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
31
votes
4answers
18k views

More Efficient Spatial join in Python without QGIS, ArcGIS, PostGIS, etc

I'm attempting to do a spatial join much like the example here: Is there a python option to "join attributes by location"?. However, that approach seems really inefficient / slow. Even ...
23
votes
3answers
34k views

Join spatial point data to polygons in R

I am trying to perform a spatial join between point data and polygon data. I have data that indicate the spatial coordinates of an event in my csv file A and have another file, shapefile B, that ...
14
votes
3answers
7k views

geopandas spatial join extremely slow

I am using the code below to find a country (and sometimes state) for millions of GPS points. The code currently takes about one second per point, which is incredibly slow. The shapefile is 6 MB. I ...
13
votes
2answers
9k views

Understanding Join Attributes by Location in QGIS?

I wonder if there is somewhere an explanation for the parameters that can be set when running the Algorithm "Join Attributes by Location" in QGIS 2.18. I had a look here: Documentation QGIS Testing |...
12
votes
3answers
2k views

Getting points-touching-a-line attributes back to lines layer using QGIS?

I'm using QGIS 2.14.4-Essen. I have two layers: points.shp that contains points with a YEAR column lines.shp that contains lines that exactly connect the points from points.shp I would like to get ...
11
votes
2answers
772 views

How to perform repetitive tasks in QGIS?

I am trying to do a treatment on many feature files, so I would like to automate it. In fact, I have one shapefile with the spatial distribution of some species, and one with vegetation type. I ...
10
votes
2answers
13k views

One-to-many joins on a feature class to a table

I am using ArcMap 10.2.2 with an Advanced license. I have used ArcMap for other basic analyses, but am fairly new to the program and have only basic coding skills, with no SQL experience outside of ...
9
votes
2answers
4k views

Is there a python option to “join attributes by location”?

I am trying to perform the function join attributes by location as found on the QGIS menu Vector>Data Management Tools. I am seeking an open source python option for this. I know arcpy has a spatial ...
8
votes
3answers
7k views

Spatial join versus classical join [closed]

What are the main differences between a spatial join and a classical database join such as an equi (inner) join?
8
votes
4answers
19k views

Join CSV file to shapefile

I wanted to join a CSV file to a shapefile. When I identified a field to facilitate the join, e.g., map <- spChFIDs(map, as.character(map$ID)) it returned Error in spChFIDs(SP, x) : lengths ...
8
votes
1answer
1k views

Join by attribute / spatialite with SQL / left outer join in QGIS

