Latest Contributions by JaredPilbeam2

Why is this Table not a table?  At first I had 'Table' in the type parameter and got [ ]. Then I found out the Table is actually a 'Feature Layer Collection'. So, that's great. Or so I thought. But, then I get an error telling me the table is not a table? with arcpy.da.SearchCursor(table, fields) as cursor: for row in cursor: description_dict[row[1]] = row[0]‍‍‍‍‍‍‍‍‍‍‍‍ --------------------------------------------------------------------------- RuntimeError Traceback (most recent call last) <ipython-input-21-bdc66f453653> in <module> 13 description_dict = {} 14 ---> 15 with arcpy.da.SearchCursor(table, fields) as cursor: 16 for row in cursor: 17 description_dict[row[1]] = row[0] RuntimeError: 'in_table' is not a table or a featureclass ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I then tried the Green Descriptions CSV but got the same error. with arcpy.da.SearchCursor(csv, fields) as cursor: for row in cursor: description_dict[row[1]] = row[0]‍‍‍ --------------------------------------------------------------------------- RuntimeError Traceback (most recent call last) <ipython-input-22-b36d2a96d554> in <module> 13 description_dict = {} 14 ---> 15 with arcpy.da.SearchCursor(csv, fields) as cursor: 16 for row in cursor: 17 description_dict[row[1]] = row[0] RuntimeError: 'in_table' is not a table or a featureclass‍‍‍‍‍‍‍‍‍‍ I've came across a similar thread posted earlier this year that was never answered Convert from Feature Collection to Feature Class  ... View more

I'm trying to populate the 'Description' field in the Recycling Locations View layer (a hosted Feature Layer) with the text from the 'Description' field in the Green Descriptions layer (a hosted Table). The 'Category' field from both have the same values. The script I have uses the UpdateCursor to populate a field based on another field from the same Feature Layer. I think I can create a list with the text from the 'Description' field, but that seems redundant seeing as though there is probably a way to bring it in straight from the hosted table? import arcpy, requests, json #disable warnings requests.packages.urllib3.disable_warnings() #Recycling Locations Feature layer fc = survey_item #text to populate the Description field of the Recycling Locations layer descriptions = ['Refrigerators, stoves, dishwashers, water heaters and other large appliances are considered white goods and are banned from landfills. Hazardous components such as mercury, CFCs and PCBs are dangerous and require proper handling and disposal. When purchasing an appliance, request the company to take your “old” appliance or contact your city/village. A list of certified Freon removal specialists is not currently available. The U.S. EPA administers a program to certify technicans. Their requirements can be found at http://www.epa.gov/Ozone/title6/608/608fact.html#techcert', 'ASBESTOS - Asbestos is a naturally occurring mineral found in certain rocks. Asbestos was commonly used in home building materials before the mid-1970s and occasionally until the late 1980s because it is strong, fire- and corrosion-resistant and a good insulator. If asbestos is in good condition and left in place, it should not present health risks. However, if a building is going to be demolished, renovated, or remodeled, care should be taken to prevent the release of asbestos fibers into the air. Inhalation of microscopic asbestos fibers can cause health risks. You may search for Licensed Asbestos Professionals in the Yellow Pages or call the Illinois Dept. of Public Health.', 'In most cases older vehicles are traded-in or brought to an auto salvage yard; or you may choose to donate them for parts reuse and recycling. Contact the following organizations to make arrangements, get paid or ask about tax deduction information.', ... etc. ] #fields from the Recycling Locations layer fields = ['Description', 'Category'] #use the updatecursor to populate the Description field from the descriptions list with arcpy.da.UpdateCursor(fc, fields) as cursor: for row in cursor: if row[1] == 'Appliance Recycling': row[0] = descriptions[0] elif row[1] == 'Asbestos Info / Removal Service': row[0] = descriptions[1] elif row[1] == 'Automobile & Boat Reuse Recycling': row[0] = descriptions[2] cursor.updateRow(row) del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

