Re: [FreeGeoCZ] velké bodové datasety n a webu (TWKB, PBF)

Vojta Dubrovsky <[email protected]> Mon, 03 Jul 2017 09:03:09 +0200
Newsgroups	gmane.comp.gis.grass.cz
Message-ID	<[email protected]>
--===============0591658883==
Content-type: multipart/alternative;
	boundary="Apple-Mail=_4C31FF19-1EFD-40EC-84DF-EAFC390B81D8"


--Apple-Mail=_4C31FF19-1EFD-40EC-84DF-EAFC390B81D8
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

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/ =
<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.=20=


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=BE=
e po=C4=8D=C3=ADst.

------=20

Vojt=C4=9Bch Dubrovsk=C3=BD

m: 		+420 608 075 163
e:  		[email protected]
t:		@vdubr
ln:		https://cz.linkedin.com/in/vojtechdubrovsky

> On 30 Jun 2017, at 17:00, Ha Noj <[email protected]> wrote:
>=20
> Ahoj,
>=20
> 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=
.
> M=C3=A1te n=C4=9Bjakou praktickou zku=C5=A1enost?
>=20
> 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.
> *** klasika, ale velk=C3=BD a pomal=C3=BD...
>=20
> 2) TopoJSON 26 MB/zip 3 MB
> *** pro body to nem=C3=A1 moc v=C3=BDznam
>=20
> 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, jak ale vytvo=C5=99it korektn=C3=AD =
bin=C3=A1rn=C3=AD soubor?
> psql -c "SELECT ST_AsTWKB('POINT(16 49)'::geometry);"=20
>=20
> 4) Geobuf PBF [2]
> *** 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=99ev=C3=A1d=C4=9B=
c=C3=ADho n=C3=A1stroje [3].
>=20
> 5) N=C4=9Bco jin=C3=A9ho jinak? =C3=9Apln=C4=9B jinak?
>=20
> zdrav=C3=AD
>  Dan B=C3=A1rta
>=20
> [1] =
https://dev.camptocamp.com/files/ol3/webgl/examples/webgl-points.html =
<https://dev.camptocamp.com/files/ol3/webgl/examples/webgl-points.html>
> [2] https://github.com/mapbox/geobuf#install =
<https://github.com/mapbox/geobuf#install>
> [3] =
https://stackoverflow.com/questions/35393903/geojson-encoding-for-using-in=
-leaflet-js =
<https://stackoverflow.com/questions/35393903/geojson-encoding-for-using-i=
n-leaflet-js>
>=20
> _______________________________________________
> FreeGeoCZ mailing list
> [email protected]
> http://mailman.fsv.cvut.cz/mailman/listinfo/freegeocz


--Apple-Mail=_4C31FF19-1EFD-40EC-84DF-EAFC390B81D8
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html =
charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" =
class=3D"">Ahoj,<div class=3D""><br class=3D""></div><div =
class=3D"">=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.</div><div class=3D""><br =
class=3D""></div><div class=3D""><a =
href=3D"http://vdubr.github.io/water_moldavia/" =
class=3D"">http://vdubr.github.io/water_moldavia/</a></div><div =
class=3D""><br class=3D""></div><div class=3D"">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.&nbsp;</div><div =
class=3D""><br class=3D""></div><div class=3D"">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 class=3D""><br =
class=3D""></div><div class=3D"">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.</div><div =
class=3D""><br class=3D""><div class=3D"">
<div style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space;" class=3D""><div style=3D"color: =
rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: =
normal; font-variant-caps: normal; font-weight: normal; letter-spacing: =
normal; orphans: auto; text-align: start; text-indent: 0px; =
text-transform: none; white-space: normal; widows: auto; word-spacing: =
0px; -webkit-text-stroke-width: 0px;">------&nbsp;<br class=3D""><br =
class=3D"">Vojt=C4=9Bch Dubrovsk=C3=BD<br class=3D""><br =
class=3D"">m:&nbsp;<span class=3D"Apple-tab-span" style=3D"white-space: =
pre;">		</span>+420 608 075 163<br class=3D"">e: &nbsp;<span =
class=3D"Apple-tab-span" style=3D"white-space: pre;">		=
</span><a href=3D"mailto:[email protected]" =
class=3D"">[email protected]</a><br class=3D"">t:<span =
class=3D"Apple-tab-span" style=3D"white-space: pre;">		=
</span>@vdubr</div><div style=3D"color: rgb(0, 0, 0); font-family: =
Helvetica; font-size: 12px; font-style: normal; font-variant-caps: =
normal; font-weight: normal; letter-spacing: normal; orphans: auto; =
text-align: start; text-indent: 0px; text-transform: none; white-space: =
normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: =
0px;">ln:<span class=3D"Apple-tab-span" style=3D"white-space: pre;">		=
</span><a href=3D"https://cz.linkedin.com/in/vojtechdubrovsky" =
class=3D"">https://cz.linkedin.com/in/vojtechdubrovsky</a></div></div>
</div>

<br class=3D""><div><blockquote type=3D"cite" class=3D""><div =
class=3D"">On 30 Jun 2017, at 17:00, Ha Noj &lt;<a =
href=3D"mailto:[email protected]" class=3D"">[email protected]</a>&gt; =
wrote:</div><br class=3D"Apple-interchange-newline"><div class=3D""><div =
dir=3D"ltr" class=3D""><div class=3D""><div class=3D""><div =
class=3D""><div class=3D""><div class=3D"">Ahoj,<br class=3D""></div><br =
class=3D"">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=9Bla=
t i bez atribut=C5=AF.<br class=3D""></div><div class=3D"">M=C3=A1te =
n=C4=9Bjakou praktickou zku=C5=A1enost?<br class=3D""></div><div =
class=3D""><br class=3D""></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 class=3D""></div><div class=3D"">*** klasika, ale =
velk=C3=BD a pomal=C3=BD...<br class=3D""></div><div class=3D""><br =
class=3D""></div>2) TopoJSON 26 MB/zip 3 MB<br class=3D""></div><div =
class=3D"">*** pro body to nem=C3=A1 moc v=C3=BDznam<br =
class=3D""></div><div class=3D""><br class=3D""></div>3) TWKB [1]<br =
class=3D""></div><div class=3D"">*** 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 =
vytvo=C5=99it korektn=C3=AD bin=C3=A1rn=C3=AD soubor?<br =
class=3D""></div><div class=3D"">psql -c "SELECT ST_AsTWKB('POINT(16 =
49)'::geometry);" <span class=3D"m_2432755989386533772gmail-"><br =
class=3D""><br class=3D""></span></div>4) Geobuf PBF [2]<br =
class=3D""><div class=3D"">*** 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=99ev=C3=A1d=C4=9Bc=C3=ADho n=C3=A1stroje [3].<br =
class=3D""><br class=3D""></div><div class=3D"">5) N=C4=9Bco jin=C3=A9ho =
jinak? =C3=9Apln=C4=9B jinak?<br class=3D""></div><div class=3D""><br =
class=3D"">zdrav=C3=AD<br class=3D"">&nbsp;Dan B=C3=A1rta<br =
class=3D""><br class=3D"">[1] <a =
href=3D"https://dev.camptocamp.com/files/ol3/webgl/examples/webgl-points.h=
tml" target=3D"_blank" class=3D"">https://dev.camptocamp.com/<wbr =
class=3D"">files/ol3/webgl/examples/<wbr =
class=3D"">webgl-points.html</a><br class=3D"">[2] <a =
href=3D"https://github.com/mapbox/geobuf#install" target=3D"_blank" =
class=3D"">https://github.com/mapbox/<wbr class=3D"">geobuf#install</a><br=
 class=3D"">[3] <a =
href=3D"https://stackoverflow.com/questions/35393903/geojson-encoding-for-=
using-in-leaflet-js" target=3D"_blank" =
class=3D"">https://stackoverflow.com/<wbr =
class=3D"">questions/35393903/geojson-<wbr =
class=3D"">encoding-for-using-in-leaflet-<wbr class=3D"">js</a><br =
class=3D""><br class=3D""></div></div>
_______________________________________________<br class=3D"">FreeGeoCZ =
mailing list<br class=3D""><a href=3D"mailto:[email protected]" =
class=3D"">[email protected]</a><br =
class=3D"">http://mailman.fsv.cvut.cz/mailman/listinfo/freegeocz<br =
class=3D""></div></blockquote></div><br class=3D""></div></body></html>=

--Apple-Mail=_4C31FF19-1EFD-40EC-84DF-EAFC390B81D8--

--===============0591658883==
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

--===============0591658883==--