Return
CITY COUNCIL WORK SESSION
TUESDAY, DECEMBER 10, 2019
CITY HALL COUNCIL CHAMBERS
211 WEST ASPEN
 6:00 P.M.

 
MINUTES
             
1.
Call to Order

Vice Mayor Shimoni called the Work Session of December 10, 2019, to order at 6:00 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 audience recited the Pledge of Allegiance and Deputy City Manager Anderson 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:

VICE MAYOR SHIMONI
COUNCILMEMBER MCCARTHY
COUNCILMEMBER SALAS
COUNCILMEMBER WHELAN
ABSENT:

MAYOR EVANS
COUNCILMEMBER ASLAN

COUNCILMEMBER ODEGAARD
             
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.
  Aaron Kane addressed Vice Mayor and Council regarding declaring a climate emergency in the City of Flagstaff.
             
5.
Review of Draft Agenda for the December 17, 2019 City Council Meeting
Citizens wishing to speak on agenda items not specifically called out by the City Council may submit a speaker card for their items of interest to the recording clerk.
  Councilmember Whelan stated that she will send some questions to staff by email and Vice Mayor Shimoni stated that he had his questions answered on Monday. 
             
6. Flagstaff Airport Parking Update
  Airport Director Barney Helmick gave a presentation to Council regarding the temporary parking solution, winter snow parking, and the permanent parking program. Operations/ARFF Manager Tim Skinner, Public Works Senior Project Manager Adam Miele, and Streets Director Scott Overton joined Mr. Helmick in the presentation. Mr. Helmick discussed the successes and the challenges at the airport. There are currently 385 parking spots at the airport with an average of 335 passengers per day with about 500 cars parking at the airport each day.
 
Mr. Overton took over the presentation. He stated that the permanent parking solution is being worked on and addressed the challenges faced by the airport. He also discussed the current temporary solutions and the steps that have been taken regarding design of a permanent solution. Within three weeks of identifying the need for a temporary solution, a parking lot with 235 temporary spaces was developed.
 
Vice Mayor Shimoni asked who will park in the new parking lot. Mr. Overton stated that there are two areas and everything to the east of the watershed is for rental car parking and everything to the west is for airport employees, TSA employees, and overflow airport patrons.
 
Councilmember Whelan asked how many spaces are left for patrons after employees park in the lot. Mr. Helmick stated that there are about 135 employees working just in the terminal facilities. He elaborated that there is a daily average of 45 employees parking with 100 parking spots designated for employees and temporary overflow.

Mr. Skinner resumed the presentation and addressed the controls of the temporary parking lot. He reviewed the map of the overflow parking and the temporary lot.
 
Mr. Helmick added that another factor in the creation of the temporary lot was winter snow removal since snow plows could not get through when cars are parked illegally in the roadway and in the landscaping. He also covered the Request for Information (RFI) for a permanent parking solution and the challenges with the RFI and the next steps. He stated that there is an aggressive timeline with the hope of starting on the next steps in the spring.
 
Councilmember Whelan asked how much growth the permanent parking lot would encompass. Mr. Helmick stated that they will know more after the concept plan is completed. The existing parking lot is supposed to manage today’s numbers, but the numbers are not accurate. Councilmember Whelan asked about potential growth at the airport and if the parking lot will be large enough to incorporate potential growth. Economic Vitality Director Heidi Hanson added that an Airport Master Plan for 20 years was approved earlier this year and it includes parking. They were looking at surface parking versus a vertical parking structure because of pricing. Also, a two-lot solution was identified to create short-term and long-term parking lots with a paid parking solution. She believes that the lot would last for at least five years, but she does not know how the commercial growth will develop. United Airlines has seen 90% load rate when they expected a 70% load rate. Ms. Hansen stated that she expects to see more routes in the future and that American Airlines is currently seeing about a 78% load rate.
 
Vice Mayor Shimoni asked if there is adjacent land next to the parking lot to expand. Mr. Helmick added that the old master plan identified a second permanent lot location. The cost of a vertical parking structure was identified to be about $8 million dollars ten years ago versus $3 million to develop the surface lot. There would be options in the future to develop a parking structure. Vice Mayor Shimoni asked NAIPTA CEO Erika Mazza about the participation of NAIPTA at the airport. Ms. Mazza stated that there is currently a route there and that there could be more routes developed. The initial proposal is for the route to run from the downtown connection center through Ponderosa Trails.
 
