[Geoserver-users] Create a postgis parametric sql view via REST

GeoServer GeoServer User
1

Dear list,
I didn’t found, in the official documentation, how to create a parametric sql view layer via rest. It’s possible do this? Where can find some examples or some documentations about this!
thanks so much.

Luigi Marotta
IT Specialist - Ariespace s.r.l - Spin off Company
Università degli Studi di Napoli “Federico II”
Centro Direzionale IS. A3
80143 - Napoli - Italy
tel.: (+39) 08119564282
fax: (+39) 08119564223
mob.: (+39) 3478836273
skypecontact: live:luigi.marotta

PRIVACY
Le informazioni contenute in questo messaggio sono riservate e confidenziali. Il loro utilizzo e’ consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo dal Suo Sistema ed a distruggere le varie copie o stampe, dandocene gentilmente comunicazione. Ogni utilizzo improprio e’ contrario ai principi del D.lgs 196/03 e alla legislazione europea (Direttiva 2002/58/CE).

The information in this e-mail is intended for the named recipients only. It may contain privileged and confidential information. If you have received this communication in error, any use, copying or dissemination of its contents is strictly prohibited. Please erase all copies of the message along with any included attachments and notify the sender immediately.

2

In my experience:

  1. Create one via the UI and get it working.

  2. Dump the featureType as JSON or XML via the REST API

  3. Edit it and post it back to create a a new featureType

  4. Keep tweaking until it works how you want :slight_smile:

Note that if you’re using JSON you may have to order keys in some of the objects due to http://jira.codehaus.org/browse/GEOS-4986 - specifically the “virtualTable” object and any objects within it (“geometry” & “parameter” objects). In Python >= 2.7 the collections.OrderedDict class will help, in <=2.6 use simplejson.OrderedDict. Other languages I presume you can figure out something similar :slight_smile:

HTH,

Rob :slight_smile:

···

On Fri, Aug 8, 2014 at 2:54 AM, Luigi Marotta <luigi.marotta@anonymised.com> wrote:

Dear list,
I didn’t found, in the official documentation, how to create a parametric sql view layer via rest. It’s possible do this? Where can find some examples or some documentations about this!
thanks so much.

Luigi Marotta
IT Specialist - Ariespace s.r.l - Spin off Company
Università degli Studi di Napoli “Federico II”
Centro Direzionale IS. A3
80143 - Napoli - Italy
tel.: (+39) 08119564282
fax: (+39) 08119564223
mob.: (+39) 3478836273
skypecontact: live:luigi.marotta

PRIVACY
Le informazioni contenute in questo messaggio sono riservate e confidenziali. Il loro utilizzo e’ consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo dal Suo Sistema ed a distruggere le varie copie o stampe, dandocene gentilmente comunicazione. Ogni utilizzo improprio e’ contrario ai principi del D.lgs 196/03 e alla legislazione europea (Direttiva 2002/58/CE).

The information in this e-mail is intended for the named recipients only. It may contain privileged and confidential information. If you have received this communication in error, any use, copying or dissemination of its contents is strictly prohibited. Please erase all copies of the message along with any included attachments and notify the sender immediately.

Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

Koordinates
PO Box 1604, Shortland St, Auckland 1140, New Zealand
Phone +64-9-966 0433 koordinates.com

3

Thanks Rob.
I used, exactly, this approach, using xml via curl, and it works fine. But do you know if there’s an official documentation about this functionality?
This tryal approach is too alchemical!

···

Luigi Marotta
IT Specialist - Ariespace s.r.l - Spin off Company
Università degli Studi di Napoli “Federico II”
Centro Direzionale IS. A3
80143 - Napoli - Italy
tel.: (+39) 08119564282
fax: (+39) 08119564223
mob.: (+39) 3478836273
skypecontact: live:luigi.marotta

PRIVACY
Le informazioni contenute in questo messaggio sono riservate e confidenziali. Il loro utilizzo e’ consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo dal Suo Sistema ed a distruggere le varie copie o stampe, dandocene gentilmente comunicazione. Ogni utilizzo improprio e’ contrario ai principi del D.lgs 196/03 e alla legislazione europea (Direttiva 2002/58/CE).

The information in this e-mail is intended for the named recipients only. It may contain privileged and confidential information. If you have received this communication in error, any use, copying or dissemination of its contents is strictly prohibited. Please erase all copies of the message along with any included attachments and notify the sender immediately.

2014-08-08 1:54 GMT+02:00 Robert Coup <robert.coup@anonymised.com>:

