units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
106 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, PARK_URL, COUNTY, GAP_STS
DES_TP 21
MNG_AGENCY 8
- East Bay Regional Park District 47
- Midpeninsula Regional Open Space District 19
- Santa Clara Valley Open Space Authority 18
- 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 · 106 ✖
ACCESS_TYP 1
- No Public Access · 106 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16415 | 16415 | 16414 | {"type": "Polygon", "coordinates": [[[-122.16888, 37.8072], [-122.16832, 37.80721], [-122.16831, 37.80673], [-122.16805, 37.80673], [-122.16806, 37.80645], [-122.16886, 37.8061], [-122.16888, 37.8072]]]} | No Public Access 3 | 46996 | Redwood Regional Park | 30634 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.525 | Redwood RP | 1939 | Local Park 2 | 4 | |
14182 | 14182 | 14181 | {"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 | 43103 | North Richmond Wetlands | 22856 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 1.61 | North Richmond Wetlands | 0 | Local Conservation Area 4 | 2 | |
13023 | 13023 | 13022 | {"type": "Polygon", "coordinates": [[[-122.1377, 37.6311], [-122.13721, 37.63171], [-122.13632, 37.63217], [-122.13453, 37.63218], [-122.1377, 37.6311]]]} | No Public Access 3 | 46960 | Hayward Regional Shoreline | 19761 | 1685 | Hayward, City of 1038 | City 2 | City Agency 2 | http://www.ci.hayward.ca.us/ | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/hayward | Alameda 17 | 2.662 | Hayward Reg. Shoreline | 1980 | Local Park 2 | 4 |
3558 | 3558 | 3557 | {"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 | 15364 | Brooks Island Regional Preserve | 31524 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 3.177 | Brooks Island RPr | 0 | Local Conservation Area 4 | 2 | |
9975 | 9975 | 9974 | {"type": "Polygon", "coordinates": [[[-122.11034, 37.25814], [-122.1099, 37.25831], [-122.10963, 37.25848], [-122.10956, 37.25855], [-122.10952, 37.25863], [-122.10951, 37.25873], [-122.10953, 37.25882], [-122.10846, 37.25883], [-122.10844, 37.25755], [-122.11032, 37.25756], [-122.11034, 37.25814]]]} | No Public Access 3 | 47967 | Saratoga Gap Open Space Preserve | 31468 | 373 | Santa Clara, County of 941 | County 3 | County Agency 3 | http://www.sccgov.org/sites/scc/Pages/default.aspx | County 3 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 4.827 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
11975 | 11975 | 11974 | {"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 | 35055 | Coal Creek Open Space Preserve | 31502 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_coal_creek.asp | San Mateo 15 | 5.246 | Coal Creek OSP | 0 | Local Conservation Area 4 | 2 |
6263 | 6263 | 6262 | {"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.78871, 36.52058], [-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 | 1348 | Thomas Open Space | 26308 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 5.313 | Thomas OS | 0 | Local Recreation Area 3 | 4 | |
13022 | 13022 | 13021 | {"type": "Polygon", "coordinates": [[[-122.14836, 37.627], [-122.14532, 37.62726], [-122.1389, 37.62727], [-122.13892, 37.62376], [-122.13918, 37.62376], [-122.13922, 37.627], [-122.14836, 37.627]]]} | No Public Access 3 | 46959 | Hayward Regional Shoreline | 19761 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/hayward | Alameda 17 | 7.307 | Hayward Reg. Shoreline | 1980 | Local Park 2 | 4 |
14532 | 14532 | 14531 | {"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 | 47776 | Santa Teresa Foothills Open Space Preserve | 31575 | 2142 | Santa Clara Valley Open Space Authority 475 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | http://www.openspaceauthority.org | Santa Clara 19 | 8.63 | Santa Teresa Foothills OSP | 2016 | Local Conservation Area 4 | 2 |
15888 | 15888 | 15887 | {"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.38543], [-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.25261, 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.26271, 37.38929], [-122.26274, 37.38943], [-122.26253, 37.38947], [-122.26249, 37.38934], [-122.26146, 37.38952], [-122.26043, 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.26099, 37.3876], [-122.26101, 37.38761], [-122.25987, 37.38932], [-122.26025, 37.38926], [-122.26044, 37.38916], [-122.26154, 37.38944], [-122.26316, 37.38911], [-122.26368, 37.38918]]]]} | No Public Access 3 | 47712 | Thornewood Open Space Preserve | 31492 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_thornewood.asp | San Mateo 15 | 9.424 | Thornewood OSP | 1986 | Local Conservation Area 4 | 2 |
13008 | 13008 | 13007 | {"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 | 46953 | MLK Regional Shoreline | 30577 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 14.008 | MLK Reg. Shoreline | 0 | Local Park 2 | 4 | |
12369 | 12369 | 12368 | {"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.82893, 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 | 26071 | Occidental Road Wetlands | 31262 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 15.729 | Occidental Road Wetlands | 2008 | Local Conservation Area 4 | 2 | |
16665 | 16665 | 16664 | {"type": "Polygon", "coordinates": [[[-122.0161, 37.83947], [-122.01592, 37.83969], [-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.01386, 37.83993], [-122.01417, 37.83899], [-122.0151, 37.83896], [-122.01558, 37.83916], [-122.0161, 37.83947]]]} | No Public Access 3 | 15340 | Las Trampas/Diablo Regional Trail | 21068 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 16.575 | Las Trampas/Diablo Reg. Trail | 0 | Local Recreation Area 3 | 4 | |
13126 | 13126 | 13125 | {"type": "Polygon", "coordinates": [[[-121.97561, 37.57073], [-121.97355, 37.57142], [-121.97349, 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.97251, 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 | 46965 | Quarry Lakes Regional Recreation Area | 30596 | 2000 | Alameda County Flood Control and Water Conservation District 771 | Special District 4 | Flood District 8 | http://acfloodcontrol.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 17.733 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
12993 | 12993 | 12992 | {"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.82154], [-122.3199, 37.8199], [-122.31924, 37.81945], [-122.31952, 37.81919], [-122.32164, 37.81919], [-122.32165, 37.82097], [-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.32528, 37.82085], [-122.32552, 37.82092], [-122.32566, 37.82091], [-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.82056], [-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 | 46946 | East Bay Gateway Shoreline | 30571 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 20.218 | East Bay Gateway Shoreline | 0 | Local Park 2 | 4 | |
6381 | 6381 | 6380 | {"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 | 47550 | Haroutunian - South | 31261 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 21.082 | Haroutunian - South | 1995 | None 518 | ||
9762 | 9762 | 9761 | {"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 | 47874 | Garaventa Wetlands Preserve | 31818 | 2062 | Livermore Area Recreation and Park District 394 | Special District 4 | Recreation/Parks District 4 | http://www.larpd.dst.ca.us/ | Special District 4 | 2062 | Livermore Area Recreation and Park District 388 | Special District 4 | Recreation/Parks District 4 | https://www.larpd.org/garaventa-wetlands | Alameda 17 | 21.405 | Garaventa Wetlands Preserve | 0 | Local Conservation Area 4 | 2 |
6296 | 6296 | 6295 | {"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.87199, 37.72425], [-121.872, 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 | 1411 | Tassajara Creek Regional Park | 26194 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 24.514 | Tassajara Creek RP | 1971 | Local Park 2 | 4 | |
6871 | 6871 | 6870 | {"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.41346], [-122.65199, 38.41361], [-122.65215, 38.41375], [-122.65228, 38.41382], [-122.65038, 38.41376], [-122.6504, 38.41606], [-122.65381, 38.41605]]]} | No Public Access 3 | 47545 | Keegan & Coppin | 31258 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 24.67 | Keegan & Coppin | 1997 | None 558 | ||
5528 | 5528 | 5527 | {"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.73061, 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 | 393 | San Francisco Archdiocese | 31255 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 26.417 | San Francisco Archdiocese | 1994 | None 448 |
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]);