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
0
votes
1answer
13 views

What is getting nearest points between two different but nearby (almost intersecting) datasets called?

I need some terminology help as I am still learning GIS. This is related to, but not the same as, What is getting nearest points between two different but overlaping datasets called? I have two ...
1
vote
1answer
28 views

What is getting nearest points between two different but overlaping datasets called?

I need some terminology help as I am still learning GIS. I have two datasets. One with the address of every fire and it's latitude/longitude of small census tract. One with the location of every ...
0
votes
1answer
28 views

Using join in ArcGIS Pro?

I am trying to join the information from a line to that of a point associated with that point. To explain a bit, it would be adding the information from a bus line to the associated bus stops with ...
2
votes
0answers
47 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
65 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 ...
0
votes
2answers
38 views

GeoPandas sjoin with extensive quantities

I have one geodataframe that contains polygons and corresponding land use category (e.g. agricultural, commercial, retail, residential, ...) and another that contains census tract polygons and ...
1
vote
0answers
21 views

Spatial 1 to 1 join by proximity in sf and R?

I'm trying to join a Simple Feature of POINT geometry type to another Simple Feature of POLYGON geometry type using st_join and nngeo::st_nn as the person asking this other question also did. The ...
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 ...
4
votes
2answers
65 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
vote
1answer
25 views

Spatial Join Polygon to Polygon with Centroids Inside features

I have a parcel feature class with +5M features. I want to spatially join it to a feature class of regions to check if the regional code matches that in the parcel data. I've tried using "have their ...
1
vote
1answer
49 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
39 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
1answer
25 views

Fails ST_intersects(geom, select statement) for drive time

I am trying to select houses in a drive time isochrone. I have the code working fine to make the isochrone. I can't place the results in a seperate table I need the isochrone in a where clause Is ...
2
votes
2answers
39 views

FME spatial join by PointOnAreaOverlayer transformer rejects Invalid Polygon Geometry Type

I would like to perform a spatial join of points and polygons in FME Workbench by PointOnAreaOverlayer transformer. The result should be a country polygons with additional attributes from points. I ...
1
vote
1answer
54 views

Failing to JOIN ON ST_Contains

I have two tables of polygons: Table_1and Table_2. All the polygons of T1 are inside the polygons of T2. I want to SELECT the id of T1 and the name of the polygon from T2 where the polygon is located....
5
votes
1answer
106 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 ...
2
votes
0answers
35 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 ...
0
votes
1answer
33 views

Counting points contained in polygon for large number of points in ArcMap?

I'm trying to determine the number of points within a set of polygons for a large number of points. There are 2GB of lat-long coordinates in a CSV file, and I want to see how many are contained in ...
0
votes
0answers
7 views

Assigning points to buffers in MapInfo12.0

First time using MapInfo. I want to essentially spatially join a point(s) that is situated inside a buffer together (so that the point and buffer have the same numerical ID). My table currently listed ...
0
votes
0answers
18 views

Joining inplace selected attributes of polygon layer to point layer using QGIS? [duplicate]

I am trying to join (selected) information of a polygon layer with multiple fields (e.g. CO2, NO2, PM10,...) to a point layer without creating a third layer. I know there is the Join Attributes by ...
1
vote
2answers
66 views

Update a value by nearest polygon

I'm looking to be able to update a value by its nearest polygon. The below image shows polygons in green where the column roadclass = 'A' and shows polygons where column roadclass IS NULL in brown. ...
1
vote
1answer
226 views

AttributeError: 'NoneType' object has no attribute 'bounds'

