units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 261 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 12
MNG_AGENCY 1
- Chino, City of · 12 ✖
DES_TP 1
- Local Park 12
ACCESS_TYP 1
- Open Access 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4907 | 4907 | 4906 | {"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 | 48704 | South Meridian Park | 33435 | 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 | 3.431 | South Meridian 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 |
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 |
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 |
12946 | 12946 | 12945 | {"type": "Polygon", "coordinates": [[[-117.65868, 34.01386], [-117.65659, 34.01387], [-117.65657, 34.01214], [-117.65761, 34.01213], [-117.65763, 34.01345], [-117.65868, 34.01345], [-117.65868, 34.01386]]]} | Open Access 1 | 30402 | Shady Grove Park | 31072 | 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/shady-grove-park | San Bernardino 22 | 5.682 | Shady Grove 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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]);