{"rows":[{"cartodb_id":27579,"the_geom":"0101000020E6100000B8A7996339CA52C032C9023336F74340","the_geom_webmercator":"0101000020110F00007D83E059A6EA5FC1FE0FCD8128865241","addressobjectid":"648967","address":"1418 S 9TH ST","unit_type":null,"unit_num":null,"zip":"19147-5704","opa_account_num":"012269700","parcel_id_num":"417943","censustract":"28.02","opa_owner":"CHAN KEN HOI             ZHAO YATING","primaryappellant":"KEN CHAN","appellanttype":"APPL","internaljobid":879122,"appealnumber":"7068","acceleratedappeal":null,"createddate":"2008-09-08T20:22:00Z","completeddate":null,"relatedpermit":"Description of Project:  145\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: MOOT  DECDATE: 28-JAN-09  PROVISO: COMPLIED  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"I AM THE OWNER OF THE PROPERTY, ALSO A REGISTERED MASTER PLUMBER IN THE CITY. BASED ON THE THEORY AND METHOD USED TO DETERMINE, THE LEAK SHOULD BE CONSIDERED OUT OF DATE AND UNSCIENTIFIC. WE DO NOT HAVE LEAKING ON OUR FRONT BASEMENT WALL OR SURROUNDING SUPPLY PIPING AREA.","scheduleddate":"2009-01-27T18:15:00Z","decision":"MOOT","meetingresult":null,"proviso":"COMPLIED","decisiondate":"2009-01-28T05:00:00Z","systemofrecord":"HANSEN","geocode_x":2694813.83698197,"geocode_y":228498.90934747,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":27479,"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}