superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where MNG_AGENCY = 287 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA ▼ | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11197 | 11197 | 11196 | {"type": "Polygon", "coordinates": [[[-118.05777, 34.02462], [-118.05596, 34.02781], [-118.0555, 34.02795], [-118.05614, 34.03005], [-118.05591, 34.03011], [-118.05443, 34.02787], [-118.05411, 34.02797], [-118.05257, 34.02758], [-118.0521, 34.02755], [-118.05374, 34.02676], [-118.05406, 34.02413], [-118.05457, 34.02336], [-118.05777, 34.02462]]]} | Open Access 1 | Whittier Narrows Recreation Area | 27481 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 37.114 | Whittier Narrows Rec. Area | ||
11262 | 11262 | 11261 | {"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.02259, 33.97499], [-118.02256, 33.97492], [-118.02256, 33.97481], [-118.02264, 33.97467], [-118.02282, 33.97455], [-118.02301, 33.97449], [-118.02382, 33.97435], [-118.02401, 33.97426], [-118.02418, 33.97412], [-118.02422, 33.97407], [-118.02452, 33.97422], [-118.02453, 33.97417], [-118.02429, 33.97405], [-118.02438, 33.97388], [-118.0244, 33.97378], [-118.02486, 33.97402], [-118.02477, 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.97492], [-118.02416, 33.9749], [-118.02436, 33.97494], [-118.02455, 33.97503], [-118.02494, 33.97539]]]]} | Open Access 1 | William Penn Park | 27556 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 5.657 | William Penn Park | ||
11434 | 11434 | 11433 | {"type": "Polygon", "coordinates": [[[-118.05259, 33.95681], [-118.05074, 33.95865], [-118.05065, 33.95865], [-118.04934, 33.95774], [-118.05065, 33.95647], [-118.05259, 33.95681]]]} | Open Access 1 | York Field | 27780 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 9.184 | York Field | ||
15209 | 15209 | 15208 | {"type": "MultiPolygon", "coordinates": [[[[-118.07201, 33.99374], [-118.07172, 33.99428], [-118.07171, 33.9943], [-118.07171, 33.9943], [-118.07201, 33.99374]]], [[[-118.0717, 33.99431], [-118.07163, 33.99444], [-118.07136, 33.99471], [-118.0712, 33.9946], [-118.07149, 33.9943], [-118.07164, 33.9944], [-118.0717, 33.99431]]], [[[-118.07229, 33.99322], [-118.07171, 33.99283], [-118.07171, 33.99283], [-118.07197, 33.99299], [-118.07229, 33.99322]]]]} | Open Access 1 | Pío Pico State Historic Park | 28084 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 0.216 | Pío Pico SHP | 1917 | |
10445 | 10445 | 10444 | {"type": "MultiPolygon", "coordinates": [[[[-118.01025, 33.96928], [-118.00905, 33.97078], [-118.0088, 33.97086], [-118.00826, 33.97078], [-118.00886, 33.97002], [-118.00795, 33.9695], [-118.00792, 33.9694], [-118.00843, 33.96896], [-118.00845, 33.96883], [-118.00937, 33.96935], [-118.00969, 33.96896], [-118.01025, 33.96928]]], [[[-118.01077, 33.9639], [-118.01053, 33.9642], [-118.01004, 33.96394], [-118.01029, 33.9636], [-118.01076, 33.96386], [-118.01077, 33.9639]]]]} | Open Access 1 | Arroyo Pescadero | http://www.habitatauthority.org/trails/ | 28934 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 6.298 | Arroyo Pescadero | |
14332 | 14332 | 14331 | {"type": "MultiPolygon", "coordinates": [[[[-118.03255, 33.97371], [-118.03203, 33.9737], [-118.03203, 33.97351], [-118.03246, 33.97351], [-118.03249, 33.97355], [-118.03255, 33.97359], [-118.03255, 33.97371]]], [[[-118.03556, 33.97383], [-118.03511, 33.97384], [-118.0351, 33.9737], [-118.03556, 33.9737], [-118.03556, 33.97383]]], [[[-118.03609, 33.9737], [-118.03608, 33.97384], [-118.03563, 33.97384], [-118.03562, 33.97371], [-118.03609, 33.9737]]], [[[-118.03723, 33.98024], [-118.03676, 33.98024], [-118.03676, 33.98001], [-118.03723, 33.98002], [-118.03723, 33.98024]]], [[[-118.03912, 33.97384], [-118.03866, 33.97384], [-118.03865, 33.97371], [-118.03912, 33.97371], [-118.03912, 33.97384]]], [[[-118.03965, 33.97385], [-118.03919, 33.97384], [-118.03919, 33.97371], [-118.03965, 33.97371], [-118.03965, 33.97385]]], [[[-118.04028, 33.97371], [-118.04027, 33.97385], [-118.03981, 33.97384], [-118.03981, 33.97371], [-118.04028, 33.97371]]], [[[-118.0408, 33.97384], [-118.04035, 33.97385], [-118.04034, 33.97371], [-118.0408, 33.97371], [-118.0408, 33.97384]]], [[[-118.04143, 33.97385], [-118.04096, 33.97384], [-118.04097, 33.97371], [-118.04142, 33.97371], [-118.04143, 33.97385]]], [[[-118.04196, 33.97385], [-118.04149, 33.97385], [-118.04149, 33.97371], [-118.04196, 33.97371], [-118.04196, 33.97385]]], [[[-118.04312, 33.97387], [-118.04305, 33.97383], [-118.04264, 33.97382], [-118.04225, 33.97382], [-118.04219, 33.97387], [-118.04218, 33.97373], [-118.04223, 33.97369], [-118.04311, 33.97369], [-118.04312, 33.97387]]]]} | Open Access 1 | Unnamed site - Whittier, City of | 29858 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2.105 | |||
12705 | 12705 | 12704 | {"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 | Bailey Ranch House and Park | 29859 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 0.382 | Bailey Ranch House and Park | ||
12711 | 12711 | 12710 | {"type": "MultiPolygon", "coordinates": [[[[-118.06513, 33.99083], [-118.06488, 33.99107], [-118.06383, 33.99036], [-118.06403, 33.99015], [-118.06408, 33.99013], [-118.06412, 33.99013], [-118.06513, 33.99083]]], [[[-118.06684, 33.99203], [-118.06663, 33.99225], [-118.06531, 33.99136], [-118.06551, 33.99115], [-118.06556, 33.99114], [-118.06683, 33.99199], [-118.06684, 33.99203]]]]} | Open Access 1 | Whittier Boulevard Greenbelt | 29861 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2.42 | Whittier Boulevard Greenbelt | ||
11245 | 11245 | 11244 | {"type": "Polygon", "coordinates": [[[-118.04648, 33.97899], [-118.04609, 33.979], [-118.04611, 33.97832], [-118.04619, 33.97832], [-118.04619, 33.97795], [-118.04624, 33.97795], [-118.04625, 33.97792], [-118.04643, 33.97792], [-118.04646, 33.97897], [-118.04648, 33.97899]]]} | Restricted Access 2 | Whittier Dog Park | 29862 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 0.85 | Whittier Dog Park | ||
12712 | 12712 | 12711 | {"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 | Whittier Depot Park | 29863 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 0.321 | Whittier Depot Park | ||
267 | 267 | 266 | {"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 | Scott Avenue Elementary School Park | 31906 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 4.025 | Scott Avenue Elementary School Park | ||
268 | 268 | 267 | {"type": "Polygon", "coordinates": [[[-117.99819, 33.95654], [-117.99808, 33.957], [-117.99805, 33.95723], [-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 | La Serna High School Park | 31907 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 22.497 | La Serna High School Park | ||
269 | 269 | 268 | {"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 | California High School Park | 31908 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 26.419 | California High School Park | ||
270 | 270 | 269 | {"type": "Polygon", "coordinates": [[[-118.04953, 33.95322], [-118.04794, 33.95479], [-118.04703, 33.95414], [-118.04711, 33.95402], [-118.04661, 33.95363], [-118.0473, 33.95299], [-118.04766, 33.95263], [-118.04765, 33.95257], [-118.04729, 33.95235], [-118.04701, 33.95253], [-118.04688, 33.95256], [-118.04672, 33.95256], [-118.04499, 33.95139], [-118.04575, 33.95062], [-118.04953, 33.95322]]]} | Restricted Access 2 | Sierra Vista Adult School Park | 31909 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 16.347 | Sierra Vista Adult School Park | ||
271 | 271 | 270 | {"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.04542, 33.98097], [-118.04661, 33.98098]]]} | Restricted Access 2 | Whittier High School Park | 31910 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 14.027 | Whittier High School Park | ||
272 | 272 | 271 | {"type": "Polygon", "coordinates": [[[-118.05409, 33.98997], [-118.05257, 33.98997], [-118.05256, 33.98818], [-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 | Dexter Middle School Park | 31911 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 8.328 | Dexter Middle School Park | ||
273 | 273 | 272 | {"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 | Granada Middle School Park | 31912 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 12.036 | Granada Middle School Park | ||
276 | 276 | 275 | {"type": "Polygon", "coordinates": [[[-118.01607, 33.95413], [-118.01537, 33.95498], [-118.0151, 33.95486], [-118.01456, 33.95557], [-118.01606, 33.9564], [-118.01525, 33.95741], [-118.01384, 33.95663], [-118.01356, 33.9561], [-118.0145, 33.95494], [-118.0145, 33.95492], [-118.01435, 33.95484], [-118.01524, 33.9537], [-118.01607, 33.95413]]]} | Restricted Access 2 | East Whittier Middle School Park | 31913 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 10.472 | East Whittier Middle School Park | ||
277 | 277 | 276 | {"type": "Polygon", "coordinates": [[[-118.03804, 33.95602], [-118.03719, 33.95686], [-118.03667, 33.9565], [-118.03649, 33.95641], [-118.03662, 33.95617], [-118.0367, 33.9562], [-118.03678, 33.95608], [-118.03691, 33.95609], [-118.03698, 33.95594], [-118.03709, 33.95597], [-118.03725, 33.95565], [-118.03687, 33.95551], [-118.03656, 33.95547], [-118.03544, 33.95494], [-118.03587, 33.95451], [-118.03804, 33.95602]]]} | Restricted Access 2 | Laurel Elementary School Park | 31914 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 4.346 | Laurel Elementary School Park | ||
278 | 278 | 277 | {"type": "Polygon", "coordinates": [[[-118.00903, 33.93231], [-118.00901, 33.93505], [-118.00717, 33.93505], [-118.00717, 33.93475], [-118.00684, 33.93474], [-118.00684, 33.93436], [-118.00787, 33.93436], [-118.00787, 33.93381], [-118.00782, 33.9337], [-118.00791, 33.93347], [-118.00798, 33.93313], [-118.00801, 33.93308], [-118.00808, 33.93307], [-118.00826, 33.93307], [-118.00832, 33.93305], [-118.00837, 33.93301], [-118.00852, 33.93231], [-118.00903, 33.93231]]]} | Restricted Access 2 | Hillview Middle School Park | 31915 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 8.357 | Hillview Middle School Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);