units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 183
- Los Angeles, City of 102
- San Francisco, City and County of 58
- Mountains Recreation and Conservation Authority 51
- Conejo Open Space Conservation Agency 28
- Los Angeles, County of 27
- East Bay Regional Park District 26
- Las Virgenes Municipal Water District 24
- San Luis Obispo, City of 23
- Davis, City of 23
- Long Beach, City of 19
- Santa Clarita, City of 18
- Glendale, City of 17
- Santa Barbara, County of 16
- Vacaville, City of 16
- San Jose, City of 15
- Sacramento, City of 15
- Los Angeles - Department of Parks and Recreation, County of 14
- Thousand Oaks, City of 14
- Santa Cruz, City of 13
- Tiburon, Town of 13
- Oakland, City of 12
- Fullerton, City of 12
- Carlsbad, City of 12
- San Marcos, City of 12
- Sunrise Recreation and Park District 12
- San Bernardino, City of 11
- Littlerock Creek Irrigation District 11
- Conejo Recreation and Park District 10
- Poway, City of 10
- …
MNG_AG_TYP 17
- City Agency 1,214
- Recreation/Parks District 145
- County Agency 105
- Open Space District 80
- Water District 61
- County Agency - Parks 34
- Irrigation District 21
- Community Services District 11
- Flood District 5
- School District 5
- County Agency - Other 4
- Port/Harbor District 4
- Special District - Other 4
- Cemetery District 2
- Sanitation District 2
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 1,393
- Restricted Access 200
- No Public Access 93
- Unknown Access 13
DES_TP 1
- Local Recreation Area · 1,699 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3556 | 3556 | 3555 | {"type": "Polygon", "coordinates": [[[-117.23771, 32.92887], [-117.23764, 32.92911], [-117.23752, 32.9294], [-117.23732, 32.92977], [-117.23735, 32.9298], [-117.23727, 32.92994], [-117.23672, 32.93067], [-117.23651, 32.93102], [-117.23436, 32.93101], [-117.23431, 32.92669], [-117.23586, 32.92657], [-117.23762, 32.92885], [-117.23771, 32.92887]]]} | Open Access 1 | 12154 | Arroyo Sorrento Open Space | 15633 | 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 | 29.661 | Arroyo Sorrento OS | 0 | Local Recreation Area 3 | 4 | |
3562 | 3562 | 3561 | {"type": "Polygon", "coordinates": [[[-119.25831, 35.7417], [-119.2583, 35.74291], [-119.25009, 35.74289], [-119.24959, 35.74256], [-119.24962, 35.74173], [-119.25831, 35.7417]]]} | Open Access 1 | 28352 | Soccer Park | 25588 | 1084 | Delano, City of 442 | City 2 | City Agency 2 | http://www.cityofdelano.org/index.aspx?NID=90 | City 2 | 1084 | Delano, City of 436 | City 2 | City Agency 2 | Kern 36 | 25.252 | Soccer Park | 0 | Local Recreation Area 3 | 4 | |
3569 | 3569 | 3568 | {"type": "Polygon", "coordinates": [[[-122.22826, 37.7939], [-122.22801, 37.79472], [-122.22759, 37.79463], [-122.22784, 37.79382], [-122.22826, 37.7939]]]} | Open Access 1 | 13339 | Manzanita Recreation Center | 30894 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/s/facility/OAK029390 | Alameda 17 | 0.877 | Manzanita Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
3572 | 3572 | 3571 | {"type": "Polygon", "coordinates": [[[-118.4037, 34.2292], [-118.40363, 34.22925], [-118.40364, 34.22929], [-118.40362, 34.22931], [-118.40221, 34.23034], [-118.40077, 34.22897], [-118.40228, 34.22787], [-118.4037, 34.2292]]]} | Open Access 1 | 519 | Fernangeles Recreation Center | 18880 | 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 | 9.262 | Fernangeles Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
3624 | 3624 | 3623 | {"type": "Polygon", "coordinates": [[[-121.70748, 37.99957], [-121.7053, 37.99809], [-121.70531, 37.9979], [-121.70746, 37.99794], [-121.70748, 37.99957]]]} | Open Access 1 | 29411 | BB Delta Shoreline Trail | 15905 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.739 | BB Delta Shoreline Trail | 0 | Local Recreation Area 3 | 4 | |
3638 | 3638 | 3637 | {"type": "Polygon", "coordinates": [[[-121.26288, 38.75472], [-121.26165, 38.75576], [-121.26024, 38.75636], [-121.2599, 38.75658], [-121.25957, 38.75693], [-121.25942, 38.7572], [-121.25928, 38.75719], [-121.25913, 38.75715], [-121.25811, 38.75675], [-121.2583, 38.75636], [-121.25846, 38.75613], [-121.25865, 38.75607], [-121.25897, 38.75611], [-121.25927, 38.75602], [-121.25879, 38.75582], [-121.25853, 38.75577], [-121.25864, 38.75568], [-121.25905, 38.75576], [-121.2594, 38.75588], [-121.25963, 38.7556], [-121.2597, 38.75563], [-121.25996, 38.75532], [-121.26004, 38.75535], [-121.2604, 38.75492], [-121.26036, 38.75477], [-121.26023, 38.7547], [-121.26041, 38.75449], [-121.26063, 38.75445], [-121.26067, 38.75462], [-121.26083, 38.75481], [-121.2612, 38.75475], [-121.26116, 38.75458], [-121.26112, 38.75458], [-121.26108, 38.75438], [-121.26112, 38.75435], [-121.26136, 38.75427], [-121.26158, 38.75423], [-121.26148, 38.75381], [-121.26193, 38.75408], [-121.2621, 38.75415], [-121.26238, 38.75435], [-121.2627, 38.75464], [-121.26288, 38.75472]], [[-121.26236, 38.75516], [-121.26236, 38.75514], [-121.26206, 38.75493], [-121.26189, 38.75488], [-121.26133, 38.75524], [-121.26147, 38.75549], [-121.26154, 38.75545], [-121.26208, 38.75534], [-121.26236, 38.75516]]]} | Open Access 1 | 29478 | Miner's Ravine Trail | 22260 | 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 | 12.44 | Miner's Ravine Trail | 0 | Local Recreation Area 3 | 4 | |
3643 | 3643 | 3642 | {"type": "Polygon", "coordinates": [[[-117.05646, 34.07589], [-117.05605, 34.07592], [-117.05567, 34.07597], [-117.05538, 34.07542], [-117.05514, 34.07532], [-117.05489, 34.07538], [-117.05484, 34.07531], [-117.0549, 34.07522], [-117.05473, 34.07516], [-117.05384, 34.07497], [-117.05337, 34.07475], [-117.05234, 34.07447], [-117.0519, 34.0745], [-117.05123, 34.07449], [-117.05063, 34.07436], [-117.04996, 34.0743], [-117.0496, 34.07422], [-117.04925, 34.07419], [-117.04869, 34.0742], [-117.04823, 34.07398], [-117.04784, 34.07399], [-117.04771, 34.06692], [-117.04942, 34.06795], [-117.05016, 34.06761], [-117.05061, 34.06565], [-117.04902, 34.06452], [-117.04766, 34.06428], [-117.04763, 34.06268], [-117.05203, 34.06257], [-117.05221, 34.06978], [-117.05643, 34.06979], [-117.05646, 34.07589]]]} | Open Access 1 | 29520 | Crafton Reservoir | 17750 | 318 | San Bernardino, County of 368 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | San Bernardino 22 | 168.476 | Crafton Reservoir | 0 | Local Recreation Area 3 | 4 | |
3646 | 3646 | 3645 | {"type": "Polygon", "coordinates": [[[-122.09719, 37.88699], [-122.0967, 37.88654], [-122.09593, 37.88668], [-122.09517, 37.88629], [-122.09471, 37.88637], [-122.09407, 37.88659], [-122.09356, 37.88625], [-122.09322, 37.88618], [-122.0933, 37.88612], [-122.0934, 37.8861], [-122.09615, 37.88602], [-122.09669, 37.88602], [-122.09723, 37.88606], [-122.09727, 37.88609], [-122.09728, 37.88613], [-122.09719, 37.88664], [-122.09719, 37.88699]]]} | Open Access 1 | 29549 | Lafayette/Moraga Trail | 20836 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.276 | Lafayette/Moraga Trail | 0 | Local Recreation Area 3 | 4 | |
3673 | 3673 | 3672 | {"type": "Polygon", "coordinates": [[[-121.764, 38.67997], [-121.76378, 38.68], [-121.76291, 38.68027], [-121.7627, 38.68031], [-121.75975, 38.68029], [-121.75975, 38.67976], [-121.7603, 38.67977], [-121.7603, 38.67979], [-121.76059, 38.67981], [-121.76213, 38.67983], [-121.76214, 38.67974], [-121.76325, 38.67977], [-121.76325, 38.67994], [-121.764, 38.67997]]]} | Open Access 1 | 29720 | Gonzales Park Soccer Field | 19399 | 332 | Yolo, County of 545 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | Yolo 33 | 4.348 | Gonzales Park Soccer Field | 0 | Local Recreation Area 3 | 4 | |
3715 | 3715 | 3714 | {"type": "Polygon", "coordinates": [[[-118.79784, 34.25155], [-118.79749, 34.25203], [-118.7975, 34.25248], [-118.79724, 34.25295], [-118.79723, 34.2536], [-118.79568, 34.2533], [-118.7955, 34.25324], [-118.79538, 34.25317], [-118.79528, 34.25324], [-118.7952, 34.25343], [-118.79525, 34.25345], [-118.7954, 34.25372], [-118.79566, 34.25383], [-118.79597, 34.25401], [-118.79541, 34.25383], [-118.79527, 34.25375], [-118.79518, 34.2538], [-118.79509, 34.25364], [-118.79508, 34.25348], [-118.7952, 34.2532], [-118.79531, 34.2531], [-118.79523, 34.25299], [-118.79518, 34.25288], [-118.79515, 34.25275], [-118.79516, 34.25265], [-118.79518, 34.25254], [-118.79548, 34.25178], [-118.79559, 34.25128], [-118.79649, 34.25136], [-118.79776, 34.25144], [-118.79782, 34.25149], [-118.79784, 34.25155]]]} | Open Access 1 | 44685 | Sinaloa Youth Ball Fields | 25516 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 11.424 | Sinaloa Youth Ball Fields | 0 | Local Recreation Area 3 | 4 | |
3722 | 3722 | 3721 | {"type": "Polygon", "coordinates": [[[-118.06595, 33.77472], [-118.06558, 33.77479], [-118.06521, 33.7749], [-118.06481, 33.77506], [-118.06449, 33.77523], [-118.06408, 33.77551], [-118.06382, 33.77574], [-118.06343, 33.77613], [-118.06332, 33.77613], [-118.06287, 33.77585], [-118.0627, 33.77578], [-118.06252, 33.77572], [-118.06235, 33.77569], [-118.06217, 33.77568], [-118.06212, 33.77564], [-118.06212, 33.77508], [-118.06219, 33.77491], [-118.06217, 33.77476], [-118.06595, 33.77472]]]} | Open Access 1 | 30350 | Seal Beach Tennis Center | 25242 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 6.797 | Seal Beach Tennis Ctr. | 0 | Local Recreation Area 3 | 4 | |
3733 | 3733 | 3732 | {"type": "MultiPolygon", "coordinates": [[[[-122.03357, 37.90414], [-122.03346, 37.90426], [-122.03345, 37.904], [-122.0335, 37.90405], [-122.03357, 37.90414]]], [[[-122.04019, 37.90842], [-122.03957, 37.90859], [-122.03754, 37.90726], [-122.03826, 37.90623], [-122.03875, 37.90662], [-122.03905, 37.9069], [-122.03939, 37.90741], [-122.03961, 37.90803], [-122.04019, 37.90842]]]]} | Open Access 1 | 31016 | Briones to Mount Diablo Trail | 33752 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 5.904 | Briones to Mount Diablo Trail | 0 | Local Recreation Area 3 | 4 | |
3756 | 3756 | 3755 | {"type": "Polygon", "coordinates": [[[-117.18035, 32.94266], [-117.17962, 32.94267], [-117.1796, 32.94186], [-117.17996, 32.94211], [-117.18002, 32.94218], [-117.18014, 32.9424], [-117.18035, 32.94266]]]} | Open Access 1 | 464 | Del Mar Mesa Open Space | 18033 | 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.868 | Del Mar Mesa OS | 0 | Local Recreation Area 3 | 4 | |
3764 | 3764 | 3763 | {"type": "Polygon", "coordinates": [[[-121.30488, 38.5734], [-121.30175, 38.57341], [-121.30099, 38.57293], [-121.29923, 38.57175], [-121.29896, 38.57152], [-121.29829, 38.57106], [-121.29822, 38.57096], [-121.29824, 38.57085], [-121.29831, 38.57076], [-121.2984, 38.57069], [-121.301, 38.56951], [-121.30107, 38.56951], [-121.30111, 38.56954], [-121.30269, 38.57164], [-121.30277, 38.57172], [-121.30297, 38.57181], [-121.30301, 38.57185], [-121.30301, 38.57187], [-121.303, 38.57191], [-121.30287, 38.57198], [-121.30339, 38.57275], [-121.30414, 38.5724], [-121.30488, 38.5734]]]} | Open Access 1 | 34931 | Mather Sports Center | 21951 | 1671 | Rancho Cordova, City of 679 | City 2 | City Agency 2 | http://www.cityofranchocordova.org/ | City 2 | 1671 | Rancho Cordova, City of 669 | City 2 | City Agency 2 | Sacramento 41 | 27.915 | Mather Sports Ctr. | 0 | Local Recreation Area 3 | 4 | |
3776 | 3776 | 3775 | {"type": "Polygon", "coordinates": [[[-122.63891, 41.72279], [-122.63868, 41.72414], [-122.6381, 41.72593], [-122.63764, 41.72582], [-122.63728, 41.72581], [-122.6358, 41.72545], [-122.63636, 41.72418], [-122.63739, 41.72439], [-122.63746, 41.72265], [-122.63891, 41.72279]]]} | Open Access 1 | 25377 | Yreka Creek Greenway | 27796 | 1428 | Yreka, City of 683 | City 2 | City Agency 2 | http://ci.yreka.ca.us/parks-and-facilities | City 2 | 1428 | Yreka, City of 674 | City 2 | City Agency 2 | Siskiyou 28 | 12.69 | Yreka Creek Greenway | 0 | Local Recreation Area 3 | 4 | |
3781 | 3781 | 3780 | {"type": "Polygon", "coordinates": [[[-117.93457, 33.80691], [-117.93442, 33.80719], [-117.93423, 33.80745], [-117.93415, 33.80743], [-117.93406, 33.80742], [-117.93397, 33.80743], [-117.9339, 33.8074], [-117.93378, 33.8074], [-117.93373, 33.80741], [-117.93365, 33.80747], [-117.93366, 33.80767], [-117.93284, 33.80768], [-117.93284, 33.80692], [-117.93457, 33.80691]]]} | Open Access 1 | 8684 | Energy Field Park | 18673 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 2.549 | Energy Field Park | 0 | Local Recreation Area 3 | 4 | |
3790 | 3790 | 3789 | {"type": "Polygon", "coordinates": [[[-119.13936, 36.29391], [-119.13839, 36.29424], [-119.13784, 36.29325], [-119.13882, 36.2929], [-119.13936, 36.29391]]]} | Open Access 1 | 1074 | Carnegie Community Center & City Park | 16883 | 1103 | Exeter, City of 129 | City 2 | City Agency 2 | http://www.cityofexeter.com/ | City 2 | 1103 | Exeter, City of 126 | City 2 | City Agency 2 | Tulare 29 | 2.863 | Carnegie Community Ctr. & City Park | 0 | Local Recreation Area 3 | 4 | |
3794 | 3794 | 3793 | {"type": "MultiPolygon", "coordinates": [[[[-121.03814, 38.21994], [-121.03814, 38.22083], [-121.0374, 38.22086], [-121.0373, 38.2208], [-121.03733, 38.22062], [-121.03731, 38.22053], [-121.03735, 38.2204], [-121.0373, 38.22006], [-121.03727, 38.22], [-121.03721, 38.21997], [-121.03697, 38.21995], [-121.03686, 38.22], [-121.03663, 38.22001], [-121.03654, 38.22007], [-121.03654, 38.22019], [-121.03657, 38.22045], [-121.03667, 38.22056], [-121.03666, 38.22077], [-121.03655, 38.22086], [-121.03651, 38.22095], [-121.03658, 38.22102], [-121.03686, 38.22109], [-121.03695, 38.22114], [-121.03716, 38.22138], [-121.03718, 38.22147], [-121.03683, 38.22185], [-121.0367, 38.22196], [-121.0365, 38.22204], [-121.03621, 38.22209], [-121.03584, 38.22227], [-121.03545, 38.22238], [-121.03528, 38.22239], [-121.03513, 38.22236], [-121.03504, 38.22231], [-121.03497, 38.22225], [-121.03477, 38.22219], [-121.03459, 38.22224], [-121.03436, 38.22237], [-121.03433, 38.22246], [-121.03437, 38.22257], [-121.03451, 38.22266], [-121.03457, 38.22276], [-121.03426, 38.22303], [-121.03422, 38.22312], [-121.03435, 38.22329], [-121.03436, 38.22339], [-121.03435, 38.22343], [-121.03413, 38.22377], [-121.03398, 38.22396], [-121.03381, 38.22414], [-121.03364, 38.22422], [-121.03341, 38.22442], [-121.03288, 38.22494], [-121.03285, 38.22493], [-121.03276, 38.22481], [-121.03265, 38.22472], [-121.03254, 38.22473], [-121.03235, 38.22486], [-121.03233, 38.22492], [-121.03236, 38.22496], [-121.03243, 38.225], [-121.03256, 38.22494], [-121.0326, 38.22494], [-121.0327, 38.22497], [-121.03271, 38.22501], [-121.03268, 38.22506], [-121.0326, 38.22513], [-121.03242, 38.2251], [-121.03236, 38.22505], [-121.03223, 38.22508], [-121.03225, 38.22514], [-121.03234, 38.22521], [-121.03246, 38.22528], [-121.03253, 38.22529], [-121.03239, 38.22549], [-121.03223, 38.22567], [-121.032, 38.22588], [-121.03171, 38.2261], [-121.03154, 38.22635], [-121.03142, 38.22645], [-121.03131, 38.22646], [-121.03121, 38.22642], [-121.03055, 38.22645], [-121.0303, 38.22644], [-121.03005, 38.22641], [-121.02968, 38.22632], [-121.02897, 38.22627], [-121.02814, 38.22624], [-121.0279, 38.2263], [-121.02763, 38.22642], [-121.02757, 38.22644], [-121.02727, 38.22648], [-121.02697, 38.22647], [-121.02666, 38.22642], [-121.02599, 38.22617], [-121.02584, 38.22615], [-121.02564, 38.22615], [-121.02546, 38.22612], [-121.02525, 38.22607], [-121.02493, 38.22595], [-121.02473, 38.22591], [-121.02453, 38.22589], [-121.02408, 38.22592], [-121.02391, 38.22598], [-121.02366, 38.22593], [-121.02357, 38.22617], [-121.02389, 38.22633], [-121.02438, 38.22634], [-121.02456, 38.22632], [-121.02448, 38.2264], [-121.02449, 38.22642], [-121.02481, 38.22653], [-121.02484, 38.22652], [-121.02497, 38.22658], [-121.02508, 38.22652], [-121.02516, 38.22644], [-121.02524, 38.22643], [-121.02556, 38.22658], [-121.02586, 38.22669], [-121.02619, 38.22677], [-121.02654, 38.22682], [-121.02695, 38.22683], [-121.02738, 38.22682], [-121.02809, 38.22669], [-121.02839, 38.22667], [-121.02869, 38.22666], [-121.02934, 38.22672], [-121.03012, 38.22687], [-121.03027, 38.22688], [-121.03042, 38.22686], [-121.03094, 38.22688], [-121.03119, 38.22691], [-121.03151, 38.22691], [-121.03156, 38.22694], [-121.0317, 38.22694], [-121.03178, 38.2269], [-121.03179, 38.22683], [-121.03172, 38.22677], [-121.03175, 38.2266], [-121.0318, 38.2265], [-121.03194, 38.22632], [-121.03225, 38.22608], [-121.03237, 38.22597], [-121.03248, 38.22581], [-121.03273, 38.22562], [-121.03316, 38.22532], [-121.03344, 38.22525], [-121.03403, 38.22475], [-121.03438, 38.22419], [-121.03469, 38.22375], [-121.03488, 38.22352], [-121.03537, 38.22304], [-121.0356, 38.22286], [-121.03585, 38.22272], [-121.03669, 38.22238], [-121.03686, 38.22233], [-121.03701, 38.22224], [-121.03707, 38.22878], [-121.03567, 38.22877], [-121.0353, 38.22874], [-121.03476, 38.22868], [-121.03453, 38.22862], [-121.03431, 38.22855], [-121.03355, 38.22818], [-121.03341, 38.22813], [-121.03235, 38.22796], [-121.03219, 38.22795], [-121.03188, 38.22796], [-121.0315, 38.22806], [-121.03092, 38.22837], [-121.03076, 38.22842], [-121.03056, 38.22845], [-121.02987, 38.22851], [-121.02908, 38.2285], [-121.02895, 38.22847], [-121.02878, 38.22836], [-121.0283, 38.22784], [-121.02829, 38.22765], [-121.02815, 38.22753], [-121.02782, 38.22753], [-121.02775, 38.23248], [-121.01399, 38.23241], [-121.01404, 38.23604], [-121.00947, 38.236], [-121.00947, 38.23773], [-121.00863, 38.23888], [-121.00845, 38.23945], [-121.00782, 38.24233], [-121.0077, 38.24268], [-121.00756, 38.24298], [-121.00733, 38.24334], [-121.00704, 38.24367], [-121.00669, 38.24398], [-121.00637, 38.24421], [-121.00605, 38.24439], [-121.00581, 38.2445], [-121.00422, 38.24515], [-121.00288, 38.24196], [-121.00317, 38.24197], [-121.0035, 38.24158], [-121.00381, 38.24128], [-121.00394, 38.24117], [-121.00433, 38.24093], [-121.00463, 38.24083], [-121.00498, 38.24076], [-121.00524, 38.24074], [-121.0057, 38.24076], [-121.00617, 38.23807], [-121.0059, 38.23745], [-121.00591, 38.23725], [-121.00595, 38.23706], [-121.00605, 38.2368], [-121.00615, 38.23663], [-121.00625, 38.2365], [-121.00642, 38.23633], [-121.00703, 38.23583], [-121.00743, 38.23569], [-121.00799, 38.23552], [-121.00862, 38.23525], [-121.00885, 38.23519], [-121.00905, 38.23509], [-121.00922, 38.23497], [-121.00959, 38.23461], [-121.00976, 38.2344], [-121.01001, 38.23417], [-121.01001, 38.23406], [-121.01008, 38.23397], [-121.01018, 38.23392], [-121.01031, 38.2339], [-121.0105, 38.23372], [-121.01074, 38.23357], [-121.01089, 38.23354], [-121.01089, 38.23352], [-121.01084, 38.23349], [-121.01081, 38.23329], [-121.01098, 38.23302], [-121.01124, 38.23275], [-121.01139, 38.23237], [-121.01132, 38.23211], [-121.01117, 38.23197], [-121.0108, 38.2319], [-121.0105, 38.23181], [-121.0102, 38.23167], [-121.00992, 38.23152], [-121.0097, 38.23135], [-121.00965, 38.23115], [-121.00955, 38.23101], [-121.00942, 38.23091], [-121.00925, 38.23083], [-121.00919, 38.23077], [-121.00912, 38.23066], [-121.00908, 38.23056], [-121.00906, 38.23036], [-121.00911, 38.23015], [-121.00926, 38.22981], [-121.00936, 38.22971], [-121.00946, 38.22967], [-121.00959, 38.22965], [-121.00981, 38.22966], [-121.01008, 38.22963], [-121.01016, 38.22965], [-121.01023, 38.22968], [-121.01034, 38.22984], [-121.01055, 38.22978], [-121.01078, 38.22977], [-121.01097, 38.2298], [-121.01113, 38.22987], [-121.01112, 38.22973], [-121.01101, 38.22945], [-121.01101, 38.22938], [-121.01105, 38.22932], [-121.01113, 38.22927], [-121.01124, 38.22925], [-121.01157, 38.22931], [-121.01167, 38.22926], [-121.01161, 38.22915], [-121.01175, 38.22904], [-121.01189, 38.229], [-121.01209, 38.22901], [-121.01223, 38.22898], [-121.01216, 38.22873], [-121.01217, 38.22869], [-121.0122, 38.22863], [-121.01226, 38.22858], [-121.01241, 38.22854], [-121.01256, 38.22855], [-121.01268, 38.22862], [-121.01299, 38.22902], [-121.01311, 38.22914], [-121.01326, 38.22925], [-121.01342, 38.22934], [-121.01367, 38.22945], [-121.01376, 38.22944], [-121.01389, 38.22935], [-121.01385, 38.22924], [-121.01367, 38.22915], [-121.01363, 38.22898], [-121.01369, 38.22891], [-121.01377, 38.22887], [-121.01387, 38.22887], [-121.01395, 38.22889], [-121.01398, 38.22881], [-121.01403, 38.22873], [-121.0141, 38.22867], [-121.0142, 38.22861], [-121.01421, 38.22855], [-121.0143, 38.22836], [-121.01434, 38.22821], [-121.01434, 38.22806], [-121.01413, 38.22788], [-121.01407, 38.22787], [-121.01402, 38.22784], [-121.01399, 38.22779], [-121.014, 38.22774], [-121.01413, 38.22762], [-121.01433, 38.22749], [-121.01455, 38.22738], [-121.01474, 38.22731], [-121.01492, 38.22731], [-121.01495, 38.22736], [-121.01495, 38.22748], [-121.01488, 38.22759], [-121.0149, 38.2277], [-121.01504, 38.22775], [-121.01509, 38.22782], [-121.01511, 38.22791], [-121.0152, 38.22787], [-121.01529, 38.22788], [-121.01537, 38.22794], [-121.01538, 38.22802], [-121.01547, 38.22804], [-121.0157, 38.22814], [-121.0159, 38.2281], [-121.01622, 38.22813], [-121.01641, 38.22811], [-121.01654, 38.22816], [-121.01668, 38.22805], [-121.01678, 38.22801], [-121.01681, 38.22819], [-121.01668, 38.22829], [-121.01663, 38.2284], [-121.0166, 38.22858], [-121.0166, 38.22866], [-121.0181, 38.22886], [-121.01811, 38.22885], [-121.01808, 38.22876], [-121.01811, 38.22862], [-121.01809, 38.22847], [-121.01814, 38.22831], [-121.0184, 38.22823], [-121.01898, 38.22779], [-121.0193, 38.22759], [-121.01964, 38.22729], [-121.01984, 38.22716], [-121.02011, 38.22706], [-121.02041, 38.22701], [-121.02064, 38.22702], [-121.02086, 38.22707], [-121.0211, 38.2271], [-121.02131, 38.2271], [-121.02154, 38.22708], [-121.02271, 38.22461], [-121.02444, 38.22119], [-121.0245, 38.22103], [-121.02452, 38.2208], [-121.02446, 38.22057], [-121.02362, 38.21902], [-121.02353, 38.21878], [-121.02349, 38.21852], [-121.02349, 38.21835], [-121.02351, 38.21818], [-121.02356, 38.21802], [-121.02363, 38.21785], [-121.02389, 38.21742], [-121.02427, 38.2169], [-121.0243, 38.21675], [-121.0243, 38.2166], [-121.02425, 38.21638], [-121.02261, 38.21339], [-121.02248, 38.21319], [-121.02232, 38.213], [-121.02208, 38.21279], [-121.0188, 38.21038], [-121.01862, 38.21027], [-121.01843, 38.21019], [-121.01829, 38.21015], [-121.01804, 38.21011], [-121.01774, 38.21011], [-121.01348, 38.20974], [-121.01322, 38.20974], [-121.01288, 38.20977], [-121.00935, 38.21041], [-121.00911, 38.21043], [-121.00887, 38.21042], [-121.00862, 38.21038], [-121.00839, 38.21031], [-121.00819, 38.21022], [-121.00481, 38.20887], [-121.00465, 38.209], [-121.00449, 38.20919], [-121.004, 38.20994], [-121.00369, 38.21034], [-121.00364, 38.2104], [-121.00338, 38.21055], [-121.00308, 38.21105], [-121.00269, 38.21152], [-121.00231, 38.21182], [-121.00222, 38.21186], [-121.00208, 38.21186], [-121.00197, 38.21181], [-121.00191, 38.21176], [-121.00188, 38.21171], [-121.00193, 38.21125], [-121.00197, 38.21112], [-121.00204, 38.21101], [-121.00221, 38.21085], [-121.00278, 38.21045], [-121.00315, 38.21023], [-121.00348, 38.20996], [-121.00373, 38.20969], [-121.00445, 38.20871], [-121.00445, 38.2087], [-120.99989, 38.20682], [-120.99983, 38.20689], [-120.99973, 38.20695], [-120.99961, 38.20699], [-120.99947, 38.207], [-120.99931, 38.20698], [-120.99914, 38.20689], [-120.99868, 38.20678], [-120.99519, 38.20826], [-120.99493, 38.20832], [-120.99453, 38.20835], [-120.99424, 38.20834], [-120.99073, 38.20792], [-120.99066, 38.20798], [-120.99063, 38.20803], [-120.99062, 38.20809], [-120.99063, 38.20815], [-120.99068, 38.20821], [-120.99084, 38.20831], [-120.99099, 38.20845], [-120.99103, 38.20854], [-120.99101, 38.20863], [-120.99092, 38.20873], [-120.99077, 38.20877], [-120.9905, 38.20876], [-120.99029, 38.20873], [-120.99019, 38.2087], [-120.99011, 38.20864], [-120.99006, 38.20856], [-120.99005, 38.20845], [-120.99008, 38.20838], [-120.99012, 38.20832], [-120.99026, 38.20826], [-120.99037, 38.20815], [-120.99042, 38.20801], [-120.99041, 38.20788], [-120.98826, 38.20761], [-120.98716, 38.20499], [-120.9881, 38.20503], [-120.99118, 38.20507], [-120.99172, 38.20505], [-120.99252, 38.20496], [-120.99565, 38.20442], [-120.99565, 38.20589], [-120.99566, 38.2059], [-120.99749, 38.20509], [-121.0049, 38.2051], [-121.00491, 38.20678], [-121.00945, 38.20679], [-121.01872, 38.20675], [-121.02335, 38.2068], [-121.02333, 38.21049], [-121.02794, 38.21054], [-121.02792, 38.21418], [-121.03706, 38.21428], [-121.03706, 38.21781], [-121.03704, 38.21992], [-121.03814, 38.21994]]], [[[-121.00486, 38.24661], [-121.00433, 38.24535], [-121.00485, 38.24514], [-121.00485, 38.24514], [-121.00486, 38.24661]]]]} | No Public Access 3 | 35090 | Camanche Reservoir | 16745 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 2031 | East Bay Municipal Utility District 427 | Special District 4 | Water District 13 | San Joaquin 39 | 1057.628 | Camanche Reservoir | 0 | Local Recreation Area 3 | 4 | |
3797 | 3797 | 3796 | {"type": "MultiPolygon", "coordinates": [[[[-117.007, 32.87455], [-117.00513, 32.87459], [-117.00513, 32.87459], [-117.0059, 32.87307], [-117.00666, 32.87307], [-117.00676, 32.87322], [-117.00643, 32.87323], [-117.00642, 32.87324], [-117.007, 32.87455]]], [[[-117.01663, 32.86839], [-117.01493, 32.86948], [-117.01329, 32.8671], [-117.01455, 32.86624], [-117.01459, 32.86612], [-117.01663, 32.86839]]], [[[-117.01772, 32.87281], [-117.01479, 32.87318], [-117.01447, 32.87138], [-117.01765, 32.87049], [-117.01772, 32.87281]]]]} | Open Access 1 | 45131 | City Open Space | 17337 | 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 | 34.702 | City OS | 0 | Local Recreation Area 3 | 4 | |
3798 | 3798 | 3797 | {"type": "MultiPolygon", "coordinates": [[[[-116.9578, 33.32443], [-116.94941, 33.3289], [-116.94271, 33.33233], [-116.93544, 33.32958], [-116.92862, 33.32705], [-116.91095, 33.32034], [-116.90797, 33.31919], [-116.91534, 33.31418], [-116.92002, 33.31102], [-116.92765, 33.31311], [-116.92793, 33.31298], [-116.92835, 33.31273], [-116.92842, 33.31228], [-116.929, 33.31186], [-116.92931, 33.31159], [-116.92979, 33.31131], [-116.93077, 33.311], [-116.93042, 33.31167], [-116.92952, 33.31213], [-116.92917, 33.31283], [-116.92805, 33.31344], [-116.92704, 33.31409], [-116.92582, 33.31491], [-116.92483, 33.31573], [-116.92386, 33.31674], [-116.92361, 33.31727], [-116.92383, 33.31777], [-116.92675, 33.31811], [-116.93088, 33.31862], [-116.93485, 33.318], [-116.93823, 33.31644], [-116.93821, 33.31671], [-116.93823, 33.31709], [-116.9382, 33.31734], [-116.93815, 33.31744], [-116.93808, 33.31751], [-116.93778, 33.31765], [-116.93785, 33.31774], [-116.93818, 33.31759], [-116.93827, 33.31749], [-116.93832, 33.31739], [-116.93836, 33.31715], [-116.93834, 33.31671], [-116.93837, 33.31633], [-116.94031, 33.31541], [-116.94087, 33.31561], [-116.94023, 33.31693], [-116.94024, 33.31695], [-116.94325, 33.31647], [-116.94478, 33.31671], [-116.94578, 33.31681], [-116.94575, 33.31803], [-116.94491, 33.31761], [-116.94483, 33.31757], [-116.94482, 33.31758], [-116.94292, 33.32426], [-116.95073, 33.32383], [-116.9542, 33.32362], [-116.9578, 33.32443]]], [[[-116.92717, 33.31458], [-116.92717, 33.31471], [-116.927, 33.31471], [-116.927, 33.31458], [-116.92717, 33.31458]]]]} | No Public Access 3 | 45133 | YMWD Open Space | 27772 | 2320 | Yuima Municipal Water District 684 | Special District 4 | Water District 13 | http://www.yuimamwd.com/ | Special District 4 | 2320 | Yuima Municipal Water District 675 | Special District 4 | Water District 13 | San Diego 4 | 1090.211 | YMWD OS | 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]);