Hi,
I've got a new GSIP ready for discussion here, this time to
allow people defining new layers by a raw SQL query against
a database, plus eventual custom parameters whose value can
be specified in the GetMap request:
http://geoserver.org/display/GEOS/GSIP+48+-+Parametric+SQL+views+in+GeoServer
Feedback and opinions welcomed!
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
Nicely done: I lost track of the proposal when it jumped to "internal changes"; picked up the story again later. The idea itself seems nice and solid.
The WMS specification does provide an option for some parameters already; and better yet offers a description of the range of the parameters.
I know it is only an option for WMS but the wms dimension / extent may also be candidates for the env parameter. Not sure if your customer would be interested? Or if they already know the range and values allowed for the parameters.
Jody
On 23/06/2010, at 5:16 PM, Andrea Aime wrote:
Hi,
I've got a new GSIP ready for discussion here, this time to
allow people defining new layers by a raw SQL query against
a database, plus eventual custom parameters whose value can
be specified in the GetMap request:http://geoserver.org/display/GEOS/GSIP+48+-+Parametric+SQL+views+in+GeoServer
Feedback and opinions welcomed!
Cheers
Andrea--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
And before I forget: +1
Jody
On 23/06/2010, at 5:42 PM, Jody Garnett wrote:
Nicely done: I lost track of the proposal when it jumped to "internal changes"; picked up the story again later. The idea itself seems nice and solid.
The WMS specification does provide an option for some parameters already; and better yet offers a description of the range of the parameters.
I know it is only an option for WMS but the wms dimension / extent may also be candidates for the env parameter. Not sure if your customer would be interested? Or if they already know the range and values allowed for the parameters.Jody
On 23/06/2010, at 5:16 PM, Andrea Aime wrote:
Hi,
I've got a new GSIP ready for discussion here, this time to
allow people defining new layers by a raw SQL query against
a database, plus eventual custom parameters whose value can
be specified in the GetMap request:http://geoserver.org/display/GEOS/GSIP+48+-+Parametric+SQL+views+in+GeoServer
Feedback and opinions welcomed!
Cheers
Andrea--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
Jody Garnett ha scritto:
Nicely done: I lost track of the proposal when it jumped to "internal
changes"; picked up the story again later. The idea itself seems
nice and solid.The WMS specification does provide an option for some parameters
already; and better yet offers a description of the range of the
parameters. I know it is only an option for WMS but the wms dimension
/ extent may also be candidates for the env parameter. Not sure if
your customer would be interested? Or if they already know the range
and values allowed for the parameters.
dimension and extent are 100% out of scope
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
Hi Andrea,
It seems like a great and very useful add on for Geoserver! Will the RESTful
interface be extended to support this kind of feature type configuration?
Cheers,
Pedro Mendes
-----Mensagem original-----
De: Andrea Aime [mailto:aaime@anonymised.com]
Enviada: quarta-feira, 23 de Junho de 2010 08:17
Para: Geoserver-devel
Assunto: [Geoserver-devel] New GSIP: configuring a new feature type as a
parametrized sql queryHi,
I've got a new GSIP ready for discussion here, this time to
allow people defining new layers by a raw SQL query against
a database, plus eventual custom parameters whose value can
be specified in the GetMap request:http://geoserver.org/display/GEOS/GSIP+48+-
+Parametric+SQL+views+in+GeoServerFeedback and opinions welcomed!
Cheers
Andrea--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
----------------------------------------------------------------------------
--
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
Pedro Mendes ha scritto:
Hi Andrea,
It seems like a great and very useful add on for Geoserver! Will the RESTful
interface be extended to support this kind of feature type configuration?
As far as I know there will be no need, you'll just have to post
the definition of the new feature type including the virtual table
definition among the metadata map values (see the featureTypeInfo.xml
sample)
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
Andrea Aime ha scritto:
Hi,
I've got a new GSIP ready for discussion here, this time to
allow people defining new layers by a raw SQL query against
a database, plus eventual custom parameters whose value can
be specified in the GetMap request:http://geoserver.org/display/GEOS/GSIP+48+-+Parametric+SQL+views+in+GeoServer
Feedback and opinions welcomed!
Just got some feedback from the sponsor, updated a couple of bits:
- they don't want the same param to be used for sld and view substitution, so I'm now suggesting to use a separate view_params
parameter specifically for sql views
- the example shows replacement with full sql constructs instead
of just a string/value parameter
Minor changes, the substance is still the same
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.