Councilmember Whelan inquired about the purchase of the land by the hospital off I-17 and to see if NAIPTA has looked at running a temporary shuttle in that area for a test. Ms. Mazza stated that there is a nominal difference between a shuttle and a fixed route bus. They have not looked at a shuttle solution at this time, but that if the will of the organization is to try a shuttle to start, that is a possibility. NAIPTA is happy to support this project in any way possible. Councilmember Whelan added that she believes that the airport usage will continue to grow and that she would like to put in a structure that can handle the growth along with transit rather than addressing it in another ten years. She is concerned that the project will not last if future growth is not taken into consideration.  
 
Vice Mayor Shimoni stated that the parking needs could be based on the downtown parking model and can be done with phases like the downtown parking model as money is raised. Mr. Helmick added that building a parking garage would close the front lot, so that a new lot would be necessary. Mr. Helmick added that if the lot does not fill up,it could be used for a park and ride if a transit route is established.
 
Councilmember Whelan asked about hotel shuttle service. Mr. Helmick and Ms. Hansen stated that they have had discussions with hotels in the area on that subject.
 
Mr. Helmick resumed the presentation. He shared the initial conceptional design created by Mr. Miele and then addressed the potential of a paid parking system. Mr. Helmick is not convinced that a kiosk system would work well at the airport and recommended a gate arm system. Over a twenty-year period, the paid lots would pay off the required loan and would create additional revenue as well. The cost of the parking lots would come back to Council for direction and a decision.
 
Councilmember Whelan asked if the overflow lot has lights at this time. Mr. Helmick stated that there are not, but there are plans to do so. Mr. Miele stated that there are plans to get dark-sky compliant lighting there as soon as possible. The staff parking lot overflow area would be in the temporary lot until the construction on the new permanent lot is completed.
 
Councilmember Salas stated that she is looking forward to the next presentation and invited everyone to look at budget requirements for capital improvements for the necessary improvements and maintenance of the airport. She added that the City needs to identify permanent revenue streams for the airport. Ms. Hansen stated that a paid parking system would be one revenue stream that would allow for improvements to the airport. Staff will come in front of Council again regarding the 32-acre parcel to see what to do with it to create an additional revenue stream for the airport.
         
Slides included in the presentation were:
  • Airline Success and Airport Parking
  • Temporary Parking Solution
  • Winter Snow & Parking
  • Permanent Parking System
             
7. Flagstaff Metropolitan Planning Organization (FMPO) Update
  FMPO Executive Director Jeff Meilbeck reported to the Council on the progress of FMPO transitioning to an independent organization. He stated that Councilmember McCarthy serves on the FMPO Board with Councilmember Salas as an alternate and Councilmember Odegaard and Mayor Evans also serve on the Board. FMPO has been hosted by the City of Flagstaff for the past 20 years. He discussed the plans for becoming independent, the potential expansion of the Board, and the reasons for the change. He also thanked the CVB staff for their assistance with the rebranding effort. Mr. Meilbeck thanked the City of Flagstaff for their support.
 
Slides included:
  • Rebrand and Independence
  • Why Metroplan Exists
  • Vision
  • Mission
  • Rebranding to Metroplan
  • Project Description
  • Timeline
 
Councilmember McCarthy asked if going independent is revenue neutral or if it will take additional resources to cover staffing for HR, office space, legal, and more. Mr. Meilbeck stated that the increased costs are estimated to be about $20,000 a year.
 
Councilmember Whelan asked how FMPO was originally funded, how the City is part of the funding, and where FMPO wants to be when they are independent. She wanted to see where the funds come from. Mr. Meilbeck replied that because the metropolitan organization was formed that the organization and the City became eligible for federal funding. Approximately $750,000 a year comes to the FMPO. The City provided services to FMPO and some of the awarded grants received would go to the City to pay for the services. The City for the past ten years or so has made a $22,500 a year contribution in matching funds so that about $750,000 in federal funds could be accepted.
 
Vice Mayor Shimoni reiterated that the reason for FMPO to go independent is for more flexibility. Mr. Meilbeck stated that his synopsis is correct. Vice Mayor Shimoni asked Mr. Meilbeck to review the timeline. He asked if Mr. Meilbeck is planning to come back to Council for another presentation. Mr. Meilbeck stated that he does not have a date scheduled at this time, but he will try to set up annual updates at least. Vice Mayor Shimoni asked for the FMPO to come back perhaps in the fall and to let Council know if there are any major hurdles that the City can assist with. Mr. Meilbeck stated that the process is moving ahead and that he can come back in the fall next year with an update. He believes that the timeframe is realistic at this time and does not anticipate challenges. If the FMPO is unable to make the deadline to become independent by January 1, 2020, there is an agreement in place for the City to host the organization for another year.
 
