superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where MNG_AGENCY = 57 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2436 | 2436 | 2435 | {"type": "Polygon", "coordinates": [[[-117.91223, 33.83697], [-117.91193, 33.83704], [-117.91187, 33.83683], [-117.91216, 33.83677], [-117.91223, 33.83697]]]} | Open Access 1 | Colony Square | 17539 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.163 | Colony Square | ||
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 | |
3224 | 3224 | 3223 | {"type": "Polygon", "coordinates": [[[-117.92104, 33.8216], [-117.92098, 33.82164], [-117.92092, 33.82159], [-117.92078, 33.82154], [-117.92025, 33.82105], [-117.92021, 33.82099], [-117.92044, 33.82094], [-117.92052, 33.82104], [-117.92104, 33.8216]]]} | Open Access 1 | Cottonwood Park | 17687 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.387 | Cottonwood 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 | ||
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 | ||
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 | ||
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 | |
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 |
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 | ||
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 | ||
3109 | 3109 | 3108 | {"type": "Polygon", "coordinates": [[[-117.90684, 33.83022], [-117.90683, 33.83026], [-117.90596, 33.83046], [-117.90591, 33.83044], [-117.90591, 33.83039], [-117.90594, 33.83034], [-117.90592, 33.83019], [-117.90585, 33.83018], [-117.9058, 33.83014], [-117.9058, 33.8301], [-117.90582, 33.83006], [-117.90674, 33.82985], [-117.90677, 33.82996], [-117.90673, 33.83006], [-117.90674, 33.83011], [-117.90684, 33.83022]]]} | Open Access 1 | Colony Park | 17534 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 0.953 | Colony Park | ||
4548 | 4548 | 4547 | {"type": "Polygon", "coordinates": [[[-117.91259, 33.83804], [-117.91258, 33.83808], [-117.91185, 33.83823], [-117.91182, 33.83819], [-117.91156, 33.83744], [-117.91234, 33.83726], [-117.91259, 33.83804]]]} | Open Access 1 | George Washington Park | 19275 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1.678 | George Washington 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 | ||
4030 | 4030 | 4029 | {"type": "Polygon", "coordinates": [[[-117.93457, 33.80691], [-117.93442, 33.80719], [-117.93423, 33.80745], [-117.93415, 33.80743], [-117.93406, 33.80742], [-117.93397, 33.80743], [-117.93389, 33.8074], [-117.93377, 33.8074], [-117.93373, 33.80741], [-117.93365, 33.80747], [-117.93366, 33.80767], [-117.93284, 33.80768], [-117.93284, 33.80692], [-117.93457, 33.80691]]]} | Open Access 1 | Energy Field Park | 18673 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 2.55 | Energy Field Park | ||
2959 | 2959 | 2958 | {"type": "Polygon", "coordinates": [[[-117.90715, 33.83743], [-117.90706, 33.83744], [-117.90704, 33.8374], [-117.90695, 33.83742], [-117.90685, 33.83739], [-117.90676, 33.83739], [-117.90674, 33.83733], [-117.90667, 33.83734], [-117.90666, 33.8374], [-117.90662, 33.83743], [-117.90654, 33.83742], [-117.90641, 33.83707], [-117.90577, 33.83514], [-117.90619, 33.83504], [-117.90682, 33.83697], [-117.90702, 33.83706], [-117.90715, 33.83743]]]} | Open Access 1 | Citrus Park | 17283 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 2.787 | Citrus 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 | ||
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 | |||
1319 | 1319 | 1318 | {"type": "Polygon", "coordinates": [[[-117.7455, 33.84239], [-117.74527, 33.84244], [-117.74511, 33.84249], [-117.74493, 33.84267], [-117.74482, 33.8429], [-117.74482, 33.84306], [-117.74493, 33.84329], [-117.74499, 33.84337], [-117.7443, 33.84341], [-117.74474, 33.84199], [-117.74489, 33.84174], [-117.74538, 33.84107], [-117.74549, 33.84113], [-117.7455, 33.84239]]]} | Open Access 1 | Anaheim holding 2 | 15467 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 3.08 | Anaheim holding 2 | ||
1322 | 1322 | 1321 | {"type": "Polygon", "coordinates": [[[-117.97816, 33.85487], [-117.97665, 33.85405], [-117.97656, 33.85345], [-117.97814, 33.85344], [-117.97816, 33.85487]]]} | Open Access 1 | Anaheim holding 3 | 15468 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 3.955 | Anaheim holding 3 | ||
1332 | 1332 | 1331 | {"type": "Polygon", "coordinates": [[[-117.78356, 33.84518], [-117.78356, 33.84564], [-117.78066, 33.84564], [-117.78019, 33.84566], [-117.78021, 33.84548], [-117.78026, 33.84543], [-117.78065, 33.84536], [-117.78158, 33.84505], [-117.78172, 33.84502], [-117.78206, 33.84499], [-117.7823, 33.845], [-117.78248, 33.84499], [-117.78356, 33.84518]]]} | Open Access 1 | Anaheim holding 4 | 15469 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 4.264 | Anaheim holding 4 |
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]);