OKSCAUG User Group Meeting at Edmond

Edmond Fire Training Center

5300 E Covell Road, Edmond, OK 73034
Click here for directions

A special thanks to :

The The City of Edmond Fire Department for the facility
&
Sara Cobb, Christy Batterson, & Ian Peebles for helping coordinate the event & provide the morning coffee & drinks.
&
 Meshek & Associates, PLC for the morning pastries & food.

8:30 - 8:45 a.m.
Welcome

---

8:45 - 9:30 a.m.
Spatial Analysis of Opioid Mortality and EMS Administration of Naloxone in Oklahoma
Johnnie Gilpen - Statistical Research Specialist - Oklahoma State Department of Health
Objective: Identify high-risk areas of opiate overdose using GIS to compare opiate-related overdose mortality data and EMS naloxone administration data.
Background: On 06/14/2014 House Bill 1782 took effect providing statutory revisions to Administration of opiate antagonists (§ 63-1-2506.1) allowing all first responders to administer naloxone.
Methodology: Patient-level data from the Oklahoma EMS Information System and vital statistics death data were used in conjunction with GIS techniques and spatial scan statistics to generate risk maps for areas with lower-than-expected naloxone use.
Results: Between 01/01/2011 and 06/03/2014, 13,064 instances of naloxone administration were reported. Four clusters of statistically significant, higher-than-expected naloxone administration were identified (1.01<RR<9.0, P=.001). Analysis revealed 19 clusters of lower-than-expected naloxone administration. The clusters of lower-than-expected usage correlated with basic and intermediate licensed EMS agencies. 
Conclusion: Analysis of spatial risk distribution may be useful identifying EMS agencies that would benefit from the Naloxone Training and Administration for EMS Personnel Program.

---

9:30 - 9:45 a.m. 
Break

---

9:45 - 10:30 a.m.
Chemicals in Your Community: How DEQ uses ArcGIS Online to Keep the Public Informed
Matt Wormus - Oklahoma Department Of Environmental Quality

---

10:30 - 10:45 a.m. 
Break

---

10:45 - 11:45 a.m.
Desktop Mapping: ArcMap Tips & Tricks
Pam Kersh - ESRI Solutions Engineer
Thomas Brown - ESRI Account Manager

In this session we will explore several workflows to enhance your experience working with ArcGIS Desktop such as performance, working with tables and geodatabases, and geoprocessing.

Online:

• Show new ArcGIS Desktop documentation page http://desktop.arcgis.com/en/documentation/
  

• ArcGIS for Desktop Extensions - Infographics Add In http://www.esri.com/software/arcgis/extensions/infographics
  

• Esri Data & Maps - Layer Packages http://esriurl.com/dataandmaps
  

• Can You Run It - ArcMap http://esriurl.com/canyourunit
  

----------------------------------------------------------------------------------------------------------------------------------------------------------------

Performance:

• Analyze Basemap via File Menu.
• Basemap Layers (Vector and Raster)
• Full Extent (ALT key and click Layer in TOC)
• Open Table (CRTL + Double Click Layer in TOC)
• Folder Connections à drag/drop
• AGOL Connection Tests via Taskbar

----------------------------------------------------------------------------------------------------------------------------------------------------------------

Tables:

• Rename Fields (geodatabase only)
• Change Field Type if Table is empty

----------------------------------------------------------------------------------------------------------------------------------------------------------------

Geodatabase

• Create File Geodatabase (CURRENT, 10.0, 9.3, 9.2)
• License file geodatabase – create and load file geodatabase with only the data you need, run Generate Licensed File Geodatabase, Run Generate File Geodatabase License, Apply the License to the Client through the ArcGIS Administrator.

----------------------------------------------------------------------------------------------------------------------------------------------------------------

Geoprocessing:

• Geotagged Photos to Points
• Table to Excel GP tool

----------------------------------------------------------------------------------------------------------------------------------------------------------------

PDF:

• PDF Encryption

----------------------------------------------------------------------------------------------------------------------------------------------------------------

---

11:45 a.m. - 12:00p.m.
Closing Remarks & Door Prizes

Attendees GISP credits : 4 hours - EDU - 0.1 credits
Presenters GISP Credits : 1 hour - CON -  1 credit