20211104 10354100 1.0 TRUE sGravityMain with additional ID column "PipeID_By_Access_Point". Pipe ID by Access Point = MainComp1-UNITID - MainComp1-UNITID2 if an asset is not synced between IPS&GIS yet, then UFID of the line will be used as UNITID and type will be "UND": def getAssetType(compType): AssetType={ 3:"EQ-", 4:"FAC-", 5:"GMN-", 6:"GMTR-", 10:"GSL-", 11:"GV-", 12:"HY-", 13:"IN-", 14:"LAND-", 15:"SLS-", 16:"APP-", 18:"PARK-", 19:"SBF-", 20:"SIGN-", 21:"SMN-", 22:"SMH-", 23:"SMTR-", 24:"SND-", 25:"SP-", 26:"SSL-", 28:"STCH-", 29:"STIN-", 30:"STMH-", 31:"STMN-", 32:"STND-", 33:"STSL-", 34:"FSU-", 35:"SV-", 36:"TR-", 37:"VEH-", 38:"WBF-", 40:"WELL-", 41:"WMN-", 42:"WMTR-", 43:"WND-", 44:"WP-", 45:"WSL-", 46:"WV-", 48:"STP-", 49:"STV-", 53:"EMTR-", 55:"POLE-", 66:"BR-", 67:"WSU-", 68:"SEG-", 69:"SMS-", 70:"WMS-", 71:"GMS-", 72:"STMS-", 73:"LGHT-", 74:"SGNL-", 75:"PMS-", 77:"STLS-", 78:"WPS-", 79:"IWBF-", 80:"IWLS-", 81:"IWMN-", 82:"IWMH-", 83:"IWMS-", 84:"IWND-", 85:"IWSL-", 86:"CPLX-", 87:"STBF-", 88:"STMT-", 89:"RSEG-", 90:"RAPP-", 91:"XING-", 92:"RSGN-", 93:"RSGL-", 94:"RSTN-", 95:"RYRD-", 96:"BLDG-", 97:"SW-", 98:"SPL-", 99:"WPL-", 100:"RW-", 101:"RL-", 102:"RES-", 103:"RSB-", 104:"RSPL-", 105:"REMB-", 106:"RINS-", 107:"RMS-", 108:"STSB-", 109:"AREA-" } try: return AssetType[compType] except: return "UND" def genHansenID(comp1, id1, comp2, id2, UFID): try: id1 = id1 == None if str(UFID) else str(id1).strip() id2 = id2 == None if str(UFID) else str(id2).strip() return getAssetType(comp1) + id1 + " - " + getAssetType(comp2) + id2 except: return UFID genHansenID( !MAINCOMP1!, !UNITID! , !MAINCOMP2! , !UNITID2!, !UFID!) CUES WWO sGravityMain with additional ID column "PipeID_By_Access_Point". Pipe ID by Access Point = MainCompType1-UNITID - MainCompType2-UNITID2 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gAooooAKKKKACiiigAooooAKKKKACiiigAoorxi7+KOtWHjO4troQpYw3DQvEqbioBxkHPXj17ms qtaNO3N1O7BZfWxrkqVvdVz1bWdc0/QNPe91G5SGIcKCfmc+ijqT9KyfDXjzRfE7pb2krpesjO1s 8bZUA4+9jb6Hg968H8U+KL7xXqpvLtisajbDAD8sS+3ue5/wFZNpdz2F5Dd2spinhcPG46qw6GuK WOfP7q0PqKPC0Hhv3srVH9y8vPz/AA8/rWivBdO+K3iqTViVjjvBMdsdkkPG4/3cZc/TJ616/wCH tZu9SsBNqdolhK8rrFE74dlDsoyp5B4HrnqOuK66WIhU0ifO47KMRgkpVLWfZ/pubdFFFbnlhRRR QAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAMmmit4WlmkWONBlnY4AH1pILiG6hWa3lSWJhl XRgQfxFZHivw/H4m0KXTpLmS3VmVi6DPAYE8Z54B+h5rzy0+KWjeG7f+ytN0eSS0gOI3DeVu7kkN k5znqaxnWVOXvaI9HC5fPF0m6F5TT1XRLvdvr28j16vF/ih4J1WXW59csYZLu2lVTKqAFoiBjhRy RgA5x3NcrqXj7xLqE8c/9oTwRxys8SxEqM7i2D643AYPGAOK+htKuftulWtzukbzIwxMkexifdcD FY88MUnDsem8PicinDEXT5rpo8O0f4Ta3qllZXkssNrFcEl1kB8yNOzbeMk8nGR29eN6D4UWek2+ p3mtSzXVtGhFutorF8H+PaAeQecfMAM5zXr9Vr2+srCFXvrmGCORhGplcKGY9FGep9qawlKKMp8Q 46tKydk+i33vvv5HgWo6Lc+HbOLxL4ZvbgaXOioJZV2zxMcHaeB6D5hwfXnntfCugXPjOPSvE2ty Tw3VlKnkFHytwqFSGIYnBLAg4wPYVc+KWgalf6DYwaPFK9vDIqGxt4+MYwpwBwB09B/LtNB0w6No NlpxYMbeIIWXOCfbNRToWqNPb8LnVjM05sFCpFr2jbV/tKPZmjRRRXcfLBRRRQAUUUUAFFFFABRR RQAUUUUAFFFFAHjfjvx/4m0fxU1lboljDbHdGCof7QpGAzZ4x1wBjHfkV6vpF+dU0ezv2geBriFZ DE/VSRnFMvtC0rUruG6vrC3uJ4RiN5UDFe9Sahq1hpSRvfXUUCyOsab2xkkgD+fXtWEIShKUpS0P TxOIo4ijSpUaVprdrr+r76liaaK2gknmkWOKNSzuxwFA6k14rrHxE1Kw8eNNDqq3mkRzAiGFdqlM AFeedw56nGee+K9pmhgvLVopUSaCVcMp5DA15H4++GulaToM+r6XI8LRSBpUml+TYcjCjbnduKgc 4qMUqnLeHTU6silhFVdPEq7lotE1r+KZTufivq2sadqGnWulI0twkgRlyxjiKnccDqQM8/nnHPDW y/ZIYJ57e9itjKUmZWZROVIbaDgAbcDPJOSDXe/BjTGl1O+v5bMtFGgWK4K8K+eVB9cHn8K9B8b+ Eh4r0VbSKQQzxyiSNj93J4JP4E1zKlUrU/aN3Z7k8fhMuxbwkIcsXa7v5fp/wTxmz15bzxlaebeK ulfaQoN4glEcJOCCXDc44ye/PHb6KgnhuoI54JUlhkUMjo2VYHoQR1rxXxZ4C8NeGU0xrvV7mHzT tlVYfMaXBG5hz8uAfQ1634f03T9L0S0g00ZtvKUrIVAaQY4ZsAZOPatsKpxlKMjy89qYavSpVqF7 apaWTt59/vMvW/GlroviLT9Ge0uJZbsj94qnagJxnGMt06Cuc8YwaV4r8ZWOgXBuLe4twJPtCncr qeSgXIxkEfN19sV6RsXfv2jfjG7HOPSq39l2X9qDU/s6fbBGYvNA52nGf/QRzW86cpKzel/wPLw2 LpUJKcItSSaun1fX06WJreCO1to7eLd5cahV3uWOB6kkk/jUtFFbHnttu7CiiigQUUUUAFFFFABR RRQAUUUUAFFFFABRRRQBXt761ulJguI3Adozg/xAkEfmp/KvNfjNqItbXS7U2cMvnM7+ZJuyu0od owRjPGa858Yx2Fj4ouv7EvVktZGL/uXOI2yylc9+/PPDdTWNe6le6lL5l5cyTNx98+ihRx64VRn2 rzK2L5ouFtT7nLcgVKtTxSneO9mrPb1NjS/G2vaZfLcLqd5IgwGiecsCvoN27H5UeKfGeqeK7lXv HEUCDCW8XCL0yfUkkd652iuL2k+XlvofRrB4dVVWUFzLrY7vwr4/g8KeHp7S0sHe8kuVl8yRwV2Y QMOgP8Jx6ZHXFd+fjF4bWzjlMd40zLloUjB2HHQkkA+nFeC0VtDFVIKyODE5Fg8RP2k07t3eu5ua t4qv9a1qHVL5LaWaHAVTENpAJIDYxnrXu/hjxlpus2NnFJNaWuoSLj7HHcLIR6Y2+2DjqOnavmyp LdZXuIkgWRpmYKix53FieAMd6KOIlTk3vcMwyahi6UYL3eXa3T9LH1vRXJ+A7XWdL8MQp4guv3jN mOOYfvI9zHhn3HdnIwMAjJHPGOsr2IS5op2sfnGIpKlVlBS5kna62YUUUVRiFFFFABRRRQAUUUUA FFFFABRRRQAU3zE8wx713gbtueceuKSWMSxPGWZQ6lSUYqRn0I6GvJbrwB40tdWvbnSdZkRHlYwl 719xjLMQG9TyDz3JNZVJyha0bnbg8NSr8yqVFBra/U9drP1y+tdN0S8uryaSGBIm3PEcOMjHy/7X pXhF/wCKPG/hvVmttSv7lbhWWTZK+5WAORjHG04x+lY+teL9d8QxLDqV+8sKncIgAq5wBkgdTx36 ZOMZNc08bFJqzue7h+GKspxk6icN7rt5GITkknHPoMUlFdL4U8KJ4oM6rqcVtLBh3SVDgpkDIbpn JxivMjFydkfbVq0KEHUqOyRzVFS3MQgupoQ24Ruy5yDnBx24qS7sZ7JbZpgALiETRkHOVJI/mDSs zTmWmu5WooopDCp7WdbaUTbXMqENEysAFYHIJBByPaoKlhRZcxjcZmIWMADBJPc54poUrW1OpfxV qfii0sNE1G5fdHKPKuFkEYPpvHCkjsxxj3r3nQ7/AE+5tPsllqUd69mFilYSb2BxwWOTk8dc8818 yarpd5oupTafqEXlXUON6bg2MgEcgkdCK9L+D/hy/j1GbW50kgtvK8uMSRsPODYO5SeCBjrXdhas /acrV2fLZ5gcO8J7WElGK1SWzb/z8tOp7JRRRXqHwgUUUUAFFFFABRRRQAUUUUAFFFFABRRRQB8+ /FXVrPVPF7Jagk2ieRI/ZmBzxz2zjt/WuGr2bxH8MJdZ8UX95GYrCxaHzQ0S+YZJeRjbwV7E4yOe 56eNuhR2Q9VJB4xXiYiE1Nyl1P1DJ8Rh6mGjSou/Klfyv+A2nrNIsLRBiEYhiM9SM/4mmUVznq2u FKSTjJJxxV3Rk059Xtl1Z5Y7AuBM8X3lXPX/APVk+lWtQ1PT5Li+jstKt4rWU4iLFmkjAxghuPT0 7n61SWl7mUqjU+RRb8+hj0UUVJqFXNMsjqOowWq3VvavIwVZbh9iLx1Ldun61ToBwcjrTW4pJtNJ 2Z9Zf2dYi7a7+x2/2liGabyl3kgYBLYz04+lTRRRwxLFEixxqMKqDAA9hXn/AMM/HA1uwGl6ncr/ AGlCQkW4/NOgXOfdhtOT9DXode9TnGceaJ+TY3D1sNVdGruvy6W8gooorQ5AooooAKKKKACiiigA ooooAKKKKACiiigBCcAk549Bmvl/xbqEGqeKtQvILSS1WSU5ikI3BhwScdCSCcfqa+oazL3w7o2o wzR3WmWjiYHe3kruPvnGc+9c+Iouqkkz2cmzKngKkpzi3fTR7f5nyvRXtmr/AAZ0yW1P9k3k8FwM YFw29D65wMiuL8WfDPUPDFi9+tyt5aqwXdHEwZRjlmHIUZ75x7g4B8yeGqwV2j7bDZ3gsRJRhOzf Rr+kcPWloug6n4gvRa6ZaPO/8TDhU4J+Zug6Hr1rNqaC7ubUg29xLEQwcFHK4YHIIx3BHWsFa+p6 dRTcX7NpPz2C4t2trqW3kZd8bFSVOQSPQ1DS7m27dx29cZ4pKCle2oUVp3MNjaaYkMkF0NTf52Zm wiLnhduMkkc5yR098ZpJIAJJxwPahqwoT5ldI7rwLrvhXw3qZv7v+0ZLoKUR/KTYgJwTgEnOMfr1 zXvVrdQ3tpFdW774ZkDo2CMqehwa+TFYo6uhKspBB9DXpWjfFnXre3a41GG2vbWNo4mIIjkBIPIH 8XCsemMntxXdhcSoLllsfLZ5ktTESVajrLrd/clp+p7fRVXTb6PU9Ltb+JSsdzEsqhuoDDP9atV6 id9T4aUXFuL3QUUUUCCiiigAooooAKKKKACiiigAooooAKKKKACvK/jLrsEdhbaGok+1Oy3RYHCh PnXHvznivVKwNa8H6Xr2s2GpX6NI1oCvknBjkBzjcOvBOetZV4ynBxj1PQyyvRw+JjVrJ2V3p36H zZfafeaZc/Z761ltptofy5VKtgjI4NdP4H8GJ4vN9E8txbtDGGjnCbo9xP3W/Xv/ACr3u70PSdQu Rc3mmWdxOAAJZYFZsDoMkZq1a2ltZW6wWlvFbwr92OJAij6AcVyQwKUrt3R72I4plOhy048s+/RH GeFfhnpGi2YbUbeDUL2RR5vnIskakf3AV4Hueaj1r4VaJqWrQ3tuv2VTLvuoVztkXnO3n5T9OPYd +9orr9hT5eWx4P8AauM9q6yqO7/rY4u8+GulX/iKLVLmWSSGKJIltCoKlVXaMk8ntWFqPwVsLi5e Sw1WW0jdywieHzAgPRR8wPHvmvUaKUsPSluiqWcY6lbkqPRW6beh8ur4Z1CTxS/h6KPdeiVowDxk AE5/75Ga0LD4d+J9Qt2mXTJYQGKhLhTGxwpbgEdOMZ9SK+i/sNobsXf2WD7SBgTeWN4H+917n86n rmWBj1Z7NTiqu0lTgtlv36nn3wv1x30xvD2oyLFqNgSiW8iMkhj65OeuM4wBwAM9a9Br5+mg8QN8 WZhaM0epNdkiQRuE25xkjk+Xj8MV9A1thpuUXF9NDzs7w0KVaNWLX7xc1uze/wAn0Ciiiuk8UKKK KACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigCH7JbfaxdfZ4vtIXZ52wb 9vpnripqKKBtt7hRRRQIKKKKACiiigD/2Q==