HomeMy WebLinkAboutFW PRR re Code Enforcement Activities - Response to additional questions regarding software and spreadsheetsMia,
The BS&A program does have the capability of exporting to and excel spreadsheet. We are able to run a report of all code enforcement and export that into an excel spreadsheet (see attachment).
However to export all fields from the database into an excel spreadsheet as requested would require us to build that report, which we are capable of doing. This report would take approximately
2hrs to build and export, due to the system not already containing a report covering all fields.
We also need to keep in mind this is a new system and we are still in the process of populating all fields.
Thank you.
Sincerely,
Brian Palmer
Code Enforcement Officer
b.palmer@cityofcapecanaveral.org <mailto:b.palmer@cityofcapecanaveral.org>
phone (321) 868-1220 ext. 115
fax (321) 868-1247
100 Polk Avenue — P.O. Box 326
Cape Canaveral, FL 32920
www.cityofcapecanaveral.org <http://www.cityofcapecanaveral.org/>
The City of Cape Canaveral — Sun, Space & Sea®
Connect with us! Facebook <https://www.facebook.com/CityofCapeCanaveral/> + Instagram <https://www.instagram.com/cityofcapecanaveral/> + Twitter <https://twitter.com/capecanaveralfl>
+ YouTube <https://www.youtube.com/channel/UCL28gl1p_Hwru3agK9A1sMQ> + Nextdoor <https://nextdoor.com/agency-detail/fl/cape-canaveral/city-of-cape-canaveral/>
From: Patrick CFL [mailto:patrickcampbell@cfl.rr.com]
Sent: Thursday, February 6, 2020 8:23 AM
To: Mia Goforth <M.Goforth@cityofcapecanaveral.org>; Brian Palmer <B.Palmer@cityofcapecanaveral.org>; Todd Morley <T.Morley@cityofcapecanaveral.org>
Subject: Re: PRR re Code Enforcement Activities - Response to additional questions regarding software and spreadsheets
________________________________
Warning-This email originated outside the City of Cape Canaveral mail system. Please review the sender's address. Report any suspicious mail to John DeLeo or Sam Thorpe
________________________________
I would like a report. I have confirmed BS&A includes export functionality in their software including export to Excel. I am not asking for an exact duplication of what the city has
provided only asking for the export of all fields, delimited regardless of status for all code enforcement issues in now in your new software provided through BS&A. Thank you
Sent from my iPhone
On Feb 3, 2020, at 4:55 PM, Mia Goforth <M.Goforth@cityofcapecanaveral.org <mailto:M.Goforth@cityofcapecanaveral.org> > wrote:
Good afternoon Mr. Campbell,
Staff has completed investigating whether or not your request can be fulfilled for:
“the ability to see all records with the ability to assess performance. For instance grouped by violator, type, code reference, time lines between status changes. Will the new window
export the data? How do you assess performance?” …
related to your request on January 15, 2020 for:
1. As provided multiple times in the past, please provide an export, delimited and searchable, of all code enforcement cases, under review, open and closed. A copy of a previous response
is attached and I would like this PRR to be provided in the same format.
2. As provided in the past, please provide all Report a Concerns, delimited and searchable, that have been submitted to the city from 4/1/2019 to date. A copy of the previous response
is attached and I would like this PRR to be provided in the same format.
The City is no longer using the same software that it did in the past therefore we are no longer able to provide the records in the same exact format you request. As relayed to me
below by Community Development Staff, you have the following options:
1. Staff can run a report from the current BS&A System. However, it cannot produce the information in the same exact way as before; and/or
2. Use the online <https://www.cityofcapecanaveral.org/government/online_services.php> BS&A portal to search the properties yourself and create your own spreadsheet.
As referenced in the 2019 Government in the Sunshine Manual <http://www.myfloridalegal.com/sun.nsf/sunmanual> , page 158, under Request to create new records, answer questions about
the records, or reformat existing records - Chapter 119, F.S. provides a right of access to inspect and copy an agency’s existing public records; it does not mandate that an agency
create new records in order to accommodate a request for information from the agency.
Please contact me if you would like Mr. Palmer to provide you with a report or if you have additional questions.
Thank you
Mia
Mia Goforth
City Clerk/Records Custodian/ADA Coordinator
m.goforth@cityofcapecanaveral.org <mailto:m.goforth@cityofcapecanaveral.org>
phone (321) 868-1220 ext. 207
fax (321) 868-1248
100 Polk Avenue — P.O. Box 326
Cape Canaveral, FL 32920
www.cityofcapecanaveral.org <mailto:m.goforth@cityofcapecanaveral.org>
The City of Cape Canaveral — Sun, Space & Sea®
Connect with us! Facebook <https://www.facebook.com/CityofCapeCanaveral/> + Instagram <https://www.instagram.com/cityofcapecanaveral/> + Twitter <https://twitter.com/capecanaveralfl>
+ YouTube <https://www.youtube.com/channel/UCL28gl1p_Hwru3agK9A1sMQ> + Nextdoor <https://nextdoor.com/agency-detail/fl/cape-canaveral/city-of-cape-canaveral/>
From: Brian Palmer
Sent: Monday, February 3, 2020 4:06 PM
To: Mia Goforth <M.Goforth@cityofcapecanaveral.org <mailto:M.Goforth@cityofcapecanaveral.org> >
Cc: David Dickey <D.Dickey@cityofcapecanaveral.org <mailto:D.Dickey@cityofcapecanaveral.org> >
Subject: RE: PRR re Code Enforcement Activities
Mia,
I have attempted to recreate the Springbrook spreadsheet, which we have provided in the past, in the new BS&A system however BS&A will not create the same spreadsheet.
I am able to run a report however it is not in the format previously provided due to being a completely different system.
All this information is able to be found on line through BS&A and actually provides more information than the previous spreadsheet did.
Thank you.
Sincerely,
Brian Palmer
Code Enforcement Officer
b.palmer@cityofcapecanaveral.org <mailto:b.palmer@cityofcapecanaveral.org>
phone (321) 868-1220 ext. 115
fax (321) 868-1247
100 Polk Avenue — P.O. Box 326
Cape Canaveral, FL 32920
www.cityofcapecanaveral.org <http://www.cityofcapecanaveral.org/>
The City of Cape Canaveral — Sun, Space & Sea®
Connect with us! Facebook <https://www.facebook.com/CityofCapeCanaveral/> + Instagram <https://www.instagram.com/cityofcapecanaveral/> + Twitter <https://twitter.com/capecanaveralfl>
+ YouTube <https://www.youtube.com/channel/UCL28gl1p_Hwru3agK9A1sMQ> + Nextdoor <https://nextdoor.com/agency-detail/fl/cape-canaveral/city-of-cape-canaveral/>
From: Patrick CFL [mailto:patrickcampbell@cfl.rr.com]
Sent: Wednesday, January 22, 2020 5:09 PM
To: David Dickey <D.Dickey@cityofcapecanaveral.org <mailto:D.Dickey@cityofcapecanaveral.org> >
Subject: Re: PRR re Code Enforcement Activities - Acknowledgement
________________________________
Warning-This email originated outside the City of Cape Canaveral mail system. Please review the sender's address. Report any suspicious mail to John DeLeo or Sam Thorpe
________________________________
Thanks, but I want the ability to see all records with the ability to assess performance. For instance grouped by violator, type, code reference, time lines between status changes.
Will the new window export the data? How do you assess performance?
Sent from my iPhone
On Jan 22, 2020, at 4:06 PM, David Dickey <D.Dickey@cityofcapecanaveral.org <mailto:D.Dickey@cityofcapecanaveral.org> > wrote:
Good afternoon Mr. Campbell. This is in response to your PRR re: Code Enforcement Activities (below). City Staff no longer maintains a spreadsheet with the requested information. However,
all code enforcement cases that were available in the City’s previous software program (Springbrook) are searchable through the BS&A Online program. To access the information, go to
the home page of the City (www.cityofcapecanaveral.org <http://www.cityofcapecanaveral.org> ) and click on the “How Do I” tab which is located in the upper right corner of the page.
There, you will see the “View Code Enforcement Records” link. Press that and you will be taken to the BS&A Online page where you will find a link titled “All Record Search” in the top
left portion of the page. Click that and you can enter whatever address or addresses you wish to search.
If you have any problems with searching this information, please contact me and I will have someone assist you. Thanks. Dave
David Dickey
Community Development Director
d.dickey@cityofcapecanaveral.org <mailto:d.dickey@cityofcapecanaveral.org>
phone (321) 868-1220 ext. 118
fax (321) 868-1247
100 Polk Avenue — P.O. Box 326
Cape Canaveral, FL 32920
www.cityofcapecanaveral.org <http://www.cityofcapecanaveral.org/>
The City of Cape Canaveral — Sun, Space & Sea®
Connect with us! Facebook <https://www.facebook.com/CityofCapeCanaveral/> + Instagram <https://www.instagram.com/cityofcapecanaveral/> + Twitter <https://twitter.com/capecanaveralfl>
+ YouTube <https://www.youtube.com/channel/UCL28gl1p_Hwru3agK9A1sMQ> + Nextdoor <https://nextdoor.com/agency-detail/fl/cape-canaveral/city-of-cape-canaveral/>
Florida has a very broad public records law. As a result, any written communication created or received by the City of Cape Canaveral officials and employees will be made available
to the public and/or media upon request, unless otherwise exempt. Under Florida Law, email addresses are public records. If you do not want your email address released in response to
a public-records request, do not send electronic email to this entity. Instead, contact our office by phone or in writing
Florida has a very broad public records law. As a result, any written communication created or received by the City of Cape Canaveral officials and employees will be made available to
the public and/or media upon request, unless otherwise exempt. Under Florida Law, email addresses are public records. If you do not want your email address released in response to a
public-records request, do not send electronic email to this entity. Instead, contact our office by phone or in writing
Florida has a very broad public records law. As a result, any written communication created or received by the City of Cape Canaveral officials and employees will be made available to
the public and/or media upon request, unless otherwise exempt. Under Florida Law, email addresses are public records. If you do not want your email address released in response to a
public-records request, do not send electronic email to this entity. Instead, contact our office by phone or in writing
᭢죋Ც㠂䏂䂙�쉈⊉栁등㋞棳銁䝃爧�⮯�ᩈꍋ鬋ꊥ译賾◊꜔㋌暸弩哝坕钠늆䑄ᯅ僇뭲ᆹ祀〉렗�펹㯼㧌ѕဈୖࣀݬ叺퓤熻鶶힐⋱檇蔜瓼ᙢ폲ၱ㏲໑밁⪛䋚杽뢔읎껼牅倛Ⲉཌ弞볕篔ⶆ㷪衤蜚䑉恘㸈䙊雹녓◒ড়ᴷ끐귟穂괱塕䱔跏ᇒ쪷彳ຬ婈䕊Ꚑᓎ뇗뿐艇吏쾩仟쏐祫䫙젺�䌦ဎ㾱ꊝ翸縊㎈ഊ縉늑怶ﱥᛏ섖ᬿ彮�ꫨꠊ죦ﰲभ阹汹톝ۀ旇ᣒम≯ᨯ��뙄산ቺ៣ꤸ랚�牑ၓ牁蘷᳔䋮䖬蚂ደ擃䁉ט腮ꇇᗷ賓鑊
秜纯쥷䵀类䛉栫㍣狦ᯂ⧣◝괚햝ᱢ輇잙됡뇊⽛粗ﺶ屰砃쟏莳㎟爛ᴨꉵ鶍ᱛ健桖鉈械⿂ᦱ咟珟檫㚚ᬕ暫ᢥ暷㢈ꡪ퍉ꊣ⃮襆뗞䶜㒍청孫ￃ뤯홋⭸ሒⱄ왘韪犛딶탊锾짣쾆범펥痁脞�䁹먆跒Ꙋ罬ꤠᖬ倄ດ�汏炓閂女⺉挣猻譐⃭顉횲㦔뛐羔פּ똾빮풍ᬎ㑼㠤荱띏啶內菸⥲틭觿艨頸齂㤨汁ࣿ舆菽娠䱲ﳊ�鑌퐅녭滜渴孎ㅢ⍿▦많�驭곗裤돖䝕䊈❦⛊䇡ㅄ豱㐖좓ұ얝ꍎ鹽ꘛ唼꘥䌝금�릎ᢏ꽑訵疉䳿鴌ㅞ雜頥ꚵⷤ䔎
䪨ꕫ宕텱卭㛘浸ऽ�㫷㕩瘿产ΐ㕣㨂氿똦곖눂䧊社嫦䴩巌ꝷꖨ侷혂矞腓ﵭ◂�꯲мŎ닗퉎毞�뤒₆ꑕꭾ湽若衑࣓퇁鯊䒊竖ꀑ揧ꆌ딙宖稌⹗ᖤ⽯맒峬팛ү꧷퉕䍲䧍쭹饂뽹樵㩆�砌ⴥ췣봵嵻唷㭎⁶殗䝦㙍迖ܩ�䳴盜봝䵍裁⦆꓾缡㷗չՃ䦑⥊䤵钨釴멙陕鉋纜⯕걽줕㼾ఇ⬢쒋쵥풅甯풜絔쒘蹩㣭䮶魙袾箈굳泄齅푧찐⎴ﮏɊힲ⑼닭燛鮉矑똦㮌蒅タ谰┼犁釋퍋�젭纥ۢ륫ᲈ箕㔎醱䊃록捃芥紎袑緆�颺엄滬욠苕ၥ拇㋢⎻
࿐爜웝呭ኵ몭ೋ퐐滗뤕讧텥⮯鳁⨙됮聣쭘ꏺ헽֮큱虎ಟු燀㻢䳠앣鐕騃㴽㛁�㔐ạᐌ䦼뉜猪ᐪꡏ懟ܥ燻岬뢩礘癞➳拝ﴐຜ뤸Ή식魑걚땀콃얍귳渎굮뢬ꟙ燼뀝冂ߐ魠듋次㬵톉쩱钞낦䖡舐ᥩ㫵쩙䧅鬥ᔶ괈榣䃷�γ⦈錨囑安ꭃ�飵妞騈༕坋ᐖ衆꧵喂퐜¤叄툞✀๚첂ᛌ䚛곛芵拰쒲∰䚸蔺훧攺ᠦ츳依ꋠ�橂镫ꥎ뒾⧒蟔鯒돻磭冨ꛦƍᝎ嶌슅Ḫ톪의돓㌪щ뎿�即ቩ륝㩎Ⅷﭒ⿕庲쿔軁瘝쌎媘�懥鴏橢踖쐔�뾺␚㡷댈᪼䪠
ᇴ媮䓢敾ℳ鯬뻊㏯痃웺႑�ႋỖ㮊繐蠛衑結ጄ랕䆑慹䞔絣冓魢虪픡䋼�츅ʿ咜᭳暩戶㌍쵣䑪槊਼ᘼ棹涵뢆혽偤ꦪ좠嵮ॅ┟蓖챍巵馃镰Ψ㲈윣醝䵣㷏鹵灹쳏潍�弜䋻颅⿈颂宕訔뉮괦镐馊ᖪ寵鍕橫곲㗴숗恔툚⾭镵왢敓髼껒ⸯ鄀瑡嬹谿쐩쬜ஓ꾴뭞䶸䳝팤됑撬歖䢖ꄞૈ즿螺죯ᤏ沣ᯞ鍫៏驴榌⨱尿㣯疲昐쇚퀦繝瀰ᚻ얦ꏓ뼷緶쒝쐖鑪�肣艭ₚ쮀ꌷ쟪瀽囹幥艥ꜙ糯礧⋬噯奡쉻癸恽䄓��ṅ쬡휻蔣릾譋䲨诒쾼궤㇞潝㥽ﯾ샛
弔禁帜帟랩쩀䐁씿仁龞㭿ﹺ忽欀謩ജ攊摮瑳敲浡攍摮扯൪″‰扯൪㰼䘯汩整⽲汆瑡䑥捥摯⽥敌杮桴㈠㤰㸾瑳敲浡�쌀㰀얭俠벃豚賁풮刉ᦢꡞ늑ᓖꙚ攣▬굥搦⒭걥늑ᗕꝚ攥辬풱圏ᾢꡢ몑ዘꭩ猢꒰ꌻ䣚�䟶썔ꗭ뼿䷦㿴쉌䯨㻲썊㷦쉋䫧쑊䫥썋䳦쉋䫦썋㷥㓲쁁䋤쁂䏥뽂䋦滵퉸短퉷磬텸磭ంఀ竸ഴ攊摮瑳敲浡攍摮扯൪‴‰扯൪㰼䈯瑩偳牥潃灭湯湥⁴⼸潃潬卲慰散ㄠ‴‰⽒楆瑬牥䘯慬整敄潣敤䠯
楥桧⁴㘴䰯湥瑧㤳⼴畓瑢灹⽥浉条⽥祔数堯扏敪瑣圯摩桴ㄠ㜲㸶猾牴慥൭栊럚ɂᑁ円쑳ᖜ㨓討ㄘ懲俾栥㘥稖紐쬺옩睿ᨙ蠂硧ᑤ鰠耉♰ꚧ숁ᄁ乍쳍萂ꭒ﮹袀ᷦဂ苍ߝ摄Ƿ�䁽癈ဟ�萇ā緙䡀묵蠏ꅧ뢶츐䀚鬛浬ï厄�ࠃｧრ騠퇆䎱ꈀꑩ䧺䷎䂀콎뮒蠏瞨㗷掓숀�㥸矷ꭟ閩튥⼻鎘앒箵忷䟎ệ腹ｅ힙⼣踐ྻ⠈켥䂼륀耐籀闧볯ﮊ랝鯌膏尊ఖ阪뾾廳�뮃弯敊幷✰쪥ꝫ�ꗷ�ﯗ咃굲㦂唩统꯵篴秷‡ﮯ迴緙﮲緙﮲癉줾鏮⟝
緙﮲묤癏撟躀穔剳몪캇揭里뗥⩕랻㦂唩ꏽ怔挀ᡒ攊摮瑳敲浡攍摮扯൪‵‰扯൪㰼䈯瑩偳牥潃灭湯湥⁴⼸潃潬卲慰散㐠‱‰⽒楆瑬牥䐯呃敄潣敤䠯楥桧⁴〹䰯湥瑧㌴〹匯扵祴数䤯慭敧启灹⽥佘橢捥⽴楗瑤ㄳ㸹猾牴慥൭＊î䄎潤敢搀