{"rows":[{"cartodb_id":33759,"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":"TYLER BRADLEY DBA: THE SULLIVAN COMPANY","appellanttype":"Owner","internaljobid":null,"appealnumber":"HA-2024-001649","acceleratedappeal":"Standard Appeal","createddate":"2024-05-01T16:45:07Z","completeddate":"2025-09-26T14:08:06Z","relatedpermit":null,"relatedcasefile":"CF-2024-027269","appealstatus":"Closed","appealtype":"LIRB Violation Appeal","agendadescription":null,"applicationtype":"L&I Review Board Codes","meetingnumber":"MI-2025-004981","appealgrounds":"Never have i been told by any philadelphia inspector to upload my finish subcontractors after the permit has been issued to use.\n\nAdditiionally the contractor license renewal was  addressed by our office the day we were notified. The documents listed in eclipse were all labelled \"optional\". One wouldnt know that they need to upload an osha card and 3 copies of the same insurance document until its uploaded, reviewed, and told to us by L&I.","scheduleddate":"2025-09-25T16:30:00Z","decision":"City Affirmed","meetingresult":"Complete","proviso":"CITY AFFIRMED","decisiondate":"2025-09-26T14:07:27Z","systemofrecord":"ECLIPSE","geocode_x":null,"geocode_y":null,"council_district":null,"posse_jobid":"743409129","gdb_geomattr_data":null,"objectid":33726,"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}