From a 500-row sample across 7 columns.
the_geomyx+2the_geomydate+3the_geomyx+2the_geomyx+2Mappable — Socrata point column `the_geom`.
Open on the map →| the_geom | total_flyer | date | long | lat | x | y |
|---|---|---|---|---|---|---|
| 40.67012, -73.95527 | 560.0 | 10/21/2019 | -73.9552711851581 | 40.6701245162883 | 996658.000106394 | 183423.999999732 |
| 40.68944, -73.95512 | 940.0 | 10/22/2019 | -73.9551212015388 | 40.6894449194852 | 996696.000030383 | 190463.000029311 |
| 40.67872, -73.95299 | 1075.0 | 10/23/2019 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | coordinate | — | 0% | {'coordinates': [-73.852…{'coordinates': [-74.162…{'coordinates': [-74.109… |
total_flyer | integer | — | 0% | 0.032003800 |
date | text | — | 0% | 10/30/201910/24/20197/13/2022 |
long | coordinate | — | 0% | -73.852163876414-74.1097619144324 |
GET /api/datasets/j62s-m9yf GET /api/datasets/j62s-m9yf/quality GET /api/datasets/j62s-m9yf/related GET /api/columns?dataset=j62s-m9yf
the_geomyx+2the_geomyx+2the_geomthe_geom| -73.952986867156 |
| 40.6787229868888 |
| 997290.000154719 |
| 186556.999967307 |
| 40.67703, -73.95268 | 625.0 | 10/24/2019 | -73.9526780155592 | 40.6770265895432 | 997375.999982715 | 185938.999890983 |
| 40.67703, -73.95268 | 360.0 | 10/24/2019 | -73.9526780155592 | 40.6770265895432 | 997375.999982715 | 185938.999890983 |
| 40.67066, -73.95797 | 6300 | 10/26/2019 | -73.9579744772891 | 40.6706580220649 | 995907.999965966 | 183617.999939814 |
| 40.75550, -73.96807 | 955.0 | 10/28/2019 | -73.9680671322999 | 40.7555045918697 | 993097.00001055 | 214529.000125557 |
| 40.72860, -73.98767 | 555.0 | 10/29/2019 | -73.9876714651285 | 40.7285960765482 | 987667.000043809 | 204724.00005056 |
| 40.73235, -73.98495 | 460.0 | 10/30/2019 | -73.9849465779765 | 40.7323505774347 | 988421.999846131 | 206091.999939233 |
| 40.74259, -73.98041 | 420.0 | 10/30/2019 | -73.9804116652499 | 40.742587822795 | 989677.999958798 | 209822.000025138 |
-74.162421363317lat | coordinate | — | 0% | 40.693662515407140.607190292341540.5704668030309 |
x | coordinate | — | 0% | 1025246.00001688939150.999963135953755.999952555 |
y | coordinate | — | 0% | 192030.999846056160533.999848053147132.000077307 |