Re: R-tree, order by, limit

From: Mark Cave-Ayland <mark(dot)cave-ayland(at)siriusit(dot)co(dot)uk>
To: Anton Belyaev <anton(dot)belyaev(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: R-tree, order by, limit
Date: 2008-09-22 08:33:15
Message-ID: 48D7584B.1070406@siriusit.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bohdan Linda 2008-09-22 08:37:57 Re: Getting cozy with weekly PITR
Previous Message Asko Oja 2008-09-22 08:01:34 Re: Largest PostgreSQL 8.x DB someone is running?