20230614
16181100
1.0
FALSE
FeatureClassToFeatureClass "Planilha1$ Events1" C:\DER\SGP\Patos_de_Minas\APRX\Patos_de_minas.gdb Patos_de_minas_topologia # "SRE "SRE" true true false 255 Text 0 0,First,#,Planilha1$ Events1,SRE,0,255;Numero "Numero" true true false 8 Double 0 0,First,#,Planilha1$ Events1,Numero,-1,-1;kminicial "kminicial" true true false 8 Double 0 0,First,#,Planilha1$ Events1,kminicial,-1,-1;kmfinal "kmfinal" true true false 8 Double 0 0,First,#,Planilha1$ Events1,kmfinal,-1,-1;IGGEP "IGGEP" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IGGEP,0,255;IGGETriTR "IGGETriTR" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IGGETriTR,0,255;IGGEtriTJ "IGGEtriTJ" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IGGEtriTJ,0,255;IGGEtriTB "IGGEtriTB" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IGGEtriTB,0,255;IGGER "IGGER" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IGGER,0,255;IGGEdefAF "IGGEdefAF" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IGGEdefAF,0,255;IGGEdefO "IGGEdefO" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IGGEdefO,0,255;IGGEdefD "IGGEdefD" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IGGEdefD,0,255;IGGEdefEX "IGGEdefEX" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IGGEdefEX,0,255;IGGEdefE "IGGEdefE" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IGGEdefE,0,255;IGGEtri "IGGEtri" true true false 8 Double 0 0,First,#,Planilha1$ Events1,IGGEtri,-1,-1;IGGEdef "IGGEdef" true true false 8 Double 0 0,First,#,Planilha1$ Events1,IGGEdef,-1,-1;IGGEpanrem "IGGEpanrem" true true false 8 Double 0 0,First,#,Planilha1$ Events1,IGGEpanrem,-1,-1;IGGEICPF "IGGEICPF" true true false 8 Double 0 0,First,#,Planilha1$ Events1,IGGEICPF,-1,-1;IGGEATRLE "IGGEATRLE" true true false 8 Double 0 0,First,#,Planilha1$ Events1,IGGEATRLE,-1,-1;IGGEATRLD "IGGEATRLD" true true false 8 Double 0 0,First,#,Planilha1$ Events1,IGGEATRLD,-1,-1;IGGEindIGG "IGGEindIGG" true true false 8 Double 0 0,First,#,Planilha1$ Events1,IGGEindIGG,-1,-1;IGGEConcei "IGGEConcei" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IGGEConcei,0,255;DEFD0Viga "DEFD0Viga" true true false 8 Double 0 0,First,#,Planilha1$ Events1,DEFD0Viga,-1,-1;DEFN10 "DEFN10" true true false 255 Text 0 0,First,#,Planilha1$ Events1,DEFN10,0,255;DEFN20 "DEFN20" true true false 255 Text 0 0,First,#,Planilha1$ Events1,DEFN20,0,255;DEFN30 "DEFN30" true true false 255 Text 0 0,First,#,Planilha1$ Events1,DEFN30,0,255;DEFDpro11 "DEFDpro11" true true false 255 Text 0 0,First,#,Planilha1$ Events1,DEFDpro11,0,255;DEFDpr269 "DEFDpr269" true true false 255 Text 0 0,First,#,Planilha1$ Events1,DEFDpr269,0,255;Raiocurva "Raiocurva" true true false 8 Double 0 0,First,#,Planilha1$ Events1,Raiocurva,-1,-1;IRILEMed "IRILEMed" true true false 8 Double 0 0,First,#,Planilha1$ Events1,IRILEMed,-1,-1;IRILEConc "IRILEConc" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IRILEConc,0,255;IRILDMed "IRILDMed" true true false 8 Double 0 0,First,#,Planilha1$ Events1,IRILDMed,-1,-1;IRILDConc "IRILDConc" true true false 255 Text 0 0,First,#,Planilha1$ Events1,IRILDConc,0,255;LOC_ERROR "LOC_ERROR" false true false 50 Text 0 0,First,#,Planilha1$ Events1,LOC_ERROR,0,50" #
FeatureClassToFeatureClass Patos_de_minas_topologia C:\DER\SGP\Dashboard_SGP.gdb SRE # "SRE "SRE" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,SRE,0,255;Numero "Numero" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,Numero,-1,-1;kminicial "kminicial" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,kminicial,-1,-1;kmfinal "kmfinal" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,kmfinal,-1,-1;IGGEP "IGGEP" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IGGEP,0,255;IGGETriTR "IGGETriTR" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IGGETriTR,0,255;IGGEtriTJ "IGGEtriTJ" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IGGEtriTJ,0,255;IGGEtriTB "IGGEtriTB" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IGGEtriTB,0,255;IGGER "IGGER" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IGGER,0,255;IGGEdefAF "IGGEdefAF" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IGGEdefAF,0,255;IGGEdefO "IGGEdefO" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IGGEdefO,0,255;IGGEdefD "IGGEdefD" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IGGEdefD,0,255;IGGEdefEX "IGGEdefEX" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IGGEdefEX,0,255;IGGEdefE "IGGEdefE" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IGGEdefE,0,255;IGGEtri "IGGEtri" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,IGGEtri,-1,-1;IGGEdef "IGGEdef" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,IGGEdef,-1,-1;IGGEpanrem "IGGEpanrem" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,IGGEpanrem,-1,-1;IGGEICPF "IGGEICPF" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,IGGEICPF,-1,-1;IGGEATRLE "IGGEATRLE" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,IGGEATRLE,-1,-1;IGGEATRLD "IGGEATRLD" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,IGGEATRLD,-1,-1;IGGEindIGG "IGGEindIGG" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,IGGEindIGG,-1,-1;IGGEConcei "IGGEConcei" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IGGEConcei,0,255;DEFD0Viga "DEFD0Viga" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,DEFD0Viga,-1,-1;DEFN10 "DEFN10" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,DEFN10,0,255;DEFN20 "DEFN20" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,DEFN20,0,255;DEFN30 "DEFN30" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,DEFN30,0,255;DEFDpro11 "DEFDpro11" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,DEFDpro11,0,255;DEFDpr269 "DEFDpr269" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,DEFDpr269,0,255;Raiocurva "Raiocurva" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,Raiocurva,-1,-1;IRILEMed "IRILEMed" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,IRILEMed,-1,-1;IRILEConc "IRILEConc" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IRILEConc,0,255;IRILDMed "IRILDMed" true true false 8 Double 0 0,First,#,Patos_de_minas_topologia,IRILDMed,-1,-1;IRILDConc "IRILDConc" true true false 255 Text 0 0,First,#,Patos_de_minas_topologia,IRILDConc,0,255;LOC_ERROR "LOC_ERROR" true true false 50 Text 0 0,First,#,Patos_de_minas_topologia,LOC_ERROR,0,50;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Patos_de_minas_topologia,Shape_Length,-1,-1" #
Append Passos C:\DER\SGP\Dashboard_SGP.gdb\SRE "Skip and warn if schema does not match" # # #
Append Passos C:\DER\SGP\Dashboard_SGP.gdb\SRE "Use the field map to reconcile field differences" "SRE "SRE" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,SRE,0,255;Numero "Numero" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,Numero,-1,-1;kminicial "kminicial" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,kminicial,-1,-1;kmfinal "kmfinal" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,kmfinal,-1,-1;IGGEP "IGGEP" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEP,0,255;IGGETriTR "IGGETriTR" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGETriTR,0,255;IGGEtriTJ "IGGEtriTJ" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEtriTJ,0,255;IGGEtriTB "IGGEtriTB" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEtriTB,0,255;IGGER "IGGER" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGER,0,255;IGGEdefAF "IGGEdefAF" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEdefAF,0,255;IGGEdefO "IGGEdefO" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEdefO,0,255;IGGEdefD "IGGEdefD" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEdefD,0,255;IGGEdefEX "IGGEdefEX" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEdefEX,0,255;IGGEdefE "IGGEdefE" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEdefE,0,255;IGGEtri "IGGEtri" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEtri,-1,-1;IGGEdef "IGGEdef" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEdef,-1,-1;IGGEpanrem "IGGEpanrem" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEpanrem,-1,-1;IGGEICPF "IGGEICPF" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEICPF,-1,-1;IGGEATRLE "IGGEATRLE" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEATRLE,-1,-1;IGGEATRLD "IGGEATRLD" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEATRLD,-1,-1;IGGEindIGG "IGGEindIGG" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEindIGG,-1,-1;IGGEConcei "IGGEConcei" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IGGEConcei,0,255;DEFD0Viga "DEFD0Viga" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,DEFD0Viga,-1,-1;DEFN10 "DEFN10" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,DEFN10,-1,-1;DEFN20 "DEFN20" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,DEFN20,0,255;DEFN30 "DEFN30" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,DEFN30,0,255;DEFDpro11 "DEFDpro11" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,DEFDpro11,0,255;DEFDpr269 "DEFDpr269" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,DEFDpr269,-1,-1;Raiocurva "Raiocurva" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,Raiocurva,-1,-1;IRILEMed "IRILEMed" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IRILEMed,-1,-1;IRILEConc "IRILEConc" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IRILEConc,0,255;IRILDMed "IRILDMed" true true false 8 Double 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IRILDMed,-1,-1;IRILDConc "IRILDConc" true true false 255 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,IRILDConc,0,255;LOC_ERROR "LOC_ERROR" true true false 50 Text 0 0,First,#,C:\DER\SGP\Passos\APRX\Passos.gdb\Passos,LOC_ERROR,0,50" # #
CalculateField SRE IRILDConc Lower($feature.IGGEConcei) Arcade # Text NO_ENFORCE_DOMAINS
CalculateField SRE IGGEConcei !IGGEConcei!.title() "Python 3" # Text NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>DATABASE=C:\DER\SGP\Dashboard_SGP.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SRE</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterField><field_name>Numero</field_name><field_alias>Número</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>kminicial</field_name><field_alias>Quilômetro inicial</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>kmfinal</field_name><field_alias>Quilômetro final</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEP</field_name><field_alias>IGGE P</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGETriTR</field_name><field_alias>IGGE Trincas TR</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEtriTJ</field_name><field_alias>IGGE Trincas TJ</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEtriTB</field_name><field_alias>IGGE Trincas TB</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>DATABASE=C:\DER\SGP\Dashboard_SGP.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SRE</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterField><field_name>IGGER</field_name><field_alias>IGGE R</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEdefAF</field_name><field_alias>IGGE Deformações AF</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEdefO</field_name><field_alias>IGGE Deformações O</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEdefD</field_name><field_alias>IGGE Outros defeitos D</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEdefEX</field_name><field_alias>IGGE Outros defeitos EX</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEdefE</field_name><field_alias>IGGE Outros defeitos E</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEtri</field_name><field_alias>IGGE Trincas</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEdef</field_name><field_alias>IGGE Deformações</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEpanrem</field_name><field_alias>IGGE Panelas + Remendos</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>DATABASE=C:\DER\SGP\Dashboard_SGP.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SRE</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterField><field_name>IGGEICPF</field_name><field_alias>IGGE ICPF</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEATRLE</field_name><field_alias>IGGE Flechas nas Trilhas de Roda ATR (LE)</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEATRLD</field_name><field_alias>IGGE Flechas nas Trilhas de Roda ATR (LD)</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEindIGG</field_name><field_alias>IGGE Índice IGGE</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IGGEConcei</field_name><field_alias>IGGE Conceito</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>DEFD0Viga</field_name><field_alias>Deflexão D0 (Viga)</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>DEFN10</field_name><field_alias>Deflexão Número N 10 anos</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>DEFN20</field_name><field_alias>Deflexão Número N 20 anos</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>DEFN30</field_name><field_alias>Deflexão Número N 30 anos</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>DEFDpro11</field_name><field_alias>Deflexão Dadm PRO 11</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>DEFDpr269</field_name><field_alias>Deflexão Dadm PRO 269</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>Raiocurva</field_name><field_alias>Deflexão Raio de Curvatura (Média)</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IRILEMed</field_name><field_alias>IRI (m/km) LE Média</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IRILEConc</field_name><field_alias>IRI (m/km) LE Conceito</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IRILDMed</field_name><field_alias>IRI (m/km) LD Média</field_alias><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>IRILDConc</field_name><field_alias>IRI (m/km) LD Conceito</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>"
CalculateField SRE IGGEConcei !IGGEConcei!.capitalize() "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SRE IGGEConcei !IGGEConcei!.lower() "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SRE IGGEConcei !IGGEConcei!.capitalize() "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SRE IRILDConc !IRILDConc!.capitalize() "Python 3" # Text NO_ENFORCE_DOMAINS
SpatialJoin SRE Rodovias C:\DER\SGP\Dashboard_SGP.gdb\SRE_MG "Join one to one" KEEP_ALL "SRE "SRE" true true false 255 Text 0 0,First,#,SRE,SRE,0,255;Numero "Número" true true false 8 Double 0 0,First,#,SRE,Numero,-1,-1;kminicial "Quilômetro inicial" true true false 8 Double 0 0,First,#,SRE,kminicial,-1,-1;kmfinal "Quilômetro final" true true false 8 Double 0 0,First,#,SRE,kmfinal,-1,-1;IGGEP "IGGE P" true true false 255 Text 0 0,First,#,SRE,IGGEP,0,255;IGGETriTR "IGGE Trincas TR" true true false 255 Text 0 0,First,#,SRE,IGGETriTR,0,255;IGGEtriTJ "IGGE Trincas TJ" true true false 255 Text 0 0,First,#,SRE,IGGEtriTJ,0,255;IGGEtriTB "IGGE Trincas TB" true true false 255 Text 0 0,First,#,SRE,IGGEtriTB,0,255;IGGER "IGGE R" true true false 255 Text 0 0,First,#,SRE,IGGER,0,255;IGGEdefAF "IGGE Deformações AF" true true false 255 Text 0 0,First,#,SRE,IGGEdefAF,0,255;IGGEdefO "IGGE Deformações O" true true false 255 Text 0 0,First,#,SRE,IGGEdefO,0,255;IGGEdefD "IGGE Outros defeitos D" true true false 255 Text 0 0,First,#,SRE,IGGEdefD,0,255;IGGEdefEX "IGGE Outros defeitos EX" true true false 255 Text 0 0,First,#,SRE,IGGEdefEX,0,255;IGGEdefE "IGGE Outros defeitos E" true true false 255 Text 0 0,First,#,SRE,IGGEdefE,0,255;IGGEtri "IGGE Trincas" true true false 8 Double 0 0,First,#,SRE,IGGEtri,-1,-1;IGGEdef "IGGE Deformações" true true false 8 Double 0 0,First,#,SRE,IGGEdef,-1,-1;IGGEpanrem "IGGE Panelas + Remendos" true true false 8 Double 0 0,First,#,SRE,IGGEpanrem,-1,-1;IGGEICPF "IGGE ICPF" true true false 8 Double 0 0,First,#,SRE,IGGEICPF,-1,-1;IGGEATRLE "IGGE Flechas nas Trilhas de Roda ATR (LE)" true true false 8 Double 0 0,First,#,SRE,IGGEATRLE,-1,-1;IGGEATRLD "IGGE Flechas nas Trilhas de Roda ATR (LD)" true true false 8 Double 0 0,First,#,SRE,IGGEATRLD,-1,-1;IGGEindIGG "IGGE Índice IGGE" true true false 8 Double 0 0,First,#,SRE,IGGEindIGG,-1,-1;IGGEConcei "IGGE Conceito" true true false 255 Text 0 0,First,#,SRE,IGGEConcei,0,255;DEFD0Viga "Deflexão D0 (Viga)" true true false 8 Double 0 0,First,#,SRE,DEFD0Viga,-1,-1;DEFN10 "Deflexão Número N 10 anos" true true false 255 Text 0 0,First,#,SRE,DEFN10,0,255;DEFN20 "Deflexão Número N 20 anos" true true false 255 Text 0 0,First,#,SRE,DEFN20,0,255;DEFN30 "Deflexão Número N 30 anos" true true false 255 Text 0 0,First,#,SRE,DEFN30,0,255;DEFDpro11 "Deflexão Dadm PRO 11" true true false 255 Text 0 0,First,#,SRE,DEFDpro11,0,255;DEFDpr269 "Deflexão Dadm PRO 269" true true false 255 Text 0 0,First,#,SRE,DEFDpr269,0,255;Raiocurva "Deflexão Raio de Curvatura (Média)" true true false 8 Double 0 0,First,#,SRE,Raiocurva,-1,-1;IRILEMed "IRI (m/km) LE Média" true true false 8 Double 0 0,First,#,SRE,IRILEMed,-1,-1;IRILEConc "IRI (m/km) LE Conceito" true true false 255 Text 0 0,First,#,SRE,IRILEConc,0,255;IRILDMed "IRI (m/km) LD Média" true true false 8 Double 0 0,First,#,SRE,IRILDMed,-1,-1;IRILDConc "IRI (m/km) LD Conceito" true true false 255 Text 0 0,First,#,SRE,IRILDConc,0,255;LOC_ERROR "LOC_ERROR" true true false 50 Text 0 0,First,#,SRE,LOC_ERROR,0,50;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,SRE,Shape_Length,-1,-1,Rodovias,Shape_Length,-1,-1;CDEXPORTAC "CDEXPORTAC" true true false 8 Double 0 0,First,#,Rodovias,CDEXPORTAC,-1,-1;ANO "ANO" true true false 254 Text 0 0,First,#,Rodovias,ANO,0,254;ROD "ROD" true true false 254 Text 0 0,First,#,Rodovias,ROD,0,254;SREMG "SREMG" true true false 254 Text 0 0,First,#,Rodovias,SREMG,0,254;CDTRECHO "CDTRECHO" true true false 8 Double 0 0,First,#,Rodovias,CDTRECHO,-1,-1;DESCINI "DESCINI" true true false 254 Text 0 0,First,#,Rodovias,DESCINI,0,254;DESFIM "DESFIM" true true false 254 Text 0 0,First,#,Rodovias,DESFIM,0,254;KMINI "KMINI" true true false 254 Text 0 0,First,#,Rodovias,KMINI,0,254;KMFIM "KMFIM" true true false 254 Text 0 0,First,#,Rodovias,KMFIM,0,254;KMEXT "KMEXT" true true false 254 Text 0 0,First,#,Rodovias,KMEXT,0,254;MKINI "MKINI" true true false 254 Text 0 0,First,#,Rodovias,MKINI,0,254;MKFIM "MKFIM" true true false 254 Text 0 0,First,#,Rodovias,MKFIM,0,254;RESP "RESP" true true false 254 Text 0 0,First,#,Rodovias,RESP,0,254;CRGRRG "CRGRRG" true true false 254 Text 0 0,First,#,Rodovias,CRGRRG,0,254;CRGRESP "CRGRESP" true true false 254 Text 0 0,First,#,Rodovias,CRGRESP,0,254;CARAC "CARAC" true true false 254 Text 0 0,First,#,Rodovias,CARAC,0,254;SITFIS "SITFIS" true true false 254 Text 0 0,First,#,Rodovias,SITFIS,0,254;JURIS "JURIS" true true false 254 Text 0 0,First,#,Rodovias,JURIS,0,254;CIDE "CIDE" true true false 254 Text 0 0,First,#,Rodovias,CIDE,0,254;CONSR "CONSR" true true false 254 Text 0 0,First,#,Rodovias,CONSR,0,254;POSI "POSI" true true false 254 Text 0 0,First,#,Rodovias,POSI,0,254;COIN1 "COIN1" true true false 254 Text 0 0,First,#,Rodovias,COIN1,0,254;COIN2 "COIN2" true true false 254 Text 0 0,First,#,Rodovias,COIN2,0,254;COIN3 "COIN3" true true false 254 Text 0 0,First,#,Rodovias,COIN3,0,254;COIN4 "COIN4" true true false 254 Text 0 0,First,#,Rodovias,COIN4,0,254;SREMGANT "SREMGANT" true true false 254 Text 0 0,First,#,Rodovias,SREMGANT,0,254;TRECHOOBS "TRECHOOBS" true true false 254 Text 0 0,First,#,Rodovias,TRECHOOBS,0,254;CLASSFUNC "CLASSFUNC" true true false 254 Text 0 0,First,#,Rodovias,CLASSFUNC,0,254;DENNOM "DENNOM" true true false 254 Text 0 0,First,#,Rodovias,DENNOM,0,254;DENDEC "DENDEC" true true false 254 Text 0 0,First,#,Rodovias,DENDEC,0,254;DENDAT "DENDAT" true true false 254 Text 0 0,First,#,Rodovias,DENDAT,0,254;RMBH "RMBH" true true false 254 Text 0 0,First,#,Rodovias,RMBH,0,254;REGPLAN "REGPLAN" true true false 254 Text 0 0,First,#,Rodovias,REGPLAN,0,254;CONVNUM "CONVNUM" true true false 254 Text 0 0,First,#,Rodovias,CONVNUM,0,254;CONVPUB "CONVPUB" true true false 254 Text 0 0,First,#,Rodovias,CONVPUB,0,254;CONVINI "CONVINI" true true false 254 Text 0 0,First,#,Rodovias,CONVINI,0,254;CONVFIM "CONVFIM" true true false 254 Text 0 0,First,#,Rodovias,CONVFIM,0,254;CONVOBS "CONVOBS" true true false 254 Text 0 0,First,#,Rodovias,CONVOBS,0,254;VMDPASS "VMDPASS" true true false 8 Double 0 0,First,#,Rodovias,VMDPASS,-1,-1;VMDCOLE "VMDCOLE" true true false 8 Double 0 0,First,#,Rodovias,VMDCOLE,-1,-1;VMDLEVE "VMDLEVE" true true false 8 Double 0 0,First,#,Rodovias,VMDLEVE,-1,-1;VMDMED "VMDMED" true true false 8 Double 0 0,First,#,Rodovias,VMDMED,-1,-1;VMDPESA "VMDPESA" true true false 8 Double 0 0,First,#,Rodovias,VMDPESA,-1,-1;VMDTOT "VMDTOT" true true false 254 Text 0 0,First,#,Rodovias,VMDTOT,0,254;SENTTRAF "SENTTRAF" true true false 254 Text 0 0,First,#,Rodovias,SENTTRAF,0,254;INATIVO "INATIVO" true true false 254 Text 0 0,First,#,Rodovias,INATIVO,0,254;OFICIAL "OFICIAL" true true false 254 Text 0 0,First,#,Rodovias,OFICIAL,0,254;NUKMINICIA "NUKMINICIA" true true false 254 Text 0 0,First,#,Rodovias,NUKMINICIA,0,254;NUKMFINALG "NUKMFINALG" true true false 254 Text 0 0,First,#,Rodovias,NUKMFINALG,0,254;TIPO "TIPO" true true false 255 Text 0 0,First,#,Rodovias,TIPO,0,255" Intersect # #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>DATABASE=C:\DER\SGP\Dashboard_SGP.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SRE_MG</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Pavimento</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Pavimento</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField SRE_MG Pavimento "Pavimentada" "Python 3" # Text NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>DATABASE=C:\DER\SGP\Dashboard_SGP.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SRE_MG</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>ANO</field_name><field_name>ROD</field_name><field_name>SREMG</field_name><field_name>CDTRECHO</field_name><field_name>DESCINI</field_name><field_name>DESFIM</field_name><field_name>KMINI</field_name><field_name>KMFIM</field_name><field_name>KMEXT</field_name><field_name>MKINI</field_name><field_name>MKFIM</field_name><field_name>RESP</field_name><field_name>CRGRRG</field_name><field_name>CRGRESP</field_name><field_name>CARAC</field_name><field_name>SITFIS</field_name><field_name>JURIS</field_name><field_name>CIDE</field_name><field_name>CONSR</field_name><field_name>POSI</field_name><field_name>COIN1</field_name><field_name>COIN2</field_name><field_name>COIN3</field_name><field_name>COIN4</field_name><field_name>SREMGANT</field_name><field_name>TRECHOOBS</field_name><field_name>CLASSFUNC</field_name><field_name>DENNOM</field_name><field_name>DENDEC</field_name><field_name>DENDAT</field_name><field_name>RMBH</field_name><field_name>REGPLAN</field_name><field_name>CONVNUM</field_name><field_name>CONVPUB</field_name><field_name>CONVINI</field_name><field_name>CONVFIM</field_name><field_name>CONVOBS</field_name><field_name>VMDPASS</field_name><field_name>VMDCOLE</field_name><field_name>VMDLEVE</field_name><field_name>VMDMED</field_name><field_name>VMDPESA</field_name><field_name>VMDTOT</field_name><field_name>SENTTRAF</field_name><field_name>INATIVO</field_name><field_name>OFICIAL</field_name><field_name>NUKMINICIA</field_name><field_name>NUKMFINALG</field_name><field_name>TIPO</field_name><field_name>Pavimento</field_name></DeleteField></workflow></operationSequence>
FeatureClassToFeatureClass SRE_MG C:\DER\SGP\Dashboard_SGP.gdb SRE_MG_V2 # "Join_Count "Join_Count" true true false 4 Long 0 0,First,#,SRE_MG,SRE_MG.Join_Count,-1,-1;TARGET_FID "TARGET_FID" true true false 4 Long 0 0,First,#,SRE_MG,SRE_MG.TARGET_FID,-1,-1;SRE "SRE" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.SRE,0,255;Numero "Número" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.Numero,-1,-1;kminicial "Quilômetro inicial" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.kminicial,-1,-1;kmfinal "Quilômetro final" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.kmfinal,-1,-1;IGGEP "IGGE P" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IGGEP,0,255;IGGETriTR "IGGE Trincas TR" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IGGETriTR,0,255;IGGEtriTJ "IGGE Trincas TJ" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IGGEtriTJ,0,255;IGGEtriTB "IGGE Trincas TB" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IGGEtriTB,0,255;IGGER "IGGE R" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IGGER,0,255;IGGEdefAF "IGGE Deformações AF" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IGGEdefAF,0,255;IGGEdefO "IGGE Deformações O" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IGGEdefO,0,255;IGGEdefD "IGGE Outros defeitos D" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IGGEdefD,0,255;IGGEdefEX "IGGE Outros defeitos EX" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IGGEdefEX,0,255;IGGEdefE "IGGE Outros defeitos E" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IGGEdefE,0,255;IGGEtri "IGGE Trincas" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.IGGEtri,-1,-1;IGGEdef "IGGE Deformações" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.IGGEdef,-1,-1;IGGEpanrem "IGGE Panelas + Remendos" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.IGGEpanrem,-1,-1;IGGEICPF "IGGE ICPF" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.IGGEICPF,-1,-1;IGGEATRLE "IGGE Flechas nas Trilhas de Roda ATR (LE)" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.IGGEATRLE,-1,-1;IGGEATRLD "IGGE Flechas nas Trilhas de Roda ATR (LD)" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.IGGEATRLD,-1,-1;IGGEindIGG "IGGE Índice IGGE" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.IGGEindIGG,-1,-1;IGGEConcei "IGGE Conceito" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IGGEConcei,0,255;DEFD0Viga "Deflexão D0 (Viga)" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.DEFD0Viga,-1,-1;DEFN10 "Deflexão Número N 10 anos" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.DEFN10,0,255;DEFN20 "Deflexão Número N 20 anos" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.DEFN20,0,255;DEFN30 "Deflexão Número N 30 anos" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.DEFN30,0,255;DEFDpro11 "Deflexão Dadm PRO 11" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.DEFDpro11,0,255;DEFDpr269 "Deflexão Dadm PRO 269" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.DEFDpr269,0,255;Raiocurva "Deflexão Raio de Curvatura (Média)" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.Raiocurva,-1,-1;IRILEMed "IRI (m/km) LE Média" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.IRILEMed,-1,-1;IRILEConc "IRI (m/km) LE Conceito" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IRILEConc,0,255;IRILDMed "IRI (m/km) LD Média" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.IRILDMed,-1,-1;IRILDConc "IRI (m/km) LD Conceito" true true false 255 Text 0 0,First,#,SRE_MG,SRE_MG.IRILDConc,0,255;LOC_ERROR "LOC_ERROR" true true false 50 Text 0 0,First,#,SRE_MG,SRE_MG.LOC_ERROR,0,50;CDEXPORTAC "CDEXPORTAC" true true false 8 Double 0 0,First,#,SRE_MG,SRE_MG.CDEXPORTAC,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,SRE_MG,SRE_MG.Shape_Length,-1,-1;FID "FID" false true false 4 Long 0 9,First,#,SRE_MG,VGEOTRECHOSHAPELine.FID,-1,-1;CDEXPORTAC "CDEXPORTAC" true true false 33 Double 15 32,First,#,SRE_MG,VGEOTRECHOSHAPELine.CDEXPORTAC,-1,-1;ANO "ANO" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.ANO,0,254;ROD "ROD" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.ROD,0,254;SREMG "SREMG" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.SREMG,0,254;CDTRECHO "CDTRECHO" true true false 33 Double 15 32,First,#,SRE_MG,VGEOTRECHOSHAPELine.CDTRECHO,-1,-1;DESCINI "DESCINI" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.DESCINI,0,254;DESFIM "DESFIM" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.DESFIM,0,254;KMINI "KMINI" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.KMINI,0,254;KMFIM "KMFIM" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.KMFIM,0,254;KMEXT "KMEXT" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.KMEXT,0,254;MKINI "MKINI" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.MKINI,0,254;MKFIM "MKFIM" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.MKFIM,0,254;RESP "RESP" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.RESP,0,254;CRGRRG "CRGRRG" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.CRGRRG,0,254;CRGRESP "CRGRESP" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.CRGRESP,0,254;CARAC "CARAC" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.CARAC,0,254;SITFIS "SITFIS" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.SITFIS,0,254;JURIS "JURIS" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.JURIS,0,254;CIDE "CIDE" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.CIDE,0,254;CONSR "CONSR" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.CONSR,0,254;POSI "POSI" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.POSI,0,254;COIN1 "COIN1" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.COIN1,0,254;COIN2 "COIN2" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.COIN2,0,254;COIN3 "COIN3" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.COIN3,0,254;COIN4 "COIN4" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.COIN4,0,254;SREMGANT "SREMGANT" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.SREMGANT,0,254;TRECHOOBS "TRECHOOBS" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.TRECHOOBS,0,254;CLASSFUNC "CLASSFUNC" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.CLASSFUNC,0,254;DENNOM "DENNOM" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.DENNOM,0,254;DENDEC "DENDEC" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.DENDEC,0,254;DENDAT "DENDAT" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.DENDAT,0,254;RMBH "RMBH" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.RMBH,0,254;REGPLAN "REGPLAN" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.REGPLAN,0,254;CONVNUM "CONVNUM" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.CONVNUM,0,254;CONVPUB "CONVPUB" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.CONVPUB,0,254;CONVINI "CONVINI" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.CONVINI,0,254;CONVFIM "CONVFIM" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.CONVFIM,0,254;CONVOBS "CONVOBS" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.CONVOBS,0,254;VMDPASS "VMDPASS" true true false 33 Double 15 32,First,#,SRE_MG,VGEOTRECHOSHAPELine.VMDPASS,-1,-1;VMDCOLE "VMDCOLE" true true false 33 Double 15 32,First,#,SRE_MG,VGEOTRECHOSHAPELine.VMDCOLE,-1,-1;VMDLEVE "VMDLEVE" true true false 33 Double 15 32,First,#,SRE_MG,VGEOTRECHOSHAPELine.VMDLEVE,-1,-1;VMDMED "VMDMED" true true false 33 Double 15 32,First,#,SRE_MG,VGEOTRECHOSHAPELine.VMDMED,-1,-1;VMDPESA "VMDPESA" true true false 33 Double 15 32,First,#,SRE_MG,VGEOTRECHOSHAPELine.VMDPESA,-1,-1;VMDTOT "VMDTOT" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.VMDTOT,0,254;SENTTRAF "SENTTRAF" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.SENTTRAF,0,254;INATIVO "INATIVO" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.INATIVO,0,254;OFICIAL "OFICIAL" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.OFICIAL,0,254;NUKMINICIA "NUKMINICIA" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.NUKMINICIA,0,254;NUKMFINALG "NUKMFINALG" true true false 254 Text 0 0,First,#,SRE_MG,VGEOTRECHOSHAPELine.NUKMFINALG,0,254" #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>DATABASE=C:\DER\SGP\Dashboard_SGP.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SRE_MG_V2</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Pavimento</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Pavimento</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField SRE_MG_V2 Pavimento "Pavimentada" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField SRE_MG_V2 Pavimento "Não Pavimentada" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "IGGE Conceito" CRGRRG "14º CRG Patos de Minas" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "IGGE Conceito" CRGRRG "14º CRG Patos de Minas" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "IGGE Conceito" CRGRRG "24º CRG Passos" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "IRI (m/km) LD Conceito" IRILDConc "Sem Informações" "Python 3" # Text NO_ENFORCE_DOMAINS
SRE_MG_V2
002
file://\\18204490-D-01\C$\DER\SGP\Dashboard_SGP.gdb
Local Area Network
Projected
GCS_SIRGAS_2000
Linear Unit: Meter (1.000000)
SIRGAS_2000_UTM_Zone_23S
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WKT>PROJCS["SIRGAS_2000_UTM_Zone_23S",GEOGCS["GCS_SIRGAS_2000",DATUM["D_SIRGAS_2000",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",10000000.0],PARAMETER["Central_Meridian",-45.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",31983]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>1900</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>31983</WKID><LatestWKID>31983</LatestWKID></ProjectedCoordinateSystem>
20230621
11143300
20230621
11143300
Microsoft Windows 10 Version 10.0 (Build 19044) ; Esri ArcGIS 12.9.4.32739
IRI _m_km_ LD Conceito
IRI _m_km_ LD Conceito
IRI _m_km_ LD Conceito
File Geodatabase Feature Class
dataset
EPSG
6.11(8.1.2)
0
Simple
FALSE
0
TRUE
TRUE
SRE_MG_V2
Feature Class
0
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
Join_Count
Join_Count
Integer
4
0
0
TARGET_FID
TARGET_FID
Integer
4
0
0
SRE
SRE
String
255
0
0
Numero
Número
Double
8
0
0
kminicial
Quilômetro inicial
Double
8
0
0
kmfinal
Quilômetro final
Double
8
0
0
IGGEP
IGGE P
String
255
0
0
IGGETriTR
IGGE Trincas TR
String
255
0
0
IGGEtriTJ
IGGE Trincas TJ
String
255
0
0
IGGEtriTB
IGGE Trincas TB
String
255
0
0
IGGER
IGGE R
String
255
0
0
IGGEdefAF
IGGE Deformações AF
String
255
0
0
IGGEdefO
IGGE Deformações O
String
255
0
0
IGGEdefD
IGGE Outros defeitos D
String
255
0
0
IGGEdefEX
IGGE Outros defeitos EX
String
255
0
0
IGGEdefE
IGGE Outros defeitos E
String
255
0
0
IGGEtri
IGGE Trincas
Double
8
0
0
IGGEdef
IGGE Deformações
Double
8
0
0
IGGEpanrem
IGGE Panelas + Remendos
Double
8
0
0
IGGEICPF
IGGE ICPF
Double
8
0
0
IGGEATRLE
IGGE Flechas nas Trilhas de Roda ATR (LE)
Double
8
0
0
IGGEATRLD
IGGE Flechas nas Trilhas de Roda ATR (LD)
Double
8
0
0
IGGEindIGG
IGGE Índice IGGE
Double
8
0
0
IGGEConcei
IGGE Conceito
String
255
0
0
DEFD0Viga
Deflexão D0 (Viga)
Double
8
0
0
DEFN10
Deflexão Número N 10 anos
String
255
0
0
DEFN20
Deflexão Número N 20 anos
String
255
0
0
DEFN30
Deflexão Número N 30 anos
String
255
0
0
DEFDpro11
Deflexão Dadm PRO 11
String
255
0
0
DEFDpr269
Deflexão Dadm PRO 269
String
255
0
0
Raiocurva
Deflexão Raio de Curvatura (Média)
Double
8
0
0
IRILEMed
IRI (m/km) LE Média
Double
8
0
0
IRILEConc
IRI (m/km) LE Conceito
String
255
0
0
IRILDMed
IRI (m/km) LD Média
Double
8
0
0
IRILDConc
IRI (m/km) LD Conceito
String
255
0
0
LOC_ERROR
LOC_ERROR
String
50
0
0
CDEXPORTAC
CDEXPORTAC
Double
8
0
0
FID
FID
Integer
4
0
0
CDEXPORTAC_1
CDEXPORTAC
Double
8
0
0
ANO
ANO
String
254
0
0
ROD
ROD
String
254
0
0
SREMG
SREMG
String
254
0
0
CDTRECHO
CDTRECHO
Double
8
0
0
DESCINI
DESCINI
String
254
0
0
DESFIM
DESFIM
String
254
0
0
KMINI
KMINI
String
254
0
0
KMFIM
KMFIM
String
254
0
0
KMEXT
KMEXT
String
254
0
0
MKINI
MKINI
String
254
0
0
MKFIM
MKFIM
String
254
0
0
RESP
RESP
String
254
0
0
CRGRRG
CRGRRG
String
254
0
0
CRGRESP
CRGRESP
String
254
0
0
CARAC
CARAC
String
254
0
0
SITFIS
SITFIS
String
254
0
0
JURIS
JURIS
String
254
0
0
CIDE
CIDE
String
254
0
0
CONSR
CONSR
String
254
0
0
POSI
POSI
String
254
0
0
COIN1
COIN1
String
254
0
0
COIN2
COIN2
String
254
0
0
COIN3
COIN3
String
254
0
0
COIN4
COIN4
String
254
0
0
SREMGANT
SREMGANT
String
254
0
0
TRECHOOBS
TRECHOOBS
String
254
0
0
CLASSFUNC
CLASSFUNC
String
254
0
0
DENNOM
DENNOM
String
254
0
0
DENDEC
DENDEC
String
254
0
0
DENDAT
DENDAT
String
254
0
0
RMBH
RMBH
String
254
0
0
REGPLAN
REGPLAN
String
254
0
0
CONVNUM
CONVNUM
String
254
0
0
CONVPUB
CONVPUB
String
254
0
0
CONVINI
CONVINI
String
254
0
0
CONVFIM
CONVFIM
String
254
0
0
CONVOBS
CONVOBS
String
254
0
0
VMDPASS
VMDPASS
Double
8
0
0
VMDCOLE
VMDCOLE
Double
8
0
0
VMDLEVE
VMDLEVE
Double
8
0
0
VMDMED
VMDMED
Double
8
0
0
VMDPESA
VMDPESA
Double
8
0
0
VMDTOT
VMDTOT
String
254
0
0
SENTTRAF
SENTTRAF
String
254
0
0
INATIVO
INATIVO
String
254
0
0
OFICIAL
OFICIAL
String
254
0
0
NUKMINICIA
NUKMINICIA
String
254
0
0
NUKMFINALG
NUKMFINALG
String
254
0
0
Shape_Length
Shape_Length
Double
8
0
0
Length of feature in internal units.
Esri
Positive real numbers that are automatically generated.
20230621
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDziiii
gQUUUUAFFFFABRRRQAUUUUAFFFFACEA9RS0UUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAB
RRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUASm2nWBZzC4iY4VyvBP1oFtMYzIIn2AZLY4
xWlBrYhjgzao0sS7BJkg7cOOPQ/PnI9BT18USDzR9jiBkzyM4HOelAGR5ThN+xtucZx3plbyeJpB
cNM9tGzHOSSec+vrxxWCTkk0AFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFF
FABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUU
AFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA
UUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABR
RRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAKqlmCjqTipr2zmsLt7addsiYyPqMioASDkd
RWxqdw+ow2E10ypN5ewyHq4B4J/l+FRKTi0+htRpe1vFNX82l+Ze8K6emr2eqWI8nz2jV4jIORg8
4PbisbVorWDUpYbQhoo8LvByGI6n862LDTm0qzu9Te6hMRg2QsrnMjN2HHUe+K5xY3f7iM30Gayp
3lUc09B1VKEVGW42ilCszhApLE4A75p00MtvK0U0bRyL1Vhgit7q9jGwyiiimIKKKKACiiigAooo
oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAUcEZGamu7k
3UofaEVVCqo6ACoKKANbSbxnjOmzoZLN38x1UfMpA6g1DNqUqERWhMMKcAKeT7moLO8ezMpRQWkQ
pk9s1bibR/7NHmJcfa884I2n6Vj8EnK29jqSjUhGF0mr7/kZzyySSmVmJcnO7vmpby+udQlWW6la
WRVCBm64HSiW1KwCeNg8WcEjsfQ1XrRWepjOMqbcH+d/yCiiiqMwooooAKKKKACiiigAooooAKKK
KACiiigAooooAKKKKACiiigAooooAKKKKACrmnQ208jrcOEAAIJOO/NU6KAN640/R2Z3ivSiiNmV
RzkgjH9fypUsNHdpE+1YVQVDs3JO8jdj6Y/OsCigDfgsNHG5nu94LIAGONoLc9OvFZmoW1vbNCLe
fzQ8QZz/AHW5yP8APrVOigAooooAKKKKAJ7q4FzKHEMUOFC7Y1wDgYz9TWp4f0FNUkkub64Fpptu
peec9cf3VHcnisStLTbO/u0Z7aF7iGB1aSIHg8+n4VnUfLHexUUm7Ml1WWO53/2baPBpsbHYGOSf
cnuayK6K0m+2T39xdwhYLaE/uBwFJOPzrKmhsjGZILgg4/1bqc5+tEHvHsXOKUU+9ylRRRWhkFFF
FABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUU
AFFFFABT45ZIm3RyMjeqnBplFAGpPqNsthJaWcEiiUqzvI+SSPwrLq2qWqWRdn3zvwEGRs5qpUQS
V0jes2+Vya22XQKKKKswCiiigAooooAKKCCOooIx1oAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigApSCvLAj60A4INdA/iC
0mkLS2CEfNgADuaAHXGt6TPEnmWLNsgMYfZgbsKPX2bn36VUv9Q067tpjHbMtxJJuDEdOfr6YH4U
+PV7Qbg9rhQm1AoHB2gfzyac2tWOflsFwVCkED1Jx+o/KgDC6daK2bvVrS4s7iMWuJZAgDkDjGM/
y/WsagAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK0dN0PUtXDfYLUzb
c9GAyfQZPNZ1WLW7ltZ4XWRwscgfCnHPH+FTLmt7u41a+pa1mBba6jtwhWSOMK+Vxk/Sqt3am0eN
C4ZmQOQARtz2Oa9AhvrHUmjudXsrS2lTLQTMfnfuoYd64TVZbqfUZZbzHnOcnAwMdse1ZQqSnKzV
rHROg4U+Z9/6+/oUqKk8iXyDN5beUDt344zU0enXkqB47aVlboQvWtuZdzBRk9kVaKuXumz6ekRu
AFaRd2zPI+tU6E09glFxdpBRRRTJCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiinwx+bPHGTjewXPpk0AMoroT4bjMjol2CcDa3GMkH/AAqsdAZIVd7mLLIr
8HOAVY/0oAx6K2bzQWt4XmSZSqoGIJ5PGTWTEgkmRGbarMAT6UAbmpac17FYX1nDI0dwojKqh+Vh
wea2mh8PQXkFvdxxyvGpWU+acKoXJJx/FngCi4j+waJcx2EkRto4uJEl+YuepNcOSSSSck1wwput
T5eZpK6TW/8ASPSqVI0VoruW/bTT+vwOkuPEltKUtYdLh+yI2ERmPT1470niG/1AXitClxa2qxqq
bQyqeKqaHpK6hulSUeZAwZojxlfUU+wv9QudZFurmRJJCGhkOVK9SMH2FaezjD4FsZqtKS5Z9bWa
MV5HlbdI7O3qxzTau6tCtvq93Ci7USVgq+gzxVKulO6ucc04yaYUUUUyQooooAKKKKACiiigAooo
oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo6UUUAa2mpYyWkhu7qSKUyBE2v0BB5I
9M1Mthp7WyN/amS6MQhYDZhgBnn0JOPyrDooAuahGlvceVDdGdCoJYNn8OCap0UUAa+grPdTzadE
hcXEZBUDPI5B9qSbQntoJJJr6xRkHMQnDOT6YFV9P1W40xZ/su1ZJk2GTHzKD1x9ao1koz529kb+
0j7NRau1cfFNJA++J2RvVTin2sb3F7DEjFXkkChs9ycVDTkd4pFkRirqQVYHBBHetH5GKeqvsaPi
CYT65dMBgK+we+OP6VmUrMzsWYksTkk96SiK5UkVUlzycu4UUUUyAooooAKKKKACiiigAooooAKK
KKACiiigAoop6RSSrujjd19VUmgBlFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUA
FFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAE4Gaadxzjj3NFFAAF5yTz6dq6DSNVltbE
RJp8kwDH50Yj+lFFAH//2Q==