Skip to content

Instantly share code, notes, and snippets.

@jj0hns0n

jj0hns0n/gist:37e42a6ef5da24afb89c7ff081fe1238

Last active January 4, 2023 00:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jj0hns0n/37e42a6ef5da24afb89c7ff081fe1238 to your computer and use it in GitHub Desktop.
Save jj0hns0n/37e42a6ef5da24afb89c7ff081fe1238 to your computer and use it in GitHub Desktop.
Download ZIP
testing
Raw
gistfile1.txt
{
"jobTypes" : [
{
"featureDefinitions" : [
{
"featureClass" : "Pole",
"geometryType" : "Point",
"featureIdAttribute" : "Number",
"arColor" : "#ffff00",
"fixedDistanceInformation" : {
"maximumDistance" : 2,
"fallbackDistance" : 0.29999999999999999
},
"featureDescriptionSuffix" : "[Number]",
"attributes" : [
{
"name" : "Number",
"type" : "String",
"patterns" : [
{
"pattern" : "^(A[0-9]{7})$",
"positiveValidationStrings" : [
"A1234567",
"A12345678"
],
"negativeValidationStrings" : [
"A123456"
]
}
]
},
{
"patterns" : [
{
"pattern" : "\\b(Wood|Steel|Concrete)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
],
"name" : "Material",
"type" : "String",
"voiceSubstitutions" : {
"steel" : [
"steal"
],
"Wood" : [
"would"
]
}
},
{
"name" : "Height",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(10|15|20|25|30|35|40)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"patterns" : [
{
"pattern" : "\\b(\\d{3})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
],
"function" : "stackedText",
"name" : "Grid ID",
"type" : "String"
},
{
"name" : "Street Light Count",
"type" : "string",
"patterns" : [
]
},
{
"name" : "Security Light Count",
"type" : "string",
"patterns" : [
]
},
{
"name" : "Cable Count",
"type" : "string",
"patterns" : [
]
}
],
"mlModelMapping" : {
"featureClass" : "PoleClose"
}
},
{
"featureClass" : "ElectricCabinet",
"featureDescriptionSuffix" : "[Transformer Number]",
"geometryType" : "Point",
"attributes" : [
{
"patterns" : [
{
"pattern" : "^(\\d{5})$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
],
"mandatory" : true,
"name" : "Transformer Number",
"type" : "String"
},
{
"patterns" : [
{
"pattern" : "^(50|75|150|225|300)$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
},
{
"pattern" : "\\bKVA\\s+0*([1-9]\\d*)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
},
{
"pattern" : "\\b(\\d{2,4})\\s+KVA\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
],
"mandatory" : true,
"name" : "KVA",
"type" : "String"
},
{
"name" : "URL",
"type" : "String",
"patterns" : [
{
"pattern" : "^(http\\S+)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Switch Number",
"type" : "String",
"patterns" : [
{
"pattern" : "^(SW\\d{2,})$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Serial Number",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bS\/N\\s+(\\w+)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
},
{
"pattern" : "(\\bERC\\d+)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
},
{
"pattern" : "\\bSerial Number:\\s+(\\S+)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
},
{
"pattern" : "^(\\d{10}|A\\d{10})$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Manufacturer",
"type" : "String",
"patterns" : [
{
"pattern" : "^(ERMCO|HI|S&C|ER)$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Work Order Due",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bW\/[O0]\\s+Due\\s+([0-9\/]+)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "W\/O #",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(\\d{6}\\.\\d{3})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Catalog Number",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bCatalog Number:\\s+(\\S+)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Voltage",
"type" : "String",
"patterns" : [
{
"pattern" : "^(\\d{2,3}Y?\\s*\/\\s*\\d{2,3})$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Catalog Number",
"type" : "String",
"patterns" : [
{
"pattern" : "^(\\d{4}-\\d{6}-\\d{3})$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Company",
"type" : "String",
"patterns" : [
{
"pattern" : "(?i:\\b(xcel\\s?\\w*)\\b)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "PCB",
"type" : "String",
"patterns" : [
{
"pattern" : "NON PCB",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Weight",
"type" : "String",
"patterns" : [
{
"pattern" : "(\\d+\\s*LBS)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"patterns" : [
{
"pattern" : "\\b(\\d{3})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
],
"function" : "stackedText",
"name" : "Grid ID",
"type" : "String"
},
{
"name" : "Type",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bTYPE\\s+(SCC.*)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Enclosure",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bENCL\\s+(\\w.*)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "File",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bFILE\\s+(\\w.*)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "System",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bSYSTEM\\s+(\\w.*)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Amps Supply",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bAMPS-SUPPLY\\s+(\\d+)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Section",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bSECTION\\s+(\\d+)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Volts",
"type" : "String",
"patterns" : [
{
"pattern" : "^(600)$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "RMS Sym Amps",
"type" : "String",
"patterns" : [
{
"pattern" : "^(85,000)$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
}
],
"arColor" : "#ffff00"
},
{
"featureClass" : "ElectricalMeter",
"geometryType" : "Point",
"featureIdAttribute" : "Number",
"fixedDistanceInformation" : {
"maximumDistance" : 0.5,
"fallbackDistance" : 0.14999999999999999
},
"arColor" : "#ffff00",
"featureDescriptionSuffix" : "[Number]",
"attributes" : [
{
"name" : "Company",
"type" : "String",
"patterns" : [
{
"pattern" : "XCEL ENERGY|Xcel|XCEL|PSCO|PS CO|DUKE ENERGY",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Voltage",
"type" : "String",
"patterns" : [
{
"pattern" : "(\\b\\d*-?\\d+V\\b)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Power",
"type" : "String",
"patterns" : [
{
"pattern" : "(\\b\\d+W\\b)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Frequency",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(\\d+\\s*Hz)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Meter Number",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(\\d{2,3} \\d{3} \\d{3})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Manufacturer",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(Itron|Itrón|ABB)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Model",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(CEN\\w*|SENTINEL)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Kh",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bKh\\s?(\\d+\\.?\\d*\\b)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Kh",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(\\d+\\.?\\d*)\\s?Kh\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Kt",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bKt\\s?(\\d+.?\\d*\\b)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Meter Type",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bTYPE\\s+(\\w+)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Class",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(CL\\s?\\d{2,3})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "TA",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bTA\\s?(\\d{2,3})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
},
{
"pattern" : "\\b(\\d{2,3})\\s?TA\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "FM",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bFM\\s*(\\S+)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "FCC ID",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bFCC ID:\\s+(\\w+)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "IC",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bIC:\\s*(.+),",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "AMI Model",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bMODEL:\\s*(.+)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "AMI ID",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(\\d{5}\\w{5})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Asset ID",
"type" : "String",
"patterns" : [
{
"pattern" : "\\*\\d{7}\\*",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "CA",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bCA\\s?(\\d+\\.?\\d*\\b)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Network type",
"type" : "String",
"patterns" : [
{
"pattern" : "(OpenWay)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Installation date",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b\\d{1,2}\\\/\\d{2}\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Openway number",
"type" : "String",
"patterns" : [
{
"pattern" : "^(\\d{7})$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "AMI type",
"type" : "String",
"patterns" : [
{
"pattern" : "^(AMI)$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Number",
"type" : "String",
"patterns" : [
{
"pattern" : "^(\\d{7,8})$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
}
]
},
{
"featureClass" : "GasMeter",
"geometryType" : "Point",
"featureIdAttribute" : "Number",
"fixedDistanceInformation" : {
"maximumDistance" : 0.5,
"fallbackDistance" : 0.14999999999999999
},
"arColor" : "#ffff00",
"featureDescriptionSuffix" : "[Number]",
"attributes" : [
{
"name" : "Number",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(\\d{7,8})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
}
]
},
{
"geometryType" : "Point",
"featureClass" : "Hydrant",
"attributes" : [
{
"name" : "Year",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(20\\d{2})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Pressure",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(250)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Valve Opening",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(4|5)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
}
],
"arColor" : "#ffff00"
},
{
"featureClass" : "ParkingMeter",
"geometryType" : "Point",
"featureIdAttribute" : "Number",
"fixedDistanceInformation" : {
"maximumDistance" : 1,
"fallbackDistance" : 0.29999999999999999
},
"arColor" : "#ffff00",
"featureDescriptionSuffix" : "[Number]",
"attributes" : [
{
"name" : "Number",
"type" : "String",
"patterns" : [
{
"pattern" : "^(\\w{2}-\\d{4})$",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
}
]
},
{
"geometryType" : "Line",
"featureClass" : "Pipe",
"attributes" : [
],
"arColor" : "#7f007f"
},
{
"geometryType" : "Point",
"featureClass" : "Manhole",
"attributes" : [
{
"name" : "Company",
"type" : "String",
"patterns" : [
{
"pattern" : "(Xcel\\s*\\w*|XCEL\\s*\\w*|PSCO|PS CO|Comcast|COMCAST|comcast|LEVEL|RTD|DENVER|AT&T|Century\\w*|CENTURY\\w*)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Utility Type",
"type" : "String",
"patterns" : [
{
"pattern" : "(WATER|ELEC\\w*|SEWER|STORM|TRAFFIC|COMM\\w*|FIBER\\s?\\w*)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Manufactured",
"type" : "String",
"patterns" : [
{
"pattern" : "(MADE.*)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Installed",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(\\w{3}\\s+20\\d{2})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Number",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(\\d{14})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
}
],
"arColor" : "#ffff00"
},
{
"geometryType" : "Line",
"featureClass" : "Wire",
"attributes" : [
],
"arColor" : "#ff7f00"
},
{
"geometryType" : "Point",
"featureClass" : "Light",
"attributes" : [
{
"name" : "Manufacturer",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(AEL)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Brand",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(ACUITY)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Mfg Date",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bMFG DATE:\\s*(\\d.*)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Style",
"type" : "String",
"patterns" : [
{
"pattern" : "LED LUMINAIRE",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Serial number",
"type" : "String",
"patterns" : [
{
"pattern" : "^(\\*\\d{3}\\w*)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Catalog no",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bCATALOG NO.?\\s*(\\w.*)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Watts",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bWATTS:?\\s*(\\d.*)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Wired at",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bWIRED AT:?\\s*(\\d.*)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Height",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(\\d+FT)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Factory code",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bFACTORY CODE:?\\s+(\\d+)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Assembled in",
"type" : "String",
"patterns" : [
{
"pattern" : "\\bASSEMBLED IN\\s+(\\w.*)\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
}
],
"arColor" : "#ffff00"
},
{
"featureClass" : "LightPoleClose",
"featureIdAttribute" : "Grid ID",
"fixedDistanceInformation" : {
"maximumDistance" : 2,
"fallbackDistance" : 0.29999999999999999
},
"geometryType" : "Point",
"featureDescriptionSuffix" : "[Grid ID] ",
"attributes" : [
{
"name" : "Number",
"type" : "String",
"patterns" : [
{
"pattern" : "\\b(\\d{5})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"name" : "Height",
"type" : "String",
"patterns" : [
{
"pattern" : "(15|20|25|30|35)",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
]
},
{
"patterns" : [
{
"pattern" : "\\b(\\d{3})\\b",
"positiveValidationStrings" : [
],
"negativeValidationStrings" : [
]
}
],
"function" : "stackedText",
"name" : "Grid ID",
"type" : "String"
}
],
"mlModelMapping" : {
"featureClass" : "LightPoleClose"
}
},
{
"geometryType" : "Point",
"attributes" : [
],
"featureClass" : "Pedestal"
},
{
"geometryType" : "Point",
"attributes" : [
],
"featureClass" : "TelecomPedestal"
},
{
"geometryType" : "Point",
"attributes" : [
],
"featureClass" : "HandHole"
},
{
"geometryType" : "Point",
"attributes" : [
],
"featureClass" : "MeterPedestal"
}
],
"lastOfflineModelURL" : "https:\/\/drive.google.com\/uc?export=download&id=1odLsd5TkXUBb7549Yn0K36w3za68sXxZ",
"modelConfigurationURL" : "https:\/\/drive.google.com\/uc?export=download&id=18EkQu8sGEDJFoDGcOZchgLYrULfqCv8U",
"auxiliaryModels" : {
"https:\/\/drive.google.com\/uc?export=download&id=1-18IT3m0haw4c3P57xfPKEeEdbi9Gaoq" : {
"modelMode" : "attributeDetection",
"associatedFeatureClasses" : [
"Pole"
]
}
},
"jobName" : "Utility Demo with Jeff's Model"
}
],
"configurationName" : "Jeff's Config"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment