{"rows":[{"cartodb_id":6381,"the_geom":"0101000020E6100000F084E73295C652C014399D9509004440","the_geom_webmercator":"0101000020110F0000AB1BA4EE76E45FC107842C32F08F5241","addressobjectid":"587207","address":"1857 E VENANGO ST","unit_type":null,"unit_num":null,"zip":"19134-1521","opa_account_num":"452150200","parcel_id_num":"15391","censustract":"188","opa_owner":"CHEN XIANG","primaryappellant":"JUAN L. VALDEZ","appellanttype":"APPL","internaljobid":1367878,"appealnumber":"17570","acceleratedappeal":null,"createddate":"2012-03-20T20:15:47Z","completeddate":null,"relatedpermit":"Description of Project:  PWD-HOUSE DRAIN\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: AFFIRMED  DECDATE: 17-MAY-12  PROVISO: FOR WANT OF APPEARANCE  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"I HAD A LICENSED PLUMBER CLEAR THE BLOCKED LATERAL. HOWEVER, THE MORE HE CLEARED THE MORE IT FILLED WITH GREASE AND DIRT FROM THE STREET. THE PLUMBER BELIEVES THE PIPING UNDER THE STREET AND MY HOUSE ARE BENT INTO A V-SHAPE WHICH COULD BE CREATING THE BLOCKAGE.","scheduleddate":"2012-05-15T17:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":"FOR WANT OF APPEARANCE","decisiondate":"2012-05-17T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2710010.24952904,"geocode_y":254078.31483551,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":6303,"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}