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

learn more… | top users | synonyms

1
vote
2answers
630 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
216 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
109 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
114 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
49 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
46 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
174 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
2k 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
600 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
2k 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
760 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
167 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
347 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
212 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
245 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
758 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
294 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
248 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
583 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
595 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
969 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 ...
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
549 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
426 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 ...
2
votes
1answer
720 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 ...
12
votes
2answers
8k 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 ...
-1
votes
6answers
418 views

Which program that merges excel data onto shapefiles is easiest to use?

some options for merging looks like fusion tables, vizmaps, and these 2 http://mapbox.com/tilemill/docs/guides/joining-data/ ...
1
vote
1answer
522 views

Joining tables with merge rules in ArcGIS

I have two tables in ArcGIS that contain a mutual unique identifier, which the join will be based upon. However, table2 has multiple records of the unique identifier. There is another field in table2 ...
2
votes
0answers
311 views

ArcObjects : How to change layers connection properties without losing joins

I'm using arcObjects 9.2.6 java librairies to change connection/path properties within a java prog. This prog aims to change path and connection properties for all layers of an mxd file. It works well ...
1
vote
1answer
509 views

Enhance performance of a join query for mapnik using postgis

I use mapnik to render map with datasources from a postgis database. One query is a join on two table, one with a geometry (a polygon) and the other one with some fields I want to use for rendering. ...
4
votes
1answer
594 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 ...
1
vote
1answer
554 views

Join attribute table

I am using QGIS 1.7.3 on Mac and when I try to use the tool "join" in the properties toolbox, I have no possibility to add a name for either the file or the field used to join tables. Has anyone ...
5
votes
3answers
2k 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 ...
1
vote
1answer
773 views

Linking SharePoint database with ArcGIS…possible?

Ok, so I the organization I am working for has a sharepoint database that multiple people update every time they do an inspection of natural resources on a parcel in the county. This database has the ...
7
votes
5answers
8k 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
809 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 ...
8
votes
1answer
2k 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
2k 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 ...
1
vote
1answer
761 views

How to join an external table to a set of polygons, and symbolize on the joined values, in a web map?

Say I have a table showing a number of statistics - for example, various gun crime by US State measures. I also have a dataset of state boundaries. How can I join the table to the features in a web ...
5
votes
1answer
684 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 ...
4
votes
1answer
583 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 ...
1
vote
2answers
636 views

Join/Relate in ArcGIS 9.3.1 ArcEditor through a python script - is it possible?

I'm working on a ArcGIS 9.3.1 ArcEditor and I want to write a python script that will do a Join or Relate. Problem is, that join table\join field are restricted to ARCINFO (higher license), and relate ...
5
votes
1answer
213 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 ...