I'm using Map 3D 2012 with Oracle 11g. I created an enterprise project with an industry model with water and wastewater modules. After this i created my feature classes and defined the utility model linking the geometry feature class to the attribute ones (ex: WA_POINT to WA_ARMATURE, WA_VALVE, WA_HYDRANT etc.).
At this moment i have to import a large amount of data from *.shp or *.sdf files, but theese files contain geometric and attribute data together.
How can i import the geometry from the shp or sdf file to the geometry feature class (ex: WA_POINT) and the attributes to the attribute feature class (ex: WA_VALVE), while creating the reference between the geometry and attribute feature classes?
I tried bulk-copying the geometry, but it doesn't create the coresponding attribute feature.
Solved! Go to Solution.
do you want to migrate the SHP files into your industry model? If so - take a look at "Enterprise Industry Model Data Transfer". It allows migration of any Oracle data into an industry model.
You would need to import your SHPs first into Oracle. You can use SHP import tools or even Bulk-Copy in Map might work. For Bulk Copy - create a new data store in oracle using the Map oracle provider, don't use the Enterprise data provider.
After importing the SHPs into Oracle you use the Data Transfer tool in Map to get the data into the right structure (= industry model).
More information can be found here:
Thanks again for your help! It worked great.
I bulk-copied the shp files in a temporary industry model, then i used Oracle Data Import from Infrastructure Administrator to migrate the data to the final industry model.
I created the link between the geometry and the attribute features with a post SQL in the mapping definition.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.