wvdot gis reference - wvdot geospatial transportation ... · link to esri gis tutorials coordinate...

37
Reference A broad range of reference materials of interest during the GIS seminars.

Upload: others

Post on 12-Jun-2020

17 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

ReferenceA broad range of reference materials of interest during the GIS seminars.

Page 2: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Toolbars 6

Standard Toolbar

Tools Toolbar

Layout Toolbar

Editing Toolbar

Geocoding Toolbar

Federal Information Processing System (FIPS) 13

State FIPS Codes

West Virginia County FIPS Codes

WV Counties by DOH District 17

Online Data: The United States Census Bureau 18

Connecting to Other Online Data Services 19

Connect to ArcGIS Online

Connect to WVNet IMS Server

Connect to WVGIS Server

Connect to WVDOT Public Geodatabase Service

Access GTI_PUB_UTM Data from a WVDOH District Office 23

Database Location

How to access the GIS database

Connecting to the GTI_PUB_UTM SDE database from the WVDOT Central Office 28

Connecting to the geo-database GTI_PUB_UTM from ArcGIS Desktop

Adding a data layer from the Geodatabase

WVDOH RouteID System 31

Current RouteID Configuration

Future RouteID Configuration

�2

Page 3: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Link to ESRI GIS Tutorials

Coordinate Systems 36

West Virginia State Plane Zones by County

Relationship between UTM Zone 17 and WV State Plane Zones

�3

Page 4: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

�4

Page 5: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Questions?

Feel free to contact the GTI Help Desk: [email protected] or Yueming Wu: [email protected] (304) 558-7437.

�5

Page 6: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

ToolbarsStandard Toolbar

! New: Create a new map document.

� Open: Open and existing map document.

� Save: Save the current map document.

! Print: Print the current map document.

� Cut: Cut the selected element(s).

� Copy: Copy the selected element(s).

� Paste: Paste the clipboard contents onto the map.

� Delete: Delete the selected element(s).

! ! Undo/Redo: Undo/Redo the last action.

! Add Data: Add new adds data to the active data frame.

! Map Scale: Display and set the map scale.

! Editor Toolbar: Open the Editor Toolbar to edit the map’s data.

! Table of Contents: Open the Table of Contents (TOC) window to work with the map’s contents

! Catalog: Open the catalog window to access and manage data.

! Search: Open the search window to search for data, maps, tools, etc.

! ArcToolbox: Open the ArcToolbox window to access geoprocessing tools and toolboxes.

! Python: Open the Python window to execute geoprocessing commands and scripts.

�6

Page 7: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

! ModelBuilder: Open the ModelBuilder window to make a geoprocessing model. Tools Toolbar

� Zoom in/ out: Clicking and hold the mouse key to select a rectangular area to zoom in/out of. Alternately, place the magnifier icon over the area of interest and use the mouse roller wheel to zoom in and out.

� Pan: Pan the map by dragging. Click to re-center the map. Double-click to re-center and zoom in. SHIFT and drag to zoom to rectangle.

� Full Extent: View the full extent of the map. By default, this is the extent of all the data in the active data frame. To customize Full Extent, choose View > Data Frame Properties.

� Fixed zoom in/out: Zoom in/out on the center of the map.

� Previous/Next Extent: Returns the view to the previous/last extent.

� Select Features: Select features from selectable layers by clicking on them or dragging a box over them. Also use the Select by Polygon, Lasso, Circle and Line tools to select features using graphics drawn to the screen. Hold down the SHIFT key while selecting features to add or remove selected features. Alternately, choose Selection > Interactive Selection Method from the Main menu.Clear Selected Features: Unselect the currently selected features in all layers.

� Select Elements: Select, resize, and move text, graphics, and other elements placed on the map.

� Identify: Identify geographic features by clicking on them or dragging a box around them.

� Measure: Measure distance and area on the map.

� Find: Find a geographic feature, place, or address.

� Find Route: Find a route between specified stops.

� Go to XY: Type in an XY location to find it.�7

Page 8: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

�8

Page 9: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Layout Toolbar

