1. Home
  2. Datasets
  3. YLRE Katuosat viiva
To download the data set, please sign up or log in

YLRE Katuosat viiva

No description available for layer avoindata:YLRE_Katuosat_viiva (YLRE_Katuosat_viiva)

Tables

Column Descriptions

Ylre katuosat viivaline, Avoindataylre katuosat viiva, Latest

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 130909 and maximum value is 602535.
paakohde_t int Data source did not contain a description for paakohde_t. Column paakohde_t has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 26 and maximum value is 32.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Kalusteet ja leikkiväline... and first 25 characters of maximum string: Varusteet...
alakohde_t int Data source did not contain a description for alakohde_t. Column alakohde_t has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 238 and maximum value is 495.
alatyyppi string Data source did not contain a description for alatyyppi. Column alatyyppi has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Aidat and maximum string is Verkkoaita.
materiaali int Data source did not contain a description for materiaali. Column materiaali has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 82 and maximum value is 7256.
materiaal0 string Data source did not contain a description for materiaal0. Column materiaal0 has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Aco Drain tmv and maximum string is Verkkoaita.
rakenteell string Data source did not contain a description for rakenteell. Column rakenteell has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is HELEN and maximum string is Valtio, Ely-keskus.
talvikunno string Data source did not contain a description for talvikunno. Column talvikunno has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Ei talvikunnossapitoa and maximum string is Valtio, Ely-keskus.
tkp_kiiree string Data source did not contain a description for tkp_kiiree. Column is empty.
laatutaso int Data source did not contain a description for laatutaso. Column laatutaso has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 90.
yllapitolu string Data source did not contain a description for yllapitolu. Column yllapitolu has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is H1 and maximum string is KC3.
yllapitolk string Data source did not contain a description for yllapitolk. Column yllapitolk has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Edustuskatuvihreä and maximum string is Yleiskatuvihreä.
puhtaanapi string Data source did not contain a description for puhtaanapi. Column puhtaanapi has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Ei toimenpiteitä and maximum string is Valtio, Ely-keskus.
puhtaanap0 int Data source did not contain a description for puhtaanap0. Column puhtaanap0 has 3811 rows, out of which 171 are empty, making the null percent 4.49. Minimum value is 1 and maximum value is 5.
kadun_nimi string Data source did not contain a description for kadun_nimi. Column kadun_nimi has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is A03 and maximum string is Yrjö-Koskisen katu.
katualueen int Data source did not contain a description for katualueen. Column katualueen has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 64 and maximum value is 33021.
katualuee0 string Data source did not contain a description for katualuee0. Column katualuee0 has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Asuntokatu and maximum string is Tori.
kadunpitop date Data source did not contain a description for kadunpitop. Column is empty.
katualuee1 int Data source did not contain a description for katualuee1. Column katualuee1 has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 10 and maximum value is 9352.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 1264.
osan_pituu float Data source did not contain a description for osan_pituu. Column osan_pituu has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 788.5.
osan_levey int Data source did not contain a description for osan_levey. Column osan_levey has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 12.
osan_pinta int Data source did not contain a description for osan_pinta. Column osan_pinta has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 3451.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/YLRE.
paivitett0 date Data source did not contain a description for paivitett0. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: LINESTRING (24.8329856378... and first 25 characters of maximum string: LINESTRING (25.5218282597...
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 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_LINESTRING.

Ylre katuosat viivaline, Avoindataylre katuosat viiva, Full history

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 130909 and maximum value is 602535.
paakohde_t int Data source did not contain a description for paakohde_t. Column paakohde_t has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 26 and maximum value is 32.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Kalusteet ja leikkiväline... and first 25 characters of maximum string: Varusteet...
alakohde_t int Data source did not contain a description for alakohde_t. Column alakohde_t has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 238 and maximum value is 495.
alatyyppi string Data source did not contain a description for alatyyppi. Column alatyyppi has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Aidat and maximum string is Verkkoaita.
materiaali int Data source did not contain a description for materiaali. Column materiaali has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 82 and maximum value is 7256.
materiaal0 string Data source did not contain a description for materiaal0. Column materiaal0 has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Aco Drain tmv and maximum string is Verkkoaita.
rakenteell string Data source did not contain a description for rakenteell. Column rakenteell has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is HELEN and maximum string is Valtio, Ely-keskus.
talvikunno string Data source did not contain a description for talvikunno. Column talvikunno has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Ei talvikunnossapitoa and maximum string is Valtio, Ely-keskus.
tkp_kiiree string Data source did not contain a description for tkp_kiiree. Column is empty.
laatutaso int Data source did not contain a description for laatutaso. Column laatutaso has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 90.
yllapitolu string Data source did not contain a description for yllapitolu. Column yllapitolu has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is H1 and maximum string is KC3.
yllapitolk string Data source did not contain a description for yllapitolk. Column yllapitolk has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Edustuskatuvihreä and maximum string is Yleiskatuvihreä.
puhtaanapi string Data source did not contain a description for puhtaanapi. Column puhtaanapi has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Ei toimenpiteitä and maximum string is Valtio, Ely-keskus.
puhtaanap0 int Data source did not contain a description for puhtaanap0. Column puhtaanap0 has 3811 rows, out of which 171 are empty, making the null percent 4.49. Minimum value is 1 and maximum value is 5.
kadun_nimi string Data source did not contain a description for kadun_nimi. Column kadun_nimi has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is A03 and maximum string is Yrjö-Koskisen katu.
katualueen int Data source did not contain a description for katualueen. Column katualueen has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 64 and maximum value is 33021.
katualuee0 string Data source did not contain a description for katualuee0. Column katualuee0 has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Asuntokatu and maximum string is Tori.
kadunpitop date Data source did not contain a description for kadunpitop. Column is empty.
katualuee1 int Data source did not contain a description for katualuee1. Column katualuee1 has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 10 and maximum value is 9352.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 1 and maximum value is 1264.
osan_pituu float Data source did not contain a description for osan_pituu. Column osan_pituu has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 788.5.
osan_levey int Data source did not contain a description for osan_levey. Column osan_levey has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 12.
osan_pinta int Data source did not contain a description for osan_pinta. Column osan_pinta has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0 and maximum value is 3451.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/YLRE.
paivitett0 date Data source did not contain a description for paivitett0. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3811 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: LINESTRING (24.8329856378... and first 25 characters of maximum string: LINESTRING (25.5218282597...
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 3811 rows, out of which 0 are empty, making the null percent 0. 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 July 7, 2022
Created July 5, 2022