From a 500-row sample across 36 columns.
addressgisobjidwaterfront+17the_geomaddressthe_geomboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| the_geom | gispropnum | objectid | omppropid | department | permitdist | permitpare | parentid | location | communityb | councildis | precinct |
|---|---|---|---|---|---|---|---|---|---|---|---|
| NaN, NaN | R145 | 6367 | R145 | R-03 | R-03 | R-03 | R-03 | Nelson Ave., Tennyson Dr. and Bulkhead Line | 503 | 51 | 122 |
| {"type":"MultiPolygon","coordinates":[[[[-73.90748556731788,40.75708917875267],[-73.90767966215755,40.757071748493715],[-73.90757282834349,40.757356495426514],[-73.90754040000033,40.75736019659576],[-73.90748556731788,40.75708917875267]]]]} |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | — | — | — |
gispropnum | text | — | 0% | Q106Q316Q336 |
objectid | integer | — | 0% | 663966694773 |
omppropid | text | — | 0% | Q106Q316Q336 |
department | text | — | 0% | M-03 |
GET /api/datasets/ghu2-eden GET /api/datasets/ghu2-eden/quality GET /api/datasets/ghu2-eden/related GET /api/columns?dataset=ghu2-eden
the_geomaddressborough| Q355 |
| 5916 |
| Q355 |
| Q-01 |
| Q-01 |
| Q-01 |
| Q-01 |
| 31 Ave., 51 St., 54 St. |
| 401 |
| 22 |
| 114 |
| {"type":"MultiPolygon","coordinates":[[[[-74.00468042094083,40.6558401856359],[-74.00492023725671,40.655613945962095],[-74.00554383343307,40.655990645250085],[-74.00507887526457,40.65643331219284],[-74.00428598378717,40.65595404255754],[-74.00451351598763,40.655739394745304],[-74.00468042094083,40.6558401856359]]]]} | B210B | 5465 | B210B | B-07 | B-07 | B-07 | B-07 | 3 Ave. bet. 35 St. and 34 St. | 307 | 38 | 72 |
| NaN, NaN | X262 | 4857 | X262 | X-09 | X-09 | X-09 | X-09 | Bolton Ave. bet. O'Brien Ave. and G St. | 209 | 18 | 43 |
| NaN, NaN | X188 | 6621 | X188 | X-12 | X-12 | X-12 | X-12 | Matilda Ave. to Carpenter Ave. bet. E. 239 St. and E. 240 St. | 212 | 11 | 47 |
| {"type":"MultiPolygon","coordinates":[[[[-73.93181660333437,40.69727087030175],[-73.93170310497646,40.6972921793766],[-73.9317693674725,40.697245647764824],[-73.93181660333437,40.69727087030175]]]]} | B037 | 5719 | B037 | B-04 | B-04 | B-04 | B-04 | Bushwick Ave., Myrtle Ave., Willoughby Ave. | 304 | 34 | 83 |
| NaN, NaN | Q094 | 6170 | Q094 | Q-10 | Q-10 | Q-10 | Q-10 | N. Conduit Ave., 133 Ave. bet. 80 St. and 88 St. | 410 | 32 | 106 |
| {"type":"MultiPolygon","coordinates":[[[[-73.99479706266717,40.70052351987295],[-73.99483132983104,40.700450397138404],[-73.9951730570268,40.70054785458263],[-73.99517335519373,40.70054793924326],[-73.9950166181056,40.70087771897064],[-73.99467583232673,40.7007822116187],[-73.99479706266717,40.70052351987295]]]]} | B223H | 5111 | B223H | B-02 | B-02 | B-02 | B-02 | Columbia Hts. at Middagh St. | 302 | 33 | 84 |
| {"type":"MultiPolygon","coordinates":[[[[-73.97063986586979,40.68998446082801],[-73.97109799203454,40.689932200243106],[-73.97121904191744,40.690542861410925],[-73.97080586384634,40.69059547698163],[-73.97086691936669,40.69092155387264],[-73.97055639274205,40.69095754669947],[-73.9703704564564,40.69001519293484],[-73.97063986586979,40.68998446082801]]]]} | B253 | 4660 | B253 | B-02 | B-02 | B-02 | B-02 | Adelphi St., Clermont Ave., Dekalb Ave., Willoughby Ave. | 302 | 35 | 88 |
| {"type":"MultiPolygon","coordinates":[[[[-73.94877722234759,40.68951307615012],[-73.94883383062528,40.68950658521787],[-73.94888770519606,40.68978214555376],[-73.94883814228803,40.68978782828225],[-73.94889302936593,40.69006856790842],[-73.94882114855358,40.69007684590112],[-73.94863075908323,40.69009877322171],[-73.94827671890656,40.690139547476555],[-73.94819798322438,40.68974603363575],[-73.94816540596942,40.68958322415019],[-73.94852197384768,40.689542342404884],[-73.94861646381874,40.689531508232804],[-73.94871238062015,40.68952051072556],[-73.94877722234759,40.68951307615012]]]]} | B400 | 6424 | B400 | B-03 | B-03 | B-03 | B-03 | Marcy Ave between Clifton Pl. and Lafayette Ave. | 303 | 36 | 79 |
Showing 12 of 36 columns. All of them are listed below.
B-01B-03permitdist | text | — | 2% | M-03B-01B-05 |
permitpare | text | — | 2% | M-03B-01B-05 |
parentid | text | — | 0% | M-03B-01B-05 |
location | text | — | 0% | Hoyt Ave. bet. 21 St. an…East RiverMadison Ave. bet. E. 110… |
communityb | text | — | 0% | 103301303 |
councildis | text | — | 0% | 17833 |
precinct | text | — | 2% | 7512090 |
zipcode | text | — | 0% | 112071121110009 |
borough | categorical | — | 0% | BQXof 5 |
acres | float | — | 0% | 10.10.057 |
retired | text | — | 0% | Falseof 1 |
eapply | text | — | 4% | ParkStripBrooklyn Heights Promena… |
pip_ratabl | categorical | — | 2% | YesNoof 2 |
gisobjid | integer | — | 0% | 100008318100024463100004168 |
class | categorical | — | 0% | PARKPLGDZONEof 3 |
commission | coordinate | — | 9% | 20100106000000.0000020090423000000.0000020110712000000.00000of 18 |
acquisitio | coordinate | — | 4% | 20021120000000.0000019990712000000.0000020160209000000.00000 |
address | text | — | 46% | 68 COLUMBIA HEIGHTS215 BROADWAY8301 SHORE ROAD |
jurisdicti | text | — | 0% | DPRDPR/DOEDPR/CDOT |
mapped | categorical | — | 0% | FalseTruePartof 6 |
name311 | text | — | 0% | ParkGardenBrooklyn Heights Promena… |
permit | categorical | — | 5% | YNNoof 4 |
signname | text | — | 0% | ParkBrooklyn Heights Promena…LaGuardia Landing Lights |
subcategor | text | — | 7% | Neighborhood PlgdSitting Area/Triangle/Ma…JOP |
typecatego | categorical | — | 0% | GardenTriangle/PlazaNeighborhood Parkof 19 |
url | url | — | 5% | http://www.nycgovparks.o…http://www.nycgovparks.o…http://www.nycgovparks.o… |
waterfront | categorical | — | 0% | NoYesof 2 |
nys_assemb | text | — | 0% | 557952 |
nys_senate | text | — | 0% | 262529 |
us_congres | text | — | 0% | 15811 |
global_id | text | — | 0% | {64F849CE-71DF-4116-AB9C…{D9B7AAD0-A45A-4A65-956B…{8484CBFB-8AB5-4137-ACE5… |