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

Pohjamaa-alue

Pohjamaa-alue

Tables

Column Descriptions

Rata pohjamaa alue, Avoinrata pohjamaa alue, Latest

Column Type Comment
alkukm_m string Data source did not contain a description for ALKUKM_M. Column alkukm_m has 3202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0008+0200 and maximum string is 1084+0660.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
id int Data source did not contain a description for ID. Column id has 3202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 349592 and maximum value is 897216.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 3202 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:32 and maximum value is 2020-05-25 21:00:39.
kpitoalue int Data source did not contain a description for KPITOALUE. Column kpitoalue has 3202 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.
kuvaus string Data source did not contain a description for KUVAUS. Column kuvaus has 3202 rows, out of which 566 are empty, making the null percent 17.68. First 25 characters of minimum string: ... and first 25 characters of maximum string: Ylin silttikerros on kuiv...
lahtotieto string Data source did not contain a description for LAHTOTIETO. Column lahtotieto has 3202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Hl-Tpe pohjanvahvistussuu... and first 25 characters of maximum string: Tiedot peräisin Ratojen l...
latauspvm date Data source did not contain a description for LATAUSPVM. Column is empty.
loc_error string Data source did not contain a description for LOC_ERROR. Column loc_error has 3202 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 3202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0008+0750 and maximum string is 1085+0000.
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.
objectid int Data source did not contain a description for OBJECTID. Column objectid has 3202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 378401 and maximum value is 381609.
pistekm_m string Data source did not contain a description for PISTEKM_M. Column pistekm_m has 3202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0008+0600 and maximum string is 1084+0660.
pluku_alku int Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 3202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 80200 and maximum value is 10840660.
pluku_lopp int Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 3202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 80750 and maximum value is 10850000.
pluku_pist int Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 3202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 80600 and maximum value is 10840660.
ratanumero int Data source did not contain a description for RATANUMERO. Column ratanumero has 3202 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 int Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 3202 rows, out of which 1252 are empty, making the null percent 39.10. Minimum value is 2 and maximum value is 751.
tyyppi string Data source did not contain a description for TYYPPI. Column tyyppi has 3202 rows, out of which 112 are empty, making the null percent 3.50. Minimum string is and maximum string is Pehmeikkö, turve.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (21.2525121022... and first 25 characters of maximum string: MULTILINESTRING ((30.9169...
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 3202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_MULTILINESTRING.

Additional Info

Last Updated September 11, 2020
Created July 9, 2018