MIT OpenCourseWare

相关阅读资料


本页翻译进度

灯号说明

审定:无
翻译:叶秋芸(简介并寄信)
编辑:吴嘉哲(简介并寄信)

课程单元 阅读资料
第一堂
Lecture 1

11.208 和主题图表导论
Introduction To 11.208 And Thematic Mapping

制作和打印主题图表
Producing and printing thematic maps

Hutchinson, Scott 与 Larry Daniel. 《Arcview GIS之内幕》第一章:〈Arcview导论〉和第三章:〈开始的第一步:计划和观点〉. Albany, NY: OnWord Press, 2000.
Hutchinson, Scott and Larry Daniel. Inside ArcView GIS. Albany, NY: OnWord Press, 2000. (read Chapter 1: "Introducing ArcView" and Chapter 3: "Getting Started: Projects and Views")

Monmonier, Mark S. 〈图表的元素〉于《如何利用图表说谎》第二章, Chicago, IL: University of Chicago Press, 1991.
Monmonier, Mark S. How to Lie with Maps. Chicago, IL: University of Chicago Press, 1991. (read "Elements of the Map" and Chapter 2)

Bossard, Earl G. 与 Haiyan Zhang. 〈将个人计算机软件做为空间分析的架构〉于《都市及区域资讯系统协会1993年年度会议公报》第三期 (1993): 38-47.
Bossard, Earl G. and Haiyan Zhang. "Loosely Coupled PC Programs as a Framework for Spatial Analysis." URISA 1993 Annual Conference Proccedings 3 (1993): 38-47.

实作A
Lab A
以资料表和国界文件建立和打印一个简单的图表
Building and printing a simple map from database tables and boundary files
第二堂
Lecture 2

犯罪个案研究和基本数据库管理
Crime Case Study and Elementary Database Management

分析图表的个案研究
Case study in analytic mapping

将资料输入数据库(资料汇入、输入)
Getting data into a database (data import, entry)

数据库的查询(选择栏位和记录、简单总计)
Simple queries on a database (selecting fields and records, simple aggregation)

将资料汇出数据库(资料汇出)
Getting data out of the database (data export)

Ferreira, J. 〈经济犯罪的空间模式和社会经济的特性〉 (1986).
Ferreira, J. "Spatial Patterns of Property Crimes and Socio-Economic Characteristics." (1986).

Lewis, S. 〈资料、计算机和规划人员〉
Lewis, S. "Data, Computers and Planners."

Ferreira, J. 〈规划的数据库管理工具〉于《美国规划协会期刊》第56期,第1号 (1990): 78-84.
Ferreira, J. "Database Management Tools for Planning." Journal of the American Planning Association 56, no. 1 (1990): 78-84.

微软MSQuery使用手册:导论与节录
MSQuery Manual: Introduction and Excerpts

实作B
Lab B
数据库基本作业:资料输入、简单查询、输出
Essential database operations: data input, simple queries, output.
第三堂
Lecture 3

人口统计普查的意义,第一部分
Making Sense Of The Census, Part I

1990 年人口及住宅普查
The 1990 Census of Population and Housing

撷取人口普查资料的工具
Tools to extract census data

使用人口普查资料:标准化、以时序进行比较
Using census data: normalization, comparisons over time

美国人口普查局,〈1990 年人口普查结果导论〉
U.S. Census Bureau. "Introduction to 1990 Census Products."

美国人口普查局,〈90年人口普查的基本资料〉
U.S. Census Bureau. "Census '90 Basics."

第四堂
Lecture 4

关联化数据库导论,第一部份
Introduction To Relational Databases, Part I

关联化模型导论
Introduction to the relational model

中阶查询:统计功能 (分类)、多资料表查询
Intermediate queries: aggregation functions (grouping), multi-table queries

Trimble, J. Harvey 与 David Chappell. 《结构性查询语言导论》第一章〈结构性查询语言图示导论〉第74-104页、124-137页, New York, NY: John Wiley & Sons, 1989. ISBN: 0471616842.
Trimble, J. Harvey and David Chappell. Introducing SQL. New York, NY: John Wiley & Sons, 1989. ISBN: 0471616842. (read Chapter 1, pp. 74-104, 124-137 of A Visual Introduction to SQL)
实作C
Lab C
以调查资料和城市管理记录建立和执行查询作业
Build and run queries on survey data and urban management records
第五堂
Lecture 5

