|
|
(Není zobrazeno 8 mezilehlých verzí od stejného uživatele.) |
Řádek 1: |
Řádek 1: |
| {{Upravit}} | | {{freegiswiki|RasterLite}} |
| [[Image:spatialite-logo.png|175px|right]]
| |
| '''RasterLite''' je rozšíření [[SpatiaLite]] pro uložení, manipulaci a analýzu rastrových dat.
| |
| __TOC__
| |
| Pod operačním systémem Debian GNU/Linux nainstalujeme SpatiaLite příkazem
| |
| | |
| sudo apt-get install librasterlite2 rasterlite-bin
| |
| | |
| == Import dat ==
| |
| | |
| Nejprve stáhneme testovací data a vytvoříme SpatiaLite databázi.
| |
| | |
| wget http://geo.fsv.cvut.cz/~landa/vyuka/postgis/dem.tif
| |
| spatialite raster.sqlite < init_spatialite-2.3.sql
| |
| | |
| Data naimportujeme pomocí nástroje <tt>rasterlite_load</tt>.
| |
| | |
| rasterlite_load -d raster.sqlite -T dem -f dem.tif -i TIFF -e 2065
| |
| | |
| Příklad jednoduchého dotazu.
| |
| | |
| <source lang="sql">
| |
| SELECT tile_id, AsText(geometry) FROM dem
| |
| WHERE NOT IsEmpty(geometry) LIMIT 3;
| |
| </source>
| |
| | |
| <pre>
| |
| tile_id = 0
| |
| astext(geometry) = POLYGON((-180 90, -177.904167 90, -177.904167 87.904167, -180 87.904167, -180 90))
| |
| | |
| tile_id = 1
| |
| astext(geometry) = POLYGON((-177.904167 90, -175.808333 90, -175.808333 87.904167, -177.904167 87.904167, -177.904167 90))
| |
| | |
| tile_id = 2
| |
| astext(geometry) = POLYGON((-175.808333 90, -173.7125 90, -173.7125 87.904167, -175.808333 87.904167, -175.808333 90))
| |
| </pre>
| |
| | |
| V databázi se vytvoří dvě tabulky
| |
| | |
| * <tt>dem_rasters</tt> - binární data dlaždic
| |
| * <tt>dem_metadata</tt> - metadata dlaždic
| |
| | |
| <source lang=sql>
| |
| SELECT * FROM dem_rasters LIMIT 3;
| |
| </source>
| |
| | |
| <pre>
| |
| id|raster
| |
| 1 |II*
| |
| 2 |II*
| |
| 3 |II*
| |
| </pre>
| |
| | |
| <source lang=sql>
| |
| SELECT * FROM marble_metadata LIMIT 3;
| |
| </source>
| |
| | |
| <pre>
| |
| id source_name tile_id width height pixel_x_size pixel_y_size geometry
| |
| ---------- --------------- ---------- ---------- ---------- ------------ ------------ ----------
| |
| 0 raster metadata 0 0 0 0.0 0.0
| |
| 1 /opt/vyuka/land 0 503 503 0.0041666666 0.0041666666
| |
| 2 /opt/vyuka/land 1 503 503 0.0041666666 0.0041666666
| |
| </pre>
| |
| | |
| == Související články ==
| |
| | |
| * [[SpatiaLite]]
| |
| * [[PostGIS Raster]]
| |
| | |
| == Externí odkazy ==
| |
| | |
| * [http://www.gaia-gis.it/spatialite/rasterlite-man.pdf RasterLite Manual]
| |
| * [http://www.gaia-gis.it/spatialite/rasterlite-how-to.pdf RasterLite HowTo]
| |
| | |
| {{Databáze}}
| |
| {{GIS}}
| |
| {{GFOSS}}
| |