About E_money12

E_money12 · ‎01-20-2020

Well I'm out of luck, because this data was given to me with no background information other than reported parking citations. None the less would you know how to code for a choropleth based on US states and their frequency?

E_money12 · ‎01-19-2020

Here is a different section from the csv, it should have proper lat and long values. Ticket number,Issue Date,Issue time,Meter Id,Marked Time,RP State Plate,Plate Expiry Date,VIN,Make,Body Style,Color,Location,Route,Agency,Violation code,Violation Description,Fine amount,Latitude,Longitude 4273733822,2016-01-19T00:00:00,1228,,,CA,201508,,TOYT,PA,BK,1880 EL CERRITO PL,00485,54,80.69BS,NO PARK/STREET CLEAN,73,6457152.1,1860798 4273733833,2016-01-19T00:00:00,1236,HO991,,CA,201608,,LEXS,PA,GY,1701 LAS PALMAS AV N,00485,54,88.13B+,METER EXP.,63,6459906.9,1859512.3 4273733844,2016-01-19T00:00:00,1331,,,NE,201611,,TOYT,PA,RD,1665 SYCAMORE AVE N,00485,54,80.69BS,NO PARK/STREET CLEAN,73,6457731.2,1859357.8 4273733855,2016-01-19T00:00:00,1332,,,CA,201603,,JEEP,PA,WT,1665 SYCAMORE AVE N,00485,54,80.69BS,NO PARK/STREET CLEAN,73,6457731.2,1859357.8 4273733866,2016-01-19T00:00:00,1338,,,CA,201610,,MAZD,PA,GY,7001 HAWTHORN AVE,00485,54,80.56E4+,RED ZONE,93,6458312.4,1859071.2 4273733881,2016-01-19T00:00:00,1340,,,CA,201607,,CHEV,PA,BK,7001 HAWTHORN AVE,00485,54,80.69BS,NO PARK/STREET CLEAN,73,6458312.4,1859071.2 4273741776,2016-01-19T00:00:00,1032,,,CA,5,,FORD,PA,GY,9507 DORRINGTON AVE,00331,53,80.69BS,NO PARK/STREET CLEAN,73,6427344.2,1911181.4 4273741780,2016-01-19T00:00:00,1043,,,CA,3,,NISS,PU,WT,13900 PIERCE ST,00331,53,80.69BS,NO PARK/STREET CLEAN,73,6430052,1914015.3 4273743983,2016-01-19T00:00:00,704,,,CA,201604,,DODG,PA,RD,1282 SUNSET BLVD W,00640,56,80.70,NO STOPPING/ANTI-GRI,163,6485800.9,1848249.7 4273743994,2016-01-19T00:00:00,727,,,CA,201603,,LEXS,PA,RD,940 AVILA ST,00640,56,80.56E2,YELLOW ZONE,58,6491078.9,1843431.9 4273751672,2016-01-19T00:00:00,1635,WW2705,,CA,201604,,NISS,PA,WT,3501 7TH ST W,00401,54,88.13B+,METER EXP.,63,6469869,1844249.5 4273751683,2016-01-19T00:00:00,1724,WW1711B,,CA,201602,,LEXS,PA,BK,601 SERRANO AV S,00401,54,88.13B+,METER EXP.,63,6468733.3,1852248.6 4273751694,2016-01-19T00:00:00,1741,,,CA,201701,,TOYT,PA,WT,631 BERENDO ST S,00401,54,80.61,STANDNG IN ALLEY,68,6472581.7,1845235.8 4273751705,2016-01-19T00:00:00,1821,80,,CA,201609,,FORD,PA,GY,4760 WILLOW BROOK AVE,00401,54,80.58L,PREFERENTIAL PARKING,68,6472288.6,1855056.4 4273751716,2016-01-19T00:00:00,1822,80,,CA,201609,,BMW,PA,BK,4761 WILLOW BROOK AVE,00401,54,80.58L,PREFERENTIAL PARKING,68,6472288.6,1855056.4 4273751731,2016-01-19T00:00:00,1833,80,,CA,201601,,FORD,PU,WT,871 HELIOTROPE DR,00401,54,80.58L,PREFERENTIAL PARKING,68,6472357.5,1854317.2 4273751786,2016-01-19T00:00:00,1857,42,,CA,201601,,JEEP,TK,GN,5152 RALEIGH ST,00401,54,80.58L,PREFERENTIAL PARKING,68,6466378.8,1852579.8 4273751790,2016-01-19T00:00:00,1859,42,,AK,201604,,HYUN,PA,GY,5146 RALEIGH ST,00401,54,80.58L,PREFERENTIAL PARKING,68,6466419.4,1852579.7 4273751801,2016-01-19T00:00:00,1900,,,CA,201509,,VOLK,PA,GY,5151 RALEIGH ST,00401,54,5204A-,DISPLAY OF TABS,25,6466392.3,1852579.7 4273751812,2016-01-19T00:00:00,1923,37,,CA,201609,,CHRY,PA,SL,1438 LAUREL AVE N,00401,54,80.58L,PREFERENTIAL PARKING,68,6451326.6,1857995.9 4273751823,2016-01-19T00:00:00,1931,37,,PA,201604,,TOYT,TK,GY,7570 DE LONGPRE AVE,00401,54,80.58L,PREFERENTIAL PARKING,68,6454359.1,1857576.9 4273751834,2016-01-19T00:00:00,1934,37,,AZ,,,GMC,TK,WT,7568 DE LONGPRE AVE,00401,54,80.58L,PREFERENTIAL PARKING,68,6454371.4,1857576.8 4273751845,2016-01-19T00:00:00,1957,80,,CA,201604,,TOYT,PA,WT,849 HELIOTROPE DR,00401,54,80.58L,PREFERENTIAL PARKING,68,6472357.6,1854136.5 4273751856,2016-01-19T00:00:00,2000,80,,CA,201604,,FORD,TK,GO,757 HELIOTROPE DR,00401,54,80.58L,PREFERENTIAL PARKING,68,6472357.7,1853394.6 4273751860,2016-01-19T00:00:00,2003,80,,CA,201609,,TOYT,TT,RD,737 HELIOTROPE DR,00401,54,80.58L,PREFERENTIAL PARKING,68,6472357.6,1853229 4273751871,2016-01-19T00:00:00,2009,80,,CA,201508,,MAZD,PA,GY,653 BERENDO ST N,00401,54,80.58L,PREFERENTIAL PARKING,68,6472581.4,1844963.7 4273751882,2016-01-19T00:00:00,2009,,,CA,201508,,MAZD,PA,GY,653 BERENDO ST N,00401,54,5204A-,DISPLAY OF TABS,25,6472581.4,1844963.7 4273751893,2016-01-19T00:00:00,2010,80,,CT,,,NISS,PA,BK,638 BERENDO ST N,00401,54,80.58L,PREFERENTIAL PARKING,68,6472581.7,1845146.9 4273751904,2016-01-19T00:00:00,2014,80,,CA,201609,,GMC,TK,GY,633 BERENDO ST N,00401,54,80.58L,PREFERENTIAL PARKING,68,6472581.7,1845207.6 4273751941,2016-01-19T00:00:00,2131,,,CA,201606,,DODG,PA,BK,4060 6TH ST W,00401,54,80.69A+,STOP/STAND PROHIBIT,93,6467221.2,1845643.8 4273751952,2016-01-19T00:00:00,2132,,,CA,201601,,HYUN,PA,WT,4060 6TH ST W,00401,54,80.69A+,STOP/STAND PROHIBIT,93,6467221.2,1845643.8 4273751963,2016-01-19T00:00:00,2133,,,CA,201605,,HYUN,PA,BK,4060 6TH ST W,00401,54,80.69A+,STOP/STAND PROHIBIT,93,6467221.2,1845643.8 4273751974,2016-01-19T00:00:00,2141,,,NJ,201607,,CHEV,PA,BL,791 SERRANO AVE S,00401,54,80.56E1,WHITE ZONE,58,6468806.9,1843571.9 4273751985,2016-01-19T00:00:00,2148,,,CA,201611,,LEXS,TK,GY,548 KINGSLEY DR S,00401,54,80.56E1,WHITE ZONE,58,6469786.5,1852116.7 4273751996,2016-01-19T00:00:00,2300,,,CA,201611,,LEXS,PA,BK,3191 4TH ST W,00401,54,80.69B,NO PARKING,73,6474158.3,1846888.7 4273752000,2016-01-19T00:00:00,2312,,,CA,,,HOND,PA,BL,133 NEW HAMPSHIRE AVE N,00401,54,22514,FIRE HYDRANT,68,6472951.7,1849188 4273780906,2016-01-19T00:00:00,851,,,CA,201612,,HYUN,PA,WT,9950 WHITE OAK AVE,00387,53,80.69B,NO PARKING,73,6404577.7,1914202.9 4273780910,2016-01-19T00:00:00,1331,03,,CA,201601,,HYUN,PA,GY,8150 DARBY PL,00387,53,80.58L,PREFERENTIAL PARKING,68,6400661.3,1902350 4273780921,2016-01-19T00:00:00,1336,03,,CA,201601,,NISS,PA,GN,8144 DARBY AVE,00387,53,80.58L,PREFERENTIAL PARKING,68,6400407.3,1902318.8 4273780932,2016-01-19T00:00:00,1434,03,,CA,201609,,MAZD,PA,WT,8145 ETIWANDA AVE,00387,53,80.58L,PREFERENTIAL PARKING,68,6400918,1902284.4 4273780943,2016-01-19T00:00:00,1506,,,CA,201602,,BMW,PA,GN,10520 BALBOA BLVD,00387,53,80.70,NO STOPPING/ANTI-GRI,163,6409897.4,1917987.3 4273780954,2016-01-19T00:00:00,1509,,,CA,201605,,TOYT,PA,SL,10540 BALBOA BLVD,00387,53,80.70,NO STOPPING/ANTI-GRI,163,6409898.1,1918051.5 4273780965,2016-01-19T00:00:00,1516,,,CA,201603,,TOYT,PA,GY,17030 SAN JOSE ST,00387,53,80.69A+,STOP/STAND PROHIBIT,93,6409233.5,1917805.3 4273780976,2016-01-19T00:00:00,1517,,,CA,201608,,INFI,PA,GO,17030 SAN JOSE ST,00387,53,80.69A+,STOP/STAND PROHIBIT,93,6409233.5,1917805.3 4273792681,2016-01-19T00:00:00,1646,,,CA,,,GRUM,CM,BN,16030 VENTURA BOULEVARD,00310,53,80.70,NO STOPPING/ANTI-GRI,163,6415813.8,1879562.3 4273792692,2016-01-19T00:00:00,1656,,,CA,201511,,FORD,PU,RD,16446 MOORPARK ST,00310,53,80.69B,NO PARKING,73,6412958.8,1880510 4273792703,2016-01-19T00:00:00,1658,,,CA,201511,,FORD,PU,RD,16446 MOORPARK ST,00310,53,5204A-,DISPLAY OF TABS,25,6412958.8,1880510 4273792714,2016-01-19T00:00:00,1713,EN413,,CA,201608,,NISS,PA,BK,17401 VENTURA BL,00310,53,88.13B+,METER EXP.,63,6406913.6,1881408.4 4273792725,2016-01-19T00:00:00,1741,R258,,CA,201607,,VOLK,PA,BK,18336 SHERMAN WAY,00310,53,88.13B+,METER EXP.,63,6400700.3,1895981.3 4273792736,2016-01-19T00:00:00,1744,R255,,CA,201511,,HOND,PA,SL,18344 SHERMAN WAY,00310,53,88.13B+,METER EXP.,63,6400655.3,1895981.5 4273792740,2016-01-19T00:00:00,1746,,,CA,201511,,HOND,PA,SL,18344 SHERMAN WAY,00310,53,5204A-,DISPLAY OF TABS,25,6400655.3,1895981.5 4273792751,2016-01-19T00:00:00,1747,,,CA,201508,,SUBA,PA,BK,18340 SHERMAN WAY,00310,53,5204A-,DISPLAY OF TABS,25,6400677.8,1895981.4 4273792762,2016-01-19T00:00:00,1752,R268,,CA,201606,,FORD,PA,SL,18308 SHERMAN WAY,00310,53,88.13B+,METER EXP.,63,6400856.4,1895967.8 4273792773,2016-01-19T00:00:00,1848,TZ410,,CA,201607,,HOND,PA,SL,19000 VENTURA BL,00310,53,88.13B+,METER EXP.,63,6396076,1885607.3 4273792784,2016-01-19T00:00:00,1903,TZ518,,CA,201612,,LEXS,PA,WT,5400 AMIGO AV,00310,53,88.13B+,METER EXP.,63,6398675,1883984.9 4273792795,2016-01-19T00:00:00,1921,EN644,,CA,201702,,TOYT,PA,SL,17614 VENTURA BL,00310,53,88.13B+,METER EXP.,63,6405310.1,1881733.5 4273792806,2016-01-19T00:00:00,1925,EN711,,CA,201611,,GMC,PA,BK,17340 VENTURA BL,00310,53,88.13B+,METER EXP.,63,6407226,1881352.3 4273792810,2016-01-19T00:00:00,1928,EN720,,CA,201606,,JEEP,PA,SL,17300 VENTURA BL,00310,53,88.13B+,METER EXP.,63,6407441.4,1881313.6 4273792865,2016-01-19T00:00:00,2102,,,CA,201610,,TOYT,PA,WT,7300 HASKELL AVE,00310,53,80.56E4+,RED ZONE,93,6418064.6,1896596.2 4273792876,2016-01-19T00:00:00,2125,,,CA,201607,,FRHT,CM,WT,17512 ROSCOE BOULEVARD,00310,53,80.69.2,COMM VEH OVER TIME L,133,6405969.7,1903220 4273792902,2016-01-19T00:00:00,2250,,,CA,201511,,NISS,PA,WT,16812 SHERMAN WAY,00310,53,5204A-,DISPLAY OF TABS,25,6410719.9,1895918.8 4273792913,2016-01-19T00:00:00,2311,,,CA,201611,,HOND,PA,RD,7900 HASKELL AVENUE,00310,53,80.69AP+,NO STOP/STANDING,93,6418080.8,1900598.2 4273792924,2016-01-19T00:00:00,2313,,,CA,201611,,HOND,PA,RD,7900 HASKELL AVENUE,00310,53,5204A-,DISPLAY OF TABS,25,6418080.8,1900598.2 4273796575,2016-01-19T00:00:00,121,,,CA,201610,,HOND,PA,SL,901 SOUTH FLOWER STREET,00611,56,80.56E1,WHITE ZONE,58,6482467,1839158.9 4273796586,2016-01-19T00:00:00,134,,,CA,201612,,MERZ,PA,GY,1348 INGRAHAM STREET,00611,56,80.56E4+,RED ZONE,93,6480431.3,1841971 4273796590,2016-01-19T00:00:00,142,,,CA,201604,,MERC,PA,WT,2019 8TH ST W,00611,56,80.69B,NO PARKING,73,6477803.4,1842311.9 4273796601,2016-01-19T00:00:00,159,,,MI,201603,,HOND,PA,BK,2121 11TH ST W,00611,56,80.56E1,WHITE ZONE,58,6490569.2,1831439.4 4273796741,2016-01-19T00:00:00,2222,,,CA,201610,,VOLK,PA,BK,612 FLOWER ST S,00611,56,80.56E1,WHITE ZONE,58,6483524.6,1840515.4 4273796752,2016-01-19T00:00:00,2228,,,CA,201608,,NISS,PA,BK,810 FLOWER ST S,00611,56,80.56E1,WHITE ZONE,58,6420304.2,1823051 4273796763,2016-01-19T00:00:00,2235,,,CA,201601,,SMRT,PA,BK,810 FLOWER ST S,00611,56,80.56E1,WHITE ZONE,58,6420304.2,1823051 4273796774,2016-01-19T00:00:00,2239,,,CA,201605,,HYUN,PA,RD,901 FLOWER ST S,00611,56,80.56E1,WHITE ZONE,58,6482467,1839158.9 4273796785,2016-01-19T00:00:00,2247,,,CA,201603,,DODG,PA,SL,1325 INGRAHAM STREET,00611,56,80.61,STANDNG IN ALLEY,68,6480684.1,1841833.2 4273796796,2016-01-19T00:00:00,2251,,,CA,201611,,BMW,PA,BL,1325 INGRAHAM STREET,00611,56,80.61,STANDNG IN ALLEY,68,6480684.1,1841833.2 4273796800,2016-01-19T00:00:00,2254,,,CA,201701,,TOYT,PA,TN,1325 INGRAHAM STREET,00611,56,80.61,STANDNG IN ALLEY,68,6480684.1,1841833.2 4273796811,2016-01-19T00:00:00,2301,,,CA,201602,,GMC,VN,MR,2119 WEST 8TH STREET,00611,56,80.69B,NO PARKING,73,6490388.4,1833194.5 4273796822,2016-01-19T00:00:00,2308,,,CA,201610,,TOYT,PU,WT,820 SOUTH ALVARADO STREET,00611,56,80.69B,NO PARKING,73,6481366.5,1849715.9 4273796833,2016-01-19T00:00:00,2316,,,CA,,,HOND,PA,GY,2500 SAN MARINO STREET,00611,56,80.56E4+,RED ZONE,93,6475771.9,1842310.4 4273796844,2016-01-19T00:00:00,2324,,,MI,201603,,HOND,PA,BK,2121 11TH ST W,00611,56,80.56E1,WHITE ZONE,58,6490569.2,1831439.4 4273809330,2016-01-19T00:00:00,58,,,IN,,,FRHT,TK,OR,8100 HASKELL AVENUE,00300,53,80.69B,NO PARKING,73,6418087.5,1902113.7 4273809341,2016-01-19T00:00:00,112,,,MN,201606,,CHRY,PA,WT,6555 HAYVENHURST AVENUE,00300,53,22514,FIRE HYDRANT,68,6412765.1,1891989.3 4273809352,2016-01-19T00:00:00,123,,,CA,201611,,TOYT,PU,GY,6666 DARBY AVENUE,00300,53,80.56E4+,RED ZONE,93,6400337.5,1892477.7 4273809363,2016-01-19T00:00:00,129,,,CA,201608,,BMW,PA,BL,7124 BAIRD AVENUE,00300,53,80.69B,NO PARKING,73,6399189.1,1895501.2 4273809374,2016-01-19T00:00:00,131,,,CA,201608,,BMW,PA,WT,7124 BAIRD AVENUE,00300,53,80.69B,NO PARKING,73,6399189.1,1895501.2 4273809385,2016-01-19T00:00:00,134,,,CA,201611,,JEEP,PA,GY,7220 BAIRD AVENUE,00300,53,80.69B,NO PARKING,73,6399191.6,1896125.1 4273809396,2016-01-19T00:00:00,217,,,CA,201603,,FORD,PA,GY,15555 ROSCOE BOULEVARD,00300,53,80.69A+,STOP/STAND PROHIBIT,93,6419250,1903286.9 4273809400,2016-01-19T00:00:00,219,,,CA,201601,,TOYT,PA,SL,15555 ROSCOE BOULEVARD,00300,53,80.69A+,STOP/STAND PROHIBIT,93,6419250,1903286.9 4273809411,2016-01-19T00:00:00,222,,,CA,201606,,TOYT,PA,WT,15555 ROSCOE BOULEVARD,00300,53,80.69A+,STOP/STAND PROHIBIT,93,6419250,1903286.9 4273809422,2016-01-19T00:00:00,237,,,CA,,,HOND,PA,WT,8700 TOBIAS AVENUE,00300,53,80.69A+,STOP/STAND PROHIBIT,93,6425144.2,1905648.5 4273809433,2016-01-19T00:00:00,319,,,CA,201612,,NISS,VN,RD,7000 RADFORD AVENUE,00300,53,80.56E1,WHITE ZONE,58,6443087.2,1894511.5 4273809455,2016-01-19T00:00:00,330,,,CA,201603,,FORD,PA,WT,6923 HINDS AVENUE,00300,53,22514,FIRE HYDRANT,68,6443409.1,1894021.7 4273809466,2016-01-19T00:00:00,440,,,CA,201601,,MERZ,PA,WT,12020 RUNNYMEDE STREET,00300,53,22514,FIRE HYDRANT,68,6442297.8,1897489.2 4273809470,2016-01-19T00:00:00,611,,,CA,201510,,HOND,PA,RD,11901 HORTENSE ST,00300,53,22514,FIRE HYDRANT,68,6443019.3,1878961.8 4273809481,2016-01-19T00:00:00,634,,,CA,201606,,ACUR,PA,GN,6017 WHITSETT AVENUE,00300,53,80.56E4+,RED ZONE,93,6439099.7,1888026.5 4273809492,2016-01-19T00:00:00,714,,,CA,201509,,JEEP,PA,BK,7801 WOODMAN AVE,00300,53,80.69AA+,NO STOP/STAND,93,6431370.5,1899869.8 4273811426,2016-01-19T00:00:00,1127,,,CA,201604,,KIA,PA,RD,2716 HILL ST S,538C,55,80.56E2,YELLOW ZONE,58,6479376.6,1831472.8 4273811430,2016-01-19T00:00:00,1228,,1135,CA,,,HOND,PA,GY,727 27TH ST W,538C,55,80.69C,PARKED OVER TIME LIM,58,6472758.1,1720502 4273811441,2016-01-19T00:00:00,1230,,1135,CA,201611,,TOYT,PA,BK,727 27TH ST W,538C,55,80.69C,PARKED OVER TIME LIM,58,6472758.1,1720502 4273811452,2016-01-19T00:00:00,1231,,1135,CA,201611,,HOND,PA,RD,727 27TH ST W,538C,55,80.69C,PARKED OVER TIME LIM,58,6472758.1,1720502 4273811463,2016-01-19T00:00:00,1242,,,CA,201611,,UNK,TK,WT,3110 ORCHARD AVE,538C,55,80.69.2,COMM VEH OVER TIME L,78,6474336.2,1832291.7 4273811474,2016-01-19T00:00:00,1250,,,CA,201509,,VOLK,PA,WT,1170 31ST ST W,538C,55,80.56E4+,RED ZONE,93,6469881.9,1720202.5 4273811485,2016-01-19T00:00:00,1252,,,CA,201606,,CADI,PA,BK,1170 31ST ST W,538C,55,80.56E4+,RED ZONE,93,6469881.9,1720202.5 4273817273,2016-01-15T00:00:00,808,,,CA,201609,,TOYT,PA,BK,1012 ALEXANDRIA AVE N,00460,54,80.69B,NO PARKING,73,6471480.7,1855180.4 4273817284,2016-01-15T00:00:00,811,,,CA,201609,,DODG,PA,BK,1042 ALEXANDRIA AVE N,00460,54,80.69B,NO PARKING,73,6471480.6,1855317.5 4273817376,2016-01-15T00:00:00,1218,,,CA,201603,,HOND,PA,BK,845 CARONDELET ST S,00460,54,80.69BS,NO PARK/STREET CLEAN,73,6476101.4,1842919.1 4273817380,2016-01-15T00:00:00,1229,,,CA,201604,,HOND,PA,GY,675 PARK VIEW ST S,00460,54,80.69BS,NO PARK/STREET CLEAN,73,6477002.7,1844208.4 4273839883,2016-01-19T00:00:00,635,,,CA,201701,,VOLK,PA,GY,11133 CHARNOCK ROAD,00112,51,80.56E1,WHITE ZONE,58,6434431.4,1828861.6 4273839894,2016-01-19T00:00:00,637,,,CA,,,MASE,PA,GY,11133 CHARNOCK ROAD,00112,51,80.56E1,WHITE ZONE,58,6434431.4,1828861.6 4273839905,2016-01-19T00:00:00,638,,,CA,201604,,AUDI,PA,GY,11133 CHARNOCK ROAD,00112,51,80.56E1,WHITE ZONE,58,6434431.4,1828861.6 4273839916,2016-01-19T00:00:00,639,,,CA,201604,,AUDI,PA,GY,11133 CHARNOCK ROAD,00112,51,5200,DISPLAY OF PLATES,25,6434431.4,1828861.6 4273839920,2016-01-19T00:00:00,640,,,CA,201601,,MITS,PA,WT,11133 CHARNOCK ROAD,00112,51,80.56E1,WHITE ZONE,58,6434431.4,1828861.6 4273839931,2016-01-19T00:00:00,708,,,CA,201606,,VOLV,PA,BK,10726 MCCUNE AVE,00112,51,5200,DISPLAY OF PLATES,25,6437718.9,1829710.6 4273845214,2016-01-19T00:00:00,1153,,,CA,201505,,GMC,PA,BK,636 HILL PL,6T4,56,5204A-,DISPLAY OF TABS,25,6488239.7,1844720.1 4273845225,2016-01-19T00:00:00,1218,,,CA,1,,OTHR,TK,BN,900 2ND ST E,6T4,56,80.56E4+,RED ZONE,93,6484996.4,1843058 4273845236,2016-01-19T00:00:00,1458,,,CA,7,,OTHR,VN,WT,351 TEMPLE ST E,6T4,56,80.56E4+,RED ZONE,93,6487748,1842892.3 4273845240,2016-01-19T00:00:00,1501,,,CA,7,,OTHR,VN,WT,351 TEMPLE ST E,6T4,56,80.56E4+,RED ZONE,93,6487748,1842892.3 4273845251,2016-01-19T00:00:00,1520,,,CA,2,,OTHR,TK,BN,1055 WILSHIRE BLVD,6T4,56,80.56E4+,RED ZONE,93,6482104.9,1841419.8 4273845262,2016-01-19T00:00:00,1605,,,CA,201607,,CHRY,PA,BL,1111 6TH ST W,6T4,56,80.69AP+,NO STOP/STANDING,93,6482219,1842183.2 4273845273,2016-01-19T00:00:00,1650,,,CA,201512,,MERZ,PA,BL,1665 BEVERLY BLVD,6T4,56,80.69AP+,NO STOP/STANDING,93,6481443.6,1845863.4 4273845284,2016-01-19T00:00:00,1652,,,CA,201512,,MERZ,PA,BL,1665 BEVERLY BLVD,6T4,56,5200,DISPLAY OF PLATES,25,6481443.6,1845863.4 4273845295,2016-01-19T00:00:00,1701,,,CA,1,,OTHR,TK,BN,1801 BEVERLY BLVD,6T4,56,80.69AP+,NO STOP/STANDING,93,6480801.4,1846213.1 4273869515,2016-01-19T00:00:00,1518,,,CA,201603,,TOYT,PA,BK,11333 SEPULVEDA BLVD,00393,53,22507.8A,DISABLED PARKING/NO,363,6420086.1,1923980.6 4273873516,2016-01-19T00:00:00,735,,,CA,201510,,VOLK,PA,GN,109 SOUTH HOBART BOULEVARD,57B,57,5204A-,DISPLAY OF TABS,25,6469149.4,1849271.9 4273879455,2016-01-19T00:00:00,1238,WS813,,CA,201603,,BMW,PA,BK,11100 MISSOURI AV,00907,51,88.13B+,METER EXP.,63,6427729.8,1838755.8 4273879466,2016-01-19T00:00:00,1258,WS557,,CA,201511,,NISS,PA,BK,10901 ASHTON AV,00907,51,88.13B+,METER EXP.,63,6427412.6,1843717.8 4273879470,2016-01-19T00:00:00,1259,,,CA,201511,,NISS,PA,BK,10901 ASHTON AV,00907,51,5204A-,DISPLAY OF TABS,25,6427412.6,1843717.8 4273879481,2016-01-19T00:00:00,1542,V70,,NV,,,HOND,PA,BN,0 NORTH VENICE BL,00907,51,88.13B+,METER EXP.,63,6418770.8,1816984 4273895894,2016-01-19T00:00:00,827,,,CA,,,OTHR,PA,BK,2800 GARNET ST,00631,56,80.73.2,EXCEED 72HRS-ST,68,6497152.5,1832510.2 4273895905,2016-01-19T00:00:00,858,,,CA,201607,,FORD,PA,BL,215 CUMMINGS ST,00631,56,80.73.2,EXCEED 72HRS-ST,68,6496346.5,1838622.6 4273895916,2016-01-19T00:00:00,901,,,CA,201602,,JEEP,PA,BK,215 CUMMINGS ST,00631,56,80.73.2,EXCEED 72HRS-ST,68,6496346.5,1838622.6 4273895920,2016-01-19T00:00:00,904,,,CA,201603,,OLDS,PA,GY,215 CUMMINGS ST,00631,56,80.73.2,EXCEED 72HRS-ST,68,6496346.5,1838622.6 4273895931,2016-01-19T00:00:00,908,,,CA,201507,,CHEV,PA,WT,215 CUMMINGS ST,00631,56,80.73.2,EXCEED 72HRS-ST,68,6496346.5,1838622.6 4273895942,2016-01-19T00:00:00,911,,,CA,201602,,GEO,PA,GY,215 CUMMINGS ST,00631,56,80.73.2,EXCEED 72HRS-ST,68,6496346.5,1838622.6 4273895953,2016-01-19T00:00:00,915,,,CA,,,CHEV,PA,GY,215 CUMMINGS ST,00631,56,80.73.2,EXCEED 72HRS-ST,68,6496346.5,1838622.6 4273895964,2016-01-19T00:00:00,1011,,,CA,201608,,TOYT,PA,GY,100 BREED ST,00631,56,80.69BS,NO PARK/STREET CLEAN,73,6497739.2,1838558.9 4273895975,2016-01-19T00:00:00,1014,,,CA,201604,,HOND,PA,RD,2221 MICHIGAN AVE,00631,56,80.69BS,NO PARK/STREET CLEAN,73,6497713,1839202.7 4273895986,2016-01-19T00:00:00,1017,,,CA,201511,,JEEP,PA,WT,151 CHICAGO ST,00631,56,80.69BS,NO PARK/STREET CLEAN,73,6497192.2,1838428.8 4273895990,2016-01-19T00:00:00,1018,,,CA,201609,,HOND,PA,GN,151 CHICAGO ST,00631,56,80.69BS,NO PARK/STREET CLEAN,73,6497192.2,1838428.8 4273911036,2016-01-19T00:00:00,1053,SG180,,CA,,,BMW,PA,RD,7901 SUNSET BL,00483,54,88.13B+,METER EXP.,63,6452207.2,1858262.8 4273911040,2016-01-19T00:00:00,1058,SG207A,,CA,201607,,CHEV,PA,RD,7950 SUNSET BLVD,00483,54,88.13B+,METER EXP.,63,6451992.3,1858259.6 4273911051,2016-01-19T00:00:00,1114,,,CA,201604,,FORD,PU,GY,1148 NORTH MCCADDEN PLACE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6459498.5,1855898.3 4273911062,2016-01-19T00:00:00,1125,SV412A,,IL,201602,,NISS,PA,GY,1200 VINE ST,00483,54,88.13B+,METER EXP.,63,6462773.7,1856224.3 4273911073,2016-01-19T00:00:00,1141,SG22,,TX,201507,,AUDI,PA,WT,7501 SUNSET BL,00483,54,88.13B+,METER EXP.,63,6454848.3,1858242.1 4273911084,2016-01-19T00:00:00,1143,,,CA,201609,,CHEV,PA,RD,7501 W HAWTHORN AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6454848.1,1858900.8 4273911095,2016-01-19T00:00:00,1200,SV187,,CA,,,TOYT,PA,SL,6700 SUNSET BL,00483,54,88.13B+,METER EXP.,63,6459767.8,1858208.5 4273911106,2016-01-19T00:00:00,1206,SV286,,CA,201609,,HOND,PA,GY,1401 IVAR AV,00483,54,88.13B+,METER EXP.,63,6462120.7,1857542 4273911110,2016-01-19T00:00:00,1253,WW1392C,,CA,201612,,INFI,PA,MR,4800 ROSEWOOD AV,00483,54,88.13B+,METER EXP.,63,6468048.5,1851386.8 4273911121,2016-01-19T00:00:00,1315,SH3,,OH,201601,,TOYT,PA,WT,6201 SANTA MONICA BL,00483,54,88.13B+,METER EXP.,63,6463434,1855564.2 4273911132,2016-01-19T00:00:00,1327,SG1,,CA,201610,,TOYT,PU,GY,7401 SUNSET BL,00483,54,88.13B+,METER EXP.,63,6455403.8,1858235.4 4273911143,2016-01-19T00:00:00,1341,SG68,,CA,201604,,TOYT,PA,SL,7500 SUNSET BL,00483,54,88.13B+,METER EXP.,63,6454848.3,1858242.1 4273911154,2016-01-19T00:00:00,1345,SG16190,,CA,201702,,TOYT,PA,WT,1451 GARDNER ST N,00483,54,88.13B+,METER EXP.,63,6454848.1,1857913.4 4273911165,2016-01-19T00:00:00,1451,SV181,,CA,201612,,CADI,PA,BK,6701 SUNSET BL,00483,54,88.13B+,METER EXP.,63,6459850.1,1858208.2 4273911176,2016-01-19T00:00:00,1516,SH101,,IL,201607,,INFI,PA,SL,1100 MCCADDEN PL N,00483,54,88.13B+,METER EXP.,63,6459499.5,1855565.9 4273911180,2016-01-19T00:00:00,1521,SH206,,CA,201604,,HYUN,PA,GY,6900 SANTA MONICA BL,00483,54,88.13B+,METER EXP.,63,6458592.4,1855566.4 4273911191,2016-01-19T00:00:00,1551,HO590,,CA,201512,,CADI,PA,BK,1700 WILCOX AV,00483,54,88.13B+,METER EXP.,63,6461453.8,1857874.1 4273911202,2016-01-19T00:00:00,1558,SV93,,CA,201606,,TOYT,PA,BL,1501 WILCOX AV,00483,54,88.13B+,METER EXP.,63,6461453.8,1857650.9 4273911213,2016-01-19T00:00:00,1611,,,CA,201602,,ACUR,PA,GY,7181 SUNSET BOULEVARD,00483,54,80.70,NO STOPPING/ANTI-GRI,163,6456775.7,1858219.5 4273939600,2016-01-19T00:00:00,2251,,,CA,201609,,MAZD,PA,WT,733 GARLAND AVE,00611,56,80.56E1,WHITE ZONE,58,6480826.9,1840992.8 4273939611,2016-01-19T00:00:00,2252,,,CA,201610,,HOND,PA,WT,733 GARLAND AVE,00611,56,80.56E1,WHITE ZONE,58,6480826.9,1840992.8 4273939622,2016-01-19T00:00:00,2255,,,CA,201604,,NISS,PA,GY,749 GARLAND AVE,00611,56,80.69B,NO PARKING,73,6480768.2,1840884.7 4273941361,2016-01-19T00:00:00,1113,WP67,,CA,201606,,NISS,PA,WT,124 WASHINGTON BL W,00308,51,88.13B+,METER EXP.,63,6420637.7,1815430.6 4273941372,2016-01-19T00:00:00,1122,,,CA,201609,,CHRY,PA,BK,1700 PACIFIC AVE S,00308,51,80.69AP+,NO STOP/STANDING,93,6418647.5,1818049.4 4273941383,2016-01-19T00:00:00,1138,,,CA,201604,,LNDR,PA,BK,32 WINDWARD AVE E,00308,51,80.69BS,NO PARK/STREET CLEAN,73,6418252,1818052.8 4273941394,2016-01-19T00:00:00,1146,,,CA,201607,,HOND,PA,SL,1902 PACIFIC AVE S,00308,51,80.69BS,NO PARK/STREET CLEAN,73,6418918.4,1817636 4273941405,2016-01-19T00:00:00,1149,,,CA,201609,,HOND,PA,SL,1902 PACIFIC AVE S,00308,51,80.69BS,NO PARK/STREET CLEAN,73,6418918.4,1817636 4273941416,2016-01-19T00:00:00,1151,,,CA,201608,,FORD,PA,RD,1904 PACIFIC AVE S,00308,51,80.69BS,NO PARK/STREET CLEAN,73,6418934.5,1817611.3 4273941431,2016-01-19T00:00:00,1302,WP162,,CA,201605,,LEXS,PA,TU,3000 DELL AV,00308,51,88.13B+,METER EXP.,63,6421004.7,1816011.8 4273941442,2016-01-19T00:00:00,1307,WP1,,CA,,,BMW,PA,SL,339 WASHINGTON BL W,00308,51,88.13B+,METER EXP.,63,6420991.6,1815686.3 4273941453,2016-01-19T00:00:00,1311,,,CA,201610,,KIA,PA,GY,100 NORTH VENICE BLVD E,00308,51,22500B,PARKED IN CROSSWALK,68,6419161.3,1817265.6 4273941464,2016-01-19T00:00:00,1413,W52,,CA,201609,,TOYT,PA,GY,6100 98TH ST W,00308,51,88.13B+,METER EXP.,63,6442475.2,1803451.2 4273941475,2016-01-19T00:00:00,1424,W109,,CA,201610,,PORS,PA,WT,5901 98TH ST W,00308,51,88.13B+,METER EXP.,63,6444605.4,1803444.3 4273941486,2016-01-19T00:00:00,1434,W86,,CA,201604,,NISS,PA,RD,5901 98TH ST W,00308,51,88.13B+,METER EXP.,63,6444605.4,1803444.3 4273941501,2016-01-19T00:00:00,1752,MV182,,CA,201608,,OTHR,PA,BK,3827 GRAND VIEW BL,00308,51,88.13B+,METER EXP.,63,6431137.9,1824192.1 4273941512,2016-01-19T00:00:00,1754,MV178A,,CA,201602,,SAA,PA,BK,3823 GRAND VIEW BL,00308,51,88.13B+,METER EXP.,63,6431109.2,1824237.9 4273951916,2016-01-19T00:00:00,858,,,CA,201510,,MAZD,PA,GY,701 JACKSON ST,00662,56,5204A-,DISPLAY OF TABS,25,6490969.4,1841063.1 4273951920,2016-01-19T00:00:00,901,,,CA,,,OTHR,TK,WT,901 2ND ST E,00662,56,22500H,DOUBLE PARKING,68,6484596.1,1843373.1 4273951931,2016-01-19T00:00:00,904,,,CA,,,BMW,PA,WT,901 2ND ST E,00662,56,80.56E4+,RED ZONE,93,6484596.1,1843373.1 4273951942,2016-01-19T00:00:00,916,CB2498,,CA,,,DODG,PA,BL,600 WALL ST S,00662,56,88.13B+,METER EXP.,63,6486805,1838292.7 4273951953,2016-01-19T00:00:00,919,CB2573,,CA,201601,,NISS,PA,BL,700 WALL ST S,00662,56,88.13B+,METER EXP.,63,6486375.3,1837737.7 4273951964,2016-01-19T00:00:00,925,CB2223A,,CA,201512,,TOYT,PA,SL,700 SAN JULIAN ST S,00662,56,88.13B+,METER EXP.,63,6486038.3,1836821.4 4273951975,2016-01-19T00:00:00,928,,,CA,201509,,NISS,PA,SL,501 8TH ST E,00662,56,5204A-,DISPLAY OF TABS,25,6483852.6,1838917.3 4273951986,2016-01-19T00:00:00,1007,CB3927F,,CA,201512,,TOYT,PU,GY,800 CECILIA ST,00662,56,88.13B+,METER EXP.,63,6485688.4,1837215.7 4273951990,2016-01-19T00:00:00,1014,,,CA,9,,OTHR,TK,BN,316 9TH ST E,00662,56,80.56E4+,RED ZONE,93,6483610.4,1838265.8 4273952001,2016-01-19T00:00:00,1020,,,CA,201512,,FRHT,TK,WT,840 SANTEE ST S,00662,56,80.56E2,YELLOW ZONE,58,6485214.1,1837328.7 4273952012,2016-01-19T00:00:00,1030,,,IN,,,FRHT,TK,WT,766 SAN JULIAN ST S,00662,56,80.56E4+,RED ZONE,93,6486694,1837467.9 4273952023,2016-01-19T00:00:00,1051,CB654,,CA,201608,,TOYT,PA,WT,801 WALL ST S,00662,56,88.13B+,METER EXP.,63,6485807.2,1837081.8 4273952034,2016-01-19T00:00:00,1101,CB2572,,CA,201608,,AUDI,PA,BK,700 WALL ST S,00662,56,88.13B+,METER EXP.,63,6486375.3,1837737.7 4273952045,2016-01-19T00:00:00,1121,,,CA,1,,TOYT,PU,GO,345 4TH ST E,00662,56,5204A-,DISPLAY OF TABS,25,6485985.2,1840612.3 4273952056,2016-01-19T00:00:00,1136,,,CA,201610,,HOND,PA,SL,330 OMAR AVE,00662,56,80.56E2,YELLOW ZONE,58,6488417.9,1839157.7 4273952060,2016-01-19T00:00:00,1140,,,CA,11,,OTHR,TK,BN,323 BOYD ST,00662,56,22502A,18 IN. CURB/2 WAY,63,6487783.7,1839605 4273952071,2016-01-19T00:00:00,1145,LT377,,CA,6,,GMC,TK,GN,300 WALL ST,00662,56,88.13B+,METER EXP.,63,6487816.3,1839925.3 4273952082,2016-01-19T00:00:00,1152,LT2,,CA,201607,,CHEV,PU,BL,200 BOYD ST,00662,56,88.13B+,METER EXP.,63,6487342.1,1839891.2 4273952093,2016-01-19T00:00:00,1153,,,CA,201607,,CHEV,PU,BL,200 BOYD ST,00662,56,5200,DISPLAY OF PLATES,25,6487342.1,1839891.2 4273952104,2016-01-19T00:00:00,1236,CB3927D,,CA,201604,,BMW,PA,BK,800 CECILIA ST,00662,56,88.13B+,METER EXP.,63,6485688.4,1837215.7 4273952115,2016-01-19T00:00:00,1352,CB652A,,CA,201605,,HYUN,PA,BK,801 WALL ST S,00662,56,88.03A,OUTSIDE LINES/METER,58,6485807.2,1837081.8 4273952126,2016-01-19T00:00:00,1359,CB690,,CA,201606,,CHEV,PA,BL,800 MAPLE AVE S,00662,56,88.13B+,METER EXP.,63,6485579.1,1837339.3 4273952130,2016-01-19T00:00:00,1401,CB721,,CA,201509,,HOND,PA,SL,801 MAPLE AVE S,00662,56,88.13B+,METER EXP.,63,6485579.1,1837339.3 4273952141,2016-01-19T00:00:00,1559,,,CA,201510,,VOLK,PA,BL,326 BOYD ST,00662,56,5204A-,DISPLAY OF TABS,25,6487802.5,1839597.3 4273956035,2016-01-19T00:00:00,1907,CS110,,CA,201603,,DODG,VN,GN,5300 CRENSHAW BL,00500,55,88.13B+,METER EXP.,63,6461428.2,1820714.7 4273956046,2016-01-19T00:00:00,1915,LP236,,CA,201701,,CHEV,TK,SL,3301 43RD ST W,00500,55,88.13B+,METER EXP.,63,6461774.3,1824481.2 4273966970,2016-01-19T00:00:00,1112,L176,,CA,201606,,HYUN,PA,BN,402 LARCHMONT BL N,00483,54,88.13B+,METER EXP.,63,6463661,1850787.4 4273966981,2016-01-19T00:00:00,1209,L75,,CA,201601,,BUIC,PA,BG,113 LARCHMONT BL N,00483,54,88.13B+,METER EXP.,63,6463690,1849029.7 4273966992,2016-01-19T00:00:00,1211,L82,,CA,,,MERZ,PA,WT,101 LARCHMONT BL N,00483,54,88.13B+,METER EXP.,63,6463690,1849114.3 4273967003,2016-01-19T00:00:00,1352,L16940,,CA,201610,,MNNI,PA,SL,209 LARCHMONT BLVD N,00483,54,88.13B+,METER EXP.,63,6463689.9,1848358.5 4273967025,2016-01-19T00:00:00,1420,LM781,,CA,201603,,MAZD,PA,GN,524 LA BREA AV N,00483,54,88.13B+,METER EXP.,63,6457476.8,1846450.3 4273967036,2016-01-19T00:00:00,1428,LM172,,CA,,,VOLK,PA,SL,834 LA BREA AV N,00483,54,88.13B+,METER EXP.,63,6457234.2,1844463.8 4273967040,2016-01-19T00:00:00,1430,LM176,,CA,201608,,LEXS,PA,SL,800 LA BREA AV N,00483,54,88.13B+,METER EXP.,63,6457275.2,1844586.3 4273979452,2016-01-19T00:00:00,917,,,CA,201609,,GMC,PA,WT,1500 OLYMPIC BLVD,00644,56,80.56E4+,RED ZONE,93,6488177.7,1833632.6 4273979463,2016-01-19T00:00:00,933,,,CA,201504,,TOYT,PA,WT,1700 14TH ST,00644,56,5204A-,DISPLAY OF TABS,25,6477164.8,1838322.6 4273979474,2016-01-19T00:00:00,1005,,,CA,201604,,NISS,PA,GY,1200 MIRAMAR ST,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6483651.8,1843281.2 4273979485,2016-01-19T00:00:00,1006,,,CA,201608,,GMC,PA,WT,1200 MIRAMAR ST,00644,56,22500H,DOUBLE PARKING,68,6483651.8,1843281.2 4273979496,2016-01-19T00:00:00,1008,,,CA,201606,,FORD,PA,WT,1200 HUNTLEY DR,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6483811.4,1843590.7 4273979500,2016-01-19T00:00:00,1013,,,CA,201609,,GMC,PA,BN,1401 3RD ST,00644,56,80.56E4+,RED ZONE,93,6482432.2,1843701.4 4273979511,2016-01-19T00:00:00,1016,,,CA,201607,,GMC,PA,WT,300 BIXEL ST,00644,56,22500H,DOUBLE PARKING,68,6482975.5,1843425.6 4273979522,2016-01-19T00:00:00,1042,,,CA,201607,,GMC,PA,BN,600 WESTLAKE AVE,00644,56,80.56E4+,RED ZONE,93,6478786.1,1843963.7 4273979533,2016-01-19T00:00:00,1108,,,CA,201607,,GMC,PA,BN,600 BURLINGTON AVE,00644,56,80.56E4+,RED ZONE,93,6479446.3,1843607.4 4273979566,2016-01-19T00:00:00,1210,,,CA,201506,,CHEV,PA,WT,212 WESTLAKE AVE,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6479936,1845925.4 4273979570,2016-01-19T00:00:00,1211,,,CA,201506,,CHEV,PA,WT,212 WESTLAKE AVE,00644,56,5204A-,DISPLAY OF TABS,25,6479936,1845925.4 4273979581,2016-01-19T00:00:00,1213,,,CA,201606,,MAZD,PA,GY,200 BONNIE BRAE ST,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6480326,1845912.3 4273979592,2016-01-19T00:00:00,1215,,,CA,201605,,NISS,PA,BK,1831 MIRAMAR ST,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6480400.7,1845427.9 4273979603,2016-01-19T00:00:00,1217,,,CA,201605,,TOYT,PA,GN,1831 MIRAMAR ST,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6480400.7,1845427.9 4273979614,2016-01-19T00:00:00,1219,,,CA,201604,,HOND,PA,GY,264 BURLINGTON AVE,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6480302.4,1844952.7 4273979625,2016-01-19T00:00:00,1221,,,CA,201607,,CHEV,PA,BK,200 BURLINGTON AVE,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6480437.6,1845213.5 4273979640,2016-01-19T00:00:00,1359,,,CA,201611,,CHEV,PA,MR,415 BURLINGTON AVE S,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6479934.1,1844275.2 4273979651,2016-01-19T00:00:00,1401,,,CA,201606,,FORD,PA,GO,1821 MARYLAND ST,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6479804.7,1844226.4 4273979662,2016-01-19T00:00:00,1402,,,CA,201610,,TOYT,PA,OR,1821 MARYLAND ST,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6479804.7,1844226.4 4273979673,2016-01-19T00:00:00,1406,,,CA,201602,,TOYT,PA,SL,1800 5TH ST,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6479716.9,1843876.7 4273979684,2016-01-19T00:00:00,1407,,,CA,201604,,YAMA,MC,RD,1800 5TH ST,00644,56,80.69BS,NO PARK/STREET CLEAN,73,6479716.9,1843876.7 4273979695,2016-01-19T00:00:00,1517,,,CA,201609,,GMC,PA,WT,900 YALE ST,00644,56,80.56E4+,RED ZONE,93,6488994.2,1846080.4 4273980955,2016-01-19T00:00:00,1001,VS478,,CA,201607,,HOND,PA,SL,1301 EDGEMONT ST N,00441,54,88.13B+,METER EXP.,63,6472016.2,1857226.7 4273980966,2016-01-19T00:00:00,1026,,,CA,201612,,TOYT,PA,BL,4845 SUNSET BOULEVARD,00441,54,80.56E1,WHITE ZONE,58,6472377.4,1858229.1 4273980970,2016-01-19T00:00:00,1032,,,CA,201610,,TOYT,PA,WT,1300 NORTH VAN NESS AVENUE,00441,54,80.69BS,NO PARK/STREET CLEAN,73,6466070,1857002.8 4273980981,2016-01-19T00:00:00,1040,,,CA,201602,,DODG,PA,BL,6212 BANNER AVENUE,00441,54,80.69BS,NO PARK/STREET CLEAN,73,6463353.1,1855894.3 4273981003,2016-01-19T00:00:00,1049,,,CA,201605,,HYUN,PA,BK,1352 IVAR AVENUE,00441,54,80.69BS,NO PARK/STREET CLEAN,73,6462120.6,1857386.2 4273981014,2016-01-19T00:00:00,1050,,,CA,201604,,TOYT,PA,BK,1352 IVAR AVENUE,00441,54,80.69BS,NO PARK/STREET CLEAN,73,6462120.6,1857386.2 4273981025,2016-01-19T00:00:00,1051,,,CA,201608,,TOYT,PA,WT,1352 IVAR AVENUE,00441,54,80.69BS,NO PARK/STREET CLEAN,73,6462120.6,1857386.2 4273981036,2016-01-19T00:00:00,1101,,,CA,201608,,HOND,PA,BK,1345 WILCOX AVENUE,00441,54,80.69BS,NO PARK/STREET CLEAN,73,6461458.3,1857277.6 4273981040,2016-01-19T00:00:00,1116,VS475,,CA,201601,,ACUR,PA,GY,1300 EDGEMONT ST N,00441,54,88.13B+,METER EXP.,63,6472016.2,1857226.7 4273981051,2016-01-19T00:00:00,1121,,,CA,201611,,TOYT,PA,BL,4607 MAUBERT AVENUE,00441,54,5200,DISPLAY OF PLATES,25,6473957.9,1858569.9 4273981073,2016-01-19T00:00:00,1207,,1001,CA,201609,,HOND,PA,GY,1427 NORTH EDGEMONT STREET,00441,54,80.69C,PARKED OVER TIME LIM,58,6472017.1,1857865.3 4273981084,2016-01-19T00:00:00,1247,VS159A,,CA,201610,,SUBA,PA,GY,4501 SUNSET BL,00441,54,88.13B+,METER EXP.,63,6474660.3,1858230 4273981095,2016-01-19T00:00:00,1319,,,CA,201608,,VOLK,PA,WT,1075 NORTH MANSFIELD AVENUE,00441,54,80.69BS,NO PARK/STREET CLEAN,73,6458591.9,1855405.6 4273981106,2016-01-19T00:00:00,1321,,,CA,,,LEXS,PA,WT,1075 NORTH MANSFIELD AVENUE,00441,54,80.69BS,NO PARK/STREET CLEAN,73,6458591.9,1855405.6 4273981110,2016-01-19T00:00:00,1427,,,CA,201604,,MERZ,PA,GY,1017 NORTH LAS PALMAS AVENUE,00441,54,5200,DISPLAY OF PLATES,25,6459850.2,1855016.5 4273981132,2016-01-19T00:00:00,1443,,,CA,201512,,TOYT,PA,GY,5755 FOUNTAIN AVENUE,00441,54,80.56E1,WHITE ZONE,58,6466282.9,1857003.7 4273981143,2016-01-19T00:00:00,1454,,,CA,201610,,TOYT,PA,BK,1100 NEW HAMPSHIRE AVE N,00441,54,80.56E2,YELLOW ZONE,58,6473017.5,1855579.5 4273981154,2016-01-19T00:00:00,1710,,,CA,201701,,AUDI,PA,GY,914 COLE AVENUE,00441,54,5200,DISPLAY OF PLATES,25,6461785.7,1854340.7 4273985866,2016-01-19T00:00:00,807,,,CA,,,HOND,PA,TN,1010 RIDGEWOOD PL N,00443,54,80.69BS,NO PARK/STREET CLEAN,73,6466416.2,1854972.3 4273985914,2016-01-19T00:00:00,817,,,CA,,,HOND,PA,WT,729 RIDGEWOOD PL N,00443,54,80.69BS,NO PARK/STREET CLEAN,73,6466399,1853106.6 4273985925,2016-01-19T00:00:00,817,,,CA,,,HOND,PA,BL,719 RIDGEWOOD PL N,00443,54,80.69BS,NO PARK/STREET CLEAN,73,6466398.9,1853040 4273985936,2016-01-19T00:00:00,818,,,CA,,,HOND,PA,BL,719 RIDGEWOOD PL N,00443,54,5204A-,DISPLAY OF TABS,25,6466398.9,1853040 4273985984,2016-01-19T00:00:00,857,,,CA,,,NISS,PA,WT,1105 EL CENTRO AVE,00443,54,80.69B,NO PARKING,73,6463434,1855611.4 4273986006,2016-01-19T00:00:00,1009,,,CA,,,MAZD,PA,GY,5623 VIRGINIA AVE,00443,54,80.69BS,NO PARK/STREET CLEAN,73,6467355.1,1855932.8 4273988401,2016-01-19T00:00:00,1509,,,IL,201606,,CHEV,PA,WT,240 OLIVE ST S,6T7,56,80.69A+,STOP/STAND PROHIBIT,93,6486076.3,1841763.1 4273988412,2016-01-19T00:00:00,1512,,,CA,201511,,FORD,PA,BK,240 OLIVE ST S,6T7,56,80.69A+,STOP/STAND PROHIBIT,93,6486076.3,1841763.1 4273988423,2016-01-19T00:00:00,1537,,,CA,201610,,TOYT,PA,GY,312 5TH ST W,6T7,56,80.69A+,STOP/STAND PROHIBIT,93,6485695.7,1839994.8 4273988434,2016-01-19T00:00:00,1608,,,CA,201602,,TOYT,PA,SL,600 SPRING ST S,6T7,56,80.69A+,STOP/STAND PROHIBIT,93,6485641.3,1839201.4 4273988445,2016-01-19T00:00:00,1616,,,CA,201606,,DODG,VN,SL,816 SPRING ST S,6T7,56,80.69A+,STOP/STAND PROHIBIT,93,6484761,1838072.9 4273988456,2016-01-19T00:00:00,1647,,,CA,,,MERZ,PA,WT,1030 HILL ST S,6T7,56,80.69A+,STOP/STAND PROHIBIT,93,6489918.6,1847168.5 4273995191,2016-01-19T00:00:00,1056,OS670,,CA,,,LEXS,PA,SL,11513 PICO BL W,00107,51,88.13B+,METER EXP.,63,6427753.5,1834895 4273995202,2016-01-19T00:00:00,1114,PW338,,TX,201605,,CHEV,PA,WT,2400 PATRICIA AV,00107,51,88.13B+,METER EXP.,63,6434722.5,1839081 4273995213,2016-01-19T00:00:00,1117,PW28,,CA,201603,,SUBA,PA,BK,10585 PICO BL W,00107,51,88.13B+,METER EXP.,63,6433972.2,1838566.5 4273995224,2016-01-19T00:00:00,1124,PW87,,CA,201604,,TOYT,PA,WT,10767 PICO BL W,00107,51,88.13B+,METER EXP.,63,6432395.1,1837563.7 4273995235,2016-01-19T00:00:00,1128,PW94,,CA,201604,,TOYT,CM,BK,2300 GLENDON AV,00107,51,88.13B+,METER EXP.,63,6431539.4,1838287.3 4273995246,2016-01-19T00:00:00,1131,PW198,,CA,201604,,LEXS,PA,BK,10885 PICO BL W,00107,51,88.13B+,METER EXP.,63,6431639.7,1837136.7 4273995250,2016-01-19T00:00:00,1203,PW143A,,CA,201606,,LEXS,PA,WT,2244 WESTWOOD BL,00107,51,88.13B+,METER EXP.,63,6431049.6,1838388.6 4273995261,2016-01-19T00:00:00,1211,WS285,,WA,201603,,LEXS,PA,SL,2079 WESTWOOD BL,00107,51,88.13B+,METER EXP.,63,6430444.3,1839239.5 4273995272,2016-01-19T00:00:00,1253,,,CA,201606,,MNNI,PA,TN,1314 WESTWOOD BOULEVARD,00107,51,80.56E2,YELLOW ZONE,58,6427602.9,1843334.3 4273995283,2016-01-19T00:00:00,1258,WS126,,CA,201511,,MERZ,PA,BK,10801 WELLWORTH AV,00107,51,88.13B+,METER EXP.,63,6428697.2,1843775.9 4273995294,2016-01-19T00:00:00,1259,,,CA,201511,,MERZ,PA,BK,10801 WELLWORTH AV,00107,51,5200,DISPLAY OF PLATES,25,6428697.2,1843775.9 4273995305,2016-01-19T00:00:00,1301,4,,CA,,,TOYT,PA,BK,10870 WELLWORTH AVENUE,00107,51,80.58L,PREFERENTIAL PARKING,68,6427813,1843475.2 4273995316,2016-01-19T00:00:00,1303,4,,CA,201602,,NISS,PA,WT,10856 WELLWORTH AVENUE,00107,51,80.58L,PREFERENTIAL PARKING,68,6427965.8,1843523.2 4273995320,2016-01-19T00:00:00,1323,,,CA,201609,,BMW,PA,SL,1122 GAYLEY AVE,00107,51,80.56E4+,RED ZONE,93,6426523.5,1844475.9 4273995331,2016-01-19T00:00:00,1334,WV36,,CA,201601,,TOYT,PA,BL,1015 GAYLEY AV,00107,51,88.13B+,METER EXP.,63,6426049.6,1845142.7 4273995342,2016-01-19T00:00:00,1335,,,CA,201610,,VOLK,PA,TN,1033 GAYLEY AVENUE,00107,51,80.56E1,WHITE ZONE,58,6426132.5,1845026.1 4273995353,2016-01-19T00:00:00,1353,WSV164,,CA,201605,,CHEV,PA,BK,12400 WILSHIRE BL,00107,51,88.13B+,METER EXP.,63,6419015.7,1837763.2 4273995364,2016-01-19T00:00:00,1359,WSV210,,CA,201610,,TOYT,CM,WT,11982 WILSHIRE BL,00107,51,88.13B+,METER EXP.,63,6420800.9,1839484.4 4273995375,2016-01-19T00:00:00,1403,WSV242,,CA,201601,,TOYT,PA,SL,1201 WESTGATE AV S,00107,51,88.13B+,METER EXP.,63,6421268.8,1839935.6 4273995386,2016-01-19T00:00:00,1453,,,CA,201609,,HOND,PA,BK,1056 WESTWOOD BOULEVARD,00107,51,80.56E1,WHITE ZONE,58,6426791,1845080.8 4273995390,2016-01-19T00:00:00,1502,WV273,,CA,201604,,MAZD,PA,BL,1051 WESTWOOD BLVD,00107,51,88.13B+,METER EXP.,63,6426791.8,1845120.5 4273995401,2016-01-19T00:00:00,1505,,,CA,201501,,MERZ,PA,BK,1139 SOUTH WESTWOOD BOULEVARD,00107,51,80.56E2,YELLOW ZONE,58,6426791.8,1844617.7 4273995412,2016-01-19T00:00:00,1507,,,CA,201501,,MERZ,PA,BK,1139 SOUTH WESTWOOD BOULEVARD,00107,51,5200,DISPLAY OF PLATES,25,6426791.8,1844617.7 4273995423,2016-01-19T00:00:00,1513,4,,CA,201609,,DODG,CM,BK,10864 ROCHESTER AVE,00107,51,80.58L,PREFERENTIAL PARKING,68,6428014.7,1843203 4273995434,2016-01-19T00:00:00,1518,4,,CA,201609,,TOYT,PA,RD,10852 WELLWORTH AVENUE,00107,51,80.58L,PREFERENTIAL PARKING,68,6428032.4,1843544.5 4273995456,2016-01-19T00:00:00,1527,WS195,,CA,201609,,SUBA,PA,BK,1501 WESTWOOD BL,00107,51,88.13B+,METER EXP.,63,6428183.3,1842357.7 4273995460,2016-01-19T00:00:00,1618,PW33D,,CA,201510,,TOYT,PA,GY,2301 PARNELL AV,00107,51,88.13B+,METER EXP.,63,6433339,1839174.5 4273995471,2016-01-19T00:00:00,1620,,,CA,201510,,TOYT,PA,GY,2301 PARNELL AV,00107,51,5204A-,DISPLAY OF TABS,25,6433339,1839174.5 4273995482,2016-01-19T00:00:00,1632,WS14,,CA,201612,,GMC,PA,WT,1728 WESTWOOD BL,00107,51,88.13B+,METER EXP.,63,6428913.2,1841331.5 4273995493,2016-01-19T00:00:00,1640,,,CA,201601,,HYUN,PA,WT,1360 WESTWOOD BLVD,00107,51,80.66.1D,RESTRICTED TAXI ZONE,68,6427739.4,1843059.2 4273995504,2016-01-19T00:00:00,1645,4,,CA,201602,,CHEV,PA,BK,10855 WELLWORTH AVENUE,00107,51,80.58L,PREFERENTIAL PARKING,68,6427970.6,1843524.7 4273995515,2016-01-19T00:00:00,1650,WV337,,CA,201605,,CHEV,PA,BK,1070 GLENDON AV,00107,51,88.13B+,METER EXP.,63,6427089,1844981.4 4273995526,2016-01-19T00:00:00,1654,WV346,,OH,201608,,HOND,PA,GY,1030 GLENDON AV,00107,51,88.13B+,METER EXP.,63,6427115.4,1845107.9 4273995530,2016-01-19T00:00:00,1703,WV487A,,CA,,,MASE,PA,SL,10861 LINDBROOK DR,00107,51,88.13B+,METER EXP.,63,6427460.8,1844524.5 4273995541,2016-01-19T00:00:00,1748,WS227,,CA,201608,,FORD,PA,GY,1701 WESTWOOD BL,00107,51,88.13B+,METER EXP.,63,6428764.3,1841540.7 4273995552,2016-01-19T00:00:00,1751,WS230,,CA,201512,,AUDI,PA,BK,1701 WESTWOOD BL,00107,51,88.13B+,METER EXP.,63,6428764.3,1841540.7 4274002762,2016-01-19T00:00:00,1006,,,NY,201702,,ACUR,PA,BK,1312 MCCADDEN PL N,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6459495.6,1856980.1 4274002773,2016-01-19T00:00:00,1009,,,CA,201611,,TOYT,PA,WT,1326 MCCADDEN PL N,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6459495.3,1857072.7 4274002784,2016-01-19T00:00:00,1010,,,CA,201611,,TOYT,PA,WT,1326 MCCADDEN PL N,00483,54,22502A,18 IN. CURB/2 WAY,63,6459495.3,1857072.7 4274002795,2016-01-19T00:00:00,1014,,,CA,201601,,NISS,PA,BK,6705 DE LONGPRE AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6459720.9,1857548.4 4274002806,2016-01-19T00:00:00,1017,,,CA,201606,,VOLK,PA,BL,1435 LAS PALMAS AVE N,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6459769.8,1857838.9 4274002810,2016-01-19T00:00:00,1017,,,CA,201604,,RROV,PA,BN,1435 LAS PALMAS AVE N,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6459769.8,1857838.9 4274002821,2016-01-19T00:00:00,1019,,,CA,201604,,FORD,PA,GN,1419 LAS PALMAS AVE N,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6459770.3,1857746.5 4274002832,2016-01-19T00:00:00,1022,,,CA,201606,,ACUR,PA,GY,1351 LAS PALMAS AVE N,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6459844.9,1857231 4274002843,2016-01-19T00:00:00,1023,,,CA,201603,,DODG,PA,BK,1301 LAS PALMAS AVE N,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6459845.8,1856900.3 4274002935,2016-01-19T00:00:00,1038,,,CA,201608,,ACUR,PA,BG,1400 CHEROKEE AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6460168.3,1857547.7 4274002946,2016-01-19T00:00:00,1049,,,CA,,,TOYT,PA,WT,1400 MCCADDEN PL N,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6459335.7,1857549.1 4274002950,2016-01-19T00:00:00,1057,SV362,,CA,201612,,FORD,PA,RD,1401 COLE PL,00483,54,88.13B+,METER EXP.,63,6461674.7,1857540.6 4274002961,2016-01-19T00:00:00,1204,,,CA,201611,,MERZ,PA,WT,7062 HAWTHORN AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6457618.4,1859071.7 4274002972,2016-01-19T00:00:00,1205,,,CA,201701,,PORS,PA,GY,7076 HAWTHORN AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6457486.4,1859071.7 4274002983,2016-01-19T00:00:00,1206,,,CA,201610,,JEEP,PA,BK,7076 HAWTHORN AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6457486.4,1859071.7 4274002994,2016-01-19T00:00:00,1207,,,CA,201611,,FORD,PA,GY,7076 HAWTHORN AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6457486.4,1859071.7 4274003005,2016-01-19T00:00:00,1208,,,CA,201604,,MAZD,PA,GY,7076 HAWTHORN AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6457486.4,1859071.7 4274003016,2016-01-19T00:00:00,1209,,,NC,201512,,MAZD,PA,RD,7060 HAWTHORN AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6457637.2,1859071.7 4274003020,2016-01-19T00:00:00,1211,,,CA,201609,,MAZD,PA,GY,1665 SYCAMORE AVE N,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6457731.2,1859357.8 4274003031,2016-01-19T00:00:00,1212,,,NV,201606,,KIA,PA,GY,1665 SYCAMORE AVE N,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6457731.2,1859357.8 4274003042,2016-01-19T00:00:00,1213,,,CA,201606,,AUDI,PA,SL,1665 SYCAMORE AVE N,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6457731.2,1859357.8 4274003053,2016-01-19T00:00:00,1214,,,GA,201603,,HOND,PA,GY,1665 SYCAMORE AVE N,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6457731.2,1859357.8 4274003064,2016-01-19T00:00:00,1216,,,CA,201609,,TOYT,VN,BL,7000 HAWTHORN AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6458312.4,1859071.2 4274003075,2016-01-19T00:00:00,1217,,,CA,201607,,NISS,PA,GY,7018 HAWTHORN AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6458094.5,1859071.4 4274003086,2016-01-19T00:00:00,1218,,,CA,201603,,DODG,PA,GY,7024 HAWTHORN AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6458021.9,1859071.4 4274003090,2016-01-19T00:00:00,1221,,,CA,201611,,CHEV,PA,WT,7027 LANEWOOD AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6458066.4,1858662.2 4274003101,2016-01-19T00:00:00,1222,,,CA,201602,,HOND,PA,GY,7045 LANEWOOD AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6457894.1,1858662.2 4274003112,2016-01-19T00:00:00,1222,,,CA,201605,,CHEV,PA,GY,7045 LANEWOOD AVE,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6457894.1,1858662.2 4274003123,2016-01-19T00:00:00,1255,,,CA,201604,,TOYT,PA,BK,6671 SUNSET BLVD,00483,54,80.69BS,NO PARK/STREET CLEAN,73,6460067.6,1858208 4274003134,2016-01-19T00:00:00,1301,HO27,,CA,201611,,OTHR,PA,BK,1601 LAS PALMAS AV N,00483,54,88.13B+,METER EXP.,63,6459910.7,1858835.4 4274003145,2016-01-19T00:00:00,1308,SV168,,CA,201604,,TOYT,PA,BK,6601 SUNSET BL,00483,54,88.13B+,METER EXP.,63,6460788.4,1858207.3 4274003156,2016-01-19T00:00:00,1344,,,CA,201511,,ACUR,PA,GY,6651 SUNSET BL,00483,54,5204A-,DISPLAY OF TABS,25,6460232.1,1858207.8 4274003160,2016-01-19T00:00:00,1403,,,CA,201510,,MAZD,PA,WT,813 LA BREA AVE N,00483,54,5204A-,DISPLAY OF TABS,25,6457260.7,1844543 4274003171,2016-01-19T00:00:00,1411,,,CA,201508,,AUDI,PA,GY,171 LA BREA AVE S,00483,54,5204A-,DISPLAY OF TABS,25,6457481.1,1848677.6 4274003182,2016-01-19T00:00:00,1429,MM543,,CA,201606,,JAGU,PA,OT,401 LA BREA AV S,00483,54,88.13B+,METER EXP.,63,6457477.6,1846901.6 4274003193,2016-01-19T00:00:00,1438,MM691,,AZ,,,TOYT,PA,SL,5601 WILSHIRE BL,00483,54,88.13B+,METER EXP.,63,6455520.6,1845278.7 4274003204,2016-01-19T00:00:00,1525,MM781,,CA,,,BMW,PA,BK,5700 WILSHIRE BL,00483,54,88.13B+,METER EXP.,63,6454875.1,1845256.2 4274003215,2016-01-19T00:00:00,1556,MM703,,CA,201603,,CHEV,PA,BL,5701 WILSHIRE BL,00483,54,88.13B+,METER EXP.,63,6454889.7,1845295.8 4274007570,2016-01-19T00:00:00,805,WW2040,,CA,201602,,NISS,PA,GY,601 GRAMERCY PL S,00492,54,88.13B+,METER EXP.,63,6466926.2,1845645 4274007581,2016-01-19T00:00:00,814,WW1952,,CA,201511,,TOYT,PA,BK,3700 7TH ST W,00492,54,88.13B+,METER EXP.,63,6468807,1844245 4274007592,2016-01-19T00:00:00,815,,,CA,201511,,TOYT,PA,BK,3700 7TH ST W,00492,54,5204A-,DISPLAY OF TABS,25,6468807,1844245 4274007603,2016-01-19T00:00:00,818,WW1913,,NJ,201607,,CHEV,PA,BL,800 SERRANO AV S,00492,54,88.13B+,METER EXP.,63,6468806.9,1843512.1 4274007614,2016-01-19T00:00:00,826,WW1938,,CA,201607,,NISS,PA,BL,701 KINGSLEY DR S,00492,54,88.13B+,METER EXP.,63,6469869,1844249.5 4274007684,2016-01-19T00:00:00,1206,,,CA,201607,,MERZ,PA,BL,759 MCCADDEN PL N,00492,54,80.69BS,NO PARK/STREET CLEAN,73,6459502.4,1853318.8 4274007695,2016-01-19T00:00:00,1208,,,CA,201607,,MERZ,PA,BL,759 MCCADDEN PL N,00492,54,5200,DISPLAY OF PLATES,25,6459502.4,1853318.8 4274007706,2016-01-19T00:00:00,1210,,,CA,,,MERZ,PA,BK,801 MCCADDEN PL N,00492,54,80.69BS,NO PARK/STREET CLEAN,73,99999,99999 4274007710,2016-01-19T00:00:00,1213,,,CA,,,FIAT,PA,BK,6618 WILLOUGHBY AVE,00492,54,80.69BS,NO PARK/STREET CLEAN,73,6460107.8,1854248.8 4274007721,2016-01-19T00:00:00,1451,WW1709,,CA,201610,,VOLK,PA,GY,501 SERRANO AV S,00495,54,88.13B+,METER EXP.,63,6468733.5,1851597.6 4274008992,2016-01-19T00:00:00,120,,,CA,201604,,DODG,PA,SL,15055 RAYEN ST,00319,53,80.56E4+,RED ZONE,93,6422632.7,1907075 4274009003,2016-01-19T00:00:00,126,,,CA,201604,,BMW,PA,BK,8953 MEMORY PARK AVE,00319,53,80.56E1,WHITE ZONE,58,6421323.4,1907628.4 4274009014,2016-01-19T00:00:00,127,,,CA,201604,,BMW,PA,BK,8953 MEMORY PARK AVE,00319,53,5200,DISPLAY OF PLATES,25,6421323.4,1907628.4 4274009025,2016-01-19T00:00:00,128,,,NV,,,VOLK,PA,SL,8953 MEMORY PARK AVE,00319,53,80.56E1,WHITE ZONE,58,6421323.4,1907628.4 4274009051,2016-01-19T00:00:00,152,,,CA,201602,,HOND,PA,SL,9851 ZELZAH AVE,00319,53,80.56E4+,RED ZONE,93,6403523.8,1913585.3 4274009062,2016-01-19T00:00:00,157,,,AZ,,,FORD,CM,WT,10000 ZELZAH AVE,00319,53,80.69.2,COMM VEH OVER TIME L,78,6403520.5,1914576.7 4274009073,2016-01-19T00:00:00,212,,,AZ,,,FORD,CM,WT,7940 RESEDA BLVD,00319,53,80.69.2,COMM VEH OVER TIME L,78,6399600.6,1900900.4 4274009084,2016-01-19T00:00:00,358,,,CA,201607,,FORD,PA,RD,12200 VANOWEN ST,00319,53,80.61,STANDNG IN ALLEY,68,6441101.3,1893199 4274009095,2016-01-19T00:00:00,402,,,CA,201610,,CHEV,PA,WT,12201 VANOWEN ST,00319,53,80.61,STANDNG IN ALLEY,68,6441101.3,1893199 4274009106,2016-01-19T00:00:00,433,,,CA,201508,,PONT,PA,GY,17800 KINZIE ST,00319,53,5204A-,DISPLAY OF TABS,25,99999,99999 4274009110,2016-01-19T00:00:00,608,,,CA,201509,,TOYT,PA,WT,9900 ZELZAH AVE,00319,53,5204A-,DISPLAY OF TABS,25,6403522.8,1913915.8 4274009121,2016-01-19T00:00:00,636,,,CA,201610,,DODG,PA,WT,8600 KESTER AVE,00319,53,22500B,PARKED IN CROSSWALK,68,6423382.2,1905126.5 4274009132,2016-01-19T00:00:00,641,,,CA,201612,,SUBA,PA,BL,8924 KESTER AVE,00319,53,80.56E1,WHITE ZONE,58,6423391.9,1907236.5 4274009180,2016-01-19T00:00:00,2246,,,CA,201507,,MERC,PA,GN,12430 SATICOY ST,00319,53,5204A-,DISPLAY OF TABS,25,6439546,1898496.5 4274009191,2016-01-19T00:00:00,2251,,,CA,201612,,HOND,PA,GN,12534 ROSCOE BLVD,00319,53,80.56E4+,RED ZONE,93,6438582.7,1903296.6 4274009202,2016-01-19T00:00:00,2311,,,AB,201607,,PONT,PA,BL,9755 ZELZAH AVE,00319,53,80.56E4+,RED ZONE,93,6403525.3,1912959.4 4274009213,2016-01-19T00:00:00,2317,,,CA,201610,,LEXS,PA,SL,18606 CITRONIA ST,00319,53,80.69B,NO PARKING,73,6398831.3,1912150.3 4274009224,2016-01-19T00:00:00,2334,,,CA,201607,,FORD,CM,WT,19609 SHERMAN WAY,00319,53,80.69.2,COMM VEH OVER TIME L,78,6392258.1,1895990 4274009235,2016-01-19T00:00:00,2343,,,CA,201509,,TOYT,PA,WT,19619 LEADWELL ST,00319,53,22500F,PARKED ON SIDEWALK,68,6392169,1896923.7 4274009246,2016-01-19T00:00:00,2344,,,CA,201509,,TOYT,PA,WT,19619 LEADWELL ST,00319,53,5204A-,DISPLAY OF TABS,25,6392169,1896923.7 4274009250,2016-01-19T00:00:00,2351,,,CA,201607,,JEEP,PA,BK,7400 OSO AVE,00319,53,80.56E4+,RED ZONE,93,6387700,1897505.6 4274011416,2016-01-19T00:00:00,1624,SV28,,CA,201701,,HOND,PA,BK,1500 IVAR AV,00402,54,88.13B+,METER EXP.,63,6462120.7,1858205.4 4274011420,2016-01-19T00:00:00,1627,HO207,,CA,201602,,HOND,PA,GY,1650 IVAR AV,00402,54,88.13B+,METER EXP.,63,6462322.2,1859195.5 4274011431,2016-01-19T00:00:00,1813,64,,CA,201608,,DODG,PA,RD,6666 FRANKLIN AVE,00402,54,80.58L,PREFERENTIAL PARKING,68,6460173.3,1860830.4 4274011442,2016-01-19T00:00:00,1824,99,,CA,201602,,MNNI,PA,SL,1966 WILCOX AVE,00402,54,80.58L,PREFERENTIAL PARKING,68,6461453.8,1858170.8 4274011453,2016-01-19T00:00:00,1835,,,CA,,,BMW,PA,BK,1617 CAHUENGA BLVD,00402,54,80.56E1,WHITE ZONE,58,6461907.3,1858964.1 4274011464,2016-01-19T00:00:00,1850,64,,CA,201612,,NISS,PA,SL,1350 MCCADDEN PL N,00402,54,80.58L,PREFERENTIAL PARKING,68,6459494.9,1857231.4 4274011475,2016-01-19T00:00:00,1855,64,,CA,201511,,BMW,PA,GY,1212 MCCADDEN PL N,00402,54,80.58L,PREFERENTIAL PARKING,68,6459497.3,1856324.9 4274011486,2016-01-19T00:00:00,1856,,,CA,201511,,BMW,PA,GY,1212 MCCADDEN PL N,00402,54,5204A-,DISPLAY OF TABS,25,6459497.3,1856324.9 4274011490,2016-01-19T00:00:00,2006,,,CA,201609,,AUDI,PA,SL,1401 IVAR AVE,00402,54,80.66.1D,RESTRICTED TAXI ZONE,68,6462120.7,1857542 4274011501,2016-01-19T00:00:00,2007,,,TX,201611,,TOYT,PA,BK,1439 IVAR AVE,00402,54,80.56E1,WHITE ZONE,58,6462120.7,1857799.3 4274011512,2016-01-19T00:00:00,2024,114,,CA,201611,,MERZ,PA,SL,345 SYCAMORE AVE S,00402,54,80.58L,PREFERENTIAL PARKING,68,6457808.6,1847304 4274011523,2016-01-19T00:00:00,2025,,,CA,201611,,MERZ,PA,SL,345 SYCAMORE AVE S,00402,54,5200,DISPLAY OF PLATES,25,6457808.6,1847304 4274011534,2016-01-19T00:00:00,2033,36,,CA,201607,,MERZ,PA,GY,750 SYCAMORE AVE S,00402,54,80.58L,PREFERENTIAL PARKING,68,6457718.9,1844879 4274011545,2016-01-19T00:00:00,2034,,,CA,201607,,MERZ,PA,GY,750 SYCAMORE AVE S,00402,54,5200,DISPLAY OF PLATES,25,6457718.9,1844879 4274011556,2016-01-19T00:00:00,2036,36,,CA,201609,,MERZ,PA,BK,740 SYCAMORE AVE S,00402,54,80.58L,PREFERENTIAL PARKING,68,6457739.9,1844941.8 4274011560,2016-01-19T00:00:00,2207,,,CA,201612,,NISS,PA,BK,1401 IVAR AVE,00402,54,80.66.1D,RESTRICTED TAXI ZONE,68,6462120.7,1857542 4274011571,2016-01-19T00:00:00,2220,37,,CA,201606,,LINC,PA,BK,7040 HAWTHORN AVE,00402,54,80.58L,PREFERENTIAL PARKING,68,6457828.3,1859071.6 4274011582,2016-01-19T00:00:00,2228,70,,CA,201609,,TOYT,PA,RD,1800 ORCHID AVE,00402,54,80.58L,PREFERENTIAL PARKING,68,6458690.6,1860449.9 4274011593,2016-01-19T00:00:00,2258,,,CA,201608,,TOYT,PA,GY,6407 SELMA AVE,00402,54,80.56E1,WHITE ZONE,58,6461879.7,1858855.3 4274011604,2016-01-19T00:00:00,2259,,,CA,201609,,FORD,PA,BK,6407 SELMA AVE,00402,54,80.56E1,WHITE ZONE,58,6461879.7,1858855.3 4274011615,2016-01-19T00:00:00,2300,,,CA,201611,,JEEP,PA,BK,6407 SELMA AVE,00402,54,80.56E1,WHITE ZONE,58,6461879.7,1858855.3 4274013800,2016-01-19T00:00:00,751,,,CA,201611,,FORD,PA,RD,135 LAKE ST N,00400,54,80.56E1,WHITE ZONE,58,6479433.3,1846808.4 4274013822,2016-01-19T00:00:00,904,,,CA,201601,,TOYT,PA,WT,4927 ELMWOOD AVE,00400,54,80.69BS,NO PARK/STREET CLEAN,73,6466493,1851094 4274013833,2016-01-19T00:00:00,906,,,CA,201606,,TOYT,PA,BK,4951 ELMWOOD AVE,00400,54,80.69BS,NO PARK/STREET CLEAN,73,6466334,1851094.3 4274013855,2016-01-19T00:00:00,909,,,CA,201608,,FORD,PA,GY,450 VAN NESS AVE N,00400,54,80.69BS,NO PARK/STREET CLEAN,73,6466063.9,1851425 4274013866,2016-01-19T00:00:00,911,,,CA,201603,,TOYT,PA,WT,5119 MAPLEWOOD AVE W,00400,54,80.69BS,NO PARK/STREET CLEAN,73,6466608.1,1851754 4274013870,2016-01-19T00:00:00,912,,,CA,201606,,KIA,PA,BL,5139 MAPLEWOOD AVE W,00400,54,80.69BS,NO PARK/STREET CLEAN,73,6466472,1851754.3 4274013881,2016-01-19T00:00:00,914,,,AL,201602,,TOYT,PA,GO,5178 CLINTON ST,00400,54,80.69BS,NO PARK/STREET CLEAN,73,6466199.8,1852250 4274013892,2016-01-19T00:00:00,916,,,CA,201508,,AUDI,PA,GY,5145 RALEIGH ST,00400,54,80.69BS,NO PARK/STREET CLEAN,73,6466432.9,1852579.6 4274013903,2016-01-19T00:00:00,917,,,CA,201508,,AUDI,PA,GY,5145 RALEIGH ST,00400,54,5204A-,DISPLAY OF TABS,25,6466432.9,1852579.6 4274013914,2016-01-19T00:00:00,918,,,CA,201602,,TOYT,PA,SL,5135 RALEIGH ST,00400,54,80.69BS,NO PARK/STREET CLEAN,73,6466500.4,1852579.4 4274013925,2016-01-19T00:00:00,1044,,,CA,201605,,MAZD,PA,BK,438 GOWER ST,00400,54,80.69BS,NO PARK/STREET CLEAN,73,6463955.2,1850968 4274013940,2016-01-19T00:00:00,1204,,,CA,201612,,HOND,PA,SL,5301 ROSEWOOD AVE W,00400,54,80.69BS,NO PARK/STREET CLEAN,73,6463660.9,1851271.4 4274013951,2016-01-19T00:00:00,1205,,,NV,201603,,TOYT,PA,WT,5301 ROSEWOOD AVE W,00400,54,80.69BS,NO PARK/STREET CLEAN,73,6463660.9,1851271.4 4274013962,2016-01-19T00:00:00,1206,,,FL,201605,,MNNI,PA,BL,5325 ROSEWOOD AVE W,00400,54,80.69BS,NO PARK/STREET CLEAN,73,6463480.9,1851271.6 4274022012,2016-01-19T00:00:00,1400,,1145,CA,201605,,NISS,PA,BK,580 HILGARD AVE,169R1,51,80.69C,PARKED OVER TIME LIM,58,6428805.8,1848319.1 4274022023,2016-01-19T00:00:00,1402,,1145,CA,201605,,HOND,PA,BL,580 HILGARD AVE,169R1,51,80.69C,PARKED OVER TIME LIM,58,6428805.8,1848319.1 4274022034,2016-01-19T00:00:00,1501,,1250,CA,201609,,NISS,PA,WT,10974 ROEBLING AVE,169R1,51,80.69C,PARKED OVER TIME LIM,58,6425503.7,1846299.5 4274022045,2016-01-19T00:00:00,1505,,1250,AZ,,,GMC,PU,WT,10984 STRATHMORE DR,169R1,51,80.69C,PARKED OVER TIME LIM,58,6425323.7,1846707.4 4274022056,2016-01-19T00:00:00,1509,,1255,CA,201604,,TOYT,PA,BL,615 MIDVALE AVE S,169R1,51,80.69C,PARKED OVER TIME LIM,58,6424824.8,1846753.8 4274022060,2016-01-19T00:00:00,1522,,1300,CA,201605,,LEXS,PA,BK,411 KELTON AVE,169R1,51,80.69C,PARKED OVER TIME LIM,58,6424214.2,1848223.2 4274022071,2016-01-19T00:00:00,1523,,1300,CA,201608,,HOND,PA,GY,424 KELTON AVE,169R1,51,80.69C,PARKED OVER TIME LIM,58,6424225,1848116.7 4274022082,2016-01-19T00:00:00,1524,,1300,CA,201602,,HOND,PA,WT,424 KELTON AVE,169R1,51,80.69C,PARKED OVER TIME LIM,58,6424225,1848116.7 4274022093,2016-01-19T00:00:00,1527,,1300,CA,201604,,FORD,PA,WT,424 KELTON AVE,169R1,51,80.69C,PARKED OVER TIME LIM,58,6424225,1848116.7 4274022104,2016-01-19T00:00:00,1530,,1300,CA,201602,,CHRY,PA,BL,554 LEVERING AVE,169R1,51,80.69C,PARKED OVER TIME LIM,58,6423996.1,1846993.8 4274022115,2016-01-19T00:00:00,1532,,,CA,201602,,CHRY,PA,BL,554 LEVERING AVE,169R1,51,5200,DISPLAY OF PLATES,25,6423996.1,1846993.8 4274022126,2016-01-19T00:00:00,1538,,1305,CA,201605,,VOLK,PA,BL,501 LANDFAIR AVE S,169R1,51,80.69C,PARKED OVER TIME LIM,58,6425046.2,1847655.1 4274022130,2016-01-19T00:00:00,1539,,1305,NY,201706,,TOYT,PA,GY,509 LANDFAIR AVE S,169R1,51,80.69C,PARKED OVER TIME LIM,58,6425075,1847621.8 4274022141,2016-01-19T00:00:00,1543,,1305,CA,201609,,TOYT,PA,WT,601 LANDFAIR AVE S,169R1,51,80.69C,PARKED OVER TIME LIM,58,6425406.2,1847238.7 4274022152,2016-01-19T00:00:00,1546,,,CA,201605,,FORD,PA,RD,601 LANDFAIR AVE S,169R1,51,80.56E4+,RED ZONE,93,6425406.2,1847238.7 4274022163,2016-01-19T00:00:00,1551,,1305,CA,201601,,HOND,PA,BL,424 LANDFAIR AVE S,169R1,51,80.69C,PARKED OVER TIME LIM,58,6424556.2,1848103.3 4274033466,2016-01-19T00:00:00,1618,,,CA,201603,,CHEV,PA,GY,12836 VICTORY BOULEVARD,00315,53,80.70,NO STOPPING/ANTI-GRI,163,6436919.8,1890573.1 4274033470,2016-01-19T00:00:00,1620,,,CA,201511,,MERZ,PA,WT,12832 VICTORY BOULEVARD,00315,53,80.70,NO STOPPING/ANTI-GRI,163,6436945.1,1890572.9 4274033481,2016-01-19T00:00:00,1622,,,CA,201608,,TOYT,PU,WT,12830 VICTORY BOULEVARD,00315,53,80.70,NO STOPPING/ANTI-GRI,163,6436957.8,1890572.9 4274033514,2016-01-19T00:00:00,1806,57,,CA,201601,,FORD,PA,BN,3935 RHODES AVENUE,00315,53,80.58L,PREFERENTIAL PARKING,68,6439747.9,1874370.8 4274033525,2016-01-19T00:00:00,1809,57,,CA,201604,,FIAT,PA,RD,3935 RHODES AVENUE,00315,53,80.58L,PREFERENTIAL PARKING,68,6439747.9,1874370.8 4274033536,2016-01-19T00:00:00,1922,,,CA,201605,,TOYT,PA,OT,4441 TALOFA AVENUE,00315,53,80.69B,NO PARKING,73,6455267.3,1877568.7 4274033540,2016-01-19T00:00:00,1937,,,CA,,,TOYT,PA,BK,5259 LANKERSHIM BOULEVARD,00315,53,80.61,STANDNG IN ALLEY,68,6448081.5,1883118.7 4274033551,2016-01-19T00:00:00,2005,,,CA,201611,,BMW,PA,WT,3970 EUREKA DRIVE,00315,53,80.69B,NO PARKING,73,6448042.3,1873215 4274033562,2016-01-19T00:00:00,2007,,,CA,201601,,TOYT,PA,BL,3970 EUREKA DRIVE,00315,53,80.69B,NO PARKING,73,6448042.3,1873215 4274033573,2016-01-19T00:00:00,2008,,,CA,201611,,LEXS,PA,SL,3968 EUREKA DRIVE,00315,53,80.69B,NO PARKING,73,6448043.9,1873208.2 4274033584,2016-01-19T00:00:00,2024,,,CA,,,MERZ,PA,BL,10900 VENTURA BLVD,00315,53,22507.8A,DISABLED PARKING/NO,363,6450030.8,1873514 4274033610,2016-01-19T00:00:00,2106,81,,CA,201607,,BMW,PA,SL,11417 WOODBRIDGE STREET,00315,53,80.58L,PREFERENTIAL PARKING,68,6446781.1,1876661.9 4274033621,2016-01-19T00:00:00,2108,81,,CA,201608,,CHRY,PA,PR,11415 WOODBRIDGE STREET,00315,53,80.58L,PREFERENTIAL PARKING,68,6446808.6,1876661.8 4274033632,2016-01-19T00:00:00,2110,81,,CA,,,MERZ,PA,BK,11417 WOODBRIDGE STREET,00315,53,80.58L,PREFERENTIAL PARKING,68,6446781.1,1876661.9 4274033643,2016-01-19T00:00:00,2116,81,,CA,201601,,HOND,PA,GY,11330 WOODBRIDGE STREET,00315,53,80.58L,PREFERENTIAL PARKING,68,6447331.2,1876660.2 4274033665,2016-01-19T00:00:00,2239,,,CA,201603,,NISS,PA,WT,5333 HARMONY AVENUE,00315,53,80.69B,NO PARKING,73,6450816.5,1883373 4274033676,2016-01-19T00:00:00,2305,,,CA,201701,,HYUN,PA,SL,11201 CHANDLER BOULEVARD,00315,53,80.69B,NO PARKING,73,6448402.1,1883766.8 4274033680,2016-01-19T00:00:00,2307,,,CA,201605,,KIA,PA,BK,11209 CHANDLER BOULEVARD,00315,53,80.69B,NO PARKING,73,6448355.1,1883767 4274033691,2016-01-19T00:00:00,2308,,,CA,201607,,MITS,PA,SL,11265 CHANDLER BOULEVARD,00315,53,80.69B,NO PARKING,73,6447717.7,1883769.7 4274033702,2016-01-19T00:00:00,2352,,,CA,,,HYUN,PA,SL,12550 SATICOY STREET SOUTH,00315,53,80.69B,NO PARKING,73,6438550.7,1898308.3 4274041321,2016-01-19T00:00:00,941,,,WA,,,DODG,PA,SL,1039 NORTH BROADWAY,00651,56,80.56E1,WHITE ZONE,58,6490417,1846986.5 4274041332,2016-01-19T00:00:00,1009,,,CA,201602,,HOND,PA,BK,301 AVENUE 21 S,00651,56,80.69BS,NO PARK/STREET CLEAN,73,6494526.5,1850648 4274041365,2016-01-19T00:00:00,1019,,,CA,201612,,NISS,PA,SL,2223 GRIFFIN AVE,00651,56,80.69BS,NO PARK/STREET CLEAN,73,6497568.2,1848128.7 4274041376,2016-01-19T00:00:00,1024,,,CA,201604,,TOYT,PA,GN,2438 DALY ST,00651,56,80.69BS,NO PARK/STREET CLEAN,73,6496367.5,1849459.6 4274041380,2016-01-19T00:00:00,1101,,,CA,201611,,TOYT,PA,SL,100 AVENUE 24 S,00651,56,80.69BS,NO PARK/STREET CLEAN,73,6495957.7,1850120.4 4274041391,2016-01-19T00:00:00,1234,,,CA,201606,,MITS,PA,SL,1004 MARK ST,00651,56,80.69BS,NO PARK/STREET CLEAN,73,6497279.5,1843320 4274041402,2016-01-19T00:00:00,1237,,,CA,201606,,TOYT,PA,GN,1033 CLEMENT ST,00651,56,80.69BS,NO PARK/STREET CLEAN,73,6497595.7,1843319.7 4274041413,2016-01-19T00:00:00,1237,,,CA,201601,,LEXS,PA,SL,1033 CLEMENT ST,00651,56,80.69BS,NO PARK/STREET CLEAN,73,6497595.7,1843319.7 4274041424,2016-01-19T00:00:00,1238,,,CA,,,TOYT,PA,BK,1033 CLEMENT ST,00651,56,80.69BS,NO PARK/STREET CLEAN,73,6497595.7,1843319.7 4274041435,2016-01-19T00:00:00,1239,,,CA,201609,,TOYT,PA,WT,1015 CLEMENT ST,00651,56,80.69BS,NO PARK/STREET CLEAN,73,6497551.5,1843236 4274041446,2016-01-19T00:00:00,1240,,,CA,201601,,TOYT,PA,WT,1015 CLEMENT ST,00651,56,80.69BS,NO PARK/STREET CLEAN,73,6497551.5,1843236 4274041516,2016-01-19T00:00:00,1458,,,CA,,,OTHR,TK,BN,401 SAN PEDRO ST S,00651,56,80.56E4+,RED ZONE,93,6488052.8,1839154.3 4274041520,2016-01-19T00:00:00,1506,,,CA,,,CHEV,PA,BL,312 5TH ST W,00651,56,80.69AP+,NO STOP/STANDING,93,6485695.7,1839994.8 4274041531,2016-01-19T00:00:00,1509,,,CA,201603,,VOLK,PA,BK,325 5TH ST W,00651,56,80.69AP+,NO STOP/STANDING,93,6485647.9,1840032.2 4274041542,2016-01-19T00:00:00,1513,,,CA,201611,,LEXS,PA,WT,325 5TH ST W,00651,56,80.69AP+,NO STOP/STANDING,93,6485647.9,1840032.2 4274043620,2016-01-19T00:00:00,1149,,1130,CA,201608,,CHRY,VN,GY,6671 W YUCCA ST,489R1,54,80.69C,PARKED OVER TIME LIM,58,6460151.6,1860105.5 4274043631,2016-01-19T00:00:00,1152,,1130,CA,201601,,TOYT,PA,WT,6671 W YUCCA ST,489R1,54,80.69C,PARKED OVER TIME LIM,58,6460151.6,1860105.5 4274043642,2016-01-19T00:00:00,1156,HO979,,CA,201604,,TOYT,PU,WT,1738 LAS PALMAS AV N,489R1,54,88.13B+,METER EXP.,63,6459906.5,1859981.1 4274043653,2016-01-19T00:00:00,1159,HO978,,CA,,,JEEP,PA,RD,1738 N LAS PALMAS AV N,489R1,54,88.13B+,METER EXP.,63,99999,99999 4274043664,2016-01-19T00:00:00,1201,,,CA,201602,,TSMR,PA,GY,1700 BK N LAS PALMAS AV N,489R1,54,5200,DISPLAY OF PLATES,25,99999,99999 4274043675,2016-01-19T00:00:00,1205,,,TX,201603,,LAMO,PA,YE,6751 W HOLLYWOOD BLVD,489R1,54,80.56E1,WHITE ZONE,58,6459518.8,1859510.7 4274043686,2016-01-19T00:00:00,1229,,,CA,,,FORD,VN,GY,6925 W HOLLYWOOD BLVD,489R1,54,80.56E4+,RED ZONE,93,6458363.9,1859509.7 4274043734,2016-01-19T00:00:00,1306,,,CA,201603,,MAZD,PA,GY,6652 W HOLLYWOOD BLVD,489R1,54,80.56E4+,RED ZONE,93,6460239.9,1859513.8 4274043745,2016-01-19T00:00:00,1436,,,NY,201606,,MAZD,PA,RD,1800 BK N IVAR AVE,489R1,54,22502A,18 IN. CURB/2 WAY,63,99999,99999 4274043756,2016-01-19T00:00:00,1438,,,CA,201606,,HOND,PA,GY,1851 N IVAR AVE,489R1,54,22502A,18 IN. CURB/2 WAY,63,6462321.7,1860697.3 4274043760,2016-01-19T00:00:00,1440,,,CA,201610,,CHEV,VN,GY,1851 N IVAR AVE,489R1,54,22502A,18 IN. CURB/2 WAY,63,6462321.7,1860697.3 4274055671,2016-01-19T00:00:00,1101,L226,,CA,201603,,HYUN,PA,BL,600 LARCHMONT BL N,00472,54,88.13B+,METER EXP.,63,6463661.1,1852263.8 4274055682,2016-01-19T00:00:00,1122,MM319A,,CA,201611,,TOYT,PA,SL,601 MASSELIN AV,00472,54,88.13B+,METER EXP.,63,6454905.9,1846181.9 4274055693,2016-01-19T00:00:00,1129,MM697,,CA,201607,,KIA,PA,BK,5701 WILSHIRE BL,00472,54,88.13B+,METER EXP.,63,6454889.7,1845295.8 4274055704,2016-01-19T00:00:00,1143,34,,AZ,201608,,KIA,PA,BK,660 LA JOLLA AVE,00472,54,80.58L,PREFERENTIAL PARKING,68,6450174,1846084.7 4274055715,2016-01-19T00:00:00,1145,,,CA,201607,,TOYT,PA,BL,657 LA JOLLA AVE,00472,54,80.69BS,NO PARK/STREET CLEAN,73,6450178.4,1846116.1 4274055726,2016-01-19T00:00:00,1148,34,,CA,201604,,HYUN,PA,BN,660 LA JOLLA AVE,00472,54,80.58L,PREFERENTIAL PARKING,68,6450174,1846084.7 4274055730,2016-01-19T00:00:00,1153,34,,CA,201701,,TOYT,PA,MR,6311 ORANGE ST,00472,54,80.58L,PREFERENTIAL PARKING,68,6450998.8,1846049.8 4274055741,2016-01-19T00:00:00,1157,34,,CA,201108,,HOND,PA,OT,6315 ORANGE ST,00472,54,80.58L,PREFERENTIAL PARKING,68,6450961.8,1846054.9 4274055752,2016-01-19T00:00:00,1158,,,CA,201108,,HOND,PA,OT,6315 ORANGE ST,00472,54,5204A-,DISPLAY OF TABS,25,6450961.8,1846054.9 4274055763,2016-01-19T00:00:00,1200,34,,CA,201607,,HYUN,PA,BL,6331 ORANGE ST,00472,54,80.58L,PREFERENTIAL PARKING,68,6450813.9,1846075.5 4274055774,2016-01-19T00:00:00,1204,34,,CA,201512,,TOYT,PA,WT,6365 ORANGE ST,00472,54,80.58L,PREFERENTIAL PARKING,68,6450499.4,1846119.4 4274055785,2016-01-19T00:00:00,1208,34,,CA,201512,,NISS,PA,OT,6369 ORANGE ST,00472,54,80.58L,PREFERENTIAL PARKING,68,6450462.4,1846124.5 4274055796,2016-01-19T00:00:00,1226,WF569,,CA,201702,,LEXS,PA,GY,500 SAN VICENTE BL,00472,54,88.13B+,METER EXP.,63,6448176.8,1847568.1 4274055800,2016-01-19T00:00:00,1237,34,,CA,201610,,NISS,PA,GY,6700 DREXEL AVE,00472,54,80.58L,PREFERENTIAL PARKING,68,6448492.1,1847926.4 4274055811,2016-01-19T00:00:00,1248,34,,CA,201611,,HOND,PA,SL,6737 COLGATE AVE,00472,54,80.58L,PREFERENTIAL PARKING,68,6448285.8,1848257 4274055822,2016-01-19T00:00:00,1305,WF182,,CA,201603,,FORD,PA,SL,8300 3RD ST W,00472,54,88.13B+,METER EXP.,63,6449615.6,1849032.2 4274055833,2016-01-19T00:00:00,1308,,,CA,201607,,BMW,PA,WT,8300 3RD ST W,00472,54,80.56E1,WHITE ZONE,58,6449615.6,1849032.2 4274055844,2016-01-19T00:00:00,1318,,,CA,201612,,MERZ,PA,BK,100 LAUREL AVE,00472,54,80.61,STANDNG IN ALLEY,68,6451208.2,1849617.8 4274055855,2016-01-19T00:00:00,1326,,,CA,201604,,VOLK,PA,GY,100 LAUREL AVE,00472,54,80.61,STANDNG IN ALLEY,68,6451208.2,1849617.8 4274055866,2016-01-19T00:00:00,1409,WF89,,CA,201602,,HYUN,PA,WT,101 KINGS RD S,00472,54,88.13B+,METER EXP.,63,6448977.2,1849690 4274055870,2016-01-19T00:00:00,1415,LC248,,CA,201611,,MAZD,PA,GY,100 KILKEA DR N,00472,54,88.13B+,METER EXP.,63,6450563.5,1849616.9 4274055881,2016-01-19T00:00:00,1542,BF180,,CA,,,PORS,PA,BK,7500 MELROSE AV,00472,54,88.13B+,METER EXP.,63,6454710.6,1853005.8 4274055892,2016-01-19T00:00:00,1545,BF194,,CA,201607,,OTHR,PA,BK,7500 MELROSE AV,00472,54,88.13B+,METER EXP.,63,6454710.6,1853005.8 4274055903,2016-01-19T00:00:00,1641,L177,,CA,201607,,VOLK,PA,BK,400 LARCHMONT BL N,00472,54,88.13B+,METER EXP.,63,6463661,1850777.3 4274057406,2016-01-19T00:00:00,1025,,,CA,201612,,FORD,PU,WT,4300 VIA DOLCE,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6422522.7,1813396.5 4274057421,2016-01-19T00:00:00,1032,,,TX,201601,,FORD,PA,RD,5000 VIA DOLCE,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6423437,1811888.3 4274057432,2016-01-19T00:00:00,1105,,,CA,201611,,CHEV,PA,BK,1903 PACIFIC AVE,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6418918.4,1817636 4274057454,2016-01-19T00:00:00,1109,,,CA,201607,,TOYT,PU,RD,1915 PACIFIC AVE,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6418969.8,1817557.6 4274057465,2016-01-19T00:00:00,1112,,,CA,201601,,VOLK,PA,WT,23 18TH AVE,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6418492.2,1817655.8 4274057476,2016-01-19T00:00:00,1114,,,OR,201701,,CHEV,PA,BL,25 18TH AVE,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6418499.6,1817661.2 4274057480,2016-01-19T00:00:00,1115,,,CA,201605,,FORD,VN,WT,35 18TH AVE,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6418536.5,1817687.8 4274057491,2016-01-19T00:00:00,1123,,,CA,201606,,PORS,PA,BL,1419 ABBOT KINNEY BLVD,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6420570,1819253.9 4274057502,2016-01-19T00:00:00,1129,,,CA,201606,,TOYT,PA,PR,1331 ABBOT KINNEY BLVD,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6420097.4,1819400.1 4274057513,2016-01-19T00:00:00,1130,,,CA,,,AUDI,PA,GY,1341 ABBOT KINNEY BLVD,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6420144.5,1819385.5 4274057524,2016-01-19T00:00:00,1131,,,CA,201610,,NISS,PA,RD,1349 ABBOT KINNEY BLVD,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6420182.2,1819373.9 4274057535,2016-01-19T00:00:00,1134,,,CA,201601,,BMW,PA,GY,1353 ABBOT KINNEY BLVD,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6420201,1819368 4274057546,2016-01-19T00:00:00,1137,,,CA,201603,,BMW,PA,BK,1317 ABBOT KINNEY BLVD,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6419960.2,1819442.5 4274057550,2016-01-19T00:00:00,1139,,,CA,201603,,BMW,PA,GY,1231 ABBOT KINNEY BLVD,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6419525.7,1819576.9 4274057561,2016-01-19T00:00:00,1140,,,CA,201608,,FORD,PA,GY,1227 ABBOT KINNEY BLVD,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6419513.6,1819580.6 4274057572,2016-01-19T00:00:00,1141,,,CA,201611,,NISS,PA,SL,1225 ABBOT KINNEY BLVD,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6419507.6,1819582.5 4274057583,2016-01-19T00:00:00,1143,,,CA,201607,,MERZ,PA,BL,1219 ABBOT KINNEY BLVD,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6419489.5,1819588.1 4274057594,2016-01-19T00:00:00,1221,,,CA,201609,,TOYT,PU,WT,46 WINDWARD AVE,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6418305,1818091.3 4274057605,2016-01-19T00:00:00,1228,,,AZ,201712,,MAZD,PA,GY,1905 PACIFIC AVE,00131,51,80.69BS,NO PARK/STREET CLEAN,73,99999,99999 4274057616,2016-01-19T00:00:00,1315,,,CA,201610,,MERZ,PA,BK,1527 CABRILLO AVE,00131,51,80.69BS,NO PARK/STREET CLEAN,73,6420601.6,1818980.7 4274057620,2016-01-19T00:00:00,1340,V6125,,CA,201611,,MAZD,PA,GY,61 WINDWARD AVE E,00131,51,88.13B+,METER EXP.,63,6418361.5,1818132.4 4274057631,2016-01-19T00:00:00,1357,WP8206,,NV,201602,,HYUN,PA,SL,26 WASHINGTON BLVD E,00131,51,88.13B+,METER EXP.,63,6420288.4,1815191.5 4274057653,2016-01-19T00:00:00,1435,,1325,NV,201612,,TOYT,PA,GN,1514 ABBOT KINNEY BLVD,00131,51,80.69C,PARKED OVER TIME LIM,58,6421001,1819096.6 4274057664,2016-01-19T00:00:00,1437,,1325,CA,201603,,NISS,PA,BK,1504 ABBOT KINNEY BLVD,00131,51,80.69C,PARKED OVER TIME LIM,58,6420975,1819117.2 4274057686,2016-01-19T00:00:00,1439,,1325,CA,201603,,BMW,PA,SL,1502 ABBOT KINNEY BLVD,00131,51,80.69C,PARKED OVER TIME LIM,58,6420969.8,1819121.3 4274057690,2016-01-19T00:00:00,1443,,1330,CA,201610,,INFI,PA,BK,1409 ABBOT KINNEY BLVD,00131,51,80.69C,PARKED OVER TIME LIM,58,6420513.1,1819271.5 4274064001,2016-01-19T00:00:00,1005,,,CA,201608,,TOYT,PA,GN,14248 DELANO ST,00363,53,80.69BS,NO PARK/STREET CLEAN,73,6427612.6,1889147.7 4274083726,2016-01-19T00:00:00,1009,SVV333,,CA,201509,,TOYT,PA,BK,710 HELIOTROPE DR,00444,54,88.13B+,METER EXP.,63,6472357.6,1853013.8 4274083730,2016-01-19T00:00:00,1010,,,CA,201509,,TOYT,PA,BK,710 HELIOTROPE DR,00444,54,5204A-,DISPLAY OF TABS,25,6472357.6,1853013.8 4274083741,2016-01-19T00:00:00,1013,SVV447A,,CA,201606,,HOND,PA,WT,840 HELIOTROPE DR,00444,54,88.13B+,METER EXP.,63,6472357.6,1854070.8 4274083774,2016-01-19T00:00:00,1037,VH78,,CA,201605,,AUDI,PA,BK,4650 RUSSELL AV,00444,54,88.13B+,METER EXP.,63,6473662.7,1860540.4 4274083785,2016-01-19T00:00:00,1043,VH169,,CA,201609,,NISS,PA,GY,2050 HILLHURST AV,00444,54,88.13B+,METER EXP.,63,6474661.3,1862172.5 4274083800,2016-01-19T00:00:00,1103,SL378,,CA,201702,,CHEV,PA,SL,4314 SUNSET BL,00444,54,88.13B+,METER EXP.,63,6475972.3,1857020.6 4274083811,2016-01-19T00:00:00,1148,HW437,,CA,201610,,DODG,PA,BK,5645 HOLLYWOOD BL,00444,54,88.13B+,METER EXP.,63,6467016.7,1859544.1 4274083833,2016-01-19T00:00:00,1238,,,CA,201607,,TOYT,PA,GY,1451 KENMORE AVE N,00444,54,22500H,DOUBLE PARKING,68,6471685.8,1857985.1 4274083844,2016-01-19T00:00:00,1303,,,CA,201608,,TOYT,PA,SL,1859 HILLHURST AVE,00444,54,80.56E4+,RED ZONE,93,6474660.6,1860595.6 4274083855,2016-01-19T00:00:00,1340,VH73A,,CA,201609,,HYUN,PA,BK,1814 VERMONT AV N,00444,54,88.13B+,METER EXP.,63,6473338.3,1860306.8 4274083866,2016-01-19T00:00:00,1343,VH77,,CA,201607,,VOLK,VN,TU,4650 RUSSELL AV,00444,54,88.13B+,METER EXP.,63,6473662.7,1860540.4 4274083870,2016-01-19T00:00:00,1558,SL457,,CA,201612,,HOND,PA,SL,2514 SUNSET BL,00444,54,88.13B+,METER EXP.,63,6480173.1,1851450.3 4274083881,2016-01-19T00:00:00,1602,SA77,,CA,201608,,JEEP,PA,BK,2134 SUNSET BL,00444,54,88.13B+,METER EXP.,63,6481432.2,1850655.3 4274083892,2016-01-19T00:00:00,1608,SA64,,CA,201605,,RROV,PA,WT,2151 SUNSET BL,00444,54,88.13B+,METER EXP.,63,6481423.7,1850656.2 4274083903,2016-01-19T00:00:00,1610,SA61,,CA,201610,,MERZ,PA,BK,2131 SUNSET BL,00444,54,88.13B+,METER EXP.,63,6481576,1850672.2 4274083914,2016-01-19T00:00:00,1611,SA59,,CA,,,NISS,PA,SL,2125 SUNSET BL,00444,54,88.13B+,METER EXP.,63,6481637,1850684.3 4274083925,2016-01-19T00:00:00,1615,,,CA,201610,,CHEV,PA,BK,2141 SUNSET BL,00444,54,80.56E1,WHITE ZONE,58,99999,99999 4274083936,2016-01-19T00:00:00,1618,SL225,,CA,201612,,NISS,PA,WT,2719 SUNSET BL,00444,54,88.13B+,METER EXP.,63,6479634.8,1852003.3 4274083951,2016-01-19T00:00:00,1711,SVV441,,CA,,,FORD,PA,BK,840 HELIOTROPE DR,00444,54,88.13B+,METER EXP.,63,6472357.6,1854070.8 4274087882,2016-01-19T00:00:00,725,,,CA,201610,,TOYT,PA,WT,714 ALPINE ST,00674,56,80.56E1,WHITE ZONE,58,6488001,1845579.7 4274087893,2016-01-19T00:00:00,746,,,CA,201604,,CHEV,PA,GY,419 ALVARADO ST S,00674,56,80.70,NO STOPPING/ANTI-GRI,163,6478724,1844737.1 4274087904,2016-01-19T00:00:00,816,WU585,,CA,,,FORD,PA,RD,700 BEACON AV,00674,56,88.13B+,METER EXP.,63,6479183.2,1842299.1 4274087930,2016-01-19T00:00:00,840,,,CA,201512,,CHEV,PA,GY,1116 7TH ST W,00674,56,80.69AP+,NO STOP/STANDING,93,6481574.7,1841028 4274087941,2016-01-19T00:00:00,844,WU1166A,,CA,,,FORD,PA,RD,1101 8TH ST W,00674,56,88.13B+,METER EXP.,63,6481442.1,1840515.3 4274087952,2016-01-19T00:00:00,914,,,CA,,,FORD,PU,WT,745 BEACON AVE,00674,56,80.56E2,YELLOW ZONE,58,6479042.8,1842043.3 4274087974,2016-01-19T00:00:00,1232,,,CA,201606,,HOND,PA,BK,4834 BALTIMORE ST,00674,56,80.73.2,EXCEED 72HRS-ST,68,6497852,1865916.8 4274099583,2016-01-19T00:00:00,826,,,CA,201612,,PONT,PA,RD,21834 SATICOY ST,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6379201.9,1898728.3 4274099594,2016-01-19T00:00:00,829,,,CA,201609,,JEEP,PA,BN,21820 SATICOY ST,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6379262.6,1898728 4274099605,2016-01-19T00:00:00,833,,,CA,,,HOND,PA,GY,21700 SATICOY ST,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6379779.9,1898726 4274099616,2016-01-19T00:00:00,837,,,CA,201607,,MITS,PA,RD,21500 COHASSET ST,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6380547.2,1898062.7 4274099631,2016-01-19T00:00:00,842,,,CA,201606,,FORD,PA,SL,7300 ALABAMA AVE,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6380542.7,1896742.1 4274099642,2016-01-19T00:00:00,844,,,CA,201611,,HOND,PA,WT,7348 ALABAMA AVE,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6380543.7,1897065.4 4274099653,2016-01-19T00:00:00,852,,,CA,201608,,HOND,PA,GY,21701 COHASSET ST,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6379777.5,1898065.9 4274099664,2016-01-19T00:00:00,856,,,CA,201606,,HOND,PA,RD,7248 VASSAR AVE,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6378916.2,1896410.2 4274099686,2016-01-19T00:00:00,902,,,CA,201511,,HOND,MC,SL,21900 VALERIO ST,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6378919.6,1897408.7 4274099690,2016-01-19T00:00:00,1007,,,CA,201606,,DODG,VN,BL,7010 ALABAMA AVE,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6380535.6,1894822.4 4274099701,2016-01-19T00:00:00,1009,,,CA,201606,,NISS,PA,BK,7038 ALABAMA AVE,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6380536.3,1895011.1 4274099712,2016-01-19T00:00:00,1012,,,CA,201612,,HOND,PA,SL,21601 GAULT ST,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6380157.7,1895416.8 4274099723,2016-01-19T00:00:00,1015,,,CA,201612,,TOYT,VN,BK,7123 REMMET AVE,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6380158.3,1895565.7 4274099734,2016-01-19T00:00:00,1021,,,CA,201603,,FORD,PA,BL,21800 HART ST,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6379375.1,1894759.8 4274099745,2016-01-19T00:00:00,1111,3,,CA,201610,,MERZ,PA,WT,8151 DARBY AVE,00371,53,80.58L,PREFERENTIAL PARKING,68,6400407.4,1902350.9 4274099756,2016-01-19T00:00:00,1116,3,,CA,201512,,AUDI,PA,GY,8150 DARBY PL,00371,53,80.58L,PREFERENTIAL PARKING,68,6400661.3,1902350 4274099760,2016-01-19T00:00:00,1210,,,CA,201608,,HOND,PA,GY,7800 FALLBROOK AVE,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6373182.7,1900072.7 4274099782,2016-01-19T00:00:00,1218,,,SD,201606,,FORD,PA,GY,7948 FALLBROOK AVE,00371,53,80.69BS,NO PARK/STREET CLEAN,73,6373186.4,1901059.3 4274099804,2016-01-19T00:00:00,1356,3,,CA,201604,,FORD,PU,SL,18300 CANTARA ST,00371,53,80.58L,PREFERENTIAL PARKING,68,6400919.4,1902606 4274111800,2016-01-19T00:00:00,23,,,CA,201605,,TOYT,PA,BL,1604 NORTH CAHUENGA BOULEVARD,00401,54,80.69B,NO PARKING,73,6461907.6,1858882.6 4274111811,2016-01-19T00:00:00,25,,,CA,201510,,TOYT,PA,OT,1608 NORTH CAHUENGA BOULEVARD,00401,54,80.69B,NO PARKING,73,6461907.5,1858909.7 4274111822,2016-01-19T00:00:00,25,,,CA,201510,,TOYT,PA,OT,1608 NORTH CAHUENGA BOULEVARD,00401,54,5204A-,DISPLAY OF TABS,25,6461907.5,1858909.7 4274111833,2016-01-19T00:00:00,26,,,CA,201605,,CHEV,PA,OT,1612 NORTH CAHUENGA BOULEVARD,00401,54,80.69B,NO PARKING,73,6461907.4,1858936.9 4274111844,2016-01-19T00:00:00,27,,,CA,201608,,ACUR,PA,GY,1612 NORTH CAHUENGA BOULEVARD,00401,54,80.69B,NO PARKING,73,6461907.4,1858936.9 4274111855,2016-01-19T00:00:00,28,,,CA,,,BMW,PA,BK,1618 NORTH CAHUENGA BOULEVARD,00401,54,80.69B,NO PARKING,73,6461907.3,1858977.7 4274111866,2016-01-19T00:00:00,29,,,CA,201602,,HYUN,PA,BK,1618 NORTH CAHUENGA BOULEVARD,00401,54,80.69B,NO PARKING,73,6461907.3,1858977.7 4274111870,2016-01-19T00:00:00,31,,,CA,201611,,TOYT,PA,SL,1626 NORTH CAHUENGA BOULEVARD,00401,54,80.69B,NO PARKING,73,6461907.2,1859032.1 4274111881,2016-01-19T00:00:00,32,,,CA,201601,,HOND,PA,GY,1626 NORTH CAHUENGA BOULEVARD,00401,54,80.69B,NO PARKING,73,6461907.2,1859032.1 4274111892,2016-01-19T00:00:00,32,,,CA,201607,,UNK,PA,GY,1636 NORTH CAHUENGA BOULEVARD,00401,54,80.69B,NO PARKING,73,6461907,1859100 4274111903,2016-01-19T00:00:00,33,,,CA,201611,,ACUR,PA,GY,1636 NORTH CAHUENGA BOULEVARD,00401,54,80.69B,NO PARKING,73,6461907,1859100 4274111914,2016-01-19T00:00:00,34,,,CA,201607,,VOLV,PA,GY,1640 NORTH CAHUENGA BOULEVARD,00401,54,80.69B,NO PARKING,73,6461906.9,1859127.2 4274111925,2016-01-19T00:00:00,35,,,CA,,,MERZ,PA,BK,1636 NORTH CAHUENGA BOULEVARD,00401,54,80.69B,NO PARKING,73,6461907,1859100 4274111936,2016-01-19T00:00:00,40,,,CA,201603,,TOYT,PA,OT,1777 VINE STREET,00401,54,80.69B,NO PARKING,73,6462768.1,1860125.9 4274111940,2016-01-19T00:00:00,44,,,CA,201607,,NISS,PA,OT,1617 COSMO ST,00401,54,80.69B,NO PARKING,73,6462122.6,1858964.5 4274111951,2016-01-19T00:00:00,45,,,CA,201609,,HOND,PA,SL,1617 COSMO ST,00401,54,80.69B,NO PARKING,73,6462122.6,1858964.5 4274111962,2016-01-19T00:00:00,354,47,,CA,201607,,HYUN,PA,WT,7000 OAKWOOD AVE W,00401,54,80.58L,PREFERENTIAL PARKING,68,6457815.8,1851046.6 4274111973,2016-01-19T00:00:00,357,,,CA,201604,,KIA,PA,WT,800 WESTMORELAND AVE S,00401,54,80.56E4+,RED ZONE,93,6474106.7,1843512.8 4274111995,2016-01-19T00:00:00,636,,,CA,201602,,UNK,PA,BK,758 SOUTH PARK VIEW STREET,00401,54,80.56E1,WHITE ZONE,58,6476712.3,1843205.1 4274112006,2016-01-19T00:00:00,638,,,CA,201607,,BMW,PA,BK,748 SOUTH PARK VIEW STREET,00401,54,80.56E1,WHITE ZONE,58,6476744,1843264.3 4274119765,2016-01-19T00:00:00,37,,,CA,201509,,MITS,PA,GN,449 LANDFAIR AVE,00118,51,5204A-,DISPLAY OF TABS,25,6424696.1,1847974.2 4274119776,2016-01-19T00:00:00,46,,,CA,201610,,TOYT,PA,RD,10900 WILKINS AVE,00118,51,80.56E4+,RED ZONE,93,6427863,1842810 4274119780,2016-01-19T00:00:00,55,43,,CA,201605,,FORD,PA,WT,1652 PANDORA AVE,00118,51,80.54H1,OVNIGHT PRK W/OUT PE,68,6432642.2,1843873.7 4274119791,2016-01-19T00:00:00,57,43,,CA,201610,,VOLK,PA,SL,1651 PANDORA AVE,00118,51,80.54H1,OVNIGHT PRK W/OUT PE,68,6432631.2,1843990 4274119802,2016-01-19T00:00:00,103,43,,CA,201608,,INFI,PA,GY,10439 HOLMAN AVE,00118,51,80.54H1,OVNIGHT PRK W/OUT PE,68,6432397.4,1843798.7 4274119813,2016-01-19T00:00:00,131,21,,CA,,,DODG,PA,BK,1960 BENTLEY AVE,00118,51,80.54H1,OVNIGHT PRK W/OUT PE,68,6428384.4,1838718.4 4274119872,2016-01-19T00:00:00,1044,WV615,,CA,201701,,DODG,PA,WT,900 TIVERTON AV,00111,51,88.13B+,METER EXP.,63,6427665.9,1845867.5 4274119883,2016-01-19T00:00:00,1055,WV593,,CA,201608,,HYUN,PA,SL,1000 HILGARD AV,00111,51,88.13B+,METER EXP.,63,6427912.4,1845102.9 4274119894,2016-01-19T00:00:00,1058,WV480,,CA,201602,,VOLK,PA,GY,10801 LINDBROOK DR,00111,51,88.13B+,METER EXP.,63,6428364.4,1844834.9 4274119905,2016-01-19T00:00:00,1108,WV319,,CA,201611,,TOYT,PA,WT,1101 GLENDON AV,00111,51,88.13B+,METER EXP.,63,6427050.6,1844798.1 4274119916,2016-01-19T00:00:00,1109,,,CA,201611,,TOYT,PA,WT,1101 GLENDON AV,00111,51,5200,DISPLAY OF PLATES,25,6427050.6,1844798.1 4274119920,2016-01-19T00:00:00,1110,WV321,,CA,201605,,SMRT,PA,BK,1101 GLENDON AV,00111,51,88.13B+,METER EXP.,63,6427050.6,1844798.1 4274119931,2016-01-19T00:00:00,1114,WV296,,CA,201602,,BMW,PA,BK,10801 LINDBROOK DR,00111,51,88.13B+,METER EXP.,63,6428364.4,1844834.9 4274119942,2016-01-19T00:00:00,1115,WV297,,CA,201608,,GMC,PA,GY,10801 LINDBROOK DR,00111,51,88.13B+,METER EXP.,63,6428364.4,1844834.9 4274119964,2016-01-19T00:00:00,1120,,,CA,201602,,VOLK,PA,GY,10801 KINROSS AV,00111,51,80.56E1,WHITE ZONE,58,6427050.6,1844798.1 4274119986,2016-01-19T00:00:00,1138,WV112,,TN,201605,,CHRY,VN,WT,1000 GAYLEY AV,00111,51,88.13B+,METER EXP.,63,6425985.2,1845233.3 4274119990,2016-01-19T00:00:00,1144,WV206,,CA,201609,,OTHR,MC,BL,1000 BROXTON AVE,00111,51,88.13B+,METER EXP.,63,6426272.9,1845437.7 4274120001,2016-01-19T00:00:00,1154,WV279A,,CA,201612,,DODG,PA,BK,1101 WESTWOOD BLVD,00111,51,88.13B+,METER EXP.,63,6426785.9,1844802.9 4274135670,2016-01-19T00:00:00,635,,,CA,201606,,NISS,PA,GY,2301 THOMAS ST,00645,56,80.56E1,WHITE ZONE,58,6499532.6,1848647.8 4274135681,2016-01-19T00:00:00,640,,,CA,201604,,TOYT,PA,BL,2016 SICHEL ST,00645,56,80.56E1,WHITE ZONE,58,6497173.4,1847153.7 4274135692,2016-01-19T00:00:00,704,,,CA,201611,,SUBA,PA,BL,850 CESAR E CHAVEZ AVE W,00645,56,80.70,NO STOPPING/ANTI-GRI,163,6487317.5,1845024.3 4274135703,2016-01-19T00:00:00,738,,,CA,201610,,INFI,PA,WT,500 LUCAS AVE,00645,56,80.56E1,WHITE ZONE,58,6481940.2,1842740.5 4274135736,2016-01-19T00:00:00,807,,,CA,201603,,CHEV,PA,WT,317 BIXEL ST,00645,56,80.69BS,NO PARK/STREET CLEAN,73,6482948.5,1843373.5 4274135784,2016-01-19T00:00:00,817,,,CA,201607,,TOYT,PA,BL,1201 COURT ST,00645,56,80.69BS,NO PARK/STREET CLEAN,73,6484752.9,1845360.4 4274135806,2016-01-19T00:00:00,824,,,CA,201606,,TOYT,PA,SL,100 EDGEWARE ROAD,00645,56,80.69BS,NO PARK/STREET CLEAN,73,6483582.7,1844697 4274135832,2016-01-19T00:00:00,836,,,CA,201601,,NISS,PA,BK,1260 TEMPLE ST,00645,56,80.69AA+,NO STOP/STAND,93,6484744.8,1846519.9 4274135843,2016-01-19T00:00:00,949,LH227,,CA,,,MAZD,PA,BL,100 AVENUE 24,00645,56,88.13B+,METER EXP.,63,6495957.7,1850120.4 4274135865,2016-01-19T00:00:00,1118,,,CA,201609,,FIAT,PA,RD,200 AVENUE 24,00645,56,80.69BS,NO PARK/STREET CLEAN,73,6495970.6,1849245.9 4274135876,2016-01-19T00:00:00,1119,,,CA,201603,,FORD,PA,GN,200 AVENUE 24,00645,56,80.69BS,NO PARK/STREET CLEAN,73,6495970.6,1849245.9 4274137571,2016-01-19T00:00:00,1633,,,CA,201610,,AUDI,PA,BK,5000 MAYWOOD AVE N,00600,56,80.56E4+,RED ZONE,93,6497599.5,1872175.1 4274137593,2016-01-19T00:00:00,2036,,,CA,,,AUDI,PA,BK,A/F 6735 FOREST LAWN DRIVE,00600,56,22502A,18 IN. CURB/2 WAY,63,6459101.1,1875162.7 4274137604,2016-01-19T00:00:00,2039,,,OH,201606,,BMW,PA,BK,A/F 6767 FOREST LAWN DRIVE,00600,56,22502A,18 IN. CURB/2 WAY,63,6458942.8,1875073 4274139774,2016-01-19T00:00:00,738,,,CA,201601,,VOLK,PA,BK,540 HARVARD BLVD S,00476,54,80.56E2,YELLOW ZONE,58,6469433.7,1851865.7 4274139785,2016-01-19T00:00:00,805,,,CA,201604,,CHEV,PA,BK,400 DETROIT ST S,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6457147.7,1846901.6 4274139796,2016-01-19T00:00:00,806,,,CA,201602,,MITS,PA,WT,400 DETROIT ST S,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6457147.7,1846901.6 4274139800,2016-01-19T00:00:00,806,,,CA,201606,,BMW,PA,GY,400 DETROIT ST S,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6457147.7,1846901.6 4274139811,2016-01-19T00:00:00,808,,,CA,201512,,MERZ,PA,WT,360 DETROIT ST S,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6457148.2,1847184.7 4274139822,2016-01-19T00:00:00,809,,,CA,201610,,TOYT,PA,WT,350 DETROIT ST S,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6457148.3,1847259.2 4274139833,2016-01-19T00:00:00,810,,,CA,201507,,ACUR,PA,WT,318 DETROIT ST S,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6457148.7,1847497.6 4274139844,2016-01-19T00:00:00,811,,,CA,201507,,ACUR,PA,WT,318 DETROIT ST S,00476,54,5204A-,DISPLAY OF TABS,25,6457148.7,1847497.6 4274139855,2016-01-19T00:00:00,812,,,CA,201701,,AUDI,PA,GY,310 DETROIT ST S,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6457148.8,1847557.2 4274139866,2016-01-19T00:00:00,814,,,CA,201607,,TOYT,PA,BL,311 CLOVERDALE AVE,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6456825.2,1847591.6 4274139870,2016-01-19T00:00:00,816,,,CA,201608,,VOLK,PA,SL,443 CLOVERDALE AVE,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6456827.4,1846749.1 4274139881,2016-01-19T00:00:00,818,,,CA,201701,,VOLK,PA,BK,442 COCHRAN AVE,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6456507.2,1846749.2 4274139903,2016-01-19T00:00:00,825,,,CA,,,VOLK,PA,WT,5719 4TH ST W,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6457027.7,1846901.8 4274139914,2016-01-19T00:00:00,826,,,CA,201612,,LEXS,PA,GY,5605 4TH ST W,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6457780.2,1846901.5 4274139925,2016-01-19T00:00:00,831,,,CA,201605,,FIAT,PA,BK,5663 6TH ST W,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6455149.2,1846181.9 4274139936,2016-01-19T00:00:00,834,,,CA,201601,,VOLK,PA,BK,5867 6TH ST W,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6453794.6,1846182.5 4274139940,2016-01-19T00:00:00,834,,,CA,,,JEEP,PA,GY,5867 6TH ST W,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6453794.6,1846182.5 4274139951,2016-01-19T00:00:00,931,,,CA,,,LEXS,PA,WT,6005 6TH ST W,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6452808.1,1846183.6 4274139962,2016-01-19T00:00:00,937,,,CA,201604,,CHEV,PA,SL,6209 6TH ST W,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6451595.5,1846276.9 4274139973,2016-01-19T00:00:00,938,,,CA,201610,,VOLV,PA,RD,6213 6TH ST W,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6451574.9,1846279.8 4274139984,2016-01-19T00:00:00,1032,,,CA,201610,,JEEP,PA,BK,305 LA JOLLA AVE S,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6450240.9,1850302.9 4274139995,2016-01-19T00:00:00,1035,,,CA,201603,,MERZ,PA,WT,8400 4TH ST W,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6448575.5,1848524.8 4274140006,2016-01-19T00:00:00,1054,,,CA,,,CHEV,PA,GY,6730 DREXEL AVE W,00476,54,80.69BS,NO PARK/STREET CLEAN,73,6448337.1,1847948.1 4274142515,2016-01-19T00:00:00,1621,OS775,,CA,,,AUDI,PA,BK,2201 CORINTH AV,00114,51,88.13B+,METER EXP.,63,6427692.6,1836366.8 4274142526,2016-01-19T00:00:00,1701,OS31,,CA,201602,,MERZ,PA,BK,2200 GRANVILLE AV,00114,51,88.13B+,METER EXP.,63,6425378.3,1834767.8 4274142530,2016-01-19T00:00:00,1706,OS107,,CA,201605,,VOLK,PA,SL,11500 OLYMPIC BL W,00114,51,88.13B+,METER EXP.,63,6427126.4,1835963.5 4274142541,2016-01-19T00:00:00,1906,SS34,,CA,201510,,STRN,PA,SL,1501 CORINTH AV,00114,51,88.13B+,METER EXP.,63,6425049.8,1840082.5 4274142552,2016-01-19T00:00:00,1906,,,CA,201510,,STRN,PA,SL,1501 CORINTH AV,00114,51,5204A-,DISPLAY OF TABS,25,6425049.8,1840082.5 4274142563,2016-01-19T00:00:00,1909,SS62,,CA,201608,,JEEP,PA,BL,1501 BUTLER AV,00114,51,88.13B+,METER EXP.,63,6424470.9,1839671.4 4274142574,2016-01-19T00:00:00,1920,OS305,,CA,,,PORS,PA,BK,2100 CORINTH AV,00114,51,88.13B+,METER EXP.,63,6427335.8,1836868.4 4274142585,2016-01-19T00:00:00,1922,OS700,,CA,201602,,VOLK,PA,BK,2201 PURDUE AV,00114,51,88.13B+,METER EXP.,63,6427403.6,1836160.6 4274142596,2016-01-19T00:00:00,1943,OS221B,,CA,201604,,ACUR,PA,SL,2200 SAWTELLE BL,00114,51,88.13B+,METER EXP.,63,6427981.6,1836572.6 4274142600,2016-01-19T00:00:00,1943,OS221,,CA,201510,,VOLK,PA,SL,2200 SAWTELLE BL,00114,51,88.13B+,METER EXP.,63,6427981.6,1836572.6 4274142611,2016-01-19T00:00:00,1950,WS807,,CA,201606,,STRN,PA,BK,1900 PONTIUS AV,00114,51,88.13B+,METER EXP.,63,6427729.8,1838755.8 4274142622,2016-01-19T00:00:00,2142,,,CA,201611,,MASE,PA,BK,2101 CORINTH AV,00114,51,5200,DISPLAY OF PLATES,25,6427335.8,1836868.4 4274142633,2016-01-19T00:00:00,2146,,,CA,201509,,HOND,PA,GY,1957 BELOIT AVE S,00114,51,5204A-,DISPLAY OF TABS,25,6427377.3,1838035 4274142644,2016-01-19T00:00:00,2211,,,CA,201604,,TOYT,PA,BK,11174 CHARNOCK ROAD W,00114,51,80.56E4+,RED ZONE,93,6434273.4,1828519.6 4274142655,2016-01-19T00:00:00,2231,,,CA,201608,,HOND,PA,BK,11114 CHARNOCK ROAD W,00114,51,5200,DISPLAY OF PLATES,25,6434603.9,1828973.4 4274142666,2016-01-19T00:00:00,2244,45,,CA,201606,,HOND,PA,BL,11376 EXPOSITION BLVD,00114,51,80.58L,PREFERENTIAL PARKING,68,6428399.7,1835089.7 4274146951,2016-01-19T00:00:00,132,,,CA,201511,,TOYT,PA,BK,15200 PARTHENIA ST,00300,53,5204A-,DISPLAY OF TABS,25,6420980.3,1905775.2 4274146962,2016-01-19T00:00:00,136,,,CA,,,NISS,PA,WT,15100 PARTHENIA ST,00300,53,22514,FIRE HYDRANT,68,6422285,1905728.8 4274146973,2016-01-19T00:00:00,139,,,CA,,,HYUN,PA,WT,8600 KESTER AVE,00300,53,80.56E4+,RED ZONE,93,6423382.2,1905126.5 4274146984,2016-01-19T00:00:00,143,,,CA,201611,,TOYT,PA,SL,8500 KESTER AVE,00300,53,80.56E4+,RED ZONE,93,6423379,1904475.6 4274146995,2016-01-19T00:00:00,146,,,CA,,,TOYT,PA,SL,14900 CHASE ST,00300,53,80.56E4+,RED ZONE,93,6389648.7,1904601.2 4274147006,2016-01-19T00:00:00,149,,,CA,201512,,NISS,PA,SL,8430 CEDROS AVE,00300,53,22500F,PARKED ON SIDEWALK,68,6424562.3,1904072.9 4274147010,2016-01-19T00:00:00,157,,,CA,201508,,CHEV,TK,SL,14600 PARTHENIA ST,00300,53,5204A-,DISPLAY OF TABS,25,6425547.4,1905316.6 4274147021,2016-01-19T00:00:00,202,,,CA,,,CHEV,PA,WT,8500 CEDROS AVE,00300,53,22500F,PARKED ON SIDEWALK,68,6424564.3,1904478.2 4274147032,2016-01-19T00:00:00,215,,,CA,201511,,VOLV,PA,GY,8600 SEPULVEDA BLVD,00300,53,5204A-,DISPLAY OF TABS,25,6420297,1905130.6 4274147043,2016-01-19T00:00:00,218,,,CA,201511,,CHEV,TK,WT,8600 SEPULVEDA BLVD,00300,53,5204A-,DISPLAY OF TABS,25,6420297,1905130.6 4274147054,2016-01-19T00:00:00,642,,,CA,201701,,STRN,PA,RD,8800 ORION AVE,00300,53,80.56E1,WHITE ZONE,58,6418993.5,1906467.3 4274147065,2016-01-19T00:00:00,703,,,CA,201610,,CHEV,TK,BK,8800 ORION AVE,00300,53,80.69A+,STOP/STAND PROHIBIT,93,6418993.5,1906467.3 4274147076,2016-01-19T00:00:00,707,,,CA,201612,,GMC,VN,RD,8950 LANGDON AVE,00300,53,80.69B,NO PARKING,73,6419666.2,1907445.5 4274165453,2016-01-19T00:00:00,1022,VW610,,CA,201505,,CHEV,PA,GY,601 WESTMORELAND AV S,00463,54,88.13B+,METER EXP.,63,6474107.6,1845000.9 4274165464,2016-01-19T00:00:00,1032,,,CA,201608,,TOYT,PA,GN,2540 BEVERLY BLVD,00463,54,80.56E4+,RED ZONE,93,6478187.7,1847604.4 4274165475,2016-01-19T00:00:00,1036,,,WY,201605,,UNK,MH,WT,2100 VALLEY ST,00463,54,80.69BS,NO PARK/STREET CLEAN,73,6479440.3,1846083 4274165486,2016-01-19T00:00:00,1044,,,CA,201511,,HOND,PA,GN,500 GRAND VIEW ST,00463,54,80.56E4+,RED ZONE,93,6478099.2,1845088.3 4274165490,2016-01-19T00:00:00,1045,,,CA,201511,,HOND,PA,GN,500 GRAND VIEW ST,00463,54,5204A-,DISPLAY OF TABS,25,6478099.2,1845088.3 4274165501,2016-01-19T00:00:00,1046,,,CA,5,,VOLK,PA,BL,500 GRAND VIEW ST,00463,54,22502A,18 IN. CURB/2 WAY,63,6478099.2,1845088.3 4274165512,2016-01-19T00:00:00,1047,,,CA,5,,VOLK,PA,BL,500 GRAND VIEW ST,00463,54,5204A-,DISPLAY OF TABS,25,6478099.2,1845088.3 4274165523,2016-01-19T00:00:00,1056,,,CA,201603,,ACUR,PA,GY,700 MAGNOLIA AVE,00463,54,80.56E4+,RED ZONE,93,6474982.1,1844267.2 4274165534,2016-01-19T00:00:00,1057,,,CA,201603,,ACUR,PA,GY,700 MAGNOLIA AVE,00463,54,5200,DISPLAY OF PLATES,25,6474982.1,1844267.2 4274165545,2016-01-19T00:00:00,1100,,,CA,201608,,DODG,PU,SL,700 MAGNOLIA AVE,00463,54,80.56E4+,RED ZONE,93,6474982.1,1844267.2 4274165556,2016-01-19T00:00:00,1114,WW2146,,CA,201510,,KIA,PA,BL,3600 WILSHIRE BL,00463,54,88.13B+,METER EXP.,63,6469869.4,1844984.6 4274165560,2016-01-19T00:00:00,1114,,,CA,201510,,KIA,PA,BL,3600 WILSHIRE BL,00463,54,5204A-,DISPLAY OF TABS,25,6469869.4,1844984.6 4274165571,2016-01-19T00:00:00,1157,,,CA,201701,,HOND,PA,GY,960 SERRANO AVE S,00463,54,80.69A+,STOP/STAND PROHIBIT,93,6468880,1842144.4 4274165582,2016-01-19T00:00:00,1253,WW1749,,CA,201607,,TOYT,PA,BL,600 SERRANO AV S,00463,54,88.13B+,METER EXP.,63,6468733.3,1852248.6 4274165593,2016-01-19T00:00:00,1305,,,CA,201512,,MERZ,PA,WT,4000 5TH ST W,00463,54,22500E,BLOCKING DRIVEWAY,68,6469184.6,1846305.5 4274165626,2016-01-19T00:00:00,1532,VW958,,CA,201612,,TOYT,PA,GN,200 NEW HAMPSHIRE AV S,00463,54,88.13B+,METER EXP.,63,6472952,1849619.8 4274165630,2016-01-19T00:00:00,1540,WW1988,,CA,201609,,TSMR,PA,GY,3601 WILSHIRE BL,00463,54,88.13B+,METER EXP.,63,6469939.6,1844984.7 4274165641,2016-01-19T00:00:00,1541,,,CA,201609,,TSMR,PA,GY,3601 WILSHIRE BL,00463,54,5200,DISPLAY OF PLATES,25,6469939.6,1844984.7 4274165652,2016-01-19T00:00:00,1610,,,LA,201703,,HOND,PA,WT,3450 WILSHIRE BL,00463,54,80.70,NO STOPPING/ANTI-GRI,163,6471034.3,1844989 4274165663,2016-01-19T00:00:00,1611,,,CA,,,LEXS,PA,WT,3450 WILSHIRE BL,00463,54,80.70,NO STOPPING/ANTI-GRI,163,6471034.3,1844989 4274165674,2016-01-19T00:00:00,1612,,,CA,201602,,MERZ,PA,WT,3450 WILSHIRE BL,00463,54,80.70,NO STOPPING/ANTI-GRI,163,6471034.3,1844989 4274169281,2016-01-19T00:00:00,1009,,,CA,201604,,TOYT,PA,GY,1110 SEWARD ST,00487,54,80.69BS,NO PARK/STREET CLEAN,73,6460791.3,1855633 4274169292,2016-01-19T00:00:00,1011,,,CA,201606,,JEEP,PA,WT,6552 LA MIRADA AVE,00487,54,80.69BS,NO PARK/STREET CLEAN,73,6461101.8,1856552.1 4274169303,2016-01-19T00:00:00,1014,,,CA,201609,,VOLK,PA,SL,6600 FOUNTAIN AVE,00487,54,80.69BS,NO PARK/STREET CLEAN,73,6460789.8,1856899.3 4274169314,2016-01-19T00:00:00,1015,,,CA,201603,,TOYT,PA,GY,6600 FOUNTAIN AVE,00487,54,80.69BS,NO PARK/STREET CLEAN,73,6460789.8,1856899.3 4274169340,2016-01-19T00:00:00,1317,,,CA,201701,,TOYT,PA,SL,501 ROSSMORE AVE N,00487,54,80.69BS,NO PARK/STREET CLEAN,73,6462543.7,1846311.8 4274169362,2016-01-19T00:00:00,1335,,,CA,201602,,BMW,PA,BK,106 LUCERNE BLVD N,00487,54,80.69BS,NO PARK/STREET CLEAN,73,6463300.5,1849073.2 4274169373,2016-01-19T00:00:00,1335,,,CA,201701,,HD,PA,GY,112 LUCERNE BLVD N,00487,54,80.69BS,NO PARK/STREET CLEAN,73,6463300.5,1849030.9 4274169384,2016-01-19T00:00:00,1338,,,AZ,,,KIA,PA,BK,116 LUCERNE BLVD N,00487,54,80.69BS,NO PARK/STREET CLEAN,73,6463300.5,1849002.6 4274169395,2016-01-19T00:00:00,1447,132,,CA,201601,,VOLK,PA,SL,826 ORANGE GROVE AVE N,00487,54,80.58L,PREFERENTIAL PARKING,68,6452509,1853830.5 4274169406,2016-01-19T00:00:00,1452,132,,AZ,201611,,FORD,PA,WT,858 ORANGE GROVE AVE N,00487,54,80.58L,PREFERENTIAL PARKING,68,6452508.5,1854043 4274169410,2016-01-19T00:00:00,1556,,,CA,201609,,NISS,PU,GN,719 KINGSLEY DR N,00487,54,22500E,BLOCKING DRIVEWAY,68,6469869,1844114.4 4274171720,2016-01-19T00:00:00,649,,,CA,,,FRHT,CM,RD,1320 12TH ST E,00688,56,80.69B,NO PARKING,73,6479123.9,1838725.8 4274171731,2016-01-19T00:00:00,651,,,CA,,,FRHT,CM,WT,1320 12TH ST E,00688,56,80.69B,NO PARKING,73,6479123.9,1838725.8 4274171742,2016-01-19T00:00:00,718,,,CA,,,FORD,CM,WT,729 WALL ST S,00688,56,80.49+,18 IN/CURB/COMM VEH,63,6486219.7,1837544.7 4274171764,2016-01-19T00:00:00,727,,,CA,201610,,CHEV,CM,WT,810 GLADYS AVE S,00688,56,22500H,DOUBLE PARKING,68,6487104.6,1835471.2 4274171786,2016-01-19T00:00:00,749,,,CA,,,PTRB,CM,RD,1110 7TH ST E,00688,56,80.69AP+,NO STOP/STANDING,93,6481606.2,1841013.4 4274171790,2016-01-19T00:00:00,750,,,CA,,,PTRB,CM,RD,1110 7TH ST E,00688,56,80.49+,18 IN/CURB/COMM VEH,63,6481606.2,1841013.4 4274171801,2016-01-19T00:00:00,806,CB781,,CA,201611,,HOND,PA,SL,1001 SANTEE ST S,00688,56,88.13B+,METER EXP.,63,6484423.3,1836632.2 4274171812,2016-01-19T00:00:00,811,,,CA,201605,,CHEV,VN,WT,1214 MAIN ST S,00688,56,80.56E2,YELLOW ZONE,58,6483048.3,1836097.2 4274171823,2016-01-19T00:00:00,951,,,OR,,,FORD,PA,BG,565 SAN PEDRO ST S,00688,56,80.56E4+,RED ZONE,93,6487518.4,1838094.5 4274171834,2016-01-19T00:00:00,1105,,0940,CA,,,GEO,PA,GN,515 6TH ST E,00688,56,80.69C,PARKED OVER TIME LIM,58,6484621.7,1839998.3 4274171845,2016-01-19T00:00:00,1108,,0945,CA,201606,,LINC,PA,RD,563 CROCKER ST S,00688,56,80.69C,PARKED OVER TIME LIM,58,6487817.5,1837892.1 4274171856,2016-01-19T00:00:00,1114,,,CA,201607,,NISS,PA,WT,567 SAN PEDRO ST S,00688,56,80.56E2,YELLOW ZONE,58,6487509.8,1838080.2 4274171860,2016-01-19T00:00:00,1121,,0915,CA,201610,,SUBA,PA,SL,601 SAN PEDRO ST S,00688,56,80.69C,PARKED OVER TIME LIM,58,6487371.7,1837852 4274171871,2016-01-19T00:00:00,1124,,0915,CA,201510,,MERC,PA,RD,601 SAN PEDRO ST S,00688,56,80.69C,PARKED OVER TIME LIM,58,6487371.7,1837852 4274171882,2016-01-19T00:00:00,1127,,0915,CA,201606,,PONT,PA,GY,625 SAN PEDRO ST S,00688,56,80.69C,PARKED OVER TIME LIM,58,6487273.2,1837702.6 4274171893,2016-01-19T00:00:00,1129,,0920,CA,201607,,CHEV,PA,BK,625 SAN PEDRO ST S,00688,56,80.69C,PARKED OVER TIME LIM,58,6487273.2,1837702.6 4274171904,2016-01-19T00:00:00,1134,,0930,CA,201607,,HOND,PA,BL,705 CROCKER ST S,00688,56,80.69C,PARKED OVER TIME LIM,58,6486773.4,1836625 4274171926,2016-01-19T00:00:00,1140,,0930,CA,201607,,CHEV,PA,BK,751 CROCKER ST S,00688,56,80.69C,PARKED OVER TIME LIM,58,6486605.5,1836433.5 4274172770,2016-01-19T00:00:00,1017,,,CA,201607,,MNNI,PA,WT,5500 CLINTON ST,00484,54,80.69BS,NO PARK/STREET CLEAN,73,6464257.6,1852263.7 4274172781,2016-01-19T00:00:00,1030,HO484A,,CA,201603,,KIA,PA,BL,6301 YUCCA ST,00484,54,88.13B+,METER EXP.,63,6462767.6,1860299.9 4274172792,2016-01-19T00:00:00,1034,HO626,,CA,,,NISS,PA,BK,1723 WILCOX AV,00484,54,88.13B+,METER EXP.,63,6461453.8,1857898.6 4274172803,2016-01-19T00:00:00,1103,SG32,,CA,201604,,AUDI,PA,BK,7561 SUNSET BL,00484,54,88.13B+,METER EXP.,63,6454449.2,1858246.6 4274172825,2016-01-19T00:00:00,1218,HO101,,CA,201612,,TOYT,PA,GY,1625 SCHRADER BL,00484,54,88.13B+,METER EXP.,63,6461015.4,1859016.1 4274172836,2016-01-19T00:00:00,1221,HO254,,CA,201605,,CADI,PA,BK,6501 SELMA AV,00484,54,88.13B+,METER EXP.,63,6461452.3,1858854.3 4274172840,2016-01-19T00:00:00,1230,,,CA,201603,,PONT,PA,BK,1040 LAS PALMAS AVE N,00484,54,80.69BS,NO PARK/STREET CLEAN,73,6459850,1855177.2 4274172851,2016-01-19T00:00:00,1231,,,CA,201602,,MAZD,PA,GY,1040 LAS PALMAS AVE N,00484,54,80.69BS,NO PARK/STREET CLEAN,73,6459850,1855177.2 4274172862,2016-01-19T00:00:00,1232,,,CA,201608,,CHEV,PA,RD,1040 LAS PALMAS AVE N,00484,54,80.69BS,NO PARK/STREET CLEAN,73,6459850,1855177.2 4274172873,2016-01-19T00:00:00,1237,,,CA,201604,,FIAT,PA,OR,913 SEWARD ST,00484,54,80.69BS,NO PARK/STREET CLEAN,73,6460793,1854383.5 4274172884,2016-01-19T00:00:00,1238,,,AZ,201706,,JEEP,PA,WT,911 SEWARD ST,00484,54,80.69BS,NO PARK/STREET CLEAN,73,6460793,1854361 4274172895,2016-01-19T00:00:00,1239,,,CA,201610,,TOYT,PA,SL,905 SEWARD ST,00484,54,80.69BS,NO PARK/STREET CLEAN,73,6460793.1,1854293.5 4274172906,2016-01-19T00:00:00,1240,,,CA,201605,,LEXS,PA,WT,901 SEWARD ST,00484,54,80.69BS,NO PARK/STREET CLEAN,73,6460793.1,1854248.5 4274172910,2016-01-19T00:00:00,1242,,,CA,,,FIAT,PA,BK,6618 WILLOUGHBY AVE,00484,54,80.69BS,NO PARK/STREET CLEAN,73,6460107.8,1854248.8 4274172921,2016-01-19T00:00:00,1250,SH440,,CA,201611,,JEEP,PA,BK,1101 ORANGE DR N,00484,54,88.13B+,METER EXP.,63,6457313,1842288 4274172932,2016-01-19T00:00:00,1301,,,CA,201608,,MERZ,PA,BK,1745 CAMINO PALMERO,00484,54,80.69BS,NO PARK/STREET CLEAN,73,6455720.1,1859847.6 4274172943,2016-01-19T00:00:00,1305,72,,CA,201603,,TOYT,PA,BK,1852 VISTA ST N,00484,54,80.58L,PREFERENTIAL PARKING,68,6455149.8,1860660.7 4274172954,2016-01-19T00:00:00,1346,HO133B,,CA,201605,,AUDI,PA,WT,1601 WILCOX AV,00484,54,88.13B+,METER EXP.,63,6461453.8,1857762.5 4274172965,2016-01-19T00:00:00,1412,SH194,,CA,201602,,BMW,PA,BK,1001 ORANGE DR N,00484,54,88.13B+,METER EXP.,63,6457536.9,1843363.7 4274172976,2016-01-19T00:00:00,1535,96,,CA,201604,,FORD,PA,SL,1737 ORANGE DR N,00484,54,80.58L,PREFERENTIAL PARKING,68,6458211,1859855.1 4274172980,2016-01-19T00:00:00,1536,96,,CA,201601,,HYUN,PA,SL,1737 ORANGE DR N,00484,54,80.58L,PREFERENTIAL PARKING,68,6458211,1859855.1 4274172991,2016-01-19T00:00:00,1625,SH102,,CA,201511,,BMW,PA,GY,1150 MCCADDEN PL N,00484,54,88.13B+,METER EXP.,63,6459498.5,1855912.2 4274173002,2016-01-19T00:00:00,1626,,,CA,201511,,BMW,PA,GY,1150 MCCADDEN PL N,00484,54,5204A-,DISPLAY OF TABS,25,6459498.5,1855912.2 4274173013,2016-01-19T00:00:00,1716,,,CA,,,RROV,PA,WT,6100 ROMAINE ST,00484,54,80.56E4+,RED ZONE,93,6463433.7,1854904.4 4274175640,2016-01-19T00:00:00,1000,,,CA,201604,,TOYT,PA,SL,5500 CLINTON ST,00474,54,80.69BS,NO PARK/STREET CLEAN,73,6464257.6,1852263.7 4274175651,2016-01-19T00:00:00,1022,LM236,,CA,201701,,VOLK,PA,GY,701 LA BREA AV N,00474,54,88.13B+,METER EXP.,63,6457298.4,1844661.3 4274175662,2016-01-19T00:00:00,1041,30,,CA,201609,,TOYT,PA,GY,735 ALFRED ST N,00474,54,80.58L,PREFERENTIAL PARKING,68,6448035.7,1853237.5 4274175673,2016-01-19T00:00:00,1101,BF375,,CA,201506,,AUDI,PA,BK,7900 MELROSE AV,00474,54,88.13B+,METER EXP.,63,6452230.6,1853079.4 4274175684,2016-01-19T00:00:00,1218,30,,CA,,,BMW,PA,BK,718 CROFT AVE N,00474,54,80.58L,PREFERENTIAL PARKING,68,6448355.1,1853139.6 4274175695,2016-01-19T00:00:00,1242,30,,CA,201610,,HOND,PA,WT,618 EDINBURGH AVE N,00474,54,80.58L,PREFERENTIAL PARKING,68,6451526.2,1852422.6 4274175706,2016-01-19T00:00:00,1325,LC26,,CA,201606,,MNNI,PA,BK,800 LA CIENEGA BL N,00474,54,88.13B+,METER EXP.,63,6447674,1853641.6 4274175721,2016-01-19T00:00:00,1348,30,,CA,201604,,TOYT,PA,SL,718 CROFT AVE N,00474,54,80.58L,PREFERENTIAL PARKING,68,6448355.1,1853139.6

