how to save object properties as an attribute in oracle?

[Anonymous]

Hi! I am new one to ACAD Map 3d and ACAD family always confused me.

I prepare bunch of project in ACAD Map 3d with oracle db as datasourse. And we have lot of DWG to load in this db.

The Question is how can i save object properties like layername, linetype, blockname, etc., as attributes of feature in oracle table? 

Of course manual filling of fields is not suitable. Thanks for answers 🙂

[Anonymous]

Hi,

how do you itend to load your drawings into Oracle?

What is the purpose and how will you use the data when it is stored in Oracle?

Rob

[Anonymous]

Rob, briefly, oracle db is single spatial data store for city planning department. Users conect to this db with different gis soft like qgis, mapinfo.
As u know, dwg don't have an attributes and our dwg plans and maps contains only lines and poly's with different colors and linetypes. This properties needs to divide objects by type and fill attributes later, maybe in other gis with queries etc.
As users, who work with Autocad, said they used 'New Feature from Geometry' to load into oracle fdo connection.

[Anonymous · Accepted solution]

Hi,

so, AutoCAD Map users store data in Oracle using "New Feature From Geometry".

Going this way you cannot save AutoCAD properties in Oracle (at least not with out-of-the-box functionality).

Im just wondering how the whole workflow is in Map. From your initial posting I thought you want to take multiple drawings and store all of their content in Oracle Spatial. Now it looks like that only few CAD objects are converted to Oracle Spatial features through FDO provider.

If you need to store additional attribute data from CAD elements in Oracle using Map - here is one approach (which I haven't tested):

- export your AutoCAD drawing features as SHP or SDF, command: _mapexport, in Map export options you can choose CAD entity properties such as layer name etc. to be exported as well

- copy / load your SHP files into Oracle:

  (1) using Map FDO Bulk Copy

or

  (2) Map's "Convert to Industry Model" (but this requires that you set up an Map Industry Model in Oracle)

or

  (3) use other tools such as Oracle SHP loader or GDAL

It is probably not what you want - but if you tell me bit more about your workflow than I might have other suggestions.

Rob

[Anonymous]

 i am not familiar with workflow so close, because it's a new implemented system (with oracle store). As i see situation: users worked with ACAD before with no attributes, only drawings. Now they need to load this drawings into system and continue use ACAD in works, but with oracle store. 

So, for only single load GDAL or FME fully fit.

The root of the problem is we can't find an analog of domains from ArcGIS or Dictionaries from Geomedia - way to fill attributes fields from dropdown list in ACAD Map 3d. But it possible to choose line style for one of objects types. It is a bit strange decision 🙂 So maybe it would be easy to help with this.

I hope you are not confused by the final. And sorry for English in case any mistakes.

[Anonymous]

Hi,

I'm not 100% whether I understood completly.

"The root of the problem is we can't find an analog of domains from ArcGIS or Dictionaries from Geomedia - way to fill attributes fields from dropdown list in ACAD Map 3d. " - you can do that with Map Industry Models.

For each feature class you can have a form. Your form can contain drop down lists where the user picks values. You can set default values for a new feature.

Now - the drawback is that Map Industry Models have some complexitly and you need to set them up. Initial work needs to be done before you can use the advantages of IMs.

Have you looked at IM as an option?

You can create your own IMs easily - Map comes with some pre-configured IMs for certain industries but with Map-Administrator you have a tool to create your own models. 

Rob

[Anonymous]

That's why I don't like Autocad. Looks too complicated.

Ok I will look about Industry Model. Thank u for answers and advices Rob

[scheel]

Hi,

Rob is right - industry models inside of AutoCAD Map 3d is a possible solution, also working with Domains like in ArcGIS.

1. You can use mapexport to create shp-files or sdf-file with exporting all properties you want.
2. Then you can Import this data into a configurated industry model using temporary fields.
3. Next step is then working with filtering and global assigning of values to normalized the values to the Id's of the Domains.
4. And now you are finished or you can copy it to any fdo Oracle source using bulkcopy and you have coded it to the Domain
   using there.

There is a also important Point. Please have a look for the coordinates and the System they are defined. Thats a Point for all GIS System.

AutoCAD vanilla is no GIS Sytem and so the users often did not recognize this.

You say it looks complicate, but mention, that you mix two issues. One to Transfer CAD-data to GIS and second coding the values

to a given Domain. After you have transfered it to a industry model you have a real gis System and after this step you have the same easy

possibilities as in ArcGIS.

Thorsten Scheel

Contelos GmbH