Underground plan avoindatakaavahakemisto area being planned from the website of Helsingin kaupunkiympariston toimiala, Finland

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

Tables

Database Table: Planning Directory Area - Underground Plan in ProgressTSV
The table contains data obtained from the website of Helsingin kaupunkiympariston toimiala, which originates from Finland (ISO country code: fi). It represents information related to 'avoindatakaavahakemisto_alue_maanalainenkaava_vireilla__kaavahakemisto_alue_maanalainenkaava_vireillapolygon' table. The table consists of several columns that store various attributes such as '_extract_date', '_row_number', 'id', 'tyyppi', 'kaavatunnu', 'luokka', 'alkuperain', 'pintaala', 'korkeusjar', 'sijaintial', 'hyvaksymis', 'lainvoimai', 'voimaantul', 'vahvistami', 'luontipvm', 'muokkauspv', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', 'geom'. This table can be utilized for data analytics by performing various...
Version History of Area Underground Plan Applications' Areas (Pending) - PolygonTSV
This table contains the version history of the rows in the 'avoindatakaavahakemisto_alue_maanalainenkaava_vireilla__kaavahakemisto_alue_maanalainenkaava_vireillapolygon' table. It includes the columns '_start_date' and '_end_date', which indicate the start and end dates of each version of a row. The data in this table is sourced from the website of 'Helsinki City Environment Sector', which originates from Finland (ISO country code: 'fi'). The table provides historical information about various attributes such as 'id', 'tyyppi', 'kaavatunnu', 'luokka', 'alkuperain', 'pintaala', 'korkeusjar', 'sijaintial', 'hyvaksymis', 'lainvoimai', 'voimaantul', 'vahvistami', 'luontipvm', 'muokkauspv', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid',...

Column Descriptions

Database Table: Planning Directory Area - Underground Plan in Progress

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the record.
id	int	The unique identifier for each record.
tyyppi	string	The type of the record.
kaavatunnu	string	The code for the property.
luokka	string	The class of the property.
alkuperain	string	The origin of the property.
pintaala	float	The area of the property.
korkeusjar	string	The altitude of the property.
sijaintial	string	The location of the property.
hyvaksymis	string	The approval status of the property.
lainvoimai	date	The legal status of the property.
voimaantul	date	The effective date of the property.
vahvistami	date	The confirmation date of the property.
luontipvm	date	The creation date of the record.
muokkauspv	date	The modification date of the record.
datanomist	string	The owner of the data.
paivitetty	date	Flag indicating whether the record has been updated.
geom_geojson	string	The geographic data of the property in GeoJSON format.
geom_geotext	string	The geographic data of the property in GeoText format.
geom_type	string	The type of the geographic data.
geom_centroid	string	The centroid coordinates of the property.
geom_center_x	double	The x coordinate of the center point of the property.
geom_center_y	double	The y coordinate of the center point of the property.
geom	binary	The geometric representation of the property.

Version History of Area Underground Plan Applications' Areas (Pending) - Polygon

Column	Type	Comment
_start_date	date	The timestamp indicating the start of the validity period of the row version.
_end_date	date	The timestamp indicating the end of the validity period of the row version.
_row_number	long	The sequential number assigned to each row in the table.
id	int	The unique identifier for each row in the base table.
tyyppi	string	The type of the data.
kaavatunnu	string	The identifier code used in planning documents.
luokka	string	The classification of the data.
alkuperain	string	The original source of the data.
pintaala	float	The surface area value.
korkeusjar	string	The height or elevation information.
sijaintial	string	The location information.
hyvaksymis	string	The approval status of the data.
lainvoimai	date	The legal validity status of the data.
voimaantul	date	The date when the data becomes effective.
vahvistami	date	The person who verified the data.
luontipvm	date	The creation timestamp of the data.
muokkauspv	date	The last modification date of the data.
datanomist	string	The person responsible for the data.
paivitetty	date	The timestamp indicating when the data was last updated.
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 point 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 actual geometry data.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024