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

This StoryMap describes the neighborhoods in Nashville and provides information on nearby apartments, restaurants, and points of interest.Nashville is one of the country's fastest growing cities. From music to healthcare, Nashville has seen an abundance of development in recent years. In 2023, 86 residents per day were moving to Nashville, and 18.6 million tourists visited the city [1].The first interactive feature will walk you through 11 neighborhoods found in Nashville. It was created using the “map tour” feature and walks you around a map of Nashville (created by me) while displaying the location and information. The information describes the ambience of each neighborhood as well as what they are known for and who typically lives in the area. All the information was provided by Nashville Guru [2]. Next, the story continues with rent for these locations. The values reflect the costs for studio/one-bedroom apartments. These costs were calculated using the Summary Statistics feature in ArcGIS Pro, which were then plotted in the chart seen in this StoryMap. After displaying the average values, there is a map of the individual apartments’ locations (created by me) with pop-ups showing the building name, starting rent, pool, and website link. This map and its pop-ups were created by me in ArcGIS Pro and then uploaded as a web map into ArcGIS Online. It utilizes an Experience Builder to allow you to filter through and focus on the apartments in each neighborhood. All of the information is available on apartments.com [3]. The next map dictates some restaurants in the area. The original feature layer was created by NNRobbins11 [4]. A spatial query was performed in ArcGIS pro by joining this restaurants layer to neighborhoods within a 1-mile distance. Like the apartments map, a filter is attached so that you may select a neighborhood. This allows you to select a neighborhood and then view the closest restaurants. There is also a pull-up arrow located at the bottom of this experience to allow users to view the pop-ups in table form.Finally, a sidecar is used to show the locations and information about local attractions. The map was created by me in ArcGIS Pro and shows 10 features with a name, description, and image. The description and image are shown in the left sidecar. All of this information is available in Nashville Guru [5]. The final video provides a live look of Nashville from a drone’s perspective [6]. Sources:[1] https://www.govloop.com/community/blog/the-enterprise-tech-driving-nashvilles-historic-growth/[2] https://nashvilleguru.com/neighborhoods[3] https://www.apartments.com/nashville-tn/?msockid=2dcf432ac6f36e722d9956e7c76a6fa7[4] https://services3.arcgis.com/58WV6GqBWodG9Kll/arcgis/rest/services/Nashville_Eateries/FeatureServer[5] https://nashvilleguru.com/[6] https://www.bing.com/videos/riverview/relatedvideo?&q=nashville+birds+eye+video&&mid=2489D5A39FFFCAE7A92B2489D5A39FFFCAE7A92B&&FORM=VRDGAR