units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
206 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 7 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 24
MNG_AGENCY 7
- Los Angeles - Department of Parks and Recreation, County of 57
- Sonoma County Regional Parks Dept., County of 47
- Santa Clara County Parks and Recreation Dept., County of 40
- Marin County Parks Department, County of 32
- San Mateo County Parks and Recreation Dept., County of 24
- Del Norte County Parks, County of 5
- Yolo County Parks, County of 1
MNG_AG_TYP 1
- County Agency - Parks · 206 ✖
ACCESS_TYP 1
- Open Access · 206 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11442 | 11442 | 11441 | {"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 | 48138 | Lennox Community Garden | 32666 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.127 | Lennox Community Garden | 0 | Local Park 2 | 4 | |
9554 | 9554 | 9553 | {"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 | 16105 | Candy's Park | 16799 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.134 | Candy's Park | 0 | Local Park 2 | 4 | |
12451 | 12451 | 12450 | {"type": "Polygon", "coordinates": [[[-121.85893, 37.37941], [-121.85873, 37.3795], [-121.85851, 37.37957], [-121.8585, 37.37936], [-121.85856, 37.37933], [-121.85893, 37.37941]]]} | Open Access 1 | 28092 | Penitencia Creek Park | 23582 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 0.135 | Penitencia Creek Park | 1872 | Local Park 2 | 4 | |
11446 | 11446 | 11445 | {"type": "Polygon", "coordinates": [[[-118.49983, 34.28887], [-118.49978, 34.28895], [-118.49972, 34.28892], [-118.49959, 34.28878], [-118.49971, 34.28866], [-118.49975, 34.28864], [-118.49983, 34.28865], [-118.49987, 34.28867], [-118.49989, 34.28871], [-118.49989, 34.28876], [-118.49983, 34.28885], [-118.49983, 34.28887]]]} | Open Access 1 | 48139 | Knollwood Pool | 32669 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/knollwood-pool/ | Los Angeles 6 | 0.141 | Knollwood Pool | 0 | Local Recreation Area 3 | 4 |
4302 | 4302 | 4301 | {"type": "Polygon", "coordinates": [[[-118.1262, 34.18898], [-118.12621, 34.18904], [-118.12603, 34.18933], [-118.12602, 34.18935], [-118.12595, 34.18934], [-118.12593, 34.18924], [-118.12595, 34.18897], [-118.12609, 34.18896], [-118.1262, 34.18898]]]} | Open Access 1 | 48153 | Ganesha Park | 32689 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.181 | Ganesha Park | 0 | Local Park 2 | 4 | |
14869 | 14869 | 14868 | {"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 | 45388 | Pickens Canyon Park | 32497 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Pickens_Canyon_Park | Los Angeles 6 | 0.22 | Pickens Canyon Park | 0 | Local Park 2 | 4 |
15076 | 15076 | 15075 | {"type": "Polygon", "coordinates": [[[-118.23107, 34.20894], [-118.23096, 34.20934], [-118.23094, 34.20936], [-118.2309, 34.20936], [-118.23081, 34.20922], [-118.23064, 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 | 45856 | Mira Vista Park | 32494 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.249 | Mira Vista Park | 0 | Local Park 2 | 4 | |
14522 | 14522 | 14521 | {"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 | 47185 | Corte Los Sombras Park | 31223 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.299 | Corte Los Sombras Park | 0 | Local Park 2 | 4 | |
5566 | 5566 | 5565 | {"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 | 46891 | 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 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 0.407 | Friendship Park | 0 | Local Park 2 | 4 | |
15080 | 15080 | 15079 | {"type": "Polygon", "coordinates": [[[-118.29689, 33.82584], [-118.29682, 33.82596], [-118.29682, 33.82618], [-118.2968, 33.82621], [-118.2963, 33.82621], [-118.2963, 33.82584], [-118.29689, 33.82584]]]} | Open Access 1 | 45860 | Park Learning Grove County Park | 32495 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Park_Learning_Grove_County_Park | Los Angeles 6 | 0.488 | Park Learning Grove County Park | 0 | Local Park 2 | 4 |
9757 | 9757 | 9756 | {"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.13216, 34.18976], [-118.13253, 34.18988]]]} | Open Access 1 | 47869 | Altadena Triangle Park | 32467 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/altadena-triangle-park/ | Los Angeles 6 | 0.524 | Altadena Triangle Park | 0 | Local Park 2 | 4 |
3988 | 3988 | 3987 | {"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 | 38044 | Forest Knolls Park | 18995 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.526 | Forest Knolls Park | 0 | Local Park 2 | 4 | |
11566 | 11566 | 11565 | {"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 | 23648 | Shell Beach | 25387 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 0.556 | Shell Beach | 0 | Local Park 2 | 4 | |
5567 | 5567 | 5566 | {"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 | 46892 | 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 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 0.6 | Moss Beach Park | 0 | Local Park 2 | 4 | |
14035 | 14035 | 14034 | {"type": "MultiPolygon", "coordinates": [[[[-122.63982, 37.89789], [-122.63971, 37.89843], [-122.63938, 37.89841], [-122.63938, 37.89813], [-122.63955, 37.89814], [-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 | 38042 | Village Green | 27111 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.621 | Village Green | 0 | Local Park 2 | 4 | |
2626 | 2626 | 2625 | {"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 | 18036 | Moran Goodman Park | 22470 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 0.652 | Moran Goodman Park | 1990 | Local Park 2 | 4 | |
2470 | 2470 | 2469 | {"type": "Polygon", "coordinates": [[[-121.93625, 37.29043], [-121.93574, 37.29058], [-121.93531, 37.29081], [-121.93489, 37.29119], [-121.93414, 37.29197], [-121.93402, 37.29191], [-121.93485, 37.29101], [-121.93558, 37.29054], [-121.93623, 37.29028], [-121.93625, 37.29043]]]} | Open Access 1 | 17438 | Los Gatos Creek Trail | 21517 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 0.826 | Los Gatos Creek Trail | 1966 | Local Recreation Area 3 | 4 | |
9586 | 9586 | 9585 | {"type": "Polygon", "coordinates": [[[-122.51646, 38.01272], [-122.51615, 38.01311], [-122.51571, 38.01298], [-122.51568, 38.01286], [-122.5156, 38.01274], [-122.51562, 38.0127], [-122.51608, 38.01244], [-122.51646, 38.01272]]]} | Open Access 1 | 16115 | Adrian Rosall Park | 15275 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.826 | Adrian Rosall Park | 0 | Local Park 2 | 4 | |
9588 | 9588 | 9587 | {"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.01565], [-122.51505, 38.01543], [-122.51507, 38.01544], [-122.51488, 38.01566], [-122.5151, 38.01577]]]} | Open Access 1 | 16117 | Pueblo Park | 24026 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.899 | Pueblo Park | 0 | Local Park 2 | 4 | |
9345 | 9345 | 9344 | {"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 | 15612 | 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 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 1.049 | Washington Playground | 1962 | 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]);