6

Is there something out there for QGIS that is similar to the Append Tool in ArcMap?

Reason I am looking: I am currently working on a storm drainage project that involves GPSing Storm drain lids. My issue is when I capture the points with the GPS unit, and then bring them into the office. The GPS unit produces a CSV file for me to import into QGIS. It gives the CSV file with generic header names ( field1, field2, field3..etc) This is fine, until I try to copy it into the working shapefile that has all the other storm drains. The beautiful thing with Arcmap's append tool was that I could map each field from my csv file to the destination shape file...ex... "field1" from csv is equal to "Elevation" field in my shapefile. And thus update my shapefile with the newest points.

  • Could you add one line from your CSV file into your question as an example? – user30184 Jan 20 '15 at 22:17
  • 1
    You could modify or replace the header of your CSV file to match the schema of the shapefile. This can be done in Excel or a simple text editor like Note Pad. – Brent Edwards Apr 17 '15 at 17:20
1

You need to keep the same column names so QGIs can find the related columns. To do that, if you already imported your data, you can use refactor tool from the QGIS geoalgorithms in the processing toolbox (Vector table tool).

Easier : if you can, just create a new first line for your incoming CSV, like @Brent Edwards suggested. Copy/paste the new names within the CSV opened with a Notepad ++ for example : instead of "field1,field2,field3" for the first line paste "x,y,z" for example.

Load it into QGIS. You will then have a replica of your existing shape with the new data.

Now, just try to save the new data by pointing to your existing data. QGIS will ask you if you want to overwrite or to append the existing file (save a backup version in case before doing that) :

Append

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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