Excellent, Andrea! SQLViews look exactly like what i need (though i haven't gotten it to work yet … and i was kinda looking forward to some GeoServer coding ;-) It seems to me that CQL is still doing the filtering in GeoServer? Thanks --nix
On Feb 14, 2013, at 02:15, Andrea Aime <[email protected]> wrote: > On Thu, Feb 14, 2013 at 4:21 AM, Robert Nix <[email protected]> wrote: > Hi, > > Being that i'm kind of new to GeoServer, i'm looking for some ideas for how > best to implement the ability to basically send a query through WMS to > PostGIS but still have it processed as if it was a defined layer? > > My scenario is that i have to be able to query any individual (or group or) > geometry-row(s) from a PostGIS table that contains millions of rows and build > a GeoTiff. It seems filtering a layer in GeoServer for such a large amount of > data isn't possible and given the huge (and growing) number of rows, defining > static layers in GeoServer is also infeasible? > > Before delving into programming options, have you looked into: > - CQL filtering: > http://docs.geoserver.org/stable/en/user/tutorials/cql/cql_tutorial.html > - parametric SQL views: > http://docs.geoserver.org/latest/en/user/data/database/sqlview.html > > Cheers > Andrea > > > -- > == > Our support, Your Success! Visit http://opensdi.geo-solutions.it for more > information. > == > > Ing. Andrea Aime > @geowolf > Technical Lead > > GeoSolutions S.A.S. > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > phone: +39 0584 962313 > fax: +39 0584 1660272 > mob: +39 339 8844549 > > http://www.geo-solutions.it > http://twitter.com/geosolutions_it > > -------------------------------------------------------
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Free Next-Gen Firewall Hardware Offer Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more. http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
