units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
46 rows where DES_TP = 2 and MNG_AGENCY = 441 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 46
MNG_AGENCY 1
- Napa, City of · 46 ✖
DES_TP 1
- Local Park · 46 ✖
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13774 | 13774 | 13773 | {"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 | 36318 | 9/11 Memorial Garden | 30016 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.071 | 9/11 Memorial Garden | 0 | Local Park 2 | 4 | |
13761 | 13761 | 13760 | {"type": "Polygon", "coordinates": [[[-122.29458, 38.30493], [-122.29454, 38.30498], [-122.29445, 38.305], [-122.29438, 38.30471], [-122.29435, 38.3047], [-122.29436, 38.30468], [-122.29451, 38.30474], [-122.29458, 38.30493]]]} | Open Access 1 | 36281 | Jefferson Park | 28694 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.087 | Jefferson Park | 0 | Local Park 2 | 4 | |
13958 | 13958 | 13957 | {"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 | 36600 | Tallac Park | 30019 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.144 | Tallac Park | 0 | Local Park 2 | 4 | |
13993 | 13993 | 13992 | {"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 | 36675 | Norfolk Park | 28719 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.163 | Norfolk Park | 0 | Local Park 2 | 4 | |
9516 | 9516 | 9515 | {"type": "Polygon", "coordinates": [[[-122.28661, 38.29915], [-122.28655, 38.29918], [-122.28646, 38.29908], [-122.28628, 38.29916], [-122.28622, 38.29909], [-122.28624, 38.29907], [-122.28614, 38.29895], [-122.28636, 38.29883], [-122.28661, 38.29915]]]} | Open Access 1 | 15968 | Dwight Murray Plaza | 30020 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.186 | Dwight Murray Plaza | 2009 | Local Park 2 | 4 | |
8838 | 8838 | 8837 | {"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 | 14442 | Evans Park | 18755 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.373 | Evans Park | 1999 | Local Park 2 | 4 | |
13800 | 13800 | 13799 | {"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.30246], [-122.28538, 38.30275], [-122.28537, 38.30289], [-122.28539, 38.30299], [-122.28543, 38.30302], [-122.28548, 38.30302], [-122.28559, 38.30298]]]} | Open Access 1 | 36368 | Solomon Grove | 30032 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.52 | Solomon Grove | 0 | Local Park 2 | 4 | |
8851 | 8851 | 8850 | {"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 | 14469 | Harkness Park | 19682 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.571 | Harkness Park | 0 | Local Park 2 | 4 | |
3530 | 3530 | 3529 | {"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 | 36316 | North Jefferson Park | 28695 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.602 | North Jefferson Park | 0 | Local Park 2 | 4 | |
15425 | 15425 | 15424 | {"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.28493, 38.29958], [-122.2851, 38.2995], [-122.28551, 38.30003]]]} | Open Access 1 | 46688 | Opera House Plaza | 30024 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.667 | Opera House Plaza | 0 | Local Park 2 | 4 | |
8864 | 8864 | 8863 | {"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 | 14491 | Knolls Park | 20700 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.792 | Knolls Park | 0 | Local Park 2 | 4 | |
8853 | 8853 | 8852 | {"type": "Polygon", "coordinates": [[[-122.28477, 38.29847], [-122.28441, 38.29865], [-122.28437, 38.29864], [-122.28405, 38.29844], [-122.28395, 38.2983], [-122.28396, 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 | 14474 | Veteran's Memorial Park | 27014 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.821 | Veteran's Memorial Park | 0 | Local Park 2 | 4 | |
8848 | 8848 | 8847 | {"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 | 14459 | Monarch Park | 22367 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.354 | Monarch Park | 0 | Local Park 2 | 4 | |
8870 | 8870 | 8869 | {"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 | 14496 | Kensington Park | 20614 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.374 | Kensington Park | 0 | Local Park 2 | 4 | |
8846 | 8846 | 8845 | {"type": "Polygon", "coordinates": [[[-122.31577, 38.3453], [-122.31548, 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.34505], [-122.31493, 38.34473], [-122.31527, 38.34518], [-122.31557, 38.34504], [-122.31577, 38.3453]]]} | Open Access 1 | 14456 | Summerfield Park | 25958 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.515 | Summerfield Park | 0 | Local Park 2 | 4 | |
8845 | 8845 | 8844 | {"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.30686, 38.33516], [-122.30681, 38.33478], [-122.30698, 38.33469], [-122.30756, 38.33544]]]} | Open Access 1 | 14454 | Solomon Park | 25600 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.752 | Solomon Park | 0 | Local Park 2 | 4 | |
8856 | 8856 | 8855 | {"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 | 14480 | Kiwanis Park | 20683 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.783 | Kiwanis Park | 1975 | Local Park 2 | 4 | |
8839 | 8839 | 8838 | {"type": "Polygon", "coordinates": [[[-122.27391, 38.30843], [-122.27275, 38.30852], [-122.27267, 38.30793], [-122.2728, 38.30789], [-122.27286, 38.30783], [-122.27384, 38.30776], [-122.27391, 38.30843]]]} | Open Access 1 | 14445 | Esther Deaver Park | 30021 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.89 | Esther Deaver Park | 0 | Local Park 2 | 4 | |
8869 | 8869 | 8868 | {"type": "Polygon", "coordinates": [[[-122.33053, 38.3066], [-122.32907, 38.3065], [-122.32912, 38.30616], [-122.32947, 38.3057], [-122.32974, 38.30576], [-122.33, 38.3059], [-122.33022, 38.30611], [-122.33039, 38.30631], [-122.33053, 38.3066]]]} | Open Access 1 | 14495 | Valley Park | 26798 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.989 | Valley Park | 1967 | Local Park 2 | 4 | |
13962 | 13962 | 13961 | {"type": "Polygon", "coordinates": [[[-122.26703, 38.29781], [-122.26696, 38.29802], [-122.26676, 38.29798], [-122.26667, 38.29805], [-122.26653, 38.29802], [-122.26644, 38.29812], [-122.26642, 38.29821], [-122.26621, 38.29835], [-122.26576, 38.29831], [-122.26553, 38.29825], [-122.26592, 38.29724], [-122.26623, 38.29734], [-122.26628, 38.2974], [-122.26631, 38.29747], [-122.26637, 38.29753], [-122.26643, 38.29755], [-122.2665, 38.29754], [-122.26673, 38.29762], [-122.26681, 38.29777], [-122.26703, 38.29781]]]} | No Public Access 3 | 36606 | Hidden Glen Park | 30022 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.182 | Hidden Glen Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);