Untitled

one or four tables? (db structure)
id | thingID | regionId | countyId | cityId | placeId

id | thingId | regionId

id | thingId | countyId

id | thingId | cityId

id | thingId | placeId

Table: location
ID     Name                 Parent
------------------------
1     South East England    null
2     Middlesex             1
3     London                2
4     Chelsea               3
5     Kent                  1
6     Canterbury            5


Table: item
Id     name
-----------------
1      Posh Boy
2      Cricket ground
3      Rain

Table: item_location
ItemID    LocationID
--------------------
1        4    //Posh boy in Chelsea
2        2    // Cricket ground in Middlesex
3        1    // Rain in the South East of England.