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
1
vote
0answers
13 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 ...
3
votes
1answer
35 views

Adding list of overlapping polygons to attributes of unique polygons in QGIS

I have two vector layers each made up of around 1000 unique polygons. Is there a way to add to the attributes of each polygon in Layer 1 a list of the polygons it overlaps in Layer 2? Can this be ...
0
votes
0answers
20 views

Meaning of merge rules for overlapping features in spatial join

I used Spatial Join in ArcGIS Pro. The joining features were polygons with overlaps. There were some areas where 5 features overlapped each other. I used the default merge first tool and one-to-one ...
0
votes
0answers
24 views

Dynamic Segmentation on QGIS

I'm working on QGIS 3.16.7-Hannover and I need to get one layer from two layers that belong to the same lines but have different data and a different segmentation. Both are calibrated. The resulting ...
1
vote
1answer
36 views

Create a frequency map from overlapping polygons (for large/complex polygons)

I have vector layers (polygons) of burned areas for a series of 33 years and i need to create a frequency map from the overlapping of this polygons (1 if there is no overlapping, 2 if there are two ...
0
votes
0answers
20 views

Get raster point values for multiple coordinates

I'm currently working on my thesis. I have 126k REIT properties loaded into QGIS by coordinates. On top of that I have the the full US FEMA floodzone shapefiles (13GB). However in order to join ...
6
votes
3answers
155 views

Aggregating result of many to many join of points closest to line in QGIS

I have a layer of points and a second layer of lines. The goal is to know for each line, how many and which points (by "ID") are closest to that line, to then export this information for ...
1
vote
1answer
38 views

st_intersects with ST_Dump throws PostGIS exception

I have a query in my lines and points table. My lines table includes MULTILINESTRING, MULTILINESTRING Z, LINESTRING geometry type data. select * from sde.line h2 left join sde.points b on ...
1
vote
0answers
19 views

Polygonize OS Mastermap. Join by Location QGIS

Our Provider of OS MasterMap data doesn't include filled polygons in the DWG data we buy for projects. I would like to be able to create Polygons of the features. The Buildings layer works fine (shown ...
0
votes
0answers
28 views

ArcMap spatial join only partially working

I have 141 main polygons, and then a list of thousands of smaller polygons that are clipped to the main polygons. I am interested in knowing what percentage of the surface area of the main polygons is ...
1
vote
1answer
34 views

Spatial join 2 polygon Feature Collections and count number of times they intersect

I have 2 ee.FeatureCollections in GEE. The first is a square grid polygon layer. The second is a polygon layer made up of multiple irregular rectangles that overlap with one another. I want to count ...
2
votes
1answer
55 views

Spatial join of two polygons using GeoPandas

I am trying to preform a spatial join between two vector files where i have one polygon-grid and a classified vector-file, as shown below: I would like to be able to classify my grid according to the ...
2
votes
1answer
35 views

Spatial join sum error using ArcMap

I'm working with two political boundary shapefiles from Brazil. One is a municipality shapefile, and the other is the broader micro region, which contains all the municipalities. I'm trying to ...
1
vote
0answers
68 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 ...
1
vote
1answer
46 views

Spatial Join takes very long time on two small datasets using PostGIS

I have two datasets: A is a hexagon grid and has 19089 rows B contains linestrings and has 18641 rows I want to know, which linestrings are within which hexagon. WITH bufferedB AS ( SELECT ...
0
votes
0answers
14 views

Adding 2D information to a 3D dataset in ArcGIS Pro

I am working in a local scene (ArcGIS Pro) whereby I have a 3D dataset that shows buildings within a city. This dataset has no further information (i.e. no attribute table) and all the 3D buildings ...
0
votes
0answers
23 views

Spatial Join in ArcPy - one point shapefile to multiple polygon files

I want to join a point file to many polygon files (i.e. different shapefiles) using a spatial join. Trying to do this in ArcPy via this script. My thought was that the script would do a spatial join ...
2
votes
1answer
123 views

Fix features with invalid spherical geometry (polygon shape file) for s2 geometry (V 1.0) in sf() within R [st_join() or st_intersection()]

Since the update of the sf package (V1.0) simple operations such as st_join() or st_intersection() may be hampered by features with invalid spherical geometry such as: [XY] Loop XY is not valid: Edge ...
1
vote
1answer
49 views

Union multiple layers - reduce rows if exactly same geometry

I have 10 tables with different attributes. Geometries are grid polygons. Each table have their own gridID numbering, so that cannot be used for joining. Pure union of tables producing total of 2 600 ...
0
votes
0answers
14 views

Inconsistent Spatial Join Results using ArcMap

I am trying to get rid of overlapping, incongruous lines representing the same road. I have done this successfully on an exported subset of my feature class (13 rows) with this process: Buffer FC by ...
1
vote
1answer
24 views

Sum of a attribute at different points with the same coordinate

I am quite new to ArcGIS. I want to know how can I sum the number of different assets at the same point in a table as follows. As a result, I want to have a table as follows:
1
vote
1answer
45 views

Weighted mean in attribute union with QGIS

I have joined Argentina's census data wich has small area divisions, with electoral disctrict data wich has a bigger area than those of the census. In QGIS, I've calculated centroids for the census ...
0
votes
0answers
18 views

Join feature class from ArcGIS Online with attachments to feature class in file geodatabase

I created a basic structure survey web map for Collector. My mistake was not assigning a GlobalID to the feature class before pushing to ArcGIS Online. Approximately 2,000 structures were inspected ...
2
votes
2answers
63 views

Efficiently join two large point layers by location [closed]

I need to join two point layers containing several million points each. One has an ID and population density, the other has an ID and a settlement model (SMOD) categorization. The attributes of those ...
1
vote
1answer
72 views

Geopandas spatial join giving empty result [closed]

I have two GeoDataframes : one has polygons, the other points. df_points x y z geometry 0 1844035.96 5172079.80 172.74 POINT (1844035.960 5172079.800) 1 1844036.48 5172079.77 172.78 ...
7
votes
1answer
133 views

Performant possible pairs in concave polygon

My objective is to create all possible pairs of connecting vertices in a concave polygon, i.e. only keeping those lines which are covered entirely by the polygon itself. I have come up with the ...
1
vote
0answers
37 views

QGIS omitting repeat fields in a CSV

Total QGIS noob here who started using the software last night, I've looked all over SE for a solution but nothing helped. I joined a shapefile to a CSV. The join field is 'market_number', target ...
2
votes
1answer
88 views

Counting points in overlapping polygons using GeoPandas

I have converted a 200m x 200m point grid of Greater London into a multypolygon 500m radius buffer layer for each point in the grid. What this means is that I have over 100,000 overlapping polygons. I ...
1
vote
1answer
91 views

Creating relations many to one in QGIS [closed]

I have a vector layer with polygons A, and the second with polygons B. Polygons A includes/are intersected by several polygons B. I want to join the data (just names of polygons) from polygons B to ...
6
votes
3answers
345 views

Invert the ST_DWithin() function

Is it possible to perform a query like this: SELECT * FROM foo JOIN bar ON ST_Dwithin(foo.geom, bar.geom, > 10); -- the > 10 means that I want to select everything that is ...
2
votes
1answer
43 views

Checking if boundaries of two geometries touch using PostGIS

I am fiddling around with this dataset http://s3.cleverelephant.ca/postgis-workshop-2020.zip. It is used in this workshop http://postgis.net/workshops/postgis-intro/spatial_relationships.html. I have ...
0
votes
1answer
27 views

Splitting lines by polygon boundary and attaining polygon ID

I have a layer with the road network (lines) and a layer with municipalities (polygons). I'd like to split the lines by municipality borders and then attain the name/id for the municipality the road ...
0
votes
0answers
40 views

Help joining two polygon layers using ArcGIS Spatial Join

I am trying to use ArcGIS Pro to spatially join approximately 600,000 polygons in ESRI TitleInfo with the polygons in this London landuse dataset. However, the spatial join fails to match any record. ...
1
vote
0answers
28 views

For Join Attributes by Location, how should I set up geometric predicate in QGIS?

I want to calculate the distribution of attributes of a vector layer in a grid layer by using "Join Attributes by Location (summary)". My question is, how to set the geometric predicate so ...
1
vote
1answer
42 views

Spatial join with "IF" operator and "Closest" match option

To add AdressIDs from a point feature layer to noise immission point features (Target, green points)), I need to spatially join immission points (IPs) to addresses (Join Features, red points). The ...
1
vote
1answer
33 views

Joining by location and by fields simultaneously using ArcMap

ArcMap 10.4.0.5524 for Desktop. No internet connection. I have points with street names and lines with street names. I would like to join the points and the lines (giving the attributes of the lines ...
1
vote
3answers
102 views

Transforming EPSG:26918 to EPSG:4236 in GeoPandas

I am trying to transform a shapefile of polygons projected on CRS: EPSG:26918 to EPSG:4326 so that I can perform a spatial join in GeoPandas over two shapefiles. My previous code allowed me to simply ...
0
votes
1answer
30 views

Joining polygons to points returns no rows?

I'm trying to join a 1000m fishnet grid to a layer of points, so that for each point I can find out which grid cell the point lies in. Both the grid and points layers are saved in a file Geodatabase. ...
1
vote
1answer
83 views

GeoPandas Spatial Join Error: 'left_df' should be GeoDataFrame, got <class 'geopandas.geoseries.GeoSeries'

I have a gdf with this characteristics: gdf.info() <class 'geopandas.geodataframe.GeoDataFrame'> Int64Index: 405943 entries, 0 to 405942 Data columns (total 7 columns): # Column Non-Null ...
2
votes
0answers
23 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 ...
6
votes
2answers
148 views

How to group polygons based on spatial proximity and field value?

I have a shapefile consisting of the day of the year on which the temperature in a lake exceeds 15 degrees Celsius. I can see clear patterns in this (here seen as a raster): I want to group the ...
1
vote
0answers
47 views

Ideas to improve spatial query PostGIS

I am constructing dynamic sql query with spatial filtering. It works, but I would like to speed it up - now it takes about 400msec for execute on ~ 5000 rows... I have created spatial indexes. My ...
0
votes
0answers
37 views

Join by nearest Error: Could not convert value "LSU" to target type

I am trying to join a point shapefile to nearby sampling locations in the Graphical Modeler, but the following red text appears in the model log: Feature could not be written to ...
0
votes
0answers
24 views

Polygons getting named multiple times using ArcMap

I was looking at a dataset of votes in California and wanted to get a normalized map of voting trend. The dataset I had was of precinct votes in county and polygons of the counties. I completed the ...
3
votes
3answers
132 views

Counting points in polygon and printing out each placing

Here is my sample table for further description: I have a original point layer: ID Name X(latitude) Y(longtitude) ID1 Dog A 1 ID2 Cat A 1 ID3 Bird B 1 ID4 Cat A 2 ID5 Cat B 1 ID6 Dog A 1 Those ...
1
vote
1answer
82 views

Resolving memory issues in R spatial data joins (spatial polygons)

I have two rather big spatial polygon datasets for 250m x 250m gridded data. Although they use an identical grid, they do use different grid identifiers. I'd like to join them to have a lookup between ...
1
vote
0answers
48 views

Migrating polyline sidewalk data into centerline (two lines into one without attribute loss) using ArcMap

I'm in the process of amalgamating several sidewalk datasets which require updating. All data I intend to consolidate within my centerline is based off of older versions of the data, and is a single ...
1
vote
1answer
57 views

QGIS dissolving joining lines

I dissolve lines with the same attributes. However, if these lines join, they cannot be dissolved. How can it be done?
0
votes
0answers
21 views

Join two polyline shapefiles without a common field to copy over attributes?

I am trying to sort out how to utilize two polyline shapefiles where their data doesn't have any common "data" attributes but they generally represent the same features. Spatially, there are ...
1
vote
1answer
51 views

Joining points to closest line with summary of attributes using GeoPandas

I have a streets line dataset and a GPS Ping point dataset which contains speed. I'm trying to join the points to the closest street within 15m to get an average speed along each segment. More details:...

1
2 3 4 5
17