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
1answer
36 views

QGIS: virtual layer with spatial query crashes

Working with QGIS 3.10. Details: This should be really simple, but I am unable to solve it: I've got a point layer with two numeric fields "max" and "min", and a polygon layer. I ...
4
votes
1answer
34 views

Adding field by proximity using ArcMap

I'm using ArcMap with the Basic license. I have turnout gates (points) on or very close to irrigation facilities (lines). The irrigation facilities have a field for type (canal, pipeline, culvert, etc....
2
votes
1answer
27 views

Spatial join with overlapping polygons

I have a dataset with two layers: a Planned Projects polygon layer and Roads represented by lines. The lines intersect one another, the Planned Projects polygons overlap. Using a spatial join that ...
1
vote
1answer
22 views

ST_GEOMETRY points: get attribute of intersecting polygon

I have an SDE.ST_GEOEMTRY point feature class. I want to create an SQL query from the points. The query would perform a spatial join/intersection with an SDE.ST_GEOMETRY polygon feature class. An ...
-1
votes
0answers
15 views

Creating new layers of points according to a multipolygon layer in R

I have a shapefile of points and another one of polygons. I'm trying to create new separate layers of points based on the division of polygons. i.e a new shapefile that contains all the points that ...
1
vote
0answers
21 views

Failure to pick up attributes following use of ArcGIS Pro ModelBuilder: Iterate Feature Classes

I have a folder containing numerous point shapefiles (Species occurrence records) and (in a separate folder) a multipolygon shapefile of small parcels of land. For each species, I need to extract all ...
3
votes
0answers
31 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 ...
4
votes
2answers
58 views

Combining data with partially overlapping polygon layers? (QGIS)

I am new to QGIS. I have a dataset with Baltimore neighborhoods, and then a series of datasets for Baltimore census tracts dating back to the 1930s. My goal is to look at how population and the amount ...
2
votes
1answer
60 views

Plotting data with centroids only

I am fairly new to spatial analysis and I am trying to create a map of the spatial distribution of pollution in the UK using publicly available data retrieved from https://uk-air.defra.gov.uk/data/pcm-...
0
votes
0answers
37 views

Improving PostGIS performance for spatial intersection

I have a fairly large table with line geometries, representing roads (about 900k rows) and a table with polygons representing land use (about 8k rows). I want to know what type of land each road ...
1
vote
1answer
27 views

Is there a way to merge a grid with a shapefile?

I'm using QGIS and I have a shapefile that's a grid I created and another shapefile that is points. I would like to join them so each grid section is linked with points that fall within in. The grid ...
1
vote
0answers
38 views

Create non trivial join/view via PyQGIS in a QgsProcessingAlgorithm

In the context of QgsProcessingAlgorithm, what is the best way to take information from several layers and output based upon that combination of layers? or: What is wrong with my layer creation? The ...
0
votes
0answers
25 views

How do I join ACS data to this Census shapefile?

I'm using QGIS. I am trying to join the .CSV data from the American Community Survey (ACS): https://gisdata.mn.gov/dataset/us-mn-state-metc-society-census-acs With the shapefile from the 2010 Census: ...
1
vote
0answers
68 views

Join attributes by location in QGIS 3

I wonder if there is a better way to join attributes based on location. I have a vector layer with polygons representing lines. Layer A is the layer where I want to take the correct attributes and ...
2
votes
0answers
34 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 ...
0
votes
1answer
19 views

Create a table of points that intersect with polygons in ArcGIS Pro

I have a set of polygon and point data. Each polygon shares the same area with dozens of points. I want to create a table that shows which points intersect with which polygon. What is the best tool ...
1
vote
1answer
44 views

Assign nearest point values to polygon

I am using 3 feature classes in ArcGIS 10.7 an irregular spaced set of data points. a set of regular spaced points 100m apart that covers the data area of 1, generated using Fishnet. a polygon of ...
3
votes
0answers
56 views

QGIS virtual layers and slow performance

