To download the data set, please sign up or log in
Loistot - Loistot (vesiväyläaineisto)
Tables
-
Loistot, Avoinloistot, LatestTSV
Vesiväyläaineisto on Liikenneviraston vesiväylärekisterissä ylläpidettävä aineisto, joka sisältää viralliset vesiväylätiedot ja merenkulun turvalaitteiden tiedot. Lisäksi aineistoon kuuluvat ruoppaus- ja läjitysalueet, vesiväyliin liittyvät rajoitusalueet sekä vesiliikennemerkit. Aineisto on luonteeltaan väyläomaisuuden hallintaan tarkoitettua perusrekisteritietoa.
Column Descriptions
Loistot, Avoinloistot, Latest
| Column | Type | Comment |
|---|---|---|
| jnr | int | Data source did not contain a description for JNR. Column jnr has 4792 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4894 and maximum value is 221062. |
| kiin_valov | int | Data source did not contain a description for KIIN_VALOV. Column kiin_valov has 4792 rows, out of which 2496 are empty, making the null percent 52.09. Minimum value is 0 and maximum value is 4715379. |
| laji | string | Data source did not contain a description for LAJI. Column laji has 4792 rows, out of which 562 are empty, making the null percent 11.73. Minimum string is and maximum string is Yövalo. |
| maa_kanto | float | Data source did not contain a description for MAA_KANTO. Column maa_kanto has 4792 rows, out of which 62 are empty, making the null percent 1.29. Minimum value is 1.00 and maximum value is 44.70. |
| teho_valov | int | Data source did not contain a description for TEHO_VALOV. Column teho_valov has 4792 rows, out of which 1992 are empty, making the null percent 41.57. Minimum value is 0 and maximum value is 4563270. |
| tark_valot | string | Data source did not contain a description for TARK_VALOT. Column tark_valot has 4792 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is - (Ki-F) and maximum string is 9*(0,2+0,4) + 4,6=10,0 s. |
| tlnumero | int | Data source did not contain a description for TLNUMERO. Column tlnumero has 4792 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 86048. |
| vir_valot | string | Data source did not contain a description for VIR_VALOT. Column vir_valot has 4792 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ka-Int 10 s and maximum string is V-B 7 s. |
| opt_kanto | float | Data source did not contain a description for OPT_KANTO. Column opt_kanto has 4792 rows, out of which 85 are empty, making the null percent 1.77. Minimum value is 0.60 and maximum value is 27.50. |
| laatu | string | Data source did not contain a description for LAATU. Column laatu has 4792 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lisäloist and maximum string is Pääloist. |
| tahdistus | string | Data source did not contain a description for TAHDISTUS. Column tahdistus has 4792 rows, out of which 225 are empty, making the null percent 4.70. Minimum string is and maximum string is K. |
| kork_ved | float | Data source did not contain a description for KORK_VED. Column kork_ved has 4792 rows, out of which 82 are empty, making the null percent 1.71. Minimum value is 1.50 and maximum value is 370.00. |
| kork_maa | float | Data source did not contain a description for KORK_MAA. Column kork_maa has 4792 rows, out of which 2277 are empty, making the null percent 47.52. Minimum value is 0.00 and maximum value is 326.00. |
| irrotus_pv | timestamp | Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 4792 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-09-10 01:19:25 and maximum value is 2020-09-10 01:19:33. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 4792 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 (19.13144089739295 ... and first 25 characters of maximum string: POINT (30.05898109570125 ... |
| 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 4792 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 |