{"text_format":"2","workbook":"xls","n_sheets":15,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5","Sheet6","Sheet7","Sheet8","Sheet9","Sheet10","Sheet11","Sheet12","Sheet13","Sheet14","Sheet15"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":15,"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":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: 8/26/2009 To: 9/18/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Angela Avakian"]
["Subzone:  N2"]
["238 F 4","I","2009-09-16","8716","ASPEN HILL CT","CODX2009-05158","308033","2009-08-27","TATTOO BUSINESS"]
["238 F 6","I","2009-09-22","3209","GALLOP CT","CODX2009-05267","0","2009-09-02","INOP UNREGD GRAND AM 4CBU536\n"]
["238 F 6","I","2009-10-04","3024","WOLFE CT","CODX2009-05410","309062","2009-09-14","TRASH PILED UP IN DRIVEWAY. 309063-INOP BOAT AND TAN DODGE RAM TRUCK IN DRIVEWAY."]
["238 F 6","I","2009-09-17","8200","PINEFIELD DR","CODX2009-05191","308075","2009-08-28","WHITE CHEVY TRUCK WITH FLAT TIRE IN DRIVEWAY"]
["238 F 6","I","2009-09-22","3213","GALLOP CT","CODX2009-05269","0","2009-09-02","INOP UNREGD BLK PK 3J92105\n"]
["238 F 6","I","2009-09-20","8216","PINEFIELD DR","CODX2009-05193","308077","2009-08-31","BLUE PLYMOUTH BREEZE AND GREEN ASPIRE IN DRIVEWAY."]
["238 F 6","I","2009-10-05","3325","GRAY MARE WAY","CODX2009-05332","308679","2009-09-04","INOPERABLE BLUE VOLVO IN DRIVEWAY."]
["238 F 7","I","2009-10-06","3306","DAVIDSON DR","CODX2009-05465","0","2009-09-16","WEEDS"]
["238 G 5","I","2009-10-01","3717","BLACK EAGLE DR","CODX2009-05386","308756","2009-09-11","TWO CARS PARKED ON LAWN; ONE IS TAN DODGE, OTHER IS BLUE T-BIRD"]
["238 G 5","I","2009-10-01","3450","ESTERBROOK WAY","CODX2009-05354","308907","2009-09-11","Vacant.  the backyard has weed growing over 6 feet tall; the back yard has not been taken care over 3 years; the water to the property is shut down for a year;  there is no sign in the front for sale;"]
["238 G 6","I","2009-09-23","3345","GRAY MARE WAY","CODX2009-05327","308683","2009-09-03","CEMENT CHUNKS AND BASKETBALL HOOP IN FRONT YARD. 308682-VACANT RESIDENCE DRY WEEDS IN FRONT AND BACK YARDS MORE THAN THREE FEET TALL. FIRE HAZARD."]
["238 G 7","I","2009-10-06","3613","N COUNTRY DR","CODX2009-05461","309167","2009-09-16","BLACK HONDA, NO LICENSE PLATE PARKED ON DRIVEWAY"]
["239 B 5","I","2009-10-04","8913","PALMERSON DR","CODX2009-05404","309011","2009-09-14","MATTRESSES,APPLIANCES, FURNITURE, TREE TRIMMINGS THAT ARE DRY, TRASH AND DEBRIS IN BACKYARD."]
["239 B 7","I","2009-10-07","7683","BOGAN WAY","CODX2009-05481","305166","2009-09-17","JUNK & RUBBISH - FENCING MATERIAL FROM WHEN FENCE BLEW DOWN NEVER REPLACED"]
["239 B 7","I","2009-09-09","7733","TENNIS CT","CODX2009-05295","308458","2009-09-03","JUNK AND RUBBISH....property a mess every day"]
["239 B 7","I","2009-10-07","7679","BOGAN WAY","CODX2009-05478","305166","2009-09-17","JUNK & RUBBISH - FENCE DOWN (FENCING MATERIAL) LAYING ON GROUND NEVER REPLACED"]
["239 C 7","I","2009-10-01","5413","BECKWORTH WAY","CODX2009-05359","308849","2009-09-11","LAWN PARKING: red Dodge pick-up truck, a black sedan, and a white covered utility trailer.  309001-TWO CARS AND UTILITY TRAILER ON FRONT LAWN."]
["258 H 1","I","2009-10-04","4158","N COUNTRY DR","CODX2009-05415","309079","2009-09-14","ADDRESS HAS TIRES AND LITTER ALL AROUND THE FRONT YARD."]
["259 A 1","I","2009-09-23","4689","MONUMENT DR","CODX2009-05321","0","2009-09-03","Lawn parking"]
["259 A 2","I","2009-09-20","7225","EMINENT CT","CODX2009-05208","308155","2009-08-31","THERE IS MAJOR AUTOMOTIVE REPAIR HAPPENING AT THE ABOVE ADDRESS THAT CONSISTS MOSTLY OF PAINTING.  MOST OF THE OTHER REPAIRS OCCUR AT NIGHT."]
["259 B 1","I","2009-10-04","7535","ST STORY CT","CODX2009-05402","309007","2009-09-14","VEHICLE PARKED UP ON GRASS, WHITE TOYOTA PICKUP, LICENSE PLATE NUMBER 8A19274, HAS NOT MOVED FROM THE GRASS IN 2 MONTHS."]
["259 B 3","I","2009-09-22","6830","SILVERTHORNE CIR","CODX2009-05270","308322","2009-09-02","CALLER STATES NEW FENCE AT THE ABOVE ADDRESS IS OVER 7 FEET TALL."]
["259 C 1","I","2009-10-07","7221","CANDLESTICK WAY","CODX2009-05482","0","2009-09-17","INOP/UNREG - #2WSZ353 ALSO LAWN PARKING"]
["259 C 1","I","2009-10-16","7229","OJAI CT","CODX2009-05394","308946","2009-09-11","ROOF IN DISREPAIR"]

{"sheet":"Sheet2","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"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: 8/26/2009 To: 9/18/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Jess Bermudez"]
["Subzone:  C5"]
["317 F 5","I","2009-09-09","3804","40TH AVE","CODX2009-05334","308926","2009-09-08","HOUSING: UNIT 1: SURFACING SEWAGE (COMING UP OUT OF DRAINS)"]
["317 F 6","R","2009-10-01","3715","46TH AVE","CODX2009-05138","308248","2009-08-27","HOUSING: UNIT 3: HOLES IN ROOF AND WALLS FROM FIREFIGHTERS SINCE 7/5, ALL ELECRRICAL DISCONNECTED."]
["317 G 2","I","2009-10-05","4101","E NICHOLS AVE","CODX2009-05427","0","2009-09-15","OVER GROWN VEGETATION"]
["317 G 3","I","2009-09-16","4200","42ND ST","CODX2009-05144","308023","2009-08-27","junk and debri in front of property ie: furnitures and car parts on the property."]
["317 G 4","I","2009-09-03","5500","DEL NORTE BLVD","CODX2009-05301","2341","2009-09-03"]
["317 G 5","I","2009-09-16","5826","41ST ST","CODX2009-05153","307949","2009-08-27","VACANT RESIDENCE WITH TRASH ON PROPERTY."]
["317 G 5","I","2009-09-17","5831","41ST ST","CODX2009-05181","308117","2009-08-28","CALLER STATES THAT THERE IS A LOT OF AUTO REPAIR GOING ON AT THIS PROPERTY FOR ABOUT 2 YEARS...THERE ARE VARIOUS CARS COMING IN AAND OUT DALIY. SHE STATES THAT THE OWNERS/TENANTS ARE ALWAYS CLEANING UP THE MESS DAILY SO NO ONE KNOWS WHAT THEY ARE DOING."]
["317 G 6","I","2009-10-06","6224","39TH ST","CODX2009-05440","0","2009-09-16","Excessive junk and rubbish"]
["317 G 6","I","2009-09-21","3911","44TH AVE","CODX2009-05262","0","2009-09-01","MULTIPLE NON-OP VEHICLES\n\n"]
["317 G 6","I","2009-10-07","3907","43RD AVE","CODX2009-05476","0","2009-09-17","INOP/UNREG VEHICLES & COMMERCIAL VEHICLES"]
["317 G 6","I","2009-09-21","3914","44TH AVE","CODX2009-05263","0","2009-09-01","JUNK AND RUBBISH, LAWN PARKING, ILLEGAL OCCUPANCY (IN A TENT).\n\n\n\n\n"]
["317 G 6","I","2009-10-06","6224","39TH ST","CODX2009-05439","0","2009-09-16","JUNK & RUBBISH"]
["317 G 7","I","2009-10-02","3903","49TH AVE","CODX2009-05192","308372","2009-08-28","\"HOUSING\" failure to maintain provided appliance (dishwasher)"]
["317 H 2","I","2009-09-17","4421","15TH AVE","CODX2009-05186","307969","2009-08-28","VACANT RESIDENCE.  DRY WEEDS MORE THAN TWO FEET TALL. FIRE HAZARD."]
["317 H 3","I","2009-10-19","4620","ROOSEVELT AVE","CODX2009-05395","308902","2009-09-14","HOUSING: LACK OF SMOKE ALARMS; LACK OF MAINTANENCE OF EXISTING APPLIANCE (WASHING MACHINE); WATER INTRUSION (WASHING MACHINE & UNDER KITCHEN SINK); FOUR WINDOWS NON OPERABLE; IMPROPER/INCOMPLETE INSTALLATION OF WINDOW (BEDROOM); BROKEN WINDOW (KITCHEN); POSSIBLE LACK OF REQUIRED KITCHEN VENTILATION"]
["317 H 3","I","2009-10-01","4311","48TH ST","CODX2009-05356","308921","2009-09-11","THERE IS A PILE OF TRASH, BROKEN FURNITURE AT ADDRESS LISTED."]
["317 H 3","I","2009-10-01","4345","48TH ST","CODX2009-05358","308922","2009-09-11","THERE IS TRASH, BROKEN FURNITURE AND OTHER DEBRIS AT ADDRESS "]
["317 H 4","R","2009-09-28","5648","ETHEL WAY","CODX2009-05441","0","2009-09-16","VOA"]
["317 H 5","I","2009-10-07","4501","37TH AVE","CODX2009-05475","0","2009-09-17","JUNK & RUBBISH, INOP/UNREG"]
["317 H 5","I","2009-10-01","6012","DEWEY BLVD","CODX2009-05351","308890","2009-09-11","JUNK AND RUBBISH, TREE DEBRIS, IN BACK YARD, LUMBER, ASSORTED TRASH AND DEMOLITION DEBRIS. THERE ARE RATS EVERYWHERE."]
["317 H 6","I","2009-09-30","4405","42ND AVE","CODX2009-05343","308874","2009-09-10","GRAY FORD FALCON TWO DOOR SEDAN UP ON JACKS IN DRIVEWAY"]
["317 H 6","I","2009-10-01","6100","LEOLA WAY","CODX2009-05387","308740","2009-09-11","TRASH AND DEBRIS ON PROPERTY"]
["317 H 6","I","2009-09-30","4824","42ND AVE","CODX2009-05336","308873","2009-09-10","BOAT WITH TRAILER"]
["317 H 6","I","2009-10-01","6129","LEOLA WAY","CODX2009-05388","308736","2009-09-11","VARIOUS PIECES OF FURNITURE, WHEELCHAIR AND OTHER DEBRIS AND TRASH"]
["317 J 5","I","2009-09-23","5160","MCKELLAR AVE","CODX2009-05299","308702","2009-09-03","ZONING: ILLEGAL OCCUPANCY OF GARAGE"]
["317 J 5","I","2009-09-20","6100","LUCERO DR","CODX2009-05221","308213","2009-08-31","THERE IS MAJOR AUTO REPAIR AT THE ABOVE ADDRESS. CARS ARE TOWED IN WEEKLY, THERE'S ALWAYS AT LEAST FIVE VEHICLES. THE VEHICLES ARE ALL OVER THE NEIGHBORHOOD. SOME OF THE VEHICLES ON THE PROPERTY ARE UP ON JACKS AT THIS TIME."]
["337 G 1","I","2009-09-23",null,null,"CODX2009-05296","0","2009-09-03","ACTUAL ADDRESS \"0\" FRANKLIN BLVD ILLEGAL BUSINESS- RECYCLING BUSINESS"]

{"sheet":"Sheet3","index":2,"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],[6,0,6,4],[8,0,8,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 8/26/2009 To: 9/18/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Ty Colston"]
["Subzone:  C1"]
["416 G 3","I","2009-09-22",null,null,"CODX2009-05279","308309","2009-09-02","CALLER TRESE IS WITH RANCHO POLICE DEPARTMENT SAID CALLER REPORT TO THEM OF AN ABANDONED FORD VAN E350 LIC#6A93160 PARKED IN THE PARKING LOT. ABANDONED FOR 3 MONTHS, RECENTLY BROKEN GLASS, AND DENTED. EXPIRED TAG 11/30/08.\n\nALSO KNOWN AS 552 VORDEN."]
["Subzone:  S4"]
["340 G 2","I","2009-09-23","7200","SLOUGHHOUSE RD","CODX2009-05294","0","2009-09-03","INOPERABLE AND/OR UNREGISTERED VEHICLES"]
["Subzone:  S5"]
["339 D 5","I","2009-09-22","7850","LAHONTAN CT","CODX2009-05164","308020","2009-08-27","AT REFERENCED ADDRESS HAVE A CHAIN LINK FENCE THAT IS OVER 8 FEET TALL."]
["339 E 5","I","2009-09-30","10209","MAGINNES CT","CODX2009-05444","0","2009-09-16","INOPERABLE AND/OR UNREGISTERED VEHICLE(S)"]
["339 E 5","I","2009-10-01","10246","MARUYAMA CT","CODX2009-05379","308976","2009-09-11","HAD A TOW TRUCK PARKED ON THE LAWN IN THE FRONT, NOT SURE OF NAME ON TRUCK. TOW TRUCK WHITE. DOES NOT THINK THE TOW TRUCK WORKS."]
["339 G 6","I","2009-09-30","8141","EXCELSIOR RD","CODX2009-05446","0","2009-09-16","STORAGE OF INOPERABLE AND/OR UNREGISTERED VEHICLE(S)"]
["339 H 7","I","2009-09-23","10891","CALVINE RD","CODX2009-05469","309036","2009-09-16","TRASH HAS NOT BEEN PICKED UP AT PROPERTY  THEY ARE ACTUALLY BURRYING THE RUBBISH ON THE PROEPRTY AND "]
["380 G 2","I","2009-09-22","10055","TAVERNOR RD","CODX2009-05273","308294","2009-09-02","OWNER OF PROPERTY HAS PEOPLE LIVING IN THE BARN. THESE ARE MIGRANT/TRANSIENTS. THIS HAS BEEN GOING ON FOR SEVERAL YEARS."]
["401 D 6","I","2009-10-04","13734","MONTFORT AVE","CODX2009-05416","309080","2009-09-14","JUNK, TRASH AND DEBRIS ON PROPERTY."]
["420 C 3","I","2009-10-06","13056","WEST LN","CODX2009-05454","309255","2009-09-16","the roof on his home has been leaking since last winter, landlord is refusing to repair it and is only putting plastic over it. "]

{"sheet":"Sheet4","index":3,"n_rows":49,"n_cols":9,"rows_kept":49,"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: 8/26/2009 To: 9/18/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Tom Curl"]
["Subzone:  C1"]
[null,"I","2009-09-20",null,null,"CODX2009-05214","0","2009-08-31","16.18.401W - Overgrowth of vegetation"]
["257 E 2","I","2009-09-21","6715","W 6TH ST","CODX2009-05260","0","2009-09-01","JUNK - TRASH ON DRIVEWAY AND SIDEYARD"]
["257 E 3","I","2009-09-21","6815","W 6TH ST","CODX2009-05259","0","2009-09-01","ILL. BUS. - M1 PARCEL NO BUISINESS LIC ON PROPERTY, JUNK, INOP CARS"]
["257 F 3","I","2009-09-21","6501","W 6TH ST","CODX2009-05257","0","2009-09-01","TIRES, FORKLIFT, JUNK - STUDWALL NEXT TO BUILDING"]
["257 F 3","I","2009-09-21","6606","W 6TH ST","CODX2009-05258","0","2009-09-01","LARGE PILES OF YARD WASTE ON PROP, BOXES ON DRIVEWAY"]
["257 F 3","I","2009-10-19","6315","W 6TH ST","CODX2009-05256","0","2009-09-01","JUNK - CLOTHING AND BOXES ALL OVER DRIVEWAY, RV OCCUPANCY"]
["257 F 4","I","2009-09-21",null,null,"CODX2009-05253","0","2009-09-01","JUNK - TRASH AND WOOD ON AND NEXT TO DRIVEWAY"]
["257 F 4","I","2009-09-21","6133","W 4TH ST","CODX2009-05244","0","2009-09-01","16.18.401w - Overgrowth of vegetation"]
["257 F 5","I","2009-10-21","5625","W 6TH ST","CODX2009-05248","0","2009-09-01","PALLETS, WORKBENCK, METAL BOX ON DRIVEWAY"]
["257 F 5","I","2009-09-21","5720","W 6TH ST","CODX2009-05250","0","2009-09-01","JUNK - APPLIANCES ON DRIVEWAY, MAR"]
["257 G 2","I","2009-09-20","240","W M ST","CODX2009-05240","0","2009-08-31","TIRES, INOP/UNREG RVS AND TRUCKS IN REAR YARD"]
["257 G 2","I","2009-09-20","6720","W 2ND ST","CODX2009-05223","0","2009-08-31","APPLIANCE AND FURNITURE ON DRIVEWAY"]
["257 G 3","I","2009-09-20","6331","W 2ND ST","CODX2009-05226","0","2009-08-31","6331 W 2nd Street: JUNK - YARD WASTE.\n6325 W 2nd Street: (ADDT'L ADD FOR 6331) JUNK - TRASH ON YARD."]
["257 G 3","I","2009-09-20","6439","W 2ND ST","CODX2009-05224","0","2009-08-31","INOP GRAY CAR AND WHITE TRUCK"]
["257 G 3","I","2009-09-20","6328","W 2ND ST","CODX2009-05229","0","2009-08-31","JUNK - WOOD ON NORTH WEST PART OF YARD"]
["257 G 3","I","2009-09-20","6416","W 2ND ST","CODX2009-05225","0","2009-08-31","LAWN PKG - RED TRUCK"]
["257 G 4","I","2009-09-21","228","W E ST","CODX2009-05247","0","2009-09-01","JUNK - WOOD, TIRES, YARD WASTE, ELECTRONICS, FIREWOOD"]
["257 G 4","I","2009-09-20","6212","W 2ND ST","CODX2009-05237","0","2009-08-31","DEBRIS PILE ON DRIVEWAY AND YARD, INOP IN DRIVEWAY"]
["257 G 4","I","2009-10-30","109","E ST","CODX2009-05246","0","2009-09-01","16.18.401w AND JUNK ON PROERTY"]
["257 G 4","I","2009-09-20","6143","W 2ND ST","CODX2009-05238","0","2009-08-31","JUNK - PILE OF WOOD NEXT TO DRIVEWAY"]
["257 G 4","I","2009-11-12","5904","W 2ND ST","CODX2009-05281","0","2009-09-02","INOP, MAR, JUNK & RUBBISH"]
["257 G 4","I","2009-10-05","101","E ST","CODX2009-05245","0","2009-09-01","JUNK - CONSTR MATERIALS ON LAWN AND WOOD PILE NEXT 2 DRIVEWAY"]
["257 G 4","I","2009-09-20","6124","W 2ND ST","CODX2009-05239","0","2009-08-31","INOP TRAILER AND TRUCK ON DRIVEWAY"]
["257 G 4","I","2009-09-20","6249","W 2ND ST","CODX2009-05230","0","2009-08-31","JUNK - TRASH ON YARD"]
["257 G 4","I","2009-10-16","6236","W 2ND ST","CODX2009-05233","0","2009-08-31","JUNK - TRUCK RACK, FENCING, MISC DEBRIS OTHER THAN CONSISTENT WITH THE OPEN PERMIT"]
["257 H 2","I","2009-09-20","6841","RIO LINDA BLVD","CODX2009-05195","0","2009-08-31","INDOOR CHAIR ON DRIVEWAY (EZ CHAIR TYPE)"]
["257 H 2","I","2009-09-20","6923","RIO LINDA BLVD","CODX2009-05194","0","2009-08-31","BLACK PLASTIC TRUCK TOOL BOX NEXT TO DRIVEWAY"]
["257 H 2","I","2009-09-20","6837","RIO LINDA BLVD","CODX2009-05197","0","2009-08-31","LP - 4UJM438,  2PQP807,  WHT CARGO TRAILER"]
["257 H 3","I","2009-10-01","6423","RIO LINDA BLVD","CODX2009-05202","0","2009-08-31","SZC 301-70, 71 - FAIL TO MAINTAIN LANDSCAPE, MULTI-FAM BUILDING"]
["257 H 3","I","2009-09-20","6545","RIO LINDA BLVD","CODX2009-05200","0","2009-08-31","FRIDGE ON DRIVEWAY, INOP & LP (WHT NISSAN)"]
["257 H 4","I","2009-09-20","6224","RIO LINDA BLVD","CODX2009-05207","0","2009-08-31","INOP CARS- 947SHL, 4WWP597"]
["257 H 4","I","2009-09-20","310","COLLIN LN","CODX2009-05212","0","2009-08-31","PILE OF WOOD ON SOUTH SIDE OF PROPERTY"]
["257 H 4","I","2009-09-20","5939","RIO LINDA BLVD","CODX2009-05222","0","2009-08-31","COMMERCIAL TRAILER, AUTO PARTS NEAR FENCE IFO PROPERTY"]
["257 H 4","I","2009-09-20","6016","RIO LINDA BLVD","CODX2009-05216","0","2009-08-31","PORCH COUCH, TUB IN YARD NEAR FENCE"]
["257 H 4","I","2009-09-20","6229","RIO LINDA BLVD","CODX2009-05205","0","2009-08-31","PILE OF JUNK NEXT TO DRIVEWAY ON NORTH SIDE OF PROPERTY"]
["257 H 4","I","2009-09-20","6200","RIO LINDA BLVD","CODX2009-05211","0","2009-08-31","ILL. BUS. Auto Sales, junk(campershell, wood debris)"]
["257 H 4","I","2009-09-20","6210","RIO LINDA BLVD","CODX2009-05210","0","2009-08-31","MAR, INOP/UNREG (CAR UNDER CAR COVER)"]
["258 B 3","I","2009-10-01","6518","16TH ST","CODX2009-05384","308759","2009-09-11","LAWN PARKING: JUNK CAR IN YARD"]
["258 F 1","I","2009-10-05","7316","34TH ST","CODX2009-05431","309189","2009-09-15","YARD IS FULL OF BROKEN DOWN CARS AND TRUCKS"]
["258 F 2","I","2009-10-04","7019","32ND ST","CODX2009-05419","309107","2009-09-14","THERE'S A RETAIL STORE BEING RAN OUT OF THIS HOME FOR CAR RELATED ITEMS."]
["258 G 1","I","2009-09-22","3857","WRIGLEY CIR","CODX2009-05266","308371","2009-09-02","CALLER STATES THERE IS JUNK ON THE SIDE YARD AT THE ABOVE ADDRESS. JUNK CONSISTS OF WOOD, BIKES, COMPUTER MONITORS AND OTHER JUNK."]
["258 H 2","I","2009-09-22","4118","PAINTER WAY","CODX2009-05274","308287","2009-09-02","In/op car in driveway and numerous cars parked on the lawn."]
["258 H 2","I","2009-09-22","4136","PAINTER WAY","CODX2009-05275","308286","2009-09-02","Automotive repair in driveway and garage.  Revving engines late at night while working on cars."]
["258 J 1","I","2009-10-01","4241","STRATHMORE WAY","CODX2009-05218","308190","2009-08-31","COMMERCIAL TRUCK IN DRIVEWAY. NO LICENSE PLATES."]

{"sheet":"Sheet5","index":4,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4],[25,0,25,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 8/26/2009 To: 9/18/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 7","I","2009-10-05","4661","UNDERWOOD WAY","CODX2009-05423","309372","2009-09-15","TWO VEHICLES ON DRIVEWAY INOPERABLE AND/OR UNREGISTERD-  Red Ford Bronco Truck  License 2EEG549 3 flats, Black Compact Car w/ tarp sitting for two months License 4DCX885"]
["317 H 7","I","2009-09-12","4317","LIVINGSTON WAY","CODX2009-05383","309203","2009-09-11","HOUSING: surfacing sewage"]
["317 J 6","I","2009-10-08","5520","47TH AVE","CODX2009-05297","308611","2009-09-03","LACK OF ELECTICITY. LIGHTS GOES OFF IF LIGHTS ON ALL ROOM ARE ON. HALL WAY LIGHT DO NOT WORK.  PLUMING PROBLEM, BATHTUB TAKES ABOUT 3 HOURS TO DRAIN.  BATHROOM SINK IN THE MASTER BEDROOM ALSO TAKES A WHILE TO DRAIN. WINDOWS ARE VERY HARD TO OPEN AND CLOSED. MANAGER IS YOLANDA VALENCIA 916 419-7205,"]
["317 J 6","I","2009-09-16","5406","48TH AVE","CODX2009-05165","308019","2009-08-27","CHICKENS AND ROOSTERS ARE NOISY AND LOTS OF FECES."]
["317 J 7","I","2009-10-04","6612","BURDETT WAY","CODX2009-05408","309037","2009-09-14"," TRASH UP BY HOUSE IN GARBAGE CANS OVERFLOWING"]
["317 J 7","I","2009-10-21","6729","BURDETT WAY","CODX2009-05452","309252","2009-09-16","NO SMOKE DETECTORS IN A 6 BEDROOM HOUSE, ROACH INFESTATION-. NO DOWNSTAIRS HEATING UNIT,ONE OF THE SINKS IN THE KITCHEN IS NOT FUNCTIONAL BECAUSE THE SEWAGE DRAINS DOWN TO THE LOWER FLOOR SO THE SEWAGE DRAINS OUT INTO THE BACKYARD. "]
["337 J 1","I","2009-09-20","5414","SKY PKWY","CODX2009-05231","308078","2009-08-31","hold yard sales every other week here, and have been doing this for several years now."]
["338 A 2","I","2009-10-01","6307","66TH AVE","CODX2009-05365","308841","2009-09-11","GARBAGE AND OTHER TRASH AND DEBRIS ON SIDE AND BACK YARDS"]
["338 A 3","I","2009-09-20","7500","CITRUS AVE","CODX2009-05217","308083","2009-08-31","VACANT PROPERTY, OVERGROWN LAWN (WEEDS OVER 12\")"]
["338 A 3","I","2009-09-16","7594","CITRUS AVE","CODX2009-05175","307896","2009-08-27","INOPERABLE VEHICLE AND GARBAGE ON FRONT YARD. VACANT RESIDENCE IS IN STATE OF DISREPAIR."]
["338 A 3","I","2009-09-20","6034","POMEGRANATE AVE","CODX2009-05196","308086","2009-08-31","THERE IS TRASH, BROKEN FURNITURE AND OTHER DEBRIS ON THE FRONTLAWN AT ADDRESS LISTED."]
["338 B 1","I","2009-09-30","7020","STOCKER WAY","CODX2009-05338","308721","2009-09-10","M.A.R- THERE IS A BROWN CAMERO AND A WHITE VLOKSWAGEN"]
["338 B 2","I","2009-10-01","6808","FLEMING AVE","CODX2009-05159","308170","2009-08-27","HOUSING: OVEN MALFUNCTIONING, TOILET MALFUNCTIONING, UNSANITARY KITCHEN COUNTERTOPS, CEILING SAGGING"]
["338 B 2","I","2009-10-01","7420","LINDALE DR","CODX2009-05377","308953","2009-09-11","THERE IS A PILE OF TRASH ON THE SIDE OF ADDRESS LISTED"]
["338 C 2","R","2009-09-21","7812","LOUCRETA DR","CODX2009-05455","0","2009-09-16","VOA"]
["338 C 2","I","2009-10-06","7434","BRUNO WAY","CODX2009-05464","309033","2009-09-16","Huge pile of debris, furniture, broken trees, appliances, etc., spilling out into the street, and has been like this for about a week."]
["338 C 2","I","2009-09-23","7402","DELLA CIR","CODX2009-05322","308705","2009-09-03","7402 (DUPLEX). JUNK AND DEBRIS SUCH AS GARBAGE ALL OVER THE FRONT YARD."]
["338 C 2","I","2009-10-01","7700","SCOTTSDALE DR","CODX2009-05373","308800","2009-09-11","JUNK AND RUBBISH: CUT TREE TRIMMINGS AND CUT TREE BRANCHES"]
["338 C 2","I","2009-10-06","7334","GIGI PL","CODX2009-05443","0","2009-09-16","17920.3 (w) ALL BUILDINGS OR PORTIONS THEREOF OCCUPIED FOR LIVING, SLEEPING, COOKING, OR DINING PURPOSES THAT WERE NOT DESIGNATED OR INTENDED TO BE USED FOR THOSE OCCUPANTS LIVING IN A GARAGE,"]
["338 D 3","I","2009-10-05","8143","AUSTELL WAY","CODX2009-05422","309367","2009-09-15","ZONING: \"this house has many cars that have been parked there for years with out of date plates\""]
["Subzone:  C8"]
["319 H 2","I","2009-09-30","4386","MONHEGAN WAY","CODX2009-05339","308710","2009-09-10","JUNK AND RUBISH  IN THE BACKYARD, TOYS AND FURNITURE LEFT BEHIND WEEDS AND GREENWASTE LEFT HOUSE VACANT OVER 2 YEARS."]
["319 H 2","I","2009-09-30","4389","AUBERGINE WAY","CODX2009-05340","308712","2009-09-10","TOOK DOWN WOODEN SHED.HE STACKED THE WOOD IN THE BACK YARD OVER 6 MONTHS AGO. THE WOOD IS ROOTING ALONG THE SIDE OF HOUSE "]

{"sheet":"Sheet6","index":5,"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: 8/26/2009 To: 9/18/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 1","I","2009-09-21","3865","WRIGLEY CIR","CODX2009-05264","308375","2009-09-01","JUNK AND RUBBISH FROM YARD SALE"]
["258 G 3","I","2009-10-06","6561","KEMP WAY","CODX2009-05460","309280","2009-09-16","WORKING ON WRECKED CARS"]
["258 H 2","I","2009-09-23","4124","LUND CT","CODX2009-05288","308402","2009-09-03","Woodchip pile on front lawn that has rodents living in it"]
["258 H 4","I","2009-10-01","6205","CLAUSSEN WAY","CODX2009-05390","308730","2009-09-11","constituent said there are many in-op vehicles and many parts, such as transmissions scattered in back yard.  The smell of gear oil is very strong especially during days of hot weather."]
["258 H 4","I","2009-10-01","6117","LOCHLEVEN WAY","CODX2009-05382","309000","2009-09-11","There are ducks, chickens, and turkeys on this property for the last few weeks to a month."]
["258 H 4","I","2009-09-22","3900","STEPHEN DR","CODX2009-05272","308302","2009-09-02","THERE IS A PILE, OF TRASH, AUTO PARTS AND OTHER DEBRIS AT ADDRESS LISTED."]
["258 H 4","I","2009-10-01","6327","CLAUSSEN WAY","CODX2009-05368","308951","2009-09-11","A COUPLE HAVE BEEN LIVING IN AN RV THAT HAS BEEN PARKED IN FRONT OF STREET FOR OVER A MONTH. THE RV WAS MOVED TO THE LAWN IN FRONT YARD 4 DAYS AGO. COACHMEN RV LIC #R60876 TAN WITH BROWN STRIP RV. 308952-FORD PICK-UP TRUCK SILVER PARKED IN DRIVEWAY FOR OVER A YEAR LIC #6F11009. SPIDER WEBS UNDER TRUCK NO OTHER APPARENT DAMAGE. 308968-RV on front lawn at this address since Saturday, was reported as being on the street previously, people still living in it, extension cords, cable TV etc. all running out from the house.  Not on a concrete slab, no septic etc."]
["258 H 4","I","2009-10-05","6121","CHANNING DR","CODX2009-05425","309245","2009-09-15","3 or 4 beehives/bee boxes out in the back yard of this house.  "]
["258 H 4","R","2009-09-09","6100","GAY WAY","CODX2009-05291","308438","2009-09-03","vacant unmaintained property, weeds over 4' high. fire hazzard. 308442-OWNERS LEFT PROPERTY, HAVE JUNK AND RUBBISH STACKED UP AND STREWN IN THE FRONT AND BACKYARD.  NO APPLIANCES,BROKEN CONCRETE, ASSORTED TRASH, ELECTRONICS, CHAIRS, FURNITURE, MATTRESSES. RATS EVERYWHERE.   /\\/\\ HOUSING: VOA (PER COMPLAINT #308439)"]
["258 H 4","I","2009-09-03","4009","BRUCE WAY","CODX2009-05150","307843","2009-08-27","the weeds at this address are over 12 ft high. home is a foreclosure and vacant."]
["258 H 5","I","2009-10-08","5608"," SAN VINCENTE WAY","CODX2009-05335","308897","2009-09-09T15:40:10.780","VOA - GARAGE DOOR BROKEN AND OPEN.....09/11/2009-308893-VACANT RESIDENCE WITH TRASH, RUBBISH AND OTHER DEBRIS IN BACKYARD. 308896-VACANT RESIDENCE HAS DRY WEEDS MORE THAN 2 FEET TALL IN FRONT AND BACK YARDS. FIRE HAZARD."]
["258 H 5","I","2009-10-05","5969","GEORGIA DR","CODX2009-05428","309212","2009-09-15","THIS ADDRESS HAS MATTRESS AND PIECES OF WOOD IN THE DRIVEWAY"]
["258 H 6","I","2009-09-30","5416","JACKSON ST","CODX2009-05134","308072","2009-08-26","HOUSING: RODENT INFESTATION (in apt 45)"]
["258 H 7","I","2009-10-16","3939","TRICIA WAY","CODX2009-05374","308792","2009-09-11","HOUSING: water heater not properly maintained -- leaks from safety valve"]
["258 H 7","I","2009-09-23","4031","WARD AVE","CODX2009-05314","308637","2009-09-03","WASHER & DRYER,IN BACKYARD,MOTORCYCLE,GARBAGE ON THE SIDE YARD.ROACH INFESTATION,"]
["258 J 4","I","2009-10-23","6235","WHITECLIFF WAY","CODX2009-05491","309366","2009-09-18","HOUSING: DANGEROUS FLOORING (EXPOSED TACK STRIPS); PLUMBING PROBLEMS (WASHER DRAIN BACKS UP); "]
["258 J 5","I","2009-09-16","5954","CROWDER WAY","CODX2009-05179","307935","2009-08-27","ROOSTER AT THIS ADDRESS"]
["259 A 3","I","2009-09-18","4818","MONET WAY","CODX2009-05483","309544","2009-09-17","THERE IS SEWAGE SERFACING THROUGH THE BATHTUBS AND SINKS IN THE HOME AT THE ABOVE ADDRESS. "]
["278 G 1","I","2009-09-23","3561","ORANGE GROVE AVE","CODX2009-05316","308644","2009-09-03","Several vehicles on lawn (4) and inop on driveway (2-3), has been like this a few weeks."]
["278 H 1","I","2009-09-23","4800","JACKSON ST","CODX2009-05315","308642","2009-09-03","Has a fridge with the door on it in the driveway for the past several weeks."]
["278 H 1","I","2009-09-23","4601","RULA CT","CODX2009-05312","308596","2009-09-03","FURNITURE,CLOTHES,STOVES TRASH&DEBRI ALL OVER FRONT AND BACK OF PROPERTY"]

{"sheet":"Sheet7","index":6,"n_rows":22,"n_cols":9,"rows_kept":22,"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: 8/26/2009 To: 9/18/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Marina Jauregui"]
["Subzone:  E2"]
["259 D 6","I","2009-10-04","6209","TEMPLETON DR","CODX2009-05418","309104","2009-09-14","LOCATED IN FRONT YARD AND IN DRIVEWAY IS VARIOUS JUNK AND DEBRIS THAT HAS BEEN THERE FOR ABOUT 1 MONTH OR MORE."]
["259 D 7","I","2009-09-16","6106","RUTLAND DR","CODX2009-05174","307893","2009-08-27","CONSTRUCTION DEBRIS ON SIDE OF HOUSE"]
["259 E 6","I","2009-09-20","6310","APPIAN WAY","CODX2009-05232","307604","2009-08-31","THERE IS 1 DISH THAT IS LOCATED ON A POLE THAT IS BOLTED ON THE HOUSE THAT IS MORE THAN 3 FT IN DIAMETER.  THERE ARE 2 ANTENNAS THAT ARE ALSO MOUNTED ON THE SAME POLE.  THERE IS A TOTAL OF 6 ANTENNAS MOUNTED ON THE ROOF.  TWO BEING T.V. ANTENNAS.\n"]
["259 E 7","I","2009-10-04","6512","SAINT JAMES DR","CODX2009-05405","309024","2009-09-14","OUTBUILDING HAS SOMEONE LIVING IN IT"]
["259 F 6","I","2009-10-06","6801","LINCOLN OAKS DR","CODX2009-05450","309296","2009-09-16","THIS ADDRESS HAS A TRAILOR AND 3 IN-OP VEHICLES PARKED ON THE FRONT LAWN. ALSO THE ADDRESS IS DISMANTLING VEHICLES AND MAJOR AUTO WORK BEING DONE IN THE DRIVEWAY AS WELL."]
["259 G 6","I","2009-10-01","7350","MADISON AVE","CODX2009-05367","308823","2009-09-11","JUNK & RUBBISH ON PRIVATE PROPERTY. THIS IS AN OLD VACANT GAS STATION, THEY HAVE PULLED DOWN THE METAL FENCING, PAPERS, ASSORTED JUNK, LOOKS HORRIBLE."]
["259 G 7","I","2009-09-16","7310","ROBIN RD","CODX2009-05142","307812","2009-08-27","JUNK AND DEBRIS IN FRONT YARD. 307813-TWO TRAILERS IN FRONT YARD"]
["279 B 4","I","2009-10-04","3617","CASA ROSA WAY","CODX2009-05412","309065","2009-09-14","ONGOING YARD SALE."]
["279 B 5","I","2009-10-23","5128","ROBERTSON AVE","CODX2009-05490","308796","2009-09-18","HOUSING: UNIT 1 or A: WATER INTRUSION FROM SWAMP COOLER"]
["279 B 6","I","2009-10-01","5405","MIRIAM CT","CODX2009-05169","308037, 308044, 308045, 308039, 308009","2009-08-27","-OWNER HAS 3 BIG FLAT BED TRAILERS PARKED ON THE PROPERTY NOT REGISTERED. THESE HAS BEEN PARKED FOR SEVERAL MONTHS.\n-301-04.8 (A) PARKING EXCEEDS 40% OF FRONT YARD AREA. DOES NOT MEET SURFACING REQUIREMENTS.\n-OWNER HAS JUNK ALL OVER THE BACK YARD.  USED TRAFFIC DEVICES, SCRAP METAL AND RUBBISH.\n-COMMERCIAL VEHICLES PARKED ON RESIDENTAIL PROPERTY VIOLATION # 301-03.\n-MOTORHOME ON FRONT LAWN."]
["279 C 2","I","2009-09-17","4212","CASA BLANCA LN","CODX2009-05184","307981","2009-08-28","CALLER REPORTS FURNITURES, TOYS, FOOD AND OTHER JUNK ALL OVER THE BACKYARD OF ABOVE ADDRESS. GOING ON FOR ABOUT MONTH."]
["279 C 2","I","2009-09-05","4200","CASA BLANCA LN","CODX2009-05329","308443","2009-09-04","VOA: \"CONSTITUENT STATES THAT UNIT IS VACANT BUT IS BEING LIVED IN BY PEOPLE. WINDOWS HAVE BEEN BROKEN TO GAIN ACCESS INTO DUPLEX.\""]
["279 D 3","I","2009-10-01","7701","FAIR OAKS BLVD","CODX2009-05352","308904","2009-09-11","''JEWLERY EXCHANGE'' BUSINESS HAS BANNERS AND OLD BLUE VAN WITHOUT PLATES WITH NON-OP STATUS WITH MORE SIGNS ON IT. THIS VAN BLOCKS THE VIEW OF OTHER BUSINESS."]
["279 F 1","I","2009-10-06","6900","ELLSWORTH CIR","CODX2009-05449","309177","2009-09-16","A tan Volvo parked on the side of the driveway for several months license # 69vs950"]
["279 F 4","I","2009-10-05","3547","ALTAMONT DR","CODX2009-05430","309209","2009-09-15","Various junk and debris on yard/walkways/porch. It looks like the owners are running a recycling business.\n309381: ASSORTED PROBLEMS AT THIS HOUSE, FRONT DOOR WINDOW IS BOARDED UP FOR OVER 1 YEAR, 5 OTHER WINDOWS ARE BOARDED UP. THERE IS NO ELECTRIC/POWER TO THE HOUSE, THE OWNER IS USING A GAS GENERATOR TO PROVIDE POWER TO THE HOUSE. THE GENERATOR IS INSIDE THE GARAGE THAT EMITS GAS FUMES AND APPEARS TO BE A FIRE HAZZARD."]
["279 G 2","I","2009-09-23","7304","WALNUT RD","CODX2009-05310","308554","2009-09-03","A PILE OF MISCELLANEOUS DEBRIS IN THE FRONT YARD"]
["279 G 2","I","2009-09-23","7317","WALNUT RD","CODX2009-05318","308558","2009-09-03","A PILE OF MISCELLANEOUS DEBRIS IN THE FRONT YARD. 308559-THERE ARE 2 CARS THAT ARE PARKED ON THE FRONT LAWN OF REFERENCED PROPERTY"]

{"sheet":"Sheet8","index":7,"n_rows":25,"n_cols":9,"rows_kept":25,"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: 8/26/2009 To: 9/18/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Jenneil Parks"]
["Subzone:  S3"]
["298 J 6","I","2009-10-05","9208","VANCOUVER DR","CODX2009-05421","309365 ","2009-09-15","INOPERABLE AND/OR UNREGISTED VEHICLE wHITE cHRYSLER (5CZV087), BLUE FORD VAN (3DHN883), BLUE FORD VAN (2KDC115) ON DRIVEWAY"]
["299 A 5","I","2009-09-23","9475","BUTTERFIELD WAY","CODX2009-05286","308398","2009-09-03","TRASH ON PROPERTY"]
["299 A 5","I","2009-09-09","9470","BUTTERFIELD WAY","CODX2009-05284","308397","2009-09-03","TRASH ON PROPERTY"]
["299 A 5","I","2009-09-23","9443","FORT WORTH WAY","CODX2009-05287","308401","2009-09-03","VACANT, DRY WEEDS MORE THAN ONE FOOT TALL. FIRE HAZARD."]
["299 A 5","I","2009-09-21","9436","BUTTERFIELD WAY","CODX2009-05249","308391","2009-09-01","DRY WEEDS MORE THAN TWO FEET TALL"]
["299 A 7","I","2009-09-23","3505","CONTEMPO DR","CODX2009-05308","308524","2009-09-03","Home vacant about 3 years, grass/weeds in back yard growing up over fence"]
["299 A 7","I","2009-09-19","9332","PREMIER WAY","CODX2009-05489","309566","2009-09-18","HOUSING: VOA"]
["299 B 4","I","2009-09-22","2712","EL CERRO CT","CODX2009-05277","308279","2009-09-02","**WEBMAIL**GARAGE OVERFLOWING WITH TRASH AND DEBRIS."]
["299 C 7","B",null,"9700","GOETHE RD","CODX2009-05328","11111111","2009-09-04","JJohn McKenney Test"]
["318 H 1","I","2009-10-05","8900","KIEFER BLVD","CODX2009-05209","308157","2009-08-31","CORNER LOT HAS VERY HIGH WEEDS ABOUT 18'' TO 3'. HOME APPEARS TO BE VACANT. NO LIGHTS, NO MOVEMENT, CAR IN DRIVEWAY THAT IS NEVER MOVED."]
["318 J 2","I","2009-10-16","4005","ASHGROVE WAY","CODX2009-05362","308928","2009-09-11","RED PICKUP IN DRIVEWAY WITH TRASH IN BED, NO LICENSE PLATES."]
["318 J 2","I","2009-09-30","4016","ASHGROVE WAY","CODX2009-05348","308923","2009-09-10","WHITE PICKUP TRUCK, MAROON PICKUP TRUCK CAB AND SIXTEEN FOOT LONG CHASIS WITH WHEELS."]
["318 J 2","I","2009-10-01","3921","ASHGROVE WAY","CODX2009-05360","308925","2009-09-11","RED PICKUP TRUCK IN DRIVEWAY, NO LICENSE PLATES."]
["318 J 2","I","2009-10-01","3920","ASHGROVE WAY","CODX2009-05361","308927","2009-09-11","BLACK PICKUP TRUCK IN DRIVEWAY, NO LICENSE PLATES."]
["318 J 7","I","2009-10-06","6545","HEDGE AVE","CODX2009-05445","309124","2009-09-16","Home has junk all over the front and back yard. Old dismantled cars ,furniture, and appliances"]
["319 A 1","I","2009-09-23","9429","MIRANDY DR","CODX2009-05283","308396","2009-09-03","Vacant property, weeds over 2 feet in front/side yard."]
["319 A 1","I","2009-10-01","9432","MIRANDY DR","CODX2009-05393","309121","2009-09-11","JUNK AND RUBBISH"]
["319 B 1","R","2009-09-30","9532","MIRANDY DR","CODX2009-05130","proactive","2009-08-26","HOUSING: VOA, LACK OF WATER"]
["338 H 5","I","2009-10-05","9064","GEYSER PEAK WAY","CODX2009-05331","308681","2009-09-04","2 INOP VEHICLES, ONE IS OLDER GREY FORD PICK UP, NO MAJOR DAMAGE 2ND IS OLDER WHITE CHEVY BLAZER, NO MAJOR DAMAGE,PARKED IN DRIVE WAY"]
["338 H 6","I","2009-10-04","8108","DELFT CT","CODX2009-05413","309075","2009-09-14","PILES OF TRASH IN BACKYARD."]

{"sheet":"Sheet9","index":8,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[29,0,29,4],[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4],[11,0,11,4],[15,0,15,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 8/26/2009 To: 9/18/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 7","I","2009-09-17","5155","MADISON AVE","CODX2009-05183","307983","2009-08-28","CONSTITUENT STATES THAT THIS IS MYSTIC SHOP THAT IS ONLY LICENSED TO SELL GIFTS BUT THEY ARE PROVIDING FORTUNE TELLING SERVICES.  THE LICENSE HAS NOT BEEN TRANSFERRED TO THE NEW OWNERS.\nNAME OF THE BUSINESS IS PYSCHIC WORLD"]
["259 C 5","I","2009-08-29","5452","RAMBLER WAY","CODX2009-05188","308357","2009-08-28","HOUSING: VOA /\\ ZONING: VACANT UNMAINTAINED, J&R"]
["259 C 6","I","2009-10-09","5560","PALM AVE","CODX2009-05333","308421","2009-09-04","INTERIOR VECTOR ROACHES"]
["259 E 5","I","2009-10-01","6328","ASLIN WAY","CODX2009-05380","308977","2009-09-11","THERE IS A MOTOR HOME THAT IS IN-OP AND HAS BEEN PARKED IN THE DRIVEWAY FOR OVER A MONTH."]
["278 J 1","I","2009-09-16","4640","CREEK RD","CODX2009-05161","307793","2009-08-27","THERE ARE 3 VEHICLES PARKED ON THE LAWN AT ANY GIVEN TIME. AT THE MOMENT THERE IS A TOYOTA MINI MOTOR HOME WITH HOOD UP.  HAS BEEN THERE SINCE AUGUST 5TH. THIS IS CONSTANTLY HAPPENING. ALSO LOTS OF TRASH STREWN ACROSS THE FRONT YARD."]
["278 J 1","I","2009-09-22","4300","CARLE LN","CODX2009-05278","308246","2009-09-02","Large piles of sheet rock, tree limbs, old carpet, etc., has been here for 2-3 months.  There's a trailer full of garbage in the driveway."]
["Subzone:  C3"]
["278 G 3","I","2009-10-19","3520","AUBURN BLVD","CODX2009-05403","308906","2009-09-14","HOUSING: 3550 AUBURN BLVD APT 11: COCKROACH INFESTATION"]
["278 G 4","I","2009-10-21","3536","WATT AVE","CODX2009-05451","309235","2009-09-16","ROACHES"]
["278 G 4","I","2009-10-19","3525","WHITNEY AVE","CODX2009-05406","308930","2009-09-14","HOUSING: APT 17: COCKROACH INFESTATION"]
["Subzone:  C4"]
[null,"I","2009-10-15","2045","WYDA WAY","CODX2009-05349","308713","2009-09-10","HOUSING -- UNIT A33 -- failure to maintain provided appliances: built-in microwave screw coming out, dishwasher malodorous despite tenant's attempts to clean -- ALSO bathtub drain plug lifter does not function."]
["278 C 6","I","2009-10-06","2037","ROBERT WAY","CODX2009-05467","309141","2009-09-16","THERE ARE 3 STRUCTURES THAT WERE BUILT WITHOUT A PERMIT AND ARE NOW RENTED OUT IN THE BACKYARD."]
["278 C 7","I","2009-10-01","2020","EDWIN WAY","CODX2009-05378","308962","2009-09-11","THERE IS WHITE 2 DOOR SEDAN PARKED ON THE PROPERTY OVER A MONTH ON JACKS."]
["278 C 7","I","2009-09-30","2016","EDWIN WAY","CODX2009-05337","308963","2009-09-10","A RED PICKUP PARKED ON THE PROPERTY FOR A YEAR."]
["278 D 6","I","2009-09-22","2428","WULFF LN","CODX2009-05268","308338","2009-09-02","FURNITURE, TRAMPOLINE, APPLIANCES, BROKEN BICYCLES, AND OTHER TRASH AND DEBRIS IN EXCESS."]
["278 D 7","I","2009-09-21","2540","HERNANDO RD","CODX2009-05242","0","2009-09-01","J/R and landscaping debris all over the front yard"]
["278 E 6","I","2009-09-30","2500","FULTON AVE","CODX2009-05345","308865","2009-09-10","SIGNS: THERE IS AN ADVSERTISING SIGN THAT IS STICKING OUT OF THE GRASS IN FRONT OF THE CHEVRON."]
["278 F 6","I","2009-09-21","2740","MORSE AVE","CODX2009-05254","308381","2009-09-01","Standard size pickup on front yard. 09/03/09-308697-THERE IS A PILE OF MISCELLANEOUS DEBRIS LOCATED IN FRONT YARD OF PROPERTY. THE ITEM THAT IS ON THE PROPERTY IS A LARGE BEIGE FIXTURE THAT LOOKS LIKE IT BELONGS IN A RETAIL STORE."]
["298 D 2","I","2009-10-07","1351","FULTON AVE","CODX2009-05479","309463","2009-09-17","LOCATION IS 1351 FULTON AVE STRIP NEAR RITE AID.THE CALLER SAYS THIS ADDRESS IS A COMMERICAL BUILDING (NO BUSINESS NAME LISTED) THAT IS OPEN AND ACCESIBLE TO PEOPLE.THE MAJORITY OF THE WINDOWS HAVE BEEN BROKEN OUT."]
["298 D 2","I","2009-09-01","2510","WITTKOP WAY","CODX2009-05199","308383, 308671, 308692","2009-08-31","HOUSING APT 54: SURFACING SEWAGE"]
["298 D 3","I","2009-09-18","2409","CARTA CT","CODX2009-05472","309421","2009-09-17","VOA- CALLER STATES THE WINDOWS ARE SMASHED IN AND THE DOORS ARE KNOCKED OUT. THE GARAGE IS TORE DOWN. ALSO STATES THERE THERE IS A BUNCH OF JUNK ALL OVER THE OUTSIDE"]
["298 D 3","I","2009-10-19","1181","FULTON AVE","CODX2009-05417","309131","2009-09-14","HOUSING: APT 18: WATER INTRUSION THROUGH BASE OF WALLS WHEN NEIGHBOR SHOWER"]
["298 E 2","I","2009-10-04","2721","MAISON WAY","CODX2009-05409","309038","2009-09-14","THERE IS MAJOR AUTO REPAIR GOING ON THE PROEPRTY; THERE ARE ABOUT 10 CARS IN THE BACK YARD FOR REPAIR; RESIDENT WORKS ON THE CARS DURING NIGHT TIME IN THE BACK YARD; 309039-SOMEONE IS LIVING IN THE 30 FOOT, BROWN COLOR, SLIDE OUT TRAILER; THE TRIALER IS IN THE BACK YARD; IT IS HIDDEN FROM THE STREET; PER CALLER SOMEONE HAS BEEN LIVING IN IT FOR ATLEAST A MONTH;"]
["Subzone:  E5"]
["279 A 6","I","2009-09-20","2600","KENDALE WAY","CODX2009-05228","308217","2009-08-31","IN THE BACKYARD OF THIS ADDRESS THERE IS A MOTOR HOME,JET SKI'S, BROKEN DOWN CARS,CANT SEE PLATES "]

{"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: 8/26/2009 To: 9/18/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Dennis Springer"]
["Subzone:  C5"]
["317 G 4","B",null,"5290","MENDOCINO BLVD","CODX2009-05324","308700","2009-09-03","VACANT RESIDENCE DRY WEEDS MORE THAN TWO FEET TALL IN FRONT AND BACK YARDS\n9/2/09- 308698: VOA THROUGH BACK WINDOW"]

{"sheet":"Sheet11","index":10,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4],[15,0,15,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 8/26/2009 To: 9/18/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Rachel Sutherland"]
["Subzone:  E5"]
["278 E 5","I","2009-10-04","3210","LASSEN WAY","CODX2009-05420","309109","2009-09-14","PROPERTY IS VANCANT THE GRASS AND WEEDS ARE OVER A FOOT HIGH.."]
["278 F 3","I","2009-09-30","3421","LERWICK RD","CODX2009-05133","308124","2009-08-26","HOUSING: TERMITES"]
["278 F 3","I","2009-10-19","3370","LERWICK RD","CODX2009-05400","308548","2009-09-14","There are also roaches in the apt for past 6 months.  "]
["278 F 4","I","2009-09-23","3350","HARMONY LN","CODX2009-05293","308448","2009-09-03","THERE'S A 78' OR 80' CHEVY TON WHITE PICK UP IN DRIVEWAY, TWO TIRES FLAT & FULL OF GARBAGE."]
["278 G 4","I","2009-10-05","3604","SEAN DR","CODX2009-05424","309138","2009-09-15","THIS HOUSE IS VACANT; THE HOUSE HAS TRASH IN THE YARD; THERE IS DRY WOOD, CARDBOARD BOXES, WEED IS GROWN VERY HIGH; THERE IS 6 MONTHS OF TRASH IN THE YARD; THE GARAGE SMELL LIKE DEAD RATS; THERE IS COFFEE TABLE IN THE FRONT YARD; BACK YARD HAS BEDS/TABLE CHAIRS ETC. THE WHOLE PROPERTY HAS TRASH EVERY WHERE, INSIDE AND OUT;"]
["278 G 6","I","2009-09-21","2502","WATT AVE","CODX2009-05261","0","2009-09-01","Goodwill trailer in the parking lot."]
["278 H 5","I","2009-10-06","3009","OLIVE GLEN CT","CODX2009-05466","309092","2009-09-16","THERE IS A BOAT ON THE PROPERTY THAT HAS NO PLATES"]
["278 H 6","I","2009-09-16","2812","VERNA WAY","CODX2009-05171","307881","2009-08-27","EXCESSIVE RUBBISH PILED AGAINST COMMON FENCE."]
["279 A 4","I","2009-10-01","3637","MISSION AVE","CODX2009-05375","308615","2009-09-11","HAS MOVED A DUMPSTER LESS THAN 25 FEET FROM REPORTING PROPERTY. DUMPSTER LOCATED ON SOUTHWEST CORNER OF PROPERTY."]
["279 A 4","I","2009-10-01","4900","ENGLE RD","CODX2009-05371","308807","2009-09-11","CONSTRUCTION TRAILER AND VARIOUS TRAILERS ON PROPERTY"]
["Subzone:  E6"]
["278 E 7","I","2009-10-06","3018","EL CAMINO AVE","CODX2009-05456","309156","2009-09-16","IN THE DRIVEWAY THERE'S A SHELL OF A TRUCK, WOOD, AND PLASTIC COVERINGS."]
["278 E 7","I","2009-10-06","2667","LA VIA WAY","CODX2009-05448","309136","2009-09-16","This yard has been growing out and left to go to seed for almost a year, has a fence that is falling down, ivy is taking over things.  Place is an eyesore."]
["278 F 7","I","2009-09-30","3300","EL CAMINO AVE","CODX2009-05344","308866","2009-09-10","THERE IS AN A FRAME SIGN THAT IS ON THE GRASS ON THE CORNER OF EL CAMINO IT IS AN ADVERTISEMENT FOR ''ZONE LIVE''"]
["278 G 7","I","2009-10-06","3708","ATWATER RD","CODX2009-05462","309273","2009-09-16","A brown Lincoln  in the driveway for 3 years license 5RKJ157.\nA light blue Cadillac parked in op parked in the driveway. License # 3anh216."]
["278 H 7","I","2009-09-23","2329","MARYAL DR","CODX2009-05311","308592","2009-09-03","REMOVED CONCRETE FROM DRIVEWAY; PARKING TRUCK ON DIRT DRIVEWAY."]
["278 J 7","I","2009-10-04","4560","OXBOW DR","CODX2009-05399","307848","2009-09-14","THERE IS A AN OCCUPIED MOTOR HOME ON THE STREET THAT IS CONNECTED TO THE ABOVE ADDRESS THROUGH THE USE OF AN EXTENSION CORD.  HAS BEEN PARKED THERE FOR ABOUT 2 WEEKS."]
["279 B 7","R","2009-09-10","2413","GARFIELD AVE","CODX2009-05235","proactive","2009-08-31","ZONING: DRY WEEDS OVER THREE FEET /\\ HOUSING: SUBSTANDARD"]
["279 B 7","I","2009-10-08","5420","HALSTED AVE","CODX2009-05488","309449","2009-09-18","JUNK AND RUBBISH THERE ARE ABOUT 11 30GALLON BARRELS/TRAS CANS LOCATED IN THE BACKYARD.  NOT SURE IF ANYTHING IN THEM, LID CLOSED."]
["298 E 3","I","2009-09-20","1116","MORTON CT","CODX2009-05203","308131","2009-08-31","RESIDENTS OF THIS DUPLEX ARE RAISING GEESE AND CHICKENS."]
["298 F 1","I","2009-09-23","1840","MORSE AVE","CODX2009-05309","308584","2009-09-03","CONTINUAL YARD SALES"]
["298 F 4","I","2009-10-01","3330","ADAMS RD","CODX2009-05372","308648","2009-09-11","THERE IS A FENCE TOO CLOSE TO THE ROADWAY. SETBACK 305-83.2"]
["298 G 3","R","2009-09-18","1100","WATT AVE","CODX2009-05357","309146","2009-09-11","VOA -- FRONT WINDOWS BROKEN, FRONT DOOR STANDING OPEN."]
["298 H 5","I","2009-10-06","446","GROTON CT","CODX2009-05468","309266","2009-09-16","Occupied motorhome parked in the driveway\n\n\n\n"]
["298 J 1","I","2009-09-23","1752","OLYMPUS DR","CODX2009-05303","308487","2009-09-03","TRASH CANS ARE OVERFLOWING,TRASH ALL IN GROUND."]

{"sheet":"Sheet12","index":11,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4],[7,0,7,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 8/26/2009 To: 9/18/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Brian Tischbirek"]
["Subzone:  S7"]
["337 J 2","I","2009-10-19","7534","CIRCLE PARKWAY ","CODX2009-05396","308834","2009-09-14","PLUMBING:A FOUL ODOR THAT COMES FROM DRAIN SMELLS LIKE SEWER."]
["337 J 3","I","2009-10-04","5700","POMEGRANATE AVE","CODX2009-05398","308876","2009-09-14","EXPOSED WIRING IN SEVERAL ROOMS AND THE GAS OVEN DON'T WORK PROPERLY"]
["Subzone:  S8"]
["338 D 4","I","2009-09-16","7847","SHELLBROOK CT","CODX2009-05140","307808","2009-08-27","THERE IS LAWN PARKING AND MAJOR AUTOMOTIVE REPAIR HAPPENING AT THE ABOVE ADDRESS."]
["338 D 4","I","2009-09-16","8356","FIELDPOPPY CIR","CODX2009-05168","307805","2009-08-27","VEHICLES PARKED ON LAWN."]
["338 D 6","I","2009-09-16","8132","VISALIA WAY","CODX2009-05148","307828","2009-08-27","HAS WEEDS/GRASS IN THE FRONT YARD THAT ARE OVER 3 FEET TALL. THE HOME HAS BEEN VACANT FOR 4-6 MONTHS. 307879-DRY WEEDS MORE THAN 2 FEET TALL.  FIRE HAZARD."]
["338 D 6","I","2009-10-01","8182","OAK LANDING CT","CODX2009-05391","308726","2009-09-11","JUNK AND RUBBISH: 10-12 big black garbage bags along driveway/side of house and some all the way out to the street, been building up for the past few weeks.  Caller says that it looks like they just keep missing the garbage pick up."]
["338 D 6","I","2009-10-06","8204","ADEN WAY","CODX2009-05442","309110","2009-09-16","INOP BLACK CHEVROLET PICKUP PARKED IN DRIVEWAY"]
["338 E 5","I","2009-09-21","8336","SUMMER SUNSET DR","CODX2009-05255","308377","2009-09-01","ROOSTER/CHICKEN HAS A COOP ON THE PROPERTY.ROOSTER/ CHICKENS HAS OVER 11 IN THE YARD, IN A COUP. AND 10 NEW BABY CHICKS."]
["338 F 4","I","2009-09-08","7706","VALLEY WOOD DR","CODX2009-05213","308173","2009-08-31","REPAIRING ENGINES ON BOATS AND CARS ON PROPERTY."]
["338 F 6","I","2009-10-01","8632","DELAHYE CIR","CODX2009-05364","308942","2009-09-11","PROPERTY IS VACANT WITH 6'HIGH DRY WEEDS"]
["338 G 3","I","2009-09-20","7634","TAMARINDO BAY DR","CODX2009-05215","308174","2009-08-31","livestock/chickens"]
["338 G 3","I","2009-10-08","7621","TAMARINDO BAY DR","CODX2009-05487","308787","2009-09-18","GOLD/SILVER INFINITY WITH MAJOR FRONT END DAMAGE, UNDER TARP, PARKED IN DRIVEWAY."]
["338 G 3","I","2009-09-22","7626","CORNEJO WAY","CODX2009-05282","0","2009-09-02","2 WHITE INOP FORD VANS, ONE HAS A FLAT TIRE. MOTORCYCLE IN DRIVEWAY THAT ALSO APPREARS INOP"]
["338 G 4","I","2009-10-05","8840","SAILFISH BAY CIR","CODX2009-05433","309184, 309186","2009-09-15","FENCE OVER 6 FT AND TRAILER PARKED ON GRASS."]
["338 G 4","I","2009-09-16","8841","SAILFISH BAY CIR","CODX2009-05151","307778","2009-08-27","PARKING HIS BOAT ON THE LAWN.  HAS BEEN THERE FOR OVER ONE WEEK."]
["338 G 4","I","2009-10-06","8817","SAILFISH BAY CIR","CODX2009-05447","309180","2009-09-16","BLUE TWO-DOOR ACURA IN DRIVEWAY."]
["338 G 4","I","2009-09-23","8837","SAILFISH BAY CIR","CODX2009-05459","309183","2009-09-16","BOAT PARKED ON FRONT LAWN."]
["338 G 4","I","2009-10-05","8861","SAILFISH BAY CIR","CODX2009-05434","309181","2009-09-15","BOAT PARKED ON FRONT LAWN"]

{"sheet":"Sheet13","index":12,"n_rows":7,"n_cols":9,"rows_kept":7,"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: 8/26/2009 To: 9/18/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  undefined"]
["Subzone:  S1"]
["476 A 6","I","2009-10-06","611","W BRANNAN ISLAND RD","CODX2009-05243","0","2009-09-01","ZONING: JUNK AND RUBBISH\nHOUSING:rodent infestations, insect infestations, rot, leaky roof("]
["476 A 6","I","2009-09-22","611","W BRANNAN ISLAND RD","CODX2009-05243","0","2009-09-01","ZONING: JUNK AND RUBBISH\nHOUSING:rodent infestations, insect infestations, rot, leaky roof("]

{"sheet":"Sheet14","index":13,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4],[6,0,6,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 8/26/2009 To: 9/18/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Jared Wickliff"]
["Subzone:  C1"]
["258 E 2","I","2009-10-06","6900","28TH ST","CODX2009-05435","0","2009-09-16","Dead Ranger, fridge, scrap metal, other j/r in yard\n"]
["Subzone:  N1"]
["237 C 6","I","2009-10-07",null,null,"CODX2009-05480","0","2009-09-17","Pallets, scrap metals and appliances laying all over d/w.\n*Actual address: 1508 W. Elverta Rd., Sacramento CA 95836*"]
["238 D 5","I","2009-10-01","2369","MISSOURI WAY","CODX2009-05350","308541","2009-09-11","Mobile home in driveway being used for a a place to live.  Vehicles in driveway have temporary tags from DMV, but the tags were printed out from a copy machine, not from DMV.  A Camaro T-top has fake registration.  There is junk and rubbish and hazardous chemicals in the back yard."]
["238 D 6","I","2009-09-23","2328","MORTENSEN CT","CODX2009-05304","308488","2009-09-03","BODYWORK BEING DONE."]
["257 G 1","I","2009-10-01","218","ARCANO WAY","CODX2009-05355","308910","2009-09-11","HAS REFRIGERATOR LEFT IN FRONT OF GARAGE WITH DOORS ON IN FRONT YARD ON LEFT SIDE"]
["257 H 1","I","2009-10-05","628","Q ST","CODX2009-05429","0","2009-09-15","PER CEO RAG THEY ARE RUNNING A BUSINESS \"JIMS TRACTOR HAULING\" SIGNS EVERYWHERE ON THE PROPERTY ADVERTISING."]
["257 H 3","I","2009-10-07","509","LILAC LN","CODX2009-05484","0","2009-09-17","Dead truck in the driveway.  Expired registration and flat tires.\n"]
["257 J 1","I","2009-09-23","818","SUN RAY CT","CODX2009-05302","308466","2009-09-03","HAS CHICKEN AND ROOSTER"]
["257 J 1","I","2009-10-06","7104","9TH AVE","CODX2009-05458","309162","2009-09-16","VACANT RESIDENCE HAS INOPERABLE VEHICLE IN BACKYARD COVERED WITH TARP"]
["257 J 1","I","2009-10-01","900","LUCILE WAY","CODX2009-05369","308819","2009-09-11","Large amounts of household garbage all over the yard, along both sides of the driveway, just looks like they dump the trash cans out in the yard."]
["257 J 1","I","2009-09-23","817","SUN RAY CT","CODX2009-05300","308464","2009-09-03","HAS CHICKEN AND ROOSTERS  "]
["257 J 2","I","2009-10-04","6914","8TH ST","CODX2009-05414","309078","2009-09-14","THERE IS FURNITURE ALL ALONG THE DRIVEWAY AND FRONT YARD"]
["276 E 3","I","2009-10-06","3563","GARDEN HWY","CODX2009-05437","0","2009-09-16","Totalled red Toyota MR2 on front lawn.  Was left on the side of the road for 2 weeks, and when Code Enforcement came to tow it, somebody dragged it onto the lawn."]
["276 G 4","I","2009-10-06","3790","SAN JUAN RD","CODX2009-05436","0","2009-09-16","4 piles of j/r consisting of appliances, furniture, and other trash.  About 60 cubic yards.  In the northwest corner of the property.\n"]
["276 H 3","I","2009-10-06","3357","LEONA CIR","CODX2009-05438","0","2009-09-16","Dismantled El Camino body in d/w\n"]
["277 C 1","R","2009-10-19","1780","N MARKET BLVD","CODX2009-05353","0","2009-09-11","VIOLATION(S) OF USE PERMIT ***ALSO SEE PREVIOUS CASE DSCX2009-00325***"]

{"sheet":"Sheet15","index":14,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4],[22,0,22,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 8/26/2009 To: 9/18/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Scott Woodward"]
["Subzone:  E3"]
["260 E 5","I","2009-09-30","8843","FORTUNA WAY","CODX2009-05342","308880","2009-09-10","RD 4 ZONE: ALLOWED- MUST MEET 310-13 & 310-15(C) ROOSTERES"]
["260 E 6","I","2009-10-19","8820","MOHAWK WAY","CODX2009-05401","0","2009-09-14","VOA-opening window in the garage"]
["260 F 5","I","2009-09-08","8928","OAKMORE WAY","CODX2009-05236","308498","2009-08-31","VARIOUS JUNK ON DRIVEWAY AND ROOF"]
["260 F 5","I","2009-09-20","5829","HUSKER ST","CODX2009-05234","308497","2009-08-31","CARS PARKED ON LAWN"]
["260 F 6","I","2009-10-01","5700","BEAUREGARD WAY","CODX2009-05363","308935","2009-09-11","REPAIRS ON MOTORCYCLES. 09/11/2009-308936-PILE OF JUNK WOOD ON SIDE OF DRIVEWAY."]
["260 F 6","I","2009-09-16","5654","BEAUREGARD WAY","CODX2009-05170","307868","2009-08-27","HAS FURNITURE STACKED ON SIDE YARD VERY HIGH AND INDUSTRIAL SHELVES. THERE IS A WASHING MACHINE IN FRONT YARD."]
["260 G 3","I","2009-10-05","6825","CHESTNUT AVE","CODX2009-05366","308944","2009-09-11","Grinding & arc welding on what appears to be an unlicensed truck in front yard."]
["260 G 4","I","2009-09-03","9200","ORANGEVALE AVE","CODX2009-05157","308064","2009-08-27","Cars being repaired everyday."]
["260 G 5","I","2009-09-23","9112","SHERRILEE WAY","CODX2009-05298","308794 ","2009-09-03","INOPERABLE AND/OR UNREGISTER VEHICLS, JUNK AND RUBBISH CONSTRUCTION MATERIALS AND APPLIANCES ON FRONT YARD AT ALL TIMES"]
["260 G 6","I","2009-10-19","9161","MADISON AVE","CODX2009-05407","309016","2009-09-14","HOUSING: APT 25: ROACHES"]
["260 H 2","I","2009-09-30","7333","WALNUT AVE","CODX2009-05346","308854","2009-09-10","JUNK AND RUBBISH: TRASH AND DEBRIS "]
["260 H 2","I","2009-09-23","7312","WALNUT AVE","CODX2009-05292","308557","2009-09-03","THERE IS A BOAT THAT IS PARKED ON THE FRONT LAWN. 308556-THERE IS A PILE OF MISCELLANEOUS DEBRIS IN THE FRONT YARD"]
["260 H 2","I","2009-09-30","7307","WALNUT AVE","CODX2009-05347","308853","2009-09-10","JUNK AND RUBBIS TRASH AND OTHER DEBRIS"]
["260 H 3","I","2009-09-23","6621","MAIN AVE","CODX2009-05470","309360","2009-09-16","RESIDENT HAVE MAJOR AUTO REPAIR BUSINESS; THE CARS ARE REBUILT, THERE IS TENT IN THE BACK YARD AND RESIDENT IS PAINTING SPRAYING FIBERGLASS, AND FUMES ARE VERY STRONG, PER CALLER IT ON GOING ISSUE; "]
["260 H 4","I","2009-10-19","6441","BENNING ST","CODX2009-05411","309074","2009-09-14","HOUSING: UNIT 3: WATER INTRUSION THROUGH WALL; garbage disposal not functional"]
["260 H 6","I","2009-10-06","5500","CHAMISE CT","CODX2009-05463","309168","2009-09-16","there is a  open 10 feet tent full of boxes; the boxes are stacked to the top of the tent;  it is creating rat infestation; 309169-BLUE CAR ON GRASS."]
["260 J 5","I","2009-10-06","6032","ANTHONY DR","CODX2009-05453","309150","2009-09-16","HAS GARAGE SALES EVERY FRIDAY AND SATURDAY FOR THE LAST YEAR."]
["Subzone:  E4"]
[null,"B",null,"4231","NEW YORK AVE","CODX2009-05474","0","2009-09-17","ILLEGAL OCCUPANCY / CAMPGROUND / j7 R / INOP UNREG / "]
["260 F 7","I","2009-10-21","5232","SIMONE PL","CODX2009-05457","309207","2009-09-16","Back sliding glass door doesn't operate propertly, very hard to open/close, has no locks/latches on it at all.  "]
["260 F 7","I","2009-09-16","8905","RAMSTAD AVE","CODX2009-05162","308026","2009-08-27","Renters are running illegal business of car repair and sales at the above location. 9/16/2009-309111-Haulmark trailer parked on lawn between garage and tree, been there for a couple weeks now, was cited for being parked on the street more than 72 hours, was just moved up to the lawn."]
["260 F 7","I","2009-10-01","5104","ARROYO ST","CODX2009-05385","308758","2009-09-11","RD 3 ZONE:THERE ARE SEVERAL CHICKENS AT THE ABOVE ADDRESS"]
["260 G 7","I","2009-10-01","9100","WINDING OAK DR","CODX2009-05381","308998","2009-09-11","TRAVEL TRAILER PARKED ON FRONT LAWN."]
["279 H 1","I","2009-10-01","4810","KENTUCKY LN","CODX2009-05370","308816","2009-09-11","MOTORHOME ON PROPERTY IN DRIVEWAY HAS PEOPLE LIVING IN IT OVER SEVERAL MONTHS. THEY ARE RUNNING HOSE AND ELECTRICE TO THE TRAILOR. "]
["279 H 2","I","2009-10-05","7439","WISAM CT","CODX2009-05426","309225","2009-09-15","36 FT LONG BOAT COVERED WITH A TARP IN FRONT YARD."]
["279 J 2","B",null,"4231","NEW YORK AVE","CODX2009-05474","0","2009-09-17","ILLEGAL OCCUPANCY / CAMPGROUND / j7 R / INOP UNREG / "]
["280 B 2","R","2009-09-21","8265","WINDING WAY","CODX2009-05187","307967","2009-08-28","caller says front yard and garage is dumping, owner passed away unoccupied home. furniture, tree stumps, etc."]
["280 D 2","I","2009-10-01","8500","WINDING WAY","CODX2009-05392","309226","2009-09-11","BEES ZONED RD-2"]
["280 F 2","I","2009-10-01","4400","WALALI WAY","CODX2009-05376","308765","2009-09-11","LAWN PARKING: THREE VEHICLES PARKED ON LAWN, DODGE TRUCK, LICENSE 3Z07318, MERCEDES, LICENSE 1JU232, TOYOTA 4 RUNNER, LICENSE 1RMP715."]