Tag Info

New answers tagged

0

You can join .csv file to your shapefile attribute table by (as you wrote) matching unique identier (ID or something else) add your .csv file to project same way as a layer add your shapefile open shapefile properties (right click -> "Properties") click on "Joins" and then add join via green + button as a layer select your csv file, in join and target ...


1

Have a search in help for the subject "Performance tips for joining data" it offers advice on improving join performance. Your code does not indicate you have added an attribute index which can often improve performance.


1

If the tables are large I would suggest importing them into a file geodatabase before joining, this will enhance performance. The big gotcha with joins is making sure the joining field data types are the same between the two tables (e.g. numeric to numeric OR text to text NOT numeric to text OR text to numeric).


1

I'm not sure this is the answer that I was looking for (especially since the original model worked for another user), but I ended up getting it to run successfully with a bit of a work-around. I put everything after Add Join into a submodel and it worked perfectly.


3

I think you could achieve that goal with the "Group stats" function. A useful tutorial is posted here


1

As mentioned in the answer to QGIS 2.0 text delimited layer importing data as single row: The Add delimited text layer plugin does not use the .csvt file. The .csvt file is only interpreted by OGR - that means when you load the .csv using Add vector layer. You will find some hints on Mac-specific problems with delimited text too. Apart from that, ...


0

You might want to see this post: Join non-spatial CSV to spatial data in QGIS And here is a video demo on how to join CSV data to Shapefiles in QGIS: https://www.youtube.com/watch?v=82aRDdJdhI0


0

Great answer Geog. Some experimentation with this reveals that if you revise the excel file and re-open your .mxd your revision will be reflected in the worksheet you added as a data source but will not be reflected in the table to which it was joined. In other words the connection to excel is dynamic for the linked table but not when the linked table is ...


3

It is good practice never do any operations on shape's structure outside of a GIS environment. If you're are using Quantum GIS I strongly recommend to add the DBF table to qgis, and then use "join function" with,for example, "left join". So I advise you to take a look at Qgis documentation and tutorials like this.


1

The GRASS v.distance function can be used for this. In QGIS you can access the function through the GRASS plugin (the Processing version is currently not working). A light-weight alternative (for small datasets) is the NNJoin plugin.



Top 50 recent answers are included