units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where LAYER = 2, MNG_AGENCY = 441 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |||
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 | |
4616 | 4616 | 4615 | {"type": "Polygon", "coordinates": [[[-122.25499, 38.35941], [-122.25411, 38.35979], [-122.25361, 38.35995], [-122.25326, 38.35997], [-122.25289, 38.3599], [-122.25265, 38.35979], [-122.25242, 38.35946], [-122.25248, 38.35927], [-122.25284, 38.35909], [-122.2538, 38.35892], [-122.2543, 38.35893], [-122.25499, 38.35941]]]} | No Public Access 3 | 35922 | 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 | 4.386 | 0 | Local Other or Unknown 14 | 4 | ||
4630 | 4630 | 4629 | {"type": "Polygon", "coordinates": [[[-122.22625, 38.22568], [-122.22229, 38.22571], [-122.22225, 38.22421], [-122.22224, 38.22254], [-122.22307, 38.22433], [-122.2237, 38.22472], [-122.2237, 38.22525], [-122.22475, 38.22524], [-122.22476, 38.22438], [-122.22452, 38.22437], [-122.22415, 38.22431], [-122.22384, 38.22431], [-122.22307, 38.22385], [-122.22241, 38.22243], [-122.22242, 38.22209], [-122.22261, 38.22185], [-122.22315, 38.22161], [-122.22316, 38.22152], [-122.22322, 38.22151], [-122.22325, 38.22127], [-122.22366, 38.2211], [-122.22393, 38.22126], [-122.22421, 38.22139], [-122.22447, 38.22149], [-122.2248, 38.22157], [-122.22525, 38.22163], [-122.2262, 38.22165], [-122.22625, 38.22568]]]} | No Public Access 3 | 36293 | 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 | 35.376 | 0 | Local Other or Unknown 14 | 4 | ||
4631 | 4631 | 4630 | {"type": "MultiPolygon", "coordinates": [[[[-122.34618, 38.30909], [-122.34596, 38.30934], [-122.34614, 38.30944], [-122.34597, 38.30955], [-122.34589, 38.30957], [-122.34581, 38.30954], [-122.34512, 38.30898], [-122.34519, 38.30876], [-122.34544, 38.30879], [-122.34534, 38.30904], [-122.34535, 38.30905], [-122.34567, 38.30906], [-122.34612, 38.30899], [-122.34618, 38.30909]]], [[[-122.3487, 38.31069], [-122.34864, 38.31088], [-122.34806, 38.31077], [-122.34714, 38.31048], [-122.34688, 38.31036], [-122.34665, 38.31022], [-122.34613, 38.30976], [-122.3461, 38.30972], [-122.34611, 38.30968], [-122.34617, 38.30961], [-122.34625, 38.30956], [-122.34634, 38.30965], [-122.34665, 38.30968], [-122.34674, 38.30993], [-122.34686, 38.31013], [-122.34726, 38.31024], [-122.3475, 38.31039], [-122.34763, 38.31031], [-122.34789, 38.31053], [-122.34805, 38.31036], [-122.34821, 38.31049], [-122.34838, 38.31044], [-122.34859, 38.31072], [-122.3487, 38.31069]]]]} | Open Access 1 | 36294 | 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.657 | 0 | Local Other or Unknown 14 | 4 | ||
4632 | 4632 | 4631 | {"type": "Polygon", "coordinates": [[[-122.27703, 38.31682], [-122.27674, 38.3171], [-122.27647, 38.31702], [-122.27594, 38.31695], [-122.27565, 38.31688], [-122.27558, 38.31653], [-122.27581, 38.31638], [-122.27597, 38.3162], [-122.27656, 38.31622], [-122.27679, 38.31615], [-122.27678, 38.31633], [-122.27683, 38.31652], [-122.27691, 38.31667], [-122.27703, 38.31682]]]} | Open Access 1 | 36315 | 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.219 | 0 | Local Other or Unknown 14 | 4 | ||
4633 | 4633 | 4632 | {"type": "Polygon", "coordinates": [[[-122.26376, 38.30317], [-122.26366, 38.30341], [-122.26313, 38.30317], [-122.26295, 38.30314], [-122.26275, 38.30314], [-122.26311, 38.30284], [-122.26376, 38.30317]]]} | No Public Access 3 | 36317 | 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.57 | 0 | Local Other or Unknown 14 | 4 | ||
4634 | 4634 | 4633 | {"type": "Polygon", "coordinates": [[[-122.27749, 38.30276], [-122.27737, 38.30283], [-122.27718, 38.30304], [-122.27707, 38.30306], [-122.27701, 38.30305], [-122.27692, 38.30298], [-122.27666, 38.3027], [-122.27686, 38.3028], [-122.27706, 38.30284], [-122.27729, 38.30283], [-122.27735, 38.30281], [-122.27736, 38.30279], [-122.27749, 38.30276]]]} | Open Access 1 | 36319 | 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.235 | 0 | Local Other or Unknown 14 | 4 | ||
4636 | 4636 | 4635 | {"type": "Polygon", "coordinates": [[[-122.34106, 38.30681], [-122.341, 38.30679], [-122.34093, 38.30667], [-122.34086, 38.30658], [-122.34045, 38.3062], [-122.34007, 38.30593], [-122.33968, 38.30568], [-122.33914, 38.3054], [-122.3391, 38.30534], [-122.33912, 38.30527], [-122.33923, 38.30535], [-122.33938, 38.3054], [-122.33952, 38.30542], [-122.33961, 38.30547], [-122.33966, 38.30552], [-122.3398, 38.30569], [-122.33993, 38.3058], [-122.34012, 38.30586], [-122.34049, 38.30593], [-122.34063, 38.30599], [-122.34068, 38.30605], [-122.34073, 38.30625], [-122.3408, 38.30635], [-122.34083, 38.30638], [-122.34091, 38.30639], [-122.34105, 38.30635], [-122.34106, 38.30681]]]} | Open Access 1 | 36336 | 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.856 | 0 | Local Other or Unknown 14 | 4 | ||
4637 | 4637 | 4636 | {"type": "Polygon", "coordinates": [[[-122.31969, 38.31537], [-122.31968, 38.3154], [-122.31965, 38.31542], [-122.31947, 38.31545], [-122.31931, 38.31498], [-122.31956, 38.31521], [-122.31969, 38.31537]]]} | Open Access 1 | 36337 | 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.169 | 0 | Local Other or Unknown 14 | 4 | ||
4638 | 4638 | 4637 | {"type": "Polygon", "coordinates": [[[-122.2977, 38.32825], [-122.2972, 38.3285], [-122.29663, 38.32864], [-122.29655, 38.32859], [-122.29758, 38.3281], [-122.2977, 38.32825]]]} | Open Access 1 | 36340 | 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.452 | 0 | Local Other or Unknown 14 | 4 | ||
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 | ||
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 | ||
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 |
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]);