Le portail francophone de la géomatique

import arcpy
from arcpy import env

env.overwriteOutput = True

# Set workspace environment
env.workspace = r"mon chemin d'environnement"


# Set input feature class
in_dataset = arcpy.GetParameterAsText(0)
path_newexport = arcpy.GetParameterAsText(1)


checkField = ["Id_node", "ID_COLL", "INSEE", "COMMUNE", "RESEAU", "TYPE", "CATEGORIE", "NUMERO", "DATE_POSE", "ENTREPRISE", "FABRICANT", "MODELE", "IMPLANT", "HorS_SERV", "DATE_HS", "PROJET", "ALTITUDE", "PROFONDEUR", "RADIER", "X", "Y", "X_mesure", "Y_mesure", "PROPRIO", "CLASSE_P", "ANGLE", "DIAMETRE", "MATERIAU", "ACCESSIBLE", "FERMETURE", "DEBITMETRE", "COTE_REFOU", "Z_PUISARD"]


expression = "getCheck(!Id_node!, !ID_COLL!, !INSEE!, !COMMUNE!, !RESEAU!, !TYPE!, !CATEGORIE!, !NUMERO!, !DATE_POSE!, !ENTREPRISE!, !FABRICANT!, !MODELE!, !IMPLANT!, !HORS_SERV!, !DATE_HS!, !PROJET!, !ALTITUDE!, !PROFONDEUR!, !RADIER!, !X!, !Y!, !X_mesure!, !Y_mesure!, !PROPRIO!, !CLASSE_P!, !ANGLE!, !DIAMETRE!, !MATERIAU!, !ACCESSIBLE!, !FERMETURE!, !DEBITMETRE!, !COTE_REFOU!, !Z_PUISARD!)"
codeblock ="""
def getCheck(Id_node, ID_COLL, INSEE, COMMUNE, RESEAU, TYPE, CATEGORIE, NUMERO, DATE_POSE, ENTREPRISE, FABRICANT, MODELE, IMPLANT, HORS_SERV, DATE_HS, PROJET, ALTITUDE, PROFONDEUR, RADIER, X, Y, X_mesure, Y_mesure, PROPRIO, CLASSE_P, ANGLE, DIAMETRE, MATERIAU, ACCESSIBLE, FERMETURE, DEBITMETRE, COTE_REFOU, Z_PUISARD):
    in_dataset = arcpy.GetParameterAsText(0)
    path_newexport = arcpy.GetParameterAsText(1)
    checkField = ["Id_node", "ID_COLL", "INSEE", "COMMUNE", "RESEAU", "TYPE", "CATEGORIE", "NUMERO", "DATE_POSE", "ENTREPRISE", "FABRICANT", "MODELE", "IMPLANT", "HorS_SERV", "DATE_HS", "PROJET", "ALTITUDE", "PROFONDEUR", "RADIER", "X", "Y", "X_mesure", "Y_mesure", "PROPRIO", "CLASSE_P", "ANGLE", "DIAMETRE", "MATERIAU", "ACCESSIBLE", "FERMETURE", "DEBITMETRE", "COTE_REFOU", "Z_PUISARD"]
    cursor1 = arcpy.da.SearchCursor(in_dataset, checkField)
    cursor2 = arcpy.da.SearchCursor(path_newexport, checkField)

    for row1 in cursor1:
        for row2 in cursor2:
            if row1[0] == row2[0]:
                if row1[1] != row2[1] or row1[2] != row2[2] or row1[3] != row2[3] or row1[4] != row2[4] or row1[5] != row2[5] or row1[6] != row2[6] or row1[7] != row2[7] or row1[8] != row2[8] or row1[9] != row2[9] or row1[10] != row2[10] or row1[11] != row2[11] or row1[12] != row2[12] or row1[13] != row2[13] or row1[14] != row2[14] or row1[15] != row2[15] or row1[16] != row2[16] or row1[17] != row2[17] or row1[18] != row2[18] or row1[19] != row2[19] or row1[20] != row2[20] or row1[21] != row2[21] or row1[22] != row2[22] or row1[23] != row2[23] or row1[24] != row2[24] or row1[25] != row2[25] or row1[26] != row2[26] or row1[27] != row2[27] or row1[28] != row2[28] or row1[29] != row2[29] or row1[30] != row2[30] or row1[31] != row2[31] or row1[32] != row2[32]:
                    Match = '1'
                else:
                    Match = '0'
            else:
                Match = ''

            return '{0}'.format(Match) """

arcpy.AddField_management(path_newexport, "Match", "SHORT")
arcpy.CalculateField_management(path_newexport,"Match",expression,"PYTHON_9.3",codeblock)