|
|
| Řádek 1: |
Řádek 1: |
| {{Upravit}} | | {{freegiswiki|RasterLite}} |
| [[Image:spatialite-logo.png|175px|right]]
| |
| '''[https://www.gaia-gis.it/fossil/librasterlite/index RasterLite]''' je rozšíření [[SpatiaLite]] pro uložení, manipulaci a analýzu rastrových dat v prostředí [[SQLite]].
| |
| __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://geo102.fsv.cvut.cz/zodh/2011/tiff/pardubice-1980/L4191025_02519840414_B10.TIF
| |
| | |
| Data naimportujeme pomocí nástroje <tt>rasterlite_load</tt>.
| |
| | |
| rasterlite_load -d gisdb.sqlite -T landsat_b10 -f L4191025_02519840414_B10.TIF -i TIFF
| |
| | |
| Příklad jednoduchého dotazu.
| |
| | |
| <source lang="sql">
| |
| SELECT tile_id, AsText(geometry) FROM landsat_b10_metadata
| |
| WHERE NOT IsEmpty(geometry) LIMIT 3;
| |
| </source>
| |
| | |
| <pre>
| |
| tile_id|AsText(geometry)
| |
| 0|POLYGON((403080 5679180, 433140 5679180, 433140 5652120, 403080 5652120, 403080 5679180))
| |
| 1|POLYGON((433140 5679180, 463200 5679180, 463200 5652120, 433140 5652120, 433140 5679180))
| |
| 2|POLYGON((463200 5679180, 493260 5679180, 493260 5652120, 463200 5652120, 463200 5679180))
| |
| </pre>
| |
| | |
| V databázi se vytvoří dvě tabulky
| |
| | |
| * <tt>landsat_b10_rasters</tt> - binární data dlaždic
| |
| * <tt>landsat_b10_metadata</tt> - metadata dlaždic
| |
| | |
| <source lang=sql>
| |
| SELECT * FROM landsat_b10_rasters LIMIT 3;
| |
| </source>
| |
| | |
| <pre>
| |
| id|raster
| |
| 1 |II*
| |
| 2 |II*
| |
| 3 |II*
| |
| </pre>
| |
| | |
| <source lang=sql>
| |
| SELECT * FROM landsat_b10_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 L4191025_025198 0 501 451 60.0 60.0
| |
| 2 L4191025_025198 1 501 451 60.0 60.0
| |
| </pre>
| |
| | |
| == Související články ==
| |
| | |
| * [[SpatiaLite]]
| |
| * [[PostGIS Raster]]
| |
| | |
| == Externí odkazy ==
| |
| | |
| * [https://www.gaia-gis.it/fossil/librasterlite/index librasterlite]
| |
| * [http://www.gaia-gis.it/gaia-sins/rasterlite-docs/rasterlite-man.pdf RasterLite Manual]
| |
| * [http://www.gaia-gis.it/gaia-sins/rasterlite-docs/rasterlite-how-to.pdf RasterLite HowTo]
| |
| | |
| {{Databáze}}
| |
| {{GIS}}
| |
| {{GFOSS}}
| |
