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

Tilapainen liikennejarjestely alue

No description available for layer avoindata:Tilapainen_liikennejarjestely_alue (Tilapainen_liikennejarjestely_alue)

Tables

Column Descriptions

Tilapainen liikennejarjestely aluepolygon, Avoindatatilapainen liikennejarjestely alue, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 142 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 142.
hakemus string Data source did not contain a description for hakemus. Column hakemus has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Tilapäinen liikennejärjes...
hakemuksen string Data source did not contain a description for hakemuksen. Column hakemuksen has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Muu and maximum string is Yleisötilaisuus.
hakemustun string Data source did not contain a description for hakemustun. Column hakemustun has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is LJ1800011 and maximum string is LJ2200082.
liikenneja date Data source did not contain a description for liikenneja. Column is empty.
liikennej0 date Data source did not contain a description for liikennej0. Column is empty.
tyon_tarko string Data source did not contain a description for tyon_tarko. Column tyon_tarko has 142 rows, out of which 3 are empty, making the null percent 2.11. First 25 characters of minimum string: ... and first 25 characters of maximum string: Väliaikainen ajoreitti ko...
osoite string Data source did not contain a description for osoite. Column osoite has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Alppipuisto... and first 25 characters of maximum string: Viilarintie-Roihuvuorenti...
kaupungino string Data source did not contain a description for kaupungino. Column kaupungino has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 10 SÖRNÄINEN and maximum string is 49 LAAJASALO.
status string Data source did not contain a description for status. Column status has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Käynnissä and maximum string is Tuleva.
hakija string Data source did not contain a description for hakija. Column hakija has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Bar 12 Vaasis Oy and maximum string is VRP Etelä-Suomi Oy.
geometryty string Data source did not contain a description for geometryty. Column geometryty has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_Polygon.
tyon_suori string Data source did not contain a description for tyon_suori. Column tyon_suori has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Bar 12 Vaasis Oy and maximum string is YIT Suomi Oy.
liikennej1 timestamp Data source did not contain a description for liikennej1. Column liikennej1 has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2016-10-31 00:00:00 and maximum value is 2022-09-23 00:00:00.
liikennej2 timestamp Data source did not contain a description for liikennej2. Column liikennej2 has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2021-11-10 00:00:00 and maximum value is 2028-06-04 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POLYGON ((24.844875 60.25... and first 25 characters of maximum string: POLYGON ((25.080824 60.22...
geom_center_x float Longitude of center. Column geom_center_x has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.84 and maximum value is 25.08.
geom_center_y float Latitude of center. Column geom_center_y has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.15 and maximum value is 60.26.
geom_type string Geometry type. Column geom_type has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POLYGON.

Tilapainen liikennejarjestely aluepolygon, Avoindatatilapainen liikennejarjestely alue, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 142 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 142.
hakemus string Data source did not contain a description for hakemus. Column hakemus has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Tilapäinen liikennejärjes...
hakemuksen string Data source did not contain a description for hakemuksen. Column hakemuksen has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Muu and maximum string is Yleisötilaisuus.
hakemustun string Data source did not contain a description for hakemustun. Column hakemustun has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is LJ1800011 and maximum string is LJ2200082.
liikenneja date Data source did not contain a description for liikenneja. Column is empty.
liikennej0 date Data source did not contain a description for liikennej0. Column is empty.
tyon_tarko string Data source did not contain a description for tyon_tarko. Column tyon_tarko has 142 rows, out of which 3 are empty, making the null percent 2.11. First 25 characters of minimum string: ... and first 25 characters of maximum string: Väliaikainen ajoreitti ko...
osoite string Data source did not contain a description for osoite. Column osoite has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Alppipuisto... and first 25 characters of maximum string: Viilarintie-Roihuvuorenti...
kaupungino string Data source did not contain a description for kaupungino. Column kaupungino has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is 10 SÖRNÄINEN and maximum string is 49 LAAJASALO.
status string Data source did not contain a description for status. Column status has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Käynnissä and maximum string is Tuleva.
hakija string Data source did not contain a description for hakija. Column hakija has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Bar 12 Vaasis Oy and maximum string is VRP Etelä-Suomi Oy.
geometryty string Data source did not contain a description for geometryty. Column geometryty has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_Polygon.
tyon_suori string Data source did not contain a description for tyon_suori. Column tyon_suori has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is Bar 12 Vaasis Oy and maximum string is YIT Suomi Oy.
liikennej1 timestamp Data source did not contain a description for liikennej1. Column liikennej1 has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2016-10-31 00:00:00 and maximum value is 2022-09-23 00:00:00.
liikennej2 timestamp Data source did not contain a description for liikennej2. Column liikennej2 has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 2021-11-10 00:00:00 and maximum value is 2028-06-04 00:00:00.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: POLYGON ((24.844875 60.25... and first 25 characters of maximum string: POLYGON ((25.080824 60.22...
geom_center_x float Longitude of center. Column geom_center_x has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.84 and maximum value is 25.08.
geom_center_y float Latitude of center. Column geom_center_y has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.15 and maximum value is 60.26.
geom_type string Geometry type. Column geom_type has 142 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 5, 2022
Created July 5, 2022