bertt

        Tool: pg2b3dm 2.8.0.0
        Options: -h localhost -U postgres -c geom -d postgres -t sibbe -a identificatie
        Password for user postgres:
        Start processing 2024-04-09T12:18:51....
        Input table: sibbe
        Input geometry column: geom
        App mode: Cesium
        Spatial reference of sibbe.geom: 4979
        Spatial index detected on sibbe.geom
        Query bounding box of sibbe.geom...

bertt

[3dtiles] type / componentType -> [.net] -> [postgres]
boolean / - -> bool -> boolean
scalar / uint8 -> byte -> -
scalar / int8 -> sbyte -> -
scalar / int16 -> short -> smallint
scalar / uint16 -> ushort -> -
scalar / int32 -> int -> integer
scalar / uint32 -> uint -> -
scalar / int64 -> long -> bigint
scalar / uint64 -> ulong -> -

bertt

Nederlandse naam,Wetenschappelijke naam,Plantjaar,Leeftijd,Eigenaar,Buurt,Wijk,Boomnummer,X,Y,Lat,Long,Exportdatum
Bolacacia,Robinia pseudoacacia 
'Umbraculifera',2017,3,Gemeentelijk,Mariëndaalstraat e.o.,Noordwest,3022615,134958.072,457421.454,5.094669474551958,52.104669913710175,20201123

bertt

Tool: dotnetCampus.TagToVersion

https://github.com/dotnet-campus/dotnetCampus.TagToVersion

Writes a tag to file Build/Version.props

<Project>
  <PropertyGroup>
    <Version>0.11</Version>
  </PropertyGroup>

bertt

DuckDB and GeoParquet Tutorial

This is a quick tutorial on how you can use DuckDB to easily access the cloud-native version of the Google Open Buildings data set from source.coop and transform it into your favorite GIS format. A big thanks to Mark Litwintschik's post on DuckDB's Spatial Extension for lots of the key information, it's highly recommended.

About DuckDB?

DuckDB is an awesome new tool for working with data. In some ways it's a next generation 'SQLite' (which is behind GeoPackage in the geo world) - but fundamentally designed for analysis workflows. TODO: more explanation.

To install it just follow the instructions at: https://duckdb.org/docs/installation/index. This tutorial uses the command line version

bertt

// following works without gdalwarp:
$ wget https://ns_hwh.fundaments.nl/hwh-ahn/AHN3/DTM_5m/M5_65HZ2.zip
$ unzip M5_65HZ2.zip
$ gdalbuildvrt ahn.vrt M5_65HZ2.TIF 
$ mkdir tiles
$ docker run -it -v D:/aaa/testdownload:/data tumgis/ctb-quantized-mesh ctb-tile -f Mesh -C -N -o tiles ahn.vrt

// following does not work with gdalwarp:
$ wget https://ns_hwh.fundaments.nl/hwh-ahn/AHN3/DTM_5m/M5_65HZ2.zip
$ unzip M5_65HZ2.zip

bertt

{
   "asset":{
      "version":"1.0"
   },
   "geometricError":1e+100,
   "root":{
      "boundingVolume":{
         "box":[
            0,
            0,

bertt

{
   "asset":{
      "version":"1.0"
   },
   "geometricError":1e+100,
   "root":{
      "boundingVolume":{
         "box":[
            0,
            0,

bertt

{
   "extensions":{
      "EXT_structural_metadata":{
         "schema":{
            "classes":{
               "terrain":{
                  "description":"class description",
                  "name":"terrain",
                  "properties":{
                     "objectid":{

bertt

import pyproj
lon = 1231256.4091099831 
lat = -4800453.896456448
alt = 4000024.663498499

transformer = pyproj.Transformer.from_crs("EPSG:4978", "EPSG:4326")
print(transformer)
xyz = transformer.transform(lon, lat, alt)
print('Projected XY', xyz)
lonlat = transformer.transform(xyz[0], xyz[1], xyz[2], direction='INVERSE')