Print Minutes Return
WORK SESSION
TUESDAY, JANUARY 26, 2016
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.


 
MINUTES
             
1.
Call to Order

Mayor Nabours called the Work Session of the Flagstaff City Council held January 26, 2016, to order at 6:00 p.m.

NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this work session, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).
             
2. Pledge of Allegiance

The Council and audience recited the pledge of allegiance.
             
3. Roll Call
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT

MAYOR NABOURS
VICE MAYOR BAROTZ
COUNCILMEMBER BREWSTER
COUNCILMEMBER EVANS
COUNCILMEMBER ORAVITS
COUNCILMEMBER OVERTON

ABSENT

COUNCILMEMBER PUTZOVA





Others present: City Manager Josh Copley and Deputy City Attorney Sterling Solomon.
             
4.
Preliminary Review of Draft Agenda for the February 2, 2016, City Council Meeting.*
* Public comment on draft agenda items may be taken under “Review of Draft Agenda Items” later in the meeting, at the discretion of the Mayor. Citizens wishing to speak on agenda items not specifically called out by the City Council for discussion under the second Review section may submit a speaker card for their items of interest to the recording clerk.
  Councilmember Oravits asked in regards to the zoning code amendments if the agreed sign size was 24 or 32. Mayor Nabours stated that the sign code is not part of next week’s discussion. Councilmember Oravits asked when the sign code will be coming back to Council for discussion. Planning Director Dan Folke stated that the sign code is going before the Planning and Zoning Commission in February so it will come to Council hopefully in March. He stated that he will be sure to address his question on temporary sign size in the materials that are provided.

Vice Mayor Barotz stated that she would like to talk about the process for how motions will be made concerning the amendments; she would like for each section to have its own motion and not one action for the entire set of amendments.
             
5. 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.
  John Viktora addressed Council with concerns about the State’s recent actions to limit what municipalities can do within their own cities and towns.

Andy Fernandez addressed Council with a number of concerns.
             
6. Presentation on Children's Garden in Foxglenn Park.
  Public Works Section Director Michael O’Connor addressed Council providing some history on the JLB project. JLB is a non-profit organization that provides services to families who have lost a child. They approached the City about five years ago about establishing a memorial garden at one of the City parks. At the time there was no donation policy to allow a project such as this to come in. It took some time but the City was able to develop a resolution that addressed this kind of donation. In 2014 the Parks and Recreation Commission approved the proposed resolution and project after which the City Council approved the resolution that allowed for donations to the City for the memorial. Mr. O’Connor introduce the President and founder of the JLB Project Anna LaBenz. Ms. LaBenz stated that the project was developed to help provide services and assistance to help families who have lost a child. She explained that over time she found that people wanted and needed a place to reflect on the lives of their loved ones which led them to begin the process of developing such a space.
 
Ms. LaBenz provided a PowerPoint presentation that covered the following:
 
EXISTING SITE AND CONDITIONS
GUIDING PRINCIPLES FOR CHILDREN’S GARDEN
RIBBON-LIKE FORMS SERVED AS DESIGN INSPIRATION FOR THE GARDEN
CHILDREN’S GARDEN AERIAL VIEW – PHASE I
CHILDREN’S GARDEN AERIAL VIEW – PHASE II
PERSPECTIVE OF GARDEN ENTRY SPACE
PERSPECTIVE OF GATHERING SPACE
ONE SCULPTURE AT THE HEART
PERSPECTIVE OF MEMORIAL PLAQUES AT GATHERING SPACE
PERSPECTIVE OF STONE FORMATION AT GATHERING SPACE
PRECEDENT IMAGES THAT SERVED AS DESIGN INSPIRATION FOR CHILDREN’S
GARDEN RIBBON
CONCEPT DESIGN FOR MEMORIAL PLAQUES
 
Vice Mayor Barotz stated that she remembered the first day Ms. LaBenz took her to the site to express the vision; it is a number of years later but the design and proposal is beautiful.
 
