Helsinki Urban Environment Sector's Open Data General Plan Directory Area

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

General Plan Application Directory Area Polygon DatasetTSV
This table contains data from the avoindataosayleiskaavahakemisto_alue__osayleiskaavahakemisto_aluepolygon dataset sourced from the website of Helsingin kaupunkiympariston toimiala. The data originates from Finland (ISO country code: FI). The table includes various columns such as '_extract_date', '_row_number', 'id', 'kohdenimi', 'tunnus', 'nimi', 'olotila', 'luontipvm', 'muokkauspv', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' among others. This data can be utilized for various data analytics purposes such as spatial analysis, mapping, geolocation-based insights, and trends visualization.
Open Data General Plan Area Directory Sub-Area Polygon HistoryTSV
This table contains the version history of the base table 'avoindataosayleiskaavahakemisto_alue__osayleiskaavahakemisto_aluepolygon'. It includes additional columns '_start_date' and '_end_date' which indicate the extraction dates of each version. The data in this table is sourced from the website of 'Helsinki City Environment Sector' in Finland (ISO country code: FI). The table provides valuable information for data analytics tasks such as trend analysis, historical comparisons, and monitoring changes over time.

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data.
id	int	The unique identifier of the entry.
kohdenimi	string	The name of the target.
tunnus	int	The identifier of the target.
nimi	string	The name of the entry.
olotila	int	The status of the entry.
luontipvm	string	The creation date of the entry.
muokkauspv	string	The last modification date of the entry.
datanomist	string	The owner of the data.
paivitetty	string	Specifies if the entry has been updated.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in GeoText format.
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.

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 row number of the version.
id	int	The unique identifier of the row.
kohdenimi	string	The name of the target.
tunnus	int	The identifier of the target.
nimi	string	The name of the row.
olotila	int	The state of the row.
luontipvm	string	The creation date of the row.
muokkauspv	string	The modification date of the row.
datanomist	string	The owner of the data.
paivitetty	string	The date of the last update.
geom_geojson	string	The geometry of the row in GEOJSON format.
geom_geotext	string	The geometry of the row 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 of the row.

Last Updated	September 13, 2024
Created	April 24, 2024