units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,925 rows where ACCESS_TYP = 1 and MNG_AG_LEV = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 503
- Los Angeles, City of 432
- San Jose, City of 247
- San Francisco, City and County of 238
- Sacramento, City of 216
- Ventura, City of 149
- Long Beach, City of 135
- Roseville, City of 123
- Oakland, City of 122
- Irvine, City of 100
- Fresno, City of 92
- Modesto, City of 78
- Stockton, City of 77
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Rosa, City of 72
- Chula Vista, City of 68
- Brentwood, City of 68
- Napa, City of 67
- Santa Cruz, City of 65
- Newport Beach, City of 65
- Poway, City of 64
- San Luis Obispo, City of 63
- Davis, City of 62
- Clovis, City of 61
- Manteca, City of 60
- Anaheim, City of 59
- Glendale, City of 59
- Riverside, City of 59
- Bakersfield, City of 59
- …
DES_TP >30
- Local Park 7,297
- Local Recreation Area 1,226
- Local Other or Unknown 581
- Local Conservation Area 126
- Local Historic or Cultural Area 35
- National Monument or Landmark 4
- Local Resource Management Area 4
- 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
- National Recreation Area 1
- …
MNG_AG_TYP 1
- City Agency 9,925
ACCESS_TYP 1
- Open Access · 9,925 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | 1 | {"type": "Polygon", "coordinates": [[[-120.84977, 37.77283], [-120.84915, 37.77309], [-120.84786, 37.77119], [-120.84847, 37.77095], [-120.84977, 37.77283]]]} | Open Access 1 | 14 | Oaklawn Memorial Park | 23029 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.595 | Oaklawn Memorial Park | 0 | Local Park 2 | 4 | |
5 | 5 | 4 | {"type": "MultiPolygon", "coordinates": [[[[-118.10598, 33.73945], [-118.10581, 33.73968], [-118.1051, 33.73933], [-118.10527, 33.73909], [-118.10598, 33.73945]]], [[[-118.10701, 33.73996], [-118.10683, 33.7402], [-118.10615, 33.73985], [-118.10632, 33.73962], [-118.10701, 33.73996]]], [[[-118.10746, 33.7402], [-118.10729, 33.74044], [-118.10691, 33.74024], [-118.10708, 33.74], [-118.10746, 33.7402]]]]} | Open Access 1 | 25 | Eisenhower Park | 18475 | 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 | 1.46 | Eisenhower Park | 0 | Local Park 2 | 4 | |
6 | 6 | 5 | {"type": "MultiPolygon", "coordinates": [[[[-117.11089, 32.73295], [-117.11088, 32.73298], [-117.11086, 32.73286], [-117.1107, 32.73261], [-117.11037, 32.73248], [-117.10993, 32.73245], [-117.10979, 32.73242], [-117.10919, 32.73273], [-117.10874, 32.73272], [-117.10872, 32.73247], [-117.10818, 32.73272], [-117.10811, 32.73272], [-117.10788, 32.73308], [-117.10775, 32.73295], [-117.10773, 32.73295], [-117.1074, 32.73315], [-117.10734, 32.73317], [-117.10705, 32.7334], [-117.10683, 32.73321], [-117.10705, 32.73283], [-117.10727, 32.73261], [-117.10691, 32.73234], [-117.10697, 32.73229], [-117.10703, 32.73226], [-117.10776, 32.73211], [-117.10766, 32.73176], [-117.10765, 32.73157], [-117.10769, 32.73139], [-117.10774, 32.73124], [-117.10782, 32.73111], [-117.10802, 32.73089], [-117.10797, 32.73062], [-117.10803, 32.73067], [-117.10847, 32.7309], [-117.10876, 32.73109], [-117.10866, 32.73109], [-117.10858, 32.73107], [-117.10849, 32.73117], [-117.10866, 32.73138], [-117.10875, 32.73158], [-117.10881, 32.73182], [-117.10883, 32.73208], [-117.10939, 32.73195], [-117.10985, 32.73194], [-117.10996, 32.73191], [-117.11035, 32.73217], [-117.11072, 32.73258], [-117.11089, 32.73286], [-117.11089, 32.73295]]], [[[-117.10995, 32.73399], [-117.10989, 32.73404], [-117.10985, 32.734], [-117.10991, 32.73395], [-117.10995, 32.73399]]]]} | Open Access 1 | 26 | Azalea Neighborhood Park | 30115 | 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.138 | Azalea Neighborhood Park | 0 | Local Park 2 | 4 | |
8 | 8 | 7 | {"type": "Polygon", "coordinates": [[[-117.70487, 34.09777], [-117.70457, 34.09776], [-117.7046, 34.09775], [-117.70462, 34.09772], [-117.70461, 34.09748], [-117.70381, 34.09747], [-117.7042, 34.09652], [-117.7048, 34.09652], [-117.70482, 34.09772], [-117.70483, 34.09775], [-117.70487, 34.09777]]]} | Open Access 1 | 30 | El Barrio Park | 18477 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | Los Angeles 6 | 2.099 | El Barrio Park | 0 | Local Park 2 | 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 | |
11 | 11 | 10 | {"type": "Polygon", "coordinates": [[[-117.08431, 32.9339], [-117.08421, 32.93398], [-117.08411, 32.93375], [-117.08393, 32.93344], [-117.08356, 32.93329], [-117.08306, 32.93325], [-117.08297, 32.9331], [-117.08313, 32.93271], [-117.08313, 32.93246], [-117.08292, 32.93223], [-117.08257, 32.9321], [-117.08257, 32.93151], [-117.08386, 32.93278], [-117.08402, 32.93297], [-117.08415, 32.93318], [-117.08425, 32.93342], [-117.0843, 32.93368], [-117.08431, 32.9339]]]} | Open Access 1 | 46738 | Butterfly Mini-Park | 30187 | 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 | 3.079 | Butterfly Mini-Park | 0 | Local Park 2 | 4 | |
13 | 13 | 12 | {"type": "Polygon", "coordinates": [[[-120.84861, 37.76492], [-120.8483, 37.76505], [-120.84814, 37.76482], [-120.84845, 37.76468], [-120.84861, 37.76492]]]} | Open Access 1 | 49 | William Meyer Park | 27553 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 0.233 | William Meyer Park | 0 | Local Park 2 | 4 | |
14 | 14 | 13 | {"type": "Polygon", "coordinates": [[[-122.03122, 36.97381], [-122.03122, 36.97381], [-122.03111, 36.97409], [-122.03105, 36.97384], [-122.03122, 36.97381]]]} | Open Access 1 | 42 | Rincon Park | 24369 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.055 | Rincon Park | 0 | Local Park 2 | 4 | |
15 | 15 | 14 | {"type": "Polygon", "coordinates": [[[-120.87737, 37.76176], [-120.87616, 37.76176], [-120.87611, 37.76172], [-120.8761, 37.76055], [-120.87615, 37.76051], [-120.87682, 37.76051], [-120.87688, 37.76054], [-120.87736, 37.76051], [-120.87737, 37.76176]]]} | Open Access 1 | 43 | William A. Fish Veterans Memorial Park | 27537 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.803 | William A. Fish Veterans Memorial Park | 0 | Local Park 2 | 4 | |
16 | 16 | 15 | {"type": "Polygon", "coordinates": [[[-121.15169, 37.47476], [-121.15143, 37.47478], [-121.15101, 37.47485], [-121.15025, 37.47485], [-121.15026, 37.4736], [-121.15131, 37.4736], [-121.15156, 37.47359], [-121.15169, 37.47476]]]} | Open Access 1 | 66 | Ambercot Park | 15443 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 4.088 | Ambercot Park | 0 | Local Park 2 | 4 | |
17 | 17 | 16 | {"type": "Polygon", "coordinates": [[[-118.12258, 34.69275], [-118.12251, 34.69275], [-118.1225, 34.69267], [-118.1217, 34.69267], [-118.12164, 34.69261], [-118.12164, 34.69054], [-118.12169, 34.69048], [-118.12257, 34.69049], [-118.12258, 34.69275]]]} | Open Access 1 | 56 | El Dorado Park | 18505 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | Los Angeles 6 | 5.137 | El Dorado Park | 0 | Local Park 2 | 4 | |
19 | 19 | 18 | {"type": "Polygon", "coordinates": [[[-117.08916, 32.92533], [-117.08917, 32.92536], [-117.08915, 32.92627], [-117.08884, 32.92626], [-117.08902, 32.92612], [-117.08902, 32.926], [-117.08877, 32.92601], [-117.08855, 32.92613], [-117.08872, 32.92567], [-117.0877, 32.92529], [-117.08912, 32.92531], [-117.08916, 32.92533]]]} | Open Access 1 | 46740 | Dry Creek Mini-Park | 30190 | 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 | 1.479 | Dry Creek Mini-Park | 0 | Local Park 2 | 4 | |
20 | 20 | 19 | {"type": "Polygon", "coordinates": [[[-121.7511, 36.90667], [-121.74954, 36.9078], [-121.74933, 36.90761], [-121.75087, 36.90647], [-121.7511, 36.90667]]]} | Open Access 1 | 76 | River Park | 24419 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 1.349 | River Park | 0 | Local Park 2 | 4 | |
21 | 21 | 20 | {"type": "Polygon", "coordinates": [[[-121.14743, 37.47816], [-121.14709, 37.47823], [-121.14693, 37.47771], [-121.14719, 37.47764], [-121.14726, 37.47767], [-121.14743, 37.47816]]]} | Open Access 1 | 77 | Aurora Park | 15710 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.447 | Aurora Park | 0 | Local Park 2 | 4 | |
22 | 22 | 21 | {"type": "Polygon", "coordinates": [[[-119.79976, 36.71887], [-119.79974, 36.71947], [-119.79972, 36.71963], [-119.7977, 36.7196], [-119.79769, 36.71907], [-119.79807, 36.71906], [-119.79808, 36.71894], [-119.7991, 36.71892], [-119.79911, 36.71887], [-119.79976, 36.71887]]]} | Open Access 1 | 60 | Bigby VIlla Park | 16097 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 3.426 | Bigby VIlla Park | 0 | Local Park 2 | 4 | |
23 | 23 | 22 | {"type": "MultiPolygon", "coordinates": [[[[-117.18273, 33.93183], [-117.18271, 33.93293], [-117.18092, 33.93339], [-117.18015, 33.93307], [-117.17968, 33.93256], [-117.17883, 33.93225], [-117.17828, 33.93231], [-117.17756, 33.93249], [-117.17718, 33.93231], [-117.17635, 33.93181], [-117.17587, 33.93169], [-117.17515, 33.93142], [-117.17428, 33.93106], [-117.17404, 33.93104], [-117.17405, 33.93095], [-117.17838, 33.93096], [-117.17837, 33.93177], [-117.18134, 33.93186], [-117.18135, 33.9325], [-117.18202, 33.93251], [-117.18203, 33.93187], [-117.18273, 33.93183]]], [[[-117.20327, 33.88839], [-117.2032, 33.88929], [-117.20248, 33.89008], [-117.19813, 33.88981], [-117.19756, 33.89], [-117.19712, 33.89012], [-117.19596, 33.89009], [-117.19656, 33.88864], [-117.19473, 33.88873], [-117.1934, 33.88746], [-117.1949, 33.886], [-117.19511, 33.88553], [-117.19532, 33.8853], [-117.19552, 33.88517], [-117.19617, 33.88509], [-117.19685, 33.88507], [-117.19695, 33.88473], [-117.19724, 33.88446], [-117.19752, 33.88367], [-117.19799, 33.88294], [-117.19871, 33.88264], [-117.19944, 33.88307], [-117.20072, 33.88375], [-117.20013, 33.88439], [-117.20077, 33.88457], [-117.2001, 33.88458], [-117.19982, 33.88459], [-117.1995, 33.88457], [-117.19919, 33.88452], [-117.19892, 33.88446], [-117.19878, 33.88446], [-117.19868, 33.8845], [-117.19859, 33.88457], [-117.19849, 33.88468], [-117.19837, 33.88486], [-117.19816, 33.88507], [-117.19799, 33.88517], [-117.19738, 33.88546], [-117.19714, 33.88561], [-117.19684, 33.88575], [-117.19691, 33.88591], [-117.19725, 33.8861], [-117.19751, 33.88627], [-117.19772, 33.88651], [-117.19788, 33.88627], [-117.19816, 33.88599], [-117.19887, 33.88551], [-117.19917, 33.88533], [-117.19955, 33.88521], [-117.19991, 33.88513], [-117.20042, 33.88512], [-117.20179, 33.88527], [-117.20187, 33.88486], [-117.20231, 33.88493], [-117.20245, 33.88837], [-117.20327, 33.88839]]], [[[-117.21209, 33.94042], [-117.21158, 33.94047], [-117.21048, 33.94048], [-117.2089, 33.94044], [-117.20839, 33.94036], [-117.20882, 33.93952], [-117.21195, 33.93945], [-117.21195, 33.93996], [-117.21209, 33.94042]]], [[[-117.21258, 33.87392], [-117.21113, 33.87391], [-117.21112, 33.87311], [-117.21258, 33.87312], [-117.21258, 33.87392]]], [[[-117.22996, 33.96398], [-117.22991, 33.96404], [-117.22837, 33.96145], [-117.22796, 33.96184], [-117.22797, 33.96208], [-117.22795, 33.9621], [-117.22793, 33.96218], [-117.2276, 33.96237], [-117.2273, 33.9626], [-117.22714, 33.96327], [-117.22705, 33.96355], [-117.22685, 33.96381], [-117.22652, 33.9641], [-117.22656, 33.96117], [-117.22828, 33.96118], [-117.22996, 33.96398]]], [[[-117.24241, 33.96625], [-117.24241, 33.96627], [-117.24212, 33.96633], [-117.24204, 33.96649], [-117.24195, 33.96663], [-117.24178, 33.96678], [-117.24149, 33.96713], [-117.24137, 33.96732], [-117.24119, 33.9677], [-117.24108, 33.96786], [-117.24095, 33.96801], [-117.2408, 33.96814], [-117.24063, 33.96824], [-117.23997, 33.96853], [-117.23939, 33.96894], [-117.23906, 33.96926], [-117.23861, 33.96974], [-117.2384, 33.96985], [-117.23781, 33.97048], [-117.23757, 33.97082], [-117.23742, 33.97097], [-117.23707, 33.97125], [-117.23678, 33.97156], [-117.23668, 33.97175], [-117.23652, 33.97194], [-117.23625, 33.97238], [-117.23626, 33.97263], [-117.23588, 33.97254], [-117.23552, 33.97286], [-117.2353, 33.97311], [-117.23515, 33.97353], [-117.23506, 33.97346], [-117.23496, 33.97333], [-117.23483, 33.97308], [-117.23471, 33.97294], [-117.2346, 33.97285], [-117.2344, 33.97273], [-117.23422, 33.97267], [-117.23404, 33.97263], [-117.23376, 33.97262], [-117.23369, 33.97256], [-117.23371, 33.97199], [-117.23369, 33.97139], [-117.23358, 33.97046], [-117.23344, 33.96976], [-117.23335, 33.96943], [-117.23324, 33.96906], [-117.23298, 33.96831], [-117.23301, 33.96824], [-117.23466, 33.96774], [-117.23474, 33.96778], [-117.23309, 33.96827], [-117.23304, 33.96837], [-117.23314, 33.96866], [-117.23324, 33.9689], [-117.23337, 33.96932], [-117.23354, 33.97002], [-117.23357, 33.97016], [-117.23384, 33.97014], [-117.23421, 33.97009], [-117.23448, 33.97002], [-117.23484, 33.96988], [-117.2352, 33.96963], [-117.23582, 33.96962], [-117.23616, 33.9695], [-117.23638, 33.96927], [-117.23636, 33.96912], [-117.23618, 33.96873], [-117.23679, 33.9688], [-117.23721, 33.96849], [-117.23783, 33.96819], [-117.23807, 33.9681], [-117.23829, 33.96796], [-117.23846, 33.96778], [-117.23859, 33.96757], [-117.23864, 33.96742], [-117.23877, 33.96732], [-117.23894, 33.96719], [-117.23921, 33.96716], [-117.2394, 33.96704], [-117.23971, 33.96672], [-117.23989, 33.9666], [-117.24012, 33.96652], [-117.24029, 33.96632], [-117.24078, 33.96587], [-117.24097, 33.96575], [-117.24131, 33.96564], [-117.24122, 33.96539], [-117.24131, 33.96532], [-117.24133, 33.96527], [-117.24171, 33.96527], [-117.24179, 33.96545], [-117.24187, 33.96555], [-117.24197, 33.96565], [-117.24218, 33.96581], [-117.24231, 33.96597], [-117.24238, 33.9661], [-117.24241, 33.96625]]], [[[-117.23937, 33.97096], [-117.23871, 33.97233], [-117.23849, 33.97267], [-117.23813, 33.97308], [-117.23787, 33.97333], [-117.23498, 33.97555], [-117.23308, 33.97552], [-117.23323, 33.97508], [-117.23363, 33.97328], [-117.23367, 33.97286], [-117.23375, 33.97279], [-117.234, 33.97279], [-117.2341, 33.97281], [-117.23432, 33.97288], [-117.23447, 33.97297], [-117.23457, 33.97305], [-117.23467, 33.97317], [-117.23479, 33.97341], [-117.23491, 33.97356], [-117.23485, 33.97392], [-117.23483, 33.97423], [-117.23495, 33.97424], [-117.23539, 33.9742], [-117.23561, 33.97422], [-117.23579, 33.97429], [-117.23591, 33.97427], [-117.2362, 33.97419], [-117.23635, 33.97413], [-117.23649, 33.97402], [-117.23668, 33.97391], [-117.23689, 33.97375], [-117.23704, 33.97355], [-117.23715, 33.97334], [-117.23721, 33.9731], [-117.23722, 33.97287], [-117.23761, 33.97279], [-117.23815, 33.97252], [-117.23831, 33.97217], [-117.23841, 33.9722], [-117.23853, 33.97206], [-117.23879, 33.97152], [-117.2389, 33.97152], [-117.23906, 33.97125], [-117.23925, 33.97085], [-117.23937, 33.97096]]], [[[-117.25376, 33.97083], [-117.25343, 33.97097], [-117.25343, 33.97099], [-117.2535, 33.97109], [-117.25341, 33.97113], [-117.25331, 33.97122], [-117.25313, 33.97151], [-117.25302, 33.97162], [-117.25284, 33.97176], [-117.25274, 33.97192], [-117.25272, 33.97203], [-117.25272, 33.97226], [-117.25275, 33.97258], [-117.25282, 33.97307], [-117.25282, 33.97324], [-117.2528, 33.9733], [-117.25271, 33.97338], [-117.25265, 33.97339], [-117.25261, 33.97339], [-117.25236, 33.97329], [-117.25224, 33.9733], [-117.25217, 33.97339], [-117.25215, 33.97354], [-117.25211, 33.97362], [-117.25208, 33.97365], [-117.25199, 33.97368], [-117.2518, 33.97368], [-117.25172, 33.97363], [-117.25169, 33.97359], [-117.25167, 33.9733], [-117.25169, 33.97312], [-117.25173, 33.97297], [-117.25187, 33.97268], [-117.25192, 33.9725], [-117.25193, 33.97216], [-117.2519, 33.97208], [-117.25177, 33.97199], [-117.25165, 33.97198], [-117.25032, 33.97216], [-117.25027, 33.97216], [-117.25017, 33.97212], [-117.25011, 33.97205], [-117.25011, 33.97195], [-117.25015, 33.97191], [-117.25021, 33.97186], [-117.25058, 33.97175], [-117.25066, 33.9717], [-117.25086, 33.97155], [-117.25097, 33.97139], [-117.25102, 33.97123], [-117.251, 33.9711], [-117.25094, 33.97102], [-117.25088, 33.97096], [-117.25077, 33.97091], [-117.25024, 33.97088], [-117.24963, 33.97086], [-117.24936, 33.97091], [-117.24832, 33.97125], [-117.24822, 33.97126], [-117.24814, 33.97124], [-117.24808, 33.9712], [-117.24804, 33.97118], [-117.24799, 33.97108], [-117.24798, 33.97103], [-117.248, 33.97098], [-117.24802, 33.97094], [-117.24831, 33.97071], [-117.24843, 33.97057], [-117.24849, 33.97046], [-117.24857, 33.97029], [-117.2486, 33.97017], [-117.24859, 33.96994], [-117.24855, 33.96981], [-117.24849, 33.96971], [-117.24832, 33.9695], [-117.24804, 33.96931], [-117.24783, 33.96925], [-117.24768, 33.96918], [-117.24757, 33.96908], [-117.24752, 33.96899], [-117.24749, 33.96888], [-117.24716, 33.96891], [-117.24709, 33.96912], [-117.24707, 33.96912], [-117.24704, 33.96887], [-117.24558, 33.9689], [-117.24535, 33.96898], [-117.24484, 33.96926], [-117.24438, 33.96938], [-117.24378, 33.96949], [-117.24355, 33.96905], [-117.24379, 33.96897], [-117.24394, 33.96905], [-117.24456, 33.96907], [-117.24494, 33.9689], [-117.24524, 33.96869], [-117.24538, 33.96861], [-117.2461, 33.96851], [-117.24703, 33.96834], [-117.24762, 33.96834], [-117.24766, 33.96843], [-117.24781, 33.96837], [-117.24794, 33.96838], [-117.24851, 33.96869], [-117.2487, 33.96876], [-117.24897, 33.96881], [-117.24911, 33.96886], [-117.24933, 33.96898], [-117.25086, 33.96775], [-117.25233, 33.96906], [-117.25276, 33.96949], [-117.25315, 33.96994], [-117.25353, 33.97046], [-117.25376, 33.97083]]], [[[-117.25811, 33.968], [-117.25687, 33.96801], [-117.25647, 33.96804], [-117.25596, 33.96813], [-117.25546, 33.96828], [-117.25523, 33.96837], [-117.25456, 33.9676], [-117.25751, 33.96687], [-117.25705, 33.96589], [-117.25513, 33.96426], [-117.25514, 33.96306], [-117.25542, 33.96263], [-117.25542, 33.9622], [-117.25463, 33.96114], [-117.25438, 33.96114], [-117.25423, 33.961], [-117.25458, 33.961], [-117.25459, 33.96098], [-117.25115, 33.9587], [-117.24533, 33.95605], [-117.24463, 33.95577], [-117.24495, 33.95304], [-117.24724, 33.95255], [-117.25382, 33.95299], [-117.25377, 33.95324], [-117.2537, 33.95333], [-117.25311, 33.95387], [-117.25252, 33.95447], [-117.25288, 33.95566], [-117.25227, 33.95566], [-117.25226, 33.95567], [-117.25274, 33.95694], [-117.25304, 33.95766], [-117.25507, 33.95786], [-117.25521, 33.95813], [-117.25497, 33.95822], [-117.25508, 33.95844], [-117.25534, 33.95837], [-117.25637, 33.96037], [-117.25675, 33.96104], [-117.25696, 33.96104], [-117.25699, 33.96349], [-117.2581, 33.96493], [-117.25811, 33.968]]], [[[-117.2694, 33.97192], [-117.26938, 33.97231], [-117.26928, 33.97265], [-117.26914, 33.97287], [-117.26905, 33.97298], [-117.26883, 33.97319], [-117.26869, 33.97329], [-117.26777, 33.97386], [-117.26773, 33.97385], [-117.26857, 33.97332], [-117.268, 33.97318], [-117.26792, 33.97321], [-117.26787, 33.97316], [-117.26775, 33.97314], [-117.26774, 33.9731], [-117.2674, 33.97302], [-117.26732, 33.97315], [-117.26705, 33.97305], [-117.26679, 33.97301], [-117.2664, 33.9729], [-117.26512, 33.97241], [-117.26466, 33.97231], [-117.26401, 33.97223], [-117.26378, 33.97224], [-117.26364, 33.97228], [-117.26356, 33.97235], [-117.26356, 33.97238], [-117.26358, 33.97241], [-117.26375, 33.97255], [-117.2637, 33.97262], [-117.26369, 33.97269], [-117.26348, 33.97262], [-117.26343, 33.97262], [-117.26339, 33.97266], [-117.26336, 33.97338], [-117.26336, 33.97356], [-117.26338, 33.97368], [-117.26341, 33.97379], [-117.26353, 33.97401], [-117.26365, 33.97416], [-117.26377, 33.97426], [-117.26391, 33.97436], [-117.26407, 33.97444], [-117.26548, 33.97498], [-117.26549, 33.97499], [-117.26537, 33.97521], [-117.26535, 33.97536], [-117.26539, 33.97546], [-117.26544, 33.97554], [-117.26555, 33.97563], [-117.26567, 33.97569], [-117.26575, 33.97571], [-117.26587, 33.97571], [-117.26636, 33.97568], [-117.26635, 33.97556], [-117.26642, 33.97519], [-117.26645, 33.97523], [-117.26641, 33.97535], [-117.2664, 33.97575], [-117.26644, 33.97597], [-117.2665, 33.97615], [-117.26675, 33.97664], [-117.2669, 33.97698], [-117.26702, 33.97742], [-117.26711, 33.97806], [-117.26719, 33.97843], [-117.26737, 33.97889], [-117.26753, 33.97919], [-117.26765, 33.97948], [-117.26773, 33.9798], [-117.26775, 33.98009], [-117.26772, 33.98044], [-117.26766, 33.98071], [-117.26747, 33.98111], [-117.26738, 33.98114], [-117.26734, 33.98112], [-117.2675, 33.9809], [-117.2675, 33.98087], [-117.26723, 33.98069], [-117.26701, 33.98047], [-117.26684, 33.98026], [-117.2667, 33.97995], [-117.26666, 33.97978], [-117.26663, 33.97961], [-117.26664, 33.97955], [-117.26664, 33.97899], [-117.26659, 33.97854], [-117.2665, 33.9781], [-117.26638, 33.9777], [-117.26626, 33.97738], [-117.26606, 33.97696], [-117.26584, 33.97659], [-117.2657, 33.97643], [-117.26557, 33.97632], [-117.26537, 33.9762], [-117.26522, 33.97613], [-117.26494, 33.97605], [-117.26398, 33.97588], [-117.26383, 33.97569], [-117.26376, 33.97525], [-117.26362, 33.97527], [-117.26362, 33.97524], [-117.2636, 33.97521], [-117.26331, 33.97516], [-117.26345, 33.97502], [-117.26348, 33.97495], [-117.26347, 33.97488], [-117.26342, 33.97483], [-117.26336, 33.9748], [-117.26326, 33.9748], [-117.26323, 33.97482], [-117.2632, 33.97478], [-117.26278, 33.97468], [-117.26279, 33.97449], [-117.26277, 33.97432], [-117.26275, 33.97431], [-117.26243, 33.97431], [-117.26242, 33.97416], [-117.26271, 33.97414], [-117.26275, 33.97411], [-117.26274, 33.97397], [-117.26264, 33.97354], [-117.26261, 33.97309], [-117.26265, 33.97265], [-117.26271, 33.97238], [-117.26269, 33.97236], [-117.26239, 33.97236], [-117.26243, 33.97228], [-117.26242, 33.97219], [-117.26239, 33.97215], [-117.26233, 33.97212], [-117.26223, 33.97212], [-117.26219, 33.97205], [-117.26166, 33.97204], [-117.26165, 33.96882], [-117.26172, 33.96833], [-117.26259, 33.96832], [-117.26252, 33.96834], [-117.26248, 33.96838], [-117.26244, 33.96845], [-117.26245, 33.96889], [-117.26249, 33.96893], [-117.26254, 33.96893], [-117.26279, 33.96879], [-117.26288, 33.96885], [-117.26279, 33.969], [-117.26279, 33.96907], [-117.2628, 33.9691], [-117.26303, 33.96934], [-117.26296, 33.96939], [-117.26264, 33.96925], [-117.26261, 33.96927], [-117.26255, 33.96948], [-117.26256, 33.96963], [-117.2627, 33.96994], [-117.26263, 33.97007], [-117.26265, 33.9703], [-117.26282, 33.9705], [-117.26307, 33.97068], [-117.26297, 33.97089], [-117.26301, 33.97112], [-117.26328, 33.971], [-117.26333, 33.97106], [-117.26318, 33.97127], [-117.26319, 33.97129], [-117.26344, 33.97135], [-117.2637, 33.97132], [-117.26387, 33.9712], [-117.26395, 33.97107], [-117.26413, 33.97088], [-117.26452, 33.97071], [-117.26465, 33.97086], [-117.26493, 33.97106], [-117.26517, 33.97085], [-117.26537, 33.97103], [-117.26511, 33.97125], [-117.26532, 33.97145], [-117.26548, 33.97157], [-117.26565, 33.97166], [-117.26583, 33.97173], [-117.26649, 33.97191], [-117.26727, 33.97208], [-117.26738, 33.97178], [-117.26752, 33.97181], [-117.26742, 33.97212], [-117.26808, 33.97227], [-117.2683, 33.97231], [-117.26852, 33.97232], [-117.26936, 33.97219], [-117.26938, 33.97213], [-117.26937, 33.9719], [-117.2694, 33.97192]]], [[[-117.27259, 33.97065], [-117.27256, 33.97187], [-117.27205, 33.97186], [-117.27196, 33.97207], [-117.27186, 33.9721], [-117.27181, 33.97217], [-117.27181, 33.97224], [-117.27186, 33.97234], [-117.2705, 33.97242], [-117.27052, 33.97272], [-117.27035, 33.97275], [-117.27013, 33.97283], [-117.26994, 33.97293], [-117.26965, 33.97314], [-117.26952, 33.9733], [-117.26945, 33.97331], [-117.26922, 33.97315], [-117.26922, 33.97309], [-117.26937, 33.97289], [-117.26947, 33.97271], [-117.2696, 33.97236], [-117.26962, 33.97197], [-117.26961, 33.97189], [-117.26964, 33.97185], [-117.26966, 33.97193], [-117.26967, 33.97214], [-117.27007, 33.97204], [-117.27069, 33.97194], [-117.27092, 33.97186], [-117.27162, 33.97151], [-117.27145, 33.97126], [-117.27157, 33.9712], [-117.27175, 33.97145], [-117.272, 33.97133], [-117.27218, 33.97118], [-117.27247, 33.97085], [-117.27252, 33.97063], [-117.27259, 33.97065]]]]} | Open Access 1 | 17469 | City of Moreno Valley Open Space | 6975 | 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 | 471.264 | City of Moreno Valley OS | 0 | Local Recreation Area 3 | 4 | |
26 | 26 | 25 | {"type": "Polygon", "coordinates": [[[-117.08357, 32.75155], [-117.08352, 32.75156], [-117.08352, 32.75251], [-117.08356, 32.75252], [-117.08356, 32.75298], [-117.08332, 32.75306], [-117.08317, 32.75308], [-117.08165, 32.75308], [-117.08164, 32.75303], [-117.08042, 32.75302], [-117.0804, 32.75307], [-117.07989, 32.75305], [-117.07986, 32.753], [-117.07987, 32.75272], [-117.0797, 32.7518], [-117.07969, 32.75051], [-117.07966, 32.7505], [-117.07967, 32.74994], [-117.08202, 32.74993], [-117.08203, 32.75], [-117.08346, 32.75002], [-117.08348, 32.75006], [-117.08343, 32.75131], [-117.08356, 32.75132], [-117.08357, 32.75155]]]} | Open Access 1 | 89 | Colina Del Sol Community Park | 17497 | 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.899 | Colina Del Sol Community Park | 0 | Local Park 2 | 4 | |
27 | 27 | 26 | {"type": "Polygon", "coordinates": [[[-118.40012, 33.99275], [-118.39867, 33.9928], [-118.39865, 33.99222], [-118.39914, 33.99221], [-118.39922, 33.99218], [-118.39931, 33.99211], [-118.40012, 33.99275]]]} | Open Access 1 | 78 | El Marino Park | 18512 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 1.645 | El Marino Park | 0 | Local Park 2 | 4 | |
28 | 28 | 27 | {"type": "Polygon", "coordinates": [[[-117.89558, 33.75242], [-117.89529, 33.75244], [-117.89531, 33.75329], [-117.8936, 33.75333], [-117.89359, 33.75197], [-117.89397, 33.75194], [-117.89398, 33.75162], [-117.89558, 33.75161], [-117.89558, 33.75242]]]} | Open Access 1 | 154 | El Salvador Park | 18538 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 7.57 | El Salvador Park | 0 | Local Park 2 | 4 | |
29 | 29 | 28 | {"type": "Polygon", "coordinates": [[[-117.08212, 32.83605], [-117.08201, 32.83608], [-117.08196, 32.83613], [-117.08194, 32.83618], [-117.08196, 32.83628], [-117.08204, 32.83636], [-117.08165, 32.83637], [-117.08171, 32.83615], [-117.08175, 32.8361], [-117.08182, 32.83613], [-117.08206, 32.83602], [-117.08212, 32.83605]]]} | Open Access 1 | 46752 | Corte Playa San Juan Mini-Park | 30203 | 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.206 | Corte Playa San Juan Mini-Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);