route_id,agency_id,route_short_name,route_long_name,route_desc,route_type,route_url,route_color,route_text_color
10,TRIO3,"669","Compiègne - Senlis",,3,,8DC04C,FFFFFF
100,TRIO3,"663","Francières - Gournay sur Aronde - Compiègne",,3,,8DC04C,FFFFFF
101,TRIO3,"654","Ressons sur Matz - Compiègne",,3,,8DC04C,FFFFFF
102,TRIO3,"655","Roye - Boulogne la Grasse - Compiègne",,3,,8DC04C,FFFFFF
106,TRIO3,"664","Lassigny - Compiègne",,3,,8DC04C,FFFFFF
107,TRIO3,"681","Vandélicourt - Noyon",,3,,8DC04C,FFFFFF
108,TRIO3,"675","Orvillers Sorel - Noyon",,3,,8DC04C,FFFFFF
109,TRIO3,"674","Verpillères - Noyon",,3,,8DC04C,FFFFFF
11,TRIO3,"6323","Pont Sainte Maxence - Compiègne",,3,,FF0000,FFFFFF
110,TRIO3,"679","Roye - Noyon",,3,,8DC04C,FFFFFF
111,TRIO3,"680","Champien - Noyon",,3,,8DC04C,FFFFFF
112,TRIO3,"677","Ham - Noyon",,3,,8DC04C,FFFFFF
113,TRIO3,"678","Brouchy - Muirancourt - Noyon",,3,,8DC04C,FFFFFF
114,TRIO3,"676","Nesle - Noyon",,3,,8DC04C,FFFFFF
115,TRIO3,"672","Brétigny - Baboeuf - Noyon",,3,,8DC04C,FFFFFF
116,TRIO3,"673","Brétigny - Varesnes - Noyon",,3,,8DC04C,FFFFFF
117,TRIO3,"670","Carlepont - Noyon",,3,,8DC04C,FFFFFF
118,TRIO3,"6331","Nampcel - Noyon",,3,,FF0000,FFFFFF
119,TRIO3,"671","Pont l'Eveque - Sempigny - Noyon",,3,,8DC04C,FFFFFF
120,TRIO3,"6332","Tracy le Val - Noyon",,3,,FF9900,FFFFFF
123,TRIO3,"686","Liancourt-Rantigny",,3,,8DC04C,FFFFFF
124,TRIO3,"687","Labruyère-Rantigny",,3,,8DC04C,FFFFFF
125,TRIO3,"6355","Bailleval-Liancourt",,3,,FF0000,FFFFFF
13,TRIO3,"6352","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF0000,FFFFFF
135,TRIO3,"6354","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF0000,FFFFFF
136,TRIO3,"6316","Collège de Liancourt",,3,,FF9900,FFFFFF
140,TRIO3,"6341","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF9900,FFFFFF
141,TRIO3,"6350","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF0000,FFFFFF
142,TRIO3,"6351","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF9900,FFFFFF
143,TRIO3,"6356","Clermont - Lycée d'Estrées Saint Denis",,3,,FF9900,FFFFFF
144,TRIO3,"6314","Collège de Cauffry",,3,,FF9900,FFFFFF
145,TRIO3,"6313","Collège de Mouy",,3,,FF0000,FFFFFF
146,TRIO3,"6342","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF9900,FFFFFF
147,TRIO3,"6343","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF0000,FFFFFF
148,TRIO3,"6344","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF0000,FFFFFF
149,TRIO3,"6345","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF9900,FFFFFF
15,TRIO3,"6315","Collège de Cauffry",,3,,FF9900,FFFFFF
150,TRIO3,"6346","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF9900,FFFFFF
151,TRIO3,"6347","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF0000,FFFFFF
152,TRIO3,"6348","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF9900,FFFFFF
153,TRIO3,"6349","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF9900,FFFFFF
155,TRIO3,"6327","Compiègne - Agnetz CFA",,3,,FF9900,FFFFFF
160,TRIO3,"6302","Collège de Couloisy",,3,,FF9900,FFFFFF
162,TRIO3,"6325","Cuise la Motte - Croutoy",,3,,FF9900,FFFFFF
163,TRIO3,"6301","Collège d'Estrées Saint Denis",,3,,FF0000,FFFFFF
167,TRIO3,"6308","Collège de Guiscard",,3,,FF9900,FFFFFF
169,TRIO3,"6310","Collège de La Croix Saint Ouen",,3,,FF0000,FFFFFF
172,TRIO3,"6307","Collège de Lassigny",,3,,FF9900,FFFFFF
173,TRIO3,"6309","Collège de Maignelay Montigny",,3,,FF9900,FFFFFF
174,TRIO3,"6311","Collège de Margny les Compiègne",,3,,FF9900,FFFFFF
184,TRIO3,"6303","Collège de Ressons sur Matz",,3,,FF0000,FFFFFF
185,TRIO3,"6334","Etablissements de Ribécourt Dreslincourt",,3,,FF9900,FFFFFF
189,TRIO3,"6304","Collège de Saint Just en Chaussée",,3,,FF0000,FFFFFF
190,TRIO3,"6306","Collège de Thourotte",,3,,FF0000,FFFFFF
191,TRIO3,"6305","Collège de Verberie",,3,,FF0000,FFFFFF
199,TRIO3,"6333","Lycée de Ham",,3,,FF9900,FFFFFF
2,TRIO3,"6353","Etablissements de Clermont - Agnetz - Breuil le Vert",,3,,FF0000,FFFFFF
206,TRIO3,"6312","SEGPA du collège de Margny les Compiègne",,3,,FF9900,FFFFFF
208,TRIO3,"685","Maignelay Montigny - Saint Just en Chaussée",,3,,8DC04C,FFFFFF
212,TRIO3,"684","Saint Just en Chaussée - Montdidier",,3,,8DC04C,FFFFFF
221,TRIO3,"6801","AGNETZ-RONQUEROLLES",,3,,FF0000,FFFFFF
222,TRIO3,"6802","AMY-AVRICOURT-MARGNY AUX CERISES-CRAPEAUMESNIL",,3,,FF0000,FFFFFF
223,TRIO3,"6803","ANGIVILLERS-CERNOY-ERQUINVILLERS-NOROY-CUIGNIERES-LIEUVILLERS",,3,,FF0000,FFFFFF
224,TRIO3,"6804","ANTHEUIL PORTES-MARGNY/MATZ-MARQUEGLISE-VANDELICOURT-VIGNEMONT",,3,,FF0000,FFFFFF
226,TRIO3,"6805","APPILLY-BRETIGNY-MONDESCOURT",,3,,FF0000,FFFFFF
227,TRIO3,"6806","ARSY-MOYVILLERS",,3,,FF0000,FFFFFF
228,TRIO3,"6807","ATTICHY-NAMPCEL",,3,,FF0000,FFFFFF
233,TRIO3,"6808","AVRIGNY-BLINCOURT-CHOISY LA VICTOIRE-FOUILLEUSE-EPINEUSE",,3,,FF0000,FFFFFF
234,TRIO3,"6809","BABOEUF-BEHERICOURT-GANDRU",,3,,FF0000,FFFFFF
236,TRIO3,"6810","BAILLEUL LE SOC-CRESSONSACQ-GRANDVILLERS AUX BOIS-ROUVILLERS",,3,,FF0000,FFFFFF
238,TRIO3,"6811","BAUGY-BRAISNES SUR ARONDE-MONCHY HUMIERES",,3,,FFCC00,FFFFFF
242,TRIO3,"6812","BEAULIEU LES FONTAINES-ECUVILLY-OGNOLLES-CANDOR-SOLENTE",,3,,FF0000,FFFFFF
244,TRIO3,"6814","BERLANCOURT-GOLANCOURT-VILLESELVE-LE PLESSIS PATTE D'OIE",,3,,FF0000,FFFFFF
245,TRIO3,"6815","BIERMONT-CUVILLY-HAINVILLERS-ORVILLERS SOREL-MORTEMER-LATAULE-BELLOY",,3,,FF0000,FFFFFF
246,TRIO3,"6816","BITRY-MOULIN SOUS TOUVENT-SAINT PIERRE LES BITRY",,3,,FF0000,FFFFFF
257,TRIO3,"6817","BOULOGNE LA GRASSE-CONCHY LES POTS-ROYE/MATZ-CANNY/MATZ",,3,,FF0000,FFFFFF
260,TRIO3,"6818","BRUNVILLERS LA MOTTE-GANNES-QUINQUEMPOIX",,3,,FFCC00,FFFFFF
261,TRIO3,"6819","BURY SAINT EPIN-BURY SAINT CLAUDE-ROUSSELOY",,3,,FFCC00,FFFFFF
262,TRIO3,"6820","CAISNES-CUTS",,3,,FF0000,FFFFFF
266,TRIO3,"6822","CATENOY-MAIMBEVILLE",,3,,FF0000,FFFFFF
267,TRIO3,"6823","CATILLON FUMECHON-LE MESNIL/BULLES-LE PLESSIER/BULLES-NOURARD LE FRANC",,3,,FFCC00,FFFFFF
272,TRIO3,"6824","CHEVINCOURT-MACHEMONT",,3,,FFCC00,FFFFFF
274,TRIO3,"6825","CHEVRIERES - LE FAYEL",,3,,FF0000,FFFFFF
278,TRIO3,"6827","COUDUN-GIRAUMONT",,3,,FF0000,FFFFFF
279,TRIO3,"6828","COULOISY-COURTIEUX",,3,,FF0000,FFFFFF
282,TRIO3,"6829","CROUTOY-HAUTEFONTAINE-CHELLES-SAINT ETIENNE ROILAYE",,3,,FF0000,FFFFFF
284,TRIO3,"6830","CUY-DIVES-LAGNY",,3,,FFCC00,FFFFFF
287,TRIO3,"6831","DE COURCELLES EPAYELLES-MERY LA BATAILLE-LE FRESTOY VAUX",,3,,FF0000,FFFFFF
290,TRIO3,"6832","ELINCOURT SAINTE MARGUERITE-MAREST SUR MATZ",,3,,FF0000,FFFFFF
293,TRIO3,"6833","ERQUERY-SAINT AUBIN SS ERQUERY-REMECOURT-LAMECOURT",,3,,FF0000,FFFFFF
297,TRIO3,"6834","EVRICOURT-CANNECTANCOURT-THIESCOURT",,3,,FF0000,FFFFFF
3,TRIO3,"6317","Collège de Liancourt",,3,,FF9900,FFFFFF
300,TRIO3,"6835","FERRIERES-DOMFRONT-DOMPIERRE-ROYAUCOURT-GODENVILLERS-SAINS-CREVECOEUR-WELLES",,3,,FF0000,FFFFFF
301,TRIO3,"6836","FLAVY LE MELDEUX-FRENICHES-FRETOY LE CHÂTEAU-MUIRANCOURT-LIBERMONT",,3,,FF0000,FFFFFF
305,TRIO3,"6837","FOURNIVAL-SAINT REMY EN L'EAU-VALESCOURT",,3,,FF0000,FFFFFF
307,TRIO3,"6838","FRANCIERES-HEMEVILLERS-MONTMARTIN",,3,,FF0000,FFFFFF
313,TRIO3,"6839","GOURNAY SUR ARONDE-MOYENNEVILLE-NEUFVY SUR ARONDE",,3,,FFCC00,FFFFFF
321,TRIO3,"6840","HONDAINVILLE-THURY SOUS CLERMONT",,3,,FF0000,FFFFFF
322,TRIO3,"6841","HOUDANCOURT-SACY LE PETIT",,3,,FF0000,FFFFFF
327,TRIO3,"6842","LA NEUVILLE ROY-LEGLANTIERS-PRONLEROY -WACQUEMOULIN-MONTIERS",,3,,FF0000,FFFFFF
330,TRIO3,"6843","LABRUYERE-ROSOY-VERDERONNE",,3,,FF0000,FFFFFF
331,TRIO3,"6844","LARBROYE-PORQUERICOURT-VAUCHELLES",,3,,FF0000,FFFFFF
332,TRIO3,"6845","LASSIGNY-PLESSIS DE ROYE-FRESNIERES-GURY",,3,,FF0000,FFFFFF
335,TRIO3,"6846","LE PLOYRON-TRICOT",,3,,FF0000,FFFFFF
337,TRIO3,"6847","LONGUEIL SAINTE MARIE-RIVECOURT",,3,,FF0000,FFFFFF
338,TRIO3,"6848","MAIGNELAY MONTIGNY",,3,,FF0000,FFFFFF
339,TRIO3,"6849","MAUCOURT-QUESMY-GUISCARD-BEAUGIES SOUS BOIS",,3,,FF0000,FFFFFF
345,TRIO3,"6850","MORLINCOURT-PONTOISE-VARESNES",,3,,FF0000,FFFFFF
347,TRIO3,"6851","NEUILLY SOUS CLERMONT - CAMBRONNE LES CLERMONT",,3,,FFCC00,FFFFFF
350,TRIO3,"6852","PASSEL-SUZOY-VILLE",,3,,FFCC00,FFFFFF
351,TRIO3,"6853","PIERREFONDS-PALESNES",,3,,FF0000,FFFFFF
352,TRIO3,"6854","PLAINVAL-LE PLESSIER SUR SAINT JUST",,3,,FF0000,FFFFFF
354,TRIO3,"6855","PONT L'EVEQUE-SEMPIGNY",,3,,FF0000,FFFFFF
367,TRIO3,"6858","TRACY LE MONT-TRACY LE VAL-OLLENCOURT",,3,,FF0000,FFFFFF
388,TRIO3,"6859","SIRS BEAURAINS LES NOYON - BUSSY - GENVRY - CAMPAGNE - CATIGNY - SERMAIZE",,3,,FF0000,FFFFFF
39,TRIO3,"668","Noyon - Compiègne",,3,,8DC04C,FFFFFF
40,TRIO3,"667","Thourotte - Compiègne",,3,,8DC04C,FFFFFF
41,TRIO3,"6321","Compiègne - Noyon",,3,,FF0000,FFFFFF
42,TRIO3,"665","Carlepont - Compiègne",,3,,8DC04C,FFFFFF
43,TRIO3,"652","Soissons - Compiègne par les villages",,3,,8DC04C,FFFFFF
44,TRIO3,"653","Vic sur Aisne - Attichy - Compiègne",,3,,8DC04C,FFFFFF
45,TRIO3,"650","Soissons - Compiègne par RN31",,3,,1154A0,FFFFFF
46,TRIO3,"651","Ressons le long - Cuise la Motte - Compiègne",,3,,8DC04C,FFFFFF
47,TRIO3,"658","Pierrefonds - Compiègne",,3,,8DC04C,FFFFFF
48,TRIO3,"657","Crépy en Valois - Pierrefonds - Compiègne",,3,,8DC04C,FFFFFF
49,TRIO3,"656","Morienval - Crépy en Valois - Compiègne",,3,,8DC04C,FFFFFF
58,TRIO3,"660","Clermont - Compiègne",,3,,8DC04C,FFFFFF
59,TRIO3,"661","Grandfresnoy - Compiègne",,3,,8DC04C,FFFFFF
6,TRIO3,"6318","Collège de Cauffry",,3,,FF9900,FFFFFF
60,TRIO3,"682","Estrées Saint Denis - Clermont",,3,,8DC04C,FFFFFF
61,TRIO3,"6322","Avrigny - Compiègne",,3,,FF9900,FFFFFF
62,TRIO3,"6324","Arsy - Compiègne",,3,,FF9900,FFFFFF
63,TRIO3,"659","Estrées Saint Denis - Compiègne",,3,,8DC04C,FFFFFF
97,TRIO3,"662","Saint Just en Chaussée - Compiègne",,3,,8DC04C,FFFFFF
98,TRIO3,"683","Lieuvillers - Pronleroy - Saint Just en Chaussée",,3,,8DC04C,FFFFFF
99,TRIO3,"6328","Gare de Tricot",,3,,FF0000,FFFFFF
