To join the attributes from one spatial data layer to another

learn more… | top users | synonyms

1
vote
0answers
13 views

Spatial Join - Field mapping to delete and rename fields

I have a python script where the user can enter a study area (Polygon shapefile) and multiple point Features of interest (Point shapefiles). The point shapefiles are looped through and joined with ...
1
vote
1answer
14 views

Spatial join for multiple shapefiles (loop)

I have the following two datasets: - polygon shapefile containing administrative boundaries of a City - multiple point shapefiles What I want to do is to spatially join the point shapefiles with ...
1
vote
0answers
13 views

geopandas spatial join: how to find problematic row?

I have an sjoin function from geopandas that is behaving erratically: it works on some version of the "points" geodataframe but not others. merged=sjoin(points,polygons, how='left',op='within') ...
1
vote
1answer
33 views

QGIS: getting NULL values when using “Join Attributes by Location” of lines and polygons

I'm using QGIS 2.12.3-Lyon. I have a polygon layer (~130k square polygons with some small overlaps) and I have imported a road network from OpenStreetMap (via Geofabrik, ~141k road segments) for my ...
2
votes
0answers
21 views

Spatial Join Hangs on Two Specific Shapefiles in QGIS 2.8

I have successfully done spatial joins with QGIS many times. However, with two shapefiles QGIS hangs or never seems to complete. (I’ve let the process run for over two hours.) I’ve tried all the ...
1
vote
0answers
27 views

Join Attributes By Location inside QGIS modeler still fails to compute sums

Recently, a question was asked about the spatial join tool, and its failure to calculate the desired data. I ran into the same problem, but none of the solutions that were offered there solved it. ...
1
vote
1answer
49 views

ArcGIS - Why would spatial join return correct distances but wrong attributes

I am doing spatial joins on points and street (line) features to identify the closest street to each point. However, despite getting appropriate distances returned for each points, closest road, the ...
3
votes
1answer
34 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
0answers
27 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 ...
7
votes
1answer
123 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 ...
4
votes
2answers
84 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 ...
2
votes
0answers
24 views

Intersect, Spatial Join?: One Line crossing Multiple Polygons, assigned wrong attribute

I am looking for any possible solutions to a problem I am encountering with ArcGIS. I am using census block groups (CBG) to assign streets an income level value based on their location within the ...
2
votes
1answer
70 views

geopandas spatial join extremely slow

I am using the code below to find a country (and sometimes state) for millions of GPS points. The code currently takes about one second per point, which is incredibly slow. The shapefile is 6 MB. I ...
2
votes
1answer
40 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 ...
1
vote
1answer
21 views

appending country names to route feature class

I have a polyline feature class made up of multiple segments. This feature class overlays a polygon feature class representing the countries through which this polyline is going. For each segment, I ...
2
votes
1answer
56 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 ...
0
votes
1answer
18 views

Linking datasets for two polygon layers in ArcMap?

I have two polygon shp files that do not have a common ID. I'm trying to link the datasets with a common ID based on spatial location. Is there a tool/process to link features (common ID in the ...
0
votes
1answer
107 views

Fastest way to join many points to many polygons in python

I need to attribute a geographical area (based on shapefile polygons) to 8 million GPS points. There are 405 polygons. I currently have the code below, and a quick extrapolation tells me it will take ...
2
votes
1answer
51 views

How to do spatial join in FME by preferring points with same attribute

First of all, I'm new to FME, but I'll try to be specific with my question. I have two different shapefiles with point features. These points have information on bridges and overpasses etc. but are ...
5
votes
2answers
68 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 ...
1
vote
0answers
35 views

Has “add polygon attributes to points” been removed from QGIS?

I've been using "add polygon attributes to points" in qgis for a while, but hadn't needed it for a while (thanks to Underdark for this); in 2.13.0 master on ubuntu it seems to be missing from the ...
5
votes
1answer
55 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 ...
1
vote
1answer
65 views

ArcGIS Spatial Join - “contains part of” match option

I would like to perform a spatial join using a (non-existent) "contains part of" match option. i.e. I want the join to include any and all polygons that overlap, not just touch at the edge. None of ...
0
votes
0answers
15 views

How to join CSV data (based on admin boundary names) to shapefile of aforementioned boundaries in R? [duplicate]

DATA: CSV data, Shapefile Hi all! I'm looking to perform what I've been taught is called a spatial join. After researching this further, it's looking like this operation is most often called a ...
1
vote
0answers
20 views

Spatial Join with start and endpoints of polylines

My question is concerning spatial joins. Basically, I want to join 2 layers. One of them is are polylines and has two pairs of lat/long, representing the start and the end. id lat_start ...
6
votes
2answers
178 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 ...
0
votes
1answer
19 views

Divide broken line layer in seperate clusters based on location

