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

learn more… | top users | synonyms

1
vote
2answers
43 views

What is the strategy to add attributes to shapefile when the number of records are not the same?

I'm trying to add attributes (in excel format) to an existing shapefile using ArcGIS, but the number of records between the two are not the same; there are some records in one file but not in the ...
1
vote
0answers
32 views

Joining shapefiles based on FID in QGIS [on hold]

I want to join shapefiles (or a shapefile and a data file) based on their mutual FIDs and can't see the FID in the "Target Field" dropdown on the join form. I believe this is a basic need to have ...
0
votes
1answer
51 views

Write CSV table for join self in ArcGIS for Desktop?

I wonder how I would write a table for a join which I want to perform. Right now I wrote a .txt File, tab-seperated. The headerline only contains letters. Here is the problematic table: ...
1
vote
3answers
45 views

Create Statewide Hydrologic Soil Group Map

This may be better for Engineering? Not sure. Background: Previously I have downloaded SSURGO soil data for the state of Pennsylvania by downloading each county and merging the shapefiles. I then ...
0
votes
0answers
38 views

Joining the tables with the geometry

I have a large table (as a shapefile without geometry, just set of records) with data which has the refference to the other tables (as a shapefiles with specific geometry, reference as same ID's for ...
0
votes
1answer
31 views

How to take only relevant rows from database, based on common codes

I have a shp file that is missing some data, e.g. attributes. I have the missing data in a csv file. How can I get ONLY the relevant rows from the csv file added to the current shp file's data table? ...
1
vote
2answers
61 views

Combining spatially identical polylines in the same layer

I have a shapefile of road volumes as polylines, and want to be able to show the sum of the volumes for polylines that are spatially the same/similar but are for travel in opposite directions. For ...
0
votes
1answer
66 views

Joining blank shp with dBASE Table

What is the best way to join following tables? I have 55 records in the second table and I would like to just "drag and drop" the data to the first one. Shapefile table Database table
0
votes
0answers
31 views

QGIS table join with multiple fields

I am trying to join info from a DBF to a shapefile. There isn't a perfectly unique identifer. Is there a way to join the tables with 2 or 3 fields? The simpler the better. I am just getting familiar ...
1
vote
0answers
26 views

Can I define a style for one layer, taking into account a defined relationship with another? (QGIS 2.8)

I have two sets of data. A large set of lines with a line_ref field, and a small data-only (no geometry) table with a matching line_ref field (let's say for argument's sake that the data-only table ...
0
votes
2answers
56 views

add attribute information from polyline to a point shapefile (QGIS or ArcGIS)

I was wondering if, and how, it is possible to add attribute information from a polyline to a point dataset. I have a network layer with information per street how many scooters went over this street. ...
0
votes
1answer
44 views

CartoDB table join error: Column reference is ambiguous

I've got a CartoDB question that seems dumb b/c the layer is correctly rendering. Anyway, I have two layers, named sampling_points sample_point I'm trying to inner join the sample_point data to ...
1
vote
1answer
40 views

QGIS Categorized Symbology based on joined table

I am trying to create categorized symbology for a data layer. The column that I would like to base the categories on is a result of a table join. For some reason it isn't working. All of my polygons ...
0
votes
0answers
52 views

How do I join multiple features with a single geometry-less table entry?

I have three features with the same ID, let's say "5". I also have a corresponding text table containing IDs among other info (for example a "category" value). I want to join the table with the ...
0
votes
1answer
36 views

Update the_geom field with polygons from a different table using one common field

Using CartoDB SQL API I'd like to: Update the_geom field in a table that has no spatial data by selecting the polygons from a table with spatial data and joining based on one common field.. In this ...
0
votes
0answers
29 views

Using the QGIS Graphical Modeller how can I choose specific fields to make a join based on?

I wish to join one field from a shapefile to another shapefile within the QGIS graphical modeler. I am aware that there is a 'Join attributes table' algorithm but this joins all of the fields from the ...
2
votes
2answers
121 views

PostgreSQL/PostGIS Geom to JSON with Inner Join to another table

I am currently producing JSON from a database successfully using the following query: SELECT row_to_json(fc) FROM ( SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As features FROM ...
0
votes
0answers
102 views

How to find soil names for “mukey” in USDA Soil Data SSURGO

I an trying to join the soil descriptions in the tabular data to the spatial data in ArcGIS. I have both the mukey and musym in the attribute table associated with my soil polygon layer in my map. ...
0
votes
1answer
40 views

Point inside st_dwithin with wrong results

I want to get all points, that are in the same area. Therefore, I have the following query for my table check: SELECT l.location_id, l.location FROM check l INNER JOIN check l2 ON ST_DWithin ...
1
vote
1answer
37 views

Joining Information from Point and Polygon

I tried to find the answer to this question by searching, but I was not too successful. My issue is that I have a point file of around 400 Organizations that do not have a column of county names tied ...
3
votes
3answers
79 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
24 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
190 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." ...
0
votes
2answers
58 views

Performing batch Join Field in ModelBuilder?

I have a list of 250 feature classes (X1, X2 X3, ...) which all have an individual field that I want to join to another feature class Y. The join can be established through a common field that are ...
3
votes
1answer
35 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
37 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
73 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
165 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 ...
0
votes
1answer
75 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 ...
0
votes
1answer
25 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
29 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
39 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
46 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
79 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 ...
2
votes
1answer
58 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 “ ...
1
vote
1answer
66 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
1answer
101 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
0answers
12 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 ...
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 ...
2
votes
1answer
51 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 ...
1
vote
1answer
45 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
1answer
60 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
33 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
26 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
11 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
33 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 ...
0
votes
0answers
15 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 ...
1
vote
0answers
57 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 ...
2
votes
1answer
137 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 ...