{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 76, "name": "Ranking Matrix of Project Evaluation, Ranking and Prioritization System", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "PRJ_NAME", "typeIdField": "RANKING_MAIN_CAT", "subtypeField": "RANKING_MAIN_CAT", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "RANKING_MAIN_CAT", "type": "esriFieldTypeInteger", "alias": "RANKING MAIN CATEGORY", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "RANKING_MAIN_CAT" }, { "name": "RANKING_SUB_CAT", "type": "esriFieldTypeInteger", "alias": "RANKING SUB CAT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RANKING_SUB_CAT" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RATING_VALUE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WEIGHTING_FACTOR" }, { "name": "JUSTIFICATION", "type": "esriFieldTypeString", "alias": "JUSTIFICATION", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "JUSTIFICATION" }, { "name": "TOTAL_NO_OF_POINTS", "type": "esriFieldTypeDouble", "alias": "TOTAL NO OF POINTS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_NO_OF_POINTS" }, { "name": "ESTIMATED_FOR_YEAR", "type": "esriFieldTypeString", "alias": "ESTIMATED FOR YEAR", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "ESTIMATED_FOR_YEAR" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "CREATEWHO", "type": "esriFieldTypeString", "alias": "CREATEWHO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CREATEWHO" }, { "name": "CREATEWHEN", "type": "esriFieldTypeDate", "alias": "CREATEWHEN", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATEWHEN" }, { "name": "UPDATEWHO", "type": "esriFieldTypeString", "alias": "UPDATEWHO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UPDATEWHO" }, { "name": "UPDATEWHEN", "type": "esriFieldTypeDate", "alias": "UPDATEWHEN", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UPDATEWHEN" }, { "name": "MAIN_CAT_OVERALL_SCORE", "type": "esriFieldTypeDouble", "alias": "MAIN CATEGORY OVERALL SCORE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAIN_CAT_OVERALL_SCORE" }, { "name": "OVERALL_SCORE", "type": "esriFieldTypeDouble", "alias": "OVERALL SCORE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERALL_SCORE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OVERALL_PROJECT_RELEVANCE" }, { "name": "PRJ_NAME", "type": "esriFieldTypeString", "alias": "PRJ NAME", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "PRJ_NAME" }, { "name": "PRJ_ID", "type": "esriFieldTypeInteger", "alias": "PRJ ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PRJ_ID" }, { "name": "PRJ_CARD", "type": "esriFieldTypeString", "alias": "PRJ CARD", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PRJ_CARD" } ], "indexes": [ { "name": "R728_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": 1, "name": "Governance", "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" } }, "templates": [ { "name": "Governance", "description": "", "prototype": { "attributes": {"RANKING_MAIN_CAT": 1} }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 2, "name": "Water Supply", "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" } }, "templates": [ { "name": "Water Supply", "description": "", "prototype": { "attributes": {"RANKING_MAIN_CAT": 2} }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 3, "name": "Sanitation", "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" } }, "templates": [ { "name": "Sanitation", "description": "", "prototype": { "attributes": {"RANKING_MAIN_CAT": 3} }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 4, "name": "Irrigation and Reuse", "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" } }, "templates": [ { "name": "Irrigation and Reuse", "description": "", "prototype": { "attributes": {"RANKING_MAIN_CAT": 4} }, "drawingTool": "esriFeatureEditToolNone" } ] }, { "id": 5, "name": "Cross-Cutting", "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" } }, "templates": [ { "name": "Cross-Cutting", "description": "", "prototype": { "attributes": {"RANKING_MAIN_CAT": 5} }, "drawingTool": "esriFeatureEditToolNone" } ] } ], "templates": [], "subtypes": [ { "code": 1, "name": "Governance", "defaultValues": { "RANKING_MAIN_CAT": 1, "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 }, "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" } } }, { "code": 2, "name": "Water Supply", "defaultValues": { "RANKING_MAIN_CAT": 2, "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 }, "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" } } }, { "code": 3, "name": "Sanitation", "defaultValues": { "RANKING_MAIN_CAT": 3, "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 }, "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" } } }, { "code": 4, "name": "Irrigation and Reuse", "defaultValues": { "RANKING_MAIN_CAT": 4, "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 }, "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" } } }, { "code": 5, "name": "Cross-Cutting", "defaultValues": { "RANKING_MAIN_CAT": 5, "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 }, "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" } } } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "36fea20cf74943dc8592ecd8194a887b" }