Dataset collection 'avoindataarvoymparistot' from the website of Helsingin kaupunkiympariston toimiala in Finland - Environmental Values - Polygon History - This service has been deprecated - please visit https://www.smartdatahub.io/ to access data. See the About page for details. //

Environmental Values - Polygon History

To download the data set, please sign up or log in

This table contains the version history of the rows from the 'Helsingin kaupunkiympariston toimiala' data source in Finland. It represents the historical information of various attributes related to 'avoindataarvoymparistotarvoymparistotpolygonhistory' base table. The table has additional columns '_start_date' and '_end_date' to indicate the extraction dates of the row versions. The data in this table can be utilized for data analytics to analyze the changes and evolution of the attributes over time and to identify patterns and trends in the 'avoindataarvoymparistot__arvoymparistotpolygon' data.

Field Descriptions

Name	Data type	Description
_start_date	date	The start date indicating the validity period of the row version.
_end_date	date	The end date indicating the validity period of the row version.
_row_number	long	The row number of the version in the version history table.
id	int	The unique identifier of the row.
kohteen_ni	string	The name of the target.
kohdetyypp	string	The type of the target.
kaupungino	string	The city name.
osa_alue	string	The sub-area name.
yleisten_a	int	The public area.
ajantasa_a	string	The up-to-date area.
kaavamerki	string	The zoning symbol.
ylkaava_20	string	The high-level zoning plan (20).
hallintovi	string	The administrative district.
yleiskuvau	string	The general description of the target.
suunnittel	string	The planning information.
kohteen_ke	string	The target's condition.
arvoluokka	string	The value class.
arvon_peru	string	The value reason.
historiall	string	Flag indicating if the target is historical.
arkkitehto	string	The architectural value.
kaupunkira	string	The urban value.
kaupunkiku	string	The urban landscape.
kaupunkir0	string	The urban view direction.
kasvilajis	string	The species of vegetation.
harvinaisu	string	The rarity of the target.
alkuperais	string	The originality of the target.
nahtavyysa	string	The visibility of the target.
muut_arvot	string	Other values regarding the target.
sailyneisy	string	The preservation of the target.
tilarakenn	string	The space structure.
rakenteet	string	The structures.
pinnoittee	string	The surface materials.
kasvillisu	string	The vegetation.
kalusteet	string	The fixtures.
valaistus	string	The lighting.
vaalittavi	string	Flag indicating if the target needs to be cared for.
kunto	string	The condition of the target.
arvoja_hei	string	Values combined with assessments.
suositukse	string	The recommendation for the target.
tiedon_tas	string	The level of information.
lahteet	string	The sources of information.
inventoinn	string	The inventory information.
inventoija	string	The name of the inventory taker.
paivitetty	string	The date when the version was updated.
maxx	int	The maximum x-coordinate.
minx	int	The minimum x-coordinate.
maxy	float	The maximum y-coordinate.
miny	float	The minimum y-coordinate.
bbmaxx	int	The maximum bounding box x-coordinate.
bbminx	int	The minimum bounding box x-coordinate.
bbmaxy	float	The maximum bounding box y-coordinate.
bbminy	float	The minimum bounding box y-coordinate.
liittamisv	int	The connection value.
id_oracle	int	The Oracle identifier of the row.
muokattu	int	Flag indicating if the row was modified.
muokkaaja	string	The name of the modifier.
datanomist	string	The data owner.
paivitett0	int	The updated date.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in Geotext 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 geometry of the target.

Name

Data type

Description

_start_date

date

The start date indicating the validity period of the row version.

_end_date

date

The end date indicating the validity period of the row version.

_row_number

long

The row number of the version in the version history table.

int

The unique identifier of the row.

kohteen_ni

string

The name of the target.

kohdetyypp

string

The type of the target.

kaupungino

string

The city name.

osa_alue

string

The sub-area name.

yleisten_a

int

The public area.

ajantasa_a

string

The up-to-date area.

kaavamerki

string

The zoning symbol.

ylkaava_20

string

The high-level zoning plan (20).

hallintovi

string

The administrative district.

yleiskuvau

string

The general description of the target.

suunnittel

string

The planning information.

kohteen_ke

string

The target's condition.

arvoluokka

string

The value class.

arvon_peru

string

The value reason.

historiall

string

Flag indicating if the target is historical.

arkkitehto

string

The architectural value.

kaupunkira

string

The urban value.

kaupunkiku

string

The urban landscape.

kaupunkir0

string

The urban view direction.

kasvilajis

string

The species of vegetation.

harvinaisu

string

The rarity of the target.

alkuperais

string

The originality of the target.

nahtavyysa

string

The visibility of the target.

muut_arvot

string

Other values regarding the target.

sailyneisy

string

The preservation of the target.

tilarakenn

string

The space structure.

rakenteet

string

The structures.

pinnoittee

string

The surface materials.

kasvillisu

string

The vegetation.

kalusteet

string

The fixtures.

valaistus

string

The lighting.

vaalittavi

string

Flag indicating if the target needs to be cared for.

kunto

string

The condition of the target.

arvoja_hei

string

Values combined with assessments.

suositukse

string

The recommendation for the target.

tiedon_tas

string

The level of information.

lahteet

string

The sources of information.

inventoinn

string

The inventory information.

inventoija

string

The name of the inventory taker.

paivitetty

string

The date when the version was updated.

maxx

int

The maximum x-coordinate.

minx

int

The minimum x-coordinate.

maxy

float

The maximum y-coordinate.

miny

float

The minimum y-coordinate.

bbmaxx

int

The maximum bounding box x-coordinate.

bbminx

int

The minimum bounding box x-coordinate.

bbmaxy

float

The maximum bounding box y-coordinate.

bbminy

float

The minimum bounding box y-coordinate.

liittamisv

int

The connection value.

id_oracle

int

The Oracle identifier of the row.

muokattu

int

Flag indicating if the row was modified.

muokkaaja

string

The name of the modifier.

datanomist

string

The data owner.

paivitett0

int

The updated date.

geom_geojson

string

The geometry in GeoJSON format.

geom_geotext

string

The geometry in Geotext 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 geometry of the target.

Additional Information


Last updated	April 23, 2024
Created	April 23, 2024
License	No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapter	delta
Country	fi
Database	fi_helsingin_kaupunkiympariston_toimiala
Id	c7fd65d1-bc4e-4f8e-ba8d-7b7e9253dab9
Package id	60d789b0-e14f-4258-9370-84bbb2f31575
Position	1
Revision id	f1ae9471-857b-4539-a00f-37df7a566c48
State	active
Table	avoindataarvoymparistot__arvoymparistotpolygon__history

Last updated

April 23, 2024

Created

April 23, 2024

License

No License Provided

Geographic coverage

Geographic granularity

Temporal coverage from

Temporal coverage to

Adapter

delta

Country

Database

fi_helsingin_kaupunkiympariston_toimiala

c7fd65d1-bc4e-4f8e-ba8d-7b7e9253dab9

Package id

60d789b0-e14f-4258-9370-84bbb2f31575

Position

Revision id

f1ae9471-857b-4539-a00f-37df7a566c48

State

active

Table

avoindataarvoymparistot__arvoymparistotpolygon__history

Environmental Values - Polygon History

Field Descriptions

No sample for this dataset

Additional Information