View In:   ArcGIS Online Map Viewer

Name: End Structures - State

Display Field: TYPE

Type: Feature Layer

Geometry Type: esriGeometryPoint

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: -9440170.4506
YMin: 4941019.649599999
XMax: -9091274.3513
YMax: 5138956.618600003
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSSquare
Color: [85, 255, 0, 255]
Size: 13.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• TYPE ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TYPE , Coded Values: [Catch Basin: Catch Basin] , [Manhole: Manhole] , [Headwall: Headwall] , ...4 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 10, defaultValue: Active, modelName: STATUS , Coded Values: [Active: Active] , [Retired: Retired] , [Proposed: Proposed] )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 52, defaultValue: Unknown, modelName: MATERIAL , Coded Values: [Block: Block] , [Brick: Brick] , [Clay-Vertical Stand Pipe: Clay-Vertical Stand Pipe] , ...5 more... )
• INSTALL_YEAR ( type: esriFieldTypeString, alias: Install Year, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_YEAR )
• DATE_LAST_CLEANED ( type: esriFieldTypeDate, alias: Date Last Cleaned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_LAST_CLEANED )
• SIZE_OF_STRUCTURE ( type: esriFieldTypeString, alias: Size of Structure, editable: true, nullable: true, length: 31, defaultValue: Unknown, modelName: SIZE_OF_STRUCTURE , Coded Values: [1x1: 1x1] , [2x2: 2x2] , [3x3: 3x3] , ...11 more... )
• FLOW_DIRECTION ( type: esriFieldTypeString, alias: Direction of Flow, editable: true, nullable: true, length: 2, defaultValue: null, modelName: FLOW_DIRECTION , Coded Values: [N: North] , [S: South] , [E: East] , ...5 more... )
• PIPE_TO_THE_NORTH_EAST ( type: esriFieldTypeString, alias: Pipe size to the north east, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PIPE_TO_THE_NORTH_EAST , Coded Values: [02: 02] , [04: 04] , [06: 06] , ...18 more... )
• PIPE_TO_THE_EAST ( type: esriFieldTypeString, alias: Pipe size to the east, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PIPE_TO_THE_EAST , Coded Values: [02: 02] , [04: 04] , [06: 06] , ...18 more... )
• PIPE_TO_THE_SOUTH_EAST ( type: esriFieldTypeString, alias: Pipe size to the south east, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PIPE_TO_THE_SOUTH_EAST , Coded Values: [02: 02] , [04: 04] , [06: 06] , ...18 more... )
• PIPE_TO_THE_SOUTH ( type: esriFieldTypeString, alias: Pipe size to the south, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PIPE_TO_THE_SOUTH , Coded Values: [02: 02] , [04: 04] , [06: 06] , ...18 more... )
• PIPE_TO_THE_SOUTH_WEST ( type: esriFieldTypeString, alias: Pipe size to the south west, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PIPE_TO_THE_SOUTH_WEST , Coded Values: [02: 02] , [04: 04] , [06: 06] , ...18 more... )
• PIPE_TO_THE_WEST ( type: esriFieldTypeString, alias: Pipe size to the west, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PIPE_TO_THE_WEST , Coded Values: [02: 02] , [04: 04] , [06: 06] , ...18 more... )
• PIPE_TO_THE_NORTH_WEST ( type: esriFieldTypeString, alias: Pipe size to the north west, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PIPE_TO_THE_NORTH_WEST , Coded Values: [02: 02] , [04: 04] , [06: 06] , ...18 more... )
• REPAIR ( type: esriFieldTypeString, alias: Repair, editable: true, nullable: true, length: 8, defaultValue: No, modelName: REPAIR , Coded Values: [Yes: Yes] , [No: No] )
• REPLACE ( type: esriFieldTypeString, alias: Replace, editable: true, nullable: true, length: 8, defaultValue: No, modelName: REPLACE , Coded Values: [Yes: Yes] , [No: No] )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: COMMENT )
• MAINTENANCE_RESPONSIBILITY ( type: esriFieldTypeString, alias: Maintenance Responsible, editable: true, nullable: true, length: 15, defaultValue: ODOT, modelName: MAINTENANCE_RESPONSIBILITY , Coded Values: [ODOT: ODOT] , [County: County] , [City: City] , ...4 more... )
• ENDSTRUCTURE_FILE_NUMBER ( type: esriFieldTypeString, alias: ESFN, editable: true, nullable: true, length: 11, defaultValue: null, modelName: ENDSTRUCTURE_FILE_NUMBER )
• ODOT_DISTRICT ( type: esriFieldTypeString, alias: ODOT 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 )
• STL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: STL Begin Number, editable: true, nullable: true, defaultValue: null, modelName: STL_BEGIN_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 )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• SOURCE ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 50, defaultValue: Unknown, modelName: SOURCE , Coded Values: [Field Verified: Field Verified] , [Plan Set: Plan Set] , [Survey Data: Survey Data] , ...2 more... )
• PIPE_TO_THE_NORTH ( type: esriFieldTypeString, alias: Pipe size to the north, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PIPE_TO_THE_NORTH , Coded Values: [02: 02] , [04: 04] , [06: 06] , ...18 more... )
• RISER ( type: esriFieldTypeString, alias: Riser, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RISER , Coded Values: [Yes: Yes] , [Unknown: Unknown] )
• STRUCTURE_DEPTH ( type: esriFieldTypeString, alias: Depth, editable: true, nullable: true, length: 255, defaultValue: Unknown, modelName: STRUCTURE_DEPTH , Coded Values: [2: 2] , [3: 3] , [4: 4] , ...3 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 )
• MAT_N ( type: esriFieldTypeString, alias: Material to north, editable: true, nullable: true, length: 50, defaultValue: None, modelName: MAT_N , Coded Values: [Clay: Clay] , [Concrete: Concrete] , [Cast Iron: Cast Iron] , ...7 more... )
• MAT_NE ( type: esriFieldTypeString, alias: Material to north east, editable: true, nullable: true, length: 50, defaultValue: None, modelName: MAT_NE , Coded Values: [Clay: Clay] , [Concrete: Concrete] , [Cast Iron: Cast Iron] , ...7 more... )
• MAT_E ( type: esriFieldTypeString, alias: Material to east, editable: true, nullable: true, length: 50, defaultValue: None, modelName: MAT_E , Coded Values: [Clay: Clay] , [Concrete: Concrete] , [Cast Iron: Cast Iron] , ...7 more... )
• MAT_SE ( type: esriFieldTypeString, alias: Material to south east, editable: true, nullable: true, length: 50, defaultValue: None, modelName: MAT_SE , Coded Values: [Clay: Clay] , [Concrete: Concrete] , [Cast Iron: Cast Iron] , ...7 more... )
• MAT_SW ( type: esriFieldTypeString, alias: Material to south west, editable: true, nullable: true, length: 50, defaultValue: None, modelName: MAT_SW , Coded Values: [Clay: Clay] , [Concrete: Concrete] , [Cast Iron: Cast Iron] , ...7 more... )
• MAT_S ( type: esriFieldTypeString, alias: Material to south, editable: true, nullable: true, length: 255, defaultValue: None, modelName: MAT_S , Coded Values: [Clay: Clay] , [Concrete: Concrete] , [Cast Iron: Cast Iron] , ...7 more... )
• MAT_W ( type: esriFieldTypeString, alias: Material to west, editable: true, nullable: true, length: 255, defaultValue: None, modelName: MAT_W , Coded Values: [Clay: Clay] , [Concrete: Concrete] , [Cast Iron: Cast Iron] , ...7 more... )
• MAT_NW ( type: esriFieldTypeString, alias: Material to north west, editable: true, nullable: true, length: 255, defaultValue: None, modelName: MAT_NW , Coded Values: [Clay: Clay] , [Concrete: Concrete] , [Cast Iron: Cast Iron] , ...7 more... )
• ASSOC_W_UNDR_DR ( type: esriFieldTypeString, alias: Associated with Underdrain, editable: true, nullable: true, length: 255, defaultValue: No, modelName: ASSOC_W_UNDR_DR , Coded Values: [Yes: Yes] , [No: No] )
• ASSOC_W_CULVE ( type: esriFieldTypeString, alias: Associated with Culvert, editable: true, nullable: true, length: 255, defaultValue: No, modelName: ASSOC_W_CULVE , Coded Values: [Yes: Yes] , [No: No] )
• RISER1 ( type: esriFieldTypeString, alias: Riser 1, editable: true, nullable: true, length: 255, defaultValue: No, modelName: RISER1 , Coded Values: [No: No] , [Yes - 4": Yes - 4"] , [Yes - 6": Yes - 6"] , ...2 more... )
• RISER2 ( type: esriFieldTypeString, alias: Riser 2, editable: true, nullable: true, length: 255, defaultValue: No, modelName: RISER2 , Coded Values: [No: No] , [Yes - 4": Yes - 4"] , [Yes - 6": Yes - 6"] , ...2 more... )
• RISER3 ( type: esriFieldTypeString, alias: Riser 3, editable: true, nullable: true, length: 255, defaultValue: No, modelName: RISER3 , Coded Values: [No: No] , [Yes - 4": Yes - 4"] , [Yes - 6": Yes - 6"] , ...2 more... )
• GRATE_CLEANING ( type: esriFieldTypeString, alias: Grate Cleaning, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GRATE_CLEANING , Coded Values: [Grate was cleaned: Grate was cleaned] , [Grate needs cleaned: Grate needs cleaned] , [Maintenance needed: Maintenance needed] , ...1 more... )
• EDITING_ONLY ( type: esriFieldTypeString, alias: Editor Field, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EDITING_ONLY , Coded Values: [Yes: Yes] , [Unknown: Unknown] )
• CRS ( type: esriFieldTypeString, alias: CRS, editable: true, nullable: true, length: 17, defaultValue: null, modelName: CRS )
• NLFID ( type: esriFieldTypeString, alias: NLFID, editable: true, nullable: true, length: 14, defaultValue: null, modelName: NLFID )
• 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 )

