[postgis-users] SRID and EPSG

[patrick.vanlaake at home.nl]

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