Skip to main content

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

How does ArcGIS Pro determine what is "first" or "last"?

ArcGIS Pro 3.2 When using geoprocessing tools, the field map has options such as: First - The first field value Last - The last field value https://pro.arcgis.com/en/pro-app/3.2/help/analysis/...
sushi's user avatar
  • 319
2 votes
1 answer
34 views

Transfering attribute from line layer to polygon layer by their overlay in QGIS

I have a polygon layer that represents sub-catchments and a line layer that represents a stream network. There is exactly one feature in the line layer for each polygon. I have used v.rast.stats to ...
Fabi's user avatar
  • 75
0 votes
0 answers
28 views

Finding closest feature of polyline layer to point layer using ArcPy with ArcGIS Pro

In ArcGIS Pro, I have 2 layers. One layer called X has data points which contains data for count points in a certain point of a road. This layer has an attribute (column) called Direction. This is ...
Barsino Larushku's user avatar
1 vote
2 answers
105 views

Filling field with values from field of another table using QGIS

I am using QGIS 3.28.9. I need to complete a field from a building's layer with the field's values from a plot's layer, based on the location of the buildings. At first I thought of doing it through ...
Mig TabSher's user avatar
1 vote
1 answer
59 views

Join by location lines and points, reporting more attributes in the table

I have two layers, one of points and one of lines. Visually, is something like thise: As you can see, each line has two points, as it was a graph with vertices and edges. The properties in the ...
Cla's user avatar
  • 11
1 vote
1 answer
93 views

DataFrame to GeoDataFrame Error: could not convert string to float

I have two Excel sheets with x und y coordinates (EPSG 4326) and several other attributes. My aim is to match both Excel sheets via the coordinates (geopandas.sjoin_nearest). I try to convert the ...
noj's user avatar
  • 13
1 vote
1 answer
17 views

How do I join grid cell data set with 2 travel time data sets?

I was doing an exercise from Automating GIS Processes courses and one of the tasks required me to join a YKR grid cell data set with two data sets of travel times to two shopping centres from every ...
mfirdaus_96's user avatar
3 votes
1 answer
54 views

Joining two polygon tables based on conditions

I have two tables: table1 and table2, I would like to join polygons from table1 (purple) to table2 (yellow) if the polygons in table1 don't intersect or are coveredby table 2 polygons. I would like ...
MJM's user avatar
  • 975
1 vote
2 answers
70 views

Count of points in shape

I have mapped the population (1km x 1km grid) of my country and I have used travel time to create driving distance polygons (i.e. 15 minutes). I have reprojected all the layers to the same EPSG (3857) ...
Cluedoz's user avatar
  • 11
0 votes
0 answers
46 views

Select building facades that face the street

I have a set of buildings (building footprints) and a street network. The buildings have attribute Use. I need to transfer the value of attribute Use as well as the length of the building façade that ...
Jio's user avatar
  • 652
2 votes
1 answer
84 views

KNN (<->) order by -- possible to use spatial index with a secondary order by?

From reading here as well as the docs, I know how to use the <-> operator in my order by in order to do KNN search, and this is fast and uses the gist spatial index as expected. However, I have ...
Loose_Screw_748's user avatar
0 votes
0 answers
25 views

Displaying Multiple Results in FME with a Spatial Intersection

I have a workspace that outputs planning scheme data against properties. Quite a few properties have multiple overlays and some have multiple planning zones. However, I am finding no matter which ...
Joshua J Geoghegan's user avatar
2 votes
1 answer
61 views

Combining two shapefiles containing roads of the same area

I have two layers both containing roads of the same area. One si from OSM, and the other is from another source. Both networks are quite dense and for the most part, they contain the same roads, ...
serta8199's user avatar
0 votes
0 answers
34 views

'Join attributes' failing to merge data

In QGIS 3.22.9, I retrieved data from buildings from a WFS. I want to use the 'join attributes by location' to add more data from other layers into the attributes table. To be precise: if a building ...
JT99's user avatar
  • 1
1 vote
0 answers
33 views

Point-to-line-error when joining attributes by location in QGIS

In QGIS I have several lines with an azimuth attribute. I want to write this attribute to a point layer with "Join attributes by location". The points lay right on the lines (I used the &...
Max's user avatar
  • 11
0 votes
1 answer
45 views

Spatial Join with no Related Primary Key

The example I am showing is a VERY simplified version of my dataset which actually represents 100's of points. I have point A representing a building (centroid of the building polygon), but no other ...
Joe G's user avatar
  • 191
2 votes
2 answers
70 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 ...
GIStrees's user avatar
  • 119
1 vote
1 answer
53 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 ...
ericandrethegiant's user avatar
-1 votes
1 answer
134 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 ...
Jota Q's user avatar
  • 85
2 votes
0 answers
52 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 ...
Kurt Cederholm's user avatar
0 votes
0 answers
26 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 (...
dphin's user avatar
  • 1
4 votes
1 answer
303 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, ...
leo's user avatar
  • 801
0 votes
1 answer
270 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: ...
user18791303's user avatar
3 votes
2 answers
170 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 ...
rtaani's user avatar
  • 557
0 votes
0 answers
38 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 &...
Oalvinegro's user avatar
1 vote
0 answers
40 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 '...
lianal's user avatar
  • 21
0 votes
1 answer
46 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 ...
fed's user avatar
  • 27
2 votes
2 answers
96 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 ...
Fezter's user avatar
  • 21.9k
1 vote
1 answer
48 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 ...
JTHW's user avatar
  • 13
0 votes
0 answers
102 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 ...
Manuel Popp's user avatar
0 votes
0 answers
54 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 ...
Jason Leland's user avatar
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)....
shrey_shankar's user avatar
1 vote
1 answer
233 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/...
Oalvinegro's user avatar
0 votes
1 answer
204 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 ...
Honeybear's user avatar
  • 2,464
0 votes
0 answers
176 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); ...
Sam's user avatar
  • 11
0 votes
1 answer
51 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 ...
Lost_Smoking_Snake's user avatar
1 vote
0 answers
132 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-...
Nabil's user avatar
  • 31
0 votes
0 answers
25 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 ...
coral's user avatar
  • 81
2 votes
1 answer
408 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 ...
LostinSpatialAnalysis's user avatar
0 votes
1 answer
176 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:...
user55570's user avatar
  • 156
1 vote
1 answer
82 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. ...
splodyn's user avatar
  • 13
1 vote
1 answer
163 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 ...
Camillionnaire's user avatar
0 votes
1 answer
158 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, -...
Yndigo Dream's user avatar
4 votes
1 answer
96 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 ...
Jonathan's user avatar
1 vote
1 answer
206 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'; //...
user157564's user avatar
1 vote
1 answer
70 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 ...
Sedigh pagh's user avatar
1 vote
1 answer
117 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 ...
Mow's user avatar
  • 175
0 votes
0 answers
47 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 = [] ...
adamekcerv's user avatar
3 votes
1 answer
197 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 ...
i.i.k.'s user avatar
  • 1,607
-1 votes
1 answer
251 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 ...
kms's user avatar
  • 473

1
2 3 4 5
20