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

Baliisi

Baliisi

Tables

Column Descriptions

Rata baliisi, Avoinrata baliisi, Latest

Column Type Comment
alkukm_m string Data source did not contain a description for ALKUKM_M. Column alkukm_m has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0500 and maximum string is 1064+0240.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
baliisitun int Data source did not contain a description for BALIISITUN. Column baliisitun has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10030 and maximum value is 63859.
id int Data source did not contain a description for ID. Column id has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 629354 and maximum value is 909179.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-05-25 21:00:10 and maximum value is 2020-05-25 21:00:19.
kpitoalue int Data source did not contain a description for KPITOALUE. Column kpitoalue has 2555 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 12.
lahdekoodi string Data source did not contain a description for LAHDEKOODI. Column lahdekoodi has 2555 rows, out of which 277 are empty, making the null percent 10.84. Minimum string is and maximum string is TLT.
laji string Data source did not contain a description for LAJI. Column laji has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 111G and maximum string is 183 E.
latauspvm date Data source did not contain a description for LATAUSPVM. Column is empty.
lehti int Data source did not contain a description for LEHTI. Column lehti has 2555 rows, out of which 8 are empty, making the null percent 0.31. Minimum value is 1 and maximum value is 26.
loc_error string Data source did not contain a description for LOC_ERROR. Column loc_error has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: NO ERROR.
loppukm_m string Data source did not contain a description for LOPPUKM_M. Column loppukm_m has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0500 and maximum string is 1064+0240.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
muutospvm date Data source did not contain a description for MUUTOSPVM. Column is empty.
nimi string Data source did not contain a description for NIMI. Column is empty.
numero int Data source did not contain a description for NUMERO. Column numero has 2555 rows, out of which 1684 are empty, making the null percent 65.91. Minimum value is 15 and maximum value is 24877.
objectid int Data source did not contain a description for OBJECTID. Column objectid has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 278193 and maximum value is 280865.
paikka int Data source did not contain a description for PAIKKA. Column paikka has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 400 and maximum value is 4950.
pistekm_m string Data source did not contain a description for PISTEKM_M. Column pistekm_m has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0500 and maximum string is 1064+0240.
pluku_alku int Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 500 and maximum value is 10640240.
pluku_lopp int Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 500 and maximum value is 10640240.
pluku_pist int Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 500 and maximum value is 10640240.
ratanumero int Data source did not contain a description for RATANUMERO. Column ratanumero has 2555 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 751.
sijraidtun string Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 001 EKR HKI-LPV and maximum string is ÄKI 494.
suunta string Data source did not contain a description for SUUNTA. Column suunta has 2555 rows, out of which 5 are empty, making the null percent 0.20. Minimum string is and maximum string is PE.
tarkkuus string Data source did not contain a description for TARKKUUS. Column tarkkuus has 2555 rows, out of which 2264 are empty, making the null percent 88.61. Minimum string is and maximum string is TLT.
tila string Data source did not contain a description for TILA. Column tila has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: KÄYTÖSSÄ.
tyyppi string Data source did not contain a description for TYYPPI. Column tyyppi has 2555 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 231e and maximum string is So421tp.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 2555 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 (21.434973276703925... and first 25 characters of maximum string: POINT (30.597835549870876...
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 2555 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 July 9, 2018