Templates:

• Name: End Structures - State
  Description:
  Prototype:
  TYPE: null
  STATUS: Active
  DATE_LAST_CLEANED: null
  PIPE_TO_THE_NORTH_WEST: null
  REPAIR: No
  COMMENT: null
  COUNTY_CD: null
  RISER: null
  sys_updated_date: null
  MAT_N: None
  MAT_NE: None
  MAT_E: None
  MAT_SE: None
  MAT_SW: None
  MAT_S: None
  MAT_W: None
  MAT_NW: None
  ASSOC_W_UNDR_DR: No
  ASSOC_W_CULVE: No
  RISER1: No
  RISER2: No
  MATERIAL: Unknown
  INSTALL_YEAR: null
  SIZE_OF_STRUCTURE: Unknown
  FLOW_DIRECTION: null
  PIPE_TO_THE_NORTH_EAST: null
  PIPE_TO_THE_EAST: null
  PIPE_TO_THE_SOUTH_EAST: null
  PIPE_TO_THE_SOUTH: null
  PIPE_TO_THE_SOUTH_WEST: null
  PIPE_TO_THE_WEST: null
  REPLACE: No
  MAINTENANCE_RESPONSIBILITY: ODOT
  ENDSTRUCTURE_FILE_NUMBER: null
  ODOT_DISTRICT: null
  COUNTY: null
  ROUTE_TYPE: null
  ROUTE_NBR: null
  ROUTE_SUFFIX: null
  CTL_BEGIN_NBR: null
  STL_BEGIN_NBR: null
  LATITUDE_DD_BEGIN: null
  LONGITUDE_DD_BEGIN: null
  NLFID: null
  CRS: null
  EDITING_ONLY: null
  GRATE_CLEANING: null
  SOURCE: Unknown
  PIPE_TO_THE_NORTH: null
  STRUCTURE_DEPTH: Unknown
  COUNTY_RESPON: null
  RISER3: No
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• TAMCollector.TAMCOLLECTOR.DSI_ENDSTRUCTURE_DATELASTCLEANED (0) -- Related To: End Structure Date Last Cleaned (9)

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

Sync Can Return Changes: true

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: 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