The process of connecting two or more datasets based on a common attribute or spatial location.
10
votes
4answers
4k views
Join non-spatial CSV to spatial data in QGIS
I have a csv 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 csv with ...
10
votes
3answers
2k views
How to join attributes from nearest point in QGIS?
I have two layers with points, call them A and B, each with different attributes.
For each point in A I want to join all the attributes from the nearest point in B.
Ideally this would also include ...
7
votes
3answers
3k views
How to join external tables with a shapefile's attribute table in QGIS?
I need to join a .csv table into an attribute table of a shapefile. I wanted to do this with QGIS and i don't seem to find anyway of doing it. I know that the mmqgis plugin does it, but my shapefile ...
6
votes
2answers
551 views
Difference between two layers in PostGIS
What is the right way to calculate the difference between two layers? I tried to use the following approach:
SELECT ST_Difference(river.geom, lakes.geom)
FROM river LEFT JOIN lakes ON ...
6
votes
5answers
4k views
How to join multiple records to single feature?
apologies for what I'm guessing is a really easy problem to solve. GIS user, not programmer here.
I'm trying to create a join/relate in QGIS where I have a shapefile of buildings and to that I would ...
6
votes
1answer
359 views
How to join tables without losing the original field names in ArcGIS?
I'm wondering if there is any method to preserve the original field names in Arc GIS when I join csv. tables to a Shapefile.
I ask, because sometimes I join tables with 10, 20 or even more columns ...
6
votes
2answers
472 views
Trouble with graduated symbols after joining shapefile with csv file
I have successfully joined data from a csv file to a shapefile in QGIS but for some reason I am having trouble symbolizing my data. I want to use a graduated symbology however this option is not ...
6
votes
1answer
674 views
How to perform a spatial join of point and polygon layers in PostGIS?
I have a point dataset representing households that I want to associate with a parcel layer (i.e. assign its parcel_id). With ArcMap, I could spatially join the polygons to the points and specify that ...
6
votes
1answer
432 views
Can Spatial Joins be used to perform One-to-Many Closest joins?
My situation appears rather simple, but it has given me headaches more than once already. I have a set of points and a set of polylines. I would like to use a spatial join to join the attributes of ...
5
votes
3answers
656 views
FME: Join attributes in text file with attributes in SHAPE file
I have a SHAPE file with points and different attributes - one attribute MyID. I also have a plain text file with several attributes - each in a separated column:
MyID MyValue
1 A
2 B
3 C
...
5
votes
3answers
635 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:
...
5
votes
5answers
729 views
Spatial Join on two point featureclasses produces empty output featureclass
I have two point featureclasses that intersect each other. They are in the same projection and dataframe. The issue is, when I perform a Spatial Join the output point featureclass is empty. The file ...
5
votes
2answers
2k views
Trouble creating a query table
I need to join one feature class and one table. This is a one to multiple join, therefore, my only option seems to be by creating a query table. My problem is that the fields I want to join do not ...
5
votes
2answers
68 views
How to enumerate join values with ArcGIS?
I have two shape files (e.g. postal code areas and cities) which I want to join based on an id that both shape files have in common (the id would be the city name in this example). Joining the two ...
5
votes
1answer
650 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 ...
5
votes
2answers
697 views
Creating polygons from a one to many relationship of points
I have a set of polygons that are in a one to many relationship with points.
The polygons are administrative boundaries and the points have information on companies and percentage of ownership .
I ...
5
votes
3answers
362 views
How to close multipart polyline gaps in ArcMap
I have a multiple multipart contour lines that originally came from CAD drawing. I converted these into a polyline shapefile in ArcGIS. The issue I have is with gap in each contour lines that are ...
5
votes
1answer
210 views
How do I avoid text field truncation when saving a table join?
Using QGIS I've joined tabular text data (all in fields of less than 255 characters) to a shapefile via a CSV file. All looks good in the joined table but when I save to a new shapefile to make the ...
5
votes
1answer
455 views
How to merge linestrings that don't touch based on common name?
I had a table of road line strings that contained duplicate road names with different geoms for different line segments. I extracted the duplicates to another table. I now want to join these segments ...
5
votes
1answer
172 views
Reading an Existing Join
Confused again. I was finally able to run ArcCatalog and create a join in my map document (I will do the deed programmatically eventually) but I was interested in how a join looked once it was ...
4
votes
1answer
299 views
ArcObjects joins and non-persistent fields after joining to multiple tables
I have inherited a truly awful and very large ArcObjects project that was originally written in VB and then ported to C#. Apparently the source code I have been given is not the latest version and I ...
4
votes
1answer
378 views
Spatial Join in PostGIS according to Line Attribute
I am in the process of building a data warehouse in PostGIS, that will store the length of the road network of a country (Lines) per Administrative Area (i.e. Province or State, referred to as AA ...
4
votes
2answers
281 views
How do I correctly perform a spatial join between lines that travel along each other in ArcGIS
I have 2 layers, one representing streets, and one representing pipes. The pipe layer has a street field that I want it to be automatically filled (I want the pipe to show the street that it's on) I ...
4
votes
3answers
245 views
How to join two tables using date, time, lat and lon as common field?
I am sorry if the question is elementary but I did not find any clear discussion or guide to understand how to run a query in postgresql. So that a pointer to another website would be also useful. ...
4
votes
2answers
2k views
One-To-Many Table Relate Viewed Through ArcGIS Server
I want to create a Table Relate with a one-to-many relationship between a layer and a non-spatial table based on a common field.
My question is, if I publish this data to ArcGIS Server, will an ...
4
votes
1answer
68 views
How do “join field” and “target field” work?
New user. This should be simple, but I can't figure out how to perform this basic join in QGIS. (It works in Cartographica.)
My shapefile (IL_BNDY_County_Py) has two fields/columns in its attribute ...
4
votes
1answer
93 views
Join a table to a parcel layer and get duplicate parcels, reflecting individual leases
I have a table of 3,000+ lease files that I'm trying to join to our parcel layer. Each parcel has 4+ leases associated with it, and I need each to be represented by an actual polygon. When I do a ...
4
votes
1answer
1k views
Spatial distance join between polygon and points using R?
I'm figuring out how to do a Intersection (Spatial Join) between point and polygons from shapefiles. My idea is to get the closest points and those points that match completely inside the polygons. In ...
4
votes
3answers
804 views
SDE views not showing values in joined table
I created an SDE view between a point feature class and a table (stored in SDE) - the join is done on a text field called RFRNC. I changed the view so that it is now a LEFT OUTER JOIN in line with ...
4
votes
0answers
125 views
How to join fields which must still be created in ArcGIS Model Builder?
I am in the process of creating a generic model in ArcGIS Model Builder. At one point in my model, I have to do a join between an existing layer (entry parameter) and a table issued from the "Zonal ...
3
votes
7answers
8k views
Having problems with joining an excel table to a shapefile in ArcMap
I have a shapefile of lower layer super output areas (LSOA) for England and Wales and I have a spreadsheet of the indices of deprivation for each of the LSOA's in England. I want to join the ...
3
votes
3answers
464 views
Copy dbf data into a shapefile in Arcpy
Basically it's to perform a one-to-many join in a python script, from a dbf to a shapefile. I saw (Greg Krakow's method) using QGIS, but I can't use it (I'm working on it, but QGIS is not yet ...
3
votes
1answer
149 views
How to use a search cursor on a joined table in ArcMap?
I'm struggling to get a search cursor to work on a joined table view.
I've used search cursors before, but never on data that has been joined.
Arcpy keeps saying that some of my joined fields don't ...
3
votes
1answer
1k 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 ...
3
votes
1answer
573 views
Help with joining a large dbf file to shape file
My overall objective is to create a timeline animation depicting when a person is working in a particular region. The .dbf table consists of over 6000 record entries of shift data, including date ...
3
votes
2answers
77 views
How can i spatially add text to feature in argis 10?
I have alot of text that write with drawing tools and same feature . i want to find a method to add texts to features spatially like spatial join for feature to feature . is there any method to add ...
3
votes
2answers
248 views
How to create polyline feature from two input points by following/tracing another polyline?
I have a list of things each have two grid references, start and stop points. I can turn these into points and join them with polylines.
But what I need to do is have the lines that join the points ...
3
votes
1answer
112 views
Deep merge data from multiple layers
Let me explain what I mean by "Deep Merge" and what I am trying to do.
Suppose that I have 3 layers (Layer1, Layer2 and Layer3) with the same field names (field_a, field_b and field_c). For any ...
3
votes
0answers
30 views
Adjacent DEM files have narrow triangular gaps when joined
Newbie here. I've downloaded several DEM files from GeoCommunity which correspond to adjacent regions. When I join them together to form a larger relief map there are triangular 'gaps' on all four ...
2
votes
2answers
411 views
Join Issue with Attributes Table
I am trying to Join a Mineral Database (excel) into my Attributes table. Once I do and check the Attributes, it shows up as "NULL". What is causing that, what am I not doing?
Can anyone offer ...
2
votes
1answer
134 views
Why can't I use a Join in a model?
I'm trying to build a model using Model Builder in ArcGIS 10.1 that starts off by joining two shapefiles together based on a common field. I would like to make this open ended (not hardcoded) so I can ...
2
votes
3answers
431 views
vector tool missing when install QGIS 1.7.4 on new computer
I installed QGIS version 1.7.4 a few months ago. Under the menu Vector > Data Management Tools I have two options to make a join: 'Join Attributes' and 'Join attributes by location' (see screenshot).
...
2
votes
1answer
117 views
Joining Excel with arcmap by model builder
I am trying to use the model builder tool in ArcMap 10.
I would like to join an Excel file (xls) with a shp.file.
The Excel file and the shapefile have one identical column with data but the ...
2
votes
2answers
188 views
ArcGIS Geoprocessing: Join multiple fields to a table and export new table as join field name
I am bit new to geoprocessing and ModelBuilder.
I am using join field tool to join table (info tables/.dbf) to one a shape file.
I am trying to use ModelBuilder, as there are around 100 tables (each ...
2
votes
2answers
71 views
Why does ArcMap crash if I try this Join Field (which ArcPy does not like either)?
I'm a little uncertain whether this question belongs here or on http://gis.stackexchange.com
Have an "AddJoin" that results in no shared records, which is not what I'm expecting. Is it because I'm ...
2
votes
1answer
232 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
1answer
112 views
joining a table from zonal statistics as table with a layer, problem with reserved names
I have a raster file (percentage of total forest killed) and a shapefile with polygons (municipalities). I thought as a first step I would like to find out which municipality shows the greatest ...
2
votes
2answers
102 views
Joining lines in MapInfo that won't be split by disaggregate?
I have just run a disaggregation a .tab containing just lines and found I have a few with duplicate IDs. However when I zoom in these lines appear to be connected. Is there any way to join these ...
2
votes
1answer
215 views
Counting occurrences across a record in ArcGIS 10.0
I'm a student at Millersville University, PA studying for a BA in Geography with a concentration in GIS. I've stumbled across this site for questions I've had over the past year or so with getting ...
2
votes
3answers
510 views
How to join a WFS layer to a stand-alone table in OpenLayers
I'm a complete novice at OpenLayers, and am checking whether the following is possible.
I envisage a dataset of polygons in GeoServer, being served as a WFS layer into OpenLayers. The polygons won't ...
