Join Gordon Luckett for an in-depth discussion in this video Connecting to a database, part of AutoCAD Map 3D Essential Training.
- Connecting the databases is an extremely powerful way to get information into your drawing that you or your department does not maintain. For example, you may want to attach billing information to your drawing directly from account receivables to each customer point on the map. In this lesson, you will learn how to attach a database to your current drawing, let's do that now. I'm going to drag and drop an Access database into a blank drawing. I have the zoning.mbd file, I'm going to drag it into the Map Explorer, hit TASK PANE. Once you drag and drop it in, you'll see it automatically forms a data connection, called Zoning.
You'll see the table called Zoning is now inside. By double clicking on it, you will see a table inside of the Access database, right inside of your AutoCAD Map window. By double clicking the ZONING header, you can sort alphabetically, or alphabetically inversed. Same with the PARCEL ID, ordered or reverse ordered, by double clicking. We can also filter this data, for example, if I click on the SQL Filter, I can filter by the column under the Where condition, or the ZONING equals, and I can type something in here, or click the browse button, deliminated by three dots.
This will give me a distinct list of all the ZONING in that particular column. If you scroll down to the very bottom, you will see UR, let's pick that, and click OK. I'll add this to the query, you'll see ZONING=UR, and you'll click OK. Now you will see the only data listed in your Data View are UR. Let's go back in and search for something else. Click on the SQL filter, we're gonna delete the previous SQL filter, under Work Condition, you'll change your column to ZONING.
In this case, we're going to change the Operator to LIKE, so we're not going to use the equal sign, we're going to use LIKE, so we can get something LIKE what we're looking for. We want all the residential. It just so happens that all the residential, starts with a capital R and a period. And to get everything that begins with a capital R. period, you have to put a percent sign %, that's a wild card. Once you've done that, click add, you will see, ZONING LIKE R.%, click OK to filter.
Now you can see ZONING is now filtered by R. Double click on ZONING to see all the different types. For example, at the top you see R.1A You scroll through, the last one is R.4D Now that you've seen how to attach databases, you may now have many databases you wish to connect at your organization, and now you can. Depending on your user name and password, you may also be able to edit that data too.
- 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