{ "currentVersion": 10.61, "id": 3, "name": "WildlandFire_Facility.DBO.FacilityTreatment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "EditName", "typeIdField": "Zone", "subtypeFieldName": "Zone", "subtypeField": "Zone", "defaultSubtypeCode": 0, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Treatment_ID", "type": "esriFieldTypeString", "alias": "Treatment_ID", "length": 50, "domain": null }, { "name": "Fire_Bldg_ID", "type": "esriFieldTypeString", "alias": "Fire_Bldg_ID", "length": 50, "domain": null }, { "name": "Community_ID", "type": "esriFieldTypeString", "alias": "Community_ID", "length": 50, "domain": null }, { "name": "NFPORS_TRT_ID", "type": "esriFieldTypeString", "alias": "NFPORS_TRT_ID", "length": 50, "domain": null }, { "name": "VisitType", "type": "esriFieldTypeString", "alias": "Site Visit Type", "length": 50, "domain": { "type": "codedValue", "name": "Treat_VisType", "description": "Site Visit Type", "codedValues": [ { "name": "Maintenance", "code": "Maintenance" }, { "name": "Active Incident", "code": "Incident" }, { "name": "Initial Assessment", "code": "Initial" }, { "name": "Site Visit", "code": "SiteVisit" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Zone", "type": "esriFieldTypeInteger", "alias": "Zone", "domain": null }, { "name": "Treatment", "type": "esriFieldTypeString", "alias": "Treatment", "length": 100, "domain": null }, { "name": "Pers_Hours", "type": "esriFieldTypeDouble", "alias": "Pers_Hours", "domain": null }, { "name": "Treat_Cycle", "type": "esriFieldTypeDouble", "alias": "Treatment Cycle", "domain": null }, { "name": "Treat_Units", "type": "esriFieldTypeString", "alias": "Treatment Units", "length": 50, "domain": { "type": "codedValue", "name": "Treat_Units", "description": "Treatment Cycle Units", "codedValues": [ { "name": "Day(s)", "code": "Day" }, { "name": "Week(s)", "code": "Week" }, { "name": "Month(s)", "code": "Month" }, { "name": "Year(s)", "code": "Year" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Date_Next", "type": "esriFieldTypeDate", "alias": "Date Next Treatment Recommended", "length": 8, "domain": null }, { "name": "Treat_Status", "type": "esriFieldTypeString", "alias": "Treat_Status", "length": 50, "domain": { "type": "codedValue", "name": "Treat_Status", "description": "Treament Status", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Planned", "code": "Planned" }, { "name": "Completed", "code": "Completed" }, { "name": "Initiated", "code": "Initiated" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Treat_Priority", "type": "esriFieldTypeString", "alias": "Treat_Priority", "length": 50, "domain": { "type": "codedValue", "name": "Treat_Priority", "description": "Treatment Priority", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Low", "code": "Low" }, { "name": "Medium", "code": "Medium" }, { "name": "High", "code": "High" }, { "name": "Critical", "code": "Critical" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Date_Implement", "type": "esriFieldTypeDate", "alias": "Date_Implement", "length": 8, "domain": null }, { "name": "Treat_Acres", "type": "esriFieldTypeDouble", "alias": "Treat_Acres", "domain": null }, { "name": "TreatDesc", "type": "esriFieldTypeString", "alias": "TreatDesc", "length": 3000, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "Date_Current", "length": 8, "domain": null }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R121_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_121", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4823Community_I", "fields": "Community_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4823Fire_Bldg_I", "fields": "Fire_Bldg_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G4823Treatment_I", "fields": "Treatment_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_121", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "VisitType": {"type": "inherited"}, "Treat_Units": {"type": "inherited"}, "Treat_Status": {"type": "inherited"}, "Treat_Priority": {"type": "inherited"} }, "id": 0, "name": "No treatment necessary" }, { "domains": { "VisitType": {"type": "inherited"}, "Treatment": { "type": "codedValue", "name": "Treat_Zone1", "description": "Treatment Zone 1", "codedValues": [ { "name": "Clear roof/gutters", "code": "ClearGutters" }, { "name": "Move firewood", "code": "MoveFirewood" }, { "name": "Clear ground cover", "code": "ClearGroundcover" }, { "name": "Clear deck", "code": "ClearDeck" }, { "name": "Limb trees", "code": "LimbTrees" }, { "name": "Open crown spacing", "code": "OpenCrownSpacing" }, { "name": "Clear adjacent and over hanging fuels", "code": "ClearAdjFuels" }, { "name": "Remove dead or dying fuels", "code": "RemoveFuels" }, { "name": "Mow grass", "code": "MowGrass" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "Treat_Units": {"type": "inherited"}, "Treat_Status": {"type": "inherited"}, "Treat_Priority": {"type": "inherited"} }, "id": 1, "name": "Zone 1" }, { "domains": { "VisitType": {"type": "inherited"}, "Treatment": { "type": "codedValue", "name": "Treat_Zone2", "description": "Treatment Zone 2", "codedValues": [ { "name": "Limb trees", "code": "LimbTrees" }, { "name": "Open crown spacing", "code": "CrownSpacing" }, { "name": "MowGrass", "code": "MowGrass" }, { "name": "Remove/isolate flamable ground cover", "code": "FlamableGroundCov" }, { "name": "Remove dead/dying fuels", "code": "RemoveFuels" }, { "name": "Move firewood 15ft horizontal from crowns", "code": "MoveFirewood" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "Treat_Units": {"type": "inherited"}, "Treat_Status": {"type": "inherited"}, "Treat_Priority": {"type": "inherited"} }, "id": 2, "name": "Zone 2" }, { "domains": { "VisitType": {"type": "inherited"}, "Treatment": { "type": "codedValue", "name": "Treat_Zone3", "description": "Treatment Zone 3", "codedValues": [ { "name": "Remove ground fuels", "code": "RemoveGroundFuels" }, { "name": "Remove dead/dying trees", "code": "RemoveDeadDying" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "Treat_Units": {"type": "inherited"}, "Treat_Status": {"type": "inherited"}, "Treat_Priority": {"type": "inherited"} }, "id": 3, "name": "Zone 3" }, { "domains": { "VisitType": {"type": "inherited"}, "Treatment": { "type": "codedValue", "name": "Treat_NoZone", "description": "Treatment not based on Firewise Zones", "codedValues": [ { "name": "Thinning", "code": "Thinning" }, { "name": "Pile Burning", "code": "PileBurn" }, { "name": "Burnout", "code": "Burnout" }, { "name": "Thinning and Burnout", "code": "ThinAndBurn" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "Treat_Units": {"type": "inherited"}, "Treat_Status": {"type": "inherited"}, "Treat_Priority": {"type": "inherited"} }, "id": 4, "name": "Not Available (AK)" } ], "subtypes": [ { "domains": { "VisitType": {"type": "inherited"}, "Treat_Units": {"type": "inherited"}, "Treat_Status": {"type": "inherited"}, "Treat_Priority": {"type": "inherited"} }, "defaultValues": { "Treatment_ID": null, "Fire_Bldg_ID": null, "Community_ID": null, "NFPORS_TRT_ID": null, "VisitType": null, "Zone": null, "Treatment": "None Needed", "Pers_Hours": null, "Treat_Cycle": null, "Treat_Units": null, "Date_Next": null, "Treat_Status": null, "Treat_Priority": null, "Date_Implement": null, "Treat_Acres": null, "TreatDesc": null, "EditName": null, "EditDate": null, "CreateName": null, "CreateDate": null, "GlobalID": null, "CP_EditName": null, "CP_EditDate": null, "CP_PROJECT_ID": null, "BUNDLE_ID": null, "BUNDLE_TYPE": null }, "code": 0, "name": "No treatment necessary" }, { "domains": { "VisitType": {"type": "inherited"}, "Treatment": { "type": "codedValue", "name": "Treat_Zone1", "description": "Treatment Zone 1", "codedValues": [ { "name": "Clear roof/gutters", "code": "ClearGutters" }, { "name": "Move firewood", "code": "MoveFirewood" }, { "name": "Clear ground cover", "code": "ClearGroundcover" }, { "name": "Clear deck", "code": "ClearDeck" }, { "name": "Limb trees", "code": "LimbTrees" }, { "name": "Open crown spacing", "code": "OpenCrownSpacing" }, { "name": "Clear adjacent and over hanging fuels", "code": "ClearAdjFuels" }, { "name": "Remove dead or dying fuels", "code": "RemoveFuels" }, { "name": "Mow grass", "code": "MowGrass" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "Treat_Units": {"type": "inherited"}, "Treat_Status": {"type": "inherited"}, "Treat_Priority": {"type": "inherited"} }, "defaultValues": { "Treatment_ID": null, "Fire_Bldg_ID": null, "Community_ID": null, "NFPORS_TRT_ID": null, "VisitType": null, "Zone": null, "Treatment": null, "Pers_Hours": null, "Treat_Cycle": null, "Treat_Units": null, "Date_Next": null, "Treat_Status": null, "Treat_Priority": null, "Date_Implement": null, "Treat_Acres": null, "TreatDesc": null, "EditName": null, "EditDate": null, "CreateName": null, "CreateDate": null, "GlobalID": null, "CP_EditName": null, "CP_EditDate": null, "CP_PROJECT_ID": null, "BUNDLE_ID": null, "BUNDLE_TYPE": null }, "code": 1, "name": "Zone 1" }, { "domains": { "VisitType": {"type": "inherited"}, "Treatment": { "type": "codedValue", "name": "Treat_Zone2", "description": "Treatment Zone 2", "codedValues": [ { "name": "Limb trees", "code": "LimbTrees" }, { "name": "Open crown spacing", "code": "CrownSpacing" }, { "name": "MowGrass", "code": "MowGrass" }, { "name": "Remove/isolate flamable ground cover", "code": "FlamableGroundCov" }, { "name": "Remove dead/dying fuels", "code": "RemoveFuels" }, { "name": "Move firewood 15ft horizontal from crowns", "code": "MoveFirewood" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "Treat_Units": {"type": "inherited"}, "Treat_Status": {"type": "inherited"}, "Treat_Priority": {"type": "inherited"} }, "defaultValues": { "Treatment_ID": null, "Fire_Bldg_ID": null, "Community_ID": null, "NFPORS_TRT_ID": null, "VisitType": null, "Zone": null, "Treatment": null, "Pers_Hours": null, "Treat_Cycle": null, "Treat_Units": null, "Date_Next": null, "Treat_Status": null, "Treat_Priority": null, "Date_Implement": null, "Treat_Acres": null, "TreatDesc": null, "EditName": null, "EditDate": null, "CreateName": null, "CreateDate": null, "GlobalID": null, "CP_EditName": null, "CP_EditDate": null, "CP_PROJECT_ID": null, "BUNDLE_ID": null, "BUNDLE_TYPE": null }, "code": 2, "name": "Zone 2" }, { "domains": { "VisitType": {"type": "inherited"}, "Treatment": { "type": "codedValue", "name": "Treat_Zone3", "description": "Treatment Zone 3", "codedValues": [ { "name": "Remove ground fuels", "code": "RemoveGroundFuels" }, { "name": "Remove dead/dying trees", "code": "RemoveDeadDying" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "Treat_Units": {"type": "inherited"}, "Treat_Status": {"type": "inherited"}, "Treat_Priority": {"type": "inherited"} }, "defaultValues": { "Treatment_ID": null, "Fire_Bldg_ID": null, "Community_ID": null, "NFPORS_TRT_ID": null, "VisitType": null, "Zone": null, "Treatment": null, "Pers_Hours": null, "Treat_Cycle": null, "Treat_Units": null, "Date_Next": null, "Treat_Status": null, "Treat_Priority": null, "Date_Implement": null, "Treat_Acres": null, "TreatDesc": null, "EditName": null, "EditDate": null, "CreateName": null, "CreateDate": null, "GlobalID": null, "CP_EditName": null, "CP_EditDate": null, "CP_PROJECT_ID": null, "BUNDLE_ID": null, "BUNDLE_TYPE": null }, "code": 3, "name": "Zone 3" }, { "domains": { "VisitType": {"type": "inherited"}, "Treatment": { "type": "codedValue", "name": "Treat_NoZone", "description": "Treatment not based on Firewise Zones", "codedValues": [ { "name": "Thinning", "code": "Thinning" }, { "name": "Pile Burning", "code": "PileBurn" }, { "name": "Burnout", "code": "Burnout" }, { "name": "Thinning and Burnout", "code": "ThinAndBurn" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "Treat_Units": {"type": "inherited"}, "Treat_Status": {"type": "inherited"}, "Treat_Priority": {"type": "inherited"} }, "defaultValues": { "Treatment_ID": null, "Fire_Bldg_ID": null, "Community_ID": null, "NFPORS_TRT_ID": null, "VisitType": null, "Zone": null, "Treatment": null, "Pers_Hours": null, "Treat_Cycle": null, "Treat_Units": null, "Date_Next": null, "Treat_Status": null, "Treat_Priority": null, "Date_Implement": null, "Treat_Acres": null, "TreatDesc": null, "EditName": null, "EditDate": null, "CreateName": null, "CreateDate": null, "GlobalID": null, "CP_EditName": null, "CP_EditDate": null, "CP_PROJECT_ID": null, "BUNDLE_ID": null, "BUNDLE_TYPE": null }, "code": 4, "name": "Not Available (AK)" } ], "relationships": [ { "id": 4, "name": "Community", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "Community_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "Facility", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Fire_Bldg_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }