To download the data set, please sign up or log in
Valaistus
Tables
-
Tl167, Avointl167, LatestTSV
Tierekisterin valaistus-tietolaji. Kattaa Liikenneviraston ylläpitämän maantieverkon. Valaistuksi tieosuudeksi katsotaan 2 tai useamman valaisimen muodostama kokonaisuus tiellä. Käytännössä saattaa esiintyä tapauksia, joissa valaisimet ovat suurin välimatkoin ja heikkotehoisia. Nämäkin osuudet on huomioitava, mikäli valaisimet liittyvät samaan kokonaisuuteen. Valaistuksen tieosoitteet määritellään ko. osuuden ensimmäisen ja viimeisen valaisinpylvään mukaan. Kuvaustekniikka perustuu: valaistuksen omistaja ilmoitetaan koodilla 0 = valaistus on varsinaisella tiellä, 1 = Liikennevirasto omistaa, 2 = kunta omista, 9 = oletusarvo, jos vanhassa tierekisterissä ei ole ilmoitettu omistajaa
Column Descriptions
Tl167, Avointl167, Latest
| Column | Type | Comment |
|---|---|---|
| objectid | int | Data source did not contain a description for OBJECTID. Column objectid has 30211 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 305270 and maximum value is 336228. |
| ely | int | Data source did not contain a description for ELY. Column ely has 30211 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 30211 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 98410. |
| 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 30211 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 30211 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 998. |
| aet | int | Data source did not contain a description for AET. Column aet has 30211 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 26641. |
| losa | int | Data source did not contain a description for LOSA. Column losa has 30211 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 998. |
| let | int | Data source did not contain a description for LET. Column let has 30211 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 27041. |
| puoli | int | Data source did not contain a description for PUOLI. Column puoli has 30211 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0. |
| 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. |
| valoom | int | Data source did not contain a description for VALOOM. Column valoom has 30211 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 9. |
| s_valoom | string | Data source did not contain a description for S_VALOOM. Column s_valoom has 30211 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 valtio. |
| valohoi | int | Data source did not contain a description for VALOHOI. Column valohoi has 30211 rows, out of which 146 are empty, making the null percent 0.48. Minimum value is 0 and maximum value is 3. |
| s_valohoi | string | Data source did not contain a description for S_VALOHOI. Column s_valohoi has 30211 rows, out of which 146 are empty, making the null percent 0.48. Minimum string is and maximum string is valtio. |
| valopylv | int | Data source did not contain a description for VALOPYLV. Column valopylv has 30211 rows, out of which 13510 are empty, making the null percent 44.72. Minimum value is 0 and maximum value is 6. |
| s_valopylv | string | Data source did not contain a description for S_VALOPYLV. Column s_valopylv has 30211 rows, out of which 13510 are empty, making the null percent 44.72. Minimum string is and maximum string is terpysä. |
| valolamp | int | Data source did not contain a description for VALOLAMP. Column valolamp has 30211 rows, out of which 15092 are empty, making the null percent 49.96. Minimum value is 0 and maximum value is 30. |
| s_valolamp | string | Data source did not contain a description for S_VALOLAMP. Column s_valolamp has 30211 rows, out of which 15092 are empty, making the null percent 49.96. Minimum string is and maximum string is SPNA70. |
| valokaap | int | Data source did not contain a description for VALOKAAP. Column valokaap has 30211 rows, out of which 12651 are empty, making the null percent 41.88. Minimum value is 0 and maximum value is 2. |
| s_valokaap | string | Data source did not contain a description for S_VALOKAAP. Column s_valokaap has 30211 rows, out of which 12651 are empty, making the null percent 41.88. Minimum string is and maximum string is maassa. |
| valotorm | int | Data source did not contain a description for VALOTORM. Column valotorm has 30211 rows, out of which 15287 are empty, making the null percent 50.60. Minimum value is 0 and maximum value is 2. |
| s_valotorm | string | Data source did not contain a description for S_VALOTORM. Column s_valotorm has 30211 rows, out of which 15287 are empty, making the null percent 50.60. Minimum string is and maximum string is vaarall. |
| valourak | int | Data source did not contain a description for VALOURAK. Column valourak has 30211 rows, out of which 268 are empty, making the null percent 0.89. Minimum value is 0 and maximum value is 2117. |
| s_valourak | string | Data source did not contain a description for S_VALOURAK. Column s_valourak has 30211 rows, out of which 268 are empty, making the null percent 0.89. Minimum string is and maximum string is vu Lä-Uusi. |
| tu_valou | int | Data source did not contain a description for TU_VALOU. Column tu_valou has 30211 rows, out of which 12186 are empty, making the null percent 40.34. Minimum value is 0 and maximum value is 2117. |
| s_tu_valou | string | Data source did not contain a description for S_TU_VALOU. Column s_tu_valou has 30211 rows, out of which 12186 are empty, making the null percent 40.34. Minimum string is and maximum string is vu Lä-Uusi. |
| 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. |
| poisto | float | Data source did not contain a description for POISTO. Column is empty. |
| ualue | int | Data source did not contain a description for UALUE. Column ualue has 30211 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 9000. |
| s_ualue | string | Data source did not contain a description for S_UALUE. Column s_ualue has 30211 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 30211 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 30211 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 30211 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 Äänekoski. |
| maakuntako | int | Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 30211 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 30211 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 30211 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 30211 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 (20.7637678384... and first 25 characters of maximum string: MULTILINESTRING ((30.0356... |
| geom_center_x | float | Longitude of center. Column is empty. |
| geom_center_y | float | Latitude of center. Column is empty. |
| geom_type | string | Geometry type. Column geom_type has 30211 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_MULTILINESTRING. |
Additional Info
| Last Updated | September 11, 2020 |
|---|---|
| Created | July 9, 2018 |