NatureQuant - NatureScore - Codebook.xlsx

	A	B	C	D	E	F
1
2
3
4
5
6	Data Partner			Dataset
7	Nature Quant			NatureScore
8	This codebook is created to be representative of the data available on Deweys platform. Please note: some datafields from the provider may be hidden due to privacy policies.
9	Column Number	Column Name	Column Format	Valid Values	Field Description	Notes
10	1	LEAF_CLASSIFICATION	VARCHAR	Nature Adequate Nature Deficient Nature Light Nature Rich Nature Utopia
11	2	LEAF_DESCRIPTION	VARCHAR		Text summary describing the density and quality of natural elements surrounding the location.
12	3	LEAF_RATING	NUMBER	1-5	score indicating the density of natural vegetation surrounding the location.
13	4	MEETS_WHO_GUIDELINE	BOOLEAN	TRUE FALSE	Indicates whether the location meets WHO guidelines	TRUE if the location meets WHO's recommendation of having accessible green space within 300 meters.
14	5	NATURESCORE	FLOAT	0-100		See NATURESCORE tab
15	6	GEOMETRY_HEX	VARCHAR		WKB hex string identifying the point’s coordinates	Hex-encoded Well-Known Binary (WKB) geometry representation. Stores point locations as binary encoded hex strings (e.g., "01010000..."). Can be converted to standard geometry types (e.g., longitude/latitude points) using GIS tools.
16	7	H3_CELL	VARCHAR		H3 hexagonal grid cell ID for the location	H3 spatial index representing the hexagonal cell containing the location. Stored as a 64-bit hex string (e.g., "882699ba0dfffff"). Encodes a resolution-8 H3 hexagon that can be decoded to a geographic area (centroid latitude/longitude or polygon boundary) using an H3 library.
17	8	LATITUDE	FLOAT		Latitude coordinate of the point location
18	9	LONGITUDE	FLOAT		Longitude coordinate of the point location
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100