Councilmember McCarthy stated that the long-term goal is reorganization which could result in larger and more grants. Mr. Meilbeck agreed.
             
8. Public Participation
  None
             
9. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests
  Councilmember Salas spoke about the meeting with the Chamber last night.
 
Deputy City Manager Anderson notified that the two F.A.I.R. items for the January 7, 2020 meeting were requested to be pulled by the proposing Councilmember. The first was an item proposed by Vice Mayor Shimoni to have a discussion about cyclist safety infrastructure and planning, evaluate the plan and how the City approaches cyclist safety. The second F.A.I.R. item pulled was proposed by Mayor Evans to have a presentation by Citizens Climate Lobby to brief the Council on HR 763: The Energy Innovation & Carbon Dividend Act. A community meeting will be planned on this topic.
 
Councilmember McCarthy asked that the Council be emailed stating that the two F.A.I.R. items had been withdrawn.
 
Vice Mayor Shimoni added his reasons for removing the F.A.I.R. item. He added that tomorrow there is a 2020 Census Open House.
 
             
10. Adjournment

The Flagstaff City Council Work Session of December 10, 2019, adjourned at 7:05 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 25-Apr-24 02:26 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
172 ms 172 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
125 ms 125 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
125 ms 125 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.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
188 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 14:26:08.008
			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 @ 14:26:08.008
				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 @ 14:26:08.008
			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 @ 14:26:08.008
				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 @ 14:26:08.008
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 14:26:08.008
	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 @ 14:26:08.008
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 14:26:08.008
		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 @ 14:26:08.008
	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 @ 14:26:08.008
		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 @ 14:26:08.008
	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 @ 14:26:08.008
	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 @ 14:26:08.008
		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 @ 14:26:08.008
		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 @ 14:26:08.008
	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 @ 14:26:08.008
	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 @ 14:26:08.008
	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 @ 14:26:08.008
	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 @ 14:26:08.008
	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 @ 14:26:08.008
	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 @ 14:26:08.008
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 14:26:08.008
	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=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 14:26:08.008
		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) = 2019-12-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2019-12-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 14:26:08.008
			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(935 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 @ 14:26:08.008
	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 @ 14:26:08.008
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 934 
getAllMnLines (Datasource=frsRO, Time=32ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
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 = 934 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 = 446 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=10) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
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 @ 14:26:08.008
	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 @ 14:26:08.008
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
		
	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 = 446 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 446 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 @ 14:26:08.008
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 9950 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 9955 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 9948 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 9949 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6742 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 9951 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6743 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 9957 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6745 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 9958 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6746 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 9953 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6747 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 9952 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6748 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 9954 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 14:26:08.008
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 14:26:08.008
	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 @ 14:26:08.008
	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 @ 14:26:08.008
		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 @ 14:26:08.008
		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=12&get_year=2019&dsp=min&seq=935
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=12&get_year=2019&dsp=min&seq=935
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=9284587
cftoken=dce85ea9ab7cdb60-E757C16B-B013-2BBD-C48C568A57C204B5
hitcount=4
lastvisit={ts '2024-04-25 14:26:08'}
timecreated={ts '2024-04-25 14:26:08'}
urltoken=CFID=9284587&CFTOKEN=dce85ea9ab7cdb60-E757C16B-B013-2BBD-C48C568A57C204B5
Cookie Variables:
CFID=9284587
CFTOKEN=dce85ea9ab7cdb60-E757C16B-B013-2BBD-C48C568A57C204B5
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=935
Session Variables:
cfid=9284587
cftoken=dce85ea9ab7cdb60-E757C16B-B013-2BBD-C48C568A57C204B5
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9284587_dce85ea9ab7cdb60-E757C16B-B013-2BBD-C48C568A57C204B5
subdir=/public/
tzoffset=0
urltoken=CFID=9284587&CFTOKEN=dce85ea9ab7cdb60-E757C16B-B013-2BBD-C48C568A57C204B5
URL Parameters:
dsp=min
get_month=12
get_year=2019
id=
mt=ALL
seq=935
Debug Rendering Time: 0 ms