How can I convert EPSG4326 point to UTM in spatialite?
X(TRANSFORM(Geometry, 32639)) as X always returns NULL. What's the proper way of extracting northing and easting from geometry type 4326?
You've not given a reproducible example, but here's one:
spatialite> select X(transform(GeomFromText("POINT (0 0)",27700),4326)); X(transform(GeomFromText("POINT (0 0)",27700),4326)) -7.55715980520632
The X coordinate of (0,0) in epsg:27700 is -7.55 degrees in epsg:4326.
And here it is in
spatialite-gui (version 2.0.0):
if this fails for you, then there's something wrong or just different with your Spatialite installation.
I'm not sure what your
"SRID=..." line is suppose to be. Is that some text in a geometry column? I've constructed a geometry from a string in WKT format with the SRID passed to the