Re: R-tree, order by, limit

Поиск
Список
Период
Сортировка
От Anton Belyaev
Тема Re: R-tree, order by, limit
Дата
Msg-id d7e834b0809220318v7c06cc6bq1e48de77525dfee@mail.gmail.com
обсуждение исходный текст
Ответ на Re: R-tree, order by, limit  (Mark Cave-Ayland <mark.cave-ayland@siriusit.co.uk>)
Ответы Re: R-tree, order by, limit
Список pgsql-general
2008/9/22 Mark Cave-Ayland <mark.cave-ayland@siriusit.co.uk>:
>>> I am implementing a map application. There are towns with altitude,
>>> longitude and population.
>>> One of the tasks is to be able to query N biggest (by population)
>>> towns within a rectangle.
> Have you considered using PostGIS? (http://postgis.refractions.net). It
> implements the OGC SFS for geometries and is compatible with a large number
> of open source viewers/tools such as Mapserver, Geoserver, QGIS, OGR etc...

Mark, thanks for the suggestion.
I examined PostGIS some time ago. It is too complex for my simple task
and it gives no advantages for me:
For spatial indexing it uses the same GiST-based R-tree.
And PostGIS does not offer that "population" or "priority" queries I need.

Anton.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Anton Belyaev"
Дата:
Сообщение: Re: R-tree, order by, limit
Следующее
От: Volkan YAZICI
Дата:
Сообщение: Re: R-tree, order by, limit