{"rows":[{"cartodb_id":4485,"the_geom":"0101000020E610000043A422C3BDCB52C08D48EF7E00F74340","the_geom_webmercator":"0101000020110F00001498C10A3AED5FC110FD0607ED855241","addressobjectid":"676148","address":"1807 S 23RD ST","unit_type":null,"unit_num":null,"zip":"19145-1901","opa_account_num":"482246200","parcel_id_num":"388583","censustract":"37.01","opa_owner":"HARRIS CASSIE E","primaryappellant":"TIFFANY GREEN","appellanttype":"APPL","internaljobid":1262563,"appealnumber":"15512","acceleratedappeal":null,"createddate":"2011-06-27T17:23:11Z","completeddate":null,"relatedpermit":"Description of Project:  PERMIT #319924\n  APPEAL TYPES==> \nAPPEAL TYPE: AGAINSTL&I  \n\n  BOARD DECISIONS==> \nDECISION: CONTINUED  DECDATE: 10-AUG-11  PROVISO: MUST HAVE REINSPECTION  \nDECISION: AFFIRMED  DECDATE: 22-SEP-11  PROVISO: FOR WANT OF APPEARANCE  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"OWNER HAS PUT UP OVERSIZED BAY PROTRUDING WINDOW THAT BLOCKS NEIGHBORS VIEW, INFRINGES ON PRIVACY AND LACKS CONFORMITY WITH BLOCK.  HE PUT AN ARCHED ROOF FRONT TO BACK OF HOUSE. IT WILL RAIN ON NEIGHBORS' HOUSES. NO EXTERIOR PERMIT FOR THE PREMISES.","scheduleddate":"2011-09-20T17:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":"FOR WANT OF APPEARANCE","decisiondate":"2011-09-22T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2688186.26896057,"geocode_y":227708.0758801,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":4421,"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}