Transcript Olathe Cemetery Project

Olathe City Cemetery: an Update
of Online Capabilities
Scott Rice
GIS DBA
AIMS Coordinators Meeting
January 2010
Collin
Baffa
Amanda
Bakley
High School / College Interns (2006-09)
AIMS Coordinators Meeting
January 2010
Mission
• Olathe Memorial Cemetery
– ~8,000 member exclusive club
– Each member has a name, dates, and other
associated information
• Intern’s Task (2006-09)
– Match that information with a physical location
and a photo reference
(i.e. a picture and location for each headstone)
AIMS Coordinators Meeting
January 2010
Intern’s Tools
•
•
•
•
•
•
•
Maps- digital, and the old fashioned kind
Professional Survey
Trimble Geo XT and external antenna
Arcpad and Arcpad Application Builder
ArcGIS
AutoCad- Map3D
GPS-Photo Link
AIMS Coordinators Meeting
January 2010
Methods
• Interns collected points in Arcpad using a
Trimble GeoXT GPS device
• At each point (headstone) they took a
picture and recorded the name, date, and
time in a custom shapefile
AIMS Coordinators Meeting
January 2010
Collecting Data
• Take a GPS point at every headstone
• The name is added into the form
created for the cemetery project
• Once the point has been entered a
picture is taken of the headstone
• Repeat
AIMS Coordinators Meeting
January 2010
GPS-Photo Link
• GPS-Photo Link is software that combines
pictures and coordinate data into a single
shapefile
• It also creates thumbnails and custom
watermarked photos that are linked to the
shapefile
• It does this by matching the time a GPS
point was taken with the timestamp
embedded in digital photos
AIMS Coordinators Meeting
January 2010
Why?
• To create a searchable geodatabase that
will allow
– Quick location of people buried within the
cemetery
– Allow the caretaker to determine who is
buried in a particular location
– Allow the caretaker to determine quickly
which plots are open for future customers
– Create an internet version that will allow
searches by resident name, dates, or owner
name
AIMS Coordinators Meeting
January 2010
After the Interns
• Have 7,742 points in different feature classes
• Approximately 24,000 pictures (original, tagged,
thumbnail plus some extras)
• Tagged images have the x,y and date imprinted
on photo after processing by GPS Photo Link
• Merged all points into 1 feature class in test SDE
database
• 9 points missing images
AIMS Coordinators Meeting
January 2010
After the Interns
• 6 in center, 1 N
end, 2 S end
• Took own pictures
• Merged with rest
• Verified all 24,000
photos were
oriented correctly,
some were not
AIMS Coordinators Meeting
January 2010
After the Interns
• Images moved to web server
• Table exported from SQL Server to
MySQL (web server)
• Next step:
– Process to move images from Firebird
database (PONTEM) to MySQL
AIMS Coordinators Meeting
January 2010
After the Interns
• Website
– Parks & Rec hired a consultant to build web
site for viewing cemetery records
– Told us it would take 6 – 24 months to get the
headstone images incorporated
– We built a work around that went live at the
same time as cemetery online database
AIMS Coordinators Meeting
January 2010
Examples
• Demo: http://www.olatheks.org/parksrec/cemetery
– Effie, Daniel & Dean Park
– Goldie Carver & James McAuley (rotated photos)
– William Shakespeare
– Zuel
AIMS Coordinators Meeting
January 2010
Questions?
[email protected]
AIMS Coordinators Meeting
January 2010