� Zoom in/out: Zoom in on the map layout by clicking once or dragging a box on the layout.

� Pan: Pan the map layout by dragging it.

� Full Extent: Zoom to the full extent of the map layout.

! Zoom to 100%: Zoom the map layer to 100% (1:1).

! Fixed Zoom in/out: Zoom in/out of the center of the map layout.

! Go Back/ Go Forward to Extent: Go back/forward to the previous extent of the

map layout.

! Zoom to Percent: Zoom the map layout by a particular percentage. Choose

from the list or type in the percentage.

! Toggle Draft Mode: Toggle draft mode of the frame graphics.

! Focus Data Frame: Put this frame into focus, making it the target for graphics and

text drawn on top of it while in layout view.

! Change Layout: Change a layout by choosing a predefined template.

! Data Driven Pages Toolbar: Open the Data Driven Pages Toolbar to set up and

work with data driven pages for this map. Data driven pages enable creation of map

books and map series using the map’s layout. Data driven pages use an index layer to

produce multiple output pages using a single layout. Each page shows the data at a

different extent. The extent are defined by the features in the index layer.

�9

Page 10: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Editing Toolbar

� Editor:• Start Editing• Stop Editing• Save Edits• Move• Split• Construct Points…• Copy Parallel…• Merge…• Buffer…• Union…• Clip…• Validate Features• Snapping• More Editing Tools• Editing Windows• Options…

Edit Tool: Select and edit features in an edit session. This tool selects from any selectable layers, including ones you are not editing. If there is more than one selectable feature where clicked the selection can be refined by clicking the selection icon that appears on the map.Edit Annotation Tool: Select and annotate geodatabase annotation features. Disabled is there is not at least one geodatabase annotation layer set as selectable while editing.Straight Segment: Create a vertex each time you click. The segment between vertices are straight lines. Right-click or use keyboard shortcuts to place vertices using exact measurements.End Point Arc Segment: Create a circular arc segment by place the start and end points of the curve and defining a radius. Press R to enter a radius.Trace: Create segments by tracing existing features.Right-click or press O to access tracing options, include setting an offset.Point: Add points to the edit sketch.

�10

Page 11: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Edit Vertices: View, select, and modify the vertices and segments that make up the shape of an editable feature. Use the tools on the Edit Vertices toolbar to edit the geometry.Reshape Feature Tools: Reshape a line or polygon by constructing a sketch over a selected feature. The feature takes the shape of the sketch from the first place the sketch intersects the line feature to the last.Cut Polygons Tool: Split one of more selected polygons based on a line you draw.Split Tool: Split a selected line feature into two features at a location you click. When clicked, the pointer must be within the snapping tolerance.Rotate Tool: Rotate selected features interactively or by an angular measurement. Press A to rotate a value.Attributes: Open the attributes window to modify the attribute values of selected features in the layers being edited. The relationships among features may also be edited in this window.Sketch Properties: Open the sketch Properties window to view and modify the properties of the sketch geometry that makes up a feature. To populate this window, use the Edit tool to double-click a feature.Create Features: Open the Create Features window to add new features. Click a feature template to set up the editing environment with those properties, then click a construction tool on the window to digitize features.

�11

Page 12: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Geocoding Toolbar

� Select Address Locator: Select and address locator from the list or choose the Manage Address Locators option to add or remove an address locator.

� Use Map Extent: Use the current map extent when finding locations.

� Find Address: Enter and address to geocode. When a match is found, right-click the matched address to choose an action such as Zoom to or Add Labeled Point on the context menu.

� Address Inspector: Hold down mouse button and move over locations to see addresses.

� Geocode Address: Geocode a table of addresses.

� Review/Rematch Addresses: Review and rematch the addresses in this feature class.

�12

Page 13: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Federal Information Processing System (FIPS)A Federal Information Processing Standard (FIPS) is a publicly announced

standardization developed by the United States federal government for use in computer

systems by all non-military government agencies and by government contractors, when

properly invoked and tailored on a contract.

