{"rows":[{"cartodb_id":24279,"the_geom":"0101000020E61000007E3385276BCB52C0D47C24AEA2FD4340","the_geom_webmercator":"0101000020110F0000917267B9ADEC5FC18E40928D468D5241","addressobjectid":"71838","address":"2629 CECIL B MOORE AVE","unit_type":null,"unit_num":null,"zip":"19121-2853","opa_account_num":"324050800","parcel_id_num":"224694","censustract":"149","opa_owner":"MURCHISON FRANCESCA O","primaryappellant":"FRANCESCA MURCHISON","appellanttype":"APPL","internaljobid":2590649,"appealnumber":"38628","acceleratedappeal":null,"createddate":"2019-09-13T13:50:00Z","completeddate":null,"relatedpermit":"Description of Project:  PWD (RESCHEDULED)\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: MOOT  DECDATE: 23-JAN-20  PROVISO:   \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"IN JUNE 2019 THE CITY OF PHILADELPHIA'S WATER DEPARTMENT CAME OUT TO THE BLOCK, DUGGED UP THE STREET AND REPLACED SOME PIPING. DURING THIS TIME, THEY LEFT THE VENT BOX OPENED AND UNCOVERED FOR DAYS BEFORE REPAIRING THE CEMENT AND COVERING THE BOX. IMMEDIATELY AFTER THIS ACTION WAS DONE I STARTED HAVING PLUMBING ISSUES AT MY RESIDENCE. I CALLED SEVERAL TIMES AND PUT EMERGENCY TICKETS IN AND THIS IS THE FIRST TIME IT IS NOW BEING ADDRESSED. THE CITY IS ADVISING THAT IT IS MY RESPONSIBILITY TO HAVE THIS REPAIRED WHEN I SHOULD NOT HAVE TO FIX AN ISSUE CAUSED BY THE WATER DEPARTMENT. PLEASE REVIEW PICTURES AND THE INFORMATION PROVIDED AND CONTACT ME IF ANYTHING ADDITIONAL IS NEEDED.","scheduleddate":"2020-01-23T18:15:00Z","decision":"MOOT","meetingresult":null,"proviso":null,"decisiondate":"2020-01-23T05:00:00Z","systemofrecord":"HANSEN","geocode_x":2689050.0340624796,"geocode_y":246619.93047068,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":24108,"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}