units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
969 rows where ACCESS_TYP = 3 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 79
- East Bay Regional Park District 47
- Los Angeles, City of 36
- The Nature Conservancy 32
- Las Virgenes Municipal Water District 28
- Peninsula Open Space Trust 24
- Natomas Basin Conservancy 22
- Rivers and Lands Conservancy 22
- Torrance, City of 20
- Mountains Restoration Trust 20
- San Diego, City of 19
- Midpeninsula Regional Open Space District 19
- Santa Clara Valley Open Space Authority 18
- United States Fish and Wildlife Service 16
- Fresno Metropolitan Flood Control District 16
- California Department of Parks and Recreation 15
- Endangered Habitats Conservancy 14
- San Diego, County of 14
- Los Angeles County Flood Control District 13
- Kinneloa Irrigation District 13
- Santa Clara County Parks and Recreation Dept., County of 13
- American River Conservancy 13
- Save Mount Diablo 13
- Littlerock Creek Irrigation District 13
- Napa, City of 12
- Sonoma Land Trust 11
- Sonoma County Agricultural Preservation and Open Space District 11
- California Department of Water Resources 11
- California Department of General Services 10
- Escondido, City of 10
- …
DES_TP >30
- Private Conservation 195
- Local Recreation Area 113
- Local Other or Unknown 96
- Local Park 77
- Local Conservation Area 77
- State Resource Management Area 64
- Private Recreation or Education 25
- Private Other or Unknown 25
- State Conservation Area 22
- State Other or Unknown 19
- National Wildlife Refuge 14
- Local Resource Management Area 8
- State Park 5
- Private Agricultural 5
- Conservation Area 3
- Resource Management Area 3
- State Historic or Cultural Area 3
- National Public Lands 2
- National Monument or Landmark 2
- Federal Other or Unknown 2
- None 1
- None 1
- State Recreation Area 1
- Recreation Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 19
- City Agency 207
- Non Profit - Land Trust 202
- State Agency 136
- Recreation/Parks District 106
- Flood District 58
- Water District 56
- Non Profit - Conservation 49
- Federal Agency 31
- Irrigation District 29
- County Agency 26
- Open Space District 22
- County Agency - Parks 18
- County Agency - Other 3
- Home Owners Association 1
- Commercial 1
- Sanitation District 1
- Non Profit - Other 1
- Joint Powers Authority 1
- Other 1
ACCESS_TYP 1
- No Public Access · 949 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8181 | 8181 | 8180 | {"type": "Polygon", "coordinates": [[[-117.30491, 33.0932], [-117.30453, 33.09207], [-117.30484, 33.09153], [-117.30491, 33.09304], [-117.30491, 33.0932]]]} | No Public Access 3 | 12389 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 0.747 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8182 | 8182 | 8181 | {"type": "Polygon", "coordinates": [[[-117.22114, 33.1097], [-117.22113, 33.11125], [-117.21683, 33.11123], [-117.21682, 33.10968], [-117.22114, 33.1097]]]} | No Public Access 3 | 12396 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 17.099 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8183 | 8183 | 8182 | {"type": "Polygon", "coordinates": [[[-117.01448, 32.58373], [-117.01447, 32.58791], [-117.01414, 32.58782], [-117.01392, 32.58773], [-117.01354, 32.58752], [-117.01332, 32.58737], [-117.0132, 32.58726], [-117.01306, 32.5871], [-117.01298, 32.58697], [-117.01279, 32.58662], [-117.0127, 32.5865], [-117.0125, 32.58632], [-117.01219, 32.58617], [-117.01186, 32.5861], [-117.00764, 32.58606], [-117.00745, 32.58604], [-117.00722, 32.586], [-117.00705, 32.58594], [-117.00676, 32.5858], [-117.00648, 32.58561], [-117.00562, 32.58532], [-117.00752, 32.58336], [-117.01448, 32.58373]]]} | No Public Access 3 | 12398 | Robinhood Ridge | 24501 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 58.533 | Robinhood Ridge | 0 | Private Conservation 16 | 2 | ||
8184 | 8184 | 8183 | {"type": "Polygon", "coordinates": [[[-116.89139, 32.83481], [-116.89096, 32.83513], [-116.8907, 32.83504], [-116.89049, 32.83468], [-116.89006, 32.83463], [-116.88961, 32.8348], [-116.88948, 32.8348], [-116.88926, 32.83474], [-116.88904, 32.83445], [-116.88865, 32.83423], [-116.88889, 32.83406], [-116.88925, 32.83386], [-116.88981, 32.83345], [-116.88981, 32.83333], [-116.88976, 32.83318], [-116.8895, 32.83284], [-116.88914, 32.83251], [-116.88893, 32.83244], [-116.88873, 32.8324], [-116.88896, 32.83162], [-116.8896, 32.83155], [-116.89091, 32.83191], [-116.89059, 32.8325], [-116.8912, 32.83331], [-116.89086, 32.8336], [-116.89081, 32.83374], [-116.89109, 32.83382], [-116.89111, 32.83389], [-116.89115, 32.83392], [-116.89124, 32.83415], [-116.89095, 32.83426], [-116.89139, 32.83481]]]} | No Public Access 3 | 12400 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 14.229 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8235 | 8235 | 8234 | {"type": "Polygon", "coordinates": [[[-117.00398, 32.95858], [-117.00347, 32.95885], [-117.00267, 32.95902], [-117.00248, 32.9592], [-117.00238, 32.95921], [-117.00228, 32.95927], [-117.00224, 32.95935], [-117.00223, 32.95942], [-117.00187, 32.95949], [-117.00142, 32.95963], [-117.00107, 32.95966], [-117.0005, 32.9599], [-117.00031, 32.95999], [-117.00015, 32.96009], [-116.99999, 32.96022], [-116.99938, 32.96082], [-116.99922, 32.961], [-116.999, 32.96116], [-116.99869, 32.96076], [-116.9986, 32.96055], [-116.99857, 32.96041], [-116.99857, 32.96028], [-116.99889, 32.96032], [-116.99894, 32.96017], [-116.99903, 32.96003], [-116.99919, 32.9599], [-117.0004, 32.9591], [-117.00022, 32.95889], [-117.00036, 32.95882], [-117.00045, 32.9588], [-117.00053, 32.95908], [-117.00071, 32.95907], [-117.0009, 32.95908], [-117.00109, 32.95914], [-117.00158, 32.95908], [-117.00154, 32.9589], [-117.00171, 32.95887], [-117.00396, 32.95799], [-117.00398, 32.95858]]]} | No Public Access 3 | 12569 | Poway Creek Riparian Preserve | 23931 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 10.021 | Poway Creek Riparian Preserve | 0 | Private Conservation 16 | 2 | ||
8308 | 8308 | 8307 | {"type": "Polygon", "coordinates": [[[-117.33623, 33.21599], [-117.33279, 33.22069], [-117.33193, 33.22042], [-117.33199, 33.22009], [-117.33205, 33.21957], [-117.33208, 33.21908], [-117.33208, 33.2186], [-117.33211, 33.21826], [-117.33221, 33.21782], [-117.3323, 33.21756], [-117.33241, 33.2172], [-117.33249, 33.21674], [-117.33251, 33.21653], [-117.33255, 33.21549], [-117.33262, 33.21504], [-117.33268, 33.21475], [-117.33282, 33.2143], [-117.33327, 33.21307], [-117.33336, 33.21277], [-117.33342, 33.21248], [-117.33471, 33.21244], [-117.33623, 33.21599]]]} | No Public Access 3 | 12737 | Vista de la Valle - Land Preserve/Mitigation Area | 27166 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 50.738 | Vista de la Valle - Land Preserve/Mitigation Area | 0 | Private Conservation 16 | 2 | ||
9848 | 9848 | 9847 | {"type": "Polygon", "coordinates": [[[-119.62642, 36.59749], [-119.62573, 36.5975], [-119.62574, 36.5981], [-119.62256, 36.59811], [-119.62256, 36.59635], [-119.62389, 36.59572], [-119.62388, 36.59489], [-119.6232, 36.59416], [-119.62192, 36.59418], [-119.62191, 36.59289], [-119.62419, 36.59288], [-119.6242, 36.59467], [-119.62497, 36.59528], [-119.62541, 36.59616], [-119.62639, 36.59616], [-119.62642, 36.59749]]]} | No Public Access 3 | 16838 | Young Pond Federal Wetlands/Selma Pres | 27789 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Fresno 9 | 29.786 | Young Pond Federal Wetlands/Selma Pres | 0 | Federal Other or Unknown 87 | 4 | ||
11425 | 11425 | 11424 | {"type": "MultiPolygon", "coordinates": [[[[-121.3675, 38.67299], [-121.36388, 38.67606], [-121.36391, 38.67519], [-121.36103, 38.6752], [-121.36093, 38.67293], [-121.3675, 38.67299]]], [[[-121.38686, 38.71035], [-121.38621, 38.71061], [-121.38139, 38.71218], [-121.3813, 38.71244], [-121.38071, 38.71244], [-121.38078, 38.71216], [-121.38077, 38.71215], [-121.37652, 38.71218], [-121.37402, 38.71051], [-121.37491, 38.70982], [-121.37505, 38.70977], [-121.37599, 38.70985], [-121.37658, 38.71005], [-121.37976, 38.71], [-121.38052, 38.71011], [-121.38227, 38.71018], [-121.38356, 38.71001], [-121.38466, 38.70975], [-121.38501, 38.70956], [-121.38548, 38.70963], [-121.38581, 38.70997], [-121.38634, 38.71026], [-121.38686, 38.71035]]]]} | No Public Access 3 | 22268 | Other Federal | 23247 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Sacramento 41 | 79.009 | Other Federal | 0 | Federal Other or Unknown 87 | 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 | |
10341 | 10341 | 10340 | {"type": "Polygon", "coordinates": [[[-121.80063, 36.71388], [-121.80041, 36.71423], [-121.7996, 36.71582], [-121.79919, 36.71731], [-121.79904, 36.71798], [-121.7999, 36.72298], [-121.79929, 36.72379], [-121.79896, 36.72387], [-121.79857, 36.72412], [-121.7987, 36.72467], [-121.79841, 36.72503], [-121.78914, 36.72115], [-121.78929, 36.72074], [-121.78951, 36.72025], [-121.78977, 36.71978], [-121.79008, 36.71932], [-121.79048, 36.71881], [-121.79226, 36.7168], [-121.79248, 36.71652], [-121.79262, 36.71625], [-121.79275, 36.7159], [-121.7928, 36.71561], [-121.7928, 36.71522], [-121.79283, 36.71498], [-121.79292, 36.71464], [-121.79304, 36.71435], [-121.79323, 36.71404], [-121.7935, 36.7137], [-121.79382, 36.71339], [-121.79419, 36.71313], [-121.79445, 36.71299], [-121.79473, 36.71286], [-121.79768, 36.71187], [-121.79791, 36.71182], [-121.79815, 36.71178], [-121.79842, 36.71177], [-121.79863, 36.71178], [-121.79889, 36.71183], [-121.79883, 36.712], [-121.79968, 36.71227], [-121.79995, 36.71261], [-121.80063, 36.71388]]]} | No Public Access 3 | 18242 | Ocean Mist Farm | 23054 | 3042 | Ag Land Trust 947 | Non Profit 6 | Non Profit - Land Trust 10 | http://aglandtrust.org/ | Non Governmental Organization 10 | 3042 | Ag Land Trust 919 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 222.013 | Ocean Mist Farm | 0 | Private Agricultural 354 | 4 | |
13712 | 13712 | 13711 | {"type": "MultiPolygon", "coordinates": [[[[-122.48737, 37.88444], [-122.48632, 37.88604], [-122.48237, 37.8846], [-122.4814, 37.88629], [-122.48068, 37.88606], [-122.48029, 37.8859], [-122.47745, 37.88485], [-122.47846, 37.88316], [-122.48122, 37.88414], [-122.48237, 37.8846], [-122.48336, 37.88288], [-122.48737, 37.88444]]], [[[-122.49343, 37.89369], [-122.49298, 37.89377], [-122.4913, 37.8926], [-122.49158, 37.89214], [-122.49343, 37.89369]]], [[[-122.49394, 37.89369], [-122.49366, 37.89367], [-122.49167, 37.89196], [-122.49188, 37.89166], [-122.49394, 37.89369]]], [[[-122.49543, 37.89412], [-122.49528, 37.89413], [-122.49512, 37.89406], [-122.49512, 37.89403], [-122.4923, 37.89097], [-122.49261, 37.8905], [-122.49521, 37.89278], [-122.49543, 37.89412]]], [[[-122.50011, 37.89408], [-122.49954, 37.89424], [-122.49911, 37.89369], [-122.49821, 37.89349], [-122.49747, 37.89359], [-122.49673, 37.89397], [-122.49647, 37.89479], [-122.49642, 37.89482], [-122.49621, 37.89467], [-122.49602, 37.89457], [-122.49617, 37.89406], [-122.49571, 37.89409], [-122.49547, 37.8927], [-122.49273, 37.8903], [-122.4931, 37.88965], [-122.49453, 37.88741], [-122.4975, 37.88853], [-122.49781, 37.88802], [-122.50011, 37.89408]]], [[[-122.50928, 37.87681], [-122.50822, 37.87751], [-122.50769, 37.87701], [-122.50875, 37.8763], [-122.50928, 37.87681]]], [[[-122.50932, 37.87892], [-122.50833, 37.87959], [-122.50816, 37.87951], [-122.50775, 37.87912], [-122.50879, 37.87841], [-122.50932, 37.87892]]]]} | No Public Access 3 | 36120 | Richardson Bay Audubon Center & Sanctuary | 24329 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 123.778 | Richardson Bay Audubon Ctr. & Sanctuary | 0 | Private Conservation 16 | 2 | |
15947 | 15947 | 15946 | {"type": "Polygon", "coordinates": [[[-122.49954, 37.89424], [-122.49884, 37.89498], [-122.49752, 37.89514], [-122.49729, 37.89525], [-122.49639, 37.89483], [-122.49647, 37.89479], [-122.49673, 37.89397], [-122.49747, 37.89359], [-122.49821, 37.89349], [-122.49911, 37.89369], [-122.49954, 37.89424]]]} | No Public Access 3 | 5202 | Audubon Society Lyford House Open Space Area | 15705 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 9.091 | Audubon Society Lyford House OS Area | 0 | Private Conservation 16 | 2 | |
723 | 723 | 722 | {"type": "Polygon", "coordinates": [[[-122.8297, 38.43042], [-122.82526, 38.43042], [-122.82525, 38.42579], [-122.8253, 38.42547], [-122.82624, 38.42547], [-122.82716, 38.42577], [-122.82941, 38.42635], [-122.82931, 38.42976], [-122.82941, 38.43012], [-122.8297, 38.43042]]]} | No Public Access 3 | 4499 | Stone Farm | 25869 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 45.409 | Stone Farm | None 67 | |||
3463 | 3463 | 3462 | {"type": "Polygon", "coordinates": [[[-122.81258, 38.40688], [-122.81095, 38.40685], [-122.81097, 38.4091], [-122.81254, 38.40914], [-122.81254, 38.4196], [-122.81121, 38.4196], [-122.81123, 38.42122], [-122.81049, 38.42124], [-122.81052, 38.42267], [-122.80968, 38.42267], [-122.80969, 38.42059], [-122.80968, 38.42058], [-122.80889, 38.42059], [-122.80889, 38.42267], [-122.80642, 38.42269], [-122.80108, 38.42268], [-122.79501, 38.42272], [-122.79499, 38.41973], [-122.80359, 38.4197], [-122.80349, 38.41056], [-122.80349, 38.4086], [-122.80676, 38.40743], [-122.80677, 38.40815], [-122.80678, 38.40816], [-122.80709, 38.40804], [-122.80708, 38.40732], [-122.80753, 38.40716], [-122.80755, 38.40779], [-122.80756, 38.4078], [-122.80855, 38.40771], [-122.81023, 38.40712], [-122.81024, 38.4062], [-122.81245, 38.40541], [-122.81259, 38.40564], [-122.81258, 38.40688]]]} | No Public Access 3 | 25346 | Kelly Farm | 20586 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 368.971 | Kelly Farm | None 288 | |||
3550 | 3550 | 3549 | {"type": "Polygon", "coordinates": [[[-122.79598, 38.68638], [-122.79593, 38.68645], [-122.79587, 38.68663], [-122.79584, 38.68702], [-122.79582, 38.68712], [-122.79577, 38.68724], [-122.79549, 38.68779], [-122.79545, 38.68786], [-122.79501, 38.68816], [-122.79483, 38.68832], [-122.79478, 38.68849], [-122.79478, 38.68903], [-122.79483, 38.68923], [-122.79486, 38.68944], [-122.79482, 38.68962], [-122.79478, 38.68969], [-122.79471, 38.68978], [-122.79457, 38.68984], [-122.79425, 38.68987], [-122.79372, 38.68983], [-122.79362, 38.68984], [-122.79311, 38.68994], [-122.79276, 38.69005], [-122.79265, 38.69012], [-122.79244, 38.6902], [-122.79194, 38.69034], [-122.79182, 38.69038], [-122.79175, 38.69043], [-122.79171, 38.6905], [-122.79168, 38.69063], [-122.79137, 38.69088], [-122.79073, 38.69135], [-122.79069, 38.69141], [-122.79067, 38.69148], [-122.7907, 38.6916], [-122.79102, 38.69195], [-122.79109, 38.69208], [-122.79115, 38.69228], [-122.79115, 38.69241], [-122.79113, 38.69252], [-122.79101, 38.69282], [-122.79094, 38.6929], [-122.79085, 38.69297], [-122.79052, 38.69312], [-122.79023, 38.69322], [-122.79012, 38.69328], [-122.78934, 38.69224], [-122.78925, 38.6893], [-122.78809, 38.68905], [-122.7847, 38.68871], [-122.78467, 38.68598], [-122.79598, 38.68638]]]} | No Public Access 3 | 28288 | Bear Canyon | 15921 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 98.229 | Bear Canyon | 0 | Local Recreation Area 3 | 4 | |
5297 | 5297 | 5296 | {"type": "Polygon", "coordinates": [[[-122.82593, 38.43055], [-122.82443, 38.43055], [-122.82444, 38.42965], [-122.82498, 38.42959], [-122.82517, 38.42953], [-122.82526, 38.42956], [-122.82526, 38.43042], [-122.82593, 38.43042], [-122.82593, 38.43055]]]} | No Public Access 3 | 4510 | Stone Farm | 25869 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 2.101 | Stone Farm | None 427 | |||
6589 | 6589 | 6588 | {"type": "Polygon", "coordinates": [[[-122.82826, 38.42594], [-122.82824, 38.42604], [-122.82716, 38.42577], [-122.82624, 38.42547], [-122.8253, 38.42548], [-122.82525, 38.42579], [-122.82526, 38.42923], [-122.82514, 38.42923], [-122.8249, 38.42929], [-122.82445, 38.42934], [-122.82442, 38.42666], [-122.82442, 38.42578], [-122.82445, 38.42544], [-122.82216, 38.42482], [-122.82049, 38.42439], [-122.8205, 38.42385], [-122.82826, 38.42594]]]} | No Public Access 3 | 4475 | Stone Farm | 25869 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 14.35 | Stone Farm | None 530 | |||
6593 | 6593 | 6592 | {"type": "Polygon", "coordinates": [[[-122.82446, 38.42544], [-122.82442, 38.42578], [-122.82442, 38.42666], [-122.82445, 38.42934], [-122.8235, 38.42949], [-122.82314, 38.42952], [-122.82295, 38.42956], [-122.82253, 38.42973], [-122.82216, 38.43], [-122.82202, 38.43006], [-122.82193, 38.43014], [-122.82177, 38.43018], [-122.82162, 38.43024], [-122.82125, 38.43031], [-122.82113, 38.43037], [-122.82108, 38.43037], [-122.82099, 38.43033], [-122.82089, 38.43032], [-122.82052, 38.43008], [-122.82053, 38.42921], [-122.82048, 38.4251], [-122.82049, 38.42439], [-122.82216, 38.42482], [-122.82446, 38.42544]]]} | No Public Access 3 | 4022 | Stone Farm | 25869 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 46.388 | Stone Farm | None 531 | |||
6597 | 6597 | 6596 | {"type": "MultiPolygon", "coordinates": [[[[-122.81587, 38.40123], [-122.81272, 38.40264], [-122.81266, 38.4026], [-122.81259, 38.40252], [-122.81251, 38.40232], [-122.8125, 38.40212], [-122.81253, 38.40196], [-122.81251, 38.40187], [-122.81245, 38.40185], [-122.81236, 38.40191], [-122.81224, 38.40206], [-122.81216, 38.4022], [-122.81215, 38.40227], [-122.8122, 38.40247], [-122.81207, 38.40279], [-122.81206, 38.40286], [-122.8121, 38.40292], [-122.80774, 38.40488], [-122.80551, 38.40586], [-122.80424, 38.40644], [-122.80102, 38.40784], [-122.8008, 38.40792], [-122.80001, 38.40832], [-122.79906, 38.40885], [-122.79838, 38.40919], [-122.79601, 38.41007], [-122.79446, 38.41071], [-122.79431, 38.4105], [-122.7948, 38.41031], [-122.79481, 38.4103], [-122.79469, 38.41013], [-122.79451, 38.41029], [-122.79424, 38.4104], [-122.79317, 38.40885], [-122.79019, 38.40445], [-122.79012, 38.40432], [-122.78868, 38.40221], [-122.7934, 38.40115], [-122.81277, 38.39668], [-122.81331, 38.39672], [-122.81342, 38.39753], [-122.81363, 38.39754], [-122.81382, 38.39773], [-122.81484, 38.39865], [-122.81524, 38.39907], [-122.8155, 38.39927], [-122.8156, 38.39953], [-122.81568, 38.40008], [-122.81565, 38.40089], [-122.81569, 38.40107], [-122.81573, 38.40118], [-122.81584, 38.40118], [-122.81587, 38.40123]], [[-122.79167, 38.40561], [-122.7905, 38.40387], [-122.79017, 38.40335], [-122.79015, 38.40335], [-122.79016, 38.40341], [-122.79022, 38.40352], [-122.79161, 38.40558], [-122.79166, 38.40564], [-122.79167, 38.40561]], [[-122.79449, 38.40986], [-122.7939, 38.40892], [-122.79355, 38.40842], [-122.7932, 38.40791], [-122.79289, 38.40741], [-122.79257, 38.40696], [-122.79309, 38.40795], [-122.79429, 38.41005], [-122.7943, 38.41005], [-122.79449, 38.40986]]], [[[-122.81641, 38.40121], [-122.81554, 38.4016], [-122.81554, 38.40315], [-122.81577, 38.40353], [-122.8131, 38.40439], [-122.80605, 38.40685], [-122.79987, 38.40907], [-122.79972, 38.40883], [-122.80116, 38.40807], [-122.80147, 38.40794], [-122.80163, 38.40819], [-122.80555, 38.4068], [-122.80919, 38.40545], [-122.81179, 38.40453], [-122.81179, 38.40451], [-122.81153, 38.40448], [-122.81074, 38.40427], [-122.81033, 38.40411], [-122.81012, 38.40399], [-122.81108, 38.40358], [-122.81322, 38.40262], [-122.81613, 38.40122], [-122.81641, 38.40121]]]]} | No Public Access 3 | 4034 | Brown Farm | 16443 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 468.322 | Brown Farm | None 532 | |||
6615 | 6615 | 6614 | {"type": "MultiPolygon", "coordinates": [[[[-122.77242, 38.38856], [-122.77237, 38.38856], [-122.77228, 38.38852], [-122.77236, 38.38852], [-122.77242, 38.38856]]], [[[-122.78653, 38.39443], [-122.78225, 38.39597], [-122.77744, 38.39197], [-122.77726, 38.39206], [-122.77695, 38.39211], [-122.77686, 38.39216], [-122.77651, 38.39193], [-122.77658, 38.39187], [-122.77677, 38.39178], [-122.77708, 38.3917], [-122.77709, 38.39169], [-122.77328, 38.38856], [-122.77867, 38.38851], [-122.77897, 38.38833], [-122.77912, 38.38832], [-122.77993, 38.38786], [-122.78653, 38.39443]]], [[[-122.79813, 38.3852], [-122.79796, 38.38596], [-122.7971, 38.38672], [-122.79711, 38.38673], [-122.79756, 38.38673], [-122.79756, 38.38825], [-122.79762, 38.38827], [-122.79761, 38.38881], [-122.7974, 38.38973], [-122.79746, 38.39027], [-122.79521, 38.39118], [-122.79444, 38.39148], [-122.78668, 38.39437], [-122.78491, 38.39263], [-122.78087, 38.38859], [-122.78007, 38.38777], [-122.7815, 38.38698], [-122.78783, 38.38684], [-122.78778, 38.38578], [-122.78764, 38.38578], [-122.78757, 38.38314], [-122.79463, 38.38229], [-122.79484, 38.38244], [-122.79564, 38.38276], [-122.79618, 38.38313], [-122.79632, 38.38369], [-122.79703, 38.38415], [-122.79707, 38.38419], [-122.79708, 38.38423], [-122.79813, 38.3852]]]]} | No Public Access 3 | 4205 | Alpha Farm | 15405 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 410.901 | Alpha Farm | None 534 |
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]);