View In:   ArcGIS Online Map Viewer

Parent Layer: Stormwater Collection

Name: SW Inlet

Display Field: AncillaryRole

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: d5e7da2a1f864c3a86490afe2bc84ee3

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Effective Min Scale: 10000

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: -8629669.66730755
YMin: 4617673.573682835
XMax: -8621633.19437774
YMax: 4625208.157702498
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SubtypeCD
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Grate Inlet
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Curb Drop Inlet
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Bare Pipe In
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Headwall
  Description: N/A
  Symbol:
  
• Value: 6
  Label: Riser
  Description: N/A
  Symbol:
  
• Value: 7
  Label: Unknown
  Description: N/A
  Symbol:
  
• Value: 8
  Label: Other
  Description: N/A
  Symbol:
  
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 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: 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 Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubtypeCD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: 0, modelName: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• AsbuiltNumber ( type: esriFieldTypeString, alias: Asbuilt Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AsbuiltNumber )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• InstallYear ( type: esriFieldTypeString, alias: Install Year, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InstallYear )
• LifecycleStatus ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: LifecycleStatus , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...1 more... )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Owner , Coded Values: [CITY: City of Fredericksburg Owned] , [NON_CITY: Not City of Fredericksburg Owned] )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material , Coded Values: [PRECAST: Precast Concrete] , [OTHER: Other] , [UNK: Unknown] )
• SubtypeCD ( type: esriFieldTypeInteger, alias: SubtypeCD, editable: true, nullable: true, defaultValue: 2, modelName: SubtypeCD )
• InletDimension ( type: esriFieldTypeString, alias: Inlet Dimension, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InletDimension )
• RimElevation ( type: esriFieldTypeDouble, alias: Rim Elevation, editable: true, nullable: true, defaultValue: null, modelName: RimElevation )
• SumpElevation ( type: esriFieldTypeDouble, alias: Sump Elevation, editable: true, nullable: true, defaultValue: null, modelName: SumpElevation )
• SourceType ( type: esriFieldTypeString, alias: Source Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location_Status , Coded Values: [GEO_REF: Georeferenced] , [CAD: CAD] , [FRED_GPS: City of Fredericksburg GPS] , ...2 more... )
• SourceDoc1 ( type: esriFieldTypeString, alias: Source Document 1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceDoc1 )
• SourceDoc2 ( type: esriFieldTypeString, alias: Source Document 2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceDoc2 )
• SourceDoc3 ( type: esriFieldTypeString, alias: Source Document 3, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceDoc3 )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Comments )
• X_CRD ( type: esriFieldTypeDouble, alias: X_CRD, editable: true, nullable: true, defaultValue: null, modelName: X_CRD )
• Y_CRD ( type: esriFieldTypeDouble, alias: Y_CRD, editable: true, nullable: true, defaultValue: null, modelName: Y_CRD )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: 1
Name: Grate Inlet
Domains:
• AncillaryRole:
  Inherited
• Enabled:
  Inherited
• LifecycleStatus:
  Inherited
• Owner:
  Inherited
• Material:
  Inherited
• SourceType:
  Inherited
Templates:
• Name: Grate Inlet
  Description:
  Prototype:
  Material: null
  Y_CRD: null
  AncillaryRole: 0
  Enabled: 1
  AssetID: null
  AsbuiltNumber: null
  InstallDate: null
  InstallYear: null
  LifecycleStatus: Active
  Owner: null
  SubtypeCD: 1
  InletDimension: null
  RimElevation: null
  SumpElevation: null
  SourceType: null
  SourceDoc1: null
  SourceDoc2: null
  SourceDoc3: null
  Comments: null
  X_CRD: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Curb Drop Inlet
Domains:
• AncillaryRole:
  Inherited
• Enabled:
  Inherited
• LifecycleStatus:
  Inherited
• Owner:
  Inherited
• Material:
  Inherited
• SourceType:
  Inherited
Templates:
• Name: Curb Drop Inlet
  Description:
  Prototype:
  Material: null
  Y_CRD: null
  AncillaryRole: 0
  Enabled: 1
  AssetID: null
  AsbuiltNumber: null
  InstallDate: null
  InstallYear: null
  LifecycleStatus: Active
  Owner: null
  SubtypeCD: 2
  InletDimension: null
  RimElevation: null
  SumpElevation: null
  SourceType: null
  SourceDoc1: null
  SourceDoc2: null
  SourceDoc3: null
  Comments: null
  X_CRD: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Bare Pipe In
Domains:
• AncillaryRole:
  Inherited
• Enabled:
  Inherited
• LifecycleStatus:
  Inherited
• Owner:
  Inherited
• Material:
  Inherited
• SourceType:
  Inherited
Templates:
• Name: Bare Pipe In
  Description:
  Prototype:
  Material: null
  Y_CRD: null
  AncillaryRole: 0
  Enabled: 1
  AssetID: null
  AsbuiltNumber: null
  InstallDate: null
  InstallYear: null
  LifecycleStatus: Active
  Owner: null
  SubtypeCD: 4
  InletDimension: null
  RimElevation: null
  SumpElevation: null
  SourceType: null
  SourceDoc1: null
  SourceDoc2: null
  SourceDoc3: null
  Comments: null
  X_CRD: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Headwall
Domains:
• AncillaryRole:
  Inherited
• Enabled:
  Inherited
• LifecycleStatus:
  Inherited
• Owner:
  Inherited
• Material:
  Inherited
• SourceType:
  Inherited
Templates:
• Name: Headwall
  Description:
  Prototype:
  Material: null
  Y_CRD: null
  AncillaryRole: 0
  Enabled: 1
  AssetID: null
  AsbuiltNumber: null
  InstallDate: null
  InstallYear: null
  LifecycleStatus: Active
  Owner: null
  SubtypeCD: 5
  InletDimension: null
  RimElevation: null
  SumpElevation: null
  SourceType: null
  SourceDoc1: null
  SourceDoc2: null
  SourceDoc3: null
  Comments: null
  X_CRD: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: Riser
Domains:
• AncillaryRole:
  Inherited
• Enabled:
  Inherited
• LifecycleStatus:
  Inherited
• Owner:
  Inherited
• Material:
  Inherited
• SourceType:
  Inherited
Templates:
• Name: Riser
  Description:
  Prototype:
  Material: null
  Y_CRD: null
  AncillaryRole: 0
  Enabled: 1
  AssetID: null
  AsbuiltNumber: null
  InstallDate: null
  InstallYear: null
  LifecycleStatus: Active
  Owner: null
  SubtypeCD: 6
  InletDimension: null
  RimElevation: null
  SumpElevation: null
  SourceType: null
  SourceDoc1: null
  SourceDoc2: null
  SourceDoc3: null
  Comments: null
  X_CRD: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 7
Name: Unknown
Domains:
• AncillaryRole:
  Inherited
• Enabled:
  Inherited
• LifecycleStatus:
  Inherited
• Owner:
  Inherited
• Material:
  Inherited
• SourceType:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  Material: null
  Y_CRD: null
  AncillaryRole: 0
  Enabled: 1
  AssetID: null
  AsbuiltNumber: null
  InstallDate: null
  InstallYear: null
  LifecycleStatus: Active
  Owner: null
  SubtypeCD: 7
  InletDimension: null
  RimElevation: null
  SumpElevation: null
  SourceType: null
  SourceDoc1: null
  SourceDoc2: null
  SourceDoc3: null
  Comments: null
  X_CRD: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 8
Name: Other
Domains:
• AncillaryRole:
  Inherited
• Enabled:
  Inherited
• LifecycleStatus:
  Inherited
• Owner:
  Inherited
• Material:
  Inherited
• SourceType:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  Material: null
  Y_CRD: null
  AncillaryRole: 0
  Enabled: 1
  AssetID: null
  AsbuiltNumber: null
  InstallDate: null
  InstallYear: null
  LifecycleStatus: Active
  Owner: null
  SubtypeCD: 8
  InletDimension: null
  RimElevation: null
  SumpElevation: null
  SourceType: null
  SourceDoc1: null
  SourceDoc2: null
  SourceDoc3: null
  Comments: null
  X_CRD: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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 Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata