{ "currentVersion": 10.81, "id": 9, "name": "Lead Service Replaced WO", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 103508, "latestWkid": 103508 }, "copyrightText": "", "parentLayer": { "id": 0, "name": "Water Work Orders" }, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "DESCRIPTION", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "a0923ffa6ebfcb46d608f73a6063a344", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAfZJREFUSIm91rtrFFEUB+DvxiVrMIpgQDCKiIriI4iIjVjYWlkkRapELSRubFJa+0AQlPwLdioIPlBSmIC2KdTOShBiIdiJLoa9FjM7mc3OrjNBvd0995z5+N2ZYmr+06pVHYhRCEH8p1CMdmGh1fIuBFMhWP3rUILUl2geDMFRDMZosixWCsojufJ4elYK+yMUo1HqixnyE4MYqIb1hbqQ77iOE5iqhvWEeiLzuaYKWCGUIJZoHsgj7+cT5z6GL1XDuqA1RAfSTnIcm9rNFbAOKEa7sViErGAWVzCUHyqJZVA/5Afu4Q3Orb+Cklg+0YsMgduy6xrC4bS8vQhqYztxPquMx1j/THNuXaL66xCaY1nbZbzCcrL9lZYDmqivh2ZwtqOyGkJzqb3JoBCaczGqh2AG7MMjTKxhd3EKH3EED9MQY9OM3MHWNQSTIXhaAIkxasRIERaWk4v/hv14gJuSaM+vMdKNPM7H6/jqclgMwdU8tuUMtS9J3ydcxN46L99y6GR/pAvKYbNpsgy7sMDmaXYsJ0/7Os3gDbaN/hkphHphw8eSZLUJnGa4+J0UIj2hNoZGq9WZzBPJN14B6Qu118CARqslhqAB9nQcl0JKQSk2myZrbAQpDRVglZBKUBuL0Qo+hOBZldnKv1shuFV1ZkPQRtdvS2/QD96gq3wAAAAASUVORK5CYII=", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Replace Lead Service Line", "label": "Replace Lead Service Line", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -1.4198634598604841E7, "ymin": -147113.89208478163, "xmax": 852117.9799512938, "ymax": 7100628.924971553, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PROJECTNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "WORKORDERID", "type": "esriFieldTypeString", "alias": "WORKORDERID", "length": 60, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 60, "domain": null }, { "name": "SUPERVISOR", "type": "esriFieldTypeString", "alias": "SUPERVISOR", "length": 50, "domain": null }, { "name": "REQUESTEDBY", "type": "esriFieldTypeString", "alias": "REQUESTEDBY", "length": 50, "domain": null }, { "name": "INITIATEDBY", "type": "esriFieldTypeString", "alias": "INITIATEDBY", "length": 50, "domain": null }, { "name": "INITIATEDATE", "type": "esriFieldTypeDate", "alias": "INITIATEDATE", "length": 8, "domain": null }, { "name": "PROJECTNAME", "type": "esriFieldTypeString", "alias": "PROJECTNAME", "length": 130, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 256, "domain": null }, { "name": "PROJSTARTDATE", "type": "esriFieldTypeDate", "alias": "PROJSTARTDATE", "length": 8, "domain": null }, { "name": "PROJFINISHDATE", "type": "esriFieldTypeDate", "alias": "PROJFINISHDATE", "length": 8, "domain": null }, { "name": "ACTUALSTARTDATE", "type": "esriFieldTypeDate", "alias": "ACTUALSTARTDATE", "length": 8, "domain": null }, { "name": "ACTUALFINISHDATE", "type": "esriFieldTypeDate", "alias": "ACTUALFINISHDATE", "length": 8, "domain": null }, { "name": "WOCLOSEDBY", "type": "esriFieldTypeString", "alias": "WOCLOSEDBY", "length": 50, "domain": null }, { "name": "CANCEL", "type": "esriFieldTypeString", "alias": "CANCEL", "length": 1, "domain": null }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "PRIORITY", "length": 2, "domain": null }, { "name": "NUMDAYSBEFORE", "type": "esriFieldTypeSmallInteger", "alias": "NUMDAYSBEFORE", "domain": null }, { "name": "DATETOBEPRINTED", "type": "esriFieldTypeDate", "alias": "DATETOBEPRINTED", "length": 8, "domain": null }, { "name": "DATEPRINTED", "type": "esriFieldTypeDate", "alias": "DATEPRINTED", "length": 8, "domain": null }, { "name": "MAPTEMPLATENAME", "type": "esriFieldTypeString", "alias": "MAPTEMPLATENAME", "length": 250, "domain": null }, { "name": "WOMAPEXTENT", "type": "esriFieldTypeString", "alias": "WOMAPEXTENT", "length": 1, "domain": null }, { "name": "WOMAPSCALE", "type": "esriFieldTypeInteger", "alias": "WOMAPSCALE", "domain": null }, { "name": "WOOUTPUT", "type": "esriFieldTypeString", "alias": "WOOUTPUT", "length": 1, "domain": null }, { "name": "SOURCEWOID", "type": "esriFieldTypeString", "alias": "SOURCEWOID", "length": 20, "domain": null }, { "name": "CYCLETYPE", "type": "esriFieldTypeString", "alias": "CYCLETYPE", "length": 1, "domain": null }, { "name": "CYCLEINTERVALNUM", "type": "esriFieldTypeSmallInteger", "alias": "CYCLEINTERVALNUM", "domain": null }, { "name": "CYCLEINTERVALUNIT", "type": "esriFieldTypeString", "alias": "CYCLEINTERVALUNIT", "length": 1, "domain": null }, { "name": "SCHEDULEDATE", "type": "esriFieldTypeDate", "alias": "SCHEDULEDATE", "length": 8, "domain": null }, { "name": "FROMDATE", "type": "esriFieldTypeDate", "alias": "FROMDATE", "length": 8, "domain": null }, { "name": "WOXCOORDINATE", "type": "esriFieldTypeDouble", "alias": "WOXCOORDINATE", "domain": null }, { "name": "WOYCOORDINATE", "type": "esriFieldTypeDouble", "alias": "WOYCOORDINATE", "domain": null }, { "name": "SHOP", "type": "esriFieldTypeString", "alias": "SHOP", "length": 100, "domain": null }, { "name": "WOCATEGORY", "type": "esriFieldTypeString", "alias": "WOCATEGORY", "length": 50, "domain": null }, { "name": "UNATTACHED", "type": "esriFieldTypeString", "alias": "UNATTACHED", "length": 1, "domain": null }, { "name": "WOCOST", "type": "esriFieldTypeDouble", "alias": "WOCOST", "domain": null }, { "name": "WOLABORCOST", "type": "esriFieldTypeDouble", "alias": "WOLABORCOST", "domain": null }, { "name": "WOMATCOST", "type": "esriFieldTypeDouble", "alias": "WOMATCOST", "domain": null }, { "name": "WOEQUIPCOST", "type": "esriFieldTypeDouble", "alias": "WOEQUIPCOST", "domain": null }, { "name": "WOPERMITCOST", "type": "esriFieldTypeDouble", "alias": "WOPERMITCOST", "domain": null }, { "name": "WOTEMPLATEID", "type": "esriFieldTypeString", "alias": "WOTEMPLATEID", "length": 20, "domain": null }, { "name": "ACCTNUM", "type": "esriFieldTypeString", "alias": "ACCTNUM", "length": 50, "domain": null }, { "name": "SUBMITTO", "type": "esriFieldTypeString", "alias": "SUBMITTO", "length": 50, "domain": null }, { "name": "DATESUBMITTO", "type": "esriFieldTypeDate", "alias": "DATESUBMITTO", "length": 8, "domain": null }, { "name": "SUBMITTOOPENBY", "type": "esriFieldTypeString", "alias": "SUBMITTOOPENBY", "length": 50, "domain": null }, { "name": "DATESUBMITTOOPEN", "type": "esriFieldTypeDate", "alias": "DATESUBMITTOOPEN", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": null }, { "name": "CONTRACTORSID", "type": "esriFieldTypeDouble", "alias": "CONTRACTORSID", "domain": null }, { "name": "WORKCOMPLETEDBY", "type": "esriFieldTypeString", "alias": "WORKCOMPLETEDBY", "length": 50, "domain": null }, { "name": "DATEWOCLOSED", "type": "esriFieldTypeDate", "alias": "DATEWOCLOSED", "length": 8, "domain": null }, { "name": "MAPPAGE", "type": "esriFieldTypeString", "alias": "MAPPAGE", "length": 100, "domain": null }, { "name": "LEGALBILLABLE", "type": "esriFieldTypeString", "alias": "LEGALBILLABLE", "length": 1, "domain": null }, { "name": "CONTRBILLABLE", "type": "esriFieldTypeString", "alias": "CONTRBILLABLE", "length": 1, "domain": null }, { "name": "CANCELLEDBY", "type": "esriFieldTypeString", "alias": "CANCELLEDBY", "length": 50, "domain": null }, { "name": "DATECANCELLED", "type": "esriFieldTypeDate", "alias": "DATECANCELLED", "length": 8, "domain": null }, { "name": "CUSTOM1", "type": "esriFieldTypeDouble", "alias": "CUSTOM1", "domain": null }, { "name": "CUSTOM2", "type": "esriFieldTypeDouble", "alias": "CUSTOM2", "domain": null }, { "name": "CUSTOM3", "type": "esriFieldTypeString", "alias": "CUSTOM3", "length": 20, "domain": null }, { "name": "CUSTOM4", "type": "esriFieldTypeString", "alias": "CUSTOM4", "length": 20, "domain": null }, { "name": "CUSTOM5", "type": "esriFieldTypeString", "alias": "CUSTOM5", "length": 40, "domain": null }, { "name": "UPDATEMAP", "type": "esriFieldTypeString", "alias": "UPDATEMAP", "length": 1, "domain": null }, { "name": "TILENO", "type": "esriFieldTypeString", "alias": "TILENO", "length": 100, "domain": null }, { "name": "CYCLEFROM", "type": "esriFieldTypeString", "alias": "CYCLEFROM", "length": 30, "domain": null }, { "name": "APPLYTOENTITY", "type": "esriFieldTypeString", "alias": "APPLYTOENTITY", "length": 50, "domain": null }, { "name": "DOMAINID", "type": "esriFieldTypeDouble", "alias": "DOMAINID", "domain": null }, { "name": "WOCUSTFIELDCATID", "type": "esriFieldTypeDouble", "alias": "WOCUSTFIELDCATID", "domain": null }, { "name": "ASSETGROUP", "type": "esriFieldTypeString", "alias": "ASSETGROUP", "length": 20, "domain": null }, { "name": "WOADDRESS", "type": "esriFieldTypeString", "alias": "WOADDRESS", "length": 130, "domain": null }, { "name": "CREATEDBYCYCLE", "type": "esriFieldTypeString", "alias": "CREATEDBYCYCLE", "length": 1, "domain": null }, { "name": "TRANSTOWOID", "type": "esriFieldTypeString", "alias": "TRANSTOWOID", "length": 20, "domain": null }, { "name": "STAGE", "type": "esriFieldTypeString", "alias": "STAGE", "length": 20, "domain": null }, { "name": "EXPENSETYPE", "type": "esriFieldTypeString", "alias": "EXPENSETYPE", "length": 20, "domain": null }, { "name": "UNITSACCOMPLISHED", "type": "esriFieldTypeDouble", "alias": "UNITSACCOMPLISHED", "domain": null }, { "name": "UNITSACCOMPDESC", "type": "esriFieldTypeString", "alias": "UNITSACCOMPDESC", "length": 40, "domain": null }, { "name": "PROJECTSID", "type": "esriFieldTypeDouble", "alias": "PROJECTSID", "domain": null }, { "name": "CONTRACTWOID", "type": "esriFieldTypeString", "alias": "CONTRACTWOID", "length": 30, "domain": null }, { "name": "STREETNAME", "type": "esriFieldTypeString", "alias": "STREETNAME", "length": 50, "domain": null }, { "name": "LINEITEMCOST", "type": "esriFieldTypeDouble", "alias": "LINEITEMCOST", "domain": null }, { "name": "CANCELREASON", "type": "esriFieldTypeString", "alias": "CANCELREASON", "length": 100, "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": "DISTRICT", "type": "esriFieldTypeString", "alias": "DISTRICT", "length": 50, "domain": null }, { "name": "RESOLUTION", "type": "esriFieldTypeString", "alias": "RESOLUTION", "length": 100, "domain": null }, { "name": "PRIMARYCONTRACTID", "type": "esriFieldTypeInteger", "alias": "PRIMARYCONTRACTID", "domain": null }, { "name": "UNITSACCOMPDESCLOCK", "type": "esriFieldTypeString", "alias": "UNITSACCOMPDESCLOCK", "length": 1, "domain": null }, { "name": "ISREACTIVE", "type": "esriFieldTypeString", "alias": "ISREACTIVE", "length": 1, "domain": null }, { "name": "EFFORT", "type": "esriFieldTypeDouble", "alias": "EFFORT", "domain": null }, { "name": "ACTIVITYZONE", "type": "esriFieldTypeString", "alias": "ACTIVITYZONE", "length": 50, "domain": null }, { "name": "TEXT11", "type": "esriFieldTypeString", "alias": "TEXT11", "length": 100, "domain": null }, { "name": "TEXT12", "type": "esriFieldTypeString", "alias": "TEXT12", "length": 100, "domain": null }, { "name": "TEXT13", "type": "esriFieldTypeString", "alias": "TEXT13", "length": 100, "domain": null }, { "name": "TEXT14", "type": "esriFieldTypeString", "alias": "TEXT14", "length": 100, "domain": null }, { "name": "TEXT15", "type": "esriFieldTypeString", "alias": "TEXT15", "length": 100, "domain": null }, { "name": "TEXT16", "type": "esriFieldTypeString", "alias": "TEXT16", "length": 100, "domain": null }, { "name": "TEXT17", "type": "esriFieldTypeString", "alias": "TEXT17", "length": 100, "domain": null }, { "name": "TEXT18", "type": "esriFieldTypeString", "alias": "TEXT18", "length": 100, "domain": null }, { "name": "TEXT19", "type": "esriFieldTypeString", "alias": "TEXT19", "length": 100, "domain": null }, { "name": "TEXT20", "type": "esriFieldTypeString", "alias": "TEXT20", "length": 100, "domain": null }, { "name": "GUID", "type": "esriFieldTypeString", "alias": "GUID", "length": 50, "domain": null }, { "name": "INITIATEDBYAPP", "type": "esriFieldTypeString", "alias": "INITIATEDBYAPP", "length": 50, "domain": null }, { "name": "SUPERVISORSID", "type": "esriFieldTypeInteger", "alias": "SUPERVISORSID", "domain": null }, { "name": "REQUESTEDBYSID", "type": "esriFieldTypeInteger", "alias": "REQUESTEDBYSID", "domain": null }, { "name": "INITIATEDBYSID", "type": "esriFieldTypeInteger", "alias": "INITIATEDBYSID", "domain": null }, { "name": "SUBMITTOSID", "type": "esriFieldTypeInteger", "alias": "SUBMITTOSID", "domain": null }, { "name": "SUBMITTOOPENBYSID", "type": "esriFieldTypeInteger", "alias": "SUBMITTOOPENBYSID", "domain": null }, { "name": "WORKCOMPLETEDBYSID", "type": "esriFieldTypeInteger", "alias": "WORKCOMPLETEDBYSID", "domain": null }, { "name": "CANCELLEDBYSID", "type": "esriFieldTypeInteger", "alias": "CANCELLEDBYSID", "domain": null }, { "name": "CLOSEDBYSID", "type": "esriFieldTypeInteger", "alias": "CLOSEDBYSID", "domain": null }, { "name": "WORKORDERSID", "type": "esriFieldTypeDouble", "alias": "WORKORDERSID", "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": "PROJECTPHASEID", "type": "esriFieldTypeInteger", "alias": "PROJECTPHASEID", "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "CW_PKEY_519", "fields": "WORKORDERID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "CW_INDEX_458", "fields": "DATETOBEPRINTED", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_459", "fields": "DESCRIPTION", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_460", "fields": "DOMAINID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_461", "fields": "INITIATEDBY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_462", "fields": "PROJECTNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_463", "fields": "SOURCEWOID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_464", "fields": "SUBMITTO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_465", "fields": "WORKCOMPLETEDBY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_WOXCOORDINATE", "fields": "WOXCOORDINATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_WOYCOORDINATE", "fields": "WOYCOORDINATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_511", "fields": "PROJECTSID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_513", "fields": "WOTEMPLATEID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "CW_INDEX_514", "fields": "INITIATEDATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_GUID", "fields": "GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_WORKORDER_INITIATEDBYSID", "fields": "INITIATEDBYSID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_WORKORDER_SUBMITTOSID", "fields": "SUBMITTOSID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_WORKORD_WORKCOMPLETEDBYSID", "fields": "WORKCOMPLETEDBYSID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_WORKORDERSID", "fields": "WORKORDERSID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "Shape", "fields": "Shape", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }