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

learn more… | top users | synonyms

0
votes
0answers
22 views

How to use calculatefield_management with ArcPy and joined second table? [duplicate]

How can I use calculatefield_management with ArcPy if I have a joined second table? I want to go through the attached table's field and I want to get records where the certain fields is. How can I ...
4
votes
1answer
1k views

How to Calculate Field in joined table using ArcPy?

I have to calculate a field based on another field in a joined table, but an error occurs: "Parameters are not valid. ERROR 000728: Field !Table_A.field_A! does not exist within table" My code: ...
2
votes
1answer
46 views

Difference between: join, merge and group

Suppose it is desired to make polygons A and B, and their respective attributes to be one unique polygon C. What is this GIS operation called? Is there any difference in GIS terminology about ...
4
votes
1answer
3k 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
1answer
74 views

Join and Field Calculator

I made a Join between a shape and a dbf, and now I want to calculate some data from the table that came as a result from that Join. Everytime I try to run the Field Calculator it says there's an ...
1
vote
1answer
38 views

How to remove LayerName.FieldName join format in model builder?

I am running a join in model builder based on a calculated field in a geodatabase table and a created layer. After the join I am selecting features and copying selection to a new Shapefile. My ...
1
vote
0answers
55 views

Fastest method to join a lot of tables

i have a lot of feature class (see figure 1) the objective is to create one feature class that combines the attribute table (especially one field) of each feature class the attribute table of each ...
1
vote
1answer
51 views

How do you calculate a new field for a raster table based on value from a joined table?

I need to know whether it is possible to calculate a new field for a raster table based on a value from a joined table. Ideally I'd like to be able to accomplish this task without having to add table ...
0
votes
2answers
30 views

Why won't my csv file imported as a vector layer have attribute table headers?

I have a .csv file that has unique identifiers that I'd like to join with some legislative district shapefiles in QGIS. I've done this before, and the joins all worked fine -- and technically it still ...
0
votes
0answers
13 views

Appending data from relate into single attribute table row using ArcGIS for Desktop?

I have a featureclass of cities and a separate table of city administrators and related contact info. What I need to do is consolidate all city administrator info into the attribute table of the ...
0
votes
0answers
23 views

ArcGIS Route Analysis

I have a pipe network that is a imported CAD file converted to lines showing complete runs of pipe in a system. I also have a Access database imported to ArcGIS set up as a relate to my Pipe line ...
1
vote
0answers
15 views

Join a table to a pre-joined field in QGIS

I'm trying to join a .csv (X) to a .shp layer (Y), but X and Y don't share an ID field. Another .csv, Z, has TWO ID fields--one shared with X and one shared with Y. In any other language, I'd first ...
1
vote
0answers
10 views

Editing the configuration of a join in QGIS

Is there any way to edit the conditions of an existing join in QGIS? I have a .csv joined to a (polygon) .shp layer; because I only needed a few fields from the .csv, I only joined those I needed. ...
0
votes
0answers
32 views

Modelbuilder Join

Trying to do an iterate with a join to a table to create a new feature class. The output has the spatial data but with none of the fields of the join making it. I think that I have the problem ...
4
votes
1answer
166 views

QGIS 2.0.1 linking table issue, MSSQL 2008 database

I'm trying to link tables in QGIS 2.0.1 and MSSQL 2008 database. I can link them but when I try to open the attribute table QGIS throws an error and shuts down creating a *.dmp file. I saw that ...
2
votes
1answer
105 views

Symbolising null features in graduated symbology

I have a polygon feature dataset, and an attribute from a different table that I join (one-to-one) within QGIS in order to symbolise the attributes as a choropleth map. However, not all polygon fields ...
0
votes
1answer
51 views

Selected features with a join are identified improperly from a service

We couldn’t figure out why a service fails to provide correct identification for the selected feature. However, the scenarios below may highlight the issue: In the “UrbanMasterPlans_WithJoin.mxd” ...
1
vote
4answers
743 views

Why does QGIS not detect the CSV/DBF column headers?

