superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where LAYER = 2 and MNG_AGENCY = 57
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5331 | 5331 | 5330 | {"type": "Polygon", "coordinates": [[[-117.79041, 33.84386], [-117.79042, 33.8439], [-117.79042, 33.844], [-117.79036, 33.84435], [-117.79019, 33.84484], [-117.7899, 33.8448], [-117.78946, 33.84472], [-117.78895, 33.84457], [-117.78843, 33.84461], [-117.7881, 33.84458], [-117.78783, 33.8445], [-117.78762, 33.84446], [-117.78755, 33.84562], [-117.78626, 33.84563], [-117.78627, 33.84548], [-117.78631, 33.84538], [-117.78653, 33.84498], [-117.78658, 33.8448], [-117.78659, 33.84467], [-117.78657, 33.84451], [-117.78645, 33.84425], [-117.78646, 33.84421], [-117.78666, 33.84415], [-117.78687, 33.8441], [-117.7873, 33.84408], [-117.78763, 33.84412], [-117.78765, 33.8441], [-117.78775, 33.84414], [-117.7882, 33.8442], [-117.78851, 33.84421], [-117.78875, 33.8442], [-117.7889, 33.84418], [-117.78998, 33.84393], [-117.79026, 33.84386], [-117.79028, 33.84384], [-117.79035, 33.84383], [-117.79041, 33.84386]]]} | Open Access 1 | Imperial Park | 20180 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 8.219 | Imperial Park | ||
5570 | 5570 | 5569 | {"type": "Polygon", "coordinates": [[[-117.9554, 33.84805], [-117.95368, 33.84806], [-117.95368, 33.8491], [-117.95233, 33.8491], [-117.95213, 33.8491], [-117.95203, 33.84908], [-117.95185, 33.84902], [-117.95176, 33.84896], [-117.95128, 33.84856], [-117.95129, 33.84853], [-117.95147, 33.84836], [-117.95159, 33.84822], [-117.95174, 33.84797], [-117.95186, 33.84768], [-117.95191, 33.84749], [-117.95192, 33.84719], [-117.95194, 33.84716], [-117.95198, 33.84715], [-117.95536, 33.84711], [-117.95538, 33.84713], [-117.95539, 33.84716], [-117.9554, 33.84805]]]} | Open Access 1 | John Marshall Park | 20457 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 13.956 | John Marshall Park | ||
5623 | 5623 | 5622 | {"type": "Polygon", "coordinates": [[[-117.88266, 33.82743], [-117.88261, 33.82743], [-117.88253, 33.82748], [-117.88251, 33.82752], [-117.8825, 33.82758], [-117.88256, 33.8277], [-117.88256, 33.82834], [-117.88256, 33.82847], [-117.8825, 33.82858], [-117.8825, 33.82862], [-117.8825, 33.82866], [-117.88254, 33.8287], [-117.88263, 33.82874], [-117.88263, 33.82903], [-117.88064, 33.82904], [-117.88065, 33.82721], [-117.88266, 33.82721], [-117.88266, 33.82743]]]} | Open Access 1 | Juarez Park | 20515 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 8.974 | Juarez Park | ||
5630 | 5630 | 5629 | {"type": "Polygon", "coordinates": [[[-117.91594, 33.84882], [-117.9159, 33.84886], [-117.91549, 33.84886], [-117.91544, 33.84887], [-117.91541, 33.84891], [-117.91534, 33.8489], [-117.91524, 33.84892], [-117.91518, 33.84896], [-117.91513, 33.84903], [-117.91488, 33.84904], [-117.91487, 33.84867], [-117.91533, 33.84867], [-117.91542, 33.84868], [-117.91544, 33.84872], [-117.91594, 33.84872], [-117.91594, 33.84882]]]} | Open Access 1 | Julianna Park | 20520 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.608 | Julianna Park | ||
5827 | 5827 | 5826 | {"type": "Polygon", "coordinates": [[[-117.92398, 33.84989], [-117.92393, 33.84991], [-117.92388, 33.8499], [-117.92081, 33.84838], [-117.9201, 33.84805], [-117.91997, 33.84795], [-117.91993, 33.84787], [-117.91994, 33.84743], [-117.91996, 33.84738], [-117.92002, 33.84735], [-117.92356, 33.84733], [-117.92364, 33.84736], [-117.92392, 33.8483], [-117.92397, 33.84862], [-117.924, 33.84983], [-117.92398, 33.84989]]]} | Open Access 1 | La Palma Park | 20780 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 16.03 | La Palma Park | ||
6192 | 6192 | 6191 | {"type": "MultiPolygon", "coordinates": [[[[-117.89776, 33.83845], [-117.89744, 33.83852], [-117.89739, 33.83843], [-117.89724, 33.83847], [-117.89726, 33.83857], [-117.89642, 33.83876], [-117.89596, 33.83739], [-117.89613, 33.83735], [-117.89626, 33.83769], [-117.89741, 33.83742], [-117.89776, 33.83845]]], [[[-117.89914, 33.83875], [-117.89831, 33.83894], [-117.89807, 33.83828], [-117.89891, 33.83808], [-117.89914, 33.83875]]]]} | Open Access 1 | Lincoln Park | 21261 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 5.393 | Lincoln Park | ||
6279 | 6279 | 6278 | {"type": "Polygon", "coordinates": [[[-117.91582, 33.83142], [-117.9148, 33.83166], [-117.91469, 33.83133], [-117.9157, 33.83108], [-117.91582, 33.83142]]]} | Open Access 1 | Little Peoples Park | 21352 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.933 | Little Peoples Park | ||
6466 | 6466 | 6465 | {"type": "Polygon", "coordinates": [[[-117.89357, 33.80521], [-117.89357, 33.80566], [-117.89286, 33.80565], [-117.89286, 33.80521], [-117.89357, 33.80521]]]} | Open Access 1 | Magnolia Park | 21677 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.793 | Magnolia Park | ||
6600 | 6600 | 6599 | {"type": "Polygon", "coordinates": [[[-117.92915, 33.8519], [-117.92914, 33.85374], [-117.92542, 33.85307], [-117.92542, 33.85294], [-117.92772, 33.85294], [-117.92915, 33.8519]]]} | Open Access 1 | Manzanita Park | 21768 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 6.247 | Manzanita Park | ||
6772 | 6772 | 6771 | {"type": "Polygon", "coordinates": [[[-117.98034, 33.82842], [-117.97815, 33.82845], [-117.97813, 33.82676], [-117.9773, 33.82676], [-117.97729, 33.82592], [-117.97783, 33.8259], [-117.97784, 33.82578], [-117.97812, 33.82576], [-117.97812, 33.8256], [-117.97826, 33.82558], [-117.97827, 33.82525], [-117.97837, 33.82523], [-117.97838, 33.825], [-117.97961, 33.82499], [-117.97963, 33.82578], [-117.9803, 33.82579], [-117.98034, 33.82842]]]} | Open Access 1 | Maxwell Park | 21970 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 19.309 | Maxwell Park | ||
7086 | 7086 | 7085 | {"type": "Polygon", "coordinates": [[[-117.95445, 33.81559], [-117.95025, 33.8156], [-117.95024, 33.81368], [-117.95027, 33.81366], [-117.95059, 33.81366], [-117.95079, 33.81364], [-117.95144, 33.81352], [-117.95347, 33.81352], [-117.95433, 33.81349], [-117.95441, 33.8135], [-117.95443, 33.81354], [-117.95445, 33.81559]]]} | Open Access 1 | Modjeska Park | 22343 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 21.842 | Modjeska Park | ||
7521 | 7521 | 7520 | {"type": "Polygon", "coordinates": [[[-117.74708, 33.86458], [-117.74635, 33.86471], [-117.74625, 33.86471], [-117.74606, 33.86465], [-117.74576, 33.86448], [-117.74595, 33.86423], [-117.74609, 33.8641], [-117.74621, 33.86402], [-117.74676, 33.86381], [-117.74708, 33.86458]]]} | Open Access 1 | Roosevelt Park | 24596 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1.847 | Roosevelt Park | ||
7578 | 7578 | 7577 | {"type": "Polygon", "coordinates": [[[-117.76934, 33.83943], [-117.76919, 33.8398], [-117.76877, 33.83968], [-117.76842, 33.83961], [-117.76782, 33.83956], [-117.76746, 33.83956], [-117.76578, 33.83972], [-117.76531, 33.83981], [-117.76502, 33.83983], [-117.76473, 33.83983], [-117.76452, 33.83979], [-117.76455, 33.83963], [-117.76457, 33.83965], [-117.76481, 33.83965], [-117.76506, 33.83962], [-117.76628, 33.83904], [-117.76643, 33.83894], [-117.76644, 33.83892], [-117.76669, 33.83878], [-117.76667, 33.83852], [-117.76725, 33.83858], [-117.76811, 33.83826], [-117.7675, 33.83775], [-117.76856, 33.83801], [-117.76925, 33.83878], [-117.76934, 33.83943]]]} | Open Access 1 | Oak Park | 22995 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 10.916 | Oak Park | ||
7674 | 7674 | 7673 | {"type": "Polygon", "coordinates": [[[-117.82661, 33.83646], [-117.82589, 33.83675], [-117.82503, 33.83724], [-117.82501, 33.83776], [-117.82433, 33.83779], [-117.8237, 33.83789], [-117.82352, 33.8379], [-117.823, 33.83783], [-117.82292, 33.83683], [-117.82455, 33.83597], [-117.82493, 33.83624], [-117.82608, 33.83604], [-117.82637, 33.83617], [-117.82656, 33.83616], [-117.82661, 33.83646]]]} | Open Access 1 | Olive Hills Tennis Courts | 23124 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 10.617 | Olive Hills Tennis Courts | ||
7872 | 7872 | 7871 | {"type": "Polygon", "coordinates": [[[-117.93923, 33.81516], [-117.93708, 33.81517], [-117.93707, 33.81567], [-117.9365, 33.81567], [-117.93647, 33.81432], [-117.93737, 33.81432], [-117.93744, 33.81431], [-117.93752, 33.81427], [-117.93923, 33.81427], [-117.93923, 33.81516]]]} | Open Access 1 | Palm Lane Park | 23341 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 6.863 | Palm Lane Park | ||
8032 | 8032 | 8031 | {"type": "Polygon", "coordinates": [[[-117.9095, 33.81358], [-117.9095, 33.81395], [-117.90904, 33.81394], [-117.90899, 33.81392], [-117.90899, 33.81358], [-117.9095, 33.81358]]]} | Open Access 1 | Paul Revere Park Development | 23533 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.477 | Paul Revere Park Development | ||
8048 | 8048 | 8047 | {"type": "Polygon", "coordinates": [[[-117.92079, 33.83849], [-117.91739, 33.83929], [-117.91733, 33.83928], [-117.91671, 33.83737], [-117.91673, 33.83732], [-117.91696, 33.83724], [-117.92011, 33.83652], [-117.92015, 33.83652], [-117.9208, 33.83845], [-117.92079, 33.83849]]]} | Open Access 1 | Pearson Park | 23549 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 18.825 | Pearson Park | ||
8066 | 8066 | 8065 | {"type": "Polygon", "coordinates": [[[-117.79702, 33.84624], [-117.79632, 33.84674], [-117.79598, 33.84814], [-117.79646, 33.8488], [-117.79614, 33.84902], [-117.79607, 33.84906], [-117.79591, 33.84911], [-117.79554, 33.84916], [-117.79516, 33.84918], [-117.79479, 33.84923], [-117.79436, 33.84937], [-117.79431, 33.84936], [-117.79412, 33.84912], [-117.79412, 33.84897], [-117.79428, 33.84881], [-117.79445, 33.84832], [-117.79463, 33.84711], [-117.79442, 33.84652], [-117.7941, 33.84654], [-117.79412, 33.84558], [-117.79501, 33.84557], [-117.79542, 33.84516], [-117.7956, 33.84509], [-117.7958, 33.84495], [-117.7966, 33.84558], [-117.79687, 33.84559], [-117.79688, 33.8459], [-117.79702, 33.84624]]]} | Open Access 1 | Pelanconi Park | 23566 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 19.934 | Pelanconi Park | ||
8087 | 8087 | 8086 | {"type": "Polygon", "coordinates": [[[-117.80655, 33.85401], [-117.80228, 33.85403], [-117.80225, 33.85223], [-117.80226, 33.85213], [-117.80233, 33.85205], [-117.80271, 33.85193], [-117.80299, 33.85175], [-117.80328, 33.85162], [-117.80466, 33.8513], [-117.80467, 33.85301], [-117.80654, 33.85303], [-117.80655, 33.85401]]]} | Open Access 1 | Peralta Canyon Park | 23604 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 19.255 | Peralta Canyon Park | ||
8094 | 8094 | 8093 | {"type": "Polygon", "coordinates": [[[-117.97826, 33.84221], [-117.97824, 33.84225], [-117.97636, 33.84226], [-117.9763, 33.84225], [-117.97627, 33.84222], [-117.97626, 33.84138], [-117.97826, 33.84133], [-117.97826, 33.84221]]]} | Open Access 1 | Peter Marshall Park | 23627 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 4.554 | Peter Marshall 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]);