{ "currentVersion": 10.71, "id": 1, "name": "PIP_SANEAMIENTO", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "flag_pip_activo", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "flag_pip_activo", "type": "esriFieldTypeInteger", "alias": "FLAG PIP ACTIVO", "domain": null }, { "name": "flag_reconstruccion", "type": "esriFieldTypeString", "alias": "FLAG RECONSTRUCCION", "length": 255, "domain": null }, { "name": "flag_inv_ago2016_2019", "type": "esriFieldTypeInteger", "alias": "FLAG INVERSION AGO. 2016 - 2019", "domain": null }, { "name": "flag_inv_23marzo2019", "type": "esriFieldTypeInteger", "alias": "FLAG INVERSION 23 MAR. - 2019", "domain": null }, { "name": "flag_transferencia2018", "type": "esriFieldTypeInteger", "alias": "FLAG TRANFERENCIA A 2018", "domain": null }, { "name": "flag_transferencia2019", "type": "esriFieldTypeInteger", "alias": "FLAG TRANFERENCIA A 2019", "domain": null }, { "name": "flag_vizcarra", "type": "esriFieldTypeInteger", "alias": "FLAG PDTE. VIZCARRA", "domain": null }, { "name": "anio_termino_compromiso", "type": "esriFieldTypeString", "alias": "Año de termino compromiso", "length": 255, "domain": null }, { "name": "mes_termino_compromiso", "type": "esriFieldTypeInteger", "alias": "Mes de termino compromiso", "domain": null }, { "name": "etapa_compromiso", "type": "esriFieldTypeString", "alias": "ETAPA compromiso", "length": 255, "domain": null }, { "name": "monitoreo_pcm", "type": "esriFieldTypeString", "alias": "MONITOREO PCM", "length": 255, "domain": null }, { "name": "anio_termino_compromiso_act", "type": "esriFieldTypeString", "alias": "Año de termino compromiso actualizado", "length": 255, "domain": null }, { "name": "mes_termino_compromiso_act", "type": "esriFieldTypeString", "alias": "Mes de termino compromiso actualizado", "length": 255, "domain": null }, { "name": "grupo_cumplido_porcumplir", "type": "esriFieldTypeString", "alias": "Grupo cumplido por cumplir", "length": 255, "domain": null }, { "name": "id_saldo_proyectossp", "type": "esriFieldTypeString", "alias": "ID SALDO_PROYECTO SSP", "length": 255, "domain": null }, { "name": "id_proyectossp", "type": "esriFieldTypeInteger", "alias": "ID PROYECTO SSP", "domain": null }, { "name": "ubigeo", "type": "esriFieldTypeString", "alias": "UBIGEO", "length": 255, "domain": null }, { "name": "ubigeo_ccpp", "type": "esriFieldTypeString", "alias": "Ubigeo CCPP", "length": 255, "domain": null }, { "name": "x_longitud", "type": "esriFieldTypeDouble", "alias": "X (ESTE)", "domain": null }, { "name": "y_longitud", "type": "esriFieldTypeDouble", "alias": "Y (NORTE)", "domain": null }, { "name": "modalidad_financiamientossp", "type": "esriFieldTypeString", "alias": "MODALIDAD DE FINANCIAMIENTO SSP", "length": 255, "domain": null }, { "name": "programa", "type": "esriFieldTypeString", "alias": "PROGRAMA", "length": 255, "domain": null }, { "name": "codigo_snip", "type": "esriFieldTypeString", "alias": "CODIGO SNIP", "length": 255, "domain": null }, { "name": "codigo_unificado", "type": "esriFieldTypeString", "alias": "codigo_unificado", "length": 255, "domain": null }, { "name": "departamento", "type": "esriFieldTypeString", "alias": "departamento", "length": 255, "domain": null }, { "name": "provincia", "type": "esriFieldTypeString", "alias": "provincia", "length": 255, "domain": null }, { "name": "distrito", "type": "esriFieldTypeString", "alias": "distrito", "length": 255, "domain": null }, { "name": "centro_poblado", "type": "esriFieldTypeString", "alias": "centro_poblado", "length": 309, "domain": null }, { "name": "nombre_proyecto", "type": "esriFieldTypeString", "alias": "nombre_proyecto", "length": 549, "domain": null }, { "name": "unidad_ejecutora", "type": "esriFieldTypeString", "alias": "unidad_ejecutora", "length": 255, "domain": null }, { "name": "costo_proyecto", "type": "esriFieldTypeDouble", "alias": "COSTO DEL PROYECTO S/", "domain": null }, { "name": "total_inversion", "type": "esriFieldTypeDouble", "alias": "total_inversion", "domain": null }, { "name": "total_inv_gestion", "type": "esriFieldTypeDouble", "alias": "total_inv_gestion", "domain": null }, { "name": "total_inv_gestion_ant", "type": "esriFieldTypeDouble", "alias": "total_inv_gestion_ant", "domain": null }, { "name": "total_modalidad_transf", "type": "esriFieldTypeDouble", "alias": "total_modalidad_transf", "domain": null }, { "name": "total_inver_modalidad_contrata", "type": "esriFieldTypeDouble", "alias": "total_inver_modalidad_contrata", "domain": null }, { "name": "poblacion_beneficiada", "type": "esriFieldTypeDouble", "alias": "poblacion_beneficiada", "domain": null }, { "name": "nro_conexiones_aguassp", "type": "esriFieldTypeString", "alias": "nro_conexiones_aguassp", "length": 255, "domain": null }, { "name": "nro_conexiones_ubsssp", "type": "esriFieldTypeString", "alias": "nro_conexiones_ubsssp", "length": 255, "domain": null }, { "name": "nro_conexiones_agua_rehab", "type": "esriFieldTypeString", "alias": "nro_conexiones_agua_rehab", "length": 255, "domain": null }, { "name": "nro_conexiones_desague_rehab", "type": "esriFieldTypeString", "alias": "nro_conexiones_desague_rehab", "length": 255, "domain": null }, { "name": "metas_pavimento", "type": "esriFieldTypeInteger", "alias": "metas_pavimento", "domain": null }, { "name": "metas_vereda", "type": "esriFieldTypeInteger", "alias": "metas_vereda", "domain": null }, { "name": "tipo_proyecto", "type": "esriFieldTypeString", "alias": "tipo_proyecto", "length": 255, "domain": null }, { "name": "ds_aprobo_financiamiento", "type": "esriFieldTypeString", "alias": "ds_aprobo_financiamiento", "length": 255, "domain": null }, { "name": "estado_carpeta", "type": "esriFieldTypeString", "alias": "estado_carpeta", "length": 255, "domain": null }, { "name": "sub_estado_carpeta", "type": "esriFieldTypeString", "alias": "sub_estado_carpeta", "length": 255, "domain": null }, { "name": "filtro_activo2019", "type": "esriFieldTypeInteger", "alias": "filtro_activo2019", "domain": null }, { "name": "unidad", "type": "esriFieldTypeString", "alias": "unidad", "length": 255, "domain": null }, { "name": "cinco_cuencas", "type": "esriFieldTypeInteger", "alias": "cinco_cuencas", "domain": null }, { "name": "cuatro_cuencas", "type": "esriFieldTypeInteger", "alias": "cuatro_cuencas", "domain": null }, { "name": "fecha_ultima_act", "type": "esriFieldTypeDate", "alias": "fecha_ultima_act", "length": 8, "domain": null }, { "name": "hoy", "type": "esriFieldTypeDate", "alias": "hoy", "length": 8, "domain": null }, { "name": "dias_desactualizados", "type": "esriFieldTypeDouble", "alias": "dias_desactualizados", "domain": null }, { "name": "etapa_ssp", "type": "esriFieldTypeString", "alias": "etapa_ssp", "length": 255, "domain": null }, { "name": "estado", "type": "esriFieldTypeString", "alias": "estado", "length": 255, "domain": null }, { "name": "subestado", "type": "esriFieldTypeString", "alias": "subestado", "length": 255, "domain": null }, { "name": "subestado2", "type": "esriFieldTypeString", "alias": "subestado2", "length": 255, "domain": null }, { "name": "flag_diferente_etapa", "type": "esriFieldTypeInteger", "alias": "flag_diferente_etapa", "domain": null }, { "name": "fis_2019_9", "type": "esriFieldTypeDouble", "alias": "fis_2019_9", "domain": null }, { "name": "fis_2019_8", "type": "esriFieldTypeDouble", "alias": "fis_2019_8", "domain": null }, { "name": "fis_2019_7", "type": "esriFieldTypeDouble", "alias": "fis_2019_7", "domain": null }, { "name": "fis_2019_6", "type": "esriFieldTypeDouble", "alias": "fis_2019_6", "domain": null }, { "name": "fis_2019_5", "type": "esriFieldTypeDouble", "alias": "fis_2019_5", "domain": null }, { "name": "fis_2019_4", "type": "esriFieldTypeDouble", "alias": "fis_2019_4", "domain": null }, { "name": "fis_2019_3", "type": "esriFieldTypeDouble", "alias": "fis_2019_3", "domain": null }, { "name": "fis_2019_2", "type": "esriFieldTypeDouble", "alias": "fis_2019_2", "domain": null }, { "name": "fis_2019_1", "type": "esriFieldTypeDouble", "alias": "fis_2019_1", "domain": null }, { "name": "fis_2018_12", "type": "esriFieldTypeDouble", "alias": "fis_2018_12", "domain": null }, { "name": "fis_2018_11", "type": "esriFieldTypeDouble", "alias": "fis_2018_11", "domain": null }, { "name": "fis_2018_10", "type": "esriFieldTypeDouble", "alias": "fis_2018_10", "domain": null }, { "name": "sin_variacion_avance_fisico", "type": "esriFieldTypeString", "alias": "sin_variacion_avance_fisico", "length": 255, "domain": null }, { "name": "tiene_informe", "type": "esriFieldTypeString", "alias": "tiene_informe", "length": 255, "domain": null }, { "name": "tiene_acta", "type": "esriFieldTypeString", "alias": "tiene_acta", "length": 255, "domain": null }, { "name": "tiene_oficio", "type": "esriFieldTypeString", "alias": "tiene_oficio", "length": 255, "domain": null }, { "name": "nom_tipo_monitoreo", "type": "esriFieldTypeString", "alias": "nom_tipo_monitoreo", "length": 255, "domain": null }, { "name": "monitoreo_fisico_sindocs", "type": "esriFieldTypeInteger", "alias": "monitoreo_fisico_sindocs", "domain": null }, { "name": "pip_sin_registrossp", "type": "esriFieldTypeInteger", "alias": "pip_sin_registrossp", "domain": null }, { "name": "pip_desactualizados", "type": "esriFieldTypeInteger", "alias": "pip_desactualizados", "domain": null }, { "name": "pip_sin_regmetas", "type": "esriFieldTypeInteger", "alias": "pip_sin_regmetas", "domain": null }, { "name": "pip_sin_metasprog", "type": "esriFieldTypeInteger", "alias": "pip_sin_metasprog", "domain": null }, { "name": "pip_sin_metasejec", "type": "esriFieldTypeInteger", "alias": "pip_sin_metasejec", "domain": null }, { "name": "pip_sin_fechainicio", "type": "esriFieldTypeInteger", "alias": "pip_sin_fechainicio", "domain": null }, { "name": "pip_sin_fecharealculm", "type": "esriFieldTypeInteger", "alias": "pip_sin_fecharealculm", "domain": null }, { "name": "pip_recep_obs_desact", "type": "esriFieldTypeInteger", "alias": "pip_recep_obs_desact", "domain": null }, { "name": "pip_concluido_sinfecharecep", "type": "esriFieldTypeString", "alias": "pip_concluido_sinfecharecep", "length": 255, "domain": null }, { "name": "pip_sinfechaterminoest", "type": "esriFieldTypeString", "alias": "pip_sinfechaterminoest", "length": 255, "domain": null }, { "name": "pip_confechaterminoest_vencido", "type": "esriFieldTypeString", "alias": "pip_confechaterminoest_vencido", "length": 255, "domain": null }, { "name": "pip_sincoord_proyecto", "type": "esriFieldTypeString", "alias": "pip_sincoord_proyecto", "length": 255, "domain": null }, { "name": "pip_sincoord_componente", "type": "esriFieldTypeString", "alias": "pip_sincoord_componente", "length": 255, "domain": null }, { "name": "pip_sinreg_fecha_paralizacion", "type": "esriFieldTypeString", "alias": "pip_sinreg_fecha_paralizacion", "length": 255, "domain": null }, { "name": "pip_sinasignar_revision", "type": "esriFieldTypeString", "alias": "pip_sinasignar_revision", "length": 255, "domain": null }, { "name": "pip_sinreg_nombccpp", "type": "esriFieldTypeString", "alias": "pip_sinreg_nombccpp", "length": 255, "domain": null }, { "name": "pip_sinfecha_firmacontrato", "type": "esriFieldTypeString", "alias": "pip_sinfecha_firmacontrato", "length": 255, "domain": null }, { "name": "pip_sinfechafirmacontrato", "type": "esriFieldTypeString", "alias": "pip_sinfechafirmacontrato", "length": 255, "domain": null }, { "name": "pip_conejecucionatrasada", "type": "esriFieldTypeString", "alias": "pip_conejecucionatrasada", "length": 255, "domain": null }, { "name": "fecha_ultimo_monitoreo", "type": "esriFieldTypeString", "alias": "fecha_ultimo_monitoreo", "length": 255, "domain": null }, { "name": "categoria_monitoreo_fisico", "type": "esriFieldTypeString", "alias": "categoria_monitoreo_fisico", "length": 255, "domain": null }, { "name": "fecha_ultimo_monitoreo_telef", "type": "esriFieldTypeString", "alias": "fecha_ultimo_monitoreo_telef", "length": 255, "domain": null }, { "name": "fecha_ultimo_monitoreo_web", "type": "esriFieldTypeString", "alias": "fecha_ultimo_monitoreo_web", "length": 255, "domain": null }, { "name": "numero_total_visitas_monitoreo", "type": "esriFieldTypeString", "alias": "numero_total_visitas_monitoreo", "length": 255, "domain": null }, { "name": "categorias_desact", "type": "esriFieldTypeString", "alias": "categorias_desact", "length": 255, "domain": null }, { "name": "anio_estimado_prog_termino_obra", "type": "esriFieldTypeInteger", "alias": "anio_estimado_prog_termino_obra", "domain": null }, { "name": "field", "type": "esriFieldTypeString", "alias": "field", "length": 255, "domain": null }, { "name": "field_1", "type": "esriFieldTypeString", "alias": "field_1", "length": 255, "domain": null }, { "name": "field_1_2", "type": "esriFieldTypeString", "alias": "field_1_2", "length": 255, "domain": null }, { "name": "field_1__3", "type": "esriFieldTypeInteger", "alias": "field_1__3", "domain": null }, { "name": "field_1__4", "type": "esriFieldTypeInteger", "alias": "field_1__4", "domain": null }, { "name": "field_1__5", "type": "esriFieldTypeInteger", "alias": "field_1__5", "domain": null }, { "name": "field_1__6", "type": "esriFieldTypeInteger", "alias": "field_1__6", "domain": null }, { "name": "field_1__7", "type": "esriFieldTypeDouble", "alias": "field_1__7", "domain": null }, { "name": "field_1__8", "type": "esriFieldTypeDouble", "alias": "field_1__8", "domain": null }, { "name": "field_1__9", "type": "esriFieldTypeDouble", "alias": "field_1__9", "domain": null }, { "name": "field_1__10", "type": "esriFieldTypeInteger", "alias": "field_1__10", "domain": null }, { "name": "field_1__11", "type": "esriFieldTypeInteger", "alias": "field_1__11", "domain": null }, { "name": "field_1__12", "type": "esriFieldTypeDouble", "alias": "field_1__12", "domain": null }, { "name": "field_1__13", "type": "esriFieldTypeDouble", "alias": "field_1__13", "domain": null }, { "name": "field_1__14", "type": "esriFieldTypeDouble", "alias": "field_1__14", "domain": null }, { "name": "field_1__15", "type": "esriFieldTypeDouble", "alias": "field_1__15", "domain": null }, { "name": "field_1__16", "type": "esriFieldTypeDouble", "alias": "field_1__16", "domain": null }, { "name": "field_1__17", "type": "esriFieldTypeDouble", "alias": "field_1__17", "domain": null }, { "name": "field_1__18", "type": "esriFieldTypeDouble", "alias": "field_1__18", "domain": null }, { "name": "field_1__19", "type": "esriFieldTypeDouble", "alias": "field_1__19", "domain": null }, { "name": "field_1__20", "type": "esriFieldTypeDouble", "alias": "field_1__20", "domain": null }, { "name": "field_1__21", "type": "esriFieldTypeDouble", "alias": "field_1__21", "domain": null }, { "name": "field_1__22", "type": "esriFieldTypeDouble", "alias": "field_1__22", "domain": null }, { "name": "field_1__23", "type": "esriFieldTypeDouble", "alias": "field_1__23", "domain": null }, { "name": "field_1__24", "type": "esriFieldTypeDouble", "alias": "field_1__24", "domain": null }, { "name": "field_1__25", "type": "esriFieldTypeDouble", "alias": "field_1__25", "domain": null }, { "name": "field_1__26", "type": "esriFieldTypeDouble", "alias": "field_1__26", "domain": null }, { "name": "field_1__27", "type": "esriFieldTypeDouble", "alias": "field_1__27", "domain": null }, { "name": "field_1__28", "type": "esriFieldTypeDouble", "alias": "field_1__28", "domain": null }, { "name": "field_1__29", "type": "esriFieldTypeDouble", "alias": "field_1__29", "domain": null }, { "name": "field_1__30", "type": "esriFieldTypeDouble", "alias": "field_1__30", "domain": null }, { "name": "field_1__31", "type": "esriFieldTypeString", "alias": "field_1__31", "length": 255, "domain": null }, { "name": "field_1__32", "type": "esriFieldTypeInteger", "alias": "field_1__32", "domain": null }, { "name": "field_1__33", "type": "esriFieldTypeInteger", "alias": "field_1__33", "domain": null }, { "name": "field_1__34", "type": "esriFieldTypeInteger", "alias": "field_1__34", "domain": null }, { "name": "field_1__35", "type": "esriFieldTypeString", "alias": "field_1__35", "length": 255, "domain": null }, { "name": "field_1__36", "type": "esriFieldTypeInteger", "alias": "field_1__36", "domain": null }, { "name": "pip_ultfecha_termino_ant_afecha", "type": "esriFieldTypeInteger", "alias": "pip_ultfecha_termino_ant_afechaactual", "domain": null }, { "name": "pip_confirma_contratodesact_mas", "type": "esriFieldTypeString", "alias": "pip_confirma_contratodesact_mas3meses", "length": 255, "domain": null }, { "name": "pip_confecha_buenapro_postalafe", "type": "esriFieldTypeString", "alias": "pip_confecha_buenapro_postalafechafirmacontrato", "length": 255, "domain": null }, { "name": "pip_actosprevios_cuentan_fechai", "type": "esriFieldTypeString", "alias": "pip_actosprevios_cuentan_fechainicio", "length": 255, "domain": null }, { "name": "pip_sinfecha_publicacion_convoc", "type": "esriFieldTypeString", "alias": "pip_sinfecha_publicacion_convocatoria", "length": 255, "domain": null }, { "name": "pip_confechaact_termino_antalaf", "type": "esriFieldTypeString", "alias": "pip_confechaact_termino_antalafechaact", "length": 255, "domain": null }, { "name": "fecha_ultimo_monitoreo_fisico_v", "type": "esriFieldTypeString", "alias": "fecha_ultimo_monitoreo_fisico_visita", "length": 255, "domain": null }, { "name": "dias_transcurridos_monitoreo_fi", "type": "esriFieldTypeString", "alias": "dias_transcurridos_monitoreo_fisico", "length": 255, "domain": null }, { "name": "fecha_ultimo_monitoreo_fisico_d", "type": "esriFieldTypeString", "alias": "fecha_ultimo_monitoreo_fisico_docpres", "length": 255, "domain": null }, { "name": "flag_pip_activo2", "type": "esriFieldTypeSmallInteger", "alias": "flag_pip_activo2", "domain": null }, { "name": "flag_inv_ago2016_2019_2", "type": "esriFieldTypeSmallInteger", "alias": "flag_inv_ago2016_2019_2", "domain": null }, { "name": "flag_inv_23marzo2019_2", "type": "esriFieldTypeSmallInteger", "alias": "flag_inv_23marzo2019_2", "domain": null }, { "name": "flag_transferencia2018_2", "type": "esriFieldTypeSmallInteger", "alias": "flag_transferencia2018_2", "domain": null }, { "name": "flag_transferencia2019_2", "type": "esriFieldTypeSmallInteger", "alias": "flag_transferencia2019_2", "domain": null }, { "name": "flag_vizcarra_2", "type": "esriFieldTypeSmallInteger", "alias": "flag_vizcarra_2", "domain": null }, { "name": "anio_est_prog_termino_obra_2", "type": "esriFieldTypeString", "alias": "anio_est_prog_termino_obra_2", "length": 10, "domain": null }, { "name": "flag_diferente_etapa_2", "type": "esriFieldTypeSmallInteger", "alias": "flag_diferente_etapa_2", "domain": null }, { "name": "pip_confirma_contratodesact_tre", "type": "esriFieldTypeInteger", "alias": "pip_confirma_contratodesact_tre", "domain": null }, { "name": "pip_confec_buenapro_postfechafi", "type": "esriFieldTypeInteger", "alias": "pip_confec_buenapro_postfechafi", "domain": null } ], "indexes": [ { "name": "r640_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }