The PG&E Transformer Database and the Metcalf Sniper
Notes
Arrived Dec 2010
Source: Fake Vendor
Project: Dubious
Content: Domestic Terrorist Toolbox
Theory: Shootout transformer to generate business
Suspects: Powerful Plaintiff Attorneys
Suspects: Powerful Plaintiff Attorneys
Transformers for Sale?
Name Type Size
Proposal number Long Integer 4
Customer name Text 50
Proposal location Text 50
Proposal description Text 50
LV airswitch count Long Integer 4
LV airswitch location count Long Integer 4
MV airswitch count Long Integer 4
MV airswitch location count Long Integer 4
HV outdoor substation class airswitch count Long Integer 4
HV outdoor substation class airswitch location Long Integer 4
LV primary injection fixed breaker over 2000A Long Integer 4
LV primary injection draw out breaker over Long Integer 4
LV primary injection fixed breaker under Long Integer 4
LV primary injection draw out breaker under Long Integer 4
LV primary injection location count Long Integer 4
LV secondary injection breaker count Long Integer 4
LV ground fault count Long Integer 4
MV breaker count Long Integer 4
MV breaker location count Long Integer 4
HV breaker count Long Integer 4
HV breaker location count Long Integer 4
Time travel for HV breaker count Long Integer 4
Switchboards to clean count Long Integer 4
LV motor starter count Long Integer 4
LV motor starter number of locations Long Integer 4
LV MCC to clean count Long Integer 4
MV vacuum motor contactors count Long Integer 4
MV air motor contactors count Long Integer 4
MV contactor location count Long Integer 4
MV motor overload relay count Long Integer 4
MV motor multifunction relay count Long Integer 4
MV MCC to clean count Long Integer 4
Thermoscan count (1 or 0) Long Integer 4
Electro-mechanical overcurrent relay count Long Integer 4
Electro-mechanical voltage relay count Long Integer 4
Electro-mechanical directional relay Long Integer 4
Electro-mechanical generator differential relay Long Integer 4
Elecrto-mechanical transformer differential Long Integer 4
Electro-mechanical distance relay count Long Integer 4
Electro-mechanical synch-check relay count Long Integer 4
Electro-mechanical other relay count Long Integer 4
Solid state overcurrent relay count Long Integer 4
Solid state voltage relay count Long Integer 4
Solid state differential count Long Integer 4
Solid state mutlifunction relay Long Integer 4
Solid state distance relay count Long Integer 4
Solid state synch-check relay count Long Integer 4
Solid state other relay count Long Integer 4
Relay location count Long Integer 4
Current transformer count Long Integer 4
CT location count Long Integer 4
Potential transformer count Long Integer 4
PT location count Long Integer 4
MV/HV breaker wiring check count Long Integer 4
HV protection functional check Long Integer 4
ATS count Long Integer 4
Single finction panel meter count Long Integer 4
Multi function panel meter count Long Integer 4
Transformer above 30MVA count Long Integer 4
Transformer from 10 to 30MVA count Long Integer 4
Transfomer from 1/2 to 10 MVA count Long Integer 4
Transformer from 100 to 500KVA count Long Integer 4
Transformer less than 100KVA Long Integer 4
35Kv run hypot count Long Integer 4
25Kv run hypot count Long Integer 4
15Kv run hypot count Long Integer 4
5Kv run hypot count Long Integer 4
600V run megger count Long Integer 4
Generator 2000-3000KVA load bank count Long Integer 4
Generator load bank below 2000KVA count Long Integer 4
Grounding resistor count Long Integer 4
Grounding tests Long Integer 4
Bid Rate Long Integer 4
END