To download the data set, please sign up or log in
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 |