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

learn more… | top users | synonyms (1)

0
votes
1answer
73 views

Join line segments sharing a common attribute, using GDAL

I'm having trouble rendering a shapefile consisting of trail routes broken down into many short segments. So I'd like to combine them into a small number of line features, which share a NAME and touch ...
1
vote
0answers
64 views

Export Joined table an Feature layer based on a query

I have a table and a layer joined fine, I am trying to export the end result into a file geodatabase, the export is fine if I specify specific name, other than that it exports the original layer data. ...
1
vote
2answers
462 views

How to join a File Geodatabase table with only one record of Feature Class

I've a Geodatabase containing a Featureclass and some File Geodatabase Tables. Each File Geodatabase Table is actully about the only one record of a featurClass. Can We Join these File Geodatabase ...
0
votes
1answer
69 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 ...
0
votes
1answer
1k views

MapInfo SQL: Selecting all columns from one table, some cols from second table?

I'm fairly adept with the SQL Select in MapInfo, but I'm running into something that's got me a bit stumped. I've got data in two tables that have a few columns in common. I want to join the tables ...
0
votes
0answers
21 views

Adding values from a text file to a gridded area on my map [duplicate]

I have a .txt file with comma seperated values. Each individual value corresponds to a cell in my grid. The first value in the .txt file corresponds to the cell in the first column and first row of my ...
1
vote
1answer
97 views

Joining Parcel/Building Attributes Based on Coordinates

GIS noob here: I downloaded a building footprint shape file for a city and imported it as a vector layer in QGIS. I was hoping to see street address information in the attribute table, but there was ...
1
vote
1answer
117 views

Adding data from a table to a grid in ArcGIS

I have a table with 720 rows and 156 columns. I have a grid with 720 rows and 156 columns. I would like to assign the values from the table to the corresponding values in the grid. I am a beginner to ...
1
vote
2answers
90 views

Spatial Join returning max value and unique ID

Using ArcGIS 10.3 I have a dataset containing polylines of a pipe network, along which I have a polygon layer representing a burst every 50m. The burst layer contains a value (p) and a unique ID (the ...
0
votes
0answers
18 views

Join based on approximate area

I am trying to join information from a table to information from a feature class based on "approximate area". I have drawn (on-the-fly) building footprints, multiple footprints per parcel. I have "...
1
vote
1answer
816 views

arcpy JoinField_managment RuntimeError

My script is supposed to pull weekly flu data from a department of health website, parse it for that week, and then push the data up to our ArcSDE server so that it can be displayed on our Web Mapping ...
1
vote
1answer
153 views

why the values are NULL if I join the csv table to a point shp file [closed]

So my problem is all values are NULL if I join my csv-table to a point-shape-file. (QGIS) Why? I tried so much thing but I can not find and handle the problem. I have customer names in the csv, ...
0
votes
1answer
64 views

Exporting KML from QGIS with relation (one-to-many) table as popup

Here is a challenging one for someone. I have two tables in QGIS. Holes (parent) - Which contains the borehole locations. Strata (child) - which has many rows that contain the strata for each ...
0
votes
0answers
347 views

Multiple LEFT JOIN in PostgreSQL

I got a "nice" problem with a query in PostgreSQL with a multiple join SELECT DISTINCT "Monitoraggio_L001_L008_2015_aprile"."ID", "Monitoraggio_L001_L008_2015_aprile"."Ordine", "...
1
vote
2answers
64 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
167 views

Joining shapefiles based on FID in QGIS [closed]

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
77 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: http://www....
4
votes
1answer
1k 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
0answers
100 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
37 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
80 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 e.g....
0
votes
1answer
129 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
7
votes
3answers
8k views

Creating join based on multiple fields using ArcGIS Desktop?

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

How to improve join between shape and view?

I have a problem with a simple join and I don't know what to do: I have a shapefile with 400,000 parcels, in this shape I have only one column with the parcel id with an index. I have a Materialized ...
13
votes
1answer
2k views

Why do simple joins on small datasets slow down ArcMap so badly?

ArcGIS 9.3.1, ArcInfo. I have some small file geodatabase and SDE featureclasses (few thousand records each, 50 columns) that I am doing attribute joins on. After the joins, drawing of the map is ...
1
vote
1answer
847 views

Slow performance with Add Join and Calculate Field?

I have a point layer and a table with approximately 100 fields. I need to join the table to the point layer based on a key field and create a new shapefile / feature class. This script has been ...
0
votes
0answers
55 views

QGIS table join with multiple fields [duplicate]

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 ...
2
votes
1answer
1k 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
0answers
47 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
248 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. ...
1
vote
1answer
65 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
1answer
545 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 ...
3
votes
2answers
402 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
122 views

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

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
151 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
2k 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
119 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 (l....
1
vote
2answers
251 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 ...
1
vote
1answer
42 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
139 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
207 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
924 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
63 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
542 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 spatially,...
3
votes
2answers
928 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: "...