{"rows":[{"cartodb_id":338,"the_geom":"0101000020E6100000AD2E9A37FFCE52C04C32F8D590F64340","the_geom_webmercator":"0101000020110F0000F91EC6BFC1F25FC1A991B95C71855241","addressobjectid":"538504","address":"2138 S SIMPSON ST","unit_type":null,"unit_num":null,"zip":"19142-2030","opa_account_num":"401195600","parcel_id_num":"176667","censustract":"66","opa_owner":"GIBNEY DANIEL","primaryappellant":"SIS AY FEYISSA","appellanttype":"APPL","internaljobid":1034556,"appealnumber":"10381","acceleratedappeal":null,"createddate":"2009-11-02T14:44:00Z","completeddate":null,"relatedpermit":"Description of Project:  RADIO NO. 115\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: MOOT  DECDATE: 12-FEB-10  PROVISO: COMPLIED  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"WHEN I BOUGHT THE HOUSE EVERYTHING WAS INSPECTED AND EVERYTHING WORKED PROPERLY. THE WATER DEPARTMENT WAS WORKING ON THE STREET RUNNING NEW PIPES. MY HOUSE WAS VACANT AT THE TIME. MY TENANT JUST MOVED IN AND THE WATER BACKED UP IN THE BASEMENT.","scheduleddate":"2010-02-09T18:15:00Z","decision":"MOOT","meetingresult":null,"proviso":"COMPLIED","decisiondate":"2010-02-12T05:00:00Z","systemofrecord":"HANSEN","geocode_x":2673961.01157897,"geocode_y":226056.80080622,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":333,"coordinatingrco":null}],"time":0.093,"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}