Urban planning community | #theplannerlife

+ Reply to thread
Results 1 to 4 of 4

Thread: New zoning database suggestions?

  1. #1
    Mar 2011

    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
    Jan 2005
    Hang on Sloopy...land
    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
    Jun 2003
    We track by parcel tax ID & docket #.

  4. #4
    Cyburbian Raf's avatar
    Feb 2007
    Playing at a movie theater near you
    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.
    No Signature Required

+ Reply to thread

More at Cyburbia

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