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

learn more… | top users | synonyms (1)

4
votes
2answers
2k views

Join a CSV file to shapefile using gdal/ogr?

I have a shapefile with several attributes, for example YEAR, COUNTY, and AREA. I also have a CSV file with more fields that I want in the shapefile, such as POPULATION. Both the shapefile and the CSV ...
0
votes
1answer
7k 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 ...
0
votes
1answer
36 views

How do I make a field of summarized zip codes, 1 for each, put it into my data table and join the table to shapefile without losing data?

I'm trying to use a field in my shapefile with summarized zip code data. I have a table of hospital admissions data and in this table there is a field of zip codes which are repeated multiple times. ...
1
vote
1answer
19 views

Error on join in ogr2ogr

I am doing an ogr2ogr process where i will be making a join between two tables, imported as shapefiles and .csv to join on a column with idential attributes. The code i've made so far looks like ...
2
votes
2answers
200 views

One-to-many join in QGIS

I am looking for a possibility to make a one-to-many table-join in QGIS. I have a shapefile with postal codes and would like to join them with survey results (more than one). In other words, there ...
4
votes
1answer
90 views

Join / merge lines that touch and intersect in QGIS

I have a large dataset consisting of lines/polylines where I would like to join/merge the lines that touch / intersect. Each line has an individual ID and there are no common attributes I can use for ...
3
votes
1answer
57 views

Attaching Excel sheet with different language font(hindi) to shapefile

When I try to join a excel sheet with Hindi font to a shp file, I get '?????' as a result in those cells which has Hindi font. (Before/Aft images attached) I tried changing the locale language to ...
1
vote
1answer
65 views

Why does joining all layers in a group not work?

I am attempting to re-join all layers within a group to another layer ("Main.shp") outside of this group. The idea is for users to change values in one of the group's layers. As these layers are ...
10
votes
6answers
15k views

Joining multiple records to single feature using QGIS?

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 ...
2
votes
1answer
33 views

How to doing spatial join for several rasters

I have four rasters, each of 32 bits (single band), with the same cell size, the same number of rows and columns and identical extension. I need to make something like a "Spatial join", I mean, I need ...
1
vote
1answer
273 views

Join traffic data (point) to a road network (line) - Section between two roads - ArcGIS

I am trying to analyze the vehicle traffic in Melbourne's (AUS) road network. I have two files: the traffic data (point data for a given latitude and longitude with the average hourly traffic between ...
-2
votes
1answer
40 views

Simple join not working

I am joining a large excel spreadsheet to a feature class. Both have a little over 8,000 records. I have gotten this particular join to work before, unfortunately I had to redo it. This time I cannot ...
0
votes
1answer
26 views

How can I combine together cells within the same raster in ArcGIS 10.2?

I have a raster displaying Land Cover data for the UK at a cell size of 25m. The cells are currently categorised as one of 24 different types of land cover. Some of these are irrelevant to me, and ...
1
vote
0answers
43 views

Arcpy: Delete rows from joined table

I would like to delete all rows which are joined to a layer from a csv table. Only the joined records which match (keep only matching records) should be deleted. After the records are deleted, the ...
2
votes
1answer
60 views

Arcpy Join field options

I am looping through Municipalities and clipping a layer called AllZones containing Multiple Facility (FACID) with multiple chemicals per Facility (CID). 1 to many relationship FacilityID, ...
4
votes
1answer
62 views

How to use joinFieldNamesSubset from QgsVectorJoinInfo class

I have written a small python plugin to refresh a join on a point layer in QGIS. point_layer=None for lyr1 in QgsMapLayerRegistry.instance().mapLayers().values(): if lyr1.name() == "point_layer": ...
1
vote
0answers
25 views

QGIS: Join by Location: Option to retain all attributes of spatially related objects of my join layer [duplicate]

I am facing the problem that I want to join the attributes from one specific column of ALL intersecting features from my join layer to my target layer in case of an intersection (1:n relationship) ...
1
vote
1answer
544 views

