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
3 votes
3 answers
49 views

Joining attributes by location where percentage of polygon feature is more within a polygon in QGIS

I am trying to join the attributes of bigger polygon layer to smaller polygon layer as seen below. The location geometric predicate I used in WITHIN, so that all smaller polygons within lager polygon ...
3 votes
1 answer
58 views

PostGIS, create a view with a spatial join

I have a PostgreSQL database with PostGIS. In a scheme are two tables. Table one contains polygons with two depth values recorded per polygon. These values are stored in the datamodel in columns '...
0 votes
1 answer
20 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 ...
1 vote
0 answers
21 views

NULL values after joining a CSV file to a shapefile layer on ArcGIS Pro

I am trying to join a CSV file to a shapefile layer (points) and after the joining all column values are NULL I checked the joining field to be in the exact same type Here is my data: The shapefile ...
  • 29
1 vote
0 answers
44 views

QGIS - Graphical modeler - output shapefile is not altered

Graphical Modeller I started using Graphical Modeler in QGIS (learned about it few weeks back and I was really excited about this). Unfortunately (probably due to lack of skill) I cannot seem to make ...
1 vote
1 answer
30 views

Spatial join ST_Within

I have two tables Barnet 0 pk_uid INTEGER 0 NULL 1 1 name TEXT 1 NULL 0 2 gss_code TEXT 1 NULL 0 3 district TEXT 1 NULL 0 4 lagsscode TEXT 1 ...
  • 155
0 votes
0 answers
14 views

Scheduled Python script arcpy.SpatialJoin_analysis line of code resumes only when I log into the machine

I have a python script (scheduled by windows scheduler) on a desktop I remote into. all lines of code execute without me being remoted into the machine except when it gets to this line of code below ...
-1 votes
1 answer
15 views

Join Data with summarize (max) in ModelBuilder [closed]

I want to add this process to the ModelBuilder (there are a lot of data needed to do with this step) but apparently, this is different with spatial join. I have been trying spatial join (one to one ...
0 votes
0 answers
32 views

Merging nearly identical, imperfectly overlapping line shapefiles (of railways)

I have digitized and (imperfectly) georeferenced old railway maps in QGIS. In the figure below you see two of the resulting line shapefiles representing two different years. Due to poor georeferencing ...
  • 9
1 vote
1 answer
24 views

QGIS - create new feature layer with total counts after join

I have a dataset with counts (coutns). These are spatially joined to polygons with 'fid' (column 3). As you see in the attached image, id '1' with counts '5' belongs to fid '330832'/ id '2' and '3' ...
0 votes
0 answers
11 views

How can I get line IDs in one shapefile to points along those lines in another shapefile?

I have two shapefiles. One polyline shapefile that contains an ID attribute and then another shapefile containing points along these lines. I would like each point to have ID of that line where they ...
  • 287
2 votes
0 answers
52 views

Newly created multipolygon layer fails to save due to large file size

I used the function "Join attributes by location" to join a number of polygon circles (a multipoylgon layer) with the values of the points (multipoint layer) that are "contained" ...
  • 33
1 vote
0 answers
35 views

Get feature from WFS based on the location from points

I have several hundred GPS points which I want to join additional data to (e.g. corresponding district). Since the points are spread over a whole country it seems not possible to pre-load every ...
  • 143
1 vote
0 answers
15 views

Extracting names of POIs from multiple point feature to polygon

I have many point features and polygons, The point file contains names of the POIs, what I want to do is, through spatial join I want to extract the names from the point file to the polygon, the only ...
1 vote
0 answers
43 views

QGIS Join by location results in NULL fields

I try to join data by its position. I have one layer with GPX data as points and another layer managing zones as polys. I wanna get the data from the poly where the corresponding point is within and ...
  • 143
1 vote
2 answers
39 views

Fixing multiple gap errors within polygon shapefiles using ArcGIS Pro

I did a Land Use Land Cover Classification based on multiple and different source shapefiles. The problem I'm facing in the result now is that there a thousands (about 50.000) of little gaps which I ...
0 votes
0 answers
42 views

ST_Contains not returning a correct result

I'm trying to do a spatial join between a table that stores locations of photos and the table with names and geometries of countries and the table containing locations of major cities. For example ...
  • 109
0 votes
1 answer
35 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 ...
  • 13
0 votes
0 answers
15 views

Specifying particular year in multi-year time series raster image service when attempting spatial join using ArcGIS Pro

I've been trying to grab land use data over a period of time within a set of polygons, but when attempting a spatial join (either through the right-click menu, through the specific tool or through an ...
0 votes
0 answers
19 views

Problems with "Join layer" - Joining points and a polygon. (ArcGIS-Online)

I have a polygon map with different values (1-10) and various points spread across those values with lat/long coordinates. I am trying to join to determine the value of each point. When I do the join, ...
  • 11
0 votes
1 answer
39 views

Near Tool not working in ArcGIS Pro possibly due to coordinate systems

I have 60,000 points (denoting properties) in a raster and I'm trying to measure the distance from each one to a line (denoting the coastline). I've tried using Near and a couple of other tools like ...
1 vote
2 answers
91 views

Relationship by location in QGIS

I have two feature classes: point and polygon. The purpose is to make geometrical relations between them. For instance, if points are within a polygon then automatically make the relation between ...
3 votes
1 answer
228 views

Merge polygons that are within determined distance

I have a shapefile containing numerous polygons. I want to merge polygons that have another polygon within a 10 meter distance.
  • 343
1 vote
1 answer
115 views

GeoPandas Spatial Join with random samples

I have a geopandas DataFrame with Polygon geometry and another one with POINT geometry. I'd like to do a spatial join between them and randomly select a set of points that are within certain distance ...
  • 365
1 vote
0 answers
24 views

Summarizing binned feature attributes after spatial join?

I am trying to perform a spatial join of cell traffic data to RF Coverage polygons. What I am trying to do is perform a spatial join between the traffic and the coverage polygons so that the total ...
  • 43
4 votes
1 answer
71 views

Unable to execute spatial join after CRS transformation in GeoPandas

I'm trying to join a points GeoPandas GeoDataFrame with a polygon GeoDataFrame, but I'm getting an empty results (inner join). The points GeoDataFrame I'm loading it by using latitude and longitude. ...
0 votes
1 answer
100 views

Spatial Join with largest overlap does not work in ArcGIS Pro

I'm trying to do a spatial join with a parcel shapefile and a soil-water shapefile. I tried to do a one-to-one spatial join with the match option "largest overlap", so the parcel shapefile ...
0 votes
0 answers
55 views

Merge spatial polygon with panel data

I have a grid shapefile with a total number of 10667 polygons (gid) dput(head(grid.sp)) new("SpatialPolygonsDataFrame", data = structure(list(gid = c("183253", "183254",...
  • 39
5 votes
2 answers
151 views

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

I am using QGIS v3.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 ...
  • 51
0 votes
2 answers
22 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. ...
  • 269
4 votes
2 answers
311 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 ...
  • 121
2 votes
2 answers
105 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 ...
  • 23
1 vote
0 answers
34 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 ...
1 vote
1 answer
41 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....
3 votes
1 answer
81 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.
  • 41
1 vote
0 answers
27 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 ...
3 votes
1 answer
225 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....
0 votes
0 answers
45 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....
2 votes
1 answer
128 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 ...
6 votes
1 answer
121 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 ...
  • 61
2 votes
1 answer
37 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 ...
0 votes
0 answers
45 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 ...
0 votes
0 answers
43 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, ...
1 vote
1 answer
74 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, ...
1 vote
1 answer
104 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 ...
0 votes
0 answers
11 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 ...
0 votes
0 answers
20 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 ...
  • 1
1 vote
1 answer
62 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",&...
  • 13
3 votes
1 answer
819 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 ...
  • 592
0 votes
1 answer
58 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 ...
  • 13

1
2 3 4 5
18