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

learn more… | top users | synonyms (1)

0
votes
0answers
17 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 ...
1
vote
1answer
34 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
74 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
133 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
51 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 ...
0
votes
1answer
39 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?
0
votes
0answers
60 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
48 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
1answer
36 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 ...
0
votes
0answers
34 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 ...
0
votes
0answers
59 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
16 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 ...
0
votes
0answers
18 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 ...
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 ...
1
vote
1answer
78 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: ...
3
votes
1answer
78 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
59 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 ...
1
vote
0answers
123 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 ...
2
votes
0answers
140 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
103 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
30 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 ...
0
votes
1answer
51 views

Python Scripting Displaying Incorrect Names after Join Field

My problem is that the code is adding numbers to the field names, and this is incorrect. Problem: Field should be names VALUE_122, but after running JoinField code, it becomes VALUES_122_123. The ...
1
vote
0answers
27 views

listing existing joins in table of contents feature

I am looking for a way to use python in ArcGIS desktop to check and print out the joins that exist between tables and feature classes in my map rather than right-clicking, going to joins and relates ...
2
votes
2answers
90 views

One-To-Many Join

I have a ZIP3 boundary feature class that contains roughly 900 records. I then have a table in a geodatabase that has 21000~ records and a ZIP3 field. How would I go about making a feature class ...
3
votes
0answers
30 views

Optimisation of MySQL JOIN based on a Within match

I have a table of points and boundaries, and am trying to add the boundary ID which a point is within. However, using a LEFT JOIN ON Within(location, boundary) it is taking about 3.5 hours match ...
2
votes
0answers
64 views

Making Large Data Sets Faster in ArcGIS Online or Portal

I have a sql view joined to a parcel layer for the entire city of New York (over 800k records). All data is registered to to the arcgis server. As you could imagine, this produces very slow response ...
4
votes
1answer
120 views

Conditional Spatial Join?

I need to join two layers (a fishnet grid and land cover). I'd like the join to occur only if the the land cover occupies 50% or more of each fishnet grid (See image below). Can anybody provide an ...
1
vote
0answers
89 views

How to show two layers at the same time in Qgis

I have a question about Qgis layers. I want to see two layers at the same times. one is lines which are boundary lines and the other is polygon which are district. when i was surfing about this ...
3
votes
3answers
257 views

How to Join two feature classes without common attribute

I have two shapefiles of essentially the same objects however, one shapefile has terrible spatial data but great attribute data and the other is the reverse. What I'm looking to do is essentially a ...
0
votes
0answers
78 views

Using Join with a Raster File

I would like to add a new field to a raster file. Then, I would like to add the new field content. Can I do this with a join of attributes? I know that a raster file can be reclassed. But there ...
0
votes
0answers
24 views

Fail in searches on the joined table data

When a table is joined to a standalone table, the searches on the joined table data return a fail. Is there another way to solve this inconvenient without save the layer with joined table under a new ...
1
vote
0answers
28 views

Join tables in QGis 2.01. Dufour

I performed a "join" going to the properties option in a shapefile (in this case is just a table), in order to join the attributes from another shapefile that has a field in common, specifically ...
1
vote
2answers
145 views

One-to-many join in QGIS

I am looking for a possibility to make a one-to-many table-join in QGIS. I have a shapefile with postal codes and would like to join them with survey results (more than one). In other words, there ...
0
votes
0answers
84 views

Join tables with duplicate values

I have two sets of data: list of parcel numbers and locations which I am interested in Address database for the county (shapefile) In dataset 2 there can be multiple instances of the same parcel ...
0
votes
0answers
78 views

What is the function for Joins and Relates?

I was writing a script to do a Join based on Spatial location. I don't want to do a spatial join as it will have all the fields of the layer that is joined to the target layer. I want only the fields ...
1
vote
0answers
52 views

Nearest neighbour / spatial join with attribute condition

I have 2 point format datasets I wish to schematically join (manholes & gullies). I am content that I can join them by nearest proximity alone using e.g. NNJoin plugin. What I would like to do ...
0
votes
0answers
64 views

Assigning one-to-many polygon to .csv data in ArcGIS for Desktop?

So I am currently working with two separate files. One is a polygon feature class detailing a specific countries' subdistricts. These subdistricts are identified using a specific alpha-numeric code. ...
1
vote
1answer
42 views

Table join not displaying in createLayer function in cartodb.js

I am trying to build on the cartodb tutorial to develop a map of fibre networks in Africa. The example works fine when my SQL select is very simple i.e. var layerSource = { ...
3
votes
1answer
47 views

ArcGIS converting list of enumeration in single field of s-57 data?

Im storing s-57 data in an MDB which is being symolised via a layer. Some attributes in s-57 data can be a list of enumerations and I want to find a way to show the actual values the enumeration ...
1
vote
1answer
59 views

Joining Excel file with CityGML file using FME?

I want to join a excel file with a CityGML file with FME. i want to join the excel file with the geometry of the CityGML file. all attributes should join this file which settings should i choose ...
1
vote
1answer
43 views

Joining table to a near table

I calculated the distances between one set of xy coordinates and another set of xy coordinates. So my near table has the ID variables, distance and rank. However, when I join the near table to the ...
0
votes
4answers
96 views

ModelBuilder - Iterate through tabels to join and export and keep original field names

I am trying to iterate through an excel with over 200 sheets and join each to a ZIP code layer. I then need to symbolize each of those the three different ways and save that to a layer file. In order ...
2
votes
1answer
80 views

QGIS feature subsets are incompatible with table joins. Bug?

When using QGIS 2.8.2, I am unable join a table to a layer that has a feature subset (Layer Properties > General > Feature Subset). For example, creating a feature subset on a layer prior to joining ...
1
vote
1answer
73 views

Working w/ Shapefiles Containing 50,000 to 300,000 Features

I work daily with shapefiles that are quite large in number of features using ArcGIS. Sometimes I am able to perform operations (joins, selections, exports, etc) on these shapefiles (though they do ...
0
votes
0answers
75 views

What is corrupting my layer file?

I'm trying to save layer files from a colleague's mxd. As usual I right clicked on the layer and saved as layer file. Simple - but no - the layer files can't be opened. I get this message "Adding ...
2
votes
3answers
346 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
145 views

How to conduct an inner join with QGIS?

My QGIS (2.8.2) joins always result in an outer join. How do I create an inner join with QGIS?
1
vote
1answer
120 views

Problems when joining large shapefiles to excel table

I began with a shapefile of 330,000 features, each having already been geocoded (not that it matters I don't think). I attempted to join this shapefile to an excel spreadsheet but of course, Arc ...
1
vote
0answers
60 views

Export Joined table an Feature layer based on a query

I have a table and a layer joined fine, I am trying to export the end result into a file geodatabase, the export is fine if I specify specific name, other than that it exports the original layer data. ...
0
votes
1answer
64 views

Join line segments sharing a common attribute, using GDAL

I'm having trouble rendering a shapefile consisting of trail routes broken down into many short segments. So I'd like to combine them into a small number of line features, which share a NAME and touch ...