{"text_format":"2","workbook":"xls","n_sheets":19,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5","Sheet6","Sheet7","Sheet8","Sheet9","Sheet10","Sheet11","Sheet12","Sheet13","Sheet14","Sheet15","Sheet16","Sheet17","Sheet18","Sheet19"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":19,"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":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]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 7/6/2009 To: 8/2/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-08-09","3115","PEPPERRIDGE DR","CODX2009-04338","305781","2009-07-20","THERE ARE WEEDS AS HIGH AS 3 FT IN PLACES AND 4FT IN THE BACK."]
["238 F 4","I","2009-08-12","3373","ALDER CANYON WAY","CODX2009-04420","306112","2009-07-23","NEIGHBOR HAS TIRES GAS CANS AND JUNK AND DEBRI ALL OVER YARD.."]
["238 F 6","I","2009-07-27","3162","BOULDER CREEK WAY","CODX2009-04105","304967","2009-07-07","A PICK UP TRUCK THAT IS PARKED ON THE FRONT LAWN OF REFERENCED PROEPRTY"]
["238 F 7","I","2009-08-05","3233","ORIOLE WAY","CODX2009-04290","305708","2009-07-16","JUNK AND DEBRIS SCATTERED IN THE FRONT YARD. CONSTRUCTION DEBRIS, CONCRETE, DIRT. "]
["238 F 7","I","2009-08-05","3331","SCOTLAND DR","CODX2009-04287","305707","2009-07-16","OVERGROWN WEEDS, VACANT UNMAINTAINED PROPERTY- WEEDS OVER 5' HIGH."]
["238 F 7","I","2009-08-05","3054","KINGLET WAY","CODX2009-04293","305706","2009-07-16","VEHICLE PARKED UP ON THE FRONT LAWN-CREAM COLORED, LICENSE PLATE 5AMD648"]
["238 F 7","I","2009-08-05","3040","KINGLET WAY","CODX2009-04295","305710","2009-07-16","VACANT UNMAINTAINED PROPERTY- WEEDS OVER 4-5' TALL"]
["238 F 7","I","2009-08-05","7743","DELANEY DR","CODX2009-04292","305704","2009-07-16","VEHICLE -YELLOW VAN PARKED ON GRASS IN FRONT YARD. LICENSE PLATE 7Z60826."]
["238 G 5","I","2009-08-20","3394","NIGHT STAR CT","CODX2009-04715","306542","2009-07-31","All sorts of junk and debris along back/side fence, furniture/appliances, other random junk.  there may be a gas tank out there also, it was beside the house, but has since been moved."]
["238 H 5","I","2009-07-30","8795","FOBES DR","CODX2009-04191","305327","2009-07-10","THERE IS A SMALL WHITE P/U THAT HAS BEEN PARKED ON THE LAWN FOR MONTHS. NO PLATES"]
["238 J 5","I","2009-09-01","8283","DALKEITH WAY","CODX2009-04595","306088","2009-07-28","HOUSING: RODENT HARBORAGE"]
["238 J 6","I","2009-08-04","8204","ROCKBURY WAY","CODX2009-04264","305599","2009-07-15","torn down an existing fence, rebuilt it 2 feet taller without using new support columns."]
["239 B 7","I","2009-08-10","5252","THOMASINO WAY","CODX2009-04365","305919","2009-07-21","Vacant home - weeds/grass in back yard and side yard very dry and at least a foot tall."]
["239 C 5","I","2009-08-12","5543","RIDGEPOINT DR","CODX2009-04428","306161","2009-07-23","REBUILDING CARS IN GARAGE AND SELLING THEM FROM HIS HOME."]
["259 A 1","I","2009-08-11","7429","AUSPICIOUS WAY","CODX2009-04387","306026","2009-07-22","THERES A LOT OF JUNK AND RUBBISH ON THE PROPERTY.  THE BACK YARD IS OVERGROWN AND CREATING A RODENT HARBORAGE."]
["259 A 1","I","2009-08-06","7564","EVENT WAY","CODX2009-04328","305794","2009-07-17","JUNK AND RUBBISH....07/20/2009-305774-JUNK AND DEBRIS ON PREMISES."]
["259 A 1","I","2009-08-19","4843","TORRINGTON PL","CODX2009-04657","305534","2009-07-30","ZONING: ILLEGAL/UNPERMITTED GARAGE CONVERSION"]
["259 A 1","I","2009-08-16","7344","AUSPICIOUS WAY","CODX2009-04487","306241","2009-07-27","ACCUMULATION OF LARGE PIECES OF FURNITURE AND APPLIANCES IN FRONT YARD."]
["259 A 2","I","2009-08-05","4912","ADORN CT","CODX2009-04304","305624","2009-07-16","NEIGHBOR IN COURT IS REPARING AUTO'S IN DRIVEWAY AND HAS A CHOP-SHOP IN BACK YARD"]
["259 A 2","I","2009-08-17","4820","PROPITIOUS CT","CODX2009-04563","306292","2009-07-28","THERE ARE 20 CHICKENS AND 1 TURKEY AT THE ABOVE ADDRESS"]
["259 B 1","I","2009-07-30","7616","LA TOUR DR","CODX2009-04192","305300","2009-07-10","ROOSTER CROWING CONSTANTLY"]
["259 B 1","I","2009-08-17","5244","TURRET CT","CODX2009-04581","306170","2009-07-28","OWNERS OF PROPERTY ARE KEEPING LIVESTOCK, GOATS & CHICKENS, THIS PROPERTY IS .9 ACRES, IS ZONED FOR LIVESTOCK, HOWEVER, THEY KEEP THE CHICKENS AND GOATS IN THE FRONT/SIDE YARD ARE OF THE PROPERTY THAT BACKS UP TO 7356 AND 7352 VERDUGO THAT ARE SINGLE FAMILY DWELLINGS NOT ZONED FOR LIVESTOCK, THE YARD IS FILTHY AND FLY RIDDEN FROM THE ANIMAL FECES AND THE SMELL IS OVERWHELMING. THE NOISE IS UNBEARABLE AT TIMES. IT SEEMS THERE SHOULD BE A SET BACK AREA FROM A RESIDENTIAL AREA THAT SHOULD BE MAINTAINED TO KEEP THE PEACE IN THE NEIGHBORHOOD."]
["259 C 1","I","2009-08-12","7217","CANDLESTICK WAY","CODX2009-04417","306072","2009-07-23","THERE IS AT LEAST 2 ROOSTERS, A DUCK, A GOOSE, AND A TURKEY AT THE ABOVE ADDRESS.  HAVE BEEN THERE AT LEAST ONE MONTH. 306186-ROOSTERS, CHICKEN AND TURKEY ON PROPERTY.  EXTREMELY NOISY DAY AND NIGHT."]
["259 C 2","I","2009-08-17","7131","DIABLO OAK CT","CODX2009-04558","306277","2009-07-28","CAR PARKED ON LAWN \nCAR NEVER MOVES, COLOR CAR IS RED NOT SURE OF MAKE.   GRASS HIGH AROUND CAR."]
["259 C 3","I","2009-08-05","5629","EASTRIDGE DR","CODX2009-04283","305651","2009-07-16","Major Auto Repair.  Also several junk cars that are partially dismantled."]

{"sheet":"Sheet2","index":1,"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]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 7/6/2009 To: 8/2/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-08-20","5790","MARTIN LUTHER KING BLVD","CODX2009-04727","306581","2009-07-31","CONCERNED WITH HOMELESS CAMP,  DEBRIS.  FIRE ON 7/26/2009 HAPPENED AT AROUND 5PM AND SHE IS CONCERNED EVERTHING HAS NOT BEEN CLEANED UP. "]
["317 G 2","I","2009-08-16","4019","E NICHOLS AVE","CODX2009-04498","306239","2009-07-27","THE VACANT HOME AT THE ABOVE ADDRESS HAS BEEN UNMAINTAINED FOR 2 YEARS. THERE IS GRASS/WEEDS OVER 6 FEET TALL."]
["317 G 3","I","2009-08-28","4990","DEL NORTE BLVD","CODX2009-04434","306284","2009-07-24","HOUSING: WINDOWS BROKEN OUT; DOOR IMPROPERLY INSTALLED; EXPOSED WIRING; HOLES IN WALL"]
["317 G 3","I","2009-08-28","4990","DEL NORTE BLVD","CODX2009-04434","306284","2009-07-24","HOUSING: WINDOWS BROKEN OUT; DOOR IMPROPERLY INSTALLED; EXPOSED WIRING; HOLES IN WALL"]
["317 G 3","I","2009-08-10","4150","42ND ST","CODX2009-04370","305910","2009-07-21","THERE ARE CHICKENS AT THE ABOVE ADDRESS."]
["317 G 4","I","2009-08-02","5220","MENDOCINO BLVD","CODX2009-04217","0","2009-07-13","JUNK AND RUBBISH, LAWN PARKING, INOPERABLE AND/OR UNREGISTERED VEHICLE"]
["317 G 4","I","2009-07-22","5371","MENDOCINO BLVD","CODX2009-04257","305570","2009-07-15","VEHICLE(S) PARKED ON LAWN."]
["317 G 4","R","2009-07-27","5111","MENDOCINO BLVD","CODX2009-04125","0","2009-07-09","LAWN PARKING"]
["317 G 5","I","2009-08-19","5830","MENDOCINO BLVD","CODX2009-04665","306508","2009-07-30","VACANT RESIDENCE DRY WEEDS IN FRONT AND BACKYARD MORE THAN TWO FEET TALL.  FIRE HAZARD."]
["317 G 5","I","2009-08-11","6028","41ST ST","CODX2009-04398","306121","2009-07-22","THE TENANTS/OWNER PACKED UP AND MOVED FROM THE RESIDENCE AND LEFT VARIOUS JUNK AND DEBRIS IN THE FRONT YARD."]
["317 G 5","I","2009-08-18","3888","35TH AVE","CODX2009-04651","306514","2009-07-29","ABANDONED RESIDENCE. TRASH ON PROPERTY"]
["317 G 5","R","2009-08-03","5917","MENDOCINO BLVD","CODX2009-04618","306506","2009-07-29","VOA....07/31/2009-306505-VACANT RESIDENCE HAS DEBRIS IN FRONT AND BACKYARDS, MAJOR DISREPAIR."]
["317 G 7","I","2009-08-12","4197","CUNY AVE","CODX2009-04430","306174","2009-07-23","THERE ARE A NUMBER OF APPLIANCES LOCATED IN THE FRONT YARD."]
["317 H 4","I","2009-08-04","5613","44TH ST","CODX2009-04250","305306","2009-07-15","ROOSTER ON THE PROPERTY"]
["317 H 4","I","2009-08-05","4441","FRUITRIDGE RD","CODX2009-04286","305716","2009-07-16","A LARGE DEBIRS PILE WOOD, SHRUBBERY,GRASS ALONG WITH OTHER THINGS IN THE REAR PARKING LOT."]
["317 H 4","I","2009-08-19","5620","NONA WAY","CODX2009-04667","306513","2009-07-30","COMMERCIAL VEHICLE PARKED IN DRIVEWAY BLOCKING VIEW OF STREET."]
["317 H 5","I","2009-08-12","5934","LAURINE WAY","CODX2009-04426","306151","2009-07-23","WEEDS OVER 6' TALL IN FRONT AND BACKYARD. VACANT FORECLOSED HOME"]
["317 H 5","I","2009-08-06","4740","39TH AVE","CODX2009-04331","305714","2009-07-17","ADDRESS HAS TO MANY PIGIONS IN CAGES AND OWNER IS NOT CLEANING UP THE WASTE FROM THE PIGIONS "]
["317 H 6","I","2009-08-06","6321","WELTY WAY","CODX2009-04313","305837","2009-07-17","THERE IS A BLUE VAN THAT HAS BEEN IN AN ACCIDENT,IT IS PARKED IN THE DRIVEWAY NEAR THE FENCE.\n305836: THERE IS MAJOR JUNK AND DEBRIS OUT IN THE PATIO SUCH AS OLD SWINGS, BIRD CAGES AND OTHER JUNK ITEMS"]

