<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16640" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2>Antonio,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2>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)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN><SPAN class=843373304-26052008><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2>SELECT * FROM spatial_ref_sys where auth_name =
'EPSG'</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2>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
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2>auth_srid </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2>field.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843373304-26052008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>António Pestana<BR><B>Sent:</B> Sunday, May 25, 2008 7:00 PM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] SRID
and EPSG<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Thanks</DIV></BODY></HTML>