Geodatabase Design Using ArcCatalog Demo and Exercise UT-Dallas GISC 6383 RB 10/04/06Getting ReadyCreate an empty Personal Geodatabase called WilsonGDBCreate Feature Dataset (fds) for City of Wilson data (an fds is essentially a “spatial folder”)Import North Carolina counties layer as a Standalone Feature classNote: It would probably be more appropriate to create a Feature Data Set with Spatial Domain sufficient to encompass all of North Carolina, then put the NC counties in there, rather than create a standalone feature class for these counties. You will probably need other “statewide” datasets e.g. freeways.Establishing the SchemaCreating Feature classes and attributesSpecifying SubTypes and Defaults for Waterlines (business rules)Loading Data: Populating the TableWe populate the table either by:--Loading data from an existing source (e.g a Shapefile, coverage, etc.)--hand edit in ArcMap10. Loading from an Existing SourceThe next dialog allows you to match variables in source to those in target (gdb) table.Note how Line_material and Line_size have been set based on the defaults we established.Importing Data: importing a ShapefileLets see how this works in ArcMApApply these domains to fields and/or subtypesDefine Relationships Between Tables(Saved as P;….Wilson_GDBWilsonGDB_X.mdb)Use Domains in ArcMapUse Relationships in ArcMapImporting a CoverageExtra Practice with ImportCreate a New Feature Class (Table) and Load Data (Crime95)You now need to specify variables and their types either by:Geodatabase Design Using ArcCatalog Demo and Exercise UT-Dallas GISC 6383 RB 10/04/06This demo/exercise shows how to use ArcCatalog to create a geodatabase, specify spatial precision, define and populate tables, incorporate business rules through subtypes, defaults and domains, and establish relationships. Hint: if you get error messages saying “user lock” or similar shut down ArcMap, or close ArcCat and reopen.This exercise borrows heavily from ESRI Intro to ArcInfoGetting Ready1. Use Windows Explorer to Copy the two Wilson folders in p:\ briggs\g6383 to c:\my documents or h:\2. Examine the Wilson data using ArcCat --it consists of coverages , shapefiles, rasters and tablesExamine the same folder with Windows Explorer--notice the physical files/folders used to store spatial files Our purpose is to create a Personal Geodatabase to store and manage the Wilson data.Create an empty Personal Geodatabase called WilsonGDB 3. In the left window of ArcCat, right-click Wilson folder and select New/personal geodatabaseImmediately type WilsonGDB to name itIf it’s called New Personal Geodatabase, right click on it in right window, and use Rename.We now need to structure this currently-empty geodatabase according to our database design. Create Feature Dataset (fds) for City of Wilson data (an fds is essentially a “spatial folder”)4. Right-click WilsonGDB entry in left side ArcCat window and select New/Feature Dataset--in name box type WilsonCityWe need to establish its Spatial Reference- click the show details box and note the values relative to max for 4byte long integer--range is –10000 to 11474.83645 = 21474.83645 * 10,000 (scale) = 2,147,483,645- click Edit box and note your various options--click the Import button: we will set Spatial Reference based on another layer--go to the Wislon folder on c:\ and select WilsonCity.shp and click the Add button--examine each of the tabs in the Spatial Reference Properties boxCoordinate System, X/Y Domain, Z Domain, M DomainNote Precision (under X/Y domain tab): 15,624. There are 15,000 units per foot. Data will be stored to approximately 1/1,000 of an inch (15,624/12)Compare X/Y domain values relative to slide from lecture--click Apply then OK to use this, then click OK to create Feature Dataset- Click WilsonCity.shp, select Metadata tab, FGDC ESRI style, then Spatial optiono Note the bounding box values (they are shown also in the lecture slide)o Compare them to the X/Y domain for the Feature Dataset just created(right click on Wilson City Feature Dataset, select Properties, click Edit button)Are they the same? If not, how and why do they differ?We now have a feature data set in which to place feature classes. But before we do this, let’s illustrate creating a standalone feature class.Import North Carolina counties layer as a Standalone Feature class Our design calls for a North Carolina counties layer so that we can place City of Wilson in a state context.Why is it inappropriate to place in WilsonCity feature dataset? --- because it needs a different spatial reference.5. Right click WilsonGDB and select Import/Feature Class (Single) - drag c:\My Documents\usr\initials\Wilson\nccounty_prj.shp into the Input Features box, - In the third box specify the name as ncCounty.- You can also control three other major things when importing a data set --Use Expression line to create an SQL statement to import only selected features (rows) --Use NewFieldName column in FieldInfo (optional) box to change variable namesChange Black to AfAm --Use Visible column in FieldInfo (optional) box to select variables (columns) to importFor variables that you do not wish to import, change Visible column to False.1Do this for AREA variable since area is automatically maintained in Geodatabase. --Use Environments button to change the spatial reference system (e.g. the projection) as you import the file—however, this does not seem to work in ArcGIS version 9.0 or 9.1!- Click OK- When tool completes, check messages for anything in red (or green), then click Close- Right click WilsonGDB and select Import/Shapefile to GeodatabseFeature Class (Single) (hammer icon, not wizard)Check Spatial Reference: Right click ncCounty and select Properties (or double-click ncCounty), select Fields tab. In Field Names (upper box) select Shape, in Field Properties box (bottom box) click small grey rectangle at end of Spatial Reference line, finally click X/Y Domain tab.Note the very different Precision (244.140624772626) and x/y values Each foot is divided into 244 units. Data will be stored to approximately 1/20th of an inch (244/12)Note also that range times precision is less than 2, 147,483,648 (close but less!). For x (note MinX is negative) range is (2668471.91727639 + 6127621.10083561) = 8796093.01811200*244.140624772626 = 2,147,483,645 Note: It would probably be more appropriate to create a Feature