Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

How do I put many shape files into 1 table?

The PostGIS plug-in shape file uploader makes one seperate table each time it uploads a shape file.

share|improve this question
2  
You can fix that after the fact: gis.stackexchange.com/questions/27402/… –  lynxlynxlynx Jun 13 '12 at 22:29

3 Answers 3

There's a tool called pgShapeLoader, which allows you to specify the table to which you want the shape loaded. I downloaded OpenGeo 2.0.1, and it came with it. I'm not sure if you can get it anywhere else, but if you can lay your hands on OpenGeo Suite, the tool is bundled in it.

Have a look at this link: http://workshops.opengeo.org/postgis-intro/loading_data.html. It shows a screenshot of the tool. And, if you can follow the workshop tutorials, you'll probably get a link somewhere to download it.

You can also use Quantum GIS' SPIT tool (accessible via Database - Spit menu). After adding a shape file to load into PostGIS, you have an option to specify DB Relation Name, which can be the same as what you had used before. Of course with the assumption that you are using PostGIS.

share|improve this answer

This may be a newer feature, but you can change from the default behavior of create to append.

In the shapefile uploader dialog change the table name to your existing one then just click on "Create" and a dropdown should appear with the available options.

enter image description here

share|improve this answer

you can achive this with some batch scripting:

for %i in (*.shp) do 
shp2pgsql -W Latin5 -s 4326 -I -S -D %i %~.shp myTableName | psql
          -U postgres -h localhost -d myDatabase

i hope it helps you...

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.