ورود داده از پایگاه داده اوراکل به سیویل تری دی
با سلام
در این پست به وارد کردن داده از پایگاه داده مکانی اوراکل به نرم افزار سیویل تری دی را داریم.
You can import data from a connected Oracle database into your map. Using this option, your data will be imported as drawing objects. The data will be a snapshot of your Oracle data. You can also make a live connection with Oracle (one where edits will go into the database).
Data you import becomes AutoCAD drawing objects in your map.
- To connect to the data in its original format, see Overview of Bringing In GIS Features.
- To convert the drawing objects to a geospatial format, see Overview of Converting and Exporting.
- To import from ArcSDE, see Importing From ESRI ArcSDE.
- To export to Oracle or ArcSDE, see Exporting DWG Data to an FDO Data Store.
To import data from an Oracle data source
- Before moving Oracle data into your map, assign a coordinate system to the map. This lets you position your data accurately in a real-world geographic location and align imported survey or GPS point data.
- In
Display Manager
, click DataConnect To Data.
For more information, see Using Features from an Oracle Feature Source
- At the Command prompt, enter mapimportfdo.
- In the Map Import From FDO dialog box, select the Oracle data source connection from which to import data.
- Click OK.
- In the Import dialog box, review the Current Drawing Coordinate System to make sure it is correct.
- Under Spatial Filter, specify whether to limit the area where data will be imported:
- None — Place no area limits on the incoming file.
- Current Display — Limit the import to the current drawing area.
- Define Window — Limit the import to an area you define. To use this option, click Select. Respond to the prompts to define the area.
- Specify the import settings for each input layer:
- Drawing Layer— Select a target layer for each layer in the incoming file.
- Object Class— Assign incoming objects to an existing object class and map incoming attribute data to the data fields in the object class. The Object Class fields are available only if you have object classes defined in your Map drawing. For more information about setting up object classes, see Setting Up Object Classification.
- Input Coordinate System— Specify the coordinate system of the incoming file. If the ProdName drawing has a coordinate system assigned to it, incoming objects are converted to the coordinate system of the drawing.
- Data— For each layer, specify how to import data.
- Points— For each layer, specify how to treat incoming point objects.
- By default, polygons are imported as polygon objects. To import them as closed polylines, select Import Polygons As Closed Polylines.
- If you assigned incoming objects to object classes and want to use the object class defaults for any incoming data that is
out of the defined object class range, select Use Class Defaults For Out Of Range Values.
If you do not select this option, incoming data will be imported as is, which may include some out of range values. If you later view the data on the Object Class tab of the Properties palette, ProdName automatically modifies the data, using defaults as needed, so that the data is in range and properly classified.
- To save your settings as a profile, click Save. These saved profiles can be loaded when you import other files, and they can be used to automate command-line scripts.
- Click OK to begin the import process.
If you cancel the import operation, all objects imported prior to canceling will remain in the ProdName drawing. You can delete these objects and any associated data.