1. Home
  2. Datasets
  3. Rumpu
To download the data set, please sign up or log in

Rumpu

Rumpu

Tables

Column Descriptions

Rata rumpu, Avoinrata rumpu, Latest

Column Type Comment
alkukm_m string Data source did not contain a description for ALKUKM_M. Column alkukm_m has 6684 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0003+0275 and maximum string is 1132+0831.
alkupvm date Data source did not contain a description for ALKUPVM. Column is empty.
halkaisija float Data source did not contain a description for HALKAISIJA. Column halkaisija has 6684 rows, out of which 1381 are empty, making the null percent 20.66. Minimum value is 0.00 and maximum value is 2.40.
id int Data source did not contain a description for ID. Column id has 6684 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 348404 and maximum value is 909426.
kesklinjkv int Data source did not contain a description for KESKLINJKV. Column kesklinjkv has 6684 rows, out of which 362 are empty, making the null percent 5.42. Minimum value is 0 and maximum value is 90.
kunnpitaja string Data source did not contain a description for KUNNPITAJA. Column kunnpitaja has 6684 rows, out of which 5955 are empty, making the null percent 89.09. Minimum string is and maximum string is Yksityinen.
kpitoalue int Data source did not contain a description for KPITOALUE. Column kpitoalue has 6684 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.
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 6684 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 6684 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0003+0275 and maximum string is 1132+0831.
loppupvm date Data source did not contain a description for LOPPUPVM. Column is empty.
maatukrv int Data source did not contain a description for MAATUKRV. Column maatukrv has 6684 rows, out of which 6019 are empty, making the null percent 90.05. Minimum value is 200 and maximum value is 2018.
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 6684 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 850497 and maximum value is 857227.
pluku_alku int Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 6684 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30275 and maximum value is 11320831.
pluku_lopp int Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 6684 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30275 and maximum value is 11320831.
pluku_pist int Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 6684 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30275 and maximum value is 11320831.
perustus string Data source did not contain a description for PERUSTUS. Column perustus has 6684 rows, out of which 237 are empty, making the null percent 3.55. Minimum string is and maximum string is Vanhat rumpukivet.
pistekm_m string Data source did not contain a description for PISTEKM_M. Column pistekm_m has 6684 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0003+0275 and maximum string is 1132+0831.
pituus float Data source did not contain a description for PITUUS. Column pituus has 6684 rows, out of which 724 are empty, making the null percent 10.83. Minimum value is 0.00 and maximum value is 180.00.
raideluku int Data source did not contain a description for RAIDELUKU. Column raideluku has 6684 rows, out of which 3353 are empty, making the null percent 50.16. Minimum value is 0 and maximum value is 11.
rakvuosi int Data source did not contain a description for RAKVUOSI. Column rakvuosi has 6684 rows, out of which 5319 are empty, making the null percent 79.58. Minimum value is 1893 and maximum value is 2019.
ratanumero int Data source did not contain a description for RATANUMERO. Column ratanumero has 6684 rows, out of which 6 are empty, making the null percent 0.09. Minimum value is 1 and maximum value is 751.
rpalkkorko float Data source did not contain a description for RPALKKORKO. Column rpalkkorko has 6684 rows, out of which 3740 are empty, making the null percent 55.95. Minimum value is 0.00 and maximum value is 7.00.
rpalkkorkv float Data source did not contain a description for RPALKKORKV. Column rpalkkorkv has 6684 rows, out of which 3726 are empty, making the null percent 55.75. Minimum value is 0.00 and maximum value is 7.00.
rpalkkoroo string Data source did not contain a description for RPALKKOROO. Column rpalkkoroo has 6684 rows, out of which 2904 are empty, making the null percent 43.45. Minimum string is and maximum string is K.
rpalkkorov string Data source did not contain a description for RPALKKOROV. Column rpalkkorov has 6684 rows, out of which 2898 are empty, making the null percent 43.36. Minimum string is and maximum string is K.
rpalkmatoi string Data source did not contain a description for RPALKMATOI. Column rpalkmatoi has 6684 rows, out of which 237 are empty, making the null percent 3.55. Minimum string is and maximum string is Kivi alla. betoni päällä.
rpalkmatva string Data source did not contain a description for RPALKMATVA. Column rpalkmatva has 6684 rows, out of which 237 are empty, making the null percent 3.55. Minimum string is and maximum string is Kivi alla. betoni päällä.
rpalkpitoi float Data source did not contain a description for RPALKPITOI. Column rpalkpitoi has 6684 rows, out of which 5595 are empty, making the null percent 83.71. Minimum value is 0.00 and maximum value is 18.40.
rpalkpitva float Data source did not contain a description for RPALKPITVA. Column rpalkpitva has 6684 rows, out of which 5575 are empty, making the null percent 83.41. Minimum value is 0.00 and maximum value is 30.00.
rumpu_tila string Data source did not contain a description for RUMPU_TILA. Column rumpu_tila has 6684 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is EI LÖYDY and maximum string is TÄYTETTY.
rumpu_id float Data source did not contain a description for RUMPU_ID. Column is empty.
rumjatvas string Data source did not contain a description for RUMJATVAS. Column rumjatvas has 6684 rows, out of which 237 are empty, making the null percent 3.55. Minimum string is and maximum string is Teräs.
rumjatoik string Data source did not contain a description for RUMJATOIK. Column rumjatoik has 6684 rows, out of which 237 are empty, making the null percent 3.55. Minimum string is and maximum string is Teräs.
rumpukoodi int Data source did not contain a description for RUMPUKOODI. Column rumpukoodi has 6684 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 340 and maximum value is 7422.
rumpulaji string Data source did not contain a description for RUMPULAJI. Column rumpulaji has 6684 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei määritelty and maximum string is Rumpu.
rumpunimi string Data source did not contain a description for RUMPUNIMI. Column rumpunimi has 6684 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aatamilan rumpu and maximum string is Yrttivuori.
rumpurakid int Data source did not contain a description for RUMPURAKID. Column rumpurakid has 6684 rows, out of which 237 are empty, making the null percent 3.55. Minimum value is 465491 and maximum value is 1169554.
rumreuoik float Data source did not contain a description for RUMREUOIK. Column rumreuoik has 6684 rows, out of which 3190 are empty, making the null percent 47.73. Minimum value is 0.00 and maximum value is 91.98.
rumreuvas float Data source did not contain a description for RUMREUVAS. Column rumreuvas has 6684 rows, out of which 3215 are empty, making the null percent 48.10. Minimum value is 0.00 and maximum value is 55.00.
rumputyyp string Data source did not contain a description for RUMPUTYYP. Column rumputyyp has 6684 rows, out of which 237 are empty, making the null percent 3.55. Minimum string is and maximum string is Teräsputki.
rumpuv_oik int Data source did not contain a description for RUMPUV_OIK. Column rumpuv_oik has 6684 rows, out of which 6409 are empty, making the null percent 95.89. Minimum value is 20 and maximum value is 2019.
rumpuv_vas int Data source did not contain a description for RUMPUV_VAS. Column rumpuv_vas has 6684 rows, out of which 6425 are empty, making the null percent 96.13. Minimum value is 20 and maximum value is 2019.
sijraidtun int Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 6684 rows, out of which 2954 are empty, making the null percent 44.20. Minimum value is 2 and maximum value is 751.
trr_tunnus string Data source did not contain a description for TRR_TUNNUS. Column trr_tunnus has 6684 rows, out of which 53 are empty, making the null percent 0.79. Minimum string is and maximum string is R999.
vapkorkeus float Data source did not contain a description for VAPKORKEUS. Column vapkorkeus has 6684 rows, out of which 2240 are empty, making the null percent 33.51. Minimum value is 0.00 and maximum value is 4.50.
vapaalev2 float Data source did not contain a description for VAPAALEV2. Column vapaalev2 has 6684 rows, out of which 6378 are empty, making the null percent 95.42. Minimum value is 0.00 and maximum value is 1.90.
vesjuokoik float Data source did not contain a description for VESJUOKOIK. Column vesjuokoik has 6684 rows, out of which 4280 are empty, making the null percent 64.03. Minimum value is 0.00 and maximum value is 20.00.
vesjuokvas float Data source did not contain a description for VESJUOKVAS. Column vesjuokvas has 6684 rows, out of which 4236 are empty, making the null percent 63.38. Minimum value is 0.00 and maximum value is 40.60.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 6684 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:03:00 and maximum value is 2020-05-25 21:03:13.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 6684 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.223201980062424... and first 25 characters of maximum string: POINT (30.943087065171184...
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 6684 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