[postgis-users] SRID and EPSG

Markus Schaber schabi at logix-tt.com
Mon May 26 12:04:27 PDT 2008


Hi, António,

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...

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.


Regards,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org



More information about the postgis-users mailing list