From a 500-row sample across 16 columns.
remarksschooldistzoned_dist+9remarksschooldistzoned_dist+6Has borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| the_geom | schooldist | boro | initials | creat_date | edit_date | boro_num | shape_leng | shape_area | dbn | esid_no | label |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiPolygon","coordinates":[[[[-74.01924633135063,40.6431854115336],[-74.01865273834098,40.64375753683256],[-74.01806004482778,40.644326281705034],[-74.01749264886907,40.644878918184375],[-74.01690609409391,40.64544418010645],[-74.01674997418975,40.64533397020998],[-74.01490732500596,40.64422985817117],[-74.01264921249422,40.642865789682865],[-74.01323203409127,40.642305187408276],[-74.01102862045661,40.640975900845646],[-74.01102871146932,40.64097581348671],[-74.00882481840237,40.63964463007195],[-74.00881247416554,40.63951069623688],[-74.00922840928322,40.639096086529975],[-74.00940854274678,40.63908474016395],[-74.00998983375521,40.63852434352619],[-74.012194907988,40.63985478183333],[-74.01439632340747,40.64118583562586],[-74.01659362859085,40.6425110305317],[-74.01665160045293,40.64254598927727],[-74.01723502479221,40.64198735754925],[-74.01924633135063,40.6431854115336]]]]} |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | Geospatial column used for mapping | — | — |
schooldist | integer | Official district where school is located | 0% | 30.031.010.0 |
boro | categorical | Letter code for the NYC borough | 0% | KQXof 5 |
initials | text | Initials of the person creating the zone | 1% | BGDMHAP |
creat_date | datetime | Date the zone was created | 2% |
GET /api/datasets/cmjf-yawu GET /api/datasets/cmjf-yawu/quality GET /api/datasets/cmjf-yawu/related GET /api/columns?dataset=cmjf-yawu
dbndbn| 20.0 |
| K |
| SP |
| 2011-08-12T00:00:00.000 |
| 2019-11-15T00:00:00.000 |
| 3 |
| 19512.2966006 |
| 6613407.70193 |
| 20K503 |
| 816.0 |
| 503 |
| {"type":"MultiPolygon","coordinates":[[[[-73.87335012627533,40.678638430965876],[-73.87406779665993,40.67853598444842],[-73.87422202253147,40.67851610556999],[-73.87403563695752,40.677698863685265],[-73.87374051258308,40.67645463080433],[-73.87466664786842,40.67632134967031],[-73.874351408859,40.675052638349754],[-73.87527450805116,40.6749188264014],[-73.87558810556116,40.67618862299736],[-73.87589560341046,40.6774307209184],[-73.8760987604599,40.678247752508206],[-73.8762772177988,40.67897323048316],[-73.87382793938589,40.679327948375054],[-73.87335012627533,40.678638430965876]]]]} | 19.0 | K | BS | 2001-08-07T00:00:00.000 | 2021-10-26T00:00:00.000 | 3 | 11278.3612118 | 5923154.18093 | 19K938,19K159 | 930.0 | 938 (K-4), 159 (5) |
| {"type":"MultiPolygon","coordinates":[[[[-73.89670364706564,40.66755444418299],[-73.8958051502497,40.6676883152808],[-73.89540926658472,40.666153106922636],[-73.8957454467723,40.66590289340704],[-73.89549858116101,40.66475169938044],[-73.89592090098506,40.66447126209344],[-73.89630545940756,40.66400986890511],[-73.89618190252115,40.66305706727676],[-73.89628562376915,40.66294212845199],[-73.89644986310758,40.662808962138996],[-73.8967964444926,40.66286600163332],[-73.89720984026978,40.66281807118313],[-73.89736883717985,40.66267293423682],[-73.90002523109172,40.662281633720625],[-73.90041654239988,40.66380652995572],[-73.90075326976925,40.66499864493581],[-73.90085135762877,40.66534589719386],[-73.9008215585743,40.66544813712415],[-73.90074038831938,40.66552781767233],[-73.90026095467714,40.665606901666116],[-73.89999713972917,40.66547185770732],[-73.89978486640638,40.66574311966916],[-73.89943370468686,40.66580815829574],[-73.89960922835257,40.667025665890016],[-73.89947172808716,40.66714565763227],[-73.898551489253,40.66728255674513],[-73.8976333053857,40.667418676024276],[-73.89670364706564,40.66755444418299]]]]} | 19.0 | K | JG | 2001-08-07T00:00:00.000 | 2015-11-18T00:00:00.000 | 3 | 6884.01154674 | 1885953.14902 | 19K557 | 190.0 | 557 |
| {"type":"MultiPolygon","coordinates":[[[[-73.95824570382237,40.67998510437865],[-73.95829216607584,40.679831141169835],[-73.96134655108374,40.68046352945426],[-73.96329205592747,40.680881585096024],[-73.96442184920672,40.6811192884674],[-73.96442081862745,40.68118849266036],[-73.96477852649431,40.683039717777426],[-73.96508764268638,40.68454676456663],[-73.96402925385614,40.68466837357023],[-73.96462663854929,40.687591876307174],[-73.96269328187219,40.68781917671666],[-73.95713186518076,40.68846313278467],[-73.95497568160671,40.68871119337144],[-73.95468418919756,40.68724485364865],[-73.95684165201914,40.686996078747654],[-73.95669902113931,40.68626334033396],[-73.95655081117172,40.68553036510495],[-73.95640328932859,40.684798803984535],[-73.95625781854639,40.6840657483884],[-73.95898328012812,40.68374991542122],[-73.95884062068343,40.68301805314492],[-73.95839571596566,40.680797791970186],[-73.95824570382237,40.67998510437865]]]]} | 13.0 | K | BG | 2001-08-07T00:00:00.000 | 2004-09-02T00:00:00.000 | 3 | 11575.3940978 | 5657619.05755 | 13K056 | 236.0 | 56 |
| {"type":"MultiPolygon","coordinates":[[[[-73.95073580110589,40.686203666223776],[-73.95059026528021,40.68546662655995],[-73.94731056692157,40.685845485532084],[-73.94716450737123,40.685112390973025],[-73.94701720839684,40.68437947619581],[-73.95029937911643,40.6840014102479],[-73.95000845868591,40.68253675958711],[-73.94986111094764,40.68180401924229],[-73.9497143701918,40.68107006297199],[-73.9495568871953,40.68039040296556],[-73.95155682685908,40.68049884676386],[-73.95337017553848,40.68064050846756],[-73.95440263979833,40.680858027270354],[-73.95566601543159,40.6811369597924],[-73.95529361668048,40.67920315333384],[-73.95829216607572,40.67983114116989],[-73.95824570382231,40.679985104378694],[-73.95839571596566,40.680797791970186],[-73.95884062068343,40.683018053144956],[-73.95898328012818,40.68374991542125],[-73.95625781854628,40.6840657483884],[-73.95640328932848,40.684798803984535],[-73.95655081117165,40.68553036510499],[-73.95669902113919,40.686263340333994],[-73.95684165201908,40.686996078747654],[-73.9546841891975,40.68724485364865],[-73.95102806039253,40.68766648954068],[-73.9508831508559,40.686932518207],[-73.95073580110589,40.686203666223776]]]]} | 13.0 | K | SCS | 2001-08-07T00:00:00.000 | 2021-10-27T00:00:00.000 | 3 | 10918.0218822 | 4434726.45778 | 13K003 | 237.0 | 3 |
| {"type":"MultiPolygon","coordinates":[[[[-74.00575322449023,40.58177840763732],[-74.00547740445575,40.58161019425894],[-74.00509228395397,40.58161021197388],[-74.00450484898857,40.581672441994385],[-74.00393692847823,40.58173260254227],[-74.00289388433039,40.581585819345676],[-74.00193108059594,40.581487963425836],[-74.00109665278485,40.58146350538633],[-74.00108774006448,40.581462689596464],[-74.00029431984346,40.58139010314007],[-73.99970217155315,40.58129925918355],[-74.000705677412,40.58106184273695],[-74.00020348127875,40.58096154443174],[-73.99988568074956,40.580825421297156],[-73.99974518862776,40.5807389348187],[-73.99844883996118,40.57990926278407],[-73.99829903503047,40.57973376676707],[-73.9982161635206,40.57953607329324],[-73.9979684946348,40.57823673906668],[-73.99787742178071,40.57754328898856],[-73.99862979699219,40.57743953515132],[-73.99898230567527,40.57738938650367],[-73.99912527150154,40.57736510934747],[-73.9992510072764,40.57734853409474],[-73.99940884701591,40.577327726661856],[-73.99949581679142,40.57731626148434],[-74.00003382502375,40.57724533412447],[-73.99986449656993,40.57633092750331],[-73.99983381682436,40.57616524837751],[-73.99961512311535,40.57498420713267],[-74.00067580362015,40.57486856034138],[-74.00048497246331,40.57385885414047],[-74.00045899218804,40.573721388417574],[-74.00030997988716,40.57293292056508],[-74.00142189832437,40.57310184171452],[-74.00254829136375,40.573327043322536],[-74.00236551191975,40.572317487322366],[-74.00220561576361,40.5717559863823],[-74.0023485310163,40.571341465876806],[-74.00279081065963,40.571585027196505],[-74.00407400783007,40.57206359159103],[-74.00505136881503,40.57242808153408],[-74.00664110494223,40.57288257463341],[-74.00701710007267,40.57299006500844],[-74.00901968870721,40.57331780981727],[-74.00938179075625,40.573430365292914],[-74.0102851674654,40.573711164261695],[-74.01151385054736,40.57437618497008],[-74.01196850485343,40.574816440017926],[-74.01243552498603,40.575659520773556],[-74.01244689678455,40.57568386972041],[-74.01269363791462,40.57621221186118],[-74.01302553015508,40.57706467311823],[-74.01345572361505,40.57792649093348],[-74.01275083871975,40.5785583403404],[-74.01239936701032,40.57942550875067],[-74.01160698226629,40.58010489191687],[-74.0105222727445,40.58039823039929],[-74.01029875691874,40.58045867400886],[-74.00984195555554,40.580582202896906],[-74.0072424789107,40.58103507333512],[-74.00633769470662,40.58151804174287],[-74.00586781495883,40.58176885448835],[-74.00579835520199,40.5818059307801],[-74.00575322449023,40.58177840763732]]]]} | 21.0 | K | BG | 2001-08-06T00:00:00.000 | — | 3 | 13911.2830465 | 10480088.3431 | 21K188 | 117.0 | 188 |
| {"type":"MultiPolygon","coordinates":[[[[-73.99370969822654,40.57800223243921],[-73.9932619803865,40.57569515424595],[-73.99113480030721,40.57592567897036],[-73.99100352718553,40.57582443670191],[-73.99095391945652,40.57558236857025],[-73.99011283962753,40.575674567897266],[-73.99016120505644,40.57591735405004],[-73.99007402742761,40.576041498684205],[-73.99000435065733,40.575674814856704],[-73.98968697908617,40.57400455059563],[-73.99071712232185,40.573709455357616],[-73.99041255828473,40.57174186533367],[-73.98982788648671,40.571029608210345],[-73.98956828095602,40.57050123791229],[-73.99005113417203,40.5704136149481],[-73.99055484710577,40.57023566334456],[-73.99281532203226,40.5699922557237],[-73.99766789388447,40.57011424190609],[-73.99780217361597,40.571548091183914],[-73.99792060326695,40.57202884784061],[-73.99793723610796,40.57209636758784],[-73.99795884150407,40.57218407161536],[-73.99808758440105,40.572752728146035],[-73.99750151748549,40.57275150808265],[-73.99740979367554,40.57275131665958],[-73.99714601204404,40.57275076638879],[-73.99704433395455,40.57275055384018],[-73.99686813055688,40.57275660228859],[-73.99678403554734,40.57275948859729],[-73.99644946243049,40.57277097178868],[-73.99636029772279,40.57277403165089],[-73.99596084579471,40.572787739577485],[-73.99579140425777,40.57280142238323],[-73.99568523468639,40.57280999540926],[-73.99490444395774,40.57287304013175],[-73.99457419936665,40.57291593017504],[-73.99464801935864,40.57334052244325],[-73.99443841667626,40.573367414862304],[-73.99454531939266,40.573923821438335],[-73.99491028011045,40.575122171149914],[-73.99440094974219,40.57543705398853],[-73.9943155385416,40.57557399161961],[-73.9943863661642,40.57594934420978],[-73.99491184294415,40.57589215412438],[-73.99490137479653,40.57583651209909],[-73.9953326451101,40.57579004992527],[-73.99541901399034,40.57624914211292],[-73.9949853447445,40.57629586196708],[-73.99519064255188,40.57738714143872],[-73.99566636454995,40.57760967484069],[-73.99580937045464,40.57775938486753],[-73.99475685515901,40.57787974162011],[-73.99370969822654,40.57800223243921]]]]} | 21.0 | K | BG | 2011-08-12T00:00:00.000 | — | 3 | 11668.3769533 | 3870862.12615 | 21K288 | 118.0 | 288 |
| {"type":"MultiPolygon","coordinates":[[[[-73.9978873458811,40.580643777614696],[-73.99165902172889,40.57926169153142],[-73.99085884506967,40.57935640180149],[-73.99069770943079,40.579373051066355],[-73.99050367240508,40.578357647240786],[-73.99007402742761,40.576041498684205],[-73.99016120505644,40.57591735405004],[-73.99011283962753,40.575674567897266],[-73.99095391945652,40.57558236857025],[-73.99100352718553,40.57582443670191],[-73.99113480030721,40.57592567897036],[-73.9932619803865,40.57569515424595],[-73.99370969822654,40.57800223243921],[-73.99475685515901,40.57787974162011],[-73.99580937045464,40.57775938486753],[-73.99566636454995,40.57760967484069],[-73.99519064255188,40.57738714143872],[-73.9949853447445,40.57629586196708],[-73.99541901399034,40.57624914211292],[-73.9953326451101,40.57579004992527],[-73.99490137479653,40.57583651209909],[-73.99491184294415,40.57589215412438],[-73.9943863661642,40.57594934420978],[-73.9943155385416,40.57557399161961],[-73.99440094974219,40.57543705398853],[-73.99491028011045,40.575122171149914],[-73.99454531939266,40.573923821438335],[-73.99443841667626,40.573367414862304],[-73.99464801935864,40.57334052244325],[-73.99457419936665,40.57291593017504],[-73.99490444395774,40.57287304013175],[-73.99568523468639,40.57280999540926],[-73.99579140425777,40.57280142238323],[-73.99596084579471,40.572787739577485],[-73.99636029772279,40.57277403165089],[-73.99644946243049,40.57277097178868],[-73.99678403554734,40.57275948859729],[-73.99686813055688,40.57275660228859],[-73.99704433395455,40.57275055384018],[-73.99714601204404,40.57275076638879],[-73.99740979367554,40.57275131665958],[-73.99750151748549,40.57275150808265],[-73.99808758440105,40.572752728146035],[-73.99795884150407,40.57218407161536],[-73.99793723610796,40.57209636758784],[-73.99792060326695,40.57202884784061],[-73.99780217361597,40.571548091183914],[-73.99766789388447,40.57011424190609],[-74.00056716090751,40.57024541840903],[-74.00148853775937,40.570170464890566],[-74.00205364103206,40.569908148614864],[-74.0023485310163,40.571341465876806],[-74.00220561576361,40.5717559863823],[-74.00236551191975,40.572317487322366],[-74.00254829136375,40.573327043322536],[-74.00142189832437,40.57310184171452],[-74.00030997988716,40.57293292056508],[-74.00045899218804,40.573721388417574],[-74.00048497246331,40.57385885414047],[-74.00067580362015,40.57486856034138],[-73.99961512311535,40.57498420713267],[-73.99983381682436,40.57616524837751],[-73.99986449656993,40.57633092750331],[-74.00003382502375,40.57724533412447],[-73.99949581679142,40.57731626148434],[-73.99940884701591,40.577327726661856],[-73.9992510072764,40.57734853409474],[-73.99912527150154,40.57736510934747],[-73.99898230567527,40.57738938650367],[-73.99862979699219,40.57743953515132],[-73.99787742178071,40.57754328898856],[-73.9979684946348,40.57823673906664],[-73.9982161635206,40.57953607329324],[-73.99829903503047,40.57973376676707],[-73.99844883996118,40.57990926278407],[-73.99974518862776,40.5807389348187],[-73.99988568074956,40.580825421297156],[-74.00020348127875,40.58096154443174],[-74.000705677412,40.58106184273695],[-73.99970217155315,40.58129925918355],[-73.99913295099324,40.58133406965023],[-73.99841686150911,40.58137785809234],[-73.9980317488365,40.58115763082735],[-73.99800562188625,40.581064658489424],[-73.9978873458811,40.580643777614696]]]]} | 21.0 | K | BG | 2011-08-12T00:00:00.000 | — | 3 | 18376.4356828 | 6543570.56606 | 21K329 | 120.0 | 329 |
| {"type":"MultiPolygon","coordinates":[[[[-73.98534222565361,40.5790304893635],[-73.98521063936826,40.57893714233994],[-73.9851313796038,40.578518081856764],[-73.98460250501644,40.57857172093987],[-73.98431819982538,40.57706550358111],[-73.98437695390636,40.5770590267137],[-73.98435984721434,40.57696839811503],[-73.98453087226842,40.576939148491725],[-73.98465832762193,40.576748572609326],[-73.98477359075333,40.57662632218365],[-73.98583251616407,40.57650969590712],[-73.98689291469441,40.57639209606252],[-73.98795385210401,40.5762757743475],[-73.98901555383294,40.57615831753761],[-73.99007402742761,40.576041498684205],[-73.99050367240508,40.578357647240786],[-73.99069770943079,40.579373051066355],[-73.9903593700369,40.57941403863863],[-73.98957956209232,40.579192941591636],[-73.98928137640546,40.57900298897144],[-73.98894298028847,40.578808736371116],[-73.98851252554277,40.57883431134526],[-73.98828491439302,40.578847834044375],[-73.9882055338105,40.57885255007191],[-73.98806162410833,40.57889764245902],[-73.98738754205074,40.57910885409451],[-73.98692727309498,40.579455009115],[-73.98670581791615,40.57962155813533],[-73.98673741378495,40.57964784628219],[-73.98680577317802,40.57970472314549],[-73.98672149741341,40.57977297495731],[-73.986660335566,40.579822507498854],[-73.9869122477621,40.57996537398681],[-73.98701474446713,40.58002350273396],[-73.98646020053592,40.580764892324844],[-73.98601478730916,40.5811251710066],[-73.98580572456534,40.58124294650079],[-73.98580571040497,40.581242885263414],[-73.98565343080817,40.58066120657479],[-73.98534222565361,40.5790304893635]]]]} | 21.0 | K | BG | 2011-08-12T00:00:00.000 | — | 3 | 6782.79094401 | 1833886.20521 | 21K288 | 121.0 | 288 |
| {"type":"MultiPolygon","coordinates":[[[[-73.98968697908617,40.57400455059563],[-73.99000435065733,40.575674814856704],[-73.99007402742761,40.576041498684205],[-73.98901555383294,40.57615831753761],[-73.98866270791697,40.574301545905485],[-73.98871454383492,40.57428651222818],[-73.98968697908617,40.57400455059563]]]]} | 21.0 | K | BG | 2011-08-12T00:00:00.000 | — | 3 | 2034.92139974 | 212939.871258 | 21K329 | 122.0 | 329 |
Showing 12 of 16 columns. All of them are listed below.
2011-08-12T00:00:00.0002001-08-13T00:00:00.0002001-08-06T00:00:00.000 |
edit_date | datetime | Date the zone was edited | 55% | 2004-09-02T00:00:00.0002014-11-24T00:00:00.0002012-03-21T00:00:00.000 |
boro_num | categorical | Numerical equivalent of the NYC borough | 0% | 342of 5 |
shape_leng | float | Boundary of the polygon | 0% | 5977.743974915510.115347980.0 |
shape_area | float | Boundary of the polygon | 0% | 2203578.448091726741.259750.0 |
remarks | text | Comments | 87% | Elementary School Choice…ParkShared Zone: PS 243 and … |
dbn | text | District Borough Number is the combination of the District Number, the letter code for the borough, and the number of the school. Every school in NYC Public Schools (NYCPS) has a District Borough Number. | 4% | 30Q11130Q07630Q017 |
esid_no | integer | Unique internal identifier | 0% | 3.014.0486.0 |
label | text | District planning identifier. The Office of District Planning (ODP) creates annual strategic plans for all 32 Community School Districts through ongoing conversations with input from school communities and stakeholders. | 4% | 7611111 |
zoned_dist | text | Number assigned to each district | 0% | 303120 |
x_centroid | float | Center of polygon mass | 0% | 0.01015005.028621028402.08581 |
y_centroid | float | Center of polygon mass | 0% | 0.0214278.840151220320.598362 |