yes I have to go through the spacial indexing. I am grateful for the replay.
- Our dataset is a collection of some objects [car, bus, cycle] where each object represented in each wms layer in client side using Openlayer. - All the metadata of all the objects = car, bus, cycle is stored in SQL DB with its personal data and its latitude and longitude of that point in its row. - I have created 3 query for 3 layer (car , bus , cycle) to create 3 wms layers. - But now I want based on the owner permission only some object must be shown at the client side Ex: owner 1 have permission for 1000 bus out of 50000 busses. - How can I make a proper use of the geoserver and Openlayer and Sql db. To reach this output. - Do we have any approach to pass dynamic sql query and create wms layer for that query result dynamically using geoserver or any other opensource tool I should use. - I have to handle 1000000 points and min 1000 user accessing them with respected permission. -- Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