{"sheet":"Sheet3","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"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],[6,0,6,4],[8,0,8,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 7/6/2009 To: 8/2/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Barry Chamberlain"]
["Subzone:  C5"]
["317 H 2","R","2009-07-22","4748","16TH AVE","CODX2009-04270","305724","2009-07-16","VOA....305721-VACANT HOUSE.  EXTREMELY DRY WEEDS IN BACKYARD MORE THAN TWO FEET TALL. FIRE HAZARD."]
["Subzone:  C6"]
[null,"I","2009-08-11","7215","STOCKTON BL","CODX2009-04389","0","2009-07-22","CONTROL NUMBER: PLNP2009-00129- DANCE PERFORMANCE EVENT"]
["Subzone:  E5"]
["279 A 6","I","2009-07-29","4920","EDEN CT","CODX2009-04126","305075","2009-07-09","STATES THE ADDRESS ABOVE HOME IS VACANT AND WEEDS GETTING SO TALL AND GRASS COMING THROUGH HER FENCE AND BACKYARD IS A MESS"]
["Subzone:  S5"]
["420 A 6","I","2009-08-21","13589","CHEROKEE LN","CODX2009-04346","0","2009-07-21","Occupants living in a RV, commercial vehicles parked on the property & two kitchens in one dwelling."]

{"sheet":"Sheet4","index":3,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[10,0,10,4],[14,0,14,4],[17,0,17,4],[29,0,29,4],[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: 7/6/2009 To: 8/2/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Ty Colston"]
["Subzone:  C1"]
["456 A 5","I","2009-08-06","665","TYLER ISLAND BRIDGE RD","CODX2009-04186","0","2009-07-10","JUNK AND RUBBISH, INOPERABLE AND/OR UNREGISTERED VEHICLE(S), ILLEGAL OCCUPIED TRAVEL TRAILER"]
["Subzone:  C10"]
["437 A 1","I","2009-08-12","14143","TYLER ST","CODX2009-04429","306165","2009-07-23","Accumulation of garbage/trash on this property for the last six years. piles of trash are attracting flies and wasps, etc. 08/04/2009-306762-5 vehicles on this property, all parked in large driveway.  At least 3 inoperable, one has busted out windshield and flat tires, also a pickup truck with various car car parts in back, ***306792-CALLER REPORTS 4 IN OPERABLE VEHICLES IN DRIVE WAY,, OLDER GREEN FORD MINIVAN SITTING ON FLATS AND BUSTED OUT WINDSHIELD, 2ND OLDER BLUE POSS FORD MINIVAN NO SEEABLE DAMAGE,, 3RD OLDER GREY FORD PICK UP, RUSTED AND FULL OF DEBRI, 4TH OLDER GREEN ISUZU RODEO NO MAJOR DAMGAGE,, DEAD MOTOR....ALL 4 ARE INOPERABLE.."]
["Subzone:  C9"]
["419 C 2","R","2009-08-03","10016","TWIN CITIES RD","CODX2009-04185","0","2009-07-10","STORAGE OF INOPERABLE AND/OR UNREGISTERED VEHICLE(S)"]
["Subzone:  S1"]
["456 A 4","B",null,"732","TYLER ISLAND BRIDGE RD","CODX2009-04170","0","2009-07-09","FIRE DAMAGE STRUCTURE, VOA"]
["476 B 6","R","2009-08-04","395","BRANNAN ISLAND RD","CODX2009-04171","0","2009-07-09","ILLEGAL USES OF EXTENSION CORDS"]
["494 H 5","I","2009-08-09",null,null,"CODX2009-04341","0","2009-07-20","J/R - construction type material"]
["Subzone:  S4"]
["280 B 6","I","2009-08-05","2351","NEW EUREKA WAY","CODX2009-04187","305148","2009-07-10","OWNER HAS 5 TON STAKE BED TRUCK PARKED AT RESIDENCE FOR OVER 4 WEEKS FILLED WITH GARBAGE."]
["282 C 6","I","2009-08-31",null,null,"CODX2009-04360","0","2009-07-21","\"0\" PLACERVILLE RD- INOPERABLE AND/OR UNREGISTERED VEHICLE, JUNK AND RUBISH, STORAGE OF A MOBILE HOME"]
["Subzone:  S5"]
["339 C 6","I","2009-08-10","9719","VINTAGE PARK DR","CODX2009-04357","0","2009-07-21","STORING COMMERICAL VEHICLE"]
["339 D 4","I","2009-08-10","10048","CROOKED STICK DR","CODX2009-04359","0","2009-07-21","INOPERABLE AND/OR UNREGISTERED VEHICLES"]
["339 D 4","I","2009-08-10","10083","MISSION HILLS DR","CODX2009-04358","0","2009-07-21","INOPERABLE AND/OR UNREGISTERED VEHICLE"]
["379 J 1","I","2009-08-14","9985","COSUMNES RD","CODX2009-04220","0","2009-07-14","INOPERABLE AND/OR UNREGISTERED VEHICLE"]
["401 D 3","I","2009-08-11","11652","GIUSTI RD","CODX2009-04388","306030","2009-07-22","THE OUTBUILDING IN THE BACK IS BEING RENTED OUT AGAIN; STATE CODE ENFORCEMENT DEEMED IT INHABILABLE LAST TIME;"]
["420 A 5","I","2009-08-17","11375","SIMMERHORN RD","CODX2009-04437","0","2009-07-24","Junk & Rubbish, Inop/Unreg"]
["420 A 5","I","2009-08-13","11322","BLEHM RD","CODX2009-04440","0","2009-07-24","Junk & Rubbish, Inop/Unreg"]
["420 A 5","I","2009-08-13","11363","SIMMERHORN RD","CODX2009-04438","0","2009-07-24","Junk & Rubbish, Inop/Unreg"]
["420 A 5","I","2009-08-13","13545","CHEROKEE LN","CODX2009-04435","0","2009-07-24","Junk & Rubbish, Inop/Unreg"]
["420 A 5","I","2009-08-17","11337","BLEHM RD","CODX2009-04439","0","2009-07-24","Junk & Rubbish, Inop/Unreg"]
["420 B 2","B",null,"11601","BORDEN RD","CODX2009-04120","305055","2009-07-08","PEOPLE LIVING IN OUT BUILDINGS-10 PEOPLE- LIVING IN 3 SEPARATE BARNS, NO POWER, WATER OR TOILET FACILITIES TO ANY. THE PEOPLE ARE DEFICATING IN THE YARD. "]
["Subzone:  S9"]
["419 D 2","R","2009-08-03","10134","TWIN CITIES RD","CODX2009-04184","0","2009-07-10","INOPERABLE AND/OR UNREGISTERED VEHICLE"]

{"sheet":"Sheet5","index":4,"n_rows":23,"n_cols":9,"rows_kept":23,"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: 7/6/2009 To: 8/2/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 3","I","2009-08-17","55","W RINETTI WAY","CODX2009-04593","0","2009-07-28","Overgrowth of vegetation"]
["257 J 4","I","2009-08-11","6132","10TH ST","CODX2009-04401","0","2009-07-22","Overgrowth of vegetation \n\n\n\n"]
["257 J 4","I","2009-08-10","6027","MIO CT","CODX2009-04371","305961","2009-07-21","THERE IS A CAR, TIRES, 5 GALLON PAINT CANS AND LOTS OF OTHER JUNK IN THE BACK YARD.  SOME OF IT IS LEANING AGAINST A FENCE."]
["258 B 4","I","2009-08-10","1537","G ST","CODX2009-04364","0","2009-07-21","\"NOR CAL EMPLOYMENT AGENCY\" LARGE BANNER ON FENCE"]
["258 D 3","I","2009-08-20","2501","I ST","CODX2009-04332","305903","2009-07-17","Surfacing sewage in back yard.  Can not flush without sewage surfacing.  Children in the house.  Referred from a CPS worker who made a visit and witnessed the unsafe living conditions."]
["258 E 1","I","2009-08-05","3000","U ST","CODX2009-04277","305653","2009-07-16","THERE ARE ABOUT 20 CARS PARKED ON THE LAWN, OPERABLE."]
["258 G 1","R","2009-08-17","7144","THOMAS DR","CODX2009-04111","304891","2009-07-07","there are weeds and grass taller than one foot tall on this property, and it's been more than a year that it's been this way.\nHouse is vacant.\n304984: Home is vacant and open with vagrants living in it.  Neighbor went into home and found clothes, dirty diapers and duffel bags.  There is also someone living on the front porch."]
["258 G 2","R","2009-08-20","3616","TURNER DR","CODX2009-04132","305009,305010","2009-07-09","CALLER STATES VACANT AND UNMAINTAINED AT THE ABOVE ADDRESS. WEEDS ARE OVER 4 FEET TALL. ISS# 305010 CP (SAL SIUENTES 916-331-1896)  STATES THAT THERE IS ALSO JUNK & RUBBISH ON THE DRIVE WAY."]
["258 G 2","I","2009-08-12","3712","PLYMOUTH DR","CODX2009-04427","306157","2009-07-23","OVERGROWN VEGETATION: WEEDS OVER 12 INCHES HIGH. THIS PROPERTY HAS BEEN VACANT OVER A YEAR. "]
["258 H 1","I","2009-08-10","4000","CRUMLEY LN","CODX2009-04374","305970","2009-07-21","A CARS SALES BUSINESS FROM THIS HOME. \n\n\n\n\n"]
["258 H 2","I","2009-09-03","4133","RAMSEY DR","CODX2009-04193","305353","2009-07-10","LOCATED ON THE PROPERTY TOWARDS THE BACKYARD IS A BLUE MAZDA SEDAN...HAS BEEN THERE FOR ABOUT 3-5 MONTHS."]
["258 H 2","I","2009-08-12","6801","THOMAS DR","CODX2009-04432","306182","2009-07-23","MOBILEHOME IN DRIVEWAY WITH PEOPLE LIVING IN IT.  CORD RUNNING FROM HOUSE TO MOBILEHOME."]
["258 H 4","I","2009-08-05","4009","BRUCE WAY","CODX2009-04294","0","2009-07-16","Storage of inop/unreg vehicle(s) and overgrowth of vegetation....7/16/2009-305740-INOPERABLE BLACK MUSTANG GT, LICENSE 6HMR622, WINDSHIELD IS BROKEN, NO RADIO, NO TIRES."]
["259 B 2","I","2009-08-10","5209","BOOTJACK DR","CODX2009-04380","306013","2009-07-21","BLUE MINI VAN HAS BEEN REMOVED FROM THE STREET AND IS NOW IN THE DRIVEWAY, HAS NOT RUN\nFOR YEARS, THE BRAKES DONT WORK #ESC332 ALASKA PLATES."]
["259 B 2","I","2009-08-17","5150","DREAM CT","CODX2009-04152","0","2009-07-09","Inoperable/unregistered vehicle and construction debris and junk on the front and sides of the property\n"]
["259 B 2","R","2009-08-21","5153","DREAM CT","CODX2009-04155","0","2009-07-09","Inoperable/unregistered vehicle and furniture, mattress, junk on the front and sides of the property\n"]
["259 B 2","I","2009-08-17","5329","BOOTJACK DR","CODX2009-04500","0","2009-07-28","INOP/UNREG VEHICLE ON PROPERTY #2YRH543, EXPIRED REGISTRATION, SEE VAPX2009-02311/PREVIOUSLY ON THE STREET MOVED ONTO THE PROPERTY PER AMA"]
["259 C 2","I","2009-08-17","7055","KILKENNY DR","CODX2009-04596","0","2009-07-28","Junk and rubbish (yard waste and furniture in the front setback)\n"]

{"sheet":"Sheet6","index":5,"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],[27,0,27,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 7/6/2009 To: 8/2/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-08-11","6618","47TH ST","CODX2009-04385","306004","2009-07-22","CLOTHES, BOXES, SHOPPING CART, ETC. ALL ON FRONT YARD."]
["317 H 7","I","2009-08-13","6603","44TH ST","CODX2009-04173","305069","2009-07-09","HOUSING: COCKROACH INFESTATION /\\ HOUSING: COCKROACH AND RODENT INFESTATION"]
["317 J 6","I","2009-08-27","5611","MANMAR WAY","CODX2009-04407","306185","2009-07-23","HOUSING: LACK OF SMOKE DETECTORS, HOLES IN WALLS"]
["317 J 7","I","2009-08-10","6613","AUSTIN WAY","CODX2009-04373","305968","2009-07-21","OCCUPANTS REPAIR TRAILERS, DAILY, FOR SALE AT RESIDENCE"]
["318 B 7","I","2009-08-17","6900","RICHMAN WAY","CODX2009-04594","304841","2009-07-28","ROOSTER CROWING CONSTANTLY"]
["338 B 3","I","2009-07-30","7501","WILLIWAW LN","CODX2009-04178","305249","2009-07-10","THIS IS A VACANT PROPERTY THERE IS GRASS 12-18 INCHES HIGH "]
["338 C 1","I","2009-08-20","7949","SAMANTHA WAY","CODX2009-04725","306569","2009-07-31","THERE IS VARIOUS JUNK AND DEBRIS THAT HAS BEEN IN THE FRONT YARD ON THE PROPERTY FOR ABOUT 1 MONTH NOW."]
["338 C 1","I","2009-08-11","7244","LAMER WAY","CODX2009-04386","306018","2009-07-22","INOPERABLE BOAT AND TRAILER ON FRONT LAWN"]
["338 C 2","I","2009-08-18","7359","GIGI PL","CODX2009-04233","305506","2009-07-14","HOUSING: COCKROACH INFESTATION, ELECTRICAL PROBLEMS, HOLES IN THE WALLS"]
["338 C 2","I","2009-08-04","8020","BLACKHAWK DR","CODX2009-04258","305565","2009-07-15","HAS A ROOSTER AND CHICKENS IN BACKYARD"]
["338 C 2","R","2009-08-31","7742","FROST WAY","CODX2009-04655","306566","2009-07-30","VOA....7/31/2009-306568-THERE IS AUTO REPAIR GOING ON FOR ABOUT SIX MONTHS.  THE PROPERTY HAS VARIOUS VEHICLES THAT COME IN AND OUT OF THERE."]
["338 C 2","R","2009-07-27","7430","DELLA CIR","CODX2009-04412","0","2009-07-23","No power"]
["338 C 2","R","2009-07-27","7468","DELLA CIR","CODX2009-04408","0","2009-07-23","NO POWER"]
["338 C 2","I","2009-08-20","7746","FROST WAY","CODX2009-04723","306567","2009-07-31","THERE IS VARIOUS JUNK AND DEBRIS AMONGST THE FRONT YARD AND HAS BEEN THERE FOR ABOUT 6 MONTHS."]
["338 C 3","I","2009-08-16","7513","MCTAVISH CIR","CODX2009-04484","306209","2009-07-27","HAS TWO ROOSTERS."]
["338 D 2","I","2009-08-06","8169","TOMMY CIR","CODX2009-04324","305761","2009-07-17","REPAIRING AND UPHOLSTERING VEHICLES "]
["338 D 2","I","2009-07-29","8006","INGLESIDE WAY","CODX2009-04124","305109","2009-07-09","VANCANT HOUSE WITH DRY WEEDS IN THE FRONT AND BACK OF THE HOUSE OVER 12 INCHES HIGH. "]
["338 E 1","I","2009-08-12","8448","FLORIN RD","CODX2009-04424","306149","2009-07-23","THERE ARE STACKS OF WOOD ON THE PROPERTY. THE FIRE DEPARTMENT CAME OUT LAST YEAR. WAS TOLD THAT IT WAS A FIRE HAZARD."]
["338 F 1","I","2009-08-13","7049","FLORIN PERKINS RD","CODX2009-04451","306246","2009-07-24","ZONING: J&R"]
["338 F 2","I","2009-09-02","7259","HAYWARD DR","CODX2009-04637","306510","2009-07-29","HOUSING: WATER INTRUSION THROUGH CEILING, MALFUNCTIONING WINDOW, COCKROACHES, GENERAL DILAPIDATION"]
["338 F 2","I","2009-08-10","8521","SUN FLORIN DR","CODX2009-04350","305854","2009-07-21","A PILE OF METAL ABOVE THE FENCE IN THE BACKYARD AND TWO PILES OF WOOD IN THE DRIVEWAY."]
["338 F 3","I","2009-08-19","7580","EL TERRAZA DR","CODX2009-04097","304107","2009-07-07","VACANT HOME - Dry weeds, J/R: The front and back yard are covered in weeds, and there is furniture, machinery and other junk in the backyard of this vacant property."]
["Subzone:  C7"]
["298 H 7","I","2009-08-03","9051","MONTOYA ST","CODX2009-04241","304958","2009-07-14","front yard is a mess"]
["298 J 7","I","2009-07-30","2924","NORCADE CIR","CODX2009-04639","proactive","2009-07-29","VOA"]

{"sheet":"Sheet7","index":6,"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: 7/6/2009 To: 8/2/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 F 5","I","2009-08-17","3448","FREEDOM PARK DR","CODX2009-04214","305421","2009-07-13","HOUSING: COCKROACH INFESTATION"]
["258 G 2","I","2009-08-17","3650","JONOTHAN WAY","CODX2009-04528","306345","2009-07-28","THIS HOUSE HAS A LOT OF TRASH ALL AROUND THE FRONT YARD, CARDBOARD, ICE CHESTS, INOP VEHICLES. "]
["258 G 2","I","2009-08-26","3658","JONOTHAN WAY","CODX2009-04532","0","2009-07-28","VOA"]
["258 G 3","I","2009-08-20","6417","LARRY WAY","CODX2009-04761","306642","2009-07-31","LIGHT BLUE SEDAN IN THE DRIVE WAY AT THE ABOVE ADDRESS UP ON JACKS WITH NO FRONT WHEELS. THE CAR HAS BEEN LIKE THAT FOR 2 WEEKS."]
["258 G 5","I","2009-08-11","5920","N HAVEN DR","CODX2009-04399","306043","2009-07-22","Boat parked on grass.  Also trialer on grass"]
["258 H 3","I","2009-08-12","6544","GRAYLOCK LN","CODX2009-04297","0","2009-07-16","Commercial vehicle, lawn parking and inop unregistered vehicles"]
["258 H 3","I","2009-08-10","6431","LA CIENEGA DR","CODX2009-04355","305551","2009-07-21","House burned to the ground.  Weeds are now over six feet tall.  junk and rubbish."]
["258 H 3","I","2009-08-20","6533","BROCK DR","CODX2009-04709","306538","2009-07-31","RESIDENT HAVE CHICKENS, ROOSTER "]
["258 H 3","R","2009-07-31","6435","LA CIENEGA DR","CODX2009-04236","305549","2009-07-14","VOA"]
["258 H 4","I","2009-07-30","4049","FARMER WAY","CODX2009-04189","305196","2009-07-10","JUNK & RUBBISH (FURNITURE, PAILS, CART ETC.)"]
["258 H 4","I","2009-08-20","4053","FARMER WAY","CODX2009-04760","306610","2009-07-31","THERE IS A BLACK TOYOTA SEDAN LIC#4CYY356 THAT HAS BEEN PARKED ON THE LAWN AT THE ABOVE ADDRESS FOR ABOUT 6 MONTHS.  SEEMS TO BE INOPERABLE.  NO DAMAGE."]
["258 H 5","I","2009-08-19","3874","SANTA FE WAY","CODX2009-04674","0","2009-07-30","OVERGROWN VEGETATION"]
["258 H 6","I","2009-08-24","5416","JACKSON ST","CODX2009-04345","305943","2009-07-20","HOUSING: CENTRAL HEATING AND A/C UNITS NON FUNCTIONAL"]
["258 H 6","I","2009-08-05","3928","SENATE AVE","CODX2009-04274","305635","2009-07-16","IN DRIVEWAY THERE'S A INOP WHITE CHEVROLET OR FORD PICK UP. 305634-THERE'S JUNK & DEBRIS AND CONTAINERS WITH OIL IN IT AND CONTAINERS WITH AN UNKNOW SUBSTANCE, LIGHT BROWN IN COLOR, IN THE BACKYARD. AND THERE'S CHAIRS AND A BACKSEAT ON THE PATIO."]
["258 H 7","I","2009-08-18","3957","MYRTLE AVE","CODX2009-04648","306410","2009-07-29","THERE IS A BLUE DODGE CAR WITH EXP REG AND GREEN UTILITY TRAILER NO PLATES PARKED IN THE DRIVEWAY. THEY HAVE BEEN THERE FOR MONTHS."]
["258 J 2","I","2009-08-27","6873","HARLEQUIN WAY","CODX2009-04406","306179","2009-07-23","HOUSING: ELECTRICAL FAILURE AND MALFUNCTION"]
["258 J 4","I","2009-08-17",null,null,"CODX2009-04592","306008","2009-07-28","There's a transient camp along train tracks behind this house, caller says about 50 yards behind house past the dead end of the street.  Says it's been going on since last Nov/Dec, but been getting worse lately and causing a lot of illegal dumping issues, which have already been reported."]
["258 J 4","I","2009-08-04","6051","SPRINGHAVEN CIR","CODX2009-04268","305495","2009-07-15","VACANT RESIDENCE. DRY WEEDS IN FRONT AND BACK YARDS.  TALLER THAN TWO FEET. FIRE HAZARD."]
["258 J 6","I","2009-08-16","5523","MOORHOUSE CT","CODX2009-04480","306374, 306872","2009-07-27","JUNK AND DEBRIS IN BACKYARD"]
["258 J 6","I","2009-08-03","5542","TYLER ST","CODX2009-04235","0","2009-07-14","Inop/unreg, MAR"]
["258 J 6","I","2009-08-11","4306","TURNSWORTH CT","CODX2009-04201","304951","2009-07-13","THE CALLER STATES THAT THE RESIDENTS AT REFERENCED PROPERTY HAVE MISCELLANEOUS DEBRIS IN THE FRONT AND SIDE YARDS OF THE PROPERTY"]
["259 A 2","I","2009-08-02","4733","DON JULIO BLVD","CODX2009-04200","305120","2009-07-13","Owner at this address has an auto repair shop in his garage, doing engine repair and re-painting.  Caller states that there's always a smell of paint and oil, there's a car that was just painted in the driveway right now."]
["259 A 4","I","2009-08-19","4818","MCCLOUD DR","CODX2009-04671","305879 ","2009-07-30","ADDRESS HAS OVER 40 CATS.  "]
["259 A 5","I","2009-08-18","5849","MEGHAN WAY","CODX2009-04649","306465","2009-07-29","DARK BLUE VAN MAYBE VOYAGER OR ASTRO VAN. NOT RUNNING NO LICENSE BEEN ON SIDE OF DRIVEWAY SINCE DEC '08. 306465-AUTO IN PIECES IN DRIVEWAY FOR 4 MONTHS. COVERED WITH A TARP NOW. DARK SEDAN. NO LIC#"]
["259 A 6","I","2009-07-27","4635","JION CT","CODX2009-04099","304910","2009-07-07","THE RESIDENTS AT REFERENCED ADDRESS ARE KEEPING LARGE PILES OF REFUSE IN THE BACKYARD OF REFERENCED PROPERTY."]
["278 E 2","I","2009-08-10","2901","ORANGE GROVE AVE","CODX2009-04366","0","2009-07-21","Screen Fences: storage material on racks that are a third to a half again as high as the screened fencing"]
["278 G 1","I","2009-08-10","4521","LONGVIEW DR","CODX2009-04096","304926","2009-07-06","THERE ARE RACKS OF ROTTEN FOOD IN THE FRONT YARD. THERE IS A PILE OF TRASH IN THE BACK YARD. ALSO THERE ARE FIVE IN-OP VEHICLES ON THE DRIVEWAY. THE SIXTH VEHICLE IS PARKED ON THE GRASS."]

{"sheet":"Sheet8","index":7,"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: 7/6/2009 To: 8/2/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-08-17","6004","RUTLAND DR","CODX2009-04210","305154","2009-07-13","HOUSING: WATER INTRUSION FROM AC UNIT LEAKING"]
["259 D 7","I","2009-08-20","6008","MADISON AVE","CODX2009-04730","306582","2009-07-31","THERE ARE TREE SHRUBS,AN OLD POOL,LAWN CHAIRS ETC IN THE FRONT YARD."]
["279 B 4","I","2009-08-20","3611","AFFIRMED WAY","CODX2009-04758","306584","2009-07-31","A TIOGA FLEETWOOD MOTOR HOME PARKED IN THE DRIVEWAY FOR 3 MONTHS. HAS EXPIRED TAGS LICENSE 3AAT897. "]
["279 B 6","I","2009-08-04","5100","KOVANDA AVE","CODX2009-04253","305527","2009-07-15","WOOD TRIMMINGS, FURNITURE, COMPUTOR MONITOR,TARP, TOYS AND ALL KINDS OF TRASH AND DEBRI"]
["279 B 6","I","2009-09-03","5325","MARCONI AVE","CODX2009-04656","306589","2009-07-30","HOUSING: SPONGY SUBFLOORING IN LIVING ROOM, LEAKY BATHROOM TOILET, HOLE IN WALL WHERE SINK SHOULD BE"]
["279 C 4","I","2009-08-04","5448","ENGLE RD","CODX2009-04249","305415","2009-07-15","CONSTRUCTION DEBRIS, TARILER W/TRASH, BOARDS AGAINST GARAGE DOOR."]
["279 C 6","I","2009-08-25","5530","KENNETH AVE","CODX2009-04119","0","2009-07-08","Junk and rubbish-- shoping carts, engine parts, couch, boxes, bottles, all kinds of debris.\nInop/unreg RV in driveway\n* additional issue (305940) - OCCUPIED RV PARKED ON THE DRIVE-WAY.  WHAT/RUST COLORED*"]
["279 C 6","I","2009-08-24","5529","MARCONI AVE","CODX2009-04604","0","2009-07-29","voa"]
["279 D 1","R","2009-08-20","4854","SCOTCH CT","CODX2009-04197","0","2009-07-10","Inop/unreg Red  Ford Exp 3BLJ068"]
["279 D 1","I","2009-08-12","6041","RYE WAY","CODX2009-04425","306150","2009-07-23","VACANT DUPLEX, WEEDS MORE THAN TWO FEET TALL. FIRE HAZARD."]
["279 D 1","I","2009-08-20","6031","RYE WAY","CODX2009-04196","0","2009-07-10","Unreg Ford Exp 5CXN411"]
["279 D 1","R","2009-08-20","6029","NORTHCREST CIR","CODX2009-04172","0","2009-07-09","Inop/Unreg vehicles\n"]
["279 D 1","I","2009-08-20","6017","RYE WAY","CODX2009-04195","0","2009-07-10","Unreg BMW in driveway"]
["279 D 3","I","2009-08-19","7733","FAIR OAKS BLVD","CODX2009-04675","0","2009-07-30","ILLEGAL SIGNS \"E-BIKES $599\", DISPLAYING BIKES WITH OUT PERMIT"]
["279 D 5","I","2009-08-18","6012","LEAFWOOD DR","CODX2009-04640","0","2009-07-29","Inop/unreg vehicles - a Pontiac Firebird plate 4BTA760\nand a Ford Truck 4T00153; both out of reg and covered in dirt and webs. \n"]
["279 D 7","R","2009-08-18","6000","VAN ALSTINE AVE","CODX2009-04118","0","2009-07-08","Inop/unreg vehicles at property\n"]
["279 E 3","I","2009-08-04","4117","MARSHALL AVE","CODX2009-04263","305608","2009-07-15","SAYS 4 IN OP VEH,ON FRONT DRIVEWAY\nMOTORHOME,AND CARS,SAYS SOME IN BACK YARD."]
["279 F 3","I","2009-08-06","4201","FRIDA MARIA CT","CODX2009-04662","306500","2009-07-30","OPERATING A RECYCLING BUSINESS OUT OF RESIDENCE."]
["279 F 4","I","2009-08-10","6838","GRANT AVE","CODX2009-04363","0","2009-07-21","Junk and rubbish and inop/unreg vehcles"]
["279 G 2","I","2009-08-17","7308","WALNUT RD","CODX2009-04550","306323","2009-07-28","HOME IS VACANT AND HAS OVERGROWN WEEDS OF 12'' OR HIGHER."]
["279 G 3","I","2009-08-20","4146","JOY LN","CODX2009-04759","306608","2009-07-31","there is an occupied 5th wheel at least 5ft away from the fence"]

{"sheet":"Sheet9","index":8,"n_rows":11,"n_cols":9,"rows_kept":11,"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],[9,0,9,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 7/6/2009 To: 8/2/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Jose Mendez"]
["Subzone:  E6"]
["298 F 3","R","2009-08-17","3332","CHURCHILL RD","CODX2009-04402","306104","2009-07-23","VOA"]
["Subzone:  S3"]
["319 B 5","I","2009-08-09","5645","BRADSHAW RD","CODX2009-04340","0","2009-07-20","Junk and rubbish \n"]
["339 B 1","I","2009-08-09","9501","FLORIN RD","CODX2009-04343","0","2009-07-20","Illegal mobile home "]
["Subzone:  S5"]
["420 C 2","I","2009-08-06","11757","BORDEN RD","CODX2009-04335","0","2009-07-17","weeds"]

{"sheet":"Sheet10","index":9,"n_rows":21,"n_cols":9,"rows_kept":21,"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: 7/6/2009 To: 8/2/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-08-03","407","RAFAEL DR","CODX2009-04240","305326","2009-07-14","HAVE ABOUT 7 IN OP VEHICLES IN THE BACKYARD IN THE GRASS AREA; PER CALLER THESE VEHICLES HAS BEEN THERE OVER A YEAR; ALSO THE BACK YARD IS FULL OF JUNK ALSO;"]
["238 C 6","I","2009-08-17","7944","BELLINGRATH DR","CODX2009-04539","306273","2009-07-28","THERE IS 2 GOATS AT THIS ADDRESS ABOVE AND O THEY ARE ON LESS THAN 1 ACRE OF LAND"]
["238 C 6","I","2009-08-10","2100","MAGNUM CT","CODX2009-04242","305281","2009-07-14","THE CALLER SAYS THAT THE LOCATION ADDRESS HAS GOATS ON THEIR PROPERTY AND THEY ARE STACKING PILES OF MANURE IN THE BACKYARD."]
["257 G 1","I","2009-07-29","7344","W 2ND ST","CODX2009-04168","305286","2009-07-09","THERE ARE 2 CAMPERS, A TRAILER WITH A CONECTION ON THE PROPERTY "]
["257 H 1","I","2009-08-11","7230","6TH ST","CODX2009-04231","305390","2009-07-14","THERE ARE VARIOUS IN-OPERABLE VEHICLES ON THE PROPERTY.  ABOUT 3 PICK UPS AND 1 VEHICLE THAT HAVE BEEN IN-OPERABLE FOR ABOUT 6 MONTHS NOW. ALSO THERE IS ALSO AN UNATTACHED TRAILER TYPE OF THING ALSO IN THE BACKYARD."]
["257 H 1","I","2009-08-17","413","SILVER CREST CIR","CODX2009-04525","0","2009-07-28","inop/unreg 5UIJ476 and 3KUV799 and junk and rubbish - pipes\n"]
["257 H 1","I","2009-08-16","503","ARLINGDALE CIR","CODX2009-04497","306233","2009-07-27","RUNNING A PARTS STORE WITH MUFFLERS, CAR DOORS AND TIRES.  CONCERNED BECAUSE SO MANY TIRES AND FEARFUL IT'S FIRE HAZARD."]
["257 H 2","I","2009-08-19","6941","7TH ST","CODX2009-04661","0","2009-07-30","SCZC 230-02, 230-11 ( I6 ) operating a boat storage facility without a conditional use permit. "]
["257 H 2","I","2009-08-16","6944","5TH AVE","CODX2009-04462","306388","2009-07-27","there are garage sales being held every weekend,states the home looks like the roseville auction."]
["257 H 2","I","2009-08-06","6931","5TH ST","CODX2009-04333","0","2009-07-17","Junk and Rubbish - North side of house - brush, toilet and rubbish"]
["257 H 2","I","2009-08-12","6817","5TH ST","CODX2009-04431","306177","2009-07-23","WEEDS ARE OVER 6' TALL IN BACK YARD OF VACANT UNMAINTAINED PROPERTY RHODENTS EVERYWHERE."]
["257 H 3","I","2009-09-03","6438","6TH ST","CODX2009-04664","306557","2009-07-30","HOUSING: LACK OF SMOKE DETECTORS, ELECTRICAL MALFUNCTION (KITCHEN LIGHTS), MALFUNCTIONING EXTERIOR DOOR"]
["257 J 1","I","2009-08-17","7246","MANUEL ST","CODX2009-04537","306264, 306757","2009-07-28","Two cars in front of this address currently, one gold Ford taurus with door, hood and fenders missing, also a pink Dodge Neon in similar shape, caller thinks resident is running parts shop/auto repair business out of house.\n7/31/09 Additional Issue (306757) THERE ARE CAR PARTS AND OTHER JUNK ALL OVER THE FRONT YARD."]
["257 J 1","I","2009-08-18","7229","8TH ST","CODX2009-04209","0","2009-07-13","inop/unreg (green SUV) \n"]
["257 J 1","I","2009-08-02","7301","8TH ST","CODX2009-04208","0","2009-07-13","commercial vehicles, inop/unreg, and Junk and rubbish"]
["258 A 1","I","2010-07-19","1138","Q ST","CODX2009-04311","0","2009-07-16","CONTROL NUMBER: 2008-TMZ-00293- TEMPORARY MOBILEHOME AS AN ACCESSORY DWELLING- ALLOW TIME 36 MONTHS FROM 5/27/09"]

{"sheet":"Sheet11","index":10,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[10,0,10,4],[12,0,12,4],[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: 7/6/2009 To: 8/2/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Cecilia Perez"]
["Subzone:  E6"]
["278 G 7","I","2009-08-11","2310","WATT AVE","CODX2009-04391","0","2009-07-22","CONTROL NUMBER: PLNP2009-00130-TUZ- CARNIVAL"]
["Subzone:  S3"]
["299 B 6","I","2009-08-05","3300","BRADSHAW RD","CODX2009-04303","0","2009-07-16","CONTROL NUMBER: PLNP2009-TUZ-00128- \"PARKING LOT PROMOTION\" VALID FROM JULY 10, 2008-AUGUST 8, 2009"]
["Subzone:  S4"]
["280 B 6","I","2009-08-11","11351","PYRITES WAY","CODX2009-04384","0","2009-07-22","CONTROL NUMBER:2007-UPP-VAZ-00581- TO ALLOW A POLE SIGN/SPECIAL SIGN CORRIDOR.  "]
["Subzone:  S5"]
["400 C 4","I","2009-08-11","11995","COLONY RD","CODX2009-04395","0","2009-07-22","CONTROL NUMBER:2008-RZB-PMR-00230"]
["Subzone:  S8"]
[null,"I","2009-08-05",null,null,"CODX2009-04305","0","2009-07-16","CONTROL NUMBER: 2008-UPP-DRS-PRS-00101 (ADDITIONAL PARCEL 115-0430-075,077, AND 078) \"sHOPPING CENTER/SHOPPING CENTER-FLOOD\" 2 LANE DRIVE THROUGH WITH AMPLIFIED SOUND. "]
[null,"I","2009-08-05",null,null,"CODX2009-04305","0","2009-07-16","CONTROL NUMBER: 2008-UPP-DRS-PRS-00101 (ADDITIONAL PARCEL 115-0430-075,077, AND 078) \"sHOPPING CENTER/SHOPPING CENTER-FLOOD\" 2 LANE DRIVE THROUGH WITH AMPLIFIED SOUND. "]
[null,"I","2009-08-05",null,null,"CODX2009-04305","0","2009-07-16","CONTROL NUMBER: 2008-UPP-DRS-PRS-00101 (ADDITIONAL PARCEL 115-0430-075,077, AND 078) \"sHOPPING CENTER/SHOPPING CENTER-FLOOD\" 2 LANE DRIVE THROUGH WITH AMPLIFIED SOUND. "]
[null,"I","2009-08-05",null,null,"CODX2009-04305","0","2009-07-16","CONTROL NUMBER: 2008-UPP-DRS-PRS-00101 (ADDITIONAL PARCEL 115-0430-075,077, AND 078) \"sHOPPING CENTER/SHOPPING CENTER-FLOOD\" 2 LANE DRIVE THROUGH WITH AMPLIFIED SOUND. "]
[null,"I","2009-08-05",null,null,"CODX2009-04305","0","2009-07-16","CONTROL NUMBER: 2008-UPP-DRS-PRS-00101 (ADDITIONAL PARCEL 115-0430-075,077, AND 078) \"sHOPPING CENTER/SHOPPING CENTER-FLOOD\" 2 LANE DRIVE THROUGH WITH AMPLIFIED SOUND. "]

{"sheet":"Sheet12","index":11,"n_rows":224,"n_cols":9,"rows_kept":224,"cut":false,"hidden":false,"merged":[[148,0,148,4],[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4],[18,0,18,4],[21,0,21,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 7/6/2009 To: 8/2/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 A 7","I","2009-08-03","5041","AUBURN BLVD","CODX2009-04238","0","2009-07-14"]
["259 A 7","I","2009-08-05","4955","SADDLEROCK WAY","CODX2009-04291","305712","2009-07-16","OCCUPIED TRAVEL TRAILER IN DRIVEWAY, HOOKED UP TO WATER AND ELECTRICTY. (AT 4957 SADDLEROCK WAY)"]
["259 A 7","I","2009-08-16","4955","DATE AVE","CODX2009-04495","306217","2009-07-27","THERE ARE SEVERAL INOPERABLE VEHICLES AT THE ABOVE PROPERTY.  STATES THAT IT LOOKS LIKE A JUNK YARD."]
["259 A 7","I","2009-08-18","4971","DATE AVE","CODX2009-04646","306398","2009-07-29","THERE IS A RED CAR PARKED ON THE FRONT LAWN AT THIS ADDRESS ABOVE BEEN THERE FOR SEVERAL MONTHS"]
["259 A 7","I","2009-08-05","4985","DATE AVE","CODX2009-04310","305772","2009-07-16","PILE OF JUNK AND DEBRIS AT THE DRIVE-WAY,COVER WITH A TARP.  ALSO IN-OP VEHILE PARKED ON THE DIRT. LOOKS LIKE A GREEN VOLKSWAGON BUG. "]
["259 B 5","I","2009-08-19","5325","FORT SUTTER WAY","CODX2009-04669","306526","2009-07-30","AUTO REPAIR BUSINESS IS BEING RUN OUT OF THIS HOME AND IN THE STREET. THIS HAS BEEN GOING SEVERAL MONTHS.."]
["259 B 6","I","2009-08-10","5341","WALNUT AVE","CODX2009-04354","305851","2009-07-21","MAINTENANCE MEN ARE THROWING MATTRESSES/ ASSORTED FURNITURE IN AND AROUND THE DUMPSTERS. SOMETIMES THERE ARE UP TO 12 MATTRESSES, BEHIND THE MAINTENANCE SHOP THERE IS A STACK OF TV, ELECTRONICS,REFRIGERATORS, WASHING MACHINES. IT IS BEGINING TO LOOK LIKE A DUMP."]
["259 C 5","R","2009-08-13","5821","SHENANDOAH DR","CODX2009-04121","304987","2009-07-08","The caregiver that was taking care of him has been living illegally on the property since he passed away.  SMUD has removed the power and now they have hooked up a generator that runs all day.  The backyard is full of junk/rubbish and junk in/op cars."]
["259 C 5","I","2009-07-29","5800","AUBURN BLVD","CODX2009-04166","0","2009-07-09","OK Vinyl Inc STE # 14-15, they’re storing foam outside in their yard, it’s not screened from view.  "]
["259 C 5","I","2009-08-17","5821","AUBURN BLVD","CODX2009-04584","306267","2009-07-28","A FRAME SIGNS, SIGNS ON WALLS ILLEGALLY. ADVERTISING FOR OFFBEAT 6-8 MONTHS, ADVERTISING THE DOGHOUSE OFF AND ON FOR LAST 8 MONTHS, CITY LIMITS SHOWGIRLS SIGNS UP FOR OVER 1 YEAR."]
["259 C 5","I","2009-08-25","5511","KEONCREST CIR","CODX2009-04349","306021","2009-07-21","HOUSING: WATER INTRUSION THROUGH CEILING"]
["278 J 1","I","2009-08-27","4838","PASAROBLES DR","CODX2009-04411","306105","2009-07-23","HOUSING: BROKEN WINDOWS, TORN FLOOR COVERINGS, FRAME OF SLIDING GLASS WINDOW IS BENT"]
["278 J 1","I","2009-08-12","4552","AUBURN BLVD","CODX2009-04410","0","2009-07-23","TOWING BUSSINESS- \"ABSOLUTE ADJUSTMENT SERVICES INC\""]
["Subzone:  C3"]
["278 G 4","I","2009-08-28","3536","WATT AVE","CODX2009-04436","306244","2009-07-24","HOUSING: COCKROACH INFESTATION"]
["278 H 3","I","2009-07-27","4025","NORRIS AVE","CODX2009-04117","304948","2009-07-07","home is vacant and overgrown weeds over 12\" in the backyard."]
["Subzone:  C4"]
["278 C 6","I","2009-08-19","2160","WHIPPOORWILL LN","CODX2009-04666","306509","2009-07-30","THERE IS ABOUT 5 CHICKENS ON THIS PROPERTY"]
["278 C 6","I","2009-08-04","2609","ANNA WAY","CODX2009-04254","305456","2009-07-15","JUNK IN BACKYARD AT THE ABOVE ADDRESS IS CREATING A RAT HARBORAGE"]
["278 C 7","I","2009-08-19","2000","BOWLING GREEN DR","CODX2009-04670","306531","2009-07-30","THERE IS A P/U TRUCK ON THE LAWN"]
["278 D 4","I","2009-08-03","2412","EDISON AVE","CODX2009-04226","305338","2009-07-14","THERE IS OLD FURNITURE, MATTRESSES AND OTHER JUNK ON THE FRONT YARD AT THE ABOVE ADDRESS. THE DEBRIS HAS BEEN THERE FOR 4 MONTHS"]
["278 D 5","I","2009-08-05","2306","RAINBOW AVE","CODX2009-04288","305702","2009-07-16","A BLUE CAMERO LIC #5HIY469 IN THE DRIVEWAY, UNMOVED. TIRES ARE FLAT."]
["278 D 5","R","2009-08-03","2901","BRYCE ST","CODX2009-04624","306519","2009-07-29","VOA WITH POSSIBLE SQUATTERS"]
["278 D 5","I","2009-08-05","2431","VALLEY RD","CODX2009-04285","305701","2009-07-16","A RED 4 DOOR LINCOLN UP ON BLOCKS. LIC #A2565 HANDICAPPED PLATES. "]
["278 D 5","I","2009-08-19","2848","BELL ST","CODX2009-04668","306516","2009-07-30","CAR PARKED ON LAWN"]
["278 E 6","I","2009-08-19","2751","FULTON AVE","CODX2009-04256","305494","2009-07-15","THERE IS JUST A PILE OF STUFF ON THE ABOVE PROPERTY.  LOCATED IN THE BACK LOT OF THE BUSINESS"]
["298 C 1","I","2009-07-30","2105","ARDEN WAY","CODX2009-04199","0","2009-07-10","operating without a business license \"car washes uses\""]
["298 D 3","I","2009-08-20","1019","DORNAJO WY","CODX2009-04271","305720","2009-07-16","HOUSING: WATER INTRUSION"]
["298 D 3","I","2009-09-04","910","BELL ST","CODX2009-04757","306698","2009-07-31","HOUSING: NO HEAT"]
["298 D 3","I","2009-08-06","917","CARRO DR","CODX2009-04319","proactive","2009-07-17","ZONING: J&R"]
["298 D 3","I","2009-08-06","929","CARRO DR","CODX2009-04321","proactive","2009-07-17","ZONING: J&R"]
["298 D 3","I","2009-08-16","2404","CAVA CT","CODX2009-04465","306258","2009-07-27","AT THIS 4 PLEX CURRENTLY HAS NO DUMPSTER AND THE RESIDENTS ARE COMING ACROSS THE STREET TO USE THEIR DUMSPTER AND ALSO THERE IS TRASH THAT IS PILING UP AT THIS ADDRESS. HAS BEEN THIS WAY SINCE MAY 2009."]
["298 D 3","I","2009-08-06","928","DORNAJO WAY","CODX2009-04325","proactive","2009-07-17","ZONING: J&R"]
["298 D 3","I","2009-08-06","2417","NORTHROP AVE","CODX2009-04315","proactive","2009-07-17","ZONING: J&R\n306260:THE DUMPSTER IS OVER FLOWING AT THIS ADDRESS.  HAS BEEN OVER FLOWING SINCE MAY 2009"]
["298 D 3","I","2009-08-06","908","DORNAJO WAY","CODX2009-04323","proactive","2009-07-17","ZONING: J&R\n306257:STATES THE DUMPSTER THAT IS LOCATED AT THIS ADDRESS IS AND HAS BEEN OVERFLOWING SINCE MAY 2009."]
["298 E 2","I","2009-08-20","1328","TOPAZ WAY","CODX2009-04713","0","2009-07-31","Inop/unreg - bug on driveway\n"]
["298 E 2","I","2009-08-17","1333","JONAS AVE","CODX2009-04531","0","2009-07-28","LAWN PARKING- TRUCK ON LAWN"]
["298 E 2","I","2009-08-17","2620","COOPER WAY","CODX2009-04534","0","2009-07-28","Inop/unreg - green car and truck"]
["298 E 2","I","2009-08-16","2801","BERKSHIRE WAY","CODX2009-04475","0","2009-07-27","J/R - chair on side of house"]
["298 E 2","I","2009-08-16","2809","BERKSHIRE WAY","CODX2009-04476","0","2009-07-27","Inop/unreg - grey truck"]
["298 E 2","I","2009-08-18","1413","MORSE AVE","CODX2009-04612","0","2009-07-29","INOP/UNREG- BURGANDY CAR IN DRIVEWAY"]
["298 E 2","I","2009-08-17","2913","HOLT WAY","CODX2009-04597","0","2009-07-28","J/R on driveway"]
["298 E 2","I","2009-08-17","2741","HILLDALE RD","CODX2009-04582","0","2009-07-28","J/R, Inop/unreg"]
["298 E 2","I","2009-08-17","3021","MAISON WAY","CODX2009-04569","0","2009-07-28","J/R"]
["298 E 2","I","2009-08-18","2745","HURLEY WAY","CODX2009-04625","0","2009-07-29","Lawn parking - trailer on lawn"]
["298 E 2","I","2009-07-29","3009","MAISON WAY","CODX2009-04157","3605271","2009-07-09","THERE IS A AN IN-OP OLDER MODEL CAR AND A RV THAT HAVE BEEN PARKED ON THE PROPERTY FOR SEVERAL MONTHS."]
["298 E 2","I","2009-08-20","1520","WYANT WAY","CODX2009-04753","0","2009-07-31","J/R"]
["298 E 2","I","2009-08-17","1401","KEENEY WAY","CODX2009-04557","0","2009-07-28","COMM. VEHICLE"]
["298 E 2","I","2009-08-17","1356","DIFANI CT","CODX2009-04542","0","2009-07-28","Lawn parking - boat on lawn"]
["298 E 2","I","2009-08-17","2920","HOLT WAY","CODX2009-04599","0","2009-07-28","J/R on driveway"]
["298 E 2","I","2009-08-18","1353","ROWENA WAY","CODX2009-04632","0","2009-07-29","INOP/UNREG- BLUE CAR"]
["298 E 2","I","2009-08-20","1531","WYANT WAY","CODX2009-04755","0","2009-07-31","INOP/UNREG"]
["298 E 2","I","2009-08-17","1409","KEENEY WAY","CODX2009-04561","0","2009-07-28","LAWN PARKING"]
["298 E 2","I","2009-08-16","2829","BERKSHIRE WAY","CODX2009-04477","0","2009-07-27","Inop/unreg - Grey car"]
["298 E 2","I","2009-08-17","1345","KEENEY WAY","CODX2009-04554","0","2009-07-28","LAWN PARKING, INOP/UNREG"]
["298 E 2","I","2009-08-18","1405","MORSE AVE","CODX2009-04608","0","2009-07-29","LAWN PARKING- BOAT AND TRAILER ON LAWN"]
["298 E 2","I","2009-08-20","1505","WYANT WAY","CODX2009-04748","0","2009-07-31","INOP/UNREG RED CAR"]
["298 E 2","I","2009-08-17","2821","HILLDALE RD","CODX2009-04583","0","2009-07-28","Lawn parking- trailer on lawn"]
["298 E 2","I","2009-08-18","1550","MAYFLOWER CT","CODX2009-04601","0","2009-07-29","INOP/UNREG - 5JBX209"]
["298 E 2","I","2009-08-17","2740","HILLDALE RD","CODX2009-04578","0","2009-07-28","Lawn parking"]
["298 E 2","I","2009-08-17","2916","HOLT WAY","CODX2009-04598","0","2009-07-28","Comm. Vehicle"]
["298 E 2","I","2009-08-20","1508","WYANT WAY","CODX2009-04752","0","2009-07-31","INOP/UNREG"]
["298 E 2","I","2009-08-17","1433","JONAS AVE","CODX2009-04535","0","2009-07-28","J/R"]
["298 E 2","I","2009-08-20","1422","TOPAZ WAY","CODX2009-04714","0","2009-07-31","Inop/unreg, MAR - maroon car\n"]
["298 E 2","I","2009-08-20","1511","ROWENA WAY","CODX2009-04676","0","2009-07-31","INOP/UNREG- GREY CAR 1FXW155"]
["298 E 2","I","2009-08-18","1341","MORSE AVE","CODX2009-04606","0","2009-07-29","INOP/UNREG - WHITE CAR IN DRIVEWAY"]
["298 E 2","I","2009-08-17","1321","KEENEY WAY","CODX2009-04553","0","2009-07-28","Inop/Unreg"]
["298 E 2","I","2009-08-17","1366","JONAS AVE","CODX2009-04533","0","2009-07-28","LAWN PARKING"]
["298 E 2","I","2009-08-17","1441","JONAS AVE","CODX2009-04536","0","2009-07-28","WEEDS"]
["298 E 2","I","2009-08-18","1321","MORSE AVE","CODX2009-04603","0","2009-07-29","LAWN PARKING- WHITE NISSAN ON LAWN"]
["298 E 2","I","2009-08-18","1505","MORSE AVE","CODX2009-04610","0","2009-07-29","INOP/UNREG - RED VAN IN DRIVEWAY"]
["298 E 2","I","2009-08-18","1517","MORSE AVE","CODX2009-04614","0","2009-07-29","INOP/UNREG- 3 CARS IN THE DRIVEWAY, RED BLAZER AND TAN TRUCK"]
["298 E 2","I","2009-08-18","2841","HURLEY WAY","CODX2009-04633","0","2009-07-29","Inop/unreg - wrecked truck in driveway (2J68674)"]
["298 E 2","I","2009-08-20","1367","ROWENA WAY","CODX2009-04677","0","2009-07-31","INOP/UNREG - 2 VEHICLES ON DRIVEWAY"]
["298 E 2","I","2009-08-20","1310","TOPAZ WAY","CODX2009-04711","0","2009-07-31","Inop/unreg, lawn parking\n"]
["298 E 2","I","2009-08-18","2921","HOLT WAY","CODX2009-04609","0","2009-07-29","J/R on driveway"]
["298 E 2","I","2009-08-20","1413","WYANT WAY","CODX2009-04746","0","2009-07-31","INOP/UNREG - BLACK CAR"]
["298 F 2","I","2009-08-20","1512","RUSHDEN DR","CODX2009-04693","0","2009-07-31","LAFWN PARKING- GREEN TRAILER ON LAWN"]
["298 F 2","I","2009-08-20","1421","WATT AVE","CODX2009-04732","0","2009-07-31","J/R - chair\n"]
["298 F 2","I","2009-08-16","3136","BERKSHIRE WAY","CODX2009-04482","0","2009-07-27","J/R"]
["298 F 2","I","2009-08-20","1321","SHADOWGLEN RD","CODX2009-04687","0","2009-07-31","Lawn parking- boat on lawn, J/R\n"]
["298 F 2","I","2009-08-20","3129","SOMERSET RD","CODX2009-04694","0","2009-07-31","JUNK AND RUBBISH"]
["298 F 2","I","2009-08-20","3125","SOMERSET RD","CODX2009-04701","0","2009-07-31","J/R, Inop/unreg\n"]
["298 F 2","I","2009-08-20","1437","SEBASTIAN WAY","CODX2009-04708","0","2009-07-31","INOP/UNREG - CAR UNDER GREY TARP"]
["298 F 2","I","2009-08-20","1525","WILTON WAY","CODX2009-04756","0","2009-07-31","Inop/unreg - NCS973\n"]
["298 F 2","I","2009-08-20","1309","WATT AVE","CODX2009-04729","0","2009-07-31","Inop/unreg - car under tarp with weeds\n"]
["298 F 2","I","2009-08-20","1417","WATT AVE","CODX2009-04731","0","2009-07-31","Inop/unreg- white car\n"]
["298 F 2","I","2009-08-18","1380","MORSE AVE","CODX2009-04607","0","2009-07-29","INOP/UNREG - CAR UNDER TARP"]
["298 F 2","I","2009-08-17","1321","GLADSTONE DR","CODX2009-04548","0","2009-07-28","Inop/unreg  - white car 2UAV962"]
["298 F 2","I","2009-08-17","1336","GLENWOOD RD","CODX2009-04552","0","2009-07-28","J/R, Inop/unreg - blue car"]
["298 F 2","I","2009-08-17","1325","GREENHILLS RD","CODX2009-04565","0","2009-07-28","J/R - on driveway"]
["298 F 2","I","2009-08-17","3220","CHELSEA RD","CODX2009-04509","0","2009-07-28","Lawn parking - boat on lawn"]
["298 F 2","I","2009-08-16","3132","BAKULA WAY","CODX2009-04468","0","2009-07-27","Inop/unreg - chevy in driveway"]
["298 F 2","I","2009-08-16","3437","BARRINGTON RD","CODX2009-04474","0","2009-07-27","Inop/unreg - Whie and orange truck"]
["298 F 2","I","2009-08-16","3112","BERKSHIRE WAY","CODX2009-04481","0","2009-07-27","Inop/unreg"]
["298 F 2","I","2009-08-16","3109","CHELSEA RD","CODX2009-04491","0","2009-07-27","Inop/unreg  - Silver Nissan car"]
["298 F 2","I","2009-08-20","1518","SEBASTIAN WAY","CODX2009-04683","0","2009-07-31","Inop/unreg - m/h (1MZL287) , green chevy (4PGT649)\n"]
["298 F 2","I","2009-08-20","1332","SEBASTIAN WAY","CODX2009-04697","0","2009-07-31","COMM. VEHICLE (8b60564)"]
["298 F 2","I","2009-08-20","1337","SEBASTIAN WAY","CODX2009-04698","0","2009-07-31","J/R"]
["298 F 2","I","2009-08-20","1341","SEBASTIAN WAY","CODX2009-04699","0","2009-07-31","J/R, INOP/UNREG- TRAILER ON SIDE DRIVEWAY"]
["298 F 2","I","2009-08-20","1420","SEBASTIAN WAY","CODX2009-04702","0","2009-07-31","INOP/UNREG - BLACK VEHICLE (2SMV063)"]
["298 F 2","I","2009-08-20","1437","WATT AVE","CODX2009-04733","0","2009-07-31","J/R\n"]
["298 F 2","I","2009-08-20","1505","WATT AVE","CODX2009-04735","0","2009-07-31","Inop/unreg\n"]
["298 F 2","I","2009-08-20","1517","WATT AVE","CODX2009-04736","0","2009-07-31","J/R on side yard\n"]
["298 F 2","I","2009-08-17","3124","CHELSEA RD","CODX2009-04506","0","2009-07-28","Lawn parking - trailer on lawn"]
["298 F 2","I","2009-08-16","3204","BERKSHIRE WAY","CODX2009-04486","0","2009-07-27","Inop/unreg - white truck"]
["298 F 2","I","2009-08-16","3108","CHELSEA RD","CODX2009-04489","0","2009-07-27","Lawn parking - boat on lawn"]
["298 F 2","I","2009-08-16","3120","CHELSEA RD","CODX2009-04492","0","2009-07-27","Inop/unreg - beige Jeep"]
["298 F 2","I","2009-08-16","3420","BARRINGTON RD","CODX2009-04472","0","2009-07-27","Inop/unreg - jeep cherokee"]
["298 F 2","I","2009-08-16","3101","BERKSHIRE WAY","CODX2009-04478","0","2009-07-27","Inop/unreg"]
["298 F 2","I","2009-08-16","3108","BERKSHIRE WAY","CODX2009-04479","0","2009-07-27","Inop/unreg"]
["298 F 2","I","2009-08-17","1329","GREENHILLS RD","CODX2009-04567","0","2009-07-28","Inop/unreg - Ford Bronco\n305951: BROWN FORD SUV"]
["298 F 2","I","2009-08-18","3115","HURLEY WAY","CODX2009-04635","0","2009-07-29","J/R, Inop/unreg, weeds"]
["298 F 2","I","2009-08-20","1320","RUSHDEN DR","CODX2009-04682","0","2009-07-31","INOP/UNREG- GREEN VW ON DRIVEWAY"]
["298 F 2","I","2009-08-16","3173","BAKULA WAY","CODX2009-04471","0","2009-07-27","Inop/unreg , Lawn parking"]
["298 F 2","I","2009-08-20","1400","RUSHDEN DR","CODX2009-04688","0","2009-07-31","J/R- UNDER CARPORT"]
["298 F 2","I","2009-08-17","1524","GLADSTONE DR","CODX2009-04549","0","2009-07-28","Lawn parking - camper on lawn"]
["298 F 2","I","2009-08-17","1300","GLADSTONE DR","CODX2009-04545","0","2009-07-28","Inop/unreg- pontiac with weeds (4TJW822)"]
["298 F 2","I","2009-08-20","1445","WATT AVE","CODX2009-04734","0","2009-07-31","Inop/unreg, J/R\n"]
["298 F 2","I","2009-08-16","3105","CHELSEA RD","CODX2009-04488","0","2009-07-27","Inop/unreg - 4KW977 (mising letter/number)"]
["298 F 2","I","2009-08-16","3135","BAKULA WAY","CODX2009-04470","0","2009-07-27","Inop/unreg - boat and trailer"]
["298 F 2","I","2009-08-17","1405","GLENWOOD RD","CODX2009-04559","0","2009-07-28","Lawn parking - trailer on lawn under bushes"]
["298 F 2","I","2009-08-20","1408","RUSHDEN DR","CODX2009-04690","0","2009-07-31","LAWN PARKING"]
["298 F 2","I","2009-08-20","1424","SEBASTIAN WAY","CODX2009-04704","0","2009-07-31","INOP/UNREG WHITE HONDA (4FWF091)"]
["298 F 2","I","2009-08-17","1308","GLADSTONE DR","CODX2009-04547","0","2009-07-28","Inop/unreg- Ford (3EGW705)"]
["298 F 2","I","2009-08-17","1337","GLENWOOD RD","CODX2009-04556","0","2009-07-28","Inop/unreg - motorhome on driveway, J/R"]
["298 F 2","I","2009-08-16","3115","BAKULA WAY","CODX2009-04467","0","2009-07-27","Inop/unreg - white truck"]
["298 F 2","I","2009-07-15","1580","MORSE AVE","CODX2009-04223","305501, 306408","2009-07-14","HOUSING: SURFACING SEWAGE /\\ HOUSING ISSUE UNIT 26): VARIOUS ELECTRICAL PROBLEMS AND GENERAL DILAPIDATION"]
["298 F 2","I","2009-08-20","1312","RUSHDEN DR","CODX2009-04680","0","2009-07-31","LAWN PARKING- CAMRY PARKEN ON LAWN"]
["298 F 2","I","2009-08-20","1505","SEBASTIAN WAY","CODX2009-04681","0","2009-07-31","Inop/unreg\n"]
["298 F 2","I","2009-08-20","3108","SOMERSET RD","CODX2009-04695","0","2009-07-31","Inop/unreg\n"]
["298 F 2","I","2009-08-20","1521","WATT AVE","CODX2009-04737","0","2009-07-31","Lawn parking- green car on lawn, J/R\n"]
["298 F 2","I","2009-08-20","1400","SEBASTIAN WAY","CODX2009-04700","0","2009-07-31","LAWN PARKING- TRAILER ON LAWN"]
["298 F 2","I","2009-08-20","1341","RUSHDEN DR","CODX2009-04684","0","2009-07-31","INOP/UNREG- MOTORHOME AND GREEN CAR"]
["298 F 2","I","2009-08-17","1301","GLADSTONE DR","CODX2009-04546","0","2009-07-28","J/R - on driveway"]
["298 F 2","I","2009-08-17","1309","GLENWOOD RD","CODX2009-04551","0","2009-07-28","Inop/unreg - orange truck and silver Crysler"]
["298 F 2","I","2009-08-17","1316","GREENHILLS RD","CODX2009-04564","0","2009-07-28","Inop/unreg - 6CHV624 burgundy car"]
["298 F 2","I","2009-08-17","3125","CHELSEA RD","CODX2009-04508","0","2009-07-28","J/R on driveway, Inop/unreg (3UIN788)"]
["298 F 2","I","2009-08-20","1441","SEBASTIAN WAY","CODX2009-04678","0","2009-07-31","INOPERABLE/UNREGISTERED VEHICLE- car under grey tarp"]
["298 F 2","I","2009-08-20","1308","RUSHDEN DR","CODX2009-04679","0","2009-07-31","J/R- ON DRIVEWAY"]
["298 F 2","I","2009-08-20","1440","RUSHDEN DR","CODX2009-04691","0","2009-07-31","INOP/UNREG - 4ZWW051, BEAMER WITH WEBS"]
["298 F 2","I","2009-08-20","1508","RUSHDEN DR","CODX2009-04692","0","2009-07-31","J/R"]
["298 F 2","I","2009-08-20","3116","SOMERSET RD","CODX2009-04696","0","2009-07-31","Lawn parking\n"]
["Subzone:  E6"]
["278 H 7","I","2009-07-30","4120","EL CAMINO AVE","CODX2009-04198","0","2009-07-10","UNIT #C-for illegal portable signs and banners\n"]
["298 E 3","I","2009-08-18","2702","HURLEY WAY","CODX2009-04621","0","2009-07-29","Lawn parking - trailer on lawn, Inop/unreg - under tarp"]
["298 E 3","I","2009-08-17","1160","JONAS AVE","CODX2009-04524","0","2009-07-28","J/R, INOP/UNREG"]
["298 E 3","I","2009-08-18","2830","HURLEY WAY","CODX2009-04631","0","2009-07-29","Lawn parking - white truck on lawn"]
["298 E 3","I","2009-08-17","2910","JOSEPH AVE","CODX2009-04541","0","2009-07-28","Inop/Unreg - trailer with junk and white van"]
["298 E 3","I","2009-08-17","1207","FRANMOR CT","CODX2009-04544","0","2009-07-28","Inop/unreg - grey car"]
["298 E 3","I","2009-08-17","1275","JONAS AVE","CODX2009-04529","0","2009-07-28","LAWN PARKING- TRUCK PARKED ON DIRT"]
["298 E 3","I","2009-08-17","1155","JONAS AVE","CODX2009-04521","0","2009-07-28","INOP/UNREG - CAR UNDER TARP"]
["298 E 3","I","2009-08-17","1202","JONAS AVE","CODX2009-04527","0","2009-07-28","J/R"]
["298 E 3","I","2009-08-17","1053","EVELYN LN","CODX2009-04543","0","2009-07-28","J/R"]
["298 E 3","I","2009-08-17","2707","MATHESON WAY","CODX2009-04577","0","2009-07-28","INOP/UNREG- GREY CAR IN DRIVEWAY. "]
["298 F 3","I","2009-08-20","3401","WINDSOR DR","CODX2009-04741","0","2009-07-31","INOP/UNREG. COMM.VEH. (TRUCK)  "]
["298 F 3","I","2009-08-20","3452","WEMBERLEY DR","CODX2009-04751","0","2009-07-31","Inop - 4LRU821, J/R\n"]
["298 F 3","I","2009-08-17","1007","HAMPTON RD","CODX2009-04572","0","2009-07-28","Inop/unreg - white truck in driveway"]
["298 F 3","I","2009-08-20","1161","WATT AVE","CODX2009-04718","0","2009-07-31","Inop/unreg - boat on lawn, J/R- car on jacks\n"]
["298 F 3","I","2009-08-17","3308","HURLEY WAY","CODX2009-04503","0","2009-07-28","J/R in rear yard."]
["298 F 3","I","2009-08-20","3309","WELLINGTON DR","CODX2009-04738","0","2009-07-31","J/R - carparts, etc\n"]
["298 F 3","I","2009-08-17","3312","CHURCHILL RD","CODX2009-04526","0","2009-07-28","Inop/unreg - Blue VW van"]
["298 F 3","I","2009-08-20","3436","WEMBERLEY DR","CODX2009-04750","0","2009-07-31","Inop - green truck\n"]
["298 F 3","I","2009-08-20","1221","WATT AVE","CODX2009-04721","0","2009-07-31","Inop/unreg - motorhome on jacks, Lawn parking\n"]
["298 F 3","I","2009-08-20","1209","SHADOWGLEN RD","CODX2009-04686","0","2009-07-31","J/R, Lawn parking - chevy\n"]
["298 F 3","I","2009-08-18","3112","HURLEY WAY","CODX2009-04634","0","2009-07-29","Inop/unreg - blue truck (5T25668)"]
["298 F 3","I","2009-08-16","3412","ARDENRIDGE DR","CODX2009-04466","0","2009-07-27","Car under silver tarp"]
["298 F 3","I","2009-08-18","3409","NORTHROP AVE","CODX2009-04627","0","2009-07-29","WEEDS/INOP VEHICLE"]
["298 F 3","I","2009-08-18","1024","MORSE AVE","CODX2009-04602","0","2009-07-29","INOP/UNREG, LAWN PARKING- CAR WITH TARP ON LAWN."]
["298 F 3","I","2009-08-17","1108","HAMPTON RD","CODX2009-04574","0","2009-07-28","Inop/unreg - blue/green car "]
["298 F 3","I","2009-08-17","3112","MAYFAIR DR","CODX2009-04580","0","2009-07-28","INOP/UNREG - 3XJP2077"]
["298 F 3","I","2009-08-17","3305","CHURCHILL RD","CODX2009-04522","0","2009-07-28","J/R - washer/dryer"]
["298 F 3","I","2009-08-17","1201","GREENHILLS RD","CODX2009-04560","0","2009-07-28","J/R - on side of driveway"]
["298 F 3","I","2009-08-17","921","HAMPTON RD","CODX2009-04571","0","2009-07-28","Inop/unreg - 5CZU924  red car"]
["298 F 3","I","2009-08-20","3332","TEMBROOK DR","CODX2009-04705","0","2009-07-31","Inop/unreg - bpat\n"]
["298 F 3","I","2009-08-18","3416","HUMBOLDT WAY","CODX2009-04615","0","2009-07-29","Inop/Unreg - Grey crysler on driveway"]
["298 F 3","I","2009-08-18","3433","MAYFAIR DR","CODX2009-04600","0","2009-07-29","J/R - UNDER CARPORT"]
["298 F 3","I","2009-08-18","3401","NORTHROP AVE","CODX2009-04626","0","2009-07-29","J/R- BOXES UNDER CARPORT"]
["298 F 3","I","2009-08-18","928","PATRICIA WAY","CODX2009-04630","0","2009-07-29","J/R - ON SIDE YARD"]
["298 F 3","I","2009-08-20","3213","WEMBERLEY DR","CODX2009-04739","0","2009-07-31","Inop/Unreg - white van and green car\n"]
["298 F 3","I","2009-08-18","909","PATRICIA WAY","CODX2009-04629","0","2009-07-29","J/R- IN BACKYARD THROUGH FENCE "]
["298 F 3","I","2009-08-18","3313","NORTHROP AVE","CODX2009-04623","0","2009-07-29","J/R- DIRT/SCRAP WOOD. UNREG VEH."]
["298 F 3","I","2009-08-17","3201","CHURCHILL RD","CODX2009-04516","0","2009-07-28","Inop/unreg- white car, tires going flat"]
["298 F 3","I","2009-08-20","3237","WEMBERLEY DR","CODX2009-04740","0","2009-07-31","J/R - scrap wood on side of house\n"]
["298 F 3","I","2009-08-20","3404","WEMBERLEY DR","CODX2009-04745","0","2009-07-31","Inop/Unreg - Blue BMM\n"]
["298 F 3","I","2009-08-20","1149","WATT AVE","CODX2009-04717","0","2009-07-31","Lawn parking - boat on lawn\n"]
["298 F 3","I","2009-08-20","1225","WATT AVE","CODX2009-04728","0","2009-07-31","Lawn parking - car on lawn\n"]
["298 F 3","I","2009-08-18","3401","HUMBOLDT WAY","CODX2009-04611","0","2009-07-29","J/R"]
["298 F 3","I","2009-08-20","3448","WINDSOR DR","CODX2009-04743","0","2009-07-31","INOP/UNREG- 2STE317, J/R"]
["298 F 3","I","2009-08-20","3309","WEMBERLEY DR","CODX2009-04744","0","2009-07-31","Lawn parking - boat on lawn\n"]
["298 F 3","I","2009-08-17","3213","CHURCHILL RD","CODX2009-04519","0","2009-07-28","Inop/unreg - 307FRG Blue van"]
["298 F 3","I","2009-08-20","3325","TEMBROOK DR","CODX2009-04703","0","2009-07-31","inop/unreg - 1T65800 ford , red car under tarp\n"]
["298 F 3","I","2009-08-20","3413","TEMBROOK DR","CODX2009-04706","0","2009-07-31","Inop/unreg - black car\n"]
["298 F 3","I","2009-08-20","3425","TEMBROOK DR","CODX2009-04710","0","2009-07-31","Inop/unreg- 5FJN040 * 2 cars, Lawn parking\n"]
["298 F 3","I","2009-08-20","3217","WINDSOR DR","CODX2009-04724","0","2009-07-31","J/R- FRIDGE ON LAWN"]
["298 F 3","I","2009-08-18","3421","HUMBOLDT WAY","CODX2009-04617","0","2009-07-29","J/R - fridge, etc"]
["298 F 3","I","2009-08-18","3425","NORTHROP AVE","CODX2009-04628","0","2009-07-29","4 INOP VEHICLES ON DRIVEWAY"]
["298 F 3","I","2009-08-18","3120","HURLEY WAY","CODX2009-04636","0","2009-07-29","Inop/unreg - white Toyota"]
["298 F 3","I","2009-08-18","3441","HUMBOLDT WAY","CODX2009-04619","0","2009-07-29","J/R - washer, boxes, furniture, etc"]
["298 F 3","I","2009-08-17","1165","HAMPTON RD","CODX2009-04575","0","2009-07-28","Lawn parking - boat and trailer on lawn"]
["298 F 3","I","2009-08-17","3109","MAYFAIR DR","CODX2009-04579","0","2009-07-28","INOP/UNREG - UNDER TARP"]
["298 F 3","I","2009-08-16","3325","ARDENRIDGE DR","CODX2009-04463","0","2009-07-27","Inop blue car in driveway"]
["298 F 3","I","2009-08-20","3124","WINDSOR DR","CODX2009-04716","0","2009-07-31","LAWN PARKING- YELLOW TRUCK ON LAWN"]
["298 F 3","I","2009-08-20","1213","WATT AVE","CODX2009-04720","0","2009-07-31","Lawn parking\n"]
["298 F 3","I","2009-08-16","3356","ARDENRIDGE DR","CODX2009-04464","0","2009-07-27","Trailer and car under tarp, J/R - scrap wood"]
["298 F 3","I","2009-08-17","3133","CHURCHILL RD","CODX2009-04513","0","2009-07-28","Lawn parking - green explorer on lawn"]
["298 F 3","I","2009-08-18","3408","HUMBOLDT WAY","CODX2009-04613","0","2009-07-29","Inop/unreg, lawn parking"]
["298 F 3","I","2009-08-17","900","HAMPTON RD","CODX2009-04568","0","2009-07-28","J/R - scrap wood, tree trimmings"]
["298 F 3","I","2009-08-20","3425","WEMBERLEY DR","CODX2009-04749","0","2009-07-31","J/R, Inop - tan car\n"]
["298 F 3","I","2009-08-20","3453","WEMBERLY DR","CODX2009-04754","0","2009-07-31","Inop/Unreg - 4WNG850\n"]
["298 F 3","I","2009-08-20","3129","WINDSOR DR","CODX2009-04719","0","2009-07-31","INOP/UNREG- GREY FORD TRUCK"]
["298 F 3","I","2009-08-20","3253","WEMBERLEY DR","CODX2009-04742","0","2009-07-31","Inop/unreg - red truck\n"]
["298 F 3","I","2009-08-20","3420","WEMBERLEY DR","CODX2009-04747","0","2009-07-31","Inop, Lawn parking -  blue car with white top \n"]
["298 F 3","I","2009-08-20","1005","SINGINGWOOD RD","CODX2009-04689","0","2009-07-31","J/R - applainces on side yard\n"]
["298 F 3","I","2009-08-17","1216","GREENHILLS RD","CODX2009-04562","0","2009-07-28","Inop/unreg - trailer on driveway"]
["298 F 3","I","2009-08-17","917","HAMPTON RD","CODX2009-04570","0","2009-07-28","Lawn parking - boat on lawn"]
["298 F 3","I","2009-08-20","3421","TEMBROOK DR","CODX2009-04707","0","2009-07-31","Lawn parking - trailer on lawn\n"]
["298 F 3","I","2009-08-17","3316","CHURCHILL RD","CODX2009-04530","0","2009-07-28","Inop/unreg - blue Buick"]
["298 F 3","I","2009-08-20","3105","WINDSOR DR","CODX2009-04712","0","2009-07-31","INOP/UNREG - TRAILER PARKING WITH WEEDS UNDERNEATH IT"]

{"sheet":"Sheet13","index":12,"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: 7/6/2009 To: 8/2/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Dennis Springer"]
["Subzone:  C6"]
["338 D 2","I","2009-08-05","8170","MILLS GAP WAY","CODX2009-04280","305689","2009-07-16","A OCCUPIED TRAILER IS IN THE DRIVEWAY"]

{"sheet":"Sheet14","index":13,"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],[9,0,9,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 7/6/2009 To: 8/2/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 2","I","2009-08-06","4625","LIPPI PKWY","CODX2009-04659","306429","2009-07-30","AT LEAST 15 PEOPLE LIVING IN GARAGE."]
["337 J 3","I","2009-08-10","4824","L PKWY","CODX2009-04351","305870","2009-07-21","LARGE BOAT ON CARRIER/WHITE PARKED ON DRIVEWAY SINCE SPRING, FLAT TIRE. IT ALSO EXTENDS PAST THE DRIVEWAY, INTO THE GUTTER AND BLOCKS ANY FOOT TRAFFIC ON THE SIDEWALK, CHILDREN AND ADULTS ARE FORCED TO WALK IN THE STREET WHEN PASSING. "]
["338 A 3","I","2009-08-10","6101","SAN BRISTOL CT","CODX2009-04372","305931","2009-07-21","ABOUT TEN CHICKENS ARE AT THIS ADDRESS"]
["338 A 3","I","2009-08-04","5852","STALLON WAY","CODX2009-04266","305614","2009-07-15","OLDER MODEL PICK UP TRUCK, CREAM/WHITE COLORED TRUCK PARKED IN THE DRIVEWAY.  THE VECHICLE NEVER MOVES."]
["Subzone:  S8"]
["338 C 5","I","2009-08-10","7520","VICTORY AVE","CODX2009-04100","305144","2009-07-07","Using lot for overflow parking from truck stop located at 7891 Stockton Blvd. Big rigs/semi's being parked on dirt in lot. Lot not zoned for this use."]
["338 C 5","I","2009-08-10","7891","STOCKTON BLVD","CODX2009-04102","305153","2009-07-07","Inop/junk semi's/rigs being stored on property, vehicles are parked on side yard area bordering vistory. Also recycling center/cargo container in setbacks."]
["338 D 4","I","2009-08-04","7741","POWER INN RD","CODX2009-04262","305581","2009-07-15","TRAVEL TRAILER IN BACKYARD IS OCCUPIED BY FIVE PEOPLE."]
["338 D 4","I","2009-08-13","8305","HAYFIELD CIR","CODX2009-04382","305984","2009-07-22","TOW TRUCK PARKED ON FRONT YARD OF THIS RESIDENCE"]
["338 D 4","I","2009-08-04","8274","HAYFIELD CIR","CODX2009-04260","305533","2009-07-15","INOPERABLE VEHICLE(S) IN DRIVEWAY ON JACKS."]
["338 D 4","I","2009-08-04","8250","HAYFIELD CIR","CODX2009-04255","305529","2009-07-15","VEHICLE PARKED ON FRONT LAWN."]
["338 D 5","I","2009-08-02","8331","SUMMER FALLS CIR","CODX2009-04206","0","2009-07-13","Storage of inop/unreg vehicle(s)\n*x-reference with VAPX2009-01872-on street inop vehicle moved to driveway in addition to another inop*"]
["338 D 6","I","2009-08-09","8208","INSKIP DR","CODX2009-04337","305510","2009-07-20","THERE ARE 3 CHICKENS AND 1 ROOSTER AT THE ABOVE ADDRESS. THE CHICKENS AND ROOSTER HAVE BEEN THERE FOR ABOUT 1 WEEK."]
["338 E 5","I","2009-08-13","7904","EASTMAN CT","CODX2009-04145","305004","2009-07-09","HOUSING: RAT INFESTATION, ROACH INFESTATION, MALFUNCTIONING WATER HEATER"]
["338 E 5","I","2009-08-03","8384","BLOOMINGTON DR","CODX2009-04237","0","2009-07-14","Storage of inop/unreg vehicles. Several inop/unreg vehicles in driveway"]
["338 E 7","I","2009-08-06","8456","CASSATT WAY","CODX2009-04317","305826","2009-07-17","INOPERABLE FOR ONE YEAR GREEN KIA, LICENSE 3NMJI64 PARKED IN DRIVEWAY"]
["338 E 7","I","2009-08-16","8358","MILANO CT","CODX2009-04458","306068","2009-07-27","INOPERABLE VEHICLE SITTING IN DRIVEWAY REAR AXLE ON BLOCKS AND VEHICLE PARKED ON LAWN."]
["338 E 7","I","2009-08-16","8420","PASTORI WAY","CODX2009-04456","306066","2009-07-27","VEHICLE IN DRIVEWAY INOPERABLE. LICENSE 5CSK988."]
["338 F 6","I","2009-08-10","8100","MORGAN HILL WAY","CODX2009-04368","305948","2009-07-21","GMC PICK UP RED. PARK ON THE SIDE TO THE PROPERTY W/FLAT TIRES"]
["338 F 6","I","2009-08-09","8101","SIMI CT","CODX2009-04339","0","2009-07-20","Junk and rubbish: pile of yard waste piled next to fence, other miscellaneous debris/garbage on driveway.\n\n"]
["338 F 6","I","2009-08-10","8065","MORGAN HILL WAY","CODX2009-04367","305944","2009-07-21","POSSIBLY DODGE WHITE VAN ON THE DRIVEWAY W/EXPIRED TAGS "]
["338 F 6","I","2009-08-10","8076","MORGAN HILL WAY","CODX2009-04375","305941","2009-07-21","FIAT RED COVERED HALF WAY WITH RED TARP AND YELLOW OLDSMOBILE ON THE DRIVEWAY OF ADDRESS "]
["338 G 4","R","2009-08-18","8820","MARLIN SEAS CT","CODX2009-04296","0","2009-07-16","Referral from Smud for lack of power. Marijuana grow house."]
["338 G 6","I","2009-08-17","8058","DUNSMUIR CT","CODX2009-04204","0","2009-07-13","Storage of inop/unreg vehicle(s)\n*On-street moved to driveway. x-reference-VAPX2009-01872*"]

{"sheet":"Sheet15","index":14,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4],[26,0,26,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 7/6/2009 To: 8/2/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 E 4","I","2009-08-17","3415","ALWOOD CT","CODX2009-04511","306357","2009-07-28","RECLINER ON FRONT PORCH AND FOUR BARBECUE GRILLS."]
["278 E 4","I","2009-08-17","3405","ALWOOD CT","CODX2009-04515","306356","2009-07-28","LIVINGROOM COUCH ON FRONT PORCH"]
["278 E 4","I","2009-08-03","2621","EDISON AVE","CODX2009-04225","305336","2009-07-14","THERE IS A COUCH ON THE FRONT YARD AT THE ABOVE ADDRESS. THE COUCH HAS BEEN THERE FOR OVER 4 MONTHS."]
["278 E 4","I","2009-08-17","3400","ALWOOD CT","CODX2009-04520","306355","2009-07-28","FURNITURE ON FRONT PORCH "]
["278 E 4","I","2009-08-03","3001","EDISON AVE","CODX2009-04222","305334","2009-07-14","THERE IS A COUCH AND BED IN PIECES ON THE FRONT LAWN AT THE ABOVE ADDRESS. THE DEBRIS HAS BEEN THERE FOR A FEW DAYS."]
["278 E 4","I","2009-08-16","3013","EDISON AVE","CODX2009-04490","306362","2009-07-27","BOAT AND TRAILER PARKED ON FRONT LAWN FOR APPROXIMATELY FOUR TO SIX MONTHS."]
["278 E 4","I","2009-08-03","3430","ALWOOD CT","CODX2009-04224","305335","2009-07-14","THERE BOXES AND OLD BLANKETS ON THE SIDE YARD AT THE ABOVE ADDRESS. THE DEBRIS HAS BEEN THERE FOR OVER 2 MONTHS."]
["278 E 4","I","2009-08-16","3411","ALWOOD CT","CODX2009-04496","306359","2009-07-27","CAR PARKED ON FRONT LAWN "]
["278 F 4","I","2009-08-12","3108","WHITNEY AVE","CODX2009-04409","306082","2009-07-23","VACANT HOUSE AT THE ABOVE ADDRESS IS OVERGROWN WITH WEEDS. THE WEEDS ARE 4 FT TALL."]
["278 F 4","I","2009-08-19","3545","LEATHA WAY","CODX2009-04244","305660","2009-07-15","HOUSING: ROOF LEAKS"]
["278 H 6","I","2009-08-19","2825","AVALON DR","CODX2009-04663","306502","2009-07-30","THERE HAS BEEN A PILE OF WOOD CHIPS OR A CHOPPED UP TREE IN THE DRIVEWAY FOR MONTHS.  THEY ARE DRIVING OVER IT AND PARKING ON IT."]
["278 H 6","I","2009-08-18","2560","AVALON DR","CODX2009-04645","306394","2009-07-29","THERE IS A LARGE PILE FOR DEBRIS IN THE DRIVE WAY AT THE ABOVE ADDRESS. PILE CONSISTS OF FURNITURE AND BAGS OF GARBAGE."]
["278 J 3","I","2009-08-12","4116","NEWELL ST","CODX2009-04405","0","2009-07-23","Storage of inoperable and/or unregistered vehicles. 07/27/2009-306207-TWO VEHICLES AT THE ABOVE ADDRESS THAT ARE INOP/UNREG.  FIRST VEHICLE IS A 1995 ISUZU LIC#4JBX698 EXP. 02/2007.  SECOND VEHICLE IS A YELLOW AND WHITE 1978 CHEVY COUPE LIC#520TVU EXP. 01/2004"]
["278 J 3","I","2009-08-12","4237","EDISON AVE","CODX2009-04404","0","2009-07-23","TRASH IN FRONT AREA OF HOUSE"]
["278 J 3","I","2009-08-20","4118","WHEAT ST","CODX2009-04762","306441","2009-07-31","OWNERS OF PROPERTY CUT SOME LIMBS OFF OF NEIGHBORS LIQUID AMBER TREE, HAS DUMPED THEM ON THE SIDE OF THE HOUSE HIS OWN PROPERTY OVER 1 WEEK AGO"]
["278 J 3","I","2009-08-16","4520","EDISON AVE","CODX2009-04459","306193","2009-07-27","THERE IS COVERED VEHICLE THAT IS SITTING IN THE DRIVEWAY.  IT HAS BEEN SITTING IN THE DRIVEWAY FOR SEVERAL YEARS."]
["278 J 4","I","2009-08-12","4537","ENGLE RD","CODX2009-04415","306060","2009-07-23","RESIDENT HAS PUT A 12 TO 14 FEET LONG SIGN ABOVE THE GARAGE ADVERTISING THE DAY CARE ''HOME AWAY FROM HOME, DAY CARE''"]
["279 A 3","I","2009-08-12","4100","DENA WAY","CODX2009-04423","306134","2009-07-23","NEIGHBOR HAS LARGE PILE OF DEAD TREE TRIMMINGS AND A 2 YEAR OLD X-MAS TREE ON LAWN. "]
["279 A 4","I","2009-08-17","3532","MISSION AVE","CODX2009-04501","0","2009-07-28","property was determined to be an imminent hazard."]
["279 A 6","I","2009-08-06","4627","HAZELWOOD AVE","CODX2009-04320","305820","2009-07-17","BUILT A FENCE OVER 6FT TALL LEADING TO THE STREET "]
["279 B 6","R","2009-08-18","2600","FOOTHILL DR","CODX2009-04110","304969","2009-07-07","THIS IS A VACANT HOUSE,WITH OVERGROWN GRASS"]
["Subzone:  E6"]
["278 G 7","R","2009-08-03","3600","WINDING CREEK RD","CODX2009-04433","306279","2009-07-24","VOA"]
["278 H 7","I","2009-08-05","3936","LA VERNE WAY","CODX2009-04300","305743","2009-07-16","CA LIC # 1RDPS42 GOLD COLOR, NON OP FLAT TIRES, HAS BEEN THERE FOR ABOUT 4YRS"]
["298 D 4","I","2009-09-03","809","CARRO DR","CODX2009-04654","306447","2009-07-30","HOUSING: PLUMBING PROBLEMS -- TOILET BACKING UP FOR PAST THREE WEEKS"]
["298 E 1","I","2009-08-03","1809","MORSE AVE","CODX2009-04232","305378","2009-07-14","Front yard is constantly used by owners as dumping ground for all of their old furniture and assorted trash."]
["298 E 3","I","2009-08-17","1025","JONAS AVE","CODX2009-04514","0","2009-07-28","INOP/UNREG - WRECKED WHITE TRUCK (4b74974)"]
["298 E 3","I","2009-08-18","3031","NORTHROP AVE","CODX2009-04622","0","2009-07-29","INOP/UNREG, J/R"]
["298 E 3","I","2009-08-16","1130","JONAS AVE","CODX2009-04493","306274","2009-07-27","THERE IS A VAN PARKED ON THE LAWN FOR 5 DAYS."]
["298 E 3","I","2009-08-17","991","JONAS AVE","CODX2009-04512","0","2009-07-28","J/R"]
["298 E 3","I","2009-08-17","1031","JONAS AVE","CODX2009-04517","0","2009-07-28","J/R, OVERGROWN VEGETATION"]
["298 E 3","I","2009-08-17","1033","JONAS AVE","CODX2009-04518","0","2009-07-28","LAWN PARKING- VAN ON LAWN"]
["298 E 3","I","2009-08-18","1106","MORTON CT","CODX2009-04616","0","2009-07-29","INOP/UNREG - TRUCK"]
["298 E 3","I","2009-08-18","2961","NORTHROP AVE","CODX2009-04620","0","2009-07-29","INOP/UNREG "]
["298 E 3","I","2009-08-17","2661","LARKSPUR LN","CODX2009-04566","0","2009-07-28","J/R- ON SIDE OF DRIVEWAY."]
["298 E 3","I","2009-08-17","990","JONAS AVE","CODX2009-04510","0","2009-07-28","LAWN PARKING- TRUCK AND VAN ON LAWN"]
["298 F 1","I","2009-08-24","1728","RICHMOND ST","CODX2009-04336","305875","2009-07-20","HOUSING: TOILET NOT SECURED TO FLOOR, LEAKING PIPES IN THE BATHROOM COMING FROM UPSTAIRS; CRACKED ELECTRICAL PLATES; ROACHES, Unit #6"]
["298 F 3","I","2009-08-17","3237","MAYFAIR DR","CODX2009-04589","0","2009-07-28","LAWN PARKING - BOAT ON LAWN"]
["298 F 3","I","2009-08-17","3205","MAYFAIR DR","CODX2009-04587","0","2009-07-28","J/R, WEEDS"]
["298 F 3","I","2009-08-20","3132","WINDSOR DR","CODX2009-04722","0","2009-07-31","LAWN PARKING- WHITE TRUCK ON LAWN"]
["298 F 3","I","2009-08-12","3244","HURLEY WAY","CODX2009-04403","0","2009-07-23","Junk and rubbish and inoperable and/or unregistered vehicles"]
["298 F 3","I","2009-08-16","924","AMBERWOOD RD","CODX2009-04461","0","2009-07-27","Lawn parking - grey camero on lawn, J/R"]
["298 F 3","I","2009-08-16","3116","CHURCHILL RD","CODX2009-04469","306194","2009-07-27","Whitish Mercury Sable with flat tires has been in yard for at least two weeks."]
["298 F 3","I","2009-08-17","3200","HURLEY WAY","CODX2009-04502","0","2009-07-28","Inop/Unreg- green car "]
["298 F 3","I","2009-08-17","3316","HURLEY WAY","CODX2009-04505","0","2009-07-28","J/R ON DRIVEWAY"]
["298 F 3","I","2009-08-16","3137","CHURCHILL RD","CODX2009-04473","306197","2009-07-27","A blue/black Ford Explorer SUV has been sitting on the lawn at least a couple of weeks."]
["298 F 3","I","2009-08-17","3120","MAYFAIR DR","CODX2009-04585","0","2009-07-28","J/R, INOP/UNREG - BOAT"]
["298 F 3","I","2009-08-17","3424","MAYFAIR DR","CODX2009-04591","0","2009-07-28","INOP/UNREG - W/RED CAR, TRILER, MOTORHOME"]
["298 F 3","I","2009-08-16","908","AMBERWOOD RD","CODX2009-04460","0","2009-07-27","Lawn Parking - black mustang on lawn"]
["298 F 3","I","2009-08-17","3312","HURLEY WAY","CODX2009-04504","0","2009-07-28","J/R IN SIDE YARD"]
["298 F 3","I","2009-08-17","3332","HURLEY WAY","CODX2009-04507","0","2009-07-28","J/R- BRUSH AND YARD DEBRIS"]
["298 F 3","I","2009-08-17","3116","MAYFAIR DR","CODX2009-04215","305452","2009-07-13","HOUSING: WINDOWS NOT FULLY FUNCTIONAL/    PER CEO BDP SWEEP ADDITIONAL VIOLATIONS ARE AS FOLLOWS: INOP - BLUE MERCURY 1NVG762 AND J/R."]
["298 F 3","I","2009-08-17","3201","MAYFAIR DR","CODX2009-04586","0","2009-07-28","INOP/UNREG - VAN EXP. 2007, J/R"]
["298 F 3","I","2009-08-17","3244","MAYFAIR DR","CODX2009-04590","0","2009-07-28","LAWN PARKING - WHITE CAR ON LAWN 6EUU577"]
["298 F 3","I","2009-08-20","1200","SHADOWGLEN RD","CODX2009-04685","0","2009-07-31","Inop/Unreg - silver and blue cars\n"]
["298 H 3","I","2009-08-11","1328","FITCH WAY","CODX2009-04383","305994","2009-07-22","THERE IS A BEIGE TRUCK THAT IS PARKED ON THE FRONT LAWN OF THE REFERENCED PROPERTY"]
["299 A 1","I","2009-08-12","1921","WALNUT AVE","CODX2009-04421","306124","2009-07-23","VACANT RESIDENCE HAS DRY WEEDS OVER 4 FEET TALL IN BACKYARD."]

{"sheet":"Sheet16","index":15,"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: 7/6/2009 To: 8/2/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  undefined"]
["Subzone:  S1"]
["456 A 5","I","2009-07-28","636","TYLER ISLAND BRIDGE RD","CODX2009-04188","0","2009-07-10","INOPERABLE AND/OR UNREGISTERED VEHICLE"]
["456 A 5","R","2009-08-03","636","TYLER ISLAND BRIDGE RD","CODX2009-04188","0","2009-07-10","INOPERABLE AND/OR UNREGISTERED VEHICLE"]

{"sheet":"Sheet17","index":16,"n_rows":57,"n_cols":9,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,4],[4,0,4,4],[38,0,38,4]],"flags":["formulas_cached_only"]}
["ACTIVE CODE CASES"]
["Cases Opened From: 7/6/2009 To: 8/2/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Jared Wickliff"]
["Subzone:  E3"]
["260 B 4","I","2009-08-17","6438","BREEZEWOOD CT","CODX2009-04576","0","2009-07-28","UNREG 04 CHEVY TRAILBLAZER 5EDT637 IN D/W "]
["260 C 2","I","2009-08-11","8373","OLD RANCH RD","CODX2009-04396","306164","2009-07-22","POP-UP CAMPER LAWN PARKING. PARKED ON GRAVEL"]
["260 C 3","I","2009-08-05","8436","NOEL DR","CODX2009-04279","0","2009-07-16","UNREG DODGE TRUCK 2V65463 PARKED ON LAWN"]
["260 C 3","I","2009-08-21","8335","CENTRAL AVE","CODX2009-04312","305819","2009-07-17","HOUSING: RODENT INFESTATION"]
["260 C 3","I","2009-08-13","8430","NOEL DR","CODX2009-04441","0","2009-07-24","DODGE 2V65463 IN D/W EXP REG"]
["260 D 3","I","2009-08-24","6726","CARRWOOD ST","CODX2009-04443","0","2009-07-24","2 DEAD TRUCKS ON LAWN, PILE OF BRICK AND OTHER JUNK ON LAWN. LOOKS MORE LIKE A CONTRACTOR STORAGE YARD THAN A RESIDENCE"]
["260 D 3","I","2009-08-24","8551","CENTRAL AVE","CODX2009-04444","0","2009-07-24","UNREG CHEVY TRUCK 3C30912 IN D/W W/FLAT TIRE.  ALSO MATTRESSES IN D/W"]
["260 D 4","I","2009-08-17","8650","GAINES AVE","CODX2009-04573","0","2009-07-28","UNREG 97 DODGE NEON 5RME564 IN D/W "]
["260 E 1","I","2009-08-13","7326","HICKORY AVE","CODX2009-04448","0","2009-07-24","UNREG DODGE VAN 803NAK IN D/W"]
["260 E 1","I","2009-08-13","7524","HICKORY AVE","CODX2009-04442","0","2009-07-24","UNREG RV 5BRM673 IS ALSO LAWN PARKING"]
["260 E 1","I","2009-08-10","7421","HICKORY AVE","CODX2009-04352","305871","2009-07-21","VACANT HOUSE.  DRY WEEDS IN BACKYARD MORE THAN 3 FEET TALL. FIRE HAZARD. 305873-JUNK IN BACKYARD."]
["260 E 2","I","2009-08-13","8842","MAVIS AVE","CODX2009-04449","0","2009-07-24","UNREG BMW 5YBR507 IN D/W"]
["260 E 2","I","2009-08-05","8712","BUNTING CT","CODX2009-04284","305791","2009-07-16","ILLEGAL HOME OCCUPATION - BRINGS BACKHOE TO RESIDENTIAL ZONE AS PART OF HIS BUSINESS"]
["260 E 3","I","2009-08-17","6808","BEECH AVE","CODX2009-04213","305343","2009-07-13","HOUSING: card issue 305343: VERMIN INFESTATION; HOLES AND GAPS IN WALLS. 07/14/2009-305358-REFRIGERATOR W/DOOR ON PATIO (LEFT BY LANDLORD).\n*********\ncard issue 305348: **WEBMAIL**CONSTITUENT STATES THAT RESIDENCE HAS NUMEROUS ISSUE THAT LANDLORD REFUSES TO REPAIR. HOLES IN WALLS, WATER SEEPAGE IN LAUNDRY/PANTRY BECAUSE WALLS DON'T GO ALL THE WAY TO FLOOR."]
["260 E 6","I","2009-08-03","8841","MOHAWK WAY","CODX2009-04221","305356","2009-07-14","3 vehicles in back yard, all inoperable, and at least one camping trailer.  unsure if there's any auto repair going on, but there's always a lot of noise after dark."]
["260 E 6","I","2009-08-12","8763","CORINNE DR","CODX2009-04416","306076","2009-07-23","THERE IS A LAREG AMOUNT OF JUNK ACCUMULATING IN THE FRONT YARD ANBD DRIVEWAY OF THE ABOVE ADDRESS. 07/29/2009-306482-THERE IS A BLACK/GRAY FORD P/U ON THE DRIVE WAY FOR YEARS, NEVER MOVES NO DAMAGE"]
["260 F 2","I","2009-08-18","7301","FILBERT AVE","CODX2009-04641","305263","2009-07-29","ZONING: SIGN COMPLAINT: ADVERTISING FINAL 9 SPORTS"]
["260 F 3","I","2009-08-18",null,null,"CODX2009-04642","305273","2009-07-29","ZONING: SIGN COMPLAINTS: BANNERS ADVERTISING SWIMMING POOLS"]
["260 F 5","I","2009-07-29","5838","PERMENTER CT","CODX2009-04142","0","2009-07-09","UNREG TOYOTA 2YYM357 IN D/W"]
["260 F 6","I","2009-08-12","8906","AMERIGO AVE","CODX2009-04419","306075","2009-07-23","THERE ARE SEVERAL CARS ARE PARKED ON THE LAWN "]
["260 G 3","I","2009-07-29","6550","FILBERT AVE","CODX2009-04165","305272","2009-07-09","MULT SIGNS FOR CHARTER SCHOOLS ON CORNER OF CENTRAL AND FILBERT"]
["260 H 2","I","2009-08-13","9362","OTTOMON WAY","CODX2009-04452","0","2009-07-24","UNREG VW 4MSD772 IN D/W"]
["260 H 2","I","2009-08-13","9395","OTTOMAN WAY","CODX2009-04453","0","2009-07-24","2 OLD BROKEN DOWN TRUCKS IN D/W ON MAIN AVE WITHOUT LICENSE PLATES"]
["260 H 2","I","2009-08-13","9390","NEVINS WAY","CODX2009-04454","0","2009-07-24","OLD BROKEN DOWN SCHOOL BUS IN R/Y WITH OR PLATES"]
["260 H 3","I","2009-08-18","9356","CENTRAL AVE","CODX2009-04652","306442","2009-07-29","ADDRESS HAS JUNK AND DEBRIS ON THE PROPERTY.THERE ARE PILES OF WOOD,2X4'S AND SHEET METAL IN THEIR DRIVEWAY."]
["260 H 3","I","2009-08-04","6745","MAIN AVE","CODX2009-04247","305475","2009-07-15","THERE ARE 4 IN OP VEHICLES ON THE PROPERTY. CURRENTLY THERE IS 1 BLACK BLAZER, 2 RED EL CAMINO'S AND A TOW TRUCK. VEHICLES HAVE BEEN THERE FOR 1 MONTH."]
["260 H 4","I","2009-08-18","6216","MAIN AVE","CODX2009-04643","306384","2009-07-29","operating business in area not zoned CALLER SAYS THAT THIS ADDRESS HAS NO BUSINESS LICENSE BUT IS RUNNING A RACECAR FABRICATION SHOP OUT OF HIS HOME."]
["260 H 4","I","2009-07-29","9328","ORANGEVALE AVE","CODX2009-04141","0","2009-07-09","UNREG PLYMOUTH 5ENN056 IN D/W WITH FLAT TIRE"]
["260 H 4","R","2009-09-14","6527","MAIN AVE","CODX2009-04164","305270","2009-07-09","ILLEGAL BLUE SIGN"]
["260 H 5","I","2009-08-18","9289","AIRHILL WAY","CODX2009-04644","306386","2009-07-29","DOING MAJOR AUTO REPAIR OUT OF GARAGE. HAS AN AVERAGE OF 5 CARS AT A TIME. HAS AUTO PARTS ON THE DRIVEWAY, ENGINE PARTS ETC, TOOLS,OIL, ETC. IT IS ALMOST LIKE A BUSINESS."]
["260 H 5","I","2009-08-19","9360","GREENBACK LN","CODX2009-04658","0","2009-07-30","RV STORAGE WITHOUT US PERMIT, CONCERTINA WIRE WITHOUT USE PERMIT, PORTABLE SIGNAGE"]
["260 H 6","I","2009-08-13","9304","BLUE OAK DR","CODX2009-04450","0","2009-07-24","UNREG TOYOTA 1LSY689 IN D/W "]
["260 J 5","I","2009-08-10","9635","TANGLEWOOD CIR","CODX2009-04378","306003","2009-07-21","PILING GARBAGE, COMPUTER MONITORS, AUATO PARTS, FURNITURE, UP AGANIST THE FENCE ON THE SIDE OF THE HOUSE THAT BORDERS CALLERS PROPERTY. THIS HAS BEEN ACCUMULATENG OVER THE PAST COUPLE OF YEARS AS AN OVERFLOW TO THE MATERIAL STORED IN THE GARAGE, THE GARBAGE SMELLS."]
["Subzone:  E4"]
["260 B 6","I","2009-08-06","8106","TREECREST AVE","CODX2009-04316","305827","2009-07-17","30' TRAILER COVERED BY BLUE TARP IN THE DRIVEWAY FOR MONTHS."]
["260 D 7","I","2009-09-01","5136","KENNETH AVE","CODX2009-04588","306057","2009-07-28","HOUSING: RODENT HARBORAGE"]
["260 E 7","I","2009-08-13","8701","EL CHAPUL WAY","CODX2009-04445","0","2009-07-24","UNREG AEROSTAR 2VJB838 IN D/W ON ILLINOIS"]
["260 E 7","I","2009-08-13","5141","ILLINOIS AVE","CODX2009-04446","0","2009-07-24","UNREG MALIBU 4ACR316"]
["260 E 7","I","2009-08-13","5135","ILLINOIS AVE","CODX2009-04447","0","2009-07-24","TORE UP TRUCK PARKED IN R/Y. 3 VEHICLES L/P ON F/Y"]
["260 F 7","I","2009-08-06","5046","HAZEL AVE","CODX2009-04322","305769","2009-07-17","VACANT HOUSE DRY WEEDS IN FRONT AND BACK YARDS MORE THAN TWO FEET TALL. "]
["260 F 7","I","2009-08-13","5000","GERHARDT PL","CODX2009-04455","0","2009-07-24","UNREG TOYOTA 1PFX132 IN D/W ON ROEDIGER LN. SARAN WRAP HANGING OVER LICENSE PLATE"]
["279 H 1","I","2009-08-05","7430","SAN NITA WAY","CODX2009-04282","0","2009-07-16","UNREG COMMERCIAL VEHICLE 1A11421 IN D/W"]
["279 H 1","I","2009-08-05","7445","SAN NITA WAY","CODX2009-04281","0","2009-07-16","UNREG RV 1LBL232 IN D/W"]
["279 J 3","I","2009-08-16","4053","BOB LN","CODX2009-04485","306370","2009-07-27","IN THE FRONT YARD THERE'S FURNITURE, COFFEE TABLES, A BABY STROLLER AND OTHER MISC JUNK ALL AROUND THE HOUSE."]
["279 J 3","I","2009-08-18","3937","NEW YORK AVE","CODX2009-04650","306453","2009-07-29","OLD APPLIANCES TREE ROOTS, LOTS OF JUNK AND DEBRI IN FRONT YARD, LEADING INTO STREET.."]
["279 J 3","I","2009-08-05","4049","BOB LN","CODX2009-04653","306435","2009-07-29","CARPET AND PAD IN FRONT YARD OVER 6 WEEKS.THE  FRONT YARD ALSO HAS SEVERAL BOXES WITH  MISC ITEMS AND BEER AND COKE BOTTLES EVERYWHERE GENERAL JUNK."]
["279 J 3","I","2009-08-24","4054","BOB LN","CODX2009-04483","306371","2009-07-27","JUNK AND RUBBISH: THERE'S ALUMINUM, BEER CANS, & SIDING IN THE YARD."]
["279 J 3","I","2009-08-18","4036","NEW YORK AVE","CODX2009-04218","305516","2009-07-14","HOUSING: ELECTRICAL ISSUES WITH CIRCUIT BREAKER RESULTING IN INSUFFICIENT LIGHTING"]
["280 B 2","I","2009-08-10","4532","CHICAGO AVE","CODX2009-04151","305324","2009-07-09","12 DERELICT CARS ON PROPERTY"]
["280 E 2","I","2009-08-11","8871","N WINDING WAY","CODX2009-04392","0","2009-07-22","YARD SALE FOR OVER A WEEK"]
["280 E 2","I","2009-08-11","8765","WINDING WAY","CODX2009-04394","0","2009-07-22","OWNER OF PROPERTY IS RUNNING AN AUTO SHOP OUT OF THE HOME.  MULTIPLE DERELICT CARS ARE SCATTERED ACROSS THE PROPERTY, PURPLE SILVERADO, WHITE BMW, TOYOTA TRUCK, AND 5 LAND CRUISERS OF VARYING AGES.  HE WORKS ON ALL OF THESE, OTHER CARS COME AND GO"]
["280 F 2","I","2009-08-19","4242","CURRAGH OAKS LN","CODX2009-04672","306533","2009-07-30","HAS BEEN DOING MAJOR AUTO REPAIR IN GARAGE AND SIDE YARD. THIS HAS BEEN GOING ON 5 YEARS MAJOR MACHINE NOISE 8-5 ALMOST DAILY. HE REBUILDS ONE AT A TIME. "]

{"sheet":"Sheet18","index":17,"n_rows":41,"n_cols":9,"rows_kept":41,"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: 7/6/2009 To: 8/2/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Kari Wilson"]
["Subzone:  S3"]
[null,"I","2009-08-04","8304","SILVER MOON WAY","CODX2009-04246","305465","2009-07-15","THERE IS  A TAN SEDAN PARKEN IN THE DRIVEWAY CAR IS TOTALED HAS BEEN THERE FOR 2 MONTHS."]
["298 H 6","I","2009-08-17","8991","GULFPORT WAY","CODX2009-04540","306336","2009-07-28","TENANTS MOVED OUT LEAVING 2 SOFAS ON DRIVEWAY FOR 2 MONTHS"]
["298 H 6","I","2009-08-17","8982","GULFPORT WAY","CODX2009-04538","306337","2009-07-28","MA.R, LAWN PARKING, INOPERABLE AND/OR UNREGISTERED (SEE NOTES OF FULL DESCRIPTION BELOW)"]
["298 H 7","I","2009-08-17","9012","NEW DAWN DR","CODX2009-04555","306314","2009-07-28","NEIGHBOR HAS PUT UP A SCREEN MESH FENCE ON TOP OF HIS FENCE MAKING IT ABOUT 10' TALL. ALSO BELIEVES THERE IS MARIJUANA PLANTS IN BACK YARD, MAY BE THE REASON FOR THE TALL FENCE."]
["298 J 6","I","2009-08-05","9100","RAWHIDE WAY","CODX2009-04272","305607","2009-07-16","PROPERTY HAS BEEN VACANT FOR 2 YEARS AND THERE ARE WEEDS THAT ARE OVER 12 INCHES HIGH ALL OVER THE PROPERTY"]
["298 J 6","I","2009-08-16","2624","NIAGARA WAY","CODX2009-04457","306073","2009-07-27","THERE IS A LARGE PILE OF JUNK ACCUMULATING IN THE DRIVEWAY OF THE ABOVE ADDRESS."]
["298 J 7","I","2009-08-20","9227","CARLA WAY","CODX2009-04726","306558","2009-07-31","RUNNING A AUTO BODY SHOP FOR THE LAST 5 YEARS."]
["298 J 7","I","2009-08-05","9175","FIRELIGHT WAY","CODX2009-04289","305711","2009-07-16","HOUSE AND YARD HAS JUNK IN FRONT YARD, CARS IN YARD, ETC. "]
["298 J 7","I","2009-08-11","9153","POSADA WAY","CODX2009-04400","306056","2009-07-22","INOPERABLE VEHICLE IN DRIVEWAY, BRONZE TOYOTA CAMRY, LICENSE 5NZC04Y."]
["298 J 7","I","2009-08-10","9133","POSADA WAY","CODX2009-04379","306006","2009-07-21","BEIGE FORD RANGER HAS BEEN IN DRIVEWAY FOR A COUPLE YEARS AND HAS COBWEBS. REG EXPIRED OCT 2007. LICENSE #Z750849"]
["299 A 5","I","2009-08-12","9351","DEFIANCE CIR","CODX2009-04414","306081","2009-07-23","BLACK HONDA/ACURA IN DRIVEWAY"]
["299 A 5","I","2009-08-04","2617","YUMA CIR","CODX2009-04265","305606","2009-07-15","PARKS HIS WHITE CHEVY BLAZER 4 WHEEL DR ABOUT A '72-'74, ON SIDE OF DRIVEWAY WHERE LAWN SHOULD BE, BUT IS DUSTY DIRT NOW. IT LEAKS OIL AND DISTROYED THE PACIFIC BELL TELEPHONE BOX BY DRIVING OVER IT. DOES NOT KNOW LIC# SITS IN SAME PLACE WEEKS AT A TIME."]
["299 A 5","I","2009-08-12","9338","DEFIANCE CIR","CODX2009-04413","306078","2009-07-23","GREEN HONDA PARKED IN DRIVEWAY. EXPIRED TAGS."]
["299 A 7","I","2009-08-11","3425","ZORINA WAY","CODX2009-04390","305612","2009-07-22","THERE IS A DETERIORATED COUCH IN FRONT OF THIS HOUSE THAT IS CREATING A RAT HARBORAGE.  THERE ARE ALSO PIECES OF THIS COUCH STREWN ABOUT THE PROPERTY."]
["299 A 7","R","2009-08-10","3374","ZORINA WAY","CODX2009-04267","305610","2009-07-15","THERE IS JUNK AND RUBBISH CONSISTING OF VAN SEATS, GARBAGE BAGS, BEER BOTTLES AND CASES, COUPLE OF ICE CHESTS, ETC. \nTHERE IS ALSO AN INOP VEHICLE ON PROP...BLACK SEDAN HAS NOT MOVED IN ABOUT 2 TO 3 WEEKS."]
["299 A 7","I","2009-08-12","9305","SUNGOLD WAY","CODX2009-04418","306106","2009-07-23","INOPERABLE PICKUP TRUCK IN DRIVEWAY PILED WITH JUNK AND DEBRIS. HAS BEEN THERE FOR MONTHS."]
["299 B 4","R","2009-08-20","9486","MIRA DEL RIO DR","CODX2009-04161","305279","2009-07-09","NEIGHBOR OPERATING BUSINESS IN DRIVEWAY, UP ALL HOURS AS MECHANIC..07/09/2009-305277-NEIGHBOR HAS JUNK AND DEBRI,, ALL OVER FRONT LAWN, DRIVEWAY AND ALL AROUND HOUSE."]
["299 B 6","I","2009-08-05","3300","COVERED WAGON CT","CODX2009-04298","305727","2009-07-16","INOPERATIVE VEHICLE, BLUE, CADILLAC, LICENSE PLATE HHA992, PARKED FOR PAST 6 YEARS IN DRIVEWAY, NEVER MOVES. COBWEBS EVERYWHERE, SOME NEIGHBORS HAVE NOTICED MICE COMING AND GOING FROM THE VEHICLE."]
["318 H 1","I","2009-08-11","9009","GLEN ALDER WAY","CODX2009-04381","305975","2009-07-22","CAR PARKED ON LAWN, LICENSE 5FKD288."]
["318 H 1","I","2009-07-17","8965","RED LEAF WAY","CODX2009-04183","305198","2009-07-10"," OWNER HAS 5 TON STAKE BED TRUCK PARKED AT RESIDENCE FOR OVER 4 WEEKS FILLED WITH GARBAGE."]
["318 H 1","I","2009-08-20","8999","GLEN ALDER WAY","CODX2009-04763","306479","2009-07-31","THERE IS A LARGE GARBAGE BIN ON THE PROPERTY AND HAS BEEN THERE FOR4 5 WEEKS, IT IS OVERFLOWING AND SMELLS BAD AND NOW THERE HAVE BEEN RODENTS SEEN NEAR BY."]
["318 H 1","I","2009-08-16","3533","LINDENWOOD WAY","CODX2009-04499","306255","2009-07-27","INOPERATIVE VEHICLE ON DRIVEWAY, WHEELS OFF, UP ON BLOCKS. BLUE, SEDAN, NO LICENSE PLATE NUMBER. THINK THEY ARE PULLING PARTS OFF TO FIX ANOTHER VEHICLE. HAS BEEN ON THE DRIVE FOR OVER 6 MONTHS. NEVER MOVES."]
["318 J 2","I","2009-07-22","4100","APPLEGATE DR","CODX2009-04362","305846","2009-07-21","HOUSING: COLLAPSING ROOF /\\ NEWEST COMPLAINT (7/23/09) SAYS \"ROOF ON RESIDENCE IS COLLAPSED\""]
["318 J 2","I","2009-08-04","9113","NASREEN DR","CODX2009-04245","305434","2009-07-15","RESIDENTS AT 9113 PARK THEIR VEHICLE UNDER THE TREE ON THE LAWN EVERY NIGHT.  BIG CREAM COLORED 4 DOOR CAR, DID NOT KNOW LICENSE PLATE."]
["318 J 2","I","2009-08-19","9160","IRISH GOLD WAY","CODX2009-04660","306418","2009-07-30","INOPERABLE, WRECKED HONDA, LICENSE 6FHK046 IN DRIVEWAY FOR SEVERAL WEEKS."]
["318 J 2","I","2009-07-30","4100","ASHGROVE WAY","CODX2009-04179","305262","2009-07-10","Home abandoned about a month ago, overgrown weeds in back yard and side yard, even all the way down to the sidewalk.  "]
["319 A 1","I","2009-08-04","9436","MIRANDY DR","CODX2009-04251","305522, 305523","2009-07-15","A maroonish pick-up truck has been on the lawn for at least a few months;A tannish pick-up truck has been on the lawn for at least a few months; 07/30/2009-306428-BOAT AND TRAILER PARKED ON FRONT LAWN."]
["319 A 1","I","2009-08-05","3625","HUNTSMAN DR","CODX2009-04308","305789","2009-07-16","WHITE SATURN IN-OP, IN THE DRIVEWAY AT LEAST 2 YEARS. LICENSE 4FRP471.  ALSO A BLUE AND SILVER BOAT IN THE DRIVEWAY ON A TRAILER FOR VERY LONG TIME. CA0702."]
["319 A 1","I","2009-08-05","3717","HUNTSMAN DR","CODX2009-04309","305792","2009-07-16","BROWN CHEVY 2500 SUPERCAB, NO PLATES, IN-OP. IN DRIVEWAY OVER 3 YEARS, COVERED BY A BLUE TARP FOR LAST YEAR."]
["319 A 1","I","2009-08-19","3608","REEDSPORT CT","CODX2009-04673","proactive","2009-07-30","yard parking Boat on trailer parked on unapproved surface- also RV partially parked in the yard also"]
["319 A 1","I","2009-08-18","9458","SALISHAN CT","CODX2009-04647","306399","2009-07-29","NEIGHBOR IS BEEKEEPING AND HAS SEEN A LOT OF BEES. HAS SEEN THE WHITE BOXES IN NEIGHBOR'S BACKYARD AND HAS BEEN STUNG BY BEES."]
["319 B 1","R","2009-07-20","3832","FABERGE WAY","CODX2009-04134","305012, 305186","2009-07-09","ABANDONED REFRIGERATOR ON DRIVEWAY. ISS# 305186 ALSO STATES THAT THERE IS JUNK & RUBBISH EVERYWHERE."]
["338 J 6","I","2009-08-18","8203","GARDENSIDE CT","CODX2009-04229","305244","2009-07-14","HOUSING: ELECTRICAL PROBLEMS: SPARKING, CIRCUIT BREAKER TRIPPING, SHOCKING, NONFUNCTIONAL IN KITCHEN"]
["338 J 7","I","2009-08-10","8353","LAS MONTANAS CT","CODX2009-04348","305850","2009-07-21","THIS ADDRESS HAS A DUCK & CHICKEN."]
["338 J 7","I","2009-08-12","9290","TAMERTON WAY","CODX2009-04422","306131","2009-07-23","CONSTIUENT STATES THAT THERE IS JUNK AND RUBBISH CONSISTING OF CANS, PAPERS, BOTTLES, ETC...\nALSO THERE INOP/UNREG VEHICLES IN THE DRIVEWAY.\nTHE SIDE AND BACK YARD FENCES ARE FALLING."]
["339 A 7","I","2009-08-17","9374","FOX RIVER WAY","CODX2009-04523","306347","2009-07-28","GREEN FORD EXPLORER, 4-DOOR. BEEN IN THE DRIVEWAY FOR 5 MONTHS, "]

{"sheet":"Sheet19","index":18,"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: 7/6/2009 To: 8/2/2009"]
["Thomas Guide","Type","Insp. Due Date","St No.","Street Name","Case Number","CUBS Issue #","Case Opened","Complaint Description"]
["Officer:  Scott Woodward"]
["Subzone:  N2"]
["238 G 4","R","2009-08-13","3419","ALDER CANYON WAY","CODX2009-04347","306025","2009-07-21","OVERGROWN VEGITATION AND POSSIBLE VOA WITH SQUATTERS"]
["238 H 6","R","2009-07-20","3900","TAWNY MEADOW WAY","CODX2009-04269","305715","2009-07-16","VOA....07/16/2009-305713-VACANT HOUSE. DRY WEEDS MORE THAN TWO FEET TALL IN FRONT AND BACK YARDS.  FIRE HAZARD."]