units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,640 rows where ACCESS_TYP = 1 and DES_TP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 195
- Los Angeles, City of 105
- San Francisco, City and County of 77
- Mountains Recreation and Conservation Authority 52
- Conejo Open Space Conservation Agency 24
- East Bay Regional Park District 23
- San Luis Obispo, City of 22
- Glendale, City of 22
- Davis, City of 22
- Los Angeles, County of 20
- Santa Clarita, City of 18
- Santa Barbara, County of 17
- Long Beach, City of 17
- Sacramento, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 15
- Fullerton, City of 14
- Conejo Recreation and Park District 13
- San Marcos, City of 13
- Tiburon, Town of 13
- San Jose, City of 12
- Vacaville, City of 12
- Sunrise Recreation and Park District 12
- Poway, City of 11
- Mission Viejo, City of 11
- San Bernardino, City of 10
- Rancho Simi Recreation and Park District 9
- Carlsbad, City of 9
- Santa Clara County Parks and Recreation Dept., County of 9
- Fresno, City of 8
- …
MNG_AG_TYP 15
- City Agency 1,208
- Recreation/Parks District 148
- County Agency 89
- Open Space District 77
- County Agency - Parks 29
- Water District 26
- Community Services District 13
- Flood District 9
- Port/Harbor District 5
- County Agency - Other 4
- Special District - Other 4
- Sanitation District 3
- Cemetery District 2
- Irrigation District 2
- Transportation Agency 1
MNG_AG_LEV 3 ✖
- City 1,208
- Special District 290
- County 122
DES_TP 1
- Local Recreation Area · 1,620 ✖
ACCESS_TYP 1
- Open Access · 1,620 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
277 | 277 | 276 | {"type": "Polygon", "coordinates": [[[-117.5615, 33.93786], [-117.56124, 33.93819], [-117.56111, 33.93847], [-117.56107, 33.93871], [-117.56106, 33.93932], [-117.55877, 33.93932], [-117.55877, 33.93876], [-117.55864, 33.93875], [-117.55864, 33.9379], [-117.55991, 33.93791], [-117.55992, 33.93787], [-117.5615, 33.93786]]]} | Open Access 1 | 47359 | Community Center Park | 31082 | 1395 | Norco, City of 114 | City 2 | City Agency 2 | http://www.norco.ca.us/depts/parks/default.asp | City 2 | 1395 | Norco, City of 111 | City 2 | City Agency 2 | http://www.norco.ca.us/depts/parks/facilities/parks/communitycenter.asp | Riverside 10 | 8.953 | Community Ctr. Park | 0 | Local Recreation Area 3 | 4 |
278 | 278 | 277 | {"type": "Polygon", "coordinates": [[[-120.66515, 35.26662], [-120.66466, 35.26653], [-120.66436, 35.26666], [-120.66427, 35.26653], [-120.66393, 35.26612], [-120.66379, 35.266], [-120.66357, 35.26587], [-120.66337, 35.26579], [-120.66315, 35.26574], [-120.66292, 35.26572], [-120.66252, 35.26572], [-120.66262, 35.26536], [-120.66261, 35.26497], [-120.66004, 35.26496], [-120.66011, 35.26356], [-120.65886, 35.26356], [-120.65883, 35.26352], [-120.65904, 35.26352], [-120.65905, 35.26351], [-120.659, 35.26347], [-120.6588, 35.26341], [-120.65852, 35.26335], [-120.65797, 35.26314], [-120.65777, 35.26304], [-120.65767, 35.26291], [-120.6573, 35.26264], [-120.65721, 35.26255], [-120.65717, 35.2625], [-120.65683, 35.26235], [-120.65661, 35.26231], [-120.6564, 35.26215], [-120.65633, 35.26207], [-120.65617, 35.26197], [-120.65608, 35.26186], [-120.65599, 35.26184], [-120.65583, 35.26163], [-120.65493, 35.26108], [-120.6544, 35.25768], [-120.65583, 35.25766], [-120.65584, 35.2577], [-120.65524, 35.25788], [-120.65526, 35.25821], [-120.65719, 35.26012], [-120.65825, 35.26135], [-120.65927, 35.26221], [-120.66054, 35.2628], [-120.66113, 35.26331], [-120.66475, 35.2634], [-120.66476, 35.26499], [-120.66513, 35.265], [-120.66515, 35.26662]], [[-120.66016, 35.26352], [-120.66016, 35.2635], [-120.66011, 35.26351], [-120.66012, 35.26352], [-120.66016, 35.26352]]]} | Open Access 1 | 946 | South Hills Open Space | 25656 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 58.628 | South Hills OS | 0 | Local Recreation Area 3 | 4 | |
282 | 282 | 281 | {"type": "Polygon", "coordinates": [[[-117.89382, 33.88608], [-117.89375, 33.8862], [-117.89366, 33.88628], [-117.89357, 33.88634], [-117.89345, 33.88638], [-117.89184, 33.88657], [-117.89171, 33.88659], [-117.89162, 33.88663], [-117.89142, 33.88677], [-117.89085, 33.88747], [-117.89075, 33.88764], [-117.89069, 33.88781], [-117.89029, 33.88783], [-117.89023, 33.8878], [-117.8901, 33.88716], [-117.89051, 33.88706], [-117.89064, 33.88674], [-117.89088, 33.88669], [-117.89106, 33.88662], [-117.89167, 33.88626], [-117.89176, 33.88622], [-117.89298, 33.88609], [-117.89312, 33.88604], [-117.89324, 33.88597], [-117.89338, 33.88584], [-117.89382, 33.88608]]]} | Open Access 1 | 756 | Fullerton Creek Greenbelt | 19143 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 4.418 | Fullerton Creek Greenbelt | 0 | Local Recreation Area 3 | 4 | |
294 | 294 | 293 | {"type": "Polygon", "coordinates": [[[-118.36564, 34.02332], [-118.36557, 34.02447], [-118.36551, 34.02475], [-118.36542, 34.02503], [-118.36317, 34.02482], [-118.36308, 34.02548], [-118.3629, 34.02546], [-118.36318, 34.02338], [-118.36465, 34.02338], [-118.36466, 34.02331], [-118.36564, 34.02332]]]} | Open Access 1 | 788 | Baldwin Hills Recreation Center | 15776 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 10.253 | Baldwin Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 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 | |
354 | 354 | 353 | {"type": "Polygon", "coordinates": [[[-117.36947, 33.17694], [-117.36912, 33.17714], [-117.36883, 33.1768], [-117.3692, 33.17658], [-117.36947, 33.17694]]]} | Open Access 1 | 976 | Buccaneer Beach Access | 16467 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 0.466 | Buccaneer Beach Access | 0 | Local Recreation Area 3 | 4 | |
371 | 371 | 370 | {"type": "Polygon", "coordinates": [[[-119.131, 36.29982], [-119.13097, 36.30053], [-119.1279, 36.30049], [-119.12801, 36.2971], [-119.13018, 36.29713], [-119.13005, 36.29768], [-119.13003, 36.29832], [-119.13033, 36.29892], [-119.13082, 36.29961], [-119.131, 36.29982]]]} | Open Access 1 | 1081 | Dobson Field | 18175 | 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 | 20.718 | Dobson Field | 0 | Local Recreation Area 3 | 4 | |
385 | 385 | 384 | {"type": "Polygon", "coordinates": [[[-117.15388, 33.67064], [-117.15386, 33.67362], [-117.15375, 33.67366], [-117.15354, 33.67338], [-117.15342, 33.6733], [-117.15342, 33.67327], [-117.15317, 33.67312], [-117.15276, 33.67299], [-117.15275, 33.67297], [-117.15218, 33.67273], [-117.1521, 33.67268], [-117.15205, 33.67268], [-117.15209, 33.67232], [-117.15206, 33.67228], [-117.15172, 33.67207], [-117.15166, 33.67209], [-117.15161, 33.67209], [-117.15158, 33.67206], [-117.15137, 33.67206], [-117.15114, 33.67216], [-117.15096, 33.67243], [-117.15097, 33.67245], [-117.15093, 33.67262], [-117.15094, 33.67265], [-117.15089, 33.67283], [-117.15091, 33.67286], [-117.15091, 33.67306], [-117.15088, 33.67306], [-117.15083, 33.67326], [-117.15041, 33.67303], [-117.15016, 33.67299], [-117.14999, 33.67287], [-117.14973, 33.67259], [-117.14955, 33.67245], [-117.14936, 33.67232], [-117.14933, 33.67232], [-117.14914, 33.6722], [-117.14911, 33.6722], [-117.14903, 33.67215], [-117.14888, 33.67217], [-117.14849, 33.67226], [-117.1482, 33.67272], [-117.14817, 33.6727], [-117.14817, 33.67261], [-117.14814, 33.67256], [-117.1481, 33.67252], [-117.14802, 33.67247], [-117.14821, 33.67255], [-117.14865, 33.67182], [-117.14797, 33.67065], [-117.14945, 33.67065], [-117.14949, 33.67069], [-117.14974, 33.67069], [-117.14978, 33.67065], [-117.15154, 33.67065], [-117.15159, 33.67069], [-117.15184, 33.67069], [-117.15188, 33.67065], [-117.15388, 33.67064]]]} | Open Access 1 | 48338 | Lago Vista Sports Park | 32901 | 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/lago-vista-sports-park | Riverside 10 | 28.451 | Lago Vista Sports Park | 0 | Local Recreation Area 3 | 4 |
414 | 414 | 413 | {"type": "Polygon", "coordinates": [[[-121.99027, 36.96704], [-121.98919, 36.96912], [-121.98905, 36.9695], [-121.98804, 36.9695], [-121.98722, 36.96943], [-121.98774, 36.96794], [-121.98768, 36.96792], [-121.98777, 36.96788], [-121.98814, 36.96779], [-121.98895, 36.96735], [-121.98913, 36.96739], [-121.99027, 36.96704]]]} | Open Access 1 | 830 | Simpkins Swim Center | 25513 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 9.9 | Simpkins Swim Ctr. | 0 | Local Recreation Area 3 | 4 | |
416 | 416 | 415 | {"type": "Polygon", "coordinates": [[[-117.31368, 34.12421], [-117.31368, 34.12495], [-117.31262, 34.12495], [-117.31262, 34.1242], [-117.31368, 34.12421]]]} | Open Access 1 | 1286 | Gutierrez Field | 19573 | 1293 | San Bernardino, City of 167 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | San Bernardino 22 | 1.988 | Gutierrez Field | 0 | Local Recreation Area 3 | 4 | |
462 | 462 | 461 | {"type": "Polygon", "coordinates": [[[-119.82186, 36.78834], [-119.81967, 36.78838], [-119.81975, 36.78668], [-119.82184, 36.78661], [-119.82186, 36.78834]]]} | Open Access 1 | 1856 | Quigley Playground | 24064 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.955 | Quigley Playground | 0 | Local Recreation Area 3 | 4 | |
466 | 466 | 465 | {"type": "Polygon", "coordinates": [[[-119.77435, 36.73962], [-119.77432, 36.74122], [-119.7726, 36.74123], [-119.77267, 36.73961], [-119.77435, 36.73962]]]} | Open Access 1 | 922 | Holmes Playground | 20056 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.725 | Holmes Playground | 0 | Local Recreation Area 3 | 4 | |
500 | 500 | 499 | {"type": "Polygon", "coordinates": [[[-117.1728, 32.71668], [-117.17278, 32.71676], [-117.17262, 32.71679], [-117.17261, 32.71695], [-117.1722, 32.71685], [-117.17129, 32.71683], [-117.17128, 32.71657], [-117.17223, 32.71657], [-117.17231, 32.71653], [-117.17235, 32.71589], [-117.17279, 32.71589], [-117.1728, 32.71668]]]} | Open Access 1 | 47486 | Lane Field Park | 31204 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/parks/lane-field-park.html | San Diego 4 | 1.887 | Lane Field Park | 0 | Local Recreation Area 3 | 4 |
508 | 508 | 507 | {"type": "Polygon", "coordinates": [[[-119.77465, 36.75361], [-119.77461, 36.75365], [-119.77404, 36.75398], [-119.77404, 36.75406], [-119.7726, 36.75407], [-119.7726, 36.75242], [-119.77465, 36.75241], [-119.77465, 36.75361]]]} | Open Access 1 | 2073 | Romain Playground | 24586 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 7.876 | Romain Playground | 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 | |
557 | 557 | 556 | {"type": "Polygon", "coordinates": [[[-117.10253, 33.61115], [-117.1013, 33.61115], [-117.10128, 33.60911], [-117.10251, 33.60901], [-117.10253, 33.61115]]]} | Open Access 1 | 48384 | Pourroy Fields | 32948 | 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/pourroy-fields | Riverside 10 | 6.552 | Pourroy Fields | 0 | Local Recreation Area 3 | 4 |
559 | 559 | 558 | {"type": "Polygon", "coordinates": [[[-117.14812, 33.12447], [-117.14555, 33.12477], [-117.14553, 33.12381], [-117.1481, 33.12381], [-117.14812, 33.12447]]]} | Open Access 1 | 1866 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 5.376 | City of San Marcos OS | 0 | Local Recreation Area 3 | 4 | |
567 | 567 | 566 | {"type": "Polygon", "coordinates": [[[-116.28545, 33.64926], [-116.27605, 33.6493], [-116.27598, 33.64886], [-116.27585, 33.64695], [-116.27557, 33.64484], [-116.27553, 33.64464], [-116.2754, 33.64431], [-116.27531, 33.64417], [-116.27517, 33.64399], [-116.2749, 33.64373], [-116.27445, 33.64342], [-116.27439, 33.64335], [-116.27436, 33.64326], [-116.27435, 33.64317], [-116.27438, 33.64308], [-116.27467, 33.64262], [-116.27478, 33.64236], [-116.27486, 33.64209], [-116.27489, 33.64208], [-116.27489, 33.64181], [-116.27485, 33.64155], [-116.27478, 33.64134], [-116.27444, 33.6407], [-116.27435, 33.64045], [-116.2741, 33.63907], [-116.27415, 33.63896], [-116.27423, 33.6389], [-116.27463, 33.63883], [-116.27495, 33.63873], [-116.27516, 33.63865], [-116.2755, 33.63848], [-116.2757, 33.63841], [-116.27604, 33.63834], [-116.27679, 33.6383], [-116.27679, 33.63793], [-116.27606, 33.63794], [-116.27575, 33.63799], [-116.27547, 33.63807], [-116.27523, 33.63815], [-116.27487, 33.63832], [-116.27471, 33.63838], [-116.27451, 33.63844], [-116.27408, 33.63852], [-116.27397, 33.63856], [-116.27385, 33.63862], [-116.27376, 33.6387], [-116.27369, 33.6388], [-116.27365, 33.63888], [-116.27322, 33.63867], [-116.273, 33.63852], [-116.27277, 33.63831], [-116.27259, 33.63807], [-116.27246, 33.63778], [-116.27241, 33.63747], [-116.27242, 33.63233], [-116.27236, 33.63209], [-116.27227, 33.63189], [-116.27213, 33.6317], [-116.27194, 33.63152], [-116.27176, 33.6314], [-116.27151, 33.63128], [-116.27134, 33.63123], [-116.27114, 33.6312], [-116.26991, 33.63119], [-116.26969, 33.63117], [-116.26945, 33.63112], [-116.2691, 33.63099], [-116.26892, 33.63089], [-116.26877, 33.63079], [-116.26854, 33.63057], [-116.26836, 33.63031], [-116.26811, 33.63031], [-116.26811, 33.62777], [-116.26796, 33.62763], [-116.26793, 33.62282], [-116.26835, 33.62284], [-116.26846, 33.62308], [-116.26867, 33.62343], [-116.26903, 33.62371], [-116.26946, 33.62391], [-116.27001, 33.62436], [-116.27227, 33.62528], [-116.27348, 33.62589], [-116.27578, 33.62758], [-116.28097, 33.62756], [-116.28101, 33.63121], [-116.28107, 33.64207], [-116.28542, 33.64205], [-116.28545, 33.64926]]]} | Open Access 1 | 3338 | Lake Cahuilla Recreation Area | 9500 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/parks/lake-cahuilla/lake-cahuilla-recreation-area-home/ | Riverside 10 | 566.48 | Lake Cahuilla Rec. Area | 0 | Local Recreation Area 3 | 4 |
568 | 568 | 567 | {"type": "Polygon", "coordinates": [[[-118.08621, 33.93879], [-118.08597, 33.93885], [-118.08499, 33.93885], [-118.08498, 33.93814], [-118.08454, 33.938], [-118.08408, 33.93774], [-118.08394, 33.93726], [-118.08284, 33.93741], [-118.08267, 33.93673], [-118.08267, 33.93658], [-118.08466, 33.93659], [-118.08465, 33.93544], [-118.08619, 33.93545], [-118.08621, 33.93879]]]} | Open Access 1 | 3354 | Lake Center Athletic Park | 20879 | 1321 | Santa Fe Springs, City of 211 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | Los Angeles 6 | 17.226 | Lake Ctr. Athletic Park | 0 | Local Recreation Area 3 | 4 | |
574 | 574 | 573 | {"type": "Polygon", "coordinates": [[[-117.03531, 32.69994], [-117.03497, 32.70006], [-117.03488, 32.70023], [-117.03519, 32.70101], [-117.03496, 32.70097], [-117.03328, 32.701], [-117.03352, 32.70069], [-117.03386, 32.70047], [-117.03445, 32.70026], [-117.03443, 32.69981], [-117.03449, 32.69954], [-117.03449, 32.69929], [-117.03457, 32.69943], [-117.03467, 32.69969], [-117.03485, 32.69976], [-117.03517, 32.69966], [-117.03531, 32.69994]]]} | Open Access 1 | 1914 | South Bay Terraces Open Space | 25638 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.533 | South Bay Terraces OS | 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]);