Geodatabase Documentation
Date: Friday, August 21, 2020
Time: 1:23:12 PM
Summary Information and Links
6 Feature Datasets and 38 Feature Classes
No Topology Datasets
No Geometric Networks
No Rasters
15 Tables (Object Classes)
No Relationship Classes
70 Domains
Feature Datasets and Child Classes
PGE_AssetLine - Feature Dataset
PGE_PrimaryDistributionLine_20200909 - Simple
PGE_SecondaryDistributionLine_20200909 - Simple
PGE_TransmissionLine_20200909 - Simple
PGE_AssetPoint - Feature Dataset
PGE_Camera_20200909 - Simple
PGE_ConnectionDevice_20200909 - Simple
PGE_CustomerMeter_20200909 - Simple
PGE_Fuse_20200909 - Simple
PGE_LightingArrestor_20200909 - Simple
PGE_Substation_20200909 - Simple
PGE_SupportStructure_20200909 - Simple
PGE_Switchgear_20200909 - Simple
PGE_Transformer_20200909 - Simple
PGE_WeatherStation_20200909 - Simple
PGE_Initiative - Feature Dataset
PGE_AssetInspectionLine_20200909 - Simple
PGE_AssetInspectionPoint_20200909 - Simple
PGE_AssetInspectionPolygon_20200909 - Simple
PGE_GridHardeningLine_20200909 - Simple
PGE_GridHardeningPoint_20200909 - Simple
PGE_VegetationManagementInspectionLine_20200909 - Simple
PGE_VegetationManagementInspectionPoint_20200909 - Simple
PGE_VegetationManagementInspectionPolygon_20200909 - Simple
PGE_VegetationManagementProjectLine_20200909 - Simple
PGE_VegetationManagementProjectPoint_20200909 - Simple
PGE_VegetationManagementProjectPolygon_20200909 - Simple
PGE_OtherRequiredData - Feature Dataset
PGE_AdministrativeArea_20200909 - Simple
PGE_CriticalFacility_20200909 - Simple
PGE_OtherPowerLineConnectionLocation_20200909 - Simple
PGE_RedFlagWarningDayPolygon_20200909 - Simple
PGE_PspsEvent - Feature Dataset
PGE_PspsEventCustomerMeterPoint_20200909 - Simple
PGE_PspsEventDamagePoint_20200909 - Simple
PGE_PspsEventLine_20200909 - Simple
PGE_PspsEventPolygon_20200909 - Simple
PGE_RiskEvent - Feature Dataset
PGE_DistributionOutage_20200909 - Simple
PGE_DistributionVmOutage_20200909 - Simple
PGE_Ignition_20200909 - Simple
PGE_TransmissionOutage_20200909 - Simple
PGE_TransmissionVmOutage_20200909 - Simple
PGE_WireDown_20200909 - Simple
Rasters
Workspace-Level Tables and Feature Classes
PGE_AssetInspectionLog_20200909 - Table
PGE_GridHardeningLog_20200909 - Table
PGE_InitiativeAssetLog_20200909 - Table
PGE_InitiativePhotoLog_20200909 - Table
PGE_PspsDamagePhotoLog_20200909 - Table
PGE_PspsEventConductorDamageDetail_20200909 - Table
PGE_PspsEventLog_20200909 - Table
PGE_PspsEventOtherAssetDamageDetail_20200909 - Table
PGE_PspsEventSupportStructureDamageDetail_20200909 - Table
PGE_RiskEventAssetLog_20200909 - Table
PGE_RiskEventPhotoLog_20200909 - Table
PGE_SupportStructureCrossarmDetail_20200909 - Table
PGE_TransformerDetail_20200909 - Table
PGE_VegetationManagementInspectionLog_20200909 - Table
PGE_VegetationManagementProjectLog_20200909 - Table
Relationship Classes
Domains
AssetClass
BackupType
Balance
Brace Type
BraceType
CircuitType
ConductorMaterial
ConductorType
ConductorTypeSecondary
ConnectionDeviceSubtype
ConnectionDeviceType
ConnectionOHUG
ConnectionType
ConstructionGrade
ContributingFactor
CrossarmConfiguration
CrossarmMaterial
CrossarmOrientation
DamageDescription
DamageType
Determination
Equiment Failure
EquipmentType
EstimatedAge
EventCause
ExemptionStatus
FacilityCategory
FacilityContacted
FireDetectionMethod
FireInvestigation
FireSize
FuelBedDescription
FuseAssetType
GhChangeOrderType
GhStatus
HFTD
InitiativeActivity
InspectionMethod
InspectionTechnology
InspectionType
IsolationDevice
IsolationDeviceType
LandDesignation
MaterialAtOrigin
ObjectContact
OhUg
OriginLandUse
OtherAssetDamageDescription
OutageInterval
PerformedBy
ProjectCategory
PspsAsset
PspsOtherAsset
RecloserSetting
SpeciesGrowthRate
SubareaType
SubstationType
SupportStructureDamageDescription
SupportStructureMaterial
SupportStructureType
SuppressedBy
SuspectedCause
TransformerSubtype
VegetationTreatmentType
VmInspectionType
VmiStatus
VmpStatus
YesNo
YesNoNA
YesNoUnknown
PGE_AssetLine - FeatureDataset
PGE_PrimaryDistributionLine_20200909 - FeatureClass
Name | PGE_PrimaryDistributionLine_20200909 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Primary Distribution Line 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_PrimaryDistributionLine_20200909 |
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. Primary key enabling connection to the “Primary Distribution Lines Detail” table. | | | true | | |
UtilityID | String | 30 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
LineClass | String | 30 | Line Class | Classification of line asset. Required value: Primary distribution | | | true | | |
CircuitName | String | 255 | Circuit Name | Name of circuit associated with asset. | | | 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 | 10 | Conductor Type | Type of conductor. Possible values: Bare, Covered, Unknown | ConductorType | | true | | |
AssetOHUG | String | 30 | Asset OH or UG | Is the asset overhead or underground? Possible values: Overhead, Underground, Unknown | OhUg | | 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 | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation table. | | | 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), Copper (Cu), Other – See comment. | ConductorMaterial | | 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 | | |
ConductorCodeName | String | 30 | Conductor Code Name | Codename of the conductor. For example, “Lapwing,” “Sparrow,” etc. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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 | YesNoUnknown | | true | | |
PGE_SecondaryDistributionLine_20200909 - FeatureClass
Name | PGE_SecondaryDistributionLine_20200909 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Secondary Distribution Line 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_SecondaryDistributionLine_20200909 |
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. Primary key enabling connection to the “Secondary Distribution Lines Detail” related table. 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 (“UtilityG+E,” etc.). | | | true | | |
LineClass | String | 30 | Line Class | Classification of line asset. Required value: Secondary distribution | | | 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. | | | 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, Triplex, Other – See comment. | ConductorTypeSecondary | | 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 | OhUg | | 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 | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation table. | | | 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), Copper (Cu), Other – See comment. | ConductorMaterial | | 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 | | |
ConductorCodeName | String | 30 | Conductor Code Name | Codename of the conductor. For example, “Lapwing,” “Sparrow,” etc. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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 | YesNoUnknown | | true | | |
PGE_TransmissionLine_20200909 - FeatureClass
Name | PGE_TransmissionLine_20200909 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Transmission Line 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_TransmissionLine_20200909 |
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. Primary key enabling connection to the “Transmission Line Detail” table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
LineClass | String | 30 | Line Class | Classification of line asset. Required value: Transmission | | | true | | |
CircuitName | String | 255 | Circuit Name | Name of circuit associated with asset. | | | 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, Unknown | ConductorType | | true | | |
AssetOHUG | String | 30 | Asset OH or UG | Is the asset overhead or underground? Possible values: Overhead, Underground, Unknown | OhUg | | 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 | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation table. | | | 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), Copper (Cu), Other – See comment. | ConductorMaterial | | true | | |
ConductorMaterialComment | String | 50 | Conductor Material Comment | Conductor material not listed in the options above. | | | true | | |
ConductorSize | String | 30 | Conductor Material Comment | 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 | | |
ConductorCodeName | String | 30 | Conductor Code Name | Codename of the conductor. For example, “Lapwing,” “Sparrow,” etc. | | | 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 | | |
Terminal_s_ | String | 50 | Terminal(s) | Substation name of other terminals. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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 | YesNoUnknown | | true | | |
PGE_AssetPoint - FeatureDataset
Description | PGE_AssetPoint |
PGE_Camera_20200909 - FeatureClass
Name | PGE_Camera_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Camera 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_Camera_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AssetType | String | 10 | Asset Type | Type of point asset. Required value: Camera | | | true | | |
MakeandManufacturer | String | 50 | Make and Manufacturer | What is the make and manufacturer of the asset? 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. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
County | String | 60 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationYear | Integer | 4 | Installation Year | Year of asset installation. Use four digits. Enter “-99” if unknown. | | | 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 | | |
CameraHeight | Single | 4 | Camera Height (feet) | Height of camera (in feet) above the ground below it. | | | true | | |
CameraURL | String | 255 | Camera URL | Website address for camera video feed (if publicly available). | | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). | | | true | | |
PGE_ConnectionDevice_20200909 - FeatureClass
Name | PGE_ConnectionDevice_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Connection Device 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_ConnectionDevice_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AssetType | String | 50 | Asset Type | Type of point asset. Required value: Line connection device | | | true | | |
AssetOHUG | String | 30 | Asset OH or UG | Is the asset overhead or underground? Possible values: Overhead, Underground, Unknown | OhUg | | true | | |
ConnectionDeviceType | String | 30 | Connection Device Type | What type of connection device is the asset? Possible values: Splice, Connector, Clamp, Other – See comment, Unknown | ConnectionDeviceType | | 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. | ConnectionDeviceSubtype | | true | | |
ConnectionDeviceSubtypeComment | String | 30 | Connection Device Subtype Comment | Connection device subtype not listed in the options above. | | | 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 | | |
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 table. | | | true | | |
ToStructureID | String | 50 | To 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 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 tables. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name of circuit associated with asset. | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation table. | | | true | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | true | | |
MakeandManufacturer | String | 50 | Make and Manufacturer | What is the make and manufacturer of the asset? 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. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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 | | |
ExemptionStatus | String | 10 | Exemption Status | Is the asset exempt per California Public Resources Code (PRC) 4292? PRC 4292 requires clearance around support structures on which certain equipment is mounted in certain areas. Possible values: Yes, No, Unknown, N/A | ExemptionStatus | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). | | | true | | |
PGE_CustomerMeter_20200909 - FeatureClass
Name | PGE_CustomerMeter_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Customer Meter 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_CustomerMeter_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AssetType | String | 30 | Asset Type | Type of point asset. Required value: Customer meter | | | 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 tables. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name of circuit associated with asset. | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign key to the Substation table. | | | true | | |
SubstationName | String | 30 | Substation Name | Name of substation associated with asset. | | | true | | |
MakeandManufacturer | String | 50 | Make and Manufacturer | What is the make and manufacturer of the asset? 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. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). | | | true | | |
PGE_Fuse_20200909 - FeatureClass
Name | PGE_Fuse_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Fuse 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_Fuse_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AssetOHUG | String | 30 | Asset OH or UG | Is the asset overhead or underground? Possible values: Overhead, Underground, Unknown | OhUg | | 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 | AssociatedOperatingVoltage (kV) | Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A. | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign Key to the Substation table. | | | true | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | 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 tables. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name of circuit associated with asset. | | | true | | |
MakeandManufacturer | String | 50 | Make and Manufacturer | What is the make and manufacturer of the asset? 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. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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 | | |
ExemptionStatus | String | 10 | Exemption Status | Is the asset exempt per California Public Resources Code (PRC) 4292? PRC 4292 requires clearance around support structures on which certain equipment is mounted in certain areas. Possible values: Yes, No, Unknown, N/A | ExemptionStatus | | true | | |
FuseRating | Single | 4 | Fuse Rating (A) | The nominal current rating of the fuse in amperes. | | | true | | |
AssetType | String | 30 | Asset Type | Type of fuse device. Possible values: Bridged, Current limiting, Expulsion, Fused elbow, Unknown, Other – See comment. | FuseAssetType | | true | | |
AssetTypeComment | String | 50 | Asset Type Comment | Fuse asset type not listed in the options above. | | | true | | |
AssetSubtype | String | 30 | Asset Subtype | What is the specific subtype of the fuse device? | | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). | | | true | | |
PGE_LightingArrestor_20200909 - FeatureClass
Name | PGE_LightingArrestor_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Lighting Arrestor 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_LightingArrestor_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AssetID | String | 50 | Asset ID | Unique ID for a specific lightning arrestor. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Lighting Arrestor table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AssetType | String | 30 | Asset Type | Type of point asset. Required value: Lightning arrestor. | | | 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 | | |
SupportStructureID | String | 50 | Support Structure ID | Unique ID for support structure to which a lightning arrestor is attached. It should be a traceable stable ID within the utility’s operations/processes. | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign Key to the Substation table. | | | true | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | 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 tables. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name of circuit associated with asset. | | | true | | |
MakeandManufacturer | String | 50 | Make and Manufacturer | What is the make and manufacturer of the asset? 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. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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 | | |
ExemptionStatus | String | 10 | Exemption Status | Is the asset exempt per California Public Resources Code (PRC) 4292? PRC 4292 requires clearance around support structures on which certain equipment is mounted in certain areas. Possible values: Yes, No, Unknown, N/A | ExemptionStatus | | true | | |
ArrestorRating | Single | 4 | Arrestor Rating (kV) | Rating of the lightning arrestor in kilovolts. | | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). | | | true | | |
AssetLongitude | Single | 4 | AssetLongitude | Longitude coordinate of asset (in decimal degrees). | | | true | | |
PGE_Substation_20200909 - FeatureClass
Name | PGE_Substation_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Substation 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_Substation_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AssetType | String | 30 | Asset Type | Type of point asset. Required value: Substation | | | true | | |
SubstationName | String | 50 | Substation Name | Name of substation. | | | true | | |
SubstationNominalVoltagekV | Single | 4 | 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”). Enter “-99” if N/A. | | | true | | |
AssociatedOperatingVoltagekV | Single | 4 | Associated 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”). Enter “-99” if N/A. | | | true | | |
SubstationRating | Single | 4 | Substation Rating | Power rating of the substation in mega volt amps (MVAs). | | | true | | |
SubstationType | String | 10 | Substation Type | Type of substation. Possible values: Network, Loop, Radial | SubstationType | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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). | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). | | | true | | |
PGE_SupportStructure_20200909 - FeatureClass
Name | PGE_SupportStructure_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Support Structure 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_SupportStructure_20200909 |
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 enabling connection to the “Support Structure Crossarm Detail” table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AssetType | String | 30 | Asset Type | Type of point asset. Required value: Support structure | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign Key to the Substation table. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LastIntrusiveDate | Date | 8 | Last Intrusive Date | Date of the last intrusive. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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 | | |
SupportStructureType | String | 30 | Support Structure Type | Type of support structure. Possible values: Pole, Tower, Other – See comment. | SupportStructureType | | true | | |
SupportStructureTypeComment | String | 30 | Support Structure Type Comment | Support structure type analogous to a pole or tower and not listed in the options above. Note: Crossarms are support structures for which the WSD is requesting data, but they are addressed in a separate field at the end of this able and involve related tables. | | | 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. | SupportStructureMaterial | | 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 | YesNo | | true | | |
ConstructionGrade | String | 10 | Construction Grade | Grade of construction, in accordance with GO 95, Rule 42. Possible Values: Grade A, Grade B, Grade C | ConstructionGrade | | true | | |
CrossarmAttached | String | 10 | Crossarm Attached | Is one or more crossarms attached to the support structure? Possible values: Yes, No, Unknown | YesNoUnknown | | true | | |
AssetLatitude | Single | 4 | Asset Latitude | Latitude coordinate of asset (in decimal degrees). | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). | | | true | | |
PGE_Switchgear_20200909 - FeatureClass
Name | PGE_Switchgear_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Switchgear 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_Switchgear_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AssetType | String | 30 | Asset Type | Type of point asset. Required value: Switchgear | | | true | | |
AssetOHUG | String | 30 | Asset OH or UG | Is the asset overhead or underground? Possible values: Overhead, Underground, Unknown | OhUg | | 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 | | |
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 table. | | | true | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign Key to the Substation table. | | | true | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | 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 tables. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name of circuit associated with asset. | | | true | | |
MakeandManufacturer | String | 50 | Make and Manufacturer | What is the make and manufacturer of the asset? 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. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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 | | |
ExemptionStatus | String | 10 | Exemption Status | Is the asset exempt per California Public Resources Code (PRC) 4292? PRC 4292 requires clearance around support structures on which certain equipment is mounted in certain areas. Possible values: Yes, No, Unknown, N/A | ExemptionStatus | | 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? Possible values: Distribution, Transmission | AssetClass | | true | | |
SCADAEnabled | String | 3 | SCADA Enabled | Can supervisory control and data acquisition (SCADA) be utilized with the asset? Possible values: Yes, No, N/A | YesNoNA | | 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). | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). | | | true | | |
PGE_Transformer_20200909 - FeatureClass
Name | PGE_Transformer_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Transformer 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_Transformer_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
TransformerID | String | 50 | Transformer ID | Unique ID for a specific transformer. It should be a traceable stable ID within the utility’s operations/processes. Primary key enabling connection to the “Transformer Detail” table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | 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 table. | | | true | | |
AssetType | String | 30 | Asset Type | Type of point asset. Required value: Transformer | | | true | | |
AssetOHUG | String | 30 | Asset OH or UG | Is the asset overhead or underground? Possible values: Overhead, Underground, Unknown | OhUg | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
InaBank | String | 30 | Ina 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, use additional related tables as needed), No, Unknown, N/A | ExemptionStatus | | 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). | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). | | | true | | |
PGE_WeatherStation_20200909 - FeatureClass
Name | PGE_WeatherStation_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Weather Station 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_WeatherStation_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AssetType | String | 30 | Asset Type | Type of point asset. Required field: Weather station. | | | true | | |
MakeandManufacturer | String | 30 | Make and Manufacturer | What is the make and manufacturer of the asset? 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. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
County | String | 50 | County | County in which asset is located. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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 | | |
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). | | | true | | |
AssetLongitude | Single | 4 | Asset Longitude | Longitude coordinate of asset (in decimal degrees). | | | true | | |
PGE_Initiative - FeatureDataset
Description | PGE_Initiative |
PGE_AssetInspectionLine_20200909 - FeatureClass
Name | PGE_AssetInspectionLine_20200909 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Asset Inspection Line 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_AssetInspectionLine_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AiLogID | String | 50 | AI Log ID | Unique ID or job ID of an asset inspection activity. Foreign key to the Asset inspection table. | | | true | | |
InspectionLocationOrAddress | String | 100 | Inspection Location Or Address | Address or location description for the inspection location. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
HFTDClassComment | String | 50 | HFTDClassComment | If the project line intersects multiple HFTD areas, list all of them here. | | | true | | |
City | String | 50 | City | City in where the asset inspection project is located. | | | true | | |
County | String | 50 | County | County in where the asset inspection project is located. | | | true | | |
District | String | 100 | District | Operating district where the asset inspection project occurred. | | | true | | |
PGE_AssetInspectionPoint_20200909 - FeatureClass
Name | PGE_AssetInspectionPoint_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Asset Inspection Point 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_AssetInspectionPoint_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AiLogID | String | 50 | AI Log ID | Unique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection table. | | | true | | |
InspectionLocationOrAddress | String | 100 | Inspection Location Or Address | Address or location description for the inspection location. | | | true | | |
ParcelAPN | String | 17 | 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. Use the format: ###-####-###-####. For example, 006-0144-029-0000. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
City | String | 50 | City | City in where the asset inspection project is located. | | | true | | |
County | String | 50 | County | County in where the asset inspection project is located. | | | 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 | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point in decimal degrees. | | | true | | |
PGE_AssetInspectionPolygon_20200909 - FeatureClass
Name | PGE_AssetInspectionPolygon_20200909 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | PGE Asset Inspection Polygon 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_AssetInspectionPolygon_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AiLogID | String | 50 | AI Log ID | Unique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection table. | | | true | | |
ParcelAPN | String | 17 | 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. Use the format: ###-####-###-####. For example, 006-0144-029-0000. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
HFTDClassComment | String | 50 | HFTDClassComment | If the project line intersects multiple HFTD areas, list all of them here. | | | true | | |
City | String | 50 | City | City in where the asset inspection project is located. | | | true | | |
County | String | 50 | County | County in where the asset inspection project is located. | | | true | | |
District | String | 100 | District | Operating district where the asset inspection project occurred. | | | true | | |
PGE_GridHardeningLine_20200909 - FeatureClass
Name | PGE_GridHardeningLine_20200909 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Grid Hardening Line 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_GridHardeningLine_20200909 |
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 table. This ID is exactly same as the GhID for the Grid Hardening Log. This key also joins with the Primary key for the Grid Hardening Log table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
GhLogID | String | 50 | GH Log ID | Unique ID or job ID of a grid hardening activity. Foreign key to the Grid Hardening Log table. | | | true | | |
GridHardeningLocationOrAddress | String | 100 | Grid Hardening Location Or Address | Address or location description for the grid hardening location. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
HFTDClassComment | String | 50 | HFTDClassComment | If the project line intersects multiple HFTD areas, list all of them here. | | | true | | |
City | String | 50 | City | City in where the grid hardening project is located. | | | true | | |
County | String | 50 | County | County in where the grid hardening project is located. | | | true | | |
District | String | 100 | District | Operating district where the grid hardening project. | | | true | | |
PGE_GridHardeningPoint_20200909 - FeatureClass
Name | PGE_GridHardeningPoint_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Grid Hardening Point 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_GridHardeningPoint_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
GhLogID | String | 50 | GH Log ID | Unique ID or job ID of a grid hardening activity. Foreign key to the Grid Hardening Log table. | | | true | | |
GridHardeningLocationOrAddress | String | 100 | Grid Hardening Location Or Address | Address or location description for the grid hardening location. | | | true | | |
ParcelAPN | String | 17 | 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. Use the format: ###-####-###-####. For example, 006-0144-029-0000. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
City | String | 50 | City | City in where the grid hardening project is located. | | | true | | |
County | String | 50 | County | County in where the grid hardening project is located. | | | true | | |
District | String | 100 | District | Operating district where the grid hardening project. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point in decimal degrees | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point in decimal degrees. | | | true | | |
PGE_VegetationManagementInspectionLine_20200909 - FeatureClass
Name | PGE_VegetationManagementInspectionLine_20200909 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Vegetation Management Inspection Line 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_VegetationManagementInspectionLine_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
VmiID | String | 50 | VMI ID | Unique ID or job ID of a vegetation management inspection activity. Primary key for the Vegetation Management Inspection Line table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
VmiLogID | String | 50 | VMI Log ID | Unique ID or job ID of a vegetation management inspection activity. Foreign key to the Vegetation Management Inspection Log table. | | | true | | |
InspectionLocationOrAddress | String | 100 | Inspection Location Or Address | Address or location description for the inspection location. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
HFTDClassComment | String | 50 | HFTDClassComment | If the project line intersects multiple HFTD areas, list all of them here. | | | true | | |
City | String | 50 | City | City in where the vegetation management inspection is located. | | | true | | |
County | String | 50 | County | County in where the vegetation management inspection is located. | | | true | | |
District | String | 100 | District | Operating district where the vegetation management inspection occurred. | | | true | | |
PGE_VegetationManagementInspectionPoint_20200909 - FeatureClass
Name | PGE_VegetationManagementInspectionPoint_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Vegetation Management Inspection Point 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_VegetationManagementInspectionPoint_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
VmiID | String | 50 | VMI ID | Unique ID or job ID of a vegetation management inspection activity. Primary key for the Vegetation Management Inspection Point table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
VmiLogID | String | 50 | VMI Log ID | Unique ID or job ID of a vegetation management inspection activity. Foreign key to the Vegetation Management Inspection Log table. | | | true | | |
InspectionLocationOrAddress | String | 100 | Inspection Location Or Address | Address or location description for the inspection location. | | | true | | |
ParcelAPN | String | 17 | 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. Use the format: ###-####-###-####. For example, 006-0144- 029-0000. | | | true | | |
TreeHealth | String | 3 | Tree Health | Is the tree healthy? Possible values: Yes, No | YesNo | | 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. | | | true | | |
TreeDiameter | Integer | 4 | Tree Diameter (Inches) | Tree diameter at breast height (inches). Round the value. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
City | String | 50 | City | City in where the vegetation management inspection is located. | | | true | | |
County | String | 50 | County | County in where the vegetation management inspection is located. | | | true | | |
District | String | 100 | District | Operating district where the vegetation management inspection occurred. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point in decimal degrees | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point in decimal degrees. | | | true | | |
PGE_VegetationManagementInspectionPolygon_20200909 - FeatureClass
Name | PGE_VegetationManagementInspectionPolygon_20200909 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | PGE Vegetation Management Inspection Polygon 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_VegetationManagementInspectionPolygon_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
VmiID | String | 50 | VMI ID | Unique ID or job ID of a vegetation management inspection activity. Primary key for the Vegetation Management Inspection Polygon table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
VmiLogID | String | 50 | VMI LogID | Unique ID or job ID of a vegetation management inspection activity. Foreign key to the Vegetation Management Inspection Log table. | | | true | | |
InspectionLocationOrAddress | String | 100 | Inspection Location Or Address | Address or location description for the inspection location. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
HFTDClassComment | String | 50 | City | If the project line intersects multiple HFTD areas, list all of them here. | | | true | | |
City | String | 50 | County | City in where the vegetation management inspection is located. | | | true | | |
County | String | 50 | District | County in where the vegetation management inspection is located. | | | true | | |
District | String | 100 | District | Operating district where the vegetation management inspection occurred. | | | true | | |
PGE_VegetationManagementProjectLine_20200909 - FeatureClass
Name | PGE_VegetationManagementProjectLine_20200909 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE Vegetation Management Project Line 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_VegetationManagementProjectLine_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
VMPLogID | String | 50 | WMP Log ID | VMPLogID | | | true | | |
ProjectLocationOrAddress | String | 100 | Project Location Or Address | Address or location description for tree location. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
HFTDClassComment | String | 50 | City | If the project line intersects multiple HFTD areas, list all of them here. | | | true | | |
City | String | 50 | County | City in where the vegetation management project is located. | | | true | | |
County | String | 50 | District | County in where the vegetation management project is located. | | | true | | |
District | String | 100 | District | Operating district where the vegetation management project occurred. | | | true | | |
PGE_VegetationManagementProjectPoint_20200909 - FeatureClass
Name | PGE_VegetationManagementProjectPoint_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Vegetation Management Project Point 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_VegetationManagementProjectPoint_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
VmpLogID | String | 50 | VMP Log ID | Unique ID or job ID of an initiative. Foreign key to the Vegetation Inspection Project Log table. | | | true | | |
ProjectLocationOrAddress | String | 100 | Project Location Or Address | Address or location description for tree location. Enter “N/A” if there is no address where the subject tree is located. | | | true | | |
ParcelAPN | String | 17 | 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. Use the format: ###-####-###-####. For example, “006-0144-029-0000”. | | | true | | |
TreeID | String | 50 | Tree ID | A unique ID associated with individual tree(s) within the scope of the vegetation management project. | | | true | | |
TreeHealth | String | 3 | Tree Health | Is the subject tree healthy? Possible values: Yes, No | YesNo | | true | | |
TreeHazard | String | 3 | Tree Hazard | Is the subject tree a hazard tree? Possible values: Yes, No | YesNo | | 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. | SpeciesGrowthRate | | true | | |
TreeHeight | Integer | 4 | Tree Height (feet) | Tree height (feet). Round the value. | | | true | | |
TreeDiameter | Integer | 4 | Tree Diameter (inches) | Tree diameter at breast height (inches). Round the value. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
City | String | 50 | City | City in where the vegetation management project is located. | | | true | | |
County | String | 50 | County | County in 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 | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point in decimal degrees. | | | true | | |
PGE_VegetationManagementProjectPolygon_20200909 - FeatureClass
Name | PGE_VegetationManagementProjectPolygon_20200909 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | CEC Vegetation Management Project Polygon 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_VegetationManagementProjectPolygon_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
VmpLogID | String | 50 | VMP Log ID | Unique ID or job ID of an initiative. Foreign key to the Vegetation Inspection Project Log table. | | | true | | |
ProjectLocationOrAddress | String | 100 | Project Location Or Address | Address or location description for tree location. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
HFTDClassComment | String | 50 | HFTDClassComment | If the project line intersects multiple HFTD areas, list all of them here. | | | true | | |
City | String | 50 | City | City in where the vegetation management project is located. | | | true | | |
County | String | 50 | County | County in where the vegetation management project is located. | | | true | | |
District | String | 100 | District | Operating district where the vegetation management project occurred. | | | true | | |
PGE_OtherRequiredData - FeatureDataset
Name | PGE_OtherRequiredData |
Description | PGE_OtherRequiredData |
PGE_AdministrativeArea_20200909 - FeatureClass
Name | PGE_AdministrativeArea_20200909 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | PGE Administrative Area 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_AdministrativeArea_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AdminID | String | 50 | Admin ID | Unique ID and primary key for the Administrative Area table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AreaType | String | 50 | Area Type | Type of administrative area (service territory, region, district, etc.) | | | true | | |
SubareaType | String | 50 | Subarea Type | Utility subarea type. Possible values: Operational, Construction, Weather, Organizational, Other - See comment | SubareaType | | true | | |
SubareaTypeComment | String | 50 | Subarea Type Comment | Subarea type not listed in the options above. | | | true | | |
Name | String | 100 | Name | Name of administrative area. | | | true | | |
PGE_CriticalFacility_20200909 - FeatureClass
Name | PGE_CriticalFacility_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Critical Facility 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_CriticalFacility_20200909 |
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 for the Critical Facility table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
FacilityName | String | 100 | Facility Name | Name of the facility | | | true | | |
FacilityCategory | String | 30 | Facility Category | Critical facility category. See examples table below this table for examples of facilities that fall under these categories. Possible values: Chemical, Communications, Emergency services, Energy, Government facilities, Healthcare and public health, Public safety answering points, Transportation, Water and wastewater systems, Other – See comment. | FacilityCategory | | 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, | | | 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 | YesNoUnknown | | true | | |
BackupType | String | 30 | Backup Type | Type of backup power source. Possible values: Storage battery, Diesel generator, Gas generator, Combined/hybrid, Other – See comment. | BackupType | | 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 hours 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. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | 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 | Single | 4 | 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 | 17 | Parcel APN | ID of parcel containing critical facility. Primary key for the Critical Facility table. | | | 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). | | | true | | |
Longitude | Single | 4 | Longitude | Longitude coordinate of critical facility (in decimal degrees). | | | true | | |
PGE_OtherPowerLineConnectionLocation_20200909 - FeatureClass
Name | PGE_OtherPowerLineConnectionLocation_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Other Power Line Connection Location 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_OtherPowerLineConnectionLocation_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
OplcID | String | 50 | PPIC ID | Unique ID and primary key for the private Power Line Connection Location table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
OtherLineOwner | String | 100 | Other Line Owner | Name of individual or other entity that owns the private line to which an 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. | | | 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. | | | 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 | CircuitType | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
County | String | 50 | County | County in which connection location is located. | | | true | | |
OtherConductorType | String | 10 | Other Conductor Type | Type of conductor that connects to corporation line. Possible values: Bare, Covered, Unknown | ConductorType | | true | | |
ConnectionType | String | 30 | Connection Type | Type of energy transfer happening at location. Possible values: Other to corporation, Corporation to other | ConnectionType | | 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 | ConnectionOHUG | | 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 N/A.Use -99 if this is not known. | | | 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 N/A.Use -99 for unknown. | | | 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), Copper (Cu), Unknown, Other - See comment. | ConductorMaterial | | true | | |
ConductorMaterialComment | String | 50 | 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 | | |
OtherConductorCodeName | String | 50 | Other Conductor Code Name | Codename of the other conductor that connects to the corporation conductor. For example, “Lapwing,” “Sparrow,” etc. Write “Unknown” if this is not known. | | | true | | |
ConnectionLastInspectionDate | Date | 8 | Connection Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
ConnectionLastMaintenanceDate | Date | 8 | Connection Last Maintenance Date | Date of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
ConnectionEstablishmentDate | Date | 8 | Connection Establishment Date | Date the connection was established. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
ConnectionEstablishmentYear | Integer | 4 | Connection Establishment Year | Year of connection establishment. Use four digits. Can be pulled from the “InstallationDate” field with a field calculation. Enter “-99” if unknown. | | | true | | |
EstimatedConnectionAge | String | 10 | Estimated Connection 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) | EstimatedAge | | 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. Use -99 for unknown. | | | 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 | YesNoUnknown | | true | | |
OtherPowerLineComments | String | 100 | Other Power Line Comments | Describe any additional key details that should be known about the connection location. | | | true | | |
PGE_RedFlagWarningDayPolygon_20200909 - FeatureClass
Name | PGE_RedFlagWarningDayPolygon_20200909 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | PGE Red Flag Warning Day Polygon 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_RedFlagWarningDayPolygon_20200909 |
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 table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | 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 | | |
RedFlagWarningIssueDate | Date | 8 | Red Flag Warning Issue Date | Start date of the RFW in YYYY-MM-DD format. Do not include time. | | | true | | |
RedFlagWarningIssueTime | Date | 8 | Red Flag Warning Issue Time | Start time of the RFW. Must be in the “hh:mm:ss” format. | | | true | | |
NumberRedFlagWarningDays | Integer | 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 | Single | 4 | 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_20200909 - FeatureClass
Name | PGE_PspsEventCustomerMeterPoint_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE PSPS Event Customer Meter Point 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_PspsEventCustomerMeterPoint_20200909 |
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. | | | true | | |
EventID | String | 50 | Event ID | A unique standardized identification name of the unique event. Foreign key enabling connection to “PSPS Event Log” table. | | | true | | |
AssetID | String | 50 | Asset ID | Unique ID for a specific meter. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the Meter table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | 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_PspsEventDamagePoint_20200909 - FeatureClass
Name | PGE_PspsEventDamagePoint_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE PSPS Event Damage Point 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_PspsEventDamagePoint_20200909 |
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 to PSPS event conductor, support structure, and other asset damage detail tables. | | | true | | |
EventID | String | 50 | Event ID | A unique standardized identification name of the unique event. Foreign key enabling connection to “PSPS Event Log” table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
FuelBedDescription | String | 150 | Fuel Bed Description | Type of fuel bed existing under 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. | FuelBedDescription | | 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. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
County | String | 150 | County | County in which asset damage is located. If the line crosses multiple counties, list all counties separated by commas. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of point in decimal degrees. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of point in decimal degrees. | | | true | | |
PGE_PspsEventLine_20200909 - FeatureClass
Name | PGE_PspsEventLine_20200909 |
ShapeType | Polyline |
FeatureType | Simple |
AliasName | PGE PSPS Event Line 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_PspsEventLine_20200909 |
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 table. | | | true | | |
EventID | String | 50 | Event ID | A unique standardized identification name of the unique event. Foreign key enabling connection to “PSPS Event Log” 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 tables. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | 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_20200909 - FeatureClass
Name | PGE_PspsEventPolygon_20200909 |
ShapeType | Polygon |
FeatureType | Simple |
AliasName | PGE PSPS Event Polygon 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_PspsEventPolygon_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
PspsEventPolygonID | String | 50 | PSPS Event Polygon ID | Primary key for PSPS Event Polygons. | | | true | | |
EventID | String | 50 | Event ID | A unique standardized identification name of the unique event. Foreign key enabling connection to “PSPS Event Log” 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 tables. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | 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_RiskEvent - FeatureDataset
PGE_DistributionOutage_20200909 - FeatureClass
Name | PGE_DistributionOutage_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Distribution Outage 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_DistributionOutage_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
DoutageID | String | 50 | Distribution Outage ID | The unique ID for outage event. Primary key for the Distribution Outages table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
EventYear | Integer | 4 | Event Year | The year outage started. Use four digits. | | | true | | |
OutageStartDate | Date | 8 | Outage Start Date | The date outage started. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
OutageStartTime | Date | 8 | Outage Start Time | The time outage started. Must be in the “hh:mm:ss” format. | | | true | | |
OutageEndDate | Date | 8 | Outage End Date | The date of full restoration. | | | true | | |
OutageEndTime | Date | 8 | Outage End Time | The time of full restoration. Must be in the “hh:mm:ss” format. | | | true | | |
OutageDuration | Date | 8 | Outage Duration | The total time to restore all customers from the first customer out. Must be in the “hh:mm:ss” format. | | | true | | |
CMI | Single | 4 | Total 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. | | | true | | |
CustomersOutSustained | Integer | 4 | Customers Out Sustained | Total number of unique customers that experienced an outage lasting longer than 5 minutes. | | | true | | |
CustomerCount | Integer | 4 | Customer Count | The total number of customers impacted by the outage. | | | 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 | OutageInterval | | 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 | | |
OtherCompanies | String | 150 | Other Companies | Affected companies from the event. | | | true | | |
OutageClass | String | 30 | Outage Class | The class of circuit involved in the outage. Possible Values: Distribution | | | 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 table. | | | 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 assign N/A. Possible values: Enabled, Disabled, N/A | RecloserSetting | | true | | |
IsolationDeviceType | String | 30 | Isolation Device Type | Type of protective device that operated. Possible values: Circuit Breaker, Fuse, Lightning Arrestor, Switch, Other – See comment | IsolationDeviceType | | true | | |
IsolationDeviceTypeComment | String | 30 | Isolation Device Type Comment | Isolation device type description not listed in the options above. | | | true | | |
BasicCause | String | 30 | Basic Cause | High-level category for event cause. Possible values: Object contact, Equipment failure, Wire-to-wire contact, Contamination, Utility work/Operation, Vandalism/Theft, Unknown, Other – See comment. | SuspectedCause | | true | | |
BasicCauseComment | String | 30 | Basic Cause Comment | Basic cause description not listed in the options above. | | | true | | |
BasicCauseObject | String | 30 | Basic Cause Object | Description of object involved in contact if “Object contact” is value of “BasicCause.” Possible values: Vegetation contact, Animal contact, Balloon contact, Vehicle contact - car pole, Vehicle contact - aircraft, 3rd party contact (e.g. 3rd party tree trimmer), Unknown, N/A | ObjectContact | | true | | |
BasicCauseObjectComment | String | 30 | Basic Cause Object Comment | Basic cause object description not listed in the options above. | | | 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 arrestor, Pole, Recloser, Relay, Sectionalizer, Splice, Switch, Tap, Tie wire, Transformer, Voltage regulator/ booster, Unknown, Other – See comment., N/A | Equiment Failure | | true | | |
DamagedDeviceComment | String | 30 | Damaged Device Comment | Damaged device description not listed in the options above. | | | 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 | YesNoNA | | true | | |
OutageDescription | String | 100 | Outage Description | Description or additional information for the outage. | | | true | | |
MED | 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 | YesNo | | true | | |
SupplementalCause | String | 50 | Supplemental Cause | The supplemental cause of the outage. | | | true | | |
SupplementalCauseDescription | String | 100 | Supplemental Cause Description | Please describe the supplemental cause of the outage. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
LocationOrAddress | String | 100 | Location or Address | Address or location description for the outage location. | | | true | | |
City | String | 50 | City | City in where the outage event is located. | | | true | | |
County | String | 50 | County | County in 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. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point in decimal degrees. | | | true | | |
PGE_DistributionVmOutage_20200909 - FeatureClass
Name | PGE_DistributionVmOutage_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Distribution VM Outage 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_DistributionVmOutage_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
DvmOutageID | String | 50 | VM Outage ID | The unique ID for outage caused by vegetation. Primary key for the Distribution VM Outages table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
DoutageID | String | 50 | Outage ID | Foreign key to the Distribution Outages table. | | | true | | |
EventYear | Integer | 4 | Event Year | The year outage started. Use four digits. | | | true | | |
DateOut | Date | 8 | Date Out | The date outage started. Use YYYY-MM-DD format. Leave blank if unknown. | | | true | | |
TimeOut | Date | 8 | Time Out | The time outage started. Must be in the “hh:mm:ss” format. | | | true | | |
InspectionDate | Date | 8 | Inspection Date | Date of inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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 table. | | | 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 | | |
TreeSpecies | String | 100 | Tree Species | Species of the subject tree involved in causing the outage. | | | true | | |
TreeHeight | Integer | 4 | Tree Height (feet) | Tree height estimation height of the subject tree involved in causing the outage, in feet. | | | true | | |
TreeDBH | Integer | 4 | Tree Diameter at Breast Height (Inches) | Tree diameter at breast height of the subject tree involved in causing the outage, in inches. | | | true | | |
TreeTrunkDistance | Integer | 4 | Tree Trunk Distance (feet) | Horizontal distance of the subject tree’s trunk from the impacted power lines, in feet. | | | true | | |
VmOutageDescription | String | 100 | VM Outage Description | Description or additional information for the VM outage event. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
LocationOrAddress | String | 100 | Location or Address | Address or location description for the outage location. | | | true | | |
City | String | 50 | City | City in where the VM outage is located. | | | true | | |
County | String | 50 | County | County in where the VM outage is located. | | | true | | |
District | String | 100 | District | Operating district where the VM outage occurred. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point in decimal degrees. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point in decimal degrees. | | | true | | |
PGE_Ignition_20200909 - FeatureClass
Name | PGE_Ignition_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Ignition 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_Ignition_20200909 |
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 Point table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
FireStartTime | Date | 8 | Fire Start Time | The start time of the event. Must be in the “hh:mm:ss” format. | | | true | | |
FireStartDate | Date | 8 | Fire Start Date | The start date of the event. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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 – Comment. | FireDetectionMethod | | 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, Utility work/Operation, Vandalism/Theft, Unknown, Other – See comment. | SuspectedCause | | 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 value of “SuspectedInitiatingEvent”. If “Object contact” is not the value of “SuspectedInitiatingEvent,” then enter N/A for this field. Possible values: Vegetation contact, Animal contact, Balloon contact, Vehicle contact - car pole, Vehicle contact - aircraft, 3rd party contact (e.g. 3rd party tree trimmer), Unknown, N/A | ObjectContact | | true | | |
EquimentFailure | String | 30 | Equiment 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 arrestor, Pole, Recloser, Relay, Sectionalizer, Splice, Switch, Tap, Tie wire, Transformer, Voltage regulator/ booster, Unknown, Other – See comment., N/A | Equiment Failure | | 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 | | |
SubstationID | String | 50 | Substation ID | Unique ID of the substation supplying the involved circuit. Foreign key to Substation table. | | | true | | |
SubstationName | String | 50 | Substation Name | Name of the substation supplying the involved circuit. | | | true | | |
OtherCompanies | String | 50 | Other Companies | Affected companies from the event. | | | true | | |
EquipmentType | String | 30 | Equipment Type | The type of equipment involved in the ignition event. Possible values: Overhead, Pad-mounted, Subsurface | EquipmentType | | true | | |
Determination | String | 30 | Determination | The entity relied upon to make the determination of “SuspectedInitiatingEvent” above. Possible values: Utility personnel, Fire Agency, Other – See comment | Determination | | 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 “SuspectedInitiatingEvent”. Possible values: Electric Facility, Pole, Communication Facility | FacilityContacted | | true | | |
ContributingFactor | String | 30 | Contributing Factor | Factors suspected as contributing to the ignition. Possible values: Weather, External Force, Human Error, Other – See comment, Unknown | ContributingFactor | | 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 | YesNo | | true | | |
RFWIssueDate | Date | 8 | Red Flag Warning Issue Date | The date on which the NWS issued the RFW in effect at the ignition location at the time of the ignition event. Leave blank if there was no RFW in effect at the time of ignition at the ignition location. Also leave blank if unknown. Use YYYY-MM-DD format. | | | true | | |
RFWIssueTime | Date | 8 | Red Flag Warning Issue Time | The time at which the NWS issued the RFW in effect at the ignition location at the time of the ignition event. Leave blank if there was no RFW in effect at the time of ignition at the ignition location. Must be in the “hh:mm:ss” format. | | | 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 | YesNo | | true | | |
FWWIssueDate | Date | 8 | Fire Weather Watch IssueDate | The date on which the NWS issued the FWW in effect at the ignition location at the time of the ignition event. Leave blank if there was no FWW in effect at the time of ignition at the ignition location. Also leave blank if unknown. Use YYYY-MM-DD format. | | | true | | |
FWWIssueTime | Date | 8 | Fire Weather Watch IssueTime | The time at which the NWS issued the FWW in effect at the ignition location at the time of the ignition event. Leave blank if there was no FWW in effect at the time of ignition at the ignition location. Must be in the “hh:mm:ss” format. | | | 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 | YesNo | | true | | |
HWWIssueDate | Date | 8 | High Wind Warning IssueDate | The date on which 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. Use YYYY-MM-DD format. | | | true | | |
HWWIssueTime | Date | 8 | High Wind Warning IssueTime | The time at which 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. Must be in the “hh:mm:ss” format. | | | true | | |
OriginLandUse | String | 10 | Origin Land Use | Status of land at origin of ignition. Possible values: Rural, Urban | OriginLandUse | | true | | |
MaterialAtOrigin | String | 30 | Material At Origin | Fuel material for the ignition origin. Possible values: Vegetation, Structure, Other – See comment | MaterialAtOrigin | | true | | |
MaterialAtOriginComment | String | 30 | Material At Origin Comment | Material at origin description not listed in the options above. | | | true | | |
FuelBedDescription | String | 100 | Fuel Bed Description | 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. | FuelBedDescription | | 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, 100-299, 300-999, 1,000-4,999, >5,000, Unknown" | FireSize | | true | | |
SuppressedBy | String | 30 | Suppressed By | Entity responsible for suppressing ignition. Possible values: Customer, Fire agency, Self-extinguished, Utility, Unknown | SuppressedBy | | true | | |
SuppressingAgency | String | 30 | Suppressing Agency | If the “SupressedBy” is “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 | FireInvestigation | | true | | |
FireAHJ | String | 100 | Fire AHJ | 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 | YesNo | | true | | |
ToutageID | String | 50 | Transmission Outage ID | A unique ID for the transmission outage event. Foreign key to the Transmission Outages table. | | | true | | |
DoutageID | String | 50 | Distribution Outage ID | A unique ID for the distributoin outage event. Foreign key to the Distribution Outages table. | | | 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. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
City | String | 50 | City | City in where the ignition event is located. | | | true | | |
County | String | 50 | County | County in where the ignition event is located. | | | true | | |
District | String | 100 | District | Operating district where the ignition occurred. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point in decimal degrees. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point in decimal degrees. | | | true | | |
PGE_TransmissionOutage_20200909 - FeatureClass
Name | PGE_TransmissionOutage_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Transmission Outage 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_TransmissionOutage_20200909 |
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 Outages table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
EventYear | Integer | 4 | Event Year | The year outage started. Use four digits. | | | true | | |
OutageStartDate | Date | 8 | Outage Start Date | The date outage started. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
OutageStartTime | Date | 8 | Outage Start Time | The time outage started. Must be in the “hh:mm:ss” format. | | | true | | |
OutageEndDate | Date | 8 | Outage End Date | The date of full restoration. | | | true | | |
OutageEndTime | Date | 8 | Outage End Time | The time of full restoration. Must be in the “hh:mm:ss” format. | | | true | | |
OutageDuration | Date | 8 | Outage Duration | The total time to restore all customers from the first customer out. Must be in the “hh:mm:ss” format. | | | true | | |
CMI | Single | 4 | Total 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. | | | true | | |
CustomersOutSustained | Integer | 4 | Customers Out Sustained | Total number of unique customers that experienced an outage lasting longer than 5 minutes. | | | true | | |
CustomerCount | Integer | 4 | Customer Count | The total number of customers impacted by the outage. | | | 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 | OutageInterval | | 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 | | |
OtherCompanies | String | 150 | Other Companies | Affected companies from the event. | | | true | | |
OutageClass | String | 30 | Outage Class | The class of circuit involved in the outage. Possible Values: Transmission | | | 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 table. | | | 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 assign N/A. Possible values: Enabled, Disabled, N/A | RecloserSetting | | true | | |
IsolationDeviceType | String | 30 | Isolation Device Type | Type of protective device that operated. Possible values: Circuit Breaker, Fuse, Lightning Arrestor, Switch, Other – See comment | IsolationDeviceType | | true | | |
IsolationDeviceTypeComment | String | 30 | Isolation Device Type Comment | Isolation device type description not listed in the options above. | | | true | | |
BasicCause | String | 30 | Basic Cause | High-level category for event cause. Possible values: Object contact, Equipment failure, Wire-to-wire contact, Contamination, Utility work/Operation, Vandalism/Theft, Unknown, Other – See comment. | SuspectedCause | | true | | |
BasicCauseComment | String | 30 | Basic Cause Comment | Basic cause description not listed in the options above. | | | true | | |
BasicCauseObject | String | 30 | Basic Cause Object | Description of object involved in contact if “Object contact” is value of “BasicCause.” Possible values: Vegetation contact, Animal contact, Balloon contact, Vehicle contact - car pole, Vehicle contact - aircraft, 3rd party contact (e.g. 3rd party tree trimmer), Unknown, N/A | ObjectContact | | true | | |
BasicCauseObjectComment | String | 30 | Basic Cause Object Comment | Basic cause object description not listed in the options above. | | | 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 arrestor, Pole, Recloser, Relay, Sectionalizer, Splice, Switch, Tap, Tie wire, Transformer, Voltage regulator/ booster, Unknown, Other – See comment., N/A | Equiment Failure | | true | | |
DamagedDeviceComment | String | 30 | Damaged Device Comment | Damaged device description not listed in the options above. | | | 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 | YesNoNA | | true | | |
OutageDescription | String | 100 | Outage Description | Description or additional information for the outage. | | | true | | |
MED | 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 | YesNo | | true | | |
SupplementalCause | String | 50 | Supplemental Cause | The supplemental cause of the outage. | | | true | | |
SupplementalCauseDescription | String | 100 | Supplemental Cause Description | Please describe the supplemental cause of the outage. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
LocationOrAddress | String | 100 | Location or Address | Address or location description for the outage location. | | | true | | |
City | String | 50 | City | City in where the outage event is located. | | | true | | |
County | String | 50 | County | County in 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. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point in decimal degrees. | | | true | | |
PGE_TransmissionVmOutage_20200909 - FeatureClass
Name | PGE_TransmissionVmOutage_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Transmission VM Outage 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_TransmissionVmOutage_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
TvmOutageID | String | 50 | Transmission VM Outage ID | The unique ID for outage caused by vegetation. Primary key for the Transmission VM Outages table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
ToutageID | String | 50 | Outage ID | Foreign key to the Transmission Outages table. | | | true | | |
EventYear | Integer | 4 | Event Year | The year outage started. Use four digits. | | | true | | |
DateOut | Date | 8 | Date Out | The date outage started. Use YYYY-MM-DD format. Leave blank if unknown. | | | true | | |
TimeOut | Date | 8 | Time Out | The time outage started. Must be in the “hh:mm:ss” format. | | | true | | |
InspectionDate | Date | 8 | Inspection Date | Date of inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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 table. | | | 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 | | |
TreeSpecies | String | 100 | Tree Species | Species of the subject tree involved in causing the outage. | | | true | | |
TreeHeight | Integer | 4 | Tree Height (feet) | Tree height estimation height of the subject tree involved in causing the outage, in feet. | | | true | | |
TreeDBH | Integer | 4 | Tree Diameter at Breast Height (Inches) | Tree diameter at breast height of the subject tree involved in causing the outage, in inches. | | | true | | |
TreeTrunkDistance | Integer | 4 | Tree Trunk Distance (feet) | Horizontal distance of the subject tree’s trunk from the impacted power lines, in feet. | | | true | | |
VmOutageDescription | String | 100 | VM Outage Description | Description or additional information for the VM outage event. | | | true | | |
HFTDClass | String | 10 | HFTD Class | The CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
LocationOrAddress | String | 100 | Location or Address | Address or location description for the outage location. | | | true | | |
City | String | 50 | City | City in where the VM outage is located. | | | true | | |
County | String | 50 | County | County in where the VM outage is located. | | | true | | |
District | String | 100 | District | Operating district where the VM outage occurred. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point in decimal degrees. | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point in decimal degrees. | | | true | | |
PGE_WireDown_20200909 - FeatureClass
Name | PGE_WireDown_20200909 |
ShapeType | Point |
FeatureType | Simple |
AliasName | PGE Wire Down 20200909 |
HasM | false |
HasZ | false |
HasAttachments | false |
Description | PGE_WireDown_20200909 |
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 Point table. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
WireDownDate | Date | 8 | Wire Down Date | The start date of the wire down event. Use YYYY-MM-DD format. Leave blank if unknown. | | | true | | |
WireDownYear | Integer | 4 | Wire Down Year | The year that the risk event occurred. Use four digits. | | | true | | |
SuspectedWireDownCause | String | 30 | Suspected Wire Down Cause | High-level category for wire down event cause. Possible values: Object contact, Equipment failure, Wire-to-wire contact, Contamination, Utility work/Operation, Vandalism/Theft, Unknown, Other – See comment. | SuspectedCause | | true | | |
SuspectedWireDownCauseComment | String | 30 | Suspected Wire Down Cause Comment | Suspected 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.” Possible values: Vegetation contact, Animal contact , Balloon contact, Vehicle contact - car pole, Vehicle contact - aircraft, 3rd party contact (e.g. 3rd party tree trimmer), Unknown, N/A | ObjectContact | | true | | |
EquimentFailure | String | 30 | Equiment 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 arrestor, Pole, Recloser, Relay, Sectionalizer, Splice, Switch, Tap, Tie wire, Transformer, Voltage regulator/ booster, Unknown, Other – See comment., N/A | Equiment Failure | | true | | |
EquipmentFailureComment | String | 30 | Equipment Failure Comment | Equipment failure description not listed in the options above. | | | 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 | | |
SpanLength | Single | 4 | Span Length (feet) | The length of a single-phase conductor, in feet, as measured between the “FromDevice” and “ToDevice.” | | | 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 | YesNo | | 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), Copper (Cu), Other – See comment. | ConductorMaterial | | 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 | | |
ConductorCodeName | String | 30 | Conductor Code Name | The code name of the conductor involved in the wire down event. For example, Lapwing, Sparrow, Merlin, etc. | | | 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 | YesNo | | true | | |
ToutageID | String | 50 | Transmission Outage ID | A unique ID for the transmission outage event. Foreign key to the Transmission Outages table. | | | true | | |
DoutageID | String | 50 | Distribution Outage ID | A unique ID for the distribution outage event. Foreign key to the Distribution Outages table. | | | true | | |
Energized | String | 3 | 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, N/A | YesNoNA | | true | | |
IgnitionStatus | String | 3 | Ignition Status | Was there an ignition associated with the wire down event? Possible values: Yes, No | YesNo | | 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. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTD | HFTD | | true | | |
City | String | 50 | City | City in where the wire down event is located. | | | true | | |
County | String | 50 | County | County in where the wire down event is located. | | | true | | |
District | String | 100 | District | Operating district where the wire down occurred. | | | true | | |
Latitude | Single | 4 | Latitude | Latitude of event point in decimal degrees | | | true | | |
Longitude | Single | 4 | Longitude | Longitude of event point in decimal degrees. | | | true | | |
PGE_AssetInspectionLog_20200909 - Table
Name | PGE_AssetInspectionLog_20200909 |
AliasName | PGE Asset Inspection Log 20200909 |
HasAttachments | false |
Description | PGE_AssetInspectionLog_20200909 |
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 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 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. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
PerformedBy | String | 30 | Performed By | Who performed the asset inspection? Possible values: Utility staff, Contractor, Other – See comment | PerformedBy | | true | | |
PerformedByComment | String | 30 | Performed By Comment | Inspector description not listed in the options above. | | | true | | |
InpsectorName | String | 50 | Inpsector Name | Inspector name for the asset management inspection. | | | true | | |
InspectionType | String | 30 | Inspection Type | The type of asset inspection performed. Possible values: Patrol, Detailed, Pole loading, Other – See comment. | InspectionType | | 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 | YesNo | | true | | |
InspectionComments | String | 100 | Inspection Comments | 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 | YesNo | | true | | |
InspectionMethod | String | 100 | Inspection Method | The method(s) by which the asset inspection was conducted. Possible values: Drive by, Walk out, Aerial – drone, Aerial – helicopter, Remote sensing – Infrared/Thermal, Remote sensing – LiDAR, Other – See comment. | InspectionMethod | | 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 | InspectionTechnology | | true | | |
InspectionTechnologyComment | String | 30 | Inspection Technology Comment | Inspection technology not listed in the options above. | | | true | | |
PGE_GridHardeningLog_20200909 - Table
Name | PGE_GridHardeningLog_20200909 |
AliasName | PGE Grid Hardening Log 20200909 |
HasAttachments | false |
Description | PGE_GridHardeningLog_20200909 |
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 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 table. | | | true | | |
GhStatus | String | 30 | GH Status | The status of the grid hardening activity. Possible values: Planned, In progress, Complete, Cancelled | GhStatus | | 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 | YesNo | | true | | |
GhChangeOrderDate | Date | 8 | GH Change Order Date | The date of when the change order was submitted. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
GhChangeOrderType | String | 100 | GH Change Order Type | GhChangeOrderType | GhChangeOrderType | | true | | |
GhChangeOrderTypeComment | String | 100 | Gh Change Order Type Comment | GhChangeOrderTypeComment | | | true | | |
DateStart | Date | 8 | Date Start | The start date of the grid hardening project. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
DateEnd | Date | 8 | Date End | The completion date of the grid hardening project. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LineDeenergized | String | 3 | Line Deenergized | Lines need to be de-energized to perform the work. Possible values: Yes, No | YesNo | | true | | |
PersonInChargeName | String | 50 | Person In Charge Name | Person in charge for the grid hardening project. | | | true | | |
PerformedBy | String | 30 | Performed By | Who performed the grid hardening activity? Possible values: Utility staff, Contractor, Other – See comment. | PerformedBy | | true | | |
PerformedByComment | String | 30 | Performed By Comment | Entity that performed grid hardening and is not listed in options above. | | | true | | |
InitiativeActivity | String | 100 | Initiative Activity | Initiative activities related to the grid hardening project which include: Capacitor maintenance and replacement; Circuit breaker maintenance and installation; Conductor replacement; Covered conductor installation; Covered conductor maintenance, Crossarm maintenance, repair, and replacement; Expulsion fuse replacement; Grid topology improvements to mitigate or reduce PSPS events; Installation of system automation equipment; Installation of sectionalizing equipment; Maintenance, repair, and replacement of connectors, including hotline clamps; Other corrective action; Pole replacement; Pole reinforcement; Transformer maintenance and replacement; Transmission tower maintenance and replacement; Undergrounding of electric lines and/or equipment; Other – See comment. | InitiativeActivity | | true | | |
InitiativeActivityComment | String | 50 | Initiative Activity Comment | Initiative activity not listed in the options above. | | | true | | |
DescriptionOfGridHardening | String | 100 | Description Of Grid Hardening | Additional description for the grid hardening work. | | | true | | |
PGE_InitiativeAssetLog_20200909 - Table
Name | PGE_InitiativeAssetLog_20200909 |
AliasName | PGE Initiative Asset Log 20200909 |
HasAttachments | false |
Description | PGE_InitiativeAssetLog_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AssetLogID | String | 50 | Asset Log ID | Unique ID and primary key for the Initiative Asset Log table. | | | 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 tables. This value can be repeated based on the amount of asset or circuit segments. | | | 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 tables. This value can be repeated based on the amount of asset or circuit segments. | | | true | | |
AiID | String | 50 | AI ID | Unique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection Point, Line and Polygon tables. This value can be repeated based on the amount of asset or circuit segments. | | | 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 tables. This value can be repeated based on the amount of asset or circuit segments. | | | 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 | | |
AssociatedAssetCount | Integer | 4 | Associated Asset Count | The number of assets which are associated with the initiative activity. | | | true | | |
SubstationID | String | 50 | Substation ID | Unique ID of the substation supplying the circuit associated with vegetation management project. | | | true | | |
SubstationName | String | 50 | Substation Name | Name of the substation supplying the circuit associated with the vegetation management project. | | | 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 | | |
CircuitName | String | 255 | Circuit Name | Name of the circuit associated with the vegetation management project. | | | true | | |
CircuitType | String | 30 | Circuit Type | Circuit line type. Possible values: Transmission Line, Primary Distribution Line, Secondary Distribution Line, Unknonwn | CircuitType | | true | | |
AssociatedCircuitLength | Single | 4 | Associated Circuit Length (mile) | The length of circuits which are associated with the initiative activity (mile). Two decimal places. | | | true | | |
Underbuild | String | 3 | Underbuild | Are transmission lines also present on the subject structure? Possible values: Yes, No | YesNo | | true | | |
LineDeenergized | String | 3 | Line Deenergized | Do the power lines need to be de-energized to perform the work? Possible values: Yes, No | YesNo | | true | | |
PGE_InitiativePhotoLog_20200909 - Table
Name | PGE_InitiativePhotoLog_20200909 |
AliasName | PGE Initiative Photo Log 20200909 |
HasAttachments | false |
Description | PGE_InitiativePhotoLog_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
PhotoID | String | 100 | Photo ID | ID for photo showing the initiative or inspection findings. Primary key for the Initiative Photo Log table. Photo format: Geotagged JPEG or PNG. Use format UtilityName_DistrictID_InspectorInitial_Initiative_YYYYMMDD_PhotoNumber. For example, “UtilityG+E_AB_20200703_Initiative_1.png” | | | true | | |
PhotoBeforeID | String | 100 | Photo Before ID | ID for photo showing the initiative or inspection location prior to the project happening or a corrective action taking place. Primary key for the Initiative Photo Log table. Photo format: Geotagged JPEG or PNG. Use format UtilityName_DistrictID_InspectorInitial_Initiative_YYYYMMDD_PhotoNumber. For example, “UtilityG+E_AB_Initiative_20200703_1.png” | | | true | | |
PhotoAfterID | String | 100 | Photo After ID | ID for photo showing the initiative or inspection location after a project happens or a corrective action takes place. Primary key for the Initiative Photo Log table. Use format UtilityName_DistrictID_InspectorInitial_Initiative_YYYYMMDD_PhotoNumber. For example, “UtilityG+E_AB_Initiative_20200703_1.png” | | | 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 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 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. Foregin key to the Asset inspection 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 tables. This value can be repeated based on the number of photos taken. | | | true | | |
FromDevice | String | 50 | From Device | 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 | | |
ToDevice | String | 50 | To Device | 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_PspsDamagePhotoLog_20200909 - Table
Name | PGE_PspsDamagePhotoLog_20200909 |
AliasName | PGE PSPS Damage Photo Log 20200909 |
HasAttachments | false |
Description | PGE_PspsDamagePhotoLog_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
PhotoID | String | 100 | Photo ID | Number or other label for a photo of the asset that enables the point to be linked to GIS data. If more than one photo is taken, enter additional IDs with separation commas. A primary key for the “PSPS Damage Photo Log” table. Photo format: Geotagged JPEG or PNG. Use format: UtilityName_DistrictID_InspectorInitial_PspsDamage_YYYYMMDD_PhotoNumber. For example, “UtilityG+E_AB_PspsDamage_20200703_1.png”. | | | true | | |
FuelBedPhotoID | String | 100 | Fuel Bed Photo ID | Number or other label for a photo of the fuel bed below the damaged asset that enables the point to be linked to GIS data. If more than one photo is taken, enter additional IDs with separation commas. A primary key for the “PSPS Damage Photo Log” table. | | | true | | |
DamageEventID | String | 100 | Damage Event ID | Foreign key to the damage point tables. | | | true | | |
PGE_PspsEventConductorDamageDetail_20200909 - Table
Name | PGE_PspsEventConductorDamageDetail_20200909 |
AliasName | PGE PSPS Event Conductor Damage Detail 20200909 |
HasAttachments | false |
Description | PGE_PspsEventConductorDamageDetail_20200909 |
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 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 Points” feature class. | | | true | | |
DateofDamage | Date | 8 | Date of Damage | Date or estimated date damage occurred in YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
EstimatedTimeofDamage | Date | 8 | Time of Damage | Estimated time damage occurred. Must be in the “hh:mm:ss” format. | | | 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 tables. | | | true | | |
Asset | String | 10 | Asset | Specific type of asset that is damaged. Required value: Conductor | | | 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 | | |
FromDevice | String | 50 | From Device | The upstream support structure asset ID. Foreign key to the related asset point tables. AKA AssetID. | | | true | | |
ToDevice | String | 50 | To Device | The downstream support structure asset ID. Foreign key to the related asset point tables. AKA AssetID. | | | true | | |
FeederID | String | 50 | FeederID | Circuit/feeder ID for the damaged span of line. Foreign to the related asset line tables. | | | 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), Copper (Cu), Other – See comment. | ConductorMaterial | | true | | |
ConductorMaterialComment | String | 50 | Conductor Material Comment | Conductor material not listed in the options above. | | | true | | |
ConductorType | String | 10 | Conductor Type | Type of conductor. Possible values: Bare, Covered, Unknown | ConductorType | | 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 | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign Key to the Substation table. | | | true | | |
SubstationType | String | 10 | Substation Type | Type of substation. Possible values: Radial, Loop, Network | SubstationType | | true | | |
Cause | String | 30 | Cause | High-level category for PSPS event cause. Possible values: Object contact, Equipment failure, Wire-to-wire contact, Contamination, Utility work/Operation, Vandalism/Theft, Unknown, Other – See comment. | EventCause | | 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 | YesNoUnknown | | 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. 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 IOU 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. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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. Use -99 for unknown. | | | true | | |
LikelyArcing | String | 10 | Likely Arcing | Was arcing likely because of the damage? Possible values: Yes, No, Unknown | YesNoUnknown | | true | | |
DamageType | String | 30 | Damage Type | Type of damage sustained. Possible values: Asset damage, Asset failure, Equipment damage, Equipment failure, Veg contact, Object contact | DamageType | | 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. | DamageDescription | | true | | |
DamageDescriptionComment | String | 30 | Damage Description Comment | Damage category not listed in the options above and/or additional relevant details about damage | | | true | | |
PGE_PspsEventLog_20200909 - Table
Name | PGE_PspsEventLog_20200909 |
AliasName | PGE PSPS Event Log 20200909 |
HasAttachments | false |
Description | PGE_PspsEventLog_20200909 |
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 classes. | | | 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 tables. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name of circuit associated with asset. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | 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 table. | | | true | | |
SubstationName | String | 50 | 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. | IsolationDevice | | true | | |
IsolationDeviceComment | String | 50 | Isolation Device Comment | Isolation device not listed in the options above. | | | 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. | | | true | | |
EOCActivationDate | Date | 8 | EOC Activation Date | Date IOU’s emergency operation center (EOC) was activated in YYYY-MM-DD format. Do not include time. | | | true | | |
EOCActivationTime | Date | 8 | EOC Activation Time | Time IOU’s emergency operation center was activated. Must be in the “hh:mm:ss” format. | | | true | | |
StartDate | Date | 8 | Start Date | Start date of the PSPS event in YYYY-MM-DD format. Do not include time. | | | true | | |
StartTime | Date | 8 | Start Time | Start time of the PSPS event (i.e. when the first de-energization occurred). Must be in the “hh:mm:ss” format. | | | true | | |
AllClearDate | Date | 8 | All Clear Date | Date the weather event precipitating the PSPS event cleared the area, and the utility began inspection and restoration efforts. Must be in YYYY-MM-DD format. Do not include time. | | | true | | |
AllClearTime | Date | 8 | All Clear Time | Time the weather event precipitating the PSPS event cleared the area, and the utility began inspection and restoration efforts. Must be in the “hh:mm:ss” format. | | | true | | |
AllLoadUpDate | Date | 8 | All Load Up Date | Date last customer was fully restored following the PSPS event. Must be in YYYY-MM-DD format. Do not include time. | | | true | | |
AllLoadUpTime | Date | 8 | All Load Up Time | Time the last customer was fully restored following the PSPS event and “All Load Up” was declared. Must be in the “hh:mm:ss” format. | | | 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. | | | 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 | "ActualDurationMinutes" multiplied by "TotalCustomers". This field features total customer minutes impacted across the circuit. | | | true | | |
TotalCustomerHours | Integer | 4 | Total Customer Hours | "TotalCustomerMinutes" divided by 60. This field features total customer hours impacted across the circuit. | | | 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 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 | YesNo | | true | | |
RelativeHumidityRisk | String | 3 | Relative Humidity Risk | Was low relative humidity a driving risk factor in the PSPS decision? Possible values: Yes, No | YesNo | | true | | |
TemperatureRisk | String | 3 | Temperature Risk | Was high temperature a driving risk factor in the PSPS decision? Possible values: Yes, No | YesNo | | 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 | YesNo | | 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 | YesNo | | 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 | YesNo | | 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 | YesNo | | 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 | YesNo | | 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 | YesNo | | 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_20200909 - Table
Name | PGE_PspsEventOtherAssetDamageDetail_20200909 |
AliasName | PGE PSPS Event Other Asset Damage Detail 20200909 |
HasAttachments | false |
Description | PGE_PspsEventOtherAssetDamageDetail_20200909 |
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 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 Points” feature class. | | | true | | |
DateofDamage | Date | 8 | Date of Damage | Date or estimated date damage occurred in YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
EstimatedTimeofDamage | Date | 8 | Time of Damage | Estimated time damage occurred. Must be in the “hh:mm:ss” format. | | | 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 tables. | | | 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: Down guy, Neutral, Service neutral, Span guy, Tie wire, Wood pin, Anchor, Other – See comment. | PspsOtherAsset | | true | | |
AssetComment | String | 30 | Asset Comment | Asset not listed in the options above. | | | true | | |
FeederID | String | 50 | Circuit ID | Circuit/feeder ID for the damaged span of line. Foreign to the related asset line tables. | | | 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 | | |
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. 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 IOU 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. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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. Use -99 for unknown. | | | true | | |
ExemptionStatus | String | 10 | Exemption Status | Is the asset exempt per California Public Resources Code (PRC) 4292? PRC 4292 requires clearance around support structures on which certain equipment is mounted in certain areas. Possible values: Yes, No, Unknown, N/A | ExemptionStatus | | true | | |
LikelyArcing | String | 10 | Likely Arcing | Was arcing likely because of the damage? Possible values: Yes, No, Unknown | YesNoUnknown | | true | | |
DamageType | String | 30 | Damage Type | Type of damage sustained. Possible values: Asset damage, Asset failure, Equipment damage, Equipment failure, Veg contact, Object contact | DamageType | | 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. | OtherAssetDamageDescription | | 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_20200909 - Table
Name | PGE_PspsEventSupportStructureDamageDetail_20200909 |
AliasName | PGE PSPS Event Support Structure Damage Detail 20200909 |
HasAttachments | false |
Description | PGE_PspsEventSupportStructureDamageDetail_20200909 |
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 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 Points” feature class. | | | true | | |
DateofDamage | Date | 8 | Date of Damage | Date or estimated date damage occurred in YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
EstimatedTimeofDamage | Date | 8 | Time of Damage | Estimated time damage occurred. Must be in the “hh:mm:ss” format. | | | 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 tables. | | | 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. | PspsAsset | | true | | |
AssetComment | String | 30 | Asset Comment | Asset not listed in the options above. | | | true | | |
FeederID | String | 50 | Circuit ID | Circuit/feeder ID for the damaged span of line. Foreign to the related asset line tables. | | | 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 | | |
SupportStructureMaterial | String | 30 | Support Structure Material | Material of which support structure is made. Possible values: Wood, Metal, Composite, Wrapped wood, Concrete, Other – See comment. | SupportStructureMaterial | | true | | |
MaterialComment | String | 30 | Material Comment | Support structure material not listed in the options above. | | | true | | |
ManufacturerModelID | String | 50 | Manufacturer Mode lID | The manufacturer and asset model specifications that would enable one to identify exactly what type of equipment was involved with the damage. 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 IOU 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. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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. Use -99 for unknown. | | | true | | |
LikelyArcing | String | 10 | Likely Arcing | Was arcing likely because of the damage? Possible values: Yes, No, Unknown | YesNoUnknown | | true | | |
DamageType | String | 30 | Damage Type | Type of damage sustained. Possible values: Asset damage, Asset failure, Equipment damage, Equipment failure, Veg contact, Object contact | DamageType | | 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. | SupportStructureDamageDescription | | 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_20200909 - Table
Name | PGE_RiskEventAssetLog_20200909 |
AliasName | PGE Risk Event Asset Log 20200909 |
HasAttachments | false |
Description | PGE_RiskEventAssetLog_20200909 |
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 table. | | | true | | |
WireDownID | String | 50 | Wire Down ID | Foreign key to the Wire Down Event table. | | | true | | |
FromDevice | String | 50 | From Device | The AssetID of the upstream structure 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 tables. | | | true | | |
ToDevice | String | 50 | To Device | 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 tables. | | | true | | |
IgnitionID | String | 50 | Ignition ID | Foreign key to the Ignition 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 table. | | | true | | |
ToutageID | String | 50 | Transmission Outage ID | Foreign key to the Transmission Outages table. | | | true | | |
TvmOutageID | String | 50 | Transmission VM Outage ID | The unique ID for outage caused by vegetation. Foreign key to the Transmission Vegetation Management Outage table. | | | true | | |
DoutageID | String | 50 | Distribution Outage ID | Foreign key to the Distribution Outages table. | | | true | | |
DvmOutageID | String | 50 | Distribution VM Outage ID | The unique ID for outage caused by vegetation. Foreign key to the Distribution Vegetation Management Outage 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 damage which initiated the outage. Should be traceable within a specific asset class. Foreign key to all the associated asset point tables. | | | true | | |
AssetID | String | 50 | Asset ID | Unique ID for asset point tables. Must be traceable stable ID within a specific asset class. Foreign key to all the associated asset point 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 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 table. | | | true | | |
PGE_RiskEventPhotoLog_20200909 - Table
Name | PGE_RiskEventPhotoLog_20200909 |
AliasName | PGE Risk Event Photo Log 20200909 |
HasAttachments | false |
Description | PGE_RiskEventPhotoLog_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
PhotoID | String | 100 | Photo ID | Illustration of the initiative or inspection activity. Primary key for the Risk Event Photo Log table. Photo format: Geotagged JPEG or PNG. Use format UtilityName_DistrictID_InspectorInitial_RiskEvent_YYYYMMDD_PhotoNumber. For example, “UtilityG+E_AB_Ignition_20200703_1.png”. If more than one photo is taken, enter additional photo IDs with the duplicate risk event ID. | | | true | | |
IgnitionID | String | 50 | Ignition ID | “UtilityG+E_AB_Ignition_20200703_1.png”. If more than one photo is taken, enter additional photo IDs with the duplicate risk event ID. | | | true | | |
WireDownID | String | 50 | Wire Down ID | Foreign key to the Wire Down Event table. | | | true | | |
PGE_SupportStructureCrossarmDetail_20200909 - Table
Name | PGE_SupportStructureCrossarmDetail_20200909 |
AliasName | PGE Support Structure Crossarm Detail 20200909 |
HasAttachments | false |
Description | PGE_SupportStructureCrossarmDetail_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
AssetID | String | 50 | Asset ID | Unique ID for a specific support structure crossarm. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Support Structure Crossarm Detail table. | | | true | | |
SupportStructureID | String | 50 | Support Structure ID | Unique ID for specific support structure. It should be a traceable stable ID within the utility’s operations/processes. Foreign key enabling connection to the “Support Structures” feature class. | | | true | | |
UtilityID | String | 10 | Utility ID | Standardized identification name of the utility (“UtilityG+E,” etc.). | | | true | | |
AssetType | String | 10 | Asset Type | Type of point asset. Required value: Crossarm | | | 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 | | |
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 tables. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name of circuit associated with asset. | | | true | | |
LastInspectionDate | Date | 8 | Last Inspection Date | Date of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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 | | |
CrossarmConfiguration | String | 30 | Crossarm Configuration | Configuration of crossarm. Possible values: Single Arm, Double Arm, Alley Arm | CrossarmConfiguration | | true | | |
CrossarmLength | Single | 4 | Crossarm Length (inches) | Length of crossarm in inches. | | | true | | |
CrossarmWidth | Single | 4 | Crossarm Width (inches) | Width of crossarm in inches. | | | true | | |
CrossarmHeight | Single | 4 | Crossarm Height (inches) | Height of crossarm in inches. | | | true | | |
CrossarmMaterial | String | 30 | Crossarm Material | Material from which pole, tower, or crossarm is made. Possible values: Wood, Metal, Composite, Other – See comment. | CrossarmMaterial | | true | | |
CrossarmMaterialComment | String | 30 | Crossarm Material Comment | Crossarm material not listed in the options above. | | | true | | |
CrossarmMaterialSubtype | String | 30 | Crossarm Material Subtype | The subtype of structure material. For example, if a wood pole, the type of wood (i.e. Douglas Fir, Cedar, etc.). | | | true | | |
BraceType | String | 30 | Brace Type | The type of brace supporting the crossarm. Possible values: V brace, Flat brace, Other – See comment. | BraceType | | true | | |
BraceTypeComment | String | 30 | Brace Type Comment | Brace type not listed in the options above. | | | true | | |
CrossarmOrientation | String | 10 | Crossarm Orientation | Orientation of crossarm. Possible values: In-line, Buck | CrossarmOrientation | | true | | |
Balance | String | 30 | Balance | Balancing status of crossarm. Possible values: Balanced, Unbalanced (i.e., end of line) | Balance | | true | | |
PGE_TransformerDetail_20200909 - Table
Name | PGE_TransformerDetail_20200909 |
AliasName | PGE Transformer Detail 20200909 |
HasAttachments | false |
Description | PGE_TransformerDetail_20200909 |
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 Transformer Detail table. | | | true | | |
TransformerID | String | 50 | Transformer ID | Unique ID for a specific transformer. It should be a traceable stable ID within the utility’s operations/processes. Foreign key enabling connection to the “Transformer” feature class. | | | 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 | TransformerSubtype | | true | | |
AssociatedNominalVoltagekV | Single | 4 | Associated Nominal Voltage (kV) | Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. | | | 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 | | |
SubstationID | String | 50 | Substation ID | ID of substation associated with asset. Foreign Key to the Substation table. | | | true | | |
SubstationName | String | 50 | Substation Name | Name of substation associated with asset. | | | 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 tables. | | | true | | |
CircuitName | String | 255 | Circuit Name | Name of circuit associated with asset. | | | true | | |
MakeandManufacturer | String | 50 | Make and Manufacturer | What is the make and manufacturer of the asset? 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. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
LastMaintenanceDate | Date | 8 | Last Maintenance Date | Date of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InstallationDate | Date | 8 | Installation Date | Date the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | 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) | EstimatedAge | | 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 | | |
ExemptionStatus | String | 30 | Exemption Status | Is the asset exempt per California Public Resources Code (PRC) 4292? PRC 4292 requires clearance around support structures on which certain equipment is mounted in certain areas. Possible values: Yes, No, Unknown, N/A | ExemptionStatus | | true | | |
TransformerRating | Single | 4 | Transformer Rating (kVAs) | Nominal electrical load capacity in kilovolt amps (kVAs). | | | true | | |
PGE_VegetationManagementInspectionLog_20200909 - Table
Name | PGE_VegetationManagementInspectionLog_20200909 |
AliasName | PGE Vegetation Management Inspection Log 20200909 |
HasAttachments | false |
Description | PGE_VegetationManagementInspectionLog_20200909 |
Field | DataType | Length | AliasName | Description | Domain | DefaultValue | IsNullable | Precision | Scale |
VmiLogID | String | 50 | VMI Log ID | Unique ID or job ID of a vegetation management inspection activity. Primary key for the Vegetation Management Inspection Log table. | | | true | | |
VmpLogID | String | 50 | VMP Log ID | Unique ID or job ID of of a vegetation management project resulting from a vegetation management inspection. A Foreign key to the Vegetation Management Project table. | | | true | | |
InspectionDate | Date | 8 | Inspection Date | The date when a vegetation management inspection was or will be conducted. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
InpsectorName | String | 50 | Inpsector Name | Inspector performing the vegetation management inspection. | | | true | | |
InspectionType | String | 100 | Inspection Type | Initiative activities related to the vegetation management project which include, Assessing trees with the potential to strike. Clearances – routine, Clearances – enhanced, Hazard trees, Tree mortality, Other – See comment | VmInspectionType | | true | | |
InspectionTypeComment | String | 100 | Inspection Type Comment | Inspection type description not listed in the options above. | | | true | | |
InspectionStatus | String | 30 | Inspection Status | The status of the initiative activity related to the vegetation inspection project which include, Planned, In-progress, Complete | VmiStatus | | true | | |
InspectionQA | String | 3 | Inspection QA | Has the inspection been checked for quality assurance? Possible values: Yes, No | YesNo | | true | | |
TreeTrimmingCount | Integer | 4 | Tree Trimming Count | The number of trees identified for trimming from the vegetation management inspection. | | | true | | |
TreeTrimmingAcreage | Single | 4 | Tree Trimming Acreage | The acreage of trees identified for trimming from the vegetation management inspection. Two decimal places | | | true | | |
InspectionComment | String | 100 | Inspection Comment | Additional comments regarding the vegetation inspection project. | | | true | | |
InspectionMethod | String | 100 | Inspection Method | Inspection methods which include, Ground inspection, Aerial – drone, Aerial – helicopter, Remote sensing – satellite imagery, Remote sensing – LiDAR, Other – See comment | InspectionMethod | | 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 | InspectionTechnology | | true | | |
InspectionTechnologyComment | String | 30 | Inspection Technology Comment | Inspection technology description not listed in the options above. | | | true | | |
PGE_VegetationManagementProjectLog_20200909 - Table
Name | PGE_VegetationManagementProjectLog_20200909 |
AliasName | PGE Vegetation Management Project Log 20200909 |
HasAttachments | false |
Description | PGE_VegetationManagementProjectLog_20200909 |
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 table. | | | true | | |
DateStart | Date | 8 | Date Start | The completion date of the vegetation management project. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
DateEnd | Date | 8 | Date End | The completion date of the vegetation management project. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time. | | | true | | |
VmpStatus | String | 30 | Vegetation Management Project Status | Status of the vegetation management project. Possible Values: Complete, In progress, Planned, Delayed, Cancelled | VmpStatus | | true | | |
VmpStatusComments | String | 30 | Vegetation Management Project Status Comments | Additional comments regarding the status of the vegetation management project. | | | true | | |
PersonInCharge | String | 50 | Person In Charge | Name of the person in charge for the vegetation management project. | | | true | | |
CoastalRedwoodExemption | String | 3 | Coastal Redwood Exemption | Coastal redwood exception to clearance being applied. Possible values: Yes, No | YesNo | | true | | |
EncroachPermit | String | 3 | Encroach Permit | Is an encroachment permit required for the vegetation management project? Possible values: Yes, No | YesNo | | true | | |
EnvPermit | String | 3 | Environmental Permit | Is special environmental permitting needed for the vegetation management project? Possible values: Yes, No | YesNo | | true | | |
EnvPermitProject | String | 100 | Environmental Permit Project | Specific activity (e.g., timber harvest under an exemption) for which a permit was obtained. | | | true | | |
EnvPermitDocumentation | String | 50 | Environmental Permit Documentation | Include any key details about environmental permit documentation and project ID numbers. For example, 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). | | | true | | |
BMPApply | String | 3 | Best Management Practice Apply | Do best management practices apply for the vegetation management project? Possible values: Yes, No | YesNo | | true | | |
AMMApply | String | 3 | Avoidance and Minimization Measures Apply | Do avoidance and minimization measures apply to the vegetation management project? Possible values: Yes, No | YesNo | | true | | |
WoodManagement | String | 3 | Wood Management | Is wood management needed for the vegetation management project? Possible values: Yes, No | YesNo | | true | | |
WoodManagementComments | String | 100 | Wood Management Comments | Additional comments regarding wood management needs for the vegetation management project. | | | true | | |
LandDesignation | String | 50 | Land Designation | 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) | LandDesignation | | true | | |
RiparianArea | String | 3 | Riparian Area | Is the vegetation management project located in a riparian area? Possible values: Yes, No | YesNo | | true | | |
CaltransProp | String | 3 | Caltrans Property | Is the vegetation management project located on Caltrans property? Possible values: Yes, No | YesNo | | true | | |
ProjectCategory | String | 50 | Project Category | High-level category describing the nature of the vegetation management project. Possible values: Tree trimming, Tree removal, Fuel management, Assessing trees with the potential to strike, Other – See comment. | ProjectCategory | | true | | |
ProjectCategoryComment | String | 50 | Project Category Comment | Project category description not listed in the options above. | | | true | | |
TreeTrimCount | Integer | 4 | Tree Trim Count | Number of trees listed for trimming in the vegetation management project. | | | true | | |
TreeTrimAcreage | Single | 4 | Tree Trim Acreage | Acreage of trees listed for trimming in the vegetation management project. Two decimal places | | | true | | |
TreeRemovalCount | Integer | 4 | Tree Removal Count | Number of trees listed for removal in the vegetation management project. | | | true | | |
TreeRemovalAcreage | Single | 4 | Tree Removal Acreage | Acreage of trees listed for removal in the vegetation management project. Two decimal places | | | true | | |
TreeTrimCountActl | Integer | 4 | Tree Trim Count Actually | Number of trees actually trimmed as part of the vegetation management project. | | | true | | |
TreeTrimAcreageActl | Single | 4 | Tree Trim Acreage Actually | Acreage of trees actually trimmed as part of the in the vegetation management project. Two decimal places | | | true | | |
TreeRemovalCountActl | Integer | 4 | Tree Removal Count Actually | Number of trees actually removed as part of the vegetation management project. | | | true | | |
TreeRemovalAcreageActl | Single | 4 | Tree Removal Acreage Actually | Acreage of trees actually removed as part of the vegetation management project. Two decimal places | | | true | | |
VegetationTreatmentType | String | 50 | Vegetation Treatment Type | The type(s) of treatment scoped into 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. | VegetationTreatmentType | | 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 | | |
DescriptionOfWork | String | 100 | Description Of Work | Additional description of the vegetation management work. | | | true | | |
AssetClass - Domain
DomainName | AssetClass |
Description | Is the asset associated with transmission or distribution? |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Transmission | Transmission |
Distribution | Distribution |
BackupType - Domain
DomainName | BackupType |
Description | Type of backup power source. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Storage battery | Storage battery |
Diesel generator | Diesel generator |
Gas generator | Gas generator |
Combined/hybrid | Combined/hybrid |
Other | Other |
Balance - Domain
DomainName | Balance |
Description | Balancing status of crossarm. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Balanced | Balanced |
Unbalanced | Unbalanced |
Brace Type - Domain
DomainName | Brace Type |
Description | The type of brace supporting the crossarm. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
V brace | V brace |
Flat brace | Flat brace |
Other | Other |
BraceType - Domain
DomainName | BraceType |
Description | The type of brace supporting the crossarm. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
V brace | V brace |
Flat brace | Flat brace |
Other | Other |
CircuitType - Domain
DomainName | CircuitType |
Description | Circuit line type. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Transmission Line | Transmission Line |
Primary Distribution Line | Primary Distribution Line |
Secondary Distribution Line | Secondary Distribution Line |
Unknown | Unknown |
ConductorMaterial - Domain
DomainName | ConductorMaterial |
Description | Conductor material. |
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) |
Copper (Cu) | Copper (Cu) |
Other | Other |
ConductorType - Domain
DomainName | ConductorType |
Description | Type of conductor. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Bare | Bare |
Covered | Covered |
Unknown | Unknown |
ConductorTypeSecondary - Domain
DomainName | ConductorTypeSecondary |
Description | Type of conductor for secondary distribution. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Open wire | Open wire |
Triplex | Triplex |
Other | Other |
ConnectionDeviceSubtype - Domain
DomainName | ConnectionDeviceSubtype |
Description | What is the specific subtype of the connection device? |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Crimp Splice | Crimp Splice |
Automatic Splice | Automatic Splice |
Explosive Sleeve Splice | Explosive Sleeve Splice |
3-bolt | 3-bolt |
Parallel Groove | Parallel Groove |
Unknown | Unknown |
Other | Other |
ConnectionDeviceType - Domain
DomainName | ConnectionDeviceType |
Description | What type of connection device is the asset? |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Splice | Splice |
Connector | Connector |
Clamp | Clamp |
Other | Other |
Unknown | Unknown |
ConnectionOHUG - Domain
DomainName | ConnectionOHUG |
Description | Is the connection overhead or underground? |
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 |
ConnectionType - Domain
DomainName | ConnectionType |
Description | Type of energy transfer happening at location. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Private to corporation | Private to corporation |
Corporation to private | Corporation to private |
ConstructionGrade - Domain
DomainName | ConstructionGrade |
Description | Grade of construction, in accordance with GO 9, Rule 42 |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Grade A | Grade A |
Grade B | Grade B |
Grade C | Grade C |
ContributingFactor - Domain
DomainName | ContributingFactor |
Description | Factors suspected as contributing to the ignition. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Weather | Weather |
External Force | External Force |
Human Error | Human Error |
Other | Other |
Unknown | Unknown |
CrossarmConfiguration - Domain
DomainName | CrossarmConfiguration |
Description | Configuration of crossarm |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Single Arm | Single Arm |
Double Arm | Double Arm |
Alley Arm | Alley Arm |
CrossarmMaterial - Domain
DomainName | CrossarmMaterial |
Description | Material from which pole, tower, or crossarm is made. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Wood | Wood |
Metal | Metal |
Composite | Composite |
Other | Other |
CrossarmOrientation - Domain
DomainName | CrossarmOrientation |
Description | Orientation of crossarm. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
In-line | In-line |
Buck | Buck |
DamageDescription - Domain
DomainName | DamageDescription |
Description | Description of damage. |
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 | Other |
DamageType - Domain
DomainName | DamageType |
Description | Type of damage sustained. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Asset damage | Asset damage |
Asset failure | Asset failure |
Equipment damage | Equipment damage |
Equipment failure | Equipment failure |
Veg contact | Veg contact |
Object contact | Object contact |
Determination - Domain
DomainName | Determination |
Description | The entity relied upon to make the determination of SuspectedInitiatingEvent. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Utility personnel | Utility personnel |
Fire Agency | Fire Agency |
Other | Other |
Equiment Failure - Domain
DomainName | Equiment Failure |
Description | Description of failed or damaged equipment or component. |
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 arrestor | Lightning arrestor |
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 |
Other | Other |
N/A | N/A |
EquipmentType - Domain
DomainName | EquipmentType |
Description | The type of equipment involved in the ignition event. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Overhead | Overhead |
Pad-mounted | Pad-mounted |
Subsurface | Subsurface |
EstimatedAge - Domain
DomainName | EstimatedAge |
Description | The age of the asset in years. |
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 |
EventCause - Domain
DomainName | EventCause |
Description | High-level category for event cause. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Object contact | Object contact |
Equipment failure | Equipment failure |
Wire-to-wire contact | Wire-to-wire contact |
Contamination | Contamination |
Utility work/Operation | Utility work/Operation |
Vandalism/Theft | Vandalism/Theft |
Unknown | Unknown |
Other | Other |
ExemptionStatus - Domain
DomainName | ExemptionStatus |
Description | Is the asset exempt per California PRC 4292 |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Yes | Yes |
No | No |
Unknown | Unknown |
N/A | N/A |
FacilityCategory - Domain
DomainName | FacilityCategory |
Description | Critical facility category. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Chemical | Chemical |
Communications | Communications |
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 | Other |
FacilityContacted - Domain
DomainName | FacilityContacted |
Description | The first facility that was contacted by an outside object. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Electric Facility | Electric Facility |
Pole | Pole |
Communication Facility | Communication Facility |
FireDetectionMethod - Domain
DomainName | FireDetectionMethod |
Description | The method by which the utility first learned of the ignition event. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Public | Public |
Satellite | Satellite |
Camera | Camera |
Utility staff | Utility staff |
Fire agency | Fire agency |
Other | Other |
FireInvestigation - Domain
DomainName | FireInvestigation |
Description | Whether the fire authority having jurisdiction investigated the ignition and the status of the investigation. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Yes – Complete | Yes – Complete |
Yes – Pending | Yes – Pending |
No | No |
FireSize - Domain
DomainName | FireSize |
Description | Size, in acres unless otherwise indicated, of fire resulting from the ignition. |
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 |
100-299 | 100-299 |
300-999 | 300-999 |
1,000-4,999 | 1,000-4,999 |
>5,000 | >5,000 |
Unknown | Unknown |
FuelBedDescription - Domain
DomainName | FuelBedDescription |
Description | Type of fuel bed existing under damage location. |
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 | Other |
FuseAssetType - Domain
DomainName | FuseAssetType |
Description | Type of fuse device |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Bridged | Bridged |
Current limiting | Current limiting |
Expulsion | Expulsion |
Fused elbow | Fused elbow |
Unknown | Unknown |
Other | Other |
GhChangeOrderType - Domain
DomainName | GhChangeOrderType |
Description | The type of change order requested. |
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 | Other change |
GhStatus - Domain
DomainName | GhStatus |
Description | The status of the grid hardening activity. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Planned | Planned |
In progress | In progress |
Complete | Complete |
Cancelled | Cancelled |
HFTD - Domain
DomainName | HFTD |
Description | The CPUC high-fire threat district area the asset intersects. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Tier 3 | Tier 3 |
Tier 2 | Tier 2 |
Zone 1 | Zone 1 |
Non-HFTD | Non-HFTD |
InitiativeActivity - Domain
DomainName | InitiativeActivity |
Description | Initiative activities related to the grid hardening project. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Capacitor maintenance and replacement | Capacitor maintenance and replacement |
Circuit breaker maintenance and installation | Circuit breaker maintenance and installation |
Conductor replacement | Conductor replacement |
Covered conductor installation | Covered conductor installation |
Covered conductor maintenance | Covered conductor maintenance |
Crossarm maintenance, repair, and replacement | Crossarm maintenance, repair, and replacement |
Expulsion fuse replacement | Expulsion fuse replacement |
Grid topology improvements to mitigate or reduce PSPS events | Grid topology improvements to mitigate or reduce PSPS events |
Installation of system automation equipment | Installation of system automation equipment |
Installation of sectionalizing equipment | Installation of sectionalizing equipment |
Maintenance, repair, and replacement of connectors, including hotline clamps | Maintenance, repair, and replacement of connectors, including hotline clamps |
Other corrective action | Other corrective action |
Pole replacement | Pole replacement |
Pole reinforcement | Pole reinforcement |
Transformer maintenance and replacement | Transformer maintenance and replacement |
Transmission tower maintenance and replacement | Transmission tower maintenance and replacement |
Undergrounding of electric lines and/or equipment | Undergrounding of electric lines and/or equipment |
Other | Other |
InspectionMethod - Domain
DomainName | InspectionMethod |
Description | The method by which the asset inspection was conducted. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Drive by | Drive by |
Walk out | Walk out |
Aerial – drone | Aerial – drone |
Aerial – helicopter | Aerial – helicopter |
Remote sensing – Infrared/Thermal | Remote sensing – Infrared/Thermal |
Remote sensing – LiDAR | Remote sensing – LiDAR |
Other | Other |
InspectionTechnology - Domain
DomainName | InspectionTechnology |
Description | The technology that an inspector uses for the vegetation management inspection. |
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 | Other |
None | None |
InspectionType - Domain
DomainName | InspectionType |
Description | The type of asset inspection performed. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Patrol | Patrol |
Detailed | Detailed |
Pole loading | Pole loading |
Other | Other |
IsolationDevice - Domain
DomainName | IsolationDevice |
Description | The device which isolated the circuit during the PSPS event. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Circuit Breaker | Circuit Breaker |
Fuse | Fuse |
Switch | Switch |
Other | Other |
IsolationDeviceType - Domain
DomainName | IsolationDeviceType |
Description | Type of protective device that operated. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Circuit Breaker | Circuit Breaker |
Fuse | Fuse |
Lightning Arrestor | Lightning Arrestor |
Switch | Switch |
Other | Other |
LandDesignation - Domain
DomainName | LandDesignation |
Description | The assigned designation of the land where the subject vegetation management project is scheduled. |
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) |
MaterialAtOrigin - Domain
DomainName | MaterialAtOrigin |
Description | Fuel material for the ignition origin. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Vegetation | Vegetation |
Structure | Structure |
Other | Other |
ObjectContact - Domain
DomainName | ObjectContact |
Description | Description of object involved in the contact. |
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 |
N/A | N/A |
OhUg - Domain
DomainName | OhUg |
Description | Is the asset overhead or underground? |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Overhead | Overhead |
Underground | Underground |
Unknown | Unknown |
OriginLandUse - Domain
DomainName | OriginLandUse |
Description | Status of land at origin of ignition. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Rural | Rural |
Urban | Urban |
OtherAssetDamageDescription - Domain
DomainName | OtherAssetDamageDescription |
Description | Description of damage. |
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 | Other |
OutageInterval - Domain
DomainName | OutageInterval |
Description | Indication of whether the subject outage was momentary or sustained |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Momentary | Momentary |
Sustained | Sustained |
PerformedBy - Domain
DomainName | PerformedBy |
Description | Who performed the asset inspection? |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Utility staff | Utility staff |
Contractor | Contractor |
Other | Other |
ProjectCategory - Domain
DomainName | ProjectCategory |
Description | High-level category describing the nature of the vegetation management project. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Tree trimming | Tree trimming |
Tree removal | Tree removal |
Fuel management | Fuel management |
Assessing trees with the potential to strike | Assessing trees with the potential to strike |
Other | Other |
PspsAsset - Domain
DomainName | PspsAsset |
Description | Specific type of asset that is damaged. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Pole | Pole |
Tower | Tower |
Crossarm | Crossarm |
Secondary arms | Secondary arms |
Other | Other |
PspsOtherAsset - Domain
DomainName | PspsOtherAsset |
Description | Specific type of asset that is damaged. |
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 | Other |
RecloserSetting - Domain
DomainName | RecloserSetting |
Description | If the subject circuit is equipped with reclosing capabilities, indicate whether the reclose function was enabled or disabled at the time of the outage. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Enabled | Enabled |
Disabled | Disabled |
N/A | N/A |
SpeciesGrowthRate - Domain
DomainName | SpeciesGrowthRate |
Description | Generalized growth rate of the subject tree species. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Slow growing | Slow growing |
Moderately growing | Moderately growing |
Fast growing | Fast growing |
SubareaType - Domain
DomainName | SubareaType |
Description | Utility subarea type. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Operational | Operational |
Construction | Construction |
Weather | Weather |
Organizational | Organizational |
Other | Other |
SubstationType - Domain
DomainName | SubstationType |
Description | Type of substation |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Network | Network |
Loop | Loop |
Radial | Radial |
SupportStructureDamageDescription - Domain
DomainName | SupportStructureDamageDescription |
Description | Description of damage for support structure. |
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 | Other |
SupportStructureMaterial - Domain
DomainName | SupportStructureMaterial |
Description | Material from which pole, tower, or crossarm is made |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Wood | Wood |
Metal | Metal |
Composite | Composite |
Wrapped wood | Wrapped wood |
Concrete | Concrete |
Other | Other |
SupportStructureType - Domain
DomainName | SupportStructureType |
Description | Type of support structure |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Pole | Pole |
Tower | Tower |
Other | Other |
SuppressedBy - Domain
DomainName | SuppressedBy |
Description | Entity responsible for suppressing ignition. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Customer | Customer |
Fire agency | Fire agency |
Self-extinguished | Self-extinguished |
Utility | Utility |
Unknown | Unknown |
SuspectedCause - Domain
DomainName | SuspectedCause |
Description | High-level category for wire down event cause. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Object contact | Object contact |
Equipment failure | Equipment failure |
Wire-to-wire contact | Wire-to-wire contact |
Contamination | Contamination |
Utility work/Operation | Utility work/Operation |
Vandalism/Theft | Vandalism/Theft |
Unknown | Unknown |
Other | Other |
TransformerSubtype - Domain
DomainName | TransformerSubtype |
Description | Specific subtype of the transformer. |
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 |
Three phase pad-mounted | Three phase pad-mounted |
Three phase subsurface | Three phase subsurface |
Three phase overhead | Three phase overhead |
VegetationTreatmentType - Domain
DomainName | VegetationTreatmentType |
Description | The type(s) of treatment scoped into the vegetation management project. |
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 | Other or multiple treatment types |
VmInspectionType - Domain
DomainName | VmInspectionType |
Description | Initiative activities related to the vegetation management project. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Assessing trees with the potential to strike | Assessing trees with the potential to strike |
Clearances – routine | Clearances – routine |
Clearances – enhanced | Clearances – enhanced |
Hazard trees | Hazard trees |
Tree mortality | Tree mortality |
Other | Other |
VmiStatus - Domain
DomainName | VmiStatus |
Description | Status of the vegetation management project. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Planned | Planned |
In progress | In progress |
Complete | Complete |
VmpStatus - Domain
DomainName | VmpStatus |
Description | Status of the vegetation management project. |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Complete | Complete |
In progress | In progress |
Planned | Planned |
Delayed | Delayed |
Cancelled | Cancelled |
YesNo - Domain
DomainName | YesNo |
Description | Yes or No |
FieldType | String |
Domain Type | CodedValue |
YesNoNA - Domain
DomainName | YesNoNA |
Description | Yes, No or N/A |
FieldType | String |
Domain Type | CodedValue |
YesNoUnknown - Domain
DomainName | YesNoUnknown |
Description | Yes, No, or Unknown |
FieldType | String |
Domain Type | CodedValue |
Code | Name |
|
Yes | Yes |
No | No |
Unknown | Unknown |