[postgis-users] add custom epsg

[Greg Allensworth]

1.
The GDAL/OGR tools use PROJ to do the reprojection, and PROJ knows about 
projections, via its "epsg" file. On Unix systems this is something 
like:  /usr/share/proj/epsg

Pop it open, and you'll see that the format is quite easy to follow. 
Paste in a new pair of lines, and that SRS is now recognized by ogr2ogr.

2.
PostGIS does not use the PROJ epsg file, but instead the spatial_ref_sys 
DB table. This lists projections available to PostGIS, and if you do a 
SELECT there you should find the rows easy to understand: srid (103782), 
authority (EPSG), the SRS in both PROJ format and WKT format, ... Simply 
insert a row here and PostGIS will support that SRS.


I hope that helps!


On 12/19/2013 9:12 AM, Andy Colson wrote:
> I know this isn't directly a postgis question, I'm kinda hoping someone
> will know anyway.
>
> I'm trying to import a File.gdb into postgis, but the projection its in
> seems to be unknown.
>
> I'm using ogr2ogr to do the conversion (and all my scripts are already
> setup to use it, so I'd rather not change to shp2pgsql), and I'm getting
> this error:
>
> ERROR 6: EPSG PCS/GCS code 103782 not found in EPSG support files.  Is
> this a valid EPSG coordinate system?
>
> The data is for Steele MN, and this does seem to be a thing:
>
> http://edndoc.esri.com/arcims/9.2/elements/pcs.htm#103782
>
> so how can I get ogr2ogr (ogrinfo, testepsg, etc) to use it?
>
> Thanks for your time,
>
> -Andy
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users


-- 
Greg Allensworth, Senior Web GIS Developer
BS  A+  Network+  Security+  Linux+  Server+
GreenInfo Network - Information and Mapping in the Public Interest
564 Market Street, Suite 510  San Francisco CA 94104
PH: 521-223-7636    email: gregor at greeninfo.org
Web: www.GreenInfo.org     www.MapsPortal.org

Subscribe to MapLines, our e-newsletter, at www.GreenInfo.org