View In:   ArcGIS Online Map Viewer

Name: Pipe_Filter

Display Field: Asset_Type

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 8000

Tile Max Record Count: 4000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 3137741.244541049
YMin: 1272833.3982093036
XMax: 3163261.2686321437
YMax: 1293732.6907282323
Spatial Reference: 2876  (2876)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [85, 255, 0, 255]
Width: 2
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: true

HasM: true

Has Attachments: true

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID_1 ( modelName: OBJECTID_1, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID_1, type: esriFieldTypeOID )
• Asset_Type ( modelName: Asset_Type, nullable: true, editable: true, defaultValue: 0, alias: Asset Type, type: esriFieldTypeSmallInteger , Coded Values: [4: Force Main] , [3: Gravity] , [5: Underground Storm] , ...2 more... )
• Asset_ID ( modelName: Asset_ID, nullable: true, editable: true, defaultValue: N/A, length: 64, alias: Asset ID, type: esriFieldTypeString )
• material ( modelName: material, nullable: true, editable: true, defaultValue: 0, alias: Material, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [2: Asbestos Cement - AC] , ...24 more... )
• diameter ( modelName: diameter, nullable: true, editable: true, defaultValue: 0, alias: Diameter, type: esriFieldTypeDouble , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...27 more... )
• Upstream_Elev ( modelName: Upstream_Elev, nullable: true, editable: true, defaultValue: N/A, alias: Upstream Elevation, type: esriFieldTypeDouble )
• Downstream_Elev ( modelName: Downstream_Elev, nullable: true, editable: true, defaultValue: N/A, alias: Downstream Elevation, type: esriFieldTypeDouble )
• slope ( modelName: slope, nullable: true, editable: true, defaultValue: N/A, alias: Slope, type: esriFieldTypeDouble )
• Install_Date ( modelName: Install_Date, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Install Date, type: esriFieldTypeDate )
• Lifecycle_Status ( modelName: Lifecycle_Status, nullable: true, editable: true, defaultValue: 0, alias: Lifecycle Status, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more... )
• Pipe_Shape ( modelName: Pipe_Shape, nullable: true, editable: true, defaultValue: 0, alias: Pipe Shape, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...5 more... )
• lined ( modelName: lined, nullable: true, editable: true, defaultValue: 0, alias: Lined?, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• Liner_Year ( modelName: Liner_Year, nullable: true, editable: true, defaultValue: N/A, alias: Liner Year, type: esriFieldTypeSmallInteger , Range: [2000, 2080] )
• Liner_Method ( modelName: Liner_Method, nullable: true, editable: true, defaultValue: 0, alias: Liner Method, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Cured In Place] , [2: Fold and Form or Deform/Reform] , ...11 more... )
• Owned_By ( modelName: Owned_By, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [2: Private] , [1: Town of Frederick] , [0: Other] )
• Maintained_By ( modelName: Maintained_By, nullable: true, editable: true, defaultValue: 1, alias: Maintained By, type: esriFieldTypeSmallInteger , Coded Values: [2: Private] , [1: Town of Frederick] , [0: Other] )
• notes ( modelName: notes, nullable: true, editable: true, defaultValue: N/A, length: 250, alias: Notes, type: esriFieldTypeString )
• globalid ( modelName: globalid, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: Global ID, type: esriFieldTypeGlobalID )
• OBJECTID ( modelName: OBJECTID, nullable: true, editable: true, defaultValue: N/A, alias: stPipeMainGeneralOID, type: esriFieldTypeInteger )
• LiningMethod ( modelName: LiningMethod, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: LiningMethod, type: esriFieldTypeString )
• Manufacturer ( modelName: Manufacturer, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Manufacturer, type: esriFieldTypeString )
• Material_1 ( modelName: Material_1, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Material, type: esriFieldTypeString )
• Shape_1 ( modelName: Shape_1, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Shape, type: esriFieldTypeString )
• UseType ( modelName: UseType, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: UseType, type: esriFieldTypeString )
• Diameter_1 ( modelName: Diameter_1, nullable: true, editable: true, defaultValue: N/A, alias: Diameter, type: esriFieldTypeDouble )
• Diameter_unit ( modelName: Diameter_unit, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: Diameter_unit, type: esriFieldTypeString )
• DownstreamElevation ( modelName: DownstreamElevation, nullable: true, editable: true, defaultValue: N/A, alias: DownstreamElevation, type: esriFieldTypeDouble )
• DownstreamElevation_unit ( modelName: DownstreamElevation_unit, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: DownstreamElevation_unit, type: esriFieldTypeString )
• Length ( modelName: Length, nullable: true, editable: true, defaultValue: N/A, alias: Length, type: esriFieldTypeDouble )
• Length_unit ( modelName: Length_unit, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: Length_unit, type: esriFieldTypeString )
• Slope_1 ( modelName: Slope_1, nullable: true, editable: true, defaultValue: N/A, alias: Slope, type: esriFieldTypeDouble )
• Slope_unit ( modelName: Slope_unit, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: Slope_unit, type: esriFieldTypeString )
• UpstreamElevation ( modelName: UpstreamElevation, nullable: true, editable: true, defaultValue: N/A, alias: UpstreamElevation, type: esriFieldTypeDouble )
• UpstreamElevation_unit ( modelName: UpstreamElevation_unit, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: UpstreamElevation_unit, type: esriFieldTypeString )
• Retired ( modelName: Retired, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Retired, type: esriFieldTypeDate )
• Replaced ( modelName: Replaced, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Replaced, type: esriFieldTypeDate )
• Installed ( modelName: Installed, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Installed, type: esriFieldTypeDate )
• CartegraphID ( modelName: CartegraphID, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: CartegraphID, type: esriFieldTypeString )
• TotalCost ( modelName: TotalCost, nullable: true, editable: true, defaultValue: N/A, alias: TotalCost, type: esriFieldTypeDouble )
• ConditionGroup ( modelName: ConditionGroup, nullable: true, editable: true, defaultValue: N/A, length: 150, alias: ConditionGroup, type: esriFieldTypeString )
• Jurisdiction ( modelName: Jurisdiction, nullable: true, editable: true, defaultValue: N/A, length: 35, alias: Jurisdiction, type: esriFieldTypeString )
• Notes_Cartograph ( modelName: Notes_Cartograph, nullable: true, editable: true, defaultValue: N/A, length: 500, alias: Notes, type: esriFieldTypeString )
• EstimatedOCI ( modelName: EstimatedOCI, nullable: true, editable: true, defaultValue: N/A, alias: EstimatedOCI, type: esriFieldTypeDouble )
• PredictionGroup ( modelName: PredictionGroup, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: PredictionGroup, type: esriFieldTypeString )
• LocationDescription ( modelName: LocationDescription, nullable: true, editable: true, defaultValue: N/A, length: 500, alias: LocationDescription, type: esriFieldTypeString )
• EstimatedOCR ( modelName: EstimatedOCR, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: EstimatedOCR, type: esriFieldTypeString )
• EstimatedCCR ( modelName: EstimatedCCR, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: EstimatedCCR, type: esriFieldTypeString )
• CriticalityFactor ( modelName: CriticalityFactor, nullable: true, editable: true, defaultValue: N/A, alias: CriticalityFactor, type: esriFieldTypeDouble )
• CurrentInspectionID ( modelName: CurrentInspectionID, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: CurrentInspectionID, type: esriFieldTypeString )
• EstimatedCCI ( modelName: EstimatedCCI, nullable: true, editable: true, defaultValue: N/A, alias: EstimatedCCI, type: esriFieldTypeDouble )
• ActBefore ( modelName: ActBefore, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: ActBefore, type: esriFieldTypeDate )
• County ( modelName: County, nullable: true, editable: true, defaultValue: N/A, length: 32, alias: County, type: esriFieldTypeString )
• Street ( modelName: Street, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Street, type: esriFieldTypeString )
• StateValue ( modelName: StateValue, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: StateValue, type: esriFieldTypeString )
• City ( modelName: City, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: City, type: esriFieldTypeString )
• DownstreamManhole ( modelName: DownstreamManhole, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: DownstreamManhole, type: esriFieldTypeString )
• UpstreamManhole ( modelName: UpstreamManhole, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: UpstreamManhole, type: esriFieldTypeString )
• DownstreamBasin ( modelName: DownstreamBasin, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: DownstreamBasin, type: esriFieldTypeString )
• UpstreamBasin ( modelName: UpstreamBasin, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: UpstreamBasin, type: esriFieldTypeString )
• DownstreamInlet ( modelName: DownstreamInlet, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: DownstreamInlet, type: esriFieldTypeString )
• UpstreamInlet ( modelName: UpstreamInlet, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: UpstreamInlet, type: esriFieldTypeString )
• CurrentInspectionDate ( modelName: CurrentInspectionDate, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: CurrentInspectionDate, type: esriFieldTypeDate )
• CurrentInspectionOCI ( modelName: CurrentInspectionOCI, nullable: true, editable: true, defaultValue: N/A, alias: CurrentInspectionOCI, type: esriFieldTypeDouble )
• CurrentInspectionOCR ( modelName: CurrentInspectionOCR, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: CurrentInspectionOCR, type: esriFieldTypeString )
• CurrentInspectionNotes ( modelName: CurrentInspectionNotes, nullable: true, editable: true, defaultValue: N/A, length: 500, alias: CurrentInspectionNotes, type: esriFieldTypeString )
• cgShape_Length ( modelName: cgShape_Length, nullable: true, editable: true, defaultValue: N/A, alias: cgShape_Length, type: esriFieldTypeDouble )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• Shape__Length ( modelName: Shape.STLength(), nullable: true, editable: false, defaultValue: N/A, alias: Shape.STLength(), type: esriFieldTypeDouble, required: true )