This question is a continuation of my last one: Query Features by Category and Keyword  The app so far has two drop-downs. The user can query by categories and query by keywords. <!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <meta name="viewport" content="initial-scale=1,maximum-scale=1,user-scalable=no" /> <title>Recycling Map</title> <link rel="stylesheet" href="https://js.arcgis.com/4.15/esri/themes/light/main.css" /> <script src="https://js.arcgis.com/4.15/"></script> <style> html, body, #viewDiv { height: 100%; width: 100%; margin: 0; padding: 0; } #infoDiv { background-color: white; color: black; padding: 6px; width: 440px; } #titleDiv { padding: 10px; } #titleText { font-size: 20pt; font-weight: 60; padding-bottom: 10px; } #results { font-weight: bolder; padding-top: 10px; } #category, #keyword { margin-top: 8px; margin-bottom: 8px; } </style> <script> require([ "esri/Map", "esri/views/MapView", "esri/layers/FeatureLayer", "esri/layers/GraphicsLayer", "esri/geometry/geometryEngine", "esri/Graphic" ], function ( Map, MapView, FeatureLayer, GraphicsLayer, geometryEngine, Graphic ) { var catTypeSelect = document.getElementById("category"); var keyTypeSelect = document.getElementById("keyword"); var filterButton = document.getElementById("SelectBtn"); // Recycling Locations View var recycleLayer = new FeatureLayer({ portalItem: { // autocasts as new PortalItem() id: "227061be60a14cc89946a978b440d227" }, outFields: ["*"], visible: false }); // GraphicsLayer for displaying results var resultsLayer = new GraphicsLayer(); var map = new Map({ basemap: "dark-gray", layers: [recycleLayer, resultsLayer] }); var view = new MapView({ container: "viewDiv", map: map, center: [-87.95, 41.47], zoom: 10 }); view.ui.add("infoDiv", "top-left"); // query all features from the Recycle layer view .when(function () { return recycleLayer.when(function () { var query = recycleLayer.createQuery(); return recycleLayer.queryFeatures(query); }); }) .then(getValues) .then(getUniqueValues) .then(addToSelect) // return an array of all the values in the // USER_Categ and USER_Keyword fields of the Recycle layer function getValues(response) { var features = response.features; var values = features.map(function (feature) { return { USER_Categ: feature.attributes.USER_Categ, USER_Keywo: feature.attributes.USER_Keywo } }); return values; } // return an array of unique values in // the keyword and category fields of the Recycle layer function getUniqueValues(values) { var uniqueKeyValues = []; var uniqueCatValues = []; values.forEach(function (item, i) { var keyVal = item.USER_Keywo.split(";"); var catVal = item.USER_Categ.split(";"); catVal.map(function (val1) { if ( (uniqueCatValues.length < 1 || uniqueCatValues.indexOf(val1) === -1) && val1 !== "" ) { uniqueCatValues.push(val1); } }); keyVal.map(function (val2) { if ( (uniqueKeyValues.length < 1 || uniqueKeyValues.indexOf(val2) === -1) && val2 !== "" ) { uniqueKeyValues.push(val2); } }); }); return { uKeyVals: uniqueKeyValues, uCatVals: uniqueCatValues }; } // Add the unique values to the category type // select element. This will allow the user // to filter categorys by type. function addToSelect(values) { values.uCatVals.sort(); values.uCatVals.forEach(function (value) { var option = document.createElement("option"); option.text = value; catTypeSelect.add(option); }); values.uKeyVals.sort(); values.uKeyVals.forEach(function (value) { var option = document.createElement("option"); option.text = value; keyTypeSelect.add(option); }); return setDefinitionExpression(); } // set the definition expression on the recycle // layer to reflect the selection of the user function setDefinitionExpression() { var sqlExp = ""; if (catTypeSelect.selectedIndex > 0) { sqlExp += "USER_Categ LIKE '%" + catTypeSelect.options[catTypeSelect.selectedIndex].value + "%'"; } if (keyTypeSelect.selectedIndex > 0) { if (sqlExp === "") { sqlExp += "USER_Keywo LIKE '%" + keyTypeSelect.options[keyTypeSelect.selectedIndex].value + "%'"; } else { sqlExp += " AND USER_Keywo LIKE '%" + keyTypeSelect.options[keyTypeSelect.selectedIndex].value + "%'"; } } recycleLayer.definitionExpression = sqlExp; if (!recycleLayer.visible) { recycleLayer.visible = true; } return queryForGeometries(); } // Get all the geometries of the recycle layer // the createQuery() method creates a query // object that respects the definitionExpression // of the layer function queryForGeometries() { var rQuery = recycleLayer.createQuery(); return recycleLayer.queryFeatures(rQuery).then(function (response) { rGeometries = response.features.map(function (feature) { return feature.geometry; }); return rGeometries; }); } filterButton.addEventListener("click", function () { setDefinitionExpression(); }); // set a new definitionExpression on the recycle layer // catTypeSelect.addEventListener("change", function () { // var type = event.target.value; // setDefinitionExpression(type, "cat"); // }); // set a new definitionExpression on the recycle layer // keyTypeSelect.addEventListener("change", function () { // var type = event.target.value; // setDefinitionExpression(type, "key"); // }); view.ui.add("titleDiv", "top-right"); }); </script> </head> <body> <div id="viewDiv"></div> <div id="infoDiv" class="esri-widget"> <div id="drop-downs"> Select Category (leave blank if searching by Keyword): <select id="category" class="esri-widget"></select> Select Keyword: <select id="keyword" class="esri-widget"></select> <button id="SelectBtn" class="esri-button esri-button--secondary">Search</button> </div> <div id="results" class="esri-widget"></div> </div> <div id="titleDiv" class="esri-widget"> <div id="titleText">Green Guide</div> <div>Easy Ways To Be More Green</div> </div> </body> </html>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Now I'd like to filter the categories and keywords based on two fields in the attribute table, USER_IsRes and USER_IsBus (residential and business). The values are either TRUE or FALSE-- Feature Layer View. I'm able to use a sample and loosely get that to function with the USER_IsRes field. <!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <meta name="viewport" content="initial-scale=1,maximum-scale=1,user-scalable=no" /> <title>Filter features by attribute - 4.15</title> <link rel="stylesheet" href="https://js.arcgis.com/4.15/esri/themes/light/main.css" /> <script src="https://js.arcgis.com/4.15/"></script> <style> html, body, #viewDiv { padding: 0; margin: 0; height: 100%; width: 100%; } #res-filter { height: 160px; width: 100%; visibility: hidden; } .res-item { width: 100%; padding: 12px; text-align: center; vertical-align: baseline; cursor: pointer; height: 40px; } .res-item:focus { background-color: dimgrey; } .res-item:hover { background-color: dimgrey; } #titleDiv { padding: 10px; } #titleText { font-size: 20pt; font-weight: 60; padding-bottom: 10px; } </style> <script> require([ "esri/views/MapView", "esri/Map", "esri/layers/FeatureLayer", "esri/widgets/Expand" ], function (MapView, Map, FeatureLayer, Expand) { let floodLayerView; // flash flood warnings layer const layer = new FeatureLayer({ portalItem: { id: "227061be60a14cc89946a978b440d227" }, outFields: ["USER_IsRes"] }); const map = new Map({ basemap: "gray-vector", layers: [layer] }); const view = new MapView({ map: map, container: "viewDiv", center: [-98, 40], zoom: 4 }); const resNodes = document.querySelectorAll(`.res-item`); const resElement = document.getElementById("res-filter"); // click event handler for res choices resElement.addEventListener("click", filterByres); // User clicked on Winter, Spring, Summer or Fall // set an attribute filter on flood warnings layer view // to display the warnings issued in that res function filterByres(event) { const selectedres = event.target.getAttribute("data-res"); floodLayerView.filter = { where: "USER_IsRes = '" + selectedres + "'", }; } view.whenLayerView(layer).then(function(layerView) { // flash flood warnings layer loaded // get a reference to the flood warnings layerview floodLayerView = layerView; // set up UI items resElement.style.visibility = "visible"; const resExpand = new Expand({ view: view, content: resElement, expandIconClass: "esri-icon-filter", group: "top-left" }); //clear the filters when user closes the expand widget resExpand.watch("expanded", function() { if (!resExpand.expanded) { floodLayerView.filter = null; } }); view.ui.add(resExpand, "top-left"); view.ui.add("titleDiv", "top-right"); }); }); </script> </head> <body> <div id="res-filter" class="esri-widget"> <div class="res-item visible-res" data-res="TRUE">True</div> <div class="res-item visible-res" data-res="False">False</div> </div> <div id="viewDiv"></div> <div id="titleDiv" class="esri-widget"> <div id="titleText">Flash Floods by res</div> <div>Flash Flood Warnings (2002 - 2012)</div> </div> </body> </html> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ But, how do I incorporate the filter (preferably client side since they say it's faster) into the app? Once the user has either a keyword or category selected I want there to be a way to filter with either Residential or Business. In the end, the selection methods should more or less mirror this page: Will County EEC Mobile Site ... View more

