To join the attributes from one spatial data layer to another

learn more… | top users | synonyms

1
vote
0answers
12 views

Dissolve and join features based on an attribute range

Note: I have edited the post to suggest a possible solution. I have a CSV file of Postal Codes containing average energy usage information. Furthermore, I have Feature Classes (both points and ...
0
votes
1answer
21 views

Assigning irregular points to a grid and assigning grid number as attribute

I have a large point data set that has irregular geometry (random sampling) that I want to bin in 2D XY space. I've attached a sketch below to illustrate what I mean. Apologies for hand drawing, hope ...
0
votes
2answers
221 views

Performing spatial join in Spatialite (QspatiaLite for QGIS)

I'm trying to spatially join and summarize the attributes of a set of buildings to a set of containing parcels. There are (potentially) many buildings to each one parcel. Here is the query as I'm ...
0
votes
0answers
28 views

Join attributes by location - QGIS

I am trying to perform an attributes join by location between a shapefile (with points) and a second shapefile (with polygons). The points are hydrometric gauges, whereas the polygons are catchments. ...
6
votes
3answers
271 views

How to do a spatial join in PostGIS that returns on the minimum value of point intersecting polygon?

I have a polygon table (buffer) and a point table (dem_points), and I want to do a spatial join on them. I need to join the point with the minimum elevation (dn) to its spatially corresponding ...
3
votes
1answer
52 views

Spatial Join with aspatial conditions

I'm using ArcGIS 10.3 for Desktop. I have two point datasets: The first point file contains bus delay events (e.g., due to traffic, signal delay, passenger on/offs etc.) along a number of routes ...
1
vote
1answer
291 views

Join traffic data (point) to a road network (line) - Section between two roads - ArcGIS

I am trying to analyze the vehicle traffic in Melbourne's (AUS) road network. I have two files: the traffic data (point data for a given latitude and longitude with the average hourly traffic between ...
3
votes
2answers
72 views

Joining polygons to polylines based off specific point in polyline being within polygon

I am trying to join a polyline feature class and a polygon feature class. The polylines will always have at least their first point in a polygon, and each polyline consists of exactly three points. ...
0
votes
0answers
18 views

Comparing multiple point datasets to polygon dataset?

I have multiple point datasets indicating presence absence and i want to compare them all to a polygon dataset to calculate cumulative score for the polygon i.e. presence of points in 2 point datasets ...
7
votes
4answers
4k views

More Efficient Spatial join in Python without QGIS, ArcGIS, PostGIS, etc

I'm attempting to do a spatial join much like the example here: Is there a python option to "join attributes by location"?. However, that approach seems really inefficient / slow. Even ...
0
votes
0answers
21 views

Excluding numeric data that are null (0) when conducting spatial join for mean value?

I am working on household income data as point shapefile. And for some reason, I have to modify points to polygons (I already got polygon shapefile) Now, I am trying to conduct spatial join to get ...
1
vote
1answer
32 views

Joining/Merging Shapefiles?

I have a shapefile of a water main and I want to find specifics about it by adding other shapefiles to it. For example I have a shapefile of the roads and of waterways; I want to identify where both ...
-1
votes
0answers
24 views

Trying to join a column from one table to another using python [duplicate]

So I have two tables, one has county polygons, the other has well Points. I am trying to first calculate the total numbers of wells that fall into that county, and update the county table with the ...
2
votes
1answer
36 views

Conflating two road networks

I have two line feature classes representing the same roads. Their geometries are only crudely similar, while their attributes are totally different. I am trying to add the attributes of one feature ...
1
vote
1answer
26 views

Writing point feature classes fields to polygon feature classes field in ArcGIS?

I have one database and two feature classes. One of feature class is polygon other is point featured. I want to write points names to polygon attribute table with commas which are intersects. my ...
-2
votes
0answers
51 views

Spatial join Python script in ArcGIS 10.2.2 [closed]

I tried to set up a loop python script for closest spatial join. However, I failed with empty fields (they have data in original shapefile) after the spatial join geoprocessing without looping. I ...
1
vote
1answer
43 views

Split multiple attributes from a big polygon to smaller ones

I am looking for a sort of spatial (un)join function. Let's say I have 2 tables, both with a large number of polygons. The first one has a pop/polygon column in his attribute table. The 2nd one has ...
1
vote
1answer
52 views

How to calculate the area of polygon features within another polygon feature layer

As shown below, I would like to calculate the percentage of each red feature (landscape zones) taken up by a green feature (forest zone). So I need the summed percentage of forest zone for each ...
0
votes
1answer
27 views

Attempting to “merge” 3 polygon layers together, not sure if merge is correct

I have three separate polygon layers. Some of the sections in the different layers overlap. I want to "merge" all three layers together and create one layer that is representative of the entire area ...
0
votes
1answer
334 views

Spatial Join of Polygons to Polygon Grid with Shared Boundaries in ArcGIS Desktop?

I have polygons containing an attribute to be summed by a polygon grid. the polygons with the attribute always share borders with each grid cell and never extend outside any grid cell (the grid has ...
1
vote
3answers
40 views

arcpy field mapping for a spatial join: keep only specific columns

I want to perform a spatial join to find the join point (a node in the code below) that is closest to a target point (a consumer in the code below). In the result, I only need certain attributes from ...
4
votes
1answer
102 views

Join / merge lines that touch and intersect in QGIS

I have a large dataset consisting of lines/polylines where I would like to join/merge the lines that touch / intersect. Each line has an individual ID and there are no common attributes I can use for ...
1
vote
0answers
20 views

spatial join on selected features?

I am working with a set of housing data and I am trying to combine a set of apartments into a single point. I was wondering if it would be possible to select only the apartments I want to join and ...
0
votes
0answers
30 views

Spatial Join returning Null values

I've seen a few posts about this but unfortunately none of the fixes have worked so far. I'm trying to do a spatial join between a grid (polygon) and set of points in the UK. I'm interested in 1 ...
0
votes
0answers
34 views

Spatial join with concatenation of results

I've two polygon layers which I would make a spatial join. The objective is to transport a specific code from layer A (Municipality) to layer B (Issues) using like a concatenate function, in this way ...
2
votes
0answers
43 views

problem using qgis spatial join in a python script or modeler : no results [closed]

I'm trying to create polygons from points layers. Each layer contains one point to avoid troubles due to superposition of polygons. I detailed the context here : How can I add output vector to a list ...
1
vote
1answer
71 views

ArcGIS - how to join attributes of overlapping polygons

Given two tables each with unique attribute sets, how do I merge the attributes of one layer onto the other, or create a new layer containing the attributes from both? The image shows my two layers: ...
0
votes
1answer
75 views

Spatial Joining in QGIS?

I'm new to QGIS and I'd like to know if exist in QGIS the equivalent command for "spatial join" of ArcGIS. I have tried with "join attributes by location" but seems to be impossible setting the match ...
1
vote
0answers
39 views

spatial join field mapping Arcpy, change merge rule

I have a line feature class which represents a stream network. At a confluence of two river segments, I'm joining the stream segments to the point of intersection via spatial join (one to one join). I ...
2
votes
2answers
507 views

How to do a one-to-many Spatial Join/Query in QGIS

Does anyone know if it's possible to do a 'one to many' spatial join based on distance in QGIS? The "Join Attributes By Location" under ->Vector->Data Management Tools is very limited... Just to be ...
1
vote
1answer
43 views

Arcpy Spatial Join Fails: Field is Not Nullable

We are working to perform a spatial join of a very large point .shp of voters (target_features) with another of incidents (join_features). arcpy.SpatialJoin_analysis(target_features, join_features, ...
0
votes
1answer
32 views

Consolidating many-to-one overlapping polygon feature values into another polygon attribute using ArcGIS for Desktop?

I have a situation similar to the one here: Spatial join - many to one however the desired end product is a dissolved/aggregated feature that collects up all the values it was joined to. For example ...
1
vote
0answers
27 views

Joining polygons to points when the points fall in the intersection of polygons. QGIS

I am using QGIS. I am hoping to join a set of geocoded points to polygons in such a way that the new snapefile will be points that have a new field which lists the attributes of the polygon it lies in ...
2
votes
2answers
35 views

Performing spatial join on existing feature class?

I have feature classes containing points (Events) and polygons (Sectors). I want to add a new field to the Events FC to store a field from the Sectors FC. The Events FC would be the Target Features ...
0
votes
0answers
33 views

How to do a Python / Fiona / Shapely equivalen to an ESRI ArcPy SpatialJoin?

I'm a GIS noob, but I am trying to learn as quickly as I can. Please bear with me. How can I identify what structures from one layer are WITHIN in some body of water in another layer? My problem ...
1
vote
0answers
23 views

Moving one polygon layers data to another polygon layer based on distance

I'm trying to set variable shape polygons to a hexagon grid. I want to do something like a spatial join, but without merging data as in "One_to_one", and only having one polygon fill one hexagon ...
0
votes
1answer
55 views

How to do a Spatial Join after opening a GDB file with Fiona?

After I successfully open up an ESRI GDB file/folder with Fiona, what open-source Python package should I use to do a spatial join? I was told Shapely is not the appropriate package for this. I am ...
0
votes
1answer
37 views

Assign similar ID to points inside a polygon

I have 3 input datasets of points. What I'm trying to do is to assign a common ID code to the points that are close to each other (no specific distance). I'm using a ModelBuilder to achieve this : ...
1
vote
0answers
40 views

Spatial AND temporal join between two point data sets

I was hoping I could get some pointers in how to approach this issue, which is tricky version of a spatial join. I have been searching and I can't find a particular solution to what I need. I have ...
2
votes
0answers
49 views

Update Join Attributes by Location

I have a shapefile with points, and a shapefile with polygons. I want to sum the attribute value of all points that are contained in a polygon, and I'd like to do this for each polygon in my dataset. ...
1
vote
1answer
72 views

Postgis spatial join performance (point on area)

I need to update a single attribute of a large table of point data with a result of a spatial join (point on area operation) on a polygon table. I'm using the below query but wondering if this is the ...
2
votes
1answer
84 views

Sum line lengths for each grid cell in QGIS

I'm trying to get data from a polyline layer into a grid (I've created this with regular points, points to polylines). I guess at first I have to cut all polyline segments at the grid lines and then I ...
1
vote
1answer
27 views

CRS and Spatial join problem

I try to match two layers. First one is point-type with cities in Europe. Second one is grid layer (polygon) with elevation value. What I want to achieve is to to join the "Z" value from grid layer to ...
1
vote
1answer
84 views

Missing distance field after Spatial Join? [closed]

When I use Spatial Join, the distance attribute is not being added to the resulting shapefile. I'm trying to use Spatial Join to assign each of 16,151 points to one of three zones (see screenshot), ...
1
vote
2answers
54 views

Joining points to points on the same road

I know there may be a really simple solution to this query but I have been looking for one for ages and have not been successful. I have points that represent mammal sightings on roads, as well as ...
0
votes
0answers
298 views

Spatial Join with ArcGIS ModelBuilder?

I have a bigger model done with ModelBuilder. In the end I want to make a spatial join of a polygon (target) with points (join) (see figure below). The model runs with any error or warning message, ...
0
votes
1answer
39 views

How can I fix my spatial join issue?

I am using ArcGIS. I have two different files. The first file is from the United State Census. It is a file consisting of the census tracts for 1990. Each polygon has information that labels its ...
1
vote
1answer
52 views

How to spatially join several attributes of one layer to a unique one on a second layer

My goal is to link all the attributes of an input layer (that has a UTM CRS projection matrix and point coordinates but no geometries) to the geometries of another layer based on the spatial analysis. ...
2
votes
1answer
64 views

Update column/Join in QGIS similar Mapinfo

Looking somewhat similar to UPDATE COLUM option ( for join) MapInfo in QGIS. This exists ?
1
vote
1answer
30 views

Performing join on simultaneous spatial and attribute criteria in ArcGIS for Desktop in Modelbuilder?

A similar question was posted here, but I have an additional problem that seems to make the answers there unlikely to work. I am interested in performing a spatial join between point feature class A (...