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

Vesiliikennemerkki

Vesiliikennemerkki

Tables

  • Vesiliikennemerkit, Avoinvesiliikennemerkit, 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

Vesiliikennemerkit, Avoinvesiliikennemerkit, Latest

Column Type Comment
tunniste int Data source did not contain a description for TUNNISTE. Column tunniste has 4679 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 4971.
nimis string Data source did not contain a description for NIMIS. Column nimis has 4679 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ? and maximum string is Österviken.
nimir string Data source did not contain a description for NIMIR. Column nimir has 4679 rows, out of which 4580 are empty, making the null percent 97.88. Minimum string is and maximum string is Ångnästö.
sijaintis string Data source did not contain a description for SIJAINTIS. Column sijaintis has 4679 rows, out of which 1006 are empty, making the null percent 21.50. Minimum string is and maximum string is Örön pohjoispäässä.
sijaintir string Data source did not contain a description for SIJAINTIR. Column sijaintir has 4679 rows, out of which 4572 are empty, making the null percent 97.71. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vid inloppet till Vaasa h...
omistaja string Data source did not contain a description for OMISTAJA. Column omistaja has 4679 rows, out of which 532 are empty, making the null percent 11.37. Minimum string is and maximum string is Ääneseudun Energia Oy.
pata_tyyp int Data source did not contain a description for PATA_TYYP. Column pata_tyyp has 4679 rows, out of which 430 are empty, making the null percent 9.19. Minimum value is 0 and maximum value is 65.
tklnumero int Data source did not contain a description for TKLNUMERO. Column tklnumero has 4679 rows, out of which 520 are empty, making the null percent 11.11. Minimum value is 0 and maximum value is 63.
pako_tyyp int Data source did not contain a description for PAKO_TYYP. Column pako_tyyp has 4679 rows, out of which 1364 are empty, making the null percent 29.15. Minimum value is 0 and maximum value is 6.
lisakilpi string Data source did not contain a description for LISAKILPI. Column lisakilpi has 4679 rows, out of which 3880 are empty, making the null percent 82.92. Minimum string is and maximum string is K.
lk_tekstis string Data source did not contain a description for LK_TEKSTIS. Column lk_tekstis has 4679 rows, out of which 3612 are empty, making the null percent 77.20. Minimum string is and maximum string is ÖRÖ.
lk_tekstir string Data source did not contain a description for LK_TEKSTIR. Column lk_tekstir has 4679 rows, out of which 4585 are empty, making the null percent 97.99. First 25 characters of minimum string: ... and first 25 characters of maximum string: VÄLTÄ PERÄAALLON MUODOSTA...
mittauspvm date Data source did not contain a description for MITTAUSPVM. Column is empty.
lisatietos string Data source did not contain a description for LISATIETOS. Column lisatietos has 4679 rows, out of which 3248 are empty, making the null percent 69.42. Minimum string is and maximum string is yleistaulu.
lisatietor string Data source did not contain a description for LISATIETOR. Column lisatietor has 4679 rows, out of which 4402 are empty, making the null percent 94.08. Minimum string is and maximum string is Y-koordinaatti?.
paatos string Data source did not contain a description for PAATOS. Column paatos has 4679 rows, out of which 3406 are empty, making the null percent 72.79. Minimum string is and maximum string is YTM314/30.3.1992.
vaylalaji string Data source did not contain a description for VAYLALAJI. Column vaylalaji has 4679 rows, out of which 3462 are empty, making the null percent 73.99. Minimum string is and maximum string is S.
vaikutusal string Data source did not contain a description for VAIKUTUSAL. Column vaikutusal has 4679 rows, out of which 463 are empty, making the null percent 9.90. Minimum string is and maximum string is V.
vlm_tyyppi int Data source did not contain a description for VLM_TYYPPI. Column vlm_tyyppi has 4679 rows, out of which 6 are empty, making the null percent 0.13. Minimum value is 0 and maximum value is 6.
vlm_laji int Data source did not contain a description for VLM_LAJI. Column vlm_laji has 4679 rows, out of which 61 are empty, making the null percent 1.30. Minimum value is 0 and maximum value is 35.
ra_arvo int Data source did not contain a description for RA_ARVO. Column ra_arvo has 4679 rows, out of which 2858 are empty, making the null percent 61.08. Minimum value is 0 and maximum value is 46.
ra_arvo_t int Data source did not contain a description for RA_ARVO_T. Column ra_arvo_t has 4679 rows, out of which 3778 are empty, making the null percent 80.74. Minimum value is 2 and maximum value is 46.
jnro int Data source did not contain a description for JNRO. Column jnro has 4679 rows, out of which 750 are empty, making the null percent 16.03. Minimum value is 220 and maximum value is 9550.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 4679 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:08 and maximum value is 2020-09-10 01:17:17.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 4679 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 (20.381319954436552... and first 25 characters of maximum string: POINT (30.227957039754322...
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 4679 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 11, 2020
Created September 25, 2018
score 0.8312017163987265