Name: LongDistanceCleaning

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10647979.7832069
YMin: 3448929.54358495
XMax: -10593998.4562169
YMax: 3499973.74536717
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[165,83,183,255],"width":1}},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GravityMain_ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• GravityMain_CREATIONUSER (type: esriFieldTypeString, alias: Employee Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GravityMain_DATECREATED (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GravityMain_DATEMODIFIED (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GravityMain_LASTUSER (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GravityMain_FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GravityMain_UFID (type: esriFieldTypeInteger, alias: UFID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GravityMain_CONDITIONDATE (type: esriFieldTypeDate, alias: Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GravityMain_NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GravityMain_QCVERIFIED (type: esriFieldTypeInteger, alias: QC Verified, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• GravityMain_FIELDVERIFYNUM (type: esriFieldTypeInteger, alias: Field Verified Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_INSERVICEDATE (type: esriFieldTypeDate, alias: In Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GravityMain_PLANDATE (type: esriFieldTypeDate, alias: Plan Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GravityMain_REHABCOMPLETIONDATE (type: esriFieldTypeDate, alias: Rehab Completion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GravityMain_MOTIONDATE (type: esriFieldTypeDate, alias: Motion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GravityMain_PERMITDATE (type: esriFieldTypeDate, alias: Permit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GravityMain_SUBTYPECD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_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 ...)
• GravityMain_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 ...)
• GravityMain_MEASUREDLENGTH (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_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 ...)
• GravityMain_WASTEWATERTRACEWEIG (type: esriFieldTypeInteger, alias: Wastewater Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_DISTANCETODOWNSTREA (type: esriFieldTypeString, alias: Distance To Downstream Manhole, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GravityMain_STUBLENGTH (type: esriFieldTypeInteger, alias: Stub Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_SIZE2 (type: esriFieldTypeInteger, alias: Size 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_UPSTREAMINVERT (type: esriFieldTypeDouble, alias: Upstream Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_DOWNSTREAMINVERT (type: esriFieldTypeDouble, alias: Downstream Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_DIAMETER (type: esriFieldTypeInteger, alias: Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: 2"], [3: 3"], [4: 4"], ... 41 more ...)
• GravityMain_PERCENTSLOPE (type: esriFieldTypeDouble, alias: Percent Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_GLOBALID (type: esriFieldTypeGUID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GravityMain_SUBDIVISION_NAME (type: esriFieldTypeString, alias: Subdivision Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GravityMain_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 ...)
• GravityMain_RMD_DELIVERY (type: esriFieldTypeString, alias: RMD Delivery, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• GravityMain_PUMPLINE_NUMBER (type: esriFieldTypeString, alias: Pumpline Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• GravityMain_NOTES2 (type: esriFieldTypeString, alias: Notes 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GravityMain_VIDEOLINK (type: esriFieldTypeString, alias: Video Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GravityMain_BASELINESIZE (type: esriFieldTypeInteger, alias: Baseline Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: 2"], [3: 3"], [4: 4"], ... 41 more ...)
• GravityMain_BASELINEMATERIAL (type: esriFieldTypeString, alias: Baseline 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 ...)
• GravityMain_BASELINEAGE (type: esriFieldTypeDate, alias: Baseline Age, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GravityMain_BASELINENOTES (type: esriFieldTypeString, alias: Baseline Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GravityMain_COMPKEY (type: esriFieldTypeInteger, alias: COMPKEY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_CLEANTVDATE (type: esriFieldTypeDate, alias: Clean TV Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GravityMain_CLEANTVMETHOD (type: esriFieldTypeString, alias: Clean TV Method, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [CCTV: Clean & TV], [SNRTV: Sonar TV])
• GravityMain_KEYMAP (type: esriFieldTypeString, alias: Key Map, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• GravityMain_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 ...)
• GravityMain_ZONE (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [GNEHSA: GNEHSA], [IAH: IAH], [NE: NE], ... 3 more ...)
• GravityMain_TVREPORT (type: esriFieldTypeString, alias: TV Report, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GravityMain_MODELINGUSINVERTLEV (type: esriFieldTypeDouble, alias: U/S Pipe Invert Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_MODELINGUSINVERTFLA (type: esriFieldTypeString, alias: Flag for U/S Pipe Invert Elevation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GravityMain_MODELINGDSINVERTLEV (type: esriFieldTypeDouble, alias: D/S Pipe Invert Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_MODELINGDSINVERTFLA (type: esriFieldTypeString, alias: Flag for D/S Pipe Invert Elevation, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GravityMain_IPSSUBTYPE (type: esriFieldTypeString, alias: IPSSUBTYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• GravityMain_IPSFACILITYID (type: esriFieldTypeString, alias: IPSFACILITYID, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• GravityMain_ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• GravityMain_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], ... 5 more ...)
• GravityMain_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 ...)
• GravityMain_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 ...)
• GravityMain_PLANNUMBER (type: esriFieldTypeString, alias: Plan Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• GravityMain_REHABPLANNUMBER (type: esriFieldTypeString, alias: Rehab Plan Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• GravityMain_ILMSNUMBER (type: esriFieldTypeString, alias: ILMS Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• GravityMain_COSTPERACRE (type: esriFieldTypeString, alias: Cost Per Acre, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GravityMain_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 ...)
• GravityMain_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 ...)
• GravityMain_MOTIONNUMBER (type: esriFieldTypeString, alias: Motion Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GravityMain_PERMITNUMBER (type: esriFieldTypeString, alias: Permit Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GravityMain_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 ...)
• GravityMain_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 ...)
• GravityMain_SOURCEOFFUND (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PSC: Private Service Connection], [DNT: Do Not Tap])
• GravityMain_WCRNUMBER (type: esriFieldTypeString, alias: WCR Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GravityMain_CLEANTVPROJECTNUMBE (type: esriFieldTypeString, alias: Clean TV Project Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• GravityMain_PROJECTNUMBER (type: esriFieldTypeString, alias: File Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• GravityMain_REHABPROJECTNUMBER (type: esriFieldTypeString, alias: Rehab Project Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• GravityMain_DOWNSTREAMMANHOLENU (type: esriFieldTypeString, alias: Downstream Manhole Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• GravityMain_UPSTREAMMANHOLENUMB (type: esriFieldTypeString, alias: Upstream Manhole Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• GravityMain_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 ...)
• GravityMain_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 ...)
• GravityMain_DATUM_YEAR (type: esriFieldTypeString, alias: Datum Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• GravityMain_LAND_BASE_REVIEWED (type: esriFieldTypeString, alias: Land Base Reviewed, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• GravityMain_GFSORWBS (type: esriFieldTypeString, alias: GFS Or WBS, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [GFS: Government Financial System], [WBS: Work Business Structure])
• GravityMain_GFSWBSNUMBER (type: esriFieldTypeString, alias: GFS-WBS Number, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• GravityMain_ADDRESS_ID (type: esriFieldTypeDouble, alias: ADDRESS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_LENGTH (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_UNITID2 (type: esriFieldTypeString, alias: Unit ID 2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GravityMain_MAINCOMP1 (type: esriFieldTypeSmallInteger, alias: Main Comp 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_MAINCOMP2 (type: esriFieldTypeSmallInteger, alias: Main Comp 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_COMPTYPE (type: esriFieldTypeSmallInteger, alias: COMPTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_PARLINENO (type: esriFieldTypeString, alias: PARLINENO, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• GravityMain_UNITID (type: esriFieldTypeString, alias: UNITID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GravityMain_IMSWONUM (type: esriFieldTypeInteger, alias: IMS Work Order Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_REHABWBSNUMBER (type: esriFieldTypeString, alias: Rehab WBS Number, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• GravityMain_REHABDIAMETER (type: esriFieldTypeDouble, alias: Rehab Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: 2"], [3: 3"], [4: 4"], ... 40 more ...)
• GravityMain_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 ...)
• GravityMain_SECONDARYLENGTH (type: esriFieldTypeDouble, alias: Secondary Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GravityMain_SECONDARYMATERIAL (type: esriFieldTypeString, alias: Secondary 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 ...)
• GravityMain_QCDATE (type: esriFieldTypeDate, alias: QC Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GravityMain_PSCNUMBER (type: esriFieldTypeString, alias: PSC Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GravityMain_COMMUNITYSEWERINDIC (type: esriFieldTypeString, alias: Community Sewer Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unk: Unk])
• GravityMain_METERBASIN (type: esriFieldTypeString, alias: Meter Basin, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LDC_SDC_Exported_OBJECTID (type: esriFieldTypeInteger, alias: LDC_SDC_Exported.OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LDC_SDC_Exported_Inspection_Num (type: esriFieldTypeInteger, alias: Inspection Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LDC_SDC_Exported_CompletedDateT (type: esriFieldTypeDate, alias: CompletedDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LDC_SDC_Exported_AssetLength (type: esriFieldTypeInteger, alias: AssetLength, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LDC_SDC_Exported_Asset_AssetKey (type: esriFieldTypeInteger, alias: Asset.AssetKey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LDC_SDC_Exported_InitiatedDateT (type: esriFieldTypeDate, alias: InitiatedDateTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LDC_SDC_Exported_InspectionType (type: esriFieldTypeString, alias: InspectionType.Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• GravityMain_ENABLED: 1
• GravityMain_SUBTYPECD: 3
• GravityMain_MATERIAL: PVC
• GravityMain_LIFECYCLESTATUS: E
• GravityMain_MEASUREDLENGTH: 0
• GravityMain_LENGTHSOURCE: MS
• GravityMain_DIAMETER: 12

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/11/2022 6:26:55 PM

Schema Last Edit Date: 2/11/2022 6:26:55 PM

Data Last Edit Date: 2/11/2022 6:26:55 PM

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