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

learn more… | top users | synonyms

3
votes
2answers
3k views

ArcGIS - Create a join based on multiple fields

I have two feature classes in a File Geodatabase that I would like to join based on multiple fields. I've searched this site and Google and all I have come up with was to use the Make Query Table ...
1
vote
1answer
64 views

Join of two attribute tables with different amounts of rows

I have a hard time sorting the following out: I have two different Shapefiles. The attributetable of one, lets call it shapefile A looks the following: SHAPEFILE A ATTRIBUTETABLE Name Type ...
4
votes
1answer
140 views

QGIS 2.0.1 linking table issue, MSSQL 2008 database

I'm trying to link tables in QGIS 2.0.1 and MSSQL 2008 database. I can link them but when I try to open the attribute table QGIS throws an error and shuts down creating a *.dmp file. I saw that ...
0
votes
1answer
23 views

Join leads to null value outside of edit session

I am using Arcmap 10.2 on Windows 7 I joined a shapefile with an Excel file, and the attributes are shown as until I start an edit session. Then, the values are as they should be. They match up by ...
0
votes
1answer
28 views

Is exporting to feature class the simplest way to make joins permanent?

I am a new user doing simple tasks with ArcMap 10.1 I have a shapefile and an excel file, and I want the join to be a permanent part of the shapefile. The way I've been going about this is to export ...
0
votes
1answer
38 views

How can I get a join for pre-existing fields?

I am joining some values from a table to a shapefile. The table and shapefile have the same column names and types, but when I join, Arcmap creates a new field, and I just want the join to write the ...
2
votes
0answers
65 views

How to join two fields after calculating?

I have been working with two layers and I am trying to join them and turn them into a raster data. The first layer is a watershed layer which I have assigned each shed a location from the center point ...
1
vote
1answer
44 views

How to join two tables and convert joined table to a vector layer containing points in QGIS? [duplicate]

I have one table that contains 450 locations and a table that has 10'000 rows containing data and no spatial information. I have a column that allows me to join them. The issue is that I want to have ...
0
votes
1answer
164 views

Join and Calculate vb.net

Im trying to join an excel table to a shapefile and then calculating those fields using vb.net. The code I have written has no errors, but won't work when I try it in ArcGIS 10.1 and I'm out of ideas. ...
2
votes
2answers
1k views

Creating non-spatial Many to One Joins/Relationships between tables

I may have missed a trick here but I can't seem to find a solution. I have a table of ~1.6 million postcodes, also containing co-ordinates, and a separate file detailing ~6000 a population with ...
0
votes
1answer
34 views

Error using 'Join attributes by location' via Python

Trying to run a simple script using qgis:joinbylocation but getting either errors or it's not processing correctly. I don't want to take a summary of the attributes, just the attributes of the first ...
0
votes
1answer
46 views

postgis, st_within, and a join

So I'm in the middle of learning postgis/postgres. I've a polygon table. I've a point table. The polygon layer contains a foreign key that points to another table. For the example the Foreign key ...
3
votes
8answers
17k views

Having problems with joining an excel table to a shapefile in ArcMap

I have a shapefile of lower layer super output areas (LSOA) for England and Wales and I have a spreadsheet of the indices of deprivation for each of the LSOA's in England. I want to join the ...
0
votes
0answers
15 views

how to join 1second GPS data with dGPS using much shorter time interval?

for one of our measurements we rented a dGPS with a portable "rover". I have now our measurements from our device which also contain data from built-in GPS (1 second sampling rate) + also the dGPS ...
0
votes
0answers
33 views

How can I correctly delete a join from featurelayer using arcobjects?

If I create a join using ArcMap dialog definition query can be changed if joined layer contains a definition query. For example, layer A has definition query "A", layer B has definition query "B", ...
1
vote
1answer
85 views

Creating a Simple Join Script in Python

I'm trying to create a simple join script in python from an arcgis model, where the only steps are joining a map to a table to produce a map with the table's properties. The attributes joined ...
0
votes
0answers
22 views

Broken links after joining an .accdb with a .csv in ArcGIS 10.1

