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

 
MINUTES
             
1.
Call to Order

Mayor Evans called the Work Session of February 26, 2019, to order at 6:00 pm.

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 Councilmember Aslan 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
VICE MAYOR SHIMONI
COUNCILMEMBER ASLAN
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD
COUNCILMEMBER SALAS

COUNCILMEMBER WHELAN
ABSENT:








             
4. Public Participation

Public Participation enables the public to address the council about items that are not on the prepared agenda. Public Participation appears on the agenda twice, at the beginning and at the end of the work session. You may speak at one or the other, but not both. Anyone wishing to comment at the meeting is asked to fill out a speaker card and submit it to the recording clerk. When the item comes up on the agenda, your name will be called. You may address the Council up to three times throughout the meeting, including comments made during Public Participation. Please limit your remarks to three minutes per item to allow everyone to have an opportunity to speak. At the discretion of the Chair, ten or more persons present at the meeting and wishing to speak may appoint a representative who may have no more than fifteen minutes to speak.

None
             
5.
Review of Draft Agenda for the March 5, 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.

None
             
6. Discussion:  Airport Marketing/Promoting, United Airlines Minimum Revenue Guarantee Agreement, Air Carrier Incentive Policy, and United and American Airline Lease Agreements
  Economic Vitality Director Heidi Hansen gave a presentation on airport marketing, the small community air service revenue guarantee grant, air carrier incentive policy and American and United Airlines lease agreements. She was joined by Grants and Contract Manager Stacey Brechler-Knaggs, Airport Director Barney Helmick, Senior Assistant City Attorney Christina Rubalcava, and Real Estate Manager Charity Lee. The purpose of the presentation was to give Council a background on the airport before the regular meeting where the Flagstaff Airport Air Carrier Incentive Policy, the Minimum Revenue Guarantee Agreement for air services between the City and United Airlines, and the lease agreement with United Airlines will be considered.

Highlights from the presentation included a discussion on marketing campaigns targeted to raise enplanements. The "Always Fly First” campaign raised enplanements by 3% and the 
“I always fly Flagstaff first” resulted in a 9.2% increase in enplanements. One-on-one meetings with airlines and consultants at airline specific conferences resulted in new ideas on how to present the airport to prospective airlines and allowed staff to design a collaborative piece highlighting things airlines want to know. The brochure created was key in making meetings with airline executives impactful. Staff held local presentations that allowed for conversations to figure out needed routes for Flagstaff area residents and businesses. An Airport Annual Report was created that included all things important to an airline and shared with prospective airlines. All these strategies were key in attracting an additional airline at the Flagstaff Pulliam Airport.

Stacey Brechler-Knaggs resumed the presentation and spoke about the contract with United Airlines and the minimum revenue guarantee (MRG) agreement. She reported that in September 2011, the City received a small community air service development grant in the amount of $800,000. The City has received five extensions to continue the effort to market for a new service and/or route. Starting on March 31, United Airlines will be a new service provider and will receive the MRG for operating flights out of Flagstaff. This is the first time the City has offered an MRG. United Airlines researched what the minimum revenue needed (MR) per month to operate in Flagstaff is. If the actual revenue received is less than the minimum revenue required, the City will pay the difference out of the grant funds. If United Airlines meets their MR, they do not receive funds. If they exceed the monthly MR, they will apply that revenue to the next month. The MRG is calculated quarterly. The MRG is available for one year in an amount not to exceed $550,000 and The funds are 100% grant funded with no match needed from the City. There is a termination clause of 90 days to terminate the MRG and the lease agreement. 

Councilmember Whelan thanked Ms. Brechler-Knaggs for her service and asked about the grant. She asked if it was solely earmarked for the MRG. Ms. Brechler-Knaggs stated that it is almost only available for a new airline, but that there was a little money available upfront for marketing. The MRG term is for one year (March 31, 2019 to March 31, 2020). United Airlines stated that they are expecting a minimum revenue of about $40,000 a month, and the MRG will be used to meet the minimum revenue if needed. Councilmember Whelan also asked about the term lease of 10-years. Ms. Lee will address the lease agreements later in the presentation. 

