Urban planning community

+ Reply to thread
Results 1 to 4 of 4

Thread: New zoning database suggestions?

  1. #1
    Cyburbian
    Registered
    Mar 2011
    Location
    Purgatory
    Posts
    57

    New zoning database suggestions?

    We have an outdated system of tracking rezonings, variances, conditional uses, subdivisions, etc. I'd like to set up a database that can eventually be tied to GIS (that will have to come later). I've got plenty of experience using Access so I'm comfortable actually creating the database, but I'm not sure what I can use for a unique key to track the different applications. I'd like to get to a point where I can look up a piece of property and see all actions that have been done to it or are pending. My first thought was to use the parcel number as the unique ID, but if the parcels are divided (or combined) the tax parcel ID will change.

    Any suggestions or experience on how this database can be designed? Thanks!

  2. #2
    OH....IO Hink's avatar
    Registered
    Jan 2005
    Location
    Hang on Sloopy...land
    Posts
    10,127
    The best way is to create a unique key for each record. Using address or parcel ID generally causes issues at some point or another. Having an extra field for Unique ID and then working to relate the databases with this new ID, you will have better success keeping the database clean from trouble down the road.

    Good luck.
    A common mistake people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools. -Douglas Adams

  3. #3
    Cyburbian Plus
    Registered
    Jun 2003
    Location
    De Noc
    Posts
    18,164
    We track by parcel tax ID & docket #.
    Oddball
    Why don't you knock it off with them negative waves?
    Why don't you dig how beautiful it is out here?
    Why don't you say something righteous and hopeful for a change?
    From Kelly's Heroes (1970)


    Are you sure you're not hurt ?
    No. Just some parts wake up faster than others.
    Broke parts take a little longer, though.
    From Electric Horseman (1979)

  4. #4
    Cyburbian Raf's avatar
    Registered
    Feb 2007
    Location
    As far south of SoCal as I Will Go
    Posts
    5,116
    We track by Parcel ID# and unique ID Number:

    Zone Change - ZCH Year-0XX
    CUP - Year-0XX

    The unique number corresponds with our folder tracking numbers.
    follow me on the twitter @rcplans

+ Reply to thread

More at Cyburbia

  1. Zoning case database
    Land Use and Zoning
    Replies: 1
    Last post: 16 Mar 2011, 2:18 PM
  2. Internet Movie Car Database
    Friday Afternoon Club
    Replies: 6
    Last post: 02 Nov 2009, 5:19 PM
  3. Database error?
    Cyburbia Issues and Help
    Replies: 3
    Last post: 30 Nov 2006, 10:50 AM
  4. Forum database glitch
    Cyburbia Issues and Help
    Replies: 0
    Last post: 07 Nov 2006, 1:09 AM