Project Title: GIS
database for the United Arab Emirates University (UAEU)
Brief introduction about
UAEU (history, main faculties) and campuses:
Objectives
-To develop a GIS-multimedia database for UAEU facilities (number of offices, Lecture Theatres, Facilities, staff, Services available, etc.)
-To use the GIS database for space inventory, monitoring, and decision
making
- To analyze the facilities’ database with respect to the urban environment
(distribution, ratio to staff/students, accessibility)
-Proper management of the University's resources. For example avoiding of duplication of efforts in terms of buying data, hardware and software. Such management may lead to cost reduction
-The UAEU development
staff may use the system to simulate/allocate new facilities and allow the
administration to give their views and comments via the internet on the
location of new facilities
-The UAEU
staff/students may use the system to retrieve detail information about any
facility in the campus
-Tables, Graphs, maps can be viewed simultaneously for analysis and comparison
- The project is a multidisciplinary, integrated, and holistic
Data needed for GIS
Built-up
area: Faculties (Polygons)
•Total area/built-up
area, Number of blocks
•Block information:
(Name or number, Number of levels, height, area, Number of offices and lecture
theatres)
•Number of restaurants,
Studios, Labs, Toilets
•Office information
•Lecture Theatres
information
Office information (Polygons)
Fields that must be included in the database
–Area (width x length )
–Identification number
(e.g.MQ 71-14)
–Number of Occupant
(one person, 2,3, etc.)
–Number of chairs/Sofa
–Number of tables
–Number of computers
(printers, scanners)
–Number of cabinets
–Number of lamps (Status, average
monthly consumption)
–Number of Air
conditions (Status, average monthly consumption)
–Curtain (status:Good,
need to be changed)
–Door/Windows status
(Good, need repair)
–Telephone number (link to the operator system)
Lecture Theatres information (Polygons)
Fields that must be included in the database
–Area (width x length )
–Identification number
(e.g. MQ66-104)
–Capacity (number
chairs/desks)
–Number of lamps (Status (2 not
functioning, average monthly consumption)
–Number of Air
conditions (Status , average monthly consumption)
–Curtain (status:Good,
need to be changed)
–Door/Windows status
(Good, need repair)
–Lecturer Desk/Table
(Yes, No, need repair)
–White Board status
(Good, need repair)
–Over Head Projector
(OHP) (Yes, No)
–Smart room (Yes, No: Computer + LCD projector)
Laboratories (Polygon)
–Name
–Area
–Equipment (e.g. chemical testing instruments)
–Computers (number)
–Accessories (number of printers, scanners, plotters)
–Number of technician
–Number of lamps
–Number of Air conditions (AC)/status (good/No)
Libraries (Polygon)
Fields that must be included in the database
–Name e.g. Zayed Central library
–Location
–Total Area/surrounding- built-up area
–Number of levels
–Number of tables
–Number of Chairs
-Total volume collection (classification: Books/ journals/ CDs)
–Number of lamps (average monthly consumption)
–Number of Air conditions (average monthly consumption), Status (15 functioning, 2 Not)
–Capacity of parking area (number of cars)
–Total number of Bibliographic collection
–Number of staff
–Link to library Information System
Built-up area: Hostels (Polygons)
Fields that must be included in the database
–Name of the hostel
(e.g. Markhaniya Girls’/Men’s)
–Address for each hostel
(Location e.g. Khalifa Street)
–Starting and ending
date of construction
–Total area/built-up
area, Number of blocks
–Number of rooms,
room’s capacity (2 beds), available beds (1 bed), available furniture
(mattress, pillows, reading desks/tables, chairs, cabinets, mirror)
–Number of (restaurants, prayers’ room, TVs, Cyber Café, reading rooms)
Restaurants (Polygon)
Fields that must be included in the
database
–Name
–Name/Address of company running the restaurant
–Area
–Capacity
–Number of table
–Number of chairs
–Number of air conditions/type (average
monthly consumption)
–Number of lamps (average monthly consumption)
–Number of gas cooker (average monthly)
–Kitchen condition (health measures , Clean/Not clean)
–Safety measures (number of fire alarms and status)
–Number of workers
–Average Total volume of monthly consumption (Sugar, bread, tea, coffee, milk, onion, oil, etc.)
Population database
•Staff (Faculty-based): Link to the staff’s information system
•Students: (Female/ Male), total: Link to the students’ information system-Admission and Registration
•Employees (number): Link to the Employees’ information system
•All the above links are made through “Password access”
•The linkage is a good example for coordination in order to avoid duplication of efforts, therefore, reducing cost
•Example of data structure is shown below (calculate ratio between staff/students/employee)
|
Faculty
|
staff
|
Employees
|
Male students |
Female students
|
Total students
|
|
Law |
50 |
20 |
20 |
40 |
60 |
Hardware : The hardware used in this project include:
•PC: Intel Pentium III 1000 MHz, Memory (RAM): 512 MB, 20 GB HD, 40X CDROM, built-in Iomega ZIP drive (100 MB) and CD-writer (Operating System: Windows 2000)
•Printer: HP DeskJet1120C (A3 size printer)
•Scanner: HP ScanJet
5200C
•Plotter: HP DesignJet
1050C colour (40 MB RAM, 1200 dpi)
•Digital Camera
Software: The software used in this project include:
- MS PhotoEditor (for scanning)
- Arc/INFO 3.5 (for topology building)
- ArcView (for on screen digitization and display)
- MS Access (for database entry)
•Data Collection(photos, scanning, digitization) 40,000 *
•Multimedia storage
(CDs, Zips)
05,000
•Printing cartridge
03,000
•Printing papers 02,000
•Digital Camera 01,400
•Printer 05,000
•Plotter 20,000
•Scanner 05,000
Total ?
*Note: Data costing
-Coordination and exchange of information within the UAEU
-Proper management of the University's resources. For example avoiding of duplication of efforts in terms of buying data, hardware and software. Such management may lead to cost reduction
-Historically, the UAEU is the first University in the UAE and it is anticipated that the university must lead and become the pioneer in new areas such as IT and GIS
-The potential
beneficiaries of the system are the UAEU Development/Planning staff, staff,
students, as well as the public
-The UAEU development
staff may use the system to simulate/allocate new facilities and allow the
administration to give their views and comments via the internet on the
location of new facilities
-The UAEU development
staff may use the system to monitor
maintenance, renovation, or rehabilitation program
-The UAEU
staff/students may use the system to retrieve detail information about any
facility in the campus
-Tables, Graphs, maps can be viewed simultaneously for analysis and comparison
- The project is a multidisciplinary, integrated, and holistic
•Time minimization
•Labor reduction
•Accuracy improvement
•Increases efficiency
•Improves customer services
•High cost/benefit ratio
References: Students must add more references and web sites relevant to the project
ArcUser, 2000. Learning with
GIS. The Magazine for ESRI Software Users. 3(3)10-13.