1 / 5

Geographic Data Model Group

Geographic Data Model Group. Conventions. Tables names preceeded by ‘tbl’. Example: tblLocation, tblRoad. Similarly query names start with ‘qry’ and stored procedure names start with ‘prc’. All road segments heading in the north south direction are numbered from 0 - 1000.

jacoba
Download Presentation

Geographic Data Model Group

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Geographic Data Model Group

  2. Conventions • Tables names preceeded by ‘tbl’. • Example: tblLocation, tblRoad. • Similarly query names start with ‘qry’ and stored procedure names start with ‘prc’. • All road segments heading in the north south direction are numbered from 0 - 1000. • All road segments heading in the east west direction are numbered from 1000 onwards.

  3. Zones • tblZone has the following fields: • ZoneNorth • ZoneSouth • ZoneEast • ZoneWest • These fields will give the neighboring zone once the direction is specified.

  4. Name : Find_Zone Input : LocationID Returns : LocationZoneID Function : This procedure returns the ZoneID of the Source/Destination selected. Pseudo Code : create procedure Find_Zone SELECT LocationZoneID FROM tblLocation WHERE LocationID = ‘X’ Name : Find_Name Input : LocationID Returns : LocationName, LocationDescription Function : This procedure returns the name and description of the Source/Destination selected Pseudo Code : create procedure Find_Name SELECT LocationName, LocationDescription FROM tblLocation WHERE LocationID = ‘X’ StoredProcedures/Queries

  5. Stored Procedures/Queries (2) • Name : Find_Neighbor • Input : ZoneID, Direction • Returns : Zone(Direction)ID • Function : This procedure returns the ID of neighboring zone in the given direction for input zone. • Pseudo Code : create Find_Neighbor @ZoneID, @Direction as switch @direction case “North” : SELECT ZoneNorthID FROM tblZone WHERE ZoneID = @ZoneID case “South” : SELECT ZoneSouthID FROM tblZone WHERE ZoneID = @ZoneID … ...

More Related