City Council Meeting - FINAL


Return to the Search Page Return to the Agenda
  12.C.       
Meeting Date: 11/01/2022  
From: Martin Ince, Multi-Modal Planner

Information
TITLE:
Consideration and Adoption of Resolution No. 2022-50:  A resolution of the Flagstaff City Council adopting the Active Transportation Master Plan
STAFF RECOMMENDED ACTION:
1) Read Resolution No. 2022-50 by title only
2) City Clerk reads Resolution No. 2022-50 by title only (if approved above)
3) Adopt Resolution No.2022-50
Executive Summary:
This resolution will adopt the City’s Active Transportation Master Plan (ATMP), a guide to enhance walking and biking by making them more useful, comfortable, safe, attractive and convenient as modes of transportation. Over the years, a variety of City of Flagstaff plans and policy documents have highlighted the importance of walking and biking, starting with the Flagstaff Regional Plan. The ATMP advances the City’s vision and goals for walking and biking by providing direction and details on becoming a more pedestrian- and bicycle-friendly community.
Financial Impact:
The ATMP helps guide City capital expenditures, through identification and prioritization of a variety of pedestrian and bicycle projects to be built over the next 20 years with funding from the transportation sales tax and First Mile Last Mile grant. The plan also positions the City to pursue grants and other opportunities to build walking and biking infrastructure.
 
Adoption of the ATMP does not have a direct financial impact; however in the future additional funding and staff resources will be required to implement programmatic recommendations in the plan. Additional maintenance resources will also be needed to take care of new pedestrian and bicycle infrastructure as recommended in the draft ATMP.
Policy Impact:
The ATMP does not change existing Regional Plan goals and policies relevant to walking and biking, but it does provide additional detail regarding how to implement them. The document also includes its own goals, policies, and strategies for walking and biking. There are 32 policies organized around six topics – infrastructure, maintenance and operations, support and encouragement, safety, transportation and land use planning, and evaluation – as well as a long list of detailed strategies and actions for each of the 32 policies.
Connection to PBB Priorities/Objectives, Carbon Neutrality Plan & Regional Plan:
Priority Based Budget Key Community Priorities and Objectives
 
Safe & Healthy Community
Foster a safe, secure, and healthy community
 
Inclusive & Engaged Community
Advance social equity and social justice in Flagstaff
Enhance community outreach and engagement opportunities
Ensure city facilities, services, and programs are accessible for all residents
 
Sustainable, Innovative Infrastructure
Deliver outstanding services to residents through a healthy, well maintained infrastructure system
Utilize existing long-range plan(s) that identify the community's future infrastructure needs and all associated costs
Identify smart traffic management, multi-modal transportation, and alternative energy opportunities
 
Livable Community
Provide amenities and activities that support a healthy lifestyle
 
Environmental Stewardship
Implement sustainable building practices and alternative energy and transportation options
Implement, maintain and further the Climate Action and Adaptation Plan (CAAP)

Carbon Neutrality Plan
 
Goal: Equitable Systems
Strategies
ES-1: Incorporate equity as a foundational element of every climate action the City develops and implements.
ES-2: Proactively engage community members on an ongoing basis.
 
Goal: Decreased Dependence on Cars
Strategies:
DD-1: Encourage vibrancy, appropriate density, and attainability in existing neighborhoods, so that more residents live within walking distance of their daily needs.
DD-2: Create inclusive networks for walking and biking that are continuous, attractive, safe, comprehensive, and convenient for people of all ages.
DD-3: Encourage Flagstaff residents and visitors to walk, bike, roll and take the bus.
 
Goal: Electric Mobility
Strategies
EM-2:   Welcome electric micro-mobility devices as legitimate, healthy, affordable, and low-carbon modes of transportation.

Regional Plan
 
Goal T.1. Improve mobility and access throughout the region.
Policy T.1.1. Integrate a balanced, multimodal, regional transportation system.
Policy T.1.2. Apply Complete Street Guidelines to accommodate all appropriate modes of travel in transportation improvement projects.
Policy T.1.5. Manage the operation and interaction of all modal systems for efficiency, effectiveness, safety, and to best mitigate traffic congestion.
Policy T.1.6. Provide and promote strategies that increase alternate modes of travel and demand for vehicular travel to reduce peak period traffic.
 
Goal T.2. Improve transportation safety and efficiency for all modes.
Policy T.2.1. Design infrastructure to provide safe and efficient movement of vehicles, bicycles, and pedestrians.
Policy T.2.3. Provide safety programs and infrastructure to protect the most vulnerable travelers, including the young, elderly, mobility impaired, pedestrians, and bicyclists.
 
