300 likes | 516 Views
GIS Tutorial 1. Prepared by:. David Webb. Lecture 4 Geodatabases. With support from:. NSF DUE-0903270. in partnership with:. Geospatial Technician Education Through Virginia’s Community Colleges (GTEVCC). Lecture 4. geodatabases. The Geodatabase Poster. Geodatabase. No more lost data!
E N D
GIS Tutorial 1 Prepared by: David Webb Lecture 4 Geodatabases 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
The Geodatabase Poster GIS TUTORIAL 1 - Basic Workbook
Geodatabase • No more lost data! • Model of reality. • Contains the information needed to create a map and answer a problem. • Schema already available. GIS TUTORIAL 1 - Basic Workbook
Geodatabase types Manages features and tables inside a database management system • 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
Geodatabase types • Personal geodatabase • stores datasets in a Microsoft Access .mdb file • storage sizes between 250 and 500 MB • limited to 2GB • only supported on Windows • ArcSDE geodatabase • stores datasets in a number of optional DBMSs: • IBM DB2, IBM Informix , Microsoft SQL Server , Oracle, or PostgreSQL • unlimited size and users GIS TUTORIAL 1 - Basic Workbook
New file geodatabase ArcCatalog GIS TUTORIAL 1 - Basic Workbook
Import into geodatabase Shapefile features GIS TUTORIAL 1 - Basic Workbook
Import into geodatabase • Tables GIS TUTORIAL 1 - Basic Workbook
Export from geodatabase GIS TUTORIAL 1 - Basic Workbook
Compact geodatabases • 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 ArcMap cannot be compacted • remove any layers with a source table or feature class in that database from the TOC GIS TUTORIAL 1 - Basic Workbook
Compress geodatabases • 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
View geodatabases • Cannot identify names in Windows Explorer • Must use ArcCatalog GIS TUTORIAL 1 - Basic Workbook
Geodatabase Essentials GIS TUTORIAL 1 - Basic Workbook
Lecture 4 Data Models GIS TUTORIAL 1 - Basic Workbook
Data Models • Download Models and copy appropriate portions into your geodatabase. • http://support.esri.com/en/downloads/datamodel • Base maps: http://resources.arcgis.com/content/local-government/basemaps • GDB Design Forms-Tutorial #3 • For large Projects and multiple entities GIS TUTORIAL 1 - Basic Workbook
Student Models • What data is required to answer the questions…..Often driven by the limitations on location. • Where to put a wind turbine in Roanoke area? GIS TUTORIAL 1 - Basic Workbook
Wind Turbine • Wind power available • Elevation • Slope • Proximity to airports, roads, rivers, populations • Ability to see from scenic locations GIS TUTORIAL 1 - Basic Workbook
Lecture 4 Data types GIS TUTORIAL 1 - Basic Workbook
Vector data • Map features • Points, lines, polygons • Shape Files • Feature attributes • Every feature has attributes (e.g. name, area, population) Tabular Data GIS TUTORIAL 1 - Basic Workbook
Feature class • 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
Feature dataset • Use feature datasets to organize spatially related feature classes into a common dataset: GIS TUTORIAL 1 - Basic Workbook
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_raster_dataset_file_formats/009t0000000q000000/ GIS TUTORIAL 1 - Basic Workbook
Directly loadable data types • dBase (.dbf) • Text with comma (.csv) or tab-separated values (.txt) • Microsoft Access (.mdb) • Microsoft Excel (.xls) GIS TUTORIAL 1 - Basic Workbook
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
Terrain • TIN Based surface based on measurements stored as features in a geodatabase. GIS TUTORIAL 1 - Basic Workbook
Lecture 4 Topology GIS TUTORIAL 1 - Basic Workbook
Topology • Quality Assurance of Data GIS TUTORIAL 1 - Basic Workbook
Topology GIS TUTORIAL 1 - Basic Workbook
Topology tw_651 GIS TUTORIAL 1 - Basic Workbook