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

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