Questions tagged [spatial-join]
To join the attributes from one spatial data layer to another using their common location
959
questions
0
votes
0
answers
16
views
Closing open polylines to create polygons in ArcGIS Pro [closed]
I have a large file with right-of-way lines displaying the edge of roadways. I am trying to create polygons that encompass the entire area within these lines but have stumbled upon a handful of issues ...
1
vote
2
answers
65
views
Check if polygon falls inside other polygon with 2 layers
I have two polygons layers with SRID 4326, indexed in a PostGIS database. Layer 1 is a country layer. I want to check whether the polygons (> 60k instances) from layer 2, fall inside the boundaries ...
- 109
1
vote
1
answer
49
views
How can I intersect two shapefiles without creating split features that have duplicated attributes in QGIS?
I am intersecting two shapefiles in QGIS: a city council map and the census blocks in the city's county with demographic variables (e.g., population).
When I use the intersect tool in QGIS, the blocks ...
-1
votes
1
answer
47
views
Count points inside polygons using R [closed]
I have imported two shapefiles in R, one with polygons and other with points. Each polygon has an identifier different from the others, and each point also.
The polygons and points identifiers are not ...
- 85
0
votes
0
answers
21
views
Join cities to counties of a province using Spatial Join with keeping the information of each [closed]
I have a shapefile of cities of a country with information of its province, population and area. also have another shapefile of counties of the same country (cities are part of a county) with the same ...
- 11
2
votes
0
answers
19
views
How do I find the length of part of a line segment that crosses a polygon boundary?
I have a street centerline table and a borough boundary polygon table. I want to select any centerlines that cross borough boundaries and also return the how much of that centerline is crossing each ...
- 157
0
votes
0
answers
12
views
ArcGIS Spatial Join not adhering to merge rules
I'm attempting to extract soil data into a fishnet grid, whereas there can be multiple underlying soils overlapping each grid cell.
I've successfully done this via Intersect -> Calculate Geometry (...
- 1
4
votes
1
answer
70
views
Find nearest node on nearest line
GeoPandas has this really convenient tool sjoin_nearest() to find the nearest features to, say, each point in a dataframe. It can also return the distance:
distances = gpd.sjoin_nearest(points_gdf, ...
- 791
0
votes
1
answer
33
views
Merge two spatial polygon data frames that have the same geometries and different attributes introduces duplicates/additional row names in R
I have two multi polygon data frames that originate from the same spatial data frame. So, the polygons should be exactly the same. I calculated some stuff and now I have used st_join as follows:
...
3
votes
2
answers
93
views
Spatial join of points and isochrones of openrouteservices
I'm using QGIS 3.22.0 Bialowieza.
I have a point Layer which I generated from a street layer. I used these points to calculate the time accessibility with openrouteservices. The isochrones I get back ...
- 557
0
votes
0
answers
26
views
Assign single SPEI value for each city
I want to have a single value of SPEI to every city of my map. As the SPEI data is gridded at 0.5 degree resolution, some cities o not have a point falling into its boundaries. My approach was to &...
- 185
1
vote
0
answers
32
views
Calculate the intersection area of three types of polygons in QGIS
I have three layers --
US Census tract boundaries (vector)
Radius of superfund sites (vector)
US Land Use (raster)
So I only want the land cover types starting with 'Developed', and let's call it '...
- 21
0
votes
1
answer
33
views
Spatial join to isolate clusters
I have this shp made by many tiny polygons. I want to identify clusters (red circles) with a spatial join and then apply a minimum bounding geometry to isolate them with a perimeter.
I am having ...
- 9
2
votes
2
answers
89
views
How to prevent duplicates from being generated in Spatial Join in PostGIS
I'm trying to create a spatial view which meets the following criteria:
Sentinel hotspots registered within 2km of powerline (feeder)
AND
QRFS point located within 4km radius of sentinel hotspots
AND
...
- 21.8k
1
vote
1
answer
36
views
Join non-spatial CSV layer with spatial shape layer, using multiple input fields
I have two separate layers i want to join in my QGIS-project based on multiple matching input fields.
One layer consists of a non-spatial CSV table, but with the matching fields: Streetname, House ...
- 13
0
votes
0
answers
43
views
How to use sf::st_join and avoid filling in values if polygon mostly covers empty space?
I am using sf::st_join in R to join two polygon layers. One of the two layers (sample) was created from a rasterised subset of the other (patches).
I would like to extract the values from the subset ...
- 271
0
votes
0
answers
34
views
Joining street ID to Sidewalk polygons using ArcGIS Pro
I am using ArcGIS Pro 3.0.3.
I am trying to match a set of Street IDs (line data) to sidewalk polygons. I have buffered the street line data based on street width, and then ran a spatial join, joining ...
2
votes
1
answer
35
views
Spatial Join to calculate basic statistics For multiple locations
I am using QGIS and looking at multiple businesses (purple dots), and water levels (the grey behind them).
I am trying to calculate the average water level within x feet of each business (purple dot)....
2
votes
1
answer
90
views
Warning message when doing spatial join nearest neighbor on GeoPandas
I am trying a nearest neighbor spatial join with two point Geodataframes but a warning message is appearing.
My code:
import geopandas as gpd
yield_2013=gpd.read_file('https://github.com/kevinkuranyi/...
- 185
0
votes
1
answer
69
views
Spatial join (multiple) layers "in place" with QGIS
In my QGIS projects I often have to append attributes from other spatially overlapping layers to a base dataset. E.g. I am working with a forest stand map and need add soil information, plant ...
- 2,334
0
votes
0
answers
88
views
Utilizing spatial index in SQL Server
I have a table Points with shape column for points of geography type, and a spatial index on the column to improve performance..
CREATE TABLE Points(id VARCHAR(10) PRIMARY KEY, shape geography);
...
- 11
0
votes
1
answer
33
views
How to group polygons based on spatial proximity and sum of numbers?
Similar to this question, rather I want to group polygons based on sum of values.
To be more specific, I need to group cities, within a state, and that group must add up to "x" amount of ...
1
vote
0
answers
113
views
Making Nearest neighbour join with attribute condition in QGIS
I have two line layers in QGIS:
Input Layer A: Street Segments
Layer B: Traffic Data
and would like to perform the nearest neighbour join with a condition (where the same street name is equal- one-...
- 31
0
votes
0
answers
24
views
Setting distance range in spatial join using ArcMap
I have many city polygons and I want to select some of them with distance range condition from boundary of other polygons. I use WITHIN_A_DISTANCE in spatial join but this item selects even ...
- 79
2
votes
1
answer
126
views
Spatial join from points to polygons using GeoPandas gives me a points shapefile, not a polygons shapefile
I have the following points and polygons layers:
There is exactly one point attributed to each polygon, all accordingly within the corresponding polygon boundaries.
The points layer contains a binary ...
0
votes
1
answer
78
views
Does MS SQL server actually support spatial joins?
I have tried these ways to run a spatial join
select * from a
join b on GEOMETRY::STWITHIN(a.geom, b.geom) = 1
select * from a
join b on a.geom.STWITHIN(b.geom) = 1
Both return the error:...
- 156
1
vote
1
answer
61
views
Google Earth Engine spatial join of nearest polygon to points
I am trying to do a spatial join of two feature collections: points to watershed polygons. Many of the points are outside of the polygon area so I want to join the point to the nearest polygon. ...
- 13
1
vote
1
answer
89
views
Joining polygons from the same data source and create one smooth polygon in R
I would like to create on single polygon from multiple small polygons (see the image below which represents what I want)
I need to connect the polygons and I found that purrr::st_connect might work ...
0
votes
1
answer
76
views
DISJOINT and TOUCH between Polygon and LineString not working as expected in Oracle Spatial
I have the following 4 geometries in an Oracle Spatial table:
A) POLYGON ((-100 40, -100 44, -96 44, -96 40, -100 40))
B) LINESTRING (-99 37, -99 40)
C) POINT (-100 41)
D) POLYGON ((-96 41.5, -95 42, -...
- 15
4
votes
1
answer
83
views
QGIS - expression join attrributes by location
I'd like to sum up values from a point layer in my polygon layer from points lying within the polygon.
I only found it with the processing toolbox, but that creates a new layer. But I just want to ...
- 43
1
vote
1
answer
125
views
Joining feature collections, keep non-matching features in Earth Engine
I have a sample of tile centroids:
var BGD = ee.FeatureCollection("FAO/GAUL/2015/level0")
.filter(ee.Filter.eq("ADM0_NAME", "Bangladesh"));
var projection='EPSG:4326'; //...
- 199
1
vote
1
answer
59
views
Defining the join type (one to one ) in Join attribute by location (summary) in QGIS
I have two shapefiles. One of them is residential area and the other one is a polygon shapefile which has the population field.
Now I want to do Join attribute by location (summary) analysis but in ...
- 87
1
vote
1
answer
84
views
Join attributes from point layer to overlapping polygon layer in a one-to-one relationship in QGIS
I have a polygon layer and a point layer. I want to get the attributes from the point layer and join them to the polygon layer in a one-to-one relationship. This is normally easily done with the Join ...
- 175
0
votes
0
answers
40
views
Spatial join of multiple GDFs and extract values
I have several different polygon geodataframes:
I would like to get the interseting area of one to another. I was able to do it like that:
frames = [oranzove, modre, cervene, tyrkysove]
empty = []
...
- 121
3
votes
1
answer
108
views
Join attributes by nearest with many data
I'm trying to apply the 'join attributes by nearest' function on a quite big dataset: A multipolygon layer with ~ 415.000 features (1.11GB) and a point layer with ~ 305.000 features (~320 MB).
Just to ...
- 1,105
-1
votes
1
answer
177
views
H3 Hexagon Geometry join on MSA Geometry
I have a pandas DataFrame with h3 hex ids and corresponding Polygon geometries and a geojson file with Texas Metro Area Geometries.
I'd like to join the H3 hex ID to Metro area and identify which ...
- 473
-1
votes
1
answer
54
views
known contained polygons on geopandas return everything False for "contain" and "within" when dissolving one layer
I have two geodataframes:
gdf1= 1000 polygons
gdf2= 26 polygons that are bounding box of 26 polygons from gdf1.
I would like to get the all the polygons from gdf1 that are not within gdf2.
I decided ...
- 2,047
0
votes
0
answers
29
views
QGIS 3.22.16 How to join two table with different values
I am using QGIS 2.22 16. Working on a road network shapefile I was asked to add in this layer the road names from another road network shapefile. I thought about using the join tool. Unfortunately, ...
- 191
1
vote
0
answers
62
views
Virtual layer in QGIS from generated geometry by a multi table join
I have a Spatialite database with three tables. I'd like to draw a center point of a line (by using ST_Line_Interpolate_Point) that is generated by a multi table join.
The first table has the ...
- 23
0
votes
0
answers
13
views
How to join points for businesses with administrative shapefile and keep both points and administrative divisions on map
I have an administrative shapefile of Jamaica, and I have a layer with the coordinate locations of a few hundred businesses. I have spatially joined the business layer with the shapefile layer to ...
- 93
0
votes
0
answers
40
views
QGIS - Spatial Join with Raster and Vectorial files
I have two layers, a raster (arr_ker) and a vector (Polygon), as can be seen below:
In QGIS, I need to add the raster data to each of the entities found in Polygon. It would be ideal as an average.
...
- 303
0
votes
0
answers
21
views
ArcMap - Spatial Join with Raster and Vectorial files [duplicate]
I have two layers, a raster (arr_ker) and a vector (Polygon), as can be seen below:
In ArcMap, I need to add the raster data to each of the entities found in Polygon. It would be ideal as an average.
...
- 303
1
vote
1
answer
32
views
Joining Results Back to Original Pandas GeoDataFrame Results in More Rows
I have two point geodataframes: gdf_1 & gdf_2, with gdf_1 being the original dataframe and gdf_2 being the results from the analysis of gdf_1. Both frames have the same number of rows, same ...
- 831
5
votes
1
answer
323
views
Summing attribute values along line layer in direction: accumulating the attribute values of side lines in QGIS
I want to sum up the attribute values from a line layer along another line layer in QGIS in a direction:
The values from the orange line should be summed up along the red line, which is divided into ...
- 103
1
vote
0
answers
47
views
Join by nearest while Join by attribute field in QGIS graphical modeler
I have a point (road accidents) and a line (roads) layer.
The line layer has two attributes: road_code and segment_code. Each line is composed by multiple minor segments.
The point layer contains a ...
- 817
0
votes
1
answer
151
views
Join attributes by location won't sum values in QGIS
I am trying to average all the data for one attribute in a particular census tract from the road segments data that lies inside of them. The documentation states that you can sum average etc. data by ...
- 1
0
votes
0
answers
20
views
How to fill automatically points touching line layer in the attribute table? [duplicate]
I am trying to build a basic road transport network using QGIS, at this stage: one layer for nodes (nodes are dots connecting lines, one node connects two lines) and one for links (a link is a road, ...
- 23
0
votes
0
answers
30
views
Join overlapping features and store each joined object in one layer
I am using QGIS. And I drew a buffer for the link data. What I want is to combine buffers which have overlapping areas each other to create new objects.
For example, you want to automatically merge ...
- 1
0
votes
0
answers
21
views
ArcGIS Pro - Spatial Join between layers. High granularity polygons as target
Even though I found an easier way to achieve the result (using numerical data provided with the dataset), I would still like to see if what I tried to do using Spatial Join is correct, or even ...
- 291
0
votes
0
answers
27
views
FME equivalent of ArcMap spatial join one to one
I am new to FME.
I am trying to use FME to do a geometry one to one join like I can do in ArcMap.
Currently the SpatialFilter produces a many to one which is not the result I want.
Can someone let me ...
