superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
55 rows where ACCESS_TYP = 1 and MNG_AGENCY = 441
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5713 | 5713 | 5712 | {"type": "Polygon", "coordinates": [[[-122.33, 38.30856], [-122.32952, 38.30883], [-122.32928, 38.30872], [-122.32914, 38.30862], [-122.32884, 38.30847], [-122.32883, 38.30838], [-122.32898, 38.3082], [-122.32944, 38.30793], [-122.33, 38.30856]]]} | Open Access 1 | Kensington Park | 20614 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1.373 | Kensington Park | ||
5737 | 5737 | 5736 | {"type": "Polygon", "coordinates": [[[-122.31686, 38.3307], [-122.31648, 38.33101], [-122.3164, 38.33098], [-122.31619, 38.3307], [-122.31612, 38.33066], [-122.31613, 38.33062], [-122.31599, 38.33046], [-122.3158, 38.33025], [-122.31567, 38.33021], [-122.31517, 38.32963], [-122.3157, 38.32936], [-122.31686, 38.3307]]]} | Open Access 1 | Klamath Park | 20685 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 2.352 | Klamath Park | 1972 | |
5745 | 5745 | 5744 | {"type": "Polygon", "coordinates": [[[-122.28792, 38.28849], [-122.28768, 38.28918], [-122.28666, 38.28895], [-122.2869, 38.28829], [-122.28792, 38.28849]]]} | Open Access 1 | Kiwanis Park | 20683 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1.783 | Kiwanis Park | 1975 | |
5765 | 5765 | 5764 | {"type": "Polygon", "coordinates": [[[-122.3475, 38.30378], [-122.34725, 38.30408], [-122.34718, 38.30457], [-122.34657, 38.30439], [-122.34691, 38.30399], [-122.34744, 38.30372], [-122.3475, 38.30378]]]} | Open Access 1 | Knolls Park | 20700 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 0.792 | Knolls Park | ||
5967 | 5967 | 5966 | {"type": "Polygon", "coordinates": [[[-122.27201, 38.303], [-122.27118, 38.30304], [-122.27055, 38.30297], [-122.26962, 38.30311], [-122.26944, 38.30347], [-122.26912, 38.30337], [-122.26875, 38.30347], [-122.26792, 38.30353], [-122.26743, 38.30335], [-122.26721, 38.30324], [-122.26705, 38.30307], [-122.26695, 38.30282], [-122.26695, 38.30261], [-122.26699, 38.30247], [-122.26712, 38.30227], [-122.26718, 38.30212], [-122.26722, 38.30186], [-122.26729, 38.30185], [-122.26729, 38.30182], [-122.26764, 38.30189], [-122.26764, 38.30192], [-122.26879, 38.30214], [-122.26957, 38.30274], [-122.2706, 38.30272], [-122.27152, 38.30276], [-122.27201, 38.30283], [-122.27201, 38.303]]]} | Open Access 1 | Lakeview Park | 20984 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 9.529 | Lakeview Park | ||
6019 | 6019 | 6018 | {"type": "Polygon", "coordinates": [[[-122.32856, 38.33136], [-122.32856, 38.3314], [-122.32852, 38.33143], [-122.32806, 38.3317], [-122.32787, 38.33177], [-122.32678, 38.33196], [-122.32661, 38.33167], [-122.32595, 38.33205], [-122.32547, 38.33244], [-122.32474, 38.33285], [-122.32463, 38.33273], [-122.32495, 38.33252], [-122.32458, 38.33221], [-122.3235, 38.33097], [-122.3236, 38.33092], [-122.32382, 38.33107], [-122.32453, 38.33125], [-122.32466, 38.33139], [-122.32493, 38.33124], [-122.32523, 38.33158], [-122.32523, 38.33164], [-122.32501, 38.33185], [-122.32491, 38.33199], [-122.32528, 38.33231], [-122.32614, 38.33146], [-122.32753, 38.33067], [-122.3277, 38.33086], [-122.32799, 38.33071], [-122.32856, 38.33136]]]} | Open Access 1 | Las Flores Park | 21052 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 8.08 | Las Flores Park | ||
6051 | 6051 | 6050 | {"type": "Polygon", "coordinates": [[[-122.31425, 38.29491], [-122.31317, 38.29529], [-122.31275, 38.29453], [-122.31383, 38.29416], [-122.31425, 38.29491]]]} | Open Access 1 | Laurel Park | 21104 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 2.341 | Laurel Park | 1977 | |
7106 | 7106 | 7105 | {"type": "Polygon", "coordinates": [[[-122.32152, 38.33806], [-122.32082, 38.33829], [-122.32043, 38.33793], [-122.32052, 38.33781], [-122.32057, 38.33769], [-122.32056, 38.3375], [-122.32101, 38.33742], [-122.32152, 38.33806]]]} | Open Access 1 | Monarch Park | 22367 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1.354 | Monarch Park | ||
7303 | 7303 | 7302 | {"type": "Polygon", "coordinates": [[[-122.28616, 38.30171], [-122.28549, 38.30204], [-122.28503, 38.3015], [-122.28572, 38.30116], [-122.28616, 38.30171]]]} | Open Access 1 | Napa Skate Park | 22633 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1.256 | Napa Skate Park | ||
7533 | 7533 | 7532 | {"type": "Polygon", "coordinates": [[[-122.29092, 38.31682], [-122.28943, 38.31708], [-122.28932, 38.31683], [-122.28898, 38.31663], [-122.28903, 38.31653], [-122.289, 38.31645], [-122.28888, 38.3164], [-122.2887, 38.31621], [-122.28839, 38.31603], [-122.28832, 38.31587], [-122.28859, 38.31558], [-122.28859, 38.31536], [-122.28862, 38.31525], [-122.28883, 38.31523], [-122.2892, 38.31529], [-122.29041, 38.31512], [-122.29092, 38.31682]]]} | Open Access 1 | O'Brien Park | 22944 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 8.159 | O'Brien Park | ||
9629 | 9629 | 9628 | {"type": "Polygon", "coordinates": [[[-122.26278, 38.28562], [-122.26276, 38.28579], [-122.26261, 38.28613], [-122.26192, 38.28607], [-122.26191, 38.28279], [-122.26229, 38.28278], [-122.26236, 38.28311], [-122.26242, 38.28319], [-122.2625, 38.28341], [-122.26252, 38.28403], [-122.26257, 38.28427], [-122.26252, 38.28448], [-122.26252, 38.2852], [-122.2626, 38.28545], [-122.26278, 38.28562]]]} | Open Access 1 | Shurtleff Park | 25435 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 4.96 | Shurtleff Park | ||
9760 | 9760 | 9759 | {"type": "Polygon", "coordinates": [[[-122.30756, 38.33544], [-122.30662, 38.33596], [-122.30648, 38.33577], [-122.30645, 38.33553], [-122.30649, 38.3353], [-122.3065, 38.33517], [-122.30668, 38.33518], [-122.30685, 38.33516], [-122.30681, 38.33478], [-122.30698, 38.33469], [-122.30756, 38.33544]]]} | Open Access 1 | Solomon Park | 25600 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1.755 | Solomon Park | ||
9873 | 9873 | 9872 | {"type": "Polygon", "coordinates": [[[-122.32012, 38.34718], [-122.31998, 38.34767], [-122.3189, 38.34802], [-122.31854, 38.34744], [-122.31913, 38.34726], [-122.31934, 38.3469], [-122.31996, 38.34714], [-122.32012, 38.34718]]]} | Open Access 1 | Springfield Park | 25747 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 2.35 | Springfield Park | ||
10053 | 10053 | 10052 | {"type": "Polygon", "coordinates": [[[-122.31577, 38.3453], [-122.31549, 38.34543], [-122.31552, 38.34551], [-122.31537, 38.34556], [-122.31517, 38.34548], [-122.31494, 38.34546], [-122.31473, 38.34566], [-122.31463, 38.34562], [-122.31449, 38.34555], [-122.31431, 38.34539], [-122.31459, 38.34525], [-122.3145, 38.34511], [-122.31461, 38.34504], [-122.31493, 38.34473], [-122.31527, 38.34517], [-122.31557, 38.34504], [-122.31577, 38.3453]]]} | Open Access 1 | Summerfield Park | 25958 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1.52 | Summerfield Park | ||
10147 | 10147 | 10146 | {"type": "Polygon", "coordinates": [[[-122.32162, 38.31524], [-122.31999, 38.31553], [-122.31989, 38.31532], [-122.3197, 38.31512], [-122.31949, 38.31494], [-122.32142, 38.31459], [-122.32162, 38.31524]]]} | Open Access 1 | Sutherland Park | 26081 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 2.856 | Sutherland Park | ||
10305 | 10305 | 10304 | {"type": "Polygon", "coordinates": [[[-122.29703, 38.32248], [-122.29673, 38.32253], [-122.29668, 38.3225], [-122.29665, 38.32238], [-122.29698, 38.32231], [-122.29703, 38.32248]]]} | Open Access 1 | Unknown park - Napa, City of | 28648 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 0.139 | |||
10367 | 10367 | 10366 | {"type": "Polygon", "coordinates": [[[-122.35256, 38.30267], [-122.35256, 38.30309], [-122.35243, 38.30311], [-122.35241, 38.30324], [-122.352, 38.30336], [-122.35131, 38.30326], [-122.35116, 38.30326], [-122.35036, 38.30355], [-122.3502, 38.30354], [-122.35002, 38.30343], [-122.34981, 38.30363], [-122.34967, 38.3037], [-122.34938, 38.30378], [-122.34928, 38.30375], [-122.34926, 38.3038], [-122.34877, 38.30371], [-122.34864, 38.30365], [-122.34856, 38.30368], [-122.34808, 38.30347], [-122.34813, 38.30339], [-122.34826, 38.30346], [-122.34842, 38.30351], [-122.34861, 38.30356], [-122.34899, 38.30361], [-122.34922, 38.30359], [-122.34936, 38.30355], [-122.34951, 38.30348], [-122.34966, 38.30338], [-122.34959, 38.30328], [-122.35043, 38.30295], [-122.35022, 38.3025], [-122.35128, 38.30192], [-122.35075, 38.3014], [-122.34988, 38.30078], [-122.34892, 38.30023], [-122.34864, 38.30025], [-122.34876, 38.30005], [-122.35003, 38.29971], [-122.35073, 38.29969], [-122.35189, 38.29978], [-122.35178, 38.30006], [-122.35058, 38.3005], [-122.35256, 38.30267]]]} | Open Access 1 | Timber Hill Park | 26368 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 14.727 | Timber Hill Park | 1977 | |
10443 | 10443 | 10442 | {"type": "Polygon", "coordinates": [[[-122.28639, 38.32781], [-122.28618, 38.32824], [-122.28595, 38.32833], [-122.2858, 38.32854], [-122.28586, 38.32868], [-122.28573, 38.32876], [-122.28578, 38.32889], [-122.28586, 38.32893], [-122.28611, 38.32952], [-122.28229, 38.33143], [-122.28223, 38.33134], [-122.28218, 38.33116], [-122.28212, 38.33104], [-122.28205, 38.33067], [-122.28208, 38.33057], [-122.28221, 38.33029], [-122.28238, 38.3301], [-122.28274, 38.32963], [-122.283, 38.32938], [-122.28354, 38.32941], [-122.28357, 38.32905], [-122.28346, 38.32846], [-122.28339, 38.32831], [-122.28311, 38.32801], [-122.28299, 38.32725], [-122.28348, 38.32666], [-122.28421, 38.32623], [-122.28441, 38.32579], [-122.28415, 38.32526], [-122.28519, 38.32529], [-122.28526, 38.32547], [-122.28543, 38.32545], [-122.28553, 38.32616], [-122.28524, 38.32618], [-122.28523, 38.3262], [-122.28639, 38.32781]]]} | Open Access 1 | Trancas Crossing Park | 26513 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 31.555 | Trancas Crossing Park | ||
10629 | 10629 | 10628 | {"type": "Polygon", "coordinates": [[[-122.33053, 38.3066], [-122.32907, 38.3065], [-122.32912, 38.30616], [-122.32947, 38.3057], [-122.32973, 38.30576], [-122.33, 38.3059], [-122.33022, 38.30611], [-122.33039, 38.30631], [-122.33053, 38.3066]]]} | Open Access 1 | Valley Park | 26798 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1.989 | Valley Park | 1967 | |
10801 | 10801 | 10800 | {"type": "Polygon", "coordinates": [[[-122.28477, 38.29847], [-122.28441, 38.29865], [-122.28437, 38.29864], [-122.28405, 38.29844], [-122.28395, 38.2983], [-122.28395, 38.29826], [-122.28391, 38.29818], [-122.28392, 38.29812], [-122.28399, 38.2981], [-122.28411, 38.2982], [-122.28412, 38.29818], [-122.28403, 38.29809], [-122.28434, 38.29793], [-122.28477, 38.29847]]]} | Open Access 1 | Veteran's Memorial Park | 27014 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 0.822 | Veteran's Memorial 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]);