View In:   ArcGIS Online Map Viewer

Name: Sign Maintenance

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 20000

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: -86.84357039899999
YMin: 33.64795986000007
XMax: -73.58392257499997
YMax: 45.51912510900007
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: maintenance_suggestion
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Defer
  Label: Defer
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [116, 173, 66, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [240, 240, 240, 0] Width: 1
• Value: Replace
  Label: Replace
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [131, 41, 166, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [240, 240, 240, 0] Width: 1
• Value: Retire
  Label: Retire
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 197, 255, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [240, 240, 240, 0] Width: 1
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: maintenance_suggestion

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• streetname ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: streetname )
• fromstreetname ( type: esriFieldTypeString, alias: From Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fromstreetname )
• tostreetname ( type: esriFieldTypeString, alias: To Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tostreetname )
• signcondition ( type: esriFieldTypeString, alias: Sign Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: signcondition , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] )
• signcategory ( type: esriFieldTypeString, alias: Sign Category, editable: true, nullable: true, length: 50, defaultValue: null, modelName: signcategory )
• signtype ( type: esriFieldTypeString, alias: Sign Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: signtype )
• mutcd ( type: esriFieldTypeString, alias: MUTCD, editable: true, nullable: true, length: 255, defaultValue: null, modelName: mutcd )
• maintenance_suggestion ( type: esriFieldTypeString, alias: Maintenance Suggestion, editable: true, nullable: true, length: 50, defaultValue: null, modelName: maintenance_suggestion )
• estimated_cost ( type: esriFieldTypeInteger, alias: Estimate Cost ($), editable: true, nullable: true, defaultValue: null, modelName: estimated_cost )
• repair_priority ( type: esriFieldTypeDouble, alias: Repair Priority, editable: true, nullable: true, defaultValue: null, modelName: repair_priority )
• functional_class ( type: esriFieldTypeString, alias: Functional Class, editable: true, nullable: true, length: 50, defaultValue: null, modelName: functional_class )
• functional_class_id ( type: esriFieldTypeSmallInteger, alias: Functional Class ID, editable: true, nullable: true, defaultValue: null, modelName: functional_class_id )
• last_repair_method ( type: esriFieldTypeString, alias: Last Repair Method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: last_repair_method )
• last_repair_cost ( type: esriFieldTypeInteger, alias: Last Repair Cost, editable: true, nullable: true, defaultValue: null, modelName: last_repair_cost )
• last_repair_date ( type: esriFieldTypeDate, alias: Last Repair Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_repair_date )
• future_event ( type: esriFieldTypeString, alias: Future Event, editable: true, nullable: true, length: 50, defaultValue: null, modelName: future_event )
• future_event_date ( type: esriFieldTypeDate, alias: Future Event Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: future_event_date )
• editor_note ( type: esriFieldTypeString, alias: Editor Note, editable: true, nullable: true, length: 100, defaultValue: null, modelName: editor_note )
• editor_name ( type: esriFieldTypeString, alias: Editor Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: editor_name )
• editor_id ( type: esriFieldTypeInteger, alias: Editor ID, editable: true, nullable: true, defaultValue: null, modelName: editor_id )
• last_edit ( type: esriFieldTypeDate, alias: Last Edit, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edit )
• ss_id ( type: esriFieldTypeInteger, alias: SS ID, editable: true, nullable: true, defaultValue: null, modelName: ss_id )
• positioninrow ( type: esriFieldTypeString, alias: Position In Row, editable: true, nullable: true, length: 255, defaultValue: null, modelName: positioninrow )
• postmaterial ( type: esriFieldTypeString, alias: Post Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: postmaterial )
• positiononpost ( type: esriFieldTypeString, alias: Position On Post, editable: true, nullable: true, length: 255, defaultValue: null, modelName: positiononpost )
• signposttype ( type: esriFieldTypeString, alias: Sign Post Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: signposttype )
• geodata_sign_signid ( type: esriFieldTypeInteger, alias: SignID, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_signid )
• geodata_sign_supportid ( type: esriFieldTypeInteger, alias: SupportID, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_supportid )
• geodata_sign_installdate ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: geodata_sign_installdate )
• geodata_sign_collectdate ( type: esriFieldTypeDate, alias: CollectDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: geodata_sign_collectdate )
• geodata_sign_status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_status )
• geodata_sign_dimwidth ( type: esriFieldTypeSmallInteger, alias: DimWidth, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_dimwidth )
• geodata_sign_dimheight ( type: esriFieldTypeSmallInteger, alias: DimHeight, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_dimheight )
• geodata_sign_signheight ( type: esriFieldTypeDouble, alias: SignHeight, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_signheight )
• geodata_sign_facedirection ( type: esriFieldTypeString, alias: FaceDirection, editable: true, nullable: true, length: 20, defaultValue: null, modelName: geodata_sign_facedirection )
• geodata_sign_facecondition ( type: esriFieldTypeString, alias: FaceCondition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_facecondition )
• geodata_sign_sheetcolor1 ( type: esriFieldTypeString, alias: SheetColor1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_sheetcolor1 )
• geodata_sign_sheetcolor2 ( type: esriFieldTypeString, alias: SheetColor2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_sheetcolor2 )
• geodata_sign_legendcolor1 ( type: esriFieldTypeString, alias: LegendColor1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_legendcolor1 )
• geodata_sign_legendcolor2 ( type: esriFieldTypeString, alias: LegendColor2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_legendcolor2 )
• geodata_sign_donotreplace ( type: esriFieldTypeSmallInteger, alias: DoNotReplace, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_donotreplace )
• geodata_sign_hasnewsignindicat ( type: esriFieldTypeSmallInteger, alias: HasNewSignIndicator, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_hasnewsignindicat )
• geodata_sign_installer ( type: esriFieldTypeString, alias: Installer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_installer )
• geodata_sign_replaceyear ( type: esriFieldTypeInteger, alias: ReplaceYear, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_replaceyear )
• geodata_sign_gridloc ( type: esriFieldTypeString, alias: GridLoc, editable: true, nullable: true, length: 5, defaultValue: null, modelName: geodata_sign_gridloc )
• geodata_sign_replaces ( type: esriFieldTypeInteger, alias: Replaces, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_replaces )
• geodata_sign_regpkrestrtype1 ( type: esriFieldTypeString, alias: RegPkRestrType1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_regpkrestrtype1 )
• geodata_sign_regpkvehexception ( type: esriFieldTypeString, alias: RegPkVehException1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_regpkvehexception )
• geodata_sign_regpktoday2 ( type: esriFieldTypeString, alias: RegPkToDay2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_regpktoday2 )
• geodata_sign_comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: geodata_sign_comments )
• geodata_sign_retiredate ( type: esriFieldTypeDate, alias: RetireDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: geodata_sign_retiredate )
• geodata_sign_category ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 255, defaultValue: null, modelName: geodata_sign_category )
• geodata_sign_support_supportid ( type: esriFieldTypeInteger, alias: SupportID, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_support_supportid )
• geodata_sign_support_type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_support_type )
• geodata_sign_support_material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_support_material )
• geodata_sign_support_basetype ( type: esriFieldTypeString, alias: BaseType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_support_basetype )
• geodata_sign_support_postgroup ( type: esriFieldTypeString, alias: PostGroup, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_support_postgroup )
• geodata_sign_support_condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_support_condition )
• geodata_sign_support_installda ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: geodata_sign_support_installda )
• geodata_sign_support_leanangle ( type: esriFieldTypeDouble, alias: LeanAngle, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_support_leanangle )
• geodata_sign_support_numsuppor ( type: esriFieldTypeSmallInteger, alias: NumSupports, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_support_numsuppor )
• geodata_sign_support_status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_support_status )
• geodata_sign_support_relativep ( type: esriFieldTypeString, alias: RelativePosition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: geodata_sign_support_relativep )
• geodata_sign_support_replaces ( type: esriFieldTypeInteger, alias: Replaces, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_support_replaces )
• geodata_sign_support_offset_in ( type: esriFieldTypeSmallInteger, alias: Offset_In, editable: true, nullable: true, defaultValue: null, modelName: geodata_sign_support_offset_in )
• geodata_sign_support_poleid ( type: esriFieldTypeString, alias: Pole ID TEXT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: geodata_sign_support_poleid )
• photomatchid ( type: esriFieldTypeInteger, alias: PHOTOMATCHID, editable: true, nullable: true, defaultValue: null, modelName: photomatchid )
• legend ( type: esriFieldTypeString, alias: Legend, editable: true, nullable: true, length: 100, defaultValue: null, modelName: legend )
• start_date_ss ( type: esriFieldTypeDate, alias: start_date_ss, editable: true, nullable: true, length: 8, defaultValue: null, modelName: start_date_ss )
• end_date_ss ( type: esriFieldTypeDate, alias: end_date_ss, editable: true, nullable: true, length: 8, defaultValue: null, modelName: end_date_ss )
• objectid_slx ( type: esriFieldTypeInteger, alias: objectid_slx, editable: true, nullable: true, defaultValue: null, modelName: objectid_slx )
• condition_index ( type: esriFieldTypeInteger, alias: condition_index, editable: true, nullable: true, defaultValue: null, modelName: condition_index )
• installation_date ( type: esriFieldTypeDate, alias: installation_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installation_date )
• sign_id ( type: esriFieldTypeInteger, alias: sign_id, editable: true, nullable: true, defaultValue: null, modelName: sign_id )
• clx_uid ( type: esriFieldTypeInteger, alias: clx_uid, editable: true, nullable: true, defaultValue: null, modelName: clx_uid )

Types:

ID: Defer
Name: Defer
Domains:
• signcondition:
  Inherited
Templates:
• Name: Defer
  Description:
  Prototype:
  mutcd: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  signcondition: null
  signcategory: null
  signtype: null
  maintenance_suggestion: Defer
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  future_event: null
  future_event_date: null
  editor_note: null
  editor_name: null
  editor_id: null
  last_edit: null
  ss_id: null
  positioninrow: null
  postmaterial: null
  positiononpost: null
  signposttype: null
  geodata_sign_signid: null
  geodata_sign_supportid: null
  geodata_sign_installdate: null
  geodata_sign_collectdate: null
  geodata_sign_status: null
  geodata_sign_dimwidth: null
  geodata_sign_dimheight: null
  geodata_sign_signheight: null
  geodata_sign_facedirection: null
  geodata_sign_facecondition: null
  geodata_sign_sheetcolor1: null
  geodata_sign_sheetcolor2: null
  geodata_sign_legendcolor1: null
  geodata_sign_legendcolor2: null
  geodata_sign_donotreplace: null
  geodata_sign_hasnewsignindicat: null
  geodata_sign_installer: null
  geodata_sign_replaceyear: null
  geodata_sign_gridloc: null
  geodata_sign_replaces: null
  geodata_sign_regpkrestrtype1: null
  geodata_sign_regpkvehexception: null
  geodata_sign_regpktoday2: null
  geodata_sign_comments: null
  geodata_sign_retiredate: null
  geodata_sign_category: null
  geodata_sign_support_supportid: null
  geodata_sign_support_type: null
  geodata_sign_support_material: null
  geodata_sign_support_basetype: null
  geodata_sign_support_postgroup: null
  geodata_sign_support_condition: null
  geodata_sign_support_installda: null
  geodata_sign_support_leanangle: null
  geodata_sign_support_numsuppor: null
  geodata_sign_support_status: null
  geodata_sign_support_relativep: null
  geodata_sign_support_replaces: null
  geodata_sign_support_offset_in: null
  geodata_sign_support_poleid: null
  photomatchid: null
  legend: null
  start_date_ss: null
  end_date_ss: null
  objectid_slx: null
  condition_index: null
  installation_date: null
  sign_id: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Replace
