BOA TARDE
Tenho um campo com as latitude e longitude de um poligono, preciso colocar latitude e longitude em uma tabela campos separados
Exemplo
Poligono1
-45.91802598323845,-21.6730242381895,0 -45.91796140726108,-21.67296228837713,0 -45.91788928733067,-21.67286912514073,0 -45.91782595715815,-21.67281613132478,0 -45.91777616461947,-21.67274847009734,0 -45.91771824283764,-21.6726721201304,0 -45.91762555616348,-21.67255099108178,0 -45.91757652371323,-21.67249584786729,0 -45.91752301856713,-21.67243600182899,0 -45.91746839506548,-21.67236631225802,0 -45.91738957639605,-21.67242535453181,0 -45.91732441329447,-21.67250606242535,0 -45.9172464432995,-21.67260565239167,0 -45.91716729159791,-21.67266602845025,0 -45.91710370243761,-21.67272616780245,0 -45.91706182096288,-21.67277862020865,0 -45.91723214426886,-21.6729100345756,0 -45.91730499163099,-21.67300804798779,0 -45.91738573700451,-21.67310131434034,0 -45.91744688700044,-21.67318174401968,0 -45.91752550386147,-21.67322568352003,0 -45.9175902640681,-21.67328916329074,0 -45.91761099837283,-21.6733274748227,0 -45.91765818317863,-21.6733898972451,0 -45.91774308335428,-21.6733406674947,0 -45.91782290693429,-21.67325071723814,0 -45.91790460273903,-21.67317804615874,0 -45.91797461633638,-21.67310160299756,0 -45.91802598323845,-21.6730242381895,0
Preciso que fique mais ou menos assim
idPonto Logitude Latitude
1 -45.91802598323845 -21.6730242381895
2 -45.91796140726108 -21.67296228837713
3 -45.91788928733067 -21.67286912514073
Tenho um campo com as latitude e longitude de um poligono, preciso colocar latitude e longitude em uma tabela campos separados
Exemplo
Poligono1
-45.91802598323845,-21.6730242381895,0 -45.91796140726108,-21.67296228837713,0 -45.91788928733067,-21.67286912514073,0 -45.91782595715815,-21.67281613132478,0 -45.91777616461947,-21.67274847009734,0 -45.91771824283764,-21.6726721201304,0 -45.91762555616348,-21.67255099108178,0 -45.91757652371323,-21.67249584786729,0 -45.91752301856713,-21.67243600182899,0 -45.91746839506548,-21.67236631225802,0 -45.91738957639605,-21.67242535453181,0 -45.91732441329447,-21.67250606242535,0 -45.9172464432995,-21.67260565239167,0 -45.91716729159791,-21.67266602845025,0 -45.91710370243761,-21.67272616780245,0 -45.91706182096288,-21.67277862020865,0 -45.91723214426886,-21.6729100345756,0 -45.91730499163099,-21.67300804798779,0 -45.91738573700451,-21.67310131434034,0 -45.91744688700044,-21.67318174401968,0 -45.91752550386147,-21.67322568352003,0 -45.9175902640681,-21.67328916329074,0 -45.91761099837283,-21.6733274748227,0 -45.91765818317863,-21.6733898972451,0 -45.91774308335428,-21.6733406674947,0 -45.91782290693429,-21.67325071723814,0 -45.91790460273903,-21.67317804615874,0 -45.91797461633638,-21.67310160299756,0 -45.91802598323845,-21.6730242381895,0
Preciso que fique mais ou menos assim
idPonto Logitude Latitude
1 -45.91802598323845 -21.6730242381895
2 -45.91796140726108 -21.67296228837713
3 -45.91788928733067 -21.67286912514073