Agenda Items from Helsingin kaupunkiympariston toimiala in Finland

This dataset collection contains tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

Agenda Items in Helsingin kaupunkiympariston toimiala, FinlandTSV
This table contains agenda items from the website of the Urban Environment Division of the City of Helsinki. The data originates from Finland (ISO country code 'fi'). It provides information about various agenda items such as their unique IDs, registration numbers, subjects, policy makers, meeting dates, meeting IDs, preparers, introducers, geographical coordinates, URLs for viewing, origin IDs, geojson and geotext formats of the geometry, geometry types, centroids, center coordinates, and the geometry itself. This data can be utilized for data analytics to analyze trends, patterns, and relationships within agenda items, as well as to perform spatial analysis based on the geographical coordinates.
History of Agenda Items in Helsingin kaupunkiympariston toimiala (Country: Finland)TSV
The table contains the version history of agenda items extracted from the website of Helsingin kaupunkiympäristön toimiala in Finland. It has additional columns '_start_date' and '_end_date' which indicate the extraction dates of the rows. The table provides historical data of multiple columns such as 'id', 'register_i', 'subject', 'policymake', 'meeting_da', 'meeting_id', 'preparer', 'introducer', 'geometry_t', 'geometry_n', 'view_url', 'origin_id', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. The '_start_date' column denotes the start date of a specific version of the row, while the '_end_date' column represents the end date when a new version of the row was extracted. If '_end_date' is null, it means that the row is the...

Column Descriptions

Agenda Items in Helsingin kaupunkiympariston toimiala, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted from the source.
_row_number	long	The sequential number of the row in the table.
id	int	The unique identifier for each record in the table.
register_i	string	The identifier of the register for the record.
subject	string	The subject of the record.
policymake	string	The policy maker associated with the record.
meeting_da	string	The date of the meeting associated with the record.
meeting_id	string	The unique identifier for the meeting associated with the record.
preparer	string	The person who prepared the record.
introducer	string	The entity that introduced the record.
geometry_t	string	The type of geometry associated with the record.
geometry_n	string	The name of the geometry associated with the record.
view_url	string	The URL for viewing the record.
origin_id	string	The identifier of the origin of the record.
geom_geojson	string	The geometry data in GeoJSON format.
geom_geotext	string	The geometry data in Geotext format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid of the geometry.
geom_center_x	double	The x-coordinate of the center of the geometry.
geom_center_y	double	The y-coordinate of the center of the geometry.
geom	binary	The geometry data.

History of Agenda Items in Helsingin kaupunkiympariston toimiala (Country: Finland)

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The sequence number of the row version.
id	int	The unique identifier of the row.
register_i	string	The registration index of the row.
subject	string	The subject of the row.
policymake	string	The policy maker of the row.
meeting_da	string	The meeting date of the row.
meeting_id	string	The ID of the meeting associated with the row.
preparer	string	The preparer of the row.
introducer	string	The introducer of the row.
geometry_t	string	The geometry type of the row.
geometry_n	string	The number of geometries in the row.
view_url	string	The URL for viewing the row.
origin_id	string	The original ID of the row.
geom_geojson	string	The GeoJSON representation of the geometry.
geom_geotext	string	The well-known text representation of the geometry.
geom_type	string	The type of the geometry.
geom_centroid	string	The centroid of the geometry.
geom_center_x	double	The x-coordinate of the center of the geometry.
geom_center_y	double	The y-coordinate of the center of the geometry.
geom	binary	The geometry object of the row.

Additional Info

Last Updated	September 13, 2024
Created	October 22, 2018