Skip to main content

NC State Extension

EIT Redistricting Checklist

en Español / em Português
Español

El inglés es el idioma de control de esta página. En la medida en que haya algún conflicto entre la traducción al inglés y la traducción, el inglés prevalece.

Al hacer clic en el enlace de traducción se activa un servicio de traducción gratuito para convertir la página al español. Al igual que con cualquier traducción por Internet, la conversión no es sensible al contexto y puede que no traduzca el texto en su significado original. NC State Extension no garantiza la exactitud del texto traducido. Por favor, tenga en cuenta que algunas aplicaciones y/o servicios pueden no funcionar como se espera cuando se traducen.


Português

Inglês é o idioma de controle desta página. Na medida que haja algum conflito entre o texto original em Inglês e a tradução, o Inglês prevalece.

Ao clicar no link de tradução, um serviço gratuito de tradução será ativado para converter a página para o Português. Como em qualquer tradução pela internet, a conversão não é sensivel ao contexto e pode não ocorrer a tradução para o significado orginal. O serviço de Extensão da Carolina do Norte (NC State Extension) não garante a exatidão do texto traduzido. Por favor, observe que algumas funções ou serviços podem não funcionar como esperado após a tradução.


English

English is the controlling language of this page. To the extent there is any conflict between the English text and the translation, English controls.

Clicking on the translation link activates a free translation service to convert the page to Spanish. As with any Internet translation, the conversion is not context-sensitive and may not translate the text to its original meaning. NC State Extension does not guarantee the accuracy of the translated text. Please note that some applications and/or services may not function as expected when translated.

Collapse ▲

Things that EIT needs to do when changing Districts:

2012

  • Update the CED email lists –> ** have file to update after 1/1/12
  • Update tables in XEMP (districts, counties, locations). The districts and counties table have been updated and named …_2008. The new tables just need to be named appropriately at the correct time: The following SQL needs to be run on the locations table: update locations, counties set locations.dist_id = counties.district_id where locations.dist_id != 0 and locations.name = concat(counties.county_name, " County")
  • Update tables in other applications (LMS, calendar, others?)

The following databases have counties/districts tables

√ xemp (master table to be updated after jan 1)
√ ncce
√ phoenix
√ xcal
√ xlms
√ xrdb
√ xvacancy

The following SQL was executed against the databases above to make their county tables point to the master xemp county table. When the xemp county table is updated for the new year the others will automatically be updated as well.

  • newton.ncce

create view ncce.counties_latlon_vw as select county_id, ind, county_name, district_id, gateway, latitude, longitude from xemp.counties; rename table ncce.counties_latlon to ncce.counties_latlon_SAVE; rename table ncce.counties_latlon_vw to ncce.counties_latlon;

  • newton.phoenix

create view phoenix.counties_vw as select county_id, ind, county_name, district_id, gateway, latitude, longitude, ‘Y’ as use_new_url from xemp.counties where ind = 0; rename table phoenix.counties to phoenix.counties_SAVE; rename table phoenix.counties_vw to phoenix.counties;

  • newton.xcal

create view xcal.counties_vw as select county_id, county_name, district_id from xemp.counties where ind = 0; rename table xcal.counties to xcal.counties_SAVE; rename table xcal.counties_vw to xcal.counties;

  • newton.xlms

create view xlms.counties_vw as select county_id, county_name, district_id from xemp.counties where ind = 0; rename table xlms.counties to xlms.counties_SAVE; rename table xlms.counties_vw to xlms.counties;

  • newton.xrdb

create view xrdb.counties_vw as select county_id, county_name, district_id from xemp.counties where ind = 0; rename table xrdb.counties to xrdb.counties_SAVE; rename table xrdb.counties_vw to xrdb.counties;

  • newton.xvacancy

create view xvacancy.counties_vw as select county_id, county_name, district_id from xemp.counties where ind = 0; rename table xvacancy.counties to xvacancy.counties_SAVE; rename table xvacancy.counties_vw to xvacancy.counties;


Not sure about changes to ERS — (RK: ERS does not use districts and is unaffected by redistricting.)

Most of these will not cause a problem once we remap counties and change district names as appropriate.
The following paragraph may apply… One potential issue is if we delete district 8 (formerly Southwest) from the database we will need to make sure to update any records (wherever they may be in each db) that reference it. This will require us to analyze the data in each program and come up with the appropriate SQL to fix the problem and/or mark them as “Non-District” and let the changes be performed manually within the program.

  • Update phoenix.counties table. Maybe use xemp.counties?
  • Update XEMP entries for DEDs and AAs
  • Change district web sites
    • DNS changes
    • rewrite rules
  • Update County Centers page
  • Replace District Map with new map (obtained new map from Ext Admin)
  • Farm Income in NC (FINC) program (RK:ANCIENT program – no longer active – no changes needed)
  • Update CES Organizational Chart
  • Update map images on district web pages –> *** copy /loc/htdocs/ncce/map2012map.php over map.php
  • Update descriptive text on district web pages (District AAs should do this)

2008

  • Update the CED email lists
  • Update tables in XEMP (districts, counties, locations). The districts and counties table have been updated and named …_2008. The new tables just need to be named appropriately at the correct time: The following SQL needs to be run on the locations table: update locations, counties set locations.dist_id = counties.district_id where locations.dist_id != 0 and locations.name = concat(counties.county_name, " County")
  • Update tables in other applications (LMS, calendar, others?)

The following databases have counties/districts tables

copubs_import not used
copubs_import_dorner not used
finc
ncce
√phoenix
program_evaluation not used
√ xcal
xemp
√xlms
xlrp not used
√ xrdb
√ xvacancy

Not sure about changes to ERS/POD

Most of these will not cause a problem once we remap counties and change district names as appropriate.

One potential issue is if we delete district 8 (formerly Southwest) from the database we will need to make sure to update any records (wherever they may be in each db) that reference it. This will require us to analyze the data in each program and come up with the appropriate SQL to fix the problem and/or mark them as “Non-District” and let the changes be performed manually within the program.

  • Update phoenix.counties table. Maybe use xemp.counties?
  • Update XEMP entries for DEDs and AAs
  • Change district web sites
    • √ DNS changes
    • √ rewrite rules
  • Update County Centers page
  • Replace District Map with new map (obtained new map from Ext Admin)
  • √ Farm Income in NC (FINC) program
  • Update CES Organizational Chart
  • Update map images on district web pages
  • Update descriptive text on district web pages (District AAs should do this)

This page has value for future changes in districts and should be archived.

Written By

Rhonda Conlon, N.C. Cooperative ExtensionRhonda ConlonDirector, Extension Information Technology Call Rhonda Email Rhonda Extension Information Technology
NC State Extension, NC State University
Page Last Updated: 8 years ago
Was the information on this page helpful? Yes check No close