[postgis-users] How can I upload .shp files?

[Joseph Spenner]

This works for me:
Create the SQL for the insert:
$ shp2pgsql -I shape.shp <tableName>   >shapefile.sql

Then insert that sql:$ psql -d <database> -f shapefile.sql 

 If life gives you lemons, keep them-- because hey.. free lemons. "~heart~ Sticker"  fixer:  http://microflush.org/stuff/stickers/heartFix.html
      From: Rémi Cura <remi.cura at gmail.com>
 To: PostGIS Users Discussion <postgis-users at lists.osgeo.org> 
Cc: PostGIS Users <postgis-users at googlegroups.com> 
 Sent: Wednesday, August 19, 2015 11:00 AM
 Subject: Re: [postgis-users] How can I upload .shp files?
   
Other options : 
Grass gis
Gdal 
Gdal-python
Cheers
RémiLe 19 août 2015 09:51, "Elmehdi OUADOUD" <ouadoud.elmehdi at gmail.com> a écrit :



Hi 
You have 3 solutions:
1-Use QGIS specialy PostGIS Manager and import your shp files to database;2-Use PostGIS plugin PostGIS shapefile  Import/Export Manager;3-Use shp2pgsql command



Le mercredi 5 août 2015 04:50:58 UTC+2, Joao Bosco Jares a écrit :
Hi All,
I know that can sounds weird this thread. but if we are talking about a popular data base, we need to meet a way to upload .shp file to post gis using an API, batch files seems a terrible workaround. I tried Rjava but nothing, I tried GISserver, but his .war is not working. So, I don't know what I can do anymore. Any advice are very welcome.
Ps.: I'm using Java/Spring, if anyone knows a efficient solution to deal with this architecture are very welcome too.


Thanks in advance.


Cheers

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150820/d4968717/attachment.html>