- Connecting a database to AutoCAD features…is completed with link templates.…But for GIS vector data, creating a join to another database…is done with a GIS join.…In this lesson you will learn how to connect…an ODBC database to an SDF data source.…Let's do that.…If I drag the PARCELS_JOIN.sdf into my session.…There's the parcels.…But I need to connect to this Access database called,…"zoning_join" now unfortunately,…I can't drag and drop it into my current session,…I have to create an ODBC connection to join to this.…
I'll do that now.…So let's search for "run" and we'll type "odbcad32"…which is a shortcut to the ODBC administrator.…You can access this through the administrative tools.…Let's click add, we'll pick Access Driver, Finish.…We'll just call this "PARCEL_JOIN"…Browse to that chapter 10 exercise, pick on zoning_join.…So we have zoning_join.mdb, PARCEL_JOIN, we'll hit OK.…
There's PARCEL_JOIN, and OK.…So we're done with ODBC.…Now what we can do, we've got PARCELS,…we can go Data, Connect to Data…and this time we'll pick on the…
Author
Gordon Luckett
Released
10/31/2014- Creating object data definitions
- Modifying object data
- Attaching source drawings
- Performing queries
- Adding images
- Styling drawing data
- Importing and exporting GIS data
- Connecting to GIS data
- Styling, editing, and analyzing GIS data
- Merging and splitting GIS data
- Using coordinate systems
- Publishing map books
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome38s
-
-
1. Adding Your Own Data Attributes
-
Modifying object data1m 46s
-
2. Connecting Databases
-
Connecting to a database2m 43s
-
-
3. Using Project Drawings
-
Attaching source drawings2m 10s
-
Performing location queries2m 43s
-
Performing property queries1m 44s
-
Performing database queries2m 27s
-
-
4. Adding Images
-
Adding raster images1m 14s
-
Modifying raster images1m 42s
-
-
5. Styling AutoCAD Objects
-
6. Importing and Exporting GIS Data
-
Importing GIS data1m 56s
-
Exporting GIS data2m 16s
-
-
7. Connecting to GIS Data
-
Connecting to raster data2m 48s
-
Connecting to ODBC points2m 26s
-
8. Stylizing GIS Data
-
Stylizing vector layers3m 49s
-
Adding scale dependence2m 24s
-
Filtering vector layers3m 20s
-
Stylizing raster layers2m 2s
-
-
9. Editing GIS Data
-
10. Analyzing GIS Data
-
Understanding GIS joins3m 47s
-
Working with buffer analysis1m 43s
-
-
11. Merging and Splitting GIS Data
-
Splitting GIS data2m 9s
-
Merging GIS data2m 3s
-
-
12. Using Coordinate Systems
-
Assigning coordinate systems2m 16s
-
Reprojecting AutoCAD data1m 59s
-
Reprojecting GIS data1m 44s
-
-
13. Publishing Map Books
-
Publishing a map book4m 30s
-
-
Conclusion
-
Next steps44s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Understanding GIS joins