Name: Replace
Domains:
• signcondition:
  Inherited
Templates:
• Name: Replace
  Description:
  Prototype:
  mutcd: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  signcondition: null
  signcategory: null
  signtype: null
  maintenance_suggestion: Replace
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  future_event: null
  future_event_date: null
  editor_note: null
  editor_name: null
  editor_id: null
  last_edit: null
  ss_id: null
  positioninrow: null
  postmaterial: null
  positiononpost: null
  signposttype: null
  geodata_sign_signid: null
  geodata_sign_supportid: null
  geodata_sign_installdate: null
  geodata_sign_collectdate: null
  geodata_sign_status: null
  geodata_sign_dimwidth: null
  geodata_sign_dimheight: null
  geodata_sign_signheight: null
  geodata_sign_facedirection: null
  geodata_sign_facecondition: null
  geodata_sign_sheetcolor1: null
  geodata_sign_sheetcolor2: null
  geodata_sign_legendcolor1: null
  geodata_sign_legendcolor2: null
  geodata_sign_donotreplace: null
  geodata_sign_hasnewsignindicat: null
  geodata_sign_installer: null
  geodata_sign_replaceyear: null
  geodata_sign_gridloc: null
  geodata_sign_replaces: null
  geodata_sign_regpkrestrtype1: null
  geodata_sign_regpkvehexception: null
  geodata_sign_regpktoday2: null
  geodata_sign_comments: null
  geodata_sign_retiredate: null
  geodata_sign_category: null
  geodata_sign_support_supportid: null
  geodata_sign_support_type: null
  geodata_sign_support_material: null
  geodata_sign_support_basetype: null
  geodata_sign_support_postgroup: null
  geodata_sign_support_condition: null
  geodata_sign_support_installda: null
  geodata_sign_support_leanangle: null
  geodata_sign_support_numsuppor: null
  geodata_sign_support_status: null
  geodata_sign_support_relativep: null
  geodata_sign_support_replaces: null
  geodata_sign_support_offset_in: null
  geodata_sign_support_poleid: null
  photomatchid: null
  legend: null
  start_date_ss: null
  end_date_ss: null
  objectid_slx: null
  condition_index: null
  installation_date: null
  sign_id: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Retire
