QA

 Recent updates RSS feed

welcome

... to the Alameda County Transportation Commission! We are a newly-formed countywide transportation agency, resulting from a merger of the Alameda County Congestion Management Agency (ACCMA) and the Alameda County Transportation Improvement Authority (ACTIA). Our mission is to plan, fund and deliver a broad spectrum of transportation projects and programs to enhance mobility throughout Alameda County. This merger will eliminate redundancies and create efficiencies in planning, programs and project delivery and streamline legislative, policy and funding efforts.
ACCMA website link ACTIA website link

This website contains information for the Alameda CTC, which holds its first meeting on July 22, 2010. For projects, programs, reports and archived information related to ACCMA or ACTIA, click on the appropriate button above.
meeting calendar link
opportunities link news link		 e-notifier link
(default) 29 queries took 303 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';0515
2SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'aros' AND table_schema = 'public' ORDER BY position0720
3SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'acos' AND table_schema = 'public' ORDER BY position0715
4SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'aros_acos' AND table_schema = 'public' ORDER BY position0716
5SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'users' AND table_schema = 'public' ORDER BY position01219
6SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'user_settings' AND table_schema = 'public' ORDER BY position0413
7SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'email_frequencies' AND table_schema = 'public' ORDER BY position0211
8SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'app_object_types' AND table_schema = 'public' ORDER BY position0715
9SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'app_object_types_user_settings' AND table_schema = 'public' ORDER BY position0313
10SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'roles' AND table_schema = 'public' ORDER BY position0615
11SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'group_roles' AND table_schema = 'public' ORDER BY position0312
12SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'groups' AND table_schema = 'public' ORDER BY position0413
13SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'roles_groups' AND table_schema = 'public' ORDER BY position0211
14SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'roles_users' AND table_schema = 'public' ORDER BY position0211
15SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'menus' AND table_schema = 'public' ORDER BY position0414
16SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'menu_items' AND table_schema = 'public' ORDER BY position01220
17SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'app_objects' AND table_schema = 'public' ORDER BY position01825
18SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'app_folders' AND table_schema = 'public' ORDER BY position0917
19SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'clickboard' AND table_schema = 'public' ORDER BY position0211
20SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'app_objects_app_objects' AND table_schema = 'public' ORDER BY position0211
21SELECT "MenuItem"."id" AS "MenuItem__id", "MenuItem"."menu_id" AS "MenuItem__menu_id", "MenuItem"."label" AS "MenuItem__label", "MenuItem"."url" AS "MenuItem__url", "MenuItem"."parent_id" AS "MenuItem__parent_id", "MenuItem"."app_object_id" AS "MenuItem__app_object_id", "MenuItem"."html_class" AS "MenuItem__html_class", "MenuItem"."lft" AS "MenuItem__lft", "MenuItem"."rght" AS "MenuItem__rght", "MenuItem"."public" AS "MenuItem__public", "MenuItem"."private" AS "MenuItem__private", "MenuItem"."active" AS "MenuItem__active", "Menu"."id" AS "Menu__id", "Menu"."name" AS "Menu__name", "Menu"."html_id" AS "Menu__html_id", "Menu"."html_class" AS "Menu__html_class", "AppObject"."id" AS "AppObject__id", "AppObject"."app_folder_id" AS "AppObject__app_folder_id", "AppObject"."app_object_type_id" AS "AppObject__app_object_type_id", "AppObject"."creator_user_id" AS "AppObject__creator_user_id", "AppObject"."owner_user_id" AS "AppObject__owner_user_id", "AppObject"."owner_group_id" AS "AppObject__owner_group_id", "AppObject"."name" AS "AppObject__name", "AppObject"."teaser" AS "AppObject__teaser", "AppObject"."created" AS "AppObject__created", "AppObject"."modified" AS "AppObject__modified", "AppObject"."allow_comments" AS "AppObject__allow_comments", "AppObject"."comment_start_date" AS "AppObject__comment_start_date", "AppObject"."comment_end_date" AS "AppObject__comment_end_date", "AppObject"."last_email_sent" AS "AppObject__last_email_sent", "AppObject"."send_daily_email" AS "AppObject__send_daily_email", "AppObject"."send_weekly_email" AS "AppObject__send_weekly_email", "AppObject"."send_instantly_email" AS "AppObject__send_instantly_email", "AppObject"."active" AS "AppObject__active" FROM "menu_items" AS "MenuItem" LEFT JOIN "menus" AS "Menu" ON ("MenuItem"."menu_id" = "Menu"."id") LEFT JOIN "app_objects" AS "AppObject" ON ("MenuItem"."app_object_id" = "AppObject"."id") WHERE "MenuItem"."menu_id" = '5' AND "MenuItem"."active" = TRUE AND "MenuItem"."public" = TRUE ORDER BY "MenuItem"."lft" ASC 004
22SELECT "Menu"."id" AS "Menu__id", "Menu"."name" AS "Menu__name", "Menu"."html_id" AS "Menu__html_id", "Menu"."html_class" AS "Menu__html_class" FROM "menus" AS "Menu" WHERE "Menu"."id" = '5' LIMIT 1001
23SELECT "MenuItem"."id" AS "MenuItem__id", "MenuItem"."menu_id" AS "MenuItem__menu_id", "MenuItem"."label" AS "MenuItem__label", "MenuItem"."url" AS "MenuItem__url", "MenuItem"."parent_id" AS "MenuItem__parent_id", "MenuItem"."app_object_id" AS "MenuItem__app_object_id", "MenuItem"."html_class" AS "MenuItem__html_class", "MenuItem"."lft" AS "MenuItem__lft", "MenuItem"."rght" AS "MenuItem__rght", "MenuItem"."public" AS "MenuItem__public", "MenuItem"."private" AS "MenuItem__private", "MenuItem"."active" AS "MenuItem__active", "Menu"."id" AS "Menu__id", "Menu"."name" AS "Menu__name", "Menu"."html_id" AS "Menu__html_id", "Menu"."html_class" AS "Menu__html_class", "AppObject"."id" AS "AppObject__id", "AppObject"."app_folder_id" AS "AppObject__app_folder_id", "AppObject"."app_object_type_id" AS "AppObject__app_object_type_id", "AppObject"."creator_user_id" AS "AppObject__creator_user_id", "AppObject"."owner_user_id" AS "AppObject__owner_user_id", "AppObject"."owner_group_id" AS "AppObject__owner_group_id", "AppObject"."name" AS "AppObject__name", "AppObject"."teaser" AS "AppObject__teaser", "AppObject"."created" AS "AppObject__created", "AppObject"."modified" AS "AppObject__modified", "AppObject"."allow_comments" AS "AppObject__allow_comments", "AppObject"."comment_start_date" AS "AppObject__comment_start_date", "AppObject"."comment_end_date" AS "AppObject__comment_end_date", "AppObject"."last_email_sent" AS "AppObject__last_email_sent", "AppObject"."send_daily_email" AS "AppObject__send_daily_email", "AppObject"."send_weekly_email" AS "AppObject__send_weekly_email", "AppObject"."send_instantly_email" AS "AppObject__send_instantly_email", "AppObject"."active" AS "AppObject__active" FROM "menu_items" AS "MenuItem" LEFT JOIN "menus" AS "Menu" ON ("MenuItem"."menu_id" = "Menu"."id") LEFT JOIN "app_objects" AS "AppObject" ON ("MenuItem"."app_object_id" = "AppObject"."id") WHERE "MenuItem"."menu_id" = '1' AND "MenuItem"."active" = TRUE AND "MenuItem"."public" = TRUE ORDER BY "MenuItem"."lft" ASC 002
24SELECT "Menu"."id" AS "Menu__id", "Menu"."name" AS "Menu__name", "Menu"."html_id" AS "Menu__html_id", "Menu"."html_class" AS "Menu__html_class" FROM "menus" AS "Menu" WHERE "Menu"."id" = '1' LIMIT 1011
25SELECT "MenuItem"."id" AS "MenuItem__id", "MenuItem"."menu_id" AS "MenuItem__menu_id", "MenuItem"."label" AS "MenuItem__label", "MenuItem"."url" AS "MenuItem__url", "MenuItem"."parent_id" AS "MenuItem__parent_id", "MenuItem"."app_object_id" AS "MenuItem__app_object_id", "MenuItem"."html_class" AS "MenuItem__html_class", "MenuItem"."lft" AS "MenuItem__lft", "MenuItem"."rght" AS "MenuItem__rght", "MenuItem"."public" AS "MenuItem__public", "MenuItem"."private" AS "MenuItem__private", "MenuItem"."active" AS "MenuItem__active" FROM "menu_items" AS "MenuItem" WHERE "MenuItem"."menu_id" = ('1') 0171
26SELECT "MenuItem"."id" AS "MenuItem__id", "MenuItem"."menu_id" AS "MenuItem__menu_id", "MenuItem"."label" AS "MenuItem__label", "MenuItem"."url" AS "MenuItem__url", "MenuItem"."parent_id" AS "MenuItem__parent_id", "MenuItem"."app_object_id" AS "MenuItem__app_object_id", "MenuItem"."html_class" AS "MenuItem__html_class", "MenuItem"."lft" AS "MenuItem__lft", "MenuItem"."rght" AS "MenuItem__rght", "MenuItem"."public" AS "MenuItem__public", "MenuItem"."private" AS "MenuItem__private", "MenuItem"."active" AS "MenuItem__active", "Menu"."id" AS "Menu__id", "Menu"."name" AS "Menu__name", "Menu"."html_id" AS "Menu__html_id", "Menu"."html_class" AS "Menu__html_class", "AppObject"."id" AS "AppObject__id", "AppObject"."app_folder_id" AS "AppObject__app_folder_id", "AppObject"."app_object_type_id" AS "AppObject__app_object_type_id", "AppObject"."creator_user_id" AS "AppObject__creator_user_id", "AppObject"."owner_user_id" AS "AppObject__owner_user_id", "AppObject"."owner_group_id" AS "AppObject__owner_group_id", "AppObject"."name" AS "AppObject__name", "AppObject"."teaser" AS "AppObject__teaser", "AppObject"."created" AS "AppObject__created", "AppObject"."modified" AS "AppObject__modified", "AppObject"."allow_comments" AS "AppObject__allow_comments", "AppObject"."comment_start_date" AS "AppObject__comment_start_date", "AppObject"."comment_end_date" AS "AppObject__comment_end_date", "AppObject"."last_email_sent" AS "AppObject__last_email_sent", "AppObject"."send_daily_email" AS "AppObject__send_daily_email", "AppObject"."send_weekly_email" AS "AppObject__send_weekly_email", "AppObject"."send_instantly_email" AS "AppObject__send_instantly_email", "AppObject"."active" AS "AppObject__active" FROM "menu_items" AS "MenuItem" LEFT JOIN "menus" AS "Menu" ON ("MenuItem"."menu_id" = "Menu"."id") LEFT JOIN "app_objects" AS "AppObject" ON ("MenuItem"."app_object_id" = "AppObject"."id") WHERE "MenuItem"."menu_id" = '3' AND "MenuItem"."active" = TRUE AND "MenuItem"."public" = TRUE ORDER BY "MenuItem"."lft" ASC 0103
27SELECT "MenuItem"."id" AS "MenuItem__id", "MenuItem"."menu_id" AS "MenuItem__menu_id", "MenuItem"."label" AS "MenuItem__label", "MenuItem"."url" AS "MenuItem__url", "MenuItem"."parent_id" AS "MenuItem__parent_id", "MenuItem"."app_object_id" AS "MenuItem__app_object_id", "MenuItem"."html_class" AS "MenuItem__html_class", "MenuItem"."lft" AS "MenuItem__lft", "MenuItem"."rght" AS "MenuItem__rght", "MenuItem"."public" AS "MenuItem__public", "MenuItem"."private" AS "MenuItem__private", "MenuItem"."active" AS "MenuItem__active", "Menu"."id" AS "Menu__id", "Menu"."name" AS "Menu__name", "Menu"."html_id" AS "Menu__html_id", "Menu"."html_class" AS "Menu__html_class", "AppObject"."id" AS "AppObject__id", "AppObject"."app_folder_id" AS "AppObject__app_folder_id", "AppObject"."app_object_type_id" AS "AppObject__app_object_type_id", "AppObject"."creator_user_id" AS "AppObject__creator_user_id", "AppObject"."owner_user_id" AS "AppObject__owner_user_id", "AppObject"."owner_group_id" AS "AppObject__owner_group_id", "AppObject"."name" AS "AppObject__name", "AppObject"."teaser" AS "AppObject__teaser", "AppObject"."created" AS "AppObject__created", "AppObject"."modified" AS "AppObject__modified", "AppObject"."allow_comments" AS "AppObject__allow_comments", "AppObject"."comment_start_date" AS "AppObject__comment_start_date", "AppObject"."comment_end_date" AS "AppObject__comment_end_date", "AppObject"."last_email_sent" AS "AppObject__last_email_sent", "AppObject"."send_daily_email" AS "AppObject__send_daily_email", "AppObject"."send_weekly_email" AS "AppObject__send_weekly_email", "AppObject"."send_instantly_email" AS "AppObject__send_instantly_email", "AppObject"."active" AS "AppObject__active" FROM "menu_items" AS "MenuItem" LEFT JOIN "menus" AS "Menu" ON ("MenuItem"."menu_id" = "Menu"."id") LEFT JOIN "app_objects" AS "AppObject" ON ("MenuItem"."app_object_id" = "AppObject"."id") WHERE "MenuItem"."menu_id" = '2' AND "MenuItem"."active" = TRUE AND "MenuItem"."public" = TRUE ORDER BY "MenuItem"."lft" ASC 042
28SELECT "Menu"."id" AS "Menu__id", "Menu"."name" AS "Menu__name", "Menu"."html_id" AS "Menu__html_id", "Menu"."html_class" AS "Menu__html_class" FROM "menus" AS "Menu" WHERE "Menu"."id" = '2' LIMIT 1011
29SELECT "MenuItem"."id" AS "MenuItem__id", "MenuItem"."menu_id" AS "MenuItem__menu_id", "MenuItem"."label" AS "MenuItem__label", "MenuItem"."url" AS "MenuItem__url", "MenuItem"."parent_id" AS "MenuItem__parent_id", "MenuItem"."app_object_id" AS "MenuItem__app_object_id", "MenuItem"."html_class" AS "MenuItem__html_class", "MenuItem"."lft" AS "MenuItem__lft", "MenuItem"."rght" AS "MenuItem__rght", "MenuItem"."public" AS "MenuItem__public", "MenuItem"."private" AS "MenuItem__private", "MenuItem"."active" AS "MenuItem__active" FROM "menu_items" AS "MenuItem" WHERE "MenuItem"."menu_id" = ('2') 041