From: | lcelati(at)latitude-geosystems(dot)com |
---|---|
To: | psycopg(at)postgresql(dot)org |
Subject: | psycopg : web service |
Date: | 2014-05-20 15:36:27 |
Message-ID: | 20140520173627.07hlxpazqcwgcwcc@webmail.latitude-geosystems.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | psycopg |
Dear all,
I would like code a web service with python. I have already imported
several vector data (land cover) and one Digital Elevation Model
(raster layer) into my postgresql/postgis database (server side).
I succeed in connecting to my pg db via psycopg2.
Client side, operators use a client application (Developed with PHP /
javascript / openlayers).
Objectives : Client side, once the layer would be selected,and once
the operators have clicked on the map , they would like that usefull
informations appear on the interface of the client application(kind of
land cover, z of the DEM).
=> Regarding my python script, i have to type a SQL query in order to
select usefull informations of the db layers. And, of course, the
information must depend on geographic coordinates (Latitude
Y/Longitute X).
In a 2nd time, my script must produce a result(JSon type) for the
client side.
It would be possible to help me regarding the coding in order to
select usefull informations of the db layers. (depends on geographic
coordinates x/y ? Could you throw light for me regarding the way to
do this SQL query ?
In advance, thank you to throw light for me.
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Mildebrandt | 2014-05-20 15:49:40 | Re: GNU GPL license in some of the source files |
Previous Message | Daniele Varrazzo | 2014-05-20 15:01:51 | Re: GNU GPL license in some of the source files |