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

learn more… | top users | synonyms

3
votes
3answers
129 views

Field Join by Approximate Data in ArcMap?

I've run into a bit of an issue. I recently pulled data from the CDC website concerning Suicide rates by county. However, the csv file does not have locational data. Luckily, my project is about the ...
0
votes
0answers
35 views

How to show an overview of all Joins and Relations in ArcMap Project?

Is it possible to get an overview of all Joins and Relations between my Tables and Files in ArcMap 10.1? Right now I have to right-click on every file to see how it is connected to another file. It ...
0
votes
2answers
3k views

can't join excel(2013) to ARCGIS 10.2.2

When trying to join Excel datafile to shapefile in ARC GIS 10.2.2 I keep getting the following message: "Failed to connect to database. An underlying database error occurred. Class not registerd." ...
2
votes
2answers
5k 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 ...
1
vote
1answer
186 views

Creating many-to-many table from intersection between two polygon layers in QGIS?

I have created a buffer around several points. I want to intersect this layer with a Census Tract layer. My end goal is to create a table that would list all the census tracts that intersect with the ...
3
votes
2answers
3k 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 ...
3
votes
1answer
667 views

Joined tables and now field calulator is greyed out

In ArcMap (10.2), I accidentally calculated the wrong field outside of an edit session, so there was no way to reverse my action. I restored a previous version (shadow copy) and joined the tables ...
2
votes
1answer
59 views

Can I join a table with a field with several rows with the same word to a polygon?

I have a table that looks like: Name X X X Y Y Z Z I have a polygon feature class with the attributes: Place X Y Z Essentially, I want to join that table to the polygon, but I want each row in ...
1
vote
0answers
391 views

Joining to data in ArcGIS Online

I'm a GIS professional. One of my clients (an ArcMap user) has asked our firm to teach some of his staff about ArcGIS online. In so doing, we are to provide an overview of GIS-- how to think ...
3
votes
2answers
743 views

Join table field with shapefile programatically (via PyQgis)?

The following is currently unsuccessful at fulfilling a table field join to a point shapefile in Qgis. All instances of the join object will print the proper values, and no error is flagged when ...
6
votes
6answers
1k views

How do I remove a join (between a standalone table and a feature layer) with ArcObjects?

I already know how to do a table join with ArcObjects, via the IDisplayTable, IMemoryRelationshipClassFactory etc. interfaces. Here are some links to resources that have example code for this: ...
0
votes
1answer
60 views

How to join multiple lines (branches of a large stream network)

I've generated a channel/stream network based on a DEM, but each branch of the network is split into very small lines. I'd like to have the network divided into as few separate lines as possible, so ...
1
vote
0answers
75 views

Saving fields after a raster join with python arcgis

I am working on a raster processing script in which i join a categorical raster with a table that includes some extra data on each category. After much hassle, I have the join working, but I can't ...
1
vote
1answer
82 views

Joining dBase (*.dbf) table to Coverage?

I have a dbf table and a polygon coverage. How do I join and save the joined data to the coverage without exporting to feature class and then re-creating a coverage in python? I have been looking at ...
1
vote
1answer
137 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
215 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
455 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
130 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 “ ...
4
votes
2answers
2k 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
209 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
314 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 ...
4
votes
1answer
3k 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
159 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 ...
0
votes
1answer
402 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
219 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
76 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
144 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
85 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 ...
1
vote
0answers
21 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
14 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
46 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
182 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 ...
0
votes
1answer
109 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” ...
2
votes
4answers
1k 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
347 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
198 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
175 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
1k 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
1k 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
279 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, ...
1
vote
1answer
33 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
123 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
3k 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
51 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
97 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
667 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 ...
0
votes
0answers
15 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 ...
2
votes
1answer
1k 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 ...
2
votes
2answers
4k 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
364 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 ...