Layers:

Layer: Water Utility Stop Employee Information (0)

Name: Water Utility Stop Employee Information

Display Field: EMPLOYEE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: -1.5306436407191567E7
YMin: -2.944910386452497E7
XMax: -1.036027962694783E7
YMax: 4397396.191651145
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [39, 163, 47, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GUID ( type: esriFieldTypeGUID, alias: Points to UtilityServiceStop GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• EMPLOYEE ( type: esriFieldTypeString, alias: City of Branson Employee, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EMPLOYEE , Coded Values: [Dylan Hampton: Dylan Hampton] , [Alan Johnson: Alan Johnson] , [Alex Kyger: Alex Kyger] , ...10 more... )
• HOURS ( type: esriFieldTypeDouble, alias: Hours, editable: true, nullable: true, defaultValue: null, modelName: HOURS )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: Water Utility Stop Employee Information
  Description:
  Prototype:
  HOURS: null
  EMPLOYEE: null
  GUID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.ssSewerRepairs (0) -- Related To: Sewer Repairs (5)
• COB_LGIM.DBO.ssManholeWork (2) -- Related To: Manhole Maintenance Jobs (6)
• COB_LGIM.DBO.ssMainLineJobType (1) -- Related To: Mainline Maintenance Jobs (7)

Layer: Utility Stop Equipment Information (1)

Name: Utility Stop Equipment Information

Display Field: EQUIPMENT

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: -1.5306436407191567E7
YMin: -2.944910386452497E7
XMax: -1.036027962694783E7
YMax: 4397396.191651145
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [52, 155, 38, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GUID ( type: esriFieldTypeGUID, alias: Points to UtilityServiceStop GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• EQUIPMENT ( type: esriFieldTypeString, alias: City of Branson Equipment, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EQUIPMENT , Coded Values: [Unit 141: Unit 141] , [Unit 160: Unit 160] , [Unit 184: Unit 184] , ...30 more... )
• HOURS ( type: esriFieldTypeDouble, alias: Hours, editable: true, nullable: true, defaultValue: null, modelName: HOURS )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: Utility Stop Equipment Information
  Description:
  Prototype:
  HOURS: null
  EQUIPMENT: null
  GUID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.ssSewerRepairs (5) -- Related To: Sewer Repairs (5)
• COB_LGIM.DBO.ssManholeWork (4) -- Related To: Manhole Maintenance Jobs (6)
• COB_LGIM.DBO.ssMainLineJobType (3) -- Related To: Mainline Maintenance Jobs (7)

Layer: Manholes (2)

Name: Manholes

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 67874.854386

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: -1.038846053100044E7
YMin: 4383503.634130891
XMax: -1.0375368242583713E7
YMax: 4397398.770814344
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [5, 128, 17, 255]
Size: 5.497
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• ASSETGRID ( type: esriFieldTypeString, alias: Asset Grid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETGRID )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 400, defaultValue: null, modelName: COMMENTS )
• EASEMTCOND ( type: esriFieldTypeString, alias: Condition of Easement, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EASEMTCOND , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• CVTYPE ( type: esriFieldTypeString, alias: Cover Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CVTYPE , Coded Values: [Standard W/ Lock: Standard W/ Lock] , [Standard W/ Ears: Standard W/ Ears] , [Water Tight: Water Tight] , ...7 more... )
• DATA_STATUS ( type: esriFieldTypeString, alias: Current status of feature data, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DATA_STATUS )
• CLEAN_DT ( type: esriFieldTypeDate, alias: Date Cleaned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CLEAN_DT )
• INSPECT_DT ( type: esriFieldTypeDate, alias: Date Inspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPECT_DT )
• PLAN_DATE ( type: esriFieldTypeDate, alias: Date on Project Plans, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLAN_DATE )
• LIDDIA ( type: esriFieldTypeDouble, alias: Diameter of lid in inches, editable: true, nullable: true, defaultValue: null, modelName: LIDDIA , Range: [0, 72] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• FLD_CMNT ( type: esriFieldTypeString, alias: Field Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FLD_CMNT )
• FLOWDIR ( type: esriFieldTypeString, alias: Flow Direction, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FLOWDIR , Coded Values: [East: East] , [North: North] , [South: South] , ...9 more... )
• FL_IN1 ( type: esriFieldTypeDouble, alias: Flow Inlet 1 Elevation, editable: true, nullable: true, defaultValue: null, modelName: FL_IN1 )
• FL_IN2 ( type: esriFieldTypeDouble, alias: Flow Inlet 2 Elevation, editable: true, nullable: true, defaultValue: null, modelName: FL_IN2 )
• FL_IN3 ( type: esriFieldTypeDouble, alias: Flow Inlet 3 Elevation, editable: true, nullable: true, defaultValue: null, modelName: FL_IN3 )
• FL_OUT ( type: esriFieldTypeDouble, alias: Flow Out Elevation, editable: true, nullable: true, defaultValue: null, modelName: FL_OUT )
• SUMFLOW ( type: esriFieldTypeDouble, alias: Flow Summary, editable: true, nullable: true, defaultValue: null, modelName: SUMFLOW )
• FORCEIN ( type: esriFieldTypeString, alias: Force Main inlet (yes or no), editable: true, nullable: true, length: 10, defaultValue: null, modelName: FORCEIN , Coded Values: [Yes: Yes] , [No: No] )
• GPSUSER ( type: esriFieldTypeString, alias: GPS Data Collector Initials, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GPSUSER )
• GPSDATE ( type: esriFieldTypeDate, alias: GPS Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDATE )
• HIGHELEV ( type: esriFieldTypeDouble, alias: High Pipe Elevation, editable: true, nullable: true, defaultValue: null, modelName: HIGHELEV )
• INFILTRATN ( type: esriFieldTypeString, alias: Infiltration condition, editable: true, nullable: true, length: 25, defaultValue: null, modelName: INFILTRATN , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• IN1DIA ( type: esriFieldTypeDouble, alias: Inlet 1 pipe diamter, editable: true, nullable: true, defaultValue: null, modelName: IN1DIA , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• IN1MTRL ( type: esriFieldTypeString, alias: Inlet 1 pipe material, editable: true, nullable: true, length: 100, defaultValue: null, modelName: IN1MTRL , Coded Values: [ABS: ABS Plastic] , [ASP: Asphalt] , [BR: Brick] , ...48 more... )
• IN2MTRL ( type: esriFieldTypeString, alias: Inlet 2 material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IN2MTRL , Coded Values: [ABS: ABS Plastic] , [ASP: Asphalt] , [BR: Brick] , ...48 more... )
• IN2DIA ( type: esriFieldTypeDouble, alias: Inlet 2 pipe diameter, editable: true, nullable: true, defaultValue: null, modelName: IN2DIA , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• IN3DIA ( type: esriFieldTypeDouble, alias: Inlet 3 pipe diameter, editable: true, nullable: true, defaultValue: null, modelName: IN3DIA , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• IN3MTRL ( type: esriFieldTypeString, alias: Inlet 3 pipe material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IN3MTRL , Coded Values: [ABS: ABS Plastic] , [ASP: Asphalt] , [BR: Brick] , ...48 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• INVERT ( type: esriFieldTypeDouble, alias: Invert, editable: true, nullable: true, defaultValue: null, modelName: INVERT )
• INVERTELEV ( type: esriFieldTypeDouble, alias: Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVERTELEV )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LIDTHICK ( type: esriFieldTypeDouble, alias: LIDTHICK, editable: true, nullable: true, defaultValue: null, modelName: LIDTHICK )
• LINED ( type: esriFieldTypeString, alias: Lined, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LINED , Coded Values: [Yes: Yes] , [No: No] )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• CONDITION ( type: esriFieldTypeString, alias: Manhole Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...6 more... )
• MHDIA ( type: esriFieldTypeDouble, alias: Manhole diamete, editable: true, nullable: true, defaultValue: null, modelName: MHDIA , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• MH_NUM ( type: esriFieldTypeString, alias: Manhole Label Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MH_NUM )
• STAKED ( type: esriFieldTypeString, alias: Manhole staked (Yes or No), editable: true, nullable: true, length: 10, defaultValue: null, modelName: STAKED , Coded Values: [Yes: Yes] , [No: No] )
• MHTYPE ( type: esriFieldTypeString, alias: Manhole Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MHTYPE , Coded Values: [STD: Standard] , [DRP: Drop] , [OTH: Other] , ...4 more... )
• SEWER_PLANT ( type: esriFieldTypeString, alias: Name of Sewer Treatment Plant, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SEWER_PLANT , Coded Values: [Cooper: Cooper Creek Wastewater Treatment Plant] , [Compton: Compton Wastewater Treatment Plant] , [Cliff: Cliff Drive Water Treatment Plant] , ...1 more... )
• NEW_MH_NUM ( type: esriFieldTypeString, alias: New Manhole Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEW_MH_NUM )
• OLDMHNO ( type: esriFieldTypeString, alias: Original Manhole Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OLDMHNO )
• OUTDIA ( type: esriFieldTypeDouble, alias: Outlet diameter, editable: true, nullable: true, defaultValue: null, modelName: OUTDIA , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• OUTMTRL ( type: esriFieldTypeString, alias: Outlet pipe material, editable: true, nullable: true, length: 100, defaultValue: null, modelName: OUTMTRL , Coded Values: [ABS: ABS Plastic] , [ASP: Asphalt] , [BR: Brick] , ...48 more... )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• CUTDEPTH ( type: esriFieldTypeDouble, alias: Pavement Cut Depth, editable: true, nullable: true, defaultValue: null, modelName: CUTDEPTH )
• PRIVATEIN ( type: esriFieldTypeString, alias: Private inlet (Yes or No), editable: true, nullable: true, length: 10, defaultValue: null, modelName: PRIVATEIN , Coded Values: [Yes: Yes] , [No: No] )
• PRIV_IN_DIA ( type: esriFieldTypeDouble, alias: Private inlet diameter, editable: true, nullable: true, defaultValue: null, modelName: PRIV_IN_DIA )
• PRIV_IN_DIA_2 ( type: esriFieldTypeDouble, alias: Private inlet diameter 2, editable: true, nullable: true, defaultValue: null, modelName: PRIV_IN_DIA_2 )
• PRIV_IN_DIA_3 ( type: esriFieldTypeDouble, alias: Private inlet diameter 3, editable: true, nullable: true, defaultValue: null, modelName: PRIV_IN_DIA_3 )
• PRIV_IN_MTRL ( type: esriFieldTypeString, alias: Private inlet material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRIV_IN_MTRL , Coded Values: [ABS: ABS Plastic] , [ASP: Asphalt] , [BR: Brick] , ...48 more... )
• PRIV_IN_MTRL_2 ( type: esriFieldTypeString, alias: Private inlet material 2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRIV_IN_MTRL_2 , Coded Values: [ABS: ABS Plastic] , [ASP: Asphalt] , [BR: Brick] , ...48 more... )
• PRIV_IN_MTRL_3 ( type: esriFieldTypeString, alias: Private inlet material 3, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRIV_IN_MTRL_3 , Coded Values: [ABS: ABS Plastic] , [ASP: Asphalt] , [BR: Brick] , ...48 more... )
• RIMELEV ( type: esriFieldTypeDouble, alias: Rim Elevation, editable: true, nullable: true, defaultValue: null, modelName: RIMELEV )
• PROJECT ( type: esriFieldTypeString, alias: Sewer Project Name, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PROJECT )
• EDIT_SOURCE ( type: esriFieldTypeString, alias: Source data for edits, editable: true, nullable: true, length: 250, defaultValue: null, modelName: EDIT_SOURCE )
• WALLMAT ( type: esriFieldTypeString, alias: Wall Material, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WALLMAT , Coded Values: [ABS: ABS Plastic] , [ASP: Asphalt] , [BR: Brick] , ...48 more... )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WATERTYPE , Coded Values: [Treated: Treated Water] , [Potable: Potable Water] , [Raw: Raw Water] , ...4 more... )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: Sanitary Sewer Manholes
  Description:
  Prototype:
  ACTIVEFLAG: 1
  PRIV_IN_MTRL_2: null
  ENABLED: 1
  IN3MTRL: null
  GPSDATE: null
  INSTALLDATE: null
  INVERT: null
  PRIV_IN_MTRL_3: null
  EASEMTCOND: null
  EDIT_SOURCE: null
  STAKED: null
  MAINTBY: 1
  OWNEDBY: 1
  FLD_CMNT: null
  LIDTHICK: null
  GPSUSER: null
  WALLMAT: null
  LINED: null
  LIDDIA: null
  SEWER_PLANT: null
  OUTMTRL: null
  LONGITUDE: null
  FL_OUT: null
  MHDIA: null
  CONDITION: null
  OLDMHNO: null
  OUTDIA: null
  INFILTRATN: null
  IN1DIA: null
  IN2MTRL: null
  IN1MTRL: null
  IN2DIA: null
  IN3DIA: null
  SUMFLOW: null
  ASSETGRID: null
  PLAN_DATE: null
  LATITUDE: null
  MH_NUM: null
  COMMENTS: null
  HIGHELEV: null
  FORCEIN: null
  CUTDEPTH: null
  LOCDESC: null
  INVERTELEV: null
  FL_IN3: null
  FLOWDIR: null
  FL_IN1: null
  FL_IN2: null
  RIMELEV: null
  INSPECT_DT: null
  PROJECT: null
  MHTYPE: null
  NEW_MH_NUM: null
  CLEAN_DT: null
  FACILITYID: null
  DATA_STATUS: null
  PRIV_IN_DIA_2: null
  PRIV_IN_MTRL: null
  PRIV_IN_DIA: null
  WATERTYPE: null
  PRIVATEIN: null
  PRIV_IN_DIA_3: null
  CVTYPE: null
  WATERSHED: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.ssSewerRepairs (6) -- Related To: Sewer Repairs (5)
• COB_LGIM.DBO.ssManholeWork (7) -- Related To: Manhole Maintenance Jobs (6)

Layer: Gravity Mains (3)

Name: Gravity Mains

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 48409.53726

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: -1.0388460660178049E7
YMin: 4382873.943883715
XMax: -1.0375363652544893E7
YMax: 4397398.770814344
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [5, 128, 17, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• ASSETGRID ( type: esriFieldTypeString, alias: Asset Grid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETGRID )
• DATA_STATUS ( type: esriFieldTypeString, alias: Current status of feature, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DATA_STATUS )
• PLAN_DATE ( type: esriFieldTypeDate, alias: Date of project plans, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLAN_DATE )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• DOWNELEV ( type: esriFieldTypeDouble, alias: Downstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: DOWNELEV )
• ESMT_MAINT ( type: esriFieldTypeSmallInteger, alias: Easement Maintenance, editable: true, nullable: true, defaultValue: null, modelName: ESMT_MAINT , Range: [0, 5] )
• EASEMENT_WIDTH ( type: esriFieldTypeDouble, alias: Easement Width, editable: true, nullable: true, defaultValue: null, modelName: EASEMENT_WIDTH )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• SUMFLOW ( type: esriFieldTypeDouble, alias: Flow Summary, editable: true, nullable: true, defaultValue: null, modelName: SUMFLOW )
• FROMMH ( type: esriFieldTypeString, alias: From Manhole, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FROMMH )
• FROM_NEW_MH ( type: esriFieldTypeString, alias: From New MH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FROM_NEW_MH )
• HASVIDEO ( type: esriFieldTypeString, alias: Has Video, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HASVIDEO )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• PIPELENGTH ( type: esriFieldTypeDouble, alias: Length of Pipe, editable: true, nullable: true, defaultValue: null, modelName: PIPELENGTH )
• LINER_NEEDED ( type: esriFieldTypeString, alias: Liner Needed (Y/N), editable: true, nullable: true, length: 10, defaultValue: null, modelName: LINER_NEEDED , Coded Values: [Yes: Yes] , [No: No] )
• LINERTYPE ( type: esriFieldTypeString, alias: Liner Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LINERTYPE , Coded Values: [CP: Cured in Place] , [OTH: Other] , [NONE: None] )
• MAINSHAPE ( type: esriFieldTypeString, alias: Main Shape, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINSHAPE , Coded Values: [Circular: Circular] , [Other: Other] , [Unknown: Unknown] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL , Coded Values: [ABS: ABS Plastic] , [ASP: Asphalt] , [BR: Brick] , ...48 more... )
• PROJECT ( type: esriFieldTypeString, alias: Name of project, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PROJECT )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• LIFTSTATION ( type: esriFieldTypeString, alias: Receiving Liftstation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LIFTSTATION , Coded Values: [2: 2] , [3: 3] , [4: 4] , ...39 more... )
• SEWER_PLANT ( type: esriFieldTypeString, alias: Receiving treatment plant, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SEWER_PLANT , Coded Values: [Cooper: Cooper Creek Wastewater Treatment Plant] , [Compton: Compton Wastewater Treatment Plant] , [Cliff: Cliff Drive Water Treatment Plant] , ...1 more... )
• SLOPE ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: SLOPE )
• SLOPE_DEG ( type: esriFieldTypeDouble, alias: SLOPE_DEG, editable: true, nullable: true, defaultValue: null, modelName: SLOPE_DEG )
• DATA_SOURCE ( type: esriFieldTypeString, alias: Source of feature data, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DATA_SOURCE )
• TOMH ( type: esriFieldTypeString, alias: To Manhole, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TOMH )
• TO_NEW_MH ( type: esriFieldTypeString, alias: To New MH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TO_NEW_MH )
• UPELEV ( type: esriFieldTypeDouble, alias: Upstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: UPELEV )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WATERTYPE , Coded Values: [Treated: Treated Water] , [Potable: Potable Water] , [Raw: Raw Water] , ...4 more... )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• LINEDYEAR ( type: esriFieldTypeString, alias: Year Lined, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LINEDYEAR )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )
Templates:
• Name: Sewer Gravity Mains
  Description:
  Prototype:
  ACTIVEFLAG: 1
  FROM_NEW_MH: null
  ENABLED: 1
  HASVIDEO: null
  MAINTBY: 1
  PLAN_DATE: null
  LINERTYPE: null
  WATERSHED: null
  LINER_NEEDED: null
  SUMFLOW: null
  DATA_SOURCE: null
  UPELEV: null
  EASEMENT_WIDTH: null
  FROMMH: null
  PROJECT: null
  MAINSHAPE: null
  FACILITYID: null
  DIAMETER: null
  TO_NEW_MH: null
  SEWER_PLANT: null
  SLOPE: null
  ESMT_MAINT: null
  DOWNELEV: null
  TOMH: null
  INSTALLDATE: null
  ASSETGRID: null
  MATERIAL: null
  SLOPE_DEG: null
  LIFTSTATION: null
  DATA_STATUS: null
  WATERTYPE: null
  OWNEDBY: 1
  PIPELENGTH: null
  LINEDYEAR: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• COB_LGIM.DBO.ssMainLineJobType (8) -- Related To: Mainline Maintenance Jobs (7)

Layer: Pressurized Mains (4)

Name: Pressurized Mains

Display Field: PROJ_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 52846.214965

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: -1.038722150282239E7
YMin: 4382792.785946217
XMax: -1.0376105205052603E7
YMax: 4397885.038136656
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [229, 28, 19, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• ASSETGRID ( type: esriFieldTypeString, alias: Asset Grid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETGRID )
• ASSOC_FACILITY ( type: esriFieldTypeString, alias: Associated Facility, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ASSOC_FACILITY )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• PLAN_DATE ( type: esriFieldTypeDate, alias: Date of Plans, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLAN_DATE )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...25 more... )
• ESMT_MAINT ( type: esriFieldTypeSmallInteger, alias: Easement Maintenance, editable: true, nullable: true, defaultValue: null, modelName: ESMT_MAINT , Range: [0, 5] )
• EASEMENT_WIDTH ( type: esriFieldTypeDouble, alias: Easement Width, editable: true, nullable: true, defaultValue: null, modelName: EASEMENT_WIDTH )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LENGTH ( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: LENGTH )
• LINE_TYPE ( type: esriFieldTypeString, alias: Line Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LINE_TYPE , Coded Values: [Main Line: Main Line] , [Service Line: Service Line] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...18 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL , Coded Values: [ABS: ABS Plastic] , [ASP: Asphalt] , [BR: Brick] , ...48 more... )
• PROJ_NAME ( type: esriFieldTypeString, alias: Name of Project, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PROJ_NAME )
• ORIG_ID ( type: esriFieldTypeInteger, alias: Original ID, editable: true, nullable: true, defaultValue: null, modelName: ORIG_ID )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: CITY OF BRANSON] , [2: TANEY COUNTY] , [3: STONE COUNTY] , ...7 more... )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WATERTYPE , Coded Values: [Treated: Treated Water] , [Potable: Potable Water] , [Raw: Raw Water] , ...4 more... )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )
Templates:
• Name: Sewer Pressurized Mains
  Description:
  Prototype:
  ACTIVEFLAG: 1
  ASSOC_FACILITY: null
  ENABLED: 1
  FACILITYID: null
  MAINTBY: 1
  PLAN_DATE: null
  OWNEDBY: 1
  EASEMENT_WIDTH: null
  DIAMETER: null
  ORIG_ID: null
  LINE_TYPE: null
  COMMENTS: null
  MATERIAL: null
  ESMT_MAINT: null
  LENGTH: null
  WATERTYPE: null
  INSTALLDATE: null
  ASSETGRID: null
  PROJ_NAME: null
  WATERSHED: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• COB_LGIM.DBO.ssMainLineJobType (9) -- Related To: Mainline Maintenance Jobs (7)

Layer: Sewer Repairs (5)

Name: Sewer Repairs

Display Field: LOCATION

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: -1.0386181509394415E7
YMin: 4383157.90088234
XMax: -1.0376591780920422E7
YMax: 4394514.675335103
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [47, 0, 156, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: COMMENTS )
• DEPTH ( type: esriFieldTypeDouble, alias: Depth in Inches, editable: true, nullable: true, defaultValue: null, modelName: DEPTH )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCATION )
• PIPELENGTH ( type: esriFieldTypeDouble, alias: Pipe Length, editable: true, nullable: true, defaultValue: null, modelName: PIPELENGTH )
• PIPESIZE ( type: esriFieldTypeDouble, alias: Pipe Size, editable: true, nullable: true, defaultValue: null, modelName: PIPESIZE )
• REPAIRTYPE ( type: esriFieldTypeString, alias: Repair Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: REPAIRTYPE , Coded Values: [Point Repair: Point Repair] , [Sewer Backup: Sewer Backup] , [Leak: Leak] )
• SERVICETYPE ( type: esriFieldTypeString, alias: Service Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SERVICETYPE , Coded Values: [Gravity Main: Gravity Main] , [Pressurized Main: Pressurized Main] , [Manhole: Manhole] )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: Sewer Repairs
  Description:
  Prototype:
  COMMENTS: null
  SERVICETYPE: null
  DEPTH: null
  REPAIRTYPE: null
  PIPESIZE: null
  PIPELENGTH: null
  LOCATION: null
  WATERSHED: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• COB_LGIM.DBO.UtilityStopEmployeeInfo (0) -- Related To: Water Utility Stop Employee Information (0)
• COB_LGIM.DBO.UtilityStopEquipmentInfo (5) -- Related To: Utility Stop Equipment Information (1)
• COB_LGIM.DBO.ssManhole (6) -- Related To: Manholes (2)

Layer: Manhole Maintenance Jobs (6)

Name: Manhole Maintenance Jobs

Display Field: JOBTYPE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: -1.0387060561993398E7
YMin: 4383515.526669207
XMax: -1.037571651190011E7
YMax: 4397396.191651145
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: NEEDREPAIR
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: No
  Label: No
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [237, 81, 81, 255]
  Size: 8.03
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [8, 8, 8, 255] Width: 0
• Value: Yes
  Label: Yes
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [112, 20, 204, 255]
  Size: 8.04
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [8, 8, 8, 255] Width: 0
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: NEEDREPAIR

Fields:
• ASSETGRID ( type: esriFieldTypeString, alias: Asset Grid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETGRID )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: COMMENTS )
• GALLONS ( type: esriFieldTypeDouble, alias: Gallons Used, editable: true, nullable: true, defaultValue: null, modelName: GALLONS )
• JOBTYPE ( type: esriFieldTypeString, alias: Job Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: JOBTYPE , Coded Values: [GPS: GPS] , [Inspection: Inspection] , [General Maintenance: General Maintenance] , ...3 more... )
• NEEDREPAIR ( type: esriFieldTypeString, alias: Needs Repair, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDREPAIR , Coded Values: [Yes: Yes] , [No: No] , [Fixed: Fixed] )
• RAMNEK ( type: esriFieldTypeString, alias: Ram-nek Pieces Used, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RAMNEK )
• CASTING ( type: esriFieldTypeString, alias: Type of Casting Used, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CASTING , Coded Values: [New: New] , [Used: Used] )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: false, length: 38, defaultValue: null, modelName: GUID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Types:
ID: No
Name: No
Domains:
• JOBTYPE:
  Inherited
• NEEDREPAIR:
  Inherited
• CASTING:
  Inherited
• WATERSHED:
  Inherited
Templates:
• Name: No
  Description:
  Prototype:
  GUID: {00000000-0000-0000-0000-000000000000}
  ASSETGRID: null
  COMMENTS: null
  GALLONS: null
  JOBTYPE: null
  NEEDREPAIR: No
  RAMNEK: null
  CASTING: null
  WATERSHED: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Yes
Name: Yes
Domains:
• JOBTYPE:
  Inherited
• NEEDREPAIR:
  Inherited
• CASTING:
  Inherited
• WATERSHED:
  Inherited
Templates:
• Name: Yes
  Description:
  Prototype:
  GUID: {00000000-0000-0000-0000-000000000000}
  ASSETGRID: null
  COMMENTS: null
  GALLONS: null
  JOBTYPE: null
  NEEDREPAIR: Yes
  RAMNEK: null
  CASTING: null
  WATERSHED: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• COB_LGIM.DBO.UtilityStopEmployeeInfo (2) -- Related To: Water Utility Stop Employee Information (0)
• COB_LGIM.DBO.UtilityStopEquipmentInfo (4) -- Related To: Utility Stop Equipment Information (1)
• COB_LGIM.DBO.ssManhole (7) -- Related To: Manholes (2)

Layer: Mainline Maintenance Jobs (7)

Name: Mainline Maintenance Jobs

Display Field: JOBTYPE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: -1.038846053100044E7
YMin: 4383625.413874313
XMax: -1.0375369130369505E7
YMax: 4397398.770814344
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: NEEDREPAIR
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: No
  Label: No
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [179, 89, 51, 255]
  Width: 4
• Value: Yes
  Label: Yes
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [179, 89, 51, 255]
  Width: 4
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: NEEDREPAIR

Fields:
• ASSETGRID ( type: esriFieldTypeString, alias: Asset Grid, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETGRID )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: COMMENTS )
• GALLONS ( type: esriFieldTypeDouble, alias: Gallons Used, editable: true, nullable: true, defaultValue: null, modelName: GALLONS )
• JOBTYPE ( type: esriFieldTypeString, alias: Job Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: JOBTYPE , Coded Values: [Easement Clearing: Easement Clearing] , [Jetting: Jetting] , [Point Repair: Point Repair] , ...3 more... )
• NEW_MH_NUM ( type: esriFieldTypeString, alias: Manhole number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEW_MH_NUM )
• NEEDREPAIR ( type: esriFieldTypeString, alias: Need Repair, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEEDREPAIR , Coded Values: [Yes: Yes] , [No: No] , [Fixed: Fixed] )
• NUMBERFEET ( type: esriFieldTypeDouble, alias: Number of feet, editable: true, nullable: true, defaultValue: null, modelName: NUMBERFEET )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WATERSHED , Coded Values: [BEE_CREEK: Bee Creek] , [COOPER_CREEK: Cooper Creek] , [COPELAND_BRANCH: Copeland Branch] , ...7 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )
Types:
ID: No
Name: No
Domains:
• JOBTYPE:
  Inherited
• NEEDREPAIR:
  Inherited
• WATERSHED:
  Inherited
Templates:
• Name: No
  Description:
  Prototype:
  GUID: null
  ASSETGRID: null
  COMMENTS: null
  GALLONS: null
  JOBTYPE: null
  NEW_MH_NUM: null
  NEEDREPAIR: No
  NUMBERFEET: null
  WATERSHED: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Yes
Name: Yes
Domains:
• JOBTYPE:
  Inherited
• NEEDREPAIR:
  Inherited
• WATERSHED:
  Inherited
Templates:
• Name: Yes
  Description:
  Prototype:
  GUID: null
  ASSETGRID: null
  COMMENTS: null
  GALLONS: null
  JOBTYPE: null
  NEW_MH_NUM: null
  NEEDREPAIR: Yes
  NUMBERFEET: null
  WATERSHED: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Relationships:

• COB_LGIM.DBO.UtilityStopEquipmentInfo (3) -- Related To: Utility Stop Equipment Information (1)
• COB_LGIM.DBO.UtilityStopEmployeeInfo (1) -- Related To: Water Utility Stop Employee Information (0)
• COB_LGIM.DBO.ssGravityMain (8) -- Related To: Gravity Mains (3)
• COB_LGIM.DBO.ssPressurizedMain (9) -- Related To: Pressurized Mains (4)

Layer: SSO Location (8)

Name: SSO Location

Display Field: FACNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACNAME ( type: esriFieldTypeString, alias: Facility Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FACNAME )
• PERMITNUM ( type: esriFieldTypeString, alias: Permit Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PERMITNUM , Coded Values: [Cooper: Cooper Creek Wastewater Treatment Plant] , [Compton: Compton Wastewater Treatment Plant] , [Cliff: Cliff Drive Water Treatment Plant] , ...1 more... )
• EVENTTYPE ( type: esriFieldTypeString, alias: Type of Event, editable: true, nullable: true, length: 100, defaultValue: SSO, modelName: EVENTTYPE )
• WDWEATHER ( type: esriFieldTypeString, alias: Wet Weather or Dry Weather, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WDWEATHER )
• EVENTSTARTDATE ( type: esriFieldTypeDate, alias: Event Begin Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EVENTSTARTDATE )
• EVENTSTARTTIME ( type: esriFieldTypeDate, alias: Event Start Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EVENTSTARTTIME )
• EVENTENDDATE ( type: esriFieldTypeDate, alias: Event End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EVENTENDDATE )
• EVENTENDTIME ( type: esriFieldTypeDate, alias: Event End Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EVENTENDTIME )
• EVENTDURATION ( type: esriFieldTypeString, alias: Event Duration, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EVENTDURATION )
• INIREPORTDATE ( type: esriFieldTypeDate, alias: Initial Report Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INIREPORTDATE )
• INIREPORTTIME ( type: esriFieldTypeDate, alias: Initial Report Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INIREPORTTIME )
• REPORTEDBY ( type: esriFieldTypeString, alias: Reported By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REPORTEDBY , Coded Values: [Dylan Hampton: Dylan Hampton] , [Alan Johnson: Alan Johnson] , [Alex Kyger: Alex Kyger] , ...10 more... )
• CONTACTPHONE ( type: esriFieldTypeString, alias: Immediate Contact Phone Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CONTACTPHONE )
• INIVOLUME ( type: esriFieldTypeDouble, alias: Estimated Volume at time of Initial Report, editable: true, nullable: true, defaultValue: null, modelName: INIVOLUME )
• BYPASSWTRSTATE ( type: esriFieldTypeString, alias: Is Bypass reaching Waters of the State?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BYPASSWTRSTATE , Coded Values: [Yes: Yes] , [No: No] )
• AFFECTEDWTRWAY ( type: esriFieldTypeString, alias: Affected Waterbody, editable: true, nullable: true, length: 250, defaultValue: null, modelName: AFFECTEDWTRWAY )
• DISCHARGETO ( type: esriFieldTypeString, alias: Discharge to, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DISCHARGETO )
• EVENTCAUSE ( type: esriFieldTypeString, alias: Cause of Event, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EVENTCAUSE )
• EVENTCAUSENOTES ( type: esriFieldTypeString, alias: Cause of Event Comments, editable: true, nullable: true, length: 1500, defaultValue: null, modelName: EVENTCAUSENOTES )
• SSOEVENTTYPE ( type: esriFieldTypeString, alias: Event Type , editable: true, nullable: true, length: 50, defaultValue: null, modelName: SSOEVENTTYPE )
• ADDIMPACT ( type: esriFieldTypeString, alias: Additional Impact, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ADDIMPACT )
• PERMITFEATURE ( type: esriFieldTypeString, alias: Permitted Feature, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PERMITFEATURE )
• CANPDESID ( type: esriFieldTypeString, alias: Control Authority NPDES ID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CANPDESID )
• CANPDESIDRSN ( type: esriFieldTypeString, alias: Control Authority NPDES ID Reason, editable: true, nullable: true, length: 250, defaultValue: null, modelName: CANPDESIDRSN )
• WETEVENTSTART ( type: esriFieldTypeDate, alias: Wet Event Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WETEVENTSTART )
• WETEVENTEND ( type: esriFieldTypeDate, alias: Wet Event End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WETEVENTEND )
• PRECIPTYPE ( type: esriFieldTypeString, alias: Precipitation Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PRECIPTYPE )
• PRECIPAMOUNT ( type: esriFieldTypeString, alias: Precipitation Amount, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRECIPAMOUNT )
• SOILCOND ( type: esriFieldTypeString, alias: Soil Conditions, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SOILCOND )
• LOCINFO ( type: esriFieldTypeString, alias: Location Information, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCINFO )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 25, defaultValue: Taney, modelName: COUNTY )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LOCDESC )
• UTMEASTING ( type: esriFieldTypeDouble, alias: UTM Easting, editable: true, nullable: true, defaultValue: null, modelName: UTMEASTING )
• UTMNORTHING ( type: esriFieldTypeDouble, alias: UTM Northing, editable: true, nullable: true, defaultValue: null, modelName: UTMNORTHING )
• ESTFINTOTALVOL ( type: esriFieldTypeDouble, alias: Estimated Final Total Volume, editable: true, nullable: true, defaultValue: null, modelName: ESTFINTOTALVOL )
• WETBYPASSWTRSTATE ( type: esriFieldTypeString, alias: Wet Event: Did Bypass reach Waters of the State?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WETBYPASSWTRSTATE , Coded Values: [Yes: Yes] , [No: No] )
• RESPONSE ( type: esriFieldTypeString, alias: Response, editable: true, nullable: true, length: 1500, defaultValue: null, modelName: RESPONSE )
• RECADDEDBY ( type: esriFieldTypeString, alias: Record Added By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RECADDEDBY , Coded Values: [Dylan Hampton: Dylan Hampton] , [Alan Johnson: Alan Johnson] , [Alex Kyger: Alex Kyger] , ...10 more... )
• ESIGNEDBY ( type: esriFieldTypeString, alias: eSigned By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ESIGNEDBY , Coded Values: [Dylan Hampton: Dylan Hampton] , [Alan Johnson: Alan Johnson] , [Alex Kyger: Alex Kyger] , ...10 more... )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: SSO Location
  Description:
  Prototype:
  RECADDEDBY: null
  RESPONSE: null
  WETBYPASSWTRSTATE: null
  FACNAME: null
  PERMITNUM: null
  EVENTTYPE: SSO
  WDWEATHER: null
  EVENTSTARTDATE: null
  EVENTSTARTTIME: null
  EVENTENDDATE: null
  EVENTENDTIME: null
  EVENTDURATION: null
  INIREPORTDATE: null
  INIREPORTTIME: null
  REPORTEDBY: null
  CONTACTPHONE: null
  INIVOLUME: null
  BYPASSWTRSTATE: null
  AFFECTEDWTRWAY: null
  DISCHARGETO: null
  EVENTCAUSE: null
  EVENTCAUSENOTES: null
  SSOEVENTTYPE: null
  ADDIMPACT: null
  PERMITFEATURE: null
  CANPDESID: null
  CANPDESIDRSN: null
  WETEVENTSTART: null
  WETEVENTEND: null
  PRECIPTYPE: null
  PRECIPAMOUNT: null
  SOILCOND: null
  LOCINFO: null
  COUNTY: Taney
  LOCDESC: null
  UTMEASTING: null
  UTMNORTHING: null
  ESTFINTOTALVOL: null
  ESIGNEDBY: null
  
  Drawing Tool: esriFeatureEditToolPoint