Name: Retire
Domains:
• signcondition:
  Inherited
Templates:
• Name: Retire
  Description:
  Prototype:
  mutcd: null
  clx_uid: null
  streetname: null
  fromstreetname: null
  tostreetname: null
  signcondition: null
  signcategory: null
  signtype: null
  maintenance_suggestion: Retire
  estimated_cost: null
  repair_priority: null
  functional_class: null
  functional_class_id: null
  last_repair_method: null
  last_repair_cost: null
  last_repair_date: null
  future_event: null
  future_event_date: null
  editor_note: null
  editor_name: null
  editor_id: null
  last_edit: null
  ss_id: null
  positioninrow: null
  postmaterial: null
  positiononpost: null
  signposttype: null
  geodata_sign_signid: null
  geodata_sign_supportid: null
  geodata_sign_installdate: null
  geodata_sign_collectdate: null
  geodata_sign_status: null
  geodata_sign_dimwidth: null
  geodata_sign_dimheight: null
  geodata_sign_signheight: null
  geodata_sign_facedirection: null
  geodata_sign_facecondition: null
  geodata_sign_sheetcolor1: null
  geodata_sign_sheetcolor2: null
  geodata_sign_legendcolor1: null
  geodata_sign_legendcolor2: null
  geodata_sign_donotreplace: null
  geodata_sign_hasnewsignindicat: null
  geodata_sign_installer: null
  geodata_sign_replaceyear: null
  geodata_sign_gridloc: null
  geodata_sign_replaces: null
  geodata_sign_regpkrestrtype1: null
  geodata_sign_regpkvehexception: null
  geodata_sign_regpktoday2: null
  geodata_sign_comments: null
  geodata_sign_retiredate: null
  geodata_sign_category: null
  geodata_sign_support_supportid: null
  geodata_sign_support_type: null
  geodata_sign_support_material: null
  geodata_sign_support_basetype: null
  geodata_sign_support_postgroup: null
  geodata_sign_support_condition: null
  geodata_sign_support_installda: null
  geodata_sign_support_leanangle: null
  geodata_sign_support_numsuppor: null
  geodata_sign_support_status: null
  geodata_sign_support_relativep: null
  geodata_sign_support_replaces: null
  geodata_sign_support_offset_in: null
  geodata_sign_support_poleid: null
  photomatchid: null
  legend: null
  start_date_ss: null
  end_date_ss: null
  objectid_slx: null
  condition_index: null
  installation_date: null
  sign_id: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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