Goal T.3. Provide transportation infrastructure that is conducive to conservation, preservation, and development goals to avoid, minimize, or mitigate impacts on the natural and built environment.
Policy T.3.2. Promote transportation systems that reduce the use of fossil fuels and eventually replace with carbon neutral alternatives.
Policy T.3.4. Actively manage parking, including cost and supply, to support land use, transportation, and economic development goals.
Policy T.3.8. Promote transportation options such as increased public transit and more bike lanes to reduce congestion, fuel consumption, and overall carbon emissions and promote walkable community design.
 
Goal T.4. Promote transportation infrastructure and services that enhance the quality of life of the communities within the region.
Policy T.4.1. Promote context sensitive solutions (CSS) supportive of planned land uses, integration of related infrastructure needs, and desired community character elements in all transportation investments.
Policy T.4.2. Design all gateway corridors, streets, roads, and highways to safely and attractively accommodate all transportation users with contextual landscaping and appropriate architectural features.
 
Goal T.5. Increase the availability and use of pedestrian infrastructure, including FUTS, as a critical element of a safe and livable community.
Policy T.5.1. Provide accessible pedestrian infrastructure with all public and private street construction and reconstruction projects.
Policy T.5.2. Improve pedestrian visibility and safety and raise awareness of the benefits of walking.
Policy T.5.3. Identify specific pedestrian mobility and accessibility challenges and develop a program to build and maintain necessary improvements.
Policy T.5.4. Design streets with continuous pedestrian infrastructure of sufficient width to provide safe, accessible use and opportunities for shelter.
 
Goal T.6. Provide for bicycling as a safe and efficient means of transportation and recreation.
Policy T.6.1. Expand recognition of bicycling as a legitimate and beneficial form of transportation.
Policy T.6.2. Establish and maintain a comprehensive, consistent, and highly connected system of bikeways and FUTS trails.
Policy T.6.3. Educate bicyclists and motorists about bicyclist safety through education programs, enforcement, and detailed crash analyses.
Policy T.6.4. Encourage bikeways and bicycle infrastructure to serve the needs of a full range of bicyclist experience levels.
Policy T.6.5. Provide short- and long-term bicycle parking where bicyclists want to travel.
Policy T6.6. Integrate policies to increase bicycling and meet the needs of bicyclists into all relevant plans, policies, studies, strategies, and regulations.
 
Goal T.7. Provide a high-quality, safe, convenient, accessible public transportation system, where feasible, to serve as an attractive alternative to single-occupant vehicles.
Policy T.7.5. Incorporate adopted plans and policies for non-motorized and public transportation in the permitting process for all development or land use proposals, including provisions for efficient access and mobility, and convenient links between pedestrian, bicycle, and transit facilities.
 
Goal T.9. Strengthen and support rail service opportunities for the region’s businesses and travelers.
Policy T.9.4. Increase the number of grade-separated railroad crossings.
 
Goal T.10. Strengthen and expand the role of Flagstaff Pulliam Airport as the dominant hub for passenger, air freight, public safety flights, and other services in northern Arizona.
Policy T.10.2. Improve multimodal access and service to and from the airport including transit, bicycle, and parking services.
 
Goal T.11. Build and sustain public support for the implementation of transportation planning goals and policies, including the financial underpinnings of the Plan, by actively seeking meaningful community involvement.
Policy T.11.2. Approach public involvement proactively throughout regional transportation planning, prioritization, and programming processes, including open access to communications, meetings, and documents related to the Plan.
Policy T.11.3. Include and involve all segments of the population, including those potentially underrepresented such as the elderly, low-income, and minorities
Policy T.11.4. Attempt to equitably distribute the burdens and benefits of transportation investments to all segments of the community.
 
Goal NH.1. Foster and maintain healthy and diverse urban, suburban, and rural neighborhoods in the Flagstaff region.
Policy NH.1.3. Interconnect existing and new neighborhoods through patterns of development, with complete streets, sidewalks, and trails.
 
Goal OS.1. The region has a system of open lands, such as undeveloped natural areas, wildlife corridors and habitat areas, trails, access to public lands, and greenways to support the natural environment that sustains our quality of life, cultural heritage, and ecosystem health.
Policy OS.1.4. Use open space as opportunities for non-motorized connectivity, to interact with nature, and to enjoy the views and quiet.
 
Goal WR.5. Manage watersheds and stormwater to address flooding concerns, water quality, environmental protections, and rainwater harvesting.
Policy WR.5.2. Incorporate pedestrian access, trails, and watchable wildlife opportunities into natural watercourses when practical.
 