Join and Calculate vb.net

I'm trying to join an excel table to a shapefile and then calculating those fields using vb.net. The code I have written has no errors, but won't work when I try it in ArcGIS 10.1 and I'm out of ideas....
0
votes
1answer
232 views

Why aren't my hyperlinks saving in ArcGIS 10.2

I have a polygon layer and I have a joined table with a link to an excel document for each polygon. Under the "Display" tab in layer properties I check the "Support Hyperlinks using field:" box and ...
4
votes
2answers
902 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
1answer
35 views

Arcpy Freezing on Field Calculation

I am trying to populate a grid with the number of features in each grid cell. I've gotten this script to work with a subset of the data, but when I try to run it on the full (52,000+) cell feature ...
4
votes
2answers
1k views

Using Spatial join for many to one relates in ArcGIS for Desktop?

I'm trying to do a spatial join that takes the attributes of multiple polygons and applies them to a single polygon in another layer. The data is currently in a geodatabase, but can be exported to shp ...
3
votes
0answers
57 views

How to access attributes from linked tables (QGIS 2.14.2 Essen)

I have one source shape file like this: It consist the geographical coordinates of weather stations: And several attribute files, wich contain the Temperature data of each date for several years ...
0
votes
0answers
31 views

Using a join in Arc with feature classes containing a definition query always return an inner join

At Arc 10.4, I am attempting to do an outer join (using the "Keep all records" option) between two file geodatabase feature class layer tables. Each of the two tables has an identical Definition ...
3
votes
1answer
30 views

Joined table fields don't work in print composer?

I am trying to use the attributes of the current atlas feature, which is from a joined table. In the expression builder it shows the correct value, but the result is blank when I actually try to ...
0
votes
1answer
39 views

after to make join between 2 tables a field is not recognize [closed]

I made join between two attribute tables with a common field and then I tried to use python to read a field and now field is not recognized on the new table.. Is it normal? How can I solve this ...
3
votes
3answers
74 views

Joining Excel File to ArcMap

I'm trying to join an excel file to ArcMap. The information in the excel file is clean and doesn't contain any characters that might hinder the joining process. However, when I join the file, all of ...
1
vote
1answer
22 views

Search and Update Cursor Automation: Avoid <Null> Values and Recognize Data Values

I am attempting to Search Cursor through a joined table. (I do not have access to the original separated tables) If the value of "COMPANY" and "DATE_" are then they will be skipped and it is ...
1
vote
1answer
64 views

Postgis spatial join performance (point on area)

I need to update a single attribute of a large table of point data with a result of a spatial join (point on area operation) on a polygon table. I'm using the below query but wondering if this is the ...
2
votes
0answers
43 views

Unable to add feature class based on database view in ArcMap

To solve Rendering features based on relationships using ArcGIS for Server?, we created a view in the database that joins the two tables together. That works fine. I see the feature class in ...
1
vote
1answer
18 views

Processing “Join by attribute” issue

I don't know what's going wrong when I try to join a shape file with an xls or csv. I do have the same identifier in both files. The joined file has all the expected columns but they are all empty. ...
1
vote
1answer
26 views

How do I combine missing data in one table with another?

I have two tables. I need to join data from table A to table B. Both tables have the same field names and same set of data, except Table A has quite a few rows of data that table B does not have. The ...
1
vote
2answers
53 views

How can I display my Excel file in Arcmap 10.4?

I am currently working on a project. I have created an excel spreadsheet: So, I need to attach the spreadsheet into ArcMap 10.4 and show the states population percentage. I have already created a ...
3
votes
0answers
55 views

Using one to many join to *.xlsx in ArcGIS Desktop? [on hold]

I'm working with ArcMap 10 and have some trouble joining a shapefile and a .xlsx file. The .xlsx contains sensor data (CO2, NO2 etc.) without location information. The shapefile contains all the ...
0
votes
1answer
25 views

