[OSM-dev] Best and FASTEST Spatial DB for only calculating points near to X?

[Stefan Keller]

Hi Ander

I would try PostGIS with the newest KNN index, limited to X first
results, and eventually also limited by an absolute distance criterion
(see ST_DWithin) or bbox, accelerated by a spatial index like this:

  SELECT ST_AsText(osm_poi.way) AS geom, name AS label
  FROM
    osm_poi,
    (SELECT ST_Transform(ST_GeomFromText('POINT(8.81638 47.22666)',
4326), 900913) AS way) AS mylocation
  WHERE ST_DWithin(osm_poi.way, mylocation.way, 20000)
  AND osm_poi.tags @> hstore('amenity', 'restaurant')
  ORDER BY osm_poi.way <-> mylocation.way
  LIMIT 100

(this query can be tested on my PostGIS Terminal.)

Yours, Stefan


2012/12/15 Jukka Rahkonen <jukka.rahkonen at latuviitta.fi>:
> Hi,
>
> Why not to put a good dataset available, let people run some tests with
> different databases and publish the results like in this clipping contest?
> http://gfoss.blogspot.it/2012/11/arcgis-vs-qgis-etc-clipping-contest.html
>
> Read also from the end of this message the warning about comparing apples
> with oranges
> https://www.gaia-gis.it/fossil/libspatialite/wiki?name=benchmark-4.0
>
> -Jukka Rahkonen-
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev