superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where MNG_AGENCY = 261 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2534 | 2534 | 2533 | {"type": "Polygon", "coordinates": [[[-117.68995, 34.02217], [-117.68981, 34.02217], [-117.68967, 34.02214], [-117.68951, 34.02207], [-117.68951, 34.022], [-117.68995, 34.022], [-117.68995, 34.02217]]]} | Open Access 1 | Carolyn Owens Centennial Square | http://www.cityofchino.org/government-services/community-services/parks/carolyn-owens-centennial-square | 16889 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.156 | Carolyn Owens Centennial Square | |
112 | 112 | 111 | {"type": "Polygon", "coordinates": [[[-117.6908, 34.02102], [-117.69079, 34.02124], [-117.69076, 34.02128], [-117.69068, 34.02129], [-117.69063, 34.02129], [-117.69057, 34.02125], [-117.69057, 34.02103], [-117.69059, 34.02098], [-117.69063, 34.02096], [-117.6907, 34.02096], [-117.69078, 34.02099], [-117.6908, 34.02102]]]} | Open Access 1 | 7th Street Park | http://www.cityofchino.org/government-services/community-services/parks/7th-street-park | 15215 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.175 | 7th Street Park | |
13607 | 13607 | 13606 | {"type": "Polygon", "coordinates": [[[-117.62599, 33.96845], [-117.62557, 33.96845], [-117.62557, 33.96815], [-117.62593, 33.96813], [-117.62594, 33.96816], [-117.62598, 33.96816], [-117.62599, 33.96845]]]} | Open Access 1 | Evergreen Park | http://www.cityofchino.org/government-services/community-services/parks/evergreen-park | 31066 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.321 | Evergreen Park | |
13611 | 13611 | 13610 | {"type": "Polygon", "coordinates": [[[-117.63077, 33.96688], [-117.63073, 33.96692], [-117.63049, 33.96692], [-117.63049, 33.96646], [-117.6307, 33.96646], [-117.63074, 33.96647], [-117.63077, 33.9665], [-117.63077, 33.96688]]]} | Open Access 1 | Secret Garden Park | http://www.cityofchino.org/government-services/community-services/parks/secret-garden-park | 31071 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.324 | Secret Garden Park | |
13609 | 13609 | 13608 | {"type": "Polygon", "coordinates": [[[-117.6212, 33.96792], [-117.62116, 33.96804], [-117.621, 33.96806], [-117.621, 33.96848], [-117.62076, 33.96848], [-117.62075, 33.96806], [-117.62093, 33.96801], [-117.62113, 33.9679], [-117.6212, 33.96792]]]} | Open Access 1 | Mulberry Park | http://www.cityofchino.org/government-services/community-services/parks/mulberry-park | 31069 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.343 | Mulberry Park | |
13608 | 13608 | 13607 | {"type": "Polygon", "coordinates": [[[-117.66232, 33.99133], [-117.66227, 33.99137], [-117.66169, 33.99137], [-117.66161, 33.99131], [-117.66161, 33.9912], [-117.66166, 33.99116], [-117.66227, 33.99115], [-117.66232, 33.99119], [-117.66232, 33.99133]]]} | Open Access 1 | Inspiration Park | http://www.cityofchino.org/government-services/community-services/parks/inspiration-park | 31068 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.377 | Inspiration Park | |
13610 | 13610 | 13609 | {"type": "Polygon", "coordinates": [[[-117.69359, 34.01964], [-117.69329, 34.01965], [-117.69328, 34.01913], [-117.69352, 34.01913], [-117.69358, 34.01916], [-117.69359, 34.01964]]]} | Open Access 1 | Oak Tree Square Park | http://www.cityofchino.org/government-services/community-services/parks/oak-tree-square-park | 31070 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.384 | Oak Tree Square Park | |
13218 | 13218 | 13217 | {"type": "Polygon", "coordinates": [[[-117.61843, 33.96746], [-117.6181, 33.96746], [-117.61793, 33.96713], [-117.61793, 33.9671], [-117.61819, 33.96702], [-117.61828, 33.96695], [-117.61838, 33.96722], [-117.61843, 33.96746]]]} | Open Access 1 | Hidden Hollow Park | http://www.cityofchino.org/government-services/community-services/parks/hidden-hollow-park | 31067 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.407 | Hidden Hollow Park | |
9472 | 9472 | 9471 | {"type": "Polygon", "coordinates": [[[-117.67536, 34.02858], [-117.67469, 34.02859], [-117.67468, 34.0282], [-117.67535, 34.02819], [-117.67536, 34.02858]]]} | Open Access 1 | Sebring Park | http://www.cityofchino.org/government-services/community-services/parks/sebring-park | 25275 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.665 | Sebring Park | |
1415 | 1415 | 1414 | {"type": "Polygon", "coordinates": [[[-117.69167, 34.01455], [-117.69121, 34.01455], [-117.6912, 34.0139], [-117.69167, 34.01389], [-117.69167, 34.01455]]]} | Open Access 1 | Aguiar Square | http://www.cityofchino.org/government-services/community-services/parks/aguiar-square | 15296 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.78 | Aguiar Square | |
3216 | 3216 | 3215 | {"type": "Polygon", "coordinates": [[[-117.67517, 34.0201], [-117.67477, 34.0201], [-117.67476, 34.0193], [-117.67517, 34.0193], [-117.67517, 34.0201]]]} | Open Access 1 | Community Garden Pocket Park | https://www.cityofchino.org/residents/connection/programs/garden_workshops | 33797 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.827 | Community Garden PP | |
10283 | 10283 | 10282 | {"type": "Polygon", "coordinates": [[[-117.68662, 34.01663], [-117.68604, 34.01664], [-117.68592, 34.01669], [-117.68591, 34.01726], [-117.68564, 34.01726], [-117.68563, 34.01647], [-117.68662, 34.01646], [-117.68662, 34.01663]]]} | Open Access 1 | Tenth Street Park | 26247 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.878 | Tenth Street Park | ||
13413 | 13413 | 13412 | {"type": "Polygon", "coordinates": [[[-117.63204, 33.95902], [-117.63201, 33.95915], [-117.632, 33.95932], [-117.632, 33.95991], [-117.63149, 33.96007], [-117.6312, 33.95941], [-117.63141, 33.95934], [-117.63127, 33.95898], [-117.6315, 33.95892], [-117.63157, 33.95886], [-117.632, 33.95895], [-117.63204, 33.95902]]]} | Open Access 1 | West Meridian Park | 33436 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1.84 | West Meridian Park | ||
13407 | 13407 | 13406 | {"type": "Polygon", "coordinates": [[[-117.6293, 33.96127], [-117.62796, 33.96128], [-117.62791, 33.96123], [-117.6279, 33.96039], [-117.62795, 33.96033], [-117.62821, 33.96032], [-117.62852, 33.961], [-117.6291, 33.96082], [-117.6293, 33.96127]]]} | Open Access 1 | North Meridian Park | 33434 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1.845 | North Meridian Park | ||
2767 | 2767 | 2766 | {"type": "Polygon", "coordinates": [[[-117.68909, 34.01304], [-117.6881, 34.01305], [-117.68809, 34.01215], [-117.68817, 34.01208], [-117.68899, 34.01207], [-117.68908, 34.01214], [-117.68909, 34.01304]]]} | Open Access 1 | Central Park | http://www.cityofchino.org/government-services/community-services/parks/central-park | 17051 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 2.409 | Central Park | |
4310 | 4310 | 4309 | {"type": "Polygon", "coordinates": [[[-117.61617, 33.96626], [-117.61617, 33.96636], [-117.61614, 33.96646], [-117.61607, 33.96655], [-117.61598, 33.96663], [-117.61588, 33.96667], [-117.61507, 33.96693], [-117.61487, 33.96693], [-117.6147, 33.96688], [-117.61456, 33.96676], [-117.61449, 33.96662], [-117.61449, 33.96652], [-117.61452, 33.96641], [-117.61459, 33.96631], [-117.61468, 33.96624], [-117.61479, 33.96619], [-117.61559, 33.96594], [-117.61577, 33.96593], [-117.61597, 33.966], [-117.6161, 33.96611], [-117.61614, 33.96618], [-117.61617, 33.96626]]]} | Open Access 1 | Forest Park | http://www.cityofchino.org/government-services/community-services/parks/forest-park | 18997 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 2.97 | Forest Park | |
4488 | 4488 | 4487 | {"type": "Polygon", "coordinates": [[[-117.63067, 33.96454], [-117.63064, 33.96458], [-117.63059, 33.9646], [-117.63005, 33.9646], [-117.63, 33.96458], [-117.62998, 33.96454], [-117.62996, 33.96308], [-117.62999, 33.963], [-117.63003, 33.96293], [-117.63011, 33.96287], [-117.6302, 33.96283], [-117.63034, 33.96282], [-117.63048, 33.96286], [-117.63059, 33.96295], [-117.63065, 33.96305], [-117.63067, 33.96454]]]} | Open Access 1 | Garden Park | http://www.cityofchino.org/government-services/community-services/parks/garden-park | 19202 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 2.974 | Garden Park | |
12467 | 12467 | 12466 | {"type": "Polygon", "coordinates": [[[-117.67105, 34.02566], [-117.67043, 34.02566], [-117.67041, 34.02571], [-117.66987, 34.02571], [-117.66987, 34.02507], [-117.66984, 34.02493], [-117.66978, 34.02474], [-117.66977, 34.02461], [-117.67105, 34.0246], [-117.67105, 34.02566]]]} | Open Access 1 | Bob B. McLeod Park | http://www.cityofchino.org/government-services/community-services/parks/bob-b-mcleod-park | 31074 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 3.292 | Bob B. McLeod Park | |
13408 | 13408 | 13407 | {"type": "Polygon", "coordinates": [[[-117.62879, 33.95998], [-117.62819, 33.96016], [-117.62795, 33.96017], [-117.6279, 33.96011], [-117.62788, 33.95828], [-117.62794, 33.95824], [-117.62842, 33.95818], [-117.62849, 33.9586], [-117.6286, 33.95906], [-117.62866, 33.95946], [-117.62874, 33.95983], [-117.62879, 33.95998]]]} | Open Access 1 | South Meridian Park | 33435 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 3.431 | South Meridian Park | ||
3161 | 3161 | 3160 | {"type": "Polygon", "coordinates": [[[-117.65456, 33.99001], [-117.6542, 33.99002], [-117.65358, 33.99008], [-117.65298, 33.99009], [-117.65294, 33.99006], [-117.65293, 33.9892], [-117.65298, 33.98916], [-117.65455, 33.98914], [-117.65456, 33.99001]]]} | Open Access 1 | Constellation Park | http://www.cityofchino.org/government-services/community-services/parks/constellation-park | 17597 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 3.698 | Constellation 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]);