Name: SPressurizedMain

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: 2096536.2673
YMin: 1179685.6559
XMax: 2265005.46
YMax: 1387378.08
Spatial Reference: 102630 (102630)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[250,52,17,255],"width":1.7},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

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)
• 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)
• 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)
• 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)
• LEGACYID (type: esriFieldTypeString, alias: LEGACYID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• WARRANTYDATE (type: esriFieldTypeDate, alias: WARRANTYDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RECORDEDLENGTH (type: esriFieldTypeDouble, alias: RECORDEDLENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSTALLCONTRACTOR (type: esriFieldTypeString, alias: INSTALLCONTRACTOR, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• FLOWMEASUREMENTID (type: esriFieldTypeString, alias: FLOWMEASUREMENTID, SQL Type: sqlTypeOther, length: 20, 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 ...)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [RCON: Reinforced Concrete], [PVC: Poly Vinyl Chloride], [WD: Wood], ... 18 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 ...)
• EXTERIORCOATING (type: esriFieldTypeString, alias: ExteriorCoating, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other], [TAR: Tar])
• JOINTTYPE1 (type: esriFieldTypeString, alias: JointType1, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Flange: Flange], [Weld: Weld], [Bond: Bond], ... 2 more ...)
• JOINTTYPE2 (type: esriFieldTypeString, alias: JointType2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Flange: Flange], [Weld: Weld], [Bond: Bond], ... 2 more ...)
• LININGTYPE (type: esriFieldTypeString, alias: LiningType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other])
• PIPECLASS (type: esriFieldTypeString, alias: PipeClass, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other])
• ROUGHNESS (type: esriFieldTypeDouble, alias: ROUGHNESS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DEPTH (type: esriFieldTypeDouble, alias: DEPTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRESSURERATING (type: esriFieldTypeString, alias: PRESSURERATING, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• DESIGNFLOW (type: esriFieldTypeInteger, alias: DESIGNFLOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONDTION (type: esriFieldTypeString, alias: CONDTION, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CONDTIONDATE (type: esriFieldTypeDate, alias: CONDTIONDATE, 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 ...)
• RELIEFINDICATOR (type: esriFieldTypeInteger, alias: ReliefIndicator, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• AERIALINDICATOR (type: esriFieldTypeInteger, alias: AerialIndicator, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• RAD (type: esriFieldTypeDouble, alias: RAD, SQL Type: sqlTypeOther, 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)
• ALIAS_REF_NUMBER (type: esriFieldTypeString, alias: ALIAS_REF_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)
• TRUNK (type: esriFieldTypeString, alias: TRUNK, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• EFFLUENT (type: esriFieldTypeString, alias: EFFLUENT, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• PLUGGED (type: esriFieldTypeString, alias: PLUGGED, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• FACILITY_ID (type: esriFieldTypeString, alias: FACILITY_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeDouble, alias: DIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [6: 6 inch], [8: 8 inch], [10: 10 inch], ... 45 more ...)
• 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)
• REPLACEDATE (type: esriFieldTypeDate, alias: REPLACEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GPS_REF_NUMBER (type: esriFieldTypeString, alias: GPS_REF_NUMBER, SQL Type: sqlTypeOther, length: 50, 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)
• CONSENT_DECREE_BREAKOUT_WORK (type: esriFieldTypeString, alias: CONSENT_DECREE_BREAKOUT_WORK, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FLOWMEASUREMENTID1 (type: esriFieldTypeString, alias: FLOWMEASUREMENTID1, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• Model_Mannings_Capacity (type: esriFieldTypeDouble, alias: Model_Mannings_Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Model_DS_Flow (type: esriFieldTypeDouble, alias: Model_DS_Flow, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Model_maxsurchar (type: esriFieldTypeInteger, alias: Model_maxsurchar, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Model_Floodvol (type: esriFieldTypeDouble, alias: Model_Floodvol, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Model_Data_Date (type: esriFieldTypeDate, alias: Model_Data_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)
• 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: 12, 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)
• 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])
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: SPressurizedMain
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• LIFECYCLESTATUS: PRP
• SUBTYPE: 2
• WATERTYPE: Sewage
• MATERIAL: DUCTILE_IRON
• OWNERTYPE: CNT
• RELIEFINDICATOR: 0
• AERIALINDICATOR: 0
• PVT_TREATMENT: N
• DIAMETER: 6

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