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 rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
13765 | 13765 | 13764 | {"type": "Polygon", "coordinates": [[[-121.23949, 38.55728], [-121.23948, 38.55731], [-121.23944, 38.55734], [-121.2391, 38.55736], [-121.23686, 38.55732], [-121.23682, 38.55731], [-121.2368, 38.55729], [-121.2368, 38.5567], [-121.23679, 38.55666], [-121.23676, 38.55663], [-121.23683, 38.55658], [-121.23683, 38.55631], [-121.23921, 38.55639], [-121.23932, 38.5566], [-121.23943, 38.55694], [-121.23949, 38.55728]]]} | Open Access 1 | Argonaut Park | http://crpd.com/parks/argonaut-park/ | 31273 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 6.116 | Argonaut Park | |
13736 | 13736 | 13735 | {"type": "Polygon", "coordinates": [[[-121.28169, 38.58508], [-121.28164, 38.5851], [-121.28134, 38.58511], [-121.2804, 38.5853], [-121.28024, 38.58532], [-121.28005, 38.58529], [-121.27994, 38.58524], [-121.27982, 38.58513], [-121.27977, 38.58511], [-121.27973, 38.58501], [-121.27972, 38.58495], [-121.27975, 38.58492], [-121.27979, 38.58478], [-121.2799, 38.58466], [-121.28005, 38.58458], [-121.28108, 38.58436], [-121.28139, 38.58424], [-121.28145, 38.58426], [-121.28159, 38.58436], [-121.28172, 38.58453], [-121.28177, 38.58466], [-121.28179, 38.58479], [-121.28177, 38.58492], [-121.28172, 38.58506], [-121.28169, 38.58508]]]} | Open Access 1 | Village Green Park | http://crpd.com/parks/village-green-park/ | 31237 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 3.557 | Village Green Park | |
12615 | 12615 | 12614 | {"type": "Polygon", "coordinates": [[[-121.23855, 38.54734], [-121.23856, 38.54816], [-121.23852, 38.54822], [-121.23846, 38.54824], [-121.23796, 38.54825], [-121.23749, 38.54829], [-121.23743, 38.54783], [-121.23743, 38.54772], [-121.23747, 38.54761], [-121.23758, 38.54748], [-121.23769, 38.54741], [-121.23786, 38.54735], [-121.23855, 38.54734]]]} | Open Access 1 | Eagle's Nest Park | http://crpd.com/parks/eagles-nest-park/ | 31309 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2.302 | Eagle's Nest Park | |
11183 | 11183 | 11182 | {"type": "MultiPolygon", "coordinates": [[[[-121.29841, 38.58552], [-121.29666, 38.58584], [-121.29633, 38.58587], [-121.29839, 38.58462], [-121.29841, 38.58552]]], [[[-121.30115, 38.58557], [-121.29851, 38.58552], [-121.29849, 38.58456], [-121.30105, 38.58302], [-121.30115, 38.58557]]]]} | Open Access 1 | White Rock Community Park | 27464 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 13.268 | White Rock Community 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 | ||
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 | ||
10517 | 10517 | 10516 | {"type": "Polygon", "coordinates": [[[-121.27262, 38.57888], [-121.27196, 38.5792], [-121.27192, 38.57926], [-121.27187, 38.57926], [-121.2718, 38.57928], [-121.27177, 38.57931], [-121.27175, 38.57935], [-121.27179, 38.57945], [-121.27177, 38.57948], [-121.27141, 38.57948], [-121.27113, 38.57944], [-121.27067, 38.5791], [-121.27083, 38.57873], [-121.27097, 38.5785], [-121.27117, 38.57828], [-121.27147, 38.57807], [-121.27173, 38.57793], [-121.27184, 38.57795], [-121.27254, 38.57879], [-121.27262, 38.57888]]]} | Open Access 1 | Tuscany Park | 26602 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 4.231 | Tuscany 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 | ||
10114 | 10114 | 10113 | {"type": "Polygon", "coordinates": [[[-121.27362, 38.62465], [-121.27342, 38.62538], [-121.27319, 38.62557], [-121.27257, 38.6255], [-121.27255, 38.62542], [-121.27248, 38.62539], [-121.27236, 38.62537], [-121.27202, 38.62528], [-121.27142, 38.62517], [-121.27139, 38.62515], [-121.27137, 38.62512], [-121.27158, 38.62476], [-121.27176, 38.62438], [-121.2719, 38.62418], [-121.27225, 38.62432], [-121.27362, 38.62465]]]} | Open Access 1 | Sunriver Park | 26040 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 4.642 | Sunriver Park | ||
9984 | 9984 | 9983 | {"type": "Polygon", "coordinates": [[[-121.27946, 38.56943], [-121.27965, 38.57223], [-121.27964, 38.57254], [-121.2796, 38.5728], [-121.27953, 38.57311], [-121.27937, 38.57356], [-121.27924, 38.57381], [-121.27911, 38.57404], [-121.27879, 38.57446], [-121.27841, 38.57486], [-121.27808, 38.57513], [-121.27759, 38.57548], [-121.27753, 38.57543], [-121.27753, 38.57538], [-121.27811, 38.57495], [-121.27853, 38.57456], [-121.27876, 38.5743], [-121.27887, 38.57416], [-121.27892, 38.57406], [-121.27893, 38.57391], [-121.27884, 38.57376], [-121.27876, 38.5737], [-121.27853, 38.5736], [-121.27834, 38.57347], [-121.2782, 38.57336], [-121.27803, 38.57319], [-121.27777, 38.57299], [-121.27764, 38.57284], [-121.27755, 38.57271], [-121.27748, 38.57253], [-121.27735, 38.57233], [-121.27725, 38.57224], [-121.27684, 38.57206], [-121.2766, 38.57191], [-121.27636, 38.57171], [-121.27627, 38.57158], [-121.27624, 38.57148], [-121.27624, 38.57138], [-121.2764, 38.57113], [-121.27681, 38.57088], [-121.27771, 38.57061], [-121.27837, 38.57058], [-121.27886, 38.57065], [-121.27918, 38.57078], [-121.27922, 38.57078], [-121.27933, 38.57076], [-121.27941, 38.57071], [-121.27945, 38.57062], [-121.27938, 38.56947], [-121.27946, 38.56943]]]} | Open Access 1 | Stone Creek Community Park | 25867 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 18.334 | Stone Creek Community 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 | ||
9128 | 9128 | 9127 | {"type": "MultiPolygon", "coordinates": [[[[-121.37216, 38.55979], [-121.37215, 38.56051], [-121.37168, 38.56054], [-121.3715, 38.55986], [-121.37216, 38.55979]]], [[[-121.37215, 38.56066], [-121.37213, 38.56155], [-121.37195, 38.56158], [-121.37172, 38.56069], [-121.37215, 38.56066]]]]} | Open Access 1 | Salmon Falls Park | https://crpd.com/parks/salmon-falls-park/ | 24807 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 1.627 | Salmon Falls 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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 |
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]);