The importance of referring to this system is providing the ability to ‘decode’ data

filenames from the United States Census Bureau. A later example will illustrate FIPS.

�13

Page 14: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

State FIPS Codes

State Abbreviation FIPS Code State/Territory NameAK 02 AlaskaAL 01 AlabamaAR 05 ArkansasAS 60 American SamoaAZ 04 ArizonaCA 06 CaliforniaCO 08 ColoradoCT 09 ConnecticutDC 11 District Of ColumbiaDE 10 DelawareFL 12 FloridaGA 13 GeorgiaGU 66 GuamHI 15 HawaiiIA 19 IowaID 16 IdahoIL 17 IllinoisIN 18 IndianaKS 20 KansasKY 21 KentuckyLA 22 LouisianaMA 25 MassachusettsMD 24 MarylandME 23 MaineMI 26 MichiganMN 27 MinnesotaMO 29 MissouriMS 28 MississippiMT 30 MontanaNC 37 North CarolinaND 38 North DakotaNE 31 NebraskaNH 33 New HampshireNJ 34 New JerseyNM 35 New MexicoNV 32 Nevada

�14

Page 15: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Combine state and county code to completely identify a county.

Example: Kanawha County West Virginia 54 + 039 = 54039.

NY 36 New YorkOH 39 OhioOK 40 OklahomaOR 41 OregonPA 42 PennsylvaniaPR 72 Puerto RicoRI 44 Rhode IslandSC 45 South CarolinaSD 46 South DakotaTN 47 TennesseeTX 48 TexasUT 49 UtahVA 51 VirginiaVI 78 Virgin IslandsVT 50 VermontWA 53 WashingtonWV 54 West VirginiaWI 55 Wisconsin

State Abbreviation FIPS Code State/Territory Name

�15

Page 16: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

West Virginia County FIPS Codes

County Name FIPS Code County Name FIPS CodeBARBOUR 001 MINERAL 057BERKELEY 003 MINGO 059

BOONE 005 MONONGALIA 061BRAXTON 007 MONROE 063BROOKE 009 MORGAN 065CABELL 011 NICHOLAS 067

CALHOUN 013 OHIO 069CLAY 015 PENDLETON 071

DODDRIDGE 017 PLEASANTS 073FAYETTE 019 POCAHONTAS 075GILMER 021 PRESTON 077GRANT 023 PUTNAM 079

GREENBRIER 025 RALEIGH 081HAMPSHIRE 027 RANDOLPH 083HANCOCK 029 RITCHIE 085

HARDY 031 ROANE 087HARRISON 033 SUMMERS 89JACKSON 035 TAYLOR 091

JEFFERSON 037 TUCKER 093KANAWHA 039 TYLER 095

LEWIS 041 UPSHUR 097LINCOLN 043 WAYNE 099LOGAN 045 WEBSTER 101MARION 049 WETZEL 103

MARSHALL 051 WIRT 105MASON 053 WOOD 107

MCDOWELL 047 WYOMING 109MERCER 055

�16

Page 17: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

WV Counties by DOH District

�17

9

8

5

1

73

4

2

10

6

Randolph-42

Greenbrier-13

Kanawha-20

Hardy-16

Pocahontas-38

Fayette-10

Preston-39

Raleigh-41

Nicholas-34

Boone-03

Roane-44

Webster-51

Logan-23

Braxton-04

Ritchie-43

Mason-27

Clay-08

Monroe-32

Lewis-21

Mcdowell-24

Lincoln-22

Tucker-47Wood-54

Mercer-28

Wetzel-52

Tyler-48Marion-25

Monongalia-31

Grant-12

Pendleton-36

Wayne-50

Hampshire-14

Mingo-30

Jackson-18

Wyoming-55

Harrison-17

Gilmer-11 Upshur-49

Wirt-53

Putnam-40

Mineral-29

Barbour-01

Cabell-06

Summers-45

Berkeley-02

Marshall-26

Calhoun-07

Doddgridge-09

Morgan-33

Taylor-46 Jefferson-19

Ohio-35

Pleasants-37

