I have been trying to figure out the reason shp2pgsql isn't working when I try to import a shapefile with SRID=102631. I've had no problems with other SRIDs. For all shapefiles in 102631, I get this error: Failed in pgui_exec(): ERROR: AddGeometryColumn() - invalid SRID

Here is a link to one file, for example, that won't import.



SRID:102631 is an Esri well-known ID given to NAD 1983 State Plane Alaska Zone 1 (US survey feet). This definition isn't in the EPSG Geodetic Parameter Registry.

You might be able to munge the prj file's WKT into something that PostGIS will support. One way would be to find an existing WKT/definition for the same zone but using meters for the unit of measure. The WKID (SRID) would be 26931. My assumption is that the projection method name and/or the parameter names aren't being understood.

Disclosure: I work for Esri and I'm on the subcommittee that manages the EPSG Registry.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.