Goal E.1. Increase energy efficiency.
Policy E.1.5. Promote and encourage the expansion and use of energy-efficient modes of transportation:
a. Public transportation
b. Bicycles
c. Pedestrians
 
Goal CC.4. Design and develop all projects to be contextually sensitive, to enhance a positive image and identity for the region.
Policy CC.4.1. Design streetscapes to be context sensitive and transportation systems to reflect the desired land use while balancing the needs of all modes for traffic safety and construction and maintenance costs.
Policy CC.4.4. Design streets and parking lots to balance automobile facilities, recognize human-scale and pedestrian needs, and accentuate the surrounding environment.
 
Goal CC.5. Support and promote art, science, and education resources for all to experience.
Policy CC.5.4. Complete sidewalks and Flagstaff Urban Trails System connections for all schools, community colleges, and university campuses.
 
Goal LU.1. Invest in existing neighborhoods and activity centers for the purpose of developing complete, and
connected places.
Policy LU.1.4. Attract private investment by reinvesting in transportation infrastructure improvements as well as public utilities infrastructure for desired development size.
 
Goal LU.2. Develop Flagstaff ’s Greenfields in accordance with the Regional Plan and within the growth boundary.
Policy LU.2.1. Design new neighborhoods that embody the characteristics of Flagstaff’s favorite neighborhoods – that is, with a mix of uses, a variety of housing types and densities, public spaces, and greater connectivity with multimodal transportation options.
 
Goal LU.10. Increase the proportion of urban neighborhoods to achieve walkable, compact growth.
Policy LU.10.1. Prioritize connectivity within all urban neighborhoods and activity centers.
Policy LU.10.2. Support on-street parking, shared lots, and parking structures.
Policy LU.10.7. Invest in infrastructure and right-of-way enhancements that favor the pedestrian and transit as an incentive for private investment in urban neighborhoods and activity centers.
 
Goal LU.12. Accommodate pedestrians, bicyclists, transit riders, and private cars to supplement downtown’s status as the best-served and most accessible location in the region.
Policy LU.12.1. Invest in downtown’s streets and sidewalks so that they remain Flagstaff’s premiere public spaces.
Policy LU.12.7. Provide multiple routes and pathways for vehicular and pedestrian movement.
Policy LU.12.8. Provide for strong connections from the Flagstaff Medical Campus to the Northern Arizona University campus via pedestrian paths, bicycle connections, streets, and transit service.
Policy LU.12.9. As defined in the FUTS Master Plan, include trail access points, bicycle parking, and bicycle facilities.
 
Goal LU.13. Increase the variety of housing options and expand opportunities for employment and neighborhood shopping within all suburban neighborhoods.
Policy LU.13.1. Prioritize connectivity for walking, biking, and driving within and between surrounding neighborhoods.
Policy LU.13.9. Use open space and FUTS trails to provide walking and biking links from residential uses to employment, shopping, schools, parks, and neighborwoods.
 
Goal LU.14. Maintain the character of existing rural communities.
Policy LU.14.4. Connect rural neighborhoods using roads, trails (equestrian, foot, and bicycle), and public access to the National Forest.
 
Goal LU.15. Plan for and encourage employee-intensive uses throughout the area as activity centers, corridors,
research and development offices, business parks, and light industrial areas to encourage efficient infrastructure and multimodal commuting.
Policy LU.15.4. Accommodate safe and convenient walking, biking, and transit facilities in existing and proposed employment centers.
 
Goal LU.19. Develop a manageable evolution of the main corridors into contextual place makers.
Policy LU.19.4. Balance automobile use, parking, bicycle access, while prioritizing pedestrian safety along all corridors.
Has There Been Previous Council Decision on This:
No
Options and Alternatives:
Option A. Adopt Resolution 2022-50 as submitted and adopt the Active Transportation Master Plan
Option B. Adopt Resolution 2022-50 with changes
Option C. Do not adopt Resolution 2022-50
Background and History:
The ATMP is intended to serve as a guide to making walking and biking in Flagstaff more convenient, useful, comfortable, attractive, and safe. The Flagstaff Regional Plan describes an overall vision for transportation and lists a variety of goals of policies to achieve the vision, including a number of goals and policies directly related to walking and biking. The ATMP will provide the details to advance the overall vision and implement the goals and policies.
Key Considerations:
The intent of the ATMP 
  • Provide policy guidance to advance the transportation goals and vision of the Regional Plan
  • Establish specific goals and strategies to support and promote walking and biking
  • Identify and prioritize needed pedestrian and bicycle infrastructure
  • Set forth planning and design guidance for walking and biking
  • Facilitate a fundamental change (the Big Shift) in Flagstaff’s approach to transportation planning
 Plan contents
 
1 Introduction: describes the policy context, how the plan was developed, and how it will be used; closed with a list of guiding principles and a description of an overall approach.
 
2 Current conditions: provides an accounting of the current status of walking and biking, based on existing facilities, mode share, crash data, and national indicators.
 
3 Goals and policies: includes specific goals for walking and biking, as well as 32 policies organized around six topics. Appendix A supplements this chapter with a list of potential strategies and actions for each of the 32 policies.
 
4 Outcomes, indicators, and targets: lists desired results and measures, and establishes attainable targets for the short and long term.
 
5 Implementation: describes a broad range of opportunities to implement the plan, including priority actions for the first year and first five years.
 
6 Planning considerations: a discussion of how walking and biking fit into the larger contexts of transportation and land use planning.
 
7 Design guidance: provides information on design considerations for pedestrian and bicycle facilities, as well as streets and intersections.
 
8 Infrastructure recommendations:
 
How the plan is used
  • Goals and policies in the ATMP can provide guidance on walking and biking for other planning documents, including the Regional Plan and the Regional Transportation Plan.
  • The ATMP includes a prioritized list of pedestrian and bicycle infrastructure projects that will be included in the City’s five-year capital program.
  • Policies and strategies can be reflected in the City’s performance-based budgeting process and incorporated into budget requests, strategic plans, and work programs.
  • The ATMP does not create any new standards or regulations, but it can be used to help identify revisions to the Zoning Code and Engineering Standards to support walking and biking. The document can also inform how City processes and practices can be made more walk and bike friendly.
  • The ATMP also does not create any new requirements for private development, but it can serve as guidance for pedestrian and bicycle accommodation.
  • Design and planning guidance can also be used with other City capital projects that includes pedestrian and bicycle components, like new roadway projects.
 
Guiding principles
  • Walking and biking are important to Flagstaff and reflect the values of the community.
  • Flagstaff has a significant opportunity to expand walking and biking, but it takes a concerted effort by the City
  • More people will choose to walk and bike when it is comfortable, convenient, and useful
  • Walking and biking are critical elements of a robust transportation system
  • Walking and biking are integral parts of a larger context of land use, community character, and street design.
  • Mobility – the ability to travel freely to access our daily needs and activities – is a fundamental human need.
  • Better transportation options and enhanced mobility support equity
  • Sustainable transportation options are critical to meeting the City’s carbon neutrality goals
  • Active transportation supports a healthy and resilient economy
 
Recommended approach 
  • Be more transformational than incremental
  • Prioritize pedestrians and bicyclists
  • Take a well-rounded approach to transportation.
  • Pursue a wide range of solutions for mobility
  • Use Travel Demand Management (TDM) as a guiding principle
  • Don’t overbuild for cars
Community Involvement:
Walking and biking support a variety of community benefits, both directly and indirectly:
  • Health: walking and biking are linked to a number of health benefits.
  • Safety: providing facilities for walking and biking can help make roadways safer for all users, including motorists.
  • Mobility: more viable transportation options mean better mobility for the entire community.
  • Transit: walking and biking help support transit by making it easier for riders to get to transit stops and extending the reach of bus lines into neighborhoods.  Transit supports walking and biking by serving as a backup safety net.
  • Equity: more viable transportation options improve mobility for all segments of the population, including the elderly, individuals with mobility challenges, and low-income populations.
  • Environment: walking and biking reduce reliance on fossil fuels and lowers greenhouse gas emissions, which provides numerous benefits such as improved local air quality and better health.
  • Housing: transportation typically accounts for about 20 percent of a typical household income; when transportation costs are reduced, more household income is available for housing (H+T index).
  • Economy: pedestrian and bicycle-friendly commercial areas promote street-level activity, vibrancy, and vitality. Communities with strong walking, biking, and trails infrastructure gain a competitive edge in attracting and keeping businesses and jobs.
  • Sustainability: walking and biking also support Flagstaff's goal of carbon neutrality. In Flagstaff, transportation accounts for about 30 percent of greenhouse gas emissions.
Expanded Options and Alternatives:
The community was engaged in the preparation of this draft plan in a number of ways:
 
Community surveys: a total of 15 community surveys related to walking and biking have been conducted since 2016. Six of these were done specifically in support of the ATMP, and another nine were conducted for other projects but are relevant to walking and biking.
 