I have the following geodataframes, corresponding to a regular grid: id grid_id geometry 0 48 0 (POLYGON ((2.052457758079306 41.42493869117656... 1 49 1 ...
1
vote
0answers
27 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
1answer
66 views

Why does spatial join on geodataframes return empty result?

I have two geodataframes that I want to perform a spatial join on; one is points, one is polygons. They are both dtype: int64. They both have .crs = {'init': 'epsg:4326'}. I have verified both of them ...
0
votes
0answers
18 views

Error: trying to get slot “polygons” from an object (class “data.frame”) that is not an S4 object

I am trying to join .csv file data to shape file data using @data slot. I am getting error "trying to get slot "polygons" from an object (class "data.frame") that is not an S4 object " Here is my ...
1
vote
0answers
46 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 ...
0
votes
0answers
24 views

Fieldmapping for mean and max using arcpy

I'm trying to spatial join two features. One polygon layer and one point layer. The point layer contains one field of values that I want the Mean and Min of. Im trying to use the fieldmaper object to ...
1
vote
1answer
11 views

ArcMap: Combining County Polygons for 3 separate states into one layer with attributes

I have 3 separate layers with the counties for 3 separate states: WA, OR, & ID. I want to combine them into one layer "Counties" so they all share an attribute table with the same fields. I am ...
1
vote
0answers
36 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
22 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
1answer
34 views

Transfering attributes from nearest feature using ArcGIS Desktop?

I have two layers, containing polygons (lots) and points (meters). I want to identify the closest polygon to the point, and then copy specific attributes from the polygon to the points. Is this ...
0
votes
0answers
21 views

ArcMap - Spatial Join changed the values

I just run spatial join on two big tables I have. for some reason, one of the columns has changed its values- for example, on the original input layer I had this value. : 72145367277699000 the ...
1
vote
0answers
44 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
253 views

Performing sjoin on polygons and lines without intersection using GeoPandas?

I want to join a GeoDataFrame with Polygons (circular, were created from Points with buffer) with a GeoDataFrame that has Linestrings. These polygons and lines do not necessarily intersect nor ...
1
vote
3answers
52 views

Use a .shp file to map multiple entries in a .csv in QGIS

I have a .csv file with several entries with data for events which happened in places, and a corresponding .shp file which shows the locations where the events took place. How would I go about mapping ...
1
vote
2answers
54 views

PostGIS line in polygon performance (ST_Intersects)

I am running an analysis to find lines that is covered by a polygon. I have to create the polygon from a road network (hence the buffer and union) because the the lines are not exactly equal. The ...
0
votes
0answers
13 views

Map District Data through Lat Long [duplicate]

Lat Long coordinates are available in the map through QGIS software. I have added shapefiles of district and subdistrict. How to join these files so that i get district and subdistrict against lat ...
3
votes
3answers
110 views

Joining Attributes by Location to nearest point?

I have a point feature and I want to perform a spatial join with the nearest point of another point feature (maybe even within a certain buffer distance). I know QGIS has a nice spatial join tool "...
0
votes
1answer
65 views

Subdivide raster file by polygon in R

I am trying to get a raster file of nightlights data for Brazil and subdivide/regroup it into several rasters for each state, in a list or data.frame in R I managed to download the nightlights file, ...
3
votes
1answer
49 views

Missing features after joining by attribute, but geometry is valid

I've tried joining two point layers by location on QGIS 2.18.27 (Mac iOS 10.13.5 High Sierra), but some points in the new vector don't end up appearing. One point layer is an interpolated point layer ...
1
vote
0answers
31 views

Transferring Z values from point layer to line layer using ArcMap? [duplicate]

I have two shapefiles, point and polyline, and I am trying to transfer Z values from point layer to polyline layer to calculate the pipe slope (by using manhole's depth and z value). In the ...
2
votes
2answers
243 views

Combining st_join with st_nn to include all points within, as well as within a given distance of a polygon

This is a follow up to my earlier question (Spatial join in R - Adding points to polygons with multiple corresponding points). I have successfully joined a spatial points file to a polygon file in R ...
1
vote
1answer
30 views

What is the search mechanism in “join attributes by location”?

While running join attributes by location, we can either choose one to many or one to one mapping. In One-to-one, it assigns the first located features value. What is meant by first located feature? ...
2
votes
1answer
49 views

Efficiently relate two large shapefiles for use in Python script [closed]

I have a large National Land Use Code polygon shapefile for the San Diego area as well as a large point shapefile representing the center of each pixel from the Land Use Code raster for the same area. ...
1
vote
0answers
26 views

Spatial joining (nearest) between features that fulfill query? [closed]

I have two point feature classes, one with locations wildfires were discovered, and one where lightning strikes were detected. Both feature classes contain temporal information. For each fire, I want ...
0
votes
1answer
80 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 ...
1
vote
0answers
70 views

Spatial join for closest features and using a sum merge rule in QGIS

I am trying to perform a spatial join based on nearest neighbor ("CLOSEST") spatial relationship in QGIS, and by summing the results of the join where multiple matches occur. In ArcMap there is a way ...
0
votes
0answers
27 views

Spatial Join on single feature class returning zeros

I am attempting a spatial join in ArcMap using the spatial join tool to count identical overlapping polygons in the same feature class. I have run this analysis a number of times without problem. ...
1
vote
1answer
39 views

Exporting query to identify the exact points that fall into a polygon using ArcGIS

I am using ArcGIS 10.6.1. I have a shapefile consisting of points (facilities names and adresses). I also a shapefile consisting of polygons made up of enumeration areas as well as the Local ...
1
vote
0answers
24 views

Use geometry to join Spatial Dataframe

I have two Spatial Dataframe, the first one is the Paris Polling Stations from 2012, the other is the Polling Stations from 2017. They almost have the same geography, it deffers for 20 polygons (2017 ...