Have a look here: http://www.paulnorman.ca/blog/2016/05/improve-your-st-geohash-sorting-with-these-three-simple-tricks/
for simplest case, you can just order by your geom field. ср, 1 мар. 2017 г. в 14:44, Jonathan Moules <[email protected]>: > Hi List, > I've got a database of about 60 million spatial features that I need to > run through a process. > > The process can't do all of them at once, so I want to get the data from > postgis in spatial chunks of up to say 500,000 features per query. > > The data itself isn't evenly spatially distributed, so gridding won't work > either, and I don't see any prospectively useful functions in the reference. > > Non-spatially this would be simple: > > *SELECT * FROM my_table ORDER BY some_key ASC LIMIT 500000 OFFSET 0* > > Does anyone have any suggestions for how to spatially order data with > PostGIS? > > Thanks, > Jonathan > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
