Print Minutes Return
CITY COUNCIL WORK SESSION
JUNE 9, 2015
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 June 9, 2015, to order at 6:02 p.m.
             
2. Pledge of Allegiance

The audience and City Council 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 OVERTON
COUNCILMEMBER PUTZOVA
ABSENT:

COUNCILMEMBER ORAVITS (excused)





Others present: Interim City Manager Jeff Meilbeck and City Attorney Michelle D'Andrea.
             
4.
Preliminary Review of Draft Agenda for the June 16, 2015, 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.

None
             
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.
  Emily Davalos, Flagstaff, addressed the Council stating that she was astounded at what she witnessed last week and now there was racist hate mail being sent. She said that the changes made by Councilmember Putzova were the only ones that made sense.
             
6. Review of the Draft La Plaza Vieja Neighborhood Specific Plan
  Comprehensive Planning Manager Sara Dechter addressed the Council and provided a PowerPoint presentation which addressed the following:

♦TIMELINE
♦WHAT WAS CONSIDERED AS PART OF THE COMPREHENSIVE UPDATE?
♦WHAT IS THE CONTENT OF THE PLAN?
              Chapters 1) site and area analysis
                              2) concept plan
                              3) goals and policy recommendations
                              4) implementation Plan
♦LAND USE – ZONING
            Current Zoning   split between Commercial and Low/High density residential
♦LAND USE – FRP30
♦LAND USE POLICY AREAS
            Goal 6.N Neigborhood Core
            Goal 6.T Transition Area
            Goal 6.C Commercial Edge
♦LAND USE GOALS AND POLICIES
♦HISTORIC IDENTITY
            Preserve and Enhance Existing Housing Stock
            Preserve Historic Structures and Landmarks
            Develop Gateways
♦TRANSPORTATION
            Clay Avenue Extension
♦CLAY AVENUE EXTENSION
♦CONCEPT PLAN
            Concept Map 1: Land Use
            By fall hope to have more info – from FMPO – studying
♦3D VISUALIZATION   Illustration #4
            Illustration #6, #2, #3
            None of these sketches indicate any type of approval        
♦ROLES AND RESPONSIBILITIES
♦NEIGHBORHOOD CHALLENGES
            Existing Entitlements
            Clay Avenue Extension
            Arrowhead Village Mobile Home Park
            Housing Occupancy - currently 6% owner occupied
            Nonconforming Uses
 ♦QUESTIONS

Ms. Dechter said that the boundary of the area was established during the prior planning efforts led by Kim Sharp. She said that the railroad tracks were not always fenced and families owned homes on both sides and they did not have the train volume at that time.

Mayor Nabours asked if the businesses included in the commercial edge were contacted. Ms. Dechter said that she was not sure she could answer that. Since they started this process back up recently they have sent out mailers to every property owner and fliers to the businesses, and they went door to door, encouraging them to be involved in the process.

Mayor Nabours asked if there was any discussion about the dilapidated building ordinance since there were some buildings in the area that are uninhabitable. Mr. Eastman said that with regard to abatement of those buildings, the building official enforces subject to the standards in that code. Many of the buildings have been boarded up; others they have not as they have not received complaints. From talking to Laura Meyers and other residents they are concerned and would like them removed or rehabilitated.

Mayor Nabours asked if the plan included any design review of new buildings. Ms. Dechter said that the plan cannot change the current design standards without further action by Council. They could bring that forward in an overlay district and the details of what that would include could be a number of things.

Councilmember Brewster said that the area is bisected by the railroad track and asked if there were any plans for residents to access those areas back and forth. Ms. Dechter said that there is currently a plan and programmed project that would connect Florence with a ten foot high tunnel to allow for bikes and pedestrians. She said that BNSF has a lot of illegal trespass into the park north of the tracks and the fences are always down. This is a proposal to provide access to connect these two parts.
  Councilmember Overton said that in looking at the implementation strategies he noticed two distinct areas--private parcels where the City has little control without working with the property owners, and then those that the City has control over. To make the biggest impact they could encourage those private property owners. He asked what easy things the City could do to help kick off the improvements. Ms. Dechter said that there are things in the street scapes that could be done, such as providing space for a planting strip and provide mechanisms to help do some reinvestment in the parks. She said that when they were doing the renovations in the Old Spring Park they found footprints for a saloon and commercial strip. The neighborhood would like to find a partnership with museums and NAU to do a good job in gathering that information.

