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
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users