units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where AGNCY_LEV = 2 and MNG_AGENCY = 441 sorted by YR_EST
This data as json, copyable, CSV (advanced)
DES_TP 7
- Local Park 43
- Local Other or Unknown 10
- Local Recreation Area 4
- Local Conservation Area 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 61
MNG_AGENCY 1
- Napa, City of · 61 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4665 | 4665 | 4664 | {"type": "Polygon", "coordinates": [[[-122.28966, 38.30079], [-122.28949, 38.30081], [-122.28941, 38.30051], [-122.28952, 38.30046], [-122.28962, 38.30044], [-122.28966, 38.30079]]]} | Open Access 1 | 36611 | Unnamed site - Napa, City of | 28646 | 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.157 | 0 | Local Other or Unknown 14 | 4 | ||
4666 | 4666 | 4665 | {"type": "Polygon", "coordinates": [[[-122.28917, 38.3009], [-122.28907, 38.30095], [-122.28902, 38.30095], [-122.28885, 38.30075], [-122.28901, 38.30069], [-122.28917, 38.3009]]]} | Open Access 1 | 36612 | Unnamed site - Napa, City of | 28646 | 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.105 | 0 | Local Other or Unknown 14 | 4 | ||
4667 | 4667 | 4666 | {"type": "Polygon", "coordinates": [[[-122.26819, 38.3106], [-122.26761, 38.3104], [-122.26755, 38.31017], [-122.26748, 38.31002], [-122.26773, 38.30992], [-122.26819, 38.3106]]]} | No Public Access 3 | 36614 | Unnamed site - Napa, City of | 28645 | 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.487 | 0 | Local Other or Unknown 14 | 4 | ||
4668 | 4668 | 4667 | {"type": "MultiPolygon", "coordinates": [[[[-122.28563, 38.32175], [-122.28561, 38.32179], [-122.28539, 38.32195], [-122.28528, 38.32197], [-122.28528, 38.32154], [-122.28548, 38.3215], [-122.28563, 38.3217], [-122.28563, 38.32175]]], [[[-122.28633, 38.32236], [-122.2863, 38.32236], [-122.28528, 38.32252], [-122.28528, 38.3224], [-122.28534, 38.32223], [-122.2854, 38.32215], [-122.28547, 38.32206], [-122.28558, 38.32197], [-122.28568, 38.32191], [-122.28575, 38.3219], [-122.2858, 38.3219], [-122.28614, 38.32221], [-122.28633, 38.32236]]], [[[-122.28707, 38.32222], [-122.28659, 38.32231], [-122.28628, 38.32208], [-122.2861, 38.32192], [-122.28591, 38.32174], [-122.2857, 38.32146], [-122.28679, 38.32126], [-122.28707, 38.32222]]]]} | Open Access 1 | 36617 | Unnamed site - Napa, City of | 28646 | 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 | 3.179 | 0 | Local Other or Unknown 14 | 4 | ||
4669 | 4669 | 4668 | {"type": "Polygon", "coordinates": [[[-122.34815, 38.318], [-122.34756, 38.31831], [-122.34706, 38.31768], [-122.34742, 38.31748], [-122.34791, 38.31776], [-122.34815, 38.318]]]} | No Public Access 3 | 36618 | Unnamed site - Napa, City of | 28645 | 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.089 | 0 | Local Other or Unknown 14 | 4 | ||
4672 | 4672 | 4671 | {"type": "Polygon", "coordinates": [[[-122.34393, 38.31701], [-122.34317, 38.31651], [-122.34302, 38.31644], [-122.34282, 38.31622], [-122.343, 38.31604], [-122.34304, 38.31589], [-122.34292, 38.31573], [-122.34268, 38.31564], [-122.34243, 38.31559], [-122.34204, 38.31569], [-122.34134, 38.31566], [-122.34134, 38.31545], [-122.3427, 38.31551], [-122.34283, 38.31553], [-122.34294, 38.31558], [-122.34305, 38.31567], [-122.34311, 38.31575], [-122.34319, 38.31614], [-122.34327, 38.31631], [-122.34337, 38.31643], [-122.34367, 38.31671], [-122.34393, 38.31701]]]} | No Public Access 3 | 36636 | Unnamed site - Napa, City of | 28645 | 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.35 | 0 | Local Other or Unknown 14 | 4 | ||
4854 | 4854 | 4853 | {"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 | 36620 | Unknown park - Napa, City of | 28648 | 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.139 | 0 | Local Other or Unknown 14 | 4 | ||
8828 | 8828 | 8827 | {"type": "Polygon", "coordinates": [[[-122.26654, 38.28835], [-122.26638, 38.28844], [-122.26616, 38.28822], [-122.26584, 38.2884], [-122.26573, 38.2884], [-122.26572, 38.28764], [-122.26506, 38.28772], [-122.26494, 38.28755], [-122.2647, 38.28736], [-122.264, 38.28697], [-122.26383, 38.28674], [-122.26425, 38.287], [-122.2645, 38.28684], [-122.26502, 38.28692], [-122.26531, 38.28685], [-122.2656, 38.28653], [-122.26569, 38.28634], [-122.26584, 38.28622], [-122.26595, 38.28616], [-122.26606, 38.28692], [-122.26629, 38.28807], [-122.26654, 38.28835]]]} | Open Access 1 | 14431 | Camille Park | 16764 | 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 | 4.705 | Camille Park | 0 | Local Park 2 | 4 | |
8837 | 8837 | 8836 | {"type": "Polygon", "coordinates": [[[-122.27159, 38.29621], [-122.27154, 38.29711], [-122.2696, 38.29713], [-122.26959, 38.29698], [-122.27, 38.29696], [-122.27, 38.29621], [-122.27159, 38.29621]]]} | Open Access 1 | 14439 | Fairview Park | 18817 | 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 | 3.55 | Fairview Park | 0 | 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 | |
8840 | 8840 | 8839 | {"type": "Polygon", "coordinates": [[[-122.28199, 38.31364], [-122.28202, 38.31525], [-122.28198, 38.31563], [-122.28177, 38.31633], [-122.28142, 38.31622], [-122.28128, 38.31644], [-122.28107, 38.31666], [-122.28094, 38.31652], [-122.28066, 38.31669], [-122.28058, 38.3166], [-122.28085, 38.31645], [-122.28086, 38.31644], [-122.28057, 38.31613], [-122.28023, 38.31604], [-122.28124, 38.3136], [-122.28146, 38.31365], [-122.28199, 38.31364]]]} | Open Access 1 | 14447 | Lake Park | 20961 | 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 | 8.387 | Lake Park | 0 | Local Park 2 | 4 | |
8842 | 8842 | 8841 | {"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.31622], [-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 | 14449 | O'Brien Park | 22944 | 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 | 8.158 | O'Brien Park | 0 | Local Park 2 | 4 | |
8843 | 8843 | 8842 | {"type": "Polygon", "coordinates": [[[-122.30257, 38.33174], [-122.30009, 38.33299], [-122.29868, 38.33123], [-122.29887, 38.33115], [-122.29897, 38.33107], [-122.29953, 38.33077], [-122.29956, 38.33079], [-122.29991, 38.33061], [-122.30058, 38.33052], [-122.30079, 38.33048], [-122.3009, 38.33044], [-122.30104, 38.33034], [-122.30124, 38.33028], [-122.30135, 38.33029], [-122.30139, 38.33028], [-122.30257, 38.33174]]]} | Open Access 1 | 14452 | Garfield Park | 19218 | 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 | 14.0 | Garfield 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 | |
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 | |
8847 | 8847 | 8846 | {"type": "Polygon", "coordinates": [[[-122.32012, 38.34718], [-122.31998, 38.34767], [-122.3189, 38.34802], [-122.31854, 38.34744], [-122.31913, 38.34727], [-122.31934, 38.3469], [-122.31996, 38.34714], [-122.32012, 38.34718]]]} | Open Access 1 | 14457 | Springfield Park | 25747 | 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.349 | Springfield 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 | |
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 | |
8852 | 8852 | 8851 | {"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 | 14472 | Napa Skate Park | 22633 | 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.257 | Napa Skate Park | 0 | Local Recreation Area 3 | 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 |
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]);