[GeoNode-users] GeoNode and ETL

Wed Oct 2 09:03:48 PDT 2019

Dear Magnus,
please, read below...

Regards,
Simone Giannecchini
==
GeoServer Professional Services from the experts!
Visit http://bit.ly/gs-services for more information.
==
Ing. Simone Giannecchini
@simogeo
Founder/Director

GeoSolutions S.A.S.
Via di Montramito 3/A
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax:     +39 0584 1660272
mob:   +39  333 8128928

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------
Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE
2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si
precisa che ogni circostanza inerente alla presente email (il suo
contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è
riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il
messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra
operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is
addressed and may contain information that is privileged, confidential or
otherwise protected from disclosure. We remind that - as provided by
European Regulation 2016/679 “GDPR” - copying, dissemination or use of this
e-mail or the information herein by anyone other than the intended
recipient is prohibited. If you have received this email by mistake, please
notify us immediately by telephone or e-mail.

On Wed, Oct 2, 2019 at 11:56 AM Magnus Nilsson <johnrobot at gmail.com> wrote:

> Hi Simone
> Thanks for your reply. In our case, I think it would be a priority to have
> support for a workflow where we can use FME (or perhaps a QGIS processing
> model writing to PostGIS, somewhere down the road) to add data to the
> database used by GeoNode.
>

Adding data to a database table published in GeoNode is doable already.
What is missing is the ability to register an existing table directly
rathen than having to through the shapefile upload.
I believe there was work done in WorldMap (a downstream project) to create
tables directly from GeoNode but this would be a GUI process anyway.

> I have not really used GeoNode, beyond the demo at
> http://master.demo.geonode.org/, so I don´t know how to call the
> updateLayers command, but I´m sure I can find some documentation on that.
> Should that command also be used when overwriting an existing table, when
> updating the data (again, using FME)?
>

Once you create a layer in GeoServer.

> Perhaps GeoNode could automatically detect new/updated tables in the
> database and ask the admin to configure them in GeoNode?
>

This would need to be implemented but I would rather go towards and
approach when "something" tells GeoNode that a certain layer has been
updated.

>
> Magnus
>
> On Tue, Oct 1, 2019 at 7:42 PM Simone Giannecchini <
> simone.giannecchini at geo-solutions.it> wrote:
>
>> Hi Magnus,
>> please, read below...
>>
>> Regards,
>> Simone Giannecchini
>> ==
>> GeoServer Professional Services from the experts!
>> Visit http://bit.ly/gs-services for more information.
>> ==
>> Ing. Simone Giannecchini
>> @simogeo
>> Founder/Director
>>
>> GeoSolutions S.A.S.
>> Via di Montramito 3/A
>> 55054  Massarosa (LU)
>> Italy
>> phone: +39 0584 962313
>> fax:     +39 0584 1660272
>> mob:   +39  333 8128928
>>
>> http://www.geo-solutions.it
>> http://twitter.com/geosolutions_it
>>
>> -------------------------------------------------------
>> Con riferimento alla normativa sul trattamento dei dati personali (Reg.
>> UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si
>> precisa che ogni circostanza inerente alla presente email (il suo
>> contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è
>> riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il
>> messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra
>> operazione è illecita. Le sarei comunque grato se potesse darmene notizia.
>>
>> This email is intended only for the person or entity to which it is
>> addressed and may contain information that is privileged, confidential or
>> otherwise protected from disclosure. We remind that - as provided by
>> European Regulation 2016/679 “GDPR” - copying, dissemination or use of this
>> e-mail or the information herein by anyone other than the intended
>> recipient is prohibited. If you have received this email by mistake, please
>> notify us immediately by telephone or e-mail.
>>
>>
>> On Tue, Oct 1, 2019 at 1:14 PM Magnus Nilsson <johnrobot at gmail.com>
>> wrote:
>>
>>> Hi
>>>
>>> I have a few questions about GeoNode:
>>>
>>>
>>>
>>> - Is it possible to expose the metadata using DCAT-AP? It seems to be
>>> the standard used by https://oppnadata.se/, which is where I want our
>>> geodata to be displayed.
>>>
>>
>> I don't think this is supported out of the box; I believe, it would
>> require some development both in terms of supporting the additional
>> elements in the model as well as in terms of outputting them.
>>
>>
>>>
>>> - We use FME, https://www.safe.com/, a lot for geodata ETL tasks. Can I
>>> register data sets in GeoNode without uploading any data via the web
>>> interface and instead point it to the correct PostGIS table? I would like
>>> to use FME to write data to PostGIS and then configure GeoNode to discover
>>> the new PostGIS table and display its content to our users. Having to
>>> convert to SHP and upload that seems like a step backwards.
>>>
>>
>>  One way to achieve that is to register them in GeoServer and then call
>> the updateLayers command; in any case, I believe we would need to make sure
>> we do not loose any of the standard GeoNode functionalities.
>>
>>
>>> Regards,
>>>
>>>
>>> Magnus
>>> _______________________________________________
>>> geonode-users mailing list
>>> geonode-users at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/geonode-users
>>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20191002/bbd696b6/attachment-0001.html>