From a 500-row sample across 8 columns.
xthe_geomlat+2xthe_geomlat+2xthe_geomlat+2xthe_geomlat+2Mappable — Socrata point column `the_geom`.
Open on the map →| the_geom | main_street | cross_stree | install_da | long | lat | x | y |
|---|---|---|---|---|---|---|---|
| 40.61847, -74.02122 | 86 Street | 7 Avenue | 2020-06-04T00:00:00 | -74.0212160564291 | 40.6184716641775 | 978360.000285134 | 164603.000240222 |
| 40.61673, -74.01833 | 86 Street | 11 Avenue | 2020-06-04T00:00:00 | -74.0183267364981 | 40.6167264729284 | 979161.999993473 | 163967.000199899 |
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.959…{'coordinates': [-73.927…{'coordinates': [-73.947… |
main_street | text | — | 0% | 3 AvenueBroadway5 Avenue |
cross_stree | text | — | 0% | Bergen StreetDean StreetGates Avenue |
install_da | datetime | — | 0% | 2018-10-28T00:00:00 |
GET /api/datasets/xc4v-ntf4 GET /api/datasets/xc4v-ntf4/quality GET /api/datasets/xc4v-ntf4/related GET /api/columns?dataset=xc4v-ntf4
xthe_geomlat+2xthe_geomlat+2xthe_geomlat+2xthe_geomlat+2| 40.61538, -74.01612 | 86 Street | 12 Avenue | 2020-06-04T00:00:00 | -74.0161184149984 | 40.6153845999937 | 979775.000079811 | 163478.000193641 |
| 40.61405, -74.01391 | 86 Street | 13 Avenue | 2020-06-04T00:00:00 | -74.0139065827685 | 40.6140536640395 | 980389.000164136 | 162993.000179395 |
| 40.61273, -74.01171 | 86 Street | 14 Avenue | 2020-06-04T00:00:00 | -74.0117128493109 | 40.6127336626656 | 980998.000258476 | 162512.000157148 |
| 40.60461, -73.99825 | 86 Street | 20 Avenue | 2020-06-04T00:00:00 | -73.9982533698862 | 40.60460965297 | 984735.00000231 | 159552.000171646 |
| 40.59925, -73.98940 | 86 Street | 24 Avenue | 2020-06-04T00:00:00 | -73.9893950245534 | 40.5992540781763 | 987195.000003561 | 157601.000136644 |
| 40.59793, -73.98719 | 86 Street | 25 Avenue | 2020-06-04T00:00:00 | -73.9871914607863 | 40.5979253715356 | 987807.000091881 | 157117.000120386 |
| 40.59400, -73.98071 | 86 Street | Avenue V | 2020-06-04T00:00:00 | -73.9807109059945 | 40.5939966595826 | 989607.000100806 | 155686.000029638 |
| 40.61229, -74.01097 | 86 Street | Bay 7 Street | 2020-06-04T00:00:00 | -74.0109708181758 | 40.6122863344603 | 981204.000174552 | 162349.000155061 |
2019-06-08T00:00:002019-06-01T00:00:00long | coordinate | — | 0% | -73.8967082631757-73.9758463897239-73.9251604094784 |
lat | coordinate | — | 0% | 40.753676707938140.639643841551140.8473669002584 |
x | coordinate | — | 0% | 998030.999985054988145.000072047998910.999865472 |
y | coordinate | — | 0% | 205859.000077143188618.000110388212666.99991256 |