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

learn more… | top users | synonyms (1)

1
vote
1answer
31 views

Arcpy Freezing on Field Calculation

I am trying to populate a grid with the number of features in each grid cell. I've gotten this script to work with a subset of the data, but when I try to run it on the full (52,000+) cell feature ...
3
votes
0answers
44 views

How to access attributes from linked tables (QGIS 2.14.2 Essen)

I have one source shape file like this: It consist the geographical coordinates of weather stations: And several attribute files, wich contain the Temperature data of each date for several years ...
0
votes
0answers
25 views

Using a join in Arc with feature classes containing a definition query always return an inner join

At Arc 10.4, I am attempting to do an outer join (using the "Keep all records" option) between two file geodatabase feature class layer tables. Each of the two tables has an identical Definition ...
3
votes
1answer
28 views

Joined table fields don't work in print composer?

I am trying to use the attributes of the current atlas feature, which is from a joined table. In the expression builder it shows the correct value, but the result is blank when I actually try to ...
0
votes
1answer
37 views

after to make join between 2 tables a field is not recognize [closed]

I made join between two attribute tables with a common field and then I tried to use python to read a field and now field is not recognized on the new table.. Is it normal? How can I solve this ...
3
votes
3answers
71 views

Joining Excel File to ArcMap

I'm trying to join an excel file to ArcMap. The information in the excel file is clean and doesn't contain any characters that might hinder the joining process. However, when I join the file, all of ...
1
vote
1answer
20 views

Search and Update Cursor Automation: Avoid <Null> Values and Recognize Data Values

I am attempting to Search Cursor through a joined table. (I do not have access to the original separated tables) If the value of "COMPANY" and "DATE_" are then they will be skipped and it is ...
1
vote
1answer
59 views

Postgis spatial join performance (point on area)

I need to update a single attribute of a large table of point data with a result of a spatial join (point on area operation) on a polygon table. I'm using the below query but wondering if this is the ...
1
vote
1answer
16 views

Processing “Join by attribute” issue

I don't know what's going wrong when I try to join a shape file with an xls or csv. I do have the same identifier in both files. The joined file has all the expected columns but they are all empty. ...
1
vote
1answer
26 views

How do I combine missing data in one table with another?

I have two tables. I need to join data from table A to table B. Both tables have the same field names and same set of data, except Table A has quite a few rows of data that table B does not have. The ...
2
votes
0answers
41 views

Unable to add feature class based on database view in ArcMap

To solve Rendering features based on relationships using ArcGIS for Server?, we created a view in the database that joins the two tables together. That works fine. I see the feature class in ...
1
vote
2answers
41 views

How can I display my Excel file in Arcmap 10.4?

I am currently working on a project. I have created an excel spreadsheet: So, I need to attach the spreadsheet into ArcMap 10.4 and show the states population percentage. I have already created a ...
1
vote
1answer
56 views

Why does joining all layers in a group not work?

I am attempting to re-join all layers within a group to another layer ("Main.shp") outside of this group. The idea is for users to change values in one of the group's layers. As these layers are ...
4
votes
0answers
51 views

Using one to many join to *.xlsx in ArcGIS Desktop?

I'm working with ArcMap 10 and have some trouble joining a shapefile and a .xlsx file. The .xlsx contains sensor data (CO2, NO2 etc.) without location information. The shapefile contains all the ...
0
votes
1answer
25 views

Identifying the closest polygon to a point dataset

I have two large data sets one point and one polygon. What I was looking to do was identify which polygon is closest to each point. Hopefully I was looking for a automated process as the point data ...
0
votes
0answers
37 views

Updating attribute data based on another layer and key field?

I currently have two polygon layers (one building layer and one property layer). The information for the property layer is updated and supplied by an external source. In the building layer, I use a ...
3
votes
1answer
33 views

Positional join with multiple overlaying geometries, each containing a different attribute

I can't find any documentation on how a spatial join in QGIS is working on the following situation: An area layer is being spatially joined with a polyline layer in order to compare attributes of ...
2
votes
1answer
40 views

QGIS Join table with shp file. Get Null Values on the join fields

