The process of connecting two or more datasets based on a common attribute or spatial location.

learn more… | top users | synonyms

7
votes
5answers
7k views

How to join multiple records to single feature?

apologies for what I'm guessing is a really easy problem to solve. GIS user, not programmer here. I'm trying to create a join/relate in QGIS where I have a shapefile of buildings and to that I would ...
2
votes
1answer
276 views

How to join averaged precipitation values to each municipality

I have precipitation data that I would like to average over each municipal unit in a boundary layer. First, how do I average the rainfall spatially by each administrative unit? Second, the rainfall ...
3
votes
1answer
681 views

Help with joining a large dbf file to shape file

My overall objective is to create a timeline animation depicting when a person is working in a particular region. The .dbf table consists of over 6000 record entries of shift data, including date ...
5
votes
2answers
909 views

Creating polygons from a one to many relationship of points

I have a set of polygons that are in a one to many relationship with points. The polygons are administrative boundaries and the points have information on companies and percentage of ownership . I ...
5
votes
2answers
4k views

Trouble creating a query table

I need to join one feature class and one table. This is a one to multiple join, therefore, my only option seems to be by creating a query table. My problem is that the fields I want to join do not ...
15
votes
4answers
7k views

Join non-spatial CSV to spatial data in QGIS

I have a csv which has postcode data in a field, but it is non-spatial e.g. no Easting and Northing. I have a shapefile with postcode in a field and some additional data. I want to join the csv with ...
4
votes
2answers
3k views

One-To-Many Table Relate Viewed Through ArcGIS Server

I want to create a Table Relate with a one-to-many relationship between a layer and a non-spatial table based on a common field. My question is, if I publish this data to ArcGIS Server, will an ...
5
votes
3answers
892 views

SDE views not showing values in joined table

I created an SDE view between a point feature class and a table (stored in SDE) - the join is done on a text field called RFRNC. I changed the view so that it is now a LEFT OUTER JOIN in line with ...
2
votes
2answers
458 views

Join Issue with Attributes Table

I am trying to Join a Mineral Database (excel) into my Attributes table. Once I do and check the Attributes, it shows up as "NULL". What is causing that, what am I not doing? Can anyone offer ...