How to import gis shapefiles into postgis database programatically?

Question

How can I import gis shapefiles into postgis database programatically using java ? I used a program named postgis shapefile import but now I want to do it in my java code.

osm2pgsql is a command line tool for that, maybe doing a batch execution of this via bash is an option for you? — grasshopper
– grasshopper, Commented Mar 18, 2014 at 15:55

Mike T · Accepted Answer · 2014-03-18 23:23:23Z

2

The most common tool (one of several) is shp2pgsql, which comes with PostGIS. It is normally used from a command prompt, but can be used through Java's ProcessBuilder.

ProcessBuilder pb =
   new ProcessBuilder("/bin/sh", "-c", "shp2pgsql my.shp | psql -d mydb");
Process p = pb.start();

ogr2ogr is another commonly used tool to convert most geospatial vector formats to PostGIS.

answered Mar 18, 2014 at 23:23

Mike T

44.3k18 gold badges166 silver badges213 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Obtice Over a year ago

thanks for your answer, shp2pgsql has many options when we work with its gui. How can I pass this parameters in command? I searched all available parameters but I can't find any of them inside those parameters.

Mike T Over a year ago

@Obtice the gui does the same as the command, which is well documented

Obtice Over a year ago

thanks a lot, could you please explain what "/bin/sh" and "-c" is ?

Mike T Over a year ago

It depends on what OS you have. If you have Linux or Mac OS X, this process the command that has a pipe | character with /bin/sh (i.e., see man sh). But if you have a different OS, you will need to set up the ProcessBuilder differently.

Collectives™ on Stack Overflow

How to import gis shapefiles into postgis database programatically?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related