I am using QGIS to create a layer comprised of counties in 7 northeast US states. I start with the US census 5M cartographic state borders file, and then set a filter on that layer: "NAME" ...
1
vote
1answer
13 views

Choosing tool to add field based on nearest neighbor using ArcMap

Using ArcMap, I have two feature classes. The first is my polygon parcel layer with crop type, irrigation type, owner, etc. The second is my line canal layer, which has a field for our water schedule (...
0
votes
2answers
73 views

Problem with spatial join of large shapefiles

I want to combine the attributes of five shapefiles into one shapefile using QGIS. Therefore, I used several data processing steps including clipping the five shapefiles to the boundaries of my ...
1
vote
2answers
36 views

ArcPy Spatial Join, use join geometry not target

My goal is to create a layer of lines representing the closest street segment to a set of points. The code: arcpy.SpatialJoin_analysis( target_features=point_req, join_features=...
0
votes
1answer
16 views

Combining information from two point layers based on the nearest neighbour relationship

I have two layers: One a modeled dataset with points on a 1x1km grid across the globe. I also have another layer which is my own data points which are scattered across the globe. What I want to do is ...
2
votes
0answers
23 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 (...
0
votes
0answers
23 views

Interpreting results from Join Attributes by Location (Summary) in QGIS

I have 2 layers Map of Chicago by ZIP code Vector data of grocery stores (obtained by taking the point data of grocery stores, converting it to a heat map, and then using Raster Pixels to Point to ...
4
votes
2answers
224 views

Combining CSV and shapefile to find area name where stations are located

I have one shapefile with marine areas. The other is a CSV file with some station names and coordinates. I would like to get table with stations names and corresponding marine area names, where the ...
1
vote
1answer
75 views

Concatenating names of the districts and the numbers of the sections in the polygonal layer of streets based on intersection

In QGIS 3.14 I want for a layer with street contours (polygons) to record the names of the areas through which the street passes and the numbers of cadastral plots through which it passes. If a street ...
1
vote
1answer
454 views

Error while using sjoin in GeoPandas

I have a problem with GeoPandas sjoin, I work with Ubuntu and I want to use: opolskieadresy = geopandas.sjoin(smallopolskie, adresy, how="inner", op='intersects') and i'm getting error: ...
0
votes
0answers
23 views

Merging multiple point shapefiles that have same coordinates but different years

I am using ArcGIS Pro. I have 35 shapefiles of point data, with each layer representing a different year of data collection. Each layer has points with the same coordinates. I want to bring these ...
1
vote
1answer
18 views

Match centroids from one dataset with polygons of another

I want to make a data frame showing which voting precincts are in each school zone. To do this, I want to see which precincts' center points are in which school zones. library(sf) precincts <- ...
0
votes
0answers
9 views

How to merge self-created grids of areas and match it with county-level demographic information using tidycensus package in R

I have manually created grids of 20 mile radius each, across USA. Additionally I have also downloaded the demographic information at the county-level from US Census using tidycensus package in R. I ...
1
vote
1answer
30 views

Overlapping score for each feature in the merged layer after spatial joins

I've clicked on the Join attributes by location button and can join two layers. But in the merged layer, how do I find out percentage of overlap/intersect calculated for each feature? For example, in ...
0
votes
0answers
27 views

How to make `st_join` stricter?

I used st_join() to combine t1 and t2. library(sf) j <- st_join( x = t1, y = t2 ) t1 represents voting precincts boundaries and t2, school zone boundaries. In some cases, the boundaries of t1 ...
1
vote
1answer
30 views

Spatial joining two polygon objects in R?

I want to combine voter precinct data with school zone data. Precinct boundaries do not line up neatly with school zone boundaries in all cases. Code look something like this: library(rgdal) library(...
0
votes
0answers
9 views

Spatial Join 3D point datasets: Ecological Marine Units (EMUs)

I have a global set of sampling points (N = 500+) that I would like to attribute with the Ecological Marine Unit (EMU) classifications near which they fall. The EMU dataset and my sampling dataset are ...
1
vote
1answer
68 views

Joining attributes by location using QGIS

I have a dataset of around 15000 events (protests) with latitude+longitude coordinates, and I would like to know in which US congressional district each event occurred. I've found a shapefile of US ...
3
votes
1answer
70 views

“Join Attributes by location (summary)” only with more than 50% of overlapping area

I have been using the "Join attributes by location (summary)" tool in QGIS to help create heatmaps. I am wondering if there is a way to only join a feature if it overlaps more than 50% ...
3
votes
1answer
36 views

QGIS 3.4 Spatial Join error message interpretation

I had a problem when spatial joining two polygon layers. The error message says: " Feature (182) has invalid geometry. Please fix the geometry or change the Processing setting to the "Ignore ...
4
votes
1answer
86 views

Join on field with multiple values

I have a field "istat" that contains multiple values ​​of the istat code (municipal code): and a table containing the centroids of the municipalities I am looking for a way to join the &...
2
votes
1answer
55 views

Aggregate polygons from one table in PostGIS by proximity, area and date

I'm looking for guidance on a pgSQL query to dissolve polygons in PostGIS that are within 200 m of each other, have the same creation date and are above a threshold area. I am trying SELECT ...
0
votes
0answers
22 views

How to get polygons contained within another polygon, including those that touch the border in BigQuery Standard SQL?

I'm trying to get blockgroups contains within a designated market area polygon in BigQuery. I've tried using st_contains and st_covers but I still only get the completely contained ones (and not the ...
3
votes
1answer
64 views

Algorithm qgis:joinattributesbylocation not found

I would like to join attributes by location using standalone PyQGIS but I'm getting error. I have QGIS 3.16 installed on my machine. from qgis.core import * QgsApplication.setPrefixPath("C:/...
0
votes
1answer
38 views

Pairing line segments that follow a similar path

I have a shapefile with a regional travel model comprised of straight line features (model.shp, blue in the image). These lines roughly match the actual paths of the roadways they represent (road.shp, ...
0
votes
1answer
38 views

Joining X and Y coordinates form CSV with shapefile [closed]

I am working in QGIS. I have a shapefile showing regions of Sweden. In a .csv-file I have X and Y coordinates which I want to link to the shapefile spatially. How can I do it?
0
votes
0answers
29 views

Using Spatial Join in ArcGIS Desktop

I am having an issue when trying to use the spatial join tool in ArcGIS. I have 2 datasets: Tennessee Counties Tennessee Protected Areas I want to join these two datasets so that I have the total ...
1
vote
0answers
48 views

Clipping multipatch with 2D polygons using ArcGIS Pro

I am using ArcGIS Pro. I have a multipatch dataset and 2D polygon dataset. Is there an automated way how I can clip one multipatch into separate features? Using clip and split tools gives a ...
0
votes
3answers
30 views

Separate boundary from adjacent polygons [closed]

I have a list of polygon features that share a common boundary. Is it possible to extract that line somehow? I am thinking about making a spatial join that shows me polygons that share a line segment, ...
3
votes
3answers
61 views

Calculating value of unique points in polygon in PostGIS

I'm working with a spatial PostgreSQL database that contains species records, there is a point layer 'spp_points', each point has a "spp_ID" and "spp_score" field. I also have a ...
3
votes
1answer
65 views

Removing one to many links when performing spatial join in GeoPandas

I am spatially joining census data to building data using GeoPandas spatial join gpd.sjoin(left_df=gdf_building,right_df=gdf_census_data, how="left", op="intersects"). In the ...
0
votes
1answer
28 views

Spatial Join not adding votes correctly when mapping election precinct data by County using ArcMap

I was given precinct level election data but need to make a map at the county level. The precinct data does not have any Counties listed in the attribute table, so I took a county layer and did a ...
0
votes
0answers
10 views

Spatial join with field mappings yields zero value when inputs are layers made from feature classes

this might be more of a bug report than a question, but I encountered this strange behavior in ArcPy and was wondering if anyone else has experienced the same issue. Summary: I was trying to perform a ...

1
2 3 4 5
15