To download the data set, please sign up or log in
Valosektorit - Valosektorit (vesiväyläaineisto)
Tables
-
Valosektorit, Avoinvalosektorit, 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
Valosektorit, Avoinvalosektorit, Latest
| Column | Type | Comment |
|---|---|---|
| tlnumero | int | Data source did not contain a description for TLNUMERO. Column tlnumero has 6577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 86048. |
| loisto | int | Data source did not contain a description for LOISTO. Column loisto has 6577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4894 and maximum value is 221062. |
| alkukulma | int | Data source did not contain a description for ALKUKULMA. Column alkukulma has 6577 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 359. |
| loppukulma | int | Data source did not contain a description for LOPPUKULMA. Column loppukulma has 6577 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 360. |
| varis | string | Data source did not contain a description for VARIS. Column varis has 6577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is k and maximum string is vi. |
| irrotus_pv | timestamp | Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 6577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-09-09 01:19:26 and maximum value is 2020-09-09 01:19:34. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 6577 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 (30.05898109570125 ... |
| 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 6577 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 9, 2020 |
|---|---|
| Created | July 9, 2018 |