Councilmember McCarthy asked where the MRG comes from. Ms. Brechler-Knaggs stated that the MRG is a federal grant.

Mr. Helmick explained that the process to find a new airline has been ongoing for over six years. In that time, staff learned that a lot of airports have incentive policies. They learned about established guidelines. Staff is strongly encouraging two more markets at the Flagstaff airport: Los Angeles and San Francisco. The MRG, which is only for new airlines, offers the least risk for the City. If an existing airline wanted to add an additional route, the City could waive the landing fee as an incentive. 

Councilmember Whelan asked what the City uses the landing fees for. Mr. Helmick answered that landing fees are a revenue stream for the airport. The biggest revenue stream for the airport is from rental cars. The least producing revenue piece comes from the landing fees. 

Ms. Lee took over the presentation to address lease agreements. Staff has worked on creating a new lease template for commercial services. They have focused on United Airlines and have temporarily suspended the American Airlines’ lease renewal until this process is done to ensure that both airlines have the same terms. There have been no changes thus far. The lease term is for ten years and allows for two five-year extensions. Either party can terminate the lease with a 90-day written notice. The rental amount per the lease is $36,000 per year for 1,027 square feet of Ticket Counter space/storage and an additional rental fee of $30.74 for 144 square feet of office space. Only American Airlines is utilizing that option at this time. Semi-Permanent storage unit space is available for an additional rental fee of $0.34 per square foot. The landing fee is waived for one year under an Incentive Agreement, but it is normally $1.09 per thousand pounds of declared maximum certified gross landing weight of aircraft. There is a rate adjustment of 2% increase annually on the $36,000 base rent per year on the lease anniversary. The City agreed to pay utilities (water, gas, sewer electric) per the lease, however the airlines are responsible for all taxes and fuel costs. 

Ms. Hansen summed up the presentation and explained the goals of the presentation were to explain the: marketing successes, the MRG, the lease agreement, and revenue generation. She also expressed that the benefits of having a great transportation system in Flagstaff is to not just expand tourism, but to also assist businesses, such as telecommuters and small business, with east coast connections. It will also assist with competition and capture lost revenue. Currently 80% of the commercial airline market is driving to Phoenix for flights. Adding a new airline and increasing service routes will increase the number of flights to Phoenix and will hopefully cut costs to the consumer.

Vice Mayor Shimoni thanked staff for the work and is excited about the agreement and about flying out of Flagstaff. 

Councilmember Aslan commented that he thinks that there is an opportunity cost in flying versus driving due to the carbon footprint and would like to see offsets for carbon. He asked if there were any direct flights to Tucson planned. Mr. Helmick stated that Tucson is not a top 25 destination and it would be difficult to get a flight over a major hub like Phoenix. There are over 300 destinations now available with only one layover provided by the new routes. Councilmember Aslan asked if there had been any sound impact studies in the neighboring communities. Mr. Helmick replied that there was a study done in 2008 when prop planes, which are louder, were prevalent. The new commercial air service change may increase commercial flights by about 2,000 flights a day. Councilmember Aslan stated that he had not noticed a change in the noise level in his neighborhood, which borders the airport.

Councilmember Whelan stated that she loves flying out of the Flagstaff airport and thanked airport staff for their positive attitude.

Ms. Hansen stated that additional signage will be added to the airport to mitigate traffic. An additional restroom and beverage service will be available after the security checkpoint to increase security efficiency.

Councilmember Odegaard stated that he was looking to book a flight with the new routes. He asked about the competitiveness of the prices of flights.  Mr. Helmick stated that the competition is there right now and that there are sweet spots to buy tickets between six to eight weeks before your flight. He purchased a flight for $236 to Monterey, CA. 
 
             
7. Update to the Work Programs for Comprehensive Planning and Development Codes (Zoning, Subdivision, and Related Codes)
  Zoning Code Manger Daniel Symer, Comprehensive Planning Manager Sara Dechter, and Planning Manager Tiffany Antol reviewed the updates to the work programs and the program updates. Ms. Antol stated that the last time an update was given to Council was in January 2018. The objectives were: to increase familiarity with the Work Program and Development Codes; introduce Daniel Symer as the new Zoning Code Manager; review projects and plans; and receive feedback on program priorities from Council. 

