superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
218 rows where MNG_AG_TYP = 7 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, AGNCY_WEB
YR_EST 26 ✖
MNG_AGENCY 7
- Los Angeles - Department of Parks and Recreation, County of 63
- Sonoma County Regional Parks Dept., County of 48
- Santa Clara County Parks and Recreation Dept., County of 42
- Marin County Parks Department, County of 34
- San Mateo County Parks and Recreation Dept., County of 24
- Del Norte County Parks, County of 6
- Yolo County Parks, County of 1
ACCESS_TYP 4
- Open Access 189
- No Public Access 17
- Restricted Access 11
- Unknown Access 1
MNG_AG_TYP 1
- County Agency - Parks · 218 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14203 | 14203 | 14202 | {"type": "Polygon", "coordinates": [[[-118.36175, 33.93255], [-118.36175, 33.93272], [-118.36145, 33.93272], [-118.36146, 33.93255], [-118.36175, 33.93255]]]} | Open Access 1 | Lennox Community Garden | 32666 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 0.127 | Lennox Community Garden | ||
2581 | 2581 | 2580 | {"type": "Polygon", "coordinates": [[[-122.51744, 38.01193], [-122.51734, 38.01202], [-122.51708, 38.01218], [-122.51696, 38.01205], [-122.51738, 38.01189], [-122.51744, 38.01193]]]} | Open Access 1 | Candy's Park | 16799 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 0.134 | Candy's Park | ||
13514 | 13514 | 13513 | {"type": "Polygon", "coordinates": [[[-118.49989, 34.28871], [-118.49989, 34.28876], [-118.49978, 34.28895], [-118.49972, 34.28892], [-118.49959, 34.28878], [-118.49971, 34.28866], [-118.49975, 34.28864], [-118.49987, 34.28867], [-118.49989, 34.28871]]]} | Open Access 1 | Knollwood Pool | http://parks.lacounty.gov/knollwood-pool/ | 32669 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 0.139 | Knollwood Pool | |
588 | 588 | 587 | {"type": "Polygon", "coordinates": [[[-118.12621, 34.18904], [-118.12602, 34.18935], [-118.12595, 34.18934], [-118.12593, 34.18924], [-118.12595, 34.18897], [-118.12609, 34.18896], [-118.1262, 34.18898], [-118.12621, 34.18904]]]} | Open Access 1 | Ganesha Park | 32689 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 0.18 | Ganesha Park | ||
13911 | 13911 | 13910 | {"type": "Polygon", "coordinates": [[[-118.23121, 34.21905], [-118.23088, 34.21936], [-118.23059, 34.21958], [-118.23052, 34.21953], [-118.23111, 34.21899], [-118.23121, 34.21905]]]} | Open Access 1 | Pickens Canyon Park | http://parks.lacounty.gov/wps/portal/dpr/Parks/Pickens_Canyon_Park | 32497 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 0.22 | Pickens Canyon Park | |
13900 | 13900 | 13899 | {"type": "Polygon", "coordinates": [[[-118.23107, 34.20894], [-118.23096, 34.20934], [-118.23094, 34.20936], [-118.2309, 34.20936], [-118.23081, 34.20922], [-118.23065, 34.20904], [-118.23064, 34.20902], [-118.23066, 34.209], [-118.23091, 34.20896], [-118.23103, 34.20892], [-118.23106, 34.20892], [-118.23107, 34.20894]]]} | Open Access 1 | Mira Vista Park | 32494 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 0.249 | Mira Vista Park | ||
12553 | 12553 | 12552 | {"type": "Polygon", "coordinates": [[[-122.52992, 37.94943], [-122.52988, 37.94956], [-122.52939, 37.94972], [-122.5293, 37.94972], [-122.52954, 37.94934], [-122.52992, 37.94943]]]} | Open Access 1 | Corte Los Sombras Park | 31223 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 0.299 | Corte Los Sombras Park | ||
13111 | 13111 | 13110 | {"type": "Polygon", "coordinates": [[[-122.21003, 37.47408], [-122.20952, 37.47417], [-122.20935, 37.47434], [-122.20898, 37.4741], [-122.20983, 37.47394], [-122.21003, 37.47408]]]} | Open Access 1 | Friendship Park | 30388 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 0.407 | Friendship Park | ||
13901 | 13901 | 13900 | {"type": "Polygon", "coordinates": [[[-118.29689, 33.82584], [-118.29682, 33.82596], [-118.29682, 33.82618], [-118.2968, 33.82621], [-118.2963, 33.82621], [-118.29631, 33.82584], [-118.29689, 33.82584]]]} | Open Access 1 | Park Learning Grove County Park | http://parks.lacounty.gov/wps/portal/dpr/Parks/Park_Learning_Grove_County_Park | 32495 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 0.488 | Park Learning Grove County Park | |
12591 | 12591 | 12590 | {"type": "Polygon", "coordinates": [[[-118.13253, 34.18988], [-118.13208, 34.1899], [-118.13157, 34.19001], [-118.1315, 34.18999], [-118.13147, 34.18994], [-118.13148, 34.18975], [-118.13166, 34.18963], [-118.13189, 34.1897], [-118.13207, 34.18969], [-118.13217, 34.18976], [-118.13253, 34.18988]]]} | Open Access 1 | Altadena Triangle Park | http://parks.lacounty.gov/altadena-triangle-park/ | 32467 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/ | County 3 | 0.524 | Altadena Triangle Park | |
4308 | 4308 | 4307 | {"type": "Polygon", "coordinates": [[[-122.68946, 38.01406], [-122.68941, 38.01415], [-122.68914, 38.01432], [-122.68905, 38.01435], [-122.68897, 38.01436], [-122.6889, 38.01434], [-122.68874, 38.01421], [-122.68929, 38.01378], [-122.6893, 38.01384], [-122.68938, 38.01388], [-122.68944, 38.01394], [-122.68946, 38.01399], [-122.68946, 38.01406]]]} | Open Access 1 | Forest Knolls Park | 18995 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 0.526 | Forest Knolls Park | ||
9584 | 9584 | 9583 | {"type": "Polygon", "coordinates": [[[-123.4743, 38.7297], [-123.47379, 38.7302], [-123.47355, 38.72996], [-123.47404, 38.72949], [-123.4743, 38.7297]]]} | Open Access 1 | Shell Beach | 25387 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 0.556 | Shell Beach | ||
13112 | 13112 | 13111 | {"type": "Polygon", "coordinates": [[[-122.51225, 37.52751], [-122.51195, 37.52795], [-122.51135, 37.52763], [-122.512, 37.5274], [-122.51225, 37.52751]]]} | Open Access 1 | Moss Beach Park | 30389 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 0.6 | Moss Beach Park | ||
10877 | 10877 | 10876 | {"type": "MultiPolygon", "coordinates": [[[[-122.63982, 37.89789], [-122.63971, 37.89843], [-122.63938, 37.89841], [-122.63938, 37.89813], [-122.63955, 37.89813], [-122.63955, 37.89788], [-122.63982, 37.89789]]], [[[-122.64032, 37.89826], [-122.64022, 37.8985], [-122.6399, 37.89842], [-122.63995, 37.89817], [-122.64032, 37.89826]]]]} | Open Access 1 | Village Green | 27111 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 0.623 | Village Green | ||
7199 | 7199 | 7198 | {"type": "Polygon", "coordinates": [[[-122.51197, 38.34219], [-122.51196, 38.34225], [-122.51196, 38.34231], [-122.51135, 38.34242], [-122.51119, 38.34185], [-122.51136, 38.34182], [-122.51197, 38.34219]]]} | Open Access 1 | Moran Goodman Park | 22470 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 0.652 | Moran Goodman Park | 1990 | |
577 | 577 | 576 | {"type": "Polygon", "coordinates": [[[-122.51646, 38.01272], [-122.51615, 38.01311], [-122.51571, 38.01298], [-122.51567, 38.01286], [-122.5156, 38.01274], [-122.51562, 38.0127], [-122.51608, 38.01244], [-122.51646, 38.01272]]]} | Open Access 1 | Adrian Rosall Park | 15275 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 0.826 | Adrian Rosall Park | ||
8430 | 8430 | 8429 | {"type": "Polygon", "coordinates": [[[-122.5151, 38.01577], [-122.51506, 38.01607], [-122.51496, 38.01608], [-122.51487, 38.01612], [-122.51466, 38.01636], [-122.51442, 38.01623], [-122.51419, 38.01606], [-122.5143, 38.01593], [-122.51453, 38.01595], [-122.51459, 38.01568], [-122.51475, 38.01559], [-122.51485, 38.01564], [-122.51505, 38.01543], [-122.51507, 38.01544], [-122.51488, 38.01566], [-122.5151, 38.01577]]]} | Open Access 1 | Pueblo Park | 24026 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 0.904 | Pueblo Park | ||
11044 | 11044 | 11043 | {"type": "Polygon", "coordinates": [[[-122.29842, 37.5564], [-122.2981, 37.55659], [-122.29806, 37.55653], [-122.29799, 37.55649], [-122.29791, 37.55648], [-122.29782, 37.55651], [-122.29745, 37.55611], [-122.2975, 37.55607], [-122.29753, 37.556], [-122.29751, 37.55594], [-122.29746, 37.55589], [-122.29777, 37.55571], [-122.29842, 37.5564]]]} | Open Access 1 | Washington Playground | 27284 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 1.049 | Washington Playground | 1962 | |
14179 | 14179 | 14178 | {"type": "Polygon", "coordinates": [[[-122.93948, 38.35579], [-122.93861, 38.35592], [-122.93857, 38.35592], [-122.93856, 38.35587], [-122.93847, 38.35577], [-122.93853, 38.35573], [-122.93849, 38.35551], [-122.93858, 38.35544], [-122.93913, 38.35514], [-122.93922, 38.35551], [-122.93948, 38.35579]]]} | Restricted Access 2 | Watson School/ Wayside Park | 31655 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 1.063 | Watson School/ Wayside Park | ||
8879 | 8879 | 8878 | {"type": "Polygon", "coordinates": [[[-122.51392, 37.87414], [-122.51376, 37.87421], [-122.51357, 37.87426], [-122.51337, 37.87427], [-122.51323, 37.87425], [-122.51309, 37.8742], [-122.51297, 37.87413], [-122.51288, 37.87403], [-122.51283, 37.87395], [-122.51347, 37.87356], [-122.51369, 37.87376], [-122.51369, 37.87378], [-122.51392, 37.87414]]]} | Open Access 1 | Rocky Graham Park | 24540 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 1.112 | Rocky Graham Park |
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]);