Dataset Collection - 'avoindatakaavahakemisto_viiteviivat' from Helsingin kaupunkiympariston toimiala in Finland

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

Tables

Reference Lines of Open Data Directory - Spatial DataTSV
This table contains data from the 'Helsinki City Environment Sector' website, which originates from the country Finland (ISO country code: FI). It includes various columns such as '_extract_date', '_row_number', 'id', 'sijaintial', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. These columns provide information related to the location, geometry, and centroid of certain objects. The data in this table can be utilized for various data analytics tasks such as spatial analysis, geographical visualization, and location-based queries.
Version History of Avoindatakaavahakemisto Viiteviivat - Kaavahakemisto ViiteviivatpointTSV
This table contains the version history of rows from the 'avoindatakaavahakemisto_viiteviivat__kaavahakemisto_viiteviivatpoint' base table. It represents data sourced from the website of the Department of Urban Environment in Helsinki, Finland. The table includes additional columns '_start_date' and '_end_date', which indicate the extraction dates of each row version. The table can be utilized for data analytics purposes, such as analyzing the changes in 'sijaintial' (location), 'geom_geojson' (geographical data in GeoJSON format), 'geom_geotext' (geographical data in Geotext format), 'geom_type' (geometry type), 'geom_centroid' (centroid coordinates), 'geom_center_x' (x-coordinate of the geometric center), 'geom_center_y' (y-coordinate of the geometric center), and 'geom' (general...

Column Descriptions

Reference Lines of Open Data Directory - Spatial Data

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	A unique identifier for each row in the table.
id	int	The unique identifier for each record in the table.
sijaintial	string	The location's address in the format of a string.
geom_geojson	string	The location's geometry in GeoJSON format.
geom_geotext	string	The location's geometry in Geotext format.
geom_type	string	The type of geometry associated with the location.
geom_centroid	string	The centroid of the location's geometry.
geom_center_x	double	The X-coordinate of the center point of the location's geometry.
geom_center_y	double	The Y-coordinate of the center point of the location's geometry.
geom	binary	The detailed geometric representation of the location.

Version History of Avoindatakaavahakemisto Viiteviivat - Kaavahakemisto Viiteviivatpoint

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	A sequential number assigned to each row version.
id	int	The unique identifier of the row version.
sijaintial	string	The location initial of the row version.
geom_geojson	string	The Geometry Object Encoding (GeoJSON) representation of the geometric data.
geom_geotext	string	The geospatial text representation of the geometric data.
geom_type	string	The type of geometry stored in the row version.
geom_centroid	string	The centroid of the geometric data.
geom_center_x	double	The x-coordinate of the center point of the geometric data.
geom_center_y	double	The y-coordinate of the center point of the geometric data.
geom	binary	The full geometric data of the row version.

Additional Info

Last Updated	April 23, 2024
Created	May 6, 2018