Restricted Construction Area Identifier for Urban Development Planning in Helsinki, Finland

The dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

Building Restriction Area for Preparing Detailed Plan - PolygonTSV
The 'avoindatarakennuskieltoalue_tunnus_asemakaavan_laatimiseksi__rakennuskieltoalue_tunnus_asemakaavan_laatimiseksipolygon' table contains data sourced from the website of 'Helsinki City Environment Sector' in Finland (ISO country code: fi). It includes various attributes related to building prohibition areas for the drafting of detailed plans. The table provides information such as extract date, row number, ID, type, building prohibition, expiration date, font style, font size, text direction, creation date, modification date, data owner, last update date, geospatial data in GeoJSON and geotext formats, geometry type, centroid coordinates, and the actual geometry itself. This data can be utilized in data analytics for various purposes such as spatial analysis, identifying areas where...
History of Building Restriction Area Identification for Creating Zone PlansTSV
This table contains the version history of the rows from the 'avoindatarakennuskieltoalue_tunnus_asemakaavan_laatimiseksi__rakennuskieltoalue_tunnus_asemakaavan_laatimiseksipolygon' table. The rows in this table represent different versions of the base table rows and include two additional columns: '_start_date' and '_end_date'. The '_start_date' column stores the date when the row was extracted from the data source, while the '_end_date' column stores the date when a new version of the row was extracted from the data source. If the value in the '_end_date' column is null, it indicates that the row is the most recent version. The data in this table is sourced from the website of 'Helsinki Urban Environment Division' in Finland (ISO country code: 'FI'). This table provides a historical...

Column Descriptions

Building Restriction Area for Preparing Detailed Plan - Polygon

Column	Type	Comment
_extract_date	date	The date and time when the data was extracted.
_row_number	long	The row number of the data in the table.
id	int	The unique identifier for each record in the table.
tyyppi	string	The type of the data.
rakennuski	int	The building code.
paattymisp	string	The date when the record is scheduled to end.
tekstifont	string	The font used for the text.
tekstikoko	float	The font size used for the text.
tekstisuun	int	The text orientation.
luontipvm	string	The creation date of the record.
muokkauspv	string	The last modified date of the record.
datanomist	string	The owner of the data.
paivitetty	string	The timestamp of the latest update.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry 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 geometric representation of the data.

History of Building Restriction Area Identification for Creating Zone Plans

Column	Type	Comment
_start_date	date	The start date indicating the beginning of validity period for the row version.
_end_date	date	The end date indicating the end of validity period for the row version.
_row_number	long	The row number representing the position of the row version within the table.
id	int	The unique identifier of the row version.
tyyppi	string	The type of the row version.
rakennuski	int	The building type.
paattymisp	string	The expiration date of the row version.
tekstifont	string	The font used for text in the row version.
tekstikoko	float	The size of the text in the row version.
tekstisuun	int	The orientation of the text in the row version.
luontipvm	string	The creation date of the row version.
muokkauspv	string	The modification date of the row version.
datanomist	string	The data owner of the row version.
paivitetty	string	The date of the last update on the row version.
geom_geojson	string	The geometry data in GeoJSON format.
geom_geotext	string	The geometry data in Geotext format.
geom_type	string	The type of the geometry data.
geom_centroid	string	The centroid of the geometry data.
geom_center_x	double	The x-coordinate of the center of the geometry data.
geom_center_y	double	The y-coordinate of the center of the geometry data.
geom	binary	The geometry data.

Additional Info

Last Updated	September 13, 2024
Created	April 24, 2024