Hello, I have many many points (roughly 100-200 millions) all throughout the united states. I am loading that data into a set of postGIS servers partitioned by states or counties (partitioning by state is easier because it requires less instances, but partitioning by county will provide more "targeted" lookups).
What I want to do is for a getMap request (that will be done per tile) I want to quickly target the database to fetch the points from by first doing an intersection lookup by state boundaries (if I partitioned) or by county boundaries (if I partitioned by county). so let's assume I partitioned by state, what I would do is receive a getMap request, fetch all the states that intersect that bounding box, run through each state I come up with and paint all the points from that state on the tile raster. What is the standard method with which people use geoserver to "target" a particular sets of partitions to grab features from to paint on a particular raster without having to run through all the possible partitions? Thank you, -- Signed, Alessandro Ferrucci ------------------------------------------------------------------------------ Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users