200 likes | 415 Views
Geographic information system. Rıfat Ordulu. What is geographic information system?. Wherever a geographic information is manipulated, integrated, stored, edited, analyzed, shared and displayed, we are talking about GIS (geographic information system)
E N D
Geographic information system RıfatOrdulu
What is geographic information system? • Wherever a geographic information is manipulated, integrated, stored, edited, analyzed, shared and displayed, we are talking about GIS (geographic information system) • Data representation: roads, land use, elevation, trees, waterways, etc.
Types of objects • Discrete objects: houses, trees, etc. • Continues objects: rainfall amount, elevation.
Methods to store data • Raster images • Vector • Point clouds
Raster Method • Bitmap technology (as we already now) • Pixel by pixel values • Special data to the pixels (temperature)
Vector Method • Points, Lines, Polygons • All of them are linked to a row in db • Example; storage of a house • House’s population • Height • Price • ….
How to keep records? • Flat files and spreadsheets • Hierarchical files • Relational files
Flat Files and Spreadsheets • Simplest method for storing data • Expanding the number of fields is a problem • May require reprogramming • Insert operation is time consuming if number of fields is high • No flexibility
Hierarchical Files • Parent-child, one-to-many relationship • One field is key to all records • Associates the records with similar attributes • If relationships clearly defined and if we have standardized queries, we will come up efficient results • Must access the master record in order to go downwards
Relational Files • Connects records without a key or a pointer • Matrices of tables • Tables having common link • Flexible • Most popular for GIS • Close to SQL
Representing Relationships • Spatial Relationships • Relative location, direction and movement from place to place, etc. • Functional Relationships • Road network, house ownership etc. • Logical Relationships • No land may be permitted to be zoned for residential use if it is within rivers three-year flood plain • If-then, and-or logic.
Topological Relationships • Most useful in spatial databases • Determines how and where points and lines connect • Usage example; to find optional routes for emergency vehicles
How connections are stored • First; location of all nodes • Second; defining arcs (from node to node with direction) • Third; defining polygons using arcs
Object-Oriented Databases • Grouping the attributes of an object into sub objects • For example; instead of using points, you divide it into house, office, resident, forest etc. • Big work load, but well organized
E-R • E-R is the most important term when building a GIS database • We have many entities and relations in GIS databases • For example; a house may be related to an owner, related to a place, related to a person who lives in there, related to a type of house etc.
References • Database Concepts, Kenneth E.Foote and Donald J.Huebner, Department of Geography, University of Texas at Austin, 1996. • GIS Database Development and Exchange: Interaction Mechanisms and MotivationsZoricaNedovic-Budic, Jeffrey K. Pinto, and Lisa Warnecke • Relational Database Management Systems,Database Design, and GIS. Tim Haithcoat ,University of Missouri,Columbia • A GIS DATABASE DESIGN FOR URBAN POVERTYMANAGEMENT, Felicia Olufunmilayo AKINYEMI, Nigeria • UPDATED GIS DATABASE DESIGN:Geodatabase ModelPrepared by:Michael Baker Jr., Inc.Virginia Beach, Virgini