1. Home
  2. Datasets
  3. Tutkamajakat - Tutkamajakka ...
To download the data set, please sign up or log in

Tutkamajakat - Tutkamajakka (vesiväyläaineisto)

Tutkamajakat - Radarfyrar (farledsdata)

Tables

  • Tutkamajakat, Avointutkamajakat, 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

Tutkamajakat, Avointutkamajakat, Latest

Column Type Comment
jnr int Data source did not contain a description for JNR. Column jnr has 56 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 47512 and maximum value is 217154.
periodion int Data source did not contain a description for PERIODION. Column periodion has 56 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6 and maximum value is 30.
periodioff int Data source did not contain a description for PERIODIOFF. Column periodioff has 56 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 84.
tlnumero int Data source did not contain a description for TLNUMERO. Column tlnumero has 56 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 81 and maximum value is 80357.
tunnuss int Data source did not contain a description for TUNNUSS. Column tunnuss has 56 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 15.
tunnuspit float Data source did not contain a description for TUNNUSPIT. Column tunnuspit has 56 rows, out of which 9 are empty, making the null percent 16.07. Minimum value is 0.40 and maximum value is 11.00.
lajis int Data source did not contain a description for LAJIS. Column lajis has 56 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.
malli int Data source did not contain a description for MALLI. Column malli has 56 rows, out of which 1 are empty, making the null percent 1.79. Minimum value is 2 and maximum value is 10.
kantamas float Data source did not contain a description for KANTAMAS. Column kantamas has 56 rows, out of which 13 are empty, making the null percent 23.21. Minimum value is 7.80 and maximum value is 15.10.
taajuuss string Data source did not contain a description for TAAJUUSS. Column taajuuss has 56 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.
taajuusx string Data source did not contain a description for TAAJUUSX. Column taajuusx has 56 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.
kantamax float Data source did not contain a description for KANTAMAX. Column kantamax has 56 rows, out of which 1 are empty, making the null percent 1.79. Minimum value is 9.50 and maximum value is 18.10.
asenn_kork float Data source did not contain a description for ASENN_KORK. Column asenn_kork has 56 rows, out of which 1 are empty, making the null percent 1.79. Minimum value is 7.00 and maximum value is 54.20.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 56 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:15:59 and maximum value is 2020-09-10 01:16:08.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 56 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.7820565586038 5... and first 25 characters of maximum string: POINT (27.240072716245006...
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 56 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 July 9, 2018