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

learn more… | top users | synonyms

3
votes
2answers
160 views

Arcgis not seeing my column header to join tables

I am trying to join a data table to the attribute table of a shapefile. I have done all the necessary steps to makes sure it works: removed spaces, not use numbers in column headers, remove illegal ...
1
vote
0answers
47 views

Record Set (Recordset) for Join in ModelBuilder

I am trying to use a recordset to develop a Table View to use to join to a feature layer in model builder. I can export the table view directly with the user input included. However, when I attempt to ...
0
votes
0answers
54 views

export spatial information from table that is joined to a shapefile in QGIS 2.0

I have a table with data values per district for different years. The table looks like this: district name / year / value. The same district is thus present in the data multiple times for different ...
2
votes
2answers
278 views

Table join with .csv file results in null fields after join

Similar to questions already asked about .dbf files, I'm attempting to join .csv files to a .gdb or shapefile coverage in QGIS. The tables as added to QGIS prior to the join look fine, but after the ...
6
votes
2answers
140 views

How to enumerate join values with ArcGIS?

I have two shape files (e.g. postal code areas and cities) which I want to join based on an id that both shape files have in common (the id would be the city name in this example). Joining the two ...
2
votes
1answer
72 views

CartoDB merge tables (column join) returns import error

I have been trying to merge two tables using the column join in Carto DB. The first table is a table of US counties that contains the polygon geometry and the FIPS id code. The second table contains ...
0
votes
2answers
62 views

Joining two tables in CartoDB mysteriously returns no rows

