units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 261
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
10515 | 10515 | 10514 | {"type": "Polygon", "coordinates": [[[-117.63201, 33.95915], [-117.632, 33.95932], [-117.632, 33.95991], [-117.63149, 33.96007], [-117.6312, 33.95941], [-117.63201, 33.95915]]]} | Open Access 1 | 48706 | West Meridian Park | 33436 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | San Bernardino 22 | 1.242 | West Meridian Park | 0 | Local Park 2 | 4 | |
10628 | 10628 | 10627 | {"type": "Polygon", "coordinates": [[[-117.62852, 33.961], [-117.62791, 33.96119], [-117.6279, 33.96039], [-117.62795, 33.96033], [-117.62821, 33.96032], [-117.62852, 33.961]]]} | Open Access 1 | 48707 | North Meridian Park | 33434 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | San Bernardino 22 | 0.926 | North Meridian Park | 0 | Local Park 2 | 4 | |
11463 | 11463 | 11462 | {"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 | 48698 | Community Garden Pocket Park | 33797 | 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 | https://www.cityofchino.org/residents/connection/programs/garden_workshops | San Bernardino 22 | 0.828 | Community Garden PP | 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 |
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 |
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 |
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 |
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 |
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]);