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 Well-known 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.2491435199277467e-08 |
| 3 | the_geom_centroid (text) |
The centroid of the base geometry (a POINT in Well-known Text format). |
"POINT (-122.4949675314404 37.73208033387407)" |
| 4 | the_geom_centroid_ubid_inf (text) |
The informative UBID for the the base geometry. | "849VPGJ4+R2M-849VPGJ3+RXW-849VPGJ4+R29" |
| 5 | the_geom_centroid_ubid_rep (text) |
The representative UBID for the the base geometry. | "849VPGJ4+R2M-1-2-2-3" |
| 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 Well-known 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.3135741362971848e-08 |
| 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 anti-clockwise rotation. |
-1 |
| 18 | bbox (text) |
The bounding box for the base geometry (a POLYGON in Well-known 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.4511483876275387e-08 |
| 20 | bbox_centroid (text) |
The centroid of the bounding box for the base geometry (a POINT in Well-known 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+R2M-849VPGJ3+RXW-849VPGJ4+R29" |
| 22 | bbox_centroid_ubid_rep (text) |
The representative UBID for the bounding box for the base geometry. | "849VPGJ4+R2M-1-2-2-3" |
| 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 Well-known 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.87499999959158e-08 |
| 40 | olc_bbox_centroid (text) |
The centroid of the Open Location Code bounding box for the base geometry (a POINT in Well-known 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+R2M-849VPGJ3+RXW-849VPGJ4+R25" |
| 42 | olc_bbox_centroid_ubid_rep (text) |
The representative UBID for the Open Location Code bounding box for the base geometry. | "849VPGJ4+R2M-1-2-3-3" |
| 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 left-hand 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.
- Double-click the last point.
- Edit the polygon (optional).
- Click the
button (top left-hand corner of the map).
- Exit drawing mode; press the
ESCkey.
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 |