1. Home
  2. Datasets
  3. OpenAhjo-päätökset
To download the data set, please sign up or log in

OpenAhjo-päätökset

OpenAhjo-päätökset

Tables

Column Descriptions

Openahjo agenda itemspolygon, Helopenahjo agenda items, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2363 and maximum value is 72747.
register_i string Data source did not contain a description for register_i. Column register_i has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HEL 2011-000055 and maximum string is HEL 2016-011280.
subject string Data source did not contain a description for subject. Column subject has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ajoyhteyttä ja johtojen s... and first 25 characters of maximum string: Zaidankadun alueen johtos...
policymake string Data source did not contain a description for policymake. Column policymake has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 021400VH1 and maximum string is Zoojk.
meeting_da date Data source did not contain a description for meeting_da. Column is empty.
meeting_id string Data source did not contain a description for meeting_id. Column meeting_id has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1/2012 and maximum string is 99/2016.
preparer string Data source did not contain a description for preparer. Column preparer has 8108 rows, out of which 25 are empty, making the null percent 0.31. Minimum string is and maximum string is Virpi Vertainen.
introducer string Data source did not contain a description for introducer. Column introducer has 8108 rows, out of which 3024 are empty, making the null percent 37.30. Minimum string is and maximum string is Ville Lehmuskoski.
geometry_t string Data source did not contain a description for geometry_t. Column geometry_t has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is plan and maximum string is plan_unit.
geometry_n int Data source did not contain a description for geometry_n. Column geometry_n has 8108 rows, out of which 6619 are empty, making the null percent 81.64. Minimum value is 3261 and maximum value is 12294.
view_url string Data source did not contain a description for view_url. Column view_url has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: http://dev.hel.fi/openahj... and first 25 characters of maximum string: http://dev.hel.fi/openahj...
origin_id string Data source did not contain a description for origin_id. Column origin_id has 8108 rows, out of which 6034 are empty, making the null percent 74.42. First 25 characters of minimum string: ... and first 25 characters of maximum string: FF3612CA-12E8-5D02-B44F-A...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((24.846187... and first 25 characters of maximum string: POLYGON ((25.244243505000...
geom_center_x float Longitude of center. Column geom_center_x has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.83 and maximum value is 25.25.
geom_center_y float Latitude of center. Column geom_center_y has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.13 and maximum value is 60.29.
geom_type string Geometry type. Column geom_type has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.

Openahjo agenda itemspolygon, Helopenahjo agenda items, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2363 and maximum value is 72747.
register_i string Data source did not contain a description for register_i. Column register_i has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HEL 2011-000055 and maximum string is HEL 2016-011280.
subject string Data source did not contain a description for subject. Column subject has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ajoyhteyttä ja johtojen s... and first 25 characters of maximum string: Zaidankadun alueen johtos...
policymake string Data source did not contain a description for policymake. Column policymake has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 021400VH1 and maximum string is Zoojk.
meeting_da date Data source did not contain a description for meeting_da. Column is empty.
meeting_id string Data source did not contain a description for meeting_id. Column meeting_id has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1/2012 and maximum string is 99/2016.
preparer string Data source did not contain a description for preparer. Column preparer has 8108 rows, out of which 25 are empty, making the null percent 0.31. Minimum string is and maximum string is Virpi Vertainen.
introducer string Data source did not contain a description for introducer. Column introducer has 8108 rows, out of which 3024 are empty, making the null percent 37.30. Minimum string is and maximum string is Ville Lehmuskoski.
geometry_t string Data source did not contain a description for geometry_t. Column geometry_t has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is plan and maximum string is plan_unit.
geometry_n int Data source did not contain a description for geometry_n. Column geometry_n has 8108 rows, out of which 6619 are empty, making the null percent 81.64. Minimum value is 3261 and maximum value is 12294.
view_url string Data source did not contain a description for view_url. Column view_url has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: http://dev.hel.fi/openahj... and first 25 characters of maximum string: http://dev.hel.fi/openahj...
origin_id string Data source did not contain a description for origin_id. Column origin_id has 8108 rows, out of which 6034 are empty, making the null percent 74.42. First 25 characters of minimum string: ... and first 25 characters of maximum string: FF3612CA-12E8-5D02-B44F-A...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((24.846187... and first 25 characters of maximum string: POLYGON ((25.244243505000...
geom_center_x float Longitude of center. Column geom_center_x has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.83 and maximum value is 25.25.
geom_center_y float Latitude of center. Column geom_center_y has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.13 and maximum value is 60.29.
geom_type string Geometry type. Column geom_type has 8108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 7, 2020
Created September 7, 2020