superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where MNG_AGENCY = 304 and MNG_AG_TYP = 4 sorted by map descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 36 ✖
MNG_AGENCY 1
- Cordova Recreation and Park District · 36 ✖
ACCESS_TYP 1
- Open Access 36
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3243 | 3243 | 3242 | {"type": "Polygon", "coordinates": [[[-121.40928, 38.45719], [-121.40871, 38.45878], [-121.40829, 38.45876], [-121.40789, 38.45876], [-121.4075, 38.45879], [-121.407, 38.45885], [-121.4065, 38.45895], [-121.40595, 38.45914], [-121.40588, 38.45911], [-121.40581, 38.459], [-121.40565, 38.45865], [-121.40557, 38.45843], [-121.40548, 38.45807], [-121.40542, 38.45769], [-121.4054, 38.45739], [-121.40541, 38.4571], [-121.40544, 38.45703], [-121.40556, 38.45636], [-121.40559, 38.45632], [-121.40565, 38.45631], [-121.40599, 38.45634], [-121.40829, 38.45695], [-121.40928, 38.45719]]]} | Open Access 1 | Countryside Community Park | 17708 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 18.284 | Countryside Community Park | ||
6583 | 6583 | 6582 | {"type": "Polygon", "coordinates": [[[-121.36334, 38.55723], [-121.36257, 38.55762], [-121.36242, 38.55766], [-121.36227, 38.55768], [-121.36222, 38.55742], [-121.36205, 38.55743], [-121.36191, 38.55645], [-121.36279, 38.55637], [-121.36283, 38.55664], [-121.36288, 38.55665], [-121.36334, 38.55723]]]} | Open Access 1 | Manlove Park | 21751 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2.852 | Manlove Park | ||
8413 | 8413 | 8412 | {"type": "Polygon", "coordinates": [[[-121.36159, 38.53637], [-121.36153, 38.53648], [-121.3615, 38.53648], [-121.36134, 38.53667], [-121.36134, 38.53695], [-121.36011, 38.53694], [-121.36007, 38.53693], [-121.36005, 38.5369], [-121.36005, 38.53629], [-121.36009, 38.53622], [-121.36017, 38.53615], [-121.36019, 38.5361], [-121.36016, 38.53603], [-121.36008, 38.53599], [-121.36009, 38.53595], [-121.36159, 38.53637]]]} | Open Access 1 | Primrose Park | 24003 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2.589 | Primrose Park | ||
5999 | 5999 | 5998 | {"type": "Polygon", "coordinates": [[[-121.36093, 38.5692], [-121.36015, 38.56933], [-121.35965, 38.56944], [-121.35916, 38.56957], [-121.35834, 38.56982], [-121.35794, 38.56992], [-121.35784, 38.56966], [-121.35782, 38.56964], [-121.35786, 38.56961], [-121.35791, 38.56965], [-121.35818, 38.56972], [-121.35829, 38.56948], [-121.35801, 38.56939], [-121.35801, 38.56936], [-121.35839, 38.56925], [-121.35755, 38.56692], [-121.35819, 38.56676], [-121.35839, 38.56669], [-121.35861, 38.56657], [-121.35882, 38.5664], [-121.35902, 38.56654], [-121.35909, 38.56657], [-121.35973, 38.56834], [-121.36055, 38.56815], [-121.36093, 38.5692]]]} | Open Access 1 | Larchmont Community Park | 21023 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 14.068 | Larchmont Community Park | ||
8949 | 8949 | 8948 | {"type": "Polygon", "coordinates": [[[-121.35365, 38.55201], [-121.35123, 38.55245], [-121.3507, 38.5526], [-121.34978, 38.55126], [-121.3504, 38.55079], [-121.35068, 38.5506], [-121.35104, 38.55043], [-121.35139, 38.55031], [-121.35171, 38.55024], [-121.35213, 38.55019], [-121.35352, 38.55019], [-121.35352, 38.55152], [-121.35365, 38.55201]]]} | Open Access 1 | Rosemont Community Park | 24622 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 16.026 | Rosemont Community Park | ||
8950 | 8950 | 8949 | {"type": "Polygon", "coordinates": [[[-121.35261, 38.55785], [-121.35216, 38.5583], [-121.35181, 38.55855], [-121.35162, 38.55839], [-121.35127, 38.5586], [-121.35118, 38.55846], [-121.35109, 38.55821], [-121.35107, 38.55809], [-121.35099, 38.55802], [-121.35101, 38.55795], [-121.35093, 38.55773], [-121.3517, 38.55757], [-121.35231, 38.55746], [-121.35235, 38.55769], [-121.35261, 38.55785]]]} | Open Access 1 | Rosemont North Park | 24623 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2.786 | Rosemont North Park | ||
5029 | 5029 | 5028 | {"type": "Polygon", "coordinates": [[[-121.35089, 38.54512], [-121.35061, 38.54519], [-121.35033, 38.5452], [-121.35033, 38.54473], [-121.3508, 38.54468], [-121.35089, 38.54512]]]} | Open Access 1 | Henley Park | 19818 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 0.591 | Henley Park | ||
9005 | 9005 | 9004 | {"type": "Polygon", "coordinates": [[[-121.34637, 38.54437], [-121.34635, 38.54442], [-121.34634, 38.54451], [-121.346, 38.54444], [-121.34586, 38.54485], [-121.34561, 38.54522], [-121.34534, 38.54497], [-121.34532, 38.54458], [-121.34599, 38.54421], [-121.34637, 38.54437]]]} | Open Access 1 | Rosswood Park | 24680 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 1.106 | Rosswood Park | ||
8809 | 8809 | 8808 | {"type": "Polygon", "coordinates": [[[-121.34174, 38.57559], [-121.34172, 38.57664], [-121.34123, 38.57672], [-121.34084, 38.57682], [-121.34046, 38.57696], [-121.33999, 38.57717], [-121.3397, 38.5768], [-121.33931, 38.57652], [-121.33865, 38.57661], [-121.33866, 38.57559], [-121.34174, 38.57559]]]} | Open Access 1 | Riviera East Park | 24469 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 8.726 | Riviera East Park | ||
6206 | 6206 | 6205 | {"type": "Polygon", "coordinates": [[[-121.32083, 38.56642], [-121.32067, 38.56655], [-121.32071, 38.56678], [-121.32065, 38.56691], [-121.32067, 38.56717], [-121.32081, 38.56787], [-121.31809, 38.56786], [-121.31809, 38.56555], [-121.32057, 38.56556], [-121.3207, 38.56563], [-121.32064, 38.56605], [-121.32083, 38.56642]]]} | Open Access 1 | Lincoln Village Park | 21277 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 14.463 | Lincoln Village Park | ||
10243 | 10243 | 10242 | {"type": "Polygon", "coordinates": [[[-121.31931, 38.59043], [-121.31921, 38.59047], [-121.31918, 38.59045], [-121.31909, 38.59049], [-121.31908, 38.59052], [-121.31834, 38.59081], [-121.31743, 38.59101], [-121.31641, 38.59122], [-121.31619, 38.59056], [-121.3161, 38.59037], [-121.31601, 38.59024], [-121.31583, 38.59003], [-121.31556, 38.58987], [-121.31558, 38.58963], [-121.31556, 38.58938], [-121.31559, 38.58935], [-121.31772, 38.58891], [-121.31783, 38.58922], [-121.31826, 38.58906], [-121.3185, 38.58983], [-121.3189, 38.58974], [-121.31901, 38.58995], [-121.31931, 38.59043]]]} | Open Access 1 | Taylor Park | 26205 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 12.824 | Taylor Park | ||
13948 | 13948 | 13947 | {"type": "Polygon", "coordinates": [[[-121.3151, 38.57228], [-121.31468, 38.57252], [-121.31468, 38.57254], [-121.31471, 38.57257], [-121.31444, 38.57275], [-121.31433, 38.57263], [-121.314, 38.57281], [-121.31339, 38.57218], [-121.31497, 38.57194], [-121.31502, 38.57219], [-121.3151, 38.57228]]]} | Open Access 1 | Countryside Park | https://crpd.com/parks/countryside-park/ | 33252 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 1.981 | Countryside Park | |
4830 | 4830 | 4829 | {"type": "Polygon", "coordinates": [[[-121.31331, 38.60273], [-121.31135, 38.60429], [-121.31035, 38.60352], [-121.30748, 38.60507], [-121.30707, 38.60476], [-121.308, 38.60403], [-121.30764, 38.60358], [-121.30773, 38.60336], [-121.30798, 38.60341], [-121.30826, 38.60269], [-121.3078, 38.60256], [-121.30816, 38.60167], [-121.30997, 38.60023], [-121.31223, 38.60202], [-121.31197, 38.60224], [-121.31251, 38.60266], [-121.31287, 38.60239], [-121.31331, 38.60273]]]} | Open Access 1 | Hagan Community Park | 19592 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 32.957 | Hagan Community Park | ||
5998 | 5998 | 5997 | {"type": "Polygon", "coordinates": [[[-121.29376, 38.61641], [-121.2926, 38.61697], [-121.29226, 38.61708], [-121.29206, 38.61712], [-121.29167, 38.61716], [-121.29062, 38.61718], [-121.29062, 38.61689], [-121.29073, 38.61684], [-121.29073, 38.61566], [-121.29074, 38.61549], [-121.29093, 38.61504], [-121.29109, 38.61476], [-121.29116, 38.61472], [-121.29168, 38.61484], [-121.29284, 38.61492], [-121.29299, 38.61537], [-121.29344, 38.61594], [-121.29363, 38.61625], [-121.29376, 38.61641]]]} | Open Access 1 | Larchmont-Rossmoor Park | 21022 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 13.185 | Larchmont-Rossmoor Park | ||
4197 | 4197 | 4196 | {"type": "Polygon", "coordinates": [[[-121.29372, 38.59969], [-121.2937, 38.59987], [-121.29369, 38.60011], [-121.29362, 38.60011], [-121.29329, 38.6005], [-121.29325, 38.60071], [-121.29244, 38.60167], [-121.29222, 38.60166], [-121.29222, 38.60129], [-121.29235, 38.60126], [-121.29244, 38.60117], [-121.29247, 38.60106], [-121.29268, 38.60058], [-121.29278, 38.60033], [-121.29299, 38.59957], [-121.29304, 38.59954], [-121.29366, 38.59964], [-121.2937, 38.59966], [-121.29372, 38.59969]]]} | Open Access 1 | Federspiel Park (Rancho Pk) | 18862 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2.955 | Federspiel Park (Rancho Pk) | ||
1418 | 1418 | 1417 | {"type": "Polygon", "coordinates": [[[-121.28989, 38.60301], [-121.2892, 38.60361], [-121.28854, 38.60412], [-121.2874, 38.60253], [-121.28783, 38.60224], [-121.2882, 38.60189], [-121.28853, 38.60168], [-121.28904, 38.60223], [-121.28918, 38.60246], [-121.28943, 38.60274], [-121.28989, 38.60301]]]} | Open Access 1 | Ahlstrom Park | 15298 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 7.052 | Ahlstrom Park | ||
9777 | 9777 | 9776 | {"type": "Polygon", "coordinates": [[[-121.28691, 38.57521], [-121.28655, 38.57524], [-121.28655, 38.57552], [-121.2865, 38.57556], [-121.28649, 38.57561], [-121.28641, 38.57563], [-121.28641, 38.57596], [-121.28637, 38.57601], [-121.28626, 38.57596], [-121.28579, 38.5756], [-121.2855, 38.57543], [-121.28552, 38.57532], [-121.28571, 38.57498], [-121.28582, 38.57472], [-121.28589, 38.57448], [-121.28599, 38.57405], [-121.28601, 38.57401], [-121.28606, 38.57398], [-121.28679, 38.57398], [-121.28691, 38.57521]]]} | Open Access 1 | Sonoma Park | 25617 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 4.235 | Sonoma Park | ||
3449 | 3449 | 3448 | {"type": "Polygon", "coordinates": [[[-121.28463, 38.61359], [-121.28384, 38.61418], [-121.2836, 38.61398], [-121.28315, 38.61374], [-121.2827, 38.61353], [-121.28266, 38.61315], [-121.28206, 38.61265], [-121.28155, 38.61301], [-121.28143, 38.61292], [-121.28135, 38.6129], [-121.28126, 38.61282], [-121.28122, 38.61284], [-121.28084, 38.61251], [-121.28072, 38.61246], [-121.27992, 38.61181], [-121.27964, 38.61202], [-121.27954, 38.61214], [-121.27774, 38.61348], [-121.2752, 38.61108], [-121.27737, 38.61031], [-121.27967, 38.60944], [-121.28041, 38.61005], [-121.28463, 38.61359]]]} | Open Access 1 | Dave Roberts Community Park | 17936 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 42.027 | Dave Roberts Community Park | ||
10838 | 10838 | 10837 | {"type": "Polygon", "coordinates": [[[-121.2831, 38.54518], [-121.2834, 38.54533], [-121.28355, 38.54545], [-121.28366, 38.54556], [-121.28375, 38.54569], [-121.28383, 38.54584], [-121.28387, 38.546], [-121.28389, 38.54611], [-121.28388, 38.54625], [-121.28385, 38.54638], [-121.28375, 38.5466], [-121.28357, 38.54681], [-121.28342, 38.54693], [-121.28327, 38.54702], [-121.28311, 38.54709], [-121.28294, 38.54714], [-121.28262, 38.54718], [-121.28229, 38.54716], [-121.28191, 38.54706], [-121.2819, 38.54703], [-121.28221, 38.54635], [-121.28245, 38.54596], [-121.28287, 38.54612], [-121.28277, 38.5463], [-121.28299, 38.54637], [-121.28311, 38.54615], [-121.28249, 38.5459], [-121.28307, 38.54519], [-121.2831, 38.54518]]]} | Open Access 1 | Veterans Park | 27056 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 5.719 | Veterans Park | ||
11060 | 11060 | 11059 | {"type": "Polygon", "coordinates": [[[-121.28286, 38.5753], [-121.28275, 38.57551], [-121.28263, 38.57548], [-121.2824, 38.57529], [-121.28262, 38.57514], [-121.28271, 38.57522], [-121.28286, 38.5753]]]} | Open Access 1 | Waterbrook Park | 27299 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 0.214 | Waterbrook 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]);