Merenkulun turvalaitteet - Merenkulun turvalaitteet (vesiväyläaineisto)

Merenkulun turvalaitteet - Sjöfartens säkerhetsanordningar (farledsdata)

Tables

Turvalaitteet, Avointurvalaitteet, 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

Turvalaitteet, Avointurvalaitteet, Latest

Column	Type	Comment
tlnumero	int	Data source did not contain a description for TLNUMERO. Column tlnumero has 35043 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 86253.
omistaja	string	Data source did not contain a description for OMISTAJA. Column omistaja has 35043 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...
tila	string	Data source did not contain a description for TILA. Column tila has 35043 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: VAHVISTETTU.
pata_tyyp	int	Data source did not contain a description for PATA_TYYP. Column pata_tyyp has 35043 rows, out of which 7 are empty, making the null percent 0.02. Minimum value is 0 and maximum value is 65.
tklnumero	int	Data source did not contain a description for TKLNUMERO. Column tklnumero has 35043 rows, out of which 6 are empty, making the null percent 0.02. Minimum value is 0 and maximum value is 63.
ty_jnr	int	Data source did not contain a description for TY_JNR. Column ty_jnr has 35043 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 13.
toti_tyyp	int	Data source did not contain a description for TOTI_TYYP. Column toti_tyyp has 35043 rows, out of which 23 are empty, making the null percent 0.07. Minimum value is 0 and maximum value is 5.
pako_tyyp	int	Data source did not contain a description for PAKO_TYYP. Column pako_tyyp has 35043 rows, out of which 21 are empty, making the null percent 0.06. Minimum value is 0 and maximum value is 6.
navl_tyyp	int	Data source did not contain a description for NAVL_TYYP. Column navl_tyyp has 35043 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 99.
rakt_tyyp	int	Data source did not contain a description for RAKT_TYYP. Column rakt_tyyp has 35043 rows, out of which 32480 are empty, making the null percent 92.69. Minimum value is 1 and maximum value is 20.
rak_vuosi	int	Data source did not contain a description for RAK_VUOSI. Column rak_vuosi has 35043 rows, out of which 19499 are empty, making the null percent 55.64. Minimum value is 2 and maximum value is 19902003.
subtype	string	Data source did not contain a description for SUBTYPE. Column subtype has 35043 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is KELLUVA and maximum string is KIINTE.
sijaintis	string	Data source did not contain a description for SIJAINTIS. Column sijaintis has 35043 rows, out of which 1452 are empty, making the null percent 4.14. First 25 characters of minimum string: ... and first 25 characters of maximum string: Ööperin saaret, pohjoisin...
sijaintir	string	Data source did not contain a description for SIJAINTIR. Column sijaintir has 35043 rows, out of which 20408 are empty, making the null percent 58.24. First 25 characters of minimum string: ... and first 25 characters of maximum string: Övervattensten bakom remm...
nimis	string	Data source did not contain a description for NIMIS. Column nimis has 35043 rows, out of which 1 are empty, making the null percent 0.00. Minimum string is and maximum string is ?selp??.
nimir	string	Data source did not contain a description for NIMIR. Column nimir has 35043 rows, out of which 20941 are empty, making the null percent 59.76. Minimum string is and maximum string is ?selp??.
mitt_pvm	date	Data source did not contain a description for MITT_PVM. Column is empty.
vahv_pvm	date	Data source did not contain a description for VAHV_PVM. Column is empty.
paiv_pvm	date	Data source did not contain a description for PAIV_PVM. Column is empty.
valaistu	string	Data source did not contain a description for VALAISTU. Column valaistu has 35043 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is E and maximum string is K.
fasadivalo	int	Data source did not contain a description for FASADIVALO. Column fasadivalo has 35043 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 1.
huippumerk	int	Data source did not contain a description for HUIPPUMERK. Column huippumerk has 35043 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 1.
tutkaheij	int	Data source did not contain a description for TUTKAHEIJ. Column tutkaheij has 35043 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 6.
vaylat	int	Data source did not contain a description for VAYLAT. Column vaylat has 35043 rows, out of which 972 are empty, making the null percent 2.77. Minimum value is 5 and maximum value is 9560.
irrotus_pv	timestamp	Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 35043 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:16:10 and maximum value is 2020-09-10 01:17:00.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 35043 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (19.13144089739295 ... and first 25 characters of maximum string: POINT (31.28162998499813 ...
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 35043 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.

Additional Info

Last Updated	September 10, 2020
Created	September 25, 2018