Mr. Symer thanked the Council and led the first section of the presentation. He stated that he has been in planning for 21 years and is happy to be a part of the City of Flagstaff. He explained that the Zoning Code Manager lives in the Implementation zone of the planning pyramid and works to make the community a better place. Implementation is based off the zoning codes, the Regional Plan, and the policies currently in place and Mr. Symer's role is to ensure that policies can be implemented. He explained the primary responsibilities of the Zoning Code Manager adn that he works as the Zoning Code Administrator for Development Codes which includes Intra-City Coordination and Assistance, Public Assistance, and working as the Board of Adjustment Liaison. He also works on the development of code amendments; and works with project management including variance applications and zoning verification.

Mr. Symer gave an overview of Zoning Code Manager accomplishments which included: an amendment to the conditional use permit approval process, West University Drive entrance sign district, comprehensive review of the zoning code to identify inconsistences, coordinating with the City Clerk’s office and the city’s codifier to correct codification errors and inconsistencies, and drafted code revisions. The code was vetted against the existing code by a consultant before Mr. Symer came on board, which was a great help to him when he started. The code review created three updates to the current codes. There are currently two codes with the codification company that are being published and one with legal at the time of this update.

Mr. Symer reviewed the Planning & Zoning Projects Timeline and gave examples of individual projects that makeup the high-level program description. The codes will be reviewed based off the established timeline that he presented and reviewed for Council. He gave an example of the lighting code when discussing the implementation issues in the projects timeline. He stated that codes need updates to get caught up with technology and that all the codes crossover each other. As they work on each plan, a code may be affected by those changes in multiple plans. Having an overlap in the projects timeline helps focus the project all the way through and the plan is contingent on funding a consultant.

Mr. Symer reviewed the Zoning Code Program key points. He touched on the existing code implementation and enforcement issues and reiterated that the proposed work program timeline is reliant on funding the existing consultant
 
Mayor Evans commented that over the years she has asked for the Regional Plan to be linked to the Zoning Code for the lay-person to be able to use. She would like to see that implemented. For example, she would like to see the high-density areas in the Regional Plan link to the high-density zoning codes. Mr. Symer stated that it is challenging because there is an outside codifier. He suggested linking the area in the Regional Plan to a main page that has a directory for the codes. Mayor Evans stated that she has seen this in other municipalities. She feels that this would be very useful to the community.
 
Vice Mayor Shimoni expressed that he is looking forward to the work ahead and excited to see the accomplishments. He advocated to place High Occupancy Housing (HOH) and bed ratios as a top priority and asked where they currently lie in the timeline. Mr. Symer stated that the priority is high, and HOH is listed in the administrative modifications. He would like to tackle it this year, potentially starting in the summer. He also has the bed ratios as a priority project.
 
Councilmember Whelan added that it is good to have Mr. Symer on board. She appreciates Mr. Symer taking the time to work to change the code only once. She stated that she was partially elected based on her stances on zoning codes that allowed for buildings that are not appropriate in the area they were built that brought parking issues to the community. She would like to complete the zoning updates for the “bigger fires” soon. She asked how to do this in a timely way. Mr. Symer responded that parking is on his list as a priority. He is working on getting a base-line on parking and has handed off a big chunk of that for review. Parking and dwelling units are a priority for him. The consultant will need to be on board because it takes a lot of field work to complete the studies needed and Mr. Symer believes having an independent analysis would be beneficial for the community. The 60 foot height restriction has been in place for 50 years and needs to be addressed. He asked that specific zoning concerns be sent to the City Manager. Councilmember Whelan stated that redoing a map of the zoning code would be something the Council would be ready to tackle today. She would love to see movement forward and is afraid that the changes to the code are being put off. Mr. Symer stated that there are some areas that may be able to move forward soon. Councilmember Whelan asked if Mr. Symer could be the delegator of the sections to consultants. Mr. Symer stated that this is the idea and he will be focusing on the administrative modifications. The idea is to delegate the assignments and get the base-line information collected first.
 
