Errors on importing CityGML models generated by FME

[zhangjw5]

Hi,
I am writing my graduation thesis, "Based on CityGML 3DGIS Application Studies", I use the 3DCityDB Importer Exporter tool to import my own CityGML data into the 3DCityDB database, but it is wrong to show Failed to resolve XLink reference '# fme-gen-3010b1e6 -9537-4a87-8e67-f72ebcf0b4f3 ', I feel very depressed, how can I do?
Best Regards,
Jingwen

[clausnagel]

Your dataset contains an xlink:href reference to an object with a gml:id of value fme-gen-3010b1e6-9537-4a87-8e67-f72ebcf0b4f3, but there is no such object in the dataset. Thus, the reference cannot be resolved and consequently no data can be imported.

This seems to be a data issue in the first place. Please fix your dataset.

[FxKu]

Ha, Claus was faster :)

• Are there whitespaces in your XLink target ID? I see at least three. Maybe this causes the problem.
• Which version of the 3DCityDB and FME (?) you are using?

[zhangjw5]

Thank you for the enthusiastic help,
my citygml data is converted by the BIM data through the FME tool, when I use the FME tool to view the CityGML data, the display of gml_id can not be found in the file, import to 3DcityDB gml_id is also different.
When I see my original data, did not find XLink target ID have the space,
3DCityDB version is 3.3.0, FME version is 2017.0.0.2

[zhangjw5]

This is part of my data and FME display:

[clausnagel]

@zhangjw5 can you share your CityGML file for testing?

[zhangjw5]

Thanks for your reply,
Of course, this is my experimental data.
http://pan.baidu.com/s/1o7D3GU2

[clausnagel]

Thanks for sharing your dataset.

The dataset contains a lot of gml:MultiGeometry elements. CityGML supports the use of gml:MultiGeometry at few places, for instance, as geometry for gen:GenericCityObject or grp:CityObjectGroup features. So the dataset validates against the CityGML schema.

However, the 3DCityDB lacks support for gml:MultiGeometry. That's why the geometry is not imported and why XLink references cannot be resolved. The latest version 3.3 of the Importer/Exporter logs a corresponding error message when importing your dataset:

[16:20:35 ERROR] GENERIC_CITY_OBJECT 'UUID_cbed4c39-917f-4e5b-b4b1-c39e7a138862': Unsupported geometry type MULTI_GEOMETRY.

To solve this issue, you have to change your FME process to write another geometry type such as gml:MultiSurface instead of gml:MultiGeometry.

[zhangjw5]

Yes, thank you very much!
I tried to import another model and successful, and export the gml file is also open.
However, there have a new question: when I export the date for KML / glTF, it exports nothing.
Then I checked the column ENVELOPE of the table CITYOBJECT,
It is null, I tryed and recalculateed all values using the Importer / Exporter tool,but it did not work.
What should I do?
I have a little bit of puzzles that I import into the database that many properties are null, but exporting the CityGML model in the FME view is correct.
This is my data:http://pan.baidu.com/s/1slxyXCL

[yaozhihang]

I have tested the KML/glTF export of your shared data using both Oracle and PostGIS databases. Everything worked fine on my machine.

A successful KML/glTF export requires a number of parameter settings which are explained in detail in the 3DCityDB documentation. For a quick start, a step-by-step hands-on tutorial is very helpful.

[zhangjw5]

Thanks, listen to your suggestion, I once again read the document carefully and try again,
I think maybe because of my SRID set up a problem, so it's shown like this:

This is my SRID and URN settings:

GML file is set as follows:

[FxKu]

Hey,
so your file has the SRS 25833 and your 3DCityDB has 31467? Well, this does not fit together. You can change the database's SRID with the stored procedure change_schema_srid (see documentation - only update metdata - do not transform the coordinates as they are 25833). Then buildings should be placed correctly (only if the source data is correctly referenced, of course).
Cheers

[zhangjw5]

I am very sorry, this is my mistake, I figure the wrong data, in fact, the data screenshots are like this:

Looking forward for your reply, thank you！

[zhangjw5]

Hi,
I found the problem is not SRID, which is due to Google Earth's 3D building display simulation shows the problem.
Data export KML format still can not show, although I have all the models involved in the building properties are set, but still useless. I hope you can get your guidance, what should I do?

[yaozhihang]

Make sure that the parameters on the Altitude/Terrain panel are set as follows:

Run the KML export again and load the exported KML files into Google Earth Pro. You also need to disable the Google Earth's "Terrain" and "3D buildings" layers

[zhangjw5]

Thank you very much,
I tried again and again, the result is:

And I tried another way and the result was wrong:

What method can I use to correct the model？

[LoveNile]

I also encountered the same problem,would you solve it?

[zhangjw5]

