{"text_format":"2","workbook":"xls","n_sheets":17,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5","Sheet6","Sheet7","Sheet8","Sheet9","Sheet10","Sheet11","Sheet12","Sheet13","Sheet14","Sheet15","Sheet16","Sheet17"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,0,6,4],[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Angela Avakian"]
["Subzone:  C2"]
["259 B 6","I","2009-07-12","5520","SHAVER CT","CODX2009-03691","0","2009-06-22","Inop/Unreg - Car posted on street moved into driveway. Now covered with an opaque car cover and plate is visible from the street. Vehicle registration expired in 2005 (4BDK825) (See VAPX2009-01750)\n"]
["Subzone:  N2"]
["238 F 6","I","2009-07-12","3206","GALLOP CT","CODX2009-03689","0","2009-06-22","Inop/Unreg RED DODGE RAM PK #7G00900 (7G00900) - vehicle was parked on the street and was posted, was moved to driveway and is registered non-op and covered in dirt and cobwebs (see VAPX2009-01790)\n"]
["238 H 5","I","2009-07-22","8429","MORNING SKYE WAY","CODX2009-04032","304908","2009-07-02","OVERGROWN VEGETATION"]
["238 H 6","I","2009-07-19","8144","WOOD MILL PL","CODX2009-03919","304573","2009-06-29","BEE KEEPING"]
["239 A 5","I","2009-07-12","4504","WINTER OAK WAY","CODX2009-03703","304096","2009-06-22","INOP/UNREG BLACK TRANS AM IN THE DRIVEWAY, MISSING REAR BUMPER"]
["258 J 1","I","2009-07-13","7420","MARTIGNETTI CT","CODX2009-03727","303989","2009-06-23","Overgrown vegetation"]
["259 A 1","I","2009-07-14","4693","MONUMENT DR","CODX2009-03762","304406","2009-06-24","JUNK IN THE BACKYARD.  CLAIMS RATS ARE NESTING IN IT AND COMING OVER TO HIS PROPERTY."]
["259 A 2","I","2009-08-04","7140","PREDIAL WAY","CODX2009-03932","304688","2009-06-30","HOUSING: RODENT INFESTATION"]

{"sheet":"Sheet2","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Jess Bermudez"]
["Subzone:  C5"]
["258 C 2","I","2009-07-19","6902","22ND ST","CODX2009-03893","305095","2009-06-29","Tires, metal, Plastic junk, Inop Jeep, Inop Truck\n"]
["317 G 2","R","2009-07-31","4046","43RD ST","CODX2009-03754","0","2009-06-23","JUNK AND RUBBISH, OVERGROWN VEGETATION (PROPERTY VACANT)"]
["317 G 6","I","2009-08-06","6225","39TH ST","CODX2009-03925","304667","2009-06-29","HOUSING: WATER INTRUSION FROM UPSTAIRS UNIT"]
["317 G 6","B",null,"3908","43RD AVE","CODX2009-03924","0","2009-06-29","VOA- PER BID CONDUCTING INSPECTION ACROSS THE STREET,NOTICED THAT GANG MEMBERS ARE RIPPING OF THE BOARDS TO THIS PROPERTY."]
["317 H 2","I","2009-07-12","4541","ORINDA WAY","CODX2009-03700","304229","2009-06-22","7FT ROD IRON FENCE "]
["317 H 2","I","2009-07-19","4015","44TH ST","CODX2009-03911","304567","2009-06-29","VACANT- OVERGROWN VEGETATION"]
["317 H 3","I","2009-07-13","4914","BAKER AVE","CODX2009-03720","0","2009-06-23","INOPERABLE AND/OR UNREGISTERED VEHICLE (VAN)"]
["317 H 5","I","2009-07-20","5835","SAMPSON BLVD","CODX2009-03933","0","2009-06-30","JUNK AND RUBBISH, INOPERABLE AND/OR UNREGISTERED VEHICLE"]
["317 H 5","B",null,"5936","CLOVER MANOR WAY","CODX2009-03935","0","2009-06-30","JUNK AND RUBBISH: HOUSE WAS BURNT OUT AND THE DEBRIS IS OUTSIDE ON FRONT YARD"]
["317 H 5","I","2009-07-20","5845","SAMPSON BLVD","CODX2009-03934","0","2009-06-30","JUNK AND RUBBISH"]

{"sheet":"Sheet3","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,0,6,4],[9,0,9,4],[12,0,12,4],[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Barry Chamberlain"]
["Subzone:  "]
[null,"I","2009-07-15","8501","GERBER RD","CODX2009-03827","0","2009-06-25","CONTROL NUMBER: 2008-UPB-DRS-00086 \"AUTOMOBILE SERVICE STATION, AUTO WASH, AND CONVENIENCE MARKET AND RESTAURANT\""]
["Subzone:  C1"]
["258 F 4","I","2009-07-16","3436","I ST","CODX2009-03877","0","2009-06-26","CONTROL NUMBER: 2008-UPP-DRS-00105 \" \"LIGHT OF THE WORLD CHURCH\" (SUNDAY SCHOLL, AND MULTIPURPOSE ROOM)\nATTACHED PARCEL 215-0062-005-0000"]
["258 G 2","I","2009-07-16","3615","ELKHORN BLVD","CODX2009-03874","0","2009-06-26","CONTROL NUMBER: PLNP2009-00091-TUZ: \"CERTIFIED FARMERS' MARKET\" VALID FROM JULY 1, 2009 TO JULY 1, 2010"]
["Subzone:  C5"]
["317 J 5","I","2009-07-22","5300","GORDON DR","CODX2009-04080","0","2009-07-02","Lawning parking"]
["317 J 5","I","2009-07-22","5301","GORDON DR","CODX2009-04084","0","2009-07-02","Storage of inop/unreg vehicles and J/R on property"]
["Subzone:  C6"]
["338 B 1","I","2009-07-16","6621","FLORIN RD","CODX2009-03876","0","2009-06-26","CONTROL NUMBER: 2008-UPP-00207 \"T-MOBILE\" WIRELESS"]

{"sheet":"Sheet4","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,0,8,4],[16,0,16,4],[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Ty Colston"]
["Subzone:  S4"]
["282 B 5","R","2009-07-28",null,null,"CODX2009-03760","0","2009-06-24","\"0 WHITEROCK RD\" - INOP/UNREG VEHICLES, J&R"]
["340 D 3","I","2009-07-20","11701","SHELDON LAKE DR","CODX2009-03936","0","2009-06-30","INOPERABLE AND/OR UNREGISTERED VEHICLE"]
["340 D 4","I","2009-07-16","11825","SHELDON LAKE DR","CODX2009-03864","304541","2009-06-26","THIS VACANT PROPERTY HAS OVERGROWN WEEDS ATLEAST 12\" HIGH."]
["Subzone:  S5"]
[null,"R","2009-08-03",null,null,"CODX2009-03931","0","2009-06-30","ZONING: WEEDS"]
["339 D 5","I","2009-07-21","7851","LAHONTAN CT","CODX2009-03995","304845","2009-07-01","Roosters at their home."]
["339 D 6","I","2009-07-19","9900","SILVER MEADOW WAY","CODX2009-03915","304644","2009-06-29","MANY COMMERICIAL VEHICLE PARKED IN THE DRIVE-WAY, STREET AND BACKYARD. "]
["380 G 7","I","2009-08-04","11160","NYGAARD LN","CODX2009-03941","0","2009-06-30","BUILDING A DIRTBIKE TRACK WHICH CALLER STATES IS AGAINST COUNTY ORDINANCES. THE TRACK IS EQUIPPED WITH VARIOUS JUMPS AND IS EXTREMELY LARGE."]
["420 A 1","I","2009-07-22","12735","CHEROKEE LN","CODX2009-04051","304744","2009-07-02","THERE IS CHURCH BEING HELD IN A BARN IN THE REAR OF THE PROPERTY AT THE ABOVE ADDRESS. THE CHURCH SERVICE IS BEING HELD AT APPROXIMATELY 5-7PM DAILY. THE SERVICE BRINGS 50-60 CARS. THE CALLER STATES THEY DO NOT HAVE A USE PERMIT."]
["420 C 2","I","2009-07-29","11807","BORDEN RD","CODX2009-03712","304001","2009-06-23","**WEBMAIL**They have large church services 3-4 times per week  Use loud PA system for preaching and music.  Remodeled garage for services.  "]
["420 D 3","I","2009-07-22","13051","IVIE RD","CODX2009-04056","304774","2009-07-02","MAJOR AUTO REPAIR AT THE ABOVE ADDRESS.THERE ARE ABOUT 30 VEHICLES SCATTERED THROUGHOUT THE PROPERTY AND THE CARS ARE BEING SCRAPPED OUT."]
["Subzone:  S9"]
["419 E 2","I","2009-07-22","12916","STOCKTON BLVD","CODX2009-04025","304826","2009-07-02","Abandoned Vehicle in Backyard. "]

