{"rows":[{"cartodb_id":13969,"the_geom":"0101000020E6100000000000000000F87F000000000000F87F","the_geom_webmercator":null,"addressobjectid":null,"address":null,"unit_type":null,"unit_num":null,"zip":null,"opa_account_num":null,"parcel_id_num":null,"censustract":null,"opa_owner":null,"primaryappellant":"MICHAEL JP WILLIAMS, ESQ.","appellanttype":"OTHER","internaljobid":1930154,"appealnumber":"26079","acceleratedappeal":null,"createddate":"2015-09-16T16:05:09Z","completeddate":null,"relatedpermit":"Description of Project:  Journeyman Plumber License\n  APPEAL TYPES==> \nAPPEAL TYPE: MISC  \n\n  BOARD DECISIONS==> \nDECISION: SUSTAINED  DECDATE: 18-NOV-15  PROVISO:   \n\n  COURT APPEALS==> \n","relatedcasefile":null,"appealstatus":"OPEN","appealtype":null,"agendadescription":null,"applicationtype":"RB_LIRB","meetingnumber":null,"appealgrounds":"APPLICANT EXCEEDS REQUIREMENTS OF PHILADELPHIA CODE CHAPTER 9-1000 PLUMBER 8334a-c FOR ISSUANCE OF JOURNEYMAN PLUMBER LICENSE AND HEREBY APPEAL CITY'S REFUSAL TO ISSUE LICENSE. APPLICANT PASSED EXAMINATION, HAS REQUISITE EXPERIENCE IN PLUMBING FIELD, IS LICENSED PLUMBER IN FOUR JURISDICTIONS OTHER THAN PHILADELPHIA.","scheduleddate":"2015-11-17T18:15:00Z","decision":null,"meetingresult":null,"proviso":null,"decisiondate":"2015-11-18T05:00:00Z","systemofrecord":"HANSEN","geocode_x":null,"geocode_y":null,"council_district":null,"posse_jobid":null,"gdb_geomattr_data":null,"objectid":13842,"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}