{"rows":[{"cartodb_id":7675,"the_geom":"0101000020E61000000F60D842CECB52C0039CCB8EF9F64340","the_geom_webmercator":"0101000020110F00000C0B271156ED5FC1C9FDE057E5855241","addressobjectid":"422349","address":"2322 MCCLELLAN ST","unit_type":null,"unit_num":null,"zip":"19145-1820","opa_account_num":"482016700","parcel_id_num":"477407","censustract":"37.01","opa_owner":"KELLEY INVESTMENT GROUP L","primaryappellant":"PAUL D. ROBINSON","appellanttype":"APPL","internaljobid":1454097,"appealnumber":"18976","acceleratedappeal":null,"createddate":"2012-10-03T14:07:48Z","completeddate":null,"relatedpermit":"Description of Project:  PWD-LEAK\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: LATE-APPRVD  DECDATE: 03-OCT-12  PROVISO:   \nDECISION: AFFIRMED  DECDATE: 03-DEC-12  PROVISO: 45 DAYS STAY OF ENFORCEMENT  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"THE PLUMBING DEFECT WAS CAUSED BY THE WATER DEPARTMENT WHEN THEY TURNED THE WATER OFF TO THE PROPERTY. THEY DAMAGED THE LINE CONNECTED TO THE SHUT OFF VALVE. MY NEIGHBORS AND MYSELF HAVE COMPLAINED TO THE WATER DEPARTMENT FOR TWO YEARS ABOUT HEARING WATER RUNNING UNDERGROUND.","scheduleddate":"2012-11-27T18:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":"45 DAYS STAY OF ENFORCEMENT","decisiondate":"2012-12-03T05:00:00Z","systemofrecord":"HANSEN","geocode_x":2687906.21214625,"geocode_y":227622.77344924,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":7583,"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}