superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
45 rows where MNG_AGENCY = 163 and MNG_AG_TYP = 2 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13654 | 13654 | 13653 | {"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 | Sonora Tot Lot | 31147 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 0.169 | Sonora Tot Lot | ||
13113 | 13113 | 13112 | {"type": "Polygon", "coordinates": [[[-117.29467, 34.11611], [-117.29454, 34.11613], [-117.29453, 34.11634], [-117.2943, 34.11635], [-117.29429, 34.11591], [-117.29467, 34.11591], [-117.29467, 34.11611]]]} | Open Access 1 | Jon Cole Skate Park | 31759 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 0.337 | Jon Cole Skate Park | 2017 | |
9646 | 9646 | 9645 | {"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 | Sierra Park | 25463 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1.126 | Sierra Park | ||
10384 | 10384 | 10383 | {"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 | Tom Gould Memorial Park | 26392 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1.286 | Tom Gould Memorial Park | ||
7348 | 7348 | 7347 | {"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 | Newberry Park | 22714 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1.653 | Newberry Park | ||
4806 | 4806 | 4805 | {"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 | Gutierrez Field | 19573 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1.988 | Gutierrez Field | ||
5833 | 5833 | 5832 | {"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 | La Plaza Park | 20794 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 2.025 | La Plaza Park | ||
9958 | 9958 | 9957 | {"type": "Polygon", "coordinates": [[[-117.24352, 34.14926], [-117.2435, 34.1493], [-117.24346, 34.14931], [-117.24299, 34.14931], [-117.24319, 34.14884], [-117.24319, 34.14683], [-117.24347, 34.14684], [-117.2435, 34.14686], [-117.24352, 34.14689], [-117.24352, 34.14926]]]} | Open Access 1 | Sterling Park | 25833 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 2.184 | Sterling Park | ||
4786 | 4786 | 4785 | {"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 | Guadalupe Field Park | 19543 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 2.256 | Guadalupe Field Park | ||
35 | 35 | 34 | {"type": "Polygon", "coordinates": [[[-117.29529, 34.117], [-117.29481, 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.1161], [-117.29467, 34.11591], [-117.29529, 34.1159], [-117.29529, 34.117]]]} | Open Access 1 | Bryce Edward Hanes Park | 31758 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 2.453 | Bryce Edward Hanes Park | 2017 | |
7870 | 7870 | 7869 | {"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 | Palm Field Park | 23337 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 3.376 | Palm Field Park | ||
2816 | 2816 | 2815 | {"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 | Del Rosa School Field | 18054 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 3.379 | Del Rosa School Field | ||
14066 | 14066 | 14065 | {"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 | Jack Reilly Park | 33543 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 3.748 | Jack Reilly Park | ||
14231 | 14231 | 14230 | {"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 | Bobby Vega Park | http://www.ci.san-bernardino.ca.us/cityhall/parks/parks/ninth_street_park.asp | 31720 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 4.284 | Bobby Vega Park | |
678 | 678 | 677 | {"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.33059, 34.18312], [-117.33053, 34.18298], [-117.33071, 34.18304], [-117.33081, 34.18301], [-117.33093, 34.18322], [-117.33171, 34.18296], [-117.33176, 34.18287], [-117.3321, 34.18276], [-117.33177, 34.18204], [-117.33181, 34.18196], [-117.3322, 34.18208], [-117.33236, 34.18217], [-117.33295, 34.18264], [-117.33296, 34.18263], [-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.18336], [-117.33375, 34.18351]]]} | Open Access 1 | Ronald Reagan Park | 33542 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 4.499 | Ronald Reagan Park | ||
10205 | 10205 | 10204 | {"type": "Polygon", "coordinates": [[[-117.35818, 34.19584], [-117.35717, 34.19744], [-117.3563, 34.19706], [-117.3565, 34.19674], [-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 | Tom Minor Park | 28486 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 4.642 | Tom Minor Park | ||
2563 | 2563 | 2562 | {"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 | Campo Santo Memorial Park | 16784 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 4.72 | Campo Santo Memorial Park | ||
8192 | 8192 | 8191 | {"type": "Polygon", "coordinates": [[[-117.29626, 34.11007], [-117.29428, 34.11007], [-117.29428, 34.10905], [-117.29576, 34.10905], [-117.29577, 34.10929], [-117.29625, 34.10929], [-117.29626, 34.11007]]]} | Open Access 1 | Pioneer Park | 23730 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 4.829 | Pioneer Park | ||
9436 | 9436 | 9435 | {"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 | Meadowbrook Fields | 33704 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 4.92 | Meadowbrook Fields | ||
13228 | 13228 | 13227 | {"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 | Richardson School Field | 31149 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 5.027 | Richardson School Field |
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]);