Skip to main content
10 events
when toggle format what by license comment
Jun 12, 2020 at 0:31 review Reopen votes
Jun 12, 2020 at 5:36
Apr 13, 2017 at 12:34 history edited CommunityBot
replaced http://gis.stackexchange.com/ with https://gis.stackexchange.com/
Apr 6, 2017 at 15:50 history closed Midavalo Needs more focus
Jul 14, 2015 at 7:06 vote accept user3520314
Jul 8, 2015 at 3:37 history edited Mike T
edited tags
Jul 8, 2015 at 3:36 answer added Mike T timeline score: 27
May 7, 2015 at 14:01 comment added user3520314 yes I use PostGIS with the postgreSQL environment. I have tried that one too as it was suggested in the thread I already followed...Paul Ramsey's functions I've tried them all.. Btw with that query UPDATE "ita_adm1" SET wkb_geometry = ST_AsText("wkb_geometry") that's the error I get ERRORE: Geometry SRID (0) does not match column SRID (4326)
May 6, 2015 at 16:17 comment added MappaGnosis What software environment are you using? Is it PostGIS as per the example or something else?. Also, if you are using Postgresql, do you have PostGIS installed (it is not a standard part of Postgresql - which could explain why the function is missing - can you confirm? Finally PostGIS stores geometry in a hexadecimal format (note Vince's comment), so have you tried ST_AsText?
May 6, 2015 at 15:12 comment added Vince That's a hexadecimal dump of WKB, not WKB itself.
May 6, 2015 at 13:29 history asked user3520314 CC BY-SA 3.0