Brooke-05

Hancock-15

Counties by DOH District

01 Barbour02 Berkeley03 Boone04 Braxton05 Brooke06 Cabell07 Calhoun08 Clay09 Doddgridge10 Fayette11 Gilmer12 Grant13 Greenbrier14 Hampshire15 Hancock16 Hardy17 Harrison18 Jackson

19 Jefferson20 Kanawha21 Lewis22 Lincoln23 Logan24 Marion25 Marshall26 Mason27 Mcdowell28 Mercer29 Mineral30 Mingo31 Monongalia32 Monroe33 Morgan34 Nicholas35 Ohio36 Pendleton

37 Pleasants38 Pocahontas39 Preston40 Putnam41 Raleigh42 Randolph43 Ritchie44 Roane45 Summers46 Taylor47 Tucker48 Tyler49 Upshur50 Wayne51 Webster52 Wetzel53 Wirt54 Wood55 Wyoming

Page 18: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Online Data: The United States Census BureauA large store of up-to-date geospatial data is available from the US Census Bureau.

A simple way to quickly download geographic data, such as roads or river, is to use ftp

(file transfer protocol) access. The relevant files are referred to as TIGER (Topologically

Integrated Geographic Encoding and Referencing) line products. These geographic and

select demographic and economic products are available in shapefile or geodatabase

formats. Starting from the Geography page: http://www.census.gov/geo/maps-data/data/

tiger-line.html, navigate to the ftp site, login as an anonymous user or guest. Our

example uses the 2014 TIGER data located at URL ftp://ftp2.census.gov/geo/tiger/TIGER2014.

From the TIGER2014 file system, select “ROADS”. This folder reveals a large collection

of ZIP files. The collection is all of the roads in the US by county. To ‘decode’ the zip file

names, use the preceding FIPS information. Example: What is in

tl_2014_54023_roads.zip?

tl = TIGER line; 2014; 54 = West Virginia; 023 = Grant County; roads.

Download and unzip the file, import the data source into ArcMap.

In addition, the Census web site’s Data Profiles have the most frequently requested

social, economic, housing, and demographic data. Each of these four subject areas is a

separate data profile. The data profiles summarize the data for a single geographic

area, both numbers and percent, to cover the most basic data on all topics.

�18

Page 19: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Connecting to Other Online Data Services

Online data services may be accessed by adding the URL (Uniform Resource Locator)

information and any login credentials that may be required for a particular server. The

illustration shows a connection to the WVGIS server, with the data organized by

subfolder. Several server connections are illustrated on the following pages.

Connect to ArcGIS Online

Enter the server URL http://services.arcgisonline.com/ArcGIS/rest/services

! !

�19

Page 20: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Connect to WVNet IMS Server

ArcIMS stands for Arc Internet Map Server is a Web Map Server produced by ESRI. It is

a GIS that is designed to serve maps across the Internet. ArcIMS will be discontinued in

ArcGIS version 10.1. However the data service is likely to be available for some time.

To connect to the WVNet IMS server, enter the server URL http://ims.wvgs.wvnet.edu

�20

Page 21: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Connect to WVGIS Server

Enter the server URL http://services.wvgis.wvu.edu/ArcGIS/services

To add connection to an ArcGIS Server on your computer:1.Open ArcCatalog2.Expand GIS Servers in the Table of Contents (TOC)3.Double-click Add ArcGIS Server4.The Add ArcGIS Server Wizard will open5.On the first screen, choose Use GIS Services and click Next>6.On the 2nd screen, enter the information as seen in the graphic below:

http://otvmarcgisdev01/argis/services7.Click Finish

�21

Page 22: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Connect to WVDOT Public Geodatabase Service

Enter the WVDOH GIS service URL: http://gis.wvdot.com/arcgis/rest/services

�22

Page 23: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Access GTI_PUB_UTM Data from a WVDOH District

OfficeThe WVDOH GTI Section maintains GIS data for numerous transportation features and data layers. To enable these data to be accessed efficiently from a district office, the central GIS database has been replicated onto the shared drive at each district. The following directions indicate how to access and use these data.Database Location

