City of Chandler · Meeting 1032 failed
2023-12-04 · Study Session
Items: 37 / 37
Votes: 1
Votes: 1
City Council Study Session
Synced: 2026-05-27 14:03 AZ
Last attempted: 2026-07-10 15:58 AZ
Retries: 1
Last error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_supporting_doc_item_url" DETAIL: Key (agenda_item_id, document_url)=(0, https://public.destinyhosted.com/chanddocs/2023/CC/20231204_1036/5188_5188_Bucket_Truck_Quote_w.Photos1.pdf) already exists. [SQL: INSERT INTO supporting_documents (body, agenda_item_id, meeting_id, meeting_db_id, agenda_item_number, c_number, c_number_base, c_number_revision, document_title, document_url, document_type, file_name, file_extension, local_path, content_hash, scrap ... 41158 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'document_title__0': 'Quote w.Photos', 'content_hash__0': None, 'body__0': 'chandler-cc', 'jurisdiction_id__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2023/CC/20231204_1036/5188_5188_Bucket_Truck_Quote_w.Photos1.pdf', 'agenda_item_number__0': '2', 'text_content__0': None, 'created_at__0': datetime.datetime(2026, 7, 10, 22, 58, 21, 112627, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'meeting_db_id__0': 4611, 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 58, 21, 112638, tzinfo=datetime.timezone.utc), 'text_extracted_at__0': None, 'local_path__0': None, 'c_number_revision__0': None, 'c_number__0': None, 'meeting_id__0': '1032', 'search_vector__0': None, 'agenda_item_id__0': 0, 'document_type__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 58, 21, 87487, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'file_name__0': None, 'c_number_base__0': None, 'extraction_duration_ms__0': None, 'document_title__1': 'Location Map', 'content_hash__1': None, 'body__1': 'chandler-cc', 'jurisdiction_id__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2023/CC/20231204_1036/5299_CP24-078.pdf', 'agenda_item_number__1': '3', 'text_content__1': None, 'created_at__1': datetime.datetime(2026, 7, 10, 22, 58, 21, 112639, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'meeting_db_id__1': 4611, 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 58, 21, 112640, tzinfo=datetime.timezone.utc), 'text_extracted_at__1': None, 'local_path__1': None, 'c_number_revision__1': None, 'c_number__1': None, 'meeting_id__1': '1032', 'search_vector__1': None, 'agenda_item_id__1': 0, 'document_type__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 58, 21, 87548, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'file_name__1': None, 'c_number_base__1': None, 'extraction_duration_ms__1': None, 'document_title__2': 'Construction Contract', 'content_hash__2': None ... 1652 parameters truncated ... 'c_number_base__70': None, 'extraction_duration_ms__70': None, 'document_title__71': 'October 18, 2023 Regular Meeting Minutes', 'content_hash__71': None, 'body__71': 'chandler-cc', 'jurisdiction_id__71': None, 'document_url__71': 'https://public.destinyhosted.com/chanddocs/2023/CC/20231204_1036/5317_10.18.2023_Signed_Regular_Meeting_Minutes.pdf', 'agenda_item_number__71': '36', 'text_content__71': None, 'created_at__71': datetime.datetime(2026, 7, 10, 22, 58, 21, 112760, tzinfo=datetime.timezone.utc), 'text_extraction_method__71': None, 'meeting_db_id__71': 4611, 'updated_at__71': datetime.datetime(2026, 7, 10, 22, 58, 21, 112760, tzinfo=datetime.timezone.utc), 'text_extracted_at__71': None, 'local_path__71': None, 'c_number_revision__71': None, 'c_number__71': None, 'meeting_id__71': '1032', 'search_vector__71': None, 'agenda_item_id__71': 0, 'document_type__71': None, 'scraped_at__71': datetime.datetime(2026, 7, 10, 22, 58, 21, 90364, tzinfo=datetime.timezone.utc), 'file_extension__71': 'pdf', 'file_name__71': None, 'c_number_base__71': None, 'extraction_duration_ms__71': None, 'document_title__72': 'Contracts and Agreements Administratively Approved', 'content_hash__72': None, 'body__72': 'chandler-cc', 'jurisdiction_id__72': None, 'document_url__72': 'https://public.destinyhosted.com/chanddocs/2023/CC/20231204_1036/5318_12.7.23_Informational_Procurement_Council_Item.pdf', 'agenda_item_number__72': '37', 'text_content__72': None, 'created_at__72': datetime.datetime(2026, 7, 10, 22, 58, 21, 112761, tzinfo=datetime.timezone.utc), 'text_extraction_method__72': None, 'meeting_db_id__72': 4611, 'updated_at__72': datetime.datetime(2026, 7, 10, 22, 58, 21, 112761, tzinfo=datetime.timezone.utc), 'text_extracted_at__72': None, 'local_path__72': None, 'c_number_revision__72': None, 'c_number__72': None, 'meeting_id__72': '1032', 'search_vector__72': None, 'agenda_item_id__72': 0, 'document_type__72': None, 'scraped_at__72': datetime.datetime(2026, 7, 10, 22, 58, 21, 90397, tzinfo=datetime.timezone.utc), 'file_extension__72': 'pdf', 'file_name__72': None, 'c_number_base__72': None, 'extraction_duration_ms__72': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 15:58 AZ
Retries: 1
Last error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "uq_supporting_doc_item_url" DETAIL: Key (agenda_item_id, document_url)=(0, https://public.destinyhosted.com/chanddocs/2023/CC/20231204_1036/5188_5188_Bucket_Truck_Quote_w.Photos1.pdf) already exists. [SQL: INSERT INTO supporting_documents (body, agenda_item_id, meeting_id, meeting_db_id, agenda_item_number, c_number, c_number_base, c_number_revision, document_title, document_url, document_type, file_name, file_extension, local_path, content_hash, scrap ... 41158 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'document_title__0': 'Quote w.Photos', 'content_hash__0': None, 'body__0': 'chandler-cc', 'jurisdiction_id__0': None, 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2023/CC/20231204_1036/5188_5188_Bucket_Truck_Quote_w.Photos1.pdf', 'agenda_item_number__0': '2', 'text_content__0': None, 'created_at__0': datetime.datetime(2026, 7, 10, 22, 58, 21, 112627, tzinfo=datetime.timezone.utc), 'text_extraction_method__0': None, 'meeting_db_id__0': 4611, 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 58, 21, 112638, tzinfo=datetime.timezone.utc), 'text_extracted_at__0': None, 'local_path__0': None, 'c_number_revision__0': None, 'c_number__0': None, 'meeting_id__0': '1032', 'search_vector__0': None, 'agenda_item_id__0': 0, 'document_type__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 58, 21, 87487, tzinfo=datetime.timezone.utc), 'file_extension__0': 'pdf', 'file_name__0': None, 'c_number_base__0': None, 'extraction_duration_ms__0': None, 'document_title__1': 'Location Map', 'content_hash__1': None, 'body__1': 'chandler-cc', 'jurisdiction_id__1': None, 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2023/CC/20231204_1036/5299_CP24-078.pdf', 'agenda_item_number__1': '3', 'text_content__1': None, 'created_at__1': datetime.datetime(2026, 7, 10, 22, 58, 21, 112639, tzinfo=datetime.timezone.utc), 'text_extraction_method__1': None, 'meeting_db_id__1': 4611, 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 58, 21, 112640, tzinfo=datetime.timezone.utc), 'text_extracted_at__1': None, 'local_path__1': None, 'c_number_revision__1': None, 'c_number__1': None, 'meeting_id__1': '1032', 'search_vector__1': None, 'agenda_item_id__1': 0, 'document_type__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 58, 21, 87548, tzinfo=datetime.timezone.utc), 'file_extension__1': 'pdf', 'file_name__1': None, 'c_number_base__1': None, 'extraction_duration_ms__1': None, 'document_title__2': 'Construction Contract', 'content_hash__2': None ... 1652 parameters truncated ... 'c_number_base__70': None, 'extraction_duration_ms__70': None, 'document_title__71': 'October 18, 2023 Regular Meeting Minutes', 'content_hash__71': None, 'body__71': 'chandler-cc', 'jurisdiction_id__71': None, 'document_url__71': 'https://public.destinyhosted.com/chanddocs/2023/CC/20231204_1036/5317_10.18.2023_Signed_Regular_Meeting_Minutes.pdf', 'agenda_item_number__71': '36', 'text_content__71': None, 'created_at__71': datetime.datetime(2026, 7, 10, 22, 58, 21, 112760, tzinfo=datetime.timezone.utc), 'text_extraction_method__71': None, 'meeting_db_id__71': 4611, 'updated_at__71': datetime.datetime(2026, 7, 10, 22, 58, 21, 112760, tzinfo=datetime.timezone.utc), 'text_extracted_at__71': None, 'local_path__71': None, 'c_number_revision__71': None, 'c_number__71': None, 'meeting_id__71': '1032', 'search_vector__71': None, 'agenda_item_id__71': 0, 'document_type__71': None, 'scraped_at__71': datetime.datetime(2026, 7, 10, 22, 58, 21, 90364, tzinfo=datetime.timezone.utc), 'file_extension__71': 'pdf', 'file_name__71': None, 'c_number_base__71': None, 'extraction_duration_ms__71': None, 'document_title__72': 'Contracts and Agreements Administratively Approved', 'content_hash__72': None, 'body__72': 'chandler-cc', 'jurisdiction_id__72': None, 'document_url__72': 'https://public.destinyhosted.com/chanddocs/2023/CC/20231204_1036/5318_12.7.23_Informational_Procurement_Council_Item.pdf', 'agenda_item_number__72': '37', 'text_content__72': None, 'created_at__72': datetime.datetime(2026, 7, 10, 22, 58, 21, 112761, tzinfo=datetime.timezone.utc), 'text_extraction_method__72': None, 'meeting_db_id__72': 4611, 'updated_at__72': datetime.datetime(2026, 7, 10, 22, 58, 21, 112761, tzinfo=datetime.timezone.utc), 'text_extracted_at__72': None, 'local_path__72': None, 'c_number_revision__72': None, 'c_number__72': None, 'meeting_id__72': '1032', 'search_vector__72': None, 'agenda_item_id__72': 0, 'document_type__72': None, 'scraped_at__72': datetime.datetime(2026, 7, 10, 22, 58, 21, 90397, tzinfo=datetime.timezone.utc), 'file_extension__72': 'pdf', 'file_name__72': None, 'c_number_base__72': None, 'extraction_duration_ms__72': None}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Item text
Move City Council approve the Board and Commission appointments as recommended.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council approve the utilization of Sourcewell Contract No.110421-TER, for the purchase of a bucket truck, from Custom Truck One Source, in the amount of $173,812.32.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award CMAR Construction Services Agreement No. PR2201.401, Guaranteed Maximum Price Proposal No. 1, to Chasse Building Team, Inc., for the Tumbleweed Recreation Center Multi-Generational Facility Expansion, in an amount not to exceed $11,585,136; and award the related municipal arts project services agreement to coLAB Studio, LLC, in an amount not to exceed $300,000; and authorize an appropriation transfer of $25,000 from the General Fund, Non-Departmental Contingency account, to the Municipal Arts Fund, Center for the Arts, Improvements account.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award Professional Services Agreement No. PR2201.271 to Barker Rinker Seacat Architecture, for the Tumbleweed Recreation Center Multi-Generational Facility Expansion p ost-design services, in an amount not to exceed $356,535.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award Professional Services Agreement No. PR2201.452 to Marc Taylor, Inc., for the Tumbleweed Recreation Center Multi-Generational Facility Expansion Construction Management Services, in an amount not to exceed $1,453,055.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council approve Agreement No. PW0-745-4183, Amendment No. 7, with M.R. Tanner Development and Construction, Inc., for street maintenance repaving, surface seal, and repair services, increasing the spending limit by $151,534 for the Arrowhead Aquatic Center north parking lot; and approve the transfer of appropriation from the Community Services Department, Existing Community Park Improvements Program (6PR530), to the Public Works and Utilities Department, City-Owned Parking Lot Maintenance and Resurfacing Program (6ST777) in the amount of $151,534.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-23-0029
Item text
Move City Council introduce and tentatively adopt Ordinance No. 5074 approving PLH23-0029 Alma Office Building Rezoning, Rezoning from Single-Family Residential (SF-8.5) to Planned Area Development (PAD) for administrative office and limited commercial uses, subject to the conditions as recommended by Planning and Zoning Commission.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLT-22-0023
Item text
Move City Council approve Final Plat, PLT22-0023, as recommended by staff.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-23-0045
Item text
Move City Council approve Entertainment Use Permit, PLH23-0045 Buon Padre Pizza, to allow televisions, speakers, and live entertainment within an outdoor patio, subject to the conditions recommended by Planning and Zoning Commission.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council approve Agreement No. PD2-055-4378, Amendment No. 2, with American Emergency Products, Inc., MHQ of Arizona, and Pride Outfitting, LLC; and the utilization of the City of Phoenix Contract No. 159257-0, with Airwave Communication Enterprises, for Police and Fire Vehicle Upfitting, in a combined amount not to exceed $1,263,311.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council approve Agreement No. 4698, within Invoke, LLC, for Microsoft information technology consulting services, for a period of one year, beginning November 15, 2023, through November 14, 2024, in an amount not to exceed $570,000.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council approve Agreement No. 4577, with N. Harris Computer Corporation, for implementation of Infinity CIS Version 5, in an amount not to exceed $2,228,100, with a support and maintenance term of five years, with the option of up to four one-year extensions, and approve contingency transfers from the Water Operating Fund of $435,610, the Wastewater Operating Fund of $326,634, and the Solid Waste Operating Fund of $217,756, for a total of $980,000, to the IT Projects Capital Cost Center (1285), Utility Billing Replatform Program (6IC112).
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Iga Counterparty
Chandler
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Iga Counterparty
the City of Chandler to Accept Community Services Block Grant Funds
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Iga Counterparty
the City of Chandler
Reference
C-22-23-079-X-00
Item text
Move City Council pass and adopt Resolution No. 5761 approving amendment No. 1 to intergovernmental agreement C-22-23-079-X-00 between Maricopa County, administered by its Human Services Department, and the City of Chandler for heat relief services to extend the term to December 31, 2024; authorizing the City Manager to sign all related documents and assurances on behalf of the City of Chandler; and further authorizing the City Manager to take all action necessary or prudent to implement the agreement.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Iga Counterparty
said program
Item text
Move City Council pass and adopt Resolution No. 5759 authorizing Intergovernmental Agreements (IGAs) with the Chandler Unified School District No. 80, Kyrene Elementary School District No. 28, and Mesa Unified School District No. 4 for the assignment of School Resource Officers to schools located within the Chandler City limits; authorizing the Mayor to sign the agreements; and authorizing the Chief of Police to administer, execute, and submit all documents and other necessary instruments in connection with said program.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council introduce and tentatively adopt Ordinance No. 5073 granting a non-exclusive utility easement to Arizona Public Service Company, at no cost, to accommodate the Wall Street Improvement Project (Frye Road to Chicago Street).
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council pass and adopt Resolution No. 5719 authorizing the acquisition of real property rights required for the Wall Street Improvement Project (Project No. CA2202), from Frye Road to Chicago Street; authorizing the city's Real Estate Administrator to sign the purchase agreements, authorizations to access property, and any other documents necessary to facilitate these acquisitions and access to the properties; authorizing eminent domain proceedings, as needed, to acquire said real property and obtain immediate possession thereof; and authorizing relocation assistance as may be required by law.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award Job Order Project Agreement No. ST2017.403, to Sunland Asphalt & Construction, Inc., Pursuant to Job Order Master Agreement No. JOC1909.401, for Quiet Zone Improvements, in an amount not to exceed $237,410.40.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award Professional Services Agreement No. WA2401.451, to Hazen and Sawyer, P.C., for the Pecos Surface Water Treatment Plant Filter Improvements Phase 2 Construction Management Services, in an amount not to exceed $189,290.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award Job Order Project Agreement No. WA2401.402, to PCL Construction, Inc., Pursuant to Job Order Master Agreement No. JOC1915.401, for the Pecos Surface Water Treatment Plant Filter Improvements Phase 2, in an amount not to exceed $761,888.80.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council approve Agreement No. PW2-988-4407, Amendment No. 2, with Artistic Land Management, Inc., for Public Works landscape services, in an amount not to exceed $1,152,000, for a one-year term, January 1, 2024, through December 31, 2024.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award CMAR Construction Services Agreement No. WW2206.401, GMP No. 2, to PCL Construction, Inc., for the Reclaimed Water Conveyance Improvements, in the amount of $10,967,208.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award Professional Services Agreement No. WW2206.451, Amendment No. 1, to Wilson Engineers, LLC, for the Reclaimed Water Conveyance Improvements Construction Management Services, in the amount of $1,316,320.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award Professional Services Agreement No. WW2106.271 to Brown and Caldwell, Inc., for the Sewer Lift Station Rehabilitation Post-Design Services, in an amount not to exceed $179,814.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award Professional Services Agreement No. WW2106.451, Amendment No. 4, to Entellus, Inc., for the Sewer Lift Station Rehabilitation Construction Management Services, in the amount of $1,058,243.84.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award CMAR Construction Services Agreement No. WW2106.401, to MGC Contractors, Inc., for the Sewer Lift Station Rehabilitation, in an amount not to exceed $9,280,107.02.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award CMAR Construction Services Agreement No. WW2106.402, to MGC Contractors, Inc., for the Manganaro Lift Station Electrical Improvements, in an amount not to exceed $2,707,998.57.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award CMAR Construction Services Agreement No. WA2105.401, to PCL Construction, Inc., for the Water Facilities Optimization Improvements – Hunt Highway Water Production Facility Rehabilitation, in an amount not to exceed $3,317,089.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award Professional Services Agreement No. WA2105.451, to Water Works Engineers, LLC, for the Water Facilities Optimization Improvements – Hunt Highway Water Production Facility Rehabilitation Construction Management Services, in an amount not to exceed $127,130.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
37 item(s)