units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,394 rows where AGNCY_LEV = 2 sorted by MNG_AG_LEV descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 525
- Los Angeles, City of 485
- San Jose, City of 253
- San Francisco, City and County of 238
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 144
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 90
- Modesto, City of 85
- Santa Rosa, City of 82
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Cruz, City of 72
- Torrance, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- Davis, City of 65
- San Luis Obispo, City of 64
- Santa Barbara, City of 64
- Newport Beach, City of 64
- Glendale, City of 61
- Bakersfield, City of 61
- Manteca, City of 61
- Riverside, City of 60
- …
DES_TP >30
- Local Park 7,352
- Local Recreation Area 1,414
- Local Other or Unknown 661
- Local Conservation Area 149
- Local Historic or Cultural Area 38
- Local Resource Management Area 6
- National Monument or Landmark 5
- State Conservation Area 2
- None 1
- None 1
- National Forest 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 14
- City Agency 10,292
- Open Space District 21
- Recreation/Parks District 19
- County Agency 16
- Non Profit - Other 11
- Commercial 9
- Non Profit - Conservation 7
- State Agency 5
- County Agency - Parks 4
- Other 3
- County Agency - Other 2
- Non Profit - Land Trust 2
- Port/Harbor District 2
- Community Services District 1
ACCESS_TYP 4
- Open Access 9,898
- Restricted Access 260
- No Public Access 207
- Unknown Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4238 | 4238 | 4237 | {"type": "Polygon", "coordinates": [[[-122.38933, 37.7711], [-122.38673, 37.77126], [-122.38667, 37.77089], [-122.38929, 37.77073], [-122.38933, 37.7711]]]} | Open Access 1 | 47889 | Mission Bay Commons | 31834 | 1719 | San Francisco - Office of Community Investment and Infrastructure, City and County of 737 | City 2 | City Agency 2 | https://sfocii.org/ | City 2 | 6121 | MJM Management Group 721 | Private 7 | Commercial 18 | https://missionbayparks.com/mission-bay-commons/ | San Francisco 13 | 2.353 | Mission Bay Commons | None 369 | ||
5056 | 5056 | 5055 | {"type": "Polygon", "coordinates": [[[-117.13499, 32.75509], [-117.13393, 32.75509], [-117.13391, 32.75416], [-117.13499, 32.75415], [-117.13499, 32.75509]]]} | Restricted Access 2 | 46 | San Diego Indoor Soccer Center | 30288 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 6103 | Private Landowner 774 | Private 7 | Other 26 | San Diego 4 | 2.583 | San Diego Indoor Soccer Ctr. | None 416 | |||
6063 | 6063 | 6062 | {"type": "Polygon", "coordinates": [[[-117.68112, 33.95815], [-117.68057, 33.95845], [-117.68019, 33.95877], [-117.67991, 33.95894], [-117.67992, 33.95944], [-117.67986, 33.95958], [-117.67975, 33.95957], [-117.67965, 33.95962], [-117.67871, 33.95935], [-117.67721, 33.96028], [-117.67532, 33.95816], [-117.678, 33.95652], [-117.6807, 33.95757], [-117.68081, 33.9576], [-117.68098, 33.95782], [-117.68101, 33.95788], [-117.68103, 33.95807], [-117.68107, 33.95812], [-117.68112, 33.95815]]]} | Restricted Access 2 | 47366 | Big League Dreams Sports Park | 31089 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 6109 | Big League Dreams 803 | Private 7 | Commercial 18 | https://www.chinohills.org/index.aspx?NID=282 | San Bernardino 22 | 30.171 | Big League Dreams Sports Park | None 489 | ||
7964 | 7964 | 7963 | {"type": "Polygon", "coordinates": [[[-117.2302, 32.9787], [-117.2267, 32.9787], [-117.22602, 32.97873], [-117.22534, 32.9788], [-117.22479, 32.97889], [-117.22042, 32.97969], [-117.21955, 32.97992], [-117.21887, 32.98014], [-117.21805, 32.98047], [-117.21727, 32.98086], [-117.21667, 32.98122], [-117.21597, 32.98171], [-117.21558, 32.98203], [-117.21527, 32.98229], [-117.21193, 32.98539], [-117.19708, 32.98498], [-117.19767, 32.9845], [-117.19804, 32.98428], [-117.19828, 32.98417], [-117.19854, 32.98408], [-117.1988, 32.98401], [-117.19907, 32.98397], [-117.19953, 32.98396], [-117.19998, 32.98401], [-117.20025, 32.98407], [-117.20168, 32.9845], [-117.20205, 32.98458], [-117.20243, 32.98461], [-117.20292, 32.9846], [-117.2034, 32.98452], [-117.20381, 32.9844], [-117.20424, 32.98421], [-117.20464, 32.98396], [-117.20498, 32.98366], [-117.20526, 32.98332], [-117.20547, 32.98297], [-117.20562, 32.98262], [-117.20571, 32.98225], [-117.20582, 32.98083], [-117.20589, 32.98046], [-117.20601, 32.98017], [-117.20618, 32.9799], [-117.20636, 32.97968], [-117.2066, 32.97945], [-117.20691, 32.97923], [-117.20857, 32.97828], [-117.21102, 32.97656], [-117.21139, 32.97633], [-117.21164, 32.97622], [-117.21189, 32.97613], [-117.21397, 32.97552], [-117.21428, 32.9754], [-117.21542, 32.97486], [-117.21575, 32.97475], [-117.21615, 32.97465], [-117.21644, 32.97461], [-117.21672, 32.97459], [-117.21775, 32.97456], [-117.2182, 32.97459], [-117.21854, 32.97465], [-117.21886, 32.97473], [-117.22019, 32.97526], [-117.22051, 32.97536], [-117.22083, 32.97543], [-117.22123, 32.97548], [-117.22283, 32.97555], [-117.22461, 32.97568], [-117.22508, 32.97568], [-117.22555, 32.97562], [-117.2259, 32.97554], [-117.22674, 32.97528], [-117.22711, 32.9752], [-117.22829, 32.97511], [-117.22878, 32.9751], [-117.22924, 32.97513], [-117.22961, 32.97519], [-117.23009, 32.97532], [-117.23012, 32.97534], [-117.23013, 32.97537], [-117.2302, 32.9787]]]} | Restricted Access 2 | 47733 | Fairbanks Ranch Country Club | 31535 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 7021 | Bay Club 860 | Private 7 | Commercial 18 | https://www.bayclubs.com/fairbanksranch/ | San Diego 4 | 372.882 | Fairbanks Ranch Country Club | None 664 | ||
9772 | 9772 | 9771 | {"type": "MultiPolygon", "coordinates": [[[[-122.39652, 37.77142], [-122.39227, 37.77478], [-122.39203, 37.77458], [-122.39628, 37.77123], [-122.39652, 37.77142]]], [[[-122.39537, 37.77404], [-122.39525, 37.77413], [-122.39481, 37.77378], [-122.39299, 37.77522], [-122.39294, 37.77518], [-122.39286, 37.77525], [-122.39276, 37.77517], [-122.39479, 37.77357], [-122.39537, 37.77404]]], [[[-122.39716, 37.77193], [-122.39526, 37.77343], [-122.39526, 37.77344], [-122.3957, 37.77379], [-122.39558, 37.77388], [-122.39499, 37.77341], [-122.39701, 37.77181], [-122.39716, 37.77193]]], [[[-122.39942, 37.77078], [-122.39941, 37.77085], [-122.39774, 37.77216], [-122.39759, 37.77195], [-122.39745, 37.77171], [-122.39736, 37.77177], [-122.39722, 37.77165], [-122.3985, 37.77064], [-122.39833, 37.77], [-122.39673, 37.77126], [-122.39648, 37.77107], [-122.39809, 37.7698], [-122.39821, 37.76989], [-122.39852, 37.76986], [-122.3991, 37.77033], [-122.39914, 37.77056], [-122.39942, 37.77078]]]]} | Open Access 1 | 47888 | Mission Creek Park | 31833 | 1719 | San Francisco - Office of Community Investment and Infrastructure, City and County of 737 | City 2 | City Agency 2 | https://sfocii.org/ | City 2 | 6121 | MJM Management Group 721 | Private 7 | Commercial 18 | https://missionbayparks.com/mission-creek-park/ | San Francisco 13 | 12.578 | Mission Creek Park | None 845 | ||
11514 | 11514 | 11513 | {"type": "MultiPolygon", "coordinates": [[[[-118.125, 33.83134], [-118.12499, 33.83168], [-118.12426, 33.83168], [-118.12426, 33.83134], [-118.125, 33.83134]]], [[[-118.12601, 33.83154], [-118.12534, 33.83154], [-118.12534, 33.83085], [-118.12601, 33.83085], [-118.12601, 33.83154]]]]} | No Public Access 3 | 48218 | Heartwell Park | 32767 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 6103 | Private Landowner 774 | Private 7 | Other 26 | Los Angeles 6 | 1.82 | Heartwell Park | None 1023 | |||
11516 | 11516 | 11515 | {"type": "Polygon", "coordinates": [[[-118.18686, 33.84556], [-118.18686, 33.84557], [-118.18512, 33.84616], [-118.18512, 33.84532], [-118.18565, 33.8453], [-118.18613, 33.84533], [-118.18647, 33.84542], [-118.18686, 33.84556]]]} | Restricted Access 2 | 48222 | Scherer Park | 32775 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 6103 | Private Landowner 774 | Private 7 | Other 26 | Los Angeles 6 | 2.201 | Scherer Park | None 1024 | |||
14688 | 14688 | 14687 | {"type": "Polygon", "coordinates": [[[-117.93807, 34.01787], [-117.9369, 34.02264], [-117.93682, 34.02264], [-117.9367, 34.02287], [-117.93573, 34.02327], [-117.93478, 34.02326], [-117.93448, 34.02322], [-117.93398, 34.02336], [-117.93332, 34.02341], [-117.93268, 34.02377], [-117.93232, 34.02429], [-117.93221, 34.02464], [-117.93236, 34.02535], [-117.93261, 34.02577], [-117.9329, 34.02604], [-117.93359, 34.02641], [-117.93493, 34.02691], [-117.93511, 34.02717], [-117.93532, 34.02753], [-117.93534, 34.02768], [-117.93528, 34.02789], [-117.93341, 34.02785], [-117.93283, 34.02778], [-117.93226, 34.02768], [-117.92284, 34.02511], [-117.92244, 34.02505], [-117.91796, 34.02461], [-117.91792, 34.02459], [-117.9179, 34.02456], [-117.9179, 34.02452], [-117.92008, 34.01904], [-117.92158, 34.01919], [-117.92157, 34.01914], [-117.9201, 34.01899], [-117.92078, 34.01727], [-117.92095, 34.0169], [-117.92116, 34.01651], [-117.92171, 34.01558], [-117.9217, 34.01556], [-117.9221, 34.01491], [-117.93046, 34.01574], [-117.9371, 34.0177], [-117.93807, 34.01787]]]} | Restricted Access 2 | 45010 | Industry Hills Golf Club | 29719 | 1146 | Industry, City of 1119 | City 2 | City Agency 2 | http://www.cityofindustry.org/ | City 2 | 6108 | Los Angeles Golf Club 1073 | Private 7 | Commercial 18 | http://www.ihgolfclub.com/ | Los Angeles 6 | 430.082 | Industry Hills Golf Club | None 1257 | ||
15379 | 15379 | 15378 | {"type": "Polygon", "coordinates": [[[-117.91257, 34.03967], [-117.91245, 34.03993], [-117.91203, 34.04013], [-117.91193, 34.04047], [-117.91214, 34.04078], [-117.912, 34.04119], [-117.91145, 34.0417], [-117.91066, 34.04186], [-117.91045, 34.04181], [-117.90909, 34.04119], [-117.90866, 34.0401], [-117.90908, 34.03917], [-117.90923, 34.03897], [-117.90946, 34.03861], [-117.90968, 34.03813], [-117.90979, 34.03808], [-117.91005, 34.03812], [-117.91031, 34.03814], [-117.91058, 34.03814], [-117.91129, 34.03809], [-117.91192, 34.03815], [-117.91189, 34.03836], [-117.91225, 34.0388], [-117.91242, 34.03907], [-117.91257, 34.03967]]]} | Restricted Access 2 | 46592 | Big League Dreams Sportsplex | 29897 | 1374 | West Covina, City of 318 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 6109 | Big League Dreams 803 | Private 7 | Commercial 18 | Los Angeles 6 | 27.328 | Big League Dreams Sportsplex | None 1357 | |||
15654 | 15654 | 15653 | {"type": "MultiPolygon", "coordinates": [[[[-117.09268, 33.16118], [-117.09263, 33.16144], [-117.09239, 33.1623], [-117.09172, 33.16442], [-117.09132, 33.16557], [-117.09126, 33.16559], [-117.09122, 33.16558], [-117.09117, 33.16553], [-117.09112, 33.16552], [-117.09095, 33.1655], [-117.09109, 33.16538], [-117.09084, 33.16498], [-117.09075, 33.16478], [-117.09071, 33.16458], [-117.09071, 33.16438], [-117.09076, 33.16417], [-117.09092, 33.16373], [-117.09086, 33.16352], [-117.09003, 33.16299], [-117.08995, 33.16301], [-117.08984, 33.16316], [-117.0898, 33.16374], [-117.09023, 33.1638], [-117.09023, 33.16386], [-117.0898, 33.1638], [-117.08972, 33.1645], [-117.08977, 33.16477], [-117.08983, 33.16503], [-117.08993, 33.16525], [-117.09006, 33.1655], [-117.09025, 33.1657], [-117.09055, 33.16553], [-117.09067, 33.16561], [-117.09073, 33.16569], [-117.09088, 33.16575], [-117.09098, 33.16581], [-117.09117, 33.16582], [-117.0912, 33.16588], [-117.09069, 33.16732], [-117.09045, 33.16811], [-117.09031, 33.1682], [-117.08999, 33.16812], [-117.08956, 33.1681], [-117.08947, 33.16806], [-117.08938, 33.16805], [-117.08929, 33.16808], [-117.08918, 33.16816], [-117.08894, 33.16826], [-117.08883, 33.16821], [-117.08896, 33.16797], [-117.08906, 33.1677], [-117.08909, 33.16741], [-117.08905, 33.16713], [-117.08871, 33.16584], [-117.08859, 33.16494], [-117.0884, 33.16417], [-117.08837, 33.16359], [-117.08815, 33.16355], [-117.08817, 33.16349], [-117.08816, 33.16345], [-117.08821, 33.16335], [-117.08822, 33.16322], [-117.08826, 33.16313], [-117.08827, 33.16306], [-117.08823, 33.16297], [-117.08815, 33.1629], [-117.08795, 33.16256], [-117.08797, 33.16246], [-117.08897, 33.16188], [-117.0893, 33.16172], [-117.0897, 33.16157], [-117.08991, 33.1615], [-117.09033, 33.1614], [-117.09069, 33.16135], [-117.09263, 33.16112], [-117.09268, 33.16118]]], [[[-117.0949, 33.17091], [-117.09272, 33.17091], [-117.08993, 33.17091], [-117.09066, 33.1685], [-117.0928, 33.1691], [-117.09489, 33.16975], [-117.09493, 33.16981], [-117.09491, 33.16997], [-117.0949, 33.17091]]], [[[-117.09702, 33.17023], [-117.0954, 33.16973], [-117.0954, 33.16968], [-117.09404, 33.16924], [-117.09211, 33.16867], [-117.09084, 33.16831], [-117.09344, 33.16883], [-117.09504, 33.16905], [-117.09539, 33.16912], [-117.09576, 33.16927], [-117.09604, 33.16943], [-117.09629, 33.16963], [-117.09644, 33.16979], [-117.09662, 33.16997], [-117.09679, 33.1701], [-117.09702, 33.17023]]]]} | Restricted Access 2 | 644 | Reidy Creek Golf Course | 31473 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 7017 | JC Resorts 1102 | Private 7 | Commercial 18 | https://www.jcgolf.com/san-diego-golf-courses/reidy-creek/ | San Diego 4 | 70.314 | Reidy Creek GC | None 1366 | ||
15661 | 15661 | 15660 | {"type": "Polygon", "coordinates": [[[-117.0607, 33.0691], [-117.06056, 33.0691], [-117.06032, 33.06962], [-117.06013, 33.07022], [-117.05995, 33.07071], [-117.05868, 33.07381], [-117.05857, 33.07384], [-117.05197, 33.07314], [-117.05161, 33.07306], [-117.05013, 33.07263], [-117.0498, 33.07251], [-117.05015, 33.07117], [-117.05011, 33.07055], [-117.05001, 33.07054], [-117.04992, 33.07055], [-117.04996, 33.07112], [-117.04961, 33.07247], [-117.04858, 33.07215], [-117.04909, 33.07113], [-117.0494, 33.07036], [-117.04945, 33.07026], [-117.04955, 33.07011], [-117.04976, 33.0699], [-117.05022, 33.06955], [-117.05031, 33.06955], [-117.05047, 33.06965], [-117.05065, 33.06972], [-117.05062, 33.06978], [-117.0506, 33.07004], [-117.0516, 33.07009], [-117.05241, 33.06989], [-117.05259, 33.07037], [-117.0535, 33.07117], [-117.05388, 33.0709], [-117.05426, 33.07057], [-117.05466, 33.07008], [-117.05485, 33.06937], [-117.05529, 33.06938], [-117.05577, 33.06924], [-117.05643, 33.06865], [-117.05688, 33.06907], [-117.05753, 33.06844], [-117.05702, 33.06809], [-117.05754, 33.06758], [-117.05804, 33.06727], [-117.05897, 33.06796], [-117.05895, 33.06799], [-117.05978, 33.06862], [-117.0607, 33.0691]]]} | Restricted Access 2 | 4951 | The Vineyard at Escondido Golf Course | 31472 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 6098 | American Golf 1103 | Private 7 | Commercial 18 | http://www.vineyardatescondido.com/?doubleclick=false | San Diego 4 | 105.386 | The Vineyard at Escondido GC | None 1367 | ||
17053 | 17053 | 17052 | {"type": "Polygon", "coordinates": [[[-118.20385, 34.15912], [-118.20364, 34.15913], [-118.20283, 34.15904], [-118.20265, 34.15903], [-118.20242, 34.15906], [-118.20215, 34.15918], [-118.20198, 34.15931], [-118.20187, 34.15946], [-118.20181, 34.15961], [-118.20163, 34.16029], [-118.20152, 34.16049], [-118.20134, 34.16069], [-118.20113, 34.16084], [-118.20035, 34.16128], [-118.19998, 34.16144], [-118.19952, 34.16158], [-118.19932, 34.16163], [-118.19902, 34.16167], [-118.19849, 34.16169], [-118.19592, 34.16158], [-118.19553, 34.16156], [-118.19518, 34.16157], [-118.19473, 34.16163], [-118.19442, 34.1617], [-118.19389, 34.16188], [-118.19365, 34.16167], [-118.19365, 34.16163], [-118.19384, 34.16147], [-118.19386, 34.16142], [-118.19384, 34.16133], [-118.19377, 34.1612], [-118.19376, 34.16113], [-118.19382, 34.16092], [-118.19381, 34.16077], [-118.19383, 34.16072], [-118.19397, 34.16063], [-118.19415, 34.16047], [-118.1942, 34.16046], [-118.19428, 34.16047], [-118.19437, 34.16057], [-118.19449, 34.16065], [-118.19459, 34.16067], [-118.19469, 34.16066], [-118.19481, 34.16059], [-118.19508, 34.16038], [-118.1952, 34.16036], [-118.19532, 34.16032], [-118.19559, 34.16013], [-118.19567, 34.16001], [-118.19576, 34.15995], [-118.19586, 34.15985], [-118.19589, 34.15979], [-118.1959, 34.1593], [-118.19593, 34.15921], [-118.19598, 34.15913], [-118.19606, 34.15906], [-118.19614, 34.15902], [-118.19629, 34.15897], [-118.1965, 34.15894], [-118.19678, 34.15894], [-118.19707, 34.15878], [-118.19761, 34.15832], [-118.19787, 34.15792], [-118.19805, 34.15789], [-118.1985, 34.1582], [-118.19855, 34.15817], [-118.19866, 34.15816], [-118.199, 34.15799], [-118.1992, 34.15792], [-118.19932, 34.15784], [-118.19949, 34.15777], [-118.19957, 34.1577], [-118.19971, 34.15763], [-118.19978, 34.1576], [-118.19992, 34.15761], [-118.20004, 34.15771], [-118.2004, 34.15772], [-118.20115, 34.15799], [-118.20281, 34.15819], [-118.20278, 34.1576], [-118.20345, 34.15779], [-118.20361, 34.15821], [-118.20366, 34.15888], [-118.20384, 34.15885], [-118.20385, 34.15912]]]} | Restricted Access 2 | 6955 | Scholl Canyon Golf Course & Tennis Center | 29385 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 6098 | American Golf 1103 | Private 7 | Commercial 18 | http://www.schollcanyongc.com/ | Los Angeles 6 | 60.199 | Scholl Canyon GC & Tennis Ctr. | None 1427 | ||
2489 | 2489 | 2488 | {"type": "Polygon", "coordinates": [[[-122.44958, 37.76633], [-122.44898, 37.76641], [-122.44881, 37.76647], [-122.44849, 37.76654], [-122.44848, 37.76657], [-122.44806, 37.76662], [-122.44802, 37.76642], [-122.44844, 37.76637], [-122.44846, 37.7664], [-122.44872, 37.76635], [-122.44892, 37.76627], [-122.44902, 37.7662], [-122.44899, 37.76602], [-122.4495, 37.76595], [-122.44958, 37.76633]]]} | Open Access 1 | 48909 | Richard Gamble Memorial Park | 33627 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/gamble-memorial-park | San Francisco 13 | 0.912 | Richard Gamble Memorial Park | None 205 | ||
3034 | 3034 | 3033 | {"type": "Polygon", "coordinates": [[[-122.39104, 37.75772], [-122.39035, 37.75777], [-122.39033, 37.7576], [-122.39101, 37.75756], [-122.39104, 37.75772]]]} | Open Access 1 | 48833 | Woods Yard | 33552 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/woods-yard | San Francisco 13 | 0.275 | Woods Yard | None 249 | ||
3568 | 3568 | 3567 | {"type": "Polygon", "coordinates": [[[-117.12444, 32.57552], [-117.12422, 32.57552], [-117.12425, 32.57652], [-117.12305, 32.57652], [-117.12307, 32.5737], [-117.12357, 32.57366], [-117.12388, 32.57374], [-117.12399, 32.57387], [-117.12401, 32.57408], [-117.12442, 32.57408], [-117.12444, 32.57552]]]} | Open Access 1 | 439 | Imperial Beach Sports Park | 31474 | 1143 | Imperial Beach, City of 630 | City 2 | City Agency 2 | http://www.imperialbeachca.gov/index.asp?Type=B_BASIC&SEC={9F232DF8-5366-4BA2-A4B8-8795196F6D81} | City 2 | 7018 | Boys and Girls Clubs of South County 649 | Non Profit 6 | Non Profit - Other 20 | http://www.bgcscounty.org/portal/home | San Diego 4 | 8.985 | Imperial Beach Sports Park | None 298 | ||
3710 | 3710 | 3709 | {"type": "Polygon", "coordinates": [[[-117.12997, 34.00757], [-117.12565, 34.00736], [-117.12569, 34.01105], [-117.12135, 34.01083], [-117.12136, 34.0124], [-117.11672, 34.01318], [-117.11671, 34.01471], [-117.11253, 34.01494], [-117.11247, 34.01855], [-117.11191, 34.01851], [-117.1119, 34.01823], [-117.11177, 34.01822], [-117.1117, 34.01827], [-117.11153, 34.01825], [-117.11138, 34.01805], [-117.11128, 34.01822], [-117.11086, 34.01823], [-117.10962, 34.01775], [-117.10954, 34.01781], [-117.10954, 34.01786], [-117.10942, 34.01774], [-117.10934, 34.01772], [-117.10927, 34.01772], [-117.10918, 34.01753], [-117.10925, 34.01752], [-117.10915, 34.01654], [-117.10816, 34.01601], [-117.10719, 34.01448], [-117.10708, 34.0126], [-117.10573, 34.01116], [-117.10685, 34.01022], [-117.10756, 34.01071], [-117.11261, 34.01028], [-117.1126, 34.01067], [-117.11262, 34.01068], [-117.11494, 34.0093], [-117.1164, 34.00859], [-117.11749, 34.00742], [-117.11913, 34.0066], [-117.11913, 34.00658], [-117.11825, 34.00577], [-117.11884, 34.00524], [-117.11984, 34.00498], [-117.12059, 34.00429], [-117.12243, 34.00429], [-117.12244, 34.00434], [-117.12273, 34.00488], [-117.12362, 34.00456], [-117.12395, 34.00465], [-117.12397, 34.00461], [-117.12449, 34.00464], [-117.12498, 34.0043], [-117.12991, 34.0043], [-117.12997, 34.00757]]]} | Open Access 1 | 48815 | Live Oak Canyon Open Space | 33535 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 3302 | Redlands Conservancy 660 | Non Profit 6 | Non Profit - Other 20 | San Bernardino 22 | 338.281 | Live Oak Canyon OS | None 309 | |||
5615 | 5615 | 5614 | {"type": "Polygon", "coordinates": [[[-117.76036, 33.6333], [-117.76003, 33.63457], [-117.75946, 33.63534], [-117.75959, 33.6366], [-117.75799, 33.63627], [-117.75777, 33.63505], [-117.75816, 33.6341], [-117.75829, 33.63301], [-117.75797, 33.63238], [-117.75941, 33.63136], [-117.7596, 33.63046], [-117.75905, 33.62932], [-117.75748, 33.62811], [-117.75568, 33.62795], [-117.75455, 33.62681], [-117.75287, 33.62703], [-117.75232, 33.62772], [-117.75125, 33.62754], [-117.75066, 33.62795], [-117.75052, 33.62877], [-117.75004, 33.62956], [-117.75011, 33.62997], [-117.75038, 33.63063], [-117.75039, 33.63152], [-117.75084, 33.63193], [-117.75088, 33.63311], [-117.75252, 33.63418], [-117.75221, 33.63484], [-117.75027, 33.63452], [-117.74936, 33.63421], [-117.7489, 33.63359], [-117.74782, 33.63285], [-117.74759, 33.63246], [-117.74669, 33.63253], [-117.74542, 33.63182], [-117.74514, 33.63121], [-117.74443, 33.63138], [-117.74373, 33.6308], [-117.74323, 33.63067], [-117.74136, 33.63063], [-117.74312, 33.6255], [-117.74522, 33.62259], [-117.74536, 33.6226], [-117.74545, 33.62255], [-117.7455, 33.6224], [-117.74551, 33.62219], [-117.74782, 33.61898], [-117.75092, 33.62051], [-117.75177, 33.62228], [-117.75343, 33.62336], [-117.75265, 33.62571], [-117.75349, 33.62666], [-117.75634, 33.62553], [-117.75672, 33.6262], [-117.75716, 33.62638], [-117.75796, 33.62735], [-117.75843, 33.62773], [-117.76007, 33.62971], [-117.76009, 33.62994], [-117.76033, 33.63064], [-117.75978, 33.63132], [-117.75978, 33.63168], [-117.75996, 33.63186], [-117.75977, 33.63245], [-117.76002, 33.63296], [-117.76036, 33.6333]]]} | No Public Access 3 | 47477 | Veeh Creek | 31199 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3257 | Irvine Ranch Conservancy 790 | Non Profit 6 | Non Profit - Conservation 12 | Orange 3 | 309.589 | Veeh Creek | None 452 | |||
7480 | 7480 | 7479 | {"type": "Polygon", "coordinates": [[[-118.12811, 34.11951], [-118.12805, 34.11968], [-118.1278, 34.11974], [-118.12742, 34.11973], [-118.1274, 34.11975], [-118.12724, 34.11968], [-118.12728, 34.11907], [-118.1277, 34.11898], [-118.1279, 34.1189], [-118.12811, 34.11951]]]} | Open Access 1 | 7004 | The Old Mill | 28251 | 1309 | San Marino, City of 335 | City 2 | City Agency 2 | http://www.cityofsanmarino.org/275/Parks | City 2 | 3354 | The Old Mill Foundation 845 | Non Profit 6 | Non Profit - Conservation 12 | http://www.old-mill.org/ | Los Angeles 6 | 1.424 | The Old Mill | None 621 | ||
7950 | 7950 | 7949 | {"type": "Polygon", "coordinates": [[[-117.01166, 33.09834], [-117.00724, 33.09846], [-117.00721, 33.10173], [-117.00292, 33.10171], [-117.00293, 33.1048], [-117.00284, 33.10489], [-117.00279, 33.10502], [-117.00276, 33.10523], [-117.00281, 33.1053], [-116.99808, 33.10533], [-116.99803, 33.10898], [-116.98097, 33.10899], [-116.98096, 33.10543], [-116.96332, 33.10566], [-116.96371, 33.09511], [-116.96367, 33.09348], [-116.96393, 33.09332], [-116.96428, 33.09317], [-116.96446, 33.09312], [-116.96564, 33.09286], [-116.96609, 33.09274], [-116.96856, 33.0918], [-116.96876, 33.09173], [-116.96925, 33.09162], [-116.97152, 33.09125], [-116.97191, 33.09117], [-116.97461, 33.09036], [-116.97866, 33.08928], [-116.97854, 33.08932], [-116.97856, 33.09035], [-116.98186, 33.09031], [-116.99163, 33.08849], [-116.99171, 33.08887], [-116.99197, 33.08955], [-116.99249, 33.09015], [-116.99317, 33.09071], [-116.99366, 33.09108], [-116.99411, 33.09135], [-116.99459, 33.0916], [-116.99501, 33.09177], [-116.99945, 33.09342], [-117.00223, 33.09441], [-117.00239, 33.09428], [-117.00232, 33.09447], [-117.00438, 33.09522], [-117.00503, 33.09542], [-117.00567, 33.09558], [-117.00623, 33.09569], [-117.00687, 33.09579], [-117.01086, 33.09625], [-117.01126, 33.09635], [-117.01148, 33.09642], [-117.01165, 33.0965], [-117.01166, 33.09834]]]} | Open Access 1 | 47725 | San Diego Safari Park | 31513 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 7020 | San Diego Zoo Global 858 | Non Profit 6 | Non Profit - Other 20 | http://sdzsafaripark.org/ | San Diego 4 | 1699.918 | San Diego Safari Park | None 662 | ||
9507 | 9507 | 9506 | {"type": "Polygon", "coordinates": [[[-117.77532, 34.12952], [-117.77504, 34.12945], [-117.77433, 34.1294], [-117.77405, 34.12932], [-117.77412, 34.12916], [-117.77405, 34.12898], [-117.77414, 34.12894], [-117.77431, 34.1287], [-117.77434, 34.12868], [-117.77432, 34.1286], [-117.7742, 34.12857], [-117.77402, 34.12834], [-117.77396, 34.12824], [-117.77394, 34.12812], [-117.77421, 34.12799], [-117.77383, 34.12742], [-117.774, 34.1274], [-117.77418, 34.12741], [-117.77492, 34.12751], [-117.77483, 34.12784], [-117.77483, 34.12796], [-117.77491, 34.12831], [-117.77504, 34.12875], [-117.77512, 34.12876], [-117.77516, 34.12873], [-117.77532, 34.12952]]]} | Restricted Access 2 | 47831 | La Verne Heritage Foundation | 31773 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 3382 | La Verne Heritage Foundation 888 | Non Profit 6 | Non Profit - Other 20 | Los Angeles 6 | 4.634 | La Verne Heritage Foundation | None 788 |
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]);