GIS Tutorial 1 Lecture 4 Geodatabases Prepared by

GIS Tutorial 1 Lecture 4 Geodatabases Prepared by: David Webb With support from: NSF DUE-0903270 in partnership with: Geospatial Technician Education Through Virginia’s Community Colleges (GTEVCC)

Lecture 4 GEODATABASES GIS TUTORIAL 1 - Basic Workbook 2

The Geodatabase Poster GIS TUTORIAL 1 - Basic Workbook 3

Geodatabase u No more lost data! u Model of reality. u Contains the information needed to create a map and answer a problem. u Schema already available. GIS TUTORIAL 1 - Basic Workbook 4

Geodatabase types Manages features and tables inside a database management system u File geodatabase § § stores datasets in a folder of files each dataset a file up to 1 TB in size can be used across platforms can be compressed and encrypted for read-only, secure use § ESRI’s recommended choice GIS TUTORIAL 1 - Basic Workbook 5

Geodatabase types u Personal geodatabase § § u stores datasets in a Microsoft Access. mdb file storage sizes between 250 and 500 MB limited to 2 GB only supported on Windows Arc. SDE geodatabase § stores datasets in a number of optional DBMSs: q IBM DB 2, IBM Informix , Microsoft SQL Server , Oracle, or Postgre. SQL § unlimited size and users GIS TUTORIAL 1 - Basic Workbook 6

New file geodatabase Arc. Catalog GIS TUTORIAL 1 - Basic Workbook 7

Import into geodatabase Shapefile features GIS TUTORIAL 1 - Basic Workbook 8

Import into geodatabase u Tables GIS TUTORIAL 1 - Basic Workbook 9

Export from geodatabase GIS TUTORIAL 1 - Basic Workbook 10

Compact geodatabases u File and personal geodatabases § Reduces size and improves performance § Compact personal geodatabases > 250 MB. § Geodatabases with frequent data entry, deletion, or general editing § Open geodatabases in Arc. Map cannot be compacted q remove any layers with a source table or feature class in that database from the TOC GIS TUTORIAL 1 - Basic Workbook 11

Compress geodatabases u File geodatabases § Once compressed, a feature class or table is read -only and cannot be edited § Compression is ideally suited to mature datasets that do not require further editing § Compressed dataset can be uncompressed to return it to its original, read-write format GIS TUTORIAL 1 - Basic Workbook 12

View geodatabases u u Cannot identify names in Windows Explorer Must use Arc. Catalog GIS TUTORIAL 1 - Basic Workbook 13

Geodatabase Essentials GIS TUTORIAL 1 - Basic Workbook 14

Lecture 4 DATA MODELS GIS TUTORIAL 1 - Basic Workbook 15

Data Models u Download Models and copy appropriate portions into your geodatabase. § http: //support. esri. com/en/downloads/datamodel u Base maps: http: //resources. arcgis. com/content/localgovernment/basemaps u GDB Design Forms-Tutorial #3 § For large Projects and multiple entities GIS TUTORIAL 1 - Basic Workbook 16

Student Models u What data is required to answer the questions…. . Often driven by the limitations on location. u Where to put a wind turbine in Roanoke area? GIS TUTORIAL 1 - Basic Workbook 17

Wind Turbine u Wind power available u Elevation u Slope u Proximity to airports, roads, rivers, populations u Ability to see from scenic locations GIS TUTORIAL 1 - Basic Workbook 18

Lecture 4 DATA TYPES GIS TUTORIAL 1 - Basic Workbook 19

Vector data u Map features § Points, lines, polygons § Shape Files u Feature attributes § Every feature has attributes (e. g. name, area, population) Tabular Data Shape Name Class Pop 2000 State Point New York City 8, 008, 278 NY Point Los Angeles City 3, 694, 820 CA Point Chicago City 2, 896, 016 IL GIS TUTORIAL 1 - Basic Workbook 20

Feature class u a collection of geographic features that share the same geometry type (such as point, line, or polygon) and the same attribute fields for a common area. Streets, well points, parcels, soil types, and census tracts are examples of feature classes. GIS TUTORIAL 1 - Basic Workbook 21

Feature dataset u Use feature datasets to organize spatially related feature classes into a common dataset: GIS TUTORIAL 1 - Basic Workbook 22

Raster Data Stored electronic image or picture taken as an aerial photograph or satellite image Composed of a rectangular array of square cells, called pixels, with a number in each cell representing the solid color fill of that cell http: //help. arcgis. com/en/arcgisdesktop/10. 0/help/index. html#/Supported_raste r_dataset_file_formats/009 t 0000000 q 000000/ GIS TUTORIAL 1 - Basic Workbook 23

Directly loadable data types u u d. Base (. dbf) Text with comma (. csv) or tab-separated values (. txt) u Microsoft Access (. mdb) u Microsoft Excel (. xls) GIS TUTORIAL 1 - Basic Workbook 24

Triangular irregular networks (TIN) Vector based triangles: useful to create slopes, contour intervals and other elevation data. Cannot be stored in a geodatabase. GIS TUTORIAL 1 - Basic Workbook 25

Terrain u TIN Based surface based on measurements stored as features in a geodatabase. GIS TUTORIAL 1 - Basic Workbook 26

Lecture 4 TOPOLOGY GIS TUTORIAL 1 - Basic Workbook 27

Topology u Quality Assurance of Data GIS TUTORIAL 1 - Basic Workbook 28

Topology GIS TUTORIAL 1 - Basic Workbook 29

Topology tw_651 GIS TUTORIAL 1 - Basic Workbook 30