Name: assessment

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• intent_of_assessment (type: esriFieldTypeString, alias: Intent of Assessment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Inventory: Inventory], [Repair_Update: Repair/Update])
• what_needs_to_be_done (type: esriFieldTypeString, alias: What needs to be done?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Hardware_Needs_Repair: Hardware Needs Repair], [Sign_Needs_Replacement: Sign Needs Replacement], [Post_Needs_Replacement: Post Needs Replacement], ... 6 more ...)
• what_needs_to_be_done_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• new_sign_location_description (type: esriFieldTypeString, alias: New Sign Location Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• sign_category (type: esriFieldTypeString, alias: Sign Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Custom: Custom Sign], [Park Management: Park Management (M)], [Hazard: Hazard (H)], ... 7 more ...)
• sign_category_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• custom_signage (type: esriFieldTypeString, alias: Custom Signage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Custom_Sign_Number_and_Descript: Custom Sign Number and Description])
• park_management_signage (type: esriFieldTypeString, alias: Park Management Signage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [M_063_Area_Closed_For_Plant_Reh: M-063 Area Closed For Plant Rehabilitation], [M_222_No_Smoking: M-222 No Smoking], [M_133_No_Diving_Within_The_Stat: M-133 No Diving Within The State Park], ... 2 more ...)
• land_management_signage (type: esriFieldTypeString, alias: Land Management Signage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [LM_Sign_Number_and_Description: LM Sign Number and Description])
• hazard_signage (type: esriFieldTypeString, alias: Hazard Signage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Hazard_Sign_Number_and_Descript: Hazard Sign Number and Description])
• recreational_symbols (type: esriFieldTypeString, alias: Recreational Symbols, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [RS_Sign_Number_and_Description: RS Sign Number and Description])
• interpretive_signage (type: esriFieldTypeString, alias: Interpretive Signage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Interp_Sign_Number_and_Descript: Interp Sign Number and Description])
• regulatory_signage (type: esriFieldTypeString, alias: Regulatory Signage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Regulatory_Sign_Number_and_Desc: Regulatory Sign Number and Description])
• warning_signage (type: esriFieldTypeString, alias: Warning Signage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Warning_Sign_Number_and_Descrip: Warning Sign Number and Description])
• construction_signage (type: esriFieldTypeString, alias: Construction Signage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Construction_Sign_Number_and_De: Construction Sign Number and Description])
• new_sign_text (type: esriFieldTypeString, alias: New Sign Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sign_image (type: esriFieldTypeString, alias: sign_image, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• _size (type: esriFieldTypeString, alias: Size, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [10x12: 10x12], [12x6: 12x6], [18x10: 18x10], ... 1 more ...)
• _size_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sign_figures (type: esriFieldTypeString, alias: sign_figures, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• what_is_the_sign_attached_to (type: esriFieldTypeString, alias: What is the sign attached to?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Wood_Post: Wood Post], [Metal_Post: Metal Post], [Gate: Gate], ... 7 more ...)
• what_is_the_sign_attached_to_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• type_of_metal_post (type: esriFieldTypeString, alias: Type of Metal Post, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Metal_Pole: Metal Pole], [Hollow_U_Channel: Hollow U-Channel], [Hollow_Square: Hollow Square], ... 2 more ...)
• type_of_metal_post_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• type_of_wood_post (type: esriFieldTypeString, alias: Type of Wood Post, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• type_of_wood_post_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• type_of_post_mounting (type: esriFieldTypeString, alias: Type of Post Mounting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Single: Single], [Double: Double], [other: Other])
• type_of_post_mounting_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• _condition (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Operational: Operational], [Needs_Repair: Needs Repair])
• condition_issue (type: esriFieldTypeString, alias: Condition Issue, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Damaged: Damaged], [Vandalized: Vandalized], [Fading: Fading], ... 4 more ...)
• condition_issue_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sign_waiver_procedure (type: esriFieldTypeString, alias: Sign Waiver Procedure, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• is_a_sign_waiver_required (type: esriFieldTypeString, alias: Is a sign waiver required for this new sign?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Pending: Pending], [Completed: Completed])
• completed_date (type: esriFieldTypeDate, alias: Completed Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• additional_comments (type: esriFieldTypeString, alias: Additional Comments, SQL Type: sqlTypeOther, length: 900, nullable: true, editable: true)
• multi_sign_repeat (type: esriFieldTypeString, alias: Click "+" to add multiple signs at this location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:

• form_assessment (1) -- Related To: survey (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/21/2020 11:32:35 PM

Schema Last Edit Date: 12/21/2020 11:32:35 PM

Data Last Edit Date: 12/21/2020 11:32:35 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat