[GeoNode-devel] RV: [GeoNode-users] Advanced Styling

David Alda Fernandez de Lezea dalda at hazi.eus
Tue Sep 6 01:06:46 PDT 2016


Hi,

I'm resending this email to the developers list as I think it might be more suitable.  I need to have a script in GeoNode to make a query to the PostGIS DB to get some values so I've began the functionality under the geonode directory structure and following the DJANGO documentation. So far I've made something like this:

-geonode

├── hazi
│   ├── __init__.py
│   ├── models.py
│   ├── urls.py
│   └── views.py

This is the views.py content

	from django.shortcuts import render_to_response
	from django.http import HttpResponse
	from models import DBAtribDistinctValues

	def distinctValues(request):
   		db = PostGisdb.connect(user=DATABASE_USER, db=DATABASE_NAME, passwd=DATABASE_PASSWORD, host=DATABASE_HOST)
   		 cursor = db.cursor()
   		 cursor.execute('SELECT distinct() FROM books ORDER BY name')
   		 names = [row[0] for row in cursor.fetchall()]
   		 db.close()
   		 return render_to_response('book_list.html', {'names': names})

	def hello():
		return HttpResponse( "<html><body>Hello</body></html>")

This is the urls.py content

	from django.conf.urls import url, patterns
	from geonode.hazi import views

	urlpatterns = patterns('geonode.hazi.views',
  		  url(r'^distinctValues', 'distinctValues', name='distinctValues'),
    		url(r'^hello', 'hello',name='hello'),
	)
	
And finally de models.py

	from django.contrib.gis.db import models

	class DBAtribDistinctValues(models.Model):
    		distinctValues = models.CharField(max_length=150000, blank=True, null=True)

I've also added to the settings.py the module to the GEONODE_APPS array.

So far don't get any response of neither functions. I can't even get the "hello" when I visit \\myip\hazi\hello

I know this is a newbie question but I've no idea about Django programming. I've looking into google but without success.

What I'm doing wrong? Any ideas?

Thanks in advance.

Regards.

Agur bero bat,


David Alda Fernández de Lezea
Área de Sistemas de Información Geográfica, Planificación Territorial y Forestal Informazio Geografikoen Sistemak, Lurralde eta Baso Antolaketaren Arloa.
dalda at hazi.eus | www.hazi.eus
T 945 003 240 – M 627 923 170 – F 945 003 290 
Hazi | Granja Modelo de Arkaute s/n | 01192 Arkaute – Araba
 
*********************  LEGE OHARRA   *******************   AVISOLEGAL   *******************   DISCLAIMER   *****************************
Mezu hau pertsonala eta isilpekoa da eta baimenik gabeko erabilera debekatua dago legalki. Jasotzailea ez bazara ezabatu mezua, bidali eta kontserbatu gabe.
Este mensaje es personal y confidencial y su uso no autorizado está prohibido legalmente. Si usted no es el destinatario, proceda a borrarlo, sin reenviarlo ni conservarlo.
This message is personal and confidential, unauthorised use is legally prohibited. If you are not the intended recipient, delete it without resending or backing it.

-----Mensaje original-----
De: geonode-users [mailto:geonode-users-bounces at lists.osgeo.org] En nombre de David Alda Fernandez de Lezea
Enviado el: viernes, 02 de septiembre de 2016 14:44
Para: Paolo Corti
CC: geonode-users at lists.osgeo.org
Asunto: Re: [GeoNode-users] Advanced Styling

Hi again,

I'm taking up this task again and so far I've managed to identify, from the geoexplorer, the layer a its datastore with db information, but now I'd like to make a query to the table stored in the POSTGIS db but I've got no clue how or  where do I have to start coding because I'm a completely newbie in Django. My idea is pretty simple, I'd like to add callable function in which I query the db and return the information to the geoexplorer.

Can anyone point me to the right files to edit?

Thanks in advance.

Regards,

Agur bero bat,


David Alda Fernández de Lezea
Área de Sistemas de Información Geográfica, Planificación Territorial y Forestal Informazio Geografikoen Sistemak, Lurralde eta Baso Antolaketaren Arloa.
dalda at hazi.eus | www.hazi.eus
T 945 003 240 – M 627 923 170 – F 945 003 290 Hazi | Granja Modelo de Arkaute s/n | 01192 Arkaute – Araba
 
*********************  LEGE OHARRA   *******************   AVISOLEGAL   *******************   DISCLAIMER   ***************************** Mezu hau pertsonala eta isilpekoa da eta baimenik gabeko erabilera debekatua dago legalki. Jasotzailea ez bazara ezabatu mezua, bidali eta kontserbatu gabe.
Este mensaje es personal y confidencial y su uso no autorizado está prohibido legalmente. Si usted no es el destinatario, proceda a borrarlo, sin reenviarlo ni conservarlo.
This message is personal and confidential, unauthorised use is legally prohibited. If you are not the intended recipient, delete it without resending or backing it.


