User dbaston

95 votes

SQL query to have a complete geojson feature from PostGIS?

answered Apr 27, 2016 at 18:56

40 votes

Fixing non-noded intersection problem using PostGIS

answered Mar 19, 2014 at 23:04

27 votes

PostGIS Geometry type not matching column type in QGIS

answered Apr 30, 2014 at 16:17

26 votes

Accepted

PostGIS - how to effeciently ST_Union all overlapping polygons in a single table

answered Oct 2, 2015 at 18:34

26 votes

Accepted

Check whether table has overlapping polygons, in PostGIS?

answered Jun 12, 2017 at 12:36

25 votes

Accepted

Is it ok to group by geometry in PostGIS?

answered Sep 10, 2017 at 23:59

23 votes

PostGIS nearest points with ST_Distance, kNN

answered Feb 9, 2017 at 17:38

23 votes

Accepted

postgis update multipolygon with st_makevalid() gives error

answered Oct 2, 2015 at 20:32

23 votes

Accepted

Using ST_Difference to remove overlapping features?

answered Jul 24, 2015 at 15:41

20 votes

How to get the centroid of a set of points in PostGIS?

answered Jun 18, 2018 at 22:27

14 votes

Multipoint vs point PostGIS

answered Apr 12, 2017 at 19:56

14 votes

Accepted

PostGIS - when I add a polygon, delete overlapping areas in other layers

answered Mar 19, 2014 at 11:40

14 votes

converting/parsing geojson into com.vividsolutions.jts geometry

answered Oct 2, 2015 at 10:44

13 votes

Accepted

Enforce PostGIS constraint that geometries do not overlap

answered Feb 8, 2018 at 18:19

12 votes

Accepted

Force coordinate precision in QGIS when saving feature to PostGIS

answered Aug 2, 2016 at 12:51

11 votes

Accepted

PostGIS ST_Intersection of polygons can return lines

answered Mar 12, 2014 at 0:12

11 votes

Accepted

How does QGIS Zonal Statistics handle partially overlapping pixels?

answered May 3, 2018 at 15:53

11 votes

Accepted

Finding PostGIS tables that are missing indexes?

answered May 24, 2017 at 17:48

10 votes

Accepted

Undoing last point when drawing linestring in OpenLayers 3?

answered Sep 29, 2016 at 14:55

10 votes

Accepted

Wrong value in ST_distance between two lines

answered May 7, 2018 at 13:54

10 votes

Accepted

What does LW stand for in liblwgeom of PostGIS?

answered Jun 19, 2018 at 15:18

10 votes

Accepted

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

answered Feb 19, 2018 at 21:51

10 votes

Accepted

How to use St_intersects with different geometry type

answered Sep 8, 2016 at 10:51

9 votes

Accepted

Create GeoJSON with CRS from Postgis

answered Jun 10, 2016 at 15:14

9 votes

PostGIS query for selecting features not connected to rest of road network?

answered Mar 4, 2016 at 21:44

9 votes

Area of polygon split by a line

answered Mar 16, 2014 at 16:11

8 votes

Accepted

How to transform a set of street-segments into city-blocks, with PostGIS2?

answered Apr 12, 2014 at 19:44

8 votes

Finding and merging lines that touch in PostGIS?

answered Jan 18, 2016 at 14:44

8 votes

Drawing line between points at specific distance in PostGIS?

answered Apr 6, 2016 at 22:49

8 votes

Accepted

Using ST_ClusterDBSCAN on results of ST_ClusterKMeans for nested clustering with PostGIS?

answered Feb 5, 2018 at 1:23

Stack Exchange Network

172 Answers

SQL query to have a complete geojson feature from PostGIS?

Fixing non-noded intersection problem using PostGIS

PostGIS Geometry type not matching column type in QGIS

PostGIS - how to effeciently ST_Union all overlapping polygons in a single table

Check whether table has overlapping polygons, in PostGIS?

Is it ok to group by geometry in PostGIS?

PostGIS nearest points with ST_Distance, kNN

postgis update multipolygon with st_makevalid() gives error

Using ST_Difference to remove overlapping features?

How to get the centroid of a set of points in PostGIS?

Multipoint vs point PostGIS

PostGIS - when I add a polygon, delete overlapping areas in other layers

converting/parsing geojson into com.vividsolutions.jts geometry

Enforce PostGIS constraint that geometries do not overlap

Force coordinate precision in QGIS when saving feature to PostGIS

PostGIS ST_Intersection of polygons can return lines

How does QGIS Zonal Statistics handle partially overlapping pixels?

Finding PostGIS tables that are missing indexes?

Undoing last point when drawing linestring in OpenLayers 3?

Wrong value in ST_distance between two lines

What does LW stand for in liblwgeom of PostGIS?

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

How to use St_intersects with different geometry type

Create GeoJSON with CRS from Postgis

PostGIS query for selecting features not connected to rest of road network?

Area of polygon split by a line

How to transform a set of street-segments into city-blocks, with PostGIS2?

Finding and merging lines that touch in PostGIS?

Drawing line between points at specific distance in PostGIS?

Using ST_ClusterDBSCAN on results of ST_ClusterKMeans for nested clustering with PostGIS?