My dirty data

co-address-cleaning.json

{
   "alwaysShowComment": false,
   "preview": false,
   "params": {
      "matching": "PATTERN",
      "stopAfterFirstMatch": false,
      "appliesTo": "COLUMNS",
      "normalization": "EXACT",
      "columns": [
         "DIR,C,60",
         "DIR2,C,60"
      ],
      "mapping": [
         {
            "to": "",
            "from": "med\\."
         },
         {
            "to": "carrera $1",
            "from": "^(?:crra|carrera|carre|cra\\.|ccra|caar|car|cra|cr|rc|kra|kr|carr) {0,1}(\\d)"
         },
         {
            "to": "calle $1",
            "from": "^(?:caalle|calle|\\.calle|callle|clle\\.|clle|call|cll|cle|cl|c) {0,1}(\\d)"
         },
         {
            "to": "avenida carrera $1",
            "from": "^(?:av cra|av cr|ak) {0,1}(\\d)"
         },
         {
            "to": "avenida calle $1",
            "from": "^(?:av cll|av cl|ac) {0,1}(\\d)"
         },
         {
            "to": "avenida $1",
            "from": "^(?:av\\.|avda|ave|av) {0,1}(\\d| .*?\\b.*\\b)"
         },
         {
            "to": "transversal $1",
            "from": "^(?:tans|trasversal|transversl|transv|trans|transv\\.|tranvs|tranv|trasnv|trasv|tran|trav|tras|tra|trv|trnsv|trns|trn|tr|tv) {0,1}(\\d)"
         },
         {
            "to": "diagonal $1",
            "from": "^(?:dgonal|d/gonal|diagn|diag|dia|dig|dgnal|dg) {0,1}(\\d)"
         },
         {
            "to": "circunvalar $1",
            "from": "^(?:circunvalar|circunvala|circunval|circunva|circunv|circun|circu|circ\\.|circ|cir|ci) {0,1}(\\d)"
         },
         {
            "to": "autopista $1",
            "from": "^(?:autop|auto|aut) {0,1}(\\d| .*?\\b.*\\b)"
         },
         {
            "to": " # $1",
            "from": " (?:n\\.|n o|no(?!rte))(?:\\.|)(?: |)(\\w)"
         },
         {
            "to": " oeste ",
            "from": " oest "
         },
         {
            "to": "",
            "from": "\\*"
         },
         {
            "to": "",
            "from": "^nn$"
         },
         {
            "to": " ",
            "from": "\\."
         },
         {
            "to": "$1 $2",
            "from": "(\\d[a-z])(\\d{1,7})$"
         }
      ],
      "output": ""
   },
   "type": "FindReplace",
   "disabled": false,
   "metaType": "PROCESSOR"
}