# SUEWS Database Prepare Question

**URL:** <https://community.suews.io/t/suews-database-prepare-question/23>\
**Category:** General\
**Created:** [22 January 2026 14:47 UTC](https://community.suews.io/t/suews-database-prepare-question/23 "2026-01-22T14:47:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![inshans](https://avatars.discourse-cdn.com/v4/letter/i/dec6dc/32.png) [@inshans](https://community.suews.io/u/inshans)\
**Post date:** [22 January 2026 14:47 UTC](https://community.suews.io/t/suews-database-prepare-question/23/1 "2026-01-22T14:47:16Z")

</div>

Hi all!

We are updating our analysis from early 2025 using the most recent updates of UMEP 4.4.3 and SUEWSv2025. A new grid, building and vegetation morphologies, land cover and meteorological data were all formatted using these versions of the tools.

When placing the reformatted vector, raster, met and morphology data into the prepare tool, it would begin to process for a few minutes and then return this error:

2026-01-21T23:23:53 WARNING Traceback (most recent call last):  
File “C:\Users/smi21/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\UMEP\suews\_prepare\_database\suews\_prepare\_database.py”, line 753, in generate  
self.generateSiteSelect(settings\_dict)  
File “C:\Users/smi21/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\UMEP\suews\_prepare\_database\suews\_prepare\_database.py”, line 999, in generateSiteSelect  
df\_build\_frac = df\_build\_frac.set\_index(‘ID’) # Set ID as index in df to be able to slice in df  
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
File “C:\PROGRA~1\QGIS34~1.14\apps\Python312\Lib\site-packages\pandas\core\frame.py”, line 6129, in set\_index  
raise KeyError(f"None of {missing} are in the columns")  
KeyError: “None of [‘ID’] are in the columns”

I know this is forum is more geared to the Python versions of SUEWS, but any insight on what the error could be caused by would be really useful!

Thank you in advance!

---

<div class="post-metadata">

**Author:** ![biglimp](https://avatars.discourse-cdn.com/v4/letter/b/b19c9b/32.png) [@biglimp](https://community.suews.io/u/biglimp)\
**Post date:** [23 January 2026 14:39 UTC](https://community.suews.io/t/suews-database-prepare-question/23/2 "2026-01-23T14:39:34Z")

</div>

We did not yet update the tool in the QGIS repo so please use the development release accessed from here: [2. Getting Started — UMEP Manual documentation](https://umep-docs.readthedocs.io/en/latest/Getting_Started.html#installing-development-release-could-be-unstable) .

Later, I recommend to post UMEP/QGIS related issues to this Discussion site instead: [UMEP-dev/UMEP · Discussions · GitHub](https://github.com/UMEP-dev/UMEP/discussions)

---

<div class="post-metadata">

**Author:** ![inshans](https://avatars.discourse-cdn.com/v4/letter/i/dec6dc/32.png) [@inshans](https://community.suews.io/u/inshans)\
**Post date:** [23 January 2026 18:40 UTC](https://community.suews.io/t/suews-database-prepare-question/23/3 "2026-01-23T18:40:09Z")

</div>

This is very helpful! thank you for your reply. I have posted a question regarding the install of the QGIS plugin (version 4.4.5). Thank you again!