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 373
- San Diego, City of 368
- San Jose, City of 183
- San Francisco, City and County of 167
- Sacramento, City of 166
- Ventura, City of 140
- Long Beach, City of 119
- Roseville, City of 104
- Oakland, City of 83
- Irvine, City of 81
- Fresno, City of 80
- Torrance, City of 65
- Huntington Beach, City of 61
- Poway, City of 61
- Stockton, City of 61
- Santa Cruz, City of 59
- Modesto, City of 58
- Chula Vista, City of 57
- Tracy, City of 57
- Napa, City of 56
- Encinitas, City of 53
- Davis, City of 53
- San Luis Obispo, City of 50
- Rocklin, City of 50
- Santa Rosa, City of 49
- Clovis, City of 49
- Santa Barbara, City of 48
- Newport Beach, City of 48
- San Ramon, City of 48
- Anaheim, City of 44
- …
ACCESS_TYP 4
- Open Access 7,359
- Restricted Access 265
- No Public Access 140
- Unknown Access 25
MNG_AG_TYP 1
- City Agency · 7,789 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3846 | 3846 | 3845 | {"type": "Polygon", "coordinates": [[[-121.823, 37.2655], [-121.82273, 37.26566], [-121.82189, 37.26626], [-121.82172, 37.26633], [-121.82156, 37.26635], [-121.82143, 37.26634], [-121.82131, 37.2663], [-121.82003, 37.26559], [-121.8195, 37.26514], [-121.81947, 37.26509], [-121.81945, 37.26503], [-121.81942, 37.26502], [-121.81945, 37.26287], [-121.82135, 37.26289], [-121.82136, 37.26338], [-121.82176, 37.26351], [-121.82177, 37.26403], [-121.82156, 37.26429], [-121.82156, 37.26434], [-121.823, 37.2655]]]} | Open Access 1 | Edenvale Garden | 18431 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 18.981 | Edenvale Garden | 1991 | |
3848 | 3848 | 3847 | {"type": "Polygon", "coordinates": [[[-118.02716, 33.77607], [-118.02715, 33.77847], [-118.02713, 33.77851], [-118.02649, 33.77851], [-118.02651, 33.77704], [-118.02563, 33.77703], [-118.02407, 33.77705], [-118.02407, 33.77607], [-118.02716, 33.77607]]]} | Open Access 1 | Edgar Park | 18433 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 10.037 | Edgar Park | ||
3849 | 3849 | 3848 | {"type": "Polygon", "coordinates": [[[-121.43046, 37.7577], [-121.42818, 37.75771], [-121.42817, 37.75587], [-121.42952, 37.75575], [-121.42952, 37.75433], [-121.43045, 37.75433], [-121.43046, 37.7577]]]} | Open Access 1 | El Pescadero Park | 18528 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 13.777 | El Pescadero Park | ||
3851 | 3851 | 3850 | {"type": "Polygon", "coordinates": [[[-122.4606, 37.74202], [-122.46018, 37.74226], [-122.4602, 37.74231], [-122.4599, 37.74259], [-122.45924, 37.74241], [-122.45915, 37.74237], [-122.45931, 37.74181], [-122.45932, 37.74173], [-122.4593, 37.74167], [-122.45933, 37.7414], [-122.4596, 37.74141], [-122.45972, 37.74147], [-122.45971, 37.74151], [-122.45981, 37.74163], [-122.45974, 37.74167], [-122.45974, 37.74169], [-122.46007, 37.74186], [-122.46026, 37.74166], [-122.4606, 37.74202]]]} | Open Access 1 | Edgehill Mountain | 18435 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 2.347 | Edgehill Mtn. | ||
3852 | 3852 | 3851 | {"type": "Polygon", "coordinates": [[[-122.48783, 37.65343], [-122.48751, 37.65378], [-122.48743, 37.65376], [-122.48732, 37.65381], [-122.48696, 37.65377], [-122.48679, 37.65385], [-122.48662, 37.65364], [-122.4866, 37.65358], [-122.48666, 37.65328], [-122.48738, 37.65336], [-122.48762, 37.6533], [-122.48783, 37.65343]]]} | Open Access 1 | Edgemar Park | 18436 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1.18 | Edgemar Park | ||
3853 | 3853 | 3852 | {"type": "Polygon", "coordinates": [[[-122.27653, 37.54926], [-122.27598, 37.5498], [-122.27574, 37.54998], [-122.27545, 37.55013], [-122.27559, 37.55037], [-122.27533, 37.55047], [-122.27506, 37.55054], [-122.27479, 37.55059], [-122.27475, 37.55059], [-122.27471, 37.55057], [-122.27468, 37.55038], [-122.27467, 37.55013], [-122.2747, 37.5497], [-122.27469, 37.54944], [-122.27465, 37.54912], [-122.27457, 37.54884], [-122.27538, 37.54842], [-122.27555, 37.54861], [-122.27572, 37.54875], [-122.27653, 37.54926]]]} | Open Access 1 | Edgewater Park | 18437 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 5.907 | Edgewater Park | 1960 | |
3855 | 3855 | 3854 | {"type": "Polygon", "coordinates": [[[-122.46028, 37.70064], [-122.46009, 37.70065], [-122.45961, 37.70111], [-122.45957, 37.70032], [-122.46026, 37.70029], [-122.46028, 37.70064]]]} | Open Access 1 | Edgewood Park | 18440 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 0.854 | Edgewood Park | ||
3856 | 3856 | 3855 | {"type": "Polygon", "coordinates": [[[-122.56127, 37.90272], [-122.56111, 37.90294], [-122.56104, 37.90321], [-122.56096, 37.90329], [-122.56054, 37.90341], [-122.56012, 37.90317], [-122.55964, 37.90307], [-122.55927, 37.90288], [-122.559, 37.9024], [-122.55868, 37.90221], [-122.55918, 37.90164], [-122.55976, 37.90179], [-122.55993, 37.90166], [-122.5605, 37.90226], [-122.56127, 37.90272]]]} | Open Access 1 | Edgewood Park | 18441 | 1204 | Mill Valley, City of 223 | City 2 | City Agency 2 | http://www.cityofmillvalley.org/Index.aspx?page=416 | City 2 | 5.984 | Edgewood Park | ||
3857 | 3857 | 3856 | {"type": "Polygon", "coordinates": [[[-122.48438, 37.66358], [-122.4839, 37.66357], [-122.48388, 37.66343], [-122.48379, 37.6633], [-122.48372, 37.66324], [-122.4836, 37.66318], [-122.48347, 37.66314], [-122.48336, 37.66314], [-122.48262, 37.66222], [-122.48276, 37.66179], [-122.48259, 37.66157], [-122.48264, 37.66105], [-122.48212, 37.6607], [-122.4824, 37.66037], [-122.48259, 37.65977], [-122.48304, 37.66045], [-122.48352, 37.66124], [-122.48359, 37.66156], [-122.4837, 37.66191], [-122.48438, 37.66358]]]} | Open Access 1 | Edgewood Park | 18442 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 7.397 | Edgewood Park | 2000 | |
3859 | 3859 | 3858 | {"type": "Polygon", "coordinates": [[[-117.89577, 33.85049], [-117.8937, 33.85049], [-117.89367, 33.84909], [-117.89575, 33.84909], [-117.89577, 33.85049]]]} | Open Access 1 | Edison Park | 18445 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 7.387 | Edison Park | ||
3860 | 3860 | 3859 | {"type": "Polygon", "coordinates": [[[-118.09665, 33.77734], [-118.09664, 33.77835], [-118.09659, 33.77908], [-118.09606, 33.779], [-118.09566, 33.77902], [-118.09569, 33.77668], [-118.09574, 33.77489], [-118.09606, 33.77483], [-118.09664, 33.77485], [-118.09662, 33.77729], [-118.09665, 33.77734]]]} | Open Access 1 | Edison Park | 18446 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 9.949 | Edison Park | ||
3861 | 3861 | 3860 | {"type": "Polygon", "coordinates": [[[-118.12837, 34.0455], [-118.12829, 34.04553], [-118.12817, 34.04553], [-118.12743, 34.04535], [-118.1272, 34.04532], [-118.11801, 34.04309], [-118.11799, 34.04277], [-118.11801, 34.04266], [-118.12629, 34.04467], [-118.12828, 34.0447], [-118.12838, 34.04547], [-118.12837, 34.0455]]]} | Open Access 1 | Edison Trails Park | 18447 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | http://www.ci.monterey-park.ca.us/ | City 2 | 12.367 | Edison Trails Park | ||
3862 | 3862 | 3861 | {"type": "Polygon", "coordinates": [[[-121.94347, 37.27888], [-121.94328, 37.27905], [-121.94231, 37.27968], [-121.94207, 37.27977], [-121.94181, 37.2798], [-121.94163, 37.27979], [-121.94147, 37.27974], [-121.94131, 37.27967], [-121.94112, 37.27953], [-121.94097, 37.27935], [-121.94079, 37.27887], [-121.94347, 37.27888]]]} | Open Access 1 | Edith Morley Park | 18448 | 1043 | Campbell, City of 442 | City 2 | City Agency 2 | http://www.ci.campbell.ca.us/226/Recreation-Parks | City 2 | 4.003 | Edith Morley Park | ||
3863 | 3863 | 3862 | {"type": "Polygon", "coordinates": [[[-118.38718, 33.85905], [-118.38653, 33.85914], [-118.38641, 33.85852], [-118.38712, 33.85872], [-118.38718, 33.85905]]]} | Open Access 1 | Edith Rodaway Friendship Park | 18449 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 0.805 | Edith Rodaway Friendship Park | ||
3864 | 3864 | 3863 | {"type": "Polygon", "coordinates": [[[-117.89348, 34.09213], [-117.89348, 34.09262], [-117.89296, 34.09263], [-117.89283, 34.09267], [-117.89259, 34.09276], [-117.89236, 34.09279], [-117.89236, 34.09214], [-117.89348, 34.09213]]]} | Open Access 1 | Edna Park | 18450 | 1073 | Covina, City of 203 | City 2 | City Agency 2 | http://www.ci.covina.ca.us/city-departments/parks-a-recreation | City 2 | 1.539 | Edna Park | ||
3867 | 3867 | 3866 | {"type": "Polygon", "coordinates": [[[-116.98119, 33.74391], [-116.98076, 33.74408], [-116.98046, 33.74418], [-116.98046, 33.74392], [-116.98119, 33.74391]]]} | Open Access 1 | Edward J. Rodeghier Green Park | 18456 | 1132 | Hemet, City of 139 | City 2 | City Agency 2 | http://www.cityofhemet.org/index.aspx?nid=95 | City 2 | 0.244 | Edward J. Rodeghier Green Park | ||
3868 | 3868 | 3867 | {"type": "Polygon", "coordinates": [[[-121.47357, 38.4861], [-121.47167, 38.48617], [-121.47167, 38.48616], [-121.47171, 38.48611], [-121.47223, 38.48592], [-121.47289, 38.48556], [-121.47313, 38.48548], [-121.47341, 38.48542], [-121.47357, 38.4861]]]} | Open Access 1 | Edward Kemble Park | 18457 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.745 | Edward Kemble Park | ||
3869 | 3869 | 3868 | {"type": "MultiPolygon", "coordinates": [[[[-117.94976, 33.88576], [-117.94976, 33.8858], [-117.94964, 33.88596], [-117.94929, 33.88575], [-117.94942, 33.88558], [-117.94976, 33.88576]]], [[[-117.95294, 33.88975], [-117.95255, 33.89002], [-117.95104, 33.89003], [-117.95181, 33.88902], [-117.95173, 33.88877], [-117.95141, 33.88884], [-117.95137, 33.88877], [-117.95131, 33.88873], [-117.95151, 33.88853], [-117.95151, 33.88851], [-117.95134, 33.88841], [-117.95094, 33.88829], [-117.95126, 33.88828], [-117.95122, 33.88789], [-117.95099, 33.88758], [-117.95097, 33.88744], [-117.95083, 33.88713], [-117.9508, 33.88698], [-117.95065, 33.88657], [-117.95056, 33.88645], [-117.95043, 33.88633], [-117.95026, 33.88641], [-117.95016, 33.88628], [-117.94984, 33.88607], [-117.94982, 33.88603], [-117.94982, 33.88601], [-117.9499, 33.88592], [-117.94994, 33.88589], [-117.95, 33.8859], [-117.95028, 33.88609], [-117.95073, 33.88647], [-117.95101, 33.88677], [-117.95114, 33.88694], [-117.95138, 33.88731], [-117.95187, 33.88828], [-117.95203, 33.88864], [-117.95224, 33.88899], [-117.9524, 33.88919], [-117.95294, 33.88975]]]]} | Open Access 1 | Edward White II Park | 18458 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 6.785 | Edward White II Park | ||
3870 | 3870 | 3869 | {"type": "Polygon", "coordinates": [[[-121.50809, 38.48685], [-121.50809, 38.4869], [-121.50806, 38.48692], [-121.50752, 38.48709], [-121.5074, 38.48708], [-121.50731, 38.48712], [-121.50725, 38.48706], [-121.50686, 38.48709], [-121.50671, 38.48606], [-121.50754, 38.48607], [-121.50755, 38.48609], [-121.50757, 38.4861], [-121.5076, 38.48624], [-121.50767, 38.48638], [-121.50773, 38.48646], [-121.508, 38.48671], [-121.50809, 38.48685]]]} | Open Access 1 | Edwin Z'berg Park | 18461 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.479 | Edwin Z'berg Park | ||
3871 | 3871 | 3870 | {"type": "MultiPolygon", "coordinates": [[[[-121.68811, 38.16638], [-121.68698, 38.16787], [-121.68549, 38.16698], [-121.68678, 38.16568], [-121.68811, 38.16638]]], [[[-121.68889, 38.16495], [-121.68802, 38.16593], [-121.68697, 38.16507], [-121.68672, 38.16489], [-121.68773, 38.16406], [-121.68889, 38.16495]]]]} | Open Access 1 | Egbert Field | 18465 | 1276 | Rio Vista, City of 324 | City 2 | City Agency 2 | http://riovistacity.com/parks-dept/ | City 2 | 11.868 | Egbert Field |
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]);