superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
97 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, MNG_AG_ID, AGNCY_WEB
MNG_AGENCY 8
- East Bay Regional Park District 41
- Santa Clara Valley Open Space Authority 17
- Midpeninsula Regional Open Space District 17
- Sonoma County Agricultural Preservation and Open Space District 11
- Napa County Regional Park and Open Space District 7
- Monterey Peninsula Regional Park District 2
- Marin County Open Space District 1
- Livermore Area Recreation and Park District 1
MNG_AG_TYP 1
- Recreation/Parks District · 97 ✖
ACCESS_TYP 1
- No Public Access · 97 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12220 | 12220 | 12219 | {"type": "Polygon", "coordinates": [[[-122.16888, 37.8072], [-122.16832, 37.80721], [-122.16831, 37.80674], [-122.16805, 37.80673], [-122.16806, 37.80645], [-122.16886, 37.8061], [-122.16888, 37.8072]]]} | No Public Access 3 | Redwood Regional Park | 30634 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 1.526 | Redwood RP | 1939 | |
7467 | 7467 | 7466 | {"type": "Polygon", "coordinates": [[[-122.3732, 37.97143], [-122.37282, 37.97158], [-122.37227, 37.97224], [-122.37225, 37.97251], [-122.37217, 37.97255], [-122.37148, 37.97255], [-122.37238, 37.97143], [-122.3732, 37.97143]]]} | No Public Access 3 | North Richmond Wetlands | 22856 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 1.611 | North Richmond Wetlands | ||
14078 | 14078 | 14077 | {"type": "Polygon", "coordinates": [[[-122.34141, 37.899], [-122.33912, 37.89903], [-122.33911, 37.89846], [-122.3414, 37.89842], [-122.34141, 37.899]]]} | No Public Access 3 | Brooks Island Regional Preserve | 31524 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 3.175 | Brooks Island RPr | ||
12962 | 12962 | 12961 | {"type": "Polygon", "coordinates": [[[-122.21029, 37.33464], [-122.21012, 37.33619], [-122.20954, 37.33542], [-122.20931, 37.3353], [-122.20907, 37.33507], [-122.20787, 37.33496], [-122.20832, 37.3339], [-122.20853, 37.33408], [-122.20943, 37.33451], [-122.21029, 37.33464]]]} | No Public Access 3 | Coal Creek Open Space Preserve | http://www.openspace.org/preserves/pr_coal_creek.asp | 31502 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 5.248 | Coal Creek OSP | |
10329 | 10329 | 10328 | {"type": "Polygon", "coordinates": [[[-121.79058, 36.52123], [-121.79045, 36.52142], [-121.79048, 36.52155], [-121.79052, 36.52163], [-121.79026, 36.52171], [-121.7886, 36.52066], [-121.7887, 36.52057], [-121.78783, 36.5197], [-121.78919, 36.51943], [-121.7892, 36.51992], [-121.78948, 36.52042], [-121.78993, 36.52087], [-121.79025, 36.52083], [-121.79058, 36.52123]]]} | No Public Access 3 | Thomas Open Space | 26308 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 5.317 | Thomas OS | ||
13039 | 13039 | 13038 | {"type": "Polygon", "coordinates": [[[-121.86443, 37.2402], [-121.86348, 37.24014], [-121.86302, 37.23952], [-121.86246, 37.23953], [-121.8623, 37.23942], [-121.86313, 37.23732], [-121.86382, 37.23753], [-121.86443, 37.2402]]]} | No Public Access 3 | Santa Teresa Foothills Open Space Preserve | http://www.openspaceauthority.org | 31575 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 8.631 | Santa Teresa Foothills OSP | 2016 |
14750 | 14750 | 14749 | {"type": "MultiPolygon", "coordinates": [[[[-122.25101, 37.38772], [-122.25009, 37.38677], [-122.25016, 37.38663], [-122.24959, 37.38534], [-122.24977, 37.3849], [-122.24991, 37.38503], [-122.24978, 37.38544], [-122.2503, 37.38663], [-122.25024, 37.38676], [-122.25101, 37.38756], [-122.25101, 37.38772]]], [[[-122.25556, 37.38431], [-122.25517, 37.38465], [-122.25478, 37.38479], [-122.25397, 37.38546], [-122.25262, 37.38594], [-122.25258, 37.3863], [-122.25234, 37.38657], [-122.25222, 37.38656], [-122.25248, 37.38627], [-122.25251, 37.38585], [-122.25391, 37.38537], [-122.25463, 37.38475], [-122.2551, 37.38458], [-122.25534, 37.38439], [-122.25556, 37.38431]]], [[[-122.25581, 37.39222], [-122.25525, 37.39278], [-122.25538, 37.3932], [-122.25553, 37.39356], [-122.25554, 37.39382], [-122.25519, 37.39392], [-122.25481, 37.39398], [-122.25441, 37.394], [-122.25423, 37.3937], [-122.25429, 37.39309], [-122.25451, 37.39302], [-122.25461, 37.39235], [-122.25436, 37.392], [-122.25467, 37.3916], [-122.25501, 37.3918], [-122.25507, 37.3918], [-122.25511, 37.39182], [-122.25514, 37.39181], [-122.25526, 37.39188], [-122.25526, 37.3919], [-122.25581, 37.39222]]], [[[-122.26368, 37.38918], [-122.26365, 37.38925], [-122.26316, 37.38918], [-122.26272, 37.38929], [-122.26274, 37.38943], [-122.26253, 37.38947], [-122.26249, 37.38934], [-122.26146, 37.38952], [-122.26044, 37.38926], [-122.26019, 37.38939], [-122.25986, 37.38932], [-122.25941, 37.38939], [-122.2598, 37.38915], [-122.26085, 37.38754], [-122.26091, 37.38753], [-122.26104, 37.38753], [-122.261, 37.38759], [-122.26101, 37.38761], [-122.25989, 37.38931], [-122.26025, 37.38926], [-122.26044, 37.38916], [-122.26154, 37.38944], [-122.26316, 37.38911], [-122.26368, 37.38918]]]]} | No Public Access 3 | Thornewood Open Space Preserve | http://www.openspace.org/preserves/pr_thornewood.asp | 31492 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 9.465 | Thornewood OSP | 1986 |
13260 | 13260 | 13259 | {"type": "MultiPolygon", "coordinates": [[[[-122.21078, 37.75096], [-122.21026, 37.75118], [-122.20951, 37.75162], [-122.20928, 37.75171], [-122.20913, 37.75182], [-122.20901, 37.75171], [-122.20802, 37.75057], [-122.20983, 37.74957], [-122.21063, 37.75052], [-122.21078, 37.75096]]], [[[-122.22308, 37.76039], [-122.22247, 37.76073], [-122.22075, 37.7592], [-122.22115, 37.75888], [-122.22144, 37.75881], [-122.22177, 37.75872], [-122.22218, 37.75879], [-122.22256, 37.75923], [-122.2228, 37.75963], [-122.22304, 37.75997], [-122.22308, 37.76039]]]]} | No Public Access 3 | MLK Regional Shoreline | 30577 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 14.006 | MLK Reg. Shoreline | ||
13753 | 13753 | 13752 | {"type": "Polygon", "coordinates": [[[-122.8295, 38.42575], [-122.82842, 38.4255], [-122.82654, 38.42518], [-122.82585, 38.42504], [-122.82581, 38.4245], [-122.82568, 38.4232], [-122.82723, 38.42319], [-122.82787, 38.42348], [-122.82792, 38.42344], [-122.82827, 38.42365], [-122.82852, 38.42382], [-122.82874, 38.42402], [-122.82894, 38.42424], [-122.82918, 38.42458], [-122.82935, 38.42495], [-122.82946, 38.42528], [-122.82949, 38.42548], [-122.8295, 38.42575]]]} | No Public Access 3 | Occidental Road Wetlands | 31262 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 15.728 | Occidental Road Wetlands | 2008 | |
15465 | 15465 | 15464 | {"type": "Polygon", "coordinates": [[[-122.0161, 37.83947], [-122.01593, 37.83968], [-122.01594, 37.83971], [-122.01576, 37.83994], [-122.01475, 37.84015], [-122.01362, 37.84097], [-122.01307, 37.84201], [-122.01332, 37.84594], [-122.01281, 37.84602], [-122.01282, 37.84625], [-122.01252, 37.84626], [-122.01243, 37.84633], [-122.01035, 37.84636], [-122.01015, 37.84633], [-122.01004, 37.84636], [-122.00938, 37.84638], [-122.00738, 37.8457], [-122.00703, 37.84551], [-122.00622, 37.84524], [-122.00475, 37.84479], [-122.00478, 37.84468], [-122.00627, 37.84515], [-122.00735, 37.84552], [-122.00735, 37.84562], [-122.00938, 37.8463], [-122.01245, 37.84625], [-122.0128, 37.84594], [-122.0125, 37.84132], [-122.01337, 37.83979], [-122.01387, 37.83992], [-122.01417, 37.83899], [-122.0151, 37.83896], [-122.01558, 37.83916], [-122.0161, 37.83947]]]} | No Public Access 3 | Las Trampas/Diablo Regional Trail | 21068 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 16.595 | Las Trampas/Diablo Reg. Trail | ||
13273 | 13273 | 13272 | {"type": "Polygon", "coordinates": [[[-121.97561, 37.57073], [-121.97355, 37.57142], [-121.97348, 37.57127], [-121.97245, 37.57159], [-121.97094, 37.57232], [-121.97064, 37.57203], [-121.97072, 37.57045], [-121.97094, 37.5703], [-121.97132, 37.57017], [-121.97167, 37.57028], [-121.97219, 37.57057], [-121.9725, 37.57061], [-121.97248, 37.57023], [-121.97265, 37.56971], [-121.97407, 37.56935], [-121.97486, 37.57004], [-121.97518, 37.57025], [-121.97535, 37.57038], [-121.97561, 37.57073]]]} | No Public Access 3 | Quarry Lakes Regional Recreation Area | 30596 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 17.738 | Quarry Lakes Reg. Rec. Area | 2001 | |
13257 | 13257 | 13256 | {"type": "Polygon", "coordinates": [[[-122.33026, 37.82072], [-122.32855, 37.821], [-122.32573, 37.82142], [-122.32338, 37.82152], [-122.32103, 37.82184], [-122.32075, 37.82185], [-122.32073, 37.82153], [-122.3199, 37.8199], [-122.31924, 37.81945], [-122.31952, 37.81919], [-122.32164, 37.81919], [-122.32166, 37.82096], [-122.32188, 37.82093], [-122.3223, 37.82093], [-122.32253, 37.821], [-122.32267, 37.82099], [-122.32306, 37.82102], [-122.32326, 37.82109], [-122.32373, 37.82106], [-122.32388, 37.82107], [-122.32404, 37.82103], [-122.3242, 37.82103], [-122.32434, 37.82097], [-122.32454, 37.82101], [-122.32474, 37.821], [-122.32495, 37.82094], [-122.32502, 37.82091], [-122.32508, 37.82083], [-122.32518, 37.82079], [-122.32521, 37.8208], [-122.32529, 37.82085], [-122.32552, 37.82092], [-122.32593, 37.82091], [-122.32601, 37.82089], [-122.32606, 37.82087], [-122.32615, 37.82088], [-122.32642, 37.82084], [-122.32661, 37.82077], [-122.32678, 37.82076], [-122.32689, 37.82071], [-122.32719, 37.82065], [-122.32745, 37.82057], [-122.32761, 37.82057], [-122.32777, 37.82061], [-122.32831, 37.82061], [-122.32853, 37.82058], [-122.32861, 37.82055], [-122.32876, 37.82054], [-122.32941, 37.82044], [-122.32994, 37.82033], [-122.3301, 37.82031], [-122.33015, 37.82031], [-122.33026, 37.82072]]]} | No Public Access 3 | East Bay Gateway Shoreline | 30571 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 20.235 | East Bay Gateway Shoreline | ||
13752 | 13752 | 13751 | {"type": "Polygon", "coordinates": [[[-122.72095, 38.37621], [-122.71915, 38.3762], [-122.71901, 38.37594], [-122.71853, 38.37515], [-122.7181, 38.37448], [-122.71699, 38.37267], [-122.72016, 38.37266], [-122.72065, 38.37481], [-122.72095, 38.37621]]]} | No Public Access 3 | Haroutunian - South | 31261 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 21.081 | Haroutunian - South | 1995 | |
117 | 117 | 116 | {"type": "Polygon", "coordinates": [[[-121.72392, 37.72515], [-121.72391, 37.72701], [-121.71937, 37.72699], [-121.71955, 37.72651], [-121.71934, 37.72518], [-121.71901, 37.72496], [-121.71905, 37.72481], [-121.71958, 37.72492], [-121.72009, 37.72486], [-121.72039, 37.72492], [-121.72092, 37.72511], [-121.72158, 37.72515], [-121.72198, 37.72506], [-121.72233, 37.72491], [-121.72253, 37.72495], [-121.72267, 37.72508], [-121.72367, 37.72516], [-121.72392, 37.72515]]]} | No Public Access 3 | Garaventa Wetlands Preserve | https://www.larpd.org/garaventa-wetlands | 31818 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 21.408 | Garaventa Wetlands Preserve | |
820 | 820 | 819 | {"type": "Polygon", "coordinates": [[[-121.88197, 37.73651], [-121.88144, 37.73642], [-121.874, 37.73118], [-121.87389, 37.72956], [-121.8737, 37.72941], [-121.87354, 37.72903], [-121.87339, 37.72886], [-121.87321, 37.72857], [-121.87321, 37.72841], [-121.87326, 37.72834], [-121.87361, 37.72828], [-121.8737, 37.72821], [-121.87367, 37.72806], [-121.87354, 37.72802], [-121.87327, 37.72806], [-121.87305, 37.72785], [-121.87286, 37.72737], [-121.87287, 37.7271], [-121.87293, 37.72697], [-121.87303, 37.72646], [-121.873, 37.72633], [-121.87291, 37.72631], [-121.87278, 37.72635], [-121.87269, 37.72635], [-121.87258, 37.72621], [-121.87244, 37.72581], [-121.87254, 37.72555], [-121.87256, 37.72525], [-121.87253, 37.72514], [-121.87225, 37.72474], [-121.87185, 37.72446], [-121.87183, 37.72431], [-121.87198, 37.72426], [-121.87199, 37.72424], [-121.87166, 37.72419], [-121.87168, 37.72391], [-121.87238, 37.72394], [-121.87288, 37.72369], [-121.87438, 37.72709], [-121.87473, 37.73143], [-121.88197, 37.73651]]]} | No Public Access 3 | Tassajara Creek Regional Park | 26194 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 24.53 | Tassajara Creek RP | 1971 | |
13749 | 13749 | 13748 | {"type": "Polygon", "coordinates": [[[-122.65381, 38.41605], [-122.6538, 38.41625], [-122.64751, 38.4163], [-122.64864, 38.4159], [-122.64852, 38.41328], [-122.64851, 38.41268], [-122.64841, 38.41182], [-122.65085, 38.41247], [-122.65115, 38.41257], [-122.65126, 38.41264], [-122.65151, 38.41287], [-122.65161, 38.41299], [-122.65187, 38.41345], [-122.65199, 38.4136], [-122.65215, 38.41375], [-122.65228, 38.41382], [-122.65039, 38.41376], [-122.65041, 38.41606], [-122.65381, 38.41605]]]} | No Public Access 3 | Keegan & Coppin | 31258 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 24.712 | Keegan & Coppin | 1997 | |
13747 | 13747 | 13746 | {"type": "MultiPolygon", "coordinates": [[[[-122.73292, 38.36331], [-122.7329, 38.36345], [-122.73137, 38.36624], [-122.73123, 38.36644], [-122.73112, 38.36655], [-122.73092, 38.3667], [-122.7306, 38.36684], [-122.73047, 38.36688], [-122.72932, 38.36712], [-122.72931, 38.36331], [-122.73292, 38.36331]]], [[[-122.73279, 38.3648], [-122.73263, 38.36594], [-122.73211, 38.36694], [-122.73176, 38.36739], [-122.73122, 38.36763], [-122.73104, 38.36765], [-122.73058, 38.36752], [-122.73046, 38.36736], [-122.73085, 38.36726], [-122.73121, 38.36709], [-122.73148, 38.36691], [-122.73165, 38.36676], [-122.73175, 38.36664], [-122.73189, 38.36645], [-122.73279, 38.3648]]]]} | No Public Access 3 | San Francisco Archdiocese | 31255 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 26.415 | San Francisco Archdiocese | 1994 | |
13750 | 13750 | 13749 | {"type": "Polygon", "coordinates": [[[-122.66687, 38.35235], [-122.6595, 38.35231], [-122.65959, 38.35068], [-122.66686, 38.35067], [-122.66687, 38.35235]]]} | No Public Access 3 | Ho | 31259 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 29.047 | Ho | 2001 | |
13308 | 13308 | 13307 | {"type": "Polygon", "coordinates": [[[-122.37378, 37.97697], [-122.36785, 37.97699], [-122.36769, 37.97694], [-122.37097, 37.97462], [-122.37103, 37.97476], [-122.37125, 37.97494], [-122.3714, 37.97493], [-122.37145, 37.97481], [-122.37156, 37.97472], [-122.37163, 37.97458], [-122.37164, 37.97447], [-122.37168, 37.9744], [-122.37168, 37.97427], [-122.37182, 37.97415], [-122.37179, 37.97404], [-122.37375, 37.97268], [-122.37378, 37.97697]]]} | No Public Access 3 | North Richmond Shoreline | 30624 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 31.198 | North Richmond Shoreline | ||
14706 | 14706 | 14705 | {"type": "MultiPolygon", "coordinates": [[[[-121.66883, 37.12359], [-121.66674, 37.12357], [-121.66651, 37.12332], [-121.66627, 37.12302], [-121.66597, 37.12252], [-121.66553, 37.12198], [-121.6661, 37.12198], [-121.66632, 37.12234], [-121.66625, 37.12238], [-121.66631, 37.12246], [-121.66637, 37.12244], [-121.66821, 37.12247], [-121.66883, 37.12359]]], [[[-121.67204, 37.11703], [-121.66846, 37.11719], [-121.6659, 37.11598], [-121.66581, 37.1145], [-121.67047, 37.11431], [-121.67204, 37.11703]]]]} | No Public Access 3 | El Toro Open Space Preserve | http://www.openspaceauthority.org | 18545 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 39.195 | El Toro OSP | 2010 |
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]);