To download the data set, please sign up or log in
Läjitysalue - Läjitysalue (vesiväyläaineisto)
Tables
-
Lajitysalueet, Avoinlajitysalueet, 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
Lajitysalueet, Avoinlajitysalueet, Latest
| Column | Type | Comment |
|---|---|---|
| gdo_gid | int | Data source did not contain a description for GDO_GID. Column gdo_gid has 196 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100418 and maximum value is 237524. |
| laj_taso | int | Data source did not contain a description for LAJ_TASO. Column laj_taso has 196 rows, out of which 126 are empty, making the null percent 64.29. Minimum value is -50 and maximum value is 94. |
| vert_taso | string | Data source did not contain a description for VERT_TASO. Column vert_taso has 196 rows, out of which 34 are empty, making the null percent 17.35. Minimum string is and maximum string is NN+98.85. |
| vuodet | int | Data source did not contain a description for VUODET. Column vuodet has 196 rows, out of which 119 are empty, making the null percent 60.71. Minimum value is 1970 and maximum value is 2018. |
| maalaatu | string | Data source did not contain a description for MAALAATU. Column maalaatu has 196 rows, out of which 92 are empty, making the null percent 46.94. Minimum string is and maximum string is Sa, Si. |
| laj_tyyppi | int | Data source did not contain a description for LAJ_TYYPPI. Column laj_tyyppi has 196 rows, out of which 8 are empty, making the null percent 4.08. Minimum value is 0 and maximum value is 2. |
| ruoppaus | int | Data source did not contain a description for RUOPPAUS. Column ruoppaus has 196 rows, out of which 136 are empty, making the null percent 69.39. Minimum value is 104829 and maximum value is 187774. |
| irrotus_pv | timestamp | Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 196 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:30:43 and maximum value is 2020-09-11 02:30:44. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 196 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.896194648462... and first 25 characters of maximum string: POLYGON ((29.877074403650... |
| geom_center_x | double | Longitude of the centroid of the geometry. Column geom_center_x has 196 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.87. |
| geom_center_y | double | Latitude of the centroid of the geometry. Column geom_center_y has 196 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.76. |
| geom_type | string | Geometry type. Column geom_type has 196 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 |