units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where MNG_AGENCY = 287 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
DES_TP 5
ACCESS_TYP 2
- Open Access 28
- Restricted Access 20
MNG_AG_TYP 1
- City Agency 48
MNG_AGENCY 1
- Whittier, City of · 48 ✖
Link | rowid ▲ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16034 | 16034 | 16033 | {"type": "Polygon", "coordinates": [[[-118.02482, 33.98022], [-118.02407, 33.9806], [-118.02376, 33.98114], [-118.02378, 33.98121], [-118.02382, 33.98125], [-118.02386, 33.98126], [-118.02393, 33.98125], [-118.02374, 33.98136], [-118.02358, 33.98126], [-118.02323, 33.98115], [-118.0225, 33.98121], [-118.0216, 33.98166], [-118.01996, 33.98163], [-118.01995, 33.98253], [-118.01676, 33.98248], [-118.01673, 33.98326], [-118.01617, 33.98356], [-118.01558, 33.98377], [-118.01405, 33.98404], [-118.01334, 33.98402], [-118.0129, 33.9839], [-118.01238, 33.98365], [-118.01159, 33.98351], [-118.01098, 33.98353], [-118.01011, 33.98279], [-118.00999, 33.982], [-118.01028, 33.98102], [-118.01084, 33.98063], [-118.01287, 33.98141], [-118.01311, 33.98104], [-118.01375, 33.98062], [-118.01378, 33.98056], [-118.01378, 33.9805], [-118.01371, 33.98042], [-118.01361, 33.9804], [-118.01256, 33.98079], [-118.01267, 33.98046], [-118.01485, 33.97894], [-118.01564, 33.97895], [-118.01564, 33.97709], [-118.01907, 33.97712], [-118.01997, 33.97662], [-118.01998, 33.97533], [-118.0235, 33.97537], [-118.0214, 33.97828], [-118.02166, 33.97931], [-118.02167, 33.97931], [-118.02174, 33.97925], [-118.02178, 33.97917], [-118.02178, 33.97915], [-118.02303, 33.97958], [-118.02325, 33.97978], [-118.02331, 33.97974], [-118.02366, 33.98006], [-118.02415, 33.97987], [-118.02482, 33.98022]]]} | Open Access 1 | 6516 | Worsham Canyon Open Space | 14873 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 154.353 | Worsham Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15375 | 15375 | 15374 | {"type": "Polygon", "coordinates": [[[-118.06214, 33.99624], [-118.06143, 33.99697], [-118.06026, 33.99618], [-118.06023, 33.99613], [-118.06024, 33.99609], [-118.06036, 33.99592], [-118.06036, 33.99586], [-118.06034, 33.99581], [-118.06029, 33.99577], [-118.06042, 33.99562], [-118.06025, 33.99551], [-118.06031, 33.99544], [-118.06042, 33.99552], [-118.06068, 33.99526], [-118.06125, 33.99569], [-118.06164, 33.99594], [-118.06214, 33.99624]]]} | Restricted Access 2 | 46586 | Orange Grove Elementary School Park | 31923 | 2371 | Whittier City School District 923 | Special District 4 | School District 14 | http://www.whittiercity.k12.ca.us/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 4.112 | Orange Grove Elementary School Park | 0 | Local Park 2 | 4 | |
15374 | 15374 | 15373 | {"type": "Polygon", "coordinates": [[[-118.07089, 33.98277], [-118.07034, 33.98332], [-118.07025, 33.98332], [-118.07025, 33.98291], [-118.06916, 33.98298], [-118.06903, 33.98295], [-118.06895, 33.98284], [-118.06879, 33.9828], [-118.06867, 33.98281], [-118.06848, 33.98289], [-118.06761, 33.98287], [-118.06732, 33.98319], [-118.06592, 33.98222], [-118.0659, 33.98218], [-118.06677, 33.98141], [-118.0679, 33.98219], [-118.06876, 33.9813], [-118.07089, 33.98277]]]} | Restricted Access 2 | 46585 | Katherine Edwards Middle School Park | 31922 | 2371 | Whittier City School District 923 | Special District 4 | School District 14 | http://www.whittiercity.k12.ca.us/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 12.444 | Katherine Edwards Middle School Park | 0 | Local Park 2 | 4 | |
15373 | 15373 | 15372 | {"type": "Polygon", "coordinates": [[[-118.00906, 33.93605], [-118.00905, 33.93665], [-118.00888, 33.93669], [-118.00796, 33.93701], [-118.00795, 33.93695], [-118.0074, 33.93695], [-118.00741, 33.93657], [-118.00719, 33.93652], [-118.00734, 33.93606], [-118.00706, 33.936], [-118.00713, 33.93579], [-118.00721, 33.93576], [-118.00718, 33.9357], [-118.00732, 33.93569], [-118.00731, 33.93533], [-118.0077, 33.93533], [-118.00906, 33.93605]]]} | Restricted Access 2 | 46584 | Orchard Dale Elementary School Park | 31921 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 5.701 | Orchard Dale Elementary School Park | 0 | Local Park 2 | 4 | |
15372 | 15372 | 15371 | {"type": "Polygon", "coordinates": [[[-117.98787, 33.94757], [-117.98771, 33.94783], [-117.98755, 33.94804], [-117.98742, 33.94817], [-117.98728, 33.94827], [-117.98705, 33.9484], [-117.9864, 33.94818], [-117.98619, 33.94749], [-117.98701, 33.94731], [-117.98787, 33.94757]]]} | Restricted Access 2 | 46581 | Murphy Ranch Elementary School Park | 31919 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 3.01 | Murphy Ranch Elementary School Park | 0 | Local Park 2 | 4 | |
15371 | 15371 | 15370 | {"type": "Polygon", "coordinates": [[[-118.00458, 33.9266], [-118.00234, 33.92712], [-118.00169, 33.92516], [-118.00393, 33.92463], [-118.00458, 33.9266]]]} | Restricted Access 2 | 46567 | Granada Middle School Park | 31912 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 12.037 | Granada Middle School Park | 0 | Local Park 2 | 4 | |
15370 | 15370 | 15369 | {"type": "Polygon", "coordinates": [[[-118.05409, 33.98997], [-118.05257, 33.98997], [-118.05256, 33.98817], [-118.05247, 33.98816], [-118.05247, 33.98725], [-118.05276, 33.98725], [-118.05365, 33.98816], [-118.05359, 33.98816], [-118.05358, 33.98817], [-118.05408, 33.98868], [-118.05409, 33.98997]]]} | Restricted Access 2 | 46566 | Dexter Middle School Park | 31911 | 2371 | Whittier City School District 923 | Special District 4 | School District 14 | http://www.whittiercity.k12.ca.us/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 8.327 | Dexter Middle School Park | 0 | Local Park 2 | 4 | |
15369 | 15369 | 15368 | {"type": "Polygon", "coordinates": [[[-118.04661, 33.98098], [-118.0466, 33.98257], [-118.04655, 33.98262], [-118.0434, 33.98262], [-118.04335, 33.98259], [-118.04335, 33.98089], [-118.0454, 33.98089], [-118.04541, 33.98097], [-118.04661, 33.98098]]]} | Restricted Access 2 | 46565 | Whittier High School Park | 31910 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 14.027 | Whittier High School Park | 0 | Local Park 2 | 4 | |
15368 | 15368 | 15367 | {"type": "Polygon", "coordinates": [[[-118.04953, 33.95322], [-118.04794, 33.95479], [-118.04703, 33.95414], [-118.04712, 33.95402], [-118.04661, 33.95363], [-118.0473, 33.95299], [-118.04766, 33.95262], [-118.04765, 33.95257], [-118.04729, 33.95235], [-118.04701, 33.95253], [-118.04688, 33.95257], [-118.04672, 33.95256], [-118.04499, 33.95139], [-118.04575, 33.95062], [-118.04953, 33.95322]]]} | Restricted Access 2 | 46564 | Sierra Vista Adult School Park | 31909 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 16.345 | Sierra Vista Adult School Park | 0 | Local Park 2 | 4 | |
15367 | 15367 | 15366 | {"type": "Polygon", "coordinates": [[[-118.02225, 33.94131], [-118.02046, 33.94359], [-118.01735, 33.94146], [-118.01943, 33.93937], [-118.02225, 33.94131]]]} | Restricted Access 2 | 46563 | California High School Park | 31908 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 26.421 | California High School Park | 0 | Local Park 2 | 4 | |
15366 | 15366 | 15365 | {"type": "Polygon", "coordinates": [[[-117.99819, 33.95654], [-117.99808, 33.957], [-117.99805, 33.95724], [-117.99805, 33.95742], [-117.99797, 33.95761], [-117.99795, 33.95761], [-117.99766, 33.9579], [-117.99726, 33.95842], [-117.99394, 33.95658], [-117.99393, 33.95522], [-117.99456, 33.95479], [-117.9948, 33.95469], [-117.99819, 33.95654]]]} | Restricted Access 2 | 46562 | La Serna High School Park | 31907 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 22.498 | La Serna High School Park | 0 | Local Park 2 | 4 | |
15365 | 15365 | 15364 | {"type": "Polygon", "coordinates": [[[-118.00234, 33.92712], [-118.00162, 33.92729], [-118.0016, 33.92713], [-118.0015, 33.92688], [-118.00137, 33.92672], [-118.00117, 33.92657], [-118.00098, 33.92647], [-118.00074, 33.92575], [-118.0018, 33.92549], [-118.00234, 33.92712]]]} | Restricted Access 2 | 46561 | Scott Avenue Elementary School Park | 31906 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 4.025 | Scott Avenue Elementary School Park | 0 | Local Park 2 | 4 | |
15307 | 15307 | 15306 | {"type": "Polygon", "coordinates": [[[-118.03796, 33.97412], [-118.03796, 33.97439], [-118.0375, 33.97439], [-118.0375, 33.97412], [-118.03796, 33.97412]]]} | Open Access 1 | 46560 | Whittier Depot Park | 29863 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 0.321 | Whittier Depot Park | 0 | Local Park 2 | 4 | |
7279 | 7279 | 7278 | {"type": "Polygon", "coordinates": [[[-118.03492, 33.98096], [-118.03491, 33.98163], [-118.03392, 33.98163], [-118.03394, 33.98096], [-118.03492, 33.98096]]]} | Open Access 1 | 6537 | Central Park | 17064 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 1.688 | Central Park | 0 | Local Park 2 | 4 | |
7278 | 7278 | 7277 | {"type": "Polygon", "coordinates": [[[-118.02298, 33.96402], [-118.02183, 33.96545], [-118.01994, 33.9644], [-118.02109, 33.96296], [-118.02298, 33.96402]]]} | Open Access 1 | 6536 | Michigan Park | 22200 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 9.972 | Michigan Park | 0 | Local Park 2 | 4 | |
7277 | 7277 | 7276 | {"type": "MultiPolygon", "coordinates": [[[[-118.02526, 33.97531], [-118.02514, 33.97531], [-118.02508, 33.97529], [-118.02501, 33.97525], [-118.0248, 33.97503], [-118.02465, 33.97492], [-118.02451, 33.97485], [-118.02428, 33.97479], [-118.02398, 33.97478], [-118.02376, 33.97483], [-118.02355, 33.97493], [-118.02329, 33.97515], [-118.02311, 33.97521], [-118.02293, 33.97521], [-118.02284, 33.97519], [-118.02272, 33.97512], [-118.02266, 33.97508], [-118.0226, 33.97499], [-118.02256, 33.97492], [-118.02256, 33.97481], [-118.02264, 33.97467], [-118.02282, 33.97456], [-118.02301, 33.97449], [-118.02382, 33.97435], [-118.02401, 33.97426], [-118.02419, 33.97412], [-118.02422, 33.97407], [-118.02452, 33.97422], [-118.02454, 33.97418], [-118.02429, 33.97405], [-118.02438, 33.97388], [-118.0244, 33.97378], [-118.02486, 33.97402], [-118.02476, 33.97432], [-118.02526, 33.97531]]], [[[-118.02494, 33.97539], [-118.02494, 33.97539], [-118.02274, 33.97536], [-118.02275, 33.97529], [-118.02285, 33.97532], [-118.02297, 33.97534], [-118.02308, 33.97534], [-118.02324, 33.97531], [-118.02341, 33.97522], [-118.02361, 33.97505], [-118.02372, 33.97499], [-118.02389, 33.97493], [-118.02416, 33.9749], [-118.02436, 33.97494], [-118.02455, 33.97503], [-118.02494, 33.97539]]]]} | Open Access 1 | 6535 | William Penn Park | 27556 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 5.653 | William Penn Park | 0 | Local Park 2 | 4 | |
7276 | 7276 | 7275 | {"type": "Polygon", "coordinates": [[[-118.00215, 33.94886], [-118.00214, 33.9489], [-118.00206, 33.949], [-118.002, 33.94912], [-118.00178, 33.94977], [-118.00198, 33.94984], [-118.00196, 33.94995], [-118.00167, 33.9504], [-118.0013, 33.95135], [-118.00092, 33.95167], [-118.00051, 33.95194], [-118.00043, 33.9518], [-118.0004, 33.95175], [-118.0004, 33.95168], [-118.00045, 33.95164], [-118.00065, 33.95159], [-118.00085, 33.95147], [-118.00099, 33.95134], [-118.00109, 33.95121], [-118.00154, 33.95019], [-118.00168, 33.94978], [-118.00193, 33.94917], [-118.00205, 33.94898], [-118.00215, 33.94886]]]} | Open Access 1 | 6519 | La Serna Drive Open Space | 20807 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 1.661 | La Serna Drive OS | 0 | Local Recreation Area 3 | 4 | |
7275 | 7275 | 7274 | {"type": "Polygon", "coordinates": [[[-118.03492, 33.97189], [-118.03492, 33.97353], [-118.03427, 33.97353], [-118.03331, 33.9734], [-118.03332, 33.97241], [-118.03385, 33.9724], [-118.03385, 33.97215], [-118.03394, 33.97215], [-118.03395, 33.97189], [-118.0344, 33.9719], [-118.03441, 33.97215], [-118.03447, 33.97214], [-118.03448, 33.9719], [-118.03492, 33.97189]]]} | Open Access 1 | 6518 | Friends Park Complex | 19117 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 5.686 | Friends Park Complex | 0 | Local Recreation Area 3 | 4 | |
7274 | 7274 | 7273 | {"type": "Polygon", "coordinates": [[[-118.03194, 33.98457], [-118.03194, 33.98501], [-118.03164, 33.98513], [-118.03164, 33.98457], [-118.03194, 33.98457]]]} | Restricted Access 2 | 6517 | Bailey Ranch House and Park | 29859 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 0.383 | Bailey Ranch House and Park | 0 | Local Park 2 | 4 | |
7272 | 7272 | 7271 | {"type": "MultiPolygon", "coordinates": [[[[-118.03213, 33.99081], [-118.03186, 33.9908], [-118.03187, 33.99053], [-118.03212, 33.99053], [-118.03213, 33.99081]]], [[[-118.03399, 33.98995], [-118.03398, 33.99019], [-118.0325, 33.99019], [-118.03251, 33.98994], [-118.03399, 33.98995]]], [[[-118.03322, 33.98945], [-118.03321, 33.98986], [-118.03274, 33.98986], [-118.03275, 33.98944], [-118.03322, 33.98945]]], [[[-118.03607, 33.99067], [-118.03607, 33.99067], [-118.03508, 33.99066], [-118.03587, 33.99044], [-118.03606, 33.99043], [-118.03607, 33.99067]]], [[[-118.03783, 33.99604], [-118.03756, 33.99644], [-118.03728, 33.99647], [-118.03727, 33.99604], [-118.03757, 33.99584], [-118.03783, 33.99604]]], [[[-118.0374, 33.99507], [-118.03728, 33.99507], [-118.03728, 33.99483], [-118.03734, 33.99483], [-118.0374, 33.99507]]], [[[-118.03924, 33.99587], [-118.0392, 33.99627], [-118.0389, 33.9963], [-118.03892, 33.99616], [-118.03906, 33.99613], [-118.03913, 33.99609], [-118.03915, 33.99605], [-118.03917, 33.99586], [-118.03924, 33.99587]]], [[[-118.04615, 34.00015], [-118.04611, 34.00027], [-118.04606, 34.00029], [-118.046, 34.00034], [-118.04595, 34.00041], [-118.04595, 34.00044], [-118.04593, 34.00044], [-118.04593, 34.00008], [-118.04615, 34.00015]]]]} | Open Access 1 | 6511 | Hellman Park | 14853 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.lamountains.com/parks.asp?parkid=633 | Los Angeles 6 | 2.862 | Hellman Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);