[postgis-users] SRID and EPSG

[Paragon Corporation]

Antonio,
 
I think all the spatial references used are EPSG in the spatial_ref_sys
table.  There used to be a time when ESRI codes were used, but I don't see
those in the newer spatial_ref_sys tables.
 
Anyrate the standard query to pull up all EPSG codes supported would be the
below (it applies for any OGC compliant DB with slight variation)
 
SELECT * FROM spatial_ref_sys where auth_name = 'EPSG'
 
I think pretty much for all cases as far as Postgis is concerned the EPSG
auth_srid matches the SRID.  This is not the case for all spatial database
providers.  In cases where the authority name's SRID is different from
PostGIS, that SRID would be stored in the 
 
auth_srid 
 
field.
 
 
Hope that helps,
Regina

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of António
Pestana
Sent: Sunday, May 25, 2008 7:00 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] SRID and EPSG


What version of EPSG-codes are used by PostGIS? I have just downloaded and
installed PostgreSQL (MS Windows) and I couldn't find anything about this
subject in the documentation.
 
Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080526/ee8baf67/attachment.html>