units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
164 rows where DES_TP = 3 and MNG_AG_TYP = 4 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, PARK_URL, COUNTY
MNG_AGENCY >30
- East Bay Regional Park District 28
- Conejo Recreation and Park District 14
- Sunrise Recreation and Park District 12
- Rancho Simi Recreation and Park District 11
- Valley-Wide Recreation and Park District 9
- Hayward Area Recreation and Park District 7
- Isla Vista Recreation and Park District 6
- Desert Recreation District 6
- Southgate Recreation and Park District 5
- Monterey Peninsula Regional Park District 4
- Tuolumne Park and Recreation District 4
- Miraleste Recreation and Park District 4
- Pleasant Valley Recreation and Park District 3
- Apple Valley Recreation and Park District 3
- Pleasant Hill Recreation and Park District 3
- Durham Recreation and Park District 3
- Barstow Recreation and Park District 2
- Jurupa Area Recreation and Park District 2
- North of the River Recreation and Park District 2
- Auburn Area Recreation and Park District 2
- West Side Recreation and Park District 2
- Truckee-Donner Recreation and Park District 2
- Hesperia Recreation and Park District 2
- Orangevale Recreation and Park District 2
- Weed Recreation and Parks District 2
- Rim of the World Recreation and Park District 1
- Feather River Recreation and Park District 1
- Greater Vallejo Recreation and Park District 1
- Shafter Recreation and Park District 1
- Wasco Recreation and Park District 1
- …
ACCESS_TYP 3
MNG_AG_TYP 1
- Recreation/Parks District · 164 ✖
DES_TP 1
- Local Recreation Area · 164 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3929 | 3929 | 3928 | {"type": "Polygon", "coordinates": [[[-121.10884, 38.95035], [-121.10788, 38.95042], [-121.10787, 38.95046], [-121.10748, 38.95048], [-121.10748, 38.94927], [-121.1088, 38.94923], [-121.10884, 38.95035]]]} | Open Access 1 | 36208 | Auburn Recreation District 1 | 15695 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | Placer 35 | 3.705 | Auburn Rec. District 1 | 0 | Local Recreation Area 3 | 4 | |
11225 | 11225 | 11224 | {"type": "Polygon", "coordinates": [[[-121.08019, 38.88362], [-121.08017, 38.8873], [-121.08018, 38.88871], [-121.07996, 38.88872], [-121.07997, 38.89012], [-121.07901, 38.89031], [-121.0787, 38.89031], [-121.07837, 38.89027], [-121.07817, 38.88988], [-121.07792, 38.88832], [-121.07785, 38.88746], [-121.07815, 38.88727], [-121.07848, 38.88699], [-121.07918, 38.88629], [-121.07938, 38.88605], [-121.07956, 38.88581], [-121.07969, 38.88557], [-121.07981, 38.88531], [-121.0799, 38.88504], [-121.07996, 38.88476], [-121.07998, 38.88454], [-121.07998, 38.88432], [-121.07991, 38.88363], [-121.08019, 38.88362]]]} | Open Access 1 | 21560 | Recreation Park | 24219 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_recreation.php | Placer 35 | 20.474 | Rec. Park | 0 | Local Recreation Area 3 | 4 |
2199 | 2199 | 2198 | {"type": "Polygon", "coordinates": [[[-121.96127, 39.73954], [-121.9611, 39.73965], [-121.96071, 39.73926], [-121.96055, 39.73914], [-121.96029, 39.73899], [-121.96006, 39.7389], [-121.95966, 39.73877], [-121.9598, 39.73858], [-121.95991, 39.73863], [-121.96007, 39.73873], [-121.96046, 39.73889], [-121.96064, 39.73894], [-121.96089, 39.73915], [-121.96127, 39.73954]]]} | Open Access 1 | 16471 | Chico Area Recreation & Park District | 17191 | 2017 | Chico Area Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.chicorec.com/ | Special District 4 | 2017 | Chico Area Recreation and Park District 485 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 0.797 | Chico Area Rec. & Park District | 0 | Local Recreation Area 3 | 4 | |
532 | 532 | 531 | {"type": "Polygon", "coordinates": [[[-118.90336, 34.18406], [-118.90262, 34.18413], [-118.8993, 34.1842], [-118.89928, 34.18407], [-118.89887, 34.18356], [-118.89889, 34.18303], [-118.89872, 34.18292], [-118.89961, 34.18202], [-118.8998, 34.18225], [-118.90006, 34.18231], [-118.90027, 34.18246], [-118.90028, 34.18262], [-118.90087, 34.18263], [-118.90133, 34.18247], [-118.9018, 34.18266], [-118.9019, 34.18329], [-118.90208, 34.18388], [-118.90268, 34.18407], [-118.90324, 34.18397], [-118.90324, 34.18342], [-118.90333, 34.18327], [-118.90336, 34.18406]]]} | Open Access 1 | 1797 | Walnut Grove Equestrian Center | 27229 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 13.391 | Walnut Grove Equestrian Ctr. | 0 | Local Recreation Area 3 | 4 | |
2046 | 2046 | 2045 | {"type": "Polygon", "coordinates": [[[-118.90087, 34.21526], [-118.90083, 34.21549], [-118.90044, 34.21561], [-118.90035, 34.21547], [-118.90019, 34.21531], [-118.90026, 34.21519], [-118.90029, 34.21507], [-118.90075, 34.21508], [-118.90087, 34.21526]]]} | Open Access 1 | 15585 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.656 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
2047 | 2047 | 2046 | {"type": "Polygon", "coordinates": [[[-118.82311, 34.2117], [-118.82304, 34.212], [-118.82178, 34.21232], [-118.8209, 34.21284], [-118.82064, 34.2127], [-118.82024, 34.21277], [-118.81916, 34.21315], [-118.81817, 34.21344], [-118.81724, 34.21322], [-118.81664, 34.21319], [-118.81637, 34.21305], [-118.81624, 34.21296], [-118.81654, 34.21275], [-118.81686, 34.21244], [-118.817, 34.21233], [-118.81723, 34.21222], [-118.81746, 34.21215], [-118.81768, 34.21213], [-118.8179, 34.21214], [-118.82005, 34.21254], [-118.82032, 34.21256], [-118.82056, 34.21256], [-118.82089, 34.2125], [-118.82121, 34.21239], [-118.82229, 34.21176], [-118.82247, 34.21168], [-118.82275, 34.21162], [-118.82299, 34.21161], [-118.82309, 34.21163], [-118.82311, 34.21166], [-118.82311, 34.2117]]]} | Open Access 1 | 15591 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 10.413 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
2664 | 2664 | 2663 | {"type": "Polygon", "coordinates": [[[-118.79074, 34.17831], [-118.79083, 34.17883], [-118.79085, 34.17913], [-118.79081, 34.17938], [-118.79071, 34.1796], [-118.79039, 34.18012], [-118.79027, 34.18039], [-118.79029, 34.18095], [-118.78987, 34.18098], [-118.78894, 34.18098], [-118.78894, 34.18079], [-118.78879, 34.18062], [-118.78855, 34.1805], [-118.78858, 34.18019], [-118.78876, 34.17983], [-118.78868, 34.17964], [-118.78895, 34.17945], [-118.789, 34.17905], [-118.78924, 34.17889], [-118.78889, 34.17857], [-118.78936, 34.1781], [-118.79015, 34.17831], [-118.79074, 34.17831]]]} | Open Access 1 | 18176 | North Ranch Playfield | 22854 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 11.94 | North Ranch Playfield | 0 | Local Recreation Area 3 | 4 | |
4981 | 4981 | 4980 | {"type": "Polygon", "coordinates": [[[-118.86601, 34.24605], [-118.86522, 34.24588], [-118.86449, 34.24562], [-118.8641, 34.24534], [-118.86386, 34.24503], [-118.86363, 34.24453], [-118.86337, 34.24383], [-118.8629, 34.24116], [-118.86291, 34.24008], [-118.86269, 34.23963], [-118.8625, 34.23963], [-118.86212, 34.24004], [-118.86184, 34.24115], [-118.86166, 34.24164], [-118.86142, 34.24204], [-118.86109, 34.2424], [-118.86029, 34.24304], [-118.86001, 34.24322], [-118.85893, 34.24344], [-118.85787, 34.24342], [-118.85677, 34.24345], [-118.85552, 34.24377], [-118.85491, 34.24409], [-118.85445, 34.24414], [-118.85382, 34.24395], [-118.85335, 34.24361], [-118.85305, 34.24322], [-118.85238, 34.24315], [-118.85209, 34.24331], [-118.85209, 34.24376], [-118.85198, 34.24435], [-118.85229, 34.24447], [-118.85308, 34.24441], [-118.85356, 34.24447], [-118.85435, 34.2448], [-118.85472, 34.24505], [-118.85521, 34.24539], [-118.85582, 34.24601], [-118.85907, 34.24557], [-118.85908, 34.24601], [-118.86183, 34.24698], [-118.86183, 34.24704], [-118.86135, 34.24737], [-118.86071, 34.24737], [-118.85901, 34.24664], [-118.8566, 34.247], [-118.85424, 34.2469], [-118.85211, 34.24762], [-118.85042, 34.2476], [-118.85039, 34.24535], [-118.84855, 34.24563], [-118.84856, 34.24296], [-118.8512, 34.24133], [-118.85202, 34.24224], [-118.85363, 34.24125], [-118.85364, 34.24123], [-118.85345, 34.24102], [-118.85321, 34.24082], [-118.85298, 34.24071], [-118.85281, 34.24069], [-118.85264, 34.24058], [-118.85238, 34.24061], [-118.85271, 34.24038], [-118.85426, 34.23944], [-118.85592, 34.24026], [-118.85688, 34.23975], [-118.85678, 34.23961], [-118.85682, 34.23954], [-118.8567, 34.23937], [-118.85687, 34.23921], [-118.85732, 34.23972], [-118.85764, 34.23997], [-118.86057, 34.23827], [-118.86071, 34.23809], [-118.86598, 34.23806], [-118.86601, 34.24605]]]} | Restricted Access 2 | 17732 | McCrea Open Space | 22014 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 226.171 | McCrea OS | 0 | Local Recreation Area 3 | 4 | |
5082 | 5082 | 5081 | {"type": "Polygon", "coordinates": [[[-118.85008, 34.18256], [-118.84998, 34.18289], [-118.84956, 34.1828], [-118.84971, 34.18249], [-118.85008, 34.18256]]]} | Open Access 1 | 15579 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.346 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5083 | 5083 | 5082 | {"type": "Polygon", "coordinates": [[[-118.89482, 34.22828], [-118.89475, 34.22845], [-118.8946, 34.2284], [-118.8946, 34.22839], [-118.89482, 34.22828]]]} | Open Access 1 | 15581 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.041 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
5243 | 5243 | 5242 | {"type": "Polygon", "coordinates": [[[-118.87309, 34.18644], [-118.87297, 34.18708], [-118.87264, 34.18703], [-118.87276, 34.1864], [-118.87309, 34.18644]]]} | Open Access 1 | 15577 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.536 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
6411 | 6411 | 6410 | {"type": "Polygon", "coordinates": [[[-118.89794, 34.2191], [-118.89793, 34.21915], [-118.89758, 34.21917], [-118.89736, 34.21956], [-118.89723, 34.21963], [-118.89685, 34.22], [-118.89682, 34.22008], [-118.89663, 34.22017], [-118.89628, 34.22], [-118.89553, 34.21901], [-118.89381, 34.21849], [-118.89343, 34.2182], [-118.89323, 34.21818], [-118.89319, 34.21816], [-118.89308, 34.21814], [-118.89292, 34.21802], [-118.89258, 34.21796], [-118.89178, 34.21774], [-118.89125, 34.21762], [-118.89129, 34.21739], [-118.89139, 34.2172], [-118.89162, 34.21689], [-118.89169, 34.2167], [-118.89177, 34.21643], [-118.89185, 34.21642], [-118.89793, 34.21868], [-118.89762, 34.2191], [-118.89763, 34.21912], [-118.89794, 34.2191]]]} | Open Access 1 | 1873 | Wildflower Playfield | 27513 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 21.318 | Wildflower Playfield | 0 | Local Recreation Area 3 | 4 | |
9344 | 9344 | 9343 | {"type": "Polygon", "coordinates": [[[-118.93287, 34.20622], [-118.93193, 34.20716], [-118.93113, 34.20679], [-118.93227, 34.2058], [-118.93257, 34.20603], [-118.93287, 34.20622]]]} | Open Access 1 | 15600 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 2.722 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
10035 | 10035 | 10034 | {"type": "Polygon", "coordinates": [[[-118.91346, 34.1918], [-118.91347, 34.19185], [-118.91314, 34.19327], [-118.91295, 34.19374], [-118.91274, 34.1941], [-118.91103, 34.19338], [-118.91104, 34.19313], [-118.91127, 34.19297], [-118.91135, 34.19285], [-118.9113, 34.1927], [-118.91116, 34.19248], [-118.91116, 34.1923], [-118.91106, 34.19213], [-118.91111, 34.192], [-118.91111, 34.19186], [-118.91106, 34.19169], [-118.91094, 34.19154], [-118.91101, 34.1914], [-118.911, 34.19126], [-118.91079, 34.19126], [-118.91076, 34.19098], [-118.91161, 34.19059], [-118.91181, 34.19085], [-118.91194, 34.19099], [-118.91213, 34.19116], [-118.91232, 34.1913], [-118.91251, 34.19142], [-118.91281, 34.19157], [-118.91346, 34.1918]]]} | Open Access 1 | 18901 | Rancho Conejo Playfield | 24135 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 14.343 | Rancho Conejo Playfield | 0 | Local Recreation Area 3 | 4 | |
10322 | 10322 | 10321 | {"type": "Polygon", "coordinates": [[[-118.85556, 34.22802], [-118.85545, 34.22805], [-118.85539, 34.22811], [-118.85543, 34.22823], [-118.85552, 34.22828], [-118.85555, 34.22841], [-118.85548, 34.22863], [-118.8552, 34.22915], [-118.85463, 34.22899], [-118.85454, 34.22889], [-118.85439, 34.22879], [-118.85362, 34.22847], [-118.8536, 34.22845], [-118.85371, 34.22828], [-118.85414, 34.2279], [-118.85421, 34.22776], [-118.85421, 34.22754], [-118.85414, 34.22727], [-118.85401, 34.22706], [-118.85386, 34.22687], [-118.85387, 34.22683], [-118.85432, 34.22654], [-118.85443, 34.22642], [-118.85454, 34.22635], [-118.85459, 34.22648], [-118.85474, 34.22652], [-118.85478, 34.22656], [-118.85498, 34.22696], [-118.85513, 34.22716], [-118.85534, 34.2274], [-118.85546, 34.22758], [-118.85548, 34.2277], [-118.8554, 34.22776], [-118.85536, 34.22784], [-118.8554, 34.22794], [-118.85552, 34.22798], [-118.85556, 34.22802]]]} | Open Access 1 | 18181 | Northwood Field | 22900 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 7.839 | Northwood Field | 0 | Local Recreation Area 3 | 4 | |
10446 | 10446 | 10445 | {"type": "Polygon", "coordinates": [[[-118.95865, 34.19332], [-118.95755, 34.19292], [-118.95737, 34.19284], [-118.95543, 34.19225], [-118.95497, 34.19215], [-118.95454, 34.1921], [-118.95313, 34.192], [-118.95307, 34.19196], [-118.95304, 34.1919], [-118.95305, 34.19182], [-118.95365, 34.19111], [-118.95394, 34.19075], [-118.9541, 34.19049], [-118.95425, 34.19017], [-118.95433, 34.18995], [-118.95446, 34.18936], [-118.9546, 34.18932], [-118.95462, 34.18962], [-118.95466, 34.1898], [-118.95475, 34.19004], [-118.95485, 34.19022], [-118.95502, 34.19035], [-118.95578, 34.19075], [-118.95652, 34.19106], [-118.95708, 34.19122], [-118.95785, 34.19139], [-118.95836, 34.19156], [-118.9586, 34.19168], [-118.95868, 34.19177], [-118.95874, 34.19188], [-118.95877, 34.192], [-118.95865, 34.19332]]]} | Open Access 1 | 18483 | Pepper Tree Playfield | 23595 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 22.244 | Pepper Tree Playfield | 0 | Local Recreation Area 3 | 4 | |
16805 | 16805 | 16804 | {"type": "Polygon", "coordinates": [[[-118.90091, 34.2165], [-118.90088, 34.21655], [-118.90042, 34.2164], [-118.90045, 34.21635], [-118.90091, 34.2165]]]} | Open Access 1 | 15583 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.068 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
13472 | 13472 | 13471 | {"type": "Polygon", "coordinates": [[[-121.80194, 39.64878], [-121.80091, 39.64895], [-121.80036, 39.64752], [-121.80032, 39.64731], [-121.80034, 39.64725], [-121.80107, 39.64708], [-121.80118, 39.64737], [-121.80146, 39.6475], [-121.80194, 39.64878]]]} | Open Access 1 | 35731 | Durham Recreation and Park District 1 | 18313 | 2030 | Durham Recreation and Park District 1060 | Special District 4 | Recreation/Parks District 4 | http://www.durhamrec.com/ | Special District 4 | 2030 | Durham Recreation and Park District 1018 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 4.222 | Durham Rec. and Park District 1 | 0 | Local Recreation Area 3 | 4 | |
13473 | 13473 | 13472 | {"type": "Polygon", "coordinates": [[[-121.77925, 39.64587], [-121.77474, 39.646], [-121.77471, 39.64458], [-121.77478, 39.64455], [-121.77507, 39.64437], [-121.77532, 39.64415], [-121.77556, 39.64373], [-121.77523, 39.64316], [-121.77663, 39.64268], [-121.77925, 39.64587]]]} | Open Access 1 | 35730 | Durham Recreation and Park District 2 | 18314 | 2030 | Durham Recreation and Park District 1060 | Special District 4 | Recreation/Parks District 4 | http://www.durhamrec.com/ | Special District 4 | 2030 | Durham Recreation and Park District 1018 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 21.557 | Durham Rec. and Park District 2 | 0 | Local Recreation Area 3 | 4 | |
16829 | 16829 | 16828 | {"type": "Polygon", "coordinates": [[[-121.76741, 39.55063], [-121.76703, 39.55071], [-121.76672, 39.54986], [-121.76666, 39.54986], [-121.76665, 39.54988], [-121.76696, 39.55072], [-121.76658, 39.55081], [-121.76622, 39.54984], [-121.76705, 39.54966], [-121.76741, 39.55063]]]} | Open Access 1 | 35629 | Durham Recreation and Park District 3 | 18315 | 2030 | Durham Recreation and Park District 1060 | Special District 4 | Recreation/Parks District 4 | http://www.durhamrec.com/ | Special District 4 | 2030 | Durham Recreation and Park District 1018 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 1.89 | Durham Rec. and Park District 3 | 0 | 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]);