Public outreach: staff have conversed with hundreds of residents about pedestrian and bicycle issues at numerous community events, including Earth Day, Bike-to-Work Week, Arizona Trail Day, and the Flagstaff Community Market. Two walking and biking summits were hosted in late 2017, during which approximately 100 attendees were given an opportunity to provide feedback and complete a survey.
 
PAC and BAC meetings: since 2014, discussion of the ATMP has been a standing item on the monthly agendas of the City’s Pedestrian Advisory Committee (PAC) and Bicycle Advisory Committee (BAC). The draft ATMP has also been discussed at the several Transportation Commission meetings.
 
Other boards and commission: the draft ATMP was presented to a variety of City commission over the past year, including the Beautification and Public Art Commission, Commission on Diversity Awareness, Commission on Inclusion and Adaptive Living, Housing Commission, Open Spaces Commission, Parks and Recreation Commission, Planning and Zoning Commission, Sustainability Commission, and Tourism Commission.
Attachments
Res. 2022-50
Ex. A. - Draft Active Transportation Master Plan
Presentation


    

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 17-Apr-24 11:57 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
188 ms 188 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
141 ms 141 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
46 ms 46 ms 1 D:/inetpub/PublicPages/Application.cfm
46 ms 23 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
32 ms 32 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/include_set_fonts.cfm
15 ms 15 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(6882, 0, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
15 ms 15 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.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/print_agm_ud.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
234 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 23:57:26.026
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 23:57:26.026
				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 @ 23:57:26.026
			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 @ 23:57:26.026
				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 @ 23:57:26.026
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 23:57:26.026
	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 @ 23:57:26.026
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 23:57:26.026
		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 @ 23:57:26.026
	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 @ 23:57:26.026
		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 @ 23:57:26.026
	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 @ 23:57:26.026
	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 @ 23:57:26.026
		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 @ 23:57:26.026
		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 @ 23:57:26.026
	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 @ 23:57:26.026
	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 @ 23:57:26.026
	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 @ 23:57:26.026
	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 @ 23:57:26.026
	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 @ 23:57:26.026
	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 @ 23:57:26.026
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 23:57:26.026
	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=14) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 23:57:26.026
		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) = 2022-11-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2022-11-30 00:00:00.0

