units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
363 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 2 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, YR_EST
MNG_AGENCY >30
- Los Angeles, City of 20
- Whittier, City of 20
- San Ramon, City of 15
- San Diego, City of 10
- Long Beach, City of 9
- Arcadia, City of 8
- Manhattan Beach, City of 8
- Santa Cruz, City of 7
- Modesto, City of 7
- San Jose, City of 6
- Carlsbad, City of 6
- Hollister, City of 6
- Pasadena, City of 6
- Santa Ana, City of 5
- Fullerton, City of 5
- Vacaville, City of 5
- San Bernardino, City of 5
- Beverly Hills, City of 5
- Lawndale, City of 5
- San Gabriel, City of 5
- Glendora, City of 4
- El Segundo, City of 4
- Stockton, City of 4
- Mountain View, City of 4
- Roseville, City of 4
- South El Monte, City of 4
- Watsonville, City of 3
- San Luis Obispo, City of 3
- Oceanside, City of 3
- Pomona, City of 3
- …
DES_TP >30
- Local Recreation Area 168
- Local Park 151
- Local Conservation Area 10
- Local Other or Unknown 6
- Local Historic or Cultural Area 2
- 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 · 363 ✖
ACCESS_TYP 1
- Restricted Access · 363 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
280 | 280 | 279 | {"type": "Polygon", "coordinates": [[[-121.85612, 36.61199], [-121.8561, 36.6123], [-121.85602, 36.6123], [-121.85604, 36.61196], [-121.85607, 36.61194], [-121.85612, 36.61199]]]} | Restricted Access 2 | 956 | South Monterey Dunes | 25664 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.07 | South Monterey Dunes | None 30 | |||
2159 | 2159 | 2158 | {"type": "Polygon", "coordinates": [[[-122.5122, 37.93636], [-122.50745, 37.93685], [-122.50733, 37.93585], [-122.50733, 37.93514], [-122.50753, 37.93394], [-122.50773, 37.93298], [-122.50798, 37.93199], [-122.50819, 37.9308], [-122.50832, 37.93034], [-122.50839, 37.92998], [-122.50843, 37.92956], [-122.50862, 37.92877], [-122.50865, 37.92853], [-122.50876, 37.92835], [-122.50901, 37.92814], [-122.50954, 37.92788], [-122.50987, 37.92778], [-122.5106, 37.92744], [-122.51067, 37.9274], [-122.51066, 37.9273], [-122.51068, 37.92728], [-122.51062, 37.9269], [-122.51051, 37.92633], [-122.51056, 37.9263], [-122.51068, 37.92631], [-122.51084, 37.92759], [-122.51106, 37.9289], [-122.5122, 37.93636]]]} | Restricted Access 2 | 16168 | Muzzi Marsh | 22617 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 77.169 | Muzzi Marsh | None 177 | |||
2219 | 2219 | 2218 | {"type": "MultiPolygon", "coordinates": [[[[-122.53623, 38.01398], [-122.53597, 38.01397], [-122.53407, 38.01539], [-122.53406, 38.01497], [-122.53397, 38.01496], [-122.53397, 38.01473], [-122.5334, 38.01505], [-122.53336, 38.0164], [-122.5328, 38.0164], [-122.53257, 38.01637], [-122.53171, 38.0164], [-122.53089, 38.01638], [-122.53055, 38.01646], [-122.53322, 38.01055], [-122.53338, 38.01089], [-122.53304, 38.01129], [-122.53413, 38.01286], [-122.53623, 38.01398]]], [[[-122.53425, 38.01729], [-122.53416, 38.01705], [-122.53412, 38.01637], [-122.53424, 38.01636], [-122.53425, 38.01729]]]]} | Restricted Access 2 | 16569 | Gallinas Creek Marsh Restoration | 19179 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 31.196 | Gallinas Creek Marsh Restoration | None 182 | |||
3448 | 3448 | 3447 | {"type": "Polygon", "coordinates": [[[-122.37728, 37.8995], [-122.37687, 37.90346], [-122.35981, 37.90125], [-122.3598, 37.90126], [-122.35981, 37.9018], [-122.35775, 37.90181], [-122.35773, 37.90092], [-122.35788, 37.90109], [-122.35803, 37.90098], [-122.35781, 37.9007], [-122.3576, 37.90062], [-122.3574, 37.8997], [-122.3572, 37.89911], [-122.35737, 37.89887], [-122.35772, 37.89812], [-122.35749, 37.89767], [-122.35716, 37.89727], [-122.35737, 37.89693], [-122.35721, 37.89654], [-122.3575, 37.89591], [-122.35742, 37.89558], [-122.35717, 37.89509], [-122.35687, 37.8949], [-122.3566, 37.89494], [-122.3563, 37.89461], [-122.35471, 37.89435], [-122.35458, 37.89471], [-122.35306, 37.89475], [-122.35246, 37.8945], [-122.35191, 37.89435], [-122.3514, 37.89407], [-122.35136, 37.8937], [-122.35107, 37.89356], [-122.35082, 37.89383], [-122.35146, 37.89463], [-122.35148, 37.89464], [-122.35174, 37.89554], [-122.352, 37.89603], [-122.35227, 37.89631], [-122.35261, 37.89649], [-122.35277, 37.8969], [-122.35282, 37.89693], [-122.35286, 37.89882], [-122.34909, 37.89467], [-122.34902, 37.8918], [-122.35677, 37.89326], [-122.35962, 37.89378], [-122.35969, 37.89617], [-122.37728, 37.8995]]]} | Restricted Access 2 | 25298 | Brooks Island | 16426 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 289.362 | Brooks Island | None 282 | |||
3449 | 3449 | 3448 | {"type": "Polygon", "coordinates": [[[-122.10288, 37.98676], [-122.10284, 37.98741], [-122.0973, 37.9875], [-122.09724, 37.98631], [-122.09749, 37.98606], [-122.09779, 37.98587], [-122.0981, 37.98575], [-122.09846, 37.98558], [-122.09872, 37.98543], [-122.09892, 37.98521], [-122.09945, 37.98532], [-122.10123, 37.98528], [-122.10169, 37.98536], [-122.10203, 37.98589], [-122.10241, 37.98638], [-122.1027, 37.98663], [-122.10288, 37.98676]]]} | Restricted Access 2 | 25304 | Martinez | 21925 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 24.888 | Martinez | None 283 | |||
4165 | 4165 | 4164 | {"type": "Polygon", "coordinates": [[[-121.94848, 37.74904], [-121.94621, 37.74996], [-121.94536, 37.74865], [-121.94551, 37.7483], [-121.94569, 37.74815], [-121.94589, 37.7481], [-121.94621, 37.74811], [-121.94644, 37.7482], [-121.9468, 37.74876], [-121.94796, 37.74823], [-121.94848, 37.74904]]]} | Restricted Access 2 | 47573 | California High School Tennis Courts and Track | 31298 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 7.772 | California High School Tennis Courts and Track | None 360 | |||
7105 | 7105 | 7104 | {"type": "Polygon", "coordinates": [[[-118.40261, 33.92509], [-118.40215, 33.92509], [-118.40215, 33.92477], [-118.40261, 33.92477], [-118.40261, 33.92509]]]} | Restricted Access 2 | 6158 | Camp Eucalyptus | 29706 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 0.378 | Camp Eucalyptus | None 581 | |||
9493 | 9493 | 9492 | {"type": "MultiPolygon", "coordinates": [[[[-117.94979, 35.1278], [-117.94897, 35.12779], [-117.9487, 35.12788], [-117.94845, 35.1281], [-117.94846, 35.13001], [-117.94782, 35.13002], [-117.94782, 35.12984], [-117.94781, 35.12855], [-117.94753, 35.12829], [-117.94728, 35.12823], [-117.94692, 35.12838], [-117.94679, 35.12855], [-117.94677, 35.12887], [-117.94677, 35.13003], [-117.94655, 35.13003], [-117.94636, 35.12998], [-117.94627, 35.12999], [-117.9462, 35.13003], [-117.94617, 35.13008], [-117.94615, 35.13018], [-117.94619, 35.13027], [-117.94625, 35.13031], [-117.94634, 35.13033], [-117.94653, 35.13028], [-117.94667, 35.13027], [-117.94667, 35.13073], [-117.94562, 35.13074], [-117.94558, 35.13233], [-117.94541, 35.13232], [-117.94554, 35.13226], [-117.94551, 35.13094], [-117.94537, 35.13076], [-117.9447, 35.13062], [-117.94437, 35.13043], [-117.94384, 35.13032], [-117.9437, 35.1302], [-117.9437, 35.13002], [-117.94381, 35.12986], [-117.94375, 35.12968], [-117.94311, 35.12954], [-117.94311, 35.12929], [-117.94334, 35.12915], [-117.94331, 35.12869], [-117.94345, 35.12858], [-117.94442, 35.12849], [-117.94489, 35.12831], [-117.94495, 35.12785], [-117.94523, 35.12762], [-117.94523, 35.12745], [-117.94501, 35.12737], [-117.94413, 35.12743], [-117.94412, 35.12745], [-117.94423, 35.12764], [-117.94423, 35.12791], [-117.94384, 35.12803], [-117.94339, 35.12807], [-117.94311, 35.12798], [-117.94311, 35.12771], [-117.94325, 35.12741], [-117.94311, 35.12732], [-117.94267, 35.1275], [-117.94236, 35.12785], [-117.94247, 35.12833], [-117.94255, 35.1284], [-117.94255, 35.12865], [-117.94214, 35.12881], [-117.94141, 35.12892], [-117.94102, 35.12879], [-117.94103, 35.12755], [-117.94109, 35.12739], [-117.9412, 35.12699], [-117.94123, 35.12672], [-117.94124, 35.12613], [-117.94977, 35.12613], [-117.94979, 35.1278]]], [[[-117.94286, 35.13016], [-117.94286, 35.13018], [-117.94264, 35.13018], [-117.94264, 35.13015], [-117.94286, 35.13016]]], [[[-117.94567, 35.13316], [-117.94481, 35.1331], [-117.94404, 35.133], [-117.94334, 35.13283], [-117.94307, 35.13275], [-117.94334, 35.13215], [-117.94332, 35.13203], [-117.94339, 35.13198], [-117.94412, 35.13222], [-117.94422, 35.13229], [-117.94434, 35.13254], [-117.94441, 35.1326], [-117.94452, 35.1326], [-117.94504, 35.13242], [-117.94508, 35.1326], [-117.94476, 35.1327], [-117.94471, 35.13281], [-117.94471, 35.1329], [-117.94564, 35.13299], [-117.94567, 35.13316]]], [[[-117.94352, 35.13092], [-117.94349, 35.13096], [-117.9434, 35.13101], [-117.94331, 35.13102], [-117.9432, 35.13099], [-117.94313, 35.13092], [-117.94352, 35.13092]]]]} | Restricted Access 2 | 15889 | California City Central Park/Tierra Del Sol Golf | 33388 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 67.723 | California City Central Park/Tierra Del Sol Golf | None 786 | |||
9610 | 9610 | 9609 | {"type": "Polygon", "coordinates": [[[-122.51578, 37.93447], [-122.51567, 37.93481], [-122.51546, 37.93574], [-122.51546, 37.9358], [-122.51567, 37.93605], [-122.51514, 37.93636], [-122.51465, 37.9367], [-122.5141, 37.93719], [-122.51372, 37.93759], [-122.51345, 37.93792], [-122.51322, 37.9383], [-122.5131, 37.93865], [-122.51297, 37.93799], [-122.51263, 37.93588], [-122.51159, 37.92886], [-122.51137, 37.92754], [-122.51163, 37.92751], [-122.51171, 37.92758], [-122.51164, 37.92782], [-122.51162, 37.92803], [-122.51163, 37.92814], [-122.51181, 37.9292], [-122.51206, 37.93053], [-122.51209, 37.93066], [-122.51219, 37.9309], [-122.51226, 37.93101], [-122.5124, 37.93117], [-122.51252, 37.93127], [-122.51279, 37.93144], [-122.51308, 37.93157], [-122.51341, 37.93165], [-122.51357, 37.93168], [-122.5139, 37.9317], [-122.51498, 37.93163], [-122.51524, 37.93167], [-122.51541, 37.93172], [-122.5155, 37.93177], [-122.51556, 37.93183], [-122.51559, 37.93191], [-122.51588, 37.93331], [-122.51589, 37.93378], [-122.51585, 37.93413], [-122.51578, 37.93447]]]} | Restricted Access 2 | 16166 | Shorebird Marsh | 25419 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 46.096 | Shorebird Marsh | None 816 | |||
10378 | 10378 | 10377 | {"type": "MultiPolygon", "coordinates": [[[[-121.92445, 36.62692], [-121.92367, 36.62794], [-121.92237, 36.62731], [-121.92247, 36.62704], [-121.91997, 36.62581], [-121.92003, 36.62571], [-121.91989, 36.62563], [-121.91971, 36.62549], [-121.91887, 36.62507], [-121.91881, 36.62498], [-121.91882, 36.62488], [-121.91886, 36.62482], [-121.91893, 36.62478], [-121.91901, 36.62475], [-121.9191, 36.62476], [-121.92302, 36.62586], [-121.92292, 36.62621], [-121.92316, 36.62628], [-121.9236, 36.62644], [-121.92382, 36.62655], [-121.9242, 36.62678], [-121.92445, 36.62692]]], [[[-121.92659, 36.62954], [-121.9265, 36.62993], [-121.92645, 36.62997], [-121.92639, 36.62997], [-121.92345, 36.62854], [-121.92375, 36.62815], [-121.92659, 36.62954]]], [[[-121.92669, 36.62885], [-121.92661, 36.62939], [-121.92384, 36.62803], [-121.92418, 36.6276], [-121.92669, 36.62885]]], [[[-121.93197, 36.6333], [-121.93172, 36.634], [-121.93169, 36.63404], [-121.93163, 36.63405], [-121.92913, 36.63361], [-121.92879, 36.6335], [-121.92834, 36.63329], [-121.92832, 36.63325], [-121.92832, 36.63321], [-121.92865, 36.63278], [-121.9287, 36.63263], [-121.92867, 36.63201], [-121.92861, 36.63176], [-121.92855, 36.63158], [-121.92845, 36.63137], [-121.92829, 36.63114], [-121.92812, 36.63094], [-121.9279, 36.63074], [-121.92752, 36.63049], [-121.92732, 36.63039], [-121.927, 36.63027], [-121.92672, 36.63013], [-121.92671, 36.63008], [-121.92678, 36.62964], [-121.92943, 36.63095], [-121.92971, 36.63106], [-121.92997, 36.63113], [-121.9294, 36.63268], [-121.93197, 36.6333]]], [[[-121.92934, 36.63016], [-121.92922, 36.63068], [-121.9268, 36.62949], [-121.92689, 36.62894], [-121.92934, 36.63016]]], [[[-121.9352, 36.63631], [-121.93508, 36.63686], [-121.93454, 36.63701], [-121.93434, 36.63703], [-121.93421, 36.63702], [-121.9341, 36.63698], [-121.93401, 36.63693], [-121.93388, 36.63682], [-121.93402, 36.63596], [-121.93434, 36.63622], [-121.9352, 36.63631]]]]} | Restricted Access 2 | 18334 | Pacific Grove Golf Links | 33064 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 42.199 | Pacific Grove Golf Links | None 907 | |||
10933 | 10933 | 10932 | {"type": "Polygon", "coordinates": [[[-121.64543, 38.58948], [-121.63841, 38.58953], [-121.63129, 38.58946], [-121.63131, 38.58253], [-121.63156, 38.58084], [-121.63183, 38.58003], [-121.63258, 38.57849], [-121.63329, 38.57731], [-121.63423, 38.5762], [-121.6349, 38.57544], [-121.63534, 38.57532], [-121.63556, 38.57529], [-121.63601, 38.57532], [-121.63644, 38.57548], [-121.63674, 38.57566], [-121.63742, 38.57615], [-121.63776, 38.57626], [-121.63805, 38.5764], [-121.63835, 38.57647], [-121.63858, 38.57649], [-121.63928, 38.57661], [-121.64007, 38.57663], [-121.64366, 38.57663], [-121.64405, 38.57668], [-121.64434, 38.57677], [-121.64464, 38.57694], [-121.64491, 38.57715], [-121.64512, 38.57745], [-121.64521, 38.57777], [-121.64497, 38.58825], [-121.64504, 38.5886], [-121.64513, 38.58894], [-121.64543, 38.58948]]]} | Restricted Access 2 | 20958 | Davis Wetland Demonstration | 17955 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 419.626 | Davis Wetland Demonstration | None 954 | |||
11086 | 11086 | 11085 | {"type": "MultiPolygon", "coordinates": [[[[-121.44086, 38.39459], [-121.43552, 38.39463], [-121.42709, 38.39468], [-121.422, 38.39493], [-121.41795, 38.39493], [-121.41795, 38.39458], [-121.42201, 38.39457], [-121.42708, 38.39433], [-121.43606, 38.39427], [-121.43607, 38.39461], [-121.43609, 38.39462], [-121.4361, 38.39461], [-121.43609, 38.39427], [-121.44035, 38.39424], [-121.44036, 38.39395], [-121.44032, 38.39394], [-121.44085, 38.39394], [-121.44086, 38.39459]]], [[[-121.43609, 38.40531], [-121.43598, 38.4086], [-121.43569, 38.4086], [-121.43577, 38.4059], [-121.43587, 38.40526], [-121.43609, 38.40531]]], [[[-121.44071, 38.4054], [-121.44048, 38.40543], [-121.43989, 38.4056], [-121.43949, 38.40567], [-121.43917, 38.40568], [-121.43887, 38.40567], [-121.43641, 38.40584], [-121.4362, 38.40594], [-121.43621, 38.40553], [-121.43635, 38.40551], [-121.43878, 38.40534], [-121.43941, 38.40533], [-121.43974, 38.40528], [-121.44034, 38.40511], [-121.44071, 38.40506], [-121.44071, 38.4054]]], [[[-121.44105, 38.38668], [-121.44097, 38.38669], [-121.44089, 38.38673], [-121.44083, 38.38679], [-121.44081, 38.38686], [-121.44084, 38.39374], [-121.44019, 38.39375], [-121.44016, 38.38659], [-121.44105, 38.38659], [-121.44105, 38.38668]]]]} | Restricted Access 2 | 21328 | CITY OF ELK GROVE | 17310 | 1097 | Elk Grove, City of 963 | City 2 | City Agency 2 | http://www.elkgrovecity.org/ | City 2 | 1097 | Elk Grove, City of 931 | City 2 | City Agency 2 | Sacramento 41 | 37.05 | CITY OF ELK GROVE | None 963 | |||
12760 | 12760 | 12759 | {"type": "Polygon", "coordinates": [[[-121.5371, 38.58568], [-121.53598, 38.58568], [-121.53599, 38.58453], [-121.53471, 38.58454], [-121.53471, 38.58397], [-121.5371, 38.58383], [-121.5371, 38.58568]]]} | Restricted Access 2 | 29861 | Westifield School Playsite | 31656 | 1376 | West Sacramento, City of 548 | City 2 | City Agency 2 | http://www.cityofwestsacramento.org/city/depts/pcs/default.asp | City 2 | 1376 | West Sacramento, City of 541 | City 2 | City Agency 2 | Yolo 33 | 6.689 | Westifield School Playsite | None 1117 | |||
14195 | 14195 | 14194 | {"type": "Polygon", "coordinates": [[[-118.54281, 34.25984], [-118.54023, 34.25984], [-118.5403, 34.2596], [-118.5404, 34.25932], [-118.54124, 34.2574], [-118.54174, 34.25744], [-118.54281, 34.25743], [-118.54281, 34.25984]]]} | Restricted Access 2 | 46859 | Northridge City Little League | 30336 | 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 | 12.794 | Northridge City Little League | None 1208 | |||
14393 | 14393 | 14392 | {"type": "MultiPolygon", "coordinates": [[[[-119.25231, 35.30226], [-119.25231, 35.30309], [-119.25223, 35.3031], [-119.25222, 35.30377], [-119.25231, 35.30378], [-119.2523, 35.30706], [-119.24691, 35.30706], [-119.24689, 35.31068], [-119.24357, 35.31069], [-119.24355, 35.31431], [-119.23467, 35.3143], [-119.23463, 35.31794], [-119.23106, 35.31795], [-119.23105, 35.31986], [-119.21949, 35.32], [-119.21947, 35.32536], [-119.21637, 35.3254], [-119.21635, 35.32721], [-119.21203, 35.32721], [-119.21196, 35.33231], [-119.21237, 35.33267], [-119.19869, 35.33266], [-119.19417, 35.33263], [-119.19407, 35.33993], [-119.18531, 35.33985], [-119.18533, 35.34355], [-119.1809, 35.34352], [-119.18092, 35.34642], [-119.17282, 35.34638], [-119.17282, 35.34627], [-119.17216, 35.3462], [-119.17025, 35.34618], [-119.16994, 35.3462], [-119.16942, 35.34631], [-119.16922, 35.34633], [-119.16921, 35.34661], [-119.16335, 35.34659], [-119.16335, 35.34614], [-119.16316, 35.34614], [-119.16314, 35.34659], [-119.1549, 35.34666], [-119.15433, 35.34673], [-119.15381, 35.34673], [-119.1538, 35.34675], [-119.14748, 35.3468], [-119.14747, 35.34678], [-119.14733, 35.34678], [-119.14702, 35.34685], [-119.14677, 35.34695], [-119.14658, 35.34707], [-119.14631, 35.34729], [-119.14553, 35.3473], [-119.14553, 35.34797], [-119.145, 35.34843], [-119.14497, 35.34841], [-119.14437, 35.34892], [-119.14412, 35.34909], [-119.1438, 35.34925], [-119.14342, 35.34939], [-119.14313, 35.34947], [-119.14132, 35.34975], [-119.14085, 35.34986], [-119.14051, 35.34998], [-119.13735, 35.3512], [-119.13734, 35.35119], [-119.13699, 35.3513], [-119.1356, 35.35161], [-119.13549, 35.35161], [-119.13497, 35.3515], [-119.13484, 35.35151], [-119.133, 35.35189], [-119.13144, 35.35085], [-119.13213, 35.35018], [-119.13545, 35.34873], [-119.1366, 35.34848], [-119.13659, 35.34756], [-119.13714, 35.3473], [-119.14146, 35.34564], [-119.14337, 35.34493], [-119.14412, 35.34462], [-119.14552, 35.34446], [-119.14552, 35.3456], [-119.14554, 35.34561], [-119.14565, 35.34507], [-119.15013, 35.34469], [-119.15125, 35.34468], [-119.15439, 35.3431], [-119.16039, 35.34305], [-119.16326, 35.34385], [-119.16327, 35.34414], [-119.16498, 35.34432], [-119.16768, 35.34402], [-119.16837, 35.34364], [-119.16913, 35.34254], [-119.16938, 35.34184], [-119.1713, 35.33983], [-119.17208, 35.33982], [-119.17212, 35.33618], [-119.17652, 35.33617], [-119.17656, 35.33253], [-119.18096, 35.33252], [-119.18107, 35.32415], [-119.18682, 35.32194], [-119.18726, 35.32181], [-119.197, 35.32044], [-119.19726, 35.32038], [-119.19748, 35.32027], [-119.19882, 35.32142], [-119.20352, 35.32537], [-119.20396, 35.32537], [-119.20396, 35.32535], [-119.19775, 35.32011], [-119.21331, 35.31076], [-119.21743, 35.30838], [-119.21775, 35.30826], [-119.21817, 35.30814], [-119.21859, 35.30805], [-119.21893, 35.30799], [-119.23869, 35.30597], [-119.2387, 35.30596], [-119.23866, 35.3057], [-119.24602, 35.30491], [-119.24784, 35.30307], [-119.25231, 35.30226]]], [[[-119.26408, 35.30353], [-119.25461, 35.30346], [-119.25393, 35.30397], [-119.25258, 35.30426], [-119.25258, 35.30378], [-119.25266, 35.30377], [-119.25266, 35.30311], [-119.25258, 35.30309], [-119.25258, 35.30216], [-119.25321, 35.30159], [-119.25464, 35.30088], [-119.25577, 35.30059], [-119.25736, 35.30052], [-119.25921, 35.30106], [-119.26113, 35.30122], [-119.26408, 35.30353]]]]} | Restricted Access 2 | 44492 | 2800 Acre Water Bank | 15189 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 3053.963 | 2800 Acre Water Bank | None 1220 | |||
15106 | 15106 | 15105 | {"type": "Polygon", "coordinates": [[[-118.19716, 33.76369], [-118.19705, 33.76402], [-118.19697, 33.76419], [-118.19684, 33.7644], [-118.19667, 33.76459], [-118.19658, 33.76458], [-118.19607, 33.76429], [-118.19559, 33.76406], [-118.19599, 33.76352], [-118.19603, 33.76342], [-118.19603, 33.76328], [-118.19614, 33.76327], [-118.19626, 33.76322], [-118.19631, 33.76322], [-118.19716, 33.76369]]]} | Restricted Access 2 | 45903 | Long Beach Aquarium of the Pacific | 28978 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 3.167 | Long Beach Aquarium of the Pacific | None 1314 | |||
15131 | 15131 | 15130 | {"type": "Polygon", "coordinates": [[[-118.17142, 34.16041], [-118.171, 34.16012], [-118.17032, 34.15985], [-118.16923, 34.15947], [-118.16932, 34.15971], [-118.16928, 34.15992], [-118.16967, 34.161], [-118.16974, 34.16109], [-118.16982, 34.16114], [-118.17003, 34.16174], [-118.16999, 34.16176], [-118.17005, 34.16195], [-118.16896, 34.16226], [-118.1689, 34.16241], [-118.16857, 34.16252], [-118.16841, 34.16264], [-118.16808, 34.16276], [-118.16778, 34.16277], [-118.16589, 34.16329], [-118.16523, 34.16349], [-118.16484, 34.16267], [-118.1643, 34.16174], [-118.16393, 34.16098], [-118.16414, 34.1607], [-118.16434, 34.16049], [-118.16452, 34.16034], [-118.16488, 34.1601], [-118.1652, 34.15989], [-118.16547, 34.15975], [-118.16635, 34.15937], [-118.16677, 34.1591], [-118.16692, 34.15898], [-118.16712, 34.15877], [-118.1673, 34.15855], [-118.16745, 34.15832], [-118.16758, 34.15807], [-118.16767, 34.15782], [-118.16772, 34.15756], [-118.16775, 34.15729], [-118.16774, 34.15703], [-118.1676, 34.15659], [-118.16757, 34.15606], [-118.16822, 34.15592], [-118.1683, 34.15589], [-118.1684, 34.15582], [-118.16848, 34.15574], [-118.16855, 34.15563], [-118.16857, 34.15553], [-118.16858, 34.15541], [-118.16854, 34.15527], [-118.168, 34.15465], [-118.16787, 34.15444], [-118.16778, 34.15421], [-118.16776, 34.15415], [-118.16779, 34.15412], [-118.16809, 34.15392], [-118.1681, 34.154], [-118.16823, 34.15427], [-118.16828, 34.15444], [-118.1688, 34.1547], [-118.1694, 34.15575], [-118.16993, 34.15661], [-118.17033, 34.1578], [-118.17055, 34.1584], [-118.17071, 34.1588], [-118.17103, 34.1592], [-118.17142, 34.16041]]]} | Restricted Access 2 | 45950 | Rose Bowl | 29069 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://www.rosebowlstadium.com/ | Los Angeles 6 | 74.133 | Rose Bowl | None 1318 | ||
15165 | 15165 | 15164 | {"type": "Polygon", "coordinates": [[[-121.34597, 37.95779], [-121.34588, 37.95797], [-121.34548, 37.95813], [-121.34457, 37.95838], [-121.34326, 37.95858], [-121.34331, 37.95855], [-121.34331, 37.95847], [-121.34327, 37.95843], [-121.34318, 37.95841], [-121.34314, 37.95834], [-121.34307, 37.95812], [-121.34308, 37.95799], [-121.34298, 37.95774], [-121.34296, 37.95756], [-121.34295, 37.95735], [-121.34301, 37.95719], [-121.34318, 37.95688], [-121.34321, 37.95678], [-121.34333, 37.95665], [-121.34346, 37.95654], [-121.34358, 37.9565], [-121.34379, 37.95652], [-121.34384, 37.95655], [-121.34391, 37.95665], [-121.3439, 37.95681], [-121.34379, 37.95719], [-121.34597, 37.95779]]]} | Restricted Access 2 | 46016 | Pixie Woods | 29339 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/government/departments/communityServices/attPixWood.html | San Joaquin 39 | 7.563 | Pixie Woods | None 1322 | ||
15198 | 15198 | 15197 | {"type": "Polygon", "coordinates": [[[-118.16833, 34.12281], [-118.16827, 34.12316], [-118.16819, 34.12339], [-118.16805, 34.12365], [-118.16806, 34.12387], [-118.168, 34.12391], [-118.16596, 34.12389], [-118.16631, 34.12303], [-118.16635, 34.12294], [-118.16642, 34.12286], [-118.16833, 34.12281]]]} | Restricted Access 2 | 46075 | San Pascual Stables | 29415 | 1340 | South Pasadena, City of 309 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/index.aspx?page=67 | Los Angeles 6 | 5.409 | San Pascual Stables | None 1327 | ||
16030 | 16030 | 16029 | {"type": "Polygon", "coordinates": [[[-122.46262, 37.88628], [-122.46194, 37.88753], [-122.46228, 37.88826], [-122.46203, 37.88883], [-122.46196, 37.88881], [-122.4622, 37.88825], [-122.46187, 37.88752], [-122.46244, 37.88647], [-122.46247, 37.88632], [-122.46244, 37.88621], [-122.46238, 37.88612], [-122.46202, 37.88574], [-122.46178, 37.88559], [-122.46163, 37.88555], [-122.46145, 37.88555], [-122.46137, 37.88558], [-122.46098, 37.88576], [-122.46088, 37.88583], [-122.4608, 37.88591], [-122.46058, 37.88632], [-122.45992, 37.8867], [-122.45884, 37.88729], [-122.45859, 37.88716], [-122.45997, 37.88649], [-122.46005, 37.88643], [-122.4601, 37.88635], [-122.46014, 37.88627], [-122.46014, 37.88621], [-122.46013, 37.88612], [-122.46006, 37.88601], [-122.45998, 37.88594], [-122.45989, 37.8859], [-122.45976, 37.88587], [-122.4593, 37.88584], [-122.45902, 37.88578], [-122.45852, 37.88564], [-122.45852, 37.8856], [-122.45892, 37.88563], [-122.45893, 37.88562], [-122.45892, 37.88559], [-122.45949, 37.88556], [-122.45993, 37.88558], [-122.46045, 37.88565], [-122.46068, 37.88563], [-122.4609, 37.88557], [-122.46112, 37.88544], [-122.46123, 37.88533], [-122.46127, 37.88526], [-122.46129, 37.88515], [-122.46128, 37.88503], [-122.46124, 37.88493], [-122.46116, 37.88484], [-122.46106, 37.88476], [-122.46088, 37.88466], [-122.46073, 37.8846], [-122.46025, 37.8845], [-122.46002, 37.88441], [-122.45985, 37.88429], [-122.45966, 37.88409], [-122.45902, 37.88413], [-122.4589, 37.88426], [-122.45871, 37.88418], [-122.45883, 37.88394], [-122.45949, 37.88386], [-122.45929, 37.88352], [-122.45912, 37.8832], [-122.45898, 37.88287], [-122.46164, 37.88514], [-122.4616, 37.88539], [-122.46206, 37.8857], [-122.46262, 37.88628]]]} | Restricted Access 2 | 5233 | Marinero Owner's Association Open Space Areas | 21856 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 6.995 | Marinero Owner's Association OS Areas | None 1375 |
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]);