View In:   ArcGIS Online Map Viewer

Name: Storm Mains - State

Display Field: STATUS

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -9436473.2564
YMin: 4962092.380999997
XMax: -9087853.4721
YMax: 5120487.395800002
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [85, 255, 0, 255]
Width: 5
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: 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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 10, defaultValue: Active, modelName: STATUS , Coded Values: [Active: Active] , [Retired: Retired] , [Proposed: Proposed] )
• DIAMETER ( type: esriFieldTypeString, alias: Diameter, editable: true, nullable: true, length: 8, defaultValue: Unknown, modelName: DIAMETER , Coded Values: [02: 02] , [04: 04] , [06: 06] , ...18 more... )
• SHAPE_OF_PIPE ( type: esriFieldTypeString, alias: Shape Of Pipe, editable: true, nullable: true, length: 31, defaultValue: Unknown, modelName: SHAPE_OF_PIPE , Coded Values: [Circular: Circular] , [Elliptical-Horizontal: Elliptical-Horizontal] , [Elliptical-Vertical: Elliptical-Vertical] , ...2 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 52, defaultValue: Unknown, modelName: MATERIAL , Coded Values: [Clay: Clay] , [Concrete: Concrete] , [Cast Iron: Cast Iron] , ...7 more... )
• INSTALL_YEAR ( type: esriFieldTypeString, alias: Install Year, editable: true, nullable: true, length: 8, defaultValue: Unknown, modelName: INSTALL_YEAR )
• DATE_LAST_CLEANED ( type: esriFieldTypeDate, alias: Date Last Cleaned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_LAST_CLEANED )
• FLOW_DIRECTION ( type: esriFieldTypeString, alias: Flow Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: FLOW_DIRECTION , Coded Values: [N: North] , [S: South] , [E: East] , ...5 more... )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: COMMENT )
• REPLACE ( type: esriFieldTypeString, alias: Replace, editable: true, nullable: true, length: 8, defaultValue: Unknown, modelName: REPLACE , Coded Values: [Yes: Yes] , [Unknown: Unknown] )
• REPAIR ( type: esriFieldTypeString, alias: Repair, editable: true, nullable: true, length: 8, defaultValue: Unknown, modelName: REPAIR , Coded Values: [Yes: Yes] , [Unknown: Unknown] )
• MAINTENANCE_RESPONSIBILITY ( type: esriFieldTypeString, alias: Maintenance Responsibility, editable: true, nullable: true, length: 15, defaultValue: ODOT, modelName: MAINTENANCE_RESPONSIBILITY , Coded Values: [ODOT: ODOT] , [County: County] , [City: City] , ...4 more... )
• LET_PLANS_URL ( type: esriFieldTypeString, alias: URL, editable: true, nullable: true, length: 150, defaultValue: null, modelName: LET_PLANS_URL )
• STORM_MAIN_FILE_NUMBER ( type: esriFieldTypeString, alias: SMFN, editable: true, nullable: true, length: 11, defaultValue: null, modelName: STORM_MAIN_FILE_NUMBER )
• ODOT_DISTRICT ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ODOT_DISTRICT , Coded Values: [01: 01] , [02: 02] , [03: 03] , ...9 more... )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 10, defaultValue: null, modelName: COUNTY )
• ROUTE_TYPE ( type: esriFieldTypeString, alias: Route Type, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROUTE_TYPE )
• ROUTE_NBR ( type: esriFieldTypeString, alias: Route Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ROUTE_NBR )
• ROUTE_SUFFIX ( type: esriFieldTypeString, alias: Route Suffix, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ROUTE_SUFFIX )
• CTL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: CTL Begin Number, editable: true, nullable: true, defaultValue: null, modelName: CTL_BEGIN_NBR )
• CTL_END_NBR ( type: esriFieldTypeDouble, alias: CTL End Number, editable: true, nullable: true, defaultValue: null, modelName: CTL_END_NBR )
• STL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: STL Begin Number, editable: true, nullable: true, defaultValue: null, modelName: STL_BEGIN_NBR )
• STL_END_NBR ( type: esriFieldTypeDouble, alias: STL End Number, editable: true, nullable: true, defaultValue: null, modelName: STL_END_NBR )
• LATITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Latitude DD Begin, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE_DD_BEGIN )
• LONGITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Longitude DD Begin, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE_DD_BEGIN )
• 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 )
• FITTING_ON_TILE ( type: esriFieldTypeString, alias: Fitting on Tile, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FITTING_ON_TILE , Coded Values: [Tee: Tee] , [Pipe Guard: Pipe Guard (aminal guard)] )
• KNOWN_FLOW ( type: esriFieldTypeString, alias: Flow Direction Known, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: KNOWN_FLOW_1 , Coded Values: [Yes: Yes] , [Unknown: Unknown] )
• SOURCE ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: SOURCE_1 , Coded Values: [Field Verified: Field Verified] , [Plan Set: Plan Set] , [Survey Data: Survey Data] , ...2 more... )
• COUNTY_RESPON ( type: esriFieldTypeString, alias: County Responsible, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COUNTY_RESPON , Coded Values: [Fulton: Fulton] , [Henry: Henry] , [Lucas: Lucas] , ...7 more... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• INSPECT_VID_LINK ( type: esriFieldTypeString, alias: Inspection Video Link, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INSPECT_VID_LINK )
• VIDEO_DATE ( type: esriFieldTypeDate, alias: Video Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VIDEO_DATE )
• INSPECTION_LENGTH ( type: esriFieldTypeString, alias: Inspection Length, editable: true, nullable: true, length: 100, defaultValue: null, modelName: INSPECTION_LENGTH )
• ASSOC_W_UNDR_DRN ( type: esriFieldTypeString, alias: Associated with underdrain, editable: true, nullable: true, length: 255, defaultValue: No, modelName: ASSOC_W_UNDR_DRN , Coded Values: [Yes: Yes] , [No: No] )
• ASSOC_W_CULVE ( type: esriFieldTypeString, alias: Associated with culveret, editable: true, nullable: true, length: 255, defaultValue: No, modelName: ASSOC_W_CULVE , Coded Values: [Yes: Yes] , [No: No] )
• CRS ( type: esriFieldTypeString, alias: CRS, editable: true, nullable: true, length: 17, defaultValue: null, modelName: CRS )
• NLF_ID ( type: esriFieldTypeString, alias: NLF_ID, editable: true, nullable: true, length: 14, defaultValue: null, modelName: NLF_ID )
• sys_updated_date ( type: esriFieldTypeDate, alias: sys_updated_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: sys_updated_date )
• COUNTY_CD ( type: esriFieldTypeString, alias: COUNTY_CD, editable: true, nullable: true, length: 3, defaultValue: null, modelName: COUNTY_CD )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )

Templates:

• Name: Storm Mains - State
  Description:
  Prototype:
  ASSOC_W_UNDR_DRN: No
  STATUS: Active
  DIAMETER: Unknown
  SHAPE_OF_PIPE: Unknown
  MATERIAL: Unknown
  COMMENT: null
  REPLACE: Unknown
  REPAIR: Unknown
  FITTING_ON_TILE: null
  KNOWN_FLOW: Unknown
  INSPECTION_LENGTH: null
  INSTALL_YEAR: Unknown
  DATE_LAST_CLEANED: null
  FLOW_DIRECTION: null
  MAINTENANCE_RESPONSIBILITY: ODOT
  LET_PLANS_URL: null
  STORM_MAIN_FILE_NUMBER: null
  ODOT_DISTRICT: null
  COUNTY: null
  ROUTE_TYPE: null
  ROUTE_NBR: null
  ROUTE_SUFFIX: null
  CTL_BEGIN_NBR: null
  CTL_END_NBR: null
  STL_BEGIN_NBR: null
  STL_END_NBR: null
  LATITUDE_DD_BEGIN: null
  LONGITUDE_DD_BEGIN: null
  sys_updated_date: null
  NLF_ID: null
  CRS: null
  ASSOC_W_CULVE: No
  VIDEO_DATE: null
  SOURCE: Unknown
  COUNTY_RESPON: null
  COUNTY_CD: null
  INSPECT_VID_LINK: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• TAMCollector.TAMCOLLECTOR.DSI_STORMMAIN_DATELASTCLEANED (1) -- Related To: Storm Mains Date Last Cleaned (10)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: 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: true

Supports Coordinates Quantization: true

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