Geodatabase Documentation
Date: Wednesday, February 3, 2021
Time: 6:37:47 PM

Summary Information and Links

6 Feature Datasets and 42 Feature Classes
No Topology Datasets
No Geometric Networks
No Rasters
14 Tables (Object Classes)
No Relationship Classes
67 Domains


Feature Datasets and Child Classes

SCE_AssetLine - Feature Dataset

SCE_PrimaryDistributionLine_20210501 - Simple
SCE_SecondaryDistributionLine_20210501 - Simple
SCE_TransmissionLine_20210501 - Simple


SCE_AssetPoint - Feature Dataset

SCE_Camera_20210501 - Simple
SCE_ConnectionDevice_20210501 - Simple
SCE_CustomerMeter_20210501 - Simple
SCE_Fuse_20210501 - Simple
SCE_LightingArrester_20210501 - Simple
SCE_Substation_20210501 - Simple
SCE_SupportStructure_20210501 - Simple
SCE_Switchgear_20210501 - Simple
SCE_TransformerSite_20210501 - Simple
SCE_WeatherStation_20210501 - Simple


SCE_Initiative - Feature Dataset

SCE_AssetInspectionLine_20210501 - Simple
SCE_AssetInspectionPoint_20210501 - Simple
SCE_AssetInspectionPolygon_20210501 - Simple
SCE_GridHardeningLine_20210501 - Simple
SCE_GridHardeningPoint_20210501 - Simple
SCE_OtherInitiativeLine_20210501 - Simple
SCE_OtherInitiativePoint_20210501 - Simple
SCE_OtherInitiativePolygon_20210501 - Simple
SCE_VegetationInspectionLine_20210501 - Simple
SCE_VegetationInspectionPoint_20210501 - Simple
SCE_VegetationInspectionPolygon_20210501 - Simple
SCE_VegetationManagementProjectLine_20210501 - Simple
SCE_VegetationManagementProjectPoint_20210501 - Simple
SCE_VegetationManagementProjectPolygon_20210501 - Simple


SCE_OtherRequiredData - Feature Dataset

SCE_AdministrativeArea_20210501 - Simple
SCE_CriticalFacility_20210501 - Simple
SCE_MajorWoodyStemExemptTreePoint_20210501 - Simple
SCE_OtherPowerLineConnectionLocation_20210501 - Simple
SCE_RedFlagWarningDayPolygon_20210501 - Simple


SCE_PspsEvent - Feature Dataset

SCE_PspsEventCustomerMeterPoint_20210501 - Simple
SCE_PspsEventDamagePoint_20210501 - Simple
SCE_PspsEventLine_20210501 - Simple
SCE_PspsEventPolygon_20210501 - Simple


SCE_RiskEvent - Feature Dataset

SCE_DistributionUnplannedOutage_20210501 - Simple
SCE_DistributionVegetationCausedUnplannedOutage_20210501 - Simple
SCE_Ignition_20210501 - Simple
SCE_TransmissionUnplannedOutage_20210501 - Simple
SCE_TransmissionVegetationCausedUnplannedOutage_20210501 - Simple
SCE_WireDownEvent_20210501 - Simple


Rasters



Workspace-Level Tables and Feature Classes

SCE_AssetInspectionLog_20210501 - Table
SCE_GridHardeningLog_20210501 - Table
SCE_InitiativePhotoLog_20210501 - Table
SCE_OtherInitiativeLog_20210501 - Table
SCE_PspsEventConductorDamageDetail_20210501 - Table
SCE_PspsEventDamagePhotoLog_20210501 - Table
SCE_PspsEventLog_20210501 - Table
SCE_PspsEventOtherAssetDamageDetail_20210501 - Table
SCE_PspsEventSupportStructureDamageDetail_20210501 - Table
SCE_RiskEventAssetLog_20210501 - Table
SCE_RiskEventPhotoLog_20210501 - Table
SCE_TransformerDetail_20210501 - Table
SCE_VegetationInspectionLog_20210501 - Table
SCE_VegetationManagementProjectLog_20210501 - Table



Relationship Classes



Domains

DomAssetClass
DomAssetType
DomBackupType
DomCause
DomCircuitType
DomConductorMaterial
DomConductorType
DomConductorTypeSecondary
DomConnectionDeviceSubtype
DomConnectionDeviceType
DomConnectionOhUg
DomConnectionType
DomConstructionGrade
DomContributingFactor
DomDamageDescription
DomDamageType
DomDetermination
DomEquipmentFailure
DomEquipmentType
DomEstimatedAge
DomFacilityCategory
DomFacilityContacted
DomFireDetectionMethod
DomFireInvestigation
DomFireResponsibility
DomFireSize
DomFuelBedDescription
DomFuseType
DomGhChangeOrderType
DomHFTD
DomInitiativeCategory1
DomInitiativeCategory2
DomInspectionMethod
DomInspectionTechnology
DomInspectionType
DomIsolationDevice
DomLandUse
DomLineClass
DomMaterialAtOrigin
DomObjectContact
DomOhUg
DomOtherAssetDamageDescription
DomOutageInterval
DomPerformedBy
DomPspsAsset
DomPspsIsolationDevice
DomPspsOtherAsset
DomRecloserSetting
DomSlashManagement
DomSpeciesGrowthRate
DomStatus
DomSubareaType
DomSubstationType
DomSupportStructureDamageDescription
DomSupportStructureMaterial
DomSupportStructureType
DomSuppressedBy
DomTransformerSubtype
DomTreeDiameter
DomTreeHeight
DomVegTreatmentType
DomVmInspectionType
DomWoodDestination
DomYesNo
DomYesNoNA
DomYesNoUnknown
DomYesNoUnknownNA



SCE_AssetLine - FeatureDataset

NameSCE_AssetLine
DescriptionSCE_AssetLine

SCE_PrimaryDistributionLine_20210501 - FeatureClass

NameSCE_PrimaryDistributionLine_20210501
ShapeTypePolyline
FeatureTypeSimple
AliasNameSCE Primary Distribution Line 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_PrimaryDistributionLine_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
CircuitIDString50Circuit IDUnique ID for a specific circuit. It should be a traceable stable ID within the utility’s operations/processes.true
UtilityIDString30Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation feature class attribute table.true
LineClassString30Line ClassClassification of line asset. Required value: Primary distributionDomLineClasstrue
CircuitNameString255Circuit NameName of circuit associated with asset. Leave blank or enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
CountyString150CountyCounty in which asset is located. If the line crosses multiple counties, list all counties separated by commas.true
ConductorTypeString30Conductor TypeType of conductor. Possible values: Bare, Covered, Other - See comment.DomConductorTypetrue
ConductorTypeCommentString30Conductor Type CommentConductor type not listed in the options above.true
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, Unknown.DomOhUgtrue
NominalVoltagekVSingle4Nominal Voltage (kV)Nominal voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
OperatingVoltagekVSingle4Operating Voltage (kV)Operating voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
SubstationNameString50Substation NameName of substation associated with asset.true
ConductorMaterialString50Conductor MaterialConductor material. Possible values: All aluminum conductor (AAC), All aluminum alloy conductor (AAAC), Aluminum conductor aluminum reinforced (ACAR), Aluminum conductor steel reinforced (ACSR), Aluminum conductor steel supportes (ACSS), Copper (Cu), Other – See comment.DomConductorMaterialtrue
ConductorMaterialCommentString50Conductor Material CommentConductor material not listed in the options above.true
ConductorSizeString30Conductor SizeSize of conductor (e.g. No. 4 Cu or 1/0 ACSR).true
ConductorODSingle4Conductor Overall Diameter (inches)Overall diameter of the conductor in inches.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Leave blank if unknown.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Leave blank if unknown.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Note: Only enter "N/A" if there is an "InstallationDate" value or "InstallationYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.”true
AmpacityRatingSingle4Ampacity Rating (A)Nominal ampacity rating of the conductor in amperes.true
GreasedString10GreasedIs the conductor greased to prevent water intrusion? Possible values: Yes, No, Unknown.DomYesNoUnknowntrue


SCE_SecondaryDistributionLine_20210501 - FeatureClass

NameSCE_SecondaryDistributionLine_20210501
ShapeTypePolyline
FeatureTypeSimple
AliasNameSCE Secondary Distribution Line 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_SecondaryDistributionLine_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
CircuitIDString50Circuit IDUnique ID for a specific circuit. It should be a traceable stable ID within the utility’s operations/processes. This ID is expected to be based on the circuit name of the secondary line’s associated primary distribution line.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation feature class attribute table.true
LineClassString30Line ClassClassification of line asset. Required value: Secondary distributionDomLineClasstrue
CircuitNameString255Circuit NameName of circuit associated with asset. This name is expected to be based on the circuit name of the secondary line’s associated primary distribution line. Leave blank or enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
CountyString150CountyCounty in which asset is located. If the line crosses multiple counties, list all counties separated by commas.true
ConductorTypeString30Conductor TypeType of conductor. Possible values:Open wire, Duplex, Triplex, Quadruplex, Other – See comment.DomConductorTypeSecondarytrue
ConductorTypeCommentString30Conductor Type CommentConductor type not listed in the options above.true
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, Unknown.DomOhUgtrue
NominalVoltagekVString10Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
OperatingVoltagekVString10Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
SubstationNameString50Substation NameName of substation associated with asset.true
ConductorMaterialString50Conductor MaterialConductor material. Possible values: All aluminum conductor (AAC), All aluminum alloy conductor (AAAC), Aluminum conductor aluminum reinforced (ACAR), Aluminum conductor steel reinforced (ACSR), Aluminum conductor steel supportes (ACSS), Copper (Cu), Other – See comment.DomConductorMaterialtrue
ConductorMaterialCommentString50Conductor Material CommentConductor material not listed in the options above.true
ConductorSizeString30Conductor SizeSize of conductor (e.g. No. 4 Cu or 1/0 ACSR).true
ConductorODSingle4Conductor Overall Diameter (inches)Overall diameter of the conductor in inches.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Leave blank if unknown.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Leave blank if unknown.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Note: Only enter "N/A" if there is an "InstallationDate" value or "InstallationYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
AmpacityRatingSingle4Ampacity Rating (A)Nominal ampacity rating of the conductor, in amperes).true
GreasedString10GreasedIs the conductor greased to prevent water intrusion? Possible values: Yes, No, Unknown.DomYesNoUnknowntrue


SCE_TransmissionLine_20210501 - FeatureClass

NameSCE_TransmissionLine_20210501
ShapeTypePolyline
FeatureTypeSimple
AliasNameSCE Transmission Line 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_TransmissionLine_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
CircuitIDString50Circuit IDUnique ID for a specific circuit. It should be a traceable stable ID within the utility’s operations/processes.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation feature class attribute table.true
LineClassString30Line ClassClassification of line asset. Possible values: Transmission, Sub-transmission.DomLineClasstrue
CircuitNameString255Circuit NameName of circuit associated with asset. Enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
CountyString150CountyCounty in which asset is located. If the line crosses multiple counties, list all counties separated by commas.true
ConductorTypeString30Conductor TypeType of conductor. Possible values: Bare, Covered, Other - See comment.DomConductorTypetrue
ConductorTypeCommentString30Conductor Type CommentConductor type not listed in the options above.true
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, Unknown.DomOhUgtrue
NominalVoltagekVSingle4Nominal Voltage (kV)Nominal voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
OperatingVoltagekVSingle4Operating Voltage (kV)Operating voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
SubstationNameString50Substation NameName of substation associated with asset.true
ConductorMaterialString50Conductor MaterialConductor material. Possible values: All aluminum conductor (AAC), All aluminum alloy conductor (AAAC), Aluminum conductor aluminum reinforced (ACAR), Aluminum conductor steel reinforced (ACSR), Aluminum conductor steel supportes (ACSS), Copper (Cu), Other – See comment.DomConductorMaterialtrue
ConductorMaterialCommentString50Conductor Material CommentConductor material not listed in the options above.true
ConductorSizeString30Conductor SizeConductorSizetrue
ConductorODSingle4Conductor Overall Diameter (inches)Overall diameter of the conductor in inches.true
Terminal1String50Terminal 1Substation name of first terminal.true
Terminal2String50Terminal 2Substation name of second terminal.true
Terminal3String50Terminal 3Substation name of third terminal.true
Terminal4String50Terminal 4Substation name of fourth terminal.true
Terminal5String50Terminal 5Substation name of fifth terminal.true
TerminalsString50TerminalsTerminalstrue
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Leave blank if unknown.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Leave blank if unknown.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Note: Only enter "N/A" if there is an "InstallationDate" value or "InstallationYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.”true
AmpacityRatingSingle4Ampacity Rating (A)Nominal ampacity rating of the conductor in amperes.true
GreasedString10GreasedIs the conductor greased to prevent water intrusion? Possible values: Yes, No, Unknown.DomYesNoUnknowntrue



SCE_AssetPoint - FeatureDataset

NameSCE_AssetPoint
DescriptionSCE_AssetPoint

SCE_Camera_20210501 - FeatureClass

NameSCE_Camera_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Camera 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_Camera_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique ID for a specific camera. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Camera feature class attribute table.true
SupportStructureIDString50Support Structure IDUnique ID for support structure to which the camera is attached. It should be a traceable stable ID within the utility’s operations/processes.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., "UtilityG+E").true
AssetTypeString50Asset TypeType of point asset. Required value: CameraDomAssetTypetrue
CameraLocationNameString30Camera Location NameUnique name of cameras location (e.g. “Cisco Buttes 1”, “Penn Valley”). For Alert Wildfire camers, this should match the name on the website.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which asset is located.true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true
AssetLongitudeSingle4Asset LongitudeLatitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true


SCE_ConnectionDevice_20210501 - FeatureClass

NameSCE_ConnectionDevice_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE ConnectionDevice 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_ConnectionDevice_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique ID for a specific connection device. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Connection Device feature class attribute table.true
FromStructureIDString50From Structure IDID of the structure upstream of the span of line containing a connection device. This structure may be a support structure (e.g., pole or tower) if the span is overhead, and it may be something else (e.g., manhole, vault, etc.) if the span is underground. Foreign key to the Support Structure feature class attribute table.true
ToStructureIDString50To Structure IDID of the structure downstream of the span of line containing a connection device. This structure may be a support structure (e.g., pole or tower) if the span is overhead, and it may be something else (e.g., manhole, vault, etc.) if the span is underground. Foreign key to the Support Structure feature class attribute table.true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line feature class attribute tables.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
AssetTypeString50Asset TypeType of point asset. Required value: Line connection deviceDomAssetTypetrue
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, Unknown.DomOhUgtrue
ConnectionDeviceTypeString30Connection Device TypeWhat type of connection device is the asset? Possible values: Splice, Connector, Clamp, Unknown, Other - See comment.DomConnectionDeviceTypetrue
ConnectionDeviceTypeCommentString30Connection Device Type CommentConnection device type not listed in the options above.true
ConnectionDeviceSubtypeString30Connection Device SubtypeWhat is the specific subtype of the connection device? Automatic splice, Crimp splice, Explosive sleeve splice (i.e., permanent, fused), 3-bolt, Parallel groove, Unknown, Other – See comment.DomConnectionDeviceSubtypetrue
ConnectionDeviceSubtypeCommentString30Connection Device Subtype CommentConnection device subtype not listed in the options above.true
AssociatedNominalVoltagekVString10Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
AssociatedOperatingVoltagekVString10Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
CircuitNameString255Circuit NameName of circuit associated with asset. Leave blank or enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
SubstationNameString50Substation NameName of substation associated with asset.true
ManufacturerString50ManufacturerName of the manufacturer of the connection device. Do not use acronyms or abbreviations for this field. Fully spell out the manufacturer name. Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Leave blank if unknown.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Note: Only enter "N/A" if there is an "InstallationDate" value or "InstallationYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter "-99."true
ExemptionStatusString10Exemption StatusIs the asset exempt per California Public Resources Code (PRC) 4292? This field is especially important and a high priority for the WSD and the State of California. Non-exempt equipment requires support structure clearance. Possible values: Yes, No, Unknown, N/A.DomYesNoUnknownNAtrue
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true


SCE_CustomerMeter_20210501 - FeatureClass

NameSCE_CustomerMeter_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Customer Meter 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_CustomerMeter_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
MeterIDString50Meter IDUnique ID for a specific meter. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Customer Meter feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line feature class attribute tables.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation feature class attribute table.true
AssetTypeString50Asset TypeType of point asset. Required value: Customer meterDomAssetTypetrue
CircuitNameString255Circuit NameName of circuit associated with asset. Leave blank or enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
SubstationNameString30Substation NameName of substation associated with asset.true
ManufacturerString50ManufacturerName of the manufacturer of the meter. Do not use acronyms or abbreviations for this field. Fully spell out the manufacturer name. Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which asset is located.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Note: Only enter "N/A" if there is an "InstallationDate" value or "InstallationYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true


SCE_Fuse_20210501 - FeatureClass

NameSCE_Fuse_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Fuse 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_Fuse_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique ID for a specific fuse. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Fuse feature class attribute table.true
SupportStructureIDString50Support Structure IDUnique ID for support structure to which fuse is attached. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the Support Structure feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation feature class attribute table.true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line feature class attribute tables.true
AssetTypeString50Asset TypeType of point asset: Required value: FuseDomAssetTypetrue
AssociatedNominalVoltagekVString10Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
AssociatedOperatingVoltagekVString10AssociatedOperatingVoltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
SubstationNameString50Substation NameName of substation associated with asset.true
CircuitNameString255Circuit NameName of circuit associated with asset. Leave blank or enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
ManufacturerString50ManufacturerName of the manufacturer of the fuse. Do not use acronyms or abbreviations for this field. Fully spell out the manufacturer name. Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Leave blank if unknown.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Leave blank if unknown.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Note: Only enter "N/A" if there is an "InstallationDate" value or "InstallationYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.”true
ExemptionStatusString10Exemption StatusIs the asset exempt per California Public Resources Code (PRC) 4292? This field is especially important and a high priority for the WSD and the State of California. Non-exempt equipment requires support structure clearance. Possible values: Yes, No, Unknown, N/A.DomYesNoUnknownNAtrue
FuseRatingSingle4Fuse Rating (A)The nominal current rating of the fuse in amperes.true
FuseTypeString30Fuse TypeType of fuse device. Possible values: Bridged, Current limiting, Expulsion, Fused elbow, Unknown, Other – See comment.DomFuseTypetrue
FuseTypeCommentString50Fuse Type CommentFuse type not listed in the options above.true
FuseSubtypeString30Fuse SubtypeWhat is the specific subtype of the fuse device?true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true


SCE_LightingArrester_20210501 - FeatureClass

NameSCE_LightingArrester_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Lighting Arrester 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_LightingArrester_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique ID for a specific lightning arrester. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Lighting Arrester feature class attribute table.true
SupportStructureIDString50Support Structure IDUnique ID for support structure to which lightning arrester is attached. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the Support Structure feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation feature class attribute table.true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line feature class attribute tables.true
AssetTypeString50Asset TypeType of point asset. Required value: Lightning arresterDomAssetTypetrue
AssociatedNominalVoltagekVString10Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
AssociatedOperatingVoltagekVString10Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
SubstationNameString50Substation NameName of substation associated with asset.true
CircuitNameString255Circuit NameName of circuit associated with asset. Leave blank or enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
ManufacturerString50ManufacturerName of the manufacturer of the lightning arrester. Do not use acronyms or abbreviations for this field. Fully spell out the manufacturer name. Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Leave blank if unknown.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Leave blank if unknown.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Note: Only enter "N/A" if there is an "InstallationDate" value or "InstallationYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.”true
ExemptionStatusString10Exemption StatusIs the asset exempt per California Public Resources Code (PRC) 4292? This field is especially important and a high priority for the WSD and the State of California. Non-exempt equipment requires support structure clearance. Possible values: Yes, No, Unknown, N/A.DomYesNoUnknownNAtrue
ArresterRatingSingle4Arrester Rating (kV)Rating of the lightning arrester in kilovolts.true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true


