{"rows":[{"cartodb_id":22132,"the_geom":"0101000020E610000064A7D42BFDD052C0FC93775DA5FC4340","the_geom_webmercator":"0101000020110F0000EDA413F523F65FC1B85377CC2D8C5241","addressobjectid":"407769","address":"7543 MALVERN AVE","unit_type":null,"unit_num":null,"zip":"19151-2815","opa_account_num":"343172000","parcel_id_num":"251282","censustract":"98.02","opa_owner":"TARHAN MEHMET","primaryappellant":"MEHMET TARHAN","appellanttype":"APPL","internaljobid":2462480,"appealnumber":"35899","acceleratedappeal":null,"createddate":"2018-12-18T16:13:04Z","completeddate":null,"relatedpermit":"Description of Project:  663584\n  APPEAL TYPES==> \nAPPEAL TYPE: HOUSING  \n\n  BOARD DECISIONS==> \nDECISION: WITHDRAWN  DECDATE: 14-MAY-19  PROVISO:   \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"CLOSED","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"THE TENANT WAS NOT CO-OPERATING TO RESOLVE THE ISSUES. THE APPOINTMENTS WERE SCHEDULED AND THE TECHNICIANS WERE AT THE PROPERTY EITHER THERE WERE NO GAS OR ELECTRICITY AT THE PROPERTY DURING TIME OF SERVICE REQUEST. I AM COMMITTED TO RESOLVE THE VIOLATIONS AS SOON AS POSSIBLE.","scheduleddate":"2019-05-14T17:15:00Z","decision":"WITHDRAWN","meetingresult":null,"proviso":null,"decisiondate":"2019-05-14T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2664748.25899663,"geocode_y":243106.79768836,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":21964,"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}