Questions tagged [spatial-join]

To join the attributes from one spatial data layer to another using their common location

136 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
0answers
814 views

Join attributes by location very slow on QGIS 3.0

"Join attributes by location" is very slow on QGIS 3.0. I have tried it with a CSV file and also with a shapefile (point layer) and a grid (made of polygons). On QGIS3.0 it takes about 3 hours to ...
4
votes
1answer
53 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). ...
4
votes
0answers
934 views

How to perform spatial join and obtain attribute in python/GDAL?

I am working on a script that will take an unprojected raster, and using a UTM grid (shapefile), will obtain the correct SRS (I have a shapefile where each zone is attributed with its numerical SRS) ...
3
votes
0answers
65 views

Joining non-contiguous polygons in QGIS

I am trying to "physically" join non-contiguous polygons of the same layer to form one (when the polygons are spaced less than 5m), without distorting the original shape. This is a building layer, ...
3
votes
3answers
97 views

Concatenate string field in spatial join in QGIS

I'm doing a spatial join between a point layer and a polygon layer. The point layer has a field called "type" which has string values. When I join this to the polygon layer, I would like to get a ...
3
votes
0answers
42 views

QGIS Join attribute by most similar lines

Using QGIS 3's (new?) Join attributes by nearest feature on two multiline layers, I get unexpected results... Namely, if a line crosses another, that is favored over one that is almost exactly the ...
3
votes
1answer
101 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 (...
3
votes
0answers
870 views

How to do effective spatial joins using spark v2.0 and python?

I need to do spatial joins and KNN joins on big geolocalised dataset. They are stored as pySpark RDDs. I've been looking for libraries to do so, but couldn't find any that fits my needs: compatible ...
3
votes
0answers
127 views

Update Join Attributes by Location

I have a shapefile with points, and a shapefile with polygons. I want to sum the attribute value of all points that are contained in a polygon, and I'd like to do this for each polygon in my dataset. ...
3
votes
0answers
756 views

Intersect two layers and get resulting features

I have X layers on a map and I need to intersect chosen layers (two per time) and color resulting features. I'm trying to get this code working // get first feature (index 0) ESRI.ArcGIS.ADF.Web....
2
votes
0answers
30 views

Spatial join many polygon layers and save ones with condition

I've got 8 polygon layers made from buffering point layers. All have index and geometry columns: I would like to select areas where at least 3 consecutive buffers intersect (like: buffer_03 & ...
2
votes
1answer
58 views

Copying fields from one attribute table to another in QGIS

I have two layers. One is point, the other one a line. They both share same x and y coordinate. How do I transfer one field from the point layer to another field in the line layer based on the same ...
2
votes
0answers
43 views

Spatial join for adjacent polygons with same attributes

I am working with QGIS 3.4.5. I have a map of soil types (~ 100.000 polygons) and I'm trying to find the best way to make a spatial join with ~5000 point features with several numerical ...
2
votes
0answers
41 views

Plotting point data from one dataset on polygon

I have a point dataset with information on: date, number of beneficiaries, and type of assistance. I want to plot/map this info on a country polygon. I tried joining attributes by location, but that ...
2
votes
0answers
71 views

GeoPandas spatial join generates error in QGIS 3.8 Python console

I want to execute a spatial join using GeoPandas in the Python console QGIS 3.8 like this: dfsjoin = gpd.sjoin(point, polygon) but it doesn't work. It always shows the following error: Exception ...
2
votes
1answer
81 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 ...
2
votes
0answers
36 views

Join attributes to nearest without repeating feature

I have two layers, one of point and one of polygons, each with approximately 1000 features. I need to join the attributes of the points to the nearest polygons. The problem is that point attributes ...
2
votes
0answers
54 views

Spatial join by argument closest, but based on majority of vertices

I'm often working with different polyline datasets which represent street networks. One of the most common tasks I have is to join information from one layer to another. Often there are no mutual ...
2
votes
0answers
58 views

postgis and st_intersects ; fail to compare a table to itself with a left join

postgresql 9.6, postgis 2.3 Following this Select features that do NOT intersect in PostGIS, I would like to compare one table to itself, to keep all records from table p1, even and above all those ...
2
votes
0answers
101 views

Add layer info to points, keeps failing in QGIS

Within QGIS, I am looking to get an extra column in the points file, describing in which layer the point lies. All points are within 1 layer: Layer source >SHP file from shapefile.zip. Validate layer ...
2
votes
0answers
233 views

R - Spatial Join Between SpatialPoints (GPS coordinates) and SpatialLinesDataFrame

I am working on a university project which combines data science and GIS. We need to find an open-source solution capable of obtaining additional information from a massive GPS coordinates dataset. ...
2
votes
0answers
190 views

Summing numeric attributes of field during Spatial Join using ArcPy?

Just performed a spatial join operation on a polygon layer (made of 500 grids cells) and point layer (1 million points). The aim was to find the sum of a field in the points layer (field AREA) during ...
2
votes
0answers
465 views

Joining attribute by location in QGIS?

I have two equal point layers (76300 features) with different attributes as a result of queries with the "point sampling tool". Now I want to merge the attribute tables using the "join attribute by ...
2
votes
0answers
44 views

QGIS Spatial Join Includes Records From Features Just Outside Polygon

I am using QGIS to do spatial joins between UK parliamentary constituency boundaries and subsidy amounts associated with areas defined by boundaries in a separate layer. The idea is to find the ...
2
votes
0answers
167 views

Determine percentage of parallelism of two parallel lines in QGIS/python

I'm trying to match some lines to each other and join attributes proportionally. Have a look at the image where S1 can appear in both A1 and A2. Let's say 30% of S1 is parallel to A1, and 15% of S1 is ...
2
votes
0answers
177 views

QGIS 'join attributes by location' algorithm produces strange results for min, max

In QGIS 2.14.11 LTR I have a point shapefile with (besides others) an attribute kd which is either 1 or 0 (never NULL) and a polygon dataset. I try to calculate minimum and maximum values for kd for ...
2
votes
0answers
60 views

Joining polygons to points when the points fall in the intersection of polygons. QGIS

I am using QGIS. I am hoping to join a set of geocoded points to polygons in such a way that the new snapefile will be points that have a new field which lists the attributes of the polygon it lies in ...
2
votes
0answers
479 views

Using the 'Mean' mergeRule with a spatial join

I have two feature classes. The first is a point file, derived from a raster, with the values for slope of the terrain. The second is a shapefile of polygons. What I want to do is spatially join the ...
2
votes
0answers
445 views

QGIS spatial join - join all features, not just one

I'm trying to do a spatial join of a feature on a polygon layer (p1) that intersects with two features of another polygon layer (p2)) via QGIS. What I want: get the attributes of both features of p2 (...
2
votes
0answers
359 views

Spatial join with multiple intersecting features

I have a polygon dataset representing pavement areas broken up by year of construction and a roads centerline dataset that contains values for remaining service life (RSL). I want to spatially join ...
2
votes
0answers
329 views

Update Attribute based on spatial location

I want to spatially (Spatial Join) update few fields, not all, from another feature class. Is there any way to select and update few fields instead of all the fields from the other layer and ...
2
votes
0answers
269 views

Trouble with polygon to polygon “Join attributes by location”

I have two polygon vector layers - one of census tracts and one of water bodies. I would like to join a particular attribute from the water bodies table to each census tract, with the output being the ...
2
votes
0answers
257 views

Automatic attribution of one layer from another based on spatial relationship?

I have two layers with a 1:many relationship. Working within ArcMap, I'd like to have that relationship somehow formalized so that when I add a new feature to the child layer, it automatically gets ...
1
vote
0answers
37 views

Unable to perform join raster-table ArcGIS 10.3

I am trying to replicate some results from a publication. There, one of the datasets they use is WISE30sec map (available for download here: https://www.isric.org/explore/wise-databases). My problem ...
1
vote
1answer
35 views

A simple way to merge lines separated by a space in QGIS

In QGIS after creating contour lines by extracting them from a DEM (Extraction > Contour) and smoothing them (Line Smoothing) I noticed this situation: In order to smooth out the corners ...
1
vote
0answers
46 views

Sliver polygons, vertex, gaps

I'm correcting a Land Use polygon, interpreting a drone image using QGIS. When I use the cut tool and merge tool to edit, the polygon leave a smalls polygons like a line, or sometimes leave a vertex ...
1
vote
1answer
53 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 ...
1
vote
0answers
50 views

Creating table of point in polygon results using PostGIS

I have one PostGIS table of polygons like this: index | lat | lon | geom where geom is a polygon d-type ex. POLYGON ((x1,y1,x2,y2.....)) CREATE TABLE buildings2 ( index integer PRIMARY KEY, ...
1
vote
0answers
30 views

Keep properties after spatial join

I have two Feature collections: One that includes the location of dams and one that provides the basin area of a river within a country. I want to use gee to obtain a list of dams constructed in a ...
1
vote
0answers
25 views

Merge attributes using spatial join where Target and Join feature is the same

I have a single polyline feature class and i need to merge one of the attributes together based on a common identifier using a delimiter (i.e. |). I was certain Spatial Join using the one feature ...
1
vote
0answers
28 views

Iteratively join linestrings that intersect?

I'm struggling to iteratively join intersecting linestrings of a geometry collection using st_join, meaning I want to join intersecting linestrings, but want to build on that join (i.e. joining all ...
1
vote
0answers
29 views

Extracting list of counties that are nested within larger geographic units in QGIS?

I have one layer/shapefile that consists of county boundaries and another layer of larger geographic divisions that each contain about 15 counties. I basically want a list of all the counties that are ...
1
vote
1answer
85 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 ...
1
vote
1answer
93 views

QGIS: Joining data from multiple road lines onto polygons by location

I'm looking to add traffic data linked to a polyline shapefile of road centerlines to a multipolygon shapefile of land parcels. I want to join this data using proximity to roads instead of by matching ...
1
vote
0answers
29 views

Accounting for intersecting features with spatial join?

I am looking to analyse the effects of the designation Marine Conservation Zones (MCZs) on fishing effort. I have a shapefile for fishing effort which is gridded, each pixel has information about ...
1
vote
0answers
107 views

Joining attributes by location/intersect works for all but one polygon in QGIS?

I used the Join attributes by location and Intersect tools in QGIS 3.4 for my points layer to add a column with name of the intersected area into the attribute table of points. It works perfectly for ...
1
vote
0answers
46 views

What could cause a Spatial Join (Completely Within) to return false positives?

Im using ArcMap 10.3 I have a large feature class of Archaeological surveys that I need to Spatial Join to a target feature class of buffered work locations to find locations that are Completely ...
1
vote
0answers
24 views

Calculating areas and joining attributes between overlapping features

I am working with QGIS 3.4.8 and Python 3.6.8 on OSX El Capitan 10.11.6. I have two shapefilea, one which is a grid of cells (each cell a feature) and the other one which is urban settlements as ...
1
vote
0answers
69 views

Performing Spatial join with polygons using st_join in R?

I want to join 2 partly overlapping polygons in R the same way I'm doing it in ArcGIS Desktop . In ArcGIS Desktop I am doing it like this: Analysis toolbox - Overlay toolset - Spatial Join. The rows ...
1
vote
1answer
137 views

Join by location (summary) returns null

I am trying to count points within polygons (311 calls by Census tract). Both shapefiles are EPSG 4326, and I've done define projection just to double-check. Every time I run Join attributes by ...