I have two tables in CartoDB, one with locations and one with related data to those locations. They are related through the common columns "placeid" and "relatedid". Both columns are string, (and ...
0
votes
0answers
97 views

Best way to join and handle multiple attributes related to the same feature

this is not going to be a question, I'm just trying to find some advice. Suppose I have a point shape file (for example just 2 point, actually I have many more points) representing water control ...
0
votes
0answers
61 views

Bug in Qgis 2.0 Field Calculator with Values from Joined table

I have a data of hospitals. I have two excel sheets, one has no of patients examined in each hospital and other has no. of patients treated in each hospital. I want to find percentage of treated ...
1
vote
2answers
464 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 ...
2
votes
1answer
51 views

Can ArcGIS make a join with selected attributes being added into the outcome?

My question is when making a spatial join, is it possible to only assign selected attributes of source layer to the target layer instead of getting all attributes from source layer? I'm asking is ...
2
votes
0answers
112 views

Joining nearest neighbor small polygons using R

The figure shows a plot of numerous polygons (zoom in) made from a raster file by require(sp) require(raster) pol100 <- rasterToPolygons(r, fun=function(x){x==1}, dissolve=FALSE) There polygon ...
1
vote
1answer
145 views

Join Tables related by a composite primary key in qgis

I have two tables, one has the geometry and other has attributes. The table with geometry has unique number primary key, and 4 columns admin1,admin2,admin3,featureid. Table two is a csv file has the ...
0
votes
0answers
33 views

Search an attribute and highlight corresponding polygon from a “joined-in” layer [QGIS/PostGIS]

Using QGIS 1.8.0, Postgis 2.1.0, and still new to all that. As the headline points out, I have a list of samples, which are found within areas (no point (GPS) coordinates). With a search query I ...
1
vote
1answer
311 views

keep the same field headers after joining a table to a shape file in QGIS

I noticed that after joining a table to a shape file the headers of each fields in the table used for the join are changed by QGIS and they are attributed to a different name. For instance, i had a ...
1
vote
0answers
46 views

How to repair a data source with joins to Excel?

I have a set of MXD files, that do not use relative paths, and related data that have been copied to a new computer. Normally it's not a big problem to repair the data sources in the project, but in ...
2
votes
0answers
694 views

QGIS: 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 ...
0
votes
1answer
53 views

Using JOIN TOOL in ModelBuilder

I want to perform JOIN TOOL for all DBFs generated from ZONAL STATISTICS AS TABLE into one table. However, it seems that DBF has a maximum of 255 fields while my dataset has more than 500 ...
6
votes
2answers
2k views

How to join tables without losing the original field names in ArcGIS?

I'm wondering if there is any method to preserve the original field names in Arc GIS when I join csv. tables to a Shapefile. I ask, because sometimes I join tables with 10, 20 or even more columns ...
0
votes
2answers
232 views

Problem with adding new field to attribute table after performing join by attributes

I am studying ArcMap 10.2 and concentrates on different join operations. I am working on a Personal Geodatabase. I have digitized some polygons from a raster representing houses and have created a ...
6
votes
1answer
77 views

Is there maximum number of .DBFs that can be joined using ModelBuilder?

Is there a maximum number of .DBFs that can be joined using the Join Tool in ModelBuilder? I tried joining 480 .DBFs but results generated only 250 fields in the input table. Is this a glitch? I am ...
1
vote
4answers
161 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 ...
0
votes
2answers
143 views

How to permanently join MDB database (access) table with spatial data in ArcGIS for Desktop?

I have an Access file (*.mdb), and I want to join between this attribute data with its spatial data ? But other than (join & relate way) . And I need it to be permanent .
1
vote
0answers
49 views

GeoJoin with ArcGIS Services [closed]

Has anyone seen any ways to dynamically join data in services. E.g. I've already exposed County boundaries in a MapService, now I want to let users join their relative data to this service for their ...
4
votes
1answer
388 views

How to join fields which must still be created in ArcGIS Model Builder?

I am in the process of creating a generic model in ArcGIS Model Builder. At one point in my model, I have to do a join between an existing layer (entry parameter) and a table issued from the "Zonal ...
1
vote
0answers
670 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
0answers
51 views

Joining Data in ArcMap Errors

Has anybody encountered issues with ArcMap when joining data? Specifically, my rows join, however, depending on how ArcMap is feeling, I might or might not receive my data in the form of quantities. ...
2
votes
1answer
158 views

Joining Multiple Features to One Feature

I have two layers - an index layer (polygon) and a town boundary layer (polygon). The desired output is a FC with each town represented as only one feature and that FC's table having a field with ...
4
votes
1answer
214 views

How to join data from NHGIS to make choropleth maps in R/ggplot2?

I have downloaded shapefiles of county/state boundaries and census data keyed to those shapefiles from the NHGIS. Both the shapefiles and the census data have a GISJOIN column to be used for merging ...
1
vote
2answers
297 views

Join excel attributes to shape attribute

I am wondering if there is a way to join the attributes from excel tables to shapes in Qgis. I have abbreviations in the shape and want to add the associated complete names from excel file by ...
0
votes
1answer
707 views

Problem adding a join to a table via Python using addJoin_management

I am currently building a script for a script tool that will join data from a multitude of tables into a single table based on a common join field. Now, I have attempted to use ...
1
vote
1answer
365 views

MapInfo: How to get the population contained within 2 geographical tables

I using 3 different tables which are also geographical objects: population data; points on the map representing inhabitants (1 or more) region data; the map is divided in regions coverage data; it ...
0
votes
1answer
60 views

AddJoin_management crashes ArcMap

I am going to be using an AddJoin_management command in a python script at the end of several loops. To test, I used the AddJoin tool and use the below command in the Python window and made the ...
3
votes
1answer
101 views

Join is deleting fields in arcpy

I'm working on a script to automate the conversion of CAD .dwgs of rooms to feature classes, I'm nearing completion and am now working on the second portion of the script (I've seperated it into two ...
3
votes
1answer
765 views

Creating a spatial “Many to one” join

I'm trying to create what I call a "many to one" join. I don't know if that would be the correct term or not. I have a table that has unique account numbers for mobile homes (i.e. - M1007970) per ...
1
vote
4answers
91 views

Add only unique features from another shapefile

I've got a problem that I am sure at least one of you have dealt with. I'm new to a company that makes use of a rather large database of point data. For whatever reason, the woman who was here before ...
7
votes
5answers
481 views

How to programatically identify the “Joined Field” in ArcMap?

Is it possible to programmatically identify the Join Field that is being used to Table Join two datasets together in ArcMap? I am currently using ArcGIS 10.0, SP5 and would prefer an ArcPy solution, ...
2
votes
0answers
92 views

QGIS - How to avoid -2147483648 value from imported CSV?

I am attempting to join a spreadsheet containing all the CIA Factbook Country Comparison Data (many columns) to the existing Natural Earth world countries shapefile. I followd the tutorial here, but ...
0
votes
0answers
183 views

PyQGIS joining a dbf to a shapefile

I am trying to join a shp and dbf file using the PyQGIS API. The code I'll use is below: from PyQt4.QtCore import * vector1 = QgsVectorLayer("path to dbf file", "test1", "ogr") id1 = vector1.id() ...
0
votes
1answer
67 views

Why is ArcGIS for Desktop not joining records when values have dot (.) in text string?

ArcGIS is not joining records from a table that have a dot (.) in the text string. Has anyone else come across this problem? Is it a known issue?
2
votes
2answers
195 views

ArcMap | Perform full outer join

Hey there, does anybody know how to perform a full outer join with ArcMap? Just to describe the problem a little bit more, lets say I got the following two tables: Table A Joinkey 1 2 3 Table B ...
2
votes
1answer
58 views

After joining data from csv file to shapefile, why are all values zero in categorized renderer?

I have joined data from a csv file to my shapefile. The attribute table shows a successful join. I have converted the variable of interest to INTEGER. But when I go through Style to categorize the ...
2
votes
1answer
161 views

QGIS join data not transferring

I'm reanalyzing data from a VA Late Woodland Palisaded Village. The site is mapped in CAD and exported as a shapefile. QGIS brings up the 1059 features as polygons. I am using a CSV file for the ...
0
votes
0answers
432 views

How to do a spatial join if QGIS 1.8 keeps crashing?

I am trying to perform a simple spatial join (adding polygon data to points) in QGIS 1.8: target vector: points join vector: polygons take attributes of first located feature keep all records ...
1
vote
1answer
1k views

Join Fields from Multiple Tables to One Table in Modelbuilder

I have 40 tables with about 2000 row with a shared ID that I want to merge into 1 table with 2000 rows. I only want to retain a distance field calculated within each table. The distance field is ...
5
votes
1answer
362 views

How do I avoid text field truncation when saving a table join?

Using QGIS I've joined tabular text data (all in fields of less than 255 characters) to a shapefile via a CSV file. All looks good in the joined table but when I save to a new shapefile to make the ...
0
votes
0answers
38 views

multiple data atach with shape file in GIS-regarding

I have different sampling data of one location that is a point so, multiple data how to join with single point. after joining i need quries by select attribute in GIS.
0
votes
1answer
1k 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 ...
2
votes
2answers
404 views

Why does ArcMap crash if I try this Join Field (which ArcPy does not like either)?

I'm a little uncertain whether this question belongs here or on http://gis.stackexchange.com Have an "AddJoin" that results in no shared records, which is not what I'm expecting. Is it because I'm ...
2
votes
2answers
308 views

Joining lines in MapInfo that won't be split by disaggregate?

I have just run a disaggregation a .tab containing just lines and found I have a few with duplicate IDs. However when I zoom in these lines appear to be connected. Is there any way to join these ...