{ "cells": [ { "cell_type": "code", "execution_count": 74, "metadata": {}, "outputs": [], "source": [ "import geopandas as gpd\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n" ] }, { "cell_type": "code", "execution_count": 25, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | RT | \n", "TP | \n", "longitude | \n", "latitude | \n", "avg_ons | \n", "avg_offs | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "1707 Myrtle\\Williams | \n", "-106.470347 | \n", "31.768641 | \n", "0.261719 | \n", "0.496094 | \n", "POINT (-106.47035 31.76864) | \n", "
1 | \n", "2 | \n", "1900 Magoffin\\Laurel | \n", "-106.467481 | \n", "31.768037 | \n", "0.360784 | \n", "1.752941 | \n", "POINT (-106.46748 31.76804) | \n", "
2 | \n", "2 | \n", "1931 Myrtle\\Eucalyptus | \n", "-106.467916 | \n", "31.770229 | \n", "3.019531 | \n", "2.636719 | \n", "POINT (-106.46792 31.77023) | \n", "
3 | \n", "2 | \n", "2023 Myrtle\\Willow | \n", "-106.466690 | \n", "31.770923 | \n", "1.308594 | \n", "1.039062 | \n", "POINT (-106.46669 31.77092) | \n", "
4 | \n", "2 | \n", "2114 Magoffin\\Walnut | \n", "-106.464387 | \n", "31.770018 | \n", "0.129412 | \n", "0.074510 | \n", "POINT (-106.46439 31.77002) | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
3424 | \n", "500 | \n", "Stanton St/Cincinnati Ave | \n", "-106.502172 | \n", "31.777396 | \n", "1.655425 | \n", "2.766862 | \n", "POINT (-106.50217 31.77740) | \n", "
3425 | \n", "500 | \n", "Stanton St/Kerbey Ave | \n", "-106.499769 | \n", "31.774824 | \n", "1.005856 | \n", "2.035139 | \n", "POINT (-106.49977 31.77482) | \n", "
3426 | \n", "500 | \n", "Stanton St/Missouri Ave | \n", "-106.488914 | \n", "31.762469 | \n", "0.885630 | \n", "0.391496 | \n", "POINT (-106.48891 31.76247) | \n", "
3427 | \n", "500 | \n", "Stanton St/Rim Rd | \n", "-106.496622 | \n", "31.771112 | \n", "0.566618 | \n", "0.814056 | \n", "POINT (-106.49662 31.77111) | \n", "
3428 | \n", "500 | \n", "Stanton\\Yandell | \n", "-106.490297 | \n", "31.764011 | \n", "0.802053 | \n", "0.728739 | \n", "POINT (-106.49030 31.76401) | \n", "
3429 rows × 7 columns
\n", "\n", " | uniqueID | \n", "ridership | \n", "totalPop | \n", "hlPop | \n", "whitePop | \n", "blackPop | \n", "aiPop | \n", "asianPop | \n", "nhPop | \n", "otherRacePop | \n", "... | \n", "major_road.nn3 | \n", "major_road.nn5 | \n", "stops_in_hex | \n", "bays_in_hex | \n", "cvID | \n", "prediction | \n", "error | \n", "ridership_per_stop | \n", "pred_ridership_per_stop | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "0 | \n", "192.697819 | \n", "149.407509 | \n", "175.915293 | \n", "1.463092 | \n", "0.000000 | \n", "0.279709 | \n", "0.000000 | \n", "14.286663 | \n", "... | \n", "0.006613 | \n", "0.007121 | \n", "0.0 | \n", "0.0 | \n", "88 | \n", "0.998888 | \n", "0.998888 | \n", "0.0 | \n", "0.0 | \n", "POLYGON ((-106.63329 31.86642, -106.63579 31.8... | \n", "
1 | \n", "2 | \n", "0 | \n", "38.915167 | \n", "30.191817 | \n", "35.454301 | \n", "0.291479 | \n", "0.001266 | \n", "0.055724 | \n", "0.000000 | \n", "2.917649 | \n", "... | \n", "0.005748 | \n", "0.006669 | \n", "0.0 | \n", "0.0 | \n", "3 | \n", "1.000461 | \n", "1.000461 | \n", "0.0 | \n", "0.0 | \n", "POLYGON ((-106.63329 31.87508, -106.63579 31.8... | \n", "
2 | \n", "3 | \n", "0 | \n", "175.428773 | \n", "136.018021 | \n", "160.150251 | \n", "1.331974 | \n", "0.000000 | \n", "0.254642 | \n", "0.000000 | \n", "13.006332 | \n", "... | \n", "0.002750 | \n", "0.003626 | \n", "0.0 | \n", "0.0 | \n", "64 | \n", "0.999877 | \n", "0.999877 | \n", "0.0 | \n", "0.0 | \n", "POLYGON ((-106.63079 31.86209, -106.63329 31.8... | \n", "
3 | \n", "4 | \n", "0 | \n", "192.827021 | \n", "149.507686 | \n", "176.033243 | \n", "1.464073 | \n", "0.000000 | \n", "0.279896 | \n", "0.000000 | \n", "14.296242 | \n", "... | \n", "0.005156 | \n", "0.005415 | \n", "0.0 | \n", "0.0 | \n", "74 | \n", "1.000771 | \n", "1.000771 | \n", "0.0 | \n", "0.0 | \n", "POLYGON ((-106.63079 31.87075, -106.63329 31.8... | \n", "
4 | \n", "5 | \n", "0 | \n", "71.358125 | \n", "57.918821 | \n", "55.418041 | \n", "0.000000 | \n", "0.171809 | \n", "0.000000 | \n", "0.000000 | \n", "9.697680 | \n", "... | \n", "0.004352 | \n", "0.005308 | \n", "0.0 | \n", "0.0 | \n", "77 | \n", "1.000009 | \n", "1.000009 | \n", "0.0 | \n", "0.0 | \n", "POLYGON ((-106.63079 31.87941, -106.63329 31.8... | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2112 | \n", "2115 | \n", "0 | \n", "543.652444 | \n", "450.740202 | \n", "459.666269 | \n", "28.793764 | \n", "5.012733 | \n", "6.046690 | \n", "0.314114 | \n", "26.359382 | \n", "... | \n", "0.005634 | \n", "0.006134 | \n", "0.0 | \n", "0.0 | \n", "74 | \n", "1.000663 | \n", "1.000663 | \n", "0.0 | \n", "0.0 | \n", "POLYGON ((-106.22329 31.77115, -106.22579 31.7... | \n", "
2113 | \n", "2116 | \n", "0 | \n", "543.602526 | \n", "450.698816 | \n", "459.624063 | \n", "28.791120 | \n", "5.012272 | \n", "6.046135 | \n", "0.314085 | \n", "26.356962 | \n", "... | \n", "0.002491 | \n", "0.003027 | \n", "0.0 | \n", "0.0 | \n", "61 | \n", "0.999908 | \n", "0.999908 | \n", "0.0 | \n", "0.0 | \n", "POLYGON ((-106.22329 31.77981, -106.22579 31.7... | \n", "
2114 | \n", "2117 | \n", "0 | \n", "543.552597 | \n", "450.657419 | \n", "459.581847 | \n", "28.788476 | \n", "5.011812 | \n", "6.045580 | \n", "0.314056 | \n", "26.354541 | \n", "... | \n", "0.005917 | \n", "0.006791 | \n", "0.0 | \n", "0.0 | \n", "46 | \n", "0.999658 | \n", "0.999658 | \n", "0.0 | \n", "0.0 | \n", "POLYGON ((-106.22329 31.78847, -106.22579 31.7... | \n", "
2115 | \n", "2118 | \n", "0 | \n", "543.364693 | \n", "450.305350 | \n", "459.409980 | \n", "28.837100 | \n", "5.000581 | \n", "6.008357 | \n", "0.310526 | \n", "26.292744 | \n", "... | \n", "0.003640 | \n", "0.004312 | \n", "0.0 | \n", "0.0 | \n", "12 | \n", "1.000274 | \n", "1.000274 | \n", "0.0 | \n", "0.0 | \n", "POLYGON ((-106.22329 31.79713, -106.22579 31.7... | \n", "
2116 | \n", "2119 | \n", "0 | \n", "178.687388 | \n", "142.226068 | \n", "150.690837 | \n", "11.231522 | \n", "1.360943 | \n", "0.927236 | \n", "0.000000 | \n", "7.073915 | \n", "... | \n", "0.005618 | \n", "0.006706 | \n", "0.0 | \n", "0.0 | \n", "86 | \n", "1.000633 | \n", "1.000633 | \n", "0.0 | \n", "0.0 | \n", "POLYGON ((-106.22329 31.80579, -106.22579 31.8... | \n", "
2117 rows × 150 columns
\n", "\n", " | ridership_per_stop_left | \n", "pred_ridership_per_stop_left | \n", "whitePop_left | \n", "blackPop_left | \n", "asianPop_left | \n", "hlPop_left | \n", "otherRacePop_left | \n", "nhPop_left | \n", "aiPop_left | \n", "disability_left | \n", "medHHInc_left | \n", "employmentHHMix_left | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
RT | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2 | \n", "134522.944788 | \n", "134534.933482 | \n", "208.267392 | \n", "9.887799 | \n", "2.213135 | \n", "309.054605 | \n", "97.922292 | \n", "0.000000e+00 | \n", "3.221515 | \n", "32.503298 | \n", "2358.714255 | \n", "0.678890 | \n", "
4 | \n", "99808.540597 | \n", "99805.952204 | \n", "294.027808 | \n", "17.776914 | \n", "2.035270 | \n", "391.922281 | \n", "102.258638 | \n", "0.000000e+00 | \n", "4.392465 | \n", "39.850378 | \n", "3427.174551 | \n", "0.605265 | \n", "
5 | \n", "39859.112121 | \n", "39831.697560 | \n", "300.474488 | \n", "11.754595 | \n", "3.375640 | \n", "313.013460 | \n", "26.172151 | \n", "2.725746e-01 | \n", "7.295883 | \n", "14.683008 | \n", "2764.141157 | \n", "0.627341 | \n", "
6 | \n", "70198.159740 | \n", "70151.561310 | \n", "323.780105 | \n", "11.268005 | \n", "3.375640 | \n", "347.711036 | \n", "42.267087 | \n", "6.911012e-01 | \n", "1.863522 | \n", "18.819553 | \n", "2533.982711 | \n", "0.637560 | \n", "
7 | \n", "172704.875000 | \n", "172705.516626 | \n", "272.825121 | \n", "16.937637 | \n", "3.704804 | \n", "264.809078 | \n", "35.694635 | \n", "2.042944e-01 | \n", "1.552696 | \n", "447.844155 | \n", "2364.803431 | \n", "0.613350 | \n", "
8 | \n", "31700.785109 | \n", "31715.974935 | \n", "345.976548 | \n", "16.826645 | \n", "1.665794 | \n", "346.276938 | \n", "42.570599 | \n", "3.759443e-01 | \n", "3.047165 | \n", "356.473438 | \n", "4101.151177 | \n", "0.672532 | \n", "
10 | \n", "180693.320513 | \n", "180688.863148 | \n", "293.626300 | \n", "26.512654 | \n", "2.220482 | \n", "338.464838 | \n", "86.256646 | \n", "0.000000e+00 | \n", "4.658511 | \n", "0.945881 | \n", "4039.459861 | \n", "0.377877 | \n", "
11 | \n", "106647.419048 | \n", "106647.802261 | \n", "181.120285 | \n", "7.650461 | \n", "8.498604 | \n", "170.615978 | \n", "38.439002 | \n", "0.000000e+00 | \n", "1.280814 | \n", "1.630691 | \n", "3272.177597 | \n", "0.555266 | \n", "
12 | \n", "85971.939683 | \n", "85869.967130 | \n", "217.193877 | \n", "2.914674 | \n", "3.969830 | \n", "246.261411 | \n", "55.440696 | \n", "4.049652e-01 | \n", "0.811182 | \n", "127.086499 | \n", "3001.717148 | \n", "0.637096 | \n", "
13 | \n", "352065.832937 | \n", "351993.357497 | \n", "303.795568 | \n", "6.193875 | \n", "12.329514 | \n", "279.310287 | \n", "63.363140 | \n", "6.113203e+00 | \n", "1.846071 | \n", "222.135478 | \n", "3202.533721 | \n", "0.680011 | \n", "
14 | \n", "622898.507567 | \n", "622629.520302 | \n", "260.635485 | \n", "9.297009 | \n", "8.992134 | \n", "256.000005 | \n", "61.420634 | \n", "1.733508e+00 | \n", "1.573087 | \n", "184.408919 | \n", "3837.076096 | \n", "0.598012 | \n", "
15 | \n", "480979.640229 | \n", "480916.501601 | \n", "218.530810 | \n", "8.360215 | \n", "8.935973 | \n", "218.787842 | \n", "53.806072 | \n", "2.901344e+00 | \n", "2.268997 | \n", "78.477025 | \n", "2929.195847 | \n", "0.702311 | \n", "
16 | \n", "61913.339683 | \n", "61832.045438 | \n", "173.252459 | \n", "1.477653 | \n", "2.870003 | \n", "157.177239 | \n", "23.922623 | \n", "5.762041e-01 | \n", "0.839681 | \n", "69.443286 | \n", "3180.696030 | \n", "0.527821 | \n", "
17 | \n", "69928.573016 | \n", "69832.930591 | \n", "260.891003 | \n", "3.844743 | \n", "9.490762 | \n", "267.070524 | \n", "56.813415 | \n", "8.388609e-01 | \n", "0.764677 | \n", "54.377882 | \n", "3760.066077 | \n", "0.720910 | \n", "
19 | \n", "92025.039683 | \n", "91947.301004 | \n", "278.905230 | \n", "4.532799 | \n", "11.618772 | \n", "262.231997 | \n", "53.849798 | \n", "1.771287e+00 | \n", "0.696525 | \n", "62.902654 | \n", "4319.978697 | \n", "0.639357 | \n", "
20 | \n", "18662.667063 | \n", "18666.881909 | \n", "219.472950 | \n", "4.280203 | \n", "9.281274 | \n", "231.397089 | \n", "58.100654 | \n", "3.531956e-01 | \n", "1.179460 | \n", "37.719113 | \n", "2729.706579 | \n", "0.842817 | \n", "
21 | \n", "37845.840747 | \n", "37849.810601 | \n", "333.356175 | \n", "1.840153 | \n", "1.113253 | \n", "378.659996 | \n", "64.390557 | \n", "4.420221e-02 | \n", "1.224643 | \n", "273.700006 | \n", "3125.074943 | \n", "0.502860 | \n", "
24 | \n", "122421.171047 | \n", "122415.645083 | \n", "332.246318 | \n", "5.706959 | \n", "0.497646 | \n", "411.517699 | \n", "77.420557 | \n", "0.000000e+00 | \n", "2.410588 | \n", "248.116826 | \n", "3082.695337 | \n", "0.430235 | \n", "
25 | \n", "85211.193939 | \n", "85213.359826 | \n", "248.000134 | \n", "2.703231 | \n", "0.746362 | \n", "273.513526 | \n", "37.572968 | \n", "2.290862e-01 | \n", "1.245279 | \n", "156.374937 | \n", "2474.481847 | \n", "0.676294 | \n", "
26 | \n", "75149.279895 | \n", "75170.468097 | \n", "230.363305 | \n", "3.597488 | \n", "2.273301 | \n", "320.572720 | \n", "84.137631 | \n", "0.000000e+00 | \n", "0.998893 | \n", "27.590168 | \n", "2350.389283 | \n", "0.626042 | \n", "
32 | \n", "89786.133117 | \n", "89819.274260 | \n", "391.892723 | \n", "10.954668 | \n", "3.338142 | \n", "418.893187 | \n", "50.212330 | \n", "4.634834e-07 | \n", "1.410105 | \n", "248.587744 | \n", "3713.123084 | \n", "0.354143 | \n", "
33 | \n", "139203.941558 | \n", "139245.216131 | \n", "330.384085 | \n", "4.914969 | \n", "1.920133 | \n", "349.624606 | \n", "43.265217 | \n", "1.664783e-01 | \n", "0.704070 | \n", "357.749929 | \n", "3100.087203 | \n", "0.557372 | \n", "
34 | \n", "233473.055575 | \n", "233521.007256 | \n", "348.550397 | \n", "13.615040 | \n", "4.468771 | \n", "396.171870 | \n", "73.100073 | \n", "0.000000e+00 | \n", "4.031467 | \n", "176.733030 | \n", "3974.680069 | \n", "0.511730 | \n", "
35 | \n", "301469.718615 | \n", "301429.061166 | \n", "432.892573 | \n", "11.140815 | \n", "3.939210 | \n", "459.834850 | \n", "57.564989 | \n", "9.304611e-02 | \n", "2.673003 | \n", "383.505733 | \n", "4821.666297 | \n", "0.560738 | \n", "
36 | \n", "223034.837876 | \n", "223033.080681 | \n", "341.594838 | \n", "13.890318 | \n", "3.574373 | \n", "375.280980 | \n", "58.407137 | \n", "0.000000e+00 | \n", "2.991883 | \n", "345.213472 | \n", "3497.843724 | \n", "0.492910 | \n", "
37 | \n", "405965.933333 | \n", "405853.282068 | \n", "281.590568 | \n", "17.835954 | \n", "6.148458 | \n", "315.299166 | \n", "59.950050 | \n", "0.000000e+00 | \n", "1.671791 | \n", "228.081755 | \n", "2734.914991 | \n", "0.426441 | \n", "
41 | \n", "100968.400000 | \n", "100992.533399 | \n", "307.232031 | \n", "15.689165 | \n", "5.209317 | \n", "333.195980 | \n", "48.113433 | \n", "0.000000e+00 | \n", "1.188075 | \n", "330.633750 | \n", "2889.642805 | \n", "0.318899 | \n", "
43 | \n", "146544.766667 | \n", "146450.246174 | \n", "282.834047 | \n", "23.579636 | \n", "7.161005 | \n", "294.625179 | \n", "57.838204 | \n", "4.695201e-04 | \n", "2.407509 | \n", "145.937095 | \n", "2935.823932 | \n", "0.390286 | \n", "
44 | \n", "191258.266667 | \n", "191192.397839 | \n", "351.666212 | \n", "42.591637 | \n", "7.176825 | \n", "348.848159 | \n", "51.828271 | \n", "1.366525e-01 | \n", "1.893701 | \n", "541.265492 | \n", "4114.832294 | \n", "0.417645 | \n", "
46 | \n", "60323.833333 | \n", "60374.530492 | \n", "301.959543 | \n", "37.629617 | \n", "10.895082 | \n", "285.502556 | \n", "43.224666 | \n", "0.000000e+00 | \n", "1.636080 | \n", "277.053220 | \n", "4015.943173 | \n", "0.460820 | \n", "
50 | \n", "584818.566214 | \n", "584834.674639 | \n", "314.140816 | \n", "6.978516 | \n", "2.516955 | \n", "342.499512 | \n", "53.074771 | \n", "1.068349e-01 | \n", "2.854014 | \n", "506.285536 | \n", "3222.771377 | \n", "0.609286 | \n", "
51 | \n", "108179.156168 | \n", "108188.780606 | \n", "501.687139 | \n", "18.734744 | \n", "6.192684 | \n", "477.391775 | \n", "37.600306 | \n", "6.789015e-01 | \n", "2.373191 | \n", "414.526060 | \n", "5498.521503 | \n", "0.453391 | \n", "
52 | \n", "60272.185460 | \n", "60297.463282 | \n", "500.511921 | \n", "18.866005 | \n", "7.771088 | \n", "484.252887 | \n", "38.156436 | \n", "7.766051e-01 | \n", "2.432707 | \n", "603.608824 | \n", "6318.355886 | \n", "0.424681 | \n", "
53 | \n", "170722.063220 | \n", "170681.473226 | \n", "450.232567 | \n", "12.749701 | \n", "4.771019 | \n", "423.184847 | \n", "32.136942 | \n", "5.991110e-01 | \n", "2.437072 | \n", "324.065390 | \n", "5674.202288 | \n", "0.625288 | \n", "
54 | \n", "85306.533550 | \n", "85318.399332 | \n", "481.588203 | \n", "19.682970 | \n", "6.922146 | \n", "469.435214 | \n", "29.543268 | \n", "6.425049e-01 | \n", "2.497703 | \n", "203.026244 | \n", "4077.102058 | \n", "0.610594 | \n", "
56 | \n", "6913.780303 | \n", "6930.661764 | \n", "430.938946 | \n", "29.019033 | \n", "4.721459 | \n", "421.723888 | \n", "33.285783 | \n", "2.302183e-01 | \n", "3.217713 | \n", "163.147985 | \n", "2297.223626 | \n", "0.439487 | \n", "
58 | \n", "57577.551313 | \n", "57589.476710 | \n", "401.171436 | \n", "13.943126 | \n", "3.460870 | \n", "379.106941 | \n", "22.476502 | \n", "3.255794e-01 | \n", "2.574096 | \n", "300.178032 | \n", "3818.747723 | \n", "0.498902 | \n", "
59 | \n", "31940.600654 | \n", "31947.858909 | \n", "291.255384 | \n", "12.909488 | \n", "1.154495 | \n", "322.994807 | \n", "58.059301 | \n", "8.326188e-01 | \n", "3.509223 | \n", "0.000000 | \n", "3641.673270 | \n", "0.729460 | \n", "
60 | \n", "197420.717079 | \n", "197321.111906 | \n", "211.656480 | \n", "5.464838 | \n", "0.945457 | \n", "247.686517 | \n", "42.634054 | \n", "1.793349e-01 | \n", "5.685922 | \n", "190.416203 | \n", "2229.294792 | \n", "0.597746 | \n", "
61 | \n", "254286.115697 | \n", "254247.490267 | \n", "263.648754 | \n", "4.466586 | \n", "0.794033 | \n", "336.602360 | \n", "72.887624 | \n", "0.000000e+00 | \n", "1.938614 | \n", "290.812589 | \n", "2668.145628 | \n", "0.577633 | \n", "
62 | \n", "177872.914216 | \n", "177864.884855 | \n", "284.652982 | \n", "4.275840 | \n", "0.796263 | \n", "362.092008 | \n", "76.828017 | \n", "0.000000e+00 | \n", "2.037210 | \n", "437.145689 | \n", "2776.231394 | \n", "0.459794 | \n", "
63 | \n", "191308.330411 | \n", "191208.756162 | \n", "303.258465 | \n", "6.466490 | \n", "0.471597 | \n", "359.330963 | \n", "63.386103 | \n", "3.051031e-01 | \n", "4.285515 | \n", "751.678445 | \n", "2634.557845 | \n", "0.538122 | \n", "
64 | \n", "193934.674654 | \n", "193832.039293 | \n", "319.956888 | \n", "3.297993 | \n", "0.476294 | \n", "377.969575 | \n", "66.603760 | \n", "1.229366e+00 | \n", "1.771440 | \n", "223.776246 | \n", "3001.624291 | \n", "0.504488 | \n", "
65 | \n", "268705.528770 | \n", "268635.363922 | \n", "245.750030 | \n", "3.544280 | \n", "0.660387 | \n", "313.968077 | \n", "67.811746 | \n", "0.000000e+00 | \n", "2.123849 | \n", "179.193541 | \n", "2502.481736 | \n", "0.518695 | \n", "
66 | \n", "234966.724030 | \n", "234927.323055 | \n", "224.337742 | \n", "3.804681 | \n", "0.789005 | \n", "290.193688 | \n", "65.076444 | \n", "0.000000e+00 | \n", "2.139242 | \n", "159.169072 | \n", "2358.336738 | \n", "0.587815 | \n", "
67 | \n", "71483.529245 | \n", "71496.764756 | \n", "363.739226 | \n", "7.712595 | \n", "2.164735 | \n", "388.740886 | \n", "50.543796 | \n", "3.731947e-01 | \n", "2.468416 | \n", "264.841789 | \n", "4426.018238 | \n", "0.503898 | \n", "
68 | \n", "170664.045350 | \n", "170593.245968 | \n", "341.140023 | \n", "8.252484 | \n", "2.347105 | \n", "366.269992 | \n", "48.291744 | \n", "4.531270e-01 | \n", "2.616498 | \n", "392.200318 | \n", "4290.907032 | \n", "0.627410 | \n", "
69 | \n", "255354.614148 | \n", "255243.634342 | \n", "398.194892 | \n", "9.527414 | \n", "2.944664 | \n", "410.627827 | \n", "45.041233 | \n", "9.403005e-01 | \n", "2.721314 | \n", "357.478682 | \n", "4369.969334 | \n", "0.603660 | \n", "
72 | \n", "87339.986624 | \n", "87358.478608 | \n", "377.372597 | \n", "15.889928 | \n", "4.414315 | \n", "374.832925 | \n", "39.485434 | \n", "2.887332e+00 | \n", "3.643563 | \n", "452.986644 | \n", "4724.310772 | \n", "0.638322 | \n", "
74 | \n", "66822.784739 | \n", "66830.910878 | \n", "352.346539 | \n", "16.132443 | \n", "2.831254 | \n", "356.062812 | \n", "37.960470 | \n", "2.574042e-01 | \n", "2.699090 | \n", "475.832009 | \n", "4006.934807 | \n", "0.667023 | \n", "
76 | \n", "90999.920635 | \n", "90987.484131 | \n", "312.441716 | \n", "17.197475 | \n", "3.243708 | \n", "327.146162 | \n", "61.325058 | \n", "4.594797e-01 | \n", "3.788519 | \n", "10.310863 | \n", "5095.375077 | \n", "0.563549 | \n", "
82 | \n", "53742.150325 | \n", "53724.244194 | \n", "300.133921 | \n", "1.125199 | \n", "0.485408 | \n", "375.243634 | \n", "73.390082 | \n", "3.570894e-01 | \n", "1.031886 | \n", "120.471432 | \n", "2354.544508 | \n", "0.401188 | \n", "
84 | \n", "114379.547619 | \n", "114312.167712 | \n", "165.854765 | \n", "3.771376 | \n", "0.630626 | \n", "214.140747 | \n", "39.632554 | \n", "1.147322e-01 | \n", "11.562392 | \n", "80.578124 | \n", "1575.577614 | \n", "0.598063 | \n", "
86 | \n", "109150.480303 | \n", "109099.040451 | \n", "251.080903 | \n", "2.964100 | \n", "0.037449 | \n", "313.327269 | \n", "64.416356 | \n", "0.000000e+00 | \n", "4.026967 | \n", "264.175247 | \n", "1848.524387 | \n", "0.549545 | \n", "
87 | \n", "30310.225000 | \n", "30279.747522 | \n", "201.860485 | \n", "4.512516 | \n", "0.240302 | \n", "195.962632 | \n", "19.696657 | \n", "3.365469e-01 | \n", "1.947113 | \n", "30.722840 | \n", "2081.387338 | \n", "0.533753 | \n", "
89 | \n", "124524.436126 | \n", "124485.234078 | \n", "303.826812 | \n", "7.667245 | \n", "1.191275 | \n", "324.084106 | \n", "37.632111 | \n", "3.197981e-01 | \n", "8.812845 | \n", "62.771705 | \n", "3863.154590 | \n", "0.586516 | \n", "
205 | \n", "299681.378783 | \n", "299592.707962 | \n", "217.929947 | \n", "9.835670 | \n", "9.330200 | \n", "221.535831 | \n", "54.939539 | \n", "2.151090e+00 | \n", "2.904398 | \n", "16.842071 | \n", "2926.609618 | \n", "0.650941 | \n", "
206 | \n", "238975.674216 | \n", "238868.787783 | \n", "271.659480 | \n", "4.721598 | \n", "0.697541 | \n", "351.862214 | \n", "79.698529 | \n", "2.754881e-01 | \n", "2.098728 | \n", "97.317359 | \n", "2606.694487 | \n", "0.589749 | \n", "
207 | \n", "530627.898633 | \n", "530496.553495 | \n", "388.078190 | \n", "15.849512 | \n", "3.781185 | \n", "445.046984 | \n", "79.401489 | \n", "0.000000e+00 | \n", "2.592672 | \n", "119.368904 | \n", "3676.151628 | \n", "0.596090 | \n", "
208 | \n", "133550.241026 | \n", "133552.619235 | \n", "329.023799 | \n", "9.853762 | \n", "2.490395 | \n", "326.705800 | \n", "31.580602 | \n", "2.837028e-01 | \n", "2.004973 | \n", "109.419825 | \n", "3008.279850 | \n", "0.591694 | \n", "
500 | \n", "165112.148907 | \n", "165100.949397 | \n", "234.181211 | \n", "20.733320 | \n", "2.202552 | \n", "290.423778 | \n", "82.137842 | \n", "0.000000e+00 | \n", "5.098681 | \n", "4.177935 | \n", "4284.519484 | \n", "0.641251 | \n", "
\n", " | RT | \n", "TP | \n", "longitude | \n", "latitude | \n", "avg_ons | \n", "avg_offs | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "2 | \n", "1707 Myrtle\\Williams | \n", "-106.470347 | \n", "31.768641 | \n", "0.261719 | \n", "0.496094 | \n", "POINT (-106.47035 31.76864) | \n", "
1 | \n", "2 | \n", "1900 Magoffin\\Laurel | \n", "-106.467481 | \n", "31.768037 | \n", "0.360784 | \n", "1.752941 | \n", "POINT (-106.46748 31.76804) | \n", "
2 | \n", "2 | \n", "1931 Myrtle\\Eucalyptus | \n", "-106.467916 | \n", "31.770229 | \n", "3.019531 | \n", "2.636719 | \n", "POINT (-106.46792 31.77023) | \n", "
3 | \n", "2 | \n", "2023 Myrtle\\Willow | \n", "-106.466690 | \n", "31.770923 | \n", "1.308594 | \n", "1.039062 | \n", "POINT (-106.46669 31.77092) | \n", "
4 | \n", "2 | \n", "2114 Magoffin\\Walnut | \n", "-106.464387 | \n", "31.770018 | \n", "0.129412 | \n", "0.074510 | \n", "POINT (-106.46439 31.77002) | \n", "
5 | \n", "2 | \n", "222 Campbell\\First | \n", "-106.483134 | \n", "31.756794 | \n", "1.000000 | \n", "1.078125 | \n", "POINT (-106.48313 31.75679) | \n", "
6 | \n", "2 | \n", "2302 Magoffin\\Palm | \n", "-106.462529 | \n", "31.771204 | \n", "2.862745 | \n", "7.133333 | \n", "POINT (-106.46253 31.77120) | \n", "
7 | \n", "2 | \n", "Cotton\\Bassett | \n", "-106.473659 | \n", "31.765381 | \n", "2.609375 | \n", "2.425781 | \n", "POINT (-106.47366 31.76538) | \n", "
8 | \n", "2 | \n", "Downtown Transit Ctr Bay B | \n", "-106.489452 | \n", "31.753149 | \n", "76.767442 | \n", "49.550388 | \n", "POINT (-106.48945 31.75315) | \n", "
9 | \n", "2 | \n", "Five Points Terminal Bay F | \n", "-106.462582 | \n", "31.781775 | \n", "41.769531 | \n", "36.171875 | \n", "POINT (-106.46258 31.78178) | \n", "
10 | \n", "2 | \n", "Magoffin\\Cotton | \n", "-106.473197 | \n", "31.764500 | \n", "4.742188 | \n", "3.878906 | \n", "POINT (-106.47320 31.76450) | \n", "
11 | \n", "2 | \n", "Magoffin\\Dallas | \n", "-106.469792 | \n", "31.766546 | \n", "0.243137 | \n", "0.682353 | \n", "POINT (-106.46979 31.76655) | \n", "
12 | \n", "2 | \n", "Magoffin\\Eucalyptus | \n", "-106.466224 | \n", "31.768835 | \n", "6.207843 | \n", "8.976471 | \n", "POINT (-106.46622 31.76884) | \n", "
13 | \n", "2 | \n", "Magoffin\\Lee St. | \n", "-106.470973 | \n", "31.765799 | \n", "1.560784 | \n", "5.176471 | \n", "POINT (-106.47097 31.76580) | \n", "
14 | \n", "2 | \n", "Magoffin\\Ochoa | \n", "-106.481350 | \n", "31.760229 | \n", "0.468750 | \n", "0.304688 | \n", "POINT (-106.48135 31.76023) | \n", "
15 | \n", "2 | \n", "Myrtle\\Dallas | \n", "-106.471543 | \n", "31.767864 | \n", "0.140625 | \n", "0.476562 | \n", "POINT (-106.47154 31.76786) | \n", "
16 | \n", "2 | \n", "Myrtle\\Florence | \n", "-106.483486 | \n", "31.760174 | \n", "0.464844 | \n", "2.687500 | \n", "POINT (-106.48349 31.76017) | \n", "
17 | \n", "2 | \n", "Myrtle\\Palm | \n", "-106.464270 | \n", "31.772482 | \n", "1.316406 | \n", "1.609375 | \n", "POINT (-106.46427 31.77248) | \n", "
18 | \n", "2 | \n", "Paisano\\Stanton | \n", "-106.485464 | \n", "31.755833 | \n", "1.412698 | \n", "8.357143 | \n", "POINT (-106.48546 31.75583) | \n", "
19 | \n", "2 | \n", "Piedras\\Alameda | \n", "-106.461671 | \n", "31.773800 | \n", "2.359375 | \n", "4.378906 | \n", "POINT (-106.46167 31.77380) | \n", "
20 | \n", "2 | \n", "Piedras\\Alameda | \n", "-106.461459 | \n", "31.773017 | \n", "2.359375 | \n", "4.378906 | \n", "POINT (-106.46146 31.77302) | \n", "
21 | \n", "2 | \n", "Piedras\\Gateway West | \n", "-106.461569 | \n", "31.779130 | \n", "1.371094 | \n", "0.496094 | \n", "POINT (-106.46157 31.77913) | \n", "
22 | \n", "2 | \n", "Raynor\\Missouri | \n", "-106.459890 | \n", "31.779435 | \n", "0.478431 | \n", "2.443137 | \n", "POINT (-106.45989 31.77944) | \n", "
23 | \n", "2 | \n", "San Antonio Transit Terminal | \n", "-106.482454 | \n", "31.759522 | \n", "6.480469 | \n", "1.320312 | \n", "POINT (-106.48245 31.75952) | \n", "
24 | \n", "2 | \n", "San Antonio\\Cotton | \n", "-106.474008 | \n", "31.762369 | \n", "3.660156 | \n", "0.902344 | \n", "POINT (-106.47401 31.76237) | \n", "
25 | \n", "2 | \n", "San Antonio\\Park | \n", "-106.476305 | \n", "31.761216 | \n", "29.369650 | \n", "20.463035 | \n", "POINT (-106.47630 31.76122) | \n", "
26 | \n", "2 | \n", "San Antonio\\Park | \n", "-106.476130 | \n", "31.761476 | \n", "29.369650 | \n", "20.463035 | \n", "POINT (-106.47613 31.76148) | \n", "
27 | \n", "2 | \n", "San Antonio\\St.Vrain | \n", "-106.479437 | \n", "31.759983 | \n", "0.402344 | \n", "1.140625 | \n", "POINT (-106.47944 31.75998) | \n", "
28 | \n", "2 | \n", "San Antonio\\Tays | \n", "-106.477835 | \n", "31.760688 | \n", "2.683594 | \n", "1.058594 | \n", "POINT (-106.47783 31.76069) | \n", "
29 | \n", "2 | \n", "Virgina\\Magoffin | \n", "-106.480653 | \n", "31.760530 | \n", "0.269531 | \n", "1.183594 | \n", "POINT (-106.48065 31.76053) | \n", "