Timeline for Understanding the format: WKB from WKT and how to convert the first into the latter [closed]
Current License: CC BY-SA 3.0
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 |