2

I imported precinct data from the Harvard Dataverse into Postgres 9.3 using the PostGIS Shapefile Import/Export Manager.

It creates a geom column with a SRID of 0. I think the data is projected as SRID 4326 as I was able to view a map of it using TileMill when I chose WGS 84. However, QGis says it is EPSG:4019 so maybe that is the problem.

How can I import it with this SRID? When I try to change the SRID it fails.

SELECT UpdateGeometrySRID('public', 'precinct', 'geom', 4326);
ERROR:  Geometry has Z dimension but column does not
4
  • 1
    The error message may be trying to say that you're using a 2D (latitude-longitude) CRS but the data is 3D. Try using 4979 instead. This states that the Z values are ellipsoidal heights which is probably not true though. – mkennedy Feb 4 '20 at 0:07
  • 1
    for what's it's worth ... I downloaded a sample of your file. it appears to have .prj file with a projection. and it seems to be ESRI:102749 . But it's not the same for each shapefile, so check the .prj file and google it. – Maximilien jaffrès Feb 4 '20 at 14:40
  • Looking at the projections is a great tip. They are using different projections on the state level. – Aaron Kreider Feb 17 '20 at 21:02
  • Convert prj to ESPG. In most cases is this the same as the SRID? prj2epsg.org/search – Aaron Kreider Feb 17 '20 at 21:12
0

Either you cannot set a SRID for a geometry column that has multiple projections or you cannot do this if the projections are incompatible.

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.