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

learn more… | top users | synonyms

0
votes
1answer
201 views

Why aren't my hyperlinks saving in ArcGIS 10.2

I have a polygon layer and I have a joined table with a link to an excel document for each polygon. Under the "Display" tab in layer properties I check the "Support Hyperlinks using field:" box and ...
1
vote
1answer
506 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
0answers
26 views

Unable to add feature class based on database view in ArcMap

To solve this problem (earlier question), we created a view in the database that joins the two tables together. That works fine. I see the feature class in ArcCatalog and can view the features in the ...
1
vote
1answer
47 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
50 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
1answer
6k views

Merge attribute of points into a polygon : Arcmap 10

I have points layer which the attribute looks like this: FID Shape ID Lat Long 0 Point 2065 -5.51666 106.48333 1 Point 2319 21.93333 120.73366 I also have polygons layer : FID Shape ...
0
votes
0answers
33 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
36 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
4answers
2k views

Joining shapefile table with csv

So I am having a shapefile with all the world countries. And the table for this shapefile has a column named "Country Name". Each of this entry is unique, meaning, each country takes only 1 row, and ...
2
votes
2answers
45 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
1answer
245 views

Join traffic data (point) to a road network (line) - Section between two roads - ArcGIS

I am trying to analyze the vehicle traffic in Melbourne's (AUS) road network. I have two files: the traffic data (point data for a given latitude and longitude with the average hourly traffic between ...
3
votes
1answer
149 views

How to use QGIS Graphical Modeller to join specific fields?

I wish to join one field from a shapefile to another shapefile within the QGIS graphical modeler. I am aware that there is a 'Join attributes table' algorithm but this joins all of the fields from the ...
1
vote
0answers
17 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 ...
1
vote
1answer
73 views

arcpy join csv files to raster attribute table

In arcpy, I'm trying to join an list of .csv files with data of emissions per country, with the attribute table of a raster in order to make lookup tables later on. So far this is my script: ...
5
votes
7answers
261 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 ...
0
votes
0answers
26 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 ...
0
votes
0answers
52 views

Multiple join of Access data with ArcGIS shapefile

I am looking for a solution for joining constantly modificated data to my shapefile. The shapefile consists of polygons. Each one has a code. In the Access database, I have varias colums for one code ...
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 ...
18
votes
4answers
8k views

Joining 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
1answer
244 views

Startup python script to re-join layers in QGIS?

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
46 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
0answers
1k views

arcpy spatial join input parameter problems [closed]

Using ArcGIS 10 SP4 with all extensions... I have a parent directory (J:\...\spatialjoin) containing two sub-directories of feature classes I want to spatially join. Directory 1 (target features) ...
1
vote
1answer
246 views

Can Virtual Fields be used for a rendering style?

In QGIS 2.6, creating a virtual field for a layer and adding up 2 integer fields work fine. I get the correct results and I can use that field for styling. However, when doing a Joins with 2 layers ...
1
vote
1answer
30 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: ...
2
votes
3answers
310 views

QGIS joins 2 FIELDS

I have an excel with 4 columns (Region; District; village; number of cases) Have a shapefile with dots for villages with many columns including (Region ; District ;Village) I want to plot the cases ...
2
votes
1answer
2k views

After performing a table join, all the fields are “NULL”

Within QGIS, I joined .dbf table containing population data to a shapefile of Census tracts. The join field is called GISJOIN in both the target table and the shapefile's table, and this attribute ...
1
vote
0answers
17 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 ...
4
votes
3answers
77 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
5answers
216 views

Create Statewide Hydrologic Soil Group Map

This may be better for Engineering? Not sure. Background: Previously I have downloaded SSURGO soil data for the state of Pennsylvania by downloading each county and merging the shapefiles. I then ...
2
votes
2answers
38 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 ...
6
votes
2answers
731 views

How to symbolize features with NULL values in graduated symbology?

I have a polygon feature dataset, and an attribute from a different table that I join (one-to-one) within QGIS in order to symbolise the attributes as a choropleth map. However, not all polygon fields ...
1
vote
0answers
28 views

How to avoid field duplication when joining two vector layers?

I have 2 point vector layers wich differ in 2 fields while both of them have the same number of fields (10). What I want to do is produce a new point vector layer with 12 fields. When I join the two ...
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 ...
3
votes
1answer
824 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 ...
1
vote
0answers
43 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 ...
10
votes
5answers
14k 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 ...
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 - 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 ...
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
15 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 ...
0
votes
3answers
47 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, ...
1
vote
1answer
1k views

Linking SharePoint database with ArcGIS?

The organization I am working for has a sharepoint database that multiple people update every time they do an inspection of natural resources on a parcel in the county. This database has the ...
4
votes
2answers
125 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
167 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 ...
2
votes
3answers
1k 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?
6
votes
2answers
286 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
62 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 ...
5
votes
1answer
252 views

Reading an Existing Join

Confused again. I was finally able to run ArcCatalog and create a join in my map document (I will do the deed programmatically eventually) but I was interested in how a join looked once it was ...
4
votes
2answers
1k 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 ...