Re: [FreeGeoCZ] velké bodové datasety na webu (TWK B, PBF)

Jachym Cepicky <[email protected]> Mon, 03 Jul 2017 08:29:51 +0000
Newsgroups gmane.comp.gis.grass.cz
Message-ID <CAAZUH4GdVi8fguQ4nejXyoOidrCHMrccOfMTU_EZjrZTsGTvZA@mail.gmail.com>
--===============1557642433==
Content-Type: multipart/alternative; boundary="001a1145e906c7e79905536592f1"

--001a1145e906c7e79905536592f1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Nadla=C5=BEdicovat

https://github.com/mapbox/tippecanoe


po 3. 7. 2017 v 10:03 odes=C3=ADlatel Vojta Dubrovsky <[email protected]> na=
psal:

> Ahoj,
>
> =C5=99e=C5=A1il jsem n=C4=9Bco podobn=C3=A9ho. Nyn=C3=AD zobrazuji =E2=80=
=9Cpouze=E2=80=9D 10k bod=C5=AF, ale d=C3=A1 se to
> pou=C5=BE=C3=ADt jako usecase.
>
> http://vdubr.github.io/water_moldavia/
>
> Pou=C5=BEil jsem TopoJSON s p=C5=99esnost=C3=AD na metry. V gzipu to d=C4=
=9Bl=C3=A1 80KB.
> Atribotov=C3=A1 data jsem vy=C4=8Dlenil od geometrie a stahuj=C3=AD se ze=
 slo=C5=BEky podle ID
> a=C5=BE p=C5=99i prokliku. M=C3=A1m tam p=C5=99ipraveny i offline filtrov=
=C3=A1n=C3=AD.
>
> Koukni do dev konzole na =C4=8Dasy, ale mysl=C3=ADm =C5=BEe i 100k bod=C5=
=AF by bylo st=C3=A1le pro
> u=C5=BEivatele snesiteln=C3=BDch.
>
> Kdo si vy=C5=BE=C3=ADv=C3=A1 v Moldav=C5=A1tin=C4=9B, tak si m=C5=AF=C5=
=BEe po=C4=8D=C3=ADst.
>
> ------
>
> Vojt=C4=9Bch Dubrovsk=C3=BD
>
> m:  +420 608 075 163 <608%20075%20163>
> e:   [email protected]
> t: @vdubr
> ln: https://cz.linkedin.com/in/vojtechdubrovsky
>
> On 30 Jun 2017, at 17:00, Ha Noj <[email protected]> wrote:
>
> Ahoj,
>
> cht=C4=9Bl bych publikovat na webu v n=C4=9B=C4=8Dem jako Openlayers bez =
u=C5=BEit=C3=AD serveru
> dataset o 100.000 bodech, optim=C3=A1ln=C4=9B i s n=C4=9Bjak=C3=BDmi atri=
buty, ale lze to
> ud=C4=9Blat i bez atribut=C5=AF.
> M=C3=A1te n=C4=9Bjakou praktickou zku=C5=A1enost?
>
> 1) GeoJSON 32 MB/zip 3 MB/RAM 390 MB (zip za p=C5=99edpokladu, =C5=BEe we=
b server se
> s klientem dohodnou na sta=C5=BEen=C3=AD v Gzip - zd=C3=A1 se mi, =C5=BEe=
 tomu tak nen=C3=AD v=C5=BEdy),
> pokud odstran=C3=ADm v=C5=A1echny atributy tak 11 MB/zip 0,7 MB/ RAM 350 =
MB.
> *** klasika, ale velk=C3=BD a pomal=C3=BD...
>
> 2) TopoJSON 26 MB/zip 3 MB
> *** pro body to nem=C3=A1 moc v=C3=BDznam
>
> 3) TWKB [1]
> *** zaj=C3=ADmav=C3=BD! RAM 9 MB na 100.000 bod=C5=AF, ale nepochopil jak=
 se vytv=C3=A1=C5=99=C3=AD
> soubory twkb? Z=C3=ADskat samotnou geometrii je v psql jednoduch=C3=A9, j=
ak ale
> vytvo=C5=99it korektn=C3=AD bin=C3=A1rn=C3=AD soubor?
> psql -c "SELECT ST_AsTWKB('POINT(16 49)'::geometry);"
>
> 4) Geobuf PBF [2]
> *** op=C4=9Bt zaj=C3=ADmav=C3=BD, ale =C5=BE=C3=A1dn=C3=BDm z n=C3=A1stro=
j=C5=AF se mi nepoda=C5=99ilo vytvo=C5=99it
> pot=C5=99ebn=C3=BD PBF soubor, v=C5=BEdy to kon=C4=8D=C3=AD p=C3=A1dem p=
=C5=99ev=C3=A1d=C4=9Bc=C3=ADho n=C3=A1stroje [3].
>
> 5) N=C4=9Bco jin=C3=A9ho jinak? =C3=9Apln=C4=9B jinak?
>
> zdrav=C3=AD
>  Dan B=C3=A1rta
>
> [1] https://dev.camptocamp.com/files/ol3/webgl/examples/webgl-points.html
> [2] https://github.com/mapbox/geobuf#install
> [3]
> https://stackoverflow.com/questions/35393903/geojson-encoding-for-using-i=
n-leaflet-js
>
> _______________________________________________
> FreeGeoCZ mailing list
> [email protected]
> http://mailman.fsv.cvut.cz/mailman/listinfo/freegeocz
>
>
> _______________________________________________
> FreeGeoCZ mailing list
> [email protected]
> http://mailman.fsv.cvut.cz/mailman/listinfo/freegeocz
>

