Avoindatakorttelialue

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

Tables

Urban Development Areas - Polygon DataTSV
The table avoindatakorttelialue__korttelialuepolygon contains data sourced from the website of 'Helsinki City Environment Sector' in Finland. It includes various attributes such as '_extract_date', '_row_number', 'gid', 'korttelial', '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', 'geom_center_y', and 'geom'. These attributes can be analyzed to gain insights into urban planning, land usage, building characteristics, and other related areas in Helsinki city.
Version History of Neighborhood Polygon Area in Helsinki, FinlandTSV
This table contains the version history of the rows from the base table 'avoindatakorttelialue__korttelialuepolygon'. It has additional columns '_start_date' and '_end_date' that indicate the extraction dates of each row. The data in this table is sourced from the website of 'City of Helsinki Urban Environment Division' in Finland (ISO country code: 'fi'). The table provides historical information about various attributes such as 'gid', 'korttelial', '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',...

Column Descriptions

Urban Development Areas - Polygon Data

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The unique identifier for each row in the table.
gid	int	The unique identifier for each record in the table.
korttelial	string	The block/square area in which the property is located.
kayttotark	string	The designated use or purpose of the property.
tyyppi	string	The type of the property (e.g. residential, commercial, etc.).
maanalaine	boolean	Indicator for whether the property has an underground structure.
tehokkuusl	float	The floor-area ratio for the property.
kaavamerki	string	The zoning mark or symbol used in the city's zoning plan.
km2	int	The total area of the property in square kilometers.
lisakm2	string	Additional area in square kilometers for the property.
lisakm2riv	boolean	Additional area in square kilometers for the property (record-specific value).
yhteensakm	string	The combined area of the property including additional areas.
kellari	string	Indicator for whether the property has a basement.
kerrosluku	int	The number of floors in the building.
ullakko	string	Indicator for whether the property has an attic.
korttelinn	int	The block/increment number of the property.
knumerokar	boolean	The street address number of the property.
pintaala	float	The total area of the property in square meters.
lisatietoj	string	Additional information about the property.
lisakm2kuv	string	Additional area in square kilometers for the property (visualized value).
yhtluontip	string	The date of creation for the record.
yhtmuokkau	string	The date of the last modification for the record.
yhtdatanom	string	Indicator for whether the record is currently being edited.
asemakaava	string	The zoning plan designation for the property.
geom_geojson	string	The geometry of the property in GeoJSON format.
geom_geotext	string	The geometry of the property in well-known text format.
geom_type	string	The type of the geometry (e.g. point, polygon, etc.).
geom_centroid	string	The centroid point of the property's geometry.
geom_center_x	double	The x-coordinate of the centroid point of the property's geometry.
geom_center_y	double	The y-coordinate of the centroid point of the property's geometry.
geom	binary	The spatial representation of the property's geometry.

Version History of Neighborhood Polygon Area in Helsinki, Finland

Column	Type	Comment
_start_date	date	Indicates the start date of the validity period for the row version.
_end_date	date	Indicates the end date of the validity period for the row version.
_row_number	long	A unique identifier for each row version.
gid	int	A unique identifier for each row in the table.
korttelial	string	The identifier for a city block.
kayttotark	string	The designated use of the area.
tyyppi	string	The type or category of the area.
maanalaine	boolean	Indicates if the area is located underground.
tehokkuusl	float	The permitted building ratio for the area.
kaavamerki	string	The symbol representing the area on a map.
km2	int	The area in square kilometers.
lisakm2	string	Additional area in square kilometers.
lisakm2riv	boolean	Additional area in square kilometers for a specific row version.
yhteensakm	string	The total area in square kilometers.
kellari	string	Indicates if there is a basement in the building.
kerrosluku	int	The number of floors in the building.
ullakko	string	Indicates if there is an attic in the building.
korttelinn	int	The block number within a city.
knumerokar	boolean	The number of the building.
pintaala	float	The surface area of the building.
lisatietoj	string	Additional information about the area or building.
lisakm2kuv	string	Additional area in square kilometers represented on a map.
yhtluontip	string	The date of creation of the row version.
yhtmuokkau	string	The date of modification of the row version.
yhtdatanom	string	The person who requested the row version.
asemakaava	string	The master plan for the area.
geom_geojson	string	The geometry of the area in GeoJSON format.
geom_geotext	string	The geometry of the area in geotext format.
geom_type	string	The type of geometry for the area.
geom_centroid	string	The centroid of the area geometry.
geom_center_x	double	The x-coordinate of the center of the area geometry.
geom_center_y	double	The y-coordinate of the center of the area geometry.
geom	binary	The geometry of the area.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024