View In:   ArcGIS Online Map Viewer

Parent Layer: StormSewerNetwork

Name: Stormwater - Inlets

Display Field: cFacilityID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 2c96c38ba295499e82f7d52b783ede50

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 4800.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: 1855562.3782584392
YMin: 724144.5560907737
XMax: 1881343.509848967
YMax: 749353.8121846383
Spatial Reference: 102723  (3735)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ASSETTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: Unknown
  Description: N/A
  Symbol:
  
• Value: 1
  Label: Curb Inlet
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Catch Basin
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Pipe Inlet
  Description: N/A
  Symbol:
  
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
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: ASSETTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• cFacilityID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cFacilityID )
• cLegacyID ( type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cLegacyID )
• Address ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 130, defaultValue: null, modelName: Address )
• Location ( type: esriFieldTypeString, alias: Location Details, editable: true, nullable: true, length: 256, defaultValue: null, modelName: Location )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate )
• cWarranty ( type: esriFieldTypeString, alias: Warranty Information, editable: true, nullable: true, length: 256, defaultValue: null, modelName: cWarranty )
• cWarrantyResponsible ( type: esriFieldTypeString, alias: Warranty Responsible, editable: true, nullable: true, length: 20, defaultValue: null, modelName: cWarrantyResponsible )
• cStatus ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cStatus , Coded Values: [INSERV: In Service] , [OOSERV: Out of Service] , [DISPOSE: Disposed/Removed] , ...2 more... )
• cAssetCost ( type: esriFieldTypeDouble, alias: Asset Cost, editable: true, nullable: true, defaultValue: null, modelName: cAssetCost )
• cCondition ( type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: cCondition , Coded Values: [1: Excellent] , [2: Good] , [3: Fair] , ...1 more... )
• cConditionDate ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cConditionDate )
• cLifeExpectancy ( type: esriFieldTypeSmallInteger, alias: Life Expectancy in Yrs, editable: true, nullable: true, defaultValue: null, modelName: cLifeExpectancy )
• cCOF ( type: esriFieldTypeSmallInteger, alias: Consequence of Failure, editable: true, nullable: true, defaultValue: null, modelName: cCOF )
• cPOF ( type: esriFieldTypeSmallInteger, alias: Probability of Failure, editable: true, nullable: true, defaultValue: null, modelName: cPOF )
• cBRE ( type: esriFieldTypeSmallInteger, alias: Business Risk Exposure, editable: true, nullable: true, defaultValue: null, modelName: cBRE )
• cHazard ( type: esriFieldTypeString, alias: Hazard?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: cHazard )
• cComments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cComments )
• Size_ ( type: esriFieldTypeSmallInteger, alias: Inlet Size, editable: true, nullable: true, defaultValue: null, modelName: Size_ )
• Casting ( type: esriFieldTypeString, alias: Casting, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Casting , Coded Values: [R-3405: R-3405] )
• Type ( type: esriFieldTypeSmallInteger, alias: Inlet Type, editable: true, nullable: true, defaultValue: null, modelName: Type , Coded Values: [1: Catch Basin] , [2: Curb Inlet] , [3: Pipe Inlet] , ...1 more... )
• TC ( type: esriFieldTypeDouble, alias: Top of Casting, editable: true, nullable: true, defaultValue: null, modelName: TC , Range: [500, 1500] )
• Inv_Elev ( type: esriFieldTypeDouble, alias: Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: Inv_Elev , Range: [500, 1500] )
• Trash_Rk ( type: esriFieldTypeString, alias: Trash Rack, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Trash_Rk , Coded Values: [Yes: Yes] , [No: No] )
• Class ( type: esriFieldTypeString, alias: Class, editable: true, nullable: true, length: 50, defaultValue: IN, modelName: Class , Coded Values: [BH: Bulkhead] , [BA: Basin] , [IN: Inlet] , ...6 more... )
• Source ( type: esriFieldTypeString, alias: Data Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Source , Coded Values: [FC: Field Collected] , [SI: Scanned Image] , [SIBB: Scanned Image - Blue Binder] , ...5 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 50, defaultValue: COG, modelName: Owner , Coded Values: [AEP: AEP] , [ARC: Archive] , [COG: City of Gahanna] , ...7 more... )
• diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter )
• permitid ( type: esriFieldTypeString, alias: Permit ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: permitid )
• material ( type: esriFieldTypeSmallInteger, alias: Material, editable: true, nullable: true, defaultValue: null, modelName: material )
• wingwall ( type: esriFieldTypeSmallInteger, alias: Wingwall, editable: true, nullable: true, defaultValue: null, modelName: wingwall )
• surfacewater ( type: esriFieldTypeSmallInteger, alias: Receives Surface Water, editable: true, nullable: true, defaultValue: null, modelName: surfacewater )
• exitsystem ( type: esriFieldTypeSmallInteger, alias: Water Exiting System, editable: true, nullable: true, defaultValue: null, modelName: exitsystem )
• designtype ( type: esriFieldTypeSmallInteger, alias: Type, editable: true, nullable: true, defaultValue: null, modelName: designtype )
• length2 ( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: length2 )
• width ( type: esriFieldTypeDouble, alias: Width, editable: true, nullable: true, defaultValue: null, modelName: width )
• depth ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: depth )
• inletcount ( type: esriFieldTypeSmallInteger, alias: Number of Inlets, editable: true, nullable: true, defaultValue: null, modelName: inletcount )
• outletcount ( type: esriFieldTypeSmallInteger, alias: Number of Outlets, editable: true, nullable: true, defaultValue: null, modelName: outletcount )
• volume ( type: esriFieldTypeDouble, alias: Storage Volume, editable: true, nullable: true, defaultValue: null, modelName: volume )
• elevation ( type: esriFieldTypeSmallInteger, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: elevation )
• inletshape ( type: esriFieldTypeSmallInteger, alias: Inlet Shape, editable: true, nullable: true, defaultValue: null, modelName: inletshape )
• sump ( type: esriFieldTypeSmallInteger, alias: Sump, editable: true, nullable: true, defaultValue: null, modelName: sump )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: Asset type, editable: true, nullable: true, defaultValue: 0, modelName: ASSETTYPE )

Types:

ID: 0
Name: Unknown
Domains:
• cStatus:
  Inherited
• cCondition:
  Inherited
• Casting:
  Inherited
• Type:
  Inherited
• TC:
  Inherited
• Inv_Elev:
  Inherited
• Trash_Rk:
  Inherited
• Class:
  Inherited
• Source:
  Inherited
• Owner:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  sump: null
  inletshape: null
  cFacilityID: null
  cLegacyID: null
  Address: null
  Location: null
  InstallDate: null
  WarrantyDate: null
  cWarranty: null
  cWarrantyResponsible: null
  cStatus: null
  cAssetCost: null
  cCondition: null
  cConditionDate: null
  cLifeExpectancy: null
  cCOF: null
  cPOF: null
  cBRE: null
  cHazard: null
  cComments: null
  Size_: null
  Casting: null
  Type: 0
  TC: null
  Inv_Elev: null
  Trash_Rk: null
  Class: IN
  Source: null
  ASSETTYPE: 0
  elevation: null
  volume: null
  outletcount: null
  inletcount: null
  Owner: COG
  diameter: null
  permitid: null
  material: null
  wingwall: null
  surfacewater: null
  exitsystem: null
  designtype: null
  length2: null
  width: null
  depth: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: Curb Inlet
Domains:
• cStatus:
  Inherited
• cCondition:
  Inherited
• Casting:
  Inherited
• Type:
  Inherited
• TC:
  Inherited
• Inv_Elev:
  Inherited
• Trash_Rk:
  Inherited
• Class:
  Inherited
• Source:
  Inherited
• Owner:
  Inherited
Templates:
• Name: Curb Inlet
  Description:
  Prototype:
  sump: null
  inletshape: null
  cFacilityID: null
  cLegacyID: null
  Address: null
  Location: null
  InstallDate: null
  WarrantyDate: null
  cWarranty: null
  cWarrantyResponsible: null
  cStatus: null
  cAssetCost: null
  cCondition: null
  cConditionDate: null
  cLifeExpectancy: null
  cCOF: null
  cPOF: null
  cBRE: null
  cHazard: null
  cComments: null
  Size_: null
  Casting: null
  Type: null
  TC: null
  Inv_Elev: null
  Trash_Rk: null
  Class: null
  Source: null
  ASSETTYPE: 1
  elevation: null
  volume: null
  outletcount: null
  inletcount: null
  Owner: null
  diameter: null
  permitid: null
  material: null
  wingwall: null
  surfacewater: null
  exitsystem: null
  designtype: null
  length2: null
  width: null
  depth: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Catch Basin
Domains:
• cStatus:
  Inherited
• cCondition:
  Inherited
• Casting:
  Inherited
• Type:
  Inherited
• TC:
  Inherited
• Inv_Elev:
  Inherited
• Trash_Rk:
  Inherited
• Class:
  Inherited
• Source:
  Inherited
• Owner:
  Inherited
Templates:
• Name: Catch Basin
  Description:
  Prototype:
  sump: null
  inletshape: null
  cFacilityID: null
  cLegacyID: null
  Address: null
  Location: null
  InstallDate: null
  WarrantyDate: null
  cWarranty: null
  cWarrantyResponsible: null
  cStatus: null
  cAssetCost: null
  cCondition: null
  cConditionDate: null
  cLifeExpectancy: null
  cCOF: null
  cPOF: null
  cBRE: null
  cHazard: null
  cComments: null
  Size_: null
  Casting: null
  Type: null
  TC: null
  Inv_Elev: null
  Trash_Rk: null
  Class: null
  Source: null
  ASSETTYPE: 2
  elevation: null
  volume: null
  outletcount: null
  inletcount: null
  Owner: null
  diameter: null
  permitid: null
  material: null
  wingwall: null
  surfacewater: null
  exitsystem: null
  designtype: null
  length2: null
  width: null
  depth: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Pipe Inlet
Domains:
• cStatus:
  Inherited
• cCondition:
  Inherited
• Casting:
  Inherited
• Type:
  Inherited
• TC:
  Inherited
• Inv_Elev:
  Inherited
• Trash_Rk:
  Inherited
• Class:
  Inherited
• Source:
  Inherited
• Owner:
  Inherited
Templates:
• Name: Pipe Inlet
  Description:
  Prototype:
  sump: null
  inletshape: null
  cFacilityID: null
  cLegacyID: null
  Address: null
  Location: null
  InstallDate: null
  WarrantyDate: null
  cWarranty: null
  cWarrantyResponsible: null
  cStatus: null
  cAssetCost: null
  cCondition: null
  cConditionDate: null
  cLifeExpectancy: null
  cCOF: null
  cPOF: null
  cBRE: null
  cHazard: null
  cComments: null
  Size_: null
  Casting: null
  Type: null
  TC: null
  Inv_Elev: null
  Trash_Rk: null
  Class: null
  Source: null
  ASSETTYPE: 3
  elevation: null
  volume: null
  outletcount: null
  inletcount: null
  Owner: null
  diameter: null
  permitid: null
  material: null
  wingwall: null
  surfacewater: null
  exitsystem: null
  designtype: null
  length2: null
  width: null
  depth: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

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   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata