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

learn more… | top users | synonyms

1
vote
1answer
21 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
713 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
39 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 ...
9
votes
5answers
13k 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
17 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
20 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
20 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
13 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
34 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 ...
-2
votes
0answers
25 views

How to make an one to many join and duplicate the polygons where are more than one join

I have one polygon shapefile which represent the properties of some people, and one table in csv format in which there is the name of people and the properties that they own. I want to do a one to ...
4
votes
2answers
80 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
115 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
863 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?
1
vote
1answer
188 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 ...
5
votes
2answers
86 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 ...
1
vote
1answer
461 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
1answer
46 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
249 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 ...
0
votes
0answers
15 views

One to Many link that can be queried

I'm at my wits end, having looked through a number of posts and tried several options. At this point I'm just looking for confirmation that I cannot do what I am trying to do without ArcGIS or using a ...
3
votes
0answers
18 views

Listing Joined tables in MXD using Python? [duplicate]

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

Join field in modelbuilder wont work, but will manually

I'm trying to do a 'join field' in a model. When I do the join simply not in a model, no problem. When I try to use the 'join field tool' in a model, I get the "" does not have OIDs. I have a very ...
0
votes
1answer
38 views

How do you filter a layer on a joined table in QGIS?

I am attempting to do a join in QGIS between a SQL Server Spatial table and a non-spatial table (on a single integer field). I was able to add both successfully and make the join, but the query ...
4
votes
1answer
55 views

How to automate joining SQL Server non-spatial database tables to ArcGIS shapefile

I have dozens of SQL Server non-spatial database tables. These are common tables, the column types are: nvarchar, int and float. I try to use Arcpy to automate joining these database tables to ...
0
votes
1answer
31 views

Auto-selecting records in all spatial and non-spatial joined/related tables by selecting only “parent” spatial record in ArcGIS for Desktop?

(1) I have a layer of pipes with related spatial and non-spatial data linked via joins and relates. Is there a way of selecting the top/parent record and then having ArcGIS auto-select all related ...
2
votes
2answers
3k views

Fastest way to Join tables in python automation

My issue comes form the fact that doing Joins manually is actually relatively quick (5mins), but python automation of this process is 6hrs! Here is my code: import arcpy GDB_MARK_TO_MARK_VECTOR_VIEW ...
0
votes
1answer
20 views

How to export joined feature classes without losing field name?

I want to export a feature class uisng arcpy that join with other feature class.I use the below code to join and export feature class. The problem is that field names of the result feature class have ...
6
votes
2answers
1k views

Creating polygons from one to many relationship of points using QGIS or PostGIS?

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 ...
0
votes
1answer
37 views

arcpy: I would like to join a .xls table to a .shp table using two common fields

arcpy: I would like to join a .xls table to a .shp table using two common fields, instead of one common field. Is this possible in ArcGIS using python?
1
vote
1answer
45 views

Joining two datasets based on matching values in multiple fields

I am trying to find a way to join CSV data to a vector layer only when they both share matching values in multiple fields, rather than just one field. This is a problem I'm running into with multiple ...
0
votes
0answers
31 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 ...
7
votes
1answer
7k views

Joining polygons in R

I am wondering how to join spatial polygons using R code? I'm working with census data where certain areas change over time and I wish to join the polygons and the corresponding data and simply ...
0
votes
0answers
30 views

Preserving Reclassified Values as Attributes?

What is the BEST way to preserve original raster values as attributes in the output raster when reclassifying? I see that this question has been asked before as Making reclassified raster layers ...
1
vote
0answers
60 views

Add join works, join field doesn't

My input join field and output join field are text type, and my problem is that when I use "Add Join" all joins ok, but if I want to use "Join field" there are some records with Null, it seems like it ...
0
votes
0answers
35 views

Convert raster to polygon then join attributes

I'm trying to convert IMG files to shapefiles, then joining the attributes of the IMG file to the new shapefile. I got the conversion part to work, but am a stuck on how to join the tables. I have ...
0
votes
0answers
15 views

How to join CSV data (based on admin boundary names) to shapefile of aforementioned boundaries in R? [duplicate]

DATA: CSV data, Shapefile Hi all! I'm looking to perform what I've been taught is called a spatial join. After researching this further, it's looking like this operation is most often called a ...
3
votes
0answers
218 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. ...
3
votes
1answer
125 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 ...
2
votes
2answers
1k 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 ...
0
votes
0answers
16 views

(non spatial) One to one join and keeping all data

I have a set of over 20,000 villages in xls that only have a ward assigned to them - no coordinate. I do have a ward shapefile. Now I have created a data set of random points (shp) and spatially ...
9
votes
2answers
2k views

After joining shapefile with CSV file graduated symbols option unavailable in QGIS?

I have successfully joined data from a csv file to a shapefile in QGIS but for some reason I am having trouble symbolizing my data. I want to use a graduated symbology however this option is not ...
0
votes
0answers
6 views

Trouble with graduated symbols after joining shapefile with csv file Again [duplicate]

This question has already been asked: Trouble with graduated symbols after joining shapefile with csv file BUT I do not know how to create a csvt file? Having a lot of trouble with this. Is there ...
2
votes
1answer
64 views

Does joining CSV file to shapefile overcomes the 255 character limitation of shapefile? [duplicate]

I have a CSV file in which some fields contain values greater than 255 characters. I want to ask that wether joining the CSV file with a shapefile overcomes the 255 character limitation of shapefile ...
1
vote
1answer
52 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: ...
2
votes
1answer
264 views

How to import Excel data and display it on a state map in QGIS?

I want to import summarized data from Excel into QGIS 2.4. The date consist of US states and Canadian provinces paired up with a percentage. The data looks like this: State % CO 50.4 IN ...
1
vote
1answer
41 views

Join new data to selected features in a table using Arcgis

I have a point feature class, A, and I have joined data from another point feature class, B, to its attribute table based on spatial location. I selected the second option in the Join Data window ...
2
votes
0answers
84 views

How to automate calculation of distance between a zip code (centroid) and an address within one line of data?

I have a large data set of federal contracts which includes two pieces of spatial data per entry (or line): the zip code in which the project took place and the address of the contractor. I am ...
2
votes
1answer
69 views

Is there are way to import non-geo JSON files into QGIS?

Here is a json file containing various attributes relating to countries. However, it does not contain any geographic data. http://bost.ocks.org/mike/nations/nations.json I would like to join these ...
1
vote
0answers
26 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 ...