superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13,512 rows where ACCESS_TYP = 1
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 338
- Los Angeles, City of 316
- California Department of Fish and Wildlife 203
- San Jose, City of 146
- San Francisco, City and County of 143
- California Department of Parks and Recreation 139
- Sacramento, City of 137
- Ventura, City of 136
- Long Beach, City of 108
- Los Angeles, County of 107
- Mountains Recreation and Conservation Authority 102
- Roseville, City of 89
- San Diego, County of 81
- Irvine, City of 75
- Fresno, City of 71
- Oakland, City of 65
- Consumnes Community Services District 64
- Poway, City of 57
- Orange, County of 55
- Santa Barbara, County of 54
- Santa Cruz, City of 51
- Lake, County of 51
- Davis, City of 50
- Los Angeles - Department of Parks and Recreation, County of 49
- Clovis, City of 48
- East Bay Regional Park District 47
- Chula Vista, City of 47
- Huntington Beach, City of 47
- Stockton, City of 47
- Hayward Area Recreation and Park District 45
- …
MNG_AG_TYP 28
- City Agency 6,453
- County Agency 660
- Recreation/Parks District 597
- State Agency 409
- County Agency - Parks 137
- Open Space District 131
- Community Services District 123
- Non Profit - Land Trust 122
- Federal Agency 97
- Water District 66
- Non Profit - Conservation 38
- Cemetery District 36
- Flood District 28
- Non Profit - Other 25
- Port/Harbor District 21
- County Agency - Other 14
- Irrigation District 6
- Special District - Other 6
- Sanitation District 5
- Non Profit - Cemetery District 4
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Utility 1
- Transportation Agency 1
ACCESS_TYP 1
- Open Access · 8,990 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5057 | 5057 | 5056 | {"type": "Polygon", "coordinates": [[[-117.57751, 33.84415], [-117.57745, 33.84458], [-117.57741, 33.84466], [-117.57731, 33.84478], [-117.57728, 33.84484], [-117.57731, 33.84492], [-117.57738, 33.84498], [-117.57734, 33.8453], [-117.57585, 33.84516], [-117.57613, 33.84334], [-117.57618, 33.84334], [-117.57617, 33.84345], [-117.57612, 33.84363], [-117.57612, 33.84368], [-117.57618, 33.84378], [-117.57626, 33.84383], [-117.57623, 33.84413], [-117.57666, 33.84413], [-117.5769, 33.8441], [-117.57751, 33.84415]]]} | Open Access 1 | Heritage Park | 19846 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 4.404 | Heritage Park | ||
5058 | 5058 | 5057 | {"type": "Polygon", "coordinates": [[[-117.69807, 33.46235], [-117.69807, 33.46339], [-117.69794, 33.46342], [-117.69795, 33.46533], [-117.69789, 33.46539], [-117.6979, 33.46445], [-117.69788, 33.4643], [-117.69782, 33.46425], [-117.69786, 33.46418], [-117.69785, 33.46412], [-117.69791, 33.46409], [-117.6979, 33.46398], [-117.69775, 33.46365], [-117.69764, 33.46368], [-117.69743, 33.46356], [-117.69742, 33.4635], [-117.69737, 33.46345], [-117.69742, 33.46336], [-117.69733, 33.46325], [-117.69717, 33.46316], [-117.69702, 33.46313], [-117.69679, 33.46322], [-117.69672, 33.46317], [-117.69662, 33.46317], [-117.69659, 33.46319], [-117.69656, 33.46324], [-117.69646, 33.46323], [-117.69625, 33.4633], [-117.69608, 33.46344], [-117.69602, 33.46343], [-117.69596, 33.46343], [-117.69589, 33.4635], [-117.6958, 33.46349], [-117.69567, 33.46318], [-117.69558, 33.46257], [-117.69807, 33.46235]]]} | Open Access 1 | Heritage Park | 19847 | 1079 | Dana Point, City of 131 | City 2 | City Agency 2 | http://www.danapoint.org/index.aspx?page=170 | City 2 | 5.924 | Heritage Park | ||
5059 | 5059 | 5058 | {"type": "Polygon", "coordinates": [[[-117.84397, 33.97359], [-117.84302, 33.97478], [-117.84226, 33.97435], [-117.84321, 33.97317], [-117.84397, 33.97359]]]} | Open Access 1 | Heritage Park | 19848 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 3.321 | Heritage Park | ||
5060 | 5060 | 5059 | {"type": "Polygon", "coordinates": [[[-117.95117, 33.70777], [-117.95117, 33.70828], [-117.9504, 33.70829], [-117.9504, 33.70816], [-117.95045, 33.70811], [-117.95045, 33.70804], [-117.95053, 33.70802], [-117.95052, 33.70786], [-117.95104, 33.70785], [-117.95106, 33.70777], [-117.95117, 33.70777]]]} | Open Access 1 | Heritage Park | 19849 | 1111 | Fountain Valley, City of 268 | City 2 | City Agency 2 | http://www.fountainvalley.org/visitors/parks/ | City 2 | 0.804 | Heritage Park | ||
5061 | 5061 | 5060 | {"type": "Polygon", "coordinates": [[[-117.78086, 33.70027], [-117.78075, 33.70072], [-117.7807, 33.7008], [-117.7806, 33.70085], [-117.78027, 33.70086], [-117.78023, 33.70088], [-117.78016, 33.70097], [-117.77979, 33.70281], [-117.77977, 33.70299], [-117.77956, 33.70288], [-117.77939, 33.70284], [-117.77925, 33.70283], [-117.77909, 33.70284], [-117.77894, 33.70289], [-117.77872, 33.7031], [-117.77862, 33.7033], [-117.7785, 33.70404], [-117.77844, 33.70421], [-117.77816, 33.70418], [-117.77764, 33.70341], [-117.77759, 33.70343], [-117.77669, 33.70213], [-117.7772, 33.70185], [-117.7765, 33.70075], [-117.77767, 33.69954], [-117.77828, 33.69995], [-117.77854, 33.69994], [-117.77909, 33.69938], [-117.77899, 33.69929], [-117.77925, 33.69903], [-117.78064, 33.69999], [-117.78059, 33.70007], [-117.78086, 33.70027]]]} | Open Access 1 | Heritage Park | 19850 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 30.629 | Heritage Park | ||
5062 | 5062 | 5061 | {"type": "Polygon", "coordinates": [[[-117.77666, 34.12771], [-117.77648, 34.12776], [-117.77611, 34.1278], [-117.7758, 34.12781], [-117.77566, 34.12789], [-117.77553, 34.128], [-117.77518, 34.12847], [-117.77516, 34.12873], [-117.77513, 34.12876], [-117.77504, 34.12875], [-117.77491, 34.12831], [-117.77483, 34.12796], [-117.77483, 34.12784], [-117.77492, 34.12751], [-117.77553, 34.12759], [-117.77594, 34.12763], [-117.77604, 34.12765], [-117.77661, 34.12766], [-117.77665, 34.12768], [-117.77666, 34.12771]]]} | Open Access 1 | Heritage Park | 19851 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1.914 | Heritage Park | ||
5063 | 5063 | 5062 | {"type": "Polygon", "coordinates": [[[-117.93514, 33.73981], [-117.93478, 33.74004], [-117.93455, 33.74022], [-117.93426, 33.74049], [-117.93398, 33.7408], [-117.93383, 33.74101], [-117.93354, 33.74148], [-117.93336, 33.74182], [-117.9331, 33.74245], [-117.93308, 33.74147], [-117.93261, 33.74146], [-117.93261, 33.73985], [-117.93299, 33.73995], [-117.93392, 33.73994], [-117.93401, 33.73984], [-117.93402, 33.73981], [-117.93514, 33.73981]]]} | Open Access 1 | Heritage Park | 19854 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 6.8 | Heritage Park | ||
5064 | 5064 | 5063 | {"type": "MultiPolygon", "coordinates": [[[[-118.07484, 33.94086], [-118.07444, 33.94153], [-118.07459, 33.94162], [-118.07441, 33.94237], [-118.07292, 33.94176], [-118.07286, 33.94168], [-118.07286, 33.94086], [-118.07484, 33.94086]]], [[[-118.07801, 33.93894], [-118.07672, 33.94086], [-118.07657, 33.94091], [-118.07636, 33.94094], [-118.0762, 33.94095], [-118.07598, 33.94093], [-118.07577, 33.94087], [-118.07561, 33.9408], [-118.07547, 33.94071], [-118.0753, 33.94057], [-118.0753, 33.94053], [-118.07531, 33.9405], [-118.07546, 33.94036], [-118.07559, 33.94022], [-118.07585, 33.93981], [-118.07611, 33.93909], [-118.07615, 33.93904], [-118.07621, 33.93903], [-118.07745, 33.93902], [-118.07772, 33.93906], [-118.07784, 33.93902], [-118.07792, 33.93894], [-118.07801, 33.93894]]]]} | Open Access 1 | Heritage Park | 19855 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 12.827 | Heritage Park | ||
5065 | 5065 | 5064 | {"type": "Polygon", "coordinates": [[[-122.02496, 38.24674], [-122.02492, 38.24958], [-122.02414, 38.2496], [-122.0235, 38.24955], [-122.02346, 38.24783], [-122.02373, 38.24775], [-122.02372, 38.2467], [-122.02496, 38.24674]]]} | Open Access 1 | Heritage Park | 19856 | 1344 | Suisun City, City of 770 | City 2 | City Agency 2 | http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/ | City 2 | 9.413 | Heritage Park | 2000 | |
5066 | 5066 | 5065 | {"type": "MultiPolygon", "coordinates": [[[[-122.02756, 37.35569], [-122.02706, 37.35718], [-122.02573, 37.35689], [-122.02573, 37.35683], [-122.02593, 37.35668], [-122.02591, 37.3566], [-122.02541, 37.35623], [-122.02527, 37.3563], [-122.02507, 37.35626], [-122.02488, 37.35608], [-122.02463, 37.35617], [-122.02461, 37.35623], [-122.02459, 37.3566], [-122.02424, 37.35662], [-122.02413, 37.3567], [-122.02403, 37.35669], [-122.0246, 37.35502], [-122.02464, 37.355], [-122.02469, 37.355], [-122.0275, 37.3556], [-122.02755, 37.35563], [-122.02756, 37.35569]]], [[[-122.02762, 37.35884], [-122.0276, 37.35888], [-122.02754, 37.35892], [-122.02722, 37.35899], [-122.02692, 37.35907], [-122.02664, 37.35918], [-122.02638, 37.35931], [-122.02602, 37.35955], [-122.02581, 37.35973], [-122.02559, 37.35996], [-122.02551, 37.35997], [-122.02544, 37.35994], [-122.02431, 37.35901], [-122.02454, 37.35876], [-122.02474, 37.35877], [-122.02487, 37.35867], [-122.02505, 37.35883], [-122.02503, 37.35889], [-122.0251, 37.35895], [-122.02527, 37.35883], [-122.02521, 37.35875], [-122.02532, 37.35868], [-122.02527, 37.35861], [-122.02542, 37.35851], [-122.02551, 37.35857], [-122.0256, 37.35853], [-122.02567, 37.35855], [-122.02582, 37.3584], [-122.02573, 37.35831], [-122.02653, 37.35777], [-122.02687, 37.35806], [-122.02713, 37.35787], [-122.02745, 37.35832], [-122.02753, 37.35849], [-122.0276, 37.35874], [-122.02762, 37.35884]]]]} | Open Access 1 | Heritage Park | 19857 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 18.827 | Heritage Park | ||
5067 | 5067 | 5066 | {"type": "Polygon", "coordinates": [[[-117.79607, 33.73433], [-117.79549, 33.73543], [-117.79537, 33.73547], [-117.79461, 33.73512], [-117.79448, 33.73499], [-117.79435, 33.73497], [-117.79427, 33.735], [-117.79401, 33.73485], [-117.79493, 33.7337], [-117.79524, 33.73394], [-117.79553, 33.73407], [-117.79601, 33.73423], [-117.79607, 33.73433]]]} | Open Access 1 | Heritage Park | 19858 | 1360 | Tustin, City of 274 | City 2 | City Agency 2 | http://www.tustinca.org/departments/parksrec/index.html | City 2 | 4.987 | Heritage Park | ||
5068 | 5068 | 5067 | {"type": "Polygon", "coordinates": [[[-117.8726, 34.05496], [-117.87256, 34.05763], [-117.87241, 34.05747], [-117.8721, 34.05723], [-117.87146, 34.05685], [-117.87082, 34.05667], [-117.87053, 34.0566], [-117.87027, 34.05658], [-117.87028, 34.05563], [-117.87025, 34.05561], [-117.87026, 34.05429], [-117.87106, 34.05432], [-117.87173, 34.05453], [-117.8726, 34.05496]]]} | Open Access 1 | Heritage Park | 19859 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 14.33 | Heritage Park | ||
5069 | 5069 | 5068 | {"type": "Polygon", "coordinates": [[[-118.98667, 34.23418], [-118.98622, 34.2343], [-118.98467, 34.23476], [-118.98468, 34.23491], [-118.98432, 34.23495], [-118.98426, 34.23462], [-118.98353, 34.2344], [-118.98368, 34.23412], [-118.98373, 34.23392], [-118.98373, 34.23378], [-118.98365, 34.23333], [-118.9844, 34.23329], [-118.98445, 34.2335], [-118.98665, 34.23325], [-118.98664, 34.23381], [-118.98667, 34.23418]]]} | Open Access 1 | Heritage Park | 19861 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 8.894 | Heritage Park | ||
5070 | 5070 | 5069 | {"type": "Polygon", "coordinates": [[[-117.14961, 33.72167], [-117.14957, 33.72188], [-117.14951, 33.72209], [-117.1493, 33.72259], [-117.14746, 33.72206], [-117.14735, 33.72196], [-117.1474, 33.72191], [-117.14775, 33.72118], [-117.14828, 33.72134], [-117.14869, 33.72144], [-117.14954, 33.72159], [-117.14961, 33.72167]]]} | Open Access 1 | Heritage Park | 19862 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 4.833 | Heritage Park | ||
5071 | 5071 | 5070 | {"type": "Polygon", "coordinates": [[[-121.90826, 37.34403], [-121.90825, 37.34406], [-121.90731, 37.34471], [-121.90726, 37.34472], [-121.90722, 37.3447], [-121.90628, 37.34386], [-121.90732, 37.34314], [-121.90825, 37.34399], [-121.90826, 37.34403]]]} | Open Access 1 | Heritage Rose Garden | 19864 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 3.935 | Heritage Rose Garden | ||
5072 | 5072 | 5071 | {"type": "Polygon", "coordinates": [[[-118.21282, 34.08604], [-118.21279, 34.0861], [-118.21277, 34.0861], [-118.21265, 34.08637], [-118.21229, 34.0864], [-118.21188, 34.08647], [-118.21132, 34.08662], [-118.21073, 34.08685], [-118.21027, 34.08709], [-118.20971, 34.08746], [-118.20817, 34.08873], [-118.20788, 34.08904], [-118.20765, 34.08934], [-118.20734, 34.08932], [-118.20749, 34.0892], [-118.20785, 34.08875], [-118.20774, 34.08869], [-118.20778, 34.0886], [-118.20747, 34.08846], [-118.20787, 34.08805], [-118.20821, 34.08774], [-118.20832, 34.08767], [-118.20877, 34.08744], [-118.20891, 34.0874], [-118.20975, 34.08693], [-118.2099, 34.08687], [-118.21071, 34.08645], [-118.21071, 34.08643], [-118.21055, 34.0864], [-118.21158, 34.08576], [-118.21178, 34.08581], [-118.2118, 34.08576], [-118.21282, 34.08604]]]} | Open Access 1 | Heritage Square | 19865 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 8.473 | Heritage Square | ||
5073 | 5073 | 5072 | {"type": "Polygon", "coordinates": [[[-116.68439, 33.67798], [-116.68332, 33.67893], [-116.68325, 33.67922], [-116.68303, 33.67923], [-116.68266, 33.68164], [-116.68233, 33.68175], [-116.68215, 33.68145], [-116.68192, 33.68122], [-116.68198, 33.68043], [-116.68174, 33.68004], [-116.68091, 33.67917], [-116.68038, 33.67794], [-116.67964, 33.6772], [-116.6792, 33.6776], [-116.67885, 33.6784], [-116.67838, 33.67849], [-116.67788, 33.67828], [-116.67766, 33.6776], [-116.67571, 33.67759], [-116.6757, 33.67582], [-116.67894, 33.67586], [-116.6796, 33.67582], [-116.67984, 33.67574], [-116.68008, 33.67574], [-116.68006, 33.67523], [-116.68191, 33.67527], [-116.68211, 33.67525], [-116.68334, 33.67622], [-116.68347, 33.67629], [-116.68439, 33.67742], [-116.68439, 33.67798]]]} | Open Access 1 | Herkey Creek Park | 19866 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 62.303 | Herkey Creek Park | ||
5074 | 5074 | 5073 | {"type": "Polygon", "coordinates": [[[-122.41355, 37.63561], [-122.41355, 37.63561], [-122.41334, 37.63565], [-122.41336, 37.63552], [-122.41342, 37.63547], [-122.41351, 37.63555], [-122.41355, 37.63561]]]} | Open Access 1 | Herman Tot Lot | 19867 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 0.055 | Herman Tot Lot | 1940 | |
5075 | 5075 | 5074 | {"type": "Polygon", "coordinates": [[[-118.40966, 33.87693], [-118.40916, 33.87712], [-118.40823, 33.87745], [-118.40805, 33.87708], [-118.40801, 33.87707], [-118.40813, 33.87703], [-118.40816, 33.8771], [-118.40822, 33.87711], [-118.40823, 33.8771], [-118.40822, 33.87708], [-118.40836, 33.87708], [-118.40837, 33.87706], [-118.40666, 33.87357], [-118.40626, 33.87284], [-118.40629, 33.87284], [-118.40629, 33.87282], [-118.40491, 33.87024], [-118.40366, 33.86737], [-118.40335, 33.86655], [-118.40197, 33.8626], [-118.40194, 33.86259], [-118.40145, 33.86122], [-118.40147, 33.8612], [-118.39993, 33.85693], [-118.39788, 33.85239], [-118.39919, 33.85195], [-118.39906, 33.85149], [-118.39933, 33.85141], [-118.3994, 33.85192], [-118.39969, 33.85292], [-118.40028, 33.85445], [-118.40058, 33.85514], [-118.4014, 33.85734], [-118.40174, 33.85811], [-118.4023, 33.85951], [-118.40309, 33.86178], [-118.40365, 33.86348], [-118.40422, 33.86503], [-118.40487, 33.86666], [-118.40569, 33.86859], [-118.40699, 33.87144], [-118.40772, 33.87286], [-118.40805, 33.87357], [-118.40912, 33.87571], [-118.40966, 33.87693]]]} | Open Access 1 | Hermosa City Beach | 19869 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 91.817 | Hermosa City Beach | ||
5076 | 5076 | 5075 | {"type": "Polygon", "coordinates": [[[-117.5846, 34.13116], [-117.58458, 34.13119], [-117.58453, 34.13122], [-117.58266, 34.13123], [-117.58263, 34.12928], [-117.58458, 34.12927], [-117.5846, 34.13116]]]} | Open Access 1 | Hermosa Park | 19870 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 9.576 | Hermosa 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]);