{ "currentVersion": 10.81, "id": 205, "name": "WO Sanitary Pipe - ALL", "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": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 3 }, "label": "", "description": "" }, "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": "esriServerHTMLPopupTypeNone", "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.SD1_SewerPipe_AllWO.WO_NUMBER", "type": "esriFieldTypeString", "alias": "WO Number", "length": 25, "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.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_AllWO.WO_CAT_CD", "type": "esriFieldTypeString", "alias": "WO Category Code", "length": 10, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.WO_CAT_TY", "type": "esriFieldTypeString", "alias": "WO Category", "length": 60, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.WO_PROB_TY", "type": "esriFieldTypeString", "alias": "WO Problem", "length": 40, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.WO_ACTN_TY", "type": "esriFieldTypeString", "alias": "WO Action", "length": 75, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.WO_STAT_TY", "type": "esriFieldTypeString", "alias": "WO Status", "length": 100, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.WO_STAT_DT", "type": "esriFieldTypeDate", "alias": "WO Status Date", "length": 8, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.WO_REAS_TY", "type": "esriFieldTypeString", "alias": "WO Reason", "length": 100, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.WO_SUPR_TY", "type": "esriFieldTypeString", "alias": "WO Supervisor", "length": 100, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.WO_CREW_TY", "type": "esriFieldTypeString", "alias": "WO Crew", "length": 25, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.WO_PRIORTY", "type": "esriFieldTypeString", "alias": "WO Priority", "length": 100, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.AS_WO_COMM", "type": "esriFieldTypeString", "alias": "Asset Comment", "length": 255, "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.WO_INIDATE", "type": "esriFieldTypeDate", "alias": "INIDATE", "length": 8, "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.SD1_SewerPipe_AllWO.DurationHours", "type": "esriFieldTypeDouble", "alias": "Duration Hours", "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.LaborHours", "type": "esriFieldTypeDouble", "alias": "Labor Hours", "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.LaborCost", "type": "esriFieldTypeDouble", "alias": "Labor Cost", "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.MaterialCost", "type": "esriFieldTypeDouble", "alias": "Material Cost", "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.EquipmentCost", "type": "esriFieldTypeDouble", "alias": "Equipment Cost", "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.ContractorCost", "type": "esriFieldTypeDouble", "alias": "Contractor Cost", "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.MiscCost", "type": "esriFieldTypeDouble", "alias": "Misc Cost", "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.TotalCost", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null }, { "name": "gbagis.dbo.SD1_SewerPipe_AllWO.WOCloseOutDate", "type": "esriFieldTypeDate", "alias": "WO CloseOut Date", "length": 8, "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" } } ], "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, "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 }