Skip to main content

Questions tagged [spatial-join]

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

236 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
9 votes
0 answers
121 views

Does QGIS use data source-specific operations?

This may be a very basic question, but I couldn't find an appropriate answer. Does QGIS use data source specific operations where available and appropriate? For example, when using the Join attributes ...
Geotob's user avatar
  • 376
6 votes
0 answers
250 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, ...
Laurent Somma's user avatar
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 (...
mosquitonomics's user avatar
5 votes
0 answers
664 views

QGIS 3.10 crashes constantly when performing join with virtual layer

I want to create a pie-chart map showing the amount of groundwater extracted from different aquifers within different administrative areas like in the picture below: I have a shapefile with ...
ancyluss's user avatar
5 votes
1 answer
317 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). ...
SpatialSDE's user avatar
5 votes
0 answers
2k 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) ...
auslander's user avatar
  • 1,567
4 votes
0 answers
13k views

Meaning of "No spatial index exists for join layer" when doing spatial join in QGIS

I am doing a spatial join by location. My input layer is a shp file. It is a grid cell of the African of 0.5 x 0.5 degree latitude. It contains, a gid number which identifies the cell, the longitude ...
OgeiD's user avatar
  • 566
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 ...
perrier's user avatar
  • 119
3 votes
0 answers
114 views

QGIS- editing form auto completion

I'm new in QGIS world :) I would like to have an auto-completion script within the editing form on QGiS. When editing a point features with QGIS form, I would like the script to identify the list of ...
MGALLES's user avatar
  • 31
3 votes
0 answers
169 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 ...
A4329SF's user avatar
  • 31
3 votes
1 answer
369 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 ...
Jay Edwards's user avatar
3 votes
0 answers
170 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 ...
Leehan's user avatar
  • 1,234
3 votes
0 answers
1k 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 ...
4rzael's user avatar
  • 131
3 votes
0 answers
138 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. ...
Olfa's user avatar
  • 131
3 votes
0 answers
772 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....
Marco A.'s user avatar
  • 375
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
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
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
2 votes
0 answers
182 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" ...
user avatar
2 votes
1 answer
70 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 ...
Chris Medyna's user avatar
2 votes
1 answer
462 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 ...
Nandula's user avatar
  • 783
2 votes
0 answers
70 views

Splitting polygons with lines not working for polygons that intersect with multiple lines [QGIS]

The 'Split with Lines' tool in QGIS works well when polygons are intersected by a single straight line, but fails when it is intersected by multiple lines. For example: Ideally, I was expecting that ...
Aarthi Sundaram's user avatar
2 votes
0 answers
46 views

Need to join attributes from one point feature class to another based on line connectivity

I need points representing houses to have the ID number of the electrical pole sourcing the house. I would use a spatial join "WITHIN_A_DISTANCE", but some houses have sources that are ...
ElizaC's user avatar
  • 93
2 votes
1 answer
163 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 ...
Benji's user avatar
  • 21
2 votes
0 answers
54 views

Missing connections between line and points

I have two shapefiles line layer (Blue color) points layer which represents houses (Green color)) I am trying to connect line with points (houses). For that, I used closestSegmentWithContext as ...
Case Msee's user avatar
  • 855
2 votes
0 answers
121 views

Contour lines from AutoCAD to QGIS: how to automatically assign the right value to the Z

I have a plate of contour lines made on AutoCAD (contour lines do not have a Z). The Z is indicated only for some curves but in a text format. If you import the table in QGIS the situation is this (...
ddomizia's user avatar
  • 648
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 ...
YuYuYu's user avatar
  • 21
2 votes
1 answer
698 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 ...
DHG's user avatar
  • 51
2 votes
0 answers
131 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 ...
CesarS's user avatar
  • 21
2 votes
0 answers
52 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 ...
mapster's user avatar
  • 41
2 votes
0 answers
715 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 ...
Suhendra's user avatar
  • 117
2 votes
0 answers
190 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 ...
hugonbg's user avatar
  • 854
2 votes
0 answers
84 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 ...
Ville Koivisto's user avatar
2 votes
0 answers
120 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 ...
RobinB's user avatar
  • 21
2 votes
0 answers
138 views

Obtaining Total value of votes using spatial join in ArcMap?

I have been tasked with aggregating precinct level voting data upto the county level. I have both the layers and I used the spatial join tool to do the aggregation. However, there is a complication. ...
Dhruvil Patel's user avatar
2 votes
0 answers
298 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. ...
Seymour's user avatar
  • 121
2 votes
0 answers
282 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 ...
user109472's user avatar
2 votes
0 answers
482 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 ...
Konstantin_o's user avatar
2 votes
0 answers
46 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 ...
Chris Gordon-Smith's user avatar
2 votes
0 answers
441 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 ...
Alexejevitsch's user avatar
2 votes
0 answers
267 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 ...
Jochen Schwarze's user avatar
2 votes
0 answers
65 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 ...
Dmac's user avatar
  • 21
2 votes
0 answers
586 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 ...
msmi235's user avatar
  • 51
2 votes
0 answers
487 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 (...
menodeo's user avatar
  • 81
2 votes
0 answers
398 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 ...
cbunn's user avatar
  • 1,417
2 votes
0 answers
101 views

QGIS join by location not returning for features

I have eight contours/features in one shapefile (contour.shp) that i want to find the number of population within each contour, this is in another shp. I am using join attributes by location to do ...
mike's user avatar
  • 21
2 votes
0 answers
365 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 ...
user34810's user avatar
  • 177
2 votes
0 answers
277 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 ...
user14743's user avatar
2 votes
0 answers
264 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 ...
Eric's user avatar
  • 21
2 votes
1 answer
408 views

Query Geopackage using spatial index in QGIS DB manager

I would like to do spatial join in QGIS DB manager on geopackage database. The query should look like this select * from Soil_C_cadaster a, (select * from Soil_C_cadaster where forest_c is null) b ...
Albine Pro's user avatar

1
2 3 4 5