Required: integration unit codes for US states

This forum deals with questions about special content. Let us know what kind of content you wish to see within our services...

Required: integration unit codes for US states

Postby Bernd Welter » Tue Feb 27, 2018 3:20 pm

Hi there,
IU codes in the USA.PNG
example screenshot of a route in US traversing various states. The issue is that the returned IU codes aren't sufficient without a matching table IUcode<=>state


We deal with the routing in the USA and one info we retrieve from the xRoute server is the toll.
According to the API documentation the toll info's are assigned to INTEGRATION UNIT CODES but what we really need is the code of the STATE.

Is there a matching list of IUcodes 2 state code?

Bet regards,
Bernd
Bernd Welter
Manager Technical Consulting & Requirement Engineering
Senior Technical Consultant Developer Components
PTV GROUP - Germany

Bernd at Youtube
User avatar
Bernd Welter
Site Admin
 
Posts: 1098
Joined: Mon Apr 14, 2014 10:28 am

Re: Required: integration unit codes for US states

Postby jmamy » Tue Feb 27, 2018 9:48 pm

Hi there,
This use case is pretty common for US customers that want to evaluate their fuel tax (IFTA), it requires mileage per states.

I built a geojson file from various source on the web, and a little bit of edition to match the PTV sub unit code to the actual state name.
I'm now able to retrieve the mileage per state (US and CAN)and the states boundaries, Mexico return the same IUCode (752) for the whole country.
Attachments
nam.zip
US and Canada name and area boudaries
(546.38 KiB) Downloaded 32 times
mileageByStates.png
Mileage per state
Julien Mamy
Logistics Software Sales Engineer
PTV AMERICA
User avatar
jmamy
 
Posts: 28
Joined: Wed Jul 02, 2014 7:21 am

Re: Required: integration unit codes for US states

Postby Bernd Welter » Tue Mar 06, 2018 12:38 pm

Here we go... I already asked for those values to be updated in the documentation.
world.txt
TXT file with the values
(11.82 KiB) Downloaded 30 times

viewtopic.php?f=48&t=434&p=1119&hilit=56100#p1119