If my problem is that my ID types are not the same, I need help in addressing that. I started with an excel file, I read that on a mac to I need to save that as a Windows comma Separated file. I ...
2
votes
1answer
81 views

Why do layers with different CRS overlap fine but cannot be merged by location?

Perhaps someone could clear this up for me? I have a shapfile with the CRS Selected CRS (EPSG:29902, TM65 / Irish Grid) I also have a number of XY points which take the CRS, Selected CRS (EPSG:4326, ...
3
votes
1answer
39 views

ArcGIS Add Join Not Working?

Im currently working on a ArcGIS ModelBuilder Project where I want to use "Add Join" to look through a list of species (Table 1: converted from excel -> Make query table -> Copy rows (to get index)) ...
1
vote
0answers
25 views

Joining a table with an If/Then Statement

I want to join two tables in ArcMap, but not every feature has the same common attribute in the two tables I want to join. For example, "Feature 1" is in both Table 1 and Table 2 and both tables have ...
1
vote
1answer
55 views

Calculate Field not saving on joined layer

I'm joining a table to a layer file, calculating a field in the layer and then removing the join. The code below runs with no errors, but when I check the field in the attribute table, nothing has ...
1
vote
1answer
26 views

Joining attribute data from one layer to another layer in QGIS 2.12.2-Lyon

I have a polygon vector layer that I am trying to join its attributes to a point vector layer. The problem is that the polygon layer consists of grids that are numbered 1-150 (ID) and I am trying to ...
2
votes
2answers
58 views

Output shapefile has no records after joining shapefile with table and exporting result?

I have successfully joined a .xls Excel spreadsheet to a shapefile. The join is successful (the number of remaining records seems accurate), although it takes a really long time (like 20 minutes). For ...
1
vote
0answers
18 views

CartoDB geom (coordinates) join: without exact match

Trying to join two datasets (layers) on CartoDB based on their geographical fields (in CartoDB's the_geom created field). However, the basic ST_Intersection function does not work since its tolerance ...
2
votes
1answer
45 views

Expand Street Network passing through points using QGIS?

I have a road network (red) passing through some traffic data points (green): I want to expand this network to include all of the points. I already have a bigger street network (blue) from which I ...
2
votes
2answers
72 views

ArcPy: Excel to Table Conversion and Join Management

I am trying to join an Excel table to a shapefile in ArcPy. My first step is to convert the Excel sheet to a table, but I am receiving an error: #Convert xlsx to table: import os import xlrd import ...
0
votes
0answers
31 views

Add Join issue with ModelBuilder?

I am trying to do a simple Add Join within ModelBuilder but it keeps throwing the 99999 error. What is going wrong? I have even tried to create a Table View for the table I am joining to a feature ...
1
vote
1answer
29 views

In QGIS is there a way to select one feature from a layer and only see related features from another layer

I am self taught. I have 3 layers on my map: Retailer, Producer and Processor. Each business in each of these categories has a unique identifier, their license number. I have a CSV file with a list ...
-2
votes
1answer
31 views

Simple join not working

I am joining a large excel spreadsheet to a feature class. Both have a little over 8,000 records. I have gotten this particular join to work before, unfortunately I had to redo it. This time I cannot ...
2
votes
1answer
52 views

QGIS Attribute update using excel

I am looking to update the Attribute table for a Layer in QGIS using a join. However I am not looking to ADD attributes to the table (thereby adding extra columns) rather I would like to "Update" ...
1
vote
1answer
34 views

Joined attributes not available in Feature Service

I have a joined feature class (PROPERTY) and table (OG_LEASE). When I publish this as part of a map service and feature service, attributes are only available in the map service. Map service fields: ...
1
vote
0answers
26 views

Command line join attributes by location using OGR

I have two overlapping vector files (polygons and sample) and want to do a spatial join from the command line to extract all features in polygons that intersect with sample. Essentially I want to have ...
1
vote
1answer
50 views

Joining multiple polygons inside a single polygon in QGIS

I need to somehow "join" information from two shape files: zoning - these are large polygons indicating the zoning code for a moderately large area, typically hundreds of separately owned parcels ...
1
vote
0answers
18 views

Expression Within ModelBuilder?

In ArcMap I add 2 tables, join on a field then run an attribute query to return any of the joined tables records that are not null in a particular field - all works OK. I would like to build this ...
5
votes
7answers
286 views

How to join data from excel to an attribute table in QGIS without creating duplicates

I have an attribute table with two empty fields in QGIS. I want to import an excel database to fill my empty fields in QGIS. My excel file matches the columns in my QGIS attribute table. I am ...
2
votes
1answer
91 views

How to join and display .shp lines with values in .dbf

I've got a shapefile lines with ID attribute and .dbf with values which corresponds do ID. Every value in dbf is in different record. I want to style lines and display label using these values from ...
4
votes
3answers
79 views

How to Make Two Attributes Display Simultaneously on one Shape File

I am trying to make a map that displays both an incidence rate of a type of cancer and also display at the same time a percent of the population per state that has a certain vaccination. I've added ...
2
votes
2answers
41 views

How can I handle NULL values in a color ramp? [duplicate]

I'm mapping areas in QGIS 2.12 based on average pricing, using area polygons (PostGIS) joined with a CSV data table that doesn't have values for areas that didn't have any sales. I'd like to color ...
3
votes
2answers
43 views

replace records in layer with records form another layer by id and column name QGIS

I have a two polyline layers - one with 2800 rows, the other with 150 rows. Each row has a unique id column. I need to replace the records in one column of the the 2800-row layer with the records ...
1
vote
0answers
46 views

Polygons get lost when doing Join attributes by location

I am trying to do the operation "Join attributes by location" in QGIS. I have a point layer and a few polygon layers, all of them in shapefile format. I want to sum the values of the attributes of the ...
1
vote
0answers
21 views

“undo” pivot table with ArcGIS ModelBuilder?

I have a table in a geodatabase with an ID and a text field for each day of a week. The text fields contains 0 or 1 for monday, 0 or 2 for tuesday, and so on. One ID can have multiple day entries, so ...
1
vote
1answer
21 views

QGIS Way to join based on different length keys fields?

In QGIS is there a way to join a .shp file to a table when the keys are different length (by ignoring part of one set of keys?) For example .shp file key col like this 1500000US120730002001 ...
1
vote
0answers
16 views

QGIS .shp joined to xlsx.vrt; Classify works, Rule-based does not

Very simple set up. Tiger .shp file as a layer. Has a join to an xlsx non geo attribute table as a .vrt .shp has join on MTFCC to MTFCC in xlsx.vrt. xlsx.vrt, has a string field with a brief label ...
1
vote
1answer
21 views

QGIS - Have spreadsheet with col from 0% to 100% plus null want 100 bin gradient plus one more for null

Newbie alert. Have a spreadsheet with no geo; has a col with values in there from 0% to 100%, plus several blanks/nulls. Ideally would like a 100 step (bin) gradient fill from 0 (100% black) to 100 ...
0
votes
3answers
52 views

How to add two dataframe columns of city and state names to form single city-state column for geocoding in R? [closed]

I tried to search for an answer to this, but I couldn't seem to find the right search terms, so I decided to spell it out quite explicitly. I have a data frame with separate columns for cities, ...
4
votes
2answers
152 views

One-to-many joins on a feature class to a table

I am using ArcMap 10.2.2 with an Advanced license. I have used ArcMap for other basic analyses, but am fairly new to the program and have only basic coding skills, with no SQL experience outside of ...
6
votes
1answer
189 views

Joining Google Docs table to feature class at ArcGIS Online to use in Operations Dashboard?

I am using ArcGIS operation Dashboard. I get the Data Source from excel file that i have published using google docs as a dynamically data source. I need to join the excel table to hosted feature ...
6
votes
2answers
362 views

How to join a table to a shapefile with non-matching IDs and names (similar strings)?

I'm having an annoying problem that I'm trying to find an automated solution for. The shorthand version is that I have a shapefile and a table of created data for regions within countries. The created ...
2
votes
1answer
65 views

Problems with one-to-many join ArcGIS

I need to display polygons as different colors based on a value in a separate data table that I've imported from Excel. The polygon attribute table and data table both have a field with the polygon ...