Author: Titus, Maxwell (mtitus@esri.com)Last Updated: 3/4/2025Intended Environment: ArcGIS ProPurpose: This Notebook was designed to automate updates for Hosted Feature Services hosted in ArcGIS Online (or ArcGIS Portal) from ArcGIS Pro and a spatial join of two live datasets.Description: This Notebook was designed to automate updates for Hosted Feature Services hosted in ArcGIS Online (or ArcGIS Portal) from ArcGIS Pro. An associated ArcGIS Dashboard would then reflect these updates. Specifically, this Notebook would:First, pull two datasets - National Weather Updates and Public Schools - from the Living Atlas and add them to an ArcGIS Pro map.Then, the Notebook would perform a spatial join on two layers to give Public Schools features information on whether they fell within an ongoing weather event or alert. Next, the Notebook would truncate the Hosted Feature Service in ArcGIS Online - that is, delete all the data - and then append the new data to the Hosted Feature ServiceAssociated Resources: This Notebook was used as part of the demo for FedGIS 2025. Below are the associated resources:Living Atlas Layer: NWS National Weather Events and AlertsLiving Atlas Layer: U.S. Public SchoolsArcGIS Demo Dashboard: Demo Impacted Schools Weather DashboardUpdatable Hosted Feature Service: HIFLD Public Schools with Event DataNotebook Requirements: This Notebook has the following requirements:This notebook requires ArcPy and is meant for use in ArcGIS Pro. However, it could be adjusted to work with Notebooks in ArcGIS Online or ArcGIS Portal with the advanced runtime.If running from ArcGIS Pro, connect ArcGIS Pro to the ArcGIS Online or ArcGIS Portal environment.Lastly, the user should have editable access to the hosted feature service to update.

This data is utilized in the Lesson 1.1 What is Climate activity on the MI EnviroLearning Hub Climate Change page.Station data accessed was accessed from NOAA. Data was imported into ArcGIS Pro where Coordinate Table to Point was used to spatially enable the originating CSV. This feature service, which incorporates Census Designated Places from the U.S. Census Bureau’s 2020 Census Demographic and Housing Characteristics, was used to spatially join weather stations to the nearest incorporated area throughout Michigan.Email Egle-Maps@Michigan.gov for questions.Former name: MichiganStationswAvgs19912020_WithinIncoproatedArea_UpdatedName Display Name Field Name Description

STATION_ID MichiganStationswAvgs19912020_W Station ID where weather data is collected

STATION MichiganStationswAvgs19912020_1 Station name where weather data is collected

ELEVATION MichiganStationswAvgs19912020_6 Elevation above mean sea level-meters

MLY-PRCP-NORMAL MichiganStationswAvgs19912020_8 Long-term averages of monthly precipitation total-inches

MLY-TAVG-NORMAL MichiganStationswAvgs19912020_9 Long-term averages of monthly average temperature -F

OID MichiganStationswAvgs1991202_10 Object ID for weather dataset

Join_Count MichiganStationswAvgs1991202_11 Spatial join count of weather station data to specific weather station

TARGET_FID MichiganStationswAvgs1991202_12 Spatial Join ID

Current place ANSI code MichiganStationswAvgs1991202_13 Census codes for identification of geographic entities (used for join)

Geographic Identifier MichiganStationswAvgs1991202_14 Geographic identifier (used for join)

Current class code MichiganStationswAvgs1991202_15 Class (CLASSFP) code defines the current class of a geographic entity

Current functional status MichiganStationswAvgs1991202_16 Status of weather station

Area of Land (Square Meters) MichiganStationswAvgs1991202_17 Area of land in square meters

Area of Water (Square Meters) MichiganStationswAvgs1991202_18 Area of water in square meters

Current latitude of the internal point MichiganStationswAvgs1991202_19 Latitude

Current longitude of the internal point MichiganStationswAvgs1991202_20 Longitude

Name MichiganStationswAvgs1991202_21 Location name of weather station

Current consolidated city GNIS code MichiganStationswAvgs1991202_22 Geographic Names Information System for an incorporated area

OBJECTID MichiganStationswAvgs1991202_23 Object ID for point dataset

