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

NamePGE_AssetLine
DescriptionPGE_AssetLine

PGE_PrimaryDistributionLine_20200909 - FeatureClass

NamePGE_PrimaryDistributionLine_20200909
ShapeTypePolyline
FeatureTypeSimple
AliasNamePGE Primary Distribution Line 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_PrimaryDistributionLine_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
CircuitIDString50Circuit IDUnique 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
UtilityIDString30Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
LineClassString30Line ClassClassification of line asset. Required value: Primary distributiontrue
CircuitNameString255Circuit NameName of circuit associated with asset.true
CountyString150CountyCounty in which asset is located. If the line crosses multiple counties, list all counties separated by commas.true
ConductorTypeString10Conductor TypeType of conductor. Possible values: Bare, Covered, UnknownConductorTypetrue
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, UnknownOhUgtrue
NominalVoltagekVSingle4Nominal Voltage (kV)Nominal voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
OperatingVoltagekVSingle4Operating Voltage (kV)Operating voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation table.true
SubstationNameString50Substation NameName of substation associated with asset.true
ConductorMaterialString50Conductor MaterialConductor material. Possible values: All aluminum conductor (AAC), All aluminum alloy, conductor (AAAC), Aluminum conductor aluminum reinforced (ACAR), Aluminum conductor steel, reinforced (ACSR), Copper (Cu), Other – See comment.ConductorMaterialtrue
ConductorMaterialCommentString50Conductor Material CommentConductor material not listed in the options above.true
ConductorSizeString30Conductor SizeSize of conductor (e.g. No. 4 Cu or 1/0 ACSR).true
ConductorODSingle4Conductor Overall Diameter (inches)Overall diameter of the conductor in inches.true
ConductorCodeNameString30Conductor Code NameCodename of the conductor. For example, “Lapwing,” “Sparrow,” etc.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
AmpacityRatingSingle4Ampacity Rating (A)Nominal ampacity rating of the conductor, in amperes).true
GreasedString10GreasedIs the conductor greased to prevent water intrusion? Possible values: Yes, No, UnknownYesNoUnknowntrue


PGE_SecondaryDistributionLine_20200909 - FeatureClass

NamePGE_SecondaryDistributionLine_20200909
ShapeTypePolyline
FeatureTypeSimple
AliasNamePGE Secondary Distribution Line 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_SecondaryDistributionLine_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
CircuitIDString50Circuit IDUnique 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
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
LineClassString30Line ClassClassification of line asset. Required value: Secondary distributiontrue
CircuitNameString255Circuit NameName of circuit associated with asset. This name is expected to be based on the circuit name of the secondary line’s associated primary distribution line.true
CountyString150CountyCounty in which asset is located. If the line crosses multiple counties, list all counties separated by commas.true
ConductorTypeString30Conductor TypeType of conductor. Possible values: Open wire, Triplex, Other – See comment.ConductorTypeSecondarytrue
ConductorTypeCommentString30Conductor Type CommentConductor type not listed in the options above.true
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, UnknownOhUgtrue
NominalVoltagekVSingle4Nominal Voltage (kV)Nominal voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
OperatingVoltagekVSingle4Operating Voltage (kV)Operating voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation table.true
SubstationNameString50Substation NameName of substation associated with asset.true
ConductorMaterialString50Conductor MaterialConductor material. Possible values: All aluminum conductor (AAC), All aluminum alloy, conductor (AAAC), Aluminum conductor aluminum reinforced (ACAR), Aluminum conductor steel, reinforced (ACSR), Copper (Cu), Other – See comment.ConductorMaterialtrue
ConductorMaterialCommentString50Conductor Material CommentConductor material not listed in the options above.true
ConductorSizeString30Conductor SizeSize of conductor (e.g. No. 4 Cu or 1/0 ACSR).true
ConductorODSingle4Conductor Overall Diameter (inches)Overall diameter of the conductor in inches.true
ConductorCodeNameString30Conductor Code NameCodename of the conductor. For example, “Lapwing,” “Sparrow,” etc.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
AmpacityRatingSingle4Ampacity Rating (A)Nominal ampacity rating of the conductor, in amperes).true
GreasedString10GreasedIs the conductor greased to prevent water intrusion? Possible values: Yes, No, UnknownYesNoUnknowntrue


PGE_TransmissionLine_20200909 - FeatureClass

NamePGE_TransmissionLine_20200909
ShapeTypePolyline
FeatureTypeSimple
AliasNamePGE Transmission Line 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_TransmissionLine_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
CircuitIDString50Circuit IDUnique 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
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
LineClassString30Line ClassClassification of line asset. Required value: Transmissiontrue
CircuitNameString255Circuit NameName of circuit associated with asset.true
CountyString150CountyCounty in which asset is located. If the line crosses multiple counties, list all counties separated by commas.true
ConductorTypeString30Conductor TypeType of conductor. Possible values: Bare, Covered, UnknownConductorTypetrue
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, UnknownOhUgtrue
NominalVoltagekVSingle4Nominal Voltage (kV)Nominal voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
OperatingVoltagekVSingle4Operating Voltage (kV)Operating voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation table.true
SubstationNameString50Substation NameName of substation associated with asset.true
ConductorMaterialString50Conductor MaterialConductor material. Possible values: All aluminum conductor (AAC), All aluminum alloy, conductor (AAAC), Aluminum conductor aluminum reinforced (ACAR), Aluminum conductor steel, reinforced (ACSR), Copper (Cu), Other – See comment.ConductorMaterialtrue
ConductorMaterialCommentString50Conductor Material CommentConductor material not listed in the options above.true
ConductorSizeString30Conductor Material CommentSize of conductor (e.g. No. 4 Cu or 1/0 ACSR).true
ConductorODSingle4Conductor Overall Diameter (inches)Overall diameter of the conductor in inches.true
ConductorCodeNameString30Conductor Code NameCodename of the conductor. For example, “Lapwing,” “Sparrow,” etc.true
Terminal1String50Terminal 1Substation name of first terminal.true
Terminal2String50Terminal 2Substation name of second terminal.true
Terminal3String50Terminal 3Substation name of third terminal.true
Terminal4String50Terminal 4Substation name of fourth terminal.true
Terminal5String50Terminal 5Substation name of fifth terminal.true
Terminal_s_String50Terminal(s)Substation name of other terminals.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
AmpacityRatingSingle4Ampacity Rating (A)Nominal ampacity rating of the conductor, in amperes).true
GreasedString10GreasedIs the conductor greased to prevent water intrusion? Possible values: Yes, No, UnknownYesNoUnknowntrue



PGE_AssetPoint - FeatureDataset

NamePGE_AssetPoint
DescriptionPGE_AssetPoint

PGE_Camera_20200909 - FeatureClass

NamePGE_Camera_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Camera 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_Camera_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique ID for a specific camera. It should be a traceable stable ID within the utility's operations/processes. Primary key for the Camera table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AssetTypeString10Asset TypeType of point asset. Required value: Cameratrue
MakeandManufacturerString50Make and ManufacturerWhat is the make and manufacturer of the asset? Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString60CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
CameraHeightSingle4Camera Height (feet)Height of camera (in feet) above the ground below it.true
CameraURLString255Camera URLWebsite address for camera video feed (if publicly available).true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees).true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees).true


PGE_ConnectionDevice_20200909 - FeatureClass

NamePGE_ConnectionDevice_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Connection Device 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_ConnectionDevice_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique ID for a specific connection device. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Connection Device table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AssetTypeString50Asset TypeType of point asset. Required value: Line connection devicetrue
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, UnknownOhUgtrue
ConnectionDeviceTypeString30Connection Device TypeWhat type of connection device is the asset? Possible values: Splice, Connector, Clamp, Other – See comment, UnknownConnectionDeviceTypetrue
ConnectionDeviceTypeCommentString30Connection Device Type CommentConnection device type not listed in the options above.true
ConnectionDeviceSubtypeString30Connection Device SubtypeWhat is the specific subtype of the connection device? Automatic Splice, Crimp Splice, Explosive Sleeve Splice (i.e. permanent, fused), 3-bolt, Parallel Groove, Unknown, Other – See comment.ConnectionDeviceSubtypetrue
ConnectionDeviceSubtypeCommentString30Connection Device Subtype CommentConnection device subtype not listed in the options above.true
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
FromStructureIDString50From Structure IDID of the structure upstream of the span of line containing a connection device. This structure may be a support structure (e.g., pole or tower) if the span is overhead, and it may be something else (e.g., manhole, vault, etc.) if the span is underground. Foreign key to the Support Structure table.true
ToStructureIDString50To Structure IDID of the structure upstream of the span of line containing a connection device. This structure may be a support structure (e.g., pole or tower) if the span is overhead, and it may be something else (e.g., manhole, vault, etc.) if the span is underground. Foreign key to the Support Structure table.true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line tables.true
CircuitNameString255Circuit NameName of circuit associated with asset.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation table.true
SubstationNameString50Substation NameName of substation associated with asset.true
MakeandManufacturerString50Make and ManufacturerWhat is the make and manufacturer of the asset? Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
ExemptionStatusString10Exemption StatusIs 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/AExemptionStatustrue
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees).true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees).true


PGE_CustomerMeter_20200909 - FeatureClass

NamePGE_CustomerMeter_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Customer Meter 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_CustomerMeter_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
MeterIDString50Meter IDUnique ID for a specific meter. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Customer Meter table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AssetTypeString30Asset TypeType of point asset. Required value: Customer metertrue
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line tables.true
CircuitNameString255Circuit NameName of circuit associated with asset.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign key to the Substation table.true
SubstationNameString30Substation NameName of substation associated with asset.true
MakeandManufacturerString50Make and ManufacturerWhat is the make and manufacturer of the asset? Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString50CountyCounty in which asset is located.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees).true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees).true


PGE_Fuse_20200909 - FeatureClass

NamePGE_Fuse_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Fuse 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_Fuse_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique ID for a specific fuse. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Fuse table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, UnknownOhUgtrue
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4AssociatedOperatingVoltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign Key to the Substation table.true
SubstationNameString50Substation NameName of substation associated with asset.true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line tables.true
CircuitNameString255Circuit NameName of circuit associated with asset.true
MakeandManufacturerString50Make and ManufacturerWhat is the make and manufacturer of the asset? Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
ExemptionStatusString10Exemption StatusIs 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/AExemptionStatustrue
FuseRatingSingle4Fuse Rating (A)The nominal current rating of the fuse in amperes.true
AssetTypeString30Asset TypeType of fuse device. Possible values: Bridged, Current limiting, Expulsion, Fused elbow, Unknown, Other – See comment.FuseAssetTypetrue
AssetTypeCommentString50Asset Type CommentFuse asset type not listed in the options above.true
AssetSubtypeString30Asset SubtypeWhat is the specific subtype of the fuse device?true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees).true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees).true


PGE_LightingArrestor_20200909 - FeatureClass

NamePGE_LightingArrestor_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Lighting Arrestor 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_LightingArrestor_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique 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
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AssetTypeString30Asset TypeType of point asset. Required value: Lightning arrestor.true
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
SupportStructureIDString50Support Structure IDUnique 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
SubstationIDString50Substation IDID of substation associated with asset. Foreign Key to the Substation table.true
SubstationNameString50Substation NameName of substation associated with asset.true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line tables.true
CircuitNameString255Circuit NameName of circuit associated with asset.true
MakeandManufacturerString50Make and ManufacturerWhat is the make and manufacturer of the asset? Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
ExemptionStatusString10Exemption StatusIs 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/AExemptionStatustrue
ArrestorRatingSingle4Arrestor Rating (kV)Rating of the lightning arrestor in kilovolts.true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees).true
AssetLongitudeSingle4AssetLongitudeLongitude coordinate of asset (in decimal degrees).true


PGE_Substation_20200909 - FeatureClass

NamePGE_Substation_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Substation 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_Substation_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
SubstationIDString50Substation IDID of substation associated with asset. Primary key for the Substation table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AssetTypeString30Asset TypeType of point asset. Required value: Substationtrue
SubstationNameString50Substation NameName of substation.true
SubstationNominalVoltagekVSingle4Substation 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
AssociatedOperatingVoltagekVSingle4Associated 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
SubstationRatingSingle4Substation RatingPower rating of the substation in mega volt amps (MVAs).true
SubstationTypeString10Substation TypeType of substation. Possible values: Network, Loop, RadialSubstationTypetrue
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees).true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees).true


PGE_SupportStructure_20200909 - FeatureClass

NamePGE_SupportStructure_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Support Structure 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_SupportStructure_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
SupportStructureIDString50Support Structure IDUnique 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
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AssetTypeString30Asset TypeType of point asset. Required value: Support structuretrue
SubstationIDString50Substation IDID of substation associated with asset. Foreign Key to the Substation table.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LastIntrusiveDateDate8Last Intrusive DateDate of the last intrusive. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
SupportStructureTypeString30Support Structure TypeType of support structure. Possible values: Pole, Tower, Other – See comment.SupportStructureTypetrue
SupportStructureTypeCommentString30Support Structure Type CommentSupport 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
SupportStructureMaterialString30Support Structure MaterialMaterial from which pole, tower, or crossarm is made. Possible values: Wood, Metal, Composite, Wrapped wood, Concrete, Other – See comment.SupportStructureMaterialtrue
SupportStructureMaterialCommentString30Support Structure Material CommentSupport structure material not listed in the options above.true
SupportStructureMaterialSubtypeString30Support Structure Material SubtypeThe subtype of structure material. For example, if a wood pole, the type of wood (i.e. Douglas Fir, Cedar, etc.).true
UnderbuildString3UnderbuildDoes the line support multiple transmission or primary distribution circuits? Possible values: Yes, NoYesNotrue
ConstructionGradeString10Construction GradeGrade of construction, in accordance with GO 95, Rule 42. Possible Values: Grade A, Grade B, Grade CConstructionGradetrue
CrossarmAttachedString10Crossarm AttachedIs one or more crossarms attached to the support structure? Possible values: Yes, No, UnknownYesNoUnknowntrue
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees).true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees).true


PGE_Switchgear_20200909 - FeatureClass

NamePGE_Switchgear_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Switchgear 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_Switchgear_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique ID for a specific switchgear asset. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Switchgear table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AssetTypeString30Asset TypeType of point asset. Required value: Switchgeartrue
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, UnknownOhUgtrue
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
SupportStructureIDString50Support Structure IDUnique ID for support structure to which a switchgear asset is attached. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the Support Structure table.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign Key to the Substation table.true
SubstationNameString50Substation NameName of substation associated with asset.true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line tables.true
CircuitNameString255Circuit NameName of circuit associated with asset.true
MakeandManufacturerString50Make and ManufacturerWhat is the make and manufacturer of the asset? Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
ExemptionStatusString10Exemption StatusIs 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/AExemptionStatustrue
CurrentRatingSingle4Current Rating (A)Nominal current rating of the switchgear in amperes.true
AssetClassString30Asset ClassIs the asset associated with transmission or distribution? Possible values: Distribution, TransmissionAssetClasstrue
SCADAEnabledString3SCADA EnabledCan supervisory control and data acquisition (SCADA) be utilized with the asset? Possible values: Yes, No, N/AYesNoNAtrue
SwitchgearTypeString30Switchgear TypeType of switchgear (switch, cut-out fuse, circuit breaker, etc.)true
SwitchgearSubtypeString30Switchgear SubtypeSpecific type of switch, cut-out fuse, circuit breaker, etc.true
SwitchgearInsulatingMediumString30Switchgear Insulating MediumMedium (air, gas, oil, etc.) providing insulation for switchgear asset. Be specifictrue
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees).true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees).true


PGE_Transformer_20200909 - FeatureClass

NamePGE_Transformer_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Transformer 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_Transformer_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
TransformerIDString50Transformer IDUnique 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
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
SupportStructureIDString50Support Structure IDUnique ID for support structure to which transformer is attached. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the Support Structure table.true
AssetTypeString30Asset TypeType of point asset. Required value: Transformertrue
AssetOHUGString30Asset OH or UGIs the asset overhead or underground? Possible values: Overhead, Underground, UnknownOhUgtrue
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString50CountyCounty in which asset is located.true
InaBankString30Ina BankDoes a single point represent multiple assets that exist in a bank arrangement (i.e., transformer bank)? Possible values: Yes (if multiple transformers are represented by a single point, use additional related tables as needed), No, Unknown, N/AExemptionStatustrue
QuantityinBankInteger4Quantity in BankHow many transformers exist in a bank arrangement (if applicable)? Enter “-99” if unknown.true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees).true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees).true


PGE_WeatherStation_20200909 - FeatureClass

NamePGE_WeatherStation_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Weather Station 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_WeatherStation_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
StationIDString50Station IDThe equivalent to the “Asset ID” field from other feature classes. Station ID for the weather station. It should enable data users to look up the data collected by the weather station. Primary key for the Weather Station table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AssetTypeString30Asset TypeType of point asset. Required field: Weather station.true
MakeandManufacturerString30Make and ManufacturerWhat is the make and manufacturer of the asset? Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString50CountyCounty in which asset is located.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
WeatherStationURLString255Weather Station URLWebsite address for weather station information (if publicly available).true
AssetLatitudeSingle4Asset LatitudeLatitude coordinate of asset (in decimal degrees).true
AssetLongitudeSingle4Asset LongitudeLongitude coordinate of asset (in decimal degrees).true



PGE_Initiative - FeatureDataset

NamePGE_Initiative
DescriptionPGE_Initiative

PGE_AssetInspectionLine_20200909 - FeatureClass

NamePGE_AssetInspectionLine_20200909
ShapeTypePolyline
FeatureTypeSimple
AliasNamePGE Asset Inspection Line 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_AssetInspectionLine_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AiIDString50AI IDUnique ID or job ID of an asset inspection activity. Primary key for the Asset inspection Line table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AiLogIDString50AI Log IDUnique ID or job ID of an asset inspection activity. Foreign key to the Asset inspection table.true
InspectionLocationOrAddressString100Inspection Location Or AddressAddress or location description for the inspection location.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
HFTDClassCommentString50HFTDClassCommentIf the project line intersects multiple HFTD areas, list all of them here.true
CityString50CityCity in where the asset inspection project is located.true
CountyString50CountyCounty in where the asset inspection project is located.true
DistrictString100DistrictOperating district where the asset inspection project occurred.true


PGE_AssetInspectionPoint_20200909 - FeatureClass

NamePGE_AssetInspectionPoint_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Asset Inspection Point 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_AssetInspectionPoint_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AiIDString50AI IDUnique ID or job ID of an asset inspection activity. Primary key for the Asset Inspection Point table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AiLogIDString50AI Log IDUnique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection table.true
InspectionLocationOrAddressString100Inspection Location Or AddressAddress or location description for the inspection location.true
ParcelAPNString17Parcel APNAssessor Parcel Number (APN), a number assigned to parcels of real property by the tax assessor of a particular jurisdiction for purposes of identification and record-keeping. If the asset inspected does not intersect a parcel boundary, enter “N/A” for this field. Use the format: ###-####-###-####. For example, 006-0144-029-0000.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CityString50CityCity in where the asset inspection project is located.true
CountyString50CountyCounty in where the asset inspection project is located.true
DistrictString100DistrictOperating district where the asset inspection project occurred.true
LatitudeSingle4LatitudeLatitude of event point in decimal degreestrue
LongitudeSingle4LongitudeLongitude of event point in decimal degrees.true


PGE_AssetInspectionPolygon_20200909 - FeatureClass

NamePGE_AssetInspectionPolygon_20200909
ShapeTypePolygon
FeatureTypeSimple
AliasNamePGE Asset Inspection Polygon 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_AssetInspectionPolygon_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AiIDString50AI IDUnique ID or job ID of an asset inspection activity. Primary key for the Asset Inspection Polygon table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AiLogIDString50AI Log IDUnique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection table.true
ParcelAPNString17Parcel APNAssessor Parcel Number (APN), a number assigned to parcels of real property by the tax assessor of a particular jurisdiction for purposes of identification and record-keeping. If the asset inspected does not intersect a parcel boundary, enter “N/A” for this field. Use the format: ###-####-###-####. For example, 006-0144-029-0000.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
HFTDClassCommentString50HFTDClassCommentIf the project line intersects multiple HFTD areas, list all of them here.true
CityString50CityCity in where the asset inspection project is located.true
CountyString50CountyCounty in where the asset inspection project is located.true
DistrictString100DistrictOperating district where the asset inspection project occurred.true


PGE_GridHardeningLine_20200909 - FeatureClass

NamePGE_GridHardeningLine_20200909
ShapeTypePolyline
FeatureTypeSimple
AliasNamePGE Grid Hardening Line 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_GridHardeningLine_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
GhIDString50GH IDUnique 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
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
GhLogIDString50GH Log IDUnique ID or job ID of a grid hardening activity. Foreign key to the Grid Hardening Log table.true
GridHardeningLocationOrAddressString100Grid Hardening Location Or AddressAddress or location description for the grid hardening location.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
HFTDClassCommentString50HFTDClassCommentIf the project line intersects multiple HFTD areas, list all of them here.true
CityString50CityCity in where the grid hardening project is located.true
CountyString50CountyCounty in where the grid hardening project is located.true
DistrictString100DistrictOperating district where the grid hardening project.true


PGE_GridHardeningPoint_20200909 - FeatureClass

NamePGE_GridHardeningPoint_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Grid Hardening Point 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_GridHardeningPoint_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
GhIDString50GH IDUnique ID or job ID of a grid hardening activity. Primary key for the Grid Hardening Point table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
GhLogIDString50GH Log IDUnique ID or job ID of a grid hardening activity. Foreign key to the Grid Hardening Log table.true
GridHardeningLocationOrAddressString100Grid Hardening Location Or AddressAddress or location description for the grid hardening location.true
ParcelAPNString17Parcel APNAssessor Parcel Number (APN), a number assigned to parcels of real property by the tax assessor of a particular jurisdiction for purposes of identification and record-keeping. If the asset inspected does not intersect a parcel boundary, enter “N/A” for this field. Use the format: ###-####-###-####. For example, 006-0144-029-0000.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CityString50CityCity in where the grid hardening project is located.true
CountyString50CountyCounty in where the grid hardening project is located.true
DistrictString100DistrictOperating district where the grid hardening project.true
LatitudeSingle4LatitudeLatitude of event point in decimal degreestrue
LongitudeSingle4LongitudeLongitude of event point in decimal degrees.true


PGE_VegetationManagementInspectionLine_20200909 - FeatureClass

NamePGE_VegetationManagementInspectionLine_20200909
ShapeTypePolyline
FeatureTypeSimple
AliasNamePGE Vegetation Management Inspection Line 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_VegetationManagementInspectionLine_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmiIDString50VMI IDUnique ID or job ID of a vegetation management inspection activity. Primary key for the Vegetation Management Inspection Line table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
VmiLogIDString50VMI Log IDUnique ID or job ID of a vegetation management inspection activity. Foreign key to the Vegetation Management Inspection Log table.true
InspectionLocationOrAddressString100Inspection Location Or AddressAddress or location description for the inspection location.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
HFTDClassCommentString50HFTDClassCommentIf the project line intersects multiple HFTD areas, list all of them here.true
CityString50CityCity in where the vegetation management inspection is located.true
CountyString50CountyCounty in where the vegetation management inspection is located.true
DistrictString100DistrictOperating district where the vegetation management inspection occurred.true


PGE_VegetationManagementInspectionPoint_20200909 - FeatureClass

NamePGE_VegetationManagementInspectionPoint_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Vegetation Management Inspection Point 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_VegetationManagementInspectionPoint_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmiIDString50VMI IDUnique ID or job ID of a vegetation management inspection activity. Primary key for the Vegetation Management Inspection Point table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
VmiLogIDString50VMI Log IDUnique ID or job ID of a vegetation management inspection activity. Foreign key to the Vegetation Management Inspection Log table.true
InspectionLocationOrAddressString100Inspection Location Or AddressAddress or location description for the inspection location.true
ParcelAPNString17Parcel APNAssessor Parcel Number (APN), a number assigned to parcels of real property by the tax assessor of a particular jurisdiction for purposes of identification and record-keeping. Use the format: ###-####-###-####. For example, 006-0144- 029-0000.true
TreeHealthString3Tree HealthIs the tree healthy? Possible values: Yes, NoYesNotrue
TreeSpeciesString100Tree SpeciesCommon name for species of tree.true
TreeHeightInteger4Tree Height (feet)Tree height (feet). Round the value.true
TreeDiameterInteger4Tree Diameter (Inches)Tree diameter at breast height (inches). Round the value.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CityString50CityCity in where the vegetation management inspection is located.true
CountyString50CountyCounty in where the vegetation management inspection is located.true
DistrictString100DistrictOperating district where the vegetation management inspection occurred.true
LatitudeSingle4LatitudeLatitude of event point in decimal degreestrue
LongitudeSingle4LongitudeLongitude of event point in decimal degrees.true


PGE_VegetationManagementInspectionPolygon_20200909 - FeatureClass

NamePGE_VegetationManagementInspectionPolygon_20200909
ShapeTypePolygon
FeatureTypeSimple
AliasNamePGE Vegetation Management Inspection Polygon 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_VegetationManagementInspectionPolygon_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmiIDString50VMI IDUnique ID or job ID of a vegetation management inspection activity. Primary key for the Vegetation Management Inspection Polygon table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
VmiLogIDString50VMI LogIDUnique ID or job ID of a vegetation management inspection activity. Foreign key to the Vegetation Management Inspection Log table.true
InspectionLocationOrAddressString100Inspection Location Or AddressAddress or location description for the inspection location.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
HFTDClassCommentString50CityIf the project line intersects multiple HFTD areas, list all of them here.true
CityString50CountyCity in where the vegetation management inspection is located.true
CountyString50DistrictCounty in where the vegetation management inspection is located.true
DistrictString100DistrictOperating district where the vegetation management inspection occurred.true


PGE_VegetationManagementProjectLine_20200909 - FeatureClass

NamePGE_VegetationManagementProjectLine_20200909
ShapeTypePolyline
FeatureTypeSimple
AliasNamePGE Vegetation Management Project Line 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_VegetationManagementProjectLine_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmpIDString50VMP IDUnique ID or job ID of an initiative. Primary key for Vegetation Management Project Line table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
VMPLogIDString50WMP Log IDVMPLogIDtrue
ProjectLocationOrAddressString100Project Location Or AddressAddress or location description for tree location.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
HFTDClassCommentString50CityIf the project line intersects multiple HFTD areas, list all of them here.true
CityString50CountyCity in where the vegetation management project is located.true
CountyString50DistrictCounty in where the vegetation management project is located.true
DistrictString100DistrictOperating district where the vegetation management project occurred.true


PGE_VegetationManagementProjectPoint_20200909 - FeatureClass

NamePGE_VegetationManagementProjectPoint_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Vegetation Management Project Point 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_VegetationManagementProjectPoint_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmpIDString50VMP IDUnique ID or job ID of an initiative. Primary key for Vegetation Management Project Point table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
VmpLogIDString50VMP Log IDUnique ID or job ID of an initiative. Foreign key to the Vegetation Inspection Project Log table.true
ProjectLocationOrAddressString100Project Location Or AddressAddress or location description for tree location. Enter “N/A” if there is no address where the subject tree is located.true
ParcelAPNString17Parcel APNAssessor Parcel Number (APN), a number assigned to parcels of real property by the tax assessor of a particular jurisdiction for purposes of identification and record- keeping. Use the format: ###-####-###-####. For example, “006-0144-029-0000”.true
TreeIDString50Tree IDA unique ID associated with individual tree(s) within the scope of the vegetation management project.true
TreeHealthString3Tree HealthIs the subject tree healthy? Possible values: Yes, NoYesNotrue
TreeHazardString3Tree HazardIs the subject tree a hazard tree? Possible values: Yes, NoYesNotrue
TreeSpeciesString100Tree SpeciesCommon name for tree species in scope for the vegetation management project.true
SpeciesGrowthRateString30Species Growth RateGeneralized growth rate of the subject tree species. Possible values: Slow growing, Moderately growing, Fast growing.SpeciesGrowthRatetrue
TreeHeightInteger4Tree Height (feet)Tree height (feet). Round the value.true
TreeDiameterInteger4Tree Diameter (inches)Tree diameter at breast height (inches). Round the value.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CityString50CityCity in where the vegetation management project is located.true
CountyString50CountyCounty in where the vegetation management project is located.true
DistrictString100DistrictOperating district where the vegetation management project occurred.true
LatitudeSingle4LatitudeLatitude of event point in decimal degreestrue
LongitudeSingle4LongitudeLongitude of event point in decimal degrees.true


PGE_VegetationManagementProjectPolygon_20200909 - FeatureClass

NamePGE_VegetationManagementProjectPolygon_20200909
ShapeTypePolygon
FeatureTypeSimple
AliasNameCEC Vegetation Management Project Polygon 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_VegetationManagementProjectPolygon_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmpIDString50VMP IDUnique ID or job ID of an initiative. Primary key for Vegetation Management Project Polygon table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
VmpLogIDString50VMP Log IDUnique ID or job ID of an initiative. Foreign key to the Vegetation Inspection Project Log table.true
ProjectLocationOrAddressString100Project Location Or AddressAddress or location description for tree location.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
HFTDClassCommentString50HFTDClassCommentIf the project line intersects multiple HFTD areas, list all of them here.true
CityString50CityCity in where the vegetation management project is located.true
CountyString50CountyCounty in where the vegetation management project is located.true
DistrictString100DistrictOperating district where the vegetation management project occurred.true



PGE_OtherRequiredData - FeatureDataset

NamePGE_OtherRequiredData
DescriptionPGE_OtherRequiredData

PGE_AdministrativeArea_20200909 - FeatureClass

NamePGE_AdministrativeArea_20200909
ShapeTypePolygon
FeatureTypeSimple
AliasNamePGE Administrative Area 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_AdministrativeArea_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AdminIDString50Admin IDUnique ID and primary key for the Administrative Area table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AreaTypeString50Area TypeType of administrative area (service territory, region, district, etc.)true
SubareaTypeString50Subarea TypeUtility subarea type. Possible values: Operational, Construction, Weather, Organizational, Other - See commentSubareaTypetrue
SubareaTypeCommentString50Subarea Type CommentSubarea type not listed in the options above.true
NameString100NameName of administrative area.true


