Name: Force_Main

Display Field: SUBDIVISION_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This geospatial layer is a polyline feature class that contains information about the location and attributes of more than 320 miles of force mains of the City of Houston’s wastewater collection system. According to the City's Infrastructure Design Manual, a force main is a pressure-rated conduit which conveys wastewater from one pump station to one discharge point. This feature class includes force and sludge.The GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset within a Relational Database Management System (RDBMS). The data are derived from Plan and Profile Engineering drawings obtained from Block Map, As Built, Field Book, Taps and Meters, Metro, Autocad Data from GHW Project, Wastewater Reconciliation Project, Other Source (Operator Input), FVFL, FVFD, Field Verified with Control Number, and Construction Layer.From GIMS Planning Database 09/28/2020

Copyright Text: City of Houston, Houston Public Works, Houston Water, GIS Services

Min. Scale: 80000

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 3018756.74706346
YMin: 13757369.9532805
XMax: 3211897.44956368
YMax: 13963263.3334796
Spatial Reference: 102740 (2278)

Drawing Info:

{"renderer":{"type":"classBreaks","field":"DIAMETER","classificationMethod":"esriClassifyNaturalBreaks","minValue":0,"classBreakInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,38,0,255],"width":1},"classMaxValue":6,"label":"0 - 6","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,38,0,255],"width":1},"classMaxValue":12,"label":"7 - 12","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,0,0,255],"width":1},"classMaxValue":21,"label":"13 - 21","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,38,0,255],"width":1},"classMaxValue":30,"label":"22 - 30","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,38,0,255],"width":1},"classMaxValue":60,"label":"31 - 60","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])
• CREATIONUSER (type: esriFieldTypeString, alias: Employee Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• DATECREATED (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATEMODIFIED (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTUSER (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UFID (type: esriFieldTypeInteger, alias: UFID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CONDITIONDATE (type: esriFieldTypeDate, alias: Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• QCVERIFIED (type: esriFieldTypeInteger, alias: QC Verified, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• FIELDVERIFYNUM (type: esriFieldTypeInteger, alias: Field Verified Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSERVICEDATE (type: esriFieldTypeDate, alias: In Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PLANDATE (type: esriFieldTypeDate, alias: Plan Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REHABCOMPLETIONDATE (type: esriFieldTypeDate, alias: Rehab Completion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MOTIONDATE (type: esriFieldTypeDate, alias: Motion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PERMITDATE (type: esriFieldTypeDate, alias: Permit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SUBTYPECD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [BRK: Clay or Concrete Brick], [CGMP: Corrugated Metal Pipe], [CI: Cast Iron], ... 26 more ...)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [E: Features Being Used and Maintained], [P: Proposed], [A: Abandoned], ... 1 more ...)
• MEASUREDLENGTH (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LENGTHSOURCE (type: esriFieldTypeString, alias: Length Source, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [FM: Field Measurement], [MS: Mapping System], [USER: User-Derived], ... 1 more ...)
• WASTEWATERTRACEWEIGHT (type: esriFieldTypeInteger, alias: Wastewater Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISTANCETODOWNSTREAMMANHOLE (type: esriFieldTypeString, alias: Distance To Downstream Manhole, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• STUBLENGTH (type: esriFieldTypeInteger, alias: Stub Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SIZE2 (type: esriFieldTypeInteger, alias: Size 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeInteger, alias: Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: 2"], [3: 3"], [4: 4"], ... 41 more ...)
• UPSTREAMINVERT (type: esriFieldTypeDouble, alias: Upstream Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOWNSTREAMINVERT (type: esriFieldTypeDouble, alias: Downstream Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERCENTSLOPE (type: esriFieldTypeDouble, alias: Percent Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GROUNDCOVER (type: esriFieldTypeDouble, alias: Ground Cover, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• SUBDIVISION_NAME (type: esriFieldTypeString, alias: Subdivision Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FISCAL_YEAR (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [FY10: FY10], [FY11: FY11], [FY12: FY12], ... 38 more ...)
• LIFTSTATION_NUM (type: esriFieldTypeString, alias: Lift Station Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LS_DIRECTION (type: esriFieldTypeString, alias: Lift Station Direction, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [N: North], [S: South], [E: East], ... 2 more ...)
• NOTES2 (type: esriFieldTypeString, alias: Notes 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COMPKEY (type: esriFieldTypeInteger, alias: COMPKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• KEYMAP (type: esriFieldTypeString, alias: Key Map, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• COUNCILDISTRICT (type: esriFieldTypeString, alias: Council District, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 8 more ...)
• ZONE (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [GNEHSA: GNEHSA], [IAH: IAH], [NE: NE], ... 3 more ...)
• IPSSUBTYPE (type: esriFieldTypeString, alias: IPSSUBTYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• IPSFACILITYID (type: esriFieldTypeString, alias: IPSFACILITYID, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DATUM (type: esriFieldTypeString, alias: Datum, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [COHnnnn: City of Houston], [CORPnnnn: U.S. Army Corps of Engrs], [HCFnnnn: Harris County Flood Control], ... 4 more ...)
• OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [C: City Owned/Maintained], [P: Privately Owned & Maintained], [CP: City Own & Privately Maintained], ... 1 more ...)
• PIPESHAPE (type: esriFieldTypeString, alias: Pipe Shape, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [RND: Round], [ARCH: Arch], [BOX: Box], ... 1 more ...)
• PLANNUMBER (type: esriFieldTypeString, alias: Plan Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• REHABPLANNUMBER (type: esriFieldTypeString, alias: Rehab Plan Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ILMSNUMBER (type: esriFieldTypeString, alias: ILMS Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• COSTPERACRE (type: esriFieldTypeString, alias: Cost Per Acre, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CREATIONSOURCE (type: esriFieldTypeString, alias: Financial Assets, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CIP: CAPITAL IMPROVEMENT PROJECT], [COMMERCIAL: COMMERCIAL], [DPC: DEVELOPER PARTICIPATION CONTRACTOR], ... 2 more ...)
• DATASOURCETYPE (type: esriFieldTypeString, alias: Data Source Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [BM: Block Map], [P: Plan and Profile], [AB: As Built], ... 11 more ...)
• MOTIONNUMBER (type: esriFieldTypeString, alias: Motion Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PCSNUMBER (type: esriFieldTypeString, alias: PCS Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PERMITNUMBER (type: esriFieldTypeString, alias: Permit Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PLANTYPE (type: esriFieldTypeString, alias: Plan Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [P: Plan and Profile], [R: Rehabilitation Drawing], [RP: Proposed Rehabilitation Drawing], ... 3 more ...)
• REHABMATERIAL (type: esriFieldTypeString, alias: Rehab Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PVC: Polyvinyl Chloride], [CIPP: Cured in Place Pipe], [PEP: Polyethylene Pipe], ... 2 more ...)
• SOURCEOFFUND (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• WCRNUMBER (type: esriFieldTypeString, alias: WCR Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PROJECTNUMBER (type: esriFieldTypeString, alias: File Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• REHABPROJECTNUMBER (type: esriFieldTypeString, alias: Rehab Project Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• DOWNSTREAMMANHOLENUMBER (type: esriFieldTypeString, alias: Downstream Manhole Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• UPSTREAMMANHOLENUMBER (type: esriFieldTypeString, alias: Upstream Manhole Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• PROJECTTYPE (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [JOB: City Job], [WW: Waste Water], [GFS: Government Financial System], ... 7 more ...)
• REHABMETHOD (type: esriFieldTypeString, alias: Rehab Method, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [CIPP: Cured in Place], [FLDF: Fold and Form], [BRST: Pipe Burst], ... 4 more ...)
• DATUM_YEAR (type: esriFieldTypeString, alias: Datum Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LAND_BASE_REVIEWED (type: esriFieldTypeString, alias: Land Base Reviewed, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• GFSORWBS (type: esriFieldTypeString, alias: GFS-WBS Number, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [GFS: Government Financial System], [WBS: Work Business Structure])
• GFSWBSNUMBER (type: esriFieldTypeString, alias: PROJECTNUMBER2, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• LENGTH (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDRESS_ID (type: esriFieldTypeDouble, alias: ADDRESS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MODELINGUSINVERTLEVEL (type: esriFieldTypeDouble, alias: U/S Pipe Invert Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MODELINGUSINVERTFLAGDESC (type: esriFieldTypeString, alias: Flag for U/S Pipe Invert Elevation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MODELINGDSINVERTLEVEL (type: esriFieldTypeDouble, alias: D/S Pipe Invert Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MODELINGDSINVERTFLAGDESC (type: esriFieldTypeString, alias: Flag for D/S Pipe Invert Elevation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UNITID2 (type: esriFieldTypeString, alias: Unit ID 2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MAINCOMP1 (type: esriFieldTypeSmallInteger, alias: Main Comp 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINCOMP2 (type: esriFieldTypeSmallInteger, alias: Main Comp 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMPTYPE (type: esriFieldTypeSmallInteger, alias: COMPTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PARLINENO (type: esriFieldTypeString, alias: PARLINENO, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• UNITID (type: esriFieldTypeString, alias: UNITID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• REPLACEMENTYR (type: esriFieldTypeString, alias: Replacement Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [2010: 2010], [2011: 2011], [2012: 2012], ... 18 more ...)
• QCDATE (type: esriFieldTypeDate, alias: QC Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Force_Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• SUBTYPECD: 1
• MATERIAL: PVC
• LIFECYCLESTATUS: E
• MEASUREDLENGTH: 0
• LENGTHSOURCE: MS
• DIAMETER: 12

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/21/2020 3:35:12 PM

Schema Last Edit Date: 10/21/2020 3:35:12 PM

Data Last Edit Date: 10/21/2020 3:35:12 PM

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