geomon/notes.txt

pip freeze > requirements.txt
pip install -r requirements.txt
===========================================================================================
python -m venv .venv
d:/Software/geomon/.venv/Scripts/python.exe -m pip install -U pylint

WARNING: You are using pip version 21.1.3; however, version 21.2.1 is available.
You should consider upgrading via the 'd:\Software\geomon\.venv\Scripts\python.exe -m pip install --upgrade pip' command.


d:/Software/geomon/.venv/Scripts/python.exe -m pip install requests


d:/Software/geomon/.venv/Scripts/python.exe -m pip install sqlalchemy 
d:/Software/geomon/.venv/Scripts/python.exe -m pip install pylint-flask
pip install pylint-flask-sqlalchemy

pylint --load-plugins pylint_flask pylint_flask_sqlalchemy
or:
And in your settings.json of VisualCode:
 "python.linting.pylintArgs": [
        "--load-plugins",
        "pylint_flask",
        "pylint_flask_sqlalchemy",        
    ],


Install python formatter:
d:/Software/geomon/.venv/Scripts/python.exe -m pip install -U autopep8


python -m pip install fdb
python -m pip install sqlalchemy-firebird
python -m pip uninstall psycopg2
python -m pip install pyproj
python -m pip install GeoAlchemy2

Marshmallow provides functionality to serialize and deserialize Python objects as they flow out of and into our JSON-based REST API. Marshmallow converts Python class instances to objects that can be converted to JSON.
python -m pip install marshmallow-sqlalchemy marshmallow 



https://medium.com/dataexplorations/sqlalchemy-orm-a-more-pythonic-way-of-interacting-with-your-database-935b57fd2d4d
https://stackoverflow.com/questions/51737548/how-to-set-primary-key-auto-increment-in-sqlalchemy-orm


 <sml:output name=\"HumanVisualPerception\">
                <swe:Category definition=\"http://www.opengis.net/def/property/humanVisualPerception\">
                    <swe:codeSpace xlink:href=\"NOT_DEFINED\"/>
                </swe:Category>
            </sml:output>



<sml:output name=\"Image\">
<swe:DataRecord>
<swe:field name=\"manuel_observation\">
<swe:Text definition=\"manuel_observation\"/>
</swe:field>
</swe:DataRecord>
</sml:output>

<swe:field name="wmo_weather_code"><swe:Category definition="https://www.nodc.noaa.gov/archive/arc0021/0002199/1.1/data/0-data/HTML/WMO-CODE/WMO4677.HTM"><swe:codeSpace xlink:href="NOT_DEFINED"/></swe:Category></swe:field> -->



1. Pechgraben images
2. Gschliefgraben Piezometer
3. Gschliefgraben Glasfaser
4. Laakirchen Inklinometer










UPDATE pg_extension SET extrelocatable = TRUE WHERE extname = 'postgis';
ALTER EXTENSION postgis SET SCHEMA gba;

ALTER DATABASE sos_db SET search_path TO gba, public;
oder ??
alter role sos_admin set search_path = "$user", public, gba;