1. Home
  2. Datasets
  3. Joukkoliikenteen pysäkit ...
To download the data set, please sign up or log in

Joukkoliikenteen pysäkit (Digiroad)

Joukkoliikenteen pysäkit (Digiroad)

Tables

Column Descriptions

Dr pysakki, Avoindr pysakki, Full history

Column Type Comment
valtak_id int Data source did not contain a description for VALTAK_ID. Column valtak_id has 96691 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1011 and maximum value is 1795461.
link_id int Data source did not contain a description for LINK_ID. Column link_id has 96691 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 11932351.
sijainti_m float Data source did not contain a description for SIJAINTI_M. Column sijainti_m has 96691 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.00 and maximum value is 4380.00.
vaik_suunt int Data source did not contain a description for VAIK_SUUNT. Column vaik_suunt has 96691 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 99.
nimi_su string Data source did not contain a description for NIMI_SU. Column nimi_su has 96691 rows, out of which 1750 are empty, making the null percent 1.81. Minimum string is and maximum string is Öölanninkatu.
nimi_ru string Data source did not contain a description for NIMI_RU. Column nimi_ru has 96691 rows, out of which 70675 are empty, making the null percent 73.09. Minimum string is and maximum string is ?MT??NTIE E.
yllapitaja int Data source did not contain a description for YLLAPITAJA. Column yllapitaja has 96691 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 99.
yllap_tunn int Data source did not contain a description for YLLAP_TUNN. Column yllap_tunn has 96691 rows, out of which 72491 are empty, making the null percent 74.97. Minimum value is 0 and maximum value is 109397144.
livi_tunn string Data source did not contain a description for LIVI_TUNN. Column livi_tunn has 96691 rows, out of which 31086 are empty, making the null percent 32.15. Minimum string is and maximum string is TMTMVI1962612790.
matk_tunn int Data source did not contain a description for MATK_TUNN. Column matk_tunn has 96691 rows, out of which 87162 are empty, making the null percent 90.14. Minimum value is 1 and maximum value is 19031.
maast_x float Data source did not contain a description for MAAST_X. Column maast_x has 96691 rows, out of which 87591 are empty, making the null percent 90.59. Minimum value is 60.29 and maximum value is 60434836.00.
maast_y float Data source did not contain a description for MAAST_Y. Column maast_y has 96691 rows, out of which 87590 are empty, making the null percent 90.59. Minimum value is 24.31 and maximum value is 24381242.00.
maast_z string Data source did not contain a description for MAAST_Z. Column maast_z has 96691 rows, out of which 96689 are empty, making the null percent 100.00. Minimum string is and maximum string is luode.
liik_suunt string Data source did not contain a description for LIIK_SUUNT. Column liik_suunt has 96691 rows, out of which 81426 are empty, making the null percent 84.21. Minimum string is and maximum string is Ylikiiminki.
l_suuntima int Data source did not contain a description for L_SUUNTIMA. Column l_suuntima has 96691 rows, out of which 50 are empty, making the null percent 0.05. Minimum value is 0 and maximum value is 360.
ens_vo_pv timestamp Data source did not contain a description for ENS_VO_PV.
viim_vo_pv timestamp Data source did not contain a description for VIIM_VO_PV.
pys_tyyppi string Data source did not contain a description for PYS_TYYPPI. Column pys_tyyppi has 96691 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is [1] and maximum string is [99].
aikataulu int Data source did not contain a description for AIKATAULU. Column aikataulu has 96691 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 99.
katos int Data source did not contain a description for KATOS. Column katos has 96691 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 99.
penkki int Data source did not contain a description for PENKKI. Column penkki has 96691 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 99.
mainoskat int Data source did not contain a description for MAINOSKAT. Column mainoskat has 96691 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 99.
pyoratelin int Data source did not contain a description for PYORATELIN. Column pyoratelin has 96691 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 99.
s_aikataul int Data source did not contain a description for S_AIKATAUL. Column s_aikataul has 96691 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 99.
valaistus int Data source did not contain a description for VALAISTUS. Column valaistus has 96691 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 99.
estettomyy string Data source did not contain a description for ESTETTOMYY. Column estettomyy has 96691 rows, out of which 12497 are empty, making the null percent 12.92. Minimum string is and maximum string is Vaikeakulkuinen.
saattomahd int Data source did not contain a description for SAATTOMAHD. Column saattomahd has 96691 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 99.
liit_lkm string Data source did not contain a description for LIIT_LKM. Column liit_lkm has 96691 rows, out of which 96679 are empty, making the null percent 99.99. Minimum string is and maximum string is 72.
liit_lisat string Data source did not contain a description for LIIT_LISAT. Column liit_lisat has 96691 rows, out of which 96135 are empty, making the null percent 99.42. Minimum string is and maximum string is t.
pys_omist string Data source did not contain a description for PYS_OMIST. Column pys_omist has 96691 rows, out of which 95427 are empty, making the null percent 98.69. Minimum string is and maximum string is Virolahden kunta.
palaute_os string Data source did not contain a description for PALAUTE_OS. Column palaute_os has 96691 rows, out of which 96570 are empty, making the null percent 99.87. Minimum string is and maximum string is yhdyskunta@lempaala.fi.
lisatiedot string Data source did not contain a description for LISATIEDOT. Column lisatiedot has 96691 rows, out of which 89532 are empty, making the null percent 92.60. Minimum string is and maximum string is Ylä-Vista.
irti_geom int Data source did not contain a description for IRTI_GEOM. Column irti_geom has 96691 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
muokkauspv timestamp Data source did not contain a description for MUOKKAUSPV. Column muokkauspv has 96691 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2014-03-17 16:07:24 and maximum value is 2020-09-09 15:04:53.
kuntakoodi int Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 96691 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 992.
koord_x float Data source did not contain a description for KOORD_X. Column koord_x has 96691 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 87229.68 and maximum value is 719654.38.
koord_y float Data source did not contain a description for KOORD_Y. Column koord_y has 96691 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6638741.50 and maximum value is 7776113.50.
link_mmlid string Data source did not contain a description for LINK_MMLID. Column is empty.
laiturinum string Data source did not contain a description for LAITURINUM. Column laiturinum has 96691 rows, out of which 96567 are empty, making the null percent 99.87. Minimum string is and maximum string is E.
liit_term string Data source did not contain a description for LIIT_TERM. Column liit_term has 96691 rows, out of which 96371 are empty, making the null percent 99.67. Minimum string is and maximum string is 344117.
vyohyktiet string Data source did not contain a description for VYOHYKTIET. Column vyohyktiet has 96691 rows, out of which 72330 are empty, making the null percent 74.81. Minimum string is and maximum string is V-4/D.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 96691 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.538433948466704... and first 25 characters of maximum string: POINT (31.28607761539245 ...
geom_center_x float Longitude of center. Column geom_center_x has 96691 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.54 and maximum value is 31.29.
geom_center_y float Latitude of center. Column geom_center_y has 96691 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.82 and maximum value is 70.09.
geom_type string Geometry type. Column geom_type has 96691 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.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 10, 2020
Created September 10, 2020