E_money12 · ‎01-19-2020

Hello, I am new to sas and only know basics so please be specific. I have a list of latitudes and longitudes from reported parking citations, but I cant figure out what format they are in and how i could plot them on a sgmap or something similar. There is about 8.8 million observations and I also need a way to group them or sort them so I don't break anything when I run it. Sample of the csv. Ticket number,Issue Date,Issue time,Meter Id,Marked Time,RP State Plate,Plate Expiry Date,VIN,Make,Body Style,Color,Location,Route,Agency,Violation code,Violation Description,Fine amount,Latitude,Longitude 1103341116,2015-12-21T00:00:00,1251,,,CA,200304,,HOND,PA,GY,13147 WELBY WAY,01521,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1103700150,2015-12-21T00:00:00,1435,,,CA,201512,,GMC,VN,WH,525 S MAIN ST,1C51,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1104803000,2015-12-21T00:00:00,2055,,,CA,201503,,NISS,PA,BK,200 WORLD WAY,2R2,2,8939,WHITE CURB,58,6439997.9,1802686.4 1104820732,2015-12-26T00:00:00,1515,,,CA,,,ACUR,PA,WH,100 WORLD WAY,2F11,2,000,17104h,,6440041.1,1802686.2 1105461453,2015-09-15T00:00:00,115,,,CA,200316,,CHEV,PA,BK,GEORGIA ST/OLYMPIC,1FB70,1,8069A,NO STOPPING/STANDING,93,99999,99999 1106226590,2015-09-15T00:00:00,19,,,CA,201507,,CHEV,VN,GY,SAN PEDRO S/O BOYD,1A35W,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1106500452,2015-12-17T00:00:00,1710,,,CA,201605,,MAZD,PA,BL,SUNSET/ALVARADO,00217,1,8070,PARK IN GRID LOCK ZN,163,99999,99999 1106500463,2015-12-17T00:00:00,1710,,,CA,201602,,TOYO,PA,BK,SUNSET/ALVARADO,00217,1,8070,PARK IN GRID LOCK ZN,163,99999,99999 1106506402,2015-12-22T00:00:00,945,,,CA,201605,,CHEV,PA,BR,721 S WESTLAKE,2A75,1,8069AA,NO STOP/STAND AM,93,99999,99999 1106506413,2015-12-22T00:00:00,1100,,,CA,201701,,NISS,PA,SI,1159 HUNTLEY DR,2A75,1,8069AA,NO STOP/STAND AM,93,99999,99999 1106506424,2015-12-22T00:00:00,1100,,,CA,201511,,FORD,TR,WH,1159 HUNTLEY DR,2A75,1,8069AA,NO STOP/STAND AM,93,99999,99999 1106506435,2015-12-22T00:00:00,1105,,,CA,201701,,CHRY,PA,GO,1159 HUNTLEY DR,2A75,1,8069AA,NO STOP/STAND AM,93,99999,99999 1106506446,2015-12-22T00:00:00,1110,,,CA,201511,,BMW,PA,BK,1200 W MIRAMAR,2A75,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1106549754,2015-12-15T00:00:00,825,,,CA,201607,,PTRB,TR,BK,4TH/STATE,CM96,1,8069A,NO STOPPING/STANDING,93,99999,99999 1107179581,2015-12-27T00:00:00,1055,,,CA,201605,,TOYO,PA,BK,3100 N HOLLYRIDGE DR,,54,8058L,PREF PARKING,68,99999,99999 1107179592,2015-12-27T00:00:00,1200,,,CA,201602,,MBNZ,PA,BK,3115 N BERENDO DR,,54,8058L,PREF PARKING,68,99999,99999 1107179603,2015-12-27T00:00:00,1400,,,CA,201611,,NISS,PA,WH,3100 N BEACHWOOD DR,,54,8058L,PREF PARKING,68,99999,99999 1107539823,2015-09-16T00:00:00,2120,,,CA,201502,,NISS,PA,,BLAINE/11TH PL,1FB95,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1107539834,2015-09-16T00:00:00,1045,,,CA,,,CHEV,PA,BK,1246 S FIGUEROA ST,1L20,1,8069AP,NO STOP/STAND PM,93,99999,99999 1107780811,2015-12-22T00:00:00,1102,,,CA,201606,,HOND,PA,BK,PLATA/RAMPART,2A1,1,8069B,NO PARKING,73,99999,99999 1107780822,2015-12-22T00:00:00,1105,,,FL,201611,,FORD,PA,WH,,2A1,1,8069B,NO PARKING,73,99999,99999 1107973985,2015-12-18T00:00:00,1920,,,CA,201509,,NISS,PA,BK,VICAR/CASTLE HEIGHTS,8A95,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1107973996,2015-12-18T00:00:00,1930,,,CA,201511,,HOND,PA,BK,REGENT ST/IVY ST,8A95,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1107978852,2015-12-18T00:00:00,1900,,,CA,201511,,HYUN,PA,SI,1707 GLENDON AV,8A29,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1108311002,2015-12-22T00:00:00,140,,,CA,201603,,FORD,PA,RE,12113 BURBANK BL,01532,1,5200A,DSPLYPLATE A,25,99999,99999 1108311013,2015-12-22T00:00:00,150,,,CA,201610,,FORD,SU,GY,6936 AGNES AV,01514,1,5200A,DSPLYPLATE A,25,99999,99999 1108311024,2015-12-22T00:00:00,205,,,CA,201607,,MASE,PA,BL,12036 SATICOY ST,01503,1,5200A,DSPLYPLATE A,25,99999,99999 1108311035,2015-12-22T00:00:00,200,,,CA,201511,,BMW,PA,BK,7466 LAUREL CYN BL,01503,1,099,5204,25,99999,99999 1108311046,2015-12-22T00:00:00,225,,,CA,201512,,PONT,PA,SI,BURBANK BL/COLFAX AV,01535,1,5200A,DSPLYPLATE A,25,99999,99999 1108311050,2015-12-22T00:00:00,510,,,CA,201601,,TESL,PA,GY,11411 DONA PEGITA DR,,1,5200A,DSPLYPLATE A,25,99999,99999 1108319494,2015-12-22T00:00:00,135,,,CA,201601,,MBNZ,PA,WH,12355 BURBANK BL,01503,1,5200A,DSPLYPLATE A,25,99999,99999 I could use the RP_State_Plate, as a choropleth but I don't know how to do any of that. Here is my the main parts of my code /*Parking Citation /*==========================================================================================================*/ /* Custom Macros */ /*Compressed original imports to a macro for simple use */ /*==========================================================================================================*/ %web_drop_table(WORK.citationstotal); %web_drop_table(WORK.citationsmonthyear); %macro citationsimport (exportname=, infiledataset=); FILENAME &infiledataset; data &exportname; %let _EFIERR_ = 0; infile &infiledataset delimiter=',' MISSOVER DSD firstobs=2; informat "Ticket number"N $32.; informat Issue_Date anydtdtm40.; informat Issue_Time 4.; informat "Meter Id"N $6.; informat "Marked Time"N best32.; informat RP_State_Plate $2.; informat "Plate Expiry Date"N best32.; informat VIN $1.; informat Make $4.; informat "Body Style"N $2.; informat Color $2.; informat Location $16.; informat Route $32.; informat Agency best32.; informat "Violation code"N $20.; informat "Violation Description"N $22.; informat Fine_amount best32.; informat Latitude best32.; informat Longitude best32.; format "Ticket number"N $12.; format Issue_Date datetime.; format Issue_Time 4.; format "Meter Id"N $6.; format "Marked Time"N best12.; format RP_State_Plate $2.; format "Plate Expiry Date"N best12.; format VIN $1.; format Make $4.; format "Body Style"N $2.; format Color $2.; format Location $16.; format Route $12.; format Agency best12.; format "Violation code"N $20.; format "Violation Description"N $22.; format Fine_amount best12.; format Latitude best12.; format Longitude best12.; input "Ticket number"N Issue_Date Issue_Time "Meter Id"N $ "Marked Time"N RP_State_Plate $ "Plate Expiry Date"N VIN $ Make $ "Body Style"N $ Color $ Location $ Route Agency "Violation code"N $ "Violation Description"N $ Fine_amount Latitude Longitude; if _ERROR_ then call symputx('_EFIERR_', 1); run; %MEND; options mprint symbolgen mlogic; %put %citationsimport (exportname=import1, infiledataset='/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations1.csv'); %put %citationsimport (exportname=import2, infiledataset='/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations2.csv'); %put %citationsimport (exportname=import3, infiledataset='/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations3.csv'); %put %citationsimport (exportname=import4, infiledataset='/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations4.csv'); %put %citationsimport (exportname=import5, infiledataset='/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations5.csv'); /*==========================================================================================================*/ /* Data editing and managing */ /*Using Proc SQL improves run time and effeciency with such a large data set. */ /*Producing multiple frequencys */ /*==========================================================================================================*/ proc sql prompt; create table citationstemp AS SELECT * FROM work.import1 OUTER UNION corresponding SELECT * FROM work.import2 OUTER UNION corresponding SELECT * FROM work.import3 OUTER UNION corresponding SELECT * FROM work.import4 OUTER UNION corresponding SELECT * FROM work.import5; create table citationstotal as select *, stnamel(RP_State_Plate) as state length=54, Issue_Date+input(put(Issue_Time, z4.), hhmmss4.) as issue_dttm format=datetime20. from work.citationstemp where not missing(Fine_amount) order by Issue_Date; select "Violation Description"N, count(*) as frequency from work.citationstotal group by "Violation Description"N order by frequency desc; select "Violation code"N, count(*) as frequency from work.citationstotal group by "Violation code"N order by frequency desc; select state, count(*) as frequency from work.citationstotal group by state order by frequency desc; create table citationsdate as select Issue_Date, count(*) as frequency from work.citationstotal where not missing(Issue_Date) group by Issue_Date order by Issue_Date; select * from work.citationstotal (obs=100) where not missing(issue_dttm); create table citationsmonthyear as select *, month(datepart(Issue_Date)) as month, year(datepart(Issue_Date)) as year from work.citationstotal where not missing(Issue_Date) order by Issue_Date; quit; Along with this I would also like to us a sgplot to plot the amount of citations per year on one graph. Like having an overlaping comparison of the year 2017 and 2018 Example of just one year on a graph proc sgplot data=work.citationsdate(where=(datepart(Issue_Date) >='01JAN17'd and datepart(Issue_Date) < '01JAN18'd)); series x=Issue_Date y=frequency / legendlabel="Maximum Number citations"; yaxis label="Number of Citations" valuesformat=comma6.; xaxis label="Date"; run; Please and Thank You.

