units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
46 rows where ACCESS_TYP = 2, DES_TP = 3 and LAYER = 4
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, PARK_URL, COUNTY
MNG_AGENCY >30
- Santa Ana, City of 4
- Rancho Simi Recreation and Park District 2
- San Bernardino, City of 2
- Hollister, City of 2
- Hayward Area Recreation and Park District 2
- Conejo Open Space Conservation Agency 2
- San Gabriel, City of 2
- Culver City Unified School District 2
- Nevada Irrigation District 2
- San Diego, City of 1
- Conejo Recreation and Park District 1
- Monterey Peninsula Regional Park District 1
- Yorba Linda, City of 1
- San Ramon, City of 1
- Huntington Park, City of 1
- Sonoma County Water Agency 1
- Carlsbad, City of 1
- Burbank, City of 1
- Valley-Wide Recreation and Park District 1
- Needles, City of 1
- El Segundo, City of 1
- La Verne, City of 1
- La Canada Flintridge, City of 1
- Pico Rivera, City of 1
- Brooktrails Community Services District 1
- Lawndale, City of 1
- Southgate Recreation and Park District 1
- La Quinta, City of 1
- Los Angeles Unified School District 1
- Calleguas Municipal Water District 1
- …
MNG_AG_TYP 9
DES_TP 1
- Local Recreation Area · 46 ✖
ACCESS_TYP 1
- Restricted Access · 46 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2099 | 2099 | 2098 | {"type": "Polygon", "coordinates": [[[-121.94503, 37.73765], [-121.94369, 37.73818], [-121.94322, 37.73744], [-121.94227, 37.7378], [-121.94234, 37.73798], [-121.94192, 37.73811], [-121.94168, 37.73772], [-121.94145, 37.73739], [-121.94426, 37.7363], [-121.9444, 37.73653], [-121.94433, 37.7366], [-121.94433, 37.73668], [-121.94438, 37.73674], [-121.94449, 37.73676], [-121.94503, 37.73765]]]} | Restricted Access 2 | 47569 | Pine Valley Middle School Parks and Community Gym | 31294 | 2309 | San Ramon Valley Unified School District 478 | Special District 4 | School District 14 | http://www.srvusd.net/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 8.075 | Pine Valley Middle School Parks and Community Gym | 0 | Local Recreation Area 3 | 4 | |
| 2890 | 2890 | 2889 | {"type": "Polygon", "coordinates": [[[-121.39678, 36.84126], [-121.39678, 36.84159], [-121.39616, 36.84157], [-121.39614, 36.84183], [-121.39515, 36.8418], [-121.39507, 36.842], [-121.39507, 36.84215], [-121.39527, 36.84217], [-121.39527, 36.84247], [-121.39543, 36.84248], [-121.39542, 36.84336], [-121.39404, 36.84334], [-121.39252, 36.84106], [-121.39624, 36.84113], [-121.39633, 36.8412], [-121.39644, 36.84126], [-121.39678, 36.84126]]]} | Restricted Access 2 | 18924 | Rancho San Justo Sports Complex | 32730 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | San Benito 38 | 13.179 | Rancho San Justo Sports Complex | 0 | Local Recreation Area 3 | 4 | |
| 4411 | 4411 | 4410 | {"type": "Polygon", "coordinates": [[[-118.35352, 34.18058], [-118.3535, 34.18106], [-118.35346, 34.18107], [-118.35306, 34.18107], [-118.35307, 34.18057], [-118.35352, 34.18058]]]} | Restricted Access 2 | 46266 | Maple Street Playground | 31626 | 2391 | Burbank Unified School District 759 | Special District 4 | School District 14 | http://www.burbankusd.org/ | Special District 4 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/maple-street-playground | Los Angeles 6 | 0.55 | Maple Street Playground | 0 | Local Recreation Area 3 | 4 |
| 4949 | 4949 | 4948 | {"type": "Polygon", "coordinates": [[[-118.41083, 34.01373], [-118.40949, 34.01447], [-118.4092, 34.01411], [-118.4095, 34.01394], [-118.40926, 34.01364], [-118.40988, 34.01309], [-118.4101, 34.0127], [-118.41032, 34.01298], [-118.41025, 34.01312], [-118.41049, 34.01342], [-118.41056, 34.01339], [-118.41083, 34.01373]]]} | Restricted Access 2 | 3031 | La Ballona Playground | 29387 | 2367 | Culver City Unified School District 789 | Special District 4 | School District 14 | http://www.ccusd.org/ | Special District 4 | 2367 | Culver City Unified School District 768 | Special District 4 | School District 21 | Los Angeles 6 | 3.369 | La Ballona Playground | 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 | |
| 5739 | 5739 | 5738 | {"type": "Polygon", "coordinates": [[[-117.86368, 33.71492], [-117.86366, 33.71591], [-117.86257, 33.71591], [-117.86257, 33.715], [-117.86248, 33.71499], [-117.86248, 33.71487], [-117.86359, 33.71488], [-117.86359, 33.71492], [-117.86368, 33.71492]]]} | Restricted Access 2 | 47437 | Monroe Elementary School Field | 31153 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 2.918 | Monroe Elementary School Field | 0 | Local Recreation Area 3 | 4 | |
| 5740 | 5740 | 5739 | {"type": "Polygon", "coordinates": [[[-117.90815, 33.749], [-117.90761, 33.74987], [-117.90711, 33.75063], [-117.9066, 33.75137], [-117.9061, 33.75206], [-117.90563, 33.75177], [-117.9056, 33.75179], [-117.90382, 33.75069], [-117.90435, 33.74984], [-117.90502, 33.75014], [-117.90503, 33.75021], [-117.90483, 33.75055], [-117.90576, 33.75095], [-117.90624, 33.75015], [-117.90651, 33.75028], [-117.90653, 33.75028], [-117.90651, 33.74904], [-117.90667, 33.74904], [-117.90668, 33.74906], [-117.90714, 33.74906], [-117.90715, 33.74901], [-117.90815, 33.749]]]} | Restricted Access 2 | 47438 | Spurgeon Intermediate School Field | 31154 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 12.376 | Spurgeon Intermediate School Field | 0 | 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 | |
| 6317 | 6317 | 6316 | {"type": "Polygon", "coordinates": [[[-117.28211, 34.15967], [-117.28207, 34.15968], [-117.28207, 34.16048], [-117.28042, 34.16048], [-117.28041, 34.16006], [-117.28015, 34.16006], [-117.28015, 34.15949], [-117.28008, 34.15948], [-117.28007, 34.15884], [-117.2821, 34.15884], [-117.28211, 34.15967]]]} | Restricted Access 2 | 47434 | Golden Valley School Field | 31151 | 2314 | San Bernardino City Unified School District 832 | Special District 4 | School District 14 | http://www.sbcusd.k12.ca.us/ | Special District 4 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 7.872 | Golden Valley School Field | 0 | Local Recreation Area 3 | 4 | |
| 6328 | 6328 | 6327 | {"type": "Polygon", "coordinates": [[[-117.89836, 33.72183], [-117.8983, 33.72317], [-117.89797, 33.72315], [-117.89796, 33.72316], [-117.89797, 33.72355], [-117.89832, 33.72355], [-117.89835, 33.72428], [-117.8943, 33.72425], [-117.8943, 33.72338], [-117.89435, 33.72295], [-117.89452, 33.72237], [-117.89471, 33.72195], [-117.89481, 33.72179], [-117.89488, 33.72177], [-117.89525, 33.72176], [-117.89683, 33.72176], [-117.897, 33.72177], [-117.89752, 33.72184], [-117.89836, 33.72183]]]} | Restricted Access 2 | 47436 | Valley High School Field | 31152 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 24.28 | Valley High School Field | 0 | Local Recreation Area 3 | 4 | |
| 6335 | 6335 | 6334 | {"type": "Polygon", "coordinates": [[[-117.91058, 33.72179], [-117.91047, 33.72176], [-117.91041, 33.72186], [-117.91048, 33.72189], [-117.91044, 33.72198], [-117.91045, 33.722], [-117.91032, 33.72232], [-117.91024, 33.72234], [-117.91017, 33.72238], [-117.91007, 33.72251], [-117.90997, 33.7225], [-117.90995, 33.72254], [-117.90986, 33.72251], [-117.90986, 33.72247], [-117.90977, 33.72248], [-117.9096, 33.72254], [-117.90953, 33.72264], [-117.90952, 33.72269], [-117.9094, 33.72266], [-117.90937, 33.72271], [-117.90927, 33.7227], [-117.90916, 33.72291], [-117.90914, 33.72327], [-117.90867, 33.72327], [-117.90855, 33.72329], [-117.90838, 33.72335], [-117.90792, 33.72336], [-117.90848, 33.72176], [-117.90871, 33.72179], [-117.90924, 33.72182], [-117.90951, 33.72176], [-117.90978, 33.72154], [-117.90996, 33.72132], [-117.91058, 33.72179]]]} | Restricted Access 2 | 47439 | Hector G. Godinez High School Field | 31155 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.664 | Hector G. Godinez High School Field | 0 | Local Recreation Area 3 | 4 | |
| 6341 | 6341 | 6340 | {"type": "Polygon", "coordinates": [[[-117.84173, 33.89423], [-117.83972, 33.89424], [-117.83966, 33.89199], [-117.8408, 33.89197], [-117.84079, 33.89285], [-117.84024, 33.89286], [-117.84024, 33.89331], [-117.84092, 33.89332], [-117.84092, 33.89378], [-117.84123, 33.89378], [-117.84122, 33.89348], [-117.84171, 33.89348], [-117.84173, 33.89423]]]} | Restricted Access 2 | 47441 | Rose Drive Elementary School Recreational Facilities | 31157 | 2410 | Placentia-Yorba Linda Unified School District 833 | Special District 4 | School District 14 | http://www.pylusd.org/ | Special District 4 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 7.295 | Rose Drive Elementary School Recreational Facilities | 0 | Local Recreation Area 3 | 4 | |
| 6617 | 6617 | 6616 | {"type": "Polygon", "coordinates": [[[-118.39361, 34.0222], [-118.39299, 34.02292], [-118.39286, 34.02283], [-118.39221, 34.02248], [-118.39279, 34.02174], [-118.39361, 34.0222]]]} | Restricted Access 2 | 4230 | Linwood E. Howe Playground | 29386 | 2367 | Culver City Unified School District 789 | Special District 4 | School District 14 | http://www.ccusd.org/ | Special District 4 | 2367 | Culver City Unified School District 768 | Special District 4 | School District 21 | Los Angeles 6 | 2.149 | Linwood E. Howe Playground | 0 | Local Recreation Area 3 | 4 | |
| 7261 | 7261 | 7260 | {"type": "Polygon", "coordinates": [[[-118.83515, 34.23259], [-118.83311, 34.24265], [-118.82882, 34.24621], [-118.81532, 34.23954], [-118.81766, 34.23382], [-118.81607, 34.2271], [-118.81847, 34.22638], [-118.8202, 34.22678], [-118.82229, 34.22626], [-118.82297, 34.22618], [-118.82348, 34.22618], [-118.82412, 34.22632], [-118.82474, 34.22653], [-118.82541, 34.22649], [-118.82606, 34.22664], [-118.83021, 34.22816], [-118.8305, 34.22913], [-118.83515, 34.23259]]]} | Restricted Access 2 | 49003 | Calleguas Municipal Water District Open Space | 33702 | 2441 | Calleguas Municipal Water District 855 | Special District 4 | Water District 13 | http://www.calleguas.com/ | Special District 4 | 2441 | Calleguas Municipal Water District 833 | Special District 4 | Water District 13 | Ventura 8 | 702.738 | Calleguas Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
| 7453 | 7453 | 7452 | {"type": "Polygon", "coordinates": [[[-121.96985, 37.35893], [-121.96981, 37.35894], [-121.96977, 37.359], [-121.96974, 37.359], [-121.96972, 37.35903], [-121.96973, 37.35906], [-121.96901, 37.3589], [-121.96895, 37.35886], [-121.96892, 37.3588], [-121.96887, 37.35846], [-121.96961, 37.35847], [-121.96975, 37.3589], [-121.96985, 37.35888], [-121.96985, 37.35893]]]} | Restricted Access 2 | 48942 | Santa Clara Skate Park | 33658 | 2440 | Santa Clara Unified School District 865 | Special District 4 | School District 14 | https://www.santaclarausd.org/ | Special District 4 | 2440 | Santa Clara Unified School District 843 | Special District 4 | School District 21 | https://www.santaclaraca.gov/our-city/departments-g-z/parks-recreation/community-centers/skate-park | Santa Clara 19 | 0.964 | Santa Clara Skate Park | 0 | Local Recreation Area 3 | 4 |
| 8997 | 8997 | 8996 | {"type": "MultiPolygon", "coordinates": [[[[-122.04337, 37.62404], [-122.0433, 37.62429], [-122.04202, 37.62518], [-122.04029, 37.62378], [-122.04286, 37.62379], [-122.0431, 37.62411], [-122.04331, 37.62396], [-122.04337, 37.62404]]], [[[-122.05058, 37.62653], [-122.04861, 37.62811], [-122.04838, 37.62793], [-122.0453, 37.62798], [-122.04225, 37.62538], [-122.04346, 37.62451], [-122.04355, 37.62461], [-122.04366, 37.6246], [-122.04449, 37.62538], [-122.04567, 37.62544], [-122.0457, 37.62672], [-122.04602, 37.62698], [-122.04659, 37.62714], [-122.04745, 37.62728], [-122.04796, 37.62732], [-122.04819, 37.62714], [-122.04814, 37.62684], [-122.04827, 37.62667], [-122.04822, 37.62471], [-122.04919, 37.62473], [-122.05058, 37.62653]]]]} | Restricted Access 2 | 14851 | Mission Hills Golf Course | 33042 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 37.311 | Mission Hills GC | 0 | Local Recreation Area 3 | 4 | |
| 10780 | 10780 | 10779 | {"type": "Polygon", "coordinates": [[[-117.76612, 34.10899], [-117.7652, 34.11126], [-117.76228, 34.1103], [-117.76223, 34.11016], [-117.76212, 34.10995], [-117.76202, 34.1098], [-117.7623, 34.10965], [-117.76255, 34.10947], [-117.76279, 34.10925], [-117.76296, 34.10904], [-117.76318, 34.10868], [-117.7637, 34.10752], [-117.76409, 34.10765], [-117.76407, 34.10773], [-117.76441, 34.10784], [-117.76461, 34.10794], [-117.76462, 34.10793], [-117.76466, 34.10782], [-117.76493, 34.10789], [-117.76612, 34.10899]]]} | Restricted Access 2 | 20550 | La Verne Sports Park | 31619 | 2398 | Bonita Unified School District 956 | Special District 4 | School District 14 | http://do.bonita.k12.ca.us/ | Special District 4 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 22.089 | La Verne Sports Park | 0 | Local Recreation Area 3 | 4 | |
| 10843 | 10843 | 10842 | {"type": "Polygon", "coordinates": [[[-118.41941, 33.92466], [-118.4187, 33.92467], [-118.4187, 33.92444], [-118.41841, 33.92444], [-118.41841, 33.92366], [-118.41941, 33.92366], [-118.41941, 33.92466]]]} | Restricted Access 2 | 20624 | Richmond Street Field | 31642 | 2378 | El Segundo Unified School District 958 | Special District 4 | School District 14 | http://www.elsegundousd.net/ | Special District 4 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 2.392 | Richmond Street Field | 0 | Local Recreation Area 3 | 4 | |
| 10863 | 10863 | 10862 | {"type": "Polygon", "coordinates": [[[-118.82414, 34.0228], [-118.82415, 34.02343], [-118.8242, 34.02514], [-118.82383, 34.02594], [-118.82355, 34.02636], [-118.82309, 34.02697], [-118.8214, 34.02658], [-118.82087, 34.0264], [-118.82069, 34.02541], [-118.82061, 34.02514], [-118.82048, 34.02484], [-118.82045, 34.02472], [-118.82044, 34.02459], [-118.82046, 34.02446], [-118.82054, 34.02429], [-118.82093, 34.02387], [-118.82105, 34.02371], [-118.82121, 34.02343], [-118.82192, 34.02391], [-118.82243, 34.02344], [-118.8217, 34.02273], [-118.82181, 34.0226], [-118.82192, 34.0225], [-118.82258, 34.02203], [-118.82271, 34.02189], [-118.82412, 34.02284], [-118.82414, 34.02283], [-118.82414, 34.0228]]]} | Restricted Access 2 | 20661 | Malibu Equestrian Park | 32834 | 2423 | Santa Monica-Malibu Unified School District 960 | Special District 4 | School District 14 | www.smmusd.org | Special District 4 | 1193 | Malibu, City of 928 | City 2 | City Agency 2 | Los Angeles 6 | 32.463 | Malibu Equestrian Park | 0 | Local Recreation Area 3 | 4 | |
| 11431 | 11431 | 11430 | {"type": "Polygon", "coordinates": [[[-118.34535, 33.89046], [-118.34465, 33.89053], [-118.34471, 33.89095], [-118.34436, 33.89096], [-118.34432, 33.88985], [-118.34484, 33.88984], [-118.34485, 33.88999], [-118.34528, 33.88995], [-118.34535, 33.89046]]]} | Restricted Access 2 | 48114 | Bollinger Gymnasium | 32629 | 2396 | Lawndale Elementary School District 670 | Special District 4 | School District 14 | http://www.lawndale.k12.ca.us/ | Special District 4 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/ASSETS/PDF/Parks/bollinger.pdf | Los Angeles 6 | 1.856 | Bollinger Gymnasium | 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]);