The crash
A
AFR data
Florida municipalities............. 54
Americans With Disabilies Act...... 9
Assigned To
Support Tickets....................... 15
B
BS&A
import trial balance................ 58
Bullying
import Michigan data............. 75
C
Capital Improvement Manager
described................................. 23
Census
exporting from........................ 91
County Millage Rate
Michigan upload..................... 67
crash data
Michigan import annually...... 68
D
Database Naming Convention
explained................................. 16
Debt
Florida...................................... 55
Debt Manager
described................................. 21
digital business car...................... 10
Dirty Laundry
SGX data loaded chart............ 32
distance
calculation from local unit..... 11
E
Entity Master
Michigan schools.................... 70
Ethnicity Codes
M-STEP student data.............. 32
Expulsion
import Michigan data............. 75
F
Florida
pension & OPEB...................... 56
foreign keys
naming convention................. 17
function
SLO pretest group IDs............. 35
G
geocoding
Census batch................ 104, 105
L
Longevity
MI staff import....................... 76
M
MailManager............................... 14
Migrant
MI enrollment import...... 74, 75
M-STEP
Private student data upload.. 80
Public data upload.................. 78
N
narratives....................................... 8
local unit specific...................... 8
New York
municipal annual data............ 81
P
Peer Groups
display...................................... 11
Pennsylvania
municipal annual data............ 85
primary key
naming convention................. 17
R
Revenues
Florida...................................... 55
S
School Millage
Michigan upload..................... 70
Shared Services
link to project tracker............. 13
staff demographic
import...................................... 77
Staffing
school data load...................... 42
Student Enrollment
Florida...................................... 54
Student Information Software
used for making a quasi-roster 33
Student Learning Objectives
defined.................................... 34
Support Ticket
assigned to.............................. 15
survey
CNA perception & process..... 26
T
taxable value
Florida...................................... 57
Transportation
school data load...................... 42
V
Victims of Violent Crime
import Michigan data............. 76
support tickets........................ 15
data comes from the TIA. The data has its own code for the county and the local unit. There is a MySQL staging table that serves as a decoder to convert the TIA code to the Munetrix MunID (aa_mi_crash_decoder). There is also a small staging table to roll the crash levs up to the three categories we report (aa_mi_crashlevel).
The current data set does not provide data by county therefore these need to be rolled up from local units to counties, SPDR’s and the state.
The SQL utilities to import the data is stored in: MU MI Import Crash Data. Import the raw data into the MySQL staging table: aa_mi_crashdata.