To download the data set, please sign up or log in
Puomit - Puomit (Tierekisterin tietolaji 520)
Tables
-
Tl520, Avointl520, Full historyTSV
Tälle tietolajille inventoidaan puomit ja niiden lukitustieto. Lisäksi kirjataan huoltoaukon tienumero, mikäli puomi kuuluu huoltoaukkoon (tyyppi 1). Huoltoaukon tarkemmat tiedot kerrotaan tietolajilla 519.
-
Tl520, Avointl520, LatestTSV
Tälle tietolajille inventoidaan puomit ja niiden lukitustieto. Lisäksi kirjataan huoltoaukon tienumero, mikäli puomi kuuluu huoltoaukkoon (tyyppi 1). Huoltoaukon tarkemmat tiedot kerrotaan tietolajilla 519.
Column Descriptions
Tl520, Avointl520, Full history
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1295 and maximum value is 3216. |
| ely | int | Data source did not contain a description for ELY. Column ely has 742 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 742 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 87494. |
| 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 742 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 742 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 910. |
| aet | int | Data source did not contain a description for AET. Column aet has 742 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 16110. |
| puoli | int | Data source did not contain a description for PUOLI. Column puoli has 742 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. |
| 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. |
| ptyyppi | int | Data source did not contain a description for PTYYPPI. Column ptyyppi has 742 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_ptyyppi | string | Data source did not contain a description for S_PTYYPPI. Column s_ptyyppi has 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is erikureit and maximum string is tunneli. |
| plukitus | int | Data source did not contain a description for PLUKITUS. Column plukitus has 742 rows, out of which 355 are empty, making the null percent 47.84. Minimum value is 0 and maximum value is 3. |
| s_plukitus | string | Data source did not contain a description for S_PLUKITUS. Column s_plukitus has 742 rows, out of which 355 are empty, making the null percent 47.84. Minimum string is and maximum string is lukoton. |
| haukkonro | int | Data source did not contain a description for HAUKKONRO. Column haukkonro has 742 rows, out of which 487 are empty, making the null percent 65.63. Minimum value is 25 and maximum value is 70025. |
| tunniste | string | Data source did not contain a description for TUNNISTE. Column tunniste has 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Livi1010183 and maximum string is TMTMVL815521336. |
| kuntoluo | int | Data source did not contain a description for KUNTOLUO. Column kuntoluo has 742 rows, out of which 387 are empty, making the null percent 52.16. Minimum value is 1 and maximum value is 5. |
| s_kuntoluo | string | Data source did not contain a description for S_KUNTOLUO. Column s_kuntoluo has 742 rows, out of which 387 are empty, making the null percent 52.16. Minimum string is and maximum string is tyydyttävä. |
| urakka | int | Data source did not contain a description for URAKKA. Column urakka has 742 rows, out of which 716 are empty, making the null percent 96.50. Minimum value is 200 and maximum value is 3007. |
| s_urakka | string | Data source did not contain a description for S_URAKKA. Column s_urakka has 742 rows, out of which 716 are empty, making the null percent 96.50. Minimum string is and maximum string is Vt 12 RaTu. |
| x | int | Data source did not contain a description for X. Column x has 742 rows, out of which 442 are empty, making the null percent 59.57. Minimum value is 226268 and maximum value is 644806. |
| y | int | Data source did not contain a description for Y. Column y has 742 rows, out of which 442 are empty, making the null percent 59.57. Minimum value is 6667042 and maximum value is 7376768. |
| z | float | Data source did not contain a description for Z. 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 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 129 and maximum value is 1435. |
| s_ualue | string | Data source did not contain a description for S_UALUE. Column s_ualue has 742 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 742 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 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 989. |
| kunta | string | Data source did not contain a description for KUNTA. Column kunta has 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Ähtäri. |
| maakuntako | int | Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 742 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 742 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 742 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. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 742 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 (21.176890476116522... and first 25 characters of maximum string: POINT (30.632130977168014... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.18 and maximum value is 30.63. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.86 and maximum value is 66.94. |
| geom_type | string | Geometry type. Column geom_type has 742 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. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Tl520, Avointl520, Latest
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1295 and maximum value is 3216. |
| ely | int | Data source did not contain a description for ELY. Column ely has 742 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 742 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 87494. |
| 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 742 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 742 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 910. |
| aet | int | Data source did not contain a description for AET. Column aet has 742 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 16110. |
| puoli | int | Data source did not contain a description for PUOLI. Column puoli has 742 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. |
| 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. |
| ptyyppi | int | Data source did not contain a description for PTYYPPI. Column ptyyppi has 742 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_ptyyppi | string | Data source did not contain a description for S_PTYYPPI. Column s_ptyyppi has 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is erikureit and maximum string is tunneli. |
| plukitus | int | Data source did not contain a description for PLUKITUS. Column plukitus has 742 rows, out of which 355 are empty, making the null percent 47.84. Minimum value is 0 and maximum value is 3. |
| s_plukitus | string | Data source did not contain a description for S_PLUKITUS. Column s_plukitus has 742 rows, out of which 355 are empty, making the null percent 47.84. Minimum string is and maximum string is lukoton. |
| haukkonro | int | Data source did not contain a description for HAUKKONRO. Column haukkonro has 742 rows, out of which 487 are empty, making the null percent 65.63. Minimum value is 25 and maximum value is 70025. |
| tunniste | string | Data source did not contain a description for TUNNISTE. Column tunniste has 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Livi1010183 and maximum string is TMTMVL815521336. |
| kuntoluo | int | Data source did not contain a description for KUNTOLUO. Column kuntoluo has 742 rows, out of which 387 are empty, making the null percent 52.16. Minimum value is 1 and maximum value is 5. |
| s_kuntoluo | string | Data source did not contain a description for S_KUNTOLUO. Column s_kuntoluo has 742 rows, out of which 387 are empty, making the null percent 52.16. Minimum string is and maximum string is tyydyttävä. |
| urakka | int | Data source did not contain a description for URAKKA. Column urakka has 742 rows, out of which 716 are empty, making the null percent 96.50. Minimum value is 200 and maximum value is 3007. |
| s_urakka | string | Data source did not contain a description for S_URAKKA. Column s_urakka has 742 rows, out of which 716 are empty, making the null percent 96.50. Minimum string is and maximum string is Vt 12 RaTu. |
| x | int | Data source did not contain a description for X. Column x has 742 rows, out of which 442 are empty, making the null percent 59.57. Minimum value is 226268 and maximum value is 644806. |
| y | int | Data source did not contain a description for Y. Column y has 742 rows, out of which 442 are empty, making the null percent 59.57. Minimum value is 6667042 and maximum value is 7376768. |
| z | float | Data source did not contain a description for Z. 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 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 129 and maximum value is 1435. |
| s_ualue | string | Data source did not contain a description for S_UALUE. Column s_ualue has 742 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 742 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 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 989. |
| kunta | string | Data source did not contain a description for KUNTA. Column kunta has 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Ähtäri. |
| maakuntako | int | Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 742 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 742 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 742 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. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 742 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 (21.176890476116522... and first 25 characters of maximum string: POINT (30.632130977168014... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.18 and maximum value is 30.63. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 742 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.86 and maximum value is 66.94. |
| geom_type | string | Geometry type. Column geom_type has 742 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 | September 10, 2020 |