units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where ACCESS_TYP = 1, AGNCY_NAME = 447 and DES_TP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, DES_TP
MNG_AGENCY 1
ACCESS_TYP 1
- Open Access · 44 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1885 | 1885 | 1884 | {"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.33166], [-122.32595, 38.33205], [-122.32547, 38.33244], [-122.32474, 38.33285], [-122.32463, 38.33273], [-122.32496, 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.3314], [-122.32493, 38.33124], [-122.32523, 38.33158], [-122.32523, 38.33164], [-122.32501, 38.33185], [-122.3249, 38.33198], [-122.32528, 38.33232], [-122.32614, 38.33146], [-122.32753, 38.33067], [-122.3277, 38.33086], [-122.32799, 38.33071], [-122.32856, 38.33136]]]} | Open Access 1 | 14502 | Las Flores Park | 21052 | 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.061 | Las Flores 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 | |
4290 | 4290 | 4289 | {"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.28447], [-122.26252, 38.2852], [-122.2626, 38.28545], [-122.26278, 38.28562]]]} | Open Access 1 | 14429 | Shurtleff Park | 25435 | 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.96 | Shurtleff Park | 0 | Local Park 2 | 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 | |
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 | |
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 | |
8850 | 8850 | 8849 | {"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 | 14466 | Klamath Park | 20685 | 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.352 | Klamath Park | 1972 | 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 | |
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 | |
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 | |
8857 | 8857 | 8856 | {"type": "Polygon", "coordinates": [[[-122.29405, 38.29278], [-122.2937, 38.29478], [-122.29168, 38.29456], [-122.292, 38.29273], [-122.29405, 38.29278]]]} | Open Access 1 | 14482 | Fuller Park | 19141 | 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 | 9.466 | Fuller Park | 1904 | Local Park 2 | 4 | |
8859 | 8859 | 8858 | {"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 | 14485 | Laurel Park | 21104 | 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.342 | Laurel Park | 1977 | 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]);