Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [spatial-join]

To join the attributes from one spatial data layer to another using their common location

0
votes
0answers
12 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
2answers
65 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
40 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
44 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 ...
1
vote
2answers
62 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
28 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
46 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
17 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
41 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
18 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
15 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
35 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
21 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 ...
0
votes
1answer
21 views

Using Spatial Join to join geologic features to polylines

I want to spatially join polygons (geologic features, major aquifers) to where the NHD polylines (rivers/streams) fall. I want to be able to click on a polyline and see what geologic feature or major ...
0
votes
0answers
28 views

Build measure of state change

I want to be able to build a measure in ArcGIS (ArcMap). (1) I have some shapefiles of sovereign states by centuries. These are polygons with the name of the state as ID. (2) Moreover, I have a ...
1
vote
1answer
54 views

Joining attributes by location error when finding polygons within district boundaries?

I am using QGIS 3.5. I have a large shapefile (760 MB) with 1800 polygons representing different bird species ranges (download link) I have a second shapefile with polygons of district boundaries (...
1
vote
1answer
47 views

Spatial join between two FeatureCollections in Earth Engine

Given two FeatureCollections in Earth Engine, one being a regular grid, the other a number of country shapefiles, I would like to produce a new FeatureCollection with the geometry of the regular grid, ...
0
votes
1answer
77 views

Convert CRS for spatial join for GeoDataFrame

I have the following 2 GeoDataFrame variables in GeoPandas. # shp.csr {'init': 'epsg:2953'} # line.csr {'proj': 'sterea', 'lat_0': 46.5, 'lon_0': -66.5, 'k': 0.999912, 'x_0': 2500000, 'y_0': ...
0
votes
1answer
77 views

Push attributes to GeoJSON in Leaflet

I am trying to add attributes to a layer. I have a select function that finds all points within 10 miles of a feature. If the point is within the radius distance I add it to an array and make another "...
0
votes
0answers
27 views

ArcGIS Pro using spatial join and query to find distance

I'm given a set of points (locations) and lines (roads) and I need to use spatial join and then a query afterwards to find how many points are 5 meters from the roads and then finding the exact ...
1
vote
0answers
28 views

Spatial join error 000426

I ran the tool Spatial Join(Analysis), target and joined features are line feature class, the join operation is Join one to one, I set a merge rule(sum) in one of my fields(the type of the field is ...
1
vote
2answers
91 views

Combining data from overlapping polygons and assign [duplicate]

I have two multipolygons layers: Layer A: Census blocks with data from 2010 (last census). Layer B: A study about poor neighborhoods with data from 2016 (POOR NH). Both layers have a "population" ...
2
votes
2answers
73 views

Aggregating census level data to county level in QGIS?

I'm trying to take census tract linked data (in the form of a CSV I joined to a census tract level map of Washington State) and create a county-level map with it. My census data also has the county ...
1
vote
0answers
38 views

Most effective way to find spatial relationships in python

I am trying to find the spatial relationship between two polygon geoDFs as follows: Find geoDF1.geom within geoDF2.geom else (not within) Find geoDF1.geom with largest intersection fromgeoDF2.geom ...
2
votes
0answers
38 views

Spatial join by argument closest, but based on majority of vertices

I'm often working with different polyline datasets which represent street networks. One of the most common tasks I have is to join information from one layer to another. Often there are no mutual ...
0
votes
0answers
41 views

How to merge / join line segments by attribute and split at intersection

I have a complex network of line features with a lot of attributes (and unique IDs). Many features have the exact same values (exept the ID). I need to join all features with the same attribute which ...
1
vote
1answer
30 views

More creative or efficient solution for a proximity table (1:m) to all points within X distance, keeping obs. where no points fall within X distance?

I have a proximity question. I am open to Arc or Python solutions. I am mainly asking because I think I am lacking a little creativity in approaching the situation. The Situation I have two point ...
1
vote
0answers
49 views

Spatial Join of two Feature Classes with a condition using ArcMap

I have two Point Feature Classes: the first contains manholes incl. the invert elevation the second file contains road gullies and their invert elevation. Both files have roughly 10,000 to 20,000 ...
1
vote
1answer
60 views

PostgreSQL PostGIS: Spatial join but keep all features that don't intersect

Spatial joining a point table to a polygon table, creating a new output table. So far I can only get the output table to contain features that satisfy the spatial join. However, I want the output to ...
1
vote
0answers
19 views

QGIS 2.12 How can I assign the attributes of the polygons of the layer A containing the geometry of layer B?

In other words, I have two shapefiles: Layer A: not-intersected Areas (1 attribute: ID); Layer B: Buildings (Several attributes). I want to identified by the related ID attribute all the buildings ...
1
vote
1answer
55 views

PostgreSQL: Spatial join points to polygon, listing point attributes where multiple are joined

I have a large polygon table and a large point table in a postgis enabled PostgreSQL database. Each point has a unique reference number (double type). I want to spatial join the points to the polygons,...
2
votes
1answer
36 views

return only one value per point from ST_Value() - currently returning 2 values for some points

I'm testing a point sample query with a subset of 5 points on a single band elevation raster. Using my usual approach (which I've previously not noticed this behavior), I get six records returned: ...
1
vote
0answers
20 views

How to index spatial objects? [closed]

“R-tree is useful to store spatial objects such as restaurant locations”. I see this sentence a lot of time in internet but I haven't found the good explanation on this. Can anybody please elaborate ...
3
votes
1answer
106 views

How to test the geometry type from a list of layers and then join it with PyQGIS 3

Summarizing my problem, I'm a beginner and I'm developing a plugin that will be able to do several spatial joins. For this, it will have to separate the spatial from the non-spatial layers and do the ...
0
votes
0answers
26 views

Matrix union in ArcGIS

How can I do matrix processing in ArcGIS or ERDAS Imagine? l have two different raster images for change detection. Matrix join same code filed information. In this video link already done matrix in ...
1
vote
1answer
64 views

Open a MSSQL Spatial View in QGIS

I have created a view in MSSQL Server 2012 that does a spatial join as below: SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 100)) AS PID, DS.Dip_No, PB.SP_GEOMETRY FROM dbo.Dipsites AS DS INNER JOIN ...
0
votes
1answer
146 views

