Dear all, I coded a web service with psycopg. I have already imported one 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 and z of the DEM). => So Regarding my script, i writed 2 (one for each layer) 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. But the result of my script when i execute it : "bad request". Please find below the script : web_service_test.py <http://postgis.17.x6.nabble.com/file/n5006541/web_service_test.py> Could tou throw light for me? Thanks. -- View this message in context: http://postgis.17.x6.nabble.com/Psycopg2-bad-request-tp5006541.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
