citygml2pgsql converts buildings found in a CityGML file to MultiPolygon insert statements aimed at PosgresSQL/PostGIS.
CREATE TABLE buildings (id TEXT PRIMARY KEY, filename TEXT, lod2 GEOMETRY(MultipolygonZ, 3857));
CREATE TABLE imports (filename TEXT, md5sum CHAR(32), count INTEGER);
Configure database, column names and target SRS in config.yaml
.
Then, run
python citygml2pgsql.py <input_folder> <input_srs> <lod>
# e.g.
python citygml2pgsql.py data/gml_files/ 25832 lod2
Our work was funded by BMBF Prototype Fund:
![](https://private-user-images.githubusercontent.com/74312290/313689757-9dfa1ce4-adaf-4638-9cbc-e519b033331b.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkxOTAwNjQsIm5iZiI6MTczOTE4OTc2NCwicGF0aCI6Ii83NDMxMjI5MC8zMTM2ODk3NTctOWRmYTFjZTQtYWRhZi00NjM4LTljYmMtZTUxOWIwMzMzMzFiLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTAlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjEwVDEyMTYwNFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTFiY2JhNzZhYTM0YWVkMjVkZTBlZDdiMzk4M2MyZTEwZmIxMjg0Mjc0ZmMyYjIyYjY5NDE0ODQ2NzdjZjc2MjYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.9NE8y0wCRSCMrCsogCFUXB8w_IyRe3a78GC2dKN5XOE)
Forked from https://gitlab.com/Oslandia/citygml2pgsql. Original Credits:
This plugin has been developed by Oslandia ( http://www.oslandia.com ).
First release was funded by European Union (FEDER related to the e-PLU project) and by Oslandia.
This work is free software and licenced under the MIT licence. See LICENSE file.