From a 6-row sample across 4 columns.
:@computed_region_f5dn_yrer:@computed_region_efsh_h5xi:@computed_region_sbqj_enih+3:@computed_region_f5dn_yrer:@computed_region_efsh_h5xi:@computed_region_sbqj_enih+3:@computed_region_f5dn_yrer:@computed_region_efsh_h5xi:@computed_region_sbqj_enih+2Mappable — Socrata point column `location`.
Open on the map →| location | estimated_unsheltered_population | total_population | ratio_of_unsheltered_homeless_to_general_population |
|---|---|---|---|
| {"human_address":"{\"address\": \"\", \"city\": \"Chicago *\", \"state\": \"\", \"zip\": \"\"}"} | 1576 | 2836658 | 1 in 1,800 |
| {"human_address":"{\"address\": \"\", \"city\": \"Miami-Dade County\", \"state\": \"\", \"zip\": \"\"}"} | 994 | 2387170 | 1 in 2,402 |
| {"human_address":"{\"address\": \"\", \"city\": \"San Francisco *\", \"state\": \"\", \"zip\": \"\"}"} | 2771 | 764976 | 1 in 276 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
location | coordinate | — | — | — |
estimated_unsheltered_population | categorical | — | 0% | 197699440144of 6 |
total_population | categorical | — | 0% | 827452728366582387170of 6 |
ratio_of_unsheltered_homeless_to_general_population | categorical | — | 0% | 1 in 96 1 in 3,554 1 in 301 of 6 |
GET /api/datasets/x56h-7iwp GET /api/datasets/x56h-7iwp/quality GET /api/datasets/x56h-7iwp/related GET /api/columns?dataset=x56h-7iwp
location_address| {"human_address":"{\"address\": \"\", \"city\": \"Seattle\", \"state\": \"\", \"zip\": \"\"}"} |
| 1976 |
| 594210 |
| 1 in 301 |
| {"human_address":"{\"address\": \"\", \"city\": \"New York City\", \"state\": \"\", \"zip\": \"\"}"} | 2328 | 8274527 | 1 in 3,554 |
| {"human_address":"{\"address\": \"\", \"city\": \"Los Angeles *\", \"state\": \"\", \"zip\": \"\"}"} | 40144 | 3834340 | 1 in 96 |