Tulvakohteet

Tables

Tl157, Avointl157, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tulvalle alttiit kohteet tiestöllä inventoidaan toimistotyönä toteutuneiden tulvatietojen, tulvariskiaineistojen sekä paikallisen asiantuntemuksen perusteella. Tulvakohteiden alku- ja loppupisteet kirjataan n. 10 metrin tarkkuudella.

Column Descriptions

Tl157, Avointl157, Latest

Column	Type	Comment
aet	int	Data source did not contain a description for AET. Column aet has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 20465.
losa	int	Data source did not contain a description for LOSA. Column losa has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 970.
let	int	Data source did not contain a description for LET. Column let has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 24170.
alkupvm	date	Data source did not contain a description for ALKUPVM. Column is empty.
loppupvm	date	Data source did not contain a description for LOPPUPVM. Column is empty.
tulvsyy1	int	Data source did not contain a description for TULVSYY1. Column tulvsyy1 has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 9.
s_tulvsyy1	string	Data source did not contain a description for S_TULVSYY1. Column s_tulvsyy1 has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ei tietoa and maximum string is vesistötu.
tulvsyy2	int	Data source did not contain a description for TULVSYY2. Column tulvsyy2 has 771 rows, out of which 576 are empty, making the null percent 74.71. Minimum value is 1 and maximum value is 7.
s_tulvsyy2	string	Data source did not contain a description for S_TULVSYY2. Column s_tulvsyy2 has 771 rows, out of which 576 are empty, making the null percent 74.71. Minimum string is and maximum string is vesistötu.
tulvsyy3	int	Data source did not contain a description for TULVSYY3. Column tulvsyy3 has 771 rows, out of which 747 are empty, making the null percent 96.89. Minimum value is 1 and maximum value is 7.
s_tulvsyy3	string	Data source did not contain a description for S_TULVSYY3. Column s_tulvsyy3 has 771 rows, out of which 747 are empty, making the null percent 96.89. Minimum string is and maximum string is vesistötu.
tulvatoi	int	Data source did not contain a description for TULVATOI. Column tulvatoi has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 9.
s_tulvatoi	string	Data source did not contain a description for S_TULVATOI. Column s_tulvatoi has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 / 100v and maximum string is yleinen.
syvyystod	int	Data source did not contain a description for SYVYYSTOD. Column syvyystod has 771 rows, out of which 733 are empty, making the null percent 95.07. Minimum value is 10 and maximum value is 200.
syvyysarv	int	Data source did not contain a description for SYVYYSARV. Column syvyysarv has 771 rows, out of which 736 are empty, making the null percent 95.46. Minimum value is 5 and maximum value is 100.
tulvkiert1	float	Data source did not contain a description for TULVKIERT1. Column is empty.
tulvkiert2	float	Data source did not contain a description for TULVKIERT2. Column is empty.
tulvatekst	string	Data source did not contain a description for TULVATEKST. Column tulvatekst has 771 rows, out of which 138 are empty, making the null percent 17.90. First 25 characters of minimum string: ... and first 25 characters of maximum string: Östrasidan - Överby. Tie...
id	int	Data source did not contain a description for ID. Column is empty.
muutospvm	date	Data source did not contain a description for MUUTOSPVM. Column is empty.
ualue	int	Data source did not contain a description for UALUE. Column ualue has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 132 and maximum value is 1437.
s_ualue	string	Data source did not contain a description for S_UALUE. Column s_ualue has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus 17-22 and maximum string is Äänekoski 19-24.
liva	string	Data source did not contain a description for LIVA. Column liva has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Pohjanmaan ELY and maximum string is Varsinais-Suomen ELY.
kuntakoodi	int	Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
kunta	string	Data source did not contain a description for KUNTA. Column kunta has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alajärvi and maximum string is Äänekoski.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 19.
maakunta	string	Data source did not contain a description for MAAKUNTA. Column maakunta has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Karjala and maximum string is Varsinais-Suomi.
laani	string	Data source did not contain a description for LAANI. Column laani has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Suomen lääni and maximum string is Oulun l??ni.
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 8406 and maximum value is 10022.
ely	int	Data source did not contain a description for ELY. Column ely has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 14.
tie	int	Data source did not contain a description for TIE. Column tie has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 70956.
lakkautpvm	date	Data source did not contain a description for LAKKAUTPVM. Column is empty.
ajr	int	Data source did not contain a description for AJR. Column ajr has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
aosa	int	Data source did not contain a description for AOSA. Column aosa has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 970.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (21.3397150497... and first 25 characters of maximum string: LINESTRING (31.0750400626...
geom_center_x	double	Longitude of the centroid of the geometry. Column is empty.
geom_center_y	double	Latitude of the centroid of the geometry. Column is empty.
geom_type	string	Geometry type. Column geom_type has 771 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING.

Additional Info

Last Updated	September 11, 2020
Created	July 9, 2018