The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [intersection]

Use this tag when asking questions related to where features overlap.

Filter by
Sorted by
Tagged with
1
vote
0answers
84 views

GDAL intersection returning NoneType in Python

I have two shapefiles, one for landuse and one for subbasin. I want to find out how much landuse area is present within 3rd feature of subbasin shapefile. I am using following code. fillu = ogr....
3
votes
2answers
1k views

mongo geoIntersects with Spring Data

I created a collection that contains a multipolygon document. I want to write a query in spring data that tells me if a point (lon, lat) intersects the multipolygon. The query in mongoDb is as ...
6
votes
1answer
137 views

PostGIS slow intersection

Yet another intersection issue. I'm working with OSM database in PostGIS. Now trying to count all buildings that fall into a countries bounding box. This is my query (bbox for Germany). SELECT ...
1
vote
0answers
146 views

Intersecting two geodatabases with ogr

I am trying to create an intersection between two different layers of two different geodatabases using ogr2ogr, but without success. I have been using the following command line prompt: ogr2ogr.exe ...
3
votes
1answer
195 views

Calculating distance between matching intersections using QGIS?

I have a streetmap with the coordinates of some speed limit signs (which mark either the beginning or the ending of a speed limit and hold the applicable speed limit in km/h). With regard to the ...
2
votes
1answer
1k views

Vector Geoprocesing Intersection not working in QGIS 3.0? [closed]

I have not been able to create an intersection layer in QGIS 3.0. The method has been working fine in QGIS 2.18. The method I have been using is to select Vector >> Geoprocessing tools >> Intersection....
1
vote
1answer
166 views

Copying rasters which are intersecting with polygons using ArcPy?

