From a 500-row sample across 12 columns.
latitudelongitudethe_geomMappable — Socrata point column `the_geom`.
Open on the map →| the_geom | treatment_ | unitid | ownership | location | latitude | longitude | point_x | point_y | outfall_ty | of_size | receiving_ |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40.90502, -73.91386 | WI | WIB-053 | DEP | W 255TH STREET (REG # R-3) | 40.9050156 | -73.91386276 | 1008060.7499 | 269011.4699 | CSO | 7' X 4' | HUDSON RIVER |
| 40.89743, -73.91671 | WI |
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.961…{'coordinates': [-73.936…{'coordinates': [-74.129… |
treatment_ | categorical | — | 0% | HPBBOBof 15 |
unitid | text | — | 0% | NR-433TI-308BB-593 |
ownership | categorical | — | 0% | PVTDEPNYSDOT |
GET /api/datasets/8rjn-kpsh GET /api/datasets/8rjn-kpsh/quality GET /api/datasets/8rjn-kpsh/related GET /api/columns?dataset=8rjn-kpsh
latitudelongitude| WIB-054 |
| DEP |
| W 248TH STREET (REG # R-2) |
| 40.89742537 |
| -73.91671232 |
| 1007275.6816 |
| 266245.2733 |
| CSO |
| 8' X 6' |
| HUDSON RIVER |
| 40.89054, -73.90771 | WI | WIB-202 | UNK | — | 40.89053544 | -73.90770752 | 1009767.7894 | 263737.4882 | DIRECT | — | No Data |
| 40.90093, -73.89710 | WI | WIB-203 | UNK | — | 40.90093458 | -73.89710443 | 1012694.9668 | 267529.5825 | DIRECT | — | No Data |
| 40.89773, -73.91484 | WI | WIB-204 | UNK | — | 40.89772922 | -73.9148356 | 1007794.4112 | 266356.4772 | DIRECT | — | HUDSON RIVER |
| 40.91488, -73.91063 | WI | WIB-079 | DEP | 750' n/o W 261st Street (Reg # R-4) | 40.91488473 | -73.91063319 | 1008949.8267 | 272608.1014 | CSO | 18" DIA | HUDSON RIVER |
| 40.91459, -73.91089 | WI | WIB-205 | UNK | — | 40.91458863 | -73.91088951 | 1008879.0908 | 272500.1447 | DIRECT | — | HUDSON RIVER |
| 40.91174, -73.91091 | WI | WIB-159 | UNK | — | 40.91174136 | -73.91090702 | 1008875.3065 | 271462.7617 | GENERAL | — | HUDSON RIVER |
| 40.88847, -73.92008 | WI | WIB-055 | DEP | W 236TH STREET (REG # R-1) | 40.88846926 | -73.92007865 | 1006348.0042 | 262981.3333 | CSO | 6' X 4' 6" | HUDSON RIVER |
| 40.90019, -73.88778 | HP | HP-1131 | NYSDOT | — | 40.90018788 | -73.88777772 | 1015273.6388 | 267260.6971 | HIGHWAY | — | Stream wider than 8 feet |
location | text | — | 14% | BETWEEN 28TH & 29TH STRE…HYLAN BLVDARTHUR KILL RD |
latitude | float | — | 0% | 40.7961691740.6933266740.84123611 |
longitude | float | — | 0% | -73.9533-73.87646111-73.88499167 |
point_x | float | — | 0% | 1034628.87751016254.8441924680.2481 |
point_y | float | — | 0% | 184961.6364191874.51158996.2099 |
outfall_ty | categorical | — | 0% | DIRECTHIGHWAYMS4of 10 |
of_size | text | — | 16% | 6" DIA4" DIA8" DIA |
receiving_ | text | — | 6% | EAST RIVERHUDSON RIVERHARLEM RIVER |