Mayor Nabours asked what the plan is for Phase 2 and the timeline of when it might happen. Mr. O’Connor stated that the area is ideal because there are no plans for future improvements. City staff worked very closely with JLB in the development of Phase 1 and Phase 2 to make sure that the design complimented the existing park. The amenities that the project proposes work very well with the existing elements and there is already a naturally occurring path that the project wishes to enhance.
 
Ms. LaBenz stated that the goal is to break ground this spring for Phase 1 and complete in October, 2016. After Phase 1 is complete JLB will begin fundraising efforts for the funding of Phase 2; because it is donation driven the timeline for Phase 2 is still developing and is very dependent upon when funding becomes available.
 
Mayor Nabours asked if there is a limit on the number of memorial plaques. Ms. LaBenz explained that there is no limit and that was something that was very important to JLB. It is very important to them that this memorial stands the 50 year test and that additional plaques can be added over time.
 
Councilmember Oravits asked what the funding goal for Phase 1 is. Ms. LaBenz stated that the goal is $150,000.
 
Mayor Nabours stated that sponsors have been mentioned, he asked how they will be recognized without having issues with advertising. Mr. O’Connor explained that the sponsorship recognition is specifically addressed in the resolution. Ms. LaBenz added that it is very important to allow a space for community members to be recognized even if they did not lose a child and one of the options they are looking at is a placard that states that the space was made possible by the following donors.
 
Mayor Nabours stated that the design and project have turned out quite well and he looks forward to seeing it move forward.
             
7. Introduction of Terros and Crisis Response Network: The Mobile Crisis System That Helps Get Flagstaff's Mentally Ill the Help They Need When They Need It.
  Flagstaff Police Chief Kevin Treadway stated that the Police Department places great care and support to its most vulnerable populations within the community. To this end, there is continued support for the partnership with the Guidance Center to train officers on how to better understand and respond to the mentally ill in the community. He reported that a few months ago a new mobile crisis response program arrived in Flagstaff. Additionally, the Guidance Center and Healthchoice Integrated Care have worked hard to add additional services in Flagstaff. To better explain the programs he introduced Dr. Jack Callahan from the Guidance Center, Shawn Nell, the Chief Operating Officer for Healthchoice Integrated Care, Dr. Dara Ramparsand, Senior Director for Terros and Sara Schol, Director of Strategic Initiatives for Crisis Response Network.
 
Mr. Nell provided a PowerPoint presentation that covered the following:
 
HEALTHCHOICE CRISIS SYSTEM UPDATE
ABOUT US
REVISED FLAGSTAFF REGIONAL CRISIS SYSTEM
 
Ms. Schol continued the presentation.
 
CRISIS LINE OF HEALTHCHOICE INTEGRATED CARE
WHO WE ARE. WHAT WE DO.
CRISIS RESPONSE NETWORK
STATISTICS
CRISIS LINE OF NORTHERN ARIZONA
IDENTIFYING WHEN TO CALL THE CRISIS LINE
 
Dr. Ramparsand continued the presentation.
 
TERROS
FLAGSTAFF MOBILE CRISIS
 
Mayor Nabours asked about the funding and if each agency is funded separately or if funds are divided from a lump sum allocation. Dr. Ramparsand stated that Healthchoice Integrated contracts with and provides the funding for Terros’ operations in Flagstaff. Mr. Nell explained that the funding is 100% through AHCCCS or State general funds; it is a largely state funded program.
 
Dr. Callahan continued the presentation. He highlighted the partnership with Healthchoice. They are excited about the partnership with the Crisis Response Network and Terros. He introduced Medical Director for the Guidance Center Dr. McDaniel who continued the presentation.
 
CRISIS ENTRY AND STABILIZATION UNIT
 
Vice Mayor Barotz asked how the Crisis Response Network’s phone number is advertised in the community so people know it is available to them. Dr. McDaniel stated that the number is advertised through brochures and various stakeholders in the community. It is a relatively new service and as they go further more community knowledge is to be expected.
 
