Return
CITY COUNCIL SPECIAL WORK SESSION
TUESDAY, JUNE 22, 2021
CITY HALL STAFF CONFERENCE ROOM
211 WEST ASPEN
3:00 P.M.

 

MINUTES
             
1.
Call to Order

Mayor Deasy called the Special Work Session held June 22, 2021, to order at 3:03 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. Pledge of Allegiance and Mission Statement

The Council and attendees recited the pledge of allegiance and Councilmember Salas read the Mission Statement of the City of Flagstaff.
MISSION STATEMENT
The mission of the City of Flagstaff is to protect and enhance the quality of life for all.
             
3. ROLL CALL
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR DEASY (virtually)
VICE MAYOR DAGGETT (virtually)
COUNCILMEMBER ASLAN (virtually)
COUNCILMEMBER MCCARTHY (virtually)
COUNCILMEMBER SALAS (virtually)
COUNCILMEMBER SHIMONI (virtually)
COUNCILMEMBER SWEET (virtually)
ABSENT:









  Others present:  City Manager Greg Clifton; City Attorney Sterling Solomon.
             
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.

None
             
5. Transportation Commission, Bicycle Advisory Committee and Pedestrian Advisory Committee Updates
  Transportation Engineer Jeff Bauman introduced the Chair of the Transportation Commission Julie Leid, the Chair of the Pedestrian Advisory Committee Brandon Cruickshank, and Chair of the Bicycle Advisory Committee Mark Haughwout. Ms. Leid provided a PowerPoint presentation that covered the following:
 
TRANSPORTATION COMMISSION PEDESTRIAN & BICYCLE COMMITTEES
TRANSPORTATION COMMISSION MEMBERS
CHAPTER 2-12 ENABLING LEGISLATION
FUNCTIONS OF THE COMMISSION
RECENT TC AGENDA ITEMS
CURRENT TC AGENDA ITEMS
ACTIVE TRANSPORTATION MASTER PLAN
PAC INTRODUCTION
 
Mr. Cruickshank continued the presentation.
 
PEDESTRIAN ADVISORY COMMITTEE MEMBERS
PAC HIGHLIGHTS
FUTS MASTER PLAN
 
Mr. Haughwout continued the presentation.
 
BICYCLE ADVISORY COMMITTEE MEMBERS
BAC HIGHLIGHTS
BAC – BIKEWAYS
BAC HIGHLIGHTS
 
Ms. Leid concluded the presentation.
 
SPECIAL RECOGNITION – JACK WELCH
LOOKING AHEAD
 
The Council expressed their appreciation for the presentation and updates.
 
Vice Mayor Daggett stated that speeding is one of the reasons that road size should not be expanded. She would like to see separated bike lines if roads are expanding. She would also like to see bike and pedestrian infrastructure take priority over vehicles with every project containing complete bike and pedestrian components.
 
Councilmember Aslan stated that he would like to see a reprioritization of multi-modal transportation with every new street design incorporating appropriate bike and pedestrian infrastructure. Rather than widening streets, the focus should be on creating greater connectivity to lessen congestion. Enhancing bike and pedestrian pathways will encourage more people to bike or walk and reduce the number of vehicles on the roadways.
 
Councilmember Shimoni noted that the Transportation Commission can be very helpful with the public outreach efforts for the Alternative Transportation Master Plan (ATMP). Creating a fully connected FUTS system will encourage biking and walking. He would like to see all city developments paused to make sure biking and pedestrian safety are at the heart of all the plans. The roads are too wide which is why speeding is an issue.
 
Councilmember Sweet agreed that right-sizing roads rather than widening is important. Every project should contain multi-modal components. She also noted that having dedicated bus lanes would encourage more bus riders and reduce the number of vehicles. She advocated for connected FUTS trails and better signage for drivers to be aware of cyclists.
 
Councilmember Salas stated that integrating open space and trails is integral for safety and getting people on bikes. She noted that MetroPlan is a multi-agency transportation planning group, so the challenge is to influence leadership at the county and state levels to increase awareness of multi-modal transportation especially along Milton and Hwy 180.
 
Councilmember McCarthy stated that any new project or modification on a street needs to take into account bike and pedestrian safety. He noted that a pedestrian bridge over I-40 is a project that should be considered. He also indicated that better connectivity is needed on the FUTS trails.
 
Mayor Deasy added that he would like to see programming developed that focuses on educating young people about bicycle safety. He would like to see what opportunities there are for things such as three-dimensional painting for crosswalks and to bring back the safe routes to school program. He indicated that he would like to hear from commissions as to what programs exist in other communities and how they are working.
             
6. Petition - Lack of Safe and Accessible Bicycle and Pedestrian Infrastructure in Flagstaff
  City Engineer Rick Barrett provided a PowerPoint presentation that covered the following:
 
CITIZEN’S PETITION – ACK OF SAFE AND ACCESSIBLE BICYCLE AND PEDESTRIAN INFRASTRUCTURE IN FLAGSTAFF
OVERVIEW OF PETITION
 
Multi-Modal Transportation Manager Martin Ince continued the presentation.
 
ATMP CAPITAL PLANNING
FOUNDATIONS IN COMMUNITY PLANS
ACTIVE TRANSPORTATION MASTER PLAN AND THE CARBON NEUTRALITY PLN
PROP 419 PED-BIKE PROJECTS
PED-BIKE PROJECT FUNDING
PROJECT DEVELOPMENT/PRIORITIZATION
PROCESS/COMMUNITY ENGAGEMENT
PRIORITY FACTORS
SOCIAL FACTOR
TOTAL INFRASTRUCTURE NEEDS
FIRST PRIORITY INFRASTRUCTURE NEEDS
PED-BIKE IN 419 ROADWAY PROJECTS
SIDEWALK PRIORITY MAP
FUTS TRAILS PRIORITY MAP
ENHANCED CROSSINGS MAP
BRIDGES AND TUNNELS MAP
PROJECT LISTS
FIRST PROJECTS MAP
BIKEWAYS PLAN
SEPARATION PRINCIPLE
TYPES OF CYCLISTS
BICYCLIST PREFERENCE
BIKEWAYS HIERARCHY
BIKEWAYS HIERARCHY MAP
WHAT IT MEANS
BIKEWAYS FACILITIES MAP
PICTURE EXAMPLES
FIRST PROJECTS BIKEWAYS
CITIZEN PETITION
CITIZEN PETITION MAP
COMPARE TO BIKEWAYS PLAN
OTHER CANDIDATE STREETS
POTENTIAL PILOT STREETS MAP
DESIGN OPTIONS
METAL RAILING + CANDLESTICKS
CONCRETE BARRIER
CURB OR MEDIAN
BALANCE BETWEEN OPTIONS
 
Councilmember Shimoni asked if there are cost estimates for the options. Mr. Ince stated that the rough estimate for the candlesticks is about $100,000 per mile. Staff is working with the company that provides the metal railing and expect to hear back from them shortly. They anticipate the metal railing will cost more than the candlesticks and the concrete even more than that. With the direction of Council, they will continue gathering that information.
 
Mayor Deasy stated that he would like to understand the impact candlesticks and metal railings will have on snowplow operations. Mr. Ince stated that the candlesticks will likely not survive snowplowing and would need to be regularly replaced. They have been told that the metal installation will withstand snow plowing but the greater impact will be that the plows will push snow into the bike lane and then specific equipment will be needed to remove the snow from the bike lane.
 
Mr. Barrett continued the presentation.
 
ACCELERATE PROJECTS
419 REALLOCATION
REDUCE SPEED LIMITS
 
Councilmember Shimoni asked if it is possible to explore widening Butler Avenue to three lanes and integrating a cycle track option for the fourth lane. Mr. Barrett stated that it is something that could be included in the design discussions. It is a good time to put ideas on the table as the design process has not yet started.
 
