[Qgis-user] Relations table

labrinos at eled.auth.gr labrinos at eled.auth.gr
Tue Mar 3 23:21:14 PST 2020


Hi Matt,

You have to have a common column in both tables (QGIS table and  
spreadsheet). The cells in both columns of the tables must contain  
exactly the same values.
Then, open the layer in QGIS, go to properties and choose Connections.
Then go to (+) symbol and follow the instructions.

Nikos


Παραθέτοντας από Matt Boyd <mattslists at gmail.com>:

> Hi QGISers,
> I'm trying to work out how to link up a table of data with no spatial
> information to a gis layer with locations.
> Each location has more than one property, the property is in an excel
> spreadsheet.
> I want to use the location data from the GIS layer and the properties from
> the table to classify the points. Both of these datasets are maintained
> separately and I need to be able to bring them back together for analysis.
>
> I'm having trouble getting all of the results for a point in the table to
> link to the location.
>
> Any tips on this?
> Thanks



-- 
Δρ. Νίκος Λαμπρινός
Καθηγητής της Διδασκαλίας της Γεωγραφίας
Τμήμα Δημοτικής Εκπαίδευσης
Α.Π.Θ. 54124 Θεσσαλονίκη
Τηλ.: 2310 991201 / 991230
Email: labrinos at eled.auth.gr
Web Page: http://users.auth.gr/labrinos/
	  http://www.digital-earth.edu.gr/
	  https://www.auth.gr/univUnits

---------------------------------------------------------------------
Dr. Nikos Lambrinos
Professor of Geography Teaching
Director of the Sector of Science and New Technologies
President of the Hellenic digital earth Centre of Excellence
Faculty of Education
School of Primary Education
Dept. of Science and New Technologies
Aristotle University of Thessaloniki
GR-54124 Thessaloniki, Greece
Tel: +30 2310 991201
Email: labrinos at eled.auth.gr
Web Page:     http://users.auth.gr/labrinos/
	      http://www.digital-earth.edu.gr/
	      https://www.auth.gr/en/univUnits



More information about the Qgis-user mailing list