PGE_CriticalFacility_20200909 - FeatureClass

NamePGE_CriticalFacility_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Critical Facility 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_CriticalFacility_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
FacilityIDString50Facility IDUnique 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
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
FacilityNameString100Facility NameName of the facilitytrue
FacilityCategoryString30Facility CategoryCritical 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.FacilityCategorytrue
FacilityCategoryCommentString30Facility Category CommentFacility category not covered by the options above.true
FacilityDescriptionString50Facility DescriptionBrief facility description (e.g., fire station, prison, nursing home, etc.).true
CircuitIDString50Circuit IDID of circuit associated with critical facility.true
CircuitNameString255Circuit NameName of circuit associated with critical facility,true
MeterIDString50Meter IDID of meter associated with critical facility.true
BackupPowerString10Backup PowerDoes the facility have a backup power source? Possible values: Yes, No, UnknownYesNoUnknowntrue
BackupTypeString30Backup TypeType of backup power source. Possible values: Storage battery, Diesel generator, Gas generator, Combined/hybrid, Other – See comment.BackupTypetrue
BackupTypeCommentString30Backup Type CommentBackup type not listed in the options above.true
BackupCapacitySingle4Backup CapacityHours of energy storage of hours of backup generation from backup power source.true
PopulationImpactInteger4Population ImpactThe approximate number of people that depend on this critical facilitytrue
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
PSPSDaysInteger4PSPS DaysThe number of days the critical facility was impacted by PSPS events in the last 365 days.true
PSPSDaysDateBasisSingle4PSPS Days Date BasisThe date used for calculating the “PSPSDays” field. This would be the date from which 365 days would be subtracted to determine the timespan that may contain critical facility-impacting PSPS events.true
ParcelAPNString17Parcel APNID of parcel containing critical facility. Primary key for the Critical Facility table.true
AddressString100AddressThe address of the critical facility.true
CityString50CityThe city of the critical facility.true
ZipString5ZipThe 5-digit zip code of the critical facility.true
LatitudeSingle4LatitudeLatitude coordinate of critical facility (in decimal degrees).true
LongitudeSingle4LongitudeLongitude coordinate of critical facility (in decimal degrees).true


PGE_OtherPowerLineConnectionLocation_20200909 - FeatureClass

NamePGE_OtherPowerLineConnectionLocation_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Other Power Line Connection Location 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_OtherPowerLineConnectionLocation_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
OplcIDString50PPIC IDUnique ID and primary key for the private Power Line Connection Location table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
OtherLineOwnerString100Other Line OwnerName of individual or other entity that owns the private line to which an electrical corporation line is connecting.true
ConnectionAssetString100Connection AssetAsset enabling the connection.true
ConnectionPointAssetIDString50Connection Point Asset IDAssetID of the asset that enables the connection. Must be traceable stable ID within a specific asset class.true
CorporationLineIDString50Corporation Line IDAssetID of the electrical corporation line that feeds energy into or receives energy from the private line. Must be traceable stable ID within a specific asset class.true
OtherLineClassString30Other Line ClassClassification of line asset that meets corporation line at connection location. Possible values: Transmission, Primary distribution, Secondary Distribution, UnknownCircuitTypetrue
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString50CountyCounty in which connection location is located.true
OtherConductorTypeString10Other Conductor TypeType of conductor that connects to corporation line. Possible values: Bare, Covered, UnknownConductorTypetrue
ConnectionTypeString30Connection TypeType of energy transfer happening at location. Possible values: Other to corporation, Corporation to otherConnectionTypetrue
ConnectionOHUGString50Connection OH or UGIs the connection overhead or underground? Possible values: All Overhead, All underground, Overhead to underground, Underground to overhead, UnknownConnectionOHUGtrue
OtherNominalVoltagekVSingle4Other Nominal Voltage (kV)Nominal voltage (in kilovolts) of other conductor connected to corporation line. Do not use more than two decimal places. Enter “-99” if N/A.Use -99 if this is not known.true
OtherOperatingVoltagekVSingle4Other Operating Voltage (kV)Operating voltage (in kilovolts) of other conductor connected to corporation line. Do not use more than two decimal places. Enter “-99” if N/A.Use -99 for unknown.true
OtherConductorMaterialString100Other Conductor MaterialConductor material of other line that connects to corporation line. Possible values: All aluminum conductor (AAC), All aluminum alloy conductor (AAAC), Aluminum conductor aluminum reinforced (ACAR), Aluminum conductor steel reinforced (ACSR), Copper (Cu), Unknown, Other - See comment.ConductorMaterialtrue
ConductorMaterialCommentString50Conductor Material CommentConductor material not listed in the options above.true
OtherConductorSizeString30Other Conductor SizeSize of other conductor that connects to corporation line (e.g. No. 4 Cu or 1/0 ACSR). Write “Unknown” if this is not known.true
OtherConductorODSingle4Other Conductor Overall Diameter (inches)Overall diameter of the other conductor that connects to the corporation conductor in inches. Leave blank if this is not known.true
OtherConductorCodeNameString50Other Conductor Code NameCodename of the other conductor that connects to the corporation conductor. For example, “Lapwing,” “Sparrow,” etc. Write “Unknown” if this is not known.true
ConnectionLastInspectionDateDate8Connection Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
ConnectionLastMaintenanceDateDate8Connection Last Maintenance DateDate of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
ConnectionEstablishmentDateDate8Connection Establishment DateDate the connection was established. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
ConnectionEstablishmentYearInteger4Connection Establishment YearYear of connection establishment. Use four digits. Can be pulled from the “InstallationDate” field with a field calculation. Enter “-99” if unknown.true
EstimatedConnectionAgeString10Estimated Connection AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
OtherUsefulLifespanInteger4Other Useful LifespanThe number of years the other line connected to the corporation line is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
OtherAmpacityRatingSingle4Other Ampacity RatingNominal ampacity rating of the other conductor in amperes.true
OtherLineGreasedString10Other Line GreasedIs the other conductor connected to the corporation line greased to prevent water intrusion? Possible values: Yes, No, UnknownYesNoUnknowntrue
OtherPowerLineCommentsString100Other Power Line CommentsDescribe any additional key details that should be known about the connection location.true


PGE_RedFlagWarningDayPolygon_20200909 - FeatureClass

NamePGE_RedFlagWarningDayPolygon_20200909
ShapeTypePolygon
FeatureTypeSimple
AliasNamePGE Red Flag Warning Day Polygon 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_RedFlagWarningDayPolygon_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
RfwIDString50RFW IDUnique ID and primary key for the red flag warning table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
FireWeatherZoneIDString50Fire Weather Zone IDID number of fire weather zone.true
FireWeatherZoneNameString30Fire Weather Zone NameUnique ID for a specific point asset. It should be a traceable stable ID within the utility’s operations/processes.true
RedFlagWarningIssueDateDate8Red Flag Warning Issue DateStart date of the RFW in YYYY-MM-DD format. Do not include time.true
RedFlagWarningIssueTimeDate8Red Flag Warning Issue TimeStart time of the RFW. Must be in the “hh:mm:ss” format.true
NumberRedFlagWarningDaysInteger4Number Red Flag Warning DaysNumber of red flag warning days experienced in the fire weather zone in the last 365 days.true
RedFlagDaysDateBasisSingle4Red Flag Days Date BasisThe date used for calculating the “NumberRedFlagWarningDays” field. This would be the date from which 365 days would be subtracted to determine the timespan that contained red flag warning days.true



PGE_PspsEvent - FeatureDataset

NamePGE_PspsEvent
DescriptionPGE_PspsEvent

PGE_PspsEventCustomerMeterPoint_20200909 - FeatureClass

NamePGE_PspsEventCustomerMeterPoint_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE PSPS Event Customer Meter Point 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_PspsEventCustomerMeterPoint_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PspsEventMeterIDString50PSPS Event Meter IDAn underscore delimited concatenation of "EventID"+"_"+"AssetID.” Primary key for the PSPS Event Customer Meter Point.true
EventIDString50Event IDA unique standardized identification name of the unique event. Foreign key enabling connection to “PSPS Event Log” table.true
AssetIDString50Asset IDUnique 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
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString150CountyCounty in which asset is located. If the line crosses multiple counties, list all counties separated by commas.true


PGE_PspsEventDamagePoint_20200909 - FeatureClass

NamePGE_PspsEventDamagePoint_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE PSPS Event Damage Point 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_PspsEventDamagePoint_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
DamageEventIDString50Damage Event IDID value for an individual PSPS event. Event ID values for damage points should match event ID values in corresponding PSPS event GIS data. Primary key enabling connection to PSPS event conductor, support structure, and other asset damage detail tables.true
EventIDString50Event IDA unique standardized identification name of the unique event. Foreign key enabling connection to “PSPS Event Log” table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
FuelBedDescriptionString150Fuel Bed DescriptionType 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.FuelBedDescriptiontrue
FuelBedDescriptionCommentString150Fuel Bed Description CommentFuel bed description not listed in the options above.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CountyString150CountyCounty in which asset damage is located. If the line crosses multiple counties, list all counties separated by commas.true
LatitudeSingle4LatitudeLatitude of point in decimal degrees.true
LongitudeSingle4LongitudeLongitude of point in decimal degrees.true


PGE_PspsEventLine_20200909 - FeatureClass

NamePGE_PspsEventLine_20200909
ShapeTypePolyline
FeatureTypeSimple
AliasNamePGE PSPS Event Line 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_PspsEventLine_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PspsEventLineIDString50PSPS Event Line IDAn underscore delimited concatenation of "EventID"+"_"+"CircuitID.” Primary key for the PSPS Event Line table.true
EventIDString50Event IDA unique standardized identification name of the unique event. Foreign key enabling connection to “PSPS Event Log” table.true
CircuitIDString50Circuit IDA unique standardized identification name of the circuit that was de-energized. Foreign key to all the related asset line tables.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
CountyString150CountyCounty in which asset is located. If the line crosses multiple counties, list all counties separated by commas.true


PGE_PspsEventPolygon_20200909 - FeatureClass

NamePGE_PspsEventPolygon_20200909
ShapeTypePolygon
FeatureTypeSimple
AliasNamePGE PSPS Event Polygon 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_PspsEventPolygon_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PspsEventPolygonIDString50PSPS Event Polygon IDPrimary key for PSPS Event Polygons.true
EventIDString50Event IDA unique standardized identification name of the unique event. Foreign key enabling connection to “PSPS Event Log” table.true
CircuitIDString50Circuit IDA unique standardized identification name of the circuit that was de-energized. Foreign key to all the related asset line tables.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
CountyString150CountyCounty in which asset is located. If the line crosses multiple counties, list all counties separated by commas.true



PGE_RiskEvent - FeatureDataset

NamePGE_RiskEvent
DescriptionPGE_RiskEvent

PGE_DistributionOutage_20200909 - FeatureClass

NamePGE_DistributionOutage_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Distribution Outage 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_DistributionOutage_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
DoutageIDString50Distribution Outage IDThe unique ID for outage event. Primary key for the Distribution Outages table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
EventYearInteger4Event YearThe year outage started. Use four digits.true
OutageStartDateDate8Outage Start DateThe date outage started. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
OutageStartTimeDate8Outage Start TimeThe time outage started. Must be in the “hh:mm:ss” format.true
OutageEndDateDate8Outage End DateThe date of full restoration.true
OutageEndTimeDate8Outage End TimeThe time of full restoration. Must be in the “hh:mm:ss” format.true
OutageDurationDate8Outage DurationThe total time to restore all customers from the first customer out. Must be in the “hh:mm:ss” format.true
CMISingle4Total Customer-Minutes InterruptedTotal customer-minutes interrupted associated with the outage. Not more than two decimal places.true
CustomersOutMomentaryInteger4Customers Out MomentaryTotal number of unique customers that experienced an outage lasting 5 minutes or less.true
CustomersOutSustainedInteger4Customers Out SustainedTotal number of unique customers that experienced an outage lasting longer than 5 minutes.true
CustomerCountInteger4Customer CountThe total number of customers impacted by the outage.true
OutageIntervalString30Outage IntervalIndication of whether the subject outage was momentary (i.e. 5 minutes or less) or sustained (i.e. longer than 5 minutes). Possible values: Momentary, SustainedOutageIntervaltrue
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
OtherCompaniesString150Other CompaniesAffected companies from the event.true
OutageClassString30Outage ClassThe class of circuit involved in the outage. Possible Values: Distributiontrue
SubstationIDString50Substation IDUnique ID for the source substation feeding the circuit impacted by the outage. Must be traceable stable ID within a specific asset class. Foreign key to Substation table.true
RecloserSettingString30Recloser SettingIf the subject circuit is equipped with reclosing capabilities, indicate whether the reclose function was enabled or disabled at the time of the outage. If the subject circuit is not equipped with reclosing capabilities assign N/A. Possible values: Enabled, Disabled, N/ARecloserSettingtrue
IsolationDeviceTypeString30Isolation Device TypeType of protective device that operated. Possible values: Circuit Breaker, Fuse, Lightning Arrestor, Switch, Other – See commentIsolationDeviceTypetrue
IsolationDeviceTypeCommentString30Isolation Device Type CommentIsolation device type description not listed in the options above.true
BasicCauseString30Basic CauseHigh-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.SuspectedCausetrue
BasicCauseCommentString30Basic Cause CommentBasic cause description not listed in the options above.true
BasicCauseObjectString30Basic Cause ObjectDescription 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/AObjectContacttrue
BasicCauseObjectCommentString30Basic Cause Object CommentBasic cause object description not listed in the options above.true
DamagedDeviceString30Damaged DeviceThe device type that failed or experienced damage which initiated the outage. Possible Values: Anchor/ guy, Capacitor bank, Conductor, Connector device, Crossarm, Fuse, Insulator and bushing, Lightning arrestor, Pole, Recloser, Relay, Sectionalizer, Splice, Switch, Tap, Tie wire, Transformer, Voltage regulator/ booster, Unknown, Other – See comment., N/AEquiment Failuretrue
DamagedDeviceCommentString30Damaged Device CommentDamaged device description not listed in the options above.true
ExpulsionFuseOperationString3Expulsion Fuse OperationDid an expulsion fuse operate during the outage? Enter N/A if the subject circuit is not equipped with expulsion type fuses. Possible values: Yes, No, N/AYesNoNAtrue
OutageDescriptionString100Outage DescriptionDescription or additional information for the outage.true
MEDString3Major Event DayIf all outages on a certain date exceed a statistical limit called Major Event Day (MED), this flag is set against outages associated with that day and typically excluded from certain types of reports. Possible values: Yes, NoYesNotrue
SupplementalCauseString50Supplemental CauseThe supplemental cause of the outage.true
SupplementalCauseDescriptionString100Supplemental Cause DescriptionPlease describe the supplemental cause of the outage.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
LocationOrAddressString100Location or AddressAddress or location description for the outage location.true
CityString50CityCity in where the outage event is located.true
CountyString50CountyCounty in where the outage event is located.true
DistrictString100DistrictOperating district where the outage event occurred.true
LatitudeSingle4LatitudeLatitude of event point in decimal degrees.true
LongitudeSingle4LongitudeLongitude of event point in decimal degrees.true


PGE_DistributionVmOutage_20200909 - FeatureClass

NamePGE_DistributionVmOutage_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Distribution VM Outage 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_DistributionVmOutage_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
DvmOutageIDString50VM Outage IDThe unique ID for outage caused by vegetation. Primary key for the Distribution VM Outages table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
DoutageIDString50Outage IDForeign key to the Distribution Outages table.true
EventYearInteger4Event YearThe year outage started. Use four digits.true
DateOutDate8Date OutThe date outage started. Use YYYY-MM-DD format. Leave blank if unknown.true
TimeOutDate8Time OutThe time outage started. Must be in the “hh:mm:ss” format.true
InspectionDateDate8Inspection DateDate of inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
SubstationIDString50Substation IDUnique ID for the source substation feeding the circuit impacted by the outage. Must be traceable stable ID within a specific asset class. Foreign key to Substation table.true
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
TreeSpeciesString100Tree SpeciesSpecies of the subject tree involved in causing the outage.true
TreeHeightInteger4Tree Height (feet)Tree height estimation height of the subject tree involved in causing the outage, in feet.true
TreeDBHInteger4Tree Diameter at Breast Height (Inches)Tree diameter at breast height of the subject tree involved in causing the outage, in inches.true
TreeTrunkDistanceInteger4Tree Trunk Distance (feet)Horizontal distance of the subject tree’s trunk from the impacted power lines, in feet.true
VmOutageDescriptionString100VM Outage DescriptionDescription or additional information for the VM outage event.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
LocationOrAddressString100Location or AddressAddress or location description for the outage location.true
CityString50CityCity in where the VM outage is located.true
CountyString50CountyCounty in where the VM outage is located.true
DistrictString100DistrictOperating district where the VM outage occurred.true
LatitudeSingle4LatitudeLatitude of event point in decimal degrees.true
LongitudeSingle4LongitudeLongitude of event point in decimal degrees.true


PGE_Ignition_20200909 - FeatureClass

NamePGE_Ignition_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Ignition 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_Ignition_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
IgnitionIDString50Ignition IDUnique ID for the ignition event. Primary key for the Ignition Point table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
FireStartTimeDate8Fire Start TimeThe start time of the event. Must be in the “hh:mm:ss” format.true
FireStartDateDate8Fire Start DateThe start date of the event. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
FireStartYearInteger4Fire Start YearThe year that the risk event occurred. Use four digits.true
FireDetectionMethodString30Fire Detection MethodThe method by which the utility first learned of the ignition event. Possible values: Public, Satellite, Camera, Utility staff, Fire agency, Other – Comment.FireDetectionMethodtrue
FireDetectionMethodCommentString30Fire Detection Method CommentFire detection method description not listed in the options above.true
SuspectedInitiatingCauseString30Suspected Initiating CauseThe suspected initiating event of the ignition. Possible values: Object contact, Equipment failure, Wire-to-wire contact, Contamination, Utility work/Operation, Vandalism/Theft, Unknown, Other – See comment.SuspectedCausetrue
SuspectedInitiatingCauseCommentString30Suspected Initiating Cause CommentSuspected initiating event of the ignition cause description not listed in the options above.true
ObjectContactString30Object ContactDescription of object involved in contact if “Object contact” is 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/AObjectContacttrue
EquimentFailureString30Equiment FailureDescription of failed or damaged equipment or component involved if “SuspectedWireDownCause” value is “Equipment failure.” Enter N/A for this field if the value of “SuspectedWireDownCause” is not “Equipment failure.” Possible values: Anchor/ guy, Capacitor bank, Conductor, Connector device, Crossarm, Fuse, Insulator and bushing, Lightning arrestor, Pole, Recloser, Relay, Sectionalizer, Splice, Switch, Tap, Tie wire, Transformer, Voltage regulator/ booster, Unknown, Other – See comment., N/AEquiment Failuretrue
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
SubstationIDString50Substation IDUnique ID of the substation supplying the involved circuit. Foreign key to Substation table.true
SubstationNameString50Substation NameName of the substation supplying the involved circuit.true
OtherCompaniesString50Other CompaniesAffected companies from the event.true
EquipmentTypeString30Equipment TypeThe type of equipment involved in the ignition event. Possible values: Overhead, Pad-mounted, SubsurfaceEquipmentTypetrue
DeterminationString30DeterminationThe entity relied upon to make the determination of “SuspectedInitiatingEvent” above. Possible values: Utility personnel, Fire Agency, Other – See commentDeterminationtrue
DeterminationCommentString50Determination CommentDetermination entity description not listed in the options above.true
FacilityContactedString50Facility ContactedThe first facility that was contacted by an outside object. Only to be used if “Object contact” is selected as “SuspectedInitiatingEvent”. Possible values: Electric Facility, Pole, Communication FacilityFacilityContactedtrue
ContributingFactorString30Contributing FactorFactors suspected as contributing to the ignition. Possible values: Weather, External Force, Human Error, Other – See comment, UnknownContributingFactortrue
ContributingFactorCommentString30Contributing Factor CommentContributing factor description not listed in the options above.true
RFWStatusString3Red Flag Warning StatusWas there a red flag warning (RFW) issued by the National Weather Service (NWS) in effect at the ignition location at the time of ignition? Possible values: Yes, NoYesNotrue
RFWIssueDateDate8Red Flag Warning Issue DateThe 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
RFWIssueTimeDate8Red Flag Warning Issue TimeThe 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
FWWStatusString3Fire Weather Watch StatusWas there a fire weather watch (FWW) issued by the National Weather Service (NWS) in effect at the ignition location at the time of ignition? Possible values: Yes, NoYesNotrue
FWWIssueDateDate8Fire Weather Watch IssueDateThe 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
FWWIssueTimeDate8Fire Weather Watch IssueTimeThe 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
HWWStatusString3High Wind Warning StatusWas there a high wind warning (HWW) issued by the National Weather Service (NWS) in effect at the ignition location at the time of ignition? Possible values: Yes, NoYesNotrue
HWWIssueDateDate8High Wind Warning IssueDateThe 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
HWWIssueTimeDate8High Wind Warning IssueTimeThe 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
OriginLandUseString10Origin Land UseStatus of land at origin of ignition. Possible values: Rural, UrbanOriginLandUsetrue
MaterialAtOriginString30Material At OriginFuel material for the ignition origin. Possible values: Vegetation, Structure, Other – See commentMaterialAtOrigintrue
MaterialAtOriginCommentString30Material At Origin CommentMaterial at origin description not listed in the options above.true
FuelBedDescriptionString100Fuel Bed DescriptionType 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.FuelBedDescriptiontrue
FuelBedDescriptionCommentString100Fuel Bed Description CommentFuel bed description not listed in the options above.true
FireSizeString30Fire 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"FireSizetrue
SuppressedByString30Suppressed ByEntity responsible for suppressing ignition. Possible values: Customer, Fire agency, Self-extinguished, Utility, UnknownSuppressedBytrue
SuppressingAgencyString30Suppressing AgencyIf the “SupressedBy” is “Fire Agency”, enter the fire department name.true
FireInvestigationString30Fire InvestigationWhether the fire authority having jurisdiction investigated the ignition and the status of the investigation. Possible values: Yes – Complete, Yes – Pending, NoFireInvestigationtrue
FireAHJString100Fire AHJIf there was an investigation of the ignition by a fire authority having jurisdiction, enter the fire agency name.true
OutageStatusString3Outage StatusWas there an outage associated with the event? Possible values: Yes, NoYesNotrue
ToutageIDString50Transmission Outage IDA unique ID for the transmission outage event. Foreign key to the Transmission Outages table.true
DoutageIDString50Distribution Outage IDA unique ID for the distributoin outage event. Foreign key to the Distribution Outages table.true
IgnitionNotesString100Ignition NotesAdditional information regarding the ignition event. All additional data fields collected by the utility that are not included in this ignition schema shall be included in this field.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CityString50CityCity in where the ignition event is located.true
CountyString50CountyCounty in where the ignition event is located.true
DistrictString100DistrictOperating district where the ignition occurred.true
LatitudeSingle4LatitudeLatitude of event point in decimal degrees.true
LongitudeSingle4LongitudeLongitude of event point in decimal degrees.true


PGE_TransmissionOutage_20200909 - FeatureClass

NamePGE_TransmissionOutage_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Transmission Outage 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_TransmissionOutage_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
ToutageIDString50Transmission Outage IDThe unique ID for outage event. Primary key for the Transmission Outages table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
EventYearInteger4Event YearThe year outage started. Use four digits.true
OutageStartDateDate8Outage Start DateThe date outage started. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
OutageStartTimeDate8Outage Start TimeThe time outage started. Must be in the “hh:mm:ss” format.true
OutageEndDateDate8Outage End DateThe date of full restoration.true
OutageEndTimeDate8Outage End TimeThe time of full restoration. Must be in the “hh:mm:ss” format.true
OutageDurationDate8Outage DurationThe total time to restore all customers from the first customer out. Must be in the “hh:mm:ss” format.true
CMISingle4Total Customer-Minutes InterruptedTotal customer-minutes interrupted associated with the outage. Not more than two decimal places.true
CustomersOutMomentaryInteger4Customers Out MomentaryTotal number of unique customers that experienced an outage lasting 5 minutes or less.true
CustomersOutSustainedInteger4Customers Out SustainedTotal number of unique customers that experienced an outage lasting longer than 5 minutes.true
CustomerCountInteger4Customer CountThe total number of customers impacted by the outage.true
OutageIntervalString30Outage IntervalIndication of whether the subject outage was momentary (i.e. 5 minutes or less) or sustained (i.e. longer than 5 minutes). Possible values: Momentary, SustainedOutageIntervaltrue
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
OtherCompaniesString150Other CompaniesAffected companies from the event.true
OutageClassString30Outage ClassThe class of circuit involved in the outage. Possible Values: Transmissiontrue
SubstationIDString50Substation IDUnique ID for the source substation feeding the circuit impacted by the outage. Must be traceable stable ID within a specific asset class. Foreign key to Substation table.true
RecloserSettingString30Recloser SettingIf the subject circuit is equipped with reclosing capabilities, indicate whether the reclose function was enabled or disabled at the time of the outage. If the subject circuit is not equipped with reclosing capabilities assign N/A. Possible values: Enabled, Disabled, N/ARecloserSettingtrue
IsolationDeviceTypeString30Isolation Device TypeType of protective device that operated. Possible values: Circuit Breaker, Fuse, Lightning Arrestor, Switch, Other – See commentIsolationDeviceTypetrue
IsolationDeviceTypeCommentString30Isolation Device Type CommentIsolation device type description not listed in the options above.true
BasicCauseString30Basic CauseHigh-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.SuspectedCausetrue
BasicCauseCommentString30Basic Cause CommentBasic cause description not listed in the options above.true
BasicCauseObjectString30Basic Cause ObjectDescription 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/AObjectContacttrue
BasicCauseObjectCommentString30Basic Cause Object CommentBasic cause object description not listed in the options above.true
DamagedDeviceString30Damaged DeviceThe device type that failed or experienced damage which initiated the outage. Possible Values: Anchor/ guy, Capacitor bank, Conductor, Connector device, Crossarm, Fuse, Insulator and bushing, Lightning arrestor, Pole, Recloser, Relay, Sectionalizer, Splice, Switch, Tap, Tie wire, Transformer, Voltage regulator/ booster, Unknown, Other – See comment., N/AEquiment Failuretrue
DamagedDeviceCommentString30Damaged Device CommentDamaged device description not listed in the options above.true
ExpulsionFuseOperationString3Expulsion Fuse OperationDid an expulsion fuse operate during the outage? Enter N/A if the subject circuit is not equipped with expulsion type fuses. Possible values: Yes, No, N/AYesNoNAtrue
OutageDescriptionString100Outage DescriptionDescription or additional information for the outage.true
MEDString3Major Event DayIf all outages on a certain date exceed a statistical limit called Major Event Day (MED), this flag is set against outages associated with that day and typically excluded from certain types of reports. Possible values: Yes, NoYesNotrue
SupplementalCauseString50Supplemental CauseThe supplemental cause of the outage.true
SupplementalCauseDescriptionString100Supplemental Cause DescriptionPlease describe the supplemental cause of the outage.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
LocationOrAddressString100Location or AddressAddress or location description for the outage location.true
CityString50CityCity in where the outage event is located.true
CountyString50CountyCounty in where the outage event is located.true
DistrictString100DistrictOperating district where the outage event occurred.true
LatitudeSingle4LatitudeLatitude of event point in decimal degrees.true
LongitudeSingle4LongitudeLongitude of event point in decimal degrees.true


PGE_TransmissionVmOutage_20200909 - FeatureClass

NamePGE_TransmissionVmOutage_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Transmission VM Outage 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_TransmissionVmOutage_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
TvmOutageIDString50Transmission VM Outage IDThe unique ID for outage caused by vegetation. Primary key for the Transmission VM Outages table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
ToutageIDString50Outage IDForeign key to the Transmission Outages table.true
EventYearInteger4Event YearThe year outage started. Use four digits.true
DateOutDate8Date OutThe date outage started. Use YYYY-MM-DD format. Leave blank if unknown.true
TimeOutDate8Time OutThe time outage started. Must be in the “hh:mm:ss” format.true
InspectionDateDate8Inspection DateDate of inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
SubstationIDString50Substation IDUnique ID for the source substation feeding the circuit impacted by the outage. Must be traceable stable ID within a specific asset class. Foreign key to Substation table.true
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
TreeSpeciesString100Tree SpeciesSpecies of the subject tree involved in causing the outage.true
TreeHeightInteger4Tree Height (feet)Tree height estimation height of the subject tree involved in causing the outage, in feet.true
TreeDBHInteger4Tree Diameter at Breast Height (Inches)Tree diameter at breast height of the subject tree involved in causing the outage, in inches.true
TreeTrunkDistanceInteger4Tree Trunk Distance (feet)Horizontal distance of the subject tree’s trunk from the impacted power lines, in feet.true
VmOutageDescriptionString100VM Outage DescriptionDescription or additional information for the VM outage event.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
LocationOrAddressString100Location or AddressAddress or location description for the outage location.true
CityString50CityCity in where the VM outage is located.true
CountyString50CountyCounty in where the VM outage is located.true
DistrictString100DistrictOperating district where the VM outage occurred.true
LatitudeSingle4LatitudeLatitude of event point in decimal degrees.true
LongitudeSingle4LongitudeLongitude of event point in decimal degrees.true


PGE_WireDown_20200909 - FeatureClass

