I still would like binary dump as I request in here.

Sorry - I thought I'd given you this in Re^4: Geo Package files

Here you go, this is hex dump of the entirety of $geo from this script...the lengths are vastly different. I added the random order to see how varied the data actually is.


use DBD::SQLite;
use Data::Dumper;

use strict;
use warnings;

my $dbh = DBI->connect("dbi:SQLite:uri=file:osopenusrn_202203.gpkg?mod
+e=rwc");

my $tab = $dbh->prepare("SELECT * FROM openUSRN ORDER BY RANDOM() LIMI
+T 1");
$tab->execute;
my $data = $tab->fetchrow_hashref;

my $geo = $data->{'geometry'};

print join ' ', unpack '(H2)*', $geo;
exit;

47 50 00 05 34 6c 00 00 a0 70 3d 0a a6 be 14 41
00 2b 87 96 97 c9 14 41 20 b2 9d 6f 1a 03 1b 41
e0 ce f7 53 e7 0d 1b 41 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 01 ed 03 00 00 04 00 00
00 01 ea 03 00 00 0a 00 00 00 40 8b 6c e7 16 c1
14 41 20 87 16 d9 12 07 1b 41 00 00 00 00 00 00
00 00 90 6e 12 83 bf c1 14 41 40 62 10 d8 35 07
1b 41 00 00 00 00 00 00 00 00 90 ed 7c bf 18 c2
14 41 40 35 5e 3a 64 07 1b 41 00 00 00 00 00 00
00 00 a0 c4 20 b0 79 c2 14 41 00 fe d4 78 c3 07
1b 41 00 00 00 00 00 00 00 00 a0 9b c4 a0 1a c3
14 41 a0 47 e1 fa ab 08 1b 41 00 00 00 00 00 00
00 00 40 60 e5 d0 86 c4 14 41 c0 cc cc 4c 3e 09
1b 41 00 00 00 00 00 00 00 00 50 37 89 41 87 c6
14 41 00 2b 87 96 a0 0a 1b 41 00 00 00 00 00 00
00 00 a0 45 b6 f3 a5 c6 14 41 00 ac 1c da da 0a
1b 41 00 00 00 00 00 00 00 00 90 ed 7c bf a0 c6
14 41 00 d5 78 e9 a9 0b 1b 41 00 00 00 00 00 00
00 00 80 6a bc f4 61 c7 14 41 80 be 9f 1a 38 0c
1b 41 00 00 00 00 00 00 00 00 01 ea 03 00 00 04
00 00 00 40 8b 6c e7 16 c1 14 41 20 87 16 d9 12
07 1b 41 00 00 00 00 00 00 00 00 c0 20 b0 72 61
bf 14 41 e0 fb a9 f1 78 05 1b 41 00 00 00 00 00
00 00 00 90 97 6e 92 a7 be 14 41 20 5c 8f 42 5f
03 1b 41 00 00 00 00 00 00 00 00 a0 70 3d 0a a6
be 14 41 20 b2 9d 6f 1a 03 1b 41 00 00 00 00 00
00 00 00 01 ea 03 00 00 02 00 00 00 a0 70 3d 8a
8d c8 14 41 80 95 43 8b ea 0c 1b 41 00 00 00 00
00 00 00 00 00 2b 87 96 97 c9 14 41 e0 ce f7 53
e7 0d 1b 41 00 00 00 00 00 00 00 00 01 ea 03 00
00 02 00 00 00 80 6a bc f4 61 c7 14 41 80 be 9f
1a 38 0c 1b 41 00 00 00 00 00 00 00 00 a0 70 3d
8a 8d c8 14 41 80 95 43 8b ea 0c 1b 41 00 00 00
00 00 00 00 00

[download]

In reply to Hex dump (was: Re^6: Geo Package files) by Bod
in thread Geo Package files by Bod

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.