Geodatabase Documentation
Date: Wednesday, February 3, 2021
Time: 6:36:39 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
PGE_AssetLine - Feature Dataset
PGE_PrimaryDistributionLine_20210501 - Simple
PGE_SecondaryDistributionLine_20210501 - Simple
PGE_TransmissionLine_20210501 - Simple
PGE_AssetPoint - Feature Dataset
PGE_Camera_20210501 - Simple
PGE_ConnectionDevice_20210501 - Simple
PGE_CustomerMeter_20210501 - Simple
PGE_Fuse_20210501 - Simple
PGE_LightingArrester_20210501 - Simple
PGE_Substation_20210501 - Simple
PGE_SupportStructure_20210501 - Simple
PGE_Switchgear_20210501 - Simple
PGE_TransformerSite_20210501 - Simple
PGE_WeatherStation_20210501 - Simple
PGE_Initiative - Feature Dataset
PGE_AssetInspectionLine_20210501 - Simple
PGE_AssetInspectionPoint_20210501 - Simple
PGE_AssetInspectionPolygon_20210501 - Simple
PGE_GridHardeningLine_20210501 - Simple
PGE_GridHardeningPoint_20210501 - Simple
PGE_OtherInitiativeLine_20210501 - Simple
PGE_OtherInitiativePoint_20210501 - Simple
PGE_OtherInitiativePolygon_20210501 - Simple
PGE_VegetationInspectionLine_20210501 - Simple
PGE_VegetationInspectionPoint_20210501 - Simple
PGE_VegetationInspectionPolygon_20210501 - Simple
PGE_VegetationManagementProjectLine_20210501 - Simple
PGE_VegetationManagementProjectPoint_20210501 - Simple
PGE_VegetationManagementProjectPolygon_20210501 - Simple
PGE_OtherRequiredData - Feature Dataset
PGE_AdministrativeArea_20210501 - Simple
PGE_CriticalFacility_20210501 - Simple
PGE_MajorWoodyStemExemptTreePoint_20210501 - Simple
PGE_OtherPowerLineConnectionLocation_20210501 - Simple
PGE_RedFlagWarningDayPolygon_20210501 - Simple
PGE_PspsEvent - Feature Dataset
PGE_PspsEventCustomerMeterPoint_20210501 - Simple
PGE_PspsEventDamagePoint_20210501 - Simple
PGE_PspsEventLine_20210501 - Simple
PGE_PspsEventPolygon_20210501 - Simple
PGE_RiskEvent - Feature Dataset
PGE_DistributionUnplannedOutage_20210501 - Simple
PGE_DistributionVegetationCausedUnplannedOutage_20210501 - Simple
PGE_Ignition_20210501 - Simple
PGE_TransmissionUnplannedOutage_20210501 - Simple
PGE_TransmissionVegetationCausedUnplannedOutage_20210501 - Simple
PGE_WireDownEvent_20210501 - Simple
Rasters
Workspace-Level Tables and Feature Classes
PGE_AssetInspectionLog_20210501 - Table
PGE_GridHardeningLog_20210501 - Table
PGE_InitiativePhotoLog_20210501 - Table
PGE_OtherInitiativeLog_20210501 - Table
PGE_PspsEventConductorDamageDetail_20210501 - Table
PGE_PspsEventDamagePhotoLog_20210501 - Table
PGE_PspsEventLog_20210501 - Table
PGE_PspsEventOtherAssetDamageDetail_20210501 - Table
PGE_PspsEventSupportStructureDamageDetail_20210501 - Table
PGE_RiskEventAssetLog_20210501 - Table
PGE_RiskEventPhotoLog_20210501 - Table
PGE_TransformerDetail_20210501 - Table
PGE_VegetationInspectionLog_20210501 - Table
PGE_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
PGE_AssetLine - FeatureDataset
PGE_PrimaryDistributionLine_20210501 - FeatureClass
Name | PGE_PrimaryDistributionLine_20210501 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Primary Distribution Line 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_PrimaryDistributionLine_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
CircuitID | String | 50 | Circuit ID | Unique ID for a specific circuit. It should be a traceable stable ID within the utility’s operations/processes. | | | true | | |
UtilityID | String | 30 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation feature class attribute table. | | | true | | |
LineClass | String | 30 | Line Class | Classification of line asset. Required value: Primary distribution | DomLineClass | | true | | |
CircuitName | String | 255 | Circuit Name | Name 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 | | |
County | String | 150 | County | County in which asset is located. If the line crosses multiple counties, list all counties separated by commas. | | | true | | |
ConductorType | String | 30 | Conductor Type | Type of conductor. Possible values: Bare, Covered, Other - See comment. | DomConductorType | | true | | |
ConductorTypeComment | String | 30 | Conductor Type Comment | Conductor type not listed in the options above. | | | true | | |
AssetOHUG | String | 30 | Asset OH or UG | Is the asset overhead or underground? Possible values: Overhead, Underground, Unknown. | DomOhUg | | true | | |
NominalVoltagekV | Single | 4 | Nominal Voltage (kV) | Nominal voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A. | | | true | | |
OperatingVoltagekV | Single | 4 | Operating Voltage (kV) | Operating voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A. | | | true | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | true | | |
ConductorMaterial | String | 50 | Conductor Material | Conductor 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. | DomConductorMaterial | | true | | |
ConductorMaterialComment | String | 50 | Conductor Material Comment | Conductor material not listed in the options above. | | | true | | |
ConductorSize | String | 30 | Conductor Size | Size of conductor (e.g. No. 4 Cu or 1/0 ACSR). | | | true | | |
ConductorOD | Single | 4 | Conductor Overall Diameter (inches) | Overall diameter of the conductor in inches. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Leave blank if unknown. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Leave blank if unknown. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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. | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.” | | | true | | |
AmpacityRating | Single | 4 | Ampacity Rating (A) | Nominal ampacity rating of the conductor in amperes. | | | true | | |
Greased | String | 10 | Greased | Is the conductor greased to prevent water intrusion? Possible values: Yes, No, Unknown. | DomYesNoUnknown | | true | | |
PGE_SecondaryDistributionLine_20210501 - FeatureClass
Name | PGE_SecondaryDistributionLine_20210501 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Secondary Distribution Line 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_SecondaryDistributionLine_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation feature class attribute table. | | | true | | |
LineClass | String | 30 | Line Class | Classification of line asset. Required value: Secondary distribution | DomLineClass | | true | | |
CircuitName | String | 255 | Circuit Name | Name 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 | | |
County | String | 150 | County | County in which asset is located. If the line crosses multiple counties, list all counties separated by commas. | | | true | | |
ConductorType | String | 30 | Conductor Type | Type of conductor. Possible values:Open wire, Duplex, Triplex, Quadruplex, Other – See comment. | DomConductorTypeSecondary | | true | | |
ConductorTypeComment | String | 30 | Conductor Type Comment | Conductor type not listed in the options above. | | | true | | |
AssetOHUG | String | 30 | Asset OH or UG | Is the asset overhead or underground? Possible values: Overhead, Underground, Unknown. | DomOhUg | | true | | |
NominalVoltagekV | String | 10 | 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 | | |
OperatingVoltagekV | String | 10 | 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 | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | true | | |
ConductorMaterial | String | 50 | Conductor Material | Conductor 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. | DomConductorMaterial | | true | | |
ConductorMaterialComment | String | 50 | Conductor Material Comment | Conductor material not listed in the options above. | | | true | | |
ConductorSize | String | 30 | Conductor Size | Size of conductor (e.g. No. 4 Cu or 1/0 ACSR). | | | true | | |
ConductorOD | Single | 4 | Conductor Overall Diameter (inches) | Overall diameter of the conductor in inches. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Leave blank if unknown. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Leave blank if unknown. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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. | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown. | | | true | | |
AmpacityRating | Single | 4 | Ampacity Rating (A) | Nominal ampacity rating of the conductor, in amperes). | | | true | | |
Greased | String | 10 | Greased | Is the conductor greased to prevent water intrusion? Possible values: Yes, No, Unknown. | DomYesNoUnknown | | true | | |
PGE_TransmissionLine_20210501 - FeatureClass
Name | PGE_TransmissionLine_20210501 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Transmission Line 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_TransmissionLine_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
CircuitID | String | 50 | Circuit ID | Unique ID for a specific circuit. It should be a traceable stable ID within the utility’s operations/processes. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation feature class attribute table. | | | true | | |
LineClass | String | 30 | Line Class | Classification of line asset. Possible values: Transmission, Sub-transmission. | DomLineClass | | true | | |
CircuitName | String | 255 | Circuit Name | Name 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 | | |
County | String | 150 | County | County in which asset is located. If the line crosses multiple counties, list all counties separated by commas. | | | true | | |
ConductorType | String | 30 | Conductor Type | Type of conductor. Possible values: Bare, Covered, Other - See comment. | DomConductorType | | true | | |
ConductorTypeComment | String | 30 | Conductor Type Comment | Conductor type not listed in the options above. | | | true | | |
AssetOHUG | String | 30 | Asset OH or UG | Is the asset overhead or underground? Possible values: Overhead, Underground, Unknown. | DomOhUg | | true | | |
NominalVoltagekV | Single | 4 | Nominal Voltage (kV) | Nominal voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A. | | | true | | |
OperatingVoltagekV | Single | 4 | Operating Voltage (kV) | Operating voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A. | | | true | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | true | | |
ConductorMaterial | String | 50 | Conductor Material | Conductor 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. | DomConductorMaterial | | true | | |
ConductorMaterialComment | String | 50 | Conductor Material Comment | Conductor material not listed in the options above. | | | true | | |
ConductorSize | String | 30 | Conductor Size | ConductorSize | | | true | | |
ConductorOD | Single | 4 | Conductor Overall Diameter (inches) | Overall diameter of the conductor in inches. | | | true | | |
Terminal1 | String | 50 | Terminal 1 | Substation name of first terminal. | | | true | | |
Terminal2 | String | 50 | Terminal 2 | Substation name of second terminal. | | | true | | |
Terminal3 | String | 50 | Terminal 3 | Substation name of third terminal. | | | true | | |
Terminal4 | String | 50 | Terminal 4 | Substation name of fourth terminal. | | | true | | |
Terminal5 | String | 50 | Terminal 5 | Substation name of fifth terminal. | | | true | | |
Terminals | String | 50 | Terminals | Terminals | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Leave blank if unknown. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Leave blank if unknown. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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. | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.” | | | true | | |
AmpacityRating | Single | 4 | Ampacity Rating (A) | Nominal ampacity rating of the conductor in amperes. | | | true | | |
Greased | String | 10 | Greased | Is the conductor greased to prevent water intrusion? Possible values: Yes, No, Unknown. | DomYesNoUnknown | | true | | |
PGE_AssetPoint - FeatureDataset
Description | PGE_AssetPoint |
PGE_Camera_20210501 - FeatureClass
Name | PGE_Camera_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Camera 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_Camera_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AssetID | String | 50 | Asset ID | Unique 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 | | |
SupportStructureID | String | 50 | Support Structure ID | Unique ID for support structure to which the camera is attached. It should be a traceable stable ID within the utility’s operations/processes. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., "UtilityG+E"). | | | true | | |
AssetType | String | 50 | Asset Type | Type of point asset. Required value: Camera | DomAssetType | | true | | |
CameraLocationName | String | 30 | Camera Location Name | Unique name of cameras location (e.g. “Cisco Buttes 1”, “Penn Valley”). For Alert Wildfire camers, this should match the name on the website. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Latitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_ConnectionDevice_20210501 - FeatureClass
Name | PGE_ConnectionDevice_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE ConnectionDevice 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_ConnectionDevice_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AssetID | String | 50 | Asset ID | Unique 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 | | |
FromStructureID | String | 50 | From Structure ID | ID 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 | | |
ToStructureID | String | 50 | To Structure ID | ID 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 | | |
CircuitID | String | 50 | Circuit ID | ID 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 | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
AssetType | String | 50 | Asset Type | Type of point asset. Required value: Line connection device | DomAssetType | | true | | |
AssetOHUG | String | 30 | Asset OH or UG | Is the asset overhead or underground? Possible values: Overhead, Underground, Unknown. | DomOhUg | | true | | |
ConnectionDeviceType | String | 30 | Connection Device Type | What type of connection device is the asset? Possible values: Splice, Connector, Clamp, Unknown, Other - See comment. | DomConnectionDeviceType | | true | | |
ConnectionDeviceTypeComment | String | 30 | Connection Device Type Comment | Connection device type not listed in the options above. | | | true | | |
ConnectionDeviceSubtype | String | 30 | Connection Device Subtype | What 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. | DomConnectionDeviceSubtype | | true | | |
ConnectionDeviceSubtypeComment | String | 30 | Connection Device Subtype Comment | Connection device subtype not listed in the options above. | | | true | | |
AssociatedNominalVoltagekV | String | 10 | Associated 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 | | |
AssociatedOperatingVoltagekV | String | 10 | Associated 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 | | |
CircuitName | String | 255 | Circuit Name | Name 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 | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | true | | |
Manufacturer | String | 50 | Manufacturer | Name 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 | | |
ModelNumber | String | 30 | Model Number | Model number of the asset. Enter “Unknown” if this cannot be determined. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Leave blank if unknown. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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. | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter "-99." | | | true | | |
ExemptionStatus | String | 10 | Exemption Status | Is 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. | DomYesNoUnknownNA | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_CustomerMeter_20210501 - FeatureClass
Name | PGE_CustomerMeter_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Customer Meter 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_CustomerMeter_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
MeterID | String | 50 | Meter ID | Unique 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
CircuitID | String | 50 | Circuit ID | ID 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 | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation feature class attribute table. | | | true | | |
AssetType | String | 50 | Asset Type | Type of point asset. Required value: Customer meter | DomAssetType | | true | | |
CircuitName | String | 255 | Circuit Name | Name 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 | | |
SubstationName | String | 30 | Substation Name | Name of substation associated with asset. | | | true | | |
Manufacturer | String | 50 | Manufacturer | Name 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 | | |
ModelNumber | String | 30 | Model Number | Model number of the asset. Enter “Unknown” if this cannot be determined. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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. | DomEstimatedAge | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_Fuse_20210501 - FeatureClass
Name | PGE_Fuse_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Fuse 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_Fuse_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AssetID | String | 50 | Asset ID | Unique 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 | | |
SupportStructureID | String | 50 | Support Structure ID | Unique 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation feature class attribute table. | | | true | | |
CircuitID | String | 50 | Circuit ID | ID 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 | | |
AssetType | String | 50 | Asset Type | Type of point asset: Required value: Fuse | DomAssetType | | true | | |
AssociatedNominalVoltagekV | String | 10 | Associated 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 | | |
AssociatedOperatingVoltagekV | String | 10 | AssociatedOperatingVoltage (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 | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name 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 | | |
Manufacturer | String | 50 | Manufacturer | Name 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 | | |
ModelNumber | String | 30 | Model Number | Model number of the asset. Enter “Unknown” if this cannot be determined. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Leave blank if unknown. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Leave blank if unknown. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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. | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.” | | | true | | |
ExemptionStatus | String | 10 | Exemption Status | Is 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. | DomYesNoUnknownNA | | true | | |
FuseRating | Single | 4 | Fuse Rating (A) | The nominal current rating of the fuse in amperes. | | | true | | |
FuseType | String | 30 | Fuse Type | Type of fuse device. Possible values: Bridged, Current limiting, Expulsion, Fused elbow, Unknown, Other – See comment. | DomFuseType | | true | | |
FuseTypeComment | String | 50 | Fuse Type Comment | Fuse type not listed in the options above. | | | true | | |
FuseSubtype | String | 30 | Fuse Subtype | What is the specific subtype of the fuse device? | | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_LightingArrester_20210501 - FeatureClass
Name | PGE_LightingArrester_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Lighting Arrester 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_LightingArrester_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AssetID | String | 50 | Asset ID | Unique 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 | | |
SupportStructureID | String | 50 | Support Structure ID | Unique 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation feature class attribute table. | | | true | | |
CircuitID | String | 50 | Circuit ID | ID 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 | | |
AssetType | String | 50 | Asset Type | Type of point asset. Required value: Lightning arrester | DomAssetType | | true | | |
AssociatedNominalVoltagekV | String | 10 | Associated 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 | | |
AssociatedOperatingVoltagekV | String | 10 | Associated 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 | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name 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 | | |
Manufacturer | String | 50 | Manufacturer | Name 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 | | |
ModelNumber | String | 30 | Model Number | Model number of the asset. Enter “Unknown” if this cannot be determined. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Leave blank if unknown. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Leave blank if unknown. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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. | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.” | | | true | | |
ExemptionStatus | String | 10 | Exemption Status | Is 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. | DomYesNoUnknownNA | | true | | |
ArresterRating | Single | 4 | Arrester Rating (kV) | Rating of the lightning arrester in kilovolts. | | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_Substation_20210501 - FeatureClass
Name | PGE_Substation_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Substation 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_Substation_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Primary key for the Substation feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
AssetType | String | 50 | Asset Type | Type of point asset. Required value: Substation | DomAssetType | | true | | |
SubstationName | String | 50 | Substation Name | Name of substation. | | | true | | |
SubstationNominalVoltagekV | String | 10 | Substation 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 | | |
SubstationOperatingVoltagekV | String | 10 | Substation 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 | | |
SubstationRating | Single | 4 | Substation Rating | Power rating of the substation in Megavolt-amperes (MVAs). | | | true | | |
SubstationType | String | 10 | Substation Type | Type of substation. Possible values: Network, Loop, Radial. | DomSubstationType | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Leave blank if unknown. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the first asset of the substation was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_SupportStructure_20210501 - FeatureClass
Name | PGE_SupportStructure_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Support Structure 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_SupportStructure_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
SupportStructureID | String | 50 | Support Structure ID | Unique 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation feature class attribute table. | | | true | | |
CircuitID | String | 50 | Circuit ID | ID 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 | | |
AssetType | String | 50 | Asset Type | Type of point asset. Required value: Support structure | DomAssetType | | true | | |
ExemptionStatus | String | 10 | Exemption Status | Does 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. | DomYesNoUnknownNA | | true | | |
CircuitName | String | 255 | CircuitName | Name 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 | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Leave blank if unknown. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Leave blank if unknown. | | | true | | |
LastIntrusiveDate | Date | 8 | Last Intrusive Date | Date of the last intrusive. Leave blank if unknown. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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. | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.” | | | true | | |
SupportStructureType | String | 30 | Support Structure Type | Type of support structure. Possible values: Pole, Tower, Other – See comment. | DomSupportStructureType | | true | | |
SupportStructureTypeComment | String | 30 | Support Structure Type Comment | Support structure type (analogous to a pole or tower) not listed in the options above. | | | true | | |
SupportStructureMaterial | String | 30 | Support Structure Material | Material from which pole, tower, or crossarm is made. Possible values: Wood, Metal, Composite, Wrapped wood, Concrete, Other – See comment. | DomSupportStructureMaterial | | true | | |
SupportStructureMaterialComment | String | 30 | Support Structure Material Comment | Support structure material not listed in the options above. | | | true | | |
SupportStructureMaterialSubtype | String | 30 | Support Structure Material Subtype | The subtype of structure material. For example, if a wood pole, the type of wood (i.e. Douglas Fir, Cedar, etc.). | | | true | | |
Underbuild | String | 3 | Underbuild | Does the line support multiple transmission or primary distribution circuits? Possible values: Yes, No. | DomYesNo | | true | | |
ConstructionGrade | String | 10 | Construction Grade | Grade of construction, in accordance with GO 95, Rule 42. Possible Values: Grade A, Grade B, Grade C. | DomConstructionGrade | | true | | |
CrossarmAttached | String | 10 | Crossarm Attached | Is one or more crossarms attached to the support structure? Possible values: Yes, No, Unknown. | DomYesNoUnknown | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_Switchgear_20210501 - FeatureClass
Name | PGE_Switchgear_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Switchgear 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_Switchgear_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AssetID | String | 50 | Asset ID | Unique 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 | | |
SupportStructureID | String | 50 | Support Structure ID | Unique 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation feature class attribute table. | | | true | | |
CircuitID | String | 50 | Circuit ID | ID 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 | | |
AssetType | String | 50 | Asset Type | Type of point asset. Required value: Switchgear | DomAssetType | | true | | |
AssetOHUG | String | 30 | Asset OH or UG | Is the asset overhead or underground? Possible values: Overhead, Underground, Unknown. | DomOhUg | | true | | |
AssociatedNominalVoltagekV | Single | 4 | Associated Nominal Voltage (kV) | Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A. | | | true | | |
AssociatedOperatingVoltagekV | Single | 4 | Associated Operating Voltage (kV) | Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A. | | | true | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name 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 | | |
Manufacturer | String | 50 | Manufacturer | Name 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 | | |
ModelNumber | String | 30 | Model Number | Model number of the asset. Enter “Unknown” if this cannot be determined. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Leave blank if unknown. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Leave blank if unknown. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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. | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.” | | | true | | |
ExemptionStatus | String | 10 | Exemption Status | Is 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. | DomYesNoUnknownNA | | true | | |
CurrentRating | Single | 4 | Current Rating (A) | Nominal current rating of the switchgear in amperes. | | | true | | |
AssetClass | String | 30 | Asset Class | Is the asset associated with transmission or distribution? If the asset is associated with subtransmission, enter “Transmission.” Possible values: Distribution, Transmission. | DomAssetClass | | true | | |
SCADAEnabled | String | 3 | SCADA Enabled | Can supervisory control and data acquisition (SCADA) be utilized with the asset? Possible values: Yes, No, N/A. | DomYesNoNA | | true | | |
SwitchgearType | String | 30 | Switchgear Type | Type of switchgear (switch, cut-out fuse, circuit breaker, etc.) | | | true | | |
SwitchgearSubtype | String | 30 | Switchgear Subtype | Specific type of switch, cut-out fuse, circuit breaker, etc. | | | true | | |
SwitchgearInsulatingMedium | String | 30 | Switchgear Insulating Medium | Medium (air, gas, oil, etc.) providing insulation for switchgear asset. Be specific. | | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_TransformerSite_20210501 - FeatureClass
Name | PGE_TransformerSite_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Transformer Site 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_TransformerSite_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
TransformerSiteID | String | 50 | Transformer Site ID | Unique 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 | | |
SupportStructureID | String | 50 | Support Structure ID | Unique 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
AssetType | String | 50 | Asset Type | Type of point asset. Required value: Transformer | DomAssetType | | true | | |
AssetOHUG | String | 30 | Asset OH or UG | Is the asset overhead or underground? Possible values: Overhead, Underground, Unknown. | DomOhUg | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
InaBank | String | 30 | In A Bank | Does 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. | DomYesNoUnknown | | true | | |
QuantityinBank | Integer | 4 | Quantity in Bank | How many transformers exist in a bank arrangement (if applicable)? Enter “-99” if unknown. | | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_WeatherStation_20210501 - FeatureClass
Name | PGE_WeatherStation_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Weather Station 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_WeatherStation_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
StationID | String | 50 | Station ID | The 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
AssetType | String | 50 | Asset Type | Type of point asset. Required field: Weather station | DomAssetType | | true | | |
Manufacturer | String | 150 | Manufacturer | Name 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 | | |
ModelNumber | String | 30 | Model Number | Model number of the asset. Enter “Unknown” if this cannot be determined. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Leave blank if unknown. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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. | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.” | | | true | | |
WeatherStationURL | String | 255 | Weather Station URL | Website address for weather station information (if publicly available). | | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_Initiative - FeatureDataset
Description | PGE_Initiative |
PGE_AssetInspectionLine_20210501 - FeatureClass
Name | PGE_AssetInspectionLine_20210501 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Asset Inspection Line 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_AssetInspectionLine_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AiID | String | 50 | AI ID | Unique ID or job ID of an asset inspection activity. Primary key for the Asset Inspection Line feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
AiLogID | String | 50 | AI Log ID | Unique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection Log related table. | | | true | | |
AssetID | String | 50 | Asset ID | Unique 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 | | |
CircuitID | String | 50 | Circuit ID | Unique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line tables. | | | true | | |
InspectionLocationOrAddress | String | 100 | Inspection Location Or Address | Address or location description for the inspection location. | | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory1 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
InspectionStatus | String | 30 | Inspection Status | The status of the asset inspection. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
HFTDClassComment | String | 50 | HFTD Class Comment | If the project line intersects multiple HFTD areas, list all of them here. | | | true | | |
County | String | 50 | County | County where the asset inspection project is located. If the data line intersects multiple counties, list all counties separated by commas. | | | true | | |
District | String | 100 | District | Operating district where the asset inspection project occurred. If the data line intersects multiple districts, list all districts separated by commas. | | | true | | |
PGE_AssetInspectionPoint_20210501 - FeatureClass
Name | PGE_AssetInspectionPoint_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Asset Inspection Point 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_AssetInspectionPoint_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AiID | String | 50 | AI ID | Unique ID or job ID of an asset inspection activity. Primary key for the Asset Inspection Point feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
AiLogID | String | 50 | AI Log ID | Unique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection Log related table. | | | true | | |
AssetID | String | 50 | Asset ID | Unique 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 | | |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
InspectionLocationOrAddress | String | 100 | Inspection Location Or Address | Address or location description for the inspection location. | | | true | | |
ParcelAPN | String | 25 | Parcel APN | 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. If the asset inspected does not intersect a parcel boundary, enter “N/A” for this field. | | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory1 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
InspectionStatus | String | 30 | Inspection Status | The status of the asset inspection. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County where the asset inspection project occurred. | | | true | | |
District | String | 100 | District | Operating district where the asset inspection project occurred. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_AssetInspectionPolygon_20210501 - FeatureClass
Name | PGE_AssetInspectionPolygon_20210501 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | PGE Asset Inspection Polygon 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_AssetInspectionPolygon_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AiID | String | 50 | AI ID | Unique ID or job ID of an asset inspection activity. Primary key for the Asset Inspection Polygon feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
AiLogID | String | 50 | AI Log ID | Unique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection Log related table. | | | true | | |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
ParcelAPN | String | 25 | Parcel APN | 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. If the asset inspected does not intersect a parcel boundary, enter “N/A” for this field. | | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory1 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
InspectionStatus | String | 30 | Inspection Status | The status of the asset inspection. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
HFTDClassComment | String | 50 | HFTD Class Comment | If the project line intersects multiple HFTD areas, list all of them here. | | | true | | |
County | String | 50 | County | County where the asset inspection project is located. If the data polygon intersects multiple counties, list all counties separated by commas. | | | true | | |
District | String | 100 | District | Operating district where the asset inspection project occurred. If the data polygon intersects multiple districts, list all districts separated by commas. | | | true | | |
PGE_GridHardeningLine_20210501 - FeatureClass
Name | PGE_GridHardeningLine_20210501 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Grid Hardening Line 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_GridHardeningLine_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
GhID | String | 50 | GH ID | Unique ID or job ID of a grid hardening activity. Primary key for the Grid Hardening Line feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
GhLogID | String | 50 | GH Log ID | Unique ID or job ID of a grid hardening activity. Foreign key to the Grid Hardening Log related table. | | | true | | |
AssetID | String | 50 | Asset ID | Unique 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 | | |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
GridHardeningLocationOrAddress | String | 100 | Grid Hardening Location Or Address | Address or location description for the grid hardening location. | | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory1 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
GhStatus | String | 30 | GH Status | The status of the grid hardening activity. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
HFTDClassComment | String | 50 | HFTD Class Comment | If the project line intersects multiple HFTD areas, list all of them here. | | | true | | |
County | String | 50 | County | County where the grid hardening project is located. If the data line intersects multiple counties, list all counties separated by commas. | | | true | | |
District | String | 100 | District | Operating district where the grid hardening project is located. If the data line intersects multiple districts, list all districts separated by commas. | | | true | | |
PGE_GridHardeningPoint_20210501 - FeatureClass
Name | PGE_GridHardeningPoint_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Grid Hardening Point 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_GridHardeningPoint_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
GhID | String | 50 | GH ID | Unique ID or job ID of a grid hardening activity. Primary key for the Grid Hardening Point feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
GhLogID | String | 50 | GH Log ID | Unique ID or job ID of a grid hardening activity. Foreign key to the Grid Hardening Log related table. | | | true | | |
AssetID | String | 50 | Asset ID | Unique 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 | | |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
GridHardeningLocationOrAddress | String | 100 | Grid Hardening Location Or Address | Address or location description for the grid hardening location. | | | true | | |
ParcelAPN | String | 25 | Parcel APN | 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. If the asset inspected does not intersect a parcel boundary, enter “N/A” for this field. | | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory1 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
GhStatus | String | 30 | GH Status | The status of the grid hardening activity. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County where the grid hardening project is located. | | | true | | |
District | String | 100 | District | Operating district where the grid hardening project is located. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_OtherInitiativeLine_20210501 - FeatureClass
Name | PGE_OtherInitiativeLine_20210501 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Other Initiative Line 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_OtherInitiativeLine_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
OiID | String | 50 | OI ID | Unique ID of Other initiative activity. Primary key for the Other Initiative Line feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
OiLogID | String | 50 | OI Log ID | Unique ID or job ID of a 'Other Initiative' activity. Foreign key to the Other Initiative Log related table. | | | true | | |
LocationOrAddress | String | 100 | Location or Address | Address or location description for the activity. | | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory2 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
OiStatus | String | 30 | Other Initiative Status | The status of the activity. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
County | String | 50 | County | County where the initiative is located. If the data line intersects multiple counties, list all counties separated by commas. | | | true | | |
District | String | 100 | District | Operating district where the initiative is located. If the data line intersects multiple districts, list all districts separated by commas. | | | true | | |
PGE_OtherInitiativePoint_20210501 - FeatureClass
Name | PGE_OtherInitiativePoint_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Other Initiative Point 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_OtherInitiativePoint_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
OiID | String | 50 | OI ID | Unique ID or job ID of an Other Initiative activity. Primary key for the Other Initiative Point feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
OiLogID | String | 50 | OI Log ID | Unique ID or job ID of an Other Initiative activity. Foreign key to the Other Initiative Log related table. | | | true | | |
LocationOrAddress | String | 100 | Location or Address | Address or location description for the activity. | | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory2 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
OiStatus | String | 30 | Other Initiative Status | The status of the activity. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
County | String | 50 | County | County where the initiative is located. | | | true | | |
District | String | 100 | District | Operating district where the initiative is located. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of point in decimal degrees. Field-calculate in GIS software. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of point in decimal degrees. Field-calculate in GIS software. | | | true | | |
PGE_OtherInitiativePolygon_20210501 - FeatureClass
Name | PGE_OtherInitiativePolygon_20210501 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | PGE Other Initiative Polygon 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_OtherInitiativePolygon_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
OiID | String | 50 | OI ID | Unique ID of Other initiative activity. Primary key for the Other Initiative Polygon feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
OiLogID | String | 50 | OI Log ID | Unique ID or job ID of a 'Other Initiative' activity. Foreign key to the Other Initiative Log table. | | | true | | |
LocationOrAddress | String | 100 | Location or Address | Address or location description for the activity. | | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory2 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
OiStatus | String | 30 | Other Initiative Status | The status of the activity. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
County | String | 50 | County | County where the initiative is located. If the data polygon intersects multiple counties, list all counties separated by commas. | | | true | | |
District | String | 100 | District | Operating district where the initiative is located. If the data polygon intersects multiple districts, list all districts separated by commas. | | | true | | |
PGE_VegetationInspectionLine_20210501 - FeatureClass
Name | PGE_VegetationInspectionLine_20210501 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Vegetation Inspection Line 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_VegetationInspectionLine_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
VmiID | String | 50 | VMI ID | Unique ID or job ID of a vegetation inspection activity. Primary key for the Vegetation Inspection Line feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
VmiLogID | String | 50 | VMI Log ID | Unique ID or job ID of a vegetation inspection activity. Foreign key to the Vegetation Inspection Log related table. | | | true | | |
AssetID | String | 50 | Asset ID | Unique 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 | | |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
InspectionLocationOrAddress | String | 100 | Inspection Location Or Address | Address or location description for the inspection location. | | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory1 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
InspectionStatus | String | 30 | Inspection Status | The status of the vegetation inspection project. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
HFTDClassComment | String | 50 | HFTD Class Comment | HFTDClassComment | | | true | | |
County | String | 50 | County | County where the vegetation management inspection occurred. If the data line intersects multiple counties, list all counties separated by commas. | | | true | | |
District | String | 100 | District | Operating district where the vegetation management inspection occurred. If the data line intersects multiple districts, list all districts separated by commas. | | | true | | |
PGE_VegetationInspectionPoint_20210501 - FeatureClass
Name | PGE_VegetationInspectionPoint_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Vegetation Inspection Point 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_VegetationInspectionPoint_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
VmiID | String | 50 | VMI ID | Unique ID or job ID of a vegetation inspection activity. Primary key for the Vegetation Inspection Point feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
VmiLogID | String | 50 | VMI Log ID | Unique ID or job ID of a vegetation inspection activity. Foreign key to the Vegetation Inspection Log related table. | | | true | | |
AssetID | String | 50 | Asset ID | Unique 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 | | |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
InspectionLocationOrAddress | String | 100 | Inspection Location Or Address | Address or location description for the inspection location. | | | true | | |
ParcelAPN | String | 25 | Parcel APN | 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 | | |
TreeHealth | String | 3 | Tree Health | Is the tree healthy? Possible values: Yes, No. | DomYesNo | | true | | |
TreeSpecies | String | 100 | Tree Species | Common name for species of tree. | | | true | | |
TreeHeight | Integer | 4 | Tree Height (feet) | Tree height (feet). Round the value. Maximum value: 300. | DomTreeHeight | | true | | |
TreeDiameter | Integer | 4 | Tree Diameter (inches) | Tree diameter at breast height (inches). Round the value. Maximum value: 180. | DomTreeDiameter | | true | | |
TreeDistance | Integer | 4 | Tree Distance (feet) | Distance (in feet) between tree and nearest utility asset. | | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory1 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
InspectionStatus | String | 30 | Inspection Status | The status of the vegetation inspection project. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County where the vegetation inspection is located. | | | true | | |
District | String | 100 | District | Operating district where the vegetation inspection occurred. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_VegetationInspectionPolygon_20210501 - FeatureClass
Name | PGE_VegetationInspectionPolygon_20210501 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | PGE Vegetation Inspection Polygon 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_VegetationInspectionPolygon_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
VmiID | String | 50 | VMI ID | Unique ID or job ID of a vegetation inspection activity. Primary key for the Vegetation Inspection Polygon feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
VmiLogID | String | 50 | VMI LogID | Unique ID or job ID of a vegetation inspection activity. Foreign key to the Vegetation Inspection Log related table. | | | true | | |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
InspectionLocationOrAddress | String | 100 | Inspection Location Or Address | Address or location description for the inspection location. | | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory1 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
InspectionStatus | String | 30 | Inspection Status | The status of the vegetation inspection project. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
HFTDClassComment | String | 50 | HFTD Class Comment | HFTDClassComment | | | true | | |
County | String | 50 | County | County where the vegetation management inspection is located. If the data polygon intersects multiple counties, list all counties separated by commas. | | | true | | |
District | String | 100 | District | Operating district where the vegetation management inspection occurred. If the data polygon intersects multiple districts, list all districts separated by commas. | | | true | | |
PGE_VegetationManagementProjectLine_20210501 - FeatureClass
Name | PGE_VegetationManagementProjectLine_20210501 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Vegetation Management Project Line 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_VegetationManagementProjectLine_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
VmpID | String | 50 | VMP ID | Unique ID or job ID of an initiative. Primary key for Vegetation Management Project Line feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
VmpLogID | String | 50 | VMP Log ID | Unique ID or job ID of an initiative. Foreign key to the Vegetation Inspection Project Log related table. | | | true | | |
AssetID | String | 50 | Asset ID | Unique 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 | | |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
ProjectLocationOrAddress | String | 100 | Project Location Or Address | Address or location description for project location. | | | true | | |
LineDeenergized | String | 3 | Line Deenergized? | Do the power lines need to be de-energized to perform the work? Possible values: Yes, No. | DomYesNo | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory1 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
VmpStatus | String | 30 | Vegetation Management Project Status | The status of the vegetation management project. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
HerbicideUse | String | 3 | Herbicide Use | Are any herbicides planned to be used or were any herbicides used as part of the project? Possible values: Yes, No | DomYesNo | | true | | |
HerbicideName | String | 100 | Herbicide Name | If any herbicides are planned for use or were used, list the specific products used / to be used. | | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
HFTDClassComment | String | 50 | HFTD Class Comment | If the project line intersects multiple HFTD areas, list all of them here. | | | true | | |
County | String | 50 | County | County where the vegetation management project is located. If the data line intersects multiple counties, list all counties separated by commas. | | | true | | |
District | String | 100 | District | Operating district where the vegetation management project occurred. If the data line intersects multiple districts, list all districts separated by commas. | | | true | | |
PGE_VegetationManagementProjectPoint_20210501 - FeatureClass
Name | PGE_VegetationManagementProjectPoint_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Vegetation Management Project Point 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_VegetationManagementProjectPoint_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
VmpID | String | 50 | VMP ID | Unique ID or job ID of an initiative. Primary key for Vegetation Management Project Point feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
VmpLogID | String | 50 | VMP Log ID | Unique ID or job ID of an initiative. Foreign key to the Vegetation Inspection Project Log related table. | | | true | | |
AssetID | String | 50 | Asset ID | Unique 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 | | |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
ProjectLocationOrAddress | String | 100 | Project Location Or Address | Address or location description for vegetation project location. Enter “N/A” if there is no address where the project is located. | | | true | | |
ParcelAPN | String | 25 | Parcel APN | 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 | | |
TreeID | String | 50 | Tree ID | A unique ID associated with the individual tree within the scope of the vegetation management project. | | | true | | |
TreeHealth | String | 3 | Tree Health | Is the subject tree healthy? Possible values: Yes, No. | DomYesNo | | true | | |
TreeHazard | String | 3 | Tree Hazard | Is the subject tree a hazard tree? Possible values: Yes, No. | DomYesNo | | true | | |
TreeSpecies | String | 100 | Tree Species | Common name for tree species in scope for the vegetation management project. | | | true | | |
SpeciesGrowthRate | String | 30 | Species Growth Rate | Generalized growth rate of the subject tree species. Possible values: Slow growing, Moderately growing, Fast growing. | DomSpeciesGrowthRate | | true | | |
TreeHeight | Integer | 4 | Tree Height (feet) | Tree height (feet). Round the value. Maximum value: 300. | DomTreeHeight | | true | | |
TreeDiameter | Integer | 4 | Tree Diameter (inches) | Tree diameter at breast height (inches). Round the value. Maximum value: 180. | DomTreeDiameter | | true | | |
LineDeenergized | String | 3 | Line Deenergized? | Do the power lines need to be de-energized to perform the work? Possible values: Yes, No. | DomYesNo | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory1 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
VmpStatus | String | 30 | Vegetation Management Project Status | The status of the vegetation management project. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
HerbicideUse | String | 3 | Herbicide Use | Are any herbicides planned to be used or were any herbicides used as part of the project? Possible values: Yes, No | DomYesNo | | true | | |
HerbicideName | String | 100 | Herbicide Name | If any herbicides are planned for use or were used, list the specific products used / to be used. | | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County where the vegetation management project is located. | | | true | | |
District | String | 100 | District | Operating district where the vegetation management project occurred. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_VegetationManagementProjectPolygon_20210501 - FeatureClass
Name | PGE_VegetationManagementProjectPolygon_20210501 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | PGE Vegetation Management Project Polygon 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_VegetationManagementProjectPolygon_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
VmpID | String | 50 | VMP ID | Unique ID or job ID of an initiative. Primary key for Vegetation Management Project Polygon feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
VmpLogID | String | 50 | VMP Log ID | Unique ID or job ID of an initiative. Foreign key to the Vegetation Inspection Project Log related table. | | | true | | |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
ProjectLocationOrAddress | String | 100 | Project Location Or Address | Address or location description for project location. | | | true | | |
LineDeenergized | String | 3 | Line Deenergized? | Do the power lines need to be de-energized to perform the work? Possible values: Yes, No. | DomYesNo | | true | | |
WMPInitiativeCategory | String | 50 | WMP Initiative Category | Broad 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. | DomInitiativeCategory1 | | true | | |
WMPInitiativeActivity | String | 150 | WMP Initiative Activity | More 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 | | |
WMPSection | String | 15 | WMP Section | Section of WMP tied to initiative. | | | true | | |
WMPPageNumber | Integer | 4 | WMP Page Number | Page number of WMP where section begins. | | | true | | |
VmpStatus | String | 30 | Vegetation Management Project Status | The status of the vegetation management project. Possible values: Planned, In-progress, Complete | DomStatus | | true | | |
HerbicideUse | String | 3 | Herbicide Use | Are any herbicides planned to be used or were any herbicides used as part of the project? Possible values: Yes, No | DomYesNo | | true | | |
HerbicideName | String | 100 | Herbicide Name | If any herbicides are planned for use or were used, list the specific products used / to be used. | | | true | | |
InitiativeTarget | Single | 4 | Initiative Target | The 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 | | |
InitiativeProgress | Single | 4 | Initiative Progress | The 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 | | |
InitiativeTargetUnits | String | 50 | Initiative Target Units | The units (e.g., trees, line miles, etc.) for the numerical InitiativeTarget identified above. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
HFTDClassComment | String | 50 | HFTD Class Comment | HFTDClassComment | | | true | | |
County | String | 50 | County | County where the vegetation management project is located. If the data polygon intersects multiple counties, list all counties separated by commas. | | | true | | |
District | String | 100 | District | Operating district where the vegetation management project occurred. If the data polygon intersects multiple districts, list all districts separated by commas. | | | true | | |
PGE_OtherRequiredData - FeatureDataset
Name | PGE_OtherRequiredData |
Description | PGE_OtherRequiredData |
PGE_AdministrativeArea_20210501 - FeatureClass
Name | PGE_AdministrativeArea_20210501 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | PGE Administrative Area 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_AdministrativeArea_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AdminID | String | 50 | Admin ID | Unique ID and primary key for the Administrative Area feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
AreaType | String | 50 | Area Type | Type of administrative area (service territory, region, district, zone, etc.) | | | true | | |
SubareaType | String | 50 | Subarea Type | Utility 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. | DomSubareaType | | true | | |
SubareaTypeComment | String | 50 | Subarea Type Comment | Sub-area type not listed in the options above. | | | true | | |
Name | String | 100 | Name | Name of administrative area. | | | true | | |
PGE_CriticalFacility_20210501 - FeatureClass
Name | PGE_CriticalFacility_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Critical Facility 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_CriticalFacility_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
FacilityID | String | 50 | Facility ID | Unique 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
FacilityName | String | 100 | Facility Name | Name of the facility. | | | true | | |
FacilityCategory | String | 30 | Facility Category | Critical 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. | DomFacilityCategory | | true | | |
FacilityCategoryComment | String | 30 | Facility Category Comment | Facility category not covered by the options above. | | | true | | |
FacilityDescription | String | 50 | Facility Description | Brief facility description (e.g., fire station, prison, nursing home, etc.). | | | true | | |
CircuitID | String | 50 | Circuit ID | ID of circuit associated with critical facility. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name 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 | | |
MeterID | String | 50 | Meter ID | ID of meter associated with critical facility. | | | true | | |
BackupPower | String | 10 | Backup Power | Does the facility have a backup power source? Possible values: Yes, No, Unknown. | DomYesNoUnknown | | true | | |
BackupType | String | 30 | Backup Type | Type of backup power source. Possible values: Storage battery, Diesel generator, Gas generator, Combined/hybrid, Other – See comment. | DomBackupType | | true | | |
BackupTypeComment | String | 30 | Backup Type Comment | Backup type not listed in the options above. | | | true | | |
BackupCapacity | Single | 4 | Backup Capacity | Hours of energy storage of backup generation from backup power source. | | | true | | |
PopulationImpact | Integer | 4 | Population Impact | The approximate number of people that depend on this critical facility. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
PSPSDays | Integer | 4 | PSPS Days | The number of days the critical facility was impacted by PSPS events in the last 365 days. | | | true | | |
PSPSDaysDateBasis | Date | 8 | PSPS Days Date Basis | The 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 | | |
ParcelAPN | String | 25 | Parcel APN | ID 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 | | |
Address | String | 100 | Address | The address of the critical facility. | | | true | | |
City | String | 50 | City | The city of the critical facility. | | | true | | |
Zip | String | 5 | Zip | The 5-digit zip code of the critical facility. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude coordinate of critical facility (in decimal degrees). Field-calculate in GIS software. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude coordinate of critical facility (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_MajorWoodyStemExemptTreePoint_20210501 - FeatureClass
Name | PGE_MajorWoodyStemExemptTreePoint_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Major Woody Stem Exempt Tree Point 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_MajorWoodyStemExemptTreePoint_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
Species | String | 100 | Species | Tree species common name. Do not use codes of scientific names. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Last date MWS tree was inspected. | | | true | | |
Quantity | Integer | 4 | Quantity | Quantity 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 | | |
Latitude | Single | 4 | Latitude | Latitude of MWS tree point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of MWS tree point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_OtherPowerLineConnectionLocation_20210501 - FeatureClass
Name | PGE_OtherPowerLineConnectionLocation_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Other Power Line Connection Location 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_OtherPowerLineConnectionLocation_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
OplcID | String | 50 | OPLC ID | Unique 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
OtherLineOwner | String | 100 | Other Line Owner | Name of individual or other entity that owns the line to which the submitting corporation's electrical corporation line is connecting. | | | true | | |
ConnectionAsset | String | 100 | Connection Asset | Asset enabling the connection. | | | true | | |
ConnectionPointAssetID | String | 50 | Connection Point Asset ID | AssetID 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 | | |
CorporationLineID | String | 50 | Corporation Line ID | AssetID 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 | | |
OtherLineClass | String | 30 | Other Line Class | Classification of line asset that meets corporation line at connection location. Possible values: Transmission, Primary distribution, Secondary distribution, Unknown | DomCircuitType | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which connection location is located. | | | true | | |
OtherConductorType | String | 30 | Other Conductor Type | Type of conductor that connects to corporation line. Possible values: Bare, Covered, Unknown | DomConductorType | | true | | |
ConnectionType | String | 30 | Connection Type | Type of energy transfer happening at location. Possible values: Corporation to private, Corporation to corporation | DomConnectionType | | true | | |
ConnectionOHUG | String | 50 | Connection OH or UG | Is the connection overhead or underground? Possible values: All Overhead, All underground, Overhead to underground, Underground to overhead, Unknown | DomConnectionOhUg | | true | | |
OtherNominalVoltagekV | Single | 4 | Other 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 | | |
OtherOperatingVoltagekV | Single | 4 | Other 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 | | |
OtherConductorMaterial | String | 100 | Other Conductor Material | Conductor 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 comment | DomConductorMaterial | | true | | |
OtherConductorMaterialComment | String | 50 | Other Conductor Material Comment | Conductor material not listed in the options above. | | | true | | |
OtherConductorSize | String | 30 | Other Conductor Size | Size 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 | | |
OtherConductorOD | Single | 4 | Other 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 | | |
ConnectionLastInspectionDate | Date | 8 | Connection Last Inspection Date | Date of the last maintenance. Leave blank if unknown. | | | true | | |
ConnectionLastMaintenanceDate | Date | 8 | Connection Last Maintenance Date | Date the connection was established. Leave blank if unknown. | | | true | | |
ConnectionEstablishmentDate | Date | 8 | Connection Establishment Date | Date the connection was established. Leave blank if unknown. | | | true | | |
ConnectionEstablishmentYear | Integer | 4 | Connection Establishment Year | Year of connection establishment. Leave blank if unknown. | | | true | | |
EstimatedConnectionAge | String | 10 | Estimated Connection Age | The 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. | DomEstimatedAge | | true | | |
OtherUsefulLifespan | Integer | 4 | Other Useful Lifespan | The 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 | | |
OtherAmpacityRating | Single | 4 | Other Ampacity Rating | Nominal ampacity rating of the other conductor in amperes. | | | true | | |
OtherLineGreased | String | 10 | Other Line Greased | Is the other conductor connected to the corporation line greased to prevent water intrusion? Possible values: Yes, No, Unknown. | DomYesNoUnknown | | true | | |
ConnectionComments | String | 100 | Other Power Line Comments | Describe any additional key details that should be known about the connection location. | | | true | | |
PGE_RedFlagWarningDayPolygon_20210501 - FeatureClass
Name | PGE_RedFlagWarningDayPolygon_20210501 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | PGE Red Flag Warning Day Polygon 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_RedFlagWarningDayPolygon_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
RfwID | String | 50 | RFW ID | Unique ID and primary key for the Red Flag Warning Day feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
FireWeatherZoneID | String | 50 | Fire Weather Zone ID | ID number of fire weather zone. | | | true | | |
FireWeatherZoneName | String | 30 | Fire Weather Zone Name | Unique ID for a specific point asset. It should be a traceable stable ID within the utility’s operations/processes. | | | true | | |
RedFlagWarningIssueDateTime | Date | 8 | Red Flag Warning Issue Date and Time | Start date and time of the Red Flag Warning. | | | true | | |
NumberRedFlagWarningDays | Single | 4 | Number Red Flag Warning Days | Number of red flag warning days experienced in the fire weather zone in the last 365 days. | | | true | | |
RedFlagDaysDateBasis | Date | 8 | Red Flag Days Date Basis | The 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 | | |
PGE_PspsEvent - FeatureDataset
PGE_PspsEventCustomerMeterPoint_20210501 - FeatureClass
Name | PGE_PspsEventCustomerMeterPoint_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE PSPS Event Customer Meter Point 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_PspsEventCustomerMeterPoint_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
PspsEventMeterID | String | 50 | PSPS Event Meter ID | An underscore delimited concatenation of "EventID"+"_"+"AssetID.” Primary key for the PSPS Event Customer Meter Point feature class attribute table. | | | true | | |
EventID | String | 50 | Event ID | A 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 | | |
AssetID | String | 50 | Circuit ID | Unique 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
PGE_PspsEventDamagePoint_20210501 - FeatureClass
Name | PGE_PspsEventDamagePoint_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE PSPS Event Damage Point 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_PspsEventDamagePoint_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
DamageEventID | String | 50 | Damage Event ID | ID 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 | | |
EventID | String | 50 | Event ID | A unique standardized identification name of the unique event. Foreign key enabling connection to the PSPS Event Log related table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
FuelBedDescription | String | 150 | Fuel Bed Description | Type 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. | DomFuelBedDescription | | true | | |
FuelBedDescriptionComment | String | 150 | Fuel Bed Description Comment | Fuel bed description not listed in the options above. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County in which asset damage is located. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of point in decimal degrees. Field-calculate in GIS software. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of point in decimal degrees. Field-calculate in GIS software. | | | true | | |
PGE_PspsEventLine_20210501 - FeatureClass
Name | PGE_PspsEventLine_20210501 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE PSPS Event Line 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_PspsEventLine_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
PspsEventLineID | String | 50 | PSPS Event Line ID | An underscore delimited concatenation of "EventID"+"_"+"CircuitID.” Primary key for the PSPS Event Line feature class attribute table. | | | true | | |
EventID | String | 50 | Event ID | A unique standardized identification name of the unique event. Foreign key enabling connection to PSPS Event Log related table. | | | true | | |
CircuitID | String | 50 | Circuit ID | A 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 | | |
SubstationID | String | 50 | Substation ID | A 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 | | |
IsolationDeviceID | String | 50 | Isolation Device ID | A 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
CircuitName | String | 255 | Circuit Name | Name 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 | | |
SubstationName | String | 100 | Substation Name | Name of substation associated with asset. | | | true | | |
IsolationDevice | String | 30 | Isolation Device | The 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. | DomPspsIsolationDevice | | true | | |
IsolationDeviceComment | String | 50 | Isolation Device Comment | Isolation device not listed in the options above. | | | true | | |
PredictedDurationMinutes | Integer | 4 | Predicted Duration Minutes | Anticipated duration of PSPS event's circuit shutoff after it is initiated. Must be reported in whole number minutes. | | | true | | |
ActualDurationMinutes | Integer | 4 | Actual Duration Minutes | Actual 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 | | |
DurationPredictionError | Integer | 4 | Duration Prediction Error | “PredictedDurationMinutes” minus “ActualDurationMinutes.” Positive values indicate shorter than predicted PSPS outage duration; negative values indicate longer than predicted PSPS outage duration. | | | true | | |
TotalCustomerMinutes | Integer | 4 | Total Customer Minutes | Actual outage minutes experienced by customers. | | | true | | |
TotalCustomers | Integer | 4 | Total Customers | Total 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 | | |
ResidentialCustomers | Integer | 4 | Residential Customers | Total residential customers. | | | true | | |
MedicalBaselineCustomers | Integer | 4 | Medical Baseline Customers | Total medical baseline customers. | | | true | | |
CommercialIndustrialCustomers | Integer | 4 | Commercial Industrial Customers | Total commercial/industrial customers. | | | true | | |
OtherCustomers | Integer | 4 | Other Customers | Total customers that do not fall within residential or commercial/industrial (as requested under Decision 12-04-024). | | | true | | |
CriticalInfrastructure | Integer | 4 | Critical Infrastructure | Number of critical infrastructure locations (in accordance with Decision 19-05-042 as modified by D.20-05-051) impacted by the PSPS event. | | | true | | |
CriticalInfrastructureDuration | Integer | 4 | Critical Infrastructure Duration | Duration 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 | | |
CriticalInfrastructureImpact | Integer | 4 | Critical Infrastructure Impact | “CriticalInfrastructure” multiplied by “CriticalInfrastructureDuration.” | | | true | | |
County | String | 150 | County | County in which asset is located. If the line crosses multiple counties, list all counties separated by commas. | | | true | | |
PGE_PspsEventPolygon_20210501 - FeatureClass
Name | PGE_PspsEventPolygon_20210501 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | PGE PSPS Event Polygon 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_PspsEventPolygon_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
PspsEventPolygonID | String | 50 | PSPS Event Polygon ID | Primary key for the PSPS Event Polygon feature class attribute table. | | | true | | |
EventID | String | 50 | Event ID | A unique standardized identification name of the unique event. Foreign key enabling connection to the PSPS Event Log related table. | | | true | | |
CircuitID | String | 50 | Circuit ID | A 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 | | |
SubstationID | String | 50 | Substation ID | A 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 | | |
IsolationDeviceID | String | 50 | Isolation Device ID | A 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 | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
CircuitName | String | 255 | Circuit Name | Name 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 | | |
SubstationName | String | 100 | Substation Name | Name of substation associated with asset. | | | true | | |
IsolationDevice | String | 30 | Isolation Device | The 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. | DomPspsIsolationDevice | | true | | |
IsolationDeviceComment | String | 50 | Isolation Device Comment | Isolation device not listed in the options above. | | | true | | |
PredictedDurationMinutes | Integer | 4 | Predicted Duration Minutes | Anticipated duration of PSPS event's circuit shutoff after it is initiated. Must be reported in whole number minutes. | | | true | | |
ActualDurationMinutes | Integer | 4 | Actual Duration Minutes | Actual 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 | | |
DurationPredictionError | Integer | 4 | Duration Prediction Error | “PredictedDurationMinutes” minus “ActualDurationMinutes.” Positive values indicate shorter than predicted PSPS outage duration; negative values indicate longer than predicted PSPS outage duration. | | | true | | |
TotalCustomerMinutes | Integer | 4 | Total Customer Minutes | Actual outage minutes experienced by customers. | | | true | | |
TotalCustomers | Integer | 4 | Total Customers | Total 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 | | |
ResidentialCustomers | Integer | 4 | Residential Customers | Total residential customers. | | | true | | |
MedicalBaselineCustomers | Integer | 4 | Medical Baseline Customers | Total medical baseline customers. | | | true | | |
CommercialIndustrialCustomers | Integer | 4 | Commercial Industrial Customers | Total commercial/industrial customers. | | | true | | |
OtherCustomers | Integer | 4 | Other Customers | Total customers that do not fall within residential or commercial/industrial (as requested under Decision 12-04-024). | | | true | | |
CriticalInfrastructure | Integer | 4 | Critical Infrastructure | Number of critical infrastructure locations (in accordance with Decision 19-05-042 as modified by D.20-05-051) impacted by the PSPS event. | | | true | | |
CriticalInfrastructureDuration | Integer | 4 | Critical Infrastructure Duration | Duration 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 | | |
CriticalInfrastructureImpact | Integer | 4 | Critical Infrastructure Impact | “CriticalInfrastructure” multiplied by “CriticalInfrastructureDuration.” This field features the total PSPS impact on critical infrastructure. | | | true | | |
County | String | 150 | County | County in which parcel affected by PSPS event is located. If the data polygon intersects multiple counties, list all counties separated by commas. | | | true | | |
PGE_RiskEvent - FeatureDataset
PGE_DistributionUnplannedOutage_20210501 - FeatureClass
Name | PGE_DistributionUnplannedOutage_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Distribution Unplanned Outage 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_DistributionUnplannedOutage_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
DoutageID | String | 50 | Distribution Outage ID | The unique ID for the distribution unplanned outage event. Primary key for the Distribution Unplanned Outage feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
SubstationID | String | 50 | Substation ID | Unique 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 | | |
BasicCause | String | 30 | Basic Cause | High-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. | DomCause | | true | | |
BasicCauseComment | String | 50 | Basic Cause Comment | Basic 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 | | |
BasicCauseObject | String | 30 | Basic Cause Object | Description 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. | DomObjectContact | | true | | |
BasicCauseObjectComment | String | 50 | Basic Cause Object Comment | Basic cause object description not listed in the options above; or, any additional information about object. | | | true | | |
DamagedDevice | String | 30 | Damaged Device | The 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. | DomEquipmentFailure | | true | | |
DamagedDeviceComment | String | 50 | Damaged Device Comment | Damaged device description not listed in the options above; or, any additional information about damaged device. | | | true | | |
ExpulsionFuseOperation | String | 3 | Expulsion Fuse Operation | Did 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. | DomYesNoNA | | true | | |
OutageDescription | String | 100 | Outage Description | Description or additional information for the outage. Not required. | | | true | | |
EventYear | Integer | 4 | Event Year | The year outage started. Use four digits. | | | true | | |
OutageStartDateTime | Date | 8 | Outage Start Date and Time | The date and time outage started. Leave blank if unknown. | | | true | | |
OutageEndDateTime | Date | 8 | Outage End Date and Time | The date and time of full restoration. | | | true | | |
OutageDuration | Single | 4 | Outage Duration | The total time to restore all customers, from the first customer out, in minutes. | | | true | | |
CustomerMinutesInterrupted | Single | 4 | Customer-Minutes Interrupted | Total customer-minutes interrupted associated with the outage. Not more than two decimal places. | | | true | | |
CustomersOutMomentary | Integer | 4 | Customers Out Momentary | Total 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 | | |
CustomersOutSustained | Integer | 4 | Customers Out Sustained | Total 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 | | |
CustomerCount | Integer | 4 | Customer Count | The 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 | | |
OutageInterval | String | 30 | Outage Interval | Indication 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. | DomOutageInterval | | true | | |
OutageIntervalAlternativeDefinition | String | 30 | Outage Interval Alternative Definition | If the utility uses a different definition of “momentary” than specified above (5 minutes or less), specify the alternative definition here. | | | true | | |
AssociatedNominalVoltagekV | String | 10 | Associated 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 | | |
AssociatedOperatingVoltagekV | String | 10 | Associated 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 | | |
OtherCompanies | String | 150 | Other Companies | Companies (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 | | |
OutageClass | String | 30 | Outage Class | The class of circuit involved in the outage. Required value: Distribution | | | true | | |
RecloserSetting | String | 30 | Recloser Setting | If 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. | DomRecloserSetting | | true | | |
IsolationDeviceType | String | 30 | Isolation Device Type | Type of protective device that operated. Possible values: Circuit Breaker, Fuse, Lightning Arrester, Switch, Transformer, Recloser, Jumper, Other – See comment. | DomIsolationDevice | | true | | |
IsolationDeviceTypeComment | String | 30 | Isolation Device Type Comment | Isolation device type description not listed in the options above. | | | true | | |
MajorEventDay | String | 3 | Major Event Day | If 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. | DomYesNo | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
LocationOrAddress | String | 100 | Location or Address | Address or location description for the outage location. | | | true | | |
County | String | 50 | County | County where the outage event occurred. | | | true | | |
District | String | 100 | District | Operating district where the outage event occurred. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_DistributionVegetationCausedUnplannedOutage_20210501 - FeatureClass
Name | PGE_DistributionVegetationCausedUnplannedOutage_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Distribution Vegetation Caused Unplanned Outage 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_DistributionVegetationCausedUnplannedOutage_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
DvmOutageID | String | 50 | VM Outage ID | The unique ID for distribution outage caused by vegetation. Primary key for the Distribution Vegetation Caused Unplanned Outage feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
DoutageID | String | 50 | Distribution Outage ID | Foreign key to the Distribution Unplanned Outage feature class attribute table. | | | true | | |
VmOutageDescription | String | 100 | VM Outage Description | Description or additional information for the outage event. | | | true | | |
InspectionDate | Date | 8 | Inspection Date | Date of inspection. Leave blank if unknown. | | | true | | |
VegetationSpecies | String | 100 | Vegetation Species | Species of vegetation involved in causing the outage. | | | true | | |
TreeHeight | Integer | 4 | Tree 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. | DomTreeHeight | | true | | |
TreeDiameter | Integer | 4 | Tree 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. | DomTreeDiameter | | true | | |
TreeTrunkDistance | Integer | 4 | Tree 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 | | |
PGE_Ignition_20210501 - FeatureClass
Name | PGE_Ignition_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Ignition 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_Ignition_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
IgnitionID | String | 50 | Ignition ID | Unique ID for the ignition event. Primary key for the Ignition feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
SubstationID | String | 50 | Substation ID | Unique ID of the substation supplying the involved circuit. Foreign key to Substation feature class attribute table. | | | true | | |
NearestWeatherStationID | String | 50 | Nearest Weather Station ID | Unique ID of weather station closest to the ignition location. Foreign key to the Weather Station feature class attribute table. | | | true | | |
ToutageID | String | 50 | Transmission Outage ID | A unique ID for the transmission outage event. Foreign key to the Transmission Outage feature class attribute table. | | | true | | |
DoutageID | String | 50 | Distribution Outage ID | A unique ID for the distribution outage event. Foreign key to the Distribution Outage feature class attribute table. | | | true | | |
FireStartDateTime | Date | 8 | Fire Start Date and Time | Date and time ignition started. Leave blank if unknown. | | | true | | |
FireStartYear | Integer | 4 | Fire Start Year | The year that the risk event occurred. Use four digits. | | | true | | |
FireDetectionMethod | String | 30 | Fire Detection Method | The method by which the utility first learned of the ignition event. Possible values: Public, Satellite, Camera, Utility staff, Fire agency, Other – See comment. | DomFireDetectionMethod | | true | | |
FireDetectionMethodComment | String | 30 | Fire Detection Method Comment | Fire detection method description not listed in the options above. | | | true | | |
SuspectedInitiatingCause | String | 30 | Suspected Initiating Cause | The 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. | DomCause | | true | | |
SuspectedInitiatingCauseComment | String | 30 | Suspected Initiating Cause Comment | Suspected initiating event of the ignition cause description not listed in the options above. | | | true | | |
ObjectContact | String | 30 | Object Contact | Description 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. | DomObjectContact | | true | | |
ObjectContactComment | String | 30 | Object Contact Comment | Description of object contact not listed in the options above; or, any additional information about object contact. | | | true | | |
EquipmentFailure | String | 30 | Equipment Failure | Description 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. | DomEquipmentFailure | | true | | |
AssociatedNominalVoltagekV | String | 10 | Associated 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 | | |
AssociatedOperatingVoltagekV | String | 10 | Associated 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 | | |
SubstationName | String | 50 | Substation Name | Name of the substation supplying the involved circuit. | | | true | | |
OtherCompanies | String | 50 | Other Companies | Companies (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 | | |
EquipmentType | String | 30 | Equipment Type | The type of equipment involved in the ignition event. Possible values: Overhead, Pad-mounted, Subsurface. | DomEquipmentType | | true | | |
Determination | String | 30 | Determination | The entity relied upon to make the determination of “SuspectedInitiatingCause” above. Possible values: Utility personnel, Fire Agency, Other – See comment. | DomDetermination | | true | | |
DeterminationComment | String | 50 | Determination Comment | Determination entity description not listed in the options above. | | | true | | |
FacilityContacted | String | 50 | Facility Contacted | The 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. | DomFacilityContacted | | true | | |
FacilityContactedComment | String | 150 | Facility Contacted Comment | Any contacted facility that does not fall in the list above. If multiple facilities from the list above were contacted, list them here. | | | true | | |
ContributingFactor | String | 30 | Contributing Factor | Factors suspected as contributing to the ignition. Possible values: Weather, External Force, Human Error, Unknown, Other – See comment. | DomContributingFactor | | true | | |
ContributingFactorComment | String | 30 | Contributing Factor Comment | Contributing factor description not listed in the options above. | | | true | | |
RFWStatus | String | 3 | Red Flag Warning Status | Was 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. | DomYesNo | | true | | |
RFWIssueDateTime | Date | 8 | Red Flag Warning Issue Date and Time | The 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 | | |
FWWStatus | String | 3 | Fire Weather Watch Status | Was 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. | DomYesNo | | true | | |
FWWIssueDateTime | Date | 8 | Fire Weather Watch Issue Date and Time | The 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 | | |
HWWStatus | String | 3 | High Wind Warning Status | Was 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. | DomYesNo | | true | | |
HWWIssueDateTime | Date | 8 | High Wind Warning Issue Date and Time | The 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 | | |
OriginLandUse | String | 10 | Origin Land Use | Status 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. | DomLandUse | | true | | |
MaterialAtOrigin | String | 30 | Material At Origin | Fuel material for the ignition origin. Possible values: Vegetation, Structure, Other – See comment. | DomMaterialAtOrigin | | true | | |
MaterialAtOriginComment | String | 30 | Material At Origin Comment | Type 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 | | |
FuelBedDescription | String | 100 | Fuel Bed Description | Type 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. | DomFuelBedDescription | | true | | |
FuelBedDescriptionComment | String | 100 | Fuel Bed Description Comment | Fuel bed description not listed in the options above. | | | true | | |
FireSize | String | 30 | Fire Size | Size, 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. | DomFireSize | | true | | |
SuppressedBy | String | 30 | Suppressed By | Entity responsible for suppressing ignition. Possible values: Customer, Fire agency, Self-extinguished, Utility, Unknown. | DomSuppressedBy | | true | | |
SuppressingAgency | String | 30 | Suppressing Agency | If the “SupressedBy” field has the value of “Fire Agency”, enter the fire department name. | | | true | | |
FireInvestigation | String | 30 | Fire Investigation | Whether the fire authority having jurisdiction investigated the ignition and the status of the investigation. Possible values: Yes – Complete, Yes – Pending, No. | DomFireInvestigation | | true | | |
FireAHJ | String | 100 | Fire Authority Having Jurisdiction | If there was an investigation of the ignition by a fire authority having jurisdiction, enter the fire agency name. | | | true | | |
OutageStatus | String | 3 | Outage Status | Was there an outage associated with the event? Possible values: Yes, No. | DomYesNo | | true | | |
IgnitionNotes | String | 100 | Ignition Notes | Additional 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 | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County where the ignition event occurred. | | | true | | |
District | String | 100 | District | Operating district where the ignition occurred. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_TransmissionUnplannedOutage_20210501 - FeatureClass
Name | PGE_TransmissionUnplannedOutage_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Transmission Unplanned Outage 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_TransmissionUnplannedOutage_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
ToutageID | String | 50 | Transmission Outage ID | The unique ID for outage event. Primary key for the Transmission Unplanned Outage feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
SubstationID | String | 50 | Substation ID | Unique 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 | | |
BasicCause | String | 30 | Basic Cause | High-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 comment | DomCause | | true | | |
BasicCauseComment | String | 50 | Basic Cause Comment | Basic 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 | | |
BasicCauseObject | String | 30 | Basic Cause Object | Description 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. | DomObjectContact | | true | | |
BasicCauseObjectComment | String | 50 | Basic Cause Object Comment | Basic cause object description not listed in the options above; or, any additional information about object contact. | | | true | | |
DamagedDevice | String | 30 | Damaged Device | The 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. | DomEquipmentFailure | | true | | |
DamagedDeviceComment | String | 50 | Damaged Device Comment | Damaged device description not listed in the options above; or, any additional information about damaged device. | | | true | | |
ExpulsionFuseOperation | String | 3 | Expulsion Fuse Operation | Did 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. | DomYesNoNA | | true | | |
OutageDescription | String | 100 | Outage Description | Description or additional information for the outage. Not required. | | | true | | |
EventYear | Integer | 4 | Event Year | The year outage started. Use four digits. | | | true | | |
OutageStartDateTime | Date | 8 | Outage Start Date and Time | The date and time outage started. Leave blank if unknown. | | | true | | |
OutageEndDateTime | Date | 8 | Outage End Date and Time | The date and time of full restoration. | | | true | | |
OutageDuration | Single | 4 | Outage Duration | The total time to restore all customers, from the first customer out, in minutes. | | | true | | |
CustomerMinutesInterrupted | Single | 4 | Total Customer-Minutes Interrupted | Total customer-minutes interrupted associated with the outage. Do not more than two decimal places. | | | true | | |
CustomersOutMomentary | Integer | 4 | Customers Out Momentary | Total 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 | | |
CustomersOutSustained | Integer | 4 | Customers Out Sustained | Total 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 | | |
CustomerCount | Integer | 4 | Customer Count | The 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 | | |
OutageInterval | String | 30 | Outage Interval | Indication 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. | DomOutageInterval | | true | | |
OutageIntervalAlternativeDefinition | String | 30 | Outage Interval Alternative Definition | If the utility uses a different definition of “momentary” than specified above (5 minutes or less), specify the alternative definition here. | | | true | | |
AssociatedNominalVoltagekV | Single | 4 | Associated Nominal Voltage (kV) | Voltage (in kilovolts) associated with outage. Do not use more than two decimal places. Enter “-99” if N/A. | | | true | | |
AssociatedOperatingVoltagekV | Single | 4 | Associated Operating Voltage (kV) | Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A. | | | true | | |
OtherCompanies | String | 150 | Other Companies | Companies (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 | | |
OutageClass | String | 30 | Outage Class | The class of circuit involved in the outage. Required value: Transmission | | | true | | |
RecloserSetting | String | 30 | Recloser Setting | If 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. | DomRecloserSetting | | true | | |
IsolationDeviceType | String | 30 | Isolation Device Type | Type of protective device that operated. Possible values: Circuit breaker, Fuse, Lightning arrester, Switch, Transformer, Recloser, Jumper, Other – See comment. | DomIsolationDevice | | true | | |
IsolationDeviceTypeComment | String | 30 | Isolation Device Type Comment | Isolation device type description not listed in the options above. | | | true | | |
MajorEventDay | String | 3 | Major Event Day | If 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. | DomYesNo | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
LocationOrAddress | String | 100 | Location or Address | Address or location description for the outage location. | | | true | | |
County | String | 50 | County | County where the outage event is located. | | | true | | |
District | String | 100 | District | Operating district where the outage event occurred. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point (in decimal degrees). Field-calculate in GIS software. | | | true | | |
PGE_TransmissionVegetationCausedUnplannedOutage_20210501 - FeatureClass
Name | PGE_TransmissionVegetationCausedUnplannedOutage_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Transmission Vegetation Caused Unplanned Outage 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_TransmissionVegetationCausedUnplannedOutage_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
TvmOutageID | String | 50 | Transmission VM Outage ID | The unique ID for an outage caused by vegetation. Primary key for the Transmission VM Outage feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
ToutageID | String | 50 | Transmission Outage ID | Foreign key to the Transmission Outage feature class attribute table. | | | true | | |
VmOutageDescription | String | 100 | VM Outage Description | Description or additional information for the outage event. | | | true | | |
InspectionDate | Date | 8 | Inspection Date | Date of inspection. Leave blank if unknown. | | | true | | |
VegetationSpecies | String | 100 | Vegetation Species | Species of the vegetation involved in causing the outage. | | | true | | |
TreeHeight | Integer | 4 | Tree 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. | DomTreeHeight | | true | | |
TreeDiameter | Integer | 4 | Tree 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. | DomTreeDiameter | | true | | |
TreeTrunkDistance | Integer | 4 | Tree 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 | | |
PGE_WireDownEvent_20210501 - FeatureClass
Name | PGE_WireDownEvent_20210501 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Wire Down Event 20210501 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_WireDownEvent_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
WireDownID | String | 50 | Wire Down ID | Unique ID for the wire down event. Primary key for the Wire Down Event feature class attribute table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (e.g., “UtilityG+E”). | | | true | | |
ToutageID | String | 50 | Transmission Outage ID | A unique ID for the transmission outage event. Foreign key to the Transmission Outage feature class attribute table. | | | true | | |
DoutageID | String | 50 | Distribution Outage ID | A unique ID for the distribution outage event. Foreign key to the Distribution Outage feature class attribute table. | | | true | | |
WireDownDate | Date | 8 | Wire Down Date | The start date of the wire down event. Leave blank if unknown. | | | true | | |
WireDownYear | Integer | 4 | Wire Down Year | The year that the risk event occurred. Use four digits. | | | true | | |
Cause | String | 30 | Cause | High-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 comment | DomCause | | true | | |
CauseComment | String | 30 | Cause Comment | Wire down cause description not listed in the options above. | | | true | | |
ObjectContact | String | 30 | Object Contact | Description 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. | DomObjectContact | | true | | |
EquipmentFailure | String | 30 | Equipment Failure | Description 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. | DomEquipmentFailure | | true | | |
EquipmentFailureComment | String | 30 | Equipment Failure Comment | Equipment failure description not listed in the options above. | | | true | | |
AssociatedNominalVoltagekV | String | 10 | Associated 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 | | |
AssociatedOperatingVoltagekV | String | 10 | Associated 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 | | |
SpanLength | Single | 4 | Span Length (feet) | The length of a single-phase conductor, in feet, as measured between the “FromDevice” and “ToDevice” assets. | | | true | | |
TotalSplices | Integer | 4 | Total Splices | The 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 | | |
MaxSplices | Integer | 4 | Maximum Splices | The maximum number of splices in an individual phase conductor involved in the wire down event. | | | true | | |
MultipleDown | String | 3 | Multiple Down | Was more than one span of conductors impacted by the wire down event? Possible values: Yes, No. | DomYesNo | | true | | |
ConductorMaterial | String | 50 | Conductor Material | Conductor 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. | DomConductorMaterial | | true | | |
ConductorMaterialComment | String | 50 | Conductor Material Comment | Conductor material description not listed in the options above. | | | true | | |
ConductorSize | String | 30 | Conductor Size | Size (e.g. No. 4, 1/0, etc.) of the conductor involved in the incident, in AWG or KCMIL. | | | true | | |
ConductorOD | Single | 4 | Conductor Overall Diameter (inches) | Overall diameter of the conductor, in inches. | | | true | | |
ConductorRating | Single | 4 | Conductor Rating | The nominal ampacity rating of the conductor involved in the wire down event in amperes. | | | true | | |
OutageStatus | String | 3 | Outage Status | Was there an outage associated with the event? Possible values: Yes, No. | DomYesNo | | true | | |
Energized | String | 10 | Energized | Was 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. | DomYesNoUnknownNA | | true | | |
IgnitionStatus | String | 3 | Ignition Status | Was there an ignition associated with the wire down event? Possible values: Yes, No. | DomYesNo | | true | | |
WireDownNotes | String | 100 | Wire Down Notes | Additional information or notes available for the wire down event and not captured in other fields. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The 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. | DomHFTD | | true | | |
County | String | 50 | County | County where the wire down event ocurred. | | | true | | |
District | String | 100 | District | Operating district where the wire down occurred. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point in decimal degrees. Field-calculate in GIS software. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point in decimal degrees. Field-calculate in GIS software. | | | true | | |
PGE_AssetInspectionLog_20210501 - Table
Name | PGE_AssetInspectionLog_20210501 |
AliasName | PGE Asset Inspection Log 20210501 |
HasAttachments | false |
Description | PGE_AssetInspectionLog_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AiLogID | String | 50 | AI Log ID | Unique ID or job ID of an asset inspection activity. Primary key for the Asset Inspection related table. | | | true | | |
VmpLogID | String | 50 | VMP Log ID | Unique 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 | | |
InspectionStartDate | Date | 8 | Inspection Start Date | The 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 | | |
InspectionEndDate | Date | 8 | Inspection End Date | The 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 | | |
PerformedBy | String | 30 | Performed By | Who performed the asset inspection? Possible values: Utility staff, Contractor, Other – See comment. | DomPerformedBy | | true | | |
PerformedByComment | String | 30 | Performed By Comment | Inspector description not listed in the options above. | | | true | | |
InspectionType | String | 30 | Inspection Type | The type of asset inspection performed. Possible values: Patrol, Detailed, Pole loading, Other – See comment. | DomInspectionType | | true | | |
InspectionTypeComment | String | 30 | Inspection Type Comment | Inspection type description not listed in the options above. | | | true | | |
InspectionQA | String | 3 | Inspection QA | Has the inspection been checked for quality assurance? Possible values: Yes, No. | DomYesNo | | true | | |
InspectionComment | String | 100 | Inspection Comment | Additional comments related to the asset management inspection. | | | true | | |
ComplianceFinding | String | 3 | Compliance Finding | Did the asset inspection result in the finding of any non-compliance issues? Possible values: Yes, No. | DomYesNo | | true | | |
InspectionMethod | String | 100 | Inspection Method | The 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. | DomInspectionMethod | | true | | |
InspectionMethodComment | String | 50 | Inspection Method Comment | Inspection 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 | | |
InspectionTechnology | String | 30 | Inspection Technology | The 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. | DomInspectionTechnology | | true | | |
InspectionTechnologyComment | String | 30 | Inspection Technology Comment | Inspection technology not listed in the options above. | | | true | | |
PGE_GridHardeningLog_20210501 - Table
Name | PGE_GridHardeningLog_20210501 |
AliasName | PGE Grid Hardening Log 20210501 |
HasAttachments | false |
Description | PGE_GridHardeningLog_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
GhLogID | String | 50 | GH Log ID | Unique ID or job ID of a grid hardening activity. Primary key for the Grid Hardening Log related table. | | | true | | |
AiLogID | String | 50 | AI Log ID | Unique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection Log related table. | | | true | | |
GhChangeOrder | String | 3 | GH Change Order | Has a change order been requested for this grid hardening initiative since the approval of the utility’s previous WMP? Possible values: Yes, No. | DomYesNo | | true | | |
GhChangeOrderDate | Date | 8 | GH Change Order Date | Date the change order was submitted. Leave blank if unknown. | | | true | | |
GhChangeOrderType | String | 30 | GH Change Order Type | The 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. | DomGhChangeOrderType | | true | | |
GhChangeOrderTypeComment | String | 100 | Gh Change Order Type Comment | Change order type not listed above. | | | true | | |
StartDate | Date | 8 | Date Start | Start 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 | | |
EndDate | Date | 8 | Date End | Completion 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 | | |
LineDeenergized | String | 3 | Line Deenergized | Lines need to be de-energized to perform the work. Possible values: Yes, No. | DomYesNo | | true | | |
PerformedBy | String | 30 | Performed By | Who performed the grid hardening activity? Possible values: Utility staff, Contractor, Other – See comment. | DomPerformedBy | | true | | |
PerformedByComment | String | 30 | Performed By Comment | Entity that performed grid hardening and is not listed in options above. | | | true | | |
PGE_InitiativePhotoLog_20210501 - Table
Name | PGE_InitiativePhotoLog_20210501 |
AliasName | PGE Initiative Photo Log 20210501 |
HasAttachments | false |
Description | PGE_InitiativePhotoLog_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
PhotoID | String | 100 | Photo ID | Name for a photo showing an initiative or inspection findings. A primary key for the Initiative Photo Log related table. | | | true | | |
PhotoBeforeID | String | 100 | Photo Before ID | Name 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 | | |
PhotoAfterID | String | 100 | Photo After ID | Name 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 | | |
VmpID | String | 50 | VMP ID | Unique 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 | | |
VmiID | String | 50 | VMI ID | Unique 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 | | |
AiID | String | 50 | AI ID | Unique 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 | | |
GhID | String | 50 | GH ID | Unique 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 | | |
OiID | String | 50 | OI ID | Unique 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 | | |
FromDeviceID | String | 50 | From Device ID | The 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 | | |
ToDeviceID | String | 50 | To Device ID | The 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 | | |
PGE_OtherInitiativeLog_20210501 - Table
Name | PGE_OtherInitiativeLog_20210501 |
AliasName | PGE Other Initiative Log 20210501 |
HasAttachments | false |
Description | PGE_OtherInitiativeLog_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
OiLogID | String | 50 | OI Log ID | Unique ID or job ID of other initiative activity. Primary key for the Other Initiative Log related table. | | | true | | |
StartDate | Date | 8 | Date Start | The start date of the activity. If exact date is not known, may approximate as first day of the month in which project began. | | | true | | |
EndDate | Date | 8 | Date End | The 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 | | |
OiComment | String | 100 | Other Initiative Comment | Any other information about the activity. | | | true | | |
PGE_PspsEventConductorDamageDetail_20210501 - Table
Name | PGE_PspsEventConductorDamageDetail_20210501 |
AliasName | PGE PSPS Event Conductor Damage Detail 20210501 |
HasAttachments | false |
Description | PGE_PspsEventConductorDamageDetail_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
PspsCdID | String | 50 | PSPS Conductor Damage ID | Primary key for the PSPS Event Conductor Damage Detail related table. | | | true | | |
DamageEventID | String | 50 | Damage Event ID | ID 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 | | |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
FromDeviceID | String | 50 | From Device ID | The upstream support structure asset ID. Foreign key to the related asset point feature class attribute tables. AKA AssetID. | | | true | | |
ToDeviceID | String | 50 | To Device ID | The downstream support structure asset ID. Foreign key to the related asset point feature class attribute tables. AKA AssetID. | | | true | | |
FeederID | String | 50 | Feeder ID | Circuit/feeder ID for the damaged span of line. Foreign key to the related asset line feature class attribute tables. | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation feature class attribute table. | | | true | | |
DamageDateTime | Date | 8 | Date and Time of Damage | Date and time or estimated date and time damage occurred. | | | true | | |
Asset | String | 10 | Asset | Specific type of asset that is damaged. Required value: Conductor | | | true | | |
NominalVoltagekV | String | 10 | 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 | | |
OperatingVoltagekV | String | 10 | 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 | | |
ConductorMaterial | String | 50 | Conductor Material | Conductor 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. | DomConductorMaterial | | true | | |
ConductorMaterialComment | String | 50 | Conductor Material Comment | Conductor material not listed in the options above. | | | true | | |
ConductorType | String | 30 | Conductor Type | Type of conductor. Possible values: Bare, Covered, Other - See comment. | DomConductorType | | true | | |
ConductorTypeComment | String | 50 | Conductor Type Comment | Conductor type not listed above. | | | true | | |
ConductorLength | Single | 4 | Conductor Length (feet) | Conductor length in feet based on GIS data. | | | true | | |
FailedEquipmentDescription | String | 100 | Failed Equipment Description | Equipment that contributed to the conductor damage. Write “Unknown” or “N/A” as appropriate. | | | true | | |
ExternalForceDescription | String | 100 | External Force Description | Force responsible for causing the conductor damage. | | | true | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | true | | |
SubstationType | String | 10 | Substation Type | Type of substation. Possible values: Radial, Loop, Network. | DomSubstationType | | true | | |
Cause | String | 30 | Cause | High-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 comment | DomCause | | true | | |
CauseComment | String | 30 | Cause Comment | Cause category not listed in options above. | | | true | | |
EnergizedOnGround | String | 10 | Energized On Ground | Did the damaged conductor make contact with the ground while energized? Possible values: Yes, No, Unknown. | DomYesNoUnknown | | true | | |
ManufacturerModelID | String | 50 | Manufacturer Model ID | The 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 | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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. | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset would have been expected to have a useful functioning existence prior to damage. If unknown, enter “-99.” | | | true | | |
LikelyArcing | String | 10 | Likely Arcing | Was arcing likely because of the damage? Possible values: Yes, No, Unknown. | DomYesNoUnknown | | true | | |
DamageType | String | 30 | Damage Type | Type of damage sustained. Possible values: Asset damage, Asset failure, Equipment damage, Equipment failure, Veg contact, Object contact. | DomDamageType | | true | | |
DamageDescription | String | 30 | Damage Description | Description 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. | DomDamageDescription | | true | | |
DamageDescriptionComment | String | 30 | Damage Description Comment | Damage category not listed in the options above and/or additional relevant details about damage | | | true | | |
PGE_PspsEventDamagePhotoLog_20210501 - Table
Name | PGE_PspsEventDamagePhotoLog_20210501 |
AliasName | PGE PSPS Event Damage Photo Log 20210501 |
HasAttachments | false |
Description | PGE_PspsEventDamagePhotoLog_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
DamagedAssetPhotoID | String | 100 | Damaged Asset Photo ID | Name 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 | | |
FuelBedPhotoID | String | 100 | Fuel Bed Photo ID | Name 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 | | |
DamageEventID | String | 100 | Damage Event ID | Foreign key to the damage point feature class and damage detail related tables. | | | true | | |
PGE_PspsEventLog_20210501 - Table
Name | PGE_PspsEventLog_20210501 |
AliasName | PGE PSPS Event Log 20210501 |
HasAttachments | false |
Description | PGE_PspsEventLog_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
EventID | String | 50 | Event ID | A unique standardized identification name of the unique event. Primary key enabling connection to PSPS event feature class attribute tables | | | true | | |
EOCActivationDateTime | Date | 8 | EOC Activation Date and Time | Date and time electrical corporation’s emergency operation center (EOC) was activated. | | | true | | |
StartDateTime | Date | 8 | Start Date and Time | Start date and time of the PSPS event. | | | true | | |
AllClearDateTime | Date | 8 | All Clear Date and Time | Date 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 | | |
AllLoadUpDateTime | Date | 8 | All Load Up Date and Time | Date 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 | | |
County | String | 150 | County | County in which asset is located. If the line crosses multiple counties, list all counties separated by commas. | | | true | | |
WindRisk | String | 3 | Wind Risk | Was high wind a driving risk factor in the PSPS decision? Possible values: Yes, No. | DomYesNo | | true | | |
RelativeHumidityRisk | String | 3 | Relative Humidity Risk | Was low relative humidity a driving risk factor in the PSPS decision? Possible values: Yes, No. | DomYesNo | | true | | |
TemperatureRisk | String | 3 | Temperature Risk | Was high temperature a driving risk factor in the PSPS decision? Possible values: Yes, No. | DomYesNo | | true | | |
VegetationRisk | String | 3 | Vegetation Risk | Was a higher probability of vegetation interference a driving risk factor in the PSPS decision? Possible values: Yes, No. | DomYesNo | | true | | |
AssetRisk | String | 3 | Asset Risk | Was a higher probability of asset failure a driving risk factor in the PSPS decision? Possible values: Yes, No. | DomYesNo | | true | | |
DeadFuelRisk | String | 3 | Dead Fuel Risk | Was a high presence of dead fuel a driving risk factor in the PSPS decision? Possible values: Yes, No. | DomYesNo | | true | | |
LiveFuelRisk | String | 3 | Live Fuel Risk | Was a high presence of live fuel a driving risk factor in the PSPS decision? Possible values: Yes, No. | DomYesNo | | true | | |
RedFlagWarningRisk | String | 3 | Red Flag Warning Risk | Was the presence of a Red Flag Warning risk day a driving factor in the PSPS decision? Possible values: Yes, No. | DomYesNo | | true | | |
OtherRisk | String | 3 | Other Risk | Was some other form of risk (not covered by the fields above) a driving risk factor in the PSPS decision? Possible values: Yes, No. | DomYesNo | | true | | |
OtherRiskReason | String | 100 | Other Risk Reason | Brief 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 | | |
PGE_PspsEventOtherAssetDamageDetail_20210501 - Table
Name | PGE_PspsEventOtherAssetDamageDetail_20210501 |
AliasName | PGE PSPS Event Other Asset Damage Detail 20210501 |
HasAttachments | false |
Description | PGE_PspsEventOtherAssetDamageDetail_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
PspsOadID | String | 50 | PSPS Other Asset Damage ID | Primary key for the PSPS Event Other Asset Damage Detail related table. | | | true | | |
DamageEventID | String | 50 | Damage Event ID | ID 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 | | |
AssetID | String | 50 | Asset ID | Unique 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 | | |
FeederID | String | 50 | Feeder ID | Circuit/feeder ID for the damaged span of line. Foreign to the related asset line feature class attribute tables. | | | true | | |
DamageDateTime | Date | 8 | Damage Date and Time | Date and time or estimated date and time damage occurred. | | | true | | |
Asset | String | 30 | Asset | Specific 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. | DomPspsOtherAsset | | true | | |
AssetComment | String | 30 | Asset Comment | Asset not listed in the options above. | | | true | | |
Cause | String | 30 | Cause | High-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 comment | DomCause | | true | | |
CauseComment | String | 30 | Cause Comment | Cause category not listed above. | | | true | | |
AssociatedNominalVoltagekV | String | 10 | Associated 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 | | |
AssociatedOperatingVoltagekV | String | 10 | Associated 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 | | |
ManufacturerModelID | String | 50 | Manufacturer Model ID | The 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 | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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). | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset would have been expected to have a useful functioning existence prior to damage. If unknown, enter “-99.” | | | true | | |
ExemptionStatus | String | 10 | Exemption Status | Is 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. | DomYesNoUnknownNA | | true | | |
LikelyArcing | String | 10 | Likely Arcing | Was arcing likely because of the damage? Possible values: Yes, No, Unknown. | DomYesNoUnknown | | true | | |
DamageType | String | 30 | Damage Type | Type of damage sustained. Possible values: Asset damage, Asset failure, Equipment damage, Equipment failure, Veg contact, Object contact. | DomDamageType | | true | | |
DamageDescription | String | 30 | Damage Description | Description 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. | DomOtherAssetDamageDescription | | true | | |
DamageDescriptionComment | String | 30 | Damage Description Comment | Damage category not listed in the options above and/or additional relevant details about damage. | | | true | | |
PGE_PspsEventSupportStructureDamageDetail_20210501 - Table
Name | PGE_PspsEventSupportStructureDamageDetail_20210501 |
AliasName | PGE PSPS Event Support Structure Damage Detail 20210501 |
HasAttachments | false |
Description | PGE_PspsEventSupportStructureDamageDetail_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
PspsSsdID | String | 50 | PSPS Support Structure ID | Primary key for the PSPS Event Support Structure Damage Detail related table. | | | true | | |
DamageEventID | String | 50 | Damage Event ID | ID 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 | | |
AssetID | String | 50 | Asset ID | Unique 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 | | |
FeederID | String | 50 | Feeder ID | Circuit/feeder ID for the damaged span of line. Foreign key to the related asset line feature class attribute tables. | | | true | | |
DamageDateTime | Date | 8 | Damage Date and Time | Specific 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 | | |
Asset | String | 30 | Asset | Specific 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 | DomPspsAsset | | true | | |
AssetComment | String | 30 | Asset Comment | Asset not listed in the options above. | | | true | | |
Cause | String | 30 | Cause | High-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 comment | DomCause | | true | | |
CauseComment | String | 30 | Cause Comment | Cause category not listed above. | | | true | | |
AssociatedNominalVoltagekV | String | 10 | Associated 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 | | |
AssociateOperatingVoltagekV | String | 10 | Associated 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 | | |
SupportStructureMaterial | String | 30 | Support Structure Material | Material of which support structure is made. Possible values: Wood, Metal, Composite, Wrapped wood, Concrete, Other – See comment. | DomSupportStructureMaterial | | true | | |
MaterialComment | String | 30 | Material Comment | Support structure material not listed in the options above. | | | true | | |
ManufacturerModelID | String | 50 | Manufacturer Model ID | The 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 | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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). | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset would have been expected to have a useful functioning existence prior to damage. If unknown, enter “-99.” | | | true | | |
LikelyArcing | String | 10 | Likely Arcing | Was arcing likely because of the damage? Possible values: Yes, No, Unknown. | DomYesNoUnknown | | true | | |
DamageType | String | 30 | Damage Type | Type of damage sustained. Possible values: Asset damage, Asset failure, Equipment damage, Equipment failure, Veg contact, Object contact. | DomDamageType | | true | | |
DamageDescription | String | 30 | Damage Description | Description of damage. Possible values: Broken pole, Damaged pole, Broken tower, Damaged tower, Broken crossarm, Damaged crossarm, Other – See comment. | DomSupportStructureDamageDescription | | true | | |
DamageDescriptionComment | String | 30 | Damage Description Comment | Damage category not listed in the options above and/or additional relevant details about damage | | | true | | |
PGE_RiskEventAssetLog_20210501 - Table
Name | PGE_RiskEventAssetLog_20210501 |
AliasName | PGE Risk Event Asset Log 20210501 |
HasAttachments | false |
Description | PGE_RiskEventAssetLog_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
ReaID | String | 50 | Risk Event Asset ID | The unique ID for the associated asset. Primary key for the Risk Event Asset Log related table. | | | true | | |
WireDownID | String | 50 | Wire Down ID | Foreign key to the Wire Down Event feature class attribute table. | | | true | | |
FromDeviceID | String | 50 | From Device ID | The 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 | | |
ToDeviceID | String | 50 | To Device ID | The 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 | | |
IgnitionID | String | 50 | Ignition ID | Foreign key to the Ignition feature class attribute table. | | | true | | |
StationID | String | 50 | Station ID | Unique 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 | | |
ToutageID | String | 50 | Transmission Outage ID | Foreign key to the Transmission Unplanned Outage feature class attribute table. | | | true | | |
TvmOutageID | String | 50 | Transmission VM Outage ID | Foreign key to the Transmission VM Unplanned Outage feature class attribute table. | | | true | | |
DoutageID | String | 50 | Distribution Outage ID | Foreign key to the Distribution Unplanned Outage feature class attribute table. | | | true | | |
DvmOutageID | String | 50 | Distribution VM Outage ID | Foreign key to the Distribution Outage feature class attribute table. | | | true | | |
IsolationDeviceID | String | 50 | Isolation Device ID | The 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 | | |
DamagedDeviceID | String | 50 | Damaged Device ID | The 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 | | |
AssetID | String | 50 | Asset ID | Unique 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 | | |
CircuitID | String | 50 | Circuit ID | Unique 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 | | |
SubstationID | String | 50 | Substation ID | Unique 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 | | |
PGE_RiskEventPhotoLog_20210501 - Table
Name | PGE_RiskEventPhotoLog_20210501 |
AliasName | PGE Risk Event Photo Log 20210501 |
HasAttachments | false |
Description | PGE_RiskEventPhotoLog_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
PhotoID | String | 100 | Photo ID | Name 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 | | |
IgnitionID | String | 50 | Ignition ID | Foreign key to the Ignition feature class attribute table. | | | true | | |
WireDownID | String | 50 | Wire Down ID | Foreign key to the Wire Down Event feature class attribute table. | | | true | | |
PGE_TransformerDetail_20210501 - Table
Name | PGE_TransformerDetail_20210501 |
AliasName | PGE Transformer Detail 20210501 |
HasAttachments | false |
Description | PGE_TransformerDetail_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AssetID | String | 50 | Asset ID | Unique 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 | | |
TransformerSiteID | String | 50 | Transformer Site ID | Unique 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 | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation feature class attribute table. | | | true | | |
CircuitID | String | 50 | Circuit ID | ID 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 | | |
TransformerSubtype | String | 100 | TransformerSubtype | Specific 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. | DomTransformerSubtype | | true | | |
AssociatedNominalVoltagekV | Single | 4 | Associated Nominal Voltage (kV) | Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A. | | | true | | |
AssociatedOperatingVoltagekV | Single | 4 | Associated Operating Voltage (kV) | Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A. | | | true | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name 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 | | |
Manufacturer | String | 50 | Manufacturer | Name 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 | | |
ModelNumber | String | 30 | Model Number | Model number of the asset. Enter “Unknown” if this cannot be determined. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Leave blank if unknown. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Leave blank if unknown. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Leave blank if unknown. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | true | | |
EstimatedAge | String | 10 | Estimated Age | The 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. | DomEstimatedAge | | true | | |
UsefulLifespan | Integer | 4 | Useful Lifespan | The number of years an asset is expected to have a useful functioning existence upon initial installation. If unknown, enter “-99.” | | | true | | |
ExemptionStatus | String | 30 | Exemption Status | Does 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. | DomYesNoUnknownNA | | true | | |
TransformerRating | Single | 4 | Transformer Rating (kVAs) | Nominal electrical load capacity in kilovolt amps (kVAs). | | | true | | |
PGE_VegetationInspectionLog_20210501 - Table
Name | PGE_VegetationInspectionLog_20210501 |
AliasName | PGE Vegetation Inspection Log 20210501 |
HasAttachments | false |
Description | PGE_VegetationInspectionLog_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
VmiLogID | String | 50 | VMI Log ID | Unique ID or job ID of a vegetation inspection activity. Primary key for the Vegetation Inspection Log related table. | | | true | | |
VmpLogID | String | 50 | VMP Log ID | Unique 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 | | |
InspectionStartDate | Date | 8 | Inspection Start Date | The 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 | | |
InspectionEndDate | Date | 8 | Inspection End Date | The 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 | | |
InspectionType | String | 100 | Inspection Type | Initiative 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. | DomVmInspectionType | | true | | |
InspectionTypeComment | String | 120 | Inspection Type Comment | Inspection type description not listed in the options above. If multiple activities are related to the project, list them here. | | | true | | |
InspectionQA | String | 3 | Inspection QA | Has the inspection been checked for quality assurance? Possible values: Yes, No. | DomYesNo | | true | | |
CommercialHarvest | String | 10 | Commercial Harvest | Does the inspection involve commercial harvest? Possible values: Yes, No, Unknown. | DomYesNoUnknown | | true | | |
TreeTrimCount | Integer | 4 | Tree Trim Count | The 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 | | |
InspectionComment | String | 100 | Inspection Comment | Additional comments regarding the vegetation inspection project. | | | true | | |
InspectionMethod | String | 100 | Inspection Method | The 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. | DomInspectionMethod | | true | | |
InspectionMethodComment | String | 50 | Inspection Method Comment | Inspection method description not listed in the options above. | | | true | | |
InspectionTechnology | String | 30 | Inspection Technology | The 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. | DomInspectionTechnology | | true | | |
InspectionTechnologyComment | String | 30 | Inspection Technology Comment | Inspection technology description not listed in the options above. | | | true | | |
PGE_VegetationManagementProjectLog_20210501 - Table
Name | PGE_VegetationManagementProjectLog_20210501 |
AliasName | PGE Vegetation Management Project Log 20210501 |
HasAttachments | false |
Description | PGE_VegetationManagementProjectLog_20210501 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
VmpLogID | String | 50 | VMP Log ID | Unique ID or job ID of an initiative. Primary key for Vegetation Management Project Log related table. | | | true | | |
DescriptionOfWork | String | 100 | Description of Work | Additional description of the vegetation management work (not required). | | | true | | |
StartDate | Date | 8 | Start Date | The 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 | | |
EndDate | Date | 8 | End Date | The 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 | | |
CoastalRedwoodExemption | String | 3 | Coastal Redwood Exemption | Coastal redwood exception to clearance being applied. Possible values: Yes, No. | DomYesNo | | true | | |
EncroachPermit | String | 3 | Encroach Permit | Is an encroachment permit required for the vegetation management project? Possible values: Yes, No. | DomYesNo | | true | | |
EnvPermit | String | 3 | Environmental Permit | Is special environmental permitting needed for the vegetation management project? Possible values: Yes, No. | DomYesNo | | true | | |
EnvPermitProject | String | 100 | Environmental Permit Project | Specific activity (e.g., timber harvest under an exemption) for which a permit was obtained. | | | true | | |
CALFIREHdNumber | String | 35 | CAL FIRE Harvest Document Number | If 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 | | |
OtherEnvPermitDocumentation | String | 50 | Other Environmental Permit Documentation | For 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 | | |
CommercialHarvest | String | 10 | Commercial Harvest | Does the initiative involve commercial harvest? Possible values: Yes, No, Unknown. | DomYesNoUnknown | | true | | |
SlashManagement | String | 20 | Slash Management | How is brush or slash generated by the vegetation management project being managed or treated? Possible values: None, Lopping, Chipping, Removal, Other – See comment. | DomSlashManagement | | true | | |
SlashManagementComments | String | 30 | Slash Management Comments | Brush/slash management method not listed above. | | | true | | |
FireResponsibility | String | 50 | Fire Responsibility | The 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/. | DomFireResponsibility | | true | | |
CaltransProp | String | 3 | Caltrans Property | Is the vegetation management project located on Caltrans property? Possible values: Yes, No. | DomYesNo | | true | | |
TreeTrimCountPlanned | Integer | 4 | Tree Trim Count Planned | Number of trees planned for trimming in the project. Enter “0” if tree trimming is not part of the vegetation project. | | | true | | |
TreeTrimAcreagePlanned | Single | 4 | Tree Trim Acreage Planned | Acreage 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 | | |
TreeRemovalCountPlanned | Integer | 4 | Tree Removal Count Planned | Number of trees planned for removal in the project. Enter “0” if tree removal is not part of the vegetation project. | | | true | | |
TreeRemovalAcreagePlanned | Single | 4 | Tree Removal Acreage Planned | Acreage 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 | | |
TreeTrimCountActl | Integer | 4 | Tree Trim Count Actual | Number 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 | | |
TreeTrimAcreageActl | Single | 4 | Tree Trim Acreage Actual | Acreage 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 | | |
TreeRemovalCountActl | Integer | 4 | Tree Removal Count Actual | Number 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 | | |
TreeRemovalAcreageActl | Single | 4 | Tree Removal Acreage Actual | Acreage 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 | | |
VegetationTreatmentType | String | 50 | Vegetation Treatment Type | The 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. | DomVegTreatmentType | | true | | |
VegetationTreatmentTypeComment | String | 50 | Vegetation Treatment Type Comment | Treatment type not listed in options above—or multiple treatment types listed in options above. If multiple, list all separated by commas. | | | true | | |
WoodDestination | String | 20 | Wood Destination | Record 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. | DomWoodDestination | | true | | |
WoodDestinationComment | String | 60 | Wood Destination Comment | Wood destination not listed above; or, if multiple destinations apply, list them here. | | | true | | |
DomAssetClass - Domain
DomainName | DomAssetClass |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Transmission | Transmission |
Distribution | Distribution |
DomAssetType - Domain
DomainName | DomAssetType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Camera | Camera |
Customer meter | Customer meter |
Fuse | Fuse |
Lightning arrester | Lightning arrester |
Line connection device | Line connection device |
Substation | Substation |
Support structure | Support structure |
Switchgear | Switchgear |
Transformer | Transformer |
Weather Station | Weather Station |
DomBackupType - Domain
DomainName | DomBackupType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Storage battery | Storage battery |
Diesel generator | Diesel generator |
Gas generator | Gas generator |
Combined/hybrid | Combined/hybrid |
Other - See comment | Other - See comment |
DomCause - Domain
DomainName | DomCause |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Contamination | Contamination |
Epuipment failure | Epuipment failure |
Object contact | Object contact |
Lightning | Lightning |
Normal operation | Normal operation |
Utility work | Utility work |
Vandalism/Theft | Vandalism/Theft |
Wire-to-wire contact | Wire-to-wire contact |
Unknown | Unknown |
Other - See comment | Other - See comment |
DomCircuitType - Domain
DomainName | DomCircuitType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Transmission | Transmission |
Primary distribution | Primary distribution |
Secondary distribution | Secondary distribution |
Unknown | Unknown |
DomConductorMaterial - Domain
DomainName | DomConductorMaterial |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
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 comment | Other - See comment |
DomConductorType - Domain
DomainName | DomConductorType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Bare | Bare |
Covered | Covered |
Other - See comment | Other - See comment |
DomConductorTypeSecondary - Domain
DomainName | DomConductorTypeSecondary |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Open wire | Open wire |
Duplex | Duplex |
Triplex | Triplex |
Quadruplex | Quadruplex |
Other - See comment | Other - See comment |
DomConnectionDeviceSubtype - Domain
DomainName | DomConnectionDeviceSubtype |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Automatic splice | Automatic splice |
Crimp splice | Crimp splice |
Explosive sleeve splice | Explosive sleeve splice |
3-bolt | 3-bolt |
Parallel groove | Parallel groove |
Unknown | Unknown |
Other - See comment | Other - See comment |
DomConnectionDeviceType - Domain
DomainName | DomConnectionDeviceType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Splice | Splice |
Connector | Connector |
Clamp | Clamp |
Unknown | Unknown |
Other - See comment | Other - See comment |
DomConnectionOhUg - Domain
DomainName | DomConnectionOhUg |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
All Overhead | All Overhead |
All Underground | All Underground |
Overhead to underground | Overhead to underground |
Underground to overhead | Underground to overhead |
Unknown | Unknown |
DomConnectionType - Domain
DomainName | DomConnectionType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Corporation to private | Corporation to private |
Corporation to corporation | Corporation to corporation |
DomConstructionGrade - Domain
DomainName | DomConstructionGrade |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Grade A | Grade A |
Grade B | Grade B |
Grade C | Grade C |
DomContributingFactor - Domain
DomainName | DomContributingFactor |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Weather | Weather |
External force | External force |
Human error | Human error |
Unknown | Unknown |
Other - See comment | Other - See comment |
DomDamageDescription - Domain
DomainName | DomDamageDescription |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Broken conductor | Broken conductor |
Damaged conductor | Damaged conductor |
Kite in line | Kite in line |
Pine needles on line | Pine needles on line |
Tree bark on line | Tree bark on line |
Tree branch on line | Tree branch on line |
Tree leaning into line | Tree leaning into line |
Tree leaning toward line | Tree leaning toward line |
Wire-to-wire contact | Wire-to-wire contact |
Other - See comment | Other - See comment |
DomDamageType - Domain
DomainName | DomDamageType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Asset damage | Asset damage |
Asset failure | Asset failure |
Equipment damage | Equipment damage |
Equipment failure | Equipment failure |
Vegetation contact | Vegetation contact |
Object contact | Object contact |
DomDetermination - Domain
DomainName | DomDetermination |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Utility personnel | Utility personnel |
Fire agency | Fire agency |
Other - See comment | Other - See comment |
DomEquipmentFailure - Domain
DomainName | DomEquipmentFailure |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Anchor/guy | Anchor/guy |
Capacitor bank | Capacitor bank |
Conductor | Conductor |
Connector device | Connector device |
Crossarm | Crossarm |
Fuse | Fuse |
Insulator and bushing | Insulator and bushing |
Lightning arrester | Lightning arrester |
Pole | Pole |
Recloser | Recloser |
Relay | Relay |
Sectionalizer | Sectionalizer |
Splice | Splice |
Switch | Switch |
Tap | Tap |
Tie wire | Tie wire |
Transformer | Transformer |
Voltage regulator/booster | Voltage regulator/booster |
Unknown | Unknown |
N/A | N/A |
Other - See comment | Other - See comment |
DomEquipmentType - Domain
DomainName | DomEquipmentType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Overhead | Overhead |
Pad-mounted | Pad-mounted |
Subsurface | Subsurface |
DomEstimatedAge - Domain
DomainName | DomEstimatedAge |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
0-9 | 0-9 |
10-19 | 10-19 |
20-29 | 20-29 |
30-39 | 30-39 |
40-49 | 40-49 |
50-59 | 50-59 |
60-69 | 60-69 |
70-79 | 70-79 |
80-89 | 80-89 |
90-99 | 90-99 |
>100 | >100 |
Unknown | Unknown |
N/A | N/A |
DomFacilityCategory - Domain
DomainName | DomFacilityCategory |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Chemical | Chemical |
Communications | Communications |
Educational | Educational |
Emergency services | Emergency services |
Energy | Energy |
Government facilities | Government facilities |
Healthcare and public health | Healthcare and public health |
Public safety answering points | Public safety answering points |
Transportation | Transportation |
Water and wastewater systems | Water and wastewater systems |
Other - See comment | Other - See comment |
DomFacilityContacted - Domain
DomainName | DomFacilityContacted |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Bushing mounted cutout | Bushing mounted cutout |
Capacitor bank | Capacitor bank |
Communications line | Communications line |
Conductor - Primary | Conductor - Primary |
Conductor - Secondary | Conductor - Secondary |
Conductor - Transmission | Conductor - Transmission |
Crossarm | Crossarm |
Fuse | Fuse |
Guy/span wire | Guy/span wire |
Insulator | Insulator |
Jumper | Jumper |
Support structure | Support structure |
Pothead | Pothead |
Recloser | Recloser |
Riser | Riser |
Service connector | Service connector |
Service drop | Service drop |
Splice/clamp/connector | Splice/clamp/connector |
Switch | Switch |
Tie wire | Tie wire |
Transformer | Transformer |
Voltage regulator | Voltage regulator |
Other - See comment | Other - See comment |
DomFireDetectionMethod - Domain
DomainName | DomFireDetectionMethod |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Public | Public |
Satellite | Satellite |
Camera | Camera |
Utility staff | Utility staff |
Fire agency | Fire agency |
Other - See comment | Other - See comment |
DomFireInvestigation - Domain
DomainName | DomFireInvestigation |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Yes - Complete | Yes - Complete |
Yes - Pending | Yes - Pending |
No | No |
DomFireResponsibility - Domain
DomainName | DomFireResponsibility |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
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
DomainName | DomFireSize |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Structure-only | Structure-only |
<3 meters of linear travel | <3 meters of linear travel |
<0.25 | <0.25 |
0.26-9.99 | 0.26-9.99 |
10-99 | 10-99 |
100-299 | 100-299 |
300-999 | 300-999 |
1,000-4,999 | 1,000-4,999 |
>5,000 | >5,000 |
Unknown | Unknown |
DomFuelBedDescription - Domain
DomainName | DomFuelBedDescription |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Fire-resistive fuel bed | Fire-resistive fuel bed |
Grass fuel model | Grass fuel model |
Brush fuel model | Brush fuel model |
Timber fuel model | Timber fuel model |
Other - See comment | Other - See comment |
DomFuseType - Domain
DomainName | DomFuseType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Bridged | Bridged |
Current limiting | Current limiting |
Expulsion | Expulsion |
Fused elbow | Fused elbow |
Unknown | Unknown |
Other - See comment | Other - See comment |
DomGhChangeOrderType - Domain
DomainName | DomGhChangeOrderType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Increase in scale | Increase in scale |
Decrease in scale | Decrease in scale |
Change in prioritization | Change in prioritization |
Change in deployment timing | Change in deployment timing |
Change in work being done | Change in work being done |
Other change - See comment | Other change - See comment |
DomHFTD - Domain
DomainName | DomHFTD |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Tier 3 | Tier 3 |
Tier 2 | Tier 2 |
Non-HFTD | Non-HFTD |
DomInitiativeCategory1 - Domain
DomainName | DomInitiativeCategory1 |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Risk mapping and simulation | Risk mapping and simulation |
Situational awareness and forecasting | Situational awareness and forecasting |
Grid design and system hardening | Grid design and system hardening |
Asset management and inspections | Asset management and inspections |
Vegetation management and inspections | Vegetation management and inspections |
DomInitiativeCategory2 - Domain
DomainName | DomInitiativeCategory2 |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Risk mapping and simulation | Risk mapping and simulation |
Data governance | Data governance |
Resource allocation methodology | Resource allocation methodology |
Emergency planning and preparedness | Emergency planning and preparedness |
Stakeholder coopiration and community engagement | Stakeholder coopiration and community engagement |
DomInspectionMethod - Domain
DomainName | DomInspectionMethod |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Ground inspection | Ground inspection |
Aerial - Drone | Aerial - Drone |
Aerial - Helicopter | Aerial - Helicopter |
Remote sensing - Imagery | Remote sensing - Imagery |
Remote sensing - LiDAR | Remote sensing - LiDAR |
Other - See comment | Other - See comment |
DomInspectionTechnology - Domain
DomainName | DomInspectionTechnology |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Collector for ArcGIS | Collector for ArcGIS |
Survey123 for ArcGIS | Survey123 for ArcGIS |
Workforce for ArcGIS | Workforce for ArcGIS |
ArcGIS QuickCapture | ArcGIS QuickCapture |
Other - See comment | Other - See comment |
None | None |
DomInspectionType - Domain
DomainName | DomInspectionType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Patrol | Patrol |
Detailed | Detailed |
Pole loading | Pole loading |
Other - See comment | Other - See comment |
DomIsolationDevice - Domain
DomainName | DomIsolationDevice |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Circuit breaker | Circuit breaker |
Fuse | Fuse |
Lightning arrester | Lightning arrester |
Switch | Switch |
Transformer | Transformer |
Recloser | Recloser |
Jumper | Jumper |
Other - See comment | Other - See comment |
DomLandUse - Domain
DomainName | DomLandUse |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Rural | Rural |
Urban | Urban |
DomLineClass - Domain
DomainName | DomLineClass |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Transmission | Transmission |
Sub-transmission | Sub-transmission |
Primary distribution | Primary distribution |
Secondary distribution | Secondary distribution |
DomMaterialAtOrigin - Domain
DomainName | DomMaterialAtOrigin |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Vegetation | Vegetation |
Structure | Structure |
Other - See comment | Other - See comment |
DomObjectContact - Domain
DomainName | DomObjectContact |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Vegetation contact | Vegetation contact |
Animal contact | Animal contact |
Balloon contact | Balloon contact |
Vehicle contact - Car pole | Vehicle contact - Car pole |
Vehicle contact - Aircraft | Vehicle contact - Aircraft |
3rd party contact | 3rd party contact |
Unknown | Unknown |
Other - See commen | Other - See commen |
N/A | N/A |
DomOhUg - Domain
DomainName | DomOhUg |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Overhead | Overhead |
Underground | Underground |
Unknown | Unknown |
DomOtherAssetDamageDescription - Domain
DomainName | DomOtherAssetDamageDescription |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Broken down guy | Broken down guy |
Broken hand tie | Broken hand tie |
Broken neutral | Broken neutral |
Broken service neutral | Broken service neutral |
Broken guy wire | Broken guy wire |
Broken tie wire | Broken tie wire |
Broken tree branch near line | Broken tree branch near line |
Broken pin | Broken pin |
Broken insulator | Broken insulator |
Damaged crossarm | Damaged crossarm |
Guy and anchor damage | Guy and anchor damage |
Tree branch on transformer | Tree branch on transformer |
Other - See comment | Other - See comment |
DomOutageInterval - Domain
DomainName | DomOutageInterval |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Momentary | Momentary |
Sustained | Sustained |
DomPerformedBy - Domain
DomainName | DomPerformedBy |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Utility staff | Utility staff |
Contractor | Contractor |
Other - See comment | Other - See comment |
DomPspsAsset - Domain
DomainName | DomPspsAsset |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Pole | Pole |
Tower | Tower |
Crossarm | Crossarm |
Secondary arms | Secondary arms |
Other - See comment | Other - See comment |
DomPspsIsolationDevice - Domain
DomainName | DomPspsIsolationDevice |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Circuit breaker | Circuit breaker |
Fuse | Fuse |
Switch | Switch |
Other - See comment | Other - See comment |
DomPspsOtherAsset - Domain
DomainName | DomPspsOtherAsset |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Down guy | Down guy |
Neutral | Neutral |
Service neutral | Service neutral |
Span guy | Span guy |
Tie wire | Tie wire |
Wood pin | Wood pin |
Anchor | Anchor |
Other - See comment | Other - See comment |
DomRecloserSetting - Domain
DomainName | DomRecloserSetting |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Enabled | Enabled |
Disabled | Disabled |
N/A | N/A |
DomSlashManagement - Domain
DomainName | DomSlashManagement |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
None | None |
Lopping | Lopping |
Chipping | Chipping |
Removal | Removal |
Other - See comment | Other - See comment |
DomSpeciesGrowthRate - Domain
DomainName | DomSpeciesGrowthRate |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Slow growing | Slow growing |
Moderately growing | Moderately growing |
Fast growing | Fast growing |
DomStatus - Domain
DomainName | DomStatus |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Planned | Planned |
In-progress | In-progress |
Complete | Complete |
DomSubareaType - Domain
DomainName | DomSubareaType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Operational | Operational |
Construction | Construction |
Weather | Weather |
Organizational | Organizational |
Other - See comment | Other - See comment |
DomSubstationType - Domain
DomainName | DomSubstationType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Network | Network |
Loop | Loop |
Radial | Radial |
DomSupportStructureDamageDescription - Domain
DomainName | DomSupportStructureDamageDescription |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Broken pole | Broken pole |
Damaged pole | Damaged pole |
Broken tower | Broken tower |
Damaged tower | Damaged tower |
Broken crossarm | Broken crossarm |
Damaged crossarm | Damaged crossarm |
Other - See comment | Other - See comment |
DomSupportStructureMaterial - Domain
DomainName | DomSupportStructureMaterial |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Wood | Wood |
Metal | Metal |
Composite | Composite |
Wrapped wood | Wrapped wood |
Concrete | Concrete |
Other - See comment | Other - See comment |
DomSupportStructureType - Domain
DomainName | DomSupportStructureType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Pole | Pole |
Tower | Tower |
Other - See comment | Other - See comment |
DomSuppressedBy - Domain
DomainName | DomSuppressedBy |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Customer | Customer |
Fire agency | Fire agency |
Self-extinguished | Self-extinguished |
Utility | Utility |
Unknown | Unknown |
DomTransformerSubtype - Domain
DomainName | DomTransformerSubtype |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Single phase pad-mounted | Single phase pad-mounted |
Single phase subsurface | Single phase subsurface |
Single phase overhead | Single phase overhead |
Two phase pad-mounted | Two phase pad-mounted |
Two phase subsurface | Two phase subsurface |
Two phase overhead | Two phase overhead |
Three phase pad-mounted | Three phase pad-mounted |
Three phase subsurface | Three phase subsurface |
Three phase overhead | Three phase overhead |
DomTreeDiameter - Domain
DomainName | DomTreeDiameter |
FieldType | Integer |
Domain Type | Range |
Minimum Value | Maximum Value |
-99 | 180 |
DomTreeHeight - Domain
DomainName | DomTreeHeight |
FieldType | Integer |
Domain Type | Range |
Minimum Value | Maximum Value |
-99 | -99 |
DomVegTreatmentType - Domain
DomainName | DomVegTreatmentType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Radial clearance - Standard | Radial clearance - Standard |
Radial clearance - Enhanced | Radial clearance - Enhanced |
Overhang clearing | Overhang clearing |
Tree removal - Hazard tree | Tree removal - Hazard tree |
Tree removal - Tree mortality | Tree removal - Tree mortality |
Tree trimming | Tree trimming |
Pole brushing | Pole brushing |
Fire break creation | Fire break creation |
Brush clearance | Brush clearance |
Other or multiple treatment types - See comment | Other or multiple treatment types - See comment |
DomVmInspectionType - Domain
DomainName | DomVmInspectionType |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Asessing trees with the potential to strike | Asessing trees with the potential to strike |
Clearances - required | Clearances - required |
Clearances - beyond requirements | Clearances - beyond requirements |
Hazard trees | Hazard trees |
Tree mortality | Tree mortality |
Other - See comment | Other - See comment |
DomWoodDestination - Domain
DomainName | DomWoodDestination |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Sawmill | Sawmill |
Firewood | Firewood |
Biomass Facility | Biomass Facility |
Left whole on-site | Left whole on-site |
Left chipped on-site | Left chipped on-site |
Burned on-site | Burned on-site |
Other - See comment | Other - See comment |
DomYesNo - Domain
DomainName | DomYesNo |
FieldType | String |
Domain Type | CodedValue |
DomYesNoNA - Domain
DomainName | DomYesNoNA |
FieldType | String |
Domain Type | CodedValue |
DomYesNoUnknown - Domain
DomainName | DomYesNoUnknown |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Yes | Yes |
No | No |
Unknown | Unknown |
DomYesNoUnknownNA - Domain
DomainName | DomYesNoUnknownNA |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Yes | Yes |
No | No |
Unknown | Unknown |
N/A | N/A |