Project Title: GIS
database for the United Arab Emirates University (UAEU)
·
Introduction
·
Objectives
·
Benefits of the project (Why the project is
important)
·
GIS
Database for UAEU
·
Multimedia
Database for UAEU
·
Hardware
·
Software
·
Expenses
·
Schedule
·
Examples
of output
·
Problems
·
Recommendation
·
References
Note: Each Group must select different Block e.g. Maqam 71 or Maqam 66
Key dates: Monday 9/4/2001 Preliminary Presentation
: Monday 18/5/2001 Final Presentation
: Final work must be submitted on CD-ROM by Monday 4/06/2001
Brief introduction about
UAEU (history, main faculties) and campuses:
· Islamic Institute
· Al-Maqam Campus
· Faculty of Medicine
· Jimi Campus
· Muwaiji Campus
· UAEU branches in Abu Dhabi, Marfa, Fujura, etc.
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)
Data needed for GIS
· Detailed Plans (maps) for the five UAEU branches
in Al-Ain
· Data will be scanned and exported to Arc/Info and ArcView
Attribute data (Statistical and descriptive information )about UAEU facilities will be keyed-in under MS Access and link to the spatial components (existing data can be integrated)
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
· Cost
of raw data (photos,
maps)
10,000
· Total man’s hours for the project = 300 hours
· One man’s hours cost = 100
· Total cost for man’s hours = 300 x 100= 30,000
· Total cost for data collection = 40,000
· For a person works 6 hours a day
and 5 days per week, the project need (300 hours/30 hours = 10 weeks). If two
persons, the project can be completed within 5 weeks
· Nature of work : scanning, digitisation, editing, data
entry
-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.
