Name: Nestrans_RATN_Results_Table

Display Field: Q1a_OverallAmbition

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

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: sqlTypeOther, length: 38, nullable: false, editable: false)
• Q1a_OverallAmbition (type: esriFieldTypeString, alias: 1. Do you think that the overall level of ambition for the network as set out earlier and in the accompanying map is:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [too_little: 1 . Too Little], [2: 2], [about_right: 3. About Right], ... 2 more ...)
• Q1b_Reason (type: esriFieldTypeString, alias: 1b. Why do you say this?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Q2a_ACAmbition (type: esriFieldTypeString, alias: 2. Do you think that the level of ambition for the network of active travel routes within Aberdeen City is:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [too_little: 1 . Too Little], [2: 2], [about_right: 3. About Right], ... 2 more ...)
• Q2b_Reason (type: esriFieldTypeString, alias: 2b. Why do you say this?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Q3a_AberdeenshireAmbition (type: esriFieldTypeString, alias: 3. Do you think that the level of ambition for the network of active travel routes within the towns in Aberdeenshire is:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [too_little: 1 . Too Little], [2: 2], [about_right: 3. About Right], ... 2 more ...)
• Q3b_Reason (type: esriFieldTypeString, alias: 3b. Why do you say this?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Q4a_RegionalConnectorAmbition (type: esriFieldTypeString, alias: 4. Do you think that the level of ambition for the network of regional connector routes between settlements is:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [too_little: 1 . Too Little], [2: 2], [about_right: 3. About Right], ... 2 more ...)
• Q4b_Reason (type: esriFieldTypeString, alias: 4b. Why do you say this?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Q5_SpecificFeatures (type: esriFieldTypeString, alias: 5. Are there specific features that you would you like to have included as part of the final network proposals that would make it easier for you to walk, wheel or cycle, or other specific features that you prefer were not included? As an example, this could include a preference for a particular type of crossing, footway designs, traffic calming measures, other improvements to improve sense of place. Please provide details below., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Q6a_SupportingMeasures (type: esriFieldTypeString, alias: 6. The network will be complemented by supporting measures to enable and encourage people to walk, wheel and cycle more. Please select up to three that would particularly help you and other people you know to travel more actively., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [improved_info: Improved information on active travel options, including signage, maps, on-line information], [cycle_training_adults: More cycle training for adults], [cycle_training_children: More cycle training for children], ... 4 more ...)
• Q6b_AdditionalComment (type: esriFieldTypeString, alias: 6a. If you have a suggestion that is not listed above, please provide it here., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Q7a_ApproachAppropriate (type: esriFieldTypeString, alias: 7. Do you feel that the proposed approach to prioritising delivery of the network is appropriate?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [partially: Partially], [no: No], ... 1 more ...)
• Q7b_Reason (type: esriFieldTypeString, alias: 7b. Why do you say this?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Q8_FurtherComments (type: esriFieldTypeString, alias: 8. Do you have any further comments or suggestions that you would like to be considered in the development of the Regional Active Travel Network ?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Q9 (type: esriFieldTypeString, alias: 9. Where is your organisation based? This information will not be used for marketing purposes or passed to anyone outside the project team., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Q10_org (type: esriFieldTypeString, alias: 10. What is the name of the organisation you are responding on behalf of?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Q11_org (type: esriFieldTypeString, alias: 11. How many people are employed by your organisation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [lessthan_10: Fewer than 10], [10_49: 10 – 49], [50_99: 50 – 99], ... 4 more ...)
• Q10_ind (type: esriFieldTypeString, alias: 10. How old are you?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [under_16: Under 16], [under_18: Under 18], [18_24: 18-24], ... 5 more ...)
• Q11_ind (type: esriFieldTypeString, alias: 11. Which gender do you identify most with?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [female: Female], [male: Male], [trans_male: Transgender Male], ... 4 more ...)
• Q12_ind (type: esriFieldTypeString, alias: 12. Do you have a disability, health condition or illness?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [no: No], [physical_impairment: Yes – physical impairment], [sensory_impairment: Yes – sensory impairment], ... 5 more ...)
• Q12b_ind (type: esriFieldTypeString, alias: 12b. Does your disability, health condition or illness affect your ability to walk, wheel or cycle?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes_a_lot: Yes, a lot], [yes_a_little: Yes, a little], [no: No], ... 1 more ...)
• Q13_ind (type: esriFieldTypeString, alias: 14. Which race or ethnicity best describes you?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes_a_lot: Yes, a lot], [yes_a_little: Yes, a little], [no: No], ... 1 more ...)
• Q14_ind (type: esriFieldTypeString, alias: 15. What is your current employment status?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [white: White], [caribbean_black: Caribbean or Black], [asian: Asian/Scottish Asian/British Asian], ... 4 more ...)
• Q15_ind (type: esriFieldTypeString, alias: 16. Please provide the first 5 digits of your postcode, for example AB24 5. This information will not be used for marketing purposes or passed to anyone outside the project team., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [employed_fulltime: Employed - full time], [employed_parttime: Employed - part time], [selfemployed_fulltime: Self-employed - full time], ... 7 more ...)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)

Templates:

Name: Nestrans_RATN_Results_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/3/2024 4:13:49 PM

Schema Last Edit Date: 7/3/2024 4:13:49 PM

Data Last Edit Date: 7/2/2024 1:21:19 PM

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