760 reputation
423
bio website oegeo.wordpress.com
location Salt Lake City, UT
age 41
visits member for 3 years, 8 months
seen Apr 4 at 5:04

Geospatial omnivore.


Jan
27
awarded  Popular Question
Nov
12
awarded  Nice Question
Aug
2
awarded  Yearling
Jul
10
awarded  Notable Question
Mar
20
accepted In PostGIS, how to count nearby points efficiently?
Mar
16
comment In PostGIS, how to count nearby points efficiently?
That is great feedback, thanks @diciu. Your first option is what I ended up going with, see my
Mar
16
comment In PostGIS, how to count nearby points efficiently?
@PaulRamsey my thought was to narrow down the search results first with ST_DWithin and then perform the final comparison on the subset with <#>, but you are saying it doesn't work like that? Hm. I will need to go back to <#> and ST_DWithin documentation and better understand what I am doing. Thanks for the feedback.
Mar
16
comment In PostGIS, how to count nearby points efficiently?
Thanks for the comments - I figured out soon enough that indeed operator choice was not the problem here, but the execution plan.
Mar
15
answered In PostGIS, how to count nearby points efficiently?
Mar
15
asked In PostGIS, how to count nearby points efficiently?
Jan
11
awarded  Popular Question
Jan
6
awarded  Popular Question
Oct
8
awarded  Popular Question
Aug
2
awarded  Yearling
Jul
12
awarded  Nice Question
May
22
accepted How to calculate the angle at which two lines intersect in PostGIS?
May
14
awarded  Self-Learner
May
10
comment How to calculate the angle at which two lines intersect in PostGIS?
I was actually surprised that it is not a PostGIS function. Thanks for your feedback on this.
May
9
comment How to calculate the angle at which two lines intersect in PostGIS?
Yep thanks, I use the PostgreSQL degrees() function for that.
May
9
answered How to calculate the angle at which two lines intersect in PostGIS?