SCE_Substation_20210501 - FeatureClass

NameSCE_Substation_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Substation 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_Substation_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
SubstationIDString50Substation IDID of substation associated with asset. Primary key for the Substation feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
AssetTypeString50Asset TypeType of point asset. Required value: SubstationDomAssetTypetrue
SubstationNameString50Substation NameName of substation.true
SubstationNominalVoltagekVString10Substation Nominal Voltage (kV)Nominal voltage (in kilovolts) ratings associated with the substation. Include all applicable voltages separated by slashes (e.g., “230/139/69/12”). Ranges are also acceptable (e.g. “0-60”). Enter “-99” if N/A.true
SubstationOperatingVoltagekVString10Substation Operating Voltage (kV)Operating voltage (in kilovolts) ratings associated with the substation. Include all applicable voltages separated by slashes (e.g., “230/139/69/12”). Ranges are also acceptable (e.g. “0-60”). Enter “-99” if N/A.true
SubstationRatingSingle4Substation RatingPower rating of the substation in Megavolt-amperes (MVAs).true
SubstationTypeString10Substation TypeType of substation. Possible values: Network, Loop, Radial.DomSubstationTypetrue
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Leave blank if unknown.true
InstallationDateDate8Installation DateDate the first asset of the substation was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true


SCE_SupportStructure_20210501 - FeatureClass

NameSCE_SupportStructure_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Support Structure 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_SupportStructure_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
SupportStructureIDString50Support Structure IDUnique ID for support structure. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Support Structure feature class attribute table. Enables connection to the Fuse, Lightning Arrester, Switchgear, and Transformer feature class attribute tables.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation feature class attribute table.true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line feature class attribute tables.true
AssetTypeString50Asset TypeType of point asset. Required value: Support structureDomAssetTypetrue
ExemptionStatusString10Exemption StatusDoes the support structure hold equipment that is exempt from Public Resource Code (PRC) 4292 vegetation clearance requirements? This field is especially important and a high priority for the WSD and the State of California. Non-exempt equipment requires support structure clearance. Possible values: Yes, No, Unknown, N/A.DomYesNoUnknownNAtrue
CircuitNameString255CircuitNameName of circuit associated with asset. Leave blank or enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Leave blank if unknown.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Leave blank if unknown.true
LastIntrusiveDateDate8Last Intrusive DateDate of the last intrusive. Leave blank if unknown.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Note: Only enter "N/A" if there is an "InstallationDate" value or "InstallationYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.”true
SupportStructureTypeString30Support Structure TypeType of support structure. Possible values: Pole, Tower, Other – See comment.DomSupportStructureTypetrue
SupportStructureTypeCommentString30Support Structure Type CommentSupport structure type (analogous to a pole or tower) not listed in the options above.true
SupportStructureMaterialString30Support Structure MaterialMaterial from which pole, tower, or crossarm is made. Possible values: Wood, Metal, Composite, Wrapped wood, Concrete, Other – See comment.DomSupportStructureMaterialtrue
SupportStructureMaterialCommentString30Support Structure Material CommentSupport structure material not listed in the options above.true
SupportStructureMaterialSubtypeString30Support Structure Material SubtypeThe subtype of structure material. For example, if a wood pole, the type of wood (i.e. Douglas Fir, Cedar, etc.).true
UnderbuildString3UnderbuildDoes the line support multiple transmission or primary distribution circuits? Possible values: Yes, No.DomYesNotrue
ConstructionGradeString10Construction GradeGrade of construction, in accordance with GO 95, Rule 42. Possible Values: Grade A, Grade B, Grade C.DomConstructionGradetrue
CrossarmAttachedString10Crossarm AttachedIs one or more crossarms attached to the support structure? Possible values: Yes, No, Unknown.DomYesNoUnknowntrue
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true


SCE_Switchgear_20210501 - FeatureClass

NameSCE_Switchgear_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Switchgear 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_Switchgear_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique ID for a specific switchgear asset. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Switchgear feature class attribute table.true
SupportStructureIDString50Support Structure IDUnique ID for support structure to which a switchgear asset is attached. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the Support Structure feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation feature class attribute table.true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line feature class attribute tables.true
AssetTypeString50Asset TypeType of point asset. Required value: SwitchgearDomAssetTypetrue
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, Unknown.DomOhUgtrue
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
SubstationNameString50Substation NameName of substation associated with asset.true
CircuitNameString255Circuit NameName of circuit associated with asset. Leave blank or enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
ManufacturerString50ManufacturerName of the manufacturer of the equipment. Do not use acronyms or abbreviations for this field. Fully spell out the manufacturer name. Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Leave blank if unknown.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Leave blank if unknown.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Note: Only enter "N/A" if there is an "InstallationDate" value or "InstallationYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.”true
ExemptionStatusString10Exemption StatusIs the asset exempt per California Public Resources Code (PRC) 4292? This field is especially important and a high priority for the WSD and the State of California. Non-exempt equipment requires support structure clearance. Possible values: Yes, No, Unknown, N/A.DomYesNoUnknownNAtrue
CurrentRatingSingle4Current Rating (A)Nominal current rating of the switchgear in amperes.true
AssetClassString30Asset ClassIs the asset associated with transmission or distribution? If the asset is associated with subtransmission, enter “Transmission.” Possible values: Distribution, Transmission.DomAssetClasstrue
SCADAEnabledString3SCADA EnabledCan supervisory control and data acquisition (SCADA) be utilized with the asset? Possible values: Yes, No, N/A.DomYesNoNAtrue
SwitchgearTypeString30Switchgear TypeType of switchgear (switch, cut-out fuse, circuit breaker, etc.)true
SwitchgearSubtypeString30Switchgear SubtypeSpecific type of switch, cut-out fuse, circuit breaker, etc.true
SwitchgearInsulatingMediumString30Switchgear Insulating MediumMedium (air, gas, oil, etc.) providing insulation for switchgear asset. Be specific.true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true


SCE_TransformerSite_20210501 - FeatureClass

NameSCE_TransformerSite_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Transformer Site 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_TransformerSite_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
TransformerSiteIDString50Transformer Site IDUnique ID for a specific transformer site. It should be a traceable stable ID within the utility’s operations/processes. Primary key enabling connection to the Transformer Detail related table.true
SupportStructureIDString50Support Structure IDUnique ID for support structure to which transformer is attached. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the Support Structure feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
AssetTypeString50Asset TypeType of point asset. Required value: TransformerDomAssetTypetrue
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, Unknown.DomOhUgtrue
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which asset is located.true
InaBankString30In A BankDoes a single point represent multiple assets that exist in a bank arrangement (i.e., transformer bank)? Possible values: Yes (if multiple transformers are represented by a single point, enter additional related table records in the Transformer Detail related table as needed), No, Unknown.DomYesNoUnknowntrue
QuantityinBankInteger4Quantity in BankHow many transformers exist in a bank arrangement (if applicable)? Enter “-99” if unknown.true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true


SCE_WeatherStation_20210501 - FeatureClass

NameSCE_WeatherStation_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Weather Station 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_WeatherStation_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
StationIDString50Station IDThe equivalent to the “Asset ID” field from other feature classes. Station ID for the weather station. It should enable data users to look up the data collected by the weather station. Primary key for the Weather Station feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
AssetTypeString50Asset TypeType of point asset. Required field: Weather stationDomAssetTypetrue
ManufacturerString150ManufacturerName of the manufacturer(s) of the asset. Do not use acronyms or abbreviations for this field. Fully spell out the manufacturer name. Enter “Unknown” if this cannot be determined. Enter multiple names as necessary, separated by semicolons.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Leave blank if unknown.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Note: Only enter "N/A" if there is an "InstallationDate" value or "InstallationYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.”true
WeatherStationURLString255Weather Station URLWebsite address for weather station information (if publicly available).true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees). Field-calculate in GIS software.true



SCE_Initiative - FeatureDataset

NameSCE_Initiative
DescriptionSCE_Initiative

SCE_AssetInspectionLine_20210501 - FeatureClass

NameSCE_AssetInspectionLine_20210501
ShapeTypePolyline
FeatureTypeSimple
AliasNameSCE Asset Inspection Line 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_AssetInspectionLine_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AiIDString50AI IDUnique ID or job ID of an asset inspection activity. Primary key for the Asset Inspection Line feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
AiLogIDString50AI Log IDUnique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection Log related table.true
AssetIDString50Asset IDUnique ID for a specific point asset. Must be traceable stable ID within a specific asset class. Foreign key to all the related Asset Point tables.true
CircuitIDString50Circuit IDUnique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line tables.true
InspectionLocationOrAddressString100Inspection Location Or AddressAddress or location description for the inspection location.true
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory1true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
InspectionStatusString30Inspection StatusThe status of the asset inspection. Possible values: Planned, In-progress, CompleteDomStatustrue
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
HFTDClassCommentString50HFTD Class CommentIf the project line intersects multiple HFTD areas, list all of them here.true
CountyString50CountyCounty where the asset inspection project is located. If the data line intersects multiple counties, list all counties separated by commas.true
DistrictString100DistrictOperating district where the asset inspection project occurred. If the data line intersects multiple districts, list all districts separated by commas.true


SCE_AssetInspectionPoint_20210501 - FeatureClass

NameSCE_AssetInspectionPoint_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Asset Inspection Point 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_AssetInspectionPoint_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AiIDString50AI IDUnique ID or job ID of an asset inspection activity. Primary key for the Asset Inspection Point feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
AiLogIDString50AI Log IDUnique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection Log related table.true
AssetIDString50Asset IDUnique ID for a specific point asset. Must be traceable stable ID within a specific asset class. Foreign key to all the related Asset Point feature class attribute tables.true
CircuitIDString50Circuit IDUnique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line feature class attribute tables.true
InspectionLocationOrAddressString100Inspection Location Or AddressAddress or location description for the inspection location.true
ParcelAPNString25Parcel APNAssessor Parcel Number (APN), a number assigned to parcels of real property by the tax assessor of a particular jurisdiction for purposes of identification and record-keeping. If the asset inspected does not intersect a parcel boundary, enter “N/A” for this field.true
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory1true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
InspectionStatusString30Inspection StatusThe status of the asset inspection. Possible values: Planned, In-progress, CompleteDomStatustrue
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty where the asset inspection project occurred.true
DistrictString100DistrictOperating district where the asset inspection project occurred.true
LatitudeSingle4LatitudeLatitude of event point (in decimal degrees). Field-calculate in GIS software.true
LongitudeSingle4LongitudeLongitude of event point (in decimal degrees). Field-calculate in GIS software.true


SCE_AssetInspectionPolygon_20210501 - FeatureClass

NameSCE_AssetInspectionPolygon_20210501
ShapeTypePolygon
FeatureTypeSimple
AliasNameSCE Asset Inspection Polygon 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_AssetInspectionPolygon_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AiIDString50AI IDUnique ID or job ID of an asset inspection activity. Primary key for the Asset Inspection Polygon feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
AiLogIDString50AI Log IDUnique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection Log related table.true
CircuitIDString50Circuit IDUnique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line feature class attribute tables.true
ParcelAPNString25Parcel APNAssessor Parcel Number (APN), a number assigned to parcels of real property by the tax assessor of a particular jurisdiction for purposes of identification and record-keeping. If the asset inspected does not intersect a parcel boundary, enter “N/A” for this field.true
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory1true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
InspectionStatusString30Inspection StatusThe status of the asset inspection. Possible values: Planned, In-progress, CompleteDomStatustrue
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
HFTDClassCommentString50HFTD Class CommentIf the project line intersects multiple HFTD areas, list all of them here.true
CountyString50CountyCounty where the asset inspection project is located. If the data polygon intersects multiple counties, list all counties separated by commas.true
DistrictString100DistrictOperating district where the asset inspection project occurred. If the data polygon intersects multiple districts, list all districts separated by commas.true


SCE_GridHardeningLine_20210501 - FeatureClass

NameSCE_GridHardeningLine_20210501
ShapeTypePolyline
FeatureTypeSimple
AliasNameSCE Grid Hardening Line 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_GridHardeningLine_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
GhIDString50GH IDUnique ID or job ID of a grid hardening activity. Primary key for the Grid Hardening Line feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
GhLogIDString50GH Log IDUnique ID or job ID of a grid hardening activity. Foreign key to the Grid Hardening Log related table.true
AssetIDString50Asset IDUnique ID for a specific point asset. Must be traceable stable ID within a specific asset class. Foreign key to all the related Asset Point feature class attribute tables.true
CircuitIDString50Circuit IDUnique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line feature class attribute tables.true
GridHardeningLocationOrAddressString100Grid Hardening Location Or AddressAddress or location description for the grid hardening location.true
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory1true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
GhStatusString30GH StatusThe status of the grid hardening activity. Possible values: Planned, In-progress, CompleteDomStatustrue
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
HFTDClassCommentString50HFTD Class CommentIf the project line intersects multiple HFTD areas, list all of them here.true
CountyString50CountyCounty where the grid hardening project is located. If the data line intersects multiple counties, list all counties separated by commas.true
DistrictString100DistrictOperating district where the grid hardening project is located. If the data line intersects multiple districts, list all districts separated by commas.true


SCE_GridHardeningPoint_20210501 - FeatureClass

NameSCE_GridHardeningPoint_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Grid Hardening Point 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_GridHardeningPoint_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
GhIDString50GH IDUnique ID or job ID of a grid hardening activity. Primary key for the Grid Hardening Point feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
GhLogIDString50GH Log IDUnique ID or job ID of a grid hardening activity. Foreign key to the Grid Hardening Log related table.true
AssetIDString50Asset IDUnique ID for a specific point asset. Must be traceable stable ID within a specific asset class. Foreign key to all the related Asset Point feature class attribute tables.true
CircuitIDString50Circuit IDUnique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line feature class attribute tables.true
GridHardeningLocationOrAddressString100Grid Hardening Location Or AddressAddress or location description for the grid hardening location.true
ParcelAPNString25Parcel APNAssessor Parcel Number (APN), a number assigned to parcels of real property by the tax assessor of a particular jurisdiction for purposes of identification and record-keeping. If the asset inspected does not intersect a parcel boundary, enter “N/A” for this field.true
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory1true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
GhStatusString30GH StatusThe status of the grid hardening activity. Possible values: Planned, In-progress, CompleteDomStatustrue
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty where the grid hardening project is located.true
DistrictString100DistrictOperating district where the grid hardening project is located.true
LatitudeSingle4LatitudeLatitude of event point (in decimal degrees). Field-calculate in GIS software.true
LongitudeSingle4LongitudeLongitude of event point (in decimal degrees). Field-calculate in GIS software.true


SCE_OtherInitiativeLine_20210501 - FeatureClass

NameSCE_OtherInitiativeLine_20210501
ShapeTypePolyline
FeatureTypeSimple
AliasNameSCE Other Initiative Line 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_OtherInitiativeLine_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
OiIDString50OI IDUnique ID of Other initiative activity. Primary key for the Other Initiative Line feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
OiLogIDString50OI Log IDUnique ID or job ID of a 'Other Initiative' activity. Foreign key to the Other Initiative Log related table.true
LocationOrAddressString100Location or AddressAddress or location description for the activity.true
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory2true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
OiStatusString30Other Initiative StatusThe status of the activity. Possible values: Planned, In-progress, CompleteDomStatustrue
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
CountyString50CountyCounty where the initiative is located. If the data line intersects multiple counties, list all counties separated by commas.true
DistrictString100DistrictOperating district where the initiative is located. If the data line intersects multiple districts, list all districts separated by commas.true


SCE_OtherInitiativePoint_20210501 - FeatureClass

NameSCE_OtherInitiativePoint_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Other Initiative Point 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_OtherInitiativePoint_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
OiIDString50OI IDUnique ID or job ID of an Other Initiative activity. Primary key for the Other Initiative Point feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
OiLogIDString50OI Log IDUnique ID or job ID of an Other Initiative activity. Foreign key to the Other Initiative Log related table.true
LocationOrAddressString100Location or AddressAddress or location description for the activity.true
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory2true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
OiStatusString30Other Initiative StatusThe status of the activity. Possible values: Planned, In-progress, CompleteDomStatustrue
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
CountyString50CountyCounty where the initiative is located.true
DistrictString100DistrictOperating district where the initiative is located.true
LatitudeSingle4LatitudeLatitude of point in decimal degrees. Field-calculate in GIS software.true
LongitudeSingle4LongitudeLongitude of point in decimal degrees. Field-calculate in GIS software.true


SCE_OtherInitiativePolygon_20210501 - FeatureClass

NameSCE_OtherInitiativePolygon_20210501
ShapeTypePolygon
FeatureTypeSimple
AliasNameSCE Other Initiative Polygon 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_OtherInitiativePolygon_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
OiIDString50OI IDUnique ID of Other initiative activity. Primary key for the Other Initiative Polygon feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
OiLogIDString50OI Log IDUnique ID or job ID of a 'Other Initiative' activity. Foreign key to the Other Initiative Log table.true
LocationOrAddressString100Location or AddressAddress or location description for the activity.true
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory2true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
OiStatusString30Other Initiative StatusThe status of the activity. Possible values: Planned, In-progress, CompleteDomStatustrue
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
CountyString50CountyCounty where the initiative is located. If the data polygon intersects multiple counties, list all counties separated by commas.true
DistrictString100DistrictOperating district where the initiative is located. If the data polygon intersects multiple districts, list all districts separated by commas.true


SCE_VegetationInspectionLine_20210501 - FeatureClass

NameSCE_VegetationInspectionLine_20210501
ShapeTypePolyline
FeatureTypeSimple
AliasNameSCE Vegetation Inspection Line 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_VegetationInspectionLine_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmiIDString50VMI IDUnique ID or job ID of a vegetation inspection activity. Primary key for the Vegetation Inspection Line feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
VmiLogIDString50VMI Log IDUnique ID or job ID of a vegetation inspection activity. Foreign key to the Vegetation Inspection Log related table.true
AssetIDString50Asset IDUnique ID for a specific point asset. Must be traceable stable ID within a specific asset class. Foreign key to all the related Asset Point feature class attribute tables.true
CircuitIDString50Circuit IDUnique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line feature class attribute tables.true
InspectionLocationOrAddressString100Inspection Location Or AddressAddress or location description for the inspection location.true
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory1true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
InspectionStatusString30Inspection StatusThe status of the vegetation inspection project. Possible values: Planned, In-progress, CompleteDomStatustrue
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
HFTDClassCommentString50HFTD Class CommentHFTDClassCommenttrue
CountyString50CountyCounty where the vegetation management inspection occurred. If the data line intersects multiple counties, list all counties separated by commas.true
DistrictString100DistrictOperating district where the vegetation management inspection occurred. If the data line intersects multiple districts, list all districts separated by commas.true


SCE_VegetationInspectionPoint_20210501 - FeatureClass

NameSCE_VegetationInspectionPoint_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Vegetation Inspection Point 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_VegetationInspectionPoint_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmiIDString50VMI IDUnique ID or job ID of a vegetation inspection activity. Primary key for the Vegetation Inspection Point feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
VmiLogIDString50VMI Log IDUnique ID or job ID of a vegetation inspection activity. Foreign key to the Vegetation Inspection Log related table.true
AssetIDString50Asset IDUnique ID for a specific point asset. Must be traceable stable ID within a specific asset class. Foreign key to all the related Asset Point feature class attribute tables.true
CircuitIDString50Circuit IDUnique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line feature class attribute tables.true
InspectionLocationOrAddressString100Inspection Location Or AddressAddress or location description for the inspection location.true
ParcelAPNString25Parcel APNAssessor Parcel Number (APN), a number assigned to parcels of real property by the tax assessor of a particular jurisdiction for purposes of identification and record-keeping.true
TreeHealthString3Tree HealthIs the tree healthy? Possible values: Yes, No.DomYesNotrue
TreeSpeciesString100Tree SpeciesCommon name for species of tree.true
TreeHeightInteger4Tree Height (feet)Tree height (feet). Round the value. Maximum value: 300.DomTreeHeighttrue
TreeDiameterInteger4Tree Diameter (inches)Tree diameter at breast height (inches). Round the value. Maximum value: 180.DomTreeDiametertrue
TreeDistanceInteger4Tree Distance (feet)Distance (in feet) between tree and nearest utility asset.true
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory1true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
InspectionStatusString30Inspection StatusThe status of the vegetation inspection project. Possible values: Planned, In-progress, CompleteDomStatustrue
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty where the vegetation inspection is located.true
DistrictString100DistrictOperating district where the vegetation inspection occurred.true
LatitudeSingle4LatitudeLatitude of event point (in decimal degrees). Field-calculate in GIS software.true
LongitudeSingle4LongitudeLongitude of event point (in decimal degrees). Field-calculate in GIS software.true


SCE_VegetationInspectionPolygon_20210501 - FeatureClass

NameSCE_VegetationInspectionPolygon_20210501
ShapeTypePolygon
FeatureTypeSimple
AliasNameSCE Vegetation Inspection Polygon 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_VegetationInspectionPolygon_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmiIDString50VMI IDUnique ID or job ID of a vegetation inspection activity. Primary key for the Vegetation Inspection Polygon feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
VmiLogIDString50VMI LogIDUnique ID or job ID of a vegetation inspection activity. Foreign key to the Vegetation Inspection Log related table.true
CircuitIDString50Circuit IDUnique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line feature class attribute tables.true
InspectionLocationOrAddressString100Inspection Location Or AddressAddress or location description for the inspection location.true
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory1true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
InspectionStatusString30Inspection StatusThe status of the vegetation inspection project. Possible values: Planned, In-progress, CompleteDomStatustrue
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
HFTDClassCommentString50HFTD Class CommentHFTDClassCommenttrue
CountyString50CountyCounty where the vegetation management inspection is located. If the data polygon intersects multiple counties, list all counties separated by commas.true
DistrictString100DistrictOperating district where the vegetation management inspection occurred. If the data polygon intersects multiple districts, list all districts separated by commas.true


SCE_VegetationManagementProjectLine_20210501 - FeatureClass

NameSCE_VegetationManagementProjectLine_20210501
ShapeTypePolyline
FeatureTypeSimple
AliasNameSCE Vegetation Management Project Line 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_VegetationManagementProjectLine_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmpIDString50VMP IDUnique ID or job ID of an initiative. Primary key for Vegetation Management Project Line feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
VmpLogIDString50VMP Log IDUnique ID or job ID of an initiative. Foreign key to the Vegetation Inspection Project Log related table.true
AssetIDString50Asset IDUnique ID for a specific point asset. Must be traceable stable ID within a specific asset class. Foreign key to all the related Asset Point feature class attribute tables.true
CircuitIDString50Circuit IDUnique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line feature class attribute tables.true
ProjectLocationOrAddressString100Project Location Or AddressAddress or location description for project location.true
LineDeenergizedString3Line Deenergized?Do the power lines need to be de-energized to perform the work? Possible values: Yes, No.DomYesNotrue
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory1true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
VmpStatusString30Vegetation Management Project StatusThe status of the vegetation management project. Possible values: Planned, In-progress, CompleteDomStatustrue
HerbicideUseString3Herbicide UseAre any herbicides planned to be used or were any herbicides used as part of the project? Possible values: Yes, NoDomYesNotrue
HerbicideNameString100Herbicide NameIf any herbicides are planned for use or were used, list the specific products used / to be used.true
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
HFTDClassCommentString50HFTD Class CommentIf the project line intersects multiple HFTD areas, list all of them here.true
CountyString50CountyCounty where the vegetation management project is located. If the data line intersects multiple counties, list all counties separated by commas.true
DistrictString100DistrictOperating district where the vegetation management project occurred. If the data line intersects multiple districts, list all districts separated by commas.true


SCE_VegetationManagementProjectPoint_20210501 - FeatureClass

NameSCE_VegetationManagementProjectPoint_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Vegetation Management Project Point 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_VegetationManagementProjectPoint_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmpIDString50VMP IDUnique ID or job ID of an initiative. Primary key for Vegetation Management Project Point feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
VmpLogIDString50VMP Log IDUnique ID or job ID of an initiative. Foreign key to the Vegetation Inspection Project Log related table.true
AssetIDString50Asset IDUnique ID for a specific point asset. Must be traceable stable ID within a specific asset class. Foreign key to all the related Asset Point feature class attribute tables.true
CircuitIDString50Circuit IDUnique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line feature class attribute tables.true
ProjectLocationOrAddressString100Project Location Or AddressAddress or location description for vegetation project location. Enter “N/A” if there is no address where the project is located.true
ParcelAPNString25Parcel APNAssessor Parcel Number (APN), a number assigned to parcels of real property by the tax assessor of a particular jurisdiction for purposes of identification and record-keeping.true
TreeIDString50Tree IDA unique ID associated with the individual tree within the scope of the vegetation management project.true
TreeHealthString3Tree HealthIs the subject tree healthy? Possible values: Yes, No.DomYesNotrue
TreeHazardString3Tree HazardIs the subject tree a hazard tree? Possible values: Yes, No.DomYesNotrue
TreeSpeciesString100Tree SpeciesCommon name for tree species in scope for the vegetation management project.true
SpeciesGrowthRateString30Species Growth RateGeneralized growth rate of the subject tree species. Possible values: Slow growing, Moderately growing, Fast growing.DomSpeciesGrowthRatetrue
TreeHeightInteger4Tree Height (feet)Tree height (feet). Round the value. Maximum value: 300.DomTreeHeighttrue
TreeDiameterInteger4Tree Diameter (inches)Tree diameter at breast height (inches). Round the value. Maximum value: 180.DomTreeDiametertrue
LineDeenergizedString3Line Deenergized?Do the power lines need to be de-energized to perform the work? Possible values: Yes, No.DomYesNotrue
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory1true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
VmpStatusString30Vegetation Management Project StatusThe status of the vegetation management project. Possible values: Planned, In-progress, CompleteDomStatustrue
HerbicideUseString3Herbicide UseAre any herbicides planned to be used or were any herbicides used as part of the project? Possible values: Yes, NoDomYesNotrue
HerbicideNameString100Herbicide NameIf any herbicides are planned for use or were used, list the specific products used / to be used.true
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty where the vegetation management project is located.true
DistrictString100DistrictOperating district where the vegetation management project occurred.true
LatitudeSingle4LatitudeLatitude of event point (in decimal degrees). Field-calculate in GIS software.true
LongitudeSingle4LongitudeLongitude of event point (in decimal degrees). Field-calculate in GIS software.true


SCE_VegetationManagementProjectPolygon_20210501 - FeatureClass

NameSCE_VegetationManagementProjectPolygon_20210501
ShapeTypePolygon
FeatureTypeSimple
AliasNameSCE Vegetation Management Project Polygon 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_VegetationManagementProjectPolygon_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmpIDString50VMP IDUnique ID or job ID of an initiative. Primary key for Vegetation Management Project Polygon feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
VmpLogIDString50VMP Log IDUnique ID or job ID of an initiative. Foreign key to the Vegetation Inspection Project Log related table.true
CircuitIDString50Circuit IDUnique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line feature class attribute tables.true
ProjectLocationOrAddressString100Project Location Or AddressAddress or location description for project location.true
LineDeenergizedString3Line Deenergized?Do the power lines need to be de-energized to perform the work? Possible values: Yes, No.DomYesNotrue
WMPInitiativeCategoryString50WMP Initiative CategoryBroad category for the initiative. Possible values: Risk assessment and mapping, Situational awareness and forecasting, Grid design and system hardening, Asset management and inspections, Vegetation management and inspections.DomInitiativeCategory1true
WMPInitiativeActivityString150WMP Initiative ActivityMore specific description of initiative activity. Use items listed in WMP guidelines section 9.1 (p. 49). May add new activity descriptions not in that list.true
WMPSectionString15WMP SectionSection of WMP tied to initiative.true
WMPPageNumberInteger4WMP Page NumberPage number of WMP where section begins.true
VmpStatusString30Vegetation Management Project StatusThe status of the vegetation management project. Possible values: Planned, In-progress, CompleteDomStatustrue
HerbicideUseString3Herbicide UseAre any herbicides planned to be used or were any herbicides used as part of the project? Possible values: Yes, NoDomYesNotrue
HerbicideNameString100Herbicide NameIf any herbicides are planned for use or were used, list the specific products used / to be used.true
InitiativeTargetSingle4Initiative TargetThe numerical target for the identified initiative activity during the reporting period. This is the expected target for the particular activity represented by the geometry, not the overall target for the larger initiative (if those are different). Do not change targets for completed projects to reflect what was actually performed.true
InitiativeProgressSingle4Initiative ProgressThe amount of the Initiative Target that was complete at the end of the reporting period, if any. This will be in the same units as the Initiative Target.true
InitiativeTargetUnitsString50Initiative Target UnitsThe units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
HFTDClassCommentString50HFTD Class CommentHFTDClassCommenttrue
CountyString50CountyCounty where the vegetation management project is located. If the data polygon intersects multiple counties, list all counties separated by commas.true
DistrictString100DistrictOperating district where the vegetation management project occurred. If the data polygon intersects multiple districts, list all districts separated by commas.true



SCE_OtherRequiredData - FeatureDataset

NameSCE_OtherRequiredData
DescriptionSCE_OtherRequiredData

SCE_AdministrativeArea_20210501 - FeatureClass

NameSCE_AdministrativeArea_20210501
ShapeTypePolygon
FeatureTypeSimple
AliasNameSCE Administrative Area 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_AdministrativeArea_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AdminIDString50Admin IDUnique ID and primary key for the Administrative Area feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
AreaTypeString50Area TypeType of administrative area (service territory, region, district, zone, etc.)true
SubareaTypeString50Subarea TypeUtility sub-area type. Enter “N/A” if an administrative area feature class is not broken into sub-polygons with unique names. Possible values: Operational, Construction, Weather, Organizational, Other - See comment.DomSubareaTypetrue
SubareaTypeCommentString50Subarea Type CommentSub-area type not listed in the options above.true
NameString100NameName of administrative area.true


SCE_CriticalFacility_20210501 - FeatureClass

NameSCE_CriticalFacility_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Critical Facility 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_CriticalFacility_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
FacilityIDString50Facility IDUnique ID for a specific critical facility. It should be a traceable stable ID within the utility's operations/processes. Primary key to the Critical Facility point feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
FacilityNameString100Facility NameName of the facility.true
FacilityCategoryString30Facility CategoryCritical facility category. See examples table in the reporting requirements document for examples of facilities that fall under these categories. Possible values: Chemical, Communications, Educational, Emergency services, Energy, Government facilities, Healthcare and public health, Public safety answering points, Transportation, Water and wastewater systems, Other – See comment.DomFacilityCategorytrue
FacilityCategoryCommentString30Facility Category CommentFacility category not covered by the options above.true
FacilityDescriptionString50Facility DescriptionBrief facility description (e.g., fire station, prison, nursing home, etc.).true
CircuitIDString50Circuit IDID of circuit associated with critical facility.true
CircuitNameString255Circuit NameName of circuit associated with critical facility. Enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
MeterIDString50Meter IDID of meter associated with critical facility.true
BackupPowerString10Backup PowerDoes the facility have a backup power source? Possible values: Yes, No, Unknown.DomYesNoUnknowntrue
BackupTypeString30Backup TypeType of backup power source. Possible values: Storage battery, Diesel generator, Gas generator, Combined/hybrid, Other – See comment.DomBackupTypetrue
BackupTypeCommentString30Backup Type CommentBackup type not listed in the options above.true
BackupCapacitySingle4Backup CapacityHours of energy storage of backup generation from backup power source.true
PopulationImpactInteger4Population ImpactThe approximate number of people that depend on this critical facility.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
PSPSDaysInteger4PSPS DaysThe number of days the critical facility was impacted by PSPS events in the last 365 days.true
PSPSDaysDateBasisDate8PSPS Days Date BasisThe date used for calculating the “PSPSDays” field. This would be the date from which 365 days would be subtracted to determine the timespan that may contain critical facility-impacting PSPS events.true
ParcelAPNString25Parcel APNID of parcel containing critical facility. Assessor Parcel Number (APN), a number assigned to parcels of real property by the tax assessor of a particular jurisdiction for purposes of identification and record-keeping.true
AddressString100AddressThe address of the critical facility.true
CityString50CityThe city of the critical facility.true
ZipString5ZipThe 5-digit zip code of the critical facility.true
LatitudeSingle4LatitudeLatitude coordinate of critical facility (in decimal degrees). Field-calculate in GIS software.true
LongitudeSingle4LongitudeLongitude coordinate of critical facility (in decimal degrees). Field-calculate in GIS software.true


SCE_MajorWoodyStemExemptTreePoint_20210501 - FeatureClass

NameSCE_MajorWoodyStemExemptTreePoint_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Major Woody Stem Exempt Tree Point 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_MajorWoodyStemExemptTreePoint_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
SpeciesString100SpeciesTree species common name. Do not use codes of scientific names.true
LastInspectionDateDate8Last Inspection DateLast date MWS tree was inspected.true
QuantityInteger4QuantityQuantity of MWS trees represented by a single point if there are more than one. This may not be applicable to all electrical corporations. Leave this value as null if it is not applicable.true
LatitudeSingle4LatitudeLatitude of MWS tree point (in decimal degrees). Field-calculate in GIS software.true
LongitudeSingle4LongitudeLongitude of MWS tree point (in decimal degrees). Field-calculate in GIS software.true


SCE_OtherPowerLineConnectionLocation_20210501 - FeatureClass

NameSCE_OtherPowerLineConnectionLocation_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Other Power Line Connection Location 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_OtherPowerLineConnectionLocation_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
OplcIDString50OPLC IDUnique ID of private power line connection location. Primary key for the Electrical Corporation Power Line-Other Power Line Connection Location Point feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
OtherLineOwnerString100Other Line OwnerName of individual or other entity that owns the line to which the submitting corporation's electrical corporation line is connecting.true
ConnectionAssetString100Connection AssetAsset enabling the connection.true
ConnectionPointAssetIDString50Connection Point Asset IDAssetID of the asset that enables the connection. Must be traceable stable ID within a specific asset class. Foreign key to the related asset point feature class attribute tables.true
CorporationLineIDString50Corporation Line IDAssetID of the electrical corporation line that feeds energy into or receives energy from the private line. Must be traceable stable ID within a specific asset class. Foreign key to the related asset line feature class attribute tables.true
OtherLineClassString30Other Line ClassClassification of line asset that meets corporation line at connection location. Possible values: Transmission, Primary distribution, Secondary distribution, UnknownDomCircuitTypetrue
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the connection location intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which connection location is located.true
OtherConductorTypeString30Other Conductor TypeType of conductor that connects to corporation line. Possible values: Bare, Covered, UnknownDomConductorTypetrue
ConnectionTypeString30Connection TypeType of energy transfer happening at location. Possible values: Corporation to private, Corporation to corporationDomConnectionTypetrue
ConnectionOHUGString50Connection OH or UGIs the connection overhead or underground? Possible values: All Overhead, All underground, Overhead to underground, Underground to overhead, UnknownDomConnectionOhUgtrue
OtherNominalVoltagekVSingle4Other Nominal Voltage (kV)Nominal voltage (in kilovolts) of other conductor connected to corporation line. Do not use more than two decimal places. Enter “-99” if not applicable.true
OtherOperatingVoltagekVSingle4Other Operating Voltage (kV)Operating voltage (in kilovolts) of other conductor connected to corporation line. Do not use more than two decimal places. Enter “-99” if not applicable.true
OtherConductorMaterialString100Other Conductor MaterialConductor material of other line that connects to corporation line. Possible values: All aluminum conductor (AAC), All aluminum alloy conductor (AAAC), Aluminum conductor aluminum reinforced (ACAR), Aluminum conductor steel reinforced (ACSR), Aluminum conductor steel supported (ACSS), Copper (Cu), Unknown, Other - See commentDomConductorMaterialtrue
OtherConductorMaterialCommentString50Other Conductor Material CommentConductor material not listed in the options above.true
OtherConductorSizeString30Other Conductor SizeSize of other conductor that connects to corporation line (e.g. No. 4 Cu or 1/0 ACSR). Write “Unknown” if this is not known.true
OtherConductorODSingle4Other Conductor Overall Diameter (inches)Overall diameter of the other conductor that connects to the corporation conductor in inches. Leave blank if this is not known.true
ConnectionLastInspectionDateDate8Connection Last Inspection DateDate of the last maintenance. Leave blank if unknown.true
ConnectionLastMaintenanceDateDate8Connection Last Maintenance DateDate the connection was established. Leave blank if unknown.true
ConnectionEstablishmentDateDate8Connection Establishment DateDate the connection was established. Leave blank if unknown.true
ConnectionEstablishmentYearInteger4Connection Establishment YearYear of connection establishment. Leave blank if unknown.true
EstimatedConnectionAgeString10Estimated Connection AgeThe age of the asset in years. Only fill this out if the “ConnectionEstablishmentYear” and “ConnectionEstablishmentDate” values are unknown. Note: Only enter "N/A" if there is an "ConnectionEstablishmentDate" value or "ConnectionEstablishmentYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
OtherUsefulLifespanInteger4Other Useful LifespanThe number of years the other line connected to the corporation line is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.”true
OtherAmpacityRatingSingle4Other Ampacity RatingNominal ampacity rating of the other conductor in amperes.true
OtherLineGreasedString10Other Line GreasedIs the other conductor connected to the corporation line greased to prevent water intrusion? Possible values: Yes, No, Unknown.DomYesNoUnknowntrue
ConnectionCommentsString100Other Power Line CommentsDescribe any additional key details that should be known about the connection location.true


SCE_RedFlagWarningDayPolygon_20210501 - FeatureClass

NameSCE_RedFlagWarningDayPolygon_20210501
ShapeTypePolygon
FeatureTypeSimple
AliasNameSCE Red Flag Warning Day Polygon 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_RedFlagWarningDayPolygon_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
RfwIDString50RFW IDUnique ID and primary key for the Red Flag Warning Day feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
FireWeatherZoneIDString50Fire Weather Zone IDID number of fire weather zone.true
FireWeatherZoneNameString30Fire Weather Zone NameUnique ID for a specific point asset. It should be a traceable stable ID within the utility’s operations/processes.true
RedFlagWarningIssueDateTimeDate8Red Flag Warning Issue Date and TimeStart date and time of the Red Flag Warning.true
NumberRedFlagWarningDaysSingle4Number Red Flag Warning DaysNumber of red flag warning days experienced in the fire weather zone in the last 365 days.true
RedFlagDaysDateBasisDate8Red Flag Days Date BasisThe date used for calculating the “NumberRedFlagWarningDays” field. This would be the date from which 365 days would be subtracted to determine the timespan that contained red flag warning days.true



SCE_PspsEvent - FeatureDataset

NameSCE_PspsEvent
DescriptionSCE_PspsEvent

SCE_PspsEventCustomerMeterPoint_20210501 - FeatureClass

NameSCE_PspsEventCustomerMeterPoint_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE PSPS Event Customer Meter Point 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_PspsEventCustomerMeterPoint_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PspsEventMeterIDString50PSPS Event Meter IDAn underscore delimited concatenation of "EventID"+"_"+"AssetID.” Primary key for the PSPS Event Customer Meter Point feature class attribute table.true
EventIDString50Event IDA unique standardized identification name of the unique PSPS event associated with a customer meter. Foreign key enabling connection to the PSPS Event Log related table.true
AssetIDString50Circuit IDUnique ID for a specific meter. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the Customer Meter Point feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which asset is located.true


SCE_PspsEventDamagePoint_20210501 - FeatureClass

NameSCE_PspsEventDamagePoint_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE PSPS Event Damage Point 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_PspsEventDamagePoint_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
DamageEventIDString50Damage Event IDID value for an individual PSPS event. Event ID values for damage points should match event ID values in corresponding PSPS event GIS data. Primary key enabling connection of the PSPS Event Damage Point feature class attribute table to the PSPS Event Conductor, Support Structure, and Other Asset damage detail related tables.true
EventIDString50Event IDA unique standardized identification name of the unique event. Foreign key enabling connection to the PSPS Event Log related table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
FuelBedDescriptionString150Fuel Bed DescriptionType of fuel bed existing at the damage location. A fire-resistive fueld bed is not conducive to propagating fire where damage occurred (e.g. asphalt, concrete, gravel, etc.). A grass fuel model is comprised of annual grasses where damaged occurred. A brush fuel model is comprised of mainly brush or shrubs where damage occurred (e.g., chamise, manzanita, chaparral, scotch broom, etc.). A timber fuel model is comprised of a timber where damaged occurred (e.g. forests, timber litter, logging slash, etc.). Possible values: Fire-resistive fuel bed, Grass fuel model, Brush fuel model, Timber fuel model, Other – See comment.DomFuelBedDescriptiontrue
FuelBedDescriptionCommentString150Fuel Bed Description CommentFuel bed description not listed in the options above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty in which asset damage is located.true
LatitudeSingle4LatitudeLatitude of point in decimal degrees. Field-calculate in GIS software.true
LongitudeSingle4LongitudeLongitude of point in decimal degrees. Field-calculate in GIS software.true


SCE_PspsEventLine_20210501 - FeatureClass

NameSCE_PspsEventLine_20210501
ShapeTypePolyline
FeatureTypeSimple
AliasNameSCE PSPS Event Line 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_PspsEventLine_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PspsEventLineIDString50PSPS Event Line IDAn underscore delimited concatenation of "EventID"+"_"+"CircuitID.” Primary key for the PSPS Event Line feature class attribute table.true
EventIDString50Event IDA unique standardized identification name of the unique event. Foreign key enabling connection to PSPS Event Log related table.true
CircuitIDString50Circuit IDA unique standardized identification name of the circuit that was de-energized. Foreign key to all the related asset line feature class attribute tables. There should be only one value per record – may have multiple records in table for one PSPS event if multiple circuits were involved. Use the same Event ID for these records.true
SubstationIDString50Substation IDA unique standardized identification name of the substation/feeder feeding the circuit that was de-energized during the PSPS event. Foreign key to the Substation feature class attribute table. There should be only one value per record – may have multiple records in table for one PSPS event if multiple substations were involved. Use the same Event ID for these records.true
IsolationDeviceIDString50Isolation Device IDA unique standardized identification name of the isolation device. Should match the value in the “AssetID” field of the isolation device’s point data in the Switchgear feature class. A foreign key. AKA AssetID. There should be only one value per record – may have multiple records in table for one PSPS event if multiple isolation devices were involved. Use the same Event ID for these records.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
CircuitNameString255Circuit NameName of circuit associated with asset. Leave blank or enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
SubstationNameString100Substation NameName of substation associated with asset.true
IsolationDeviceString30Isolation DeviceThe device which isolated the circuit during the PSPS event. Possible values: Circuit Breaker, Fuse, Switch, Other – See comment. There should be only one value per record – may have multiple records in table for one PSPS event if multiple devices were used. Use the same Event ID for these records.DomPspsIsolationDevicetrue
IsolationDeviceCommentString50Isolation Device CommentIsolation device not listed in the options above.true
PredictedDurationMinutesInteger4Predicted Duration MinutesAnticipated duration of PSPS event's circuit shutoff after it is initiated. Must be reported in whole number minutes.true
ActualDurationMinutesInteger4Actual Duration MinutesActual duration of PSPS event's circuit shutoff. This would be determined after restoration and must be reported in whole number minutes. This should be the duration for the customer whose service was restored last (the maximum duration for the outage).true
DurationPredictionErrorInteger4Duration Prediction Error​“PredictedDurationMinutes” minus “ActualDurationMinutes.” Positive values indicate shorter than predicted PSPS outage duration; negative values indicate longer than predicted PSPS outage duration.true
TotalCustomerMinutesInteger4Total Customer MinutesActual outage minutes experienced by customers.true
TotalCustomersInteger4Total CustomersTotal impacted customers. This is not necessarily a sum of all customer category values listed below because medical baseline customers may also be in other customer categories.true
ResidentialCustomersInteger4Residential CustomersTotal residential customers.true
MedicalBaselineCustomersInteger4Medical Baseline CustomersTotal medical baseline customers.true
CommercialIndustrialCustomersInteger4Commercial Industrial CustomersTotal commercial/industrial customers.true
OtherCustomersInteger4Other CustomersTotal customers that do not fall within residential or commercial/industrial (as requested under Decision 12-04-024).true
CriticalInfrastructureInteger4Critical InfrastructureNumber of critical infrastructure locations (in accordance with Decision 19-05-042 as modified by D.20-05-051) impacted by the PSPS event.true
CriticalInfrastructureDurationInteger4Critical Infrastructure DurationDuration of critical infrastructure locations (in accordance with Decision 19-05-042) de-energized during the PSPS event. Must be reported in whole number minutes.true
CriticalInfrastructureImpactInteger4Critical Infrastructure Impact“CriticalInfrastructure” multiplied by “CriticalInfrastructureDuration.”true
CountyString150CountyCounty in which asset is located. If the line crosses multiple counties, list all counties separated by commas.true


SCE_PspsEventPolygon_20210501 - FeatureClass

NameSCE_PspsEventPolygon_20210501
ShapeTypePolygon
FeatureTypeSimple
AliasNameSCE PSPS Event Polygon 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_PspsEventPolygon_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PspsEventPolygonIDString50PSPS Event Polygon IDPrimary key for the PSPS Event Polygon feature class attribute table.true
EventIDString50Event IDA unique standardized identification name of the unique event. Foreign key enabling connection to the PSPS Event Log related table.true
CircuitIDString50Circuit IDA unique standardized identification name of the circuit that was de-energized. Foreign key to all the related asset line feature class attribute tables. There should be only one value per record – may have multiple records in table for one PSPS event if multiple circuits were involved. Use the same Event ID for these recordstrue
SubstationIDString50Substation IDA unique standardized identification name of the substation/feeder feeding the circuit that was de-energized during the PSPS event. Foreign key to the Substation feature class attribute table. There should be only one value per record – may have multiple records in table for one PSPS event if multiple substations were involved. Use the same Event ID for these records.true
IsolationDeviceIDString50Isolation Device IDA unique standardized identification name of the isolation device. Should match the value in the “AssetID” field of the isolation device’s point data in the Switchgear feature class. A foreign key. AKA AssetID. There should be only one value per record – may have multiple records in table for one PSPS event if multiple isolation devices were involved. Use the same Event ID for these records.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
CircuitNameString255Circuit NameName of circuit associated with asset. Leave blank or enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
SubstationNameString100Substation NameName of substation associated with asset.true
IsolationDeviceString30Isolation DeviceThe device which isolated the circuit during the PSPS event. Possible values: Circuit Breaker, Fuse, Switch, Other – See comment, There should be only one value per record – may have multiple records in table for one PSPS event if multiple devices were used. Use the same Event ID for these records.DomPspsIsolationDevicetrue
IsolationDeviceCommentString50Isolation Device CommentIsolation device not listed in the options above.true
PredictedDurationMinutesInteger4Predicted Duration MinutesAnticipated duration of PSPS event's circuit shutoff after it is initiated. Must be reported in whole number minutes.true
ActualDurationMinutesInteger4Actual Duration MinutesActual duration of PSPS event's circuit shutoff. This would be determined after restoration and must be reported in whole number minutes. This should be the duration for the customer whose service was restored last (the maximum duration for the outage).true
DurationPredictionErrorInteger4Duration Prediction Error​“PredictedDurationMinutes” minus “ActualDurationMinutes.” Positive values indicate shorter than predicted PSPS outage duration; negative values indicate longer than predicted PSPS outage duration.true
TotalCustomerMinutesInteger4Total Customer MinutesActual outage minutes experienced by customers.true
TotalCustomersInteger4Total CustomersTotal impacted customers. This is not necessarily a sum of all customer category values listed below because medical baseline customers may also be in other customer categories.true
ResidentialCustomersInteger4Residential CustomersTotal residential customers.true
MedicalBaselineCustomersInteger4Medical Baseline CustomersTotal medical baseline customers.true
CommercialIndustrialCustomersInteger4Commercial Industrial CustomersTotal commercial/industrial customers.true
OtherCustomersInteger4Other CustomersTotal customers that do not fall within residential or commercial/industrial (as requested under Decision 12-04-024).true
CriticalInfrastructureInteger4Critical InfrastructureNumber of critical infrastructure locations (in accordance with Decision 19-05-042 as modified by D.20-05-051) impacted by the PSPS event.true
CriticalInfrastructureDurationInteger4Critical Infrastructure DurationDuration of critical infrastructure locations (in accordance with Decision 19-05-042) de-energized during the PSPS event. Must be reported in whole number minutes.true
CriticalInfrastructureImpactInteger4Critical Infrastructure Impact“CriticalInfrastructure” multiplied by “CriticalInfrastructureDuration.” This field features the total PSPS impact on critical infrastructure.true
CountyString150CountyCounty in which parcel affected by PSPS event is located. If the data polygon intersects multiple counties, list all counties separated by commas.true



SCE_RiskEvent - FeatureDataset

NameSCE_RiskEvent
DescriptionSCE_RiskEvent

SCE_DistributionUnplannedOutage_20210501 - FeatureClass

NameSCE_DistributionUnplannedOutage_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Distribution Unplanned Outage 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_DistributionUnplannedOutage_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
DoutageIDString50Distribution Outage IDThe unique ID for the distribution unplanned outage event. Primary key for the Distribution Unplanned Outage feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
SubstationIDString50Substation IDUnique ID for the source substation feeding the circuit impacted by the outage. Must be traceable stable ID within a specific asset class. Foreign key to Substation feature class attribute table.true
BasicCauseString30Basic CauseHigh-level category for event cause. Possible values: Object contact, Equipment failure, Wire-to-wire contact, Contamination, Operator error, Vandalism/theft, Lightning, Unknown, Other – See comment.DomCausetrue
BasicCauseCommentString50Basic Cause CommentBasic cause description not listed in the options above; or, any additional information about cause (unless additional info is regarding object contact or equipment failure, which have their own comment fields).true
BasicCauseObjectString30Basic Cause ObjectDescription of object involved in contact. Only applicable if the "BasicCause" field has a value of "Object contact." If this is not the case, choose “N/A.” If the object involved in the contact is not in the list below, use the "Other - See comment" value and input an appropriate comment. Possible values: Vegetation, Animal, Balloon, Vehicle contact - car pole, Vehicle contact - aircraft, 3rd party facility, N/A, Unknown, Other - See comment.DomObjectContacttrue
BasicCauseObjectCommentString50Basic Cause Object CommentBasic cause object description not listed in the options above; or, any additional information about object.true
DamagedDeviceString30Damaged DeviceThe device type that failed or experienced damage which initiated the outage. Possible Values: Anchor/guy, Capacitor bank, Conductor, Connector device, Crossarm, Fuse, Insulator and bushing, Lightning arrester, Pole, Recloser, Relay, Sectionalizer, Splice, Switch, Tap, Tie wire, Transformer, Voltage regulator/booster, N/A, Unknown, Other – See comment.DomEquipmentFailuretrue
DamagedDeviceCommentString50Damaged Device CommentDamaged device description not listed in the options above; or, any additional information about damaged device.true
ExpulsionFuseOperationString3Expulsion Fuse OperationDid an expulsion fuse operate during the outage? Enter N/A if the subject circuit is not equipped with expulsion type fuses. Possible values: Yes, No, N/A.DomYesNoNAtrue
OutageDescriptionString100Outage DescriptionDescription or additional information for the outage. Not required.true
EventYearInteger4Event YearThe year outage started. Use four digits.true
OutageStartDateTimeDate8Outage Start Date and TimeThe date and time outage started. Leave blank if unknown.true
OutageEndDateTimeDate8Outage End Date and TimeThe date and time of full restoration.true
OutageDurationSingle4Outage DurationThe total time to restore all customers, from the first customer out, in minutes.true
CustomerMinutesInterruptedSingle4Customer-Minutes InterruptedTotal customer-minutes interrupted associated with the outage. Not more than two decimal places.true
CustomersOutMomentaryInteger4Customers Out MomentaryTotal number of unique customers that experienced an outage lasting 5 minutes or less. Note: utility may use a different definition of “momentary” – if so, specify in the “OutageIntervalAlternativeDefinition” field.true
CustomersOutSustainedInteger4Customers Out SustainedTotal number of unique customers that experienced an outage lasting longer than 5 minutes. Note: utility may use a different definition of “momentary” – if so, specify in the “OutageIntervalAlternativeDefinition” field.true
CustomerCountInteger4Customer CountThe total number of customers impacted by the outage. May not be the sum of the values in the “CustomersOutSustained” and “CustomersOutMomentary” fields (some customers may experience both in the same event – do not double count).true
OutageIntervalString30Outage IntervalIndication of whether the subject outage was momentary (i.e., 5 minutes or less) or sustained (i.e., longer than 5 minutes). Possible values: Momentary, Sustained. Note: utility may use a different definition of “momentary” – if so, specify in the “OutageIntervalAlternativeDefinition” field.DomOutageIntervaltrue
OutageIntervalAlternativeDefinitionString30Outage Interval Alternative DefinitionIf the utility uses a different definition of “momentary” than specified above (5 minutes or less), specify the alternative definition here.true
AssociatedNominalVoltagekVString10Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
AssociatedOperatingVoltagekVString10Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
OtherCompaniesString150Other CompaniesCompanies (other than the electrical corporation submitting data) that had assets affected by the outage event. These may include telephone, internet, and other service providers with equipment on affected infrastructure, if any. Enter “NA” if no other companies were affected.true
OutageClassString30Outage ClassThe class of circuit involved in the outage. Required value: Distributiontrue
RecloserSettingString30Recloser SettingIf the subject circuit is equipped with reclosing capabilities, indicate whether the reclose function was enabled or disabled at the time of the outage. If the subject circuit is not equipped with reclosing capabilities, enter “N/A.” Possible values: Enabled, Disabled, N/A.DomRecloserSettingtrue
IsolationDeviceTypeString30Isolation Device TypeType of protective device that operated. Possible values: Circuit Breaker, Fuse, Lightning Arrester, Switch, Transformer, Recloser, Jumper, Other – See comment.DomIsolationDevicetrue
IsolationDeviceTypeCommentString30Isolation Device Type CommentIsolation device type description not listed in the options above.true
MajorEventDayString3Major Event DayIf all outages on a certain date exceed a statistical limit called Major Event Day (MED), this flag is set against outages associated with that day and typically excluded from certain types of reports. Possible values: Yes, No.DomYesNotrue
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
LocationOrAddressString100Location or AddressAddress or location description for the outage location.true
CountyString50CountyCounty where the outage event occurred.true
DistrictString100DistrictOperating district where the outage event occurred.true
LatitudeSingle4LatitudeLatitude of event point (in decimal degrees). Field-calculate in GIS software.true
LongitudeSingle4LongitudeLongitude of event point (in decimal degrees). Field-calculate in GIS software.true


SCE_DistributionVegetationCausedUnplannedOutage_20210501 - FeatureClass

NameSCE_DistributionVegetationCausedUnplannedOutage_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Distribution Vegetation Caused Unplanned Outage 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_DistributionVegetationCausedUnplannedOutage_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
DvmOutageIDString50VM Outage IDThe unique ID for distribution outage caused by vegetation. Primary key for the Distribution Vegetation Caused Unplanned Outage feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
DoutageIDString50Distribution Outage IDForeign key to the Distribution Unplanned Outage feature class attribute table.true
VmOutageDescriptionString100VM Outage DescriptionDescription or additional information for the outage event.true
InspectionDateDate8Inspection DateDate of inspection. Leave blank if unknown.true
VegetationSpeciesString100Vegetation SpeciesSpecies of vegetation involved in causing the outage.true
TreeHeightInteger4Tree Height (feet)If a tree was involved with the outage, enter a height estimate (in feet). If a tree was not involved with the outage, enter “N/A.” Maximum value: 300.DomTreeHeighttrue
TreeDiameterInteger4Tree Diameter (inches)If a tree was involved with the outage, enter tree diameter at breast height (in inches). If a tree was not involved with the outage, enter “N/A.” Maximum value: 180.DomTreeDiametertrue
TreeTrunkDistanceInteger4Tree Trunk Distance (feet)If a tree was involved with the outage, enter the horizontal distance (in feet) of the tree’s trunk from the impacted power lines. If a tree was not involved with the outage, enter “N/A.”true


SCE_Ignition_20210501 - FeatureClass