In my experience:

  1. Create one via the UI and get it working.

  2. Dump the featureType as JSON or XML via the REST API

  3. Edit it and post it back to create a a new featureType

  4. Keep tweaking until it works how you want :slight_smile:

Note that if you’re using JSON you may have to order keys in some of the objects due to http://jira.codehaus.org/browse/GEOS-4986 - specifically the “virtualTable” object and any objects within it (“geometry” & “parameter” objects). In Python >= 2.7 the collections.OrderedDict class will help, in <=2.6 use simplejson.OrderedDict. Other languages I presume you can figure out something similar :slight_smile:

HTH,

Rob :slight_smile:

On Fri, Aug 8, 2014 at 2:54 AM, Luigi Marotta <luigi.marotta@anonymised.com> wrote:

Dear list,
I didn’t found, in the official documentation, how to create a parametric sql view layer via rest. It’s possible do this? Where can find some examples or some documentations about this!
thanks so much.

Luigi Marotta
IT Specialist - Ariespace s.r.l - Spin off Company
Università degli Studi di Napoli “Federico II”
Centro Direzionale IS. A3
80143 - Napoli - Italy
tel.: (+39) 08119564282
fax: (+39) 08119564223
mob.: (+39) 3478836273
skypecontact: live:luigi.marotta

PRIVACY
Le informazioni contenute in questo messaggio sono riservate e confidenziali. Il loro utilizzo e’ consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo dal Suo Sistema ed a distruggere le varie copie o stampe, dandocene gentilmente comunicazione. Ogni utilizzo improprio e’ contrario ai principi del D.lgs 196/03 e alla legislazione europea (Direttiva 2002/58/CE).

The information in this e-mail is intended for the named recipients only. It may contain privileged and confidential information. If you have received this communication in error, any use, copying or dissemination of its contents is strictly prohibited. Please erase all copies of the message along with any included attachments and notify the sender immediately.

Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

Koordinates
PO Box 1604, Shortland St, Auckland 1140, New Zealand
Phone +64-9-966 0433 koordinates.com

4

On Fri, Aug 8, 2014 at 11:26 AM, Luigi Marotta <luigi.marotta@anonymised.com>
wrote:

Thanks Rob.
                  I used, exactly, this approach, using xml via curl, and
it works fine. But do you know if there's an official documentation about
this functionality?
     This tryal approach is too alchemical!

There are no docs for it, and the trial approach is how the REST API is
supposed to be used.
More docs are always welcomed, since you figured out how it works, you
could contribute
some examples yourself, just fork the project on github, add the docs, and
make a pull
request.
We also have a guide on how to write docs here:
http://docs.geoserver.org/latest/en/docguide/

The project grows better/faster when everybody lends a hand :slight_smile:

Cheers
Andrea

--

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 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

-------------------------------------------------------

5

Thank you, Andrea, good idea!

···

Luigi Marotta
IT Specialist - Ariespace s.r.l - Spin off Company
Università degli Studi di Napoli “Federico II”
Centro Direzionale IS. A3
80143 - Napoli - Italy
tel.: (+39) 08119564282
fax: (+39) 08119564223
mob.: (+39) 3478836273
skypecontact: live:luigi.marotta

PRIVACY
Le informazioni contenute in questo messaggio sono riservate e confidenziali. Il loro utilizzo e’ consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo dal Suo Sistema ed a distruggere le varie copie o stampe, dandocene gentilmente comunicazione. Ogni utilizzo improprio e’ contrario ai principi del D.lgs 196/03 e alla legislazione europea (Direttiva 2002/58/CE).

The information in this e-mail is intended for the named recipients only. It may contain privileged and confidential information. If you have received this communication in error, any use, copying or dissemination of its contents is strictly prohibited. Please erase all copies of the message along with any included attachments and notify the sender immediately.

2014-08-08 11:40 GMT+02:00 Andrea Aime <andrea.aime@anonymised.com>:

On Fri, Aug 8, 2014 at 11:26 AM, Luigi Marotta <luigi.marotta@anonymised.com> wrote:

Thanks Rob.
I used, exactly, this approach, using xml via curl, and it works fine. But do you know if there’s an official documentation about this functionality?
This tryal approach is too alchemical!

There are no docs for it, and the trial approach is how the REST API is supposed to be used.
More docs are always welcomed, since you figured out how it works, you could contribute
some examples yourself, just fork the project on github, add the docs, and make a pull
request.
We also have a guide on how to write docs here:
http://docs.geoserver.org/latest/en/docguide/

The project grows better/faster when everybody lends a hand :slight_smile:

Cheers
Andrea

–

==

GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 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