Skip to content

Instantly share code, notes, and snippets.

@cpcloud

cpcloud/gist:6179517

Created August 7, 2013 22:36
Show Gist options
  • Save cpcloud/6179517 to your computer and use it in GitHub Desktop.
Save cpcloud/6179517 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
{
"metadata": {
"name": ""
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "code",
"collapsed": false,
"input": [
"import pandas as pd\n",
"import numpy as np\n",
"print (pd.__version__)\n",
"import zipfile\n",
"with zipfile.ZipFile('Documents/Heatherwood/ARES.zip', 'r') as z:\n",
" f = z.open('AllListing1RES.txt')\n",
" table = pd.io.parsers.read_table(f, parse_dates='true')\n",
"table3=table['SUBDIVISION'].head(30)\n",
"table3"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"0.12.0.dev\n"
]
},
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 1,
"text": [
"0 MT HIGH\n",
"1 LAKE CYRUS\n",
"2 TRUSSVILLE\n",
"3 CLANTON\n",
"4 BEAVER CREEK\n",
"5 MAYS BEND\n",
"6 BERKELEY HILLS\n",
"7 WESTHILL ACRES\n",
"8 SPRING LAKE MANOR\n",
"9 RIVER OAKS\n",
"10 CLAY\n",
"11 LAKE CREST\n",
"12 WINFORD TOWNEHOMES\n",
"13 SHADES CREST\n",
"14 FULTONDALE\n",
"15 MCADORY P J\n",
"16 MIDFIELD\n",
"17 WOODLAWN\n",
"18 WARRIOR\n",
"19 DRY VALLEY\n",
"20 CENTERWOOD PARK\n",
"21 ENSLEY\n",
"22 EAST LAKE\n",
"23 EDGEWOOD\n",
"24 JEFFERSON HILLS\n",
"25 HOMEWOOD\n",
"26 WYNDHAM ROCKHAMPTON\n",
"27 LAKE CYRUS\n",
"28 GREYSTONE FARMS ENGLISH TURN\n",
"29 ASHTON WOODS\n",
"Name: SUBDIVISION, dtype: object"
]
}
],
"prompt_number": 1
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df=pd.read_excel('Documents/Heatherwood/Tbl_Fix_subdivnames.xls', 'Tbl_Fix_subdivnames',index_col=0)\n",
"df3=df[df['NSUBDIVISION'].notnull()]#selects the \"active\" translation records eliminates nulls, just assigned to df3 to print\n",
"from IPython.display import HTML \n",
"HTML(df3.to_html())"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"WARNING *** file size (150380) not 512 + multiple of sector size (512)\n",
"WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero\n"
]
},
{
"html": [
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>NSUBDIVISION</th>\n",
" </tr>\n",
" <tr>\n",
" <th>SUBDIVISION</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>*HUFFMAN**8MILES NE</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>00</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>000</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0000</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0000000</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>00000000000000000000</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>01</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1/2 ACRE M/L</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11TH COURT FLATS</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17 MISTY MEADOWS</th>\n",
" <td> MISTY MEADOWS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1ST SECTOR</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1ST SECTOR BENT RIVE</th>\n",
" <td> BENT RIVER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1ST/CHEROKEE HILLS</th>\n",
" <td> CHEROKEE HILLS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28 WESTRIDGE MANOR</th>\n",
" <td> WESTRIDGE MANOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2ND PHASE EAGLE TRAC</th>\n",
" <td> EAGLE TRAC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2ND SECTOR STERLING</th>\n",
" <td> STERLING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>303 CAMDEN COVE SECT</th>\n",
" <td> CAMDEN COVE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32/2W</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32-15-2</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32-15-2W</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32-15S</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32-2W</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33 TOWNSHIP 17 SOUTH</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3RD SECTOR</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3RD SECTOR SILVERLAK</th>\n",
" <td> SILVERLAKE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3RD/SIVERLAKES</th>\n",
" <td> SILVERLAKE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4TH SECT CARROLLWOOD</th>\n",
" <td> CARROLLWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5TH ADDN TO FORESTPK</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 2ND SEC. MAGNOLIA</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9TH SEC TRACE CROSSI</th>\n",
" <td> TRACE CROSSING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9TH SECTOR SMITHFIEL</th>\n",
" <td> NONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ACTON MEADOWS</th>\n",
" <td> ACTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ACTON PARK</th>\n",
" <td> ACTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ALTADENA BEND</th>\n",
" <td> ALTADENA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ALTADENA FOREST</th>\n",
" <td> ALTADENA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ALTADENA WOODS</th>\n",
" <td> ALTADENA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE BRAEMAR</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE CALISTON</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE CARNOUSTIE CREST</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE CLUB DR THE MANOR</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE GLENEAGLES</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE GLENGERRY</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE HADDINGTON PARC</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE KENNISTON</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE KILKERRAN</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE LAUCHLIN</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE LOCHINVAR</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE MACALLAN</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE STONEYKIRK</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE STRATHAVEN</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BALLANTRAE WEYBRIDGE</th>\n",
" <td> BALLANTRAE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BROOK HIGHLAND</th>\n",
" <td> BROOK HIGHLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BROOK HIGHLAND THE COTTAGES</th>\n",
" <td> BROOK HIGHLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BROOK HIGHLAND TOWNES</th>\n",
" <td> BROOK HIGHLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CAMDEN COVE</th>\n",
" <td> CAMDEN COVE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CAMDEN COVE WEST</th>\n",
" <td> CAMDEN COVE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CARRIAGE HILL</th>\n",
" <td> CARRIAGE HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CARRIAGE HILLS</th>\n",
" <td> CARRIAGE HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CARRIAGE HILLS ESTAT</th>\n",
" <td> CARRIAGE HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CARRIGE HILLS ESTATE</th>\n",
" <td> CARRIAGE HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CARRINGTON COTTAGES</th>\n",
" <td> CARRINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CARRINGTON DOWNS</th>\n",
" <td> CARRINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CARRINGTON ESTATES</th>\n",
" <td> CARRINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CARRINGTON LAKES</th>\n",
" <td> CARRINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CARRINGTON LAKES-THE</th>\n",
" <td> CARRINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CARRINGTON VALLEY</th>\n",
" <td> CARRINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CARRINGTON-THE CREST</th>\n",
" <td> CARRINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CHAPEL HILLS - THE S</th>\n",
" <td> CHAPEL HILLS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CHAPEL HILLS- THE SU</th>\n",
" <td> CHAPEL HILLS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CHAPEL HILLS -THE SU</th>\n",
" <td> CHAPEL HILLS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CHAPEL HILLS THE SUM</th>\n",
" <td> CHAPEL HILLS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CHAPEL HILLS THESUMM</th>\n",
" <td> CHAPEL HILLS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CHAPEL HILLS-THE SUM</th>\n",
" <td> CHAPEL HILLS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>COTTAGES AT DEER VALLEY</th>\n",
" <td> DEER VALLEY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>COTTAGES AT STONEHAVEN</th>\n",
" <td> STONEHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CROWN POINT</th>\n",
" <td> CROWN POINT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CROWN POINTE</th>\n",
" <td> CROWN POINT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DEER VALLEY</th>\n",
" <td> DEER VALLEY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>EAGLE POINT</th>\n",
" <td> EAGLE POINT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>EAGLE TRACE</th>\n",
" <td> EAGLE POINT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FOREST LAKE</th>\n",
" <td> FOREST LAKES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FOREST LAKES</th>\n",
" <td> FOREST LAKES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FOREST LAKES 40</th>\n",
" <td> FOREST LAKES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GRANDE VIEW</th>\n",
" <td> GRANDE VIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GRANDE VIEW ESATES</th>\n",
" <td> GRANDE VIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GRANDE VIEW ESTATES</th>\n",
" <td> GRANDE VIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GRANDEVIEW</th>\n",
" <td> GRANDE VIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GRANDVIEW</th>\n",
" <td> GRANDE VIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GRANTS MILL</th>\n",
" <td> GRANTS MILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GRANTS MILL AT 119</th>\n",
" <td> GRANTS MILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GRAYSON VALLEY</th>\n",
" <td> GRAYSON VALLEY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GRAYSON VALLEY HIGHLAND</th>\n",
" <td> GRAYSON VALLEY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE COVE</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE COVE DRIVE</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE CREST</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE EAST</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE FARMS</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE FARMS ENGLISH TURN</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE FARMS GUILFORD</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE FARMS LAKES EDGE</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE FARMS MILNERS CRSNT</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE FARMS TERR HILLS</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE GLEN</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE HIGHLANDS</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE LEGACY</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE LINKSIDE</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE NORTH LAKE</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE RIDGE</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE SHOAL CREEK</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE SOUTH</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE VILLAGE</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GREYSTONE, THE PARC</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>HEATHERWOOD FOREST</th>\n",
" <td> HEATHERWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS APPLECROSS</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS COBBLESTONE SQUARE</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS COUNTRY CLUB VILLAGE</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS COVE</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS GARDENS</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS GREEN</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS HIGHLANDS</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS KERRY DOWNS</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS KIRKWALL</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS POINT</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS RUN</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS SELKIRK</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS WOODFORD</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS WYNGATE</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INVERNESS/WILMINGTON</th>\n",
" <td> INVERNESS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KENSINGTON</th>\n",
" <td> KENSINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KENSINGTON PARC</th>\n",
" <td> KENSINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KENSINGTON PLACE</th>\n",
" <td> KENSINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KENSINTON PLACE</th>\n",
" <td> KENSINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LAKEVIEW</th>\n",
" <td> LAKEVIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LAKEVIEW ESTATES</th>\n",
" <td> LAKEVIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LAKEVIEW HOMES @ PAR</th>\n",
" <td> LAKEVIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LAKEWOOD</th>\n",
" <td> LAKEWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LAKEWOOD ESTATES</th>\n",
" <td> LAKEWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LONGBROOK</th>\n",
" <td> LONGBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LONGBROOK ESTATES</th>\n",
" <td> LONGBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MEADOW BROOK TOWNHOM</th>\n",
" <td> MEADOWBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MEADOWBROOK</th>\n",
" <td> MEADOWBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MEADOWBROOK CLUSTER</th>\n",
" <td> MEADOWBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MEADOWBROOK TOWNHOME</th>\n",
" <td> MEADOWBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MILL SPRINGS</th>\n",
" <td> MILL SPRINGS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MILL SPRINGS ESTATES</th>\n",
" <td> MILL SPRINGS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MOUNTAIN LAKE</th>\n",
" <td> MOUNTAIN LAKE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MOUNTAIN LAKE ESTATES</th>\n",
" <td> MOUNTAIN LAKE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NARROWS</th>\n",
" <td> NARROWS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NARROWS CREEK</th>\n",
" <td> NARROWS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NARROWS PEAK</th>\n",
" <td> NARROWS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NARROWS POINT</th>\n",
" <td> NARROWS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NARROWS REACH</th>\n",
" <td> NARROWS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NONE</th>\n",
" <td> OTHER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>OAKBROOK</th>\n",
" <td> OAKBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>OAKBROOK ESTATES</th>\n",
" <td> OAKBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>OAKBROOKE</th>\n",
" <td> OAKBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>OAKBROOKE ESTATES</th>\n",
" <td> OAKBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>OVERBROOK</th>\n",
" <td> OVERBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>OVERBROOK ESTATES</th>\n",
" <td> OVERBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>OVERBROOK GARDENS</th>\n",
" <td> OVERBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>OVERBROOK HIGHLANDS</th>\n",
" <td> OVERBROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PEPPERTREE</th>\n",
" <td> PEPPERTREE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PEPPERTREE HIGHLAND</th>\n",
" <td> PEPPERTREE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PROMISE MAANOR</th>\n",
" <td> PROMISE MANOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PROMISE MANOR</th>\n",
" <td> PROMISE MANOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PROMISE MANOR III</th>\n",
" <td> PROMISE MANOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>QUEENSBURY</th>\n",
" <td> QUEENSBURY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>QUEENSBURY EAST</th>\n",
" <td> QUEENSBURY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>REGENCY</th>\n",
" <td> REGENCY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>REGENCY EAST</th>\n",
" <td> REGENCY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIDGE @ STONEHAVEN</th>\n",
" <td> STONEHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIDGE AT STONEHAVEN</th>\n",
" <td> STONEHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIDGEVIEW</th>\n",
" <td> RIDGEVIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIDGEVIEW ESTATE</th>\n",
" <td> RIDGEVIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIDGEVIEW ESTATES</th>\n",
" <td> RIDGEVIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIDGEWAY</th>\n",
" <td> RIDGEWAY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIDGEWAY ACRES</th>\n",
" <td> RIDGEWAY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIDGEWOOD</th>\n",
" <td> RIDGEWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIDGEWOOD FOREST</th>\n",
" <td> RIDGEWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVER BROOK</th>\n",
" <td> RIVER BROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVER BROOK ESTATES</th>\n",
" <td> RIVER BROOK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVER OAKS</th>\n",
" <td> RIVER OAKS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVER OAKS 12-7-1</th>\n",
" <td> RIVER OAKS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVER TRACE</th>\n",
" <td> RIVER TRACE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVER TRACE COURT</th>\n",
" <td> RIVER TRACE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVER WALK</th>\n",
" <td> RIVER WALK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVER WALK LANE</th>\n",
" <td> RIVER WALK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVER WALK TOWN HOME</th>\n",
" <td> RIVER WALK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERBEND</th>\n",
" <td> RIVERBEND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERBEND ESTATES</th>\n",
" <td> RIVERBEND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERBEND SUB 3 SEC</th>\n",
" <td> RIVERBEND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERCHASE</th>\n",
" <td> RIVERCHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERCHASE COUNTRY CLUB</th>\n",
" <td> RIVERCHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERCHASE CTRY CLB</th>\n",
" <td> RIVERCHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERCHASE RCC 35TH</th>\n",
" <td> RIVERCHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERCHASE THE FAIRWAYS</th>\n",
" <td> RIVERCHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERCHASE THE HIGHLANDS</th>\n",
" <td> RIVERCHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERCHASE TOWNHOMES</th>\n",
" <td> RIVERCHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERCHASE WEST DAVE</th>\n",
" <td> RIVERCHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERWALK</th>\n",
" <td> RIVER WALK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERWOOD</th>\n",
" <td> RIVERWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERWOOD 1ST SECTOR</th>\n",
" <td> RIVERWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVERWOODS</th>\n",
" <td> RIVERWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROCK CREEK</th>\n",
" <td> ROCK CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROCK CREEK GARDENS</th>\n",
" <td> ROCK CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROLLING MEADOW</th>\n",
" <td> ROLLING MEADOW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROLLING MEADOW ESTAT</th>\n",
" <td> ROLLING MEADOW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROLLING MEADOWS</th>\n",
" <td> ROLLING MEADOW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROLLING MEADOWS ESTA</th>\n",
" <td> ROLLING MEADOW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSE DALE</th>\n",
" <td> ROSEDALE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSEDALE</th>\n",
" <td> ROSEDALE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSEDALE ESTATES</th>\n",
" <td> ROSEDALE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSS BRIDGE ABBEYGLEN</th>\n",
" <td> ROSS BRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSS BRIDGE BELLEVUE</th>\n",
" <td> ROSS BRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSS BRIDGE BUTLER SPRINGS</th>\n",
" <td> ROSS BRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSS BRIDGE CHALYBE</th>\n",
" <td> ROSS BRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSS BRIDGE FREESTONE RIDGE</th>\n",
" <td> ROSS BRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSS BRIDGE GLASSCOTT</th>\n",
" <td> ROSS BRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSS BRIDGE GRAND AVENUE</th>\n",
" <td> ROSS BRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSS BRIDGE GREENSIDE</th>\n",
" <td> ROSS BRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSS BRIDGE HADDON</th>\n",
" <td> ROSS BRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSS BRIDGE JAMES HILL</th>\n",
" <td> ROSS BRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROSS BRIDGE VILLAGE CENTER</th>\n",
" <td> ROSS BRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROWAN SPRINGS</th>\n",
" <td> ROWAN SPRINGS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROWAN SPRINGS SUB.</th>\n",
" <td> ROWAN SPRINGS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROWAN SPRINS SUB.</th>\n",
" <td> ROWAN SPRINGS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROYAL CHASE</th>\n",
" <td> ROYAL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROYAL CREST</th>\n",
" <td> ROYAL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROYAL FOREST</th>\n",
" <td> ROYAL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROYAL GROVE</th>\n",
" <td> ROYAL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROYAL RIDGE</th>\n",
" <td> ROYAL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROYAL TERRACE</th>\n",
" <td> ROYAL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ROYHL CHASE</th>\n",
" <td> ROYAL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RUSSET LANDING</th>\n",
" <td> RUSSET</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RUSSET MEADOWS</th>\n",
" <td> RUSSET</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RUSSET MEADOWS 3D PH</th>\n",
" <td> RUSSET</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RUSSET MEADOWS PHASE</th>\n",
" <td> RUSSET</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RUSSET WOODS</th>\n",
" <td> RUSSET</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RUSSET WOODS THE GRO</th>\n",
" <td> RUSSET</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SADDLE CREEK</th>\n",
" <td> SADDLE CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SADDLE CREEK ESTATES</th>\n",
" <td> SADDLE CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SADDLE LAKE</th>\n",
" <td> SADDLE CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SADDLE LAKE FARMS</th>\n",
" <td> SADDLE CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SADDLE LAKES</th>\n",
" <td> SADDLE CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SADDLE POINTE</th>\n",
" <td> SADDLE CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SADDLE RIDGE 2ND SEC</th>\n",
" <td> SADDLE CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SADDLECREEK</th>\n",
" <td> SADDLE CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SADDLECREEK PHASE 4</th>\n",
" <td> SADDLE CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SADDLECREEK PHS 4</th>\n",
" <td> SADDLE CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SARDIS GROVE</th>\n",
" <td> SARDIS GROVE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SARDIS GROVE I</th>\n",
" <td> SARDIS GROVE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAVANNAH LANE</th>\n",
" <td> SAVANNAH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAVANNAH PARK</th>\n",
" <td> SAVANNAH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAVANNAH PIONTE</th>\n",
" <td> SAVANNAH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAVANNAH POINT</th>\n",
" <td> SAVANNAH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAVANNAH POINTE</th>\n",
" <td> SAVANNAH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAVANNAH RIDGE</th>\n",
" <td> SAVANNAH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SEC 5 LONGWOOD</th>\n",
" <td> LONGWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SEC/2/AMANDA TRACE</th>\n",
" <td> AMANDA TRACE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SECT 4 CARROLLWOOD</th>\n",
" <td> CARROLLWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SECTION 5 LONGWOOD</th>\n",
" <td> LONGWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SECTOR 1 CROSSBRIDGE</th>\n",
" <td> CROSSBRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SECTOR 4 CARROLLWOOD</th>\n",
" <td> CARROLLWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SECTOR 5 LONGWOOD</th>\n",
" <td> LONGWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SEDDON</th>\n",
" <td> SEDDON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SEDDON FARMS</th>\n",
" <td> SEDDON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SEDDON FARMS SD</th>\n",
" <td> SEDDON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SEDDON FARMS SUBD.</th>\n",
" <td> SEDDON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHADES ACRES</th>\n",
" <td> SHADES ACRES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHADES ACRES ESTATES</th>\n",
" <td> SHADES ACRES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHALBT FOREST ESTATE</th>\n",
" <td> SHELBY FOREST EST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHAMROCK</th>\n",
" <td> SHAMROCK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHAMRODK</th>\n",
" <td> SHAMROCK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHELBY FOREST</th>\n",
" <td> SHELBY FOREST EST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHELBY FOREST EATATE</th>\n",
" <td> SHELBY FOREST EST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHELBY FOREST EST</th>\n",
" <td> SHELBY FOREST EST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHELBY FOREST ESTATE</th>\n",
" <td> SHELBY FOREST EST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHELBY SPRINGS</th>\n",
" <td> SHELBY SPRINGS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHELBY SPRINGS FARMS</th>\n",
" <td> SHELBY SPRINGS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHERMAN OAKS</th>\n",
" <td> SHERMAN OAKS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHERMAN OAKS GARD</th>\n",
" <td> SHERMAN OAKS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHERMAN OAKS GARDEN</th>\n",
" <td> SHERMAN OAKS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHERMAN OAKS GARDENS</th>\n",
" <td> SHERMAN OAKS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHOOK HILL</th>\n",
" <td> SHOOK HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHOOK HILL ESTATES</th>\n",
" <td> SHOOK HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHQAMROCK</th>\n",
" <td> SHAMROCK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVER CREEK</th>\n",
" <td> SILVER CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVER CREEK/COBBLES</th>\n",
" <td> SILVER CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVER LAKE</th>\n",
" <td> SILVER LAKE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVER LAKES</th>\n",
" <td> SILVER LAKE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVER LAKES 2ND SEC</th>\n",
" <td> SILVER LAKE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVER LEAF</th>\n",
" <td> SILVER LEAF</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVER LEAF PH 1</th>\n",
" <td> SILVER LEAF</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVER LEAF PH 2</th>\n",
" <td> SILVER LEAF</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVERFEAF</th>\n",
" <td> SILVER LEAF</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVERLAKE</th>\n",
" <td> SILVER LAKE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVERLAKE 2ND SECTO</th>\n",
" <td> SILVER LAKE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVERLAKES</th>\n",
" <td> SILVER LAKE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVERLAKES 2ND SECT</th>\n",
" <td> SILVER LAKE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVERLEAF</th>\n",
" <td> SILVER LEAF</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVERLEAF PH 1</th>\n",
" <td> SILVER LEAF</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVERLEAF PHASE 2</th>\n",
" <td> SILVER LEAF</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVERLEAF PHASE ONE</th>\n",
" <td> SILVER LEAF</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVERLEAFT</th>\n",
" <td> SILVER LEAF</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SIVERLEAF</th>\n",
" <td> SILVER LEAF</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLEEPY HOLLOW</th>\n",
" <td> SLEEPY HOLLOW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SLEEPY HOLLOW</th>\n",
" <td> SLEEPY HOLLOW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SMITHFIELD FOR. 10TH</th>\n",
" <td> SMITHFIELD FOREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SMITHFIELD FOREST</th>\n",
" <td> SMITHFIELD FOREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SMOKE RISE</th>\n",
" <td> SMOKE RISE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SMOKE RISE, SECTOR 6</th>\n",
" <td> SMOKE RISE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SMOKERISE</th>\n",
" <td> SMOKE RISE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SMOKERISE AREA</th>\n",
" <td> SMOKE RISE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SOMERBY</th>\n",
" <td> SOMERBY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SOMERBY @ UNIV. PARK</th>\n",
" <td> SOMERBY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SOMERSBY</th>\n",
" <td> SOMERBY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SOMESBY</th>\n",
" <td> SOMERBY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SOMMERSBY</th>\n",
" <td> SOMERBY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SOUTH CREST</th>\n",
" <td> SOUTHCREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SOUTHCREST</th>\n",
" <td> SOUTHCREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SOUTHWOOD HIGHLAND</th>\n",
" <td> SOUTHWOOD HIGHLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SOUTHWOOD HIGHLANDS</th>\n",
" <td> SOUTHWOOD HIGHLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SOUTHWOOOD HIGHLANDS</th>\n",
" <td> SOUTHWOOD HIGHLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SPRING GATE</th>\n",
" <td> SPRING GATE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SPRING GATE \"THE COV</th>\n",
" <td> SPRING GATE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SPRING GATE ESTATES</th>\n",
" <td> SPRING GATE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SPRING GATE SEC. 4</th>\n",
" <td> SPRING GATE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SPRING GATE THE COVE</th>\n",
" <td> SPRING GATE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SPRINGFIELD EST</th>\n",
" <td> SPRINGVILLE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SPRINGHILL ESTATES</th>\n",
" <td> SPRINGVILLE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SPRINGVIEW EST</th>\n",
" <td> SPRINGVILLE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SPRINGVILLE</th>\n",
" <td> SPRINGVILLE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SPRINGVILLE,OAK RIDG</th>\n",
" <td> SPRINGVILLE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SPRINGVILLE/ODENVILL</th>\n",
" <td> SPRINGVILLE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ST MARGARETS</th>\n",
" <td> ST MARGARETS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ST MARGARETS COURT</th>\n",
" <td> ST MARGARETS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ST. MARGARET'S COURT</th>\n",
" <td> ST MARGARETS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STAGE COACH</th>\n",
" <td> STAGECOACH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STAGE COACH TRACE</th>\n",
" <td> STAGECOACH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STAGECOACH</th>\n",
" <td> STAGECOACH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STAGECOACH MANOR</th>\n",
" <td> STAGECOACH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STEEPLE CHASE</th>\n",
" <td> STEEPLE CHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STEEPLE CHASE/CLAY</th>\n",
" <td> STEEPLE CHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STEEPLECHASE</th>\n",
" <td> STEEPLE CHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STEEPLECHASE - 5TH S</th>\n",
" <td> STEEPLE CHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STEEPLECHASE 3RD</th>\n",
" <td> STEEPLE CHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STEEPLECHASE 5TH SEC</th>\n",
" <td> STEEPLE CHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STEEPLECHASE, 5TH SE</th>\n",
" <td> STEEPLE CHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STERLING ARBOR</th>\n",
" <td> STERLING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STERLING GATE</th>\n",
" <td> STERLING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STERLING GATE CEDAR GROVE</th>\n",
" <td> STERLING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STERLING GATE HIGH GROVE</th>\n",
" <td> STERLING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STERLING GATE PADDINGTON STN</th>\n",
" <td> STERLING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STERLING OAKS</th>\n",
" <td> STERLING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STERLING PARK</th>\n",
" <td> STERLING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STERLING RIDGE</th>\n",
" <td> STERLING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STERLINGWOOD</th>\n",
" <td> STERLING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STILL MEADOW</th>\n",
" <td> STILLMEADOW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STILL OAKS</th>\n",
" <td> STILL OAKS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STILL OAKS.THE OAKS</th>\n",
" <td> STILL OAKS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STILL OAKS/THE OAKS</th>\n",
" <td> STILL OAKS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STILLMEADOW</th>\n",
" <td> STILLMEADOW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STILLOAKS</th>\n",
" <td> STILL OAKS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STOENCREST @ HIDDEN</th>\n",
" <td> STONECREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STONEBRIAR</th>\n",
" <td> STONEBRIAR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STONEBRIAR 1ST SET</th>\n",
" <td> STONEBRIAR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STONECREST</th>\n",
" <td> STONECREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STONECREST @ HIDDEN</th>\n",
" <td> STONECREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STONECREST @HIDDEN T</th>\n",
" <td> STONECREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STONECREST -HIDDEN T</th>\n",
" <td> STONECREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STONEHAVEN</th>\n",
" <td> STONEHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STONEHAVEN COTTAGES</th>\n",
" <td> STONEHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STONEHAVEN COTTAGES</th>\n",
" <td> STONEHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STONEHEDGE</th>\n",
" <td> STONEHEDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STONEHEDGE 2ND ADD</th>\n",
" <td> STONEHEDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STONEHENGE ROAD</th>\n",
" <td> STONEHEDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUGAR HILL</th>\n",
" <td> SUGAR HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUGARHILL</th>\n",
" <td> SUGAR HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMER PLACE</th>\n",
" <td> SUMMER PLACE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMER CREST</th>\n",
" <td> SUMMER CREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMER PLACE</th>\n",
" <td> SUMMER PLACE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMER PLACE 2ND SEC</th>\n",
" <td> SUMMER PLACE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMERCHASE</th>\n",
" <td> SUMMERCHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMERCNASE</th>\n",
" <td> SUMMERCHASE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMERCREST</th>\n",
" <td> SUMMER CREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMERFIELD</th>\n",
" <td> SUMMERFIELD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMERFIELD COTTAGES</th>\n",
" <td> SUMMERFIELD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMIT PLACE</th>\n",
" <td> SUMMIT PLACE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMIT PLACE @ HIGH</th>\n",
" <td> SUMMIT PLACE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMIT PLACE AT HIGH</th>\n",
" <td> SUMMIT PLACE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SUMMIT PLACE-HIGH RI</th>\n",
" <td> SUMMIT PLACE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SWEET WATER</th>\n",
" <td> SWEET WATER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SWEETWATER</th>\n",
" <td> SWEET WATER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SWEETWATER 111</th>\n",
" <td> SWEET WATER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SWEETWATER IV</th>\n",
" <td> SWEET WATER</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TANGLEWOOD</th>\n",
" <td> TANGLEWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TANGLEWOOD BY THE CREEK</th>\n",
" <td> TANGLEWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TANGLEWOOD SUB.</th>\n",
" <td> TANGLEWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TANNEHILL</th>\n",
" <td> TANNEHILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TANNEHILL FOREST</th>\n",
" <td> TANNEHILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TANNEHILL PARKWAY</th>\n",
" <td> TANNEHILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>THE GLEN AT GREYSTONE</th>\n",
" <td> GREYSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>THE HIGHLANDS</th>\n",
" <td> HIGHLANDS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>THE MEADOWS</th>\n",
" <td> MEADOWS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>THE NARROWS</th>\n",
" <td> NARROWS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>THE OAKS</th>\n",
" <td> OAKS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>THE OAKS ON PARKWOOD</th>\n",
" <td> OAKS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>THE PRESERVE</th>\n",
" <td> PRESERVE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>THE RIDGE AT STONEHA</th>\n",
" <td> STONEHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>THE VILLAGE AT DEER</th>\n",
" <td> DEER VALLEY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>THE VILLAGE DEER VAL</th>\n",
" <td> DEER VALLEY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>THE VILLAGE PHASE 2</th>\n",
" <td> THE VILLAGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TICE CAHABA HILLS</th>\n",
" <td> TICE CAHABA HILLS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TICE-CAHABA HILLS</th>\n",
" <td> TICE CAHABA HILLS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TIFFANY</th>\n",
" <td> TIFFANY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TIFFANY ESTATES</th>\n",
" <td> TIFFANY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TIFFANY ESTS.</th>\n",
" <td> TIFFANY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TOCOA PARC</th>\n",
" <td> TOCOA PARC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TOCOA PARK</th>\n",
" <td> TOCOA PARC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRACE CROSSING</th>\n",
" <td> TRACE CROSSING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRACE CROSSINGS</th>\n",
" <td> TRACE CROSSING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRACE CROSSINGS/LAKE</th>\n",
" <td> TRACE CROSSING</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TRAILS-DEER VALLEY</th>\n",
" <td> DEER VALLEY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TURWILER FARM</th>\n",
" <td> TUTWILER FARM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TUTWILER FARM</th>\n",
" <td> TUTWILER FARM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TUTWILER FARMS</th>\n",
" <td> TUTWILER FARM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TUTWILER FARMS 10TH</th>\n",
" <td> TUTWILER FARM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TUTWILER FARMS 9TH S</th>\n",
" <td> TUTWILER FARM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VALLEY CREST</th>\n",
" <td> VALLEY CREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VALLEY CREST ESTATE</th>\n",
" <td> VALLEY CREST</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VALLEY VIEW</th>\n",
" <td> VALLEY VIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VALLY VIEW ACRES</th>\n",
" <td> VALLEY VIEW</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VERNON HILL</th>\n",
" <td> VERNON HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VERNON HILL 2ND SECT</th>\n",
" <td> VERNON HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VERNON HILL/HILL PAR</th>\n",
" <td> VERNON HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VERNON HILLS</th>\n",
" <td> VERNON HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VESTAIVIA HILL</th>\n",
" <td> VESTAIVIA HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VESTAVIA HILLS</th>\n",
" <td> VESTAIVIA HILL</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE @ DEER VALLE</th>\n",
" <td> DEER VALLEY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE AT BROOK HIG</th>\n",
" <td> BROOK HIGHLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE AT BROOKHIGHLAND</th>\n",
" <td> BROOK HIGHLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE AT DEER VALL</th>\n",
" <td> DEER VALLEY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE AT HIGHLAND</th>\n",
" <td> HIGHLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE AT STONEHAVE</th>\n",
" <td> STONEHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE AT STONNEHAV</th>\n",
" <td> STONEHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE BROOK HIGHLA</th>\n",
" <td> BROOK HIGHLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE OF STONEHAVE</th>\n",
" <td> STONEHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE PARISH</th>\n",
" <td> PARRISH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE PARRISH</th>\n",
" <td> PARRISH</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE STONEHAVEN</th>\n",
" <td> STONEHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE@BROOKHGHLAND</th>\n",
" <td> BROOK HIGHLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE@BROOKHIGHLAN</th>\n",
" <td> BROOK HIGHLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VILLAGE@DEERVALLEY</th>\n",
" <td> DEER VALLEY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WATERFORD</th>\n",
" <td> WATERFORD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WATERFORD - THE VILL</th>\n",
" <td> WATERFORD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WATERFORD - VILLAGE</th>\n",
" <td> WATERFORD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WATERFORD / THE VILL</th>\n",
" <td> WATERFORD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WATERFORD CONDOS</th>\n",
" <td> WATERFORD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WATERFORD COVE</th>\n",
" <td> WATERFORD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WATERFORD FALLS</th>\n",
" <td> WATERFORD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WATERFORD HIGHLANDS</th>\n",
" <td> WATERFORD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WATERFORD -THE VILLA</th>\n",
" <td> WATERFORD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WATERFORD VILLAGE</th>\n",
" <td> WATERFORD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY ABERDEEN</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY BELVEDERE</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY BERKSHIRE</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY BROADMOOR</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY CLUB DRIVE</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY COVE</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY HIGHLANDS</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY THE COVE</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY TREYMOOR</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY WARWICK</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY WINDSOR</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY WIXFORD</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WEATHERLY-THE COVE</th>\n",
" <td> WEATHERLY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WELLINGTON</th>\n",
" <td> WELLINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WELLINGTON PARK</th>\n",
" <td> WELLINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WELLINGTON/WYNDHAM</th>\n",
" <td> WELLINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WELLLINGTON</th>\n",
" <td> WELLINGTON</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WESTWIND - HUEYTOWN</th>\n",
" <td> WESTWIND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WESTWIND SUBDIV</th>\n",
" <td> WESTWIND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WHISPERING PINES</th>\n",
" <td> WHISPERING PINES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WHISPERING PINES PHA</th>\n",
" <td> WHISPERING PINES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WHITESTONE TOWNHOMES</th>\n",
" <td> WHITESTONE TOWNHOMES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WHITESTONE TWNHMES</th>\n",
" <td> WHITESTONE TOWNHOMES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WILD ACRES</th>\n",
" <td> WILD ACRES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WILD ACRES 2</th>\n",
" <td> WILD ACRES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WILKERSON</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WILKERSON 4</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WILKERSON/WYNDHAM</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WILKERSON/WYNHAM</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WILLOW CREEK</th>\n",
" <td> WILLOW CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WILLOW CREEK SOUTH</th>\n",
" <td> WILLOW CREEK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WILSONS GLEN</th>\n",
" <td> WILSONS GLEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WILSON'S GLEN</th>\n",
" <td> WILSONS GLEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINDSOR</th>\n",
" <td> WINDSOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINDSOR EST</th>\n",
" <td> WINDSOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINDSOR FOREST</th>\n",
" <td> WINDSOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINDSOR HIGHLANDS</th>\n",
" <td> WINDSOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINDSOR PARK</th>\n",
" <td> WINDSOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINDSOR PARK PHASE I</th>\n",
" <td> WINDSOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINDSOR PARK-MOODY</th>\n",
" <td> WINDSOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINDSOR PARKWAY</th>\n",
" <td> WINDSOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINDSOR RIDGE</th>\n",
" <td> WINDSOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINDSOR VILLAGE</th>\n",
" <td> WINDSOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINDSTONE</th>\n",
" <td> WINDSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINDSTONE VI</th>\n",
" <td> WINDSTONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINE RIDGE</th>\n",
" <td> WINE RIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WINEWOOD</th>\n",
" <td> WINE RIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODBURY</th>\n",
" <td> WOODBURY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODBURY FOREST</th>\n",
" <td> WOODBURY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODBURY FORREST</th>\n",
" <td> WOODBURY</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODHAVE ESTATES</th>\n",
" <td> WOODHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODHAVEN</th>\n",
" <td> WOODHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODHAVEN LAKE</th>\n",
" <td> WOODHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODHAVEN LAKE ESTAT</th>\n",
" <td> WOODHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODHAVEN LAKES</th>\n",
" <td> WOODHAVEN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODLAMD HILLS</th>\n",
" <td> WOODLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODLAND</th>\n",
" <td> WOODLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODLAND ESTATES</th>\n",
" <td> WOODLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODLAND FOREST</th>\n",
" <td> WOODLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODLAND HILLS</th>\n",
" <td> WOODLAND</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODRIDGE</th>\n",
" <td> WOODRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODRIDGE ESTATES</th>\n",
" <td> WOODRIDGE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODRUFF FARMS</th>\n",
" <td> WOODRUFF FARMS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODRUFF FARMS - PHA</th>\n",
" <td> WOODRUFF FARMS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODRUFF FARMS II</th>\n",
" <td> WOODRUFF FARMS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODRUFF FARMS III</th>\n",
" <td> WOODRUFF FARMS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODRUFF FARMS PAHSE</th>\n",
" <td> WOODRUFF FARMS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODRUFF FARMS PHASE</th>\n",
" <td> WOODRUFF FARMS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODRUFF FARMS PHS 1</th>\n",
" <td> WOODRUFF FARMS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODRUFF FARMS, PHAS</th>\n",
" <td> WOODRUFF FARMS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODRUFF FARMS-PHASE</th>\n",
" <td> WOODRUFF FARMS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODSTOCK</th>\n",
" <td> WOODSTOCK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WOODSTOCK-BIG SPRING</th>\n",
" <td> WOODSTOCK</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYDHAM COTTAGES</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM BEDFORD</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM BEFORD</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM COTTAGES</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM COTTAGES PHI</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM ROCKHAMPTON</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM ROCKHAMTON</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM TH</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM TOWNHOMES</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM WILKERSON</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM*</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM, WYNWOOD</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM,WYNWOOD</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM/BROOK FOREST</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM/ROCKHAMPTON</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM/WELLINGTON</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM/WIKLERSON</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM/WILKERSON</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM/WYNWOOD SECT</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNDHAM-ROCKHAMPTON</th>\n",
" <td> WYNDHAM</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNWOOD</th>\n",
" <td> WYNWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNWOOD LAKE</th>\n",
" <td> WYNWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNWOOD LAKES</th>\n",
" <td> WYNWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNWOOD OF WYHDHAM</th>\n",
" <td> WYNWOOD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WYNWOOD OF WYNDHAM</th>\n",
" <td> WYNWOOD</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 11,
"text": [
"<IPython.core.display.HTML at 0x8e4cf90>"
]
}
],
"prompt_number": 11
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"table3.replace(df['NSUBDIVISION'].to_dict(),inplace=True)\n",
"table3 ## Note that BERKLEY HILLS and the two following are not in the translate table\n",
"#And neither are the entries for the 1st 5 entries which did get replaced... #28 GREYSTONE was properly replaced\n",
"# I don't get it?"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 3,
"text": [
"0 NaN\n",
"1 NaN\n",
"2 NaN\n",
"3 NaN\n",
"4 NaN\n",
"5 NaN\n",
"6 BERKELEY HILLS\n",
"7 WESTHILL ACRES\n",
"8 SPRING LAKE MANOR\n",
"9 RIVER OAKS\n",
"10 NaN\n",
"11 NaN\n",
"12 WINFORD TOWNEHOMES\n",
"13 NaN\n",
"14 NaN\n",
"15 MCADORY P J\n",
"16 NaN\n",
"17 NaN\n",
"18 NaN\n",
"19 DRY VALLEY\n",
"20 CENTERWOOD PARK\n",
"21 NaN\n",
"22 NaN\n",
"23 NaN\n",
"24 NaN\n",
"25 NaN\n",
"26 WYNDHAM\n",
"27 NaN\n",
"28 GREYSTONE\n",
"29 NaN\n",
"Name: SUBDIVISION, dtype: object"
]
}
],
"prompt_number": 3
},
{
"cell_type": "code",
"collapsed": false,
"input": [],
"language": "python",
"metadata": {},
"outputs": []
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment