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

learn more… | top users | synonyms

1
vote
1answer
13 views

Returning list of field names in joined table using ArcPy?

I need to look at all the fields in a joined table performed through arcpy. I am instigating for fields in arcpy.Listfields(Feature): print fields but it is returning a large list of: ...
1
vote
2answers
37 views

How can I release the lock file on a DBF after removing its join to a FeatureLayer using ArcObjects?

I found another post with two different answers on how to remove the join between a feature layer and a standalone table, but neither method successfully removes the lock file ...
3
votes
1answer
58 views

Using ArcPy to Remove Join?

I am trying to remove a join in arcpy and have been all over the forums and help topics but cannot get my script to remove the join. I have tried many combinations of inputs to the remove join but to ...
2
votes
1answer
35 views

The best practice to join\relate\connect 4 feature class together

What is the The best practice to join\relate\connect communities\UMP\BuiltUP\Admin boundaries, Could you please consider the following scenario: I have a feature class with a name “community “ ...
0
votes
1answer
11 views

My exported data does not align in the correct projection? [on hold]

I have excel tables the data is from a website that I need to add and update to my SDE database. The header of the excel tables have Work Order number, date, zip, department and address. The problem ...
1
vote
1answer
27 views

Join traffic data (point) to a road network (line) - Section between two roads - ArcGIS

I am trying to analyze the vehicle traffic in Melbourne's (AUS) road network. I have two files: the traffic data (point data for a given latitude and longitude with the average hourly traffic between ...
3
votes
2answers
691 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 ...
8
votes
1answer
96 views

Can you use wildcards for column headers in Field Calculator?

I know you can use wildcards for fields like so (in the Field Calculator): case when "column" ILIKE '%example%' then 1 else 0 end Can you do something similar for the column headers themselves? I ...
2
votes
1answer
289 views

How to join averaged precipitation values to each municipality

I have precipitation data that I would like to average over each municipal unit in a boundary layer. First, how do I average the rainfall spatially by each administrative unit? Second, the rainfall ...
2
votes
0answers
10 views

QGis - WFS and joins

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 ...
2
votes
1answer
281 views

query / filter on attribute tables with external tables joined

i tried to do some queries on joiend table fields ... i've got/found some answers concerning version 1.8 - which result in "use select + export to create a combined dataset" so i just did some tests ...
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
941 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
33 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
2k 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
57 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
24 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 ...
0
votes
1answer
304 views

Join and Calculate vb.net

Im trying to join an excel table to a shapefile and then calculating those fields using vb.net. The code I have written has no errors, but won't work when I try it in ArcGIS 10.1 and I'm out of ideas. ...
1
vote
0answers
46 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
31 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
24 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
8 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
12 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
27 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
160 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
52 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
37 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
658 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
92 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
37 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
46 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
173 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
115 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
43 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
6 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 ...
4
votes
3answers
4k views

ArcGIS - Create a join based on multiple fields

I have two feature classes in a File Geodatabase that I would like to join based on multiple fields. I've searched this site and Google and all I have come up with was to use the Make Query Table ...
1
vote
1answer
23 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
72 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 ...
0
votes
4answers
54 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
26 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 ...
2
votes
1answer
69 views

ArcMap many-to-many join

I'm working in ArcMap 10 and can move around in R, though am not an expert. I have a shp file and an xlsx file. The shp file is 20,221 rows and includes a field GID (grid ID) which is not unique ...
1
vote
1answer
44 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
97 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
223 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
11 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
60 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
63 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 ...