Datasets
The datasets for this demonstrator were obtained via the Socrata Open Data API.
Dataset columns
The dataset columns are listed in Table 1.
#  Column  Description  Example 

1  the_geom (text) 
The base geometry for the building footprint (a POLYGON or MULTIPOLYGON in Wellknown Text format). 
"MULTIPOLYGON (((122.494880357885 37.732074353228, 122.494885190592 37.732074562213, 122.494883369673 37.7320479286, 122.495000467199 37.7320412853, 122.495049108233 37.732039226941, 122.495051187574 37.732072886172, 122.495054851638 37.73207276134, 122.495056855062 37.732110305559, 122.495027244206 37.732111335862, 122.495027569812 37.732115133302, 122.495011437999 37.732116156651, 122.49501101228 37.732111885342, 122.494997685515 37.732112337307, 122.494985848199 37.732112738249, 122.494986094608 37.732116889798, 122.494883608028 37.732121446295, 122.494880357885 37.732074353228)))" 
2  the_geom_area (float) 
The area of the base geometry (units: square decimal degrees).  1.2491435199277467e08 
3  the_geom_centroid (text) 
The centroid of the base geometry (a POINT in Wellknown Text format). 
"POINT (122.4949675314404 37.73208033387407)" 
4  the_geom_centroid_ubid_inf (text) 
The informative UBID for the the base geometry.  "849VPGJ4+R2M849VPGJ3+RXW849VPGJ4+R29" 
5  the_geom_centroid_ubid_rep (text) 
The representative UBID for the the base geometry.  "849VPGJ4+R2M1223" 
6  the_geom_centroid_ubid_centroid_olc (text) 
The Open Location Code for the centroid of the base geometry.  "849VPGJ4+R2M" 
7  the_geom_centroid_ubid_northwest_olc (text) 
The Open Location Code for the northwest corner of the bounding box for the base geometry.  "849VPGJ3+RXW" 
8  the_geom_centroid_ubid_southeast_olc (text) 
The Open Location Code for the southeast corner of the bounding box for the base geometry.  "849VPGJ4+R29" 
9  the_geom_centroid_ubid_north (integer) 
The Manhattan distance from the centroid of the base geometry to the northern extent of the bounding box for the base geometry in Open Location Code grid units.  1 
10  the_geom_centroid_ubid_east (integer) 
The Manhattan distance from the centroid of the base geometry to the eastern extent of the bounding box for the base geometry in Open Location Code grid units.  2 
11  the_geom_centroid_ubid_south (integer) 
The Manhattan distance from the centroid of the base geometry to the southern extent of the bounding box for the base geometry in Open Location Code grid units.  2 
12  the_geom_centroid_ubid_west (integer) 
The Manhattan distance from the centroid of the base geometry to the western extent of the bounding box for the base geometry in Open Location Code grid units.  3 
13  the_geom_rotation_bbox (text) 
The rotated bounding box for the base geometry (a POLYGON ) in Wellknown Text format). 
"POLYGON ((122.4948789393708 37.73204777023362, 122.4948829544409 37.73212301275431, 122.4950570374431 37.73211372338636, 122.495053022373 37.73203848086566, 122.4948789393708 37.73204777023362))" 
14  the_geom_rotation_bbox_area (float) 
The area of the rotated bounding box for the base geometry (units: square decimal degrees).  1.3135741362971848e08 
15  the_geom_rotation_degrees (float) 
The angle of the rotated bounding box of the base geometry (units: degrees).  3.0545041832282553 
16  the_geom_rotation_radians (float) 
The angle of the rotated bounding box of the base geometry (units: radians).  0.053311155013273215 
17  the_geom_rotation_symbol (integer) 
The sign of the angle of the rotated bounding box of the base geometry: +1 for clockwise rotation and 1 for anticlockwise rotation. 
1 
18  bbox (text) 
The bounding box for the base geometry (a POLYGON in Wellknown Text format). 
"POLYGON ((122.494880357885 37.732039226941, 122.494880357885 37.732121446295, 122.495056855062 37.732121446295, 122.495056855062 37.732039226941, 122.494880357885 37.732039226941))" 
19  bbox_area (float) 
The area of the bounding box of the base geometry (units: square decimal degrees).  1.4511483876275387e08 
20  bbox_centroid (text) 
The centroid of the bounding box for the base geometry (a POINT in Wellknown Text format). 
"POINT (122.4949686064735 37.73208033661799)" 
21  bbox_centroid_ubid_inf (text) 
The informative UBID for the bounding box for the base geometry.  "849VPGJ4+R2M849VPGJ3+RXW849VPGJ4+R29" 
22  bbox_centroid_ubid_rep (text) 
The representative UBID for the bounding box for the base geometry.  "849VPGJ4+R2M1223" 
23  bbox_centroid_ubid_centroid_olc (text) 
The Open Location Code for the centroid of the bounding box for the base geometry.  "849VPGJ4+R2M" 
24  bbox_centroid_ubid_northwest_olc (text) 
The Open Location Code for the northwest corner of the bounding box for the base geometry.  "849VPGJ3+RXW" 
25  bbox_centroid_ubid_southeast_olc (text) 
The Open Location Code for the southeast corner of the bounding box for the base geometry.  "849VPGJ4+R29" 
26  bbox_centroid_ubid_north (integer) 
The Manhattan distance from the centroid of the bounding box for the base geometry to the northern extent of the bounding box for the base geometry in Open Location Code grid units.  1 
27  bbox_centroid_ubid_east (integer) 
The Manhattan distance from the centroid of the bounding box for the base geometry to the eastern extent of the bounding box for the base geometry in Open Location Code grid units.  2 
28  bbox_centroid_ubid_south (integer) 
The Manhattan distance from the centroid of the bounding box for the base geometry to the southern extent of the bounding box for the base geometry in Open Location Code grid units.  2 
29  bbox_centroid_ubid_west (integer) 
The Manhattan distance from the centroid of the bounding box for the base geometry to the western extent of the bounding box for the base geometry in Open Location Code grid units.  3 
30  bbox_centroid_distance_ft (float) 
The distance from the centroid of the base geometry to the centroid of the bounding box for the base geometry (units: feet).  0.3109099650824856 
31  bbox_centroid_distance_m (float) 
The distance from the centroid of the base geometry to the centroid of the bounding box for the base geometry (units: meters).  0.09476535739333743 
32  bbox_diag_ft (float) 
The length of the diagonal of the bounding box for the base geometry (units: feet).  59.17724564325296 
33  bbox_diag_m (float) 
The length of the diagonal of the bounding box for the base geometry (units: meters).  18.037224478952854 
34  bbox_height_ft (float) 
The height of the bounding box for the base geometry (units: feet).  29.939771206958127 
35  bbox_height_m (float) 
The height of the bounding box for the base geometry (units: meters).  9.125642267366395 
36  bbox_width_ft (float) 
The width of the bounding box for the base geometry (units: feet).  51.044680261510294 
37  bbox_width_m (float) 
The width of the bounding box for the base geometry (units: meters).  9.125642267366395 
38  olc_bbox (text) 
The Open Location Code bounding box for the base geometry (a POLYGON in Wellknown Text format). 
"POLYGON ((122.494875 37.732025, 122.494875 37.732125, 122.4950625 37.732125, 122.4950625 37.732025, 122.494875 37.732025))" 
39  olc_bbox_area (float) 
The area of the Open Location Code bounding box of the base geometry (units: square decimal degrees).  1.87499999959158e08 
40  olc_bbox_centroid (text) 
The centroid of the Open Location Code bounding box for the base geometry (a POINT in Wellknown Text format). 
"POINT (122.49496875 37.73207500000001)" 
41  olc_bbox_centroid_ubid_inf (text) 
The informative UBID for the Open Location Code bounding box for the base geometry.  "849VPGJ4+R2M849VPGJ3+RXW849VPGJ4+R25" 
42  olc_bbox_centroid_ubid_rep (text) 
The representative UBID for the Open Location Code bounding box for the base geometry.  "849VPGJ4+R2M1233" 
43  olc_bbox_centroid_ubid_centroid_olc (text) 
The Open Location Code for the centroid of the Open Location Code bounding box for the base geometry.  "849VPGJ4+R2M" 
44  olc_bbox_centroid_ubid_northwest_olc (text) 
The Open Location Code for the northwest corner of the Open Location Code bounding box for the base geometry.  "849VPGJ3+RXW" 
45  olc_bbox_centroid_ubid_southeast_olc (text) 
The Open Location Code for the southeast corner of the Open Location Code bounding box for the base geometry.  "849VPGJ4+R25" 
46  olc_bbox_centroid_ubid_north (integer) 
The Manhattan distance from the centroid of the Open Location Code bounding box for the base geometry to the northern extent of the bounding box for the base geometry in Open Location Code grid units.  1 
47  olc_bbox_centroid_ubid_east (integer) 
The Manhattan distance from the centroid of the Open Location Code bounding box for the base geometry to the eastern extent of the bounding box for the base geometry in Open Location Code grid units.  2 
48  olc_bbox_centroid_ubid_south (integer) 
The Manhattan distance from the centroid of the Open Location Code bounding box for the base geometry to the southern extent of the bounding box for the base geometry in Open Location Code grid units.  3 
49  olc_bbox_centroid_ubid_west (integer) 
The Manhattan distance from the centroid of the Open Location Code bounding box for the base geometry to the western extent of the bounding box for the base geometry in Open Location Code grid units.  3 
50  olc_bbox_centroid_bbox_centroid_distance_ft (float) 
The distance from the centroid of the bounding box for the base geometry to the centroid of the Open Location Code bounding box for the base geometry (units: feet).  1.94374445852237 
51  olc_bbox_centroid_bbox_centroid_distance_m (float) 
The distance from the centroid of the bounding box for the base geometry to the centroid of the Open Location Code bounding box for the base geometry (units: meters).  0.5924533111839071 
52  olc_bbox_centroid_distance_ft (float) 
The distance from the centroid of the base geometry to the centroid of the Open Location Code bounding box for the base geometry (units: feet).  1.974016798172323 
53  olc_bbox_centroid_distance_m (float) 
The distance from the centroid of the base geometry to the centroid of the Open Location Code bounding box for the base geometry (units: meters).  0.601680320312737 
54  olc_bbox_diag_ft (float) 
The length of the diagonal of the Open Location Code bounding box for the base geometry (units: feet).  65.31890601165743 
55  olc_bbox_diag_m (float) 
The length of the diagonal of the Open Location Code bounding box for the base geometry (units: meters).  19.909202559957546 
56  olc_bbox_height_ft (float) 
The height of the Open Location Code bounding box for the base geometry (units: feet).  36.414505502817754 
57  olc_bbox_height_m (float) 
The height of the Open Location Code bounding box for the base geometry (units: meters).  11.099141281498191 
58  olc_bbox_width_ft (float) 
The width of the Open Location Code bounding box for the base geometry (units: feet).  54.22681279701207 
59  olc_bbox_width_m (float) 
The width of the Open Location Code bounding box for the base geometry (units: meters).  16.528332546842307 
Demonstrator
The demonstrator page is divided into two sections: the map, provided by Bing Maps, and the search form.
Using the map
To use the map, see the Bing Maps Help page.
UUID calculator
To calculate the UUID for a new building footprint:
 Enter drawing mode; click the button (top lefthand corner of the map).

