| Home |
| Precinct Finder Tables |
| Who We Are |
| Contact Us |
| Bookmark This Site |
|
| The Precinct Locator Tables |
| Table | Type | Description |
|---|---|---|
| 1 | pl_street | list of streets |
| 2 | pl_precinct | list of precincts |
| 3 | pl_tally | tally of voters by party, gender, race, precinct |
| 4 | pl_office_xref | cross reference between precinct and office |
| 5 | pl_office_name | list of elected offices |
| 6 | pl_precloc | driving directions for each precinct |
| 7 | pl_officelink | links to be used for each elected office |
| 71 | pl_officelink | links to be used for each elected office - extended format |
| 8 | pl_ballotstyle | Ballot styles for display of sample ballots |
| 9 | pl_absbal | Absentee ballot status for voters |
Type 1 - pl_street
There is one record for each street range segment.| Field Name | Type | Description | Example |
|---|---|---|---|
| rec_type | char(1) | Record Type | 1 |
| direction | char(2) | Street Direction | N, S, NE |
| name | char(25) | Street name | MAGNOLIA |
| type | char(4) | Street type | AVE, RD, ST |
| post_dir | char(2) | Post direction | N, S, SE, as in 10TH AVE N |
| lo_range | bigint | Low numeric range (inclusive) | 1357 |
| hi_range | bigint | High numeric range (inclusive) | 10256 |
| odd_even | char(1) | Odd, Even or Both sides of the street | O, E, B |
| precinct | int(4) | Precinct number | 101 |
| suffix | char(1) | Precinct Suffix | A, B, C... |
| grp | smallint | Group Number (sub precinct) | 0,1,2 |
| zipcode | char(10) | Zip Code | 33411 |
Example:
1,'','1ST','ST','SW',2500,2999, 'B', 1, '','0','33920';
1,'N','ALOE','LN','',1,99, 'B', 1, '','0','33920';
1,'','CARILLON ESTATES','WAY','',8900,8999, 'B', 127, '','0','33912';
Type 2 - pl_precinct
Precinct records. One row for each precinct.| Field Name | Type | Description | Example | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| rec_type | char(1) | Record Type | 2 | ||||||||||||||||
| precinct | int(03) | Precinct Number | 32, 101 | ||||||||||||||||
| suffix | char(1) | Precinct Suffix | A,B,| location | varchar(40) | Precinct Description | OAK GROVE BAPTIST CH
| address | varchar(35) | Precinct Address | 2156 LOCH RANE BLVD
| address2 | varchar(35) | Precinct Address Line 2 | Room 201
| city | varchar(35) | City State Zip - Note : Zip is required for Mapquest Maps | MIDDLEBURG FL 32068
| |
Example:
2,1,'','ALVA COMMUNITY CENTER', '21471 N RIVER RD', '', 'ALVA 33920';
2,2,'','GRACE LUTHERAN CHURCH', '14531 OLD OLGA RD', '', 'FORT MYERS 33920';
2,3,'','GUNNERY RD BAPTIST CH', '1880 GUNNERY RD', '', 'LEHIGH ACRES 33971';
2,4,'','FAITH ASSEMBLY OF GOD', '6950 BAYSHORE RD', '', 'FORT MYERS 33917';
Type 3 - pl_tally
The voter counts by precinct, party, gender, race.| Field Name | Type | Description | Example |
|---|---|---|---|
| rec_type | char(1) | Record Type | 3 |
| Precinct | int(03) | Precinct Number | 101 |
| Suffix | CHAR(01) | Precinct Suffix | A, B |
| Grp | INT(01) | Precint Group Number | 0,1,2 |
| Party | CHAR(03) | Party Code | DE,RE,NP |
| Race | CHAR(02) | Race Code | W,B,O,AP |
| Sex | CHAR(01) | Gender Code | M,F,U |
| Tally | int(08) | Tally - number of voters matching this precinct, party, race and gender | 35 |
Example:
3,54,'',1,'N','W','M',9;
3,1,'',0,'A','W','M',1;
3,138,'',0,'D','U','U',1;
Type 4 - pl_office_xref
The precinct / elected office cross reference. There is one row for each elected office per precinct.| Field Name | Type | Description | Example |
|---|---|---|---|
| rec_type | char(1) | Record Type | 4 |
| Precinct | INT (03) | Precinct Number | 101 |
| Suffix | CHAR(01) | Precinct Suffix | A, B |
| Grp | INT (01) | Precint Group Number | 0,1,2 |
| OfficeCode | CHAR(20) | Office Code | SH-21 |
Example:
4,1,'',0,'CO5';
4,1,'',0,'CD14';
4,147,'',2,'SS25';
4,147,'',2,'TX-03';
4,147,'',2,'TX-23';
Type 5 - pl_office_name
List of elected offices.| Field Name | Type | Description | Example |
|---|---|---|---|
| rec_type | char(1) | Record Type | 5 |
| officecode | varchar(20) | Office Code | SH-21 |
| office | varchar(50) | Office Name | STATE HOUSE 21 |
Example:
5,'CD14','CONGRESSIONAL 14';
5,'CO1','COUNTY COMMISSION 1';
5,'CO2','COUNTY COMMISSION 2';
5,'TX-35','MEDITERRA NORTH';
Type 6 - pl_precloc
These are the directions to the polling place, for each precinct.| Field Name | Type | Description | Example |
|---|---|---|---|
| rec_type | char(1) | Record Type | 6 |
| precinct | int(03) | Precinct Number | 101 |
| suffix | char(1) | Precinct Suffix | A, B |
| location | blob | Directions to the polling place | TAKE PALMETTO OFF BLANDING, (FIRST UNION
& AMOCO IS AT TURN), GO PAST POST OFFICE CONTINUE DOWN STREET YOU WILL SEE MIDDLEBURG CIVIC CENTER, TURN IN FIRST DRIVE AND WEIGEL SENIOR CENTER IS LOCATED IN THE REAR OR TAKE MAIN STREET (USE CAR LOT IS ON CORNER) TURN ON BUTLER AND PROCEED STRAIGHT TO THE PRECINCT ***PARK IN FRONT ON RIGHT HAND SIDE IN SAND AREA. ***VOTERS TO USE SIDE ENTRANCE |
Example:
6,4,'','The Church is located on Bayshore Rd west of the railroad tracks on the south side of the ro ad. This is just east of the Winn Dixie plaza. (Voting is in Fellowship Hall.)';
6,5,'','Begin at intersection of Pine Island Rd and US 41. Go west on Pine Island Rd to intersectio n of Corbett Rd. The Church is on the corner. (Voting is in the Fellowship Hall.)';
6,6,'','The hall is located on Florence Ave just off Palm Beach Blvd across from Ortiz Blvd. (Votin g is in the large room of the hall.)';
Type 7 - pl_officelink
The office_link table holds the link to the office holder's web site. There should be a record for each office. If the office link record is not in the system for an office, then the office will show on the districts page without a link.| Field Name | Type | Description | Example |
|---|---|---|---|
| rec_type | char(1) | Record Type | 7 |
| officecode | varchar(8) | Office Code | SH-21 |
| link | blob | Link to office holders web site | http://www.leg.state.fl.us/Legislators/index.cfm |
Example:
7,'SH-20','http://www.leg.state.fl.us/Legislators/index.cfm?Members=View+Page&LastName=Wiles&District_Num_Link=020&Title=%2D%3EHouse%2D%3EWiles%2C%20Doug%20&Submenu=1&Tab=legislators&chamber=House';
7,'SH-21','http://www.leg.state.fl.us/Legislators/index.cfm?Members=View+Page&LastName=Pickens&District_Num_Link=021&Title=%2D%3EHouse%2D%3EPickens%2C%20Joe%20H%2E%20&Submenu=1&Tab=legislators&chamber=House';
7,'CD-6','http://www.house.gov/stearns/welcome.html';
7,'SS-6','http://www.leg.state.fl.us/Legislators/index.cfm?Members=View+Page&LastName=Horne&District_Num_Link=006&Title=%2D%3ESenate%2D%3EHorne%2C%20Jim&Submenu=1&Tab=legislators&chamber=Senate';
7,'CO-1','http://www.claycountygov.com/fitzgeraldbio.htm';
7,'CO-4','http://www.claycountygov.com/lassiterbio.htm';
Type 71 - pl_officelink (with office holders)
The office_link table holds the link to the office holder's web site. There should be a record for each office. If the office link record is not in the system for an office, then the office will show on the districts page without a link.| Field Name | Type | Description | Example |
|---|---|---|---|
| rec_type | char(1) | Record Type | 71 |
| officecode | varchar(6) | Office Code | CC4 |
| link | blob | Link to office holders web site | http://www.leg.state.fl.us/Legislators/index.cfm |
| contactinfo | text | Contact Info | 801 County Road 25<br>Bunnell, FL 32110<br>(386) 437-0815 |
| holder | text | Office Holder Name | George Wells |
| party | varchar(10) | Party | Dem |
| grp | varchar(3) | Group | Cnty |
| seq | decimal(5,2) | Sequence Number for ordering the list of offices | 50 |
Example:
71,'CC4','http://www.flaglerelections.com','824 County Road 25<br>Tampa, FL 32110<br>(386) 437-0815','Herbert \"Hatch\" Billings, Jr. ','Rep','Cnty',50;
71,'CC5','http://www.flaglerelections.com','P.O. Box 35330<br>Palmetto, FL 32135<br>(386) 446-3439 ','George Wells','Dem','Cnty',50;
Type 8 - pl_ballotstyle
The list of ballot styles for one or more elections. This is used for displaying the sample ballot pdf files.| Field Name | Type | Description | Example |
|---|---|---|---|
| rec_type | char(1) | Record Type | 8 |
| Precinct | INT (03) | Precinct Number | 101 |
| Suffix | CHAR(01) | Precinct Suffix | A, B |
| Grp | INT (01) | Precint Group Number | 0,1,2 |
| Style | CHAR(12) | Ballot Style Code | SH-21 |
| Party | CHAR(03) | Party Code | DEM, REP, non |
| ElectionCode | CHAR(8) | Election Code | GEN0801 |
| ElectionName | CHAR(30) | Election Description | General - Nov 5 2001 |
Example:
8,1,'',1,'3a','non','GEN0801','General - Nov 5 2001';
8,1,'',1,'2a','REP','GEN0801','General - Nov 5 2001';
8,1,'',1,'1a','COM','GEN0801','General - Nov 5 2001';
8,1,'',0,'3a','non','GEN0801','General - Nov 5 2001';
8,1,'',0,'2a','REP','GEN0801','General - Nov 5 2001';
8,1,'',0,'1a','COM','GEN0801','General - Nov 5 2001';
Type 9 - pl_absbal
The precinct / elected office cross reference. There is one row for each elected office per precinct.| Field Name | Type | Description | Example |
|---|---|---|---|
| rec_type | char(1) | Record Type | 4 |
| Election | CHAR(45) | Precinct Number | 101 |
| Status | CHAR(02) | Requested, Mailed, Returned | Rq,Ml, Rt |
| Date of Birth | Date | Voter Date of Birth | 1953-04-25 |
| adr_num | CHAR(08) | House Number | 1502 |
| adr_dir | CHAR(03) | Direction | N, S, E, NW, NE |
| adr_str | CHAR(25) | Street Name | Oak |
| adr_type | CHAR(04) | Street Type | Av |
| adr_zip | CHAR(05) | Zip Code | 33411 |
| dt_added | CHAR(10) | Date added | 04/30/2001 |
| dt_request | CHAR(10) | Date Requested | 03/28/2002 |
| dt_mailed | CHAR(10) | Date ballot mailed to voter | 04/12/2001 |
| dt_return | CHAR(10) | Date ballot received in elections office | 04/18/2001 |
| electiondate | DATE | Date of Election | 2002-08-05 |
Note: This table also uses a date record (D1 record) which is shown in the example below. This is the date that the system displays as the last update date for this table.
Example:
D1,02/05/2002;
9,'Rq','PRIMARY (12/16/1998)','1934/09/12',10244,'','MANASSAS MILL','RD',' ','02/23/1998','01/01/1997','','','1998/12/16';
9,'Rq','PRIMARY (12/16/1998)','1953/04/25',10241,'','MANASSAS MILL','RD','22110','02/23/1998','01/01/1998','','','1998/12/16';
9,'Rt','PALM BEACH (02/20/1998)','1953/04/25',10241,'','PIPER','LN','22110','02/13/1998','01/01/1998','','','1998/02/20';
9,'Rq','GENERAL ELECTION (11/08/1998)','1939/09/14',10953,'','STATE HWY 28','',' ','05/04/1999','05/04/1999','','','1998/11/08';
9,'Rq','PRIMARY (12/16/1998)','1953/04/25',10600,'','PIPER','LN','22110','02/23/1998','01/01/1997','','','1998/12/16';
Full File Example
The following example is the way a full file might look. We have removed many lines from each group to shorten it up.
Since this file was created by an Oracle extract, it contains lines that indicate how many rows were selected. The import program (prec_update.php) flushes the input buffer whenever a blank line is encountered so this does not present a problem.
The semi-colon indicates to the import program that the sql line is complete, and to execute it.
Please note that this example shows all sections of the file. In a normal file, all sections might not be present. In particular, the type '7' records, which are the links to officeholder's web sites would not be present, but would be in a separate file as these are normally created manually.
1,'','1ST','ST','SW',2500,2999, 'B', 1, '','0','33920'; 1,'N','ALOE','LN','',1,99, 'B', 1, '','0','33920'; 1,'','CARILLON ESTATES','WAY','',8900,8999, 'B', 127, '','0','33912'; 10611 rows selected. 2,1,'','ALVA COMMUNITY CENTER', '21471 N RIVER RD', '', 'ALVA 33920'; 2,2,'','GRACE LUTHERAN CHURCH', '14531 OLD OLGA RD', '', 'FORT MYERS 33920'; 2,3,'','GUNNERY RD BAPTIST CH', '1880 GUNNERY RD', '', 'LEHIGH ACRES 33971'; 2,4,'','FAITH ASSEMBLY OF GOD', '6950 BAYSHORE RD', '', 'FORT MYERS 33917'; 2,999,'','LEE COUNTY ELECTION CENTER', '3040 FOWLER STREET', '', 'FORT MYERS FL 33901'; 161 rows selected. 3,54,'',1,'N','W','M',9; 3,1,'',0,'A','W','M',1; 3,138,'',0,'D','U','U',1; 3,74,'',0,'L','W','M',1; 9682 rows selected. 4,1,'',0,'CO5'; 4,1,'',0,'CD14'; 4,147,'',2,'SS25'; 4,147,'',2,'TX-03'; 4,147,'',2,'TX-23'; 1521 rows selected. 5,'CD14','CONGRESSIONAL 14'; 5,'CO1','COUNTY COMMISSION 1'; 5,'CO2','COUNTY COMMISSION 2'; 5,'TX-35','MEDITERRA NORTH'; 72 rows selected. 6,4,'','The Church is located on Bayshore Rd west of the railroad tracks on the south side of the ro ad. This is just east of the Winn Dixie plaza. (Voting is in Fellowship Hall.)'; 6,5,'','Begin at intersection of Pine Island Rd and US 41. Go west on Pine Island Rd to intersectio n of Corbett Rd. The Church is on the corner. (Voting is in the Fellowship Hall.)'; 6,6,'','The hall is located on Florence Ave just off Palm Beach Blvd across from Ortiz Blvd. (Votin g is in the large room of the hall.)'; 12 rows selected. 7,'SH-20','http://www.leg.state.fl.us/Legislators/index.cfm?Members=View+Page&LastName=Wiles&District_Num_Link=020&Title=%2D%3EHouse%2D%3EWiles%2C%20Doug%20&Submenu=1&Tab=legislators&chamber=House'; 7,'SH-21','http://www.leg.state.fl.us/Legislators/index.cfm?Members=View+Page&LastName=Pickens&District_Num_Link=021&Title=%2D%3EHouse%2D%3EPickens%2C%20Joe%20H%2E%20&Submenu=1&Tab=legislators&chamber=House'; 7,'CD-6','http://www.house.gov/stearns/welcome.html'; 7,'SS-6','http://www.leg.state.fl.us/Legislators/index.cfm?Members=View+Page&LastName=Horne&District_Num_Link=006&Title=%2D%3ESenate%2D%3EHorne%2C%20Jim&Submenu=1&Tab=legislators&chamber=Senate'; 7,'CO-1','http://www.claycountygov.com/fitzgeraldbio.htm'; 7,'CO-4','http://www.claycountygov.com/lassiterbio.htm';