User:Barnes38/BNAC

From OpenStreetMap Wiki
Jump to navigation Jump to search

BNAC

Extraire ?

import json

  1. Votre GeoJSON initial

geojson_data = {

   "type": "FeatureCollection",
   # ... (le reste de vos données GeoJSON)

}

  1. Valeur que vous souhaitez filtrer (par exemple 38159)

valeur_cible = 38159

  1. Filtrer les features en fonction de la valeur de "code_com_g"

features_filtrees = [feature for feature in geojson_data["features"] if feature["properties"]["code_com_g"] == valeur_cible]

  1. Créer un nouveau GeoJSON avec les features filtrées

geojson_filtre = {

   "type": "FeatureCollection",
   "features": features_filtrees

}

  1. Convertir en chaîne JSON

geojson_filtre_str = json.dumps(geojson_filtre, indent=2)

  1. Afficher le résultat

print(geojson_filtre_str)

???

cat votre_fichier.json | jq '.features[].properties'
cat votre_fichier.json | jq '[.features[].properties]'
cat france-20240701.geojson | jq '.features[].properties' > france-20240701.properties.geojson
cat france-20240701.geojson | jq '.features[].properties' > france-20240701.properties.geojson
cat france-20240701.geojson | jq '[.features[].properties]' > france-20240701.properties.geojson
cat france-20240701.geojson | jq '[.features[].geometry]' > france-20240701.geometry.geojson
cat france-20240701.geojson | jq 'del(.features)' > france-20240701.sans-features.geojson
cat france-20240701.features-geometry-type.geojson | sort -u
cat france-20240701.geojson | jq '.features[].properties.code_com_g' > france-20240701.features-properties-code_com_g.geojson
cat france-20240701.features-properties-code_com_g.geojson
cat france-20240701.features-properties-code_com_g.geojson | sort -u
cat france-20240701.features-properties-code_com_g.geojson | sort -u | grep 38169
cat france-20240701.geojson | jq '.features[] | select(.properties.code_com_g == "38169" or .properties.code_com_g == "38474")' > france-20240701.38169-38474.geojson

?2

cat france-20240701.geojson | jq '[.features[] | select((.properties.code_com_g == "38169" and .properties.code_com_d == "38169") or (.properties.code_com_g == "38474" and .properties.code_com_d == "38474"))]' > france-20240701.38619-38474gad.json
cat france-20240701.geojson | jq '[.features[] | select((.properties.code_com_g == "38169" or .properties.code_com_d == "38169") or (.properties.code_com_g == "38474" or .properties.code_com_d == "38474"))]' > france-20240701.38619-38474god.json

gam gad

def generate_clause(code):

   return f"(.properties.code_com_g == {code} and .properties.code_com_d == {code})"
  1. Given "code" values

code_values = [

   38054, 38056, 38073, 38072, 38110, 38131, 38145, 38151, 38156, 38169,
   38177, 38185, 38196, 38215, 38516, 38168, 38193, 38315, 38474, 38229,
   38236, 38244, 38243, 38258, 38323, 38324, 38329, 38309, 38325, 38326,
   38362, 38370, 38371, 38388, 38389, 38392, 38393, 38476, 38477, 38480,
   38481, 38482, 38523, 38524, 38525, 38528, 38529, 38533, 38563

]

  1. Generate individual clauses

clauses = [generate_clause(code) for code in code_values]

  1. Combine clauses using logical OR

combined_expression = " or ".join(clauses)

print(f"Final expression:\n({combined_expression})")

((.properties.code_com_g == 38054 and .properties.code_com_d == 38054) or (.properties.code_com_g == 38056 and .properties.code_com_d == 38056) or (.properties.code_com_g == 38073 and .properties.code_com_d == 38073) or (.properties.code_com_g == 38072 and .properties.code_com_d == 38072) or (.properties.code_com_g == 38110 and .properties.code_com_d == 38110) or (.properties.code_com_g == 38131 and .properties.code_com_d == 38131) or (.properties.code_com_g == 38145 and .properties.code_com_d == 38145) or (.properties.code_com_g == 38151 and .properties.code_com_d == 38151) or (.properties.code_com_g == 38156 and .properties.code_com_d == 38156) or (.properties.code_com_g == 38169 and .properties.code_com_d == 38169) or (.properties.code_com_g == 38177 and .properties.code_com_d == 38177) or (.properties.code_com_g == 38185 and .properties.code_com_d == 38185) or (.properties.code_com_g == 38196 and .properties.code_com_d == 38196) or (.properties.code_com_g == 38215 and .properties.code_com_d == 38215) or (.properties.code_com_g == 38516 and .properties.code_com_d == 38516) or (.properties.code_com_g == 38168 and .properties.code_com_d == 38168) or (.properties.code_com_g == 38193 and .properties.code_com_d == 38193) or (.properties.code_com_g == 38315 and .properties.code_com_d == 38315) or (.properties.code_com_g == 38474 and .properties.code_com_d == 38474) or (.properties.code_com_g == 38229 and .properties.code_com_d == 38229) or (.properties.code_com_g == 38236 and .properties.code_com_d == 38236) or (.properties.code_com_g == 38244 and .properties.code_com_d == 38244) or (.properties.code_com_g == 38243 and .properties.code_com_d == 38243) or (.properties.code_com_g == 38258 and .properties.code_com_d == 38258) or (.properties.code_com_g == 38323 and .properties.code_com_d == 38323) or (.properties.code_com_g == 38324 and .properties.code_com_d == 38324) or (.properties.code_com_g == 38329 and .properties.code_com_d == 38329) or (.properties.code_com_g == 38309 and .properties.code_com_d == 38309) or (.properties.code_com_g == 38325 and .properties.code_com_d == 38325) or (.properties.code_com_g == 38326 and .properties.code_com_d == 38326) or (.properties.code_com_g == 38362 and .properties.code_com_d == 38362) or (.properties.code_com_g == 38370 and .properties.code_com_d == 38370) or (.properties.code_com_g == 38371 and .properties.code_com_d == 38371) or (.properties.code_com_g == 38388 and .properties.code_com_d == 38388) or (.properties.code_com_g == 38389 and .properties.code_com_d == 38389) or (.properties.code_com_g == 38392 and .properties.code_com_d == 38392) or (.properties.code_com_g == 38393 and .properties.code_com_d == 38393) or (.properties.code_com_g == 38476 and .properties.code_com_d == 38476) or (.properties.code_com_g == 38477 and .properties.code_com_d == 38477) or (.properties.code_com_g == 38480 and .properties.code_com_d == 38480) or (.properties.code_com_g == 38481 and .properties.code_com_d == 38481) or (.properties.code_com_g == 38482 and .properties.code_com_d == 38482) or (.properties.code_com_g == 38523 and .properties.code_com_d == 38523) or (.properties.code_com_g == 38524 and .properties.code_com_d == 38524) or (.properties.code_com_g == 38525 and .properties.code_com_d == 38525) or (.properties.code_com_g == 38528 and .properties.code_com_d == 38528) or (.properties.code_com_g == 38529 and .properties.code_com_d == 38529) or (.properties.code_com_g == 38533 and .properties.code_com_d == 38533) or (.properties.code_com_g == 38563 and .properties.code_com_d == 38563))