人口普查资料之解释,第二部分
Making Sense Of The Census, Part II

1990 年人口及住宅普查
The 1990 Census of Population and Housing

  • 撷取人口普查资料的工具
    Tools to extract census data
  • 使用人口普查资料:标准化、以时序进行比较
    Using census data: normalization, comparisons over time
Hutchinson 与 Daniel,第六章:〈资料查询〉和第 78-81页(〈结合资料表〉、〈结合相对于联结〉)
Hutchinson and Daniel, Chapter 6: "Data Queries," and pp. 78-81 ("Joining Tables," "Joining vs. Link")
实作D
Lab D
从STF 文件撷取人口普查资料
Extracting Census data from STF files
第六堂
Lecture 6

关联化数据库的原则 ,第二部分
Principles Of Relational Databases, Part II

上课前一日派发问题集
Problem Set handed out prior day.

数据库设计的元素
Elements of database design

包含资料表中的“一对多”关联化模型资料
The relational model of data including "One-to-many" relationships among data tables

结构性查询语言(SQL)导论
Introduction to Structured Query Language (SQL)

第七堂
Lecture 7

数据库管理规划
Database Management In Planning

有关目前和未来的数据库管理规划总览
An overview of planning uses of database management, both now and in the future.

实作E
Lab E
计算机教室课,主题为应用关联化模型之人口统计资料
Lab session emphasizing Census data and applying the relational model
第八堂
Lecture 8

准备有效的图表
Preparing Effective Maps

准备准确、清晰、有说服力沟通方式的图表之小技巧
Tips on preparing maps that communicate accurately, clearly, and persuasively

Hutchinson 与 Daniel 第五章:〈展示资料〉
Hutchinson and Daniel, Chapter 5: "Displaying Data."

Wood, D. 〈图表引导社会至错误的方向?〉 (1993).
Wood, D. "Are Maps Sending Society in the Wrong Direction?" (1993).

Monmonier, M,《如何利用图表说谎》的第九章:〈资料地图:利用调查胡扯〉
Monmonier, M. "Data Maps: Making Nonsense of the Census." Chapter 9 of How to Lie with Maps.

实作F
Lab F
提高图表的准确性、清晰度及说服力
Enhancing the accuracy, clarity and persuasiveness of the map
第九堂
Lecture 9

空间分析及网际网络概论
Spatial Analysis And Internet Overview

介绍网际网络和GIS的图表资源
Introduction to Internet and GIS mapping resources

网络的图表资源
Web mapping resources

NCGIA核心课程:NCGIA Core Curriculum in GISci
The NCGIA Core Curriculum: NCGIA Core Curriculum in GISci

Marble, D. 〈地理资讯系统对研究方法的可能冲击〉 (1990).
Marble, D. "The Potential Methodological Impact of Geographical Information Systems." (1990).

Levine J., 与 Landis, J. 〈针对当地规划的地理资讯系统〉于《美国规划协会期刊》 (1989年春季): 209-220.
Levine J., and Landis, J. "Geographic Information Systems for Local Planning." Journal of the American Planning Association (Spring 1989): 209-220.

实作G
Lab G
整合人口普查数据和标准图表
Integrating orthophotos with census data
专题展示
Project Demo

规划软件和PSS研究图表和空间分析的软件工具研究示范展示
Exhibition Of Planning Software And PSS Research Demonstrations of software tools for mapping and spatial analysis

第十堂
Lecture 10

课程总结
Course Summary

地理资料系统和课程总结导论
Introduction to geographical information systems and course summary

Panel Discussion

Drucker, P.F. 〈资料的认知:了解您应该知道的资料〉于《华尔街期刊》,1992年12月1日。
Drucker, P.F. "Drucker on Management: Be Data Literate -- Know What to Know." Wall Street Journal, December 1, 1992.

Harris, B. 〈地理资料系统之外的事:计算机和规划的专业人才〉于《美国规划协会期刊》 (1989): 55, 85-90.
Harris, B. "Beyond Geographic Information Systems: Computers and the Planning Professional." Journal of the American Planning Association (1989): 55, 85-90.

Zuboff, S. 〈企业的资料化:二十一世纪的主要议程〉于《国际论坛》 (1991).
Zuboff, S. "Informate the Enterprise: an Agenda for the 21st Century." National Forum (1991).