{"rows":[{"cartodb_id":30683,"the_geom":"0101000020E6100000AFF27BF4C0C952C027EA2D83A4F54340","the_geom_webmercator":"0101000020110F0000EDB81FC8D9E95FC144218DA66B845241","addressobjectid":"128659104","address":"2314 S 3RD ST","unit_type":null,"unit_num":null,"zip":"19148-4025","opa_account_num":"391000001","parcel_id_num":"129158","censustract":"004202","opa_owner":"SANBORN AUSTIN JR","primaryappellant":"FRANK RUDI","appellanttype":"Owner","internaljobid":null,"appealnumber":"HA-2021-004075","acceleratedappeal":"Standard Appeal","createddate":"2021-09-24T08:42:17Z","completeddate":"2024-07-19T13:45:12Z","relatedpermit":null,"relatedcasefile":"CF-2021-080649","appealstatus":"Closed","appealtype":"LIRB-C L&I Denial","agendadescription":null,"applicationtype":"L&I Review Board Codes","meetingnumber":"MI-2022-001456","appealgrounds":"was issued a violation notice CF-2021-080649.\nWent to renew my contractors License and was denied \nDue to my OSHA card being expired. Due to covid it was \ndifficult to renewing my OSHA CARD\nI am currently in the process of renewing my OSHA card ","scheduleddate":"2024-07-18T16:30:00Z","decision":"City Affirmed","meetingresult":"Complete","proviso":"\nCITY AFFIRMED PER AGREEMENT WITH A FIVE HUNDRED DOLLAR FINE ","decisiondate":"2024-07-19T13:44:35Z","systemofrecord":"ECLIPSE","geocode_x":2697005.73800033,"geocode_y":224095.8297318929,"council_district":"1","posse_jobid":"395501670","gdb_geomattr_data":null,"objectid":30540,"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}