{
"currentVersion": 10.81,
"id": 1,
"name": "SNGRAVITYMAIN",
"type": "Feature Layer",
"description": "",
"geometryType": "esriGeometryPolyline",
"sourceSpatialReference": {
"wkid": 102723,
"latestWkid": 3735
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 72223.819286,
"maxScale": 0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
56,
168,
0,
255
],
"width": 1.25
},
"label": "",
"description": ""
},
"transparency": 0,
"labelingInfo": [
{
"labelPlacement": "esriServerLinePlacementAboveAlong",
"where": null,
"labelExpression": "[SASIZE] CONCAT \" -\" CONCAT [SAMATL]",
"useCodedValues": true,
"symbol": {
"type": "esriTS",
"color": [
0,
0,
0,
255
],
"backgroundColor": null,
"borderLineColor": null,
"borderLineSize": null,
"verticalAlignment": "bottom",
"horizontalAlignment": "center",
"rightToLeft": false,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"kerning": true,
"haloColor": null,
"haloSize": null,
"font": {
"family": "Arial",
"size": 8,
"style": "normal",
"weight": "bold",
"decoration": "none"
}
},
"minScale": 0,
"maxScale": 0
}
]
},
"defaultVisibility": true,
"extent": {
"xmin": 1369225.391779095,
"ymin": 493253.01474663615,
"xmax": 1404231.4610597044,
"ymax": 537260.220611617,
"spatialReference": {
"wkid": 102723,
"latestWkid": 3735
}
},
"hasAttachments": true,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "LEGACYID",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "ASSETID",
"type": "esriFieldTypeString",
"alias": "Cityworks AssetID",
"length": 20,
"domain": null
},
{
"name": "SADNSTA",
"type": "esriFieldTypeDouble",
"alias": "Downstream Station",
"domain": null
},
{
"name": "SAUPSTA",
"type": "esriFieldTypeDouble",
"alias": "Upstream Station",
"domain": null
},
{
"name": "SADNINV",
"type": "esriFieldTypeDouble",
"alias": "Downstream Invert",
"domain": null
},
{
"name": "SAUPINV",
"type": "esriFieldTypeDouble",
"alias": "Upstream Invert",
"domain": null
},
{
"name": "SLOPE",
"type": "esriFieldTypeDouble",
"alias": "SLOPE",
"domain": null
},
{
"name": "SOURCE",
"type": "esriFieldTypeString",
"alias": "SOURCE",
"length": 35,
"domain": null
},
{
"name": "SAMATL",
"type": "esriFieldTypeString",
"alias": "Material",
"length": 3,
"domain": {
"type": "codedValue",
"name": "SNGravityMainMaterial",
"description": "",
"codedValues": [
{
"name": "Concrete",
"code": "CON"
},
{
"name": "Vitrified Clay",
"code": "VCP"
},
{
"name": "Truss",
"code": "TRS"
},
{
"name": "Ductile Iron",
"code": "DCI"
},
{
"name": "Cast Iron",
"code": "CAI"
},
{
"name": "Poured in Place",
"code": "POU"
},
{
"name": "Polyethylene",
"code": "PE"
},
{
"name": "Other",
"code": "OTH"
},
{
"name": "Unknown",
"code": "UNK"
},
{
"name": "Polyvinyl Chloride",
"code": "PVC"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "SADNDRP",
"type": "esriFieldTypeDouble",
"alias": "Downstream Drip",
"domain": null
},
{
"name": "REMARKS",
"type": "esriFieldTypeString",
"alias": "REMARKS",
"length": 255,
"domain": null
},
{
"name": "DATECL",
"type": "esriFieldTypeDate",
"alias": "Date Cleaned",
"length": 8,
"domain": null
},
{
"name": "CLBY",
"type": "esriFieldTypeString",
"alias": "Cleaned By",
"length": 50,
"domain": null
},
{
"name": "TVBY",
"type": "esriFieldTypeString",
"alias": "TV By",
"length": 50,
"domain": null
},
{
"name": "SANRATE",
"type": "esriFieldTypeString",
"alias": "Sanitary Facility Condition",
"length": 2,
"domain": {
"type": "codedValue",
"name": "SNFacilityConditionInd",
"description": "",
"codedValues": [
{
"name": "Very Good",
"code": "1"
},
{
"name": "Good",
"code": "2"
},
{
"name": "Adequate",
"code": "3"
},
{
"name": "Poor",
"code": "4"
},
{
"name": "Rehab or Replace",
"code": "5"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "RETYPE",
"type": "esriFieldTypeString",
"alias": "Rehab Type",
"length": 4,
"domain": {
"type": "codedValue",
"name": "SNGravityMainRehabType",
"description": "",
"codedValues": [
{
"name": "Cured-in-Place",
"code": "CIPP"
},
{
"name": "Fold and Form",
"code": "FF"
},
{
"name": "Joint Seal",
"code": "JS"
},
{
"name": "Bursting",
"code": "B"
},
{
"name": "Slip Lining",
"code": "SL"
},
{
"name": "Remove and Replace",
"code": "RR"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "RESTRICTCLEAN",
"type": "esriFieldTypeString",
"alias": "Restrict Clean",
"length": 1,
"domain": {
"type": "codedValue",
"name": "YesNo_1",
"description": "",
"codedValues": [
{
"name": "Yes",
"code": "Y"
},
{
"name": "No",
"code": "N"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "LINEDINDICATOR",
"type": "esriFieldTypeString",
"alias": "Lined Indicator",
"length": 1,
"domain": {
"type": "codedValue",
"name": "YesNo_1",
"description": "",
"codedValues": [
{
"name": "Yes",
"code": "Y"
},
{
"name": "No",
"code": "N"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "LEASEDINDICATOR",
"type": "esriFieldTypeString",
"alias": "Leased Indicator",
"length": 1,
"domain": {
"type": "codedValue",
"name": "YesNo_1",
"description": "",
"codedValues": [
{
"name": "Yes",
"code": "Y"
},
{
"name": "No",
"code": "N"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "WORKORDERID",
"type": "esriFieldTypeString",
"alias": "Work Order ID",
"length": 15,
"domain": null
},
{
"name": "INSTALLATIONDATE",
"type": "esriFieldTypeDate",
"alias": "INSTALLATIONDATE",
"length": 8,
"domain": null
},
{
"name": "DATETV",
"type": "esriFieldTypeDate",
"alias": "Date TV",
"length": 8,
"domain": null
},
{
"name": "DATERE",
"type": "esriFieldTypeDate",
"alias": "Date RE",
"length": 8,
"domain": null
},
{
"name": "FACILITYID",
"type": "esriFieldTypeString",
"alias": "FACILITYID",
"length": 30,
"domain": null
},
{
"name": "LOCATION",
"type": "esriFieldTypeString",
"alias": "LOCATION",
"length": 255,
"domain": null
},
{
"name": "GM_PRE",
"type": "esriFieldTypeString",
"alias": "GM_PRE",
"length": 3,
"domain": null
},
{
"name": "UPELEV",
"type": "esriFieldTypeDouble",
"alias": "UPELEV",
"domain": null
},
{
"name": "DOWNELEV",
"type": "esriFieldTypeDouble",
"alias": "DOWNELEV",
"domain": null
},
{
"name": "PISTREETFULL",
"type": "esriFieldTypeString",
"alias": "PipeLogix Full Street Address",
"length": 54,
"domain": null
},
{
"name": "PICITY",
"type": "esriFieldTypeString",
"alias": "PipeLogix City",
"length": 64,
"domain": {
"type": "codedValue",
"name": "Communities",
"description": "Butler County Communities",
"codedValues": [
{
"name": "COLLEGE CORNER",
"code": "COLLEGE CORNER"
},
{
"name": "FAIRFIELD",
"code": "FAIRFIELD"
},
{
"name": "FAIRFIELD TWP",
"code": "FAIRFIELD TWP"
},
{
"name": "FOREST PARK",
"code": "FOREST PARK"
},
{
"name": "FRANKLIN",
"code": "FRANKLIN"
},
{
"name": "HAMILTON",
"code": "HAMILTON"
},
{
"name": "HANOVER TWP",
"code": "HANOVER TWP"
},
{
"name": "JACKSONBURG",
"code": "JACKSONBURG"
},
{
"name": "LEMON TWP",
"code": "LEMON TWP"
},
{
"name": "LIBERTY TWP",
"code": "LIBERTY TWP"
},
{
"name": "MADISON TWP",
"code": "MADISON TWP"
},
{
"name": "MIDDLETOWN",
"code": "MIDDLETOWN"
},
{
"name": "MILFORD TWP",
"code": "MILFORD TWP"
},
{
"name": "MILLVILLE",
"code": "MILLVILLE"
},
{
"name": "MONROE",
"code": "MONROE"
},
{
"name": "MORGAN TWP",
"code": "MORGAN TWP"
},
{
"name": "NEW MIAMI",
"code": "NEW MIAMI"
},
{
"name": "OXFORD",
"code": "OXFORD"
},
{
"name": "OXFORD TWP",
"code": "OXFORD TWP"
},
{
"name": "REILY TWP",
"code": "REILY TWP"
},
{
"name": "ROSS TWP",
"code": "ROSS TWP"
},
{
"name": "SEVEN MILE",
"code": "SEVEN MILE"
},
{
"name": "SHARONVILLE",
"code": "SHARONVILLE"
},
{
"name": "SOMERVILLE",
"code": "SOMERVILLE"
},
{
"name": "SPRINGDALE",
"code": "SPRINGDALE"
},
{
"name": "ST CLAIR TWP",
"code": "ST CLAIR TWP"
},
{
"name": "TRENTON",
"code": "TRENTON"
},
{
"name": "WAYNE TWP",
"code": "WAYNE TWP"
},
{
"name": "WEST CHESTER TWP",
"code": "WEST CHESTER TWP"
},
{
"name": "TEST TOWNSHIP",
"code": "TEST TOWNSHIP"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "PIMATERIAL",
"type": "esriFieldTypeString",
"alias": "PipeLogix Material Code",
"length": 6,
"domain": {
"type": "codedValue",
"name": "piPipeMaterial",
"description": "The list of pipe materials types based on the NASSCO standards",
"codedValues": [
{
"name": "ABS Plastic",
"code": "ABS"
},
{
"name": "Asbestos Cement",
"code": "AC"
},
{
"name": "Asphalt",
"code": "ASP"
},
{
"name": "Brick",
"code": "BR"
},
{
"name": "Cast Iron",
"code": "CAS"
},
{
"name": "Clay Tile",
"code": "CT"
},
{
"name": "Concrete (Non-Reinforced)",
"code": "CP"
},
{
"name": "Concrete Segments (Bolted)",
"code": "CSB"
},
{
"name": "Concrete Segments (Unbolted)",
"code": "CSU"
},
{
"name": "Corrugated Metal",
"code": "CMP"
},
{
"name": "Copper",
"code": "COP"
},
{
"name": "Cured In Place",
"code": "CIPP"
},
{
"name": "Ductile Iron",
"code": "DIP"
},
{
"name": "Fiberglass Reinforced",
"code": "FRP"
},
{
"name": "Earth & Geotextile",
"code": "EARGEO"
},
{
"name": "Earthen",
"code": "EAR"
},
{
"name": "Geotextile",
"code": "GEO"
},
{
"name": "Galvanized Pipe",
"code": "GP"
},
{
"name": "Glass Reinforced Cement",
"code": "GRC"
},
{
"name": "Pitch Fiber (Orangeburg)",
"code": "OB"
},
{
"name": "Plastic/Steel Composite",
"code": "PSC"
},
{
"name": "Polyethylene",
"code": "PE"
},
{
"name": "Polypropylene",
"code": "PP"
},
{
"name": "Polyvinyl Chloride",
"code": "PVC"
},
{
"name": "Pre-Stressed Concrete Cylinder",
"code": "PCCP"
},
{
"name": "Reinforced Concrete",
"code": "RCP"
},
{
"name": "Reinforced Plastic (Truss)",
"code": "RPM"
},
{
"name": "Segmented Block",
"code": "SB"
},
{
"name": "Steel",
"code": "SP"
},
{
"name": "Transite",
"code": "TTE"
},
{
"name": "Vitrified Clay",
"code": "VCP"
},
{
"name": "Wood",
"code": "WD"
},
{
"name": "Brick Masonry",
"code": "BMP"
},
{
"name": "High Density Polyethylene",
"code": "HDPE"
},
{
"name": "Other",
"code": "XXX"
},
{
"name": "Unknown",
"code": "ZZZ"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "PISEWERUSE",
"type": "esriFieldTypeString",
"alias": "PipeLogix Sewer Use",
"length": 5,
"domain": {
"type": "codedValue",
"name": "pipeUse",
"description": "pipe used for life expectency",
"codedValues": [
{
"name": "Combined",
"code": "CB"
},
{
"name": "Force Main",
"code": "FM"
},
{
"name": "Other",
"code": "ZZ"
},
{
"name": "Processes",
"code": "PR"
},
{
"name": "Sanitary",
"code": "SS"
},
{
"name": "Stormwater",
"code": "SW"
},
{
"name": "Water",
"code": "W"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "PIPIPESHAPE",
"type": "esriFieldTypeString",
"alias": "PipeLogix Sewer Shape",
"length": 2,
"domain": {
"type": "codedValue",
"name": "piPipeShape",
"description": "NASSCO code to describe sewer shape",
"codedValues": [
{
"name": "Arched",
"code": "A"
},
{
"name": "Barrel",
"code": "B"
},
{
"name": "Circular",
"code": "C"
},
{
"name": "Egg shaped",
"code": "E"
},
{
"name": "Horseshoe",
"code": "H"
},
{
"name": "Oval (elliptical)",
"code": "O"
},
{
"name": "Rectangular",
"code": "R"
},
{
"name": "Square",
"code": "S"
},
{
"name": "Trapezoidal",
"code": "T"
},
{
"name": "U-shaped with flat top (straight walls)",
"code": "U"
},
{
"name": "Other",
"code": "Z"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "PILININGMETHOD",
"type": "esriFieldTypeString",
"alias": "PipeLogix Linning Method",
"length": 2,
"domain": {
"type": "codedValue",
"name": "piPipeLining",
"description": "Lining Method",
"codedValues": [
{
"name": "Fold and Form or Deform/Reform",
"code": "FF"
},
{
"name": "Sprial Wound",
"code": "SW"
},
{
"name": "Segmented Panel",
"code": "SN"
},
{
"name": "Segmented Pipe",
"code": "SP"
},
{
"name": "Other",
"code": "ZZ"
},
{
"name": "Cured-In-Place Pipe",
"code": "CP"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "PILOCATIONCODE",
"type": "esriFieldTypeString",
"alias": "PipeLogix Location Code",
"length": 2,
"domain": {
"type": "codedValue",
"name": "piPipeLocation",
"description": "Location of Sewer Surveyed",
"codedValues": [
{
"name": "Main Highway-urban-Primary Roads",
"code": "A"
},
{
"name": "Main Highway-Secondary Roads",
"code": "B"
},
{
"name": "Light Highway-Local Roads",
"code": "C"
},
{
"name": "Easment/Right of way",
"code": "D"
},
{
"name": "Woods",
"code": "E"
},
{
"name": "Sidewalk",
"code": "F"
},
{
"name": "Parking Lot",
"code": "G"
},
{
"name": "Alley",
"code": "H"
},
{
"name": "Ditch",
"code": "I"
},
{
"name": "Building",
"code": "J"
},
{
"name": "Creek",
"code": "K"
},
{
"name": "Railway",
"code": "L"
},
{
"name": "Airport",
"code": "M"
},
{
"name": "Yard",
"code": "Y"
},
{
"name": "Other",
"code": "Z"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "PIMHUPNUMBER",
"type": "esriFieldTypeString",
"alias": "Pipelogix Upstream Manhole Number",
"length": 25,
"domain": null
},
{
"name": "PIMHDOWNNUMBER",
"type": "esriFieldTypeString",
"alias": "Pipelogix Downstream MH Number",
"length": 25,
"domain": null
},
{
"name": "PIPIPELENGTH",
"type": "esriFieldTypeDouble",
"alias": "PipeLogix PipeLength",
"domain": null
},
{
"name": "PIDRAINAGEBASIN",
"type": "esriFieldTypeString",
"alias": "Pipelogix Drainage Basin ID",
"length": 3,
"domain": null
},
{
"name": "SUMFLOW",
"type": "esriFieldTypeSmallInteger",
"alias": "SUMFLOW",
"domain": null
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38,
"domain": null
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255,
"domain": null
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8,
"domain": null
},
{
"name": "DATELINED",
"type": "esriFieldTypeDate",
"alias": "Date Liined",
"length": 8,
"domain": null
},
{
"name": "LININGPROJECT",
"type": "esriFieldTypeString",
"alias": "Lining Project",
"length": 99,
"domain": null
},
{
"name": "ADDRESS",
"type": "esriFieldTypeString",
"alias": "ADDRESS",
"length": 255,
"domain": null
},
{
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null
},
{
"name": "OWNER",
"type": "esriFieldTypeString",
"alias": "Owner",
"length": 50,
"domain": {
"type": "codedValue",
"name": "SNPublicPrivate",
"description": "",
"codedValues": [
{
"name": "Public",
"code": "Public"
},
{
"name": "Private",
"code": "Private"
},
{
"name": "Unknown",
"code": "Unknown"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "INGROUNDSTATUS",
"type": "esriFieldTypeString",
"alias": "In Ground Status",
"length": 50,
"domain": {
"type": "codedValue",
"name": "ProposedDomain",
"description": "",
"codedValues": [
{
"name": "Proposed",
"code": "Proposed"
},
{
"name": "In-Service",
"code": "InService"
},
{
"name": "Removed",
"code": "Removed"
},
{
"name": "Abandoned",
"code": "Abandoned"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "SASIZE",
"type": "esriFieldTypeInteger",
"alias": "Diameter",
"domain": null
},
{
"name": "SHAPE.STLength()",
"type": "esriFieldTypeDouble",
"alias": "SHAPE.STLength()",
"domain": null
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE"
},
"indexes": [
{
"name": "R1224_pk",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_1224",
"fields": "GlobalID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "UUID_OID_1224",
"fields": "GlobalID,OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "S791_idx",
"fields": "SHAPE",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": true,
"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
}