Skip to content

Instantly share code, notes, and snippets.

View mmcelhan's full-sized avatar

Matt mmcelhan

1 follower · 1 following
View GitHub Profile
@mmcelhan
mmcelhan / 10NOV2019_sf_entries
Created November 10, 2019 18:50
This file has been truncated, but you can view the full file.
surfaceFailureDate,surfaceFailureType,surfaceFailureComponent,surfaceFailureSubComponent,surfaceFailureManufacturer,surfaceFailureModel,surfaceFailureRootCause,surfaceFailureDamages,anonymized_user,anonymized_asset,anonymized_latitude,anonymized_longitude
12/15/2017,Separator,Temp Control System,Pilot Valve,,,,Tripped out. Reset Burner ,user_156,asset_816,48.20742159,-103.6136759
7/4/2018,Wellhead,Tubing,,,,hydrate,Hydrate in wellhead. Methanol going. ,user_107,asset_1980,,
3/17/2018,Compressor,Compressor (Recip),Scrubber Level,,,,Drained scrubbers,user_46,asset_1841,48.0614644,-104.8417043
3/10/2018,Gas Scrubber Separator,ESD,,,,,Issue: well called out shut in alarm. (INT) valve fault Root Cause: not sure I drained both scrubber and they were dry i drained the desi it was dry as well. i checked all the pressure setting everything looked good so i am not sure it it came from Williams end and froze but broke before i got there. Fix: turned well back on and returned to service ,user_136,asset_1437,48.1470144,-
@mmcelhan
mmcelhan / climate.csv
Created September 30, 2019 00:14
DATE PRCP SNOW SNWD TMAX TMIN
10/26/2016 0 0 0 62 34
10/27/2016 0 0 0 66 37
10/28/2016 0 0 0 62 40
10/29/2016 0.02 0 0 61 41
10/30/2016 0 0 0 62 40
10/31/2016 0.08 0 0 57 35
11/1/2016 0.08 0 0 57 27
11/2/2016 0.18 0 0 50 24
11/3/2016 0 0 0 57 19
@mmcelhan
mmcelhan / sf_entries.csv
Created September 29, 2019 15:55
We can't make this file beautiful and searchable because it's too large.
record_number,assetId,surfaceFailureDate,surfaceFailureType,surfaceFailureComponent,surfaceFailureSubComponent,surfaceFailureManufacturer,surfaceFailureModel,surfaceFailureRootCause,surfaceFailureDamages
0,1143,12/15/2017,Separator,Temp Control System,Pilot Valve,,,,"Tripped out. Reset
Burner "
1,2231,7/4/2018,Wellhead,Tubing,,,,hydrate,Hydrate in wellhead. Methanol going.
2,622,3/17/2018,Compressor,Compressor (Recip),Scrubber Level,,,,Drained scrubbers
3,1938,3/10/2018,Gas Scrubber Separator,ESD,,,,,"Issue: well called out shut in alarm. (INT) valve fault
Root Cause: not sure I drained both scrubber and they were dry i drained the desi it was dry as well. i checked all the pressure setting everything looked good so i am not sure it it came from Williams end and froze but broke before i got there.
Fix: turned well back on and returned to service
"
4,1479,6/6/2019,Separator,Choke Valve,Body,,,,The choke stem was seized in the body and needed to be repaired.
@mmcelhan
mmcelhan / noise.json
Created September 17, 2019 17:23
This file has been truncated, but you can view the full file.
[
{
"text": "<@U1UKBLZLH|pablo.arvizu> has joined the channel",
"type": "message",
"user": "U1UKBLZLH",
"ts": "1413008179.000000",
"subtype": "channel_join"
},
{
"text": "<@U1UKGCAP4|dan> has joined the channel",
@mmcelhan
mmcelhan / noise.json
Created September 17, 2019 17:23
This file has been truncated, but you can view the full file.
[
{
"text": "<@U1UKBLZLH|pablo.arvizu> has joined the channel",
"type": "message",
"user": "U1UKBLZLH",
"ts": "1413008179.000000",
"subtype": "channel_join"
},
{
"text": "<@U1UKGCAP4|dan> has joined the channel",