.. _data: =============== Sample datasets =============== Some basic information about our data aiming to be a part of examples introduced in this documentation. This section presents two sample datasets. The first one :ref:`dataset-natural-earth` has been original created by GIS.lab developers and later adopted by Gisquick project. Subsequently, the second dataset :ref:`dataset-prague` was developed for specific needs of Gisquick publishing platform. .. _dataset-natural-earth: Natural earth ------------- Database ``natural-earth.sqlite``. Available online from `GitHub repository `__ or directly as `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 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 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 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 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 interior point (degrees)" "*longitude*", "longitude of 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 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" .. _dataset-prague: Prague ------ Database ``prague.sqlite``. Downloadable as `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 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 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 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 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 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 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 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 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 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 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"