IDISO3ISO2COUNTRY CODEPLATEINTERNATIONAL DIALLINGSUBUNIT CODEAGFCODEDRIVING SIDECURRENCY ID
1CZECZCZ420CZE030
2SVKSKSK421SLO01
7SMRSMRSM378ITA01
10PRIPRPR178ENG012
11ESTEEEST372EST01
12GEOGEGE995GEO0106
13LVALVLV371LAV01
14LTULTLT370LIT01
15MDAMDMD373RUM027
16RUSRURUS7RUS0105
17UKRUAUA380UKR0104
18BLRBYBY375BEL028
20EGYEGET20ENG063
27ZAFZAZA27ENG129
30GRCGRGR30GRE01
31NLDNLNL31DUT01
32BELBEB32FRE01
33FRAFRF33FRE01
34ESPESE34SPA01
36HUNHUH36HUN017
39ITAITI39ITA01
40ROURORO40RUM015
41CHECHCH41GER06
43AUTATA43GER01
44GBRGBGB44ENG12
45DNKDKDK45DAN03
46SWESES46SWE05
47NORNON47NOR04
48POLPLPL48POL07
49DEUDED49GER01
50GIBGIGBZ350ENG0149
51PRTPTP351POR01
52LUXLUL352LTZ01
53IRLIEIRL353ENG11
54ISLISIS354ICE010
55ALBALAL355ALB020
56MLTMTM356MLT11
57CYPCYCY357GRE11
58FINFIFIN358FIN01
59BGRBGBG359BUL016
60MYSMYMAL60MAY1128
61LBNLBRL961FRE064
62ANDADAND376CAT01
63SYRSYSYR963ENG066
64NZLNZNZ64ENG1143
65SGPSGSGP65ENG1150
66SAUSAKSA966ENG071
71LBYLYLAR218ARE062
72ISRILIL972HEB065
73PSEPSPN972ARA065
74UZBUZUZ998UZB0110
75LIELIFL423GER06
76MARMAMA212FRE059
77DZADZDZ213FRE060
78TUNTNTN216FRE061
79ESHEHDAS212ARE059
80MRTMRRIM222FRE075
81SRBRSSRB381SRB023
82KORKRROK82KOR0132
83JORJOJOR962ENG068
84VNMVNVN84VIE0126
85HRVHRHR385SCR018
86SVNSISLO386SLV01
87BIHBABIH387BOS021
89MKDMKMK389MAC019
90TURTRTR90TUR011
91INDININD91ENG1118
92PAKPKPK92URD1116
93MCOMCMC377FRE01
94AZEAZAZ994AZE0107
95ARMAMAM374ARM0108
96VATVAV390ITA01
98FROFOFR298FAO03
100USAUSUSA1ENG012
200CANCACDN1ENG013
220GMBGMWAG220ENG077
221SENSNSN221FRE076
223MLIMLRMM223FRE076
224GINGNRG224FRE078
226BFABFBF226FRE076
227NERNERN227FRE076
228TGOTGRT228FRE076
229BENBJDY229FRE076
230MUSMUMS230ENG1151
231LBRLRLB231ENG080
232SLESLWAL232ENG079
233GHAGHGH233ENG081
234NGANGWAN234ENG082
235TCDTDTCH235FRE083
236CAFCFRCA236FRE083
237CMRCMCAM237FRE083
238CPVCVCV238POR0148
239STPSTSTP239POR0153
240GNQGQEQ240SPA083
241GABGAG241FRE083
242COGCGRCB242FRE083
243CODCDCGO243FRE089
244AGOAOANG244POR094
245GNBGWGW245POR076
248SYCSCSY248CPF1135
249SDNSDSUD249ENG084
250RWARWRWA250FRE092
251ETHETETH251ENG087
252SOMSOSO252SOM088
253DJIDJDJ253ARA086
254KENKEEAK254ENG191
255TZATZEAT255ENG193
256UGAUGEAU256ENG190
257BDIBIBU257FRE0162
258MOZMZMOC258POR198
260ZMBZMZ260ENG196
261MDGMGRM261MLG0101
262REURERE262FRE01
263ZWEZWZW263ENG199
264NAMNANAM264ENG197
265MWIMWMW265ENG195
266LSOLSLS266ENG129
267BWABWRB267ENG1100
268SWZSZSD268ENG129
269COMKMKM269ARA0134
270MYTYTMAY269FRE01
291ERIERER291ENG085
292SSDSSSSD211ENG0163
297ABWAWNL297DUT0154
299GRLGLGD299DAN03
300ATAAQZZAENG
303BVTBVBVNOR4
304IOTIOGBENG12
306CXRCXAUS672ENG1140
307ZZEUND
309CIVCICI225FRE076
310ZZFUND
312ATFTFZZHFRE01
315GBGBG44ENG12
316HMDHMZZJ61ENG1140
317HKGHKHK852ENG1156
318UMUSAUND12
319ZZKUND67
320SJMSJN47NOR04
321GBGBJ44ENG12
322USAUND012
325GBGBM44ENG12
328NIUNUNZ64ENG1143
329NFKNFAUS672ENG1140
331ZZM86UND0123
333SGSGSGB500ENG151
334ZZNUND
335SHNSHSH290ENG1157
336SJMSJN47NOR04
337TKLTKNZ64ENG1143
338ZZO33UND
339UMIUMUSA1ENG012
340FSMFMFSM691ENG012
341PRKKPDVR82KOR0131
342ZZPUND0
381XKRKS381SCC01
382MNEMEMNE382SML01
500FLKFKFK500ENG151
501BLZBZBH501ENG035
502GTMGTGCA502SPA034
503SLVSVES503SPA012
504HNDHNHN504SPA036
505NICNINIC505SPA037
506CRICRCR506SPA038
507PANPAPA507SPA039
509HTIHTRH509FRE054
530TTOTTTT186ENG156
531GRDGDWG147ENG157
532BRBBBBDS124ENG158
533VCTVCWV178ENG157
534LCALCWL175ENG157
535DMADMWD176ENG157
536DOMDODOM180SPA055
537KNAKNSCN186ENG157
538JAMJMJA187ENG153
539MSRMSMOT166ENG157
540ATGAGAB126ENG157
543AIAAIADS126ENG157
544VGBVGBVI128ENG112
545VIRVIVIN134ENG112
546CYMKYCAY134ENG133
547TCATCTQ164ENG112
548NAV1UND12
550BMUBMBM144ENG112
551SPMPMPM508FRE01
590GLPGPGL590FRE01
591BOLBOBOL591SPA046
592GUYGYGUY592ENG142
593ECUECEC593SPA012
594GUFGFFG594FRE01
595PRYPYPY595SPA047
596MTQMQMR596FRE01
597SURSRSME597DUT143
598URYUYROU598SPA050
599ANTANNA599DUT0158
670MNPMPNMI167ENG012
671GUMGUGM167ENG012
673BRNBNBRU673MAY1129
674NRUNRNAU674NAU1140
675PNGPGPNG675ENG1139
676TONTOTO676ENG1147
677SLBSBSLB677ENG1141
678VUTVUNHBIS0144
679FJIFJFJI679ENG1145
680PLWPWPW680ENG012
681WLFWFWF678FRE0146
682COKCKRG682ENG1143
684ASMASWSA684ENG012
685WSMWSWS685ENG1142
686KIRKIKR686GIL1140
687NCLNCNC687FRE0146
688TUVTVTVTVL1140
689PYFPFFP689FRE0146
691CARUND0139
692MHLMHMIS692MAH012
696UMJI1UND12
698WIENG012
751PERPEPE51SPA044
752MEXMXMEX52SPA032
753CUBCUC53SPA052
754ARGARRA54SPA049
755BRABRBR55POR045
756CHLCLRCH56SPA048
757COLCOCO57SPA040
758VENVEYV58SPA041
759CYA357GRE11
760CYB357TUR111
761AUSAUAUS61ENG1140
762IDNIDRI62IND1138
763PHLPHRP63TGL0130
766THATHTHA66THA1124
775TKMTMTM993TUK0112
776KAZKZKZ7KAZ0109
777KGZKGKS996KIR0111
778TJKTJTJ992TGK0113
781JPNJPJ81JPN114
786CHNCNVRC86CHI0123
793AFGAFAFG93PER0114
794LKALKCL94SIN1137
795MMRMMMYA95BUR0122
798IRNIRIR98PER0115
809BHSBSBS124ENG131
853MACMOMAC853POR1159
855KHMKHK855KHM0127
856LAOLALAO856LAO0125
880BGDBDBD880BEN1119
886TWNTWRC886CHI0160
960MDVMVMV960DIV1136
964IRQIQIRQ964ENG067
965KWTKWKWT965ENG069
967YEMYEYEM967ENG074
968OMNOMOM968ENG073
971AREAEUAE971ENG072
973BHRBHBRN973ENG0161
974QATQAQ974ENG070
975BTNBTBHT975DZO1121
976MNGMNMGL976MON0117
977NPLNPNEP977NEP1120
978TLSTLTLTET112
981CCKCCCCENG1140
982PCNPNPNENG1143
983BLMBLBLFRE01
984MAFMFMFFRE01
985SXMSXSXDUT0158
986BESBQNADUT012
987CUWCWNADUT0158
999ZZZUND0
1016RUSFERUS0105
1027ZA27NCAFR129
1033FRAFRF33HAFRE01
1091IND91APENG1118
1100USA1ALENG012
1200CDN1NBENG013
1761AUS61SWENG1140
1786VRC86CHI0123
1999ZZZUND0
2016RUSNCRUS0105
2027ZA27WCAFR129
2091IND91ANENG1118
2100USA1AKENG012
2200CDN1PEENG013
2761AUS61VIENG1140
2786VRC86CHI0123
2999ZZZUND0
3016RUSNWRUS0105
3027ZA27LIAFR129
3091IND91ARENG1118
3200CDN1NLENG013
3761AUS61QLENG1140
3786VRC86CHI0123
3999ZZZUND0
4016RUSSBRUS0105
4027ZA27MPAFR129
4091IND91ASENG1118
4100USA1AZENG012
4200CDN1NSENG013
4761AUS61SAENG1140
4786VRC86CHI0123
4999ZZZUND0
5016RUSSNRUS0105
5027ZA27GTAFR129
5091IND91BRENG1118
5100USA1ARENG012
5200CDN1QCFRE013
5761AUS61WAENG1140
5786VRC86CHI0123
5999ZZZUND0
6016RUSULRUS0105
6027ZA27FSAFR129
6091IND91CHENG1118
6100USA1CAENG012
6200CDN1ONENG013
6761AUS61TAENG1140
6786VRC86CHI0123
6999ZZZUND0
7016RUSVARUS0105
7027ZA27KZAFR129
7091IND91CGENG1118
7200CDN1MBENG013
7761AUS61NTENG1140
7786VRC86CHI0123
8016RUSCLRUS0105
8027ZA27ECAFR129
8091IND91DNENG1118
8100USA1COENG012
8200CDN1SKENG013
8761AUS61ACENG1140
8786VRC86CHI0123
9027ZA27NWAFR129
9091IND91DDENG1118
9100USA1CTENG012
9200CDN1ABENG013
9761AUS61OTENG1140
9786VRC86CHI0123
10091IND91DLENG1118
10100USA1DEENG012
10200CDN1BCENG013
10786VRC86CHI0123
11091IND91GAENG1118
11100USA1DCENG012
11200CDN1NUENG013
11786VRC86CHI0123
12091IND91GJENG1118
12100USA1FLENG012
12200CDN1NTENG013
12786VRC86CHI0123
13091IND91HRENG1118
13100USA1GAENG012
13200CDN1YTENG013
13786VRC86CHI0123
14091IND91HPENG1118
14786VRC86CHI0123
15091IND91JKENG1118
15100USA1HIENG012
15786VRC86CHI0123
16091IND91JHENG1118
16100USA1IDENG012
16786VRC86CHI0123
17091IND91KAENG1118
17100USA1ILENG012
17786VRC86CHI0123
18091IND91KLENG1118
18100USA1INENG012
18786VRC86CHI0123
19091IND91LDENG1118
19100USA1IAENG012
19786VRC86CHI0123
20091IND91MPENG1118
20100USA1KSENG012
20786VRC86CHI0123
21091IND91MHENG1118
21100USA1KYENG012
21786VRC86CHI0123
22091IND91MNENG1118
22100USA1LAENG012
22786VRC86CHI0123
23091IND91MLENG1118
23100USA1MEENG012
23786VRC86CHI0123
24091IND91MZENG1118
24100USA1MDENG012
24786VRC86CHI0123
25091IND91NLENG1118
25100USA1MAENG012
25786VRC86CHI0123
26091IND91ORENG1118
26100USA1MIENG012
26786VRC86CHI0123
27091IND91PYENG1118
27100USA1MNENG012
27786VRC86CHI0123
28091IND91PBENG1118
28100USA1MSENG012
28786VRC86CHI0123
29091IND91RJENG1118
29100USA1MOENG012
29786VRC86CHI0123
30091IND91SKENG1118
30100USA1MTENG012
30786VRC86CHI0123
31091IND91TNENG1118
31100USA1NEENG012
31786VRC86CHI0123
32091IND91TRENG1118
32100USA1NVENG012
32786VRC86CHI1123
33091IND91UPENG1118
33100USA1NHENG012
33786VRC86POR1123
34091IND91UAENG1118
34100USA1NJENG012
35091IND91WBENG1118
35100USA1NMENG012
36091IND91TGENG1118
36100USA1NYENG012
37100USA1NCENG012
38100USA1NDENG012
39100USA1OHENG012
40100USA1OKENG012
41100USA1ORENG012
42100USA1PAENG012
44100USA1RIENG012
45100USA1SCENG012
46100USA1SDENG012
47100USA1TNENG012
48100USA1TXENG012
49100USA1UTENG012
50100USA1VTENG012
51100USA1VAENG012
53100USA1WAENG012
54100USA1WVENG012
55100USA1WIENG012
56100USA1WYENG012
Bernd Welter
Manager Technical Consulting & Requirement Engineering
Senior Technical Consultant Developer Components
PTV GROUP - Germany

Bernd at Youtube
User avatar
Bernd Welter
Site Admin
 
Posts: 1098
Joined: Mon Apr 14, 2014 10:28 am


Return to Data and content