Home » Autodesk Manuals » Computer Software » Autodesk 15606-011408-9005 » Manual Viewer

Autodesk 15606-011408-9005 Tutorial - Page 223

Exercise 1: Set up an ODBC connection for an Access database

Get Autodesk 15606-011408-9005 - MAPGUIDE R6.3 NAMED-10U PK PDF manuals and user guides

UPC - 606121429500

View all Autodesk 15606-011408-9005 manuals

Add to My Manuals
Save this manual to your list of manuals

Page 223 highlights

The database source contains a field that you can match to a field in the Parcels layer. You can join the data to the parcels and style or analyze all the resulting data seamlessly. Exercise 1: Set up an ODBC connection for an Access database Set up an ODBC connection for the Microsoft Access database using the Administrative Tools control panel in Windows. NOTE This exercise uses the AnalyzeMap1.dwg map you created and modified in the previous exercises. To set up an ODBC connection for the Access database 1 From your Windows desktop, click Start ➤ Settings ➤ Control Panel and open the Administrative Tools control panel. 2 In the Administrative Tools window, double-click Data Sources (ODBC). 3 In the ODBC Data Source Administrator dialog box, click Add. 4 In the Create New Data Source dialog box, click Microsoft Access Driver (*.mdb) and click Finish. 5 In the ODBC Microsoft Access Setup dialog box, for Data Source Name, enter Parcel_Owners. 6 Enter a description, for example, "Parcel owner information." Exercise 1: Set up an ODBC connection for an Access database | 215

