MeDALL Neighbourhood Green Space Tool
Table ID: BiB_MeDALL.medall_ngst
Entity type | Variables | Entities | Updated | Related tables |
---|---|---|---|---|
Participant | 115 | 815 | 2022-09-30 | NA |
An audit of 45 green spaces in Bradford was conducted in June-July 2015 to examine the present quality of spaces. Spaces were selected on the basis they were visited most frequently by a MEDALL sub-sample. Two assessors completed the audit using an adaptation of Gidlow’s (2012) Neighbourhood Green Space Tool. This tool measures the quality of ‘neighbourhood’ urban green space, including access, recreational facilities, amenities, natural features, incivilities and usage.
variable | label | value_type | summary |
---|---|---|---|
has_medall_ngst | Has medall neighbourhood green space tool | decimal | mean (sd) 1.00 (0.00) min < median < max 1.00 < 1.00 < 1.00 Complete: 3284 (100.00%) |
PregnancyID | BiB Pregnancy ID | text | 821 unique values 3284 non-missing values 7 characters |
FatherID | BiB Father ID | decimal | mean (sd) 31579.58 (944.48) min < median < max 30027.00 < 31513.00 < 33340.00 Complete: 1152 (35.08%) |
agemm_mdngst | Mother age (months): MeDALL Neighbourhood Green Space Tool | decimal | mean (sd) 402.93 (66.44) min < median < max 242.00 < 401.00 < 591.00 Complete: 3276 (99.76%) |
agemy_mdngst | Mother age (years): MeDALL Neighbourhood Green Space Tool | decimal | mean (sd) 33.13 (5.54) min < median < max 20.00 < 33.00 < 49.00 Complete: 3276 (99.76%) |
has_mdngst | Has: MeDALL Neighbourhood Green Space Tool | decimal | 1 : has Complete: 3284 (100.00%) |
ngst_alcoholIN2a | evidence of alcohol use | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_alcohollevelIN2b | level of evidence of alcohol use | decimal | 1 : Hardly noticeable 2 : Noticeable 3 : Very noticeable Complete: 539 (16.41%) |
ngst_attractNN4 | presence of public attraction | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_bbqAM8a | presence of bbq | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_binsAM2a | presence of bins | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_binsqualAM2b | quality of bins | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 1683 (51.25%) |
ngst_cafeAM5a | presence of cafe | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_cafequalAM5b | quality of cafe | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 967 (29.45%) |
ngst_canalNA2d | presence of canal | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_childUS4a | suitable for children’s play dichotomous | decimal | 1 : Not useful 2 : Somewhat to very useful Complete: 1683 (51.25%) |
ngst_childUS4b | suitable for children’s play | decimal | 1 : Not useful 2 : Somewhat useful 3 : Useful 4 : Very useful Complete: 1683 (51.25%) |
ngst_conseUS5a | suitable for conservation or biodiversity dichotomous | decimal | 1 : Not useful 2 : Somewhat to very useful Complete: 1683 (51.25%) |
ngst_conseUS5b | suitable for conservatio or biodiversity | decimal | 1 : Not useful 2 : Somewhat useful 3 : Useful 4 : Very useful Complete: 1683 (51.25%) |
ngst_courtqualR3b | quality of courts | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 1145 (34.87%) |
ngst_courtR3a | presence of courts | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_cparkAC7a | presence of car park | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_cparkqualAC7b | car park quality | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 1494 (45.49%) |
ngst_cycliUS9a | suitable for cycling dichotomous | decimal | 1 : Not useful 2 : Somewhat to very useful Complete: 1683 (51.25%) |
ngst_cycliUS9b | suitable for cycling | decimal | 1 : Not useful 2 : Somewhat useful 3 : Useful 4 : Very useful Complete: 1683 (51.25%) |
ngst_dbinAM3a | presence of dog mess bins | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_dbinqualAM3b | quality of dog mess bins | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 956 (29.11%) |
ngst_dogmeIN7a | presence of dog mess | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_dogmeIN7b | level of dog mess | decimal | 1 : Hardly noticeable 2 : Noticeable 3 : Very noticeable Complete: 31 (0.94%) |
ngst_drinkAM10 | presence of drinking fountains | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_drugsIN3a | evidence of drug use | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_drugslevelIN3b | level of evidence of drug use | decimal | 1 : Hardly noticeable 2 : Noticeable 3 : Very noticeable Complete: 0 (0.00%) |
ngst_entrAC1 | number of entrance points | decimal | 1 : 1-3 2 : 4-7 3 : 8+ Complete: 1683 (51.25%) |
ngst_fishiUS11a | suitable for fishing dichotomous | decimal | 1 : Not useful 2 : Somewhat to very useful Complete: 1683 (51.25%) |
ngst_fishiUS11b | suitable for fishing | decimal | 1 : Not useful 2 : Somewhat useful 3 : Useful 4 : Very useful Complete: 1683 (51.25%) |
ngst_fitfacqualR5b | quality of fitness facilities | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 398 (12.12%) |
ngst_fitfacR5a | presence of fitness facilities | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_flowerNA7a | presence of flowers | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_flowerqualNA7b | quality of flowers | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 1462 (44.52%) |
ngst_fountainNN1 | presence of water fountain | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_glassIN5a | presence of broken glass | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_glasslevelIN5b | level of broken glass | decimal | 1 : Hardly noticeable 2 : Noticeable 3 : Very noticeable Complete: 289 (8.80%) |
ngst_gpitchqualR2b | quality of grass pitch | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 1533 (46.68%) |
ngst_gpitchR2a | presence of grass pitch | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_graffitiIN4a | presence of graffiti | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_graffitilevelIN4b | level of graffiti | decimal | 1 : Hardly noticeable 2 : Noticeable 3 : Very noticeable Complete: 576 (17.54%) |
ngst_greenspace | name of green space | text | 43 unique values 1683 non-missing values 9 to 33 characters |
ngst_gsheltAM7a | presence of green shelter | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_gsheltqualAM7b | quality of green shelter | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 1539 (46.86%) |
ngst_historyNN3 | presence of historic or attractive building or man-made structure | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_housevisSA3 | visibility of houses from centre | decimal | 1 : None 2 : Partial 3 : Clear Complete: 1683 (51.25%) |
ngst_inforUS2a | suitable for informal games dichotomous | decimal | 1 : Not useful 2 : Somewhat to very useful Complete: 1683 (51.25%) |
ngst_inforUS2b | suitable for informal games | decimal | 1 : Not useful 2 : Somewhat useful 3 : Useful 4 : Very useful Complete: 1683 (51.25%) |
ngst_lakeNA2a | presence of small lake | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_lightsqualSA1b | quality of lighting | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 608 (18.51%) |
ngst_lightsSA1a | presence of lighting | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_litterIN1a | presence of litter | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_litterlevelIN1b | level of litter | decimal | 1 : Hardly noticeable 2 : Noticeable 3 : Very noticeable Complete: 1344 (40.93%) |
ngst_mroadAC2 | adjacent roads are minor/not busy | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_noiseIN8a | presence of noise pollution | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_noiselevelIN8b | level of noise pollution | decimal | 1 : Hardly noticeable 2 : Noticeable 3 : Very noticeable Complete: 187 (5.69%) |
ngst_opspacqualR7 | quality of open space | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 1673 (50.94%) |
ngst_opspacquanR6b | amount of open space | decimal | 1 : Some 2 : Adequate 3 : A lot Complete: 1673 (50.94%) |
ngst_opspacR6a | presence of open space | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_parkcode | park code | decimal | mean (sd) 41.43 (42.49) min < median < max 1.00 < 30.00 < 214.00 Complete: 2039 (62.09%) |
ngst_pathsAC5a | presence of paths | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_pathsqualAC6 | quality of paths | decimal | 1 : Poor 2 : Adequate 3 : Good 4 : Excellent Complete: 1683 (51.25%) |
ngst_pathsquanAC5b | quantity of paths | decimal | 1 : Some 2 : Adequate 3 : A lot Complete: 1633 (49.73%) |
ngst_picnicAM9a | presence of picnic tables | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_picnicqualAM9b | quality of picnic tables | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 824 (25.09%) |
ngst_plantNA8a | presence of other planted trees, shrubs | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_plantqualNA8b | quality of other plants, shrubs | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 1522 (46.35%) |
ngst_playeR1a | presence of playground equipment | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_playqualR1b | quality of playground equipment | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 1666 (50.73%) |
ngst_pondNA2b | presence of pond | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_pubartNN2 | presence of public art | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_relaxUS8a | suitable for relaxing dichotomous | decimal | 1 : Not useful 2 : Somewhat to very useful Complete: 1683 (51.25%) |
ngst_relaxUS8b | suitable for relaxing | decimal | 1 : Not useful 2 : Somewhat useful 3 : Useful 4 : Very useful Complete: 1683 (51.25%) |
ngst_roadsvisSA2 | visibility of roads from centre | decimal | 1 : None 2 : Partial 3 : Clear Complete: 1683 (51.25%) |
ngst_safecAC3 | adjacent roads have safe crossing | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_satisfaction | Satisfaction 1-5 (5 = most satisfied) | decimal | mean (sd) 4.08 (1.01) min < median < max 1.00 < 4.00 < 5.00 Complete: 2024 (61.63%) |
ngst_seatAM1a | presence of seating, benches | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_seatqualAM1b | quality of seating | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 1683 (51.25%) |
ngst_sheltAM6a | presence of man-made shelter | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_sheltqualAM6b | quality of man-made shelter | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 1221 (37.18%) |
ngst_shortAC4 | used as a shortcut/ direct route | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_skatequalR4b | quality of skaterampqual | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 492 (14.98%) |
ngst_skateR4a | presnce of skateramp | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_smellsIN9a | presence of unpleasant smells | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_smellslevelIN9b | level of unpleasant smells | decimal | 1 : Hardly noticeable 2 : Noticeable 3 : Very noticeable Complete: 201 (6.12%) |
ngst_sociaUS7a | suitable for socialising dichotomous | decimal | 1 : Not useful 2 : Somewhat to very useful Complete: 1683 (51.25%) |
ngst_sociaUS7b | suitable for socialising | decimal | 1 : Not useful 2 : Somewhat useful 3 : Useful 4 : Very useful Complete: 1683 (51.25%) |
ngst_sportUS1a | suitable for sports dichotomous | decimal | 1 : Not useful 2 : Somewhat to very useful Complete: 1683 (51.25%) |
ngst_sportUS1b | suitable for sport | decimal | 1 : Not useful 2 : Somewhat useful 3 : Useful 4 : Very useful Complete: 1683 (51.25%) |
ngst_streamNA2c | presence of stream | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_surfacqualNA6 | maintenance of primary surface | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 1683 (51.25%) |
ngst_toiletAM4a | presence of toilet | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_toiletqualAM4b | quality of public toilet | decimal | 1 : Poor 2 : Adequate 3 : Good Complete: 887 (27.01%) |
ngst_treesNA5a | presence of trees | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_treespercNA5b | percentage of area occupied by trees | decimal | 1 : 1%-10% 2 : 11%-25% 3 : 26%-50% 4 : 50%+ Complete: 1655 (50.40%) |
ngst_typol | typology | decimal | 1 : Park 2 : Natural/ semi-natural 3 : Amenity/ pulbic open space Complete: 1683 (51.25%) |
ngst_vandsmIN6a | presence of vandalism | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_vandsmlevelIN6b | level of vandalism | decimal | 1 : Hardly noticeable 2 : Noticeable 3 : Very noticeable Complete: 378 (11.51%) |
ngst_viewpNA4 | presence of viewpoint, vista, scenic view | decimal | mean (sd) 0.80 (0.40) min < median < max 0.00 < 1.00 < 1.00 Complete: 1683 (51.25%) |
ngst_visuaUS6a | suitable for visual qualities dichotomous | decimal | 1 : Not useful 2 : Somewhat to very useful Complete: 1683 (51.25%) |
ngst_visuaUS6b | suitable for enjoying landscape or visual qualities | decimal | 1 : Not useful 2 : Somewhat useful 3 : Useful 4 : Very useful Complete: 1683 (51.25%) |
ngst_walkiUS3a | suitable for walking dichotomous | decimal | 1 : Not useful 2 : Somewhat to very useful Complete: 1683 (51.25%) |
ngst_walkiUS3b | suitable for walking | decimal | 1 : Not useful 2 : Somewhat useful 3 : Useful 4 : Very useful Complete: 1683 (51.25%) |
ngst_waterNA3a | presence of water | decimal | 1 : Absent 2 : Present Complete: 1683 (51.25%) |
ngst_waterNA3b | percentage of area occupied by water | decimal | 1 : <25% 2 : 26%-50% 3 : 51%-75% Complete: 1187 (36.14%) |
ngst_waterUS10a | suitable for water sports dichotomous | decimal | 1 : Not useful 2 : Somewhat to very useful Complete: 1683 (51.25%) |
ngst_waterUS10b | suitable for water sports | decimal | 1 : Not useful 2 : Somewhat useful 3 : Useful 4 : Very useful Complete: 1683 (51.25%) |
ngst_watshoreNA1 | on the foreshore of a beach, river or lake | decimal | 1 : No 2 : Yes Complete: 1683 (51.25%) |
ngst_weath | weather | text | 3 unique values 1683 non-missing values 3 to 10 characters |
ngst_yearcode | summer park 1/2 or winter park 3/4 | decimal | 1 : summer park 1 2 : summer park 2 3 : winter park 1 4 : winter park 2 Complete: 3284 (100.00%) |