superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,670 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 2 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 431
- San Diego, City of 408
- San Jose, City of 247
- San Francisco, City and County of 238
- Sacramento, City of 214
- Ventura, City of 149
- Long Beach, City of 135
- Oakland, City of 122
- Roseville, City of 117
- Irvine, City of 97
- Fresno, City of 91
- Modesto, City of 78
- Stockton, City of 77
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Rosa, City of 72
- Brentwood, City of 68
- Chula Vista, City of 67
- Santa Cruz, City of 65
- Newport Beach, City of 65
- Poway, City of 64
- San Luis Obispo, City of 61
- Davis, City of 61
- Clovis, City of 61
- Anaheim, City of 59
- Bakersfield, City of 59
- Manteca, City of 59
- Riverside, City of 57
- Fremont, City of 56
- Napa, City of 55
- …
MNG_AG_TYP 1
- City Agency · 9,670 ✖
ACCESS_TYP 1
- Open Access · 9,670 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL ▼ | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5 | 5 | 4 | {"type": "Polygon", "coordinates": [[[-115.49103, 32.68828], [-115.49059, 32.68816], [-115.48996, 32.68793], [-115.48966, 32.68785], [-115.48947, 32.68784], [-115.48945, 32.68778], [-115.48946, 32.68677], [-115.49041, 32.68677], [-115.49042, 32.6874], [-115.49103, 32.6874], [-115.49103, 32.68828]]]} | Open Access 1 | Kennedy Gardens Large | 33476 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 4.156 | Kennedy Gardens Large | ||
6 | 6 | 5 | {"type": "Polygon", "coordinates": [[[-123.02509, 38.79963], [-123.02404, 38.79987], [-123.02384, 38.79928], [-123.02367, 38.79883], [-123.02439, 38.79818], [-123.02446, 38.79822], [-123.02466, 38.79839], [-123.02474, 38.79854], [-123.02509, 38.79963]]]} | Open Access 1 | Vintage Meadows Park | 33477 | 1059 | Cloverdale, City of 404 | City 2 | City Agency 2 | http://www.cloverdale.net/index.aspx?nid=152 | City 2 | 3.513 | Vintage Meadows Park | ||
10 | 10 | 9 | {"type": "Polygon", "coordinates": [[[-120.98579, 37.65634], [-120.9858, 37.65675], [-120.98577, 37.65684], [-120.98545, 37.65716], [-120.98541, 37.65717], [-120.98537, 37.65716], [-120.98535, 37.65713], [-120.98535, 37.65634], [-120.98538, 37.65633], [-120.98577, 37.65633], [-120.98579, 37.65634]]]} | Open Access 1 | Asby Park | 15644 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 0.745 | Asby Park | ||
11 | 11 | 10 | {"type": "Polygon", "coordinates": [[[-122.48901, 37.89521], [-122.4888, 37.89557], [-122.48822, 37.89497], [-122.4877, 37.89489], [-122.48636, 37.89374], [-122.48611, 37.89392], [-122.48646, 37.89424], [-122.48719, 37.89499], [-122.487, 37.89509], [-122.4865, 37.89457], [-122.48594, 37.89402], [-122.48532, 37.89353], [-122.48479, 37.89316], [-122.48493, 37.89301], [-122.4846, 37.89232], [-122.48478, 37.8918], [-122.48451, 37.89148], [-122.48438, 37.89133], [-122.48415, 37.89126], [-122.4841, 37.89121], [-122.4843, 37.8909], [-122.48771, 37.89414], [-122.48858, 37.89488], [-122.48901, 37.89521]]]} | Open Access 1 | McKegney Green | 31739 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 11.486 | McKegney Green | ||
12 | 12 | 11 | {"type": "MultiPolygon", "coordinates": [[[[-122.47229, 37.88394], [-122.47228, 37.88408], [-122.47155, 37.88354], [-122.47113, 37.88331], [-122.47071, 37.88311], [-122.46655, 37.88146], [-122.46617, 37.88128], [-122.46582, 37.88107], [-122.46549, 37.88084], [-122.46519, 37.88058], [-122.46485, 37.88023], [-122.46461, 37.87994], [-122.46398, 37.87905], [-122.46375, 37.87876], [-122.46349, 37.87828], [-122.46366, 37.87841], [-122.46393, 37.87866], [-122.46418, 37.87896], [-122.46473, 37.87971], [-122.46513, 37.88021], [-122.46543, 37.88051], [-122.46589, 37.88087], [-122.46654, 37.88124], [-122.46914, 37.88228], [-122.47044, 37.88282], [-122.47137, 37.88329], [-122.47177, 37.88352], [-122.47191, 37.88361], [-122.47229, 37.88394]]], [[[-122.48493, 37.89302], [-122.48479, 37.89316], [-122.48443, 37.89294], [-122.48443, 37.89291], [-122.48369, 37.89248], [-122.48336, 37.89224], [-122.48307, 37.89199], [-122.48301, 37.8919], [-122.4828, 37.89168], [-122.48218, 37.89088], [-122.4819, 37.89053], [-122.48142, 37.89016], [-122.48098, 37.8899], [-122.48092, 37.88992], [-122.48079, 37.88983], [-122.48052, 37.8897], [-122.47978, 37.88947], [-122.47892, 37.88905], [-122.47831, 37.88873], [-122.47672, 37.88778], [-122.4767, 37.88778], [-122.47506, 37.88663], [-122.47435, 37.88604], [-122.47238, 37.88426], [-122.47239, 37.88407], [-122.47364, 37.88519], [-122.4749, 37.88627], [-122.47624, 37.88729], [-122.47681, 37.88766], [-122.47834, 37.88856], [-122.47903, 37.88892], [-122.47991, 37.88929], [-122.48072, 37.88955], [-122.48094, 37.88965], [-122.48151, 37.88999], [-122.48174, 37.89016], [-122.48195, 37.89034], [-122.48214, 37.89054], [-122.48321, 37.89188], [-122.48365, 37.89224], [-122.48392, 37.89233], [-122.48424, 37.8926], [-122.48493, 37.89302]]]]} | Open Access 1 | Richardson Bay Lineal Park | 31740 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 11.346 | Richardson Bay Lineal Park | ||
13 | 13 | 12 | {"type": "Polygon", "coordinates": [[[-122.48493, 37.89302], [-122.48424, 37.8926], [-122.48392, 37.89233], [-122.48365, 37.89224], [-122.48351, 37.89213], [-122.48321, 37.89188], [-122.48243, 37.89091], [-122.48254, 37.89102], [-122.48261, 37.89097], [-122.48262, 37.8908], [-122.48269, 37.89064], [-122.48315, 37.89035], [-122.4833, 37.89039], [-122.48364, 37.89071], [-122.48415, 37.89126], [-122.48438, 37.89133], [-122.48478, 37.8918], [-122.4846, 37.89232], [-122.48493, 37.89302]]]} | Open Access 1 | South of the Knoll Park | 31741 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 6.521 | South of the Knoll Park | ||
15 | 15 | 14 | {"type": "Polygon", "coordinates": [[[-122.49781, 37.89952], [-122.49774, 37.89961], [-122.49721, 37.9006], [-122.49629, 37.90023], [-122.49657, 37.89917], [-122.49687, 37.89929], [-122.49723, 37.89941], [-122.49781, 37.89952]]]} | Open Access 1 | Highlands Subdivision Open Space | 31738 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 3.056 | Highlands Subdivision OS | ||
16 | 16 | 15 | {"type": "Polygon", "coordinates": [[[-117.1296, 32.71069], [-117.1296, 32.71124], [-117.12944, 32.71124], [-117.12944, 32.71069], [-117.1296, 32.71069]]]} | Open Access 1 | 30th Street Mini Park | 15192 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.23 | 30th Street MP | ||
18 | 18 | 17 | {"type": "Polygon", "coordinates": [[[-122.49207, 37.89502], [-122.49188, 37.89527], [-122.49079, 37.89555], [-122.49079, 37.89576], [-122.49092, 37.89579], [-122.49107, 37.8958], [-122.49135, 37.89577], [-122.49174, 37.89565], [-122.49186, 37.89557], [-122.49165, 37.8958], [-122.49148, 37.89584], [-122.49147, 37.89589], [-122.49077, 37.89627], [-122.49017, 37.89668], [-122.49009, 37.89668], [-122.49005, 37.89662], [-122.49015, 37.89626], [-122.49019, 37.89623], [-122.49024, 37.89622], [-122.49065, 37.89624], [-122.49071, 37.89602], [-122.49032, 37.89613], [-122.48994, 37.89615], [-122.48996, 37.89622], [-122.48981, 37.89665], [-122.48973, 37.89683], [-122.48963, 37.89701], [-122.48951, 37.89719], [-122.48936, 37.89734], [-122.48928, 37.89729], [-122.48902, 37.89749], [-122.48902, 37.8975], [-122.48907, 37.89755], [-122.48868, 37.89782], [-122.48855, 37.89788], [-122.48835, 37.89791], [-122.48816, 37.89789], [-122.48796, 37.89782], [-122.48779, 37.89769], [-122.48769, 37.89754], [-122.48766, 37.89745], [-122.48766, 37.89732], [-122.48779, 37.89686], [-122.48783, 37.89657], [-122.4878, 37.89631], [-122.48777, 37.89617], [-122.48768, 37.89597], [-122.48746, 37.89564], [-122.48724, 37.89534], [-122.487, 37.89509], [-122.48719, 37.895], [-122.48776, 37.89556], [-122.48817, 37.89532], [-122.4877, 37.89489], [-122.48822, 37.89497], [-122.48881, 37.89557], [-122.48954, 37.89554], [-122.48961, 37.89543], [-122.48971, 37.89544], [-122.49016, 37.89536], [-122.4916, 37.89498], [-122.49207, 37.89502]]]} | Open Access 1 | Blackie's Pasture | 31743 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 15.478 | Blackie's Pasture | ||
25 | 25 | 24 | {"type": "Polygon", "coordinates": [[[-117.22514, 33.57752], [-117.22474, 33.57763], [-117.22503, 33.57866], [-117.22368, 33.57761], [-117.22385, 33.57746], [-117.22408, 33.5773], [-117.22431, 33.57718], [-117.22457, 33.57707], [-117.22472, 33.57756], [-117.22513, 33.57748], [-117.22514, 33.57752]]]} | Open Access 1 | Antigua Park | 15519 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 2.282 | Antigua Park | ||
29 | 29 | 28 | {"type": "Polygon", "coordinates": [[[-121.55005, 38.66466], [-121.54694, 38.6659], [-121.54688, 38.66578], [-121.54685, 38.66564], [-121.54679, 38.66557], [-121.54682, 38.66554], [-121.54681, 38.66549], [-121.5491, 38.66457], [-121.55005, 38.66416], [-121.55005, 38.66466]]]} | Open Access 1 | Egret Park Open Space | 18469 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.603 | Egret Park OS | ||
30 | 30 | 29 | {"type": "MultiPolygon", "coordinates": [[[[-117.45748, 33.93032], [-117.45696, 33.93055], [-117.45684, 33.9303], [-117.45635, 33.9303], [-117.45634, 33.92971], [-117.45667, 33.92988], [-117.45692, 33.92988], [-117.45719, 33.92984], [-117.45748, 33.93032]]], [[[-117.46005, 33.93408], [-117.45945, 33.93387], [-117.45903, 33.93388], [-117.45891, 33.93342], [-117.45839, 33.93259], [-117.45813, 33.93269], [-117.45809, 33.93262], [-117.45833, 33.93249], [-117.45785, 33.93171], [-117.45762, 33.93157], [-117.45742, 33.93157], [-117.45754, 33.93125], [-117.45743, 33.93101], [-117.45709, 33.93091], [-117.45701, 33.93071], [-117.45758, 33.93047], [-117.45766, 33.93059], [-117.45798, 33.93077], [-117.45806, 33.93088], [-117.45867, 33.93184], [-117.45891, 33.93175], [-117.45898, 33.93186], [-117.45875, 33.93199], [-117.4592, 33.93271], [-117.45924, 33.93286], [-117.45933, 33.93298], [-117.45956, 33.93287], [-117.45967, 33.93295], [-117.45957, 33.93317], [-117.4598, 33.93348], [-117.45976, 33.93354], [-117.45977, 33.93361], [-117.4598, 33.93366], [-117.45989, 33.93372], [-117.45993, 33.93376], [-117.46002, 33.93393], [-117.46005, 33.93408]]]]} | Open Access 1 | El Dorado Open Space Park | 18503 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 8.445 | El Dorado OS Park | ||
31 | 31 | 30 | {"type": "MultiPolygon", "coordinates": [[[[-117.03192, 32.71435], [-117.03192, 32.71458], [-117.02892, 32.7154], [-117.02858, 32.71552], [-117.02823, 32.71566], [-117.02786, 32.71584], [-117.02757, 32.71601], [-117.02701, 32.71574], [-117.02692, 32.71561], [-117.02817, 32.71536], [-117.02875, 32.71491], [-117.02926, 32.71481], [-117.03019, 32.71466], [-117.03192, 32.71435]]], [[[-117.03286, 32.71467], [-117.03255, 32.71474], [-117.03254, 32.71477], [-117.03239, 32.7148], [-117.03224, 32.71491], [-117.0321, 32.71434], [-117.03243, 32.71411], [-117.03254, 32.71383], [-117.03262, 32.71402], [-117.03272, 32.71416], [-117.03286, 32.71467]]], [[[-117.03416, 32.71343], [-117.03405, 32.71351], [-117.03386, 32.71331], [-117.03402, 32.71328], [-117.03416, 32.71343]]], [[[-117.03542, 32.71289], [-117.0353, 32.71299], [-117.03508, 32.71277], [-117.03473, 32.71302], [-117.03502, 32.71334], [-117.03493, 32.71345], [-117.03468, 32.71321], [-117.03456, 32.71329], [-117.03416, 32.71289], [-117.03419, 32.71288], [-117.03436, 32.71291], [-117.03453, 32.71287], [-117.03461, 32.71283], [-117.03502, 32.71249], [-117.03542, 32.71289]]], [[[-117.03463, 32.71357], [-117.03444, 32.71372], [-117.03423, 32.7135], [-117.03434, 32.71342], [-117.03442, 32.7135], [-117.03451, 32.71346], [-117.03463, 32.71357]]], [[[-117.03603, 32.71207], [-117.03547, 32.71248], [-117.03575, 32.71277], [-117.03561, 32.71286], [-117.03513, 32.71239], [-117.03524, 32.71228], [-117.03533, 32.71214], [-117.03537, 32.71202], [-117.03539, 32.71184], [-117.03603, 32.71207]]], [[[-117.03787, 32.71075], [-117.03723, 32.71121], [-117.03724, 32.71202], [-117.03697, 32.71164], [-117.03695, 32.71077], [-117.03787, 32.71075]]], [[[-117.03705, 32.7123], [-117.03703, 32.71236], [-117.03698, 32.71239], [-117.03697, 32.71218], [-117.03705, 32.7123]]], [[[-117.04564, 32.70908], [-117.04562, 32.70918], [-117.04555, 32.70927], [-117.04513, 32.70952], [-117.04496, 32.70958], [-117.04459, 32.70965], [-117.04441, 32.7097], [-117.0444, 32.70968], [-117.04564, 32.70908]]], [[[-117.0479, 32.70912], [-117.04758, 32.70951], [-117.0474, 32.70956], [-117.04722, 32.70953], [-117.04686, 32.70934], [-117.04672, 32.70943], [-117.04668, 32.70957], [-117.04644, 32.70957], [-117.04643, 32.70939], [-117.04624, 32.70932], [-117.04611, 32.70922], [-117.04603, 32.70907], [-117.04601, 32.70889], [-117.04591, 32.70885], [-117.04579, 32.70887], [-117.0457, 32.70892], [-117.04564, 32.70901], [-117.04564, 32.70868], [-117.04716, 32.70856], [-117.04765, 32.70903], [-117.04772, 32.70903], [-117.0479, 32.70912]]], [[[-117.04869, 32.70945], [-117.04868, 32.71023], [-117.04828, 32.71023], [-117.04827, 32.70945], [-117.04869, 32.70945]]]]} | Open Access 1 | Encanto Expressway Open Space | 18635 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 14.138 | Encanto Expressway OS | ||
32 | 32 | 31 | {"type": "Polygon", "coordinates": [[[-120.62887, 35.24511], [-120.62865, 35.24516], [-120.62847, 35.24527], [-120.62836, 35.24539], [-120.62827, 35.24554], [-120.62821, 35.2457], [-120.62803, 35.2464], [-120.62795, 35.24665], [-120.62799, 35.24681], [-120.62799, 35.24688], [-120.62825, 35.24692], [-120.62826, 35.24699], [-120.62791, 35.24694], [-120.6274, 35.24712], [-120.62739, 35.24715], [-120.6267, 35.24714], [-120.6267, 35.24699], [-120.62675, 35.24682], [-120.62707, 35.24701], [-120.6276, 35.24683], [-120.62764, 35.24643], [-120.6278, 35.246], [-120.62778, 35.24579], [-120.62719, 35.24569], [-120.62668, 35.24573], [-120.62675, 35.24555], [-120.62722, 35.24551], [-120.62749, 35.24551], [-120.62781, 35.24557], [-120.62805, 35.24523], [-120.6282, 35.24507], [-120.62841, 35.24492], [-120.62861, 35.2449], [-120.62877, 35.245], [-120.62887, 35.24511]]]} | Open Access 1 | Islay Creek Open Space | 20283 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 3.151 | Islay Creek OS | ||
35 | 35 | 34 | {"type": "Polygon", "coordinates": [[[-117.29529, 34.117], [-117.29481, 34.11701], [-117.29479, 34.11703], [-117.2943, 34.11703], [-117.2943, 34.11635], [-117.29453, 34.11634], [-117.29454, 34.11612], [-117.29467, 34.1161], [-117.29467, 34.11591], [-117.29529, 34.1159], [-117.29529, 34.117]]]} | Open Access 1 | Bryce Edward Hanes Park | 31758 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 2.453 | Bryce Edward Hanes Park | 2017 | |
38 | 38 | 37 | {"type": "Polygon", "coordinates": [[[-116.96266, 33.79047], [-116.96174, 33.79124], [-116.96034, 33.79008], [-116.96121, 33.78934], [-116.96266, 33.79047]]]} | Open Access 1 | Sallee Park | 32819 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 5.326 | Sallee Park | ||
41 | 41 | 40 | {"type": "MultiPolygon", "coordinates": [[[[-118.21753, 34.15863], [-118.21582, 34.15898], [-118.21571, 34.15897], [-118.21567, 34.15899], [-118.21555, 34.1591], [-118.21544, 34.15913], [-118.21535, 34.15913], [-118.21526, 34.15911], [-118.21513, 34.159], [-118.21502, 34.15898], [-118.21491, 34.159], [-118.21476, 34.15915], [-118.2147, 34.15918], [-118.21461, 34.15921], [-118.21446, 34.15921], [-118.21436, 34.15918], [-118.21429, 34.15914], [-118.21411, 34.15897], [-118.21401, 34.15903], [-118.21382, 34.15902], [-118.21376, 34.15915], [-118.2139, 34.15921], [-118.21373, 34.15952], [-118.21352, 34.15935], [-118.21348, 34.15944], [-118.21342, 34.15949], [-118.21338, 34.15955], [-118.21337, 34.15968], [-118.21332, 34.15975], [-118.21305, 34.1599], [-118.2129, 34.16004], [-118.21276, 34.16012], [-118.2126, 34.16014], [-118.2125, 34.16012], [-118.21241, 34.16008], [-118.21236, 34.16007], [-118.21229, 34.16009], [-118.21227, 34.16015], [-118.21186, 34.15997], [-118.2109, 34.16091], [-118.21065, 34.1609], [-118.21055, 34.16095], [-118.21049, 34.161], [-118.21035, 34.16122], [-118.21032, 34.16125], [-118.21023, 34.16127], [-118.20965, 34.16121], [-118.20956, 34.16124], [-118.20952, 34.16128], [-118.20941, 34.16129], [-118.20939, 34.16127], [-118.20924, 34.16126], [-118.20911, 34.16123], [-118.20901, 34.16164], [-118.20901, 34.16185], [-118.20909, 34.16191], [-118.20906, 34.16199], [-118.2088, 34.16195], [-118.20866, 34.16216], [-118.20859, 34.16214], [-118.2084, 34.16231], [-118.20846, 34.16241], [-118.20849, 34.1625], [-118.20848, 34.16257], [-118.20846, 34.16259], [-118.20832, 34.16267], [-118.2082, 34.16266], [-118.20806, 34.16253], [-118.20787, 34.16243], [-118.20777, 34.16245], [-118.20766, 34.16251], [-118.20763, 34.1626], [-118.20763, 34.16272], [-118.20766, 34.16285], [-118.20763, 34.16298], [-118.20767, 34.16314], [-118.20769, 34.16318], [-118.20768, 34.16323], [-118.20766, 34.16325], [-118.20757, 34.16328], [-118.20745, 34.16323], [-118.20735, 34.16321], [-118.20727, 34.16322], [-118.2072, 34.16325], [-118.20715, 34.16328], [-118.20709, 34.16337], [-118.20709, 34.16347], [-118.20711, 34.16355], [-118.20708, 34.16358], [-118.20702, 34.1636], [-118.20696, 34.16357], [-118.20686, 34.16347], [-118.2066, 34.16339], [-118.20637, 34.16326], [-118.20625, 34.16324], [-118.20615, 34.16327], [-118.20608, 34.16333], [-118.20606, 34.16338], [-118.20607, 34.16348], [-118.20597, 34.16348], [-118.20578, 34.16367], [-118.2055, 34.16365], [-118.20525, 34.16368], [-118.20528, 34.16403], [-118.20522, 34.16403], [-118.20517, 34.16406], [-118.20519, 34.16411], [-118.20518, 34.1642], [-118.2051, 34.16431], [-118.20499, 34.16441], [-118.20493, 34.16449], [-118.20492, 34.16456], [-118.20493, 34.16463], [-118.20468, 34.16481], [-118.20485, 34.16495], [-118.20489, 34.16506], [-118.20512, 34.16505], [-118.20516, 34.1652], [-118.20507, 34.16535], [-118.20469, 34.16552], [-118.20471, 34.1657], [-118.20498, 34.16588], [-118.20501, 34.16596], [-118.20492, 34.16609], [-118.20473, 34.16622], [-118.20408, 34.1664], [-118.20376, 34.16655], [-118.20119, 34.16812], [-118.20015, 34.16873], [-118.19869, 34.16891], [-118.19937, 34.16779], [-118.20106, 34.1656], [-118.20232, 34.16387], [-118.20432, 34.16106], [-118.20561, 34.15939], [-118.20653, 34.15904], [-118.20669, 34.1593], [-118.20907, 34.15842], [-118.20908, 34.1584], [-118.20889, 34.15804], [-118.20903, 34.15793], [-118.20912, 34.15782], [-118.20919, 34.15768], [-118.20922, 34.15759], [-118.20922, 34.15743], [-118.21144, 34.15658], [-118.21568, 34.157], [-118.21666, 34.15788], [-118.21753, 34.15863]]], [[[-118.20708, 34.16433], [-118.20692, 34.16449], [-118.20676, 34.16476], [-118.20673, 34.16477], [-118.20671, 34.16477], [-118.20679, 34.16451], [-118.20679, 34.16447], [-118.20675, 34.16438], [-118.20664, 34.16427], [-118.20661, 34.16422], [-118.20659, 34.16413], [-118.20687, 34.16408], [-118.20708, 34.16433]]]]} | Open Access 1 | Murchison Open Space | 22601 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 150.152 | Murchison OS | ||
42 | 42 | 41 | {"type": "MultiPolygon", "coordinates": [[[[-117.08618, 32.78287], [-117.08622, 32.78293], [-117.08624, 32.78303], [-117.08622, 32.78311], [-117.08617, 32.7832], [-117.08531, 32.78378], [-117.08524, 32.78389], [-117.0852, 32.78402], [-117.08519, 32.78416], [-117.08523, 32.78429], [-117.08533, 32.78443], [-117.08553, 32.78456], [-117.0856, 32.78469], [-117.08463, 32.78553], [-117.08436, 32.78592], [-117.0838, 32.78593], [-117.08272, 32.78658], [-117.08188, 32.7879], [-117.08286, 32.78773], [-117.08044, 32.79012], [-117.08043, 32.79016], [-117.08034, 32.79009], [-117.08057, 32.78985], [-117.0793, 32.78893], [-117.07776, 32.79006], [-117.07763, 32.79017], [-117.07667, 32.79085], [-117.07584, 32.79148], [-117.07542, 32.79293], [-117.07593, 32.79393], [-117.07626, 32.79416], [-117.07659, 32.79381], [-117.0766, 32.79377], [-117.07671, 32.79385], [-117.07667, 32.79385], [-117.07664, 32.79387], [-117.07561, 32.79498], [-117.07591, 32.79563], [-117.07546, 32.79607], [-117.07495, 32.79571], [-117.0747, 32.79596], [-117.07404, 32.79548], [-117.07362, 32.79414], [-117.07449, 32.79342], [-117.07448, 32.79296], [-117.07389, 32.79245], [-117.07286, 32.79331], [-117.06841, 32.79401], [-117.06839, 32.79409], [-117.06843, 32.79426], [-117.06836, 32.7943], [-117.06808, 32.79402], [-117.06769, 32.79358], [-117.0676, 32.79345], [-117.0676, 32.79336], [-117.06773, 32.79353], [-117.06781, 32.79355], [-117.06852, 32.79334], [-117.06922, 32.79322], [-117.07092, 32.79298], [-117.07154, 32.79284], [-117.07175, 32.79276], [-117.07203, 32.79268], [-117.07252, 32.79249], [-117.07267, 32.79241], [-117.07272, 32.79241], [-117.07334, 32.79207], [-117.07408, 32.79157], [-117.0754, 32.79057], [-117.07323, 32.78843], [-117.07149, 32.78856], [-117.07143, 32.7885], [-117.07022, 32.78771], [-117.06892, 32.78716], [-117.0687, 32.78701], [-117.06765, 32.78579], [-117.06757, 32.78526], [-117.06807, 32.78473], [-117.06822, 32.78539], [-117.06985, 32.78614], [-117.07023, 32.7864], [-117.07028, 32.78636], [-117.07052, 32.78646], [-117.07051, 32.78654], [-117.07139, 32.78694], [-117.07187, 32.78714], [-117.07191, 32.78709], [-117.07267, 32.78742], [-117.07402, 32.78704], [-117.07404, 32.78702], [-117.07405, 32.78729], [-117.07496, 32.78863], [-117.07732, 32.78821], [-117.07817, 32.78757], [-117.07746, 32.78677], [-117.07421, 32.78551], [-117.07432, 32.78501], [-117.07451, 32.78473], [-117.07458, 32.78465], [-117.07655, 32.78524], [-117.07826, 32.78523], [-117.07841, 32.78539], [-117.07853, 32.78555], [-117.07906, 32.78608], [-117.07925, 32.78623], [-117.07969, 32.78654], [-117.08013, 32.78577], [-117.08138, 32.78469], [-117.08369, 32.78401], [-117.08345, 32.78298], [-117.08294, 32.78299], [-117.08288, 32.78279], [-117.08293, 32.78263], [-117.08618, 32.78287]]], [[[-117.08637, 32.78311], [-117.08635, 32.78329], [-117.08602, 32.78376], [-117.08606, 32.7838], [-117.08569, 32.78433], [-117.08555, 32.78436], [-117.0855, 32.78433], [-117.08544, 32.78428], [-117.08538, 32.78415], [-117.08537, 32.78403], [-117.08542, 32.7839], [-117.08551, 32.78382], [-117.0856, 32.78377], [-117.08621, 32.78334], [-117.08632, 32.78321], [-117.08637, 32.78311]]]]} | Open Access 1 | Navajo Canyon Open Space Park | 22675 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 155.928 | Navajo Canyon OS Park | ||
44 | 44 | 43 | {"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.73848], [-117.09279, 32.73755], [-117.09338, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.09361, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09322, 32.73912], [-117.09324, 32.74036], [-117.09385, 32.74037], [-117.09387, 32.74117], [-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 | 47th Street Canyon | 15202 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 10.029 | 47th Street Canyon | ||
49 | 49 | 48 | {"type": "Polygon", "coordinates": [[[-120.37312, 37.98464], [-120.37092, 37.98352], [-120.37013, 37.98316], [-120.36931, 37.98351], [-120.36816, 37.98404], [-120.36712, 37.98448], [-120.36706, 37.98392], [-120.36712, 37.98344], [-120.36852, 37.98162], [-120.37305, 37.98169], [-120.37304, 37.98224], [-120.37297, 37.98379], [-120.373, 37.98406], [-120.37308, 37.98438], [-120.37312, 37.98464]]]} | Open Access 1 | 49'er Rotary Park | 15205 | 1448 | Sonora, City of 635 | City 2 | City Agency 2 | http://www.sonoraca.com/visitsonora/trailsparks.htm | City 2 | 28.185 | 49'er Rotary Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);