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