I have a layer with polygons (let's call it "woods") that is intersected by "n" line-objects ("roads"). Every road has an unique attribute roadid. I need to add ALL the roadid's (not only the first ...
7
votes
2answers
12k views

Spatially joining polygon fields onto point layer in QGIS?

I have gridded depth points in CSV format that I'm trying to add other map data to, in additional columns. I've tried joining fields, hoping that I could link the Shapefile data to the csv, but when I ...
7
votes
3answers
2k views

How to do a spatial join in PostGIS that returns on the minimum value of point intersecting polygon?

I have a polygon table (buffer) and a point table (dem_points), and I want to do a spatial join on them. I need to join the point with the minimum elevation (dn) to its spatially corresponding ...
7
votes
2answers
11k views

Join / merge lines that touch and intersect in QGIS

I have a large dataset consisting of lines/polylines where I would like to join/merge the lines that touch / intersect. Each line has an individual ID and there are no common attributes I can use for ...
7
votes
2answers
4k 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 ...
7
votes
2answers
132 views

One-to-many spatial join with results in one row

I have two feature Datasets. Both are Polygons. Dataset A has very big Areas and Dataset B just small ones. Now, B still overlaps in 2 or 3 Zones from Dataset A. I want to perform a spatial join and ...
7
votes
1answer
3k views

How can you join attributes from polygons to points which are within the polygon feature using PostgreSQL and PostGIS? [duplicate]

Possible Duplicate: How to perform a spatial join of point and polygon layers in PostGIS? I don't know how to solve my actual problem. I have polygons and points (some points are located in the ...
7
votes
1answer
3k views

Split polylines at polygon boundaries in QGIS

I have a set of contour lines and a polygon set containing glaciers. Because I want the glaciers to have blue contours, I need to split the contour lines at the glacier boundaries. I can achieve this ...
7
votes
1answer
275 views

Select by Location and Join the Attributes of Two Line layers

I want to import the name of streets from OSM shapefile layer to another line layer based on neighborhood distance. The distances between two layers (line layers) are variable between 0 to 10 meter. ...
7
votes
0answers
242 views

Buffered one-to-many spatial join QGIS3 [closed]

I'm trying to spatial join bus stops and census block groups. However, these are a bit tricky with walking distance. Many bus stops are right on the borders of census block groups or within walking ...
6
votes
1answer
9k views

How to ignore invalid geometries in performing spatial join in QGIS 3.0? [duplicate]

I am attempting to perform a very simple join attributes by location between two shapefiles in the same projection. When I run it, I get an error message indicating that the algorithm could not be run ...
6
votes
3answers
2k views

Efficient spatial joining for large dataset in R

I am working with rather large data frames that I often need to do a spatial join on. The fastest way I have come up with so far is this method: library(rgdal) download.file("http://gis.ices.dk/...
6
votes
2answers
3k views

Calculating proportional area of polygon within another layer's polygon using QGIS?

I have two polygon layers, model and ntem, whose features overlap and intersect one another. I would like to calculate the proportion of the area of the model polygons which fit within each ntem ...
6
votes
2answers
594 views

Spatial Join Yielding NULL values in ArcPy?

I'm writing an automated script to do some data processing of address points. One stage of the process is to retrieve 19 fields of information from various polygon layers that the Address Points are ...
6
votes
2answers
779 views

Join multiple spatial tables by distance

I'm trying to join two tables, one which contains road names and the other just a point. After exhausting research I'm now stuck. The idea is to join up the two tables using only distance, ie, select ...
6
votes
1answer
1k views

Can Spatial Joins be used to perform One-to-Many Closest joins?

My situation appears rather simple, but it has given me headaches more than once already. I have a set of points and a set of polylines. I would like to use a spatial join to join the attributes of ...
6
votes
0answers
820 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 ...
5
votes
3answers
1k views

Spatial join with HUGE datasets

How to make a spatial join with ArcGIS with these HUGE datasets? Target: almost 3 million squares 500x500m size (the attribute table is basically empty) Join feature: 12000 polylines Operation: one ...
5
votes
4answers
223 views

Find the maximum value for a point among several overlapping vector layers in QGIS3

Dataset 1: around 80 vectorlayers with polygons. Each polygon has a value for a noise measurement. Some of the layers (up to ten at at time) are intersecting at some locations. Dataset 2: a ...
5
votes
3answers
2k views

Performing spatial join between lines that travel along each other in ArcGIS Desktop?

I have 2 layers, one representing streets, and one representing pipes. The pipe layer has a street field that I want it to be automatically filled (I want the pipe to show the street that it's on) I ...
5
votes
2answers
115 views

How to create a table which showing attributes from one layer and another?

I have two layers. The A12_zone system which is basically the zone system of UK and then another layer with some developments. Each layer has its own attribute table. I would like to create a ...
5
votes
2answers
100 views

Is it possible to merge attributes from lines which are on top of each other?

I was able to merge the different kinds of roads (verharding lijn) with the normal roadmap (Wegen 1.0). The attributes were copied to all the records, but there are empty attributes where the kind of ...
5
votes
1answer
404 views

Counting number of features within another feature using aggregating function in field calculator of QGIS?

My data: 1 polygon layer + 1 point layer My target: Calculate the number of points and the sum of a field within each polygon using the aggregate function in the QGIS field calculator. I know I can ...
5
votes
1answer
129 views

Merging two polylines (street networks)

I have the following problem: I have two street datasets from completely different sources. I need some attributes from one dataset (red lines) to be joined into the other one (green lines). Until ...
5
votes
1answer
2k views

PostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+

I need to obtain on each element on one table the closest point of another table. The first table contains traffic signs and the second one the Entrance Halls of the town. The thing is that I can't ...
5
votes
3answers
5k views

Dissolve Polygons using R / join specific polygons

I have data in shapefile format :: UK_boundaries I am new to R and Spatial data as well, I am trying to join some areas to be as one area no line(s) between them. Based on my search I understand ...
5
votes
1answer
1k views

Creating network from GPS tracks? [closed]

I'm trying to build a network from several GPS-trakcs, to digitize hiking routes on my land. I have several GPX-files from routes I've tracked with the gps. I managed to display them in Arcmap 10.2 ...
5
votes
3answers
4k views

Selecting nearest lines to point layer in QGIS?

I am a beginner with GIS software and I'm working on QGIS. I have a problem joining the spatial layers. I have a layer with objects in one city and another layer with the streets. I need to attach ...
5
votes
1answer
2k views

Where are the attribute summaries in Join Attributes by Location in QGIS 3.2.0?

I have recently switched from QGIS 2.18.21 to QGIS 3.0, and as of today, to the shiny new QGIS 3.2.0. I need to do some spatial joining so I was quite surprised to find out that in QGIS3, it seems, ...
5
votes
2answers
5k views

Scripting spatial join in ArcPy to set field attribute in field mapping object?

I'm scripting a spatial join in ArcGIS with Python. I only want the resultant feature class to have a single field containing one attribute from the join features. In general, many join features ...
5
votes
2answers
490 views

QGIS calculates main soil type of polygons from another polygon layer

I've been working with qgis for a while but somehow I never fiured this out, so I thought it's time to ask. I have 2 shapefiles. a polygon layer from nearby fields (SHAPE1 (the red outlines)) a ...
5
votes
1answer
678 views

QGIS 'Join attributes by location' algorithm (sometimes?) not working properly in graphical modeler

In QGIS 2.14.10 I've set up a simple model to assign min and max of attributes of a point layer (adresses, about 2500 features) to a polygon layer (parcels, about 14000 features) to polygons ...
5
votes
2answers
1k views

Intersect, Spatial Join?: One Line crossing Multiple Polygons, assigned wrong attribute

I am looking for any possible solutions to a problem I am encountering with ArcGIS. I am using census block groups (CBG) to assign streets an income level value based on their location within the ...
5
votes
2answers
229 views

How to select random adjacent census tract

I have set of census tracts spaced out across a city and I would like to randomly choose an adjacent census tract to explore nearby demographic data. I'm not sure if there is an easy process for ...
5
votes
1answer
2k views

Join attributes by location

I am trying to join multiple records that occupy the same location (polygon centroid) and have tried using the join by location plug-in but have found this does not work for me in this case as I have ...
5
votes
0answers
696 views

Spatial join to kernel density / kernel density with polygon/point output in Arc [duplicate]

I'm looking for a way to join polygons to a density function for some other feature of interest. Current workflow make density raster from feature set of interest, using point/line/kernel density ...
4
votes
4answers
314 views

Count number of points by name within distinct polygons

In PostgreSQL/PostGIS I have 2 tables: A POLYGON table (polytable1) with shapes named 'Poly 1', 'Poly 2' etc... Each name can appear multiple times (i.e. 20 polygons with the name 'Poly 1') A POINT ...
4
votes
2answers
587 views

Getting concatenated attribute values from Spatial Join

How can I query polygon features that intersect other polygon features in QGIS? I have ZIP code areas and city areas, and I would like to list all the ZIP codes that intersect the city areas. Example:...
4
votes
1answer
5k views

Creating spatial join between points and polygons in GeoPandas?

I want to create a simple spatial join between points and polygons using GeoPandas but I think GeoPandas has bug? GeoPandas code: from geopandas import gpd import geopandas points = geopandas....
4
votes
2answers
170 views

Spatial join based on polygon centroid in QGIS

I have 2 cleaned shapefiles, one containing building footprints and one land parcel shapes, both have attributes. I want to do a spatial join when data from the land parcel is merged into the ...

1
2 3 4 5
13