--001a1145e906c7e79905536592f1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Nadla=C5=BEdicovat<div><br></div><div><a href=3D"https://g=
ithub.com/mapbox/tippecanoe">https://github.com/mapbox/tippecanoe</a><br></=
div><div><br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr">po=
 3. 7. 2017 v 10:03 odes=C3=ADlatel Vojta Dubrovsky &lt;<a href=3D"mailto:v=
[email protected]">[email protected]</a>&gt; napsal:<br></div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pad=
ding-left:1ex"><div style=3D"word-wrap:break-word">Ahoj,<div><br></div><div=
>=C5=99e=C5=A1il jsem n=C4=9Bco podobn=C3=A9ho. Nyn=C3=AD zobrazuji =E2=80=
=9Cpouze=E2=80=9D 10k bod=C5=AF, ale d=C3=A1 se to pou=C5=BE=C3=ADt jako us=
ecase.</div><div><br></div><div><a href=3D"http://vdubr.github.io/water_mol=
davia/" target=3D"_blank">http://vdubr.github.io/water_moldavia/</a></div><=
div><br></div><div>Pou=C5=BEil jsem TopoJSON s p=C5=99esnost=C3=AD na metry=
. V gzipu to d=C4=9Bl=C3=A1 80KB. Atribotov=C3=A1 data jsem vy=C4=8Dlenil o=
d geometrie a stahuj=C3=AD se ze slo=C5=BEky podle ID a=C5=BE p=C5=99i prok=
liku. M=C3=A1m tam p=C5=99ipraveny i offline filtrov=C3=A1n=C3=AD.=C2=A0</d=
iv><div><br></div><div>Koukni do dev konzole na =C4=8Dasy, ale mysl=C3=ADm =
=C5=BEe i 100k bod=C5=AF by bylo st=C3=A1le pro u=C5=BEivatele snesiteln=C3=
=BDch.</div><div><br></div><div>Kdo si vy=C5=BE=C3=ADv=C3=A1 v Moldav=C5=A1=
tin=C4=9B, tak si m=C5=AF=C5=BEe po=C4=8D=C3=ADst.</div><div><br><div>
<div style=3D"word-wrap:break-word"><div style=3D"color:rgb(0,0,0);font-fam=
ily:Helvetica;font-size:12px;font-style:normal;font-variant-caps:normal;fon=
t-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text=
-transform:none;white-space:normal;word-spacing:0px">------=C2=A0<br><br>Vo=
jt=C4=9Bch Dubrovsk=C3=BD<br><br>m:=C2=A0<span class=3D"m_33961000656470671=
93Apple-tab-span" style=3D"white-space:pre-wrap">		</span><a href=3D"tel:60=
8%20075%20163" value=3D"+420608075163" target=3D"_blank">+420 608 075 163</=
a><br>e: =C2=A0<span class=3D"m_3396100065647067193Apple-tab-span" style=3D=
"white-space:pre-wrap">		</span><a href=3D"mailto:[email protected]" target=
=3D"_blank">[email protected]</a><br>t:<span class=3D"m_3396100065647067193A=
pple-tab-span" style=3D"white-space:pre-wrap">		</span>@vdubr</div><div sty=
le=3D"color:rgb(0,0,0);font-family:Helvetica;font-size:12px;font-style:norm=
al;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-a=
lign:start;text-indent:0px;text-transform:none;white-space:normal;word-spac=
ing:0px">ln:<span class=3D"m_3396100065647067193Apple-tab-span" style=3D"wh=
ite-space:pre-wrap">		</span><a href=3D"https://cz.linkedin.com/in/vojtechd=
ubrovsky" target=3D"_blank">https://cz.linkedin.com/in/vojtechdubrovsky</a>=
</div></div>
</div></div></div><div style=3D"word-wrap:break-word"><div>

