From a 500-row sample across 9 columns.
| route__id | route_name | sector | property_number | property_sequence | route_updated_date | property_updated | route_active | property_active |
|---|---|---|---|---|---|---|---|---|
| 4 | X Sector A Route 1 | X-SA | X030-99 | 1 | 2016-01-21T16:44:00.000 | NULL | 1 | 1 |
| 4 | X Sector A Route 1 | X-SA | X168 | 2 | 2016-01-21T16:44:00.000 | NULL |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
route__id | text | Unique identification number of the route for which a property or portion of a property belongs. | 0% | 2502591318 |
route_name | text | The name given to a route. | 0% | Green StreetsGreenstreetsQ Sector C Route 3 |
sector | text | The sector to which the route belongs. | 0% | X-SEB-SDR-SA |
property_number | text | Unique identification number for a property or portion of a property. In some cases – a standalone, smaller park for example – this number will be equivalent to the GIS Property Number. In other cases – a zone, playground or other site within a larger park – an additional designation of letters and/or numbers will be added. | 0% |
GET /api/datasets/752y-qk8b GET /api/datasets/752y-qk8b/quality GET /api/datasets/752y-qk8b/related GET /api/columns?dataset=752y-qk8b
| 1 |
| 1 |
| 4 | X Sector A Route 1 | X-SA | X287 | 3 | 2016-01-21T16:44:00.000 | 2015-10-06T09:48:00.000 | 1 | 1 |
| 4 | X Sector A Route 1 | X-SA | X148A2 | 4 | 2016-01-21T16:44:00.000 | 2015-10-06T09:48:00.000 | 1 | 1 |
| 4 | X Sector A Route 1 | X-SA | X148A3 | 5 | 2016-01-21T16:44:00.000 | 2015-10-06T09:48:00.000 | 1 | 1 |
| 4 | X Sector A Route 1 | X-SA | X153-01 | 6 | 2016-01-21T16:44:00.000 | 2015-10-06T09:48:00.000 | 1 | 1 |
| 4 | X Sector A Route 1 | X-SA | X153-02 | 7 | 2016-01-21T16:44:00.000 | 2015-10-06T09:48:00.000 | 1 | 1 |
| 4 | X Sector A Route 1 | X-SA | X120 | 8 | 2016-01-21T16:44:00.000 | 2015-10-06T09:48:00.000 | 1 | 1 |
| 4 | X Sector A Route 1 | X-SA | X269 | 9 | 2016-01-21T16:44:00.000 | 2015-10-06T09:48:00.000 | 1 | 1 |
| 4 | X Sector A Route 1 | X-SA | X067 | 10 | 2016-01-21T16:44:00.000 | NULL | 1 | 1 |
NULLMZ392M011 |
property_sequence | text | The general order in which a property or portion of a property appears for a given route. | 0% | 123 |
route_updated_date | datetime | The date the route was last updated. | 0% | NULL2015-10-22T14:40:00.0002016-05-24T11:21:00.000 |
property_updated | datetime | The date the property was reordered, added to, or removed from the route. | 0% | NULL2016-03-02T12:47:00.0002016-05-24T11:21:00.000 |
route_active | categorical | A binary indicator of whether a route is currently active. | 0% | 10of 2 |
property_active | categorical | A binary indicator of whether a property is currently active for a given route. | 0% | 10NULLof 3 |