770 reputation
524
bio website oegeo.wordpress.com
location Salt Lake City, UT
age 41
visits member for 4 years, 3 months
seen Jul 22 at 20:59

Geospatial omnivore.


Jul
22
comment Can OGR handle Esri's Geodatabase extensible markup language (XML) files?
It's weird because it's supposedly 'Esri's open mechanism for information interchange between geodatabases and other external systems' (reference).. You'd think they would supply a GDAL driver to back that claim up.
Jul
21
asked Can OGR handle Esri's Geodatabase extensible markup language (XML) files?
Jul
2
awarded  Curious
Jun
19
awarded  Notable Question
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?