Vice Mayor Barotz asked if this program reduces the Fire Department’s requests for response. Mr. McDaniel stated that he would assume that it does but he is not sure of the statistics on that claim.
 
Councilmember Evans asked if the information could be placed on the City’s website. Mr. Nell explained that the number has not yet been heavily advertised yet as they were working through the new system. They are beginning the outreach process and would welcome ideas such as that to help get the word out.
 
Councilmember Evans asked if they utilize volunteers. Mr. Nell stated that one of the Healthchoice partners is NARBHA which is a non-profit organization that helps provide volunteer services. Additionally, work has been done with other non-profit organizations to provide volunteer assistance to the program.
 
Councilmember Brewster asked how patients and callers under 18 are handled and if an adult is required for care. Dr. McDaniel stated that clients aged 18 or under can call into the Crisis Line and the responders will assist them in getting access to the healthcare system such as Flagstaff Medical Center or the adolescent program. Additionally, arrangements can be made to assist with transport to those resources. Ms. Schol added that the Crisis Hotline is the rollover line for the Teen Lifeline and they answer all their after hour calls. They will always talk with adolescents and provide a thorough risk assessment and safety plan. As long as there are no safety issues with the parents they do their best to involve the parents into the safety plan.
 
Councilmember Overton stated that he was surprised with the volume of response to the system without any advertising and he is encouraged with the services that are obviously needed in the community. He asked what the patient cap is for a day and at what point the system begins to not work or quality diminishes due to volume. Dr. McDaniel stated that the system is nowhere near capacity at this time but the program has been wildly successful thus far. There is excess capacity to grow and expand and they have the ability to get licensed for more chairs should they need to do that. Councilmember Overton stated that providing access to this program is positive for the community’s law enforcement agencies and it helps get people to the appropriate place for care. He thanked them for their work. Chief Treadway added that officers really look for options for people and now they have the ability to connect people to the most appropriate services.
             
8. Presentation of Specific Plan Work Program for Comprehensive Planning.
  Comprehensive Planning Manager Sara Dechter provided a PowerPoint presentation that covered the following:
 
COMPREHENSIVE PLANNING WORK PROGRAM RELATED TO SPECIFIC PLANS
DIRECTION TO STAFF
COMPREHENSIVE PLANNING
PLANNING PROJECTS TIMELINE
POTENTIAL SPECIFIC PLAN AREAS
POSSIBLE MILTON TIMELINE
 
Councilmember Oravits stated that he appreciates the approach she is taking with this item. He stated that the 4th Street Corridor Study was a $250,000 study that turned out to be a complete disaster as far as what was spent in time and money and the return on investment; he asked how that outcome can be avoided in the future. Ms. Dechter offered that one of the ways is to heavily invest in public participation assistance. An RFP for Milton should have the top five public participation contractors in the state to bid on it. In order to do this the City needs to contribute the necessary funds to do so. Additionally, the City should look to the Flagstaff Metropolitan Planning Organization (FMPO) and ADOT to also help contribute heavily.
 
Councilmember Evans stated that she feels that the City needs to be very clear in the RFP on what the expectation and end result should be. It will be very important for the Council to determine early on what they are willing to do and not do so that there is political will to move forward with the results of the study.
 
Vice Mayor Barotz asked about the Flagstaff Urban Mobility Study that was referenced in the presentation. She stated that she did an internet search for the study and found nothing except one letter to the editor; she asked what happened to the information between the study and 2016. The City is implementing the plan that was developed from the results of the study but there appears to be no record of any meetings or outreach. Community Development Director Mark Landsiedel stated that the study was done back in 2003 and was funded by FMPO and ADOT. The study was never adopted by the City Council or by ADOT’s Board. It becomes an advisory study for ADOT’s planning purposes. There were no public hearings or Council vote on the results of the study. Vice Mayor Barotz stated that from a process standpoint it will be very important to communicate with the public on whatever ADOT decides to do. Mr. Landsiedel agreed and added that the process will be a difficult one. There will be questions of jurisdiction and route transfers. Ultimately, in order for the City to control what happens to Milton a route transfer will be necessary. The City must get jurisdictional control over Milton if it is going to spend its money on improvements. This may or may not be the will of the Council or ADOT.
 
