units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where MNG_AGENCY = 441 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST, GAP_STS
DES_TP 13
- Local Park 46
- Local Other or Unknown 21
- Local Recreation Area 4
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 81
MNG_AGENCY 1
- Napa, City of · 81 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15662 | 15662 | 15661 | {"type": "Polygon", "coordinates": [[[-122.28084, 38.26895], [-122.2782, 38.26902], [-122.27678, 38.2671], [-122.2763, 38.26736], [-122.27697, 38.26817], [-122.27675, 38.26949], [-122.27213, 38.27026], [-122.2719, 38.2693], [-122.27173, 38.26867], [-122.27151, 38.26765], [-122.27138, 38.26693], [-122.27119, 38.26559], [-122.27113, 38.26497], [-122.27106, 38.26416], [-122.27105, 38.26351], [-122.27168, 38.26331], [-122.27332, 38.2629], [-122.27458, 38.26299], [-122.2765, 38.26337], [-122.27675, 38.2632], [-122.27694, 38.26317], [-122.27776, 38.26348], [-122.27804, 38.26325], [-122.27815, 38.26282], [-122.27845, 38.26244], [-122.27855, 38.26202], [-122.2785, 38.26124], [-122.2787, 38.26096], [-122.27943, 38.26047], [-122.28056, 38.25989], [-122.28082, 38.2597], [-122.28084, 38.26895]]]} | Restricted Access 2 | 48419 | Napa Golf Course | 33054 | 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 | https://www.playnapa.com/ | Napa 11 | 155.995 | Napa GC | 1958 | Local Recreation Area 3 | 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 | |
14187 | 14187 | 14186 | {"type": "Polygon", "coordinates": [[[-122.34889, 38.32547], [-122.33942, 38.3285], [-122.33807, 38.32891], [-122.33607, 38.32689], [-122.3329, 38.32359], [-122.33245, 38.32311], [-122.33246, 38.32308], [-122.33217, 38.32281], [-122.33124, 38.32185], [-122.33674, 38.31863], [-122.33733, 38.31927], [-122.33932, 38.3214], [-122.33705, 38.32272], [-122.33922, 38.32563], [-122.34192, 38.32412], [-122.34274, 38.32412], [-122.34351, 38.32445], [-122.34406, 38.32413], [-122.34472, 38.32498], [-122.34857, 38.32273], [-122.34863, 38.32283], [-122.3486, 38.32316], [-122.34858, 38.32325], [-122.34819, 38.32387], [-122.34809, 38.32428], [-122.34811, 38.32446], [-122.34822, 38.32468], [-122.34857, 38.32514], [-122.3488, 38.32536], [-122.34889, 38.32547]]]} | Open Access 1 | 44005 | Alston Park | 15410 | 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 | 160.322 | Alston 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 | |
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 | ||
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 | ||
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 | ||
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 | ||
15460 | 15460 | 15459 | {"type": "Polygon", "coordinates": [[[-122.28949, 38.30081], [-122.28933, 38.30084], [-122.28919, 38.30061], [-122.28941, 38.3005], [-122.28949, 38.30081]]]} | Open Access 1 | 36613 | 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.14 | 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 | ||
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 | ||
13963 | 13963 | 13962 | {"type": "MultiPolygon", "coordinates": [[[[-122.28468, 38.29955], [-122.28458, 38.2996], [-122.28455, 38.29959], [-122.28358, 38.30006], [-122.2835, 38.30004], [-122.28335, 38.29981], [-122.28331, 38.29978], [-122.28324, 38.29967], [-122.28328, 38.29968], [-122.28359, 38.29964], [-122.28379, 38.29958], [-122.28401, 38.29956], [-122.28408, 38.29952], [-122.28422, 38.2994], [-122.28428, 38.29931], [-122.28441, 38.29899], [-122.28446, 38.29901], [-122.2845, 38.29909], [-122.2845, 38.29919], [-122.28455, 38.29928], [-122.28456, 38.29935], [-122.28468, 38.29955]]], [[[-122.28501, 38.30032], [-122.28431, 38.30067], [-122.28388, 38.30011], [-122.28435, 38.29987], [-122.28445, 38.29987], [-122.28462, 38.30008], [-122.2847, 38.30016], [-122.28481, 38.30023], [-122.28501, 38.30032]]], [[[-122.28411, 38.30078], [-122.28403, 38.30082], [-122.28367, 38.30027], [-122.28367, 38.30022], [-122.28411, 38.30078]]], [[[-122.28538, 38.30072], [-122.28464, 38.30109], [-122.28441, 38.30081], [-122.28516, 38.30044], [-122.28538, 38.30072]]], [[[-122.28469, 38.30147], [-122.28457, 38.30153], [-122.28453, 38.30153], [-122.28449, 38.30151], [-122.28413, 38.30097], [-122.28425, 38.30091], [-122.28469, 38.30147]]], [[[-122.28469, 38.30262], [-122.28466, 38.30264], [-122.28454, 38.30251], [-122.28341, 38.30111], [-122.2837, 38.30098], [-122.28448, 38.30217], [-122.28469, 38.30262]]]]} | Open Access 1 | 36610 | Oxbow Commons | 30025 | 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.265 | Oxbow Commons | 0 | None 1194 | ||
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 | |
4663 | 4663 | 4662 | {"type": "Polygon", "coordinates": [[[-122.31677, 38.29327], [-122.31482, 38.29396], [-122.31422, 38.29403], [-122.31412, 38.29363], [-122.31425, 38.29329], [-122.31436, 38.29316], [-122.3144, 38.29308], [-122.3144, 38.29298], [-122.31651, 38.29297], [-122.31651, 38.29326], [-122.31677, 38.29327]]]} | Open Access 1 | 36605 | 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 | 4.243 | 0 | Local Other or Unknown 14 | 4 | ||
13961 | 13961 | 13960 | {"type": "Polygon", "coordinates": [[[-122.29798, 38.33067], [-122.2977, 38.3306], [-122.29733, 38.3304], [-122.29739, 38.33037], [-122.29739, 38.33035], [-122.2971, 38.33019], [-122.29687, 38.33011], [-122.29654, 38.33007], [-122.29575, 38.33011], [-122.29559, 38.33009], [-122.29548, 38.33006], [-122.29536, 38.33], [-122.29524, 38.32991], [-122.29512, 38.32975], [-122.29513, 38.32973], [-122.29505, 38.32962], [-122.29489, 38.32949], [-122.29512, 38.32911], [-122.29524, 38.3297], [-122.29541, 38.32982], [-122.29557, 38.3298], [-122.29556, 38.32988], [-122.29561, 38.32994], [-122.29571, 38.32996], [-122.29584, 38.32991], [-122.29655, 38.32983], [-122.29684, 38.32984], [-122.29713, 38.32989], [-122.29742, 38.33002], [-122.29773, 38.33028], [-122.29771, 38.33032], [-122.29798, 38.33067]]]} | Open Access 1 | 36604 | Silverado Creek Maintenance District | 30031 | 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.919 | Silverado Creek Maintenance District | None 1193 | |||
3570 | 3570 | 3569 | {"type": "Polygon", "coordinates": [[[-122.29827, 38.33084], [-122.29801, 38.33096], [-122.29792, 38.33085], [-122.29785, 38.33081], [-122.29739, 38.3307], [-122.2972, 38.33046], [-122.29733, 38.3304], [-122.29775, 38.33062], [-122.29795, 38.33066], [-122.29796, 38.33065], [-122.29814, 38.33067], [-122.29827, 38.33084]]]} | No Public Access 3 | 36603 | Silverado Creek Maintenance District | 30030 | 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.498 | Silverado Creek Maintenance District | None 299 | |||
13960 | 13960 | 13959 | {"type": "Polygon", "coordinates": [[[-122.29905, 38.32779], [-122.29848, 38.32836], [-122.29839, 38.32842], [-122.29828, 38.32846], [-122.29818, 38.32846], [-122.29777, 38.32842], [-122.29754, 38.32853], [-122.29772, 38.32878], [-122.29763, 38.32882], [-122.29773, 38.32895], [-122.29741, 38.32886], [-122.29693, 38.32878], [-122.29676, 38.32872], [-122.29662, 38.32864], [-122.2972, 38.3285], [-122.2977, 38.32826], [-122.29767, 38.3282], [-122.29787, 38.32817], [-122.29791, 38.32814], [-122.29796, 38.32817], [-122.29801, 38.32814], [-122.29814, 38.32821], [-122.29825, 38.3282], [-122.29829, 38.32816], [-122.29829, 38.32811], [-122.29869, 38.32773], [-122.29876, 38.32764], [-122.29889, 38.32758], [-122.29905, 38.32779]]]} | No Public Access 3 | 36602 | Silverado Creek Maintenance District | 30030 | 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.843 | Silverado Creek Maintenance District | None 1192 | |||
4662 | 4662 | 4661 | {"type": "Polygon", "coordinates": [[[-122.28082, 38.28098], [-122.27751, 38.28071], [-122.27753, 38.28051], [-122.28081, 38.28064], [-122.28082, 38.28098]]]} | Open Access 1 | 36601 | 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 | 2.159 | 0 | Local Other or Unknown 14 | 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 |
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]);