[postgis-users] Partitioning using Geometry

Brian M Hamlin maplabs at light42.com
Fri Apr 3 13:21:18 PDT 2015


I have implemented this in the past, with "millions of features" ... 
for land use classification in California.. 
given a reference topological set.. each polygon in the topology gets 
an ID, each POINT is assigned to one and only one poly ID
partition on the poly *id* -- no geometry expression in the check constraints

Improvements to the method include weighting, and combining sparse buckets
worked great ..   -Brian


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150403/83dd5f1b/attachment.html>


More information about the postgis-users mailing list