load-auto.sql

CREATE MATERIALIZED VIEW ROUTE4864 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4864"';
CREATE MATERIALIZED VIEW ROUTE8960 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8960"';
CREATE MATERIALIZED VIEW ROUTE1 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1"';
CREATE MATERIALIZED VIEW ROUTE5377 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5377"';
CREATE MATERIALIZED VIEW ROUTE13057 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13057"';
CREATE MATERIALIZED VIEW ROUTE2 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2"';
CREATE MATERIALIZED VIEW ROUTE1026 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1026"';
CREATE MATERIALIZED VIEW ROUTE1538 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1538"';
CREATE MATERIALIZED VIEW ROUTE5378 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5378"';
CREATE MATERIALIZED VIEW ROUTE5634 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5634"';
CREATE MATERIALIZED VIEW ROUTE13826 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13826"';
CREATE MATERIALIZED VIEW ROUTE3 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3"';
CREATE MATERIALIZED VIEW ROUTE5379 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5379"';
CREATE MATERIALIZED VIEW ROUTE11523 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11523"';
CREATE MATERIALIZED VIEW ROUTE13059 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13059"';
CREATE MATERIALIZED VIEW ROUTE4 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4"';
CREATE MATERIALIZED VIEW ROUTE8452 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8452"';
CREATE MATERIALIZED VIEW ROUTE8708 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8708"';
CREATE MATERIALIZED VIEW ROUTE8964 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8964"';
CREATE MATERIALIZED VIEW ROUTE11524 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11524"';
CREATE MATERIALIZED VIEW ROUTE13828 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13828"';
CREATE MATERIALIZED VIEW ROUTE5 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5"';
CREATE MATERIALIZED VIEW ROUTE5125 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5125"';
CREATE MATERIALIZED VIEW ROUTE8965 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8965"';
CREATE MATERIALIZED VIEW ROUTE11525 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11525"';
CREATE MATERIALIZED VIEW ROUTE6 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"6"';
CREATE MATERIALIZED VIEW ROUTE1030 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1030"';
CREATE MATERIALIZED VIEW ROUTE5382 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5382"';
CREATE MATERIALIZED VIEW ROUTE8710 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8710"';
CREATE MATERIALIZED VIEW ROUTE8966 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8966"';
CREATE MATERIALIZED VIEW ROUTE11526 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11526"';
CREATE MATERIALIZED VIEW ROUTE13830 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13830"';
CREATE MATERIALIZED VIEW ROUTE7 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7"';
CREATE MATERIALIZED VIEW ROUTE2055 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2055"';
CREATE MATERIALIZED VIEW ROUTE4871 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4871"';
CREATE MATERIALIZED VIEW ROUTE8967 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8967"';
CREATE MATERIALIZED VIEW ROUTE11527 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11527"';
CREATE MATERIALIZED VIEW ROUTE8 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8"';
CREATE MATERIALIZED VIEW ROUTE8968 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8968"';
CREATE MATERIALIZED VIEW ROUTE11528 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11528"';
CREATE MATERIALIZED VIEW ROUTE13832 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13832"';
CREATE MATERIALIZED VIEW ROUTE9 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"9"';
CREATE MATERIALIZED VIEW ROUTE1545 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1545"';
CREATE MATERIALIZED VIEW ROUTE5385 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5385"';
CREATE MATERIALIZED VIEW ROUTE8457 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8457"';
CREATE MATERIALIZED VIEW ROUTE8969 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8969"';
CREATE MATERIALIZED VIEW ROUTE11529 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11529"';
CREATE MATERIALIZED VIEW ROUTE13833 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13833"';
CREATE MATERIALIZED VIEW ROUTE8714 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8714"';
CREATE MATERIALIZED VIEW ROUTE8970 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8970"';
CREATE MATERIALIZED VIEW ROUTE13066 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13066"';
CREATE MATERIALIZED VIEW ROUTE11 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11"';
CREATE MATERIALIZED VIEW ROUTE8971 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8971"';
CREATE MATERIALIZED VIEW ROUTE13067 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13067"';
CREATE MATERIALIZED VIEW ROUTE13835 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13835"';
CREATE MATERIALIZED VIEW ROUTE12 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12"';
CREATE MATERIALIZED VIEW ROUTE8972 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8972"';
CREATE MATERIALIZED VIEW ROUTE11532 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11532"';
CREATE MATERIALIZED VIEW ROUTE13 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13"';
CREATE MATERIALIZED VIEW ROUTE8973 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8973"';
CREATE MATERIALIZED VIEW ROUTE13837 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13837"';
CREATE MATERIALIZED VIEW ROUTE14 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"14"';
CREATE MATERIALIZED VIEW ROUTE1294 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1294"';
CREATE MATERIALIZED VIEW ROUTE8462 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8462"';
CREATE MATERIALIZED VIEW ROUTE15 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"15"';
CREATE MATERIALIZED VIEW ROUTE1295 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1295"';
CREATE MATERIALIZED VIEW ROUTE1551 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1551"';
CREATE MATERIALIZED VIEW ROUTE3343 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3343"';
CREATE MATERIALIZED VIEW ROUTE13839 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13839"';
CREATE MATERIALIZED VIEW ROUTE16 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"16"';
CREATE MATERIALIZED VIEW ROUTE1296 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1296"';
CREATE MATERIALIZED VIEW ROUTE7440 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7440"';
CREATE MATERIALIZED VIEW ROUTE11536 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11536"';
CREATE MATERIALIZED VIEW ROUTE17 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"17"';
CREATE MATERIALIZED VIEW ROUTE1041 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1041"';
CREATE MATERIALIZED VIEW ROUTE1297 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1297"';
CREATE MATERIALIZED VIEW ROUTE7953 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7953"';
CREATE MATERIALIZED VIEW ROUTE13841 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13841"';
CREATE MATERIALIZED VIEW ROUTE786 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"786"';
CREATE MATERIALIZED VIEW ROUTE3346 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3346"';
CREATE MATERIALIZED VIEW ROUTE7442 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7442"';
CREATE MATERIALIZED VIEW ROUTE11539 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11539"';
CREATE MATERIALIZED VIEW ROUTE13843 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13843"';
CREATE MATERIALIZED VIEW ROUTE1300 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1300"';
CREATE MATERIALIZED VIEW ROUTE7700 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7700"';
CREATE MATERIALIZED VIEW ROUTE789 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"789"';
CREATE MATERIALIZED VIEW ROUTE1301 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1301"';
CREATE MATERIALIZED VIEW ROUTE1302 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1302"';
CREATE MATERIALIZED VIEW ROUTE7446 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7446"';
CREATE MATERIALIZED VIEW ROUTE11286 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11286"';
CREATE MATERIALIZED VIEW ROUTE1303 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1303"';
CREATE MATERIALIZED VIEW ROUTE7703 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7703"';
CREATE MATERIALIZED VIEW ROUTE8983 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8983"';
CREATE MATERIALIZED VIEW ROUTE1304 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1304"';
CREATE MATERIALIZED VIEW ROUTE11544 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11544"';
CREATE MATERIALIZED VIEW ROUTE1305 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1305"';
CREATE MATERIALIZED VIEW ROUTE11289 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11289"';
CREATE MATERIALIZED VIEW ROUTE1306 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1306"';
CREATE MATERIALIZED VIEW ROUTE3354 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3354"';
CREATE MATERIALIZED VIEW ROUTE11290 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11290"';
CREATE MATERIALIZED VIEW ROUTE1307 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1307"';
CREATE MATERIALIZED VIEW ROUTE11291 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11291"';
CREATE MATERIALIZED VIEW ROUTE1308 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1308"';
CREATE MATERIALIZED VIEW ROUTE8988 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8988"';
CREATE MATERIALIZED VIEW ROUTE11548 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11548"';
CREATE MATERIALIZED VIEW ROUTE13596 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13596"';
CREATE MATERIALIZED VIEW ROUTE1309 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1309"';
CREATE MATERIALIZED VIEW ROUTE7453 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7453"';
CREATE MATERIALIZED VIEW ROUTE13597 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13597"';
CREATE MATERIALIZED VIEW ROUTE1310 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1310"';
CREATE MATERIALIZED VIEW ROUTE1311 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1311"';
CREATE MATERIALIZED VIEW ROUTE1823 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1823"';
CREATE MATERIALIZED VIEW ROUTE2079 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2079"';
CREATE MATERIALIZED VIEW ROUTE7455 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7455"';
CREATE MATERIALIZED VIEW ROUTE13343 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13343"';
CREATE MATERIALIZED VIEW ROUTE1312 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1312"';
CREATE MATERIALIZED VIEW ROUTE1824 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1824"';
CREATE MATERIALIZED VIEW ROUTE4896 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4896"';
CREATE MATERIALIZED VIEW ROUTE5664 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5664"';
CREATE MATERIALIZED VIEW ROUTE7456 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7456"';
CREATE MATERIALIZED VIEW ROUTE11296 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11296"';
CREATE MATERIALIZED VIEW ROUTE13088 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13088"';
CREATE MATERIALIZED VIEW ROUTE11297 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11297"';
CREATE MATERIALIZED VIEW ROUTE13089 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13089"';
CREATE MATERIALIZED VIEW ROUTE1314 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1314"';
CREATE MATERIALIZED VIEW ROUTE8482 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8482"';
CREATE MATERIALIZED VIEW ROUTE13090 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13090"';
CREATE MATERIALIZED VIEW ROUTE1571 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1571"';
CREATE MATERIALIZED VIEW ROUTE2339 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2339"';
CREATE MATERIALIZED VIEW ROUTE8483 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8483"';
CREATE MATERIALIZED VIEW ROUTE13091 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13091"';
CREATE MATERIALIZED VIEW ROUTE8484 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8484"';
CREATE MATERIALIZED VIEW ROUTE11300 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11300"';
CREATE MATERIALIZED VIEW ROUTE13092 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13092"';
CREATE MATERIALIZED VIEW ROUTE3365 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3365"';
CREATE MATERIALIZED VIEW ROUTE7461 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7461"';
CREATE MATERIALIZED VIEW ROUTE8229 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8229"';
CREATE MATERIALIZED VIEW ROUTE8485 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8485"';
CREATE MATERIALIZED VIEW ROUTE1318 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1318"';
CREATE MATERIALIZED VIEW ROUTE1574 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1574"';
CREATE MATERIALIZED VIEW ROUTE2342 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2342"';
CREATE MATERIALIZED VIEW ROUTE7462 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7462"';
CREATE MATERIALIZED VIEW ROUTE8486 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8486"';
CREATE MATERIALIZED VIEW ROUTE13350 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13350"';
CREATE MATERIALIZED VIEW ROUTE1319 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1319"';
CREATE MATERIALIZED VIEW ROUTE1575 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1575"';
CREATE MATERIALIZED VIEW ROUTE5671 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5671"';
CREATE MATERIALIZED VIEW ROUTE8487 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8487"';
CREATE MATERIALIZED VIEW ROUTE11303 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11303"';
CREATE MATERIALIZED VIEW ROUTE13095 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13095"';
CREATE MATERIALIZED VIEW ROUTE1320 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1320"';
CREATE MATERIALIZED VIEW ROUTE7464 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7464"';
CREATE MATERIALIZED VIEW ROUTE8232 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8232"';
CREATE MATERIALIZED VIEW ROUTE8488 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8488"';
CREATE MATERIALIZED VIEW ROUTE11304 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11304"';
CREATE MATERIALIZED VIEW ROUTE13352 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13352"';
CREATE MATERIALIZED VIEW ROUTE1577 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1577"';
CREATE MATERIALIZED VIEW ROUTE2089 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2089"';
CREATE MATERIALIZED VIEW ROUTE8233 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8233"';
CREATE MATERIALIZED VIEW ROUTE8489 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8489"';
CREATE MATERIALIZED VIEW ROUTE11305 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11305"';
CREATE MATERIALIZED VIEW ROUTE13353 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13353"';
CREATE MATERIALIZED VIEW ROUTE1322 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1322"';
CREATE MATERIALIZED VIEW ROUTE8490 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8490"';
CREATE MATERIALIZED VIEW ROUTE5675 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5675"';
CREATE MATERIALIZED VIEW ROUTE7723 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7723"';
CREATE MATERIALIZED VIEW ROUTE11307 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11307"';
CREATE MATERIALIZED VIEW ROUTE11308 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11308"';
CREATE MATERIALIZED VIEW ROUTE1837 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1837"';
CREATE MATERIALIZED VIEW ROUTE2349 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2349"';
CREATE MATERIALIZED VIEW ROUTE8493 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8493"';
CREATE MATERIALIZED VIEW ROUTE11309 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11309"';
CREATE MATERIALIZED VIEW ROUTE1838 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1838"';
CREATE MATERIALIZED VIEW ROUTE3374 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3374"';
CREATE MATERIALIZED VIEW ROUTE7726 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7726"';
CREATE MATERIALIZED VIEW ROUTE3377 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3377"';
CREATE MATERIALIZED VIEW ROUTE5681 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5681"';
CREATE MATERIALIZED VIEW ROUTE11313 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11313"';
CREATE MATERIALIZED VIEW ROUTE1586 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1586"';
CREATE MATERIALIZED VIEW ROUTE13874 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13874"';
CREATE MATERIALIZED VIEW ROUTE1587 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1587"';
CREATE MATERIALIZED VIEW ROUTE8243 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8243"';
CREATE MATERIALIZED VIEW ROUTE13107 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13107"';
CREATE MATERIALIZED VIEW ROUTE3380 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3380"';
CREATE MATERIALIZED VIEW ROUTE5684 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5684"';
CREATE MATERIALIZED VIEW ROUTE13620 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13620"';
CREATE MATERIALIZED VIEW ROUTE821 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"821"';
CREATE MATERIALIZED VIEW ROUTE13109 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13109"';
CREATE MATERIALIZED VIEW ROUTE13621 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13621"';
CREATE MATERIALIZED VIEW ROUTE822 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"822"';
CREATE MATERIALIZED VIEW ROUTE8246 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8246"';
CREATE MATERIALIZED VIEW ROUTE11318 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11318"';
CREATE MATERIALIZED VIEW ROUTE823 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"823"';
CREATE MATERIALIZED VIEW ROUTE4663 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4663"';
CREATE MATERIALIZED VIEW ROUTE11319 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11319"';
CREATE MATERIALIZED VIEW ROUTE11575 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11575"';
CREATE MATERIALIZED VIEW ROUTE13623 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13623"';
CREATE MATERIALIZED VIEW ROUTE1848 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1848"';
CREATE MATERIALIZED VIEW ROUTE4664 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4664"';
CREATE MATERIALIZED VIEW ROUTE11320 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11320"';
CREATE MATERIALIZED VIEW ROUTE825 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"825"';
CREATE MATERIALIZED VIEW ROUTE1849 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1849"';
CREATE MATERIALIZED VIEW ROUTE13113 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13113"';
CREATE MATERIALIZED VIEW ROUTE13625 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13625"';
CREATE MATERIALIZED VIEW ROUTE8250 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8250"';
CREATE MATERIALIZED VIEW ROUTE1083 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1083"';
CREATE MATERIALIZED VIEW ROUTE1595 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1595"';
CREATE MATERIALIZED VIEW ROUTE11323 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11323"';
CREATE MATERIALIZED VIEW ROUTE13115 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13115"';
CREATE MATERIALIZED VIEW ROUTE1596 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1596"';
CREATE MATERIALIZED VIEW ROUTE6716 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"6716"';
CREATE MATERIALIZED VIEW ROUTE8508 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8508"';
CREATE MATERIALIZED VIEW ROUTE1341 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1341"';
CREATE MATERIALIZED VIEW ROUTE1853 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1853"';
CREATE MATERIALIZED VIEW ROUTE8765 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8765"';
CREATE MATERIALIZED VIEW ROUTE13117 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13117"';
CREATE MATERIALIZED VIEW ROUTE1342 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1342"';
CREATE MATERIALIZED VIEW ROUTE11326 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11326"';
CREATE MATERIALIZED VIEW ROUTE13119 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13119"';
CREATE MATERIALIZED VIEW ROUTE13631 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13631"';
CREATE MATERIALIZED VIEW ROUTE1344 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1344"';
CREATE MATERIALIZED VIEW ROUTE13632 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13632"';
CREATE MATERIALIZED VIEW ROUTE1345 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1345"';
CREATE MATERIALIZED VIEW ROUTE11329 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11329"';
CREATE MATERIALIZED VIEW ROUTE13121 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13121"';
CREATE MATERIALIZED VIEW ROUTE834 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"834"';
CREATE MATERIALIZED VIEW ROUTE1346 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1346"';
CREATE MATERIALIZED VIEW ROUTE3394 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3394"';
CREATE MATERIALIZED VIEW ROUTE8514 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8514"';
CREATE MATERIALIZED VIEW ROUTE5700 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5700"';
CREATE MATERIALIZED VIEW ROUTE13636 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13636"';
CREATE MATERIALIZED VIEW ROUTE8517 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8517"';
CREATE MATERIALIZED VIEW ROUTE1350 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1350"';
CREATE MATERIALIZED VIEW ROUTE3398 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3398"';
CREATE MATERIALIZED VIEW ROUTE13638 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13638"';
CREATE MATERIALIZED VIEW ROUTE8263 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8263"';
CREATE MATERIALIZED VIEW ROUTE11591 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11591"';
CREATE MATERIALIZED VIEW ROUTE13127 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13127"';
CREATE MATERIALIZED VIEW ROUTE1608 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1608"';
CREATE MATERIALIZED VIEW ROUTE5704 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5704"';
CREATE MATERIALIZED VIEW ROUTE13640 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13640"';
CREATE MATERIALIZED VIEW ROUTE841 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"841"';
CREATE MATERIALIZED VIEW ROUTE1609 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1609"';
CREATE MATERIALIZED VIEW ROUTE3401 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3401"';
CREATE MATERIALIZED VIEW ROUTE11337 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11337"';
CREATE MATERIALIZED VIEW ROUTE1610 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1610"';
CREATE MATERIALIZED VIEW ROUTE1355 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1355"';
CREATE MATERIALIZED VIEW ROUTE1611 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1611"';
CREATE MATERIALIZED VIEW ROUTE10827 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10827"';
CREATE MATERIALIZED VIEW ROUTE844 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"844"';
CREATE MATERIALIZED VIEW ROUTE13132 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13132"';
CREATE MATERIALIZED VIEW ROUTE845 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"845"';
CREATE MATERIALIZED VIEW ROUTE1357 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1357"';
CREATE MATERIALIZED VIEW ROUTE11597 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11597"';
CREATE MATERIALIZED VIEW ROUTE2126 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2126"';
CREATE MATERIALIZED VIEW ROUTE10830 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10830"';
CREATE MATERIALIZED VIEW ROUTE11342 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11342"';
CREATE MATERIALIZED VIEW ROUTE13134 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13134"';
CREATE MATERIALIZED VIEW ROUTE847 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"847"';
CREATE MATERIALIZED VIEW ROUTE2895 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2895"';
CREATE MATERIALIZED VIEW ROUTE13135 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13135"';
CREATE MATERIALIZED VIEW ROUTE848 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"848"';
CREATE MATERIALIZED VIEW ROUTE2896 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2896"';
CREATE MATERIALIZED VIEW ROUTE3408 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3408"';
CREATE MATERIALIZED VIEW ROUTE11600 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11600"';
CREATE MATERIALIZED VIEW ROUTE2897 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2897"';
CREATE MATERIALIZED VIEW ROUTE850 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"850"';
CREATE MATERIALIZED VIEW ROUTE7762 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7762"';
CREATE MATERIALIZED VIEW ROUTE13138 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13138"';
CREATE MATERIALIZED VIEW ROUTE851 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"851"';
CREATE MATERIALIZED VIEW ROUTE3411 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3411"';
CREATE MATERIALIZED VIEW ROUTE8275 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8275"';
CREATE MATERIALIZED VIEW ROUTE11347 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11347"';
CREATE MATERIALIZED VIEW ROUTE11603 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11603"';
CREATE MATERIALIZED VIEW ROUTE5460 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5460"';
CREATE MATERIALIZED VIEW ROUTE13140 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13140"';
CREATE MATERIALIZED VIEW ROUTE1365 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1365"';
CREATE MATERIALIZED VIEW ROUTE7765 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7765"';
CREATE MATERIALIZED VIEW ROUTE854 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"854"';
CREATE MATERIALIZED VIEW ROUTE1878 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1878"';
CREATE MATERIALIZED VIEW ROUTE855 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"855"';
CREATE MATERIALIZED VIEW ROUTE1879 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1879"';
CREATE MATERIALIZED VIEW ROUTE2903 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2903"';
CREATE MATERIALIZED VIEW ROUTE10839 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10839"';
CREATE MATERIALIZED VIEW ROUTE1112 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1112"';
CREATE MATERIALIZED VIEW ROUTE1624 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1624"';
CREATE MATERIALIZED VIEW ROUTE1880 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1880"';
CREATE MATERIALIZED VIEW ROUTE7768 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7768"';
CREATE MATERIALIZED VIEW ROUTE11096 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11096"';
CREATE MATERIALIZED VIEW ROUTE1881 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1881"';
CREATE MATERIALIZED VIEW ROUTE11609 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11609"';
CREATE MATERIALIZED VIEW ROUTE5722 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5722"';
CREATE MATERIALIZED VIEW ROUTE10842 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10842"';
CREATE MATERIALIZED VIEW ROUTE11354 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11354"';
CREATE MATERIALIZED VIEW ROUTE7771 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7771"';
CREATE MATERIALIZED VIEW ROUTE860 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"860"';
CREATE MATERIALIZED VIEW ROUTE3420 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3420"';
CREATE MATERIALIZED VIEW ROUTE7772 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7772"';
CREATE MATERIALIZED VIEW ROUTE861 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"861"';
CREATE MATERIALIZED VIEW ROUTE11357 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11357"';
CREATE MATERIALIZED VIEW ROUTE13661 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13661"';
CREATE MATERIALIZED VIEW ROUTE862 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"862"';
CREATE MATERIALIZED VIEW ROUTE10846 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10846"';
CREATE MATERIALIZED VIEW ROUTE3423 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3423"';
CREATE MATERIALIZED VIEW ROUTE1632 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1632"';
CREATE MATERIALIZED VIEW ROUTE7776 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7776"';
CREATE MATERIALIZED VIEW ROUTE11360 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11360"';
CREATE MATERIALIZED VIEW ROUTE11616 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11616"';
CREATE MATERIALIZED VIEW ROUTE13408 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13408"';
CREATE MATERIALIZED VIEW ROUTE2913 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2913"';
CREATE MATERIALIZED VIEW ROUTE11617 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11617"';
CREATE MATERIALIZED VIEW ROUTE13665 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13665"';
CREATE MATERIALIZED VIEW ROUTE7522 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7522"';
CREATE MATERIALIZED VIEW ROUTE11618 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11618"';
CREATE MATERIALIZED VIEW ROUTE867 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"867"';
CREATE MATERIALIZED VIEW ROUTE1123 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1123"';
CREATE MATERIALIZED VIEW ROUTE1379 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1379"';
CREATE MATERIALIZED VIEW ROUTE7779 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7779"';
CREATE MATERIALIZED VIEW ROUTE11363 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11363"';
CREATE MATERIALIZED VIEW ROUTE11619 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11619"';
CREATE MATERIALIZED VIEW ROUTE13667 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13667"';
CREATE MATERIALIZED VIEW ROUTE2916 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2916"';
CREATE MATERIALIZED VIEW ROUTE11620 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11620"';
CREATE MATERIALIZED VIEW ROUTE13668 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13668"';
CREATE MATERIALIZED VIEW ROUTE869 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"869"';
CREATE MATERIALIZED VIEW ROUTE11109 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11109"';
CREATE MATERIALIZED VIEW ROUTE11621 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11621"';
CREATE MATERIALIZED VIEW ROUTE13669 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13669"';
CREATE MATERIALIZED VIEW ROUTE870 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"870"';
CREATE MATERIALIZED VIEW ROUTE7782 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7782"';
CREATE MATERIALIZED VIEW ROUTE10854 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10854"';
CREATE MATERIALIZED VIEW ROUTE11366 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11366"';
CREATE MATERIALIZED VIEW ROUTE11622 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11622"';
CREATE MATERIALIZED VIEW ROUTE13670 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13670"';
CREATE MATERIALIZED VIEW ROUTE2919 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2919"';
CREATE MATERIALIZED VIEW ROUTE4711 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4711"';
CREATE MATERIALIZED VIEW ROUTE11623 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11623"';
CREATE MATERIALIZED VIEW ROUTE5480 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5480"';
CREATE MATERIALIZED VIEW ROUTE11112 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11112"';
CREATE MATERIALIZED VIEW ROUTE11624 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11624"';
CREATE MATERIALIZED VIEW ROUTE5481 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5481"';
CREATE MATERIALIZED VIEW ROUTE7785 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7785"';
CREATE MATERIALIZED VIEW ROUTE11369 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11369"';
CREATE MATERIALIZED VIEW ROUTE11625 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11625"';
CREATE MATERIALIZED VIEW ROUTE2922 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2922"';
CREATE MATERIALIZED VIEW ROUTE5738 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5738"';
CREATE MATERIALIZED VIEW ROUTE11626 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11626"';
CREATE MATERIALIZED VIEW ROUTE7531 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7531"';
CREATE MATERIALIZED VIEW ROUTE11627 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11627"';
CREATE MATERIALIZED VIEW ROUTE7788 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7788"';
CREATE MATERIALIZED VIEW ROUTE11372 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11372"';
CREATE MATERIALIZED VIEW ROUTE11628 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11628"';
CREATE MATERIALIZED VIEW ROUTE2925 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2925"';
CREATE MATERIALIZED VIEW ROUTE5741 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5741"';
CREATE MATERIALIZED VIEW ROUTE10861 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10861"';
CREATE MATERIALIZED VIEW ROUTE11629 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11629"';
CREATE MATERIALIZED VIEW ROUTE13165 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13165"';
CREATE MATERIALIZED VIEW ROUTE3438 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3438"';
CREATE MATERIALIZED VIEW ROUTE8302 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8302"';
CREATE MATERIALIZED VIEW ROUTE11118 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11118"';
CREATE MATERIALIZED VIEW ROUTE11630 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11630"';
CREATE MATERIALIZED VIEW ROUTE13166 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13166"';
CREATE MATERIALIZED VIEW ROUTE7791 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7791"';
CREATE MATERIALIZED VIEW ROUTE10863 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10863"';
CREATE MATERIALIZED VIEW ROUTE11375 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11375"';
CREATE MATERIALIZED VIEW ROUTE11631 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11631"';
CREATE MATERIALIZED VIEW ROUTE13167 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13167"';
CREATE MATERIALIZED VIEW ROUTE2928 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2928"';
CREATE MATERIALIZED VIEW ROUTE10864 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10864"';
CREATE MATERIALIZED VIEW ROUTE11632 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11632"';
CREATE MATERIALIZED VIEW ROUTE13168 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13168"';
CREATE MATERIALIZED VIEW ROUTE13680 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13680"';
CREATE MATERIALIZED VIEW ROUTE8561 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8561"';
CREATE MATERIALIZED VIEW ROUTE11121 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11121"';
CREATE MATERIALIZED VIEW ROUTE11633 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11633"';
CREATE MATERIALIZED VIEW ROUTE13169 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13169"';
CREATE MATERIALIZED VIEW ROUTE5746 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5746"';
CREATE MATERIALIZED VIEW ROUTE8306 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8306"';
CREATE MATERIALIZED VIEW ROUTE11378 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11378"';
CREATE MATERIALIZED VIEW ROUTE11634 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11634"';
CREATE MATERIALIZED VIEW ROUTE13170 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13170"';
CREATE MATERIALIZED VIEW ROUTE13426 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13426"';
CREATE MATERIALIZED VIEW ROUTE2931 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2931"';
CREATE MATERIALIZED VIEW ROUTE5747 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5747"';
CREATE MATERIALIZED VIEW ROUTE8307 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8307"';
CREATE MATERIALIZED VIEW ROUTE11635 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11635"';
CREATE MATERIALIZED VIEW ROUTE13171 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13171"';
CREATE MATERIALIZED VIEW ROUTE884 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"884"';
CREATE MATERIALIZED VIEW ROUTE1396 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1396"';
CREATE MATERIALIZED VIEW ROUTE1908 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1908"';
CREATE MATERIALIZED VIEW ROUTE5748 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5748"';
CREATE MATERIALIZED VIEW ROUTE8564 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8564"';
CREATE MATERIALIZED VIEW ROUTE13172 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13172"';
CREATE MATERIALIZED VIEW ROUTE1909 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1909"';
CREATE MATERIALIZED VIEW ROUTE7797 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7797"';
CREATE MATERIALIZED VIEW ROUTE8565 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8565"';
CREATE MATERIALIZED VIEW ROUTE11381 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11381"';
CREATE MATERIALIZED VIEW ROUTE13173 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13173"';
CREATE MATERIALIZED VIEW ROUTE13685 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13685"';
CREATE MATERIALIZED VIEW ROUTE1910 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1910"';
CREATE MATERIALIZED VIEW ROUTE2934 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2934"';
CREATE MATERIALIZED VIEW ROUTE13174 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13174"';
CREATE MATERIALIZED VIEW ROUTE13686 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13686"';
CREATE MATERIALIZED VIEW ROUTE887 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"887"';
CREATE MATERIALIZED VIEW ROUTE1143 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1143"';
CREATE MATERIALIZED VIEW ROUTE1399 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1399"';
CREATE MATERIALIZED VIEW ROUTE8567 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8567"';
CREATE MATERIALIZED VIEW ROUTE13175 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13175"';
CREATE MATERIALIZED VIEW ROUTE13687 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13687"';
CREATE MATERIALIZED VIEW ROUTE1400 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1400"';
CREATE MATERIALIZED VIEW ROUTE1912 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1912"';
CREATE MATERIALIZED VIEW ROUTE3448 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3448"';
CREATE MATERIALIZED VIEW ROUTE11384 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11384"';
CREATE MATERIALIZED VIEW ROUTE13176 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13176"';
CREATE MATERIALIZED VIEW ROUTE2937 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2937"';
CREATE MATERIALIZED VIEW ROUTE8569 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8569"';
CREATE MATERIALIZED VIEW ROUTE13177 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13177"';
CREATE MATERIALIZED VIEW ROUTE1658 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1658"';
CREATE MATERIALIZED VIEW ROUTE1914 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1914"';
CREATE MATERIALIZED VIEW ROUTE8314 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8314"';
CREATE MATERIALIZED VIEW ROUTE8570 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8570"';
CREATE MATERIALIZED VIEW ROUTE13178 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13178"';
CREATE MATERIALIZED VIEW ROUTE13690 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13690"';
CREATE MATERIALIZED VIEW ROUTE1659 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1659"';
CREATE MATERIALIZED VIEW ROUTE1915 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1915"';
CREATE MATERIALIZED VIEW ROUTE8571 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8571"';
CREATE MATERIALIZED VIEW ROUTE11387 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11387"';
CREATE MATERIALIZED VIEW ROUTE13179 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13179"';
CREATE MATERIALIZED VIEW ROUTE1660 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1660"';
CREATE MATERIALIZED VIEW ROUTE8572 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8572"';
CREATE MATERIALIZED VIEW ROUTE3453 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3453"';
CREATE MATERIALIZED VIEW ROUTE8317 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8317"';
CREATE MATERIALIZED VIEW ROUTE1150 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1150"';
CREATE MATERIALIZED VIEW ROUTE11390 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11390"';
CREATE MATERIALIZED VIEW ROUTE2943 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2943"';
CREATE MATERIALIZED VIEW ROUTE1664 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1664"';
CREATE MATERIALIZED VIEW ROUTE13696 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13696"';
CREATE MATERIALIZED VIEW ROUTE897 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"897"';
CREATE MATERIALIZED VIEW ROUTE1665 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1665"';
CREATE MATERIALIZED VIEW ROUTE11393 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11393"';
CREATE MATERIALIZED VIEW ROUTE13697 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13697"';
CREATE MATERIALIZED VIEW ROUTE1666 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1666"';
CREATE MATERIALIZED VIEW ROUTE1667 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1667"';
CREATE MATERIALIZED VIEW ROUTE8579 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8579"';
CREATE MATERIALIZED VIEW ROUTE1925 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1925"';
CREATE MATERIALIZED VIEW ROUTE11397 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11397"';
CREATE MATERIALIZED VIEW ROUTE11653 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11653"';
CREATE MATERIALIZED VIEW ROUTE13701 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13701"';
CREATE MATERIALIZED VIEW ROUTE5510 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5510"';
CREATE MATERIALIZED VIEW ROUTE8582 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8582"';
CREATE MATERIALIZED VIEW ROUTE5767 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5767"';
CREATE MATERIALIZED VIEW ROUTE13703 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13703"';
CREATE MATERIALIZED VIEW ROUTE5768 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5768"';
CREATE MATERIALIZED VIEW ROUTE13704 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13704"';
CREATE MATERIALIZED VIEW ROUTE1673 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1673"';
CREATE MATERIALIZED VIEW ROUTE4745 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4745"';
CREATE MATERIALIZED VIEW ROUTE5770 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5770"';
CREATE MATERIALIZED VIEW ROUTE8074 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8074"';
CREATE MATERIALIZED VIEW ROUTE4747 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4747"';
CREATE MATERIALIZED VIEW ROUTE13707 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13707"';
CREATE MATERIALIZED VIEW ROUTE4748 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4748"';
CREATE MATERIALIZED VIEW ROUTE909 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"909"';
CREATE MATERIALIZED VIEW ROUTE13709 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13709"';
CREATE MATERIALIZED VIEW ROUTE8590 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8590"';
CREATE MATERIALIZED VIEW ROUTE1935 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1935"';
CREATE MATERIALIZED VIEW ROUTE8591 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8591"';
CREATE MATERIALIZED VIEW ROUTE13455 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13455"';
CREATE MATERIALIZED VIEW ROUTE8080 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8080"';
CREATE MATERIALIZED VIEW ROUTE11664 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11664"';
CREATE MATERIALIZED VIEW ROUTE13712 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13712"';
CREATE MATERIALIZED VIEW ROUTE913 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"913"';
CREATE MATERIALIZED VIEW ROUTE13457 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13457"';
CREATE MATERIALIZED VIEW ROUTE13714 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13714"';
CREATE MATERIALIZED VIEW ROUTE4755 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4755"';
CREATE MATERIALIZED VIEW ROUTE13459 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13459"';
CREATE MATERIALIZED VIEW ROUTE8084 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8084"';
CREATE MATERIALIZED VIEW ROUTE8596 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8596"';
CREATE MATERIALIZED VIEW ROUTE10900 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10900"';
CREATE MATERIALIZED VIEW ROUTE13716 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13716"';
CREATE MATERIALIZED VIEW ROUTE1173 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1173"';
CREATE MATERIALIZED VIEW ROUTE4757 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4757"';
CREATE MATERIALIZED VIEW ROUTE1174 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1174"';
CREATE MATERIALIZED VIEW ROUTE4758 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4758"';
CREATE MATERIALIZED VIEW ROUTE13718 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13718"';
CREATE MATERIALIZED VIEW ROUTE1175 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1175"';
CREATE MATERIALIZED VIEW ROUTE8599 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8599"';
CREATE MATERIALIZED VIEW ROUTE10903 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10903"';
CREATE MATERIALIZED VIEW ROUTE1176 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1176"';
CREATE MATERIALIZED VIEW ROUTE10904 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10904"';
CREATE MATERIALIZED VIEW ROUTE13720 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13720"';
CREATE MATERIALIZED VIEW ROUTE4761 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4761"';
CREATE MATERIALIZED VIEW ROUTE8602 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8602"';
CREATE MATERIALIZED VIEW ROUTE13722 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13722"';
CREATE MATERIALIZED VIEW ROUTE1947 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1947"';
CREATE MATERIALIZED VIEW ROUTE3483 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3483"';
CREATE MATERIALIZED VIEW ROUTE8606 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8606"';
CREATE MATERIALIZED VIEW ROUTE927 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"927"';
CREATE MATERIALIZED VIEW ROUTE1439 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1439"';
CREATE MATERIALIZED VIEW ROUTE5023 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5023"';
CREATE MATERIALIZED VIEW ROUTE8095 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8095"';
CREATE MATERIALIZED VIEW ROUTE928 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"928"';
CREATE MATERIALIZED VIEW ROUTE1440 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1440"';
CREATE MATERIALIZED VIEW ROUTE929 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"929"';
CREATE MATERIALIZED VIEW ROUTE1441 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1441"';
CREATE MATERIALIZED VIEW ROUTE5537 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5537"';
CREATE MATERIALIZED VIEW ROUTE931 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"931"';
CREATE MATERIALIZED VIEW ROUTE1443 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1443"';
CREATE MATERIALIZED VIEW ROUTE8611 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8611"';
CREATE MATERIALIZED VIEW ROUTE13731 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13731"';
CREATE MATERIALIZED VIEW ROUTE932 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"932"';
CREATE MATERIALIZED VIEW ROUTE1444 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1444"';
CREATE MATERIALIZED VIEW ROUTE5540 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5540"';
CREATE MATERIALIZED VIEW ROUTE10917 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10917"';
CREATE MATERIALIZED VIEW ROUTE1446 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1446"';
CREATE MATERIALIZED VIEW ROUTE2982 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2982"';
CREATE MATERIALIZED VIEW ROUTE8614 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8614"';
CREATE MATERIALIZED VIEW ROUTE935 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"935"';
CREATE MATERIALIZED VIEW ROUTE1447 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1447"';
CREATE MATERIALIZED VIEW ROUTE8615 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8615"';
CREATE MATERIALIZED VIEW ROUTE8871 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8871"';
CREATE MATERIALIZED VIEW ROUTE1448 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1448"';
CREATE MATERIALIZED VIEW ROUTE13736 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13736"';
CREATE MATERIALIZED VIEW ROUTE937 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"937"';
CREATE MATERIALIZED VIEW ROUTE1449 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1449"';
CREATE MATERIALIZED VIEW ROUTE8361 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8361"';
CREATE MATERIALIZED VIEW ROUTE1706 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1706"';
CREATE MATERIALIZED VIEW ROUTE8362 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8362"';
CREATE MATERIALIZED VIEW ROUTE8618 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8618"';
CREATE MATERIALIZED VIEW ROUTE939 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"939"';
CREATE MATERIALIZED VIEW ROUTE10923 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10923"';
CREATE MATERIALIZED VIEW ROUTE940 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"940"';
CREATE MATERIALIZED VIEW ROUTE1452 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1452"';
CREATE MATERIALIZED VIEW ROUTE4780 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4780"';
CREATE MATERIALIZED VIEW ROUTE6572 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"6572"';
CREATE MATERIALIZED VIEW ROUTE10924 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10924"';
CREATE MATERIALIZED VIEW ROUTE13484 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13484"';
CREATE MATERIALIZED VIEW ROUTE13740 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13740"';
CREATE MATERIALIZED VIEW ROUTE8365 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8365"';
CREATE MATERIALIZED VIEW ROUTE8621 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8621"';
CREATE MATERIALIZED VIEW ROUTE13741 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13741"';
CREATE MATERIALIZED VIEW ROUTE1710 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1710"';
CREATE MATERIALIZED VIEW ROUTE5038 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5038"';
CREATE MATERIALIZED VIEW ROUTE8878 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8878"';
CREATE MATERIALIZED VIEW ROUTE13742 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13742"';
CREATE MATERIALIZED VIEW ROUTE8879 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8879"';
CREATE MATERIALIZED VIEW ROUTE10927 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10927"';
CREATE MATERIALIZED VIEW ROUTE8624 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8624"';
CREATE MATERIALIZED VIEW ROUTE945 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"945"';
CREATE MATERIALIZED VIEW ROUTE5041 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5041"';
CREATE MATERIALIZED VIEW ROUTE5809 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5809"';
CREATE MATERIALIZED VIEW ROUTE7601 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7601"';
CREATE MATERIALIZED VIEW ROUTE946 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"946"';
CREATE MATERIALIZED VIEW ROUTE4786 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4786"';
CREATE MATERIALIZED VIEW ROUTE8114 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8114"';
CREATE MATERIALIZED VIEW ROUTE947 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"947"';
CREATE MATERIALIZED VIEW ROUTE8627 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8627"';
CREATE MATERIALIZED VIEW ROUTE8883 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8883"';
CREATE MATERIALIZED VIEW ROUTE948 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"948"';
CREATE MATERIALIZED VIEW ROUTE5812 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5812"';
CREATE MATERIALIZED VIEW ROUTE11700 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11700"';
CREATE MATERIALIZED VIEW ROUTE13748 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13748"';
CREATE MATERIALIZED VIEW ROUTE1461 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1461"';
CREATE MATERIALIZED VIEW ROUTE1717 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1717"';
CREATE MATERIALIZED VIEW ROUTE4789 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4789"';
CREATE MATERIALIZED VIEW ROUTE8373 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8373"';
CREATE MATERIALIZED VIEW ROUTE10933 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10933"';
CREATE MATERIALIZED VIEW ROUTE950 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"950"';
CREATE MATERIALIZED VIEW ROUTE1718 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1718"';
CREATE MATERIALIZED VIEW ROUTE5814 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5814"';
CREATE MATERIALIZED VIEW ROUTE8118 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8118"';
CREATE MATERIALIZED VIEW ROUTE8630 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8630"';
CREATE MATERIALIZED VIEW ROUTE11446 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11446"';
CREATE MATERIALIZED VIEW ROUTE11702 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11702"';
CREATE MATERIALIZED VIEW ROUTE1719 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1719"';
CREATE MATERIALIZED VIEW ROUTE8887 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8887"';
CREATE MATERIALIZED VIEW ROUTE11703 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11703"';
CREATE MATERIALIZED VIEW ROUTE952 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"952"';
CREATE MATERIALIZED VIEW ROUTE1720 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1720"';
CREATE MATERIALIZED VIEW ROUTE4792 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4792"';
CREATE MATERIALIZED VIEW ROUTE5048 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5048"';
CREATE MATERIALIZED VIEW ROUTE11704 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11704"';
CREATE MATERIALIZED VIEW ROUTE953 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"953"';
CREATE MATERIALIZED VIEW ROUTE1721 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1721"';
CREATE MATERIALIZED VIEW ROUTE10937 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10937"';
CREATE MATERIALIZED VIEW ROUTE954 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"954"';
CREATE MATERIALIZED VIEW ROUTE1722 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1722"';
CREATE MATERIALIZED VIEW ROUTE8122 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8122"';
CREATE MATERIALIZED VIEW ROUTE955 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"955"';
CREATE MATERIALIZED VIEW ROUTE1723 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1723"';
CREATE MATERIALIZED VIEW ROUTE4795 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4795"';
CREATE MATERIALIZED VIEW ROUTE5051 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5051"';
CREATE MATERIALIZED VIEW ROUTE1724 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1724"';
CREATE MATERIALIZED VIEW ROUTE5052 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5052"';
CREATE MATERIALIZED VIEW ROUTE10940 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10940"';
CREATE MATERIALIZED VIEW ROUTE957 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"957"';
CREATE MATERIALIZED VIEW ROUTE1469 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1469"';
CREATE MATERIALIZED VIEW ROUTE1725 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1725"';
CREATE MATERIALIZED VIEW ROUTE7613 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7613"';
CREATE MATERIALIZED VIEW ROUTE8125 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8125"';
CREATE MATERIALIZED VIEW ROUTE958 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"958"';
CREATE MATERIALIZED VIEW ROUTE1470 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1470"';
CREATE MATERIALIZED VIEW ROUTE1726 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1726"';
CREATE MATERIALIZED VIEW ROUTE4798 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4798"';
CREATE MATERIALIZED VIEW ROUTE12734 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12734"';
CREATE MATERIALIZED VIEW ROUTE959 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"959"';
CREATE MATERIALIZED VIEW ROUTE1727 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1727"';
CREATE MATERIALIZED VIEW ROUTE4543 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4543"';
CREATE MATERIALIZED VIEW ROUTE5055 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5055"';
CREATE MATERIALIZED VIEW ROUTE8639 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8639"';
CREATE MATERIALIZED VIEW ROUTE11455 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11455"';
CREATE MATERIALIZED VIEW ROUTE11711 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11711"';
CREATE MATERIALIZED VIEW ROUTE960 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"960"';
CREATE MATERIALIZED VIEW ROUTE1728 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1728"';
CREATE MATERIALIZED VIEW ROUTE8128 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8128"';
CREATE MATERIALIZED VIEW ROUTE11456 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11456"';
CREATE MATERIALIZED VIEW ROUTE961 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"961"';
CREATE MATERIALIZED VIEW ROUTE7617 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7617"';
CREATE MATERIALIZED VIEW ROUTE11457 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11457"';
CREATE MATERIALIZED VIEW ROUTE11713 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11713"';
CREATE MATERIALIZED VIEW ROUTE12737 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12737"';
CREATE MATERIALIZED VIEW ROUTE962 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"962"';
CREATE MATERIALIZED VIEW ROUTE1474 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1474"';
CREATE MATERIALIZED VIEW ROUTE4802 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4802"';
CREATE MATERIALIZED VIEW ROUTE11458 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11458"';
CREATE MATERIALIZED VIEW ROUTE11714 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11714"';
CREATE MATERIALIZED VIEW ROUTE963 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"963"';
CREATE MATERIALIZED VIEW ROUTE1475 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1475"';
CREATE MATERIALIZED VIEW ROUTE1731 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1731"';
CREATE MATERIALIZED VIEW ROUTE5827 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5827"';
CREATE MATERIALIZED VIEW ROUTE12739 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12739"';
CREATE MATERIALIZED VIEW ROUTE13251 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13251"';
CREATE MATERIALIZED VIEW ROUTE964 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"964"';
CREATE MATERIALIZED VIEW ROUTE1732 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1732"';
CREATE MATERIALIZED VIEW ROUTE8132 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8132"';
CREATE MATERIALIZED VIEW ROUTE13252 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13252"';
CREATE MATERIALIZED VIEW ROUTE1733 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1733"';
CREATE MATERIALIZED VIEW ROUTE4805 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4805"';
CREATE MATERIALIZED VIEW ROUTE8645 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8645"';
CREATE MATERIALIZED VIEW ROUTE11205 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11205"';
CREATE MATERIALIZED VIEW ROUTE11461 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11461"';
CREATE MATERIALIZED VIEW ROUTE13253 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13253"';
CREATE MATERIALIZED VIEW ROUTE1734 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1734"';
CREATE MATERIALIZED VIEW ROUTE5062 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5062"';
CREATE MATERIALIZED VIEW ROUTE11462 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11462"';
CREATE MATERIALIZED VIEW ROUTE13254 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13254"';
CREATE MATERIALIZED VIEW ROUTE1735 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1735"';
CREATE MATERIALIZED VIEW ROUTE1991 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1991"';
CREATE MATERIALIZED VIEW ROUTE8135 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8135"';
CREATE MATERIALIZED VIEW ROUTE12743 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12743"';
CREATE MATERIALIZED VIEW ROUTE13255 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13255"';
CREATE MATERIALIZED VIEW ROUTE8648 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8648"';
CREATE MATERIALIZED VIEW ROUTE10952 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10952"';
CREATE MATERIALIZED VIEW ROUTE11464 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11464"';
CREATE MATERIALIZED VIEW ROUTE13256 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13256"';
CREATE MATERIALIZED VIEW ROUTE1737 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1737"';
CREATE MATERIALIZED VIEW ROUTE2505 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2505"';
CREATE MATERIALIZED VIEW ROUTE11465 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11465"';
CREATE MATERIALIZED VIEW ROUTE13257 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13257"';
CREATE MATERIALIZED VIEW ROUTE970 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"970"';
CREATE MATERIALIZED VIEW ROUTE1482 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1482"';
CREATE MATERIALIZED VIEW ROUTE1738 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1738"';
CREATE MATERIALIZED VIEW ROUTE5834 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5834"';
CREATE MATERIALIZED VIEW ROUTE11466 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11466"';
CREATE MATERIALIZED VIEW ROUTE12746 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12746"';
CREATE MATERIALIZED VIEW ROUTE971 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"971"';
CREATE MATERIALIZED VIEW ROUTE1995 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1995"';
CREATE MATERIALIZED VIEW ROUTE7627 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7627"';
CREATE MATERIALIZED VIEW ROUTE8139 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8139"';
CREATE MATERIALIZED VIEW ROUTE8651 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8651"';
CREATE MATERIALIZED VIEW ROUTE10955 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10955"';
CREATE MATERIALIZED VIEW ROUTE972 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"972"';
CREATE MATERIALIZED VIEW ROUTE1740 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1740"';
CREATE MATERIALIZED VIEW ROUTE973 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"973"';
CREATE MATERIALIZED VIEW ROUTE5069 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5069"';
CREATE MATERIALIZED VIEW ROUTE5837 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5837"';
CREATE MATERIALIZED VIEW ROUTE12749 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12749"';
CREATE MATERIALIZED VIEW ROUTE974 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"974"';
CREATE MATERIALIZED VIEW ROUTE5838 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5838"';
CREATE MATERIALIZED VIEW ROUTE8142 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8142"';
CREATE MATERIALIZED VIEW ROUTE8654 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8654"';
CREATE MATERIALIZED VIEW ROUTE12750 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12750"';
CREATE MATERIALIZED VIEW ROUTE975 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"975"';
CREATE MATERIALIZED VIEW ROUTE8399 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8399"';
CREATE MATERIALIZED VIEW ROUTE13263 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13263"';
CREATE MATERIALIZED VIEW ROUTE976 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"976"';
CREATE MATERIALIZED VIEW ROUTE1744 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1744"';
CREATE MATERIALIZED VIEW ROUTE2768 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2768"';
CREATE MATERIALIZED VIEW ROUTE8912 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8912"';
CREATE MATERIALIZED VIEW ROUTE11472 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11472"';
CREATE MATERIALIZED VIEW ROUTE721 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"721"';
CREATE MATERIALIZED VIEW ROUTE977 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"977"';
CREATE MATERIALIZED VIEW ROUTE1745 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1745"';
CREATE MATERIALIZED VIEW ROUTE5841 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5841"';
CREATE MATERIALIZED VIEW ROUTE10961 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10961"';
CREATE MATERIALIZED VIEW ROUTE11473 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11473"';
CREATE MATERIALIZED VIEW ROUTE12753 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12753"';
CREATE MATERIALIZED VIEW ROUTE722 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"722"';
CREATE MATERIALIZED VIEW ROUTE11474 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11474"';
CREATE MATERIALIZED VIEW ROUTE13266 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13266"';
CREATE MATERIALIZED VIEW ROUTE979 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"979"';
CREATE MATERIALIZED VIEW ROUTE5331 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5331"';
CREATE MATERIALIZED VIEW ROUTE5843 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5843"';
CREATE MATERIALIZED VIEW ROUTE7891 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"7891"';
CREATE MATERIALIZED VIEW ROUTE11475 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11475"';
CREATE MATERIALIZED VIEW ROUTE13267 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13267"';
CREATE MATERIALIZED VIEW ROUTE724 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"724"';
CREATE MATERIALIZED VIEW ROUTE980 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"980"';
CREATE MATERIALIZED VIEW ROUTE5844 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5844"';
CREATE MATERIALIZED VIEW ROUTE10964 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10964"';
CREATE MATERIALIZED VIEW ROUTE13268 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13268"';
CREATE MATERIALIZED VIEW ROUTE725 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"725"';
CREATE MATERIALIZED VIEW ROUTE1493 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1493"';
CREATE MATERIALIZED VIEW ROUTE1749 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1749"';
CREATE MATERIALIZED VIEW ROUTE5589 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5589"';
CREATE MATERIALIZED VIEW ROUTE13269 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13269"';
CREATE MATERIALIZED VIEW ROUTE982 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"982"';
CREATE MATERIALIZED VIEW ROUTE1494 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1494"';
CREATE MATERIALIZED VIEW ROUTE5334 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5334"';
CREATE MATERIALIZED VIEW ROUTE5846 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5846"';
CREATE MATERIALIZED VIEW ROUTE11478 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11478"';
CREATE MATERIALIZED VIEW ROUTE13270 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13270"';
CREATE MATERIALIZED VIEW ROUTE1495 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1495"';
CREATE MATERIALIZED VIEW ROUTE1751 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1751"';
CREATE MATERIALIZED VIEW ROUTE3287 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3287"';
CREATE MATERIALIZED VIEW ROUTE10967 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10967"';
CREATE MATERIALIZED VIEW ROUTE13271 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13271"';
CREATE MATERIALIZED VIEW ROUTE8922 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8922"';
CREATE MATERIALIZED VIEW ROUTE1755 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1755"';
CREATE MATERIALIZED VIEW ROUTE1756 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1756"';
CREATE MATERIALIZED VIEW ROUTE8924 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8924"';
CREATE MATERIALIZED VIEW ROUTE1758 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1758"';
CREATE MATERIALIZED VIEW ROUTE12766 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12766"';
CREATE MATERIALIZED VIEW ROUTE1759 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1759"';
CREATE MATERIALIZED VIEW ROUTE12767 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12767"';
CREATE MATERIALIZED VIEW ROUTE13791 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13791"';
CREATE MATERIALIZED VIEW ROUTE1760 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1760"';
CREATE MATERIALIZED VIEW ROUTE13024 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13024"';
CREATE MATERIALIZED VIEW ROUTE1761 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1761"';
CREATE MATERIALIZED VIEW ROUTE12769 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12769"';
CREATE MATERIALIZED VIEW ROUTE13025 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13025"';
CREATE MATERIALIZED VIEW ROUTE13281 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13281"';
CREATE MATERIALIZED VIEW ROUTE13793 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13793"';
CREATE MATERIALIZED VIEW ROUTE1506 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1506"';
CREATE MATERIALIZED VIEW ROUTE1762 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1762"';
CREATE MATERIALIZED VIEW ROUTE13794 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13794"';
CREATE MATERIALIZED VIEW ROUTE13027 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13027"';
CREATE MATERIALIZED VIEW ROUTE10980 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10980"';
CREATE MATERIALIZED VIEW ROUTE13028 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13028"';
CREATE MATERIALIZED VIEW ROUTE13796 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13796"';
CREATE MATERIALIZED VIEW ROUTE8677 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8677"';
CREATE MATERIALIZED VIEW ROUTE1510 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1510"';
CREATE MATERIALIZED VIEW ROUTE8934 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8934"';
CREATE MATERIALIZED VIEW ROUTE999 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"999"';
CREATE MATERIALIZED VIEW ROUTE1511 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1511"';
CREATE MATERIALIZED VIEW ROUTE1767 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1767"';
CREATE MATERIALIZED VIEW ROUTE5607 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5607"';
CREATE MATERIALIZED VIEW ROUTE13799 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13799"';
CREATE MATERIALIZED VIEW ROUTE1000 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1000"';
CREATE MATERIALIZED VIEW ROUTE1512 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1512"';
CREATE MATERIALIZED VIEW ROUTE1768 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1768"';
CREATE MATERIALIZED VIEW ROUTE8680 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8680"';
CREATE MATERIALIZED VIEW ROUTE8681 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8681"';
CREATE MATERIALIZED VIEW ROUTE13545 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13545"';
CREATE MATERIALIZED VIEW ROUTE13801 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13801"';
CREATE MATERIALIZED VIEW ROUTE1002 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1002"';
CREATE MATERIALIZED VIEW ROUTE1515 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1515"';
CREATE MATERIALIZED VIEW ROUTE12779 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12779"';
CREATE MATERIALIZED VIEW ROUTE12780 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"12780"';
CREATE MATERIALIZED VIEW ROUTE1773 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1773"';
CREATE MATERIALIZED VIEW ROUTE2285 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2285"';
CREATE MATERIALIZED VIEW ROUTE8941 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8941"';
CREATE MATERIALIZED VIEW ROUTE1774 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1774"';
CREATE MATERIALIZED VIEW ROUTE8174 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8174"';
CREATE MATERIALIZED VIEW ROUTE8430 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8430"';
CREATE MATERIALIZED VIEW ROUTE10990 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10990"';
CREATE MATERIALIZED VIEW ROUTE1007 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1007"';
CREATE MATERIALIZED VIEW ROUTE1775 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1775"';
CREATE MATERIALIZED VIEW ROUTE13807 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13807"';
CREATE MATERIALIZED VIEW ROUTE1776 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1776"';
CREATE MATERIALIZED VIEW ROUTE11504 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11504"';
CREATE MATERIALIZED VIEW ROUTE4849 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4849"';
CREATE MATERIALIZED VIEW ROUTE5105 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5105"';
CREATE MATERIALIZED VIEW ROUTE8177 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8177"';
CREATE MATERIALIZED VIEW ROUTE13809 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13809"';
CREATE MATERIALIZED VIEW ROUTE10994 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"10994"';
CREATE MATERIALIZED VIEW ROUTE13554 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13554"';
CREATE MATERIALIZED VIEW ROUTE8435 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8435"';
CREATE MATERIALIZED VIEW ROUTE11507 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11507"';
CREATE MATERIALIZED VIEW ROUTE1524 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1524"';
CREATE MATERIALIZED VIEW ROUTE5108 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5108"';
CREATE MATERIALIZED VIEW ROUTE8948 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8948"';
CREATE MATERIALIZED VIEW ROUTE1013 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1013"';
CREATE MATERIALIZED VIEW ROUTE2293 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2293"';
CREATE MATERIALIZED VIEW ROUTE1782 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1782"';
CREATE MATERIALIZED VIEW ROUTE2294 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2294"';
CREATE MATERIALIZED VIEW ROUTE11510 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11510"';
CREATE MATERIALIZED VIEW ROUTE1015 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1015"';
CREATE MATERIALIZED VIEW ROUTE1783 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1783"';
CREATE MATERIALIZED VIEW ROUTE2295 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2295"';
CREATE MATERIALIZED VIEW ROUTE4855 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4855"';
CREATE MATERIALIZED VIEW ROUTE6647 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"6647"';
CREATE MATERIALIZED VIEW ROUTE8951 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8951"';
CREATE MATERIALIZED VIEW ROUTE1784 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1784"';
CREATE MATERIALIZED VIEW ROUTE2808 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2808"';
CREATE MATERIALIZED VIEW ROUTE5368 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5368"';
CREATE MATERIALIZED VIEW ROUTE6648 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"6648"';
CREATE MATERIALIZED VIEW ROUTE761 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"761"';
CREATE MATERIALIZED VIEW ROUTE3321 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3321"';
CREATE MATERIALIZED VIEW ROUTE5369 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5369"';
CREATE MATERIALIZED VIEW ROUTE6649 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"6649"';
CREATE MATERIALIZED VIEW ROUTE8185 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8185"';
CREATE MATERIALIZED VIEW ROUTE11513 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11513"';
CREATE MATERIALIZED VIEW ROUTE3322 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3322"';
CREATE MATERIALIZED VIEW ROUTE5370 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5370"';
CREATE MATERIALIZED VIEW ROUTE5371 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5371"';
CREATE MATERIALIZED VIEW ROUTE8955 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8955"';
CREATE MATERIALIZED VIEW ROUTE11003 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11003"';
CREATE MATERIALIZED VIEW ROUTE1532 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1532"';
CREATE MATERIALIZED VIEW ROUTE3324 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"3324"';
CREATE MATERIALIZED VIEW ROUTE8956 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8956"';
CREATE MATERIALIZED VIEW ROUTE11516 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"11516"';
CREATE MATERIALIZED VIEW ROUTE13820 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"13820"';
CREATE MATERIALIZED VIEW ROUTE1533 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1533"';
CREATE MATERIALIZED VIEW ROUTE2813 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"2813"';
CREATE MATERIALIZED VIEW ROUTE4861 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"4861"';
CREATE MATERIALIZED VIEW ROUTE8957 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8957"';
CREATE MATERIALIZED VIEW ROUTE8958 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8958"';
CREATE MATERIALIZED VIEW ROUTE1023 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"1023"';
CREATE MATERIALIZED VIEW ROUTE5375 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"5375"';
CREATE MATERIALIZED VIEW ROUTE8959 AS
    SELECT *
    FROM all_tripvibe
    WHERE route_id = '"8959"';