Ms. Dechter said that this document could be a tool in the Capital Improvements Plan and budgeting process. This will be the first one to come online in awhile.

Jesse Dominguez said that he was excited now; it has been a long time. He said that he serves as President of the La Plaza Vieja Neighborhood Association and represented them. This afternoon a letter was hand delivered to the Mayor and Council, and he read the letter into the record, attached hereto as Exhibit A.

He said that they support no boundary change to the neighborhood, but they do not support the Clay Avenue Extension. He said that they feel that the McCracken connection would be better since the playground is on the southside of Clay Avenue.

Moran Henn, representing Friends of Flagstaff's Future, said that they were in support of the plan as reviewed and adopted and supports the neighborhood plan that allows them to communicate their needs.

Adam Shimoni, Flagstaff, said that they went through a hard time, but he was pleased with the work they are doing today and knows that the intentions have been good. He would like to see the Council push for more neighborhoods to put plans together.

Councilmember Evans said that she was happy to see this document before them, but she did not think it was ready to be approved. There are still issues to be worked out and she was interested in understanding what happens when it is approved and how it will be used. She said that one of the areas of concern is the Clay Avenue Extension and she was happy to see an alternative. She said that the issue of parking needs to be addressed as well as the aging infrastructure. She said that they need to have a separate plan that talks about the Arrowhead Trailer Park and a true revitalization of the park. She said that the neighborhood association has been asking for assistance for years with regard to homeownership and she would like to see CDBG funds designated for that purpose. She said that she would like to see a plan adopted by the end of the year.

Ms. Dechter said that the Planning and Zoning Commission had a work session on the working draft and they are currently in their 60-day comment period. She has sent the plan to all of the utility companies, the County, two state departments, and it has been posted on the websites. She sent out another postcard and a trifold with more information. They will have another neighborhood meeting for input and hope to receive a lot of feedback about this by July 27. Then it would go before Planning and Zoning Commission for another work session, after which there are two public hearings and one public hearing with the Council. It is possible they could have it to Council by October, perhaps November or December.
             
7. Presentation of Flagstaff Regional Plan 2014 Annual Report 
  Ms. Dechter then gave a PowerPoint presentation on the Annual Report of the Flagstaff Regional Plan 2014 which addressed:

♦MEASURE PROGRESS
♦REPORT ON FRP30 ACTIVITIES
♦IDENTIFY PLAN AMENDMENTS
♦NATURAL ENVIRONMENT
♦WHAT’S MISSING
♦BUILT ENVIRONMENT
♦EXISTING DISTRIBUTION OF ZONING CATEGORIES BY PLACE TYPE
            Outside Activity Center vs. In Activity Centers
            Commercial – fairly balanced
            Industrial, Public/OS Residential – little in activity center
♦WHAT’S MISSING?
            Heritage resources
            100-year water demand studies per project
            Connectivity of roadways
♦HUMAN ENVIRONMENT
♦CITY COUNCIL STAFF REPORTS
♦PROPOSED PLAN AMENDMENTS
            Task #1: Table of Major and Minor amendments (2015-16)
            Task #2: Map 25 Major Plan Amendment (2015)
            Task #3: Clarify the use of terminology “Great Streets” and “corridors” (2016)
            Task #4: Clarify terms and descriptive information in the Land Use Chapter (2016)
            Task #5: Non-substantive editing errors (2016-17)
♦STAFF DIRECTION REQUESTED
            Would you like something different in next year’s report?
            What missing metrics should we prioritize for next year’s report?
            Feedback on the proposed amendments – strategy or content

On request, Ms. Dechter said that the population indicated came from the recent DES numbers.

Vice Mayor Barotz said that one statistic she would like to see is how many Regional Plan Amendments came through the process, what they were and what the outcome was.

Councilmember Putzova said that she would like to see some trend data--identifying the policy decisions made that may contribute to those trends. She said that she would also like to see the information online in a dashboard format, understanding that it requires funding. 

Councilmember Overton said that it would be nice to have a way to identify or monitor as projects start using this document, to capture those things that went well or things that could be modified to make it work better.

Mayor Nabours suggested that the tasks listed be brought back to the Council one at a time.
             
8. Update on and Discussion of City of Flagstaff Resiliency and Preparedness Efforts
  Sustainability Specialist Tamara Lawless gave a PowerPoint Presentation which addressed:
 
