Hello,
I'm trying to bring into an alteryx workflow data that is located in the urls below and that are formatted as a geodatabase file type. I'm familiar with importing in shape files but have so far been unable to import the data found at the links below. I'm also been unable to find any topics/references on importing in a geodatabase file type in the Alteryx community page.
Could anyone assist with how to appropriately import the data? I've most recently tried Input Data/Data Sources/ESRI Geodatabase but it results in a blank table image (attached)
https://data-wadnr.opendata.arcgis.com/datasets/wildfire-urban-interface-wui-wui-wa-gdb-zipped-file-geodatabase
https://data-wadnr.opendata.arcgis.com/datasets/wildfire-urban-interface-zipped-tif-file-wui-wa-tif-wui
So it's my understanding that the .tif file at that link is an image file for viewing and not necessarily coordinate data you can convert in Alteryx. In the zipped folder, there's an XML file that provides instructions on how to place and scale the image (projection, scale, and lat/long boundaries), but it's still meant to just be an image that has been prepared. ArcGIS should be able to take this and display it (maybe an ArcGIS user to confirm this?), but I'm not sure what else could be done with Alteryx.
Now, that being said, if you're looking for spatial data on the wildfires that you can use in Alteryx, then I found this page which gives several downloadable options that will work:https://data-wadnr.opendata.arcgis.com/datasets/dnr-fire-statistics-2008-present-1/data
I downloaded the "File Geodatabase" and after I unzipped the file, I was able to navigate to the dbf and open it. To open the gdb from an Input tool, here's how I selected it:
I navigated to the unzipped folder and was able to select "wa_fires.gdb" and then "wa_fires" as the table.
I was then able to open and explore the data in Alteryx:
So that's how I was able to download it from the website (#themoreyouknow), but I'll also attach a .yxdb here if you want to skip to that. This looks like the spatial data that was used to create the heatmap .tif file. So maybe you could use the Alteryx Heatmap tool or other spatial methods to create your own polygons and render them as you'd like.
Hi Charlie - thanks for that explanation of the tif file! I was able to track your explanation on the wildfires but that is unfortunately a different set of data to the WUI links (which measures how dangerous certain areas in WA potentially are for wildfire).
If the tif is unusable, which makes sense, is it possible to use this link and the gbd data to get to the underlying data for viewing in alteryx?
I'm hoping to extract the data from that link to view the data in alteryx and recreate the map in the attached snip essentially (the data in the map is from 2012 and the agency has since updated it in the 2019 map).