<br><div><blockquote type=3D"cite"><div>On 30 Jun 2017, at 17:00, Ha Noj &l=
t;<a href=3D"mailto:[email protected]" target=3D"_blank">[email protected]</a=
>&gt; wrote:</div><br class=3D"m_3396100065647067193Apple-interchange-newli=
ne"><div><div dir=3D"ltr"><div><div><div><div><div>Ahoj,<br></div><br>cht=
=C4=9Bl bych publikovat na webu v n=C4=9B=C4=8Dem jako Openlayers bez u=C5=
=BEit=C3=AD serveru dataset o 100.000 bodech, optim=C3=A1ln=C4=9B i s n=C4=
=9Bjak=C3=BDmi atributy, ale lze to ud=C4=9Blat i bez atribut=C5=AF.<br></d=
iv><div>M=C3=A1te n=C4=9Bjakou praktickou zku=C5=A1enost?<br></div><div><br=
></div>1) GeoJSON 32 MB/zip 3 MB/RAM 390 MB (zip za p=C5=99edpokladu, =C5=
=BEe web server se s klientem dohodnou na sta=C5=BEen=C3=AD v Gzip - zd=C3=
=A1 se mi, =C5=BEe tomu tak nen=C3=AD v=C5=BEdy), pokud odstran=C3=ADm v=C5=
=A1echny atributy tak 11 MB/zip 0,7 MB/ RAM 350 MB.<br></div><div>*** klasi=
ka, ale velk=C3=BD a pomal=C3=BD...<br></div><div><br></div>2) TopoJSON 26 =
MB/zip 3 MB<br></div><div>*** pro body to nem=C3=A1 moc v=C3=BDznam<br></di=
v><div><br></div>3) TWKB [1]<br></div><div>*** zaj=C3=ADmav=C3=BD! RAM 9 MB=
 na 100.000 bod=C5=AF, ale nepochopil jak se vytv=C3=A1=C5=99=C3=AD soubory=
 twkb? Z=C3=ADskat samotnou geometrii je v psql jednoduch=C3=A9, jak ale vy=
tvo=C5=99it korektn=C3=AD bin=C3=A1rn=C3=AD soubor?<br></div><div>psql -c &=
quot;SELECT ST_AsTWKB(&#39;POINT(16 49)&#39;::geometry);&quot; <span class=
=3D"m_3396100065647067193m_2432755989386533772gmail-"><br><br></span></div>=
4) Geobuf PBF [2]<br><div>*** op=C4=9Bt zaj=C3=ADmav=C3=BD, ale =C5=BE=C3=
=A1dn=C3=BDm z n=C3=A1stroj=C5=AF se mi nepoda=C5=99ilo vytvo=C5=99it pot=
=C5=99ebn=C3=BD PBF soubor, v=C5=BEdy to kon=C4=8D=C3=AD p=C3=A1dem p=C5=99=
ev=C3=A1d=C4=9Bc=C3=ADho n=C3=A1stroje [3].<br><br></div><div>5) N=C4=9Bco =
jin=C3=A9ho jinak? =C3=9Apln=C4=9B jinak?<br></div><div><br>zdrav=C3=AD<br>=
=C2=A0Dan B=C3=A1rta<br><br>[1] <a href=3D"https://dev.camptocamp.com/files=
/ol3/webgl/examples/webgl-points.html" target=3D"_blank">https://dev.campto=
camp.com/files/ol3/webgl/examples/webgl-points.html</a><br>[2] <a href=3D"h=
ttps://github.com/mapbox/geobuf#install" target=3D"_blank">https://github.c=
om/mapbox/geobuf#install</a><br>[3] <a href=3D"https://stackoverflow.com/qu=
estions/35393903/geojson-encoding-for-using-in-leaflet-js" target=3D"_blank=
">https://stackoverflow.com/questions/35393903/geojson-encoding-for-using-i=
n-leaflet-js</a><br><br></div></div>
_______________________________________________<br>FreeGeoCZ mailing list<b=
r><a href=3D"mailto:[email protected]" target=3D"_blank">FreeGeoCZ@fsv.=
cvut.cz</a><br><a href=3D"http://mailman.fsv.cvut.cz/mailman/listinfo/freeg=
eocz" target=3D"_blank">http://mailman.fsv.cvut.cz/mailman/listinfo/freegeo=
cz</a><br></div></blockquote></div><br></div></div>________________________=
_______________________<br>
FreeGeoCZ mailing list<br>
<a href=3D"mailto:[email protected]" target=3D"_blank">[email protected]=
ut.cz</a><br>
<a href=3D"http://mailman.fsv.cvut.cz/mailman/listinfo/freegeocz" rel=3D"no=
referrer" target=3D"_blank">http://mailman.fsv.cvut.cz/mailman/listinfo/fre=
egeocz</a><br>
</blockquote></div>

--001a1145e906c7e79905536592f1--

--===============1557642433==
Content-Type: text/plain; charset="iso-8859-2"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

_______________________________________________
FreeGeoCZ mailing list
[email protected]
http://mailman.fsv.cvut.cz/mailman/listinfo/freegeocz

--===============1557642433==--