{"rows":[{"cartodb_id":10168,"the_geom":"0101000020E61000001B491FAC6EBF52C0EB9E2CA5CA084440","the_geom_webmercator":"0101000020110F0000170B479951D85FC13E9EF513A6995241","addressobjectid":"105020","address":"3626 W CROWN AVE","unit_type":null,"unit_num":null,"zip":"19114-1825","opa_account_num":"661181500","parcel_id_num":"311016","censustract":"353.01","opa_owner":"KODROFF DEBORAH C TR","primaryappellant":"DEBBIE C. KODROFF","appellanttype":"APPL","internaljobid":1636352,"appealnumber":"21836","acceleratedappeal":null,"createddate":"2013-12-03T20:51:23Z","completeddate":null,"relatedpermit":"Description of Project:  PWD\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: AFFIRMED  DECDATE: 15-JAN-14  PROVISO: 30 DAY STAY OF ENFORCEMENT  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"THE CITY INSTALLED A NEW WATER MAIN IN THE FALL OF 2012. SINCE THEN I HAVE BEEN HAVING MINOR SEWER BACK-UPS. THE PROBLEM HAS BECOME INCREASINGLY WORSE OVER TIME. I CALLED A PLUMBER AND WAS TOLD THE SEWER VENT AND TRAP WERE NOT INSTALLED CORRECTLY AND FILLED WITH DIRT. THE PLUMBER ATTEMPTED TO CLEAR THE BLOCKAGE FROM THE HOUSE AND STATED THE PROBLEM WAS AT THE TRAP WHERE THE GROUND WAS DUG UP WHEN THE NEW MAIN WAS INSTALLED.","scheduleddate":"2014-01-07T18:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":"30 DAY STAY OF ENFORCEMENT","decisiondate":"2014-01-15T05:00:00Z","systemofrecord":"HANSEN","geocode_x":2740518.57849121,"geocode_y":279938.0254333899,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":10062,"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}