Land Use in Coastal Areas Dataset Collection

The dataset collection 'avoindataseutukartta_maankaytto_merialue' consists of one or more dataset tables sourced from the website of 'City of Helsinki Environment Department' in Finland.

Tables

Land Use in Marine AreaTSV
This table contains data from the 'Helsinki Urban Environment Sector' website of the country Finland (ISO country code 'FI'). It includes information about land use and sea areas. The table consists of various columns including '_extract_date', '_row_number', 'maankaytto', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', and 'tietopalve'. The data in this table can be utilized in data analytics to analyze land use patterns, study different land use categories, examine the geographical distribution of land use, calculate the centroid and center coordinates of the geographical features, and perform spatial analysis on the sea areas.
Version History of Land Use in Marine AreasTSV
This table represents the version history of the 'avoindataseutukartta_maankaytto_merialue__seutukartta_maankaytto_merialuepolygon' base table. It contains the extracted rows from the data source provided by 'Helsinki Urban Environment Division' in Finland. The table includes columns such as '_start_date' and '_end_date' indicating the extraction dates of the row versions. Utilizing this table, data analysts can perform various data analytics tasks, such as tracking changes over time, analyzing trends, and understanding the historical evolution of land use in marine areas. By examining the 'maankaytto' and 'mtryhm' columns, analysts can gain insights into the different types of land use and land use categories attributed to each row version. The 'geom_geojson', 'geom_geotext',...

Column Descriptions

Land Use in Marine Area

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data entry.
maankaytto	string	The land use category associated with the entry.
mtryhm	int	The land use group of the entry.
geom_geojson	string	The geometry of the entry in GeoJSON format.
geom_geotext	string	The geometry of the entry 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 point of the geometry.
geom_center_y	double	The y-coordinate of the center point of the geometry.
geom	binary	The complete geometry information.
tietopalve	int	The data service name that provides the information.

Version History of Land Use in Marine Areas

Column	Type	Comment
_start_date	date	The start date of the validity period for the row version.
_end_date	date	The end date of the validity period for the row version.
_row_number	long	The numerical identifier for the row version.
maankaytto	string	The land use associated with the row version.
mtryhm	int	The group identifier associated with the row version.
geom_geojson	string	The geographic data in GeoJSON format associated with the row version.
geom_geotext	string	The geographic data in Geotext format associated with the row version.
geom_type	string	The type of geographic data associated with the row version.
geom_centroid	string	The centroid point of the geographic data associated with the row version.
geom_center_x	double	The x-coordinate of the center point of the geographic data associated with the row version.
geom_center_y	double	The y-coordinate of the center point of the geographic data associated with the row version.
geom	binary	The geometric data associated with the row version.
tietopalve	int	The information service associated with the row version.

Additional Info

Last Updated	September 13, 2024
Created	May 6, 2018