To join the attributes from one spatial data layer to another

learn more… | top users | synonyms

0
votes
0answers
20 views

Cannot access/store to default gdb from arcpy

I have a python script executing spatial joins for x input shapefiles from the user. The output should be stored in the default geodatabase - this is, because the join is done multiple times and the ...
1
vote
0answers
21 views

Merging multiple fields with same parcel id yet different attribute values, while keeping all fields?

I am using ArcGIS 10.3 for Desktop. I have a property parcel layer that when Intersected, each parcel is broken up into hectares of different land covers. My question is can this be merged (or ...
1
vote
0answers
28 views

Spatial Join - Field mapping to delete and rename fields

I have a python script where the user can enter a study area (Polygon shapefile) and multiple point Features of interest (Point shapefiles). The point shapefiles are looped through and joined with ...
1
vote
1answer
20 views

Spatial join for multiple shapefiles (loop)

I have the following two datasets: - polygon shapefile containing administrative boundaries of a City - multiple point shapefiles What I want to do is to spatially join the point shapefiles with ...
1
vote
0answers
16 views

geopandas spatial join: how to find problematic row?

I have an sjoin function from geopandas that is behaving erratically: it works on some version of the "points" geodataframe but not others. merged=sjoin(points,polygons, how='left',op='within') ...
1
vote
1answer
42 views

QGIS: getting NULL values when using “Join Attributes by Location” of lines and polygons

I'm using QGIS 2.12.3-Lyon. I have a polygon layer (~130k square polygons with some small overlaps) and I have imported a road network from OpenStreetMap (via Geofabrik, ~141k road segments) for my ...
2
votes
0answers
26 views

Spatial Join Hangs on Two Specific Shapefiles in QGIS 2.8

I have successfully done spatial joins with QGIS many times. However, with two shapefiles QGIS hangs or never seems to complete. (I’ve let the process run for over two hours.) I’ve tried all the ...
7
votes
1answer
126 views

Join by attribute / spatialite with SQL / left outer join in QGIS

I have a layer with polygons (let's call it "woods") that is intersected by "n" line-objects ("roads"). Every road has an unique attribute roadid. I need to add ALL the roadid's (not only the first ...
1
vote
1answer
49 views

ArcGIS - Why would spatial join return correct distances but wrong attributes

I am doing spatial joins on points and street (line) features to identify the closest street to each point. However, despite getting appropriate distances returned for each points, closest road, the ...
1
vote
0answers
27 views

Join Attributes By Location inside QGIS modeler still fails to compute sums

Recently, a question was asked about the spatial join tool, and its failure to calculate the desired data. I ran into the same problem, but none of the solutions that were offered there solved it. ...
2
votes
1answer
70 views

Spatial Join Field Mapping in ArcPy?

I know there already are posts about this subject, I tried to derive a solution for my own problem but the code for field mapping is very complex to me. I have a Raster 100x100m and point layers that ...
4
votes
1answer
274 views

Spatial join of polygon to point not transferring attributes in ArcGIS for Desktop?

What I have: 1 point layer with adresses. 1 polygon layer with zones. What I want: 1 point layer with the polygon info added. I just did the spatial join, the columns are added but there's ...
3
votes
1answer
34 views

Spatial join of raster data in QGIS

How do I perform spatial join of raster data in QGIS? I have raster soil data (tiff), I'd like to join this to an attribute table in excel? I'm not able to view the attribute table either? Is this ...
3
votes
0answers
27 views

zonal statistics / join with two vector layers [duplicate]

I have a shapefile containing three polygons of river basins with different values. I want to know the average values per country. The country thus contains three river basins. When I use join in ...
2
votes
1answer
176 views

Why is “Join Attributes by Location” reporting different CRS (and running forever)

I have a point feature layer with ~240,000 parcel centroids. I have a second feature layer containing ~9000 subdivision polygons. I want to assign the name of the associated subdivision as a new field ...
1
vote
1answer
771 views

Difference between Spatial Join Tool and Spatial Join Function in ArcGIS Desktop?

I am curious to know if anyone can shed some light on the difference between ArcGIS' Spatial Join geoprocessing tool (found in Analysis -> Overlay toolbox) and the Spatial Join 'wizard' (found by ...
4
votes
2answers
85 views

One-to-many joins on a feature class to a table

I am using ArcMap 10.2.2 with an Advanced license. I have used ArcMap for other basic analyses, but am fairly new to the program and have only basic coding skills, with no SQL experience outside of ...
2
votes
3answers
924 views

Spatial join versus classical join

What are the main differences between a spatial join and a classical database join such as an equi (inner) join?
1
vote
1answer
189 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
4answers
1k views

Produce a list of polygons that a line crosses

I have a polyline feature class and a polygon feature class. What I want to do is add a field to the lines that lists all polygons that touch the line. This is effectively performing a ...
1
vote
1answer
203 views

ArcMap populate field with value from another dataset

I have two Polygon datasets, one contains Buildings and the other PostCodes (ZipCodes). I'd like the PostCode field in the Buildings dataset to be populated with the value of the PostCode field from ...
2
votes
0answers
24 views

Intersect, Spatial Join?: One Line crossing Multiple Polygons, assigned wrong attribute

I am looking for any possible solutions to a problem I am encountering with ArcGIS. I am using census block groups (CBG) to assign streets an income level value based on their location within the ...
4
votes
2answers
936 views

Performing spatial join between lines that travel along each other in ArcGIS Desktop?

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 ...
5
votes
1answer
55 views

Merging two polylines (street networks)

I have the following problem: I have two street datasets from completely different sources. I need some attributes from one dataset (red lines) to be joined into the other one (green lines). Until ...
2
votes
1answer
73 views

geopandas spatial join extremely slow

I am using the code below to find a country (and sometimes state) for millions of GPS points. The code currently takes about one second per point, which is incredibly slow. The shapefile is 6 MB. I ...
2
votes
1answer
40 views

geopandas error “minimums more than maximums”

I posted this question on stackoverflow here, but it seems that gis.stackexchange is the more appropriate platform. I am trying to merge two geodataframes in geopandas (want to see which polygon each ...
1
vote
1answer
21 views

appending country names to route feature class

I have a polyline feature class made up of multiple segments. This feature class overlays a polygon feature class representing the countries through which this polyline is going. For each segment, I ...
2
votes
1answer
57 views

Spatial join for not perfectly overlapping polygons?

I have 2 maps with the district borders of a country and I want to combine their features based on their location on the map but the borders of the districts don't overlap perfectly. I tried to use ...
0
votes
1answer
18 views

Linking datasets for two polygon layers in ArcMap?

I have two polygon shp files that do not have a common ID. I'm trying to link the datasets with a common ID based on spatial location. Is there a tool/process to link features (common ID in the ...
3
votes
2answers
788 views

Scripting spatial join in arcpy - how to set field attribute in field mapping object?

I'm scripting a spatial join in ArcGIS with Python. I only want the resultant feature class to have a single field containing one attribute from the join features. In general, many join features ...
5
votes
2answers
68 views

Is it possible to merge attributes from lines which are on top of each other?

I was able to merge the different kinds of roads (verharding lijn) with the normal roadmap (Wegen 1.0). The attributes were copied to all the records, but there are empty attributes where the kind of ...
0
votes
1answer
108 views

Fastest way to join many points to many polygons in python

I need to attribute a geographical area (based on shapefile polygons) to 8 million GPS points. There are 405 polygons. I currently have the code below, and a quick extrapolation tells me it will take ...
2
votes
1answer
52 views

How to do spatial join in FME by preferring points with same attribute

First of all, I'm new to FME, but I'll try to be specific with my question. I have two different shapefiles with point features. These points have information on bridges and overpasses etc. but are ...
1
vote
0answers
35 views

Has “add polygon attributes to points” been removed from QGIS?

I've been using "add polygon attributes to points" in qgis for a while, but hadn't needed it for a while (thanks to Underdark for this); in 2.13.0 master on ubuntu it seems to be missing from the ...
1
vote
1answer
65 views

ArcGIS Spatial Join - “contains part of” match option

I would like to perform a spatial join using a (non-existent) "contains part of" match option. i.e. I want the join to include any and all polygons that overlap, not just touch at the edge. None of ...
2
votes
3answers
998 views

Join CSV file to shapefile

I wanted to join a CSV file to a shapefile. When I identified a field to facilitate the join, e.g., map <- spChFIDs(map, as.character(map$ID)) it returned Error in spChFIDs(SP, x) : ...
0
votes
0answers
15 views

How to join CSV data (based on admin boundary names) to shapefile of aforementioned boundaries in R? [duplicate]

DATA: CSV data, Shapefile Hi all! I'm looking to perform what I've been taught is called a spatial join. After researching this further, it's looking like this operation is most often called a ...
1
vote
0answers
131 views

Summing time spent on effort from point GPS data tracks in grid cells?

I have one layer of point data representing GPS tracks collected during vessel surveys (an individual survey is indicated as the time between departing and returning to shore and there can be more ...
1
vote
1answer
113 views

Count number of points within multipolygon shapefile using OGR

I have two shapefiles: 1) consists of points (hundreds of entries) and 2) multi polygons (tens of thousands of entries). I simply need to count the total number of points contained within the ...
6
votes
2answers
179 views

How to do a spatial join in PostGIS that returns on the minimum value of point intersecting polygon?

I have a polygon table (buffer) and a point table (dem_points), and I want to do a spatial join on them. I need to join the point with the minimum elevation (dn) to its spatially corresponding ...
1
vote
0answers
20 views

Spatial Join with start and endpoints of polylines

My question is concerning spatial joins. Basically, I want to join 2 layers. One of them is are polylines and has two pairs of lat/long, representing the start and the end. id lat_start ...
0
votes
1answer
20 views

Divide broken line layer in seperate clusters based on location

Building on a earlier asked question on this forum I would like to ask an additional question in getting the task done I asked here: Divide polyline layer in clusters with specific requirements in ...
0
votes
1answer
49 views

Calculating Geometry (area) in a spatial join attribute table

In ArcMap, will Calculate Geometry (area) be accurate for records that have other polygons attached via Spatial Join? It doesn't seem to be adding the extra polygons that are spatially joined. ArcGIS ...
0
votes
1answer
57 views

Missing distance field after Spatial Join? [closed]

I heard that spatial join creates a new distance field when you do a spatial join. However, every time I tried doing a spatial join it only creates a county layer? What might be the reason that it ...
1
vote
0answers
57 views

Attributing polygon features with names of polylines they contain using ArcGIS for Desktop? [closed]

I have a few thousand polylines that represent streams and each of the streams has a corresponding watershed polygon. Streams have "Stream Name" attribute. I needed to attribute polygons (watersheds) ...
1
vote
1answer
43 views

Join new data to selected features in a table using Arcgis

I have a point feature class, A, and I have joined data from another point feature class, B, to its attribute table based on spatial location. I selected the second option in the Join Data window ...
2
votes
2answers
390 views

Extremely slow processing time to map lat/lon data onto census shapefile with ArcPy?

I am a newcomer to ArcGIS and Python so I would greatly appreciate any and all input on this issue. What I am trying to do is very simple: map 400K business locations using lat/lon coordinates onto a ...
5
votes
4answers
3k views

More Efficient Spatial join in Python without QGIS, ArcGIS, PostGIS, etc

I'm attempting to do a spatial join much like the example here: Is there a python option to "join attributes by location"?. However, that approach seems really inefficient / slow. Even ...
1
vote
0answers
24 views

I want to spatial join two tables with the same polygons, so I only want to extract where the polygons does not merge with the other [closed]

I want to spatial join two tables with the same polygons, so I only want to extract where the polygons does not merge with the other. SELECT e.SGid as 'table_name2' From [table] inner ...
2
votes
1answer
86 views

QGIS:joinattributesbylocation gives empty shapefiles and QGIS:joinbylocation does not give summary of all fields

I am trying to make a spatial join to calculate the mean value of many variables (100+ columns) of census tracts by city. In order to do that, I would, in QGIS Desktop, run a spatial join (join ...