View In:   ArcGIS Online Map Viewer

Name: Sanitary Structures

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: a23807ee507749978c1ae9c148381397

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 1049412.055850912
YMin: 1873836.4728274047
XMax: 1056326.5630192459
YMax: 1876520.426120907
Spatial Reference: 102671  (3435)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [56, 168, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true
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 Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• mhno ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: MHNo, alias: MHNo )
• rim ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: Rim, alias: Rim )
• location ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: Location, alias: Location )
• mhsize ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: MHSize, alias: MHSize )
• frame ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Frame, alias: Frame )
• cover ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Cover, alias: Cover , Coded Values: [Typical: Typical] , [Grate: Grate] , [Beehive: Beehive] , ...4 more... )
• material ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Material, alias: Material , Coded Values: [Precast: Precast] , [Poured: Poured] , [Brick: Brick] , ...3 more... )
• depth ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: Depth, alias: Depth )
• spraylined ( nullable: true, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: SprayLined, alias: SprayLined )
• yearinstalled ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: YearInstalled, alias: YearInstalled )
• basinid ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: BasinID, alias: BasinID )
• status ( nullable: true, editable: true, defaultValue: Active, length: 50, type: esriFieldTypeString, modelName: Status, alias: Status )
• private ( nullable: true, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: Private, alias: Private )
• structuretype ( nullable: true, editable: true, defaultValue: Manhole, length: 50, type: esriFieldTypeString, modelName: Notes, alias: StructureType , Coded Values: [Air Release: Air Release] , [Cleanout: Cleanout] , [Junction Chamber: Junction Chamber] , ...9 more... )
• address ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: StructureType, alias: Address )
• streetname ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: UID, alias: StreetName )
• source ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Notes, alias: Source )
• sourcedate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: UID, alias: SourceDate )
• notes ( nullable: true, editable: true, defaultValue: null, length: 2147483647, type: esriFieldTypeString, modelName: Notes, alias: Notes )
• uid ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: UID, alias: UID )
• ringmaterial ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: RingMaterial, alias: RingMaterial , Coded Values: [Precast: Precast] , [Poured: Poured] , [Brick: Brick] , ...3 more... )
• chimneymaterial ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: ChimneyMaterial, alias: ChimneyMaterial , Coded Values: [Precast: Precast] , [Poured: Poured] , [Brick: Brick] , ...3 more... )
• conematerial ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: ConeMaterial, alias: ConeMaterial , Coded Values: [Precast: Precast] , [Poured: Poured] , [Brick: Brick] , ...3 more... )
• barrelmaterial ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: BarrelMaterial, alias: BarrelMaterial , Coded Values: [Precast: Precast] , [Poured: Poured] , [Brick: Brick] , ...3 more... )
• editdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: EditDate, alias: EditDate )
• userid ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: UserID, alias: UserID )
• old_mhno ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Old_MHNo, alias: Old_MH )
• p1_angle ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P1_Angle, alias: P1_Angle , Coded Values: [1: 1] , [1.5: 1.5] , [2: 2] , ...23 more... )
• p1_size ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: P1_Size, alias: P1_Size , Coded Values: [PVC: PVC] , [HDPE: HDPE] , [Lined Clay: Lined Clay] , ...8 more... )
• pipe2 ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Pipe2, alias: Pipe2 , Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more... )
• p2_inv ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P2_INV, alias: P2_INV )
• p2_angle ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P2_Angle, alias: P2_Angle , Coded Values: [1: 1] , [1.5: 1.5] , [2: 2] , ...23 more... )
• p2_size ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: P2_Size, alias: P2_Size , Coded Values: [PVC: PVC] , [HDPE: HDPE] , [Lined Clay: Lined Clay] , ...8 more... )
• pipe3 ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Pipe3, alias: Pipe3 , Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more... )
• p3_inv ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P3_INV, alias: P3_INV )
• p3_angle ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P3_Angle, alias: P3_Angle , Coded Values: [1: 1] , [1.5: 1.5] , [2: 2] , ...23 more... )
• p3_size ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: P3_Size, alias: P3_Size , Coded Values: [PVC: PVC] , [HDPE: HDPE] , [Lined Clay: Lined Clay] , ...8 more... )
• pipe4 ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Pipe4, alias: Pipe4 , Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more... )
• p4_inv ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P4_INV, alias: P4_INV )
• p4_angle ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P4_Angle, alias: P4_Angle , Coded Values: [1: 1] , [1.5: 1.5] , [2: 2] , ...23 more... )
• p4_size ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: P4_Size, alias: P4_Size , Coded Values: [PVC: PVC] , [HDPE: HDPE] , [Lined Clay: Lined Clay] , ...8 more... )
• pipe5 ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Pipe5, alias: Pipe5 , Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more... )
• p5_inv ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P5_INV, alias: P5_INV )
• p5_angle ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P5_Angle, alias: P5_Angle , Coded Values: [1: 1] , [1.5: 1.5] , [2: 2] , ...23 more... )
• p5_size ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: P5_Size, alias: P5_Size , Coded Values: [PVC: PVC] , [HDPE: HDPE] , [Lined Clay: Lined Clay] , ...8 more... )
• pipe6 ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Pipe6, alias: Pipe6 , Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more... )
• p6_inv ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P6_INV, alias: P6_INV )
• p6_angle ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P6_Angle, alias: P6_Angle , Coded Values: [1: 1] , [1.5: 1.5] , [2: 2] , ...23 more... )
• p6_size ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: P6_Size, alias: P6_Size , Coded Values: [PVC: PVC] , [HDPE: HDPE] , [Lined Clay: Lined Clay] , ...8 more... )
• pipe7 ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Pipe7, alias: Pipe7 , Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more... )
• p7_inv ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P7_INV, alias: P7_INV )
• p7_angle ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P7_Angle, alias: P7_Angle , Coded Values: [1: 1] , [1.5: 1.5] , [2: 2] , ...23 more... )
• p7_size ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: P7_Size, alias: P7_Size , Coded Values: [PVC: PVC] , [HDPE: HDPE] , [Lined Clay: Lined Clay] , ...8 more... )
• pipe8 ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Pipe8, alias: Pipe8 , Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more... )
• p8_inv ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P8_INV, alias: P8_INV )
• p8_angle ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: P8_Angle, alias: P8_Angle , Coded Values: [1: 1] , [1.5: 1.5] , [2: 2] , ...23 more... )
• structureno ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: StructureNo, alias: StructureNo )
• comment ( nullable: true, editable: true, defaultValue: null, length: 32, type: esriFieldTypeString, modelName: Comment, alias: Comment )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: globalid )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Templates:

• Name: Sanitary Structures
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

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:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata