units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
172 rows where COUNTY = 29
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_LEV, PARK_URL, YR_EST, GAP_STS
MNG_AGENCY >30
- Visalia, City of 43
- Tulare, City of 16
- Tulare, County of 15
- Porterville, City of 13
- Exeter, City of 11
- Dinuba, City of 10
- California Department of Fish and Wildlife 7
- Woodlake, City of 7
- Sequoia Riverlands Trust 6
- Farmersville, City of 5
- Lindsay, City of 4
- United States Forest Service 3
- Exeter Cemetery District 3
- United States Army Corps of Engineers 3
- United States Bureau of Land Management 2
- United States Fish and Wildlife Service 2
- Save the Redwoods League 2
- United States National Park Service 2
- Lindsay-Strathmore Cemetery District 2
- Porterville Public Cemetery District 2
- California Department of Parks and Recreation 1
- California State Lands Commission 1
- Center for Natural Lands Management 1
- Woodlake Public Cemetery District 1
- Tulare Veterans Memorial District 1
- Woodville Public Cemetery District 1
- Tulare Cemetery District 1
- Other Federal 1
- California Department of Forestry and Fire Protection 1
- Tulare County Historical Society 1
- …
DES_TP 20
- Local Park 102
- Local Recreation Area 14
- Local Historic or Cultural Area 11
- Private Conservation 9
- State Conservation Area 7
- Local Other or Unknown 7
- Resource Management Area 3
- Local Conservation Area 2
- National Forest 2
- National Park 2
- State Resource Management Area 2
- National Monument or Landmark 2
- National Wildlife Refuge 2
- National Public Lands 1
- None 1
- None 1
- Recreation Management Area 1
- State Historic or Cultural Area 1
- Research or Educational Area 1
- None 1
MNG_AG_TYP 9
ACCESS_TYP 3
- Open Access 155
- Restricted Access 13
- No Public Access 4
| 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 | |
| 239 | 239 | 238 | {"type": "Polygon", "coordinates": [[[-119.19796, 36.31684], [-119.19795, 36.31782], [-119.19604, 36.31789], [-119.196, 36.31689], [-119.19796, 36.31684]]]} | Open Access 1 | 773 | Deep Creek Cemetery | 17988 | 2033 | Exeter Cemetery District 99 | Special District 4 | Cemetery District 11 | Special District 4 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Tulare 29 | 4.704 | Deep Creek Cemetery | 0 | Local Historic or Cultural Area 19 | 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 | |
| 262 | 262 | 261 | {"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.51519, 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.51229, 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.50998, 36.50746], [-119.50976, 36.5076], [-119.50924, 36.50769], [-119.50894, 36.5078], [-119.50879, 36.50781], [-119.50838, 36.5078], [-119.50839, 36.5066], [-119.50732, 36.50658], [-119.50733, 36.50532], [-119.50718, 36.50531], [-119.50723, 36.50332], [-119.51176, 36.50332], [-119.51176, 36.50188], [-119.51343, 36.50219], [-119.51503, 36.50228], [-119.51505, 36.50638], [-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 | 733 | Kings River Nature Preserve | 20663 | 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 | 86.678 | Kings River Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
| 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 | |
| 267 | 267 | 266 | {"type": "Polygon", "coordinates": [[[-119.02915, 36.43551], [-119.02072, 36.43543], [-119.02065, 36.42818], [-119.02892, 36.42826], [-119.02825, 36.43122], [-119.02828, 36.43212], [-119.02856, 36.43284], [-119.02907, 36.43388], [-119.02921, 36.43451], [-119.02915, 36.43551]]]} | Restricted Access 2 | 907 | Dry Creek Preserve | 18285 | 3076 | Sequoia Riverlands Trust 109 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | Tulare 29 | 142.711 | Dry Creek Preserve | 2004 | Private Conservation 16 | 2 | |
| 286 | 286 | 285 | {"type": "Polygon", "coordinates": [[[-119.13521, 36.30947], [-119.1351, 36.31147], [-119.13075, 36.31143], [-119.13077, 36.31043], [-119.1323, 36.31043], [-119.13238, 36.30936], [-119.13521, 36.30947]]]} | Open Access 1 | 778 | Exeter Cemetery | 18773 | 2033 | Exeter Cemetery District 99 | Special District 4 | Cemetery District 11 | Special District 4 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Tulare 29 | 18.069 | Exeter Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
| 290 | 290 | 289 | {"type": "Polygon", "coordinates": [[[-119.10764, 36.34977], [-119.10762, 36.35107], [-119.1054, 36.35107], [-119.10542, 36.34976], [-119.10764, 36.34977]]]} | Open Access 1 | 782 | Hamilton Cemetery | 19616 | 2033 | Exeter Cemetery District 99 | Special District 4 | Cemetery District 11 | Special District 4 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Tulare 29 | 7.139 | Hamilton Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
| 298 | 298 | 297 | {"type": "Polygon", "coordinates": [[[-118.95592, 36.14627], [-118.95521, 36.14626], [-118.9552, 36.14479], [-118.95589, 36.1448], [-118.95592, 36.14627]]]} | Open Access 1 | 802 | Frazier Valley Cemetery | 19071 | 2060 | Lindsay-Strathmore Cemetery District 122 | Special District 4 | Cemetery District 11 | Special District 4 | 2060 | Lindsay-Strathmore Cemetery District 119 | Special District 4 | Cemetery District 11 | Tulare 29 | 2.538 | Frazier Valley Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
| 304 | 304 | 303 | {"type": "Polygon", "coordinates": [[[-119.10787, 36.41389], [-119.10786, 36.41561], [-119.10573, 36.41561], [-119.10572, 36.4146], [-119.10643, 36.4146], [-119.10644, 36.41385], [-119.10787, 36.41389]]]} | Open Access 1 | 1041 | Antelope Cemetery | 15507 | 2184 | Woodlake Public Cemetery District 124 | Special District 4 | Cemetery District 11 | Special District 4 | 2184 | Woodlake Public Cemetery District 121 | Special District 4 | Cemetery District 11 | Tulare 29 | 7.877 | Antelope Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
| 308 | 308 | 307 | {"type": "Polygon", "coordinates": [[[-119.38657, 36.53614], [-119.38603, 36.53654], [-119.38602, 36.53567], [-119.38657, 36.53614], [-119.38657, 36.53614]]]} | Open Access 1 | 1054 | Gegory Park | 19248 | 1086 | Dinuba, City of 127 | City 2 | City Agency 2 | http://www.dinuba.org/ | City 2 | 1086 | Dinuba, City of 124 | City 2 | City Agency 2 | Tulare 29 | 0.573 | Gegory Park | 0 | Local Park 2 | 4 | |
| 313 | 313 | 312 | {"type": "Polygon", "coordinates": [[[-119.13591, 36.29543], [-119.13588, 36.29709], [-119.13271, 36.29702], [-119.1327, 36.29541], [-119.13591, 36.29543]]]} | Open Access 1 | 1084 | Exeter City Athletic Park | 18774 | 1103 | Exeter, City of 129 | City 2 | City Agency 2 | http://www.cityofexeter.com/ | City 2 | 1103 | Exeter, City of 126 | City 2 | City Agency 2 | Tulare 29 | 12.899 | Exeter City Athletic Park | 0 | Local Recreation Area 3 | 4 | |
| 321 | 321 | 320 | {"type": "Polygon", "coordinates": [[[-119.13639, 36.29924], [-119.13605, 36.29935], [-119.13609, 36.29885], [-119.13612, 36.2988], [-119.13639, 36.29924]]]} | Open Access 1 | 1102 | Rose Garden Park | 24609 | 1103 | Exeter, City of 129 | City 2 | City Agency 2 | http://www.cityofexeter.com/ | City 2 | 1103 | Exeter, City of 126 | City 2 | City Agency 2 | Tulare 29 | 0.24 | Rose Garden Park | 0 | Local Park 2 | 4 | |
| 336 | 336 | 335 | {"type": "Polygon", "coordinates": [[[-119.16636, 36.33385], [-119.16631, 36.3306], [-119.17077, 36.33065], [-119.17068, 36.3269], [-119.17232, 36.3269], [-119.18431, 36.32699], [-119.18446, 36.33397], [-119.17518, 36.33393], [-119.17492, 36.33416], [-119.17353, 36.33504], [-119.17312, 36.33559], [-119.17293, 36.33569], [-119.17203, 36.33687], [-119.17172, 36.33745], [-119.17117, 36.33799], [-119.17098, 36.33813], [-119.17022, 36.33849], [-119.16965, 36.33899], [-119.16862, 36.33893], [-119.16801, 36.33869], [-119.16729, 36.33859], [-119.16658, 36.33872], [-119.16636, 36.33385]]]} | Open Access 1 | 927 | Kaweah Oaks Preserve | 12487 | 3076 | Sequoia Riverlands Trust 109 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org/protected-spaces/kaweah-oaks-preserve | Tulare 29 | 343.433 | Kaweah Oaks Preserve | 1983 | Private Conservation 16 | 2 |
| 338 | 338 | 337 | {"type": "Polygon", "coordinates": [[[-119.09585, 36.20318], [-119.09406, 36.19994], [-119.09406, 36.19994], [-119.09568, 36.19993], [-119.09574, 36.20151], [-119.09585, 36.20318]]]} | Open Access 1 | 1164 | Olive Bowl Park | 23120 | 1176 | Lindsay, City of 137 | City 2 | City Agency 2 | http://www.lindsay.ca.us/citygov/works/parks.cfm | City 2 | 1176 | Lindsay, City of 134 | City 2 | City Agency 2 | Tulare 29 | 6.405 | Olive Bowl Park | 0 | Local Park 2 | 4 | |
| 340 | 340 | 339 | {"type": "Polygon", "coordinates": [[[-119.01789, 36.10783], [-119.01789, 36.10914], [-119.00272, 36.10911], [-119.00284, 36.109], [-119.00308, 36.10874], [-119.00326, 36.10846], [-119.00365, 36.10771], [-119.00384, 36.10778], [-119.00391, 36.10765], [-119.00407, 36.10744], [-119.0043, 36.10722], [-119.00443, 36.10712], [-119.00759, 36.10672], [-119.0073, 36.10562], [-119.00796, 36.10521], [-119.01016, 36.10608], [-119.01113, 36.10503], [-119.0128, 36.10516], [-119.01788, 36.10706], [-119.01789, 36.10783]]]} | Restricted Access 2 | 933 | Lewis Hill Preserve | 21191 | 3076 | Sequoia Riverlands Trust 109 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | Tulare 29 | 107.649 | Lewis Hill Preserve | 1994 | Private Conservation 16 | 2 | |
| 343 | 343 | 342 | {"type": "Polygon", "coordinates": [[[-119.06923, 36.07235], [-119.06918, 36.07236], [-119.06918, 36.07248], [-119.06778, 36.07246], [-119.06781, 36.07093], [-119.06922, 36.07094], [-119.06923, 36.07235]]]} | Open Access 1 | 1167 | Burton Ballfields | 16529 | 1260 | Porterville, City of 139 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | Tulare 29 | 5.41 | Burton Ballfields | None 34 | |||
| 351 | 351 | 350 | {"type": "Polygon", "coordinates": [[[-119.32193, 36.20761], [-119.32189, 36.20923], [-119.32081, 36.20925], [-119.32078, 36.20934], [-119.31981, 36.20934], [-119.31987, 36.20762], [-119.32193, 36.20761]]]} | Open Access 1 | 969 | Tulare Veterans Memorial Park | 26570 | 2168 | Tulare Veterans Memorial District 144 | Special District 4 | Cemetery District 11 | Special District 4 | 2168 | Tulare Veterans Memorial District 140 | Special District 4 | Cemetery District 11 | Tulare 29 | 8.555 | Tulare Veterans Memorial Park | 0 | Local Park 2 | 4 | ||
| 366 | 366 | 365 | {"type": "Polygon", "coordinates": [[[-119.18856, 36.09471], [-119.18594, 36.09472], [-119.18594, 36.09315], [-119.18855, 36.09314], [-119.18856, 36.09471]]]} | Open Access 1 | 1046 | Woodville Cemetery | 27750 | 2185 | Woodville Public Cemetery District 150 | Special District 4 | Cemetery District 11 | Special District 4 | 2185 | Woodville Public Cemetery District 146 | Special District 4 | Cemetery District 11 | Tulare 29 | 10.155 | Woodville Cemetery | 0 | Local Historic or Cultural Area 19 | 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]);