Return
CITY COUNCIL WORK SESSION
TUESDAY, JUNE 13, 2023
CITY HALL COUNCIL CHAMBERS
211 WEST ASPEN
3:00 P.M.

 
MINUTES
             
1.
Call to Order

Mayor Daggett called the meeting of the Flagstaff City Council held June 13, 2023, to order at 3:01 p.m.

NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this work session, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).
             
2. Roll Call
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR DAGGETT
VICE MAYOR ASLAN
COUNCILMEMBER HARRIS
COUNCILMEMBER HOUSE
COUNCILMEMBER MATTHEWS
COUNCILMEMBER MCCARTHY
COUNCILMEMBER SWEET

ABSENT:









  Others present:  City Manager Greg Clifton; Deputy City Attorney Kevin Fincel
             
3. Pledge of Allegiance, Mission Statement, and Land Acknowledgment

The Council and audience recited the pledge of allegiance, Councilmember McCarthy read the Mission Statement of the City of Flagstaff, and Vice Mayor Aslan read the Land Acknowledgment.
MISSION STATEMENT
The mission of the City of Flagstaff is to protect and enhance the quality of life for all.
LAND ACKNOWLEDGMENT
The Flagstaff City Council humbly acknowledges the ancestral homelands of this area’s Indigenous nations and original stewards. These lands, still inhabited by Native descendants, border mountains sacred to Indigenous peoples. We honor them, their legacies, their traditions, and their continued contributions. We celebrate their past, present, and future generations who will forever know this place as home.
             
4. Public Participation

Public Participation enables the public to address the council about items that are not on the prepared agenda. Public Participation appears on the agenda twice, at the beginning and at the end of the work session. You may speak at one or the other, but not both. Anyone wishing to comment at the meeting is asked to fill out a speaker card and submit it to the recording clerk. When the item comes up on the agenda, your name will be called. You may address the Council up to three times throughout the meeting, including comments made during Public Participation. Please limit your remarks to three minutes per item to allow everyone to have an opportunity to speak. At the discretion of the Chair, ten or more persons present at the meeting and wishing to speak may appoint a representative who may have no more than fifteen minutes to speak.
  Nate Spangler, a FALA high school student, addressed Council regarding climate change and global warming. He stated that the recent decision to approve the specific plan for Northern Arizona Healthcare (NAH) shows that the Council has lost its commitment to action regarding climate change. He asked the Council to reconsider the decision and to protect the future of the youth by pushing towards the 2030 Net Zero goal.

Ynara Halbert, an upcoming junior in high school, also addressed Council about the carbon neutrality plan and how the NAH specific plan approval does not support the carbon neutrality plan.

John Edmonds addressed the Council regarding the pickleball decision and moving forward with the decision to build the courts. He shared a story of building a pickleball court at his home in Phoenix and stated that pickleball will continue to be played at Bushmaster even without the new courts. He stated that the Council will not regret building pickleball courts and that the courts would improve the park.

Nadine Hart, a member of the FHA Board, addressed the Council and spoke about the Section 8 housing vouchers and her issues with finding housing in Flagstaff. She stated that her home in Rio Homes was sold, and that Flagstaff needs to offer an incentive for property owners who do long-term rentals and tax property owners who do short-term rentals. She stated that a law must be added to ensure that Section 8 vouchers are considered as income.

Michael Ley addressed Council about the collection of data for pickleball. He stated that he and other members of the pickleball association conducted a survey on wait times for pickleball courts. He addressed the accusation of pickleball players not sharing courts well and the noise issues. He stated that the Council needs empirical data on the pickleball courts.

Steve Pulos also addressed Council about pickleball courts and stated that the intended spot would make an impressive pickleball court. He addressed Councilmember McCarthy and stated that he should recuse himself because he cannot be objective or fair, as demonstrated by his questions to the petitioner of the reconsideration of the pickleball courts at the last meeting.

Councilmember McCarthy stated that the idea that he needs to recuse himself is ridiculous and explained why he was concerned about noise at the location.

Natasha Thompson addressed Council and stated that she lives in Chandler and comes to Flagstaff to escape the heat. She mentioned that there were pickleball courts created at her HOA in Chandler and that there are no noise complaints. She spoke in support of creating pickleball courts at Bushmaster Park.

Irv Callahan addressed Council and expressed his disappointment in the Council's reconsideration of their decision to build pickleball courts. He spoke about how the courts will now be delayed and will cost more. He addressed some of the issues that the community members living around the park raised and stated that pickleball players in town have worked diligently with staff and the commissions to create the existing plan. He concluded by stating that Flagstaff needs pickleball courts.

Randy Schilling addressed Council and stated that he has been playing pickleball for years and that it is a great community. He urged the Council to move forward with creating new courts at Bushmaster Park.

James Crawford addressed Council and expressed his disappointment in the decision to reconsider the approval of pickleball courts at Bushmaster Park. He stated that there are a lot of untrue rumors circulating about pickleball, that the City is lagging behind other cities in providing this recreational activity, and that the pickleball association has collaborated with the Parks and Recreation Department on the creation of the courts. 

Jennifer Kottra addressed Council about the planning of the Parks and Recreation Department and the commission being stalled. She encouraged the Council to reach out to staff to access the data. She also spoke about the cost benefits of keeping the project at Bushmaster Park. She asked if the noise of pickleball is being exaggerated for an agenda.

Eileen Taggert addressed Council in favor of creating the pickleball courts but urged working with both sides to find a solution. She expressed her hope to keep pickleball free and accessible to all. She asked if there are any conditions that the other side would agree to for the pickleball courts.

Written comments were received via email from Joy Stephens, Barry Bertani, and Rachael Simukonda. 
             
5.
Review of Draft Agenda for the June 20, 2023 City Council Meeting
Citizens wishing to speak on agenda items not specifically called out by the City Council may submit a speaker card for their items of interest to the recording clerk.
  None. 
             
6. Proclamation: Juneteenth
  Councilmember House read the proclamation on behalf of the City and Ms. Jean Toner, Commission on Diversity Awareness Chairperson, accepted the proclamation on behalf of the commission.
 
Ms. Toner thanked Mayor, Vice Mayor, and Council for reading the proclamation and shared a few words about Juneteenth. She stated that she hopes the City will make Juneteenth an official city holiday, which will be a recommendation from the commission.
             
7. Proclamation: Waste & Recycling Workers Week
  Mayor Daggett stated that the staff showed immense resilience in handling the abrupt change in the recycling services and shared her gratitude to the team. She then read the proclamation.
 
Public Works Section Director Evan Tyrell thanked Council for the recognition.
             
8. Lone Tree Overpass Integrated Art Elements
 

Beautification, Arts, and Sciences Program Manager Jana Weldon presented to the Mayor, Vice Mayor, and Council on the potential integration of art elements into the Lone Tree Overpass project. She discussed the "three pillars of the public design process": artist selection, community input, funding and budget, and then focused on the integrated art elements.

Mayor Daggett thanked Ms. Weldon for the effort that went into collecting community feedback and for finding an artist.

Councilmember Sweet expressed her excitement about the project. She likened it to an art installation that could attract the community. She also extended her gratitude.

Councilmember McCarthy shared his enthusiasm for the project and appreciated the funding through the BBB tax. He suggested an edit to the bike wheel graphic within the integrated art elements, proposing that it should not feature gears along with the bike tire.

Councilmember House commended the thoughtfulness behind the project and found the engagement to be meaningful.

Councilmember Matthews echoed the sentiments that were expressed. She conveyed her excitement about the future of art in Flagstaff with this cohesive vision.

Vice Mayor Aslan remarked that the presentation was another success. He expressed his high anticipation for the project, highlighting its readiness for a post-car era. He believed the project would become an attraction.

             
9. Part 1- Streets and Parks Snow Operations Discussion
  Public Works Streets Section Director Sam Beckett, Parks, Recreation, Open Space, and Events Director Rebecca Sayers, and Recreation, Open Space, and Events Assistant Director Amy Hagin delivered a presentation to the Mayor, Vice Mayor, and Council regarding City Snow Operations for City streets. Mr. Beckett led the discussion on streets snow removal. The presentation covered the following topics:
 
  • Presentation Objectives
  • Streets Snowplow Fleet
  • Streets Staffing: Mr. Beckett mentioned that throughout most of the snow season, Streets had 22 staff members instead of 32.
  • Snow Shifts – Equipment & Staffing: Mr. Beckett stated that winter staffing averaged nine snowplows and three motor graders. He highlighted that overall staffing was a challenge.
  • Snow Response Policy
  • Streets – Snow Plowing Priorities: Mr. Beckett shared that the snow operations routes covered more area than recommended by a 2018 study. He also noted that snow operations are designed for right turns, aiming to keep snowplow drivers on route consistently.
  • Parks Snow Equipment & Staffing: Ms. Hagin discussed Parks Snow Equipment and staffing, mentioning a 30 to 45 percent vacancy rate during winter.
  • Parks Snow Shift Staffing
  • Parks Responsibilities
  • Streets Responsibilities
  • Day Time Snow Deviations
  • Post Event
  • Financial Impacts
  • Streets Strategic Vision and Goals
 
Councilmember McCarthy expressed the need for more resources for snow removal. He cited the 36-hour plowing window for snow events exceeding 12 inches as problematic and emphasized the significant issue of snow berms. He inquired about the possibility of the City acquiring a device to reduce ice berm buildup. Mr. Beckett explained that the City did not possess such a device and that research was ongoing. He mentioned CAT Empire as the sole vendor, with certain limitations regarding its use including communities that have an average of six inches or less and do not have a lot of moisture buildup in the snow. Mr. Beckett stated that the tool is not recommended in the community. Mr. Beckett stated that staff had reached out to other communities and cannot find any that have the same conditions as Flagstaff and use the tool. He added that it would take longer for staff to plow the streets and that the tool would not be recommended on storms over six inches. Councilmember McCarthy proposed that the tool could be tested, considering the effort residents invest in removing snow berms. 
 
Mayor Daggett revealed her investigation into the tool mentioned by Councilmember McCarthy. She reported mixed outcomes from communities that tried them. She acknowledged the berm issue and questioned the Streets department's current vacancies. Mr. Beckett stated that they are staffed at 22 out of 32 positions and that they had more vacancies during the winter. She asked if the possession of a CDL is a roadblock in recruiting staff. Mr. Beckett clarified staffing levels and mentioned challenges related to Commercial Driver's Licenses (CDLs) and their competitive demand in the job market.

Mayor Daggett inquired if any new positions were added. Mr. Beckett stated that they were able to fund two street light technicians through the SLEDS (dark-sky LED installation) funding for four years and they are working on securing funding for those positions for the future because of the change in HURF funding. Mr. Beckett credited Public Works Supervisor Steven Hill with the changing of the lights.

Mayor Daggett also inquired about parking enforcement during the winter hours. Mr. Beckett stated that their partnership with the Police Department has been terrific, and they were able to really help in the downtown areas that year. He added that the daytime snow operations are the real challenge and many streets need to be skipped due to traffic on the roads during daytime operations. Mayor Daggett asked if staff is utilizing ParkFlag and Mr. Beckett explained that ParkFlag works in downtown and the Southside areas but they do not have any enforcement outside of those areas.
 
Councilmember Harris raised concerns about parking and enforcement, especially in regard to streets being blocked during an emergency situation. Mr. Beckett detailed coordination with first responders, dispatch communication, and towing processes for car removal and enforcement. Councilmember Harris asked if there is a contract with towing agencies to remove parked cars. Mr. Beckett stated that there are hundreds of vehicles every snow incident and enforcement is through the Police Department which calls the towing company. He added that the Streets department can call the police to initiate the towing process.

Councilmember Harris asked what the City does with landlords when there is not enough parking at their property and if there is any penalty for having their tenants park illegally in the street. Mr. Beckett agreed to follow up on issues involving landlords and tenant parking violations.
 
Councilmember Sweet shared her experience from winter ride-alongs and mentioned the street sweeper status. Mr. Beckett confirmed that only one out of five sweepers was operational, with efforts to repair them ongoing. He anticipated the delivery of a demo street sweeper in June and the budgeting of a new one for the upcoming fiscal year.
             
10. Bicycle and Pedestrian (Multi-Modal) Snow Operations
  Parks, Recreation, Open Space, and Events Assistant Director Amy Hagin delivered a presentation to the Mayor, Vice Mayor, and Council on the PROSE and Multi-Modal snow operations. The presentation included the following slides:
 
  • Overview of presentation
  • The Shift
  • Future Growth with the Community
 
Councilmember McCarthy inquired about the plowing of gravel or aggregate paths. Ms. Hagin clarified that those paths are not plowed.
 
  • Undefined expectations
 
Mayor Daggett highlighted the need to establish and clearly communicate defined expectations for snow removal to the public.
 
  • Courtesy Berm Relocation Program: Ms. Hagin noted an increase in the program. She mentioned the necessity of resource allocation for the program in light of anticipated growth.   

Councilmember McCarthy asked Ms. Hagin about the tool used to remove snow berms. Ms. Hagin explained that it is similar to a bobcat with attachable tools, capable of traveling around 22 MPH. While a blade is sometimes used, shovels are also employed. However, snow throwers are not suitable for the program, but they are used on the Flagstaff Urban Trail System (FUTS).
 
Mayor Daggett expressed admiration for the Geographic Information System (GIS) program employed in snow removal management. She proposed the idea of an app for residents to report problem areas. She also recommended strengthening a volunteer program and noted efforts by the Sustainability Division to enhance the Snow Angel program.
 
  • FUTS – Multi-Modal Trails and Sidewalks

