superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where MNG_AGENCY = 304, MNG_AG_LEV = 4 and MNG_AG_TYP = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
948 | 948 | 947 | {"type": "Polygon", "coordinates": [[[-121.23559, 38.544], [-121.23559, 38.54448], [-121.23555, 38.54472], [-121.23549, 38.54487], [-121.23539, 38.54502], [-121.23527, 38.54515], [-121.23513, 38.54526], [-121.23487, 38.54539], [-121.23423, 38.54559], [-121.23425, 38.5437], [-121.23444, 38.5437], [-121.2346, 38.54367], [-121.23475, 38.54362], [-121.23495, 38.54351], [-121.23489, 38.54359], [-121.23487, 38.54365], [-121.2349, 38.54373], [-121.23495, 38.54378], [-121.23507, 38.54386], [-121.23521, 38.54391], [-121.23536, 38.54395], [-121.23554, 38.54396], [-121.23559, 38.544]]]} | Open Access 1 | Sandpiper Park | https://crpd.com/parks/sandpiper-park/ | 33579 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 4.884 | Sandpiper Park | |
949 | 949 | 948 | {"type": "Polygon", "coordinates": [[[-121.20817, 38.55629], [-121.20815, 38.55632], [-121.20781, 38.55648], [-121.20757, 38.55664], [-121.20685, 38.55729], [-121.20612, 38.55679], [-121.2057, 38.55716], [-121.20571, 38.55567], [-121.2061, 38.55554], [-121.20642, 38.55548], [-121.20676, 38.55548], [-121.20712, 38.55553], [-121.20749, 38.55565], [-121.20816, 38.55625], [-121.20817, 38.55629]]]} | Open Access 1 | Sunridge Park | https://crpd.com/parks/sunridge-park/ | 33580 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 7.147 | Sunridge Park | |
950 | 950 | 949 | {"type": "Polygon", "coordinates": [[[-121.23214, 38.53159], [-121.23155, 38.53215], [-121.23094, 38.53244], [-121.23062, 38.53222], [-121.23041, 38.53223], [-121.23036, 38.53214], [-121.22999, 38.53189], [-121.22984, 38.53176], [-121.22982, 38.53173], [-121.22984, 38.53169], [-121.23103, 38.53085], [-121.23107, 38.53084], [-121.23112, 38.53085], [-121.23132, 38.53101], [-121.23173, 38.53129], [-121.23186, 38.53132], [-121.23187, 38.53141], [-121.23214, 38.53159]]]} | Open Access 1 | Kavala Ranch Park | https://crpd.com/parks/kavala-ranch/ | 33581 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 4.826 | Kavala Ranch Park | |
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 | ||
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 | ||
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 | ||
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) | ||
4616 | 4616 | 4615 | {"type": "Polygon", "coordinates": [[[-121.2508, 38.62709], [-121.24976, 38.62743], [-121.249, 38.62581], [-121.24936, 38.62569], [-121.24979, 38.6255], [-121.24985, 38.6255], [-121.24989, 38.62551], [-121.25017, 38.62586], [-121.25037, 38.62618], [-121.2508, 38.62709]]]} | Open Access 1 | Gold River Park | 19355 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 4.537 | Gold River Park | ||
4617 | 4617 | 4616 | {"type": "Polygon", "coordinates": [[[-121.25992, 38.61762], [-121.25969, 38.61775], [-121.25953, 38.61787], [-121.25938, 38.61801], [-121.25892, 38.61851], [-121.25887, 38.61853], [-121.25883, 38.61852], [-121.2588, 38.6185], [-121.25869, 38.61819], [-121.25838, 38.61767], [-121.25903, 38.61743], [-121.25941, 38.61741], [-121.25962, 38.61733], [-121.25975, 38.61722], [-121.25992, 38.61762]]]} | Open Access 1 | Gold Station Park | 19356 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2.205 | Gold Station 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 | ||
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 | ||
5339 | 5339 | 5338 | {"type": "MultiPolygon", "coordinates": [[[[-121.27833, 38.54582], [-121.27831, 38.54586], [-121.27759, 38.54614], [-121.27745, 38.54616], [-121.27732, 38.54615], [-121.27721, 38.54611], [-121.27634, 38.54566], [-121.2766, 38.54531], [-121.27509, 38.54452], [-121.27566, 38.54384], [-121.27608, 38.5443], [-121.27697, 38.54493], [-121.27817, 38.54514], [-121.2783, 38.54573], [-121.27833, 38.54582]]], [[[-121.28033, 38.54412], [-121.27999, 38.54452], [-121.27967, 38.54497], [-121.27943, 38.54539], [-121.2792, 38.5459], [-121.2791, 38.54587], [-121.27852, 38.54594], [-121.27836, 38.54512], [-121.27937, 38.54391], [-121.27948, 38.54394], [-121.27938, 38.54429], [-121.27983, 38.54438], [-121.28006, 38.5437], [-121.28012, 38.54369], [-121.28015, 38.54378], [-121.28033, 38.54412]]]]} | Open Access 1 | Independence Park | 20195 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 11.255 | Independence 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 | ||
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 | ||
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 | ||
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 | ||
8422 | 8422 | 8421 | {"type": "Polygon", "coordinates": [[[-121.24752, 38.61948], [-121.24699, 38.62044], [-121.24671, 38.62104], [-121.24665, 38.621], [-121.24605, 38.62078], [-121.24586, 38.62072], [-121.24558, 38.62068], [-121.2451, 38.6207], [-121.24505, 38.62069], [-121.24503, 38.62066], [-121.24501, 38.62046], [-121.24501, 38.62028], [-121.24505, 38.62011], [-121.24513, 38.61994], [-121.24524, 38.61977], [-121.24538, 38.61962], [-121.24554, 38.61949], [-121.24576, 38.61937], [-121.24596, 38.61929], [-121.24613, 38.61925], [-121.24635, 38.61922], [-121.2466, 38.61922], [-121.24694, 38.61927], [-121.24752, 38.61948]]]} | Open Access 1 | Prospect Hill Park | 24018 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 7.155 | Prospect Hill Park | ||
8639 | 8639 | 8638 | {"type": "MultiPolygon", "coordinates": [[[[-121.27836, 38.58611], [-121.27831, 38.58614], [-121.27812, 38.58617], [-121.2774, 38.58624], [-121.27733, 38.58622], [-121.2773, 38.58617], [-121.27731, 38.58599], [-121.27741, 38.58549], [-121.27744, 38.58545], [-121.27749, 38.58543], [-121.27781, 38.58545], [-121.2781, 38.58543], [-121.27816, 38.58544], [-121.27819, 38.58548], [-121.27837, 38.58605], [-121.27836, 38.58611]]], [[[-121.27804, 38.58653], [-121.27742, 38.5866], [-121.27737, 38.58635], [-121.27798, 38.5863], [-121.27804, 38.58653]]]]} | Open Access 1 | Renaissance Park | https://crpd.com/parks/renaissance-park/ | 24292 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2.063 | Renaissance 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 |
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]);