Skip to content

Instantly share code, notes, and snippets.

@jacobtoye
Created July 21, 2015 20:06
Show Gist options
  • Save jacobtoye/e55a0c90220dc0bcfe5e to your computer and use it in GitHub Desktop.
Save jacobtoye/e55a0c90220dc0bcfe5e to your computer and use it in GitHub Desktop.
Type,ID,Value,ParentID
DEPARTMENT,1911,Plant - Surplus,19
DEPARTMENT,1912,Plant - Disposal,19
DEPARTMENT,1920,Plant - Admin,19
DEPARTMENT,1921,Plant - TS ITS,19
DEPARTMENT,1922,Plant - Workshops,19
DEPARTMENT,1924,Plant - TS UFB,19
DEPARTMENT,3001,Products,30
DEPARTMENT,3040,Products,30
DEPARTMENT,3501,Products,35
DEPARTMENT,3502,Products,35
DEPARTMENT,3503,Products,35
DEPARTMENT,3504,Products,35
DEPARTMENT,3505,Products,35
DEPARTMENT,3507,Products,35
DEPARTMENT,3508,Products,35
DEPARTMENT,3509,Products,35
DEPARTMENT,3521,Products,35
DEPARTMENT,3522,Products,35
DEPARTMENT,3523,Products,35
DEPARTMENT,7001,Head Office,70
DEPARTMENT,8010,Projects,80
DEPARTMENT,8103,Projects,81
DEPARTMENT,8104,Projects,81
DEPARTMENT,8303,Projects,83
DEPARTMENT,8818,Projects,88
DEPARTMENT,8840,Projects,88
DEPARTMENT,55000,Road Maintenance Balance Sheet,55
DEPARTMENT,55102,Far North DC West - RCM,55
DEPARTMENT,55104,NZTA Northland Sth - RCM,55
DEPARTMENT,55105,Road Marking - Northland,55
DEPARTMENT,55106,Traffic Control - Northland,55
DEPARTMENT,55107,Construction - Northland,55
DEPARTMENT,55110,AT North Rural - RCM,55
DEPARTMENT,55111,AT Central - RCM,55
DEPARTMENT,55112,AT Hauraki Gulf Islands - RCM,55
DEPARTMENT,55113,AT South West Urban - RCM,55
DEPARTMENT,55119,Technical Services - Auckland,55
DEPARTMENT,55120,Traffic Control - Auckland,55
DEPARTMENT,55121,Roadmarking - Auckland,55
DEPARTMENT,55122,Construction - Auckland,55
DEPARTMENT,55130,Hamilton CC Alliance - RCM,55
DEPARTMENT,55131,Waikato DC Alliance - RCM,55
DEPARTMENT,55133,Traffic Control - Waikato,55
DEPARTMENT,55134,Road Marking - Waikato,55
DEPARTMENT,55135,Construction - Waikato,55
DEPARTMENT,55142,NZTA East Waikato - RCM,55
DEPARTMENT,55143,NZTA BOP West - RCM,55
DEPARTMENT,55144,Hauraki DC - RCM,55
DEPARTMENT,55145,Tauranga CC Footpath,55
DEPARTMENT,55146,Traffic Control - BOP,55
DEPARTMENT,55147,Road Marking - BOP,55
DEPARTMENT,55148,Construction - BOP,55
DEPARTMENT,55150,NZTA Central Waikato - RCM,55
DEPARTMENT,55151,South Waikato DC - RCM,55
DEPARTMENT,55152,Waitomo DC - RCM,55
DEPARTMENT,55153,Ruapehu DC - RCM,55
DEPARTMENT,55154,Construction - Central North,55
DEPARTMENT,55160,Chip Sealing - Northern,55
DEPARTMENT,55161,Asphalt Paving - Northern,55
DEPARTMENT,55162,Watercutting,55
DEPARTMENT,55163,Milling,55
DEPARTMENT,55164,Stabilising,55
DEPARTMENT,55165,Sealing Stock (Auckland),55
DEPARTMENT,55166,Sealing Stock (Waikato/BOP),55
DEPARTMENT,55168,Sealing Stock (Northland),55
DEPARTMENT,55170,NZTA Taranaki - RCM,55
DEPARTMENT,55171,Stratford DC - RCM,55
DEPARTMENT,55172,Road Marking - Taranaki,55
DEPARTMENT,55173,Construction - Taranaki,55
DEPARTMENT,55180,NZTA Hawkes Bay - RCM,55
DEPARTMENT,55181,NZTA Tairawhiti Roads - RCM,55
DEPARTMENT,55182,Gisborne DC Western - RCM,55
DEPARTMENT,55184,Hastings DC Urban - RCM,55
DEPARTMENT,55185,Construction - East Coast,55
DEPARTMENT,55186,Wairoa DC - RCM,55
DEPARTMENT,55187,Central Hawkes Bay - RCM,55
DEPARTMENT,55192,Quarry - WOK,55
DEPARTMENT,55193,Quarry - Arowhana,55
DEPARTMENT,55200,Rangitikei DC - RCM,55
DEPARTMENT,55201,Wanganui DC Alliance - RCM,55
DEPARTMENT,55202,Tararua DC Alliance - RCM,55
DEPARTMENT,55203,Construction - Mid Central,55
DEPARTMENT,55210,Wellington CC North/CBD - RCM,55
DEPARTMENT,55211,Porirua DC - RCM,55
DEPARTMENT,55213,Kapiti Coast DC - RCM,55
DEPARTMENT,55219,Kiwi Rail - Wellington,55
DEPARTMENT,55222,Construction - Wellington,55
DEPARTMENT,55223,Road Marking - Wellington,55
DEPARTMENT,55224,Traffic Control - Wellington,55
DEPARTMENT,55230,Chip Sealing - Central,55
DEPARTMENT,55231,Asphalt Paving - Central,55
DEPARTMENT,55235,Sealing Stock - Taranaki,55
DEPARTMENT,55236,Sealing Stock - Hawkes Bay,55
DEPARTMENT,55237,Sealing Stock - Wanganui,55
DEPARTMENT,55238,Sealing Stock - Gisborne,55
DEPARTMENT,55240,Sealing Stock - Wellington,55
DEPARTMENT,55302,NZTA Nelson / Tasman - RCM,55
DEPARTMENT,55303,Nelson CC - RCM,55
DEPARTMENT,55304,Nelson CC - York,55
DEPARTMENT,55305,NZTA West Coast North - RCM,55
DEPARTMENT,55306,Kaikoura DC - RCM,55
DEPARTMENT,55310,Construction - Nelson,55
DEPARTMENT,55311,Construction - West Coast,55
DEPARTMENT,55312,Construction - Kaikoura,55
DEPARTMENT,55313,Traffic Control - Nelson,55
DEPARTMENT,55330,Quarry - Bartletts,55
DEPARTMENT,55331,Quarry - Marsden,55
DEPARTMENT,55332,Quarry - Stevens Pit,55
DEPARTMENT,55360,NZTA North Canterbury - RCM,55
DEPARTMENT,55361,NZTA South Canterbury - RCM,55
DEPARTMENT,55362,Hurunui DC - RCM,55
DEPARTMENT,55363,Christchurch CC CBD - RCM,55
DEPARTMENT,55364,Chatham Islands C - RCM,55
DEPARTMENT,55365,Bio Security - Canterbury,55
DEPARTMENT,55366,Traffic Control - Canterbury,55
DEPARTMENT,55367,Construction - Christchurch,55
DEPARTMENT,55368,Construction - Timaru,55
DEPARTMENT,55369,Concrete Plant - Twizel,55
DEPARTMENT,55370,NZTA Coastal Otago - RCM,55
DEPARTMENT,55371,NZTA Milford Sound - RCM,55
DEPARTMENT,55372,Queenstown Lakes DC - RCM,55
DEPARTMENT,55373,Gore DC - RCM,55
DEPARTMENT,55374,Invercargill CC - RCM,55
DEPARTMENT,55375,Technical - Lower South,55
DEPARTMENT,55376,Road Marking - Lower South,55
DEPARTMENT,55377,Construction - Lower South,55
DEPARTMENT,55379,Quarry - Parkburn,55
DEPARTMENT,55380,Workshop - Lower South,55
DEPARTMENT,55381,Quarry - Smylers Peak,55
DEPARTMENT,55382,Quarry - Rongahere Rock,55
DEPARTMENT,55384,Asphalt Paving - South Island,55
DEPARTMENT,55385,Chip Sealing - South Island,55
DEPARTMENT,55387,Asphalt Paving - Central South,55
DEPARTMENT,55388,Chip Sealing - Central South,55
DEPARTMENT,55389,Asphalt Paving - Lower South,55
DEPARTMENT,55390,Chip Sealing - Lower South,55
DEPARTMENT,55391,Sealing Stock (Nelson),55
DEPARTMENT,55392,Sealing Stock (Otago/Sthld),55
DEPARTMENT,55399,Bid Projects,55
DEPARTMENT,55510,Whangarei Depot,55
DEPARTMENT,55512,Dargaville Depot,55
DEPARTMENT,55521,Warkworth Depot,55
DEPARTMENT,55522,Silverdale Depot (Water),55
DEPARTMENT,55524,Orewa Depot,55
DEPARTMENT,55528,Henderson Depot (Water),55
DEPARTMENT,55529,Waiheke Depot,55
DEPARTMENT,55530,Penrose Depot,55
DEPARTMENT,55532,Otahuhu (Dangerous Goods),55
DEPARTMENT,55534,Helensville Depot,55
DEPARTMENT,55536,Kerrs Road - OSM Depot,55
DEPARTMENT,55539,Kerrs Road - Head Office,55
DEPARTMENT,55540,Hamilton Depot,55
DEPARTMENT,55550,Palmerston Depot,55
DEPARTMENT,55552,Paeroa Depot,55
DEPARTMENT,55553,Tauranga Depot,55
DEPARTMENT,55556,Thames Depot,55
DEPARTMENT,55558,Chapel St Depot (Water),55
DEPARTMENT,55560,Raetihi Depot,55
DEPARTMENT,55563,Taumarunui Depot,55
DEPARTMENT,55564,Taupo Depot,55
DEPARTMENT,55566,Te Kuiti Depot,55
DEPARTMENT,55568,Tirau Depot,55
DEPARTMENT,55570,Hawera Depot,55
DEPARTMENT,55572,New Plymouth Depot,55
DEPARTMENT,55574,Stratford Depot,55
DEPARTMENT,55576,Whangamomona Depot,55
DEPARTMENT,55580,Gisborne Depot,55
DEPARTMENT,55582,Hastings Depot,55
DEPARTMENT,55584,Wairoa Depot,55
DEPARTMENT,55590,Palmerston North Depot,55
DEPARTMENT,55592,Marton Depot,55
DEPARTMENT,55594,Taihape Depot,55
DEPARTMENT,55596,Wanganui Depot,55
DEPARTMENT,55598,Tararua Depot,55
DEPARTMENT,55601,Lower Hutt Depot,55
DEPARTMENT,55602,Wellington Depot,55
DEPARTMENT,55604,Horowhenua Depot,55
DEPARTMENT,55606,Kiwi Point Depot,55
DEPARTMENT,55608,Wainuiomata Yard,55
DEPARTMENT,55610,Nelson Depot,55
DEPARTMENT,55612,Blenheim Depot,55
DEPARTMENT,55614,Engineers Camp (Lewis Pass),55
DEPARTMENT,55616,Murchison Depot,55
DEPARTMENT,55619,Reefton Depot,55
DEPARTMENT,55620,Springs Juntion Depot,55
DEPARTMENT,55622,Westport Depot,55
DEPARTMENT,55624,Greymouth Depot,55
DEPARTMENT,55626,Kaikoura Depot,55
DEPARTMENT,55628,Picton Depot,55
DEPARTMENT,55630,Amberley Depot,55
DEPARTMENT,55632,Chatham Depot,55
DEPARTMENT,55635,Culverden Depot (Excell),55
DEPARTMENT,55636,Rangiora Depot (Excell),55
DEPARTMENT,55638,Kurow Depot (Excell),55
DEPARTMENT,55640,Little River Depot (Excell),55
DEPARTMENT,55643,Methven Depot (Excell),55
DEPARTMENT,55644,Omarama Depot (Excell),55
DEPARTMENT,55646,Fairlee Depot,55
DEPARTMENT,55648,Kowai Depot,55
DEPARTMENT,55650,Christchurch Depot(McLeans Is),55
DEPARTMENT,55652,Timaru Depot,55
DEPARTMENT,55654,Twizel Depot,55
DEPARTMENT,55660,Dunedin Depot (Green Island ),55
DEPARTMENT,55670,Invercargill Depot,55
DEPARTMENT,55672,Gore Depot,55
DEPARTMENT,55674,Balclutha Depot,55
DEPARTMENT,55680,Queenstown Depot,55
DEPARTMENT,55682,Te Anau Depot,55
DEPARTMENT,55684,Oamaru Depot,55
DEPARTMENT,55686,Cromwell Depot/Quarry,55
DEPARTMENT,55688,Lawrence Depot,55
DEPARTMENT,55698,Property Recharges to Regions,55
DEPARTMENT,55699,Property Recharge (External),55
DEPARTMENT,55701,People (Northland),55
DEPARTMENT,55703,People (Penrose),55
DEPARTMENT,55704,People (North Shore),55
DEPARTMENT,55705,People (Waiheke),55
DEPARTMENT,55706,People (Hamilton Alliance),55
DEPARTMENT,55707,People (Waikato Alliance),55
DEPARTMENT,55708,People (Waikato Other),55
DEPARTMENT,55712,People (Tauranga),55
DEPARTMENT,55713,People (Paeroa),55
DEPARTMENT,55720,People (Tirau),55
DEPARTMENT,55721,People (Te Kuiti),55
DEPARTMENT,55723,People (Taupo),55
DEPARTMENT,55724,People (Taumarunui),55
DEPARTMENT,55732,People (Sealing - Akld/Nthld),55
DEPARTMENT,55733,People (Sealing - Waikato/BOP),55
DEPARTMENT,55734,People (Paving - Akld/Nthld),55
DEPARTMENT,55738,People (Paving - Waikato/BOP),55
DEPARTMENT,55739,People (Pavement Services),55
DEPARTMENT,55746,People (New Plymouth),55
DEPARTMENT,55747,People (Stratford),55
DEPARTMENT,55748,People (Hawera),55
DEPARTMENT,55750,People (Gisborne),55
DEPARTMENT,55751,People (Hastings),55
DEPARTMENT,55752,People (Marton),55
DEPARTMENT,55754,People (Wanganui),55
DEPARTMENT,55755,People (Tararua),55
DEPARTMENT,55756,People (Wellington),55
DEPARTMENT,55760,People (Sealing - Taranaki),55
DEPARTMENT,55762,People (Sealing - Hawkes Bay),55
DEPARTMENT,55763,People (Paving - Wellington),55
DEPARTMENT,55766,People (Nelson),55
DEPARTMENT,55767,People (West Coast),55
DEPARTMENT,55768,People (Kaikoura),55
DEPARTMENT,55780,People (Christchurch),55
DEPARTMENT,55782,People (South Canterbury),55
DEPARTMENT,55783,People (Biosecurity),55
DEPARTMENT,55784,People (Chathams),55
DEPARTMENT,55785,People (Queenstown),55
DEPARTMENT,55786,People (Milford),55
DEPARTMENT,55787,People (Otago),55
DEPARTMENT,55789,People (Southland),55
DEPARTMENT,55791,People (Paving - Nelson),55
DEPARTMENT,55792,People (Paving - Otago/Sthld),55
DEPARTMENT,55794,People (Sealing - Nelson),55
DEPARTMENT,55795,People (Sealing - Otago/Sthld),55
DEPARTMENT,55796,People (Surfacing - CHCH),55
DEPARTMENT,55801,Plant (Northland),55
DEPARTMENT,55803,Plant (Penrose),55
DEPARTMENT,55804,Plant (North Shore),55
DEPARTMENT,55805,Plant (Waiheke),55
DEPARTMENT,55806,Plant (Hamilton Alliance),55
DEPARTMENT,55807,Plant (Waikato Alliance),55
DEPARTMENT,55808,Plant (Waikato Other),55
DEPARTMENT,55809,Plant (Transport - Pavement Se,55
DEPARTMENT,55812,Plant (Tauranga),55
DEPARTMENT,55813,Plant (Paeroa),55
DEPARTMENT,55820,Plant (Tirau),55
DEPARTMENT,55821,Plant (Te Kuiti),55
DEPARTMENT,55823,Plant (Taupo),55
DEPARTMENT,55824,Plant (Taumarunui),55
DEPARTMENT,55832,Plant (Sealing - Akld/Nthld),55
DEPARTMENT,55833,Plant (Sealing - Waikato/BOP),55
DEPARTMENT,55834,Plant (Paving - Akld/Nthld),55
DEPARTMENT,55838,Plant (Paving - Waikato/BOP),55
DEPARTMENT,55839,Plant (Pavement Services),55
DEPARTMENT,55846,Plant (New Plymouth),55
DEPARTMENT,55847,Plant (Stratford),55
DEPARTMENT,55848,Plant (Hawera),55
DEPARTMENT,55850,Plant (Gisborne),55
DEPARTMENT,55851,Plant (Hastings),55
DEPARTMENT,55852,Plant (Marton),55
DEPARTMENT,55854,Plant (Wanganui),55
DEPARTMENT,55855,Plant (Tararua),55
DEPARTMENT,55856,Plant (Wellington),55
DEPARTMENT,55860,Plant (Sealing - Taranaki),55
DEPARTMENT,55862,Plant (Sealing - Hawkes Bay),55
DEPARTMENT,55863,Plant (Paving - Wellington),55
DEPARTMENT,55866,Plant (Nelson),55
DEPARTMENT,55867,Plant (West Coast),55
DEPARTMENT,55868,Plant (Kaikoura),55
DEPARTMENT,55880,Plant (Christchurch),55
DEPARTMENT,55882,Plant (South Canterbury),55
DEPARTMENT,55883,Plant (Biosecurity),55
DEPARTMENT,55884,Plant (Chathams),55
DEPARTMENT,55885,Plant (Queenstown),55
DEPARTMENT,55886,Plant (Milford),55
DEPARTMENT,55887,Plant (Otago),55
DEPARTMENT,55889,Plant (Southland),55
DEPARTMENT,55891,Plant (Paving - Nelson),55
DEPARTMENT,55892,Plant (Paving - Otago/Sthld),55
DEPARTMENT,55894,Plant (Sealing - Nelson),55
DEPARTMENT,55895,Plant (Sealing - Otago/South),55
DEPARTMENT,55896,Plant (Surfacing - CHCH),55
DEPARTMENT,55902,Administration,55
DEPARTMENT,55904,Asset Management,55
DEPARTMENT,55906,Bid/Estimating,55
DEPARTMENT,55908,Commercial & Finance,55
DEPARTMENT,55910,Human Resources,55
DEPARTMENT,55912,Technical,55
DEPARTMENT,55914,Zero Harm,55
DEPARTMENT,55916,Operations,55
DEPARTMENT,55948,Legacy,55
DEPARTMENT,55949,Bid Amortisation,55
DEPARTMENT,55951,People Recharges to Regions,55
DEPARTMENT,55952,Overhead - Northern,55
DEPARTMENT,55953,Overhead - Central,55
DEPARTMENT,55954,Overhead - Southern,55
DEPARTMENT,55990,Corporate Overheads (IT),55
DEPARTMENT,55991,Corporate Overheads (NSC),55
DEPARTMENT,55999,Corporate Recharge to Regions,55
DEPARTMENT,56000,Utility Services Balance Sheet,56
DEPARTMENT,56110,Whangarei DC,56
DEPARTMENT,56111,Kaipara DC,56
DEPARTMENT,56116,Auckland Stormwater Northern,56
DEPARTMENT,56118,Auckland Stormwater Central,56
DEPARTMENT,56120,Watercare Rodney,56
DEPARTMENT,56121,Watercare North West,56
DEPARTMENT,56122,Tauranga CC,56
DEPARTMENT,56123,Stratford DC,56
DEPARTMENT,56124,Horowhenua DC,56
DEPARTMENT,56125,Tasman DC,56
DEPARTMENT,56126,Southland DC,56
DEPARTMENT,56129,Water Major Projects,56
DEPARTMENT,56201,AC Urban Mowing & Litter,56
DEPARTMENT,56202,AC Urban Sports Parks,56
DEPARTMENT,56203,AC Urban Hort & Assets,56
DEPARTMENT,56209,Landscape Maintenance,56
DEPARTMENT,56210,Waikato/BOP - OSM,56
DEPARTMENT,56211,Ruapehu DC - OSM,56
DEPARTMENT,56212,Stratford DC - OSM,56
DEPARTMENT,56213,Gisborne DC - OSM,56
DEPARTMENT,56216,Horowhenua DC - OSM/FM,56
DEPARTMENT,56217,Wellington OSM,56
DEPARTMENT,56218,Blenheim OSM,56
DEPARTMENT,56305,FM - Auckland,56
DEPARTMENT,56306,FM - Wellington,56
DEPARTMENT,56307,FM - AC Building Services,56
DEPARTMENT,56308,FM - AC Technical Service,56
DEPARTMENT,56309,FM - AC Management,56
DEPARTMENT,56321,ES - Chorus,56
DEPARTMENT,56322,ES - Spark,56
DEPARTMENT,56323,ES - Transpower,56
DEPARTMENT,56324,ES - ANZ,56
DEPARTMENT,56325,ES - Other,56
DEPARTMENT,56701,People - Whangarei,56
DEPARTMENT,56702,People - Kaipara,56
DEPARTMENT,56703,People - AC Stormwater North,56
DEPARTMENT,56704,People - AC Stormwater Central,56
DEPARTMENT,56705,People - Watercare,56
DEPARTMENT,56706,People - Stratford,56
DEPARTMENT,56707,People - Tauranga,56
DEPARTMENT,56708,People - Levin,56
DEPARTMENT,56710,People - Tasman,56
DEPARTMENT,56711,People - Southland,56
DEPARTMENT,56722,People - Auckland Horticulture,56
DEPARTMENT,56723,People - Auckland Mowing,56
DEPARTMENT,56724,People - Auckland Parks,56
DEPARTMENT,56726,People - Auckland Landscape,56
DEPARTMENT,56727,People - Waikato/BOP,56
DEPARTMENT,56728,People - Stratford,56
DEPARTMENT,56729,People - Gisborne,56
DEPARTMENT,56731,People - Ruapehu,56
DEPARTMENT,56732,People - Horowhenua,56
DEPARTMENT,56734,People - Wellington,56
DEPARTMENT,56735,People - Blenheim,56
DEPARTMENT,56740,People -AKLC Building Services,56
DEPARTMENT,56741,People -AKLC Management,56
DEPARTMENT,56742,People -AKLC Technical Service,56
DEPARTMENT,56743,People - Auckland LBI Contract,56
DEPARTMENT,56744,People - FM - Asset Management,56
DEPARTMENT,56801,Plant - Whangarei,56
DEPARTMENT,56802,Plant - Kaipara,56
DEPARTMENT,56803,Plant - AC Stormwater North,56
DEPARTMENT,56804,Plant - AC Stormwater Central,56
DEPARTMENT,56805,Plant - Watercare,56
DEPARTMENT,56806,Plant - Stratford,56
DEPARTMENT,56807,Plant - Tauranga,56
DEPARTMENT,56808,Plant - Levin,56
DEPARTMENT,56810,Plant - Tasman,56
DEPARTMENT,56811,Plant - Southland,56
DEPARTMENT,56822,Plant - Auckland Horticulture,56
DEPARTMENT,56823,Plant - Auckland Mowing,56
DEPARTMENT,56824,Plant - Auckland Parks,56
DEPARTMENT,56826,Plant - Auckland Landscape,56
DEPARTMENT,56827,Plant - Waikato/BOP,56
DEPARTMENT,56828,Plant - Stratford,56
DEPARTMENT,56829,Plant - Gisborne,56
DEPARTMENT,56831,Plant - Ruapehu,56
DEPARTMENT,56832,Plant - Horowhenua,56
DEPARTMENT,56834,Plant - Wellington,56
DEPARTMENT,56835,Plant - Blenheim,56
DEPARTMENT,56840,Plant - AKLC Building Services,56
DEPARTMENT,56841,Plant - AKLC Management,56
DEPARTMENT,56842,Plant - AKLC Technical Service,56
DEPARTMENT,56843,Plant - Auckland LBI Contract,56
DEPARTMENT,56844,Plant - FM - Asset Management,56
DEPARTMENT,56951,Overhead allocation - Utility,56
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment