How about:
1. Take a centroid of each shape,
2. Rounding it’s x and y coordinates to whole lat/lon values
3. Ordering by lat_round, lon_round and these values would proceed in a gridded
fashion.
Ex: select oid, floor(st_x(the_geom)) as x_index, floor(st_y(the_geom)) as
y_index from
Thanks Paul & Peter for the stimulating topics and resources!
-Original Message-
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Peter Devoy
Sent: Monday, March 21, 2016 1:34 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Postgres as cache
As Roxanne noted, the solution may vary greatly depending on whether or not you
want Read-Only or Read-Write.
One method I have used for read-only with QGis (and Arc*) is Mapserver
providing WFS -- it may be that MapBox could also serve this? AFAIR the Arc
stations would check for updates,
IT is only a matter of parameter order:
ST_within( line, polygon)
ST_Contains(polygon, line)
hth,
/r/b
From: postgis-users [postgis-users-boun...@lists.osgeo.org] on behalf of
Mustafa Elbehery [elbeherymust...@gmail.com]
Sent: Wednesday, March 02, 2016 10:06 AM
Oh - and yes George, by links I meant foreign keys... I must need some sleep
:)
From: postgis-users-boun...@lists.osgeo.org
[postgis-users-boun...@lists.osgeo.org] on behalf of George Silva
[georger.si...@gmail.com]
Sent: Tuesday, December 02, 2014 9:57 PM
To:
Thanks Remi - Qgis may be a viable option for us... if I can sell it to our
users :)
From: postgis-users-boun...@lists.osgeo.org
[postgis-users-boun...@lists.osgeo.org] on behalf of Rémi Cura
[remi.c...@gmail.com]
Sent: Wednesday, December 03, 2014 12:23 PM
To: