{"rows":[{"cartodb_id":17547,"the_geom":"0101000020E61000006B710FED39CF52C08F5989355AF94340","the_geom_webmercator":"0101000020110F0000F61FD27825F35FC1B7C15B8A87885241","addressobjectid":"697261","address":"826 S 57TH ST","unit_type":null,"unit_num":null,"zip":"19143-2702","opa_account_num":"463251200","parcel_id_num":"392410","censustract":"81.01","opa_owner":"KENNEDY STEVEN","primaryappellant":"STEVEN KENNEDY","appellanttype":"APPL","internaljobid":2186850,"appealnumber":"30393","acceleratedappeal":null,"createddate":"2017-04-21T18:17:28Z","completeddate":null,"relatedpermit":"Description of Project:  PWD\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: CONTINUED  DECDATE: 06-JUN-17  PROVISO:   \nDECISION: CONTINUED  DECDATE: 01-AUG-17  PROVISO:   \nDECISION: MOOT  DECDATE: 27-SEP-17  PROVISO: COMPLIED  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"I HAVE BEEN COMPLAINING ABOUT SEWAGE IN FRONT OF MY PROPERTY FOR THE LAST FOUR YEARS. THERE'S CONFUSION BETWEEN PWD AND STREETS DEPARTMENT AS TO WHOSE PROBLEM IT IS. CONTACTED CITY COUNCIL PERSON. PWD RETURNED 2YRS. LATER STATING THAT IT'S MY PROBLEM.","scheduleddate":"2017-09-26T17:15:00Z","decision":"MOOT","meetingresult":null,"proviso":"COMPLIED","decisiondate":"2017-09-27T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2672730.86901492,"geocode_y":233955.56124934,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":17385,"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}