♦OVERVIEW
            Review background information
            Review current resiliency projects
            Garner Council direction
 
♦BACKGROUND INFORMATION
            Climate projections for the Flagstaff area
                        Changing precipitation patterns
            COF Resiliency and Preparedness Study – 2012
                        Participants from City, County, National Weather Service
                        Assessed key components of government for vulnerability and risk
 
♦RESOLUTION 2012-22
            Policy 1 – Built partnerships with local/regional stakeholders
            Policy 2 – Consider impacts of weather on vulnerable populations
            Policy 3 – Institutionalize resiliency within City operations
            Policy 4 – Take weather extremes into City development planning
            Policy 5 – Prioritize resilience education within City operations
            Policy 6 – Develop comprehensive criteria into planning efforts
            Policy 7 – Allocate municipal resources to building adaptation
 
♦COUNCIL PRIORITIES AND REGIONAL PLAN POLICIES
            Council Goal 11
            Regional Plan Policies
 
♦FOREST MANAGEMENT – FWPP
            Approved by voters in November 2012
            Fosters resiliency through reducing threat of severe fire and post-fire flooding
            Update on current progress
 
At this time, Ms. Lawless asked Malcolm Alter to come forward as one of the City’s Champions of the Resiliency Program.
 
Stormwater Manager Malcolm Alter continued the PowerPoint presentation:
 
♦STORMWATER & UTILITIES
            FEMA Grant
            Projects to increase active and passive rainwater capture in community
            Increase resiliency and preparedness by reducing community flooding, preserving
                 functionality of wastewater treatment plants and conserving community water
                 resources
 
Vice Mayor Barotz said that she appreciated the mention of rainwater harvesting as she has not heard any feedback. Mr. Alter said that there was a disincentive to do it which led most to go away from the thirsty plans, which was one of the motives they had.
 
The next Champion to speak was Adam Miele, Public Works Project Manager, who continued the presentation:
 
♦ASPHALT INNOVATIONS – ADAM MIELE
            Freeze-thaw cycles have a detrimental impact on the integrity of asphalt projects
            Innovations in asphalt composition may improve the longevity of our roads,
                  conserving natural and fiscal resources
                        Potential additives: fibers, rubber
                        Portland cement vs. hydrated lime
            2016 construction season may incorporate pilot projects
 
Mayor Nabours said that over the last few years they have been using the millings from street overlays to pave some of the dirt roads, and he asked how that was working. Mr. Miele said that it worked well. They have recycled those millings, which have a higher “R” value, and are stronger than traditional base material. As they remove that material they are creating new surfaces which hold up well and that also reduces the amount removed from pits. They have also been using it for shoulder build-up.
 
Councilmember Brewster talked about the newer type of roads constructed, and their use of more rubberized asphalt, which produces less road roar. Mr. Miele said that they were using that a lot more in the overlay program. He said that they were not using it for that purpose but it was an added benefit.
 
Mr. Miele noted that Flagstaff has the highest freeze-thaw cycles in the country, with Boston coming in a close second.
 
At this time, Police Chief Kevin Treadway continued the presentation, as the final Champion:
 
♦POLICE DEPARTMENT
            Officers are often first responders in climatic events like flood and fires
            Increased fire prevention outreach and action
 
♦PROJECTED RESILIENCY WORK
            Workshops with key staff from each department
            Importance of strong leadership
            Discussion: How to support resilience and preparedness in this organization and
                community into the future
 
Vice Mayor Barotz said that one thing that occurred to her in looking through the information was she would like to see something about the City’s water supply in the face of these weather events. Ms. Lawless said that they did a workshop with the Utilities department and there is a lot of room to discuss that issue.
 
Vice Mayor Barotz said that she appreciated the report as it was very important and very relevant.
 
Mayor Nabours asked if staff also works with the gas company, APS, etc, or if they have their own plans. Ms. Lawless said that when they have their big meetings of collaborators, the utilities are normally involved. She said that she would assume they will be at the table with the COOP.
 
Councilmember Brewster said that it reminded her of months ago when the fiber optic line went down, and she asked if part of their plan involved the private companies. Ms. Lawless said that they were very vulnerable when that happened and they will make sure that the communication companies are at the table.
 
Ms. Lawless asked how else the Council would like to be involved in this program. Councilmember Brewster suggested that when they hold these emergency planning meetings, that they invite the Council.
 