Ms. Dechter offered that one of the reasons the timeline was put together as a flux diagram is because she does not see a project this lengthy not coming before Council and the various Boards and Commissions multiple times to communicate and provide updates on where the project is at, the next steps forward and continued public participation.
 
Mayor Nabours stated that some of the proposals are within the City’s control as opposed to another agency. The Milton corridor is one where the City does not have complete control; he would not want to spend $250,000 to get a study that would tell the City that Milton is a congested street that needs attention. He asked what she foresees with the specific plan and the study and how it is different than what the Regional Transportation Plan is already doing. Ms. Dechter offered that the specific plan would be different because one of the outcomes would be to work out a power sharing agreement with ADOT that would make sense or get control of the road. This is different from the Regional Transportation Plan because it only assumes the status quo in terms of the management of Milton.
 
Mayor Nabours asked what could be done with Milton if the City owned it as opposed to the State. Mr. Landsiedel offered that what staff wants to see is a concrete study that shows where the curb and gutter is, where medians are going to be, where streets are going to intersect, etc. The intent would be to take the studies that the FMPO have been doing on Milton to the next level. Staff believes that local control has the greatest ability to carry out the vision of the study rather than ADOT’s Transportation Board down in Phoenix.
 
Councilmember Oravits offered that it will be critical to have frequent updates at the Council level so more people will hear about it and get involved.
 
Councilmember Evans stated that working with ADOT takes a long time and there are several roads that are overseen by ADOT that the City should consider taking control of. She suggested that the City has a comprehensive discussion with ADOT about the roads in town. Mr. Landsiedel stated that a number of years ago the City completed its Route Transfer Study and sat down with the County and ADOT to comprehensively look at every State route in the City and how they might be transferred to the City at some point. They also talked about what needs to be done to the roads to bring them up to City standard and the costs associated with taking them on. It is a great suggestion and staff can continue to have those conversations with ADOT moving forward.
 
Mr. Overton offered that the cost to bring the state roads to City standard was approximately $60 million. He acknowledged that the route transfers would give the City local control but asked at what cost. He does not want to consider route transfer unless ADOT will bring the roads to standard first. Mr. Landsiedel stated that part of the Route Transfer Study suggested breaking down the transfers in segments. When the study was complete and the City began discussions with ADOT there was funding at the ADOT level to potentially use to bring those roads up to standard; that funding is now severely lacking. There is also significant cost associated with ongoing maintenance. Councilmember Overton stated that he is not interested in coming up with a bunch of solutions when the City cannot afford to own or maintain the roadway. Ms. Dechter offered that there is a new federal highway rule making process that could potentially provide alternatives to route transfers and provide an opportunity for a great partnership with ADOT to pilot the program.
 
Ms. Dechter continued the presentation.
 
POSSIBLE SOUTHSIDE TIMELINE
 
Councilmember Evans asked what the other area plans underway now are. Ms. Dechter stated that there are not any others that are underway now; the reference in the presentation was that if multiple plans were being done concurrently more consultant time would be needed. It is staff’s recommendation that one plan is done at a time.
 
Councilmember Evans indicated that appropriately funding and allocating resources is very important to the plans. There was a lot of money and time spent on a Southside plan in 2005 that was not formally adopted by Council; it has been determined that these plans are important and the appropriate resources and final adoption by Council is needed. Mayor Nabours added that it is something that the Council can really get behind and get done relatively quickly for future use.
 
