To download the data set, please sign up or log in

Väyläalue - Väyläalue (vesiväyläaineisto)

Väyläalue - Farledsområde (farledsdata)

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