GIS -515

GIS Applications in Urban Planning:

Two Hours Lecture, Two Credit Hours

PREREQUISTS:                     None.

TEXTBOOK:                           Handouts will be given to students on

                                                    weekly basis.

REFERENCE BOOKS:          None specific. (Updated Web sources will be used)

COURSE OBJECTIVES:

This course is designed mainly for graduate students who have had some background in the general aspects of GIS. The course will focus on GIS projects, while assisting students in evaluating the utility of this technology. The course will be based on “Problem – Based Learning” and each problem will be discussed in task – based studio workshops. Environmental assessment related to Urban Planning aspects, data visualization, resource management, etc., will be presented to students in those mentioned task – based workshop sessions. Completion of each task will allow students to distinguish between GIS applications in urban planning and other disciplines. This will also allow students to develop a final report, which will cover the various aspects of “GIS Applications in Urban Planning” in detail.

http://www.agi.org.uk

 http://www-nmd.usgs.gov/www/gnis

 http://info.er.usgs.gov/research/gis/title.html

 http://www.esri.com/

 http://www.geo.ed.ac.uk/agidict/welcome.html

 http://www.gis.iastate.edu

 http://www.ai-geostats.org

GIS System Integration

YARIYIL ÖDEVİ

1. Bölüm

• 1.1. CAD  nedir?
• 1.2. GIS nedir?
• 1.3. Bu kavramlar arasındaki ilişki ve farklar nelerdir?

2. Bölüm

• 2.1. Veritabanı nedir?
• 2.2. Warehouse nedir?
• 2.3. Geoworkspace nedir?
• 2.4. Map Window nedir?
• 2.5. Data Window nedir?
• 2.6. Feature Class nedir?

3. Bölüm

• 3.1. Grafik Veri nedir
• 3.2. Nongrafik Veri nedir?
• 3.3. Raster nedir?
• 3.4. Vektör nedir?

Raporlar ilan edilmiş sınav tarihinden önce "Word" veya "Acrobat" dosyası halinde mailto:[email protected]   adresine "e-mail" yolu ile ulaştırılacaktır.

COURSE OUTLINE:

WEEK 1,2,3,

Interactive relations between different program packages (Understanding interactive usage of program packages in a computer integrated  environment, understanding computers as an extension of the mind etc.,)

"Coğrafi Bilgi Sistemleri - Bilişim Günleri"

 Coğrafi Bilgi sistemleri - Emniyet Teşkilatı

Coğrafi Bilgi Sistemleri - Alfabim

Makaleler

Coğrafi Bilgi Sistemleri - Boğaziçi Üniv.

WEEK 5,6,7,8                       

Simplified GIS Database Structures. (Transferring data to several database program packages, attribute extraction, adding further records to database, changing information in the database, sorting, indexing, producing reports, basic concepts about GIS related database programming etc.,)

WEEK 9                                

Mid – Term Examination.

SQL Course - Interactive Online SQL Training for Beginners

SQL Tutorial - SQL reference and programming examples

A Gentle Introduction to SQL

Introduction to Structured Query Language

SQL KULLANIMI İÇİN ÖRNEK SORU

 ABD SINIRLARI İÇİNDE:

(USA)

DAĞLIK ...

(TIFF)

NÜFUSU 25.000 DEN BÜYÜK...

(POP)

YILLIK KAR YAĞIŞ MİKTARI 85 KG’DAN FAZLA...

(ANNUAL SNOW)

SUÇ ORANI 70 DEN AZ...

(TOTAL CRIME)

OTOBANLARA 10 KM DEN DAHA YAKIN...

(INTERSTATES)

BİR NEHİRE 20 KM DEN DAHA YAKIN...

(RIVERS)

BİR BELDE BULUN...

(COUNTIES)

WEEK 10,11,12                    

Accessing other programs from a GIS package, using third party software, custom tailoring. Workshopsessions on Final reports.

WEEK 13                              

General discussion on final reports.

WEEK 14                                          

Mid – Term Examination.

GRADING:

Two Mid Term axaminations will be averaged and affect the grade by 50 %. Final exam will be the 50 % of the resulting grade.