NameSCE_Ignition_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Ignition 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_Ignition_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
IgnitionIDString50Ignition IDUnique ID for the ignition event. Primary key for the Ignition feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
SubstationIDString50Substation IDUnique ID of the substation supplying the involved circuit. Foreign key to Substation feature class attribute table.true
NearestWeatherStationIDString50Nearest Weather Station IDUnique ID of weather station closest to the ignition location. Foreign key to the Weather Station feature class attribute table.true
ToutageIDString50Transmission Outage IDA unique ID for the transmission outage event. Foreign key to the Transmission Outage feature class attribute table.true
DoutageIDString50Distribution Outage IDA unique ID for the distribution outage event. Foreign key to the Distribution Outage feature class attribute table.true
FireStartDateTimeDate8Fire Start Date and TimeDate and time ignition started. Leave blank if unknown.true
FireStartYearInteger4Fire Start YearThe year that the risk event occurred. Use four digits.true
FireDetectionMethodString30Fire Detection MethodThe method by which the utility first learned of the ignition event. Possible values: Public, Satellite, Camera, Utility staff, Fire agency, Other – See comment.DomFireDetectionMethodtrue
FireDetectionMethodCommentString30Fire Detection Method CommentFire detection method description not listed in the options above.true
SuspectedInitiatingCauseString30Suspected Initiating CauseThe suspected initiating event of the ignition. Possible values: Object contact, Equipment failure, Wire-to-wire contact, Contamination, Normal operation, Vandalism/theft, Lightning, Unknown, Other – See comment.DomCausetrue
SuspectedInitiatingCauseCommentString30Suspected Initiating Cause CommentSuspected initiating event of the ignition cause description not listed in the options above.true
ObjectContactString30Object ContactDescription of object involved in contact if “Object contact” is the value of the “SuspectedInitiatingCause” field. If “Object contact” is not the value of the “SuspectedInitiatingCauset” field, enter “N/A.” Possible values: Vegetation contact, Animal contact , Balloon contact, Vehicle contact - car pole, Vehicle contact - aircraft, 3rd party facility, Unknown, N/A.DomObjectContacttrue
ObjectContactCommentString30Object Contact CommentDescription of object contact not listed in the options above; or, any additional information about object contact.true
EquipmentFailureString30Equipment FailureDescription of failed or damaged equipment or component involved if “SuspectedWireDownCause” value is “Equipment failure.” Enter N/A for this field if the value of “SuspectedWireDownCause” is not “Equipment failure.” Possible values: Anchor/ guy, Capacitor bank, Conductor, Connector device, Crossarm, Fuse, Insulator and bushing, Lightning arrester, Pole, Recloser, Relay, Sectionalizer, Splice, Switch, Tap, Tie wire, Transformer, Voltage regulator/booster, Unknown, Other – See comment., N/A.DomEquipmentFailuretrue
AssociatedNominalVoltagekVString10Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
AssociatedOperatingVoltagekVString10Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
SubstationNameString50Substation NameName of the substation supplying the involved circuit.true
OtherCompaniesString50Other CompaniesCompanies (other than the electrical corporation submitting data) that had assets affected by the ignition event. These may include telephone, internet, and other service providers with equipment on affected infrastructure, if any. Enter “NA” if no other companies were affected.true
EquipmentTypeString30Equipment TypeThe type of equipment involved in the ignition event. Possible values: Overhead, Pad-mounted, Subsurface.DomEquipmentTypetrue
DeterminationString30DeterminationThe entity relied upon to make the determination of “SuspectedInitiatingCause” above. Possible values: Utility personnel, Fire Agency, Other – See comment.DomDeterminationtrue
DeterminationCommentString50Determination CommentDetermination entity description not listed in the options above.true
FacilityContactedString50Facility ContactedThe first facility that was contacted by an outside object. Only to be used if “Object contact” is selected as the value of the “SuspectedInitiatingCauseEvent” field. Note: "Support structure" refers to the pole, tower, or other structure holding up conductor lines or other assets. Possible values: Bushing mounted cutout, Capacitor bank, Communications line, Conductor - Primary, Conductor - Secondary, Conductor – Transmission, Crossarm, Fuse, Guy/span wire, Insulator, Jumper, Support structure, Pothead, Recloser, Riser, Service connector, Service drop, Splice/clamp/connector, Switch, Tie wire, Transformer, Voltage regulator, Other - See comment.DomFacilityContactedtrue
FacilityContactedCommentString150Facility Contacted CommentAny contacted facility that does not fall in the list above. If multiple facilities from the list above were contacted, list them here.true
ContributingFactorString30Contributing FactorFactors suspected as contributing to the ignition. Possible values: Weather, External Force, Human Error, Unknown, Other – See comment.DomContributingFactortrue
ContributingFactorCommentString30Contributing Factor CommentContributing factor description not listed in the options above.true
RFWStatusString3Red Flag Warning StatusWas there a red flag warning (RFW) issued by the National Weather Service (NWS) in effect at the ignition location at the time of ignition? Possible values: Yes, No.DomYesNotrue
RFWIssueDateTimeDate8Red Flag Warning Issue Date and TimeThe date and time when the NWS issued the RFW in effect at the ignition location at the time of the ignition. Leave blank if there was no RFW in effect at the time of ignition at the ignition location. Also leave blank if unknown.true
FWWStatusString3Fire Weather Watch StatusWas there a fire weather watch (FWW) issued by the National Weather Service (NWS) in effect at the ignition location at the time of ignition? Possible values: Yes, No.DomYesNotrue
FWWIssueDateTimeDate8Fire Weather Watch Issue Date and TimeThe date and time when the NWS issued the HWW in effect at the ignition location at the time of the ignition. Leave blank if there was no HWW in effect at the time of ignition at the ignition location. Also leave blank if unknown.true
HWWStatusString3High Wind Warning StatusWas there a high wind warning (HWW) issued by the National Weather Service (NWS) in effect at the ignition location at the time of ignition? Possible values: Yes, No.DomYesNotrue
HWWIssueDateTimeDate8High Wind Warning Issue Date and TimeThe date and time when the NWS issued the HWW in effect at the ignition location at the time of the ignition event. Leave blank if there was no HWW in effect at the time of ignition at the ignition location. Also leave blank if unknown.true
OriginLandUseString10Origin Land UseStatus of land at origin of ignition. Possible values: Rural, Urban. Urban is defined as more than 1,000 people per square mile using U.S. Census data at at least the tract level. All other areas will be considered rural.DomLandUsetrue
MaterialAtOriginString30Material At OriginFuel material for the ignition origin. Possible values: Vegetation, Structure, Other – See comment.DomMaterialAtOrigintrue
MaterialAtOriginCommentString30Material At Origin CommentType of fuel bed existing at the damage location. Possible values: Fire-resistive fuel bed - Fuel bed not conducive to propagating fire where damage occurred (e.g. asphalt, concrete, gravel, etc.). Grass fuel model - Fuel bed comprised of annual grasses where damaged occurred. Brush fuel model - Fuel bed comprised of mainly brush or shrubs where damage occurred (e.g. chamise, manzanita, chaparral, scotch broom, etc.). Timber fuel model - Fuel bed comprised of a timber where damaged occurred (e.g. forests, timber litter, logging slash, etc.). Other – See comment.true
FuelBedDescriptionString100Fuel Bed DescriptionType of fuel bed existing at the damage location. A fire-resistive fueld bed is not conducive to propagating fire where damage occurred (e.g. asphalt, concrete, gravel, etc.). A grass fuel model is comprised of annual grasses where damaged occurred. A brush fuel model is comprised of mainly brush or shrubs where damage occurred (e.g., chamise, manzanita, chaparral, scotch broom, etc.). A timber fuel model is comprised of a timber where damaged occurred (e.g. forests, timber litter, logging slash, etc.). Possible values: Fire-resistive fuel bed, Grass fuel model, Brush fuel model, Timber fuel model, Other – See comment.DomFuelBedDescriptiontrue
FuelBedDescriptionCommentString100Fuel Bed Description CommentFuel bed description not listed in the options above.true
FireSizeString30Fire SizeSize, in acres unless otherwise indicated, of fire resulting from the ignition. Possible values: Structure-only, <3 meters of linear travel, <0.25, 0.26-9.99, 10-99, 100-299, 300-999, 1,000-4,999, >5,000,Unknown.DomFireSizetrue
SuppressedByString30Suppressed ByEntity responsible for suppressing ignition. Possible values: Customer, Fire agency, Self-extinguished, Utility, Unknown.DomSuppressedBytrue
SuppressingAgencyString30Suppressing AgencyIf the “SupressedBy” field has the value of “Fire Agency”, enter the fire department name.true
FireInvestigationString30Fire InvestigationWhether the fire authority having jurisdiction investigated the ignition and the status of the investigation. Possible values: Yes – Complete, Yes – Pending, No.DomFireInvestigationtrue
FireAHJString100Fire Authority Having JurisdictionIf there was an investigation of the ignition by a fire authority having jurisdiction, enter the fire agency name.true
OutageStatusString3Outage StatusWas there an outage associated with the event? Possible values: Yes, No.DomYesNotrue
IgnitionNotesString100Ignition NotesAdditional information regarding the ignition event. All additional data fields collected by the utility that are not included in this ignition schema shall be included in this field. This field is not required; if the utility does not collect any additional information, it may be left blank.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty where the ignition event occurred.true
DistrictString100DistrictOperating district where the ignition occurred.true
LatitudeSingle4LatitudeLatitude of event point (in decimal degrees). Field-calculate in GIS software.true
LongitudeSingle4LongitudeLongitude of event point (in decimal degrees). Field-calculate in GIS software.true


SCE_TransmissionUnplannedOutage_20210501 - FeatureClass

NameSCE_TransmissionUnplannedOutage_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Transmission Unplanned Outage 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_TransmissionUnplannedOutage_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
ToutageIDString50Transmission Outage IDThe unique ID for outage event. Primary key for the Transmission Unplanned Outage feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
SubstationIDString50Substation IDUnique ID for the source substation feeding the circuit impacted by the outage. Must be traceable stable ID within a specific asset class. Foreign key to Substation feature class attribute table.true
BasicCauseString30Basic CauseHigh-level category for conductor damage cause. Possible values: Object contact, Equipment failure, Wire-to-wire contact, Contamination, Utility work/operation, Vandalism/theft, Unknown, Other – See commentDomCausetrue
BasicCauseCommentString50Basic Cause CommentBasic cause description not listed in the options above; or, any additional information regarding cause (unless additional info is regarding object contact or equipment failure, which have their own comment fields).true
BasicCauseObjectString30Basic Cause ObjectDescription of object involved in contact. Only applicable if the "BasicCause" field has the value of "Object contact." If this is not the case, choose “N/A.” If the object involved in the contact is not in the list below, use the "Other - See comment" value and input an appropriate comment in the “BasicCauseObjectComment” field. Possible values: Vegetation, Animal, Balloon, Vehicle contact – car pole, Vehicle contact – aircraft, 3rd party facility, Unknown, N/A, Other – See comment.DomObjectContacttrue
BasicCauseObjectCommentString50Basic Cause Object CommentBasic cause object description not listed in the options above; or, any additional information about object contact.true
DamagedDeviceString30Damaged DeviceThe device type that failed or experienced the damage that initiated the outage. Only applicable if the "BasicCause" field has the value of "Equipment failure." If this is not the case, choose “N/A.” If the device involved in the equipment failure is not in the list below, use the "Other - See comment" value and input an appropriate comment in the “DamagedDeviceComment” field. Possible values: Anchor/guy, Capacitor bank, Conductor, Connector device, Crossarm, Fuse, Insulator and bushing, Lightning arrester, Pole, Recloser,Relay,Sectionalizer, Splice, Switch, Tap, Tie wire, Transformer, Voltage regulator/booster, Unknown, N/A, Other - See comment.DomEquipmentFailuretrue
DamagedDeviceCommentString50Damaged Device CommentDamaged device description not listed in the options above; or, any additional information about damaged device.true
ExpulsionFuseOperationString3Expulsion Fuse OperationDid an expulsion fuse operate during the outage? Enter “N/A” if the subject circuit is not equipped with expulsion type fuses. Possible values: Yes, No, N/A.DomYesNoNAtrue
OutageDescriptionString100Outage DescriptionDescription or additional information for the outage. Not required.true
EventYearInteger4Event YearThe year outage started. Use four digits.true
OutageStartDateTimeDate8Outage Start Date and TimeThe date and time outage started. Leave blank if unknown.true
OutageEndDateTimeDate8Outage End Date and TimeThe date and time of full restoration.true
OutageDurationSingle4Outage DurationThe total time to restore all customers, from the first customer out, in minutes.true
CustomerMinutesInterruptedSingle4Total Customer-Minutes InterruptedTotal customer-minutes interrupted associated with the outage. Do not more than two decimal places.true
CustomersOutMomentaryInteger4Customers Out MomentaryTotal number of unique customers that experienced an outage lasting 5 minutes or less. Note: electrical corporation may use a different definition of “momentary” – if so, specify in the “OutageIntervalAlternativeDefinition” field.true
CustomersOutSustainedInteger4Customers Out SustainedTotal number of unique customers that experienced an outage lasting longer than 5 minutes. Note: utility may use a different definition of “momentary” – if so, specify in the “OutageIntervalAlternativeDefinition” field.true
CustomerCountInteger4Customer CountThe total number of customers impacted by the outage. May not be the sum of the values in the “CustomersOutSustained” and “CustomersOutMomentary” fields (some customers may experience both in the same event – do not double count).true
OutageIntervalString30Outage IntervalIndication of whether the subject outage was momentary (i.e., 5 minutes or less) or sustained (i.e., longer than 5 minutes). Possible values: Momentary, Sustained. Note: utility may use a different definition of “momentary” – if so, specify in the “OutageIntervalAlternativeDefinition” field.DomOutageIntervaltrue
OutageIntervalAlternativeDefinitionString30Outage Interval Alternative DefinitionIf the utility uses a different definition of “momentary” than specified above (5 minutes or less), specify the alternative definition here.true
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Voltage (in kilovolts) associated with outage. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
OtherCompaniesString150Other CompaniesCompanies (other than the electrical corporation submitting data) that had assets affected by the outage event. These may include telephone, internet, and other service providers with equipment on affected infrastructure, if any. Enter “NA” if no other companies were affected.true
OutageClassString30Outage ClassThe class of circuit involved in the outage. Required value: Transmissiontrue
RecloserSettingString30Recloser SettingIf the subject circuit is equipped with reclosing capabilities, indicate whether the reclose function was enabled or disabled at the time of the outage. If the subject circuit is not equipped with reclosing capabilities, enter “N/A.” Possible values: Enabled, Disabled, N/A.DomRecloserSettingtrue
IsolationDeviceTypeString30Isolation Device TypeType of protective device that operated. Possible values: Circuit breaker, Fuse, Lightning arrester, Switch, Transformer, Recloser, Jumper, Other – See comment.DomIsolationDevicetrue
IsolationDeviceTypeCommentString30Isolation Device Type CommentIsolation device type description not listed in the options above.true
MajorEventDayString3Major Event DayIf all outages on a certain date exceed a statistical limit called Major Event Day (MED), this flag is set against outages associated with that day and typically excluded from certain types of reports. Possible values: Yes, No.DomYesNotrue
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
LocationOrAddressString100Location or AddressAddress or location description for the outage location.true
CountyString50CountyCounty where the outage event is located.true
DistrictString100DistrictOperating district where the outage event occurred.true
LatitudeSingle4LatitudeLatitude of event point (in decimal degrees). Field-calculate in GIS software.true
LongitudeSingle4LongitudeLongitude of event point (in decimal degrees). Field-calculate in GIS software.true


SCE_TransmissionVegetationCausedUnplannedOutage_20210501 - FeatureClass

NameSCE_TransmissionVegetationCausedUnplannedOutage_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Transmission Vegetation Caused Unplanned Outage 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_TransmissionVegetationCausedUnplannedOutage_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
TvmOutageIDString50Transmission VM Outage IDThe unique ID for an outage caused by vegetation. Primary key for the Transmission VM Outage feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
ToutageIDString50Transmission Outage IDForeign key to the Transmission Outage feature class attribute table.true
VmOutageDescriptionString100VM Outage DescriptionDescription or additional information for the outage event.true
InspectionDateDate8Inspection DateDate of inspection. Leave blank if unknown.true
VegetationSpeciesString100Vegetation SpeciesSpecies of the vegetation involved in causing the outage.true
TreeHeightInteger4Tree Height (feet)If a tree was involved with the outage, enter a height estimate (in feet). If a tree was not involved with the outage, enter “-99” Maximum value: 300. DomTreeHeighttrue
TreeDiameterInteger4Tree Diameter (inches)If a tree was involved with the outage, enter tree diameter at breast height (in inches). If a tree was not involved with the outage, enter “-99” Maximum value: 180.DomTreeDiametertrue
TreeTrunkDistanceInteger4Tree Trunk Distance (feet)If a tree was involved with the outage, enter the horizontal distance (in feet) of the tree’s trunk from the impacted power lines. If a tree was not involved with the outage, enter “-99”true


SCE_WireDownEvent_20210501 - FeatureClass

NameSCE_WireDownEvent_20210501
ShapeTypePoint
FeatureTypeSimple
AliasNameSCE Wire Down Event 20210501
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionSCE_WireDownEvent_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
WireDownIDString50Wire Down IDUnique ID for the wire down event. Primary key for the Wire Down Event feature class attribute table.true
UtilityIDString10Utility IDStandardized identification name of the utility (e.g., “UtilityG+E”).true
ToutageIDString50Transmission Outage IDA unique ID for the transmission outage event. Foreign key to the Transmission Outage feature class attribute table.true
DoutageIDString50Distribution Outage IDA unique ID for the distribution outage event. Foreign key to the Distribution Outage feature class attribute table.true
WireDownDateDate8Wire Down DateThe start date of the wire down event. Leave blank if unknown.true
WireDownYearInteger4Wire Down YearThe year that the risk event occurred. Use four digits.true
CauseString30CauseHigh-level category for conductor damage cause. Possible values: Object contact, Equipment failure, Wire-to-wire contact, Contamination, Utility work/operation, Vandalism/theft, Lightning, Unknown, Other – See commentDomCausetrue
CauseCommentString30Cause CommentWire down cause description not listed in the options above.true
ObjectContactString30Object ContactDescription of object involved in the contact if the value of “SuspectedWireDownCause” is “Object contact.” Enter "N/A" for this field if the value of “SuspectedWireDownCause” is not “Object contact.” Note: An example of 3rd party contact would be a 3rd party tree trimmer. Possible values: Vegetation contact, Animal contact, Balloon contact, Vehicle contact - car pole, Vehicle contact - aircraft, 3rd party facility, Unknown, N/A.DomObjectContacttrue
EquipmentFailureString30Equipment FailureDescription of failed or damaged equipment or component involved if “SuspectedWireDownCause” value is “Equipment failure.” Enter N/A for this field if the value of “SuspectedWireDownCause” is not “Equipment failure.” Possible values: Anchor/ guy, Capacitor bank, Conductor, Connector device, Crossarm, Fuse, Insulator and bushing, Lightning arrester, Pole, Recloser, Relay, Sectionalizer, Splice, Switch, Tap, Tie wire, Transformer, Voltage regulator/booster, Unknown, Other – See comment, N/A.DomEquipmentFailuretrue
EquipmentFailureCommentString30Equipment Failure CommentEquipment failure description not listed in the options above.true
AssociatedNominalVoltagekVString10Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
AssociatedOperatingVoltagekVString10Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
SpanLengthSingle4Span Length (feet)The length of a single-phase conductor, in feet, as measured between the “FromDevice” and “ToDevice” assets.true
TotalSplicesInteger4Total SplicesThe total number of splices in the span of conductor involved in the wire down event. In the event of wire down events occurring over multiple spans, include the total number of splices in all failed spans.true
MaxSplicesInteger4Maximum SplicesThe maximum number of splices in an individual phase conductor involved in the wire down event.true
MultipleDownString3Multiple DownWas more than one span of conductors impacted by the wire down event? Possible values: Yes, No.DomYesNotrue
ConductorMaterialString50Conductor MaterialConductor material. Possible values: All aluminum conductor (AAC), All aluminum alloy conductor (AAAC), Aluminum conductor aluminum reinforced (ACAR), Aluminum conductor steel reinforced (ACSR), Aluminum conductor steel supportes (ACSS), Copper (Cu), Other – See comment.DomConductorMaterialtrue
ConductorMaterialCommentString50Conductor Material CommentConductor material description not listed in the options above.true
ConductorSizeString30Conductor SizeSize (e.g. No. 4, 1/0, etc.) of the conductor involved in the incident, in AWG or KCMIL.true
ConductorODSingle4Conductor Overall Diameter (inches)Overall diameter of the conductor, in inches.true
ConductorRatingSingle4Conductor RatingThe nominal ampacity rating of the conductor involved in the wire down event in amperes.true
OutageStatusString3Outage StatusWas there an outage associated with the event? Possible values: Yes, No.DomYesNotrue
EnergizedString10EnergizedWas the conductor energized while in contact with a grounded object during the event? If the wire down event did not result in contact with a grounded object, then enter ""N/A"" for this field. Possible values: Yes, No, Unknown.DomYesNoUnknownNAtrue
IgnitionStatusString3Ignition StatusWas there an ignition associated with the wire down event? Possible values: Yes, No.DomYesNotrue
WireDownNotesString100Wire Down NotesAdditional information or notes available for the wire down event and not captured in other fields.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. For this data, anything outside Tiers 2 and 3 must be categorized as “Non-HFTD.” Do not record any Zone 1 or Tier 1 values. Possible values: Tier 3, Tier 2, Non-HFTD. HFTD data can be downloaded from: https://ia.cpuc.ca.gov/firemap.DomHFTDtrue
CountyString50CountyCounty where the wire down event ocurred.true
DistrictString100DistrictOperating district where the wire down occurred.true
LatitudeSingle4LatitudeLatitude of event point in decimal degrees. Field-calculate in GIS software.true
LongitudeSingle4LongitudeLongitude of event point in decimal degrees. Field-calculate in GIS software.true



SCE_AssetInspectionLog_20210501 - Table

NameSCE_AssetInspectionLog_20210501
AliasNameSCE Asset Inspection Log 20210501
HasAttachmentsfalse
DescriptionSCE_AssetInspectionLog_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AiLogIDString50AI Log IDUnique ID or job ID of an asset inspection activity. Primary key for the Asset Inspection related table.true
VmpLogIDString50VMP Log IDUnique ID or job ID of a vegetation management project resulting from an asset inspection. A foreign key to the Vegetation Management Project related table. Enter the corresponding VmpID if the subject asset inspection resulted in the creation of a vegetation management project. If the asset inspection did not result in the creation of a related vegetation management project, then enter “N/A” for this field.true
InspectionStartDateDate8Inspection Start DateThe date when an asset inspection began. If exact date is not known, may approximate as first day of the month in which inspection began.true
InspectionEndDateDate8Inspection End DateThe date when an asset inspection was completed. If the asset inspection was started and completed on the same day, “InspectionStartDate” and “InspectionEndDate” will have the same value. If exact date is not known, may approximate as last day of the month in which inspection was completed.true
PerformedByString30Performed ByWho performed the asset inspection? Possible values: Utility staff, Contractor, Other – See comment.DomPerformedBytrue
PerformedByCommentString30Performed By CommentInspector description not listed in the options above.true
InspectionTypeString30Inspection TypeThe type of asset inspection performed. Possible values: Patrol, Detailed, Pole loading, Other – See comment.DomInspectionTypetrue
InspectionTypeCommentString30Inspection Type CommentInspection type description not listed in the options above.true
InspectionQAString3Inspection QAHas the inspection been checked for quality assurance? Possible values: Yes, No.DomYesNotrue
InspectionCommentString100Inspection CommentAdditional comments related to the asset management inspection.true
ComplianceFindingString3Compliance FindingDid the asset inspection result in the finding of any non-compliance issues? Possible values: Yes, No.DomYesNotrue
InspectionMethodString100Inspection MethodThe method(s) by which the asset inspection was conducted. Possible values: Ground Inspection, Aerial – drone, Aerial – helicopter, Remote sensing – imagery, Remote sensing – LiDAR, Other – See comment.DomInspectionMethodtrue
InspectionMethodCommentString50Inspection Method CommentInspection method not listed in the options above—or multiple inspection methods listed in the options above. If multiple, list all values separated by commas.true
InspectionTechnologyString30Inspection TechnologyThe technology that an inspector uses for the asset inspection project. Possible values: Collector for ArcGIS, Survey123 for ArcGIS, Workforce for ArcGIS, ArcGIS QuickCapture, Other – See comment.DomInspectionTechnologytrue
InspectionTechnologyCommentString30Inspection Technology CommentInspection technology not listed in the options above.true

SCE_GridHardeningLog_20210501 - Table

NameSCE_GridHardeningLog_20210501
AliasNameSCE Grid Hardening Log 20210501
HasAttachmentsfalse
DescriptionSCE_GridHardeningLog_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
GhLogIDString50GH Log IDUnique ID or job ID of a grid hardening activity. Primary key for the Grid Hardening Log related table.true
AiLogIDString50AI Log IDUnique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection Log related table.true
GhChangeOrderString3GH Change OrderHas a change order been requested for this grid hardening initiative since the approval of the utility’s previous WMP? Possible values: Yes, No.DomYesNotrue
GhChangeOrderDateDate8GH Change Order DateDate the change order was submitted. Leave blank if unknown.true
GhChangeOrderTypeString30GH Change Order TypeThe type of change order requested. Possible values: Increase in scale, Decrease in scale, Change in prioritization, Change in deployment timing, Change in work being done, Other change – See comment.DomGhChangeOrderTypetrue
GhChangeOrderTypeCommentString100Gh Change Order Type CommentChange order type not listed above.true
StartDateDate8Date StartStart date of the grid hardening project. If exact date is not known, may approximate as first day of the month in which project began.true
EndDateDate8Date EndCompletion date of the grid hardening project. If exact date is not known, may approximate as last day of month in which project was completed. Not required for projects which are in progress.true
LineDeenergizedString3Line DeenergizedLines need to be de-energized to perform the work. Possible values: Yes, No.DomYesNotrue
PerformedByString30Performed ByWho performed the grid hardening activity? Possible values: Utility staff, Contractor, Other – See comment.DomPerformedBytrue
PerformedByCommentString30Performed By CommentEntity that performed grid hardening and is not listed in options above.true

SCE_InitiativePhotoLog_20210501 - Table

NameSCE_InitiativePhotoLog_20210501
AliasNameSCE Initiative Photo Log 20210501
HasAttachmentsfalse
DescriptionSCE_InitiativePhotoLog_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PhotoIDString100Photo IDName for a photo showing an initiative or inspection findings. A primary key for the Initiative Photo Log related table.true
PhotoBeforeIDString100Photo Before IDName for a photo showing the initiative location prior to the project happening or prior to a corrective action taking place. A primary key for the Initiative Photo Log related table.true
PhotoAfterIDString100Photo After IDName for a photo showing the initiative location after a project happens or after a corrective action takes place. A primary key for the Initiative Photo Log related table.true
VmpIDString50VMP IDUnique ID or job ID of an initiative. Foreign key to the Vegetation Management Project Point, Line and Polygon feature class attribute tables. This value can be repeated based on the number of photos taken.true
VmiIDString50VMI IDUnique ID or job ID of a vegetation management inspection activity. Foreign key to the Vegetation Management Inspection Point, Line, and Polygon feature class attribute tables. This value can be repeated based on the number of photos taken.true
AiIDString50AI IDUnique ID or job ID of an asset inspection activity. Primary key for the Asset Inspection Log related table. This value can be repeated based on the number of photos taken.true
GhIDString50GH IDUnique ID or job ID of a grid hardening activity. Foreign key to the Grid Hardening Point and Line feature class attribute tables. This value can be repeated based on the number of photos taken.true
OiIDString50OI IDUnique ID or job ID of an other initiative activity. Foreign key to the Other Initiative Point, Line, and Polygon feature class attribute tables. This value can be repeated based on the number of photos taken.true
FromDeviceIDString50From Device IDThe asset ID for a support structure upstream of an initiative location. This field is to be filled out to help locate initiatives that are along conductor lines or within a polygon based on conductor lines.true
ToDeviceIDString50To Device IDThe asset ID for a support structure downstream of an initiative location. This field is to be filled out to help locate initiatives that are along conductor lines or within a polygon based on conductor lines.true

SCE_OtherInitiativeLog_20210501 - Table

NameSCE_OtherInitiativeLog_20210501
AliasNameSCE Other Initiative Log 20210501
HasAttachmentsfalse
DescriptionSCE_OtherInitiativeLog_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
OiLogIDString50OI Log IDUnique ID or job ID of other initiative activity. Primary key for the Other Initiative Log related table.true
StartDateDate8Date StartThe start date of the activity. If exact date is not known, may approximate as first day of the month in which project began.true
EndDateDate8Date EndThe completion date of the activity. If exact date is not known, may approximate as last day of month in which project was completed. Not required for projects which are in progress.true
OiCommentString100Other Initiative CommentAny other information about the activity.true

SCE_PspsEventConductorDamageDetail_20210501 - Table

NameSCE_PspsEventConductorDamageDetail_20210501
AliasNameSCE PSPS Event Conductor Damage Detail 20210501
HasAttachmentsfalse
DescriptionSCE_PspsEventConductorDamageDetail_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PspsCdIDString50PSPS Conductor Damage IDPrimary key for the PSPS Event Conductor Damage Detail related table.true
DamageEventIDString50Damage Event IDID value for an individual PSPS event. Event ID values for damage points should match event ID values in corresponding PSPS event GIS data. Foreign key enabling connection to the PSPS Event Damage Pointfeature class attribute table.true
CircuitIDString50Circuit IDUnique ID for a specific circuit. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the related asset line feature class attribute tables.true
FromDeviceIDString50From Device IDThe upstream support structure asset ID. Foreign key to the related asset point feature class attribute tables. AKA AssetID.true
ToDeviceIDString50To Device IDThe downstream support structure asset ID. Foreign key to the related asset point feature class attribute tables. AKA AssetID.true
FeederIDString50Feeder IDCircuit/feeder ID for the damaged span of line. Foreign key to the related asset line feature class attribute tables.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation feature class attribute table.true
DamageDateTimeDate8Date and Time of DamageDate and time or estimated date and time damage occurred.true
AssetString10AssetSpecific type of asset that is damaged. Required value: Conductortrue
NominalVoltagekVString10Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
OperatingVoltagekVString10Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
ConductorMaterialString50Conductor MaterialConductor material. Possible values: All aluminum conductor (AAC), All aluminum alloy conductor (AAAC), Aluminum conductor aluminum reinforced (ACAR), Aluminum conductor steel reinforced (ACSR), Aluminum conductor steel supportes (ACSS), Copper (Cu), Other – See comment.DomConductorMaterialtrue
ConductorMaterialCommentString50Conductor Material CommentConductor material not listed in the options above.true
ConductorTypeString30Conductor TypeType of conductor. Possible values: Bare, Covered, Other - See comment.DomConductorTypetrue
ConductorTypeCommentString50Conductor Type CommentConductor type not listed above.true
ConductorLengthSingle4Conductor Length (feet)Conductor length in feet based on GIS data.true
FailedEquipmentDescriptionString100Failed Equipment DescriptionEquipment that contributed to the conductor damage. Write “Unknown” or “N/A” as appropriate.true
ExternalForceDescriptionString100External Force DescriptionForce responsible for causing the conductor damage.true
SubstationNameString50Substation NameName of substation associated with asset.true
SubstationTypeString10Substation TypeType of substation. Possible values: Radial, Loop, Network.DomSubstationTypetrue
CauseString30CauseHigh-level category for conductor damage cause. Possible values: Object contact, Equipment failure, Wire-to-wire contact, Contamination, Utility work/operation, Vandalism/theft, Unknown, Other – See commentDomCausetrue
CauseCommentString30Cause CommentCause category not listed in options above.true
EnergizedOnGroundString10Energized On GroundDid the damaged conductor make contact with the ground while energized? Possible values: Yes, No, Unknown.DomYesNoUnknowntrue
ManufacturerModelIDString50Manufacturer Model IDThe manufacturer and asset model specifications that would enable one to identify exactly what type of equipment was involved with the damage. Do not use acronyms or abbreviations for this field. Fully spell out the manufacturer and model names. If some sort of model or part code/name is not available, at least record the manufacturer name. Write "Unknown" if no manufacturer info can be determined based on information available in the field. “Unknown” values should be reviewed by other electrical corporation staff after data collection and filled in from existing databases or other sources if possible.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Note: Only enter "N/A" if there is an "InstallationDate" value or "InstallationYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset would have been expected to have a useful functioning existence prior to damage. If unknown, enter “-99.”true
LikelyArcingString10Likely ArcingWas arcing likely because of the damage? Possible values: Yes, No, Unknown.DomYesNoUnknowntrue
DamageTypeString30Damage TypeType of damage sustained. Possible values: Asset damage, Asset failure, Equipment damage, Equipment failure, Veg contact, Object contact.DomDamageTypetrue
DamageDescriptionString30Damage DescriptionDescription of damage. Possible values: Broken conductor, Damaged conductor, Kite in line, Pine needles on line, Tree bark on line, Tree branch on line, Tree leaning into line, Tree leaning toward line, Wire-to-wire contact, Other – See comment.DomDamageDescriptiontrue
DamageDescriptionCommentString30Damage Description CommentDamage category not listed in the options above and/or additional relevant details about damagetrue

SCE_PspsEventDamagePhotoLog_20210501 - Table

NameSCE_PspsEventDamagePhotoLog_20210501
AliasNameSCE PSPS Event Damage Photo Log 20210501
HasAttachmentsfalse
DescriptionSCE_PspsEventDamagePhotoLog_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
DamagedAssetPhotoIDString100Damaged Asset Photo IDName for a photo of the damaged asset. Enables damaged asset photos to be linked to GIS data. A primary key for the PSPS Damage Photo Log related table. Photos must be geotagged JPEG or PNG files. Use the following naming format: UtilityName _InspectorInitial_PspsDamage_YYYYMMDD_PhotoNumber. For example, “UtilityG+E_AB_PspsDamage_20200703_1.png”. If applicable/logical, an optional district ID value can be added between the utility name and inspector initial values (e.g., “UtilityName_DistrictID_InspectorInitial_PspsDamage_YYYYMMDD_PhotoNumber”).true
FuelBedPhotoIDString100Fuel Bed Photo IDName for a photo of the fuel bed below the damaged asset. Enables fuel bed photos to be linked to GIS data. A primary key for the PSPS Damage Photo Log related table. A primary key for the PSPS Damage Photo Log related table. Photos must be geotagged JPEG or PNG files. Use the following naming format: Use the following naming format: UtilityName _InspectorInitial_PspsDamageFuelBed_YYYYMMDD_PhotoNumber. For example, “UtilityG+E_AB_PspsDamage_20200703_1.png”. If applicable/logical, an optional district ID value can be added between the utility name and inspector initial values (e.g., “UtilityName_DistrictID_InspectorInitial_PspsDamageFuelBed_YYYYMMDD_PhotoNumber”).true
DamageEventIDString100Damage Event IDForeign key to the damage point feature class and damage detail related tables.true

SCE_PspsEventLog_20210501 - Table

NameSCE_PspsEventLog_20210501
AliasNameSCE PSPS Event Log 20210501
HasAttachmentsfalse
DescriptionSCE_PspsEventLog_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
EventIDString50Event IDA unique standardized identification name of the unique event. Primary key enabling connection to PSPS event feature class attribute tablestrue
EOCActivationDateTimeDate8EOC Activation Date and TimeDate and time electrical corporation’s emergency operation center (EOC) was activated.true
StartDateTimeDate8Start Date and TimeStart date and time of the PSPS event.true
AllClearDateTimeDate8All Clear Date and TimeDate and time that the weather event precipitating the PSPS event cleared the area, and the utility began inspection and restoration efforts. One value per record – if sub-areas of a single PSPS event were cleared at different times, create multiple records for that event.true
AllLoadUpDateTimeDate8All Load Up Date and TimeDate and time that the last customer (in the area represented by this record) was fully restored following the PSPS event. If there are multiple records for one PSPS event, this is not required to be the date/time of restoration for the last customer in the entire PSPS event.true
CountyString150CountyCounty in which asset is located. If the line crosses multiple counties, list all counties separated by commas.true
WindRiskString3Wind RiskWas high wind a driving risk factor in the PSPS decision? Possible values: Yes, No.DomYesNotrue
RelativeHumidityRiskString3Relative Humidity RiskWas low relative humidity a driving risk factor in the PSPS decision? Possible values: Yes, No.DomYesNotrue
TemperatureRiskString3Temperature RiskWas high temperature a driving risk factor in the PSPS decision? Possible values: Yes, No.DomYesNotrue
VegetationRiskString3Vegetation RiskWas a higher probability of vegetation interference a driving risk factor in the PSPS decision? Possible values: Yes, No.DomYesNotrue
AssetRiskString3Asset RiskWas a higher probability of asset failure a driving risk factor in the PSPS decision? Possible values: Yes, No.DomYesNotrue
DeadFuelRiskString3Dead Fuel RiskWas a high presence of dead fuel a driving risk factor in the PSPS decision? Possible values: Yes, No.DomYesNotrue
LiveFuelRiskString3Live Fuel RiskWas a high presence of live fuel a driving risk factor in the PSPS decision? Possible values: Yes, No.DomYesNotrue
RedFlagWarningRiskString3Red Flag Warning RiskWas the presence of a Red Flag Warning risk day a driving factor in the PSPS decision? Possible values: Yes, No.DomYesNotrue
OtherRiskString3Other RiskWas some other form of risk (not covered by the fields above) a driving risk factor in the PSPS decision? Possible values: Yes, No.DomYesNotrue
OtherRiskReasonString100Other Risk ReasonBrief description of what the “OtherRisk” category is if there is a “Yes” value under the “OtherRisk” field. Possible example statements include things like “vehicle collision,” “reported ignition,” etc. Enter “N/A” if the value for “OtherRisk” is “No.”true

SCE_PspsEventOtherAssetDamageDetail_20210501 - Table

NameSCE_PspsEventOtherAssetDamageDetail_20210501
AliasNameSCE PSPS Event Other Asset Damage Detail 20210501
HasAttachmentsfalse
DescriptionSCE_PspsEventOtherAssetDamageDetail_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PspsOadIDString50PSPS Other Asset Damage IDPrimary key for the PSPS Event Other Asset Damage Detail related table.true
DamageEventIDString50Damage Event IDID value for an individual PSPS event. Event ID values for damage points should match event ID values in corresponding PSPS event GIS data. Foreign key enabling connection to PSPS Event Damage Point feature class attribute table.true
AssetIDString50Asset IDUnique ID for a specific point asset. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the related asset point feature class attribute tables.true
FeederIDString50Feeder IDCircuit/feeder ID for the damaged span of line. Foreign to the related asset line feature class attribute tables.true
DamageDateTimeDate8Damage Date and TimeDate and time or estimated date and time damage occurred.true
AssetString30AssetSpecific type of asset that is damaged. This list of dropdown menu items should be modified by each electrical corporation to cover the assets most likely to be involved in PSPS damage. Possible values: Down guy , Neutral, Service neutral, Span guy, Tie wire, Wood pin, Anchor, Other – See comment.DomPspsOtherAssettrue
AssetCommentString30Asset CommentAsset not listed in the options above.true
CauseString30CauseHigh-level category for conductor damage cause. Possible values: Object contact, Equipment failure, Wire-to-wire contact, Contamination, Utility work/operation, Vandalism/theft, Lightning, Unknown, Other – See commentDomCausetrue
CauseCommentString30Cause CommentCause category not listed above.true
AssociatedNominalVoltagekVString10Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
AssociatedOperatingVoltagekVString10Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
ManufacturerModelIDString50Manufacturer Model IDThe manufacturer and asset model specifications that would enable one to identify exactly what type of equipment was involved with the damage. Do not use acronyms or abbreviations for this field. Fully spell out the manufacturer and model names. If some sort of model or part code/name is not available, at least record the manufacturer name. Write "Unknown" if no manufacturer info can be determined based on information available in the field. “Unknown” values should be reviewed by other electrical corporation staff after data collection and filled in from existing databases or other sources if possible.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value).DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset would have been expected to have a useful functioning existence prior to damage. If unknown, enter “-99.”true
ExemptionStatusString10Exemption StatusIs the asset exempt per California Public Resources Code (PRC) 4292? This field is especially important and a high priority for the WSD and the State of California. Non-exempt equipment requires support structure clearance. Possible values: Yes, No, Unknown, N/A.DomYesNoUnknownNAtrue
LikelyArcingString10Likely ArcingWas arcing likely because of the damage? Possible values: Yes, No, Unknown.DomYesNoUnknowntrue
DamageTypeString30Damage TypeType of damage sustained. Possible values: Asset damage, Asset failure, Equipment damage, Equipment failure, Veg contact, Object contact.DomDamageTypetrue
DamageDescriptionString30Damage DescriptionDescription of damage. Possible values: Broken down guy, Broken hand tie, Broken neutral, Broken service neutral, Broken guy wire, Broken tie wire, Broken tree branch near line, Broken pin, Broken insulator, Damaged crossarm, Guy and anchor damage, Tree branch on transformer, Other – See comment.DomOtherAssetDamageDescriptiontrue
DamageDescriptionCommentString30Damage Description CommentDamage category not listed in the options above and/or additional relevant details about damage.true