cat france-20240701.geojson | jq '[.features[] | select((.properties.code_com_g == 38054 and .properties.code_com_d == 38054) or (.properties.code_com_g == 38056 and .properties.code_com_d == 38056) or (.properties.code_com_g == 38073 and .properties.code_com_d == 38073) or (.properties.code_com_g == 38072 and .properties.code_com_d == 38072) or (.properties.code_com_g == 38110 and .properties.code_com_d == 38110) or (.properties.code_com_g == 38131 and .properties.code_com_d == 38131) or (.properties.code_com_g == 38145 and .properties.code_com_d == 38145) or (.properties.code_com_g == 38151 and .properties.code_com_d == 38151) or (.properties.code_com_g == 38156 and .properties.code_com_d == 38156) or (.properties.code_com_g == 38169 and .properties.code_com_d == 38169) or (.properties.code_com_g == 38177 and .properties.code_com_d == 38177) or (.properties.code_com_g == 38185 and .properties.code_com_d == 38185) or (.properties.code_com_g == 38196 and .properties.code_com_d == 38196) or (.properties.code_com_g == 38215 and .properties.code_com_d == 38215) or (.properties.code_com_g == 38516 and .properties.code_com_d == 38516) or (.properties.code_com_g == 38168 and .properties.code_com_d == 38168) or (.properties.code_com_g == 38193 and .properties.code_com_d == 38193) or (.properties.code_com_g == 38315 and .properties.code_com_d == 38315) or (.properties.code_com_g == 38474 and .properties.code_com_d == 38474) or (.properties.code_com_g == 38229 and .properties.code_com_d == 38229) or (.properties.code_com_g == 38236 and .properties.code_com_d == 38236) or (.properties.code_com_g == 38244 and .properties.code_com_d == 38244) or (.properties.code_com_g == 38243 and .properties.code_com_d == 38243) or (.properties.code_com_g == 38258 and .properties.code_com_d == 38258) or (.properties.code_com_g == 38323 and .properties.code_com_d == 38323) or (.properties.code_com_g == 38324 and .properties.code_com_d == 38324) or (.properties.code_com_g == 38329 and .properties.code_com_d == 38329) or (.properties.code_com_g == 38309 and .properties.code_com_d == 38309) or (.properties.code_com_g == 38325 and .properties.code_com_d == 38325) or (.properties.code_com_g == 38326 and .properties.code_com_d == 38326) or (.properties.code_com_g == 38362 and .properties.code_com_d == 38362) or (.properties.code_com_g == 38370 and .properties.code_com_d == 38370) or (.properties.code_com_g == 38371 and .properties.code_com_d == 38371) or (.properties.code_com_g == 38388 and .properties.code_com_d == 38388) or (.properties.code_com_g == 38389 and .properties.code_com_d == 38389) or (.properties.code_com_g == 38392 and .properties.code_com_d == 38392) or (.properties.code_com_g == 38393 and .properties.code_com_d == 38393) or (.properties.code_com_g == 38476 and .properties.code_com_d == 38476) or (.properties.code_com_g == 38477 and .properties.code_com_d == 38477) or (.properties.code_com_g == 38480 and .properties.code_com_d == 38480) or (.properties.code_com_g == 38481 and .properties.code_com_d == 38481) or (.properties.code_com_g == 38482 and .properties.code_com_d == 38482) or (.properties.code_com_g == 38523 and .properties.code_com_d == 38523) or (.properties.code_com_g == 38524 and .properties.code_com_d == 38524) or (.properties.code_com_g == 38525 and .properties.code_com_d == 38525) or (.properties.code_com_g == 38528 and .properties.code_com_d == 38528) or (.properties.code_com_g == 38529 and .properties.code_com_d == 38529) or (.properties.code_com_g == 38533 and .properties.code_com_d == 38533) or (.properties.code_com_g == 38563 and .properties.code_com_d == 38563))]


gam gand or dang

def generate_clause(code):

   return f"((.properties.code_com_g == {code} and .properties.code_com_d != {code}) or (.properties.code_com_g != {code} and .properties.code_com_d == {code}))"
  1. Given "code" values

code_values = [

   38054, 38056, 38073, 38072, 38110, 38131, 38145, 38151, 38156, 38169,
   38177, 38185, 38196, 38215, 38516, 38168, 38193, 38315, 38474, 38229,
   38236, 38244, 38243, 38258, 38323, 38324, 38329, 38309, 38325, 38326,
   38362, 38370, 38371, 38388, 38389, 38392, 38393, 38476, 38477, 38480,
   38481, 38482, 38523, 38524, 38525, 38528, 38529, 38533, 38563

]

  1. Generate individual clauses

