# Execution Times

## Dataset

Swiss | LoD3 | Untextured | CityGML2

### File name

swissbuildings3d_3_0_2021_1166-41_2056_5728.citygml.gml

### Data Source

[https://www.swisstopo.admin.ch/de/landschaftmodell-swissbuildings3d-3-0-beta#swissBUILDINGS3D-3.0-Beta---Download](https://www.swisstopo.admin.ch/de/landschaftmodell-swissbuildings3d-3-0-beta#swissBUILDINGS3D-3.0-Beta---Download)

### Data Size

513MB (Uncompressed)

## Platform

Kendir's Notebook > Docker Container (citydb-visualizer)

> "--shm-size" option is not used.

## Contents

Buildings : 5,108 + 134

Total Features Number : 23,366

### Special DB Maintainance:

```sql
-- select * from property where name like '%predicate%'
/*
UPDATE property SET name = 'predicate'
WHERE  name like '%predicate%';
*/
```

### Terrain

> Located at south west corner of the Bern city center

Source: [https://www.swisstopo.admin.ch/de/hoehenmodell-swissalti3d#swissALTI3D---Download](https://www.swisstopo.admin.ch/de/hoehenmodell-swissalti3d#swissALTI3D---Download)

Tiles : 
- swissalti3d_2025_2595-1198_0.5_2056_5728.tif
- swissalti3d_2025_2595-1199_0.5_2056_5728.tif
- swissalti3d_2025_2596-1198_0.5_2056_5728.tif
- swissalti3d_2025_2596-1199_0.5_2056_5728.tif
- swissalti3d_2025_2597-1198_0.5_2056_5728.tif
- swissalti3d_2025_2597-1199_0.5_2056_5728.tif

## Import Time

Import Time with citydbtool : 15 s

## Tiling Tasks

### Advice Command's execution time (in python venv):


- For single tileset : 0.4 s
- For separate tilesets : 0.7 s


### Used Commands and their total execution times :

1. *Single Tileset* : tile : 9 s
2. *Separate Tilesets* : ```--separate-tilesets objectclass tile``` : 15 s
3. *with custom CSV* : ```tile --custom-style tum_colors.csv``` : 11 s
4. *Property-based Color Set* : ```tile --style-mode property-based``` : 13 s
5. *Separate Tilesets* & *Property-based Color Set* : ```--separate-tilesets objectclass tile --style-mode property-based``` : 24 s
6. *Transparency Mode*: ```tile --transparency blend``` : 8 s
7. *to a Custom Folder*: ```tile --output-folder``` : 8 s
8. *No Style Mode*: ```tile --style-mode no-style``` : 8 s
9. *Selected Attributes in tabular format*: ```--separate-tilesets objectclass tile --style-mode property-based --attributes selected --selected-attributes core_name,gen_objektart``` : 16 s
10. *Selected Attributes in nested/json format*: ```--separate-tilesets objectclass tile --style-mode property-based --attributes selected --attribute-structure nested --selected-attributes core_name,gen_objektart,con_height``` : 21 s
11. *All Attributes in nested/json format*: ```--separate-tilesets objectclass tile --style-mode property-based --attributes all --attribute-structure nested``` : 32 s
12. *All Attributes in nested/json format in version 1.0 with vertical offset*: ```--separate-tilesets objectclass tile --style-mode property-based --attributes all --attribute-structure nested --tiles-version 1.0 --vertical-offset 3.5``` : 28 s