units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
47 rows where MNG_AGENCY = 178 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 3
MNG_AG_TYP 1
- City Agency · 47 ✖
MNG_AGENCY 1
- Mission Viejo, City of · 47 ✖
ACCESS_TYP 1
- Open Access 47
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1280 | 1280 | 1279 | {"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 | 9876 | Aegean Hills Park | 15279 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 0.371 | Aegean Hills Park | 0 | Local Park 2 | 4 | |
16819 | 16819 | 16818 | {"type": "Polygon", "coordinates": [[[-117.65922, 33.57103], [-117.6594, 33.57105], [-117.65977, 33.57122], [-117.65989, 33.57131], [-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]]]} | Open Access 1 | 30530 | Sierra Recreation and Fitness Center | 25465 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 1.868 | Sierra Rec. and Fitness Ctr. | 0 | Local Recreation Area 3 | 4 | |
5338 | 5338 | 5337 | {"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 | 24605 | Valyermo Park | 26817 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 2.064 | Valyermo Park | 0 | Local Park 2 | 4 | |
8120 | 8120 | 8119 | {"type": "Polygon", "coordinates": [[[-117.66485, 33.5456], [-117.66459, 33.54543], [-117.66447, 33.54554], [-117.66421, 33.54565], [-117.66381, 33.54567], [-117.66381, 33.54592], [-117.66359, 33.54592], [-117.66363, 33.54552], [-117.664, 33.54478], [-117.6637, 33.54467], [-117.66378, 33.54451], [-117.66397, 33.54457], [-117.66457, 33.54522], [-117.66484, 33.54507], [-117.66509, 33.54532], [-117.66509, 33.54537], [-117.66485, 33.5456]]]} | Open Access 1 | 12287 | Coronado Park | 17649 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 2.178 | Coronado Park | 0 | Local Park 2 | 4 | |
10527 | 10527 | 10526 | {"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 | 18723 | Doria Park | 18218 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 2.22 | Doria Park | 0 | Local Park 2 | 4 | |
7503 | 7503 | 7502 | {"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 | 8895 | Preciados Park | 23978 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 2.53 | Preciados Park | 0 | Local Park 2 | 4 | |
2449 | 2449 | 2448 | {"type": "Polygon", "coordinates": [[[-117.66415, 33.61724], [-117.66405, 33.61732], [-117.66355, 33.61759], [-117.6638, 33.61778], [-117.66376, 33.61793], [-117.66308, 33.61752], [-117.66316, 33.61729], [-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 | 12180 | Christopher Park | 17232 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 2.824 | Christopher Park | 0 | Local Park 2 | 4 | |
16098 | 16098 | 16097 | {"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.63379], [-117.65929, 33.63415], [-117.65931, 33.6343], [-117.65939, 33.63445], [-117.65952, 33.63459]]]} | Open Access 1 | 12624 | Santa Maria Open Space | 25114 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 3.009 | Santa Maria OS | 0 | Local Recreation Area 3 | 4 | |
757 | 757 | 756 | {"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.58312], [-117.66739, 33.58316], [-117.66721, 33.58291], [-117.6673, 33.58287], [-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 | 4949 | Madrid Fore Park | 21662 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 3.179 | Madrid Fore Park | 0 | Local Park 2 | 4 | |
5247 | 5247 | 5246 | {"type": "Polygon", "coordinates": [[[-117.65338, 33.57827], [-117.65327, 33.57829], [-117.65319, 33.57833], [-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 | 1343 | Barbadanes Park | 15804 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 3.369 | Barbadanes Park | 0 | Local Park 2 | 4 | |
6594 | 6594 | 6593 | {"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 | 4204 | Linda Vista Park | 21284 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 3.423 | Linda Vista Park | 0 | Local Park 2 | 4 | |
1442 | 1442 | 1441 | {"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 | 12483 | Marguerite M. O'Neill Park | 21807 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 3.49 | Marguerite M. O'Neill Park | 0 | Local Park 2 | 4 | |
5199 | 5199 | 5198 | {"type": "Polygon", "coordinates": [[[-117.65837, 33.63225], [-117.65835, 33.63227], [-117.65821, 33.63231], [-117.65795, 33.63233], [-117.65783, 33.63242], [-117.65752, 33.63232], [-117.65735, 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 | 24600 | Barcelona Park | 15811 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 3.579 | Barcelona Park | 0 | Local Park 2 | 4 | |
5320 | 5320 | 5319 | {"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 | 5594 | Napoli Park | 22634 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 3.701 | Napoli Park | 0 | Local Park 2 | 4 | |
8135 | 8135 | 8134 | {"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.66961, 33.56864], [-117.66971, 33.56869], [-117.6702, 33.56906]]]} | Open Access 1 | 12317 | Granada Park | 19420 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 4.005 | Granada Park | 0 | Local Park 2 | 4 | |
9115 | 9115 | 9114 | {"type": "Polygon", "coordinates": [[[-117.64997, 33.63266], [-117.64996, 33.63275], [-117.64987, 33.63271], [-117.64983, 33.63273], [-117.64991, 33.63303], [-117.64986, 33.63303], [-117.64978, 33.63276], [-117.64976, 33.63274], [-117.64962, 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 | 15107 | Vista del Lago Park | 27169 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 4.442 | Vista del Lago Park | 0 | Local Park 2 | 4 | |
12844 | 12844 | 12843 | {"type": "Polygon", "coordinates": [[[-117.64168, 33.58106], [-117.64158, 33.58129], [-117.6415, 33.58175], [-117.64151, 33.58196], [-117.64148, 33.58214], [-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.64127, 33.58083], [-117.64168, 33.58106]]]} | Open Access 1 | 30294 | Segeant Matt Davis Park | 25285 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 4.507 | Segeant Matt Davis Park | 0 | Local Park 2 | 4 | |
8215 | 8215 | 8214 | {"type": "Polygon", "coordinates": [[[-117.66224, 33.63381], [-117.66181, 33.63461], [-117.66127, 33.63445], [-117.6612, 33.63449], [-117.66116, 33.63445], [-117.66111, 33.63444], [-117.661, 33.63444], [-117.66098, 33.6344], [-117.66071, 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.63357], [-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 | 12476 | Loyola Park Open Space | 21572 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 4.929 | Loyola Park OS | 0 | Local Recreation Area 3 | 4 | |
1028 | 1028 | 1027 | {"type": "Polygon", "coordinates": [[[-117.66962, 33.60827], [-117.66943, 33.60877], [-117.66909, 33.60876], [-117.66897, 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 | 5641 | El Dorado Park | 18506 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 4.933 | El Dorado Park | 0 | Local Park 2 | 4 | |
5748 | 5748 | 5747 | {"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.6606, 33.57876], [-117.66029, 33.57888], [-117.66009, 33.57904], [-117.66003, 33.57908], [-117.6594, 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.65875, 33.579], [-117.65904, 33.57897], [-117.65905, 33.57899], [-117.65927, 33.5789], [-117.65929, 33.57892], [-117.65958, 33.57882], [-117.6596, 33.57884], [-117.65981, 33.57869], [-117.65984, 33.5787], [-117.66001, 33.57856], [-117.66003, 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.57806], [-117.66121, 33.57803], [-117.66132, 33.57819], [-117.66144, 33.57846], [-117.6615, 33.57871]]]} | Open Access 1 | 3150 | La Mancha Park | 20772 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 5.072 | La Mancha Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);