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

Viemärit

Viemärit

Tables

  • Tl512, Avointl512, LatestTSV

    Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tälle tietolajille inventoidaan maantien tai kevyen liikenteen väylän kuivatukseen liittyvät sadevesi- ja salaojakaivot sekä niiden kunto siltä osin kuin ne ovat silmämääräisesti nähtävissä. Sadevesikaivojen kannet on aukaistava jos mahdollista. Kaivoista tarkistetaan perustiedot ml. lähtöjen ja tulojen määrät sekä kaivon ja kannen tyyppi ja materiaali. Myös puutteet inventoidaan. Lisäksi tarkistetaan mahdollisuuksien mukaan kannen säätömahdollisuus. Putkista selvitetään materiaali ja halkaisija.

Column Descriptions

Tl512, Avointl512, Latest

Column Type Comment
ajr int Data source did not contain a description for AJR. Column ajr has 43658 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 43658 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 997.
aet int Data source did not contain a description for AET. Column aet has 43658 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 24809.
puoli int Data source did not contain a description for PUOLI. Column puoli has 43658 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 8.
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.
tunniste string Data source did not contain a description for TUNNISTE. Column tunniste has 43658 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Livi1003442 and maximum string is TMTMVL800044242.
urakka int Data source did not contain a description for URAKKA. Column urakka has 43658 rows, out of which 43368 are empty, making the null percent 99.34. Minimum value is 100 and maximum value is 3007.
s_urakka string Data source did not contain a description for S_URAKKA. Column s_urakka has 43658 rows, out of which 43368 are empty, making the null percent 99.34. Minimum string is and maximum string is yrittäjä.
x int Data source did not contain a description for X. Column x has 43658 rows, out of which 9590 are empty, making the null percent 21.97. Minimum value is 197080 and maximum value is 961943.
y int Data source did not contain a description for Y. Column y has 43658 rows, out of which 9590 are empty, making the null percent 21.97. Minimum value is 6661809 and maximum value is 7775228.
z int Data source did not contain a description for Z. Column z has 43658 rows, out of which 43569 are empty, making the null percent 99.80. Minimum value is 1 and maximum value is 984.
viempaik int Data source did not contain a description for VIEMPAIK. Column viempaik has 43658 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 6.
s_viempaik string Data source did not contain a description for S_VIEMPAIK. Column s_viempaik has 43658 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is levahdysal and maximum string is välikaista.
kansikoko int Data source did not contain a description for KANSIKOKO. Column kansikoko has 43658 rows, out of which 1479 are empty, making the null percent 3.39. Minimum value is 0 and maximum value is 9550.
kaivohalk int Data source did not contain a description for KAIVOHALK. Column kaivohalk has 43658 rows, out of which 1471 are empty, making the null percent 3.37. Minimum value is 0 and maximum value is 8000.
kaivosyv int Data source did not contain a description for KAIVOSYV. Column kaivosyv has 43658 rows, out of which 5185 are empty, making the null percent 11.88. Minimum value is 0 and maximum value is 25000.
kaivolahto int Data source did not contain a description for KAIVOLAHTO. Column kaivolahto has 43658 rows, out of which 3903 are empty, making the null percent 8.94. Minimum value is 0 and maximum value is 5.
kaivotulo int Data source did not contain a description for KAIVOTULO. Column kaivotulo has 43658 rows, out of which 4246 are empty, making the null percent 9.73. Minimum value is 0 and maximum value is 12.
sakkapesa float Data source did not contain a description for SAKKAPESA. Column is empty.
kaivotyy int Data source did not contain a description for KAIVOTYY. Column kaivotyy has 43658 rows, out of which 751 are empty, making the null percent 1.72. Minimum value is 1 and maximum value is 5.
s_kaivotyy string Data source did not contain a description for S_KAIVOTYY. Column s_kaivotyy has 43658 rows, out of which 751 are empty, making the null percent 1.72. Minimum string is and maximum string is Yhdistetty.
kaivomat int Data source did not contain a description for KAIVOMAT. Column kaivomat has 43658 rows, out of which 1442 are empty, making the null percent 3.30. Minimum value is 6 and maximum value is 13.
s_kaivomat string Data source did not contain a description for S_KAIVOMAT. Column s_kaivomat has 43658 rows, out of which 1442 are empty, making the null percent 3.30. Minimum string is and maximum string is valurauta.
kansisaato float Data source did not contain a description for KANSISAATO. Column is empty.
kansityy int Data source did not contain a description for KANSITYY. Column kansityy has 43658 rows, out of which 862 are empty, making the null percent 1.97. Minimum value is 1 and maximum value is 4.
s_kansityy string Data source did not contain a description for S_KANSITYY. Column s_kansityy has 43658 rows, out of which 862 are empty, making the null percent 1.97. Minimum string is and maximum string is umpi.
kansimat int Data source did not contain a description for KANSIMAT. Column kansimat has 43658 rows, out of which 1392 are empty, making the null percent 3.19. Minimum value is 1 and maximum value is 13.
s_kansimat string Data source did not contain a description for S_KANSIMAT. Column s_kansimat has 43658 rows, out of which 1392 are empty, making the null percent 3.19. Minimum string is and maximum string is vaneri.
putkihalk int Data source did not contain a description for PUTKIHALK. Column putkihalk has 43658 rows, out of which 4749 are empty, making the null percent 10.88. Minimum value is 0 and maximum value is 4000.
putkimat int Data source did not contain a description for PUTKIMAT. Column putkimat has 43658 rows, out of which 21324 are empty, making the null percent 48.84. Minimum value is 1 and maximum value is 13.
s_putkimat string Data source did not contain a description for S_PUTKIMAT. Column s_putkimat has 43658 rows, out of which 21324 are empty, making the null percent 48.84. Minimum string is and maximum string is valurauta.
kansijuu int Data source did not contain a description for KANSIJUU. Column kansijuu has 43658 rows, out of which 37717 are empty, making the null percent 86.39. Minimum value is 0 and maximum value is 1.
s_kansijuu string Data source did not contain a description for S_KANSIJUU. Column s_kansijuu has 43658 rows, out of which 37717 are empty, making the null percent 86.39. Minimum string is and maximum string is on.
kaivoliet float Data source did not contain a description for KAIVOLIET. Column is empty.
kaivotukk float Data source did not contain a description for KAIVOTUKK. Column is empty.
kaivorisa float Data source did not contain a description for KAIVORISA. Column is empty.
kansirisa float Data source did not contain a description for KANSIRISA. Column is empty.
kansiylh int Data source did not contain a description for KANSIYLH. Column kansiylh has 43658 rows, out of which 38025 are empty, making the null percent 87.10. Minimum value is 0 and maximum value is 1.
kansialh int Data source did not contain a description for KANSIALH. Column kansialh has 43658 rows, out of which 37639 are empty, making the null percent 86.21. Minimum value is 0 and maximum value is 1.
maasyopyn float Data source did not contain a description for MAASYOPYN. Column is empty.
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 43658 rows, out of which 1 are empty, making the null percent 0.00. Minimum value is 129 and maximum value is 1437.
s_ualue string Data source did not contain a description for S_UALUE. Column s_ualue has 43658 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is Äänekoski 19-24.
liva string Data source did not contain a description for LIVA. Column liva has 43658 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 43658 rows, out of which 1 are empty, making the null percent 0.00. Minimum value is 5 and maximum value is 992.
kunta string Data source did not contain a description for KUNTA. Column kunta has 43658 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is Äänekoski.
maakuntako int Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 43658 rows, out of which 1 are empty, making the null percent 0.00. Minimum value is 1 and maximum value is 19.
maakunta string Data source did not contain a description for MAAKUNTA. Column maakunta has 43658 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is Varsinais-Suomi.
laani string Data source did not contain a description for LAANI. Column laani has 43658 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is Oulun l??ni.
objectid int Data source did not contain a description for OBJECTID. Column objectid has 43658 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 226336 and maximum value is 274734.
ely int Data source did not contain a description for ELY. Column ely has 43658 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 43658 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 98404.
lakkautpvm date Data source did not contain a description for LAKKAUTPVM. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 43658 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (20.76378921029152 ... and first 25 characters of maximum string: POINT (30.960133023826792...
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 43658 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.

Additional Info

Last Updated September 11, 2020
Created July 9, 2018