• round to 3 decimal placed
• warn the user about the rounding

2020-12-01 15:25:54 cjio_dbexport.db3dnl 73 [ERROR ] Failed to create CityJSON from 1543, check the logs for details.
2020-12-01 15:25:55 cjio_dbexport.db3dnl 265 [ERROR ] 2202E ERROR: cannot accumulate arrays of different dimensionality
CONTEXT: SQL function "cjdb_multipolygon_to_multisurface" statement 1

field:exclude is mandatory, it should not be

Need to be able to export +GenericCityObject.

If a tile fails, restart it X times.

Report which tiles failed at the end.

3dnl table:

• wegdeel_vlak

A command like below would output the whole extent into a single file output.json

$ cjio_dbexport tests/data/test_config.yml export --subset path/to/geojson.json output.json

In table_to_cityobjects() currently I only check for datetime but that's not sufficient. See https://www.psycopg.org/docs/usage.html#adaptation-of-python-values-to-sql-types

We store a tile index in the database. The tile index is a rectangular partitioning of the Netherlands, where each partition is a polygon with a unique ID. For example the AHN index. Then the user can give a list of tile IDs that they want to export.

The command below would export the tiles 37fz2, 35dz2, 12df2 into three cityjson files 37fz2.json, 35dz2.json, 12df2.json to the directory path/to/directory.

$ cjio_dbexport tests/data/test_config.yml export --tiles 37fz2 35dz2 12df2 path/to/directory

Then the command below would export all the tiles from the tile index to the directory path/to/directory.

$ cjio_dbexport tests/data/test_config.yml export --tiles all path/to/directory

Basic validation of the generic required tags in the config file, eg. geometries, database, cityobject_type

3dnl table:

• overbruggingsdeel_vlak

cjio calculates and add extended metadata on save (per cityjson/cjio#56 ). This needs to be integrated here too.

3dnl table:

• begroeidterreindeel_vlak

3dnl table:

• waterdeel_vlak

• cjio_dbexport version: 0.8.8
• Python version: 3.7.5
• Operating System: Ubuntu 19.10

Description

I have made a dump of the 3D bag and I am trying now to create a cityjson file with the load22_3d information using the command:

cjdb --log DEBUG ./config.yaml export_bbox 148528.0213 490644.6947 148922.1004 491072.46513 40910000.json

However I am unsure how to connect to the tables pand & lod22_3d.

What I Did

At the moment, every time I want a specific building or area I first join pand and lod22_3d tables and then I create a table with only the buildings of interest. My config file looks like this. Is there a better way to structure the config file to avoid joining the tables?

geometries:
  lod: 2.2
  type: MultiSurface

database:
  dbname: db
  host: localhost
  port: 5432
  user: username
  password: password

tile_index:
  schema: tile_index
  table: tile_index_1
  srid: 7415
  field:
    pk: id
    geometry: geom

cityobject_type:
  Building:
    - schema: bag3d
      table: lod22_3ds_selection
      field:
        pk: fid
        geometry:
          lod22:
            name: geometrie3d
            type: Solid
        cityobject_id: identificatie

In case the table contains features in different LoD, then it is not possible do differentiate between them unless we mark the LoD of the feature explicitly, eg in an extra column. This column need to be treated separately, because I needs to be loaded from the table but not added as a cityobject attribute.

3dnl table:

• kunstwerkdeel_vlak
• scheiding_vlak

Send logs to file and use Click.echo for >Info messages

For example tablename

Create a data image based on alpine and postgis with the Delft testarea data from 3dfier.

For example one tile per thread.

3dnl tables:

• onbegroeidterreindeel_vlak
• ondersteunendwaterdeel_vlak
• ondersteunendwegdeel_vlak
• overigbouwwerk
• pand

• cjio_dbexport version: 0.88
• Python version: not applicable
• Operating System: Windows 10

Description

The downloaded zip-file for the compiled version of CJIO (from the releases page) is said to contain a trojan horse (cf: https://www.microsoft.com/en-us/wdsi/threats/malware-encyclopedia-description?name=Trojan%3aScript%2fWacatac.B!ml&threatid=2147735503) and can not be opened (or the executable executed) on Windows 10