The URL can be used to link to this page

Home My WebLink AboutMINUTES - 06132006 - C.81 TO: BOARD OF SUPERVISORS >>=s -z-=� Contra FROM: JOHN CULLEN, County Administrator Costa DATE: JUNE 13, 2006 County SUBJECT: AUTHORIZATION TO SUBMIT ENTRIES TO THE CSAC 2006 CHALLENGE 'Q 1 AWARDS PROGRAM 0 t SPECIFIC REQUEST(S)OR RECOMMENDATION(S)&BACKGROUND AND JUSTIFICATION RECOMMENDATION: AUTHORIZE the Chair, Board of Supervisors, to submit applications to the California State Association of Counties for the 2006 Challenge Awards Program. FISCAL IMPACT: A $35.00 application fee is required for each of the 8 entries, totaling $280.00. BACKGROUND: The California State Association of Counties (CSAC) is sponsoring the CSAC Challenge Awards Program for 2006 and Contra Costa County wishes to participate in the program. The County will nominate the following innovative programs/projects for award consideration: • Independent Learning Skills (ILSP) Graduation Binder - Employment & Human Services Department • Way to go, Contra Costa! - Employment & Human Services Department • Bay Alarm Sponsorship of Sheriff's Academy - Office of the Sheriff • Automated Regional Information Exchange System (ARIES) - Office of the District Attorney • Contra Costa County Collision Geocoding Software - Community Development • Contra Costa County Census Geography Adjustment Project - Community Development • Disaster Response: Safety Assessment Program - Building Inspection • The Keep the Delta Clean Program - Public Works In submitting these applications, the County agrees to the Program requirements and responsibilities as set forth by CSAC for entering into the awards program. CONTINUED ON ATTACHMENT: OYES ❑NO SIGNATURE: ` ----- ---- -- --------------------- ------------------------------------------------------------ --- ------------------- ------------ -------------------- i/F2ECOMMENDATION OF COUNTY ADMINISTRATOR RECOMME DA ION OF BOARD COMMITTEE APPROVE OTHER SIGNATURE(S): ------------------------- ---- ----------------- ---------------------------------------------------------------------------------------------- ACTION OF BOA D ` APPROVE AS RECOMMENDED X _ OTHER J VOTE OF SUPERVISORS I HEREBY CERTIFY THAT THIS IS A TRUE AND CORRECT COPY OF AN ACTION TAKEN UNANIMOUS(ABSENT ) AND ENTERED ON THE MINUTES OF THE BOARD OF SUPERVISORS ON THE DATE AYES: NOES: SHOWN. ABSENT: ABSTAIN: ATTESTED: JUNE 13,2006 CONTACT: JULIE ENEA (925)335-1077 JOHN CULLEN,CLERK OF THE BOARD OF SUPERVISORS AND COUNTY ADMINISTRATOR CC: COUNTY ADMINISTRATOR COMMUNITY DEVELOPMENT BUILDING INSPECTION DEPARTMENT EMPLOYMENT&HUMAN SERVICES DEPARTMENT OFFICE OF THE SHERIFF DISTRICT ATTORNEY'S OFFICE BY 9; �EPUTY _ yE TO: BOARD OF SUPERVISORS � _' , ' t. Contra Costa FROM: JOHN CULLEN, County Administrator = ,�.;z �'•.- �� .'cam DATE: JUNE 13, 2006 ' County SUBJECT: AUTHORIZATION TO SUBMIT ENTRIES TO THE CSAC 2006 CHALLENGE 1 AWARDS PROGRAM 1 SPECIFIC REQUEST(S)OR RECOMMENDATION(S)Z BACKGROUND AND JUSTIGICATION RECOMMENDATION: AUTHORIZE the Chair, Boara of Supervisors, to submit applications to the California State Association of Counties for the 2006 Challenge Awards Program. FISCAL IMPACT: A $35.00 application fee is required for each of the 8 entries, totaling $280.00.. BACKGROUND: The California State Association of Counties (CSAC) is sponsoring the CSAC Challenge Awards Program for 2006 and Contra Costa County wishes to participate in the aroaram. • The County will nominate the following innovative programs/projects for award consideration: • Independent Learning Skills (ILSP) Graduation Binder - Employment & Human Services Department • Way to ao, Contra Costa! -Employment & Human Services Department • Bay Alarm Sponsorship of Sheriff's Academy-Office of the Sheriff • Automated Regional Information Exchange System (ARIES) - Office of the District Attorney • Contra Costa County Collision Geocoding Software- Community Development • Contra Costa County Census Geography Adjustment Project - Community Development • Disaster Response: Safety Assessment Program - Building Inspection • The Keep the Delta Clean Program - Public Works In submitting these applications, the County agrees to the Program requirements and responsibilities as se' forth by CSAC for entering into the awards program. CON-IN:iED ON ATTACHMENT: El:YEs ❑NO SIGNATUREr ;\ , C ' %'RECO."lMEfJD.4-'Or!OF COUNT.Y A,CF:1Ir!!STRi.TOR _RECOPJME�D.A'IION OF BOARD COMMITTEE ' _�AP�.RCVE _0-HER SIGNATURE(S): (.. , ACTON C•C BOAPD J APPROVE AS RECOMMENDED OTHER VOTE OF SUPERVISORS I HEREBY CERTIFY THAT THIS IS A TRUE AND CORRECT COPY OF AN ACTION TAKEN Ur:ANI1,40US(ABSENT ) AND ENTERED ON THE MINUTES OF THE BOARD OF SUPERVISORS ON THE DATE AYES NOES. SHOWN. .ABSENT: ABSTAIN ATTESTED: JUNE 13,2006 CONTACT: JULIE ENEA (925)335-1077 JOHN CULLEN,CLERK OF THE BOARD OF SUPERVISORS AND COUNTY S: ' 'At . 2= 006 Chall : e. nge A` Ward. s .:. ... .....: ... ...:.,. . Contra Costa County: . L::SP.: Graduatzon- . B.ind':er .... .. ... Wh .....:. ,-'. en I emancipate ;I.;.. ...; ':: got into.aaransitiorial..•.; :..: .,. :'housing.progtam:`.ButI :., I.:was.abke'to bu some:' : ,'.... nice:things•fot mydoim wasn t:gotrig:to get my first paycheck.,foT:another room and some vvtnter week. ILSP they said My roommates...; v t�` tthat they had.this binder have.parents they.can'. r ,fati"• ,��'- „,, �' . �'ti.. - +.. .�'<,:1:,.�•� .-.�:=��,: forme: It was cbol;.and counf on but.I dont'.I: '..t. a Teciate'what ILSP.and. w• the Safeway..gift card.: <.. ....:. :. pp . '..:. .- ,. saved me.,I:was able to. :'....:.:.... ::" the'.. eo•le froiim :..... . P P. ::.: buy`enough.food:un,til'I,. ;., '. d:" :....:::.: . m unt "contribute ;r of =La y paid:". .I. eesha'G: . I• f� •C' tl- 2 most Y. Th•eA- . 3;;r.:•:�:,;; �., �;� ;;.torpor '..:'::.�� ;.�_':�:;:_�� :;•� . '•'.�•.foT:.me was the ; Stnce:I`emancipated',I "CID. I did not. r u ,...:.. ..,,...,:..:;:.. se,my,e�utbnder:;eYery=::;,:,•, know 'w to:.,','..".;'+� da the calendar:to::'.: .... .: 'get:in tontacf, kee tract c?. ri 'work : :`.:,• with any:of my� :,:t . � ,;:s,;..�•.l. schedule;school schedule;,; ,:. •`'relatives::;The•.;�: ':=�:� ,"Y.:.. :.:. arld.OtheI a O1ntmCRtS .' :-09'' �'f t:! t' ::.: PP r CD,listea`all.my ,t. - ; .thatI have;.:...I feel very G_ *4 r' rofessional:::wYien':'I',have ,;:•..r:'<;.P,....,. ,.... One of my.old m dei-:1?recaiise.;'instead':'. ... ... . ..: .... .:....... ...:Y.:.. fosteT..parents;.'::", • :4� :� �:4:4;}.LKi._�,i Ili li, •.ti.: of.havtng.sttiff'unorgan- . ": .. ew ho ` to get:` ze. e:birideT:allows:me` �:�:;:•t�• kt � w � in contact wi to:sta ror antzed ::;;. ::, .::•= >.::.•.:':: .. . - .Y... ::g,....:.::. r" '` `.my Auntame :., -Ma c W. I� ;I .........: :t. r� ontact:'::: v nY v n ane Public InformationOf ficer'.::..... ...::: . .. : Contra&s'ta-coun •:::::-'.;:.:;L..::.::.'.',;::=' iiian SPi-vi�P �tment:';::. : .:.':....•';::.:' ;;: ' '.. . ��. 40. DouglasDrive'..; :lvlarttnez CA553 94 O Y-• Y : Phone:. -1 2 ) 313 5. 4 (925 .. lyaney@ehsd.cccounty.us.: .. .... _ . . . .. .. ... �' .. .,'..::......:..:'. . . . . . __:..:: C A C :.:. _ - , , .. :. .:, ._ .. 2006 1.Ch.al.len. a .Awards: . .:...:...: _. : . - . :•:': . �: r r;: ILSP;'Graduation Binder :. . . . .....:...:.. .. " .. . 1. ,.-... . .... . . .;. :.. :........ . - ,. ,.;. :. :.:.. - ..:r:.I:..%;-. 3. ;:;' iE'. .;y ` .. .. . .. .......... .:.: .. .. .. .. .. x .. ',k. t. . .. .. ... •...,,,,n ;_. .. ... . ,u,.,:.: ... z... 1 t i:�..i4''r . ..r: ,. . .._. c. s, _ .._.. ._ tti . _ '' ......:. . :... . ...........:... t. . .. .. :......... .. _:. ... .... ... ..,.:.... ... ... .. .. .. . .. ..... .... ... :::.' - - • .. . .. .. . . ... .. ..::.�. ... ..,. ... ..-.. ... ... t..w •. .. ....... . .. :Ol.VeIVICW: Grov�nng up in.foster:care; after,ha1... .been;abused.or neglected by.your family, is p..."..::.T-:... " to connect:with other people and form lasting"relationships can.lie frightening, and in some cases;nearly rripos .:... ...... .. :... .:...:.. -- Bibl% e::A'children, row.pj o;Leena ers in.oster.care,,a:wliole::new.set of challenges present:themselves.:.., .:.. : . g g1. ,., . .. . . ..... ....:. .. .:....:.. .. . . The..Contra Costa',County Indep..endent:Livin Skills Program (I P) is designed to help,:youth'Who are.in foster: :. ;.. . ...... M . ..care;pope.-wit. hand master.:day.=to,-day,living.tiurdles;and ge.t them ready to"emancipate' from the Child Welfare ., . 5 stem .::Hel ng.youtll connect:and STAY,connect. is,a top..priority:. . : .:`' Y P . . '. ......... :: .:..:: . .: ,. .,.. .1, The:l�t0 eEt Contra Costa.Coun has always tried to.keep:young people connected to our programs and . J : support'.systeins.• When.a former.foster youth'suggested that.a`resource guide;could be:valuable:for teens,leav- ... . .. . . .:. ili :foster care; she was asked;to work,with thdI)epartment Public:lnformation officer:to..design`a resource.'. g... i . . ... ..:.... . ....:.:........... . .. . : .. ..::::.:. ;:.'.:.::gu�de:..The "guide":quickly.tu: d into-a'binder:with bells.and.whistles. We were not`give,n a budget to.work' within we'were:asked.to let our imaginations go. . . ., :".. ' 1/Je:creafecl a resource guide,:`an,:18:.month°calendar and.:an address book (complete with advice.a moth`er.would. . . ... . . :z..::..::::.::::.:. ...:.:.''. ve;""Put:names �n':ink'and:addresses -n pencllr„):. => _ . '� ... % % . : . ....... ...... .. . . ::, . .. . ... . ... When a foster:child rea%ches the age of]8, he.or she is emancipated from the:system.;:The;sociai service :. . ,. .... .. . .... . % ...:':'.:.:::;:':::�de artnient:i5.:directed by.the:'courts to gyve.the.young persona folde% r with.all their original documents:`birth..:. ,', .. certificate social secizrit 'card;school:transcri ..ts;.any death.certificates of: arerts.or`sibli :... ...l.; . - gs; lists and.records,': .'. ?_ .. y .... . P ..... .: P . ..:. . .. . . ... :. .. .. ... ' :;<: .. _:;of:foste.r:ca e; :lacements and:court records::'.This::is essentially.the formal."end".:of care:and support for.these:...:: :':::.:::: : .- P . ......'. ..:.:..... ...:... . . ...... . ; .. .,;':::`..,:teeny ors ,.Ready;or no,4,--they are now'on their:own. _]3:ecause.a.folder full;of paper':documents:can be`easily:. ',: g .. _ .... .....,: .. -- lost.or;niined;'we.:decided:fo:scan.a11 tliese.:documents.making:PDFs; and ut theni`on a aSswota- rotected:`CD: :,..:;'' .. ...:': ,:.. P , P. .. ...P :: :-;�.:.We made.two.GDs;biie;.for'the. outh`s:binder and.one'to be kept vrith the social.worker.,',.:This vi i if:a'.youth Y, . ...::..:. ;:,:..::......:: .......... , <.'::is.out;of.:the:area.and:has:lost.the paperdo:cuments.or the CD, we can immediately eiri l.them the needed .docum We'decided.:that:the bindershould.contain :.......__. ...... .. '. . ._.... .....: _ . . . o rsome.;,�Tadu ion ts.' ..Cil ren,leavingecarriveNO. . . . . ... . . . .. .... a . . . . , `'::::: actin :financal assistariceZ. .....We were able,to:include.$100 ft cards.to.Old Na and'.to.Tar et, a.$150 gift card P.... g % ' ..... : ;.., a.,,. a 10 ift'card do Starbucks.'Tlie "Sty in touch with us?`.'theme was carried over to a calculator to Safeway: :_nd.:. ,.$: ..g "..' .y: . : ... : . ....,,.. '.::... ...:....,':. .:'.'.:.,...:... ..,,....:: ... . :;;rriiniflashli. ht,and:::en ach,im rinted.;witli.:ILSP's toll free.number.and the_ILSP..website URL;.:and included in..:: ,;..: . . g .: P. . P . -...:.. .:.. : .. ........ . .: ... . .. .. .. . . ...:. .. .' . :.:. .:- .. • .. . .. . . . ;:: ;. We:used existing photography of our former.foster.kids, and.for:continuity, We...adapted.the design.theme for the .::.: ..:. ..: . .. . printed m >.: ; p materials from our.ILSP website: www.cocoilsp:org:.We.mc uded photos:and advice provided by former . .. .... . . ;;::youth:;We wanted;a hi h. uali .binder that Would be"durable as.wen as appealing to teenagers.:We chose..... . .. . ..: q tY :. ... % .. g ....:v,.:.... ...•....:.... .. . ...... :..: . 1. :: a Franklin:.Covey product and added;a CD holder, business ca d%gift card.inserts.; zipper pouch and.photo holder. . .. .... :::,.:.: I. .. :.:.. :;::::............... . ....:: .. . . . . . . . .. How to: or tt.all? PQY.f. . . .: : , :'` ::'::'We..were 'going to.:graduate..2...0�..0..youth in 2005... ...And the.costs looked like.this: ....,: - - - -_ Binders::::: :.: ...... :. :::: ;.:....::,$ 7,600.:. .'. .: .. . ::. .. :. .. . :. : , . . ;:... : ;;;::;;:;;,Gra.hies house. ::::.:.: :::::.:..: : ::::::4,000.:::' ` , ::.; P -. ... . ;::.Priritin . `:::.::: :`..::.: ::::.:.:: :. :...10;000. ..:': ... . .. : . . . '; - •.. . . . . ..... .....::.. ::. .. .. . .. "::.:: 150:Safewa Gift..Cards;:::...::.::: ::30 000''. .'., : . . . .. ,. y! .... ....:..::. ;,:;.:`::: ;.::$I0O:O1d.Na .Gift Cards...;.:: ::.: 20;000 .: . :. :` ....:..:. . - .. .. `'Y . . . .... . ........::. _. . ..::.,.: $,._.-Target Gift,..Cards:::': .:c.::.: 20,000 .:. .$10.Starbuck's:Gift Cards...........!. ards::..::;:.. '.. 2:000:: . Total. ::'::': .... .. : : ..'.::. : 3 600`;:.: .. $`. 9 .::::..,.;. .:......: ....:.......:;...:... ... .... .:.. ,.. . . ..... . . ... ... . :.. :::::.....:. : : .:: .Our:.Director.went.to.several.foundations With a mock-up of the 20.05 ILSP.Graduation Binder and received an.,.;.: :. .......: .. , .. . ::enthusiastic recti tion:and immediate financial su ort;.:;The.organizations included Vodafone=US.Fouhdation,.: ;,.:: :. . Y:&:H Soda Foundation, and McKesson:Foundation:.. All. rganizations:and private.individuals:promised to ,,<.:... .. ...... .. . ....... .. . .•::::..;; ...,,..::.fi.nanciall. .su..:orthe. 606M binder. '. : :: - Y. PP . . .... ...... : . . .:. .;.::.. . ... . ;;;-:., Donations:totall.ed:,$61;500::::This.left..fhe Departmentwith.a manageab..le balance of$32,100, or.$160.50. er.. .":...,.:,.:....:. ... .:.. .... .... ..:.:::..:... .. ...:... ....... . .. . .. .. .. . .. . emancipating youth. :: .:.......:..:..: .. :.. . ;.:..: :.:: . ... :,. . ,..., ..:... ; : : . ... " ... :::: ... . . _: .:.::. .........: ReSUi6 News of this unique.binder.spread.rapidly to other social service departments around the state. .The. ..:.. . . .. ... .. ...... .:. ;;. : ,i;:.j."Contra'Costa,Times did a.front:page:story on the.project: Requests:for..c0 ies:of the bindercame to.us from most,. ,. .. -:..... .. .. ..... ..........::: . . .:........:....: :: of.the'counties:.ir Califoiriia;plus the:State Department of-Social Services. We received re. uests for.information ::a. , ....... 11 . . .. . ............: .;;and'co :ies:of the binder;from,.a encies::�n:Michi an .Ohio'.and.Alaska ''' P g g . .. .. -- .::.;. ::::.:.:.:.:. :. .: -::: .. .. . ._ ;':,,; :The,United.:.Way.of.the.Bay Area;asked us,to.present the binder,at::one of.their Executive,Board.,-meetin`s: :The ' . 4. . propose.to sponsor and.help'pay.for.binders.modeled after ours for allof.the.Bay.Area's:emancipating::foster . :.:;..:':'.; :. outh`:`:.Thi.s:.yeai;Unifed.Wa ..is s onsorm .a.binder for.San.Francisco.Count 's.emanci titin outh:..The have ;. y P .Y P.. -. gY:, ... .Y re quested that our De aitme ;:. ;., - . .q p nt's.PIO act as;consultant and quality.control for:the San Francisco binder;.and in... . ...:..:. :.:..:::.:..::returnwill:donate$10,000:to Contra.Costa Count _s 2006 binder:`:.> :.:......:.... ::: ::........ .. ....::...:::.:: . ::.:.... . .... .: .: .. . 1.: ...That:the.'communityrecogruzes,ihis project=as,worthy.of,supporting is very.gratifying:: But the.most important„`::`: :....: . thin .is that kids-who are leaving foster care and oin into a.world 0. where the must make their own” a- it ' .. . .. g... g..." .:.. .. ..;..g..:...:.. ... ... :..Y. ..:., . . . w. y w.:.l.,. .: now have a small resource to help them begin The reactions from our youth have been very rewarding: Some., .. . 11 I :. -.. have;cried:. Others,took the binder.a.nd added man: other.items.to further ersonaI-re it. :And their notes to us avent1.ou . ::: i cfii : : ... .. .., ........,: ... . ... .. ...... ... . The thin `I;liked best aabout receivin m b der.' the act that I of to know the`ILSP sta : ... ':I. ,.. The were ve nice and the .assuied me that t'he ILSP Center;: Here or ine;and the will be " : `. .. .. .. . :... Y r1' : Y . :;; :° here or me tqo: Knowin that I have eo le that l can.call:on is veiy im ortarit or`me. Bean on ., f.....:.. ... ... .... : . P .P P f ,:. ;:;: .c",.;. my,own has been.tough; but now I know there are people that`will Help support ine."• = Richard R C S A C 2006 Challenge, Awards wa� to 00., Contra co6t'q A GUIDE TO TRANSPORTATION RESOURCES IN CONTRA COSTA COUNTY n:•l•f. V 51 .i:;Pki CONTRA COSTA COUNTY Entry title: "Way to go, Contra Costa!" Paul Branson, Transportation Coordinator 40 Douglas Drive • Martinez, CA 94553 (925) 313-1702 pbranson@ehsd.cccounty.us C S A C 2006 Challenge Awards Ward to 5o, Contra Costa( A GUIDE TO TRANSPORTATION RESOURCES IN CONTRA COSTA COUNTY Overview: We created a single source senior transportation guide, designed to help residents easily find the transportation resources available to them anywhere in Contra Costa County. Problem: Our County has four major transit providers that operate in different regions and a rail carrier that connects some of the areas. As one of the counties with the fastest aging population in the state, transportation options are critical to our older adults. A recent Long Term Care Integration Project's study found "the transportation system for seniors and adults with disabilities in Contra Costa County to be very complex and frag- mented: We needed an information guide that would make the system easy to under- stand not only for seniorsgrrlz and those with disabilities, R C but for the entire population. Solution: We created _ L o� a guide that provided `' transportation information that crossed transit companies' boundaries and - 12 incorporated community } based transportation w "=' operators and I 5 r:Ju .' - -- w• paratransit companies. The information was organixed by community with links to broader transportation resources. This format makes it easy for the readers to find out what is available to them in their community and beyond. The guide provides contact information and areas of operation rather than price and schedule. This format enables the guide to be useful over time, through many schedule and fare changes. The guide also outlines requirements for a variety of community programs. i We created the guide in an informational format that can easily be duplicated by other agencies and communities. i 4 3 Access to an electronic version was put on the Aging&Adult Services website in English and Spanish. (htip://ehsd.org/ehs000.html) This project was funded with $25,000 in (one time only) Older.Americans Act funds. Research and data collection were provided by Aging&Adult Services staff. Layout, design and photography were provided by the Public Information Officer of the Employment & Human Services Department. We printed 27,000 copies in English and 5,000 in Spanish. Distribution was made by county staff, the Information &Assistance office, senior centers and senior housing locations. Results: As expected, the guide was enthusiastically received by seniors, people with disabilities and the community at large. We continue to receive praise and anecdotal evidence of the guide's value from seniors and the agencies that support them. We knew we were filling a gap by producing a comprehensive transportation guide for the county. We didn't expect the added bonus we are receiving by listing the community based transportation programs city by city. While the information is accurate and complete, some communities are only served by the local public transit operator. Since the publication of the guide, several cities have asked for assistance in setting up their own senior transportation programs. This guide allowed communities without community based programs to see the possibilities that they could create for their seniors. -- - . .-............. ...--- ....... ------------- Entry Form You may type this information on a separate sheet and submit as Page 1 of your entry: Contra Costa County CountyGes)Nameis) Community Development Department Hillary P. Heard, Senior Planner, Transportation Planning Division ... Contact Name and Title 651 Pine St., 4th Floor, North Win Mailing Address Martinez CA 94553 . City state Zip Code (925) 335-1278 Phone Ext. hhear@cd.cccounty.us Email Title of this en try(to be used on award-seven words maximum) =r Contra Costa County Collision Geocoding Software Remember to Yl7. T+1. t Include the following for each entry: a= Completed entry form - 2-Page executive summary . 2 .1:.: :u} Copy of endorsement letter authorizing entry.One letter may be used for multiple entries,but please include a copy for each entry. ?' , y ls:s Enclose payment of$35 for each entry. One check may be used for multiple entries. •r Checks should be made payable to:CSAC Challenge Awards. " Mail or deliver all of the above to: ® CSAC Challenge Awards c' ' 1100 K Street, Suite 101 Sacramen CA 95814 — t<• i ,y ..,+�•YdtS�..� RR°:•sn^`'eI.e-f Y. ^5 ±- w:ic:,.rT.}.r y,•.;.... - _ _ - - ,:,r..:..:--. ' i Prograw/Project Title: 2006 CSAC Challenge Award Program Contra Costa County Collision Geocoding Software Overview The "Contra Costa County Collision Geocoding Software" enables local governments to automate the mapping of collision records from the California Highway Patrol's(CHP) Statewide Integrated Traffic Records System(SWITRS)database. The Problem or Challenge The SWITRS is maintained by the CHP. It contains all automobile related collisions with pedestrians, bicycles, fixed objects and other automobiles. The data provides substantial information about each collision, age of individuals involved, location, date, time of day, etc. This is the best data source for collision information for local agencies such as Contra Costa County. However, the usefulness of the data is significantly hampered by the fact that the geographic location of each collision is stored in a proprietary or atypical format that is difficult and expensive to map. Contra Costa County has had to rely on commercial software packages that are expensive,require ongoing maintenance and produce data in a form that is difficult to share with all potential users. Until the CI-IP and more local law enforcement agencies begin using Geographic Position System(GPS)equipment in their collision reporting procedures, local agencies such as Contra Costa that want to map collision data will be forced to use cumbersome commercial software packages to translate collision records into a form that can be used by mapping software. As a result, our ability to evaluate spatial relationships in collision data has been limited and public policy making that reduces exposure to collisions has been hampered. Solution The "Contra Costa County Collision Geocoding Software" produces x/y coordinates for each collision record in the SWITRS database. This information does not exist in the native data supplied from CHP. The County's mapping software can then read these collision records and map their locations. The County's software has encouraged collaboration among Public Works, Community Development, and Health Services staffers to develop plans,projects and programs that can be more effective in reducing the public's exposure to collisions. The software outputs the data in a standard database format accessible to any potential user. Unlike commercial products which house the data in a"closed system",the Contra Costa County software enables the SWITRS records to be evaluated using a variety of software applications: • ArcGIS for mapping and spatial analysis • SAS/SPSS for statistical and epidemiological reporting • Crystal Reports for tabular reporting Development of the software has also showed the benefits of having law enforcement agencies use GPS equipment in the collision reporting procedures. . i Budget/Costs/Savings Implementation of the software should save staff and consultant costs over time. This will happen by way of elimination of duplicative efforts I and payments to consultants each time a user wishes to geocode SWITRS records.In Contra Costa County,three departments access the data for differentPSPoses.Health Services for epidemiological work,CommunityDevelopment for planning PSPoses and the Public Works De artment for road operations analysis. Rather than have three departments processing the data independently, the data is processed once and stored on a network drive accessible to any County agency. Software Development Costs and Staff Time: $10,325 Realized Cost Savings: At this point, studies have not been conducted to measure savings in staff time. Costs for these departments to obtain, license and use the proprietary software would be approximately$30,000. The County's geocoding software has not been available long enough to allow evaluation of cost savings due to the public's reduced exposure to collisions. The Collision Geocoding Software will make it more feasible and cost effective for local governments to utilize this valuable data for a variety of existing and future programs related to health, safety and transportation. For these reasons the Collision Processing Software warrants the California State Association of Counties Challenge Award. Results Data Availability: This publicly available software will make it less costly for local jurisdictions to geocode this valuable dataset. For Contra Costa jurisdictions that are members of the GIS coordination group the data can be made available across the County's network. Uniform Format: The software outputs the data in a standard database format that can be read by a variety of software packages. Unlike commercial products which house the data in a "closed system", the Contra Costa County software can be accessed by a variety of software applications: • ArcGIS for mapping and spatial analysis • SAS/SPSS for statistical and epidemiological reporting • Crystal Reports for tabular reporting Program Contact Hillary P.Heard, Senior Planner,Transportation Planning Division Community Development Department 651 Pine St.,4'h Floor,North Wing Martinez,CA 94553 (925)335-1278 hhear@cd.cccounty.us Submission Please see attached map. Page 2