Identifying the closest polygon to a point dataset

I have two large data sets one point and one polygon. What I was looking to do was identify which polygon is closest to each point. Hopefully I was looking for a automated process as the point data ...
0
votes
0answers
50 views

Updating attribute data based on another layer and key field?

I currently have two polygon layers (one building layer and one property layer). The information for the property layer is updated and supplied by an external source. In the building layer, I use a ...
2
votes
1answer
47 views

QGIS Join table with shp file. Get Null Values on the join fields

If my problem is that my ID types are not the same, I need help in addressing that. I started with an excel file, I read that on a mac to I need to save that as a Windows comma Separated file. I did....
3
votes
1answer
34 views

Positional join with multiple overlaying geometries, each containing a different attribute

I can't find any documentation on how a spatial join in QGIS is working on the following situation: An area layer is being spatially joined with a polyline layer in order to compare attributes of ...
2
votes
1answer
90 views

Why do layers with different CRS overlap fine but cannot be merged by location?

Perhaps someone could clear this up for me? I have a shapfile with the CRS Selected CRS (EPSG:29902, TM65 / Irish Grid) I also have a number of XY points which take the CRS, Selected CRS (EPSG:4326, ...
3
votes
1answer
42 views

ArcGIS Add Join Not Working?

Im currently working on a ArcGIS ModelBuilder Project where I want to use "Add Join" to look through a list of species (Table 1: converted from excel -> Make query table -> Copy rows (to get index)) ...
1
vote
0answers
25 views

Joining a table with an If/Then Statement

I want to join two tables in ArcMap, but not every feature has the same common attribute in the two tables I want to join. For example, "Feature 1" is in both Table 1 and Table 2 and both tables have ...
1
vote
1answer
57 views

Calculate Field not saving on joined layer

I'm joining a table to a layer file, calculating a field in the layer and then removing the join. The code below runs with no errors, but when I check the field in the attribute table, nothing has ...
1
vote
4answers
2k views

Joining shapefile table with csv

So I am having a shapefile with all the world countries. And the table for this shapefile has a column named "Country Name". Each of this entry is unique, meaning, each country takes only 1 row, and ...
1
vote
1answer
29 views

Joining attribute data from one layer to another layer in QGIS 2.12.2-Lyon

I have a polygon vector layer that I am trying to join its attributes to a point vector layer. The problem is that the polygon layer consists of grids that are numbered 1-150 (ID) and I am trying to ...
2
votes
2answers
68 views

Output shapefile has no records after joining shapefile with table and exporting result?

I have successfully joined a .xls Excel spreadsheet to a shapefile. The join is successful (the number of remaining records seems accurate), although it takes a really long time (like 20 minutes). For ...
3
votes
1answer
173 views

How to use QGIS Graphical Modeller to join specific fields?

I wish to join one field from a shapefile to another shapefile within the QGIS graphical modeler. I am aware that there is a 'Join attributes table' algorithm but this joins all of the fields from the ...
2
votes
1answer
48 views

Expand Street Network passing through points using QGIS?

I have a road network (red) passing through some traffic data points (green): I want to expand this network to include all of the points. I already have a bigger street network (blue) from which I ...
2
votes
2answers
85 views

ArcPy: Excel to Table Conversion and Join Management

I am trying to join an Excel table to a shapefile in ArcPy. My first step is to convert the Excel sheet to a table, but I am receiving an error: #Convert xlsx to table: import os import xlrd import ...
1
vote
0answers
18 views

CartoDB geom (coordinates) join: without exact match

Trying to join two datasets (layers) on CartoDB based on their geographical fields (in CartoDB's the_geom created field). However, the basic ST_Intersection function does not work since its tolerance ...
1
vote
1answer
86 views

arcpy join csv files to raster attribute table

In arcpy, I'm trying to join an list of .csv files with data of emissions per country, with the attribute table of a raster in order to make lookup tables later on. So far this is my script: ...