merge shapefile using ogr2ogr and retrieve the attribute of both

Question

Ciao,

I have two shape files that i want merge (overlay/intersec) having in the destination the attributes of the the two sources file.

ogr2ogr file_merged.shp tl_2010_us_uac10_conus_albersUA.shp ogr2ogr -update -append file_merged.shp tabblock2010_10_pophu.shp -nln file_merged

In this way i obtain the polygons of the two shapes but i lose the attributes of the tabblock2010_10_pophu.shp.

My final aim is then make an sql statement where i can retrieve polygon in common in the both shapes.

Any suggestions??

Thanks in advance

sql query? You're using some kind of a database? You can easly do that kind of spatial queries using postgis
Thanks menjaraz, i will test it. Actually i think should be possible with ogr2ogr by using sql statement. I tried several combination but not i did not succeed. Let's see if somebody else reply. Ciao Giuseppe

toni · Answer 1 · 2012-09-29 08:35:58Z

i wrote some downloadable code for that. A simple python program for combine shapefiles in many ways: http://furiousgis.blogspot.it/2012/05/python-shapefile-merger-utility.html

By default performs the dbf schemes union and it adds an attribute filled with the source shapefile name, so you can recognize records.

This is the commandline for your needs:

python shapemerger.py -o file_merged.shp tl_2010_us_uac10_conus_albersUA.shp tabblock2010_10_pophu.shp

(you have to run it in a python environment with available ogr/gdal packages. I wrote some note about this above the code)

1 Answer