E_money12 · ‎01-19-2020

Thank You, it now works properly.

E_money12 · ‎01-19-2020

Ticket number,Issue Date,Issue time,Meter Id,Marked Time,RP State Plate,Plate Expiry Date,VIN,Make,Body Style,Color,Location,Route,Agency,Violation code,Violation Description,Fine amount,Latitude,Longitude 1103341116,2015-12-21T00:00:00,1251,,,CA,200304,,HOND,PA,GY,13147 WELBY WAY,01521,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1103700150,2015-12-21T00:00:00,1435,,,CA,201512,,GMC,VN,WH,525 S MAIN ST,1C51,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1104803000,2015-12-21T00:00:00,2055,,,CA,201503,,NISS,PA,BK,200 WORLD WAY,2R2,2,8939,WHITE CURB,58,6439997.9,1802686.4 1104820732,2015-12-26T00:00:00,1515,,,CA,,,ACUR,PA,WH,100 WORLD WAY,2F11,2,000,17104h,,6440041.1,1802686.2 1105461453,2015-09-15T00:00:00,115,,,CA,200316,,CHEV,PA,BK,GEORGIA ST/OLYMPIC,1FB70,1,8069A,NO STOPPING/STANDING,93,99999,99999 1106226590,2015-09-15T00:00:00,19,,,CA,201507,,CHEV,VN,GY,SAN PEDRO S/O BOYD,1A35W,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1106500452,2015-12-17T00:00:00,1710,,,CA,201605,,MAZD,PA,BL,SUNSET/ALVARADO,00217,1,8070,PARK IN GRID LOCK ZN,163,99999,99999 1106500463,2015-12-17T00:00:00,1710,,,CA,201602,,TOYO,PA,BK,SUNSET/ALVARADO,00217,1,8070,PARK IN GRID LOCK ZN,163,99999,99999 1106506402,2015-12-22T00:00:00,945,,,CA,201605,,CHEV,PA,BR,721 S WESTLAKE,2A75,1,8069AA,NO STOP/STAND AM,93,99999,99999 1106506413,2015-12-22T00:00:00,1100,,,CA,201701,,NISS,PA,SI,1159 HUNTLEY DR,2A75,1,8069AA,NO STOP/STAND AM,93,99999,99999 1106506424,2015-12-22T00:00:00,1100,,,CA,201511,,FORD,TR,WH,1159 HUNTLEY DR,2A75,1,8069AA,NO STOP/STAND AM,93,99999,99999 1106506435,2015-12-22T00:00:00,1105,,,CA,201701,,CHRY,PA,GO,1159 HUNTLEY DR,2A75,1,8069AA,NO STOP/STAND AM,93,99999,99999 1106506446,2015-12-22T00:00:00,1110,,,CA,201511,,BMW,PA,BK,1200 W MIRAMAR,2A75,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1106549754,2015-12-15T00:00:00,825,,,CA,201607,,PTRB,TR,BK,4TH/STATE,CM96,1,8069A,NO STOPPING/STANDING,93,99999,99999 1107179581,2015-12-27T00:00:00,1055,,,CA,201605,,TOYO,PA,BK,3100 N HOLLYRIDGE DR,,54,8058L,PREF PARKING,68,99999,99999 1107179592,2015-12-27T00:00:00,1200,,,CA,201602,,MBNZ,PA,BK,3115 N BERENDO DR,,54,8058L,PREF PARKING,68,99999,99999 1107179603,2015-12-27T00:00:00,1400,,,CA,201611,,NISS,PA,WH,3100 N BEACHWOOD DR,,54,8058L,PREF PARKING,68,99999,99999 1107539823,2015-09-16T00:00:00,2120,,,CA,201502,,NISS,PA,,BLAINE/11TH PL,1FB95,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1107539834,2015-09-16T00:00:00,1045,,,CA,,,CHEV,PA,BK,1246 S FIGUEROA ST,1L20,1,8069AP,NO STOP/STAND PM,93,99999,99999 1107780811,2015-12-22T00:00:00,1102,,,CA,201606,,HOND,PA,BK,PLATA/RAMPART,2A1,1,8069B,NO PARKING,73,99999,99999 1107780822,2015-12-22T00:00:00,1105,,,FL,201611,,FORD,PA,WH,,2A1,1,8069B,NO PARKING,73,99999,99999 1107973985,2015-12-18T00:00:00,1920,,,CA,201509,,NISS,PA,BK,VICAR/CASTLE HEIGHTS,8A95,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1107973996,2015-12-18T00:00:00,1930,,,CA,201511,,HOND,PA,BK,REGENT ST/IVY ST,8A95,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1107978852,2015-12-18T00:00:00,1900,,,CA,201511,,HYUN,PA,SI,1707 GLENDON AV,8A29,1,4000A1,NO EVIDENCE OF REG,50,99999,99999 1108311002,2015-12-22T00:00:00,140,,,CA,201603,,FORD,PA,RE,12113 BURBANK BL,01532,1,5200A,DSPLYPLATE A,25,99999,99999 1108311013,2015-12-22T00:00:00,150,,,CA,201610,,FORD,SU,GY,6936 AGNES AV,01514,1,5200A,DSPLYPLATE A,25,99999,99999 1108311024,2015-12-22T00:00:00,205,,,CA,201607,,MASE,PA,BL,12036 SATICOY ST,01503,1,5200A,DSPLYPLATE A,25,99999,99999 1108311035,2015-12-22T00:00:00,200,,,CA,201511,,BMW,PA,BK,7466 LAUREL CYN BL,01503,1,099,5204,25,99999,99999 1108311046,2015-12-22T00:00:00,225,,,CA,201512,,PONT,PA,SI,BURBANK BL/COLFAX AV,01535,1,5200A,DSPLYPLATE A,25,99999,99999 1108311050,2015-12-22T00:00:00,510,,,CA,201601,,TESL,PA,GY,11411 DONA PEGITA DR,,1,5200A,DSPLYPLATE A,25,99999,99999 1108319494,2015-12-22T00:00:00,135,,,CA,201601,,MBNZ,PA,WH,12355 BURBANK BL,01503,1,5200A,DSPLYPLATE A,25,99999,99999 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable _SASWSTEMP_ resolves to /home/u42020802/.sasstudio/.images/9368a2df-c8bd-441b-9b56-3372030d134f SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable GRAPHINIT resolves to GOPTIONS RESET=ALL GSFNAME=_GSFNAME; NOTE: ODS statements in the SAS Studio environment may disable some output features. 71 72 /* 73 Parking Citation 74 /*==========================================================================================================*/ 75 /* Custom Macros*/ 76 /*Compressed original imports to a macro for simple use */ 77 /*==========================================================================================================*/ 78 %web_drop_table(WORK.citationstotal); MLOGIC(WEB_DROP_TABLE): Beginning execution. MLOGIC(WEB_DROP_TABLE): %LET (variable name is NUM) MLOGIC(WEB_DROP_TABLE): %LET (variable name is STEPNEEDED) MLOGIC(WEB_DROP_TABLE): %LET (variable name is STEPSTARTED) MLOGIC(WEB_DROP_TABLE): %LET (variable name is DSNAME) SYMBOLGEN: Macro variable SYSPBUFF resolves to (WORK.citationstotal) SYMBOLGEN: Macro variable NUM resolves to 1 SYMBOLGEN: Macro variable DSNAME resolves to WORK.citationstotal MLOGIC(WEB_DROP_TABLE): %DO %WHILE(&dsname ne) loop beginning; condition is TRUE. SYMBOLGEN: Macro variable DSNAME resolves to WORK.citationstotal MLOGIC(WEB_DROP_TABLE): %IF condition %sysfunc(exist(&dsname)) is FALSE SYMBOLGEN: Macro variable DSNAME resolves to WORK.citationstotal MLOGIC(WEB_DROP_TABLE): %IF condition %sysfunc(exist(&dsname,view)) is FALSE MLOGIC(WEB_DROP_TABLE): %LET (variable name is NUM) SYMBOLGEN: Macro variable NUM resolves to 1 MLOGIC(WEB_DROP_TABLE): %LET (variable name is DSNAME) SYMBOLGEN: Macro variable SYSPBUFF resolves to (WORK.citationstotal) SYMBOLGEN: Macro variable NUM resolves to 2 SYMBOLGEN: Macro variable DSNAME resolves to MLOGIC(WEB_DROP_TABLE): %DO %WHILE() condition is FALSE; loop will not iterate again. SYMBOLGEN: Macro variable STEPSTARTED resolves to 0 MLOGIC(WEB_DROP_TABLE): %IF condition &stepstarted is FALSE MLOGIC(WEB_DROP_TABLE): Ending execution. 79 %web_drop_table(WORK.citationsmonthyear); MLOGIC(WEB_DROP_TABLE): Beginning execution. MLOGIC(WEB_DROP_TABLE): %LET (variable name is NUM) MLOGIC(WEB_DROP_TABLE): %LET (variable name is STEPNEEDED) MLOGIC(WEB_DROP_TABLE): %LET (variable name is STEPSTARTED) MLOGIC(WEB_DROP_TABLE): %LET (variable name is DSNAME) SYMBOLGEN: Macro variable SYSPBUFF resolves to (WORK.citationsmonthyear) SYMBOLGEN: Macro variable NUM resolves to 1 SYMBOLGEN: Macro variable DSNAME resolves to WORK.citationsmonthyear MLOGIC(WEB_DROP_TABLE): %DO %WHILE(&dsname ne) loop beginning; condition is TRUE. SYMBOLGEN: Macro variable DSNAME resolves to WORK.citationsmonthyear MLOGIC(WEB_DROP_TABLE): %IF condition %sysfunc(exist(&dsname)) is FALSE SYMBOLGEN: Macro variable DSNAME resolves to WORK.citationsmonthyear MLOGIC(WEB_DROP_TABLE): %IF condition %sysfunc(exist(&dsname,view)) is FALSE MLOGIC(WEB_DROP_TABLE): %LET (variable name is NUM) SYMBOLGEN: Macro variable NUM resolves to 1 MLOGIC(WEB_DROP_TABLE): %LET (variable name is DSNAME) SYMBOLGEN: Macro variable SYSPBUFF resolves to (WORK.citationsmonthyear) SYMBOLGEN: Macro variable NUM resolves to 2 SYMBOLGEN: Macro variable DSNAME resolves to MLOGIC(WEB_DROP_TABLE): %DO %WHILE() condition is FALSE; loop will not iterate again. SYMBOLGEN: Macro variable STEPSTARTED resolves to 0 MLOGIC(WEB_DROP_TABLE): %IF condition &stepstarted is FALSE MLOGIC(WEB_DROP_TABLE): Ending execution. 80 %macro citationsimport (exportname=, infiledataset=); 81 FILENAME &infiledataset ; 82 data &exportname; 83 %let _EFIERR_ = 0; 84 infile &infiledataset delimiter=',' MISSOVER DSD firstobs=2; 85 informat "Ticket number"N $32.; 86 informat Issue_Date anydtdtm40.; 87 informat Issue_Time $32.; 88 informat "Meter Id"N $6.; 89 informat "Marked Time"N best32.; 90 informat RP_State_Plate $2.; 91 informat "Plate Expiry Date"N best32.; 92 informat VIN $1.; 93 informat Make $4.; 94 informat "Body Style"N $2.; 95 informat Color $2.; 96 informat Location $16.; 97 informat Route $32.; 98 informat Agency best32.; 99 informat "Violation code"N $20.; 100 informat "Violation Description"N $22.; 101 informat Fine_amount best32.; 102 informat Latitude best32.; 103 informat Longitude best32.; 104 format "Ticket number"N $12.; 105 format Issue_Date datetime.; 106 format Issue_Time $12.; 107 format "Meter Id"N $6.; 108 format "Marked Time"N best12.; 109 format RP_State_Plate $2.; 110 format "Plate Expiry Date"N best12.; 111 format VIN $1.; 112 format Make $4.; 113 format "Body Style"N $2.; 114 format Color $2.; 115 format Location $16.; 116 format Route $12.; 117 format Agency best12.; 118 format "Violation code"N $20.; 119 format "Violation Description"N $22.; 120 format Fine_amount best12.; 121 format Latitude best12.; 122 format Longitude best12.; 123 input "Ticket number"N Issue_Date Issue_Time "Meter Id"N $ 124 "Marked Time"N RP_State_Plate $ 125 "Plate Expiry Date"N VIN $ 126 Make $ 127 "Body Style"N $ 128 Color $ 129 Location $ 130 Route Agency "Violation code"N $ 131 "Violation Description"N $ 132 Fine_amount Latitude Longitude; 133 if _ERROR_ then 134 call symputx('_EFIERR_', 1); 135 run; 136 %MEND; 137 options mprint symbolgen mlogic; 138 %put %citationsimport (exportname=import1, 138 ! infiledataset='/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations1.csv'); MLOGIC(CITATIONSIMPORT): Beginning execution. MLOGIC(CITATIONSIMPORT): Parameter EXPORTNAME has value import1 MLOGIC(CITATIONSIMPORT): Parameter INFILEDATASET has value '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations1.csv' SYMBOLGEN: Macro variable INFILEDATASET resolves to '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations1.csv' FILENAME '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations1.csv' SYMBOLGEN: Macro variable EXPORTNAME resolves to import1 MPRINT(CITATIONSIMPORT): data import1; MLOGIC(CITATIONSIMPORT): %LET (variable name is _EFIERR_) SYMBOLGEN: Macro variable INFILEDATASET resolves to '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations1.csv' MPRINT(CITATIONSIMPORT): infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations1.csv' delimiter=',' MISSOVER DSD firstobs=2; MPRINT(CITATIONSIMPORT): informat "Ticket number"N $32.; MPRINT(CITATIONSIMPORT): informat Issue_Date anydtdtm40.; MPRINT(CITATIONSIMPORT): informat Issue_Time $32.; MPRINT(CITATIONSIMPORT): informat "Meter Id"N $6.; MPRINT(CITATIONSIMPORT): informat "Marked Time"N best32.; MPRINT(CITATIONSIMPORT): informat RP_State_Plate $2.; MPRINT(CITATIONSIMPORT): informat "Plate Expiry Date"N best32.; MPRINT(CITATIONSIMPORT): informat VIN $1.; MPRINT(CITATIONSIMPORT): informat Make $4.; MPRINT(CITATIONSIMPORT): informat "Body Style"N $2.; MPRINT(CITATIONSIMPORT): informat Color $2.; MPRINT(CITATIONSIMPORT): informat Location $16.; MPRINT(CITATIONSIMPORT): informat Route $32.; MPRINT(CITATIONSIMPORT): informat Agency best32.; MPRINT(CITATIONSIMPORT): informat "Violation code"N $20.; MPRINT(CITATIONSIMPORT): informat "Violation Description"N $22.; MPRINT(CITATIONSIMPORT): informat Fine_amount best32.; MPRINT(CITATIONSIMPORT): informat Latitude best32.; MPRINT(CITATIONSIMPORT): informat Longitude best32.; MPRINT(CITATIONSIMPORT): format "Ticket number"N $12.; MPRINT(CITATIONSIMPORT): format Issue_Date datetime.; MPRINT(CITATIONSIMPORT): format Issue_Time $12.; MPRINT(CITATIONSIMPORT): format "Meter Id"N $6.; MPRINT(CITATIONSIMPORT): format "Marked Time"N best12.; MPRINT(CITATIONSIMPORT): format RP_State_Plate $2.; MPRINT(CITATIONSIMPORT): format "Plate Expiry Date"N best12.; MPRINT(CITATIONSIMPORT): format VIN $1.; MPRINT(CITATIONSIMPORT): format Make $4.; MPRINT(CITATIONSIMPORT): format "Body Style"N $2.; MPRINT(CITATIONSIMPORT): format Color $2.; MPRINT(CITATIONSIMPORT): format Location $16.; MPRINT(CITATIONSIMPORT): format Route $12.; MPRINT(CITATIONSIMPORT): format Agency best12.; MPRINT(CITATIONSIMPORT): format "Violation code"N $20.; MPRINT(CITATIONSIMPORT): format "Violation Description"N $22.; MPRINT(CITATIONSIMPORT): format Fine_amount best12.; MPRINT(CITATIONSIMPORT): format Latitude best12.; MPRINT(CITATIONSIMPORT): format Longitude best12.; MPRINT(CITATIONSIMPORT): input "Ticket number"N Issue_Date Issue_Time "Meter Id"N $ "Marked Time"N RP_State_Plate $ "Plate Expiry Date"N VIN $ Make $ "Body Style"N $ Color $ Location $ Route Agency "Violation code"N $ "Violation Description"N $ Fine_amount Latitude Longitude; MPRINT(CITATIONSIMPORT): if _ERROR_ then call symputx('_EFIERR_', 1); MPRINT(CITATIONSIMPORT): run; NOTE: The infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations1.csv' is: Filename=/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations1.csv, Owner Name=u42020802,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=14Jan2020:07:17:45, File Size (bytes)=265554821 NOTE: 1999999 records were read from the infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations1.csv'. The minimum record length was 58. The maximum record length was 164. NOTE: The data set WORK.IMPORT1 has 1999999 observations and 19 variables. NOTE: DATA statement used (Total process time): real time 4.43 seconds user cpu time 4.07 seconds system cpu time 0.36 seconds memory 2091.62k OS Memory 30632.00k Timestamp 01/19/2020 08:51:05 AM Step Count 41 Switch Count 2 Page Faults 0 Page Reclaims 230 Page Swaps 0 Voluntary Context Switches 16 Involuntary Context Switches 4 Block Input Operations 0 Block Output Operations 908040 MLOGIC(CITATIONSIMPORT): Ending execution. 139 %put %citationsimport (exportname=import2, 139 ! infiledataset='/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations2.csv'); MLOGIC(CITATIONSIMPORT): Beginning execution. MLOGIC(CITATIONSIMPORT): Parameter EXPORTNAME has value import2 MLOGIC(CITATIONSIMPORT): Parameter INFILEDATASET has value '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations2.csv' SYMBOLGEN: Macro variable INFILEDATASET resolves to '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations2.csv' FILENAME '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations2.csv' SYMBOLGEN: Macro variable EXPORTNAME resolves to import2 MPRINT(CITATIONSIMPORT): data import2; MLOGIC(CITATIONSIMPORT): %LET (variable name is _EFIERR_) SYMBOLGEN: Macro variable INFILEDATASET resolves to '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations2.csv' MPRINT(CITATIONSIMPORT): infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations2.csv' delimiter=',' MISSOVER DSD firstobs=2; MPRINT(CITATIONSIMPORT): informat "Ticket number"N $32.; MPRINT(CITATIONSIMPORT): informat Issue_Date anydtdtm40.; MPRINT(CITATIONSIMPORT): informat Issue_Time $32.; MPRINT(CITATIONSIMPORT): informat "Meter Id"N $6.; MPRINT(CITATIONSIMPORT): informat "Marked Time"N best32.; MPRINT(CITATIONSIMPORT): informat RP_State_Plate $2.; MPRINT(CITATIONSIMPORT): informat "Plate Expiry Date"N best32.; MPRINT(CITATIONSIMPORT): informat VIN $1.; MPRINT(CITATIONSIMPORT): informat Make $4.; MPRINT(CITATIONSIMPORT): informat "Body Style"N $2.; MPRINT(CITATIONSIMPORT): informat Color $2.; MPRINT(CITATIONSIMPORT): informat Location $16.; MPRINT(CITATIONSIMPORT): informat Route $32.; MPRINT(CITATIONSIMPORT): informat Agency best32.; MPRINT(CITATIONSIMPORT): informat "Violation code"N $20.; MPRINT(CITATIONSIMPORT): informat "Violation Description"N $22.; MPRINT(CITATIONSIMPORT): informat Fine_amount best32.; MPRINT(CITATIONSIMPORT): informat Latitude best32.; MPRINT(CITATIONSIMPORT): informat Longitude best32.; MPRINT(CITATIONSIMPORT): format "Ticket number"N $12.; MPRINT(CITATIONSIMPORT): format Issue_Date datetime.; MPRINT(CITATIONSIMPORT): format Issue_Time $12.; MPRINT(CITATIONSIMPORT): format "Meter Id"N $6.; MPRINT(CITATIONSIMPORT): format "Marked Time"N best12.; MPRINT(CITATIONSIMPORT): format RP_State_Plate $2.; MPRINT(CITATIONSIMPORT): format "Plate Expiry Date"N best12.; MPRINT(CITATIONSIMPORT): format VIN $1.; MPRINT(CITATIONSIMPORT): format Make $4.; MPRINT(CITATIONSIMPORT): format "Body Style"N $2.; MPRINT(CITATIONSIMPORT): format Color $2.; MPRINT(CITATIONSIMPORT): format Location $16.; MPRINT(CITATIONSIMPORT): format Route $12.; MPRINT(CITATIONSIMPORT): format Agency best12.; MPRINT(CITATIONSIMPORT): format "Violation code"N $20.; MPRINT(CITATIONSIMPORT): format "Violation Description"N $22.; MPRINT(CITATIONSIMPORT): format Fine_amount best12.; MPRINT(CITATIONSIMPORT): format Latitude best12.; MPRINT(CITATIONSIMPORT): format Longitude best12.; MPRINT(CITATIONSIMPORT): input "Ticket number"N Issue_Date Issue_Time "Meter Id"N $ "Marked Time"N RP_State_Plate $ "Plate Expiry Date"N VIN $ Make $ "Body Style"N $ Color $ Location $ Route Agency "Violation code"N $ "Violation Description"N $ Fine_amount Latitude Longitude; MPRINT(CITATIONSIMPORT): if _ERROR_ then call symputx('_EFIERR_', 1); MPRINT(CITATIONSIMPORT): run; NOTE: The infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations2.csv' is: Filename=/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations2.csv, Owner Name=u42020802,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=14Jan2020:07:17:58, File Size (bytes)=266029385 NOTE: 2000000 records were read from the infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations2.csv'. The minimum record length was 58. The maximum record length was 179. NOTE: The data set WORK.IMPORT2 has 2000000 observations and 19 variables. NOTE: DATA statement used (Total process time): real time 4.45 seconds user cpu time 4.06 seconds system cpu time 0.40 seconds memory 2088.09k OS Memory 30632.00k Timestamp 01/19/2020 08:51:10 AM Step Count 42 Switch Count 2 Page Faults 0 Page Reclaims 134 Page Swaps 0 Voluntary Context Switches 23 Involuntary Context Switches 5 Block Input Operations 0 Block Output Operations 908040 MLOGIC(CITATIONSIMPORT): Ending execution. 140 %put %citationsimport (exportname=import3, 140 ! infiledataset='/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations3.csv'); MLOGIC(CITATIONSIMPORT): Beginning execution. MLOGIC(CITATIONSIMPORT): Parameter EXPORTNAME has value import3 MLOGIC(CITATIONSIMPORT): Parameter INFILEDATASET has value '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations3.csv' SYMBOLGEN: Macro variable INFILEDATASET resolves to '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations3.csv' FILENAME '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations3.csv' SYMBOLGEN: Macro variable EXPORTNAME resolves to import3 MPRINT(CITATIONSIMPORT): data import3; MLOGIC(CITATIONSIMPORT): %LET (variable name is _EFIERR_) SYMBOLGEN: Macro variable INFILEDATASET resolves to '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations3.csv' MPRINT(CITATIONSIMPORT): infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations3.csv' delimiter=',' MISSOVER DSD firstobs=2; MPRINT(CITATIONSIMPORT): informat "Ticket number"N $32.; MPRINT(CITATIONSIMPORT): informat Issue_Date anydtdtm40.; MPRINT(CITATIONSIMPORT): informat Issue_Time $32.; MPRINT(CITATIONSIMPORT): informat "Meter Id"N $6.; MPRINT(CITATIONSIMPORT): informat "Marked Time"N best32.; MPRINT(CITATIONSIMPORT): informat RP_State_Plate $2.; MPRINT(CITATIONSIMPORT): informat "Plate Expiry Date"N best32.; MPRINT(CITATIONSIMPORT): informat VIN $1.; MPRINT(CITATIONSIMPORT): informat Make $4.; MPRINT(CITATIONSIMPORT): informat "Body Style"N $2.; MPRINT(CITATIONSIMPORT): informat Color $2.; MPRINT(CITATIONSIMPORT): informat Location $16.; MPRINT(CITATIONSIMPORT): informat Route $32.; MPRINT(CITATIONSIMPORT): informat Agency best32.; MPRINT(CITATIONSIMPORT): informat "Violation code"N $20.; MPRINT(CITATIONSIMPORT): informat "Violation Description"N $22.; MPRINT(CITATIONSIMPORT): informat Fine_amount best32.; MPRINT(CITATIONSIMPORT): informat Latitude best32.; MPRINT(CITATIONSIMPORT): informat Longitude best32.; MPRINT(CITATIONSIMPORT): format "Ticket number"N $12.; MPRINT(CITATIONSIMPORT): format Issue_Date datetime.; MPRINT(CITATIONSIMPORT): format Issue_Time $12.; MPRINT(CITATIONSIMPORT): format "Meter Id"N $6.; MPRINT(CITATIONSIMPORT): format "Marked Time"N best12.; MPRINT(CITATIONSIMPORT): format RP_State_Plate $2.; MPRINT(CITATIONSIMPORT): format "Plate Expiry Date"N best12.; MPRINT(CITATIONSIMPORT): format VIN $1.; MPRINT(CITATIONSIMPORT): format Make $4.; MPRINT(CITATIONSIMPORT): format "Body Style"N $2.; MPRINT(CITATIONSIMPORT): format Color $2.; MPRINT(CITATIONSIMPORT): format Location $16.; MPRINT(CITATIONSIMPORT): format Route $12.; MPRINT(CITATIONSIMPORT): format Agency best12.; MPRINT(CITATIONSIMPORT): format "Violation code"N $20.; MPRINT(CITATIONSIMPORT): format "Violation Description"N $22.; MPRINT(CITATIONSIMPORT): format Fine_amount best12.; MPRINT(CITATIONSIMPORT): format Latitude best12.; MPRINT(CITATIONSIMPORT): format Longitude best12.; MPRINT(CITATIONSIMPORT): input "Ticket number"N Issue_Date Issue_Time "Meter Id"N $ "Marked Time"N RP_State_Plate $ "Plate Expiry Date"N VIN $ Make $ "Body Style"N $ Color $ Location $ Route Agency "Violation code"N $ "Violation Description"N $ Fine_amount Latitude Longitude; MPRINT(CITATIONSIMPORT): if _ERROR_ then call symputx('_EFIERR_', 1); MPRINT(CITATIONSIMPORT): run; NOTE: The infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations3.csv' is: Filename=/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations3.csv, Owner Name=u42020802,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=14Jan2020:07:18:34, File Size (bytes)=289184419 NOTE: 2000000 records were read from the infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations3.csv'. The minimum record length was 66. The maximum record length was 180. NOTE: The data set WORK.IMPORT3 has 2000000 observations and 19 variables. NOTE: DATA statement used (Total process time): real time 4.52 seconds user cpu time 4.16 seconds system cpu time 0.36 seconds memory 2095.71k OS Memory 30632.00k Timestamp 01/19/2020 08:51:14 AM Step Count 43 Switch Count 2 Page Faults 0 Page Reclaims 130 Page Swaps 0 Voluntary Context Switches 19 Involuntary Context Switches 4 Block Input Operations 0 Block Output Operations 908040 MLOGIC(CITATIONSIMPORT): Ending execution. 141 %put %citationsimport (exportname=import4, 141 ! infiledataset='/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations4.csv'); MLOGIC(CITATIONSIMPORT): Beginning execution. MLOGIC(CITATIONSIMPORT): Parameter EXPORTNAME has value import4 MLOGIC(CITATIONSIMPORT): Parameter INFILEDATASET has value '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations4.csv' SYMBOLGEN: Macro variable INFILEDATASET resolves to '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations4.csv' FILENAME '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations4.csv' SYMBOLGEN: Macro variable EXPORTNAME resolves to import4 MPRINT(CITATIONSIMPORT): data import4; MLOGIC(CITATIONSIMPORT): %LET (variable name is _EFIERR_) SYMBOLGEN: Macro variable INFILEDATASET resolves to '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations4.csv' MPRINT(CITATIONSIMPORT): infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations4.csv' delimiter=',' MISSOVER DSD firstobs=2; MPRINT(CITATIONSIMPORT): informat "Ticket number"N $32.; MPRINT(CITATIONSIMPORT): informat Issue_Date anydtdtm40.; MPRINT(CITATIONSIMPORT): informat Issue_Time $32.; MPRINT(CITATIONSIMPORT): informat "Meter Id"N $6.; MPRINT(CITATIONSIMPORT): informat "Marked Time"N best32.; MPRINT(CITATIONSIMPORT): informat RP_State_Plate $2.; MPRINT(CITATIONSIMPORT): informat "Plate Expiry Date"N best32.; MPRINT(CITATIONSIMPORT): informat VIN $1.; MPRINT(CITATIONSIMPORT): informat Make $4.; MPRINT(CITATIONSIMPORT): informat "Body Style"N $2.; MPRINT(CITATIONSIMPORT): informat Color $2.; MPRINT(CITATIONSIMPORT): informat Location $16.; MPRINT(CITATIONSIMPORT): informat Route $32.; MPRINT(CITATIONSIMPORT): informat Agency best32.; MPRINT(CITATIONSIMPORT): informat "Violation code"N $20.; MPRINT(CITATIONSIMPORT): informat "Violation Description"N $22.; MPRINT(CITATIONSIMPORT): informat Fine_amount best32.; MPRINT(CITATIONSIMPORT): informat Latitude best32.; MPRINT(CITATIONSIMPORT): informat Longitude best32.; MPRINT(CITATIONSIMPORT): format "Ticket number"N $12.; MPRINT(CITATIONSIMPORT): format Issue_Date datetime.; MPRINT(CITATIONSIMPORT): format Issue_Time $12.; MPRINT(CITATIONSIMPORT): format "Meter Id"N $6.; MPRINT(CITATIONSIMPORT): format "Marked Time"N best12.; MPRINT(CITATIONSIMPORT): format RP_State_Plate $2.; MPRINT(CITATIONSIMPORT): format "Plate Expiry Date"N best12.; MPRINT(CITATIONSIMPORT): format VIN $1.; MPRINT(CITATIONSIMPORT): format Make $4.; MPRINT(CITATIONSIMPORT): format "Body Style"N $2.; MPRINT(CITATIONSIMPORT): format Color $2.; MPRINT(CITATIONSIMPORT): format Location $16.; MPRINT(CITATIONSIMPORT): format Route $12.; MPRINT(CITATIONSIMPORT): format Agency best12.; MPRINT(CITATIONSIMPORT): format "Violation code"N $20.; MPRINT(CITATIONSIMPORT): format "Violation Description"N $22.; MPRINT(CITATIONSIMPORT): format Fine_amount best12.; MPRINT(CITATIONSIMPORT): format Latitude best12.; MPRINT(CITATIONSIMPORT): format Longitude best12.; MPRINT(CITATIONSIMPORT): input "Ticket number"N Issue_Date Issue_Time "Meter Id"N $ "Marked Time"N RP_State_Plate $ "Plate Expiry Date"N VIN $ Make $ "Body Style"N $ Color $ Location $ Route Agency "Violation code"N $ "Violation Description"N $ Fine_amount Latitude Longitude; MPRINT(CITATIONSIMPORT): if _ERROR_ then call symputx('_EFIERR_', 1); MPRINT(CITATIONSIMPORT): run; NOTE: The infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations4.csv' is: Filename=/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations4.csv, Owner Name=u42020802,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=14Jan2020:07:19:42, File Size (bytes)=121516107 NOTE: 799052 records were read from the infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations4.csv'. The minimum record length was 64. The maximum record length was 190. NOTE: The data set WORK.IMPORT4 has 799052 observations and 19 variables. NOTE: DATA statement used (Total process time): real time 1.85 seconds user cpu time 1.69 seconds system cpu time 0.17 seconds memory 2091.71k OS Memory 30632.00k Timestamp 01/19/2020 08:51:16 AM Step Count 44 Switch Count 2 Page Faults 0 Page Reclaims 130 Page Swaps 0 Voluntary Context Switches 25 Involuntary Context Switches 2 Block Input Operations 0 Block Output Operations 362760 MLOGIC(CITATIONSIMPORT): Ending execution. 142 %put %citationsimport (exportname=import5, 142 ! infiledataset='/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations5.csv'); MLOGIC(CITATIONSIMPORT): Beginning execution. MLOGIC(CITATIONSIMPORT): Parameter EXPORTNAME has value import5 MLOGIC(CITATIONSIMPORT): Parameter INFILEDATASET has value '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations5.csv' SYMBOLGEN: Macro variable INFILEDATASET resolves to '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations5.csv' FILENAME '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations5.csv' SYMBOLGEN: Macro variable EXPORTNAME resolves to import5 MPRINT(CITATIONSIMPORT): data import5; MLOGIC(CITATIONSIMPORT): %LET (variable name is _EFIERR_) SYMBOLGEN: Macro variable INFILEDATASET resolves to '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations5.csv' MPRINT(CITATIONSIMPORT): infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations5.csv' delimiter=',' MISSOVER DSD firstobs=2; MPRINT(CITATIONSIMPORT): informat "Ticket number"N $32.; MPRINT(CITATIONSIMPORT): informat Issue_Date anydtdtm40.; MPRINT(CITATIONSIMPORT): informat Issue_Time $32.; MPRINT(CITATIONSIMPORT): informat "Meter Id"N $6.; MPRINT(CITATIONSIMPORT): informat "Marked Time"N best32.; MPRINT(CITATIONSIMPORT): informat RP_State_Plate $2.; MPRINT(CITATIONSIMPORT): informat "Plate Expiry Date"N best32.; MPRINT(CITATIONSIMPORT): informat VIN $1.; MPRINT(CITATIONSIMPORT): informat Make $4.; MPRINT(CITATIONSIMPORT): informat "Body Style"N $2.; MPRINT(CITATIONSIMPORT): informat Color $2.; MPRINT(CITATIONSIMPORT): informat Location $16.; MPRINT(CITATIONSIMPORT): informat Route $32.; MPRINT(CITATIONSIMPORT): informat Agency best32.; MPRINT(CITATIONSIMPORT): informat "Violation code"N $20.; MPRINT(CITATIONSIMPORT): informat "Violation Description"N $22.; MPRINT(CITATIONSIMPORT): informat Fine_amount best32.; MPRINT(CITATIONSIMPORT): informat Latitude best32.; MPRINT(CITATIONSIMPORT): informat Longitude best32.; MPRINT(CITATIONSIMPORT): format "Ticket number"N $12.; MPRINT(CITATIONSIMPORT): format Issue_Date datetime.; MPRINT(CITATIONSIMPORT): format Issue_Time $12.; MPRINT(CITATIONSIMPORT): format "Meter Id"N $6.; MPRINT(CITATIONSIMPORT): format "Marked Time"N best12.; MPRINT(CITATIONSIMPORT): format RP_State_Plate $2.; MPRINT(CITATIONSIMPORT): format "Plate Expiry Date"N best12.; MPRINT(CITATIONSIMPORT): format VIN $1.; MPRINT(CITATIONSIMPORT): format Make $4.; MPRINT(CITATIONSIMPORT): format "Body Style"N $2.; MPRINT(CITATIONSIMPORT): format Color $2.; MPRINT(CITATIONSIMPORT): format Location $16.; MPRINT(CITATIONSIMPORT): format Route $12.; MPRINT(CITATIONSIMPORT): format Agency best12.; MPRINT(CITATIONSIMPORT): format "Violation code"N $20.; MPRINT(CITATIONSIMPORT): format "Violation Description"N $22.; MPRINT(CITATIONSIMPORT): format Fine_amount best12.; MPRINT(CITATIONSIMPORT): format Latitude best12.; MPRINT(CITATIONSIMPORT): format Longitude best12.; MPRINT(CITATIONSIMPORT): input "Ticket number"N Issue_Date Issue_Time "Meter Id"N $ "Marked Time"N RP_State_Plate $ "Plate Expiry Date"N VIN $ Make $ "Body Style"N $ Color $ Location $ Route Agency "Violation code"N $ "Violation Description"N $ Fine_amount Latitude Longitude; MPRINT(CITATIONSIMPORT): if _ERROR_ then call symputx('_EFIERR_', 1); MPRINT(CITATIONSIMPORT): run; NOTE: The infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations5.csv' is: Filename=/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations5.csv, Owner Name=u42020802,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=14Jan2020:07:19:14, File Size (bytes)=293636484 NOTE: 2000000 records were read from the infile '/home/u42020802/sasuser.v94/HSPRG/ParkingCitations/parkingcitations5.csv'. The minimum record length was 58. The maximum record length was 191. NOTE: The data set WORK.IMPORT5 has 2000000 observations and 19 variables. NOTE: DATA statement used (Total process time): real time 4.55 seconds user cpu time 4.18 seconds system cpu time 0.38 seconds memory 2091.96k OS Memory 30632.00k Timestamp 01/19/2020 08:51:21 AM Step Count 45 Switch Count 2 Page Faults 0 Page Reclaims 130 Page Swaps 0 Voluntary Context Switches 14 Involuntary Context Switches 5 Block Input Operations 0 Block Output Operations 908040 MLOGIC(CITATIONSIMPORT): Ending execution. 143 /*==========================================================================================================*/ 144 /* Data editing and managing */ 145 /*Using Proc SQL improves run time and effeciency with such a large data set. */ 146 /*Producing multiple frequencys */ 147 /*==========================================================================================================*/ 148 proc sql prompt; 149 create table citationstemp AS SELECT * 150 FROM work.import1 151 OUTER UNION corresponding 152 SELECT * 153 FROM work.import2 154 OUTER UNION corresponding 155 SELECT * 156 FROM work.import3 157 OUTER UNION corresponding 158 SELECT * 159 FROM work.import4 160 OUTER UNION corresponding 161 SELECT * 162 FROM work.import5; NOTE: Table WORK.CITATIONSTEMP created, with 8799051 rows and 19 columns. 163 create table citationstotal as select *, stnamel(RP_State_Plate) as state length=54, 164 Issue_Date*86400 + input(put(Issue_Time,z4.),hhmmss4.) as issue_dttm format=datetime20. from work.citationstemp where 164 ! not missing(Fine_amount) order by Issue_Date; ERROR: Numeric format Z in PUT function requires a numeric argument. ERROR: Numeric format Z in PUT function requires a numeric argument. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 165 166 select "Violation Description"N, count(*) as frequency from work.citationstotal group by "Violation Description"N order 166 ! by frequency desc; ERROR: File WORK.CITATIONSTOTAL.DATA does not exist. 167 select "Violation code"N, count(*) as frequency from work.citationstotal group by "Violation code"N order by frequency 167 ! desc; ERROR: File WORK.CITATIONSTOTAL.DATA does not exist. 168 select state, count(*) as frequency from work.citationstotal group by state order by frequency desc; ERROR: File WORK.CITATIONSTOTAL.DATA does not exist. 169 create table citationsdate as select Issue_Date, count(*) as frequency from work.citationstotal where not 169 ! missing(Issue_Date) group by Issue_Date order by Issue_Date ; NOTE: Statement not executed due to NOEXEC option. 170 select * from work.citationstotal (obs=100) where not missing(issue_dttm) ; ERROR: File WORK.CITATIONSTOTAL.DATA does not exist. 171 create table citationsmonthyear as select *, month(datepart(Issue_Date)) as month, year(datepart(Issue_Date)) as year 171 ! from work.citationstotal where not missing(Issue_Date) order by Issue_Date; NOTE: Statement not executed due to NOEXEC option. 172 select month, count(*) as frequency from work.citationsmonthyear group by month order by month; ERROR: File WORK.CITATIONSMONTHYEAR.DATA does not exist. 173 select year, count(*) as frequency from work.citationsmonthyear group by year order by year; ERROR: File WORK.CITATIONSMONTHYEAR.DATA does not exist. 174 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 12.36 seconds user cpu time 10.50 seconds system cpu time 1.87 seconds memory 13839.50k OS Memory 43452.00k Timestamp 01/19/2020 08:51:33 AM Step Count 46 Switch Count 29 Page Faults 0 Page Reclaims 2349 Page Swaps 0 Voluntary Context Switches 85 Involuntary Context Switches 14 Block Input Operations 0 Block Output Operations 3994120 175 176 177 /*==========================================================================================================*/ 178 /* Data graphs and such */ 179 /*==========================================================================================================*/ 180 ods graphics on / width=8in height=5in; 181 title 'Citations Reported in 2014'; 182 proc sgplot data=work.citationsdate(where= (datepart(Issue_Date) >= '01JAN14'd and datepart(Issue_Date) < '01JAN15'd)); ERROR: File WORK.CITATIONSDATE.DATA does not exist. 183 series x=Issue_Date y=frequency / legendlabel="Maximum Number citations"; ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. 184 yaxis label="Number of Citations" valuesformat=comma6.; 185 xaxis label="Date"; 186 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 244.34k OS Memory 30372.00k Timestamp 01/19/2020 08:51:33 AM Step Count 47 Switch Count 0 Page Faults 0 Page Reclaims 17 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 187 title 'Citations Reported in 2015'; 188 proc sgplot data=work.citationsdate(where= (datepart(Issue_Date) >= '01JAN15'd and datepart(Issue_Date) < '01JAN16'd)); ERROR: File WORK.CITATIONSDATE.DATA does not exist. 189 series x=Issue_Date y=frequency / legendlabel="Maximum Number citations"; ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. 190 yaxis label="Number of Citations" valuesformat=comma6.; 191 xaxis label="Date"; 192 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 248.43k OS Memory 30372.00k Timestamp 01/19/2020 08:51:33 AM Step Count 48 Switch Count 0 Page Faults 0 Page Reclaims 17 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 193 title 'Citations Reported in 2016'; 194 proc sgplot data=work.citationsdate(where= (datepart(Issue_Date) >= '01JAN16'd and datepart(Issue_Date) < '01JAN17'd)); ERROR: File WORK.CITATIONSDATE.DATA does not exist. 195 series x=Issue_Date y=frequency / legendlabel="Maximum Number citations"; ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. 196 yaxis label="Number of Citations" valuesformat=comma6.; 197 xaxis label="Date"; 198 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 251.46k OS Memory 30372.00k Timestamp 01/19/2020 08:51:33 AM Step Count 49 Switch Count 0 Page Faults 0 Page Reclaims 17 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 199 title 'Citations Reported in 2017'; 200 proc sgplot data=work.citationsdate(where= (datepart(Issue_Date) >= '01JAN17'd and datepart(Issue_Date) < '01JAN18'd)); ERROR: File WORK.CITATIONSDATE.DATA does not exist. 201 series x=Issue_Date y=frequency / legendlabel="Maximum Number citations"; ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. 202 yaxis label="Number of Citations" valuesformat=comma6.; 203 xaxis label="Date"; 204 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 251.46k OS Memory 30372.00k Timestamp 01/19/2020 08:51:33 AM Step Count 50 Switch Count 0 Page Faults 0 Page Reclaims 17 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 205 title 'Citations Reported in 2018'; 206 proc sgplot data=work.citationsdate(where= (datepart(Issue_Date) >= '01JAN18'd and datepart(Issue_Date) < '01JAN19'd)); ERROR: File WORK.CITATIONSDATE.DATA does not exist. 207 series x=Issue_Date y=frequency / legendlabel="Maximum Number citations"; ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. 208 yaxis label="Number of Citations" valuesformat=comma6.; 209 xaxis label="Date"; 210 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 251.46k OS Memory 30372.00k Timestamp 01/19/2020 08:51:33 AM Step Count 51 Switch Count 0 Page Faults 0 Page Reclaims 17 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 211 title 'Citations Reported in 2019'; 212 proc sgplot data=work.citationsdate(where= (datepart(Issue_Date) >= '01JAN19'd)); ERROR: File WORK.CITATIONSDATE.DATA does not exist. 213 series x=Issue_Date y=frequency / legendlabel="Maximum Number citations"; ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. 214 yaxis label="Number of Citations" valuesformat=comma6.; 215 xaxis label="Date"; 216 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 239.78k OS Memory 30372.00k Timestamp 01/19/2020 08:51:33 AM Step Count 52 Switch Count 0 Page Faults 0 Page Reclaims 17 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 217 218 219 220 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; SYMBOLGEN: Macro variable GRAPHTERM resolves to GOPTIONS NOACCESSIBLE; 231 Here you go, it is kinda messy. Sorry

