{"rows":[{"cartodb_id":6018,"the_geom":"0101000020E6100000BD94D8F0A2C252C027D18DEF93044440","the_geom_webmercator":"0101000020110F0000FB7941E8C2DD5FC119FC2337F9945241","addressobjectid":"76829","address":"7226 CHARLES ST","unit_type":null,"unit_num":null,"zip":"19135-1004","opa_account_num":"412235900","parcel_id_num":"509779","censustract":"326","opa_owner":"CHEN WEN BIN","primaryappellant":"SHERYLE MULHOLLAND","appellanttype":"APPL","internaljobid":1348463,"appealnumber":"17165","acceleratedappeal":null,"createddate":"2012-02-02T16:25:00Z","completeddate":"2012-04-19T18:05:36Z","relatedpermit":"Description of Project:  RADIO#664\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: AFFIRMED  DECDATE: 04-APR-12  PROVISO:   \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"IN 2001 MY NEIGHBOR AND I HAD OUR PLUMBING FIXED IN FRONT OF OUR HOMES, WE HAD THE VENTS, TRAP AND LATERAL REPLACED BECAUSE THEY WERE BROKEN.  NOW PWD CAME OUT AGAIN AND SAID THEY ARE BROKEN. HOWEVER, THERE ARE HOLES AT THE CURBS. IF THE PROBLEM WITH THE STREET IS NOT ADDRESSED, THEY WILL KEEP BREAKING.","scheduleddate":"2012-04-03T17:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":null,"decisiondate":"2012-04-04T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2726880.97189061,"geocode_y":267517.90076306,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":5940,"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}