units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where COUNTY = 11 and DES_TP = 3
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4190 | 4190 | 4189 | {"type": "Polygon", "coordinates": [[[-122.35797, 38.40288], [-122.35774, 38.40299], [-122.35757, 38.40277], [-122.3578, 38.40266], [-122.35797, 38.40288]]]} | Open Access 1 | 47670 | Toyon Terrace Tot Lot | 31411 | 1385 | Yountville, Town of 730 | City 2 | City Agency 2 | http://www.townofyountville.com/index.aspx?page=88 | City 2 | 1385 | Yountville, Town of 714 | City 2 | City Agency 2 | Napa 11 | 0.162 | Toyon Terrace Tot Lot | 0 | Local Recreation Area 3 | 4 | |
4971 | 4971 | 4970 | {"type": "Polygon", "coordinates": [[[-122.35826, 38.40168], [-122.35771, 38.40194], [-122.35772, 38.40192], [-122.35789, 38.40181], [-122.35791, 38.40175], [-122.35791, 38.40161], [-122.35758, 38.40073], [-122.35754, 38.40064], [-122.35743, 38.40059], [-122.35742, 38.40056], [-122.35744, 38.40052], [-122.3576, 38.40039], [-122.35773, 38.40025], [-122.35782, 38.40071], [-122.35808, 38.40151], [-122.35815, 38.40149], [-122.35826, 38.40168]]]} | Open Access 1 | 47671 | Town of Yountville Open Space | 31412 | 1385 | Yountville, Town of 730 | City 2 | City Agency 2 | http://www.townofyountville.com/index.aspx?page=88 | City 2 | 1385 | Yountville, Town of 714 | City 2 | City Agency 2 | Napa 11 | 0.912 | Town of Yountville OS | 0 | Local Recreation Area 3 | 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 | |
9524 | 9524 | 9523 | {"type": "Polygon", "coordinates": [[[-122.49333, 38.50768], [-122.49296, 38.50786], [-122.49183, 38.50759], [-122.49114, 38.50768], [-122.49113, 38.50772], [-122.49114, 38.50773], [-122.49184, 38.50764], [-122.4929, 38.5079], [-122.49098, 38.5088], [-122.49102, 38.50907], [-122.491, 38.50922], [-122.49111, 38.50939], [-122.49104, 38.50958], [-122.49103, 38.50969], [-122.49109, 38.50985], [-122.49117, 38.50995], [-122.49131, 38.51002], [-122.49138, 38.51015], [-122.49154, 38.5103], [-122.49176, 38.51044], [-122.49192, 38.51051], [-122.492, 38.51069], [-122.49219, 38.51095], [-122.49231, 38.51104], [-122.49215, 38.51106], [-122.49185, 38.51078], [-122.49147, 38.5106], [-122.49134, 38.51062], [-122.49123, 38.51052], [-122.4911, 38.51045], [-122.49096, 38.51045], [-122.49034, 38.5106], [-122.49018, 38.51059], [-122.49018, 38.51015], [-122.49013, 38.50988], [-122.48998, 38.50966], [-122.48996, 38.50957], [-122.48978, 38.5094], [-122.48972, 38.5094], [-122.48965, 38.50949], [-122.48944, 38.50929], [-122.48909, 38.50891], [-122.48809, 38.50959], [-122.48786, 38.50934], [-122.48797, 38.50927], [-122.48838, 38.50825], [-122.4881, 38.50806], [-122.48589, 38.50731], [-122.48671, 38.50627], [-122.48724, 38.50668], [-122.4877, 38.50671], [-122.48799, 38.50689], [-122.4889, 38.50694], [-122.48919, 38.50685], [-122.48964, 38.50654], [-122.48983, 38.50626], [-122.48995, 38.50621], [-122.49019, 38.50616], [-122.49057, 38.50612], [-122.49087, 38.5062], [-122.49088, 38.50637], [-122.4912, 38.50642], [-122.49241, 38.50717], [-122.493, 38.50732], [-122.49333, 38.50768]]]} | No Public Access 3 | 15977 | Lower Reservoir | 21564 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 34.792 | Lower Reservoir | 0 | Local Recreation Area 3 | 4 | |
9525 | 9525 | 9524 | {"type": "MultiPolygon", "coordinates": [[[[-122.43837, 38.49699], [-122.43988, 38.49829], [-122.44033, 38.49865], [-122.43614, 38.50173], [-122.43599, 38.50173], [-122.43555, 38.50177], [-122.43473, 38.50177], [-122.4346, 38.50175], [-122.4345, 38.5017], [-122.43442, 38.50161], [-122.43423, 38.50124], [-122.43401, 38.50105], [-122.4339, 38.50097], [-122.4338, 38.50074], [-122.4337, 38.50062], [-122.43318, 38.50009], [-122.43294, 38.49986], [-122.4327, 38.49966], [-122.4325, 38.49925], [-122.43254, 38.49869], [-122.43253, 38.49819], [-122.43249, 38.4981], [-122.4324, 38.49799], [-122.43222, 38.49783], [-122.43211, 38.49776], [-122.43189, 38.49766], [-122.43167, 38.49762], [-122.43154, 38.4976], [-122.43098, 38.49761], [-122.43134, 38.49755], [-122.43134, 38.49754], [-122.43114, 38.49743], [-122.43352, 38.49571], [-122.4369, 38.49338], [-122.43828, 38.49458], [-122.4368, 38.49571], [-122.43837, 38.49699]]], [[[-122.46464, 38.51291], [-122.46285, 38.51541], [-122.46252, 38.5151], [-122.46227, 38.51482], [-122.46185, 38.51443], [-122.46164, 38.51433], [-122.46151, 38.51431], [-122.46109, 38.51427], [-122.46078, 38.51426], [-122.46232, 38.51217], [-122.46227, 38.51226], [-122.46298, 38.51254], [-122.46311, 38.51237], [-122.46464, 38.51291]]]]} | No Public Access 3 | 15980 | St Helena Wastewater Treatment Field | 25762 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 108.217 | St Helena Wastewater Treatment Field | 0 | Local Recreation Area 3 | 4 | |
9526 | 9526 | 9525 | {"type": "Polygon", "coordinates": [[[-122.49213, 38.55407], [-122.4921, 38.55514], [-122.49007, 38.55516], [-122.49014, 38.55796], [-122.49014, 38.55878], [-122.48984, 38.5588], [-122.48659, 38.56392], [-122.48242, 38.5639], [-122.48233, 38.55908], [-122.48077, 38.55917], [-122.48076, 38.55875], [-122.47996, 38.55875], [-122.47995, 38.55606], [-122.48094, 38.55589], [-122.48093, 38.55317], [-122.48554, 38.55315], [-122.48553, 38.55216], [-122.48468, 38.55149], [-122.48316, 38.5515], [-122.48315, 38.55125], [-122.4831, 38.5512], [-122.48307, 38.55064], [-122.48356, 38.55098], [-122.48489, 38.5514], [-122.48496, 38.55146], [-122.48498, 38.55149], [-122.48552, 38.55192], [-122.48553, 38.55191], [-122.48813, 38.55396], [-122.48848, 38.5542], [-122.48872, 38.55429], [-122.48904, 38.55434], [-122.48961, 38.55429], [-122.49008, 38.55422], [-122.49213, 38.55407]]]} | No Public Access 3 | 15982 | Bell Canyon Reservoir | 15971 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 206.019 | Bell Canyon Reservoir | 0 | Local Recreation Area 3 | 4 | |
9527 | 9527 | 9526 | {"type": "Polygon", "coordinates": [[[-122.61605, 38.62512], [-122.61376, 38.62739], [-122.60677, 38.62506], [-122.60683, 38.62492], [-122.60683, 38.62491], [-122.60407, 38.62493], [-122.60408, 38.62146], [-122.59921, 38.62147], [-122.59909, 38.61781], [-122.60673, 38.61786], [-122.61018, 38.6186], [-122.61047, 38.6187], [-122.6109, 38.61796], [-122.61335, 38.61401], [-122.6132, 38.61741], [-122.61476, 38.62026], [-122.61398, 38.62097], [-122.61602, 38.62399], [-122.61605, 38.62512]]]} | No Public Access 3 | 15986 | Kimball Reservoir | 20646 | 1042 | Calistoga, City of 774 | City 2 | City Agency 2 | http://www.ci.calistoga.ca.us/ | City 2 | 1042 | Calistoga, City of 755 | City 2 | City Agency 2 | Napa 11 | 258.548 | Kimball Reservoir | 0 | Local Recreation Area 3 | 4 | |
10127 | 10127 | 10126 | {"type": "Polygon", "coordinates": [[[-122.25999, 38.18782], [-122.25802, 38.18781], [-122.25773, 38.18636], [-122.2597, 38.18619], [-122.25999, 38.18782]]]} | Open Access 1 | 17597 | Little League Complex | 21344 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 7.36 | Little League Complex | 0 | Local Recreation Area 3 | 4 | |
13611 | 13611 | 13610 | {"type": "Polygon", "coordinates": [[[-122.30454, 38.32522], [-122.30452, 38.32526], [-122.30436, 38.32541], [-122.30419, 38.32528], [-122.3044, 38.3251], [-122.30452, 38.32519], [-122.30454, 38.32522]]]} | Open Access 1 | 36296 | Beckworth Tot Lot | 28574 | 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.134 | Beckworth Tot Lot | 0 | Local Recreation Area 3 | 4 | |
13957 | 13957 | 13956 | {"type": "Polygon", "coordinates": [[[-122.31129, 38.33053], [-122.31128, 38.33057], [-122.31125, 38.3306], [-122.3111, 38.33063], [-122.31102, 38.33039], [-122.31124, 38.33035], [-122.31129, 38.33053]]]} | Open Access 1 | 36599 | Sequoia Tot Lot | 30029 | 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.125 | Sequoia Tot Lot | 0 | Local Recreation Area 3 | 4 | |
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 |
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]);