{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 11, "name": "ELJ Assessment", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "SurveyDate", "creatorField": "Surveyor", "editDateField": "EditDate", "editorField": "Editor", "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Headworks.SDE.ELJs", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ELJCode", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "SurveyDate", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ELJCode", "type": "esriFieldTypeString", "alias": "ELJ Code", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ELJCode" }, { "name": "JamType", "type": "esriFieldTypeString", "alias": "Jam Type", "domain": { "type": "codedValue", "name": "JamType", "description": "Jam Type", "codedValues": [ { "name": "Bank Input", "code": "BI" }, { "name": "Log Steps", "code": "LS" }, { "name": "Valley", "code": "V" }, { "name": "Flow Deflection", "code": "FD" }, { "name": "Debris Flow/Flood", "code": "DFF" }, { "name": "Bench", "code": "B" }, { "name": "Bar Apex", "code": "BA" }, { "name": "Meander", "code": "M" }, { "name": "Raft", "code": "R" }, { "name": "Unstable", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "JamType" }, { "name": "JamSize", "type": "esriFieldTypeString", "alias": "Jam Size", "domain": { "type": "codedValue", "name": "JamSize", "description": "Jam Size Classes", "codedValues": [ { "name": "10 to 50 logs", "code": "Small" }, { "name": "51 to 100 logs", "code": "Medium" }, { "name": "Over 100 logs", "code": "Large" }, { "name": "Less than 10 logs", "code": "No Jam" }, { "name": "Designates two ELJs that racked up 10+ pieces and are connected", "code": "Aggregation" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "JamSize" }, { "name": "Zone", "type": "esriFieldTypeString", "alias": "Zone", "domain": { "type": "codedValue", "name": "WoodChannelZone", "description": "Channel Zones (Z1/Z2) for woody debris", "codedValues": [ { "name": "Wetted", "code": "Z1" }, { "name": "Bankfull", "code": "Z2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Zone" }, { "name": "HabitatUnit", "type": "esriFieldTypeString", "alias": "Habitat Unit", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "HabitatUnit" }, { "name": "NaturalWoodRecruitment", "type": "esriFieldTypeString", "alias": "Natural Wood Recruitment", "domain": { "type": "codedValue", "name": "YES_NO_CODE", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "NaturalWoodRecruitment" }, { "name": "TagNumObserved", "type": "esriFieldTypeString", "alias": "Tag Numbers Observed", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "TagNumObserved" }, { "name": "StructurePerformance", "type": "esriFieldTypeString", "alias": "Structure Performance", "domain": { "type": "codedValue", "name": "WoodPerformance", "description": "Log and Jam Structure Performance", "codedValues": [ { "name": "Fully meeting or exceeding performance objective", "code": "4" }, { "name": "Poorly meeting performance objective", "code": "2" }, { "name": "Not meeting performance objective", "code": "1" }, { "name": "Adequately meeting performance objective", "code": "3" }, { "name": "Structure lost", "code": "0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "StructurePerformance" }, { "name": "StructureCondition", "type": "esriFieldTypeString", "alias": "Structure Condition", "domain": { "type": "codedValue", "name": "WoodCondition", "description": "Log and Jam Structural Condition", "codedValues": [ { "name": "Good to very good condition", "code": "4" }, { "name": "Adequate condition", "code": "3" }, { "name": "Poor condition", "code": "2" }, { "name": "Structure has failed or is in danger of collapse.", "code": "1" }, { "name": "Structure lost", "code": "0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "StructureCondition" }, { "name": "StructureStability", "type": "esriFieldTypeString", "alias": "Structure Stability", "domain": { "type": "codedValue", "name": "WoodStability", "description": "Log and Jam Structural Stability", "codedValues": [ { "name": "No movement or rotation", "code": "4" }, { "name": "Small movement or rotation", "code": "3" }, { "name": "Large movement or rotation", "code": "2" }, { "name": "Complete failure", "code": "1" }, { "name": "Sturcture lost", "code": "0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "StructureStability" }, { "name": "MaintenanceRecommendation", "type": "esriFieldTypeString", "alias": "Maintenance Recommendation", "domain": { "type": "codedValue", "name": "WoodMaintenance", "description": "Log and Jam Maintenance Recommendations", "codedValues": [ { "name": "No repairs or maintenance required", "code": "4" }, { "name": "Minor repairs or maintenance could be undertaken but are not mandatory", "code": "3" }, { "name": "Repairs or mainenance required", "code": "2" }, { "name": "Major repairs required", "code": "1" }, { "name": "Assess need for replacement", "code": "0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "MaintenanceRecommendation" }, { "name": "SurveyDate", "type": "esriFieldTypeDate", "alias": "Survey Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SurveyDate" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Comments" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Surveyor", "type": "esriFieldTypeString", "alias": "Surveyor", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Surveyor" }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Editor" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate" } ], "indexes": [ { "name": "R309_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_309", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_66250_ELJCod", "fields": "ELJCode", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_309", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ELJ Assessment", "description": "", "prototype": { "attributes": { "MaintenanceRecommendation": null, "Comments": null, "ELJCode": null, "JamType": null, "JamSize": null, "Zone": null, "HabitatUnit": null, "NaturalWoodRecruitment": null, "TagNumObserved": null, "StructurePerformance": null, "StructureCondition": null, "StructureStability": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }