1. Home
  2. Datasets
  3. YLRE Katu ja viherosat ...
To download the data set, please sign up or log in

YLRE Katu ja viherosat eiliikenne piste

No description available for layer avoindata:YLRE_Katu_ja_viherosat_eiliikenne_piste (YLRE_Katu_ja_viherosat_eiliikenne_piste)

Tables

Column Descriptions

Ylre katu ja viherosat eiliikenne pistepoint, Avoindataylre katu ja viherosat eiliikenne piste, Latest

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 204957 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 204957 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 204957 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 204957 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 204957 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Haudat puistoissa and maximum string is Yleisökäymälä.
materiaali int Data source did not contain a description for materiaali. Column materiaali has 204957 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 8536.
materiaal0 string Data source did not contain a description for materiaal0. Column materiaal0 has 204957 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 204957 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 204957 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 204957 rows, out of which 204856 are empty, making the null percent 99.95. Minimum string is and maximum string is C - hoitotapa.
viher_hoit int Data source did not contain a description for viher_hoit. Column viher_hoit has 204957 rows, out of which 121136 are empty, making the null percent 59.1. Minimum value is 1 and maximum value is 2401.
laatutaso float Data source did not contain a description for laatutaso. Column laatutaso has 204957 rows, out of which 83821 are empty, making the null percent 40.9. Minimum value is 1 and maximum value is 93.
yllapidon string Data source did not contain a description for yllapidon. Column yllapidon has 204957 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is A1 and maximum string is KC3.
yllapidon0 string Data source did not contain a description for yllapidon0. Column yllapidon0 has 204957 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 204957 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 204957 rows, out of which 2554 are empty, making the null percent 1.25. Minimum value is 1 and maximum value is 5.
aluetieto string Data source did not contain a description for aluetieto. Column aluetieto has 204957 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Katu and maximum string is Viher.
alueen_nim string Data source did not contain a description for alueen_nim. Column alueen_nim has 204957 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.
alueen_kay string Data source did not contain a description for alueen_kay. Column alueen_kay has 204957 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Asemakaavoitettu viheralu... and first 25 characters of maximum string: Yleiskaavan viheralue / v...
viheraluee int Data source did not contain a description for viheraluee. Column viheraluee has 204957 rows, out of which 121136 are empty, making the null percent 59.1. Minimum value is 401 and maximum value is 255761.
viheralue0 int Data source did not contain a description for viheralue0. Column viheralue0 has 204957 rows, out of which 121136 are empty, making the null percent 59.1. Minimum value is 21 and maximum value is 11232.
katualueen float Data source did not contain a description for katualueen. Column katualueen has 204957 rows, out of which 83821 are empty, making the null percent 40.9. Minimum value is 41 and maximum value is 33161.
katualuee0 float Data source did not contain a description for katualuee0. Column katualuee0 has 204957 rows, out of which 83821 are empty, making the null percent 40.9. Minimum value is 1 and maximum value is 9375.
kadunpitop date Data source did not contain a description for kadunpitop. Column is empty.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 204957 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 204957 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 204957 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 1000.
osan_pinta int Data source did not contain a description for osan_pinta. Column osan_pinta has 204957 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 204957 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 204957 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.82714089547534 ... and first 25 characters of maximum string: POINT (25.521828259732487...
geom_center_x float Longitude of center. Column geom_center_x has 204957 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.52.
geom_center_y float Latitude of center. Column geom_center_y has 204957 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.11 and maximum value is 64.58.
geom_type string Geometry type. Column geom_type has 204957 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 katu ja viherosat eiliikenne pistepoint, Avoindataylre katu ja viherosat eiliikenne piste, Full history

Column Type Comment
osan_id int Data source did not contain a description for osan_id. Column osan_id has 204957 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 204957 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 204957 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 204957 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 204957 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Haudat puistoissa and maximum string is Yleisökäymälä.
materiaali int Data source did not contain a description for materiaali. Column materiaali has 204957 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 8536.
materiaal0 string Data source did not contain a description for materiaal0. Column materiaal0 has 204957 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 204957 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 204957 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 204957 rows, out of which 204856 are empty, making the null percent 99.95. Minimum string is and maximum string is C - hoitotapa.
viher_hoit int Data source did not contain a description for viher_hoit. Column viher_hoit has 204957 rows, out of which 121136 are empty, making the null percent 59.1. Minimum value is 1 and maximum value is 2401.
laatutaso float Data source did not contain a description for laatutaso. Column laatutaso has 204957 rows, out of which 83821 are empty, making the null percent 40.9. Minimum value is 1 and maximum value is 93.
yllapidon string Data source did not contain a description for yllapidon. Column yllapidon has 204957 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is A1 and maximum string is KC3.
yllapidon0 string Data source did not contain a description for yllapidon0. Column yllapidon0 has 204957 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 204957 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 204957 rows, out of which 2554 are empty, making the null percent 1.25. Minimum value is 1 and maximum value is 5.
aluetieto string Data source did not contain a description for aluetieto. Column aluetieto has 204957 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Katu and maximum string is Viher.
alueen_nim string Data source did not contain a description for alueen_nim. Column alueen_nim has 204957 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.
alueen_kay string Data source did not contain a description for alueen_kay. Column alueen_kay has 204957 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Asemakaavoitettu viheralu... and first 25 characters of maximum string: Yleiskaavan viheralue / v...
viheraluee int Data source did not contain a description for viheraluee. Column viheraluee has 204957 rows, out of which 121136 are empty, making the null percent 59.1. Minimum value is 401 and maximum value is 255761.
viheralue0 int Data source did not contain a description for viheralue0. Column viheralue0 has 204957 rows, out of which 121136 are empty, making the null percent 59.1. Minimum value is 21 and maximum value is 11232.
katualueen float Data source did not contain a description for katualueen. Column katualueen has 204957 rows, out of which 83821 are empty, making the null percent 40.9. Minimum value is 41 and maximum value is 33161.
katualuee0 float Data source did not contain a description for katualuee0. Column katualuee0 has 204957 rows, out of which 83821 are empty, making the null percent 40.9. Minimum value is 1 and maximum value is 9375.
kadunpitop date Data source did not contain a description for kadunpitop. Column is empty.
osan_nro int Data source did not contain a description for osan_nro. Column osan_nro has 204957 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 204957 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 204957 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 1000.
osan_pinta int Data source did not contain a description for osan_pinta. Column osan_pinta has 204957 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 204957 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 204957 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.82714089547534 ... and first 25 characters of maximum string: POINT (25.521828259732487...
geom_center_x float Longitude of center. Column geom_center_x has 204957 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.52.
geom_center_y float Latitude of center. Column geom_center_y has 204957 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.11 and maximum value is 64.58.
geom_type string Geometry type. Column geom_type has 204957 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