units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
158 rows where AGNCY_TYP = 7 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, COUNTY, YR_EST, GAP_STS
DES_TP 25
- Local Park 103
- Local Recreation Area 17
- Local Conservation Area 12
- Local Resource Management Area 5
- Local Other or Unknown 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
MNG_AGENCY 9
- Sonoma County Regional Parks Dept., County of 49
- Santa Clara County Parks and Recreation Dept., County of 41
- Marin County Parks Department, County of 33
- San Mateo County Parks and Recreation Dept., County of 24
- Del Norte County Parks, County of 6
- Half Moon Bay, City of 2
- Save the Redwoods League 1
- Yolo County Parks, County of 1
- Midpeninsula Regional Open Space District 1
MNG_AG_TYP 4
ACCESS_TYP 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
14491 | 14491 | 14490 | {"type": "Polygon", "coordinates": [[[-122.46195, 37.49453], [-122.46172, 37.49469], [-122.46102, 37.49405], [-122.46116, 37.49395], [-122.4618, 37.49439], [-122.46195, 37.49453]]]} | Open Access 1 | 47150 | Miramar Beach | 33339 | 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 | 1128 | Half Moon Bay, City of 433 | City 2 | City Agency 2 | San Mateo 15 | 0.536 | Miramar Beach | 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 | |
12459 | 12459 | 12458 | {"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 | 28220 | Watson School/ Wayside Park | 31655 | 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 | 1.062 | Watson School/ Wayside Park | 0 | Local Park 2 | 4 | |
12577 | 12577 | 12576 | {"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 | 29137 | Rocky Graham Park | 24540 | 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 | 1.113 | Rocky Graham Park | 0 | Local Park 2 | 4 | |
6329 | 6329 | 6328 | {"type": "Polygon", "coordinates": [[[-122.68693, 37.90647], [-122.68631, 37.90679], [-122.68619, 37.90667], [-122.68607, 37.90645], [-122.68603, 37.90634], [-122.68601, 37.90621], [-122.68605, 37.90594], [-122.68612, 37.90585], [-122.68623, 37.90589], [-122.68637, 37.90596], [-122.68663, 37.90614], [-122.68674, 37.90624], [-122.68693, 37.90647]]]} | Open Access 1 | 1648 | Bolinas Park | 30877 | 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 | 1.195 | Bolinas Park | 0 | Local Park 2 | 4 | |
14917 | 14917 | 14916 | {"type": "Polygon", "coordinates": [[[-124.15565, 41.74626], [-124.15565, 41.74659], [-124.15543, 41.7466], [-124.15543, 41.74692], [-124.15471, 41.74692], [-124.15467, 41.74626], [-124.15565, 41.74626]]]} | Open Access 1 | 45487 | Bertsch Tract Park | 28317 | 347 | Del Norte County Parks, County of 672 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | Del Norte 50 | 1.281 | Bertsch Tract Park | 0 | Local Park 2 | 4 | |
14525 | 14525 | 14524 | {"type": "Polygon", "coordinates": [[[-122.57028, 38.00565], [-122.57023, 38.00585], [-122.57009, 38.00592], [-122.57018, 38.00616], [-122.57005, 38.00647], [-122.56991, 38.00659], [-122.5698, 38.00673], [-122.5697, 38.00695], [-122.56969, 38.00718], [-122.56964, 38.00742], [-122.56977, 38.0076], [-122.56977, 38.00771], [-122.56965, 38.00773], [-122.56934, 38.00762], [-122.56925, 38.00756], [-122.56921, 38.00748], [-122.56915, 38.00728], [-122.56908, 38.00722], [-122.56887, 38.00718], [-122.56872, 38.00718], [-122.56849, 38.00724], [-122.56849, 38.00723], [-122.56862, 38.00716], [-122.56884, 38.00709], [-122.56884, 38.00708], [-122.56882, 38.00704], [-122.56889, 38.00704], [-122.56915, 38.0071], [-122.56927, 38.00717], [-122.56931, 38.00724], [-122.56937, 38.00743], [-122.56939, 38.00747], [-122.56944, 38.00751], [-122.5695, 38.00753], [-122.56947, 38.00746], [-122.56947, 38.00739], [-122.56952, 38.00717], [-122.56952, 38.00699], [-122.56954, 38.00686], [-122.56964, 38.00667], [-122.56977, 38.0065], [-122.56989, 38.0064], [-122.57, 38.00615], [-122.56988, 38.00586], [-122.57028, 38.00565]]]} | Open Access 1 | 47190 | Mission Pass Path | 30882 | 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 | 1.357 | Mission Pass Path | 0 | Local Recreation Area 3 | 4 | |
9571 | 9571 | 9570 | {"type": "Polygon", "coordinates": [[[-122.52552, 38.01157], [-122.52518, 38.01194], [-122.5243, 38.01226], [-122.52403, 38.01202], [-122.52394, 38.01186], [-122.52379, 38.01175], [-122.52359, 38.01165], [-122.52362, 38.01157], [-122.52384, 38.01164], [-122.52431, 38.0117], [-122.52484, 38.01171], [-122.52507, 38.01169], [-122.52552, 38.01157]]]} | Open Access 1 | 16103 | Castro Park | 16961 | 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 | 1.427 | Castro Park | 0 | Local Park 2 | 4 | |
9605 | 9605 | 9604 | {"type": "Polygon", "coordinates": [[[-122.49053, 38.30297], [-122.49039, 38.30284], [-122.49011, 38.30262], [-122.48963, 38.30238], [-122.48939, 38.30214], [-122.48932, 38.30204], [-122.4892, 38.30194], [-122.4891, 38.30188], [-122.48889, 38.30184], [-122.48857, 38.30189], [-122.48751, 38.30222], [-122.48744, 38.30222], [-122.48741, 38.3022], [-122.48739, 38.30215], [-122.48778, 38.30202], [-122.48781, 38.30207], [-122.4896, 38.3014], [-122.48976, 38.30169], [-122.48999, 38.30208], [-122.49019, 38.30247], [-122.49053, 38.30297]]]} | Open Access 1 | 16158 | Ernie Smith Community Park | 18699 | 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 | 2.099 | Ernie Smith Community 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]);