WinBus pysakkitiedot

WinBus pysakkitiedot

Tables

Column Descriptions

V Pysakkitiedotpoint, Tampere Orav Pysakkitiedot

Column Type Comment
py_tunnist int Data source did not contain a description for PY_TUNNIST. Column py_tunnist has 3772 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 9989.
py_nimi string Data source did not contain a description for PY_NIMI. Column py_nimi has 3772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hankaloilontie E and maximum string is Öljytie.
py_eikayto string Data source did not contain a description for PY_EIKAYTO. Column py_eikayto has 3772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is No and maximum string is Yes.
py_paatepy string Data source did not contain a description for PY_PAATEPY. Column py_paatepy has 3772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is No and maximum string is Yes.
py_onkatos string Data source did not contain a description for PY_ONKATOS. Column py_onkatos has 3772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is No and maximum string is Yes.
py_katosom string Data source did not contain a description for PY_KATOSOM. Column py_katosom has 3772 rows, out of which 3230 are empty, making the null percent 85.63.
py_katosyl string Data source did not contain a description for PY_KATOSYL. Column py_katosyl has 3772 rows, out of which 3243 are empty, making the null percent 85.98.
py_katosty string Data source did not contain a description for PY_KATOSTY. Column py_katosty has 3772 rows, out of which 2893 are empty, making the null percent 76.70.
py_aikatau string Data source did not contain a description for PY_AIKATAU. Column py_aikatau has 3772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is No and maximum string is Yes.
py_kuntako int Data source did not contain a description for PY_KUNTAKO. Column py_kuntako has 3772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 108 and maximum value is 980.
py_kunta string Data source did not contain a description for PY_KUNTA. Column py_kunta has 3772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Orivesi and maximum string is Ylöjärvi.
py_tariffi int Data source did not contain a description for PY_TARIFFI. Column py_tariffi has 3772 rows, out of which 1397 are empty, making the null percent 37.04. Minimum value is 1 and maximum value is 3.
py_pysakki int Data source did not contain a description for PY_PYSAKKI. Column py_pysakki has 3772 rows, out of which 393 are empty, making the null percent 10.42. Minimum value is 25 and maximum value is 11000.
py_pyoraka string Data source did not contain a description for PY_PYORAKA. Column py_pyoraka has 3772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is No and maximum string is Yes.
py_wc string Data source did not contain a description for PY_WC. Column py_wc has 3772 rows, out of which 3767 are empty, making the null percent 99.87.
py_osoite string Data source did not contain a description for PY_OSOITE. Column py_osoite has 3772 rows, out of which 148 are empty, making the null percent 3.92. Minimum string is Orivedentie 71 and maximum string is Yrjölänkatu.
py_viranom string Data source did not contain a description for PY_VIRANOM. Column py_viranom has 3772 rows, out of which 292 are empty, making the null percent 7.74.
py_kadunpi string Data source did not contain a description for PY_KADUNPI. Column py_kadunpi has 3772 rows, out of which 401 are empty, making the null percent 10.63.
py_tyyppi int Data source did not contain a description for PY_TYYPPI. Column py_tyyppi has 3772 rows, out of which 279 are empty, making the null percent 7.40. Minimum value is 2 and maximum value is 6.
py_tyyppin string Data source did not contain a description for PY_TYYPPIN. Column py_tyyppin has 3772 rows, out of which 279 are empty, making the null percent 7.40. First 25 characters of minimum string: Linja-autojen paikallisli...
py_digiroa int Data source did not contain a description for PY_DIGIROA. Column py_digiroa has 3772 rows, out of which 408 are empty, making the null percent 10.82. Minimum value is 36713 and maximum value is 500461.
py_lyhenne string Data source did not contain a description for PY_LYHENNE. Column py_lyhenne has 3772 rows, out of which 47 are empty, making the null percent 1.25. Minimum string is HAN and maximum string is ÄIJ.
py_xkoordi int Data source did not contain a description for PY_XKOORDI. Column py_xkoordi has 3772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6798626 and maximum value is 6908349.
py_ykoordi int Data source did not contain a description for PY_YKOORDI. Column py_ykoordi has 3772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3298327 and maximum value is 3403586.
tekija string Data source did not contain a description for TEKIJA. Column tekija has 3772 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is LEHUHTAL and maximum string is TEROMYY.
tehty string Data source did not contain a description for TEHTY. Column is empty.
muuttaja string Data source did not contain a description for MUUTTAJA. Column muuttaja has 3772 rows, out of which 210 are empty, making the null percent 5.57. Minimum string is RIIKSALK and maximum string is TEROMYY.
muutettu string Data source did not contain a description for MUUTETTU. Column is empty.
poistaja string Data source did not contain a description for POISTAJA. Column poistaja has 3772 rows, out of which 3618 are empty, making the null percent 95.92.
poistettu string Data source did not contain a description for POISTETTU. Column is empty.
geom_geojson string Geometry in GeoJSON format.
orig_extractdate string

Additional Info

Last Updated October 10, 2018
Created September 24, 2018