{"rows":[{"cartodb_id":9799,"the_geom":"0101000020E6100000035FB45CD4CA52C056939BD590F54340","the_geom_webmercator":"0101000020110F0000F612A396ADEB5FC15C991CDC55845241","addressobjectid":"87942","address":"2531 S CLARION ST","unit_type":null,"unit_num":null,"zip":"19148-4315","opa_account_num":"394448200","parcel_id_num":"216239","censustract":"40.02","opa_owner":"KRZYMOWSKI ALEX          SUTHERLAND MEGAN","primaryappellant":"ANTHONY KAYSER","appellanttype":"APPL","internaljobid":1608478,"appealnumber":"21386","acceleratedappeal":null,"createddate":"2013-09-25T19:42:43Z","completeddate":null,"relatedpermit":"Description of Project:  PWD\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: AFFIRMED  DECDATE: 20-NOV-13  PROVISO: BY AGREEMENT                        STAY OF ENFORCEMENT FOR 30DAYS  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"I AM NOT GETTING WATER IN MY BASEMENT, MY NEIGHBOR IS. I WAS NOT HOME AT THE TIME OF INSPECTION AND THERE IS NO MENTION OF ANY TESTING DONE TO ANY PLUMBING.  LOCAL PLUMBER LOOKED AT THE PLUMBING AND SAID IT COULDN'T BE THE PROBLEM.","scheduleddate":"2013-11-12T18:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":"BY AGREEMENT                        STAY OF ENFORCEMENT FOR 30DAYS","decisiondate":"2013-11-20T05:00:00Z","systemofrecord":"HANSEN","geocode_x":2692299.18723332,"geocode_y":223738.94440671,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":9694,"coordinatingrco":null}],"time":0.013,"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}