D 2020-08-19T09:38:58.373
J foundin 5.0.0-RC1
J icomment Spatialite\s5.0.0-RC1\sdoes\snot\sseem\sto\srespect\saxis\sorder\salthough\sit\sis\ssupposed\sto\sbe\susing\sPROJ\s6\s(or\slater),\ssee\sdetails\sbelow.\r\n\r\nTo\sget\sthe\sWKT\sof\sthe\scoordinate\sreference\ssystems:\r\n\r\nC:\\ProgramData\\Microsoft\\Windows\\Start\sMenu\\Programs\\OSGeo4W>chcp\s65001\r\nActive\scode\spage:\s65001\r\n\r\nC:\\ProgramData\\Microsoft\\Windows\\Start\sMenu\\Programs\\OSGeo4W>projinfo\s-o\sWKT2:2019\s--single-line\sEPSG:25832\r\nWKT2:2019\sstring:\r\nPROJCRS["ETRS89\s/\sUTM\szone\s32N",BASEGEOGCRS["ETRS89",DATUM["European\sTerrestrial\sReference\sSystem\s1989",ELLIPSOID["GRS\s1980",6378137,298.257222101,LENGTHUNIT["metre",1]]],PRIMEM["Greenwich",0,ANGLEUNIT["degree",0.0174532925199433]],ID["EPSG",4258]],CONVERSION["UTM\szone\s32N",METHOD["Transverse\sMercator",ID["EPSG",9807]],PARAMETER["Latitude\sof\snatural\sorigin",0,ANGLEUNIT["degree",0.0174532925199433],ID["EPSG",8801]],PARAMETER["Longitude\sof\snatural\sorigin",9,ANGLEUNIT["degree",0.0174532925199433],ID["EPSG",8802]],PARAMETER["Scale\sfactor\sat\snatural\sorigin",0.9996,SCALEUNIT["unity",1],ID["EPSG",8805]],PARAMETER["False\seasting",500000,LENGTHUNIT["metre",1],ID["EPSG",8806]],PARAMETER["False\snorthing",0,LENGTHUNIT["metre",1],ID["EPSG",8807]]],CS[Cartesian,2],AXIS["(E)",east,ORDER[1],LENGTHUNIT["metre",1]],AXIS["(N)",north,ORDER[2],LENGTHUNIT["metre",1]],USAGE[SCOPE["unknown"],AREA["Europe\s-\s6°E\sto\s12°E\sand\sETRS89\sby\scountry"],BBOX[38.76,6,83.92,12]],ID["EPSG",25832]]\r\n\r\nC:\\ProgramData\\Microsoft\\Windows\\Start\sMenu\\Programs\\OSGeo4W>projinfo\s-o\sWKT2:2019\s--single-line\sEPSG:3044\r\nWKT2:2019\sstring:\r\nPROJCRS["ETRS89\s/\sUTM\szone\s32N\s(N-E)",BASEGEOGCRS["ETRS89",DATUM["European\sTerrestrial\sReference\sSystem\s1989",ELLIPSOID["GRS\s1980",6378137,298.257222101,LENGTHUNIT["metre",1]]],PRIMEM["Greenwich",0,ANGLEUNIT["degree",0.0174532925199433]],ID["EPSG",4258]],CONVERSION["UTM\szone\s32N",METHOD["Transverse\sMercator",ID["EPSG",9807]],PARAMETER["Latitude\sof\snatural\sorigin",0,ANGLEUNIT["degree",0.0174532925199433],ID["EPSG",8801]],PARAMETER["Longitude\sof\snatural\sorigin",9,ANGLEUNIT["degree",0.0174532925199433],ID["EPSG",8802]],PARAMETER["Scale\sfactor\sat\snatural\sorigin",0.9996,SCALEUNIT["unity",1],ID["EPSG",8805]],PARAMETER["False\seasting",500000,LENGTHUNIT["metre",1],ID["EPSG",8806]],PARAMETER["False\snorthing",0,LENGTHUNIT["metre",1],ID["EPSG",8807]]],CS[Cartesian,2],AXIS["northing\s(N)",north,ORDER[1],LENGTHUNIT["metre",1]],AXIS["easting\s(E)",east,ORDER[2],LENGTHUNIT["metre",1]],USAGE[SCOPE["unknown"],AREA["Europe\s-\s6°E\sto\s12°E\sand\sETRS89\sby\scountry"],BBOX[38.76,6,83.92,12]],ID["EPSG",3044]]\r\n\r\nTo\sget\sthe\stransformation\spipeline:\r\n\r\nC:\\ProgramData\\Microsoft\\Windows\\Start\sMenu\\Programs\\OSGeo4W>projinfo\s-o\sPROJ\s-s\sEPSG:25832\s-t\sEPSG:3044\r\nCandidate\soperations\sfound:\s1\r\n-------------------------------------\r\nOperation\sNo.\s1:\r\n\r\nunknown\sid,\sInverse\sof\sUTM\szone\s32N\s+\sUTM\szone\s32N,\s0\sm,\sWorld\r\n\r\nPROJ\sstring:\r\n+proj=axisswap\s+order=2,1\r\n\r\n\r\nSQL\sstatements\sin\sfile\stransform.sql:\r\n\r\nselect\r\nAsEWKT(PointFromText('POINT(722125\s6178892)',\s25832))\sas\sgeometry_25832,\r\nAsEWKT(Transform(PointFromText('POINT(722125\s6178892)',\s25832),\s3044))\sas\sgeometry_3044_only_newSRID,\r\nAsEWKT(Transform(PointFromText('POINT(722125\s6178892)',\s25832),\s3044,\snull,\s'EPSG:25832',\s'EPSG:3044'))\sas\sgeometry_3044_EPSG_codes,\r\nAsEWKT(Transform(PointFromText('POINT(722125\s6178892)',\s25832),\s3044,\snull,\s'urn:ogc:def:crs:EPSG::25832',\s'urn:ogc:def:crs:EPSG::3044'))\sas\sgeometry_3044_EPSG_URNs,\r\nAsEWKT(Transform(PointFromText('POINT(722125\s6178892)',\s25832),\s3044,\snull,\s'PROJCRS["ETRS89\s/\sUTM\szone\s32N",BASEGEOGCRS["ETRS89",DATUM["European\sTerrestrial\sReference\sSystem\s1989",ELLIPSOID["GRS\s1980",6378137,298.257222101,LENGTHUNIT["metre",1]]],PRIMEM["Greenwich",0,ANGLEUNIT["degree",0.0174532925199433]],ID["EPSG",4258]],CONVERSION["UTM\szone\s32N",METHOD["Transverse\sMercator",ID["EPSG",9807]],PARAMETER["Latitude\sof\snatural\sorigin",0,ANGLEUNIT["degree",0.0174532925199433],ID["EPSG",8801]],PARAMETER["Longitude\sof\snatural\sorigin",9,ANGLEUNIT["degree",0.0174532925199433],ID["EPSG",8802]],PARAMETER["Scale\sfactor\sat\snatural\sorigin",0.9996,SCALEUNIT["unity",1],ID["EPSG",8805]],PARAMETER["False\seasting",500000,LENGTHUNIT["metre",1],ID["EPSG",8806]],PARAMETER["False\snorthing",0,LENGTHUNIT["metre",1],ID["EPSG",8807]]],CS[Cartesian,2],AXIS["(E)",east,ORDER[1],LENGTHUNIT["metre",1]],AXIS["(N)",north,ORDER[2],LENGTHUNIT["metre",1]],USAGE[SCOPE["unknown"],AREA["Europe\s-\s6°E\sto\s12°E\sand\sETRS89\sby\scountry"],BBOX[38.76,6,83.92,12]],ID["EPSG",25832]]',\s'PROJCRS["ETRS89\s/\sUTM\szone\s32N\s(N-E)",BASEGEOGCRS["ETRS89",DATUM["European\sTerrestrial\sReference\sSystem\s1989",ELLIPSOID["GRS\s1980",6378137,298.257222101,LENGTHUNIT["metre",1]]],PRIMEM["Greenwich",0,ANGLEUNIT["degree",0.0174532925199433]],ID["EPSG",4258]],CONVERSION["UTM\szone\s32N",METHOD["Transverse\sMercator",ID["EPSG",9807]],PARAMETER["Latitude\sof\snatural\sorigin",0,ANGLEUNIT["degree",0.0174532925199433],ID["EPSG",8801]],PARAMETER["Longitude\sof\snatural\sorigin",9,ANGLEUNIT["degree",0.0174532925199433],ID["EPSG",8802]],PARAMETER["Scale\sfactor\sat\snatural\sorigin",0.9996,SCALEUNIT["unity",1],ID["EPSG",8805]],PARAMETER["False\seasting",500000,LENGTHUNIT["metre",1],ID["EPSG",8806]],PARAMETER["False\snorthing",0,LENGTHUNIT["metre",1],ID["EPSG",8807]]],CS[Cartesian,2],AXIS["northing\s(N)",north,ORDER[1],LENGTHUNIT["metre",1]],AXIS["easting\s(E)",east,ORDER[2],LENGTHUNIT["metre",1]],USAGE[SCOPE["unknown"],AREA["Europe\s-\s6°E\sto\s12°E\sand\sETRS89\sby\scountry"],BBOX[38.76,6,83.92,12]],ID["EPSG",3044]]'))\sas\sgeometry_3044_wkt2_2019,\r\nAsEWKT(Transform(PointFromText('POINT(722125\s6178892)',\s25832),\s3044,\snull,\s'+proj=axisswap\s+order=2,1',\snull))\sas\sgeometry_3044_Transformation_pipeline;\r\n\r\nspatialite\soutput:\r\n\r\nC:\\OtherPrograms\\spatialite-cli-NG-RC1-win-amd64>spatialite\r\nSpatiaLite\sversion\s..:\s5.0.0-RC1\s\s\s\s\s\s\s\sSupported\sExtensions:\r\n\s\s\s\s\s\s\s\s-\s'VirtualShape'\s\s\s\s\s\s\s\s[direct\sShapefile\saccess]\r\n\s\s\s\s\s\s\s\s-\s'VirtualDbf'\s\s\s\s\s\s\s\s\s\s[direct\sDBF\saccess]\r\n\s\s\s\s\s\s\s\s-\s'VirtualXL'\s\s\s\s\s\s\s\s\s\s\s[direct\sXLS\saccess]\r\n\s\s\s\s\s\s\s\s-\s'VirtualText'\s\s\s\s\s\s\s\s\s[direct\sCSV/TXT\saccess]\r\n\s\s\s\s\s\s\s\s-\s'VirtualNetwork'\s\s\s\s\s\s[Dijkstra\sshortest\spath]\r\n\s\s\s\s\s\s\s\s-\s'RTree'\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s[Spatial\sIndex\s-\sR*Tree]\r\n\s\s\s\s\s\s\s\s-\s'MbrCache'\s\s\s\s\s\s\s\s\s\s\s\s[Spatial\sIndex\s-\sMBR\scache]\r\n\s\s\s\s\s\s\s\s-\s'VirtualSpatialIndex'\s[R*Tree\smetahandler]\r\n\s\s\s\s\s\s\s\s-\s'VirtualElementary'\s\s\s[ElemGeoms\smetahandler]\r\n\s\s\s\s\s\s\s\s-\s'VirtualKNN'\s\s[K-Nearest\sNeighbors\smetahandler]\r\n\s\s\s\s\s\s\s\s-\s'VirtualXPath'\s\s\s\s\s\s\s\s[XML\sPath\sLanguage\s-\sXPath]\r\n\s\s\s\s\s\s\s\s-\s'VirtualFDO'\s\s\s\s\s\s\s\s\s\s[FDO-OGR\sinteroperability]\r\n\s\s\s\s\s\s\s\s-\s'VirtualGPKG'\s[OGC\sGeoPackage\sinteroperability]\r\n\s\s\s\s\s\s\s\s-\s'VirtualBBox'\s\s\s\s\s\s\s\s\s[BoundingBox\stables]\r\n\s\s\s\s\s\s\s\s-\s'SpatiaLite'\s\s\s\s\s\s\s\s\s\s[Spatial\sSQL\s-\sOGC]\r\nPROJ\sversion\s........:\sRel.\s7.1.0,\sAugust\s1st,\s2020\r\nGEOS\sversion\s........:\s3.8.1-CAPI-1.13.3\r\nRTTOPO\sversion\s......:\s1.1.0\r\nTARGET\sCPU\s..........:\sx86_64-w64-mingw32\r\nthe\sSPATIAL_REF_SYS\stable\salready\scontains\ssome\srow(s)\r\nSQLite\sversion\s......:\s3.32.3\r\nEnter\s".help"\sfor\sinstructions\r\nSQLite\sversion\s3.32.3\s2020-06-18\s14:00:33\r\nEnter\s".help"\sfor\sinstructions\r\nEnter\sSQL\sstatements\sterminated\swith\sa\s";"\r\nspatialite>\s.headers\sON\r\nspatialite>\s.mode\sline\r\nspatialite>\s.read\stransform.sql\s"UTF-8"\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\sgeometry_25832\s=\sSRID=25832;POINT(722125\s6178891.999999999)\r\n\s\s\s\s\s\s\s\s\s\s\sgeometry_3044_only_newSRID\s=\sSRID=3044;POINT(722125\s6178891.999999999)\r\n\s\s\s\s\s\s\s\s\s\s\s\s\sgeometry_3044_EPSG_codes\s=\sSRID=3044;POINT(722125\s6178891.999999999)\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\sgeometry_3044_EPSG_URNs\s=\sSRID=3044;POINT(722125\s6178891.999999999)\r\n\s\s\s\s\s\s\s\s\s\s\s\s\s\sgeometry_3044_wkt2_2019\s=\sSRID=3044;POINT(722125\s6178891.999999999)\r\ngeometry_3044_Transformation_pipeline\s=\sSRID=3044;POINT(6178891.999999999\s722125)\r\n\r\nOnly\swhen\susing\sthe\stransformation\spipeline,\sthe\scorrect\sresult\sis\sobtained.\r\n\r\n\r\nWhen\susing\sPROJ\sdirectly\sto\stransform\sthe\scoordinates,\sI\sget\sthe\sfollowing\soutput,\sas\sexpected:\r\n\r\nC:\\ProgramData\\Microsoft\\Windows\\Start\sMenu\\Programs\\OSGeo4W>echo\s722125\s6178892\s|\scs2cs\sEPSG:25832\sEPSG:3044\r\n6178892.00\s\s\s\s\s\s722125.00\s0.00\r\n\r\nC:\\ProgramData\\Microsoft\\Windows\\Start\sMenu\\Programs\\OSGeo4W>echo\s722125\s6178892\s|\scs2cs\surn:ogc:def:crs:EPSG::25832\surn:ogc:def:crs:EPSG::3044\r\n6178892.00\s\s\s\s\s\s722125.00\s0.00\r\n\r\nC:\\ProgramData\\Microsoft\\Windows\\Start\sMenu\\Programs\\OSGeo4W>echo\s722125\s6178892\s0\s0\s|\scct\s+proj=axisswap\s+order=2,1\r\n\s6178892.0000\s\s\s\s722125.0000\s\s\s\s\s\s\s\s0.0000\s\s\s\s\s\s\s\s0.0000
J login anonymous
J mimetype text/x-fossil-plain
J private_contact ff9a25a4a716f96c231bba592c4efaa53979591c
J severity Severe
J status Open
J title axis\sorder\sis\snot\srespected\swhen\susing\stransform
J type Code_Defect
K 3041a242d3d949fdd2e767b68e0a6cf12387093a
U anonymous
Z 39e4155849ce8b49d070788391b04fc7