Joinn shapefile attribute ID to point in R

I have a CSV file (about 1,000,000 georeferenced points) which contains point_id/latitude/longitude. I also have a shapefile which represents a grid cell_id/xmin/xmax/ymin/ymax. I am trying to join ...
1
vote
1answer
60 views

How R-Trees, R*-Trees can be used to index the Road Network?

I am trying to understand the Tree Indexing method of the Road network. In R-Tree the Minimum Bounding Rectangle is used to store the data points, but how it can hold the line segments of the Map? Or ...
1
vote
0answers
43 views

Performing PostGIS spatial joins with remote host?

I have approximately 600,000 points that must be joined to ~12 million polygons. This process happens weekly, with the potential to happen daily. The polygon data never changes, and is stored in a ...
0
votes
1answer
75 views

Find the closest Point from a Point which contains the same attribute

I am trying to create python code to iterate through points on 1 layer and find the closest point on another layer (Road Chainages) based on attribute values. I need to limit the search to < 20m ...
2
votes
1answer
85 views

Joining 2 layers by location doesn't join desired fields from attributes tables

I have 2 layers that I'm trying to join by location: 1 is a point layer (CRS 4326) and the other is a shapefile layer (CRS 4326). The shapefile layer has a field in the attribute table whose values I ...
0
votes
1answer
130 views

Spatial (nearest neighbour) Join Between Points (GPS coordinates) and Line in R

I want to do spatial join to an OSM line data and GPS point data both in geographic coordinate system, the result which I want is a road layer(has a unique ID) with the attributes of of road and the ...
0
votes
1answer
112 views

Lines in Polygon Analysis

This question is similar to the "points in polygon" analysis, but I want to keep the attribute data for multiple lines within a single polygon. The data source is multiple line segments representing ...
1
vote
1answer
47 views

Joining single column in ArcGIS Desktop with Spatial Join

I'm trying to automate a rather annoying workflow in ArcGIS 10.4 with a Python script. My goal is to extract data from a polygon shapefile into another polygon shapefile which is arranged as a raster (...
1
vote
1answer
72 views

Using Statistics by category in QGIS?

I use the "statistics by category" tool from QGIS to learn what grain yields I got from different combinations of scenarios like: Soil A + Hybrid A + Planting Date A = Yield n Soil B + Hybrid A + ...
0
votes
1answer
23 views

Joining separate parcels based on group ID into one large group

What tool would I use to group many parcels into its own respective group. For example, if parcels A, B , C have group ID of 1 then I would like to have parcels A, B, and C combined into one larger ...
3
votes
1answer
656 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 ...
-1
votes
1answer
46 views

Sum attributes of feature that occurs multiple times within a layer

I am trying to add up the total contributing drainage area of multiple stormwater BMP's that are located on the same parcel for a layer that contains tens of thousands of parcels. I performed a one-to-...
1
vote
1answer
62 views

Join attributes by location - false information

I've been working on an analysis involving animal vehicle collisions. The data has been passed to r-stats and I keep noticing peculiar things in the cross referencing of the data. I've created highway ...