units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where COUNTY = 29, DES_TP = 2 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- County Agency · 11 ✖
MNG_AGENCY 1
DES_TP 1
- Local Park · 11 ✖
ACCESS_TYP 1
- Open Access 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
234 | 234 | 233 | {"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 | 752 | Pixley Park | 23756 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 19.73 | Pixley Park | 0 | Local Park 2 | 4 | |
252 | 252 | 251 | {"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 | 702 | Alpaugh Park | 15404 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 3.313 | Alpaugh Park | 0 | Local Park 2 | 4 | |
257 | 257 | 256 | {"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.92136, 36.05655], [-118.92194, 36.0559], [-118.92294, 36.05525], [-118.92319, 36.05498], [-118.92354, 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 | 715 | Bartlett Park | 15842 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 141.958 | Bartlett Park | 0 | Local Park 2 | 4 | |
265 | 265 | 264 | {"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 | 743 | Ledbetter Park | 21129 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 11.05 | Ledbetter Park | 0 | Local Park 2 | 4 | |
4224 | 4224 | 4223 | {"type": "Polygon", "coordinates": [[[-119.26803, 35.88277], [-119.26605, 35.88278], [-119.26604, 35.88105], [-119.26698, 35.88105], [-119.26697, 35.88198], [-119.26803, 35.88199], [-119.26803, 35.88277]]]} | Open Access 1 | 45040 | Earlimart Park | 28000 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 6.033 | Earlimart Park | 0 | Local Park 2 | 4 | |
6013 | 6013 | 6012 | {"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 | 728 | Elk Bayou Park | 18560 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 11.374 | Elk Bayou Park | 0 | Local Park 2 | 4 | |
6030 | 6030 | 6029 | {"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.22747, 36.34931], [-119.23413, 36.34928], [-119.23414, 36.35107]]]} | Open Access 1 | 721 | Cutler Park | 17867 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 50.36 | Cutler Park | 0 | Local Park 2 | 4 | |
6046 | 6046 | 6045 | {"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 | 759 | West Main Street Park | 27366 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 6.236 | West Main Street Park | 0 | Local Park 2 | 4 | |
6049 | 6049 | 6048 | {"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.30854, 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 | 748 | Mooney Grove Park | 22452 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 136.359 | Mooney Grove Park | 0 | Local Park 2 | 4 | |
6051 | 6051 | 6050 | {"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 | 764 | Woodville Park | 27751 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 9.722 | Woodville Park | 0 | Local Park 2 | 4 | |
7437 | 7437 | 7436 | {"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 | 48442 | Peter Malloch Park | 33147 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 8.931 | Peter Malloch 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]);