units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,440 rows where DES_TP = 3 and MNG_AG_LEV = 2 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: LAYER
MNG_AGENCY >30
- San Diego, City of 211
- Los Angeles, City of 116
- San Francisco, City and County of 80
- San Luis Obispo, City of 26
- Long Beach, City of 25
- Glendale, City of 24
- Davis, City of 23
- Santa Clarita, City of 18
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Santa Cruz, City of 14
- San Bernardino, City of 14
- San Marcos, City of 14
- Tiburon, Town of 13
- Carlsbad, City of 12
- Poway, City of 12
- Mission Viejo, City of 11
- Fresno, City of 10
- Oceanside, City of 10
- Riverside, City of 9
- Irvine, City of 9
- Roseville, City of 9
- Santa Barbara, City of 8
- South San Francisco, City of 8
- Escondido, City of 8
- Chico, City of 8
- …
ACCESS_TYP 4
- Open Access 1,226
- Restricted Access 168
- No Public Access 40
- Unknown Access 6
MNG_AG_TYP 1
- City Agency 1,440
DES_TP 1
- Local Recreation Area · 1,440 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
999 | 999 | 998 | {"type": "Polygon", "coordinates": [[[-118.24932, 33.93589], [-118.24931, 33.93673], [-118.24783, 33.93674], [-118.24784, 33.93589], [-118.24932, 33.93589]]]} | Open Access 1 | 6218 | 109th Street Recreation Center | 15168 | 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 | 3.184 | 109th Street Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
4899 | 4899 | 4898 | {"type": "MultiPolygon", "coordinates": [[[[-122.47227, 37.75682], [-122.47215, 37.75701], [-122.47202, 37.75727], [-122.47195, 37.75729], [-122.47141, 37.75706], [-122.47129, 37.75698], [-122.4712, 37.7569], [-122.47111, 37.75678], [-122.47106, 37.75665], [-122.47105, 37.75655], [-122.47106, 37.75638], [-122.47147, 37.75639], [-122.47146, 37.75656], [-122.47151, 37.75669], [-122.47162, 37.75678], [-122.47179, 37.75685], [-122.47194, 37.75665], [-122.47227, 37.75682]]], [[[-122.47149, 37.75605], [-122.47147, 37.75632], [-122.47108, 37.75631], [-122.47109, 37.75604], [-122.47149, 37.75605]]], [[[-122.47257, 37.75623], [-122.47259, 37.75633], [-122.47257, 37.75647], [-122.47252, 37.75655], [-122.47232, 37.75676], [-122.47199, 37.75659], [-122.47219, 37.75636], [-122.4722, 37.75634], [-122.47197, 37.75608], [-122.47171, 37.7559], [-122.47192, 37.75563], [-122.47207, 37.75572], [-122.47224, 37.75585], [-122.47238, 37.756], [-122.47257, 37.75623]]]]} | Open Access 1 | 5586 | 14th & 15th Avenue Open Space | 15172 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.665 | 14th & 15th Avenue OS | 0 | Local Recreation Area 3 | 4 | |
7327 | 7327 | 7326 | {"type": "MultiPolygon", "coordinates": [[[[-118.19093, 33.78373], [-118.19093, 33.78389], [-118.19012, 33.78389], [-118.19012, 33.78373], [-118.19093, 33.78373]]], [[[-118.19225, 33.78389], [-118.1912, 33.78389], [-118.1912, 33.78373], [-118.19225, 33.78373], [-118.19225, 33.78389]]], [[[-118.19492, 33.78372], [-118.19492, 33.78389], [-118.19388, 33.78389], [-118.19388, 33.78372], [-118.19492, 33.78372]]], [[[-118.19623, 33.78372], [-118.19623, 33.78389], [-118.19519, 33.78389], [-118.19519, 33.78372], [-118.19623, 33.78372]]]]} | Open Access 1 | 6641 | 14th Street Park and Playground | 15173 | 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 | 1.661 | 14th Street Park and Playground | 0 | Local Recreation Area 3 | 4 | |
12069 | 12069 | 12068 | {"type": "Polygon", "coordinates": [[[-124.174, 40.78401], [-124.174, 40.78456], [-124.17298, 40.78455], [-124.17297, 40.78439], [-124.17198, 40.78439], [-124.17198, 40.78413], [-124.17249, 40.78413], [-124.1725, 40.78384], [-124.17297, 40.78384], [-124.17298, 40.78375], [-124.17379, 40.78376], [-124.17379, 40.784], [-124.174, 40.78401]]]} | Open Access 1 | 24769 | 20-30 Park and Playground | 15177 | 1419 | Eureka, City of 715 | City 2 | City Agency 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | City 2 | 1419 | Eureka, City of 698 | City 2 | City Agency 2 | Humboldt 45 | 2.7 | 20-30 Park and Playground | 0 | Local Recreation Area 3 | 4 | |
11026 | 11026 | 11025 | {"type": "MultiPolygon", "coordinates": [[[[-121.41422, 38.53219], [-121.41307, 38.5322], [-121.41293, 38.53216], [-121.41289, 38.53211], [-121.41292, 38.53205], [-121.41299, 38.53202], [-121.41418, 38.53201], [-121.41422, 38.53203], [-121.41423, 38.53216], [-121.41422, 38.53219]]], [[[-121.41671, 38.53219], [-121.41443, 38.53219], [-121.41441, 38.53218], [-121.41439, 38.53203], [-121.41442, 38.53202], [-121.41666, 38.53202], [-121.4167, 38.53204], [-121.41671, 38.53219]]], [[[-121.41912, 38.53205], [-121.41898, 38.53229], [-121.4189, 38.53231], [-121.41792, 38.53231], [-121.4169, 38.5322], [-121.41688, 38.53218], [-121.41688, 38.53204], [-121.41691, 38.53202], [-121.41909, 38.53202], [-121.41912, 38.53205]]], [[[-121.42107, 38.53205], [-121.42106, 38.53229], [-121.42104, 38.53231], [-121.41918, 38.5323], [-121.41933, 38.53204], [-121.41937, 38.53202], [-121.42105, 38.53202], [-121.42107, 38.53205]]], [[[-121.42604, 38.53216], [-121.42604, 38.53227], [-121.42601, 38.53228], [-121.42297, 38.53227], [-121.42248, 38.53232], [-121.42127, 38.53231], [-121.42124, 38.53229], [-121.42125, 38.53205], [-121.42128, 38.53203], [-121.42312, 38.53203], [-121.42419, 38.53215], [-121.42604, 38.53216]]], [[[-121.42712, 38.53223], [-121.42711, 38.53225], [-121.42691, 38.53224], [-121.42678, 38.53228], [-121.42624, 38.53228], [-121.42622, 38.53227], [-121.42623, 38.53217], [-121.42624, 38.53215], [-121.42663, 38.53217], [-121.42712, 38.53223]]], [[[-121.4294, 38.53226], [-121.42938, 38.53227], [-121.42797, 38.53227], [-121.42796, 38.53226], [-121.42797, 38.53225], [-121.42818, 38.53225], [-121.4284, 38.53221], [-121.42899, 38.53215], [-121.42939, 38.53214], [-121.4294, 38.53226]]], [[[-121.43268, 38.53204], [-121.43268, 38.53227], [-121.43264, 38.5323], [-121.43224, 38.5323], [-121.43202, 38.53227], [-121.4296, 38.53227], [-121.42959, 38.53226], [-121.42959, 38.53215], [-121.42962, 38.53214], [-121.43036, 38.53214], [-121.43129, 38.53203], [-121.43265, 38.53202], [-121.43268, 38.53204]]], [[[-121.43516, 38.5322], [-121.43456, 38.53227], [-121.43288, 38.5323], [-121.43286, 38.53229], [-121.43286, 38.53204], [-121.43289, 38.53201], [-121.43512, 38.53199], [-121.43515, 38.53201], [-121.43518, 38.53217], [-121.43516, 38.5322]]], [[[-121.43863, 38.53196], [-121.43864, 38.53198], [-121.43853, 38.53212], [-121.43848, 38.53213], [-121.43566, 38.53216], [-121.4354, 38.53219], [-121.43537, 38.53217], [-121.43533, 38.53201], [-121.43535, 38.53198], [-121.43863, 38.53196]]], [[[-121.44204, 38.53208], [-121.44201, 38.53209], [-121.43875, 38.53213], [-121.43874, 38.53211], [-121.43884, 38.53197], [-121.43888, 38.53195], [-121.44129, 38.53192], [-121.44158, 38.53195], [-121.44202, 38.53194], [-121.44204, 38.53195], [-121.44204, 38.53208]]], [[[-121.44318, 38.53193], [-121.44319, 38.53196], [-121.44319, 38.53205], [-121.44317, 38.53206], [-121.44224, 38.53209], [-121.44222, 38.53208], [-121.44222, 38.53196], [-121.44224, 38.53194], [-121.44318, 38.53193]]], [[[-121.44435, 38.53195], [-121.44434, 38.53204], [-121.44432, 38.53206], [-121.44339, 38.53206], [-121.44337, 38.53204], [-121.44338, 38.53195], [-121.4434, 38.53194], [-121.44435, 38.53195]]], [[[-121.44543, 38.53192], [-121.44542, 38.53194], [-121.4452, 38.53199], [-121.4449, 38.53204], [-121.44455, 38.53206], [-121.44453, 38.53203], [-121.44453, 38.53195], [-121.44456, 38.53193], [-121.44543, 38.53192]]]]} | Open Access 1 | 21183 | 21st Avenue Parkway | 15182 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 13.339 | 21st Avenue Parkway | 0 | Local Recreation Area 3 | 4 | |
15709 | 15709 | 15708 | {"type": "Polygon", "coordinates": [[[-122.44016, 37.74009], [-122.43987, 37.7401], [-122.43978, 37.73989], [-122.43976, 37.7398], [-122.43976, 37.73971], [-122.43982, 37.73946], [-122.43984, 37.73932], [-122.43982, 37.73917], [-122.43978, 37.73898], [-122.44007, 37.73898], [-122.44016, 37.74009]]]} | Open Access 1 | 5549 | 298 Berkeley Way Open Space | 15190 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.831 | 298 Berkeley Way OS | 0 | Local Recreation Area 3 | 4 | |
1171 | 1171 | 1170 | {"type": "MultiPolygon", "coordinates": [[[[-117.12486, 32.71786], [-117.12437, 32.71786], [-117.12432, 32.71769], [-117.12428, 32.71748], [-117.12485, 32.71748], [-117.12486, 32.71786]]], [[[-117.12527, 32.7201], [-117.12493, 32.7201], [-117.12493, 32.71957], [-117.12459, 32.71956], [-117.12459, 32.71928], [-117.1244, 32.71927], [-117.1244, 32.71914], [-117.12521, 32.71913], [-117.12522, 32.71925], [-117.12525, 32.71926], [-117.12526, 32.71942], [-117.12527, 32.7201]]], [[[-117.1252, 32.71847], [-117.12449, 32.71847], [-117.12441, 32.71809], [-117.1252, 32.71808], [-117.1252, 32.71847]]], [[[-117.12521, 32.7189], [-117.12456, 32.71891], [-117.12452, 32.71853], [-117.12521, 32.71852], [-117.12521, 32.7189]]], [[[-117.12529, 32.72089], [-117.12494, 32.72089], [-117.12494, 32.72033], [-117.12528, 32.72032], [-117.12529, 32.72089]]], [[[-117.12597, 32.72046], [-117.12554, 32.72046], [-117.12554, 32.72028], [-117.12596, 32.72028], [-117.12597, 32.72046]]], [[[-117.12598, 32.72117], [-117.12554, 32.72117], [-117.12554, 32.72059], [-117.12597, 32.72059], [-117.12598, 32.72117]]], [[[-117.12644, 32.72134], [-117.12644, 32.72193], [-117.12597, 32.72192], [-117.12597, 32.72134], [-117.12644, 32.72134]]], [[[-117.12744, 32.72243], [-117.12743, 32.72304], [-117.12707, 32.72304], [-117.12707, 32.72292], [-117.12704, 32.72291], [-117.12704, 32.72269], [-117.12665, 32.72268], [-117.12666, 32.72243], [-117.12744, 32.72243]]], [[[-117.12744, 32.72221], [-117.12669, 32.72221], [-117.1267, 32.72179], [-117.12703, 32.7218], [-117.12704, 32.72207], [-117.12736, 32.72215], [-117.12743, 32.72215], [-117.12744, 32.72221]]], [[[-117.1283, 32.72411], [-117.12828, 32.72434], [-117.12792, 32.72434], [-117.12792, 32.72404], [-117.12829, 32.72404], [-117.1283, 32.72411]]], [[[-117.12829, 32.7239], [-117.12792, 32.72391], [-117.12792, 32.72377], [-117.12829, 32.72378], [-117.12829, 32.7239]]]]} | Open Access 1 | 7499 | 32nd Street Canyon | 15193 | 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 | 7.011 | 32nd Street Canyon | 0 | Local Recreation Area 3 | 4 | |
16145 | 16145 | 16144 | {"type": "Polygon", "coordinates": [[[-117.12447, 32.72612], [-117.12413, 32.72613], [-117.12412, 32.72547], [-117.12445, 32.72546], [-117.12447, 32.72612]]]} | Open Access 1 | 19921 | 34th St Canyon Open Space | 15194 | 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 | 0.576 | 34th St Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15381 | 15381 | 15380 | {"type": "Polygon", "coordinates": [[[-118.20463, 33.81903], [-118.20462, 33.81984], [-118.20458, 33.82011], [-118.20441, 33.82001], [-118.20429, 33.81989], [-118.20428, 33.81985], [-118.20429, 33.81892], [-118.20458, 33.81893], [-118.20463, 33.81903]]]} | Open Access 1 | 46593 | 34th St Greenbelt | 29894 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.928 | 34th St Greenbelt | 2007 | Local Recreation Area 3 | 4 | |
10 | 10 | 9 | {"type": "MultiPolygon", "coordinates": [[[[-117.09436, 32.74201], [-117.09395, 32.74201], [-117.09393, 32.74146], [-117.09346, 32.74146], [-117.09345, 32.74102], [-117.09291, 32.74017], [-117.09284, 32.74016], [-117.09282, 32.73919], [-117.09236, 32.73919], [-117.09235, 32.7385], [-117.0928, 32.73849], [-117.09279, 32.73755], [-117.09339, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.0936, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09321, 32.73912], [-117.09324, 32.74037], [-117.09385, 32.74037], [-117.09387, 32.74118], [-117.09435, 32.74118], [-117.09436, 32.74201]]], [[[-117.09277, 32.74057], [-117.0927, 32.74058], [-117.09269, 32.74084], [-117.09238, 32.74085], [-117.09238, 32.74039], [-117.09276, 32.74038], [-117.09277, 32.74057]]], [[[-117.09497, 32.74242], [-117.09456, 32.74242], [-117.09456, 32.74223], [-117.09497, 32.74222], [-117.09497, 32.74242]]], [[[-117.09603, 32.7429], [-117.09564, 32.74291], [-117.09564, 32.7427], [-117.09603, 32.7427], [-117.09603, 32.7429]]]]} | Open Access 1 | 31 | 47th Street Canyon | 15202 | 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 | 9.994 | 47th Street Canyon | 0 | Local Recreation Area 3 | 4 | |
971 | 971 | 970 | {"type": "Polygon", "coordinates": [[[-118.20138, 33.84854], [-118.20124, 33.85039], [-118.20107, 33.85039], [-118.20104, 33.85032], [-118.20116, 33.84873], [-118.20105, 33.84872], [-118.20105, 33.84854], [-118.20138, 33.84854]]]} | Open Access 1 | 6612 | 51st St Greenbelt | 29907 | 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 | 1.011 | 51st St Greenbelt | 2008 | Local Recreation Area 3 | 4 | |
5560 | 5560 | 5559 | {"type": "MultiPolygon", "coordinates": [[[[-121.88119, 38.02849], [-121.88109, 38.02875], [-121.87853, 38.02814], [-121.87863, 38.02788], [-121.88119, 38.02849]]], [[[-121.88244, 38.02879], [-121.88234, 38.02905], [-121.88126, 38.02879], [-121.88136, 38.02853], [-121.88244, 38.02879]]], [[[-121.88368, 38.02909], [-121.88358, 38.02935], [-121.88251, 38.0291], [-121.88261, 38.02883], [-121.88368, 38.02909]]], [[[-121.88579, 38.02974], [-121.88574, 38.02987], [-121.88458, 38.02959], [-121.88463, 38.02946], [-121.88579, 38.02974]]], [[[-121.88705, 38.03004], [-121.887, 38.03017], [-121.88591, 38.02991], [-121.88596, 38.02978], [-121.88705, 38.03004]]], [[[-121.88829, 38.03034], [-121.88824, 38.03047], [-121.88716, 38.03021], [-121.88721, 38.03007], [-121.88829, 38.03034]]], [[[-121.88953, 38.03064], [-121.88948, 38.03076], [-121.88841, 38.03051], [-121.88846, 38.03038], [-121.88953, 38.03064]]], [[[-121.8908, 38.03088], [-121.89075, 38.03101], [-121.88965, 38.0308], [-121.8897, 38.03067], [-121.8908, 38.03088]]]]} | Open Access 1 | 26052 | 8th Street Greenbelt | 15219 | 1254 | Pittsburg, City of 384 | City 2 | City Agency 2 | http://www.ci.pittsburg.ca.us/index.aspx?page=238 | City 2 | 1254 | Pittsburg, City of 380 | City 2 | City Agency 2 | Contra Costa 12 | 5.142 | 8th Street Greenbelt | 0 | Local Recreation Area 3 | 4 | |
16245 | 16245 | 16244 | {"type": "Polygon", "coordinates": [[[-118.32437, 33.83122], [-118.32371, 33.83123], [-118.32371, 33.83073], [-118.32329, 33.83036], [-118.32348, 33.83021], [-118.32436, 33.83102], [-118.32437, 33.83122]]]} | Restricted Access 2 | 35907 | ATTIC Teen Center | 32631 | 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 | https://www.torranceca.gov/our-city/recreation/attic | Los Angeles 6 | 1.086 | ATTIC Teen Ctr. | 0 | Local Recreation Area 3 | 4 |
10710 | 10710 | 10709 | {"type": "Polygon", "coordinates": [[[-117.36135, 34.01479], [-117.35954, 34.01846], [-117.35914, 34.01925], [-117.35661, 34.01788], [-117.35432, 34.01711], [-117.35485, 34.01485], [-117.35635, 34.01522], [-117.35656, 34.0142], [-117.35864, 34.01442], [-117.35857, 34.01448], [-117.35858, 34.01449], [-117.36135, 34.01479]]]} | Open Access 1 | 19868 | Ab Brown Sports Complex | 15231 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 53.482 | Ab Brown Sports Complex | 0 | Local Recreation Area 3 | 4 | |
16089 | 16089 | 16088 | {"type": "MultiPolygon", "coordinates": [[[[-117.65834, 33.63936], [-117.65791, 33.63985], [-117.65769, 33.64018], [-117.65763, 33.64016], [-117.65734, 33.64064], [-117.65714, 33.64104], [-117.65692, 33.64165], [-117.65676, 33.642], [-117.6563, 33.64312], [-117.65548, 33.64518], [-117.65519, 33.64594], [-117.65487, 33.64663], [-117.65474, 33.64681], [-117.65423, 33.64747], [-117.65398, 33.64772], [-117.65364, 33.64804], [-117.65261, 33.64895], [-117.6513, 33.64991], [-117.65043, 33.65057], [-117.64983, 33.65107], [-117.64916, 33.65179], [-117.64907, 33.65181], [-117.64887, 33.65169], [-117.64865, 33.65162], [-117.64662, 33.65054], [-117.64659, 33.65047], [-117.64694, 33.6504], [-117.64698, 33.65046], [-117.64707, 33.65054], [-117.6478, 33.65082], [-117.64882, 33.65129], [-117.64891, 33.65131], [-117.64905, 33.6513], [-117.6491, 33.65129], [-117.64919, 33.65122], [-117.64933, 33.65103], [-117.64961, 33.65077], [-117.6499, 33.65049], [-117.65011, 33.65033], [-117.65025, 33.65015], [-117.65043, 33.64997], [-117.65056, 33.64985], [-117.65071, 33.64975], [-117.6508, 33.64965], [-117.65093, 33.64945], [-117.651, 33.64928], [-117.65098, 33.64891], [-117.65144, 33.64875], [-117.65177, 33.64848], [-117.65192, 33.64838], [-117.65203, 33.64828], [-117.6521, 33.64817], [-117.65215, 33.64801], [-117.65216, 33.64787], [-117.65221, 33.64784], [-117.65234, 33.64779], [-117.65248, 33.6477], [-117.65258, 33.64761], [-117.65269, 33.64746], [-117.65278, 33.64729], [-117.65286, 33.6472], [-117.65293, 33.64714], [-117.65315, 33.64703], [-117.65333, 33.64698], [-117.65349, 33.6469], [-117.65363, 33.6468], [-117.65369, 33.64673], [-117.65376, 33.64661], [-117.65382, 33.64639], [-117.65384, 33.64619], [-117.65383, 33.646], [-117.65384, 33.64589], [-117.65388, 33.64577], [-117.65457, 33.64461], [-117.65471, 33.64442], [-117.65492, 33.64422], [-117.65504, 33.64403], [-117.65515, 33.6438], [-117.65545, 33.64338], [-117.65554, 33.6433], [-117.65569, 33.64311], [-117.6558, 33.64302], [-117.65597, 33.6427], [-117.65604, 33.64269], [-117.65616, 33.64251], [-117.65638, 33.64231], [-117.65635, 33.64198], [-117.65556, 33.64203], [-117.65548, 33.64202], [-117.65544, 33.642], [-117.65535, 33.64192], [-117.65534, 33.64185], [-117.65537, 33.64179], [-117.65585, 33.64126], [-117.65594, 33.64103], [-117.65597, 33.64092], [-117.65599, 33.64075], [-117.65596, 33.64059], [-117.65602, 33.64057], [-117.65607, 33.64058], [-117.6562, 33.64054], [-117.65643, 33.64039], [-117.65658, 33.64034], [-117.65664, 33.64028], [-117.65667, 33.6402], [-117.65667, 33.6401], [-117.65662, 33.63999], [-117.65652, 33.63986], [-117.65618, 33.6396], [-117.6559, 33.63962], [-117.65587, 33.63958], [-117.65587, 33.63955], [-117.65602, 33.63949], [-117.65621, 33.63944], [-117.65632, 33.63943], [-117.65641, 33.63952], [-117.65673, 33.63983], [-117.65678, 33.63977], [-117.65689, 33.63976], [-117.65696, 33.63986], [-117.65723, 33.63997], [-117.65726, 33.63996], [-117.65743, 33.63969], [-117.65759, 33.63946], [-117.65764, 33.63936], [-117.65832, 33.6393], [-117.65834, 33.63936]]], [[[-117.65579, 33.6409], [-117.65571, 33.64115], [-117.65559, 33.6413], [-117.65523, 33.64166], [-117.65511, 33.64185], [-117.65497, 33.64244], [-117.65489, 33.64258], [-117.6543, 33.64322], [-117.65407, 33.64341], [-117.65361, 33.64372], [-117.65329, 33.644], [-117.6532, 33.64411], [-117.65314, 33.64421], [-117.65297, 33.64456], [-117.65291, 33.64458], [-117.65286, 33.64457], [-117.65293, 33.64445], [-117.65296, 33.6443], [-117.65293, 33.64419], [-117.65271, 33.64365], [-117.65238, 33.64301], [-117.65199, 33.64317], [-117.65191, 33.64315], [-117.65185, 33.64317], [-117.6518, 33.6432], [-117.65178, 33.64323], [-117.65138, 33.64339], [-117.6513, 33.64328], [-117.65097, 33.64341], [-117.65095, 33.64348], [-117.65082, 33.6435], [-117.65053, 33.64364], [-117.65, 33.64382], [-117.64974, 33.64388], [-117.64952, 33.64388], [-117.64943, 33.64394], [-117.6494, 33.64399], [-117.64939, 33.64411], [-117.64893, 33.64404], [-117.64877, 33.64428], [-117.64872, 33.64433], [-117.64863, 33.6442], [-117.64857, 33.64416], [-117.64841, 33.64412], [-117.64842, 33.6438], [-117.64845, 33.64381], [-117.64848, 33.6438], [-117.64917, 33.64322], [-117.64918, 33.64318], [-117.64916, 33.64315], [-117.64899, 33.64299], [-117.64908, 33.643], [-117.64918, 33.64311], [-117.64925, 33.64315], [-117.64935, 33.64314], [-117.64951, 33.6431], [-117.64981, 33.64296], [-117.65008, 33.64286], [-117.65032, 33.64275], [-117.65089, 33.64259], [-117.65119, 33.64245], [-117.65135, 33.64218], [-117.65146, 33.64207], [-117.65165, 33.64202], [-117.65174, 33.64205], [-117.6518, 33.64204], [-117.6519, 33.64181], [-117.65195, 33.64183], [-117.65197, 33.64209], [-117.65244, 33.64223], [-117.65252, 33.64219], [-117.65256, 33.64211], [-117.65251, 33.64189], [-117.65252, 33.64181], [-117.65262, 33.64162], [-117.65272, 33.64149], [-117.65289, 33.64153], [-117.65302, 33.64149], [-117.6532, 33.64151], [-117.65342, 33.64151], [-117.65355, 33.64152], [-117.65359, 33.64151], [-117.6539, 33.64128], [-117.65435, 33.641], [-117.65435, 33.64099], [-117.65425, 33.6409], [-117.65398, 33.6407], [-117.65409, 33.64053], [-117.6542, 33.64059], [-117.65453, 33.64091], [-117.65455, 33.64096], [-117.65476, 33.64101], [-117.65494, 33.64102], [-117.65502, 33.64095], [-117.6551, 33.64094], [-117.65526, 33.64087], [-117.65534, 33.64082], [-117.65539, 33.64076], [-117.65579, 33.6409]]]]} | Open Access 1 | 12146 | Abanico Open Space | 15234 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 59.824 | Abanico OS | 0 | Local Recreation Area 3 | 4 | |
5044 | 5044 | 5043 | {"type": "Polygon", "coordinates": [[[-117.58063, 33.90172], [-117.58031, 33.90181], [-117.57957, 33.90195], [-117.57947, 33.90164], [-117.57942, 33.90164], [-117.57931, 33.90139], [-117.57926, 33.90133], [-117.57932, 33.90127], [-117.57934, 33.9012], [-117.57948, 33.90119], [-117.5797, 33.90089], [-117.57995, 33.90103], [-117.58024, 33.90127], [-117.58051, 33.90157], [-117.58063, 33.90172]]]} | Open Access 1 | 24637 | Aburndale Recreation Center | 15241 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 2.024 | Aburndale Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16121 | 16121 | 16120 | {"type": "MultiPolygon", "coordinates": [[[[-122.08396, 37.90417], [-122.08306, 37.90454], [-122.08276, 37.90457], [-122.08208, 37.90442], [-122.08195, 37.90475], [-122.08152, 37.90465], [-122.08067, 37.90461], [-122.08068, 37.90321], [-122.07622, 37.90326], [-122.07598, 37.90148], [-122.07495, 37.9014], [-122.07493, 37.90156], [-122.07428, 37.90114], [-122.07444, 37.90093], [-122.07397, 37.90064], [-122.07389, 37.90055], [-122.07468, 37.89993], [-122.07489, 37.89998], [-122.07482, 37.9004], [-122.07567, 37.9006], [-122.07497, 37.90124], [-122.07497, 37.90126], [-122.07596, 37.90134], [-122.07629, 37.90082], [-122.07821, 37.90136], [-122.08168, 37.90319], [-122.08322, 37.90316], [-122.08372, 37.90316], [-122.08379, 37.90337], [-122.08396, 37.90417]]], [[[-122.09885, 37.91022], [-122.09879, 37.91031], [-122.09813, 37.91072], [-122.09776, 37.91138], [-122.09822, 37.9121], [-122.09762, 37.91221], [-122.09646, 37.91191], [-122.09704, 37.91129], [-122.09697, 37.91107], [-122.097, 37.91096], [-122.09696, 37.91084], [-122.09687, 37.91078], [-122.09678, 37.91053], [-122.0959, 37.91019], [-122.09514, 37.91019], [-122.09484, 37.91056], [-122.09479, 37.91081], [-122.09469, 37.91093], [-122.09468, 37.91144], [-122.09435, 37.91123], [-122.09376, 37.91099], [-122.09372, 37.91087], [-122.09328, 37.91059], [-122.09302, 37.91085], [-122.09296, 37.91153], [-122.09325, 37.91172], [-122.09347, 37.91194], [-122.09421, 37.91242], [-122.09431, 37.91274], [-122.09532, 37.91332], [-122.09563, 37.91322], [-122.09607, 37.91391], [-122.09608, 37.91444], [-122.09653, 37.9147], [-122.09605, 37.91518], [-122.09598, 37.91529], [-122.09595, 37.91539], [-122.09558, 37.91539], [-122.09556, 37.91581], [-122.09602, 37.91584], [-122.09609, 37.91605], [-122.09609, 37.91637], [-122.09613, 37.91654], [-122.09621, 37.9167], [-122.09634, 37.91685], [-122.0965, 37.91696], [-122.0967, 37.91706], [-122.09671, 37.91737], [-122.09546, 37.91731], [-122.09277, 37.91729], [-122.09202, 37.9173], [-122.09232, 37.91688], [-122.09242, 37.9162], [-122.09221, 37.91583], [-122.09186, 37.91585], [-122.09129, 37.91565], [-122.09122, 37.91533], [-122.0901, 37.91546], [-122.09002, 37.91557], [-122.08963, 37.91569], [-122.08935, 37.91545], [-122.08923, 37.9152], [-122.08889, 37.91494], [-122.08973, 37.91428], [-122.09039, 37.91344], [-122.08933, 37.9129], [-122.08768, 37.9131], [-122.0847, 37.91239], [-122.08414, 37.91225], [-122.08383, 37.91158], [-122.08286, 37.91134], [-122.08121, 37.91196], [-122.08028, 37.91275], [-122.07987, 37.91206], [-122.07959, 37.91138], [-122.07975, 37.91128], [-122.07989, 37.91111], [-122.07983, 37.91108], [-122.07963, 37.91091], [-122.07947, 37.9105], [-122.07976, 37.9104], [-122.08274, 37.91049], [-122.08284, 37.91045], [-122.08473, 37.91052], [-122.08461, 37.91062], [-122.08456, 37.91076], [-122.08456, 37.91086], [-122.08463, 37.9111], [-122.08465, 37.91133], [-122.08586, 37.91135], [-122.0861, 37.91092], [-122.08612, 37.91058], [-122.08788, 37.91065], [-122.08991, 37.91017], [-122.0987, 37.91016], [-122.09877, 37.9102], [-122.09885, 37.91022]]], [[[-122.0867, 37.9151], [-122.08588, 37.91574], [-122.0838, 37.91717], [-122.08275, 37.91665], [-122.08225, 37.91657], [-122.08182, 37.91635], [-122.0816, 37.91633], [-122.08148, 37.91643], [-122.08077, 37.9164], [-122.08077, 37.91636], [-122.08089, 37.91628], [-122.08092, 37.9163], [-122.08137, 37.91629], [-122.08171, 37.91599], [-122.08186, 37.9161], [-122.08214, 37.91617], [-122.08355, 37.91565], [-122.08535, 37.91504], [-122.08573, 37.91503], [-122.08603, 37.91473], [-122.08652, 37.91476], [-122.0867, 37.9151]]]]} | Open Access 1 | 15920 | Acalanes Ridge Open Space | 15245 | 1371 | Walnut Creek, City of 178 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 178.835 | Acalanes Ridge OS | 0 | Local Recreation Area 3 | 4 | |
6606 | 6606 | 6605 | {"type": "Polygon", "coordinates": [[[-117.29626, 34.52451], [-117.29615, 34.52502], [-117.29604, 34.52542], [-117.29532, 34.52542], [-117.29531, 34.52452], [-117.29626, 34.52451]]]} | Open Access 1 | 4095 | Activities Center | 15251 | 1367 | Victorville, City of 40 | City 2 | City Agency 2 | http://ci.victorville.ca.us/Site/CityDepartments2.aspx?id=522 | City 2 | 1367 | Victorville, City of 39 | City 2 | City Agency 2 | San Bernardino 22 | 1.926 | Activities Ctr. | 0 | Local Recreation Area 3 | 4 | |
6148 | 6148 | 6147 | {"type": "Polygon", "coordinates": [[[-117.0747, 32.78221], [-117.07462, 32.78225], [-117.07456, 32.78235], [-117.07453, 32.78236], [-117.07449, 32.78207], [-117.07319, 32.78207], [-117.07249, 32.782], [-117.07221, 32.78175], [-117.07188, 32.78121], [-117.07462, 32.78164], [-117.0747, 32.78221]]]} | Open Access 1 | 18932 | Adobe Falls Open Space Park | 15271 | 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 | 4.003 | Adobe Falls OS Park | 0 | Local Recreation Area 3 | 4 | |
9653 | 9653 | 9652 | {"type": "Polygon", "coordinates": [[[-122.31492, 37.86324], [-122.31414, 37.86342], [-122.31398, 37.86302], [-122.31476, 37.86281], [-122.31492, 37.86324]]]} | Open Access 1 | 16277 | Adventure Playground | 15278 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.854 | Adventure Playground | 0 | Local Recreation Area 3 | 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]);