Unable to Read Spatial Data

[WBrennan88]

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-...

https://data-wadnr.opendata.arcgis.com/datasets/wildfire-urban-interface-zipped-tif-file-wui-wa-tif-... 

[CharlieS]

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.

[WBrennan88]

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?

https://data-wadnr.opendata.arcgis.com/datasets/wildfire-urban-interface-wui-wui-wa-gdb-zipped-file-...

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).

[CharlieS]

I've looked through this website for that data, but I haven't been successful:

I followed the datasource here:
https://data-wadnr.opendata.arcgis.com/datasets/wadnr-public-wd-wui/data

But the data table from that page shows "An error occurred fetching data." and the API didn't get me anywhere either. 

ThenI followed the metadata link here to ArcGIS:

https://www.arcgis.com/home/item.html?id=81033d352eb5401cb559fa999f9d6931

There's a download for "wui_wa_gdb.zip" I followed the same process for unzipping and loading the gdb as in the above post. It seems like the right thing, but the .gdb file never gives a table to open. 

Running into these issues makes me think you should reach out to the email provided in the description to see, if nothing else, they could check the hosted data.

" For more information about the WUI, please contact: ashley.blazina@dnr.wa.gov"

[WBrennan88]

Hi Charlie - thanks again for looking into this question! The data source does seem to be a little off if even you cannot get the data to open or open a gdb table. I'll work on analyzing the subject without that data in that case then.