Not all datasets are stored in a GIS. In this video, Gordon attaches an external Microsoft Access database to a GIS file using the common field called Parcel_ID.
- [Instructor] Connecting a database to AutoCAD features…is completed using link templates,…but for GIS vector data, creating a join…with another data source is called a GIS join.…We're going to learn how to connect an ODBC data source…to an SDF data source.…First, let's add the parcels join SDF to our current map.…Next, we're going to create an ODBC connection…to that parcel database.…
It's a 64-bit ODBC connection.…We'll click on System DSN, click Add,…make sure you pick Microsoft Access Driver mdb accdb,…click finish.…We'll call this parcel join.…We'll browse to our dataset under C, on our desktop.…Zoning join, there it is.…Click okay and parcel join appears and click okay.…
The next step is, now that we have that,…we have to connect to that ODBC connection.…So we go data, connect to data, pick on ODBC.…Again, we'll call it parcel join.…And the data source, we'll browse,…and sure enough, there's the parcel join we just created.…And click test, no password on that database.…If we were connecting to an enterprise database,…
Author
Gordon Luckett
Released
11/9/2018- Creating object data definitions
- Modifying object data
- Connecting to a database
- Using project drawings
- Performing queries
- Adding images
- Styling AutoCAD objects
- 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 Beginner
Duration
Views
-
Introduction
-
1. Adding Your Own Data Attributes
-
Modifying object data2m 34s
-
2. Connecting Databases
-
Connect to a database4m 19s
-
-
3. Using Project Drawings
-
Attaching source drawings3m 52s
-
Performing location queries4m 53s
-
Performing property queries2m 39s
-
Performing database queries3m 44s
-
-
4. Raster Images
-
Modifying raster images2m 7s
-
5. Styling AutoCAD Objects
-
6. Importing and Exporting GIS Data
-
Importing GIS data3m 21s
-
Exporting GIS data4m 12s
-
-
7. Connecting to GIS Data
-
Connecting to raster data3m 54s
-
8. Stylizing GIS Data
-
Stylizing vector layers6m 30s
-
Thematic vector layers5m 9s
-
Adding scale dependence5m 47s
-
Filtering vector layers4m 21s
-
Stylizing raster layers2m 46s
-
-
9. Editing GIS Data
-
10. Analyzing GIS Data
-
GIS joins4m 25s
-
Buffer analysis3m 6s
-
Overlay analysis3m 14s
-
Calculated properties2m 27s
-
-
11. Merging and Splitting GIS Data
-
Splitting GIS data2m 51s
-
Merging GIS data2m 29s
-
-
12. Using Coordinate Systems
-
Assigning coordinate systems2m 58s
-
Reprojecting AutoCAD data3m 45s
-
Reprojecting GIS data2m 19s
-
-
13. Publishing Map Books
-
Preparing a map book3m 9s
-
-
Conclusion
-
Next steps33s
-
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: GIS joins