From a 500-row sample across 10 columns.
:@computed_region_yeji_bk3q:@computed_region_92fq_4b7q:@computed_region_f5dn_yrer+1Mappable — Socrata point column `the_geom`.
Open on the map →| the_geom | unitid | latitude | longitude | point_x | point_y | :@computed_region_f5dn_yrer | :@computed_region_yeji_bk3q | :@computed_region_sbqj_enih | :@computed_region_92fq_4b7q |
|---|---|---|---|---|---|---|---|---|---|
| 40.74171, -73.78500 | CB422934 | 40.74170533 | -73.78500418 | 1043826.86556 | 209572.985386 | 26 | 3 | 69 | 3 |
| 40.70497, -73.80925 | CB460384 | 40.70497191 | -73.80924644 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | coordinate | Geometry column used for mapping this data | 0% | {'coordinates': [-74.191…{'coordinates': [-74.074…{'coordinates': [-73.918… |
unitid | text | Catch Basin ID | 0% | CB509335CB101710CB458923 |
latitude | float | Latitude of the site's location | 0% | 40.6983340.690840.66654 |
longitude | float | Longitude of the site's location | 0% |
GET /api/datasets/2w2g-fk3i GET /api/datasets/2w2g-fk3i/quality GET /api/datasets/2w2g-fk3i/related GET /api/columns?dataset=2w2g-fk3i
longitudelatitude:@computed_region_yeji_bk3q| 1037138.3166 |
| 196174.340154 |
| 41 |
| 3 |
| 61 |
| 24 |
| 40.78610, -73.79321 | CB418594 | 40.78610054 | -73.79321304 | 1041513.95225 | 225742.103405 | 22 | 3 | 67 | 20 |
| 40.68284, -73.81333 | CB402561 | 40.68284001 | -73.81332519 | 1036024.62896 | 188108.620986 | 62 | 3 | 64 | 46 |
| 40.58184, -74.11132 | CB511457 | 40.58184005 | -74.11131613 | 953329.472971 | 151276.098566 | 30 | 1 | 76 | 14 |
| 40.70264, -73.74799 | CB448485 | 40.70263543 | -73.74799024 | 1054124.6136 | 195366.017351 | 63 | 3 | 63 | 6 |
| 40.73440, -73.90188 | CB431561 | 40.73439529 | -73.90188461 | 1011441.47456 | 206851.823102 | 53 | 3 | 66 | 34 |
| 40.72751, -73.87531 | CB427063 | 40.72751088 | -73.87530897 | 1018810.1521 | 204352.986842 | 54 | 3 | 62 | 34 |
| 40.57462, -74.10236 | CB510165 | 40.5746191 | -74.10235768 | 955814.805053 | 148642.295038 | 30 | 1 | 76 | 14 |
| 40.66738, -73.82490 | CB401948 | 40.66737992 | -73.82490054 | 1032825.44604 | 182469.448353 | 62 | 3 | 64 | 41 |
-73.7434-73.7432-73.7433point_x | float | X Coordinate | 0% | 1037462.1321998198.0610151035031.25282 |
point_y | float | Y Coordinate | 0% | 209406.741978202259.154365216616.848111 |