Repeat for each building footprint:
 Click the location of the first point (in the exterior ring of the polygon for the building footprint).
 Click the location of the intermediate points.
 Doubleclick the last point.
 Edit the polygon (optional).
 Click the button (top lefthand corner of the map).
 Exit drawing mode; press the
ESC
key.
Using the search form
To use the search form: complete the inputs, and then click the Search button.
To reset the search form: click the Reset button.
To search by example: click the Example name button.
Search form inputs
The search form inputs are listed in Table 2.
#  Input name  Type  Description  Example 

1  Select  Text  A pandas.DataFrame.eval expression that uses the columns in the dataset.  "(olc_bbox_area  bbox_area) / bbox_area" 
2  As  Text  The column name for the result of evaluating the Select expression.  "x" 
3  With percentiles  Text  The percentiles to be calculated for the values of the As column, e.g., the 50th percentile is the median value.  "5 10" 
4  Where  Text 
A pandas.DataFrame.query boolean expression that uses the columns in the dataset and the following descritive statistics for the values of the As column:

"(the_geom_centroid_olc_ref_cell == bbox_centroid_olc_ref_cell) and (x > @fifth_percentile) and (x <= @tenth_percentile)" 
5  Sort by  Text  The list of columns to sort by, which may, optionally, include the As column.  "x" 
6  Order  Text  Either ascending ASC or descending DESC order. 
"ASC" 
6  Limit  Integer  The number of rows to return.  100 
7  Offset  Integer  The number of rows to skip.  0 