User Pierre Racine

21 votes

Creating regular polygon grid in PostGIS

answered Jul 6, 2017 at 13:30

12 votes

Accepted

Querying Elevation Data in Postgis

answered Nov 17, 2016 at 22:24

10 votes

Extracting raster values at points using Open Source GIS?

answered Mar 14, 2012 at 9:09

10 votes

Accepted

How to recursively loop through parent polygons intersections to get smallest (child) polygons with no overlaps?

answered Nov 5, 2018 at 19:38

7 votes

Accepted

Getting zonal statistics of polygons not touching center raster cells in PostGIS?

answered Jul 11, 2018 at 13:28

7 votes

Using PostGIS ST_MapAlgebra

answered Dec 31, 2013 at 20:28

6 votes

Zonal statistics of polygon overlays in PostGIS

answered Dec 7, 2015 at 14:57

6 votes

Accepted

PostGIS raster - sum of rasters

answered Mar 7, 2016 at 15:09

6 votes

Accepted

Passing additional arguments to ST_MapAlgebra callback?

answered Mar 30, 2017 at 15:02

4 votes

Checking for overlapping geometries in one table using PostGIS?

answered Nov 13, 2018 at 15:26

4 votes

Accepted

Creating a raster with point count as cell value?

answered Jul 30, 2019 at 16:12

4 votes

how to overlay shapefile and raster?

answered Mar 18, 2012 at 20:11

3 votes

How to calculate raster statistics for polygons?

answered Apr 11, 2012 at 2:39

3 votes

PostGIS raster - [x,y] from lat/lon

answered Feb 1, 2016 at 15:34

3 votes

Accepted

PostGIS: ST_Clip problem with area which oversteps the raster

answered Aug 17, 2016 at 17:06

3 votes

Visualizing raster coverage of PostGIS in OpenJUMP?

answered Aug 20, 2019 at 17:44

3 votes

Accepted

Get single part polygon by their intersection in PostGIS

answered Nov 5, 2018 at 19:44

3 votes

Accepted

How get intersection of polygons in the same table by PostGIS?

answered Nov 5, 2018 at 18:55

3 votes

Accepted

Union rasters previously cut by bounding box

answered Sep 21, 2019 at 19:45

3 votes

Accepted

PostGIS created fixed dimension raster bigger than geometry

answered Jul 2, 2019 at 14:04

3 votes

Accepted

How to merge two RGB raster tables with overlap by max in each band in postgis?

answered Dec 4, 2017 at 14:45

2 votes

Is there an Postgis equivalent of ArcGis Update tool?

answered Sep 5, 2017 at 20:14

2 votes

Using ST_Difference to remove overlapping features?

answered Sep 5, 2017 at 20:17

2 votes

Seeking PostGIS equivalent to GeoPandas union overlay?

answered Nov 19, 2018 at 14:42

2 votes

Clipping and merging tiles using GDAL based on bounding box from PostGIS?

answered Feb 21, 2019 at 14:41

2 votes

Using postgis to flatten all polygons in table

answered Nov 5, 2018 at 13:37

2 votes

Making a raster coverage that shows the average speed of points

answered Aug 26, 2019 at 13:14

2 votes

I cannot insert into a PostGIS raster table when I add raster constraints. "raster_table" violates check constraint "enforce_nodata_values_rast"

answered Jul 1, 2020 at 1:59

2 votes

Accepted

Enclose polygons that are not overlapped and remove gaps between them?

answered Mar 30, 2020 at 14:25

2 votes

Accepted

PostgreSQL- query a raster by XY

answered Jun 21, 2019 at 12:35

Stack Exchange Network

75 Answers

Creating regular polygon grid in PostGIS

Querying Elevation Data in Postgis

Extracting raster values at points using Open Source GIS?

How to recursively loop through parent polygons intersections to get smallest (child) polygons with no overlaps?

Getting zonal statistics of polygons not touching center raster cells in PostGIS?

Using PostGIS ST_MapAlgebra

Zonal statistics of polygon overlays in PostGIS

PostGIS raster - sum of rasters

Passing additional arguments to ST_MapAlgebra callback?

Checking for overlapping geometries in one table using PostGIS?

Creating a raster with point count as cell value?

how to overlay shapefile and raster?

How to calculate raster statistics for polygons?

PostGIS raster - [x,y] from lat/lon

PostGIS: ST_Clip problem with area which oversteps the raster

Visualizing raster coverage of PostGIS in OpenJUMP?

Get single part polygon by their intersection in PostGIS

How get intersection of polygons in the same table by PostGIS?

Union rasters previously cut by bounding box

PostGIS created fixed dimension raster bigger than geometry

How to merge two RGB raster tables with overlap by max in each band in postgis?

Is there an Postgis equivalent of ArcGis Update tool?

Using ST_Difference to remove overlapping features?

Seeking PostGIS equivalent to GeoPandas union overlay?

Clipping and merging tiles using GDAL based on bounding box from PostGIS?

Using postgis to flatten all polygons in table

Making a raster coverage that shows the average speed of points

I cannot insert into a PostGIS raster table when I add raster constraints. "raster_table" violates check constraint "enforce_nodata_values_rast"

Enclose polygons that are not overlapped and remove gaps between them?

PostgreSQL- query a raster by XY