[GeoNode-devel] Create Layer Functionality

[Paolo Corti]

The code Jeff is mentioning is working very well for us, though it
will require some improvement and an user interface - so far it is
just an API.

What it does:
* create a layer from a table join
* create a layer from a CSV

I was planning to refine it at some point and send a PR to GeoNode
2.4, but not sure when I will have some time to work with this.

Regarding Dimitris question - the implementation of a Create Layer
feature: at WorldMap there is already such a feature and it is working
very well since years. But it has been developed in a forked version
of GeoNode 1.2 so it will require some work to adapt it to 2.4. It is
anyway an excellent starting point for you I believe.
Source code is here:
https://github.com/cga-harvard/cga-worldmap/blob/legacy/geonode/maps/views.py#L2686

By the way, we are in the process to migrate everything to GeoNode
2.4. This will requires months (maybe we will be ready at the end of
2016), but at that point we should have the Create Layer feature in
GeoNode 2.4. Maybe as part of the table join/CSV application, or as a
core feature of GeoNode - we need to discuss this with other
developers.
Dmitiris if you guys are faster than me with this you are very welcome
and will pay you a beer when I am in Rome :)

cheers
p

On Mon, Jun 6, 2016 at 11:28 AM, Jeffrey Johnson <ortelius at gmail.com> wrote:
> Excellent. Paolo where are you at with this code now?
>
> On Sun, Jun 5, 2016 at 12:18 PM, Dimitris Karakostis
> <karakostis.dimitris at gmail.com> wrote:
>>
>> Hello Jeffrey,
>>
>> Thank you very much for your answer. I checked carefully your project and
>> the GNIP. The use case is a bit different but in general I was thinking of
>> following a similar logic for implementing this functionality.
>>
>> Thanks.
>> Dimitris
>>
>> On Thu, Jun 2, 2016 at 7:59 PM, Jeffrey Johnson <ortelius at gmail.com> wrote:
>>>
>>> Dimitris, I would recommend you check out the branch [1] that I worked
>>> on that works with CSVs and joins. It still needs some work, but I
>>> believe that Paolo from the Worldmap team was planning to work on it
>>> himself also. There is also a GNIP [2] for this, but your use case
>>> does sound a bit different.
>>>
>>> [1]
>>> https://github.com/jj0hns0n/geonode/tree/table-join/geonode/contrib/datatables
>>> [2] https://github.com/GeoNode/geonode/issues/1915
>>>
>>> On Thu, Jun 2, 2016 at 1:32 AM, Dimitris Karakostis
>>> <karakostis.dimitris at gmail.com> wrote:
>>> >
>>> > Hello all,
>>> >
>>> > I would like to open the discussion regarding the development of a
>>> > Create
>>> > Layer functionality, which will give the possibility to users to create
>>> > and
>>> > upload layers in various ways.
>>> >
>>> > Currently I am working on a specific approach in which the user is able
>>> > to
>>> > download a global layer (e.g. country boundaries) as a CSV (without
>>> > including the geometry). Opening the CSV in
>>> > excel etc., he/she can add new columns or change fields. After applying
>>> > the
>>> > changes, upload it and create a new layer by applying a join with the
>>> > existing global layer.
>>> >
>>> > The 'upload' part of the process requires a series of actions to be
>>> > made. 1)
>>> > Update the django database with the new layer, 2) Create a new table
>>> > with
>>> > the new layer in the uploads database 3) Create corresponding
>>> > layer in geoserver etc.
>>> >
>>> > I searched for open issues regarding this but I didn't find something
>>> > going
>>> > towards this direction. Have someone tried to do something like this in
>>> > the
>>> > past? What approach would you suggest in regards with the syncing of the
>>> > different parts (django DB, geoserver, uploads DB).
>>> >
>>> > Cheers
>>> > Dimitris
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > _______________________________________________
>>> > geonode-devel mailing list
>>> > geonode-devel at lists.osgeo.org
>>> > http://lists.osgeo.org/mailman/listinfo/geonode-devel
>>> >
>>
>>



-- 
Paolo Corti
Geospatial software developer
web: http://www.paolocorti.net
twitter: @capooti
skype: capooti