Import File Geodatabase

In this tutorial, you will be importing data from Munich, Germany.

1.Create a new Adobe Illustrator document in portrait orientation.

2.Using Import or Multiple Data Import, choose the Basic File Geodatabase Reader [*.gdb] format and click Browse. Navigate to the Tutorial Data folder and select Bavaria.gdb and click Select Folder.

3.In the Import dialog box, click the Connect and choose feature classes link.

4.In the Select Feature Classes dialog box, click the Bavaria feature class to select it, then click OK.

bavaria

importfilegdb

5.Click OK to import the feature classes.

munichplaced

The imported data is the area boundary of Bavaria, a state of Germany. Next, you'll import an additional feature class using an SQL Query to limit the amount of features imported.

6.Use Import again to choose feature classes from the Bavaria geodatabase. In the Select Feature Classes dialog box, choose the SQL Query option and click Create SQL Select Query.

7.In the Create SQL Select Query dialog box, enter the following query: SELECT  *  FROM  Bavaria_cities  WHERE  Bavaria_cities.POP_RANGE ='75K to 250K'

createsqlquery

The SQL query states that it will select all features from the Bavaria_cities point layer that has a population range attribute equal to 75K to 250K. Click the Validate button to verify that the SQL was properly entered.

8.Click OK. Click OK again to close the Select Features Classes dialog box.

importsqlquery

Notice how the Feature Classes status is listed as "SQL query".

9.Finally, click OK to import the features.

10. In the Matching MAP View Found dialog box, make sure Add to: Bavaria is chosen and click OK.

matchingmapviewbavaria

citiesimported

The Bavaria_cities_point layer is added to the map. Only five points are added. Open the MAP Attributes table to view the cities and their population to verify that the SQL query entered returned the correct results. Next, you'll import one more feature class using a spatial filter.

11. Use Import again to choose feature classes from the Bavaria geodatabase. In the Select Feature Classes dialog box, select Major_routes in the Select Feature Classes list and click Specify Spatial Filter.

12. Make sure the Intersects option is chosen as the Relationship. Choose the Set points manually option and enter the following Corner and Opposite Corner coordinate values:

Corner: Long: 9.75, Lat: 49.85

Opposite Corner: Long: 12.25, Lat: 48.65

specifyspatialfilter

The Intersects relationship option specifies that only data that intersects the spatial filter boundary will be imported.

13. Click OK to confirm these values. Click OK to close the Select Feature Classes dialog box, and finally OK to import the features.

14. In the Matching MAP View Found dialog box, make sure Add to: Bavaria is chosen and click OK.

matchingmapviewbavaria2

importresult

The feature classes are successfully imported using extent specified by the spatial filter.

15. Close the document without saving.

Copyright © 1995-2020 Avenza Systems. All rights reserved.

 

Last updated: 12/2/2020