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

learn more… | top users | synonyms

0
votes
0answers
28 views

Broken links after joining an .accdb with a .csv in ArcGIS 10.1

I have two sets of data: A "master" file of coordinates that has one row for each location, saved as a .csv file A table with information for each location but no coordinates, saved in an Access ...
0
votes
1answer
39 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, ...
4
votes
1answer
98 views

Most efficient method to join multiple fields in ArcGIS

I have as set of shapefiles with approximately 300000 polygons each, as well as corresponding point shapefiles and tables with approximately the same number of row (equal or less rows than the ...
0
votes
2answers
45 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
2k 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
0answers
34 views

Join Standalone Tables from ArcGIS Server in Javascript API

I am trying to find a way to execute the equivalent of the following query with the ArcGIS JavaScript API (I made field and table names generic): SELECT a.field1, a.field2 FROM table1 a, table2 b ...
0
votes
1answer
37 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
46 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 ...
3
votes
2answers
230 views

Join a CSV file to shapefile using gdal/ogr?

I have a shapefile with several attributes, for example YEAR, COUNTY, and AREA. I also have a CSV file with more fields that I want in the shapefile, such as POPULATION. Both the shapefile and the CSV ...
1
vote
0answers
50 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
1answer
60 views

Can anybody help me with Spatial Join in ArcGIS 10?

I have a doubt, I do not find what's happening. Screenshot: Using the Join (Join data from another layer based on spatial location) I have done an Spatial Join by location, and it is said that the ...
0
votes
2answers
55 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
103 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
60 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
52 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
102 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
54 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
61 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
150 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
54 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
53 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
63 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
86 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 ...
12
votes
3answers
4k views

How to join attributes from nearest point in QGIS?

I have two layers with points, call them A and B, each with different attributes. For each point in A I want to join all the attributes from the nearest point in B. Ideally this would also include ...
3
votes
0answers
89 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
75 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
243 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
313 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
46 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
4k 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 ...
3
votes
2answers
240 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
54 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
58 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
393 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
153 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
73 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
125 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
71 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
602 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
52 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
125 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
157 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
34 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
429 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
57 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
808 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
64 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
279 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
82 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
190 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 ...