Templates:

• Name: Underground Storm
  Description:
  Prototype:
  notes: null
  Owned_By: 1
  Maintained_By: 1
  Length_unit: null
  Downstream_Elev: null
  EstimatedCCI: null
  OBJECTID: null
  TotalCost: null
  diameter: 0
  Install_Date: null
  cgShape_Length: null
  LocationDescription: null
  DownstreamElevation_unit: null
  EstimatedCCR: null
  Manufacturer: null
  DownstreamBasin: null
  Street: null
  UpstreamInlet: null
  EstimatedOCI: null
  UpstreamElevation_unit: null
  EstimatedOCR: null
  CurrentInspectionDate: null
  Retired: null
  Notes_Cartograph: null
  UseType: null
  LiningMethod: null
  CurrentInspectionOCR: null
  City: null
  slope: null
  Jurisdiction: null
  PredictionGroup: null
  CurrentInspectionOCI: null
  ActBefore: null
  Diameter_unit: null
  StateValue: null
  Slope_1: null
  Lifecycle_Status: 0
  Diameter_1: null
  CurrentInspectionID: null
  DownstreamInlet: null
  CartegraphID: null
  County: null
  DownstreamManhole: null
  lined: 0
  Upstream_Elev: null
  Material_1: null
  Shape_1: null
  Asset_Type: 5
  CriticalityFactor: null
  CurrentInspectionNotes: null
  Replaced: null
  UpstreamBasin: null
  Pipe_Shape: 0
  Slope_unit: null
  ConditionGroup: null
  Asset_ID: null
  UpstreamElevation: null
  material: 0
  Length: null
  Installed: null
  DownstreamElevation: null
  Liner_Method: 0
  Liner_Year: null
  UpstreamManhole: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Force Main
  Description:
  Prototype:
  notes: null
  Owned_By: 1
  Maintained_By: 1
  Length_unit: null
  Downstream_Elev: null
  EstimatedCCI: null
  OBJECTID: null
  TotalCost: null
  diameter: 0
  Install_Date: null
  cgShape_Length: null
  LocationDescription: null
  DownstreamElevation_unit: null
  EstimatedCCR: null
  Manufacturer: null
  DownstreamBasin: null
  Street: null
  UpstreamInlet: null
  EstimatedOCI: null
  UpstreamElevation_unit: null
  EstimatedOCR: null
  CurrentInspectionDate: null
  Retired: null
  Notes_Cartograph: null
  UseType: null
  LiningMethod: null
  CurrentInspectionOCR: null
  City: null
  slope: null
  Jurisdiction: null
  PredictionGroup: null
  CurrentInspectionOCI: null
  ActBefore: null
  Diameter_unit: null
  StateValue: null
  Slope_1: null
  Lifecycle_Status: 0
  Diameter_1: null
  CurrentInspectionID: null
  DownstreamInlet: null
  CartegraphID: null
  County: null
  DownstreamManhole: null
  lined: 0
  Upstream_Elev: null
  Material_1: null
  Shape_1: null
  Asset_Type: 4
  CriticalityFactor: null
  CurrentInspectionNotes: null
  Replaced: null
  UpstreamBasin: null
  Pipe_Shape: 0
  Slope_unit: null
  ConditionGroup: null
  Asset_ID: null
  UpstreamElevation: null
  material: 0
  Length: null
  Installed: null
  DownstreamElevation: null
  Liner_Method: 0
  Liner_Year: null
  UpstreamManhole: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Gravity
  Description:
  Prototype:
  notes: null
  Owned_By: 1
  Maintained_By: 1
  Length_unit: null
  Downstream_Elev: null
  EstimatedCCI: null
  OBJECTID: null
  TotalCost: null
  diameter: 0
  Install_Date: null
  cgShape_Length: null
  LocationDescription: null
  DownstreamElevation_unit: null
  EstimatedCCR: null
  Manufacturer: null
  DownstreamBasin: null
  Street: null
  UpstreamInlet: null
  EstimatedOCI: null
  UpstreamElevation_unit: null
  EstimatedOCR: null
  CurrentInspectionDate: null
  Retired: null
  Notes_Cartograph: null
  UseType: null
  LiningMethod: null
  CurrentInspectionOCR: null
  City: null
  slope: null
  Jurisdiction: null
  PredictionGroup: null
  CurrentInspectionOCI: null
  ActBefore: null
  Diameter_unit: null
  StateValue: null
  Slope_1: null
  Lifecycle_Status: 0
  Diameter_1: null
  CurrentInspectionID: null
  DownstreamInlet: null
  CartegraphID: null
  County: null
  DownstreamManhole: null
  lined: 0
  Upstream_Elev: null
  Material_1: null
  Shape_1: null
  Asset_Type: 3
  CriticalityFactor: null
  CurrentInspectionNotes: null
  Replaced: null
  UpstreamBasin: null
  Pipe_Shape: 0
  Slope_unit: null
  ConditionGroup: null
  Asset_ID: null
  UpstreamElevation: null
  material: 0
  Length: null
  Installed: null
  DownstreamElevation: null
  Liner_Method: 0
  Liner_Year: null
  UpstreamManhole: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Other
  Description:
  Prototype:
  notes: null
  Owned_By: 1
  Maintained_By: 1
  Length_unit: null
  Downstream_Elev: null
  EstimatedCCI: null
  OBJECTID: null
  TotalCost: null
  diameter: 0
  Install_Date: null
  cgShape_Length: null
  LocationDescription: null
  DownstreamElevation_unit: null
  EstimatedCCR: null
  Manufacturer: null
  DownstreamBasin: null
  Street: null
  UpstreamInlet: null
  EstimatedOCI: null
  UpstreamElevation_unit: null
  EstimatedOCR: null
  CurrentInspectionDate: null
  Retired: null
  Notes_Cartograph: null
  UseType: null
  LiningMethod: null
  CurrentInspectionOCR: null
  City: null
  slope: null
  Jurisdiction: null
  PredictionGroup: null
  CurrentInspectionOCI: null
  ActBefore: null
  Diameter_unit: null
  StateValue: null
  Slope_1: null
  Lifecycle_Status: 0
  Diameter_1: null
  CurrentInspectionID: null
  DownstreamInlet: null
  CartegraphID: null
  County: null
  DownstreamManhole: null
  lined: 0
  Upstream_Elev: null
  Material_1: null
  Shape_1: null
  Asset_Type: 0
  CriticalityFactor: null
  CurrentInspectionNotes: null
  Replaced: null
  UpstreamBasin: null
  Pipe_Shape: 0
  Slope_unit: null
  ConditionGroup: null
  Asset_ID: null
  UpstreamElevation: null
  material: 0
  Length: null
  Installed: null
  DownstreamElevation: null
  Liner_Method: 0
  Liner_Year: null
  UpstreamManhole: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Unknown
  Description:
  Prototype:
  notes: null
  Owned_By: 1
  Maintained_By: 1
  Length_unit: null
  Downstream_Elev: null
  EstimatedCCI: null
  OBJECTID: null
  TotalCost: null
  diameter: 0
  Install_Date: null
  cgShape_Length: null
  LocationDescription: null
  DownstreamElevation_unit: null
  EstimatedCCR: null
  Manufacturer: null
  DownstreamBasin: null
  Street: null
  UpstreamInlet: null
  EstimatedOCI: null
  UpstreamElevation_unit: null
  EstimatedOCR: null
  CurrentInspectionDate: null
  Retired: null
  Notes_Cartograph: null
  UseType: null
  LiningMethod: null
  CurrentInspectionOCR: null
  City: null
  slope: null
  Jurisdiction: null
  PredictionGroup: null
  CurrentInspectionOCI: null
  ActBefore: null
  Diameter_unit: null
  StateValue: null
  Slope_1: null
  Lifecycle_Status: 0
  Diameter_1: null
  CurrentInspectionID: null
  DownstreamInlet: null
  CartegraphID: null
  County: null
  DownstreamManhole: null
  lined: 0
  Upstream_Elev: null
  Material_1: null
  Shape_1: null
  Asset_Type: 100
  CriticalityFactor: null
  CurrentInspectionNotes: null
  Replaced: null
  UpstreamBasin: null
  Pipe_Shape: 0
  Slope_unit: null
  ConditionGroup: null
  Asset_ID: null
  UpstreamElevation: null
  material: 0
  Length: null
  Installed: null
  DownstreamElevation: null
  Liner_Method: 0
  Liner_Year: null
  UpstreamManhole: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata