From a 500-row sample across 38 columns.
the_geomzipcodezipcodestatusthe_geomzipcodestatusboroughprecinctglobal_iddepartmentHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| the_geom | gispropnum | objectid | system | omppropid | department | parentid | location | communityb | councildis | precinct | zipcode |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiPolygon","coordinates":[[[[-73.80908476279508,40.750221309482264],[-73.80892274905989,40.75021223836881],[-73.80910312024916,40.75009811077937],[-73.80908476279508,40.750221309482264]]]]} | QZ356 | 5492 | QZ356 | QZ356 | Q-07 | Q-07 | Oak St & Quince Av & 158 St | 407 | 20 | 109 | 11355 |
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% | M096Q099MZ01 |
objectid | integer | — | 0% | 810066696910 |
system | text | — | 0% | QZ573MZ217MZ01-MZ257 |
omppropid | text | — | 0% | QZ573 |
GET /api/datasets/aaqu-mkmi GET /api/datasets/aaqu-mkmi/quality GET /api/datasets/aaqu-mkmi/related GET /api/columns?dataset=aaqu-mkmi
zipcodeacresstatus| {"type":"MultiPolygon","coordinates":[[[[-73.91233892722258,40.75592191717443],[-73.91234567406961,40.75592161433554],[-73.91235177079075,40.755922207004716],[-73.912358200157,40.755923789582326],[-73.91236413218347,40.75592625067476],[-73.91236485172679,40.75592659791682],[-73.91248756235582,40.75598583281292],[-73.9124981806153,40.75599167435455],[-73.91250291031619,40.755996213794006],[-73.91250625717298,40.75600141495513],[-73.91250837484785,40.756007494976565],[-73.91250878087286,40.75601302619059],[-73.91250808692752,40.75601753179371],[-73.91250644698177,40.75602189619944],[-73.91249999615918,40.75603032723648],[-73.91243579910552,40.75610667195013],[-73.91243147011748,40.75610989607156],[-73.91242549569571,40.756112645276],[-73.91242017447667,40.75611396047126],[-73.91241367030077,40.7561143193304],[-73.91240677571808,40.75611348562285],[-73.91240122180675,40.75611164436812],[-73.9123959962201,40.75610867683025],[-73.91235087381754,40.75603870293593],[-73.91230926045584,40.75595154104167],[-73.91230916954244,40.75594593802635],[-73.91231041724252,40.75594088894047],[-73.91231327561712,40.75593572761695],[-73.91231734479534,40.75593105528902],[-73.91232127790283,40.75592809561914],[-73.91232733460473,40.75592490433439],[-73.91233294671692,40.75592300043408],[-73.91233892722258,40.75592191717443]]]]} | Q254 | 5493 | Q254-QZ111 | QZ111 | Q-01 | Q254 | Broadway & Newtown Rd & 48 St | 401 | 26 | 114 | 11377 |
| {"type":"MultiPolygon","coordinates":[[[[-73.9050823621089,40.74534074075218],[-73.90506692330663,40.745350112212336],[-73.90440049669287,40.7454082173188],[-73.90449336752448,40.74518305592691],[-73.90499601884096,40.74531720685127],[-73.9050823621089,40.74534074075218]]]]} | Q198 | 5494 | Q198-QZ118 | QZ118 | Q-02 | Q198 | Roosevelt Av & 60 Street & Woodside Avenue | 402 | 26 | 108 | 11377 |
| {"type":"MultiPolygon","coordinates":[[[[-73.94544318020091,40.746025894428094],[-73.94546031317626,40.746020113185004],[-73.94546058676328,40.7460200214629],[-73.9454627820646,40.74601989733197],[-73.94546491083517,40.74602004782405],[-73.94546557381013,40.74602015079571],[-73.94546693409256,40.74602036215831],[-73.9454692331945,40.746020719847486],[-73.9454717829756,40.74602148828631],[-73.94547458225846,40.7460226593697],[-73.94547642621023,40.74602360487407],[-73.94547764149384,40.746024484343884],[-73.9454785572633,40.74602530693998],[-73.94547991080333,40.74602652326464],[-73.94548130812024,40.74602777923234],[-73.94548247653914,40.74602949885263],[-73.94548264676003,40.746029841125676],[-73.94548308649999,40.74603072202937],[-73.945483757929,40.74603206950509],[-73.94548412426697,40.74603294046844],[-73.9454846500759,40.746035715178316],[-73.94548460873334,40.746037041605035],[-73.94548445996489,40.74603797536002],[-73.94548417908857,40.74603974022013],[-73.94546237023539,40.74610931024311],[-73.94545945689187,40.746111507900785],[-73.94544480249886,40.74612256188357],[-73.94540742803,40.74611578497183],[-73.94539986238851,40.74613991946607],[-73.94531522711114,40.74613024749448],[-73.94531324449092,40.74613956409535],[-73.94531018379337,40.74615394283261],[-73.94515027840123,40.74614680862275],[-73.94515394767618,40.74613105420534],[-73.94522398897044,40.74610558879066],[-73.9452420295966,40.74609902907354],[-73.94542634768987,40.74603201440148],[-73.94544318020091,40.746025894428094]]]]} | Q072 | 5497 | Q072-QZ810 | QZ810 | Q-02 | Q072 | Jackson Av, 45 Rd, 23 St | 402 | 26 | 108 | 11101 |
| {"type":"MultiPolygon","coordinates":[[[[-73.8621340910289,40.74978963293992],[-73.86261456018734,40.74963662012937],[-73.86260489426641,40.74978307698234],[-73.86260338301362,40.74978324087297],[-73.86214336556363,40.749833381670605],[-73.8621340910289,40.74978963293992]]]]} | Q172 | 5501 | Q172-QZ944 | QZ944 | Q-04 | Q172 | Roosevelt & National Avs | 404 | 21 | 110 | 11368 |
| {"type":"MultiPolygon","coordinates":[[[[-73.85042494208365,40.75116027133902],[-73.85043120762214,40.75116171038079],[-73.8504343409283,40.75116219081758],[-73.8504368412972,40.751165054074846],[-73.8504380835117,40.75117029934081],[-73.85043464409449,40.751306159787084],[-73.85042394639625,40.75132473776587],[-73.85040009534357,40.7513380550084],[-73.85036561723413,40.75133848659267],[-73.85035308612291,40.751335610302775],[-73.85034682163992,40.75133369488992],[-73.85026555933786,40.751231571732625],[-73.85026182963134,40.75121774229884],[-73.85026560755566,40.7512101199146],[-73.85027126372539,40.751203453608774],[-73.85042494208365,40.75116027133902]]]]} | Q099 | 5502 | Q099-QZ939 | QZ939 | Q-04 | Q099 | Meridian Rd Triangle | 481 | 21 | 110 | 11368 |
| {"type":"MultiPolygon","coordinates":[[[[-73.88879228428048,40.72743453572604],[-73.88879332357924,40.727434532227235],[-73.88879436283585,40.727434553942665],[-73.8887954008607,40.72743460447322],[-73.88879643528935,40.727434682015534],[-73.88879746612031,40.7274347874702],[-73.88879849217288,40.72743491903498],[-73.88879950989599,40.727435076706534],[-73.88880052165545,40.72743526138756],[-73.88880152271656,40.727435473073534],[-73.88880251544666,40.727435711766745],[-73.88880349511544,40.72743597476109],[-73.88880446408888,40.7274362629594],[-73.8888054188143,40.727436577258686],[-73.8888063581095,40.727436916757334],[-73.88880728079381,40.727437279653174],[-73.8888081868642,40.727437667747246],[-73.88880907632524,40.72743807833803],[-73.88880994562423,40.72743851232256],[-73.88881079476428,40.72743896789982],[-73.88881162256003,40.72743944596923],[-73.88881242901165,40.72743994653078],[-73.88881321057244,40.72744046687949],[-73.8888139696068,40.72744100881865],[-73.88881470375343,40.72744156874396],[-73.88881541182697,40.72744214755479],[-73.88881609264385,40.72744274525002],[-73.88881674620553,40.727443360929115],[-73.88881737251499,40.72744399279106],[-73.88881796920482,40.7274446408336],[-73.88881853627656,40.72744530415615],[-73.88884892171659,40.727482368747246],[-73.88888039152476,40.72752081755923],[-73.88891340536456,40.72756113190669],[-73.88891380579551,40.727561639279884],[-73.88891418490172,40.727562157438584],[-73.88891453794996,40.727562685477785],[-73.88891486849127,40.72756322340085],[-73.88891517416424,40.72756376760349],[-73.88891545496445,40.72756432078722],[-73.88891570971263,40.7275648802494],[-73.88891593840727,40.72756544689054],[-73.88891614223509,40.72756601891071],[-73.88891632001389,40.72756659540831],[-73.88891647055844,40.72756717728271],[-73.88891659505552,40.727567762734],[-73.88891669350807,40.727568349961174],[-73.88891676354567,40.72756894076301],[-73.88891680754182,40.7275695315397],[-73.88891682549335,40.72757012409229],[-73.88891681503301,40.727570718418484],[-73.88891677735346,40.727571309116335],[-73.88891671363236,40.727571899789126],[-73.88891662387273,40.72757248863575],[-73.88891650570872,40.72757307475346],[-73.88891636151064,40.727573656343516],[-73.8889161924593,40.727574235208046],[-73.88891599500799,40.72757480864212],[-73.88891577270789,40.72757537664918],[-73.88891552437826,40.72757593742704],[-73.88891525119982,40.72757649277787],[-73.88891495080966,40.72757703999784],[-73.88891462794264,40.72757757909154],[-73.88891428023126,40.72757811005671],[-73.8889139076801,40.72757863019182],[-73.88891351265502,40.727579140399634],[-73.88891309397233,40.72757964067897],[-73.88891265400248,40.72758012923118],[-73.88891219156172,40.727580606055085],[-73.88891170665003,40.72758107115068],[-73.88891120164094,40.72758152091822],[-73.88891067652679,40.72758195986024],[-73.88891013131818,40.727582381673216],[-73.88890956718977,40.72758279176127],[-73.88890898533282,40.72758318562311],[-73.88890838574729,40.72758356325863],[-73.88890776843168,40.72758392556838],[-73.88890713693861,40.727584271655275],[-73.88890648890221,40.72758460061654],[-73.88890582550619,40.727584912453274],[-73.88890514912082,40.72758520536675],[-73.8889044597418,40.727585482058586],[-73.88890375855716,40.7275857398283],[-73.88890304556706,40.727585978675904],[-73.88890232195511,40.727586198602566],[-73.888901588905,40.7275863996094],[-73.88890084878574,40.72758658079824],[-73.8889000992268,40.72758674396771],[-73.88889934260321,40.727586884617665],[-73.88889858009104,40.72758700725173],[-73.88889781169495,40.72758710916844],[-73.88889704096444,40.727587191271624],[-73.88889626553511,40.72758725175809],[-73.88889548895516,40.727587292432176],[-73.88889471004076,40.727587313292844],[-73.88886972270677,40.72758758364612],[-73.8888605949736,40.72758768199692],[-73.88884220810985,40.727587882171576],[-73.88883998506702,40.727587906140286],[-73.88878114546523,40.727588534609886],[-73.88872230704456,40.727589163951066],[-73.88866346743754,40.727589794161574],[-73.88861229720924,40.727590341710396],[-73.88860462665018,40.72759042163934],[-73.88860382894994,40.727590350627835],[-73.88860303483544,40.72759025890813],[-73.88860224430971,40.727590144679134],[-73.8886014597371,40.72759000974419],[-73.88860068229835,40.72758985590543],[-73.88859991318168,40.72758968046244],[-73.88859915120037,40.727589485215226],[-73.88859839872185,40.7275892701659],[-73.88859765692827,40.727589036216294],[-73.88859692582113,40.72758878246575],[-73.88859620658272,40.72758850981603],[-73.88859550039818,40.72758821736771],[-73.88859480844825,40.727587906922956],[-73.88859412954916,40.72758757848066],[-73.88859346725057,40.72758723294472],[-73.88859282037028,40.72758686941351],[-73.88859219008744,40.72758649058967],[-73.88859157877403,40.72758609377401],[-73.88859098405959,40.72758568076524],[-73.88859040949072,40.72758525426829],[-73.88858985388828,40.72758481158055],[-73.88858931961514,40.72758435540578],[-73.88858880667128,40.72758388574401],[-73.88858831387451,40.72758340169358],[-73.88858784477142,40.72758290595945],[-73.88858739817984,40.727582397639964],[-73.88858697409822,40.72758187763563],[-73.888586574891,40.727581347749776],[-73.88858619937744,40.72758080618017],[-73.88858584873526,40.727580256530125],[-73.88858552296747,40.72757969699846],[-73.88858522325327,40.727579130287985],[-73.88858494959416,40.72757855549814],[-73.8885847019886,40.727577973529385],[-73.88858448043507,40.72757738528228],[-73.88858428729803,40.727576792560136],[-73.88858412021159,40.72757619446014],[-73.88858397917265,40.727575592783325],[-73.88858386773235,40.72757498753307],[-73.88858378352336,40.727574378707146],[-73.88858372535735,40.7275737690059],[-73.88858369560329,40.72757315753116],[-73.88858369423255,40.72757256139252],[-73.88858371772116,40.72757196437746],[-73.8885837684335,40.72757136828919],[-73.8885838463665,40.727570774928864],[-73.88858395033952,40.72757018249416],[-73.88858407916283,40.727569594586136],[-73.88858423520537,40.727569010306404],[-73.88858441609965,40.72756842965281],[-73.88858462302792,40.72756785352695],[-73.88858485598871,40.727567282829334],[-73.88858511379523,40.72756671935981],[-73.88858539644755,40.72756616311843],[-73.88858570276189,40.727565614104],[-73.8885860351042,40.72756507321936],[-73.88858638874113,40.72756453955937],[-73.88858676840003,40.72756401763119],[-73.88858716935059,40.72756350472871],[-73.88858759395713,40.72756300265526],[-73.88858803985232,40.72756251140847],[-73.88858850703612,40.72756203098843],[-73.88858899550249,40.72756156499714],[-73.88858950407231,40.72756111073188],[-73.8885900315603,40.72756066909209],[-73.88859058033093,40.72756024188104],[-73.88859114683149,40.72755982999576],[-73.88859173106508,40.72755943163536],[-73.88863654220083,40.72752995898264],[-73.8886821875242,40.72749994861418],[-73.88872783162275,40.727469938226406],[-73.88876375148806,40.72744634356224],[-73.88877325521979,40.727440102306254],[-73.88877405388334,40.72743959519035],[-73.88877487499965,40.727439110608856],[-73.88877571857029,40.72743864766131],[-73.88877658104404,40.727438206344246],[-73.88877746478538,40.72743778846092],[-73.88877836505941,40.727437394006856],[-73.88877928423217,40.727437023884754],[-73.88878021875398,40.727436677190774],[-73.8887811686218,40.72743635572583],[-73.88878213265198,40.727436059488824],[-73.88878310966228,40.72743578757816],[-73.88878409846458,40.72743554269411],[-73.88878509669435,40.727435323033404],[-73.88878610553243,40.72743513039828],[-73.88878712142908,40.7274349638847],[-73.88878814556656,40.727434824394365],[-73.88878917439682,40.72743471012283],[-73.88879020791377,40.727434624672114],[-73.8887912449352,40.727434567140584],[-73.88879228428048,40.72743453572604]]]]} | Q360S | 5505 | Q360S-QZ807 | QZ807 | Q-05 | Q360S | LIE service rd.(w) & 57 Rd & 73 St | 405 | 30 | 104 | 11378 |
| {"type":"MultiPolygon","coordinates":[[[[-73.90806373927703,40.8252869713143],[-73.90792143773025,40.82524806981284],[-73.9081654537987,40.82502258749881],[-73.90806373927703,40.8252869713143]]]]} | X056 | 5522 | X056-XZ198 | XZ198 | X-03 | X-03 | Boston Rd & 164th St & 3rd Ave | 203 | 16 | 42 | 10456 |
| {"type":"MultiPolygon","coordinates":[[[[-73.85462504581858,40.73619619697803],[-73.85473648701549,40.73642607724819],[-73.85463930179013,40.73643880668138],[-73.8544639522199,40.73645947071804],[-73.85429283359215,40.736476925924634],[-73.85417875914293,40.73648642148358],[-73.8541600348458,40.73648762516629],[-73.85414496695539,40.73648637868959],[-73.85413662499619,40.736482251897584],[-73.85413231831977,40.73647511711336],[-73.85407133151547,40.73635454634852],[-73.85462504581858,40.73619619697803]]]]} | QZ318 | 5507 | QZ318 | QZ318 | Q-06 | Q-06 | Yellowstone Blvd & 62 Av & LIE | 406 | 21 | 112 | 11375 |
| {"type":"MultiPolygon","coordinates":[[[[-73.81372804013215,40.79509849078248],[-73.81373346716465,40.795098015082736],[-73.8137416944541,40.79509912068662],[-73.81374838776942,40.795101747460436],[-73.81375256293744,40.795104874446025],[-73.81376430434399,40.79513066308047],[-73.81377350904113,40.79515088251343],[-73.81377716225465,40.79515930630741],[-73.81379855807823,40.79521823099485],[-73.81379840837705,40.795218374833304],[-73.81379413119032,40.795222487719776],[-73.8137636869593,40.795219626266295],[-73.81375425517241,40.79521873934068],[-73.81373685251846,40.79521699306206],[-73.81373589893586,40.79521689606794],[-73.81368185162914,40.795211365181565],[-73.81367795131781,40.79521079246117],[-73.81366279186173,40.79520856712842],[-73.81366147684717,40.79520763568459],[-73.81365738871726,40.795204738464456],[-73.81365487957056,40.79520075148814],[-73.81365419729724,40.79519685751546],[-73.81365528150718,40.795193042040836],[-73.81366947483014,40.79517382936531],[-73.81369435253534,40.795141049887135],[-73.81372804013215,40.79509849078248]]]]} | Q168 | 5508 | Q168-QZ820 | QZ820 | Q-07 | Q168 | Clintonville St & 7 Av & 151 St | 407 | 19 | 109 | 11357 |
Showing 12 of 35 columns. All of them are listed below.
MZ217QZ483department | text | — | 0% | Q-08Q-13Q-14 |
permitdist | text | — | 100% | Nullof 1 |
permitpare | text | — | 100% | Nullof 1 |
parentid | text | — | 0% | R-02Q-08Q-13 |
location | text | — | 0% | Adams St Bet Tillary St …Oak Tree Place and Arthu…Oak Tree Place and Hughe… |
communityb | text | — | 0% | 408502413 |
councildis | text | — | 0% | 50931 |
precinct | text | — | 0% | 122107105 |
zipcode | text | — | 0% | 103051123411413 |
borough | categorical | — | 0% | QBMof 5 |
acres | float | — | 0% | 00.001680430.02949451 |
organizati | text | — | 0% | NYCPARKSof 1 |
class | categorical | — | 0% | GREENSTPARKof 2 |
status | categorical | — | 0% | IDof 2 |
ampstype | text | — | 0% | Sof 1 |
parentorg | text | — | 0% | NYCPARKSof 1 |
commission | datetime | — | 0% | 2010-01-11T00:00:00.000Z2009-02-24T00:00:00.000Z2000-06-01T00:00:00.000Z |
classorg | text | — | 0% | NYCPARKSof 1 |
accessible | categorical | — | 100% | NYYesof 3 |
contract | text | — | 78% | CNYG-3005MRCNYG-2907MCNYG-5009M |
descriptio | text | — | 0% | GREENSTREETGreenstreetGreenstreet Inspection G… |
gsgroup | text | — | 39% | 03524 |
gstype | categorical | — | 21% | GreenstreetPed_RefSA_Triof 5 |
mou | categorical | — | 0% | DOTNoneOtherof 4 |
name | text | — | 97% | GREENSTREETLafayette Ave MallSherman Creek |
proplocati | categorical | — | 100% | NullRose & Frankfort Stsof 2 |
propname | categorical | — | 100% | GreenstreetNullBabi Yar Triangleof 5 |
season | categorical | — | 84% | Fall09Fall07Fall08of 13 |
sitename | text | — | 6% | GREENSTREETGreenstreetBroadway Malls |
subcategor | categorical | — | 25% | Type 1Type 1 GreenstreetType 2of 9 |
nys_assemb | text | — | 0% | 236425 |
nys_senate | text | — | 0% | 113424 |
us_congres | text | — | 0% | 11514 |
global_id | text | — | 0% | {81757227-4C39-444B-8E4A…{D0511A14-4A65-4FAF-A2A0…{4FD7F7F0-2C32-4975-8384… |
shape_star | float | — | 0% | 73.200180053773.1987152173.1997833252 |
shape_stle | float | — | 0% | 96.220365862936.5138694047167.872243299 |