Users can find the database in the following directory on their local server: S:\GIS Database

In the folder is a file geodatabase titled GTI_PUB_UTM.gdb.The geodatabase contains all the GIS data. An ArcGIS Desktop map document titled Base_Map_UTM_D* will display the data.ArcGIS 10 software

�23

Page 24: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

The map documents and data files require ArcGIS 10 software installed on the office PC. Contact the Office of Technology if the ArcGIS software is not installed. The WVDOT has an Enterprise License Agreement with ESRI that allows anyone within the WVDOT to install and use the ArcGIS suite.Base MapWith ArcGIS installed, open the base map document. The base map is a map document that has been prepared with many typical GIS layers. Map symbology and labeling have been configured in the map document. The base map is designed for new users to bypass the map setup and configuration and begin using ArcMap to access common information. To open the base map, double click the icon. The base map document is read only, meaning that changes can’t be saved to the Base_Map_UTM document. To save changes, save a copy to the local drive. The copy can be freely modified.

How to access the GIS database

To access individual layers from the database in a new map document, a connection to the GIS database folder must be established.

1. In ArcMap, click on the Add Data button � .

2. In the Add Data window, click on the Connect to Folder button � .3. In the Connect to Folder window, browse to the S:\GIS Database folder. The GIS

Database folder will show up in the folder connections every time the Add Data button is selected in ArcMap.

�24

Page 25: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

4. To add layers from the database, click the Add Data button, browse to the GIS

Database folder and click on the GTI_PUB_UTM.gdb.

�25

Page 26: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Inside the GIS Database there are six Feature Datasets. Feature Dataset are

containers that organize GIS data layers by category. 5. Click on a feature dataset to see the individual data layers in the feature dataset.

The GIS data layer types are point, line, and polygons. Choose one or multiple layers to add them to ArcMap’s data view. Click on a layer, or, hold down the control key and click multiple layers, then click Add.

�26

Page 27: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

The selected layers are added to the data view.

�27

Page 28: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Connecting to the GTI_PUB_UTM SDE database from

the WVDOT Central OfficeGTI_PUB_UTM is a geodatabase published by the West Virginia Division of Highways Program Planning & Administration Division Geospatial Transportation Information (GTI) Section. It contains the most accurate and current transportation GIS datasets maintained by GTI. It also stores spatial data published by third parties such as the West Virginia GIS Technical Center (WVGISTC) & USGS. The transportation GIS datasets are updated weekly and the third party data every quarter.The spatial reference for GTI_PUB_UTM is UTM (Universal Transverse Mercator) Zone 17, NAD 83, which is a preferred and commonly used one in the West Virginia geospatial community. Most of the spatial data published by WVGISTC is also in this spatial reference.

Connecting to the geo-database GTI_PUB_UTM from ArcGIS Desktop

1. In ArcMap, click the Add Data button.�2. In the dialog box, choose Database Connections from the drop down menu.3. Double-click Add Spatial Database Connection.

�28

Page 29: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

4. In the Spatial Database Connection dialog enter the connection Properties:

5. The Connection screen should match the graphic below. BEFORE clicking OK, click the Change… button.

6. Select dbo.DEFAULT and click OK.7. Then click Ok on the Spatial Database Connection dialog.8. Rename the new connection something more meaningful. For example:

GTI_PUB_UTM_DC. The connection setup properties only need to be created once.

Server: 10.200.46.51Service: SDE:SQLSERVER:10.200.46.51Database: GTI_PUB_UTMUsername: wvdohgisreaderPassword: wvdohgisreader

�29

Page 30: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

9. To add a GIS layer to ArcMap’s data view map, double-click the newly created connection. The Add Data dialog box will look similar illustration. Note the seven

feature datasets used to organize similar feature classes.Adding a data layer from the Geodatabase

As an example, add the hospitals feature class to the map document. Hospitals are grouped into the Cultural Feature Dataset.

