[postgis-users] psycopg : web service

[dandrigo]

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 (postgresql 's python api)

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.



--
View this message in context: http://postgis.17.x6.nabble.com/psycopg-web-service-tp5006366.html
Sent from the PostGIS - User mailing list archive at Nabble.com.