Re: [FreeGeoCZ] velké bodové datasety na webu (TWK B, PBF)
Jan Michálek <[email protected]> Mon, 3 Jul 2017 07:29:57 +0200
| Newsgroups | gmane.comp.gis.grass.cz |
|---|---|
| Message-ID | <CAAYBy8aLKnPhfC1U0LLOjDqWPLwTTJO3tiCdjGO76NWn7yrCXw@mail.gmail.com> |
--===============2025373920== Content-Type: multipart/alternative; boundary="f403045ffd1ebfd4430553630e9e" --f403045ffd1ebfd4430553630e9e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hm a co spatiallite, nebo geopackage? Mmchdm, u bodovejch dat bys ud=C4=9Blal celkem dost "par=C3=A1dy" i s oby= =C4=8Dejnskym c=C3=A9esv=C3=A9=C4=8Dkem. Je; Dne 30. =C4=8Dervna 2017 17:00 Ha Noj <[email protected]> napsal(a): > 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-encodin > g-for-using-in-leaflet-js > > > _______________________________________________ > FreeGeoCZ mailing list > [email protected] > http://mailman.fsv.cvut.cz/mailman/listinfo/freegeocz > > --=20 Jelen Star=C5=A1=C3=AD =C4=8Deled=C3=ADn datov=C3=BDho chl=C3=ADva --f403045ffd1ebfd4430553630e9e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div><div>Hm a co spatiallite, nebo geopackage?<br></div>M= mchdm, u bodovejch dat bys ud=C4=9Blal celkem dost "par=C3=A1dy" = i s oby=C4=8Dejnskym c=C3=A9esv=C3=A9=C4=8Dkem.<br><br></div>Je;<br></div><= div class=3D"gmail_extra"><br><div class=3D"gmail_quote">Dne 30. =C4=8Dervn= a 2017 17:00 Ha Noj <span dir=3D"ltr"><<a href=3D"mailto:[email protected]= m" target=3D"_blank">[email protected]</a>></span> napsal(a):<br><blockqu= ote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc s= olid;padding-left:1ex"><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 Openlaye= rs 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></div><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=99ed= pokladu, =C5=BEe web server se s klientem dohodnou na sta=C5=BEen=C3=AD v G= zip - 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><d= iv>*** klasika, 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=BD= znam<br></div><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 vytvo=C5=99it korektn=C3=AD bin=C3=A1rn=C3=AD soubor?<br></div= ><div>psql -c "SELECT ST_AsTWKB('POINT(16 49)'::geometry);&quo= t; <span class=3D"m_6284490234821136448m_2432755989386533772gmail-"><br><br= ></span></div>4) Geobuf PBF [2]<br><div>*** op=C4=9Bt zaj=C3=ADmav=C3=BD, a= le =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><br></div><div= >5) N=C4=9Bco jin=C3=A9ho jinak? =C3=9Apln=C4=9B jinak?<br></div><div><br>z= drav=C3=AD<br>=C2=A0Dan B=C3=A1rta<br><br>[1] <a href=3D"https://dev.campto= camp.com/files/ol3/webgl/examples/webgl-points.html" target=3D"_blank">http= s://dev.camptocamp.com/fil<wbr>es/ol3/webgl/examples/webgl-<wbr>points.html= </a><br>[2] <a href=3D"https://github.com/mapbox/geobuf#install" target=3D"= _blank">https://github.com/mapbox/geob<wbr>uf#install</a><br>[3] <a href=3D= "https://stackoverflow.com/questions/35393903/geojson-encoding-for-using-in= -leaflet-js" target=3D"_blank">https://stackoverflow.com/ques<wbr>tions/353= 93903/geojson-encodin<wbr>g-for-using-in-leaflet-js</a><br><br></div></div> <br>______________________________<wbr>_________________<br> FreeGeoCZ mailing list<br> <a href=3D"mailto:[email protected]">[email protected]</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/<wbr>mailman/listinf= o/freegeocz</a><br> <br></blockquote></div><br><br clear=3D"all"><br>-- <br><div class=3D"gmail= _signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><div>Jelen<= br></div>Star=C5=A1=C3=AD =C4=8Deled=C3=ADn datov=C3=BDho chl=C3=ADva<br></= div></div> </div> --f403045ffd1ebfd4430553630e9e-- --===============2025373920== 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 --===============2025373920==--