[postgis-users] SRID and EPSG

Barend Kobben kobben at itc.nl
Tue May 27 01:44:31 PDT 2008


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
>> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

International Institute for Geo-Information Science and Earth Observation (ITC)
Chamber of Commerce: 410 27 560

E-mail disclaimer
The information in this e-mail, including any attachments, is intended for the addressee only. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or action in relation to the content of this information is strictly prohibited. If you have received this e-mail by mistake, please delete the message and any attachment and inform the sender by return e-mail. ITC accepts no liability for any error or omission in the message content or for damage of any kind that may arise as a result of e-mail transmission.



More information about the postgis-users mailing list