NamePGE_WireDown_20200909
ShapeTypePoint
FeatureTypeSimple
AliasNamePGE Wire Down 20200909
HasMfalse
HasZfalse
HasAttachmentsfalse
DescriptionPGE_WireDown_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
WireDownIDString50Wire Down IDUnique ID for the wire down event. Primary key for the Wire Down Point table.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
WireDownDateDate8Wire Down DateThe start date of the wire down event. Use YYYY-MM-DD format. Leave blank if unknown.true
WireDownYearInteger4Wire Down YearThe year that the risk event occurred. Use four digits.true
SuspectedWireDownCauseString30Suspected Wire Down CauseHigh-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.SuspectedCausetrue
SuspectedWireDownCauseCommentString30Suspected Wire Down Cause CommentSuspected wire down cause description not listed in the options above.true
ObjectContactString30Object ContactDescription of object involved in the contact if the value of “SuspectedWireDownCause” is “Object contact.” Enter N/A for this field if the value of “SuspectedWireDownCause” is not “Object contact.” 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/AObjectContacttrue
EquimentFailureString30Equiment FailureDescription of failed or damaged equipment or component involved if “SuspectedWireDownCause” value is “Equipment failure.” Enter N/A for this field if the value of “SuspectedWireDownCause” is not “Equipment failure.” Possible values: Anchor/ guy, Capacitor bank, Conductor, Connector device, Crossarm, Fuse, Insulator and bushing, Lightning arrestor, Pole, Recloser, Relay, Sectionalizer, Splice, Switch, Tap, Tie wire, Transformer, Voltage regulator/ booster, Unknown, Other – See comment., N/AEquiment Failuretrue
EquipmentFailureCommentString30Equipment Failure CommentEquipment failure description not listed in the options above.true
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
SpanLengthSingle4Span Length (feet)The length of a single-phase conductor, in feet, as measured between the “FromDevice” and “ToDevice.”true
TotalSplicesInteger4Total SplicesThe total number of splices in the span of conductor involved in the wire down event. In the event of wire down events occurring over multiple spans, include the total number of splices in all failed spans.true
MaxSplicesInteger4Maximum SplicesThe maximum number of splices in an individual phase conductor involved in the wire down event.true
MultipleDownString3Multiple DownWas more than one span of conductors impacted by the wire down event? Possible values: Yes, NoYesNotrue
ConductorMaterialString50Conductor MaterialConductor 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.ConductorMaterialtrue
ConductorMaterialCommentString50Conductor Material CommentConductor material description not listed in the options above.true
ConductorSizeString30Conductor SizeSize (e.g. No. 4, 1/0, etc.) of the conductor involved in the incident, in AWG or KCMIL.true
ConductorODSingle4Conductor Overall Diameter (inches)Overall diameter of the conductor, in inches.true
ConductorCodeNameString30Conductor Code NameThe code name of the conductor involved in the wire down event. For example, Lapwing, Sparrow, Merlin, etc.true
ConductorRatingSingle4Conductor RatingThe nominal ampacity rating of the conductor involved in the wire down event, in amperes.true
OutageStatusString3Outage StatusWas there an outage associated with the event? Possible values: Yes, NoYesNotrue
ToutageIDString50Transmission Outage IDA unique ID for the transmission outage event. Foreign key to the Transmission Outages table.true
DoutageIDString50Distribution Outage IDA unique ID for the distribution outage event. Foreign key to the Distribution Outages table.true
EnergizedString3EnergizedWas 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/AYesNoNAtrue
IgnitionStatusString3Ignition StatusWas there an ignition associated with the wire down event? Possible values: Yes, NoYesNotrue
WireDownNotesString100Wire Down NotesAdditional information or notes available for the wire down event and not captured in other fields.true
HFTDClassString10HFTD ClassThe CPUC high-fire threat district (HFTD) area the asset intersects. Possible values: Tier 3, Tier 2, Zone 1, Non-HFTDHFTDtrue
CityString50CityCity in where the wire down event is located.true
CountyString50CountyCounty in where the wire down event is located.true
DistrictString100DistrictOperating district where the wire down occurred.true
LatitudeSingle4LatitudeLatitude of event point in decimal degreestrue
LongitudeSingle4LongitudeLongitude of event point in decimal degrees.true



PGE_AssetInspectionLog_20200909 - Table

NamePGE_AssetInspectionLog_20200909
AliasNamePGE Asset Inspection Log 20200909
HasAttachmentsfalse
DescriptionPGE_AssetInspectionLog_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AiLogIDString50AI Log IDUnique ID or job ID of an asset inspection activity. Primary key for the Asset inspection table.true
VmpLogIDString50VMP Log IDUnique ID or job ID of a vegetation management project resulting from an asset inspection. A Foreign key to the Vegetation Management Project table. Enter the corresponding VmpID if the subject asset inspection resulted in the creation of a vegetation management project. If the asset inspection did not result in the creation of a related vegetation management project, then enter “N/A” for this field.true
InspectionStartDateDate8Inspection Start DateThe date when an asset inspection began. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InspectionEndDateDate8Inspection End DateThe date when an asset inspection was completed. If the asset inspection was started and completed on the same day, “InspectionStartDate” and “InspectionEndDate” will have the same value. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
PerformedByString30Performed ByWho performed the asset inspection? Possible values: Utility staff, Contractor, Other – See commentPerformedBytrue
PerformedByCommentString30Performed By CommentInspector description not listed in the options above.true
InpsectorNameString50Inpsector NameInspector name for the asset management inspection.true
InspectionTypeString30Inspection TypeThe type of asset inspection performed. Possible values: Patrol, Detailed, Pole loading, Other – See comment.InspectionTypetrue
InspectionTypeCommentString30Inspection Type CommentInspection type description not listed in the options above.true
InspectionQAString3Inspection QAHas the inspection been checked for quality assurance? Possible values: Yes, NoYesNotrue
InspectionCommentsString100Inspection CommentsAdditional comments related to the asset management inspection.true
ComplianceFindingString3Compliance FindingDid the asset inspection result in the finding of any non-compliance issues? Possible values: Yes, NoYesNotrue
InspectionMethodString100Inspection MethodThe 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.InspectionMethodtrue
InspectionMethodCommentString50Inspection Method CommentInspection method not listed in the options above—or multiple inspection methods listed in the options above. If multiple, list all values separated by commas.true
InspectionTechnologyString30Inspection TechnologyThe technology that an inspector uses for the asset inspection project. Possible values: Collector for ArcGIS, Survey123 for ArcGIS, Workforce for ArcGIS, ArcGIS QuickCapture, Other – See commentInspectionTechnologytrue
InspectionTechnologyCommentString30Inspection Technology CommentInspection technology not listed in the options above.true

PGE_GridHardeningLog_20200909 - Table

NamePGE_GridHardeningLog_20200909
AliasNamePGE Grid Hardening Log 20200909
HasAttachmentsfalse
DescriptionPGE_GridHardeningLog_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
GhLogIDString50GH Log IDUnique ID or job ID of a grid hardening activity. Primary key for the Grid Hardening Log table.true
AiLogIDString50AI Log IDUnique ID or job ID of an asset inspection activity. Foreign key to the Asset Inspection Log table.true
GhStatusString30GH StatusThe status of the grid hardening activity. Possible values: Planned, In progress, Complete, CancelledGhStatustrue
GhChangeOrderString3GH Change OrderHas a change order been requested for this grid hardening initiative since the approval of the utility’s previous WMP? Possible values: Yes, NoYesNotrue
GhChangeOrderDateDate8GH Change Order DateThe date of when the change order was submitted. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
GhChangeOrderTypeString100GH Change Order TypeGhChangeOrderTypeGhChangeOrderTypetrue
GhChangeOrderTypeCommentString100Gh Change Order Type CommentGhChangeOrderTypeCommenttrue
DateStartDate8Date StartThe start date of the grid hardening project. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
DateEndDate8Date EndThe completion date of the grid hardening project. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LineDeenergizedString3Line DeenergizedLines need to be de-energized to perform the work. Possible values: Yes, NoYesNotrue
PersonInChargeNameString50Person In Charge NamePerson in charge for the grid hardening project.true
PerformedByString30Performed ByWho performed the grid hardening activity? Possible values: Utility staff, Contractor, Other – See comment.PerformedBytrue
PerformedByCommentString30Performed By CommentEntity that performed grid hardening and is not listed in options above.true
InitiativeActivityString100Initiative ActivityInitiative 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.InitiativeActivitytrue
InitiativeActivityCommentString50Initiative Activity CommentInitiative activity not listed in the options above.true
DescriptionOfGridHardeningString100Description Of Grid HardeningAdditional description for the grid hardening work.true

PGE_InitiativeAssetLog_20200909 - Table

NamePGE_InitiativeAssetLog_20200909
AliasNamePGE Initiative Asset Log 20200909
HasAttachmentsfalse
DescriptionPGE_InitiativeAssetLog_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetLogIDString50Asset Log IDUnique ID and primary key for the Initiative Asset Log table.true
VmiIDString50VMI IDUnique 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
VmpIDString50VMP IDUnique 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
AiIDString50AI IDUnique 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
GhIDString50GH IDUnique 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
AssetIDString50Asset IDUnique ID for a specific point asset. Must be traceable stable ID within a specific asset class. Foreign key to all the related Asset Point tables.true
AssociatedAssetCountInteger4Associated Asset CountThe number of assets which are associated with the initiative activity.true
SubstationIDString50Substation IDUnique ID of the substation supplying the circuit associated with vegetation management project.true
SubstationNameString50Substation NameName of the substation supplying the circuit associated with the vegetation management project.true
CircuitIDString50Circuit IDUnique ID for a specific line asset. Must be traceable stable ID within a specific asset class. Foreign key to the Asset Line tables.true
CircuitNameString255Circuit NameName of the circuit associated with the vegetation management project.true
CircuitTypeString30Circuit TypeCircuit line type. Possible values: Transmission Line, Primary Distribution Line, Secondary Distribution Line, UnknonwnCircuitTypetrue
AssociatedCircuitLengthSingle4Associated Circuit Length (mile)The length of circuits which are associated with the initiative activity (mile). Two decimal places.true
UnderbuildString3UnderbuildAre transmission lines also present on the subject structure? Possible values: Yes, NoYesNotrue
LineDeenergizedString3Line DeenergizedDo the power lines need to be de-energized to perform the work? Possible values: Yes, NoYesNotrue

PGE_InitiativePhotoLog_20200909 - Table

NamePGE_InitiativePhotoLog_20200909
AliasNamePGE Initiative Photo Log 20200909
HasAttachmentsfalse
DescriptionPGE_InitiativePhotoLog_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PhotoIDString100Photo IDID 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
PhotoBeforeIDString100Photo Before IDID 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
PhotoAfterIDString100Photo After IDID 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
VmpIDString50VMP IDUnique 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
VmiIDString50VMI IDUnique 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
AiIDString50AI IDUnique 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
GhIDString50GH IDUnique 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
FromDeviceString50From DeviceThe 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
ToDeviceString50To DeviceThe 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

NamePGE_PspsDamagePhotoLog_20200909
AliasNamePGE PSPS Damage Photo Log 20200909
HasAttachmentsfalse
DescriptionPGE_PspsDamagePhotoLog_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PhotoIDString100Photo IDNumber 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
FuelBedPhotoIDString100Fuel Bed Photo IDNumber 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
DamageEventIDString100Damage Event IDForeign key to the damage point tables.true

PGE_PspsEventConductorDamageDetail_20200909 - Table

NamePGE_PspsEventConductorDamageDetail_20200909
AliasNamePGE PSPS Event Conductor Damage Detail 20200909
HasAttachmentsfalse
DescriptionPGE_PspsEventConductorDamageDetail_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PspsCdIDString50PSPS Conductor Damage IDPrimary key for the PSPS Event Conductor Damage Detail table.true
DamageEventIDString50Damage Event IDID value for an individual PSPS event. Event ID values for damage points should match event ID values in corresponding PSPS event GIS data. Foreign key enabling connection to “PSPS Event Damage Points” feature class.true
DateofDamageDate8Date of DamageDate or estimated date damage occurred in YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
EstimatedTimeofDamageDate8Time of DamageEstimated time damage occurred. Must be in the “hh:mm:ss” format.true
AssetIDString50Asset IDUnique ID for a specific point asset. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the related asset point tables.true
AssetString10AssetSpecific type of asset that is damaged. Required value: Conductortrue
NominalVoltagekVSingle4Nominal Voltage (kV)Nominal voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
OperatingVoltagekVSingle4Operating Voltage (kV)Operating voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
FromDeviceString50From DeviceThe upstream support structure asset ID. Foreign key to the related asset point tables. AKA AssetID.true
ToDeviceString50To DeviceThe downstream support structure asset ID. Foreign key to the related asset point tables. AKA AssetID.true
FeederIDString50FeederIDCircuit/feeder ID for the damaged span of line. Foreign to the related asset line tables.true
ConductorMaterialString50Conductor MaterialConductor material. Possible values: All aluminum conductor (AAC), All aluminum alloy, conductor (AAAC), Aluminum conductor aluminum reinforced (ACAR), Aluminum conductor steel, reinforced (ACSR), Copper (Cu), Other – See comment.ConductorMaterialtrue
ConductorMaterialCommentString50Conductor Material CommentConductor material not listed in the options above.true
ConductorTypeString10Conductor TypeType of conductor. Possible values: Bare, Covered, UnknownConductorTypetrue
ConductorLengthSingle4Conductor Length (feet)Conductor length in feet based on GIS data.true
FailedEquipmentDescriptionString100Failed Equipment DescriptionEquipment that contributed to the conductor damage. Write “Unknown” or “N/A” as appropriate.true
ExternalForceDescriptionString100External Force DescriptionForce responsible for causing the conductor damage.true
SubstationNameString50Substation NameName of substation associated with asset.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign Key to the Substation table.true
SubstationTypeString10Substation TypeType of substation. Possible values: Radial, Loop, NetworkSubstationTypetrue
CauseString30CauseHigh-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.EventCausetrue
CauseCommentString30Cause CommentCause category not listed in options above.true
EnergizedOnGroundString10Energized On GroundDid the damaged conductor make contact with the ground while energized? Possible values: Yes, No, UnknownYesNoUnknowntrue
ManufacturerModelIDString50Manufacturer Model IDThe 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
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset would have been expected to have a useful functioning existence prior to damage. Use -99 for unknown.true
LikelyArcingString10Likely ArcingWas arcing likely because of the damage? Possible values: Yes, No, UnknownYesNoUnknowntrue
DamageTypeString30Damage TypeType of damage sustained. Possible values: Asset damage, Asset failure, Equipment damage, Equipment failure, Veg contact, Object contactDamageTypetrue
DamageDescriptionString30Damage DescriptionDescription of damage. Possible values: Broken conductor, Damaged conductor, Kite in line, Pine needles on line, Tree bark on line, Tree branch on line, Tree leaning into line, Tree leaning toward line, Wire-to-wire contact, Other – See comment.DamageDescriptiontrue
DamageDescriptionCommentString30Damage Description CommentDamage category not listed in the options above and/or additional relevant details about damagetrue

PGE_PspsEventLog_20200909 - Table

NamePGE_PspsEventLog_20200909
AliasNamePGE PSPS Event Log 20200909
HasAttachmentsfalse
DescriptionPGE_PspsEventLog_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
EventIDString50Event IDA unique standardized identification name of the unique event. Primary key enabling connection to PSPS event feature classes.true
CircuitIDString50Circuit IDA unique standardized identification name of the circuit that was de-energized. Foreign key to all the related asset line tables.true
CircuitNameString255Circuit NameName of circuit associated with asset.true
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
SubstationIDString50Substation IDA unique standardized identification name of the substation/feeder feeding the circuit that was de-energized during the PSPS event. Foreign Key to the Substation table.true
SubstationNameString50Substation NameName of substation associated with asset.true
IsolationDeviceString30Isolation DeviceThe device which isolated the circuit during the PSPS event. Possible values: Circuit Breaker, Fuse, Switch, Other – See comment.IsolationDevicetrue
IsolationDeviceCommentString50Isolation Device CommentIsolation device not listed in the options above.true
IsolationDeviceIDString50Isolation Device IDA unique standardized identification name of the isolation device. Should match the value in the “AssetID” field of the isolation device’s point data in the “Switchgear” feature class. A foreign key. AKA AssetID.true
EOCActivationDateDate8EOC Activation DateDate IOU’s emergency operation center (EOC) was activated in YYYY-MM-DD format. Do not include time.true
EOCActivationTimeDate8EOC Activation TimeTime IOU’s emergency operation center was activated. Must be in the “hh:mm:ss” format.true
StartDateDate8Start DateStart date of the PSPS event in YYYY-MM-DD format. Do not include time.true
StartTimeDate8Start TimeStart time of the PSPS event (i.e. when the first de-energization occurred). Must be in the “hh:mm:ss” format.true
AllClearDateDate8All Clear DateDate 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
AllClearTimeDate8All Clear TimeTime 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
AllLoadUpDateDate8All Load Up DateDate last customer was fully restored following the PSPS event. Must be in YYYY-MM-DD format. Do not include time.true
AllLoadUpTimeDate8All Load Up TimeTime 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
PredictedDurationMinutesInteger4Predicted Duration MinutesAnticipated duration of PSPS event's circuit shutoff after it is initiated. Must be reported in whole number minutes.true
ActualDurationMinutesInteger4Actual Duration MinutesActual duration of PSPS event's circuit shutoff. This would be determined after restoration and must be reported in whole number minutes.true
DurationPredictionErrorInteger4Duration Prediction Error“PredictedDurationMinutes” minus “ActualDurationMinutes”. Positive values indicate shorter than predicted PSPS outage duration; negative values indicate longer than predicted PSPS outage duration.true
TotalCustomerMinutesInteger4Total Customer Minutes"ActualDurationMinutes" multiplied by "TotalCustomers". This field features total customer minutes impacted across the circuit.true
TotalCustomerHoursInteger4Total Customer Hours"TotalCustomerMinutes" divided by 60. This field features total customer hours impacted across the circuit.true
TotalCustomersInteger4Total CustomersTotal impacted customers. This is not necessarily a sum of all customer category values listed below because medical baseline customers may also be in other customer categories.true
ResidentialCustomersInteger4Residential CustomersTotal residential customers.true
MedicalBaselineCustomersInteger4Medical Baseline CustomersTotal medical baseline customers.true
CommercialIndustrialCustomersInteger4Commercial Industrial CustomersTotal commercial/industrial customers.true
OtherCustomersInteger4Other CustomersTotal customers that do not fall within residential or commercial/industrial (as requested under Decision 12-04-024).true
CriticalInfrastructureInteger4Critical InfrastructureNumber of critical infrastructure locations (in accordance with Decision 19-05-042 as modified by D.20-05-051) impacted by the PSPS event.true
CriticalInfrastructureDurationInteger4Critical Infrastructure DurationDuration of critical infrastructure locations (in accordance with Decision 19-05-042) de-energized during the PSPS event. Must be reported in whole number minutes.true
CriticalInfrastructureImpactInteger4Critical Infrastructure Impact“CriticalInfrastructure” multiplied by “CriticalInfrastructureDuration”. This field features the total PSPS impact on critical infrastructure.true
CountyString150CountyCounty in which asset is located. If the line crosses multiple counties, list all counties separated by commas.true
WindRiskString3Wind RiskWas high wind a driving risk factor in the PSPS decision? Possible values: Yes, NoYesNotrue
RelativeHumidityRiskString3Relative Humidity RiskWas low relative humidity a driving risk factor in the PSPS decision? Possible values: Yes, NoYesNotrue
TemperatureRiskString3Temperature RiskWas high temperature a driving risk factor in the PSPS decision? Possible values: Yes, NoYesNotrue
VegetationRiskString3Vegetation RiskWas a higher probability of vegetation interference a driving risk factor in the PSPS decision? Possible values: Yes, NoYesNotrue
AssetRiskString3Asset RiskWas a higher probability of asset failure a driving risk factor in the PSPS decision? Possible values: Yes, NoYesNotrue
DeadFuelRiskString3Dead Fuel RiskWas a high presence of dead fuel a driving risk factor in the PSPS decision? Possible values: Yes, NoYesNotrue
LiveFuelRiskString3Live Fuel RiskWas a high presence of live fuel a driving risk factor in the PSPS decision? Possible values: Yes, NoYesNotrue
RedFlagWarningRiskString3Red Flag Warning RiskWas the presence of a Red Flag Warning risk day a driving factor in the PSPS decision? Possible values: Yes, NoYesNotrue
OtherRiskString3Other RiskWas some other form of risk (not covered by the fields above) a driving risk factor in the PSPS decision? Possible values: Yes, NoYesNotrue
OtherRiskReasonString100Other Risk ReasonBrief description of what the “OtherRisk” category is if there is a “Yes” value under the “OtherRisk” field. Possible example statements include things like “vehicle collision,” “reported ignition,” etc. Enter “N/A” if the value for “OtherRisk” is “No.”true

PGE_PspsEventOtherAssetDamageDetail_20200909 - Table

NamePGE_PspsEventOtherAssetDamageDetail_20200909
AliasNamePGE PSPS Event Other Asset Damage Detail 20200909
HasAttachmentsfalse
DescriptionPGE_PspsEventOtherAssetDamageDetail_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PspsOadIDString50PSPS Other Asset Damage IDPrimary key for the PSPS Event Other Asset Damage Detail table.true
DamageEventIDString50Damage Event IDID value for an individual PSPS event. Event ID values for damage points should match event ID values in corresponding PSPS event GIS data. Foreign key enabling connection to “PSPS Event Damage Points” feature class.true
DateofDamageDate8Date of DamageDate or estimated date damage occurred in YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
EstimatedTimeofDamageDate8Time of DamageEstimated time damage occurred. Must be in the “hh:mm:ss” format.true
AssetIDString50Asset IDUnique ID for a specific point asset. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the related asset point tables.true
AssetString30AssetSpecific type of asset that is damaged. This list of dropdown menu items should be modified by each IOU to cover the assets most likely to be involved in PSPS damage. Possible values: Down guy, Neutral, Service neutral, Span guy, Tie wire, Wood pin, Anchor, Other – See comment.PspsOtherAssettrue
AssetCommentString30Asset CommentAsset not listed in the options above.true
FeederIDString50Circuit IDCircuit/feeder ID for the damaged span of line. Foreign to the related asset line tables.true
NominalVoltagekVSingle4Nominal Voltage (kV)Nominal voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
OperatingVoltagekVSingle4Operating Voltage (kV)Operating voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
ManufacturerModelIDString50Manufacturer Model IDThe 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
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset would have been expected to have a useful functioning existence prior to damage. Use -99 for unknown.true
ExemptionStatusString10Exemption StatusIs 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/AExemptionStatustrue
LikelyArcingString10Likely ArcingWas arcing likely because of the damage? Possible values: Yes, No, UnknownYesNoUnknowntrue
DamageTypeString30Damage TypeType of damage sustained. Possible values: Asset damage, Asset failure, Equipment damage, Equipment failure, Veg contact, Object contactDamageTypetrue
DamageDescriptionString30Damage DescriptionDescription of damage. Possible values: Broken down guy, Broken hand tie, Broken neutral, Broken service neutral, Broken guy wire, Broken tie wire, Broken tree branch near line, Broken pin, Broken insulator, Damaged crossarm, Guy and anchor damage, Tree branch on transformer, Other – See comment.OtherAssetDamageDescriptiontrue
DamageDescriptionCommentString30Damage Description CommentDamage category not listed in the options above and/or additional relevant details about damagetrue

PGE_PspsEventSupportStructureDamageDetail_20200909 - Table

NamePGE_PspsEventSupportStructureDamageDetail_20200909
AliasNamePGE PSPS Event Support Structure Damage Detail 20200909
HasAttachmentsfalse
DescriptionPGE_PspsEventSupportStructureDamageDetail_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PspsSsdIDString50PSPS Support Structure IDPrimary key for the PSPS Event Support Structure Damage Detail table.true
DamageEventIDString50Damage Event IDID value for an individual PSPS event. Event ID values for damage points should match event ID values in corresponding PSPS event GIS data. Foreign key enabling connection to “PSPS Event Damage Points” feature class.true
DateofDamageDate8Date of DamageDate or estimated date damage occurred in YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
EstimatedTimeofDamageDate8Time of DamageEstimated time damage occurred. Must be in the “hh:mm:ss” format.true
AssetIDString50Asset IDUnique ID for a specific point asset. It should be a traceable stable ID within the utility’s operations/processes. Foreign key to the related asset point tables.true
AssetString30AssetSpecific type of asset that is damaged. This list of dropdown menu items should be modified by each IOU to cover the assets most likely to be involved in PSPS damage. Possible values: Pole, Tower, Crossarm, Secondary arms, Other – See comment.PspsAssettrue
AssetCommentString30Asset CommentAsset not listed in the options above.true
FeederIDString50Circuit IDCircuit/feeder ID for the damaged span of line. Foreign to the related asset line tables.true
NominalVoltagekVSingle4Nominal Voltage (kV)Nominal voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
OperatingVoltagekVSingle4Operating Voltage (kV)Operating voltage (in kilovolts) of conductor. Do not use more than two decimal places. Enter “-99” if N/A.true
SupportStructureMaterialString30Support Structure MaterialMaterial of which support structure is made. Possible values: Wood, Metal, Composite, Wrapped wood, Concrete, Other – See comment.SupportStructureMaterialtrue
MaterialCommentString30Material CommentSupport structure material not listed in the options above.true
ManufacturerModelIDString50Manufacturer Mode lIDThe 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
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset would have been expected to have a useful functioning existence prior to damage. Use -99 for unknown.true
LikelyArcingString10Likely ArcingWas arcing likely because of the damage? Possible values: Yes, No, UnknownYesNoUnknowntrue
DamageTypeString30Damage TypeType of damage sustained. Possible values: Asset damage, Asset failure, Equipment damage, Equipment failure, Veg contact, Object contactDamageTypetrue
DamageDescriptionString30Damage DescriptionDescription of damage. Possible values: Broken pole, Damaged pole, Broken tower, Damaged tower, Broken crossarm, Damaged crossarm, Other – See comment.SupportStructureDamageDescriptiontrue
DamageDescriptionCommentString30Damage Description CommentDamage category not listed in the options above and/or additional relevant details about damagetrue

PGE_RiskEventAssetLog_20200909 - Table

NamePGE_RiskEventAssetLog_20200909
AliasNamePGE Risk Event Asset Log 20200909
HasAttachmentsfalse
DescriptionPGE_RiskEventAssetLog_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
ReaIDString50Risk Event Asset IDThe unique ID for the associated asset. Primary key for the Risk Event Asset Log table.true
WireDownIDString50Wire Down IDForeign key to the Wire Down Event table.true
FromDeviceString50From DeviceThe 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
ToDeviceString50To DeviceThe 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
IgnitionIDString50Ignition IDForeign key to the Ignition table.true
StationIDString50Station IDUnique ID for the nearest weather station to the ignition location. Enter multiple IDs if multiple stations are in the same location. Must be traceable stable ID within a weather station. Foreign key to the Weather Station table.true
ToutageIDString50Transmission Outage IDForeign key to the Transmission Outages table.true
TvmOutageIDString50Transmission VM Outage IDThe unique ID for outage caused by vegetation. Foreign key to the Transmission Vegetation Management Outage table.true
DoutageIDString50Distribution Outage IDForeign key to the Distribution Outages table.true
DvmOutageIDString50Distribution VM Outage IDThe unique ID for outage caused by vegetation. Foreign key to the Distribution Vegetation Management Outage table.true
IsolationDeviceIDString50Isolation Device IDThe AssetID of the device that operated to de-energize the circuit for an outage event. Should be traceable within a specific asset class. Foreign key to all the associated asset point tables.true
DamagedDeviceIDString50Damaged Device IDThe AssetID of the device that failed or experienced damage which initiated the outage. Should be traceable within a specific asset class. Foreign key to all the associated asset point tables.true
AssetIDString50Asset IDUnique 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
CircuitIDString50Circuit IDUnique ID for the specific circuit impacted by a risk event. Must be traceable stable ID within a specific asset class. Foreign key to all the associated asset tables.true
SubstationIDString50Substation IDUnique ID for the source substation feeding the circuit impacted by the outage. Must be traceable stable ID within a substation. Foreign key to the Substation table.true

PGE_RiskEventPhotoLog_20200909 - Table

NamePGE_RiskEventPhotoLog_20200909
AliasNamePGE Risk Event Photo Log 20200909
HasAttachmentsfalse
DescriptionPGE_RiskEventPhotoLog_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
PhotoIDString100Photo IDIllustration 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
IgnitionIDString50Ignition 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
WireDownIDString50Wire Down IDForeign key to the Wire Down Event table.true

PGE_SupportStructureCrossarmDetail_20200909 - Table

NamePGE_SupportStructureCrossarmDetail_20200909
AliasNamePGE Support Structure Crossarm Detail 20200909
HasAttachmentsfalse
DescriptionPGE_SupportStructureCrossarmDetail_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique 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
SupportStructureIDString50Support Structure IDUnique 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
UtilityIDString10Utility IDStandardized identification name of the utility (“UtilityG+E,” etc.).true
AssetTypeString10Asset TypeType of point asset. Required value: Crossarmtrue
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line tables.true
CircuitNameString255Circuit NameName of circuit associated with asset.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
CrossarmConfigurationString30Crossarm ConfigurationConfiguration of crossarm. Possible values: Single Arm, Double Arm, Alley ArmCrossarmConfigurationtrue
CrossarmLengthSingle4Crossarm Length (inches)Length of crossarm in inches.true
CrossarmWidthSingle4Crossarm Width (inches)Width of crossarm in inches.true
CrossarmHeightSingle4Crossarm Height (inches)Height of crossarm in inches.true
CrossarmMaterialString30Crossarm MaterialMaterial from which pole, tower, or crossarm is made. Possible values: Wood, Metal, Composite, Other – See comment.CrossarmMaterialtrue
CrossarmMaterialCommentString30Crossarm Material CommentCrossarm material not listed in the options above.true
CrossarmMaterialSubtypeString30Crossarm Material SubtypeThe subtype of structure material. For example, if a wood pole, the type of wood (i.e. Douglas Fir, Cedar, etc.).true
BraceTypeString30Brace TypeThe type of brace supporting the crossarm. Possible values: V brace, Flat brace, Other – See comment.BraceTypetrue
BraceTypeCommentString30Brace Type CommentBrace type not listed in the options above.true
CrossarmOrientationString10Crossarm OrientationOrientation of crossarm. Possible values: In-line, BuckCrossarmOrientationtrue
BalanceString30BalanceBalancing status of crossarm. Possible values: Balanced, Unbalanced (i.e., end of line)Balancetrue

PGE_TransformerDetail_20200909 - Table

NamePGE_TransformerDetail_20200909
AliasNamePGE Transformer Detail 20200909
HasAttachmentsfalse
DescriptionPGE_TransformerDetail_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
AssetIDString50Asset IDUnique ID for a specific switchgear asset. It should be a traceable stable ID within the utility’s operations/processes. Primary key for the Transformer Detail table.true
TransformerIDString50Transformer IDUnique 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
TransformerSubtypeString100TransformerSubtypeSpecific subtype of the transformer. Possible values: Single phase pad-mounted, Single phase subsurface, Single phase overhead, Three phase pad-mounted, Three phase subsurface, Three phase overheadTransformerSubtypetrue
AssociatedNominalVoltagekVSingle4Associated Nominal Voltage (kV)Nominal voltage (in kilovolts) associated with asset. Do not use more than two decimal places.true
AssociatedOperatingVoltagekVSingle4Associated Operating Voltage (kV)Operating voltage (in kilovolts) associated with asset. Do not use more than two decimal places. Enter “-99” if N/A.true
SubstationIDString50Substation IDID of substation associated with asset. Foreign Key to the Substation table.true
SubstationNameString50Substation NameName of substation associated with asset.true
CircuitIDString50Circuit IDID of circuit associated with asset. This will be a unique standardized identification name of the circuit. Foreign key to all the related asset line tables.true
CircuitNameString255Circuit NameName of circuit associated with asset.true
MakeandManufacturerString50Make and ManufacturerWhat is the make and manufacturer of the asset? Enter “Unknown” if this cannot be determined.true
ModelNumberString30Model NumberModel number of the asset. Enter “Unknown” if this cannot be determined.true
LastInspectionDateDate8Last Inspection DateDate of the last inspection. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
LastMaintenanceDateDate8Last Maintenance DateDate of the last maintenance. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationDateDate8Installation DateDate the asset was installed. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
InstallationYearInteger4Installation YearYear of asset installation. Use four digits. Enter “-99” if unknown.true
EstimatedAgeString10Estimated AgeThe age of the asset in years. Only fill this out if the “InstallationYear” and “InstallationDate” values are unknown. Possible values: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90-99, >100, Unknown, N/A (only enter this if there is an “InstallationYear” value)EstimatedAgetrue
UsefulLifespanInteger4Useful LifespanThe number of years an asset is expected to have a useful functioning existence upon initial installation. Use -99 for unknown.true
ExemptionStatusString30Exemption StatusIs 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/AExemptionStatustrue
TransformerRatingSingle4Transformer Rating (kVAs)Nominal electrical load capacity in kilovolt amps (kVAs).true

PGE_VegetationManagementInspectionLog_20200909 - Table

NamePGE_VegetationManagementInspectionLog_20200909
AliasNamePGE Vegetation Management Inspection Log 20200909
HasAttachmentsfalse
DescriptionPGE_VegetationManagementInspectionLog_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmiLogIDString50VMI Log IDUnique ID or job ID of a vegetation management inspection activity. Primary key for the Vegetation Management Inspection Log table.true
VmpLogIDString50VMP Log IDUnique 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
InspectionDateDate8Inspection DateThe 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
InpsectorNameString50Inpsector NameInspector performing the vegetation management inspection.true
InspectionTypeString100Inspection TypeInitiative 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 commentVmInspectionTypetrue
InspectionTypeCommentString100Inspection Type CommentInspection type description not listed in the options above.true
InspectionStatusString30Inspection StatusThe status of the initiative activity related to the vegetation inspection project which include, Planned, In-progress, CompleteVmiStatustrue
InspectionQAString3Inspection QAHas the inspection been checked for quality assurance? Possible values: Yes, NoYesNotrue
TreeTrimmingCountInteger4Tree Trimming CountThe number of trees identified for trimming from the vegetation management inspection.true
TreeTrimmingAcreageSingle4Tree Trimming AcreageThe acreage of trees identified for trimming from the vegetation management inspection. Two decimal placestrue
InspectionCommentString100Inspection CommentAdditional comments regarding the vegetation inspection project.true
InspectionMethodString100Inspection MethodInspection methods which include, Ground inspection, Aerial – drone, Aerial – helicopter, Remote sensing – satellite imagery, Remote sensing – LiDAR, Other – See commentInspectionMethodtrue
InspectionMethodCommentString50Inspection Method CommentInspection method description not listed in the options above.true
InspectionTechnologyString30Inspection TechnologyThe technology that an inspector uses for the vegetation management inspection. Possible values: Collector for ArcGIS, Survey123 for ArcGIS, Workforce for ArcGIS, ArcGIS QuickCapture, Other – See comment, NoneInspectionTechnologytrue
InspectionTechnologyCommentString30Inspection Technology CommentInspection technology description not listed in the options above.true

PGE_VegetationManagementProjectLog_20200909 - Table

NamePGE_VegetationManagementProjectLog_20200909
AliasNamePGE Vegetation Management Project Log 20200909
HasAttachmentsfalse
DescriptionPGE_VegetationManagementProjectLog_20200909

FieldDataTypeLengthAliasNameDescriptionDomainDefaultValueIsNullablePrecisionScale
VmpLogIDString50VMP Log IDUnique ID or job ID of an initiative. Primary key for Vegetation Management Project Log table.true
DateStartDate8Date StartThe completion date of the vegetation management project. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
DateEndDate8Date EndThe completion date of the vegetation management project. Use YYYY-MM-DD format. Leave blank if unknown. Do not include time.true
VmpStatusString30Vegetation Management Project StatusStatus of the vegetation management project. Possible Values: Complete, In progress, Planned, Delayed, CancelledVmpStatustrue
VmpStatusCommentsString30Vegetation Management Project Status CommentsAdditional comments regarding the status of the vegetation management project.true
PersonInChargeString50Person In ChargeName of the person in charge for the vegetation management project.true
CoastalRedwoodExemptionString3Coastal Redwood ExemptionCoastal redwood exception to clearance being applied. Possible values: Yes, NoYesNotrue
EncroachPermitString3Encroach PermitIs an encroachment permit required for the vegetation management project? Possible values: Yes, NoYesNotrue
EnvPermitString3Environmental PermitIs special environmental permitting needed for the vegetation management project? Possible values: Yes, NoYesNotrue
EnvPermitProjectString100Environmental Permit ProjectSpecific activity (e.g., timber harvest under an exemption) for which a permit was obtained.true
EnvPermitDocumentationString50Environmental Permit DocumentationInclude 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
BMPApplyString3Best Management Practice ApplyDo best management practices apply for the vegetation management project? Possible values: Yes, NoYesNotrue
AMMApplyString3Avoidance and Minimization Measures ApplyDo avoidance and minimization measures apply to the vegetation management project? Possible values: Yes, NoYesNotrue
WoodManagementString3Wood ManagementIs wood management needed for the vegetation management project? Possible values: Yes, NoYesNotrue
WoodManagementCommentsString100Wood Management CommentsAdditional comments regarding wood management needs for the vegetation management project.true
LandDesignationString50Land DesignationThe 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)LandDesignationtrue
RiparianAreaString3Riparian AreaIs the vegetation management project located in a riparian area? Possible values: Yes, NoYesNotrue
CaltransPropString3Caltrans PropertyIs the vegetation management project located on Caltrans property? Possible values: Yes, NoYesNotrue
ProjectCategoryString50Project CategoryHigh-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.ProjectCategorytrue
ProjectCategoryCommentString50Project Category CommentProject category description not listed in the options above.true
TreeTrimCountInteger4Tree Trim CountNumber of trees listed for trimming in the vegetation management project.true
TreeTrimAcreageSingle4Tree Trim AcreageAcreage of trees listed for trimming in the vegetation management project. Two decimal placestrue
TreeRemovalCountInteger4Tree Removal CountNumber of trees listed for removal in the vegetation management project.true
TreeRemovalAcreageSingle4Tree Removal AcreageAcreage of trees listed for removal in the vegetation management project. Two decimal placestrue
TreeTrimCountActlInteger4Tree Trim Count ActuallyNumber of trees actually trimmed as part of the vegetation management project.true
TreeTrimAcreageActlSingle4Tree Trim Acreage ActuallyAcreage of trees actually trimmed as part of the in the vegetation management project. Two decimal placestrue
TreeRemovalCountActlInteger4Tree Removal Count ActuallyNumber of trees actually removed as part of the vegetation management project.true
TreeRemovalAcreageActlSingle4Tree Removal Acreage ActuallyAcreage of trees actually removed as part of the vegetation management project. Two decimal placestrue
VegetationTreatmentTypeString50Vegetation Treatment TypeThe 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.VegetationTreatmentTypetrue
VegetationTreatmentTypeCommentString50Vegetation Treatment Type CommentTreatment type not listed in options above—or multiple treatment types listed in options above. If multiple, list all separated by commas.true
DescriptionOfWorkString100Description Of WorkAdditional description of the vegetation management work.true

AssetClass - Domain

DomainNameAssetClass
DescriptionIs the asset associated with transmission or distribution?
FieldTypeString
Domain TypeCodedValue

CodeName
TransmissionTransmission
DistributionDistribution


BackupType - Domain

DomainNameBackupType
DescriptionType of backup power source.
FieldTypeString
Domain TypeCodedValue

CodeName
Storage batteryStorage battery
Diesel generatorDiesel generator
Gas generatorGas generator
Combined/hybridCombined/hybrid
OtherOther


Balance - Domain

DomainNameBalance
DescriptionBalancing status of crossarm.
FieldTypeString
Domain TypeCodedValue

CodeName
BalancedBalanced
UnbalancedUnbalanced


Brace Type - Domain

DomainNameBrace Type
DescriptionThe type of brace supporting the crossarm.
FieldTypeString
Domain TypeCodedValue

CodeName
V braceV brace
Flat braceFlat brace
OtherOther


BraceType - Domain

DomainNameBraceType
DescriptionThe type of brace supporting the crossarm.
FieldTypeString
Domain TypeCodedValue

CodeName
V braceV brace
Flat braceFlat brace
OtherOther


CircuitType - Domain

DomainNameCircuitType
DescriptionCircuit line type.
FieldTypeString
Domain TypeCodedValue

CodeName
Transmission LineTransmission Line
Primary Distribution LinePrimary Distribution Line
Secondary Distribution LineSecondary Distribution Line
UnknownUnknown


ConductorMaterial - Domain

DomainNameConductorMaterial
DescriptionConductor material.
FieldTypeString
Domain TypeCodedValue

CodeName
All aluminum conductor (AAC)All aluminum conductor (AAC)
All aluminum alloy conductor (AAAC)All aluminum alloy conductor (AAAC)
Aluminum conductor aluminum reinforced (ACAR)Aluminum conductor aluminum reinforced (ACAR)
Aluminum conductor steel reinforced (ACSR)Aluminum conductor steel reinforced (ACSR)
Copper (Cu)Copper (Cu)
OtherOther


ConductorType - Domain

DomainNameConductorType
DescriptionType of conductor.
FieldTypeString
Domain TypeCodedValue

CodeName
BareBare
CoveredCovered
UnknownUnknown


ConductorTypeSecondary - Domain

DomainNameConductorTypeSecondary
DescriptionType of conductor for secondary distribution.
FieldTypeString
Domain TypeCodedValue

CodeName
Open wireOpen wire
TriplexTriplex
OtherOther


ConnectionDeviceSubtype - Domain

DomainNameConnectionDeviceSubtype
DescriptionWhat is the specific subtype of the connection device?
FieldTypeString
Domain TypeCodedValue

CodeName
Crimp SpliceCrimp Splice
Automatic SpliceAutomatic Splice
Explosive Sleeve SpliceExplosive Sleeve Splice
3-bolt3-bolt
Parallel GrooveParallel Groove
UnknownUnknown
OtherOther


ConnectionDeviceType - Domain

DomainNameConnectionDeviceType
DescriptionWhat type of connection device is the asset?
FieldTypeString
Domain TypeCodedValue

CodeName
SpliceSplice
ConnectorConnector
ClampClamp
OtherOther
UnknownUnknown


ConnectionOHUG - Domain

DomainNameConnectionOHUG
DescriptionIs the connection overhead or underground?
FieldTypeString
Domain TypeCodedValue

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


ConnectionType - Domain

DomainNameConnectionType
DescriptionType of energy transfer happening at location.
FieldTypeString
Domain TypeCodedValue

CodeName
Private to corporationPrivate to corporation
Corporation to privateCorporation to private


ConstructionGrade - Domain

DomainNameConstructionGrade
DescriptionGrade of construction, in accordance with GO 9, Rule 42
FieldTypeString
Domain TypeCodedValue

CodeName
Grade AGrade A
Grade BGrade B
Grade CGrade C


ContributingFactor - Domain

DomainNameContributingFactor
DescriptionFactors suspected as contributing to the ignition.
FieldTypeString
Domain TypeCodedValue

CodeName
WeatherWeather
External ForceExternal Force
Human ErrorHuman Error
OtherOther
UnknownUnknown


CrossarmConfiguration - Domain

DomainNameCrossarmConfiguration
DescriptionConfiguration of crossarm
FieldTypeString
Domain TypeCodedValue

CodeName
Single ArmSingle Arm
Double ArmDouble Arm
Alley ArmAlley Arm


CrossarmMaterial - Domain

DomainNameCrossarmMaterial
DescriptionMaterial from which pole, tower, or crossarm is made.
FieldTypeString
Domain TypeCodedValue

CodeName
WoodWood
MetalMetal
CompositeComposite
OtherOther


CrossarmOrientation - Domain

DomainNameCrossarmOrientation
DescriptionOrientation of crossarm.
FieldTypeString
Domain TypeCodedValue

CodeName
In-lineIn-line
BuckBuck


DamageDescription - Domain

DomainNameDamageDescription
DescriptionDescription of damage.
FieldTypeString
Domain TypeCodedValue

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


DamageType - Domain

DomainNameDamageType
DescriptionType of damage sustained.
FieldTypeString
Domain TypeCodedValue

CodeName
Asset damageAsset damage
Asset failureAsset failure
Equipment damageEquipment damage
Equipment failureEquipment failure
Veg contactVeg contact
Object contactObject contact


Determination - Domain

DomainNameDetermination
DescriptionThe entity relied upon to make the determination of SuspectedInitiatingEvent.
FieldTypeString
Domain TypeCodedValue

CodeName
Utility personnelUtility personnel
Fire AgencyFire Agency
OtherOther


Equiment Failure - Domain

DomainNameEquiment Failure
DescriptionDescription of failed or damaged equipment or component.
FieldTypeString
Domain TypeCodedValue

CodeName
Anchor/ guyAnchor/ guy
Capacitor bankCapacitor bank
ConductorConductor
Connector deviceConnector device
CrossarmCrossarm
FuseFuse
Insulator and bushingInsulator and bushing
Lightning arrestorLightning arrestor
PolePole
RecloserRecloser
RelayRelay
SectionalizerSectionalizer
SpliceSplice
SwitchSwitch
TapTap
Tie wireTie wire
TransformerTransformer
Voltage regulator/ boosterVoltage regulator/ booster
UnknownUnknown
OtherOther
N/AN/A


EquipmentType - Domain

DomainNameEquipmentType
DescriptionThe type of equipment involved in the ignition event.
FieldTypeString
Domain TypeCodedValue

CodeName
OverheadOverhead
Pad-mountedPad-mounted
SubsurfaceSubsurface


EstimatedAge - Domain

DomainNameEstimatedAge
DescriptionThe age of the asset in years.
FieldTypeString
Domain TypeCodedValue

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


EventCause - Domain

DomainNameEventCause
DescriptionHigh-level category for event cause.
FieldTypeString
Domain TypeCodedValue

CodeName
Object contactObject contact
Equipment failureEquipment failure
Wire-to-wire contactWire-to-wire contact
ContaminationContamination
Utility work/OperationUtility work/Operation
Vandalism/TheftVandalism/Theft
UnknownUnknown
OtherOther


ExemptionStatus - Domain

DomainNameExemptionStatus
DescriptionIs the asset exempt per California PRC 4292
FieldTypeString
Domain TypeCodedValue

CodeName
YesYes
NoNo
UnknownUnknown
N/AN/A


FacilityCategory - Domain

DomainNameFacilityCategory
DescriptionCritical facility category.
FieldTypeString
Domain TypeCodedValue

CodeName
ChemicalChemical
CommunicationsCommunications
Emergency servicesEmergency services
EnergyEnergy
Government facilitiesGovernment facilities
Healthcare and public healthHealthcare and public health
Public safety answering pointsPublic safety answering points
TransportationTransportation
Water and wastewater systemsWater and wastewater systems
OtherOther


FacilityContacted - Domain

DomainNameFacilityContacted
DescriptionThe first facility that was contacted by an outside object.
FieldTypeString
Domain TypeCodedValue

CodeName
Electric FacilityElectric Facility
PolePole
Communication FacilityCommunication Facility


FireDetectionMethod - Domain

DomainNameFireDetectionMethod
DescriptionThe method by which the utility first learned of the ignition event.
FieldTypeString
Domain TypeCodedValue

CodeName
PublicPublic
SatelliteSatellite
CameraCamera
Utility staffUtility staff
Fire agencyFire agency
OtherOther


FireInvestigation - Domain

DomainNameFireInvestigation
DescriptionWhether the fire authority having jurisdiction investigated the ignition and the status of the investigation.
FieldTypeString
Domain TypeCodedValue

CodeName
Yes – CompleteYes – Complete
Yes – PendingYes – Pending
NoNo


FireSize - Domain

DomainNameFireSize
DescriptionSize, in acres unless otherwise indicated, of fire resulting from the ignition.
FieldTypeString
Domain TypeCodedValue

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


FuelBedDescription - Domain

DomainNameFuelBedDescription
DescriptionType of fuel bed existing under damage location.
FieldTypeString
Domain TypeCodedValue

CodeName
Fire-resistive fuel bedFire-resistive fuel bed
Grass fuel modelGrass fuel model
Brush fuel modelBrush fuel model
Timber fuel modelTimber fuel model
OtherOther


FuseAssetType - Domain

DomainNameFuseAssetType
DescriptionType of fuse device
FieldTypeString
Domain TypeCodedValue

CodeName
BridgedBridged
Current limitingCurrent limiting
ExpulsionExpulsion
Fused elbowFused elbow
UnknownUnknown
OtherOther


GhChangeOrderType - Domain

DomainNameGhChangeOrderType
DescriptionThe type of change order requested.
FieldTypeString
Domain TypeCodedValue

CodeName
Increase in scaleIncrease in scale
Decrease in scaleDecrease in scale
Change in prioritizationChange in prioritization
Change in deployment timingChange in deployment timing
Change in work being doneChange in work being done
Other changeOther change


GhStatus - Domain

DomainNameGhStatus
DescriptionThe status of the grid hardening activity.
FieldTypeString
Domain TypeCodedValue

CodeName
PlannedPlanned
In progressIn progress
CompleteComplete
CancelledCancelled


HFTD - Domain

DomainNameHFTD
DescriptionThe CPUC high-fire threat district area the asset intersects.
FieldTypeString
Domain TypeCodedValue

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


InitiativeActivity - Domain

DomainNameInitiativeActivity
DescriptionInitiative activities related to the grid hardening project.
FieldTypeString
Domain TypeCodedValue

CodeName
Capacitor maintenance and replacementCapacitor maintenance and replacement
Circuit breaker maintenance and installationCircuit breaker maintenance and installation
Conductor replacementConductor replacement
Covered conductor installationCovered conductor installation
Covered conductor maintenanceCovered conductor maintenance
Crossarm maintenance, repair, and replacementCrossarm maintenance, repair, and replacement
Expulsion fuse replacementExpulsion fuse replacement
Grid topology improvements to mitigate or reduce PSPS eventsGrid topology improvements to mitigate or reduce PSPS events
Installation of system automation equipmentInstallation of system automation equipment
Installation of sectionalizing equipmentInstallation of sectionalizing equipment
Maintenance, repair, and replacement of connectors, including hotline clampsMaintenance, repair, and replacement of connectors, including hotline clamps
Other corrective actionOther corrective action
Pole replacementPole replacement
Pole reinforcementPole reinforcement
Transformer maintenance and replacementTransformer maintenance and replacement
Transmission tower maintenance and replacementTransmission tower maintenance and replacement
Undergrounding of electric lines and/or equipmentUndergrounding of electric lines and/or equipment
OtherOther


InspectionMethod - Domain

DomainNameInspectionMethod
DescriptionThe method by which the asset inspection was conducted.
FieldTypeString
Domain TypeCodedValue

CodeName
Drive byDrive by
Walk outWalk out
Aerial – droneAerial – drone
Aerial – helicopterAerial – helicopter
Remote sensing – Infrared/ThermalRemote sensing – Infrared/Thermal
Remote sensing – LiDARRemote sensing – LiDAR
OtherOther


InspectionTechnology - Domain

DomainNameInspectionTechnology
DescriptionThe technology that an inspector uses for the vegetation management inspection.
FieldTypeString
Domain TypeCodedValue

CodeName
Collector for ArcGISCollector for ArcGIS
Survey123 for ArcGISSurvey123 for ArcGIS
Workforce for ArcGISWorkforce for ArcGIS
ArcGIS QuickCaptureArcGIS QuickCapture
OtherOther
NoneNone


InspectionType - Domain

DomainNameInspectionType
DescriptionThe type of asset inspection performed.
FieldTypeString
Domain TypeCodedValue

CodeName
PatrolPatrol
DetailedDetailed
Pole loadingPole loading
OtherOther


IsolationDevice - Domain

DomainNameIsolationDevice
DescriptionThe device which isolated the circuit during the PSPS event.
FieldTypeString
Domain TypeCodedValue

CodeName
Circuit BreakerCircuit Breaker
FuseFuse
SwitchSwitch
OtherOther


IsolationDeviceType - Domain

DomainNameIsolationDeviceType
DescriptionType of protective device that operated.
FieldTypeString
Domain TypeCodedValue

CodeName
Circuit BreakerCircuit Breaker
FuseFuse
Lightning ArrestorLightning Arrestor
SwitchSwitch
OtherOther


LandDesignation - Domain

DomainNameLandDesignation
DescriptionThe assigned designation of the land where the subject vegetation management project is scheduled.
FieldTypeString
Domain TypeCodedValue

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


MaterialAtOrigin - Domain

DomainNameMaterialAtOrigin
DescriptionFuel material for the ignition origin.
FieldTypeString
Domain TypeCodedValue

CodeName
VegetationVegetation
StructureStructure
OtherOther


ObjectContact - Domain

DomainNameObjectContact
DescriptionDescription of object involved in the contact.
FieldTypeString
Domain TypeCodedValue

CodeName
Vegetation contactVegetation contact
Animal contactAnimal contact
Balloon contactBalloon contact
Vehicle contact - car poleVehicle contact - car pole
Vehicle contact - aircraftVehicle contact - aircraft
3rd party contact3rd party contact
UnknownUnknown
N/AN/A


OhUg - Domain

DomainNameOhUg
DescriptionIs the asset overhead or underground?
FieldTypeString
Domain TypeCodedValue

CodeName
OverheadOverhead
UndergroundUnderground
UnknownUnknown


OriginLandUse - Domain

DomainNameOriginLandUse
DescriptionStatus of land at origin of ignition.
FieldTypeString
Domain TypeCodedValue

CodeName
RuralRural
UrbanUrban


OtherAssetDamageDescription - Domain

DomainNameOtherAssetDamageDescription
DescriptionDescription of damage.
FieldTypeString
Domain TypeCodedValue

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


OutageInterval - Domain

DomainNameOutageInterval
DescriptionIndication of whether the subject outage was momentary or sustained
FieldTypeString
Domain TypeCodedValue

CodeName
MomentaryMomentary
SustainedSustained


PerformedBy - Domain

DomainNamePerformedBy
DescriptionWho performed the asset inspection?
FieldTypeString
Domain TypeCodedValue

CodeName
Utility staffUtility staff
ContractorContractor
OtherOther


ProjectCategory - Domain

DomainNameProjectCategory
DescriptionHigh-level category describing the nature of the vegetation management project.
FieldTypeString
Domain TypeCodedValue

CodeName
Tree trimmingTree trimming
Tree removalTree removal
Fuel managementFuel management
Assessing trees with the potential to strikeAssessing trees with the potential to strike
OtherOther


PspsAsset - Domain

DomainNamePspsAsset
DescriptionSpecific type of asset that is damaged.
FieldTypeString
Domain TypeCodedValue

CodeName
PolePole
TowerTower
CrossarmCrossarm
Secondary armsSecondary arms
OtherOther


PspsOtherAsset - Domain

DomainNamePspsOtherAsset
DescriptionSpecific type of asset that is damaged.
FieldTypeString
Domain TypeCodedValue

CodeName
Down guyDown guy
NeutralNeutral
Service neutralService neutral
Span guySpan guy
Tie wireTie wire
Wood pinWood pin
AnchorAnchor
OtherOther


RecloserSetting - Domain

DomainNameRecloserSetting
DescriptionIf the subject circuit is equipped with reclosing capabilities, indicate whether the reclose function was enabled or disabled at the time of the outage.
FieldTypeString
Domain TypeCodedValue

CodeName
EnabledEnabled
DisabledDisabled
N/AN/A


SpeciesGrowthRate - Domain

DomainNameSpeciesGrowthRate
DescriptionGeneralized growth rate of the subject tree species.
FieldTypeString
Domain TypeCodedValue

CodeName
Slow growingSlow growing
Moderately growingModerately growing
Fast growingFast growing


SubareaType - Domain

DomainNameSubareaType
DescriptionUtility subarea type.
FieldTypeString
Domain TypeCodedValue

CodeName
OperationalOperational
ConstructionConstruction
WeatherWeather
OrganizationalOrganizational
OtherOther


SubstationType - Domain

DomainNameSubstationType
DescriptionType of substation
FieldTypeString
Domain TypeCodedValue

CodeName
NetworkNetwork
LoopLoop
RadialRadial


SupportStructureDamageDescription - Domain

DomainNameSupportStructureDamageDescription
DescriptionDescription of damage for support structure.
FieldTypeString
Domain TypeCodedValue

CodeName
Broken poleBroken pole
Damaged poleDamaged pole
Broken towerBroken tower
Damaged towerDamaged tower
Broken crossarmBroken crossarm
Damaged crossarmDamaged crossarm
OtherOther


SupportStructureMaterial - Domain

DomainNameSupportStructureMaterial
DescriptionMaterial from which pole, tower, or crossarm is made
FieldTypeString
Domain TypeCodedValue

CodeName
WoodWood
MetalMetal
CompositeComposite
Wrapped woodWrapped wood
ConcreteConcrete
OtherOther


SupportStructureType - Domain

DomainNameSupportStructureType
DescriptionType of support structure
FieldTypeString
Domain TypeCodedValue

CodeName
PolePole
TowerTower
OtherOther


SuppressedBy - Domain

DomainNameSuppressedBy
DescriptionEntity responsible for suppressing ignition.
FieldTypeString
Domain TypeCodedValue

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


SuspectedCause - Domain

DomainNameSuspectedCause
DescriptionHigh-level category for wire down event cause.
FieldTypeString
Domain TypeCodedValue

CodeName
Object contactObject contact
Equipment failureEquipment failure
Wire-to-wire contactWire-to-wire contact
ContaminationContamination
Utility work/OperationUtility work/Operation
Vandalism/TheftVandalism/Theft
UnknownUnknown
OtherOther


TransformerSubtype - Domain

DomainNameTransformerSubtype
DescriptionSpecific subtype of the transformer.
FieldTypeString
Domain TypeCodedValue

CodeName
Single phase pad-mountedSingle phase pad-mounted
Single phase subsurfaceSingle phase subsurface
Single phase overheadSingle phase overhead
Three phase pad-mountedThree phase pad-mounted
Three phase subsurfaceThree phase subsurface
Three phase overheadThree phase overhead


VegetationTreatmentType - Domain

DomainNameVegetationTreatmentType
DescriptionThe type(s) of treatment scoped into the vegetation management project.
FieldTypeString
Domain TypeCodedValue

CodeName
Radial clearance – standardRadial clearance – standard
Radial clearance - enhancedRadial clearance - enhanced
Overhang clearingOverhang clearing
Tree removal – hazard treeTree removal – hazard tree
Tree removal – tree mortalityTree removal – tree mortality
Tree trimmingTree trimming
Pole brushingPole brushing
Fire break creationFire break creation
Brush clearanceBrush clearance
Other or multiple treatment typesOther or multiple treatment types


VmInspectionType - Domain

DomainNameVmInspectionType
DescriptionInitiative activities related to the vegetation management project.
FieldTypeString
Domain TypeCodedValue

CodeName
Assessing trees with the potential to strikeAssessing trees with the potential to strike
Clearances – routineClearances – routine
Clearances – enhancedClearances – enhanced
Hazard treesHazard trees
Tree mortalityTree mortality
OtherOther


VmiStatus - Domain

DomainNameVmiStatus
DescriptionStatus of the vegetation management project.
FieldTypeString
Domain TypeCodedValue

CodeName
PlannedPlanned
In progressIn progress
CompleteComplete


VmpStatus - Domain

DomainNameVmpStatus
DescriptionStatus of the vegetation management project.
FieldTypeString
Domain TypeCodedValue

CodeName
CompleteComplete
In progressIn progress
PlannedPlanned
DelayedDelayed
CancelledCancelled


YesNo - Domain

DomainNameYesNo
DescriptionYes or No
FieldTypeString
Domain TypeCodedValue

CodeName
YesYes
NoNo


YesNoNA - Domain

DomainNameYesNoNA
DescriptionYes, No or N/A
FieldTypeString
Domain TypeCodedValue

CodeName
YesYes
NoNo
N/AN/A


YesNoUnknown - Domain

DomainNameYesNoUnknown
DescriptionYes, No, or Unknown
FieldTypeString
Domain TypeCodedValue

CodeName
YesYes
NoNo
UnknownUnknown