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 AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, PARK_URL, COUNTY, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16901 | 16901 | 16900 | {"type": "Polygon", "coordinates": [[[-121.99742, 37.3099], [-121.99742, 37.31032], [-121.99733, 37.31095], [-121.99727, 37.311], [-121.99717, 37.311], [-121.99687, 37.31043], [-121.99662, 37.31014], [-121.99673, 37.31007], [-121.99654, 37.30984], [-121.99704, 37.30983], [-121.99736, 37.30986], [-121.9974, 37.3099], [-121.99742, 37.3099]]]} | Open Access 1 | 24310 | Rancho Rinconada Recreation Center | 24167 | 2251 | Rancho Rinconada Recreation and Park District 1180 | Special District 4 | Recreation/Parks District 4 | http://www.ranchoreccenter.com/ | Special District 4 | 2251 | Rancho Rinconada Recreation and Park District 1119 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 1.514 | Rancho Rinconada Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16900 | 16900 | 16899 | {"type": "Polygon", "coordinates": [[[-122.19908, 37.40441], [-122.19859, 37.40468], [-122.19843, 37.40469], [-122.19797, 37.40388], [-122.19864, 37.40363], [-122.19908, 37.40441]]]} | Open Access 1 | 24309 | Ladera Recreation Center | 20823 | 2233 | Ladera Recreation District 1179 | Special District 4 | Recreation/Parks District 4 | http://www.lrdrec.com/ | Special District 4 | 2233 | Ladera Recreation District 1118 | Special District 4 | Recreation/Parks District 4 | San Mateo 15 | 1.613 | Ladera Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16899 | 16899 | 16898 | {"type": "Polygon", "coordinates": [[[-122.34743, 37.51955], [-122.34676, 37.52049], [-122.34572, 37.52008], [-122.34668, 37.51877], [-122.34722, 37.51902], [-122.34701, 37.51936], [-122.34743, 37.51955]]]} | Open Access 1 | 24308 | Highlands Recreation Center | 19949 | 2228 | Highlands Recreation District 1178 | Special District 4 | Recreation/Parks District 4 | http://www.highlandsrec.com/ | Special District 4 | 2228 | Highlands Recreation District 1117 | Special District 4 | Recreation/Parks District 4 | San Mateo 15 | 3.66 | Highlands Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
15845 | 15845 | 15844 | {"type": "MultiPolygon", "coordinates": [[[[-118.37159, 33.76721], [-118.37139, 33.76744], [-118.37081, 33.76795], [-118.37054, 33.76809], [-118.37028, 33.76819], [-118.36988, 33.76826], [-118.36957, 33.76825], [-118.36931, 33.76821], [-118.36905, 33.76812], [-118.36801, 33.7677], [-118.3677, 33.76761], [-118.36738, 33.76756], [-118.36695, 33.76756], [-118.36722, 33.76751], [-118.36745, 33.76751], [-118.36778, 33.76756], [-118.36792, 33.7676], [-118.3693, 33.76817], [-118.36961, 33.76824], [-118.36984, 33.76825], [-118.37, 33.76823], [-118.37022, 33.76817], [-118.37042, 33.76808], [-118.37055, 33.76799], [-118.37068, 33.76788], [-118.37139, 33.76708], [-118.37138, 33.76701], [-118.37159, 33.76714], [-118.37159, 33.76721]]], [[[-118.3718, 33.76638], [-118.3718, 33.76662], [-118.37176, 33.76685], [-118.3717, 33.7669], [-118.37163, 33.76689], [-118.37158, 33.76686], [-118.37168, 33.7667], [-118.37175, 33.76655], [-118.37178, 33.76638], [-118.37178, 33.76628], [-118.3718, 33.76638]]]]} | Open Access 1 | 5926 | Ridgecrest Ranchos Open Space | 24353 | 2120 | Ridgecrest Ranchos Recreation and Park District 1162 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2120 | Ridgecrest Ranchos Recreation and Park District 1105 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 1.195 | Ridgecrest Ranchos OS | 0 | Local Recreation Area 3 | 4 | ||
15667 | 15667 | 15666 | {"type": "MultiPolygon", "coordinates": [[[[-117.78087, 34.13432], [-117.77956, 34.13623], [-117.77952, 34.13623], [-117.77668, 34.13961], [-117.77672, 34.13656], [-117.77842, 34.13656], [-117.77907, 34.13625], [-117.77907, 34.13623], [-117.77757, 34.13623], [-117.77816, 34.13544], [-117.78087, 34.13432]]], [[[-117.78553, 34.13746], [-117.7855, 34.13899], [-117.78448, 34.1382], [-117.78414, 34.13855], [-117.78324, 34.13797], [-117.78188, 34.13857], [-117.77931, 34.14076], [-117.77831, 34.14213], [-117.7783, 34.14331], [-117.77675, 34.14332], [-117.77677, 34.13975], [-117.77972, 34.13625], [-117.77971, 34.13623], [-117.78, 34.1358], [-117.78077, 34.1347], [-117.78082, 34.13473], [-117.78093, 34.13461], [-117.7812, 34.13438], [-117.78164, 34.13411], [-117.78274, 34.13355], [-117.78304, 34.13334], [-117.78316, 34.13323], [-117.78323, 34.1332], [-117.78327, 34.1332], [-117.78333, 34.13323], [-117.7842, 34.13378], [-117.78317, 34.13427], [-117.78294, 34.13488], [-117.78326, 34.13531], [-117.78441, 34.13592], [-117.78436, 34.13609], [-117.78435, 34.13626], [-117.78438, 34.13643], [-117.78449, 34.13664], [-117.78468, 34.13683], [-117.78553, 34.13746]], [[-117.78214, 34.13578], [-117.78214, 34.13579], [-117.78231, 34.13592], [-117.78253, 34.13571], [-117.78235, 34.13558], [-117.78214, 34.13578]]]]} | Restricted Access 2 | 6754 | San Dimas Canyon Golf Course | 33021 | 2135 | San Dimas-La Verne Recreational Facilities Authority 1160 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2135 | San Dimas-La Verne Recreational Facilities Authority 1104 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 103.27 | San Dimas Canyon GC | 0 | Local Recreation Area 3 | 4 | ||
14329 | 14329 | 14328 | {"type": "Polygon", "coordinates": [[[-122.38715, 41.43835], [-122.38702, 41.43886], [-122.38616, 41.43867], [-122.38561, 41.43852], [-122.38556, 41.43846], [-122.38554, 41.43836], [-122.38559, 41.43811], [-122.38715, 41.43835]]]} | Open Access 1 | 48856 | Weed Skate Park | 33576 | 2352 | Weed Recreation and Parks District 1109 | Special District 4 | Recreation/Parks District 4 | http://weedrec.org/?page_id=45 | Special District 4 | 2352 | Weed Recreation and Parks District 1063 | Special District 4 | Recreation/Parks District 4 | https://www.northwestskater.com/weed.html | Siskiyou 28 | 1.645 | Weed Skate Park | 0 | Local Recreation Area 3 | 4 |
15010 | 15010 | 15009 | {"type": "Polygon", "coordinates": [[[-122.37462, 41.42859], [-122.37445, 41.42883], [-122.37449, 41.43002], [-122.37448, 41.43012], [-122.37445, 41.43022], [-122.37434, 41.43039], [-122.37363, 41.43074], [-122.37282, 41.43009], [-122.37198, 41.42915], [-122.37413, 41.42841], [-122.37462, 41.42859]]]} | Open Access 1 | 45662 | Sons Park and Lobis Field | 28478 | 2352 | Weed Recreation and Parks District 1109 | Special District 4 | Recreation/Parks District 4 | http://weedrec.org/?page_id=45 | Special District 4 | 2352 | Weed Recreation and Parks District 1063 | Special District 4 | Recreation/Parks District 4 | http://weedrec.org/?page_id=45 | Siskiyou 28 | 8.3 | Sons Park and Lobis Field | 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 | |
12353 | 12353 | 12352 | {"type": "MultiPolygon", "coordinates": [[[[-123.01059, 38.48345], [-123.01015, 38.48391], [-123.00931, 38.48364], [-123.00931, 38.48303], [-123.01059, 38.48345]]], [[[-123.01075, 38.48424], [-123.01068, 38.48437], [-123.01059, 38.48435], [-123.01053, 38.48446], [-123.01034, 38.4843], [-123.01049, 38.48402], [-123.01075, 38.48424]]], [[[-123.01166, 38.4834], [-123.01106, 38.48346], [-123.01091, 38.48354], [-123.01092, 38.48356], [-123.01119, 38.48364], [-123.01093, 38.48417], [-123.01056, 38.48386], [-123.01054, 38.48387], [-123.01049, 38.48383], [-123.01078, 38.48354], [-123.01103, 38.48341], [-123.01165, 38.48335], [-123.01166, 38.4834]]]]} | Open Access 1 | 26077 | Vacation Beach Playground | 26752 | 2254 | Russian River Recreation and Park District 1020 | Special District 4 | Recreation/Parks District 4 | http://russianriverrecpark.org/ | Special District 4 | 2254 | Russian River Recreation and Park District 982 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 2.431 | Vacation Beach Playground | 0 | Local Recreation Area 3 | 4 | |
17038 | 17038 | 17037 | {"type": "Polygon", "coordinates": [[[-121.38028, 38.71566], [-121.37876, 38.71566], [-121.37877, 38.71427], [-121.37896, 38.71426], [-121.37894, 38.71421], [-121.37891, 38.71418], [-121.3788, 38.71416], [-121.3788, 38.71329], [-121.38008, 38.71329], [-121.38006, 38.71389], [-121.38001, 38.71466], [-121.38007, 38.71497], [-121.38027, 38.71498], [-121.38028, 38.71566]]]} | Open Access 1 | 28341 | Capehart Youth Center | 16833 | 2284 | North Highland Recreation and Park District 985 | Special District 4 | Recreation/Parks District 4 | http://www.nhrpd.org/Default.htm | Special District 4 | 2284 | North Highland Recreation and Park District 949 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 7.519 | Capehart Youth Ctr. | 0 | Local Recreation Area 3 | 4 | |
16825 | 16825 | 16824 | {"type": "Polygon", "coordinates": [[[-121.26899, 38.64206], [-121.26899, 38.6423], [-121.26893, 38.64231], [-121.26893, 38.64271], [-121.26784, 38.64272], [-121.26759, 38.64241], [-121.2679, 38.64212], [-121.26823, 38.64212], [-121.26832, 38.64204], [-121.26845, 38.64198], [-121.26857, 38.64197], [-121.26879, 38.64198], [-121.2689, 38.64201], [-121.26899, 38.64206]]]} | Open Access 1 | 35491 | Fair Oaks Recreation and Park District 1 | 18789 | 2221 | Fair Oaks Recreation and Park District 975 | Special District 4 | Recreation/Parks District 4 | http://www.fairoakspark.org/ | Special District 4 | 2221 | Fair Oaks Recreation and Park District 940 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.942 | Fair Oaks Rec. and Park District 1 | 0 | Local Recreation Area 3 | 4 | |
11625 | 11625 | 11624 | {"type": "Polygon", "coordinates": [[[-121.22526, 38.68849], [-121.22521, 38.69119], [-121.22305, 38.69116], [-121.2231, 38.68846], [-121.22368, 38.68846], [-121.22368, 38.68855], [-121.22395, 38.68855], [-121.22396, 38.68847], [-121.22526, 38.68849]]]} | Open Access 1 | 23899 | Orangevale Community Center & Pool Complex | 23180 | 2248 | Orangevale Recreation and Park District 928 | Special District 4 | Recreation/Parks District 4 | http://www.orangevalecommunitycenter.com/ | Special District 4 | 2248 | Orangevale Recreation and Park District 901 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 13.892 | Orangevale Community Ctr. & Pool Complex | 0 | Local Recreation Area 3 | 4 | |
11849 | 11849 | 11848 | {"type": "Polygon", "coordinates": [[[-121.21603, 38.68469], [-121.21601, 38.68554], [-121.21259, 38.68548], [-121.21264, 38.68378], [-121.21382, 38.6838], [-121.21381, 38.68467], [-121.21603, 38.68469]]]} | Open Access 1 | 24283 | Orangevale Sports Fields | 23183 | 2248 | Orangevale Recreation and Park District 928 | Special District 4 | Recreation/Parks District 4 | http://www.orangevalecommunitycenter.com/ | Special District 4 | 2248 | Orangevale Recreation and Park District 901 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.309 | Orangevale Sports Fields | 0 | Local Recreation Area 3 | 4 | |
9412 | 9412 | 9411 | {"type": "MultiPolygon", "coordinates": [[[[-118.325, 33.74497], [-118.32496, 33.74508], [-118.32486, 33.74519], [-118.32456, 33.74533], [-118.32442, 33.74537], [-118.32395, 33.74544], [-118.32322, 33.74543], [-118.3231, 33.74545], [-118.32306, 33.74525], [-118.32227, 33.74479], [-118.32072, 33.74441], [-118.32074, 33.74435], [-118.32074, 33.74405], [-118.32121, 33.74405], [-118.32221, 33.74426], [-118.32253, 33.74419], [-118.32309, 33.74458], [-118.32347, 33.74443], [-118.32349, 33.74426], [-118.32378, 33.74428], [-118.32388, 33.74432], [-118.32395, 33.74437], [-118.32399, 33.74443], [-118.32399, 33.74446], [-118.32372, 33.74453], [-118.32355, 33.7448], [-118.32364, 33.745], [-118.32437, 33.7452], [-118.3247, 33.74515], [-118.3249, 33.74496], [-118.32482, 33.74477], [-118.32486, 33.74475], [-118.32491, 33.74475], [-118.32498, 33.74479], [-118.325, 33.74486], [-118.325, 33.74497]]], [[[-118.32439, 33.74432], [-118.32422, 33.74439], [-118.3242, 33.7443], [-118.32416, 33.74425], [-118.32407, 33.74417], [-118.32392, 33.74413], [-118.32376, 33.74413], [-118.3239, 33.74396], [-118.32439, 33.74432]]]]} | Open Access 1 | 47834 | Frascati Trail | 31776 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 5.92 | Frascati Trail | 0 | Local Recreation Area 3 | 4 | |
9521 | 9521 | 9520 | {"type": "Polygon", "coordinates": [[[-118.32587, 33.74145], [-118.32586, 33.74173], [-118.32563, 33.74185], [-118.32541, 33.7416], [-118.32474, 33.74161], [-118.32422, 33.74153], [-118.32393, 33.74164], [-118.32391, 33.74158], [-118.32401, 33.74154], [-118.32401, 33.74153], [-118.32329, 33.74095], [-118.32212, 33.74084], [-118.3217, 33.74095], [-118.32093, 33.74221], [-118.32075, 33.74221], [-118.32176, 33.74053], [-118.32318, 33.74066], [-118.32402, 33.74133], [-118.32477, 33.74147], [-118.32587, 33.74145]]]} | Open Access 1 | 47832 | Colinita Trail | 31775 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 3.136 | Colinita Trail | 0 | Local Recreation Area 3 | 4 | |
9534 | 9534 | 9533 | {"type": "MultiPolygon", "coordinates": [[[[-118.32508, 33.74836], [-118.32478, 33.74839], [-118.32442, 33.74859], [-118.3242, 33.74879], [-118.32384, 33.74839], [-118.32179, 33.74742], [-118.32161, 33.74723], [-118.32105, 33.74759], [-118.32094, 33.74748], [-118.3215, 33.74711], [-118.32094, 33.7465], [-118.32031, 33.74623], [-118.3199, 33.74579], [-118.31989, 33.7457], [-118.32, 33.74568], [-118.3201, 33.74562], [-118.32024, 33.74572], [-118.32031, 33.74572], [-118.32037, 33.74575], [-118.32054, 33.74589], [-118.32066, 33.74602], [-118.32075, 33.74605], [-118.32085, 33.74605], [-118.32097, 33.74599], [-118.32102, 33.7459], [-118.32101, 33.74581], [-118.32091, 33.74564], [-118.32093, 33.74564], [-118.32142, 33.74604], [-118.32229, 33.74651], [-118.32269, 33.74631], [-118.32274, 33.74637], [-118.32235, 33.74655], [-118.32235, 33.74656], [-118.32345, 33.74762], [-118.32367, 33.74772], [-118.32395, 33.74742], [-118.32419, 33.74758], [-118.32394, 33.74788], [-118.32439, 33.74816], [-118.32474, 33.74814], [-118.32486, 33.74801], [-118.32498, 33.74812], [-118.32504, 33.74824], [-118.32508, 33.74836]]], [[[-118.32085, 33.74589], [-118.32081, 33.74592], [-118.32078, 33.74592], [-118.32066, 33.74579], [-118.32054, 33.74569], [-118.32074, 33.74566], [-118.32085, 33.74585], [-118.32085, 33.74589]]]]} | Open Access 1 | 47835 | Sienna Loop Trail | 31777 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 9.915 | Sienna Loop Trail | 0 | Local Recreation Area 3 | 4 | |
9548 | 9548 | 9547 | {"type": "Polygon", "coordinates": [[[-118.31871, 33.75148], [-118.3186, 33.75159], [-118.3186, 33.7517], [-118.31842, 33.75196], [-118.31843, 33.74806], [-118.31846, 33.74607], [-118.31864, 33.74623], [-118.31866, 33.74651], [-118.31866, 33.7466], [-118.31862, 33.74662], [-118.31859, 33.75138], [-118.31871, 33.75148]]]} | Open Access 1 | 47839 | Lorraine Trail | 31782 | 2080 | Miraleste Recreation and Park District 912 | Special District 4 | Recreation/Parks District 4 | https://www.rpvca.gov/ | Special District 4 | 2080 | Miraleste Recreation and Park District 885 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 2.557 | Lorraine Trail | 0 | Local Recreation Area 3 | 4 | |
6713 | 6713 | 6712 | {"type": "Polygon", "coordinates": [[[-121.2326, 40.30976], [-121.23197, 40.31049], [-121.23162, 40.31034], [-121.23162, 40.31029], [-121.23127, 40.31012], [-121.23133, 40.31004], [-121.23107, 40.30991], [-121.23167, 40.30916], [-121.23253, 40.30955], [-121.2326, 40.30976]]]} | Open Access 1 | 48415 | Truman Collins Sports Complex | 33012 | 7030 | Collins Pine Company 841 | Private 7 | Commericial 30 | http://www.collinsco.com/ | Private 14 | 2427 | Almanor Recreation and Park District 818 | Special District 4 | Recreation/Parks District 4 | https://ceqanet.opr.ca.gov/2003038103 | Plumas 57 | 2.653 | Truman Collins Sports Complex | 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]);