1 2 3 4 5 6 7
|
From KML - LINESTRING Z
:memory:
SELECT AsText(GeomFromKML('<LineString><coordinates> -112.2550785337791,36.07954952145647,2357 -112.2549277039738,36.08117083492122,2357 -112.2552505069063,36.08260761307279,2357 -112.2564540158376,36.08395660588506,2357 -112.2580238976449,36.08511401044813,2357 -112.2595218489022,36.08584355239394,2357 -112.262073428656,36.08626019085147,2357 -112.2633204928495,36.08621519860091,2357 -112.2644963846444,36.08627897945274,2357 -112.2656969554589,36.08649599090644,2357 </coordinates></LineString>'))
1 # rows
1 # column
AsText(GeomFromKML('<LineString><coordinates> -112.2550785337791,36.07954952145647,2357 -112.2549277039738,36.08117083492122,2357 -112.2552505069063,36.08260761307279,2357 -112.2564540158376,36.08395660588506,2357 -112.2580238976449,36.08511401044813,2357 -112.2595218489022,36.08584355239394,2357 -112.262073428656,36.08626019085147,2357 -112.2633204928495,36.08621519860091,2357 -112.2644963846444,36.08627897945274,2357 -112.2656969554589,36.08649599090644,2357 </coordinates></LineString>'))
LINESTRING Z(-112.255079 36.07955 2357, -112.254928 36.081171 2357, -112.255251 36.082608 2357, -112.256454 36.083957 2357, -112.258024 36.085114 2357, -112.259522 36.085844 2357, -112.262073 36.08626 2357, -112.26332 36.086215 2357, -112.264496 36.086279 2357, -112.265697 36.086496 2357)
|