Форумы GIS-Lab.info

Код: Выделить всё

UPDATE "Public".buildings
SET fields1=CASE
	WHEN ST_AREA(geom::geography)>500 THEN 1
	WHEN ST_AREA(geom::geography)<500 THEN 0
END 

Код: Выделить всё

import psycopg2

connString = "
        host='hostname' 
        port='5432'
        dbname='db_name'
        user='db_user'
        password='db_user_pass'"

SQL="""
UPDATE \"Public\".buildings
SET fields1=CASE
	WHEN ST_AREA(geom::geography)>500 THEN 1
	WHEN ST_AREA(geom::geography)<500 THEN 0
""" 
   
conn = psycopg2.connect(connString)
cur = conn.cursor()
cur.execute(SQL)
cur.commit()
cur.close()
conn.close()