CITY COUNCIL COMBINED WORK SESSION/SPECIAL MEETING
TUESDAY, SEPTEMBER 22, 2020
CITY HALL STAFF CONFERENCE ROOM
211 WEST ASPEN
3:00 P.M.

 
MINUTES
 
               
1.
Call to Order

Mayor Evans called the Work Session of the Flagstaff City Council held September 22, 2020, to order at 3: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 attendees recited the pledge of allegiance and Councilmember Whelan read the Mission Statement of the City of Flagstaff.

MISSION STATEMENT
 
The mission of the City of Flagstaff is to protect and enhance the quality of life for all.
 
3. ROLL CALL
 
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
 
PRESENT:

MAYOR EVANS (virtually)
VICE MAYOR SHIMONI (virtually)
COUNCILMEMBER ASLAN (virtually)
COUNCILMEMBER MCCARTHY (virtually)
COUNCILMEMBER ODEGAARD (virtually)
COUNCILMEMBER SALAS (virtually)
COUNCILMEMBER WHELAN (virtually)
ABSENT:









 
 
  Others present:  City Manager Greg Clifton; City Attorney Sterling Solomon.
 
4. Public Participation

Public Participation enables the public to address the council about items that are not on the prepared agenda. Public Participation appears on the agenda twice, at the beginning and at the end of the work session. You may speak at one or the other, but not both. Anyone wishing to comment at the meeting is asked to fill out a speaker card and submit it to the recording clerk. When the item comes up on the agenda, your name will be called. You may address the Council up to three times throughout the meeting, including comments made during Public Participation. Please limit your remarks to three minutes per item to allow everyone to have an opportunity to speak. At the discretion of the Chair, ten or more persons present at the meeting and wishing to speak may appoint a representative who may have no more than fifteen minutes to speak.
 
5. Beautification and Public Art Commission Update
Deliver an update to Mayor and Council on the Beautification and Public Arts Commission with time for questions and feedback. 
Mayor and Council requested periodic updates from Boards and Commissions to occur during special work sessions during months that contain five Tuesdays. 
  
 
6. Commission on Diversity Awareness Update
Deliver an update to Mayor and Council on the Commission on Diversity Awareness with time for questions and feedback. 
Mayor and Council requested periodic updates from Boards and Commissions to occur during special work sessions during months that contain five Tuesdays. 
  
 
7. Commission on Inclusion and Adaptive Living Update
Deliver an update to Mayor and Council on the Commission on Inclusion and Adaptive Living with time for questions and feedback. 
Mayor and Council requested periodic updates from Boards and Commissions to occur during special work sessions during months that contain five Tuesdays. 
  
 
8. Discussion: Possible strategies and timelines for the re-implementation of the pay-to-park and permit programs for the ParkFlag District including the Downtown and Southside areas.   
 
9. Priority Based Budgeting Public Engagement Plan   
 
10. Adjournment

The Work Session of the Flagstaff City Council held September 22, 2020, adjourned at 6:25 p.m.
 
SPECIAL MEETING
 
1.
Call to Order

Mayor Evans called the Special Meeting of the Flagstaff City Council held September 22, 2020, to order at 6:25 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. Consideration and Approval of Lease Amendments:  Amendment of Flagstaff Airport Leases to extend rent abatement for a minimum of three (3) months or a maximum of six (6) months, due to the ongoing economic impacts of the COVID-19 pandemic; and provide direction related to rent abatement for hangar permittees.   
 
  Moved by Councilmember Jim McCarthy, seconded by Councilmember Jamie Whelan to approve lease amendments to extend rent abatement for all airport tenants for three (3) months.
  Vote: 4 - 3
 
NAY: Councilmember Charlie Odegaard
  Councilmember Regina Salas
  Mayor Coral Evans
 
3. Public Participation
 
4. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests
 
5. Adjournment

The Work Session of the Flagstaff City Council held September 22, 2020, adjourned at 6:47 p.m.
 
CERTIFICATE OF POSTING OF NOTICE

The undersigned hereby certifies that a copy of the foregoing notice was duly posted at Flagstaff City Hall on                      , at                a.m./p.m. in accordance with the statement filed by the City Council with the City Clerk.

Dated this               day of                                       , 2020.



__________________________________________
Stacy Saltzburg, MMC, City Clerk
                                            


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


Execution Time

