Name: SManhole

Display Field: CURRENT_SITENAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2093548.6698
YMin: 1190354.8321
XMax: 2268769.82
YMax: 1390927.87
Spatial Reference: 102630 (102630)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"73211f7256c1aacd086f4d787dbccbe1","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAXBJREFUKJGdkr1LQmEUh5+XpMuFmzeuEtiHEk0OTjW2BIIt1dKfELVHS/YfiIPQELVHQ4tD9OFiBNFQDgri0mZ6h/BSmtQL2dtg3bTEorOd4Tk855yfh3+Wp7NRCh1YbTZZbjSY0HXuTZMjYFsInJ6gUkyWy2QfHggNDYHXC40GoXKZGU1jXSltXgh51QUqhVYqce7zEYxEvqZaFoyPw9MT3nxeZpQiLAR3LlgqaVumKYMjI733MQyYmsLI5dgBFlywXpeL4XD/YxgGDAww26Wq6wz3x9rl92PGYoydnVHxALRa1P8C6jqPhULAArsN1mrkgcgvHNUqOdu2K67q3h7ZaJQ5YKwP95JOcwLtf3oADg853d21vGtrzibQ67bPNzdWPJXi8oNzA1CNx7m8vWUjkdCmhZBLwChQU4rM/j7HKyvNupTy+nOSmxzHca6TSSrJpHwFLoA3QACDgUCgKKVd7FToyipQBQ6+e9q2/cP9HW+Ifw1BqKvTAAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: AncillaryRole, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Source], [2: Sink])
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ADMINISTRATIVEAREA (type: esriFieldTypeString, alias: AdministrativeArea, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [0: Unknown], [1: ADAMSVILLE], [2: ALABASTER], ... 51 more ...)
• FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LEGACYID (type: esriFieldTypeString, alias: LEGACYID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: INSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OPERATIONALAREA (type: esriFieldTypeString, alias: OperationalArea, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [CAH: Cahaba], [FIV: Five Mile Creek], [LED: Leeds], ... 7 more ...)
• SUBBASIN (type: esriFieldTypeString, alias: SUBBASIN, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ROTATION (type: esriFieldTypeDouble, alias: ROTATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: LifeCycleStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PRP: Proposed], [ACT: Active], [ABN: Abandoned], ... 6 more ...)
• SUBTYPE (type: esriFieldTypeInteger, alias: SubType, SQL Type: sqlTypeOther, nullable: false, editable: true)
• WORKORDERID (type: esriFieldTypeString, alias: WORKORDERID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• WARRANTYDATE (type: esriFieldTypeDate, alias: WARRANTYDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSTALLCONTRACTOR (type: esriFieldTypeString, alias: INSTALLCONTRACTOR, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• WATERTYPE (type: esriFieldTypeString, alias: WaterType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Treated: Treated Water], [Combined: Combined Waste Water], [Reclaimed: Reclaimed Water], ... 4 more ...)
• ELEVATION (type: esriFieldTypeDouble, alias: ELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BELOWGRADE (type: esriFieldTypeInteger, alias: BelowGrade, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
• MANUFACTURER (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other])
• ACCESSDIAMETER (type: esriFieldTypeInteger, alias: AccessDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 72])
• ACCESSTYPE (type: esriFieldTypeString, alias: AccessType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Door: Door], [Grate: Grate], [Hand: Hand], ... 4 more ...)
• GROUNDTYPE (type: esriFieldTypeString, alias: GroundType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other], [D: Dirt], ... 4 more ...)
• HIGHPIPEELEVATION (type: esriFieldTypeDouble, alias: HIGHPIPEELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DEPTH (type: esriFieldTypeDouble, alias: DEPTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INTERIORDROP (type: esriFieldTypeInteger, alias: INTERIORDROP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BARRELMATERIAL (type: esriFieldTypeString, alias: BarrelMaterial, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other], [BRK: Brick], ... 2 more ...)
• RIMELEVATION (type: esriFieldTypeDouble, alias: RIMELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STEPMATERIAL (type: esriFieldTypeString, alias: StepMaterial, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other], [CI: Cast Iron], ... 2 more ...)
• BARRELDIAMETER (type: esriFieldTypeInteger, alias: BarrelDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [36: 36 Inch], [48: 48 Inch], [60: 60 Inch], ... 1 more ...)
• BENCHMATERIAL (type: esriFieldTypeString, alias: BenchMaterial, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other], [BRK: Brick], ... 1 more ...)
• CHANNELMATERIAL (type: esriFieldTypeString, alias: ChannelMaterial, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other], [BRK: Brick], ... 1 more ...)
• RINGMATERIAL (type: esriFieldTypeString, alias: RingMaterial, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other], [BRK: Brick], ... 1 more ...)
• ACCESSMATERIAL (type: esriFieldTypeString, alias: AccessMaterial, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other], [CI: Cast Iron], ... 1 more ...)
• FRAMEMATERIAL (type: esriFieldTypeString, alias: FrameMaterial, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other], [BRK: Brick], ... 1 more ...)
• CONEMATERIAL (type: esriFieldTypeString, alias: ConeMaterial, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other], [BRK: Brick], ... 1 more ...)
• BASEMATERIAL (type: esriFieldTypeString, alias: BaseMaterial, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other], [BRK: Brick], ... 1 more ...)
• MEASUREMENT1 (type: esriFieldTypeDouble, alias: MEASUREMENT1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MEASUREMENT2 (type: esriFieldTypeDouble, alias: MEASUREMENT2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: CONDITION, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CONDITIONDATE (type: esriFieldTypeDate, alias: CONDITIONDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FEATURE_ID (type: esriFieldTypeDouble, alias: FEATURE_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• METADATAID (type: esriFieldTypeString, alias: METADATAID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• OWNERTYPE (type: esriFieldTypeString, alias: OwnerType, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [PVT: Private], [CNT: County], [STA: State], ... 3 more ...)
• FLOWMONITORINDICATOR (type: esriFieldTypeInteger, alias: FlowMonitorIndicator, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• TEMP_MHNUM (type: esriFieldTypeString, alias: TEMP_MHNUM, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OLDMH_NUMBER (type: esriFieldTypeString, alias: OLDMH_NUMBER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PVT_TREATMENT (type: esriFieldTypeString, alias: PVT_TREATMENT, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• CURRENT_SITENAME (type: esriFieldTypeString, alias: CURRENT_SITENAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• INTELLISCAN_NAME (type: esriFieldTypeString, alias: INTELLISCAN_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FACILITY_ID (type: esriFieldTypeString, alias: FACILITY_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• X_COORD (type: esriFieldTypeDouble, alias: X_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y_COORD (type: esriFieldTypeDouble, alias: Y_COORD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS (type: esriFieldTypeString, alias: GPS, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• REF_NUMBER (type: esriFieldTypeString, alias: REF_NUMBER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PROPOSED_REF_NUMBER (type: esriFieldTypeString, alias: PROPOSED_REF_NUMBER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ABANDONEDDATE (type: esriFieldTypeDate, alias: ABANDONEDDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FLD_VERIFY (type: esriFieldTypeDate, alias: FLD_VERIFY, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DOCLINK (type: esriFieldTypeInteger, alias: DOCLINK, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_LOC (type: esriFieldTypeDouble, alias: GPS_LOC, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• REPLACEDATE (type: esriFieldTypeDate, alias: REPLACEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GPS_RIMELEVATION (type: esriFieldTypeDouble, alias: GPS_RIMELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_DEPTH (type: esriFieldTypeDouble, alias: GPS_DEPTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• R_R_PROJECT (type: esriFieldTypeString, alias: R_R_PROJECT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• R_R_REF (type: esriFieldTypeString, alias: R_R_REF, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• R_R_PROP (type: esriFieldTypeString, alias: R_R_PROP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• REHABILITATION_DATE (type: esriFieldTypeDate, alias: REHABILITATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AssetID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MiniBasinID (type: esriFieldTypeString, alias: MiniBasinID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Drawings (type: esriFieldTypeString, alias: Drawings, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• NAME2 (type: esriFieldTypeString, alias: NAME2, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• NEAR_DIST (type: esriFieldTypeDouble, alias: NEAR_DIST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Waterway_Name (type: esriFieldTypeString, alias: Waterway_Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Waterway_IDN (type: esriFieldTypeString, alias: Waterway_IDN, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ServiceLife (type: esriFieldTypeSmallInteger, alias: Service Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COF (type: esriFieldTypeSmallInteger, alias: Consequence of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 10])
• POF (type: esriFieldTypeSmallInteger, alias: Probability of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 10])
• BRE (type: esriFieldTypeSmallInteger, alias: Business Risk Exposure, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 99])
• AssetCost (type: esriFieldTypeDouble, alias: Asset Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• PurchaseDate (type: esriFieldTypeDate, alias: PurchaseDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Waterway_USE (type: esriFieldTypeString, alias: Waterway_USE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [A&I: A&I], [F&W: F&W], [OAW/F&W: OAW/F&W], ... 6 more ...)
• Water_Receiving_ID (type: esriFieldTypeString, alias: Water_Receiving_ID, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InstallDateSource (type: esriFieldTypeString, alias: InstallDateSource, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [As-built Drawing: As-built Drawing], [Avg Parcel Yr Built: Avg Parcel Yr Built])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: SManhole
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ANCILLARYROLE: 0
• ENABLED: 1
• LIFECYCLESTATUS: PRP
• SUBTYPE: 3
• WATERTYPE: Sewage
• BELOWGRADE: 0
• ACCESSTYPE: Cover
• OWNERTYPE: CNT
• FLOWMONITORINDICATOR: 0
• PVT_TREATMENT: N
• GPS_LOC: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/27/2024 3:55:29 AM

Schema Last Edit Date: 3/27/2024 3:55:29 AM

Data Last Edit Date: 3/27/2024 3:55:20 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat