Helsinki Urban Environment Sector Open Data or Other Area Data Collection

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

Tables

General or Other Area - General or Other Area PolygonTSV
This table contains data from the Helsinki City Environment Sector website. It provides information about general or other areas in the form of polygons. The data includes various attributes such as '_extract_date', '_row_number', 'gid', 'yleinen_ta', 'kayttotark', 'tyyppi', 'maanalaine', 'tehokkuusl', 'kaavamerki', 'km2', 'lisakm2', 'lisakm2riv', 'yhteensakm', 'kellari', 'kerrosluku', 'ullakko', 'korttelinn', 'knumerokar', 'pintaala', 'lisatietoj', 'lisakm2kuv', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'asemakaava', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These attributes can be utilized in various data analytics tasks such as estimating the efficiency of different areas, analyzing the distribution of building types,...
Version History of General or Other Area Polygons for Helsingin kaupunkiympariston toimiala (Finland)TSV
This table contains the version history of the 'avoindatayleinen_tai_muu_alue__yleinen_tai_muu_aluepolygon' table sourced from the website of 'Helsinki City environment sector' in Finland. The table includes additional columns '_start_date' and '_end_date' which represent the extraction dates of each row. The table consists of various columns that store information such as 'gid', 'yleinen_ta', 'kayttotark', 'tyyppi', 'maanalaine', 'tehokkuusl', 'kaavamerki', 'km2', 'lisakm2', 'lisakm2riv', 'yhteensakm', 'kellari', 'kerrosluku', 'ullakko', 'korttelinn', 'knumerokar', 'pintaala', 'lisatietoj', 'lisakm2kuv', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'asemakaava', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This table provides a...

Column Descriptions

General or Other Area - General or Other Area Polygon

Column	Type	Comment
_extract_date	date	The date on which the data was extracted.
_row_number	long	The row number of the record in the database table.
gid	int	The unique identifier for each record in the table.
yleinen_ta	string	The general name or description of the column.
kayttotark	string	The designated usage or purpose for the property.
tyyppi	string	The type or category of the property.
maanalaine	boolean	Specifies whether the property is located underground.
tehokkuusl	string	The efficiency level of the property.
kaavamerki	string	The symbol or code that represents the property on a plan or map.
km2	int	The area of the property in square kilometers.
lisakm2	string	Additional area of the property in square kilometers.
lisakm2riv	boolean	Additional area of the property in square kilometers in riv.
yhteensakm	string	The total area of the property, including additional areas.
kellari	string	Specifies whether the property has a basement.
kerrosluku	string	The number of floors in the building.
ullakko	string	Specifies whether the property has an attic.
korttelinn	string	The block number of the property.
knumerokar	boolean	The parcel number of the property.
pintaala	float	The surface area of the property.
lisatietoj	string	Additional information about the property.
lisakm2kuv	string	Additional area of the property in square kilometers as an image.
yhtluontip	string	The date and time the property record was created.
yhtmuokkau	string	The date and time the property record was last modified.
yhtdatanom	string	The date and time the property record was last updated in the database.
asemakaava	string	Specifies whether the property is part of a detailed plan.
geom_geojson	string	The geometry of the property in GeoJSON format.
geom_geotext	string	The geometry of the property in geotext format.
geom_type	string	The type of geometry for the property.
geom_centroid	string	The centroid or center point of the property geometry.
geom_center_x	double	The x-coordinate of the center point of the property geometry.
geom_center_y	double	The y-coordinate of the center point of the property geometry.
geom	binary	The geometry of the property.

Version History of General or Other Area Polygons for Helsingin kaupunkiympariston toimiala (Finland)

Column	Type	Comment
_start_date	date	The validity start date of the row version.
_end_date	date	The validity end date of the row version.
_row_number	long	The row number in the version history table.
gid	int	The globally unique identifier of the row.
yleinen_ta	string	The general description of the table.
kayttotark	string	The designated use of the table.
tyyppi	string	The type of the table.
maanalaine	boolean	Indicates if the table is underground or not.
tehokkuusl	string	The efficiency level of the table.
kaavamerki	string	The mark symbolizing the table.
km2	int	The area in square kilometers.
lisakm2	string	The additional area in square kilometers.
lisakm2riv	boolean	The additional area in square kilometers for a specific row.
yhteensakm	string	The total area in square kilometers.
kellari	string	Indicates if the table has a basement or not.
kerrosluku	string	The number of floors in the table.
ullakko	string	Indicates if the table has an attic or not.
korttelinn	string	The block number of the table.
knumerokar	boolean	The street address number of the table.
pintaala	float	The surface area of the table.
lisatietoj	string	Additional information about the table.
lisakm2kuv	string	The additional area in square kilometers visualized.
yhtluontip	string	The creation date of the whole data.
yhtmuokkau	string	The modification date of the whole data.
yhtdatanom	string	The date the whole data became official.
asemakaava	string	The zoning plan for the table.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in plain text.
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 point of the geometry.
geom_center_y	double	The Y coordinate of the center point of the geometry.
geom	binary	The geometry data.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024