User analyst92

4 votes

1 answer

145 views

Is "order by" clause in DBSCAN necessary?

asked Oct 2, 2022 at 11:47

4 votes

1 answer

270 views

Converting to EPSG code gives error

asked Oct 19, 2022 at 13:53

4 votes

1 answer

128 views

Do both arguments of ST_DWITHIN have to be spatially indexed geographical columns to efficiently check proximity in meters

asked Aug 16, 2023 at 11:00

3 votes

1 answer

100 views

Getting timestamp of each time pings enter and leave a radius

asked Mar 3, 2023 at 7:22

3 votes

2 answers

569 views

using st_collect vs st_union to calculate centroids

asked Sep 29, 2022 at 11:25

3 votes

2 answers

163 views

Total length of intersecting lines - comparing multiple lines to each other

asked Sep 27, 2022 at 20:17

3 votes

1 answer

611 views

Shortest distance between a point and multiple lines in PostGIS [closed]

asked Sep 19, 2022 at 13:22

3 votes

1 answer

1k views

How to check if geometry column has spatial indexing or not

asked Sep 21, 2022 at 6:55

3 votes

1 answer

407 views

ClusterDBSCAN eps unit is meter or degrees if SRID is 4326

asked Sep 26, 2022 at 14:21

3 votes

1 answer

94 views

Total number of intersections within a given radius

asked Sep 27, 2022 at 13:01

2 votes

1 answer

57 views

Total number of intersections of multiple linestrings - not working as expected

asked Sep 27, 2022 at 17:33

2 votes

2 answers

404 views

Is EPSG defined separately for each geometry column?

asked Sep 21, 2022 at 8:24

2 votes

1 answer

486 views

converting geometry of SRID 0 to geography

asked Sep 20, 2022 at 10:54

2 votes

1 answer

176 views

Calculating speed at various points along a route for each device

asked Sep 29, 2022 at 8:39

2 votes

0 answers

72 views

ST_DWithin taking an unreasonable time with geographical spatial indexing

asked Aug 18, 2023 at 8:50

2 votes

0 answers

156 views

CROSS JOIN LATERAL vs NOT EXISTS subquery for distance bound checking

asked Aug 26, 2023 at 11:24

2 votes

0 answers

47 views

Recursive nearest neighbour to find shortest route

asked Sep 29, 2023 at 22:59

2 votes

1 answer

29 views

ST_ClusterKMeans followed by Convex Hull gives overwhelmingly overlapped polygons

asked Sep 23 at 13:45

1 vote

0 answers

19 views

Cross join lateral for radius bounded Multi-linestrings

asked Sep 28, 2022 at 13:57

1 vote

0 answers

73 views

Spatial indexes not being used despite existing

asked May 21 at 10:40

1 vote

1 answer

70 views

Minimum spanning tree (MST) over a set of POINT geometries

asked Sep 30, 2023 at 11:53

1 vote

0 answers

42 views

Multiple "WHERE" conditions in a "NOT EXISTS" clause for distance bound checking

asked Aug 28, 2023 at 10:58

1 vote

1 answer

88 views

Distance unit in KNN using cross join lateral

asked Aug 31, 2023 at 6:10

1 vote

0 answers

177 views

Converting meters to degrees for ST_DWithin

asked Aug 21, 2023 at 6:47

1 vote

1 answer

321 views

SQL Error [22023]: ERROR: Geometry has Z dimension but column does not when updating SRID of PolygonZ column in PostGIS

asked Aug 23, 2023 at 11:06

1 vote

1 answer

34 views

ST_DWithin coordinate transforming one or both geometries

asked Aug 4, 2023 at 9:57

1 vote

1 answer

46 views

ST_Area on a PolygonZ

asked Aug 4, 2023 at 15:30

1 vote

1 answer

107 views

Cluster assignment in ST_ClusterKMeans

asked Aug 8, 2023 at 9:22

1 vote

1 answer

25 views

Kmeans - putting k as the number of rows in the partition window / 10

asked Aug 15, 2023 at 14:25

1 vote

0 answers

96 views

Understanding if Cross Join Lateral is working as expected

asked Oct 6, 2022 at 9:45

Stack Exchange Network

47 Questions

Is "order by" clause in DBSCAN necessary?

Converting to EPSG code gives error

Do both arguments of ST_DWITHIN have to be spatially indexed geographical columns to efficiently check proximity in meters

Getting timestamp of each time pings enter and leave a radius

using st_collect vs st_union to calculate centroids

Total length of intersecting lines - comparing multiple lines to each other

Shortest distance between a point and multiple lines in PostGIS [closed]

How to check if geometry column has spatial indexing or not

ClusterDBSCAN eps unit is meter or degrees if SRID is 4326

Total number of intersections within a given radius

Total number of intersections of multiple linestrings - not working as expected

Is EPSG defined separately for each geometry column?

converting geometry of SRID 0 to geography

Calculating speed at various points along a route for each device

ST_DWithin taking an unreasonable time with geographical spatial indexing

CROSS JOIN LATERAL vs NOT EXISTS subquery for distance bound checking

Recursive nearest neighbour to find shortest route

ST_ClusterKMeans followed by Convex Hull gives overwhelmingly overlapped polygons

Cross join lateral for radius bounded Multi-linestrings

Spatial indexes not being used despite existing

Minimum spanning tree (MST) over a set of POINT geometries

Multiple "WHERE" conditions in a "NOT EXISTS" clause for distance bound checking

Distance unit in KNN using cross join lateral

Converting meters to degrees for ST_DWithin

SQL Error [22023]: ERROR: Geometry has Z dimension but column does not when updating SRID of PolygonZ column in PostGIS

ST_DWithin coordinate transforming one or both geometries

ST_Area on a PolygonZ

Cluster assignment in ST_ClusterKMeans

Kmeans - putting k as the number of rows in the partition window / 10

Understanding if Cross Join Lateral is working as expected