{"rows":[{"cartodb_id":15031,"the_geom":"0101000020E6100000228EF38AE9C952C038F73CFE1C084440","the_geom_webmercator":"0101000020110F00007CC860B91EEA5FC128E7CA5DE5985241","addressobjectid":"595884","address":"2029 E WALNUT LN","unit_type":null,"unit_num":null,"zip":"19138-0000","opa_account_num":"501348700","parcel_id_num":"353162","censustract":"263.02","opa_owner":"MITCHELL TAKIYA C","primaryappellant":"TAKIYA MITCHELL","appellanttype":"APPL","internaljobid":2010711,"appealnumber":"27303","acceleratedappeal":null,"createddate":"2016-03-19T16:22:28Z","completeddate":null,"relatedpermit":"Description of Project:  510629\n  APPEAL TYPES==> \nAPPEAL TYPE: CONTSERVCS  \n\n  BOARD DECISIONS==> \nDECISION: CONTINUED  DECDATE: 14-MAY-16  PROVISO:   \nDECISION: CONTINUED  DECDATE: 21-SEP-16  PROVISO:   \nDECISION: CONTINUED  DECDATE: 29-NOV-16  PROVISO:   \nDECISION: CONTINUED  DECDATE: 16-MAR-17  PROVISO:   \nDECISION: AFFIRMED  DECDATE: 18-JUL-17  PROVISO: COMPLIED  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"THIS PROPERTY IS NOT CONNECTED IN FULL NOR PARTIAL TO THE VIOLATION ON PROPERTY LISTED AS 7259 LIMEKILN PIKE. THE VIOLATION PROPERTY IS LOCATED ON FULL CITY BLOCK AWAY FORM THE PROPERTIES BEING CITED.","scheduleddate":"2017-07-18T17:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":"COMPLIED","decisiondate":"2017-07-18T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2694766.67305228,"geocode_y":276619.3288147299,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":14894,"coordinatingrco":null}],"time":3.47,"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}