I'm using a spatialite database in a PHP program and I need to simulate an "identify" on a polygon layer (EPSG 32632), using point whose coordinates are dinamically generated.

I know that this query works fine ...

select NAME from poly32632 where within(GeomFromText('POINT(837121 5087604)'),poly32632.Geometry);

My problem is that my points coordinates are originally in EPSG 4326 system coordinates so, I've to project them in EPSG 32632 before to use them in my select.

I don't use Javascript in my program, so I can't use something like PROJ4JS to do it: is it possible to convert my coordinates couple directly in EPSG 32632 in my Spatialite query construction? Alternative queries in Spatialite to obtain the same result?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.