{"sheet":"Sheet5","index":4,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Tom Curl"]
["Subzone:  C1"]
["257 G 5","I","2009-09-14","5849","W 2ND ST","CODX2009-03791","304439","2009-06-24","NEIGHBOR CONSTANTLY WORKING ON OR REPAIRING TRUCKS IN DRIVEWAY.\n304884: DISMANTELING AND REPAIR OF VEHICLES IN DRIVEWAY AND FRONT YARD."]
["258 B 2","I","2009-07-19","1801","ELKHORN BLVD","CODX2009-03910","0","2009-06-29","Debris pile in front of property\n"]
["258 C 2","I","2009-07-19","2110","ELKHORN BLVD","CODX2009-03903","304647","2009-06-29","OCCUPIED TRAILER:THERE ARE LIVING IN A MOBILE HOME ON THE PROPERTY BEHIND THE MAIN HOUSE THAT MAY OR NOT HAVE PROPER SEWAGE AND ELECTRICAL HOOK UP."]
["258 C 2","I","2009-09-25","7142","22ND ST","CODX2009-03908","0","2009-06-29","Mobile home without a use permit\n"]
["258 C 2","I","2009-07-19","6920","22ND ST","CODX2009-03895","0","2009-06-29","Gry choptop car, gry mercury, gry ford, red Toyota, covered truck…all inop/unreg\n"]
["258 C 2","I","2009-07-19","6942","22ND ST","CODX2009-03898","0","2009-06-29","Tires, 3 boats (inop/unreg), inop Bronco, inoptrailers, washing machine \n"]
["258 C 2","I","2009-07-19","2119","ELKHORN BLVD","CODX2009-03885","0","2009-06-29","Trash, inop cars, and the landscaping (HSC 17920.3j)"]
["258 C 2","I","2009-07-19","7116","22ND ST","CODX2009-03907","0","2009-06-29","Inops - rust 2 dr, silver 2 dr, trailer, commercial truck\n"]
["258 C 2","I","2009-07-21","6828","22ND ST","CODX2009-04003","0","2009-07-01","Piles of wood, Illegal Business (pallets)\n"]
["258 C 2","I","2009-07-19","6816","22ND ST","CODX2009-03889","0","2009-06-29","Junk, wood, tires, inop blue car, inop Honda, 2 inop trucks \n"]
["258 C 2","I","2009-07-19",null,null,"CODX2009-03900","0","2009-06-29","Tires, 3 boats (inop/unreg), inop Bronco, inoptrailers, washing machine \n"]
["258 C 2","I","2009-08-31","6825","22ND ST","CODX2009-03887","0","2009-06-29","Tires, junk, bikes, wood, old red car, inop truck, inop van, inop red truck, inop red car under tarp\n"]
["258 C 2","I","2009-07-19","7100","22ND ST","CODX2009-03904","0","2009-06-29","16.18.401(w) Weeds"]
["258 C 2","I","2009-07-19","6807","22ND ST","CODX2009-03886","0","2009-06-29","16.18.401(w)  Weeds\n"]
["258 C 2","I","2009-07-19","6832","22ND ST","CODX2009-03890","0","2009-06-29","3 Inop cars in Back yard, metal in backyard\n"]
["258 D 2","I","2009-07-21","7032","26TH ST","CODX2009-03988","0","2009-07-01","Jordan’s Towing Service: This property has been developed for residential use, but it is being used as if it were developed for commercial or industrial use, as a towing yard.  "]
["258 F 1","I","2009-07-14","7306","32ND ST","CODX2009-03776","0","2009-06-24","OPERATING BUSINESS WITH OUT PERMIT \" DEVELOPED FOR RESIDENTIAL BUT USING AS INDUSTRAIL USES."]
["258 G 2","I","2009-07-15","3615","ELKHORN BLVD","CODX2009-03830","0","2009-06-25","CONTROL NUMBER: PLNP2009-00091-TUZ- \"FARMERS' MARKET\" VALID FROM 7-1-09 TO 7-1-10"]
["258 H 5","I","2009-07-20","5969","GEORGIA DR","CODX2009-03927","0","2009-06-30","White Mazda lic# 4393K"]
["258 H 7","I","2009-07-22","5015","LORI JO WAY","CODX2009-04028","0","2009-07-02","PER AMA, INOP/UNREG VEHICLE(S)-1979 SILVER(OXIDIZED)MAZDA CP #299XRQ. THE VEHICLE WAS FROM VAPX2009-01689 BUT WAS MOVED ONTO THE PROPERTY. "]
["259 A 3","I","2009-07-19","6800","WAXWING WAY","CODX2009-03906","304553","2009-06-29","OVERGROWN VEGETATION"]

{"sheet":"Sheet6","index":5,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[6,0,6,4],[9,0,9,4],[11,0,11,4],[14,0,14,4],[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Barbara Fairbanks"]
["Subzone:  C4"]
["278 C 6","I","2009-07-15","2118","EL CAMINO AVE","CODX2009-03841","0","2009-06-25","CONTROL NUMBER: PLNP2009-00114-TUZ \"CARNIVAL\"  VALID JUNE 17-21 AND JUNE 25-28, 2009"]
["Subzone:  C6"]
["338 A 1","I","2009-07-15","6020","FLORIN RD","CODX2009-03844","0","2009-06-25","CONTROL NUMBER: PLNP2009-00094- \"PROMOTIONAL SALE & BANNER\" PROMOTIONAL SALE PERMIT VAILD MAY 22-25, 2009,JULY 3- 5, 2009 AND SEPTEMBER 5-7, 2009. BANNER PERMIT VAILD MAY 15-25, 2009, JUNE 25, JULY 3, 2009, AUGUST 27-SEPTEMBER 5, 2009"]
["338 B 3","I","2009-07-16","7548","STOCKTON BLVD","CODX2009-03872","0","2009-06-26","CONTROL NUMBER: PLNP2009-00108-TCZ: \"TEMPORARY CONCESSION STAND\" VALID FROM JUNE 5,2009- TO JUNE 5,2010"]
["Subzone:  E3"]
["260 E 4","I","2009-07-15","8861","GREENBACK LN","CODX2009-03842","0","2009-06-25","CONTROL NUMBER: PLNP2009-00099-TUZ- \"PROMOTIONAL BANNER\" VALID MAY 20, 2009- JUNE 18,2009"]
["Subzone:  E4"]
["260 F 7","I","2009-07-15","4942","HAZEL AVE","CODX2009-03854","0","2009-06-25","CONTROL NUMBER: PLNP2009-00106- \"PROMOTIONAL BANNER\" VAILD FROM JUNE 5, 2009 TO JULY 4, 2009"]
["260 F 7","I","2009-07-15","5010","HAZEL AVE","CODX2009-03843","0","2009-06-25","CONTROL NUMBER: PLNP2009-00102- \"PROMOTIONAL BANNER\" VAILD FOR JUNE 10-19,2009- SEPTEMBER 1-7,2009, AND DECEMBER 17-24, 2009"]
["Subzone:  S4"]
["280 F 4","I","2009-07-15","12171","TRIBUTARY LN","CODX2009-03853","0","2009-06-25","CONTROL NUMBER: PLNP2009-00109-\" PROMOTIONAL BANNER\" VALID FOR JUNE 12, 2009* TO JULY 11, 2009"]

{"sheet":"Sheet7","index":6,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Brandon Heffley"]
["Subzone:  C6"]
["317 H 6","I","2009-08-04","4719","50TH AVE","CODX2009-03940","304329","2009-06-30","UNIT # 86- Caller states that interior walls in apartment full of cracks & holes, nothing bad enough to see through, but pretty bad.\n"]
["318 B 7","I","2009-07-22","6508","HARLEY WAY","CODX2009-04057","304854","2009-07-02","JUNK AND RUBBISH: MATTRESSES, AND OTHER MISC ITEMS PILED VERY HIGH IN THE BACKYARD."]
["338 C 2","I","2009-07-12","7912","SCOTTSDALE DR","CODX2009-03692","304084","2009-06-22","Junk & Rubbish. Bags of garbage all over the property."]
["338 C 2","R","2009-07-13","8015","68TH AVE","CODX2009-03757","0","2009-06-24","Lawn Parking, J/R and M.A.R."]
["338 D 2","I","2009-07-22","7368","KARA DR","CODX2009-04059","304855","2009-07-02","JUNK AND RUBBISH & INOPREABLE AND/OR UNREGISTERED VEHCILES: TWO TRUCKS AND HOUSEHOLD TRASH IN THE BACKYARD. "]
["338 D 3","I","2009-07-14","8255","MOORHAVEN WAY","CODX2009-03779","304405","2009-06-24","WALK WAY TORN UP OVER 6MONTHS AGO BRICK/AND CONCRET TORN UP. WALKWAY LAYING ALL OVER FRONT YARD. DEAD PLANTS STILL IN STORE CONTAINORS ON FRONT LAWN. BAGS OF CONCRET."]
["338 E 2","I","2009-06-27","7344","FRENCH RD","CODX2009-03880","303405","2009-06-26","SURFACING SEWAGE"]
["338 E 2","I","2009-07-20","7372","FRENCH RD","CODX2009-03952","0","2009-06-30","INOPERABLE AND/OR UNREGISTERED VEHICLE: Vehicles parked at the front of this property are missing parts, licenses, and appear to be partially dismantled and pushed off the side of the driveway.\n"]
["338 G 1","I","2009-07-16","8758","FLORIN RD","CODX2009-03863","304512","2009-06-26","DOING MAJOR AUTO REPAIRS ON PROPERTY, SAYS TOOLS AND AUTO PIECES ARE EVERYWHERE./"]
["338 G 1","I","2009-07-16","7207","GARDNER AVE","CODX2009-03862","304511","2009-06-26","NEIGHBORS ARE DOING MAJOR AUTO REPAIRS AT RESIDENTS..TOOLS AND PIECES OF AUTO EVERYWHERE."]

{"sheet":"Sheet8","index":7,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Krysta Hilarides"]
["Subzone:  C1"]
["258 G 5","I","2009-07-21","3805","SAN NOVADO WAY","CODX2009-03993","304861","2009-07-01","VACANT PROPERTY. DRY WEEDS MORE THAN 2 FEET TALL.  FIRE HAZARD."]
["258 G 6","I","2009-07-12","5400","POPLAR BLVD","CODX2009-03694","0","2009-06-22","OVERGROWTH OF VEGETATION, JUNK AND RUBBISH"]
["258 H 4","I","2009-07-16","5921","LARRY WAY","CODX2009-03881","304535","2009-06-26","an inop brown or burguny truck parked in driveway.  Junk and debris such as tires and other misc trash blows onto the lawn and into neighbors yard."]
["258 H 5","I","2009-07-20","5950","GAY WAY","CODX2009-03929","0","2009-06-30"," Over grown Vegetation and Junk & Rubbish."]
["258 H 5","I","2009-07-20","6149","N HAVEN DR","CODX2009-03928","0","2009-06-30","Vacant property-Abandoned vehicle; Overgrown Vegetation"]
["258 J 3","R","2009-07-10","4340","BLACKJACK WAY","CODX2009-03713","304313","2009-06-23","VOA"]
["258 J 4","I","2009-07-12","6101","DEED CT","CODX2009-03697","304168, 304166","2009-06-22","Fence over 8 ft tall on the side of the back yard , set up on a manufactured berm. Also at least 3 vehicles in the back yard and a dune buggy."]
["258 J 5","I","2009-07-15","5602","HILLSDALE BLVD","CODX2009-03821","304310","2009-06-25","STATES THAT RESIDENTS LETTING PEOPLE SET UP TENTS IN YARD LIVES AT IN UNIT D. ALSO HAVE BABY CHICKS RUNNING AROUND IN COMMON YARD."]
["259 A 3","I","2009-07-22","6805","WAXWING WAY","CODX2009-03905","304555","2009-06-29","OVERGROWN VEGETATION"]
["259 A 5","I","2009-08-03","5758","WALERGA RD","CODX2009-03920","304634","2009-06-29","HOUSING: VECTORS (RATS AND ROACHES)"]
["259 A 5","I","2009-08-03","5758","WALERGA RD","CODX2009-03920","304634","2009-06-29","HOUSING: VECTORS (RATS AND ROACHES)"]
["278 H 1","I","2009-07-13","3901","TRICIA WAY","CODX2009-03732","303990","2009-06-23","OVERGROWN VEGETATION"]

{"sheet":"Sheet9","index":8,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Marina Jauregui"]
["Subzone:  E2"]
[null,"I","2009-07-22","6121","KENNETH AVE","CODX2009-04063","304299","2009-07-02","OVERGROWN VEGETATION"]
["259 D 6","I","2009-07-21","6109","MARWICK WAY","CODX2009-03994","0","2009-07-01","J/R in side yard\n"]
["259 D 7","I","2009-08-04","6037","DENVER DR","CODX2009-03930","304692","2009-06-30","HOUSING: EXPOSED WIRES, ELECTRICAL OUTLETS IN STATE OF DISREPAIR AND MALFUNCTION, SUBFLOORING IN HALL GIVING AWAY, DRY ROT AROUND WINDOWS, FURNACE SHUT OFF BY PG&E DUE TO THERMOSTATE WIRING"]
["259 E 6","I","2009-07-21","6363","TEMPLETON DR","CODX2009-03992","0","2009-07-01","Inop van in driveway"]
["259 F 6","I","2009-07-12","5437","ELSINORE WAY","CODX2009-03706","304171","2009-06-22","RUSTY OLD TRUCK (LT BLUE) TAGS EXP"]
["259 F 6","I","2009-07-19","6618","TEMPLETON DR","CODX2009-03923","304624","2009-06-29","AT THIS HOME THEY ARE RUNNING A CAR DETAILING BUSINESS OUT OF THE GARAGE. ''MOBILE HIGH PRESSURE DETAILING WORK'' SIGN IS ON THE SIDE OF THE VAN.THE VAN IS IN THE STREET WASHING THE CARS TODAY. THERE ARE 5 CARS BEING DETAILED IN THE STRETT DRIVEWAY AND GARAGE"]
["259 G 6","I","2009-07-21","5360","ELSINORE WAY","CODX2009-03986","0","2009-07-01","Lawn parking-- Green Honda on lawn\n"]
["259 G 6","I","2009-07-29","5395","CASTLE ST","CODX2009-03785","0","2009-06-24","Housing:  General dilapidation, gutter on the front of the house is falling off"]
["259 G 7","I","2009-07-21","5329","ELSINORE WAY","CODX2009-03987","0","2009-07-01","Inop/unreg, lawn parking-- Ford Bronco unreg, red van on lawn\n"]
["259 G 7","I","2009-07-21","5309","CASTLE ST","CODX2009-03985","0","2009-07-01","Inop/unreg vehicle-- White Ford truck plate 7V69184\n"]
["259 G 7","I","2009-07-21","5319","BELLFLOWER WAY","CODX2009-03991","0","2009-07-01","Inop/unreg -- Lexus and Acura on property\n"]
["259 G 7","I","2009-07-21","5369","CASTLE ST","CODX2009-03989","0","2009-07-01","Unreg vehicle -- Green Daewoo\n"]
["279 B 2","I","2009-07-30","4225","TYRONE WAY","CODX2009-03824","303959","2009-06-25","RESIDENT HAS BUILT A SHED WITH AN EXTENDED CANOPY, THAT IS SHINGLED WITH ROOFING MATERIAL AND HAS ATTACHED IT THE THE FENCE AT THE BACK PORTION OF THE LOT"]
["279 B 4","I","2009-07-22","5404","GRANT AVE","CODX2009-04041","304788","2009-07-02","OVERGROWN VEGETATION"]
["279 C 2","I","2009-07-13","5730","JEFF WAY","CODX2009-03753","304442","2009-06-23","Junk and rubbish covering the entire backyard.  Rubbish piles have started harboring rodents (rats) that are crawling on the house.  Rubbish piles include in/op motorcycles, tv antennas, air conditioning unit, washer, bicycles.  Gargage is also full from top to bottom with junk."]
["279 C 5","I","2009-07-15","3645","MARCONI AVE","CODX2009-03828","0","2009-06-25","Weeds"]
["279 C 5","I","2009-07-19","3120","COLORADO ST","CODX2009-03899","304682","2009-06-29","JUNK AND RUBBISH: ALL KINDS CONSTRUCTION MATERIAL, BAGS, TRASH/LITTER AT THIS HOUSE\n304685: INOPERABLE AND/OR UNREGISTERED VEHICLE UNDER CAR PORT"]
["279 C 6","I","2009-07-14","5733","MARCONI AVE","CODX2009-03771","0","2009-06-24","** To be done**"]
["279 C 6","I","2009-07-29","2536","GARFIELD AVE","CODX2009-03777","304366","2009-06-24","UNIT # 2- APARTMENT IS INFESTED WITH RATS "]
["279 C 6","I","2009-07-14","2831","CLARK AVE","CODX2009-03758","0","2009-06-24","Lawn parking and storage of inop/unreg vehicles "]
["279 D 1","I","2009-08-04","4859","SAMIA CT","CODX2009-03942","304754","2009-06-30","HOUSING: WATER INTRUSION FROM BATHROOM TO AND THROUGH 1ST FLOOR CEILING."]
["279 F 3","I","2009-08-03","8327","FAIR OAKS BLVD","CODX2009-03902","304559","2009-06-29","HOUSING: UNSAFE ELECTRICAL OUTLETS"]
["279 G 1","I","2009-07-22","4701","JOHNSON DR","CODX2009-04021","304741","2009-07-02","THIS HOME IS RUNNING AN APPLIANCE REPAIR SHOP OR RECYCLING OF APPIANCE OUT OF THE HOME"]
["279 G 1","R","2009-07-16","7306","FALCON RD","CODX2009-03774","0","2009-06-24","VOA"]

{"sheet":"Sheet10","index":9,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Paul Munoz"]
["Subzone:  C1"]
["259 A 3","I","2009-06-30","6678","WEATHERBY WAY","CODX2009-03888","304758","2009-06-29","HOUSING: NO WATER, NO ELECTRICITY"]

{"sheet":"Sheet11","index":10,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Jenneil Parks"]
["Subzone:  N1"]
["237 F 5","I","2009-07-27","425","RAFAEL DR","CODX2009-03860","304506","2009-06-26","HAS STRUCTURE THAT IS COVERED THAT IS TOO CLOSE TO FENCE, ALSO HAS RUBBISH AND DEBRIS IN BACKYARD, AND HAS CHICKEN COOP THAT IS IN BACKYARD THAT IS ON EASMENT."]
["237 G 6","I","2009-07-14","7905","ELMONT AVE","CODX2009-03756","0","2009-06-24","Inop/unreg - White Cadillac (EIM225)ALSO Junk and rubbish - an appliance and pile of brush\n"]
["237 G 6","I","2009-07-28","225","CYPRESS ST","CODX2009-03759","0","2009-06-24","Inop/unreg - BOT839 and 7B49282 and possibly several others -"]
["237 J 6","I","2009-07-16","952","ELVERTA RD","CODX2009-03859","304518","2009-06-26","GREAT-GRANDSON DROVE HIS WHITE RV UP ON THE PROPERTY,LIVING IN IT CONTRARY TO HOMEOWNERS WISHES. HAS CONNECTED POWER CORDS TO THE HOUSE"]
["237 J 7","I","2009-07-15","7717","9TH ST","CODX2009-03805","304279","2009-06-25","VACANT HOUSE. CONSTITUENT STATES WEEDS ON PROPERTY ARE 3 TO 4 FEET HIGH"]
["238 C 6","I","2009-07-13","8045","BELLINGRATH DR","CODX2009-03734","304471","2009-06-23","VOA:CONSTITUENT STATES THAT SQUATTERS HAVE OCCUPIED HOME **NOT A VOA PER JLP, HOWEVER THERE ARE  OCCUPIED RV'S ON THE PROPERTY."]
["257 H 1","I","2009-08-06","7448","6TH ST","CODX2009-04061","304793","2009-07-02","PEOPLE LIVING IN MOTORHOME IN FRONT YARD, POWER CORDS RUNNING FROM MOTORHOME TO HOUSE "]
["257 H 1","I","2009-07-19","417","SILVER CREST CIR","CODX2009-03914","304591","2009-06-29","VACANT- OVERGROWN VEGETATION\n304592: JUNK AND RUBBISH"]
["257 H 1","I","2009-07-21","7448","6TH ST","CODX2009-03983","304746","2009-07-01","ACTUAL ADDRESS IS: 7448 6TH ST, PAGE 257 H1,PARCEL ID 20600350680000. THERE ARE PEOPLE LIVING IN 30' GREEN & WHITE CLASS A MOTORHOME PARKED UP IN THE FRONT YARD\nWITH POWER CORDS GOING FROM THE HOUSE TO THE MOTORHOME."]
["257 H 2","R","2009-07-20","544","O ST","CODX2009-03806","0","2009-06-25","544 O Street- junk and rubbish and inop/unreg\n "]
["257 H 2","I","2009-07-24","512","O ST","CODX2009-03811","0","2009-06-25","JUNK & RUBBISH (BRUSH & WOOD) STRG OF INOP/UNREG (1CV5947)**POSTED ON GATE**"]
["257 H 2","I","2009-07-24","6832","4TH AVE","CODX2009-03837","0","2009-06-25","JUNK & RUBBISH (VEHICLE TOOL CHESTS, METAL BARREL, TIRES, BOXES, APPLIANCES & OTHER ITEMS & DEBRIS) **POSTED ON DOOR**"]
["257 H 2","I","2009-07-24","6829","6TH ST","CODX2009-03814","0","2009-06-25","JUNK & RUBBISH (PAINT CANS & OTHER MISCELLANEOUS ITEMS & DEBRIS)AND STRG INOP/UNREG VEHICLE (913RAX)"]
["257 H 2","I","2009-07-24","6836","4TH AVE","CODX2009-03839","0","2009-06-25","JUNK & RUBBISH (WOOD & TIRE & RUBBISH NEAR GARBAGE CANS)AND STRG INOP/UNREG VEHICLES (5ZAF968)**POSTED ON GATE**"]
["257 H 2","I","2009-07-24","6935","5TH ST","CODX2009-03856","0","2009-06-25","JUNK & RUBBISH (RED TRUCK BED) **POSTED ON GATE**"]
["257 H 2","I","2009-07-24","6929","5TH AVE","CODX2009-03871","0","2009-06-26","STRG INOP/UNREG VEHICLE(S)-(#4MSY460) **HANDED TO MARIAN**"]
["257 H 2","I","2009-07-24","6825","6TH AVE","CODX2009-03817","0","2009-06-25","J&RUBBISH (PLYWOOD, BRUSH & FURNITURE)STRG INOP/UNREG VEHICLE(#3CXB288)**HANDED TO PROPERTY OWNER**"]
["257 H 2","I","2009-07-24","6933","5TH AVE","CODX2009-03870","0","2009-06-26","STRG INOP/UNREG VEHICLE(S)-(#NIX557)**POSTED ON DOOR**"]
["257 H 2","I","2009-07-24","6828","5TH AVE","CODX2009-03878","0","2009-06-26","JUNK & RUBBISH (WOOD) AND STRG INOP/UNREG VEHICLE(S)-(#4B47928)AND YARD PARKING -(#8C97283)**POSTED ON DOOR**"]
["257 H 2","I","2009-07-24","6915","5TH ST","CODX2009-03852","0","2009-06-25","junk & rubbish (couch, chair, file cabinet, wood, buckets, & other miscellaneous items & debris) **handed to KIM proper owner adult daughter**"]
["257 H 2","I","2009-07-24","6833","6TH ST","CODX2009-03813","0","2009-06-25","JUNK & RUBBISH (IN SIDE YARD-SMALL AMOUNT) AND STRG INOP/UNREG VEHICLE-(ZGB021)**POSTED ON DOOR**"]
["257 H 2","I","2009-07-24","533","M ST","CODX2009-03807","0","2009-06-25","YARD PARKING - **HANDED TO JONI"]
["257 H 2","I","2009-07-24","6826","4TH AVE","CODX2009-03835","0","2009-06-25","JUNK & RUBBISH (APPLIANCES, TIRES, BOXES, ETC)AND STRG INOP/UNREG VEHICLE(3JTT235 & VAN IN REAR) **HANDED TO TERRI WILDER G-FRIEND**"]
["257 H 2","I","2009-07-24","404","O ST","CODX2009-03810","0","2009-06-25","JUNK & RUBBISH (APPLIANCE) STRG OF INOP/UNREG (?BOAT/TRAILER)**POSTED ON GATE**"]
["257 H 2","I","2009-07-24","621","N ST","CODX2009-03819","0","2009-06-25","J&RUBBISH (WOOD/AUTO PARTS & OTHER MISCELLANEOUS ITEMS & DEBRIS)AND STRG INOP/UNREG VEHICLE (CAR ON JACKS) **HANDED TO LOIS LEE**"]
["257 H 2","I","2009-07-24","529","N ST","CODX2009-03822","0","2009-06-25","J&RUBBISH (BOXES, BUCKETS, CHRISTMAS TREE AND OR BRUSH)AND STRG INOP/UNREG VEHICLE (3VNL257)**GAVE TO PROPERTY OWNER JIMMIE**"]
["257 H 2","I","2009-07-24","6830","6TH AVE","CODX2009-03815","0","2009-06-25","JUNK & RUBBISH (DISHWASHER,FURNITURE,WIRE CAGES,AND OTHER MISCELLANEOUS ITEMS & DEBRIS)**POSTED ON PROPERTY**"]
["257 H 2","I","2009-07-24","6936","5TH AVE","CODX2009-03869","0","2009-06-26","MAJOR AUTO REPAIR OR MINOR (301-04.5) REPAIR IN VIOLATION OF ZONING CODE (#5BMJ821)AND STRG INOP/UNREG VEHICLE(S)-(#5BMJ821)AND YARD PARKING (BOAT)**POSTED ON DOOR**"]
["257 H 2","I","2009-07-24","6936","5TH AVE","CODX2009-03869","0","2009-06-26","MAJOR AUTO REPAIR OR MINOR (301-04.5) REPAIR IN VIOLATION OF ZONING CODE (#5BMJ821)AND STRG INOP/UNREG VEHICLE(S)-(#5BMJ821)AND YARD PARKING (BOAT)**POSTED ON DOOR**"]
["257 H 2","I","2009-07-24","501","N ST","CODX2009-03850","0","2009-06-25","MAJOR AUTO REPAIR (SEE YELLOW SHEET FOR AUTO REPAIR GUIDELINES) AND STRG INOP/UNREG VEHICLE(S) (WHITE CAMARO)**HANDED TO PROPERTY OWNERS DAUGHTER-DAWN**"]
["257 H 2","I","2009-07-24","6928","5TH ST","CODX2009-03855","0","2009-06-25","JUNK & RUBBISH (BRUSH, TIRES, CAR BODY PARTS)**POSTED ON GATE**"]
["257 H 2","I","2009-07-24","6821","5TH ST","CODX2009-03846","0","2009-06-25","MAJOR AUTO REPAIR (AUTO RESTORATION-ENGINE HOIST) AND STRG OF INOP/UNREG VEHICLE(YZS192 & OTHERS IN REAR?)**POSTED ON GATE**"]
["257 H 2","I","2009-07-24","6832","5TH AVE","CODX2009-03875","0","2009-06-26","YARD PARKING (#3PGA709) **HANDED TO PROP OWNER RANDY**"]
["257 H 2","I","2009-07-24","538","O ST","CODX2009-03812","0","2009-06-25","STRG INOPO/UNREG VEHICLE (6M47844 & 3MMH860) **HANDED TO TENANT DEBORAH**"]
["257 H 2","I","2009-07-24","6824","4TH AVE","CODX2009-03833","0","2009-06-25","STRG INOP/UNREG VEHICLE (2PAS456)**posted on door**"]
["257 H 2","I","2009-07-24","6936","5TH ST","CODX2009-03868","0","2009-06-26","JUNK & RUBBISH (INSIDE CARPORT)AND STRG INOP/UNREG VEHICLE(S)(IN REAR YARD & IN CARPORT - GRAY TRUCK BODY)**POSTED ON GATE**"]
["257 H 2","I","2009-07-24","535","N ST","CODX2009-03820","0","2009-06-25","STRG INOP/UNREG VEHICLE (3R15595 & 3PFW447)**POSTED ON DOOR**"]
["257 H 2","I","2009-07-24","418","N ST","CODX2009-03825","0","2009-06-25","J&RUBBISH, FAILURE TO COMPLY-ZONING REQRMENTS-HME OCCUPA (STRG COMMERCIAL VEHICLE & COMMERCIAL EQUIPMENT), STRG COMMERCIAL VEHICLE,STRG OF INOP/UNREG VEHICLE (NUMEROUS VEHILCE #1KH6643-ABANDONED?) **HANDED TO 420 & PUT IN DOOR @ 418**"]
["257 H 2","I","2009-07-24","6901","5TH ST","CODX2009-03847","0","2009-06-25","STRG OF INOP/UNREG VEHICLE (4VFZ832 & 7S84903)**POSTED ON DOOR**"]
["257 H 2","I","2009-07-24","6918","CORONATION CT","CODX2009-03826","0","2009-06-25","YARD PARKING (7G60603)**POSTED ON PROPERTY**"]
["257 H 2","I","2009-07-24","6838","5TH AVE","CODX2009-03873","0","2009-06-26","JUNK & RUBBISH (TIRES & WOOD)**HANDED TO ESPERANZA**"]
["257 H 2","I","2009-07-24","6844","4TH AVE","CODX2009-03840","0","2009-06-25","JUNK & RUBBISH ( FILE CABINET, REFRIGERATOR, PLASTIC BARRELS, & MISCELLANEOUS ITEMS AND DEBRIS)AND STRG OF INOP/UNREG VEHICLE(TRAILER?)AND YARD PARKING (RED CAR)**HANDED TO SON DERICK**"]
["257 H 2","I","2009-07-24","6833","6TH AVE","CODX2009-03818","0","2009-06-25","J&RUBBISH (EQUIPMENT & BOXES)AND FAILURE-COMPLY W/ZONING CODE REQMNTS-HM OCCUP (STRG OF COMMERCIAL EQUIPMENT)AND YARD PARKING (6J79888) **POSTED ON DOOR**"]
["257 H 2","I","2009-07-24","6848","RIO LINDA BLVD","CODX2009-03809","0","2009-06-25","YARD PARKING (#8M72932) **POSTED ON DOOR**"]
["257 H 2","I","2009-07-24","6844","RIO LINDA BLVD","CODX2009-03808","0","2009-06-25","JUNK & RUBBISH, STRG INOP/UNREG VEHICLE (5N86369-EXPIRED 2006)**HANDED TO DARLENE"]
["257 H 2","I","2009-07-24","6821","5TH AVE","CODX2009-03879","0","2009-06-26","STRG INOP/UNREG VEHICLE(S)-(#3JRH606)**HANDED TO SON TENANT**"]
["257 H 2","I","2009-07-19","6837","6TH ST","CODX2009-03916","304811","2009-06-29","PER CTZN, FRONT YARD WAS MOWED BUT REAR YARD IS STILL HIGH, PREVIOUSLY CODX2009-03133"]
["257 J 1","I","2009-07-13","817","Q ST","CODX2009-03717","303972","2009-06-23","SOMEONE LIVING IN THE MOTORHOME; IT IS WHITE COLOR WITH BLUE TOP."]
["257 J 1","I","2009-07-15","7238","MANUEL ST","CODX2009-03848","304489","2009-06-25","FRONT YARD OF THIS ADDRESS THERE IS AN OLD FRIDGE, BUSTED CABINETS AND OTHER JUNK ALL OVER THE YARD."]

{"sheet":"Sheet12","index":11,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[10,0,10,4],[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Brittany Plunkett"]
["Subzone:  C2"]
["259 B 4","I","2009-07-14","5309","VALPARAISO CIR","CODX2009-03768","0","2009-06-24","OVER GROWN VEGETATION"]
["259 C 5","I","2009-07-14","5569","KEONCREST CIR","CODX2009-03767","0","2009-06-24","Junk and rubbish "]
["259 C 5","I","2009-07-14","5543","KEONCREST CIR","CODX2009-03783","0","2009-06-24","Storage of inop/unreg vehicles\n"]
["259 C 6","I","2009-07-16","5720","PALM AVE","CODX2009-03866","304528","2009-06-26","VACANT UNMAINTAINED HOUSE AT THE ABOVE ADDRESS. WEEDS ARE ABOUT 6 FEET TALL AND VERY DRY. PROPERTY HAS BEEN VACANT FOR OVER ONE YEAR."]
["278 J 1","I","2009-07-14","4631","ORANGE GROVE AVE","CODX2009-03772","0","2009-06-24","OPERATING A BUSINESS WITHOUT A LICENSE \"CONCRETE USES\""]
["Subzone:  C4"]
["278 C 5","I","2009-07-20",null,null,"CODX2009-03937","0","2009-06-30","\"0 HERON AVE\" IMMINENT FIRE HAZARD"]
["278 C 5","I","2009-08-05","2229","EDISON AVE","CODX2009-03980","304896","2009-07-01","HOUSING: LACK OF WINDOW SCREENS"]
["278 C 6","I","2009-07-13","2020","EL CAMINO AVE","CODX2009-03715","304022","2009-06-23","There is a Ford truck parked on the lawn."]
["278 C 6","I","2009-07-22","2020","EL CAMINO AVE","CODX2009-04027","304719","2009-07-02","3 to 4 roosters in the back yard, making noise."]
["278 C 7","I","2009-08-04","2031","KEITH WAY","CODX2009-03975","304885","2009-06-30","HOUSING: WARPED FLOORBOARDS, STEPS TO BACK DOOR UNSOUND, WATER LINE BREAK UNDER HOUSE, ELECTRICAL OUTLETS IN DISREPAIR"]
["278 C 7","I","2009-07-14","2044","ERNEST WAY","CODX2009-03788","304335","2009-06-24","CONDUCTING MAJOR AUTO REAPIR WORK ON VEHICLES IN THE DRIVEWAY,THIS IS USUALLY OCCURRING IN THE EVENING TIME."]
["278 D 4","I","2009-07-29","2526","EDISON AVE","CODX2009-03784","304312","2009-06-24","UNIT # 55- STOVE WILL SHOCK WHEN TURNED ON OR OFF, WINDOWS NAILED SHUT, HAS ROACHES AND SPIDERS AND MOLD. "]
["278 D 6","I","2009-07-15","2405","BELL ST","CODX2009-03803","304232","2009-06-25","CALLER STATES VACANT UNMAINTAINED PROPERTY AT THE ABOVE ADDRESS. WEEDS ARE 3-4 FT HIGH. CALLER STATES THERE HAS ALREADY BEEN A FIRE AT THIS ADDRESS BECAUSE OF THE WEEDS. THE PROPERTY HAS BEEN VACANT FOR AT LEAST 1 1/2 YEARS."]
["278 D 7","I","2009-07-22","2109","JUANITA LN","CODX2009-04060","304833","2009-07-02","THERE ARE 2 VEHICLES THAT ARE PARKED ON THE FRONT LAWN.THE VEHICLES ARE BOTH VOLKSWAGONS, ONE IS BLACK AND ONE IS WHITE."]
["278 D 7","I","2009-07-07","2205","LLOYD LN","CODX2009-04015","304837","2009-07-01","THERE ARE LIVE ANIMALS BEING SLAUGHTERED"]
["278 F 6","I","2009-07-21","3158","JERSEY WAY","CODX2009-03982","304878","2009-07-01","VACANT DUPLEX, DRY WEEDS MORE THAN 2 FEET TALL.  FIRE HAZARD"]
["298 C 1","I","2009-07-21","1841","HOWE AVE","CODX2009-03984","0","2009-07-01","junk and rubbish in the dumpster area"]
["298 F 2","I","2009-07-13","3200","BERKSHIRE WAY","CODX2009-03739","304073","2009-06-23","Yard fulled with containers of empty wine bottles. The bottles filled the whole corner of the yard. There were also piles of plastic soda bottles piled against the house."]

{"sheet":"Sheet13","index":12,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[10,0,10,4],[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Rachel Sutherland"]
["Subzone:  S7"]
["337 H 3","I","2009-07-21",null,null,"CODX2009-03998","0","2009-07-01","MAR-several vehicles in driveway that are having MAR performed on them, vehicles on jacks etc. \n"]
["337 J 2","I","2009-07-12","7420","EAST PKWY","CODX2009-03704","304154","2009-06-22","Three inop/unreg vehicles in front yard. One vehicle is a white SUV, which is parked on yard. Second vehicle is a wrecked Acrura w/no front plate on driveway, third vehicle is under tarps on driveway.**SNAPS"]
["337 J 2","I","2009-07-21","7620","EAST PKWY","CODX2009-04018","0","2009-07-01","SCC 16.18.401 (w)-Overgrowth of weeds/vegetation in front yard area\n304873: On the grass between 7620 and 7616 East Parkway is a Ford Brono with a\nFor Sale sign on it.   The car in the driveway has been there for over a year."]
["337 J 2","I","2009-07-13","7416","EAST PKWY","CODX2009-03725","303707","2009-06-23","Inop/unreg VW hatchback in driveway, Oregon Lic plate# KDP485, reg expired 10.31.08. Large refrigerated storage container placed on driveway.\n"]
["337 J 2","I","2009-07-08","7616","EAST PKWY","CODX2009-04055","304866","2009-07-02","INOPERABLE VOLKSWAGEN HATCHBACK OREGON LICENSE KDP485"]
["Subzone:  S8"]
["338 D 4","I","2009-07-21","8259","NEWFIELD CIR","CODX2009-04017","0","2009-07-01","Yard Parking-truck being parked on yard area next to driveway\n"]
["338 D 4","I","2009-07-21","8255","HALBRITE WAY","CODX2009-04006","0","2009-07-01","Yard Parking-truck being parked on yard area next to driveway"]
["338 D 4","I","2009-07-21","7692","COUNTRY PARK DR","CODX2009-04013","0","2009-07-01","Yard Parking-vehicles being parked on yard area next to driveway\n"]
["338 D 4","I","2009-07-21","7830","RIVERHURST CT","CODX2009-04009","0","2009-07-01","SZC 305-83.2-Carport structure in driveway does not meet setback(s) from public right of way\n"]
["338 D 6","I","2009-07-22","8120","LEMON COVE CT","CODX2009-04026","304769","2009-07-02","A 4 DOOR GREEN FORD FOCUS WITH EXPIRED TAGS 2008 IS PARKED IN THE DRIVEWAY AT THE ABOVE ADDRESS."]
["338 E 3","I","2009-07-15","8390","GERBER RD","CODX2009-03816","0","2009-06-25","Junk and rubbish"]
["338 E 4","I","2009-07-13","7824","GRASS VALLEY CT","CODX2009-03724","0","2009-06-23","Yard parking-vehicles being parked in front yard of property."]
["338 E 5","I","2009-07-15","7852","FIRST DRAW WAY","CODX2009-03823","0","2009-06-25","Storage of inop/unreg vehicle(s): white Jeep in driveway, license # 2DVM688.\n"]
["338 E 6","B",null,"8028","SPENGLER DR","CODX2009-04023","304938","2009-07-02","VOA -- POLICE KNOCKED DOWN FRONT DOOR MAY 15, 2009, DOOR STILL DOWN. 07/07/2009-304937-VACANT UNMAINTAINED PROPERTY, WEEDS IN FRONT AND BACKYARD OVER 3' TALL"]
["338 E 7","I","2009-07-14","8304","HONEYCOMB WAY","CODX2009-03786","304334","2009-06-24","COMMERCIAL VEHICLE PARKED IN DRIVEWAY. SAYS BELL BROS HEATING AND AIR. CALLER SAYS THEY WERE CITED FOR PARKING ON THE STREET SO MOVED TO DRIVEWAY."]
["338 E 7","I","2009-07-15","8408","PASTORI WAY","CODX2009-03849","304496","2009-06-25","Heating & AC truck, 1-ton van box truck, always parked in driveway."]
["338 F 4","I","2009-07-13","8656","PACIFIC HILLS WAY","CODX2009-03723","0","2009-06-23","Storing commercial vehicle(s): Taco truck being parked in driveway and sometimes on street of property"]
["338 F 4","I","2009-07-13","7771","VALLEY WOOD DR","CODX2009-03733","3034145","2009-06-23","LAWN PARKING: BOAT ON  LAWN OVER 1 WEEK, LARGE WHITE CABIN STYLE BOAT. \n"]
["338 F 4","I","2009-07-13","8645","PRAIRIEWOODS DR","CODX2009-03743","304153","2009-06-23","TRAILOR HAS SIDERAILS, ON LAWN IN FRONT YARD."]
["338 F 5","R","2009-07-17","8529","WHITBY CT","CODX2009-03990","0","2009-07-01","Junk & Rubbish-repeat violator, previous complaint filed under closed case # codx2009-02013"]
["338 F 5","I","2009-07-13","8640","NASH WAY","CODX2009-03742","304059","2009-06-23","Multiple old mattresses, animal feces, general garbage in backyard"]
["338 F 5","I","2009-07-29","8626","CARLISLE AVE","CODX2009-03787","304430","2009-06-24","THIS YARD IS FULL OF TRASH AND DEBRIS SUCH AS LUMBER AND BAGS OF TRASH,FURNITURE ETC STACKED UP AGAINST A GATE. ALSO THERE IS AN IN-OP TRAILOR AND MOTOR HOME ON THE PROPERTY."]
["338 F 6","I","2009-07-15","8641","WILLOW GROVE WAY","CODX2009-03836","0","2009-06-25","Storage of inop/unreg vehicle(s): white vehicle on driveway, half of vehicle is on jacks. \n\nYard Parking-trailer parked on yard area next to driveway. \n\n"]
["338 F 6","I","2009-07-15","8085","ALDER CREST CT","CODX2009-03832","0","2009-06-25","Storage of inop/unreg vehicle(s): On driveway is a white Ford van, license # 3M69236. \n"]
["338 F 6","I","2009-07-15","8097","ALDER CREST CT","CODX2009-03829","0","2009-06-25","Storage of inop/unreg vehicles: On driveway are two inop/unreg vehicles, gray Cadillac lic# 5MGJ088, blue truck.\n"]
["338 F 6","R","2009-07-07","8645","BARCHETTA CT","CODX2009-03729","0","2009-06-23","VAO"]
["338 F 6","I","2009-07-12","8101","SIMI CT","CODX2009-03693","304024","2009-06-22","BOAT AND TRAILER PARKED ON THE FRONT LAWN."]
["338 F 6","I","2009-07-30","8060","HEATHER HOLLW CT","CODX2009-03834","0","2009-06-25","Storage of inop/unreg vehicle(s): on driveway is an inop/unreg Chevy van, lic# 5G42561.\n"]
["338 F 6","I","2009-07-15","8080","ALDER CREST CT","CODX2009-03831","0","2009-06-25","Storage of inop/unreg vehicle(s): on driveway is a Dodge truck, license# 3W07326.\n"]
["338 G 4","R","2009-07-20","0","LAKEWOOD RD","CODX2009-03938","0","2009-06-30","\"0 LAKEWOOD\" IMMINENT FIRE HAZARD "]
["338 G 4","I","2009-07-19","8868","WAHOO CT","CODX2009-03912","304628","2009-06-29","VACANT- OVERGROWN VEGETATION"]

{"sheet":"Sheet14","index":13,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[13,0,13,4],[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Brian Tischbirek"]
["Subzone:  E5"]
["278 G 6","I","2009-07-29","3644","KINGS WAY","CODX2009-03782","304383","2009-06-24","3604 kINGS WAY UNIT # 1- LACK OF SMOKE DETECTORS"]
["278 H 3","I","2009-07-19","4228","EDISON AVE","CODX2009-03917","304581","2009-06-29","JUNK AND RUBBISH: JUNK AND RUBBISH IN FRONT AND BACKYARD. BACKYARD IS FILLED WITH BUCKETS, DOORS, AIR CONDITIONING DUCTS, CONSTRUCTION DEBRIS RIPPED FROM THE HOUSE. THE DEBRIS IS SO BAD THAT IT FORCING THE FENCE OVER.  "]
["278 H 5","I","2009-07-15","4111","MARCONI AV","CODX2009-03799","304026","2009-06-25","OLD BUILDING IS VACANT AND HAS NOT BEEN MAINTAINED FOR OVER 6 WEEKS AND THE WEEDS ARE 2 1/2 FEET HIGH."]
["278 J 4","R","2009-07-15","3400","MORROW ST","CODX2009-03883","304737","2009-06-29","Surfacing Sewage: THE CALLER STATES THAT THE RESIDENT HAS A RV PARKED ON HIS DRIVEWAY THAT HAS A BLACK WATER VALVE THAT DOES NOT HAVE A CAP WHICH IS CAUSING THE FECAL MATTER TO RUN DOWN THE DRIVEWAY AND INTO THE STORM DRAINS.THIS IS HAPPENING RIGHT NOW AND EVERY MORNING.\n\n6/30/09- inoperable and/or unregistered vehicle, occupied RV"]
["279 A 2","I","2009-07-28","4915","HOPE LN","CODX2009-03755","304445","2009-06-23","THE FENCE AT THE ABOVE ADDRESS IS OVER 10 FEET TALL. THERE IS NO PERMIT FOR THE FENCE."]
["279 A 4","I","2009-07-19","4837","FOSTER WAY","CODX2009-03918","304564","2009-06-29","CONSTITUENT STATES THAT NEIGHBOR HAS BEE HIVES IN BACKYARD. BEES COME OVER TO CONSTITUENT'S YARD IN SWIMMING POOL AND HAS BEEN STUNG"]
["279 A 5","I","2009-07-20","3100","ROOT AVE","CODX2009-03956","0","2009-06-30","Please open a case for the violation of the Variance on the property (VARIANCE 98-VAZ-0419 CONDITION 3).  PO is parking on a driveway that he should not be parking on\n"]
["279 A 6","I","2009-07-12","2560","LA FRANCE DR","CODX2009-03690","304251, 304248","2009-06-22","Junk & Rubbish in the front Yard & LARGE WHITE P/U TRUCK INOP AND IN THE DRIVEWAY FILLED WITH GARBAGE."]
["Subzone:  E6"]
["278 H 7","I","2009-07-14","3812","ATWATER RD","CODX2009-03769","304458","2009-06-24","1989 CHRYSLER LEBARON, LICENSE MADBING. EXPIRED REGISTRATION. PARKED ON DRIVEWAY, CAR HAS NOT MOVED IN MONTHS."]
["278 H 7","I","2009-07-14","2051","MARYAL DR","CODX2009-03766","304454","2009-06-24","1993 GREEN CHRYSLER IMPERIAL, LICENSE 5MGB961.  HAS NOT MOVED IN A YEAR.  REGISTRATION EXPIRED."]
["279 B 7","I","2009-07-13","2329","WALNUT AVE","CODX2009-03741","304370","2009-06-23","THERE IS A NON-OP VEHICLE (RED COLT) IN THE DRIVEWAY."]
["298 E 3","I","2009-07-13","2663","MATHESON WAY","CODX2009-03711","304185","2009-06-23","lAWN PARKING, BLK P/U TRUCK "]
["298 F 3","I","2009-07-22","3404","ARDENRIDGE DR","CODX2009-04053","304888","2009-07-02","THERE IS A FENCE OVER 6FT AND W/O A PERMIT,ALSO THERE IS AN 8\" GAP FROM THE FENCE TO THE GROUND. "]
["298 F 3","I","2009-07-14","3320","CHURCHILL RD","CODX2009-03793","0","2009-06-24","INOP/UNREG VEHICLE (GREEN VEHICLE IN DRIVEWAY)"]
["298 F 3","I","2009-07-14","3201","CHURCHILL RD","CODX2009-03795","0","2009-06-24","INOPERABLE AND/OR UNREGISTERED VEHICLE"]
["298 F 3","I","2009-07-12","3321","CHURCHILL RD","CODX2009-03701","304016","2009-06-22","1950S RED SEDAN W/WHITE TOP IN THE DRIVEWAY ON JACKS."]
["298 F 3","I","2009-07-14","3109","CHURCHILL RD","CODX2009-03798","0","2009-06-24","VEHICLE IN DRIVEWAY"]
["298 G 1","I","2009-07-12","3528","MAPLEWOOD LN","CODX2009-03695","0","2009-06-22","STORING COMMERICAL VEHICLE(S)"]
["298 J 1","I","2009-07-13","2020","VESTA WAY","CODX2009-03750","304246","2009-06-23","OCCUPIED WHITE 5TH WHEEL WITH SLIDE, IS IN THE DRIVEWAY, HAS POWER CHORDS TO THE HOUSE.\n\n\n"]

{"sheet":"Sheet15","index":14,"n_rows":105,"n_cols":9,"rows_kept":105,"cut":false,"hidden":false,"merged":[[96,0,96,4],[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Jared Wickliff"]
["Subzone:  E3"]
["240 J 6","I","2009-07-16","8161","SANTA JUANITA AVE","CODX2009-03867","304510","2009-06-26","VACANT RESIDENCE.  CONSTITUENT STATES DRY WEEDS MORE THAN 3 FEET TALL.  FIRE HAZARD."]
["260 B 2","I","2009-07-13","8121","DART WAY","CODX2009-03746","304143","2009-06-23","JUNK AND DEBRIS ALL OVER THE FRONT AND BACKYARD AT THE ABOVE ADDRESS. JUNK CONSISTS OF APPLIANCES, FURNITURE AND OTHER DEBRIS. 06/24/2009-304142-ABANDONED WHITE TRUCK ON DRIVEWAY. NO DAMAGE HOWEVER THE TRUCK BED IS FULL FOR JUNK. NO LICENSE PLATE NUMBER."]
["260 C 2","I","2009-07-19","8373","OLD RANCH RD","CODX2009-03922","304605","2009-06-29","INOPERABLE AND/OR UNREGISTERED VEHICLE: SEDAN BLUE IN COLOR.  MAKE AND MODEL NOT AVAILIBLE."]
["260 D 1","I","2009-07-22","7421","HARDY ST","CODX2009-04030","0","2009-07-02","UNREG CHRYSLER XQC497"]
["260 D 1","I","2009-07-22","8612","EL SOBRANTE WAY","CODX2009-04033","0","2009-07-02","UNREG TOYOTA MISSING FRONT WHEEL"]
["260 D 1","I","2009-07-21","8551","BIRUTA AVE","CODX2009-04005","0","2009-07-01","UNREG CELICA 4CEF729 IN D/W"]
["260 D 1","I","2009-07-21","7425","LARKSPUR LN","CODX2009-04008","0","2009-07-01","UNREG EXPLORER 5VAU790 IN D/W"]
["260 D 1","I","2009-07-22","8628","LA PAENDA WAY","CODX2009-04036","0","2009-07-02","CHEVY IN D/W WITH EXP OR PLATES"]
["260 D 1","I","2009-07-27","8535","OAK AVE","CODX2009-04002","0","2009-07-01","UNREG ORANGE SCOUT IN R/Y BEING OVERTAKEN BY WEEDS, UNREG VOLVO IN D/W WITH NO PLATES"]
["260 D 1","I","2009-07-21","8588","OAK AVE","CODX2009-03996","0","2009-07-01","UNREG HONDA 4MSY580 IN D/W, HOUSEHOLD ITEMS PILED ALL OVER THE PORCH"]
["260 D 1","I","2009-07-22","8621","LA PAENDA WAY","CODX2009-04035","0","2009-07-02","UNREG TOYOTA 4N74043"]
["260 D 1","I","2009-07-21","8521","OAK AVE","CODX2009-04004","0","2009-07-01","UNREG TOYOTA 3SSX861 IN D/W. THREE OTHER CARS ON LAWN PROBABLY UNREG TOO. PILE OF J/R NEXT TO TOYOTA"]
["260 D 1","I","2009-07-22","7449","LARKSPUR LN","CODX2009-04029","0","2009-07-02","UNREG 4ZBW321 FORD WINDSTAR"]
["260 D 1","I","2009-07-22","8613","EL SOBRANTE WAY","CODX2009-04034","0","2009-07-02","UTILITY TRUCK BED ON LAWN"]
["260 D 1","I","2009-07-21","8564","OAK AVE","CODX2009-04000","0","2009-07-01","RAV4 IN D/W NO PLATES, UNREG MERCEDES 5YBZ960"]
["260 D 2","I","2009-07-21","8574","BIRUTA AVE","CODX2009-04007","0","2009-07-01","UNREG CHEVY 4T17691 IN D/W"]
["260 D 2","I","2009-07-20","7125","ALMOND AVE","CODX2009-03962","0","2009-06-30","UNREG FORD TRUCK EXP TAGS"]
["260 D 2","I","2009-07-20","8513","ELM AVE","CODX2009-03958","0","2009-06-30","ORANGE JEEP IN D/W WITH 4 FLATS"]
["260 D 2","I","2009-07-20","8599","PHEASANT HILL CT","CODX2009-03963","0","2009-06-30","BOXES OF JUNK ALL OVER DRIVEWAY"]
["260 D 2","I","2009-07-21","7011","ALMOND HILL CT","CODX2009-04010","0","2009-07-01","MERCURY TRACER STATION WAGON IN D/W EXP TAGS"]
["260 D 2","I","2009-07-20","8572","MENKE WAY","CODX2009-03961","0","2009-06-30","UNREG MERCURY 5UMF319 IN D/W"]
["260 D 2","I","2009-07-21","7023","ALMOND HILL CT","CODX2009-04011","0","2009-07-01","UNREG CADILLAC 6EEL132 IN D/W"]
["260 D 2","I","2009-07-20","7221","SUNCREEK WAY","CODX2009-03960","0","2009-06-30","UNREG CELICA WITH WASHINGTON PLATES NEXT TO D/W"]
["260 D 3","I","2009-07-20","6701","CARRWOOD ST","CODX2009-03965","0","2009-06-30","MULTIPLE UNREG CARS IN D/W, JUNK PILED ALL OVER D/W"]
["260 D 3","I","2009-07-20","8543","NOEL DR","CODX2009-03954","0","2009-06-30","UNREG HONDA 4LUU344 IN D/W"]
["260 D 3","I","2009-07-21","8506","STRONG AVE","CODX2009-04020","0","2009-07-01","PRIMERED TRUCK NO PLATES IN D/W"]
["260 D 3","I","2009-07-20","8536","NOEL DR","CODX2009-03955","0","2009-06-30","DISMANTLED TRUCK IN D/W"]
["260 D 3","I","2009-07-14","6729","CAPULLO CT","CODX2009-03780","304477","2009-06-24","IN D/W THERE IS A FORD TRUCK 4X12725 AND FORD CROWN VIC 4KNN333, IN REAR YARD THERES A DEAD ORANGE MUSTANG AND OTHER VEHICLES"]
["260 D 3","I","2009-07-21","6704","ALMOND AVE","CODX2009-04014","0","2009-07-01","SHED BUILT IN FRONT YARD SETBACK RIGHT UP AGAINST SIDEWALK"]
["260 D 3","I","2009-07-20","6605","QUANAH WAY","CODX2009-03950","0","2009-06-30","UNREG TOYOTA 4NYY401 IN D/W...J/R THROUGHOUT D/W AND S/Y - OVEN, BOOKSHELF, BAGS OF TRASH"]
["260 D 3","I","2009-07-20","6614","QUANAH WAY","CODX2009-03951","0","2009-06-30","SCRAPWOOD IN D/W"]
["260 D 3","I","2009-07-20","8530","NOEL DR","CODX2009-03957","0","2009-06-30","UNREG RV 5HFY370 IN D/W"]
["260 D 3","I","2009-08-03","6719","ALMOND AVE","CODX2009-03967","0","2009-06-30","OLD CAR 374LIO UNDER TARP INOPERABLE IN D/W"]
["260 D 3","I","2009-07-20","8701","GAINES AVE","CODX2009-03971","0","2009-06-30","UNREG NISSAN 1GZR895 IN D/W"]
["260 D 3","I","2009-07-21","8517","STRONG AVE","CODX2009-04019","0","2009-07-01","UNREG TOYOTA 102FJF IN D/W"]
["260 D 3","I","2009-07-20","8619","POSADERA AVE","CODX2009-03974","0","2009-06-30","4 UNREG CARS IN D/W - NISSAN 4WWD776, FORD SFZF649, CHRYSLER ITANWEL. JUNK AND RUBBISH PILED ALL OVER 2 OF THE CARS"]
["260 D 3","I","2009-07-20","8600","CENTRAL AVE","CODX2009-03970","0","2009-06-30","IN REAR YARD, UNREG FORD 5E65939 AND BUCKETS AND OTHER J/R"]
["260 D 3","I","2009-07-20","6650","QUANAH WAY","CODX2009-03953","0","2009-06-30","UNREG FORD TRUCK 5U48081 MISSING ITS REAR WHEELS"]
["260 D 3","I","2009-07-20","6705","CARRWOOD ST","CODX2009-03966","0","2009-06-30","CABINETS IN D/W"]
["260 D 3","I","2009-07-14","6731","CAPULLO CT","CODX2009-03781","304478","2009-06-24","OLD BROKE DOWN YELLOW TRUCK IN REAR YARD"]
["260 D 3","I","2009-07-20","8618","CENTRAL AVE","CODX2009-03977","0","2009-06-30","UNREG TOYOTA 3T42603 IN D/W"]
["260 D 3","I","2009-07-20","6748","KENNETH AVE","CODX2009-03959","0","2009-06-30","UNREG HONDA 4SEB361 IN D/W"]
["260 D 3","I","2009-07-27","6827","ALMOND AVE","CODX2009-03964","0","2009-06-30","DISMANTLED TRUCK, NO WHEELS IN D/W"]
["260 D 3","I","2009-07-20","8631","POSADERA AVE","CODX2009-03976","0","2009-06-30","UNREG DODGE VAN 2UVJ183 IN D/W"]
["260 D 3","I","2009-07-21","8524","STRONG AVE","CODX2009-04016","0","2009-07-01","UNREG GMC 4A42497 IN D/W"]
["260 D 4","I","2009-07-20","8618","GAINES AVE","CODX2009-03973","0","2009-06-30","UNREG FORD RANGER 5W30602 IN D/W"]
["260 D 4","I","2009-07-20","6239","ALMOND AVE","CODX2009-03969","0","2009-06-30","UNREG COMMERCIAL VEHICLE BOX VAN 6X68021, UNREG VAN 6RS2556"]
["260 E 1","I","2009-07-22","8737","KIOWA CT","CODX2009-04039","0","2009-07-02","UNREG VOLVO 014TII AND FORD VAN 4H54848 IN D/W ON ALGONQUIN"]
["260 E 1","I","2009-07-22","8658","PARDILLO AVE","CODX2009-04031","0","2009-07-02","BUG IN D/W UNDER TARP MISSING WHEELS"]
["260 E 1","I","2009-07-22","8690","EL SOBRANTE WAY","CODX2009-04037","0","2009-07-02","UNREG GMC N19701 IN D/W"]
["260 E 1","I","2009-07-22","8709","ALGONQUIN WAY","CODX2009-04038","0","2009-07-02","DISMANTLED TRUCK IN D/W MISSING FRONT END"]
["260 E 2","I","2009-07-22","6932","HICKORY AVE","CODX2009-04042","0","2009-07-02","SHED BUILT IN FRONT YARD SETBACK 305-83.2"]
["260 E 2","I","2009-07-13","8815","NICKENS CT","CODX2009-03748","304245","2009-06-23","Trailer moved onto property and is being occupied."]
["260 E 2","I","2009-07-22","7037","BEECH AVE","CODX2009-04079","0","2009-07-02","UNREG FORD TRUCK GNSROSE IN D/W "]
["260 E 2","I","2009-07-19","8830","MAVIS AVE","CODX2009-03892","304702","2009-06-29","JUNK AND RUBBISH: Large pile of debris in front of house and around in front of garage under tarps.  Furniture, christmas decor, possibly large appliance, overloaded cardboard boxes of other various junk/debris.  Been out there for over a year and a half."]
["260 E 2","I","2009-07-22","8765","ELM AVE","CODX2009-04085","0","2009-07-02","ILLEGAL HOME OCC"]
["260 E 2","I","2009-07-21","8689","ELM AVE","CODX2009-04012","0","2009-07-01","YELLOW JEEP IN D/W 06 TAGS"]
["260 E 2","I","2009-07-22","8780","COUNTRY VISTA LN","CODX2009-04078","0","2009-07-02","UNREG GMC TRUCK 1R19667 BY HOUSE"]
["260 E 2","I","2009-07-22","7306","REDWING CT","CODX2009-04081","0","2009-07-02","UNREG MUSTANG 2ANT841 IN D/W UNDER TARP"]
["260 E 2","I","2009-09-08","8700","BUNTING CT","CODX2009-04040","0","2009-07-02","UNREG NAVIGATOR SQL1999 ON SIDE OF HOUSE"]
["260 E 3","I","2009-07-22","6900","THAYER WAY","CODX2009-04058","0","2009-07-02","UNREG PYMOUT RELIANT K, NO LICENSE PLATES ON DUGGAN WAY IN D/W...UNREG MIATA 4ZWD805 IN D/W ON THAYER"]
["260 E 3","I","2009-07-22","8760","ZUMWALT AVE","CODX2009-04046","0","2009-07-02","UNREG TROOPER 2LMU424 PARKED ON LAWN"]
["260 E 3","I","2009-07-22","6710","HICKORY AVE","CODX2009-04067","0","2009-07-02","UNREG FORD VAN 7P41527 IN D/W"]
["260 E 3","I","2009-07-22","8732","CENTRAL AVE","CODX2009-04083","0","2009-07-02","ENGINE PICKER, SCRAPWOOD IN DRIVEWAY"]
["260 E 3","I","2009-07-22","8751","ZUMWALT AVE","CODX2009-04047","0","2009-07-02","UNREG CHEVY TRUCK 7K83965"]
["260 E 3","I","2009-07-22","8737","THORESON CT","CODX2009-04050","0","2009-07-02","DEAD JEEP IN D/W. SUBURBAN IN D/W WITHOUT WHEELS"]
["260 E 3","I","2009-08-03","8736","THORESON CT","CODX2009-04052","0","2009-07-02","2 DEAD TAURUS'S IN D/W"]
["260 E 3","I","2009-07-22","6711","CALISTA ST","CODX2009-04045","0","2009-07-02","UNREG VW BUG WML755 IN D/W"]
["260 E 3","I","2009-07-22","8750","KURTS CT","CODX2009-04044","0","2009-07-02","BLACK WILLYS IN D/W NO PLATES"]
["260 E 3","I","2009-07-22","6807","HICKORY AVE","CODX2009-04066","0","2009-07-02","UNREG FORD TRUCK 2G98612 IN D/W"]
["260 E 3","I","2009-07-22","8744","ZUMWALT AVE","CODX2009-04048","0","2009-07-02","UNREG FORD VAN 5L89888 IN D/W"]
["260 E 3","I","2009-07-22","6801","WILD HORSE CT","CODX2009-04064","0","2009-07-02","UNREG MAZDA 3SWHO81 IN D/W"]
["260 E 3","I","2009-07-22","8780","KURTS CT","CODX2009-04043","0","2009-07-02","UNREG YELLOW SCOUT IN D/W"]
["260 E 3","I","2009-07-22","6740","HICKORY AVE","CODX2009-04065","0","2009-07-02","UNREG VAN EITH EXP OR PLATES, DISMANTLED CAR UNDER TARP, COMMERCIAL BOX VAN IN D/W"]
["260 E 3","I","2009-07-22","6724","HICKORY AVE","CODX2009-04068","0","2009-07-02","UNREG DODGE MINIVAN 3RUF398 IN D/W "]
["260 E 3","I","2009-07-22","8739","CENTRAL AVE","CODX2009-04082","0","2009-07-02","BROKEN TREADMILL, BEDFRAME ON SIDE OF HOUSE"]
["260 E 3","I","2009-07-22","6650","HICKORY AVE","CODX2009-04069","0","2009-07-02","DISMANTLED CAR IN D/W, BLANKET OVER HOOD"]
["260 E 4","I","2009-07-22","8622","KINGDALE AVE","CODX2009-04074","0","2009-07-02","UNREG TOYOTA 5LIJ415 IN D/W"]
["260 E 4","I","2009-07-22","6508","HICKORY AVE","CODX2009-04070","0","2009-07-02","UNREG NISSAN 4GSA054 IN D/W"]
["260 E 4","I","2009-07-22","8747","BLYTHE AVE","CODX2009-04075","0","2009-07-02","UNREG MAZDA 6AIX775 PARKED ON LAWN"]
["260 E 4","I","2009-07-22","8734","BLYTHE AVE","CODX2009-04076","0","2009-07-02","UNREG BUICK 5NAS721 ON D/W WITH PEELING PAINT AND TURNING TO RUST"]
["260 E 4","I","2009-07-22","6323","HICKORY AVE","CODX2009-04077","0","2009-07-02","UNREG CORVETTE 2TZT155 IN D/W, J/R BOX FROM COMMERCIAL VEHICLE IN D/W"]
["260 E 4","I","2009-07-22","6509","HICKORY AVE","CODX2009-04071","0","2009-07-02","COMMERCIAL BOX IN VAN IN D/W 3Z09692. PONTIAC PARKED ON LAWN"]
["260 E 4","I","2009-07-22","6329","BEECH AVE","CODX2009-04072","0","2009-07-02","UNREG DODGE TRUCK 8A19115 IN D/W"]
["260 E 4","I","2009-07-20","8649","LADY JANE WAY","CODX2009-03972","0","2009-06-30","UNREG JIMMY 4ZGB906 IN D/W"]
["260 E 4","I","2009-07-22","8618","WESTHAVEN DR","CODX2009-04073","0","2009-07-02","UNREG NISSAN TRUCK 4M26205 IN D/W FULL OF JUNK"]
["260 F 2","I","2009-07-14","8990","ELM AVE","CODX2009-03764","304380","2009-06-24","ABANDONED FORD RANGER PICKUP IN FRONT YARD.  IT HAS BEEN THERE FOR A YEAR OR MORE. J/R IN D/W"]
["260 F 6","R","2009-07-27","8849","JONNIE WAY","CODX2009-03708","304106","2009-06-22","Tenants left home about 2 months ago and the backyard is accessible to young kids in the neighborhood.  The weeds have grown 6ft tall."]
["260 F 6","I","2009-08-04","8862","LANCE AVE","CODX2009-03939","304672","2009-06-30","HOUSING: VECTOR INFESTATION"]
["260 G 5","I","2009-07-22","9112","SHERRILEE WAY","CODX2009-04062","304767","2009-07-02","PARKS SEVERAL DIFFERENT CARS ON THE LAWN EVERY DAY AT ANY GIVIN TIME."]
["260 H 6","I","2009-07-16","5418","PLANTAIN CIR","CODX2009-03865","304502","2009-06-26","VACANT UNMAINTAINED PROPERTY. HIGH WEEDS, FIRE HAZZARD"]
["Subzone:  E4"]
["260 B 6","I","2009-07-20","8140","DESERET AVE","CODX2009-03946","0","2009-06-30","UNREG GMC VAN 3GUK698 IN D/W"]
["260 B 6","I","2009-07-20","8102","DESERET AVE","CODX2009-03949","0","2009-06-30","UNREG TOYOTA 4TSV038 IN D/W"]
["260 B 6","I","2009-07-20","5508","E KNOLL DR","CODX2009-03945","0","2009-06-30","UNREG NISSAN 2RJH781 IN D/W"]
["260 B 6","I","2009-07-20","8193","DESERET AVE","CODX2009-03947","0","2009-06-30","UNREG FORD TRUCK 8C97190 IN D/W"]
["260 B 6","I","2009-07-20","8175","DESERET AVE","CODX2009-03948","0","2009-06-30","UNREG TOYOTA 2UGY960 IN D/W"]
["260 B 6","I","2009-07-13","8148","LEAFCREST WAY","CODX2009-03740","304076","2009-06-23","JUNK AND RUBBISH ON THE  PROPERTY. THE FRONT YARD HAS INSTALLATION IN BAGS ON THE GROUND."]
["260 B 6","I","2009-07-27","5416","E KNOLL DR","CODX2009-03775","0","2009-06-24","THERE IS A WHITE FORD EXPLORER 2ZTA286 PARKED IN THE D/W DISPLAYING 2010 TAGS THAT WERE STOLEN OFF ANOTHER VEHICLE. DMV REVOKED THIS VEHICLES REG ON 9-15-08"]
["280 E 1","I","2009-07-22","4527","ILLINOIS AVE","CODX2009-04054","304862","2009-07-02","JUNK AND RUBBISH: DIRT, CAR PARTS, TRAILER PARTS, GREEN WASTE, AND OTHER MISCELLANEOUS DEBRIS PILED EVERYWHERE \n304869: TRAILER, AND SEVERAL OTHER INOPERABLE VEHCILES THAT ARE PARKED IN SEVERAL DIFFERENT AREAS OF THE REFERENCED ADDRESS."]

{"sheet":"Sheet16","index":15,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Kari Wilson"]
["Subzone:  S3"]
["298 H 6","I","2009-07-20","2634","SQUAW VALLEY WAY","CODX2009-03968","0","2009-06-30","inop unreg - blues mustang on drive- no engine"]
["299 A 5","I","2009-07-22","9419","LINDA RIO DR","CODX2009-04049","304852","2009-07-02","OVERGRWON VEGETATION: BACKYARD OF THE ABOVE VACANT ADDRESS HAS WEEDS OVER 5 FEET TALL. THE WEEDS ARE ALL DRY. THE HOME HAS BEEN VACANT FOR 8-9 MONTHS."]
["299 B 7","I","2009-07-13","3419","HANKS ST","CODX2009-03721","0","2009-06-23","inop unreg and junk and rubbish"]
["318 H 2","I","2009-07-14","4001","BAIRNSDALE WAY","CODX2009-03794","304348","2009-06-24","WEEDS IN FRONT AND BACKYARD MORE THAN 2 FEET; DRY.  FIRE HAZARD."]
["318 H 2","I","2009-07-13","4011","DION CT","CODX2009-03735","304288","2009-06-23","JUNK AND RUBBISH IN THE FRONT YARD"]
["318 J 1","I","2009-07-21","3636","KESWICK WAY","CODX2009-03981","304889","2009-07-01","ABANDONED HOUSE.  BACKYARD HAS DRY WEEDS SEVERAL FEET TALL.  FIRE HAZARD."]
["318 J 2","I","2009-07-13","4141","TALLYHO DR","CODX2009-03719","0","2009-06-23","JUNK AND RUBBISH (IN BACK YARD AND FRONT YARD)"]
["319 A 2","I","2009-07-12","4152","WESTPORTER DR","CODX2009-03707","304203","2009-06-22","INOP VEHICLE BLUE FORD EXPLORER EXP TAGS"]
["319 A 2","I","2009-07-12","4148","WESTPORTER DR","CODX2009-03688","304207","2009-06-22","Junk and carparts in the front yard. Fenders and bumpers on the side of the house."]
["319 B 1","I","2009-07-28","9532","MIRANDY DR","CODX2009-03796","304423","2009-06-24","YARD IS OVER GROWN AND WEEDS ARE ABOUT 12' HIGH. HOME HAS BEEN VACANT FOR ABOUT 1-2 MONTHS"]
["338 H 5","I","2009-07-13","7937","CHEETAH DR","CODX2009-03737","304045","2009-06-23","THERE IS A GREEN TRUCK PARKED ON THE FRONT LAWN "]
["338 J 5","I","2009-07-07","9120","BRAMWELL WAY","CODX2009-03897","304693","2009-06-29","JUNK AND RUBBISH: THROWING TRASH BAGS OUT IN THE YARD AND PUTTING BASIC HOUSHOLD JUNK IN FRONT YARD, THIS IS AN ONGOING ISSUE."]

{"sheet":"Sheet17","index":16,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 6/22/2009 To: 7/5/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Scott Woodward"]
["Subzone:  N2"]
["239 D 7","I","2009-07-13",null,null,"CODX2009-03714","0","2009-06-23","AUTO STORAGE\nRV & BOAT STORAGE\nDEVELOPMENTAL STANDARDS"]