Councilmember McCarthy inquired about the level of usage the FUTS trails receive during the winter. Ms. Hagin replied that data from trail counters at a small number of trails indicated approximately 300 daily usages at Buffalo Park.

Councilmember Sweet shared her experience of observing snowshoeing and cross-country skiing on the FUTS trails during a ride-along in Ponderosa Trails.

 
  • Impacts and Resources
  • Peer Review and Best Practices
 
Councilmember Sweet expressed keen interest in having real-time updates available for people using the trails for travel. Ms. Hagin mentioned that a portal was created to track the courtesy berm program effectively. She indicated staff's willingness to develop a program for real-time snow removal updates.
 
Councilmember Matthews concurred with Councilmember Sweet's perspective on recreational access to FUTS trails. She expressed a desire for a real-time map showing the locations of plow trucks. Mr. Beckett noted the introduction of technology in the Streets department and collaboration with Fleet for that purpose. He aimed to implement a live dashboard and confirmed ongoing efforts. Councilmember Matthews revealed her collaboration with Coconino Community College to establish a program for CDL licenses, potentially offering them for free based on financial need.
 
Vice Mayor Aslan questioned the idea of a public interface. He acknowledged its potential value but considered it somewhat ambitious. He recommended pilot testing first, as a full-scale implementation might lead to initial frustrations. He emphasized the importance of supporting the program if it is developed. He advised caution, believing the program might become more complex than initially anticipated.

Councilmember Matthews emphasized the necessity of prioritizing staff and equipment to meet snow removal requirements.

Mayor Daggett inquired about the role of emergency management in snow operations. Public Works Director Scott Overton mentioned his involvement in the Incident Management Team, particularly for larger snow incidents, highlighting the connection between snow operations and emergency management. 

  • Next Steps
 
Public Comment:

Sam Meier addressed the Mayor and Council, expressing her desire to be able to navigate during the winter. She noted that the issue is related to equity and inclusion. She emphasized the significant number of berms, which increases the likelihood of accidents.

Adam Shimoni, representing the Flagstaff Biking Organization, highlighted that Flagstaff residents ride bicycles year-round. He stressed the importance of encouraging biking through separated bicycle lanes and maintaining existing bike lanes. He differentiated between biking as a necessity versus recreation on the FUTS trails.

Shawn Cheshire introduced herself and her reliance on her guide dog for mobility. She urged the Council to consider individuals like her when planning snow removal, as her independence relies on accessible pathways.

Mayor Daggett asked Ms. Cheshire about her top frustrations during winter. Ms. Cheshire mentioned frustrations related not only to snow but also to construction and obstacles hindering safe sidewalk navigation. She emphasized working with Jeff Bauman in Traffic Engineering to find solutions. The lack of accessible sidewalks posed the most significant frustration, given her reliance on them.

Councilmember Harris acknowledged the excellence of staff while highlighting the need for equitable snow removal, even in neighborhoods where parked cars might pose challenges. She emphasized the importance of promptly removing parked cars and how the issue impacted neighborhoods like Bow and Arrow and Dupont Street.

Councilmember Matthews attributed some issues to parking reduction requirements and called for collaboration between Streets and Code Enforcement to address the problems. She proposed augmenting code enforcement and allocating more budget to snow removal. 

Vice Mayor Aslan stressed the significance of getting snow removal right for non-vehicle transportation users. He emphasized the importance of not incentivizing parking. He expressed that the conversation is about the Big Shift and that people need to check expectations on having everything perfect immediately. He added that the City needs to ensure that people can travel without cars.

Councilmember McCarthy raised the issue of snow-impeded roads due to parked cars, suggesting towing a few cars to spread awareness. He also linked this issue to carbon neutrality efforts, encouraging walking, biking, and bus use.

Deputy City Attorney Kevin Fincel mentioned reviewing the traffic code with the Police Department and Senior Assistant City Attorney Marianne Sullivan to facilitate easier towing. Councilmember McCarthy suggested notifying car owners before towing.

Deputy Police Chief Scott Mansfield explained the current Police Department approach of issuing warnings before ticketing, mainly from midnight to 7:00 a.m. He highlighted the challenge of daytime snow operations occurring during legal parking hours. He mentioned public relations announcements and social media campaigns but noted limitations in enforcement, primarily downtown.

Councilmember Harris appreciated Deputy City Attorney Fincel's involvement and reiterated the equity aspect of snow removal.

Vice Mayor Aslan emphasized the equity issue's importance and the potential to induce demand for more parking if additional parking is provided. He underscored the need for enforcement and the availability of multi-modal options.

Mayor Daggett praised staff's efforts and recognized the community-wide issue. She stressed the need for collaboration to clear sidewalks and prevent parked cars from hindering snow removal. She highlighted the broader perspective on infrastructure during snow removal.

Mayor Daggett called a 15-minute break at 6:36 p.m. The meeting resumed at 6:52 p.m.

             
11. Update and Discussion on Building and Property Care Ordinance and associated Code Amendments
  Community Development Director Dan Folke addressed the Mayor, Vice Mayor, and Council to discuss direction on changes to the building and property care ordinance, along with associated code amendments. His presentation covered several recommendations from a work group responsible for reviewing property care standards, and the presentation included slides on:
 
  • Outline
  • Ordinance and Amendment Project Team
  • Why consider property standards now?
  • What is a Property Maintenance Ordinance?
  • Considerations
  • 2022 Survey Results – Issues
  • Survey Results – Primary concerns
  • Selected Approach
  • Division 7-06 Building and Property Care Standards
  • 7-06-001-004 Definitions
 
Councilmember McCarthy suggested that posting a "no trespassing" sign on the property should be optional rather than necessary, as the sign could be disregarded. However, he emphasized that securing the property should be mandatory.
 
  • 7-06-001-0005 Property Care Standards
 
Mr. Folke discussed the current code's provision stating that abandoned buildings can be secured indefinitely. He raised the question of how long the property should remain secured before it must be repaired, inviting Council discussion.
 
  • 7-06-001-0006 Exemptions
  • Title 7 Health & Sanitation – Chapter 7-11 Littering
 
City Manager Clifton addressed exemptions, mentioning the potential suspension of enforcement for natural disasters at the City's discretion. He referred to a partially burned building on Fourth Street, inquiring about its status under proposed regulations. He asked for clarity on the process for dealing with such a building. Mr. Folke discussed the reasonable time frame for addressing specific circumstances, stating that securing a burned building would take more than 30 days, but leaving it alone for five years is excessive. He explained the exemption considerations, particularly for events like flooding and fires affecting a broader area. He also referred to the nuisances section of the code and its potential use for building removal.

Deputy City Attorney Kevin Fincel added that there is a separate code for abating dangerous buildings, which would be more appropriate in such cases.
 
Councilmember Harris sought clarification on the process for nuisance complaints. Mr. Folke explained that the Council or three citizens could initiate the process by raising the issue for agenda discussion.
 
Councilmember Matthews questioned if the proposed changes would affect NAU's property on Milton Road. Mr. Fincel clarified that the City's property code would not impact NAU's property since it is on state land.
 
  • Next Steps

Councilmember House appreciated the focus on property maintenance and resources, suggesting it should be seen as a care standard rather than an ordinance. She recommended presenting the proposal to select commissions, such as the Housing Commission.

Vice Mayor Aslan expressed readiness to adopt Mr. Folke's recommendations but inquired about the distinction between compliance and enforcement. He questioned the City's enforcement capabilities and the point of codification without effective enforcement. Mr. Folke discussed the compliance-oriented approach of Code Compliance Manager Reggie Eccleston, emphasizing cooperation with constituents and encouraging compliance before resorting to penalties. Vice Mayor Aslan proposed using Council's powers to enhance enforcement and encouraged the public to report problematic properties.

Councilmember Harris addressed the time frame for compliance and suggested setting up a system to help property owners access resources. Mr. Folke mentioned the availability of groups that can offer assistance and resources, especially in cases of hoarding.

Councilmember McCarthy supported Mr. Eccleston's approach but highlighted the need to move towards enforcement when necessary. He cited specific instances where enforcement is needed, while cautioning against excessive enforcement for minor issues.


Deputy City Attorney Kevin Fincel relayed Mr. Eccleston's success with his approach, noting it works around 99% of the time. He recommended letting Mr. Folke's process conclude before legal tweaks to the language. He explained that the nuisance property ordinance dates back to 1936, accounting for some outdated language.

Mayor Daggett suggested involving the Commission on Inclusion and Adaptive Living in the presentation.

Mr. Folke clarified that encouraging change through public engagement aligns with Community Development's approach, beyond just Mr. Eccleston's actions.

             
12. Public Participation
  None. 
             
13. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests
 

Councilmember Matthews expressed her enthusiasm for attending the Southside Community Association's Juneteenth event and Police Appreciation Day. She mentioned her meetings with Sustainability and APS and highlighted an article she received about forest health and carbon emissions mitigation.

