{"rows":[{"cartodb_id":3828,"the_geom":"0101000020E61000003E6500663CCE52C004035B1FDCFB4340","the_geom_webmercator":"0101000020110F0000B3C171D476F15FC1D5B2B0C74E8B5241","addressobjectid":"348294","address":"5064 HOOPES ST","unit_type":null,"unit_num":null,"zip":"19139-1639","opa_account_num":"442035700","parcel_id_num":"48186","censustract":"104","opa_owner":"REED JANICE","primaryappellant":"MICHAEL T. REED","appellanttype":"APPL","internaljobid":1219788,"appealnumber":"14799","acceleratedappeal":null,"createddate":"2011-03-23T15:36:51Z","completeddate":null,"relatedpermit":"Description of Project:  Leak\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: AFFIRMED  DECDATE: 04-MAY-11  PROVISO: 30 DAY STAY OF ENFORCEMENT  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"PHILADELPHIA WATER DEPARTMENT SUBCONTRACTED WITH DANELLA CONSTRUCTION COMPANY. THEY WERE REPLACING PIPES ON THE ENTIRE BLOCK. THEY MUST HAVE BUSTED SOMETHING BECAUSE WATER WAS LEAKING FROM MY HOUSE AND 5066 HOOPES.","scheduleddate":"2011-05-03T17:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":"30 DAY STAY OF ENFORCEMENT","decisiondate":"2011-05-04T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2676863.42837402,"geocode_y":241212.57090546,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":3769,"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}