superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
62 rows where MNG_AGENCY = 441 and MNG_AG_TYP = 2 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12810 | 12810 | 12809 | {"type": "Polygon", "coordinates": [[[-122.28658, 38.29983], [-122.28636, 38.29994], [-122.28629, 38.29985], [-122.28651, 38.29973], [-122.28658, 38.29983]]]} | Open Access 1 | 9/11 Memorial Garden | 30016 | 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.071 | 9/11 Memorial Garden | ||
11916 | 11916 | 11915 | {"type": "Polygon", "coordinates": [[[-122.29458, 38.30493], [-122.29454, 38.30498], [-122.29445, 38.305], [-122.29438, 38.30472], [-122.29435, 38.3047], [-122.29436, 38.30468], [-122.29451, 38.30474], [-122.29458, 38.30493]]]} | Open Access 1 | Jefferson Park | 28694 | 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.087 | Jefferson Park | ||
11387 | 11387 | 11386 | {"type": "Polygon", "coordinates": [[[-122.28933, 38.30084], [-122.28917, 38.3009], [-122.28901, 38.30069], [-122.28919, 38.30061], [-122.28933, 38.30084]]]} | Open Access 1 | Open Space - Napa, City of | 30027 | 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.117 | OS - Napa, City of | ||
12817 | 12817 | 12816 | {"type": "Polygon", "coordinates": [[[-122.31129, 38.33053], [-122.31128, 38.33057], [-122.31125, 38.3306], [-122.3111, 38.33063], [-122.31102, 38.33039], [-122.31124, 38.33035], [-122.31129, 38.33053]]]} | Open Access 1 | Sequoia Tot Lot | 30029 | 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.125 | Sequoia Tot Lot | ||
11880 | 11880 | 11879 | {"type": "Polygon", "coordinates": [[[-122.30454, 38.32522], [-122.30452, 38.32526], [-122.30436, 38.32541], [-122.30419, 38.32528], [-122.3044, 38.3251], [-122.30452, 38.32519], [-122.30454, 38.32522]]]} | Open Access 1 | Beckworth Tot Lot | 28574 | 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.134 | Beckworth Tot Lot | ||
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 | |||
12811 | 12811 | 12810 | {"type": "Polygon", "coordinates": [[[-122.31222, 38.32659], [-122.31188, 38.32665], [-122.31184, 38.32664], [-122.31177, 38.32656], [-122.31206, 38.32641], [-122.31222, 38.32659]]]} | Open Access 1 | Tallac Park | 30019 | 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.144 | Tallac Park | ||
11926 | 11926 | 11925 | {"type": "Polygon", "coordinates": [[[-122.31937, 38.32331], [-122.31916, 38.32342], [-122.31896, 38.32319], [-122.31911, 38.3231], [-122.31917, 38.3231], [-122.3192, 38.32312], [-122.31937, 38.32331]]]} | Open Access 1 | Norfolk Park | 28719 | 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.162 | Norfolk Park | ||
12812 | 12812 | 12811 | {"type": "Polygon", "coordinates": [[[-122.28661, 38.29915], [-122.28655, 38.29918], [-122.28646, 38.29908], [-122.28628, 38.29916], [-122.28622, 38.29909], [-122.28623, 38.29906], [-122.28614, 38.29895], [-122.28636, 38.29883], [-122.28661, 38.29915]]]} | Open Access 1 | Dwight Murray Plaza | 30020 | 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.187 | Dwight Murray Plaza | 2009 | |
12789 | 12789 | 12788 | {"type": "Polygon", "coordinates": [[[-122.315, 38.30559], [-122.31509, 38.30591], [-122.31495, 38.30683], [-122.31487, 38.30684], [-122.31497, 38.30621], [-122.31491, 38.30619], [-122.315, 38.30559]]]} | Open Access 1 | Linda Vista Connection | 30023 | 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.271 | Linda Vista Connection | ||
4095 | 4095 | 4094 | {"type": "Polygon", "coordinates": [[[-122.27532, 38.3019], [-122.27529, 38.30218], [-122.27527, 38.30222], [-122.27509, 38.30234], [-122.27503, 38.30233], [-122.27496, 38.30228], [-122.27477, 38.30207], [-122.27525, 38.30186], [-122.27529, 38.30188], [-122.27532, 38.3019]]]} | Open Access 1 | Evans Park | 18755 | 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.373 | Evans Park | 1999 | |
11388 | 11388 | 11387 | {"type": "Polygon", "coordinates": [[[-122.28559, 38.30298], [-122.28546, 38.30304], [-122.28532, 38.30306], [-122.28526, 38.3031], [-122.28524, 38.30316], [-122.28527, 38.30322], [-122.28533, 38.30325], [-122.28542, 38.30325], [-122.2853, 38.30331], [-122.28527, 38.30341], [-122.28522, 38.30308], [-122.28511, 38.3027], [-122.28509, 38.30244], [-122.28536, 38.30231], [-122.28542, 38.30233], [-122.28556, 38.30244], [-122.2855, 38.30244], [-122.28546, 38.30247], [-122.28538, 38.30275], [-122.28537, 38.30289], [-122.28539, 38.30299], [-122.28542, 38.30302], [-122.28548, 38.30302], [-122.28559, 38.30298]]]} | Open Access 1 | Solomon Grove | 30032 | 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.521 | Solomon Grove | ||
4909 | 4909 | 4908 | {"type": "Polygon", "coordinates": [[[-122.31113, 38.32413], [-122.31088, 38.32426], [-122.31045, 38.32375], [-122.31018, 38.32352], [-122.31036, 38.32339], [-122.31113, 38.32413]]]} | Open Access 1 | Harkness Park | 19682 | 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.571 | Harkness Park | ||
11917 | 11917 | 11916 | {"type": "Polygon", "coordinates": [[[-122.3149, 38.33891], [-122.31472, 38.33897], [-122.31412, 38.33907], [-122.31397, 38.33883], [-122.31467, 38.3386], [-122.3149, 38.33891]]]} | Open Access 1 | North Jefferson Park | 28695 | 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.602 | North Jefferson Park | ||
12797 | 12797 | 12796 | {"type": "Polygon", "coordinates": [[[-122.28551, 38.30003], [-122.28537, 38.30004], [-122.2851, 38.30002], [-122.28483, 38.29997], [-122.28474, 38.29994], [-122.28466, 38.29988], [-122.28464, 38.29978], [-122.28466, 38.29969], [-122.28491, 38.29957], [-122.28494, 38.29958], [-122.2851, 38.2995], [-122.28551, 38.30003]]]} | Open Access 1 | Opera House Plaza | 30024 | 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.667 | Opera House Plaza | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);