20211124
15400600
1.0
FALSE
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\dgi_par codeident ccogrm;ddenom;dforme;comprop
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle typologie Texte # # 60 # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle typologie Analyze(!ccogrm!, !ddenom!, !comprop!, !dforme!) "Python 3" "import re
def Analyze(ccogrm, ddenom, comprop, dforme):
if ccogrm is not None:
if ccogrm == '1':
return 'Etat'
if ccogrm == '2':
return 'Région'
if ccogrm == '3':
return 'Département'
if ccogrm == '4':
return 'Commune'
if ccogrm == '5':
return 'Office HLM'
if ddenom is not None:
if re.search(r'COMMUNE',ddenom) or re.search(r'VILLE D',ddenom):
return 'Commune'
if re.compile(r'EPCI *').match(ddenom) or re.search(r'METROPOLE',ddenom) or re.compile(r'CA*').match(ddenom) or re.search(r'AGGLO',ddenom) or re.compile(r'CC*').match(ddenom) or re.search(r'COMMUNAUTE DE COMMUNES',ddenom) or re.compile(r'CU*').match(ddenom) or re.search(r'COMMUNAUTE URBAINE',ddenom):
return 'EPCI'
if re.search(r'DEPARTEMENT',ddenom) or re.search(r'DEPARTEMENTAL',ddenom) or re.search(r'GENERAL',ddenom) or re.compile(r'CG*').match(ddenom) or re.compile(r'CD*').match(ddenom):
return 'Département'
if re.search(r'REGION',ddenom) or re.compile(r'CR*').match(ddenom) or re.search(r'REGIONAL',ddenom):
return 'Région'
if re.compile(r'ETAT*').match(ddenom):
return 'Etat'
if re.search(r'HLM',ddenom):
return 'Office HLM'
if re.search(r'SNCF',ddenom):
return 'SNCF'
if re.search(r'COPROPRIETAIRE',ddenom) or re.search(r'COPROPRIETE',ddenom):
return 'Copropriété'
if re.search(r'SYNDICAT',ddenom):
return 'Syndicat'
if comprop is not None:
if '*' not in comprop and '+' not in comprop and '@' not in comprop:
return 'Particulier'
if dforme is not None and dforme in '2210, 2220, 2310, 2320, 2385, 3120, 3220, 5520, 5522, 5585, 5620, 5622, 5625, 5647, 6511, 6539, 5202, 5203, 5532, 6532, 6561, 6562, 6563, 6564, 6565, 6566, 6567, 6568, 6569, 6571, 6572, 6573, 6574, 6575, 6576, 6577, 6578, 6596, 5191, 5192, 5193, 5194, 5195, 5196, 5710, 5720, 5770, 5785, 6534, 6597, 6542, 6543, 6551, 6554, 6558, 6560, 6585, 6598, 5306, 5307, 5308, 5309, 5370, 5385, 6100, 5410, 5415, 5422, 5426, 5430, 5431, 5432, 5442, 5443, 5451, 5453, 5454, 5455, 5458, 5459, 5460, 5470, 5499, 5498, 6210, 6220, 6540, 6541, 6544, 5505, 5510, 5525, 5531, 5542, 5546, 5547, 5548, 5551, 5552, 5553, 5554, 5555, 5559, 5560, 5570, 5599, 5605, 5610, 5615, 5631, 5632, 5642, 5643, 5646, 5648, 5651, 5652, 5653, 5654, 5655, 5659, 5660, 5670, 5685, 5699, 9900':
return 'Propriétaire privé divers'
return "Absence d'informations"
" Texte NO_ENFORCE_DOMAINS
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle secteur Texte # # 30 # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle secteur Analyze(!typologie!) "Python 3" "import re
def Analyze(typologie):
if typologie is not None:
if re.compile(r'Particulier').match(typologie) or re.compile(r'Propriétaire privé divers').match(typologie) or re.compile(r'Syndicat').match(typologie) or re.compile(r'Copropriété').match(typologie):
return 'Privé'
if re.compile(r'Commune').match(typologie) or re.compile(r'Département').match(typologie) or re.compile(r'Région').match(typologie) or re.compile(r'Etat').match(typologie) or re.compile(r'SNCF').match(typologie) or re.compile(r'Office HLM').match(typologie) or re.compile(r'EPCI').match(typologie):
return 'Public'
return "Absence d'informations"
" Texte NO_ENFORCE_DOMAINS
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\dgi_par codeident ccogrm;ddenom;dforme;comprop
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle typologie Texte # # 60 # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle typologie Analyze(!ccogrm!, !ddenom!, !comprop!, !dforme!) "Python 3" "import re
def Analyze(ccogrm, ddenom, comprop, dforme):
if ccogrm is not None:
if ccogrm == '1':
return 'Etat'
if ccogrm == '2':
return 'Région'
if ccogrm == '3':
return 'Département'
if ccogrm == '4':
return 'Commune'
if ccogrm == '5':
return 'Office HLM'
if ddenom is not None:
if re.search(r'COMMUNE',ddenom) or re.search(r'VILLE D',ddenom):
return 'Commune'
if re.compile(r'EPCI *').match(ddenom) or re.search(r'METROPOLE',ddenom) or re.compile(r'CA*').match(ddenom) or re.search(r'AGGLO',ddenom) or re.compile(r'CC*').match(ddenom) or re.search(r'COMMUNAUTE DE COMMUNES',ddenom) or re.compile(r'CU*').match(ddenom) or re.search(r'COMMUNAUTE URBAINE',ddenom):
return 'EPCI'
if re.search(r'DEPARTEMENT',ddenom) or re.search(r'DEPARTEMENTAL',ddenom) or re.search(r'GENERAL',ddenom) or re.compile(r'CG*').match(ddenom) or re.compile(r'CD*').match(ddenom):
return 'Département'
if re.search(r'REGION',ddenom) or re.compile(r'CR*').match(ddenom) or re.search(r'REGIONAL',ddenom):
return 'Région'
if re.compile(r'ETAT*').match(ddenom):
return 'Etat'
if re.search(r'HLM',ddenom):
return 'Office HLM'
if re.search(r'SNCF',ddenom):
return 'SNCF'
if re.search(r'COPROPRIETAIRE',ddenom) or re.search(r'COPROPRIETE',ddenom):
return 'Copropriété'
if re.search(r'SYNDICAT',ddenom):
return 'Syndicat'
if comprop is not None:
if '*' not in comprop and '+' not in comprop and '@' not in comprop:
return 'Particulier'
if dforme is not None and dforme in '2210, 2220, 2310, 2320, 2385, 3120, 3220, 5520, 5522, 5585, 5620, 5622, 5625, 5647, 6511, 6539, 5202, 5203, 5532, 6532, 6561, 6562, 6563, 6564, 6565, 6566, 6567, 6568, 6569, 6571, 6572, 6573, 6574, 6575, 6576, 6577, 6578, 6596, 5191, 5192, 5193, 5194, 5195, 5196, 5710, 5720, 5770, 5785, 6534, 6597, 6542, 6543, 6551, 6554, 6558, 6560, 6585, 6598, 5306, 5307, 5308, 5309, 5370, 5385, 6100, 5410, 5415, 5422, 5426, 5430, 5431, 5432, 5442, 5443, 5451, 5453, 5454, 5455, 5458, 5459, 5460, 5470, 5499, 5498, 6210, 6220, 6540, 6541, 6544, 5505, 5510, 5525, 5531, 5542, 5546, 5547, 5548, 5551, 5552, 5553, 5554, 5555, 5559, 5560, 5570, 5599, 5605, 5610, 5615, 5631, 5632, 5642, 5643, 5646, 5648, 5651, 5652, 5653, 5654, 5655, 5659, 5660, 5670, 5685, 5699, 9900':
return 'Propriétaire privé divers'
return "Absence d'informations"
" Texte NO_ENFORCE_DOMAINS
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle secteur Texte # # 30 # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle secteur Analyze(!typologie!) "Python 3" "import re
def Analyze(typologie):
if typologie is not None:
if re.compile(r'Particulier').match(typologie) or re.compile(r'Propriétaire privé divers').match(typologie) or re.compile(r'Syndicat').match(typologie) or re.compile(r'Copropriété').match(typologie):
return 'Privé'
if re.compile(r'Commune').match(typologie) or re.compile(r'Département').match(typologie) or re.compile(r'Région').match(typologie) or re.compile(r'Etat').match(typologie) or re.compile(r'SNCF').match(typologie) or re.compile(r'Office HLM').match(typologie) or re.compile(r'EPCI').match(typologie):
return 'Public'
return "Absence d'informations"
" Texte NO_ENFORCE_DOMAINS
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle SHAPE # Shape # # NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle batie # "Présence de bâti" Texte 3 NULLABLE DO_NOT_CLEAR
AssignDomainToField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle batie BATIE #
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccoarp # "Indicateur d'arpentage" Texte 3 NULLABLE DO_NOT_CLEAR
AssignDomainToField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccoarp CCOARP #
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccocif # "Code du cdif" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccocom # "Code commune" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccodep # "Code département" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccodir # "Code direction" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccopre # "Préfixe de section" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccosec # "Code de section" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccoseccr # "Section parcelle de référence" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccovoi # "Code voie" Texte 5 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codcomm # "ID commune" Texte 6 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident # "Code ID parcelle" Texte 15 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle cprsecr # "Préfixe de section de référence" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle dateacte # "Date de l'acte" Texte 10 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle dnupla # "Numéro de plan" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle dnuplar # "Numéro de plan parcelle de référence" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle dparpi # "Numéro de plan parcelle primitive" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle dreflf # "Référence au livre foncier en Alsace-Moselle " Texte 5 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle feuille # "Nom de la planche" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle figplan # "Parcelle figurée au plan" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ident # "ID parcelle" Texte 9 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle idparpdl # "Parcelle de référence" Texte 9 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle idprop # "Code compte propriétaire" Texte 6 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ndeb # "Numéro de voirie début" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle nonrej # "Parcelle rejetée" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle numpdl # "Numéro d'ordre de la pdl" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle OBJECTID # "Identifiant interne ArcGIS" # 4 NON_NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle parcelle # "Numéro de parcelle" "Long (grand entier)" 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle pdl # "Appartenance lot" Texte 3 NULLABLE DO_NOT_CLEAR
AssignDomainToField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle pdl PDL #
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle rivoli # "Code Rivoli" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle scos # "% surfacique CES" "Double (double précision)" 8 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle sdeb # "Suffixe numéro de voirie début" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle sect_cad # "Nom de la section" Texte 5 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ssurf # "Surface calculée " "Double (double précision)" 8 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ssurfb # "Surface bâtie calculée" "Double (double précision)" 8 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle surface # "Surface cadastrée" "Long (grand entier)" 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle urbain # "Parcelle urbaine" Texte 3 NULLABLE DO_NOT_CLEAR
AssignDomainToField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle urbain URBAIN #
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\dgi_par codeident ccogrm;ddenom;dforme;comprop
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle typologie Texte # # 60 # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle typologie Analyze(!ccogrm!, !ddenom!, !comprop!, !dforme!) "Python 3" "import re
def Analyze(ccogrm, ddenom, comprop, dforme):
if ccogrm is not None:
if ccogrm == '1':
return 'Etat'
if ccogrm == '2':
return 'Région'
if ccogrm == '3':
return 'Département'
if ccogrm == '4':
return 'Commune'
if ccogrm == '5':
return 'Office HLM'
if ddenom is not None:
if re.search(r'COMMUNE',ddenom) or re.search(r'VILLE D',ddenom):
return 'Commune'
if re.compile(r'EPCI *').match(ddenom) or re.search(r'METROPOLE',ddenom) or re.compile(r'CA*').match(ddenom) or re.search(r'AGGLO',ddenom) or re.compile(r'CC*').match(ddenom) or re.search(r'COMMUNAUTE DE COMMUNES',ddenom) or re.compile(r'CU*').match(ddenom) or re.search(r'COMMUNAUTE URBAINE',ddenom):
return 'EPCI'
if re.search(r'DEPARTEMENT',ddenom) or re.search(r'DEPARTEMENTAL',ddenom) or re.search(r'GENERAL',ddenom) or re.compile(r'CG*').match(ddenom) or re.compile(r'CD*').match(ddenom):
return 'Département'
if re.search(r'REGION',ddenom) or re.compile(r'CR*').match(ddenom) or re.search(r'REGIONAL',ddenom):
return 'Région'
if re.compile(r'ETAT*').match(ddenom):
return 'Etat'
if re.search(r'HLM',ddenom):
return 'Office HLM'
if re.search(r'SNCF',ddenom):
return 'SNCF'
if re.search(r'COPROPRIETAIRE',ddenom) or re.search(r'COPROPRIETE',ddenom):
return 'Copropriété'
if re.search(r'SYNDICAT',ddenom):
return 'Syndicat'
if comprop is not None:
if '*' not in comprop and '+' not in comprop and '@' not in comprop:
return 'Particulier'
if dforme is not None and dforme in '2210, 2220, 2310, 2320, 2385, 3120, 3220, 5520, 5522, 5585, 5620, 5622, 5625, 5647, 6511, 6539, 5202, 5203, 5532, 6532, 6561, 6562, 6563, 6564, 6565, 6566, 6567, 6568, 6569, 6571, 6572, 6573, 6574, 6575, 6576, 6577, 6578, 6596, 5191, 5192, 5193, 5194, 5195, 5196, 5710, 5720, 5770, 5785, 6534, 6597, 6542, 6543, 6551, 6554, 6558, 6560, 6585, 6598, 5306, 5307, 5308, 5309, 5370, 5385, 6100, 5410, 5415, 5422, 5426, 5430, 5431, 5432, 5442, 5443, 5451, 5453, 5454, 5455, 5458, 5459, 5460, 5470, 5499, 5498, 6210, 6220, 6540, 6541, 6544, 5505, 5510, 5525, 5531, 5542, 5546, 5547, 5548, 5551, 5552, 5553, 5554, 5555, 5559, 5560, 5570, 5599, 5605, 5610, 5615, 5631, 5632, 5642, 5643, 5646, 5648, 5651, 5652, 5653, 5654, 5655, 5659, 5660, 5670, 5685, 5699, 9900':
return 'Propriétaire privé divers'
return "Absence d'informations"
" Texte NO_ENFORCE_DOMAINS
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle secteur Texte # # 30 # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle secteur Analyze(!typologie!) "Python 3" "import re
def Analyze(typologie):
if typologie is not None:
if re.compile(r'Particulier').match(typologie) or re.compile(r'Propriétaire privé divers').match(typologie) or re.compile(r'Syndicat').match(typologie) or re.compile(r'Copropriété').match(typologie):
return 'Privé'
if re.compile(r'Commune').match(typologie) or re.compile(r'Département').match(typologie) or re.compile(r'Région').match(typologie) or re.compile(r'Etat').match(typologie) or re.compile(r'SNCF').match(typologie) or re.compile(r'Office HLM').match(typologie) or re.compile(r'EPCI').match(typologie):
return 'Public'
return "Absence d'informations"
" Texte NO_ENFORCE_DOMAINS
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\dgi_par codeident ccogrm;ddenom;dforme;comprop
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle typologie Texte # # 60 # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle typologie Analyze(!ccogrm!, !ddenom!, !comprop!, !dforme!) "Python 3" "import re
def Analyze(ccogrm, ddenom, comprop, dforme):
if ccogrm is not None:
if ccogrm == '1':
return 'Etat'
if ccogrm == '2':
return 'Région'
if ccogrm == '3':
return 'Département'
if ccogrm == '4':
return 'Commune'
if ccogrm == '5':
return 'Office HLM'
if ddenom is not None:
if re.search(r'COMMUNE',ddenom) or re.search(r'VILLE D',ddenom):
return 'Commune'
if re.compile(r'EPCI *').match(ddenom) or re.search(r'METROPOLE',ddenom) or re.compile(r'CA*').match(ddenom) or re.search(r'AGGLO',ddenom) or re.compile(r'CC*').match(ddenom) or re.search(r'COMMUNAUTE DE COMMUNES',ddenom) or re.compile(r'CU*').match(ddenom) or re.search(r'COMMUNAUTE URBAINE',ddenom):
return 'EPCI'
if re.search(r'DEPARTEMENT',ddenom) or re.search(r'DEPARTEMENTAL',ddenom) or re.search(r'GENERAL',ddenom) or re.compile(r'CG*').match(ddenom) or re.compile(r'CD*').match(ddenom):
return 'Département'
if re.search(r'REGION',ddenom) or re.compile(r'CR*').match(ddenom) or re.search(r'REGIONAL',ddenom):
return 'Région'
if re.compile(r'ETAT*').match(ddenom):
return 'Etat'
if re.search(r'HLM',ddenom):
return 'Office HLM'
if re.search(r'SNCF',ddenom):
return 'SNCF'
if re.search(r'COPROPRIETAIRE',ddenom) or re.search(r'COPROPRIETE',ddenom):
return 'Copropriété'
if re.search(r'SYNDICAT',ddenom):
return 'Syndicat'
if comprop is not None:
if '*' not in comprop and '+' not in comprop and '@' not in comprop:
return 'Particulier'
if dforme is not None and dforme in '2210, 2220, 2310, 2320, 2385, 3120, 3220, 5520, 5522, 5585, 5620, 5622, 5625, 5647, 6511, 6539, 5202, 5203, 5532, 6532, 6561, 6562, 6563, 6564, 6565, 6566, 6567, 6568, 6569, 6571, 6572, 6573, 6574, 6575, 6576, 6577, 6578, 6596, 5191, 5192, 5193, 5194, 5195, 5196, 5710, 5720, 5770, 5785, 6534, 6597, 6542, 6543, 6551, 6554, 6558, 6560, 6585, 6598, 5306, 5307, 5308, 5309, 5370, 5385, 6100, 5410, 5415, 5422, 5426, 5430, 5431, 5432, 5442, 5443, 5451, 5453, 5454, 5455, 5458, 5459, 5460, 5470, 5499, 5498, 6210, 6220, 6540, 6541, 6544, 5505, 5510, 5525, 5531, 5542, 5546, 5547, 5548, 5551, 5552, 5553, 5554, 5555, 5559, 5560, 5570, 5599, 5605, 5610, 5615, 5631, 5632, 5642, 5643, 5646, 5648, 5651, 5652, 5653, 5654, 5655, 5659, 5660, 5670, 5685, 5699, 9900':
return 'Propriétaire privé divers'
return "Absence d'informations"
" Texte NO_ENFORCE_DOMAINS
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle secteur Texte # # 30 # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle secteur Analyze(!typologie!) "Python 3" "import re
def Analyze(typologie):
if typologie is not None:
if re.compile(r'Particulier').match(typologie) or re.compile(r'Propriétaire privé divers').match(typologie) or re.compile(r'Syndicat').match(typologie) or re.compile(r'Copropriété').match(typologie):
return 'Privé'
if re.compile(r'Commune').match(typologie) or re.compile(r'Département').match(typologie) or re.compile(r'Région').match(typologie) or re.compile(r'Etat').match(typologie) or re.compile(r'SNCF').match(typologie) or re.compile(r'Office HLM').match(typologie) or re.compile(r'EPCI').match(typologie):
return 'Public'
return "Absence d'informations"
" Texte NO_ENFORCE_DOMAINS
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parc_occupation codeident maison;appartement;dependance;local
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle occupation Analyze(!maison!,!appartement!,!dependance!,!local!) "Python 3" "def Analyze(maison,appartement,dependance,local):
if maison is None and appartement is None and dependance is None and local is None:
return 'Pas de bâti'
if maison is not None and appartement is None and local is None:
return 'Maisons uniquement'
if maison is None and appartement is not None and local is None:
return 'Appartements uniquement'
if maison is None and appartement is None and local is not None:
return 'Locaux uniquement'
if maison is not None and appartement is None and local is not None:
return 'Locaux et maisons'
if maison is not None and appartement is not None and local is None:
return 'Appartements et maisons'
if maison is None and appartement is not None and local is not None:
return 'Locaux et appartements'
if maison is not None and appartement is not None and local is not None:
return 'Locaux, maisons et appartements'
if maison is None and appartement is None and dependance is not None and local is None:
return 'Dépendances uniquement'" Texte NO_ENFORCE_DOMAINS
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\vacance_occupation codeident v_local;v_habitation;vacance_total
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle vacance Analyze(!v_local!,!v_habitation!) "Python 3" "def Analyze(v_local,v_habitation):
if v_local is None and v_habitation is None:
return 'Pas de bâti vacant'
if v_local is None and v_habitation == 0:
return 'Pas de bâti vacant'
if v_local is None and v_habitation is not None:
return 'Vacance d’habitation'
if v_local is not None and v_habitation == 0:
return 'Vacance commerciale ou industrielle'
if v_local is not None and v_habitation is not None:
return 'Vacance d’habitation et commerciale ou industrielle'" Texte NO_ENFORCE_DOMAINS
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle pc_surfacebatie "Double (double précision)" # # # # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle pc_surfacebatie Analyze(!ssurfb!,!ssurf!) "Python 3" "def Analyze(ssurfb,ssurf):
if ssurfb is None or ssurfb == 0:
return None
if ssurf is None or ssurf == 0:
return None
return ssurfb/ssurf*100" Texte NO_ENFORCE_DOMAINS
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle presence_bati Texte # # # # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle presence_bati Analyze(!ssurfb!) "Python 3" "def Analyze(ssurfb):
if ssurfb == 0:
return 'Absence de bâti'
if ssurfb != 0:
return 'Présence de bâti'" Texte NO_ENFORCE_DOMAINS
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\age_bat codeident age_bati
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\valloc_parc codeident moy_valloc
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\somme_valloc_parc codeident somme_valloc
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle comprop
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccogrm
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ddenom
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle dforme
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle typologie
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle secteur
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle maison
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle appartement
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle dependance
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle local
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle occupation
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle v_local
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle v_habitation
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle vacance_total
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle vacance
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle pc_surfacebatie
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle presence_bati
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle age_bati
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle moy_valloc
DeleteField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle somme_valloc
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle SHAPE # Shape # # NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle batie # "Présence de bâti" Texte 3 NULLABLE DO_NOT_CLEAR
AssignDomainToField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle batie BATIE #
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccoarp # "Indicateur d'arpentage" Texte 3 NULLABLE DO_NOT_CLEAR
AssignDomainToField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccoarp CCOARP #
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccocif # "Code du cdif" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccocom # "Code commune" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccodep # "Code département" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccodir # "Code direction" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccopre # "Préfixe de section" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccosec # "Code de section" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccoseccr # "Section parcelle de référence" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ccovoi # "Code voie" Texte 5 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codcomm # "ID commune" Texte 6 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident # "Code ID parcelle" Texte 15 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle cprsecr # "Préfixe de section de référence" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle dateacte # "Date de l'acte" Texte 10 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle dnupla # "Numéro de plan" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle dnuplar # "Numéro de plan parcelle de référence" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle dparpi # "Numéro de plan parcelle primitive" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle dreflf # "Référence au livre foncier en Alsace-Moselle " Texte 5 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle feuille # "Nom de la planche" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle figplan # "Parcelle figurée au plan" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ident # "ID parcelle" Texte 9 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle idparpdl # "Parcelle de référence" Texte 9 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle idprop # "Code compte propriétaire" Texte 6 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ndeb # "Numéro de voirie début" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle nonrej # "Parcelle rejetée" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle numpdl # "Numéro d'ordre de la pdl" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle OBJECTID # "Identifiant interne ArcGIS" # 4 NON_NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle parcelle # "Numéro de parcelle" "Long (grand entier)" 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle pdl # "Appartenance lot" Texte 3 NULLABLE DO_NOT_CLEAR
AssignDomainToField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle pdl PDL #
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle rivoli # "Code Rivoli" Texte 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle scos # "% surfacique CES" "Double (double précision)" 8 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle sdeb # "Suffixe numéro de voirie début" Texte 3 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle sect_cad # "Nom de la section" Texte 5 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ssurf # "Surface calculée " "Double (double précision)" 8 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle ssurfb # "Surface bâtie calculée" "Double (double précision)" 8 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle surface # "Surface cadastrée" "Long (grand entier)" 4 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle urbain # "Parcelle urbaine" Texte 3 NULLABLE DO_NOT_CLEAR
AssignDomainToField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle urbain URBAIN #
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\dgi_par codeident ccogrm;ddenom;dforme;comprop
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle typologie Texte # # 60 # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle typologie Analyze(!ccogrm!, !ddenom!, !comprop!, !dforme!) "Python 3" "import re
def Analyze(ccogrm, ddenom, comprop, dforme):
if ccogrm is not None:
if ccogrm == '1':
return 'Etat'
if ccogrm == '2':
return 'Région'
if ccogrm == '3':
return 'Département'
if ccogrm == '4':
return 'Commune'
if ccogrm == '5':
return 'Office HLM'
if ddenom is not None:
if re.search(r'COMMUNE',ddenom) or re.search(r'VILLE D',ddenom):
return 'Commune'
if re.compile(r'EPCI *').match(ddenom) or re.search(r' CA ',ddenom) or re.search(r'METROPOLE',ddenom) or re.search(r'AGGLO',ddenom) or re.search(r' CC ',ddenom) or re.search(r'COMMUNAUTE DE COMMUNES',ddenom) or re.search(r' CU ',ddenom) or re.search(r'COMMUNAUTE URBAINE',ddenom):
return 'EPCI'
if re.search(r'DEPARTEMENT',ddenom) or re.search(r'DEPARTEMENTAL',ddenom) or re.search(r'GENERAL',ddenom) or re.search(r' CG ',ddenom) or re.search(r' CD ',ddenom):
return 'Département'
if re.search(r'REGION',ddenom) or re.search(r' CR ',ddenom) or re.search(r'REGIONAL',ddenom):
return 'Région'
if re.search(r'ETAT ',ddenom):
return 'Etat'
if re.search(r'HLM',ddenom):
return 'Office HLM'
if re.search(r'SNCF',ddenom):
return 'SNCF'
if re.search(r'COPROPRIETAIRE',ddenom) or re.search(r'COPROPRIETE',ddenom):
return 'Copropriété'
if re.search(r'SYNDICAT',ddenom):
return 'Syndicat'
if comprop is not None:
if '*' not in comprop and '+' not in comprop and '@' not in comprop:
return 'Particulier'
if dforme is not None and dforme in '2210, 2220, 2310, 2320, 2385, 3120, 3220, 5520, 5522, 5585, 5620, 5622, 5625, 5647, 6511, 6539, 5202, 5203, 5532, 6532, 6561, 6562, 6563, 6564, 6565, 6566, 6567, 6568, 6569, 6571, 6572, 6573, 6574, 6575, 6576, 6577, 6578, 6596, 5191, 5192, 5193, 5194, 5195, 5196, 5710, 5720, 5770, 5785, 6534, 6597, 6542, 6543, 6551, 6554, 6558, 6560, 6585, 6598, 5306, 5307, 5308, 5309, 5370, 5385, 6100, 5410, 5415, 5422, 5426, 5430, 5431, 5432, 5442, 5443, 5451, 5453, 5454, 5455, 5458, 5459, 5460, 5470, 5499, 5498, 6210, 6220, 6540, 6541, 6544, 5505, 5510, 5525, 5531, 5542, 5546, 5547, 5548, 5551, 5552, 5553, 5554, 5555, 5559, 5560, 5570, 5599, 5605, 5610, 5615, 5631, 5632, 5642, 5643, 5646, 5648, 5651, 5652, 5653, 5654, 5655, 5659, 5660, 5670, 5685, 5699, 9900':
return 'Propriétaire privé divers'
return "Absence d'informations"
" Texte NO_ENFORCE_DOMAINS
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle secteur Texte # # 30 # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle secteur Analyze(!typologie!) "Python 3" "import re
def Analyze(typologie):
if typologie is not None:
if re.compile(r'Particulier').match(typologie) or re.compile(r'Propriétaire privé divers').match(typologie) or re.compile(r'Syndicat').match(typologie) or re.compile(r'Copropriété').match(typologie):
return 'Privé'
if re.compile(r'Commune').match(typologie) or re.compile(r'Département').match(typologie) or re.compile(r'Région').match(typologie) or re.compile(r'Etat').match(typologie) or re.compile(r'SNCF').match(typologie) or re.compile(r'Office HLM').match(typologie) or re.compile(r'EPCI').match(typologie):
return 'Public'
return "Absence d'informations"
" Texte NO_ENFORCE_DOMAINS
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parc_occupation codeident maison;appartement;dependance;local
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle occupation Analyze(!maison!,!appartement!,!dependance!,!local!) "Python 3" "def Analyze(maison,appartement,dependance,local):
if maison is None and appartement is None and dependance is None and local is None:
return 'Pas de bâti'
if maison is not None and appartement is None and local is None:
return 'Maisons uniquement'
if maison is None and appartement is not None and local is None:
return 'Appartements uniquement'
if maison is None and appartement is None and local is not None:
return 'Locaux uniquement'
if maison is not None and appartement is None and local is not None:
return 'Locaux et maisons'
if maison is not None and appartement is not None and local is None:
return 'Appartements et maisons'
if maison is None and appartement is not None and local is not None:
return 'Locaux et appartements'
if maison is not None and appartement is not None and local is not None:
return 'Locaux, maisons et appartements'
if maison is None and appartement is None and dependance is not None and local is None:
return 'Dépendances uniquement'" Texte NO_ENFORCE_DOMAINS
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\vacance_occupation codeident v_local;v_habitation;vacance_total
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle vacance Analyze(!v_local!,!v_habitation!) "Python 3" "def Analyze(v_local,v_habitation):
if v_local is None and v_habitation is None:
return 'Pas de bâti vacant'
if v_local is None and v_habitation == 0:
return 'Pas de bâti vacant'
if v_local is None and v_habitation is not None:
return 'Vacance d’habitation'
if v_local is not None and v_habitation == 0:
return 'Vacance commerciale ou industrielle'
if v_local is not None and v_habitation is not None:
return 'Vacance d’habitation et commerciale ou industrielle'" Texte NO_ENFORCE_DOMAINS
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle pc_surfacebatie "Double (double précision)" # # # # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle pc_surfacebatie Analyze(!ssurfb!,!ssurf!) "Python 3" "def Analyze(ssurfb,ssurf):
if ssurfb is None or ssurfb == 0:
return None
if ssurf is None or ssurf == 0:
return None
return ssurfb/ssurf*100" Texte NO_ENFORCE_DOMAINS
AddField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle presence_bati Texte # # # # NULLABLE NON_REQUIRED #
CalculateField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle presence_bati Analyze(!ssurfb!) "Python 3" "def Analyze(ssurfb):
if ssurfb == 0:
return 'Absence de bâti'
if ssurfb != 0:
return 'Présence de bâti'" Texte NO_ENFORCE_DOMAINS
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\age_bat codeident age_bati
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\valloc_parc codeident moy_valloc
JoinField C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle codeident C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\somme_valloc_parc codeident somme_valloc
FeatureClassToFeatureClass C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb symbologies # "ccocom "Code commune" true true false 3 Text 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,ccocom,0,3;ccodep "Code département" true true false 3 Text 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,ccodep,0,3;codcomm "ID commune" true true false 6 Text 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,codcomm,0,6;codeident "Code ID parcelle" true true false 15 Text 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,codeident,0,15;parcelle "Numéro de parcelle" true true false 4 Long 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,parcelle,-1,-1;surface "Surface cadastrée" true true false 4 Long 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,surface,-1,-1;typologie "typologie" true true false 60 Text 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,typologie,0,60;secteur "secteur" true true false 30 Text 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,secteur,0,30;vacance "vacance" true true false 512 Text 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,vacance,0,512;vacance_total "vacance_total" true true false 4 Long 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,vacance_total,-1,-1;presence_bati "presence_bati" true true false 255 Text 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,presence_bati,0,255;occupation "occupation" true true false 512 Text 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,occupation,0,512;age_bati "age_bati" true true false 8 Double 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,age_bati,-1,-1;pc_surfacebatie "pc_surfacebatie" true true false 8 Double 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,pc_surfacebatie,-1,-1;moy_valloc "moy_valloc" true true false 4 Long 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,moy_valloc,-1,-1;somme_valloc "somme_valloc" true true false 8 Double 0 0,First,#,C:\Users\dsi8021\Desktop\Bordel\Cadastre\cadastre.gdb\parcelle,somme_valloc,-1,-1" #
FeatureClassToFeatureClass "Parcelles - symbologie" "C:\Users\dsi8017\AppData\Roaming\ESRI\Desktop10.6\ArcCatalog\Psql s-sig divers.sde" ParcellesSymbologie # "ccocom "Code commune" true true false 3 Text 0 0,First,#,Parcelles - symbologie,ccocom,0,3;ccodep "Code département" true true false 3 Text 0 0,First,#,Parcelles - symbologie,ccodep,0,3;codcomm "ID commune" true true false 6 Text 0 0,First,#,Parcelles - symbologie,codcomm,0,6;codeident "Code ID parcelle" true true false 15 Text 0 0,First,#,Parcelles - symbologie,codeident,0,15;parcelle "Numéro de parcelle" true true false 4 Long 0 0,First,#,Parcelles - symbologie,parcelle,-1,-1;surface "Surface cadastrée" true true false 4 Long 0 0,First,#,Parcelles - symbologie,surface,-1,-1;typologie "typologie" true true false 60 Text 0 0,First,#,Parcelles - symbologie,typologie,0,60;secteur "secteur" true true false 30 Text 0 0,First,#,Parcelles - symbologie,secteur,0,30;vacance "vacance" true true false 512 Text 0 0,First,#,Parcelles - symbologie,vacance,0,512;vacance_total "vacance_total" true true false 4 Long 0 0,First,#,Parcelles - symbologie,vacance_total,-1,-1;presence_bati "presence_bati" true true false 255 Text 0 0,First,#,Parcelles - symbologie,presence_bati,0,255;occupation "occupation" true true false 512 Text 0 0,First,#,Parcelles - symbologie,occupation,0,512;age_bati "age_bati" true true false 8 Double 0 0,First,#,Parcelles - symbologie,age_bati,-1,-1;pc_surfacebatie "pc_surfacebatie" true true false 8 Double 0 0,First,#,Parcelles - symbologie,pc_surfacebatie,-1,-1;moy_valloc "moy_valloc" true true false 4 Long 0 0,First,#,Parcelles - symbologie,moy_valloc,-1,-1;somme_valloc "somme_valloc" true true false 8 Double 0 0,First,#,Parcelles - symbologie,somme_valloc,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Parcelles - symbologie,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Parcelles - symbologie,Shape_Area,-1,-1" #
cadastre.divers.ParcellesSymbologie
002
Server=s-sig; Service=sde:postgresql:s-sig; Database=cadastre; User=divers; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_RGF_1993
Linear Unit: Meter (1.000000)
RGF_1993_CC48
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.6.0'><WKT>PROJCS["RGF_1993_CC48",GEOGCS["GCS_RGF_1993",DATUM["D_RGF_1993",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1700000.0],PARAMETER["False_Northing",7200000.0],PARAMETER["Central_Meridian",3.0],PARAMETER["Standard_Parallel_1",47.25],PARAMETER["Standard_Parallel_2",48.75],PARAMETER["Latitude_Of_Origin",48.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3948]]</WKT><XOrigin>-34501600</XOrigin><YOrigin>-23248800</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>3948</WKID><LatestWKID>3948</LatestWKID></ProjectedCoordinateSystem>
{"type":"CIMLayerDocument","version":"2.6.0","build":24783,"layers":["CIMPATH=carte1/cadastre_divers_parcellessymbologie.xml"],"layerDefinitions":[{"type":"CIMFeatureLayer","name":"cadastre.divers.ParcellesSymbologie","uRI":"CIMPATH=carte1/cadastre_divers_parcellessymbologie.xml","sourceModifiedTime":{"type":"TimeInstant"},"useSourceMetadata":true,"description":"cadastre.divers.ParcellesSymbologie","layerElevation":{"type":"CIMLayerElevationSurface","mapElevationID":"{2B070425-9D4C-4C94-830F-8604D75F533F}"},"expanded":true,"layerType":"Operational","showLegends":true,"visibility":true,"displayCacheType":"Permanent","maxDisplayCacheAge":5,"showPopups":true,"serviceLayerID":-1,"refreshRate":-1,"refreshRateUnit":"esriTimeUnitsSeconds","autoGenerateFeatureTemplates":true,"featureElevationExpression":"0","featureTable":{"type":"CIMFeatureTable","displayField":"ccocom","editable":true,"dataConnection":{"type":"CIMStandardDataConnection","workspaceConnectionString":"ENCRYPTED_PASSWORD=00022e685261394a59315573362f57706e5a6475753878766a736d4f486846517a5033714b31304137486e614974633d2a00;SERVER=s-sig;INSTANCE=sde:postgresql:s-sig;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=s-sig;DATABASE=cadastre;USER=divers;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS","workspaceFactory":"SDE","dataset":"cadastre.divers.ParcellesSymbologie","datasetType":"esriDTFeatureClass"},"studyAreaSpatialRel":"esriSpatialRelUndefined","searchOrder":"esriSearchOrderSpatial"},"htmlPopupEnabled":true,"selectable":true,"featureCacheType":"Session","displayFiltersType":"ByScale","labelClasses":[{"type":"CIMLabelClass","expression":"$feature.ccocom","expressionEngine":"Arcade","featuresToLabel":"AllVisibleFeatures","maplexLabelPlacementProperties":{"type":"CIMMaplexLabelPlacementProperties","featureType":"Polygon","avoidPolygonHoles":true,"canOverrunFeature":true,"canPlaceLabelOutsidePolygon":true,"canRemoveOverlappingLabel":true,"canStackLabel":true,"connectionType":"Unambiguous","constrainOffset":"NoConstraint","contourAlignmentType":"Page","contourLadderType":"Straight","contourMaximumAngle":90,"enableConnection":true,"featureWeight":0,"fontHeightReductionLimit":4,"fontHeightReductionStep":0.5,"fontWidthReductionLimit":90,"fontWidthReductionStep":5,"graticuleAlignmentType":"Straight","keyNumberGroupName":"Par défaut","labelBuffer":15,"labelLargestPolygon":true,"labelPriority":-1,"labelStackingProperties":{"type":"CIMMaplexLabelStackingProperties","stackAlignment":"ChooseBest","maximumNumberOfLines":3,"minimumNumberOfCharsPerLine":3,"maximumNumberOfCharsPerLine":24,"separators":[{"type":"CIMMaplexStackingSeparator","separator":" ","splitAfter":true},{"type":"CIMMaplexStackingSeparator","separator":",","visible":true,"splitAfter":true}]},"lineFeatureType":"General","linePlacementMethod":"OffsetCurvedFromLine","maximumLabelOverrun":80,"maximumLabelOverrunUnit":"Point","minimumFeatureSizeUnit":"Map","multiPartOption":"OneLabelPerPart","offsetAlongLineProperties":{"type":"CIMMaplexOffsetAlongLineProperties","placementMethod":"BestPositionAlongLine","labelAnchorPoint":"CenterOfLabel","distanceUnit":"Percentage","useLineDirection":true},"pointExternalZonePriorities":{"type":"CIMMaplexExternalZonePriorities","aboveLeft":4,"aboveCenter":2,"aboveRight":1,"centerRight":3,"belowRight":5,"belowCenter":7,"belowLeft":8,"centerLeft":6},"pointPlacementMethod":"AroundPoint","polygonAnchorPointType":"GeometricCenter","polygonBoundaryWeight":0,"polygonExternalZones":{"type":"CIMMaplexExternalZonePriorities","aboveLeft":4,"aboveCenter":2,"aboveRight":1,"centerRight":3,"belowRight":5,"belowCenter":7,"belowLeft":8,"centerLeft":6},"polygonFeatureType":"General","polygonInternalZones":{"type":"CIMMaplexInternalZonePriorities","center":1},"polygonPlacementMethod":"HorizontalInPolygon","primaryOffset":1,"primaryOffsetUnit":"Point","removeExtraWhiteSpace":true,"repetitionIntervalUnit":"Point","rotationProperties":{"type":"CIMMaplexRotationProperties","rotationType":"Arithmetic","alignmentType":"Straight"},"secondaryOffset":100,"strategyPriorities":{"type":"CIMMaplexStrategyPriorities","stacking":1,"overrun":2,"fontCompression":3,"fontReduction":4,"abbreviation":5},"thinningDistanceUnit":"Point","truncationMarkerCharacter":".","truncationMinimumLength":1,"truncationPreferredCharacters":"aeiou","truncationExcludedCharacters":"0123456789"},"name":"Classe\u00A01","priority":-1,"standardLabelPlacementProperties":{"type":"CIMStandardLabelPlacementProperties","featureType":"Line","featureWeight":"Low","labelWeight":"High","numLabelsOption":"OneLabelPerName","lineLabelPosition":{"type":"CIMStandardLineLabelPosition","above":true,"inLine":true,"parallel":true},"lineLabelPriorities":{"type":"CIMStandardLineLabelPriorities","aboveStart":3,"aboveAlong":3,"aboveEnd":3,"centerStart":3,"centerAlong":3,"centerEnd":3,"belowStart":3,"belowAlong":3,"belowEnd":3},"pointPlacementMethod":"AroundPoint","pointPlacementPriorities":{"type":"CIMStandardPointPlacementPriorities","aboveLeft":2,"aboveCenter":2,"aboveRight":1,"centerLeft":3,"centerRight":2,"belowLeft":3,"belowCenter":3,"belowRight":2},"rotationType":"Arithmetic","polygonPlacementMethod":"AlwaysHorizontal"},"textSymbol":{"type":"CIMSymbolReference","symbol":{"type":"CIMTextSymbol","blockProgression":"TTB","depth3D":1,"extrapolateBaselines":true,"fontEffects":"Normal","fontEncoding":"Unicode","fontFamilyName":"Tahoma","fontStyleName":"Regular","fontType":"Unspecified","haloSize":1,"height":10,"hinting":"Default","horizontalAlignment":"Left","kerning":true,"letterWidth":100,"ligatures":true,"lineGapType":"ExtraLeading","symbol":{"type":"CIMPolygonSymbol","symbolLayers":[{"type":"CIMSolidFill","enable":true,"color":{"type":"CIMRGBColor","values":[0,0,0,100]}}]},"textCase":"Normal","textDirection":"LTR","verticalAlignment":"Bottom","verticalGlyphOrientation":"Right","wordSpacing":100,"billboardMode3D":"FaceNearPlane"}},"useCodedValue":true,"visibility":true,"iD":-1}],"renderer":{"type":"CIMSimpleRenderer","patch":"Default","symbol":{"type":"CIMSymbolReference","symbol":{"type":"CIMPolygonSymbol","symbolLayers":[{"type":"CIMSolidStroke","enable":true,"capStyle":"Round","joinStyle":"Round","lineStyle3D":"Strip","miterLimit":10,"width":0.69999999999999996,"color":{"type":"CIMRGBColor","values":[110,110,110,100]}},{"type":"CIMSolidFill","enable":true,"color":{"type":"CIMRGBColor","values":[199.44,252.449999999999989,202.97,100]}}]}}},"scaleSymbols":true,"snappable":true}]}
20211221
16384600
20211221
16384600
Microsoft Windows 10 Version 10.0 (Build 19042) ; Esri ArcGIS 12.6.0.24783
Cadastre
cadastre
parcelles
WS
couche des représentations parcellaires permettant de symboliser les parcelles selon plusieurs thématiques
Classe d’entités de géodatabase d'entreprise
dataset
EPSG
6.15(10.0.0)
0
Simple
FALSE
0
TRUE
FALSE
cadastre.divers.ParcellesSymbologie
Feature Class
0
OBJECTID
objectid
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
ccocom
Code commune
String
3
0
0
ccodep
Code département
String
3
0
0
codcomm
ID commune
String
6
0
0
codeident
Code ID parcelle
String
15
0
0
parcelle
Numéro de parcelle
Integer
4
10
0
surface
Surface cadastrée
Integer
4
10
0
typologie
typologie
String
60
0
0
secteur
secteur
String
30
0
0
vacance
vacance
String
512
0
0
vacance_total
vacance_total
Integer
4
10
0
presence_bati
presence_bati
String
255
0
0
occupation
occupation
String
512
0
0
age_bati
age_bati
Double
8
38
8
pc_surfacebatie
pc_surfacebatie
Double
8
38
8
moy_valloc
moy_valloc
Integer
4
10
0
somme_valloc
somme_valloc
Double
8
38
8
st_area(shape)
st_area(shape)
Double
0
0
0
st_length(shape)
st_length(shape)
Double
0
0
0
20211221
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwCk8gEe
xOPWosg8dDWKmtSRzbZwsijjcnH41pwXMF0m+Fw3qO4/CvPlTlHc74VYT2LClhgDv29a0pojvMWO
w5OKowBTKgckL6itqCZDcO2QHxhfcVnqa2TKsEy2sZMaLu+nWq11ch5GOPm96vXttJJK2wrhdrFT
/OqbwMHV2GR/sjvVXIt3Ivskt7GGPyj+Ft2CfpT4pJLq5ltY2YeY5YncQFUqOPcnH0/lWicC1RyM
bwTtPselZ9kDLPE4GG3Oc98HnFWpaWM3G7uXGtZkyyTp5ajBDDB4FVZI7iVg2YflHAXLZ9yCBV83
MyxPG+0xbsqAOetRxFSxk24AGTzjmpTtuXa+kSOZQkY3BQF5zJyfwHaoWv8AYVUZcAY3H/Cop7lG
lYoAfQmoHUK5GOB6mobLUSyL2UTM/wB9SOQecDFOu2ZwHMj+VjBUHGD24ogceXhTjsfeif5kVCAQ
PQckUJ30Bq2pT8w5O3B4xjrxSYcnJEY46FcVZQxMgMRGB1x1FIQm4Z+UNnJ96abWgaPVFQoJTxjr
1qyI1hYhSHLDHToani08TKptZJZZO+VAUfrVaRX+1ElcEfK49ae4h58zbtAz3xjg0RI7A8AZp2yR
4yMk9tw5xVqRQQCP4hztyR0/pTRJXkwiAYO4jpSoXl2qWwV4IBz9KTC7jlydo5I7UpMkUeACXboC
OlLcHoBR5WEatg/3h6f41fS2htokUyhpG/gzk89yfWs4XIiAUgEHqevPqan3wpLGWZiBzuXHP0B7
UXHYsbEVCCQQpyM88elFS/Y5LmEuqeVGrcg5yVA5/Gii8Rao8s8mQMS26prOWS0nEyYJX7y56j0p
9pZz3jHYOB1ZjwK3LbTYbcBiBI47kYA/Cu2pUjHRnBSpTk7ovRuGUOCRkAjNWYrmVDlWBb6c1XHP
B/OnbG4VRyR271wHpepfiufKbzMqGPBJamKss0jAqQOnlg1WWCRX2yowyM/NxWhY7FikCyHOeWHU
j/JpDsV44HWViGwoUkA9cD2p9uyxG2KY5Z8fgD/hSoPLnlm5IRPunoc8VEVZbWOUYBjkLD6H/wCs
TVxM5lluqgHPfJFNl2LZkeavzcFQcmpZXKhhGoLgZAB4/P8AOqckTIpll272OcUnuOOhVIAHTg0j
FpHLEc96l8wsAGCkDoMgYqMk7uGAx0pMpEyOFHlsVXbnJP64pGzyepqEIC2Aw+gq/aLEgAmyR3wa
VtLjv0Ire3FwAyuYyrZI/vD+tEgETupxhTxkZJ/WnvASm0uVOflCkbv/ANdNCOF2qVOOCdwGf8mr
u3qRoiCe78mLDK6xtkttbA9s+oqGMSOylQQvXI6YrThtHmflRgck9MD61WmlaCchcpD/ABc5x759
/wCf1p+gXtuWIklAzGp2gcj1FLHOwO3Z+PcGrFrP5kWY2G9Tyu7qP/1frVWWfcTK33WGVPtnj/Gl
d30BpWEluI1YRFMnbknIOOc8/n+lRiJ9sTSYDbcbf7o/z/nilgtWlJmlJEj/ADLHjoO2f549/wAp
bgGKHcQQduOT3zTaaJTvqOtpIYSUlQMAMqQOv196ZJcATJMIVZU58scAe1Qwo8hPzDnnGaX97GfL
IPJ7rz9KVi79y8mp3QhLXB/cuScY556CimRXAkcLIVBJxgriipaS3HZvY5nSEC2G4Z+diefy/pV0
ct9Ki0t4prGI71UKNrBQSQRV3bCFyFJI7sSM/lV1PiZFKygrDAOBhdzHt7VdtLOTPn7VZV5xn07V
UeR2RVXAGOi8d61tHIaCWGYY6kHJBBNQ9C1ZjZZXuAiTFASeHJP5fSmeQ0VwYwQPl6qcjn/62Ks3
MUETKjBiRk7cHB+p/OmbPkDuzbsAcn9aqKuS3YZNEDEpA6d/UVVggjkMsco3IowFPcHkfyx+Bq5n
C/3jVGWaOEiRQdwJ3Z9O/wDn2q72ItdE8IdIQBmSYfuyT7dPz60k2nXDxO7shK/MV3ZpY7gCYbSV
D/Kc84PUH6EZq0nmJHshIkb/AGQBke5P+BqZdyodjAxnkUoI781NeWcto6CUAbhkD0qILuXgDNQz
QltgCwAI3McCtAWyMVVXRRjnnnP0rJVirdcVatXgRt5Z2dTkdh+dAraj7iF0j3sWUg4OD92prSBQ
oUMzO3PsfpUd8/mAt8wLfwg5C1WjkAARV3HOeTVRfUmSNM4I4PA5FVpljaNi5HzAgDrnjNQOVIJa
MSKp43YOD2OO1RoI2mWOHJbOZCc4Qen1Pp/k3dPYjVbkMEpscxMP3UvAk5yvfb689q0IicjzVARR
8qZ6dOaiazITEmHyNrZ53A/0pYJFtm8lgzhhiNj1HBOCf69/5q6b8x2a32L0Zke9MLIUypUBj0OM
g1FMWw0MirkccnPenLetCGl2MxIwSand7OWIyrIgdhnrg5qOZ3L5U0ZZDqTH0IOVJ4qe9uPMi8sF
jjnJqr55L5wVWlEhYfNxjnGO1MRJFFuhD72xjuaKp72G4KcA9uaKdw5Wc9o16LaYwyn93JjBHQN/
n+ldH8zc9h61xIAII5rq9Puzc2MRySy/K+fX/wDVitsRD7SObC1L+4y2x54qzb3LrJncwJ4bB61V
Ck84OPUUoXnIV81zHWbkCSPGuUwq9M9cUPgZC5GOB9aoR3EohC7iF6fKcEVPHcyMQrAtx94dTVRd
tyJa7E44b5QFPTOM8elUbkxmRVwRtOSQelW3kUAqWBPoB0zWZqCqw2gEGVhGcHpn/wDVVvXQSdtS
e3kRYbMgZWPafqDx/I1p26eZMz/Jt5GNoPNYc1/axpNGLhGkCE+Wozjp1ph8SSqpWK325wd27px9
KbhKSJVSMJam3fajplsCLmRWaEZ2t2z7fhXHP4lifUjiAJaE4BB5Hvj+lZmrP5tyzks0pP7xiePo
Pp/n1qgyFCQRg989q2hh421MJ4mTeh20m3dlTlSMgjvUtuRvCllXdkZI6YrlLbWpre3WIqJNvClj
0HpVpdfLKv8Ao3PT/Wf/AFqyeHmjf6xBrU6e5ZdgEbM/Ykj+VOt7OQR7gBuPesCy1eO4lWOZtku7
AyeDWy1w7xiLJEPTjqw/w/n9OucoOOjKU1L4SSKJ7hX2AiEcO/r9D+fP+RdkVIYQVhEYRecc9/8A
9X4k1FbyRtEsckqqu36Dj6/hUcmowxyyRJcrJCSMkLuBx29/w+nrSs3sVdLclkDKrP5gCZ+UY/Km
NE07qrKGUrgkcH/PTml8y4vJHYOsUbH5VMY247ZH+B/OpYZwVG5Nj4+YAYGT6VdupF9LFBbiSNHj
ulPmLwG/vj19KjYIJU+U7TyRVzURvtlcAKYzuYs3GO/P0qDykaMGHDHOflOePpRJdRwaWg5LMlXJ
boODTzYyJaGRsKW4RD95ufT9acpdlCZ2gcYFWYN1vcyNcK8lwAFjycjB/l/9eod9ylvYoR2+Vk3H
GOD1/Kirx8xgytEiu7bm2j8z/T86KFJdRuMnscbo+hLqEBmlkZRvxtC4yB15/wAKmvDHoOotBCoe
FgGKF+VP+fWukitPsFibZXYkp8rE4K59O9efywy29xLBP/rEbDHr75rtXv35tjgl+7Scdzdi8QQP
u3RyRt/s8gVI2vWw/wCWjfgtc252khQoxwSD1qIn/wCtS+rxBYiZ0L6zeXMbtA+wKflDDcT9ewq3
pWu3kn7oC3ErHaDtOQD/ABde3J/Cue0y4MV0EZd0cnyMBx171ozWRgJdXQvjGD3/AA7duKbpxWli
VVnvcv6lqV7MSUZo4VJ2gKASPfiqDX14buHE+SPmYZDAe/T3p0JM8HlhQzMu7YeM45/Ci0FpaxwX
N2z+YZd5RRn5AMjP1OaFFdhOUn1IAplaaR8kyAAsR15GP5VZYeZgRgnBwoHH06fjQrtcvmR1QGQH
ngKMHgflxSB5muVeMqJU4VCv9eO1UJDJ7V7WYtOFYjBCpnn8/wD69Q6xYuGiu9rBZlzhuuR1rc09
o5LiS6voVZ4gBt/uHGc471n63ejUJFMO5ooUx0PBPf8AlUqTuW4rlOb2jPelJwgz71dW2TzF8wNy
MjHepI7WGSaEy7khZgJNnLKPoev6dPy15jEyw3z5VsMvIOK7218qSKKRlADKrYX+Vc/Z+HUcxzPO
dhTcygdfatGyujAYrG52vGD5cU6n07MPXt/nNYVveXu9DpoNReuzNppImjxGnl/3WJ5/wpViy3DM
SemTnFJbp8x+c8Hr3q2AqlhuI6ZG3Oa50jpbsV44/nG4cg5Ocn/PWpZlKSBxjGMNn0q5EhltZQCy
kgBc9gOvT15/IVRYuWdX7MVbPfHQ/kQaL6Ba+4kgkcEK+QRyAO34015FgkVJSylgMMo+XA/l/wDq
qvHMVc7juwCv9KluLhH2OWKgHBbPQHv+GBUq9xyikro0raL5hIWHl8jJGTkc06VvNuPMOznkLyMH
pwfzqlHJghmy0TckxkYPofQ1OJlfCrhTnu2M9+9OOrB6DxCqkLnGP4tvB+o9KKDNECRlXFFHKmHM
0Yc90ywRqkmH74+bnHT865eWNZdS2kY3MA24YJPfNdBeBLWITOWaJSOmOPQfj/nisixjuk1B5GiY
cMSZDjH+P4V2xVtjgk27Fm8sLaaHbFGsU+AdxbAf8PyrJvbeOERFFwCvzfWtyV/LjG1pHKYESK+c
E+nX1Pr3qnqUO21jd4yoZ8sSMADnGOuf89aaYmjKtIRcS7csAoydorbWKJMmNfLGAG78+uaS302W
1CStGFjKnOSO/Tj601XcxtvL4XnINK6Y+Vx3AylY3MZLOowrbcg5H9KpmXzo0Lg8feBHcE/0xUL3
DbXCjZk8ioTK0UYEYDEjJLetUlchs1FcuiMvBGW479P/AK9aGnu5Volbc/32ymNo781lZnEK7FDM
oUPkgdsn+f6VesJ3srtpnXcrfJtPcGokn0KjuaF5Bb2lzHG0Ec4cEyORnb+efbmqt3qUdnZSrZNC
quRviGOR05HerUliJbATNMqyySny4/4mBHB9OvHrx0rC1Wwljky8O0nnHfHt7VMVfc0lK2xCnmNI
I+FcdGPb61LsE88p3OXhXA3cHrx2q6jQkx3B3h2GWVcHJ9QffrTInVJGSJS8rk4AGST2GevA4/Cq
TM7EcX2l4441uHjTbgbRgms9ldXZUd/lbIJPI9/rxU89w6A7uT0Pr9M1VdZYFjnK4RjjH+f88VSJ
b7HZaZevf2mHH71TtIUdfQ4q8WIuNhIJCgYx361z3hpXe8eZQ3lBMZwcE5GB+prpN4K435BJ6c89
+K5ZLlZ2UpOUVcnS5NvCy4xjofbFZcl2WnZlAKtjt7YovVwuQSBk8E9aqqBgAenUioZvFX1ZL8oH
JJP1qOVHkgdEySQeCcUuQMd/xzU0bjbz1zz7VKdmU1dC2PmT2ylIxEp+6AcAgfyPHSrLIPJaOQ7X
PQf5+lRwOkTuoXKkZU5zkk81bhO65kR4/vKDzzn3pvRtozWqsUVih2n5Vweo9fr6/jRVq6lQSkeU
C3TPr70VGvcuyObgikvZCY51EMPzkMMhz7jpiniWQo+52wwIdVJG4eh9utY1mLqCQSK5VWyPXd+F
XxbzOIWSdTKTtYHPoDnP516FjzYsl8owzBk+dFzw69uKuWbK92sk8haNQWXPQY6cd+9VCzophE3m
Lk9M7TjjIH/1qdDmSURuwjUAheOnHr/nrSauWnYvXt/bzboYtzZyGGOnoRn+lZzgGLbnj0xgn6mm
yKEnDsCCucsDkVIU8yMvuRVALFsYP+en60KKSshyk5asx2jM8hOFCq2GIrQsRaJdRPdWu/auBjhc
YODjHrjkk9/aq9jEZmuwXEasOM8HIz0/Koo538hppEOSoRWY8MenH4A1epiX7VftEsrJCHlB3Bcg
Ag9c5646VJcwYeICQsAuWXdk7885x0qpbx6gyRS48rA+STYF3fpyPrUzJch/PlmQF/vbk6H6Dipa
Zd1Y1re0Weykf7dbxSId6xvLhm4zlfU/TnpWVczXAnIvDIQO8hyVzUbCQuHWZGZTkvtOR71XuHuC
3myytIScZY/rUpA5Dy/yFQSo/wBkZOP6VFv8nDROwbplsd8/5/GpILSZ0aWRljUj7zNtzSwkRHBX
Bbg8ZJH41ZG5ALZ5ADlM9s5/+vV/yYpLQR3EgBJwQq+ncH/61VLi8MBCnkeg5Ax6GqyaoVbLqmw8
EDOR7+9HLcqLSOqsLhUjW1tmA2j5BjGPzFWjIyFo5mJbrnoPwrnfPCMHhkKnYOEcdxngj9fep11S
1YfPKscn8Svxg/1rCpTcdVqddOopaPQ1JpVkK4/EdATUUWSOeOTUYkUx+ZuBQjIb1FETD78bq8Z5
45GawOjYs4yuOfXmgKeuO3SowxI5JBp68NkccdakZI8Y8nchOR0PYH1xVywYSPuAAIwSPzrOPf5u
3b61ZglWKVSWADJtb5gCce3en8SsT8LuXpk3Sb9rbFH3sZ/Oirf2uARqsRAGBnIIorP5Gll3PPwD
BbMrpl5BgBuMD0Aq1FLIItojAxgblYk4/wA/zpjRyyX2yWRV2qzAE9FHX+Z+tX0tgsDMJlCrx97G
7B6Ed+nb0r0zykjNluFVjCZDGe77MkD096qr58iAq8vT+LAB+nrWxBpW905Vmc9FTJPP1q5d2Vvb
W5ZJw07NgjgBcDn1zmgLNmQ6OsO1S0jDrzzn/I/Wqk0h+3M77lh7r1x7fjWkyqwbYxQk5bnrn+dV
3i+1EqIZGCjPBOXxgccH+VMGiu91Ncl2i3I75L7TtznPX1qzDaS3CWxnO4RAKqAdT2/SorZY1mYS
gxxhwHbGSPardzfxgkWzdCCrhugBzQiTYGmTm1jknRkUP5bGQ4IOMjjHpisHVi7X0iyhY2QbcYIH
A9+eeD+NbNvqms6zqU1zFNDA+PMeXZhEAGMjOecDFZt00VtMZ55XuJnGWMvL5wM/rSGyja2ks21z
kAdmrSukttFlC3Dw3U2GwseG29uc8DkdcZ/pjXmrXF18iDyogu3AwMj3NZ+CVLHOPUDiqsSXJdTl
k+U7Vi3ZC4yfz70jXcXTDHHI4xVNDufBA6HrUgEMizOzsGUAogXIbkDB9OKGgI57gyNtH3B0FVmJ
wRT8gtg5AqJhgnFUgJobiaBDtfCkjAIBGRU8wlureOVI08uNcMyAA5681XlUC1t2yuSGyB1zmnWr
XCOXtt+VG47fT19qYCFpNmze3lg/dycflT7e9ubb5YZmVc5K9vyqxFeQvEY7iHcw+4R1x3/pVN0A
Ix0paPRgm1qmdbpuopfQ5wFlX7y/1HtV7k5J6/WuGQsvK8E11umXP2i1RWP71Vww7/WuKtR5dUd1
Gvze7Lc2tHihudZtIZ498UkgV13EZB+nNd9/wiWhupVrIlT1BlfH8643wnGr67CWUZVgQSOBzXp6
xGQ8KQD0OOKw16HRZdTKm8IaLFt8uzJhcblzK5I9R165orctl8+1khfO5TvQ+/cflRVNN6olNLRn
z1BckMzneZSo2vv+7z9P8mtRJBJbhSgCKWwowP4c+n+cUUV3I4IboljhClmBIG3OKiEMTnlSQQCM
npRRVdBttyZKIVQ5HWTGevcGqF3uS6ZUbaQpwwAz6n6c0UUnuR0K+pssNlFbIgBmIdn7/SnWmnW5
EZcM5IzyeOnpRRTZPUsvcmZFaQfM5B+Q7QAcjGKybiJrkyyNIQwIJOMk596KKkbKcqDYzH+HoKqT
MQwUdKKKqJJErfN05p4Yr369aKKoRG3PWprO1jumdGLLtG7IPXmiigaLsttGskKKqgbScY78c/rW
mblbK3kMMKB9vL9zRRUS3Kj1KtjZwz3jySLk4JI6AnimX9hFAltMoH77qo9wTRRUJvmKSXJcoS24
WRQDwea3fDsCTajucZ2R5A9zx/Wiiqm/dFT+JHeaPGBr1iI8Rjz1ztGM816GwMcqsWLEd/WiiuKe
x3w3LFm4W7hyCd529elFFFb0NmYYjRo//9k=