-----Mensaje original-----
De: Paolo Corti [mailto:pcorti at gmail.com] Enviado el: martes, 19 de julio de 2016 15:14
Para: David Alda Fernandez de Lezea
CC: geonode-users at lists.osgeo.org
Asunto: Re: [GeoNode-users] Advanced Styling

Hi David
surely you can do that!
GeoExplorer makes just OGC and GeoServer REST API calls, but you can add a GeoNode API to the mix The GeoExplorer version forked for GeoNode already makes some calls to GeoNode, to check permissions for a layer for example. You can use same approach.
have a nice day
p

On Tue, Jul 19, 2016 at 5:23 AM, David Alda Fernandez de Lezea <dalda at hazi.eus> wrote:
> Hi Paolo,
>
> Thanks for your response. Yes it's something that could be really interesting. From my point of view, unless I'm wrong, this functionality could be available/usable for all the layers stored in the "geonode" database, as they are the only layers that can be styled (WMS cascaded layers, which are foreign, layers can't), it would be possible to make query to the DB via python function, for example?
>
> Thanks.
>
> Regards.
>
> Agur bero bat,
>
>
> David Alda Fernández de Lezea
> Área de Sistemas de Información Geográfica, Planificación Territorial y Forestal Informazio Geografikoen Sistemak, Lurralde eta Baso Antolaketaren Arloa.
> dalda at hazi.eus | www.hazi.eus
> T 945 003 240 – M 627 923 170 – F 945 003 290 Hazi | Granja Modelo de 
> Arkaute s/n | 01192 Arkaute – Araba
>
> *********************  LEGE OHARRA   *******************   AVISOLEGAL   *******************   DISCLAIMER   *****************************
> Mezu hau pertsonala eta isilpekoa da eta baimenik gabeko erabilera debekatua dago legalki. Jasotzailea ez bazara ezabatu mezua, bidali eta kontserbatu gabe.
> Este mensaje es personal y confidencial y su uso no autorizado está prohibido legalmente. Si usted no es el destinatario, proceda a borrarlo, sin reenviarlo ni conservarlo.
> This message is personal and confidential, unauthorised use is legally prohibited. If you are not the intended recipient, delete it without resending or backing it.
>
>
> -----Mensaje original-----
> De: Paolo Corti [mailto:pcorti at gmail.com] Enviado el: lunes, 18 de 
> julio de 2016 16:20
> Para: David Alda Fernandez de Lezea
> CC: geonode-users at lists.osgeo.org
> Asunto: Re: [GeoNode-users] Advanced Styling
>
> It would be an interesting feature but I don't think there is any 
> other way than reading all the field values with a WFS request and 
> then compose the distinct values list on the client. Therefore it can 
> be overwhelming for large datasets p
>
> On Mon, Jul 18, 2016 at 7:55 AM, David Alda Fernandez de Lezea <dalda at hazi.eus> wrote:
>> Hi list,
>>
>> I'm looking for some custom functionalities on GeoNode and I'm thinking of allowing the "gxp_styler" to read the distinct values that has the selected attribute field that the user specifies to classify. I don't know if anyone else has tried or even completed this task.
>>
>> In case not, I think it would be a good idea to include this in following versions of GeoNode.
>>
>> Thanks in advance.
>>
>> Regards,
>>
>> Agur bero bat,
>>
>>
>> David Alda Fernández de Lezea
>> Área de Sistemas de Información Geográfica, Planificación Territorial y Forestal Informazio Geografikoen Sistemak, Lurralde eta Baso Antolaketaren Arloa.
>> dalda at hazi.eus | www.hazi.eus
>> T 945 003 240 - M 627 923 170 - F 945 003 290 Hazi | Granja Modelo de 
>> Arkaute s/n | 01192 Arkaute - Araba
>>
>> *********************  LEGE OHARRA   *******************   AVISOLEGAL   *******************   DISCLAIMER   *****************************
>> Mezu hau pertsonala eta isilpekoa da eta baimenik gabeko erabilera debekatua dago legalki. Jasotzailea ez bazara ezabatu mezua, bidali eta kontserbatu gabe.
>> Este mensaje es personal y confidencial y su uso no autorizado está prohibido legalmente. Si usted no es el destinatario, proceda a borrarlo, sin reenviarlo ni conservarlo.
>> This message is personal and confidential, unauthorised use is legally prohibited. If you are not the intended recipient, delete it without resending or backing it.
>>
>> _______________________________________________
>> geonode-users mailing list
>> geonode-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/geonode-users
>
>
>
> --
> Paolo Corti
> Geospatial software developer
> web: http://www.paolocorti.net
> twitter: @capooti
> skype: capooti



--
Paolo Corti
Geospatial software developer
web: http://www.paolocorti.net
twitter: @capooti
skype: capooti
_______________________________________________
geonode-users mailing list
geonode-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/geonode-users


More information about the geonode-devel mailing list