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)
These facets timed out: MNG_AGENCY
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
156 | 156 | 155 | {"type": "Polygon", "coordinates": [[[-117.08492, 32.67018], [-117.08441, 32.67041], [-117.08447, 32.67064], [-117.08269, 32.67114], [-117.08246, 32.67052], [-117.08213, 32.66991], [-117.08195, 32.66942], [-117.08191, 32.66941], [-117.08161, 32.66862], [-117.08164, 32.6686], [-117.08155, 32.66834], [-117.08336, 32.66784], [-117.08337, 32.66783], [-117.08329, 32.66763], [-117.08372, 32.6675], [-117.08384, 32.66761], [-117.08404, 32.66769], [-117.08422, 32.66784], [-117.08443, 32.66849], [-117.08427, 32.66906], [-117.08482, 32.66984], [-117.08489, 32.67002], [-117.08492, 32.67018]]]} | Open Access 1 | Las Palmas Park | http://www.nationalcityca.gov/government/community-services/facilities | 31839 | 1219 | National City, City of 49 | City 2 | City Agency 2 | http://www.ci.national-city.ca.us/index.aspx?page=152 | City 2 | 19.248 | Las Palmas Park | |
165 | 165 | 164 | {"type": "Polygon", "coordinates": [[[-120.93077, 37.73589], [-120.92905, 37.73587], [-120.92904, 37.73514], [-120.93077, 37.73514], [-120.93077, 37.73589]]]} | Open Access 1 | Community Center Park | https://www.riverbank.org/Facilities/Facility/Details/Community-Center-Veterans-Park-9 | 31854 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 3.096 | Community Ctr. Park | |
166 | 166 | 165 | {"type": "Polygon", "coordinates": [[[-118.03633, 34.13066], [-118.03547, 34.13067], [-118.03546, 34.13071], [-118.03229, 34.13073], [-118.03226, 34.12947], [-118.03497, 34.12908], [-118.03499, 34.12944], [-118.03598, 34.12943], [-118.03599, 34.1298], [-118.0363, 34.12981], [-118.03633, 34.13066]]]} | Restricted Access 2 | Arcadia High School Park | http://ahs.ausd.net/ | 31846 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 13.82 | Arcadia High School Park | |
167 | 167 | 166 | {"type": "Polygon", "coordinates": [[[-118.04812, 34.11743], [-118.0462, 34.11746], [-118.04618, 34.11714], [-118.04576, 34.11714], [-118.04575, 34.11667], [-118.04763, 34.11665], [-118.04764, 34.11711], [-118.04812, 34.11711], [-118.04812, 34.11743]]]} | Restricted Access 2 | Baldwin Stocker Elementary School Park | http://bs.ausd.net/ | 31847 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 3.8 | Baldwin Stocker Elementary School Park | |
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 | ||
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 |
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]);