SCE_PspsEventSupportStructureDamageDetail_20210501 - Table

NameSCE_PspsEventSupportStructureDamageDetail_20210501
AliasNameSCE PSPS Event Support Structure Damage Detail 20210501
HasAttachmentsfalse
DescriptionSCE_PspsEventSupportStructureDamageDetail_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PspsSsdIDString50PSPS Support Structure IDPrimary key for the PSPS Event Support Structure Damage Detail related table.true
DamageEventIDString50Damage Event IDID value for an individual PSPS event. Event ID values for damage points should match event ID values in corresponding PSPS event GIS data. Foreign key enabling connection to PSPS Event Damage Point feature class attribute table.true
AssetIDString50Asset IDUnique ID for a specific point asset. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the related asset point feature class attribute tables.true
FeederIDString50Feeder IDCircuit/feeder ID for the damaged span of line. Foreign key to the related asset line feature class attribute tables.true
DamageDateTimeDate8Damage Date and TimeSpecific type of asset that is damaged. This list of dropdown menu items should be modified by each IOU to cover the assets most likely to be involved in PSPS damage. Possible values: Pole, Tower, Crossarm, Secondary arms, Other – See comment.true
AssetString30AssetSpecific type of asset that is damaged. This list of dropdown menu items should be modified by each IOU to cover the assets most likely to be involved in PSPS damage. Possible values: Pole, Tower, Crossarm, Secondary arms, Other – See commentDomPspsAssettrue
AssetCommentString30Asset CommentAsset not listed in the options above.true
CauseString30CauseHigh-level category for conductor damage cause. Possible values: Object contact, Equipment failure, Wire-to-wire contact, Contamination, Utility work/operation, Vandalism/theft, Lightning, Unknown, Other – See commentDomCausetrue
CauseCommentString30Cause CommentCause category not listed above.true
AssociatedNominalVoltagekVString10Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, “<500”). Leave blank if unknown.true
AssociateOperatingVoltagekVString10Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. OK to use ranges (e.g. “0-60”, <500”). Leave blank if unknown.true
SupportStructureMaterialString30Support Structure MaterialMaterial of which support structure is made. Possible values: Wood, Metal, Composite, Wrapped wood, Concrete, Other – See comment.DomSupportStructureMaterialtrue
MaterialCommentString30Material CommentSupport structure material not listed in the options above.true
ManufacturerModelIDString50Manufacturer Model IDThe manufacturer and asset model specifications that would enable one to identify exactly what type of equipment was involved with the damage. Do not use acronyms or abbreviations for this field. Fully spell out the manufacturer and model names. If some sort of model or part code/name is not available, at least record the manufacturer name. Write "Unknown" if no manufacturer info can be determined based on information available in the field. “Unknown” values should be reviewed by other electrical corporation staff after data collection and filled in from existing databases or other sources if possible.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value).DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset would have been expected to have a useful functioning existence prior to damage. If unknown, enter “-99.”true
LikelyArcingString10Likely ArcingWas arcing likely because of the damage? Possible values: Yes, No, Unknown.DomYesNoUnknowntrue
DamageTypeString30Damage TypeType of damage sustained. Possible values: Asset damage, Asset failure, Equipment damage, Equipment failure, Veg contact, Object contact.DomDamageTypetrue
DamageDescriptionString30Damage DescriptionDescription of damage. Possible values: Broken pole, Damaged pole, Broken tower, Damaged tower, Broken crossarm, Damaged crossarm, Other – See comment.DomSupportStructureDamageDescriptiontrue
DamageDescriptionCommentString30Damage Description CommentDamage category not listed in the options above and/or additional relevant details about damagetrue

SCE_RiskEventAssetLog_20210501 - Table

NameSCE_RiskEventAssetLog_20210501
AliasNameSCE Risk Event Asset Log 20210501
HasAttachmentsfalse
DescriptionSCE_RiskEventAssetLog_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
ReaIDString50Risk Event Asset IDThe unique ID for the associated asset. Primary key for the Risk Event Asset Log related table.true
WireDownIDString50Wire Down IDForeign key to the Wire Down Event feature class attribute table.true
FromDeviceIDString50From Device IDThe AssetID of the upstream structure(s) supporting the conductor involved in the wire down event. Enter multiple IDs if multiple upstream structures are in the same location. Foreign key to all the associated asset point feature class attribute tables.true
ToDeviceIDString50To Device IDThe AssetID of the downstream structure(s) supporting the conductor involved in the wire down event. Enter multiple IDs if multiple downstream structures are in the same location. Foreign key to all the associated asset point feature class attribute tables.true
IgnitionIDString50Ignition IDForeign key to the Ignition feature class attribute table.true
StationIDString50Station IDUnique ID for the nearest weather station to the ignition location. Enter multiple IDs if multiple stations are in the same location. Must be traceable stable ID within a weather station. Foreign key to the Weather Station feature class attribute table.true
ToutageIDString50Transmission Outage IDForeign key to the Transmission Unplanned Outage feature class attribute table.true
TvmOutageIDString50Transmission VM Outage IDForeign key to the Transmission VM Unplanned Outage feature class attribute table.true
DoutageIDString50Distribution Outage IDForeign key to the Distribution Unplanned Outage feature class attribute table.true
DvmOutageIDString50Distribution VM Outage IDForeign key to the Distribution Outage feature class attribute table.true
IsolationDeviceIDString50Isolation Device IDThe AssetID of the device that operated to de-energize the circuit for an outage event. Should be traceable within a specific asset class. Foreign key to all the associated asset point tables.true
DamagedDeviceIDString50Damaged Device IDThe AssetID of the device that failed or experienced the damage thatinitiated the outage. Should be traceable within a specific asset class. Foreign key to all the associated asset point feature class attribute tables.true
AssetIDString50Asset IDUnique ID for asset point feature class attribute tables. Must be traceable stable ID within a specific asset class. Foreign key to all the associated asset point feature class attribute tables.true
CircuitIDString50Circuit IDUnique ID for the specific circuit impacted by a risk event. Must be traceable stable ID within a specific asset class. Foreign key to all the associated asset line feature class attribute tables.true
SubstationIDString50Substation IDUnique ID for the source substation feeding the circuit impacted by the outage. Must be traceable stable ID within a substation. Foreign key to the Substation feature class attribute table.true

SCE_RiskEventPhotoLog_20210501 - Table

NameSCE_RiskEventPhotoLog_20210501
AliasNameSCE Risk Event Photo Log 20210501
HasAttachmentsfalse
DescriptionSCE_RiskEventPhotoLog_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PhotoIDString100Photo IDName for a photo of the risk event location. Enables a risk event photo to be linked to GIS data. Primary key for the Risk Event Photo Log related table. Photos must be geotagged JPEG or PNG files. Use the following naming format: UtilityName _InspectorInitial_RiskEvent_YYYYMMDD_PhotoNumber. For example, “UtilityG+E_AB_PspsDamage_20200703_1.png”.If applicable/logical, an optional district ID value can be added between the utility name and inspector initial values (e.g., “UtilityName_DistrictID_InspectorInitial_RiskEvent_YYYYMMDD_PhotoNumber”).true
IgnitionIDString50Ignition IDForeign key to the Ignition feature class attribute table.true
WireDownIDString50Wire Down IDForeign key to the Wire Down Event feature class attribute table.true

SCE_TransformerDetail_20210501 - Table

NameSCE_TransformerDetail_20210501
AliasNameSCE Transformer Detail 20210501
HasAttachmentsfalse
DescriptionSCE_TransformerDetail_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique ID for a specific transformer asset. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Transformer Detail related table.true
TransformerSiteIDString50Transformer Site IDUnique ID for a specific transformer site. It should be a traceable stable ID within the utility’s operations/processes. Foreign key enabling connection to the Transformer Site feature class attribute table.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation feature class attribute table.true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line feature class attribute tables.true
TransformerSubtypeString100TransformerSubtypeSpecific subtype of the transformer. Possible values: Single phase pad-mounted, Single phase subsurface, Single phase overhead, Three phase pad-mounted, Three phase subsurface, Three phase overhead.DomTransformerSubtypetrue
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
SubstationNameString50Substation NameName of substation associated with asset.true
CircuitNameString255Circuit NameName of circuit associated with asset. Leave blank or enter "N/A" if there is no unique circuit name that is different than the circuit ID. There is no need to repeat "CircuitID" values in this field.true
ManufacturerString50ManufacturerName of the manufacturer of the transformer. Do not use acronyms or abbreviations for this field. Fully spell out the manufacturer name. Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Leave blank if unknown.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Leave blank if unknown.true
InstallationDateDate8Installation DateDate the asset was installed. Leave blank if unknown.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Note: Only enter "N/A" if there is an "InstallationDate" value or "InstallationYear" value. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A.DomEstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.”true
ExemptionStatusString30Exemption StatusDoes the transformer hold equipment that is exempt from Public Resource Code (PRC) 4292 vegetation clearance requirements? This field is especially important and a high priority for the WSD and the State of California. Non-exempt equipment requires support structure clearance. Possible values: Yes, No, Unknown, N/A.DomYesNoUnknownNAtrue
TransformerRatingSingle4Transformer Rating (kVAs)Nominal electrical load capacity in kilovolt amps (kVAs).true

SCE_VegetationInspectionLog_20210501 - Table

NameSCE_VegetationInspectionLog_20210501
AliasNameSCE Vegetation Inspection Log 20210501
HasAttachmentsfalse
DescriptionSCE_VegetationInspectionLog_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmiLogIDString50VMI Log IDUnique ID or job ID of a vegetation inspection activity. Primary key for the Vegetation Inspection Log related table.true
VmpLogIDString50VMP Log IDUnique ID or job ID of a vegetation management project resulting from a vegetation inspection. A foreign key to the Vegetation Management Project Log related table.true
InspectionStartDateDate8Inspection Start DateThe date when a vegetation management inspection began or is planned to begin. If exact date is not known, may approximate to first day of the month inspection was started. May leave blank for planned inspections.true
InspectionEndDateDate8Inspection End DateThe date when a vegetation management inspection ended or is planned to end. If exact date is not known, may approximate to last day of the month inspection was finished. End date is not required if inspection is in progress. May leave blank for planned inspections.true
InspectionTypeString100Inspection TypeInitiative activities related to the vegetation management project. If multiple activities are related, list them in the “InspectionType” comment field. Possible values: Assessing trees with the potential to strike, Clearances – required, Clearances – beyond requirements, Hazard trees, Tree mortality, Other – See comment.DomVmInspectionTypetrue
InspectionTypeCommentString120Inspection Type CommentInspection type description not listed in the options above. If multiple activities are related to the project, list them here.true
InspectionQAString3Inspection QAHas the inspection been checked for quality assurance? Possible values: Yes, No.DomYesNotrue
CommercialHarvestString10Commercial HarvestDoes the inspection involve commercial harvest? Possible values: Yes, No, Unknown.DomYesNoUnknowntrue
TreeTrimCountInteger4Tree Trim CountThe number of trees identified for trimming from the vegetation management inspection. Trees counted shall be over 6” DBH and outside a 4’ radius of the conductor.true
InspectionCommentString100Inspection CommentAdditional comments regarding the vegetation inspection project.true
InspectionMethodString100Inspection MethodThe method(s) by which the asset inspection was conducted. Possible values: Ground Inspection, Aerial – drone, Aerial – helicopter, Remote sensing – imagery, Remote sensing – LiDAR, Other – See comment.DomInspectionMethodtrue
InspectionMethodCommentString50Inspection Method CommentInspection method description not listed in the options above.true
InspectionTechnologyString30Inspection TechnologyThe technology that an inspector uses for the vegetation management inspection. Possible values: Collector for ArcGIS, Survey123 for ArcGIS, Workforce for ArcGIS, ArcGIS QuickCapture, Other – See comment, None.DomInspectionTechnologytrue
InspectionTechnologyCommentString30Inspection Technology CommentInspection technology description not listed in the options above.true

SCE_VegetationManagementProjectLog_20210501 - Table

