The process of connecting two or more datasets based on a common attribute or spatial location.
-1
votes
6answers
349 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/
...
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 ...
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 ...
1
vote
1answer
259 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
155 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
332 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
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 ...
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 ...
1
vote
1answer
445 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 ...
1
vote
0answers
426 views
arcpy spatial join input parameter problems
Using ArcGIS 10 SP4 with all extensions...
I have a parent directory (J:\...\spatialjoin) containing two sub-directories of feature classes I want to spatially join.
Directory 1 (target features) ...
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
...
1
vote
1answer
326 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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
1
vote
0answers
43 views
GeoJoin with ArcGIS Services
Has anyone seen any ways to dynamically join data in services. E.g. I've already exposed County boundaries in a MapService, now I want to let users join their relative data to this service for their ...
1
vote
1answer
387 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
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 ...
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 ...
1
vote
2answers
447 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
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 ...
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
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 ...
5
votes
3answers
634 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:
...
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 ...
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 ...
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 ...
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 ...
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
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 ...
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
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 ...
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 ...
