Avoin Data Kaavamääräys

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

Tables

Kaavamaarayspolygon Data from Helsinki City Environment Department, FinlandTSV
This table contains data from 'Helsinki City Environment Department' in Finland. It provides information about various attributes related to 'Kaavamaarays Polygon'. The table includes columns such as '_extract_date', '_row_number', 'gid', 'kaavamaara', 'tyyppi', 'luokka', 'teksti', 'symbolityy', 'maanalaine', 'leveys', 'sitova', 'pintaala', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'angle', 'x_scale', 'y_scale', 'asemakaava', 'rakennusal', 'ymparistoa', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. The data in this table can be utilized for data analytics purposes like analyzing the distribution and density of 'Kaavamaarays' based on different 'tyyppi' and 'luokka' classifications, determining the area and dimensions of...
Version History of KaavamaaraysPolygon in Helsingin kaupunkiymparisto DB (Finland)TSV
This table stores the version history of rows extracted from the Helsingin kaupunkiympariston toimiala website. The rows contain various data related to avoindatakaavamaarayskaavamaarayspolygon. The table has additional columns '_start_date' and '_end_date' which represent the extraction dates of each row version. The table contains information such as 'gid', 'kaavamaara', 'tyyppi', 'luokka', 'teksti', 'symbolityy', 'maanalaine', 'leveys', 'sitova', 'pintaala', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'angle', 'x_scale', 'y_scale', 'asemakaava', 'rakennusal', 'ymparistoa', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The information in this table can be utilized in various data analytics tasks, such as analyzing the historical...

Column Descriptions

Kaavamaarayspolygon Data from Helsinki City Environment Department, Finland

Column	Type	Comment
_extract_date	date	The date this data was extracted.
_row_number	long	The row number of the entry.
gid	int	The unique identifier for the table entry.
kaavamaara	string	Unknown description.
tyyppi	string	Unknown description.
luokka	string	Unknown description.
teksti	string	Unknown description.
symbolityy	string	Unknown description.
maanalaine	boolean	Unknown description.
leveys	string	Unknown description.
sitova	boolean	Unknown description.
pintaala	string	Unknown description.
yhtluontip	string	Unknown description.
yhtmuokkau	string	Unknown description.
yhtdatanom	string	Unknown description.
angle	string	Unknown description.
x_scale	string	Unknown description.
y_scale	string	Unknown description.
asemakaava	string	Unknown description.
rakennusal	string	Unknown description.
ymparistoa	string	Unknown description.
geom_geojson	string	Unknown description.
geom_geotext	string	Unknown description.
geom_type	string	Unknown description.
geom_centroid	string	Unknown description.
geom_center_x	double	Unknown description.
geom_center_y	double	Unknown description.
geom	binary	Unknown description.

Version History of KaavamaaraysPolygon in Helsingin kaupunkiymparisto DB (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 unique identifier of the row version.
gid	int	The identifier of the row in the base table.
kaavamaara	string	The value representing the 'kaavamaara' of the row in the base table.
tyyppi	string	The type of the row in the base table.
luokka	string	The classification of the row in the base table.
teksti	string	The text associated with the row in the base table.
symbolityy	string	The symbol type of the row in the base table.
maanalaine	boolean	Indicates if the row in the base table is underground.
leveys	string	The width of the row in the base table.
sitova	boolean	Indicates if the row in the base table is binding.
pintaala	string	The area of the row in the base table.
yhtluontip	string	The timestamp of the row creation in the base table.
yhtmuokkau	string	The timestamp of the row modification in the base table.
yhtdatanom	string	The timestamp of the data nomination in the base table.
angle	string	The angle of the row in the base table.
x_scale	string	The X scale of the row in the base table.
y_scale	string	The Y scale of the row in the base table.
asemakaava	string	The asemakaava associated with the row in the base table.
rakennusal	string	The rakennusal associated with the row in the base table.
ymparistoa	string	The ymparistoa associated with the row in the base table.
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 associated with the row.
geom_centroid	string	The centroid of the geometry associated with the row.
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 geometry associated with the row.

Additional Info

Last Updated	April 23, 2024
Created	April 23, 2024