Total Time Avg Time Count Template
297 ms 297 ms 1 D:/inetpub/PublicPages/public/publish/print_minutes.cfm
203 ms 203 ms 1 D:/inetpub/PublicPages/public/publish/print_minutes_dsp.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 26 D:/inetpub/PublicPages/public/publish/clean_subject.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
297 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
all_codes (Datasource=frsRO, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.dataSortOrder sort_order, c.misc_alpha2,
		   CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 00:58:02.002
			select top 1 * from codes
		
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
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.final_stop fas_final_stop,
	   fas.date_final fas_date_final, fas.final_prt_date fas_final_prt_date,
	   ft.* ,
	   m.meeting_name, m.meeting_fromthru_time, m.meeting_dt, m.meeting_loc, m.meeting_id,
	   agt.ag_template_name, agt.ag_template_id, codes.long_descr px_size, codes.descr pdf_format,
	   cv.misc_alpha vote_position, cr.misc_alpha roll_position,
 	   mt.agmemo_prefix, mt.agmemo_desc, mt.logo_plcmnt, mt.printed_logo, mt.meeting_type,
 	    ct.descr vote_width, crt.descr roll_format, crt.long_descr roll_px_size,
	   am.long_descr vote_label, am.misc_alpha motion_verbiage, 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,
	   amm.misc_alpha prt_att_links, amm.misc_alpha3 page_start, amm.text_value1 pdf_header, amm.text_value2 pdf_footer,
	   amm.misc_alpha9 printLine
FROM fas
INNER JOIN MINUTES AS ft ON (ft.form_num = fas.form_num)
INNER JOIN form_hist ON (form_hist.form_id = fas.form_id AND 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 fas.form_id = 'MINUTES' AND
	  fas.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 523

get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 00:58:02.002
		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) = 1113

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
		SELECT descr, long_descr, valid_code from codes WHERE code_type = 'AG_FONT'
	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
		SELECT long_descr, descr from getFonts
		WHERE valid_code = 'mediumText'
	
final_check (Datasource=frsRO, Time=0ms, Records=13) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 1112 
getAllLines (Datasource=frsRO, Time=32ms, Records=18) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
SELECT ml._rowid _rowid, ml.form_num, ml.rev_num, ml.seq_num, ml.motion_text,  
	   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.header_ln, ml.page_br,	
	   c.descr as status_desc,

	   ai.box1_label, ai.disp_title, ai.box1_disp, ai.box2_label, ai.box2_disp, ai.box3_label, ai.box3_disp, ai.box4_label,
	   ai.box4_disp, ai.box5_label, ai.box5_disp, ai.box6_label, ai.box6_disp, ai.box7_label, ai.box7_disp,
	   ai.print_time, ai.time_label, ai.ainumber_label, ai.lbl_bold, ai.lbl_underline, ai.lbl_size,
	   ai._rowid as 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.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, ml.ag_title ag_heading,
	   ml.header_ln, ml.footer_ln, ml.color_impact, 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_action ELSE ml.ag_action END as ag_action,
	   CASE WHEN ml.ainumber IS NOT NULL THEN ml.ainumber ELSE am.ainumber END as ainumber
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 = 1112 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 = ?
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, ainumber, sort_memo
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 523

getLines (Datasource=, Time=0ms, Records=16) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
			
	SELECT *
	FROM getAllLines
	WHERE getAllLines.header_ln = 'N' AND getAllLines.footer_ln = 'N'
	ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, ainumber, sort_memo
getHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
	select * from getAllLines where header_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
getFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
	select * from getAllLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
getheader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
		SELECT *
		FROM getAllLines
		WHERE getAllLines.header_ln = 'Y'
		ORDER BY header_ln DESC, sort_level1, sort_level2, sort_level3, sort_level4
	
all_docs (Datasource=frsRO, Time=15ms, Records=28) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
		
	SELECT docs.sort_seq, docs.doc_name, docs.doc_link, docs.doc_dir,
			docs.confidentiality, docs.from_agenda,
			ml.form_num, ml.rev_num, ml._rowid ml_rowid
	FROM minutes_ln ml,
		 minutes_docs docs
	WHERE ml.form_num = 523 AND
		  docs.form_num = ml.form_num AND
		  docs.rev_num = ml.rev_num AND
		  docs.ln_rowid = ml._rowid
all_minutes (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
	SELECT *
	FROM meeting_minutes
	WHERE form_num = 523 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 
allMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
		SELECT motion.ln_rowid, motion.motion_seq, motion.motion_text,
				motion.time_of_vote, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
			   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
			   c.descr status_desc
		FROM minutes_ln_motion motion
		LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
											  r.rev_num = motion.rev_num AND
											  r.valid_code = motion.motion_id)
		LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
											  r2.rev_num = motion.rev_num AND
											  r2.valid_code = motion.second_id)
		LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG STATUS' AND c.valid_code = motion.motion_status)
		WHERE motion.form_num = 523 AND
			  motion.rev_num = 0 AND
			  (motion.motion_status IS NULL OR motion.motion_status <> 'VERBIAGE')
		  AND (motion.obsolete <> 'Y' OR motion.obsolete IS NULL)
		ORDER BY motion.ln_rowid, motion.motion_seq
	
allVotes (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 00:58:02.002
		SELECT v.ln_rowid, v.motion_seq, v.valid_code, v.vote,
			   r.name, r.title, c2.descr vote_descr, c2.long_descr vote_type,
			   c2.misc_alpha3 disp_in_vote,
			   v.seq_num sort1, motion.time_of_vote, m.meeting_id,
			   c3.misc_alpha motion_verbiage, c3.long_descr vote_label,
			   CASE WHEN c2.long_descr = 'Y' THEN 1
			   		WHEN c2.long_descr = 'N' THEN 2
					ELSE 3 END AS sort2
		FROM minutes_ln_vote AS v
		INNER JOIN minutes AS m ON (m.form_num = v.form_num AND
								m.rev_num = v.rev_num)
		INNER JOIN minutes_roll AS r ON (r.form_num = v.form_num AND		
											  r.rev_num = v.rev_num AND
											  r.valid_code = v.valid_code)
		INNER JOIN codes AS c2 ON (c2.code_type = 'AG_VOTEOTHER' AND c2.valid_code = v.vote AND c2.misc_alpha3 = 'Y')
		LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'MinAddl' AND
			c3.valid_code = CAST(m.meeting_id AS varchar))
		LEFT OUTER JOIN minutes_ln_motion motion ON
						(motion.form_num = v.form_num AND
					 	 motion.rev_num = v.rev_num AND
					 	 motion.ln_rowid = v.ln_rowid AND
					 	 motion.motion_seq = v.motion_seq AND
					 	(motion.motion_status IS NULL OR motion.motion_status <> 'VERBIAGE')
		 AND (motion.obsolete <> 'Y' OR motion.obsolete IS NULL)
			 )
		WHERE v.form_num = 523 AND
			  v.rev_num = 0 AND (v.obsolete <> 'Y' OR v.obsolete IS NULL) 
		ORDER BY sort2, sort1						
		
qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 00:58:02.002
			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(1113 as varchar)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = MinPad

attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12621
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12621 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12621 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12622
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12622 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12622 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12623
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12623 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12623 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 8559 
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12624
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12624 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12624 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12633
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12633 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12633 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12634
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12634 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12634 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12635
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12635 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12635 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12632
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12632 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12632 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12636
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12636 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12636 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12625
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12625 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12625 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12626
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12626 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12626 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12627
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12627 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12627 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=20) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12637
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12637 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12637 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				SELECT * from sortList
				ORDER BY seqNum
			
getMotions (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle	
				        		,v.motion_text motion_verbiage, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
				        LEFT OUTER JOIN minutes_ln_motion v ON (v.form_num = motion.form_num AND
				        										v.rev_num = motion.rev_num AND
				        										v.ln_rowid = motion.ln_rowid AND
				        										v.motion_seq = motion.motion_seq AND
				        										v.motion_status = 'VERBIAGE'
				        										)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 3014 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
		 				SELECT *
						FROM getmotions
						WHERE ln_rowid = 12637 AND
						      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:02.002
							SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label	
							FROM allVotes
							WHERE allVotes.ln_rowid = 12637 AND
								  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 00:58:02.002
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 00:58:02.002
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
attachments (Datasource=, Time=157ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:03.003
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12628
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:03.003
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12628 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:03.003
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12628 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:03.003
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:03.003
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12629
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:03.003
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12629 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:03.003
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12629 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:03.003
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:03.003
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 523 AND
					  rev_num = 0 AND
					  ml_rowid = 12630
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:03.003
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 12630 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:03.003
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 12630 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 00:58:03.003
				SELECT * from sortList
				ORDER BY seqNum
			


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\public\publish\print_minutes.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=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFID=9763362; CFTOKEN=a83ec4db506df273%2D9CD67AD4%2D00F1%2D61D9%2D6DADC8C5EB267CD2
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=http://cityweb.flagstaffaz.gov/agendaquick/print_minutes.cfm?seq=523&id=&mode=External&reloaded=true
HTTP_URL=//public/publish/print_minutes.cfm?seq=523&id=&mode=External&reloaded=true&CFID=9763362&CFTOKEN=a83ec4db506df273-9CD67AD4-00F1-61D9-6DADC8C5EB267CD2
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\public\publish\print_minutes.cfm
QUERY_STRING=seq=523&id=&mode=External&reloaded=true&CFID=9763362&CFTOKEN=a83ec4db506df273-9CD67AD4-00F1-61D9-6DADC8C5EB267CD2
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/public/publish/print_minutes.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=9763362
cftoken=a83ec4db506df273-9CD67AD4-00F1-61D9-6DADC8C5EB267CD2
hitcount=4
lastvisit={ts '2024-05-14 00:58:02'}
timecreated={ts '2024-05-14 00:58:02'}
urltoken=CFID=9763362&CFTOKEN=a83ec4db506df273-9CD67AD4-00F1-61D9-6DADC8C5EB267CD2
Cookie Variables:
CFID=9763362
CFTOKEN=a83ec4db506df273-9CD67AD4-00F1-61D9-6DADC8C5EB267CD2
Session Variables:
cfid=9763362
cftoken=a83ec4db506df273-9CD67AD4-00F1-61D9-6DADC8C5EB267CD2
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9763362_a83ec4db506df273-9CD67AD4-00F1-61D9-6DADC8C5EB267CD2
subdir=/public/
tzoffset=0
urltoken=CFID=9763362&CFTOKEN=a83ec4db506df273-9CD67AD4-00F1-61D9-6DADC8C5EB267CD2
URL Parameters:
CFID=9763362
CFTOKEN=a83ec4db506df273-9CD67AD4-00F1-61D9-6DADC8C5EB267CD2
id=
mode=External
reloaded=true
seq=523
Debug Rendering Time: 15 ms