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
-------------------------------------------------------
------------------------------------------------------------------------------
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