I want to create a webmap that is based off of this data-set, for example: Will County EEC Mobile Site  I'm not familiar enough with querying to be able to recreate the querying. My data-set has multiple categories and multiple keywords. I geocoded the spreadsheet, so now I have a point for each field. Like the example, I would like to have a orderly drop down for the category field and the keyword field. Currently, I can query features by the category field, but as you can see it is very impractical being that there are too many choices. How can I create my dropdown to look like the above? My current code (taken from sample code😞 <!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <meta name="viewport" content="initial-scale=1,maximum-scale=1,user-scalable=no" /> <title>Recycling Map</title> <link rel="stylesheet" href="https://js.arcgis.com/4.15/esri/themes/light/main.css" /> <script src="https://js.arcgis.com/4.15/"></script> <style> html, body, #viewDiv { height: 100%; width: 100%; margin: 0; padding: 0; } #infoDiv { background-color: white; color: black; padding: 6px; width: 400px; } #results { font-weight: bolder; padding-top: 10px; } .slider { width: 100%; height: 60px; } #drop-downs { padding-bottom: 15px; } </style> <script>require([ "esri/Map", "esri/views/MapView", "esri/layers/FeatureLayer", "esri/layers/GraphicsLayer", "esri/geometry/geometryEngine", "esri/Graphic", ], function( Map, MapView, FeatureLayer, GraphicsLayer, geometryEngine, Graphic, ) { var wellTypeSelect = document.getElementById("category"); // oil and gas wells var wellsLayer = new FeatureLayer({ portalItem: { // autocasts as new PortalItem() id: "f76b85e6c5314a0c96539d704fe92452" }, outFields: ["*"], visible: false }); // GraphicsLayer for displaying results var resultsLayer = new GraphicsLayer(); var map = new Map({ basemap: "dark-gray", layers: [wellsLayer, resultsLayer] }); var view = new MapView({ container: "viewDiv", map: map, center: [-87.95, 41.47], zoom: 10 }); view.ui.add("infoDiv", "top-left"); // query all features from the wells layer view .when(function() { return wellsLayer.when(function() { var query = wellsLayer.createQuery(); return wellsLayer.queryFeatures(query); }); }) .then(getValues) .then(getUniqueValues) .then(addToSelect) // return an array of all the values in the // STATUS2 field of the wells layer function getValues(response) { var features = response.features; var values = features.map(function(feature) { return feature.attributes.USER_Categ; }); return values; } // return an array of unique values in // the STATUS2 field of the wells layer function getUniqueValues(values) { var uniqueValues = []; values.forEach(function(item, i) { if ( (uniqueValues.length < 1 || uniqueValues.indexOf(item) === -1) && item !== "" ) { uniqueValues.push(item); } }); return uniqueValues; } // Add the unique values to the wells type // select element. This will allow the user // to filter wells by type. function addToSelect(values) { values.sort(); values.forEach(function(value) { var option = document.createElement("option"); option.text = value; wellTypeSelect.add(option); }); return setWellsDefinitionExpression(wellTypeSelect.value); } // set the definition expression on the wells // layer to reflect the selection of the user function setWellsDefinitionExpression(newValue) { wellsLayer.definitionExpression = "USER_Categ = '" + newValue + "'"; if (!wellsLayer.visible) { wellsLayer.visible = true; } return queryForWellGeometries(); } // Get all the geometries of the wells layer // the createQuery() method creates a query // object that respects the definitionExpression // of the layer function queryForWellGeometries() { var wellsQuery = wellsLayer.createQuery(); return wellsLayer.queryFeatures(wellsQuery).then(function(response) { wellsGeometries = response.features.map(function(feature) { return feature.geometry; }); return wellsGeometries; }); } // set a new definitionExpression on the wells layer wellTypeSelect.addEventListener("change", function() { var type = event.target.value; setWellsDefinitionExpression(type); }); });</script> </head> <body> <div id="viewDiv"></div> <div id="infoDiv" class="esri-widget"> <div id="drop-downs"> Select Category: <select id="category" class="esri-widget"></select> </div> <div id="results" class="esri-widget"></div> </div> </body> </html> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more