projects / scannr.git / blame
search:
summary | shortlog | log | commit | commitdiff | tree
plain | HEAD | blame
Merge branch 'master' of ssh://maxious.lambdacomplex.org/git/scannr
[scannr.git] / tgid.csv
Alex Sadleir 1 Decimal,Subfleet,Alpha Tag,Mode,Description,Service Tag,Category,"insert into tgids (tgid,alpha_tag) (SELECT distinct ""tgid"", ""tgname"" as alpha_tag
2 FROM ""recordings"" order by tgid)"
3 10000,,GL 1,D,GL 1,Fire-Tac,Rural Fire Service RFS,
4 10001,,GL 2,D,GL 2,Fire-Tac,Rural Fire Service RFS,
5 10002,,GL 3,D,GL 3,Fire-Tac,Rural Fire Service RFS,
6 10003,,GL 4,D,GL 4,Fire-Tac,Rural Fire Service RFS,
7 10004,,GL 5,D,GL 5,Fire-Tac,Rural Fire Service RFS,
8 10005,,GL 6,D,GL 6,Fire-Tac,Rural Fire Service RFS,
9 10006,,GL 7,D,GL 7,Fire-Tac,Rural Fire Service RFS,
10 10007,,GL 8,D,GL 8,Fire-Tac,Rural Fire Service RFS,
11 10008,,GL 9,D,GL 9,Fire-Tac,Rural Fire Service RFS,
12 10009,,GL 10,D,GL 10,Fire-Tac,Rural Fire Service RFS,
13 10010,,ESO 1,D,ESO 1,Fire-Tac,Rural Fire Service RFS,
14 10011,,ESO 2,D,ESO 2,Fire-Tac,Rural Fire Service RFS,
15 10012,,ESO 3,D,ESO 3,Fire-Tac,Rural Fire Service RFS,
16 10013,,ESO 4,D,ESO 4,Fire-Tac,Rural Fire Service RFS,
17 10014,,ESO 5,D,ESO 5,Fire-Tac,Rural Fire Service RFS,
18 10015,,ESO 6,D,ESO 6,Fire-Tac,Rural Fire Service RFS,
19 10016,,ESO 7,D,ESO 7,Fire-Tac,Rural Fire Service RFS,
20 10017,,ESO 8,D,ESO 8,Fire-Tac,Rural Fire Service RFS,
21 10018,,ESO 9,D,ESO 9,Fire-Tac,Rural Fire Service RFS,
22 10019,,ESO 10,D,ESO 10,Fire-Tac,Rural Fire Service RFS,
23 10020,,ESO 11,D,ESO 11,Fire-Tac,Rural Fire Service RFS,
24 10021,,ESO 12,D,ESO 12,Fire-Tac,Rural Fire Service RFS,
25 10022,,ESO 13,D,ESO 13,Fire-Tac,Rural Fire Service RFS,
26 10023,,ESO 14,D,ESO 14,Fire-Tac,Rural Fire Service RFS,
27 10024,,ESO 15,D,ESO 15,Fire-Tac,Rural Fire Service RFS,
28 10025,,ESO 16,D,ESO 16,Fire-Tac,Rural Fire Service RFS,
29 10026,,ESO 17,D,ESO 17,Fire-Tac,Rural Fire Service RFS,
30 10027,,ESO 18,D,ESO 18,Fire-Tac,Rural Fire Service RFS,
31 10028,,ESO 19,D,ESO 19,Fire-Tac,Rural Fire Service RFS,
32 10029,,ESO 20,D,ESO 20,Fire-Tac,Rural Fire Service RFS,
33 10030,,AVIATN1,D,RFS GD01 AVIATN1,Fire-Tac,Rural Fire Service RFS,
34 10031,,AVIATN2,D,RFS GD02 AVIATN2,Fire-Tac,Rural Fire Service RFS,
35 10032,,AVIATN3,D,RFS GD03 AVIATN3,Fire-Tac,Rural Fire Service RFS,
36 10033,,AVIATN4,D,RFS GD04 AVIATN4,Fire-Tac,Rural Fire Service RFS,
37 10034,,AVIATN5,D,RFS GD05 AVIATN5,Fire-Tac,Rural Fire Service RFS,
38 10035,,AVIATN6,D,RFS GD06 AVIATN6,Fire-Tac,Rural Fire Service RFS,
39 10036,,BLKM HL,D,RFS GD08 BLKM HL,Fire-Tac,Rural Fire Service RFS,
40 10037,,BL MTNS,D,RFS GD10 BL MTNS,Fire-Tac,Rural Fire Service RFS,
41 10038,,CISS,D,RFS GD14 CISS,Fire-Tac,Rural Fire Service RFS,
42 10039,,COM ED1,D,RFS GD16 COM ED1,Fire-Tac,Rural Fire Service RFS,
43 10040,,COM ED2,D,RFS GD17 COM ED2,Fire-Tac,Rural Fire Service RFS,
44 10041,,COM ED3,D,RFS GD18 COM ED3,Fire-Tac,Rural Fire Service RFS,
45 10042,,CMBRLND,D,RFS GD20 CMBRLND,Fire-Tac,Rural Fire Service RFS,
46 10043,,EAST OP,D,RFS GD21 EAST OP,Fire-Tac,Rural Fire Service RFS,
47 10044,,EXEC OP,D,RFS GD22 EXEC OP,Fire-Tac,Rural Fire Service RFS,
48 10045,,FIU 1,D,RFS GD26 FIU 1,Fire-Tac,Rural Fire Service RFS,
49 10046,,FIU 2,D,RFS GD27 FIU 2,Fire-Tac,Rural Fire Service RFS,
50 10047,,GOSFORD,D,RFS GD28 GOSFORD,Fire-Tac,Rural Fire Service RFS,
51 10048,,HAWKESB,D,RFS GD29 HAWKESB,Fire-Tac,Rural Fire Service RFS,
52 10049,,HORNSBY,D,RFS GD30 HORNSBY,Fire-Tac,Rural Fire Service RFS,
53 10050,,LDS 1,D,RFS GD38 LDS 1,Fire-Tac,Rural Fire Service RFS,
54 10051,,LDS 2,D,RFS GD39 LDS 2,Fire-Tac,Rural Fire Service RFS,
55 10052,,MCARTHR,D,RFS GD42 MCARTHR,Fire-Tac,Rural Fire Service RFS,
56 10053,,MEDIA 1,D,RFS GD44 MEDIA 1,Fire-Tac,Rural Fire Service RFS,
57 10054,,MEDIA 2,D,RFS GD45 MEDIA 2,Fire-Tac,Rural Fire Service RFS,
58 10055,,OP COM1,D,RFS GD58 OP COM1,Fire-Tac,Rural Fire Service RFS,
59 10056,,OP COM2,D,RFS GD59 OP COM2,Fire-Tac,Rural Fire Service RFS,
60 10057,,OP COM3,D,RFS GD60 OP COM3,Fire-Tac,Rural Fire Service RFS,
61 10058,,OPS1,D,RFS GD62 OPS1,Fire-Tac,Rural Fire Service RFS,
62 10059,,OPS2,D,RFS GD63 OPS2,Fire-Tac,Rural Fire Service RFS,
63 10060,,OPS3,D,RFS GD64 OPS3,Fire-Tac,Rural Fire Service RFS,
64 10061,,OPS4,D,RFS GD65 OPS4,Fire-Tac,Rural Fire Service RFS,
65 10062,,OPS5,D,RFS GD66 OPS5,Fire-Tac,Rural Fire Service RFS,
66 10063,,OPS6,D,RFS GD67 OPS6,Fire-Tac,Rural Fire Service RFS,
67 10064,,OPS7,D,RFS GD68 OPS7,Fire-Tac,Rural Fire Service RFS,
68 10065,,OPS8,D,RFS GD69 OPS8,Fire-Tac,Rural Fire Service RFS,
69 10066,,OPS9,D,RFS GD70 OPS9,Fire-Tac,Rural Fire Service RFS,
70 10067,,OPS10,D,RFS GD71 OPS10,Fire-Tac,Rural Fire Service RFS,
71 10068,,OPS11,D,RFS GD72 OPS11,Fire-Tac,Rural Fire Service RFS,
72 10069,,OPS12,D,RFS GD73 OPS12,Fire-Tac,Rural Fire Service RFS,
73 10070,,OPS13,D,RFS GD74 OPS13,Fire-Tac,Rural Fire Service RFS,
74 10071,,OPS14,D,RFS GD75 OPS14,Fire-Tac,Rural Fire Service RFS,
75 10072,,OPS15,D,RFS GD76 OPS15,Fire-Tac,Rural Fire Service RFS,
76 10073,,RGN EST,D,RFS GD77 RGN EST,Fire-Tac,Rural Fire Service RFS,
77 10074,,STATEOP,D,RFS GD87 STATEOP,Fire-Tac,Rural Fire Service RFS,
78 10075,,STHRLND,D,RFS GD88 STHRLND,Fire-Tac,Rural Fire Service RFS,
79 10076,,WARINGH,D,RFS GD91 WARINGH,Fire-Tac,Rural Fire Service RFS,
80 10077,,WOLONDL,D,RFS GD94 WOLONDL,Fire-Tac,Rural Fire Service RFS,
81 10101,,SYD 1,D,SYD 1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
82 10102,,SYD 2,D,SYD 2,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
83 10103,,SYD 3,D,SYD 3,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
84 10104,,SYD 4,D,SYD 4,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
85 10105,,SYD 6,D,SYD 6,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
86 10106,,SYD 7,D,SYD 7,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
87 10107,,SYD 8,D,SYD 8,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
88 10108,,SYD 9,D,SYD 9,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
89 10109,,SYD 10,D,SYD 10,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
90 10110,,SYD 11,D,SYD 11,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
91 10111,,SYD 12,D,SYD 12,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
92 10112,,New 1,D,New 1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
93 10113,,New 2,D,New 2,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
94 10114,,Gos 1,D,Gos 1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
95 10115,,Gos 2,D,Gos 2,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
96 10117,,HAST 1,D,HAST 1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
97 10118,,SUMLND1,D,SUMLND1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
98 10119,,PEEL 1,D,PEEL 1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
99 10120,,WOLL 1,D,WOLL 1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
100 10121,,WOLL 2,D,WOLL 2,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
101 10122,,SHIGH1,D,SHIGH1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
102 10123,,GOULB1,D,GOULB1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
103 10124,,MONARO1,D,MONARO1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
104 10125,,SCST 1,D,SCST 1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
105 10126,,ACTNSW,D,ACTNSW,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
106 10127,,GRIFFTH,D,GRIFFTH,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
107 10128,,MURRAY1,D,MURRAY1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
108 10129,,CWEST1,D,CWEST1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
109 10130,,BLU MT1,D,BLU MT1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
110 10131,,BLU MT2,D,BLU MT2,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
111 10132,,BOGAN 1,D,BOGAN 1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
112 10133,,LACHLN1,D,LACHLN1,Fire Dispatch,Fire and Rescue New South Wales FRNSW,
113 10134,,Ops 1,D,Special Operations 1,Fire-Tac,Fire and Rescue New South Wales FRNSW,
114 10135,,Ops 2,D,Special Operations 2,Fire-Tac,Fire and Rescue New South Wales FRNSW,
115 10136,,Ops 3,D,Special Operations 3,Fire-Tac,Fire and Rescue New South Wales FRNSW,
116 10137,,Ops 4,D,Special Operations 4,Fire-Tac,Fire and Rescue New South Wales FRNSW,
117 10138,,Ops 5,D,Special Operations 5,Fire-Tac,Fire and Rescue New South Wales FRNSW,
118 10139,,Ops 6,D,Special Operations 6,Fire-Tac,Fire and Rescue New South Wales FRNSW,
119 10144,,Ops 11,D,Special Operations 11,Fire-Tac,Fire and Rescue New South Wales FRNSW,
120 10145,,Ops 12,D,Special Operations 12,Fire-Tac,Fire and Rescue New South Wales FRNSW,
121 10146,,Ops 13,D,Special Operations 13,Fire-Tac,Fire and Rescue New South Wales FRNSW,
122 10147,,Ops 14,D,Special Operations 14,Fire-Tac,Fire and Rescue New South Wales FRNSW,
123 10148,,Ops 15,D,Special Operations 15,Fire-Tac,Fire and Rescue New South Wales FRNSW,
124 10149,,Ops 16,D,Special Operations 16,Fire-Tac,Fire and Rescue New South Wales FRNSW,
125 10154,,Comms,D,Communications,Fire-Talk,Fire and Rescue New South Wales FRNSW,
126 10155,,Property,D,Property,Fire-Talk,Fire and Rescue New South Wales FRNSW,
127 10156,,Fleet,D,Fleet,Fire-Talk,Fire and Rescue New South Wales FRNSW,
128 10157,,Admin,D,Administration,Fire-Talk,Fire and Rescue New South Wales FRNSW,
129 10158,,Mech,D,Mechanics,Fire-Talk,Fire and Rescue New South Wales FRNSW,
130 10159,,Eng,D,Engineers,Fire-Talk,Fire and Rescue New South Wales FRNSW,
131 10160,,Op Comms,D,Operation Communications,Fire-Talk,Fire and Rescue New South Wales FRNSW,
132 10161,,Hazmat,D,BAHazmat,Fire-Talk,Fire and Rescue New South Wales FRNSW,
133 10162,,Bushfire,D,Bushfire,Fire-Talk,Fire and Rescue New South Wales FRNSW,
134 10163,,FIU,D,Fire Investigation Unit,Fire-Talk,Fire and Rescue New South Wales FRNSW,
135 10164,,Fire Prev,D,Fire Prevention,Fire-Talk,Fire and Rescue New South Wales FRNSW,
136 10165,,Train,D,Training,Fire-Talk,Fire and Rescue New South Wales FRNSW,
137 10166,,Rescue,D,Rescue,Fire-Talk,Fire and Rescue New South Wales FRNSW,
138 10201,,SNTAC1,D,SES 307SNTAC1,EMS-Tac,State Emergency Service SES,
139 10202,,SNTAC2,D,SES 308SNTAC2,EMS-Tac,State Emergency Service SES,
140 10203,,SNTAC3,D,SES 309SNTAC3,EMS-Tac,State Emergency Service SES,
141 10204,,SNTAC4,D,SES 310SNTAC4,EMS-Tac,State Emergency Service SES,
142 10205,,SNTAC5,D,SES 311SNTAC5,EMS-Tac,State Emergency Service SES,
143 10206,,SNTAC6,D,SES 312SNTAC6,EMS-Tac,State Emergency Service SES,
144 10207,,SNSTRAT,D,SES 314SNSTRAT,EMS-Tac,State Emergency Service SES,
145 10208,,SSTAC1,D,SES 316SSTAC1,EMS-Tac,State Emergency Service SES,
146 10209,,SSTAC2,D,SES 317SSTAC2,EMS-Tac,State Emergency Service SES,
147 10210,,SSTAC3,D,SES 318SSTAC3,EMS-Tac,State Emergency Service SES,
148 10211,,SSTAC4,D,SES 319SSTAC4,EMS-Tac,State Emergency Service SES,
149 10212,,SSTAC5,D,SES 320SSTAC5,EMS-Tac,State Emergency Service SES,
150 10213,,SSTAC6,D,SES 321SSTAC6,EMS-Tac,State Emergency Service SES,
151 10214,,SSSTRAT,D,SES 323SSSTRAT,EMS-Tac,State Emergency Service SES,
152 10215,,SWTAC1,D,SES 324SWTAC1,EMS-Tac,State Emergency Service SES,
153 10216,,SWTAC2,D,SES 325SWTAC2,EMS-Tac,State Emergency Service SES,
154 10217,,SWTAC3,D,SES 326SWTAC3,EMS-Tac,State Emergency Service SES,
155 10218,,SWTAC4,D,SES 327SWTAC4,EMS-Tac,State Emergency Service SES,
156 10219,,SWTAC5,D,SES 328SWTAC5,EMS-Tac,State Emergency Service SES,
157 10220,,SWTAC6,D,SES 329SWTAC6,EMS-Tac,State Emergency Service SES,
158 10221,,SWSTRAT,D,SES 331SWSTRAT,EMS-Tac,State Emergency Service SES,
159 10222,,SWRCR,D,SES 332SWRCR,EMS-Tac,State Emergency Service SES,
160 10223,,HNCNT1,D,SES 340HNCNT1,EMS-Tac,State Emergency Service SES,
161 10224,,HNCNT2,D,SES 341HNCNT2,EMS-Tac,State Emergency Service SES,
162 10225,,HNCNT3,D,SES 342HNCNT3,EMS-Tac,State Emergency Service SES,
163 10226,,HNCNT4,D,SES 343HNCNT4,EMS-Tac,State Emergency Service SES,
164 10227,,HNCNT5,D,SES 344HNCNT5,EMS-Tac,State Emergency Service SES,
165 10228,,TRNSPRT,D,SES 347TRNSPRT,EMS-Tac,State Emergency Service SES,
166 10229,,COORD,D,SES 348COORD,EMS-Tac,State Emergency Service SES,
167 10230,,TSKFCE1,D,SES 349TSKFCE1,EMS-Tac,State Emergency Service SES,
168 10231,,TSKFCE2,D,SES 350TSKFCE2,EMS-Tac,State Emergency Service SES,
169 10232,,TSKFCE3,D,SES 351TSKFCE3,EMS-Tac,State Emergency Service SES,
170 10233,,TSKFCE4,D,SES 352TSKFCE4,EMS-Tac,State Emergency Service SES,
171 10234,,SOPS1,D,SES 353SOPS1,EMS-Tac,State Emergency Service SES,
172 10235,,SOPS2,D,SES 354SOPS2,EMS-Tac,State Emergency Service SES,
173 10236,,SOPS3,D,SES 355SOPS3,EMS-Tac,State Emergency Service SES,
174 10237,,SOPS4,D,SES 356SOPS4,EMS-Tac,State Emergency Service SES,
175 10238,,SOPS5,D,SES 357SOPS5,EMS-Tac,State Emergency Service SES,
176 10239,,SOPS6,D,SES 358SOPS6,EMS-Tac,State Emergency Service SES,
177 10240,,SOPS7,D,SES 359SOPS7,EMS-Tac,State Emergency Service SES,
178 10241,,SOPS8,D,SES 360SOPS8,EMS-Tac,State Emergency Service SES,
179 10242,,SOPS9,D,SES 361SOPS9,EMS-Tac,State Emergency Service SES,
180 10243,,SOPS10,D,SES 362SOPS10,EMS-Tac,State Emergency Service SES,
181 10244,,SOPS11,D,SES 363SOPS11,EMS-Tac,State Emergency Service SES,
182 10245,,SOPS12,D,SES 364SOPS12,EMS-Tac,State Emergency Service SES,
183 10246,,COMMS1,D,SES 367COMMS1,EMS-Tac,State Emergency Service SES,
184 10247,,DOCSLO,D,SES 345DOCSLO,EMS-Tac,State Emergency Service SES,
185 10248,,DOCSST,D,SES 346DOCSST,EMS-Tac,State Emergency Service SES,
186 10301,,MRU,D,Administration 1 State Ops MRU,EMS Dispatch,Ambulance Service of New South Wales ASNSW,
187 10302,,Admin 2,D,Administration 2,EMS Dispatch,Ambulance Service of New South Wales ASNSW,
188 10303,,Admin 3,D,Administration 3,EMS Dispatch,Ambulance Service of New South Wales ASNSW,
189 10304,,Admin 4,D,Administration 4,EMS Dispatch,Ambulance Service of New South Wales ASNSW,
190 10305,,Admin 5,D,Administration 5,EMS Dispatch,Ambulance Service of New South Wales ASNSW,
191 10306,,NETS,D,Administration 6 NETS,EMS Dispatch,Ambulance Service of New South Wales ASNSW,
192 10307,,7 PUB HLTH,,Administration Public Health Service Liaison,,Ambulance Service of New South Wales ASNSW,
193 10308,,8 GWEST AH,,Administration Greater West AHS,,Ambulance Service of New South Wales ASNSW,
194 10309,,ASNSW,D,ASNSW,EMS-Talk,Ambulance Service of New South Wales ASNSW,
195 10310,,10 NSCC AH,,Administration North SydneyCentral Coast AHS,,Ambulance Service of New South Wales ASNSW,
196 10311,,11 SW AH,,Administration Sydney West AHS,,Ambulance Service of New South Wales ASNSW,
197 10312,,12 SSW AH,,Administration Sydney South West AHS,,Ambulance Service of New South Wales ASNSW,
198 10313,,13 SESI AH,,Administration South Eastern SydneyIllawarra AHS,,Ambulance Service of New South Wales ASNSW,
199 10314,,14 AH INCDT,,Administration AHS Incident 1,,Ambulance Service of New South Wales ASNSW,
200 10315,,15 AH INCDT,,Administration AHS Incident 2,,Ambulance Service of New South Wales ASNSW,