Questions tagged [spatial-join]

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

Filter by
Sorted by
Tagged with
2
votes
4answers
48 views

Count number of points by name within distinct polygons

In PostgreSQL/PostGIS I have 2 tables: A POLYGON table (polytable1) with shapes named 'Poly 1', 'Poly 2' etc... Each name can appear multiple times (i.e. 20 polygons with the name 'Poly 1') A POINT ...
1
vote
1answer
25 views

nngeo- nearest neighbor with distance dataframe

I'm working with some spatial data and I want to turn the output of the st_nn command (outputs a list) into a data frame that I can join. For example library(nngeo) library(tidyverse) cities <- ...
2
votes
1answer
35 views

Joining attributes from two different polygon layers

I'm trying to join the attributes from the polygon layers shown on the images. The result I'm looking for is one layer that contains the square and the attributes of both triangles: the triangles are ...
0
votes
1answer
46 views

Spatialite - update query for bounding polygon using WITHIN

I have 2 spatialite polygon layers which represent land parcels and municipalities. Each parcel is within or intersects 0, 1 or 2 municipalities. I am trying to update a field within the parcel layer ...
0
votes
1answer
19 views

ArcMap calculate distance (from and to) from a points shape to the lines shape table

I am trying to calculate the From and To fields in the line table. I have got a points shape and i have got a line shape. ( see for example the figure bellow.) The points( in red ) intersect with ...
2
votes
0answers
30 views

Spatial join many polygon layers and save ones with condition

I've got 8 polygon layers made from buffering point layers. All have index and geometry columns: I would like to select areas where at least 3 consecutive buffers intersect (like: buffer_03 & ...
7
votes
2answers
128 views

One-to-many spatial join with results in one row

I have two feature Datasets. Both are Polygons. Dataset A has very big Areas and Dataset B just small ones. Now, B still overlaps in 2 or 3 Zones from Dataset A. I want to perform a spatial join and ...
0
votes
1answer
22 views

Spatial join (points in polygon) but also including the “observation count” of each point in the join_count field

I have point layers of bird observations, and I want to symbolize certain areas by the number of bird observations in each polygon. Each point in the point layer has a "observation count" field ...
1
vote
2answers
21 views

ArcMap: Combining County Polygons for 3 separate states into one layer with attributes

I have 3 separate layers with the counties for 3 separate states: WA, OR, & ID. I want to combine them into one layer "Counties" so they all share an attribute table with the same fields. I am ...
3
votes
0answers
68 views

Joining non-contiguous polygons in QGIS

I am trying to "physically" join non-contiguous polygons of the same layer to form one (when the polygons are spaced less than 5m), without distorting the original shape. This is a building layer, ...
1
vote
1answer
35 views

A simple way to merge lines separated by a space in QGIS

In QGIS after creating contour lines by extracting them from a DEM (Extraction > Contour) and smoothing them (Line Smoothing) I noticed this situation: In order to smooth out the corners ...
1
vote
1answer
71 views

Join a grid to points that are close but aren't overlapping

I have a point grid that overlaps points on a map. I want to join this grid to the points in order to keep only the parts of the grid that contain a point. However, there are some points that lie ...
5
votes
2answers
1k 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 ...
2
votes
2answers
188 views

Aggregating census level data to county level in QGIS?

I'm trying to take census tract linked data (in the form of a CSV I joined to a census tract level map of Washington State) and create a county-level map with it. My census data also has the county ...
4
votes
1answer
54 views

Aggregating multiple rasters within a polygon in PostGIS

I have several raster tables in PostGIS (four in fact but in this case let us assume there are just two) - same cell sizes, same alignment but with different types of value (e.g 3d_pot, 3d_area). ...
2
votes
1answer
59 views

Creating new point features from count number of existing features using ArcMap

I have point features with coordinates, but some of those points have multiple observations at the same coordinate. I put those as a count column in the attribute table. But now I need to do a spatial ...
0
votes
0answers
32 views

