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

Pysyvä nopeusrajoitus

Pysyvä nopeusrajoitus

Tables

Column Descriptions

Rata nopeusrajoitus pysyva, Avoinrata nopeusrajoitus pysyva, Latest

Column Type Comment
alkukm_m string Data source did not contain a description for ALKUKM_M. Column alkukm_m has 5384 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0149 and maximum string is 1135+0313.
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 5384 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 349115 and maximum value is 913603.
irrotus_pv timestamp Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 5384 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:19 and maximum value is 2020-05-25 21:00:32.
kpitoalue int Data source did not contain a description for KPITOALUE. Column kpitoalue has 5384 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 5384 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 5384 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0638 and maximum string is 1135+0792.
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.
nop_ap_160 int Data source did not contain a description for NOP_AP_160. Column nop_ap_160 has 5384 rows, out of which 66 are empty, making the null percent 1.23. Minimum value is 0 and maximum value is 170.
nop_ap_200 int Data source did not contain a description for NOP_AP_200. Column nop_ap_200 has 5384 rows, out of which 66 are empty, making the null percent 1.23. Minimum value is 0 and maximum value is 120.
nop_ap_225 int Data source did not contain a description for NOP_AP_225. Column nop_ap_225 has 5384 rows, out of which 66 are empty, making the null percent 1.23. Minimum value is 0 and maximum value is 120.
nop_ap_245 int Data source did not contain a description for NOP_AP_245. Column nop_ap_245 has 5384 rows, out of which 823 are empty, making the null percent 15.29. Minimum value is 0 and maximum value is 220.
nop_ap_250 int Data source did not contain a description for NOP_AP_250. Column nop_ap_250 has 5384 rows, out of which 90 are empty, making the null percent 1.67. Minimum value is 0 and maximum value is 100.
nop_ap_ivy int Data source did not contain a description for NOP_AP_IVY. Column nop_ap_ivy has 5384 rows, out of which 2223 are empty, making the null percent 41.29. Minimum value is 0 and maximum value is 100.
nop_kalkor int Data source did not contain a description for NOP_KALKOR. Column nop_kalkor has 5384 rows, out of which 71 are empty, making the null percent 1.32. Minimum value is 0 and maximum value is 220.
nop_moojun int Data source did not contain a description for NOP_MOOJUN. Column nop_moojun has 5384 rows, out of which 959 are empty, making the null percent 17.81. Minimum value is 0 and maximum value is 220.
nop_tavkal int Data source did not contain a description for NOP_TAVKAL. Column nop_tavkal has 5384 rows, out of which 71 are empty, making the null percent 1.32. Minimum value is 0 and maximum value is 220.
nop_vetjun int Data source did not contain a description for NOP_VETJUN. Column nop_vetjun has 5384 rows, out of which 953 are empty, making the null percent 17.70. Minimum value is 0 and maximum value is 200.
nraj_py_id int Data source did not contain a description for NRAJ_PY_ID. Column nraj_py_id has 5384 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1306988 and maximum value is 11559773.
objectid int Data source did not contain a description for OBJECTID. Column objectid has 5384 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 817474 and maximum value is 824072.
pistekm_m string Data source did not contain a description for PISTEKM_M. Column pistekm_m has 5384 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0149 and maximum string is 1135+0313.
pluku_alku int Data source did not contain a description for PLUKU_ALKU. Column pluku_alku has 5384 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 149 and maximum value is 11350313.
pluku_lopp int Data source did not contain a description for PLUKU_LOPP. Column pluku_lopp has 5384 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 638 and maximum value is 11350792.
pluku_pist int Data source did not contain a description for PLUKU_PIST. Column pluku_pist has 5384 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 149 and maximum value is 11350313.
rajoit_syy string Data source did not contain a description for RAJOIT_SYY. Column rajoit_syy has 5384 rows, out of which 3244 are empty, making the null percent 60.25. Minimum string is and maximum string is Äänekoski.
rajoit_tyy string Data source did not contain a description for RAJOIT_TYY. Column rajoit_tyy has 5384 rows, out of which 3217 are empty, making the null percent 59.75. Minimum string is and maximum string is Vaihteen tyyppi.
ratanumero int Data source did not contain a description for RATANUMERO. Column ratanumero has 5384 rows, out of which 25 are empty, making the null percent 0.46. Minimum value is 1 and maximum value is 751.
sijraidtun int Data source did not contain a description for SIJRAIDTUN. Column sijraidtun has 5384 rows, out of which 3982 are empty, making the null percent 73.96. Minimum value is 2 and maximum value is 751.
suunta string Data source did not contain a description for SUUNTA. Column suunta has 5384 rows, out of which 4 are empty, making the null percent 0.07. Minimum string is and maximum string is X.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 5384 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.2223699449... and first 25 characters of maximum string: MULTILINESTRING ((30.9366...
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 5384 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 10, 2020
Created July 10, 2018