{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 21, "name": "Inspections", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 42, 170, 79, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -9771515.219407186, "ymin": 5.664923641290895E-9, "xmax": 6.327780442533911E-9, "ymax": 5802550.785232775, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "vcsWkid": 115700, "latestVcsWkid": 115700, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 } }, "heightModelInfo": { "heightModel": "ellipsoidal", "vertCRS": "WGS_1984", "heightUnit": "meter" }, "supportsVCSProjection": true, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "site_contact_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "inspection_dt", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "applicationid", "type": "esriFieldTypeGUID", "alias": "ApplicationID", "length": 38, "domain": null }, { "name": "reportid", "type": "esriFieldTypeGUID", "alias": "ReportID", "length": 38, "domain": null }, { "name": "requestid", "type": "esriFieldTypeGUID", "alias": "RequestID", "length": 38, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 4000, "domain": null }, { "name": "inspection_type", "type": "esriFieldTypeString", "alias": "Inspection Type", "length": 255, "domain": null }, { "name": "ref_id", "type": "esriFieldTypeString", "alias": "Reference #", "length": 255, "domain": null }, { "name": "accela_ref_id", "type": "esriFieldTypeString", "alias": "Accela Ref ID", "length": 50, "domain": null }, { "name": "reference_id", "type": "esriFieldTypeString", "alias": "Reference ID", "length": 255, "domain": null }, { "name": "report_type", "type": "esriFieldTypeString", "alias": "Report Type", "length": 35, "domain": null }, { "name": "amended_report_comment", "type": "esriFieldTypeString", "alias": "Amended Report Comments", "length": 4000, "domain": null }, { "name": "next_inspection_type", "type": "esriFieldTypeString", "alias": "Next Inspection Type", "length": 255, "domain": null }, { "name": "actrpt_2", "type": "esriFieldTypeString", "alias": "actrpt_2", "length": 255, "domain": null }, { "name": "actrpt_3", "type": "esriFieldTypeString", "alias": "actrpt_3", "length": 255, "domain": null }, { "name": "actrpt_4", "type": "esriFieldTypeString", "alias": "actrpt_4", "length": 255, "domain": null }, { "name": "actrpt_5", "type": "esriFieldTypeString", "alias": "actrpt_5", "length": 1000, "domain": null }, { "name": "public_act", "type": "esriFieldTypeString", "alias": "Public Act and Law", "length": 255, "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": null }, { "name": "inspection_location", "type": "esriFieldTypeString", "alias": "Facility # / Address", "length": 255, "domain": null }, { "name": "tanks_inspected", "type": "esriFieldTypeString", "alias": "Tank List", "length": 1000, "domain": null }, { "name": "tank_facilityid", "type": "esriFieldTypeString", "alias": "Tank FacilityID", "length": 255, "domain": null }, { "name": "inspection_result", "type": "esriFieldTypeString", "alias": "Result", "length": 35, "domain": null }, { "name": "num_tanks_inspected", "type": "esriFieldTypeSmallInteger", "alias": "# Tanks Inspected", "domain": null }, { "name": "num_violations_cited", "type": "esriFieldTypeSmallInteger", "alias": "# Violations Cited", "domain": null }, { "name": "tankid", "type": "esriFieldTypeGUID", "alias": "TankID", "length": 38, "domain": null }, { "name": "site_contact_name", "type": "esriFieldTypeString", "alias": "Contact Name", "length": 255, "domain": null }, { "name": "site_contact_information", "type": "esriFieldTypeString", "alias": "Contact Info", "length": 255, "domain": null }, { "name": "resolve_by_dt", "type": "esriFieldTypeDate", "alias": "Complaince Required Date", "length": 8, "domain": null }, { "name": "facilityid", "type": "esriFieldTypeGUID", "alias": "FacilityID", "length": 38, "domain": null }, { "name": "parentglobalid", "type": "esriFieldTypeGUID", "alias": "Activity ID", "length": 38, "domain": null }, { "name": "status_date", "type": "esriFieldTypeDate", "alias": "Status Date", "length": 8, "domain": null }, { "name": "amended_yn", "type": "esriFieldTypeString", "alias": "Report is amended", "length": 5, "domain": null }, { "name": "insp_start_time", "type": "esriFieldTypeDate", "alias": "Start Time", "length": 8, "domain": null }, { "name": "insp_end_time", "type": "esriFieldTypeDate", "alias": "End Time", "length": 8, "domain": null }, { "name": "accela_inspector_name", "type": "esriFieldTypeString", "alias": "Accela Inspector Name", "length": 255, "domain": null }, { "name": "accela_insp_desc", "type": "esriFieldTypeString", "alias": "Accela Inspection Description", "length": 255, "domain": null }, { "name": "accela_insp_result_date", "type": "esriFieldTypeDate", "alias": "accela_insp_result_date", "length": 8, "domain": null }, { "name": "accela_insp_total_mileage", "type": "esriFieldTypeDouble", "alias": "accela_insp_total_mileage", "domain": null }, { "name": "accela_insp_start_mileage", "type": "esriFieldTypeDouble", "alias": "accela_insp_start_mileage", "domain": null }, { "name": "accela_insp_end_mileage", "type": "esriFieldTypeDouble", "alias": "Accela Inspection End Mileage", "domain": null }, { "name": "accela_hist_checklist_num", "type": "esriFieldTypeDouble", "alias": "Accela Hist Checklist Number", "domain": null }, { "name": "requested_inspection_dt", "type": "esriFieldTypeDate", "alias": "Requested Inspection Dt", "length": 8, "domain": null }, { "name": "completed_inspection_dt", "type": "esriFieldTypeDate", "alias": "Completed Inpsection Dt", "length": 8, "domain": null }, { "name": "systemid", "type": "esriFieldTypeGUID", "alias": "System ID", "length": 38, "domain": null }, { "name": "next_inspection_dt", "type": "esriFieldTypeDate", "alias": "Next Inspection Dt", "length": 8, "domain": null }, { "name": "accela_hist_inspection_num", "type": "esriFieldTypeDouble", "alias": "Accela Hist Inspection Num", "domain": null }, { "name": "accela_insp_total_time", "type": "esriFieldTypeInteger", "alias": "Accela Insp Total Time", "domain": null }, { "name": "accela_insp_group", "type": "esriFieldTypeString", "alias": "Accela Inspection Group", "length": 100, "domain": null }, { "name": "accela_is_required_insp", "type": "esriFieldTypeString", "alias": "Accela Is Required Inspection", "length": 1, "domain": null }, { "name": "facility_no", "type": "esriFieldTypeString", "alias": "Facility No", "length": 255, "domain": null }, { "name": "facility_name", "type": "esriFieldTypeString", "alias": "Facility Name", "length": 255, "domain": null }, { "name": "facility_status", "type": "esriFieldTypeString", "alias": "Facility Status", "length": 35, "domain": null }, { "name": "facility_address1", "type": "esriFieldTypeString", "alias": "Facility Address 1", "length": 255, "domain": null }, { "name": "facility_address2", "type": "esriFieldTypeString", "alias": "Facility Address 2", "length": 255, "domain": null }, { "name": "facility_city", "type": "esriFieldTypeString", "alias": "Facility City", "length": 255, "domain": null }, { "name": "facility_zip", "type": "esriFieldTypeString", "alias": "Facility Zip", "length": 255, "domain": null }, { "name": "inspection_last_routine_dt", "type": "esriFieldTypeDate", "alias": "Last Routine Inspection Date", "length": 8, "domain": null }, { "name": "inspection_last_type", "type": "esriFieldTypeString", "alias": "Last Inspection Type", "length": 255, "domain": null }, { "name": "inspection_last_dt", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "length": 8, "domain": null }, { "name": "report_last_action", "type": "esriFieldTypeString", "alias": "Last Action", "length": 50, "domain": null }, { "name": "system_type", "type": "esriFieldTypeString", "alias": "System Type", "length": 255, "domain": null }, { "name": "system_subtype", "type": "esriFieldTypeString", "alias": "System Sub Type", "length": 255, "domain": null }, { "name": "tank_qty", "type": "esriFieldTypeSmallInteger", "alias": "Number of Tanks", "domain": null }, { "name": "scheduled_inspection_dt", "type": "esriFieldTypeDate", "alias": "Scheduled Date", "length": 8, "domain": null }, { "name": "facility_state", "type": "esriFieldTypeString", "alias": "Facility State", "length": 255, "domain": null }, { "name": "inspection_no", "type": "esriFieldTypeString", "alias": "Inspection Number", "length": 255, "domain": null }, { "name": "site_contact_phone", "type": "esriFieldTypeString", "alias": "Site Contact Phone", "length": 15, "domain": null }, { "name": "compl_reqd_dt", "type": "esriFieldTypeDate", "alias": "Complaince Req Date", "length": 8, "domain": null }, { "name": "compl_rcvd_dt", "type": "esriFieldTypeDate", "alias": "Complaince Rec Date", "length": 8, "domain": null }, { "name": "piping_underground", "type": "esriFieldTypeString", "alias": "Underground Piping", "length": 255, "domain": null }, { "name": "piping_cath_prot", "type": "esriFieldTypeString", "alias": "Piping Cathoticaly Protected", "length": 255, "domain": null }, { "name": "piping_release_det", "type": "esriFieldTypeString", "alias": "Piping Release Detection", "length": 255, "domain": null }, { "name": "system_location", "type": "esriFieldTypeString", "alias": "System Location", "length": 255, "domain": null }, { "name": "regulated_substance", "type": "esriFieldTypeString", "alias": "Regulated Substance", "length": 255, "domain": null }, { "name": "refined_petro", "type": "esriFieldTypeString", "alias": "Refined Petroleum", "length": 255, "domain": null }, { "name": "plan_review_req", "type": "esriFieldTypeString", "alias": "Plan Review Required", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "worker_id", "type": "esriFieldTypeString", "alias": "Worker ID", "length": 128, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "parent_inspectionid", "type": "esriFieldTypeGUID", "alias": "Parent Inspection ID", "length": 38, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "UUID_642", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_642", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_accela_insp_desc", "fields": "accela_insp_desc,accela_insp_group,accela_insp_result_date,accela_inspector_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_accela_insp_group", "fields": "accela_insp_group,accela_insp_desc,accela_insp_result_date,accela_inspector_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_accela_insp_result_date", "fields": "accela_insp_result_date,accela_insp_desc,accela_insp_group,accela_inspector_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_accela_inspector_name", "fields": "accela_inspector_name,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_applicationid", "fields": "applicationid,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_completed_inspection_dt", "fields": "completed_inspection_dt,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_created_date", "fields": "created_date,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_facilityid", "fields": "facilityid,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_inspection_dt", "fields": "inspection_dt,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_inspection_result", "fields": "inspection_result,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_inspection_type", "fields": "inspection_type,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_report_type", "fields": "report_type,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_reportid", "fields": "reportid,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_status", "fields": "status,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_status_date", "fields": "status_date,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_INSPECTIONS_systemid", "fields": "systemid,accela_insp_desc,accela_insp_group,accela_insp_result_date", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_TMP_INSPECTIONS_Accela_Insp_Nbr", "fields": "accela_hist_inspection_num", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S157_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "LARA_SDE.LARA_ADMIN.facilityViolations", "relatedTableId": 54, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B4D5490B-BF25-4FEC-AFD1-7BCD6CCFDCF8}" }, { "id": 1, "name": "LARA_SDE.LARA_ADMIN.inspectionNotes", "relatedTableId": 56, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{5A691EEA-0EBD-471E-9E09-0E4CE7A4E1A7}" }, { "id": 0, "name": "LARA_SDE.LARA_ADMIN.inspectionRelease", "relatedTableId": 58, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2C4B2C5F-C45A-46C9-AC48-94632A19C9B4}" }, { "id": 3, "name": "LARA_SDE.LARA_ADMIN.inspectionVariances", "relatedTableId": 57, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4C0F2917-6769-4B96-B05D-B35886FAC3CC}" }, { "id": 4, "name": "LARA_SDE.LARA_ADMIN.inspectionTanks", "relatedTableId": 53, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{EC41650D-8A95-412B-820A-525CE832B889}" }, { "id": 5, "name": "LARA_SDE.LARA_ADMIN.inspectors", "relatedTableId": 36, "role": "esriRelRoleDestination", "keyField": "worker_id", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E2721308-8E62-47AB-B13A-80D4B8A92784}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1750090878000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }