To join the attributes from one spatial data layer to another

learn more… | top users | synonyms

0
votes
0answers
26 views

Remote SQL Server, Crystal Reports and Geospatial Join

I have: A remote SQL server (2008 R2) that I have access to (But NOT full control of) which contains my source data including OSGB 1936 Geometry [ESPG: 27700] In house SQL Server 2008 R2 A Crystal ...
1
vote
1answer
22 views

PostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+

I need to obtain on each element on one table the closest point of another table. The first table contains traffic signs and the second one the Entrance Halls of the town. The thing is that I can't ...
1
vote
1answer
54 views

Spatial join of a single point to multiple polygons

I have a point layer which I want to spatially join to a polygon layer (bring in the attributes). This works fine unless there are overlapping polygons, if so the QGIS spatial join tool will only ...
2
votes
0answers
46 views

QGIS spatial join - join all features, not just one

I'm trying to do a spatial join of a feature on a polygon layer (p1) that intersects with two features of another polygon layer (p2)) via QGIS. What I want: get the attributes of both features of p2 ...
0
votes
0answers
42 views

Joining two features (points) with same position but different attribute using ArcGIS for Desktop?

As shown in the figure below, these two points are in the same position but with different attributes. (TextString). I am wanting to join these two points together but with different attribute in ...
3
votes
2answers
38 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. ...
2
votes
2answers
56 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 ...
3
votes
3answers
93 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 ...
2
votes
1answer
55 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 ...
1
vote
1answer
54 views

Directional Spatial Join with Python - Arcpy

Using Python, I want to join one point feature (centroid node) to the closest 4 links (polylines), but spreading the search in the 4 directions around my point, so that I have: 1 centroid-link ...
0
votes
1answer
42 views

Add Points shp attributes to Polygon shp by Point location (as Spatial Join in ArcGIS)

I have a set of points in .shp (ESRI, available here: http://ulozto.cz/xGqRVFrR/voronoi-zip). I would like to calculate Voronoi tesselation from the points, thus create polygons. So far, so good. ...
2
votes
1answer
27 views

Alphabetical Sort within a Record

I am performing a union on a polygon feature class with multiple overlapping polygons. Each of the records in the resulting feature class can be thought of as "unique area" polygons made up of the ...
1
vote
0answers
46 views

Polygons in Polygons

I have 2 layers, they represent 2 different data. I did a spatial join to see the polygons that fall in the other layer using the match option as identical. Before, i used the intersect as the match ...
0
votes
1answer
34 views

PostGIS: Perform a Spatial Join only joining the intersecting polygon with the maximum value

I'd like to perform a spatial join using PostGIS. I've got table_A containing 80.000 entries and table_B containing roughly 1.500.000 entries. The entries in table_B have a column "number". My goal ...
2
votes
1answer
15 views

Joined Attributes not recognized in mean coordinates

I am trying to find mean coordinates of a shapefile to which I have joined a csv file for population attributes, but these will not show. I'm working with county data of each US state based on the ...
1
vote
0answers
42 views

Spatial join with multiple intersecting features

I have a polygon dataset representing pavement areas broken up by year of construction and a roads centerline dataset that contains values for remaining service life (RSL). I want to spatially join ...
1
vote
1answer
73 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 ...
1
vote
2answers
60 views

Spatial Join - One Join Feature to Multiple Target Features

I want to join a set of target features (polygons) to a set of join features (points). The polygons can, and do, overlap. I want the join features to be counted (joined) to as many target features ...
0
votes
0answers
41 views

Selecting points intersecting polygon

In ArcGIS 10.2 ArcMap am attempting to label a grid of varying size polygons overlaid by a grid of evenly spaced (1km) points with an associated value X by the the value of the point. If a polygon is ...
0
votes
2answers
48 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 ...
1
vote
1answer
79 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
2answers
38 views

Spatial Join returning max value and unique ID

Using ArcGIS 10.3 I have a dataset containing polylines of a pipe network, along which I have a polygon layer representing a burst every 50m. The burst layer contains a value (p) and a unique ID (the ...
0
votes
1answer
82 views

Using spatial join in ArcGIS for Desktop?

I have two spatial layers of about the same (not exactly same) spatial extent. Layer#1 has about twice the number of polygons than layer#2 (in thousands). I am trying to calculate values for Field#X ...
0
votes
1answer
35 views

Associating 2 point files

In the image below, the green points are associated with radar wave amplitude data. They're generated from RasterToPoint, so they're at the centroid of each pixel and have only the value of the ...
1
vote
3answers
38 views

Join attributes by location doesn’t appear to be including data that it should

I am trying to calculate the number of bus stops which are within 400m of c. 100 properties that are in relatively close proximity to one another. Using MMQIS I created the 400m buffer for the ...
1
vote
0answers
24 views

Assign Z value to new coordinates based on interpolated response surface in R

I've created a response surface of sorts based on interpolated z values (bottom of post). I'm looking for the most efficient way to assign the respective z value to a new point (actually, a dataset ...
2
votes
2answers
52 views

How to link polygon features in one layer to polygon features in another, using largest overlap in QGIS or GRASS [duplicate]

I have two polygon layers: the first one contains small land lots (green in the image), the second one contains large zones (the purple line in the image attached separates 2 such zones). I want to ...
1
vote
0answers
28 views

Script for splitting of polygons and spatial join of lines to polygons

For the past couple of weeks I have been arduously creating flood depth rasters using flood zone polygons and base flood elevation survey lines. The issue is that some of the zones do not have a ...
1
vote
1answer
73 views

Using Spatial Join to copy a single attribute

I am attempting to use Spatial Join to combine tax parcels and zoning information, such that the parcels contain the designation of the underlying zone. However, I only want to take the "esmZONE" ...
1
vote
0answers
24 views

How to fix broken geometry after joining features in PostGIS

I have a PostGIS layer I'm serving over GeoServer. It looks like this. Im using the PostGIS query to get a new layer with some grouped features: SELECT id, name, st_union(st_buffer(geom, ...
1
vote
1answer
105 views

Spatially Joining Many Shapefiles. Use Spatial Join or UpdateCursor?

I have a large number of tree records in 100s of point shapefiles. Each shapefile contains a number of trees that fall within 10-50 parcels. The parcel layer contains ~60,000 shapes. For each point ...
1
vote
1answer
71 views

ArcMap populate field with value from another dataset

I have two Polygon datasets, one contains Buildings and the other PostCodes (ZipCodes). I'd like the PostCode field in the Buildings dataset to be populated with the value of the PostCode field from ...
1
vote
0answers
45 views

Matching (joining) two slightly incompatible polygon shapefiles

I have two shapefiles that represent two slightly different zonings of the same area (municipality zoning and transport zones), about 3000 polygons each. Several smaller municipalities may form a ...
1
vote
2answers
153 views

Spatial join using FME

I have two data sets, one is a polygon data set (Norwegian counties) and the other is points (roadkill incidence data). I want to do a spatial join where the points dataset inherits attributes ...
1
vote
1answer
51 views

Copy attribute data from one polygon shapefile to a multiple point shapefile

I have two shape files: Polygons of parks in Africa. Each park (polygon) has a row of data regarding it's size, name, date of establishment etc. Random points in parks in Africa. Here, I generated ...
2
votes
1answer
129 views

How can QGIS Field Calculator sum values from a spatially joined table?

Can the Field Calculater be used to sum values from a related table via a Spatial Join? I have two vector polygon layers A and B, each with a numerical column VALUES. I want to update VALUES in ...
1
vote
1answer
25 views

Querying Raster Dataset by Location to Study Area

I have downloaded a very handy raster dataset generated by the Nature Conservancy for identifying terrestrial habitat cover types in the north east. Link to the project info and a link containing a ...
1
vote
1answer
61 views

QGIS Spatial Сross Join atrributes

I have a set of LineStrings (streets) And a set of rectangles (atlas pages extents) rectangles could overlap each-other. And now I want to create a legend for atlas like street1, pages: 1,2 ...
1
vote
0answers
55 views

Does QGIS have a dynamic spatial join select tool, equivalent to MapInfo Boundary Select?

I´m a MapInfo user, I´ve gone over to QGIS and it´s got a lot going for it, except for some simple features from MapInfo I just can´t do without. One such is MapInfo Boundary Select, which is a basic ...
0
votes
0answers
73 views

Understanding Spatial Join

How do I join .shp files so one layer will contain the amount of overlapped Area from another layer (per HUC as illustrated below)? I'm trying to determine how much Area [POLY_AREA] overlaps the HUC ...
0
votes
2answers
24 views

Combine Community Layer with County Layer in ArcMap?

I have a County shapefile that I am trying to combine with an updated community or jurisdiction shapefile. I have tried Unioin, Merge, and Spatial Join, but am not getting the desired results. The end ...
0
votes
2answers
24 views

Spatial Join Layer Derived from Zonal Raster on Original Polygon

I'm trying to do a 1:1 spatial join between polygons created from the zonal max of a slope raster on the original zonal features. The problem is that the jagged edges cause the target features to ...
2
votes
0answers
81 views

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

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 ...
0
votes
2answers
91 views

add attribute information from polyline to a point shapefile (QGIS or ArcGIS)

I was wondering if, and how, it is possible to add attribute information from a polyline to a point dataset. I have a network layer with information per street how many scooters went over this street. ...
1
vote
1answer
73 views

Is there a way to save a spatial join as .sqlite?

I'm joining data from PostGIS and SpatiaLite databases in QGIS using the "Join attributes by location" (Vector -> Data management Tools) tool. However, this has a big limitation - I can only save the ...
0
votes
1answer
109 views

Spatial join point data to polygon shapefile and count a variable

I would like to perform a spatial join from point data to a polygon shapefile. In the point data attribute table there is a column called {quality} and I would like to count each category from the ...
1
vote
4answers
60 views

Labels based on spatial location

Here is what I would like to do. I have a polygon feature class called Subdivisions and a point feature class called Inspection. If I label all the Subdivisions my map becomes too congested. I only ...
0
votes
2answers
174 views

Populate cross street name at intersections

Just a follow up of an older post seen here: Python script/Model to populate cross street names at intersections I need to create a shapefile of Road segments with a "To_Road/s" and "From_Road/s" as ...
3
votes
1answer
256 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 ...
0
votes
0answers
34 views

Join attribute tables based on both location and attribute value

I'm using ArcGIS 10.2.2, basic licence. I have two polygon layers, with habitat type as an attribute. layerB is a copy of layerA, but each habitat has a 25m buffer and has then been dissolved ...