Joining two polygons that have information in same spatial location using ArcMap

I am using ArcMap 10.6.1. I have two shapefiles, one that has human disturbance and one that is fishnet grid and every grid has a unique value. I used the fishnet tool on my human disturbance ...
-1
votes
1answer
46 views

Spatially join linestrings (which can overlap or not overlap) in R and provide output in a data format that I can add other variables

I am using R to exam road infrastructure. The sf dataset I am using is very granular e.g. for the same road two or three observations may exist that are differentiated by different coloured tarmac ...
0
votes
1answer
28 views

Identifying zip codes that cover multiple townships

I have shapefiles with zip code tabulations in Massachusetts and township areas. Some zip codes fall completely within a single township, while some zip codes cross multiple town borders. I want to ...
1
vote
2answers
43 views

Using join in ArcGIS Pro?

I am trying to join the information from a line to that of a point associated with that point. To explain a bit, it would be adding the information from a bus line to the associated bus stops with ...
1
vote
1answer
134 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 ...
0
votes
1answer
31 views

Finding point from Layer B that matches point from Layer A using search radius

I have two point shapefiles of trees from two different surveys. I want to verify if data from Survey A matches data from Survey B. I want to create a search radius of 10m around each tree from ...
1
vote
0answers
37 views

Unable to perform join raster-table ArcGIS 10.3

