To download the data set, please sign up or log in
Väyläalue - Väyläalue (vesiväyläaineisto)
Tables
-
Vaylaalueet, Avoinvaylaalueet, 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
Vaylaalueet, Avoinvaylaalueet, Latest
| Column | Type | Comment |
|---|---|---|
| laatulk | int | Data source did not contain a description for LAATULK. Column laatulk has 3512 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 3. |
| vayalue_ty | int | Data source did not contain a description for VAYALUE_TY. Column vayalue_ty has 3512 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. |
| vayalue_sy | float | Data source did not contain a description for VAYALUE_SY. Column vayalue_sy has 3512 rows, out of which 17 are empty, making the null percent 0.48. Minimum value is 0.00 and maximum value is 15.30. |
| haraus_syv | float | Data source did not contain a description for HARAUS_SYV. Column haraus_syv has 3512 rows, out of which 3 are empty, making the null percent 0.09. Minimum value is 0.00 and maximum value is 19.00. |
| vert_taso | string | Data source did not contain a description for VERT_TASO. Column vert_taso has 3512 rows, out of which 10 are empty, making the null percent 0.28. Minimum string is and maximum string is NN+98.85. |
| tila | int | Data source did not contain a description for TILA. Column tila has 3512 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 3. |
| suunta | int | Data source did not contain a description for SUUNTA. Column suunta has 3512 rows, out of which 281 are empty, making the null percent 8.00. Minimum value is 0 and maximum value is 360. |
| merk_laji | int | Data source did not contain a description for MERK_LAJI. Column merk_laji has 3512 rows, out of which 567 are empty, making the null percent 16.14. Minimum value is 0 and maximum value is 2. |
| omistaja | string | Data source did not contain a description for OMISTAJA. Column omistaja has 3512 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ahvenanmaan maakuntahalli... and first 25 characters of maximum string: Vöyrin kunta... |
| diaarinro | string | Data source did not contain a description for DIAARINRO. Column diaarinro has 3512 rows, out of which 44 are empty, making the null percent 1.25. Minimum string is and maximum string is VÄYLÄ/8634/06.02.02/201. |
| vahv_pvm | date | Data source did not contain a description for VAHV_PVM. Column is empty. |
| gdo_gid | int | Data source did not contain a description for GDO_GID. Column gdo_gid has 3512 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 34856 and maximum value is 240695. |
| jnro | int | Data source did not contain a description for JNRO. Column jnro has 3512 rows, out of which 254 are empty, making the null percent 7.23. Minimum value is 10 and maximum value is 9216. |
| irrotus_pv | timestamp | Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 3512 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:31 and maximum value is 2020-09-11 02:28:36. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 3512 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.449142034481... and first 25 characters of maximum string: POLYGON ((30.237407873733... |
| geom_center_x | double | Longitude of the centroid of the geometry. Column geom_center_x has 3512 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.41 and maximum value is 30.24. |
| geom_center_y | double | Latitude of the centroid of the geometry. Column geom_center_y has 3512 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.67 and maximum value is 65.76. |
| geom_type | string | Geometry type. Column geom_type has 3512 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 | September 25, 2018 |