0

How can I join an Excel sheet with shapefile (Point) and common field is station code?

In Excel one station code has multiple rows and I want to attach those values with shapefile.

3
  • Welcome to GIS SE! As a new user be sure to take the Tour. Would you be able to use the edit button beneath your question to update it with details of the software that you are using, please? At the moment you have tags for QGIS, ArcGIS for Desktop and OpenLayers so we do not know.
    – PolyGeo
    Jun 24, 2015 at 5:31
  • Joins are one-to-one, that is one point 'sees' one row in the table, as you have said your station code has multiple entries which would mean you need to join Excel-to-Shapefile or investigate a relate which can relate one-to-many. Be careful joining to Excel, it would be best to save the table into a personal geodatabase with Microsoft Access to make the fields more stable. Jun 24, 2015 at 6:19
  • Possible duplicate gis.stackexchange.com/questions/66109/…
    – Brad Nesom
    Jun 24, 2015 at 18:53

1 Answer 1

1

In QGIS you can open the Project Properties dialog and there you will find a tab called relations, where you can have a one-to-many relationship between a spatial feature and several rows.

Have a look at this blog post, it describes how to use the feature:

http://fulcrumapp.com/blog/using-relations-in-qgis/

3
  • This solution works only if the data are stored in a database (PostGis, Sqlite etc..), or am I wrong?
    – Vale
    Jun 24, 2015 at 13:04
  • @Vale: Yes, you are wrong.
    – underdark
    Jun 24, 2015 at 20:26
  • @underdark, thank you! So there is something I do wrong because I tried and it didn't work.. in the example given above they are loading a feature class from a sqlite database, not a shapefile. I tried loading a point shapefile and created the relationship in the project properties but it didn't work...
    – Vale
    Jul 15, 2015 at 7:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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