{
 "currentVersion": 10.71,
 "id": 2,
 "name": "tabla_proyectos",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "ubigeo",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "objectid",
   "type": "esriFieldTypeOID",
   "alias": "objectid",
   "domain": null
  },
  {
   "name": "filtro_obligatorio",
   "type": "esriFieldTypeDouble",
   "alias": "filtro_obligatorio",
   "domain": null
  },
  {
   "name": "iddproyecto_ssp",
   "type": "esriFieldTypeString",
   "alias": "iddproyecto_ssp",
   "length": 20,
   "domain": null
  },
  {
   "name": "codigo_dgpp",
   "type": "esriFieldTypeString",
   "alias": "codigo_dgpp",
   "length": 20,
   "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": "ubigeo_ccpp1",
   "type": "esriFieldTypeString",
   "alias": "ubigeo_ccpp1",
   "length": 255,
   "domain": null
  },
  {
   "name": "modalidad_financiamiento",
   "type": "esriFieldTypeString",
   "alias": "modalidad_financiamiento",
   "length": 255,
   "domain": null
  },
  {
   "name": "programa",
   "type": "esriFieldTypeString",
   "alias": "programa",
   "length": 255,
   "domain": null
  },
  {
   "name": "codigo_snip",
   "type": "esriFieldTypeString",
   "alias": "codigo_snip",
   "length": 20,
   "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": 400,
   "domain": null
  },
  {
   "name": "x_longitud",
   "type": "esriFieldTypeDouble",
   "alias": "x_longitud",
   "domain": null
  },
  {
   "name": "y_longitud",
   "type": "esriFieldTypeDouble",
   "alias": "y_longitud",
   "domain": null
  },
  {
   "name": "nombre_proyecto",
   "type": "esriFieldTypeString",
   "alias": "nombre_proyecto",
   "length": 255,
   "domain": null
  },
  {
   "name": "unidad_ejecutora",
   "type": "esriFieldTypeString",
   "alias": "unidad_ejecutora",
   "length": 255,
   "domain": null
  },
  {
   "name": "costo_proyecto",
   "type": "esriFieldTypeDouble",
   "alias": "costo_proyecto",
   "domain": null
  },
  {
   "name": "total_inversion_oeee",
   "type": "esriFieldTypeDouble",
   "alias": "total_inversion_oeee",
   "domain": null
  },
  {
   "name": "total_inversion_actual_gestion",
   "type": "esriFieldTypeDouble",
   "alias": "total_inversion_actual_gestion",
   "domain": null
  },
  {
   "name": "total_inversion_gestiones_anter",
   "type": "esriFieldTypeDouble",
   "alias": "total_inversion_gestiones_anter",
   "domain": null
  },
  {
   "name": "poblacion_beneficiada",
   "type": "esriFieldTypeDouble",
   "alias": "poblacion_beneficiada",
   "domain": null
  },
  {
   "name": "nro_conexiones_nuevas_agua_ssp",
   "type": "esriFieldTypeDouble",
   "alias": "nro_conexiones_nuevas_agua_ssp",
   "domain": null
  },
  {
   "name": "nro_conexiones_nuevas_ubs_ssp",
   "type": "esriFieldTypeDouble",
   "alias": "nro_conexiones_nuevas_ubs_ssp",
   "domain": null
  },
  {
   "name": "metas_pavimento",
   "type": "esriFieldTypeDouble",
   "alias": "metas_pavimento",
   "domain": null
  },
  {
   "name": "metas_vereda",
   "type": "esriFieldTypeDouble",
   "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": "total_transferencias",
   "type": "esriFieldTypeDouble",
   "alias": "total_transferencias",
   "domain": null
  },
  {
   "name": "total_devengado",
   "type": "esriFieldTypeDouble",
   "alias": "total_devengado",
   "domain": null
  },
  {
   "name": "estado",
   "type": "esriFieldTypeString",
   "alias": "estado",
   "length": 255,
   "domain": null
  },
  {
   "name": "sub_estado",
   "type": "esriFieldTypeString",
   "alias": "sub_estado",
   "length": 255,
   "domain": null
  },
  {
   "name": "problematica",
   "type": "esriFieldTypeDouble",
   "alias": "problematica",
   "domain": null
  },
  {
   "name": "estado_saldo",
   "type": "esriFieldTypeString",
   "alias": "estado_saldo",
   "length": 255,
   "domain": null
  },
  {
   "name": "estado_ppt",
   "type": "esriFieldTypeString",
   "alias": "estado_ppt",
   "length": 255,
   "domain": null
  },
  {
   "name": "anio_estimado_termino_obra",
   "type": "esriFieldTypeString",
   "alias": "anio_estimado_termino_obra",
   "length": 255,
   "domain": null
  },
  {
   "name": "certificacion_anual_2018",
   "type": "esriFieldTypeString",
   "alias": "certificacion_anual_2018",
   "length": 255,
   "domain": null
  },
  {
   "name": "tipo_financiamiento",
   "type": "esriFieldTypeString",
   "alias": "tipo_financiamiento",
   "length": 255,
   "domain": null
  },
  {
   "name": "transferencia_2006",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_2006",
   "domain": null
  },
  {
   "name": "transferencia_2007",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_2007",
   "domain": null
  },
  {
   "name": "transferencia_2008",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_2008",
   "domain": null
  },
  {
   "name": "transferencia_2009",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_2009",
   "domain": null
  },
  {
   "name": "transferencia_2010",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_2010",
   "domain": null
  },
  {
   "name": "transferencia_ene_jul_2011",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_ene_jul_2011",
   "domain": null
  },
  {
   "name": "transferencia_ago_dic_2011",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_ago_dic_2011",
   "domain": null
  },
  {
   "name": "transferencia_2011",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_2011",
   "domain": null
  },
  {
   "name": "transferencia_2012",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_2012",
   "domain": null
  },
  {
   "name": "transferencia_2013",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_2013",
   "domain": null
  },
  {
   "name": "transferencia_2014",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_2014",
   "domain": null
  },
  {
   "name": "transferencia_2015",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_2015",
   "domain": null
  },
  {
   "name": "transferencia_ene_jul_2016",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_ene_jul_2016",
   "domain": null
  },
  {
   "name": "transferencia_ago_dic_2016",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_ago_dic_2016",
   "domain": null
  },
  {
   "name": "transferencia_2016",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_2016",
   "domain": null
  },
  {
   "name": "transferencia_2017",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_2017",
   "domain": null
  },
  {
   "name": "transferencia_20181",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_20181",
   "domain": null
  },
  {
   "name": "transferencia_vizcarra",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_vizcarra",
   "domain": null
  },
  {
   "name": "transferencia_ago_2016_2018",
   "type": "esriFieldTypeDouble",
   "alias": "transferencia_ago_2016_2018",
   "domain": null
  },
  {
   "name": "devengado_2011",
   "type": "esriFieldTypeDouble",
   "alias": "devengado_2011",
   "domain": null
  },
  {
   "name": "devengado_2012",
   "type": "esriFieldTypeDouble",
   "alias": "devengado_2012",
   "domain": null
  },
  {
   "name": "devengado_2013",
   "type": "esriFieldTypeDouble",
   "alias": "devengado_2013",
   "domain": null
  },
  {
   "name": "devengado_2014",
   "type": "esriFieldTypeDouble",
   "alias": "devengado_2014",
   "domain": null
  },
  {
   "name": "devengado_2015",
   "type": "esriFieldTypeDouble",
   "alias": "devengado_2015",
   "domain": null
  },
  {
   "name": "devengado_ene_jul_2016",
   "type": "esriFieldTypeDouble",
   "alias": "devengado_ene_jul_2016",
   "domain": null
  },
  {
   "name": "devengado_ago_dic_2016",
   "type": "esriFieldTypeDouble",
   "alias": "devengado_ago_dic_2016",
   "domain": null
  },
  {
   "name": "devengado_2016",
   "type": "esriFieldTypeDouble",
   "alias": "devengado_2016",
   "domain": null
  },
  {
   "name": "devengado_2017",
   "type": "esriFieldTypeDouble",
   "alias": "devengado_2017",
   "domain": null
  },
  {
   "name": "ene_mar_2018",
   "type": "esriFieldTypeDouble",
   "alias": "ene_mar_2018",
   "domain": null
  },
  {
   "name": "abr_dic_2018",
   "type": "esriFieldTypeDouble",
   "alias": "abr_dic_2018",
   "domain": null
  },
  {
   "name": "devengado_20181",
   "type": "esriFieldTypeDouble",
   "alias": "devengado_20181",
   "domain": null
  },
  {
   "name": "devengado_vizcarra",
   "type": "esriFieldTypeDouble",
   "alias": "devengado_vizcarra",
   "domain": null
  },
  {
   "name": "devengado_ago_2016_2018",
   "type": "esriFieldTypeDouble",
   "alias": "devengado_ago_2016_2018",
   "domain": null
  },
  {
   "name": "inversion_2011",
   "type": "esriFieldTypeDouble",
   "alias": "inversion_2011",
   "domain": null
  },
  {
   "name": "inversion_2012",
   "type": "esriFieldTypeDouble",
   "alias": "inversion_2012",
   "domain": null
  },
  {
   "name": "inversion_2013",
   "type": "esriFieldTypeDouble",
   "alias": "inversion_2013",
   "domain": null
  },
  {
   "name": "inversion_2014",
   "type": "esriFieldTypeDouble",
   "alias": "inversion_2014",
   "domain": null
  },
  {
   "name": "inversion_2015",
   "type": "esriFieldTypeDouble",
   "alias": "inversion_2015",
   "domain": null
  },
  {
   "name": "inversion_ene_jul_2016",
   "type": "esriFieldTypeDouble",
   "alias": "inversion_ene_jul_2016",
   "domain": null
  },
  {
   "name": "inversion_dic_2016",
   "type": "esriFieldTypeDouble",
   "alias": "inversion_dic_2016",
   "domain": null
  },
  {
   "name": "inversion_2016",
   "type": "esriFieldTypeDouble",
   "alias": "inversion_2016",
   "domain": null
  },
  {
   "name": "inversion_2017",
   "type": "esriFieldTypeDouble",
   "alias": "inversion_2017",
   "domain": null
  },
  {
   "name": "inversion_2018",
   "type": "esriFieldTypeDouble",
   "alias": "inversion_2018",
   "domain": null
  },
  {
   "name": "inversion_vizcarra",
   "type": "esriFieldTypeDouble",
   "alias": "inversion_vizcarra",
   "domain": null
  },
  {
   "name": "inversion_ago_2016_2018",
   "type": "esriFieldTypeDouble",
   "alias": "inversion_ago_2016_2018",
   "domain": null
  },
  {
   "name": "pia2018",
   "type": "esriFieldTypeDouble",
   "alias": "pia2018",
   "domain": null
  },
  {
   "name": "certificacion_anual2018",
   "type": "esriFieldTypeDouble",
   "alias": "certificacion_anual2018",
   "domain": null
  },
  {
   "name": "compromiso_anual2018",
   "type": "esriFieldTypeDouble",
   "alias": "compromiso_anual2018",
   "domain": null
  },
  {
   "name": "pim2018",
   "type": "esriFieldTypeDouble",
   "alias": "pim2018",
   "domain": null
  },
  {
   "name": "devengado2018",
   "type": "esriFieldTypeDouble",
   "alias": "devengado2018",
   "domain": null
  },
  {
   "name": "sub_estado2",
   "type": "esriFieldTypeString",
   "alias": "sub_estado2",
   "length": 50,
   "domain": null
  },
  {
   "name": "avance_fisico",
   "type": "esriFieldTypeDouble",
   "alias": "avance_fisico",
   "domain": null
  },
  {
   "name": "flag_transferencia",
   "type": "esriFieldTypeSmallInteger",
   "alias": "flag_transferencia",
   "domain": null
  },
  {
   "name": "flag_vizcarra",
   "type": "esriFieldTypeSmallInteger",
   "alias": "flag_vizcarra",
   "domain": null
  },
  {
   "name": "sflag_vizcarra",
   "type": "esriFieldTypeString",
   "alias": "sflag_vizcarra",
   "length": 20,
   "domain": null
  },
  {
   "name": "estado_seace",
   "type": "esriFieldTypeString",
   "alias": "estado_seace",
   "length": 100,
   "domain": null
  },
  {
   "name": "flag_saneamiento",
   "type": "esriFieldTypeString",
   "alias": "flag_saneamiento",
   "length": 50,
   "domain": null
  },
  {
   "name": "flag_construccion",
   "type": "esriFieldTypeSmallInteger",
   "alias": "FLAG RECONSTRUCCION",
   "domain": null
  },
  {
   "name": "flag_inversion_ago2016_2019",
   "type": "esriFieldTypeSmallInteger",
   "alias": "FLAG INVERSION AGO. 2016 - 2019",
   "domain": null
  },
  {
   "name": "flag_inversion_23marzo2019",
   "type": "esriFieldTypeSmallInteger",
   "alias": "FLAG INVERSION 23 MAR. - 2019",
   "domain": null
  },
  {
   "name": "flag_transferencia2019",
   "type": "esriFieldTypeSmallInteger",
   "alias": "FLAG TRANFERENCIA\n2019",
   "domain": null
  },
  {
   "name": "total_invertido_por_contrata",
   "type": "esriFieldTypeDouble",
   "alias": "TOTAL INVERTIDO S/\nMODALIDAD CONTRATA",
   "domain": null
  },
  {
   "name": "tipo_saldos",
   "type": "esriFieldTypeString",
   "alias": "TIPO_SALDOS",
   "length": 50,
   "domain": null
  },
  {
   "name": "transferencia2019",
   "type": "esriFieldTypeDouble",
   "alias": "TRANSFERENCIA 2019",
   "domain": null
  },
  {
   "name": "pia2019",
   "type": "esriFieldTypeDouble",
   "alias": "PIA 2019",
   "domain": null
  },
  {
   "name": "pim2019",
   "type": "esriFieldTypeDouble",
   "alias": "PIM 2019",
   "domain": null
  },
  {
   "name": "compromiso_anual2019",
   "type": "esriFieldTypeDouble",
   "alias": "COMPROMISO ANUAL 2019",
   "domain": null
  },
  {
   "name": "devengado_2019",
   "type": "esriFieldTypeDouble",
   "alias": "DEVENGADO 2019",
   "domain": null
  },
  {
   "name": "inversion_2006",
   "type": "esriFieldTypeDouble",
   "alias": "INVERSION 2006",
   "domain": null
  },
  {
   "name": "inversion_2007",
   "type": "esriFieldTypeDouble",
   "alias": "INVERSION 2007",
   "domain": null
  },
  {
   "name": "inversion_2008",
   "type": "esriFieldTypeDouble",
   "alias": "INVERSION 2008",
   "domain": null
  },
  {
   "name": "inversion_2009",
   "type": "esriFieldTypeDouble",
   "alias": "INVERSION 2009",
   "domain": null
  },
  {
   "name": "inversion_2010",
   "type": "esriFieldTypeDouble",
   "alias": "INVERSION 2010",
   "domain": null
  },
  {
   "name": "inversion_2019",
   "type": "esriFieldTypeDouble",
   "alias": "INVERSION 2019",
   "domain": null
  },
  {
   "name": "mes_estimado_obra",
   "type": "esriFieldTypeInteger",
   "alias": "mes_estimado_obra",
   "domain": null
  },
  {
   "name": "flag_inversion2018",
   "type": "esriFieldTypeInteger",
   "alias": "flag_inversion2018",
   "domain": null
  },
  {
   "name": "flag_inversion2019",
   "type": "esriFieldTypeInteger",
   "alias": "flag_inversion2019",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "r564_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
 }
}