superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15 rows where MNG_AG_ID = 330 and MNG_AG_LEV = 3
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
750 | 750 | 749 | {"type": "Polygon", "coordinates": [[[-119.48844, 35.88958], [-119.48844, 35.89083], [-119.48736, 35.89082], [-119.48736, 35.88959], [-119.48844, 35.88958]]]} | Open Access 1 | Alpaugh Park | 15404 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 3.313 | Alpaugh Park | ||
1784 | 1784 | 1783 | {"type": "Polygon", "coordinates": [[[-118.93335, 36.05327], [-118.92985, 36.0558], [-118.92813, 36.05675], [-118.9281, 36.05857], [-118.91372, 36.05857], [-118.91457, 36.05771], [-118.9149, 36.05674], [-118.91523, 36.05625], [-118.91535, 36.05652], [-118.91497, 36.05735], [-118.91511, 36.05767], [-118.91585, 36.058], [-118.91877, 36.058], [-118.91947, 36.05711], [-118.92079, 36.05711], [-118.92118, 36.05661], [-118.92137, 36.05655], [-118.92194, 36.0559], [-118.92294, 36.05525], [-118.92319, 36.05498], [-118.92353, 36.05439], [-118.92349, 36.05416], [-118.92339, 36.05408], [-118.92463, 36.05137], [-118.92516, 36.05104], [-118.9256, 36.05079], [-118.92683, 36.05031], [-118.92822, 36.04991], [-118.92816, 36.05452], [-118.93008, 36.05345], [-118.93103, 36.05314], [-118.93183, 36.05315], [-118.9328, 36.05262], [-118.93335, 36.05327]]]} | Open Access 1 | Bartlett Park | 15842 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 142.016 | Bartlett Park | ||
3385 | 3385 | 3384 | {"type": "Polygon", "coordinates": [[[-119.23414, 36.35107], [-119.22996, 36.35173], [-119.2286, 36.35173], [-119.2253, 36.35217], [-119.22531, 36.35003], [-119.22726, 36.34904], [-119.22746, 36.34897], [-119.22748, 36.34931], [-119.23413, 36.34928], [-119.23414, 36.35107]]]} | Open Access 1 | Cutler Park | 17867 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 50.36 | Cutler Park | ||
3938 | 3938 | 3937 | {"type": "Polygon", "coordinates": [[[-119.32892, 36.14604], [-119.32886, 36.14623], [-119.3288, 36.14734], [-119.32844, 36.14755], [-119.32821, 36.14757], [-119.32768, 36.14749], [-119.32705, 36.14774], [-119.32673, 36.1479], [-119.32644, 36.14823], [-119.32636, 36.14829], [-119.32612, 36.14841], [-119.32589, 36.14841], [-119.32588, 36.14707], [-119.32732, 36.14605], [-119.32741, 36.14599], [-119.32764, 36.1459], [-119.32785, 36.14585], [-119.32806, 36.14583], [-119.32841, 36.14585], [-119.32875, 36.14595], [-119.32892, 36.14604]]]} | Open Access 1 | Elk Bayou Park | 18560 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 11.374 | Elk Bayou Park | ||
5746 | 5746 | 5745 | {"type": "MultiPolygon", "coordinates": [[[[-119.51628, 36.5064], [-119.51628, 36.50687], [-119.51596, 36.50697], [-119.5159, 36.50697], [-119.51578, 36.50704], [-119.51571, 36.50706], [-119.51541, 36.50717], [-119.5152, 36.50722], [-119.51504, 36.50729], [-119.5146, 36.50739], [-119.51446, 36.5074], [-119.51416, 36.5074], [-119.51366, 36.50732], [-119.51344, 36.50726], [-119.51285, 36.50704], [-119.5123, 36.5069], [-119.51198, 36.50687], [-119.5116, 36.50688], [-119.51097, 36.50675], [-119.51085, 36.50679], [-119.51073, 36.50687], [-119.51069, 36.50704], [-119.51062, 36.50717], [-119.51053, 36.50724], [-119.51037, 36.50734], [-119.5101, 36.50745], [-119.50997, 36.50747], [-119.50976, 36.5076], [-119.50924, 36.50769], [-119.50894, 36.5078], [-119.50879, 36.50781], [-119.50838, 36.5078], [-119.50839, 36.50661], [-119.50732, 36.50658], [-119.50733, 36.50533], [-119.50718, 36.50531], [-119.50723, 36.50332], [-119.51175, 36.50332], [-119.51176, 36.50188], [-119.51343, 36.50219], [-119.51503, 36.50228], [-119.51505, 36.50637], [-119.51628, 36.5064]]], [[[-119.51651, 36.50754], [-119.5165, 36.50802], [-119.51522, 36.50835], [-119.51522, 36.5079], [-119.5154, 36.50788], [-119.51546, 36.50784], [-119.51651, 36.50754]]]]} | Restricted Access 2 | Kings River Nature Preserve | 20663 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 86.715 | Kings River Nature Preserve | ||
6073 | 6073 | 6072 | {"type": "Polygon", "coordinates": [[[-119.28968, 36.52836], [-119.28966, 36.53016], [-119.28768, 36.53012], [-119.28767, 36.52949], [-119.28688, 36.52949], [-119.28687, 36.52833], [-119.28968, 36.52836]]]} | Open Access 1 | Ledbetter Park | 21129 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 11.054 | Ledbetter Park | ||
6984 | 6984 | 6983 | {"type": "Polygon", "coordinates": [[[-119.29489, 35.98035], [-119.29292, 35.98036], [-119.2929, 35.97877], [-119.2929, 35.97629], [-119.29461, 35.97627], [-119.29478, 35.9767], [-119.29488, 35.977], [-119.29489, 35.98035]]]} | Open Access 1 | Pixley Park | 23756 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 19.727 | Pixley Park | ||
7181 | 7181 | 7180 | {"type": "Polygon", "coordinates": [[[-119.31332, 36.28387], [-119.31327, 36.28392], [-119.3055, 36.28427], [-119.30546, 36.27708], [-119.30854, 36.27694], [-119.30853, 36.27701], [-119.30855, 36.27702], [-119.31225, 36.27686], [-119.31289, 36.27687], [-119.31317, 36.27686], [-119.3132, 36.27937], [-119.3133, 36.28271], [-119.31332, 36.28387]]]} | Open Access 1 | Mooney Grove Park | 22452 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 136.357 | Mooney Grove Park | ||
9931 | 9931 | 9930 | {"type": "Polygon", "coordinates": [[[-119.26803, 35.88277], [-119.26605, 35.88278], [-119.26604, 35.88105], [-119.26698, 35.88105], [-119.26697, 35.88197], [-119.26803, 35.88199], [-119.26803, 35.88277]]]} | Open Access 1 | Earlimart Park | 28000 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 6.039 | Earlimart Park | ||
10491 | 10491 | 10490 | {"type": "Polygon", "coordinates": [[[-118.67954, 36.22615], [-118.66991, 36.22607], [-118.66963, 36.22235], [-118.67932, 36.2224], [-118.67954, 36.22615]]]} | Open Access 1 | Tulare holding 1 | 26567 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 88.937 | Tulare holding 1 | ||
10492 | 10492 | 10491 | {"type": "MultiPolygon", "coordinates": [[[[-118.68071, 36.22118], [-118.68053, 36.2214], [-118.67994, 36.22168], [-118.6797, 36.22207], [-118.67975, 36.22239], [-118.67444, 36.22236], [-118.67914, 36.21893], [-118.67961, 36.21893], [-118.67943, 36.21929], [-118.67935, 36.22006], [-118.67977, 36.22047], [-118.68059, 36.22082], [-118.68071, 36.22118]]], [[[-118.68642, 36.22241], [-118.68392, 36.22242], [-118.67997, 36.2224], [-118.67991, 36.22211], [-118.68009, 36.2218], [-118.68068, 36.22152], [-118.68093, 36.2212], [-118.68076, 36.22071], [-118.6799, 36.22032], [-118.67956, 36.22], [-118.67963, 36.21933], [-118.67982, 36.21893], [-118.68627, 36.21896], [-118.68642, 36.22241]]]]} | Open Access 1 | Tulare holding 2 | 26568 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 79.43 | Tulare holding 2 | ||
11087 | 11087 | 11086 | {"type": "Polygon", "coordinates": [[[-119.3255, 36.32776], [-119.32549, 36.32788], [-119.32499, 36.32825], [-119.32359, 36.32924], [-119.3233, 36.32937], [-119.32297, 36.32943], [-119.32138, 36.32946], [-119.31944, 36.32945], [-119.31947, 36.32926], [-119.31964, 36.32891], [-119.31973, 36.32875], [-119.31985, 36.32865], [-119.31996, 36.32861], [-119.32115, 36.32916], [-119.32133, 36.32919], [-119.3215, 36.32918], [-119.32171, 36.32914], [-119.32208, 36.32899], [-119.32224, 36.32897], [-119.32259, 36.32888], [-119.32305, 36.32891], [-119.32356, 36.32886], [-119.32381, 36.32876], [-119.32424, 36.32851], [-119.32468, 36.32822], [-119.32536, 36.3278], [-119.3255, 36.32776]]]} | Open Access 1 | West Main Street Park | 27366 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 6.236 | West Main Street Park | ||
11413 | 11413 | 11412 | {"type": "Polygon", "coordinates": [[[-119.20475, 36.09584], [-119.20473, 36.09616], [-119.20473, 36.09843], [-119.2034, 36.09842], [-119.20342, 36.09487], [-119.20394, 36.09487], [-119.20394, 36.09584], [-119.20475, 36.09584]]]} | Open Access 1 | Woodville Park | 27751 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 9.728 | Woodville Park | ||
13886 | 13886 | 13885 | {"type": "Polygon", "coordinates": [[[-119.41234, 36.35422], [-119.41059, 36.35422], [-119.41051, 36.35418], [-119.41044, 36.35417], [-119.41035, 36.3542], [-119.41025, 36.35427], [-119.41019, 36.35429], [-119.40983, 36.3543], [-119.40983, 36.35278], [-119.41231, 36.35278], [-119.41233, 36.3528], [-119.41234, 36.35422]]]} | Open Access 1 | Peter Malloch Park | 33147 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 8.929 | Peter Malloch Park | ||
14397 | 14397 | 14396 | {"type": "Polygon", "coordinates": [[[-119.31269, 36.05787], [-119.31226, 36.05793], [-119.31221, 36.0577], [-119.31261, 36.05762], [-119.31269, 36.05787]]]} | Open Access 1 | Unknown park - Tulare, County of | 33611 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 0.259 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);