Name: survey

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -468413.390351053
YMin: -90
XMax: 180
YMax: 7600624.55210775
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"label":"Survey Point","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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)
• Audit_Date (type: esriFieldTypeDate, alias: Audit date and time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shelter_ID (type: esriFieldTypeString, alias: Stop ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• shelter_present (type: esriFieldTypeString, alias: Shelter present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• shelter_type (type: esriFieldTypeString, alias: Shelter type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [cantilever: Cantilever], [enclosed: Enclosed], [brick_stone: Brick/Stone], ... 4 more ...)
• glassperspex_cleanliness_glassp (type: esriFieldTypeString, alias: Glass/Perspex Panels, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [not_present: Not Present], [no_issues_clean: 1], [minor_issue_s_clean_while_on_si: 2], ... 3 more ...)
• glassperspex_comments (type: esriFieldTypeString, alias: Glass/Perspex - Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• General_area (type: esriFieldTypeString, alias: General bus stop area, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issues: N/a], [Minor_issue: 1], [Major_issue: 2], ... 3 more ...)
• General_stickers (type: esriFieldTypeString, alias: Unauthorised stickers/advertising, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issues: N/a], [Minor_issue: 1], [Major_issue: 2], ... 3 more ...)
• General_graffiti (type: esriFieldTypeString, alias: Graffiti, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issues: N/a], [Minor_issue: 1], [Major_issue: 2], ... 3 more ...)
• General_bin (type: esriFieldTypeString, alias: Rubbish bin, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issues: N/a], [Minor_issue: 1], [Major_issue: 2], ... 3 more ...)
• shelter_cleanliness_vegetation_ (type: esriFieldTypeString, alias: Vegetation (weeds, moss, etc.), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issues: N/a], [Minor_issue: 1], [Major_issue: 2], ... 3 more ...)
• general_cleanliness_comments (type: esriFieldTypeString, alias: General cleanliness - comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• TT_Case_present (type: esriFieldTypeString, alias: Timetable case - present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• timetable_case_height_appropria (type: esriFieldTypeString, alias: Appropriate height of case?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [no_action_required: No action required], [minor_issue_s_rectify_while_on_: Minor issue(s)], [major_issue_s_will_require_foll: Major issue(s)])
• timetable_case_height_issues (type: esriFieldTypeString, alias: Timetable case height issues, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• TT_Case_cleanliness (type: esriFieldTypeString, alias: General cleanliness, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issues: 1], [Minor_issue: 2], [Major_issue: 3], ... 2 more ...)
• TT_Case_TT_present (type: esriFieldTypeString, alias: Timetable - present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issues: No action required], [Minor_issue: Minor issue(s) - rectify while on site], [Major_issue: Major issue(s) - will require follow-up or replacement])
• TT_Case_blank_area (type: esriFieldTypeString, alias: Full case expanse utilised?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issues: No action required], [Minor_issue: Minor issue(s) - rectify while on site], [Major_issue: Major issue(s) - will require follow-up or replacement])
• TT_Case_stickers (type: esriFieldTypeString, alias: Unauthorised stickers/advertising, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issues: 1], [Minor_issue: 2], [Major_issue: 3], ... 2 more ...)
• TT_Case_graffiti (type: esriFieldTypeString, alias: Graffiti, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issues: 1], [Minor_issue: 2], [Major_issue: 3], ... 2 more ...)
• TT_Case_tape (type: esriFieldTypeString, alias: Tape residue, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issues: 1], [Minor_issue: 2], [Major_issue: 3], ... 2 more ...)
• timetable_case_issues (type: esriFieldTypeString, alias: Timetable Case - Issues, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• timetable_information_present (type: esriFieldTypeString, alias: Timetable information present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• TT_Info_present (type: esriFieldTypeString, alias: Timetable - present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issue: Yes / No action required], [Minor_issue: Minor issue(s) - rectify while on site], [Major_issue: Major issue(s) - will require follow-up or replacement])
• TT_Info_position (type: esriFieldTypeString, alias: Timetable appropriately positioned?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issue: Yes], [Minor_issue: No], [Major_issue: Major issue(s)], ... 1 more ...)
• TT_Info_alignment (type: esriFieldTypeString, alias: Timetable correctly aligned?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issue: Yes / No action required], [Minor_issue: Minor issue(s) - rectify while on site], [Major_issue: Major issue(s) - will require follow-up or replacement])
• TT_Info_format (type: esriFieldTypeString, alias: Timetable - up to date formatting?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issue: Yes / No action required], [Minor_issue: Minor issue(s) - rectify while on site], [Major_issue: Major issue(s) - will require follow-up or replacement])
• TT_Info_mounting (type: esriFieldTypeString, alias: Timetable appropriately mounted on white background?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issue: Yes / No action required], [Minor_issue: Minor issue(s) - rectify while on site], [Major_issue: Major issue(s) - will require follow-up or replacement])
• TT_Info_legible (type: esriFieldTypeString, alias: Information and text legible?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issue: Yes], [Minor_issue: No], [Major_issue: Major issue(s)], ... 1 more ...)
• TT_Info_YoungScot (type: esriFieldTypeString, alias: Young Scot promotion present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issue: Yes], [Minor_issue: No], [Major_issue: Major issue(s)], ... 1 more ...)
• TT_Info_DRT (type: esriFieldTypeString, alias: DRT information present and correct?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issue: Yes], [Minor_issue: No], [Major_issue: Major issue(s)], ... 1 more ...)
• TT_Info_NetworkMap (type: esriFieldTypeString, alias: Public Transport Network Map present and correct?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issue: Yes], [Minor_issue: No], [Major_issue: Major issue(s)], ... 1 more ...)
• TT_Info_Issues (type: esriFieldTypeString, alias: Timetable information issues, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Flag_Present (type: esriFieldTypeString, alias: Flag present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Flag_Presentation_mounting (type: esriFieldTypeString, alias: Flag present and mounted to shelter (where appropriate)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issue: No action required], [Minor_Issue: Minor issue(s)], [Major_Issue: Major issue(s)])
• Flag_Presentation_clean (type: esriFieldTypeString, alias: Flag cleanliness, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issue: 1], [Minor_Issue: 2], [Major_Issue: 3], ... 2 more ...)
• Flag_Presentation_fading (type: esriFieldTypeString, alias: Flag fading, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No_issue: 1], [Minor_Issue: 2], [Major_Issue: 3], ... 2 more ...)
• Flag_Issues (type: esriFieldTypeString, alias: Flag - Issues, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Visible_Defects (type: esriFieldTypeString, alias: Visible Defects, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Visible_Defects_info (type: esriFieldTypeString, alias: Visible Defects - Detail, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• auditor_name (type: esriFieldTypeString, alias: Auditor name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [robert_plewes: Robert Plewes], [chris_carberry: Chris Carberry], [graham_wilson: Graham Wilson], ... 3 more ...)
• shelter_type_other (type: esriFieldTypeString, alias: Other - Shelter type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• shelter_manufacturer (type: esriFieldTypeString, alias: Shelter manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Clear_Channel: Clear Channel], [Commutaports: Commutaports], [Externiture: Externiture], ... 1 more ...)
• panel_replacements_needed (type: esriFieldTypeString, alias: Panel replacements needed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• how_many_panels_need_replaced (type: esriFieldTypeDouble, alias: How many panels need replaced?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• should_this_shelter_be_replaced (type: esriFieldTypeString, alias: Should this shelter be replaced entirely?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• shelter_replacement_notes (type: esriFieldTypeString, alias: Shelter replacement notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• timetable_case_height (type: esriFieldTypeString, alias: Timetable case height, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• flag_replacement_requirements (type: esriFieldTypeString, alias: Flag replacement requirements, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• flag_replacements (type: esriFieldTypeString, alias: Flag replacements, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• post_panel_replacements (type: esriFieldTypeString, alias: POST Panel replacements, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• panel_replacement_date (type: esriFieldTypeDate, alias: Panel replacement date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• panel_work_notes (type: esriFieldTypeString, alias: Panel work notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• post_shelter_replacement (type: esriFieldTypeString, alias: POST Shelter replacement, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• shelter_replacement_date (type: esriFieldTypeDate, alias: Shelter replacement date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• shelter_work_notes (type: esriFieldTypeString, alias: Shelter work notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• post_flag_replacements (type: esriFieldTypeString, alias: POST Flag replacements, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• flag_replacement_date (type: esriFieldTypeDate, alias: Flag replacement date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• flag_work_notes (type: esriFieldTypeString, alias: Flag work notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• unauthorised_stickersadvertisin (type: esriFieldTypeString, alias: Unauthorised stickers/advertising, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• company_details (type: esriFieldTypeString, alias: Company details, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Raised_Kerb (type: esriFieldTypeString, alias: Does this stop have a raised kerb?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/17/2023 8:48:49 AM

Schema Last Edit Date: 4/25/2022 6:01:52 AM

Data Last Edit Date: 4/25/2022 6:01:52 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat