[postgis-users] SRID and EPSG

[António Pestana]

Thank you Regina.
 
May I infer that PostGIS does not keep the spatial_ref_sys table up-to-date
with the most recent version of the EPSG Geodetic Parameter Dataset (the
current version is v 6.15)?
________________________________

De: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] Em nome de Paragon
Corporation
Enviada: segunda-feira, 26 de Maio de 2008 5:43
Para: 'PostGIS Users Discussion'
Assunto: RE: [postgis-users] SRID and EPSG



	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

	No virus found in this incoming message.
	Checked by AVG.
	Version: 8.0.100 / Virus Database: 269.24.1/1466 - Release Date:
5/25/2008 6:49 PM