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

learn more… | top users | synonyms

1
vote
1answer
99 views

SQL-Like Inner Join on IDs in Two Layers in QGIS

Using QGIS v2.6.0-Brighton. This question is not about editing layers geographically in anyway. It is merely trying to find data from two layers as you would in an SQL Query and append an extra ID to ...
2
votes
1answer
76 views

Spatial and Non Spatial join

I have a shapefile with a number of weed control blocks as polygons. They each have a unique block id number. I am trying to join a non spatial csv file which has multiple entries for each block over ...
1
vote
3answers
569 views

Excel (*.xls) imported into File Geodatabase is missing records?

Long time reader first time poster :D Err I am having a few issues with a join to a File GDB from xls I imported as a table to the the FGDB. The problem being records that are in the original ...
1
vote
5answers
514 views

Selectively removing whitespace from a string with SQL

I have two columns of adresses that I need to join. Column 1 has the adresses formatted as "Some Street 12 A" while column 2 has them formatted as "Some Street 12A." Ie. the last whitespace between ...
0
votes
1answer
77 views

How can I join a buffer layer to the layer it was created from?

I have two relevant layers for this problem: Real estate parcels (point data) Multiple ring buffer layer - contains multiple buffer rings around each particular real estate parcel. (0.5, 1, 1.5, ...
0
votes
0answers
9 views

add points when joining two datasets together in ArcGIS

I am trying to join an excel file with a shapefile based on a zipcode. My problem is that I have multiple persons with the same zip code, but it joins only 1 of those persons. Is it possible to ...
1
vote
1answer
25 views

add points when joining two datasets together in ArcGIS

I am trying to join an excel file with a shapefile based on a zipcode. My problem is that I have multiple persons with the same zip code, but it joins only 1 of those persons. Is it possible to ...
2
votes
1answer
94 views

Join line to multiple points

I took some ASCII files and created points with attributes. I am trying to join the line features to these but a simple join function will only take the one that is closest. Is there a way to perhaps ...
1
vote
4answers
255 views

How can I join all data of two raster datasets in ArcMap 10.2?

I have two raster datasets in ArcMap10.2. One is displaying rails and one that is displaying a 100m Buffer to both sides of it. My cellsize is 100x100m. What I want is to combine the rails AND the ...
1
vote
2answers
35 views

Making data joined from Excel independent in ArcMap? [duplicate]

I have joined some data from Excel (.csv) "text" to my attributes table of one feature class. However I can't edit it. I found out it is still connected to Excel file from where I added it, and I need ...
1
vote
1answer
55 views

How to specify imprecise join criteria in ArcGIS for Desktop?

I need to join data from an Excel Spreadsheet to a Point feature class. Namely, matching up Addresses from one piece of data to another, and then appending the rest of the data once the addresses ...
2
votes
1answer
267 views

How can I display multiple multi-attribute labels for polygons

I am using ArcGIS for Desktop 10.2. I trying to import and display project data for various regions. Each project is tied to a location and I want to display Project Type, Funding Source, and a dollar ...
2
votes
2answers
367 views

Spatial join versus classical join

What are the main differences between a spatial join and a classical database join such as an equi (inner) join?
0
votes
0answers
14 views

ArcGis Join Data CSV Problem [duplicate]

I have been trying to use ArcGis Desktop and ran into some problems while joining the data from a csv file with the shp file. I can see the attributes that have been added in the attribute table but ...
1
vote
1answer
147 views

Why can I not choose the join field I need from a csv or excel file?

I am attempting to join census data (county level) to a county base map, using the FIPS county code as the join field. I can join successfully if I do not alter the original csv file from the census ...
2
votes
2answers
3k 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 ...
1
vote
0answers
333 views

In ArcGis 10, spatial join of a hot street value to a fishnet cell is counting multiple values for same street segment

So, I am working on a fishnet, so that we can attribute multiple values to points within different cells (i.e., ranking light poles as optimum for traffic cameras based on the number of speeding ...
1
vote
1answer
48 views

Another Way to Join a New Column to a DBF if OpenOffice is Giving a “Longer Than the Number of Digits Allowed” Error?

When I need to add a data column to a DBF, I always download the shapefile, open the DBF with OpenOffice for Mac, us a VLOOKUP( ) to add my data to a new column, re-save the file as a DBF, then open ...
3
votes
1answer
41 views

Join Tool (Data Management)

I have a new table with statistics data that has been calculated with the tool: Zonal Statistics as a Table; in order to know the min, max, mean, range, std, etc, from a thickness value that was ...
1
vote
0answers
25 views

Joined field not recognized as number in QGIS 2.4 [duplicate]

I have a weird problem. I've loaded in QGIS a point shapefile and a CSV table. Then I performed a join between the 2 layers and all works fine. But then the joined columns (made of integers or real ...
1
vote
1answer
382 views

Using ModelBuilder to Iterate, Join & Export Feature Classes?

I am trying to make what I thought was a very simple batch processing tool, but I can't get the output to work properly. I would like the model to iterate through a geodatabase, join each feature ...
5
votes
1answer
51 views

Is it possible to have a 1:n join which takes the min, max, or average value?

I need to join the attributes of a shapefile with the one contained in a .dbf (or .txt) file. I currently use the "join" in the properties menu, but I have a problem. In the shapefile I have one ...
2
votes
2answers
100 views

Unable to merge CSV and CSVT with shapefile using QGIS due to “text” fields?

I know the question is all over this site, unfortunately I cannot find a solution. I have this CSV file and this CSVT file that I want to merge with this shapefile. I've tried to format the .csv using ...
19
votes
4answers
10k views

Joining non-spatial CSV file to spatial data (shapefile) using QGIS?

I have a CSV file 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 ...
1
vote
1answer
538 views

arcgis - updating joined excel file when adding a new sheet

When adding a new sheet to a joined Excel file in ArcGIS, the new sheet will not show till I exit both arcgis and excel. Is there a better way to update the connection...? edit: sorry for the delay ...
2
votes
1answer
67 views

Adding attributes to an existing shapefile [duplicate]

I have a shapefile made of buildings, each one of them characterized by some attributes. I need to add some attributes contained in a .dbf file. The two files have in common the attribute "ID", so the ...
7
votes
2answers
2k 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 ...
2
votes
1answer
75 views

Join command, desired field not available to select

I have a problem regarding ArcGIS 10.1 and any help would be greatly appreciated. I want to join a shapefile in which I stored geographical information with a CSV data file containing certain ...
2
votes
1answer
150 views

CartoDB merge tables (column join) returns import error

I have been trying to merge two tables using the column join in Carto DB. The first table is a table of US counties that contains the polygon geometry and the FIPS id code. The second table contains ...
2
votes
1answer
67 views

Joining QGIS extent table with shapefile

I used QGIS to find the extents of a list of features from a census boundaries shapefile. I used Vector - Research tools - Polygon From Layer Extent, which creates a new shapefile with a table of ...
3
votes
1answer
969 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 ...
2
votes
2answers
521 views

Join Field works in ArcMap but not in Python

I am trying to join a field of values found within a DBF to a multi-polyline shapefile. They share a common field name (filename) and the values found within each are identical. I was able to run Join ...
1
vote
1answer
143 views

ERROR 000728: Field Code does not exist in ModelBulider using iteration

The first join in the model is working, but after this the names of the fields are changing in the name of the Shape and a number . Therefore get the ERROR 000728. So I like to ask you if there is ...
0
votes
0answers
48 views

How to access data from a table that has been related?

I have a data driven page table that I am trying to associate with route line data. The object of this exercise is to print the associated data on the data driven page AS or LIKE a data driven page ...
1
vote
0answers
31 views

Time not configuring correctly?

I'm trying to match data in a textfile that contains time, value, and fips code to the cntyidfp part of a map of US counties. However, even though I am able to match the two sets of data together, ...
2
votes
1answer
504 views

MapBasic sentence to update column contained in an object table

I was looking for a MapBasic sentence to update a MapInfo table. I've got two tables and I want to update one of them (POINTS) with an attribute of another (REGIONS). I would like to update points ...
3
votes
0answers
184 views

Startup python script to re-join layers

In QGIS 2.2, there is a bug which involves using the JOINS properties on a vector layer (that is already being joined with several other vector layers) whereby the attributes are not fully loaded. ...
2
votes
1answer
124 views

Update Attribute based on spatial location

I want to spatially (Spatial Join) update few fields, not all, from another feature class. Is there any way to select and update few fields instead of all the fields from the other layer and ...
3
votes
1answer
192 views

nearest facility with pgrouting

I have a postgres table of students with lat, lon and geom, , and a table of schools with the same, and a table of roads that has been converted to nodes. I'm trying to find the driving distance to ...
4
votes
1answer
355 views

Find max and min values from a table based on two fields

I have a geodatabase table with the following fields: County_Name, State_Name, Date_Time, Customers Example Alameda, CA, 8/1/2014 12AM, 6 Alameda, CA, 8/1/2014 1AM, 1 Alameda, CA, 8/1/2014 2AM, ...
4
votes
1answer
179 views

QGIS 2.2 - possible to do a JOINS from the Action list?

I have a set of layers that need to be joined (Layer Properties > Joins) to one specific layer. The reason for this is that I will be updating and adding new layers into my project and would like a ...
1
vote
0answers
47 views

Join does not return matching records after 1001 records have been successfully joined

I'm working on a process that joins a feature layer to another feature class. The code is as follows: arcpy.MakeFeatureLayer_management ("New_FC", "newFC_layer") ...
1
vote
0answers
71 views

Categorized style hiding map

I am having an issue with the style properties of my map. I imported the US Zip Code Tabulation Area map from a government website, and in a separate excel file I have a list of people connected to ...
1
vote
3answers
676 views

Join excel attributes to shape attribute

I am wondering if there is a way to join the attributes from excel tables to shapes in Qgis. I have abbreviations in the shape and want to add the associated complete names from excel file by ...
3
votes
0answers
17 views

List Joined tables

I've a question about arcpy List* modules. I have a quite large amount of data on SDE Server. Earlier I made a list of the feature classes , and tables in the mxd-s placed there using da.Walk and ...
1
vote
0answers
132 views

Join operation does not return any matching records if the join table contains “coded value domains”

I have a point feature class and performed a join operation against a destination table with two fields containing coded value domains defined in the same file geodatabase. Another field called ...
1
vote
2answers
324 views

Changing field type of Excel attribute table for a Join

I have a string field type of shapefile already in ArcMap. I need to import an excel file in and join with the shapefile. The only problem is the field type of the shapefile is a String and the field ...
-1
votes
2answers
126 views

Adding an excel database to an existing shapefile [duplicate]

I have a spreadsheet with various feature data; I would like to add this data to an existing shapefile. I have a common column in both the shapefile and the excel data. I would like to be able to ...
5
votes
7answers
26k 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 ...
1
vote
1answer
181 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 ...