.. _data: =============== Sample datasets =============== This section presents information about two sample datasets used in this documentation. The first dataset :ref:`dataset-prague` was developed for specific needs of this Gisquick publishing platform. Subsequently, the second dataset :ref:`dataset-natural-earth` was originally created by the developers of GIS.lab and was later adopted by the Gisquick project. .. _dataset-prague: Prague ------ Database ``prague.sqlite``. Downloadable as a `zip file `__. .. rubric:: Data source The data are sourced from open data `IPR `_ provided by *Prague Institute of Planning and Development*, open data `RÚIAN `_ supplied by the *Registry of Territorial Identification, Addresses and Real Estate*, data `DIBAVOD `_ provided by *T. G. Masaryk water research institute, public research institution* and from a great resource for free and openly licensed data, `OpenStreetMap (OSM) `_. Some statistics data are from `Czech statistical office `_. .. rubric:: Coordinate systems (Reference system) All data in Prague dataset use reference system S-JTSK Krovak East North (EPSG:5514). .. rubric:: Format and other key features Vector data come in Esri Shapefile format. Character encoding is Windows-1252. Raster data come in TIFF format. * *Extent:* ``50.3 (N), 49.9 (S), 14.8 (E), 14.2 (W)`` .. thumbnail:: ../img/qgis-prague.png Prague sample project loaded in QGIS. Thematic layers ^^^^^^^^^^^^^^^ **Administrative districts** - administrative boundaries in Prague. * *Layer name:* ``districts`` * *Storage type:* SQLite database * *Geometry type*: Polygon * *Attributes*: .. csv-table:: Attributes of the administrative districts layer. :header: "Name", "Description" :widths: 10, 10 "*code*", "code of district" "*name*", "name of district" **Air pollution** - bonita of climate in terms of air pollution (I - the best, V - the worse). * *Layer name:* ``air_pollution`` * *Storage type:* SQLite database * *Last update:* 01.01.2008 * *Geometry type*: Polygon * `Source `__ * *Attributes*: .. csv-table:: Attributes of the air pollution layer. :header: "Name", "Description" :widths: 10, 10 "*value*", "bonita of climate in terms of air pollution" **Basins** - hydrological structure, basins of IV. code. * *Layer name:* ``basins`` * *Storage type:* SQLite database * *Last update:* 06.04.2006 * *Geometry type*: Polygon * `Source `__ * *Attributes*: .. csv-table:: Attributes of the basins layer. :header: "Name", "Description" :widths: 10, 10 "*number*", "number of basin" "*area*", "area in square kilometer" **Bike routes** - cycling routes marked, registered and others. * *Layer name:* ``bike_routes`` * *Storage type:* SQLite database * *Last update:* 14.03.2016 * *Geometry type*: Polyline * *Spatial resolution:* `1:10000` * `Source `__, `metadata `__ * *Attributes*: .. csv-table:: Attributes of the bike routes layer. :header: "Name", "Description" :widths: 10, 10 "*number*", "number of route" "*state*", "traffic state" "*one_way*", "D means one-way route" **Bike signs** - bicycle transport signs for Prague 1 district. * *Layer name:* ``bike_signs`` * *Storage type:* SQLite database * *Last update:* 14.03.2016 * *Geometry type*: Point * *Spatial resolution:* `1:10000` * `Source `__, `metadata `__ * *Attributes*: .. csv-table:: Attributes of the bike signs layer. :header: "Name", "Description" :widths: 10, 10 "*type*", "type of sign" **Boundary region** - boundary of Prague region. * *Layer name:* ``boundary_region`` * *Storage type:* SQLite database * *Last update:* 04.05.2014 * *Geometry type*: Polygon * `Source `__ * *Attributes*: .. csv-table:: Attributes of the boundary region. :header: "Name", "Description" :widths: 10, 10 "*name*", "name of region" **Buildings** - classified 3D raster with absolute altitude of buildings. * *Layer name:* ``buildings`` * *Storage type:* SQLite database * *Spatial representation:* 3D grid * `Source `__ **Elevation** - digital terrain model (DTM) within the meaning of the bare surface. * *Layer name:* ``elevation`` * *Storage type:* SQLite database * *Last update:* 10.04.2015 * *Spatial representation:* 3D grid * *Spatial resolution:* 1:5000 * `Source `__ **Landuse** - landuse in 2016. * *Layer name:* ``landuse`` * *Storage type:* SQLite database * *Last update:* 24.02.2016 * *Spatial resolution:* 1:5000 * *Geometry type*: Polygon * `Source `__ * *Attributes*: .. csv-table:: Attributes of the landuse layer. :header: "Name", "Description" :widths: 10, 10 "*code*", "code of usage" **Orthophoto** - colored orthophoto of Prague 1 district. * *Layer name:* ``orthophoto`` * *Pixel resolution:* ``50 cm`` * *Storage type:* SQLite database * *Last update:* 10.12.2015 * *Spatial representation:* grid * `Source `__, `metadata `__ **Parcels** - polygons of the parcels for Prague 1 district. * *Layer name:* ``parcels`` * *Storage type:* SQLite database * *Last update:* 01.03.2016 * *Geometry type*: Polygon * *Spatial resolution:* `1:500` * `Source `__ * *Attributes*: .. csv-table:: Attributes of the parcels layer. :header: "Name", "Description" :widths: 10, 10 "*p_number*", "permanent parcel number" "*f_number*", "fractional parcel number" "*area*", "area in square meters" **Pharmacy** - pharmacies. * *Layer name:* ``pharmacy`` * *Geometry type*: Point * *Attributes*: .. csv-table:: Attributes of the pharmacy layer. :header: "Name", "Description" :widths: 10, 10 "*name*", "name of pharmacy" **Population statistics** - marriages, divorces, live births and deaths statistics for Prague districts in 2014. * *Layer name:* ``pop_statistics`` * *Data representation:* comma separated values file * *Last update*: 31.12.2014 * `Source `__ * *Attributes*: .. csv-table:: Selected population statistics. :header: "Name", "Description" :widths: 10, 10 "*district*", "name of district" "*marriages*", "marriages in 2014" "*divorces*", "divorces in 2014" "*live births*", "live births" "*deaths*", "deaths" **Prague 1** - boundary of Prague 1 district. * *Layer name:* ``prague_1`` * *Storage type:* SQLite database * *Geometry type*: Polygon * *Attributes*: .. csv-table:: Attributes of Prague 1 district layer. :header: "Name", "Description" :widths: 10, 10 "*code*", "code of district" "*name*", "name of district" **Public toilets** - public toilets. * *Layer name:* ``public_toilets`` * *Storage type:* SQLite database * *Last update:* 20.07.2015 * *Geometry type*: Point * `Source `__ * *Attributes*: .. csv-table:: Attributes of public toilets layer. :header: "Name", "Description" :widths: 10, 10 "*locality*", "the position or site of public toilet" "*address*", "address of public toilet" "*open*", "open hours" "*price*", "price for usage" "*invalid*", "1 for invalid toilet" **Public wifi** - WiFi facilities allowing to connect to the Internet within a particular area. * *Layer name:* ``public_wifi`` * *Geometry type*: Point * *Attributes*: .. csv-table:: Attributes of public WiFi layer. :header: "Name", "Description" :widths: 10, 10 "*wifi*", "more details about WiFi" **Railways** - railway lines. * *Layer name:* ``railways`` * *Geometry type*: Polyline * *Attributes*: .. csv-table:: Attributes of railways layer. :header: "Name", "Description" :widths: 10, 10 "*osm_id*", "OSM id" **Schools** - school buildings. * *Layer name:* ``schools`` * *Geometry type*: Point * *Attributes*: .. csv-table:: Attributes of schools layer. :header: "Name", "Description" :widths: 10, 10 "*name*", "name and type of school" **Streams** - water flow, flow model. * *Layer name:* ``streams`` * *Storage type:* SQLite database * *Last update:* 06.04.2006 * *Geometry type*: Polyline * `Source `__ * *Attributes*: .. csv-table:: Attributes of streams layer. :header: "Name", "Description" :widths: 10, 10 "*name*", "name of stream" **Streets** - roads and streets in Prague 1 district. * *Layer name:* ``streets`` * *Geometry type* : Polyline * *Storage type:* SQLite database * *Attributes*: .. csv-table:: Attributes of streets layer. :header: "Name", "Description" :widths: 10, 10 "*name*", "name of street" **Universities** - university buildings. * *Layer name:* ``universities`` * *Spatial representation:* vector * *Geometry type*: Point * *Attributes*: .. csv-table:: Attributes of universities layer. :header: "Name", "Description" :widths: 10, 10 "*name*", "name of university" **Zip codes** - address points from RUIAN. * *Layer name:* ``zipcodes`` * *Storage type:* SQLite database * *Attributes*: .. csv-table:: Attributes of zip code layer. :header: "Name", "Description" :widths: 10, 10 "*number*", "number of building" "*code*", "zip code" .. _dataset-natural-earth: Natural earth ------------- Database ``natural-earth.sqlite``. Available online from `GitHub repository `__ or directly as a `zip file `__. .. rubric:: Data source The data are sourced from `Natural Earth dataset `_. It is a public domain map dataset available at ``1:10 million``, ``1:50 million`` and ``1:110 million`` map scales. It is free for use in any type of project. Dataset was built through a collaboration of many volunteers, it is supported by *NACIS* - North American Cartographic Information Society and contains a series of vector and raster data. With Natural Earth one can make a variety of maps with all commonly-used cartography and GIS software. .. rubric:: Coordinate systems All Natural Earth data use the Geographic coordinate system WGS84 (EPSG:4326). .. rubric:: Format and other key features Natural Earth Vector comes in Esri Shapefile format. Character encoding is Windows-1252. Vector features include name attributes and bounding box extent. Natural Earth Raster comes in TIFF format with a TFW world file. Natural Earth is a very useful collection of data. Most of their attributes are equally important for map-making. They contain embedded feature names, which are ranked by relative importance. Other attributes facilitate faster map production, such as width attributes assigned to river segments for creating tapers, etc. .. thumbnail:: ../img/qgis-natural-earth.png Natural Earth sample project loaded in QGIS. Thematic layers ^^^^^^^^^^^^^^^ **Area** - matched boundary polygon for the area of interest (administrative areas). * *Layer name*: ``area`` * *Storage type*: SQLite database * *Geometry type*: Polygon **Countries** - matched boundary lines and polygons with various attributes for countries. * *Layer name*: ``countries`` * *Storage type*: SQLite database * *Geometry type*: Polygon * *Attributes*: .. csv-table:: Attributes of the country layer. :header: "Name", "Description" :widths: 10, 10 "*adm0_a3*", "country code" "*name*", "estimated total population" "*gdp_md_est*", "estimated total GDP in millions of dollars" "*subregion*", "part of a larger region or continent" **Places** - point symbols with name attributes. Includes DEM data, population data and other information (urban landscape). * *Layer name*: ``places`` * *Storage type*: SQLite database * *Geometry type*: Point * *Attributes*: .. csv-table:: Attributes of the places layer. :header: "Name", "Description" :widths: 10, 10 "*name*", "name of entity" "*adm0name*", "country name" "*adm0_a3*", "country code" "*adm1name*", "sub-country name" "*lattitude*", "latitude of the interior point (degrees)" "*longitude*", "longitude of the interior point (degrees)" "*pop_max*", "population for the metropolitan area" "*pop_min*", "population for the incorporated city" "*gtopo30*", "DEM with 30-arc second resolution" "*timezone*", "timezone" **Roads** - road lines with attributes. * *Layer name*: ``roads`` * *Storage type*: SQLite database * *Geometry type*: Polyline * *Attributes*: .. csv-table:: Attributes of the places layer. :header: "Name", "Description" :widths: 10, 10 "*type*", "type of road" "*length_km*", "road length (km)" "*label*", "label" "*local*", "local label" "*expressway*", "1 for expressway, 0 for other"