units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
45 rows where MNG_AGENCY = 163 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, YR_EST
LAYER 2 ✖
- City 42
- Special District 3
DES_TP 2
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 45
MNG_AGENCY 1
- San Bernardino, City of · 45 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14875 | 14875 | 14874 | {"type": "Polygon", "coordinates": [[[-117.25902, 34.1645], [-117.25902, 34.16484], [-117.25882, 34.16484], [-117.25882, 34.1645], [-117.25902, 34.1645]]]} | Open Access 1 | 47430 | Sonora Tot Lot | 31147 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 0.17 | Sonora Tot Lot | 0 | Local Recreation Area 3 | 4 | |
9409 | 9409 | 9408 | {"type": "Polygon", "coordinates": [[[-117.29467, 34.11612], [-117.29454, 34.11613], [-117.29453, 34.11634], [-117.2943, 34.11635], [-117.29429, 34.11591], [-117.29467, 34.11591], [-117.29467, 34.11612]]]} | Open Access 1 | 47820 | Jon Cole Skate Park | 31759 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 0.336 | Jon Cole Skate Park | 2017 | Local Recreation Area 3 | 4 | |
1740 | 1740 | 1739 | {"type": "Polygon", "coordinates": [[[-117.28608, 34.16159], [-117.28607, 34.16208], [-117.28517, 34.16208], [-117.28517, 34.16159], [-117.28608, 34.16159]]]} | Open Access 1 | 12949 | Sierra Park | 25463 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 1.126 | Sierra Park | 0 | Local Park 2 | 4 | |
1742 | 1742 | 1741 | {"type": "Polygon", "coordinates": [[[-117.28878, 34.16535], [-117.28738, 34.16536], [-117.28738, 34.16502], [-117.28797, 34.16502], [-117.28822, 34.16498], [-117.28848, 34.16492], [-117.28871, 34.16492], [-117.28878, 34.16535]]]} | Open Access 1 | 12953 | Tom Gould Memorial Park | 26392 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 1.286 | Tom Gould Memorial Park | 0 | Local Park 2 | 4 | |
6569 | 6569 | 6568 | {"type": "Polygon", "coordinates": [[[-117.29528, 34.18298], [-117.29413, 34.18249], [-117.29299, 34.18199], [-117.29314, 34.18175], [-117.29427, 34.18224], [-117.29478, 34.18238], [-117.29482, 34.1824], [-117.29528, 34.18298]]]} | Open Access 1 | 3585 | Newberry Park | 22714 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 1.653 | Newberry Park | 0 | Local Park 2 | 4 | |
416 | 416 | 415 | {"type": "Polygon", "coordinates": [[[-117.31368, 34.12421], [-117.31368, 34.12495], [-117.31262, 34.12495], [-117.31262, 34.1242], [-117.31368, 34.12421]]]} | Open Access 1 | 1286 | Gutierrez Field | 19573 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 1.988 | Gutierrez Field | 0 | Local Recreation Area 3 | 4 | |
652 | 652 | 651 | {"type": "Polygon", "coordinates": [[[-117.31369, 34.11112], [-117.31368, 34.11194], [-117.31272, 34.11194], [-117.31272, 34.11112], [-117.31369, 34.11112]]]} | Open Access 1 | 3196 | La Plaza Park | 20794 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 2.026 | La Plaza Park | 0 | Local Park 2 | 4 | |
12083 | 12083 | 12082 | {"type": "Polygon", "coordinates": [[[-117.24319, 34.14683], [-117.24347, 34.14684], [-117.2435, 34.14686], [-117.24352, 34.14689], [-117.24352, 34.14926], [-117.2435, 34.1493], [-117.24346, 34.14931], [-117.24299, 34.14931], [-117.24319, 34.14884], [-117.24319, 34.14683]]]} | Open Access 1 | 24890 | Sterling Park | 25833 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 2.184 | Sterling Park | 0 | Local Park 2 | 4 | |
1510 | 1510 | 1509 | {"type": "Polygon", "coordinates": [[[-117.31851, 34.11384], [-117.31737, 34.11384], [-117.31737, 34.11306], [-117.31851, 34.11305], [-117.31851, 34.11384]]]} | Open Access 1 | 10705 | Guadalupe Field Park | 19543 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 2.257 | Guadalupe Field Park | 0 | Local Recreation Area 3 | 4 | |
14692 | 14692 | 14691 | {"type": "Polygon", "coordinates": [[[-117.29529, 34.11701], [-117.2948, 34.11701], [-117.29479, 34.11703], [-117.2943, 34.11703], [-117.2943, 34.11635], [-117.29453, 34.11634], [-117.29454, 34.11612], [-117.29467, 34.11611], [-117.29467, 34.11591], [-117.29529, 34.1159], [-117.29529, 34.11701]]]} | Open Access 1 | 45039 | Bryce Edward Hanes Park | 31758 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 2.45 | Bryce Edward Hanes Park | 2017 | Local Park 2 | 4 | |
1341 | 1341 | 1340 | {"type": "Polygon", "coordinates": [[[-117.26959, 34.11193], [-117.26877, 34.11194], [-117.26876, 34.11031], [-117.26959, 34.11031], [-117.26959, 34.11193]]]} | Open Access 1 | 7519 | Palm Field Park | 23337 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 3.376 | Palm Field Park | 0 | Local Recreation Area 3 | 4 | |
14240 | 14240 | 14239 | {"type": "Polygon", "coordinates": [[[-117.2567, 34.15055], [-117.25532, 34.15056], [-117.25532, 34.14958], [-117.25669, 34.14958], [-117.2567, 34.15055]]]} | Restricted Access 2 | 44129 | Del Rosa School Field | 18054 | 2314 | San Bernardino City Unified School District 832 | Special District 4 | School District 14 | http://www.sbcusd.k12.ca.us/ | Special District 4 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 3.38 | Del Rosa School Field | 0 | Local Recreation Area 3 | 4 | |
13136 | 13136 | 13135 | {"type": "Polygon", "coordinates": [[[-117.35628, 34.19074], [-117.35612, 34.191], [-117.35602, 34.19092], [-117.35582, 34.19086], [-117.35439, 34.19024], [-117.35394, 34.1901], [-117.35376, 34.19001], [-117.35364, 34.19], [-117.35353, 34.19004], [-117.35347, 34.19011], [-117.35339, 34.19029], [-117.35334, 34.1903], [-117.35282, 34.18999], [-117.35338, 34.18927], [-117.35393, 34.18951], [-117.35427, 34.18979], [-117.35467, 34.19003], [-117.35628, 34.19074]]]} | Open Access 1 | 48824 | Jack Reilly Park | 33543 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 3.748 | Jack Reilly Park | 0 | Local Park 2 | 4 | |
6909 | 6909 | 6908 | {"type": "Polygon", "coordinates": [[[-117.31247, 34.11568], [-117.31146, 34.11568], [-117.31146, 34.11401], [-117.31247, 34.11401], [-117.31247, 34.11568]]]} | Open Access 1 | 5764 | Bobby Vega Park | 31720 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/parks/ninth_street_park.asp | San Bernardino 22 | 4.285 | Bobby Vega Park | 0 | Local Park 2 | 4 |
13159 | 13159 | 13158 | {"type": "Polygon", "coordinates": [[[-117.33375, 34.18351], [-117.33352, 34.18356], [-117.33339, 34.18353], [-117.33329, 34.18355], [-117.33296, 34.18349], [-117.33296, 34.18311], [-117.33245, 34.18299], [-117.33213, 34.18299], [-117.33181, 34.18303], [-117.33046, 34.18348], [-117.33033, 34.18321], [-117.3306, 34.18312], [-117.33053, 34.18298], [-117.33071, 34.18304], [-117.33081, 34.18301], [-117.33092, 34.18322], [-117.33171, 34.18296], [-117.33176, 34.18287], [-117.33211, 34.18276], [-117.33177, 34.18204], [-117.33181, 34.18196], [-117.3322, 34.18208], [-117.33236, 34.18217], [-117.33295, 34.18265], [-117.33296, 34.18264], [-117.33296, 34.18214], [-117.33308, 34.18224], [-117.33314, 34.18233], [-117.33326, 34.18238], [-117.33348, 34.18256], [-117.33357, 34.18265], [-117.33357, 34.18337], [-117.33375, 34.18351]]]} | Open Access 1 | 48823 | Ronald Reagan Park | 33542 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 4.482 | Ronald Reagan Park | 0 | Local Park 2 | 4 | |
15022 | 15022 | 15021 | {"type": "Polygon", "coordinates": [[[-117.35818, 34.19584], [-117.35717, 34.19744], [-117.3563, 34.19706], [-117.3565, 34.19673], [-117.35649, 34.19669], [-117.35656, 34.19665], [-117.35662, 34.1966], [-117.35669, 34.1964], [-117.35728, 34.19546], [-117.35736, 34.19544], [-117.35816, 34.19578], [-117.35818, 34.19584]]]} | Open Access 1 | 45669 | Tom Minor Park | 28486 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 4.642 | Tom Minor Park | 0 | Local Park 2 | 4 | |
12082 | 12082 | 12081 | {"type": "MultiPolygon", "coordinates": [[[[-117.29181, 34.1401], [-117.29181, 34.14063], [-117.29028, 34.14063], [-117.29028, 34.1401], [-117.29181, 34.1401]]], [[[-117.294, 34.14011], [-117.294, 34.14064], [-117.29202, 34.14063], [-117.29202, 34.1401], [-117.294, 34.14011]]]]} | Open Access 1 | 24888 | Campo Santo Memorial Park | 16784 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 4.721 | Campo Santo Memorial Park | 0 | Local Park 2 | 4 | |
2975 | 2975 | 2974 | {"type": "Polygon", "coordinates": [[[-117.29626, 34.11007], [-117.29428, 34.11007], [-117.29428, 34.10905], [-117.29576, 34.10905], [-117.29576, 34.10929], [-117.29625, 34.10929], [-117.29626, 34.11007]]]} | Open Access 1 | 20541 | Pioneer Park | 23730 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 4.828 | Pioneer Park | 0 | Local Park 2 | 4 | |
6777 | 6777 | 6776 | {"type": "Polygon", "coordinates": [[[-117.28378, 34.10073], [-117.28203, 34.10073], [-117.28202, 34.09962], [-117.28378, 34.09962], [-117.28378, 34.10073]]]} | Open Access 1 | 5256 | Meadowbrook Fields | 33704 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 4.921 | Meadowbrook Fields | 0 | Local Recreation Area 3 | 4 | |
6327 | 6327 | 6326 | {"type": "Polygon", "coordinates": [[[-117.30749, 34.09498], [-117.30538, 34.09499], [-117.30538, 34.09434], [-117.30548, 34.09433], [-117.30548, 34.09403], [-117.30749, 34.09403], [-117.30749, 34.09498]]]} | Restricted Access 2 | 47431 | Richardson School Field | 31149 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 5.028 | Richardson School Field | 0 | Local Recreation Area 3 | 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]);