Councilmember Harris provided a brief history lesson on Juneteenth and noted that the celebration has been ongoing for about 60 years. She thanked PROSE for assisting the association in obtaining permits for the streets near South Beaver School. She invited the public to join the Juneteenth event at South Beaver School on Saturday, June 17, 2023, from 10 a.m. to 4 p.m.

Vice Mayor Aslan reported that he was in Albuquerque representing the City of Flagstaff at the American Astronomical Society Conference focusing on Dark Skies.

Councilmember McCarthy asked Housing staff to follow up on the Section 8 public comment made earlier during the meeting.

Councilmember Sweet shared her recent visit to Red Gap Ranch with Water Services Manager Erin Young for a tour. She mentioned the Flagstaff Police Department's appreciation day at the police station scheduled for June 14, 2023, from 8 a.m. to 10 a.m., during which she plans to make cinnamon apple rolls.

Councilmember House proposed a FAIR item, suggesting the designation of Juneteenth as an official holiday for the City of Flagstaff. She explained that both the Commission on Diversity Awareness and the Indigenous Commission have recommended the holiday.

Mayor Daggett informed the Council about upcoming events: a Downtown Mile public meeting on June 14, 2023, at 5:30 p.m., the Pollinator Fest on Sunday, June 18, 2023, from 10 a.m. to 2 p.m. at the Arboretum, and her participation in a podcast on Systems Change Grant with the Coconino Coalition for Children & Youth. She also mentioned her visit to Fire Station 3 and a meeting with Arizona Treasurer Kimberly Yee as well as discussions with The Guidance Center staff about the services they offer. 

             
14. Adjournment

The Work Session of the Flagstaff City Council held June 13, 2023, adjourned at 7:51 p.m.
 
                  
___________________________________
MAYOR
  ATTEST:

 
 
  _________________________________
CITY CLERK
 

    

Level double AA conformance,
                W3C WAI Web Content Accessibility Guidelines 2.0

