Thanks very much for your prompt reply.
I had seen that I could use the geopoly_blob function to copy a
json-formatted entry into a new record without getting an error from
sqlite, however I was disconcerted when seeing that a select _shape from
newtab (using example from documentation) displayed the first record as
the json string and the second record as a blob (ie []).
The news about the change in next release is all good. Thanks again.
regards,
Graham
On 20-10-2018 3:14 am, Richard Hipp wrote:
On 10/19/18, Graham Hardman <gra...@gh-designs.net> wrote:
My question now is : must I always format my list of vertices as text
(
in json format ) as shown in the documentation.
No. Polygons can be either in the GeoJSON format as text, or in a
binary format
(https://www.sqlite.org/geopoly.html#binary_encoding_of_polygons).
Any routine that accepts a polygon can accept either format.
Beginning with the next release, polygons will always be stored in the
binary format. In the previous release, polygons were stored in
whatever format was used to insert them. But experience shows that
the binary format is smaller and faster.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
