{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 9, "name": "Service Line Inspections", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 3361, "latestWkid": 3361, "xyTolerance": 0.0032808333333333335, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -4.503599627370495E11, "falseY": -4.503599627370495E11, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "Cityworks_NMB.DBO.%INSPECTION.STATUS", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "dc53a81efa5420b5a217b3ec6fa10054", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAsUlEQVQ4jdXTPwrCMBTH8W8hiwoF7WhBB69QQU/gLOghVVy9Q72AayGuHTpkqujwFIJ/IjEi9rckgfDJyyNRfDmqceA59jyiqgGInoKxgsPMDxztwJxeVxic34OFgbyUedaFYScALAzsS1ikst4eZXShTjC3MIB5H9Y6APwkTnCSwErD8lrlRsO4FwCmLZgmck0QbNAOAG+o3cd3adjDrmr5mz6x//EDCET3G3zz/z28AI3VIzyn2VhJAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 15, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "CLOSED", "label": "CLOSED" }, { "symbol": { "type": "esriPMS", "url": "bef350fe719ac894dffde2aa92a3c5b1", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAs0lEQVQ4jdXTPwrCMBTH8W+hUxE6iW6CCEqPIEq9h6hX8w8epLbeoS7du9nBgpMOT2mxEolxML8leRA+JI88lx/HtQ68+Z4eUJQAOG9B34PzWg9sLeByrWr7ethIlkOSyn48hEHXAMxyOJ5gGUq9j2VVoUowSSsMYD6FbWQAfhMlGAawiWD1uOXuAJORAdhrwyyQZ4Jg/Y4B+ETrffwUyz52Ucps6qQ+xw0QcF4P6Ob/e3gHIDUjNetY7wgAAAAASUVORK5CYII=", "contentType": "image/png", "width": 15, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "COMPLETE", "label": "COMPLETE" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 0, 112, 6, 255 ], "toColor": [ 241, 252, 30, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 241, 252, 30, 255 ], "toColor": [ 250, 58, 10, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2674763.311279297, "ymin": 719787.9188842773, "xmax": 2727709.160095215, "ymax": 745929.5162963867, "spatialReference": { "wkid": 3361, "latestWkid": 3361, "xyTolerance": 0.0032808333333333335, "zTolerance": 2, "mTolerance": 0.001, "falseX": -122907600, "falseY": -92800700, "xyUnits": 3.605544920701779E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "sdedata.SDEDATA.WMeter.FacilityID", "typeIdField": "Sub_type", "subtypeFieldName": "Sub_type", "subtypeField": "Sub_type", "defaultSubtypeCode": 4, "fields": [ { "name": "sdedata.SDEDATA.WMeter.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "sdedata.SDEDATA.WMeter.AncillaryRole", "type": "esriFieldTypeSmallInteger", "alias": "AncillaryRole", "domain": null }, { "name": "sdedata.SDEDATA.WMeter.Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sdedata.SDEDATA.WMeter.FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "sdedata.SDEDATA.WMeter.Location", "type": "esriFieldTypeString", "alias": "Location", "length": 100, "domain": null }, { "name": "sdedata.SDEDATA.WMeter.InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "sdedata.SDEDATA.WMeter.LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS2_wLifecycleStatus", "description": "", "codedValues": [ { "name": "Proposed", "code": "PRP" }, { "name": "Active", "code": "ACT" }, { "name": "Abandoned", "code": "ABN" }, { "name": "Removed", "code": "RMV" }, { "name": "Under Construction", "code": "UC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdedata.SDEDATA.WMeter.WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "sdedata.SDEDATA.WMeter.InstallContractor", "type": "esriFieldTypeString", "alias": "InstallContractor", "length": 60, "domain": null }, { "name": "sdedata.SDEDATA.WMeter.Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": null }, { "name": "sdedata.SDEDATA.WMeter.ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "sdedata.SDEDATA.WMeter.Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 20, "domain": { "type": "codedValue", "name": "WS2_wManufacturer", "description": "", "codedValues": [ { "name": "American", "code": "A" }, { "name": "Clow", "code": "C" }, { "name": "Kennedy", "code": "K" }, { "name": "M&H", "code": "MH" }, { "name": "Mueller", "code": "MU" }, { "name": "US Pipe", "code": "USP" }, { "name": "Waterous", "code": "W" }, { "name": "AVK", "code": "AVK" }, { "name": "DRES", "code": "DRES" }, { "name": "TREN", "code": "TREN" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sdedata.SDEDATA.WMeter.Sub_type", "type": "esriFieldTypeInteger", "alias": "Sub_type", "domain": null }, { "name": "sdedata.SDEDATA.WMeter.Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_wMainDistributionDiameter", "description": "", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "16\"", "code": 16 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sdedata.SDEDATA.WMeter.Model", "type": "esriFieldTypeString", "alias": "Model", "length": 20, "domain": null }, { "name": "sdedata.SDEDATA.WMeter.SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 20, "domain": null }, { "name": "sdedata.SDEDATA.WMeter.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INSPECTIONID", "type": "esriFieldTypeDouble", "alias": "INSPECTIONID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.WORKORDERID", "type": "esriFieldTypeString", "alias": "WORKORDERID", "length": 60, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INSPTEMPLATEID", "type": "esriFieldTypeDouble", "alias": "INSPTEMPLATEID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INSPTEMPLATENAME", "type": "esriFieldTypeString", "alias": "INSPTEMPLATENAME", "length": 30, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.ENTITYUID", "type": "esriFieldTypeString", "alias": "ENTITYUID", "length": 50, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.ENTITYTYPE", "type": "esriFieldTypeString", "alias": "ENTITYTYPE", "length": 50, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INSPDATE", "type": "esriFieldTypeDate", "alias": "INSPDATE", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INSPECTEDBY", "type": "esriFieldTypeString", "alias": "INSPECTEDBY", "length": 50, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 256, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.OBSERVATIONSUM", "type": "esriFieldTypeString", "alias": "OBSERVATIONSUM", "length": 900, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.REPAIRSMADE", "type": "esriFieldTypeString", "alias": "REPAIRSMADE", "length": 900, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.FOREMANRECOMND", "type": "esriFieldTypeString", "alias": "FOREMANRECOMND", "length": 900, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.REQUESTID", "type": "esriFieldTypeInteger", "alias": "REQUESTID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.PRJSTARTDATE", "type": "esriFieldTypeDate", "alias": "PRJSTARTDATE", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.PRJFINISHDATE", "type": "esriFieldTypeDate", "alias": "PRJFINISHDATE", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.ACTFINISHDATE", "type": "esriFieldTypeDate", "alias": "ACTFINISHDATE", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.DATECLOSED", "type": "esriFieldTypeDate", "alias": "DATECLOSED", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CLOSEDBY", "type": "esriFieldTypeString", "alias": "CLOSEDBY", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CLOSESR", "type": "esriFieldTypeSmallInteger", "alias": "CLOSESR", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CANCEL", "type": "esriFieldTypeSmallInteger", "alias": "CANCEL", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.DATECANCELLED", "type": "esriFieldTypeDate", "alias": "DATECANCELLED", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CANCELLEDBY", "type": "esriFieldTypeString", "alias": "CANCELLEDBY", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CANCELREASON", "type": "esriFieldTypeString", "alias": "CANCELREASON", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INSPX", "type": "esriFieldTypeDouble", "alias": "INSPX", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INSPY", "type": "esriFieldTypeDouble", "alias": "INSPY", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.DOMAINID", "type": "esriFieldTypeInteger", "alias": "DOMAINID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.FEATURETYPE", "type": "esriFieldTypeString", "alias": "FEATURETYPE", "length": 50, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.FEATUREID", "type": "esriFieldTypeInteger", "alias": "FEATUREID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.FEATUREUID", "type": "esriFieldTypeString", "alias": "FEATUREUID", "length": 50, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.ENTITYSID", "type": "esriFieldTypeInteger", "alias": "ENTITYSID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBY", "type": "esriFieldTypeString", "alias": "INITIATEDBY", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INITIATEDATE", "type": "esriFieldTypeDate", "alias": "INITIATEDATE", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.SHOP", "type": "esriFieldTypeString", "alias": "SHOP", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.MAPPAGE", "type": "esriFieldTypeString", "alias": "MAPPAGE", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.TILENO", "type": "esriFieldTypeString", "alias": "TILENO", "length": 50, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.DISTRICT", "type": "esriFieldTypeString", "alias": "DISTRICT", "length": 50, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.RESOLUTION", "type": "esriFieldTypeString", "alias": "RESOLUTION", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.PRIORITY", "type": "esriFieldTypeString", "alias": "PRIORITY", "length": 50, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.STREETNAME", "type": "esriFieldTypeString", "alias": "STREETNAME", "length": 50, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CONDRATING", "type": "esriFieldTypeDouble", "alias": "CONDRATING", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.TEXT1", "type": "esriFieldTypeString", "alias": "TEXT1", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.TEXT2", "type": "esriFieldTypeString", "alias": "TEXT2", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.TEXT3", "type": "esriFieldTypeString", "alias": "TEXT3", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.TEXT4", "type": "esriFieldTypeString", "alias": "TEXT4", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.TEXT5", "type": "esriFieldTypeString", "alias": "TEXT5", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.TEXT6", "type": "esriFieldTypeString", "alias": "TEXT6", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.TEXT7", "type": "esriFieldTypeString", "alias": "TEXT7", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.TEXT8", "type": "esriFieldTypeString", "alias": "TEXT8", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.TEXT9", "type": "esriFieldTypeString", "alias": "TEXT9", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.TEXT10", "type": "esriFieldTypeString", "alias": "TEXT10", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.NUM1", "type": "esriFieldTypeDouble", "alias": "NUM1", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.NUM2", "type": "esriFieldTypeDouble", "alias": "NUM2", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.NUM3", "type": "esriFieldTypeDouble", "alias": "NUM3", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.NUM4", "type": "esriFieldTypeDouble", "alias": "NUM4", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.NUM5", "type": "esriFieldTypeDouble", "alias": "NUM5", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.DATE1", "type": "esriFieldTypeDate", "alias": "DATE1", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.DATE2", "type": "esriFieldTypeDate", "alias": "DATE2", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.DATE3", "type": "esriFieldTypeDate", "alias": "DATE3", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.DATE4", "type": "esriFieldTypeDate", "alias": "DATE4", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.DATE5", "type": "esriFieldTypeDate", "alias": "DATE5", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CONDSCORE", "type": "esriFieldTypeDouble", "alias": "CONDSCORE", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.UPDATEMAP", "type": "esriFieldTypeString", "alias": "UPDATEMAP", "length": 1, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.SUBMITTOEMPLOYEESID", "type": "esriFieldTypeDouble", "alias": "SUBMITTOEMPLOYEESID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.SUBMITTONAME", "type": "esriFieldTypeString", "alias": "SUBMITTONAME", "length": 100, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.DATESUBMITTO", "type": "esriFieldTypeDate", "alias": "DATESUBMITTO", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.EFFORT", "type": "esriFieldTypeDouble", "alias": "EFFORT", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.PARENTINSPID", "type": "esriFieldTypeInteger", "alias": "PARENTINSPID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CYCLETYPE", "type": "esriFieldTypeString", "alias": "CYCLETYPE", "length": 20, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CYCLEFROM", "type": "esriFieldTypeString", "alias": "CYCLEFROM", "length": 30, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CYCLEINTERVALNUM", "type": "esriFieldTypeInteger", "alias": "CYCLEINTERVALNUM", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CYCLEINTERVALUNIT", "type": "esriFieldTypeString", "alias": "CYCLEINTERVALUNIT", "length": 1, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CREATEDBYCYCLE", "type": "esriFieldTypeSmallInteger", "alias": "CREATEDBYCYCLE", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.FROMDATE", "type": "esriFieldTypeDate", "alias": "FROMDATE", "length": 8, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBYAPP", "type": "esriFieldTypeString", "alias": "INITIATEDBYAPP", "length": 50, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INSPECTEDBYSID", "type": "esriFieldTypeInteger", "alias": "INSPECTEDBYSID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CANCELLEDBYSID", "type": "esriFieldTypeInteger", "alias": "CANCELLEDBYSID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBYSID", "type": "esriFieldTypeInteger", "alias": "INITIATEDBYSID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.CLOSEDBYSID", "type": "esriFieldTypeInteger", "alias": "CLOSEDBYSID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.FACILITY_ID", "type": "esriFieldTypeString", "alias": "FACILITY_ID", "length": 256, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.LEVEL_ID", "type": "esriFieldTypeString", "alias": "LEVEL_ID", "length": 256, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.PROJECTSID", "type": "esriFieldTypeDouble", "alias": "PROJECTSID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.PROJECTPHASEID", "type": "esriFieldTypeInteger", "alias": "PROJECTPHASEID", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.METADATA", "type": "esriFieldTypeString", "alias": "METADATA", "length": 1073741822, "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.INSPZ", "type": "esriFieldTypeDouble", "alias": "INSPZ", "domain": null }, { "name": "Cityworks_NMB.DBO.%INSPECTION.ESRI_OID", "type": "esriFieldTypeInteger", "alias": "ESRI_OID", "domain": null }, { "name": "sdedata.SDEDATA.WMeter.ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "sdedata.SDEDATA.WMeter.Owner", "type": "esriFieldTypeSmallInteger", "alias": "Owner", "domain": { "type": "codedValue", "name": "WS2_Owner", "description": "", "codedValues": [ { "name": "Public", "code": 1 }, { "name": "Private", "code": 2 }, { "name": "Unknown", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "sdedata.SDEDATA.WMeter.Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R421_pk", "fields": "sdedata.SDEDATA.WMeter.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S291_idx", "fields": "sdedata.SDEDATA.WMeter.Shape", "isAscending": true, "isUnique": true, "description": "" }, { "name": "CW_PKEY_235", "fields": "Cityworks_NMB.DBO.%INSPECTION.INSPECTIONID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "CW_INDEX_199", "fields": "Cityworks_NMB.DBO.%INSPECTION.ENTITYTYPE,Cityworks_NMB.DBO.%INSPECTION.ENTITYUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_200", "fields": "Cityworks_NMB.DBO.%INSPECTION.ENTITYUID,Cityworks_NMB.DBO.%INSPECTION.ENTITYTYPE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_201", "fields": "Cityworks_NMB.DBO.%INSPECTION.REQUESTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_202", "fields": "Cityworks_NMB.DBO.%INSPECTION.WORKORDERID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_PROJECTSID", "fields": "Cityworks_NMB.DBO.%INSPECTION.PROJECTSID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_INSPECTIONID", "fields": "Cityworks_NMB.DBO.%INSPECTION.INSPECTIONID", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "sdedata.SDEDATA.WMeter.Enabled": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.LifeCycleStatus": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Manufacturer": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Diameter": {"type": "inherited"} }, "id": 4, "name": "Irrigation" }, { "domains": { "sdedata.SDEDATA.WMeter.Enabled": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.LifeCycleStatus": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Manufacturer": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Diameter": {"type": "inherited"} }, "id": 3, "name": "Fire" }, { "domains": { "sdedata.SDEDATA.WMeter.Enabled": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.LifeCycleStatus": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Manufacturer": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Diameter": {"type": "inherited"} }, "id": 2, "name": "Domestic" }, { "domains": { "sdedata.SDEDATA.WMeter.Enabled": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.LifeCycleStatus": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Manufacturer": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Diameter": {"type": "inherited"} }, "id": 1, "name": "Comercial" } ], "subtypes": [ { "domains": { "sdedata.SDEDATA.WMeter.Enabled": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.LifeCycleStatus": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Manufacturer": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Diameter": {"type": "inherited"} }, "defaultValues": { "sdedata.SDEDATA.WMeter.AncillaryRole": null, "sdedata.SDEDATA.WMeter.Enabled": 1, "sdedata.SDEDATA.WMeter.FacilityID": null, "sdedata.SDEDATA.WMeter.Location": null, "sdedata.SDEDATA.WMeter.InstallDate": null, "sdedata.SDEDATA.WMeter.LifeCycleStatus": null, "sdedata.SDEDATA.WMeter.WarrantyDate": null, "sdedata.SDEDATA.WMeter.InstallContractor": null, "sdedata.SDEDATA.WMeter.Condition": null, "sdedata.SDEDATA.WMeter.ConditionDate": null, "sdedata.SDEDATA.WMeter.Manufacturer": null, "sdedata.SDEDATA.WMeter.Sub_type": 4, "sdedata.SDEDATA.WMeter.Diameter": null, "sdedata.SDEDATA.WMeter.Model": null, "sdedata.SDEDATA.WMeter.SerialNumber": null, "sdedata.SDEDATA.WMeter.ModifiedDate": null, "sdedata.SDEDATA.WMeter.Owner": null, "Cityworks_NMB.DBO.%INSPECTION.INSPECTIONID": null, "Cityworks_NMB.DBO.%INSPECTION.WORKORDERID": null, "Cityworks_NMB.DBO.%INSPECTION.INSPTEMPLATEID": null, "Cityworks_NMB.DBO.%INSPECTION.INSPTEMPLATENAME": null, "Cityworks_NMB.DBO.%INSPECTION.ENTITYUID": null, "Cityworks_NMB.DBO.%INSPECTION.ENTITYTYPE": null, "Cityworks_NMB.DBO.%INSPECTION.INSPDATE": null, "Cityworks_NMB.DBO.%INSPECTION.INSPECTEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.LOCATION": null, "Cityworks_NMB.DBO.%INSPECTION.OBSERVATIONSUM": null, "Cityworks_NMB.DBO.%INSPECTION.REPAIRSMADE": null, "Cityworks_NMB.DBO.%INSPECTION.FOREMANRECOMND": null, "Cityworks_NMB.DBO.%INSPECTION.REQUESTID": null, "Cityworks_NMB.DBO.%INSPECTION.PRJSTARTDATE": null, "Cityworks_NMB.DBO.%INSPECTION.PRJFINISHDATE": null, "Cityworks_NMB.DBO.%INSPECTION.ACTFINISHDATE": null, "Cityworks_NMB.DBO.%INSPECTION.DATECLOSED": null, "Cityworks_NMB.DBO.%INSPECTION.CLOSEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.CLOSESR": null, "Cityworks_NMB.DBO.%INSPECTION.CANCEL": null, "Cityworks_NMB.DBO.%INSPECTION.DATECANCELLED": null, "Cityworks_NMB.DBO.%INSPECTION.CANCELLEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.CANCELREASON": null, "Cityworks_NMB.DBO.%INSPECTION.STATUS": null, "Cityworks_NMB.DBO.%INSPECTION.INSPX": null, "Cityworks_NMB.DBO.%INSPECTION.INSPY": null, "Cityworks_NMB.DBO.%INSPECTION.DOMAINID": null, "Cityworks_NMB.DBO.%INSPECTION.FEATURETYPE": null, "Cityworks_NMB.DBO.%INSPECTION.FEATUREID": null, "Cityworks_NMB.DBO.%INSPECTION.FEATUREUID": null, "Cityworks_NMB.DBO.%INSPECTION.ENTITYSID": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDATE": null, "Cityworks_NMB.DBO.%INSPECTION.SHOP": null, "Cityworks_NMB.DBO.%INSPECTION.MAPPAGE": null, "Cityworks_NMB.DBO.%INSPECTION.TILENO": null, "Cityworks_NMB.DBO.%INSPECTION.DISTRICT": null, "Cityworks_NMB.DBO.%INSPECTION.RESOLUTION": null, "Cityworks_NMB.DBO.%INSPECTION.PRIORITY": null, "Cityworks_NMB.DBO.%INSPECTION.STREETNAME": null, "Cityworks_NMB.DBO.%INSPECTION.CONDRATING": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT1": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT2": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT3": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT4": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT5": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT6": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT7": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT8": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT9": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT10": null, "Cityworks_NMB.DBO.%INSPECTION.NUM1": null, "Cityworks_NMB.DBO.%INSPECTION.NUM2": null, "Cityworks_NMB.DBO.%INSPECTION.NUM3": null, "Cityworks_NMB.DBO.%INSPECTION.NUM4": null, "Cityworks_NMB.DBO.%INSPECTION.NUM5": null, "Cityworks_NMB.DBO.%INSPECTION.DATE1": null, "Cityworks_NMB.DBO.%INSPECTION.DATE2": null, "Cityworks_NMB.DBO.%INSPECTION.DATE3": null, "Cityworks_NMB.DBO.%INSPECTION.DATE4": null, "Cityworks_NMB.DBO.%INSPECTION.DATE5": null, "Cityworks_NMB.DBO.%INSPECTION.CONDSCORE": null, "Cityworks_NMB.DBO.%INSPECTION.UPDATEMAP": null, "Cityworks_NMB.DBO.%INSPECTION.SUBMITTOEMPLOYEESID": null, "Cityworks_NMB.DBO.%INSPECTION.SUBMITTONAME": null, "Cityworks_NMB.DBO.%INSPECTION.DATESUBMITTO": null, "Cityworks_NMB.DBO.%INSPECTION.EFFORT": null, "Cityworks_NMB.DBO.%INSPECTION.PARENTINSPID": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLETYPE": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLEFROM": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLEINTERVALNUM": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLEINTERVALUNIT": null, "Cityworks_NMB.DBO.%INSPECTION.CREATEDBYCYCLE": null, "Cityworks_NMB.DBO.%INSPECTION.FROMDATE": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBYAPP": null, "Cityworks_NMB.DBO.%INSPECTION.INSPECTEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.CANCELLEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.CLOSEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.FACILITY_ID": null, "Cityworks_NMB.DBO.%INSPECTION.LEVEL_ID": null, "Cityworks_NMB.DBO.%INSPECTION.PROJECTSID": null, "Cityworks_NMB.DBO.%INSPECTION.PROJECTPHASEID": null, "Cityworks_NMB.DBO.%INSPECTION.METADATA": null, "Cityworks_NMB.DBO.%INSPECTION.INSPZ": null, "Cityworks_NMB.DBO.%INSPECTION.ESRI_OID": null }, "code": 4, "name": "Irrigation" }, { "domains": { "sdedata.SDEDATA.WMeter.Enabled": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.LifeCycleStatus": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Manufacturer": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Diameter": {"type": "inherited"} }, "defaultValues": { "sdedata.SDEDATA.WMeter.AncillaryRole": null, "sdedata.SDEDATA.WMeter.Enabled": 1, "sdedata.SDEDATA.WMeter.FacilityID": null, "sdedata.SDEDATA.WMeter.Location": null, "sdedata.SDEDATA.WMeter.InstallDate": null, "sdedata.SDEDATA.WMeter.LifeCycleStatus": null, "sdedata.SDEDATA.WMeter.WarrantyDate": null, "sdedata.SDEDATA.WMeter.InstallContractor": null, "sdedata.SDEDATA.WMeter.Condition": null, "sdedata.SDEDATA.WMeter.ConditionDate": null, "sdedata.SDEDATA.WMeter.Manufacturer": null, "sdedata.SDEDATA.WMeter.Sub_type": 3, "sdedata.SDEDATA.WMeter.Diameter": null, "sdedata.SDEDATA.WMeter.Model": null, "sdedata.SDEDATA.WMeter.SerialNumber": null, "sdedata.SDEDATA.WMeter.ModifiedDate": null, "sdedata.SDEDATA.WMeter.Owner": null, "Cityworks_NMB.DBO.%INSPECTION.INSPECTIONID": null, "Cityworks_NMB.DBO.%INSPECTION.WORKORDERID": null, "Cityworks_NMB.DBO.%INSPECTION.INSPTEMPLATEID": null, "Cityworks_NMB.DBO.%INSPECTION.INSPTEMPLATENAME": null, "Cityworks_NMB.DBO.%INSPECTION.ENTITYUID": null, "Cityworks_NMB.DBO.%INSPECTION.ENTITYTYPE": null, "Cityworks_NMB.DBO.%INSPECTION.INSPDATE": null, "Cityworks_NMB.DBO.%INSPECTION.INSPECTEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.LOCATION": null, "Cityworks_NMB.DBO.%INSPECTION.OBSERVATIONSUM": null, "Cityworks_NMB.DBO.%INSPECTION.REPAIRSMADE": null, "Cityworks_NMB.DBO.%INSPECTION.FOREMANRECOMND": null, "Cityworks_NMB.DBO.%INSPECTION.REQUESTID": null, "Cityworks_NMB.DBO.%INSPECTION.PRJSTARTDATE": null, "Cityworks_NMB.DBO.%INSPECTION.PRJFINISHDATE": null, "Cityworks_NMB.DBO.%INSPECTION.ACTFINISHDATE": null, "Cityworks_NMB.DBO.%INSPECTION.DATECLOSED": null, "Cityworks_NMB.DBO.%INSPECTION.CLOSEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.CLOSESR": null, "Cityworks_NMB.DBO.%INSPECTION.CANCEL": null, "Cityworks_NMB.DBO.%INSPECTION.DATECANCELLED": null, "Cityworks_NMB.DBO.%INSPECTION.CANCELLEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.CANCELREASON": null, "Cityworks_NMB.DBO.%INSPECTION.STATUS": null, "Cityworks_NMB.DBO.%INSPECTION.INSPX": null, "Cityworks_NMB.DBO.%INSPECTION.INSPY": null, "Cityworks_NMB.DBO.%INSPECTION.DOMAINID": null, "Cityworks_NMB.DBO.%INSPECTION.FEATURETYPE": null, "Cityworks_NMB.DBO.%INSPECTION.FEATUREID": null, "Cityworks_NMB.DBO.%INSPECTION.FEATUREUID": null, "Cityworks_NMB.DBO.%INSPECTION.ENTITYSID": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDATE": null, "Cityworks_NMB.DBO.%INSPECTION.SHOP": null, "Cityworks_NMB.DBO.%INSPECTION.MAPPAGE": null, "Cityworks_NMB.DBO.%INSPECTION.TILENO": null, "Cityworks_NMB.DBO.%INSPECTION.DISTRICT": null, "Cityworks_NMB.DBO.%INSPECTION.RESOLUTION": null, "Cityworks_NMB.DBO.%INSPECTION.PRIORITY": null, "Cityworks_NMB.DBO.%INSPECTION.STREETNAME": null, "Cityworks_NMB.DBO.%INSPECTION.CONDRATING": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT1": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT2": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT3": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT4": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT5": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT6": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT7": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT8": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT9": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT10": null, "Cityworks_NMB.DBO.%INSPECTION.NUM1": null, "Cityworks_NMB.DBO.%INSPECTION.NUM2": null, "Cityworks_NMB.DBO.%INSPECTION.NUM3": null, "Cityworks_NMB.DBO.%INSPECTION.NUM4": null, "Cityworks_NMB.DBO.%INSPECTION.NUM5": null, "Cityworks_NMB.DBO.%INSPECTION.DATE1": null, "Cityworks_NMB.DBO.%INSPECTION.DATE2": null, "Cityworks_NMB.DBO.%INSPECTION.DATE3": null, "Cityworks_NMB.DBO.%INSPECTION.DATE4": null, "Cityworks_NMB.DBO.%INSPECTION.DATE5": null, "Cityworks_NMB.DBO.%INSPECTION.CONDSCORE": null, "Cityworks_NMB.DBO.%INSPECTION.UPDATEMAP": null, "Cityworks_NMB.DBO.%INSPECTION.SUBMITTOEMPLOYEESID": null, "Cityworks_NMB.DBO.%INSPECTION.SUBMITTONAME": null, "Cityworks_NMB.DBO.%INSPECTION.DATESUBMITTO": null, "Cityworks_NMB.DBO.%INSPECTION.EFFORT": null, "Cityworks_NMB.DBO.%INSPECTION.PARENTINSPID": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLETYPE": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLEFROM": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLEINTERVALNUM": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLEINTERVALUNIT": null, "Cityworks_NMB.DBO.%INSPECTION.CREATEDBYCYCLE": null, "Cityworks_NMB.DBO.%INSPECTION.FROMDATE": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBYAPP": null, "Cityworks_NMB.DBO.%INSPECTION.INSPECTEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.CANCELLEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.CLOSEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.FACILITY_ID": null, "Cityworks_NMB.DBO.%INSPECTION.LEVEL_ID": null, "Cityworks_NMB.DBO.%INSPECTION.PROJECTSID": null, "Cityworks_NMB.DBO.%INSPECTION.PROJECTPHASEID": null, "Cityworks_NMB.DBO.%INSPECTION.METADATA": null, "Cityworks_NMB.DBO.%INSPECTION.INSPZ": null, "Cityworks_NMB.DBO.%INSPECTION.ESRI_OID": null }, "code": 3, "name": "Fire" }, { "domains": { "sdedata.SDEDATA.WMeter.Enabled": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.LifeCycleStatus": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Manufacturer": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Diameter": {"type": "inherited"} }, "defaultValues": { "sdedata.SDEDATA.WMeter.AncillaryRole": null, "sdedata.SDEDATA.WMeter.Enabled": 1, "sdedata.SDEDATA.WMeter.FacilityID": null, "sdedata.SDEDATA.WMeter.Location": null, "sdedata.SDEDATA.WMeter.InstallDate": null, "sdedata.SDEDATA.WMeter.LifeCycleStatus": null, "sdedata.SDEDATA.WMeter.WarrantyDate": null, "sdedata.SDEDATA.WMeter.InstallContractor": null, "sdedata.SDEDATA.WMeter.Condition": null, "sdedata.SDEDATA.WMeter.ConditionDate": null, "sdedata.SDEDATA.WMeter.Manufacturer": null, "sdedata.SDEDATA.WMeter.Sub_type": 2, "sdedata.SDEDATA.WMeter.Diameter": null, "sdedata.SDEDATA.WMeter.Model": null, "sdedata.SDEDATA.WMeter.SerialNumber": null, "sdedata.SDEDATA.WMeter.ModifiedDate": null, "sdedata.SDEDATA.WMeter.Owner": null, "Cityworks_NMB.DBO.%INSPECTION.INSPECTIONID": null, "Cityworks_NMB.DBO.%INSPECTION.WORKORDERID": null, "Cityworks_NMB.DBO.%INSPECTION.INSPTEMPLATEID": null, "Cityworks_NMB.DBO.%INSPECTION.INSPTEMPLATENAME": null, "Cityworks_NMB.DBO.%INSPECTION.ENTITYUID": null, "Cityworks_NMB.DBO.%INSPECTION.ENTITYTYPE": null, "Cityworks_NMB.DBO.%INSPECTION.INSPDATE": null, "Cityworks_NMB.DBO.%INSPECTION.INSPECTEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.LOCATION": null, "Cityworks_NMB.DBO.%INSPECTION.OBSERVATIONSUM": null, "Cityworks_NMB.DBO.%INSPECTION.REPAIRSMADE": null, "Cityworks_NMB.DBO.%INSPECTION.FOREMANRECOMND": null, "Cityworks_NMB.DBO.%INSPECTION.REQUESTID": null, "Cityworks_NMB.DBO.%INSPECTION.PRJSTARTDATE": null, "Cityworks_NMB.DBO.%INSPECTION.PRJFINISHDATE": null, "Cityworks_NMB.DBO.%INSPECTION.ACTFINISHDATE": null, "Cityworks_NMB.DBO.%INSPECTION.DATECLOSED": null, "Cityworks_NMB.DBO.%INSPECTION.CLOSEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.CLOSESR": null, "Cityworks_NMB.DBO.%INSPECTION.CANCEL": null, "Cityworks_NMB.DBO.%INSPECTION.DATECANCELLED": null, "Cityworks_NMB.DBO.%INSPECTION.CANCELLEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.CANCELREASON": null, "Cityworks_NMB.DBO.%INSPECTION.STATUS": null, "Cityworks_NMB.DBO.%INSPECTION.INSPX": null, "Cityworks_NMB.DBO.%INSPECTION.INSPY": null, "Cityworks_NMB.DBO.%INSPECTION.DOMAINID": null, "Cityworks_NMB.DBO.%INSPECTION.FEATURETYPE": null, "Cityworks_NMB.DBO.%INSPECTION.FEATUREID": null, "Cityworks_NMB.DBO.%INSPECTION.FEATUREUID": null, "Cityworks_NMB.DBO.%INSPECTION.ENTITYSID": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDATE": null, "Cityworks_NMB.DBO.%INSPECTION.SHOP": null, "Cityworks_NMB.DBO.%INSPECTION.MAPPAGE": null, "Cityworks_NMB.DBO.%INSPECTION.TILENO": null, "Cityworks_NMB.DBO.%INSPECTION.DISTRICT": null, "Cityworks_NMB.DBO.%INSPECTION.RESOLUTION": null, "Cityworks_NMB.DBO.%INSPECTION.PRIORITY": null, "Cityworks_NMB.DBO.%INSPECTION.STREETNAME": null, "Cityworks_NMB.DBO.%INSPECTION.CONDRATING": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT1": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT2": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT3": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT4": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT5": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT6": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT7": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT8": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT9": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT10": null, "Cityworks_NMB.DBO.%INSPECTION.NUM1": null, "Cityworks_NMB.DBO.%INSPECTION.NUM2": null, "Cityworks_NMB.DBO.%INSPECTION.NUM3": null, "Cityworks_NMB.DBO.%INSPECTION.NUM4": null, "Cityworks_NMB.DBO.%INSPECTION.NUM5": null, "Cityworks_NMB.DBO.%INSPECTION.DATE1": null, "Cityworks_NMB.DBO.%INSPECTION.DATE2": null, "Cityworks_NMB.DBO.%INSPECTION.DATE3": null, "Cityworks_NMB.DBO.%INSPECTION.DATE4": null, "Cityworks_NMB.DBO.%INSPECTION.DATE5": null, "Cityworks_NMB.DBO.%INSPECTION.CONDSCORE": null, "Cityworks_NMB.DBO.%INSPECTION.UPDATEMAP": null, "Cityworks_NMB.DBO.%INSPECTION.SUBMITTOEMPLOYEESID": null, "Cityworks_NMB.DBO.%INSPECTION.SUBMITTONAME": null, "Cityworks_NMB.DBO.%INSPECTION.DATESUBMITTO": null, "Cityworks_NMB.DBO.%INSPECTION.EFFORT": null, "Cityworks_NMB.DBO.%INSPECTION.PARENTINSPID": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLETYPE": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLEFROM": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLEINTERVALNUM": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLEINTERVALUNIT": null, "Cityworks_NMB.DBO.%INSPECTION.CREATEDBYCYCLE": null, "Cityworks_NMB.DBO.%INSPECTION.FROMDATE": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBYAPP": null, "Cityworks_NMB.DBO.%INSPECTION.INSPECTEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.CANCELLEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.CLOSEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.FACILITY_ID": null, "Cityworks_NMB.DBO.%INSPECTION.LEVEL_ID": null, "Cityworks_NMB.DBO.%INSPECTION.PROJECTSID": null, "Cityworks_NMB.DBO.%INSPECTION.PROJECTPHASEID": null, "Cityworks_NMB.DBO.%INSPECTION.METADATA": null, "Cityworks_NMB.DBO.%INSPECTION.INSPZ": null, "Cityworks_NMB.DBO.%INSPECTION.ESRI_OID": null }, "code": 2, "name": "Domestic" }, { "domains": { "sdedata.SDEDATA.WMeter.Enabled": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.LifeCycleStatus": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Manufacturer": {"type": "inherited"}, "sdedata.SDEDATA.WMeter.Diameter": {"type": "inherited"} }, "defaultValues": { "sdedata.SDEDATA.WMeter.AncillaryRole": null, "sdedata.SDEDATA.WMeter.Enabled": 1, "sdedata.SDEDATA.WMeter.FacilityID": null, "sdedata.SDEDATA.WMeter.Location": null, "sdedata.SDEDATA.WMeter.InstallDate": null, "sdedata.SDEDATA.WMeter.LifeCycleStatus": null, "sdedata.SDEDATA.WMeter.WarrantyDate": null, "sdedata.SDEDATA.WMeter.InstallContractor": null, "sdedata.SDEDATA.WMeter.Condition": null, "sdedata.SDEDATA.WMeter.ConditionDate": null, "sdedata.SDEDATA.WMeter.Manufacturer": null, "sdedata.SDEDATA.WMeter.Sub_type": 1, "sdedata.SDEDATA.WMeter.Diameter": null, "sdedata.SDEDATA.WMeter.Model": null, "sdedata.SDEDATA.WMeter.SerialNumber": null, "sdedata.SDEDATA.WMeter.ModifiedDate": null, "sdedata.SDEDATA.WMeter.Owner": null, "Cityworks_NMB.DBO.%INSPECTION.INSPECTIONID": null, "Cityworks_NMB.DBO.%INSPECTION.WORKORDERID": null, "Cityworks_NMB.DBO.%INSPECTION.INSPTEMPLATEID": null, "Cityworks_NMB.DBO.%INSPECTION.INSPTEMPLATENAME": null, "Cityworks_NMB.DBO.%INSPECTION.ENTITYUID": null, "Cityworks_NMB.DBO.%INSPECTION.ENTITYTYPE": null, "Cityworks_NMB.DBO.%INSPECTION.INSPDATE": null, "Cityworks_NMB.DBO.%INSPECTION.INSPECTEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.LOCATION": null, "Cityworks_NMB.DBO.%INSPECTION.OBSERVATIONSUM": null, "Cityworks_NMB.DBO.%INSPECTION.REPAIRSMADE": null, "Cityworks_NMB.DBO.%INSPECTION.FOREMANRECOMND": null, "Cityworks_NMB.DBO.%INSPECTION.REQUESTID": null, "Cityworks_NMB.DBO.%INSPECTION.PRJSTARTDATE": null, "Cityworks_NMB.DBO.%INSPECTION.PRJFINISHDATE": null, "Cityworks_NMB.DBO.%INSPECTION.ACTFINISHDATE": null, "Cityworks_NMB.DBO.%INSPECTION.DATECLOSED": null, "Cityworks_NMB.DBO.%INSPECTION.CLOSEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.CLOSESR": null, "Cityworks_NMB.DBO.%INSPECTION.CANCEL": null, "Cityworks_NMB.DBO.%INSPECTION.DATECANCELLED": null, "Cityworks_NMB.DBO.%INSPECTION.CANCELLEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.CANCELREASON": null, "Cityworks_NMB.DBO.%INSPECTION.STATUS": null, "Cityworks_NMB.DBO.%INSPECTION.INSPX": null, "Cityworks_NMB.DBO.%INSPECTION.INSPY": null, "Cityworks_NMB.DBO.%INSPECTION.DOMAINID": null, "Cityworks_NMB.DBO.%INSPECTION.FEATURETYPE": null, "Cityworks_NMB.DBO.%INSPECTION.FEATUREID": null, "Cityworks_NMB.DBO.%INSPECTION.FEATUREUID": null, "Cityworks_NMB.DBO.%INSPECTION.ENTITYSID": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBY": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDATE": null, "Cityworks_NMB.DBO.%INSPECTION.SHOP": null, "Cityworks_NMB.DBO.%INSPECTION.MAPPAGE": null, "Cityworks_NMB.DBO.%INSPECTION.TILENO": null, "Cityworks_NMB.DBO.%INSPECTION.DISTRICT": null, "Cityworks_NMB.DBO.%INSPECTION.RESOLUTION": null, "Cityworks_NMB.DBO.%INSPECTION.PRIORITY": null, "Cityworks_NMB.DBO.%INSPECTION.STREETNAME": null, "Cityworks_NMB.DBO.%INSPECTION.CONDRATING": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT1": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT2": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT3": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT4": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT5": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT6": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT7": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT8": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT9": null, "Cityworks_NMB.DBO.%INSPECTION.TEXT10": null, "Cityworks_NMB.DBO.%INSPECTION.NUM1": null, "Cityworks_NMB.DBO.%INSPECTION.NUM2": null, "Cityworks_NMB.DBO.%INSPECTION.NUM3": null, "Cityworks_NMB.DBO.%INSPECTION.NUM4": null, "Cityworks_NMB.DBO.%INSPECTION.NUM5": null, "Cityworks_NMB.DBO.%INSPECTION.DATE1": null, "Cityworks_NMB.DBO.%INSPECTION.DATE2": null, "Cityworks_NMB.DBO.%INSPECTION.DATE3": null, "Cityworks_NMB.DBO.%INSPECTION.DATE4": null, "Cityworks_NMB.DBO.%INSPECTION.DATE5": null, "Cityworks_NMB.DBO.%INSPECTION.CONDSCORE": null, "Cityworks_NMB.DBO.%INSPECTION.UPDATEMAP": null, "Cityworks_NMB.DBO.%INSPECTION.SUBMITTOEMPLOYEESID": null, "Cityworks_NMB.DBO.%INSPECTION.SUBMITTONAME": null, "Cityworks_NMB.DBO.%INSPECTION.DATESUBMITTO": null, "Cityworks_NMB.DBO.%INSPECTION.EFFORT": null, "Cityworks_NMB.DBO.%INSPECTION.PARENTINSPID": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLETYPE": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLEFROM": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLEINTERVALNUM": null, "Cityworks_NMB.DBO.%INSPECTION.CYCLEINTERVALUNIT": null, "Cityworks_NMB.DBO.%INSPECTION.CREATEDBYCYCLE": null, "Cityworks_NMB.DBO.%INSPECTION.FROMDATE": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBYAPP": null, "Cityworks_NMB.DBO.%INSPECTION.INSPECTEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.CANCELLEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.INITIATEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.CLOSEDBYSID": null, "Cityworks_NMB.DBO.%INSPECTION.FACILITY_ID": null, "Cityworks_NMB.DBO.%INSPECTION.LEVEL_ID": null, "Cityworks_NMB.DBO.%INSPECTION.PROJECTSID": null, "Cityworks_NMB.DBO.%INSPECTION.PROJECTPHASEID": null, "Cityworks_NMB.DBO.%INSPECTION.METADATA": null, "Cityworks_NMB.DBO.%INSPECTION.INSPZ": null, "Cityworks_NMB.DBO.%INSPECTION.ESRI_OID": null }, "code": 1, "name": "Comercial" } ], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsPagination": false, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Cityworks_NMB.azteca.INSPECTION", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "INSPTEMPLATENAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "INSPECTIONID", "type": "esriFieldTypeDouble", "alias": "INSPECTIONID", "domain": null }, { "name": "WORKORDERID", "type": "esriFieldTypeString", "alias": "WORKORDERID", "length": 60, "domain": null }, { "name": "INSPTEMPLATEID", "type": "esriFieldTypeDouble", "alias": "INSPTEMPLATEID", "domain": null }, { "name": "INSPTEMPLATENAME", "type": "esriFieldTypeString", "alias": "INSPTEMPLATENAME", "length": 30, "domain": null }, { "name": "ENTITYUID", "type": "esriFieldTypeString", "alias": "ENTITYUID", "length": 50, "domain": null }, { "name": "ENTITYTYPE", "type": "esriFieldTypeString", "alias": "ENTITYTYPE", "length": 50, "domain": null }, { "name": "INSPDATE", "type": "esriFieldTypeDate", "alias": "INSPDATE", "length": 8, "domain": null }, { "name": "INSPECTEDBY", "type": "esriFieldTypeString", "alias": "INSPECTEDBY", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 256, "domain": null }, { "name": "OBSERVATIONSUM", "type": "esriFieldTypeString", "alias": "OBSERVATIONSUM", "length": 900, "domain": null }, { "name": "REPAIRSMADE", "type": "esriFieldTypeString", "alias": "REPAIRSMADE", "length": 900, "domain": null }, { "name": "FOREMANRECOMND", "type": "esriFieldTypeString", "alias": "FOREMANRECOMND", "length": 900, "domain": null }, { "name": "REQUESTID", "type": "esriFieldTypeInteger", "alias": "REQUESTID", "domain": null }, { "name": "PRJSTARTDATE", "type": "esriFieldTypeDate", "alias": "PRJSTARTDATE", "length": 8, "domain": null }, { "name": "PRJFINISHDATE", "type": "esriFieldTypeDate", "alias": "PRJFINISHDATE", "length": 8, "domain": null }, { "name": "ACTFINISHDATE", "type": "esriFieldTypeDate", "alias": "ACTFINISHDATE", "length": 8, "domain": null }, { "name": "DATECLOSED", "type": "esriFieldTypeDate", "alias": "DATECLOSED", "length": 8, "domain": null }, { "name": "CLOSEDBY", "type": "esriFieldTypeString", "alias": "CLOSEDBY", "length": 100, "domain": null }, { "name": "CLOSESR", "type": "esriFieldTypeSmallInteger", "alias": "CLOSESR", "domain": null }, { "name": "CANCEL", "type": "esriFieldTypeSmallInteger", "alias": "CANCEL", "domain": null }, { "name": "DATECANCELLED", "type": "esriFieldTypeDate", "alias": "DATECANCELLED", "length": 8, "domain": null }, { "name": "CANCELLEDBY", "type": "esriFieldTypeString", "alias": "CANCELLEDBY", "length": 100, "domain": null }, { "name": "CANCELREASON", "type": "esriFieldTypeString", "alias": "CANCELREASON", "length": 100, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": null }, { "name": "INSPX", "type": "esriFieldTypeDouble", "alias": "INSPX", "domain": null }, { "name": "INSPY", "type": "esriFieldTypeDouble", "alias": "INSPY", "domain": null }, { "name": "DOMAINID", "type": "esriFieldTypeInteger", "alias": "DOMAINID", "domain": null }, { "name": "FEATURETYPE", "type": "esriFieldTypeString", "alias": "FEATURETYPE", "length": 50, "domain": null }, { "name": "FEATUREID", "type": "esriFieldTypeInteger", "alias": "FEATUREID", "domain": null }, { "name": "FEATUREUID", "type": "esriFieldTypeString", "alias": "FEATUREUID", "length": 50, "domain": null }, { "name": "ENTITYSID", "type": "esriFieldTypeInteger", "alias": "ENTITYSID", "domain": null }, { "name": "INITIATEDBY", "type": "esriFieldTypeString", "alias": "INITIATEDBY", "length": 100, "domain": null }, { "name": "INITIATEDATE", "type": "esriFieldTypeDate", "alias": "INITIATEDATE", "length": 8, "domain": null }, { "name": "SHOP", "type": "esriFieldTypeString", "alias": "SHOP", "length": 100, "domain": null }, { "name": "MAPPAGE", "type": "esriFieldTypeString", "alias": "MAPPAGE", "length": 100, "domain": null }, { "name": "TILENO", "type": "esriFieldTypeString", "alias": "TILENO", "length": 50, "domain": null }, { "name": "DISTRICT", "type": "esriFieldTypeString", "alias": "DISTRICT", "length": 50, "domain": null }, { "name": "RESOLUTION", "type": "esriFieldTypeString", "alias": "RESOLUTION", "length": 100, "domain": null }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "PRIORITY", "length": 50, "domain": null }, { "name": "STREETNAME", "type": "esriFieldTypeString", "alias": "STREETNAME", "length": 50, "domain": null }, { "name": "CONDRATING", "type": "esriFieldTypeDouble", "alias": "CONDRATING", "domain": null }, { "name": "TEXT1", "type": "esriFieldTypeString", "alias": "TEXT1", "length": 100, "domain": null }, { "name": "TEXT2", "type": "esriFieldTypeString", "alias": "TEXT2", "length": 100, "domain": null }, { "name": "TEXT3", "type": "esriFieldTypeString", "alias": "TEXT3", "length": 100, "domain": null }, { "name": "TEXT4", "type": "esriFieldTypeString", "alias": "TEXT4", "length": 100, "domain": null }, { "name": "TEXT5", "type": "esriFieldTypeString", "alias": "TEXT5", "length": 100, "domain": null }, { "name": "TEXT6", "type": "esriFieldTypeString", "alias": "TEXT6", "length": 100, "domain": null }, { "name": "TEXT7", "type": "esriFieldTypeString", "alias": "TEXT7", "length": 100, "domain": null }, { "name": "TEXT8", "type": "esriFieldTypeString", "alias": "TEXT8", "length": 100, "domain": null }, { "name": "TEXT9", "type": "esriFieldTypeString", "alias": "TEXT9", "length": 100, "domain": null }, { "name": "TEXT10", "type": "esriFieldTypeString", "alias": "TEXT10", "length": 100, "domain": null }, { "name": "NUM1", "type": "esriFieldTypeDouble", "alias": "NUM1", "domain": null }, { "name": "NUM2", "type": "esriFieldTypeDouble", "alias": "NUM2", "domain": null }, { "name": "NUM3", "type": "esriFieldTypeDouble", "alias": "NUM3", "domain": null }, { "name": "NUM4", "type": "esriFieldTypeDouble", "alias": "NUM4", "domain": null }, { "name": "NUM5", "type": "esriFieldTypeDouble", "alias": "NUM5", "domain": null }, { "name": "DATE1", "type": "esriFieldTypeDate", "alias": "DATE1", "length": 8, "domain": null }, { "name": "DATE2", "type": "esriFieldTypeDate", "alias": "DATE2", "length": 8, "domain": null }, { "name": "DATE3", "type": "esriFieldTypeDate", "alias": "DATE3", "length": 8, "domain": null }, { "name": "DATE4", "type": "esriFieldTypeDate", "alias": "DATE4", "length": 8, "domain": null }, { "name": "DATE5", "type": "esriFieldTypeDate", "alias": "DATE5", "length": 8, "domain": null }, { "name": "CONDSCORE", "type": "esriFieldTypeDouble", "alias": "CONDSCORE", "domain": null }, { "name": "UPDATEMAP", "type": "esriFieldTypeString", "alias": "UPDATEMAP", "length": 1, "domain": null }, { "name": "SUBMITTOEMPLOYEESID", "type": "esriFieldTypeDouble", "alias": "SUBMITTOEMPLOYEESID", "domain": null }, { "name": "SUBMITTONAME", "type": "esriFieldTypeString", "alias": "SUBMITTONAME", "length": 100, "domain": null }, { "name": "DATESUBMITTO", "type": "esriFieldTypeDate", "alias": "DATESUBMITTO", "length": 8, "domain": null }, { "name": "EFFORT", "type": "esriFieldTypeDouble", "alias": "EFFORT", "domain": null }, { "name": "PARENTINSPID", "type": "esriFieldTypeInteger", "alias": "PARENTINSPID", "domain": null }, { "name": "CYCLETYPE", "type": "esriFieldTypeString", "alias": "CYCLETYPE", "length": 20, "domain": null }, { "name": "CYCLEFROM", "type": "esriFieldTypeString", "alias": "CYCLEFROM", "length": 30, "domain": null }, { "name": "CYCLEINTERVALNUM", "type": "esriFieldTypeInteger", "alias": "CYCLEINTERVALNUM", "domain": null }, { "name": "CYCLEINTERVALUNIT", "type": "esriFieldTypeString", "alias": "CYCLEINTERVALUNIT", "length": 1, "domain": null }, { "name": "CREATEDBYCYCLE", "type": "esriFieldTypeSmallInteger", "alias": "CREATEDBYCYCLE", "domain": null }, { "name": "FROMDATE", "type": "esriFieldTypeDate", "alias": "FROMDATE", "length": 8, "domain": null }, { "name": "INITIATEDBYAPP", "type": "esriFieldTypeString", "alias": "INITIATEDBYAPP", "length": 50, "domain": null }, { "name": "INSPECTEDBYSID", "type": "esriFieldTypeInteger", "alias": "INSPECTEDBYSID", "domain": null }, { "name": "CANCELLEDBYSID", "type": "esriFieldTypeInteger", "alias": "CANCELLEDBYSID", "domain": null }, { "name": "INITIATEDBYSID", "type": "esriFieldTypeInteger", "alias": "INITIATEDBYSID", "domain": null }, { "name": "CLOSEDBYSID", "type": "esriFieldTypeInteger", "alias": "CLOSEDBYSID", "domain": null }, { "name": "FACILITY_ID", "type": "esriFieldTypeString", "alias": "FACILITY_ID", "length": 256, "domain": null }, { "name": "LEVEL_ID", "type": "esriFieldTypeString", "alias": "LEVEL_ID", "length": 256, "domain": null }, { "name": "PROJECTSID", "type": "esriFieldTypeDouble", "alias": "PROJECTSID", "domain": null }, { "name": "PROJECTPHASEID", "type": "esriFieldTypeInteger", "alias": "PROJECTPHASEID", "domain": null }, { "name": "METADATA", "type": "esriFieldTypeString", "alias": "METADATA", "length": 1073741822, "domain": null }, { "name": "INSPZ", "type": "esriFieldTypeDouble", "alias": "INSPZ", "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": [ { "name": "CW_PKEY_235", "fields": "INSPECTIONID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "CW_INDEX_199", "fields": "ENTITYTYPE,ENTITYUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_200", "fields": "ENTITYUID,ENTITYTYPE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_201", "fields": "REQUESTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_202", "fields": "WORKORDERID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_PROJECTSID", "fields": "PROJECTSID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_INSPECTIONID", "fields": "INSPECTIONID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "Cityworks_NMB.azteca.INSPQUESTION", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "QUESTION", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "INSPQUESTIONID", "type": "esriFieldTypeDouble", "alias": "INSPQUESTIONID", "domain": null }, { "name": "INSPECTIONID", "type": "esriFieldTypeDouble", "alias": "INSPECTIONID", "domain": null }, { "name": "QUESTIONID", "type": "esriFieldTypeDouble", "alias": "QUESTIONID", "domain": null }, { "name": "QUESTIONSEQUENCE", "type": "esriFieldTypeInteger", "alias": "QUESTIONSEQUENCE", "domain": null }, { "name": "QUESTION", "type": "esriFieldTypeString", "alias": "QUESTION", "length": 250, "domain": null }, { "name": "ANSWER", "type": "esriFieldTypeString", "alias": "ANSWER", "length": 250, "domain": null }, { "name": "INSTRUCTION", "type": "esriFieldTypeString", "alias": "INSTRUCTION", "length": 512, "domain": null }, { "name": "EXPLANATION", "type": "esriFieldTypeString", "alias": "EXPLANATION", "length": 512, "domain": null }, { "name": "SCORE", "type": "esriFieldTypeDouble", "alias": "SCORE", "domain": null }, { "name": "WEIGHT", "type": "esriFieldTypeDouble", "alias": "WEIGHT", "domain": null }, { "name": "NUMERICANSWER", "type": "esriFieldTypeDouble", "alias": "NUMERICANSWER", "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 256, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": [ { "name": "CW_PKEY_246", "fields": "INSPQUESTIONID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "IX_INSPECTIONID", "fields": "INSPECTIONID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_INSPQUESTIONID", "fields": "INSPQUESTIONID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }