To join the attributes from one spatial data layer to another

learn more… | top users | synonyms

11
votes
2answers
575 views

How to perform repetitive tasks in QGIS?

I am trying to do a treatment on many feature files, so I would like to automate it. In fact, I have one shapefile with the spatial distribution of some species, and one with vegetation type. I ...
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 ...
7
votes
1answer
151 views

Join by attribute / spatialite with SQL / left outer join in QGIS

I have a layer with polygons (let's call it "woods") that is intersected by "n" line-objects ("roads"). Every road has an unique attribute roadid. I need to add ALL the roadid's (not only the first ...
7
votes
1answer
1k views

Is there a python option to “join attributes by location”?

I am trying to perform the function join attributes by location as found on the QGIS menu Vector>Data Management Tools. I am seeking an open source python option for this. I know arcpy has a spatial ...
6
votes
2answers
222 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 ...
6
votes
2answers
133 views

Spatial Join Yielding NULL values in ArcPy?

I'm writing an automated script to do some data processing of address points. One stage of the process is to retrieve 19 fields of information from various polygon layers that the Address Points are ...
6
votes
2answers
1k views

How to select the nearest lines to a point layer?

I am a beginner with GIS software and I'm working on QGIS. I have a problem joining the spatial layers. I have a layer with objects in one city and another layer with the streets. I need to attach ...
6
votes
2answers
317 views

Join multiple spatial tables by distance

I'm trying to join two tables, one which contains road names and the other just a point. After exhausting research I'm now stuck. The idea is to join up the two tables using only distance, ie, select ...
5
votes
2answers
76 views

Is it possible to merge attributes from lines which are on top of each other?

I was able to merge the different kinds of roads (verharding lijn) with the normal roadmap (Wegen 1.0). The attributes were copied to all the records, but there are empty attributes where the kind of ...
5
votes
1answer
56 views

Merging two polylines (street networks)

I have the following problem: I have two street datasets from completely different sources. I need some attributes from one dataset (red lines) to be joined into the other one (green lines). Until ...
5
votes
1answer
991 views

How can you join attributes from polygons to points which are within the polygon feature using PostgreSQL and PostGIS? [duplicate]

Possible Duplicate: How to perform a spatial join of point and polygon layers in PostGIS? I don't know how to solve my actual problem. I have polygons and points (some points are located ...
5
votes
1answer
2k views

Split polylines at polygon boundaries in QGIS

I have a set of contour lines and a polygon set containing glaciers. Because I want the glaciers to have blue contours, I need to split the contour lines at the glacier boundaries. I can achieve this ...
5
votes
2answers
115 views

How to select random adjacent census tract

I have set of census tracts spaced out across a city and I would like to randomly choose an adjacent census tract to explore nearby demographic data. I'm not sure if there is an easy process for ...
5
votes
0answers
678 views

Spatial join to kernel density / kernel density with polygon/point output in Arc [duplicate]

I'm looking for a way to join polygons to a density function for some other feature of interest. Current workflow make density raster from feature set of interest, using point/line/kernel density ...
4
votes
2answers
152 views

One-to-many joins on a feature class to a table

I am using ArcMap 10.2.2 with an Advanced license. I have used ArcMap for other basic analyses, but am fairly new to the program and have only basic coding skills, with no SQL experience outside of ...
4
votes
2answers
657 views

ArcGIS Spatial Join Options Missing

The ArcGIS SpatialJoin online help page has a long list of match_options when joining data spatially, including HAVE_THEIR_CENTER_IN. However running the arcpy.SpatialJoin_analysis tool in Python ...
4
votes
1answer
1k views

ArcMap 10.1 SP Spatial Join Problem (lines within polygon)

I have a line layer (faults) and a polygon layer (fishnet grid). The fishnet has a risk of earthquake attributed to each polygon. I want to take that risk value and give it to the fault lines which ...
4
votes
2answers
1k views

Performing spatial join between lines that travel along each other in ArcGIS Desktop?

I have 2 layers, one representing streets, and one representing pipes. The pipe layer has a street field that I want it to be automatically filled (I want the pipe to show the street that it's on) I ...
4
votes
1answer
120 views

Conditional Spatial Join?

I need to join two layers (a fishnet grid and land cover). I'd like the join to occur only if the the land cover occupies 50% or more of each fishnet grid (See image below). Can anybody provide an ...
4
votes
1answer
557 views

how to create a network from gps tracks?

I'm trying to build a network from several GPS-trakcs, to digitalize hiking routes on my land. I have several GPX-files from routes I've tracked with the gps. I managed to display them in Arcmap ...
4
votes
1answer
2k views

ArcMap 10.1 Spatial Join: 'Contains' and 'Within' question

I have two polygon datasets: electoral districts and postal code areas. I'm performing a spatial join to see which postal code areas are completely within a district (the area can touch the borders, ...
4
votes
1answer
948 views

Join attributes by location

I am trying to join multiple records that occupy the same location (polygon centroid) and have tried using the join by location plug-in but have found this does not work for me in this case as I have ...
4
votes
0answers
144 views

How to use the multiprocessing module on python to execute a spatial join? [closed]

I have several shapefiles of the entire Amazon rainforest each with millions of polygons (they are fairly detailed and take some time to draw on ArcMap). I need each of these shapefiles to be ...
4
votes
1answer
414 views

Spatial join of polygon to point not transferring attributes in ArcGIS for Desktop?

What I have: 1 point layer with adresses. 1 polygon layer with zones. What I want: 1 point layer with the polygon info added. I just did the spatial join, the columns are added but there's ...
3
votes
3answers
2k views

Spatial join including attributes - like SQL right join?

I've run in to a little problem. I have two sets of polygons with important attributes. I need to join over the attributes from the first set to the other, but I can't seem to figure out how. ...
3
votes
3answers
279 views

Spatial join with HUGE datasets

How to make a spatial join with ArcGIS with these HUGE datasets? Target: almost 3 million squares 500x500m size (the attribute table is basically empty) Join feature: 12000 polylines Operation: one ...
3
votes
3answers
965 views

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

I have two point layers and want to perform a spatial join on nearest distance. Normally it is easy with ArcMap. But now I have a restricting condition on the spatial join. The restriction only ...
3
votes
1answer
40 views

Spatial join of raster data in QGIS

How do I perform spatial join of raster data in QGIS? I have raster soil data (tiff), I'd like to join this to an attribute table in excel? I'm not able to view the attribute table either? Is this ...
3
votes
1answer
712 views

Dissolve Polygons using R / join specific polygons

I have data in shapefile format :: UK_boundaries I am new to R and Spatial data as well, I am trying to join some areas to be as one area no line(s) between them. Based on my search I understand ...
3
votes
1answer
228 views

PostGIS multiple conditional statement on spatial join

I want to make a multiple conditioned spatial query in PostGIS 2.0/PostgreSQL 9.3., OS Windows 7. There are 2 tables, cadastre (Polygon) and roads (Linestring). Query: Select the sum (one number) of ...
3
votes
3answers
246 views

Spatial join without operation on the variable of interest

I have a simple problem: I've got to spatially join records of an epidemic in forests to some plot coordinates I have gathered. Problem is, I cannot obtain the records for each year on each plot, I ...
3
votes
1answer
290 views

How to implement 1:n joins with string attribute concatenation?

I have a question concerning pyQGIS. I'm a QGIS long-time (self-learned) user, but just a pyQGIS newbie. I want to implement 1:n spatial join with attribute concatenation in the table. I have a vector ...
3
votes
1answer
3k views

Spatial Join problems in ArcGIS 10.1 - intersect polygon and lines

I have hurricane tracks (Lines) and Florida county boundary (polygon) and I want to extract only those hurricane tracks that intersect Florida. In ArcMap 10.0 I used Spatial Join (from ...
3
votes
2answers
1k views

Scripting spatial join in arcpy - how to set field attribute in field mapping object?

I'm scripting a spatial join in ArcGIS with Python. I only want the resultant feature class to have a single field containing one attribute from the join features. In general, many join features ...
3
votes
2answers
128 views

QGIS calculates main soil type of polygons from another polygon layer

I've been working with qgis for a while but somehow I never fiured this out, so I thought it's time to ask. I have 2 shapefiles. a polygon layer from nearby fields (SHAPE1 (the red outlines)) a ...
3
votes
1answer
57 views

How many A features that fall both in the B polygons and C polygons are for each C polygon?

I have this apparently complex problem for solving in ArcGIS: Practically, I need to get the number of all yellow polygons that fall within both the green polygons and the red polygons. I need this ...
3
votes
0answers
68 views

How to join specific attributes of two polyline shape files that overlapped but information is stored differently (QGIS)?

I have just started using QGIS (2.12.3) and I need your help. Overall, I have two polyline shape files with the same geometry (the one layer overlaps the other), but the information is stored in a ...
3
votes
0answers
29 views

zonal statistics / join with two vector layers [duplicate]

I have a shapefile containing three polygons of river basins with different values. I want to know the average values per country. The country thus contains three river basins. When I use join in ...
3
votes
2answers
70 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. ...
3
votes
1answer
3k views

Raster Version of Spatial Join (one to many) [duplicate]

I have two raster layers that are identical in shape (they overlap exactly) and I need to perform the raster equivalent of a Spatial Join (one to many). My files need to stay in raster format ...
2
votes
3answers
2k views

Spatial join versus classical join

What are the main differences between a spatial join and a classical database join such as an equi (inner) join?
2
votes
2answers
171 views

Get max value from multiple points surrounding buildings

I have a series of building represented as polygons. Surrounding these buildings I have multiple points with heights associated with them. What I am trying to do is identify all the points that are ...
2
votes
1answer
65 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 ...
2
votes
1answer
64 views

geopandas error “minimums more than maximums”

I posted this question on stackoverflow here, but it seems that gis.stackexchange is the more appropriate platform. I am trying to merge two geodataframes in geopandas (want to see which polygon each ...
2
votes
1answer
83 views

Spatial join for not perfectly overlapping polygons?

I have 2 maps with the district borders of a country and I want to combine their features based on their location on the map but the borders of the districts don't overlap perfectly. I tried to use ...
2
votes
2answers
341 views

Sum of attributes in Spatial join when polygons cross boundaries in ArcMap?

I use ArcMap, where I have two layers: Buildings as polygons. Each polygon has a number of people living in it as an attribute. Polygons dividing the city into "districts". I drew these "districts" ...
2
votes
1answer
127 views

How to join a dataframe with a dbf via a common column in R?

I have a SpatialPointsDataFrame with the data of a city and i want to join it with a dbf that contains the population via a common column that they have. How do i do that so the first one has the ...
2
votes
2answers
331 views

QGIS equivalent for ArcMap join for purpose of distances from points to polygon?

It is relatively easy to calculate distances from points to a polygon in ArcMap by doing a join and selecting the option for creating a field containing the minimum distance information. i.e. it ...
2
votes
1answer
273 views

Collapsing the multi-row output of a one-to-many spatial join to single-row (arcmap 10.1)

I'm working with TIGER data, looking at the relationships among incorporated places and counties. Not all places are completely contained by counties; some do span multiple counties. In the final ...
2
votes
1answer
342 views

Why might Spatial Join appear to produce incorrect values?

I'm trying to do a spatial join of a point file (created from a raster) to a polygon (target), where I am joining the GRID_CODE value from the point to the polygon. I've tried a variety of ...