Sorry, I can not give you the right advice, although the exported KML file is like this, but I tried to open the file in 3dcitydb-web-map, the result is like this：

[rezamolkara]

Hi everybody
I have problem to export to citygml.
I use FME and my data is shp.
When I import my gml data to 3DCityDB it says valid but when I export data to kml it was wrong in shape and location. My coordinate system is WGS 84 , UTM SIRD 4326.

When I import data to 3DCityDB it imports data but show this warning:
[10:41:39 WARN] gml:LINEAR_RING (unknown gml:id): Linear ring is not closed. Appending first coordinate to fix it.
This is my SRID data:

this is my data:

But in the 3DCityDB it shows my boundaries coordinate like this:

And the exported data to kml is like this:

Any body help me?

[rezamolkara]

I solved it gays.

Thank U;-)

[rezamolkara]

Hi gays,
I have problem by importing building gml format to 3DCityDB.
This is my data:

CevreSelected1.txt
It's shows this error:

[14:17:47 ERROR] BRIDGE_WALL_SURFACE 'GML_': Skipping import since this is not a top-level feature type. 3dcitydb

Thanks.

[FxKu]

Forgot about this one. As the log message said, you got features in your data which are encoded as top-level feature, but by the CityGML schema they are not. In your case, you are missing the bridge.

Incorrect:

<core:cityObjectMember>
  <bridge:WallSurface ...
  ... wall attributes
  </bridge:WallSurface>
</core:cityObjectMember>

Correct:

<core:cityObjectMember>
  <bridge:Bridge ...
  ... bridge attributes
    <bridge:boundedBy>
      <bridge:WallSurface ...
      ... wall attributes
      </bridge:WallSurface
      ... more walls, roofs etc. to come here
    </bridge:boundedBy>
  </bridge:Bridge>
</core:cityObjectMember>

Hope this can help you. How did you create the CityGML file, btw?

[rezamolkara]

Hi sir Thank you for yor answering. I used FME Desktop. If it possible say me how can I make true CityGML 3D format. By which software. Best regards.

[FxKu]

You can use FME for that. I'm not familiar with it, but it seems you just forgot to add the bridge feature. Should be easy to fix.

[FxKu]

This is a well known issue :)
Please, take a look at issue #28

[yaozhihang]

Could you open your CityGML dataset using FME Data Inspector and check, if the same rendering problem also occurs?

[FxKu]

To me, it looks like the order of ordinates is somehow flipped ... so not XYZ but ZYX or ZXY. I think, there is a transformer in FME to change the order of ordinates.

[clausnagel]

Maybe the FME 3D Solution Templates are a good starting point: http://www.virtualcitysystems.de/en/news/480-3d-solution-templates-now-available-in-the-fme-hub

[anwar1010]

When Set Geo-location in SketchUp and then I convert SketchUp file using FME desktop. it cannot add a coordinate system in XML or GML file. Because of the coordinate system, I am unable to import or export data using 3DCity DB importer-exporter

this is the FME for SketchUp to XML converter file for lod3.
@clausnagel

skp2citygml_v1222.2 (backup).zip

[Waji504]

Hi,
I am working on my graduation final year project , "Based on CityGML 3DGIS Application Studies", I use the 3DCityDB Importer Exporter tool to import my own CityGML data into the 3DCityDB database, but it is wrong to show Failed to resolve XLink reference '# fme-gen-72e95666-c183-4dbf-a9cb-2fb8ebfe17ad', I feel very depressed, how can I debug such type of errors ?
Best Regards,
Wajid Ali

[FxKu]

Hi Wajid,
Please, check our comments in this thread as your error report sounds "exactly" like the first post. If this does not help, you can still share a sample dataset so that we can reproduce the error and provide help. But, I'm sure you can already solve it on your own if you reed the comments such as:

To solve this issue, you have to change your FME process to write another geometry type such as gml:MultiSurface instead of gml:MultiGeometry.

Good luck.

[Waji504]

Sir,
DO you have any documentation where all the process of creating sketch up model and make a citygml through (citygml2citygml_coordinateSystemChange.fmw) file and import it on the db importer exporter.

[FxKu]

Not really, sorry. See issue #34 where we gave some hints on converting SketchUp models.

[clausnagel]

If the XLink reference cannot be resolved, then either the referenced object does not exist in your dataset or the reference itself is bad (at least there shouldn't be a blank after the hash). As @FxKu wrote we can check your dataset if you share it.

For questions and bugs related to Sketchup or FME processes, please contact the corresponding support teams.

[anwar1010]

When I am trying to select a specific region in SketchUp EPSG 24313 it will select the whole region.

[FxKu]

Dear @anwar1010 . This issue has been closed already. Please open a new one referring to the bounding box "error" and I will provide an answer :)