units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 421
- Los Angeles, City of 381
- Sacramento, City of 200
- San Jose, City of 192
- San Francisco, City and County of 163
- Ventura, City of 132
- Long Beach, City of 122
- Roseville, City of 121
- Oakland, City of 102
- Napa, City of 80
- Irvine, City of 70
- Tracy, City of 65
- Poway, City of 61
- Davis, City of 61
- Torrance, City of 61
- Stockton, City of 60
- Santa Cruz, City of 57
- Fresno, City of 57
- Chula Vista, City of 57
- Santa Rosa, City of 56
- San Ramon, City of 56
- Modesto, City of 56
- Rocklin, City of 54
- Brentwood, City of 53
- Huntington Beach, City of 52
- Manteca, City of 52
- San Luis Obispo, City of 51
- Fullerton, City of 48
- Riverside, City of 47
- Santa Clarita, City of 47
- …
DES_TP >30
- Local Park 5,607
- Local Recreation Area 1,248
- Local Other or Unknown 641
- Local Conservation Area 113
- Local Historic or Cultural Area 29
- National Monument or Landmark 5
- Local Resource Management Area 4
- National Forest 1
- National Recreation Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 7,724
- Restricted Access 332
- No Public Access 182
- Unknown Access 22
MNG_AG_TYP 1
- City Agency · 8,260 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3069 | 3069 | 3068 | {"type": "Polygon", "coordinates": [[[-121.45028, 38.52731], [-121.45035, 38.52733], [-121.4514, 38.52853], [-121.45141, 38.52857], [-121.45138, 38.52861], [-121.45006, 38.52916], [-121.45001, 38.52914], [-121.44926, 38.5281], [-121.44925, 38.52806], [-121.44927, 38.52803], [-121.44994, 38.52763], [-121.4501, 38.52749], [-121.45024, 38.52733], [-121.45028, 38.52731]]]} | Open Access 1 | 21198 | Lawrence Park | 21117 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.073 | Lawrence Park | 0 | Local Park 2 | 4 | |
3070 | 3070 | 3069 | {"type": "Polygon", "coordinates": [[[-121.32219, 36.4291], [-121.32111, 36.42909], [-121.32113, 36.42814], [-121.32124, 36.42778], [-121.3213, 36.42776], [-121.32287, 36.42802], [-121.32291, 36.42805], [-121.32292, 36.42808], [-121.32291, 36.42811], [-121.32268, 36.42839], [-121.32219, 36.4291]]]} | Open Access 1 | 24866 | Gallardo Park | 19175 | 1336 | Soledad, City of 485 | City 2 | City Agency 2 | http://www.cityofsoledad.com/ | City 2 | 1336 | Soledad, City of 476 | City 2 | City Agency 2 | Monterey 14 | 4.387 | Gallardo Park | 0 | Local Park 2 | 4 | |
3071 | 3071 | 3070 | {"type": "Polygon", "coordinates": [[[-117.3897, 34.4796], [-117.3897, 34.4796], [-117.38699, 34.48074], [-117.38699, 34.47932], [-117.38949, 34.47903], [-117.38958, 34.47932], [-117.3897, 34.4796]]]} | Open Access 1 | 24893 | Eagle Ranch Park | 18344 | 1367 | Victorville, City of 40 | City 2 | City Agency 2 | http://ci.victorville.ca.us/Site/CityDepartments2.aspx?id=522 | City 2 | 1367 | Victorville, City of 39 | City 2 | City Agency 2 | San Bernardino 22 | 6.695 | Eagle Ranch Park | 0 | Local Park 2 | 4 | |
3072 | 3072 | 3071 | {"type": "Polygon", "coordinates": [[[-121.48428, 38.48829], [-121.48427, 38.48823], [-121.48421, 38.48816], [-121.48413, 38.48811], [-121.48405, 38.4881], [-121.48271, 38.48809], [-121.48271, 38.48641], [-121.48428, 38.4864], [-121.48428, 38.48829]]]} | Open Access 1 | 21230 | Mark Hopkins Park | 21870 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 6.367 | Mark Hopkins Park | 0 | Local Park 2 | 4 | |
3073 | 3073 | 3072 | {"type": "Polygon", "coordinates": [[[-121.54386, 38.47907], [-121.5413, 38.48076], [-121.53988, 38.47961], [-121.53967, 38.47947], [-121.54192, 38.47755], [-121.54295, 38.47837], [-121.54336, 38.47881], [-121.54386, 38.47907]]]} | Open Access 1 | 21240 | Garcia Bend Park | 19191 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 15.601 | Garcia Bend Park | 0 | Local Park 2 | 4 | |
3074 | 3074 | 3073 | {"type": "Polygon", "coordinates": [[[-122.21426, 37.79561], [-122.21378, 37.79679], [-122.21206, 37.79603], [-122.21209, 37.79595], [-122.21209, 37.79585], [-122.21199, 37.79538], [-122.21201, 37.79535], [-122.21252, 37.79484], [-122.21426, 37.79561]]]} | Open Access 1 | 24940 | Curt Flood Field | 17862 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 6.219 | Curt Flood Field | 0 | Local Recreation Area 3 | 4 | |
3076 | 3076 | 3075 | {"type": "Polygon", "coordinates": [[[-121.43065, 38.44173], [-121.43038, 38.44183], [-121.43018, 38.44193], [-121.42994, 38.44208], [-121.42974, 38.44226], [-121.42779, 38.44444], [-121.42753, 38.44467], [-121.42719, 38.44487], [-121.4268, 38.44501], [-121.42653, 38.44506], [-121.42632, 38.44509], [-121.42605, 38.44509], [-121.42598, 38.44506], [-121.42597, 38.44502], [-121.42595, 38.44305], [-121.42592, 38.44275], [-121.42584, 38.44245], [-121.42573, 38.4422], [-121.42562, 38.44203], [-121.42536, 38.44167], [-121.42713, 38.44181], [-121.42868, 38.44197], [-121.42893, 38.44195], [-121.43014, 38.44175], [-121.43048, 38.44172], [-121.43065, 38.44173]]]} | Open Access 1 | 21255 | North Laguna Creek Park | 22827 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 21.437 | North Laguna Creek Park | 0 | Local Park 2 | 4 | |
3077 | 3077 | 3076 | {"type": "Polygon", "coordinates": [[[-121.40888, 38.44576], [-121.4061, 38.44611], [-121.406, 38.44602], [-121.40602, 38.44602], [-121.40603, 38.44601], [-121.4057, 38.44561], [-121.40562, 38.44542], [-121.40567, 38.44537], [-121.40622, 38.44522], [-121.40717, 38.44514], [-121.40731, 38.44516], [-121.40741, 38.44512], [-121.40745, 38.44507], [-121.40746, 38.44502], [-121.40741, 38.4449], [-121.40736, 38.44452], [-121.40738, 38.44446], [-121.4073, 38.44379], [-121.40735, 38.44376], [-121.40786, 38.44372], [-121.408, 38.44374], [-121.40811, 38.4437], [-121.40815, 38.44365], [-121.40816, 38.44359], [-121.4081, 38.44347], [-121.40799, 38.44284], [-121.40804, 38.4428], [-121.40865, 38.44276], [-121.4087, 38.44278], [-121.40872, 38.44281], [-121.40873, 38.4453], [-121.40888, 38.4453], [-121.40888, 38.44576]]]} | Open Access 1 | 21256 | Jacinto Creek Park | 20298 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 11.72 | Jacinto Creek Park | 0 | Local Park 2 | 4 | |
3078 | 3078 | 3077 | {"type": "Polygon", "coordinates": [[[-121.5365, 38.65112], [-121.53707, 38.65112], [-121.53713, 38.65115], [-121.53714, 38.65221], [-121.53713, 38.65224], [-121.53708, 38.65226], [-121.53664, 38.65228], [-121.53536, 38.65229], [-121.53531, 38.65226], [-121.53527, 38.65204], [-121.53507, 38.65134], [-121.53509, 38.65128], [-121.53513, 38.65127], [-121.53597, 38.65116], [-121.5365, 38.65112]]]} | Open Access 1 | 21258 | Quail Park | 24046 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.192 | Quail Park | 0 | Local Park 2 | 4 | |
3079 | 3079 | 3078 | {"type": "Polygon", "coordinates": [[[-121.96099, 36.97023], [-121.95985, 36.97023], [-121.95984, 36.97013], [-121.95832, 36.97013], [-121.95832, 36.96878], [-121.96098, 36.96853], [-121.96099, 36.97023]]]} | Open Access 1 | 25001 | Jade Street Park | 20334 | 1044 | Capitola, City of 112 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | Santa Cruz 5 | 9.882 | Jade Street Park | 0 | Local Park 2 | 4 | |
3081 | 3081 | 3080 | {"type": "Polygon", "coordinates": [[[-121.50685, 38.65057], [-121.50685, 38.65314], [-121.50629, 38.65314], [-121.50594, 38.6531], [-121.50561, 38.65302], [-121.50509, 38.65281], [-121.5051, 38.65069], [-121.50522, 38.65066], [-121.50527, 38.65062], [-121.50529, 38.65057], [-121.50685, 38.65057]]]} | Open Access 1 | 21263 | River Birch Park Site | 24406 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 10.39 | River Birch Park Site | 0 | Local Park 2 | 4 | |
3082 | 3082 | 3081 | {"type": "Polygon", "coordinates": [[[-121.50672, 38.66802], [-121.50672, 38.66802], [-121.50395, 38.66804], [-121.50412, 38.66774], [-121.50423, 38.66746], [-121.5043, 38.66714], [-121.50431, 38.66685], [-121.50529, 38.66685], [-121.50671, 38.66684], [-121.50672, 38.66802]]]} | Open Access 1 | 21265 | North Natomas Park Nature Area | 22833 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 7.099 | North Natomas Park Nature Area | 0 | Local Conservation Area 4 | 2 | |
3083 | 3083 | 3082 | {"type": "Polygon", "coordinates": [[[-121.53606, 38.63461], [-121.53596, 38.63488], [-121.53508, 38.63486], [-121.53466, 38.63481], [-121.53425, 38.63471], [-121.53391, 38.6346], [-121.53349, 38.63441], [-121.5332, 38.63424], [-121.53245, 38.63373], [-121.5321, 38.63354], [-121.53166, 38.63337], [-121.5312, 38.63325], [-121.53123, 38.63315], [-121.53128, 38.63315], [-121.5329, 38.63256], [-121.53289, 38.62786], [-121.53361, 38.62786], [-121.53367, 38.6278], [-121.53477, 38.62836], [-121.53478, 38.6346], [-121.53606, 38.63461]]]} | Open Access 1 | 21266 | San Juan Reservoir Park | 24921 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 32.901 | San Juan Reservoir Park | 0 | Local Park 2 | 4 | |
3084 | 3084 | 3083 | {"type": "Polygon", "coordinates": [[[-122.14851, 38.21905], [-122.14849, 38.21918], [-122.14819, 38.2197], [-122.14804, 38.21983], [-122.14746, 38.22024], [-122.14718, 38.22007], [-122.14659, 38.21961], [-122.1463, 38.21944], [-122.14613, 38.21936], [-122.14611, 38.21932], [-122.14612, 38.21923], [-122.14714, 38.21825], [-122.14742, 38.21851], [-122.1478, 38.21875], [-122.14819, 38.21892], [-122.14844, 38.21898], [-122.14851, 38.21905]]]} | Open Access 1 | 1908 | Vintage Green Valley Park | 27145 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 6.117 | Vintage Green Valley Park | 0 | Local Park 2 | 4 | |
3085 | 3085 | 3084 | {"type": "Polygon", "coordinates": [[[-117.04247, 32.70504], [-117.04095, 32.70501], [-117.04098, 32.70445], [-117.04092, 32.70443], [-117.04094, 32.70406], [-117.0414, 32.70399], [-117.04161, 32.70395], [-117.04186, 32.70388], [-117.04212, 32.70378], [-117.0422, 32.70409], [-117.04214, 32.70432], [-117.04216, 32.70455], [-117.04222, 32.70474], [-117.04237, 32.70488], [-117.04247, 32.70504]]]} | Open Access 1 | 1911 | Officer Christopher Wilson Neighborhood Park | 30065 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.529 | Officer Christopher Wilson Neighborhood Park | 0 | Local Park 2 | 4 | |
3086 | 3086 | 3085 | {"type": "Polygon", "coordinates": [[[-117.3313, 33.67558], [-117.33087, 33.67667], [-117.32993, 33.6764], [-117.33024, 33.67564], [-117.33069, 33.67576], [-117.33083, 33.67545], [-117.3313, 33.67558]]]} | Open Access 1 | 22128 | Yarborough Park | 27763 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | Riverside 10 | 2.462 | Yarborough Park | 0 | Local Park 2 | 4 | |
3087 | 3087 | 3086 | {"type": "Polygon", "coordinates": [[[-121.51926, 38.55343], [-121.51925, 38.55354], [-121.51922, 38.55357], [-121.51916, 38.5536], [-121.51764, 38.55377], [-121.51755, 38.55331], [-121.51742, 38.55303], [-121.51718, 38.55299], [-121.51696, 38.55306], [-121.51678, 38.55297], [-121.51656, 38.55293], [-121.51656, 38.55287], [-121.51658, 38.55283], [-121.51662, 38.55281], [-121.51676, 38.55279], [-121.51762, 38.55272], [-121.51785, 38.55274], [-121.51811, 38.55283], [-121.51831, 38.55297], [-121.51844, 38.55298], [-121.51846, 38.55303], [-121.51907, 38.55338], [-121.51914, 38.55336], [-121.51918, 38.5534], [-121.51926, 38.55343]]]} | Open Access 1 | 21351 | Delta Gardens Park | 18070 | 1376 | West Sacramento, City of 548 | City 2 | City Agency 2 | http://www.cityofwestsacramento.org/city/depts/pcs/default.asp | City 2 | 1376 | West Sacramento, City of 541 | City 2 | City Agency 2 | Yolo 33 | 3.26 | Delta Gardens Park | 0 | Local Park 2 | 4 | |
3088 | 3088 | 3087 | {"type": "Polygon", "coordinates": [[[-121.57434, 38.53766], [-121.57434, 38.53813], [-121.57433, 38.53836], [-121.57427, 38.53868], [-121.57424, 38.53872], [-121.57419, 38.53874], [-121.57392, 38.53869], [-121.57353, 38.53859], [-121.57221, 38.53812], [-121.57216, 38.53806], [-121.57217, 38.53802], [-121.57229, 38.53773], [-121.57235, 38.53749], [-121.57326, 38.53766], [-121.57434, 38.53766]]]} | Open Access 1 | 21352 | Sunset Vista Park | 26070 | 1376 | West Sacramento, City of 548 | City 2 | City Agency 2 | http://www.cityofwestsacramento.org/city/depts/pcs/default.asp | City 2 | 1376 | West Sacramento, City of 541 | City 2 | City Agency 2 | Yolo 33 | 4.314 | Sunset Vista Park | 0 | Local Park 2 | 4 | |
3089 | 3089 | 3088 | {"type": "MultiPolygon", "coordinates": [[[[-121.52195, 38.59572], [-121.52096, 38.59539], [-121.52097, 38.59391], [-121.5217, 38.59399], [-121.52142, 38.59544], [-121.52195, 38.59572]]], [[[-121.52271, 38.59411], [-121.52266, 38.5944], [-121.52237, 38.59585], [-121.52228, 38.59582], [-121.52266, 38.59411], [-121.52271, 38.59411]]]]} | Open Access 1 | 21353 | Elkhorn Park | 18568 | 1376 | West Sacramento, City of 548 | City 2 | City Agency 2 | http://www.cityofwestsacramento.org/city/depts/pcs/default.asp | City 2 | 1376 | West Sacramento, City of 541 | City 2 | City Agency 2 | Yolo 33 | 2.513 | Elkhorn Park | 0 | Local Park 2 | 4 | |
3090 | 3090 | 3089 | {"type": "MultiPolygon", "coordinates": [[[[-121.77039, 38.68764], [-121.77038, 38.68822], [-121.77033, 38.68825], [-121.76935, 38.68824], [-121.76936, 38.68781], [-121.7694, 38.68763], [-121.77039, 38.68764]]], [[[-121.77039, 38.68738], [-121.77039, 38.68759], [-121.76942, 38.68758], [-121.76951, 38.6874], [-121.76953, 38.68729], [-121.76958, 38.68725], [-121.76963, 38.68725], [-121.77008, 38.68735], [-121.77039, 38.68738]]]]} | Open Access 1 | 21362 | Beamer Park | 15917 | 1665 | Woodland, City of 547 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | Yolo 33 | 2.064 | Beamer 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]);