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
0 votes
0 answers
17 views

Merging shapefile with data file with coordinates

I have a shapefile 'shp' with boundaries, and I have a data .csv file with coordinates and some values. I want to join the df to shp, so that each coordinate/observation would be in the correct zone/...
0 votes
1 answer
623 views

Spatial join to append which multi polygon a point is in (GeoPandas)

Currently I have around 40 lists of coordinates I need to run the same operation on: What we will call the the points data, A) With one list of multi polygons (The polygon data, B). I need to take ...
5 votes
1 answer
108 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/...
2 votes
1 answer
702 views

Calculating percentage of area by district of land use type

I have a file geodatabase feature class, type polygon, of land use type. SEQ LU Update X project clip in the attached. I have a districts shapefile (shapefile feature class polygon). All_Brisbane in ...
2 votes
1 answer
465 views

'Join Attribute by Location (Summary)' slows down with time

I'm attempting to perform a 'Join Attribute by Location (Summary)' between two polygon layers where I calculate the sum of a given field in the join layer using the 'Intersect' predicate. The process ...
16 votes
1 answer
13k 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 ...
0 votes
1 answer
352 views

Spatial Join does not return no point inside geometry Python

I have a geodataframe containing 200 000 entries with Points, and I want to check which coordinates are inside a geodataframe containing 20 000 polygons that I am creating. The polygons are created ...
0 votes
2 answers
856 views

Merging multiple point shapefiles that have same coordinates but different years

I am using ArcGIS Pro. I have 35 shapefiles of point data, with each layer representing a different year of data collection. Each layer has points with the same coordinates. I want to bring these ...
0 votes
1 answer
179 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:...
0 votes
1 answer
212 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 votes
1 answer
35 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 ...
2 votes
1 answer
167 views

Matching polygons to intersecting polygons using ArcMap

I am trying to match a set of polygons (A) to another set of polygons (B) using ArcMap. Both sets overlap themselves, and each other. Here's an example of what it looks like in my data: The green ...
4 votes
1 answer
375 views

Joining polygon layer attributes to line segments in QGIS

I've got a hexagon layer with data that I want to have joined to the available road network for the area so that the road segments have the attributes from the hexagon layer. Each segment of the road ...
5 votes
2 answers
3k views

Using sjoin in GeoPandas

I have a GeoDataFrame with 12.431 observations of geographical units, called "cities". I also have another layer file with points, called "points". Both of them are in CRS: ...
6 votes
1 answer
195 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 (...
41 votes
6 answers
30k views

Joining attributes from nearest point in QGIS

I have two layers with points, A and B, each with different attributes. For each point in A, I want to join all the attributes from the nearest point in B. Ideally, this would also include a field ...
0 votes
2 answers
1k views

Invert of Spatial Join within (Not Within)

I have two geodataframes Source_Line (LineString) Edge_Area (Polygon) I am using Geopandas for retrieving LineStrings (Source_Line) Geometry within Polygon Following is Code gpd_sJoin = ~gpd.sjoin(...
5 votes
1 answer
318 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). ...
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 ...
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 ...
0 votes
3 answers
4k views

How to produce a 'count' of points intersecting lines?

Within ArcMap, I have a point dataset representing accident data, and a road dataset. My goal is to attribute the road dataset with a count of how many particular accidents occurred on each road ...
3 votes
1 answer
370 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
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 ...
2 votes
1 answer
206 views

Joining attributes from point layer to line layer which the endpoint's geometry matches the point geometry

In QGIS 2.18 I have 2 layers, one is a multiline layer and the other is a point layer. The point layer contain every endpoints of that multiline layer and saved some of the point's own attributes. I'd ...
1 vote
1 answer
94 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 ...
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 ...
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 ...
2 votes
1 answer
86 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 ...
1 vote
2 answers
71 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) ...
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 ...
0 votes
1 answer
152 views

Spatial Join Geospatial data returning empty data frame

I am trying to spatial join two GeoDataFrames. This is how the dataframes look like: I wanted to find the points within each region, but I got back an empty data frame. east_region = gdf[gdf['...
1 vote
1 answer
208 views

Spatial join two identical layers

I'm working with Python and GeoPandas. I have two parcel layers that are identical and in the same coordinate reference system. The parcel number field is not unique so I am unable to join on that ...
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 ...
1 vote
1 answer
100 views

Cross information in ArcMap

I'm a total amateur at ArcMap. This is the first time I use it for real. I have several shapefiles with information about: Schools in my city (elementary, middle and high school) City districts The ...
2 votes
1 answer
64 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, ...
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 ...
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 &...
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 ...
1 vote
1 answer
450 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 ...
2 votes
2 answers
71 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 ...
-1 votes
1 answer
139 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 ...
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 ...
1 vote
1 answer
178 views

Union multiple layers - reduce rows if exactly same geometry

I have 10 tables with different attributes. Geometries are grid polygons. Each table have their own gridID numbering, so that cannot be used for joining. Pure union of tables producing total of 2 600 ...
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 ...
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 (...
8 votes
4 answers
9k views

Error while using sjoin in GeoPandas

I have a problem with GeoPandas sjoin, I work with Ubuntu and I want to use: opolskieadresy = geopandas.sjoin(smallopolskie, adresy, how="inner", op='intersects') and i'm getting error: ...
4 votes
1 answer
324 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, ...
3 votes
2 answers
172 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 ...
0 votes
1 answer
286 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: ...
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 &...

1
2 3 4 5
20