units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
207 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 28
- Torrance, City of 20
- San Diego, City of 18
- Napa, City of 12
- Santa Rosa, City of 8
- Rocklin, City of 8
- Vallejo, City of 7
- Escondido, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Saint Helena, City of 5
- Vacaville, City of 4
- San Marcos, City of 4
- Petaluma, City of 3
- Long Beach, City of 3
- Chico, City of 3
- Roseville, City of 3
- Poway, City of 2
- Rancho Palos Verdes, City of 2
- Rolling Hills, City of 2
- Palos Verdes Estates, City of 2
- La Verne, City of 2
- Redding, City of 2
- Arcata, City of 2
- Sebastopol, City of 2
- Watsonville, City of 1
- Santee, City of 1
- Oceanside, City of 1
- Chula Vista, City of 1
- Rosemead, City of 1
- Davis, City of 1
- …
DES_TP >30
- Local Other or Unknown 51
- Local Recreation Area 38
- Local Park 32
- Local Conservation Area 5
- Local Resource Management Area 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
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 1
- City Agency · 187 ✖
ACCESS_TYP 1
- No Public Access · 187 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1709 | 1709 | 1708 | {"type": "Polygon", "coordinates": [[[-117.75671, 34.13628], [-117.7567, 34.1363], [-117.75036, 34.13633], [-117.75034, 34.13665], [-117.75035, 34.13666], [-117.75656, 34.13663], [-117.75559, 34.13883], [-117.75547, 34.13901], [-117.75533, 34.13918], [-117.75515, 34.13932], [-117.75367, 34.14035], [-117.75356, 34.14041], [-117.75326, 34.14053], [-117.75215, 34.14084], [-117.75214, 34.14092], [-117.75193, 34.14107], [-117.75169, 34.1413], [-117.75165, 34.14129], [-117.75133, 34.14113], [-117.75127, 34.14107], [-117.75121, 34.14102], [-117.7511, 34.141], [-117.7511, 34.14067], [-117.75024, 34.14008], [-117.75024, 34.13986], [-117.74992, 34.13986], [-117.74843, 34.13883], [-117.74818, 34.13785], [-117.7485, 34.13662], [-117.75064, 34.13454], [-117.75064, 34.13451], [-117.75208, 34.13314], [-117.75433, 34.13264], [-117.75616, 34.13503], [-117.75671, 34.13628]]]} | No Public Access 3 | 12846 | Live Oak Reservoir | 21375 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 112.516 | Live Oak Reservoir | 0 | Local Recreation Area 3 | 4 | |
2283 | 2283 | 2282 | {"type": "Polygon", "coordinates": [[[-121.96736, 38.30157], [-121.96735, 38.30183], [-121.96664, 38.30199], [-121.96611, 38.30257], [-121.96381, 38.307], [-121.96352, 38.30736], [-121.96535, 38.3109], [-121.96492, 38.31134], [-121.96492, 38.31136], [-121.96449, 38.31183], [-121.96352, 38.31397], [-121.96367, 38.31471], [-121.96344, 38.31549], [-121.96158, 38.31549], [-121.95215, 38.31541], [-121.95186, 38.31079], [-121.95186, 38.31055], [-121.95185, 38.31054], [-121.95137, 38.30158], [-121.96736, 38.30157]]]} | No Public Access 3 | 18229 | Noonan Reservoir | 22785 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 428.883 | Noonan Reservoir | 0 | Local Recreation Area 3 | 4 | |
2461 | 2461 | 2460 | {"type": "Polygon", "coordinates": [[[-118.34315, 34.12036], [-118.34289, 34.12054], [-118.34274, 34.1204], [-118.34265, 34.12036], [-118.34296, 34.12013], [-118.34315, 34.12036]]]} | No Public Access 3 | 12465 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.255 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
2462 | 2462 | 2461 | {"type": "Polygon", "coordinates": [[[-118.35722, 34.10552], [-118.35702, 34.10564], [-118.35703, 34.10532], [-118.35722, 34.10533], [-118.35722, 34.10552]]]} | No Public Access 3 | 12466 | Los Angeles Department of Water and Power | 21482 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.129 | Los Angeles Department of Water and Power | 0 | Local Other or Unknown 14 | 4 | |
2803 | 2803 | 2802 | {"type": "Polygon", "coordinates": [[[-118.37097, 34.13187], [-118.37053, 34.13214], [-118.36993, 34.13183], [-118.37013, 34.13145], [-118.37097, 34.13187]]]} | No Public Access 3 | 12817 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.89 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
3230 | 3230 | 3229 | {"type": "Polygon", "coordinates": [[[-121.43883, 39.01188], [-121.4381, 39.01215], [-121.43774, 39.01233], [-121.43643, 39.01284], [-121.43618, 39.01223], [-121.4364, 39.01219], [-121.43736, 39.01183], [-121.43754, 39.01172], [-121.43786, 39.01164], [-121.43846, 39.01129], [-121.43883, 39.01188]]]} | No Public Access 3 | 22281 | City of Wheatland Open Space | 17335 | 1379 | Wheatland, City of 569 | City 2 | City Agency 2 | http://www.wheatland.ca.gov/ | City 2 | 1379 | Wheatland, City of 561 | City 2 | City Agency 2 | Yuba 25 | 3.704 | City of Wheatland OS | 0 | Local Recreation Area 3 | 4 | |
3303 | 3303 | 3302 | {"type": "MultiPolygon", "coordinates": [[[[-121.29299, 38.78675], [-121.29281, 38.78695], [-121.29151, 38.78601], [-121.29153, 38.7857], [-121.29165, 38.78561], [-121.29166, 38.78556], [-121.29165, 38.78546], [-121.29178, 38.78527], [-121.29243, 38.78543], [-121.29257, 38.78589], [-121.29299, 38.78675]]], [[[-121.32257, 38.76796], [-121.32255, 38.76799], [-121.32252, 38.76801], [-121.32191, 38.76817], [-121.32101, 38.76854], [-121.32076, 38.76804], [-121.32034, 38.76803], [-121.32019, 38.76737], [-121.32083, 38.76704], [-121.32074, 38.76639], [-121.31577, 38.76639], [-121.31578, 38.76596], [-121.31577, 38.76578], [-121.31572, 38.76558], [-121.31564, 38.76537], [-121.31596, 38.76536], [-121.31607, 38.76549], [-121.31619, 38.76559], [-121.31638, 38.76567], [-121.31656, 38.76571], [-121.3173, 38.76572], [-121.31743, 38.76571], [-121.31756, 38.76568], [-121.31769, 38.76562], [-121.31793, 38.76545], [-121.31798, 38.76544], [-121.31832, 38.7656], [-121.3186, 38.76569], [-121.31891, 38.76575], [-121.31922, 38.76576], [-121.31959, 38.76571], [-121.3198, 38.76566], [-121.31999, 38.76559], [-121.32028, 38.76544], [-121.32042, 38.76534], [-121.32056, 38.76522], [-121.32175, 38.76518], [-121.32181, 38.76503], [-121.32197, 38.76507], [-121.322, 38.76509], [-121.32201, 38.76513], [-121.32185, 38.76559], [-121.32182, 38.76576], [-121.32181, 38.76597], [-121.32183, 38.76617], [-121.3219, 38.76638], [-121.32224, 38.76714], [-121.32257, 38.76796]]]]} | No Public Access 3 | 29576 | Proposed Park | 24017 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 23.324 | Proposed Park | 0 | Local Park 2 | 4 | |
3421 | 3421 | 3420 | {"type": "Polygon", "coordinates": [[[-116.96658, 32.84974], [-116.96647, 32.85215], [-116.96564, 32.85215], [-116.965, 32.85221], [-116.96414, 32.85224], [-116.96351, 32.8521], [-116.96347, 32.85208], [-116.96345, 32.85204], [-116.96339, 32.85204], [-116.9634, 32.85153], [-116.96338, 32.85152], [-116.9634, 32.85046], [-116.96343, 32.85045], [-116.96343, 32.84995], [-116.96658, 32.84974]]]} | No Public Access 3 | 25131 | Radio Towers Park | 24070 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | San Diego 4 | 18.699 | Radio Towers Park | 0 | Local Park 2 | 4 | |
3455 | 3455 | 3454 | {"type": "Polygon", "coordinates": [[[-118.37003, 33.80894], [-118.36954, 33.8099], [-118.36765, 33.8085], [-118.36743, 33.8087], [-118.36706, 33.80844], [-118.36605, 33.80806], [-118.36594, 33.808], [-118.36527, 33.8074], [-118.36503, 33.80742], [-118.36472, 33.80731], [-118.36486, 33.80704], [-118.36484, 33.80699], [-118.36492, 33.80694], [-118.36495, 33.80685], [-118.36494, 33.8068], [-118.36491, 33.80676], [-118.36471, 33.80663], [-118.36482, 33.80641], [-118.36514, 33.80657], [-118.36525, 33.80649], [-118.3653, 33.80593], [-118.36552, 33.8061], [-118.3655, 33.80627], [-118.36542, 33.80635], [-118.3654, 33.80639], [-118.3654, 33.80644], [-118.36542, 33.80648], [-118.36546, 33.80652], [-118.36553, 33.80654], [-118.3656, 33.80653], [-118.36565, 33.8065], [-118.36617, 33.8068], [-118.36613, 33.80682], [-118.36614, 33.80686], [-118.36596, 33.80689], [-118.36595, 33.8069], [-118.36646, 33.80748], [-118.3679, 33.80801], [-118.37003, 33.80894]]]} | No Public Access 3 | 35563 | Slope-Via Corona | 29195 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 11.822 | Slope-Via Corona | None 285 | |||
3456 | 3456 | 3455 | {"type": "Polygon", "coordinates": [[[-118.35732, 33.82927], [-118.35581, 33.8299], [-118.35559, 33.82945], [-118.35543, 33.82904], [-118.35529, 33.82863], [-118.35518, 33.8282], [-118.35509, 33.82777], [-118.35503, 33.82734], [-118.35501, 33.82703], [-118.35669, 33.82717], [-118.3568, 33.82782], [-118.35691, 33.82827], [-118.35706, 33.8287], [-118.35732, 33.82927]]]} | No Public Access 3 | 35566 | Ocean Sump | 29194 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 10.918 | Ocean Sump | None 286 | |||
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 | |||
3510 | 3510 | 3509 | {"type": "MultiPolygon", "coordinates": [[[[-121.78161, 39.72637], [-121.78124, 39.72908], [-121.78095, 39.72944], [-121.77958, 39.73019], [-121.77886, 39.73026], [-121.7783, 39.73042], [-121.77734, 39.73084], [-121.77495, 39.73206], [-121.77415, 39.73245], [-121.77329, 39.73252], [-121.77304, 39.73265], [-121.77312, 39.73282], [-121.77304, 39.73284], [-121.77297, 39.73287], [-121.77293, 39.73291], [-121.77291, 39.73297], [-121.7729, 39.73303], [-121.77293, 39.73308], [-121.77301, 39.73315], [-121.77315, 39.73318], [-121.77326, 39.73314], [-121.77339, 39.73343], [-121.7736, 39.73343], [-121.77384, 39.73346], [-121.77439, 39.73344], [-121.77519, 39.73338], [-121.77563, 39.73339], [-121.77572, 39.73312], [-121.77574, 39.73313], [-121.77576, 39.73313], [-121.77568, 39.73339], [-121.77597, 39.73347], [-121.77615, 39.73359], [-121.77277, 39.73358], [-121.77267, 39.73322], [-121.77255, 39.73291], [-121.77223, 39.73245], [-121.77333, 39.73215], [-121.77333, 39.73185], [-121.77386, 39.73195], [-121.77824, 39.72982], [-121.78013, 39.72956], [-121.78059, 39.72903], [-121.78081, 39.72844], [-121.78083, 39.72832], [-121.78077, 39.72831], [-121.78101, 39.72638], [-121.78104, 39.72637], [-121.78161, 39.72637]]], [[[-121.78736, 39.73304], [-121.78736, 39.73319], [-121.7862, 39.73271], [-121.78541, 39.73254], [-121.78513, 39.73263], [-121.78484, 39.73277], [-121.78393, 39.73285], [-121.78295, 39.73318], [-121.78266, 39.7336], [-121.78182, 39.73344], [-121.78103, 39.7336], [-121.78081, 39.7336], [-121.77994, 39.73343], [-121.77962, 39.73344], [-121.77923, 39.73343], [-121.77799, 39.7336], [-121.7774, 39.73359], [-121.77847, 39.73339], [-121.77955, 39.73325], [-121.78068, 39.73313], [-121.78108, 39.73314], [-121.78132, 39.73307], [-121.78169, 39.73291], [-121.78199, 39.73281], [-121.78247, 39.7326], [-121.78275, 39.73256], [-121.78313, 39.73254], [-121.78355, 39.73267], [-121.78447, 39.7326], [-121.78498, 39.73224], [-121.78563, 39.73232], [-121.78736, 39.73304]]], [[[-121.78224, 39.71945], [-121.78215, 39.71953], [-121.78193, 39.71983], [-121.78087, 39.72046], [-121.78081, 39.72123], [-121.78056, 39.72168], [-121.78025, 39.72312], [-121.78063, 39.72367], [-121.78149, 39.72426], [-121.78203, 39.72491], [-121.78188, 39.72619], [-121.78173, 39.72619], [-121.78184, 39.72515], [-121.78184, 39.72493], [-121.78133, 39.72431], [-121.78046, 39.72373], [-121.78009, 39.72314], [-121.78042, 39.72169], [-121.78066, 39.72115], [-121.78067, 39.72033], [-121.78176, 39.71972], [-121.78205, 39.7194], [-121.78219, 39.71901], [-121.78272, 39.71765], [-121.783, 39.7164], [-121.78302, 39.71563], [-121.78293, 39.7151], [-121.78267, 39.71455], [-121.78206, 39.71397], [-121.78173, 39.7136], [-121.78159, 39.71334], [-121.78185, 39.71331], [-121.78217, 39.71379], [-121.78288, 39.71447], [-121.78322, 39.71528], [-121.78317, 39.71644], [-121.78296, 39.71758], [-121.78224, 39.71945]]], [[[-121.80207, 39.73793], [-121.80155, 39.73764], [-121.80128, 39.73763], [-121.8006, 39.73774], [-121.80015, 39.73765], [-121.79978, 39.73742], [-121.79941, 39.73712], [-121.799, 39.73687], [-121.79864, 39.73672], [-121.79754, 39.73615], [-121.79614, 39.73575], [-121.79531, 39.7354], [-121.79471, 39.73511], [-121.79412, 39.735], [-121.79345, 39.7349], [-121.79306, 39.73486], [-121.79126, 39.73534], [-121.79034, 39.73528], [-121.78996, 39.73523], [-121.78867, 39.73473], [-121.78805, 39.73434], [-121.78774, 39.73394], [-121.78765, 39.73388], [-121.78762, 39.73306], [-121.78786, 39.73306], [-121.78813, 39.73315], [-121.78894, 39.73377], [-121.78988, 39.73417], [-121.79068, 39.73418], [-121.79123, 39.73429], [-121.79242, 39.73409], [-121.79292, 39.73382], [-121.79458, 39.73395], [-121.79552, 39.73457], [-121.7962, 39.73487], [-121.79679, 39.73492], [-121.7968, 39.73564], [-121.79765, 39.73586], [-121.79878, 39.73646], [-121.79914, 39.73661], [-121.80022, 39.73739], [-121.80158, 39.73746], [-121.80206, 39.73759], [-121.80207, 39.73793]]], [[[-121.80439, 39.738], [-121.80305, 39.73832], [-121.80232, 39.73773], [-121.80299, 39.73778], [-121.80337, 39.73778], [-121.80378, 39.73771], [-121.80428, 39.73755], [-121.80434, 39.73768], [-121.80439, 39.73783], [-121.80442, 39.73796], [-121.80439, 39.738]]], [[[-121.8164, 39.73456], [-121.81601, 39.73464], [-121.81572, 39.73473], [-121.8153, 39.73492], [-121.81536, 39.73532], [-121.81442, 39.73569], [-121.81138, 39.73653], [-121.80885, 39.73673], [-121.80752, 39.73716], [-121.8075, 39.73707], [-121.8071, 39.73705], [-121.80659, 39.73694], [-121.80644, 39.73692], [-121.80612, 39.73698], [-121.80498, 39.73732], [-121.80504, 39.73758], [-121.80486, 39.73781], [-121.80485, 39.73789], [-121.80481, 39.7379], [-121.80476, 39.73786], [-121.80466, 39.73757], [-121.80452, 39.73731], [-121.8044, 39.73716], [-121.80408, 39.73682], [-121.80452, 39.73683], [-121.80479, 39.73671], [-121.80558, 39.73651], [-121.80642, 39.73637], [-121.80671, 39.73642], [-121.80739, 39.73634], [-121.80738, 39.73622], [-121.80809, 39.73615], [-121.80896, 39.73598], [-121.80912, 39.73598], [-121.80912, 39.73616], [-121.8091, 39.73634], [-121.81016, 39.73627], [-121.81019, 39.73637], [-121.81138, 39.7363], [-121.81163, 39.7361], [-121.81196, 39.73603], [-121.81229, 39.73592], [-121.81237, 39.73587], [-121.81281, 39.73575], [-121.81411, 39.73562], [-121.81411, 39.73559], [-121.81453, 39.73546], [-121.815, 39.73522], [-121.81511, 39.7351], [-121.81516, 39.73491], [-121.81522, 39.73484], [-121.81583, 39.73456], [-121.8163, 39.73448], [-121.8164, 39.73456]]], [[[-121.81945, 39.73345], [-121.81906, 39.7337], [-121.81882, 39.73347], [-121.81864, 39.73344], [-121.81849, 39.73347], [-121.81849, 39.73349], [-121.81886, 39.73383], [-121.81873, 39.73391], [-121.81831, 39.73353], [-121.8182, 39.73362], [-121.81795, 39.7339], [-121.81781, 39.73407], [-121.81774, 39.73422], [-121.81768, 39.73428], [-121.81758, 39.73433], [-121.8174, 39.73438], [-121.8173, 39.73432], [-121.81756, 39.73424], [-121.81773, 39.73403], [-121.81776, 39.73398], [-121.81785, 39.73388], [-121.81792, 39.73378], [-121.818, 39.73371], [-121.81808, 39.7337], [-121.8181, 39.73367], [-121.81809, 39.73359], [-121.81821, 39.7335], [-121.81835, 39.73342], [-121.81848, 39.73337], [-121.81869, 39.73333], [-121.81885, 39.73337], [-121.81899, 39.73338], [-121.81933, 39.73334], [-121.81943, 39.73331], [-121.81945, 39.73345]]], [[[-121.82383, 39.73046], [-121.82379, 39.73053], [-121.82341, 39.73086], [-121.82313, 39.73106], [-121.82249, 39.73148], [-121.82228, 39.73129], [-121.82224, 39.7313], [-121.82219, 39.73137], [-121.82212, 39.73139], [-121.82201, 39.73141], [-121.8215, 39.73141], [-121.82143, 39.73143], [-121.8214, 39.73146], [-121.8213, 39.73164], [-121.82114, 39.73183], [-121.821, 39.73188], [-121.82085, 39.73201], [-121.8207, 39.7321], [-121.8206, 39.73219], [-121.8205, 39.73224], [-121.82042, 39.7323], [-121.82037, 39.73228], [-121.82024, 39.73252], [-121.82056, 39.73272], [-121.82001, 39.73308], [-121.81983, 39.73321], [-121.81971, 39.73316], [-121.81967, 39.73312], [-121.81969, 39.73312], [-121.81973, 39.73307], [-121.81981, 39.73294], [-121.81997, 39.73276], [-121.82014, 39.73247], [-121.82017, 39.73238], [-121.82026, 39.73228], [-121.82026, 39.73225], [-121.82031, 39.73224], [-121.82053, 39.73206], [-121.82081, 39.73179], [-121.82068, 39.7317], [-121.82083, 39.73156], [-121.82095, 39.73153], [-121.821, 39.73146], [-121.8211, 39.7314], [-121.82128, 39.73136], [-121.82149, 39.73135], [-121.82183, 39.73124], [-121.82191, 39.73119], [-121.82209, 39.73098], [-121.82218, 39.73094], [-121.82232, 39.73093], [-121.82239, 39.73094], [-121.82266, 39.7309], [-121.82282, 39.73086], [-121.82309, 39.73075], [-121.82327, 39.73062], [-121.82341, 39.73044], [-121.82358, 39.73034], [-121.82364, 39.73032], [-121.82383, 39.73046]]], [[[-121.82577, 39.72832], [-121.82565, 39.72835], [-121.82553, 39.72842], [-121.82548, 39.72848], [-121.82533, 39.72858], [-121.8251, 39.72879], [-121.82489, 39.72901], [-121.82459, 39.72941], [-121.82478, 39.72954], [-121.82416, 39.73013], [-121.82399, 39.73032], [-121.82392, 39.73027], [-121.82376, 39.73023], [-121.82384, 39.73018], [-121.824, 39.7299], [-121.82407, 39.72981], [-121.82409, 39.7298], [-121.82411, 39.72988], [-121.82416, 39.72984], [-121.8242, 39.72978], [-121.82423, 39.7297], [-121.8243, 39.72963], [-121.82435, 39.72953], [-121.82444, 39.72946], [-121.82452, 39.72932], [-121.82461, 39.72923], [-121.8248, 39.72895], [-121.82502, 39.72874], [-121.82505, 39.72869], [-121.82508, 39.72867], [-121.82515, 39.72857], [-121.82526, 39.72851], [-121.82536, 39.7284], [-121.82565, 39.72824], [-121.82572, 39.72823], [-121.82577, 39.72832]]], [[[-121.82742, 39.72731], [-121.8274, 39.7274], [-121.82689, 39.72758], [-121.82675, 39.72766], [-121.82647, 39.72777], [-121.82639, 39.72783], [-121.82627, 39.72789], [-121.82613, 39.72802], [-121.82611, 39.72809], [-121.82598, 39.72829], [-121.82596, 39.72829], [-121.82583, 39.72822], [-121.82589, 39.72817], [-121.82595, 39.72802], [-121.82602, 39.72791], [-121.82638, 39.72767], [-121.82645, 39.72765], [-121.82651, 39.7276], [-121.82655, 39.7276], [-121.8266, 39.72756], [-121.82681, 39.7275], [-121.82699, 39.72743], [-121.8271, 39.72741], [-121.82742, 39.72731]]], [[[-121.82832, 39.72714], [-121.82765, 39.7273], [-121.82758, 39.72725], [-121.82815, 39.72713], [-121.82832, 39.72714]]], [[[-121.82952, 39.72689], [-121.82943, 39.72697], [-121.82928, 39.72705], [-121.82922, 39.72707], [-121.8291, 39.72706], [-121.82894, 39.72708], [-121.82888, 39.72707], [-121.82883, 39.72708], [-121.82872, 39.72688], [-121.82899, 39.72688], [-121.8294, 39.72672], [-121.82952, 39.72689]]], [[[-121.83344, 39.72503], [-121.83328, 39.72507], [-121.83273, 39.72506], [-121.83278, 39.72515], [-121.8325, 39.72507], [-121.83243, 39.72517], [-121.83237, 39.72508], [-121.83235, 39.72508], [-121.83232, 39.72511], [-121.83232, 39.72517], [-121.83219, 39.72538], [-121.83199, 39.72549], [-121.83192, 39.72555], [-121.83175, 39.72562], [-121.83165, 39.72571], [-121.83157, 39.72573], [-121.83151, 39.72577], [-121.83143, 39.726], [-121.83143, 39.7261], [-121.83135, 39.72616], [-121.83102, 39.72634], [-121.83089, 39.72643], [-121.83084, 39.72648], [-121.83092, 39.72654], [-121.8306, 39.72666], [-121.83042, 39.7267], [-121.82988, 39.72691], [-121.82977, 39.72674], [-121.83015, 39.72664], [-121.8302, 39.72661], [-121.83047, 39.72653], [-121.83097, 39.72629], [-121.83101, 39.72624], [-121.83127, 39.72614], [-121.83155, 39.7256], [-121.83185, 39.7255], [-121.83202, 39.7254], [-121.83213, 39.72536], [-121.83215, 39.72534], [-121.83226, 39.72508], [-121.83235, 39.72496], [-121.83247, 39.72497], [-121.83253, 39.72496], [-121.83262, 39.72498], [-121.83294, 39.72499], [-121.83321, 39.72498], [-121.83324, 39.72497], [-121.83344, 39.72503]]], [[[-121.83511, 39.72438], [-121.83508, 39.7244], [-121.83503, 39.72439], [-121.8349, 39.72441], [-121.83482, 39.7244], [-121.83476, 39.72442], [-121.8345, 39.72445], [-121.8342, 39.72445], [-121.83413, 39.72447], [-121.83402, 39.72452], [-121.83392, 39.72463], [-121.83378, 39.72468], [-121.83373, 39.72477], [-121.83363, 39.72487], [-121.83362, 39.72488], [-121.83352, 39.72482], [-121.8336, 39.72477], [-121.83362, 39.72473], [-121.83373, 39.72462], [-121.83381, 39.72458], [-121.83385, 39.72453], [-121.83387, 39.72452], [-121.83393, 39.72446], [-121.83407, 39.72436], [-121.83414, 39.72435], [-121.8344, 39.72435], [-121.83503, 39.72427], [-121.83511, 39.72438]]], [[[-121.83623, 39.724], [-121.83617, 39.72403], [-121.83613, 39.72408], [-121.83603, 39.72415], [-121.8359, 39.72421], [-121.83552, 39.72431], [-121.83539, 39.72436], [-121.83537, 39.72436], [-121.83524, 39.72419], [-121.83534, 39.72418], [-121.83563, 39.72418], [-121.83596, 39.72403], [-121.83607, 39.72395], [-121.83619, 39.72388], [-121.83623, 39.724]]], [[[-121.83825, 39.72285], [-121.83813, 39.72294], [-121.83797, 39.72315], [-121.83783, 39.72326], [-121.83771, 39.7233], [-121.83725, 39.72338], [-121.83698, 39.72346], [-121.83687, 39.72351], [-121.83644, 39.72381], [-121.83635, 39.72373], [-121.83668, 39.72348], [-121.83709, 39.72327], [-121.83742, 39.72323], [-121.83784, 39.72306], [-121.83811, 39.72272], [-121.83825, 39.72285]]], [[[-121.83942, 39.7224], [-121.83888, 39.72278], [-121.83869, 39.72262], [-121.83852, 39.7227], [-121.83839, 39.72265], [-121.83869, 39.72234], [-121.83886, 39.72195], [-121.8387, 39.72146], [-121.83859, 39.72087], [-121.83855, 39.7208], [-121.83854, 39.72073], [-121.83878, 39.72047], [-121.8389, 39.7205], [-121.83878, 39.72068], [-121.8387, 39.72086], [-121.8387, 39.72097], [-121.83874, 39.72118], [-121.83902, 39.72171], [-121.83904, 39.72207], [-121.83942, 39.7224]]], [[[-121.84154, 39.71991], [-121.84151, 39.72], [-121.84084, 39.71993], [-121.84039, 39.71992], [-121.84017, 39.71987], [-121.83987, 39.71993], [-121.83944, 39.72009], [-121.8391, 39.72034], [-121.839, 39.72026], [-121.83929, 39.72005], [-121.83939, 39.72], [-121.83972, 39.71989], [-121.84001, 39.71984], [-121.8408, 39.71975], [-121.84136, 39.71992], [-121.84154, 39.71991]]], [[[-121.84215, 39.71983], [-121.84195, 39.72], [-121.84175, 39.71982], [-121.84185, 39.71956], [-121.84215, 39.71983]]], [[[-121.84325, 39.71835], [-121.84318, 39.71855], [-121.84276, 39.71876], [-121.84269, 39.71883], [-121.84256, 39.71917], [-121.84252, 39.71931], [-121.84252, 39.71938], [-121.84238, 39.71961], [-121.8421, 39.71937], [-121.84218, 39.71926], [-121.84233, 39.71915], [-121.84241, 39.71902], [-121.84249, 39.71884], [-121.84257, 39.71875], [-121.84271, 39.71864], [-121.84325, 39.71835]]], [[[-121.84539, 39.71636], [-121.84537, 39.71641], [-121.84527, 39.71648], [-121.84518, 39.71661], [-121.84515, 39.71667], [-121.84515, 39.71677], [-121.84509, 39.71687], [-121.84502, 39.71693], [-121.84498, 39.717], [-121.84474, 39.71709], [-121.84468, 39.71708], [-121.84457, 39.7172], [-121.84452, 39.71744], [-121.84438, 39.71756], [-121.84435, 39.71766], [-121.84434, 39.71778], [-121.84428, 39.71789], [-121.8442, 39.71802], [-121.84411, 39.7181], [-121.84394, 39.71821], [-121.84356, 39.71837], [-121.84354, 39.71808], [-121.84378, 39.71813], [-121.844, 39.71802], [-121.84412, 39.71785], [-121.84413, 39.7178], [-121.84419, 39.71772], [-121.84418, 39.71758], [-121.84433, 39.71744], [-121.84439, 39.7173], [-121.8444, 39.71721], [-121.84448, 39.71709], [-121.8446, 39.71698], [-121.84472, 39.71695], [-121.84479, 39.71695], [-121.84492, 39.7169], [-121.84496, 39.71687], [-121.84503, 39.71675], [-121.84505, 39.71662], [-121.84519, 39.71639], [-121.84526, 39.71633], [-121.84539, 39.71636]]]]} | No Public Access 3 | 36081 | Little Chico Creek Greenway | 28976 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 84.765 | Little Chico Creek Greenway | 0 | Local Recreation Area 3 | 4 | |
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 | |
3570 | 3570 | 3569 | {"type": "Polygon", "coordinates": [[[-122.29827, 38.33084], [-122.29801, 38.33096], [-122.29792, 38.33085], [-122.29785, 38.33081], [-122.29739, 38.3307], [-122.2972, 38.33046], [-122.29733, 38.3304], [-122.29775, 38.33062], [-122.29795, 38.33066], [-122.29796, 38.33065], [-122.29814, 38.33067], [-122.29827, 38.33084]]]} | No Public Access 3 | 36603 | Silverado Creek Maintenance District | 30030 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.498 | Silverado Creek Maintenance District | None 299 | |||
3582 | 3582 | 3581 | {"type": "Polygon", "coordinates": [[[-118.32429, 33.80965], [-118.32389, 33.80965], [-118.32389, 33.80924], [-118.32429, 33.80924], [-118.32429, 33.80965]]]} | No Public Access 3 | 36688 | Empty Lot 237th and Vine | 29082 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.419 | Empty Lot 237th and Vine | 0 | Local Other or Unknown 14 | 4 | |
3640 | 3640 | 3639 | {"type": "Polygon", "coordinates": [[[-121.25516, 38.82911], [-121.25484, 38.82931], [-121.25459, 38.82956], [-121.25447, 38.82976], [-121.25421, 38.8303], [-121.25411, 38.83044], [-121.25317, 38.82964], [-121.25338, 38.82941], [-121.25345, 38.82929], [-121.2535, 38.82917], [-121.25354, 38.82903], [-121.25355, 38.82889], [-121.25354, 38.82875], [-121.25351, 38.8286], [-121.25392, 38.82844], [-121.25515, 38.82835], [-121.25517, 38.82877], [-121.25511, 38.82902], [-121.25516, 38.82911]]]} | No Public Access 3 | 29498 | Mansion Oaks Park | 21761 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 5.751 | Mansion Oaks Park | 0 | Local Park 2 | 4 | |
3737 | 3737 | 3736 | {"type": "Polygon", "coordinates": [[[-122.61292, 38.22825], [-122.61179, 38.22899], [-122.61147, 38.22909], [-122.61106, 38.22932], [-122.61101, 38.22968], [-122.61177, 38.23], [-122.61184, 38.23035], [-122.61151, 38.23186], [-122.60961, 38.23153], [-122.60965, 38.23137], [-122.6092, 38.2308], [-122.6087, 38.23061], [-122.61068, 38.22837], [-122.60854, 38.22718], [-122.60936, 38.22628], [-122.60989, 38.22655], [-122.6104, 38.22678], [-122.61292, 38.22825]]]} | No Public Access 3 | 14099 | Alman | 15392 | 1249 | Petaluma, City of 148 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | Sonoma 16 | 26.587 | Alman | 1995 | None 313 | ||
3802 | 3802 | 3801 | {"type": "MultiPolygon", "coordinates": [[[[-122.40029, 37.67647], [-122.39967, 37.67678], [-122.39942, 37.67642], [-122.39966, 37.67619], [-122.40017, 37.67597], [-122.40029, 37.67647]]], [[[-122.40176, 37.6767], [-122.40155, 37.67706], [-122.40084, 37.67701], [-122.40067, 37.67684], [-122.40093, 37.67645], [-122.40171, 37.67657], [-122.40139, 37.67665], [-122.40143, 37.67678], [-122.40176, 37.6767]]], [[[-122.408, 37.67738], [-122.40713, 37.6773], [-122.4071, 37.67722], [-122.40703, 37.67718], [-122.40698, 37.6769], [-122.40695, 37.67683], [-122.40685, 37.67676], [-122.40653, 37.67669], [-122.40753, 37.67554], [-122.40799, 37.67554], [-122.408, 37.67738]]]]} | No Public Access 3 | 35106 | City of Brisbane | 28143 | 1035 | Brisbane, City of 686 | City 2 | City Agency 2 | http://www.ci.brisbane.ca.us/about-parks-and-recreation | City 2 | 1035 | Brisbane, City of 677 | City 2 | City Agency 2 | San Mateo 15 | 6.295 | City of Brisbane | None 319 | |||
3822 | 3822 | 3821 | {"type": "MultiPolygon", "coordinates": [[[[-117.16091, 33.13937], [-117.15846, 33.14101], [-117.15822, 33.14036], [-117.15821, 33.14035], [-117.15831, 33.14084], [-117.1584, 33.14105], [-117.15769, 33.14153], [-117.1577, 33.14159], [-117.15715, 33.14168], [-117.15661, 33.14181], [-117.15656, 33.14167], [-117.15663, 33.14161], [-117.15665, 33.14152], [-117.15663, 33.14145], [-117.15659, 33.14141], [-117.15691, 33.14112], [-117.15709, 33.14098], [-117.15796, 33.14043], [-117.16037, 33.13882], [-117.16091, 33.13937]]], [[[-117.16212, 33.13866], [-117.16175, 33.13905], [-117.16107, 33.13923], [-117.1605, 33.13865], [-117.16073, 33.13857], [-117.1615, 33.13836], [-117.16206, 33.1385], [-117.16212, 33.13866]]]]} | No Public Access 3 | 45235 | San Marcos City Open Space | 24944 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 10.993 | San Marcos City OS | 0 | Local Recreation Area 3 | 4 | |
3846 | 3846 | 3845 | {"type": "Polygon", "coordinates": [[[-117.22388, 32.93759], [-117.22376, 32.93764], [-117.22348, 32.9376], [-117.22333, 32.93761], [-117.22215, 32.93794], [-117.22194, 32.93802], [-117.22151, 32.93822], [-117.22151, 32.93456], [-117.22388, 32.93457], [-117.22388, 32.93759]]]} | No Public Access 3 | 46811 | Neighborhood 8 Neighborhood Park | 30272 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 19.773 | Neighborhood 8 Neighborhood 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]);