NameSCE_VegetationManagementProjectLog_20210501
AliasNameSCE Vegetation Management Project Log 20210501
HasAttachmentsfalse
DescriptionSCE_VegetationManagementProjectLog_20210501

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmpLogIDString50VMP Log IDUnique ID or job ID of an initiative. Primary key for Vegetation Management Project Log related table.true
DescriptionOfWorkString100Description of WorkAdditional description of the vegetation management work (not required).true
StartDateDate8Start DateThe start date of the vegetation management project. This field must have values for all projects that have a value of “Complete” or "In Progress" in the "VmpStatus" field. If exact date is not known, may approximate as the first day of the month in which project began. May leave blank for planned projects.true
EndDateDate8End DateThe completion date of the vegetation management project. This field must at least have values for all projects that have a value of “Complete” in the “VmpStatus” field. If exact date is not known, may approximate as last day of the month in which project was completed. End date is not required if project is in progress. May leave blank for planned projects.true
CoastalRedwoodExemptionString3Coastal Redwood ExemptionCoastal redwood exception to clearance being applied. Possible values: Yes, No.DomYesNotrue
EncroachPermitString3Encroach PermitIs an encroachment permit required for the vegetation management project? Possible values: Yes, No.DomYesNotrue
EnvPermitString3Environmental PermitIs special environmental permitting needed for the vegetation management project? Possible values: Yes, No.DomYesNotrue
EnvPermitProjectString100Environmental Permit ProjectSpecific activity (e.g., timber harvest under an exemption) for which a permit was obtained.true
CALFIREHdNumberString35CAL FIRE Harvest Document NumberIf applicable, enter the CAL FIRE harvest document number applicable to the initiative. When the permitted project is timber harvest under an exemption, this field must include the harvest document number of the exemption (e.g., 2-20EX-01049-BUT). Enter “N/A” if not applicable.true
OtherEnvPermitDocumentationString50Other Environmental Permit DocumentationFor any projects that do not have a CAL FIRE harvest document number or that have a CAL FIRE Harvest document number and additional permit documentation, enter any key details about environmental permit documentation and project ID numbers. Enter “N/A” if there is not additional permit documentation.true
CommercialHarvestString10Commercial HarvestDoes the initiative involve commercial harvest? Possible values: Yes, No, Unknown.DomYesNoUnknowntrue
SlashManagementString20Slash ManagementHow is brush or slash generated by the vegetation management project being managed or treated? Possible values: None, Lopping, Chipping, Removal, Other – See comment.DomSlashManagementtrue
SlashManagementCommentsString30Slash Management CommentsBrush/slash management method not listed above.true
FireResponsibilityString50Fire ResponsibilityThe assigned designation of the land where the subject vegetation management project is scheduled. Possible values: Local Responsibility Area (LRA), State Responsibility Area (SRA), Federal Responsibility Area (FRA). An authoritative CAL FIRE feature service for this data can be found here: https://calfire-forestry.maps.arcgis.com/home/item.html?id=5bc422648cf045f38d10e1630fb71a71. A GDB of the data can downloaded from here under the “SRA – LRA – FRA” heading: https://frap.fire.ca.gov/mapping/gis-data/.DomFireResponsibilitytrue
CaltransPropString3Caltrans PropertyIs the vegetation management project located on Caltrans property? Possible values: Yes, No.DomYesNotrue
TreeTrimCountPlannedInteger4Tree Trim Count PlannedNumber of trees planned for trimming in the project. Enter “0” if tree trimming is not part of the vegetation project.true
TreeTrimAcreagePlannedSingle4Tree Trim Acreage PlannedAcreage of trees planned for trimming in the project. Use two decimal places. Enter “0” if the vegetation project data are not recorded as a polygon or if tree trimming is not part of the project.true
TreeRemovalCountPlannedInteger4Tree Removal Count PlannedNumber of trees planned for removal in the project. Enter “0” if tree removal is not part of the vegetation project.true
TreeRemovalAcreagePlannedSingle4Tree Removal Acreage PlannedAcreage of trees planned for removal in the project. Use two decimal places. Enter “0” if the vegetation project data are not recorded as a polygon or if tree removal is not part of the vegetation project. Trees counted shall be over 6” DBH and outside a 4’ radius of the conductor.true
TreeTrimCountActlInteger4Tree Trim Count ActualNumber of trees actually trimmed as part of the project. Enter “0” if tree trimming is not part of the vegetation project or if the vegetation project has a value of “Planned” under the “VmpStatus” field.true
TreeTrimAcreageActlSingle4Tree Trim Acreage ActualAcreage of trees actually trimmed as part of the in the project. Two decimal places. Enter “0” if the vegetation project data are not recorded as a polygon or if tree trimming is not part of the vegetation project or if the vegetation project has a value of “Planned” under the “VmpStatus” field.true
TreeRemovalCountActlInteger4Tree Removal Count ActualNumber of trees actually removed as part of the project. Enter “0” if tree removal is not part of the vegetation project or if the vegetation project has a value of “Planned” under the “VmpStatus” field.true
TreeRemovalAcreageActlSingle4Tree Removal Acreage ActualAcreage of trees actually removed as part of the project. Use two decimal places. Enter “0” if the vegetation project data are not recorded as a polygon or if tree removal is not part of the vegetation project or if the vegetation project has a value of “Planned” under the “VmpStatus” field.true
VegetationTreatmentTypeString50Vegetation Treatment TypeThe type(s) of treatment scoped for the vegetation management project. Possible values: Radial clearance – standard, Radial clearance - enhanced, Overhang clearing, Tree removal – hazard tree, Tree removal – tree mortality, Tree trimming, Pole brushing, Fire break creation, Brush clearance, Other or multiple treatment types – See comment.DomVegTreatmentTypetrue
VegetationTreatmentTypeCommentString50Vegetation Treatment Type CommentTreatment type not listed in options above—or multiple treatment types listed in options above. If multiple, list all separated by commas.true
WoodDestinationString20Wood DestinationRecord how boles of trees (6" diameter and greater) will be treated. If multiple destinations apply, list them all in the “VegetationDestinationComment” field. This field may be left blank if no trees will be/were removed. Possible values: Sawmill, Firewood, Biomass facility, Left whole on-site (whether bucked or not), Left chipped on-site, Burned on-site, Other - See comment.DomWoodDestinationtrue
WoodDestinationCommentString60Wood Destination CommentWood destination not listed above; or, if multiple destinations apply, list them here.true

DomAssetClass - Domain

DomainNameDomAssetClass
FieldTypeString
Domain TypeCodedValue

CodeName
TransmissionTransmission
DistributionDistribution


DomAssetType - Domain

DomainNameDomAssetType
FieldTypeString
Domain TypeCodedValue

CodeName
CameraCamera
Customer meterCustomer meter
FuseFuse
Lightning arresterLightning arrester
Line connection deviceLine connection device
SubstationSubstation
Support structureSupport structure
SwitchgearSwitchgear
TransformerTransformer
Weather StationWeather Station


DomBackupType - Domain

DomainNameDomBackupType
FieldTypeString
Domain TypeCodedValue

CodeName
Storage batteryStorage battery
Diesel generatorDiesel generator
Gas generatorGas generator
Combined/hybridCombined/hybrid
Other - See commentOther - See comment


DomCause - Domain

DomainNameDomCause
FieldTypeString
Domain TypeCodedValue

CodeName
ContaminationContamination
Epuipment failureEpuipment failure
Object contactObject contact
LightningLightning
Normal operationNormal operation
Utility workUtility work
Vandalism/TheftVandalism/Theft
Wire-to-wire contactWire-to-wire contact
UnknownUnknown
Other - See commentOther - See comment


DomCircuitType - Domain

DomainNameDomCircuitType
FieldTypeString
Domain TypeCodedValue

CodeName
TransmissionTransmission
Primary distributionPrimary distribution
Secondary distributionSecondary distribution
UnknownUnknown


DomConductorMaterial - Domain

DomainNameDomConductorMaterial
FieldTypeString
Domain TypeCodedValue

CodeName
All aluminum conductor (AAC)All aluminum conductor (AAC)
All aluminum alloy conductor (AAAC)All aluminum alloy conductor (AAAC)
Aluminum conductor aluminum reinforced (ACAR)Aluminum conductor aluminum reinforced (ACAR)
Aluminum conductor steel reinforced (ACSR)Aluminum conductor steel reinforced (ACSR)
Aluminum conductor steel supported (ACSS)Aluminum conductor steel supported (ACSS)
Copper (Cu)Copper (Cu)
Other - See commentOther - See comment


DomConductorType - Domain

DomainNameDomConductorType
FieldTypeString
Domain TypeCodedValue

CodeName
BareBare
CoveredCovered
Other - See commentOther - See comment


DomConductorTypeSecondary - Domain

DomainNameDomConductorTypeSecondary
FieldTypeString
Domain TypeCodedValue

CodeName
Open wireOpen wire
DuplexDuplex
TriplexTriplex
QuadruplexQuadruplex
Other - See commentOther - See comment


DomConnectionDeviceSubtype - Domain

DomainNameDomConnectionDeviceSubtype
FieldTypeString
Domain TypeCodedValue

CodeName
Automatic spliceAutomatic splice
Crimp spliceCrimp splice
Explosive sleeve spliceExplosive sleeve splice
3-bolt3-bolt
Parallel grooveParallel groove
UnknownUnknown
Other - See commentOther - See comment


DomConnectionDeviceType - Domain

DomainNameDomConnectionDeviceType
FieldTypeString
Domain TypeCodedValue

CodeName
SpliceSplice
ConnectorConnector
ClampClamp
UnknownUnknown
Other - See commentOther - See comment


DomConnectionOhUg - Domain

DomainNameDomConnectionOhUg
FieldTypeString
Domain TypeCodedValue

CodeName
All OverheadAll Overhead
All UndergroundAll Underground
Overhead to undergroundOverhead to underground
Underground to overheadUnderground to overhead
UnknownUnknown


DomConnectionType - Domain

DomainNameDomConnectionType
FieldTypeString
Domain TypeCodedValue

CodeName
Corporation to privateCorporation to private
Corporation to corporationCorporation to corporation


DomConstructionGrade - Domain

DomainNameDomConstructionGrade
FieldTypeString
Domain TypeCodedValue

CodeName
Grade AGrade A
Grade BGrade B
Grade CGrade C


DomContributingFactor - Domain

DomainNameDomContributingFactor
FieldTypeString
Domain TypeCodedValue

CodeName
WeatherWeather
External forceExternal force
Human errorHuman error
UnknownUnknown
Other - See commentOther - See comment


DomDamageDescription - Domain

DomainNameDomDamageDescription
FieldTypeString
Domain TypeCodedValue

CodeName
Broken conductorBroken conductor
Damaged conductorDamaged conductor
Kite in lineKite in line
Pine needles on linePine needles on line
Tree bark on lineTree bark on line
Tree branch on lineTree branch on line
Tree leaning into lineTree leaning into line
Tree leaning toward lineTree leaning toward line
Wire-to-wire contactWire-to-wire contact
Other - See commentOther - See comment


DomDamageType - Domain

DomainNameDomDamageType
FieldTypeString
Domain TypeCodedValue

CodeName
Asset damageAsset damage
Asset failureAsset failure
Equipment damageEquipment damage
Equipment failureEquipment failure
Vegetation contactVegetation contact
Object contactObject contact


DomDetermination - Domain

DomainNameDomDetermination
FieldTypeString
Domain TypeCodedValue

CodeName
Utility personnelUtility personnel
Fire agencyFire agency
Other - See commentOther - See comment


DomEquipmentFailure - Domain

DomainNameDomEquipmentFailure
FieldTypeString
Domain TypeCodedValue

CodeName
Anchor/guyAnchor/guy
Capacitor bankCapacitor bank
ConductorConductor
Connector deviceConnector device
CrossarmCrossarm
FuseFuse
Insulator and bushingInsulator and bushing
Lightning arresterLightning arrester
PolePole
RecloserRecloser
RelayRelay
SectionalizerSectionalizer
SpliceSplice
SwitchSwitch
TapTap
Tie wireTie wire
TransformerTransformer
Voltage regulator/boosterVoltage regulator/booster
UnknownUnknown
N/AN/A
Other - See commentOther - See comment


DomEquipmentType - Domain

DomainNameDomEquipmentType
FieldTypeString
Domain TypeCodedValue

CodeName
OverheadOverhead
Pad-mountedPad-mounted
SubsurfaceSubsurface


DomEstimatedAge - Domain

DomainNameDomEstimatedAge
FieldTypeString
Domain TypeCodedValue

CodeName
0-90-9
10-1910-19
20-2920-29
30-3930-39
40-4940-49
50-5950-59
60-6960-69
70-7970-79
80-8980-89
90-9990-99
>100>100
UnknownUnknown
N/AN/A


DomFacilityCategory - Domain

DomainNameDomFacilityCategory
FieldTypeString
Domain TypeCodedValue

CodeName
ChemicalChemical
CommunicationsCommunications
EducationalEducational
Emergency servicesEmergency services
EnergyEnergy
Government facilitiesGovernment facilities
Healthcare and public healthHealthcare and public health
Public safety answering pointsPublic safety answering points
TransportationTransportation
Water and wastewater systemsWater and wastewater systems
Other - See commentOther - See comment


DomFacilityContacted - Domain

DomainNameDomFacilityContacted
FieldTypeString
Domain TypeCodedValue

CodeName
Bushing mounted cutoutBushing mounted cutout
Capacitor bankCapacitor bank
Communications lineCommunications line
Conductor - PrimaryConductor - Primary
Conductor - SecondaryConductor - Secondary
Conductor - TransmissionConductor - Transmission
CrossarmCrossarm
FuseFuse
Guy/span wireGuy/span wire
InsulatorInsulator
JumperJumper
Support structureSupport structure
PotheadPothead
RecloserRecloser
RiserRiser
Service connectorService connector
Service dropService drop
Splice/clamp/connectorSplice/clamp/connector
SwitchSwitch
Tie wireTie wire
TransformerTransformer
Voltage regulatorVoltage regulator
Other - See commentOther - See comment


DomFireDetectionMethod - Domain

DomainNameDomFireDetectionMethod
FieldTypeString
Domain TypeCodedValue

CodeName
PublicPublic
SatelliteSatellite
CameraCamera
Utility staffUtility staff
Fire agencyFire agency
Other - See commentOther - See comment


DomFireInvestigation - Domain

DomainNameDomFireInvestigation
FieldTypeString
Domain TypeCodedValue

CodeName
Yes - CompleteYes - Complete
Yes - PendingYes - Pending
NoNo


DomFireResponsibility - Domain

DomainNameDomFireResponsibility
FieldTypeString
Domain TypeCodedValue

CodeName
Local Responsibility Area (LRA)Local Responsibility Area (LRA)
State Responsibility Area (SRA)State Responsibility Area (SRA)
Federal Responsibility Area (FRA)Federal Responsibility Area (FRA)


DomFireSize - Domain

DomainNameDomFireSize
FieldTypeString
Domain TypeCodedValue

CodeName
Structure-onlyStructure-only
<3 meters of linear travel<3 meters of linear travel
<0.25<0.25
0.26-9.990.26-9.99
10-9910-99
100-299100-299
300-999300-999
1,000-4,9991,000-4,999
>5,000>5,000
UnknownUnknown


DomFuelBedDescription - Domain

DomainNameDomFuelBedDescription
FieldTypeString
Domain TypeCodedValue

CodeName
Fire-resistive fuel bedFire-resistive fuel bed
Grass fuel modelGrass fuel model
Brush fuel modelBrush fuel model
Timber fuel modelTimber fuel model
Other - See commentOther - See comment


DomFuseType - Domain

DomainNameDomFuseType
FieldTypeString
Domain TypeCodedValue

CodeName
BridgedBridged
Current limitingCurrent limiting
ExpulsionExpulsion
Fused elbowFused elbow
UnknownUnknown
Other - See commentOther - See comment


DomGhChangeOrderType - Domain

DomainNameDomGhChangeOrderType
FieldTypeString
Domain TypeCodedValue

CodeName
Increase in scaleIncrease in scale
Decrease in scaleDecrease in scale
Change in prioritizationChange in prioritization
Change in deployment timingChange in deployment timing
Change in work being doneChange in work being done
Other change - See commentOther change - See comment


DomHFTD - Domain

DomainNameDomHFTD
FieldTypeString
Domain TypeCodedValue

CodeName
Tier 3Tier 3
Tier 2Tier 2
Non-HFTDNon-HFTD


DomInitiativeCategory1 - Domain

DomainNameDomInitiativeCategory1
FieldTypeString
Domain TypeCodedValue

CodeName
Risk mapping and simulationRisk mapping and simulation
Situational awareness and forecastingSituational awareness and forecasting
Grid design and system hardeningGrid design and system hardening
Asset management and inspectionsAsset management and inspections
Vegetation management and inspectionsVegetation management and inspections


DomInitiativeCategory2 - Domain

DomainNameDomInitiativeCategory2
FieldTypeString
Domain TypeCodedValue

CodeName
Risk mapping and simulationRisk mapping and simulation
Data governanceData governance
Resource allocation methodologyResource allocation methodology
Emergency planning and preparednessEmergency planning and preparedness
Stakeholder coopiration and community engagementStakeholder coopiration and community engagement


DomInspectionMethod - Domain

DomainNameDomInspectionMethod
FieldTypeString
Domain TypeCodedValue

CodeName
Ground inspectionGround inspection
Aerial - DroneAerial - Drone
Aerial - HelicopterAerial - Helicopter
Remote sensing - ImageryRemote sensing - Imagery
Remote sensing - LiDARRemote sensing - LiDAR
Other - See commentOther - See comment


DomInspectionTechnology - Domain

DomainNameDomInspectionTechnology
FieldTypeString
Domain TypeCodedValue

CodeName
Collector for ArcGISCollector for ArcGIS
Survey123 for ArcGISSurvey123 for ArcGIS
Workforce for ArcGISWorkforce for ArcGIS
ArcGIS QuickCaptureArcGIS QuickCapture
Other - See commentOther - See comment
NoneNone


DomInspectionType - Domain

DomainNameDomInspectionType
FieldTypeString
Domain TypeCodedValue

CodeName
PatrolPatrol
DetailedDetailed
Pole loadingPole loading
Other - See commentOther - See comment


DomIsolationDevice - Domain

DomainNameDomIsolationDevice
FieldTypeString
Domain TypeCodedValue

CodeName
Circuit breakerCircuit breaker
FuseFuse
Lightning arresterLightning arrester
SwitchSwitch
TransformerTransformer
RecloserRecloser
JumperJumper
Other - See commentOther - See comment


DomLandUse - Domain

DomainNameDomLandUse
FieldTypeString
Domain TypeCodedValue

CodeName
RuralRural
UrbanUrban


DomLineClass - Domain

DomainNameDomLineClass
FieldTypeString
Domain TypeCodedValue

CodeName
TransmissionTransmission
Sub-transmissionSub-transmission
Primary distributionPrimary distribution
Secondary distributionSecondary distribution


DomMaterialAtOrigin - Domain

DomainNameDomMaterialAtOrigin
FieldTypeString
Domain TypeCodedValue

CodeName
VegetationVegetation
StructureStructure
Other - See commentOther - See comment


DomObjectContact - Domain

DomainNameDomObjectContact
FieldTypeString
Domain TypeCodedValue

CodeName
Vegetation contactVegetation contact
Animal contactAnimal contact
Balloon contactBalloon contact
Vehicle contact - Car poleVehicle contact - Car pole
Vehicle contact - AircraftVehicle contact - Aircraft
3rd party contact3rd party contact
UnknownUnknown
Other - See commenOther - See commen
N/AN/A


DomOhUg - Domain

DomainNameDomOhUg
FieldTypeString
Domain TypeCodedValue

CodeName
OverheadOverhead
UndergroundUnderground
UnknownUnknown


DomOtherAssetDamageDescription - Domain

DomainNameDomOtherAssetDamageDescription
FieldTypeString
Domain TypeCodedValue

CodeName
Broken down guyBroken down guy
Broken hand tieBroken hand tie
Broken neutralBroken neutral
Broken service neutralBroken service neutral
Broken guy wireBroken guy wire
Broken tie wireBroken tie wire
Broken tree branch near lineBroken tree branch near line
Broken pinBroken pin
Broken insulatorBroken insulator
Damaged crossarmDamaged crossarm
Guy and anchor damageGuy and anchor damage
Tree branch on transformerTree branch on transformer
Other - See commentOther - See comment


DomOutageInterval - Domain

DomainNameDomOutageInterval
FieldTypeString
Domain TypeCodedValue

CodeName
MomentaryMomentary
SustainedSustained


DomPerformedBy - Domain

DomainNameDomPerformedBy
FieldTypeString
Domain TypeCodedValue

CodeName
Utility staffUtility staff
ContractorContractor
Other - See commentOther - See comment


DomPspsAsset - Domain

DomainNameDomPspsAsset
FieldTypeString
Domain TypeCodedValue

CodeName
PolePole
TowerTower
CrossarmCrossarm
Secondary armsSecondary arms
Other - See commentOther - See comment


DomPspsIsolationDevice - Domain

DomainNameDomPspsIsolationDevice
FieldTypeString
Domain TypeCodedValue

CodeName
Circuit breakerCircuit breaker
FuseFuse
SwitchSwitch
Other - See commentOther - See comment


DomPspsOtherAsset - Domain

DomainNameDomPspsOtherAsset
FieldTypeString
Domain TypeCodedValue

CodeName
Down guyDown guy
NeutralNeutral
Service neutralService neutral
Span guySpan guy
Tie wireTie wire
Wood pinWood pin
AnchorAnchor
Other - See commentOther - See comment


DomRecloserSetting - Domain

DomainNameDomRecloserSetting
FieldTypeString
Domain TypeCodedValue

CodeName
EnabledEnabled
DisabledDisabled
N/AN/A


DomSlashManagement - Domain

DomainNameDomSlashManagement
FieldTypeString
Domain TypeCodedValue

CodeName
NoneNone
LoppingLopping
ChippingChipping
RemovalRemoval
Other - See commentOther - See comment


DomSpeciesGrowthRate - Domain

DomainNameDomSpeciesGrowthRate
FieldTypeString
Domain TypeCodedValue

CodeName
Slow growingSlow growing
Moderately growingModerately growing
Fast growingFast growing


DomStatus - Domain

DomainNameDomStatus
FieldTypeString
Domain TypeCodedValue

CodeName
PlannedPlanned
In-progressIn-progress
CompleteComplete


DomSubareaType - Domain

DomainNameDomSubareaType
FieldTypeString
Domain TypeCodedValue

CodeName
OperationalOperational
ConstructionConstruction
WeatherWeather
OrganizationalOrganizational
Other - See commentOther - See comment


DomSubstationType - Domain

DomainNameDomSubstationType
FieldTypeString
Domain TypeCodedValue

CodeName
NetworkNetwork
LoopLoop
RadialRadial


DomSupportStructureDamageDescription - Domain

DomainNameDomSupportStructureDamageDescription
FieldTypeString
Domain TypeCodedValue

CodeName
Broken poleBroken pole
Damaged poleDamaged pole
Broken towerBroken tower
Damaged towerDamaged tower
Broken crossarmBroken crossarm
Damaged crossarmDamaged crossarm
Other - See commentOther - See comment


DomSupportStructureMaterial - Domain

DomainNameDomSupportStructureMaterial
FieldTypeString
Domain TypeCodedValue

CodeName
WoodWood
MetalMetal
CompositeComposite
Wrapped woodWrapped wood
ConcreteConcrete
Other - See commentOther - See comment


DomSupportStructureType - Domain

DomainNameDomSupportStructureType
FieldTypeString
Domain TypeCodedValue

CodeName
PolePole
TowerTower
Other - See commentOther - See comment


DomSuppressedBy - Domain

DomainNameDomSuppressedBy
FieldTypeString
Domain TypeCodedValue

CodeName
CustomerCustomer
Fire agencyFire agency
Self-extinguishedSelf-extinguished
UtilityUtility
UnknownUnknown


DomTransformerSubtype - Domain

DomainNameDomTransformerSubtype
FieldTypeString
Domain TypeCodedValue

CodeName
Single phase pad-mountedSingle phase pad-mounted
Single phase subsurfaceSingle phase subsurface
Single phase overheadSingle phase overhead
Two phase pad-mountedTwo phase pad-mounted
Two phase subsurfaceTwo phase subsurface
Two phase overheadTwo phase overhead
Three phase pad-mountedThree phase pad-mounted
Three phase subsurfaceThree phase subsurface
Three phase overheadThree phase overhead


DomTreeDiameter - Domain

DomainNameDomTreeDiameter
FieldTypeInteger
Domain TypeRange

Minimum ValueMaximum Value
-99180


DomTreeHeight - Domain

DomainNameDomTreeHeight
FieldTypeInteger
Domain TypeRange

Minimum ValueMaximum Value
-99-99


DomVegTreatmentType - Domain

DomainNameDomVegTreatmentType
FieldTypeString
Domain TypeCodedValue

CodeName
Radial clearance - StandardRadial clearance - Standard
Radial clearance - EnhancedRadial clearance - Enhanced
Overhang clearingOverhang clearing
Tree removal - Hazard treeTree removal - Hazard tree
Tree removal - Tree mortalityTree removal - Tree mortality
Tree trimmingTree trimming
Pole brushingPole brushing
Fire break creationFire break creation
Brush clearanceBrush clearance
Other or multiple treatment types - See commentOther or multiple treatment types - See comment


DomVmInspectionType - Domain

DomainNameDomVmInspectionType
FieldTypeString
Domain TypeCodedValue

CodeName
Asessing trees with the potential to strikeAsessing trees with the potential to strike
Clearances - requiredClearances - required
Clearances - beyond requirementsClearances - beyond requirements
Hazard treesHazard trees
Tree mortalityTree mortality
Other - See commentOther - See comment


DomWoodDestination - Domain

DomainNameDomWoodDestination
FieldTypeString
Domain TypeCodedValue

CodeName
SawmillSawmill
FirewoodFirewood
Biomass FacilityBiomass Facility
Left whole on-siteLeft whole on-site
Left chipped on-siteLeft chipped on-site
Burned on-siteBurned on-site
Other - See commentOther - See comment


DomYesNo - Domain

DomainNameDomYesNo
FieldTypeString
Domain TypeCodedValue

CodeName
YesYes
NoNo


DomYesNoNA - Domain

DomainNameDomYesNoNA
FieldTypeString
Domain TypeCodedValue

CodeName
YesYes
NoNo
N/AN/A


DomYesNoUnknown - Domain

DomainNameDomYesNoUnknown
FieldTypeString
Domain TypeCodedValue

CodeName
YesYes
NoNo
UnknownUnknown


DomYesNoUnknownNA - Domain

DomainNameDomYesNoUnknownNA
FieldTypeString
Domain TypeCodedValue

CodeName
YesYes
NoNo
UnknownUnknown
N/AN/A