{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 11, "name": "ELJ Assessment", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SurveyDate", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ELJCode", "type": "esriFieldTypeString", "alias": "ELJ Code", "length": 20, "domain": null }, { "name": "JamType", "type": "esriFieldTypeString", "alias": "Jam Type", "length": 5, "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" } }, { "name": "JamSize", "type": "esriFieldTypeString", "alias": "Jam Size", "length": 15, "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" } }, { "name": "Zone", "type": "esriFieldTypeString", "alias": "Zone", "length": 3, "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" } }, { "name": "HabitatUnit", "type": "esriFieldTypeString", "alias": "Habitat Unit", "length": 25, "domain": null }, { "name": "NaturalWoodRecruitment", "type": "esriFieldTypeString", "alias": "Natural Wood Recruitment", "length": 5, "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" } }, { "name": "TagNumObserved", "type": "esriFieldTypeString", "alias": "Tag Numbers Observed", "length": 250, "domain": null }, { "name": "StructurePerformance", "type": "esriFieldTypeString", "alias": "Structure Performance", "length": 5, "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" } }, { "name": "StructureCondition", "type": "esriFieldTypeString", "alias": "Structure Condition", "length": 5, "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" } }, { "name": "StructureStability", "type": "esriFieldTypeString", "alias": "Structure Stability", "length": 5, "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" } }, { "name": "MaintenanceRecommendation", "type": "esriFieldTypeString", "alias": "Maintenance Recommendation", "length": 3, "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" } }, { "name": "SurveyDate", "type": "esriFieldTypeDate", "alias": "Survey Date", "length": 8, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Surveyor", "type": "esriFieldTypeString", "alias": "Surveyor", "length": 50, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 50, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Headworks.SDE.ELJs", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "ELJCode", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }