Navigointilinja - Navigointilinja (vesiväyläaineisto)

Navigointilinja - Navigationslinje (farledsdata)

Tables

Navigointilinjat, Avoinnavigointilinjat, 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

Navigointilinjat, Avoinnavigointilinjat, Latest

Column	Type	Comment
navlin_ty	int	Data source did not contain a description for NAVLIN_TY. Column navlin_ty has 12670 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 4.
laatulk	int	Data source did not contain a description for LAATULK. Column laatulk has 12670 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.
navlin_syv	float	Data source did not contain a description for NAVLIN_SYV. Column navlin_syv has 12670 rows, out of which 31 are empty, making the null percent 0.24. Minimum value is 0.00 and maximum value is 15.30.
navlin_har	float	Data source did not contain a description for NAVLIN_HAR. Column navlin_har has 12670 rows, out of which 2799 are empty, making the null percent 22.09. Minimum value is 0.00 and maximum value is 18.40.
vert_taso	string	Data source did not contain a description for VERT_TASO. Column vert_taso has 12670 rows, out of which 2706 are empty, making the null percent 21.36. Minimum string is and maximum string is NN122,30.
sade	int	Data source did not contain a description for SADE. Column sade has 12670 rows, out of which 10272 are empty, making the null percent 81.07. Minimum value is 0 and maximum value is 5000.
tosisuunta	float	Data source did not contain a description for TOSISUUNTA. Column tosisuunta has 12670 rows, out of which 4643 are empty, making the null percent 36.65. Minimum value is 0.00 and maximum value is 360.00.
suunta	float	Data source did not contain a description for SUUNTA. Column suunta has 12670 rows, out of which 4644 are empty, making the null percent 36.65. Minimum value is 0.00 and maximum value is 360.00.
tila	int	Data source did not contain a description for TILA. Column tila has 12670 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 5.
omistaja	string	Data source did not contain a description for OMISTAJA. Column omistaja has 12670 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: Ylöjärven kaupunki...
diaarinro	string	Data source did not contain a description for DIAARINRO. Column diaarinro has 12670 rows, out of which 2135 are empty, making the null percent 16.85. 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 12670 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2767 and maximum value is 240865.
pituus	int	Data source did not contain a description for PITUUS. Column pituus has 12670 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4 and maximum value is 50029.
vaylat	int	Data source did not contain a description for VAYLAT. Column vaylat has 12670 rows, out of which 799 are empty, making the null percent 6.31. Minimum value is 10 and maximum value is 9560.
irrotus_pv	timestamp	Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 12670 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:44 and maximum value is 2020-09-11 02:30:59.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 12670 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (19.2780372480... and first 25 characters of maximum string: LINESTRING (31.1640277809...
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 12670 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING.

Additional Info

Last Updated	September 11, 2020
Created	September 25, 2018