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

learn more… | top users | synonyms

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 ...
3
votes
0answers
19 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
29 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
62 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
107 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
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 ...
2
votes
2answers
4k 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
38 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
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?
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 ...
7
votes
1answer
8k 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
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 ...
1
vote
0answers
103 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
54 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
1answer
131 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
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 ...
11
votes
2answers
3k 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 ...
3
votes
1answer
74 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 ...
2
votes
1answer
289 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
54 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
126 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
101 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 ...
7
votes
7answers
37k 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
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 ...
0
votes
1answer
49 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 ...
2
votes
2answers
86 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 ...
8
votes
3answers
5k views

Joining tables without losing original field names in ArcGIS for Desktop?

I'm wondering if there is any method to preserve the original field names in ArcGIS when I join csv. tables to a Shapefile. I ask, because sometimes I join tables with 10, 20 or even more columns ...
3
votes
0answers
28 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
60 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
113 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
79 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
217 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
69 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
2answers
121 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 ...
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 ...
2
votes
0answers
42 views

Can joined tables be served by QGIS Server WFS?

I'm trying to figure out whether it's just me, or if I'm forgetting a setting. I have a shapefile which I make available for WFS-requests. Now I added a join (to a MySQL table). I tried playing ...
0
votes
0answers
74 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
75 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 ...
0
votes
0answers
63 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
0answers
46 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 ...
1
vote
1answer
41 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
46 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 ...
3
votes
1answer
5k views

Why can't I use a Join in a model?

I'm trying to build a model using Model Builder in ArcGIS 10.1 that starts off by joining two shapefiles together based on a common field. I would like to make this open ended (not hardcoded) so I can ...
0
votes
4answers
90 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 ...
1
vote
1answer
55 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 ...