Slide 1

Slide 1 text

Storage, maintenance & dissemination of massive 3D city models 3D4EM Meeting Jan 24, 2018 Kavisha TU Delft 1

Slide 2

Slide 2 text

Problem? 2 Massive terrain models (TINs) ~ 700GB in CityGML

Slide 3

Slide 3 text

1.ADE for Terrains 3 1. CityGML_iTINs_ADE : CityGML ADE for massive terrains 2. iTINGML : GML with new geometry types https://github.com/tudelft3d/CityGML_iTINs_ADE

Slide 4

Slide 4 text

4

Slide 5

Slide 5 text

5 Transactions in GIS (December 2017)

Slide 6

Slide 6 text

UML iTINGML 6

Slide 7

Slide 7 text

UML CityGML_iTINs_ADE 7

Slide 8

Slide 8 text

UML iTIN_Relief 8

Slide 9

Slide 9 text

UML iTINGML 9

Slide 10

Slide 10 text

UML iTINGML 10

Slide 11

Slide 11 text

Testing iStars < iTS < iTriStrips 11

Slide 12

Slide 12 text

2. ADE in Database 12 1. To register the ADE in the database 2. To store the terrains in the database ADE : CityGML_iTINs_ADE Database : 3D City Database

Slide 13

Slide 13 text

ADE in 3DCityDB 13 CityGML ADE 1 2 3 4 5

Slide 14

Slide 14 text

iTINRelief in Database 14 1. Register the ADE 2. iTINRelief: ADE class for DTM (i) Simple terrain withTriangle (ii)Terrain with vertical triangles (iii)Terrain with Break lines (iv)Constrained Terrain

Slide 15

Slide 15 text

3. Modelling urban noise in 3D 15 1. Automate the process of data creation for noise simulation 2. Storage and representation of the results of noise simulation (CityGML): eNoise ADE Standardize the 3D input and output data for noise simulation

Slide 16

Slide 16 text

16 3DGeoinfo 2017

Slide 17

Slide 17 text

Noise standards in NL 17 1. Industrielawaai IL (Industrial Noise) 2. Wegverkeerslawaai RMW 2012 (Road Traffic Noise) 3. Railverkeerslawaai RMR 2012 (Rail Traffic Noise)

Slide 18

Slide 18 text

18 IL

Slide 19

Slide 19 text

19 RMW-2012

Slide 20

Slide 20 text

CityGML eNoise ADE 20 1. Road traffic and railways noise 2. No support for industrial noise 3. No info about noise barriers 4. No distinction in the speeds of vehicles 5. No noise data for wide frequency range.

Slide 21

Slide 21 text

CityGML eNoise ADE 21

Slide 22

Slide 22 text

eNoise ADE 22 Buildings • reflection values (octave band) • receiver height (1..6) • receiving facade • noise levels (D/E/N)(octave band) Noise Barriers Industrial sources Roads

Slide 23

Slide 23 text

eNoise ADE 23

Slide 24

Slide 24 text

4. Modelling floods in 3D 24 Mode : Online (edX) Duration: 6 weeks

Slide 25

Slide 25 text

3Di: Requirements for input generation 25 2D/2.5D: - Raster terrain Layer - Raster soil layer (PAWN soil types) - AHN - BAG buildings footprints + threshold height - Land use - Roads, viaducts, tunnels (+ combined with levels)

Slide 26

Slide 26 text

3Di: Requirements for input generation 26 1D: - Sewer system (via the municipality) - Waterways and works of art (via the water board) - Land use (NWRW walk-in) (+ roof slope, + type of paving) After processing, result: - Buildings (+ WOZ value, + number of inhabitants, + number of floors) - Roads (height, + link crossing to junction?)

Slide 27

Slide 27 text

3Di: Requirements for input generation 27 Soil/Surface type ?? BGT

Slide 28

Slide 28 text

Proposed Solution 28 1. Automatic creation of data as required by 3Di (i) Extending 3Dfier (iii) Data sources: (a) AHN (b) BGT (c) BAG 2. Creation of unified database for this data (i) Postgres/Postgis database (ii) Procedure to import/export the data

Slide 29

Slide 29 text

Sewer system: Rotterdam 29

Slide 30

Slide 30 text

30 Task/Status Done Ongoing To Do 1. CityGML iTINs ADE ✓ 2. iTINRelief in Database ✓ 3. Full ADE in Database ✓ 4. 3D data creation For Noise ✓ 5. eNoise ADE Proposal ✓ 6. Full UML of eNoise ADE ✓ 7. 3D flood modelling ✓

Slide 31

Slide 31 text

Thank you!!! Suggestions are welcomed: Kavisha Kumar [email protected] 31