Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.
2 Pages
2011_COS326_Prac5
Course: IT 101, Spring 2011School: University of South Africa
Rating:
Word Count: 333
Document Preview
of School Information Technology Department of Computer Science COS 326 Database Systems Practical 2: Geospatial databases Practical Date: 2 September 2011 (Friday) For additional help it is recommended that you read the following: PostGIS online manual, http://www.postgis.org/documentation/manual-1.5/. Read section 1, 4, 7 and 8. The Getting Started With PostGIS: An almost Idiot's Guide...
Unformatted Document Excerpt
Coursehero >> Other International >> University of South Africa >> IT 101Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
of School Information Technology Department of Computer Science COS 326 Database Systems Practical 2: Geospatial databases
Practical Date: 2 September 2011 (Friday) For additional help it is recommended that you read the following: PostGIS online manual, http://www.postgis.org/documentation/manual-1.5/. Read section 1, 4, 7 and 8. The Getting Started With PostGIS: An almost Idiot's Guide http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01 and http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut02.
This practical will count for marks!!
Pre-practical setup:
The data we will be using for this practical can be found on the can be found on the CS ftp site under Courses\COS 326\World.zip. The World.zip file contains the following shapefiles:
File Name
admin02.shp cities.shp continent.shp country.shp lakes.shp region.shp Rivers.shp
Description
The administrative boundaries represent the regions that together make up a country. The major cities of the world. All the continents. All the countries of the world. major The lakes of the world. Regions group a number of countries together. The major rivers of the world.
Create a spatial database in postgreSQL in the same manner as last week (Please refer to last week's practical if you cannot remember the process). Make sure you can execute spatial queries in SQL in pgAdmin Query Editor.
Questions:
Answer the following questions. For each answer, show the SQL statement that you used to obtain the answer. 1. Get the bounding box in JSON format of Madagascar. 2. How many cities are within a distance of 1000 km (distance will be measured in decimal degrees) of the Caspian Sea? 3. Within which county is the following coordinate -25.750, 28.167 (format: Latitude, Longitude) and what is the closest city to the coordinate? 4. What is the total perimeter of all the countries where the population information is not available (hint: if the information is not available the attribute value is -99999)? 5. What is the largest country that has a hole in the area (for example: South Africa has a hole where Lesotho is)?
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more.
Course Hero has millions of course specific materials providing students with the best way to expand
their education.
Below is a small sample set of documents:
Below is a small sample set of documents:
University of South Africa - IT - 101
School of Information Technology Department of Computer Science COS 326 Database Systems Tutorial 4Practical Date: 9 September 2011 (Friday)Setup:The data we will be using for this practical can be found on the can be found on the CS ftp site under Cou
University of South Africa - IT - 101
School of Information Technology Department of Computer Science COS 326 Database Systems Tutorial 5Practical Date: 16 September 2011 (Friday)Tasks:1. Create a new role group called university and academic_program. 2. Create the following new roles: adm
University of South Africa - IT - 101
School of Information Technology Department of Computer Science COS 326 Database Systems Practical 3Practical Date: 14 October 2011 (Friday)Tasks and Questions:Perform the following queries using SQL. Create the following 3 group roles: owner, manager,
University of South Africa - IT - 101
School of Information Technology Department of Computer Science COS326 Database Systems Tutorial 2Practical Date: 12 August 2011 (Fri)For additional SQL and PostgreSQL information:PostgreSQL Manual: http:/www.postgresql.org/docs/9.0/interactive/index.h
University of South Africa - IT - 101
School of Information Technology Department of Computer Science COS326 Database Systems Practical 1Practical Date: 19 August 2011 (Fri)This practical will count for marks!Create a new database in PostgreSQL, in the same manner as the last two week's tu
University of South Africa - IT - 101
Name:Student number:University of PretoriaC LASS TEST 1: 31 AUGUST 2011 C OURSE : Computer Science M EMORANDUM : COS326 E XAMINER : Prof MS Olivier T IME : 30 minutes M ARKS : 15T HIS PAPER CONSISTS OF 2 PAGES .Question 1The Object-oriented Database
University of South Africa - IT - 101
COS326 - Database Systems 2011 Study Guide Department of Computer Science School of Information Technology University of Pretoria1. Overview 1.1. Description. This module builds on a prior introductory module on database technology and provides more adva
University of South Africa - IT - 101
School of Information Technology Department of Computer Science COS326 Database Systems Tutorial 1Practical Date: 5 August 2011(Fri)Task 1:For this tutorial we will be working with PostgreSQL. It is already installed on the computers in the Information
Cogswell Poly - MAT - 101
COMP 211 DATA AND SYSTEM MODELING (PROB/STAT) Spring 2012 Assignment #1 Due: 12pm, Wednesday, 2/29/2012 Total points: 200 (each question 10 points) Please submit a softcopy (in PDF format) of your assignment to WebCT before the deadline. Late penalty: wit
USF - GEOL - 233
Geomechanics Week 2: Soils & Clays1.Weathering, genesis of soil clays 2.Clay mineralogy 3.Soil colloid properties and the diffuse double layer 4.Engineering applicationsWhat is soil?Soil is the outer layer of the earth's crust capable of supporting pla
USF - GEOL - 233
Geomechanics Week 2: Soils & Clays1.Weathering, genesis of soil clays 2.Clay mineralogy 3.Soil colloid properties and the diffuse double layer 4.Engineering applicationsWhat is soil?Soil is the outer layer of the earth's crust capable of supporting pla
USF - GEOL - 233
Geomechanics Week 2: Soils & Clays1.Weathering, genesis of soil clays 2.Clay mineralogy 3.Soil colloid properties and the diffuse double layer 4.Engineering applicationsWhat is soil?Soil is the outer layer of the earth's crust capable of supporting pla
USF - GEOL - 233
Geomechanics Week 2: Soils & Clays1.Weathering, genesis of soil clays 2.Clay mineralogy 3.Soil colloid properties and the diffuse double layer 4.Engineering applicationsWhat is soil?Soil is the outer layer of the earth's crust capable of supporting pla
USF - GEOL - 233
Geomechanics Week 2: Soils & Clays1.Weathering, genesis of soil clays 2.Clay mineralogy 3.Soil colloid properties and the diffuse double layer 4.Engineering applicationsWhat is soil?Soil is the outer layer of the earth's crust capable of supporting pla
USF - GEOL - 233
GLY4930: Geomechanics Homework 1 Solutions1. A soil is collected from below the water table in a split-core sampler with an undisturbed volume of 110 cm3. The wet soil has a mass of 212 g. When ovendried, the mass is 162 g. From this information, determi
USF - GEOL - 233
GLY 4930/5932: Geomechanics1. Introductions: Who am I? Who are you? 2. Syllabus. 3. What is Geomechanics? 5. Applications of Geomechanics to: Engineering (Civil, Mining), Natural Hazards, Seismology, Volcanology, Structural GeologyGLY 4930/5932: What is
USF - GEOL - 233
GLY 4930/5932: Geomechanics1. Introductions: Who am I? Who are you? 2. Syllabus. 3. What is Geomechanics? 5. Applications of Geomechanics to: Engineering (Civil, Mining), Natural Hazards, Seismology, Volcanology, Structural GeologyGLY 4930/5932: What is
USF - GEOL - 233
Compaction ObjectivesCompaction Many types of earth construction, such as dams, retaining walls, highways, and airport, require man-placed soil, or fill. To compact a soil, that is, to place it in a dense state. The dense state is achieved through the r
USF - GEOL - 233
GLY 4930/5932: Geomechanics1. Introductions: Who am I? Who are you? 2. Syllabus. 3. What is Geomechanics? 5. Applications of Geomechanics to: Engineering (Civil, Mining), Natural Hazards, Seismology, Volcanology, Structural GeologyGLY 4930/5932: What is
USF - GEOL - 233
BSC 3022 Quiz #1 Key Fall 2011 The average on Quiz #1 was a 74%. Please review the answers for this quiz and all future quizzes carefully. If you have any questions, please visit me ASAP. You WILL see this content again! 1. Which of the following is an ex
USF - GEOL - 233
Right to Health Care- Policy PaperKanchan SujananiCritical Issues in Public Health September 26, 2010Kanchan Sujanani HSC4631 26, September, 2010 The Right to Health Care We here at the Americans for Free Choice in Medicine (AFCM) believe strongly that
USF - GEOL - 233
Right to Health Care- Policy PaperKanchan SujananiCritical Issues in Public Health September 26, 2010Kanchan Sujanani HSC4631 26, September, 2010 The Right to Health Care We here at the Americans for Free Choice in Medicine (AFCM) believe strongly that
USF - GEOL - 233
Right to Health Care- Policy PaperKanchan SujananiCritical Issues in Public Health September 26, 2010Kanchan Sujanani HSC4631 26, September, 2010 The Right to Health Care We here at the Americans for Free Choice in Medicine (AFCM) believe strongly that
USF - GEOL - 233
POP Settings for Windows Live MailThese settings will allow you to access your Windows Live Mail from most mail clients (Outlook, Outlook Express, Eudora, Thunderbird, etc.) and some web mail services such as Gmail. Unfortunately, these settings will not
USF - GEOL - 233
ScheduleClass Week Assigned Reading Assignments and Notes Course Introduction MP Chapter 1 Quiz due 11pm September 2 MP Chapter 2 Quiz due 11pm September 2 MP Chapter 3 Quiz due 11pm September 2 Class Activity: "Should Puerto Rico Become a State?" Septem
USF - GEOL - 233
ScheduleClass Week Assigned Reading Assignments and Notes Course Introduction MP Chapter 1 Quiz due 11pm September 2 MP Chapter 2 Quiz due 11pm September 2 MP Chapter 3 Quiz due 11pm September 2 Class Activity: "Should Puerto Rico Become a State?" Septem
USF - GEOL - 233
SyllabusPOS 4622 Politics and Civil Rights Dr. Terri Susan Fine Fall 2011Section 0001Location CL 1 318Day and Time M 6-8:50pmCredit Hours 3Instructor Contact:Instructor Dr. Terri Susan FineProfessor of Political Science Associate Director, Lou Fre
USF - GEOL - 233
POS 4622 Politics and Civil Rights Reparations DebateQuestion: Should the descendants of African slaves be entitled to reparations?Three possible responses:1. Yes 2. No 3. Yes; descendants of African slaves are entitled to reparations in the amount of
USF - GEOL - 233
1POS4622 Politics and Civil Rights Research Paper #2"Strategizing for the Future" Dr. Fine November 14, 2011 The purpose of this second paper is to identify and research a current civil rights problem, and develop a means to address it. The final product
USF - GEOL - 233
POS 4622 Politics and Civil Rights Paper #1: "What are the privileges and opportunities of citizenship?" Dr. Fine This first research paper asks that you consider the question: "What are the privileges and opportunities of citizenship? " As the privileges
USF - GEOL - 33
POS 4622 Politics and Civil Rights Film Analysis Due November 18 11pm via Webcourses Civil rights issues and various components of the civil rights movement have been depicted through film. In this exercise, you will view a film focusing on some aspect of
USF - GEOL - 33
3Student: _Multiple Choice Questions1.The simplest structure shared among all living organisms is the A. B. C. D. E. gut. cell. photosynthetic chloroplast. community. nucleus.2.Which of the following is likely NOT a common feature shared among all l
USF - GEOL - 33
HFT 2401: Quiz 1 (30 minutes) Bring the question sheet to class for reviews. Name: _ Read the instruction and questions carefully and put your answers on the answer sheet provided. I. A list of account titles is provided in the answer sheet. Indicate whic
USF - GEOL - 33
22Student: _1.The most ancient type of organisms on Earth originated: A. 7,200 years agoB. 2 million years agoC. 4,004 years agoD. 3.5 billion years agoE. 13 billion years ago2.Because they differ from all other living organisms by lacking a discret
USF - GEOL - 33
HFT 2401: Quiz #2 Recording Procedure with Adjustment Fall 20111.To which category of the following, does Depreciation accountbelongs? 1) Assets 2) Liabilities 3) Equity 4) Revenues 5) Expenses2.To which category of the following, does Accumulated Dep
USF - GEOL - 33
Asian PoliticsDr. Annie G. Dandavati POL 303, 4 credits Tuesday/Thursday: 9:30-10:50 Office Phone: 395-7984 Miller 249 Fall 2011 This course will focus on the following themes: 1. The cultural legacies of India and China and the fusion and intermingling
USF - GEOL - 33
Lab #2Introduction to rocks and plate tectonicsFine fractionCoarse fractionLab #2Introduction to rocks and plate tectonics Excellent sorting [sand sized grains]Lab #2Introduction to rocks and plate tectonics Good sorting [clay/mud sized grains]How
USF - GEOL - 33
The Cullowhee Formation is an interesting part of the Blue Mountains. The Formation is made mostly of gneiss and although a lot of research has been done on the area and surrounding formations researchers cannot agree on how to classify it. Some believe t
USF - GEOL - 33
The Cullowhee Formation is an interesting part of the Blue Mountains. The Formation is made mostly of gneiss and although a lot of research has been done on the area and surrounding formations researchers cannot agree on how to classify it. Some believe t
USF - GEOL - 33
Brian Szenay Dr. Ryan Geocomm. & Dissemination 01/24/12 Introduction of Project Paper Sinkhole legislation, especially in Florida, has become an increasingly talked-about and important topic. Every day, environmental consulting companies are doing tests t
USF - GEOL - 33
Sierra Fortune The transportation of sediment is an important aspect in understanding the complex processes that form our coasts. The geology of Florida's coastline is particularly interesting. The mainland of Florida is primarily dominated by silica-base
USF - GEOL - 33
Sierra Fortune The transportation of sediment is an important aspect in understanding the complex processes that form our coasts. The geology of Florida's coastline is particularly interesting. The mainland of Florida is primarily dominated by silica-base
USF - GEOL - 33
Tayler Lacey The San Jacinto Fault is part of the more well known San Andreas Fault System. It is located in Southern California and branches from the Transverse Range in a southeastern direction towards the Salton Trough running northwest to southeast. T
USF - GEOL - 33
Tayler Lacey The San Jacinto Fault is part of the more well known San Andreas Fault System. It is located in Southern California and branches from the Transverse Range in a southeastern direction towards the Salton Trough running northwest to southeast. T
USF - GEOL - 33
INTRODUCTION Cenozoic marine fossils have been collected and documented from numerous formations throughout the Caribbean region; however, the Tertiary fauna of Vieques remain largely unexplored. Within the past 3-5 million years there has been a noticeab
USF - GEOL - 33
INTRODUCTION Cenozoic marine fossils have been collected and documented from numerous formations throughout the Caribbean region; however, the Tertiary fauna of Vieques remain largely unexplored. Within the past 3-5 million years there has been a noticeab
USF - GEOL - 33
Nicholas Pieri Introduction The Moab fault is a normal fault that runs 45 km exposing Permian units of the Paradox Basin by up to 960 m (3150 ft) of vertical stratigraphic offset (Doelling, 1988; Foxford et al.,1996, 1998). The area most focused on by geo
USF - GEOL - 33
Nicholas Pieri Introduction The Moab fault is a normal fault that runs 45 km exposing Permian units of the Paradox Basin by up to 960 m (3150 ft) of vertical stratigraphic offset (Doelling, 1988; Foxford et al.,1996, 1998). The area most focused on by geo
USF - GEOL - 33
Sarah Seabrook In Indonesia there exists an area where one can monitor coral reef biodiversity in ways unlike anywhere else in the world. This place is Hoga Island in Wakatobi, South East Sulawesi. Hoga Island is surrounded by a triangle of coral reef sys
USF - GEOL - 33
Sarah Seabrook In Indonesia there exists an area where one can monitor coral reef biodiversity in ways unlike anywhere else in the world. This place is Hoga Island in Wakatobi, South East Sulawesi. Hoga Island is surrounded by a triangle of coral reef sys
USF - GEOL - 33
Daphanee Waters Introduction A lot of times natural attenuation monitoring (NAM) is initiated at a site without a geochemical evaluation of an aquifer. As a result, a site could be in NAM for years and could be very costly for clients. This paper will loo
Ryerson - MARKETING - 101
Chapter 3 review quiz Section 1 Company codes of ethics are stated in ways: Leave interpretation in a specific situation up to the manager Section 2 The most common situation in which otherwise ethical marketing executives suffer a lapse of ethics is: Sec
Ryerson - MARKETING - 101
Section 1 Codes of Ethics - The code can help by either challenging or bolstering an executive's belief that the stand he or she is taking is ethical and socially responsible. - Emphasizes honestly and truthfulness in communicating with customers, and avo
Ryerson - MARKETING - 101
Chapter 2 Review Quiz Market Share is measured: Globally, by country, by region of a country, by segment of users Market Share is measured: Company sale in dollars $ divided by total industry sales over a specific period of time x 100% Voice Share is: dol
Ryerson - MARKETING - 101
Chapter 2 Market Orientation Competitive Dynamics The organization that is market oriented (gathers good market intelligence, analyzes it, disseminates, learns from it and then responds to the intelligence) is competitively successful. Analyzing Competiti
Ryerson - MARKETING - 101
What is Marketing?Marketing is not about developing excellence in creating advertising and promotions that claim the superiority of unproven or non-existent quality and performance. It is new inventions in trading that increases product quality, reduce p
Cornell - ECON - ECON 101
4.3 VocabularyElasticity-a measure of responsiveness that tells us how a dependent variable such as quantity responds to change in an independent variable such as quantity responds to change in an independent variable such as price Demand Elasticity-the
Cornell - ECON - ECON 101
Vocabulary: Laissez-faire-the philosophy that government should not interfere with commerce or trade Market structure-the nature and degree of competition among firms operating in the same industry Perfect competition-characterized by a large number of we
Cornell - ECON - ECON 101
1. Closed Shopsthe most restrictive arrangement where the employer agrees to hire only union members. This allows the union to determine who is hired by giving or denying a person union membership Union Shopsan employment situation where workers do not ha
University of Macau - ELEC - 232
ELEC 352FFT Lab Experiments Experiment 3&4 ReportDepartment: FST Major: EEE Name: TENG CHENG (DA928240) LEONG MAN PIO(DA927978)Experiment#3Objective This experiment demonstrates the use of the FFT for analyzing the spectral content of a square wave an
University of Macau - ELEC - 232
ELEC 381-11 No. Student No. 1 D-A7-2797-1 2 D-A8-2817-8 3 D-A8-2890-7 4 D-A9-2709-8 5 D-A9-2725-4 6 D-A9-2727-3 7 D-A9-2736-7 8 D-A9-2737-3 9 D-A9-2748-3 10 D-A9-2749-9 11 D-A9-2765-5 12 D-A9-2779-3 13 D-A9-2781-1 14 D-A9-2782-7 15 D-A9-2797-8 16 D-A9-279