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. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users