1. Double-click GTI_PUB_UTM.DBO.Cultural.2. Highlight GTI_PUB_UTM.DBO.Hospitals and click Add.

Congratulations! Hospitals has been added to the data view of the map document from the GTI_PUB_UTM geodatabase. Updated 02/08/2012

�30

Page 31: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

WVDOH RouteID System Last update March 20, 2013

Current RouteID Configuration

Currently used in the WVDOT Geodatabase in data layer CompleteRoutes:

XX – X – XXXX – XX – XX1 2 3 4 5

Dashes are not part of the RouteID but shown to separate individual fields.

The future RouteID accounts for additional route complexity and network information. The future RouteID representation retains the current RouteID, and appends additional field definitions for local roads, ramps, and addressing to the end of the current RouteID.

Future RouteID Configuration

XX1 – X2 – XXXX3 – XX4 – XX5 – XX – ( XXXX – X ) 6 7 8

County Code, see table following page1

Sign System, see list second page following2

Route3

Sub-route4

Supplemental Code5

Direction6

Exit or Sequence Number7

Ramp Letter8

�31

Page 32: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

WVDOT - Route Layer - Route ID Codes (updated 3/20/2013)

Field Description Field Name

Field Name Format Comments Field

TypeField Width Dec.

ObjectID ObjectID - 999999 Key number used for sorting the table (Autonumber) N 6 0

RouteID RouteID - XX-X-XXXX-XX-XX-XX

Route Identification number (County code - Sign System - Route -Subroute - Supp Code - Dir) Dashes are not part of the key just for formating purposes.

T 13 0

RouteID (for ramps not part of existing route) *

RouteID - XX-X-XXXX-XX-XX-XX-XXXX-X

(County Code - Sign System - Route - Subroute - Supp Code - dir - Exit Number - Ramp Letter)

T 18 0

RouteID (DUPLICATE) ** RouteID - XX-X-XXXX-XX-

XX-XX-XXX

