To download the data set, please sign up or log in
Ruoppausalue - Ruoppausalue (vesiväyläaineisto)
Tables
-
Ruoppausalueet, Avoinruoppausalueet, 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
Ruoppausalueet, Avoinruoppausalueet, Latest
| Column | Type | Comment |
|---|---|---|
| gdo_gid | int | Data source did not contain a description for GDO_GID. Column gdo_gid has 739 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 101841 and maximum value is 240915. |
| ruop_taso | float | Data source did not contain a description for RUOP_TASO. Column ruop_taso has 739 rows, out of which 135 are empty, making the null percent 18.27. Minimum value is -14.40 and maximum value is 95.65. |
| vert_taso | string | Data source did not contain a description for VERT_TASO. Column vert_taso has 739 rows, out of which 66 are empty, making the null percent 8.93. Minimum string is and maximum string is NN+98.85. |
| vuodet | int | Data source did not contain a description for VUODET. Column vuodet has 739 rows, out of which 352 are empty, making the null percent 47.63. Minimum value is 1972 and maximum value is 2018. |
| maalaatu | string | Data source did not contain a description for MAALAATU. Column maalaatu has 739 rows, out of which 252 are empty, making the null percent 34.10. Minimum string is and maximum string is Sr, Mr, Hk, Si. |
| ruop_menet | int | Data source did not contain a description for RUOP_MENET. Column ruop_menet has 739 rows, out of which 150 are empty, making the null percent 20.30. Minimum value is 0 and maximum value is 3. |
| lajitys | int | Data source did not contain a description for LAJITYS. Column lajitys has 739 rows, out of which 443 are empty, making the null percent 59.95. Minimum value is 101840 and maximum value is 228627. |
| irrotus_pv | timestamp | Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 739 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-09-11 02:28:44 and maximum value is 2020-09-11 02:28:46. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 739 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POLYGON ((19.903806314714... and first 25 characters of maximum string: POLYGON ((29.914552370463... |
| geom_center_x | double | Longitude of the centroid of the geometry. Column geom_center_x has 739 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.90 and maximum value is 29.91. |
| geom_center_y | double | Latitude of the centroid of the geometry. Column geom_center_y has 739 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.74 and maximum value is 65.73. |
| geom_type | string | Geometry type. Column geom_type has 739 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POLYGON. |
Additional Info
| Last Updated | September 11, 2020 |
|---|---|
| Created | July 9, 2018 |