To download the data set, please sign up or log in

Lipas 4403 kavelyreitti

Lipas 4403 kavelyreitti

Tables

Column Descriptions

Lipas 4403 Kavelyreitti, Lipaslipas 4403 Kavelyreitti

Column Type Comment
id int Data source did not contain a description for id. Column id has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 95509 and maximum value is 529826.
nimi_fi string Data source did not contain a description for nimi_fi. Column nimi_fi has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ahvenlammen lenkki... and first 25 characters of maximum string: Utran saarten ulkoilualue...
nimi_se string Data source did not contain a description for nimi_se. Column nimi_se has 1489 rows, out of which 917 are empty, making the null percent 61.58. First 25 characters of minimum string: ... and first 25 characters of maximum string: Luk - Kalajärvi - Juvamal...
nimi_en string Data source did not contain a description for nimi_en. Column nimi_en has 1489 rows, out of which 1402 are empty, making the null percent 94.16. Minimum string is and maximum string is Riippusiltojen reitti.
sahkoposti string Data source did not contain a description for sahkoposti. Column sahkoposti has 1489 rows, out of which 789 are empty, making the null percent 52.99. Minimum string is and maximum string is kitee@kitee.fi.
www string Data source did not contain a description for www. Column www has 1489 rows, out of which 261 are empty, making the null percent 17.53. First 25 characters of minimum string: ... and first 25 characters of maximum string: www.joensuu.fi/ulkoilujar...
puhelinnum int Data source did not contain a description for puhelinnum. Column puhelinnum has 1489 rows, out of which 1396 are empty, making the null percent 93.75. Minimum value is 2129 and maximum value is 500575594.
koulun_lii string Data source did not contain a description for koulun_lii. Column koulun_lii has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ? and maximum string is F.
vapaa_kayt string Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ? and maximum string is T.
rakennusvu int Data source did not contain a description for rakennusvu. Column rakennusvu has 1489 rows, out of which 1104 are empty, making the null percent 74.14. Minimum value is 1962 and maximum value is 2018.
peruskorja int Data source did not contain a description for peruskorja. Column peruskorja has 1489 rows, out of which 1435 are empty, making the null percent 96.37. Minimum value is 2010 and maximum value is 2014.
omistaja string Data source did not contain a description for omistaja. Column omistaja has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Kunta.
yllapitaja string Data source did not contain a description for yllapitaja. Column yllapitaja has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Yksityinen / yhdistys.
katuosoite string Data source did not contain a description for katuosoite. Column katuosoite has 1489 rows, out of which 31 are empty, making the null percent 2.08. Minimum string is and maximum string is Utrantie.
postinumer int Data source did not contain a description for postinumer. Column postinumer has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 250 and maximum value is 701260.
postitoimi string Data source did not contain a description for postitoimi. Column postitoimi has 1489 rows, out of which 227 are empty, making the null percent 15.25. Minimum string is and maximum string is Joensuu.
kunta_nimi string Data source did not contain a description for kunta_nimi. Column kunta_nimi has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Enontekiö and maximum string is Joensuu.
kuntanumer int Data source did not contain a description for kuntanumer. Column kuntanumer has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 47 and maximum value is 992.
kuntaosa string Data source did not contain a description for kuntaosa. Column kuntaosa has 1489 rows, out of which 737 are empty, making the null percent 49.50. Minimum string is and maximum string is Utra.
tyyppikood int Data source did not contain a description for tyyppikood. Column tyyppikood has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4403.
tyyppi_nim string Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kävelyreitti/ulkoilureitt...
muokattu_v date Data source did not contain a description for muokattu_v. Column is empty.
reitti_id int Data source did not contain a description for reitti_id. Column reitti_id has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 33463 and maximum value is 508222.
valaistua float Data source did not contain a description for valaistua. Column valaistua has 1489 rows, out of which 827 are empty, making the null percent 55.54. Minimum value is 0.00 and maximum value is 40.00.
yleiso_wc boolean Data source did not contain a description for yleiso_wc.
pintamater string Data source did not contain a description for pintamater. Column pintamater has 1489 rows, out of which 584 are empty, making the null percent 39.22. Minimum string is and maximum string is Sora.
lisatieto string Data source did not contain a description for lisatieto. Column lisatieto has 1489 rows, out of which 451 are empty, making the null percent 30.29. First 25 characters of minimum string: ... and first 25 characters of maximum string: Maastopyöräilyyn, kävelyy...
taukopaika int Data source did not contain a description for taukopaika. Column taukopaika has 1489 rows, out of which 1149 are empty, making the null percent 77.17. Minimum value is 0 and maximum value is 13.
pintamate0 string Data source did not contain a description for pintamate0. Column pintamate0 has 1489 rows, out of which 1182 are empty, making the null percent 79.38. Minimum string is and maximum string is hiekka.
kuntoilute boolean Data source did not contain a description for kuntoilute.
saa_julkai boolean Data source did not contain a description for saa_julkai.
esteettomy string Data source did not contain a description for esteettomy. Column esteettomy has 1489 rows, out of which 1129 are empty, making the null percent 75.82. Minimum string is and maximum string is estettön.
reitin_pit float Data source did not contain a description for reitin_pit. Column reitin_pit has 1489 rows, out of which 191 are empty, making the null percent 12.83. Minimum value is 0.16 and maximum value is 900.00.
reitin_lev int Data source did not contain a description for reitin_lev. Column reitin_lev has 1489 rows, out of which 1340 are empty, making the null percent 89.99. Minimum value is 1 and maximum value is 7.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (20.2547534142... and first 25 characters of maximum string: LINESTRING (29.8678365249...
geom_center_x float Longitude of center. Column is empty.
geom_center_y float Latitude of center. Column is empty.
geom_type string Geometry type. Column geom_type has 1489 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated May 5, 2019
Created June 16, 2018