Councilmember McCarthy stated that the most common concern he received when campaigning was land use issues. He stated that the push back against inappropriate land use needs to be harder. When budget time comes, he stated that he believes that the Planning section needs to have additional staff since the workload is demanding and more help may be needed to move along faster. He stated that the headcount may need to be increased.
 
Vice Mayor Shimoni addressed the “little brush fires” and stated that until those are dealt with he does not know why the focus should be on cleaning up. Mr. Symer stated that the amendments he is working on are to minimize the City’s vulnerability. The redundancy will be reduced at the same time.
 
Mayor Evans clarified that the reason that changes are taking longer than the Council would like to see is to ensure that a change to code does not exacerbate other areas of the code.
 
Councilmember Odegaard thanked Mr. Symer. He stated that the Zoning Code booklet is thicker than the budget book. He added that he hopes for an element of education for the community, especially on lighting, rather than enforcement first.
 
Ms. Sara Dechter resumed the presentation. She stated that the Comprehensive Planning Program encompasses the Regional Plan area and the specific plans area of the planning pyramid. Ms. Dechter does project management for area plans and specific plans; inter- and intra-government coordination and Regional Plan implementation; and Regional Plan amendments and development application review. She works with the Current Planner to make sure analysis is consistent with the Regional Plan. For the next two years, Ms. Dechter’s focus will be re-centered on the census. The census, which occurs every ten years, increases the distribution of time she spends on inter- and intra-government coordination. Ms. Dechter shared her other duties as well.

She also covered the Comprehensive Planning accomplishments, including completion of the High Occupancy Housing Plan, the public participation opportunities for the Southside Community Plan, the formation of a joint Census Team, and the 4th Regional Plan Annual Report. Ms. Dechter shared the Planning & Zoning Projects Timeline for the Comprehensive Planning Program work. She anticipates that the Census and the Bus Rapid Transit Program will impact the timeline and has adjusted the timeline accordingly in this presentation.

Mayor Evans asked if other planners are involved in these projects. Ms. Dechter responded that there is an Associate Planner and that he takes on some projects for her. Ms. Dechter is the Comprehensive Planner and is assisted by the Associate Planner. About 60% of the Associate Planner's time is dedicated to this program. She also has two interns. There is not a specific Neighborhood Planner.
 
Mayor Evans inquired about the La Plaza Vieja plan. Ms. Dechter replied that the La Plaza Vieja neighborhood requested a zoning code change that creates a character overlay for home design. The neighborhood wanted the City to consider the character overlay for the historic district. Mayor Evans clarified her understanding that Ms. Dechter’s department works to complete the plan to bring it to Council for possible approval. If approved, the plans go back to Zoning and other departments. Ms. Dechter added that the La Plaza Vieja plan included park improvements, transportation, and infrastructure improvements. All of the projects have come from the neighborhood plan.  
 
Mayor Evans inquired on who monitors the work. Ms. Dechter stated that her department monitors the work and reports it in the Annual Report given in June and at neighborhood association meetings. She gave examples of grants that were received by the neighborhood associations. She stated that if there was a neighborhood planner, that the planner would be able to focus on grants. Mayor Evans stated that she wanted to know how the process worked and that only about 5% of Ms. Dechter’s time is dedicated to neighborhood planning.

Ms. Dechter continued the presentation and addressed neighborhood planning and discussed community trust, community cohesiveness, and capacity building within a community.

Councilmember Whelan asked if neighborhood plans can take years to complete how that reconciles with neighborhood trust. She stated that in her experience that the connections are integral, but with Ms. Dechter’s time being so restricted, how does that work. Ms. Dechter stated that it is a concern and that the Southside Neighborhood is a different type of project. They have asked for staff to slow down and do a four month pause with the community’s support. She values having the community involvement in creating a timeline. Right now, the Southside plan is getting ready to hold an open house on March 30 which will kick off a planning session. It was impossible to move forward with the plan without a deep understanding of the neighborhood's history. There are 64 single business in the Southside neighborhood and 32 businesses responded to a survey. 