AgendaQuick ©2005 - 2024 Destiny Software Inc. All Rights Reserved.


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /agenda_publish.cfm
Time Stamp 05-May-24 04:59 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
219 ms 219 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/Application.cfm
16 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
235 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 04:59:36.036
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 04:59:36.036
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 04:59:36.036
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 04:59:36.036
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkSite (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 04:59:36.036
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 04:59:36.036
	SELECT misc_alpha6 subscribe_tab, misc_alpha7 officials_tab, misc_alpha8 ordinance_tab, misc_alpha9 resolution_tab, misc_alpha11 voting_tab, misc_alpha12 useTabs
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup2'
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 04:59:36.036
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
		FROM meeting_type mt
		LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
		WHERE mt.show_public = 'Y'
			
		ORDER BY mt.descr
	
useNotify (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
	
chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
	SELECT c.*,
	 	c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab,
	 	c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab,
	 	c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type,
 		c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord,
 		c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr
 	from codes c
    LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3')
	WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
MeetingInfo (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
		select valid_code
		from codes
		where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
	SELECT user_filedir_alias, min_dir_alias, use_minutes, use_agendaquick,
		srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
	FROM fasinfo
getFasInfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
	select fasinfo.*,
	       c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
	       c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
	select text_value1, misc_alpha public_window, loc_code allowExtNotes
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'
begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE form_id = 'AGENDA'
end_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
	SELECT MAX(fis_yr) fis_yr
	FROM fas
	WHERE form_id = 'AGENDA' AND final_apprvl = 'Y'
begin_collection (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=32ms, Records=16) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:59:36.036
		SELECT m.meeting_dt, m.meeting_name, m.meeting_id, a.form_num as ag_form_num,
			minutes.minutes_published, a.agenda_published,
			a.minutes_doc_name, a.minutes_doc_link,	a.default_doc_dir,
			minutes.default_doc_dir minutes_default_doc_dir,
			a.packet_doc_name, a.packet_published,
			minutes.form_num as min_form_num, minutes.minutes_packet_published,
			minutes.minutes_packet_name,
			ag_links.link_label as ag_link_label, ag_links.link_url as ag_link_url,
			min_links.link_label as min_link_label, min_links.link_url as min_link_url,
			 rel.large_misc_alpha as release_date, agt.meeting_type
		FROM meetings AS m
		INNER JOIN agenda AS a ON ( 
			a.meeting_id = m.meeting_id AND
			(a.agenda_published = 'Y' OR a.packet_published = 'Y')
		)
		LEFT OUTER JOIN minutes ON (
			minutes.meeting_id = m.meeting_id AND
			(minutes.minutes_published = 'Y' OR minutes.minutes_packet_published = 'Y')
		)
		INNER JOIN ag_template AS agt ON (agt.ag_template_id = m.template_id
		
			AND agt.meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS')
		
		)
		LEFT OUTER JOIN codes as rel ON (rel.code_type = 'AddlMtg' AND CAST(rel.valid_code AS INT) = m.meeting_id)
		
		LEFT OUTER JOIN form_links AS ag_links ON (
			ag_links.form_id  = 'AGENDA' AND
			ag_links.form_num = a.form_num AND
			ag_links.link_seq = 1
		)
		LEFT OUTER JOIN form_links AS min_links ON (
			min_links.form_id  = 'MINUTES' AND
			min_links.form_num = minutes.form_num AND
			min_links.rev_num  = minutes.rev_num AND
			min_links.link_seq = 1
		)
		WHERE m.meeting_dt >= ?

		  AND m.meeting_dt <= ?

		ORDER BY m.meeting_dt DESC, m.meeting_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2023-06-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2023-06-30 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 04:59:36.036
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=63ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
SELECT fas.form_num fas_form_num, fas.action_cd fas_action_cd, fas.current_stop fas_current_stop, fas.routing_apprvl fas_routing_apprvl,
	   fas.final_apprvl fas_final_apprvl, fas.final_print fas_final_print, fas.fis_yr fas_fis_yr, fas.date_final, fas.final_prt_date,
	   ft.* ,
	   m.meeting_name, m.meeting_dt, m.meeting_fromthru_time, m.meeting_id, m.meeting_loc,
	   agt.ag_template_name, agt.ag_template_id,
	   codes.long_descr px_size, codes.descr pdf_format, 
	   mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type,
 	   agt.pdf_header, agt.pdf_footer, ct.descr vote_width, crt.descr roll_format, crt.long_descr roll_px_size,
	   am.long_descr vote_label, am.misc_alpha3 att_print_nametitle,
	   am.misc_alpha4 att_print_format, am.loc_code att_title_place, am.large_misc_alpha roll_title_place
FROM minutes ft
INNER JOIN fas ON (fas.form_id = 'MINUTES' AND fas.form_num = ft.form_num AND fas.rev_num = ft.rev_num)
INNER JOIN form_hist ON (UPPER(form_hist.form_id) = fas.form_id AND
			UPPER(form_hist.stat_action) = 'ADD' AND
			form_hist.form_num = fas.form_num)
INNER JOIN meetings AS m ON (m.meeting_id = ft.meeting_id)
LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = ft.ag_template_id)
LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = ft.text_size)
LEFT OUTER JOIN codes crt ON (crt.code_type = 'AG_FONT' and crt.valid_code = ft.roll_text_size)
LEFT OUTER JOIN codes cv ON (cv.code_type = 'AG_JUST' and cv.valid_code = ft.vote_disp_position)
LEFT OUTER JOIN codes cr ON (cr.code_type = 'AG_JUST' and cr.valid_code = ft.roll_disp_position)
LEFT OUTER JOIN codes ct ON (ct.code_type = 'VOTE_WIDTH' and ct.valid_code = ft.vote_disp_width)
LEFT OUTER JOIN codes am ON (am.code_type = 'MinAddl' and
	am.valid_code = CAST(ft.meeting_id as varchar))
LEFT OUTER JOIN codes amm ON (amm.code_type = 'AddlMtgMin' and
	amm.valid_code = CAST(ft.meeting_id as varchar))
WHERE ft.meeting_id = 3745 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 04:59:36.036
		SELECT 'Alpha','Alpha','Alpha','Alpha', min.ag_punct
		FROM meetings, minutes min
		WHERE meetings.meeting_id = ? AND
		      min.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3745

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 04:59:36.036
			select c.misc_alpha mHead_pad, c.misc_alpha2 mBody_pad, c.misc_alpha3 mPresent_pad, c.misc_alpha4 mAbsent_pad,
				   c.misc_alpha5 mStaff_pad, c.misc_alpha6 mOthers_pad, c.misc_alpha7 mAGtext_pad,
				   c.misc_alpha8 mMintext_pad, c.misc_alpha9 mMotion_pad, c.misc_alpha10 mVote_pad,
				   c.misc_alpha11 mRollSection_pad
			from codes c
			where c.code_type = ? and
			     c.valid_code = CAST(3745 as varchar)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = MinPad

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3744 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=16) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
SELECT ml._rowid ln_rowid, ml.ln_rowid ml_rowid, ml.form_num, ml.rev_num, ml.seq_num,
	   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.header_ln, ml.footer_ln, ml.left_justify, ml.page_br,		
	   c.descr as status_desc,
	   
	   
	   ai.*,
	   
	   am.ag_item_rowid,
	   
	   CASE WHEN ml.header_ln = 'Y' THEN 1	
	   		WHEN ml.footer_ln = 'Y' THEN 3
	   		ELSE 2 END AS line_sort,
	   as1.sort_seq sort_level1,
	   CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,	
	   CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
	   CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,	
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo,
	   
	   ml.ag_size, ml.ag_underline, ml.ag_bold, ml.ag_center, ml.ag_italic, ml.disp_level,
	   am.allow_comment, ml.ainumber min_ainumber, ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, ml.ag_title ag_heading,
	   ml.header_ln, ml.footer_ln, ml.left_justify,		
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time,
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_title ELSE '' END as ag_title,
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_action ELSE ml.ag_action END as ag_action
FROM minutes_ln ml
LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev)


