High number of export files about 3dcitydb HOT 6 CLOSED

Note, that in order to visualize the glTF output files (tiled or untiled), the 3DCityDB web map client must be used. I don't think that the vanilla CesiumJS code supports the loading of our files. The 3DCityDB web map client has specific extensions, which I guess, are not available within the masterportal.

However, there is another open source project called "py3Dtilers" that directly connects to a 3DCityDB and is able to produce 3Dtiles datasets. These can be directly consumed by any CesiumJS based viewer. Hence, it should work with the masterportal. The project can be found here: https://github.com/VCityTeam/py3dtilers

from 3dcitydb.

For common tasks like moving files to a server or network share, that can take very long with many small files, I can recommend to create some kind of archive (zip, tar.gz, 7z, or any other), move the file to the server and extract it locally on the target system using SSH.

from 3dcitydb.

Thanks @thomashkolbe, this link was very helpful. Its marvelous. Would be great, when it could be integrated.

One thing, that is missing, that 3dcitydb has is to set the buildings on zero elevation, not the ground elevation.
Is there a command in in 3dcitydb that I can apply a corrected elevations in the database (postgis) myself?

While I am at it. I wanted to remove some buildings from the db, because the are still in the citygml, but don't exists anymore or are going to be destroid very soon!
How can I select the buildings to be remove? I was able to find the gml:ids in the table cityobject. Is it possible to only remove the ids, or do I have to recursively remove some child objects?

from 3dcitydb.

Here is an answer to your second question: please check the manual here:
https://3dcitydb-docs.readthedocs.io/en/latest/3dcitydb/sproc/citydb-delete.html
There are stored procedures which you can use to delete CityGML objects including all their sub objects based on gml:ids of the toplevel object (e.g. some buildings).

Regarding your first question: as far as I know we do not have scripts in the 3DCityDB to move all objects down to a zero height level. This is normally also not what you want to / should do. Since this is mostly required for visualization our export tool offers the possibility to automatically adjust the elevation to zero, but this is only reflected in the exported visualization models. Maybe the py3dtilers software offers such an option. If not, I suggest to create an issue with a feature request for their software. Alternatively you should consider exporting the corresponding digital terrain model. We have also a software that can easily generate QuantizedMeshes as required by CesiumJS from DTM data: https://github.com/tum-gis/cesium-terrain-builder-docker

from 3dcitydb.

Thanks.
I also found a parameter to exclude buildings in citygml-tiler working well.
I can manually correct the offset, too. So hence I can not set it to sea level but hat least on the ground.
I think, this thread can be closed.

I would just like to kindly ask to link to py3dtilers, because I never found this by my own.

from 3dcitydb.

Good point, we will add a link to py3dtilers to the homepage (we have to update it anyway).

from 3dcitydb.