40 lines
1.0 KiB
Python
40 lines
1.0 KiB
Python
from pycen import con_fon
|
|
import geopandas as gpd
|
|
import sys
|
|
|
|
|
|
site_id = 'CRAS'
|
|
lst_parcelle = None
|
|
|
|
site = gpd.read_postgis(
|
|
"SELECT * FROM sites.v_sites WHERE site_id = '%s'"%site_id,
|
|
con_fon)
|
|
parc = gpd.read_postgis(
|
|
"SELECT * FROM sites.v_sites_parcelles WHERE site_id = '%s'"%site_id,
|
|
con_fon)
|
|
|
|
# lst_parcelle = parc[~parc.intersects(site.unary_union)].par_id.unique().tolist()
|
|
lst_parcelle = parc.par_id.unique().tolist()
|
|
|
|
for par_id in lst_parcelle:
|
|
try:
|
|
with con_fon.begin() as cnx:
|
|
cnx.execute("SELECT cadastre.suppr_parcelles_cen('{par_id}','{site_id}')"\
|
|
.format(
|
|
par_id=par_id,site_id=site_id
|
|
)
|
|
)
|
|
except Exception as e:
|
|
print(e)
|
|
print('\n')
|
|
print('La parcelle %s ne peut pas être supprimé'%par_id)
|
|
|
|
|
|
with con_fon.begin() as cnx:
|
|
r = cnx.execute("SELECT admin_sig.refresh_mview_foncier('{site_id}')"\
|
|
.format(
|
|
site_id=site_id
|
|
)
|
|
)
|
|
res = r.fetchall()
|