Ms. Dechter continued the discussion on the Southside Neighborhood Plan. The plan would be delivered by December 2019 at the earliest or by February 2020 at the latest. However, there was a pause in the Southside plan to start early implantation including: parking and street management on Fountaine Street, addition of at least six new streets into the residential Park Flag parking program with three more in the queue, handicap accessible on-street parking, storm water regulation education (especially insurance), bulk trash education and operations, communication with NAU students, and trash clean-ups with sustainability staff. Mayor Evans and Councilmember Whelan did a walking tour with staff in the neighborhood.

Ms. Dechter covered the Census 2020 Coordination. She stated that there is a new recruitment coordinator located in Flagstaff and that the lease for an office will hopefully be signed soon. Flagstaff and Coconino County have more applications than Tucson and Phoenix per positions, which shows that outreach is working well. One of the challenges of hiring for the census is that background checks are about 12 weeks behind due to the Federal government shutdown. Mayor Evans suggested that the City’s Indigenous Coordinator might be able to assist with census recruitment for Navajo speakers. Ms. Dechter informed Council that NAU’s Spring Communications capstone project is designed to work on campus outreach strategy. New technology will be implemented in the 2019 census, and a Volunteer and Event Coordinator will be hired on a temporary basis. The 2020 outreach is a City-wide priority.  

Mayor Evans asked why Ms. Dechter’s department oversees the census rather than someone who has their sole purpose as the census, perhaps someone jointly employed with the County. She has heard complaints that neighborhood planning and implementation of plans takes too long, and she is concerned that the census will pull the department away from City priorities. City Manager Goodrich stated that the Census comes up only once every ten years. She also stated that Ms. Dechter picked up the torch of the census, and that her expertise has been instrumental in the continuation of the project with changes in staff and duties. Mayor Evans would like to see if there is a better way to handle the distribution of duties. Ms. Goodrich and Ms. Dechter will look to see if there is other staff that can assist. Ms. Dechter went to Maricopa County for census training and requested that census training be brought to northern Arizona since it had never been held here. She stated that because of her education, she has expanded on the needs of the census. Mayor Evans stated that she feels that if the census is this important, that there needs to be more staff to assist. Councilmember Whelan added that Ms. Dechter is the perfect person to deal with the Census. Mayor Evans stated that if Ms. Dechter is the perfect person for all things, it limits her ability to accomplish goals. Other staff may be able to step up and work on these projects. 
 
Vice Mayor Shimoni asked about the canvassing that was done in the Southside. Ms. Dechter replied that staff went door-to-door with a survey and staff met one-on-one with families. The findings were reported in June. There was a public workshop that attracted 30 people which was not considered successful. It was determined that there needed to be more information about the demographics of the neighborhood and that canvassing would be the best way to collect the information. Vice Mayor Shimoni also asked about the turnout at community events. Ms. Dechter stated that the attendance was variable. The attendance of the workshops was between 18 and 45 attendees per event. Going door-to-door was more successful for staff than the workshops. Vice Mayor Shimoni asked what efforts were done for advertising the events. The zoning code requires a physical mailer to about 700 addresses. The mailings were expensive, so staff tried to create a document that advertised multiple events. Social media was also utilized. One to two mini-videos were produced. Door hangers were effective as well. The required notices also include an advertisement in the paper and a sign at the physical location (Murdoch Center). Vice Mayor Shimoni asked about the cost of the mailing and inquired about the social media costs. Ms. Dechter replied that she had a $45 budget for social media and she heard that most people learned about the meetings through mailers and door hangers. She did not have the cost of the mailers on hand. Mayor Evans stated that the meeting she attended had a lot of students, but not a lot of older people. She felt that the older people and families who have been in the neighborhood for multiple generations were not reached because they are not available through social media. In her opinion, the most effective method of outreach in the Southside neighborhood is door-to-door canvassing and door hangers. Vice Mayor Shimoni advocated for mini-videos to summarize the meetings and asked about the facilitation support. He was curious about the cost of the facilitation and Ms. Dechter was not sure on the cost. He also asked if there are plans regarding the J.W. Powell corridor. Mr. Symer stated that it is on the budget list. He wants to tackle the subdivision ordinance to address that area specifically.
 
