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
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- East Bay Regional Park District 25
- Sunrise Recreation and Park District 12
- Conejo Recreation and Park District 10
- Rancho Simi Recreation and Park District 9
- Valley-Wide Recreation and Park District 7
- Hayward Area Recreation and Park District 7
- Isla Vista Recreation and Park District 6
- Monterey Peninsula Regional Park District 4
- Desert Recreation District 4
- Southgate Recreation and 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
- Durham Recreation and Park District 3
- Jurupa Area Recreation and Park District 2
- North of the River Recreation and Park District 2
- Auburn Area Recreation and Park District 2
- Pleasant Hill Recreation and Park District 2
- West Side Recreation and Park District 2
- Hesperia Recreation and Park District 2
- Orangevale Recreation and Park District 2
- Weed Recreation and Parks District 2
- Barstow 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
- Rio Linda Elverta Recreation and Park District 1
- Monte Rio Recreation and Park District 1
- …
LAYER 6 ✖
ACCESS_TYP 3
MNG_AG_TYP 1
- Recreation/Parks District · 144 ✖
DES_TP 1
- Local Recreation Area · 144 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3646 | 3646 | 3645 | {"type": "Polygon", "coordinates": [[[-122.09719, 37.88699], [-122.0967, 37.88654], [-122.09593, 37.88668], [-122.09517, 37.88629], [-122.09471, 37.88637], [-122.09407, 37.88659], [-122.09356, 37.88625], [-122.09322, 37.88618], [-122.0933, 37.88612], [-122.0934, 37.8861], [-122.09615, 37.88602], [-122.09669, 37.88602], [-122.09723, 37.88606], [-122.09727, 37.88609], [-122.09728, 37.88613], [-122.09719, 37.88664], [-122.09719, 37.88699]]]} | Open Access 1 | 29549 | Lafayette/Moraga Trail | 20836 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 4.276 | Lafayette/Moraga Trail | 0 | Local Recreation Area 3 | 4 | |
3715 | 3715 | 3714 | {"type": "Polygon", "coordinates": [[[-118.79784, 34.25155], [-118.79749, 34.25203], [-118.7975, 34.25248], [-118.79724, 34.25295], [-118.79723, 34.2536], [-118.79568, 34.2533], [-118.7955, 34.25324], [-118.79538, 34.25317], [-118.79528, 34.25324], [-118.7952, 34.25343], [-118.79525, 34.25345], [-118.7954, 34.25372], [-118.79566, 34.25383], [-118.79597, 34.25401], [-118.79541, 34.25383], [-118.79527, 34.25375], [-118.79518, 34.2538], [-118.79509, 34.25364], [-118.79508, 34.25348], [-118.7952, 34.2532], [-118.79531, 34.2531], [-118.79523, 34.25299], [-118.79518, 34.25288], [-118.79515, 34.25275], [-118.79516, 34.25265], [-118.79518, 34.25254], [-118.79548, 34.25178], [-118.79559, 34.25128], [-118.79649, 34.25136], [-118.79776, 34.25144], [-118.79782, 34.25149], [-118.79784, 34.25155]]]} | Open Access 1 | 44685 | Sinaloa Youth Ball Fields | 25516 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 11.424 | Sinaloa Youth Ball Fields | 0 | Local Recreation Area 3 | 4 | |
3733 | 3733 | 3732 | {"type": "MultiPolygon", "coordinates": [[[[-122.03357, 37.90414], [-122.03346, 37.90426], [-122.03345, 37.904], [-122.0335, 37.90405], [-122.03357, 37.90414]]], [[[-122.04019, 37.90842], [-122.03957, 37.90859], [-122.03754, 37.90726], [-122.03826, 37.90623], [-122.03875, 37.90662], [-122.03905, 37.9069], [-122.03939, 37.90741], [-122.03961, 37.90803], [-122.04019, 37.90842]]]]} | Open Access 1 | 31016 | Briones to Mount Diablo Trail | 33752 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 5.904 | Briones to Mount Diablo Trail | 0 | Local Recreation Area 3 | 4 | |
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 | |
4346 | 4346 | 4345 | {"type": "Polygon", "coordinates": [[[-119.27012, 35.49626], [-119.27011, 35.49689], [-119.26949, 35.49688], [-119.26949, 35.49626], [-119.27012, 35.49626]]]} | Open Access 1 | 48440 | Skate Park | 33145 | 2149 | Shafter Recreation and Park District 436 | Special District 4 | Recreation/Parks District 4 | http://shafterrecreation.com/ | Special District 4 | 2149 | Shafter Recreation and Park District 430 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 0.977 | Skate Park | 2001 | Local Recreation Area 3 | 4 | |
4860 | 4860 | 4859 | {"type": "Polygon", "coordinates": [[[-118.8224, 34.295], [-118.82168, 34.29571], [-118.82099, 34.29626], [-118.8176, 34.29545], [-118.81217, 34.29678], [-118.80476, 34.30392], [-118.79639, 34.30984], [-118.79638, 34.3044], [-118.80047, 34.30326], [-118.80195, 34.30167], [-118.80796, 34.29721], [-118.8082, 34.29486], [-118.80973, 34.29297], [-118.81042, 34.29304], [-118.81081, 34.29253], [-118.81063, 34.29221], [-118.81146, 34.29191], [-118.81295, 34.29197], [-118.81497, 34.29179], [-118.8156, 34.29223], [-118.81725, 34.2923], [-118.81836, 34.29215], [-118.81865, 34.29188], [-118.819, 34.29232], [-118.8199, 34.292], [-118.82059, 34.29224], [-118.82079, 34.29209], [-118.82145, 34.29225], [-118.82176, 34.29316], [-118.82239, 34.2945], [-118.8224, 34.295]]]} | Open Access 1 | 48520 | Alamos Canyon Open Space | 33233 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/simi_valley/trails/alamoscanyon.php | Ventura 8 | 281.33 | Alamos Canyon OS | 2016 | 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 | |
5079 | 5079 | 5078 | {"type": "Polygon", "coordinates": [[[-119.01469, 34.22393], [-119.01462, 34.2239], [-119.01463, 34.22384], [-119.01461, 34.22379], [-119.01469, 34.22376], [-119.01469, 34.22393]]]} | Open Access 1 | 15062 | Pleasant Valley Recreation and Park District | 23802 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.025 | Pleasant Valley Rec. and Park District | 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 | |
5811 | 5811 | 5810 | {"type": "Polygon", "coordinates": [[[-121.86002, 36.60779], [-121.85928, 36.6088], [-121.85829, 36.60932], [-121.85798, 36.6093], [-121.85783, 36.60901], [-121.86002, 36.60779]]]} | Open Access 1 | 114 | Roberts Lake Open Space | 24493 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 2.374 | Roberts Lake OS | 0 | Local Recreation Area 3 | 4 | |
6007 | 6007 | 6006 | {"type": "Polygon", "coordinates": [[[-121.85372, 37.67067], [-121.84528, 37.67162], [-121.84527, 37.67159], [-121.83346, 37.67283], [-121.83347, 37.66804], [-121.83003, 37.6675], [-121.83007, 37.66576], [-121.83764, 37.66573], [-121.84017, 37.66573], [-121.84066, 37.66594], [-121.84179, 37.66599], [-121.84221, 37.66575], [-121.84532, 37.66574], [-121.84531, 37.66757], [-121.84781, 37.6683], [-121.84917, 37.6683], [-121.85004, 37.66837], [-121.85104, 37.66906], [-121.85107, 37.66961], [-121.85181, 37.66963], [-121.8524, 37.66936], [-121.85336, 37.66841], [-121.85372, 37.67067]]]} | Open Access 1 | 690 | Shadow Cliffs Regional Recreation Area | 3312 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/shadow_cliffs | Alameda 17 | 253.728 | Shadow Cliffs Reg. Rec. Area | 1971 | Local Recreation Area 3 | 4 |
6193 | 6193 | 6192 | {"type": "Polygon", "coordinates": [[[-121.56192, 36.44252], [-121.55756, 36.4424], [-121.55754, 36.43877], [-121.54888, 36.43855], [-121.54884, 36.44575], [-121.53978, 36.4455], [-121.53984, 36.4346], [-121.53079, 36.43424], [-121.53081, 36.43057], [-121.53085, 36.42693], [-121.53987, 36.42728], [-121.53986, 36.43096], [-121.5489, 36.43134], [-121.54889, 36.43494], [-121.56186, 36.43525], [-121.56192, 36.44252]]]} | Restricted Access 2 | 18578 | Bloomquist Open Space | 16170 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 639.336 | Bloomquist OS | 0 | Local Recreation Area 3 | 4 | |
6263 | 6263 | 6262 | {"type": "Polygon", "coordinates": [[[-121.79058, 36.52123], [-121.79045, 36.52142], [-121.79048, 36.52155], [-121.79052, 36.52163], [-121.79026, 36.52171], [-121.7886, 36.52066], [-121.78871, 36.52058], [-121.78783, 36.5197], [-121.78919, 36.51943], [-121.7892, 36.51992], [-121.78948, 36.52042], [-121.78993, 36.52087], [-121.79025, 36.52083], [-121.79058, 36.52123]]]} | No Public Access 3 | 1348 | Thomas Open Space | 26308 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 5.313 | Thomas OS | 0 | Local Recreation Area 3 | 4 | |
6383 | 6383 | 6382 | {"type": "Polygon", "coordinates": [[[-119.0282, 34.21507], [-119.0282, 34.21519], [-119.02817, 34.21524], [-119.02776, 34.21535], [-119.02732, 34.2154], [-119.02622, 34.21542], [-119.02514, 34.21542], [-119.02397, 34.21533], [-119.01761, 34.21534], [-119.01763, 34.21524], [-119.01764, 34.21448], [-119.0177, 34.2143], [-119.01781, 34.21412], [-119.01794, 34.21399], [-119.01809, 34.21389], [-119.01903, 34.21345], [-119.01921, 34.21335], [-119.02238, 34.21332], [-119.02239, 34.21316], [-119.02246, 34.21317], [-119.02253, 34.21316], [-119.02254, 34.21318], [-119.02504, 34.21316], [-119.0251, 34.2132], [-119.02517, 34.21321], [-119.02525, 34.21319], [-119.02532, 34.21313], [-119.02817, 34.21311], [-119.02819, 34.2149], [-119.02816, 34.21499], [-119.0282, 34.21507]]]} | Open Access 1 | 48374 | Pleasant Valley Fields | 32941 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/parks/park_list/pleasant_valley_fields.asp | Ventura 8 | 54.848 | Pleasant Valley Fields | 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 | |
6437 | 6437 | 6436 | {"type": "Polygon", "coordinates": [[[-117.13372, 34.48655], [-117.12931, 34.48651], [-117.12931, 34.48533], [-117.13037, 34.48459], [-117.13067, 34.48392], [-117.13217, 34.48391], [-117.1327, 34.48343], [-117.13274, 34.48292], [-117.13251, 34.48283], [-117.13251, 34.48129], [-117.13371, 34.48132], [-117.13372, 34.48655]]]} | Open Access 1 | 1957 | Horsemen's Center | 20096 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 33.691 | Horsemen's Ctr. | 0 | Local Recreation Area 3 | 4 | ||
6461 | 6461 | 6460 | {"type": "Polygon", "coordinates": [[[-117.12666, 33.60337], [-117.12642, 33.60338], [-117.12634, 33.60344], [-117.12614, 33.60397], [-117.12609, 33.60403], [-117.126, 33.6041], [-117.12598, 33.60425], [-117.12589, 33.60441], [-117.12586, 33.6046], [-117.1258, 33.60466], [-117.1256, 33.60452], [-117.12526, 33.60422], [-117.1251, 33.60406], [-117.1251, 33.60402], [-117.12494, 33.60384], [-117.12488, 33.60381], [-117.12481, 33.60373], [-117.12455, 33.60333], [-117.12417, 33.60257], [-117.12433, 33.60226], [-117.12621, 33.60171], [-117.12635, 33.60165], [-117.12657, 33.60158], [-117.12657, 33.6023], [-117.12666, 33.60317], [-117.12666, 33.60337]]]} | Open Access 1 | 48389 | Spencer's Crossing Sports Park | 32953 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/spencer-s-crossing-sports-park | Riverside 10 | 11.573 | Spencer's Crossing Sports Park | 0 | Local Recreation Area 3 | 4 |
6591 | 6591 | 6590 | {"type": "Polygon", "coordinates": [[[-117.30782, 34.40725], [-117.30744, 34.40904], [-117.30711, 34.409], [-117.30688, 34.41009], [-117.30473, 34.40977], [-117.30544, 34.40652], [-117.30551, 34.4065], [-117.30775, 34.40682], [-117.30766, 34.40722], [-117.30782, 34.40725]]]} | Open Access 1 | 4164 | Lime Street Park/ Community Center | 21240 | 2227 | Hesperia Recreation and Park District 609 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 19.974 | Lime Street Park/ Community Ctr. | 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]);