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

learn more… | top users | synonyms

5
votes
7answers
26k 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
1answer
181 views

Join of two attribute tables with different amounts of rows

I have a hard time sorting the following out: I have two different Shapefiles. The attributetable of one, lets call it shapefile A looks the following: SHAPEFILE A ATTRIBUTETABLE Name Type ...
0
votes
1answer
111 views

Join leads to null value outside of edit session

I am using Arcmap 10.2 on Windows 7 I joined a shapefile with an Excel file, and the attributes are shown as until I start an edit session. Then, the values are as they should be. They match up by ...
0
votes
1answer
128 views

Is exporting to feature class the simplest way to make joins permanent?

I am a new user doing simple tasks with ArcMap 10.1 I have a shapefile and an excel file, and I want the join to be a permanent part of the shapefile. The way I've been going about this is to export ...
0
votes
1answer
50 views

How can I get a join for pre-existing fields?

I am joining some values from a table to a shapefile. The table and shapefile have the same column names and types, but when I join, Arcmap creates a new field, and I just want the join to write the ...
2
votes
0answers
72 views

How to join two fields after calculating?

I have been working with two layers and I am trying to join them and turn them into a raster data. The first layer is a watershed layer which I have assigned each shed a location from the center point ...
1
vote
1answer
63 views

How to join two tables and convert joined table to a vector layer containing points in QGIS? [duplicate]

I have one table that contains 450 locations and a table that has 10'000 rows containing data and no spatial information. I have a column that allows me to join them. The issue is that I want to have ...
1
vote
1answer
166 views

Error using 'Join attributes by location' via Python

Trying to run a simple script using qgis:joinbylocation but getting either errors or it's not processing correctly. I don't want to take a summary of the attributes, just the attributes of the first ...
0
votes
1answer
172 views

postgis, st_within, and a join

So I'm in the middle of learning postgis/postgres. I've a polygon table. I've a point table. The polygon layer contains a foreign key that points to another table. For the example the Foreign key ...
1
vote
1answer
227 views

Creating a Simple Join Script in Python

I'm trying to create a simple join script in python from an arcgis model, where the only steps are joining a map to a table to produce a map with the table's properties. The attributes joined ...
0
votes
1answer
82 views

Joining Textfile to Shapefile Arc 10 and 10.2 Differences

I am trying to join a textfile generated in stata that includes caoname, caoid, and fips. The fips code should match to a shapefile county map that matches to the cntyidfp category. In ArcGIS 10.0, ...
0
votes
2answers
62 views

Joining Tigerline Census Data 2010 and American FactFinder xls

I have a shapefile from TIGERLine data from the Census website, as well as a spreadsheet from the American FactFinder. I've edited the excel sheet to a 97-2003 workbook, and am now able to bring it ...
7
votes
4answers
3k views

How to close multipart polyline gaps in ArcMap

I have a multiple multipart contour lines that originally came from CAD drawing. I converted these into a polyline shapefile in ArcGIS. The issue I have is with gap in each contour lines that are ...
0
votes
1answer
77 views

how to create a cloropleth world map in arcgis 10.2

I am new to arcgis and I am trying to create a cloropleth map to display ratio values for different countries. I believe that my basemap will need to have a country layer so that the shading of ...
0
votes
1answer
174 views

Join by attribute when unique identifier has multiple rows using ArcMap 10.2?

I would like to join the attributes of one polygon layer to another polygon layer by their common ID. The problem is that in layer A, each ID has multiple rows, because each represent shapes from the ...
2
votes
0answers
175 views

Create a non spatial index on an attribute in QGIS before joining two layers

I’m using QGIS 2.0.1 on Windows 7. I’m trying to join a .dbf which contains no spatial data to a shape file containing spatial data. Ideally I’d like to create an attribute index on the join field in ...
0
votes
2answers
85 views

Joining two polygon layers based on distance?

I'm new to GIS so this question may be an obvious one. I have one polygon layer of urban land use and another polygon layer of swamps. How do I join the two layers so that I get a column in the ...
1
vote
1answer
403 views

Modelbuilder - Join - Keep matching records only - export to feature class

