units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 261 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME
MNG_AG_TYP 1
- City Agency 32
MNG_AGENCY 1
- Chino, City of · 32 ✖
DES_TP 1
- Local Park 32
ACCESS_TYP 1
- Open Access 32
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2120 | 2120 | 2119 | {"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 | 15923 | 7th Street Park | 15215 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/7th-street-park | San Bernardino 22 | 0.175 | 7th Street Park | 0 | Local Park 2 | 4 |
12948 | 12948 | 12947 | {"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 | 30403 | Aguiar Square | 15296 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/aguiar-square | San Bernardino 22 | 0.781 | Aguiar Square | 0 | Local Park 2 | 4 |
12941 | 12941 | 12940 | {"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 | 30397 | Carolyn Owens Centennial Square | 16889 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/carolyn-owens-centennial-square | San Bernardino 22 | 0.156 | Carolyn Owens Centennial Square | 0 | Local Park 2 | 4 |
3327 | 3327 | 3326 | {"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 | 20584 | Central Park | 17051 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/central-park | San Bernardino 22 | 2.41 | Central Park | 0 | Local Park 2 | 4 |
12942 | 12942 | 12941 | {"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 | 30398 | Constellation Park | 17597 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/constellation-park | San Bernardino 22 | 3.698 | Constellation Park | 0 | Local Park 2 | 4 |
6662 | 6662 | 6661 | {"type": "Polygon", "coordinates": [[[-117.66271, 34.00464], [-117.66082, 34.00465], [-117.6608, 34.00292], [-117.66269, 34.00291], [-117.66271, 34.00464]]]} | Open Access 1 | 4819 | Cypress Trails Park | 17885 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/cypress-trails-park | San Bernardino 22 | 8.266 | Cypress Trails Park | 0 | Local Park 2 | 4 |
12943 | 12943 | 12942 | {"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.9662], [-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 | 30399 | Forest Park | 18997 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/forest-park | San Bernardino 22 | 2.971 | Forest Park | 0 | Local Park 2 | 4 |
12944 | 12944 | 12943 | {"type": "Polygon", "coordinates": [[[-117.62694, 33.96631], [-117.62663, 33.96657], [-117.62629, 33.96678], [-117.62593, 33.96694], [-117.62549, 33.96707], [-117.62519, 33.96713], [-117.62483, 33.96716], [-117.62364, 33.96717], [-117.62358, 33.96712], [-117.62357, 33.96627], [-117.62355, 33.96606], [-117.62357, 33.96602], [-117.62366, 33.96593], [-117.6242, 33.96592], [-117.62421, 33.96612], [-117.62479, 33.96611], [-117.6248, 33.96633], [-117.62531, 33.96633], [-117.62531, 33.96608], [-117.62544, 33.96608], [-117.62555, 33.96605], [-117.62581, 33.96589], [-117.62593, 33.96586], [-117.62606, 33.96584], [-117.6261, 33.96579], [-117.62619, 33.96577], [-117.62694, 33.96631]]]} | Open Access 1 | 30400 | Founders Park | 19020 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/founders-park | San Bernardino 22 | 7.985 | Founders Park | 0 | Local Park 2 | 4 |
12945 | 12945 | 12944 | {"type": "Polygon", "coordinates": [[[-117.63067, 33.96454], [-117.63064, 33.96458], [-117.63059, 33.9646], [-117.63004, 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 | 30401 | Garden Park | 19202 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/garden-park | San Bernardino 22 | 2.975 | Garden Park | 0 | Local Park 2 | 4 |
1075 | 1075 | 1074 | {"type": "Polygon", "coordinates": [[[-117.71322, 34.01347], [-117.71112, 34.01349], [-117.7111, 34.01176], [-117.7132, 34.01175], [-117.71322, 34.01347]]]} | Open Access 1 | 5661 | Heritage Park | 19844 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/heritage-park | San Bernardino 22 | 9.153 | Heritage Park | 0 | Local Park 2 | 4 |
1265 | 1265 | 1264 | {"type": "Polygon", "coordinates": [[[-117.69604, 34.03892], [-117.69495, 34.03892], [-117.69494, 34.03807], [-117.69396, 34.03808], [-117.69395, 34.03717], [-117.69597, 34.03716], [-117.69598, 34.03795], [-117.69595, 34.03817], [-117.69597, 34.03824], [-117.69603, 34.0383], [-117.69604, 34.03892]]]} | Open Access 1 | 5685 | Liberty Park | 21209 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/liberty-park | San Bernardino 22 | 6.96 | Liberty Park | 0 | Local Park 2 | 4 |
936 | 936 | 935 | {"type": "Polygon", "coordinates": [[[-117.69943, 34.01339], [-117.6991, 34.0134], [-117.69911, 34.01446], [-117.69817, 34.01447], [-117.69815, 34.01277], [-117.69908, 34.01276], [-117.69909, 34.01255], [-117.69942, 34.01273], [-117.69943, 34.01339]]]} | Open Access 1 | 5441 | Monte Vista Park | 22401 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/monte-vista-park | San Bernardino 22 | 4.707 | Monte Vista Park | 0 | Local Park 2 | 4 |
5382 | 5382 | 5381 | {"type": "Polygon", "coordinates": [[[-117.66738, 34.01186], [-117.66528, 34.01187], [-117.66526, 34.01015], [-117.66736, 34.01013], [-117.66738, 34.01186]]]} | Open Access 1 | 5725 | Mountain View Park | 22552 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/mountain-view-park | San Bernardino 22 | 9.15 | Mtn. View Park | 0 | Local Park 2 | 4 |
6670 | 6670 | 6669 | {"type": "Polygon", "coordinates": [[[-117.68893, 33.99708], [-117.68884, 33.99715], [-117.68467, 33.99717], [-117.68466, 33.99722], [-117.67601, 33.99728], [-117.67599, 33.99438], [-117.67862, 33.99436], [-117.67896, 33.99431], [-117.67925, 33.99423], [-117.67953, 33.9941], [-117.67978, 33.99392], [-117.68042, 33.99328], [-117.68082, 33.99296], [-117.68128, 33.9927], [-117.68181, 33.9925], [-117.68181, 33.99221], [-117.68889, 33.99217], [-117.68893, 33.99708]]]} | Open Access 1 | 4817 | Ruben S. Ayala Park | 24722 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/ruben-s-ayala-park | San Bernardino 22 | 139.418 | Ruben S. Ayala Park | 0 | Local Park 2 | 4 |
1580 | 1580 | 1579 | {"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 | 12125 | Sebring Park | 25275 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/sebring-park | San Bernardino 22 | 0.666 | Sebring Park | 0 | Local Park 2 | 4 |
8923 | 8923 | 8922 | {"type": "Polygon", "coordinates": [[[-117.68662, 34.01663], [-117.68603, 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 | 14705 | Tenth Street Park | 26247 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | San Bernardino 22 | 0.876 | Tenth Street Park | 0 | Local Park 2 | 4 | |
9103 | 9103 | 9102 | {"type": "Polygon", "coordinates": [[[-117.69602, 34.00833], [-117.69599, 34.00835], [-117.69442, 34.00836], [-117.6944, 34.00835], [-117.69437, 34.00636], [-117.69599, 34.00638], [-117.69602, 34.00833]]]} | Open Access 1 | 15063 | Villa Park | 27104 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/villa-park | San Bernardino 22 | 8.158 | Villa Park | 0 | Local Park 2 | 4 |
1982 | 1982 | 1981 | {"type": "Polygon", "coordinates": [[[-117.70536, 34.0279], [-117.70479, 34.02786], [-117.70459, 34.02783], [-117.70429, 34.02766], [-117.70359, 34.02766], [-117.70374, 34.02732], [-117.70374, 34.02716], [-117.70413, 34.02715], [-117.70413, 34.02635], [-117.70467, 34.02635], [-117.70468, 34.02632], [-117.70494, 34.02632], [-117.70495, 34.02634], [-117.70534, 34.02634], [-117.70536, 34.0279]]]} | Open Access 1 | 15156 | Walnut Park | 27239 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/walnut-park | San Bernardino 22 | 5.098 | Walnut Park | 0 | Local Park 2 | 4 |
6038 | 6038 | 6037 | {"type": "Polygon", "coordinates": [[[-117.62599, 33.96845], [-117.62557, 33.96845], [-117.62557, 33.96815], [-117.62593, 33.96813], [-117.62593, 33.96816], [-117.62598, 33.96816], [-117.62599, 33.96845]]]} | Open Access 1 | 47350 | Evergreen Park | 31066 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/evergreen-park | San Bernardino 22 | 0.321 | Evergreen Park | 0 | Local Park 2 | 4 |
6039 | 6039 | 6038 | {"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 | 47351 | Hidden Hollow Park | 31067 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/hidden-hollow-park | San Bernardino 22 | 0.407 | Hidden Hollow 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]);