{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 76,
 "name": "Ranking Matrix of Project Evaluation, Ranking and Prioritization System",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "PRJ_NAME",
 "typeIdField": "RANKING_MAIN_CAT",
 "subtypeFieldName": "RANKING_MAIN_CAT",
 "subtypeField": "RANKING_MAIN_CAT",
 "defaultSubtypeCode": 1,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "RANKING_MAIN_CAT",
   "type": "esriFieldTypeInteger",
   "alias": "RANKING MAIN CATEGORY",
   "domain": null
  },
  {
   "name": "RANKING_SUB_CAT",
   "type": "esriFieldTypeInteger",
   "alias": "RANKING SUB CAT",
   "domain": null
  },
  {
   "name": "RATING_VALUE",
   "type": "esriFieldTypeInteger",
   "alias": "RATING VALUE",
   "domain": {
    "type": "codedValue",
    "name": "ProjectsRatingDom",
    "description": "Projects Rating",
    "codedValues": [
     {
      "name": "Significant Adverse Effects (High)",
      "code": -2
     },
     {
      "name": "Negative Impact Adverse Effects (Low)",
      "code": -1
     },
     {
      "name": "No Impact (No Relevance)",
      "code": 0
     },
     {
      "name": "Positive Impact (Low Relevance)",
      "code": 1
     },
     {
      "name": "Moderate Relevance",
      "code": 2
     },
     {
      "name": "High Relevance",
      "code": 3
     },
     {
      "name": "Very High Relevance",
      "code": 4
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "WEIGHTING_FACTOR",
   "type": "esriFieldTypeInteger",
   "alias": "WEIGHTING FACTOR",
   "domain": {
    "type": "range",
    "name": "CIPPrjWeightingFactorDom",
    "description": "CIP Project Weighting Factors",
    "range": [
     0,
     10
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "JUSTIFICATION",
   "type": "esriFieldTypeString",
   "alias": "JUSTIFICATION",
   "length": 500,
   "domain": null
  },
  {
   "name": "TOTAL_NO_OF_POINTS",
   "type": "esriFieldTypeDouble",
   "alias": "TOTAL NO OF POINTS",
   "domain": null
  },
  {
   "name": "ESTIMATED_FOR_YEAR",
   "type": "esriFieldTypeString",
   "alias": "ESTIMATED FOR YEAR",
   "length": 6,
   "domain": null
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "COMMENTS",
   "length": 500,
   "domain": null
  },
  {
   "name": "CREATEWHO",
   "type": "esriFieldTypeString",
   "alias": "CREATEWHO",
   "length": 255,
   "domain": null
  },
  {
   "name": "CREATEWHEN",
   "type": "esriFieldTypeDate",
   "alias": "CREATEWHEN",
   "length": 8,
   "domain": null
  },
  {
   "name": "UPDATEWHO",
   "type": "esriFieldTypeString",
   "alias": "UPDATEWHO",
   "length": 255,
   "domain": null
  },
  {
   "name": "UPDATEWHEN",
   "type": "esriFieldTypeDate",
   "alias": "UPDATEWHEN",
   "length": 8,
   "domain": null
  },
  {
   "name": "MAIN_CAT_OVERALL_SCORE",
   "type": "esriFieldTypeDouble",
   "alias": "MAIN CATEGORY OVERALL SCORE",
   "domain": null
  },
  {
   "name": "OVERALL_SCORE",
   "type": "esriFieldTypeDouble",
   "alias": "OVERALL SCORE",
   "domain": null
  },
  {
   "name": "OVERALL_PROJECT_RELEVANCE",
   "type": "esriFieldTypeInteger",
   "alias": "OVERALL PROJECT RELEVANCE",
   "domain": {
    "type": "codedValue",
    "name": "ProjectsRatingDom",
    "description": "Projects Rating",
    "codedValues": [
     {
      "name": "Significant Adverse Effects (High)",
      "code": -2
     },
     {
      "name": "Negative Impact Adverse Effects (Low)",
      "code": -1
     },
     {
      "name": "No Impact (No Relevance)",
      "code": 0
     },
     {
      "name": "Positive Impact (Low Relevance)",
      "code": 1
     },
     {
      "name": "Moderate Relevance",
      "code": 2
     },
     {
      "name": "High Relevance",
      "code": 3
     },
     {
      "name": "Very High Relevance",
      "code": 4
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PRJ_NAME",
   "type": "esriFieldTypeString",
   "alias": "PRJ NAME",
   "length": 500,
   "domain": null
  },
  {
   "name": "PRJ_ID",
   "type": "esriFieldTypeInteger",
   "alias": "PRJ ID",
   "domain": null
  },
  {
   "name": "PRJ_CARD",
   "type": "esriFieldTypeString",
   "alias": "PRJ CARD",
   "length": 50,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R728_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "types": [
  {
   "domains": {
    "RANKING_SUB_CAT": {
     "type": "codedValue",
     "name": "CIPRankingGovSCDom",
     "description": "CIP Ranking Governance Sub Categories",
     "codedValues": [
      {
       "name": "Improved understanding of national groundwater system",
       "code": 1
      },
      {
       "name": "Improved understanding of local groundwater system",
       "code": 2
      },
      {
       "name": "Improved monitoring of water resources",
       "code": 3
      },
      {
       "name": "Improved database",
       "code": 4
      },
      {
       "name": "Improved Well Licensing",
       "code": 5
      },
      {
       "name": "Improved Planning",
       "code": 6
      },
      {
       "name": "Improved Allocation",
       "code": 7
      },
      {
       "name": "Improved GW Protection",
       "code": 8
      },
      {
       "name": "Improved Human Capacity",
       "code": 9
      },
      {
       "name": "Improved Awarness",
       "code": 10
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "id": 1,
   "name": "Governance"
  },
  {
   "domains": {
    "RANKING_SUB_CAT": {
     "type": "codedValue",
     "name": "CIPRankingWaterSupplySCDom",
     "description": "CIP Ranking Water Supply Sub Categories",
     "codedValues": [
      {
       "name": "Improved Water Security (Supply as Percentage of peak load)",
       "code": 1
      },
      {
       "name": "Improved Reliability of Water Supply (Frequency)",
       "code": 2
      },
      {
       "name": "Contingency Planning",
       "code": 3
      },
      {
       "name": "Improved  Water Supply Service",
       "code": 4
      },
      {
       "name": "Improved Water Quality (As percentage of average TDS Deviation;-50%-+200%)",
       "code": 5
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "id": 2,
   "name": "Water Supply"
  },
  {
   "domains": {
    "RANKING_SUB_CAT": {
     "type": "codedValue",
     "name": "CIPRankingSanitationSCDom",
     "description": "CIP Ranking Sanitation Sub Categories",
     "codedValues": [
      {
       "name": "Reduced health risk(Water Related cases)",
       "code": 1
      },
      {
       "name": "Improved protection of exploited water resources (surface and groundwater)",
       "code": 2
      },
      {
       "name": "Improved sanitation service",
       "code": 3
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "id": 3,
   "name": "Sanitation"
  },
  {
   "domains": {
    "RANKING_SUB_CAT": {
     "type": "codedValue",
     "name": "CIPRankingIrrigationSCDom",
     "description": "CIP Ranking Irrigation and Reuse Sub Categories",
     "codedValues": [
      {
       "name": "Improved use of treated wastewater",
       "code": 1
      },
      {
       "name": "Improved Irrigation Effeciency",
       "code": 2
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "id": 4,
   "name": "Irrigation and Reuse"
  },
  {
   "domains": {
    "RANKING_SUB_CAT": {
     "type": "codedValue",
     "name": "CIPRankingCrossSCDom",
     "description": "CIP Ranking Irrigation and Cross-cutting  Sub Categories",
     "codedValues": [
      {
       "name": "reduced social vulnerability",
       "code": 1
      },
      {
       "name": "reduced operational cost (cost per m3)",
       "code": 2
      },
      {
       "name": "improved revenue",
       "code": 3
      },
      {
       "name": "affordability (cost per customer)",
       "code": 4
      },
      {
       "name": "affordability (cost per m³)",
       "code": 5
      },
      {
       "name": "reduced energy consumption (kW/m3)",
       "code": 6
      },
      {
       "name": "Improved energy efficiency (-20% - +40%)",
       "code": 7
      },
      {
       "name": "environmental impacts on water resources",
       "code": 8
      },
      {
       "name": "environmental impacts (noise, air, pollution, odor)",
       "code": 9
      },
      {
       "name": "standard project description available",
       "code": 10
      },
      {
       "name": "recent feasibility study of good quality available",
       "code": 11
      },
      {
       "name": "EIA available and accepted",
       "code": 12
      },
      {
       "name": "recent detailed design study of good quality available",
       "code": 13
      },
      {
       "name": "funding committed",
       "code": 14
      },
      {
       "name": "adverse effects if project is not implemented",
       "code": 15
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "id": 5,
   "name": "Cross-Cutting"
  }
 ],
 "subtypes": [
  {
   "domains": {
    "RANKING_SUB_CAT": {
     "type": "codedValue",
     "name": "CIPRankingGovSCDom",
     "description": "CIP Ranking Governance Sub Categories",
     "codedValues": [
      {
       "name": "Improved understanding of national groundwater system",
       "code": 1
      },
      {
       "name": "Improved understanding of local groundwater system",
       "code": 2
      },
      {
       "name": "Improved monitoring of water resources",
       "code": 3
      },
      {
       "name": "Improved database",
       "code": 4
      },
      {
       "name": "Improved Well Licensing",
       "code": 5
      },
      {
       "name": "Improved Planning",
       "code": 6
      },
      {
       "name": "Improved Allocation",
       "code": 7
      },
      {
       "name": "Improved GW Protection",
       "code": 8
      },
      {
       "name": "Improved Human Capacity",
       "code": 9
      },
      {
       "name": "Improved Awarness",
       "code": 10
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "defaultValues": {
    "RANKING_MAIN_CAT": null,
    "RANKING_SUB_CAT": null,
    "RATING_VALUE": null,
    "WEIGHTING_FACTOR": null,
    "JUSTIFICATION": null,
    "TOTAL_NO_OF_POINTS": null,
    "ESTIMATED_FOR_YEAR": null,
    "COMMENTS": null,
    "CREATEWHO": null,
    "CREATEWHEN": null,
    "UPDATEWHO": null,
    "UPDATEWHEN": null,
    "MAIN_CAT_OVERALL_SCORE": null,
    "OVERALL_SCORE": null,
    "OVERALL_PROJECT_RELEVANCE": null,
    "PRJ_NAME": null,
    "PRJ_ID": null,
    "PRJ_CARD": null
   },
   "code": 1,
   "name": "Governance"
  },
  {
   "domains": {
    "RANKING_SUB_CAT": {
     "type": "codedValue",
     "name": "CIPRankingWaterSupplySCDom",
     "description": "CIP Ranking Water Supply Sub Categories",
     "codedValues": [
      {
       "name": "Improved Water Security (Supply as Percentage of peak load)",
       "code": 1
      },
      {
       "name": "Improved Reliability of Water Supply (Frequency)",
       "code": 2
      },
      {
       "name": "Contingency Planning",
       "code": 3
      },
      {
       "name": "Improved  Water Supply Service",
       "code": 4
      },
      {
       "name": "Improved Water Quality (As percentage of average TDS Deviation;-50%-+200%)",
       "code": 5
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "defaultValues": {
    "RANKING_MAIN_CAT": null,
    "RANKING_SUB_CAT": null,
    "RATING_VALUE": null,
    "WEIGHTING_FACTOR": null,
    "JUSTIFICATION": null,
    "TOTAL_NO_OF_POINTS": null,
    "ESTIMATED_FOR_YEAR": null,
    "COMMENTS": null,
    "CREATEWHO": null,
    "CREATEWHEN": null,
    "UPDATEWHO": null,
    "UPDATEWHEN": null,
    "MAIN_CAT_OVERALL_SCORE": null,
    "OVERALL_SCORE": null,
    "OVERALL_PROJECT_RELEVANCE": null,
    "PRJ_NAME": null,
    "PRJ_ID": null,
    "PRJ_CARD": null
   },
   "code": 2,
   "name": "Water Supply"
  },
  {
   "domains": {
    "RANKING_SUB_CAT": {
     "type": "codedValue",
     "name": "CIPRankingSanitationSCDom",
     "description": "CIP Ranking Sanitation Sub Categories",
     "codedValues": [
      {
       "name": "Reduced health risk(Water Related cases)",
       "code": 1
      },
      {
       "name": "Improved protection of exploited water resources (surface and groundwater)",
       "code": 2
      },
      {
       "name": "Improved sanitation service",
       "code": 3
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "defaultValues": {
    "RANKING_MAIN_CAT": null,
    "RANKING_SUB_CAT": null,
    "RATING_VALUE": null,
    "WEIGHTING_FACTOR": null,
    "JUSTIFICATION": null,
    "TOTAL_NO_OF_POINTS": null,
    "ESTIMATED_FOR_YEAR": null,
    "COMMENTS": null,
    "CREATEWHO": null,
    "CREATEWHEN": null,
    "UPDATEWHO": null,
    "UPDATEWHEN": null,
    "MAIN_CAT_OVERALL_SCORE": null,
    "OVERALL_SCORE": null,
    "OVERALL_PROJECT_RELEVANCE": null,
    "PRJ_NAME": null,
    "PRJ_ID": null,
    "PRJ_CARD": null
   },
   "code": 3,
   "name": "Sanitation"
  },
  {
   "domains": {
    "RANKING_SUB_CAT": {
     "type": "codedValue",
     "name": "CIPRankingIrrigationSCDom",
     "description": "CIP Ranking Irrigation and Reuse Sub Categories",
     "codedValues": [
      {
       "name": "Improved use of treated wastewater",
       "code": 1
      },
      {
       "name": "Improved Irrigation Effeciency",
       "code": 2
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "defaultValues": {
    "RANKING_MAIN_CAT": null,
    "RANKING_SUB_CAT": null,
    "RATING_VALUE": null,
    "WEIGHTING_FACTOR": null,
    "JUSTIFICATION": null,
    "TOTAL_NO_OF_POINTS": null,
    "ESTIMATED_FOR_YEAR": null,
    "COMMENTS": null,
    "CREATEWHO": null,
    "CREATEWHEN": null,
    "UPDATEWHO": null,
    "UPDATEWHEN": null,
    "MAIN_CAT_OVERALL_SCORE": null,
    "OVERALL_SCORE": null,
    "OVERALL_PROJECT_RELEVANCE": null,
    "PRJ_NAME": null,
    "PRJ_ID": null,
    "PRJ_CARD": null
   },
   "code": 4,
   "name": "Irrigation and Reuse"
  },
  {
   "domains": {
    "RANKING_SUB_CAT": {
     "type": "codedValue",
     "name": "CIPRankingCrossSCDom",
     "description": "CIP Ranking Irrigation and Cross-cutting  Sub Categories",
     "codedValues": [
      {
       "name": "reduced social vulnerability",
       "code": 1
      },
      {
       "name": "reduced operational cost (cost per m3)",
       "code": 2
      },
      {
       "name": "improved revenue",
       "code": 3
      },
      {
       "name": "affordability (cost per customer)",
       "code": 4
      },
      {
       "name": "affordability (cost per m³)",
       "code": 5
      },
      {
       "name": "reduced energy consumption (kW/m3)",
       "code": 6
      },
      {
       "name": "Improved energy efficiency (-20% - +40%)",
       "code": 7
      },
      {
       "name": "environmental impacts on water resources",
       "code": 8
      },
      {
       "name": "environmental impacts (noise, air, pollution, odor)",
       "code": 9
      },
      {
       "name": "standard project description available",
       "code": 10
      },
      {
       "name": "recent feasibility study of good quality available",
       "code": 11
      },
      {
       "name": "EIA available and accepted",
       "code": 12
      },
      {
       "name": "recent detailed design study of good quality available",
       "code": 13
      },
      {
       "name": "funding committed",
       "code": 14
      },
      {
       "name": "adverse effects if project is not implemented",
       "code": 15
      }
     ],
     "mergePolicy": "esriMPTDefaultValue",
     "splitPolicy": "esriSPTDefaultValue"
    }
   },
   "defaultValues": {
    "RANKING_MAIN_CAT": null,
    "RANKING_SUB_CAT": null,
    "RATING_VALUE": null,
    "WEIGHTING_FACTOR": null,
    "JUSTIFICATION": null,
    "TOTAL_NO_OF_POINTS": null,
    "ESTIMATED_FOR_YEAR": null,
    "COMMENTS": null,
    "CREATEWHO": null,
    "CREATEWHEN": null,
    "UPDATEWHO": null,
    "UPDATEWHEN": null,
    "MAIN_CAT_OVERALL_SCORE": null,
    "OVERALL_SCORE": null,
    "OVERALL_PROJECT_RELEVANCE": null,
    "PRJ_NAME": null,
    "PRJ_ID": null,
    "PRJ_CARD": null
   },
   "code": 5,
   "name": "Cross-Cutting"
  }
 ],
 "relationships": [],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": false
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "7b883bbdc8b24f88938b612a50bd5e21"
}