Councilmember Putzova said that she appreciated the report; it was very valuable for them to understand the context. She said that she would be interested in getting more information with regard to prioritization of resources so that by the time the next budget discussion comes, everything is settled. She would like to know staff’s thoughts on where they should invest their resources to avoid costs down the road. Ms. Lawless said that she would be happy to put together a report with ideas and related costs.
 
Councilmember Evans said that the concept of resiliency is abstract when talking to individuals. It is complicated and diverse. She asked how they can make themselves more resilient, with short information statements and perhaps a spot on the city’s website with weekly updates, tips, etc. She said that if they are going to have meetings covering different topics perhaps they should videotape it and post it for the public.
 
The Council then took a break from 7:57 p.m. to 8:05 p.m.
             
9. Liquor License Presentation
  Sgt. Matt Wright with the Flagstaff Police Department gave a PowerPoint presentation, Exhibit A attached hereto and made a part hereof, which addressed:
 
♦TYPES OF LICENSES
            Non-Quota license – not available for sale on the open market
            Quota license – issued by lottery – only have so many allotted per county based on
                 population
♦LIQUOR LICENSE APPLICATION PROCESS
♦CONSIDERATIONS BY CITY COUNCIL
♦NORTHSIDE & SOUTHSIDE
♦LIQUOR LICENSES BY TYPES
 
Councilmember Evans said that 32% of the City’s liquor licenses are in downtown, including retail, convenience, etc. She asked what percentage it would be if they backed out the retail and convenience. Sgt. Wright said that he did not have the number in front of him but could get it to the Council.
 
♦2015 TOTALS
♦2013 VS. 2015
♦SATURATION PATROL
 
Councilmember Evans asked what the cost of resources were compared to other areas in town. Sgt. Wright said that from the patrol force’s perspective, they actually like having all of the bars in one area as it is easier to patrol.
 
Chief Treadway said that occasionally they will bring in officers on holiday weekends and the first few weeks of school and the few weeks before school gets out. He said that it is granted-funded overtime that handles that extra patrol.
 
Councilmember Evans said that she had not heard of the patrol force’s perspective before and was concerned that perhaps the businesses downtown should be addressing the extra costs rather than all of the residents.
 
FDBA Director Terry Madeksza address the Council stating that there is an emerging entertainment scene downtown and some of those restaurants and bars have become destinations, attracting visitors and residents alike. She said that any downtown needs to have a healthy mix of business. The key is management, product and experience offered. She said that rather than regulate the number of licenses in the downtown area, they would like to have the DBA, Chamber, City, etc. work together to support the overall business climate.
 
Ms. Madeksza said that they will work with property owners to seek the best use of the space, not necessarily the first one willing to pay. She said that they can also work with the retailers downtown to help them evolve their business model. She said that sometimes retailers will forget to change their window displays, etc. and by making the pedestrian experience better would probably draw more people in.
 
Mayor Nabours thanked Ms. Madeksza for attending the meeting and addressing the issue. He asked her if it was to be left to the downtown property owners or if the City had a role. Ms. Madeksza said that the City’s role is to review the applications that come before them and make recommendations, but she did not think there needs to be a cap put on the number of licenses. She said that in order to be the best downtown, they need to bring the different resources and talented staff together and be proactive with the business community.
 
Mayor Nabours asked Ms. Madeksza if she thought it could swing too far. He said that he would hate to see the downtown become a place where no one wants to go unless they are drinking. Ms. Madeksza said that was exactly why she was in Flagstaff.
 
Councilmember Evans thanked her for coming as well and agreed that they needed to have a vibrant downtown. She said that they also need to be mindful of the people that do not live in the downtown area, but just outside, as they are impacted as well.
 
Brief discussion was held on the verification of restaurants and meeting the 60/40 rule. She said that she heard there is one liquor control officer for the entire northern part of the state. She said that there has to be a different way for the bars to report things such as fake id’s. She believed that discouraged bars from calling in.
 
Ms. Madeksza said that she has lived on the corner of San Francisco and Aspen for the past three months and she can tell them what is happening downtown at 2:00 in the morning. She said that there is a true night time economy happening, but she does not know that the story is being defined and told. She said that it is not just students. People are spending money in the restaurants that stay open until 3:00 a.m. She wondered if there was a way to keep people downtown instead of having them roaming the streets, perhaps a better management of their exiting and control of the process.
 
