Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Location
    Liverpool, UK
    Posts
    6

    How to Model a cities streets

    Can anyone help get me off the ground...

    I want to create a database to model streets in a town.

    I want to represent the street having shops, specifying the location of the shops and show that streets intersect with other streets again being able to specify where the intersection of two streets occurs.

    Can anyone suggest how I could Start to do this?


    Thanks

    Mike

  2. #2
    Join Date
    Dec 2005
    Location
    Arnhem, Gld, NL
    Posts
    21
    Here is an img of a structure that i think of..
    It holds four tables now:
    cities: with city name wich is the pk
    streets: with an name and a incity, wich is a fk to cities
    shops: with shopname, instreet to tell in wich street it is, and location to tell a location of the shop.
    intersection: hoilds to streets and tell us on what location they cross.

    Locations could be gps coords, dunno how else you can tell where a shop is located or where an intersection.

    in streets, you could use incity and the street name as a pk, to have duplicate streetnames in different cities?
    in shops, you could use shopname, streetname and cityname to identify a shop to be able to have more shops with the same name in a city, also include postion to be able to have more of the same shops in one street..

    How did you have in mind to store the locations??

    i dunno if this helped you, but as far as i understood your question, this could be a start..
    Attached Thumbnails Attached Thumbnails sc.gif  
    Last edited by MoonCrawler; 02-01-06 at 11:02.

  3. #3
    Join Date
    Feb 2006
    Location
    Liverpool, UK
    Posts
    6
    Thanks a lot MoonCrawler. That has given me just what I was looking for.

    Not sure about how to do locations yet. But as I'm not interested in a realistic representation it wont be gps coords. I want something more diagramatic.

    Cheers

    Mike

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •