Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [spatial-join]

To join the attributes from one spatial data layer to another using their common location

1
vote
1answer
21 views

How R-Trees, R*-Trees can be used to index the Road Network?

I am trying to understand the Tree Indexing method of the Road network. In R-Tree the Minimum Bounding Rectangle is used to store the data points, but how it can hold the line segments of the Map? Or ...
1
vote
0answers
26 views

Performing PostGIS spatial joins with remote host?

I have approximately 600,000 points that must be joined to ~12 million polygons. This process happens weekly, with the potential to happen daily. The polygon data never changes, and is stored in a ...
0
votes
1answer
36 views

Find the closest Point from a Point which contains the same attribute

I am trying to create python code to iterate through points on 1 layer and find the closest point on another layer (Road Chainages) based on attribute values. I need to limit the search to < 20m ...
2
votes
1answer
40 views

Joining 2 layers by location doesn't join desired fields from attributes tables

I have 2 layers that I'm trying to join by location: 1 is a point layer (CRS 4326) and the other is a shapefile layer (CRS 4326). The shapefile layer has a field in the attribute table whose values I ...
0
votes
1answer
47 views

Spatial (nearest neighbour) Join Between Points (GPS coordinates) and Line in R

I want to do spatial join to an OSM line data and GPS point data both in geographic coordinate system, the result which I want is a road layer(has a unique ID) with the attributes of of road and the ...
0
votes
1answer
62 views

Lines in Polygon Analysis

This question is similar to the "points in polygon" analysis, but I want to keep the attribute data for multiple lines within a single polygon. The data source is multiple line segments representing ...
1
vote
1answer
43 views

Joining single column in ArcGIS Desktop with Spatial Join

I'm trying to automate a rather annoying workflow in ArcGIS 10.4 with a Python script. My goal is to extract data from a polygon shapefile into another polygon shapefile which is arranged as a raster (...
1
vote
1answer
37 views

Using Statistics by category in QGIS?

I use the "statistics by category" tool from QGIS to learn what grain yields I got from different combinations of scenarios like: Soil A + Hybrid A + Planting Date A = Yield n Soil B + Hybrid A + ...
0
votes
1answer
21 views

Joining separate parcels based on group ID into one large group

What tool would I use to group many parcels into its own respective group. For example, if parcels A, B , C have group ID of 1 then I would like to have parcels A, B, and C combined into one larger ...
3
votes
1answer
62 views

GeoPandas spatial join and count

I have following two GeoDataFrames. One with the crime count per polygon per year. Polygon Year total_crime shape_area geometry 0 0 2009 1 3.266388e+06 ...
-1
votes
1answer
30 views

Sum attributes of feature that occurs multiple times within a layer

I am trying to add up the total contributing drainage area of multiple stormwater BMP's that are located on the same parcel for a layer that contains tens of thousands of parcels. I performed a one-to-...
1
vote
1answer
54 views

Join attributes by location - false information

I've been working on an analysis involving animal vehicle collisions. The data has been passed to r-stats and I keep noticing peculiar things in the cross referencing of the data. I've created highway ...
0
votes
2answers
60 views

How to join Shapefiles without common attributes using ArcMap

I have a Dissemination Areas boundaries shapefile with has an attribute table full of data needed for lowest quartile analysis and I have a neighborhood shapefile which has lowest income data which ...
0
votes
0answers
22 views

Finding number of points within each respective polygon in table [duplicate]

I have: a shapefile of circles at 15 meters radius and point data with GPS coordinates. How can I count the number of points within each circle and have a raw number that can show such? I've tried ...
1
vote
0answers
17 views

Spatial join of feature class on layer class with PyQGIS

I have three layers: One point layer consisting of residents One polygon layer with buffers of the first layer (one polygon for every point) Another point layer consisting of containers I use QGIS ...
3
votes
1answer
87 views

Spatial Join In PostGIS where centroid of a polygon is inside another polygon

I have two overlapping polygon layers as shown in figure below. One with small grid polygons and another with a large irregular polygon. I want to join them such that attributes of the large polygon ...
2
votes
3answers
75 views

Seeking PostGIS equivalent to GeoPandas union overlay?

What is the PostGIS / PostgreSQL equivalent of the GeoPandas Overlay Union operation? res_union = geopandas.overlay(df1, df2, how='union') Say I have two tables, 1 green, 1 red with each with two ...
3
votes
1answer
66 views

