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
0answers
19 views

Use ArcPy functions in an Oracle PL/SQL trigger?

My users collect points via Collector / ArcGIS Portal (Oracle 18c / 10.7.1 GDB). As points are collected in the feature class, I want to automatically / immediately enrich the features via spatial ...
1
vote
0answers
8 views

Is there a way to keep track of Parent Joins in Spatial Joins? (Multiple Spatial Join)

In the attached Image, I would like to do a Spatial Join From Layer 2 to get the intersecting Layer 1's ID. Afterwards, I would like to get all of the Layer 2 that aren't initially spatial joined (non-...
0
votes
0answers
33 views

Spatial thinning Earth Engine

I am trying to spatially thin occurrence data for use in a Species Distribution Model. Because my data represent "presence-only" or "citizen science" data, I am trying to account ...
0
votes
0answers
21 views

Join attributes from point into lines (but only lines with certain attribute value)

I have point objects with attributes and line objects, where the attributes are missing. The only connection between these geometries is an angle I calculated. (the labeling of the points has the same ...
1
vote
1answer
30 views

Spatial Join also Based on Attributes using QGIS

I have two data sets; points and neighborhoods (polygons). Each point has a timestamp. I need to compute how many points are in each neighborhood polygon, based on a time range. So in other words, how ...
1
vote
0answers
30 views

Why does PSQL ignore spatial index in “where NOT ST_Contains”, but uses in “where ST_Contains”?

I'm creating a new table of trips in my PostgreSQL/PostGIS database, where trips are comprised of a series of individually identified points, based on where the points within each trip are. The idea ...
0
votes
0answers
40 views

ArcPy spatial join script error

I made a model for spatial join and it is working properly but when I export as script and run in ArcPy it gave me error in spatial join. Here is the code import arcpy # Script arguments Houses = ...
1
vote
1answer
59 views

Density per grid cell

I have a shapefile with the following format. These are storm tracks and each unique "Serial" represents one storm track. import matplotlib.pyplot as plt import geopandas as gpd input = &...
3
votes
2answers
165 views

Get ID from closest feature in different layer

Application: ArcGIS Collector (Android) Platform: ArcGIS Online (hosted) Scenario: Users create and update features in a point FC via Collector. Upon creation/update, I want Collector to: ...
-2
votes
0answers
33 views

Spatial joining feature classes in two file geodatabases using ArcPy

I am new to ArcPy and I am trying to spatial join 500 point features class (in A.gdb) to 500 polygon features (in B.gdb).For every polygon fcs I need to spatial join all the point fcs on it, which ...
0
votes
0answers
30 views

Performing a spatial join to obtain attribute field summaries of nested polygons that are located within polygon regions using ArcPy

I have created an ArcPy script tool that finds depressions from an input DEM, and then generates closed contours (both polyline and polygon outputs) as well as regions (raster and polygon outputs). I ...
2
votes
2answers
71 views

Joining attributes by the biggest overlapping areas

I have two layers and I want to join the attribute of them together in QGIS. Unfortunately, the overlapping layer (The Blue one) ist not very precicse, so there are parts that overlap on small areas. ...
0
votes
0answers
15 views

ArcMap seems to be adding up values incorrectly on spatial join

I am currently trying to do a 1-1 spatial join where my merge rule should add up the lengths of polylines. However when I do the spatial join it seems to give a very large final value. The first ...
1
vote
0answers
34 views

Generating nodes at joining points

I have road network (lines) and points (Address) . With the help of closestSegmentWithContext function, I join points to nearest lines in QGIS. Is there a way to to generate a nodes at every joining ...
1
vote
0answers
17 views

How can I identify points that share similar attribute with polygon features based on the attribute & distance between the two?

For Example; if both the point & polygon features have an ID field, I need to flag the points if they share the same ID as a neighboring polygon & are w/in 2000ft of each other. I have tried ...
0
votes
0answers
20 views

ArcGIS equivalence of QGIS autofill field using *Default value* by expression and spatial relations

I am trying to find an ArcGIS equivalent for the QGIS operation that allows to fill automatically a field during the digitising using the option Default value by expression in Proprieties > ...
1
vote
0answers
26 views

gIntersection results in a new dataframe with more rows

This is my first time using rgeos::gIntersection, and I have a dataset with that I rasterized using rasterFromXYZ, then turned into a spatial polygon dataframe. I wanted to intersect this SP dataframe ...
0
votes
1answer
37 views

Matching points to grid-cells - using join attributes by location

I have point data in a shapefile covering most of Africa. I've made 0.1x0.1 grids using the make grid option from QGIS and now I want to link the grid_id to my point data. Below you will find a ...
0
votes
0answers
9 views

Merging a raster file to polylines according to their attributes

In ArcGIS Pro, I have a raster layer of slope-aspect of Toronto and I want to merge it another feature which contains bus routes. How can I do it? Join tool is useless since the raster layer is not a ...
2
votes
0answers
33 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 ...
1
vote
1answer
25 views

Identify optimal subset of polygons based on cumulative overlap with a separate layer?

Take the example below, where there are four shapes overlapped by a grid of points. Suppose that each shape has a "score" attribute linked to it, where score = number of sides of the shape (...
0
votes
1answer
91 views

“Spatial join” between raster and shapefille- give raster the shapefile values with python

I have raster which has NDVI values .In addition, I have shapefile(geopandas) on top of this raster but it doesn't fully covers the raster (illustration): the shapefile has column which contain data ...
1
vote
0answers
10 views

Joining xy points to regions to enable time slider-sensitive counts

I'm attempting to create a heatmap that responds to the time slider. I'm working with historical newspapers. In one table, I have individual newspapers with fields for their years of publication and ...
5
votes
1answer
95 views

Get points within maximum distance from any point in GeoPandas

Given a set of points (with meters coordinates), I am trying to create lines between them. But I don't want to create lines of each pair of points, Iwant to create thoses lines if the distance between ...
0
votes
0answers
38 views

One-to-many spatial join in R

I want to perform a spatial join (one-to-many relation) between two Spatial Dataframe layers in R. More specifically, I have a set of lines (SpatialLinesDataframe) that need to be joined to the ID of ...
1
vote
1answer
24 views

EE Spatial Join— Generate columns in primary collection

I have two feature collections- a feature collection of different polygons (primary collection) and a .csv with various location data (secondary collection). I would like to append each column in the ...
0
votes
1answer
13 views

Spatial Join Geospatial data returning empty data frame

I am trying to spatial join two GeoDataFrames. This is how the dataframes look like: I wanted to find the points within each region, but I got back an empty data frame. east_region = gdf[gdf['...
2
votes
1answer
65 views

Difference between “Join attributes by location” and “Join attributes by location (summary)”

I'm using QGIS 3.4.4. I have a polygon layer and a points layer. When I use Join attributes by location I get the espected results. When I use Join attributes by location (summary) the task failed, ...
3
votes
1answer
19 views

Connecting output as input in ModelBuilder of ArcGIS Pro

I want to use the output of the the merge function to be the input for the dissolve function and further on for the spatial join function. However, it is only possible to use as a precondition. I want ...
0
votes
2answers
47 views

How to join shapefile to CSV (not other way around)?

I have a CSV with multiple rows per county (it contains data on number of coronavirus cases per week). I want to make a choropleth map showing the change over time, but when I join this data to a ...
2
votes
1answer
40 views

GeoPandas .sjoin polygon in polygon - works fast for some countries, but not for others

I am new to working with geodata. Setup: GeoPandas, Python3.6 I have a dataset of square polygons of 10x10km for countries. However, some of these squares are already completely in a neighboring ...
0
votes
1answer
38 views

QGIS 3: equivalent tool/plugin of ArcMap's Spatial Join within a Distance

I would like to do a join by location between two point layers in QGIS 3 (3.4.10, Coruña). I would like to get the mean (or median) value of an attribute all the points of point layer 2 within a 5 ...
0
votes
1answer
42 views

Best way to extract properties from spatial join?

I applied a spatial join to two feature collections and am trying to extract specific properties from one in order to append them to another. In order to retrieve a property from one of the features, ...
0
votes
1answer
77 views

GEE: Tile Error: Reprojection output too large when joining MODIS and ERA-5 data

I am trying to combine MODIS EVI with climate data from ERA5 in Google Earth Engine. When I run the code I get the following error: Fr_EVI: Tile error: Reprojection output too large (19686x6123 ...
0
votes
1answer
50 views

PyQgis Intersect line with polygons. Result is not Correct (some of polygons result not intersec the line)

I have a track (Line) and I want to know wich countrys/cities (Polygon) intersect this track. I try in two ways: a) With PyQgis - I use QgsSpatialIndex().intersects(track.geometry().boundingBox()) ...
0
votes
1answer
31 views

PyQGIS: Spatial Join: How do I correctly pass the parameters for qgis:joinbylocationsummary?

def joinSum(layer, j): output = 'memory:sel_{}'.format('test') params = {'INPUT': layer, 'JOIN':j, "JOIN_FIELDS": ['area_gst'], "SUMMARIES": ['...
2
votes
1answer
43 views

Spatial join in GeoPandas: Line within multiple polygons

I'm having a GeoDataFrame of lines and a GeoDataFrame of polygons. The polygons have an attribute with the altitude of that polygon. For each line, I want to find in what polygon it is located. As ...
1
vote
1answer
64 views

BigQuery GIS table to GeoJSON type Feature Collection with SQL and/or Python

I have some BigQuery tables with spatial data (lon, lat, point, and linestring) representing boat tracks. I'm trying to get them into a GeoJSON featurecollection like [https://geojson.org/], for an ...
0
votes
1answer
16 views

Optimize the code for one command with only one different parameter

I am not too familiar with ArcPy/Python, but since some commands are only available in ArcGIS, I try to implement my idea using ArcPy. I want to use a command several times, but each time only with a ...
2
votes
1answer
43 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 ...
1
vote
1answer
21 views

How to update attributes of a GeoDataFrame based on another database of the same geometry

How to update the attribute of a GeoDataFrame based on another database? I have a master GeoDataFrame with line features. I have another GeoDataFrame (say obs) which is a subset of the master ...
0
votes
2answers
25 views

How to join maximum values from a polygons layer to other gridded polygons layer in QGIS?

I have two overlapping SHPs. One is with two noncontinous polygons - values 0 is blue and 1 is green. Now I have 9 meters grid for the same area, but I need to "fill" the grid with values from ...
1
vote
1answer
75 views

How to obtain mean, maximum, and mininum of all points located within polygons using spatial joint in python?

I am trying to estimate summary statistics of points located inside a polygon. Each points in the point layer is associated with N attributes. My target is to summarize (say mean, min,..) the ...
0
votes
1answer
34 views

Apply Join by Location to a Selection in QGIS Processing Modeller

In QGIS 3.10.2 I have created a process modeler file that takes inputs from 5 input layers and creates a new layer as an output. The output layer is needed by an external program and the processing ...
0
votes
0answers
32 views

Add column from one Featurecollection to another one based on polygon name

I have code in GEE which calculates NDVI and then divides given polygons into vegetation or soil. My problem is that after I do all of this computation, I lose data fro mthe original ...
0
votes
1answer
43 views

Arcpy Batch Spatial Join Error code 000732

I am relatively new to python so apologies if this is a basic mistake. I would like to make a python script to batch run the Spatial Join Tool. The Target shapefiles are in one folder and the join ...
0
votes
0answers
14 views

Creating list of wetlands with concatenation of unique ids

I am trying to create a table of wetland types per road segment with a field containing concatenation of unique IDs of each wetland type. The source table looks like this: I would like a result that ...
0
votes
0answers
24 views

Questions regarding spatial join and joining layers via matching attributes

I am on Qgis 3.12, working on land use. I have a layer1 with the land properties (polygons) of a company, and a layer2 with the land register (polygons) of the area. These are the exact same ...
1
vote
1answer
20 views

Fast way of querying existence of a point between two dataframes

I'd like to check if a point in one dataframe exists in another using Python. I have two shapefiles / GeoPandas dataframes with each over 10000 rows, and the geometry is stored as points (eg. POINT (3....
0
votes
0answers
10 views

Use Summary Statistics and Add Join to Categorize Blockgroups

I am relatively new to GIS and am still learning how to us ArcGIS Pro. I am trying to figure out how to use the "Summary Statistics" tool and the "Add Join" tool in order to categorize blockgroups in ...

1
2 3 4 5
14