-- COLLECTED DATA OF THE STUDY ABOUT PERCEIVED AND EXPERIENCED WALKING RISKS FOR CHILDREN, YOUTH AND OLDER ADULTS IN LOWER EAST BOSTON --


You can find three files with the data:

  * “lower_east_boston_risks_answers.xlsx”: a spreadsheet that has only one sheet with the answers provided by the users
    for all non-geometric questions. Field “ID” is an internal identifier that allows us to link each answer with the
    geometric elements defined on the map that are provided in the other files. Fields will be blank when the user didn't have
    to answer to them because of their relation to other questions or because of the user profile.
  * “lower_east_boston_risks_risky_places.geojson”: includes the risky places defined by the users. Coordinates are in “EPSG:4326”.
    Aside from the geometry itself, it includes the following alphanumeric fields:
      * “id”: internal identifier of the geometric element. Useful only for internal processes that
        require identifying a particular entity.
      * “answr_id”: internal identifier of the survey answer that defined this geometric element. Allows
        us to link the answers from the “xlsx” file with the places they defined on the map.
      * “risk_no_crossing”: whether the user marked the risk type “There is no pedestrian crossing”
        for this place (1 = yes | 0 = no).
      * “risk_wornout_paint”: whether the user marked the risk type “Worn-out paint at the pedestrian
        crossing” for this place (1 = yes | 0 = no).
      * “risk_no_crossing_sign”: whether the user marked the risk type “Pedestrian crossing signal does
        not work or does not exist” for this place (1 = yes | 0 = no).
      * “risk_no_ramps”: whether the user marked the risk type “No ramps” for this place (1 = yes | 0 = no).
      * “risk_poor_condition_ramps”: whether the user marked the risk type “Ramps in poor condition
        (uneven, surface texture, etc.)” for this place (1 = yes | 0 = no).
      * “risk_standing_water”: whether the user marked the risk type “Standing water that blocks sidewalks,
        ramps, or crossings” for this place (1 = yes | 0 = no).
      * “risk_blocking_vehicles”: whether the user marked the risk type “Vehicles block the pedestrian path”
        for this place (1 = yes | 0 = no).
      * “risk_poor_sidewalk”: whether the user marked the risk type “Narrow sidewalks, with obstacles, or in
        poor condition (uneven, broken, holes, etc.)” for this place (1 = yes | 0 = no).
      * “risk_no_shade”: whether the user marked the risk type “Sidewalks or pedestrian paths without shade”
        for this place (1 = yes | 0 = no).
      * “risk_no_lighting”: whether the user marked the risk type “Lack of lighting at night” for this place
        (1 = yes | 0 = no).
      * “risk_complex_intersection”: whether the user marked the risk type “Very complex intersections” for
        this place. (1 = yes | 0 = no)
      * “risk_no_time_cross”: whether the user marked the risk type “There is not enough time to cross” for
        this place. (1 = yes | 0 = no)
      * “risk_speeding_vehicles”: whether the user marked the risk type “Cars, buses, bicycles, or scooters
        travel at high speed on streets or through crossings” for this place. (1 = yes | 0 = no)
      * “risk_dont_obey_signs”: whether the user marked the risk type “Drivers do not follow traffic controls
        (for example, do not obey STOP signs, block crosswalks, or ignore traffic lights)” for this place
        (1 = yes | 0 = no).
      * “risk_sidewalk_bikes”: whether the user marked the risk type “Bicycles and/or scooters travel on
        sidewalks and interfere with pedestrian movement” for this place. (1 = yes | 0 = no)
      * “risk_no_shaded_resting”: whether the user marked the risk type “There are not enough shaded resting
        places along the route” for this place. (1 = yes | 0 = no)
      * “risk_sidewalk_garbage”: whether the user marked the risk type “Garbage or trash containers frequently
        block the pedestrian route” for this place. (1 = yes | 0 = no)
      * “risk_conflict_zone”: whether the user marked the risk type “Presence of people under the influence of
        substances, conflictive groups, or illicit/criminal activities that create a perceived risky
        environment” for this place. (1 = yes | 0 = no)
      * “risk_empty_streets”: whether the user marked the risk type “Very few other pedestrians are present
        at certain times” for this place. (1 = yes | 0 = no)
      * “risk_crowds”: whether the user marked the risk type “Excessive crowding causes disorientation or
        blocks the way” for this place. (1 = yes | 0 = no)
      * “risk_other”: whether the user marked the risk type “Other type” for this place (1 = yes | 0 = no).
      * “risk_other_text”: specific risk the user typed for the risk type “Other type” for this place.
      * “nr_types”: number of risk types selected by the user for this place.
      * “comments”: additional comments about this place by the user.
  * “lower_east_boston_risks_safe_places.geojson”: includes the safe places defined by the users. Aside
    from the geometry itself, it includes the following alphanumeric fields:
      * “id”: internal identifier of the geometric element. Useful only for internal processes that
        require identifying a particular entity.
      * “answr_id”: internal identifier of the survey answer that defined this geometric element. Allows
        us to link the answers from the “xlsx” file with the places they defined on the map.
      * “safe_accessible”: whether the user marked the positive trait “It is easy to get to places I want
        to visit, such as parks, stores, schools, transit, or community facilities” for this place
        (1 = yes | 0 = no).
      * “safe_traffic”: whether the user marked the positive trait “I feel safe from traffic and vehicles”
        for this place (1 = yes | 0 = no).
      * “safe_sidewalks”: whether the user marked the positive trait “There are good sidewalks, crossings,
        or other pedestrian facilities” for this place (1 = yes | 0 = no).
      * “safe_trees”: whether the user marked the positive trait “There are trees, shade, or comfortable
        places to rest” for this place (1 = yes | 0 = no).
      * “safe_quiet”: whether the user marked the positive trait “The area is quiet or has little traffic
        noise” for this place (1 = yes | 0 = no).
      * “safe_nice”: whether the user marked the positive trait “The area has nice views, attractive
        surroundings, or interesting things to see” for this place (1 = yes | 0 = no).
      * “safe_lighting”: whether the user marked the positive trait “There is good lighting and I can see my
        surroundings clearly” for this place (1 = yes | 0 = no).
      * “safe_people”: whether the user marked the positive trait “There are other people around, and I feel
        comfortable walking here” for this place (1 = yes | 0 = no).
      * “safe_comfortable”: whether the user marked the positive trait “There is enough space to walk comfortably”
        for this place (1 = yes | 0 = no).
      * “safe_clean”: whether the user marked the positive trait “The area is clean and well maintained” for this
        place (1 = yes | 0 = no).
      * “safe_other”: whether the user marked the positive trait “Other type” for this place (1 = yes | 0 = no).
      * “safe_other_text”: specific risk the user typed for the positive trait “Other type” for this place.
      * “nr_types”: number of positive traits selected by the user for this place.
      * “comments”: additional comments about this place by the user.

