superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 464
- San Diego, City of 428
- San Jose, City of 253
- San Francisco, City and County of 237
- Sacramento, City of 216
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 124
- Oakland, City of 120
- 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 68
- Brentwood, City of 68
- Poway, City of 66
- 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 60
- Manteca, City of 60
- Anaheim, City of 58
- …
ACCESS_TYP 4
- Open Access 9,611
- Restricted Access 351
- No Public Access 155
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,146 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
169 | 169 | 168 | {"type": "MultiPolygon", "coordinates": [[[[-118.41144, 34.06052], [-118.41139, 34.0606], [-118.41084, 34.06086], [-118.41086, 34.06092], [-118.41072, 34.06099], [-118.41068, 34.06094], [-118.40952, 34.06146], [-118.40927, 34.06126], [-118.40916, 34.06114], [-118.40908, 34.061], [-118.40903, 34.06085], [-118.40902, 34.0607], [-118.40902, 34.06015], [-118.40961, 34.05987], [-118.40985, 34.05982], [-118.40998, 34.05983], [-118.41003, 34.05986], [-118.4101, 34.05989], [-118.41017, 34.05998], [-118.41025, 34.05995], [-118.4103, 34.06002], [-118.41097, 34.05971], [-118.4114, 34.06031], [-118.41144, 34.06044], [-118.41144, 34.06052]]], [[[-118.41243, 34.06254], [-118.41206, 34.06271], [-118.41213, 34.06284], [-118.41212, 34.06285], [-118.41172, 34.06272], [-118.41123, 34.06236], [-118.411, 34.06223], [-118.41066, 34.0618], [-118.41142, 34.06141], [-118.41159, 34.06162], [-118.41191, 34.06147], [-118.41231, 34.06203], [-118.41218, 34.06212], [-118.41226, 34.06224], [-118.41224, 34.06227], [-118.41243, 34.06254]]]]} | Restricted Access 2 | Beverly Hills High School Park | 31849 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 10.454 | Beverly Hills High School Park | ||
170 | 170 | 169 | {"type": "Polygon", "coordinates": [[[-120.94402, 37.72135], [-120.94378, 37.72263], [-120.94364, 37.72261], [-120.94344, 37.72254], [-120.94332, 37.72247], [-120.94323, 37.72238], [-120.94295, 37.72195], [-120.94286, 37.72178], [-120.94273, 37.72141], [-120.9432, 37.72103], [-120.94338, 37.72114], [-120.94358, 37.72124], [-120.94379, 37.72131], [-120.94402, 37.72135]]]} | Open Access 1 | Rotary Centennial Park | http://www.riverbank.org/facilities/facility/details/Rotary-Centennial-Park-11 | 31850 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 3.1 | Rotary Centennial Park | |
172 | 172 | 171 | {"type": "Polygon", "coordinates": [[[-120.93452, 37.7213], [-120.93422, 37.72138], [-120.93289, 37.71818], [-120.9332, 37.71818], [-120.93363, 37.71921], [-120.93373, 37.71935], [-120.93401, 37.71963], [-120.93418, 37.71988], [-120.93426, 37.72006], [-120.9343, 37.72025], [-120.93431, 37.72044], [-120.93429, 37.7207], [-120.93432, 37.72086], [-120.9344, 37.72107], [-120.93439, 37.72119], [-120.93444, 37.72127], [-120.93452, 37.7213]]]} | Open Access 1 | Harless Park | https://www.riverbank.org/Facilities/Facility/Details/Harless-Park-14 | 31851 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 3.007 | Harless Park | |
173 | 173 | 172 | {"type": "Polygon", "coordinates": [[[-120.93957, 37.73594], [-120.93907, 37.73593], [-120.93908, 37.73512], [-120.9392, 37.73504], [-120.93957, 37.73594]]]} | Open Access 1 | Staley Park | http://www.riverbank.org/facilities/facility/details/Staley-Park-Skate-Park-7 | 31853 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 0.662 | Staley Park | |
174 | 174 | 173 | {"type": "Polygon", "coordinates": [[[-120.93555, 37.73614], [-120.93555, 37.73649], [-120.93528, 37.73649], [-120.93528, 37.73614], [-120.93555, 37.73614]]]} | Open Access 1 | Plaza del Rio | https://www.riverbank.org/Facilities/Facility/Details/Plaza-Del-Rio-16 | 31855 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 0.223 | Plaza del Rio | |
175 | 175 | 174 | {"type": "MultiPolygon", "coordinates": [[[[-121.12574, 36.20479], [-121.12572, 36.2048], [-121.12555, 36.20471], [-121.12534, 36.20465], [-121.12512, 36.20465], [-121.12496, 36.20469], [-121.12271, 36.20586], [-121.12271, 36.20588], [-121.12331, 36.20664], [-121.1226, 36.20702], [-121.12158, 36.20725], [-121.12096, 36.2065], [-121.11972, 36.20706], [-121.11881, 36.20599], [-121.11886, 36.20594], [-121.11821, 36.205], [-121.11858, 36.20483], [-121.11869, 36.20432], [-121.11985, 36.20344], [-121.12047, 36.20329], [-121.12069, 36.20336], [-121.12112, 36.20368], [-121.12174, 36.20387], [-121.12159, 36.20398], [-121.12159, 36.204], [-121.12179, 36.20394], [-121.12301, 36.20385], [-121.12318, 36.20369], [-121.12353, 36.20281], [-121.12473, 36.20293], [-121.125, 36.20297], [-121.12471, 36.2037], [-121.1249, 36.20371], [-121.12574, 36.20479]]], [[[-121.12664, 36.20208], [-121.12626, 36.20229], [-121.12648, 36.20249], [-121.12617, 36.20244], [-121.12532, 36.20239], [-121.12362, 36.20222], [-121.12415, 36.201], [-121.12359, 36.20061], [-121.12434, 36.19963], [-121.12494, 36.19982], [-121.12496, 36.20087], [-121.12489, 36.20119], [-121.12487, 36.20141], [-121.12589, 36.20169], [-121.12664, 36.20208]]]]} | Restricted Access 2 | King City Golf Course | 33052 | 1152 | King City, City of 473 | City 2 | City Agency 2 | http://www.kingcity.com/ | City 2 | 53.754 | King City GC | ||
176 | 176 | 175 | {"type": "Polygon", "coordinates": [[[-118.38166, 33.88367], [-118.38133, 33.88367], [-118.38133, 33.88325], [-118.38166, 33.88326], [-118.38166, 33.88367]]]} | Open Access 1 | 8th Street Parkette | 15220 | 1194 | Manhattan Beach, City of 486 | City 2 | City Agency 2 | http://www.ci.manhattan-beach.ca.us/city-services/parks-and-recreation | City 2 | 0.347 | 8th Street Parkette | ||
181 | 181 | 180 | {"type": "Polygon", "coordinates": [[[-122.28084, 38.26895], [-122.2782, 38.26902], [-122.27677, 38.2671], [-122.27631, 38.26737], [-122.27697, 38.26817], [-122.27675, 38.26949], [-122.27213, 38.27026], [-122.2719, 38.2693], [-122.27173, 38.26867], [-122.27151, 38.26765], [-122.27138, 38.26693], [-122.27119, 38.26559], [-122.27113, 38.26497], [-122.27106, 38.26416], [-122.27105, 38.26351], [-122.27168, 38.26331], [-122.27332, 38.2629], [-122.27458, 38.26299], [-122.2765, 38.26337], [-122.27675, 38.2632], [-122.27694, 38.26317], [-122.27776, 38.26348], [-122.27804, 38.26326], [-122.27815, 38.26282], [-122.27845, 38.26244], [-122.27855, 38.26202], [-122.2785, 38.26124], [-122.2787, 38.26096], [-122.27943, 38.26047], [-122.28056, 38.25989], [-122.28082, 38.2597], [-122.28084, 38.26895]]]} | Restricted Access 2 | Napa Golf Course | https://www.playnapa.com/ | 33054 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 156.018 | Napa GC | 1958 |
182 | 182 | 181 | {"type": "Polygon", "coordinates": [[[-117.64137, 34.0943], [-117.64005, 34.09426], [-117.63908, 34.09417], [-117.63907, 34.09258], [-117.64136, 34.09258], [-117.64137, 34.0943]]]} | Open Access 1 | 8th Street Reservoir Park | 15221 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 9.707 | 8th Street Reservoir Park | ||
183 | 183 | 182 | {"type": "Polygon", "coordinates": [[[-119.25659, 34.24231], [-119.25428, 34.2423], [-119.25451, 34.244], [-119.25412, 34.24391], [-119.25352, 34.24372], [-119.2535, 34.2436], [-119.25333, 34.24354], [-119.25321, 34.24362], [-119.25217, 34.24328], [-119.25168, 34.24317], [-119.25117, 34.24308], [-119.25049, 34.24303], [-119.2489, 34.24299], [-119.24828, 34.24302], [-119.24768, 34.2431], [-119.24766, 34.24276], [-119.24749, 34.24276], [-119.24709, 34.24323], [-119.24437, 34.24382], [-119.2436, 34.24393], [-119.24348, 34.24318], [-119.24343, 34.24302], [-119.24322, 34.24276], [-119.24288, 34.24238], [-119.2422, 34.24282], [-119.24183, 34.24303], [-119.24184, 34.24356], [-119.24141, 34.24358], [-119.24116, 34.24321], [-119.24087, 34.23673], [-119.24288, 34.23684], [-119.25623, 34.23634], [-119.25629, 34.23783], [-119.25642, 34.23784], [-119.25659, 34.24231]]]} | Restricted Access 2 | Olivas Links Golf Course | 33063 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 254.625 | Olivas Links GC | ||
184 | 184 | 183 | {"type": "Polygon", "coordinates": [[[-118.85085, 34.17275], [-118.85034, 34.17243], [-118.85035, 34.17371], [-118.84986, 34.17314], [-118.8485, 34.17253], [-118.84808, 34.17243], [-118.84737, 34.17184], [-118.84851, 34.17114], [-118.84891, 34.17015], [-118.84913, 34.17013], [-118.84951, 34.17015], [-118.84951, 34.17031], [-118.84949, 34.17062], [-118.84994, 34.17065], [-118.85, 34.1709], [-118.85082, 34.17101], [-118.85085, 34.17275]]]} | Open Access 1 | Conejo Ridge Open Space | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Conejo Ridge | 30798 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 15.623 | Conejo Ridge OS | |
188 | 188 | 187 | {"type": "Polygon", "coordinates": [[[-121.01091, 37.61013], [-121.01091, 37.61163], [-121.01087, 37.61165], [-121.01029, 37.61166], [-121.01028, 37.61259], [-121.00951, 37.6126], [-121.0095, 37.61333], [-121.00713, 37.61333], [-121.00712, 37.6133], [-121.0069, 37.6132], [-121.00574, 37.61394], [-121.00469, 37.61511], [-121.00313, 37.61607], [-121.00289, 37.61661], [-121.00346, 37.61667], [-121.00337, 37.61699], [-121.00483, 37.617], [-121.00483, 37.61781], [-121.00413, 37.61781], [-121.00412, 37.61791], [-121.00265, 37.61791], [-121.00265, 37.61769], [-121.00263, 37.61768], [-121.00076, 37.62018], [-121.00023, 37.62069], [-120.99954, 37.62116], [-120.99932, 37.62134], [-120.99844, 37.62135], [-120.99856, 37.61961], [-120.99866, 37.61853], [-120.99872, 37.61772], [-120.9986, 37.61696], [-120.99845, 37.61648], [-120.99809, 37.61568], [-120.99824, 37.61515], [-121.00054, 37.61294], [-121.0023, 37.61183], [-121.00496, 37.61077], [-121.00724, 37.61022], [-121.00952, 37.60948], [-121.00953, 37.60976], [-121.00959, 37.60976], [-121.01091, 37.61013]]]} | Restricted Access 2 | Dryden Park Golf Course | 33067 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 145.269 | Dryden Park GC | ||
190 | 190 | 189 | {"type": "Polygon", "coordinates": [[[-122.76777, 38.44155], [-122.76294, 38.44149], [-122.76245, 38.44143], [-122.75839, 38.44082], [-122.75793, 38.44072], [-122.75784, 38.43796], [-122.75939, 38.43796], [-122.75992, 38.4382], [-122.76024, 38.43812], [-122.76023, 38.43774], [-122.7607, 38.43792], [-122.76121, 38.43805], [-122.76187, 38.43812], [-122.76776, 38.43816], [-122.76777, 38.44155]]]} | Open Access 1 | A Place to Play Park | 15224 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 76.452 | A Place to Play Park | ||
191 | 191 | 190 | {"type": "Polygon", "coordinates": [[[-117.00327, 32.84388], [-117.0032, 32.84396], [-117.00231, 32.84396], [-117.00229, 32.84395], [-117.00137, 32.84412], [-117.00137, 32.8442], [-117.00036, 32.84439], [-117.00031, 32.84432], [-116.99874, 32.84482], [-116.99875, 32.8449], [-116.99829, 32.845], [-116.99814, 32.84466], [-116.99705, 32.84193], [-116.9988, 32.84171], [-116.99935, 32.84157], [-116.99968, 32.84165], [-117.00071, 32.84155], [-117.0017, 32.84133], [-117.00257, 32.84084], [-117.00262, 32.84057], [-117.0026, 32.8399], [-117.00308, 32.83962], [-117.00312, 32.83966], [-117.00312, 32.84055], [-117.00316, 32.84248], [-117.00327, 32.84388]]]} | Open Access 1 | Mast Park West | 31858 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 43.444 | Mast Park West | ||
199 | 199 | 198 | {"type": "MultiPolygon", "coordinates": [[[[-118.83129, 34.21425], [-118.83113, 34.21452], [-118.83089, 34.21501], [-118.83048, 34.21489], [-118.83051, 34.21474], [-118.83033, 34.21459], [-118.83011, 34.21451], [-118.82992, 34.21447], [-118.82974, 34.21447], [-118.82958, 34.21449], [-118.82924, 34.2146], [-118.82925, 34.21474], [-118.82934, 34.2149], [-118.82983, 34.21515], [-118.83005, 34.21528], [-118.83022, 34.21534], [-118.83019, 34.21564], [-118.82996, 34.21577], [-118.82996, 34.2157], [-118.82988, 34.21569], [-118.82975, 34.21554], [-118.82956, 34.21547], [-118.82931, 34.21539], [-118.8293, 34.21536], [-118.829, 34.21526], [-118.82894, 34.21535], [-118.8285, 34.21565], [-118.82839, 34.21579], [-118.82845, 34.21612], [-118.82858, 34.21644], [-118.82875, 34.21653], [-118.82859, 34.21668], [-118.82861, 34.21675], [-118.82853, 34.21695], [-118.8289, 34.21703], [-118.82887, 34.21715], [-118.82888, 34.21805], [-118.82876, 34.21837], [-118.82869, 34.21848], [-118.82854, 34.21862], [-118.82836, 34.21873], [-118.8283, 34.2188], [-118.82827, 34.21889], [-118.82829, 34.21897], [-118.82838, 34.21909], [-118.82792, 34.21919], [-118.82801, 34.21944], [-118.82813, 34.21964], [-118.82791, 34.21988], [-118.82779, 34.22003], [-118.82761, 34.22049], [-118.82733, 34.22093], [-118.82742, 34.22154], [-118.82795, 34.22169], [-118.82799, 34.22167], [-118.82812, 34.22166], [-118.82828, 34.22174], [-118.82844, 34.22173], [-118.8285, 34.2217], [-118.82847, 34.22122], [-118.82849, 34.22121], [-118.82845, 34.221], [-118.82851, 34.22098], [-118.8285, 34.22082], [-118.82855, 34.22079], [-118.82856, 34.22063], [-118.82863, 34.22059], [-118.82865, 34.22042], [-118.8288, 34.22039], [-118.8288, 34.22026], [-118.82896, 34.22029], [-118.82897, 34.22015], [-118.82919, 34.22009], [-118.82919, 34.22004], [-118.82942, 34.21995], [-118.82942, 34.21992], [-118.82964, 34.21981], [-118.82968, 34.21985], [-118.82991, 34.21976], [-118.83012, 34.21971], [-118.83035, 34.21969], [-118.83062, 34.2198], [-118.83051, 34.22001], [-118.83017, 34.2199], [-118.82998, 34.21997], [-118.82974, 34.22052], [-118.82957, 34.22077], [-118.82946, 34.22117], [-118.82953, 34.22152], [-118.83022, 34.22173], [-118.82989, 34.22221], [-118.83004, 34.22227], [-118.83008, 34.22308], [-118.82662, 34.22409], [-118.82653, 34.22395], [-118.82543, 34.2238], [-118.82543, 34.2237], [-118.82552, 34.22359], [-118.82563, 34.22357], [-118.82572, 34.22338], [-118.82631, 34.22324], [-118.82688, 34.22294], [-118.82725, 34.2219], [-118.82695, 34.22142], [-118.82614, 34.22119], [-118.82486, 34.22138], [-118.82364, 34.22196], [-118.82263, 34.22211], [-118.82219, 34.22251], [-118.82185, 34.22269], [-118.82148, 34.22258], [-118.82119, 34.22262], [-118.82089, 34.22267], [-118.82046, 34.22276], [-118.8196, 34.22302], [-118.81879, 34.22288], [-118.81848, 34.22301], [-118.81847, 34.22319], [-118.818, 34.22315], [-118.81791, 34.22303], [-118.81766, 34.22281], [-118.81681, 34.22246], [-118.81635, 34.22218], [-118.81629, 34.22211], [-118.81611, 34.22174], [-118.81582, 34.22132], [-118.81548, 34.22152], [-118.815, 34.22159], [-118.81505, 34.22201], [-118.81531, 34.2223], [-118.81569, 34.22253], [-118.81605, 34.22254], [-118.81715, 34.22278], [-118.81764, 34.22298], [-118.81783, 34.22321], [-118.818, 34.22347], [-118.81738, 34.22343], [-118.81677, 34.22356], [-118.81527, 34.22411], [-118.81526, 34.22397], [-118.81507, 34.22395], [-118.81486, 34.22292], [-118.81411, 34.22303], [-118.81428, 34.22401], [-118.81329, 34.22428], [-118.81317, 34.22439], [-118.81314, 34.22451], [-118.81316, 34.22463], [-118.81344, 34.22512], [-118.81377, 34.22541], [-118.81375, 34.22547], [-118.81382, 34.22556], [-118.81363, 34.22574], [-118.81375, 34.22615], [-118.81396, 34.22627], [-118.81423, 34.22632], [-118.81442, 34.22648], [-118.81499, 34.22649], [-118.81512, 34.22662], [-118.81531, 34.22665], [-118.81564, 34.22659], [-118.81777, 34.22609], [-118.81868, 34.22614], [-118.81921, 34.22599], [-118.81946, 34.22596], [-118.81952, 34.22607], [-118.8177, 34.22661], [-118.81736, 34.22651], [-118.81709, 34.22673], [-118.81678, 34.22674], [-118.81672, 34.22691], [-118.81607, 34.22709], [-118.81349, 34.22675], [-118.81313, 34.22547], [-118.812, 34.22511], [-118.81151, 34.22392], [-118.81045, 34.22448], [-118.80938, 34.22445], [-118.80885, 34.22462], [-118.80812, 34.22432], [-118.80733, 34.22336], [-118.80625, 34.2242], [-118.80479, 34.22333], [-118.80433, 34.22361], [-118.80257, 34.22254], [-118.80178, 34.22244], [-118.80045, 34.22301], [-118.79994, 34.22253], [-118.79886, 34.22263], [-118.79854, 34.22203], [-118.79264, 34.21029], [-118.7958, 34.21037], [-118.79647, 34.21011], [-118.7991, 34.21043], [-118.79927, 34.21205], [-118.7999, 34.21164], [-118.80046, 34.21158], [-118.80075, 34.21041], [-118.80566, 34.21057], [-118.80688, 34.21187], [-118.80927, 34.21239], [-118.80914, 34.21273], [-118.80914, 34.2128], [-118.80894, 34.21317], [-118.80881, 34.21354], [-118.80878, 34.21374], [-118.80865, 34.21394], [-118.80861, 34.21471], [-118.80853, 34.21512], [-118.81002, 34.21543], [-118.80995, 34.21569], [-118.81049, 34.21595], [-118.80994, 34.21608], [-118.80992, 34.21696], [-118.8105, 34.21707], [-118.81082, 34.21682], [-118.81118, 34.21702], [-118.81141, 34.2171], [-118.81238, 34.21724], [-118.81296, 34.21725], [-118.81316, 34.2173], [-118.81377, 34.21729], [-118.81395, 34.21732], [-118.81509, 34.21737], [-118.81532, 34.21731], [-118.81542, 34.21708], [-118.81555, 34.21706], [-118.81578, 34.21683], [-118.81589, 34.21669], [-118.81594, 34.21656], [-118.81616, 34.21637], [-118.81675, 34.21594], [-118.81686, 34.21546], [-118.81715, 34.21504], [-118.81724, 34.21483], [-118.81757, 34.2146], [-118.81764, 34.21458], [-118.81775, 34.21446], [-118.81781, 34.21433], [-118.8178, 34.21423], [-118.81772, 34.21408], [-118.81762, 34.214], [-118.81739, 34.2136], [-118.81649, 34.21343], [-118.81623, 34.21317], [-118.81601, 34.21312], [-118.81577, 34.21312], [-118.81586, 34.21265], [-118.81637, 34.21305], [-118.81664, 34.21319], [-118.81725, 34.21323], [-118.81818, 34.21344], [-118.81916, 34.21315], [-118.82024, 34.21277], [-118.82064, 34.2127], [-118.82091, 34.21283], [-118.82178, 34.21232], [-118.82319, 34.21197], [-118.82314, 34.21229], [-118.82238, 34.21251], [-118.82197, 34.21248], [-118.82152, 34.21265], [-118.82111, 34.21292], [-118.82084, 34.21302], [-118.82038, 34.21296], [-118.81972, 34.21312], [-118.8188, 34.21356], [-118.81815, 34.21362], [-118.81779, 34.21384], [-118.81801, 34.21422], [-118.81788, 34.21452], [-118.81745, 34.21493], [-118.81706, 34.2155], [-118.81698, 34.2159], [-118.81642, 34.21644], [-118.816, 34.21681], [-118.81594, 34.21703], [-118.81553, 34.21757], [-118.81556, 34.2178], [-118.81522, 34.21823], [-118.81542, 34.21882], [-118.81554, 34.21953], [-118.81529, 34.21956], [-118.81545, 34.22098], [-118.8228, 34.22024], [-118.82587, 34.22112], [-118.82588, 34.21944], [-118.82634, 34.21839], [-118.82736, 34.21551], [-118.82768, 34.21453], [-118.82778, 34.21367], [-118.82865, 34.21324], [-118.82871, 34.21343], [-118.82938, 34.21355], [-118.82983, 34.21358], [-118.82985, 34.21348], [-118.83, 34.21344], [-118.83029, 34.21347], [-118.83053, 34.21351], [-118.83085, 34.2136], [-118.83077, 34.2138], [-118.83095, 34.2139], [-118.83113, 34.21402], [-118.83119, 34.21422], [-118.83129, 34.21425]]], [[[-118.82174, 34.22562], [-118.82132, 34.22553], [-118.8209, 34.22566], [-118.82082, 34.22515], [-118.82083, 34.22495], [-118.82098, 34.22456], [-118.82156, 34.22446], [-118.82168, 34.22479], [-118.82174, 34.22562]]], [[[-118.8302, 34.22816], [-118.82606, 34.22664], [-118.82282, 34.22588], [-118.82471, 34.22598], [-118.82513, 34.22571], [-118.82521, 34.22478], [-118.82553, 34.22458], [-118.8264, 34.22436], [-118.8277, 34.22484], [-118.8286, 34.22469], [-118.82912, 34.22502], [-118.82969, 34.22479], [-118.83012, 34.22478], [-118.8302, 34.22816]]], [[[-118.83037, 34.21814], [-118.83035, 34.2183], [-118.83026, 34.21841], [-118.83016, 34.2185], [-118.82997, 34.21877], [-118.82987, 34.21886], [-118.82983, 34.21893], [-118.82953, 34.219], [-118.8297, 34.2193], [-118.82918, 34.21949], [-118.82907, 34.21925], [-118.82901, 34.21923], [-118.82908, 34.21886], [-118.82926, 34.21853], [-118.8293, 34.21853], [-118.82933, 34.21832], [-118.8294, 34.21832], [-118.82946, 34.21811], [-118.82954, 34.21808], [-118.82956, 34.21784], [-118.82944, 34.21764], [-118.82957, 34.21763], [-118.82942, 34.21743], [-118.82955, 34.21734], [-118.82955, 34.21732], [-118.82933, 34.21712], [-118.82905, 34.21708], [-118.82912, 34.21688], [-118.82922, 34.21671], [-118.82933, 34.21659], [-118.82955, 34.21681], [-118.82982, 34.21716], [-118.8301, 34.21712], [-118.83019, 34.21725], [-118.83015, 34.21735], [-118.83033, 34.21757], [-118.83028, 34.21779], [-118.83025, 34.21804], [-118.83037, 34.21814]]], [[[-118.83237, 34.21819], [-118.83191, 34.21872], [-118.83157, 34.21885], [-118.83127, 34.21911], [-118.83111, 34.21938], [-118.83086, 34.21928], [-118.83103, 34.21899], [-118.83148, 34.21854], [-118.83177, 34.21838], [-118.8319, 34.21817], [-118.83199, 34.21796], [-118.83221, 34.21802], [-118.83237, 34.21819]]], [[[-118.83555, 34.21195], [-118.83557, 34.21201], [-118.83557, 34.21224], [-118.83549, 34.21325], [-118.83541, 34.21367], [-118.83528, 34.21413], [-118.83525, 34.21435], [-118.83527, 34.21471], [-118.83497, 34.21472], [-118.83492, 34.21485], [-118.83476, 34.21509], [-118.83426, 34.21561], [-118.83397, 34.21579], [-118.83373, 34.21576], [-118.83354, 34.21593], [-118.83342, 34.21606], [-118.83334, 34.21607], [-118.83323, 34.21617], [-118.83297, 34.21634], [-118.833, 34.21644], [-118.83296, 34.21649], [-118.83272, 34.21652], [-118.83271, 34.21655], [-118.83246, 34.21652], [-118.83239, 34.2166], [-118.83229, 34.21659], [-118.83228, 34.21626], [-118.83219, 34.2162], [-118.83233, 34.21606], [-118.83232, 34.21599], [-118.83244, 34.21587], [-118.83269, 34.21541], [-118.83259, 34.21524], [-118.83235, 34.21503], [-118.8321, 34.21496], [-118.83176, 34.21495], [-118.83169, 34.21528], [-118.83168, 34.21557], [-118.83165, 34.2156], [-118.83158, 34.21577], [-118.83154, 34.21577], [-118.83149, 34.21572], [-118.83125, 34.21574], [-118.83124, 34.21564], [-118.83119, 34.21562], [-118.83129, 34.21518], [-118.83104, 34.21511], [-118.83117, 34.2148], [-118.83142, 34.21434], [-118.83161, 34.21442], [-118.83174, 34.21433], [-118.83205, 34.21423], [-118.8323, 34.21418], [-118.83278, 34.21413], [-118.83293, 34.21405], [-118.83303, 34.2139], [-118.83304, 34.21344], [-118.83315, 34.21308], [-118.83325, 34.21294], [-118.83395, 34.2124], [-118.83404, 34.21229], [-118.83399, 34.21209], [-118.83522, 34.21192], [-118.83546, 34.21192], [-118.83555, 34.21195]]], [[[-118.83794, 34.22443], [-118.8363, 34.22397], [-118.83646, 34.22355], [-118.83678, 34.22368], [-118.83724, 34.22392], [-118.83762, 34.22416], [-118.83794, 34.22443]]], [[[-118.8407, 34.22166], [-118.84057, 34.222], [-118.84031, 34.22223], [-118.83998, 34.22227], [-118.83996, 34.22199], [-118.84001, 34.22197], [-118.84007, 34.22192], [-118.84008, 34.22187], [-118.84007, 34.22181], [-118.8401, 34.22178], [-118.84003, 34.22148], [-118.83962, 34.2215], [-118.83918, 34.22144], [-118.8387, 34.22144], [-118.83808, 34.22161], [-118.83716, 34.22175], [-118.83681, 34.22201], [-118.8371, 34.22146], [-118.83704, 34.22113], [-118.83759, 34.22106], [-118.83756, 34.22092], [-118.83762, 34.22093], [-118.83768, 34.22091], [-118.83774, 34.22105], [-118.83832, 34.22097], [-118.8385, 34.22085], [-118.83899, 34.22083], [-118.83955, 34.22057], [-118.84004, 34.22077], [-118.84041, 34.22109], [-118.8406, 34.22134], [-118.8407, 34.22166]]], [[[-118.84097, 34.21797], [-118.8407, 34.21852], [-118.84062, 34.21872], [-118.84059, 34.21891], [-118.84031, 34.21896], [-118.84019, 34.21887], [-118.83967, 34.21867], [-118.83936, 34.21859], [-118.83926, 34.21882], [-118.83921, 34.21878], [-118.83918, 34.21877], [-118.83924, 34.21857], [-118.83896, 34.21833], [-118.83847, 34.21824], [-118.83819, 34.21815], [-118.83772, 34.21749], [-118.83852, 34.21722], [-118.83874, 34.21706], [-118.83914, 34.21718], [-118.83936, 34.21732], [-118.83952, 34.21748], [-118.83961, 34.21775], [-118.84097, 34.21797]]], [[[-118.84052, 34.22507], [-118.84037, 34.22537], [-118.8395, 34.22504], [-118.83905, 34.22483], [-118.83845, 34.2245], [-118.83794, 34.22417], [-118.83816, 34.22397], [-118.83803, 34.2236], [-118.83849, 34.22361], [-118.83858, 34.22388], [-118.83876, 34.22395], [-118.83907, 34.22386], [-118.83929, 34.22424], [-118.83944, 34.22441], [-118.83958, 34.22454], [-118.83974, 34.22467], [-118.84002, 34.22484], [-118.84042, 34.22504], [-118.84052, 34.22507]]], [[[-118.84085, 34.22439], [-118.84066, 34.22466], [-118.84055, 34.22462], [-118.84035, 34.22452], [-118.84004, 34.22433], [-118.83989, 34.22423], [-118.83978, 34.22412], [-118.83947, 34.22423], [-118.83933, 34.22404], [-118.83961, 34.22384], [-118.83982, 34.22382], [-118.83988, 34.22389], [-118.83996, 34.22391], [-118.83995, 34.22403], [-118.84025, 34.22418], [-118.84061, 34.22412], [-118.84085, 34.22439]]]]} | Open Access 1 | Lang Ranch Open Space | http://www.conejo-openspace.org/open_space_areas_in_TO.htm#Lang Ranch | 30802 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 746.442 | Lang Ranch OS | |
201 | 201 | 200 | {"type": "Polygon", "coordinates": [[[-117.79029, 34.00176], [-117.79027, 34.00206], [-117.79028, 34.00231], [-117.79016, 34.00236], [-117.78948, 34.00182], [-117.78963, 34.00169], [-117.78979, 34.0015], [-117.79029, 34.00176]]]} | Open Access 1 | Longview Park North | 31869 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 0.991 | Longview Park North | ||
209 | 209 | 208 | {"type": "Polygon", "coordinates": [[[-121.89428, 37.23794], [-121.89425, 37.23798], [-121.89372, 37.23825], [-121.89364, 37.23832], [-121.89355, 37.23842], [-121.89352, 37.23843], [-121.89349, 37.23841], [-121.89266, 37.23738], [-121.8926, 37.23734], [-121.89286, 37.2372], [-121.8927, 37.23699], [-121.89264, 37.23682], [-121.89285, 37.23678], [-121.89293, 37.23697], [-121.89334, 37.23689], [-121.89324, 37.23638], [-121.89339, 37.23647], [-121.89347, 37.23656], [-121.89357, 37.23685], [-121.89349, 37.23689], [-121.89352, 37.23696], [-121.89427, 37.23791], [-121.89428, 37.23794]]]} | Open Access 1 | Almaden Winery Park | 15391 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.616 | Almaden Winery Park | 1998 | |
214 | 214 | 213 | {"type": "Polygon", "coordinates": [[[-121.87788, 37.68315], [-121.87643, 37.68352], [-121.87618, 37.68275], [-121.87762, 37.68246], [-121.87788, 37.68315]]]} | Open Access 1 | Bicentennial Park | 16065 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 2.746 | Bicentennial Park | ||
215 | 215 | 214 | {"type": "Polygon", "coordinates": [[[-118.17442, 34.11313], [-118.17382, 34.11314], [-118.17249, 34.1138], [-118.1717, 34.11481], [-118.17141, 34.1152], [-118.17123, 34.11541], [-118.17063, 34.11525], [-118.17023, 34.11568], [-118.1699, 34.11588], [-118.16957, 34.11604], [-118.1687, 34.11633], [-118.1684, 34.11659], [-118.16778, 34.11722], [-118.16752, 34.1172], [-118.16721, 34.11716], [-118.16702, 34.11722], [-118.16668, 34.1172], [-118.16617, 34.11698], [-118.1663, 34.1167], [-118.16644, 34.11652], [-118.16714, 34.1158], [-118.16736, 34.11565], [-118.16786, 34.11535], [-118.16903, 34.11436], [-118.17094, 34.11312], [-118.17138, 34.11306], [-118.1719, 34.11287], [-118.17256, 34.11271], [-118.17296, 34.1125], [-118.17362, 34.11232], [-118.17402, 34.11239], [-118.17442, 34.11313]]]} | Restricted Access 2 | Arroyo Seco Golf Course | http://www.arroyosecogolf.com/Home.html | 29411 | 1340 | South Pasadena, City of 306 | City 2 | City Agency 2 | http://www.ci.south-pasadena.ca.us/ | City 2 | 31.165 | Arroyo Seco GC | |
224 | 224 | 223 | {"type": "Polygon", "coordinates": [[[-117.84833, 33.96677], [-117.84766, 33.96715], [-117.84745, 33.96733], [-117.84713, 33.96767], [-117.84702, 33.96771], [-117.84699, 33.96774], [-117.8468, 33.96774], [-117.84679, 33.96772], [-117.84666, 33.96772], [-117.84618, 33.96778], [-117.84613, 33.96766], [-117.84619, 33.96762], [-117.8462, 33.96756], [-117.84623, 33.96755], [-117.84629, 33.96747], [-117.84634, 33.96745], [-117.84671, 33.96683], [-117.84686, 33.96663], [-117.84697, 33.96655], [-117.84715, 33.9665], [-117.84727, 33.96651], [-117.84729, 33.96648], [-117.84718, 33.96644], [-117.84698, 33.96642], [-117.84674, 33.96634], [-117.84666, 33.96633], [-117.84658, 33.96626], [-117.84649, 33.96622], [-117.84643, 33.96629], [-117.84616, 33.9662], [-117.8459, 33.96634], [-117.84585, 33.96623], [-117.8458, 33.96617], [-117.84555, 33.96607], [-117.8453, 33.96591], [-117.84508, 33.96583], [-117.84502, 33.96576], [-117.84498, 33.96566], [-117.84502, 33.9657], [-117.84507, 33.96572], [-117.84518, 33.96571], [-117.8469, 33.96621], [-117.84705, 33.96627], [-117.84763, 33.96656], [-117.8478, 33.96635], [-117.84796, 33.96641], [-117.84817, 33.96659], [-117.84814, 33.96665], [-117.84815, 33.96671], [-117.84818, 33.96673], [-117.84825, 33.96675], [-117.84831, 33.96674], [-117.84833, 33.96677]]]} | Open Access 1 | Diamond Canyon Park | 31870 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 4.991 | Diamond Canyon Park | 2016 |
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]);