1

I am working with a PHP web application where we have a user submitting a ShapeFile.

I am able to convert that ShapeFile then to a format of geojson.

What I am wondering now is how I can best get that geojson into a PostGIS table as a geometry column?

PolyGeo
  • 65,136
  • 29
  • 109
  • 338
geo derek
  • 505
  • 1
  • 4
  • 19

1 Answers1

5

It might be easier to use shp2pgsl to directly load the shapefile into a PostGIS table, for example:

shp2pgsql -d -I shapefile.shp table | psql -U user database

If you prefer to use GeoJSON directly, there is ST_GeomFromGeoJSON, but for this (as I understand), you'll need to parse and insert individual features from the GeoJSON file. See this answer for additional details.

You can always keep the GeoJSON file on the server for transfer to the client, or export individual features from PostGIS as GeoJSON, using ST_AsGeoJSON

If going directly from shape to PostGIS doesn't fit your use case, perhaps include some additional information.

Community
  • 1
toms
  • 6,978
  • 1
  • 25
  • 30