{ "id": "14", "displayName": "Basin Country Units", "shortDisplayName": null, "description": "", "connectionString": "url=https://services1.arcgis.com/CD5mKowwN6nIaqd8/arcgis/rest/services/Basin_Country_Units_view/FeatureServer/0", "copyright": "", "hasAttributionData": false, "serviceType": "Feature", "serviceFunction": "Operational", "baseMapGroup": null, "baseMapGroupIndex": "", "baseMapGroupIsMutuallyExclusive": false, "opacity": 1, "visible": true, "initiallyVisible": true, "drawingBehavior": "FeatureLayer", "iconUri": null, "includeInLayerList": false, "defaultAllowSymbolization": true, "isExpanded": true, "updateInterval": null, "dataProvider": null, "disableClientCaching": null, "serviceTag": "etZZKyLtl/4BLtG+NmnzwsGLwfFN6CNTVs8ptWqltpc=", "identifiable": null, "includeMosaicDatasetValues": null, "includeCatalogItems": null, "includeInLegend": null, "startTime": null, "endTime": null, "serverVersion": "11.2", "failureAction": "Warn", "failureTimeout": null, "requestEncoding": null, "supportsDynamicLayers": false, "hasLayerCatalog": false, "autoSave": null, "color": null, "geometry": null, "objectIds": null, "onDemandCacheSize": null, "outFields": "*", "queryMode": "OnDemand", "tileHeight": null, "tileWidth": null, "selectionColor": null, "where": null, "editVerticesEnabled": true, "moveEnabled": true, "rotateEnabled": true, "scaleEnabled": true, "themeSettings": [], "layerHyperlinks": [], "tileInfo": {}, "instantSearch": false, "layers": [ { "id": "0", "name": "Basin Country Units", "nativeID": "0", "displayName": "Basin Country Units", "description": "", "defaultVisibility": true, "featureType": "Polygon", "type": "DynamicFeatureLayer", "maxScale": 0, "minScale": 0, "visible": true, "initiallyVisible": true, "showMapTips": true, "identifiable": true, "queryable": true, "searchable": false, "supportsIdentify": true, "supportsQuery": true, "canCopyFeature": true, "snappable": true, "snappingEnabled": true, "hasAttachments": false, "featureZoomFactor": null, "featureZoomScale": null, "featureBorderColor": null, "featureBorderWidth": null, "featureFillColor": null, "showFeatureHyperlinks": "ShowAll", "iconUri": null, "includeInLayerList": true, "includeInLegend": true, "allowSymbolization": true, "legendUrl": null, "styleName": null, "drawIndex": null, "canToggleLabels": false, "showLabels": true, "dataProvider": null, "featureLabel": "{adm0_name} :: {Basin_Name}", "featureDescription": "
Basin: {Basin_Name}
Country: {adm0_name}
Treaties: {treatyCount} ::Treaty Details
Events: {eventCount} ::Events Details
River Basin Organizations (RBOs): {rboCount} ::RBO Details

Get Basin Country Report
", "featureLongDescription": null, "displayField": "adm0_name", "primaryKeyField": "OBJECTID", "parentLayerId": null, "subLayerIds": [], "hasReports": false, "hasDataLinks": false, "fields": [ { "displayName": "OBJECTID", "name": "OBJECTID", "alias": "OBJECTID", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "adm0_name", "name": "adm0_name", "alias": "adm0_name", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "FIRST_stat", "name": "FIRST_stat", "alias": "FIRST_stat", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "CCODE", "name": "CCODE", "alias": "CCODE", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "Alt_CCODE", "name": "Alt_CCODE", "alias": "Alt_CCODE", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "BCODE", "name": "BCODE", "alias": "BCODE", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "BCCODE", "name": "BCCODE", "alias": "BCCODE", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "Basin_Name", "name": "Basin_Name", "alias": "Basin_Name", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "Continent_", "name": "Continent_", "alias": "Continent_", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "Area_km2", "name": "Area_km2", "alias": "Area_km2", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "Pop_2007", "name": "Pop_2007", "alias": "Pop_2007", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "PopDen2007", "name": "PopDen2007", "alias": "PopDen2007", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "Pop_2012_P", "name": "Pop_2012_P", "alias": "Pop_2012_P", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "PopDen12_P", "name": "PopDen12_P", "alias": "PopDen12_P", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "Pop_2015", "name": "Pop_2015", "alias": "Pop_2015", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "PopDen2015", "name": "PopDen2015", "alias": "PopDen2015", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "Pop_2020", "name": "Pop_2020", "alias": "Pop_2020", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "PopDen2020", "name": "PopDen2020", "alias": "PopDen2020", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "Dams_Exist", "name": "Dams_Exist", "alias": "Dams_Exist", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "Dam_Plnd", "name": "Dam_Plnd", "alias": "Dam_Plnd", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "runoff", "name": "runoff", "alias": "runoff", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "withdrawal", "name": "withdrawal", "alias": "withdrawal", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "Consumption", "name": "consumpt", "alias": "Consumption", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "HydroPolTe", "name": "HydroPolTe", "alias": "HydroPolTe", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "InstitVuln", "name": "InstitVuln", "alias": "InstitVuln", "visible": true, "dataType": "String", "searchable": true }, { "displayName": "NumberRipa", "name": "NumberRipa", "alias": "NumberRipa", "visible": true, "dataType": "Int32", "searchable": true }, { "displayName": "Dams_Plnd2", "name": "Dams_Plnd2", "alias": "Dams_Plnd2", "visible": true, "dataType": "Double", "searchable": true }, { "displayName": "Shape__Area", "name": "Shape__Area", "alias": "Shape__Area", "visible": true, "dataType": "Double", "searchable": true }, { "displayName": "Shape__Length", "name": "Shape__Length", "alias": "Shape__Length", "visible": true, "dataType": "Double", "searchable": true }, { "displayName": "GlobalID", "name": "GlobalID", "alias": "GlobalID", "visible": true, "dataType": "Guid", "searchable": true }, { "displayName": "Consumption (Cubic Km/yr)", "name": "consumption_number", "alias": "Consumption (Cubic Km/yr)", "visible": true, "dataType": "Double", "searchable": true }, { "displayName": "Runoff (mm/yr)", "name": "runoff_number", "alias": "Runoff (mm/yr)", "visible": true, "dataType": "Double", "searchable": true }, { "displayName": "Withdrawal (Cubic Km/yr)", "name": "withdrawal_number", "alias": "Withdrawal (Cubic Km/yr)", "visible": true, "dataType": "Double", "searchable": true } ], "featureHyperlinks": [], "layerHyperlinks": [], "arcadeExpressions": [ { "expression": "var basin = $feature.BCODE;\r\nvar country = $feature.CCODE;\r\n//var altCountry = $feature.Alt_CCODE;\r\n//country = DefaultValue(altCountry, country);\r\nvar basin_country_code = basin + '_' + country;\r\nvar Table = FeatureSetByName($map,\"Events\",['DATE','LOCATION','EVENT_SUMMARY','Macro_Event','NUMBER_OF_Countries','Source_Source']);\r\n//var BasinCountryEvents = Filter(Table, '(CCODE1 = @country OR CCODE2 = @country) AND BCode = @basin');\r\nvar BasinCountryEvents = Filter(Table, '(BCCODE1 = @basin_country_code OR BCCODE2 = @basin_country_code) AND BCode = @basin');\r\n\r\n//check for results\r\nif(Count(BasinCountryEvents) > 0){\r\n\r\nvar returnString = '<' + 'table' + '>';\r\nreturnString += '<' + 'tr' + '>';\r\nreturnString += '<' + 'td' + '>';\r\nreturnString += 'Date';\r\nreturnString += '<' + '/' + 'td' + '>';\r\nreturnString += '<' + 'td' + '>';\r\nreturnString += 'LOCATION';\r\nreturnString += '<' + '/' + 'td' + '>';\r\nreturnString += '<' + 'td' + '>';\r\nreturnString += 'Macro_Event';\r\nreturnString += '<' + '/' + 'td' + '>';\r\nreturnString += '<' + 'td' + '>';\r\nreturnString += 'NUMBER_OF_Countries';\r\nreturnString += '<' + '/' + 'td' + '>';\r\nreturnString += '<' + 'td' + '>';\r\nreturnString += 'EVENT_SUMMARY';\r\nreturnString += '<' + '/' + 'td' + '>';\r\nreturnString += '<' + 'td' + '>';\r\nreturnString += 'Source';\r\nreturnString += '<' + '/' + 'td' + '>';\r\nreturnString += '<' + '/' + 'tr' + '>';\r\nvar uniqueEventsbyDate = [];\r\n\r\nfor (var event in BasinCountryEvents){\r\n if (IndexOf(uniqueEventsbyDate,event.DATE) == -1){ \r\n Push(uniqueEventsbyDate,event.DATE);\r\n\treturnString += '<' + 'tr' + '>';\r\n\treturnString += '<' + 'td' + '>';\r\n\treturnString += Text(event.DATE,'YYYY, MMM');\r\n\treturnString += '<' + '/' + 'td' + '>';\r\n\treturnString += '<' + 'td' + '>';\r\n\treturnString += event.LOCATION;\r\n\treturnString += '<' + '/' + 'td' + '>';\r\n\treturnString += '<' + 'td' + '>';\r\n\treturnString += event.Macro_Event;\r\n\treturnString += '<' + '/' + 'td' + '>';\r\n\treturnString += '<' + 'td' + '>';\r\n\treturnString += event.NUMBER_OF_Countries;\r\n\treturnString += '<' + '/' + 'td' + '>';\r\n\treturnString += '<' + 'td' + '>';\r\n\treturnString += event.EVENT_SUMMARY;\r\n\treturnString += '<' + '/' + 'td' + '>';\r\n\treturnString += '<' + 'td' + '>';\r\n\treturnString += event.Source_Source;\r\n\treturnString += '<' + '/' + 'td' + '>';\r\n\treturnString += '<' + '/' + 'tr' + '>'; \r\n } \r\n}\r\nreturnString += '<' + '/' + 'table' + '>';\r\nreturn returnString;\r\n} else {\r\nreturn 'No events found four this basin and country combination.';\r\n}\r\n", "token": "Test" }, { "expression": "var basin = $feature.BCODE;\r\nvar country = $feature.CCODE;\r\n//var altCountry = $feature.Alt_CCODE;\r\n//country = DefaultValue(altCountry, country);\r\nvar basin_country_code = basin + '_' + country;\r\nvar Table = FeatureSetByName($map,\"Events\",['DATE','LOCATION','EVENT_SUMMARY','Macro_Event','NUMBER_OF_Countries','Source_Source']);\r\n//var BasinCountryEvents = Filter(Table, '(CCODE1 = @country OR CCODE2 = @country) AND BCode = @basin');\r\nvar BasinCountryEvents = Filter(Table, '(BCCODE1 = @basin_country_code OR BCCODE2 = @basin_country_code)');\r\n\r\nreturn Count(BasinCountryEvents);\r\nvar uniqueEventsbyDate = [];\r\n//check for results\r\nif(Count(BasinCountryEvents) > 0){\r\n\r\n\r\nfor (var event in BasinCountryEvents){\r\n if (IndexOf(uniqueEventsbyDate,event.DATE) == -1){ \r\n Push(uniqueEventsbyDate,event.DATE);\t \r\n } \r\n}\r\n}\r\nreturn Count(uniqueEventsbyDate)\r\n", "token": "eventCount" }, { "expression": "var basin = $feature.BCODE;\r\nvar country = $feature.CCODE;\r\n//var altCountry = $feature.Alt_CCODE;\r\n//country = DefaultValue(altCountry, country);\r\nvar basin_country_code = basin + '_' + country;\r\nvar Table = FeatureSetByName($map,\"Treaties\",['DocumentName']);\r\n\r\nvar BasinCountryTreaties = Filter(Table, 'BCCODE = @basin_country_code');\r\n\r\nvar uniqueTreatiesbyDate = [];\r\n//check for results\r\nif(Count(BasinCountryTreaties) > 0){\r\n\r\nfor (var treaty in BasinCountryTreaties){\r\n if (IndexOf(uniqueTreatiesbyDate,treaty.DocumentName) == -1){ \r\n Push(uniqueTreatiesbyDate,treaty.DocumentName);\t \r\n } \r\n}\r\n}\r\nreturn Count(uniqueTreatiesbyDate)\r\n", "token": "treatyCount" }, { "expression": "var basin = $feature.BCODE;\r\nvar country = $feature.CCODE;\r\n\r\nvar basin_country_code = basin + '_' + country;\r\nvar Table = FeatureSetByName($map,\"RBOs\",['RBO_NAME']);\r\n\r\nvar BasinCountryRBO = Filter(Table, 'BCCODE = @basin_country_code');\r\n\r\nvar uniqueRBO = [];\r\n//check for results\r\nif(Count(BasinCountryRBO ) > 0){\r\n\r\nfor (var rbo in BasinCountryRBO ){\r\n if (IndexOf(uniqueRBO,rbo.RBO_NAME) == -1){ \r\n Push(uniqueRBO ,rbo.RBO_NAME);\t \r\n } \r\n}\r\n}\r\nreturn Count(uniqueRBO)\r\n", "token": "rboCount" } ], "isDynamic": false, "dynamicDefinition": null, "themeSettings": [], "tileLevelLimits": [] } ], "tables": [], "fullExtent": { "xmin": -18500483.7018, "ymin": -5189243.144, "xmax": 16144572.983499996, "ymax": 6037178.9575, "spatialReference": { "wkid": 54034 } }, "spatialReference": { "wkid": 54034 }, "properties": [], "extensions": [] }