Mr. Landsiedel offered that staff has a certain capacity and feels they could get one of these plans done in a 12-18 month timeframe. If it is Council’s desire to do all three plans concurrently staff can analyze that through the budgeting process and come back to Council with some proposals on what it would take to get that accomplished.
 
Ms. Dechter continued the presentation.
 
POSSIBLE HIGH OCCUPANCY HOUSING TIMELINE
 
Mayor Nabours stated that there has been an outside group working on this topic for months; they have provided a report and Council has enacted several of the recommendations. He asked what the difference would be for this topic. Ms. Dechter offered that staff would figure out the criteria and how it would impact property owners. There has also been discussion about wanting to include zoning code updates into the process, this would allow staff to pursue them concurrently with updates to the zoning code at the same time as an aspirational plan.
 
Ms. Dechter continued the presentation.
 
OPTION 1: STAFF RECOMMENDATION
OPTION 2: FOCUS ON HOUSING AND NEIGHBORHOODS FIRST
OPTION 3: ACCELERATE MILTON ROAD CORRIDOR PLAN
REMINDERS
 

The following individuals addressed Council regarding the Specific Plan Work Program:
  • Andy Fernandez
  • Tory Syracuse
The following comments were received:
  • Housing needs to be available to all citizens.
  • Milton is already built and updates would be difficult.
  • More on/off ramps are needed on I-40.
  • Priority should be given to High Occupancy Housing.
  • More and more development is coming and a plan should be in place for high occupancy housing development.
A break held from 7:45 p.m. through 7:56 p.m.
 
Mayor Nabours stated that he prefers the McMillan Mesa plan and the Southside Neighborhood Plan; both have some work already done and a good conclusion can be obtained without a lot of expense or time. He feels that the Milton corridor is a bigger issue than just looking at what can be done immediately. It is an issue of where the City is going to create alternative routes. There is a lot of planning being done right now and that will escalate in the next year and $250,000 would be better spent on a broader transportation plan.
 
Councilmember Evans stated that she is interested in the high occupant housing and the neighborhood plans. She asked, in terms of the Milton project, if the City has to be the one to lead the conversation about route transfer or can they partner or contract with the FMPO to start that discussion with the state to better understand the costs associated with it now. She also requested information on what it would take to complete two of neighborhood plans each year.
 
Councilmember Overton stated that high occupancy housing is an immediate need because it is something that is happening now. There are many that are currently in development and are entitled but it is something that there will likely be more of in the future. There is currently a lot of public attention on it as well which can help with the public participation piece. He feels that there will likely be some major amendments that come out of the plan and he encouraged Ms. Dechter to plan accordingly to allow her enough time in her work plan to give those amendments the time and attention they will need.
 
He offered that he would only look at Milton if the City is looking to tie it to the transportation tax. He indicated that there is wisdom in getting those small pieces done but strongly cautioned that the City may go down a road with little return on its investment. The City must continue its support to NAIPTA and the things that can be done at a local level.
 
Councilmember Brewster stated that she would like to see staff focus on the high occupancy housing. The City is in the middle of quite a few developments headed in that direction already. Milton is such a long range project and depending on other agencies will be an even longer range goal. Neighborhood plans would be her second choice after high occupancy housing.
 
Vice Mayor Barotz indicated that she would like to be mindful of the people who took time to fill out the survey and offered that if the City puts these tools out they need to communicate with the public that they are being heard. She would support moving forward with high occupancy housing. She stated that there is one issue everyone talks about and that is traffic. She would support certain components of the Milton Road Corridor Plan such as talking to ADOT.
 
Councilmember Oravits stated that he is supportive of the high occupancy housing project. He indicated that traffic is the number one thing he hears about from the community; understanding what is realistic versus promises that cannot be delivered is something that needs to be defined. He would like to see a discussion with ADOT to see what options there are and the mechanisms for the other affected roads within the City.
 
Councilmember Brewster stated that she would like to hear more about what can be done on the Lone Tree corridor in conjunction with Milton. FMPO Manager Dave Wessel offered that the Regional Transportation Plan update is going on and there is a lot of analysis happening about alternate routes. They are in the budget season as well and are looking at the Transportation Improvement Program. One of the things they have not done for the last couple of years is program money for fiscal year 2019 or 2020. The reason they did that was because they are waiting for the Regional Transportation Plan to start pushing some of the priorities forward that could be accelerated with those monies.
 
One of the weaknesses of the early process of the Urban Mobility Study was that the City was not at the table with the land use component. At the time there were very divergent ideas on what the land use along Milton should be; the FMPO ultimately pulled $2 million in funding for the design of the Milton corridor because of that level of uncertainty. It is important for the City to make those decisions on land use along Milton before moving forward.
 
Mayor Nabours stated that the consensus is to focus on high occupancy housing right now and get to the other items as soon as possible. Also, as part of the budget process staff will provide information on what it would take to run concurrent projects.
             
9. Discussion on the City of Flagstaff Sidewalk Maintenance and Repairs Program
  Public Works Section Director Michael O’Connor provided a PowerPoint presentation that covered the following:
 
CITY OF FLAGSTAFF SIDEWALK REPLACEMENT PROGRAM
SIDEWALK REPLACEMENT PROGRAM 5-YR. HISTORY
SIDEWALK REPLACEMENT – CODE
SIDEWALK REPLACEMENT PROGRAM
SIDEWALK REPLACEMENT CATEGORIES
SIDEWALK REPLACEMENT PROGRAM COSTS 2015
 
Mayor Nabours confirmed that there are about five sidewalk replacements per year that are due to age and deterioration. Mr. O’Connor agreed and offered that there are more instances of heaving sidewalk than there are of replacements for age and deterioration. Mayor Nabours also confirmed that the streets that are being repaved under the bond initiative are also having the sidewalks replaced to which Mr. O’Connor responded yes.
 
John Viktora addressed Council in regards to developments that are supposed to have sidewalks but do not.
 
Mayor Nabours offered that there is an arbitrary ordinance that requires people to repair sidewalks that are not damaged due to their own fault. He indicated that he is looking for an exception to the ordinance for repairs that are not the result of fault of the property owner. The instances are fairly minimal and will not cost the City much. Some sidewalks will be replaced through capital projects so it does not seem fair that others are not offered the same.
 
Councilmember Oravits stated that he feels that it does seem inconsistent and would agree with changing the ordinance if it is not the fault of the property owner.
 
Mayor Nabours stated that there were only three Councilmembers in favor of changing the ordinance so no further action will be taken at this time.
             
10.
Review of Draft Agenda Items for the February 2, 2016, City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.
             
A. CALL OUT: Consideration and Adoption of Resolution No.2016-03: A Resolution of the City of Flagstaff Urging the United States Congress to Pass Carbon Fee and Dividend Legislation. (REFER TO ITEM 15-A OF THE FEBRUARY 2, 2016, DRAFT AGENDA FOR FURTHER INFORMATION)
  Gabor Kovacs addressed Council in opposition of the Resolution.
 
Public Works Director Erik Solberg stated that Sustainability Specialist Tamara Lawless is prepared with a presentation on the item. Mayor Nabours stated that the presentation can be given next week when there is more public in attendance and Council will be taking action.
             
Mayor Nabours stated that there will be an update on the legislative agenda next week and Assistant to the City Manager Stephanie Smith has an update to present in preparation for the meeting next week.

Ms. Smith stated that there are two hearings currently scheduled for the Veteran’s Home. HB2329, which is the $10 million appropriation for the building in Flagstaff, is scheduled for a hearing before the Veteran and Military Affairs Committee on Thursday February 4, 2016, at 9:00 a.m. Additionally, SB1114, which is the exact same bill in the Senate, is scheduled to go before committee on Wednesday, February 10, 2016, at 10:00 a.m.

There is also a hearing next week on HB2333 that was introduced on behalf of the City of Flagstaff. That bill proposes to modify the State statute pertaining to the registration requirements on non-structural and non-load bearing commercial improvements. The hearing is scheduled for Wednesday, February 3, 2016, at 9:00 a.m.
             
11. Public Participation

None
             
12. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember Brewster requested an update on the GreenTree hotels out at the Airport.
 
Councilmember Evans stated that she has heard from several residents in La Plaza Vieja that there are some new apartments on Tucson that are renting by the room. When she
  asked about approved Conditional Use Permits for that area she was told that there were none. Mr. Copley stated that he will look into the issue and have staff prepare a response back to Council.
 
Councilmember Evans also requested a FAIR item for a City resolution in support of Gosar and McCain’s efforts concerning the Downwinder Program.
 
Mayor Nabours requested a CCR about the City’s water pipes, he would like to know if there are lead pipes in the system and if lead has ever been an issue in the water supply.
 
Councilmember Oravits stated that he has heard from the public about the $4 surcharge when paying a water bill online; there is no charge to pay in person at City Hall and that seems backward. Mr. Copley indicated that staff has been working on the process more comprehensively and will get Council an update soon.
             
13. Adjournment

The Flagstaff City Council Work Session of January 26, 2016, adjourned at 9:02 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 05-May-24 01:36 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
250 ms 250 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
218 ms 218 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
188 ms 188 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
16 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.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/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/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
250 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 13:36:00.000
			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:36:00.000
				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:36:00.000
			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:36:00.000
				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:36:00.000
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 13:36:00.000
	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:36:00.000
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:36:00.000
		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:36:00.000
	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:36:00.000
		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:36:00.000
	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:36:00.000
	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:36:00.000
		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:36:00.000
		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:36:00.000
	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=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:36:01.001
	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:36:01.001
	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:36:01.001
	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:36:01.001
	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:36:01.001
	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:36:01.001
	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:36:01.001
	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=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:36:01.001
		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) = 2016-01-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2016-01-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 13:36:01.001
			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(425 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:36:01.001
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 425 
getAllMnLines (Datasource=frsRO, Time=62ms, Records=17) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
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 = 425 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 = 124 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=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
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:36:01.001
	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:36:01.001
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=8) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
		
	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 = 124 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=10) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 124 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:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3233 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3239 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3231 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3234 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2503 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3232 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2504 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3242 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2505 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3243 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2506 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3241 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2507 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3244 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2508 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3235 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3245 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2511 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3246 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3237 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3236 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2556 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2510 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3238 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:36:01.001
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=15ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 13:36:01.001
	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:36:01.001
	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:36:01.001
		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:36:01.001
		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=1&get_year=2016&dsp=min&seq=425
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=1&get_year=2016&dsp=min&seq=425
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=9537098
cftoken=f5ea3187547954ee-E87F5E4F-B6E1-4115-CD205469143FA11D
hitcount=4
lastvisit={ts '2024-05-05 13:36:00'}
timecreated={ts '2024-05-05 13:36:00'}
urltoken=CFID=9537098&CFTOKEN=f5ea3187547954ee-E87F5E4F-B6E1-4115-CD205469143FA11D
Cookie Variables:
CFID=9537098
CFTOKEN=f5ea3187547954ee-E87F5E4F-B6E1-4115-CD205469143FA11D
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=425
Session Variables:
cfid=9537098
cftoken=f5ea3187547954ee-E87F5E4F-B6E1-4115-CD205469143FA11D
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9537098_f5ea3187547954ee-E87F5E4F-B6E1-4115-CD205469143FA11D
subdir=/public/
tzoffset=0
urltoken=CFID=9537098&CFTOKEN=f5ea3187547954ee-E87F5E4F-B6E1-4115-CD205469143FA11D
URL Parameters:
dsp=min
get_month=1
get_year=2016
id=
mt=ALL
seq=425
Debug Rendering Time: 0 ms