tesselate_building

Console tool for creating polyhedralsurface geometry from (building) footprint, elevation and height value. Shaders for the buildings are written to the 'shaders' column. Buildings can have multiple storeys.

This tool is designed to create the correct input information for creating 3D tiles with pg2b3dm (https://github.com/Geodan/pg2b3dm). This tool is used in the pg2b3dm 'getting started' sample see https://github.com/Geodan/pg2b3dm/blob/master/getting_started.md

Installation

Prerequisite: .NET 8.0 SDK is installed https://dotnet.microsoft.com/download/dotnet/8.0

$ dotnet tool install -g tesselate_building

Or update

$ dotnet tool update -g tesselate_building

Running

$ tesselate_building -U postgres -h localhost -d research -t bro.geotop3d

command line options

All parameters are optional, except the -t --table option.

If --username and/or --dbname are not specified the current username is used as default.

 -U, --username                Database user

  -h, --host                    (Default: localhost) Database host

  -d, --dbname                  Database name

  -p, --port                    (Default: 5432) Database port

  -t, --table                   Required. Database table, include database schema if needed

  -i, --inputgeometrycolumn     (Default: geom) Input geometry column

  -o, --outputgeometrycolumn    (Default: geom3d) Output geometry column

  -f, --format                  (Default: mapbox) Output format mapbox/cesium

  --heightcolumn                (Default: height) height column

  --elevationcolumn             (Default: elevation) Elevation column

  --idcolumn                    (Default: id) Id column

  --stylecolumn                 (Default: style) Style column

  --shaderscolumn                (Default: shaders) Shaders column 

  --help                        Display this help screen.

  --version                     Display version information.

Building elevation

To support terrains there is an option --elevationcolumn to specify an elevation column. The values in the elevation column are added to the building z-values.

Building Styling

For building styling a json column is used. Please note the the json keys are case sensitive.

Simple content (without storeys):

{
  "walls": "#00ff00",
  "roof": " #ff0000",
  "floor": "#D3D3D3",
}

Style content with storeys:

{
  "roof": " #ff0000",
  "floor": "#D3D3D3",
  "storeys": [
    {
      "from": 0,
      "to": 0.5,
      "color": "#D3D3D3"
    },
    {
      "from": 0.5,
      "to": 1,
      "color": "#D3SS3D3"
    },
    {
      "from": 1,
      "to": 1.5,
      "color": "#D354S3D3"
    }
  ]
}

If both element 'walls' and 'storeys' are defined the 'walls' property will be used.

Docker

Image on Docker hub: https://hub.docker.com/repository/docker/bertt/tesselate_building

Run app in Docker:

$ docker run -it bertt/tesselate_building -U postgres -d postgres -t delaware_buildings -f mapbox -i geom -o geom_triangle --idcolumn ogc_fid --stylecolumn style --shaderscolumn shaders

Build sample application in Docker:

$ docker build -t bertt/tesselate_building .

Dependencies

• CommandLineParser https://github.com/commandlineparser/commandline
• Dapper https://github.com/StackExchange/Dapper
• Npgsql https://github.com/npgsql/npgsql
• Wkx https://github.com/cschwarz/wkx-sharp

History

2024-08-07: release 0.5.0, add support for elevation column

2024-08-07: release 0.4.0, make compatible with pg2b3dm 2.13.0

2023-01-04: release 0.3.0, make compatible with pg2b3dm 2.0.0

2023-09-26: release 0.2.2, fix normals

2023-08-18: release 0.2.1, set MetallicRoughness to 0 (gives white buildings in Cesium)

2022-01-24: release 0.2 to from .NET 5 to .NET 6