chk_aiDisplay (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_content.cfm @ 23:57:26.026
		select case when ss_agi._rowid is null then agi.display_routine else ss_agi.display_routine end as display_routine
		from ag_memo am
		inner join agenda_ln as atl on (atl.ag_memo_id = am.form_num and atl.ag_memo_rev = am.rev_num)
		inner join agenda as a on (a.form_num = atl.form_num)
		left outer join ag_item as agi on (agi._rowid = am.ag_item_rowid)
		left outer join ss_ag_item as ss_agi on (ss_agi.form_num = a.form_num and ss_agi._rowid = am.ag_item_rowid)
		where am.form_num = ?
		  and am.rev_num  = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6882
Parameter #2(cf_sql_integer) = 0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 23:57:26.026
			select top 1 * from codes
		
qryResults (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 23:57:26.026
	SELECT fas.form_id, fas.form_num fas_form_num, fas.rev_num fas_rev_num, fas.rqst_loc fas_rqst_loc, 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, fas.orig_loginid, meetings.meeting_dt as bo_date, de.fname, de.lname, de.title as utitle,															
		   meetings.doc_dir, meetings.meeting_name, meetings.meeting_dt, meetings.meeting_id, ag_times.descr time_descr, orig_depts.dept_desc, orig_divs.div_desc,
		   al.ag_size, al.ag_underline, al.ag_bold, al.ag_center, al.ag_italic, al.disp_level,
	  	   al.ag_level1 chk_level1, al.ag_level2 chk_level2, al.ag_level3 chk_level3,
		   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4,al.seq_num,
		   al._rowid line_rowid,
		   a.text_size, a.text_font, a.print_num_ai, a.att_public, a.cont_numbering, a.att_header, a.exp_header, a.line_size, a.line_bold,
	   	   a.disp_num_ai, a.ag_punct, a.disp_ainumber, a.form_num ag_form_num, a.turn_off_level_dsp, a.disp_all_lvls,
		   a.disp_rteinfo, w.email, p.phone_no, p.phone_ext,
		   ft.meeting_id as ai_meeting_id, codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format,
		   al._rowid AS ln_rowid, al._rowid AS agenda_ln_rowid, a.form_num AS ag_num, a.rev_num AS ag_rev, a.use_old_print_format,		
		   aa.descr ag_area_desc, asa.descr ag_subarea_desc, al.seq_vchar,
 	   	   c1.text_value1 pdf_header, c1.text_value2 pdf_footer, c1.misc_alpha prt_att_links,
	 	   c1.misc_alpha3 page_start, c1.misc_alpha2 info_header, c1.text_value3 all_bold,
	 	   	 
	 	   		c1.misc_alpha7 lvl_text_size, c1.misc_alpha6 dp_level_ai, c1.misc_alpha10 printMinutes, c1.misc_alpha11 printLegal, c1.misc_alpha13 dateSpelled, c1.misc_alpha14 left_justify_all,
	 	   	
	 	   c2.misc_alpha2 level_descriptor,
		   amdol.text_value amdol_more_info, amdol.text_block LinesCCCBoardOrder,
		   ft.* 
	FROM fas
	INNER JOIN ag_memo AS ft ON (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 AND form_hist.rev_num = fas.rev_num)
	LEFT OUTER JOIN agenda AS a ON (ft.meeting_id = a.meeting_id)
	LEFT OUTER JOIN agenda_ln AS al ON (al.form_num = a.form_num AND al.ag_memo_id = ft.form_num AND al.ag_memo_rev = ft.rev_num)
	LEFT OUTER JOIN meetings ON (ft.meeting_id = meetings.meeting_id) 
	LEFT OUTER JOIN websecur AS w ON (w.login_id = ft.create_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	LEFT OUTER JOIN phone AS p ON (p.empl_id = w.empl_id AND p.is_primary ='Y')
	LEFT OUTER JOIN codes AS ag_times ON (ag_times.code_type = 'AG TIME' AND ag_times.valid_code = ft.ag_time)
	LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = a.text_size)
	LEFT OUTER JOIN ag_area aa ON (aa.meeting_type = meetings.the_meeting_type AND aa.ag_area = ft.ag_area)
	LEFT OUTER JOIN area_subarea AS asa ON (asa.ag_area = ft.ag_area and asa.ag_subarea = ft.ag_subarea and asa.meeting_type = meetings.the_meeting_type)

	LEFT OUTER JOIN dist_dept AS orig_depts ON (ft.orig_dept = orig_depts.dept_code)
	LEFT OUTER JOIN dept_div AS orig_divs ON (ft.orig_dept = orig_divs.dept_code AND ft.orig_div = orig_divs.div_code)
	LEFT OUTER JOIN form_userdef as amdol on (amdol.form_id = fas.form_id AND
		amdol.form_num = ft.form_num and amdol.rev_num = ft.rev_num AND
		amdol.code_type = 'AMDOL')
	LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AddlMtg' and CAST(c1.valid_code AS INT) = ft.meeting_id)
	LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'MTG_MSG' and c2.valid_code = meetings.the_meeting_type)
	WHERE UPPER(fas.form_id) = 'AG_MEMO' AND
				fas.form_num = ? AND
				fas.rev_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6882
Parameter #2(cf_sql_integer) = 0

final_check (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 23:57:26.026
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3645 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 23:57:26.026
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 23:57:26.026
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 23:57:26.026
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
agendaChk (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 3646 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 3646 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
SELECT agi.*, mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type, mt.resolution_number mt_resolution_number, mt.num_label mt_num_label,
	   c.misc_alpha print_routine_program, c.misc_alpha2 pdfHeadersFooters, c.misc_alpha3 print_only_routine,
	   agt.text_size, agt.text_font, agt.ag_template_id, agt.disp_rteinfo,
	   agt.disp_ainumber, agt.print_num_ai , m.template_id 									
FROM meetings m, ag_template agt, meeting_type mt
	
	INNER JOIN ss_ag_item AS agi ON (agi.form_num = 3645 AND agi._rowid = 86)
	
LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine)
WHERE m.meeting_id = 3646 AND
	  agt.ag_template_id = m.template_id AND
	  mt.meeting_type = agt.meeting_type AND
  	  agi._rowid = 86 
PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
		SELECT valid_code, descr, misc_alpha, misc_alpha2 pdfHeadersFooters
		FROM codes
		WHERE code_type = 'AG_MEMO_PRT' AND valid_code = 'FLAG' AND obsolete = 'N'
	
all_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
		SELECT au.code_type au_code_type, c.misc_alpha sortRequired, au.*
		FROM user_define ud
		INNER JOIN agi_userdef as au ON (au.fld_name = ud.fld_name AND au.agi_rowid = 86)
		LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '86')
		WHERE form_id = 'AG_MEMO'
	
all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi14')
			AND (opt_form_id = '' OR opt_form_id IS NULL)
		
getAllUD (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
			SELECT au.code_type, au.field_type, au.query_name, au.fld_name, au.seq_num,
					au.fld_label, au.fld_print, au.lbl_placement, au.new_row, au.colspan,
					text_block, au.agm_print_plcmnt,au.agm_csen, au.verti_hori, au.verti_hori_cols,
					CASE WHEN au.fld_rqd = 'N' then '2' else '1' end as sortBy
			FROM agi_userdef AS au
			WHERE au.agi_rowid = '86'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
			SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
				   ud.form_label, codes.descr, codes.large_misc_alpha
			FROM form_userdef AS u
			INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
			LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
			WHERE UPPER(u.form_id) = 'AG_MEMO' AND
					  u.form_num = 6882 AND
				      u.rev_num = 0 
getfi14 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
				SELECT * from get_userdef
				WHERE code_type = 'ud_fi14'
			
fi14q (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
					SELECT valid_code, descr, sort_order, misc_alpha2 FROM all_codes
					WHERE code_type = 'ud_fi14' AND
					(obsolete = 'N' AND create_date <= ? 
					)
					ORDER BY sort_order
				
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2022-11-01

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
submittor (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
		SELECT ee.fname + ' ' + ee.lname name,
			websecur.login_id, ee.title utitle, websecur.email, p.phone_no, p.phone_ext,
			dept.dept_desc, dept.dept_code, dd.div_code, dd.div_desc
		FROM websecur
		LEFT OUTER JOIN dist_empl AS ee ON (ee.empl_id = websecur.empl_id)
		LEFT OUTER JOIN dist_dept AS dept ON (dept.dept_code = ee.department)
		LEFT OUTER JOIN dept_div AS dd ON (dd.dept_code = ee.department AND
											dd.div_code = ee.division)
		LEFT OUTER JOIN phone AS p ON (p.empl_id = ee.empl_id AND p.is_primary = 'Y')
		WHERE websecur.login_id = 'mince'
	
items (Datasource=frsRO, Time=15ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 6882 AND
      rev_num = 0
ORDER BY seq_num
committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
	SELECT dept_code, dept_desc, review_comm FROM dist_dept
	
ReviewCommittee (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
	SELECT dept_code FROM committees WHERE review_comm = 'Y'
expenditures (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 6882 AND ag_memo_dol.rev_num = 0
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
	SELECT _rowid ag_doc_id, ag_doc_name, ag_doc_dir, ag_doc_link, sort_seq, confidentiality
		,'Y' as can_look, 'Y' as can_link
		
	FROM agenda_docs ad
	WHERE ad.form_num = 6882 AND
		  ad.rev_num = 0 
		  AND (ad.confidentiality IS NULL OR ad.confidentiality = '')		
		
	ORDER BY sort_seq, ag_doc_id
min_attachments (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
		SELECT * from codes where code_type ='asdfasdfasfa'
	
get_supp_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
		SELECT * FROM ag_item
		WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 6882 AND
		      rev_num = 0
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
	SELECT _rowid stop_id, descr, form_rte.stop_id chkd_stop_id, form_rte.stop_seq
	FROM rte_stop
	LEFT OUTER JOIN form_rte ON (UPPER(form_rte.form_id) = 'AG_MEMO' AND form_rte.form_num = 6882 AND form_rte.rev_num = 0 AND form_rte.stop_id = rte_stop._rowid)
	WHERE UPPER(rte_grp) = 'AG_MEMO'
getorig (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
	SELECT action_by, stat_date, de.fname, de.lname, de.title as utitle, w.dflt_rte_stop			
	FROM form_hist
	LEFT OUTER JOIN websecur AS w ON (w.login_id = form_hist.action_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	WHERE UPPER(form_id) = 'AG_MEMO' AND
	      form_num = 6882 AND
		  rev_num = 0 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=16ms, Records=9) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
		SELECT (hist.seq_num - 1) stop_seq, hist.stop_id, hist.action_by apprvl_id, hist.stat_date apprvl_date, 	
				hist.stat_action, hist.stat_action apprvl_stat, rte_stop.descr, rte_stop.prt_on_routing,
				de.fname, de.lname, de.title, fa.incl_originator		
		FROM form_hist hist
		INNER JOIN rte_stop ON (rte_stop._rowid = hist.stop_id AND rte_stop.prt_on_routing = 'Y')
		LEFT OUTER JOIN form_actions AS fa ON (UPPER(fa.form_id) = 'AG_MEMO' AND			
			                               fa.action_cd = 'AI86')
		LEFT OUTER JOIN websecur AS w ON (w.login_id = hist.action_by)
		LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
		WHERE UPPER(hist.form_id) = 'AG_MEMO' AND
			  hist.form_num = 6882 AND
			  hist.rev_num = 0 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:57:26.026
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 23:57:26.026
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3646

GetThisLine (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:57:26.026
				SELECT am.form_num fas_form_num, al._rowid ln_rowid, al.form_num, al.seq_num,
					   al.ag_level1 chk_level1, al.ag_level2 chk_level2, al.ag_level3 chk_level3,
					   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4, al.disp_level, am.ainumber,
					   as1.sort_seq sort_level1, al.ag_memo_id, al.ag_memo_rev, c1.descr ag_time_descr,
					   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
					   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
							mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
					   ai.*,
					   CASE WHEN al.ag_level2 != '' AND al.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,
					   CASE WHEN al.ag_level3 != '' AND al.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
					   CASE WHEN al.ag_level4 != '' AND al.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,
					   CASE WHEN al.ag_memo_id IS NOT NULL THEN al.ag_memo_id ELSE -1 END AS sort_memo,
					   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_time ELSE al.ag_time END as ag_time
				FROM agenda_ln al
				INNER JOIN agenda a ON (a.form_num = al.form_num AND a.rev_num = al.rev_num)
				LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
				LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
				LEFT OUTER JOIN ag_memo AS am ON (am.form_num = al.ag_memo_id AND am.rev_num = al.ag_memo_rev)
				LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
				
				INNER JOIN ss_ag_item AS ai ON (ai.form_num = 3645 AND ai._rowid = 86)
				
				LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
				LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = al.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(al.ag_level1 AS binary(8)))
				LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = al.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(al.ag_level2 AS binary(8)))
				LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = al.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(al.ag_level3 AS binary(8)))
				LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = al.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(al.ag_level4 AS binary(8)))
				LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id)
				LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size)
				WHERE al._rowid = 43612 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:57:26.026
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3645
					AND a.ag_level1 = '12'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:57:26.026
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3645
					AND a.ag_level1 = '12'
					AND a.ag_level2 = 'C'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:57:26.026
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3645
					AND a.ag_level1 = '12'
					AND a.ag_level2 = 'C'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
get_supp_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 23:57:26.026
					SELECT * FROM ag_item
					WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 23:57:26.026
					SELECT _rowid, seq_num, text_value
					FROM ag_memo_supp
					WHERE form_num = 6882 AND
					      rev_num = 0
					ORDER BY seq_num
				
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 23:57:26.026
	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 @ 23:57:26.026
	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 @ 23:57:26.026
		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 @ 23:57:26.026
		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=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
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=11&get_year=2022&dsp=agm&seq=6882&rev=0&ag=3645&ln=43612&nseq=6883&nrev=0&pseq=6881&prev=0
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=11&get_year=2022&dsp=agm&seq=6882&rev=0&ag=3645&ln=43612&nseq=6883&nrev=0&pseq=6881&prev=0
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=9101347
cftoken=9d432b8663deaa06-5FD1C2E7-BD2D-301F-23D50C7538A6D2A4
hitcount=4
lastvisit={ts '2024-04-17 23:57:26'}
timecreated={ts '2024-04-17 23:57:26'}
urltoken=CFID=9101347&CFTOKEN=9d432b8663deaa06-5FD1C2E7-BD2D-301F-23D50C7538A6D2A4
Cookie Variables:
CFID=9101347
CFTOKEN=9d432b8663deaa06-5FD1C2E7-BD2D-301F-23D50C7538A6D2A4
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=3645
DISPLAY_ID=6882
DISPLAY_REV=0
Session Variables:
cfid=9101347
cftoken=9d432b8663deaa06-5FD1C2E7-BD2D-301F-23D50C7538A6D2A4
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9101347_9d432b8663deaa06-5FD1C2E7-BD2D-301F-23D50C7538A6D2A4
subdir=/public/
tzoffset=0
urltoken=CFID=9101347&CFTOKEN=9d432b8663deaa06-5FD1C2E7-BD2D-301F-23D50C7538A6D2A4
URL Parameters:
ag=3645
dsp=agm
get_month=11
get_year=2022
id=
ln=43612
mt=ALL
nrev=0
nseq=6883
prev=0
pseq=6881
rev=0
seq=6882
Debug Rendering Time: 16 ms