[postgis-users] SRID and EPSG

António Pestana afsm.pestana at gmail.com
Tue May 27 03:45:50 PDT 2008


Thanks Patrick. Minor problems with the formatting of the text files, easily
solved... 

It seems to me that your work does an automatic conversion of the EPSG
database into a spatial_ref_sys view/table. Did I understand correctly? I'm
not the right guy to test with EPSG 6.15...

> -----Mensagem original-----
> De: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] Em 
> nome de patrick.vanlaake at home.nl
> Enviada: terça-feira, 27 de Maio de 2008 10:47
> Para: postgis-users at postgis.refractions.net
> Assunto: [postgis-users] SRID and EPSG
> 
> The sql scripts can be found here: 
> http://downloads.sourceforge.net/dspatial/PostgreSQL-CRS.zip. 
> Note that v6.8 was used to develop this and EPSG is now at 
> version 6.15 IIANM. Things should in all likelihood still work. 
>  
> Also note that nothing has happened in 2.5 years because no 
> interest was expressed. That means that some features are 
> still not developed, most notably writing a new WKT 
> definition to the EPSG database. Since spatial_ref_sys is a 
> view that involves writing a procedure that is triggered by 
> the view object. Not too hard, but a lot of work. I reconfirm 
> my availability to help implement it, if somebody can 
> convince me that it will indeed be useful and used. Paul 
> wasn't so hot on the idea then, where is refractions now??? 
>  
> Patrick 
>  
> -----Original Message-----
> From: Barend Köbben
> Sent: Tuesday, 27 May 2008 10:45
> To: PostGIS Users Discussion
> Cc: Patrick van Laake
> Subject: Re: [postgis-users] SRID and EPSG 
>  
> Yes, it was Patrick van Laake (who happens to work at the 
> same place as me). 
> I've copied this to him, I guess he has those view 
> definitions somewhere... 
>  
> --
> Barend Köbben
> International Institute for Geo-Information Sciences and 
> Earth Observation (ITC) PO Box 6 7500AA Enschede, The Netherlands 
> +31 (0)53 4874253
>  
>  
>  
> On 27-05-08 01:07, "Paul Ramsey" <pramsey at cleverelephant.ca> wrote: 
>  
> > If someone is interested in trolling the postgis-users back 
> catalogue, 
> > a user a couple years ago wrote a system of views that made 
> the ESPG 
> > relational structure usable as a spatial_ref_sys table.
> > 
> > P
> > 
> > On Mon, May 26, 2008 at 3:34 PM, Andy Anderson 
> <aanderson at amherst.edu> wrote: 
> >>> António Pestana <afsm.pestana at gmail.com> wrote: 
> >>> 
> >>>> What about 
> >>>> 
> http://www.epsg.org/databases/Discv6_15sql-PosgreSql.html ? Is it 
> >>>> of any use? I'm really new to PostgreSQL and PostGIS, so may be 
> >>>> this is a really dumb question...
> >> 
> >> On May 26, 2008, at 3:04 PM, Markus Schaber wrote: 
> >>> 
> >>> The EPSG database contains a rather complex relational 
> structure of 
> >>> different tables describing reference systems, projections etc.
> >>> 
> >>> This relationals tructure was originally delivered as 
> access file, 
> >>> but additional delivery formats (like PostgreSQL SQL 
> dump) have been added.
> >>> 
> >>> The PostGIS spatial_ref_sys table itsself contains a "flattened" 
> >>> view of some aspects of that relational model.
> >>> 
> >>> So the EPSG database cannot be loaded as spatial_ref_sys 
> table, but 
> >>> maybe an automatic conversion process could be developed.
> >> 
> >> 
> >> Might it be useful to implement that relational table in PostGIS, 
> >> along with functions that combine them to build a spatial 
> reference? 
> >> This might make it more usable in situations where you 
> want to build 
> >> your own (give me the WGS
> >> 84 datum, a Lambert conformal conic with such-and-such standard 
> >> parallels, and a coordinate origin at this point). Or is that just 
> >> too uncommon and complicated for most users?
> >> 
> >> The current SRID table would still exist but be built at install 
> >> time, of course.
> >> 
> >> -- Andy
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> No virus found in this incoming message.
> Checked by AVG. 
> Version: 8.0.100 / Virus Database: 269.24.1/1468 - Release 
> Date: 5/26/2008 3:23 PM
> 




More information about the postgis-users mailing list