{"rows":[{"cartodb_id":17548,"the_geom":"0101000020E6100000666AC44210C552C0D757C12347FF4340","the_geom_webmercator":"0101000020110F0000D4072448E2E15FC1C76E7AA0188F5241","addressobjectid":"766581","address":"4087 RICHMOND ST","unit_type":null,"unit_num":null,"zip":"19137-    ","opa_account_num":null,"parcel_id_num":null,"censustract":"183","opa_owner":"CITY OF PHILADELPHIA","primaryappellant":"CRAIG A. SOPIN, ESQ.","appellanttype":"OTHER","internaljobid":2186882,"appealnumber":"30394","acceleratedappeal":null,"createddate":"2017-04-21T17:24:14Z","completeddate":null,"relatedpermit":"Description of Project:  574778\n  APPEAL TYPES==> \nAPPEAL TYPE: HOUSING  \n\n  BOARD DECISIONS==> \nDECISION: CONTINUED  DECDATE: 21-JUN-17  PROVISO:   \nDECISION: AFFIRMED  DECDATE: 30-AUG-17  PROVISO:   \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"1)NO NOTICE GIVEN ON 3/2/17, THAT WAS INSPECTION DATE. 2)APPELLANT HAD LICENSES LISTED OR THEY WERE PENDING BUT CANCELED, WITHOUT AUTHORIZATION OF APPELLANT.3)EXAMPLES OF LICENSES ARE ATTACHED. 4)CERTAIN ITEMS WERE IN PLACE AND EITHER NOT ASKED FOR OR VIEWED BY INSPECTOR SUCH AS FIRE EXTINGUISHERS, MSDS SHEETS, 704 SIGN, NO SMOKING SIGNS, SCALE LICENSE, ETC. 5)WEEDS, CORDS, HIGH PILE STORAGE, DEFECTIVE CONTAINERS, TANK MARKINGS ALL CONFORMED TO INSPECTOR'S REQUEST. 6)NO PROPER AUTHORITY FOR NOTICE OF INTENT TO CEASE OPERATIONS. 7)EVEN IF LISTED VIOLATIONS WERE ACCURATE, NO BASIS FOR CEASE OPERATIONS.","scheduleddate":"2017-08-29T17:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":null,"decisiondate":"2017-08-30T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2716723.26826655,"geocode_y":252117.875189,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":17386,"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}