Name: Lexington_FirstPriority_JoinView

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

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

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Lexington_Bike_Ped_Plan_SurveyV2","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: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• globalid (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• infrastructure_q14a (type: esriFieldTypeString, alias: 14a. We would like to know about your #1 highest priority for bicycling, sidewalk, and pedestrian crossing improvements in Lexington. Additional questions below will ask for your #2 and #3 top priorities. To respond, follow this two-step process Step 1: Click one of the five option buttons below to categorize your priority:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [newbikelanes: New bike lanes], [intersectionsafetyimprovements: Intersection safety improvements], [newimprovedsidewalk: New/improved sidewalk], ... 2 more ...)
• infrastructure_q14acomment (type: esriFieldTypeString, alias: Please describe the issue or concern, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• infrastructure_q14a_x (type: esriFieldTypeDouble, alias: Q14a X Location, SQL Type: sqlTypeOther, nullable: true, editable: true)
• infrastructure_q14a_y (type: esriFieldTypeDouble, alias: Q14a Y Location, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeOther, 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)
• globalid_1680869369555 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• bikewalk_q1 (type: esriFieldTypeString, alias: 1. How often do you ride a bike in Lexington for either transportation or recreation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [everyday_yearround: Every day, year-round], [everyday_warm: Every day, during warm-weather months], [weekly_yearround: 2-3 times a week, year-round], ... 4 more ...)
• bikewalk_q2 (type: esriFieldTypeString, alias: 2. Which type of bike do you typically ride within Lexington?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [hybridbike: Hybrid bike], [roadbike: Road bike], [mountainbike: Mountain bike], ... 3 more ...)
• bikewalk_q3 (type: esriFieldTypeString, alias: 3. For any of the options above, is it an e-bike?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: I don't own/ride a bicycle])
• bikewalk_q4 (type: esriFieldTypeString, alias: 4. How confident do you feel while riding a bicycle in Lexington?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [veryconfident: I am very confident riding a bike (I am comfortable riding with traffic in most situations)], [somewhatconfident: I am somewhat confident riding a bike (I prefer separated paths, but will ride on roads where space is available and traffic is manageable)], [notveryconfident: I am not very confident riding a bike (I only feel safe on separated trails/paths with few traffic crossings)], ... 1 more ...)
• bikewalk_q5 (type: esriFieldTypeString, alias: 5. Which of the following initiatives would encourage you to bike more frequently for transportation purposes?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bikewalk_q5other (type: esriFieldTypeString, alias: (please specify) (100 character limit), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• bikewalk_q6_1 (type: esriFieldTypeString, alias: 6. Do you or someone in your household own a small-scale electric vehicle such as a standing e-scooter, electric skateboard, or 'one-wheel'?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• bikewalk_q6a_1 (type: esriFieldTypeString, alias: 6A. How is the e-scooter, e-skateboard, etc. primarily used?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bikewalk_q6 (type: esriFieldTypeString, alias: 7. How often do you walk in Lexington for transportation or recreation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [everyday_yearround: Every day, year-round], [everyday_warm: Every day, during warm-weather months], [weekly_yearround: 2-3 times a week, year-round], ... 4 more ...)
• bikewalk_q7 (type: esriFieldTypeString, alias: 8. Which of the following initiatives would encourage you to walk more frequently for transportation purposes?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bikewalk_q7other (type: esriFieldTypeString, alias: (please specify) (100 character limit), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• bikewalk_q8 (type: esriFieldTypeString, alias: 9. Do you drive regularly for most or all of your trips in Lexington?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• bikewalk_q8a (type: esriFieldTypeString, alias: 9a. If you drive regularly for most or all of your trips, what barriers prevent you from walking or bicycling more frequently?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bikewalk_q8other (type: esriFieldTypeString, alias: (please specify) (100 character limit), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• bikewalk_q9 (type: esriFieldTypeString, alias: 10. What do you think would MOST improve the walking and bicycling experience for school-age children?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bikewalk_q9other (type: esriFieldTypeString, alias: (please specify) (100 character limit), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• q10a_number (type: esriFieldTypeInteger, alias: q10a_number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• q10b_number (type: esriFieldTypeInteger, alias: q10b_number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• q10c_number (type: esriFieldTypeInteger, alias: q10c_number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• q10d_number (type: esriFieldTypeInteger, alias: q10d_number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• q10e_number (type: esriFieldTypeInteger, alias: q10e_number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• q10f_number (type: esriFieldTypeInteger, alias: q10f_number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• q10g_number (type: esriFieldTypeInteger, alias: q10g_number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• q10h_number (type: esriFieldTypeInteger, alias: q10h_number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bikewalk_q10a (type: esriFieldTypeInteger, alias: Improve connections to public transit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bikewalk_q10b (type: esriFieldTypeInteger, alias: Education and safety training programs (children and adults), SQL Type: sqlTypeOther, nullable: true, editable: true)
• bikewalk_q10c (type: esriFieldTypeInteger, alias: More trails (narrower foot paths) and multiuse paths (similar to the Minuteman Bikeway), SQL Type: sqlTypeOther, nullable: true, editable: true)
• bikewalk_q10d (type: esriFieldTypeInteger, alias: Striped bike lanes/protected bike lanes, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bikewalk_q10e (type: esriFieldTypeInteger, alias: Improving or adding new sidewalks (includes wider sidewalks), SQL Type: sqlTypeOther, nullable: true, editable: true)
• bikewalk_q10f (type: esriFieldTypeInteger, alias: Winter maintenance of paths, trails, and sidewalks, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bikewalk_q10g (type: esriFieldTypeInteger, alias: Safer intersections and road crossings, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bikewalk_q10h (type: esriFieldTypeInteger, alias: Programs to promote alternatives to driving (e.g. bike share program), SQL Type: sqlTypeOther, nullable: true, editable: true)
• bikewalk_q11 (type: esriFieldTypeString, alias: 12. When rebuilding/repaving streets, a carefully balanced approach is needed to safely accommodate people bicycling and walking. What strategies or modifications should be considered first to make room for bicycles and pedestrians?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• infrastructure_q13 (type: esriFieldTypeString, alias: 13. Which of these destinations need better pedestrian and bicycle infrastructure nearby?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• infrastructure_q13other (type: esriFieldTypeString, alias: (please specify), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• infrastructure_q13schoolname (type: esriFieldTypeString, alias: Select School:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ClarkeMiddleSchool: Clarke Middle School], [DiamondMiddleSchool: Diamond Middle School], [EstabrookElementary: Estabrook Elementary], ... 6 more ...)
• infrastructure_q13busdisrtict (type: esriFieldTypeString, alias: Select Business District:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [EastLexingtonMassAve: East Lexington – Mass Ave], [HartwellBedford: Hartwell/Bedford], [MarrettLincoln: Marrett and Lincoln], ... 6 more ...)
• bikewalk_q12 (type: esriFieldTypeString, alias: 15. Are you interested in the Town developing a mountain bike park/pump track as a public amenity? A pump track is a place where kids and adults can develop their skills in mountain biking through a circuit of dirt rollers, banked turns, jumps, and other features., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unsure: Unsure])
• bikewalk_q12a (type: esriFieldTypeString, alias: 15a. If yes, feel free to suggest a location easily accessible by bicycle where it should be located., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• demographics_q15 (type: esriFieldTypeString, alias: 16. Are you a Lexington resident?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• demographics_q15a (type: esriFieldTypeString, alias: 16a. Roughly how far do you live from a K-12 school?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [miles0.25: <0.25 mile], [miles0.5: 0.25 – 0.5 mile], [miles1: 0.5 – 1.0 mile], ... 1 more ...)
• demographics_q15b (type: esriFieldTypeString, alias: 16b. Does your child/children attend (or will soon attend) school in Lexington?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [nochildren: I do not have children])
• demographics_q15b_c (type: esriFieldTypeString, alias: 16c. At what age would you be comfortable letting your child/children walk or bike to school without adult supervision, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [<7 years old: <7 years old], [7-8 years old: 7-8 years old], [9-10 years old: 9-10 years old], ... 3 more ...)
• demographics_q15c (type: esriFieldTypeString, alias: 16d. Does your child/children walk or bike to school?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Typically, Yes], [notimecontraintsdistance: No, due primarily to time constraint and/or distance], [noschoolonwaytowork: No, since the school is on my way to work], ... 3 more ...)
• demographics_q15cano (type: esriFieldTypeString, alias: (please specify) (100 character limit), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• demographics_q16 (type: esriFieldTypeString, alias: 17. What is your age?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [under18: 18 or younger], [19to24: 19-24], [25to29: 25-29], ... 7 more ...)
• demographics_q16a (type: esriFieldTypeString, alias: 17a. If you are under 18 or younger, are you in:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [highschool: High school], [middleschool: Middle school], [elementaryschool: Elementary school])
• demographics_q16b (type: esriFieldTypeString, alias: 17b. During relatively warm/pleasant weather, how do you typically get to/from school?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [walkalone: Walk alone], [walkwithparentfriend: Walk with parent or friends], [bikealone: Bike alone], ... 5 more ...)
• demographics_q16bother (type: esriFieldTypeString, alias: (please specify) (100 character limit), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• demographics_q16c (type: esriFieldTypeString, alias: 17c. What would be your preferred way to get around Lexington?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [walk: Walk], [bike_ebike: Bike/e-bike], [bus: Bus], ... 2 more ...)
• demographics_q16cother (type: esriFieldTypeString, alias: (please specify) (100 character limit), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CreationDate_1680869369555 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1680869369555 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1680869369555 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1680869369555 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• overallcomments (type: esriFieldTypeString, alias: 18. Please leave any additional comments if you wish (up to 250 words), SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

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

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/25/2024 1:40:54 PM

Schema Last Edit Date: 4/7/2023 12:05:20 PM

Data Last Edit Date: 4/7/2023 11:10:14 AM

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