{"rows":[{"cartodb_id":11823,"the_geom":"0101000020E61000005C9D46E0D6C252C0F10F8B960A034440","the_geom_webmercator":"0101000020110F00005197E11F1BDE5FC13E7065ED44935241","addressobjectid":"339172","address":"6761 HEGERMAN ST","unit_type":null,"unit_num":null,"zip":"19135-2428","opa_account_num":"412435200","parcel_id_num":"499813","censustract":"325","opa_owner":"JACOBSON JESSE L","primaryappellant":"JESSE JACOBSON","appellanttype":"APPL","internaljobid":1751684,"appealnumber":"23608","acceleratedappeal":null,"createddate":"2014-08-21T17:41:00Z","completeddate":null,"relatedpermit":"Description of Project:  PWD-RESCHEDULED\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: CONTINUED  DECDATE: 01-DEC-14  PROVISO:   \nDECISION: CONTINUED  DECDATE: 11-MAR-15  PROVISO:   \nDECISION: MOOT  DECDATE: 22-APR-15  PROVISO: COMPLIED  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"I BELIEVE THERE ARE NO PROBLEMS WITH THE WATER PIPES OR VENT PIPE RELATING TO MY PROPERTY. THEY WERE REPLACED APPROXIMATELY 12 YRS. AGO. MY MAINTENANCE WORKER EXAMINED THE VENT PIPE ON 04/24/14, AFTER I RECEIVED THE NOTICE, AND FOUND NO DAMAGE. I BELIEVE IT WAS CAUSED BY FOUR (4) HOLES DRILLED IN 2012 OR 2013 BY PWD.","scheduleddate":"2015-04-21T17:15:00Z","decision":"MOOT","meetingresult":null,"proviso":"COMPLIED","decisiondate":"2015-04-22T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2726127.735443,"geocode_y":263119.88693352,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":11714,"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}