Councilmember Evans said that if someone lives at the corner of San Francisco and Aspen, they can assume they are going to be woken up at 2:00 a.m. The issue is around Verde and Franklin, outside of the downtown area, but still being impacted.
  
Stuart McDaniel, representing the Greater Flagstaff Chamber of Commerce, said that he echoed a lot of the comments previously made. They are against any arbitrary limit on the number of licenses for many of the same reasons.
 
Mayor Nabours asked, if there were eight more bars downtown, if people are still going to want to bring their kids down to the Movies on the Square. Mr. McDaniel said that he would hope they could get eight other types of establishments as well.
 
Councilmember Overton said that the Mayor brings up a valid concern. The only oversight the community has is at the recommending body. He said that if the Chamber’s position changes in the future they need to come to the public hearings and voice their concerns.
 
Councilmember Evans said that they talk a lot about the free market. She asked what the Chamber thinks about the quality of life issues related to the liquor licenses. She would like to see that get into the conversation at some point. She said that it is great to talk about economic development, but she asked how they can ensure that they will maintain the quality of life.
 
Mr. McDaniel said that he completely agreed with Councilmember Evans. The responsibility is there and it is a critical element in everything they do. They are all charged to be good stewards and good neighbors.
 
Councilmember Brewster said that she agreed with both sides. Mr. McDaniel said that they have a nice mix right now. If it becomes oversaturated, they will be before the Council.
 
Mayor Nabours said that he wanted the word to go out that there may be a time where they hit that tipping point, and let the landlords consider that before they invest several thousand dollars, that it may not get approved.
             
10.
Review of Draft Agenda Items for the June 16, 2015, City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.
             
A. Consideration and Adoption of Resolution No. 2015-26: A resolution of the City Council of the City of Flagstaff, Coconino County, Arizona, calling a Special Election for November 3, 2015, and approving the ballot language for said election
  Ms. Burke briefly reviewed the process, noting that the resolution before the Council included wording on the six questions which Council had directed staff to bring forward.
 
Ms. D’Andrea reviewed the two personnel questions, explaining that currently the Personnel Rules and Regulations are adopted by the City Council, which is not entirely consistent with the Council/Manager form of government. The one question would turn over the establishment of the Personnel Rules and Regulations to the City Manager and the other question would include an exception that provides the Council with the ability to still have oversight on the due process for employees.
 
On question from Councilmember Overton, Ms. D’Andrea explained that there are different types of employees—those appointed by the Council directly, those that salary but do not report to Council and they still have due process right of appeal with a Deputy City Manager or City Manager, and then there are the other hourly employees, who have made it through their probationary period, and they have the right to go before a Personnel Board. 
 
She said that if Council does not want to have Question No. 2 proceed, or the citizens vote against it, then the City Manager could establish those rules as well, but if Council would like to hold on to the ability to determine the due process, they would want to move Question No. 2 forward.
 
Mayor Nabours said that the discussion previously started with how they felt about these questions, rather than whether they should be moved forward to allow the voters to determine the outcome. An example being that Councilmember Overton had a personal opinion on the purchasing contracts, and he happens to agree, but perhaps they should allow the voters to determine that issue.
 
Councilmember Putzova said that she has still not heard what the arguments are for changing the Charter. Councilmember Evans agreed. She said that if they were going to follow the Mayor’s logic, they would forward the entire list to the voters.
 
Ms. Burke explained that the list previously brought back to Council included the arguments on both sides of each of the questions. It was not staff’s place to make the arguments; the intent of the public outreach was to receive comments from the public.
 
Councilmember Putzova said that she was bothered by the entire process. Tonight they were discussing this after they had previously given direction on which questions to bring forward, and there was nothing included in the agenda packet to allow the public to know they would be discussing this. She said that these were very political questions.
 
Councilmember Evans said that she was very upset with what was going on this evening. She felt that last time they discussed this they gave staff direction; now they are being told that their personal opinions should be taken out of it. She said that she did not have the original list but she knew that districts were on the list. If they are moving these other items forward, they should just move everything forward from the original list. She did not feel the process this evening was transparent and it was disingenuous.
 
Ms. Burke explained that the Committee sent forward to the City Manager a list of 30 questions, with a recommendation to take the top 20 to the voters. The City Manager then added a few questions of his own and brought everything back to the Council; Districts did not make the top 20 list.
 
Mayor Nabours said that he brought this issue up because he does not want to wait until next week and have amendments to questions being made. By discussion it this evening they could provide further direction to staff if needed so it could be decided next week.
 
Councilmember Evans said that if they were going to be bringing back additional questions, they need to allow the Council to vote on them separately, because she would not support the additional questions.
 
Vice Mayor Barotz said that she was struggling with the notion of not considering personal opinion. If they are going to argue that, then they should send all 15 of these questions, although she did not support that.
 
Councilmember Putzova requested that next week’s presentation include an over view of the entire process, including the committee application process and a complete list of the 30 questions.
 
Mr. Meilbeck said that last week he had asked staff to put the entire list back into the packet. It was not clear to him that the six questions presented were the final list.
 
Ms. D’Andrea said that they have drafted the six questions as directed; the rest they have not. She would assume that if Council wanted to direct further questions to be considered that they would go on a future ballot. Mayor Nabours said that it was his understanding that they had until the first meeting in July to adopt the final language for the ballot, so that would allow a little more time for Legal to prepare ballot language.
             
11. Public Participation

None
             
12. Informational Items To/From Mayor, Council, and City Manager; requests for future agenda items.
             
13. Adjournment
  The Work Session of the Flagstaff City Council held June 9, 2015, adjourned at 9:35 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 03-May-24 01:46 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
218 ms 218 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
31 ms 31 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/Application.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
218 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 @ 01:46:49.049
			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 @ 01:46:49.049
				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 @ 01:46:49.049
			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 @ 01:46:49.049
				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 @ 01:46:49.049
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 01:46:49.049
	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 @ 01:46:49.049
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:46:49.049
		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 @ 01:46:49.049
	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 @ 01:46:49.049
		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 @ 01:46:49.049
	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 @ 01:46:49.049
	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 @ 01:46:49.049
		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 @ 01:46:49.049
		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 @ 01:46:49.049
	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 @ 01:46:49.049
	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 @ 01:46:49.049
	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 @ 01:46:49.049
	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 @ 01:46:49.049
	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 @ 01:46:49.049
	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 @ 01:46:49.049
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:46:49.049
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=16ms, Records=10) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:46:49.049
		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) = 2015-06-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2015-06-30 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 01:46:49.049
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
		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 @ 01:46:49.049
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 = 357 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 01:46:49.049
		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) = 357

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 01:46:49.049
			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(357 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 @ 01:46:49.049
	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 @ 01:46:49.049
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 357 
getAllMnLines (Datasource=frsRO, Time=46ms, Records=16) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
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 = 357 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 = 74 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=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
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 @ 01:46:49.049
	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 @ 01:46:49.049
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
		
	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 = 74 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=16ms, Records=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 74 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=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2208 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1580 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2214 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2206 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2209 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2207 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1581 
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2217 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1582 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1583 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2218 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1584 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2219 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1585 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2216 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1586 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2210 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2220 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1590 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2212 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2211 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2213 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:46:49.049
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1589 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 01:46:49.049
	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 @ 01:46:49.049
	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 @ 01:46:49.049
		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 @ 01:46:49.049
		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=6&get_year=2015&dsp=min&seq=357
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=6&get_year=2015&dsp=min&seq=357
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=9473160
cftoken=42d05c8651555a52-682650F8-C5B6-F42D-FD34C1E31AE80E0E
hitcount=4
lastvisit={ts '2024-05-03 01:46:49'}
timecreated={ts '2024-05-03 01:46:49'}
urltoken=CFID=9473160&CFTOKEN=42d05c8651555a52-682650F8-C5B6-F42D-FD34C1E31AE80E0E
Cookie Variables:
CFID=9473160
CFTOKEN=42d05c8651555a52-682650F8-C5B6-F42D-FD34C1E31AE80E0E
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=357
Session Variables:
cfid=9473160
cftoken=42d05c8651555a52-682650F8-C5B6-F42D-FD34C1E31AE80E0E
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9473160_42d05c8651555a52-682650F8-C5B6-F42D-FD34C1E31AE80E0E
subdir=/public/
tzoffset=0
urltoken=CFID=9473160&CFTOKEN=42d05c8651555a52-682650F8-C5B6-F42D-FD34C1E31AE80E0E
URL Parameters:
dsp=min
get_month=6
get_year=2015
id=
mt=ALL
seq=357
Debug Rendering Time: 0 ms