{"rows":[{"cartodb_id":4486,"the_geom":"0101000020E6100000980C9A3024C752C044522E484FFE4340","the_geom_webmercator":"0101000020110F00006B041AD169E55FC14C9283DE058E5241","addressobjectid":"3965","address":"3009 AGATE ST","unit_type":null,"unit_num":null,"zip":"19134-4320","opa_account_num":"252329300","parcel_id_num":"24469","censustract":"179","opa_owner":"LANDIS PROPERTY GROUP LLC","primaryappellant":"PHILLY RESIDENTIAL ACQUIS","appellanttype":"APPL","internaljobid":1262581,"appealnumber":"15513","acceleratedappeal":null,"createddate":"2011-06-27T17:38:19Z","completeddate":null,"relatedpermit":"Description of Project:  281895\n  APPEAL TYPES==> \nAPPEAL TYPE: HOUSING  \n\n  BOARD DECISIONS==> \nDECISION: AFFIRMED  DECDATE: 10-AUG-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":"DUE TO THE FINANCIAL SITUATION OF THE OWNERS, THEY ARE UNABLE TO MAKE THE NECESSARY REPAIRS TO THE PROPERTY.  THE OWNERS ARE CURRENTLY ATTEMPTING TO SELL THE PROPERTY BUT HAVE BEEN UNABLE TO DO SO THUS FAR.","scheduleddate":"2011-08-09T17:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":"FOR WANT OF APPEARANCE","decisiondate":"2011-08-10T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2707713.14467339,"geocode_y":249090.2642360499,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":4422,"coordinatingrco":null}],"time":0.001,"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}