hellouhi

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

Tables

Spatial Data from Helsingin kaupunkiympäristön toimiala in FinlandTSV
This table contains data sourced from the website of 'Helsinki Urban Environment Division' in Finland. It provides information related to various attributes including the extraction date, row number, source of the data, geographic data in both GeoJSON and GeoText formats, the type of the geographic data, centroid of the geography, center coordinates (x and y), and the actual geometry. This data can be utilized in data analytics to perform various analyses such as spatial analysis, geographical mapping, centroid calculations, and exploring the characteristics of different geographic data types.
Version History of Rows in 'Helsingin kaupunkiympariston toimiala' Table from FinlandTSV
This table contains the version history of the 'Helsingin kaupunkiympariston toimiala' dataset. It is sourced from the website of Helsinki City Planning Department which originates from the country Finland (ISO country code: FI). The table includes various columns such as '_start_date', '_end_date', '_row_number', 'source', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. The '_start_date' column indicates the date when each row was extracted from the data source, while the '_end_date' column represents the date when a new version of a row was extracted. If the '_end_date' value is null, it signifies that the row is the most recent version. This version history table provides valuable insights for data analytics and enables...

Column Descriptions

Spatial Data from Helsingin kaupunkiympäristön toimiala in Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the record.
source	string	The source of the data.
geom_geojson	string	The geometry of the record in GeoJSON format.
geom_geotext	string	The geometry of the record 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 full geometry of the record.

Version History of Rows in 'Helsingin kaupunkiympariston toimiala' Table from Finland

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 row number of the versioned row.
source	string	The source of the row version.
geom_geojson	string	The geometry of the row version in GeoJSON format.
geom_geotext	string	The geometry of the row version in geotext format.
geom_type	string	The type of geometry of the row version.
geom_centroid	string	The centroid of the geometry of the row version.
geom_center_x	double	The x-coordinate of the center point of the geometry of the row version.
geom_center_y	double	The y-coordinate of the center point of the geometry of the row version.
geom	binary	The geometry of the row version.

Additional Info

Last Updated	September 13, 2024
Created	October 22, 2018