{"rows":[{"cartodb_id":9435,"the_geom":"0101000020E6100000640B5C213CCA52C05763C9C175024440","the_geom_webmercator":"0101000020110F000024C7E201ABEA5FC185CE70DE9F925241","addressobjectid":"114314","address":"2053 DENNIE ST","unit_type":null,"unit_num":null,"zip":"19140-1722","opa_account_num":"131375100","parcel_id_num":"307374","censustract":"205","opa_owner":"BLIZZARD RAMONA","primaryappellant":"WINDY BROWN","appellanttype":"APPL","internaljobid":1578757,"appealnumber":"20960","acceleratedappeal":null,"createddate":"2013-07-22T20:01:14Z","completeddate":null,"relatedpermit":"Description of Project:  PWD-DEFECTIVE LATERAL\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: AFFIRMED  DECDATE: 22-AUG-13  PROVISO: CITY WILL STAY ENFORCEMENT FOR THIRTY (30) DAYS.  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"THE HOLE IN THE GROUND WAS COVERED IN MAY 2013. ON JULY 3RD THE CITY SENT PEOPLE IN TO CLEAN THE STREET BECAUSE THE STREET WAS TO BE REPAVED. AT THE START OF EVERYTHING THE HOLE WAS STILL FILLED. TWO DAYS LATER THE CONCRETE WAS BROKEN UP BY THE CITY. AFTER THE STREET WAS DONE, THE WATER DEPARTMENT CAME AND STATED THE PIPE WAS DEFECTIVE.","scheduleddate":"2013-08-20T17:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":"CITY WILL STAY ENFORCEMENT FOR THIRTY (30) DAYS.","decisiondate":"2013-08-22T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2693828.18873969,"geocode_y":260495.84895786,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":9333,"coordinatingrco":null}],"time":0.002,"fields":{"cartodb_id":{"type":"number","pgtype":"int8"},"the_geom":{"type":"geometry","wkbtype":"Unknown","dims":2,"srid":4326},"the_geom_webmercator":{"type":"geometry","wkbtype":"Unknown","dims":2,"srid":3857},"addressobjectid":{"type":"string","pgtype":"varchar"},"address":{"type":"string","pgtype":"varchar"},"unit_type":{"type":"string","pgtype":"varchar"},"unit_num":{"type":"string","pgtype":"varchar"},"zip":{"type":"string","pgtype":"varchar"},"opa_account_num":{"type":"string","pgtype":"varchar"},"parcel_id_num":{"type":"string","pgtype":"varchar"},"censustract":{"type":"string","pgtype":"varchar"},"opa_owner":{"type":"string","pgtype":"varchar"},"primaryappellant":{"type":"string","pgtype":"varchar"},"appellanttype":{"type":"string","pgtype":"varchar"},"internaljobid":{"type":"number","pgtype":"numeric"},"appealnumber":{"type":"string","pgtype":"varchar"},"acceleratedappeal":{"type":"string","pgtype":"varchar"},"createddate":{"type":"date","pgtype":"timestamptz"},"completeddate":{"type":"date","pgtype":"timestamptz"},"relatedpermit":{"type":"string","pgtype":"varchar"},"relatedcasefile":{"type":"string","pgtype":"varchar"},"appealstatus":{"type":"string","pgtype":"varchar"},"appealtype":{"type":"string","pgtype":"varchar"},"agendadescription":{"type":"string","pgtype":"varchar"},"applicationtype":{"type":"string","pgtype":"varchar"},"meetingnumber":{"type":"string","pgtype":"varchar"},"appealgrounds":{"type":"string","pgtype":"varchar"},"scheduleddate":{"type":"date","pgtype":"timestamptz"},"decision":{"type":"string","pgtype":"varchar"},"meetingresult":{"type":"string","pgtype":"varchar"},"proviso":{"type":"string","pgtype":"varchar"},"decisiondate":{"type":"date","pgtype":"timestamptz"},"systemofrecord":{"type":"string","pgtype":"varchar"},"geocode_x":{"type":"number","pgtype":"numeric"},"geocode_y":{"type":"number","pgtype":"numeric"},"council_district":{"type":"string","pgtype":"varchar"},"posse_jobid":{"type":"string","pgtype":"varchar"},"gdb_geomattr_data":{"type":"bytea","pgtype":"bytea"},"objectid":{"type":"number","pgtype":"int4"},"coordinatingrco":{"type":"string","pgtype":"varchar"}},"total_rows":1}