3dcitydb / tutorials Goto Github PK

Hi! I am following the Tutorial 4.0 but this file at
“C:\RTG_Schulungskurs_2016\Exports\CityGML\Berlin_Building_Output1.gml” does not exist. All my 3 folders below Exports are completely empty and so impossible to proceed to exercise 4.

I followed the instructions given on the pdf but it is showing me this error. Could you please help me?

[16:18:26 INFO] Connecting to database 'Berlin model'.
[16:18:27 ERROR] Connection to database could not be established.
[16:18:27 ERROR] Caused by: java.sql.SQLException: Failed to retrieve version information from the 3D City Database instance.
[16:18:27 ERROR] Caused by: org.postgresql.util.PSQLException: ERROR: schema "citydb_pkg" does not exist
Position: 15

also on when I run CREATE_DB.bat it shows me this error

Connecting to "[email protected]:5432/CityModelX" ...
Password for user postgres:*****
SET
postgis_version

3.1.4

postgis_raster_exists

f

  do_action_for_raster_extension_check

UTIL/HINTS/HINT_ON_MISSING_RASTER_EXTENSION.sql

psql:UTIL/HINTS/HINT_ON_MISSING_RASTER_EXTENSION.sql:33: ERROR: The postgis_raster extension is missing!
HINT: This extension is required when the target database uses PostGIS 3 or higher.
CONTEXT: PL/pgSQL function inline_code_block line 3 at RAISE
Press any key to continue . . .

I follow the tutorial and it works, but I'm trying to use the example KmlManhattanExample to add the thematic data url but this data doesn't appear in the window when you click in an object., I don't know what I'm doing bad.
buildingLayer = new CitydbKmlLayer({
url: 'Datos/ConTexturas/Berlin_con_collada_MasterJSON.json',
name: 'LOD2',
layerDataType:'COLLADA/KML/glTF',
layerProxy: false,
layerClampToGround: true,
gltfVersion: 2.0,
thematicDataUrl: 'https://docs.google.com/spreadsheets/d/1oNq3mHXYJIzVg5VLIclLfVKvaE2QByBq/edit?usp=sharing&ouid=110216278049333696593&rtpof=true&sd=true',
thematicDataSource: 'GoogleSheets',
tableType: 'Horizontal',
cityobjectsJsonUrl: 'Datos/ConTexturas/Berlin_con.json',
minLodPixels: '',
maxLodPixels: '',
maxSizeOfCachedTiles: 200,
maxCountOfVisibleTiles: 200
}
);

Hi!
I am following the Tutorial 4.0 and I can not use Google Fusion Table. It is not available anymore.
Do you have an alternative and could you explain me how to use it regarding to 3dcitydb?

Thanks.