Making Choices about Geospatial Database Development

1. Making Choices about Geospatial Database Development Dr. Ahmad BinTouq E-mail: abintouq@uaeu.ac.ae URL: http://faculty.uaeu.ac.ae/~abintouq GEO 440: GIS for Urban & Regional Planning

2. Making Choices about Geospatial Database Development • Data, Information, Evidence, and Knowledge: A Comparison • Data Models: The Core of GIS Data Management • Conceptual Data Models • Logical Data Models • Physical Data Models • Database Design Activity for Green County Functional Planning • Conceptual Design of a Database Model • Logical Design of a Database Model • Physical Design of a Database Model

3. Data, Information, Evidence, and Knowledge: A Comparison • Data—are raw observations (e.g., a measurement) of some reality, whether past, current, or future, in a shared understanding of an organizational context. • Information—is data placed in a context for use that has meaning about a world we share. • Evidence—is information that makes sense (perhaps corroborated); hence, it is something we can use to make reasoned thought (argument) about the world. • Knowledge—is an assemblage of synthesizing, enduring, credible, and corroborated evidence.

4. Data Models: The Core of GIS Data Management • 5.2.1 Conceptual Data Models

5. Data Models: The Core of GIS Data Management • 5.2.1 Conceptual Data Models

6. 5.2.2 Logical Data Models

7. 5.2.2 Logical Data Models

8. 5.2.3 Physical Data Models

9. Database Design Activity for Green County Functional Planning

10. 5.3.1 Conceptual Design of a Database Model

11. 5.3.1 Conceptual Design of a Database Model

12. 5.3.1 Conceptual Design of a Database Model

13. 5.3.1 Conceptual Design of a Database Model

14. 5.3.2 Logical Design of a Database Model • Define attribute database structure and behaviour for feature classes. Apply subtypes to control behaviour, create relationships with rules for association, and classifications for complex code domains. • Define spatial properties of datasets. Specify rules to compose topology that • enforces spatial integrity and shared geometry, and networks for connected systems of features. Topological and network rules are set to operate on features and objects. Set the spatial reference system for the dataset. Specify the survey datasets, if needed. Specify the raster datasets as appropriate.

15. 5.3.3 Physical Design of a Database Model

16. 5.3.3 Physical Design of a Database Model

17. Summary and Review Questions

18. Next week Thank You