Building on a earlier asked question on this forum I would like to ask an additional question in getting the task done I asked here: Divide polyline layer in clusters with specific requirements in ...
0
votes
1answer
49 views

Calculating Geometry (area) in a spatial join attribute table

In ArcMap, will Calculate Geometry (area) be accurate for records that have other polygons attached via Spatial Join? It doesn't seem to be adding the extra polygons that are spatially joined. ArcGIS ...
1
vote
1answer
112 views

Count number of points within multipolygon shapefile using OGR

I have two shapefiles: 1) consists of points (hundreds of entries) and 2) multi polygons (tens of thousands of entries). I simply need to count the total number of points contained within the ...
0
votes
1answer
56 views

Missing distance field after Spatial Join? [closed]

I heard that spatial join creates a new distance field when you do a spatial join. However, every time I tried doing a spatial join it only creates a county layer? What might be the reason that it ...
1
vote
0answers
57 views

Attributing polygon features with names of polylines they contain using ArcGIS for Desktop? [closed]

I have a few thousand polylines that represent streams and each of the streams has a corresponding watershed polygon. Streams have "Stream Name" attribute. I needed to attribute polygons (watersheds) ...
1
vote
1answer
43 views

Join new data to selected features in a table using Arcgis

I have a point feature class, A, and I have joined data from another point feature class, B, to its attribute table based on spatial location. I selected the second option in the Join Data window ...
1
vote
0answers
24 views

I want to spatial join two tables with the same polygons, so I only want to extract where the polygons does not merge with the other [closed]

I want to spatial join two tables with the same polygons, so I only want to extract where the polygons does not merge with the other. SELECT e.SGid as 'table_name2' From [table] inner ...
2
votes
1answer
70 views

Spatial Join Field Mapping in ArcPy?

I know there already are posts about this subject, I tried to derive a solution for my own problem but the code for field mapping is very complex to me. I have a Raster 100x100m and point layers that ...
1
vote
1answer
54 views

How to map a point to a polygon label from a shapefile

I have a shapefile that breaks the city of San Francisco up into a number of different districts depending on who your supervisor is. I need to make a lookup tool that takes a single long lat value ...
0
votes
1answer
116 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 ...
2
votes
1answer
85 views

QGIS:joinattributesbylocation gives empty shapefiles and QGIS:joinbylocation does not give summary of all fields

I am trying to make a spatial join to calculate the mean value of many variables (100+ columns) of census tracts by city. In order to do that, I would, in QGIS Desktop, run a spatial join (join ...
2
votes
2answers
188 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
39 views

Categorize feature with spatial join

I am working with Arcgis 10.3 and currently this problem keeps me awake at night. I import a csv file into ARCGIS with XY-coordinates and the Age of a person. I create a feature class which i later ...
2
votes
1answer
32 views

Spatial Join - Grid Containing Points, Display Highest Value Only

Sorry if this has been answered--I couldn't find anything specific to my question, however. I have a polygon grid layer and a point layer which contains numerical values (1-4) I want to use a ...
0
votes
1answer
32 views

Retaining UNIQUE attribute fields after dissolving a shapefile

I tried the solution to "Dissolving shapefiles but retain attribute fields" but my original shapefile (3000 rows in attribute table) has many duplicate values in the field that I want to retain so ...
0
votes
0answers
35 views

How to make a polygon and point shape file line up to do a spatial join?

I have a polygon with a North_America_Lambert_Conformal_Conic coordinate system and a point shape file which had a WGS 1984(DD) coordinate system. I defined projection and projected both of them to ...
4
votes
1answer
94 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 ...
0
votes
0answers
116 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, ...
2
votes
0answers
43 views

split points evenly to neighboring polygons?

I have a crime location data set, containing geocoded crime location points that have been geocoded to streets and street interactions. I also have a census tract shpfile. What I would like to do is ...
0
votes
0answers
40 views

Polygons Present in another Polygon (Selection/Attribute Transfer)

I have 2 layers, Sugar Data and Surveyed Parcels. My interest is to include 2 new fields in the sugar data (lot & plan) which is present in the surveyed parcels data. Im using Arc Map 10, can ...
4
votes
1answer
272 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 ...
0
votes
0answers
38 views

Using the 'Mean' mergeRule with a spatial join

I have two feature classes. The first is a point file, derived from a raster, with the values for slope of the terrain. The second is a shapefile of polygons. What I want to do is spatially join the ...
0
votes
3answers
100 views

Spatially Joining census tracts to neighborhood shapefile?

I have a bunch of census tracts that I want to spatially join with larger neighborhood geographies so that the numeric fields of the census tracts are summed on the join. A spatial join based on ...
0
votes
0answers
62 views

Understanding “Creating Layer From Selected Features.”

I used the “Create Layers From Selected Features” a lot as working with sunsets of a database is typically more efficient in ArcGIS (v. 10.3). Recently I had a project when I was trying to determine ...