I have two sets of data: A "master" file of coordinates that has one row for each location, saved as a .csv file A table with information for each location but no coordinates, saved in an Access ...
0
votes
1answer
30 views

Joining Textfile to Shapefile Arc 10 and 10.2 Differences

I am trying to join a textfile generated in stata that includes caoname, caoid, and fips. The fips code should match to a shapefile county map that matches to the cntyidfp category. In ArcGIS 10.0, ...
4
votes
1answer
77 views

Most efficient method to join multiple fields in ArcGIS

I have as set of shapefiles with approximately 300000 polygons each, as well as corresponding point shapefiles and tables with approximately the same number of row (equal or less rows than the ...
0
votes
2answers
39 views

Joining Tigerline Census Data 2010 and American FactFinder xls

I have a shapefile from TIGERLine data from the Census website, as well as a spreadsheet from the American FactFinder. I've edited the excel sheet to a 97-2003 workbook, and am now able to bring it ...
7
votes
4answers
2k views

How to close multipart polyline gaps in ArcMap

I have a multiple multipart contour lines that originally came from CAD drawing. I converted these into a polyline shapefile in ArcGIS. The issue I have is with gap in each contour lines that are ...
0
votes
0answers
21 views

Join Standalone Tables from ArcGIS Server in Javascript API

I am trying to find a way to execute the equivalent of the following query with the ArcGIS JavaScript API (I made field and table names generic): SELECT a.field1, a.field2 FROM table1 a, table2 b ...
0
votes
1answer
29 views

how to create a cloropleth world map in arcgis 10.2

I am new to arcgis and I am trying to create a cloropleth map to display ratio values for different countries. I believe that my basemap will need to have a country layer so that the shading of ...
0
votes
1answer
38 views

Join by attribute when unique identifier has multiple rows using ArcMap 10.2?

I would like to join the attributes of one polygon layer to another polygon layer by their common ID. The problem is that in layer A, each ID has multiple rows, because each represent shapes from the ...
3
votes
2answers
145 views

Join a CSV file to shapefile using gdal/ogr?

I have a shapefile with several attributes, for example YEAR, COUNTY, and AREA. I also have a CSV file with more fields that I want in the shapefile, such as POPULATION. Both the shapefile and the CSV ...
1
vote
0answers
27 views

Create a non spatial index on an attribute in QGIS before joining two layers

I’m using QGIS 2.0.1 on Windows 7. I’m trying to join a .dbf which contains no spatial data to a shape file containing spatial data. Ideally I’d like to create an attribute index on the join field in ...
0
votes
1answer
56 views

Can anybody help me with Spatial Join in ArcGIS 10?

I have a doubt, I do not find what's happening. Screenshot: Using the Join (Join data from another layer based on spatial location) I have done an Spatial Join by location, and it is said that the ...
0
votes
2answers
50 views

Joining two polygon layers based on distance?

I'm new to GIS so this question may be an obvious one. I have one polygon layer of urban land use and another polygon layer of swamps. How do I join the two layers so that I get a column in the ...
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 ...
1
vote
1answer
58 views

Modelbuilder - Join - Keep matching records only - export to feature class

I need to join a table to a feature class in a model. Have it keep only the matching records and then export that joined feature class into a new feature class.
0
votes
1answer
73 views

query / filter on attribute tables with external tables joined

i tried to do some queries on joiend table fields ... i've got/found some answers concerning version 1.8 - which result in "use select + export to create a combined dataset" so i just did some tests ...
0
votes
0answers
52 views

Batch join non-spatial csv to shape files

I have 173 point shape files from soil testing and 173 non spatial csv files with lab ressults (one csv for each shape file) that need joining. The files are located in a library with folders named ...
1
vote
1answer
40 views

Problem with QGIS 2.2 joins between shp and csv

Didn't see question like this asked, so... I've joined csv to shp file and everythings seems ok. I've modified attribute form so that fields from joined csv appears in there. So far so good- it's ...
3
votes
1answer
93 views

Field calculator uses wrong fields when working with joined data

I am having an issue in qgis table joins. i have a joined a csv file to a sqlite database and common id is used for join. the join is displays correctly in attribute table. the attributes in sqlite ...
0
votes
1answer
43 views

Creating a New Shapefile from Joined Access Table

I'm dealing with a very large amount of polygons. Once I join the land use access table to the parcel shapefile, it takes forever for Arc to draw the polygons. I'm trying to select all residential ...
0
votes
0answers
58 views

In ArcGIS, how to automatically recalculate a calculation if I modify the Excel data source?

There's a database with buildings. Each of them has a few parameters, for example building type codes. In a distinct table each building type codes has 4 attributes. During the Join, the datas will ...
3
votes
4answers
135 views

How to assign geometry to records in a table that contain an ID of a geometry point?

We are looking to map out 'incidents' at schools, but the incident table, which contains a few thousand records, only has a school number (plus the incident data). The table format is an Excel ...
3
votes
1answer
50 views

Coloring of features in ArcMap 10.1 changes randomly while zooming

I am using the sovereign states shapefile (ne_110m_admin_0_countries.zip) from http://www.naturalearthdata.com/ and joined the attributes with a spreadsheet file that codes many (but not all) country ...
0
votes
1answer
42 views

Trouble joining table in arcgis. Joining field is 'greyed out'

I'm trying to join a shape file with a excel file I converted into a CSV. I had done this before with the same shape file but with a different CSV but this time when I try to select the column it's ...
6
votes
1answer
1k views

Join attributes of point and line layer by location (closest distance) in QGIS

My problem is the following: i have a line shp (target layer) and a point shp (join layer). the second one (point layer) holds an attribute which i want to join with a line layer based on closest ...
0
votes
0answers
58 views

How to create a many to one spatial join?

I have a polygon feature class of territories and a point feature class of trees. The points have many attributes, one of them is the tree species name. I need to get the list of all the tree species ...
0
votes
1answer
76 views

Python field calc syntax error

The screenshot shows a calculate field tool in modelbuilder. The error I'm getting is invalid syntax line 1. I can't see any issues w/the syntax so I'm hoping someone out there can help. It ...
12
votes
3answers
4k views

How to join attributes from nearest point in QGIS?

I have two layers with points, call them A and B, each with different attributes. For each point in A I want to join all the attributes from the nearest point in B. Ideally this would also include ...
3
votes
0answers
88 views

tablejoin in qgis 2.x adds name of table to columnheader attributetable [duplicate]

When joining a table to a shapefile through 'layer properties > joins' the columnheader of the attributetable shows the name of the file you joined. eg.: the name of the table is: STAVAZA3 the table ...
2
votes
1answer
512 views

Joining table to shapefile with pyQGIS

Joining shapefiles is a relatively straightforward proess in QGIS using 'add vector join' in the layer properties menu. I can add a csv file as a vector layer, as well as a shapefile, and join the two ...
1
vote
1answer
60 views

When I join a table to a shapefile and then export it the titles of the columns are transformed to data1, data2

I'm using QGIS 2.0.1 The table is in an excel format that i import through "add vector" and the shapefile is a polygone I join the attributes by right clicking the polygone-->properties-->join Then ...
0
votes
1answer
198 views

Problem with MMQGIS in QGIS V. 2.0.1 - Attribute Join from CSV File

I've been trying to use the Attribute Join from CSV File function in MMQGIS, but it does not seem to work in Version 2.0.1. I've tried to join the same CSV and Shape files using V.2.0.1 running under ...
4
votes
2answers
247 views

Spatial join - many to one

I'm trying to do a spatial join that takes the attributes of multiple polygons and applies them to a single polygon in another layer. The data is currently in a geodatabase, but can be exported to shp ...
1
vote
0answers
43 views

How to create a 1:n join and concatenate text attributes?

I have 2 polygon layers A and B. I would like to join the attributes from B into A for all the polygons from B that intersect A and for text attributes, i would like them concatenate. But apparently ...
1
vote
4answers
3k views

Merging multiple .tab files?

I was wondering if there was a quick way to merge multiple .tab files together? I have about 100. Would appending one tab to another with the MapBasic window open, then changing the name of the table ...