Menu

#1182 Use Hex/WKT for Geometry Export columns

Needs_decision
wont-fix
Normal
2015-02-24
2009-09-16
Greg Roach
No

The database/table export facility has an option to export binary data as ascii text: "Use hexadecimal for BLOB
Export type".

A similar feature is needed for geometry columns.

MySQL can convert them to WKT/WKB format using AsText() and AsBinary().
MySQL can convert the data back using GeomFromText() and GeomFromWKB().

Discussion

  • Michal Čihař

    Michal Čihař - 2011-07-13
    • assigned_to: nobody --> madhuracj
     
  • Madhura Jayaratne

    • assigned_to: madhuracj --> nobody
     
  • Madhura Jayaratne

    De-assigning myself since I didn't find a straightforward way of implementing this.

     
  • Marc Delisle

    Marc Delisle - 2015-02-15
    • Priority: 5 --> Normal
     
  • Madhura Jayaratne

    • assigned_to: Madhura Jayaratne
    • Group: --> Needs_decision
     
  • Madhura Jayaratne

    Data exporting uses unbuffered mode which makes it impossible to send additional queries to convert data to WKT/WKB. On the other hand modifying the original query to convert data to WKT/WKB can not be done reliably for all cases. Moreover, such query modification complicates the logic and I do not believe it is worth the benefits.

     
  • Madhura Jayaratne

    Won't fix due to technical difficulties.

     
  • Madhura Jayaratne

    • status: open --> wont-fix
     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.