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

Access APIGeocoded Addressing Theme Please Note WGS 84 service aligned to GDA94 This dataset has spatial reference [WGS 84 ≈ GDA94] which may result in misalignments when viewed in GDA2020 …Show full description Access APIGeocoded Addressing Theme Please Note WGS 84 service aligned to GDA94 This dataset has spatial reference [WGS 84 ≈ GDA94] which may result in misalignments when viewed in GDA2020 environments. A similar service with a ‘multiCRS’ suffix is available which can support GDA2020, GDA94 and WGS 84 ≈ GDA2020 environments. In due course, and allowing time for user feedback and testing, it is intended that the original service name will adopt the new multiCRS functionally.The Geocoded Urban and Rural Addressing System (GURAS) is a ‘property’ based address database. Each property polygon captured within GURAS has a unique numeric identifier and contains at least one authoritative address which is sourced from local councils via the valuation of land database, also managed by LPI-Valnet. Properties may contain more than one address sourced from various other organisations. The GURAS database is commonly used by all levels of government for emergency services, computer aided dispatch systems, postal and delivery services, and to identify location. Address points are generally system generated points and do not always have a direct correlation to the dwelling location. In circumstances where there are multiple disparate lots for one property, particularly in rural addresses, the system generated address points may not reside within the correct property polygon. Owners names are not part of the GURAS database, nor does GURAS contain any personal information. The Geocoded Addressing Theme is a single source of truth for address information in NSW, GURAS eliminates the costly duplication of effort where all local councils, Australia Post, emergency service organisations and other agencies and businesses maintained individual address databases with different creation and distribution regimes.Geocoded Addressing Data Theme includes the following feature classes:Waypoint - A WayPoint is a point located on the RoadSegment feature class for an address where the road naming attributes from both the AddressString and the RoadSegment classes are identical. Indicates the approximate entry point of for an address.Address Point - A point feature class used to spatially locate an address / address stringThe Address Point Layer includes the below subtypes:· Building· Homestead· Monument· Property· Unit/Strata· OtherPro Way - A Proway is a line that spatially connects the AddressPoint and WayPoint.The Pro Way Layer includes the following subtypes:· Right· Left· OtherMetadata Type Esri Map ServiceUpdate Frequency As required Contact Details Contact us via the Spatial Services Customer Hub Relationship to Themes and Datasets NSW Geocoded Addressing Theme of the Foundation Spatial Data Framework (FSDF) Accuracy The dataset maintains a positional relationship to, and alignment with, the Lot and Property digital datasets. This dataset was captured by digitising the best available cadastral mapping at a variety of scales and accuracies, ranging from 1:500 to 1:250 000 according to the National Mapping Council of Australia, Standards of Map Accuracy (1975). Therefore, the position of the feature instance will be within 0.5mm at map scale for 90% of the well-defined points. That is, 1:500 = 0.25m, 1:2000 = 1m, 1:4000 = 2m, 1:25000 = 12.5m, 1:50000 = 25m and 1:100000 = 50m. A program of positional upgrade (accuracy improvement) is currently underway. Spatial Reference System (dataset) Geocentric Datum of Australia 1994 (GDA94), Australian Height Datum (AHD) Spatial Reference System    (web service) EPSG 4326: WGS 84 Geographic 2D WGS 84 Equivalent ToGDA94 Spatial Extent Full State Standards and Specifications Open Geospatial Consortium (OGC) implemented and compatible for consumption by common GIS platforms. Available as either cache or non-cache, depending on client use or requirement. Information about the “Feature Class” and “Domain Name” descriptions for the NSW Administrative Boundaries Theme can be found in the GURAS Delivery Model Data DictionarySome of Spatial Services Datasets are designed to work together for example “NSW Address Point” and “NSW Address String Table”, NSW Property (Polygon) and NSW Property Lot Table and NSW Lot (polygons). To do this you need to add a “Spatial Join”. A Spatial join is a GIS operation that affixes data from one feature layer’s attribute table to another from a spatial perspective. To see how Address, Property and Lot Geometry data and Tables can be joined together download the Data Model Document. This will show what attributes in the datasets can be linked.Distributors Service Delivery, DCS Spatial Services 346 Panorama Ave Bathurst NSW 2795Dataset Producers and Contributors Administrative Spatial Programs, DCS Spatial Services 346 Panorama Ave Bathurst NSW 2795