(County Code - Sign System - Route - Subroute - Supp Code - dir - Sequence #)**

T 16 0

RouteID (emergency crossovers)* RouteID - XX-X-XXXX-XX-

XX-XX-XXX(County Code - Sign System - Route - Subroute - Supp Code - dir - mile point)* T 16 0

RouteID (for Railroad)**** RouteID - XX-X-XXXX-XX-

XX-XX(County Code 99 - Sign System R - Route - Subroute - Supp Code 00 - Dir 00 )**** T 13 0

RouteID_Old RouteID_Old - XX-X-XXXX-XX-

XX

Route Identification number (County code - Sign System - Route -Subroute - Supp Code) Dashes are not part of the key just for formating purposes (eventually will be removed from database) .

T 11 0

County Code County Code - XX State County Code T 2 0

Sign System Sign System - X 1,2,3,4,5,6,7,8,9,U,R T 1 0

Route Route - XXXX Route number only T 4 0

Sub Route SubRoute - XX Subroute number only T 2 0

Supplemental Route Designation Code

Supp Code - XX 0 - 26 and 99. T 2 0

Dir Dir - XX

Routes that have dual geometry are given direction (EB, WB, NB, SB) Routes with single geometry are given 00. used in the creation of routeid

T 2 0

Direction Direction - XX Primary - North or East Bound, Secondary - South or West Bound (EB, WB, NB, SB) T 2 0

Direction of Survey Dsurvey   X From Straight Line Diagram (Generally from West to East or South to North) T 1 0

Exit Number Exit   XXX 001, 010, 100, etc.; Mile point of the exit T 3 0Ramp Letter Letter   X A, B, C, D, etc. T 2 0

Local Name Local Name   XXXXXXXXXXX

XXXXXX   T 250 0

Measured Length MeasuredLength miles 9999.99 Length of Segment 2 decimal places

accurracy on all miles N 6 2

Starting Mile Point from RIL BMP miles 9999.99 WVDOT Beginning Mile point 2 decimal

places accurracy on all miles N 6 2

Ending Mile Point From RIL EMP miles 9999.99 WVDOT Ending Mile point N 6 2

Continuous BMP *** CBMP miles 9999.99 Begin Mile point when looking at a continuous route layout N 6 2

Continuous EMP *** CEMP miles 9999.99 End Mile point of a segment in a continuous route layout N 6 2

Year Year   9999 Date Updated N 8 0

Comments Comments   999999999 If verification is needed. T 250 0

�32

Page 33: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Sign System Supplemental Code

1 = Interstate 00 Not Applcable

2 = US 01 Alternate

3 = WV 02 Wye

4 = CO 03 Spur

5 = N/A 04 North

6 = STATE PARKS AND FOREST ROADS 05 South

7 = FANS 06 East

8 = HARP 07 West

9 = Other 08 business

0 = MNS (Municipal Non-State) 09 North Bound (Business)

U = USFR- United state forest road 10 South Bound (Business)

R= Railroads (WV State Rail Authority) 11 East Bound (Business)

12 West Bound (Business)

13 Truck Route

14 Bypass

15 Loop

16 Toll

17 Ramp

18 Other

19 City Streets, non-State

20 Roads Under construction

*If the ramp is also part of an existing route, the RouteID remains the same as the connected route. Otherwise, the ramp RouteID is the RouteID for the highest sign system (interstate, us etc) or lowest route number if in same sign system with the addition of the exit number and ramp letter. The exit number is the mile point of the exit. Mile point is also used at the end of emergency crossover RouteID.

21 Footbridges

22 Historical Bridges

23 Connector

24 New/Proposed

** In creating the route layer in ArcGIS lines were drawn over every segment of road. This created the possibility of additional lines not in the RIL. Currently, these pieces consist mainly od undocumented wye segments. The sequence number (exit segment) of the field is used to account for duplicate RouteID designations. For the first instance of any route, the sequence number is blank. For the first duplicate, the sequence number is 001, and increments as needed (example: 0240032000200 is the first wye on route 32. If second wye present, RouteID would be 02400320002000001).

25 Crossover (btwn dual geometry)

26 Emergency Crossover

27 Left Turn Lane

28 Right Turn Lane

�33

Page 34: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Railroads*** CBMP and CEMP are used in a route flow table that follows a route from beginning to the end allowing the mileage to accumulate cross-county boundaries. This was being duplicated at one point in the route layer data but was not kept current with all the recent changes and at times was used for calculations. It can still be used for this route flow if deemed, but would need to be updated once the segment mileage is set.

99 Abandoned

Sign System Note

**** Railroads in the LRS are only for WV State Rail Authority lines. County Code and sign system will always be 99, and R respectively. Each line has a unique route number. Small spurs are given the main line route number and a unique Sub Route number. Supplemental Code and Direction is 00.

�34

Page 35: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Link to ESRI GIS Tutorials

A small sample of the ArcMap tutorial available from ESRI.

Tutorial Overview

http://resources.arcgis.com/en/help/main/10.1/index.html#//00qn0000013t000000

Page Layouts

http://resources.arcgis.com/en/help/main/10.1/index.html#/What_is_a_page_layout/

00s90000002z000000/

Maplex Label Engine

http://resources.arcgis.com/en/help/main/10.1/index.html#//00s800000050000000

�35

Page 36: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Coordinate SystemsWest Virginia State Plane Zones by County

The Geodetic Control / Surveying Task Force recommended to the WV GIS Steering

Committee that all agencies mapping geographic data within West Virginia utilize one of

the following three coordinate systems: Geographic Coordinate System, Universal Transverse Mercator, or State Plane Coordinate System, all referenced to the North

American Datum of 1983. Only these coordinate systems and datum will serve as the

official data exchange standard for GIS data sets that make up the West Virginia Spatial

Data Infrastructure. In August 2002, the new standard was approved by the WV GIS

Steering Committee.

�36

Page 37: WVDOT GIS reference - WVDOT Geospatial Transportation ... · Link to ESRI GIS Tutorials Coordinate Systems 36 West Virginia State Plane Zones by County Relationship between UTM Zone

Relationship between UTM Zone 17 and WV State Plane Zones

�37