Hi all,
We have a requirement where we need to be able to query table records (with a spatial data column) that don't yet have any spatial data. Then to a specific record, then post the spatial data for this record either from existing dgn elements (inferred xfm), or by creating new xfm geometry. Essentially adding the graphical information is the last step in a list of processes to populate the database. Presently this done in Geomedia, but we're hoping to accomplish this in Bentley software as this is where the graphical information originates.
I cant see a way of even displaying/quering the database directly, only by using the 'Data Browser' which only shows the graphical entities.
Any pointers in the right direction to accomplishing this would be appreciated.
Many Thanks,
Jim
I can not think of any way out of the box to do this. You may need some customization. Basically:
1. Select the record from the table.
2. Select the existing graphic.
3. Create feature instance from both.
4. Set the change tracker to modified feature instead of new feature.
4. Post the changes.
If the Spatial system is Oracle, then you could use the DGN2SDO tool to place the geometry into the spatial database. You would still have to link the geometry , now in the spatial db to the business attributes.
As Jerry correctly comments, there is currently no out-of-the-box way to accomplish using standard Bentley Map functionality. This workflow can however be accomplished with some customization that makes use of the Bentley Map API. The basic approach is as follows:
If interested in learning more, please let me know and we can discuss additional details offline.
Regards,
Jeff Bielefeld [Bentley]
doesnt the promote feature do this to a dgn element so its now feature ?
Lorys
Started msnt work 1990 - Retired Nov 2022 ( oh boy am I old )
But was long time user V8iss10 (8.11.09.919) dabbler CE update 16 (10.16.00.80)
MicroStation user since 1990 Melbourne Australia.click link to PM me
Jeff,
My apologies for being a little quiet. Thanks for the pointers, I was hoping it may be a case of writing a custom SQL 'update' query on the feature 'create' operation of the XFM feature, but it looks like it may be a little more involved than that.
Am I correct in thinking there is no way to do this via an sql update with the geometry with an xfm create command is issued?
pseudo:
UPDATE cadastre SET GeomCol = <created_xfm_element> WHERE lot_id = <some_xfm_property>;
I'm yet to get my hands dirty with the BM api, but it looks like this may be an opportunity to have a look at it. The steps you've detailed make sense.
The way I envision it working is into a listbox dump all the non-graphic feature instances for the user to select one. With a row selected, and an element selected a button pressed would associate the geometry to the record, and hopefully a post operation will post the record(s) with the amended graphical feature.
many thanks,
edit: Any chance of getting this functionality included in the product. I would have thought that this would be useful to most organisations that are maintaining a spatial database. Either as a way to initially create geometry, or to update/replace geometry. The only real piece missing from the software is the ability to 'browse' the data-source by non-graphical means (view, fence, etc). I would have thought that the actual query in the background is probably returning the records without geometry anyway.