General Information Monroe County

1
General Information Monroe County
Monroe County, Indiana Population 110,000
Square Miles 418 Land Parcels
58,000 Major City Bloomington INDIANA
UNIVERSITY
2

• The Monroe County Health Department was formed in
  1965
• Septic Permit Database initiated in 1980s
• Scanning of hard copy permits began 1998
• Total Permits since 1966 - 17,000

3
How can we automate
A need existed to automate this process
4
Microsoft Access Septic Permit Database
maintained in the Health Dept
5

• ESRI shp file
• for Septic System locations
• containing 1285 points
• Collected with Health Dept staff
• using paper forms and
• non-integrated GPS
• (staff acquired the GPS coordinates and wrote
  them on the paper form)
• Our goal was to make this process
• more efficient and upgrade the
• technology

6
What could we acccomplish
What did we want to accomplish

• Perform reliable, accurate, and validated field
  data collection.
• Integrate GPS, rangefinders, and digital cameras
  into GIS data collection.
• Share enterprise data with field-workers for
  updating and decision making.
• Improve the productivity of GIS data collection.
• Improve the accuracy of the GIS database and make
  it more up to date.

7
ESRI and Trimble provided an integrated
solution with equipment and software that was
within our budget
8
MC Field GIS users
Monroe County GIS Integration
HEALTH DEPT EMERGENCY MANAGEMENT HIGHWAY DEPT
Trimble GeoXT

Microsoft SQL Server
9
Our first goal was to define the existing
process used by the Health Department for
Septic System inspections
10
Monroe County Health Department Wastewater
Sanitarian arrives to Complete Septic System
inspection
First thing to inspect
11
More realistically an inspector will occasionally
find a failing or non-compliant Septic System
12
Time to call in the heavy equipment
13
Gary Cain, Monroe ,County Wastewater Sanitarian
explains to the installer how he excavated in the
WRONG yard
14
Monroe County Health Dept Staff prepare a site
map from The County GIS using Arcview, so
installers can alleviate the previous slide
depiction
15
Trimble GeoXT GPS with ArcPad collects
Coordinates of the Septic and elevation data
16
Monroe County Health Department GIS GPS
Integration
17
Health Dept staff prepare data for ArcPad using
the getdata button in ArcView
18
Once in the field with the GeoXT/ArcPad The
inspector can collect a new septic point feature
And acquire the State Plane coordinates
19
Once a point is collected, custom forms appear to
enter attribute data These forms are constructed
with ArcPad Application Builder
20
After the field collection is complete, the
Inspector places the Trimble GeoXT in the desktop
cradle and synchronizes the data collected to the
GIS database This is also how the data is
initially transferred to the GeoXT
21
(No Transcript)
22
Microsoft SQL Database now integrated with the
Field Data Collection After the field collection
is complete, the office staff can view the data
and add any other pertinent information
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
The data collected in the field, now appears in
ArcView with the attributes attached. This
entire process saves redundancy and eliminates
data entry in the office by Health Dept Staff.
28
Monroe County Health Department http//www.co.mon
roe.in.us/health