@orange
Code:
STREET SUBDIVISION
ABBEY RD THREE SPRINGS
ACORN CT HIDDEN LAKE
ACORN DR HIDDEN LAKE
ADLER CV THE GATES
ALLISON LN THREE SPRINGS
ALVINA ROSE CT ROSEWOOD ESTATES
AMBERLEY LN CLARMONTE RIDGE
Subdivision Street
Hidden Lake Acorn Ct
Hidden Lake Acorn Dr
Hidden Lake Cranberry Ln
Hidden Lake W 89th Pl
They are all a part of 1 municipal corporation which has 5 different cities for mailing addresses.
If a developer has 1 square mile of land he wants to put 1,000 homes on he must install all of the utilities: watermains, sewer, storm sewer, street lights, streets, sidewalks, etc. before they can sell lots to people. The developer can't afford to put in all of the utilities at once so they break the subdivision in phases. They install all of the utilities for that phase only. Rolloing Meadows Phase 1 has 25 homes, Phase 2 has 25 homes, Phase 3 has 15 homes, etc until the subdivision is built out. So my subdivision table has fields for subdivision name and phase number.
@Davegri
I will take a look at the database shortly.
@ArviLannemets
I didn't design the original database I have to make it work. It has 21 years of data in it. There is a lot more wrong with it than just this. I have been cleaning it up for the last 3 months with no end in sight. I just finished pulling the StreetNames from the masterpermittable. All of the street names are now selectable from a Combo Box. No more misspellings.
A subdivision can have 1 street or 15 streets. A street can belong to more than 1 subdivision. Orland Av is an example of this. It runs through subdivisions: Cardinal, Pines, and Rosewood. I don't have to worry about street number ranges for this database. That is handled on the GIS side.