Informative Maps on pda-phones

CS) Informative Maps on PDA-phones
Chui Pui Ling Page 46
4.5. Database Design
cd Database Table
Coordinates
*PK <> coordinateID: int
*
<> xCoordinate: int
*
<> yCoordinate: int
<> district text
<> subdistrict: text
<> street text
<> building text
<> constraintFactor: float
<> isJunction: smallint
+ <
>
PK_Coordinates(int)
NeighboringCoordinates
<> sourceCoordinateID: int
<> neighbourCoordinateID: int
<> photo image
UserStatus
*PK <> userID: int
*
<> xCoordinate: int
*
<> yCoordinate: int
<> currentLocationMap: image
<> zoomedCurrentLocationMap: image
*
<> district nvarchar(50)
*
<> subdistrict: nvarchar(50)
*
<> street nvarchar(50)
*
<> building nvarchar(50)
+ <
>
PK_UserProfile(int)

Table User Status
It is used to store the information of PDA-phones users. The X-/Y-coordinates are of standard HK Grid 80 format which is the current location detected via SUNDAY LBS [19]. The currentLocationMap and zoomedCurrentLocationMap are the map retrieved via SUNDAY LBS showing the current location as the centre point. The district, subdistrict, street and building are the address information corresponding to the current location detected.
• userID: a unique key to identify the PDA-phones users
• xCoordinate: x-coordinate of the user’s current location
• yCoordinate: y-coordinate of the user’s current location
• currentLocationMap: map from centamap with zoom level 4 showing user’s current locaiton
• zoomedCurrentLocationMap: map from centamap with zoom level 3 showing user’s current locaiton
• district the district of the user’s current coordinates
• subDistrict: the sub-district of the user’s current coordinates

CS) Informative Maps on PDA-phones
Chui Pui Ling Page 47
• street the street name of the user’s current coordiantes
• building the building name of the user’s current coordinates
Table Coordinates
It is used to store all the coordinates information of locations in HK. The X-/Y- coordinates are of standard HK Grid 80 format. The address information includes district, sub-district, street and building is collected via SUNDAY LBS web services [19].
• coodinateID: a unique key to identify the coordinates
• xCoordinate: x-coordinate in HK Grid 80 format
• yCoordinate: y-coordinate in HK Grid 80 format
• district the district of the coordinates
• subDistrict: the sub-district of the coordinates
• street the street name of the coordiantes
• building the building name of the coordinates
• constraintFactor: a factor to indicate the type of the coordinates, e.g. it would be a small value if the road is flat and well-known and it would be large if it is an unpopular
• isJunction: an indicator to specify if the coordinates is a junction point

Download 2.99 Mb.

Share with your friends: