Join between objects in INFRAWORKS with external databases

[scheel]

Join between objects in INFRAWORKS with external databases and showing the data in tables or dialogs.

The process to join could be like in Map 3D, where you need a second FDO-connection.

This connect can stay without a graphical representation.

Then ceating a join between both data sources and select the matching properties.

After that you should see the joined data in a table or a defined dialog.

The mechanism of joins give more flexibility in data sourcing and analysing.

[Eric_Chappell]

Can you share an example where you might use this capability?

[scheel]

Example 1: (1:1 relation)

Parcels imported from a shp file with only a few properties like the parcel no, the area and the using.

In a SQL Server table we have much more properties for the parcles with the possiblility to join over the

parcel no. The SQL table is modified over a third parts program and it self has no geometric Information.

The additional data could be the owner, the value etc.

Example 2: (n:1 relation)

Street lights of different types. In a second table you find more data to the specific types, each as a row.

In that example you have for example 20 street light of type one and 34 of type two.

Both types has properties of power, longlife etc.

Example 3: (1:n relation)

Street lights have to bee washed, light chanced etc. There is a table with every step happens for every street light.

You can see the steps for a specific light.

Trees and there inspection

etc.

You see there are many examples in different situations.

Thorsten

[Eric_Chappell]

I've asked the product team to take a closer look at this....stay tuned.

[Anonymous]

This is critical for our continued adoption of Infraworks. GIS databases such as CityGML and Spatial Data are critical in every day operations, and having the ability to edit these databases in Infraworks, and then sync them back is very important. 

For example: I may be planning to develop a new area. In the desired scenario, I would connect to my CityGML data source, create new roads, trees, sewers and housing areas, sync back to the CityGML data source. This would mean that the other apps that are connected to the CityGML data source automatically get access to the new objects, and can "tag/reference" them. For example, a discovered leak could make reference to the newly developed sewer line, or a new security report could be tied to a newly built house. Think of a Leica Realcity -> CityGML -> ArcGIS cityengine <> Infraworks <> MSFT PowerApps MSFT WorldGraph and BingMaps Spatial type of integration. Sounds powerful? It is. And the only peace of the pipeline that is missing is having streamlined engineering capabilities that could be unlocked with Infraworks.

This is an interconnected world, and having one single database is critical. 

In addition, having features such as grass, trees, roads, buildings in CityGML 3.0 would make the model much lighter.