E_money12 · ‎01-18-2020

I can't figure out why it wont work now. its just giving me asterisk for the issue_dttm

E_money12 · ‎01-18-2020

Thanks for the help, The data was previously in 1 csv, but it was to large to import to my sas(1.2gb). So I split it up into 5 csvs so I could import it and later put it back together. Would you also happen to know how I could format the longitude & latitude and plot it on a map.

E_money12 · ‎01-18-2020

Hello, I am new to proc SQL and I want to figure out how to apply a stnamel() format to my variable "RP State Plate"N to my table citationstotal within Proc SQL. Here are my code for informats and formats if you need it. %macro citationsimport (exportname=, infiledataset=); FILENAME &infiledataset ; data &exportname; %let _EFIERR_ = 0; infile &infiledataset delimiter=',' MISSOVER DSD firstobs=2; informat "Ticket number"N $32.; informat "Issue Date"N anydtdtm40.; informat "Issue time"N best32.; informat "Meter Id"N $6.; informat "Marked Time"N best32.; informat "RP State Plate"N $2.; informat "Plate Expiry Date"N best32.; informat VIN $1.; informat Make $4.; informat "Body Style"N $2.; informat Color $2.; informat Location $16.; informat Route $32.; informat Agency best32.; informat "Violation code"N $20.; informat "Violation Description"N $22.; informat "Fine amount"N best32.; informat Latitude best32.; informat Longitude best32.; format "Ticket number"N $12.; format "Issue Date"N datetime.; format "Issue time"N best12.; format "Meter Id"N $6.; format "Marked Time"N best12.; format "RP State Plate"N $2.; format "Plate Expiry Date"N best12.; format VIN $1.; format Make $4.; format "Body Style"N $2.; format Color $2.; format Location $16.; format Route $12.; format Agency best12.; format "Violation code"N $20.; format "Violation Description"N $22.; format "Fine amount"N best12.; format Latitude best12.; format Longitude best12.; input "Ticket number"N "Issue Date"N "Issue time"N "Meter Id"N $ "Marked Time"N "RP State Plate"N $ "Plate Expiry Date"N VIN $ Make $ "Body Style"N $ Color $ Location $ Route Agency "Violation code"N $ "Violation Description"N $ "Fine amount"N Latitude Longitude; if _ERROR_ then call symputx('_EFIERR_', 1); run; %MEND; The bold and underline code is where i want to format my variable proc sql; create table citationstemp AS SELECT * FROM work.import1 OUTER UNION corresponding SELECT * FROM work.import2 OUTER UNION corresponding SELECT * FROM work.import3 OUTER UNION corresponding SELECT * FROM work.import4 OUTER UNION corresponding SELECT * FROM work.import5; create table citationstotal as select * from work.citationstemp where not missing("Fine amount"N) order by "Ticket number"N; select "Violation Description"N, count(*) as frequency from work.citationstotal group by "Violation Description"N order by frequency desc; select "Violation code"N, count(*) as frequency from work.citationstotal group by "Violation code"N order by frequency desc; select "RP State Plate"N, count(*) as frequency from work.citationstotal group by "RP State Plate"N order by frequency desc; select * from work.citationstotal (obs=100); quit; Partial Output data. Not necessary, but I also need help trying to combine the issue date and issue time. The issue time is a 24 hour HHMM . Along with changing the latitude and longitude to proper degree values. Thank You.

Online Status	Offline
Date Last Visited	‎01-24-2020 03:20 PM

Re: Formatting latitude and longitude for proc sgmap

Re: Formatting latitude and longitude for proc sgmap

Formatting latitude and longitude for proc sgmap

Re: Appling STNAME Function in PROC SQL and other formats

Re: Appling STNAME Function in PROC SQL and other formats

Re: Appling STNAME Function in PROC SQL and other formats

Re: Appling STNAME Function in PROC SQL and other formats

Appling STNAME Function in PROC SQL and other formats

Re: Appling STNAME Function in PROC SQL and other formats

Re: Appling STNAME Function in PROC SQL and other formats

Re: Appling STNAME Function in PROC SQL and other formats

Re: Formatting latitude and longitude for proc sgmap

Re: Formatting latitude and longitude for proc sgmap

Formatting latitude and longitude for proc sgmap

Re: Appling STNAME Function in PROC SQL and other formats

Re: Appling STNAME Function in PROC SQL and other formats

Re: Appling STNAME Function in PROC SQL and other formats

Re: Appling STNAME Function in PROC SQL and other formats

Appling STNAME Function in PROC SQL and other formats