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

YLRE Katuosat piste

No description available for layer avoindata:YLRE_Katuosat_piste (YLRE_Katuosat_piste)

Tables

Column Descriptions

Ylre katuosat pistepoint, Avoindataylre katuosat piste, Latest

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 124586 and maximum value is 606125.
paakohde_t int Data source did not contain a description for paakohde_t. Column paakohde_t has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24 and maximum value is 32.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Erityiskohteet and maximum string is Varusteet.
alakohde_t int Data source did not contain a description for alakohde_t. Column alakohde_t has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60 and maximum value is 515.
alatyyppi string Data source did not contain a description for alatyyppi. Column alatyyppi has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Havupuu and maximum string is Yleisökäymälä.
materiaali int Data source did not contain a description for materiaali. Column materiaali has 121136 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 8496.
materiaal0 string Data source did not contain a description for materiaal0. Column materiaal0 has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: "Luonnonsuojelualue" kylt... and first 25 characters of maximum string: Victor Stanley...
rakenteell string Data source did not contain a description for rakenteell. Column rakenteell has 121136 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 YTV.
talvikunno string Data source did not contain a description for talvikunno. Column talvikunno has 121136 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 tkp_kiiree has 121136 rows, out of which 121115 are empty, making the null percent 99.98. Minimum string is and maximum string is C - hoitotapa.
laatutaso int Data source did not contain a description for laatutaso. Column laatutaso has 121136 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 93.
yllapitolu string Data source did not contain a description for yllapitolu. Column yllapitolu has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is B2 and maximum string is KC3.
yllapitolk string Data source did not contain a description for yllapitolk. Column yllapitolk has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Arvometsä and maximum string is Yleiskatuvihreä.
puhtaanapi string Data source did not contain a description for puhtaanapi. Column puhtaanapi has 121136 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 YTV.
puhtaanap0 int Data source did not contain a description for puhtaanap0. Column puhtaanap0 has 121136 rows, out of which 1131 are empty, making the null percent 0.93. 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 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is A.I.Virtasen aukio and maximum string is Örskintie.
katualueen int Data source did not contain a description for katualueen. Column katualueen has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 41 and maximum value is 33161.
katualuee0 string Data source did not contain a description for katualuee0. Column katualuee0 has 121136 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 121136 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 9375.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 121136 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 10116.
osan_pituu int Data source did not contain a description for osan_pituu. Column osan_pituu has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Constant value is 0.
osan_levey int Data source did not contain a description for osan_levey. Column osan_levey has 121136 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 36.
osan_pinta int Data source did not contain a description for osan_pinta. Column osan_pinta has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Constant value is 0.
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 121136 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 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POINT (24.83268271587638 ... and first 25 characters of maximum string: POINT (25.2305178988335 6...
geom_center_x float Longitude of center. Column geom_center_x has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.83 and maximum value is 25.23.
geom_center_y float Latitude of center. Column geom_center_y has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.14 and maximum value is 60.29.
geom_type string Geometry type. Column geom_type has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT.

Ylre katuosat pistepoint, Avoindataylre katuosat piste, Full history

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 124586 and maximum value is 606125.
paakohde_t int Data source did not contain a description for paakohde_t. Column paakohde_t has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24 and maximum value is 32.
paatyyppi string Data source did not contain a description for paatyyppi. Column paatyyppi has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Erityiskohteet and maximum string is Varusteet.
alakohde_t int Data source did not contain a description for alakohde_t. Column alakohde_t has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60 and maximum value is 515.
alatyyppi string Data source did not contain a description for alatyyppi. Column alatyyppi has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Havupuu and maximum string is Yleisökäymälä.
materiaali int Data source did not contain a description for materiaali. Column materiaali has 121136 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 8496.
materiaal0 string Data source did not contain a description for materiaal0. Column materiaal0 has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: "Luonnonsuojelualue" kylt... and first 25 characters of maximum string: Victor Stanley...
rakenteell string Data source did not contain a description for rakenteell. Column rakenteell has 121136 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 YTV.
talvikunno string Data source did not contain a description for talvikunno. Column talvikunno has 121136 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 tkp_kiiree has 121136 rows, out of which 121115 are empty, making the null percent 99.98. Minimum string is and maximum string is C - hoitotapa.
laatutaso int Data source did not contain a description for laatutaso. Column laatutaso has 121136 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 93.
yllapitolu string Data source did not contain a description for yllapitolu. Column yllapitolu has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is B2 and maximum string is KC3.
yllapitolk string Data source did not contain a description for yllapitolk. Column yllapitolk has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Arvometsä and maximum string is Yleiskatuvihreä.
puhtaanapi string Data source did not contain a description for puhtaanapi. Column puhtaanapi has 121136 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 YTV.
puhtaanap0 int Data source did not contain a description for puhtaanap0. Column puhtaanap0 has 121136 rows, out of which 1131 are empty, making the null percent 0.93. 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 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is A.I.Virtasen aukio and maximum string is Örskintie.
katualueen int Data source did not contain a description for katualueen. Column katualueen has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 41 and maximum value is 33161.
katualuee0 string Data source did not contain a description for katualuee0. Column katualuee0 has 121136 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 121136 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 9375.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 121136 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 10116.
osan_pituu int Data source did not contain a description for osan_pituu. Column osan_pituu has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Constant value is 0.
osan_levey int Data source did not contain a description for osan_levey. Column osan_levey has 121136 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 36.
osan_pinta int Data source did not contain a description for osan_pinta. Column osan_pinta has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Constant value is 0.
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 121136 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 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POINT (24.83268271587638 ... and first 25 characters of maximum string: POINT (25.2305178988335 6...
geom_center_x float Longitude of center. Column geom_center_x has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.83 and maximum value is 25.23.
geom_center_y float Latitude of center. Column geom_center_y has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.14 and maximum value is 60.29.
geom_type string Geometry type. Column geom_type has 121136 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 7, 2022
Created July 7, 2022