I am trying to import a csv or dbf into qGIS so I can perform a join on a shapefile. However, qGIS is not detecting the first row as header names. I know I've done similar joins before and there's ...
2
votes
2answers
123 views

Populate a layout text element with the description from a coded value domain

ArcGIS 10.1+ lets you easily put dynamically populated text boxes in your print layouts. Doing so puts some text in the text element that looks something like this: <dyn type="page" ...
1
vote
1answer
66 views

SQL-Like Inner Join on IDs in Two Layers in QGIS

Using QGIS v2.6.0-Brighton. This question is not about editing layers geographically in anyway. It is merely trying to find data from two layers as you would in an SQL Query and append an extra ID to ...
2
votes
1answer
64 views

Spatial and Non Spatial join

I have a shapefile with a number of weed control blocks as polygons. They each have a unique block id number. I am trying to join a non spatial csv file which has multiple entries for each block over ...
1
vote
3answers
450 views

Excel (*.xls) imported into File Geodatabase is missing records?

Long time reader first time poster :D Err I am having a few issues with a join to a File GDB from xls I imported as a table to the the FGDB. The problem being records that are in the original ...
1
vote
5answers
301 views

Selectively removing whitespace from a string with SQL

I have two columns of adresses that I need to join. Column 1 has the adresses formatted as "Some Street 12 A" while column 2 has them formatted as "Some Street 12A." Ie. the last whitespace between ...
0
votes
1answer
60 views

How can I join a buffer layer to the layer it was created from?