The NVIS vegetation attributes contain information on vegetation structure (growth form, height and cover) and floristics (genus and species) as documented in the Australian Vegetation Attribute Manual Version 7.0 (NVIS Technical Working Group, 2017).The NVIS detailed Level 1-6 vegetation descriptions make up theNVIS Information Hierarchy andare used to assign the Major Vegetation Groups and Major Vegetation Subgroups classifications. The hierarchy is based on structural and floristic information including dominant genus, growth form, height and cover and are preferably collected at the Level 6 Sub-Association (sub-stratum) level. For many reasons including different scales and classification methods, not all data is collected at this level of detail. Currently there are over 19,500 distinct NVIS vegetation descriptions in the NVIS database. For more information refer to the Australian Vegetation Attribute Manual.These detailed vector data products may be used at a regional scale and allow for more complex analyses when joined with the associated Lookup Table of Flat File. They are available in Present (Extant) and Estimated Pre-1750 (pre-European - where available) themes. Data is available under CC BY. It is recommended the datasets be used alongside the Key Layers to better understand the source data attributes such as differing scales, age of data etc.For this update, Version 7.0, the extant datasets for Queensland, Australian Capital Territory, New South Wales and Tasmania have been updated. An automated, data-driven procedure, followed by thorough manual checks, was undertaken to make any necessary updates to MVG/MVS assignments for Australian Capital Territory, New South Wales and Tasmania. Conversely, Queensland directly provided the MVG/MVS assignments for the state.This dataset is not comparable with earlier versions of NVIS.Reference: NVIS Technical Working Group (2017) Australian Vegetation Attribute Manual: National Vegetation Information System, Version 7.0. Department of the Environment and Energy, Canberra. Prep by Bolton, M.P., de Lacey, C. and Bossard, K.B. (Eds)USE INSTRUCTIONS----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Datasets:the File Geodatabase contains the following information:ItemExplanationNVIS7_0_AUST_EXT_{State}This dataset is a vector layer delineating the extant ('present') native vegetation types across Australia as a feature class for each State or TerritoryNVIS7_0_LUT_AUST_DETAILThis table: is a lookup table containing NVIS Version 7.0 vegetation descriptions. The table contains a total of 19,519 NVIS vegetation types.NVIS7_0_LUT_AUST_FLATThis table is a lookup table containing NVIS Version 7.0 vegetation descriptions in a simpler, deconstructed table, allowing for improved analyses and use of the NVIS detailed vegetation descriptions. The table contains a total of 19,519 NVIS vegetation types.Table Joins:NVIS7_0_LUT_AUST_DETAILThis table joins to the NVIS 7.0 spatial data for all states and territories (NVIS_ID in this table to NVISDSC1 in NVIS7_0_AUST_EXT_[STATE] and NVIS7_0_AUST_PRE_[STATE] ). For complex analyses and to extract maximum information from NVIS spatial data, this LUT can also be linked to NVISDSC2-6. It is recommended that users refer to the Australian Vegetation Attribute Manual V7.0 for understanding of the NVIS hierarchy (Level 1-6 descriptions) -https://www.dcceew.gov.au/environment/land/publications/australian-vegetation-attribute-manual-version-7.Once this table has been joined, a simple display option is to use the field "NVIS7_0_LUT_AUST_DETAIL.MVG_NAME" (or MVS_NAME if preferred) which includes the names of the NVIS Major Vegetation Groups (MVGs).A legend or 'shadeset' for the MVGs and MVSs can be found packaged with the detailed vector data: NVIS7_0_AUST_EXT_[STATE] and NVIS7_0_AUST_PRE_[STATE].Use the field "MVG_NUMBER" or "MVS_NUMBER" for the symbology.NVIS7_0_LUT_AUST_FLATFor complex analyses and to extract maximum information from NVIS spatial data, this LUT can also be linked to NVISDSC1-6. This LUT is a deconstruction of the Level 5 string within the NVIS detailed data (for NVIS Level 1-6 strings use NVIS7_0_LUT_AUST_DETAIL) where provided by the state/territory (not all veg descriptions have Level 5/6). It is recommended that users refer to the Australian Vegetation Attribute Manual V7.0 for understanding of the NVIS hierarchy (Level 1-6 descriptions) and structural information -https://www.dcceew.gov.au/environment/land/publications/australian-vegetation-attribute-manual-version-7. A legend or 'shadeset' for the MVGs and MVSs can be found packaged with the detailed vector data: NVIS7_0_AUST_EXT_[STATE] and NVIS7_0_AUST_PRE_[STATE]. This table joins to the NVIS 7.0 spatial data for all states and territories (NVIS_ID in this table to NVISDSC1 in NVIS7_0_EXT_[STATE] and NVIS7_0_PRE_[STATE] ). For complex analyses and to extract maximum information from NVIS spatial data, this LUT can also be linked to NVISDSC2-6. Once this table has been joined, a simple display option is to use the field "NVIS7_0_LUT_AUST_FLAT.MVG_NAME" (or MVS_NAME if preferred) which includes the names of the NVIS Major Vegetation Groups (MVGs).Retrieving data by state or territory:the first number of theNVIS_ID corresponds to a specific state or territory and can be used to subset the larger datasetCodeExplanation1Australian Capital Territory2New South Wales3Northern Territory4Queensland5South Australia6Tasmania7Victoria8Western AustraliaSymbology:To enable full Major Vegetation Group descriptions to appear in the legend in an ArcGIS Desktop map or ArcGIS Pro project, the following layer files will need to be imported and the symbology set using the relevant attribute field. Layer files are within the zipped package.