{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 2, "name": "Related Prescribed Fire Details Table", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "GIS.GIS.Treatment_Area", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "FIRE_AREA_GLOBALID", "composite": false, "catalogID": "{143B1ADD-0085-40A1-847F-EF3168F5D48A}" }, { "id": 1, "name": "GIS.GIS.Treatment_Area", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "FIRE_AREA_GLOBALID", "composite": false, "catalogID": "{143B1ADD-0085-40A1-847F-EF3168F5D48A}" } ], "isDataVersioned": true, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": true, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1619012005000 }, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FIRE_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "FIRE_AREA_GLOBALID", "type": "esriFieldTypeGUID", "alias": "FIRE AREA GLOBAL ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "FIRE_AREA_GLOBALID" }, { "name": "FIRE_NAME", "type": "esriFieldTypeString", "alias": "FIRE NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FIRE_NAME" }, { "name": "BURN_PLAN_NUM", "type": "esriFieldTypeString", "alias": "BURN PLAN NUMBER", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "BURN_PLAN_NUM" }, { "name": "PLAN_APPROVE_DT", "type": "esriFieldTypeDate", "alias": "PLAN APPROVED DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PLAN_APPROVE_DT" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": { "type": "codedValue", "name": "Plan_Status", "description": "Fire plan status", "codedValues": [ { "name": "Completed", "code": "C" }, { "name": "Planned", "code": "P" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "P", "modelName": "STATUS" }, { "name": "DATE_BURNED", "type": "esriFieldTypeDate", "alias": "DATE BURNED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_BURNED" }, { "name": "COMPLEXITY", "type": "esriFieldTypeString", "alias": "COMPLEXITY", "domain": { "type": "codedValue", "name": "Complexity", "description": "fire plan complexity", "codedValues": [ { "name": "High", "code": "H" }, { "name": "Low", "code": "l" }, { "name": "Moderate", "code": "M" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "COMPLEXITY" }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "PRIORITY", "domain": { "type": "codedValue", "name": "Y/N", "description": "Yes / No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "PRIORITY" }, { "name": "PROPERTY_NAME", "type": "esriFieldTypeString", "alias": "PROPERTY NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PROPERTY_NAME" }, { "name": "PROPERTY_OWNER", "type": "esriFieldTypeString", "alias": "PROPERTY OWNER", "domain": { "type": "codedValue", "name": "Property Owner", "description": "Propery Owner fire plan", "codedValues": [ { "name": "DCNR", "code": "DNR" }, { "name": "Cooperator", "code": "HAC" }, { "name": "Inter- Agency", "code": "IA" }, { "name": "PGC", "code": "PGC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "PROPERTY_OWNER" }, { "name": "BURN_OBJ_NOTES", "type": "esriFieldTypeString", "alias": "BURN OBJECTIVE NOTES", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BURN_OBJ_NOTES" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NOTES" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user", "required": true }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date", "required": true }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user", "required": true }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "AREA_REVIEW", "type": "esriFieldTypeString", "alias": "AREA REVIEW", "domain": { "type": "codedValue", "name": "Y/N", "description": "Yes / No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "AREA_REVIEW" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ACTIVITY_CODE", "type": "esriFieldTypeSmallInteger", "alias": "ACTIVITY_CODE", "domain": { "type": "codedValue", "name": "Prescribed_Fire_Activity_Codes", "description": "Prescribed_Fire_Activity_Codes", "codedValues": [ { "name": "114 - Prescribed Burn Field Training", "code": 114 }, { "name": "514 - Prescribed Burning (Forestland)", "code": 514 }, { "name": "516 - Prescribed Burning, Unit Preparation", "code": 516 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACTIVITY_CODE" }, { "name": "TREATMENT", "type": "esriFieldTypeString", "alias": "TREATMENT", "domain": { "type": "codedValue", "name": "Fire_Treatment_Types", "description": "Fire_Treatment_Types", "codedValues": [ { "name": "Interfering Plant Control (IPC)", "code": "IPC" }, { "name": "Low-Shade Removal (LSR)", "code": "LSR" }, { "name": "Fuel Management (FM)", "code": "FM" }, { "name": "Multiple (MLT) See Notes", "code": "MLT" }, { "name": "Site Preparation (SP)", "code": "SP" }, { "name": "Thatch Reduction (TR)", "code": "TR" }, { "name": "Herbaceous Woody Encroachment Control (WEC)", "code": "WEC" }, { "name": "Shrub Rejuvenation (SR)", "code": "SR" }, { "name": "Increase / Maintain Herbaceous Plants (IHP)", "code": "IHP" }, { "name": "Forest Resiliency (FR)", "code": "FR" }, { "name": "Data Not Entered", "code": "-1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "-1", "modelName": "TREATMENT" }, { "name": "METHOD", "type": "esriFieldTypeString", "alias": "METHOD", "domain": { "type": "codedValue", "name": "Fire_Methods", "description": "Fire_Methods", "codedValues": [ { "name": "Hand Ignition", "code": "HI" }, { "name": "Aerial Ignition (Helicopter)", "code": "AH" }, { "name": "Aerial Ignition (Drone)", "code": "AD" }, { "name": "Managed Wildfire", "code": "MW" }, { "name": "Data Not Entered", "code": "-1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 2, "defaultValue": "-1", "modelName": "METHOD" }, { "name": "FUNDING", "type": "esriFieldTypeString", "alias": "FUNDING", "domain": { "type": "codedValue", "name": "Treatment_Funding", "description": "Treatment Funding", "codedValues": [ { "name": "Pittman-Roberts", "code": "PR" }, { "name": "Game Fund", "code": "GF" }, { "name": "Land and Water Fund", "code": "W" }, { "name": "Exchange", "code": "EX" }, { "name": "Donation", "code": "D" }, { "name": "State Wildlife Grant", "code": "SW" }, { "name": "HUD", "code": "HU" }, { "name": "Other", "code": "O" }, { "name": "Unknown", "code": "U" }, { "name": "Data Not Entered", "code": "-1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "-1", "modelName": "FUNDING" }, { "name": "sgl", "type": "esriFieldTypeInteger", "alias": "SGL", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sgl" }, { "name": "pgc_region", "type": "esriFieldTypeSmallInteger", "alias": "PGC Region", "domain": { "type": "codedValue", "name": "Region_No_7", "description": "Regions", "codedValues": [ { "name": "Northwest Region", "code": 1 }, { "name": "Southwest Region", "code": 2 }, { "name": "Northcentral Region", "code": 3 }, { "name": "Southcentral Region", "code": 4 }, { "name": "Northeast Region", "code": 5 }, { "name": "Southeast Region", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pgc_region" }, { "name": "burn_unit_name", "type": "esriFieldTypeString", "alias": "Burn Unit Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "burn_unit_name" }, { "name": "coverage_type", "type": "esriFieldTypeString", "alias": "Coverage Type", "domain": { "type": "codedValue", "name": "Coverage Type", "description": "Coverage type for habitat treatments", "codedValues": [ { "name": "Full", "code": "Full" }, { "name": "Spot", "code": "Spot" }, { "name": "Random", "code": "Random" }, { "name": "Systematic", "code": "Systematic" }, { "name": "Striped", "code": "Striped" }, { "name": "Clustered", "code": "Clustered" }, { "name": "Perimeter", "code": "Perimeter" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "coverage_type" }, { "name": "coverage_extent", "type": "esriFieldTypeString", "alias": "Coverage Extent", "domain": { "type": "codedValue", "name": "Coverage Extent", "description": "Coverage extent for habitat treatments", "codedValues": [ { "name": "Minimal (<20%)", "code": "Minimal" }, { "name": "Partial (>20%)", "code": "Partial" }, { "name": "Around Half (>40%)", "code": "Around Half" }, { "name": "Majority (>60%)", "code": "Majority" }, { "name": "Near Complete (>80%)", "code": "Near Complete" }, { "name": "Complete (100%)", "code": "Complete" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "coverage_extent" }, { "name": "habitat_type", "type": "esriFieldTypeString", "alias": "Habitat Type", "domain": { "type": "codedValue", "name": "Fire Habitat Type", "description": "Habitat types for prescribed fire", "codedValues": [ { "name": "Woody", "code": "Woody" }, { "name": "Grass", "code": "Grass" }, { "name": "Woody and Grass", "code": "Woody and Grass" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "habitat_type" } ], "indexes": [ { "name": "UUID_38", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R38_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G96FIRE_AREA_GLO", "fields": "FIRE_AREA_GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Related Prescribed Fire Details Table", "description": "", "prototype": { "attributes": { "coverage_extent": null, "FIRE_AREA_GLOBALID": null, "FIRE_NAME": null, "BURN_PLAN_NUM": null, "PLAN_APPROVE_DT": null, "STATUS": "P", "DATE_BURNED": null, "COMPLEXITY": null, "PRIORITY": "N", "PROPERTY_NAME": null, "PROPERTY_OWNER": null, "BURN_OBJ_NOTES": null, "NOTES": null, "coverage_type": null, "burn_unit_name": null, "pgc_region": null, "sgl": null, "habitat_type": null, "AREA_REVIEW": "N", "ACTIVITY_CODE": null, "TREATMENT": "-1", "METHOD": "-1", "FUNDING": "-1" } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,ChangeTracking", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "userTypeExtensions": [ "advancedEditing" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "e8720e331c49458dbadcee5051051f30" }