1 / 5

Geographic Data Model Conventions for Road and Zone Management Systems

This document outlines the conventions for naming tables, queries, and stored procedures in a geographic data model. It specifies how to identify road segments based on direction, as well as the structure of zone data within the system. Key procedures like 'Find_Zone' and 'Find_Name' are defined to retrieve zone and location information. Additionally, a stored procedure for finding neighboring zones in specified directions is detailed. This is essential for developers working with geographic data management.

jacoba
Download Presentation

Geographic Data Model Conventions for Road and Zone Management Systems

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