Mayor Evans called a five-minute break at 8:05 pm and called the meeting back to order at 8:09 pm.
 
Jesse Dominguez added a public comment. He stated that he is proud of La Plaza Vieja Neighborhood Specific Plan. The new park at Old Town is a point of pride for the neighborhood. He thanked City staff, City Council, Ms. Dechter, and everyone else as well for their work in his community. He stated that the La Plaza Vieja neighborhood is willing to help with the Southside Plan and that they have a lot in common with the Southside neighborhood. He stated that the plan is working and that there are professional people and families returning to the neighborhood. He had a shuttle driver pick him up yesterday at his home and stated that the driver was impressed with the community cohesiveness. He again thanked the City and staff.
             
8. Continued support of prior council resolutions supporting the ban on mining around the Grand Canyon.
  City Manager Goodrich stated that the Grand Canyon Trust is traveling to Washington D.C. for a legislative trip and has asked Council to renew their support on the ban on mining around the Grand Canyon. Ms. Goodrich read the titles of Resolution 2017-32 and Resolution 2018-06 that supported the temporary ban of uranium mining around the Grand Canyon.
 
The following individuals addressed the Council in support of the ban on mining around the Grand Canyon.
  • Steve Finch, representing FLRTA
  • Joe Shannon
  • Roger Clark
 
Comments received included:
  • Supportive of restricting mining for uranium at the Grand Canyon
  • Representative Thorpe has introduced an initiative to open mining everywhere regardless of location and FLRTA is not in support of that.
  • Supportive of Representative Thorpe’s initiative to clean up mining tailings.
  • Asked Council to consider another resolution to support the initiative by Representative Grijalva that would permanently ban mining at the Grand Canyon.
 
Mayor Evans stated that the City Manager is looking for affirmation for the ban of mining around the Grand Canyon. A majority of Council stated that they are in support of the ban of mining around the Grand Canyon.
 
Councilmember McCarthy stated that he would like to ban transportation of uranium. If any transportation of uranium does occur, then he would like to ensure that transportation happens in sealed trucks rather than trucks covered with tarps. He would like to explore this in the future as a new resolution.
 
Mayor Evans stated that Council is in support of creating a resolution to support Representative Grijalva’s bill. Ms. Goodrich will place that on a future agenda.
 
             
9. Discussion/Direction: Current Issues Before Arizona Legislature and Federal Issues.
  Acting Assistant to the City Manager Cliff Bryson gave a presentation on a state legislative update that covered. The City's State Lobbyist Richard Travis joined the presentation via phone. Mr. Bryson provided a negative impact list and a list of good bills and bad bills. Highlights were:
  • Over 3,000 bills submitted this session
  • Bills are now in cross reference (Bills that were in the Senate are now in the House and vice versa)
  • Mr. Bryson reviewed the negative impact bills and the “good and bad” bill list.
Mayor Evans inquired about HB 2455, the State Aviation Fund and why it is an issue. Mr. Travis answered that the State Aviation Fund has been swept for several years and that has been a problem. The bill would stop the sweep of the aviation funds and allow municipalities to apply for the FAA match which is a 10 to 1 match for state funds to federal funds when there is state money available. The funds would be used to support airports. By sweeping that money, the onus for repairs at airports is passed onto the cities.

Vice Mayor Shimoni asked about the minimum wage reduction for students and Mr. Travis stated that he does not think that bill stands a chance this year.

Mayor Evans asked again about the Aviation Bill and if staff is concerned. Ms. Hansen stated that the aviation funding could help with major infrastructure. Mayor Evans asked for more information on this bill so that Council could advocate more on it. Mr. Travis stated that Representative Campbell from Prescott created an aviation caucus and that he would be more than happy to attend that and push this issue more.

Councilmember Odegaard asked about SB 1225. He asked if the House will see it to vote on it. Mr. Travis does not believe that the bill will see the light of day due to the politics of that Chamber.

Vice Mayor Shimoni asked what the next steps are moving forward and what the general timeline is. Mr. Bryson stated that staff would like to keep Council up to date on these bills as soon as possible. If there is action that Council would need to take, they will be able to move quickly with these updates. Mr. Travis added that if there are any specific questions, send them to Mr. Bryson or the City Manager and they will get them to him right away. Mayor Evans added that a delegation will be traveling to Phoenix in the future and Mr. Travis added that this date will be determined.

Councilmember Whelan added that after the initial visit, a thank you note with two or three items they discussed should be sent to the legislative representatives. Mr. Bryson will draft a thank you letter.
 
             
10. Public Participation
  None.
             
11. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests
  Vice Mayor Shimoni attended a Census 2020 meeting with Ms. Dechter and members of the County. It was an impressive meeting with about $75,000 being spent by each entity on the Census.

Councilmember Aslan reported that he attended the NAIPTA Board meeting and it was a great conversation. He stated that he is excited to work with NAITPA. He also stated his appreciation to the City and staff for surviving Snowpocalypse 2019. He also feels that pedestrian safety may need to be discussed in the future in regards to snow and inclement weather events.

Councilmember Odegaard also thanked City Staff for the work on cleaning up the snow. He was shoveling snow off the roof of his store when Ms. Goodrich called him for his signature on the emergency declaration. He thanked Councilmember McCarthy for attending a Boy Scout event with him.

Councilmember Salas stated that she joined the Mayor, Councilmember Odegaard, and Councilmember Whelan at the state legislative trip and that it was an honor. She thanked the staff who presented that evening and the Streets Department and staff that worked the snow event. She also thanked the Flagstaff Police Department for their work during the snow event. She is proud to have seen Flagstaff’s Mayor at the Grand Canyon event in support of uranium mining ban.

City Manager Goodrich also thanked the Streets Department as well as the Airport Department and Parks Department for the snow removal.

Mayor Evans also thanked staff for their work. She also stated that she went on a trip to Mexico City with Business Attraction Manager Gail Jackson to advocate for business opportunities with Mexico. It was a fascinating trip and Mayor Evans stated that Gail Jackson is a wonderful representative for the City of Flagstaff.
             
12. Adjournment

The Flagstaff City Council Work Session of February 26, 2019, adjourned at 9:09 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 30-Apr-24 01:35 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
188 ms 188 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
157 ms 157 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
157 ms 157 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/Application.cfm
15 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
203 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

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

qCodes (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 13:35:04.004
			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(813 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 @ 13:35:04.004
	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 @ 13:35:04.004
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 812 
getAllMnLines (Datasource=frsRO, Time=46ms, Records=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
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 = 812 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 = 357 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=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
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 @ 13:35:04.004
	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 @ 13:35:04.004
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
		
	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 = 357 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 357 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 @ 13:35:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7908 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7913 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7906 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7907 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7909 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7915 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5779 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7916 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5780 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7917 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5781 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7918 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5787 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7911 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5783 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7910 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5784 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7912 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:35:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 13:35:04.004
	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 @ 13:35:04.004
	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 @ 13:35:04.004
		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 @ 13:35:04.004
		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=2&get_year=2019&dsp=min&seq=813
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=2&get_year=2019&dsp=min&seq=813
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=9408469
cftoken=22a9b298f7d02fea-E6FD757F-B608-ABF0-0390208429ADDF76
hitcount=4
lastvisit={ts '2024-04-30 13:35:04'}
timecreated={ts '2024-04-30 13:35:04'}
urltoken=CFID=9408469&CFTOKEN=22a9b298f7d02fea-E6FD757F-B608-ABF0-0390208429ADDF76
Cookie Variables:
CFID=9408469
CFTOKEN=22a9b298f7d02fea-E6FD757F-B608-ABF0-0390208429ADDF76
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=813
Session Variables:
cfid=9408469
cftoken=22a9b298f7d02fea-E6FD757F-B608-ABF0-0390208429ADDF76
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9408469_22a9b298f7d02fea-E6FD757F-B608-ABF0-0390208429ADDF76
subdir=/public/
tzoffset=0
urltoken=CFID=9408469&CFTOKEN=22a9b298f7d02fea-E6FD757F-B608-ABF0-0390208429ADDF76
URL Parameters:
dsp=min
get_month=2
get_year=2019
id=
mt=ALL
seq=813
Debug Rendering Time: 0 ms