Open Data Operations and Environment in Finland (avoindataopev_ooa_ylaaste_suomi)

This dataset collection includes one or more tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Primary school spatial division data for FinlandTSV
This table contains data from the Helsingin kaupunkiympariston toimiala website in Finland. It includes various attributes such as '_extract_date', '_row_number', 'id', 'aluejako', 'kunta', 'tunnus', 'nimi_fi', 'nimi_se', 'toimipiste', 'yhtluontip', 'yhtdatanom', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. The data in this table can be used for various data analytic purposes such as geographical analysis, population distribution analysis, and facility location planning.
Version History of Opev Ooa Ylaaste Suomi - Opev Ooa Ylaaste Suomipolygon for Helsingin kaupunkiympariston toimiala, FinlandTSV
This table is a historical version of the 'avoindataopev_ooa_ylaaste_suomi__opev_ooa_ylaaste_suomipolygon' table, sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. It contains the version history of its base table rows, with two additional columns: '_start_date' and '_end_date'. The '_start_date' column contains the date when the row was extracted from the data source, while the '_end_date' column contains the date when a new version of the row was extracted. If '_end_date' is null, it means that the row is the most recent version. This table can be used for data analytics, such as tracking changes over time, analyzing trends, and performing historical comparisons of the data.

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the record in the table.
id	int	The unique identifier for each record.
aluejako	string	The categorization of the area.
kunta	int	The name of the municipality.
tunnus	int	The code or identifier for the record.
nimi_fi	string	The name of the record in Finnish.
nimi_se	string	The name of the record in Swedish.
toimipiste	int	The name of the office or branch.
yhtluontip	string	The type of creation.
yhtdatanom	string	The level of data.
paivitetty	string	The date of the last update.
geom_geojson	string	The geometry information in GeoJSON format.
geom_geotext	string	The geometry information in text format.
geom_type	string	The type of 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 geometric representation of the record.

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	The row number of the version in the table.
id	int	The unique identifier of the row.
aluejako	string	The division of the area.
kunta	int	The municipality associated with the row.
tunnus	int	The identifier of the row.
nimi_fi	string	The name of the row in Finnish.
nimi_se	string	The name of the row in Swedish.
toimipiste	int	The location of the row.
yhtluontip	string	The creation type of the row.
yhtdatanom	string	The data authority of the row.
paivitetty	string	The date of the row update.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geometry of the row 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 geometry center.
geom_center_y	double	The y-coordinate of the geometry center.
geom	binary	The geometry of the row.

Last Updated	April 24, 2024
Created	April 24, 2024