superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
47 rows where MNG_AGENCY = 178 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1105 | 1105 | 1104 | {"type": "Polygon", "coordinates": [[[-117.6886, 33.60417], [-117.68825, 33.60431], [-117.6882, 33.60422], [-117.68803, 33.60404], [-117.68833, 33.60382], [-117.68851, 33.60403], [-117.6886, 33.60417]]]} | Open Access 1 | Aegean Hills Park | 15279 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 0.371 | Aegean Hills Park | ||
9651 | 9651 | 9650 | {"type": "Polygon", "coordinates": [[[-117.65991, 33.57138], [-117.65929, 33.57205], [-117.65919, 33.57231], [-117.65879, 33.57224], [-117.65903, 33.57148], [-117.65913, 33.57108], [-117.65915, 33.57105], [-117.65922, 33.57103], [-117.6594, 33.57105], [-117.65977, 33.57122], [-117.65989, 33.57131], [-117.65991, 33.57138]]]} | Open Access 1 | Sierra Recreation and Fitness Center | 25465 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1.867 | Sierra Rec. and Fitness Ctr. | ||
10649 | 10649 | 10648 | {"type": "Polygon", "coordinates": [[[-117.66274, 33.61347], [-117.66203, 33.61356], [-117.66193, 33.61345], [-117.66163, 33.61332], [-117.66218, 33.61239], [-117.66223, 33.61233], [-117.66254, 33.61252], [-117.66263, 33.61302], [-117.66274, 33.61347]]]} | Open Access 1 | Valyermo Park | 26817 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 2.063 | Valyermo Park | ||
2513 | 2513 | 2512 | {"type": "Polygon", "coordinates": [[[-117.66509, 33.54532], [-117.66509, 33.54537], [-117.66485, 33.5456], [-117.66459, 33.54543], [-117.66447, 33.54554], [-117.66421, 33.54565], [-117.66382, 33.54567], [-117.66381, 33.54592], [-117.66359, 33.54592], [-117.66363, 33.54552], [-117.66399, 33.54479], [-117.6637, 33.54467], [-117.66378, 33.54451], [-117.66397, 33.54457], [-117.66457, 33.54522], [-117.66484, 33.54507], [-117.66509, 33.54532]]]} | Open Access 1 | Coronado Park | 17649 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 2.188 | Coronado Park | ||
3661 | 3661 | 3660 | {"type": "Polygon", "coordinates": [[[-117.68287, 33.60339], [-117.68268, 33.60396], [-117.68173, 33.60375], [-117.68138, 33.60285], [-117.68287, 33.60339]]]} | Open Access 1 | Doria Park | 18218 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 2.22 | Doria Park | ||
8389 | 8389 | 8388 | {"type": "Polygon", "coordinates": [[[-117.65858, 33.60084], [-117.65798, 33.60249], [-117.65763, 33.60226], [-117.65741, 33.60223], [-117.65744, 33.60221], [-117.65762, 33.60173], [-117.65799, 33.60071], [-117.65858, 33.60084]]]} | Open Access 1 | Preciados Park | 23978 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 2.53 | Preciados Park | ||
2924 | 2924 | 2923 | {"type": "Polygon", "coordinates": [[[-117.66415, 33.61724], [-117.66405, 33.61732], [-117.66356, 33.61759], [-117.6638, 33.61778], [-117.66376, 33.61793], [-117.66308, 33.61752], [-117.66315, 33.6173], [-117.66285, 33.6172], [-117.66284, 33.61715], [-117.66279, 33.61708], [-117.66284, 33.61702], [-117.66267, 33.61644], [-117.66327, 33.6163], [-117.66335, 33.61658], [-117.66415, 33.61724]]]} | Open Access 1 | Christopher Park | 17232 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 2.832 | Christopher Park | ||
7920 | 7920 | 7919 | {"type": "Polygon", "coordinates": [[[-117.65952, 33.63459], [-117.65929, 33.63513], [-117.65869, 33.63501], [-117.65815, 33.635], [-117.65822, 33.63464], [-117.65848, 33.63463], [-117.65853, 33.63459], [-117.65867, 33.63443], [-117.65867, 33.63404], [-117.65884, 33.63367], [-117.6592, 33.6335], [-117.65928, 33.63361], [-117.65933, 33.63371], [-117.65934, 33.6338], [-117.65929, 33.63415], [-117.65931, 33.6343], [-117.65939, 33.63445], [-117.65952, 33.63459]]]} | Open Access 1 | Santa Maria Open Space | 25114 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 3.01 | Santa Maria OS | ||
6521 | 6521 | 6520 | {"type": "Polygon", "coordinates": [[[-117.66963, 33.58289], [-117.66954, 33.58291], [-117.66938, 33.58291], [-117.66935, 33.58294], [-117.66925, 33.58295], [-117.66913, 33.58293], [-117.66909, 33.58295], [-117.66892, 33.58289], [-117.6688, 33.58289], [-117.66822, 33.58268], [-117.66793, 33.58253], [-117.66789, 33.58254], [-117.66739, 33.58311], [-117.66739, 33.58316], [-117.66721, 33.58291], [-117.6673, 33.58286], [-117.66744, 33.58276], [-117.66788, 33.5823], [-117.66815, 33.58244], [-117.66826, 33.58235], [-117.6693, 33.58181], [-117.66963, 33.58289]]]} | Open Access 1 | Madrid Fore Park | 21662 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 3.181 | Madrid Fore Park | ||
1752 | 1752 | 1751 | {"type": "Polygon", "coordinates": [[[-117.65338, 33.57827], [-117.65327, 33.57829], [-117.65319, 33.57832], [-117.65311, 33.57841], [-117.65252, 33.57938], [-117.6515, 33.57897], [-117.65142, 33.57895], [-117.65131, 33.57897], [-117.65136, 33.57891], [-117.65146, 33.57884], [-117.65149, 33.57885], [-117.65167, 33.57868], [-117.65227, 33.57803], [-117.65338, 33.57827]]]} | Open Access 1 | Barbadanes Park | 15804 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 3.37 | Barbadanes Park | ||
5162 | 5162 | 5161 | {"type": "Polygon", "coordinates": [[[-117.66576, 33.59428], [-117.66576, 33.59428], [-117.66461, 33.5953], [-117.6644, 33.59463], [-117.66432, 33.59387], [-117.66454, 33.59352], [-117.66515, 33.59387], [-117.66576, 33.59428]]]} | Open Access 1 | Linda Vista Park | 21284 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 3.423 | Linda Vista Park | ||
6631 | 6631 | 6630 | {"type": "Polygon", "coordinates": [[[-117.67129, 33.60231], [-117.67127, 33.60295], [-117.67121, 33.6035], [-117.66979, 33.60287], [-117.6702, 33.60214], [-117.67114, 33.6022], [-117.67129, 33.60231]]]} | Open Access 1 | Marguerite M. O'Neill Park | 21807 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 3.489 | Marguerite M. O'Neill Park | ||
1759 | 1759 | 1758 | {"type": "Polygon", "coordinates": [[[-117.65837, 33.63225], [-117.65835, 33.63227], [-117.65821, 33.63231], [-117.65796, 33.63233], [-117.65783, 33.63242], [-117.65752, 33.63232], [-117.65736, 33.63233], [-117.65733, 33.63239], [-117.65718, 33.63239], [-117.65721, 33.63178], [-117.65731, 33.63152], [-117.6573, 33.63142], [-117.65727, 33.63131], [-117.65719, 33.63111], [-117.65714, 33.63103], [-117.65827, 33.63102], [-117.65825, 33.63123], [-117.65826, 33.63171], [-117.65832, 33.63204], [-117.65838, 33.6322], [-117.65837, 33.63225]]]} | Open Access 1 | Barcelona Park | 15811 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 3.58 | Barcelona Park | ||
7304 | 7304 | 7303 | {"type": "Polygon", "coordinates": [[[-117.64915, 33.57941], [-117.64761, 33.58031], [-117.64747, 33.5801], [-117.64726, 33.57969], [-117.64714, 33.57936], [-117.64711, 33.57919], [-117.64712, 33.57916], [-117.64716, 33.57916], [-117.64753, 33.57917], [-117.64795, 33.57916], [-117.64821, 33.57912], [-117.64872, 33.579], [-117.64876, 33.57903], [-117.64892, 33.57921], [-117.64915, 33.57941]]]} | Open Access 1 | Napoli Park | 22634 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 3.7 | Napoli Park | ||
4684 | 4684 | 4683 | {"type": "Polygon", "coordinates": [[[-117.6702, 33.56906], [-117.66956, 33.56956], [-117.6689, 33.56945], [-117.6687, 33.5694], [-117.6685, 33.56933], [-117.66786, 33.56901], [-117.66799, 33.56889], [-117.66836, 33.56863], [-117.66868, 33.56851], [-117.66882, 33.56849], [-117.66905, 33.56848], [-117.66928, 33.56852], [-117.66962, 33.56864], [-117.66971, 33.56869], [-117.6702, 33.56906]]]} | Open Access 1 | Granada Park | 19420 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 4.004 | Granada Park | ||
10948 | 10948 | 10947 | {"type": "Polygon", "coordinates": [[[-117.64997, 33.63266], [-117.64996, 33.63275], [-117.64987, 33.63271], [-117.64983, 33.63274], [-117.64991, 33.63303], [-117.64986, 33.63303], [-117.64978, 33.63276], [-117.64976, 33.63274], [-117.64963, 33.63278], [-117.6495, 33.6329], [-117.64943, 33.63302], [-117.64941, 33.63326], [-117.64935, 33.6334], [-117.64908, 33.63374], [-117.64897, 33.63392], [-117.64866, 33.63426], [-117.64811, 33.63392], [-117.64791, 33.63382], [-117.64785, 33.6337], [-117.64799, 33.63347], [-117.64828, 33.63309], [-117.64855, 33.63278], [-117.64888, 33.63244], [-117.64907, 33.63257], [-117.64908, 33.6326], [-117.64933, 33.63271], [-117.64938, 33.6327], [-117.64956, 33.63255], [-117.64993, 33.63262], [-117.64997, 33.63266]]]} | Open Access 1 | Vista del Lago Park | 27169 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 4.443 | Vista del Lago Park | ||
9487 | 9487 | 9486 | {"type": "Polygon", "coordinates": [[[-117.64168, 33.58106], [-117.64158, 33.58129], [-117.6415, 33.58175], [-117.64151, 33.58196], [-117.64148, 33.58213], [-117.6415, 33.58215], [-117.64141, 33.58232], [-117.6414, 33.58241], [-117.64131, 33.58245], [-117.64004, 33.58133], [-117.64058, 33.58055], [-117.64068, 33.58051], [-117.6408, 33.58049], [-117.64088, 33.58052], [-117.64126, 33.58083], [-117.64168, 33.58106]]]} | Open Access 1 | Segeant Matt Davis Park | 25285 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 4.507 | Segeant Matt Davis Park | ||
6458 | 6458 | 6457 | {"type": "Polygon", "coordinates": [[[-117.66224, 33.63381], [-117.66181, 33.63461], [-117.66127, 33.63446], [-117.6612, 33.63449], [-117.66116, 33.63445], [-117.66112, 33.63444], [-117.661, 33.63444], [-117.66098, 33.6344], [-117.66072, 33.63435], [-117.66058, 33.6344], [-117.66005, 33.63433], [-117.65993, 33.63429], [-117.65982, 33.6342], [-117.65953, 33.63436], [-117.65946, 33.63418], [-117.65947, 33.63398], [-117.65952, 33.63381], [-117.66028, 33.6337], [-117.66049, 33.63371], [-117.66075, 33.63353], [-117.66085, 33.63356], [-117.66095, 33.63345], [-117.66139, 33.63361], [-117.66143, 33.63365], [-117.66147, 33.63368], [-117.66159, 33.63367], [-117.66168, 33.6336], [-117.66224, 33.63381]]]} | Open Access 1 | Loyola Park Open Space | 21572 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 4.931 | Loyola Park OS | ||
3898 | 3898 | 3897 | {"type": "Polygon", "coordinates": [[[-117.66962, 33.60827], [-117.66943, 33.60877], [-117.66909, 33.60876], [-117.66898, 33.60895], [-117.66894, 33.60921], [-117.66885, 33.60956], [-117.66878, 33.60971], [-117.66865, 33.61009], [-117.66865, 33.61025], [-117.66791, 33.61023], [-117.66834, 33.60814], [-117.66845, 33.60811], [-117.66883, 33.60811], [-117.66922, 33.60817], [-117.66962, 33.60827]]]} | Open Access 1 | El Dorado Park | 18506 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 4.934 | El Dorado Park | ||
5813 | 5813 | 5812 | {"type": "Polygon", "coordinates": [[[-117.6615, 33.57871], [-117.66129, 33.57869], [-117.66125, 33.57872], [-117.6611, 33.57875], [-117.66098, 33.57874], [-117.66089, 33.57887], [-117.66079, 33.57886], [-117.6607, 33.57889], [-117.66059, 33.57876], [-117.66029, 33.57888], [-117.66009, 33.57904], [-117.66003, 33.57908], [-117.65941, 33.57921], [-117.65933, 33.57924], [-117.65924, 33.57932], [-117.65921, 33.5794], [-117.6592, 33.57953], [-117.65916, 33.57957], [-117.65887, 33.57955], [-117.65884, 33.57966], [-117.65879, 33.57958], [-117.65872, 33.57955], [-117.65868, 33.57955], [-117.65862, 33.57898], [-117.65874, 33.57898], [-117.65876, 33.579], [-117.65904, 33.57897], [-117.65906, 33.57899], [-117.65927, 33.5789], [-117.6593, 33.57892], [-117.65958, 33.57882], [-117.6596, 33.57883], [-117.65981, 33.57869], [-117.65984, 33.57869], [-117.66001, 33.57856], [-117.66004, 33.57856], [-117.66023, 33.57839], [-117.66037, 33.57819], [-117.66036, 33.57815], [-117.66034, 33.57813], [-117.66009, 33.57804], [-117.66014, 33.57789], [-117.66014, 33.57771], [-117.66065, 33.5777], [-117.66072, 33.57727], [-117.66086, 33.57729], [-117.66084, 33.57733], [-117.66083, 33.57742], [-117.66097, 33.57778], [-117.66114, 33.57805], [-117.66121, 33.57803], [-117.66132, 33.57819], [-117.66144, 33.57846], [-117.6615, 33.57871]]]} | Open Access 1 | La Mancha Park | 20772 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 5.081 | La Mancha 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]);