Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to merge several pipeline shapefiles using GEOMERGE but it cannot complete the function because they have different column definitions.

So I need to edit the attribute tables so that they all have the same data/layout.

For e.g one pipeline has the following columns in the attribute table: ID REF TYPE

and in another pipeline attribute table it has: Leg-No From To Length_Km

What is the best way for me to overcome this?

If it is relevant some of the shapefiles have been coverted from KML to shapefiles using GQIS.

Thanks for your time!

share|improve this question
up vote 15 down vote accepted

You can use Table Manager Plugin in QGIS to rename, delete and sort table attributes. You can try harmonize the shapefiles structure.

There is one limitation, Table manager won't be able to change attribute types. If you have an attribute that is a "text" in one shapefile and a "integer" in the other, you have to create a temporary attribute and convert the data to it.

Another alternative, for points or polylines "merge", is to use union instead of merge. the result is a shapefile with all the fields of both input shapefiles. Obviously the attributes from shape2 will be empty in the shape1 attributes, but using table attribute calculator you can solve that.

share|improve this answer
Thank-you the table manager is just the sort of thing I was looking for! – Tvradz Oct 11 '12 at 12:30
@Tvradz To reward good answers, please upvote them and accept them if they answer your question. – underdark Oct 11 '12 at 12:31

Your Answer


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.