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 MNG_AG_LEV
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 464
- San Diego, City of 429
- San Jose, City of 253
- San Francisco, City and County of 239
- 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 60
- Manteca, City of 60
- Anaheim, City of 58
- …
ACCESS_TYP 4
- Open Access 9,632
- Restricted Access 354
- No Public Access 155
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,170 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
104 | 104 | 103 | {"type": "Polygon", "coordinates": [[[-122.40517, 37.62935], [-122.40481, 37.62939], [-122.40477, 37.62877], [-122.40516, 37.62875], [-122.40517, 37.62935]]]} | Open Access 1 | 7th Avenue Park | 15214 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 0.556 | 7th Avenue Park | 1940 | |
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 | |
130 | 130 | 129 | {"type": "Polygon", "coordinates": [[[-121.51824, 38.51159], [-121.5182, 38.51174], [-121.51816, 38.5118], [-121.51811, 38.51183], [-121.51787, 38.51178], [-121.51782, 38.5118], [-121.51776, 38.51185], [-121.51769, 38.51194], [-121.51766, 38.51207], [-121.51765, 38.51224], [-121.51778, 38.51238], [-121.51778, 38.51255], [-121.5176, 38.51306], [-121.51753, 38.51316], [-121.51741, 38.51329], [-121.51728, 38.51334], [-121.51711, 38.51334], [-121.5169, 38.51331], [-121.51659, 38.51334], [-121.51645, 38.5134], [-121.51629, 38.51343], [-121.51615, 38.51342], [-121.51608, 38.51339], [-121.51603, 38.51334], [-121.51599, 38.5133], [-121.5161, 38.51061], [-121.51603, 38.51034], [-121.51594, 38.50954], [-121.51557, 38.50957], [-121.51556, 38.5095], [-121.51595, 38.50944], [-121.516, 38.50921], [-121.51578, 38.50873], [-121.51597, 38.50872], [-121.51654, 38.50876], [-121.51675, 38.50876], [-121.51729, 38.50933], [-121.51746, 38.50944], [-121.51748, 38.50952], [-121.51763, 38.50978], [-121.51768, 38.5099], [-121.51778, 38.51001], [-121.51781, 38.51006], [-121.51779, 38.51016], [-121.51798, 38.51019], [-121.51806, 38.51027], [-121.51809, 38.51037], [-121.51809, 38.51047], [-121.51807, 38.51059], [-121.518, 38.51066], [-121.518, 38.51069], [-121.51803, 38.51074], [-121.51797, 38.51087], [-121.51804, 38.51104], [-121.51801, 38.51115], [-121.51805, 38.5113], [-121.51824, 38.51159]]]} | Open Access 1 | Joseph Reichmuth Park Open Space | 20499 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 18.876 | Joseph Reichmuth Park OS | ||
137 | 137 | 136 | {"type": "Polygon", "coordinates": [[[-118.01904, 34.11423], [-118.01863, 34.11424], [-118.0186, 34.11421], [-118.01858, 34.11368], [-118.01902, 34.11368], [-118.01904, 34.11423]]]} | Open Access 1 | Bicentennial Park | 16063 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 0.626 | Bicentennial Park | ||
146 | 146 | 145 | {"type": "MultiPolygon", "coordinates": [[[[-117.0469, 33.01993], [-117.04624, 33.01997], [-117.04608, 33.02002], [-117.04566, 33.0202], [-117.04544, 33.02023], [-117.04533, 33.02021], [-117.04531, 33.02017], [-117.04531, 33.01938], [-117.04538, 33.01905], [-117.0454, 33.01884], [-117.04545, 33.01881], [-117.04689, 33.01881], [-117.0469, 33.01993]]], [[[-117.04567, 33.02064], [-117.04531, 33.02064], [-117.04531, 33.02039], [-117.04566, 33.02036], [-117.04567, 33.02064]]]]} | Open Access 1 | Valle Verde Neighborhood Park | http://poway.org/Facilities/Facility/Details/Valle-Verde-Neighborhood-Park-68 | 31837 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 5.212 | Valle Verde Neighborhood Park | |
147 | 147 | 146 | {"type": "Polygon", "coordinates": [[[-117.06482, 34.0268], [-117.06482, 34.02935], [-117.06276, 34.02935], [-117.06275, 34.02844], [-117.06105, 34.02844], [-117.06104, 34.02824], [-117.06068, 34.02824], [-117.06068, 34.028], [-117.06226, 34.02701], [-117.06227, 34.02671], [-117.06276, 34.02671], [-117.06278, 34.02675], [-117.06478, 34.02675], [-117.06482, 34.0268]]]} | Open Access 1 | 7th Street Park | 15216 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 19.276 | 7th Street Park | ||
149 | 149 | 148 | {"type": "Polygon", "coordinates": [[[-122.17361, 37.75533], [-122.17331, 37.75544], [-122.17312, 37.7551], [-122.1734, 37.755], [-122.17361, 37.75533]]]} | Open Access 1 | 85th Avenue Mini Park | 15217 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.29 | 85th Avenue MP | ||
150 | 150 | 149 | {"type": "Polygon", "coordinates": [[[-122.17152, 37.75333], [-122.17114, 37.7535], [-122.17092, 37.75318], [-122.1713, 37.75301], [-122.17152, 37.75333]]]} | Open Access 1 | 88th Avenue Mini Park | 15218 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 0.384 | 88th Avenue MP | ||
151 | 151 | 150 | {"type": "Polygon", "coordinates": [[[-119.56145, 36.51108], [-119.56141, 36.51205], [-119.56054, 36.51205], [-119.56048, 36.51108], [-119.56145, 36.51108]]]} | Open Access 1 | Bicentennial Park | 16064 | 1153 | Kingsburg, City of 230 | City 2 | City Agency 2 | http://www.cityofkingsburg-ca.gov/ | City 2 | 2.199 | Bicentennial Park | ||
153 | 153 | 152 | {"type": "MultiPolygon", "coordinates": [[[[-121.88119, 38.02849], [-121.88109, 38.02875], [-121.87853, 38.02814], [-121.87863, 38.02788], [-121.88119, 38.02849]]], [[[-121.88244, 38.02879], [-121.88234, 38.02905], [-121.88126, 38.02879], [-121.88136, 38.02853], [-121.88244, 38.02879]]], [[[-121.88368, 38.02909], [-121.88358, 38.02935], [-121.88251, 38.0291], [-121.88261, 38.02883], [-121.88368, 38.02909]]], [[[-121.88579, 38.02974], [-121.88574, 38.02987], [-121.88458, 38.02959], [-121.88463, 38.02946], [-121.88579, 38.02974]]], [[[-121.88705, 38.03004], [-121.887, 38.03017], [-121.88591, 38.02991], [-121.88596, 38.02978], [-121.88705, 38.03004]]], [[[-121.88829, 38.03034], [-121.88824, 38.03047], [-121.88716, 38.03021], [-121.88721, 38.03007], [-121.88829, 38.03034]]], [[[-121.88953, 38.03064], [-121.88948, 38.03076], [-121.88841, 38.03051], [-121.88846, 38.03038], [-121.88953, 38.03064]]], [[[-121.8908, 38.03088], [-121.89075, 38.03101], [-121.88965, 38.0308], [-121.8897, 38.03067], [-121.8908, 38.03088]]]]} | Open Access 1 | 8th Street Greenbelt | 15219 | 1254 | Pittsburg, City of 380 | City 2 | City Agency 2 | http://www.ci.pittsburg.ca.us/index.aspx?page=238 | City 2 | 5.139 | 8th Street Greenbelt |
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]);