The process of connecting two or more datasets based on a common attribute or spatial location.
1
vote
0answers
22 views
How to join two fields after calculating ?
I have been working with two layers and I am trying to join them and turn them into a raster data. The first layer is a watershed layer which I have assigned each shed a location from the center point ...
1
vote
1answer
43 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
1answer
63 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
68 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 ...
1
vote
1answer
56 views
Joining table to shapefile with pyQGIS
Joining shapefiles is a relatively straightforward proess in QGIS using 'add vector join' in the layer properties menu. I can add a csv file as a vector layer, as well as a shapefile, and join the two ...
2
votes
1answer
116 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
0answers
43 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
42 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 ...
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 ...
1
vote
1answer
58 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 ...
1
vote
2answers
82 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.
2
votes
1answer
131 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 ...
1
vote
0answers
34 views
Can i use self join in a table of feature class(ArcGIS - ArcInfo)?
I read an article about self join (pros and cons) in databases. It was very interesting for me and raised a question about self join in Geodatabases. I surfed on the internet but I couldn't find 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 ...
0
votes
1answer
30 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 ...
1
vote
0answers
51 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
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 ...
0
votes
0answers
52 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 ...
1
vote
3answers
118 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 ...
1
vote
2answers
155 views
Creating non-spatial Many to One Joins/Relationships between tables
I may have missed a trick here but I can't seem to find a solution.
I have a table of ~1.6 million postcodes, also containing co-ordinates, and a separate file detailing ~6000 a population with ...
4
votes
3answers
240 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. ...
2
votes
0answers
190 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 ...
2
votes
2answers
186 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 ...
0
votes
0answers
72 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
76 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
80 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 ...
5
votes
3answers
359 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 ...
6
votes
1answer
350 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 ...
4
votes
0answers
123 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 ...
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 ...
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 ...
3
votes
1answer
148 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
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 ...
1
vote
2answers
185 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
1answer
133 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 ...
1
vote
0answers
157 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
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
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 ...
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 ...
1
vote
0answers
162 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
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 ...
1
vote
3answers
1k views
Merging multiple .tab files?
I was wondering if there was a quick way to merge multiple .tab files together? I have about 100. Would appending one tab to another with the MapBasic window open, then changing the name of the table ...
0
votes
0answers
256 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
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 ...
1
vote
1answer
258 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
154 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 ...
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 ...
6
votes
2answers
469 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
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).
...