clauses = [generate_clause(code) for code in code_values]

  1. Combine clauses using logical OR

combined_expression = " or ".join(clauses)

print(f"Final expression:\n({combined_expression})")


(((.properties.code_com_g == 38054 and .properties.code_com_d != 38054) or (.properties.code_com_g != 38054 and .properties.code_com_d == 38054) or ((.properties.code_com_g == 38056 and .properties.code_com_d != 38056) or (.properties.code_com_g != 38056 and .properties.code_com_d == 38056) or ((.properties.code_com_g == 38073 and .properties.code_com_d != 38073) or (.properties.code_com_g != 38073 and .properties.code_com_d == 38073) or ((.properties.code_com_g == 38072 and .properties.code_com_d != 38072) or (.properties.code_com_g != 38072 and .properties.code_com_d == 38072) or ((.properties.code_com_g == 38110 and .properties.code_com_d != 38110) or (.properties.code_com_g != 38110 and .properties.code_com_d == 38110) or ((.properties.code_com_g == 38131 and .properties.code_com_d != 38131) or (.properties.code_com_g != 38131 and .properties.code_com_d == 38131) or ((.properties.code_com_g == 38145 and .properties.code_com_d != 38145) or (.properties.code_com_g != 38145 and .properties.code_com_d == 38145) or ((.properties.code_com_g == 38151 and .properties.code_com_d != 38151) or (.properties.code_com_g != 38151 and .properties.code_com_d == 38151) or ((.properties.code_com_g == 38156 and .properties.code_com_d != 38156) or (.properties.code_com_g != 38156 and .properties.code_com_d == 38156) or ((.properties.code_com_g == 38169 and .properties.code_com_d != 38169) or (.properties.code_com_g != 38169 and .properties.code_com_d == 38169) or ((.properties.code_com_g == 38177 and .properties.code_com_d != 38177) or (.properties.code_com_g != 38177 and .properties.code_com_d == 38177) or ((.properties.code_com_g == 38185 and .properties.code_com_d != 38185) or (.properties.code_com_g != 38185 and .properties.code_com_d == 38185) or ((.properties.code_com_g == 38196 and .properties.code_com_d != 38196) or (.properties.code_com_g != 38196 and .properties.code_com_d == 38196) or ((.properties.code_com_g == 38215 and .properties.code_com_d != 38215) or (.properties.code_com_g != 38215 and .properties.code_com_d == 38215) or ((.properties.code_com_g == 38516 and .properties.code_com_d != 38516) or (.properties.code_com_g != 38516 and .properties.code_com_d == 38516) or ((.properties.code_com_g == 38168 and .properties.code_com_d != 38168) or (.properties.code_com_g != 38168 and .properties.code_com_d == 38168) or ((.properties.code_com_g == 38193 and .properties.code_com_d != 38193) or (.properties.code_com_g != 38193 and .properties.code_com_d == 38193) or ((.properties.code_com_g == 38315 and .properties.code_com_d != 38315) or (.properties.code_com_g != 38315 and .properties.code_com_d == 38315) or ((.properties.code_com_g == 38474 and .properties.code_com_d != 38474) or (.properties.code_com_g != 38474 and .properties.code_com_d == 38474) or ((.properties.code_com_g == 38229 and .properties.code_com_d != 38229) or (.properties.code_com_g != 38229 and .properties.code_com_d == 38229) or ((.properties.code_com_g == 38236 and .properties.code_com_d != 38236) or (.properties.code_com_g != 38236 and .properties.code_com_d == 38236) or ((.properties.code_com_g == 38244 and .properties.code_com_d != 38244) or (.properties.code_com_g != 38244 and .properties.code_com_d == 38244) or ((.properties.code_com_g == 38243 and .properties.code_com_d != 38243) or (.properties.code_com_g != 38243 and .properties.code_com_d == 38243) or ((.properties.code_com_g == 38258 and .properties.code_com_d != 38258) or (.properties.code_com_g != 38258 and .properties.code_com_d == 38258) or ((.properties.code_com_g == 38323 and .properties.code_com_d != 38323) or (.properties.code_com_g != 38323 and .properties.code_com_d == 38323) or ((.properties.code_com_g == 38324 and .properties.code_com_d != 38324) or (.properties.code_com_g != 38324 and .properties.code_com_d == 38324) or ((.properties.code_com_g == 38329 and .properties.code_com_d != 38329) or (.properties.code_com_g != 38329 and .properties.code_com_d == 38329) or ((.properties.code_com_g == 38309 and .properties.code_com_d != 38309) or (.properties.code_com_g != 38309 and .properties.code_com_d == 38309) or ((.properties.code_com_g == 38325 and .properties.code_com_d != 38325) or (.properties.code_com_g != 38325 and .properties.code_com_d == 38325) or ((.properties.code_com_g == 38326 and .properties.code_com_d != 38326) or (.properties.code_com_g != 38326 and .properties.code_com_d == 38326) or ((.properties.code_com_g == 38362 and .properties.code_com_d != 38362) or (.properties.code_com_g != 38362 and .properties.code_com_d == 38362) or ((.properties.code_com_g == 38370 and .properties.code_com_d != 38370) or (.properties.code_com_g != 38370 and .properties.code_com_d == 38370) or ((.properties.code_com_g == 38371 and .properties.code_com_d != 38371) or (.properties.code_com_g != 38371 and .properties.code_com_d == 38371) or ((.properties.code_com_g == 38388 and .properties.code_com_d != 38388) or (.properties.code_com_g != 38388 and .properties.code_com_d == 38388) or ((.properties.code_com_g == 38389 and .properties.code_com_d != 38389) or (.properties.code_com_g != 38389 and .properties.code_com_d == 38389) or ((.properties.code_com_g == 38392 and .properties.code_com_d != 38392) or (.properties.code_com_g != 38392 and .properties.code_com_d == 38392) or ((.properties.code_com_g == 38393 and .properties.code_com_d != 38393) or (.properties.code_com_g != 38393 and .properties.code_com_d == 38393) or ((.properties.code_com_g == 38476 and .properties.code_com_d != 38476) or (.properties.code_com_g != 38476 and .properties.code_com_d == 38476) or ((.properties.code_com_g == 38477 and .properties.code_com_d != 38477) or (.properties.code_com_g != 38477 and .properties.code_com_d == 38477) or ((.properties.code_com_g == 38480 and .properties.code_com_d != 38480) or (.properties.code_com_g != 38480 and .properties.code_com_d == 38480) or ((.properties.code_com_g == 38481 and .properties.code_com_d != 38481) or (.properties.code_com_g != 38481 and .properties.code_com_d == 38481) or ((.properties.code_com_g == 38482 and .properties.code_com_d != 38482) or (.properties.code_com_g != 38482 and .properties.code_com_d == 38482) or ((.properties.code_com_g == 38523 and .properties.code_com_d != 38523) or (.properties.code_com_g != 38523 and .properties.code_com_d == 38523) or ((.properties.code_com_g == 38524 and .properties.code_com_d != 38524) or (.properties.code_com_g != 38524 and .properties.code_com_d == 38524) or ((.properties.code_com_g == 38525 and .properties.code_com_d != 38525) or (.properties.code_com_g != 38525 and .properties.code_com_d == 38525) or ((.properties.code_com_g == 38528 and .properties.code_com_d != 38528) or (.properties.code_com_g != 38528 and .properties.code_com_d == 38528) or ((.properties.code_com_g == 38529 and .properties.code_com_d != 38529) or (.properties.code_com_g != 38529 and .properties.code_com_d == 38529) or ((.properties.code_com_g == 38533 and .properties.code_com_d != 38533) or (.properties.code_com_g != 38533 and .properties.code_com_d == 38533) or ((.properties.code_com_g == 38563 and .properties.code_com_d != 38563) or (.properties.code_com_g != 38563 and .properties.code_com_d == 38563))


cat france-20240701.geojson | jq '[.features[] | select(((.properties.code_com_g == 38054 and .properties.code_com_d != 38054) or (.properties.code_com_g != 38054 and .properties.code_com_d == 38054) or ((.properties.code_com_g == 38056 and .properties.code_com_d != 38056) or (.properties.code_com_g != 38056 and .properties.code_com_d == 38056) or ((.properties.code_com_g == 38073 and .properties.code_com_d != 38073) or (.properties.code_com_g != 38073 and .properties.code_com_d == 38073) or ((.properties.code_com_g == 38072 and .properties.code_com_d != 38072) or (.properties.code_com_g != 38072 and .properties.code_com_d == 38072) or ((.properties.code_com_g == 38110 and .properties.code_com_d != 38110) or (.properties.code_com_g != 38110 and .properties.code_com_d == 38110) or ((.properties.code_com_g == 38131 and .properties.code_com_d != 38131) or (.properties.code_com_g != 38131 and .properties.code_com_d == 38131) or ((.properties.code_com_g == 38145 and .properties.code_com_d != 38145) or (.properties.code_com_g != 38145 and .properties.code_com_d == 38145) or ((.properties.code_com_g == 38151 and .properties.code_com_d != 38151) or (.properties.code_com_g != 38151 and .properties.code_com_d == 38151) or ((.properties.code_com_g == 38156 and .properties.code_com_d != 38156) or (.properties.code_com_g != 38156 and .properties.code_com_d == 38156) or ((.properties.code_com_g == 38169 and .properties.code_com_d != 38169) or (.properties.code_com_g != 38169 and .properties.code_com_d == 38169) or ((.properties.code_com_g == 38177 and .properties.code_com_d != 38177) or (.properties.code_com_g != 38177 and .properties.code_com_d == 38177) or ((.properties.code_com_g == 38185 and .properties.code_com_d != 38185) or (.properties.code_com_g != 38185 and .properties.code_com_d == 38185) or ((.properties.code_com_g == 38196 and .properties.code_com_d != 38196) or (.properties.code_com_g != 38196 and .properties.code_com_d == 38196) or ((.properties.code_com_g == 38215 and .properties.code_com_d != 38215) or (.properties.code_com_g != 38215 and .properties.code_com_d == 38215) or ((.properties.code_com_g == 38516 and .properties.code_com_d != 38516) or (.properties.code_com_g != 38516 and .properties.code_com_d == 38516) or ((.properties.code_com_g == 38168 and .properties.code_com_d != 38168) or (.properties.code_com_g != 38168 and .properties.code_com_d == 38168) or ((.properties.code_com_g == 38193 and .properties.code_com_d != 38193) or (.properties.code_com_g != 38193 and .properties.code_com_d == 38193) or ((.properties.code_com_g == 38315 and .properties.code_com_d != 38315) or (.properties.code_com_g != 38315 and .properties.code_com_d == 38315) or ((.properties.code_com_g == 38474 and .properties.code_com_d != 38474) or (.properties.code_com_g != 38474 and .properties.code_com_d == 38474) or ((.properties.code_com_g == 38229 and .properties.code_com_d != 38229) or (.properties.code_com_g != 38229 and .properties.code_com_d == 38229) or ((.properties.code_com_g == 38236 and .properties.code_com_d != 38236) or (.properties.code_com_g != 38236 and .properties.code_com_d == 38236) or ((.properties.code_com_g == 38244 and .properties.code_com_d != 38244) or (.properties.code_com_g != 38244 and .properties.code_com_d == 38244) or ((.properties.code_com_g == 38243 and .properties.code_com_d != 38243) or (.properties.code_com_g != 38243 and .properties.code_com_d == 38243) or ((.properties.code_com_g == 38258 and .properties.code_com_d != 38258) or (.properties.code_com_g != 38258 and .properties.code_com_d == 38258) or ((.properties.code_com_g == 38323 and .properties.code_com_d != 38323) or (.properties.code_com_g != 38323 and .properties.code_com_d == 38323) or ((.properties.code_com_g == 38324 and .properties.code_com_d != 38324) or (.properties.code_com_g != 38324 and .properties.code_com_d == 38324) or ((.properties.code_com_g == 38329 and .properties.code_com_d != 38329) or (.properties.code_com_g != 38329 and .properties.code_com_d == 38329) or ((.properties.code_com_g == 38309 and .properties.code_com_d != 38309) or (.properties.code_com_g != 38309 and .properties.code_com_d == 38309) or ((.properties.code_com_g == 38325 and .properties.code_com_d != 38325) or (.properties.code_com_g != 38325 and .properties.code_com_d == 38325) or ((.properties.code_com_g == 38326 and .properties.code_com_d != 38326) or (.properties.code_com_g != 38326 and .properties.code_com_d == 38326) or ((.properties.code_com_g == 38362 and .properties.code_com_d != 38362) or (.properties.code_com_g != 38362 and .properties.code_com_d == 38362) or ((.properties.code_com_g == 38370 and .properties.code_com_d != 38370) or (.properties.code_com_g != 38370 and .properties.code_com_d == 38370) or ((.properties.code_com_g == 38371 and .properties.code_com_d != 38371) or (.properties.code_com_g != 38371 and .properties.code_com_d == 38371) or ((.properties.code_com_g == 38388 and .properties.code_com_d != 38388) or (.properties.code_com_g != 38388 and .properties.code_com_d == 38388) or ((.properties.code_com_g == 38389 and .properties.code_com_d != 38389) or (.properties.code_com_g != 38389 and .properties.code_com_d == 38389) or ((.properties.code_com_g == 38392 and .properties.code_com_d != 38392) or (.properties.code_com_g != 38392 and .properties.code_com_d == 38392) or ((.properties.code_com_g == 38393 and .properties.code_com_d != 38393) or (.properties.code_com_g != 38393 and .properties.code_com_d == 38393) or ((.properties.code_com_g == 38476 and .properties.code_com_d != 38476) or (.properties.code_com_g != 38476 and .properties.code_com_d == 38476) or ((.properties.code_com_g == 38477 and .properties.code_com_d != 38477) or (.properties.code_com_g != 38477 and .properties.code_com_d == 38477) or ((.properties.code_com_g == 38480 and .properties.code_com_d != 38480) or (.properties.code_com_g != 38480 and .properties.code_com_d == 38480) or ((.properties.code_com_g == 38481 and .properties.code_com_d != 38481) or (.properties.code_com_g != 38481 and .properties.code_com_d == 38481) or ((.properties.code_com_g == 38482 and .properties.code_com_d != 38482) or (.properties.code_com_g != 38482 and .properties.code_com_d == 38482) or ((.properties.code_com_g == 38523 and .properties.code_com_d != 38523) or (.properties.code_com_g != 38523 and .properties.code_com_d == 38523) or ((.properties.code_com_g == 38524 and .properties.code_com_d != 38524) or (.properties.code_com_g != 38524 and .properties.code_com_d == 38524) or ((.properties.code_com_g == 38525 and .properties.code_com_d != 38525) or (.properties.code_com_g != 38525 and .properties.code_com_d == 38525) or ((.properties.code_com_g == 38528 and .properties.code_com_d != 38528) or (.properties.code_com_g != 38528 and .properties.code_com_d == 38528) or ((.properties.code_com_g == 38529 and .properties.code_com_d != 38529) or (.properties.code_com_g != 38529 and .properties.code_com_d == 38529) or ((.properties.code_com_g == 38533 and .properties.code_com_d != 38533) or (.properties.code_com_g != 38533 and .properties.code_com_d == 38533) or ((.properties.code_com_g == 38563 and .properties.code_com_d != 38563) or (.properties.code_com_g != 38563 and .properties.code_com_d == 38563)))]'