units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
651 rows where DES_TP = 2 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 93
- San Diego, County of 67
- Orange, County of 43
- El Dorado, County of 42
- Kern, County of 37
- Santa Barbara, County of 36
- Santa Cruz, County of 29
- Stanislaus, County of 22
- Riverside, County of 19
- Placer, County of 19
- Lake, County of 18
- San Joaquin, County of 18
- San Luis Obispo, County of 16
- Monterey, County of 16
- Ventura, County of 15
- San Bernardino, County of 14
- Merced, County of 12
- Yolo, County of 12
- Fresno, County of 11
- Humboldt, County of 10
- Tulare, County of 7
- Sacramento, County of 7
- Tehama, County of 6
- Mendocino, County of 6
- Lassen, County of 6
- Mariposa, County of 5
- Mono, County of 5
- Imperial, County of 4
- Yuba, County of 4
- San Benito, County of 3
- …
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 631 ✖
DES_TP 1
- Local Park · 631 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
339 | 339 | 338 | {"type": "Polygon", "coordinates": [[[-121.95538, 36.98556], [-121.95509, 36.9857], [-121.95498, 36.98583], [-121.95502, 36.98592], [-121.95472, 36.98598], [-121.95477, 36.98571], [-121.9549, 36.98545], [-121.95538, 36.98556]]]} | Open Access 1 | 932 | Soquel Lions Park | 25623 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.38 | Soquel Lions Park | 0 | Local Park 2 | 4 | |
349 | 349 | 348 | {"type": "Polygon", "coordinates": [[[-117.81409, 33.75983], [-117.81374, 33.7598], [-117.81369, 33.75976], [-117.81367, 33.75975], [-117.81366, 33.75914], [-117.81378, 33.75944], [-117.81391, 33.75962], [-117.81409, 33.75983]]]} | Open Access 1 | 959 | Holderman Park | 20027 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.281 | Holderman Park | 0 | Local Park 2 | 4 | |
387 | 387 | 386 | {"type": "Polygon", "coordinates": [[[-119.84568, 34.44599], [-119.84615, 34.44647], [-119.84624, 34.44662], [-119.84629, 34.44677], [-119.8465, 34.44822], [-119.84663, 34.44933], [-119.84663, 34.44955], [-119.84655, 34.4499], [-119.84653, 34.45018], [-119.84655, 34.45047], [-119.84663, 34.45075], [-119.84662, 34.45079], [-119.8466, 34.45083], [-119.84655, 34.45087], [-119.84628, 34.45093], [-119.84609, 34.45095], [-119.8459, 34.45096], [-119.84512, 34.45092], [-119.84515, 34.45003], [-119.8452, 34.44961], [-119.84524, 34.44939], [-119.8453, 34.44915], [-119.84542, 34.44878], [-119.84574, 34.44803], [-119.84584, 34.44762], [-119.84586, 34.44739], [-119.84586, 34.44718], [-119.84584, 34.44697], [-119.8458, 34.44677], [-119.84565, 34.44636], [-119.84555, 34.44616], [-119.84545, 34.446], [-119.84553, 34.44596], [-119.8456, 34.44597], [-119.84565, 34.44601], [-119.84568, 34.44599]]]} | Open Access 1 | 1154 | Stow Grove Park | 25905 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 11.813 | Stow Grove Park | 0 | Local Park 2 | 4 | |
423 | 423 | 422 | {"type": "Polygon", "coordinates": [[[-120.7087, 35.54967], [-120.70788, 35.55014], [-120.70681, 35.54963], [-120.7074, 35.54889], [-120.7087, 35.54967]]]} | Open Access 1 | 1306 | Templeton Community Park | 26237 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 2.932 | Templeton Community Park | 0 | Local Park 2 | 4 | |
425 | 425 | 424 | {"type": "MultiPolygon", "coordinates": [[[[-121.86668, 36.99615], [-121.86622, 36.99659], [-121.86588, 36.99638], [-121.86594, 36.99611], [-121.86598, 36.99604], [-121.86629, 36.99605], [-121.86668, 36.99615]]], [[[-121.86716, 36.99638], [-121.86716, 36.99639], [-121.86607, 36.99714], [-121.8662, 36.99674], [-121.86631, 36.99659], [-121.86672, 36.99621], [-121.86716, 36.99638]]]]} | Open Access 1 | 1674 | Valencia Hall Park | 26761 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.476 | Valencia Hall Park | 0 | Local Park 2 | 4 | |
431 | 431 | 430 | {"type": "Polygon", "coordinates": [[[-117.28428, 33.76243], [-117.28273, 33.76246], [-117.2827, 33.76182], [-117.28324, 33.76181], [-117.28324, 33.76162], [-117.28425, 33.76159], [-117.28428, 33.76243]]]} | Open Access 1 | 48878 | Goodhope Park | 33599 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 3.022 | Goodhope Park | 0 | Local Park 2 | 4 | |
433 | 433 | 432 | {"type": "Polygon", "coordinates": [[[-116.59781, 32.61496], [-116.59778, 32.61691], [-116.592, 32.61684], [-116.59195, 32.61847], [-116.58772, 32.61842], [-116.58772, 32.61307], [-116.59204, 32.61313], [-116.59203, 32.6113], [-116.59613, 32.61131], [-116.59619, 32.61494], [-116.59781, 32.61496]]]} | Open Access 1 | 836 | Potrero Park | 23926 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Potrero.html | San Diego 4 | 126.277 | Potrero Park | 0 | Local Park 2 | 4 |
445 | 445 | 444 | {"type": "Polygon", "coordinates": [[[-119.56174, 34.43642], [-119.54997, 34.43637], [-119.54992, 34.43528], [-119.55032, 34.43491], [-119.55041, 34.43442], [-119.553, 34.4332], [-119.55302, 34.4319], [-119.55511, 34.43201], [-119.55572, 34.43196], [-119.55613, 34.43206], [-119.55647, 34.43203], [-119.55731, 34.43219], [-119.55826, 34.43235], [-119.55812, 34.43257], [-119.55654, 34.43284], [-119.55664, 34.43332], [-119.55682, 34.43352], [-119.55775, 34.43371], [-119.55825, 34.43377], [-119.55918, 34.43363], [-119.55997, 34.4338], [-119.56007, 34.43451], [-119.56063, 34.435], [-119.56121, 34.43547], [-119.56174, 34.43642]]]} | Open Access 1 | 1384 | Toro Canyon Park | 26412 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 88.907 | Toro Canyon Park | 0 | Local Park 2 | 4 | |
518 | 518 | 517 | {"type": "Polygon", "coordinates": [[[-117.98854, 34.05187], [-117.98765, 34.05279], [-117.98644, 34.05198], [-117.98629, 34.05211], [-117.98513, 34.05133], [-117.98614, 34.05027], [-117.98854, 34.05187]]]} | Open Access 1 | 2142 | Bassett Park | 15856 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 9.789 | Bassett Park | 0 | Local Park 2 | 4 | |
520 | 520 | 519 | {"type": "Polygon", "coordinates": [[[-121.65535, 36.14492], [-121.65525, 36.14864], [-121.65386, 36.14763], [-121.65385, 36.14752], [-121.65399, 36.14736], [-121.65389, 36.14607], [-121.65374, 36.14584], [-121.6534, 36.14576], [-121.65314, 36.14575], [-121.65294, 36.1453], [-121.65272, 36.14538], [-121.65239, 36.14573], [-121.65235, 36.14542], [-121.65198, 36.14474], [-121.65177, 36.14463], [-121.65147, 36.14463], [-121.65137, 36.14468], [-121.65116, 36.14459], [-121.65078, 36.14454], [-121.65052, 36.14463], [-121.65059, 36.1445], [-121.65066, 36.14424], [-121.65068, 36.14402], [-121.6505, 36.14395], [-121.6499, 36.1439], [-121.64972, 36.14395], [-121.64996, 36.14376], [-121.65037, 36.14371], [-121.65056, 36.1435], [-121.6513, 36.14321], [-121.65163, 36.14301], [-121.65168, 36.14306], [-121.65195, 36.14289], [-121.65201, 36.14294], [-121.65211, 36.14287], [-121.65237, 36.14286], [-121.65256, 36.14307], [-121.65324, 36.14282], [-121.65369, 36.14283], [-121.65387, 36.14319], [-121.65407, 36.14339], [-121.65407, 36.14365], [-121.65414, 36.14379], [-121.65407, 36.14384], [-121.65378, 36.14355], [-121.65334, 36.14344], [-121.65331, 36.14351], [-121.65359, 36.14366], [-121.65385, 36.14418], [-121.65378, 36.1444], [-121.65366, 36.1441], [-121.6533, 36.14395], [-121.65323, 36.144], [-121.65348, 36.1442], [-121.65351, 36.14468], [-121.65363, 36.14478], [-121.65396, 36.14481], [-121.65438, 36.14473], [-121.65458, 36.1449], [-121.65465, 36.14506], [-121.65535, 36.14492]]]} | Open Access 1 | 1721 | Veren Park | 26993 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 28.032 | Veren Park | 0 | Local Park 2 | 4 | |
522 | 522 | 521 | {"type": "MultiPolygon", "coordinates": [[[[-121.38423, 36.8413], [-121.3842, 36.84189], [-121.38417, 36.84218], [-121.38396, 36.84324], [-121.3839, 36.84362], [-121.3837, 36.84738], [-121.38157, 36.84731], [-121.38185, 36.84121], [-121.38423, 36.8413]]], [[[-121.38482, 36.84132], [-121.38469, 36.84397], [-121.38412, 36.84395], [-121.38419, 36.84338], [-121.38443, 36.84217], [-121.38448, 36.84131], [-121.38482, 36.84132]]]]} | Open Access 1 | 1731 | Veteran's Memorial Park | 27010 | 317 | San Benito, County of 197 | County 3 | County Agency 3 | http://sbcparks.org/ | County 3 | 317 | San Benito, County of 193 | County 3 | County Agency 3 | San Benito 38 | 35.719 | Veteran's Memorial Park | 0 | Local Park 2 | 4 | |
543 | 543 | 542 | {"type": "Polygon", "coordinates": [[[-118.79147, 34.41667], [-118.79144, 34.41725], [-118.79115, 34.41732], [-118.79079, 34.41734], [-118.79041, 34.4173], [-118.79004, 34.41718], [-118.78978, 34.41704], [-118.78916, 34.41666], [-118.78927, 34.41636], [-118.79085, 34.41637], [-118.79098, 34.41637], [-118.79098, 34.41667], [-118.79147, 34.41667]]]} | Open Access 1 | 1806 | Warring Park | 27265 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 4.168 | Warring Park | 0 | Local Park 2 | 4 | |
575 | 575 | 574 | {"type": "Polygon", "coordinates": [[[-116.55091, 32.68226], [-116.5509, 32.68904], [-116.54671, 32.68903], [-116.54666, 32.69624], [-116.54247, 32.69617], [-116.54246, 32.69264], [-116.53813, 32.69259], [-116.53815, 32.68901], [-116.53404, 32.68893], [-116.53398, 32.69617], [-116.53815, 32.6962], [-116.53809, 32.71037], [-116.53398, 32.71042], [-116.53382, 32.71605], [-116.53385, 32.72189], [-116.52947, 32.72189], [-116.52952, 32.72556], [-116.52511, 32.72556], [-116.5252, 32.71823], [-116.52073, 32.71818], [-116.52069, 32.71598], [-116.52077, 32.71459], [-116.51671, 32.71461], [-116.5166, 32.70729], [-116.50784, 32.70735], [-116.50786, 32.71104], [-116.50351, 32.71109], [-116.5035, 32.71481], [-116.49896, 32.71499], [-116.4951, 32.71505], [-116.4951, 32.71112], [-116.49937, 32.71107], [-116.49957, 32.6966], [-116.50366, 32.69661], [-116.50364, 32.70018], [-116.50784, 32.70019], [-116.508, 32.69288], [-116.51156, 32.6929], [-116.51245, 32.69289], [-116.51259, 32.68983], [-116.51262, 32.68937], [-116.51405, 32.68937], [-116.51423, 32.68936], [-116.51428, 32.6885], [-116.51487, 32.68809], [-116.51478, 32.68764], [-116.51501, 32.68738], [-116.515, 32.68715], [-116.51517, 32.68685], [-116.51506, 32.68635], [-116.51528, 32.68609], [-116.51576, 32.68605], [-116.51581, 32.68607], [-116.51608, 32.68574], [-116.51671, 32.68596], [-116.51671, 32.68474], [-116.51678, 32.68255], [-116.51675, 32.68254], [-116.51675, 32.68218], [-116.52375, 32.68219], [-116.52543, 32.68216], [-116.52542, 32.67813], [-116.53399, 32.67817], [-116.534, 32.67113], [-116.53823, 32.67113], [-116.5382, 32.67463], [-116.54239, 32.67461], [-116.54239, 32.67817], [-116.54667, 32.67819], [-116.5467, 32.68224], [-116.55091, 32.68226]], [[-116.534, 32.67817], [-116.53399, 32.67818], [-116.53399, 32.68219], [-116.53814, 32.68223], [-116.53816, 32.6782], [-116.534, 32.67817]]]} | Open Access 1 | 3446 | Lake Morena County Park | 10398 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LakeMorena.html | San Diego 4 | 3278.988 | Lake Morena County Park | 0 | Local Park 2 | 4 |
579 | 579 | 578 | {"type": "Polygon", "coordinates": [[[-119.89552, 34.4344], [-119.89508, 34.43471], [-119.89486, 34.4345], [-119.89513, 34.43431], [-119.89512, 34.4338], [-119.89489, 34.4336], [-119.8955, 34.43359], [-119.89552, 34.4344]]]} | Open Access 1 | 1927 | Winchester I Park | 27619 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.139 | Winchester I Park | 0 | Local Park 2 | 4 | |
581 | 581 | 580 | {"type": "Polygon", "coordinates": [[[-119.89864, 34.43647], [-119.89778, 34.43649], [-119.89777, 34.43593], [-119.89862, 34.43591], [-119.89864, 34.43647]]]} | Open Access 1 | 1936 | Winchester II Park | 27620 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.211 | Winchester II Park | 0 | Local Park 2 | 4 | |
601 | 601 | 600 | {"type": "Polygon", "coordinates": [[[-116.86232, 33.04283], [-116.86091, 33.04362], [-116.85968, 33.04204], [-116.8611, 33.04126], [-116.86164, 33.04196], [-116.86161, 33.04199], [-116.86171, 33.04211], [-116.86175, 33.04209], [-116.86232, 33.04283]]]} | Open Access 1 | 4174 | Collier Park | 17519 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Collier.html | San Diego 4 | 8.145 | Collier Park | 0 | Local Park 2 | 4 |
639 | 639 | 638 | {"type": "Polygon", "coordinates": [[[-117.88348, 33.60245], [-117.88321, 33.60315], [-117.88242, 33.60231], [-117.88295, 33.60212], [-117.88348, 33.60245]]]} | Open Access 1 | 2654 | Bayside Drive Beach | 15893 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.344 | Bayside Drive Beach | 0 | Local Park 2 | 4 | |
677 | 677 | 676 | {"type": "Polygon", "coordinates": [[[-117.0076, 32.7182], [-117.00574, 32.7182], [-117.00573, 32.71601], [-117.00759, 32.71601], [-117.0076, 32.7182]]]} | Open Access 1 | 5123 | Sweetwater Lane County Park | 29258 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/SweetwaterLane.html | San Diego 4 | 10.435 | Sweetwater Lane County Park | 0 | Local Park 2 | 4 |
695 | 695 | 694 | {"type": "Polygon", "coordinates": [[[-118.05463, 33.98259], [-118.05463, 33.98262], [-118.05459, 33.98263], [-118.05399, 33.98263], [-118.0539, 33.9826], [-118.05387, 33.98256], [-118.05386, 33.98251], [-118.05397, 33.98223], [-118.05403, 33.98219], [-118.05411, 33.98218], [-118.05417, 33.9822], [-118.05456, 33.98246], [-118.05462, 33.98252], [-118.05463, 33.98259]]]} | Open Access 1 | 5236 | McNees Park | 22064 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.604 | McNees Park | 0 | Local Park 2 | 4 | |
720 | 720 | 719 | {"type": "Polygon", "coordinates": [[[-117.64606, 33.71715], [-117.64569, 33.71705], [-117.6455, 33.71693], [-117.64478, 33.71604], [-117.64591, 33.71499], [-117.64598, 33.71518], [-117.64608, 33.71555], [-117.64612, 33.7158], [-117.64612, 33.71618], [-117.64606, 33.71715]]]} | Open Access 1 | 5401 | Modjeska Home and Garden | 22342 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 4.245 | Modjeska Home and Garden | 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]);