Postgres Pro
Downloads
Home   >   mailing lists

Re: R-tree, order by, limit - Mailing list pgsql-general

From Mark Cave-Ayland
Subject Re: R-tree, order by, limit
Date
Msg-id 48D7584B.1070406@siriusit.co.uk
Whole thread Raw
In response to Re: R-tree, order by, limit  ("Anton Belyaev" <anton.belyaev@gmail.com>)
Responses Re: R-tree, order by, limit
List pgsql-general
Tree view 
Anton Belyaev wrote:

>> 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.

Hi Anton,

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...


ATB,

Mark.

--
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063

pgsql-general by date:

Previous
From: "Asko Oja"
Date:
Subject: Re: Largest PostgreSQL 8.x DB someone is running?
Next
From: Bohdan Linda
Date:
Subject: Re: Getting cozy with weekly PITR