superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where MNG_AGENCY = 57 sorted by SUID_NMA descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14388 | 14388 | 14387 | {"type": "MultiPolygon", "coordinates": [[[[-117.91074, 33.8344], [-117.9097, 33.83464], [-117.90958, 33.83429], [-117.91063, 33.83404], [-117.91074, 33.8344]]], [[[-117.91175, 33.83527], [-117.91127, 33.83537], [-117.91119, 33.83526], [-117.91055, 33.83541], [-117.91028, 33.8346], [-117.9103, 33.83456], [-117.91076, 33.83445], [-117.9108, 33.83457], [-117.91083, 33.83459], [-117.91099, 33.8346], [-117.91112, 33.83496], [-117.91163, 33.83486], [-117.91175, 33.83527]]]]} | Open Access 1 | Unknown Park - Anaheim, City of | 33479 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 3.036 | |||
14409 | 14409 | 14408 | {"type": "Polygon", "coordinates": [[[-117.94727, 33.81898], [-117.94727, 33.81912], [-117.94726, 33.81914], [-117.94693, 33.81915], [-117.94689, 33.81912], [-117.94689, 33.81897], [-117.94692, 33.81894], [-117.94723, 33.81894], [-117.94726, 33.81895], [-117.94727, 33.81898]]]} | Open Access 1 | Circle Park | https://www.anaheim.net/facilities/facility/details/Circle-Park-444 | 33467 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.194 | Circle Park | |
14210 | 14210 | 14209 | {"type": "Polygon", "coordinates": [[[-117.91342, 33.83503], [-117.91294, 33.83515], [-117.91282, 33.83479], [-117.91293, 33.83475], [-117.91288, 33.83459], [-117.91329, 33.8345], [-117.9133, 33.83457], [-117.91331, 33.83469], [-117.91342, 33.83503]]]} | Open Access 1 | Friendship Plaza | https://www.anaheim.net/facilities/facility/details/Friendship-Plaza-86 | 33466 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.664 | Friendship Plaza | |
11768 | 11768 | 11767 | {"type": "Polygon", "coordinates": [[[-117.92815, 33.83616], [-117.92788, 33.83623], [-117.92791, 33.83637], [-117.92783, 33.83639], [-117.92776, 33.8362], [-117.92757, 33.83624], [-117.92744, 33.83587], [-117.928, 33.83575], [-117.92815, 33.83616]]]} | Open Access 1 | Founders' Park | 28381 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.651 | Founders' Park | ||
11574 | 11574 | 11573 | {"type": "Polygon", "coordinates": [[[-117.87829, 33.85352], [-117.87826, 33.85357], [-117.87815, 33.8536], [-117.87802, 33.8536], [-117.87749, 33.85356], [-117.87737, 33.85357], [-117.877, 33.85366], [-117.87768, 33.85322], [-117.8778, 33.85322], [-117.87789, 33.85315], [-117.87828, 33.85347], [-117.87829, 33.85352]]]} | Open Access 1 | Miraloma Park and Community Center | https://www.anaheim.net/2206/Miraloma-Park-Family-Resource-Center | 28051 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.744 | Miraloma Park and Community Ctr. | 2015 |
11279 | 11279 | 11278 | {"type": "Polygon", "coordinates": [[[-117.93926, 33.82344], [-117.93719, 33.82346], [-117.93718, 33.82182], [-117.93722, 33.82179], [-117.93925, 33.82178], [-117.93926, 33.82344]]]} | Open Access 1 | Willow Park | 27582 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 8.769 | Willow Park | ||
9414 | 9414 | 9413 | {"type": "Polygon", "coordinates": [[[-117.911, 33.82276], [-117.90994, 33.82301], [-117.90989, 33.82299], [-117.90958, 33.82205], [-117.91068, 33.8218], [-117.911, 33.82276]]]} | Open Access 1 | Walnut Grove Park | 27230 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 2.892 | Walnut Grove Park | ||
10180 | 10180 | 10179 | {"type": "Polygon", "coordinates": [[[-117.74506, 33.86256], [-117.7448, 33.86264], [-117.74461, 33.86278], [-117.7441, 33.86378], [-117.74344, 33.86362], [-117.74303, 33.86354], [-117.74299, 33.86348], [-117.74303, 33.86311], [-117.74292, 33.86266], [-117.7428, 33.86269], [-117.74284, 33.86262], [-117.74282, 33.86234], [-117.74273, 33.86205], [-117.74257, 33.86115], [-117.74311, 33.86118], [-117.74314, 33.86121], [-117.74333, 33.86122], [-117.74374, 33.862], [-117.7438, 33.86207], [-117.74386, 33.86211], [-117.74396, 33.86211], [-117.74386, 33.86191], [-117.74483, 33.86225], [-117.74497, 33.86239], [-117.74506, 33.86256]]]} | Open Access 1 | Sycamore Park | 26132 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 8.7 | Sycamore Park | ||
9982 | 9982 | 9981 | {"type": "Polygon", "coordinates": [[[-117.93509, 33.80131], [-117.93497, 33.80155], [-117.93486, 33.80182], [-117.93484, 33.80146], [-117.93281, 33.80149], [-117.93277, 33.79962], [-117.93439, 33.7996], [-117.93441, 33.79927], [-117.93463, 33.79924], [-117.93474, 33.79916], [-117.93476, 33.7992], [-117.93482, 33.79925], [-117.93494, 33.79927], [-117.93469, 33.79957], [-117.93481, 33.79959], [-117.93485, 33.80118], [-117.93509, 33.80131]]]} | Open Access 1 | Stoddard Park | 25863 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 10.254 | Stoddard Park | ||
9403 | 9403 | 9402 | {"type": "Polygon", "coordinates": [[[-117.99126, 33.82849], [-117.99003, 33.82913], [-117.98967, 33.82933], [-117.98907, 33.82959], [-117.98877, 33.82969], [-117.98802, 33.82985], [-117.98735, 33.8299], [-117.98591, 33.82989], [-117.98591, 33.82959], [-117.98651, 33.82954], [-117.98673, 33.8295], [-117.98693, 33.8294], [-117.98711, 33.82922], [-117.98711, 33.8292], [-117.98675, 33.829], [-117.98687, 33.82878], [-117.98689, 33.82848], [-117.99125, 33.82844], [-117.99126, 33.82849]]]} | Open Access 1 | Schweitzer Park | 25199 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 11.666 | Schweitzer Park | ||
9096 | 9096 | 9095 | {"type": "Polygon", "coordinates": [[[-117.93511, 33.84336], [-117.9335, 33.84442], [-117.93317, 33.84477], [-117.9326, 33.84477], [-117.93259, 33.84427], [-117.93218, 33.84426], [-117.93211, 33.84425], [-117.93202, 33.84419], [-117.93347, 33.84416], [-117.93346, 33.84229], [-117.93504, 33.84216], [-117.93505, 33.84334], [-117.93511, 33.84336]]]} | Open Access 1 | Sage Park | 24783 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 8.11 | Sage Park | ||
9001 | 9001 | 9000 | {"type": "Polygon", "coordinates": [[[-117.93062, 33.82917], [-117.93055, 33.82919], [-117.9303, 33.82908], [-117.92925, 33.82854], [-117.92857, 33.8279], [-117.92857, 33.82754], [-117.93002, 33.8277], [-117.93055, 33.82798], [-117.93062, 33.82917]]]} | Open Access 1 | Ross Park | 24676 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 4.979 | Ross 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 | ||
8924 | 8924 | 8923 | {"type": "Polygon", "coordinates": [[[-117.73239, 33.85914], [-117.73185, 33.8594], [-117.73177, 33.85946], [-117.7313, 33.85968], [-117.7312, 33.85976], [-117.73116, 33.85986], [-117.73117, 33.86001], [-117.73134, 33.86024], [-117.73135, 33.86028], [-117.73135, 33.8606], [-117.73121, 33.86086], [-117.73111, 33.86091], [-117.73101, 33.86099], [-117.73095, 33.861], [-117.73083, 33.861], [-117.73071, 33.86097], [-117.73048, 33.86077], [-117.73002, 33.86076], [-117.72975, 33.86067], [-117.72967, 33.86062], [-117.72926, 33.86047], [-117.72908, 33.86032], [-117.72889, 33.86023], [-117.7288, 33.86014], [-117.72868, 33.86007], [-117.72826, 33.8597], [-117.72824, 33.8597], [-117.72805, 33.85945], [-117.72815, 33.85946], [-117.72873, 33.85927], [-117.7294, 33.85914], [-117.72983, 33.85901], [-117.73006, 33.85891], [-117.73035, 33.85877], [-117.73064, 33.85857], [-117.7308, 33.85844], [-117.73131, 33.85781], [-117.73166, 33.8578], [-117.73177, 33.85791], [-117.73181, 33.85816], [-117.73201, 33.85839], [-117.73219, 33.85865], [-117.73223, 33.85873], [-117.73227, 33.85897], [-117.73239, 33.85914]]]} | Open Access 1 | Ronald Reagan Park | 24589 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 16.077 | Ronald Reagan Park | ||
8781 | 8781 | 8780 | {"type": "Polygon", "coordinates": [[[-117.81994, 33.85368], [-117.8184, 33.85415], [-117.81795, 33.85199], [-117.81887, 33.85177], [-117.8195, 33.85168], [-117.81994, 33.85368]]]} | Open Access 1 | Riverdale Park | 24440 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 8.668 | Riverdale Park | ||
8728 | 8728 | 8727 | {"type": "Polygon", "coordinates": [[[-117.86937, 33.84275], [-117.86936, 33.84278], [-117.86919, 33.84278], [-117.86918, 33.84293], [-117.86871, 33.84295], [-117.86874, 33.84437], [-117.86727, 33.84438], [-117.86726, 33.84355], [-117.86728, 33.84338], [-117.86741, 33.84303], [-117.86744, 33.84286], [-117.86744, 33.84196], [-117.86746, 33.84193], [-117.86925, 33.84194], [-117.86928, 33.84197], [-117.86929, 33.84202], [-117.86929, 33.84212], [-117.86925, 33.84232], [-117.8693, 33.84243], [-117.86936, 33.84248], [-117.86936, 33.84274], [-117.86937, 33.84275]]]} | Open Access 1 | Rio Vista Park | 24387 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 9.898 | Rio Vista Park | ||
8629 | 8629 | 8628 | {"type": "Polygon", "coordinates": [[[-118.00047, 33.82235], [-117.99948, 33.82237], [-117.99948, 33.82277], [-117.99945, 33.82286], [-117.99947, 33.82456], [-117.99945, 33.82459], [-117.99687, 33.82462], [-117.99682, 33.82459], [-117.99677, 33.82122], [-117.99678, 33.82121], [-117.99682, 33.8212], [-117.9976, 33.82119], [-117.99768, 33.82115], [-117.99771, 33.82112], [-117.99774, 33.82106], [-117.99774, 33.82101], [-117.9997, 33.82099], [-118.00047, 33.82235]]]} | Open Access 1 | Reid Park | 24278 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 26.111 | Reid Park | ||
8300 | 8300 | 8299 | {"type": "Polygon", "coordinates": [[[-117.90621, 33.79599], [-117.90614, 33.79601], [-117.90421, 33.79601], [-117.90418, 33.79433], [-117.90616, 33.79433], [-117.90621, 33.79493], [-117.90621, 33.79599]]]} | Open Access 1 | Ponderosa Park | 23887 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 8.562 | Ponderosa Park | ||
8178 | 8178 | 8177 | {"type": "Polygon", "coordinates": [[[-117.8803, 33.84433], [-117.88029, 33.84459], [-117.87961, 33.84466], [-117.87825, 33.84498], [-117.87823, 33.84546], [-117.87709, 33.84548], [-117.87706, 33.84556], [-117.87658, 33.84557], [-117.87656, 33.84532], [-117.87648, 33.84473], [-117.87645, 33.84441], [-117.87642, 33.84389], [-117.87648, 33.84386], [-117.87646, 33.84365], [-117.87665, 33.84365], [-117.87666, 33.84368], [-117.8767, 33.84373], [-117.87677, 33.84377], [-117.87682, 33.84377], [-117.87697, 33.84372], [-117.87813, 33.8437], [-117.87959, 33.84372], [-117.87972, 33.84372], [-117.88014, 33.84366], [-117.88021, 33.84366], [-117.88024, 33.84368], [-117.88026, 33.84382], [-117.88026, 33.84431], [-117.8803, 33.84433]]]} | Open Access 1 | Pioneer Park | 23717 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 13.39 | Pioneer 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]);