All Questions
31
questions
3
votes
0
answers
250
views
PostGIS difference between two tables with polygon
I have two polygon tables. I try to remove portions but the end result is not acceptable.
I took the time to look at different questions and answers about ST_Difference but I couldn't solve my problem....
- 131
1
vote
0
answers
289
views
How to speed up PostGIS clipping of out-db rasters?
I'm clipping (and unioning) thousands of tiled raster files that are stored in an out-db PostgreSQL/PostGIS database located on a SSD. I want to use PostgreSQL but I found that PostGIS is taking ...
1
vote
1
answer
486
views
How to properly use JOIN or GROUP By for ST_Union in PostgreSQL with PostGIS extension [duplicate]
There was already a related question, but it is not answered yet and doesn't provide the necessary information for this case...
I want to cut a raster with a polygon. The raster is stored in tiles in ...
- 330
2
votes
0
answers
189
views
Optimization of multi-band raster clip by polygon
I have tiled (50x50), 365 band, rasters in my postgis database. Each band represents a day in a year.
I want to return the raster pixels which intersect with an input geometry, including all bands. I'...
2
votes
1
answer
105
views
Creating clip in processing script for layers in directory
I am trying to create a simple script for me to clip the layers of a directory. The moment I create an output directory it no longer creates the interface of the tool. Additionally, I'm not sure I ...
3
votes
3
answers
2k
views
Clipping polygons and lines at exact borders within PostGIS
I have OSM data of the whole world in a PostGIS db.
For some reasons, I want to work with tables which have only data from a given bounding box inside.
I create this tables with following command:
...
- 43
4
votes
1
answer
3k
views
Spatial query with clip (PostGIS)
I'm making the transition from GIS to PostGIS and am stuck on this spatial query.
I have background geometry (purple, outlined red) which has an overlay of islands (blue, below); I need the area of ...
- 83
4
votes
1
answer
1k
views
ST_Clip tiled raster using geometry results in out of geometry pixels
I'm trying to run an ST_Clip for a simple AOI geometry.
I'm using this WGS84 raster, imported into PostGIS like so:
raster2pgsql -t 100x100 -C -M -F -I -s 4326 Hansen_GFC-2016-v1.4_lossyear_20S_070W....
- 1,216
5
votes
1
answer
2k
views
Clipping tiled raster with polygon using PostGIS?
I have a table in postgis with a tiled raster and a table with polygons overlaying the raster. I want to get the number of pixels for each category (pixel value) that fall inside a specific polygon.
...
- 81
0
votes
1
answer
133
views
PostGIS Clipping a Raster with a Geotiff
I believe I am doing a common operation where I am trying to clip a a Raster with a Geometry. They both share the same srid and I can successfully perform st_clip and st_intersection with the crop ...
- 101
11
votes
1
answer
3k
views
Splitting overlap between polygons and assign to nearest polygon using PostGIS?
My question is quite related to the unanswered Split overlap between polygons into disjoint sets except I'm not using shapely, I'm using PostGIS 2.4 on PostgreSQL 10.
I have a table containing ...
- 237
7
votes
0
answers
703
views
PostGIS issue with ST_Clip?
I'm trying to clip a raster using a polygon but I end up with a result that doesn't seem right and where some raster pixels are outside the polygon used for the clip.
See image below where polygon is ...
- 880
2
votes
1
answer
700
views
ST_Clip not including pixels intersecting the border of a shapefile
I'm trying to clip a raster with a shapefile in PostGIS but want the clipped raster to include pixels that overlap the border of the shapefile which ST_Clip doesn't seem to be including.
Here is a ...
- 1,161
4
votes
1
answer
424
views
ST_intersection returns erroneous polygons
I am trying to perform a clip by attribute in PostGIS between two shapefile containing 3000 polygons.
Both shapefiles are free of errors (checked with topology checker), both shapefile are using EPSG:...
- 701
0
votes
1
answer
533
views
Clip Raster with polygon if different SRID (Postgis)
I have a raster with a SRID of 4326 and a polygon of SRID 2275. The raster was uploaded to postgis with 90x90 tiles using the following raster2pgsql cmd...
raster2pgsql -s 4326 -I -M -b 1 ...
- 910