[postgis-users] Additional EPSG codes in spatial_ref_sys.sql

[Kralidis,Tom [Burlington]]

Hi,

I have a PostGIS running as per documentation.  I want to support the
additional EPSG codes as defined by the 42xxx block as well as ESRI
extensions, however they are not defined in the spatial_ref_sys table:

devgeo=# select * from spatial_ref_sys where srid=4326;
 srid | auth_name | auth_srid |
srtext
                    |                proj4text
------+-----------+-----------+-----------------------------------------
------------------------------------------------------------------------
------------
--------------------+-----------------------------------------
 4326 | EPSG      |      4326 |
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137,298
.257223563]],PRIMEM["Greenwich",0],UNIT["Degree",0.0
17453292519943295]] | +proj=longlat +ellps=WGS84 +datum=WGS84
(1 row)

devgeo=# select * from spatial_ref_sys where srid=42304;
 srid | auth_name | auth_srid | srtext | proj4text
------+-----------+-----------+--------+-----------
(0 rows)

devgeo=#

The proj file which has these is at:

http://dl1.maptools.org/dl/proj4-epsg-with-42xxx-and-esri.zip

Is there a patch to this on the postgis side?

Thanks

..Tom

=========================
Tom Kralidis
Systems Scientist
Environment Canada
Tel: +01-905-336-4409
http://www.ec.gc.ca/