Mr. Solomon stated that based on what is heard from Council, he will be scheduling a follow-up Executive Session to discuss the ballot language, voter directive, and the publicity pamphlet information and how they relate with the components of the citizen petition.
 
A break was held from 5:31 p.m. through 5:40 p.m.
 
The following individuals addressed Council in support of the citizen's petition:
  • Sam Meier
  • Anthony Quintile
  • Karin Wadsack
  • John Dailey
  • Scott Heinsius
  • Alicyn Gitlin
  • Heidi Larson
  • Shawna Heinsius
  • Dan Dunn
  • Michele James
  • Anthony Garcia
  • Sarah Andrews
  • Michael Colin Caulkins
  • Nora Timmerman
  • Jeff Meilbeck
  • Dina Barnese
  • Susan Hueftle
The following comments were received:
  • It is time to support improved bike and pedestrian infrastructure.
  • Physical separation of bikes and vehicles should be done whenever possible.
  • Consider bike specific traffic signals.
  • Bikeways need to be cleared in a priority manner.
  • Cyclists must navigate increasingly distracted drivers.
  • Please implement infrastructure improvements as soon as possible.
  • Changing the planning process will inconvenience drivers so there will likely be a lot of pushback.
  • Spending money on roads is not in line with the priorities of bike safety.
  • Explore the latitude within the ballot measure; if the flexibility is not there, hit the pause button and take it back to voters.
  • Flagstaff must set the example on bike safety.
  • There is money available and bike and pedestrian infrastructure should be given increased priority for funding.
  • Bike and pedestrian infrastructure supports and compliments the Carbon Neutrality Plan.
  • Drivers need to be held more accountable for traffic infractions.
  • It is time to make bike and pedestrian safety a priority.
  • Support the ATMP and make Flagstaff the best it can be.
  • The plan exists, it is time to implement it.
  • Please do this sooner rather than later; people deserve to have the ability to go anywhere in the city safely.
  • Implementation of the ATMP is important for improving safety and moving forward with carbon neutrality goals.
  • Move forward immediately with the short-term pilot projects.
  • Bring ideas to commissions; the Beautification and Public Arts Commission recently discussed securing funding from beautification to create safer bike and pedestrian infrastructure.
  • Re-allocate money to biking infrastructure.
  • MetroPlan developed a list of projects for funding and bike and ped projects were the top priority.
  • Once the ATMP is adopted, MetroPlan will support and further the goals of that effort.
  • More signage is needed to indicate where bike lanes are and shared bike lanes.
  • Education for cyclists is needed on how to properly bike in traffic and education for drivers on how to share the road.
  • Bike facilities cost less than vehicle facilities.
  • Repainting of sharrow marks is needed along with reflective stripes on FUTS.
Written comments in support of the citizen's petition were submitted by the following:
  • Nicolaus Hawbaker
  • Jeff Meilbeck
  • Rob McPherson
  • Jessie Bersson
  • James Bailey
  • Travis Brown
  • Michael Murphy
  • Austin Smith
  • Moses Milazzo
  • Hannah Caproon
  • Elizabeth Gehret
  • Macy Mouritsen
  • Stacy Stumpf
  • William Ambrose
  • Hannah Green
  • Rose Houk
  • Geoffrey Whittaker
  • Kyle Colavito
  • Adam Harrington
  • Heidi Larson
  • Sage Nelson
Vice Mayor Daggett asked Mr. Solomon to put information together in preparation for an Executive Session. She specifically asked about methods available to alter speed limits without a study and the discretion of Proposition 419 funds and how they are spent. She stated that she would like to see more bike and pedestrian projects coming forward even if that means other projects have to be postponed. Every project that comes forward should have sidewalks and bike facilities as a priority.
 
Councilmember Shimoni indicated that he would like to see the right sizing of roads that incorporate bike and pedestrian needs. All city roads must accommodate public safety needs and improvements that increase the likelihood of surviving an accident. He would like to see a foot taken from each lane and a bike lane installed with the metal and candlestick barriers. He would like staff to come back with options for short-term integration.
 
Councilmember McCarthy agreed that bike and pedestrian safety needs to be prioritized. There should be separated bike lanes wherever possible. The FUTS system needs to be completed and connected so people can get across the city without needing to enter into traffic. Reducing the speed on Butler makes sense but 25 miles per hour seems too low for an arterial road; an analysis is needed to evaluate options. More signage is needed regarding shared lanes and the ability for cyclists to take the lane.
 
Councilmember Sweet stated that she would like to see all projects prioritize increased safety for all users with roads that benefit all who want to use them. Roads need to be right-sized to encourage slower speeds.
 
Mayor Deasy stated that he likes the idea of utilizing the candlestick approach, but he is concerned about the cost of having to constantly replace them; he would like to see a more permanent solution to maximize the funding available. He suggested that candlesticks be used as a pilot in certain areas to see how they perform and then look for a more permanent solution more widespread.
 
Streets Director Scott Overton added that there will be an impact on snow operations, and they will need to change how things are done. They are committed to conversations and finding solutions that will work for everyone.
 
Councilmember McCarthy stated that an analysis is needed to look at the costs for all the options, how snow would be addressed, any other safety concerns, along with public acceptance. There are trade-offs with all the options, and he wants to better understand the impacts before making any decision.
 
Councilmember Aslan shared concern about the speed at which the discussion is moving. Safety is important, as is integrating bike and pedestrian infrastructure, but moving too fast may create unintended consequences. The ideas presented are worthwhile but in order to do it right and implement them effectively, it will take analysis and community buy-in.
 
Mayor Deasy suggested using the $25,000 Council Initiative funding to get barrels, potted plants, and haystacks to use to block off two lanes of Fourth Street to pilot a dedicated bike lane on both sides.
 
Councilmember Aslan stated that a pilot project is appropriate to get a feel for what the public reception is. He is concerned about the rush and believes that it is best to allow staff to put something together, so it is done right.
 
Vice Mayor Daggett stated that the prioritization should be related to already-planned infrastructure projects that are related to bike and pedestrian safety. With regard to the use of the $25,000, if staff can develop a project that could be implemented in a short timeframe then she is willing to consider something.
 
Councilmember Sweet stated that she is open to the $25,000 being used for a project that could get the community involved and create change. She would like to see what options are available before giving direction.
 
Councilmember Salas agreed that pedestrian and bike infrastructure should be prioritized but it should be done holistically with data, analysis, and recommendations from the experts. It is important to engage with the community to get buy in on projects. She indicated that she will rely on staff recommendations for the use of the $25,000; there has been a request from the Flagstaff Trails Initiative for the use of these funds as well as a desire to support victims of the accident.
 
Councilmember Shimoni stated that he supports the Mayor’s idea and he feels that it should be done before Council goes on summer break. He would like to see staff come back with options and ways to make things happen right now and speed up the projects in the ATMP.
 
After further discussion the Council expressed support for the following:
  • Staff to come back with information on the cost to implement the methods for separated bike lanes.
  • Research the ability to reallocate funds within Proposition 419.
  • Research the ability to waive or amend the code to adjust speed limits.
  • Research three-dimensional artwork for pavement markings.
  • Researching different intersection designs based on accident data.
  • Converting bike and pedestrian components into new roads and focus on right-sizing roads.
There was not Council support to pause current projects to evaluate bike and pedestrian components.
 
Council also supported adding a Special Meeting to the June 29, 2021 Work Session to take action on the use of the Council Initiative Fund.
             
7. Public Participation

None
             
8. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests
  Mayor Deasy thanked all the firefighters on the front line working the Rafael Fire. He encouraged people to sign up for Coconino County Alerts so they are informed of any Ready, Set, Go, status updates. He stated that with the increased smoke in the area, there are KN95 masks available at City Hall for those who may need them.
 