I have two relevant layers for this problem: Real estate parcels (point data) Multiple ring buffer layer - contains multiple buffer rings around each particular real estate parcel. (0.5, 1, 1.5, ...
0
votes
0answers
8 views

add points when joining two datasets together in ArcGIS

I am trying to join an excel file with a shapefile based on a zipcode. My problem is that I have multiple persons with the same zip code, but it joins only 1 of those persons. Is it possible to ...
1
vote
1answer
25 views

add points when joining two datasets together in ArcGIS

I am trying to join an excel file with a shapefile based on a zipcode. My problem is that I have multiple persons with the same zip code, but it joins only 1 of those persons. Is it possible to ...
2
votes
1answer
87 views

Join line to multiple points

I took some ASCII files and created points with attributes. I am trying to join the line features to these but a simple join function will only take the one that is closest. Is there a way to perhaps ...
1
vote
4answers
146 views

How can I join all data of two raster datasets in ArcMap 10.2?

I have two raster datasets in ArcMap10.2. One is displaying rails and one that is displaying a 100m Buffer to both sides of it. My cellsize is 100x100m. What I want is to combine the rails AND the ...
1
vote
2answers
34 views

Making data joined from Excel independent in ArcMap? [duplicate]

I have joined some data from Excel (.csv) "text" to my attributes table of one feature class. However I can't edit it. I found out it is still connected to Excel file from where I added it, and I need ...
1
vote
1answer
48 views

How to specify imprecise join criteria in ArcGIS for Desktop?

I need to join data from an Excel Spreadsheet to a Point feature class. Namely, matching up Addresses from one piece of data to another, and then appending the rest of the data once the addresses ...
2
votes
1answer
183 views

How can I display multiple multi-attribute labels for polygons

I am using ArcGIS for Desktop 10.2. I trying to import and display project data for various regions. Each project is tied to a location and I want to display Project Type, Funding Source, and a dollar ...
2
votes
2answers
286 views

Spatial join versus classical join

What are the main differences between a spatial join and a classical database join such as an equi (inner) join?
0
votes
0answers
13 views

ArcGis Join Data CSV Problem [duplicate]

I have been trying to use ArcGis Desktop and ran into some problems while joining the data from a csv file with the shp file. I can see the attributes that have been added in the attribute table but ...
1
vote
1answer
98 views

Why can I not choose the join field I need from a csv or excel file?

I am attempting to join census data (county level) to a county base map, using the FIPS county code as the join field. I can join successfully if I do not alter the original csv file from the census ...
1
vote
0answers
96 views

Can Virtual Fields be used for a rendering style?

In QGIS 2.6, creating a virtual field for a layer and adding up 2 integer fields work fine. I get the correct results and I can use that field for styling. However, when doing a Joins with 2 layers ...
2
votes
2answers
2k views

Creating non-spatial Many to One Joins/Relationships between tables

I may have missed a trick here but I can't seem to find a solution. I have a table of ~1.6 million postcodes, also containing co-ordinates, and a separate file detailing ~6000 a population with ...
1
vote
0answers
328 views

In ArcGis 10, spatial join of a hot street value to a fishnet cell is counting multiple values for same street segment

So, I am working on a fishnet, so that we can attribute multiple values to points within different cells (i.e., ranking light poles as optimum for traffic cameras based on the number of speeding ...
1
vote
1answer
44 views

Another Way to Join a New Column to a DBF if OpenOffice is Giving a “Longer Than the Number of Digits Allowed” Error?

When I need to add a data column to a DBF, I always download the shapefile, open the DBF with OpenOffice for Mac, us a VLOOKUP( ) to add my data to a new column, re-save the file as a DBF, then open ...
3
votes
1answer
39 views

Join Tool (Data Management)

I have a new table with statistics data that has been calculated with the tool: Zonal Statistics as a Table; in order to know the min, max, mean, range, std, etc, from a thickness value that was ...
1
vote
0answers
24 views

Joined field not recognized as number in QGIS 2.4 [duplicate]

I have a weird problem. I've loaded in QGIS a point shapefile and a CSV table. Then I performed a join between the 2 layers and all works fine. But then the joined columns (made of integers or real ...
1
vote
1answer
271 views

Using ModelBuilder to Iterate, Join & Export Feature Classes?

I am trying to make what I thought was a very simple batch processing tool, but I can't get the output to work properly. I would like the model to iterate through a geodatabase, join each feature ...
5
votes
1answer
50 views

Is it possible to have a 1:n join which takes the min, max, or average value?

I need to join the attributes of a shapefile with the one contained in a .dbf (or .txt) file. I currently use the "join" in the properties menu, but I have a problem. In the shapefile I have one ...
2
votes
2answers
88 views

Unable to merge CSV and CSVT with shapefile using QGIS due to “text” fields?

I know the question is all over this site, unfortunately I cannot find a solution. I have this CSV file and this CSVT file that I want to merge with this shapefile. I've tried to format the .csv using ...
18
votes
4answers
9k views

Joining non-spatial CSV file to spatial data (shapefile) using QGIS?

I have a CSV file which has postcode data in a field, but it is non-spatial e.g. no Easting and Northing. I have a shapefile with postcode in a field and some additional data. I want to join the ...
1
vote
1answer
458 views

arcgis - updating joined excel file when adding a new sheet

When adding a new sheet to a joined Excel file in ArcGIS, the new sheet will not show till I exit both arcgis and excel. Is there a better way to update the connection...? edit: sorry for the delay ...
2
votes
1answer
57 views

Adding attributes to an existing shapefile [duplicate]

I have a shapefile made of buildings, each one of them characterized by some attributes. I need to add some attributes contained in a .dbf file. The two files have in common the attribute "ID", so the ...
7
votes
2answers
2k views

Join attributes of point and line layer by location (closest distance) in QGIS

My problem is the following: i have a line shp (target layer) and a point shp (join layer). the second one (point layer) holds an attribute which i want to join with a line layer based on closest ...
2
votes
1answer
65 views

Join command, desired field not available to select

I have a problem regarding ArcGIS 10.1 and any help would be greatly appreciated. I want to join a shapefile in which I stored geographical information with a CSV data file containing certain ...
2
votes
1answer
135 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 ...
2
votes
1answer
63 views

Joining QGIS extent table with shapefile

I used QGIS to find the extents of a list of features from a census boundaries shapefile. I used Vector - Research tools - Polygon From Layer Extent, which creates a new shapefile with a table of ...