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

Lipas 4451 melontareitti

Lipas 4451 melontareitti

Tables

Column Descriptions

Lipas 4451 melontareitti, Lipaslipas 4451 melontareitti, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 97077 and maximum value is 603823.
nimi_fi string Data source did not contain a description for nimi_fi. Column nimi_fi has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alajoen melontareitti... and first 25 characters of maximum string: Ärjän kierto (Neuvosennie...
nimi_se string Data source did not contain a description for nimi_se. Column nimi_se has 615 rows, out of which 601 are empty, making the null percent 97.72. First 25 characters of minimum string: ... and first 25 characters of maximum string: Wanha Witonen Paddlingsru...
nimi_en string Data source did not contain a description for nimi_en. Column nimi_en has 615 rows, out of which 586 are empty, making the null percent 95.28. Minimum string is and maximum string is Vaikkojoen vesireitti.
sahkoposti string Data source did not contain a description for sahkoposti. Column sahkoposti has 615 rows, out of which 584 are empty, making the null percent 94.96. Minimum string is and maximum string is matkailu@sulkava.fi.
www string Data source did not contain a description for www. Column www has 615 rows, out of which 308 are empty, making the null percent 50.08. Minimum string is and maximum string is www.paltamo.fi.
puhelinnum string Data source did not contain a description for puhelinnum. Column puhelinnum has 615 rows, out of which 511 are empty, making the null percent 83.09. Minimum string is and maximum string is 057583111.
koulun_lii string Data source did not contain a description for koulun_lii. Column koulun_lii has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ?.
vapaa_kayt string Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 615 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 615 rows, out of which 394 are empty, making the null percent 64.07. Minimum value is 1970 and maximum value is 2020.
peruskorja string Data source did not contain a description for peruskorja. Column is empty.
omistaja string Data source did not contain a description for omistaja. Column omistaja has 615 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 Yritys.
yllapitaja string Data source did not contain a description for yllapitaja. Column yllapitaja has 615 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 / yritys.
katuosoite string Data source did not contain a description for katuosoite. Column katuosoite has 615 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 Yläneenjoki.
postinumer int Data source did not contain a description for postinumer. Column postinumer has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1510 and maximum value is 99720.
postitoimi string Data source did not contain a description for postitoimi. Column postitoimi has 615 rows, out of which 94 are empty, making the null percent 15.28. Minimum string is and maximum string is Yläne.
kunta_nimi string Data source did not contain a description for kunta_nimi. Column kunta_nimi has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hartola and maximum string is Ylöjärvi.
kuntanumer int Data source did not contain a description for kuntanumer. Column kuntanumer has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 81 and maximum value is 980.
kuntaosa string Data source did not contain a description for kuntaosa. Column kuntaosa has 615 rows, out of which 583 are empty, making the null percent 94.80. Minimum string is and maximum string is Päijälä.
tyyppikood int Data source did not contain a description for tyyppikood. Column tyyppikood has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4451.
tyyppi_nim string Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Melontareitti.
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 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 35211 and maximum value is 512564.
saa_julkai boolean Data source did not contain a description for saa_julkai.
taukopaika int Data source did not contain a description for taukopaika. Column taukopaika has 615 rows, out of which 414 are empty, making the null percent 67.32. Minimum value is 1 and maximum value is 30.
lisatieto string Data source did not contain a description for lisatieto. Column lisatieto has 615 rows, out of which 169 are empty, making the null percent 27.48. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yläosa on melottavissa yl...
reitin_pit float Data source did not contain a description for reitin_pit. Column reitin_pit has 615 rows, out of which 49 are empty, making the null percent 7.97. Minimum value is 1.50 and maximum value is 115.00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 615 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 (21.8366873627... and first 25 characters of maximum string: LINESTRING (30.7768393326...
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 615 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.

Lipas 4451 melontareitti, Lipaslipas 4451 melontareitti, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 97077 and maximum value is 603823.
nimi_fi string Data source did not contain a description for nimi_fi. Column nimi_fi has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alajoen melontareitti... and first 25 characters of maximum string: Ärjän kierto (Neuvosennie...
nimi_se string Data source did not contain a description for nimi_se. Column nimi_se has 615 rows, out of which 601 are empty, making the null percent 97.72. First 25 characters of minimum string: ... and first 25 characters of maximum string: Wanha Witonen Paddlingsru...
nimi_en string Data source did not contain a description for nimi_en. Column nimi_en has 615 rows, out of which 586 are empty, making the null percent 95.28. Minimum string is and maximum string is Vaikkojoen vesireitti.
sahkoposti string Data source did not contain a description for sahkoposti. Column sahkoposti has 615 rows, out of which 584 are empty, making the null percent 94.96. Minimum string is and maximum string is matkailu@sulkava.fi.
www string Data source did not contain a description for www. Column www has 615 rows, out of which 308 are empty, making the null percent 50.08. Minimum string is and maximum string is www.paltamo.fi.
puhelinnum string Data source did not contain a description for puhelinnum. Column puhelinnum has 615 rows, out of which 511 are empty, making the null percent 83.09. Minimum string is and maximum string is 057583111.
koulun_lii string Data source did not contain a description for koulun_lii. Column koulun_lii has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ?.
vapaa_kayt string Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 615 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 615 rows, out of which 394 are empty, making the null percent 64.07. Minimum value is 1970 and maximum value is 2020.
peruskorja string Data source did not contain a description for peruskorja. Column is empty.
omistaja string Data source did not contain a description for omistaja. Column omistaja has 615 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 Yritys.
yllapitaja string Data source did not contain a description for yllapitaja. Column yllapitaja has 615 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 / yritys.
katuosoite string Data source did not contain a description for katuosoite. Column katuosoite has 615 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 Yläneenjoki.
postinumer int Data source did not contain a description for postinumer. Column postinumer has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1510 and maximum value is 99720.
postitoimi string Data source did not contain a description for postitoimi. Column postitoimi has 615 rows, out of which 94 are empty, making the null percent 15.28. Minimum string is and maximum string is Yläne.
kunta_nimi string Data source did not contain a description for kunta_nimi. Column kunta_nimi has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hartola and maximum string is Ylöjärvi.
kuntanumer int Data source did not contain a description for kuntanumer. Column kuntanumer has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 81 and maximum value is 980.
kuntaosa string Data source did not contain a description for kuntaosa. Column kuntaosa has 615 rows, out of which 583 are empty, making the null percent 94.80. Minimum string is and maximum string is Päijälä.
tyyppikood int Data source did not contain a description for tyyppikood. Column tyyppikood has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4451.
tyyppi_nim string Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Melontareitti.
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 615 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 35211 and maximum value is 512564.
saa_julkai boolean Data source did not contain a description for saa_julkai.
taukopaika int Data source did not contain a description for taukopaika. Column taukopaika has 615 rows, out of which 414 are empty, making the null percent 67.32. Minimum value is 1 and maximum value is 30.
lisatieto string Data source did not contain a description for lisatieto. Column lisatieto has 615 rows, out of which 169 are empty, making the null percent 27.48. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yläosa on melottavissa yl...
reitin_pit float Data source did not contain a description for reitin_pit. Column reitin_pit has 615 rows, out of which 49 are empty, making the null percent 7.97. Minimum value is 1.50 and maximum value is 115.00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 615 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 (21.8366873627... and first 25 characters of maximum string: LINESTRING (30.7768393326...
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 615 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.

Additional Info

Last Updated September 11, 2020
Created September 23, 2018