City of Chandler · Meeting 1186 failed
2024-01-22 · Study Session
Items: 17 / 17
City Council Study Session
Synced: 2026-05-27 16:32 AZ
Last attempted: 2026-07-10 15:59 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/2024/CC/20240122_1190/5491_5491_Ordinance_No_5077_Chandler_Aviation_Lease.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 ... 13258 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'content_hash__0': None, 'extraction_duration_ms__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 59, 10, 959710, tzinfo=datetime.timezone.utc), 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2024/CC/20240122_1190/5491_5491_Ordinance_No_5077_Chandler_Aviation_Lease.pdf', 'search_vector__0': None, 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 59, 10, 978318, tzinfo=datetime.timezone.utc), 'created_at__0': datetime.datetime(2026, 7, 10, 22, 59, 10, 978308, tzinfo=datetime.timezone.utc), 'file_name__0': None, 'c_number_base__0': None, 'text_content__0': None, 'document_type__0': None, 'c_number__0': None, 'agenda_item_number__0': '1', 'jurisdiction_id__0': None, 'body__0': 'chandler-cc', 'text_extracted_at__0': None, 'meeting_id__0': '1186', 'c_number_revision__0': None, 'agenda_item_id__0': 0, 'text_extraction_method__0': None, 'meeting_db_id__0': 2139, 'local_path__0': None, 'document_title__0': 'Ordinance No. 5077', 'file_extension__0': 'pdf', 'content_hash__1': None, 'extraction_duration_ms__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 59, 10, 959807, tzinfo=datetime.timezone.utc), 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2024/CC/20240122_1190/5491_2024-01-05_Amendment_1_to_First_Amended_and_Restated_Ground_Lease_Chandler_Aviation.pdf', 'search_vector__1': None, 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 59, 10, 978322, tzinfo=datetime.timezone.utc), 'created_at__1': datetime.datetime(2026, 7, 10, 22, 59, 10, 978321, tzinfo=datetime.timezone.utc), 'file_name__1': None, 'c_number_base__1': None, 'text_content__1': None, 'document_type__1': None, 'c_number__1': None, 'agenda_item_number__1': '1', 'jurisdiction_id__1': None, 'body__1': 'chandler-cc', 'text_extracted_at__1': None, 'meeting_id__1': '1186', 'c_number_revision__1': None, 'agenda_item_id__1': 0, 'text_extraction_method__1': None, 'meeting_db_id__1': 2139, 'local_path__1': None, 'document_title__1': 'Amendment No.1 to Ground Lease', 'file_extension__1': 'pdf', 'content_hash__2': None, 'extraction_duration_ms__2': None ... 452 parameters truncated ... 'document_title__20': 'Special Event Liquor Licenses and Temporary and Permanent Extensions of Liquor License Premises Administratively Approved', 'file_extension__20': 'pdf', 'content_hash__21': None, 'extraction_duration_ms__21': None, 'scraped_at__21': datetime.datetime(2026, 7, 10, 22, 59, 10, 961220, tzinfo=datetime.timezone.utc), 'document_url__21': 'https://public.destinyhosted.com/chanddocs/2024/CC/20240122_1190/5455_Claims_Report_-_Oct_1_-_Dec_31_2023.pdf', 'search_vector__21': None, 'updated_at__21': datetime.datetime(2026, 7, 10, 22, 59, 10, 978378, tzinfo=datetime.timezone.utc), 'created_at__21': datetime.datetime(2026, 7, 10, 22, 59, 10, 978376, tzinfo=datetime.timezone.utc), 'file_name__21': None, 'c_number_base__21': None, 'text_content__21': None, 'document_type__21': None, 'c_number__21': None, 'agenda_item_number__21': '13', 'jurisdiction_id__21': None, 'body__21': 'chandler-cc', 'text_extracted_at__21': None, 'meeting_id__21': '1186', 'c_number_revision__21': None, 'agenda_item_id__21': 0, 'text_extraction_method__21': None, 'meeting_db_id__21': 2139, 'local_path__21': None, 'document_title__21': 'Claims Report - December 31, 2023', 'file_extension__21': 'pdf', 'content_hash__22': None, 'extraction_duration_ms__22': None, 'scraped_at__22': datetime.datetime(2026, 7, 10, 22, 59, 10, 961294, tzinfo=datetime.timezone.utc), 'document_url__22': 'https://public.destinyhosted.com/chanddocs/2024/CC/20240122_1190/5476_1.25.24_Informational_Procurement_Council_Item.pdf', 'search_vector__22': None, 'updated_at__22': datetime.datetime(2026, 7, 10, 22, 59, 10, 978380, tzinfo=datetime.timezone.utc), 'created_at__22': datetime.datetime(2026, 7, 10, 22, 59, 10, 978379, tzinfo=datetime.timezone.utc), 'file_name__22': None, 'c_number_base__22': None, 'text_content__22': None, 'document_type__22': None, 'c_number__22': None, 'agenda_item_number__22': '14', 'jurisdiction_id__22': None, 'body__22': 'chandler-cc', 'text_extracted_at__22': None, 'meeting_id__22': '1186', 'c_number_revision__22': None, 'agenda_item_id__22': 0, 'text_extraction_method__22': None, 'meeting_db_id__22': 2139, 'local_path__22': None, 'document_title__22': 'Contracts and Agreements Administratively Approved', 'file_extension__22': 'pdf'}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
Last attempted: 2026-07-10 15:59 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/2024/CC/20240122_1190/5491_5491_Ordinance_No_5077_Chandler_Aviation_Lease.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 ... 13258 characters truncated ... en_counter) ORDER BY sen_counter RETURNING supporting_documents.id, supporting_documents.id AS id__1] [parameters: {'content_hash__0': None, 'extraction_duration_ms__0': None, 'scraped_at__0': datetime.datetime(2026, 7, 10, 22, 59, 10, 959710, tzinfo=datetime.timezone.utc), 'document_url__0': 'https://public.destinyhosted.com/chanddocs/2024/CC/20240122_1190/5491_5491_Ordinance_No_5077_Chandler_Aviation_Lease.pdf', 'search_vector__0': None, 'updated_at__0': datetime.datetime(2026, 7, 10, 22, 59, 10, 978318, tzinfo=datetime.timezone.utc), 'created_at__0': datetime.datetime(2026, 7, 10, 22, 59, 10, 978308, tzinfo=datetime.timezone.utc), 'file_name__0': None, 'c_number_base__0': None, 'text_content__0': None, 'document_type__0': None, 'c_number__0': None, 'agenda_item_number__0': '1', 'jurisdiction_id__0': None, 'body__0': 'chandler-cc', 'text_extracted_at__0': None, 'meeting_id__0': '1186', 'c_number_revision__0': None, 'agenda_item_id__0': 0, 'text_extraction_method__0': None, 'meeting_db_id__0': 2139, 'local_path__0': None, 'document_title__0': 'Ordinance No. 5077', 'file_extension__0': 'pdf', 'content_hash__1': None, 'extraction_duration_ms__1': None, 'scraped_at__1': datetime.datetime(2026, 7, 10, 22, 59, 10, 959807, tzinfo=datetime.timezone.utc), 'document_url__1': 'https://public.destinyhosted.com/chanddocs/2024/CC/20240122_1190/5491_2024-01-05_Amendment_1_to_First_Amended_and_Restated_Ground_Lease_Chandler_Aviation.pdf', 'search_vector__1': None, 'updated_at__1': datetime.datetime(2026, 7, 10, 22, 59, 10, 978322, tzinfo=datetime.timezone.utc), 'created_at__1': datetime.datetime(2026, 7, 10, 22, 59, 10, 978321, tzinfo=datetime.timezone.utc), 'file_name__1': None, 'c_number_base__1': None, 'text_content__1': None, 'document_type__1': None, 'c_number__1': None, 'agenda_item_number__1': '1', 'jurisdiction_id__1': None, 'body__1': 'chandler-cc', 'text_extracted_at__1': None, 'meeting_id__1': '1186', 'c_number_revision__1': None, 'agenda_item_id__1': 0, 'text_extraction_method__1': None, 'meeting_db_id__1': 2139, 'local_path__1': None, 'document_title__1': 'Amendment No.1 to Ground Lease', 'file_extension__1': 'pdf', 'content_hash__2': None, 'extraction_duration_ms__2': None ... 452 parameters truncated ... 'document_title__20': 'Special Event Liquor Licenses and Temporary and Permanent Extensions of Liquor License Premises Administratively Approved', 'file_extension__20': 'pdf', 'content_hash__21': None, 'extraction_duration_ms__21': None, 'scraped_at__21': datetime.datetime(2026, 7, 10, 22, 59, 10, 961220, tzinfo=datetime.timezone.utc), 'document_url__21': 'https://public.destinyhosted.com/chanddocs/2024/CC/20240122_1190/5455_Claims_Report_-_Oct_1_-_Dec_31_2023.pdf', 'search_vector__21': None, 'updated_at__21': datetime.datetime(2026, 7, 10, 22, 59, 10, 978378, tzinfo=datetime.timezone.utc), 'created_at__21': datetime.datetime(2026, 7, 10, 22, 59, 10, 978376, tzinfo=datetime.timezone.utc), 'file_name__21': None, 'c_number_base__21': None, 'text_content__21': None, 'document_type__21': None, 'c_number__21': None, 'agenda_item_number__21': '13', 'jurisdiction_id__21': None, 'body__21': 'chandler-cc', 'text_extracted_at__21': None, 'meeting_id__21': '1186', 'c_number_revision__21': None, 'agenda_item_id__21': 0, 'text_extraction_method__21': None, 'meeting_db_id__21': 2139, 'local_path__21': None, 'document_title__21': 'Claims Report - December 31, 2023', 'file_extension__21': 'pdf', 'content_hash__22': None, 'extraction_duration_ms__22': None, 'scraped_at__22': datetime.datetime(2026, 7, 10, 22, 59, 10, 961294, tzinfo=datetime.timezone.utc), 'document_url__22': 'https://public.destinyhosted.com/chanddocs/2024/CC/20240122_1190/5476_1.25.24_Informational_Procurement_Council_Item.pdf', 'search_vector__22': None, 'updated_at__22': datetime.datetime(2026, 7, 10, 22, 59, 10, 978380, tzinfo=datetime.timezone.utc), 'created_at__22': datetime.datetime(2026, 7, 10, 22, 59, 10, 978379, tzinfo=datetime.timezone.utc), 'file_name__22': None, 'c_number_base__22': None, 'text_content__22': None, 'document_type__22': None, 'c_number__22': None, 'agenda_item_number__22': '14', 'jurisdiction_id__22': None, 'body__22': 'chandler-cc', 'text_extracted_at__22': None, 'meeting_id__22': '1186', 'c_number_revision__22': None, 'agenda_item_id__22': 0, 'text_extraction_method__22': None, 'meeting_db_id__22': 2139, 'local_path__22': None, 'document_title__22': 'Contracts and Agreements Administratively Approved', 'file_extension__22': 'pdf'}] (Background on this error at: https://sqlalche.me/e/20/gkpj)
- Case
-
PLH-23-0038
Item text
Move City Council adopt Ordinance No. 5076 approving PLH23-0038 Grayhawk Residences at Chandler, Rezoning from General Industrial (I-2) District to Planned Area Development (PAD) for Multi-Family Residential with Mid-Rise Overlay to allow heights up to seventy (70) feet, subject to the conditions as recommended by Planning and Zoning Commission.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-23-0062
Item text
Move City Council approve Use Permit and Entertainment Use Permit PLH23-0062 Lola's Liquors, for operation of a bar and for indoor live entertainment, subject to the conditions recommended by Planning and Zoning Commission
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
PLH-23-0069
Item text
Move City Council approve Entertainment Use Permit, PLH23-0069 Murphy's Law Irish Pub, for indoor live entertainment and outdoor patio speakers, subject to the conditions recommended by Planning and Zoning Commission.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
- Case
-
CTR059323
Item text
Move City Council approve the purchase of vehicle upfitting, utilizing the State of Arizona Contract No. CTR059323, with San Tan Ford, in an amount not to exceed $488,874.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council accept and ratify the City Manager's Report of Emergency Authorization, for information technology services, from Kyndryl, Inc., Booz Allen Hamilton, Inc., and Mullen Coughlin, LLC, in the combined amount of $241,923.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
Item text
Move City Council award Professional Services Agreement No. ST2303.201, to AZTEC Engineering Group, Inc., for the Cooper Road/Insight Way Loop Extension Design Services, in an amount not to exceed $699,272.18.
Supporting documents
No supporting documents stored.
View on Agenda Online ↗
14 item(s)