Creative GIS Solutions fo Today's Problems by Andrew Harrison

Our “Creative GIS Solutions for Local Government” presentation covers how communities around the country have been providing creative solutions to today’s problems using GIS. This presentation completely composed of case studies on how other communities have solved problems with innovative GIS ideas. Examples like accident tracking, cemetery mapping, finding lost tax revenue, decreasing appeals, best practices for inventory of assets, simple access to your data, online permitting, and many more. The goal of this presentation will be to share many different ideas for GIS use and for you to leave the session with new ideas that you can go home and try. Don’t miss this opportunity to see how other communities are implementing solutions that save them time and millions of dollars!

Transcript

1. Creative GIS Solutions to Today’s Problems Presenter: Andrew Harrison, GISP aharrison@schneidercorp.com 317-690-1513
2. Creative GIS Solutions to Today’s Problems • In this session we will look at uses of GIS and how local governments have been able to think “out of the box” and provide a GIS-based return on investment (ROI). Come learn more about how you can provide creative solutions to today's problems. This session will be completely composed of case studies – how other communities have solved problems with innovative ideas. Don’t miss this opportunity to see how other communities are implementing solutions that save them time and money!
3. Today’s Topics 1. Tornados 2. Rental Permits 3. Blue Angels 4. Selling your data 5. Ohio Bridge Project 6. Helping Assessor’s 7. Permitting 8. Sign Inventory 9. ADA 10. Sex Offenders
4. Storm Shelters • Purpose was to identify residents with poor storm shelter and maximize the number of residents to be covered by new shelters. – Identify residents with poor storm shelter – Maximize the number of residents to be covered by new shelters – Build 8 new storm shelters
5. Storm Shelters • March 9th – 13th 2006 105 tornadoes pass through causing a billion dollars in property damage and 13 fatalities
7. Disaster • 6 tornadoes pass through Pettis County • Cutting a path more than 16 miles wide • Two storm related fatalities
8. Problem # 2 • New Storm Shelters cost on average $300,000 each • County had three weeks to respond for a grant application to build new shelters
9. How? • Using your GIS parcel data – Identify (from your CAMA data) • Mobile home parks • Residential homes without basements – Identify existing Storm Shelter locations – Buffer Storm Shelter locations (3 miles)
12. Return on Investment • Received nearly $4,000,000 in FEMA Hazard Mitigation Grants. • New shelter will make a safer community by covering – 83% mobile home parks – 80% without basements – 78% all residential homes
13. Residential Rentals
14. Rental Permits - Problem • City of Valparaiso has a estimated 6,000 rental units • Need to root out safety issues • Fire Department does Inspections • Need new standards • Want a complaint driven system
15. Program Purpose • The purpose is to facilitate the prevention and correction of violations of all laws and ordinances pertaining to residential rental properties and to protect the public health, safety, and welfare of the citizens of Valparaiso. • Source: http://www.ci.valparaiso.in.us
16. Program Purpose • Inspection – Building Codes – Property Maintenance Codes – Unified Development Ordinance – Other applicable Regulations – Protect the character and stability of residential neighborhoods – Safety, health and general welfare of occupying dwellings – Prevent overcrowding – Prevent slums and blight – Preserver the value of land and building throughout the city. – Source: http://www.ci.valparaiso.in.us/DocumentCenter/Home/View/1029
17. Rental Registration • The Rental Registration Program requires all residential rental properties to be registered with the City of Valparaiso at $10 per unit.
18. Map of Rentals
20. Blue Angels
21. Problem • Airplanes don’t want to hit anything while in flight that they have not targeted.
22. Blue Angels • F/A – 18 HORNET • Speed MACH 1.7+ • Crew ONE • Combat Ceiling 50,000’ • A total of 16 officers voluntarily serve with the Blue Angels. Each year the team typically selects three tactical (fighter or fighter/attack) jet pilots, two support officers and one Marine Corps C-130 pilot to relieve departing members. • http://www.blueangels.navy.mil/team/
23. Side Note: My oldest son U.S. Navy Rescue Swimmer Petty officer third class, Patrick Harrison
24. Risk Mitigation • Hancock County GIS Supported Risk Mitigation
26. Appreciation
27. Selling your Data • Yes • No • Maybe • Not sure
28. How did they generate $79,395.00 in Revenue? • Miami County, KS ,, – 27 Subscribers = $ – Parcels 18,535 • Pettis County, MO – 217 Subscribers = $ – Parcels 24,303 • Berrien County, MI – 663 Subscribers = $ – Parcels 101,495 • Brookings County, SD – 76 Subscribers = $ – Parcels 15,844 • Morrison County, MN – 463 Subscribers = $ (and data sells) – Parcels 31,721
29. 10 Unique Features
30. Mailing Label Generator
31. Payment Collection
32. Third Party Integration
33. Asset Management
34. AVL Vehicle Location Management
35. Specialty Mapping
36. Document Access Tools
37. Advanced Search Tools
38. Field Data Collection
39. The Ohio River Bridges
41. Precondition Surveys • http://www.lrrb.org/media/reports/TRS1201.pdf
43. Lawsuits
45. Congratulations! Marshall County, IN
46. Saved Tax Payers • They may have saved over $45,000 in just three weeks! • How? – Registered Contractor List
47. • Apply and track permitting progress 24/7 • No additional hardware or software needed • Automated workflow management • Automated email notifications • Online payment collection • Better Information Tracking and Access • Increased Time Savings • Better Customer Service (no more office to office trips)
48. • Beacon™ Integration • GIS Integration and Interactive Mapping • Custom Workflows for Your Organization
49. Online Permitting
50. User Accounts Supported
51. Many Permit or Enforcement Types
52. Ability to Search Existing Data
53. Interfaces with Beacon
54. Customizable Workflows QR Code Integration
55. Interfaces with GIS
56. Pull downs and lookup tables
57. User Shopping Chart Supported
58. Online Payments
59. Automated Workflow Notifications
60. Office Task List / Dashboard
61. Reporting Tools
62. Complete Permit Design Customization Tools
63. Complete Workflow Customization Tools
64. Make the public happy! From: Lindon Curtis [mailto:sitrucnodnil@gmail.com] Sent: Tuesday, September 10, 2013 11:58 PM To: Deb Fall Subject: Re: certificate Thank you, Deborah, (or Deb, in the case that you hate 'Deborah' or 'Debbie') I've gone round and round with Vital Records in Indy. Leave it to the good people of Marshall County to actually care and have the wherewithal, the presence, and the sense of obligation to help a fellow Hoosier so quickly. Thank you, so much, for caring and with those attributes actually paying your community back with your service. You need a raise in wage. Just whom should I contact? Otherwise, I will write the newspaper with accolades! Thank you, again my dear! Sincerely, Lindon Jay Curtis
65. GIS Helping Assessors
66. Saving Time • What is the number one way to save time for Assessors? KEEPING PEOPLE OUT OF YOUR OFFICE • Let the public know what you have!!! – Press release in local newspaper – Locally hosted public seminars – Schneider hosted webinars • What are people coming into your office for? • What questions are you getting asked that they cannot find online?
67. GIS Visualization with CAMA Data • Directly link to your CAMA database in ArcGIS and create joins or views with the GIS parcel layer.
68. Assessor Maps – Map Abnormal Transactions – Sales – Neighborhood Mapping – Parcel Class Map – Median Sales Ratio Study – Missing Data Identification – Unique Parcel Study – Timeline of sales – Routing – Farmland Assessment – Deductions – Personal Property – Map change in the assessment of the taxpayer's property – Map Exempt Property – Assessment/Sales Ratio Studies
69. Sales Disclosers
70. Sales Disclosers
71. Neighborhood Mapping
72. Neighborhood Mapping
73. Median Sales Ratio Study
74. Missing Data Identification
75. Unique Parcel Study
76. Parcel Class Map
77. Timeline of Sales
78. Timeline of Sales by Class
79. Timeline of Sales by Month
80. Deductions
81. Assessment Differences
82. Sign Inventory Signs, Signs Everywhere a Sign…
83. 369,629 people died on America's roads between 2001 and 2009 Source: http://www.guardian.co.uk/news/datablog/interactive/2011/nov/22/us-road-accident-casualties Map Source: http://map.itoworld.com/road-casualties-usa# Problem: Nighttime = Fatalities The FHWA reports that although about one-quarter of all travel occurs at night, one-half of all fatalities occur during those hours. For every 100 vehicle miles traveled, fatalities are 2.75 times higher on rural roads than on other roads.
84. Nighttime = Fatalities • An FHWA-sponsored literature review and field study noted several motor vehicle models did not provide sufficient illumination toward mounted signs. • Currently about 80% of late model vehicles are factory- equipped with VOA (visually/optically aimed) headlamps that compromise sign performance. – 53% lower visibility on the right shoulder – 42% lower visibility on the left shoulder – 28% lower visibility overhead Source: http://www.minimumreflectivity.org/safetyconcerns.asp?pg=1
85. FHWA Requirements
86. FHWA Requirements Sign Maintenance Program • Plan for keeping signs up to standard. • How will you bring your current signs up to standard by the deadline? • How will you determine which signs to replace, and when, in the future?
87. FHWA Requirements Simplified! These signs probably need replaced: • Signs greater than 10 years old (probably not reflective enough) • Yellow signs with Engineering Grade Sheeting (not allowed) • Street Name signs with Engineering Grade white letters (not allowed) • Signs showing vandalism or environmental damage (non-compliance with MUTCD)
88. Most Common
89. Initial Compliance What is the condition of your signage program right now? • Do you have an inventory of sign types and locations? (GIS or not) • Do you know when your signs were installed? (sticker or inventory) • Do you have a retroreflectometer? • Do you have staff for visual inspection?
90. City of Franklin, IN • Sign modernization project for the City of Franklin started in October 2011 • Construction $530,000 budget • Sign inventory, which included over 4600 signs • The field crews noticed a very high concentration of signs throughout the city, especially parking signs and speed limit signs
91. City of Franklin, IN • 462 Speed Limit Signs • 915 Parking Signs • Twice as many signs per capita as neighboring community – Adding additional signs to curb complaints of speeding, while engineering studies have indicated this is not effective. Traffic calming methods, where appropriate, and police enforcement of posted speeds are much more effective.
92. City of Franklin, IN • We reviewed local ordinances and found them to be incomplete. • In addition, while most of the city is posted at 20 mph, that limit is not permitted by state law without the support of an engineering study. • When presented with this information, the city staff and the Board of Public Works and Safety agreed that the speed limit should be adjusted and superfluous signs eliminated as part of the modernization project. • The Schneider sign team worked with city staff to identify 215 speed limit signs (nearly half of the total) to remove. • This will save the city over $30,000 in materials and installation, • The Board of Public Works and Safety is expected to approve most or all of the speed limit sign removals as well as a speed limit change from 20 mph to 25 mph.
93. Long-Term Maintenance • Determine maintenance method to be used • Keep inventory up-to-date as signs are replaced • Plan and budget for future sign replacements (as damaged or when retroreflectivity fails)
94. Access
95. Americans with Disabilities Act "ADA“ Compliance needs for Local Government
96. Americans with Disabilities Act • Standards? • Mandates? • Suggestions? Civil Rights Law • Civil and political rights are a class of rights that protect individuals' freedom from unwarranted infringement by governments and private organizations, and ensure one's ability to participate in the civil and political life of the state without discrimination or repression. http://en.wikipedia.org/wiki/Civil_and_political_rights
97. Americans with Disabilities Act President George W Bush signed the ADA Bill into Law -July 26, 1990 The safeguards regarding discrimination against individuals with disabilities are under the same procedures applicable to race, color, sex, national origin and religious discrimination under the Civil Rights Acts of 1964 and 1991. Complaints against employers who violate the ADA should be filed with Equal Employment Opportunity Commission or the designated state human rights agencies. Source: National Center for Learning Disabilities
98. Source: • http://www.hhs.gov/
99. ADA Enforcement • The Department of Justice may file lawsuits in federal court to enforce the ADA, and courts may order compensatory damages and back pay to remedy discrimination if the Department prevails. Under title III, the Department of Justice may also obtain civil penalties of up to $55,000 for the first violation and $110,000 for any subsequent violation. • http://www.ada.gov/enforce.htm
101. Loss of Fed Funds • Title 49: Transportation § 27.125 Compliance procedure. – (a) General. If there is reasonable cause for the responsible Departmental official to believe that there is a failure to comply with any provision of this part that cannot be corrected by informal means, the responsible Departmental official may recommend suspension or termination of, or refusal to grant or to continue Federal financial assistance, or take any other steps authorized by law. Such other steps may include, but are not limited to:
102. Example Problem • Community being sued to fix and build ADA compliant sidewalks throughout the entire community • Estimate cost of repairs and new improvements was unknown
103. Community wide sidewalk inventory
104. What did they collect? • Evaluate sidewalk and curb ramps using the following criteria: – Difference in Elevation: A difference in elevation between square of ½” or greater. – Cracks: A crack that is ½” or more in width and 24” or more in length, or a crack that is ¾” or wider and any length. – Surface Spalling: Crumbling or chipping away of the surface of at least ¼ of the sidewalk square area and ½” deep. – Trees uprooting sidewalks. – Sidewalk and Curb Ramps not built to ADA Standards.
105. How ? • Ortho review of existing sidewalks • Added data layers to GPS units with forms • GPS unit and camera for collection • Field collection • GPS points collected of damaged areas • Attributes describing condition were entered • Photos were taken and linked to the GPS point • Information was reviewed and correction cost estimated and Transition Plan outlined
106. Sample Problems • Mailbox is in the sidewalk area – should be relocated.
107. Sample Problems The sidewalk pavement should be replaced.
108. Sample Problems There are no truncated dome warnings at the crosswalk (warning devices should be installed). Sidewalk is uneven, there are no compliant ramps – ramps should be installed – the sidewalk pavement should be replaced.
109. Judge’s opinion • http://indianalawblog.com/archives/2010/01/01/index.html
110. Sex Offenders • Purpose – Enforce Registered Sex Offenders Law better known as “Jacob Wetterling” “Megan's Law”
111. Problem • Offenders move often • Day Cares and Providers come and go • Prosecutors office give okay to live in a area without access to quality information • Sheriffs office has no method to know when an offender has moved to a location that violates the law
112. How? • Identifying all: • school property, not including property of an institution providing post-secondary education; • a youth program center; or • a public park; or • establishes a residence within (1000’) distance of the residence of the victim of the offender's sex offense
114. • Create buffers of (1000’) distance around property lines (not structure points) – This represents the areas the offenders are not eligible to live.
118. Offender Location • Additional step will be to geocode the offenders location on your map to clearly identify they are out of restricted area.
119. Return on Investment • “20” Offenders were served notice to relocate. • Safer community • Similar application can be used to identify drug offender locations
120. Since 1962, The Schneider Corporation has been providing creative solutions for land, infrastructure and facilities projects that help increase revenue, lower costs and mitigate risk and we can do the same for you. Please contact a business development manager for more information. Andrew Harrison, GISP aharrison@schneidercorp.com 317-690-1513 C ontact: Thank You