{ "currentVersion": 10.81, "id": 208, "name": "WO Sanitary Pipe - Open - Maintenance Contract - By Crew", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 2891, "latestWkid": 2891 }, "copyrightText": "", "parentLayer": { "id": 273, "name": "Work Order Layers" }, "subLayers": [], "minScale": 250000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_CREW_TY", "field2": null, "field3": null, "defaultSymbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 197, 255 ], "width": 5 }, "defaultLabel": "Contact GIS", "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 3.4 }, "value": "Dudley Construction", "label": "Dudley Construction", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 3.4 }, "value": "Building Crafts", "label": "Building Crafts", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 3.4 }, "value": "", "label": "", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 3.4 }, "value": "", "label": "", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 3.4 }, "value": "IPWC", "label": "IPWC", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 3.4 }, "value": "Larry Smith Contractors", "label": "Larry Smith Contractors", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 3.4 }, "value": "Miller Pipeline", "label": "Miller Pipeline", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 3.4 }, "value": "Rack &Ballauer Excavating", "label": "Rack &Ballauer Excavating", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 3.4 }, "value": "Robinson Pipe Cleaning", "label": "Robinson Pipe Cleaning", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 0, 0, 255 ], "width": 3.4 }, "value": "Smithcorp", "label": "Smithcorp", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 1471032.925781384, "ymin": 483724.6699743867, "xmax": 1614038.8109908104, "ymax": 594351.0599863082, "spatialReference": { "wkid": 2891, "latestWkid": 2891 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "gbagis.DBO.SWNETG.NTG_USMAN", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "gbagis.DBO.SWNETG.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_USMAN", "type": "esriFieldTypeString", "alias": "US Manhole", "length": 20, "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_DSMAN", "type": "esriFieldTypeString", "alias": "DS Manhole", "length": 20, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_NUMBER", "type": "esriFieldTypeString", "alias": "WO NUMBER", "length": 25, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_CAT_TY", "type": "esriFieldTypeString", "alias": "WO Category", "length": 60, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_PROB_TY", "type": "esriFieldTypeString", "alias": "WO Problem", "length": 40, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_ACTN_TY", "type": "esriFieldTypeString", "alias": "WO Main Task", "length": 75, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_STAT_TY", "type": "esriFieldTypeString", "alias": "WO Status", "length": 100, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_STAT_DT", "type": "esriFieldTypeDate", "alias": "WO Status Date", "length": 8, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_REAS_TY", "type": "esriFieldTypeString", "alias": "WO Reason", "length": 100, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_SUPR_TY", "type": "esriFieldTypeString", "alias": "WO Supervisor", "length": 100, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_CREW_TY", "type": "esriFieldTypeString", "alias": "WO Crew", "length": 25, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_PRIORTY", "type": "esriFieldTypeString", "alias": "WO Priority", "length": 100, "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_OWN_CD", "type": "esriFieldTypeInteger", "alias": "Owner", "domain": { "type": "codedValue", "name": "WS1_swnet_nt_own_cd", "description": "San Pipe Ownership", "codedValues": [ { "name": "N/A", "code": 0 }, { "name": "Private", "code": 1 }, { "name": "Florence", "code": 3 }, { "name": "Walton", "code": 4 }, { "name": "State", "code": 5 }, { "name": "Pending Approval", "code": 6 }, { "name": "Public - Warranty Period", "code": 7 }, { "name": "SD1", "code": 2 }, { "name": "Network Connectivity", "code": 10 }, { "name": "SD1 Private", "code": 15 }, { "name": "Transferred to Covington", "code": 16 }, { "name": "Out of Service Area", "code": 9 }, { "name": "Not SD1", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "gbagis.DBO.SWNETG.NTG_ID", "type": "esriFieldTypeInteger", "alias": "Unique Number", "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_Number", "type": "esriFieldTypeString", "alias": "Alt Pipe ID", "length": 30, "domain": null }, { "name": "gbagis.DBO.SWNETG.NT_DIST_CD", "type": "esriFieldTypeSmallInteger", "alias": "City", "domain": { "type": "codedValue", "name": "WS1_smvcondt_cn_city_cd", "description": "City", "codedValues": [ { "name": "Florence", "code": 31 }, { "name": "Union", "code": 32 }, { "name": "Walton", "code": 33 }, { "name": "Alexandria", "code": 41 }, { "name": "Bellevue", "code": 42 }, { "name": "Cold Spring", "code": 44 }, { "name": "Crestview", "code": 45 }, { "name": "Dayton", "code": 46 }, { "name": "Fort Thomas", "code": 47 }, { "name": "Highland Heights", "code": 48 }, { "name": "Melbourne", "code": 49 }, { "name": "Newport", "code": 52 }, { "name": "Silver Grove", "code": 53 }, { "name": "Southgate", "code": 54 }, { "name": "Wilder", "code": 55 }, { "name": "Woodlawn", "code": 56 }, { "name": "Bromley", "code": 61 }, { "name": "Covington", "code": 62 }, { "name": "Crescent Springs", "code": 64 }, { "name": "Crestview Hills", "code": 65 }, { "name": "Edgewood", "code": 66 }, { "name": "Elsmere", "code": 67 }, { "name": "Erlanger", "code": 68 }, { "name": "Fairview", "code": 69 }, { "name": "Fort Mitchell", "code": 71 }, { "name": "Fort Wright", "code": 72 }, { "name": "Independence", "code": 73 }, { "name": "Lakeside Park", "code": 74 }, { "name": "Ludlow", "code": 76 }, { "name": "Park Hills", "code": 77 }, { "name": "Ryland Heights", "code": 78 }, { "name": "Taylor Mill", "code": 79 }, { "name": "Kenton Vale", "code": 80 }, { "name": "Villa Hills", "code": 81 }, { "name": "Visalia", "code": 83 }, { "name": "N/A", "code": 0 }, { "name": "Unincorp Boone County", "code": 30 }, { "name": "Unincorp Campbell County", "code": 40 }, { "name": "Unincorp Kenton County", "code": 60 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.AS_WO_COMM", "type": "esriFieldTypeString", "alias": "Asset Comment", "length": 255, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_PRIORCD", "type": "esriFieldTypeSmallInteger", "alias": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_PRIORCD", "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_DEPT_CD", "type": "esriFieldTypeString", "alias": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_DEPT_CD", "length": 10, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_DEPT_TY", "type": "esriFieldTypeString", "alias": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.WO_DEPT_TY", "length": 100, "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_USER49", "type": "esriFieldTypeDate", "alias": "Date of Ownership Change", "length": 8, "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_USRIMO", "type": "esriFieldTypeDouble", "alias": "Record US Rim", "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_DSRIMO", "type": "esriFieldTypeDouble", "alias": "Record DS Rim", "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_USER17CD", "type": "esriFieldTypeInteger", "alias": "US Invert Status", "domain": { "type": "codedValue", "name": "WS1_swnet_nt_invertstat_cd", "description": "Sanitary Sewer Invert Status", "codedValues": [ { "name": "N/A", "code": 0 }, { "name": "Digital As-built", "code": 10 }, { "name": "GPS sub-decimeter", "code": 11 }, { "name": "GPS sub-meter", "code": 12 }, { "name": "Drafted As-built", "code": 13 }, { "name": "Estimated", "code": 14 }, { "name": "Accuracy Unknown", "code": 15 }, { "name": "GPS sub-foot", "code": 16 }, { "name": "SevernTrent2001", "code": 17 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gbagis.DBO.SWNETG.NTG_USER33CD", "type": "esriFieldTypeInteger", "alias": "DS Invert Status", "domain": { "type": "codedValue", "name": "WS1_swnet_nt_invertstat_cd", "description": "Sanitary Sewer Invert Status", "codedValues": [ { "name": "N/A", "code": 0 }, { "name": "Digital As-built", "code": 10 }, { "name": "GPS sub-decimeter", "code": 11 }, { "name": "GPS sub-meter", "code": 12 }, { "name": "Drafted As-built", "code": 13 }, { "name": "Estimated", "code": 14 }, { "name": "Accuracy Unknown", "code": 15 }, { "name": "GPS sub-foot", "code": 16 }, { "name": "SevernTrent2001", "code": 17 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gbagis.DBO.SWNETG.NTG_LEN_CD", "type": "esriFieldTypeInteger", "alias": "Length Status", "domain": { "type": "codedValue", "name": "WS1_swnet_nt_lengthstat_cd", "description": "Sanitary Pipe Length Status", "codedValues": [ { "name": "N/A", "code": 0 }, { "name": "Record Drawings", "code": 1 }, { "name": "As-Built Drawings", "code": 2 }, { "name": "TV Inspections", "code": 3 }, { "name": "GPS Points", "code": 4 }, { "name": "Field Inspection", "code": 5 }, { "name": "GIS", "code": 6 }, { "name": "Improvement Drawings", "code": 7 }, { "name": "Inspector's Status Sheet", "code": 8 }, { "name": "Digital As-Built", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "gbagis.DBO.SWNETG.NTG_PROJ_NO", "type": "esriFieldTypeString", "alias": "Project Number", "length": 25, "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_USER9", "type": "esriFieldTypeDate", "alias": "Accepted Date", "length": 8, "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_USER27", "type": "esriFieldTypeString", "alias": "Sub Watershed", "length": 60, "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_USER38", "type": "esriFieldTypeString", "alias": "US Plan Number", "length": 30, "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_USER39", "type": "esriFieldTypeString", "alias": "DS Plan Number", "length": 30, "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_USER46", "type": "esriFieldTypeDate", "alias": "Abandoned Date", "length": 8, "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_US_RIM", "type": "esriFieldTypeDouble", "alias": "US Active Rim", "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_DS_RIM", "type": "esriFieldTypeDouble", "alias": "DS Active Rim", "domain": null }, { "name": "gbagis.DBO.SWNETG.NTG_MANG_CD", "type": "esriFieldTypeInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS1_swnet_nt_own_cd", "description": "San Pipe Ownership", "codedValues": [ { "name": "N/A", "code": 0 }, { "name": "Private", "code": 1 }, { "name": "Florence", "code": 3 }, { "name": "Walton", "code": 4 }, { "name": "State", "code": 5 }, { "name": "Pending Approval", "code": 6 }, { "name": "Public - Warranty Period", "code": 7 }, { "name": "SD1", "code": 2 }, { "name": "Network Connectivity", "code": 10 }, { "name": "SD1 Private", "code": 15 }, { "name": "Transferred to Covington", "code": 16 }, { "name": "Out of Service Area", "code": 9 }, { "name": "Not SD1", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.NT_NUMBER", "type": "esriFieldTypeString", "alias": "gbagis.dbo.SD1_SewerPipe_AllOpenWO.NT_NUMBER", "length": 61, "domain": null } ], "geometryField": {}, "indexes": null, "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "effectiveMinScale": 4514, "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 }