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
4 votes
1 answer
38 views

Extending "Join attributes by nearest" with WHERE clause in QGIS

QGIS 24.1-Tisler and the "Join attributes by nearest" tool in Processing Toolbox which does 90% of what I need, however I would like to be able to add a WHERE clause, so join layer 1 point ...
user avatar
  • 41
0 votes
2 answers
16 views

Unable to join data from another layer

I have two polygon layers, I want to join the data based on the location from one layer to another layer. But only field is joining not the data. In image green is one layer and red is another layer. ...
user avatar
  • 259
4 votes
2 answers
162 views

Calculating mean value for points within polygon in QGIS

I have square polygons that follow the route of a boat. There is also a point layer with different measurements like salinity, temperature etc. Sometimes there is only 1 point inside the polygon, but ...
user avatar
  • 123
2 votes
2 answers
63 views

Joining two polygons where they overlap the most in QGIS

I have two layers: district (with lots of districts) and an object layer. I want to add the information where the object lies in the most to the object. For example: this object lies the most in ...
user avatar
  • 23
1 vote
0 answers
26 views

joinbylocationsummary with loop on the same input layer using PyQGIS

I have adapted a script to use "qgis:joinbylocationsummary" in a loop. I would like to adapt it so the loop adds all the .shp of the directory 'layers_I_want_to_add' to join their maximum to ...
user avatar
1 vote
1 answer
31 views

Spatial join loads indefinitely in QGIS

I am trying to perform a spatial join between a very large polygon layer and a very large point layer in QGIS. I left the process running overnight but there does not appear to be any sign of progress....
user avatar
3 votes
1 answer
77 views

Appropriating ID for all lines inside polygon in QGIS

I have 12 Polygons with a lot of lines in every Polygon. The Polygon have each its own "ID". I would like to add the "ID" of the polygon to the lines it is containing.
user avatar
  • 41
1 vote
0 answers
20 views

How to assign point feature values to line features?

I have two datasets, one being a point feature dataset and the other being a line feature dataset. Each point feature contains a traffic count value that I want to assign to the corresponding line ...
user avatar
3 votes
1 answer
156 views

Removing partly overlapping lines within the same feature

I have several layers which have features with several parts. These parts are often overlapping however and as a result the Length of the feature is often not correct when I calculate it using $length....
user avatar
0 votes
0 answers
26 views

Problem: changing EPSG projections leads to different spatial merge results

I am using python/geopandas to merge two datasets - one from WRI Aqueduct Global Flood Risk containing river basins info and one containing a list of real estate properties with lat and long I want to....
user avatar
2 votes
1 answer
58 views

ST_Within is only working on selective rows

I have two tables (Table1, 10k rows, and Table2, 100k rows). Table1 contains latitude and longitude columns while Table2 contains a geometry column (representing a polygon). I wanted to merge these ...
user avatar
6 votes
1 answer
80 views

Spatial Join with WHILE condition (in QGIS) [closed]

I'm new to QGIS and have a Spatial Join task to solve. I have many polygon features (layer 1, green in picture below) distributed accross all Germany, representing renewable energy plants. These must ...
user avatar
  • 61
2 votes
1 answer
36 views

ArcGIS spatial joins: how many species are in an area as well as averaging enviro data (polygon+points)

I am trying to work out how many species are within certain boundaries (ie. states) as well as find the average of the environmental factors (like rainfall). I am using: A map of Australia broken ...
user avatar
0 votes
0 answers
36 views

Spatially Joining two tables

I have two tables in MariaDB. I am trying to join these two tables (Table 1 and Table 2). Table 1 contains Longitude and Latitude columns and Table 2 contains a MultiPolygonGeom column, which contains ...
user avatar
0 votes
0 answers
38 views

Assigning point attributes values to respective start and end attributes of polyline using QGIS or Modellbilder

I have created a line layer manually connecting centroids of my sub catchments, then I have created a point layer (point2) of this line layer using ‘extract specific vertices’ function from QGIS, ...
user avatar
1 vote
1 answer
36 views

Error using geom_join to join nearest coordinate data

I am currently trying to join weather data from NOAA dataset that I have acquired to a county census data set. This is necessary because the NOAA data is given by Weather station and not by town, ...
user avatar
1 vote
1 answer
65 views

Joining a CSV file to a shapefile based on string fields with different length values [closed]

I am trying to join a CSV file to a shapefile based on string fields with different length values. The values on the CSV file contain up to 16 digits where as the values on the shapefile contain 9 or ...
user avatar
0 votes
0 answers
10 views

Dividing line using polygons from another layer, selecting specific line parts and join attribute

I am having two layers in QGIS; A single line layer indicating a route path (Route layer :red line in the attached pic) A buffer layer derived from a road network line layer (Buffer layer: orange ...
user avatar
0 votes
0 answers
18 views

ArcGIS Pro Spatial Join - Point to Polygon - Within cannot be used anymore?

I have a point layer and a polygon layer, and I'd like to add the Compartment number to the points based on which polygon they are inside of. Seemed like a straightforward process, selecting the ...
user avatar
  • 1
1 vote
1 answer
39 views

R spatial join-multiple criteria

I have two sf datasets and I want to find the 10 closest neighbors, based not only on distance but also on mathcing another column. For example: a = st_sf(a = 1:3, DD=c("d1","d2",&...
user avatar
  • 13
3 votes
1 answer
233 views

Using multiple predicate parameters on sjoin in GeoPandas

Looking for a way to run GeoDataFrame.sjoin() with more than one predicate. For example, on QGIS' "Join by location" tool, there is a check box of predicates to mark as needed. When trying ...
user avatar
  • 531
0 votes
1 answer
53 views

Performing near point-to-point merge with ArcPy?

I have a series of .csv datasets with points in Lat/Long mapped to Town Names: In addition, I have a shapefile containing similar data (town names with their corresponding x/y): I also have ...
user avatar
  • 13
0 votes
1 answer
37 views

Identifying the join feature and target features in ArcMap's Spatial Join

I am currently taking an online course on GIS and had a question about spatial joins. The course's example project is finding out which watersheds are in each county - there is a county feature class ...
user avatar
  • 13
1 vote
1 answer
152 views

Getting the percentage of how much areas intersects with another using GeoPandas

I have two GeoPandas dataframes, namely: grid - the base map that contains a grid of 100x100 meter squares. land - the land use of an area (e.g. farmland, meadow, etc.). How do I, upon spatially ...
user avatar
  • 69
0 votes
1 answer
47 views

Joining attributes of two points from line using ArcMap

I have layers of lines connected at two points. How can I extract information from two points on a line feature with ArcMap?
user avatar
2 votes
2 answers
65 views

Automatically populating point layer with ID of polygon it intersects in QGIS

I am using QGIS 3 and trying to populate a column of a point file that has rare species data. One of the attributes is a Wetland "ID" column. If any of my rare species points are within a ...
user avatar
  • 365
1 vote
1 answer
72 views

Difference between SDO_NN and BallTree Sklearn for Nearest Neighbors

I am trying to find nearest n/w nodes from multiple buildings in an area, I have 2 geodataframes/Tables in Oracle DB, buildings have point geometries with ID's and Nodes have point geometries with ...
user avatar
  • 111
1 vote
1 answer
60 views

QGIS join by location not working between two shape files

I am getting this weird error while using join attributes by location in QGIS, I have two layers - Source & Target. I am joining by target to source features using intersect option in join ...
user avatar
1 vote
1 answer
79 views

Creating a Multi-Step Spatial Join Tool Script (One point file to many polygons) with one point output

I am wanting to create a ArcPy Tool Script that will join a point file to multiple polygons. Ideally, the point file (input_fc) would be a parameter so it can be interchangeable. Then the polygons ...
user avatar
  • 11
0 votes
1 answer
84 views

Wrong spatial join results for points near the polygons' boundaries using Python GeoPandas

I have an issue when performing a spatial join, I have a polygon of 2x2Km squares (no overlapping between polygons) and a CSV which I converted to a geodataframe and assigned the same CRS as that for ...
user avatar
1 vote
1 answer
74 views

Calculate the proportion of the built-up property area

I have a project, which I need to calculate the proportion of the built-up property area. Theoretically I understand, how to calculate it, but the Problem is here: I have 2 Layers from WFS: https://...
user avatar
  • 31
0 votes
1 answer
57 views

Dynamically displaying polygon symbology by number of intersecting points as point layer updates using ArcGIS Pro

I have a set of polygons (municipal boundaries) and a point layer. I'd like to (eventually) create a WebApp to show the number of points inside each municipality, but that point layer is going to be ...
user avatar
  • 131
3 votes
1 answer
128 views

GeoPandas sjoin giving different results between computers

Coworker and I are getting different results from the same code on the same data. It is a very simple script where the shapefile is imported and converted to 4326, then we import the points and do a ...
user avatar
3 votes
1 answer
76 views

Joining a very large raster and shapefile in QGIS

I am using a very detailed 30 m x 30 m raster on deforestation (found here: https://storage.googleapis.com/earthenginepartners-hansen/GFC-2020-v1.8/download.html), I want to do all my analysis at this ...
user avatar
  • 31
2 votes
1 answer
37 views

Migrate attributes from old line feature to a new one where differences in geometry and common attribute exist between the two

I recently received an older Centerline modified by an external consulting firm my management team hired (which they contracted out GIS work for without consulting their own GIS staff, go figure.) As ...
user avatar
1 vote
3 answers
169 views

Joining attributes in CSV by location using QGIS

I have a shapefile which divides Africa in cells of 0.5x0.5 decimal degrees. This documents provides the longitude, latitude of the centroid of the cell and a unique identified of each cell. On the ...
user avatar
  • 445
-1 votes
1 answer
276 views

GeoPandas Spatial Join of Points and Polygons returns NaN after projecting

I have an Excel file with some points (https://www.bundesnetzagentur.de/SharedDocs/Downloads/DE/Sachgebiete/Energie/Unternehmen_Institutionen/E_Mobilitaet/Ladesaeulenregister.xlsx;jsessionid=...
user avatar
  • 3
0 votes
1 answer
82 views

ArcPy Spatial Join Loop use the output layer as the target feature

I am trying to generate a script that executes a Spatial Join between specific shapefiles. However the only values that are added to the result feature are the first and last in the list of shapefiles ...
user avatar
  • 93
0 votes
1 answer
33 views

Spatial joining one to one when join features must be unique (Point to point) using ArcGIS Pro

I am using ArcGIS Pro 2.9.0 I'm attempting to run a spatial join Join one to one Keep all target features Closest I have multiple target features in the same locations, and when I run spatial join, ...
user avatar
1 vote
1 answer
40 views

Select polygons that are within other polygons and have a certain area in PostGIS

I'm using PostgreSQL 14.1 with PostGIS 3.1 and I've got two tables malla_p and pen_bal. I want to select those polygons of table malla_p smaller than 10,000 ha that are within the polygons of table ...
user avatar
  • 2,271
1 vote
0 answers
49 views

Why count() doesn't work but size() does in Pandas? [closed]

I have a point and a polygon data and in this line I'm simply making a spatial join and group its output to count incidents per area. Currently this line works but I don't understand why it works. I ...
user avatar
  • 411
2 votes
1 answer
65 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 ...
user avatar
  • 573
3 votes
1 answer
49 views

Adding list of overlapping polygons to attributes of unique polygons in QGIS

I have two vector layers each made up of around 1000 unique polygons. Is there a way to add to the attributes of each polygon in Layer 1 a list of the polygons it overlaps in Layer 2? Can this be ...
user avatar
  • 83
0 votes
0 answers
30 views

Meaning of merge rules for overlapping features in spatial join

I used Spatial Join in ArcGIS Pro. The joining features were polygons with overlaps. There were some areas where 5 features overlapped each other. I used the default merge first tool and one-to-one ...
user avatar
  • 77
0 votes
0 answers
52 views

Dynamic Segmentation on QGIS

I'm working on QGIS 3.16.7-Hannover and I need to get one layer from two layers that belong to the same lines but have different data and a different segmentation. Both are calibrated. The resulting ...
user avatar
1 vote
1 answer
78 views

Create a frequency map from overlapping polygons (for large/complex polygons)

I have vector layers (polygons) of burned areas for a series of 33 years and i need to create a frequency map from the overlapping of this polygons (1 if there is no overlapping, 2 if there are two ...
user avatar
0 votes
0 answers
24 views

Get raster point values for multiple coordinates

I'm currently working on my thesis. I have 126k REIT properties loaded into QGIS by coordinates. On top of that I have the the full US FEMA floodzone shapefiles (13GB). However in order to join ...
user avatar
6 votes
3 answers
202 views

Aggregating result of many to many join of points closest to line in QGIS

I have a layer of points and a second layer of lines. The goal is to know for each line, how many and which points (by "ID") are closest to that line, to then export this information for ...
user avatar
  • 63
2 votes
1 answer
57 views

st_intersects with ST_Dump throws PostGIS exception

I have a query in my lines and points table. My lines table includes MULTILINESTRING, MULTILINESTRING Z, LINESTRING geometry type data. select * from sde.line h2 left join sde.points b on ...
user avatar
  • 1,604
1 vote
0 answers
23 views

Polygonize OS Mastermap. Join by Location QGIS

Our Provider of OS MasterMap data doesn't include filled polygons in the DWG data we buy for projects. I would like to be able to create Polygons of the features. The Buildings layer works fine (shown ...
user avatar

1
2 3 4 5
17