Getting somewhere. Not sure what the first byte is. Next 4 bytes=shape type (3=polygon)Next 4 bytes = record number (1) next 4 bytes are record length(0x27=39decimal) and the data starts at 08 28 27 41. Slightly different to the shapefile format, but not by much.
Can anyone help me with the format of the blobs in the SQLite data. For example, if I open up the first record in ne_10m_lakes, the second column ‘geometry’ contains 637 bytes, the first 16 of which are:
01 03 00 00 00 01 00 00 00 27 00 00 00 08 28 27 41
after which a pattern of 32 bit ints appears to begin.
According to Wikipedia(http://en.wikipedia.org/wiki/Shapefile), a shapefile begins with ‘File code (always hex value 0x0000270a)’, so I guess the blob data does not start at the beginning of the shape data, but I can’t figure out the exact format.