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

Varoitusvalot piste

No description available for layer avoindata:Varoitusvalot_piste (Varoitusvalot_piste)

Tables

Column Descriptions

Varoitusvalot pistepoint, Avoindatavaroitusvalot piste, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 11 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 13.
numero int Data source did not contain a description for numero. Column numero has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 902 and maximum value is 947.
tyyppi string Data source did not contain a description for tyyppi. Column tyyppi has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Varoitusvalot.
risteys string Data source did not contain a description for risteys. Column risteys has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Albertinkatu... and first 25 characters of maximum string: Töölönkatu/Sibeliuksenkat...
lisatiedot string Data source did not contain a description for lisatiedot. Column lisatiedot has 11 rows, out of which 3 are empty, making the null percent 27.27. First 25 characters of minimum string: ... and first 25 characters of maximum string: Raitiovaunun varoitusvalo...
datanomist string Data source did not contain a description for datanomist. Column datanomist has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/MAKA.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 11 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.875760774182837... and first 25 characters of maximum string: POINT (24.962325715144082...
geom_center_x float Longitude of center. Column geom_center_x has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.88 and maximum value is 24.96.
geom_center_y float Latitude of center. Column geom_center_y has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.16 and maximum value is 60.2.
geom_type string Geometry type. Column geom_type has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POINT.

Varoitusvalot pistepoint, Avoindatavaroitusvalot piste, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 11 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 13.
numero int Data source did not contain a description for numero. Column numero has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 902 and maximum value is 947.
tyyppi string Data source did not contain a description for tyyppi. Column tyyppi has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Varoitusvalot.
risteys string Data source did not contain a description for risteys. Column risteys has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Albertinkatu... and first 25 characters of maximum string: Töölönkatu/Sibeliuksenkat...
lisatiedot string Data source did not contain a description for lisatiedot. Column lisatiedot has 11 rows, out of which 3 are empty, making the null percent 27.27. First 25 characters of minimum string: ... and first 25 characters of maximum string: Raitiovaunun varoitusvalo...
datanomist string Data source did not contain a description for datanomist. Column datanomist has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/MAKA.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 11 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.875760774182837... and first 25 characters of maximum string: POINT (24.962325715144082...
geom_center_x float Longitude of center. Column geom_center_x has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.88 and maximum value is 24.96.
geom_center_y float Latitude of center. Column geom_center_y has 11 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.16 and maximum value is 60.2.
geom_type string Geometry type. Column geom_type has 11 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 August 2, 2022
Created July 7, 2022