I am trying to replicate some results from a publication. There, one of the datasets they use is WISE30sec map (available for download here: https://www.isric.org/explore/wise-databases). My problem ...
3
votes
1answer
102 views

Joining attributes by location error when finding polygons within district boundaries?

I am using QGIS 3.5. I have a large shapefile (760 MB) with 1800 polygons representing different bird species ranges (download link) I have a second shapefile with polygons of district boundaries (...
1
vote
1answer
36 views

How to Spatially Join Polygon IDs to Points in R

I am trying to assign a region ID to each record within a point shapefile. Each point would be assigned the Region ID of the region it falls within. The point feature is called "deciles" and the ...
1
vote
2answers
92 views

Spatially joining small target feature to one of multiple join features using ArcGIS Desktop?

I am trying to spatially join characteristics from a larger unit (here: county) to a smaller unit (say, local district), such that for every local district I will also know in which county it is in. ...
1
vote
1answer
86 views

Multiprocess Spatial Join with Spatial Index

I'm a newbie in implementing GIS on Python, but the lack of any GIS software at the office has forced me to learn about it. I have a huge grid (a multipolygon) that I'm currently filling out with ...
1
vote
2answers
40 views

Spatial Join unique values for closest target feature

I have a polygon shapefile of land plots with their corresponding cadaster number and a point shapefile with a water meters for each lot. What I'm trying to do is to join the cadaster number from the ...
0
votes
0answers
22 views

Building a grid panel in Google Earth Engine: organizing properties collected from a join by day

Code for my work is here I'm trying to build a panel-style feature collection where for each day we have a count of the number of events for each grid. I can use a join like this: leftField: '.geo',...
1
vote
2answers
290 views

Simpler Method to Map Fields in Spatial Join

I've cobbled together a script, part of which creates field mapping to sum fields in a spatial join. It took 13 lines of codes just to define which fields I want summed in the output. Is there a ...
2
votes
1answer
88 views

Joining points and polygons by date in Google Earth Engine

I am using an aerosol index, which I reduced to a daily mean for 2019: var airq_19 = ee.ImageCollection('COPERNICUS/S5P/NRTI/L3_AER_AI') .select('absorbing_aerosol_index') .filterDate('2019-01-01'...
1
vote
1answer
29 views

Using multiple layers as point features in spatial join using ArcMap

I have 15 point feature layers and one polygon layer. I need to count the total number of points in the polygon using a spatial join, to then classify the different polygons based on the join count. ...
6
votes
3answers
2k views

Efficient spatial joining for large dataset in R

I am working with rather large data frames that I often need to do a spatial join on. The fastest way I have come up with so far is this method: library(rgdal) download.file("http://gis.ices.dk/...
0
votes
1answer
178 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="...
1
vote
1answer
85 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 ...
2
votes
3answers
46 views

Populate an empty raster with values from intersecting vector layers

I'm looking to populate a large, empty Unsigned 8-bit raster with integer values 1 to 10. The value depends on the spatial relationship between a given raster cell and a variety of vector layers (...
2
votes
1answer
81 views

Optimising Large Spatial Queries in SQL

I'm sure similar answers have been given elsewhere but no matter what I have tried I am unable to optimise this query. Details: TableA has 3.5mill records TableB Had 57000 records but I have ...
1
vote
1answer
415 views

Extracting polygon attributes from covering polygon with highest area using ArcPy

I have a fishnet grid (polygon layer) and another polygon layer containing some hexagons. I would like for each square polygon in the fishnet layer that covers a hexagon (even a tiny edge of it) to ...
1
vote
1answer
139 views

Join by location (summary) returns null

I am trying to count points within polygons (311 calls by Census tract). Both shapefiles are EPSG 4326, and I've done define projection just to double-check. Every time I run Join attributes by ...
0
votes
1answer
56 views

Error message when joining two dataframes with sf -Error: y should be a data.frame; for spatial joins, use st_join

In R, I'm trying to count the number of points which fall within a buffer around polygons and add the count result to the original shapefile from which the polygon file was created. I've followed the ...
0
votes
0answers
43 views

Polygon to polygon spatial join without double counting join features using ArcGIS Desktop

I am a new GIS user trying to aggregate local ward-level voting data up to a broader county-level using a Spatial Join. Generally a given ward is within only one county, so a JOIN_ONE_TO_ONE for the ...
0
votes
1answer
30 views

Using Spatial Join to join geologic features to polylines

I want to spatially join polygons (geologic features, major aquifers) to where the NHD polylines (rivers/streams) fall. I want to be able to click on a polyline and see what geologic feature or major ...
2
votes
1answer
58 views

Copying fields from one attribute table to another in QGIS

I have two layers. One is point, the other one a line. They both share same x and y coordinate. How do I transfer one field from the point layer to another field in the line layer based on the same ...
1
vote
1answer
93 views

QGIS: Joining data from multiple road lines onto polygons by location

I'm looking to add traffic data linked to a polyline shapefile of road centerlines to a multipolygon shapefile of land parcels. I want to join this data using proximity to roads instead of by matching ...
0
votes
0answers
15 views

Adding results of Spatial Join to ArcGIS Online feature

As an example, I have 2 feature classes: Houses (points), which is uploaded online on AGOL Streets (lines), local layer I want to give every house a street name. Here is what I do: Do a spatial ...
0
votes
2answers
452 views

Combining attribute table of polygon and point shapefiles using ArcGIS Desktop?

I am fairly new to using ArcGIS Desktop. I am working with two different types of data. The first is a large shapefile that contains small polygons that distinguish different types of vegetation. ...
0
votes
0answers
37 views

Spatial join with polygon and multipolygon mixed feature class

I have a feature class which contains 300,000 polygon and multipolygon features in the same fc. The goal is to get a result layer of spatial join (must to be one to many join) between this feature ...
4
votes
3answers
102 views

Concatenate string field in spatial join in QGIS

I'm doing a spatial join between a point layer and a polygon layer. The point layer has a field called "type" which has string values. When I join this to the polygon layer, I would like to get a ...
1
vote
0answers
47 views

Sliver polygons, vertex, gaps

I'm correcting a Land Use polygon, interpreting a drone image using QGIS. When I use the cut tool and merge tool to edit, the polygon leave a smalls polygons like a line, or sometimes leave a vertex ...
0
votes
0answers
20 views

How to add up election zone voting upto county level?

Sorry if it is a trivial question. I am trying to add voting data from election zone up to county-level using spatial join tool, but I cannot figure out which relationship I should use. When I use ...

1
2 3 4 5
13