{"rows":[{"cartodb_id":3253,"the_geom":"0101000020E6100000BF9EB8B8B1CD52C088909F0473FC4340","the_geom_webmercator":"0101000020110F00001D7CF2458BF05FC1998F7700F68B5241","addressobjectid":"688394","address":"1040 N 46TH ST","unit_type":null,"unit_num":null,"zip":"19131-4614","opa_account_num":"062381100","parcel_id_num":"243737","censustract":"105","opa_owner":"COLLINS DAVID C          VERONICA C H/W","primaryappellant":"VERONICA COLLINS","appellanttype":"APPL","internaljobid":1190129,"appealnumber":"14166","acceleratedappeal":null,"createddate":"2010-12-20T18:54:00Z","completeddate":null,"relatedpermit":"Description of Project:  RADIO #122, #37, #254, #264\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: AFFIRMED  DECDATE: 09-MAR-11  PROVISO: 30 DAYS STAY OF ENFORCEMENT  \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"MY PROPERTY WAS INSPECTED BY A PLUMBER AND THE LEAK WAS NOT IN MY PIPE BUT IN THE CITY'S MAIN PIPE. THE CITY IS SAYING THE WATER PROBLEM IS SOMETHING DIFFERENT EACH TIME I RECEIVE A NOTICE OF DEFECT.","scheduleddate":"2011-03-08T18:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":"30 DAYS STAY OF ENFORCEMENT","decisiondate":"2011-03-09T05:00:00Z","systemofrecord":"HANSEN","geocode_x":2679186.73946198,"geocode_y":242957.39346729,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":3195,"coordinatingrco":null}],"time":0.004,"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}