Executive Directive No. 2013-1Data and Information Sharing, Management and Governance
• http://michigan.gov/documents/snyder/ED_2013-1_439597_7.pdf
• Establishes an Enterprise Information Management (EIM) program
• Improve service delivery and transparency
• All Executive Branch departments to participate
• Include cross-agency data sharing protocol
• Each department to establish a Chief Data Steward
• Incorporate an EIM strategy for successful cross-boundary collaboration with external partners of state departments
2
3
Master Repository for Shared Data
DOS
DCH
DEQ
MSP
CSS - DTMB Maintains & Governs common or shared data along with data stewards
Each Agency maintains their own unique sets of data to join with Location data. Each Agency has own Data Steward and Data Owner to maintain particular portions on Master Location and own unique data sets.
Shared Data
Enterprise Information Management Concept –State Government Level
Local County Governments
Data Steward Addressing & Location
Goal is to share Common Data that each Agency can use• First common set of data identified by EIM Steering Committee is
addresses/location.
• Locations have several meanings and usages by Agency.
• CSS is attempting to gather requirements by State Agency that would allow sharing of addresses/locations by Agency.
• CSS has identified that local governments may benefit from sharing of data as well and may want to participate in a Master Address Repository that will contain the cleanest and most up-to-date addresses.
• Looking to discover local government requirements needs for access and housing address information.
4
6
DHS Street Addresses
SOS Street Addresses
DCH Street Addresses
Treasury Street Addresses
ED/CEPI Addresses
Authoritative Street Addresses
UIA Street Addresses
Street Address
111 S. Capital, Lansing, MI 48933
Today - 32 million addresses Managed In DHS Data Warehouse
DCH uses address as criteria to determine identity
Maintainer of legal address
Mail unemployment checks
Mail test results – addresses provided By school districts
Personal tax filers, 40+ tax types
Simple View of Address
Common business problems• Returned mail• Address formatting cost• Managing PO Box addresses
Governance Decision• Who can modify “master” addresses?• Who can add “master” address?• Are there multiple trusted sources?• Is additional information needed • per address?
7
DHS Street Addresses
SOS Street Addresses
DCH Street Addresses
Treasury Street Addresses
ED/CEPI Addresses
Authoritative Street Addresses
UIA Street Addresses
StreetAddress
Geo Code
111 S. Capital, Lansing, MI 48933
42.733377, -84.553324
Today - 32 million addresses Managed In DHS Data Warehouse
DCH uses address as criteria to determine identityMaintainer of legal address
Mail unemployment checks
Mail test results – addresses provided By school districts
Personal tax filers, 40+ tax types
GeoSpatial View of Address
Common business problems• Location of addresses within
geographic boundaries• Returned mail• Address formatting cost• Managing PO Box addresses
Governance Decision• Who can modify “master” address?• Who can add “master” address?• Are there multiple trusted sources?• Is additional information needed • per address?
Provide accurate lat, long For each street address
Counties, Townships, Cities
Benefits to local users
• Address cleansing, verification, geocoding
• CASS Certification
• Delivery point validation
• Structure point creation
• Structure point maintenance workflow
• Cross boundary standardization / sharing
• Improved accuracy for analysis
• Structure type identification for GIS layer development
8
9
R
HC
Bridge
C
R
R
R
R
R
C
C
I
I
Park
Lake
R
Address Points Don’t always correlate correctly to places when looking at points on a map.
This is due to standardized addressing software that places the points on a map as if each address was interpolated and may be off by several feet to miles in some cases.
Jurisdictional Boundary
Interpolated Address
10
R
HC
Bridge
C
R
R
R
R
R
C
C
I
I
Park
Lake
R
A more accurate way to map addresses would be to add (X,Y) Coordinates to the locations to get better precision.
This will benefit Michigan Agencies when performing their analyses when drawing boundaries, districts or access points.
Jurisdictional Boundary
Barry County –Discrepancy Example
11
Key:
Local County Data Point
SAP Standardized Address Point
Difference in SAP and Local data point
What Address Mastering will Enable
12
Master Address Repository
Qu
alit
y o
f R
epo
sito
ry
Clean and more accurate address points
Ability to assign Agency program information to
Addresses
Cross Agency / local government analysis
Ability to assign individuals to addresses?
Leve
l of
An
alys
is
Next Steps
• Identify Local Government Addressing Needs:
• Survey to be sent out Mid-February to assess:• Addressing capabilities
• How often updated
• Coordinates added
• Type of systems used to capture and maintain data
• Volunteer data for quality assessment – Return SAP attributes
• EIM Steering Committee• Performing analysis on Agency address needs
13