Pedro-Juan Ferrer Matoses
  • Tips & Tricks
  • Archives

Split of a coordinate field

Date Tue 31 May 2016 Tags postgis / coordinate / field / split
SELECT st_astext(st_geomfromtext('POINT(' || split_part(txt_coords, ' ', 1) || ' ' || split_part(txt_coords, ' ', 2) || ')', 4258)) FROM tablatxt;
  • Social

    • Twitter
    • LinkedIn
    • Github
  • Links

    • Geomaticblog
    • Geoinquietos VLC
    • Arakua Urban Lab
    • Barrilungos

© 2017 pjfm · Powered by pelican-bootstrap3, Pelican, Bootstrap

Back to top