Feature Tour - Auto-populate District Matching

Because VoterConnect's issue and candidate campaigns are organized and executed according to districts and jurisdictions, accuracy of information is extremely important. VoterConnect has developed a proprietary method that synchronizes US Postal Service and US Census Bureau data to produce the industry's most accurate political jurisdiction information.

01
When a Supporter registers or his information is batch uploaded, VoterConnect automatically geocodes his address and generates applicable political jurisdiction information.

Based on this information, VoterConnect populates legislator information for each district level, stores it in the database, and displays it on the Supporter's "My Officials" page.

For each campaign, VoterConnect queries the database according to the jurisdiction defined by the National or State Administrator and calls Supporters in that jurisdiction.

Feature Highlight:

VoterConnect provides the following jurisdiction information:

  • Congressional District
  • State Upper House District
  • State Lower House District
  • Tribal
  • County
  • Municipal
  • School District
  • Zip+4
02
An Administrator can also implement jurisdiction matching for targeted email campaigns by using filters to send eNewsletters only to Supporters in a selected jurisdiction.

03
VoterConnect's "Mark and Drop" feature allows Supporters to manually correct their geographical location thus assuring 100% accuracy of district information.

VoterConnect Exclusive:

VoterConnect is the only system that uses manual correction to ensure 100% accuracy of jurisdiction and district information.

(default) 14 queries took 16 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `admins`11111
2DESCRIBE `countries`771
3DESCRIBE `naadmins`52522
4DESCRIBE `states`10101
5DESCRIBE `plan_price_modules`12121
6DESCRIBE `plan_price_users`661
7DESCRIBE `naadmin_plans`21211
8DESCRIBE `naadmin_payments`23231
9DESCRIBE `naadmin_card_details`18181
10DESCRIBE `invite_users`441
11DESCRIBE `customize_member_sections`25251
12DESCRIBE `default_cms_pages`16161
13DESCRIBE `default_website_templates`60602
14DESCRIBE `customize_footer_logos`441
(test) 25 queries took 25 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `cms_pages`10101
2DESCRIBE `mail_templates`441
3DESCRIBE `mail_template_contents`881
4DESCRIBE `users`74743
5DESCRIBE `home_module_displays`11111
6DESCRIBE `communiques`37372
7DESCRIBE `articles`881
8DESCRIBE `polls`661
9DESCRIBE `poll_options`331
10DESCRIBE `poll_results`441
11DESCRIBE `private_members`73732
12DESCRIBE `communique_mores`551
13DESCRIBE `donations`30301
14DESCRIBE `donation_recognitions`771
15DESCRIBE `custom_front_styles`42422
16DESCRIBE `links`991
17DESCRIBE `sections`881
18DESCRIBE `customize_cms_pages`16161
19DESCRIBE `customize_websites`63632
20SELECT `CustomFrontStyle`.`id`, `CustomFrontStyle`.`created_by`, `CustomFrontStyle`.`table_name`, `CustomFrontStyle`.`template_format`, `CustomFrontStyle`.`logo_image`, `CustomFrontStyle`.`hide_logo`, `CustomFrontStyle`.`header_image`, `CustomFrontStyle`.`hide_header_image`, `CustomFrontStyle`.`hide_subpage_header_image`, `CustomFrontStyle`.`header_text`, `CustomFrontStyle`.`header_text_color`, `CustomFrontStyle`.`header_text_font`, `CustomFrontStyle`.`header_text_size`, `CustomFrontStyle`.`hide_header_text`, `CustomFrontStyle`.`body_text_color`, `CustomFrontStyle`.`body_text_font`, `CustomFrontStyle`.`body_text_size`, `CustomFrontStyle`.`body_background_color`, `CustomFrontStyle`.`body_background_image`, `CustomFrontStyle`.`hide_background_image`, `CustomFrontStyle`.`body_background_type`, `CustomFrontStyle`.`navigation_bar_color`, `CustomFrontStyle`.`navigation_text_hover_color`, `CustomFrontStyle`.`navigation_text_color`, `CustomFrontStyle`.`navigation_text_font`, `CustomFrontStyle`.`navigation_text_size`, `CustomFrontStyle`.`menu_text_color`, `CustomFrontStyle`.`menu_text_hover_color`, `CustomFrontStyle`.`menu_text_font`, `CustomFrontStyle`.`menu_text_size`, `CustomFrontStyle`.`button_color`, `CustomFrontStyle`.`button_hover_color`, `CustomFrontStyle`.`theme_color`, `CustomFrontStyle`.`text_color`, `CustomFrontStyle`.`theme_text_font`, `CustomFrontStyle`.`theme_text_size`, `CustomFrontStyle`.`link_color`, `CustomFrontStyle`.`heading_text_color`, `CustomFrontStyle`.`body_transparency`, `CustomFrontStyle`.`status`, `CustomFrontStyle`.`message_color`, `CustomFrontStyle`.`header_body_color` FROM `custom_front_styles` AS `CustomFrontStyle` WHERE 1 = 1 LIMIT 1110
21SELECT `CustomFrontStyle`.`id`, `CustomFrontStyle`.`created_by`, `CustomFrontStyle`.`table_name`, `CustomFrontStyle`.`template_format`, `CustomFrontStyle`.`logo_image`, `CustomFrontStyle`.`hide_logo`, `CustomFrontStyle`.`header_image`, `CustomFrontStyle`.`hide_header_image`, `CustomFrontStyle`.`hide_subpage_header_image`, `CustomFrontStyle`.`header_text`, `CustomFrontStyle`.`header_text_color`, `CustomFrontStyle`.`header_text_font`, `CustomFrontStyle`.`header_text_size`, `CustomFrontStyle`.`hide_header_text`, `CustomFrontStyle`.`body_text_color`, `CustomFrontStyle`.`body_text_font`, `CustomFrontStyle`.`body_text_size`, `CustomFrontStyle`.`body_background_color`, `CustomFrontStyle`.`body_background_image`, `CustomFrontStyle`.`hide_background_image`, `CustomFrontStyle`.`body_background_type`, `CustomFrontStyle`.`navigation_bar_color`, `CustomFrontStyle`.`navigation_text_hover_color`, `CustomFrontStyle`.`navigation_text_color`, `CustomFrontStyle`.`navigation_text_font`, `CustomFrontStyle`.`navigation_text_size`, `CustomFrontStyle`.`menu_text_color`, `CustomFrontStyle`.`menu_text_hover_color`, `CustomFrontStyle`.`menu_text_font`, `CustomFrontStyle`.`menu_text_size`, `CustomFrontStyle`.`button_color`, `CustomFrontStyle`.`button_hover_color`, `CustomFrontStyle`.`theme_color`, `CustomFrontStyle`.`text_color`, `CustomFrontStyle`.`theme_text_font`, `CustomFrontStyle`.`theme_text_size`, `CustomFrontStyle`.`link_color`, `CustomFrontStyle`.`heading_text_color`, `CustomFrontStyle`.`body_transparency`, `CustomFrontStyle`.`status`, `CustomFrontStyle`.`message_color`, `CustomFrontStyle`.`header_body_color` FROM `custom_front_styles` AS `CustomFrontStyle` WHERE 1 = 1 LIMIT 1110
22SELECT `Link`.`id`, `Link`.`created_by`, `Link`.`table_name`, `Link`.`title`, `Link`.`cms_page_id`, `Link`.`position`, `Link`.`order`, `Link`.`isblocked`, `Link`.`isdeleted`, `CmsPage`.`id`, `CmsPage`.`created_by`, `CmsPage`.`table_name`, `CmsPage`.`page_name`, `CmsPage`.`page_content`, `CmsPage`.`keyword`, `CmsPage`.`meta_description`, `CmsPage`.`type`, `CmsPage`.`isblocked`, `CmsPage`.`isdeleted` FROM `links` AS `Link` LEFT JOIN `cms_pages` AS `CmsPage` ON (`Link`.`cms_page_id` = `CmsPage`.`id`) WHERE `Link`.`isdeleted` = '0' AND `Link`.`isblocked` = '0' AND `Link`.`position` = 'H' order by `Link`.`order` 11110
23SELECT `Link`.`id`, `Link`.`created_by`, `Link`.`table_name`, `Link`.`title`, `Link`.`cms_page_id`, `Link`.`position`, `Link`.`order`, `Link`.`isblocked`, `Link`.`isdeleted`, `CmsPage`.`id`, `CmsPage`.`created_by`, `CmsPage`.`table_name`, `CmsPage`.`page_name`, `CmsPage`.`page_content`, `CmsPage`.`keyword`, `CmsPage`.`meta_description`, `CmsPage`.`type`, `CmsPage`.`isblocked`, `CmsPage`.`isdeleted` FROM `links` AS `Link` LEFT JOIN `cms_pages` AS `CmsPage` ON (`Link`.`cms_page_id` = `CmsPage`.`id`) WHERE `Link`.`isdeleted` = '0' AND `Link`.`isblocked` = '0' AND `Link`.`position` = 'L' order by `Link`.`order` 000
24SELECT `Link`.`id`, `Link`.`created_by`, `Link`.`table_name`, `Link`.`title`, `Link`.`cms_page_id`, `Link`.`position`, `Link`.`order`, `Link`.`isblocked`, `Link`.`isdeleted`, `CmsPage`.`id`, `CmsPage`.`created_by`, `CmsPage`.`table_name`, `CmsPage`.`page_name`, `CmsPage`.`page_content`, `CmsPage`.`keyword`, `CmsPage`.`meta_description`, `CmsPage`.`type`, `CmsPage`.`isblocked`, `CmsPage`.`isdeleted` FROM `links` AS `Link` LEFT JOIN `cms_pages` AS `CmsPage` ON (`Link`.`cms_page_id` = `CmsPage`.`id`) WHERE `Link`.`isdeleted` = '0' AND `Link`.`isblocked` = '0' AND `Link`.`position` = 'R' order by `Link`.`order` 000
25SELECT `Section`.`id`, `Section`.`created_by`, `Section`.`table_name`, `Section`.`title`, `Section`.`content`, `Section`.`position`, `Section`.`order`, `Section`.`isdeleted` FROM `sections` AS `Section` WHERE `Section`.`isdeleted` = '0' AND `Section`.`position` = 'R' order by `Section`.`order` 330