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

Väylä - Farled (farledsdata)

Tables

Vaylat, Avoinvaylat, 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

Vaylat, Avoinvaylat, Latest

Column	Type	Comment
jnro	int	Data source did not contain a description for JNRO. Column jnro has 1876 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 9560.
vay_nimisu	string	Data source did not contain a description for VAY_NIMISU. Column vay_nimisu has 1876 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Abborgrundin väylä and maximum string is Överön väylä.
vay_nimiru	string	Data source did not contain a description for VAY_NIMIRU. Column vay_nimiru has 1876 rows, out of which 1076 are empty, making the null percent 57.36. First 25 characters of minimum string: ... and first 25 characters of maximum string: Överö-Mosshaga-Hettor-far...
tila	int	Data source did not contain a description for TILA. Column tila has 1876 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1.
vaylalaji	int	Data source did not contain a description for VAYLALAJI. Column vaylalaji has 1876 rows, out of which 1 are empty, making the null percent 0.05. Minimum value is 1 and maximum value is 2.
valaistus	int	Data source did not contain a description for VALAISTUS. Column valaistus has 1876 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 2.
kulkusyv1	float	Data source did not contain a description for KULKUSYV1. Column kulkusyv1 has 1876 rows, out of which 70 are empty, making the null percent 3.73. Minimum value is 0.00 and maximum value is 15.30.
kulkusyv2	float	Data source did not contain a description for KULKUSYV2. Column kulkusyv2 has 1876 rows, out of which 1618 are empty, making the null percent 86.25. Minimum value is 0.00 and maximum value is 11.00.
kulkusyv3	float	Data source did not contain a description for KULKUSYV3. Column kulkusyv3 has 1876 rows, out of which 1830 are empty, making the null percent 97.55. Minimum value is 0.50 and maximum value is 9.50.
merial_nr	int	Data source did not contain a description for MERIAL_NR. Column merial_nr has 1876 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 25.
seloste_al	string	Data source did not contain a description for SELOSTE_AL. Column seloste_al has 1876 rows, out of which 35 are empty, making the null percent 1.87. First 25 characters of minimum string: ... and first 25 characters of maximum string: Östra Rockelholmin eteläp...
seloste_pa	string	Data source did not contain a description for SELOSTE_PA. Column seloste_pa has 1876 rows, out of which 42 are empty, making the null percent 2.24. First 25 characters of minimum string: ... and first 25 characters of maximum string: Ööperit saarien E-puolell...
diaarinro	string	Data source did not contain a description for DIAARINRO. Column diaarinro has 1876 rows, out of which 1133 are empty, making the null percent 60.39. Minimum string is and maximum string is VÄYLÄ/956/06.02.02/2020.
vahv_pvm	date	Data source did not contain a description for VAHV_PVM. Column is empty.
vayla_lk	string	Data source did not contain a description for VAYLA_LK. Column vayla_lk has 1876 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: VL1: Kauppamerenkulun pää... and first 25 characters of maximum string: VL6: Venereitti...
irrotus_pv	timestamp	Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 1876 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-09-10 01:17:52 and maximum value is 2020-09-10 01:19:24.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 1876 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.4678517401... and first 25 characters of maximum string: MULTILINESTRING ((31.0042...
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 1876 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_MULTILINESTRING.

Additional Info

Last Updated	September 10, 2020
Created	September 26, 2018