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

learn more… | top users | synonyms

3
votes
1answer
960 views

Creating a spatial “Many to one” join

I'm trying to create what I call a "many to one" join. I don't know if that would be the correct term or not. I have a table that has unique account numbers for mobile homes (i.e. - M1007970) per ...
1
vote
4answers
94 views

Add only unique features from another shapefile

I've got a problem that I am sure at least one of you have dealt with. I'm new to a company that makes use of a rather large database of point data. For whatever reason, the woman who was here before ...
7
votes
5answers
508 views

How to programatically identify the “Joined Field” in ArcMap?

Is it possible to programmatically identify the Join Field that is being used to Table Join two datasets together in ArcMap? I am currently using ArcGIS 10.0, SP5 and would prefer an ArcPy solution, ...
2
votes
0answers
97 views

QGIS - How to avoid -2147483648 value from imported CSV?

I am attempting to join a spreadsheet containing all the CIA Factbook Country Comparison Data (many columns) to the existing Natural Earth world countries shapefile. I followd the tutorial here, but ...
0
votes
0answers
195 views

PyQGIS joining a dbf to a shapefile

I am trying to join a shp and dbf file using the PyQGIS API. The code I'll use is below: from PyQt4.QtCore import * vector1 = QgsVectorLayer("path to dbf file", "test1", "ogr") id1 = vector1.id() ...
0
votes
1answer
68 views

Why is ArcGIS for Desktop not joining records when values have dot (.) in text string?

ArcGIS is not joining records from a table that have a dot (.) in the text string. Has anyone else come across this problem? Is it a known issue?
2
votes
2answers
218 views

ArcMap | Perform full outer join

Hey there, does anybody know how to perform a full outer join with ArcMap? Just to describe the problem a little bit more, lets say I got the following two tables: Table A Joinkey 1 2 3 Table B ...
2
votes
1answer
62 views

After joining data from csv file to shapefile, why are all values zero in categorized renderer?

I have joined data from a csv file to my shapefile. The attribute table shows a successful join. I have converted the variable of interest to INTEGER. But when I go through Style to categorize the ...
2
votes
1answer
169 views

QGIS join data not transferring

I'm reanalyzing data from a VA Late Woodland Palisaded Village. The site is mapped in CAD and exported as a shapefile. QGIS brings up the 1059 features as polygons. I am using a CSV file for the ...
0
votes
0answers
439 views

How to do a spatial join if QGIS 1.8 keeps crashing?

I am trying to perform a simple spatial join (adding polygon data to points) in QGIS 1.8: target vector: points join vector: polygons take attributes of first located feature keep all records ...
1
vote
1answer
1k 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 ...
5
votes
1answer
370 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 ...
0
votes
0answers
38 views

multiple data atach with shape file in GIS-regarding

I have different sampling data of one location that is a point so, multiple data how to join with single point. after joining i need quries by select attribute in GIS.
0
votes
1answer
2k views

Merge attribute of points into a polygon : Arcmap 10

I have points layer which the attribute looks like this: FID Shape ID Lat Long 0 Point 2065 -5.51666 106.48333 1 Point 2319 21.93333 120.73366 I also have polygons layer : FID Shape ...
2
votes
2answers
435 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
2answers
315 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 ...
1
vote
1answer
590 views

How to merge different classes/clusters in one single raster in arcgis 9.3?

I've created a signature file with 8 clusters and performed an unsupervised classification. Later I have grouped values (spatial) classes together to form 4 classes I needed (in symbology) but that ...
2
votes
1answer
680 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 ...
1
vote
2answers
543 views

SearchCursor (arcpy.da), accessing data on joined tables

Can you access joined tables through a da.SearchCursor? I've found documentation to do this with SearchCursor (arcpy), but nothing for the 10.1 data access module.
1
vote
0answers
180 views

Quering a ArcSDE featureclass attribute table after joining

I am trying to query a ArcSDE Feature Class after joining using Iqueryfilter I have two SDE feature classes. 1) Subdivisions : which has details of subdivision and districts (parent) 2) ...
1
vote
0answers
97 views

Join .csv file and .shp of georeferenced points

I have georeferenced a map and saved a selection of some points on the map. These points are cities of departure and arrival and I want to join the .shp with a and excel .csv with the information of ...
2
votes
1answer
104 views

Join attributes by date in Qgis

I learned (thanks!) to use the join feature built into the layer properties, but in my case it doesn't work because data do not match perfectly. Infact shape refers to geotagged photos, csv is a log ...
2
votes
1answer
2k 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 ...
6
votes
2answers
1k 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 ...
0
votes
1answer
47 views

How to use classified styles with joined layers?

I am trying to set a color range based on this tutorial In LAYER PROPERTIES for "new", in JOINS, I have joinlayer - data-join joinfield - GEO_ID2 targetfield - GEOID10 Where "new" is my shapefile ...
3
votes
0answers
42 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 ...
1
vote
0answers
70 views

Join field from table to a raster layer

I'm trying to join a field in a table to a raster layer. I'm using the tool 'Join Field'. The table is in a excel sheet, but have been imported to a file geodatabase. The table has an ObjectID field ...
4
votes
1answer
148 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 ...
0
votes
0answers
57 views

Adding a new attribute to shapefile from Excel sheet [duplicate]

I have a shapefile in QGIS and I needed to add a attribute to the attribute table. The problem is that I have the information I need to add in an Excel file. How can I add the information from the ...
2
votes
2answers
1k 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 ...
1
vote
3answers
475 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 ...
4
votes
3answers
1k 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. ...
3
votes
0answers
702 views

How to join data from a CSV to a shapefile using QGIS

I'm new to GIS and new to StackedExchange. I need help joining a CSV of Accessibility data to a LSOA shapefile in QGIS. The process explained here does not work for me and I don't know why. The ...
0
votes
0answers
155 views

MS Access join table values, not recognized by ArcGIS symbology

I joined a MS Access database table to a GIS file. When I try to use symbology (categories) to represent a yes/no value which is in the table file (0/-1) it does not recognize it as a value.
1
vote
1answer
288 views

arcpy JoinField_managment RuntimeError

So, I've been banging my head against the wall the last few days trying to figure out what's wrong with my script. It's suppose to pull weekly flu data from a department of health website, parse it ...
1
vote
2answers
179 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
0answers
230 views

How to Query Parks in GeoNames and Combine it With a Polygon Layer?

I run a hiking site and would like to get parks where you can at least have a nice walk. That means they should not be playgrounds, stadiums, and probably be bigger than 3 square city blocks at least. ...
2
votes
3answers
714 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 ...
2
votes
1answer
244 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 ...
4
votes
1answer
217 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 ...
5
votes
1answer
506 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 ...
8
votes
2answers
1k 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 ...
2
votes
3answers
563 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). ...
3
votes
2answers
93 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 ...
1
vote
2answers
744 views

One Polygon Joining to Database with Many matching records

Using ArcMap 10.1. Is this possible to have one polygon and join to a database/excel with many matching records? I would like to have 1 polygon but match to 100 corresponding records in a table. When ...
1
vote
0answers
270 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 ...
3
votes
3answers
1k 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 ...
5
votes
5answers
1k 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 ...
3
votes
2answers
498 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 ...
1
vote
0answers
384 views

Should Delete Field work in ModelBuilder while there is a Join present that appears unrelated?

I am having an issue with a very simple Model, both in ArcGIS 9.3 and ArcGIS 10.0. The part of the Model that is causing trouble is shown below, along with ModelBuilder's error message (in ArcGIS ...