{ "layers": [ { "currentVersion": 10.91, "id": 0, "name": "Sanitary CCTV Completed 2023", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 2244, "latestWkid": 2965 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 0, 255 ], "width": 3 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -85.91621627624443, "ymin": 41.20552697784264, "xmax": -85.78659362435545, "ymax": 41.29907506989478, "spatialReference": { "wkid": 4326, "latestWkid": 4326 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CollectionSystem.DBO.ssGravityMain.PlaceName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "CollectionSystem.DBO.ssGravityMain.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_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": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "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": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CollectionSystem.DBO.ssGravityMain.MAINSHAPE", "type": "esriFieldTypeString", "alias": "Main Shape", "length": 50, "domain": { "type": "codedValue", "name": "WS2_piPipeShape", "description": "Sanitary and stormwater pipe shapes", "codedValues": [ { "name": "Arched", "code": "A" }, { "name": "Barrel", "code": "B" }, { "name": "Circlular", "code": "C" }, { "name": "Egg Shaped", "code": "E" }, { "name": "Horseshoe", "code": "H" }, { "name": "Oval", "code": "O" }, { "name": "Rectangular", "code": "R" }, { "name": "Square", "code": "S" }, { "name": "Trapezoidal", "code": "T" }, { "name": "U-Shaped", "code": "U" }, { "name": "Other", "code": "Z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.LINEDYEAR", "type": "esriFieldTypeString", "alias": "Year Lined", "length": 4, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LINERTYPE", "type": "esriFieldTypeString", "alias": "Liner Type", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piLiningMethod", "description": "The pipe lining method based on LACP and PACP standards", "codedValues": [ { "name": "Fold and Form or Deform/Reform", "code": "FF" }, { "name": "Segmented Panel", "code": "SN" }, { "name": "Segmented Pipe", "code": "SP" }, { "name": "None", "code": "NONE" }, { "name": "Cured in Place", "code": "C" }, { "name": "Spiral Wound", "code": "H" }, { "name": "Other", "code": "Z" }, { "name": "Lining inserted during manufacture", "code": "A" }, { "name": "Sprayed lining", "code": "B" }, { "name": "Segmented linings", "code": "D" }, { "name": "Lining with descrete pipes", "code": "E" }, { "name": "Lining with continuous pipes", "code": "F" }, { "name": "Close fit lining", "code": "G" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.FROMMH", "type": "esriFieldTypeString", "alias": "From Manhole", "length": 11, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.TOMH", "type": "esriFieldTypeString", "alias": "To Manhole", "length": 11, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CollectionSystem.DBO.ssGravityMain.ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CollectionSystem.DBO.ssGravityMain.OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Stub", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.SLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 26, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.junk", "type": "esriFieldTypeString", "alias": "junk", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.PACP_Use", "type": "esriFieldTypeString", "alias": "PACP_Use", "length": 2, "domain": { "type": "codedValue", "name": "WS2_ssUse", "description": "Sewer Use of Pipe", "codedValues": [ { "name": "Combined", "code": "CB" }, { "name": "Force Main", "code": "FM" }, { "name": "Processes", "code": "PR" }, { "name": "Sanitary", "code": "SS" }, { "name": "Stormwater", "code": "SW" }, { "name": "Other", "code": "ZZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.LOGIX_pipeID", "type": "esriFieldTypeSmallInteger", "alias": "LOGIX_pipeID", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.OLD_UNIQUEID", "type": "esriFieldTypeString", "alias": "OLD_UNIQUEID", "length": 100, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.DUMMY_NOTE", "type": "esriFieldTypeString", "alias": "DUMMY_NOTE", "length": 150, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.PlaceName", "type": "esriFieldTypeString", "alias": "PlaceName", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Location_Code", "type": "esriFieldTypeString", "alias": "Location_Code", "length": 5, "domain": { "type": "codedValue", "name": "WS2_ssLocCode", "description": "Sewer Location Code", "codedValues": [ { "name": "Main Highway - Urban", "code": "A" }, { "name": "Main Highway - Suburnan/Rural", "code": "B" }, { "name": "Light Highway", "code": "C" }, { "name": "Easement / 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": "Metallic Surface", "code": "T" }, { "name": "Yard", "code": "Y" }, { "name": "Other", "code": "Z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.ActivityID", "type": "esriFieldTypeString", "alias": "ActivityID", "length": 20, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LastActivity", "type": "esriFieldTypeString", "alias": "LastActivity", "length": 4, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.DateStamp", "type": "esriFieldTypeDate", "alias": "DateStamp", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.OpTime", "type": "esriFieldTypeString", "alias": "OpTime", "length": 5, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.OeratedBy", "type": "esriFieldTypeString", "alias": "OeratedBy", "length": 30, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.ComputerName", "type": "esriFieldTypeString", "alias": "ComputerName", "length": 30, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Mileage", "type": "esriFieldTypeDouble", "alias": "Mileage", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "length": 200, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Size_1899", "type": "esriFieldTypeSmallInteger", "alias": "Size_1899", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.exist", "type": "esriFieldTypeString", "alias": "exist", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.SRF_PACKAGE", "type": "esriFieldTypeString", "alias": "SRF_PACKAGE", "length": 150, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.RehabID", "type": "esriFieldTypeString", "alias": "RehabID", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.City", "type": "esriFieldTypeString", "alias": "City", "length": 64, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Material_Itpipes", "type": "esriFieldTypeString", "alias": "Material_Itpipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeMaterial_NEW", "description": "Pipe domain to work with IT Pipe Fields", "codedValues": [ { "name": "Acrylonitrile Butadiene Styrene", "code": "Acrylonitrile Butadiene Styrene" }, { "name": "Asbestos Cement", "code": "Asbestos Cement" }, { "name": "Brick", "code": "Brick" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Clay-lined Concrete Pipe", "code": "Clay-lined Concrete Pipe" }, { "name": "Corrugated Metal Pipe", "code": "Corrugated Metal Pipe" }, { "name": "Concrete Pipe (non-reinforced)", "code": "Concrete Pipe (non-reinforced)" }, { "name": "Concrete Segments (bolted)", "code": "Concrete Segments (bolted)" }, { "name": "Concrete Segments (unbolted)", "code": "Concrete Segments (unbolted)" }, { "name": "Clay Tile (not vitrified clay)", "code": "Clay Tile (not vitrified clay)" }, { "name": "Ductile Iron Pipe", "code": "Ductile Iron Pipe" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Pitch Fiber (Orangeburg)", "code": "Pitch Fiber (Orangeburg)" }, { "name": "Polymer Concrete Pipe", "code": "Polymer Concrete Pipe" }, { "name": "Pre-stressed Concrete Cylinder Pipe", "code": "Pre-stressed Concrete Cylinder Pipe" }, { "name": "Polyethylene", "code": "Polyethylene" }, { "name": "Polypropylene", "code": "Polypropylene" }, { "name": "Plastic/Steel Composite", "code": "Plastic/Steel Composite" }, { "name": "Polyvinyl Chloride", "code": "Polyvinyl Chloride" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Reinforced Plastic Pipe (Truss Pipe)", "code": "Reinforced Plastic Pipe (Truss Pipe)" }, { "name": "Segmented Block", "code": "Segmented Block" }, { "name": "Steel Pipe", "code": "Steel Pipe" }, { "name": "Vitrified Clay Pipe", "code": "Vitrified Clay Pipe" }, { "name": "Wood", "code": "Wood" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.WaterTypeITPipes", "type": "esriFieldTypeString", "alias": "WaterTypeITPipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeuse", "description": "DESCRIPT", "codedValues": [ { "name": "Combined Pipe", "code": "Combined Pipe" }, { "name": "Dam Pipe", "code": "Dam Pipe" }, { "name": "Force Main", "code": "Force Main" }, { "name": "Levee Gravity Pipe", "code": "Levee Gravity Pipe" }, { "name": "Levee Pressure Pipe", "code": "Levee Pressure Pipe" }, { "name": "Process Pipe", "code": "Process Pipe" }, { "name": "Sanitary Sewage Pipe", "code": "Sanitary Sewage Pipe" }, { "name": "Stormwater Pipe", "code": "Stormwater Pipe" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.Shape_ITPipes", "type": "esriFieldTypeString", "alias": "Shape_ITPipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeshape", "description": "DESCRIPT", "codedValues": [ { "name": "Arched (with flat bottom)", "code": "Arched (with flat bottom)" }, { "name": "Barrel (e.g. beer barrel shape)", "code": "Barrel (e.g. beer barrel shape)" }, { "name": "Circular", "code": "Circular" }, { "name": "Egg-Shaped", "code": "Egg-Shaped" }, { "name": "Horseshoe (i.e. inverted U with curved sidewalls)", "code": "Horseshoe (i.e. inverted U with curved sidewalls)" }, { "name": "Oval (Elliptical)", "code": "Oval (Elliptical)" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Square", "code": "Square" }, { "name": "Trapezoidal", "code": "Trapezoidal" }, { "name": "U-Shaped with Flat Top (straight walls)", "code": "U-Shaped with Flat Top (straight walls)" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.pipeLiningITPipes", "type": "esriFieldTypeString", "alias": "pipeLiningITPipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeliningmethod", "description": "DESCRIPT", "codedValues": [ { "name": "Cured-In-Place Pipe", "code": "Cured-In-Place Pipe" }, { "name": "Fold and Form or Deform/Reform", "code": "Fold and Form or Deform/Reform" }, { "name": "Formed-In-Place Liner", "code": "Formed-In-Place Liner" }, { "name": "Grout-In-Place Liner", "code": "Grout-In-Place Liner" }, { "name": "Glass Reinforced Cement", "code": "Glass Reinforced Cement" }, { "name": "None", "code": "None" }, { "name": "Continuous Slip Liner", "code": "Continuous Slip Liner" }, { "name": "Sectional Slip Liner", "code": "Sectional Slip Liner" }, { "name": "Spray Liner", "code": "Spray Liner" }, { "name": "Segmented Panel", "code": "Segmented Panel" }, { "name": "Segmented Pipe", "code": "Segmented Pipe" }, { "name": "Spiral Wound", "code": "Spiral Wound" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.TaskID", "type": "esriFieldTypeInteger", "alias": "TaskID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ServiceOrderDetailID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.CreatedByID", "type": "esriFieldTypeInteger", "alias": "CreatedByID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ScheduledStartDate", "type": "esriFieldTypeDate", "alias": "ScheduledStartDate", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ScheduledEndDate", "type": "esriFieldTypeDate", "alias": "ScheduledEndDate", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ActualStartDate", "type": "esriFieldTypeDate", "alias": "ActualStartDate", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ActualEndDate", "type": "esriFieldTypeDate", "alias": "ActualEndDate", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.TaskType", "type": "esriFieldTypeString", "alias": "TaskType", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Completed", "type": "esriFieldTypeSmallInteger", "alias": "Completed", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.IsWorkItemType", "type": "esriFieldTypeSmallInteger", "alias": "IsWorkItemType", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ServiceOrderNumber", "type": "esriFieldTypeString", "alias": "ServiceOrderNumber", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ServiceOrderID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.IsLocation", "type": "esriFieldTypeSmallInteger", "alias": "IsLocation", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.LocationID", "type": "esriFieldTypeString", "alias": "LocationID", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.LocationNo", "type": "esriFieldTypeString", "alias": "LocationNo", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.IsCustomer", "type": "esriFieldTypeSmallInteger", "alias": "IsCustomer", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.CustomerID", "type": "esriFieldTypeString", "alias": "CustomerID", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.CustomerNo", "type": "esriFieldTypeString", "alias": "CustomerNo", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Customer", "type": "esriFieldTypeString", "alias": "Customer", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.IsService", "type": "esriFieldTypeSmallInteger", "alias": "IsService", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ServiceID", "type": "esriFieldTypeString", "alias": "ServiceID", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Service", "type": "esriFieldTypeString", "alias": "Service", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.IsMeter", "type": "esriFieldTypeSmallInteger", "alias": "IsMeter", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.MeterID", "type": "esriFieldTypeString", "alias": "MeterID", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.MeterNo", "type": "esriFieldTypeString", "alias": "MeterNo", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.IsGISAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsGISAsset", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.GISFileID", "type": "esriFieldTypeInteger", "alias": "GISFileID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.GISLayer", "type": "esriFieldTypeString", "alias": "GISLayer", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.IsAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsAsset", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.SchemaDocGuid", "type": "esriFieldTypeGUID", "alias": "SchemaDocGuid", "length": 38, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.UtilityBillingServiceCodeTypeID", "type": "esriFieldTypeInteger", "alias": "UtilityBillingServiceCodeTypeID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.IsUtilityBillingServiceOrder", "type": "esriFieldTypeSmallInteger", "alias": "IsUtilityBillingServiceOrder", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.FeePosted", "type": "esriFieldTypeSmallInteger", "alias": "FeePosted", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.PriorityColor", "type": "esriFieldTypeString", "alias": "PriorityColor", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.FeeAmount", "type": "esriFieldTypeDouble", "alias": "FeeAmount", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.BillToAccount", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary CCTV 2023.BillToAccount", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.CompletedByFirstName", "type": "esriFieldTypeString", "alias": "CompletedByFirstName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.CompletedByLast", "type": "esriFieldTypeString", "alias": "CompletedByLast", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.LastModifiedByID", "type": "esriFieldTypeInteger", "alias": "LastModifiedByID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.LastModified", "type": "esriFieldTypeDate", "alias": "LastModified", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.PriorityID", "type": "esriFieldTypeInteger", "alias": "PriorityID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.StatusID", "type": "esriFieldTypeInteger", "alias": "StatusID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.TaskTypeID", "type": "esriFieldTypeInteger", "alias": "TaskTypeID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ServiceOrderDetailTypeID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailTypeID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.LOC_Address", "type": "esriFieldTypeString", "alias": "LOC_Address", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.LOC_City", "type": "esriFieldTypeString", "alias": "LOC_City", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.CUST_Name", "type": "esriFieldTypeString", "alias": "CUST_Name", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.GIS_AssetTag", "type": "esriFieldTypeString", "alias": "GIS_AssetTag", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.AssetNo", "type": "esriFieldTypeInteger", "alias": "AssetNo", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ASSET_AssetTag", "type": "esriFieldTypeString", "alias": "ASSET_AssetTag", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.AssetLocation", "type": "esriFieldTypeString", "alias": "AssetLocation", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.AssetStatus", "type": "esriFieldTypeString", "alias": "AssetStatus", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.TaskAssignmentCrews", "type": "esriFieldTypeString", "alias": "TaskAssignmentCrews", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.TaskAssignmentUsers", "type": "esriFieldTypeString", "alias": "TaskAssignmentUsers", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.TaskAssignmentContacts", "type": "esriFieldTypeString", "alias": "TaskAssignmentContacts", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.GISAssetNo", "type": "esriFieldTypeString", "alias": "GISAssetNo", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.DivisionID", "type": "esriFieldTypeInteger", "alias": "DivisionID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Expr1", "type": "esriFieldTypeInteger", "alias": "Expr1", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.NoteCount", "type": "esriFieldTypeInteger", "alias": "NoteCount", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Division", "type": "esriFieldTypeString", "alias": "Division", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Problem", "type": "esriFieldTypeString", "alias": "Problem", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ResourcesCount", "type": "esriFieldTypeInteger", "alias": "ResourcesCount", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ServiceOrderCategory", "type": "esriFieldTypeString", "alias": "ServiceOrderCategory", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.ServiceOrderDescription", "type": "esriFieldTypeString", "alias": "ServiceOrderDescription", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Type", "type": "esriFieldTypeString", "alias": "Type", "length": 150, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Resolution", "type": "esriFieldTypeString", "alias": "Resolution", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Total_Labor_Hours", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Hours", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Total_Labor_Cost", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Cost", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.Total_Inventory_fCost", "type": "esriFieldTypeDouble", "alias": "Total_Inventory_fCost", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.InitialResponseByFirstName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary CCTV 2023.InitialResponseByFirstName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.InitialResponseByLastName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary CCTV 2023.InitialResponseByLastName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.WorkCompletedByFirstName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary CCTV 2023.WorkCompletedByFirstName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.WorkCompletedByLastName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary CCTV 2023.WorkCompletedByLastName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.AdminCompletedByFirstName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary CCTV 2023.AdminCompletedByFirstName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary CCTV 2023.AdminCompletedByLastName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary CCTV 2023.AdminCompletedByLastName", "length": 50, "domain": null } ], "geometryField": { "name": "CollectionSystem.DBO.ssGravityMain.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R48_pk", "fields": "CollectionSystem.DBO.ssGravityMain.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_48", "fields": "CollectionSystem.DBO.ssGravityMain.GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_48", "fields": "CollectionSystem.DBO.ssGravityMain.GlobalID,CollectionSystem.DBO.ssGravityMain.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S43_idx", "fields": "CollectionSystem.DBO.ssGravityMain.SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": false, "supportsAdvancedQueries": false, "hasM": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsHavingClause": false, "supportsCountDistinct": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsPagination": false, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true, "serviceItemId": "6afd51ca97a04c2fb315218fffc0f4e6" }, { "currentVersion": 10.91, "id": 1, "name": "ElementsXS.DBO.Sanitary CCTV 2023", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 0, 0, 0 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -85.86022949199997, "ymin": 41.20875549300007, "xmax": -85.84586334199997, "ymax": 41.26371383700007, "spatialReference": { "wkid": 4326, "latestWkid": 4326 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CompletedByFirstName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "TaskID", "type": "esriFieldTypeOID", "alias": "TaskID", "domain": null }, { "name": "ServiceOrderDetailID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailID", "domain": null }, { "name": "CreatedByID", "type": "esriFieldTypeInteger", "alias": "CreatedByID", "domain": null }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "ScheduledStartDate", "type": "esriFieldTypeDate", "alias": "ScheduledStartDate", "length": 8, "domain": null }, { "name": "ScheduledEndDate", "type": "esriFieldTypeDate", "alias": "ScheduledEndDate", "length": 8, "domain": null }, { "name": "ActualStartDate", "type": "esriFieldTypeDate", "alias": "ActualStartDate", "length": 8, "domain": null }, { "name": "ActualEndDate", "type": "esriFieldTypeDate", "alias": "ActualEndDate", "length": 8, "domain": null }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 50, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": null }, { "name": "TaskType", "type": "esriFieldTypeString", "alias": "TaskType", "length": 50, "domain": null }, { "name": "Completed", "type": "esriFieldTypeSmallInteger", "alias": "Completed", "domain": null }, { "name": "IsWorkItemType", "type": "esriFieldTypeSmallInteger", "alias": "IsWorkItemType", "domain": null }, { "name": "ServiceOrderNumber", "type": "esriFieldTypeString", "alias": "ServiceOrderNumber", "length": 50, "domain": null }, { "name": "ServiceOrderID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderID", "domain": null }, { "name": "IsLocation", "type": "esriFieldTypeSmallInteger", "alias": "IsLocation", "domain": null }, { "name": "LocationID", "type": "esriFieldTypeString", "alias": "LocationID", "length": 250, "domain": null }, { "name": "LocationNo", "type": "esriFieldTypeString", "alias": "LocationNo", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "IsCustomer", "type": "esriFieldTypeSmallInteger", "alias": "IsCustomer", "domain": null }, { "name": "CustomerID", "type": "esriFieldTypeString", "alias": "CustomerID", "length": 250, "domain": null }, { "name": "CustomerNo", "type": "esriFieldTypeString", "alias": "CustomerNo", "length": 50, "domain": null }, { "name": "Customer", "type": "esriFieldTypeString", "alias": "Customer", "length": 250, "domain": null }, { "name": "IsService", "type": "esriFieldTypeSmallInteger", "alias": "IsService", "domain": null }, { "name": "ServiceID", "type": "esriFieldTypeString", "alias": "ServiceID", "length": 250, "domain": null }, { "name": "Service", "type": "esriFieldTypeString", "alias": "Service", "length": 50, "domain": null }, { "name": "IsMeter", "type": "esriFieldTypeSmallInteger", "alias": "IsMeter", "domain": null }, { "name": "MeterID", "type": "esriFieldTypeString", "alias": "MeterID", "length": 250, "domain": null }, { "name": "MeterNo", "type": "esriFieldTypeString", "alias": "MeterNo", "length": 50, "domain": null }, { "name": "IsGISAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsGISAsset", "domain": null }, { "name": "GISFileID", "type": "esriFieldTypeInteger", "alias": "GISFileID", "domain": null }, { "name": "GISLayer", "type": "esriFieldTypeString", "alias": "GISLayer", "length": 50, "domain": null }, { "name": "IsAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsAsset", "domain": null }, { "name": "SchemaDocGuid", "type": "esriFieldTypeGUID", "alias": "SchemaDocGuid", "length": 38, "domain": null }, { "name": "UtilityBillingServiceCodeTypeID", "type": "esriFieldTypeInteger", "alias": "UtilityBillingServiceCodeTypeID", "domain": null }, { "name": "IsUtilityBillingServiceOrder", "type": "esriFieldTypeSmallInteger", "alias": "IsUtilityBillingServiceOrder", "domain": null }, { "name": "FeePosted", "type": "esriFieldTypeSmallInteger", "alias": "FeePosted", "domain": null }, { "name": "PriorityColor", "type": "esriFieldTypeString", "alias": "PriorityColor", "length": 50, "domain": null }, { "name": "FeeAmount", "type": "esriFieldTypeDouble", "alias": "FeeAmount", "domain": null }, { "name": "BillToAccount", "type": "esriFieldTypeString", "alias": "BillToAccount", "length": 250, "domain": null }, { "name": "CompletedByFirstName", "type": "esriFieldTypeString", "alias": "CompletedByFirstName", "length": 50, "domain": null }, { "name": "CompletedByLast", "type": "esriFieldTypeString", "alias": "CompletedByLast", "length": 50, "domain": null }, { "name": "LastModifiedByID", "type": "esriFieldTypeInteger", "alias": "LastModifiedByID", "domain": null }, { "name": "LastModified", "type": "esriFieldTypeDate", "alias": "LastModified", "length": 8, "domain": null }, { "name": "PriorityID", "type": "esriFieldTypeInteger", "alias": "PriorityID", "domain": null }, { "name": "StatusID", "type": "esriFieldTypeInteger", "alias": "StatusID", "domain": null }, { "name": "TaskTypeID", "type": "esriFieldTypeInteger", "alias": "TaskTypeID", "domain": null }, { "name": "ServiceOrderDetailTypeID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailTypeID", "domain": null }, { "name": "LOC_Address", "type": "esriFieldTypeString", "alias": "LOC_Address", "length": 500, "domain": null }, { "name": "LOC_City", "type": "esriFieldTypeString", "alias": "LOC_City", "length": 500, "domain": null }, { "name": "CUST_Name", "type": "esriFieldTypeString", "alias": "CUST_Name", "length": 500, "domain": null }, { "name": "GIS_AssetTag", "type": "esriFieldTypeString", "alias": "GIS_AssetTag", "length": 500, "domain": null }, { "name": "AssetNo", "type": "esriFieldTypeInteger", "alias": "AssetNo", "domain": null }, { "name": "ASSET_AssetTag", "type": "esriFieldTypeString", "alias": "ASSET_AssetTag", "length": 500, "domain": null }, { "name": "GeoShape", "type": "esriFieldTypeGeometry", "alias": "GeoShape", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "AssetLocation", "type": "esriFieldTypeString", "alias": "AssetLocation", "length": 1073741822, "domain": null }, { "name": "AssetStatus", "type": "esriFieldTypeString", "alias": "AssetStatus", "length": 50, "domain": null }, { "name": "AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "length": 50, "domain": null }, { "name": "TaskAssignmentCrews", "type": "esriFieldTypeString", "alias": "TaskAssignmentCrews", "length": 1073741822, "domain": null }, { "name": "TaskAssignmentUsers", "type": "esriFieldTypeString", "alias": "TaskAssignmentUsers", "length": 1073741822, "domain": null }, { "name": "TaskAssignmentContacts", "type": "esriFieldTypeString", "alias": "TaskAssignmentContacts", "length": 1073741822, "domain": null }, { "name": "GISAssetNo", "type": "esriFieldTypeString", "alias": "GISAssetNo", "length": 250, "domain": null }, { "name": "DivisionID", "type": "esriFieldTypeInteger", "alias": "DivisionID", "domain": null }, { "name": "Expr1", "type": "esriFieldTypeInteger", "alias": "Expr1", "domain": null }, { "name": "NoteCount", "type": "esriFieldTypeInteger", "alias": "NoteCount", "domain": null }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "length": 250, "domain": null }, { "name": "Problem", "type": "esriFieldTypeString", "alias": "Problem", "length": 1073741822, "domain": null }, { "name": "ResourcesCount", "type": "esriFieldTypeInteger", "alias": "ResourcesCount", "domain": null }, { "name": "ServiceOrderCategory", "type": "esriFieldTypeString", "alias": "ServiceOrderCategory", "length": 50, "domain": null }, { "name": "ServiceOrderDescription", "type": "esriFieldTypeString", "alias": "ServiceOrderDescription", "length": 1073741822, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 150, "domain": null }, { "name": "Resolution", "type": "esriFieldTypeString", "alias": "Resolution", "length": 1073741822, "domain": null }, { "name": "Total_Labor_Hours", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Hours", "domain": null }, { "name": "Total_Labor_Cost", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Cost", "domain": null }, { "name": "Total_Inventory_fCost", "type": "esriFieldTypeDouble", "alias": "Total_Inventory_fCost", "domain": null }, { "name": "InitialResponseByFirstName", "type": "esriFieldTypeString", "alias": "InitialResponseByFirstName", "length": 50, "domain": null }, { "name": "InitialResponseByLastName", "type": "esriFieldTypeString", "alias": "InitialResponseByLastName", "length": 50, "domain": null }, { "name": "WorkCompletedByFirstName", "type": "esriFieldTypeString", "alias": "WorkCompletedByFirstName", "length": 50, "domain": null }, { "name": "WorkCompletedByLastName", "type": "esriFieldTypeString", "alias": "WorkCompletedByLastName", "length": 50, "domain": null }, { "name": "AdminCompletedByFirstName", "type": "esriFieldTypeString", "alias": "AdminCompletedByFirstName", "length": 50, "domain": null }, { "name": "AdminCompletedByLastName", "type": "esriFieldTypeString", "alias": "AdminCompletedByLastName", "length": 50, "domain": null } ], "geometryField": { "name": "GeoShape", "type": "esriFieldTypeGeometry", "alias": "GeoShape" }, "indexes": null, "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, "serviceItemId": "6afd51ca97a04c2fb315218fffc0f4e6" }, { "currentVersion": 10.91, "id": 2, "name": "ElementsXS.DBO.Sign Inspection Complete Query Layer", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "fe7429f7134d48588743f6274c4c9980", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAsAAAAOCAYAAAD5YeaVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAZxJREFUKJGVkjGr2mAUhp9BDOgiWdqKIP6AgDYdXARxcbFTFhE3RRpwzhRTCnJ/gaARhM8tDoLQ66yTU60uwUUHF8Uli9OHKB16lYudeqbzwjO8h+eE+I8JPeWGoihxKaUOHFRV7QdBsHyG44BbKBRKlmWRSqW4Xq9sNpuG4zi/fd/XH7CiKA0pZUkIwfl8ZjabEQ6HKRaLeJ73WdO0BtAPAUgpS4ZhkEgk0DQN3/cBKJfL9Ho98vn8t/l83n90XiwWnM9nhsMhk8mEwWCA53l4ngfQe1/j9Xg86pZl0Ww2abVa2LbNbrdjMBgghFgGQfAXjkajP6WU313XxXVdkskktVqNYrHIy8sLQRBMhRAfQ0A8CAK32+2SzWbJZDLL/X6P4zi64zicTidyudwHIUQ8BBwAfb1eU6/XEULo7Xab7XaLbdvEYjFWqxWqqn66H/jqum4pnU5TqVSoVqtcLhdutxuj0YhOp7MElnf4K/DLNE3dNE0MwyASiTCdTnkz+ONZ95e77vF4rAMHRVGOQP+t6j+/0ZdSPsL7HeAPSFazlG5eWXcAAAAASUVORK5CYII=", "contentType": "image/png", "width": 8, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -85.88385009799998, "ymin": 41.23186492900004, "xmax": -85.82360076899994, "ymax": 41.255786896000075, "spatialReference": { "wkid": 4326, "latestWkid": 4326 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CompletedByFirstName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "TaskID", "type": "esriFieldTypeOID", "alias": "TaskID", "domain": null }, { "name": "ServiceOrderDetailID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailID", "domain": null }, { "name": "CreatedByID", "type": "esriFieldTypeInteger", "alias": "CreatedByID", "domain": null }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "ScheduledStartDate", "type": "esriFieldTypeDate", "alias": "ScheduledStartDate", "length": 8, "domain": null }, { "name": "ScheduledEndDate", "type": "esriFieldTypeDate", "alias": "ScheduledEndDate", "length": 8, "domain": null }, { "name": "ActualStartDate", "type": "esriFieldTypeDate", "alias": "ActualStartDate", "length": 8, "domain": null }, { "name": "ActualEndDate", "type": "esriFieldTypeDate", "alias": "ActualEndDate", "length": 8, "domain": null }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 50, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": null }, { "name": "TaskType", "type": "esriFieldTypeString", "alias": "TaskType", "length": 50, "domain": null }, { "name": "Completed", "type": "esriFieldTypeSmallInteger", "alias": "Completed", "domain": null }, { "name": "IsWorkItemType", "type": "esriFieldTypeSmallInteger", "alias": "IsWorkItemType", "domain": null }, { "name": "ServiceOrderNumber", "type": "esriFieldTypeString", "alias": "ServiceOrderNumber", "length": 50, "domain": null }, { "name": "ServiceOrderID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderID", "domain": null }, { "name": "IsLocation", "type": "esriFieldTypeSmallInteger", "alias": "IsLocation", "domain": null }, { "name": "LocationID", "type": "esriFieldTypeString", "alias": "LocationID", "length": 250, "domain": null }, { "name": "LocationNo", "type": "esriFieldTypeString", "alias": "LocationNo", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "IsCustomer", "type": "esriFieldTypeSmallInteger", "alias": "IsCustomer", "domain": null }, { "name": "CustomerID", "type": "esriFieldTypeString", "alias": "CustomerID", "length": 250, "domain": null }, { "name": "CustomerNo", "type": "esriFieldTypeString", "alias": "CustomerNo", "length": 50, "domain": null }, { "name": "Customer", "type": "esriFieldTypeString", "alias": "Customer", "length": 250, "domain": null }, { "name": "IsService", "type": "esriFieldTypeSmallInteger", "alias": "IsService", "domain": null }, { "name": "ServiceID", "type": "esriFieldTypeString", "alias": "ServiceID", "length": 250, "domain": null }, { "name": "Service", "type": "esriFieldTypeString", "alias": "Service", "length": 50, "domain": null }, { "name": "IsMeter", "type": "esriFieldTypeSmallInteger", "alias": "IsMeter", "domain": null }, { "name": "MeterID", "type": "esriFieldTypeString", "alias": "MeterID", "length": 250, "domain": null }, { "name": "MeterNo", "type": "esriFieldTypeString", "alias": "MeterNo", "length": 50, "domain": null }, { "name": "IsGISAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsGISAsset", "domain": null }, { "name": "GISFileID", "type": "esriFieldTypeInteger", "alias": "GISFileID", "domain": null }, { "name": "GISLayer", "type": "esriFieldTypeString", "alias": "GISLayer", "length": 50, "domain": null }, { "name": "IsAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsAsset", "domain": null }, { "name": "SchemaDocGuid", "type": "esriFieldTypeGUID", "alias": "SchemaDocGuid", "length": 38, "domain": null }, { "name": "UtilityBillingServiceCodeTypeID", "type": "esriFieldTypeInteger", "alias": "UtilityBillingServiceCodeTypeID", "domain": null }, { "name": "IsUtilityBillingServiceOrder", "type": "esriFieldTypeSmallInteger", "alias": "IsUtilityBillingServiceOrder", "domain": null }, { "name": "FeePosted", "type": "esriFieldTypeSmallInteger", "alias": "FeePosted", "domain": null }, { "name": "PriorityColor", "type": "esriFieldTypeString", "alias": "PriorityColor", "length": 50, "domain": null }, { "name": "FeeAmount", "type": "esriFieldTypeDouble", "alias": "FeeAmount", "domain": null }, { "name": "BillToAccount", "type": "esriFieldTypeString", "alias": "BillToAccount", "length": 250, "domain": null }, { "name": "CompletedByFirstName", "type": "esriFieldTypeString", "alias": "CompletedByFirstName", "length": 50, "domain": null }, { "name": "CompletedByLast", "type": "esriFieldTypeString", "alias": "CompletedByLast", "length": 50, "domain": null }, { "name": "LastModifiedByID", "type": "esriFieldTypeInteger", "alias": "LastModifiedByID", "domain": null }, { "name": "LastModified", "type": "esriFieldTypeDate", "alias": "LastModified", "length": 8, "domain": null }, { "name": "PriorityID", "type": "esriFieldTypeInteger", "alias": "PriorityID", "domain": null }, { "name": "StatusID", "type": "esriFieldTypeInteger", "alias": "StatusID", "domain": null }, { "name": "TaskTypeID", "type": "esriFieldTypeInteger", "alias": "TaskTypeID", "domain": null }, { "name": "ServiceOrderDetailTypeID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailTypeID", "domain": null }, { "name": "LOC_Address", "type": "esriFieldTypeString", "alias": "LOC_Address", "length": 500, "domain": null }, { "name": "LOC_City", "type": "esriFieldTypeString", "alias": "LOC_City", "length": 500, "domain": null }, { "name": "CUST_Name", "type": "esriFieldTypeString", "alias": "CUST_Name", "length": 500, "domain": null }, { "name": "GIS_AssetTag", "type": "esriFieldTypeString", "alias": "GIS_AssetTag", "length": 500, "domain": null }, { "name": "AssetNo", "type": "esriFieldTypeInteger", "alias": "AssetNo", "domain": null }, { "name": "ASSET_AssetTag", "type": "esriFieldTypeString", "alias": "ASSET_AssetTag", "length": 500, "domain": null }, { "name": "GeoShape", "type": "esriFieldTypeGeometry", "alias": "GeoShape", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "AssetLocation", "type": "esriFieldTypeString", "alias": "AssetLocation", "length": 1073741822, "domain": null }, { "name": "AssetStatus", "type": "esriFieldTypeString", "alias": "AssetStatus", "length": 50, "domain": null }, { "name": "AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "length": 50, "domain": null }, { "name": "TaskAssignmentCrews", "type": "esriFieldTypeString", "alias": "TaskAssignmentCrews", "length": 1073741822, "domain": null }, { "name": "TaskAssignmentUsers", "type": "esriFieldTypeString", "alias": "TaskAssignmentUsers", "length": 1073741822, "domain": null }, { "name": "TaskAssignmentContacts", "type": "esriFieldTypeString", "alias": "TaskAssignmentContacts", "length": 1073741822, "domain": null }, { "name": "GISAssetNo", "type": "esriFieldTypeString", "alias": "GISAssetNo", "length": 250, "domain": null }, { "name": "DivisionID", "type": "esriFieldTypeInteger", "alias": "DivisionID", "domain": null }, { "name": "Expr1", "type": "esriFieldTypeInteger", "alias": "Expr1", "domain": null }, { "name": "NoteCount", "type": "esriFieldTypeInteger", "alias": "NoteCount", "domain": null }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "length": 250, "domain": null }, { "name": "Problem", "type": "esriFieldTypeString", "alias": "Problem", "length": 1073741822, "domain": null }, { "name": "ResourcesCount", "type": "esriFieldTypeInteger", "alias": "ResourcesCount", "domain": null }, { "name": "ServiceOrderCategory", "type": "esriFieldTypeString", "alias": "ServiceOrderCategory", "length": 50, "domain": null }, { "name": "ServiceOrderDescription", "type": "esriFieldTypeString", "alias": "ServiceOrderDescription", "length": 1073741822, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 150, "domain": null }, { "name": "Resolution", "type": "esriFieldTypeString", "alias": "Resolution", "length": 1073741822, "domain": null }, { "name": "Total_Labor_Hours", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Hours", "domain": null }, { "name": "Total_Labor_Cost", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Cost", "domain": null }, { "name": "Total_Inventory_fCost", "type": "esriFieldTypeDouble", "alias": "Total_Inventory_fCost", "domain": null }, { "name": "InitialResponseByFirstName", "type": "esriFieldTypeString", "alias": "InitialResponseByFirstName", "length": 50, "domain": null }, { "name": "InitialResponseByLastName", "type": "esriFieldTypeString", "alias": "InitialResponseByLastName", "length": 50, "domain": null }, { "name": "WorkCompletedByFirstName", "type": "esriFieldTypeString", "alias": "WorkCompletedByFirstName", "length": 50, "domain": null }, { "name": "WorkCompletedByLastName", "type": "esriFieldTypeString", "alias": "WorkCompletedByLastName", "length": 50, "domain": null }, { "name": "AdminCompletedByFirstName", "type": "esriFieldTypeString", "alias": "AdminCompletedByFirstName", "length": 50, "domain": null }, { "name": "AdminCompletedByLastName", "type": "esriFieldTypeString", "alias": "AdminCompletedByLastName", "length": 50, "domain": null } ], "geometryField": { "name": "GeoShape", "type": "esriFieldTypeGeometry", "alias": "GeoShape" }, "indexes": null, "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, "serviceItemId": "6afd51ca97a04c2fb315218fffc0f4e6" }, { "currentVersion": 10.91, "id": 3, "name": "Sanitary CCTV Completed 2025", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 2244, "latestWkid": 2965 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "ElementsXS.DBO.%view_DD_28.Pipe_Grade", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 52, 52, 52, 255 ], "width": 3 }, "value": "", "label": "", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 235, 214, 255 ], "width": 3 }, "value": "1", "label": "1", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 240, 188, 156, 255 ], "width": 3 }, "value": "2", "label": "2", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 224, 132, 101, 255 ], "width": 3 }, "value": "3", "label": "3", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 209, 71, 52, 255 ], "width": 3 }, "value": "4", "label": "4", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 196, 10, 10, 255 ], "width": 3 }, "value": "5", "label": "5", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -85.91621627624443, "ymin": 41.20552697784264, "xmax": -85.78659362435545, "ymax": 41.29907506989478, "spatialReference": { "wkid": 4326, "latestWkid": 4326 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CollectionSystem.DBO.ssGravityMain.PlaceName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "CollectionSystem.DBO.ssGravityMain.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_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": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "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": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CollectionSystem.DBO.ssGravityMain.MAINSHAPE", "type": "esriFieldTypeString", "alias": "Main Shape", "length": 50, "domain": { "type": "codedValue", "name": "WS2_piPipeShape", "description": "Sanitary and stormwater pipe shapes", "codedValues": [ { "name": "Arched", "code": "A" }, { "name": "Barrel", "code": "B" }, { "name": "Circlular", "code": "C" }, { "name": "Egg Shaped", "code": "E" }, { "name": "Horseshoe", "code": "H" }, { "name": "Oval", "code": "O" }, { "name": "Rectangular", "code": "R" }, { "name": "Square", "code": "S" }, { "name": "Trapezoidal", "code": "T" }, { "name": "U-Shaped", "code": "U" }, { "name": "Other", "code": "Z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.LINEDYEAR", "type": "esriFieldTypeString", "alias": "Year Lined", "length": 4, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LINERTYPE", "type": "esriFieldTypeString", "alias": "Liner Type", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piLiningMethod", "description": "The pipe lining method based on LACP and PACP standards", "codedValues": [ { "name": "Fold and Form or Deform/Reform", "code": "FF" }, { "name": "Segmented Panel", "code": "SN" }, { "name": "Segmented Pipe", "code": "SP" }, { "name": "None", "code": "NONE" }, { "name": "Cured in Place", "code": "C" }, { "name": "Spiral Wound", "code": "H" }, { "name": "Other", "code": "Z" }, { "name": "Lining inserted during manufacture", "code": "A" }, { "name": "Sprayed lining", "code": "B" }, { "name": "Segmented linings", "code": "D" }, { "name": "Lining with descrete pipes", "code": "E" }, { "name": "Lining with continuous pipes", "code": "F" }, { "name": "Close fit lining", "code": "G" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.FROMMH", "type": "esriFieldTypeString", "alias": "From Manhole", "length": 11, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.TOMH", "type": "esriFieldTypeString", "alias": "To Manhole", "length": 11, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CollectionSystem.DBO.ssGravityMain.ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CollectionSystem.DBO.ssGravityMain.OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Stub", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.SLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 26, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.junk", "type": "esriFieldTypeString", "alias": "junk", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.PACP_Use", "type": "esriFieldTypeString", "alias": "PACP_Use", "length": 2, "domain": { "type": "codedValue", "name": "WS2_ssUse", "description": "Sewer Use of Pipe", "codedValues": [ { "name": "Combined", "code": "CB" }, { "name": "Force Main", "code": "FM" }, { "name": "Processes", "code": "PR" }, { "name": "Sanitary", "code": "SS" }, { "name": "Stormwater", "code": "SW" }, { "name": "Other", "code": "ZZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.LOGIX_pipeID", "type": "esriFieldTypeSmallInteger", "alias": "LOGIX_pipeID", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.OLD_UNIQUEID", "type": "esriFieldTypeString", "alias": "OLD_UNIQUEID", "length": 100, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.DUMMY_NOTE", "type": "esriFieldTypeString", "alias": "DUMMY_NOTE", "length": 150, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.PlaceName", "type": "esriFieldTypeString", "alias": "PlaceName", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Location_Code", "type": "esriFieldTypeString", "alias": "Location_Code", "length": 5, "domain": { "type": "codedValue", "name": "WS2_ssLocCode", "description": "Sewer Location Code", "codedValues": [ { "name": "Main Highway - Urban", "code": "A" }, { "name": "Main Highway - Suburnan/Rural", "code": "B" }, { "name": "Light Highway", "code": "C" }, { "name": "Easement / 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": "Metallic Surface", "code": "T" }, { "name": "Yard", "code": "Y" }, { "name": "Other", "code": "Z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.ActivityID", "type": "esriFieldTypeString", "alias": "ActivityID", "length": 20, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LastActivity", "type": "esriFieldTypeString", "alias": "LastActivity", "length": 4, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.DateStamp", "type": "esriFieldTypeDate", "alias": "DateStamp", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.OpTime", "type": "esriFieldTypeString", "alias": "OpTime", "length": 5, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.OeratedBy", "type": "esriFieldTypeString", "alias": "OeratedBy", "length": 30, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.ComputerName", "type": "esriFieldTypeString", "alias": "ComputerName", "length": 30, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Mileage", "type": "esriFieldTypeDouble", "alias": "Mileage", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "length": 200, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Size_1899", "type": "esriFieldTypeSmallInteger", "alias": "Size_1899", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.exist", "type": "esriFieldTypeString", "alias": "exist", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.SRF_PACKAGE", "type": "esriFieldTypeString", "alias": "SRF_PACKAGE", "length": 150, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.RehabID", "type": "esriFieldTypeString", "alias": "RehabID", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.City", "type": "esriFieldTypeString", "alias": "City", "length": 64, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Material_Itpipes", "type": "esriFieldTypeString", "alias": "Material_Itpipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeMaterial_NEW", "description": "Pipe domain to work with IT Pipe Fields", "codedValues": [ { "name": "Acrylonitrile Butadiene Styrene", "code": "Acrylonitrile Butadiene Styrene" }, { "name": "Asbestos Cement", "code": "Asbestos Cement" }, { "name": "Brick", "code": "Brick" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Clay-lined Concrete Pipe", "code": "Clay-lined Concrete Pipe" }, { "name": "Corrugated Metal Pipe", "code": "Corrugated Metal Pipe" }, { "name": "Concrete Pipe (non-reinforced)", "code": "Concrete Pipe (non-reinforced)" }, { "name": "Concrete Segments (bolted)", "code": "Concrete Segments (bolted)" }, { "name": "Concrete Segments (unbolted)", "code": "Concrete Segments (unbolted)" }, { "name": "Clay Tile (not vitrified clay)", "code": "Clay Tile (not vitrified clay)" }, { "name": "Ductile Iron Pipe", "code": "Ductile Iron Pipe" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Pitch Fiber (Orangeburg)", "code": "Pitch Fiber (Orangeburg)" }, { "name": "Polymer Concrete Pipe", "code": "Polymer Concrete Pipe" }, { "name": "Pre-stressed Concrete Cylinder Pipe", "code": "Pre-stressed Concrete Cylinder Pipe" }, { "name": "Polyethylene", "code": "Polyethylene" }, { "name": "Polypropylene", "code": "Polypropylene" }, { "name": "Plastic/Steel Composite", "code": "Plastic/Steel Composite" }, { "name": "Polyvinyl Chloride", "code": "Polyvinyl Chloride" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Reinforced Plastic Pipe (Truss Pipe)", "code": "Reinforced Plastic Pipe (Truss Pipe)" }, { "name": "Segmented Block", "code": "Segmented Block" }, { "name": "Steel Pipe", "code": "Steel Pipe" }, { "name": "Vitrified Clay Pipe", "code": "Vitrified Clay Pipe" }, { "name": "Wood", "code": "Wood" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.WaterTypeITPipes", "type": "esriFieldTypeString", "alias": "WaterTypeITPipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeuse", "description": "DESCRIPT", "codedValues": [ { "name": "Combined Pipe", "code": "Combined Pipe" }, { "name": "Dam Pipe", "code": "Dam Pipe" }, { "name": "Force Main", "code": "Force Main" }, { "name": "Levee Gravity Pipe", "code": "Levee Gravity Pipe" }, { "name": "Levee Pressure Pipe", "code": "Levee Pressure Pipe" }, { "name": "Process Pipe", "code": "Process Pipe" }, { "name": "Sanitary Sewage Pipe", "code": "Sanitary Sewage Pipe" }, { "name": "Stormwater Pipe", "code": "Stormwater Pipe" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.Shape_ITPipes", "type": "esriFieldTypeString", "alias": "Shape_ITPipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeshape", "description": "DESCRIPT", "codedValues": [ { "name": "Arched (with flat bottom)", "code": "Arched (with flat bottom)" }, { "name": "Barrel (e.g. beer barrel shape)", "code": "Barrel (e.g. beer barrel shape)" }, { "name": "Circular", "code": "Circular" }, { "name": "Egg-Shaped", "code": "Egg-Shaped" }, { "name": "Horseshoe (i.e. inverted U with curved sidewalls)", "code": "Horseshoe (i.e. inverted U with curved sidewalls)" }, { "name": "Oval (Elliptical)", "code": "Oval (Elliptical)" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Square", "code": "Square" }, { "name": "Trapezoidal", "code": "Trapezoidal" }, { "name": "U-Shaped with Flat Top (straight walls)", "code": "U-Shaped with Flat Top (straight walls)" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.pipeLiningITPipes", "type": "esriFieldTypeString", "alias": "pipeLiningITPipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeliningmethod", "description": "DESCRIPT", "codedValues": [ { "name": "Cured-In-Place Pipe", "code": "Cured-In-Place Pipe" }, { "name": "Fold and Form or Deform/Reform", "code": "Fold and Form or Deform/Reform" }, { "name": "Formed-In-Place Liner", "code": "Formed-In-Place Liner" }, { "name": "Grout-In-Place Liner", "code": "Grout-In-Place Liner" }, { "name": "Glass Reinforced Cement", "code": "Glass Reinforced Cement" }, { "name": "None", "code": "None" }, { "name": "Continuous Slip Liner", "code": "Continuous Slip Liner" }, { "name": "Sectional Slip Liner", "code": "Sectional Slip Liner" }, { "name": "Spray Liner", "code": "Spray Liner" }, { "name": "Segmented Panel", "code": "Segmented Panel" }, { "name": "Segmented Pipe", "code": "Segmented Pipe" }, { "name": "Spiral Wound", "code": "Spiral Wound" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.TaskID", "type": "esriFieldTypeInteger", "alias": "TaskID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ServiceOrderDetailID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.CreatedByID", "type": "esriFieldTypeInteger", "alias": "CreatedByID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ScheduledStartDate", "type": "esriFieldTypeDate", "alias": "ScheduledStartDate", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ScheduledEndDate", "type": "esriFieldTypeDate", "alias": "ScheduledEndDate", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ActualStartDate", "type": "esriFieldTypeDate", "alias": "ActualStartDate", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ActualEndDate", "type": "esriFieldTypeDate", "alias": "ActualEndDate", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.TaskType", "type": "esriFieldTypeString", "alias": "TaskType", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Completed", "type": "esriFieldTypeSmallInteger", "alias": "Completed", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.IsWorkItemType", "type": "esriFieldTypeSmallInteger", "alias": "IsWorkItemType", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ServiceOrderNumber", "type": "esriFieldTypeString", "alias": "ServiceOrderNumber", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ServiceOrderID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.IsLocation", "type": "esriFieldTypeSmallInteger", "alias": "IsLocation", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.LocationID", "type": "esriFieldTypeString", "alias": "LocationID", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.LocationNo", "type": "esriFieldTypeString", "alias": "LocationNo", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.IsCustomer", "type": "esriFieldTypeSmallInteger", "alias": "IsCustomer", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.CustomerID", "type": "esriFieldTypeString", "alias": "CustomerID", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.CustomerNo", "type": "esriFieldTypeString", "alias": "CustomerNo", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Customer", "type": "esriFieldTypeString", "alias": "Customer", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.IsService", "type": "esriFieldTypeSmallInteger", "alias": "IsService", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ServiceID", "type": "esriFieldTypeString", "alias": "ServiceID", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Service", "type": "esriFieldTypeString", "alias": "Service", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.IsMeter", "type": "esriFieldTypeSmallInteger", "alias": "IsMeter", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.MeterID", "type": "esriFieldTypeString", "alias": "MeterID", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.MeterNo", "type": "esriFieldTypeString", "alias": "MeterNo", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.IsGISAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsGISAsset", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.GISFileID", "type": "esriFieldTypeInteger", "alias": "GISFileID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.GISLayer", "type": "esriFieldTypeString", "alias": "GISLayer", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.IsAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsAsset", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.SchemaDocGuid", "type": "esriFieldTypeGUID", "alias": "SchemaDocGuid", "length": 38, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.UtilityBillingServiceCodeTypeID", "type": "esriFieldTypeInteger", "alias": "UtilityBillingServiceCodeTypeID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.IsUtilityBillingServiceOrder", "type": "esriFieldTypeSmallInteger", "alias": "IsUtilityBillingServiceOrder", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.FeePosted", "type": "esriFieldTypeSmallInteger", "alias": "FeePosted", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.PriorityColor", "type": "esriFieldTypeString", "alias": "PriorityColor", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.FeeAmount", "type": "esriFieldTypeDouble", "alias": "FeeAmount", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.BillToAccount", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary cctv 2025.BillToAccount", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.CompletedByFirstName", "type": "esriFieldTypeString", "alias": "CompletedByFirstName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.CompletedByLast", "type": "esriFieldTypeString", "alias": "CompletedByLast", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.LastModifiedByID", "type": "esriFieldTypeInteger", "alias": "LastModifiedByID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.LastModified", "type": "esriFieldTypeDate", "alias": "LastModified", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.PriorityID", "type": "esriFieldTypeInteger", "alias": "PriorityID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.StatusID", "type": "esriFieldTypeInteger", "alias": "StatusID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.TaskTypeID", "type": "esriFieldTypeInteger", "alias": "TaskTypeID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ServiceOrderDetailTypeID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailTypeID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.LOC_Address", "type": "esriFieldTypeString", "alias": "LOC_Address", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.LOC_City", "type": "esriFieldTypeString", "alias": "LOC_City", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.CUST_Name", "type": "esriFieldTypeString", "alias": "CUST_Name", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.GIS_AssetTag", "type": "esriFieldTypeString", "alias": "GIS_AssetTag", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.AssetNo", "type": "esriFieldTypeInteger", "alias": "AssetNo", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ASSET_AssetTag", "type": "esriFieldTypeString", "alias": "ASSET_AssetTag", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.AssetLocation", "type": "esriFieldTypeString", "alias": "AssetLocation", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.AssetStatus", "type": "esriFieldTypeString", "alias": "AssetStatus", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.TaskAssignmentCrews", "type": "esriFieldTypeString", "alias": "TaskAssignmentCrews", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.TaskAssignmentUsers", "type": "esriFieldTypeString", "alias": "TaskAssignmentUsers", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.TaskAssignmentContacts", "type": "esriFieldTypeString", "alias": "TaskAssignmentContacts", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.GISAssetNo", "type": "esriFieldTypeString", "alias": "GISAssetNo", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.DivisionID", "type": "esriFieldTypeInteger", "alias": "DivisionID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Expr1", "type": "esriFieldTypeInteger", "alias": "Expr1", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.NoteCount", "type": "esriFieldTypeInteger", "alias": "NoteCount", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Division", "type": "esriFieldTypeString", "alias": "Division", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Problem", "type": "esriFieldTypeString", "alias": "Problem", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ResourcesCount", "type": "esriFieldTypeInteger", "alias": "ResourcesCount", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ServiceOrderCategory", "type": "esriFieldTypeString", "alias": "ServiceOrderCategory", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.ServiceOrderDescription", "type": "esriFieldTypeString", "alias": "ServiceOrderDescription", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Type", "type": "esriFieldTypeString", "alias": "Type", "length": 150, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Resolution", "type": "esriFieldTypeString", "alias": "Resolution", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Total_Labor_Hours", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Hours", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Total_Labor_Cost", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Cost", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.Total_Inventory_fCost", "type": "esriFieldTypeDouble", "alias": "Total_Inventory_fCost", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.InitialResponseByFirstName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary cctv 2025.InitialResponseByFirstName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.InitialResponseByLastName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary cctv 2025.InitialResponseByLastName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.WorkCompletedByFirstName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary cctv 2025.WorkCompletedByFirstName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.WorkCompletedByLastName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary cctv 2025.WorkCompletedByLastName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.AdminCompletedByFirstName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary cctv 2025.AdminCompletedByFirstName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary cctv 2025.AdminCompletedByLastName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary cctv 2025.AdminCompletedByLastName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%view_DD_28.Id", "type": "esriFieldTypeInteger", "alias": "Id", "domain": null }, { "name": "ElementsXS.DBO.%view_DD_28.EntryGuid", "type": "esriFieldTypeGUID", "alias": "EntryGuid", "length": 38, "domain": null }, { "name": "ElementsXS.DBO.%view_DD_28.Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null }, { "name": "ElementsXS.DBO.%view_DD_28.Duration", "type": "esriFieldTypeDouble", "alias": "Duration", "domain": null }, { "name": "ElementsXS.DBO.%view_DD_28.lbsPressure", "type": "esriFieldTypeDouble", "alias": "lbsPressure", "domain": null }, { "name": "ElementsXS.DBO.%view_DD_28.Length", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "ElementsXS.DBO.%view_DD_28.Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%view_DD_28.ProjectName", "type": "esriFieldTypeString", "alias": "ProjectName", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%view_DD_28.SystemType", "type": "esriFieldTypeString", "alias": "SystemType", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%view_DD_28.Type", "type": "esriFieldTypeString", "alias": "Type", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%view_DD_28.Pipe_Grade", "type": "esriFieldTypeDouble", "alias": "Pipe_Grade", "domain": null } ], "geometryField": { "name": "CollectionSystem.DBO.ssGravityMain.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R48_pk", "fields": "CollectionSystem.DBO.ssGravityMain.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_48", "fields": "CollectionSystem.DBO.ssGravityMain.GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_48", "fields": "CollectionSystem.DBO.ssGravityMain.GlobalID,CollectionSystem.DBO.ssGravityMain.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S43_idx", "fields": "CollectionSystem.DBO.ssGravityMain.SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": false, "supportsAdvancedQueries": false, "hasM": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsHavingClause": false, "supportsCountDistinct": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsPagination": false, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true, "serviceItemId": "6afd51ca97a04c2fb315218fffc0f4e6" }, { "currentVersion": 10.91, "id": 4, "name": "ElementsXS.DBO.Sanitary cctv 2025", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 153, 128, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -85.86779022199994, "ymin": 41.233242035000046, "xmax": -85.85423278799999, "ymax": 41.26381683300008, "spatialReference": { "wkid": 4326, "latestWkid": 4326 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CompletedByFirstName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "TaskID", "type": "esriFieldTypeOID", "alias": "TaskID", "domain": null }, { "name": "ServiceOrderDetailID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailID", "domain": null }, { "name": "CreatedByID", "type": "esriFieldTypeInteger", "alias": "CreatedByID", "domain": null }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "ScheduledStartDate", "type": "esriFieldTypeDate", "alias": "ScheduledStartDate", "length": 8, "domain": null }, { "name": "ScheduledEndDate", "type": "esriFieldTypeDate", "alias": "ScheduledEndDate", "length": 8, "domain": null }, { "name": "ActualStartDate", "type": "esriFieldTypeDate", "alias": "ActualStartDate", "length": 8, "domain": null }, { "name": "ActualEndDate", "type": "esriFieldTypeDate", "alias": "ActualEndDate", "length": 8, "domain": null }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 50, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": null }, { "name": "TaskType", "type": "esriFieldTypeString", "alias": "TaskType", "length": 50, "domain": null }, { "name": "Completed", "type": "esriFieldTypeSmallInteger", "alias": "Completed", "domain": null }, { "name": "IsWorkItemType", "type": "esriFieldTypeSmallInteger", "alias": "IsWorkItemType", "domain": null }, { "name": "ServiceOrderNumber", "type": "esriFieldTypeString", "alias": "ServiceOrderNumber", "length": 50, "domain": null }, { "name": "ServiceOrderID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderID", "domain": null }, { "name": "IsLocation", "type": "esriFieldTypeSmallInteger", "alias": "IsLocation", "domain": null }, { "name": "LocationID", "type": "esriFieldTypeString", "alias": "LocationID", "length": 250, "domain": null }, { "name": "LocationNo", "type": "esriFieldTypeString", "alias": "LocationNo", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "IsCustomer", "type": "esriFieldTypeSmallInteger", "alias": "IsCustomer", "domain": null }, { "name": "CustomerID", "type": "esriFieldTypeString", "alias": "CustomerID", "length": 250, "domain": null }, { "name": "CustomerNo", "type": "esriFieldTypeString", "alias": "CustomerNo", "length": 50, "domain": null }, { "name": "Customer", "type": "esriFieldTypeString", "alias": "Customer", "length": 250, "domain": null }, { "name": "IsService", "type": "esriFieldTypeSmallInteger", "alias": "IsService", "domain": null }, { "name": "ServiceID", "type": "esriFieldTypeString", "alias": "ServiceID", "length": 250, "domain": null }, { "name": "Service", "type": "esriFieldTypeString", "alias": "Service", "length": 50, "domain": null }, { "name": "IsMeter", "type": "esriFieldTypeSmallInteger", "alias": "IsMeter", "domain": null }, { "name": "MeterID", "type": "esriFieldTypeString", "alias": "MeterID", "length": 250, "domain": null }, { "name": "MeterNo", "type": "esriFieldTypeString", "alias": "MeterNo", "length": 50, "domain": null }, { "name": "IsGISAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsGISAsset", "domain": null }, { "name": "GISFileID", "type": "esriFieldTypeInteger", "alias": "GISFileID", "domain": null }, { "name": "GISLayer", "type": "esriFieldTypeString", "alias": "GISLayer", "length": 50, "domain": null }, { "name": "IsAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsAsset", "domain": null }, { "name": "SchemaDocGuid", "type": "esriFieldTypeGUID", "alias": "SchemaDocGuid", "length": 38, "domain": null }, { "name": "UtilityBillingServiceCodeTypeID", "type": "esriFieldTypeInteger", "alias": "UtilityBillingServiceCodeTypeID", "domain": null }, { "name": "IsUtilityBillingServiceOrder", "type": "esriFieldTypeSmallInteger", "alias": "IsUtilityBillingServiceOrder", "domain": null }, { "name": "FeePosted", "type": "esriFieldTypeSmallInteger", "alias": "FeePosted", "domain": null }, { "name": "PriorityColor", "type": "esriFieldTypeString", "alias": "PriorityColor", "length": 50, "domain": null }, { "name": "FeeAmount", "type": "esriFieldTypeDouble", "alias": "FeeAmount", "domain": null }, { "name": "BillToAccount", "type": "esriFieldTypeString", "alias": "BillToAccount", "length": 250, "domain": null }, { "name": "CompletedByFirstName", "type": "esriFieldTypeString", "alias": "CompletedByFirstName", "length": 50, "domain": null }, { "name": "CompletedByLast", "type": "esriFieldTypeString", "alias": "CompletedByLast", "length": 50, "domain": null }, { "name": "LastModifiedByID", "type": "esriFieldTypeInteger", "alias": "LastModifiedByID", "domain": null }, { "name": "LastModified", "type": "esriFieldTypeDate", "alias": "LastModified", "length": 8, "domain": null }, { "name": "PriorityID", "type": "esriFieldTypeInteger", "alias": "PriorityID", "domain": null }, { "name": "StatusID", "type": "esriFieldTypeInteger", "alias": "StatusID", "domain": null }, { "name": "TaskTypeID", "type": "esriFieldTypeInteger", "alias": "TaskTypeID", "domain": null }, { "name": "ServiceOrderDetailTypeID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailTypeID", "domain": null }, { "name": "LOC_Address", "type": "esriFieldTypeString", "alias": "LOC_Address", "length": 500, "domain": null }, { "name": "LOC_City", "type": "esriFieldTypeString", "alias": "LOC_City", "length": 500, "domain": null }, { "name": "CUST_Name", "type": "esriFieldTypeString", "alias": "CUST_Name", "length": 500, "domain": null }, { "name": "GIS_AssetTag", "type": "esriFieldTypeString", "alias": "GIS_AssetTag", "length": 500, "domain": null }, { "name": "AssetNo", "type": "esriFieldTypeInteger", "alias": "AssetNo", "domain": null }, { "name": "ASSET_AssetTag", "type": "esriFieldTypeString", "alias": "ASSET_AssetTag", "length": 500, "domain": null }, { "name": "GeoShape", "type": "esriFieldTypeGeometry", "alias": "GeoShape", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "AssetLocation", "type": "esriFieldTypeString", "alias": "AssetLocation", "length": 1073741822, "domain": null }, { "name": "AssetStatus", "type": "esriFieldTypeString", "alias": "AssetStatus", "length": 50, "domain": null }, { "name": "AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "length": 50, "domain": null }, { "name": "TaskAssignmentCrews", "type": "esriFieldTypeString", "alias": "TaskAssignmentCrews", "length": 1073741822, "domain": null }, { "name": "TaskAssignmentUsers", "type": "esriFieldTypeString", "alias": "TaskAssignmentUsers", "length": 1073741822, "domain": null }, { "name": "TaskAssignmentContacts", "type": "esriFieldTypeString", "alias": "TaskAssignmentContacts", "length": 1073741822, "domain": null }, { "name": "GISAssetNo", "type": "esriFieldTypeString", "alias": "GISAssetNo", "length": 250, "domain": null }, { "name": "DivisionID", "type": "esriFieldTypeInteger", "alias": "DivisionID", "domain": null }, { "name": "Expr1", "type": "esriFieldTypeInteger", "alias": "Expr1", "domain": null }, { "name": "NoteCount", "type": "esriFieldTypeInteger", "alias": "NoteCount", "domain": null }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "length": 250, "domain": null }, { "name": "Problem", "type": "esriFieldTypeString", "alias": "Problem", "length": 1073741822, "domain": null }, { "name": "ResourcesCount", "type": "esriFieldTypeInteger", "alias": "ResourcesCount", "domain": null }, { "name": "ServiceOrderCategory", "type": "esriFieldTypeString", "alias": "ServiceOrderCategory", "length": 50, "domain": null }, { "name": "ServiceOrderDescription", "type": "esriFieldTypeString", "alias": "ServiceOrderDescription", "length": 1073741822, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 150, "domain": null }, { "name": "Resolution", "type": "esriFieldTypeString", "alias": "Resolution", "length": 1073741822, "domain": null }, { "name": "Total_Labor_Hours", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Hours", "domain": null }, { "name": "Total_Labor_Cost", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Cost", "domain": null }, { "name": "Total_Inventory_fCost", "type": "esriFieldTypeDouble", "alias": "Total_Inventory_fCost", "domain": null }, { "name": "InitialResponseByFirstName", "type": "esriFieldTypeString", "alias": "InitialResponseByFirstName", "length": 50, "domain": null }, { "name": "InitialResponseByLastName", "type": "esriFieldTypeString", "alias": "InitialResponseByLastName", "length": 50, "domain": null }, { "name": "WorkCompletedByFirstName", "type": "esriFieldTypeString", "alias": "WorkCompletedByFirstName", "length": 50, "domain": null }, { "name": "WorkCompletedByLastName", "type": "esriFieldTypeString", "alias": "WorkCompletedByLastName", "length": 50, "domain": null }, { "name": "AdminCompletedByFirstName", "type": "esriFieldTypeString", "alias": "AdminCompletedByFirstName", "length": 50, "domain": null }, { "name": "AdminCompletedByLastName", "type": "esriFieldTypeString", "alias": "AdminCompletedByLastName", "length": 50, "domain": null } ], "geometryField": { "name": "GeoShape", "type": "esriFieldTypeGeometry", "alias": "GeoShape" }, "indexes": null, "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, "serviceItemId": "6afd51ca97a04c2fb315218fffc0f4e6" }, { "currentVersion": 10.91, "id": 5, "name": "Sanitary JETTING Completed 2025", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 2244, "latestWkid": 2965 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 255, 0, 255 ], "width": 3 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -85.91621627624443, "ymin": 41.20552697784264, "xmax": -85.78659362435545, "ymax": 41.29907506989478, "spatialReference": { "wkid": 4326, "latestWkid": 4326 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CollectionSystem.DBO.ssGravityMain.PlaceName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "CollectionSystem.DBO.ssGravityMain.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_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": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "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": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CollectionSystem.DBO.ssGravityMain.MAINSHAPE", "type": "esriFieldTypeString", "alias": "Main Shape", "length": 50, "domain": { "type": "codedValue", "name": "WS2_piPipeShape", "description": "Sanitary and stormwater pipe shapes", "codedValues": [ { "name": "Arched", "code": "A" }, { "name": "Barrel", "code": "B" }, { "name": "Circlular", "code": "C" }, { "name": "Egg Shaped", "code": "E" }, { "name": "Horseshoe", "code": "H" }, { "name": "Oval", "code": "O" }, { "name": "Rectangular", "code": "R" }, { "name": "Square", "code": "S" }, { "name": "Trapezoidal", "code": "T" }, { "name": "U-Shaped", "code": "U" }, { "name": "Other", "code": "Z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.LINEDYEAR", "type": "esriFieldTypeString", "alias": "Year Lined", "length": 4, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LINERTYPE", "type": "esriFieldTypeString", "alias": "Liner Type", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piLiningMethod", "description": "The pipe lining method based on LACP and PACP standards", "codedValues": [ { "name": "Fold and Form or Deform/Reform", "code": "FF" }, { "name": "Segmented Panel", "code": "SN" }, { "name": "Segmented Pipe", "code": "SP" }, { "name": "None", "code": "NONE" }, { "name": "Cured in Place", "code": "C" }, { "name": "Spiral Wound", "code": "H" }, { "name": "Other", "code": "Z" }, { "name": "Lining inserted during manufacture", "code": "A" }, { "name": "Sprayed lining", "code": "B" }, { "name": "Segmented linings", "code": "D" }, { "name": "Lining with descrete pipes", "code": "E" }, { "name": "Lining with continuous pipes", "code": "F" }, { "name": "Close fit lining", "code": "G" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.FROMMH", "type": "esriFieldTypeString", "alias": "From Manhole", "length": 11, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.TOMH", "type": "esriFieldTypeString", "alias": "To Manhole", "length": 11, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CollectionSystem.DBO.ssGravityMain.ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CollectionSystem.DBO.ssGravityMain.OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Stub", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.SLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 26, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.junk", "type": "esriFieldTypeString", "alias": "junk", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.PACP_Use", "type": "esriFieldTypeString", "alias": "PACP_Use", "length": 2, "domain": { "type": "codedValue", "name": "WS2_ssUse", "description": "Sewer Use of Pipe", "codedValues": [ { "name": "Combined", "code": "CB" }, { "name": "Force Main", "code": "FM" }, { "name": "Processes", "code": "PR" }, { "name": "Sanitary", "code": "SS" }, { "name": "Stormwater", "code": "SW" }, { "name": "Other", "code": "ZZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.LOGIX_pipeID", "type": "esriFieldTypeSmallInteger", "alias": "LOGIX_pipeID", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.OLD_UNIQUEID", "type": "esriFieldTypeString", "alias": "OLD_UNIQUEID", "length": 100, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.DUMMY_NOTE", "type": "esriFieldTypeString", "alias": "DUMMY_NOTE", "length": 150, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.PlaceName", "type": "esriFieldTypeString", "alias": "PlaceName", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Location_Code", "type": "esriFieldTypeString", "alias": "Location_Code", "length": 5, "domain": { "type": "codedValue", "name": "WS2_ssLocCode", "description": "Sewer Location Code", "codedValues": [ { "name": "Main Highway - Urban", "code": "A" }, { "name": "Main Highway - Suburnan/Rural", "code": "B" }, { "name": "Light Highway", "code": "C" }, { "name": "Easement / 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": "Metallic Surface", "code": "T" }, { "name": "Yard", "code": "Y" }, { "name": "Other", "code": "Z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.ActivityID", "type": "esriFieldTypeString", "alias": "ActivityID", "length": 20, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.LastActivity", "type": "esriFieldTypeString", "alias": "LastActivity", "length": 4, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.DateStamp", "type": "esriFieldTypeDate", "alias": "DateStamp", "length": 8, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.OpTime", "type": "esriFieldTypeString", "alias": "OpTime", "length": 5, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.OeratedBy", "type": "esriFieldTypeString", "alias": "OeratedBy", "length": 30, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.ComputerName", "type": "esriFieldTypeString", "alias": "ComputerName", "length": 30, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Mileage", "type": "esriFieldTypeDouble", "alias": "Mileage", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "length": 200, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Size_1899", "type": "esriFieldTypeSmallInteger", "alias": "Size_1899", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.exist", "type": "esriFieldTypeString", "alias": "exist", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.SRF_PACKAGE", "type": "esriFieldTypeString", "alias": "SRF_PACKAGE", "length": 150, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.RehabID", "type": "esriFieldTypeString", "alias": "RehabID", "length": 50, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.City", "type": "esriFieldTypeString", "alias": "City", "length": 64, "domain": null }, { "name": "CollectionSystem.DBO.ssGravityMain.Material_Itpipes", "type": "esriFieldTypeString", "alias": "Material_Itpipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeMaterial_NEW", "description": "Pipe domain to work with IT Pipe Fields", "codedValues": [ { "name": "Acrylonitrile Butadiene Styrene", "code": "Acrylonitrile Butadiene Styrene" }, { "name": "Asbestos Cement", "code": "Asbestos Cement" }, { "name": "Brick", "code": "Brick" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Clay-lined Concrete Pipe", "code": "Clay-lined Concrete Pipe" }, { "name": "Corrugated Metal Pipe", "code": "Corrugated Metal Pipe" }, { "name": "Concrete Pipe (non-reinforced)", "code": "Concrete Pipe (non-reinforced)" }, { "name": "Concrete Segments (bolted)", "code": "Concrete Segments (bolted)" }, { "name": "Concrete Segments (unbolted)", "code": "Concrete Segments (unbolted)" }, { "name": "Clay Tile (not vitrified clay)", "code": "Clay Tile (not vitrified clay)" }, { "name": "Ductile Iron Pipe", "code": "Ductile Iron Pipe" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Pitch Fiber (Orangeburg)", "code": "Pitch Fiber (Orangeburg)" }, { "name": "Polymer Concrete Pipe", "code": "Polymer Concrete Pipe" }, { "name": "Pre-stressed Concrete Cylinder Pipe", "code": "Pre-stressed Concrete Cylinder Pipe" }, { "name": "Polyethylene", "code": "Polyethylene" }, { "name": "Polypropylene", "code": "Polypropylene" }, { "name": "Plastic/Steel Composite", "code": "Plastic/Steel Composite" }, { "name": "Polyvinyl Chloride", "code": "Polyvinyl Chloride" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Reinforced Plastic Pipe (Truss Pipe)", "code": "Reinforced Plastic Pipe (Truss Pipe)" }, { "name": "Segmented Block", "code": "Segmented Block" }, { "name": "Steel Pipe", "code": "Steel Pipe" }, { "name": "Vitrified Clay Pipe", "code": "Vitrified Clay Pipe" }, { "name": "Wood", "code": "Wood" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.WaterTypeITPipes", "type": "esriFieldTypeString", "alias": "WaterTypeITPipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeuse", "description": "DESCRIPT", "codedValues": [ { "name": "Combined Pipe", "code": "Combined Pipe" }, { "name": "Dam Pipe", "code": "Dam Pipe" }, { "name": "Force Main", "code": "Force Main" }, { "name": "Levee Gravity Pipe", "code": "Levee Gravity Pipe" }, { "name": "Levee Pressure Pipe", "code": "Levee Pressure Pipe" }, { "name": "Process Pipe", "code": "Process Pipe" }, { "name": "Sanitary Sewage Pipe", "code": "Sanitary Sewage Pipe" }, { "name": "Stormwater Pipe", "code": "Stormwater Pipe" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.Shape_ITPipes", "type": "esriFieldTypeString", "alias": "Shape_ITPipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeshape", "description": "DESCRIPT", "codedValues": [ { "name": "Arched (with flat bottom)", "code": "Arched (with flat bottom)" }, { "name": "Barrel (e.g. beer barrel shape)", "code": "Barrel (e.g. beer barrel shape)" }, { "name": "Circular", "code": "Circular" }, { "name": "Egg-Shaped", "code": "Egg-Shaped" }, { "name": "Horseshoe (i.e. inverted U with curved sidewalls)", "code": "Horseshoe (i.e. inverted U with curved sidewalls)" }, { "name": "Oval (Elliptical)", "code": "Oval (Elliptical)" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Square", "code": "Square" }, { "name": "Trapezoidal", "code": "Trapezoidal" }, { "name": "U-Shaped with Flat Top (straight walls)", "code": "U-Shaped with Flat Top (straight walls)" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CollectionSystem.DBO.ssGravityMain.pipeLiningITPipes", "type": "esriFieldTypeString", "alias": "pipeLiningITPipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeliningmethod", "description": "DESCRIPT", "codedValues": [ { "name": "Cured-In-Place Pipe", "code": "Cured-In-Place Pipe" }, { "name": "Fold and Form or Deform/Reform", "code": "Fold and Form or Deform/Reform" }, { "name": "Formed-In-Place Liner", "code": "Formed-In-Place Liner" }, { "name": "Grout-In-Place Liner", "code": "Grout-In-Place Liner" }, { "name": "Glass Reinforced Cement", "code": "Glass Reinforced Cement" }, { "name": "None", "code": "None" }, { "name": "Continuous Slip Liner", "code": "Continuous Slip Liner" }, { "name": "Sectional Slip Liner", "code": "Sectional Slip Liner" }, { "name": "Spray Liner", "code": "Spray Liner" }, { "name": "Segmented Panel", "code": "Segmented Panel" }, { "name": "Segmented Pipe", "code": "Segmented Pipe" }, { "name": "Spiral Wound", "code": "Spiral Wound" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.TaskID", "type": "esriFieldTypeInteger", "alias": "TaskID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ServiceOrderDetailID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.CreatedByID", "type": "esriFieldTypeInteger", "alias": "CreatedByID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ScheduledStartDate", "type": "esriFieldTypeDate", "alias": "ScheduledStartDate", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ScheduledEndDate", "type": "esriFieldTypeDate", "alias": "ScheduledEndDate", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ActualStartDate", "type": "esriFieldTypeDate", "alias": "ActualStartDate", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ActualEndDate", "type": "esriFieldTypeDate", "alias": "ActualEndDate", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.TaskType", "type": "esriFieldTypeString", "alias": "TaskType", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Completed", "type": "esriFieldTypeSmallInteger", "alias": "Completed", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.IsWorkItemType", "type": "esriFieldTypeSmallInteger", "alias": "IsWorkItemType", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ServiceOrderNumber", "type": "esriFieldTypeString", "alias": "ServiceOrderNumber", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ServiceOrderID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.IsLocation", "type": "esriFieldTypeSmallInteger", "alias": "IsLocation", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.LocationID", "type": "esriFieldTypeString", "alias": "LocationID", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.LocationNo", "type": "esriFieldTypeString", "alias": "LocationNo", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.IsCustomer", "type": "esriFieldTypeSmallInteger", "alias": "IsCustomer", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.CustomerID", "type": "esriFieldTypeString", "alias": "CustomerID", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.CustomerNo", "type": "esriFieldTypeString", "alias": "CustomerNo", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Customer", "type": "esriFieldTypeString", "alias": "Customer", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.IsService", "type": "esriFieldTypeSmallInteger", "alias": "IsService", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ServiceID", "type": "esriFieldTypeString", "alias": "ServiceID", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Service", "type": "esriFieldTypeString", "alias": "Service", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.IsMeter", "type": "esriFieldTypeSmallInteger", "alias": "IsMeter", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.MeterID", "type": "esriFieldTypeString", "alias": "MeterID", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.MeterNo", "type": "esriFieldTypeString", "alias": "MeterNo", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.IsGISAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsGISAsset", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.GISFileID", "type": "esriFieldTypeInteger", "alias": "GISFileID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.GISLayer", "type": "esriFieldTypeString", "alias": "GISLayer", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.IsAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsAsset", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.SchemaDocGuid", "type": "esriFieldTypeGUID", "alias": "SchemaDocGuid", "length": 38, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.UtilityBillingServiceCodeTypeID", "type": "esriFieldTypeInteger", "alias": "UtilityBillingServiceCodeTypeID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.IsUtilityBillingServiceOrder", "type": "esriFieldTypeSmallInteger", "alias": "IsUtilityBillingServiceOrder", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.FeePosted", "type": "esriFieldTypeSmallInteger", "alias": "FeePosted", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.PriorityColor", "type": "esriFieldTypeString", "alias": "PriorityColor", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.FeeAmount", "type": "esriFieldTypeDouble", "alias": "FeeAmount", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.BillToAccount", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary Jetted 2025_2.BillToAccount", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.CompletedByFirstName", "type": "esriFieldTypeString", "alias": "CompletedByFirstName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.CompletedByLast", "type": "esriFieldTypeString", "alias": "CompletedByLast", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.LastModifiedByID", "type": "esriFieldTypeInteger", "alias": "LastModifiedByID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.LastModified", "type": "esriFieldTypeDate", "alias": "LastModified", "length": 8, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.PriorityID", "type": "esriFieldTypeInteger", "alias": "PriorityID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.StatusID", "type": "esriFieldTypeInteger", "alias": "StatusID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.TaskTypeID", "type": "esriFieldTypeInteger", "alias": "TaskTypeID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ServiceOrderDetailTypeID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailTypeID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.LOC_Address", "type": "esriFieldTypeString", "alias": "LOC_Address", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.LOC_City", "type": "esriFieldTypeString", "alias": "LOC_City", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.CUST_Name", "type": "esriFieldTypeString", "alias": "CUST_Name", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.GIS_AssetTag", "type": "esriFieldTypeString", "alias": "GIS_AssetTag", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.AssetNo", "type": "esriFieldTypeInteger", "alias": "AssetNo", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ASSET_AssetTag", "type": "esriFieldTypeString", "alias": "ASSET_AssetTag", "length": 500, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.AssetLocation", "type": "esriFieldTypeString", "alias": "AssetLocation", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.AssetStatus", "type": "esriFieldTypeString", "alias": "AssetStatus", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.TaskAssignmentCrews", "type": "esriFieldTypeString", "alias": "TaskAssignmentCrews", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.TaskAssignmentUsers", "type": "esriFieldTypeString", "alias": "TaskAssignmentUsers", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.TaskAssignmentContacts", "type": "esriFieldTypeString", "alias": "TaskAssignmentContacts", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.GISAssetNo", "type": "esriFieldTypeString", "alias": "GISAssetNo", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.DivisionID", "type": "esriFieldTypeInteger", "alias": "DivisionID", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Expr1", "type": "esriFieldTypeInteger", "alias": "Expr1", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.NoteCount", "type": "esriFieldTypeInteger", "alias": "NoteCount", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Division", "type": "esriFieldTypeString", "alias": "Division", "length": 250, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Problem", "type": "esriFieldTypeString", "alias": "Problem", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ResourcesCount", "type": "esriFieldTypeInteger", "alias": "ResourcesCount", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ServiceOrderCategory", "type": "esriFieldTypeString", "alias": "ServiceOrderCategory", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.ServiceOrderDescription", "type": "esriFieldTypeString", "alias": "ServiceOrderDescription", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Type", "type": "esriFieldTypeString", "alias": "Type", "length": 150, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Resolution", "type": "esriFieldTypeString", "alias": "Resolution", "length": 1073741822, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Total_Labor_Hours", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Hours", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Total_Labor_Cost", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Cost", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.Total_Inventory_fCost", "type": "esriFieldTypeDouble", "alias": "Total_Inventory_fCost", "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.InitialResponseByFirstName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary Jetted 2025_2.InitialResponseByFirstName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.InitialResponseByLastName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary Jetted 2025_2.InitialResponseByLastName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.WorkCompletedByFirstName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary Jetted 2025_2.WorkCompletedByFirstName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.WorkCompletedByLastName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary Jetted 2025_2.WorkCompletedByLastName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.AdminCompletedByFirstName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary Jetted 2025_2.AdminCompletedByFirstName", "length": 50, "domain": null }, { "name": "ElementsXS.DBO.%Sanitary Jetted 2025_2.AdminCompletedByLastName", "type": "esriFieldTypeString", "alias": "ElementsXS.DBO.%Sanitary Jetted 2025_2.AdminCompletedByLastName", "length": 50, "domain": null } ], "geometryField": { "name": "CollectionSystem.DBO.ssGravityMain.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R48_pk", "fields": "CollectionSystem.DBO.ssGravityMain.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_48", "fields": "CollectionSystem.DBO.ssGravityMain.GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_48", "fields": "CollectionSystem.DBO.ssGravityMain.GlobalID,CollectionSystem.DBO.ssGravityMain.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S43_idx", "fields": "CollectionSystem.DBO.ssGravityMain.SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": false, "supportsAdvancedQueries": false, "hasM": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsHavingClause": false, "supportsCountDistinct": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsPagination": false, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true, "serviceItemId": "6afd51ca97a04c2fb315218fffc0f4e6" }, { "currentVersion": 10.91, "id": 6, "name": "ElementsXS.DBO.Sanitary Jetted 2025", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 160, 163, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -85.86779022199994, "ymin": 41.264022827000076, "xmax": -85.86779022199994, "ymax": 41.264022827000076, "spatialReference": { "wkid": 4326, "latestWkid": 4326 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CompletedByFirstName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "TaskID", "type": "esriFieldTypeOID", "alias": "TaskID", "domain": null }, { "name": "ServiceOrderDetailID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailID", "domain": null }, { "name": "CreatedByID", "type": "esriFieldTypeInteger", "alias": "CreatedByID", "domain": null }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "ScheduledStartDate", "type": "esriFieldTypeDate", "alias": "ScheduledStartDate", "length": 8, "domain": null }, { "name": "ScheduledEndDate", "type": "esriFieldTypeDate", "alias": "ScheduledEndDate", "length": 8, "domain": null }, { "name": "ActualStartDate", "type": "esriFieldTypeDate", "alias": "ActualStartDate", "length": 8, "domain": null }, { "name": "ActualEndDate", "type": "esriFieldTypeDate", "alias": "ActualEndDate", "length": 8, "domain": null }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 50, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": null }, { "name": "TaskType", "type": "esriFieldTypeString", "alias": "TaskType", "length": 50, "domain": null }, { "name": "Completed", "type": "esriFieldTypeSmallInteger", "alias": "Completed", "domain": null }, { "name": "IsWorkItemType", "type": "esriFieldTypeSmallInteger", "alias": "IsWorkItemType", "domain": null }, { "name": "ServiceOrderNumber", "type": "esriFieldTypeString", "alias": "ServiceOrderNumber", "length": 50, "domain": null }, { "name": "ServiceOrderID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderID", "domain": null }, { "name": "IsLocation", "type": "esriFieldTypeSmallInteger", "alias": "IsLocation", "domain": null }, { "name": "LocationID", "type": "esriFieldTypeString", "alias": "LocationID", "length": 250, "domain": null }, { "name": "LocationNo", "type": "esriFieldTypeString", "alias": "LocationNo", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "IsCustomer", "type": "esriFieldTypeSmallInteger", "alias": "IsCustomer", "domain": null }, { "name": "CustomerID", "type": "esriFieldTypeString", "alias": "CustomerID", "length": 250, "domain": null }, { "name": "CustomerNo", "type": "esriFieldTypeString", "alias": "CustomerNo", "length": 50, "domain": null }, { "name": "Customer", "type": "esriFieldTypeString", "alias": "Customer", "length": 250, "domain": null }, { "name": "IsService", "type": "esriFieldTypeSmallInteger", "alias": "IsService", "domain": null }, { "name": "ServiceID", "type": "esriFieldTypeString", "alias": "ServiceID", "length": 250, "domain": null }, { "name": "Service", "type": "esriFieldTypeString", "alias": "Service", "length": 50, "domain": null }, { "name": "IsMeter", "type": "esriFieldTypeSmallInteger", "alias": "IsMeter", "domain": null }, { "name": "MeterID", "type": "esriFieldTypeString", "alias": "MeterID", "length": 250, "domain": null }, { "name": "MeterNo", "type": "esriFieldTypeString", "alias": "MeterNo", "length": 50, "domain": null }, { "name": "IsGISAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsGISAsset", "domain": null }, { "name": "GISFileID", "type": "esriFieldTypeInteger", "alias": "GISFileID", "domain": null }, { "name": "GISLayer", "type": "esriFieldTypeString", "alias": "GISLayer", "length": 50, "domain": null }, { "name": "IsAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsAsset", "domain": null }, { "name": "SchemaDocGuid", "type": "esriFieldTypeGUID", "alias": "SchemaDocGuid", "length": 38, "domain": null }, { "name": "UtilityBillingServiceCodeTypeID", "type": "esriFieldTypeInteger", "alias": "UtilityBillingServiceCodeTypeID", "domain": null }, { "name": "IsUtilityBillingServiceOrder", "type": "esriFieldTypeSmallInteger", "alias": "IsUtilityBillingServiceOrder", "domain": null }, { "name": "FeePosted", "type": "esriFieldTypeSmallInteger", "alias": "FeePosted", "domain": null }, { "name": "PriorityColor", "type": "esriFieldTypeString", "alias": "PriorityColor", "length": 50, "domain": null }, { "name": "FeeAmount", "type": "esriFieldTypeDouble", "alias": "FeeAmount", "domain": null }, { "name": "BillToAccount", "type": "esriFieldTypeString", "alias": "BillToAccount", "length": 250, "domain": null }, { "name": "CompletedByFirstName", "type": "esriFieldTypeString", "alias": "CompletedByFirstName", "length": 50, "domain": null }, { "name": "CompletedByLast", "type": "esriFieldTypeString", "alias": "CompletedByLast", "length": 50, "domain": null }, { "name": "LastModifiedByID", "type": "esriFieldTypeInteger", "alias": "LastModifiedByID", "domain": null }, { "name": "LastModified", "type": "esriFieldTypeDate", "alias": "LastModified", "length": 8, "domain": null }, { "name": "PriorityID", "type": "esriFieldTypeInteger", "alias": "PriorityID", "domain": null }, { "name": "StatusID", "type": "esriFieldTypeInteger", "alias": "StatusID", "domain": null }, { "name": "TaskTypeID", "type": "esriFieldTypeInteger", "alias": "TaskTypeID", "domain": null }, { "name": "ServiceOrderDetailTypeID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailTypeID", "domain": null }, { "name": "LOC_Address", "type": "esriFieldTypeString", "alias": "LOC_Address", "length": 500, "domain": null }, { "name": "LOC_City", "type": "esriFieldTypeString", "alias": "LOC_City", "length": 500, "domain": null }, { "name": "CUST_Name", "type": "esriFieldTypeString", "alias": "CUST_Name", "length": 500, "domain": null }, { "name": "GIS_AssetTag", "type": "esriFieldTypeString", "alias": "GIS_AssetTag", "length": 500, "domain": null }, { "name": "AssetNo", "type": "esriFieldTypeInteger", "alias": "AssetNo", "domain": null }, { "name": "ASSET_AssetTag", "type": "esriFieldTypeString", "alias": "ASSET_AssetTag", "length": 500, "domain": null }, { "name": "GeoShape", "type": "esriFieldTypeGeometry", "alias": "GeoShape", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "AssetLocation", "type": "esriFieldTypeString", "alias": "AssetLocation", "length": 1073741822, "domain": null }, { "name": "AssetStatus", "type": "esriFieldTypeString", "alias": "AssetStatus", "length": 50, "domain": null }, { "name": "AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "length": 50, "domain": null }, { "name": "TaskAssignmentCrews", "type": "esriFieldTypeString", "alias": "TaskAssignmentCrews", "length": 1073741822, "domain": null }, { "name": "TaskAssignmentUsers", "type": "esriFieldTypeString", "alias": "TaskAssignmentUsers", "length": 1073741822, "domain": null }, { "name": "TaskAssignmentContacts", "type": "esriFieldTypeString", "alias": "TaskAssignmentContacts", "length": 1073741822, "domain": null }, { "name": "GISAssetNo", "type": "esriFieldTypeString", "alias": "GISAssetNo", "length": 250, "domain": null }, { "name": "DivisionID", "type": "esriFieldTypeInteger", "alias": "DivisionID", "domain": null }, { "name": "Expr1", "type": "esriFieldTypeInteger", "alias": "Expr1", "domain": null }, { "name": "NoteCount", "type": "esriFieldTypeInteger", "alias": "NoteCount", "domain": null }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "length": 250, "domain": null }, { "name": "Problem", "type": "esriFieldTypeString", "alias": "Problem", "length": 1073741822, "domain": null }, { "name": "ResourcesCount", "type": "esriFieldTypeInteger", "alias": "ResourcesCount", "domain": null }, { "name": "ServiceOrderCategory", "type": "esriFieldTypeString", "alias": "ServiceOrderCategory", "length": 50, "domain": null }, { "name": "ServiceOrderDescription", "type": "esriFieldTypeString", "alias": "ServiceOrderDescription", "length": 1073741822, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 150, "domain": null }, { "name": "Resolution", "type": "esriFieldTypeString", "alias": "Resolution", "length": 1073741822, "domain": null }, { "name": "Total_Labor_Hours", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Hours", "domain": null }, { "name": "Total_Labor_Cost", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Cost", "domain": null }, { "name": "Total_Inventory_fCost", "type": "esriFieldTypeDouble", "alias": "Total_Inventory_fCost", "domain": null }, { "name": "InitialResponseByFirstName", "type": "esriFieldTypeString", "alias": "InitialResponseByFirstName", "length": 50, "domain": null }, { "name": "InitialResponseByLastName", "type": "esriFieldTypeString", "alias": "InitialResponseByLastName", "length": 50, "domain": null }, { "name": "WorkCompletedByFirstName", "type": "esriFieldTypeString", "alias": "WorkCompletedByFirstName", "length": 50, "domain": null }, { "name": "WorkCompletedByLastName", "type": "esriFieldTypeString", "alias": "WorkCompletedByLastName", "length": 50, "domain": null }, { "name": "AdminCompletedByFirstName", "type": "esriFieldTypeString", "alias": "AdminCompletedByFirstName", "length": 50, "domain": null }, { "name": "AdminCompletedByLastName", "type": "esriFieldTypeString", "alias": "AdminCompletedByLastName", "length": 50, "domain": null } ], "geometryField": { "name": "GeoShape", "type": "esriFieldTypeGeometry", "alias": "GeoShape" }, "indexes": null, "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, "serviceItemId": "6afd51ca97a04c2fb315218fffc0f4e6" }, { "currentVersion": 10.91, "id": 7, "name": "Sanitary Display", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 2244, "latestWkid": 2965 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 85, 255, 0, 255 ], "width": 2 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -85.91621627624443, "ymin": 41.20552697784264, "xmax": -85.78659362435545, "ymax": 41.29907506989478, "spatialReference": { "wkid": 4326, "latestWkid": 4326 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PlaceName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_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": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "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": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINSHAPE", "type": "esriFieldTypeString", "alias": "Main Shape", "length": 50, "domain": { "type": "codedValue", "name": "WS2_piPipeShape", "description": "Sanitary and stormwater pipe shapes", "codedValues": [ { "name": "Arched", "code": "A" }, { "name": "Barrel", "code": "B" }, { "name": "Circlular", "code": "C" }, { "name": "Egg Shaped", "code": "E" }, { "name": "Horseshoe", "code": "H" }, { "name": "Oval", "code": "O" }, { "name": "Rectangular", "code": "R" }, { "name": "Square", "code": "S" }, { "name": "Trapezoidal", "code": "T" }, { "name": "U-Shaped", "code": "U" }, { "name": "Other", "code": "Z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LINEDYEAR", "type": "esriFieldTypeString", "alias": "Year Lined", "length": 4, "domain": null }, { "name": "LINERTYPE", "type": "esriFieldTypeString", "alias": "Liner Type", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piLiningMethod", "description": "The pipe lining method based on LACP and PACP standards", "codedValues": [ { "name": "Fold and Form or Deform/Reform", "code": "FF" }, { "name": "Segmented Panel", "code": "SN" }, { "name": "Segmented Pipe", "code": "SP" }, { "name": "None", "code": "NONE" }, { "name": "Cured in Place", "code": "C" }, { "name": "Spiral Wound", "code": "H" }, { "name": "Other", "code": "Z" }, { "name": "Lining inserted during manufacture", "code": "A" }, { "name": "Sprayed lining", "code": "B" }, { "name": "Segmented linings", "code": "D" }, { "name": "Lining with descrete pipes", "code": "E" }, { "name": "Lining with continuous pipes", "code": "F" }, { "name": "Close fit lining", "code": "G" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FROMMH", "type": "esriFieldTypeString", "alias": "From Manhole", "length": 11, "domain": null }, { "name": "TOMH", "type": "esriFieldTypeString", "alias": "To Manhole", "length": 11, "domain": null }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 }, { "name": "Stub", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update Date", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null }, { "name": "UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null }, { "name": "SLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 26, "domain": null }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "junk", "type": "esriFieldTypeString", "alias": "junk", "length": 50, "domain": null }, { "name": "PACP_Use", "type": "esriFieldTypeString", "alias": "PACP_Use", "length": 2, "domain": { "type": "codedValue", "name": "WS2_ssUse", "description": "Sewer Use of Pipe", "codedValues": [ { "name": "Combined", "code": "CB" }, { "name": "Force Main", "code": "FM" }, { "name": "Processes", "code": "PR" }, { "name": "Sanitary", "code": "SS" }, { "name": "Stormwater", "code": "SW" }, { "name": "Other", "code": "ZZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOGIX_pipeID", "type": "esriFieldTypeSmallInteger", "alias": "LOGIX_pipeID", "domain": null }, { "name": "OLD_UNIQUEID", "type": "esriFieldTypeString", "alias": "OLD_UNIQUEID", "length": 100, "domain": null }, { "name": "DUMMY_NOTE", "type": "esriFieldTypeString", "alias": "DUMMY_NOTE", "length": 150, "domain": null }, { "name": "PlaceName", "type": "esriFieldTypeString", "alias": "PlaceName", "length": 50, "domain": null }, { "name": "Location_Code", "type": "esriFieldTypeString", "alias": "Location_Code", "length": 5, "domain": { "type": "codedValue", "name": "WS2_ssLocCode", "description": "Sewer Location Code", "codedValues": [ { "name": "Main Highway - Urban", "code": "A" }, { "name": "Main Highway - Suburnan/Rural", "code": "B" }, { "name": "Light Highway", "code": "C" }, { "name": "Easement / 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": "Metallic Surface", "code": "T" }, { "name": "Yard", "code": "Y" }, { "name": "Other", "code": "Z" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "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": "ActivityID", "type": "esriFieldTypeString", "alias": "ActivityID", "length": 20, "domain": null }, { "name": "LastActivity", "type": "esriFieldTypeString", "alias": "LastActivity", "length": 4, "domain": null }, { "name": "DateStamp", "type": "esriFieldTypeDate", "alias": "DateStamp", "length": 8, "domain": null }, { "name": "OpTime", "type": "esriFieldTypeString", "alias": "OpTime", "length": 5, "domain": null }, { "name": "OeratedBy", "type": "esriFieldTypeString", "alias": "OeratedBy", "length": 30, "domain": null }, { "name": "ComputerName", "type": "esriFieldTypeString", "alias": "ComputerName", "length": 30, "domain": null }, { "name": "Mileage", "type": "esriFieldTypeDouble", "alias": "Mileage", "domain": null }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DataSource", "type": "esriFieldTypeString", "alias": "DataSource", "length": 200, "domain": null }, { "name": "Size_1899", "type": "esriFieldTypeSmallInteger", "alias": "Size_1899", "domain": null }, { "name": "exist", "type": "esriFieldTypeString", "alias": "exist", "length": 50, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SRF_PACKAGE", "type": "esriFieldTypeString", "alias": "SRF_PACKAGE", "length": 150, "domain": null }, { "name": "RehabID", "type": "esriFieldTypeString", "alias": "RehabID", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 64, "domain": null }, { "name": "Material_Itpipes", "type": "esriFieldTypeString", "alias": "Material_Itpipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeMaterial_NEW", "description": "Pipe domain to work with IT Pipe Fields", "codedValues": [ { "name": "Acrylonitrile Butadiene Styrene", "code": "Acrylonitrile Butadiene Styrene" }, { "name": "Asbestos Cement", "code": "Asbestos Cement" }, { "name": "Brick", "code": "Brick" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Clay-lined Concrete Pipe", "code": "Clay-lined Concrete Pipe" }, { "name": "Corrugated Metal Pipe", "code": "Corrugated Metal Pipe" }, { "name": "Concrete Pipe (non-reinforced)", "code": "Concrete Pipe (non-reinforced)" }, { "name": "Concrete Segments (bolted)", "code": "Concrete Segments (bolted)" }, { "name": "Concrete Segments (unbolted)", "code": "Concrete Segments (unbolted)" }, { "name": "Clay Tile (not vitrified clay)", "code": "Clay Tile (not vitrified clay)" }, { "name": "Ductile Iron Pipe", "code": "Ductile Iron Pipe" }, { "name": "Fiberglass Reinforced Pipe", "code": "Fiberglass Reinforced Pipe" }, { "name": "Pitch Fiber (Orangeburg)", "code": "Pitch Fiber (Orangeburg)" }, { "name": "Polymer Concrete Pipe", "code": "Polymer Concrete Pipe" }, { "name": "Pre-stressed Concrete Cylinder Pipe", "code": "Pre-stressed Concrete Cylinder Pipe" }, { "name": "Polyethylene", "code": "Polyethylene" }, { "name": "Polypropylene", "code": "Polypropylene" }, { "name": "Plastic/Steel Composite", "code": "Plastic/Steel Composite" }, { "name": "Polyvinyl Chloride", "code": "Polyvinyl Chloride" }, { "name": "Reinforced Concrete Pipe", "code": "Reinforced Concrete Pipe" }, { "name": "Reinforced Plastic Pipe (Truss Pipe)", "code": "Reinforced Plastic Pipe (Truss Pipe)" }, { "name": "Segmented Block", "code": "Segmented Block" }, { "name": "Steel Pipe", "code": "Steel Pipe" }, { "name": "Vitrified Clay Pipe", "code": "Vitrified Clay Pipe" }, { "name": "Wood", "code": "Wood" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WaterTypeITPipes", "type": "esriFieldTypeString", "alias": "WaterTypeITPipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeuse", "description": "DESCRIPT", "codedValues": [ { "name": "Combined Pipe", "code": "Combined Pipe" }, { "name": "Dam Pipe", "code": "Dam Pipe" }, { "name": "Force Main", "code": "Force Main" }, { "name": "Levee Gravity Pipe", "code": "Levee Gravity Pipe" }, { "name": "Levee Pressure Pipe", "code": "Levee Pressure Pipe" }, { "name": "Process Pipe", "code": "Process Pipe" }, { "name": "Sanitary Sewage Pipe", "code": "Sanitary Sewage Pipe" }, { "name": "Stormwater Pipe", "code": "Stormwater Pipe" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape_ITPipes", "type": "esriFieldTypeString", "alias": "Shape_ITPipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeshape", "description": "DESCRIPT", "codedValues": [ { "name": "Arched (with flat bottom)", "code": "Arched (with flat bottom)" }, { "name": "Barrel (e.g. beer barrel shape)", "code": "Barrel (e.g. beer barrel shape)" }, { "name": "Circular", "code": "Circular" }, { "name": "Egg-Shaped", "code": "Egg-Shaped" }, { "name": "Horseshoe (i.e. inverted U with curved sidewalls)", "code": "Horseshoe (i.e. inverted U with curved sidewalls)" }, { "name": "Oval (Elliptical)", "code": "Oval (Elliptical)" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Square", "code": "Square" }, { "name": "Trapezoidal", "code": "Trapezoidal" }, { "name": "U-Shaped with Flat Top (straight walls)", "code": "U-Shaped with Flat Top (straight walls)" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pipeLiningITPipes", "type": "esriFieldTypeString", "alias": "pipeLiningITPipes", "length": 100, "domain": { "type": "codedValue", "name": "WS2_pipeliningmethod", "description": "DESCRIPT", "codedValues": [ { "name": "Cured-In-Place Pipe", "code": "Cured-In-Place Pipe" }, { "name": "Fold and Form or Deform/Reform", "code": "Fold and Form or Deform/Reform" }, { "name": "Formed-In-Place Liner", "code": "Formed-In-Place Liner" }, { "name": "Grout-In-Place Liner", "code": "Grout-In-Place Liner" }, { "name": "Glass Reinforced Cement", "code": "Glass Reinforced Cement" }, { "name": "None", "code": "None" }, { "name": "Continuous Slip Liner", "code": "Continuous Slip Liner" }, { "name": "Sectional Slip Liner", "code": "Sectional Slip Liner" }, { "name": "Spray Liner", "code": "Spray Liner" }, { "name": "Segmented Panel", "code": "Segmented Panel" }, { "name": "Segmented Pipe", "code": "Segmented Pipe" }, { "name": "Spiral Wound", "code": "Spiral Wound" }, { "name": "Not Known", "code": "Not Known" }, { "name": "Other (State in Additional Information field 59)", "code": "Other (State in Additional Information field 59)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R48_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_48", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_48", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S43_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "hasM": 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, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true, "serviceItemId": "6afd51ca97a04c2fb315218fffc0f4e6" } ], "tables": [ { "currentVersion": 10.91, "id": 8, "name": "ElementsXS.DBO.%view_DD_28", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ProjectName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Id", "type": "esriFieldTypeOID", "alias": "Id", "domain": null }, { "name": "EntryGuid", "type": "esriFieldTypeGUID", "alias": "EntryGuid", "length": 38, "domain": null }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null }, { "name": "Duration", "type": "esriFieldTypeDouble", "alias": "Duration", "domain": null }, { "name": "lbsPressure", "type": "esriFieldTypeDouble", "alias": "lbsPressure", "domain": null }, { "name": "Length", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "ProjectName", "type": "esriFieldTypeString", "alias": "ProjectName", "length": 250, "domain": null }, { "name": "SystemType", "type": "esriFieldTypeString", "alias": "SystemType", "length": 250, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 250, "domain": null }, { "name": "Pipe_Grade", "type": "esriFieldTypeDouble", "alias": "Pipe_Grade", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "6afd51ca97a04c2fb315218fffc0f4e6" } ] }