Spatial Join Ouput Attributes Differ Based on Input FC or SHP

I have a point dataset and a polyline dataset that I am running a spatial join on. I noticed that if I run the spatial join with the point FC, the ouput differs from if I run it with a point ...
2
votes
0answers
38 views

postgis and st_intersects ; fail to compare a table to itself with a left join

postgresql 9.6, postgis 2.3 Following this Select features that do NOT intersect in PostGIS, I would like to compare one table to itself, to keep all records from table p1, even and above all those ...
1
vote
0answers
48 views

Shapefile import failed in PostGIS

I am new to PostGIS/PostgreSQL and have downloaded and installed to perform a spatial join which ideally takes 27 hours in ArcGIS Pro and 19 hours by ArcPy.Hoping for a faster results via PostGIS from ...
4
votes
1answer
38 views

Extract value from vector to another

I have two vector (shapefile) data. One contains soil order for county, and the other one contains boundary for each county. I want to extract the soil order for each county by using county boundary. ...
0
votes
0answers
22 views

Using point geometry object in Spatial Join with ArcPy?

I'm trying to do something that is conceptually very straightforward. I'm pulling a center point from a raster (geotiff, etc) and then doing a CONTAINS operation with that point against a UTM zone ...
0
votes
1answer
34 views

Use two lists as input to Spatial Join in ArcPy? [closed]

I am trying to determine a method for conducting a spatial join on features from two separate feature datasets based on the first three letters of each input feature (A01_road == A01_gps). import ...
0
votes
1answer
37 views

Spatial Joining One to Many?

I am trying to create groups based on a primary object as its centroid. Groups are defined as all objects within a certain distance from a primary object. I am currently using spatial join in a ...
1
vote
0answers
36 views

QGIS problem using join by location algorithm

I am new to QGIS. I have a problem when i use the algorithm "Join by location" in my graphical modeler, it returns me the "uknown error". I think the problem is that the shape i´m using to join is ...
0
votes
0answers
24 views

Calculating total utility number of each road segment using ArcGIS Pro?

The problem I want to solve is to calculate total number of main utilities (parallel to roads) within a distance (e.g. 10m) of each road segment in ArcGIS Pro. First I applied a 10 m buffer to roads ...
0
votes
0answers
24 views

Executing Statistics operation not included in Spatial Join Merge Rules?

I want to calculate geometric mean (instead of arithmetic mean) where points are 'Join Feature'and Fishnet is 'Target Feature'. The standard procedure for this type of operation is spatial join I ...
1
vote
0answers
13 views

Iterating over set of feature classes and spatial join to create only one output? [closed]

I have a feature dataset with 50-some odd feature classes (polygon) that all have fields that I need to spatially join to one feature class (point). So in the end, I only want one object with all of ...
1
vote
1answer
22 views

Finding many intersecting polygons of one layer and listing them in single field using ArcGIS Desktop?

I have a polygon layer of a grid of USGS Quads Index clipped to the Southwestern US (https://catalog.data.gov/dataset/united-states-7-5-usgs-quad-index). I also have a polygon layer of county ...
0
votes
1answer
52 views

Connect points from two SpatialPointsDataFrames in R, considering the closest distance

I have two SpatialPointsDataFrames. In SpatialPointsDataFrame one (dat1) I have three points (A, B and C). In SpatialPointsDataFrame two (dat2), I have eight points with temperature measurements. I ...
1
vote
1answer
42 views

Spatial join in R - Adding points to polygons with multiple corresponding points

I have carried out a spatial join in R in order to join a points shapefile to the corresponding polygon in a polygon shapefile using over() from the sp package and spCbind(). join <- over(polygons,...
0
votes
1answer
68 views

Taking 2 overlapping spatial polygon layers and creating 1 with features from one replacing those of other layer?

I have two sf multipolygon layers - one is a 5km buffer along the Mexico-US border and the other is an administrative 2-level layer of Mexico. I am trying to figure out how to layer these on top of ...
0
votes
2answers
38 views

Joining features across boundary lines of target feature in spatial join?

I have a file geodatabase named ElectionData2012.gdb containing two feature classes: Counties: The feature data for California counties PrecinctVotingData: Feature data for California precincts for ...
0
votes
0answers
97 views

Calculate percentage overlap of polygon features in two layers QGIS

I have two polygon layers (building footprints and parcel boundaries) for a county. I want to join the parcel ID numbers to the attributes of the building footprint features based on location and ...
2
votes
1answer
213 views

Join attributes of polygons to another polygon feature based on location QGIS

I have two large polygon data-sets. One highlights the building footprints for a county and the other highlights the parcel boundaries for the same county. Some parcel polygon features have multiple ...
0
votes
1answer
50 views

Google Earth Engine compute point-polygon distances

I am trying to compute distances from points stored in a fusion table to the nearest political border (also from a Table) in Google Earth Engine. I need to compute distances between points. I would ...
0
votes
0answers
30 views

Building “Programmatic areas” for health services in QGIS

I need to calculate the "programmatic/influence area" (scope) of some health services in my city in QGIS. I have two input data sources: The amount of "Target Population" according to census radios ...
0
votes
1answer
40 views

R sf extrapolate grid from centroids

I've got a grid/raster in R that is represented as centroids of the grid instead of polygons. I am trying to merge that with points. library(sf) nc <- st_read(system.file("shape/nc.shp", package="...
0
votes
0answers
67 views

Spatial joining one to many within distance using ArcMap?

I have two datasets, the dataset A contains the main information, I want to join all the points from dataset A to all the points in dataset B within 150 meters. From dataset B I need to keep two ...
0
votes
1answer
553 views

Create buffers around points and merge with SpatialPolygonsDataFrame to create a list of matched polygons and the area of intersection

I have data on polling booths as points and data on village boundaries as polygons. I want to create buffers of 1km around the polling booths and (a) save the ID of all the villages that intersect ...
1
vote
1answer
59 views

Change attribute of a line according to overlapping polygon features

I'm pretty new to QGIS and python in general. For my work I'm faced with a bit of a problem. I got 100-m-segments of several streams and polygon-features of the surrounding substrate. The polygon ...
1
vote
2answers
48 views

Select points with maximum attribute value per category on a spatial join with PostGIS

I'm trying to select the points with the maximum altitude value contained in the polygons of a grid. grid and point with altitude I've managed to get the max value per category: SELECT grid.pagename,...
0
votes
0answers
53 views

Calculating sewer slope in ArcMap?

I'm working on a project with two layers, the point layer is manhole and the line layer is sewer pipe. The manhole layer includes x/y/z, the depth of manhole and etc., and the pipe layer includes the ...
0
votes
1answer
33 views

arcpy.SpatialJoin_analysis giving ERROR 000210?

I have two polygon feature classes (buildings), one with attributes in green in the example below (building_sample.shp) and one with no attributes in red in the same example (building_sample_NA.shp). ...
1
vote
0answers
104 views

Match attributes (with spatial join) weighted by length of line feature in polygon in ArcGIS

I have line features (streets) and polygons (air quality raster). I need to transfer the air quality attributes into the lines. However, some lines are part of two or more polygons (e.g. the selected ...
1
vote
1answer
42 views

Joining attibutes by location + aggregation per field

I am new to QGIS. I have a point layer (water permits) and several buffer layers (different distances from WWTPs). I can use "join attibutes by location" and find out the number of points and the ...
3
votes
1answer
72 views

Many points in many polygons, ID in R

I have a shapefile with about ~5k polygons. I have a database of about 3.8M points. I want to know, for every point, which polygon it's in. For example, Point A may be in Polygon A, Polygon B, and ...
0
votes
0answers
12 views

Joining Block Groups with Municipalities layer

I am trying to preform a join between block groups and municipalities to give the Block Groups a "District". Ideally what I wanted to do was preform a join between the Place File and Block Group file. ...
2
votes
0answers
51 views

Add layer info to points, keeps failing in QGIS

Within QGIS, I am looking to get an extra column in the points file, describing in which layer the point lies. All points are within 1 layer: Layer source >SHP file from shapefile.zip. Validate layer ...
0
votes
1answer
61 views

Spatial Join has Merge Rule Delimiter greyed out

I'm trying to use Spatial Join between a line layer and polygon layer. Where the polygon layer contains Area Names I would like to add to the lines. Sometimes a line will cross more polygons, so I'm ...