20230801
15252900
1.0
FALSE
CalculateField MPM_FuenteCensal_2018 MPM_CAB [MPM_Cabece] VB #
CalculateField MPM_FuenteCensal_2018 MPM_CPRD [MPM_Cpob_R] VB #
CalculateField MPM_FuenteCensal_2018 AFBMO_TOT [Analfabeti] VB #
CalculateField MPM_FuenteCensal_2018 AFBMO_CAB [Anlafabeti] VB #
CalculateField MPM_FuenteCensal_2018 AFBMO_CPRD [Analfabe_1] VB #
CalculateField MPM_FuenteCensal_2018 BLE_TOT [BajoLogroE] VB #
CalculateField MPM_FuenteCensal_2018 BLE_CAB [BajoLogr_1] VB #
CalculateField MPM_FuenteCensal_2018 BLE_CPRD [BajoLogr_2] VB #
CalculateField MPM_FuenteCensal_2018 BSCPI_TOT [BarreraSer] VB #
CalculateField MPM_FuenteCensal_2018 BSCPI_CAB [BarreraS_1] VB #
CalculateField MPM_FuenteCensal_2018 BSCPI_CPRD [BarreraS_2] VB #
CalculateField MPM_FuenteCensal_2018 BASS_TOT [BarreraAcc] VB #
CalculateField MPM_FuenteCensal_2018 BASS_CAB [BarreraA_1] VB #
CalculateField MPM_FuenteCensal_2018 BASS_CPRD [BarreraA_2] VB #
CalculateField MPM_FuenteCensal_2018 TDE_TOT [TasaDepend] VB #
CalculateField MPM_FuenteCensal_2018 TDE_CAB [TasaDepe_1] VB #
CalculateField MPM_FuenteCensal_2018 TDE_CPRD [TasaDepe_2] VB #
CalculateField MPM_FuenteCensal_2018 HC_TOT [Hacinamien] VB #
CalculateField MPM_FuenteCensal_2018 HC_CAB [Hacinami_1] VB #
CalculateField MPM_FuenteCensal_2018 HC_CPRD [Hacinami_2] VB #
CalculateField MPM_FuenteCensal_2018 IEE_TOT [Inadecuada] VB #
CalculateField MPM_FuenteCensal_2018 IEE_CAB [Inadecua_1] VB #
CalculateField MPM_FuenteCensal_2018 IEE_CPRD [Inadecua_2] VB #
CalculateField MPM_FuenteCensal_2018 IE_TOT [Inasistenc] VB #
CalculateField MPM_FuenteCensal_2018 IE_CAB [Inasiste_1] VB #
CalculateField MPM_FuenteCensal_2018 MPM_CAB [MPM_Cabece] VB #
CalculateField MPM_FuenteCensal_2018 MPM_CPRD [MPM_Cpob_R] VB #
CalculateField MPM_FuenteCensal_2018 AFBMO_TOT [Analfabeti] VB #
CalculateField MPM_FuenteCensal_2018 AFBMO_CAB [Anlafabeti] VB #
CalculateField MPM_FuenteCensal_2018 AFBMO_CPRD [Analfabe_1] VB #
CalculateField MPM_FuenteCensal_2018 BLE_TOT [BajoLogroE] VB #
CalculateField MPM_FuenteCensal_2018 BLE_CAB [BajoLogr_1] VB #
CalculateField MPM_FuenteCensal_2018 BLE_CPRD [BajoLogr_2] VB #
CalculateField MPM_FuenteCensal_2018 BSCPI_TOT [BarreraSer] VB #
CalculateField MPM_FuenteCensal_2018 BSCPI_CAB [BarreraS_1] VB #
CalculateField MPM_FuenteCensal_2018 BSCPI_CPRD [BarreraS_2] VB #
CalculateField MPM_FuenteCensal_2018 BASS_TOT [BarreraAcc] VB #
CalculateField MPM_FuenteCensal_2018 BASS_CAB [BarreraA_1] VB #
CalculateField MPM_FuenteCensal_2018 BASS_CPRD [BarreraA_2] VB #
CalculateField MPM_FuenteCensal_2018 TDE_TOT [TasaDepend] VB #
CalculateField MPM_FuenteCensal_2018 TDE_CAB [TasaDepe_1] VB #
CalculateField MPM_FuenteCensal_2018 TDE_CPRD [TasaDepe_2] VB #
CalculateField MPM_FuenteCensal_2018 HC_TOT [Hacinamien] VB #
CalculateField MPM_FuenteCensal_2018 HC_CAB [Hacinami_1] VB #
CalculateField MPM_FuenteCensal_2018 HC_CPRD [Hacinami_2] VB #
CalculateField MPM_FuenteCensal_2018 IEE_TOT [Inadecuada] VB #
CalculateField MPM_FuenteCensal_2018 IEE_CAB [Inasiste_1] VB #
CalculateField MPM_FuenteCensal_2018 IEE_CPRD [Inadecua_2] VB #
CalculateField MPM_FuenteCensal_2018 IE_TOT [Inasistenc] VB #
CalculateField MPM_FuenteCensal_2018 IE_CAB [Inasiste_1] VB #
CalculateField MPM_FuenteCensal_2018 IE_CPRD [Inasiste_2] VB #
CalculateField MPM_FuenteCensal_2018 MIPE_TOT [MatInadecu] VB #
CalculateField MPM_FuenteCensal_2018 MIPE_CAB [MatInade_1] VB #
CalculateField MPM_FuenteCensal_2018 MIPE_CPRD [MatInade_2] VB #
CalculateField MPM_FuenteCensal_2018 MIP_TOT [MatInade_3] VB #
CalculateField MPM_FuenteCensal_2018 MIP_CAB [MatInade_4] VB #
CalculateField MPM_FuenteCensal_2018 MIP_CPRD [MatInade_5] VB #
CalculateField MPM_FuenteCensal_2018 RE_TOT [RezagoEsco] VB #
CalculateField MPM_FuenteCensal_2018 RE_CAB [RezagoEs_1] VB #
CalculateField MPM_FuenteCensal_2018 RE_CPRD [RezagoEs_2] VB #
CalculateField MPM_FuenteCensal_2018 SAFAM_TOT [SinAccesFu] VB #
CalculateField MPM_FuenteCensal_2018 SAFAM_CAB [SinAcces_1] VB #
CalculateField MPM_FuenteCensal_2018 SAFAM_CPRD [SinAcces_2] VB #
CalculateField MPM_FuenteCensal_2018 SAS_TOT [SinAsegurS] VB #
CalculateField MPM_FuenteCensal_2018 SAS_CAB [SinAsegu_1] VB #
CalculateField MPM_FuenteCensal_2018 SAS_CPRD [SinAsegu_2] VB #
CalculateField MPM_FuenteCensal_2018 TRINF_TOT [TrabajoInf] VB #
CalculateField MPM_FuenteCensal_2018 TRINF_CAB [TrabajoI_1] VB #
CalculateField MPM_FuenteCensal_2018 TRINF_CPRD [TrabajoI_2] VB #
CalculateField MPM_FuenteCensal_2018 TRIML_TOT [TrabajoI_3] VB #
CalculateField MPM_FuenteCensal_2018 TRIML_CAB [TrabajoI_4] VB #
CalculateField MPM_FuenteCensal_2018 TRIML_CPRD [TrabajoI_5] VB #
CalculateField MPM_FuenteCensal_2018 IEE_CAB [Inadecua_1] VB #
Project MPM_FuenteCensal_2018 C:\Users\Fernando\Documents\FANDOCORP\UPIT\2_PRODUCTOS\3_DATOS\UPIT_PILOTO_V1.gdb\IND_ECONOMICOS\Pobreza_Multidimensional GEOGCS['GCS_WGS_1984',DATUM['D_WGS_1984',SPHEROID['WGS_1984',6378137.0,298.257223563]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]] MAGNA_To_WGS_1984_1 GEOGCS['GCS_MAGNA',DATUM['D_MAGNA',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]] NO_PRESERVE_SHAPE # NO_VERTICAL
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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/3.0.0'><FeatureDataset>INDICADORES_SOCIOECONOMICOS</FeatureDataset><WorkspaceConnectionString>DATABASE=D:\FRODRIGUEZ\3_DATOS\1\COPIAR\UPIT_INDICADORES_SOCIOECONOMICOS.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Pobreza_Multidimensional</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>CONCAT</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField MPIOS CONCAT "!DPTO_CNMBR! + !MPIO_CNMBR!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField MPIOS DPTO_CNMBR "QUINDIO" "Python 3" # Text NO_ENFORCE_DOMAINS
ExportFeatures MPIOS "C:\Users\Fernando Rodriguez\Documents\ArcGIS\Projects\postulado\postulado.gdb\MPIOS_CAMINOS" # NOT_USE_ALIAS "DPTO_CCDGO "DPTO_CCDGO" true true false 2 Text 0 0,First,#,MPIOS,DPTO_CCDGO,0,2;MPIO_CCDGO "MPIO_CCDGO" true true false 3 Text 0 0,First,#,MPIOS,MPIO_CCDGO,0,3;DPTO_CNMBR "DPTO_CNMBR" true true false 250 Text 0 0,First,#,MPIOS,DPTO_CNMBR,0,250;MPIO_CNMBR "MPIO_CNMBR" true true false 60 Text 0 0,First,#,MPIOS,MPIO_CNMBR,0,60;MPIO_CCNCT "MPIO_CCNCT" true true false 5 Text 0 0,First,#,MPIOS,MPIO_CCNCT,0,5;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,MPIOS,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,MPIOS,Shape_Area,-1,-1;CONCAT "CONCAT" true true false 255 Text 0 0,First,#,MPIOS,CONCAT,0,255" #
CalculateField MPIOS_CAMINOS CONCAT "!DPTO_CNMBR! + !MPIO_CNMBR!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField MPIOS_CAMINOS CONCAT "!DPTO_CNMBR! + !MPIO_CNMBR!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField MPIOS_CAMINOS CONCAT "!DPTO_CNMBR! + !MPIO_CNMBR!" "Python 3" # Text NO_ENFORCE_DOMAINS
ExportFeatures MPIOS_CAMINOS "C:\Users\Fernando Rodriguez\Documents\ArcGIS\Projects\postulado\postulado.gdb\MPIOS_CAMINOS_POSTULADOS" # NOT_USE_ALIAS "DPTO_CCDGO "DPTO_CCDGO" true true false 2 Text 0 0,First,#,MPIOS_CAMINOS,MPIOS_CAMINOS.DPTO_CCDGO,0,2;DPTO_CNMBR "DPTO_CNMBR" true true false 250 Text 0 0,First,#,MPIOS_CAMINOS,MPIOS_CAMINOS.DPTO_CNMBR,0,250;MPIO_CNMBR "MPIO_CNMBR" true true false 60 Text 0 0,First,#,MPIOS_CAMINOS,MPIOS_CAMINOS.MPIO_CNMBR,0,60;MPIO_CCNCT "MPIO_CCNCT" true true false 5 Text 0 0,First,#,MPIOS_CAMINOS,MPIOS_CAMINOS.MPIO_CCNCT,0,5;CONCAT "CONCAT" true true false 255 Text 0 0,First,#,MPIOS_CAMINOS,MPIOS_CAMINOS.CONCAT,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,MPIOS_CAMINOS,MPIOS_CAMINOS.Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,MPIOS_CAMINOS,MPIOS_CAMINOS.Shape_Area,-1,-1;OBJECTID "OBJECTID" false true false 4 Long 0 9,First,#,MPIOS_CAMINOS,Postulados_1004__mpiosfR.OBJECTID,-1,-1;COD_MPIO_I "COD_MPIO_I" true true false 5 Text 0 0,First,#,MPIOS_CAMINOS,Postulados_1004__mpiosfR.COD_MPIO_I,0,5;FREQUENCY "FREQUENCY" true true false 4 Long 0 0,First,#,MPIOS_CAMINOS,Postulados_1004__mpiosfR.FREQUENCY,-1,-1;COUNT_id "COUNT_id" true true false 4 Long 0 0,First,#,MPIOS_CAMINOS,Postulados_1004__mpiosfR.COUNT_id,-1,-1;MAX_Departamento "MAX_Departamento" true true false 255 Text 0 0,First,#,MPIOS_CAMINOS,Postulados_1004__mpiosfR.MAX_Departamento,0,255;MIN_Departamento "MIN_Departamento" true true false 255 Text 0 0,First,#,MPIOS_CAMINOS,Postulados_1004__mpiosfR.MIN_Departamento,0,255" #
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/3.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\Fernando Rodriguez\Documents\ArcGIS\Projects\postulado\postulado.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>MPIOS_CAMINOS_POSTULADOS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>OBJECTID</field_name><field_name>MAX_Departamento</field_name><field_name>MIN_Departamento</field_name></DeleteField></workflow></operationSequence>
CalculateField MPIOS_CAMINOS_POSTULADOS FREQUENCY "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField MPIOS_CAMINOS_POSTULADOS COUNT_id "0" "Python 3" # Text NO_ENFORCE_DOMAINS
Dissolve "New Group Layer\Límite Municipio" "C:\Users\Fernando Rodriguez\Documents\ArcGIS\Projects\ajustes_cpp\ajustes_cpp.gdb\Límite_depto" DPTO_CNMBR "DPTO_CCDGO FIRST" MULTI_PART DISSOLVE_LINES #
ExportFeatures Límite_depto "C:\Users\Fernando Rodriguez\Desktop\POSTULACIONES\upit_priorizacion_cpp\UPIT_AJUSTES_CONSOLIDAR.gdb\Límite_Depto" # NOT_USE_ALIAS "DPTO_CNMBR "DPTO_CNMBR" true true false 250 Text 0 0,First,#,Límite_depto,DPTO_CNMBR,0,250;FIRST_DPTO_CCDGO "FIRST_DPTO_CCDGO" true true false 2 Text 0 0,First,#,Límite_depto,FIRST_DPTO_CCDGO,0,2;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Límite_depto,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Límite_depto,Shape_Area,-1,-1" #
JoinField "Límite Departamento" DPTO_CNMBR TablasCCPPT DPTO_CNMBR Km_vías_regionales "Select transfer fields" #
JoinField "Límite Departamento" DPTO_CNMBR PostulacionesTotal DPTO_CNMBR Postulaciones_Total "Select transfer fields" #
JoinField "Límite Departamento" DPTO_CNMBR Etapas DPTO_CNMBR etapa1;etapa_2;suma "Select transfer fields" #
JoinField "Límite Departamento" DPTO_CNMBR fr_ExcelToTable DPTO_CNMBR SUM_LONG;SUM_LONG_PRIORIZADA "Select transfer fields" #
JoinField "Límite Departamento" DPTO_CNMBR Postulaciones2023_Statistics DPTO_CNMBR N_P2023;KM_P2023 "Select transfer fields" #
JoinField "Límite Departamento" DPTO_CNMBR CorredoresTransit_Statistics DPTO_CNMBR P_TRANS;KM_TRANS "Select transfer fields" #
JoinField "Límite Departamento" DPTO_CNMBR CorredoresTransit_Statistics DPTO_CNMBR P_TRANS;KM_TRANS "Select transfer fields" #
CalculateField "Límite Departamento" P_TRANS "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" KM_TRANS "0" "Python 3" # Text NO_ENFORCE_DOMAINS
DeleteField "Límite Departamento" P_TRANS_1 "Delete Fields"
DeleteField "Límite Departamento" KM_TRANS_1 "Delete Fields"
CopyMultiple "C:\Users\hmfrodriguez\Desktop\POSTULACIONES\upit_priorizacion_cpp\UPIT_AJUSTES_CONSOLIDAR.gdb\Límite_Depto FeatureClass;C:\Users\hmfrodriguez\Desktop\POSTULACIONES\upit_priorizacion_cpp\UPIT_AJUSTES_CONSOLIDAR.gdb\Límite_Municipio FeatureClass;C:\Users\hmfrodriguez\Desktop\POSTULACIONES\upit_priorizacion_cpp\UPIT_AJUSTES_CONSOLIDAR.gdb\Centro_Poblado FeatureClass;C:\Users\hmfrodriguez\Desktop\POSTULACIONES\upit_priorizacion_cpp\UPIT_AJUSTES_CONSOLIDAR.gdb\Cabeceras FeatureClass" C:\Users\hmfrodriguez\Desktop\POSTULACIONES\upit_priorizacion_cpp\PPI_DEPARTAMENTAL.gdb Límite_Depto;Límite_Municipio;Centro_Poblado;Cabeceras "Límite_Depto FeatureClass Límite_Depto #;Límite_Municipio FeatureClass Límite_Municipio #;Centro_Poblado FeatureClass Centro_Poblado #;Cabeceras FeatureClass Cabeceras #"
CopyMultiple "C:\Users\hmfrodriguez\Documents\PPI_PRIORIZACION.gdb\ConcesionesAni FeatureClass;C:\Users\hmfrodriguez\Documents\PPI_PRIORIZACION.gdb\Límite_Depto FeatureClass;C:\Users\hmfrodriguez\Documents\PPI_PRIORIZACION.gdb\Límite_Municipio FeatureClass;C:\Users\hmfrodriguez\Documents\PPI_PRIORIZACION.gdb\Centro_Poblado FeatureClass" "C:\Users\hmfrodriguez\Desktop\POSTULACIONES\upit_priorizacion_cpp\ppi_deptos\PRIORIZACION PPI\PPI_PRIORIZACION.gdb" ConcesionesAni;Límite_Depto;Límite_Municipio_1;Centro_Poblado "ConcesionesAni FeatureClass ConcesionesAni #;Límite_Depto FeatureClass Límite_Depto #;Límite_Municipio FeatureClass Límite_Municipio_1 #;Centro_Poblado FeatureClass Centro_Poblado #"
DeleteField "Límite Departamento" Km_vías_regionales;Postulaciones_Total;etapa1;etapa_2;suma;SUM_LONG;SUM_LONG_PRIORIZADA;N_P2023;KM_P2023;P_TRANS;KM_TRANS "Delete Fields"
JoinField "Límite Departamento" FIRST_DPTO_CCDGO Red_tabla_Excel COD_DEPTO RED_CONCESIONADA_ANI;Proyectos_Estrategicos_INVIAS;RED_SECUNDARIA;VIAS_REGIONALES_PRIORIZADAS_SECUNDARIAS;RED_TERCIARIA;RED_TERCIARIA_DNP_IA;VIAS_REGIONALES_PRIORIZADAS_TERCIARIAS;FERROVIARIA;INVERSION_RADICADO;INVERSION_APROBADO "Select transfer fields" #
AddRelate "Límite Departamento" DPTO_CNMBR datos_ppi DEPARTAMENTO Relate1 "One to many"
JoinField Límite_Depto DPTO_CNMBR datos_ppi DEPARTAMENTO # "Select transfer fields" #
CalculateField "Límite Departamento" PPI_Primaria "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" PPI_Secundaria "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" PPI_Terciaria "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" PPI_Regional "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" PPI_Departamental "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" PPI_Intervenidos_INVIAS "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" PPI_Intervenidos_ANI_Carretero "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" Radicado_Si "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" Radicado_Total "0" "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/3.1.0'><WorkspaceConnectionString>DATABASE=C:\Users\hmfrodriguez\Desktop\POSTULACIONES\upit_priorizacion_cpp\ppi_deptos\PRIORIZACION PPI\PPI_PRIORIZACION.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Límite_Depto</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Nombre_2</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField "Límite Departamento" Nombre_2 !DPTO_CNMBR!.lower() "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" Nombre_2 !DPTO_CNMBR!.swapcase() "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" Nombre_2 !DPTO_CNMBR!.title() "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" Nombre_2 !DPTO_CNMBR!.title() "Python 3" # Text NO_ENFORCE_DOMAINS
DeleteField Límite_Depto DEPARTAMENTO;PPI_Primaria;PPI_Secundaria;PPI_Terciaria;PPI_Regional;PPI_Departamental;PPI_Intervenidos_INVIAS;PPI_Intervenidos_ANI_Carretero;Radicado_Si;Radicado_Total;Nombre_2 "Delete Fields"
JoinField Límite_Depto DPTO_CNMBR TABLAS_CUADROS_FINAL DEPARTAMENTO # "Select transfer fields" #
CalculateField Límite_Depto PPI_Primaria "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Primaria "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Secundaria "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Terciaria "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Regional "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Departamental "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Intervenidos_INVIAS "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Intervenidos_ANI_Carretero "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Primaria_R "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Secundaria_R "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Terciaria_R "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Regional_R "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Departamental_R "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Intervenidos_INVIAS_R "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto PPI_Intervenidos_ANI_Carretero_R "0" "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/3.1.0'><WorkspaceConnectionString>DATABASE=C:\Users\hmfrodriguez\Desktop\POSTULACIONES\upit_priorizacion_cpp\ppi_deptos\PRIORIZACION PPI\PPI_PRIORIZACION.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Límite_Depto</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Nombre_2</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Límite_Depto Nombre_2 !DPTO_CNMBR!.title() "Python 3" # Text NO_ENFORCE_DOMAINS
JoinField "Límite Departamento" DPTO_CNMBR TABLAS_CUADROS_FINAL_ExcelToTable DEPARTAMENTO # "Select transfer fields" #
DeleteField "Límite Departamento" DEPARTAMENTO_1 "Delete Fields"
CalculateField "Límite Departamento" PPI_Primaria_I "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" PPI_Secundaria_I "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" PPI_Terciaria_I "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" PPI_Regional_I "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" PPI_Departamental_I "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" PPI_Intervenidos_INVIAS_I "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Límite Departamento" PPI_Intervenidos_ANI_Carretero_I "0" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto FIRST_DPTO_CCDGO !DPTO_CNMBR! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Límite_Depto DEPARTAMENTO !DPTO_CNMBR! "Python 3" # Text NO_ENFORCE_DOMAINS
JoinField Límite_Depto DPTO_CNMBR Tabla_Base_data_FINAL DPTO_CNMBR # "Select transfer fields" #
DeleteField Límite_Depto DPTO_CNMBR;FIRST_DPTO_CCDGO;RED_CONCESIONADA_ANI;Proyectos_Estrategicos_INVIAS;RED_SECUNDARIA;VIAS_REGIONALES_PRIORIZADAS_SECUNDARIAS;RED_TERCIARIA;RED_TERCIARIA_DNP_IA;VIAS_REGIONALES_PRIORIZADAS_TERCIARIAS;FERROVIARIA;INVERSION_RADICADO;INVERSION_APROBADO;DEPARTAMENTO;PPI_Primaria;PPI_Secundaria;PPI_Terciaria;PPI_Regional;PPI_Departamental;PPI_Intervenidos_INVIAS;PPI_Intervenidos_ANI_Carretero;PPI_Primaria_R;PPI_Secundaria_R;PPI_Terciaria_R;PPI_Regional_R;PPI_Departamental_R;PPI_Intervenidos_INVIAS_R;PPI_Intervenidos_ANI_Carretero_R;Nombre_2;PPI_Primaria_I;PPI_Secundaria_I;PPI_Terciaria_I;PPI_Regional_I;PPI_Departamental_I;PPI_Intervenidos_INVIAS_I;PPI_Intervenidos_ANI_Carretero_I "Delete Fields"
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/3.1.0'><WorkspaceConnectionString>DATABASE=C:\Users\lizette.guio\OneDrive - UPIT\Documentos\10. Mapas departamentos\PPI_PRIORIZACION.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Límite_Depto</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Departamento</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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/3.1.0'><WorkspaceConnectionString>DATABASE=C:\Users\lizette.guio\OneDrive - UPIT\Documentos\10. Mapas departamentos\PPI_PRIORIZACION.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Límite_Depto</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Region_Logistica</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CopyFeatures C:\Users\alejandro.gerena\Desktop\ALEJANDRO_GERENA\Base_PPI_Estructurada\PPI_PRIORIZACION_1.gdb\Límite_Depto C:\Users\alejandro.gerena\Desktop\ALEJANDRO_GERENA\Base_PPI_Estructurada\PPI_PRIORIZACION.gdb\INFORMACION_BASE\Límite_Depto # # # #
Rename C:\Users\alejandro.gerena\Desktop\ALEJANDRO_GERENA\Base_PPI_Estructurada\PPI_PRIORIZACION.gdb\INFORMACION_BASE\Límite_Depto C:\Users\alejandro.gerena\Desktop\ALEJANDRO_GERENA\Base_PPI_Estructurada\PPI_PRIORIZACION.gdb\INFORMACION_BASE\Limite_Depto FeatureClass
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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/3.1.0'><FeatureDataset>INFORMACION_BASE</FeatureDataset><WorkspaceConnectionString>DATABASE=D:\FRODRIGUEZ\3_DATOS\SIG - OGI\PLAN PLURIANUAL DE INVERSIONES - PPI\GDB_Normalizada_V1\GDB_Normalizada_V1\PPI_20240124.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Limite_Depto</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>COD_DEPTO</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Limite_Depto COD_DEPTO !FIRST_DPTO_CCDGO_1! "Python 3" # Text NO_ENFORCE_DOMAINS
AddRelate Limite_Depto DPTO_CNMBR_1 Proyectos_PPI_ExcelToTable CODxDPTO Relate1 "One to many"
RemoveRelate Limite_Depto #
AddRelate Limite_Depto DPTO_CNMBR_1 Proyectos_PPI_ExcelToTable DPTO_CNMBR Relate1 "One to many"
RemoveRelate Limite_Depto #
ExportFeatures Limite_Depto "D:\FRODRIGUEZ\3_DATOS\SIG - OGI\PLAN PLURIANUAL DE INVERSIONES - PPI\GDB_Normalizada_V1\GDB_Normalizada_V1\PPI_20240124.gdb\PPI\Proyectos_PPI_TABLA" # NOT_USE_ALIAS "Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Limite_Depto,Limite_Depto.Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Limite_Depto,Limite_Depto.Shape_Area,-1,-1;COD_DEPTO "COD_DEPTO" true true false 255 Text 0 0,First,#,Limite_Depto,Limite_Depto.COD_DEPTO,0,255;DPTO_CNMBR_1 "DPTO_CNMBR" true true false 255 Text 0 0,First,#,Limite_Depto,Limite_Depto.DPTO_CNMBR_1,0,255;OBJECTID "OBJECTID" false true false 4 Long 0 9,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.OBJECTID,-1,-1;Código_Corredor "Código Corredor" true true false 255 Text 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.Código_Corredor,0,255;Nombre_Corto "Nombre Corto" true true false 255 Text 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.Nombre_Corto,0,255;Nombre_Largo "Nombre Largo" true true false 255 Text 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.Nombre_Largo,0,255;Estado "Estado" true true false 255 Text 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.Estado,0,255;DPTO_CNMBR "DPTO_CNMBR" true true false 255 Text 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.DPTO_CNMBR,0,255;CODxDPTO "CODxDPTO" true true false 255 Text 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.CODxDPTO,0,255;Inversión "Inversión" true true false 8 Double 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.Inversión,-1,-1;Necesidades "Necesidades" true true false 8 Double 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.Necesidades,-1,-1;PGN_Nación "PGN Nación" true true false 8 Double 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.PGN_Nación,-1,-1;PGN_Previo_Nación "PGN Previo Nación" true true false 8 Double 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.PGN_Previo_Nación,-1,-1;PGN_Propios "PGN Propios" true true false 8 Double 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.PGN_Propios,-1,-1;PGN_Previo_Propios "PGN Previo Propios" true true false 8 Double 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.PGN_Previo_Propios,-1,-1;Nombre "Nombre" true true false 255 Text 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.Nombre,0,255;PND "PND" true true false 255 Text 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.PND,0,255;GOBERNACION "GOBERNACION" true true false 255 Text 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.GOBERNACION,0,255;ALCALDIA "ALCALDIA" true true false 255 Text 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.ALCALDIA,0,255;Cruza "Cruza" true true false 255 Text 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.Cruza,0,255;Presidencia "Presidencia" true true false 255 Text 0 0,First,#,Limite_Depto,Proyectos_PPI_ExcelToTable.Presidencia,0,255" #
CopyFeatures C:\Users\soportesig\Desktop\30012024\PPI_20240124.gdb\PPI\Proyectos_PPI_TABLA C:\Users\soportesig\Documents\ArcGIS\Projects\MyProject1\gis001.sde\gis001.sde.Prioriza_proyectos\gis001.sde.Proyectos_PPI_TABLA # # # #
Server=localhost; Service=sde:postgresql:localhost; Database=gis001; User=sde; Version=sde.DEFAULT
ArcSDE Connection
gis001.sde.Proyectos_PPI_TABLA
002
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
<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/3.2.0'><WKT>PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</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>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem>
WGS_1984_Web_Mercator_Auxiliary_Sphere
20240202
10375900
20240202
10375900
Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 17763) ; Esri ArcGIS 13.2.0.49743
Proyectos_PPI_TABLA
Enterprise Geodatabase Feature Class
dataset
EPSG
6.18.3(9.3.1.2)
0
Simple
FALSE
0
TRUE
FALSE
gis001.sde.Proyectos_PPI_TABLA
Feature Class
0
OBJECTID_1
OBJECTID_1
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
OBJECTID
OBJECTID
Integer
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
COD_DEPTO
COD_DEPTO
String
255
0
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
DPTO_CNMBR_1
DPTO_CNMBR
String
255
0
0
Código_Corredor
Código Corredor
String
255
0
0
Nombre_Corto
Nombre Corto
String
255
0
0
Nombre_Largo
Nombre Largo
String
255
0
0
Estado
Estado
String
255
0
0
DPTO_CNMBR
DPTO_CNMBR
String
255
0
0
CODxDPTO
CODxDPTO
String
255
0
0
Inversión
Inversión
Double
8
38
8
Necesidades
Necesidades
Double
8
38
8
PGN_Nación
PGN Nación
Double
8
38
8
PGN_Previo_Nación
PGN Previo Nación
Double
8
38
8
PGN_Propios
PGN Propios
Double
8
38
8
PGN_Previo_Propios
PGN Previo Propios
Double
8
38
8
Nombre
Nombre
String
255
0
0
PND
PND
String
255
0
0
GOBERNACION
GOBERNACION
String
255
0
0
ALCALDIA
ALCALDIA
String
255
0
0
Cruza
Cruza
String
255
0
0
Presidencia
Presidencia
String
255
0
0
st_area(shape)
st_area(shape)
Double
0
0
0
st_perimeter(shape)
st_perimeter(shape)
Double
0
0
0
20240202
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAGolJREFUeJztndtvI+lxxavvvJMidR3NzuzVXhuxDccIYMBA8h/kD81rHvOQ
h+QheYhhwA/ZBFnvendmZyWNSIr37ia7g1MUtdLcRVIkv+7zW2hnRleKap2uqq/qlNv91z+nqaRS
DopiW5Ys+OblC/lk/+Tm34S8jWg6lVE0Ft/1pOQX7rytM+zLJA5lr1yTgufzSVyRcBrL5eBKHjX2
c/lcup1RTyyxxLUdCa4vqB86F/JR83Dbj40YwuI+l6Yi0ySReDbFv6Q3Hopj2XJYa4pj29t+mNkh
ldziFv2ClP2CdEcDCeNIn4vDWkNSXH1694z1T8d2JEkT/bsKnONs9YGT3cFzXL0+LvpdFSZcG9Cw
wPWkWixTrNaIY9tS8H0ZhhMpB3ej2Tzg7lfq8n37XM67lzKKQnmyfyz//F//pnfFv//lb+Vf/vyf
Gn09aR3Ls/a5RmGe68rvv/iVXpSEgGqhpC/kgX9hbUfT7s6on0/BWvxlHEfy+dFj+Z8Xf0UIJf3J
UKI4loNaU2sQ37z8QeJpLKWgoFEXIjDrVs2LELJJ0lw+3S7Ex3Mc+fLRU3nevpDPjz+S33/xN/Lf
z79V8UK62CxXpV6qaNj/8jrsp1gRsk2sXD797uWwJwfVhoaa+9XGzRt++/HP3/gBzUptgw+PEPIq
tjU/JEOwgZPZPOHWixU9ySGEmIHrOHqg0Z+MpFWpS55wodRM7wgxh3g6lXEcymF1T3JbdCeEGII1
by3KY6BBwSLEINI0lelsltveNte286fShJjKNJnJMBxLo1SVPKI1LEKIGaSpSHI9hZJHmBISYhCu
Y0ulUNLRHMgWTgvzBAWLEIOwLVtKfiDDNJX+eCRWsZSrXiwKFiEGilbRD9SMYBhNZBRNNFUEODiE
gBW9IJOniBQsQgzEtR2pFsrqsBJOo1tvsWQSRTKOQpklifrcZWlImoJFiMEjOkU/0JfbQMQmcaS+
ZDAuCDxPBS4LULAIyRiB5+tLOSnq+M5IvbOKmejdomARklFc21G3FURbV+OBVIKi8QV6ChYhGcZ3
PbFtW9sgYNCJgr3JbsEULEJyEml1Rn3tlKdgEUJ2mjiZag3r9mYsE2GERUgO8B1PBrORtjqYDAWL
kBzg2LZ4rqetDn7iGXtiSMEiJCdUCyU577V1LdurvVumQMEiJCc4iKpYwyKEmIJl+LYdRliEEGOg
YBGSI1zblvB6PZiJhXcKFiE5olWpS288lOedC/17KQiMShMpWITkCMuydIv7KA7nG9wNEitAwSIk
Z4zCiXi2a6TlDAWLkBwxSxK1nMHWHRNnCilYhOSI7nggpaAgnmvmr76Zj5oQshS1QkkuBz09JTRx
4w4Fi5Ac4TmupPjP0N2GFCxCiDFQsAjJGWmaavEdMZZZTQ0ULEJyh21ZMo5hl2xp8d2k9gZGWITk
jON6Sz3e++FYnMiWRqlizJgOBYuQHFIOCuK7rp4YoghvChQsQnJKbzyUoufrJh1ToGARkuO5QjGs
6k7BIiTHiynCWTzvyTLEiZSCRUhOmcShFPzAqNVfFCxCckopKMogHGsdy7EcjbSSNNVga1frWhQs
QnJKyQ9kGI7lajzUKOv2WSHEq1muya5BwSIkx9SLZW0ihUBBtCxEVmkqnVFPykFx5wakKViE5Bjf
9fTlNoi4KoXyTh4gUrAIITeMo1C3Q9eLFfF20OCPgkUIuaE7Gqgb6S6KFaBgEUJuGEUTOarvya5C
wSKE3DBva9jNlgZAwSKE3PDQrg3Y2IPTyMDz56NB94SCRQhR4tlMTwzvKyOTKNTFrCjW4+OjKf50
NVoL40j2qw0t5s+SmfZ9HdVbso/N0xQsQsgq7g1YUnFfJtNYznsdOeu25bC+J5VCSX7sXqqFzYvO
S/m/H7+XJ61jaVZr8kP7QtqDvvzu0y+lusTXYoRFCFEGk5E8bh7IMmlkwfOlWanpQPV0NpWDWkNT
v1+cfqKFfERW51cdedQ81Ehr2Y3TFCxCiILO9mEYSq14v8gHkRSE6fYmnkUtDDOJSZrIdDbTf2N5
K97PW7KDnoJFCFGa5ao861zcW7AgSoiw3o7zWjf9slCwCCGKbdsyTWYyiaP3CND2oGARQm542jqW
79pn8sn+iewiFCxCyJ3a03GtKd9dnsmT1pHsGhQsQsgdin6gJ3m7CAWLEPIadBwlhJiDJTsJIyxC
yB3QJzWbJbKLULAIITeg9bM97Inj7KZjAwWLEHJDkiRy0e/KlydPZRehYBFCbkDj6DJDyZuCgkUI
UWALc9HryEljX3YVChYhOY6mkiRR3yoU2rEt57C29+AmfqtAwSIkh4X1MAplMo3UtA/CBbB8Yl1D
yg8FBYuQnDGJQrkaD6QSFKVaKO90RPUqFCxCckZ3PNC9g1hVbxoULELyRorRmx1tZX8PFCxCckeq
dSsU2pfZXLNNKFiE5NAKeRROJHA98RyzJMB92evqaQG+CXwD0Wwq43AiB7U9LczhyPOg2tj24ySE
rIlasay/27MkEW83N9K/Fffr82fSLNflm/Pn8lHrSDrDvq7oedw81G0X2HTxh5//RjdiEEKyge94
uisQ+wN31UrmTbiO7QjS2P54pC6D8TSWNEnk67Nn+s2gLwO7xShYhGSHeqmiq7fag57slWvGtDa4
nx6dagr46ydfqPm869hz9Y1DLcohNcTrCSHZwbWRC1oSTiNJtZXUDNxKUJJm+d3pXn1jD4cQsgm6
o74gu8LvvmNSSojiW9OgkJAQsjpYL98qF9W/3SRc33G1hkUIyQeTONLaNLYwm4ZbCgpGnRJkmQ9p
5EO1gfcXsixoGEWxvewXrutYZuGa+KBN5mo00FPXcBrLafNA20iGk7GeyOLEBjeQSqEkF722HNSa
GrJP4lA6g5581DqWl/2uHogc1Zv6sYiQ0U+DO6bvebJfbey0ARvZLpeDnm51Lvq+cV3uwDXxQZvM
i+6lFHxfepOh9EZDFa8emvhmifpo4+43mIzkrNuW7y/PtZ0EIXwYx3Le62pvXBTH0u5fSTid6ttx
RI3Pd37WkZ+dPJHqMQWLvA4axDFDCMEyNasyqy8/AyAyOrtqS6tSl0E4ksP6njxCpDXoSX88lL1K
TaMq9Mb0w7HUC2U9dp7OZipc8WyqkVl7cKXvM5iM9eKbT98jOitu+1skO8pgMtZrC1G5qZj7yA0F
0RDucDiVRT0BKTmi3NO9AxUlFELt6xNbuEEuTm9R31o4Qwaerza2mAODgAGIFoJlU++c5GGZzubu
omhhMDmromBtGITki6NkX35yd7zvEOric5h40kM2y0DLDGMpBwW92ZkMBYuQDDOKJhpdNUoVNTcw
OboCFCxCMsw4isRzXY2szJaqORQsQjJKev0fhCoLYgUoWIRklCiO9RDGNJO+d5Gd74QQcodRHOop
M2pXWYGCRUhGSdEGY5ljHfMhULAIySiNYkU6o74Mo4nuIMwCFCxCMopt21rDWqyjN3W1120oWIRk
fLLisn8ltjXJxNgWBYuQDGPhxbIy43lHwSIkw1iWNe/GykjtnYJFSMbxHFeSNJEIG7HSVFzXfaeP
OwbqIXSoeU1nibag4nPswlgPBYuQHNSxrkYD6Y6HEsaR1ItlNYl8tQiPIGwShdIPR+LZrg7WD8OJ
ppVYvrrYYYhly2ma3DSlblLIKFiEZBwLLQ6ligoSBqE7w7nrKFxq4VaLiGphX4Q2iMNqQ18HV9y9
clWbT+GGi/fH3xcihlNIuIbM7ZIcfZ32ft2qna0bChYhOcHS9NDRmhZstuHHtjCGhFhBXx419jXy
gjiVb/VuwXobTrhwxEW0BbNICFpvPJTpdKppJj5u4dmGr+U67todIihYhOSMooc9AZFM4lgFBe63
71vzBzGCUOFlAT4WEdgonOgyZkRW+DwQKAihWKHUCmWNwNYFBYuQnFF7RXhWAY65+rne8PmwJAU1
M0Rr62papWARQh6EwPM0+oqmkRS89SxspWARQh4E1LlgzYztThQsQsjOg5rWfJZx3gaxKoywCCEP
hud62tsVaZS1evGdgkUIeTAgUii898YjbYPA5p5Vts1TsAghDwaWtlYLJR0LQo8WivClFUSLgkVe
A41/3dFAOw1hAje7rj9kwU+JbCfKwgvqWJfaMe9SsMh6iGczOe+3pRqUtAHwot+VZ+1zebp/LNVi
Sc6uOlpEbVbqUs2AvxLZHGommM7NBJeFERZ55aLCAGwkB9U9vQteDq60cIqxDFxouFOOo1BHNPC+
CO+tzCyRIg9NJShJfzzS2cNllmNQsMgdnOvOZQjVSb0lh7U9Oa63dEgWKSGaATF2gTk0CNfVaKiR
GKb28TYs7IynUz3OXudIBskGJT/Qa+e815GDauPe1wgFi9wB0/qoX6FYOr/ACq89Q75ri5fObUUW
YoUoCxdibzTUPxduAKx7kdvgekEpAUPTy0DBIneAwKBn5rSx/94Lr+D6Ejg/TeOjOI9IDC84ysYL
7EcIuQ0ic/jLw2/rvlCwyGs1hlqxpPYjqE+9i0WEdXMxWY7WvcI4vnk7Ia8CPy20OqD8cF8oWOQO
6EqGzqxSf/JcV/zE0zspRCtLm4fJ6iAS15vdEh9LwSJaJMeyTVjnPu9eyMcHj8RboRsZbQ+I0NDP
xRoWeRO4mcFM8L5RFgUr5yz6rBBRIZ1D0f0L2N0ukc7BFA4fD6FCyI+CPWx0CbnNfqWuaeH37XM9
NUSHcrU4N/p731VHwcopEJWzXlvGcSQ/O3miF8qzzoV8fvh46doTxi9wYrhXqmiTIGtY5E3gGkHr
TCUoSpzM/eT746Fc9DpaPjiqN+VtULByynm/I99dnsnHBydqmYvU7bOD05VTOIjUMsVUki9srBFD
Snh9Ugi/LAgXyhPPOxc6JN0oVV/7OApWToF97edHj3WbykKk3ufrTci6WdweNRrHzc735ZG3r+ki
HB6etI7uvD8FK6eMoomG5uswVSNknUC8PmodytVoJF+9+Kt8efL05m0UrJyyV6qt5Ev0Nth5RdYB
mh7qpZKk0pQX3Us5abT09RSsHIIlmVgMMF95uR5QcEeHe+ByfpCsT7Rgb9S3xtpuc9o4oGDlEchU
KSiutWYFEcQMYdkp3Gz+JWQd6WEpCKQ76ukNlhFWzoAf0dlVW5tEfWd9HejYEowZREzhYzEnZwjJ
usChEHr60GxKwcoRODY+73X16BhOCuvuk8IWYAy0ossdn5+njmQd4GCoVqxokzMFK0egu/i7yx/l
s8PTB/OqWpw6IpJzhCeQZF2k4tgWBSsvQEAG4Ui7iN/nwrAK+NzRLFZxRI8XIesAI16ojTLCygmo
LyH6Oao1H9QJFEkmC+7kIcoZs2RGwcoD8GLHphIULWFj/JCChQsLULTIOsFlFU8pWJkG3uvaczVD
dDU320uSdG1rw9+GtjVQscgasW1LT56ZEmZQpGDzgkgHfVEQrEUNAEPJ85O7h1OThTHbItIiZB1g
KgPtMhSsDAFx6k9GKliIqNAbVb813EyIycDwj4KVoaI6BpoR3zTLta2t2IJoYkQHfViErBsKVgZA
+jWZhuqVvTDP2xYo7OPxwGOLkHVDwcoAKKpjU818D+B2mzXVx912llrhRMj7oGBlIbqKQ10lX3+D
Q+Om2ycAR3LIQ0HBMh1rfoIy3768XdRiJk2k6DIdJA8DBctwUGSHH3Y5mK7V32rp8YlUtJ2CkIeA
gpUBkIKhdSGcxipay62oXB0flsu2rSeWhDwEFKwMgFQMUQ06gbclVgscCOdsqr1g22qtINmFgpWR
U0L0PpX84rYfioomTirH0WTe3qCLMglZDxSsDICCOwrviGqwz20XHkt7GGmKSsEi64SClQFQO4pc
V65GA00PsVHXc7f3o8U2acuyKVZk7VCwsmLU7xc0sukMexJOIzmqtzZWzUL9DNEd/IrQwIrIqlYs
qaUNIeuEV1RGwHzzMJqoWBxU9zZaeg/jSPrjkUZU6LZHWoqC+7YPAEj2oGAZBgrZEKZxOFEnBnSX
w6EBQ8ee7agF8ibn+CCQmB+sFopS9AsqnBCqdS+4IARQsAwCxnu98dw+plosyY9Xbd1Q86ixr/7p
EAl4Xm1SKpAGAljZUKTIQ0PBMgREUH+5+EEjrM+PHmvrQKtSk3g20yL7NsQCjwUOpmrax4iKbAAK
lgGgx+rHq0tN9ZDyobgOUGgH2xILfF24MvQmsXx3eSaO40jZL2gNC+0NhKwbXlU7DqKY/mQoV6Oh
/PL04zv2MR8iVDdLId7xvngfnUNMRZ51zuVJ61hf/yHe74Hny3G9qTOESA9f9q+0teKwtneP75KQ
D4OCtcPA+aAz6MvFoCs/P3m6lNfVX86fy9dnz6RSKGltC/1Z/fFYhQYCg470Rrkm354/l18+/lQu
eh35qHmkUd0//ce/yOPWsfzdZ7+Qf//qT3JYa8pvnn7x+lovPC5rPtOIvYQQupvvQb9GpKeHbHMg
q0LB2mFedC+1PvXZwSP1s162RwqneJ1hX/724y/lry9fqHC86F5I4Phy2jyQermi7/Osfa7rwJNk
LjgQqDRJZDbDnGJBDmqN9349RHLjMJTn0YVGWkgT8bn3K3W1bmati6wCBWuHgVjBnG+VDcroyQoP
I9kr19Tz/VdPPtc/j/f2td50NR6qaOHvELeCH8gfv/1KfvfpL6QYFOTp/rEMJmNN+xB1tQc9aVZq
b/169WL5Zug5cD1tuagGJakUeIpIVoeCtcOgW/yH7kvd1rxsZAJxeZfAnF7/edRo3bwO65TAH372
61vv+dPb3weEagFaMPBvFuHJOqBg7TCoWX12cCpnvfZKorUtkBICWiaTdUHB2nFQb6oEJWkPe8bV
gGB7gxYM3+HKL7IeKFgmDDYHgYSzWEZRqAKG0Rc4jMLdc5fBCSFWjDPCIuuCgmVIatgoVjTK6oxi
dfWEjztaCCAGi0bSXQJ9XYHra4EfkVbBpvsoWR0KliFAmA6q87YCnNZBCNCCAC+sXWzSxFB0Z9TX
00daJZN1QcEyVLyqhZKOxaBtAKkXhp53ieFkLI5l34wPEbIOKFgGg+gKBW2IVmPLS1TfapfMDdBk
jVCwDAZR1SLKqn3A3N8mwbgOCu6ErBMKluEg7YIsYF5v2wsoFqDGhse0SwJKsgEFy3D0lNBxt771
+VXvLjwepoNk3VCwDActA1OY+FW2v5NwLpnpTYc7x3FWZxcPVLYJBctw5qnX9mpFCzcIeMsvfLWw
OQetDLvYH2YCEP7BZKQ2PWgSRhQNC2pCwcpEJzxEAlHWNlIwiNPVeHCz+AKihW589l4tD/ZLQqzm
z6UnvfFQ02zbsqVWLEueYYRlOGhrQOo1DMe6RWfTQCzx9RcOD2Q1kE6PwokcN1oaOUO0EGVh1+RU
l5AMpVos53aBGgXLcObD0JamZptG7ZdT1qqWBV5kOFFddH/o05mm0ihXb9J8/HzhJVaRokbREKzu
sK/r1ABuFhjTysu8JgUrE2znjBAiGSdTpn/3BPW+3nigYqVr2VR90msLa09K/pv3SrqOoykh9lLq
zzxFRDbVnwMcPfIgWhQsw9MH3KVxNy5eu3xuivT6hDKeTqVWyHdd5b7PG2p+iKQgPouTVLz+Q9I8
13HU1VVvUGmqa95QDsBLHupbFCyD79Jw85zOpppCFNzNCha+7iQKNV3Jw519HTcXREZ6OGLPI6Xb
p6j3rUlZ+j9LDziSNNBh+BDurhu+cW0aCpah4NQIF2izUr9jSbwpkIbgl4/Dze8H27nR+gFhRySM
mtM6Wz5815u3l8ShLv3IcjsJBctQXNvWC1XvqhsWrMXG5103ENwVVKws+8HqTPZ1BX7e/zaP4LIK
BctQUKzFjkFstNl07WLRLAqLG3IX9E+hLQHusEjboSWTKJJ6qfxgDb5hHGnKWS2W1MEjy2T7u8s4
uGsDLEPF3sB1A1EahGNdM4biME61sIV6GE606Nty376NJ69pOpwzgK41u65MQdi1uP5AghUnM90l
WfSDm6+ZVShYBoMjcIxsjONIbNtZe2p4OezJXqmqS1gRVaHTGo4Q2HGIo3iTFmJsIrJCtAtRx3OG
WtJGnx0LUpX9nwcFy2BQS0IqgJQAVsRr/dzXJ1voCZqfRM37hOAMsc3ZxV0Ezz/soJGmQ6y24lKR
7o5bx0NCwTIY6AZM8iAiKMCvGxSIEUXRdeHtoLVk3gNVUWHfSsE73SVzoYeFgmUwSNHm1iPTB0nP
dPSGvBOkgLMU9SP/g1IyLOeAqKElZBKH+nPD50A6j8jsQ288qaQyCkPpDHt6HeTlAISCZTjzoQ4K
yzZApz8EqBL8VGB/H3/85is9yTvvdfRjPzl8JGdX883eX599L//4u394b0o5nc00BcUN5bje0lAb
q9/yAAWLkCVAfe9y0BPPcaTof7hLBiKhP337v/P5S0skcDypX++cnCaJDjbv1+br3N7ELEk0BcVk
Q7lQzF09kYJl+DE6hl8rPs3dNg0OIXByGnjevU7nPjk4UesYNN4incOp61GjqVFy0Sto9PQu4ECK
U+GjejMHZ4KvQ8EyGFzc02Qqe8HurfjKOoiQWpWa9Cfje31cuVDSF3BQ31tKdKwlZg+zAgXLYHBX
Tli+MhZryZ/5LE0kr1CwyJvhCeEHYW24BNAe9DUdzCsULINrKHMDOGut3dpzYyZLuqO+uDYvjwXp
dc0KbSQodKPojh6sTbYTOJYtBc+T9qAnB9W3F+azDK9IQ8EvDGb91nHh4pcRacZFv6t1MRSS8efj
5sFaHqvp4PmB39SLq0s1K4R3/iAciaSWzu9tijiBRfJITpuHklcoWIaiFi/qBmCtHFVhmBnH6Uf1
lriOrTYlm/xF3M3o9afTOkSy3dFAPmmdaO8VeqgwEL7pZk0LK78cR5JkJmlOZzkpWAYCkYGX+qoz
axA9uAsg1TltHtysls+zWCEjxqIH9DotGnIhFGg/gFgUHUc+2lKE47uuHNX2dBgdQ+94THmDgmUg
6L1CVHSCLucVQJqD6KFRxJYWmvGhqI1UGM/L6d5upsOe42p0B194jPggfc8TFKwcgzTnoLpHT/Zr
LvpX6lX/pHUku4zveupeivGc45ydGP4/SGZOOI79JzMAAAAASUVORK5CYII=