I need to join a table to a feature class in a model. Have it keep only the matching records and then export that joined feature class into a new feature class.
0
votes
0answers
92 views

Batch join non-spatial csv to shape files

I have 173 point shape files from soil testing and 173 non spatial csv files with lab ressults (one csv for each shape file) that need joining. The files are located in a library with folders named ...
1
vote
1answer
64 views

Problem with QGIS 2.2 joins between shp and csv

Didn't see question like this asked, so... I've joined csv to shp file and everythings seems ok. I've modified attribute form so that fields from joined csv appears in there. So far so good- it's ...
3
votes
1answer
115 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 ...
0
votes
1answer
93 views

Creating a New Shapefile from Joined Access Table

I'm dealing with a very large amount of polygons. Once I join the land use access table to the parcel shapefile, it takes forever for Arc to draw the polygons. I'm trying to select all residential ...
0
votes
0answers
76 views

In ArcGIS, how to automatically recalculate a calculation if I modify the Excel data source?

There's a database with buildings. Each of them has a few parameters, for example building type codes. In a distinct table each building type codes has 4 attributes. During the Join, the datas will ...
3
votes
4answers
230 views

How to assign geometry to records in a table that contain an ID of a geometry point?

We are looking to map out 'incidents' at schools, but the incident table, which contains a few thousand records, only has a school number (plus the incident data). The table format is an Excel ...
3
votes
1answer
96 views

Coloring of features in ArcMap 10.1 changes randomly while zooming

I am using the sovereign states shapefile (ne_110m_admin_0_countries.zip) from http://www.naturalearthdata.com/ and joined the attributes with a spreadsheet file that codes many (but not all) country ...
0
votes
1answer
170 views

Trouble joining table in arcgis. Joining field is 'greyed out'

I'm trying to join a shape file with a excel file I converted into a CSV. I had done this before with the same shape file but with a different CSV but this time when I try to select the column it's ...
0
votes
0answers
83 views

How to create a many to one spatial join?

I have a polygon feature class of territories and a point feature class of trees. The points have many attributes, one of them is the tree species name. I need to get the list of all the tree species ...
0
votes
1answer
137 views

Python field calc syntax error

The screenshot shows a calculate field tool in modelbuilder. The error I'm getting is invalid syntax line 1. I can't see any issues w/the syntax so I'm hoping someone out there can help. It ...
3
votes
0answers
91 views

tablejoin in qgis 2.x adds name of table to columnheader attributetable [duplicate]

When joining a table to a shapefile through 'layer properties > joins' the columnheader of the attributetable shows the name of the file you joined. eg.: the name of the table is: STAVAZA3 the table ...
1
vote
1answer
152 views

When I join a table to a shapefile and then export it the titles of the columns are transformed to data1, data2

I'm using QGIS 2.0.1 The table is in an excel format that i import through "add vector" and the shapefile is a polygone I join the attributes by right clicking the polygone-->properties-->join Then ...
0
votes
1answer
404 views

Problem with MMQGIS in QGIS V. 2.0.1 - Attribute Join from CSV File

I've been trying to use the Attribute Join from CSV File function in MMQGIS, but it does not seem to work in Version 2.0.1. I've tried to join the same CSV and Shape files using V.2.0.1 running under ...
4
votes
2answers
711 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 ...
1
vote
0answers
57 views

How to create a 1:n join and concatenate text attributes?

I have 2 polygon layers A and B. I would like to join the attributes from B into A for all the polygons from B that intersect A and for text attributes, i would like them concatenate. But apparently ...
1
vote
4answers
6k views

Merging multiple .tab files?

I was wondering if there was a quick way to merge multiple .tab files together? I have about 100. Would appending one tab to another with the MapBasic window open, then changing the name of the table ...
1
vote
0answers
72 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
78 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
1k 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
255 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 ...
0
votes
2answers
108 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
327 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 ...
1
vote
2answers
2k 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
68 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
159 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
220 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 ...
1
vote
0answers
83 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
1k 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
112 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 ...
0
votes
2answers
565 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
91 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
703 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 ...