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

Opaskartta alueenviiva

No description available for layer avoindata:Opaskartta_alueenviiva (Opaskartta_alueenviiva)

Tables

Column Descriptions

Opaskartta alueenviivaline, Avoindataopaskartta alueenviiva, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 33389 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 35042.
tyyppi string Data source did not contain a description for tyyppi. Column tyyppi has 33389 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is hallinnollinen alue and maximum string is vesistö.
luokka string Data source did not contain a description for luokka. Column luokka has 33389 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is allas and maximum string is virtaussuunnan nuoli.
kunta int Data source did not contain a description for kunta. Column kunta has 33389 rows, out of which 732 are empty, making the null percent 2.19. Constant value is 91.
voimassaol string Data source did not contain a description for voimassaol. Column voimassaol has 33389 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is suunnitteilla and maximum string is voimassa.
luontipvm date Data source did not contain a description for luontipvm. Column is empty.
muokkauspv date Data source did not contain a description for muokkauspv. Column is empty.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 33389 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/KAMI.
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 33389 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.7966769393... and first 25 characters of maximum string: LINESTRING (25.2496655110...
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 33389 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.

Opaskartta alueenviivaline, Avoindataopaskartta alueenviiva, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 33389 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 35042.
tyyppi string Data source did not contain a description for tyyppi. Column tyyppi has 33389 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is hallinnollinen alue and maximum string is vesistö.
luokka string Data source did not contain a description for luokka. Column luokka has 33389 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is allas and maximum string is virtaussuunnan nuoli.
kunta int Data source did not contain a description for kunta. Column kunta has 33389 rows, out of which 732 are empty, making the null percent 2.19. Constant value is 91.
voimassaol string Data source did not contain a description for voimassaol. Column voimassaol has 33389 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is suunnitteilla and maximum string is voimassa.
luontipvm date Data source did not contain a description for luontipvm. Column is empty.
muokkauspv date Data source did not contain a description for muokkauspv. Column is empty.
datanomist string Data source did not contain a description for datanomist. Column datanomist has 33389 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/KAMI.
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 33389 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.7966769393... and first 25 characters of maximum string: LINESTRING (25.2496655110...
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 33389 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_LINESTRING.

Additional Info

Last Updated July 4, 2022
Created July 4, 2022