18

I have a shapefile that has geography types.

Can I convert it with a tool like shp2pgsql or is there a postgis function to do that?

19

You can cast the geography type to geometry by appending the ::geometry

SELECT ST_Distance('LINESTRING(-122.33 47.606, 0.0 51.5)'::geometry, 'POINT(-21.96 64.15)'::geometry);
|improve this answer|||||
1

shp2pgsql has a flag to import data in a geography type column:

shp2pgsql -G ....

But you can also import your data without it, by default shp2pgsql will create a geometry type.

|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.