Section	Page
Contents	3
Tutorial: Introducing AutoCAD Map 3D 2010	9
Lesson 1: Get Ready to Use the Tutorials	9
Exercise 1: Prepare your sample data	10
Exercise 2: Save your tutorial maps	11
Exercise 3: Set up the tutorial window	11
Exercise 4: Choose a workspace	12
Lesson 2: Take a Quick Tour of AutoCAD Map 3D	12
The Ribbon	14
Finding Commands	17
Workspaces	19
The Task Pane	20
Properties Palette	28
Data Table and Data View	29
Status Bars	31
Layout Tabs	32
Dynamic Input	33
Shortcut Menus	36
Options	37
Lesson 3: Get Started	38
Exercise 1: Create a map	38
Exercise 2: Use Data Connect to add data to your map	40
Exercise 3: Style a feature	41
Where you are now	43
Tutorial: Building a Map	45
About the Building a Map Tutorial	45
Lesson 1: Use Multiple Sources	46
Exercise 1: Drag and drop a source file	46
Exercise 2: Attach a drawing file	47
Exercise 3: Query in data from the drawing	49
Exercise 4: Use Data Connect	51
Exercise 5: Add a raster image	53
Exercise 6: Display the raster image behind other features	55
Lesson 2: Style Map Features	57
Exercise 1: Create a theme for the parcels layer	57
Exercise 2: Define the theme	58
Exercise 3: Add labels	60
Lesson 3: Change the Display by Zoom Level	62
Exercise 1: Add roads to your map	63
Exercise 2: Create a composite road style	64
Exercise 3: View styles at different zoom levels	67
Lesson 4: Create Map Features	68
Exercise 1: Draw a new parcel	68
Exercise 2: Add information about the new parcel	70
Lesson 5: Find Objects	71
Exercise 1: Display the Data Table	71
Exercise 2: Filter the Data Table	71
Lesson 6: Edit Objects	73
Exercise 1: Check out and edit a feature	73
Exercise 2: Update information for the edited feature	74
Lesson 7: Create a Legend	75
Exercise 1: Insert a legend object	75
Exercise 2: Change the order of items in the legend	77
Lesson 8: Publish Your Map	78
Exercise 1: Specify attributes to include	78
Exercise 2: Publish to DWF	80
Lesson 9: Branch Out - Find Data Sources	82
Exercise 1: Explore the Data Portal - DigitalGlobe®	83
Exercise 2: Explore the Data Portal - NAVTEQ™	84
Exercise 3: Explore the Data Portal - Intermap™	84
Exercise 4: Try out the sample data	85
Tutorial: Moving From AutoCAD to AutoCAD Map 3D	91
About The AutoCAD/AutoCAD Map 3D Tutorial	91
Lesson 1: Prepare Drawings for Use With AutoCAD Map 3D	91
Exercise 1: Set up a drive alias	92
Exercise 2: Georeference source drawings	94
Lesson 2: Clean Up Your Drawings	97
Exercise 1: Delete duplicates	98
Exercise 2: Extend undershoots	101
Exercise 3: Use cleanup profiles (optional)	104
Lesson 3: Add Drawing Objects to a Map	106
Exercise 1: Attach source drawings	107
Exercise 2: Preview attached drawings with Quick View	108
Exercise 3: Preview drawing objects with a property query	110
Exercise 4: Retrieve objects with a property and location query	113
Exercise 5: Query object data	116
Exercise 6: Create an object data index (optional)	119
Lesson 4: Add Raster Images	122
Exercise 1: Insert a raster image	122
Exercise 2: View image information	125
Exercise 3: Change the display order	127
Lesson 5: Modify Raster Images	128
Exercise 1: Adjust image brightness, contrast, and fade	128
Exercise 2: Clip the image	130
Exercise 3: Add a raster image to a Display Manager layer	133
Lesson 6: Share Your Map with Others	135
Exercise 1: Export a map to Autodesk SDF	136
Exercise 2: Publish a map to a DWF file	138
Tutorial: Classifying Drawing Objects	143
About the Classifying Drawing Objects Tutorial	143
Lesson 1: Set Up For Classification	144
Exercise 1: Set up your work environment	145
Exercise 2: Set up your user privileges	145
Lesson 2: Define Object Classes	147
Exercise 1: Create the object class definition file	147
Exercise 2: Define an object class	148
Exercise 3: Add object classes to the definition file	155
Lesson 3: Classify Objects	156
Exercise 1: Classify the signal objects	156
Exercise 2: Classify roads and parcels	160
Lesson 4: Create a Map Using Object Classes	161
Exercise 1: Create a map	162
Exercise 2: Assign a coordinate system	164
Exercise 3: Query in objects	166
Lesson 5: Create and Edit Objects Using Object Classes	167
Exercise 1: Create objects using object classes	167
Exercise 2: Edit classified objects	170
Lesson 6: Generate Metadata for a Classified Drawing	173
Exercise 1: View metadata	173
Exercise 2: Share metadata	174
Lesson 7: Use Object Classes When Exporting	176
Exercise 1: Export object classes to SDF	176
Exercise 2: Connect to the resulting SDF file	178
Exercise 3: Style the new feature classes	180
Object Classification: Best Practices	182
Tutorial: Creating a Map Book With an Inset	183
About the Map Book Tutorial	183
Lesson 1: Prepare the Map	183
Exercise 1: Create a map	184
Exercise 2: Add data to your map	184
Lesson 2: Customize a Map Book Template	186
Exercise 1: Change the printer/plotter for the template	186
Exercise 2: Resize the main viewport	188
Exercise 3: Modify the title block	190
Exercise 4: Replace the north arrow block	193
Lesson 3: Create A Map Book	194
Exercise 1: Create a key map view and a legend	194
Exercise 2: Specify the map book settings	195
Exercise 3: Preview and generate the map book	197
Lesson 4: Create an Inset	201
Exercise 1: Draw a viewport for the inset	201
Exercise 2: Change the information displayed in the viewport	202
Lesson 5: Publish The Map Book	203
Exercise 1: Set DWF publishing options	204
Exercise 2: Set background publishing options	205
Exercise 3: Publish the map book to DWF format	206
Tutorial: Analyzing Data	209
About the Analyzing Data Tutorial	209
Lesson 1: Analyze Data Visually, Using Surfaces	210
Exercise 1: Prepare your map file	210
Exercise 2: Add a surface to view elevation data	212
Exercise 3: Add a layer on top of the surface	217
Exercise 4: Drape a parcel layer on top of the surface	220
Lesson 2: Analyze Data With External Information Using Joins	222
Exercise 1: Set up an ODBC connection for an Access database	223
Exercise 2: Connect to the Access database	225
Exercise 3: Join the data from the ODBC source to the layer containing the parcels	226
Exercise 4: Use the joined data for calculated fields and styles	227
Lesson 3: Analyze Data by Proximity Using Buffers	228
Exercise 1: Create a buffer representing a construction zone	229
Exercise 2: Select the parcels within the construction-zone buffer	230
Exercise 3: Export the construction-zone parcels to an SDF file	232
Exercise 4: Compare the two parcel layers	233
Exercise 5: Export the data to CSV for use in a report	236
Lesson 4: Perform a Flood Analysis with Overlay	237
Exercise 1: Add the layers to compare	238
Exercise 2: Use an overlay to compare two layers	239
Exercise 3: Add and style a road layer	242
Exercise 4: Add emergency response points	244
Exercise 5: Find streets that are far from a hospital	245
Lesson 5: Automate an Overlay Operation with a Workflow	247
Exercise 1: Edit a workflow	247
Exercise 2: Complete the workflow definition	251
Exercise 3: Run the workflow	252
Tutorial: Managing Data From Different Sources	255
About the Managing Data Tutorial	255
Lesson 1: Convert Drawing Layers to Feature Classes	258
Exercise 1: Examine the original drawing layers	259
Exercise 2: Examine the object data	261
Exercise 3: Export the drawing layers to SDF - Select the layers	263
Exercise 4: Export the drawing layers to SDF - Map object data to feature class properties	264
Exercise 5: Export the drawing layers to SDF - Map drawing properties to feature class properties	267
Exercise 6: Export the drawing layers to SDF - Set export options	270
Lesson 2: Use the Resulting SDF Files	270
Exercise 1: Create a map	271
Exercise 2: Connect to the new SDF data	272
Exercise 3: Edit the schema	275
Exercise 4: Add a property	276
Exercise 5: Populate the new property with values	279
Lesson 3: Move SDF Data to a Different Geospatial Format	280
Exercise 1: Connect to a new SHP file folder	280
Exercise 2: Use Bulk Copy to move an SDF layer to SHP format	281
Lesson 4: Import SDF Files as DWG Layers	284
Exercise 1: Create a template for the imported material	284
Exercise 2: Import the SDF layers	285
Exercise 3: Use display layers to assign object properties	287
Tutorial: Working with Polygon Features	291
About the Polygon Features Tutorial	291
Lesson 1: Connect to Parcel Data	292
Exercise 1: Create a map	292
Exercise 2: Bring in the parcel data	293
Lesson 2: Split a Polygon Feature	294
Exercise 1: Define split/merge rules	294
Exercise 2: Find the parcel to split	296
Exercise 3: Split the parcel	298
Exercise 4: Examine the results	299
Lesson 3: Use Joined Data to Create Calculated Properties	300
Exercise 1: Set up an ODBC connection for a Microsoft Access database	301
Exercise 2: Connect to the Microsoft Access database	302
Exercise 3: Join the ODBC data to the Parcels layer	303
Exercise 4: Save the properties to a new data store	304
Exercise 5: Create a calculated property	307
Lesson 4: Theme Polygon Features	309
Exercise 1: Create a theme	309
Exercise 2: Add labels that use an expression	311
Lesson 5: Publish Your Styled Map to MapGuide	313
Exercise 1: Publish to MapGuide	313
Glossary	317