Open Animal Observations in Helsinki

This dataset collection, sourced from the website of 'Helsingin kaupunkiympariston toimiala' in Finland, contains one or more dataset tables. These tables consist of valuable open data related to animal observations.

Tables

Other Animal ObservationsTSV
This table contains data from the 'Helsinki City Environment Sector' website in Finland (ISO country code 'fi'). It includes various fields such as '_extract_date', '_row_number', 'id', 'tunnus', 'luokkatunn', 'luokan_nim', 'nimi', 'kuvaus', 'huom', 'digipvm', 'pvm_editoi', 'suojaustas', 'pinta_ala', 'kohdetekst', 'lajinimi', 'havainnon', 'havaintosa', 'metadata', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This data can be utilized in data analytics to perform various analyses such as tracking observations of different animal species, studying habitat patterns, analyzing geographical distribution, and identifying trends and patterns in animal sightings.
Version History of Animal Observations (Miscellaneous) from Helsinki City Environment Agency, FinlandTSV
This table represents the version history of rows extracted from the 'Helsingin kaupunkiympariston toimiala' website in the country 'Finland'. It contains historical data from the 'ltj_avoinmuu_elainhavaintoja__muu_elainhavaintojapoint' base table. Each row in this table corresponds to a specific version of a row in the base table and includes additional columns '_start_date' and '_end_date' which represent the extraction dates of the row versions. The data in this table can be used for various data analytics purposes such as analyzing the changes and updates to the 'muu_elainhavaintojapoint' data over time, tracking the evolution of different attributes and properties associated with the observations of other animal species, conducting trend analysis, and performing temporal analysis...

Column Descriptions

Other Animal Observations

Column	Type	Comment
_extract_date	date	The date on which the data was extracted.
_row_number	long	The unique identifier for each row in the table.
id	int	The unique identifier for each entry in the table.
tunnus	int	The identification code for the entry.
luokkatunn	string	The identification code for the class.
luokan_nim	string	The name of the class.
nimi	string	The name of the entry.
kuvaus	string	The description of the entry.
huom	string	Additional notes or comments.
digipvm	string	The date on which the entry was digitized.
pvm_editoi	string	The date on which the entry was last edited.
suojaustas	int	The security level of the entry.
pinta_ala	int	The surface area of the entry.
kohdetekst	string	The text content of the entry.
lajinimi	string	The name of the species.
havainnon	string	The observation number.
havaintosa	string	The sub-observation number.
metadata	string	The metadata associated with the entry.
geom_geojson	string	The geojson representation of the geometry.
geom_geotext	string	The geotext representation of the geometry.
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 centroid.
geom_center_y	double	The y-coordinate of the centroid.
geom	binary	The geometry object.

Version History of Animal Observations (Miscellaneous) from Helsinki City Environment Agency, 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 sequence number of the row version.
id	int	The identifier of the row.
tunnus	int	The identifier for the row.
luokkatunn	string	The identifier for the class.
luokan_nim	string	The name of the class.
nimi	string	The name of the row.
kuvaus	string	The description of the row.
huom	string	Additional notes for the row.
digipvm	string	The digital date of the row.
pvm_editoi	string	The date of the row edit.
suojaustas	int	The security level of the row.
pinta_ala	int	The surface area of the row.
kohdetekst	string	The target text of the row.
lajinimi	string	The name of the species.
havainnon	string	The observation of the row.
havaintosa	string	The secondary observation of the row.
metadata	string	Any additional metadata for the row.
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 geometry for the row.
geom_centroid	string	The centroid of the row's geometry.
geom_center_x	double	The X-coordinate of the center of the row's geometry.
geom_center_y	double	The Y-coordinate of the center of the row's geometry.
geom	binary	The geometry of the row.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018