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
15 views

ArcMap crashes without any error while trying to export to dwg or doing spatial join? [closed]

Any time I try to export data to dwg or doing spatial join or etc.my ArcMap crashed and there is no error message, I uninstall it and repaired it, even try to change windows but it wont work I use ...
0
votes
0answers
24 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
21 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
70 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
48 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
29 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 ...
1
vote
0answers
21 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
36 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
25 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 ...
0
votes
0answers
35 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
50 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
28 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
30 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
18 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
56 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
18 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
50 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
66 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
42 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
42 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
50 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
56 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
80 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
73 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
46 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
48 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
22 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
212 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
37 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
56 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 ...
0
votes
2answers
61 views

How to join Shapefiles without common attributes using ArcMap

I have a Dissemination Areas boundaries shapefile with has an attribute table full of data needed for lowest quartile analysis and I have a neighborhood shapefile which has lowest income data which ...
0
votes
0answers
22 views

Finding number of points within each respective polygon in table [duplicate]

I have: a shapefile of circles at 15 meters radius and point data with GPS coordinates. How can I count the number of points within each circle and have a raw number that can show such? I've tried ...
1
vote
0answers
23 views

Spatial join of feature class on layer class with PyQGIS

I have three layers: One point layer consisting of residents One polygon layer with buffers of the first layer (one polygon for every point) Another point layer consisting of containers I use QGIS ...
3
votes
1answer
142 views

Spatial Join In PostGIS where centroid of a polygon is inside another polygon

I have two overlapping polygon layers as shown in figure below. One with small grid polygons and another with a large irregular polygon. I want to join them such that attributes of the large polygon ...
2
votes
3answers
96 views

Seeking PostGIS equivalent to GeoPandas union overlay?

What is the PostGIS / PostgreSQL equivalent of the GeoPandas Overlay Union operation? res_union = geopandas.overlay(df1, df2, how='union') Say I have two tables, 1 green, 1 red with each with two ...
3
votes
1answer
67 views

Spatial Join Ouput Attributes Differ Based on Input FC or SHP

I have a point dataset and a polyline dataset that I am running a spatial join on. I noticed that if I run the spatial join with the point FC, the ouput differs from if I run it with a point ...
2
votes
0answers
45 views

postgis and st_intersects ; fail to compare a table to itself with a left join

postgresql 9.6, postgis 2.3 Following this Select features that do NOT intersect in PostGIS, I would like to compare one table to itself, to keep all records from table p1, even and above all those ...
1
vote
0answers
84 views

Shapefile import failed in PostGIS

I am new to PostGIS/PostgreSQL and have downloaded and installed to perform a spatial join which ideally takes 27 hours in ArcGIS Pro and 19 hours by ArcPy.Hoping for a faster results via PostGIS from ...
4
votes
1answer
42 views

Extract value from vector to another

I have two vector (shapefile) data. One contains soil order for county, and the other one contains boundary for each county. I want to extract the soil order for each county by using county boundary. ...
0
votes
0answers
27 views

Using point geometry object in Spatial Join with ArcPy?

I'm trying to do something that is conceptually very straightforward. I'm pulling a center point from a raster (geotiff, etc) and then doing a CONTAINS operation with that point against a UTM zone ...
0
votes
1answer
35 views

Use two lists as input to Spatial Join in ArcPy? [closed]

I am trying to determine a method for conducting a spatial join on features from two separate feature datasets based on the first three letters of each input feature (A01_road == A01_gps). import ...
0
votes
1answer
40 views

Spatial Joining One to Many?

I am trying to create groups based on a primary object as its centroid. Groups are defined as all objects within a certain distance from a primary object. I am currently using spatial join in a ...
1
vote
0answers
41 views

QGIS problem using join by location algorithm

I am new to QGIS. I have a problem when i use the algorithm "Join by location" in my graphical modeler, it returns me the "uknown error". I think the problem is that the shape i´m using to join is ...
1
vote
0answers
15 views

Iterating over set of feature classes and spatial join to create only one output? [closed]

I have a feature dataset with 50-some odd feature classes (polygon) that all have fields that I need to spatially join to one feature class (point). So in the end, I only want one object with all of ...
1
vote
1answer
24 views

Finding many intersecting polygons of one layer and listing them in single field using ArcGIS Desktop?

I have a polygon layer of a grid of USGS Quads Index clipped to the Southwestern US (https://catalog.data.gov/dataset/united-states-7-5-usgs-quad-index). I also have a polygon layer of county ...
0
votes
1answer
97 views

Connect points from two SpatialPointsDataFrames in R, considering the closest distance

I have two SpatialPointsDataFrames. In SpatialPointsDataFrame one (dat1) I have three points (A, B and C). In SpatialPointsDataFrame two (dat2), I have eight points with temperature measurements. I ...
1
vote
1answer
89 views

Spatial join in R - Adding points to polygons with multiple corresponding points

I have carried out a spatial join in R in order to join a points shapefile to the corresponding polygon in a polygon shapefile using over() from the sp package and spCbind(). join <- over(polygons,...
0
votes
1answer
82 views

Taking 2 overlapping spatial polygon layers and creating 1 with features from one replacing those of other layer?

I have two sf multipolygon layers - one is a 5km buffer along the Mexico-US border and the other is an administrative 2-level layer of Mexico. I am trying to figure out how to layer these on top of ...
0
votes
2answers
52 views

Joining features across boundary lines of target feature in spatial join?

I have a file geodatabase named ElectionData2012.gdb containing two feature classes: Counties: The feature data for California counties PrecinctVotingData: Feature data for California precincts for ...