{"rows":[{"cartodb_id":3826,"the_geom":"0101000020E6100000E8E6C06EEEC852C0C30E5E6CBB074440","the_geom_webmercator":"0101000020110F000031FC323074E85FC1086F1D1879985241","addressobjectid":"51279","address":"7029 N BROAD ST","unit_type":null,"unit_num":null,"zip":"19126-1714","opa_account_num":"611212000","parcel_id_num":"386288","censustract":"268","opa_owner":"THOMPSON JOSEPH HAYWARD  THOMPSON DEBORAH DAISZELL","primaryappellant":"DEBORAH THOMPSON","appellanttype":"APPL","internaljobid":1219729,"appealnumber":"14797","acceleratedappeal":null,"createddate":"2011-03-23T14:38:35Z","completeddate":null,"relatedpermit":"Description of Project:  Storm Inlet\n  APPEAL TYPES==> \nAPPEAL TYPE: WATER  \n\n  BOARD DECISIONS==> \nDECISION: AFFIRMED  DECDATE: 04-MAY-11  PROVISO:   \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"IF THE STORM FRESH AIR INLET IS MISSING, IT IS DEFECTIVE BECAUSE OF THE TREE WHERE BOTH THE SEWER AND STORM LAY. THIS TREE WAS CUT DOWN BY THE FAIRMOUNT PARK COMMISSION IN 2007. I CALLED THE PHILADELPHIA WATER DEPARTMENT TO REPORT DEFECTIVE SEWER.","scheduleddate":"2011-05-03T17:15:00Z","decision":"AFFIRMED","meetingresult":null,"proviso":null,"decisiondate":"2011-05-04T04:00:00Z","systemofrecord":"HANSEN","geocode_x":2699086.75054459,"geocode_y":275661.53059699,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":3767,"coordinatingrco":null}],"time":0.001,"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}