Reputation
790
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
6 25
Impact
~20k people reached

  • 0 posts edited
  • 0 helpful flags
  • 21 votes cast
Aug
14
awarded  Notable Question
Jul
23
comment Load geographical data administrative boundaries for Europe by levels
The actual data can be downloaded here at the time of writing: ec.europa.eu/eurostat/web/gisco/geodata/reference-data/… - non-commercial use only so not suitable for inclusion in OpenStreetMap (or any other dataset that allows commercial use.)
Apr
2
awarded  Popular Question
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