I'm new to ArcPy and to Python in general. I have a huge raster dataset of all over the World (~1000 tiles .tif) and i'd like to automatically copy the tiles which are intersecting with 24 polygons (...
2
votes
1answer
309 views

Optimize intersection of polygons

I need to get the intersection of two polygons and both sides use the same dataset (titlenumberpolygon - UK National polygons). PostGIS is used in the analysis. First a spatial index was created ...
0
votes
1answer
35 views

Stop SQL Server selecting outside buffer

I am trying to select all the parks within 200m or a railway. I can easily create and visualise the 200m buffer. However when i try and find only the parks that intersect it i get all parks returned,...
1
vote
1answer
350 views

Intersection of rasters in ArcGIS Desktop?

I have two set of raster layers, one for buildings (static) and one for depth of surface water due to pluvial flooding from simulation (dynamic, changes with each time step). My aim is to generate ...
2
votes
1answer
210 views

How to join attributes of points with several overlapping polygons?

I am making a road atlas using QGIS, where the pages overlap: I would like the intersection of the roads and the edge of each atlas page (for example, Point A and Point B) to tell which pages you ...
1
vote
1answer
159 views

Calculate the Intersect Area of Polygon Features and Circles of Equal Area Based on Feature Centroid [closed]

For this task I am using ArcGIS Pro 2.1. I am trying to fist create a process then automate the process to do the following: Create circular polygons of equal area to and with the same centroid as ...
6
votes
2answers
316 views

Looping through table to get single intersection from N>2 geometries using PostGIS?

It's really clear how to apply ST_Intersection when you have only two geometries. But I am struggling with the situation where you have N>2 shapes and you want to compute a single one that represents ...
0
votes
0answers
73 views

gdalwarp bugs with extent as float?

I work with GDAL 2.2.1, released 2017/06/23 I had some troubles when trying to resample GeoTiff images to make different data sources match with extent and resolution. I found an answer here: GDAL: ...
0
votes
1answer
336 views

Ghost Multipolygons block Overlay Intersection

I'm really desapointed, because I did everything to avoid Multipolygon in my script but last treatment blocks because of Multipolygon : File "/.../Zonage/Zonage_standalone.py", line 254, in zonage ...
0
votes
1answer
289 views

Extract points/pixels from raster based on % of intersection using PostGIS and PostgreSQL

I need to overlay a geometry (Shapefile of some city in UK) over a raster (grids of entire UK Map) and extract cells/pixels from raster that intersect with points of geometry. Current Implementation:...
1
vote
1answer
556 views

Intersection with Shapely and Fiona gives Key Error

I have written a script for standalone python based on this example for doing intersections of linestrings (representing streets) and polygons (representing gridcells) using shapely/fiona. The ...
3
votes
0answers
201 views

Framing of WFS GetFeature request using polygon intersect filter

I am trying to frame a Web Feature Service GET Request applying the INTERSECT filter but I am getting the following error. : <ows:ExceptionReport xmlns:ows="http://www.opengis.net/ows" version="1....
5
votes
2answers
571 views

Aggregate version of ST_Intersection

I would like to use an aggregate version of the ST_Intersection function in PostGIS. In a table I have multiple polygons and would like to calculate the intersection of all of them. Ideally it would ...
1
vote
1answer
330 views

The Filter geometry function in T-SQL is not precise and does not return valid results

I have two tables, edges (a set of polyline features): and nodes (set of points): I want to find the "id" of those points that have an intersection with the first point of any edges. I used the ...
4
votes
1answer
222 views

Recover M-values from PostGIS `ST_Intersection`?

I am querying the intersection of a path (LinestringZM) through a region (MultiPolygon) but the ST_Intersection returns only the Lat/Long/Alt coordinates and I need to recover time, stored in the M ...
0
votes
1answer
253 views

Intersect does not remove features, leaves them empty. Python

So I have a shapefile with 16k linestrings, and one polygon of a smaller area. My intention is to do intersection and keep only the lines or fragments of lines that lie inside the polygon, following ...
1
vote
2answers
1k views

Intersecting linestrings with polygons in Python [closed]

I have two shapefiles, one is a 1x1 km grid displayed as polygons and the other one is a street network displayed as linestrings. I want to cut the linestrings where they intersect the boundaries of a ...
0
votes
1answer
109 views

Intersection of geometries as GeoSPARQL result

I'm querying two geosparql conform datasets at endpoint http://onto.fel.cvut.cz:7200/sparql trying to get intersectred geometry as result using GeoSPARQL language. PREFIX rdf: <http://www.w3.org/...
2
votes
0answers
129 views

QGIS processing algortihm crashes in python console but works manualy

I am loading two layers from PostGIS database and I am trying to run 'qgis:intersection' algorithm with them. Execution of the algorithm through the python console initially works but crash after 2-3%....
2
votes
2answers
896 views

Area of Intersection between two polygon files in QGIS

I'm new to mapping concepts and software. I need to report on the intersecting area of postcode polygons and NBN Rollout areas. So postcode 3000 has 3 units of area in rollout region 1 and 6 units of ...
1
vote
2answers
165 views

Intersection between polygons layers is empty

I'm trying to compute the area of green surface for cities with QGis from open data found online. I have polygons on a layer for the cities boundaries and polygons on another layer for the parks. I ...
0
votes
0answers
185 views

3d Intersect query compatible with GeoTIFF/DEM?

When researching this topic I haven't been able to verify if it's possible to make spatial 3D Intersect queries between a vector polygon with z-values and GeoTIFF/DEM file holding the elevation values?...
0
votes
1answer
577 views

Calculating the proportion of area drawn over boundary file

I'm working with agriculture area data in MapInfo. I downloaded the boundary file from StatCan (call it STC), and a freehand draw tool downloaded here https://tinyurl.com/ydarsnq8 (call it DRW) I can ...
1
vote
0answers
68 views

SQL for proportional overlap in PostGIS returns successful; no affected rows

I have two tables one with block group+data and another with geometries of communities. I want to calculate the intersection area so I can later calculate the proportion of each block group in a given ...
2
votes
4answers
2k views

Intersection reports invalid geometries

I want to intersect two layers (shapefiles) with QGIS 2.18. For both layers, I tested validity with QGIS Vector / Vector Tools / Check validity and GRASS v.build.check (with default parameters) both ...
1
vote
0answers
149 views

Postgis : separate nested polygons

I'm working on OpenStreetMap data on Postgis. I have in a table "roads_polygons_label" containing all the polygons and roads in a given area and for each of them a label saying what it is (e.g. ...
2
votes
1answer
938 views

Executing intersect algorithm with pyqgis?

I want to run the process "qgis:intersection" in a pyton-script and try it like this: import processing a1 = QgsMapLayerRegistry.instance().mapLayersByName('Layer1')[0] a2 = QgsMapLayerRegistry....
0
votes
1answer
51 views

Saving borough boundaries as MultiLineStrings or MultiPolygons?

I am creating a database in PostGIS and I have a column that will save the boundaries of boroughs. The app will later query the database, asking what points, lines or polygons are inside those ...
-1
votes
2answers
114 views

Find road network lines that don't intersect

in ArcGIS,am looking for a quick way to show the roads that don't intersect
2
votes
1answer
161 views

Does the inputs extent have to be identical for raster::intersect to crop a RGB GEOTiff?

Background: I have a shapefile with multiple polygons over a large area and then I also have GEOTiff image files. I want to crop the TIFF files with each of the polygons. The problem is that when I ...
1
vote
1answer
178 views

postgis st_intersection of linestrings geometric miscalculations

Below, is a PostGIS SQL query where I have a table called nullss (polygon and line geometry) and a table called zones(polygon and line geometry as well) where the zones table spatially surrounds the ...
2
votes
1answer
2k views

How to split a shapely polygon with two linestrings and get the middle polygon

So I have a shapely Polygon and two LineStrings. Both Linestrings always intersects the polygon. I want to get the polygon in the middle as seen in the example below. The region shaded in red is the ...
1
vote
1answer
273 views

True GIS clip of polygons + attribute table

How can a true intersection/clipping of polygons be done in R? Problem description: Shapefile1 contains only one feautre without attributes (or - at least - attibutes don't matter). Shapefile2 ...
1
vote
1answer
304 views

raster::intersect not working in R

I have a SpatialPointsDataFrame and a raster for a region. I would like to retain only those points that occur within the elevational limits of the raster. Unfortunately, no points are being filtered. ...
2
votes
2answers
179 views

Query similar Linestrings (running workouts) using PostGIS

I track my running workouts using GPS and I have the coordinates for each of them I create a table to save each workout CREATE TABLE runnings (id SERIAL PRIMARY KEY, userId ...
3
votes
1answer
512 views

Looking for intersection of polygons with a tolerance in QGIS

I have two QGIS layers I created from shape files. I wanted to find which regions from one layer intersect with districts from the other layer, and the intersect tool does that perfectly. I find ...
1
vote
2answers
495 views

How to check how many line intersects a intersecting point in same geometry

I want to know that how many line intersects a point. In figure below it can be seen that 3 lines crosses a point. 2 red lines and 1 blue line. I want to know in the same geometry that many lines ...
2
votes
1answer
91 views

Intersecting to vector layers when there is no common attribute [duplicate]

I am trying to join two vector layers into one, the first is a road noise barrier shapefile, the second is a vectorised DEM. The road barriers have a relative height attribute for each section of ...
1
vote
0answers
70 views

Calculate fields referring to other layer?

I have to analyze different pathway segments based on a few variables: Number of properties crossed (polygons) Length of paths on public land (polygons) Number of intersection with stream (lines) ...
1
vote
1answer
316 views

Error in PostGIS intersection

I have a PostGIS query that counts the length of individual lines in each buffer: SELECT buffered.name, ST_LENGTH(ST_Intersection(buffered.buffer, lines.wkb_geometry)) AS total_length FROM ...
3
votes
1answer
615 views

Snap lines to nearest line in PostGIS

I have a number of pedestrian trajectories (green) that I would like to snap to the nearest road (brown). The roads are downloaded from OpenStreetMap and have been dissolved by name with CREATE ...
3
votes
2answers
191 views

Can I save a newly created Intersection layer directly into a Spatialite database in QGIS without importing?

I have a point layer (xyz_coordinates_UTM33N) and a polygon layer (section1) in a SpatiaLite database. I wish to extract the points within the polygon to a new layer, and I want that layer stored in ...
0
votes
1answer
638 views

Get intersection points between multipolygon and multiline

I am trying to get the intersection points between the boundary of a city (stored in the database as a MultiPolygon) and the OSM roads (stored as Multiline string). I am using ST_intersect(city.geom,...
1
vote
1answer
239 views

Identify polygons intersected by lines in a different shapefile

I have a shapefile with lines and a different shapefile with polygons. I want to identify the id (attribute) of the polygons intersected or overlapped by each line, to then make some additional ...