superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_TYP = 2 sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 464
- San Diego, City of 431
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 217
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 124
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 94
- Modesto, City of 83
- Stockton, City of 81
- Santa Rosa, City of 79
- Huntington Beach, City of 76
- Tracy, City of 73
- Torrance, City of 72
- Santa Cruz, City of 69
- Chula Vista, City of 69
- Brentwood, City of 68
- Poway, City of 67
- Newport Beach, City of 65
- Santa Barbara, City of 64
- Davis, City of 64
- San Luis Obispo, City of 62
- Napa, City of 62
- Clovis, City of 62
- Bakersfield, City of 61
- Manteca, City of 60
- Anaheim, City of 58
- …
ACCESS_TYP 4
- Open Access 9,651
- Restricted Access 355
- No Public Access 155
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,190 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
53 | 53 | 52 | {"type": "MultiPolygon", "coordinates": [[[[-118.35436, 34.11245], [-118.35429, 34.11252], [-118.35299, 34.11466], [-118.35297, 34.11244], [-118.35436, 34.11245]]], [[[-118.35377, 34.11413], [-118.35376, 34.1142], [-118.35361, 34.11442], [-118.35357, 34.11455], [-118.35354, 34.11476], [-118.35355, 34.11511], [-118.3535, 34.11525], [-118.35333, 34.11551], [-118.35348, 34.11564], [-118.353, 34.11529], [-118.35299, 34.11526], [-118.35373, 34.11404], [-118.35377, 34.11413]]]]} | Open Access 1 | Runyon Canyon Park | 31769 | 1716 | Los Angeles Department of Recreation and Parks, City of 647 | City 2 | City Agency 2 | http://www.laparks.org/ | City 2 | 4.703 | Runyon Canyon Park | ||
58 | 58 | 57 | {"type": "Polygon", "coordinates": [[[-118.9278, 34.40667], [-118.92762, 34.40751], [-118.92752, 34.40771], [-118.92692, 34.40853], [-118.92688, 34.40856], [-118.92653, 34.40851], [-118.92642, 34.40797], [-118.92664, 34.40792], [-118.92683, 34.40784], [-118.92704, 34.40769], [-118.92716, 34.40754], [-118.92727, 34.40733], [-118.92733, 34.40712], [-118.92734, 34.40691], [-118.9273, 34.40666], [-118.92552, 34.40689], [-118.92551, 34.40687], [-118.92771, 34.40657], [-118.92778, 34.40661], [-118.9278, 34.40667]]]} | Open Access 1 | Delores Day Park | https://www.fillmoreca.com/departments/parks-and-recreation-department/parks/delores-day-park | 33480 | 1423 | Fillmore, City of 590 | City 2 | City Agency 2 | http://www.fillmoreca.com/rec-dept.htm | City 2 | 2.664 | Delores Day Park | |
60 | 60 | 59 | {"type": "Polygon", "coordinates": [[[-121.13133, 38.67036], [-121.13127, 38.67052], [-121.13089, 38.67043], [-121.1309, 38.67038], [-121.131, 38.67022], [-121.13133, 38.67036]]]} | Open Access 1 | Keller Mini Park | https://www.folsom.ca.us/parks/parks_n_trails/parks/parklist/keller_mini_park.asp | 33482 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 0.183 | Keller MP | |
64 | 64 | 63 | {"type": "Polygon", "coordinates": [[[-122.27515, 37.84778], [-122.27496, 37.84781], [-122.27489, 37.84744], [-122.27507, 37.84741], [-122.27515, 37.84778]]]} | Open Access 1 | 63rd Street Mini-Park | 15208 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.164 | 63rd Street Mini-Park | ||
88 | 88 | 87 | {"type": "Polygon", "coordinates": [[[-121.81438, 37.97557], [-121.81346, 37.97593], [-121.81013, 37.97849], [-121.80552, 37.97659], [-121.8055, 37.97661], [-121.8055, 37.97675], [-121.80486, 37.9766], [-121.80409, 37.97634], [-121.80327, 37.97567], [-121.80324, 37.9754], [-121.80326, 37.97517], [-121.80333, 37.97497], [-121.80346, 37.97479], [-121.80354, 37.9747], [-121.80373, 37.97456], [-121.80442, 37.97421], [-121.80467, 37.97405], [-121.80478, 37.97396], [-121.80496, 37.97376], [-121.80508, 37.97352], [-121.80529, 37.97278], [-121.80555, 37.97177], [-121.80557, 37.97145], [-121.80557, 37.97081], [-121.80557, 37.97013], [-121.80559, 37.96964], [-121.80559, 37.96849], [-121.81433, 37.96848], [-121.81438, 37.97557]]]} | Restricted Access 2 | Lone Tree Golf Course | 33051 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 198.555 | Lone Tree GC | ||
99 | 99 | 98 | {"type": "Polygon", "coordinates": [[[-118.83933, 34.17975], [-118.83904, 34.17981], [-118.83824, 34.18016], [-118.83821, 34.18014], [-118.83754, 34.18045], [-118.83673, 34.18059], [-118.83676, 34.18121], [-118.83643, 34.18122], [-118.83692, 34.18251], [-118.8377, 34.1825], [-118.83801, 34.18209], [-118.83818, 34.18207], [-118.8382, 34.18211], [-118.83863, 34.1821], [-118.83846, 34.18228], [-118.83836, 34.18251], [-118.83825, 34.18264], [-118.83775, 34.18335], [-118.83782, 34.18417], [-118.83767, 34.1842], [-118.83772, 34.18479], [-118.83751, 34.18489], [-118.83744, 34.18496], [-118.83729, 34.18535], [-118.83679, 34.18555], [-118.83464, 34.18576], [-118.83336, 34.18504], [-118.8334, 34.17476], [-118.83617, 34.17687], [-118.83758, 34.17879], [-118.83776, 34.17993], [-118.83931, 34.17966], [-118.83933, 34.17975]]]} | Open Access 1 | Glider Hill/Glider Hill Addition Open Space - City | 19345 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 94.954 | Glider Hill/Glider Hill Addition OS - City | ||
100 | 100 | 99 | {"type": "Polygon", "coordinates": [[[-122.47273, 37.75508], [-122.47256, 37.75525], [-122.47257, 37.75529], [-122.47226, 37.75545], [-122.47219, 37.75536], [-122.47216, 37.75526], [-122.47213, 37.75504], [-122.47212, 37.75467], [-122.47216, 37.75465], [-122.4722, 37.75466], [-122.47236, 37.75482], [-122.47273, 37.75508]]]} | Open Access 1 | Grand View Pk. Open Space | 19427 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.642 | Grand View Pk. OS | ||
105 | 105 | 104 | {"type": "Polygon", "coordinates": [[[-119.25309, 35.7678], [-119.25145, 35.76806], [-119.2512, 35.76698], [-119.25284, 35.76672], [-119.25309, 35.7678]]]} | Open Access 1 | Cesar Chavez Park | 17096 | 1084 | Delano, City of 436 | City 2 | City Agency 2 | http://www.cityofdelano.org/index.aspx?NID=90 | City 2 | 4.541 | Cesar Chavez Park | ||
107 | 107 | 106 | {"type": "Polygon", "coordinates": [[[-117.03382, 32.61286], [-117.03349, 32.6137], [-117.03347, 32.61384], [-117.03347, 32.61412], [-117.03353, 32.61451], [-117.03347, 32.61457], [-117.033, 32.61462], [-117.0322, 32.61478], [-117.03167, 32.61487], [-117.03113, 32.61491], [-117.03111, 32.61487], [-117.03317, 32.61428], [-117.03268, 32.61309], [-117.03299, 32.61322], [-117.0333, 32.61316], [-117.03363, 32.6128], [-117.03382, 32.61286]]]} | Open Access 1 | Greg Rogers Open Space | 19497 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 3.302 | Greg Rogers OS | ||
108 | 108 | 107 | {"type": "Polygon", "coordinates": [[[-117.14184, 32.97106], [-117.14124, 32.97188], [-117.1408, 32.97192], [-117.14001, 32.97194], [-117.13999, 32.97192], [-117.1393, 32.97187], [-117.13918, 32.97191], [-117.13901, 32.97201], [-117.13894, 32.97203], [-117.13893, 32.97216], [-117.1386, 32.97217], [-117.13843, 32.97224], [-117.13783, 32.97225], [-117.1379, 32.97211], [-117.13789, 32.97209], [-117.13792, 32.97197], [-117.13791, 32.97195], [-117.13793, 32.97184], [-117.13792, 32.97181], [-117.13795, 32.9717], [-117.13793, 32.97167], [-117.13796, 32.97156], [-117.13794, 32.97154], [-117.13797, 32.97143], [-117.13795, 32.9714], [-117.13798, 32.97129], [-117.13796, 32.97126], [-117.13796, 32.97111], [-117.13876, 32.97111], [-117.13986, 32.97108], [-117.14184, 32.97106]]]} | Open Access 1 | Hampe Hills Open Space | 19630 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 8.407 | Hampe Hills OS | ||
110 | 110 | 109 | {"type": "Polygon", "coordinates": [[[-122.47017, 37.74701], [-122.46995, 37.74702], [-122.46993, 37.74705], [-122.46994, 37.74711], [-122.46989, 37.74716], [-122.46955, 37.74717], [-122.46952, 37.74707], [-122.46946, 37.74704], [-122.46939, 37.74704], [-122.46935, 37.74706], [-122.46933, 37.74712], [-122.46935, 37.74718], [-122.46892, 37.7472], [-122.46888, 37.74678], [-122.46845, 37.74672], [-122.46709, 37.74679], [-122.46707, 37.74656], [-122.46717, 37.74654], [-122.46717, 37.74647], [-122.46742, 37.74645], [-122.46742, 37.74641], [-122.46739, 37.74639], [-122.46739, 37.74612], [-122.46761, 37.74618], [-122.46795, 37.74616], [-122.46802, 37.74609], [-122.46892, 37.74615], [-122.46962, 37.74611], [-122.46966, 37.74667], [-122.47015, 37.74665], [-122.47017, 37.74701]]]} | Open Access 1 | Hawk Hill Open Space | 19745 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 4.845 | Hawk Hill OS | ||
111 | 111 | 110 | {"type": "Polygon", "coordinates": [[[-122.58498, 37.99403], [-122.58347, 37.99421], [-122.58359, 37.99479], [-122.58257, 37.99492], [-122.58243, 37.99485], [-122.58245, 37.99539], [-122.58253, 37.99559], [-122.58243, 37.99584], [-122.58223, 37.99573], [-122.58183, 37.99567], [-122.58149, 37.9957], [-122.5811, 37.99598], [-122.58105, 37.99603], [-122.58104, 37.99606], [-122.57991, 37.99606], [-122.57985, 37.99604], [-122.58041, 37.99563], [-122.57982, 37.99515], [-122.57962, 37.99507], [-122.5794, 37.99513], [-122.57896, 37.99513], [-122.57868, 37.99492], [-122.5784, 37.99489], [-122.57831, 37.99493], [-122.57828, 37.99496], [-122.57832, 37.99525], [-122.57826, 37.99552], [-122.57816, 37.99542], [-122.57817, 37.99525], [-122.57812, 37.99494], [-122.57814, 37.9949], [-122.57817, 37.99485], [-122.57812, 37.99479], [-122.57823, 37.9947], [-122.57835, 37.99468], [-122.57843, 37.99469], [-122.57864, 37.99473], [-122.57909, 37.99489], [-122.57924, 37.99453], [-122.57916, 37.99435], [-122.58012, 37.99433], [-122.58181, 37.99437], [-122.58222, 37.99416], [-122.5818, 37.99359], [-122.58167, 37.99314], [-122.58144, 37.99287], [-122.58138, 37.9926], [-122.58137, 37.99233], [-122.58123, 37.99212], [-122.58104, 37.99137], [-122.58111, 37.99137], [-122.58112, 37.99141], [-122.58119, 37.99145], [-122.58158, 37.99157], [-122.58164, 37.99162], [-122.58238, 37.99161], [-122.58266, 37.9915], [-122.58272, 37.99157], [-122.5831, 37.99146], [-122.5831, 37.99145], [-122.58303, 37.99126], [-122.58325, 37.99094], [-122.58312, 37.99086], [-122.58324, 37.99065], [-122.58297, 37.99059], [-122.58298, 37.99057], [-122.58347, 37.99064], [-122.58354, 37.99055], [-122.58498, 37.99403]]]} | Open Access 1 | Hawthorne Hills Town Open Space | 19751 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 32.982 | Hawthorne Hills Town OS | ||
112 | 112 | 111 | {"type": "Polygon", "coordinates": [[[-117.6908, 34.02102], [-117.69079, 34.02124], [-117.69076, 34.02128], [-117.69068, 34.02129], [-117.69063, 34.02129], [-117.69057, 34.02125], [-117.69057, 34.02103], [-117.69059, 34.02098], [-117.69063, 34.02096], [-117.6907, 34.02096], [-117.69078, 34.02099], [-117.6908, 34.02102]]]} | Open Access 1 | 7th Street Park | http://www.cityofchino.org/government-services/community-services/parks/7th-street-park | 15215 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 0.175 | 7th Street Park | |
123 | 123 | 122 | {"type": "Polygon", "coordinates": [[[-118.32341, 33.3435], [-118.32325, 33.34363], [-118.32307, 33.3435], [-118.32325, 33.34337], [-118.32341, 33.3435]]]} | Open Access 1 | Knabe Park | 31824 | 1016 | Avalon, City of 327 | City 2 | City Agency 2 | http://www.cityofavalon.com/ | City 2 | 0.114 | Knabe Park | ||
124 | 124 | 123 | {"type": "Polygon", "coordinates": [[[-117.10708, 32.66324], [-117.10647, 32.66342], [-117.10689, 32.66448], [-117.10651, 32.66459], [-117.10666, 32.665], [-117.10617, 32.66514], [-117.1063, 32.66549], [-117.10541, 32.66574], [-117.10527, 32.66536], [-117.10579, 32.66424], [-117.1063, 32.663], [-117.10681, 32.66258], [-117.10708, 32.66324]]]} | Open Access 1 | Paradise Creek Educational Park | http://www.nationalcityca.gov/government/community-services/facilities | 31842 | 1219 | National City, City of 49 | City 2 | City Agency 2 | http://www.ci.national-city.ca.us/index.aspx?page=152 | City 2 | 6.15 | Paradise Creek Educational 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]);