Instead wouldn’t it be more efficient if you could define such layer just once, and click a button to switch from one month to another month or quarter to produce map or data for that particular time window? where data comes in more frequently, keep repeating these steps might not be a good idea. In this particular case, it might be okay to keep repeating, but in other cases such as property sales etc. Now, if you need to do the same for a different month or a different quarter or a fiscal year, you’d need to repeat the same steps. Apply a new or predefined symbology to the layer with an attribute field that stores an aggregated results.Join the output result to your state boundary layer.Run Summary Statistics geoprocessing tool to compute total or/and average unemployment for each state using the state name/fips field as the Case field.Select unemployment records for the current month using Select By Attributes geoprocessing tool.Here are the steps ( or something similar) that you’d most likely take: a state has >1 counties for multiple months. As you have already figured out that there is a one-to-many relationship i.e. Now you need to make maps or perform some analysis using data aggregated at state level for the current month. Let’s further assume this is a historic data set that spans over multiple years – meaning you have maximum 12 records for each county for each year. You have monthly unemployment data, recorded at county level, stored in a table. Now with the advent of this tool anyone without any SQL knowledge can perform such analysis.īefore we start, please note that you must have your data in an enterprise database such as PostgreSQL, SQL Server, Oracle etc. On top it required some expertise in SQL. But creating such layers was not a very user friendly task until 2.8 release.
#ESRI QUERY TABLE TOOL PRO#
This tool allows you to perform some aggregated analysis from related records that was never even possible until ArcGIS Pro 1.4. I’m very excited to introduce you to this geoprocessing tool that was released with ArcGIS Pro 2.8 earlier this year.