From a 500-row sample across 30 columns.
objectidsosindicatorcreated_date+5:@computed_region_sbqj_enih:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+2:@computed_region_sbqj_enih:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+2zipcodeMappable — Socrata point column `the_geom`.
Open on the map →| the_geom | bin | zipcode | post_type | :@computed_region_f5dn_yrer | :@computed_region_yeji_bk3q | :@computed_region_sbqj_enih | :@computed_region_92fq_4b7q | objectid | addresspointid | house_number | hyphen_type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40.67865, -73.99505 | 3007859 | 11231 | ST | 14 | 2 | 48 | 27 | 1676115 | 3009955 | 19 | N |
| 40.64676, -73.90430 |
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.980…{'coordinates': [-73.775…{'coordinates': [-74.149… |
bin | integer | Building identification number (BIN) associated with the Address Point. | 0% | 332683010791843337867 |
zipcode | text | Five-digit postal zip codes. | 0% | 103141123410312 |
pre_type | categorical | — | 98% | AVE |
GET /api/datasets/uf93-f8nk GET /api/datasets/uf93-f8nk/quality GET /api/datasets/uf93-f8nk/related GET /api/columns?dataset=uf93-f8nk
:@computed_region_sbqj_enih:@computed_region_yeji_bk3qobjectidthe_geombinhouse_numberstreet_name| 3229057 |
| 11236 |
| PKWY |
| 5 |
| 2 |
| 42 |
| 25 |
| 1794531 |
| 3286270 |
| 1346 |
| N |
| 40.61426, -74.06609 | 5042131 | 10305 | ST | 4 | 1 | 74 | 13 | 1794068 | 5121890 | 1191 | N |
| 40.76383, -73.87631 | 4032549 | 11369 | ST | 65 | 3 | 73 | 21 | 1789007 | 36957 | 25-07 | Q |
| 40.75314, -73.71763 | 4456538 | 11004 | AVE | 63 | 3 | 63 | 16 | 1794173 | 193787 | 261-03 | Q |
| 40.73822, -74.00261 | 1078162 | 10014 | ST | 57 | 4 | 3 | 10 | 1785927 | 1013892 | 7 | N |
| 40.73049, -73.89937 | 4054993 | 11378 | ST | 54 | 3 | 62 | 34 | 1794325 | 61505 | 53-30 | Q |
| 40.83985, -73.83522 | 2074196 | 10461 | AVE | 43 | 5 | 28 | 12 | 1785644 | 2103817 | 2821 | N |
| 40.61980, -74.03735 | 3155005 | 11209 | ST | 10 | 2 | 41 | 44 | 1785732 | 3316047 | 101 | N |
| 40.65088, -73.95601 | 3116870 | 11226 | AVE | 60 | 2 | 43 | 11 | 1794306 | 3317983 | 2180 | N |
Showing 12 of 23 columns. All of them are listed below.
BCHPTpost_type | text | — | 2% | STAVERD |
objectid | integer | — | 0% | 969262969263969264 |
addresspointid | integer | — | 0% | 52177381340 |
complexid | integer | — | 99% | 515363560 |
house_number | text | — | 0% | 152016 |
house_number_suffix | text | — | 98% | AB1/2 |
hyphen_type | categorical | — | 0% | NQRof 5 |
sosindicator | categorical | — | 0% | 21of 2 |
special_condition | categorical | — | 99% | ABSof 10 |
address_source | categorical | — | 0% | 413of 6 |
address_status | categorical | — | 92% | 432of 5 |
validation | categorical | — | 0% | 325of 5 |
boroughcode | categorical | — | 0% | 435of 5 |
collectionmethod | categorical | — | 0% | AFOof 4 |
created_date | datetime | — | 0% | 2008-09-23T00:00:00.000Z2009-02-13T00:00:00.000Z2009-02-20T00:00:00.000Z |
modified_date | datetime | — | 71% | 2009-06-26T00:00:00.000Z2010-05-26T00:00:00.000Z2010-05-27T00:00:00.000Z |
b7sc_actual | text | — | 0% | 113610013186300145109001 |
b7sc_vanity | text | — | 100% | 110410011296900112779001 |
a4id | integer | — | 99% | 0224012943 |
street_name | text | — | 0% | 35BROADWAY |
house_number_range | text | — | 98% | 12911 |
house_number_range_suffix | categorical | — | 100% | BCDof 5 |
pre_modifier | categorical | — | 100% | OLDLITTLEof 2 |
pre_directional | categorical | — | 88% | EWNof 4 |
post_directional | categorical | — | 99% | SEWof 5 |
post_modifier | text | — | 100% | BOULEVARDEDGEWATR CEDGEWATR B |
full_street_name | text | — | 0% | BROADWAY3 AVE78 ST |