Councilmember Shimoni encouraged people to follow the Coconino County Facebook page for current information. He also thanked the firefighters in the region. He requested a FAIR item to discuss unsheltered and vulnerable populations with the closure of the forests and the anti-camping ordinance.
 
Councilmember Salas stated that the City had entered into Stage 4 fire restrictions and people can find more information on the website and Facebook. She stated that there is a plan in place with Coconino County Health and Human Services for displaced citizens within the evacuation areas and that Catholic Charities, the Salvation Army, and Flagstaff Shelter Services are responding to the needs of those who are experiencing homelessness. She also reported that she will be attending the upcoming National Association of Workforce board meeting.
             
9. Adjournment

The Special Work Session held June 22, 2021, adjourned at 5:41 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 18-Apr-24 05:30 PM
Locale English (US)
User Agent claudebot
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
172 ms 172 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
141 ms 141 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
125 ms 125 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
63 ms 63 ms 1 D:/inetpub/PublicPages/Application.cfm
63 ms 32 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.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=63ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 17:30:22.022
			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 @ 17:30:22.022
				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 @ 17:30:22.022
			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 @ 17:30:22.022
				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 @ 17:30:22.022
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 17:30:22.022
	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 @ 17:30:22.022
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=15ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:30:22.022
		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 @ 17:30:22.022
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:30:22.022
		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 @ 17:30:22.022
	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 @ 17:30:22.022
	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 @ 17:30:22.022
		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 @ 17:30:22.022
		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 @ 17:30:22.022
	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 @ 17:30:22.022
	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 @ 17:30:22.022
	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 @ 17:30:22.022
	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 @ 17:30:22.022
	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 @ 17:30:22.022
	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 @ 17:30:22.022
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:30:22.022
	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=16ms, Records=16) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:30:22.022
		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) = 2021-06-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2021-06-30 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 17:30:22.022
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
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 = 1237 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 17:30:22.022
		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) = 1237

qCodes (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 17:30:22.022
			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(1237 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 @ 17:30:22.022
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 1236 
getAllMnLines (Datasource=frsRO, Time=31ms, Records=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
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 = 1236 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 = 647 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=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
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 @ 17:30:22.022
	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 @ 17:30:22.022
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
		
	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 = 647 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 647 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 @ 17:30:22.022
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14793 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14797 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14791 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9829 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14792 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14799 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9830 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14800 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9831 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14795 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14794 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9833 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14796 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:30:22.022
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 17:30:22.022
	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 @ 17:30:22.022
	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 @ 17:30:22.022
		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 @ 17:30:22.022
		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=2021&dsp=min&seq=1237
HTTP_USER_AGENT=claudebot
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=2021&dsp=min&seq=1237
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=9119068
cftoken=1fe7ed1a2e895321-8578D9AC-9D7D-B909-4123DE8F02C9DCF1
hitcount=4
lastvisit={ts '2024-04-18 17:30:22'}
timecreated={ts '2024-04-18 17:30:22'}
urltoken=CFID=9119068&CFTOKEN=1fe7ed1a2e895321-8578D9AC-9D7D-B909-4123DE8F02C9DCF1
Cookie Variables:
CFID=9119068
CFTOKEN=1fe7ed1a2e895321-8578D9AC-9D7D-B909-4123DE8F02C9DCF1
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=1237
Session Variables:
cfid=9119068
cftoken=1fe7ed1a2e895321-8578D9AC-9D7D-B909-4123DE8F02C9DCF1
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9119068_1fe7ed1a2e895321-8578D9AC-9D7D-B909-4123DE8F02C9DCF1
subdir=/public/
tzoffset=0
urltoken=CFID=9119068&CFTOKEN=1fe7ed1a2e895321-8578D9AC-9D7D-B909-4123DE8F02C9DCF1
URL Parameters:
dsp=min
get_month=6
get_year=2021
id=
mt=ALL
seq=1237
Debug Rendering Time: 0 ms