Name: Wastewater Abandoned Line

Display Field: SUBDIVISION_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This geospatial layer contains information about abandoned wastewater lines, including gravity and force mains, service lead, and casing that are still on the ground but not in use within the City of Houston’s wastewater collection system.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.The GIS Services Group of Houston Water, Houston Public Works currently stores and maintains the dataset within a Relational Database Management System (RDBMS).

Definition Expression: N/A

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

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 10000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: true

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 3024830.456562981
YMin: 1.375741950736554E7
XMax: 3206167.703453794
YMax: 1.3958781370366082E7
Spatial Reference: 102740  (2278)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPECD
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 1
  Label: Force Main
  Description:
  Symbol:
  Style: esriSLSDash
  Color: [197, 0, 255, 255]
  Width: 1
• Value: 2
  Label: Sludge
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [132, 0, 168, 255]
  Width: 8
• Value: 8
  Label: Trunk
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [223, 115, 255, 255]
  Width: 8
• Value: 3
  Label: Collector
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [223, 115, 255, 255]
  Width: 8
• Value: 5
  Label: Siphon
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [223, 115, 255, 255]
  Width: 8
• Value: 10
  Label: Casing
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [197, 0, 255, 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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubtypeCD

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• CREATIONUSER ( type: esriFieldTypeString , alias: Employee Number , length: 20 )
• DATECREATED ( type: esriFieldTypeDate , alias: Date Created , length: 8 )
• DATEMODIFIED ( type: esriFieldTypeDate , alias: Date Modified , length: 8 )
• LASTUSER ( type: esriFieldTypeString , alias: Last User , length: 20 )
• FACILITYID ( type: esriFieldTypeString , alias: Facility ID , length: 50 )
• UFID ( type: esriFieldTypeInteger , alias: UFID )
• CONDITION ( type: esriFieldTypeString , alias: Condition , length: 20 )
• CONDITIONDATE ( type: esriFieldTypeDate , alias: Condition Date , length: 8 )
• NOTES ( type: esriFieldTypeString , alias: Notes , length: 255 )
• QCVERIFIED ( type: esriFieldTypeInteger , alias: QC Verified , Coded Values: [0: No] , [1: Yes] )
• FIELDVERIFYNUM ( type: esriFieldTypeInteger , alias: Field Verified Number )
• INSERVICEDATE ( type: esriFieldTypeDate , alias: In Service Date , length: 8 )
• PLANDATE ( type: esriFieldTypeDate , alias: Plan Date , length: 8 )
• REHABCOMPLETIONDATE ( type: esriFieldTypeDate , alias: Rehab Completion Date , length: 8 )
• MOTIONDATE ( type: esriFieldTypeDate , alias: Motion Date , length: 8 )
• PERMITDATE ( type: esriFieldTypeDate , alias: Permit Date , length: 8 )
• DISTANCETODOWNSTREAMMANHOLE ( type: esriFieldTypeDouble , alias: Distance To Downstream Manhole )
• SUBTYPECD ( type: esriFieldTypeInteger , alias: Subtype )
• LIFECYCLESTATUS ( type: esriFieldTypeString , alias: Lifecycle Status , length: 5 , Coded Values: [E: Features Being Used and Maintained] , [P: Proposed] , [A: Abandoned] , ...1 more... )
• MATERIAL ( type: esriFieldTypeString , alias: Material , length: 20 )
• DIAMETER ( type: esriFieldTypeInteger , alias: Size )
• PERCENTSLOPE ( type: esriFieldTypeDouble , alias: Percent Slope )
• UPSTREAMINVERT ( type: esriFieldTypeDouble , alias: Upstream Elevation )
• DOWNSTREAMINVERT ( type: esriFieldTypeDouble , alias: Down Stream Elevation )
• SIZE2 ( type: esriFieldTypeDouble , alias: Size 2 )
• STUBLENGTH ( type: esriFieldTypeInteger , alias: Stub Length )
• ENABLED ( type: esriFieldTypeSmallInteger , alias: Enabled , Coded Values: [0: False] , [1: True] )
• GLOBALID ( type: esriFieldTypeGlobalID , alias: GLOBALID , length: 38 )
• SUBDIVISION_NAME ( type: esriFieldTypeString , alias: Subdivision Name , length: 50 )
• LENGTHSOURCE ( type: esriFieldTypeString , alias: Length Source , length: 5 , Coded Values: [FM: Field Measurement] , [MS: Mapping System] , [USER: User-Derived] , ...1 more... )
• MEASUREDLENGTH ( type: esriFieldTypeDouble , alias: Measured Length )
• WASTEWATERTRACEWEIGHT ( type: esriFieldTypeDouble , alias: Wastewater Trace Weight )
• FISCAL_YEAR ( type: esriFieldTypeString , alias: Fiscal Year , length: 10 , Coded Values: [FY10: FY10] , [FY11: FY11] , [FY12: FY12] , ...38 more... )
• COMPKEY ( type: esriFieldTypeInteger , alias: COMPKEY )
• KEYMAP ( type: esriFieldTypeString , alias: Key Map , length: 14 )
• COUNCILDISTRICT ( type: esriFieldTypeString , alias: Council District , length: 10 , Coded Values: [A: A] , [B: B] , [C: C] , ...8 more... )
• ZONE ( type: esriFieldTypeString , alias: Zone , length: 10 , Coded Values: [GNEHSA: GNEHSA] , [IAH: IAH] , [NE: NE] , ...3 more... )
• IPSSUBTYPE ( type: esriFieldTypeString , alias: IPSSUBTYPE , length: 10 )
• IPSFACILITYID ( type: esriFieldTypeString , alias: IPSFACILITYID , length: 11 )
• GFSORWBS ( type: esriFieldTypeString , alias: GFSORWBS , length: 5 )
• GFSWBSNUMBER ( type: esriFieldTypeString , alias: GFSWBSNUMBER , length: 24 )
• ADDRESS ( type: esriFieldTypeString , alias: ADDRESS , length: 100 )
• DATUM ( type: esriFieldTypeString , alias: Datum , length: 10 , Coded Values: [COHnnnn: City of Houston] , [CORPnnnn: U.S. Army Corps of Engrs] , [HCFnnnn: Harris County Flood Control] , ...5 more... )
• OWNER ( type: esriFieldTypeString , alias: Owner , length: 10 , Coded Values: [C: City Owned/Maintained] , [P: Privately Owned & Maintained] , [CP: City Own & Privately Maintained] , ...1 more... )
• PIPESHAPE ( type: esriFieldTypeString , alias: Pipe Shape , length: 10 , Coded Values: [RND: Round] , [ARCH: Arch] , [BOX: Box] , ...1 more... )
• PLANNUMBER ( type: esriFieldTypeString , alias: Plan Number , length: 10 )
• REHABPLANNUMBER ( type: esriFieldTypeString , alias: Rehab Plan Number , length: 10 )
• ILMSNUMBER ( type: esriFieldTypeString , alias: ILMS Number , length: 15 )
• COSTPERACRE ( type: esriFieldTypeString , alias: Cost Per Acre , length: 20 )
• CREATIONSOURCE ( type: esriFieldTypeString , alias: Financial Assets , length: 20 , Coded Values: [CIP: CAPITAL IMPROVEMENT PROJECT] , [COMMERCIAL: COMMERCIAL] , [DPC: DEVELOPER PARTICIPATION CONTRACTOR] , ...2 more... )
• DATASOURCETYPE ( type: esriFieldTypeString , alias: Data Souce Type , length: 20 , Coded Values: [BM: Block Map] , [P: Plan and Profile] , [AB: As Built] , ...11 more... )
• MOTIONNUMBER ( type: esriFieldTypeString , alias: Motion Number , length: 20 )
• PERMITNUMBER ( type: esriFieldTypeString , alias: Permit Number , length: 20 )
• PLANTYPE ( type: esriFieldTypeString , alias: Plan Type , length: 20 , Coded Values: [P: Plan and Profile] , [R: Rehabilitation Drawing] , [RP: Proposed Rehabilitation Drawing] , ...3 more... )
• REHABMATERIAL ( type: esriFieldTypeString , alias: Rehab Material , length: 20 , Coded Values: [CONC: Concrete] , [FBGL: Fiberglass] , [RFBG: Reinforced Fiberglass] , ...3 more... )
• SOURCEOFFUND ( type: esriFieldTypeString , alias: Funding Source , length: 20 )
• WCRNUMBER ( type: esriFieldTypeString , alias: WCR Number , length: 20 )
• PROJECTNUMBER ( type: esriFieldTypeString , alias: File Number , length: 24 )
• REHABPROJECTNUMBER ( type: esriFieldTypeString , alias: Rehab Project Number , length: 24 )
• DOWNSTREAMMANHOLENUMBER ( type: esriFieldTypeString , alias: Downstream Manhole Number , length: 25 )
• UPSTREAMMANHOLENUMBER ( type: esriFieldTypeString , alias: Upstream Manhole Number , length: 25 )
• PROJECTTYPE ( type: esriFieldTypeString , alias: Project Type , length: 30 , Coded Values: [JOB: City Job] , [PN: Permit Number (Private Job)] , [WW: Waste Water] , ...4 more... )
• REHABMETHOD ( type: esriFieldTypeString , alias: Rehab Method , length: 35 , Coded Values: [ARC: Adjust Ring/Cover] , [AMH: Abandon MH] , [COAT: Coating] , ...11 more... )
• DATUM_YEAR ( type: esriFieldTypeString , alias: Datum Year , length: 4 )
• LAND_BASE_REVIEWED ( type: esriFieldTypeString , alias: Land Base Reviewed , length: 5 , Coded Values: [N: No] , [Y: Yes] )
• LENGTH ( type: esriFieldTypeDouble , alias: Length )
• ADDRESS_ID ( type: esriFieldTypeDouble , alias: ADDRESS_ID )
• UNITID2 ( type: esriFieldTypeString , alias: Unit ID 2 , length: 20 )
• MAINCOMP1 ( type: esriFieldTypeSmallInteger , alias: Main Comp 1 )
• MAINCOMP2 ( type: esriFieldTypeSmallInteger , alias: Main Comp 2 )
• COMPTYPE ( type: esriFieldTypeSmallInteger , alias: COMPTYPE )
• PARLINENO ( type: esriFieldTypeString , alias: PARLINENO , length: 2 )
• UNITID ( type: esriFieldTypeString , alias: UNITID , length: 20 )
• QCDATE ( type: esriFieldTypeDate , alias: QC Date , length: 8 )
• PSCNUMBER ( type: esriFieldTypeString , alias: PSC Number , length: 20 )
• COMMUNITYSEWERINDICATOR ( type: esriFieldTypeString , alias: Community Sewer Indicator , length: 5 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unk] )
• ABANDONMENTSOURCE ( type: esriFieldTypeString , alias: Abandonment Source , length: 50 )
• SHAPE ( type: esriFieldTypeGeometry , alias: Shape )
• SHAPE.STLength() ( type: esriFieldTypeDouble , alias: SHAPE.STLength() )

Types:

ID: 2
Name: Sludge
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ZONE:
  Inherited

---

ID: 1
Name: Force Main
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• FISCAL_YEAR:
  Coded Values:
• ZONE:
  Inherited

---

ID: 10
Name: Casing
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ZONE:
  Inherited

---

ID: 5
Name: Siphon
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ZONE:
  Inherited

---

ID: 8
Name: Trunk
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ZONE:
  Inherited

---

ID: 3
Name: Collector
Domains:
• QCVERIFIED:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• ENABLED:
  Inherited
• ZONE:
  Inherited

---

Supported Operations:   Query   Generate Renderer   Return Updates