LEFT OUTER JOIN ss_ag_item AS ai ON (ai.form_num = 3744 AND ai._rowid = am.ag_item_rowid)

LEFT OUTER JOIN codes AS c ON (c.code_type = 'MIN STATUS' AND c.valid_code = ml.ag_line_status)
LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8)))
WHERE ml.form_num = 946 AND
	  ml.rev_num = 0
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo
getMnLines (Datasource=, Time=0ms, Records=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
SELECT *
FROM getAllMnLines
WHERE getAllMnLines.header_ln = 'N' AND getAllMnLines.footer_ln = 'N'
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo	
getHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
	SELECT *
	FROM getAllMnLines
	WHERE getAllMnLines.header_ln = 'Y'
	ORDER BY header_ln DESC, sort_level1, sort_level2, sort_level3, sort_level4
getFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=10) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
		
	SELECT docs.sort_seq, docs.doc_name, docs.doc_link, docs.doc_dir,
			docs.confidentiality, docs.from_agenda,
	       
				'Y' can_look, 'Y' can_link	
			
			,
			ml.form_num, ml.rev_num, ml._rowid ml_rowid,
			min.minutes_published min_published,
			a.agenda_published ag_published
	FROM minutes min
	INNER JOIN minutes_ln AS ml ON (ml.form_num = min.form_num AND ml.rev_num = min.rev_num)
	INNER JOIN minutes_docs AS docs ON(docs.form_num = ml.form_num AND
		  							   docs.rev_num = ml.rev_num AND
		  							   docs.ln_rowid = ml._rowid
		  							
		  								AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
		  							)
	LEFT OUTER JOIN agenda AS a ON (a.form_num = min.ag_form_num AND a.rev_num = min.ag_rev_num)
	WHERE min.form_num = 946 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=16ms, Records=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 946 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19953 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19951 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12672 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19958 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19952 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12673 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19954 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 13420 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19964 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12674 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19965 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12675 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19960 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12676 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19963 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12677 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19962 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12682 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19961 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12683 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19956 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12686 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19955 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12687 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19957 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:59:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 04:59:36.036
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 04:59:36.036
	SELECT use_agendaquick, use_minutes, public_verity from fasinfo
count_minutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 04:59:36.036
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, minutes AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.minutes_published = 'Y'
		ORDER BY m.meeting_dt 
count_agendas (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 04:59:36.036
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, agenda AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.agenda_published = 'Y'
		ORDER BY m.meeting_dt 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\agenda_publish.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//agenda_publish.cfm?id=&mt=ALL&get_month=6&get_year=2023&dsp=min&seq=3745
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=6&get_year=2023&dsp=min&seq=3745
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/agenda_publish.cfm
SERVER_NAME=10.20.10.48
SERVER_PORT=8555
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Client Variables:
cfid=9527512
cftoken=1e07c9280d058ba9-D607E3B1-D371-AFD8-323277F56814A033
hitcount=4
lastvisit={ts '2024-05-05 04:59:36'}
timecreated={ts '2024-05-05 04:59:36'}
urltoken=CFID=9527512&CFTOKEN=1e07c9280d058ba9-D607E3B1-D371-AFD8-323277F56814A033
Cookie Variables:
CFID=9527512
CFTOKEN=1e07c9280d058ba9-D607E3B1-D371-AFD8-323277F56814A033
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=3745
Session Variables:
cfid=9527512
cftoken=1e07c9280d058ba9-D607E3B1-D371-AFD8-323277F56814A033
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9527512_1e07c9280d058ba9-D607E3B1-D371-AFD8-323277F56814A033
subdir=/public/
tzoffset=0
urltoken=CFID=9527512&CFTOKEN=1e07c9280d058ba9-D607E3B1-D371-AFD8-323277F56814A033
URL Parameters:
dsp=min
get_month=6
get_year=2023
id=
mt=ALL
seq=3745
Debug Rendering Time: 16 ms