units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where DES_TP = 14 and MNG_AG_TYP = 4 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_TYP, LABEL_NAME
MNG_AGENCY 14
- La Selva Beach Recreation District 8
- Marin County Open Space District 3
- Hayward Area Recreation and Park District 2
- Riverside County Regional Park and Open Space District 2
- Sonoma County Agricultural Preservation and Open Space District 2
- North County Recreation and Park District 2
- Westfield Recreation and Park District 2
- Conejo Recreation and Park District 1
- Monterey Peninsula Regional Park District 1
- Napa County Regional Park and Open Space District 1
- North of the River Recreation and Park District 1
- Santa Clara Valley Open Space Authority 1
- Soledad-Mission Recreation District 1
- Georgetown Divide Recreation District 1
ACCESS_TYP 3
MNG_AG_TYP 1
- Recreation/Parks District · 28 ✖
DES_TP 1
- Local Other or Unknown · 28 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9081 | 9081 | 9080 | {"type": "Polygon", "coordinates": [[[-123.07275, 38.37014], [-123.07057, 38.37134], [-123.06942, 38.37164], [-123.0685, 38.37149], [-123.06748, 38.37154], [-123.06637, 38.37194], [-123.06309, 38.3645], [-123.06149, 38.36456], [-123.05809, 38.35921], [-123.05832, 38.35919], [-123.05836, 38.35916], [-123.0584, 38.35911], [-123.05846, 38.35892], [-123.05851, 38.35864], [-123.05854, 38.35835], [-123.05851, 38.35812], [-123.05851, 38.35799], [-123.05848, 38.35785], [-123.0583, 38.35731], [-123.05826, 38.35714], [-123.05826, 38.35705], [-123.05823, 38.35697], [-123.05822, 38.35682], [-123.05822, 38.35627], [-123.0582, 38.356], [-123.05824, 38.35569], [-123.05831, 38.35553], [-123.05838, 38.35543], [-123.05872, 38.35516], [-123.05927, 38.3549], [-123.05941, 38.35485], [-123.05994, 38.35473], [-123.06015, 38.35469], [-123.06041, 38.35468], [-123.06101, 38.35462], [-123.06128, 38.35457], [-123.06153, 38.35449], [-123.06171, 38.35435], [-123.06179, 38.35419], [-123.06177, 38.3541], [-123.06176, 38.35385], [-123.06179, 38.35378], [-123.06188, 38.35331], [-123.06184, 38.35315], [-123.06172, 38.35292], [-123.06172, 38.35287], [-123.06166, 38.35281], [-123.06163, 38.35274], [-123.06158, 38.35256], [-123.06249, 38.35334], [-123.06313, 38.35379], [-123.06445, 38.35463], [-123.06499, 38.35501], [-123.06561, 38.35547], [-123.0666, 38.35624], [-123.06683, 38.3565], [-123.06689, 38.35665], [-123.06694, 38.35688], [-123.06696, 38.35708], [-123.06696, 38.35747], [-123.06692, 38.3578], [-123.06695, 38.358], [-123.06706, 38.35821], [-123.0675, 38.35885], [-123.06775, 38.35926], [-123.06781, 38.35942], [-123.06797, 38.3601], [-123.06807, 38.36033], [-123.06817, 38.36051], [-123.06855, 38.361], [-123.06867, 38.36122], [-123.06873, 38.36144], [-123.06873, 38.36205], [-123.06878, 38.36226], [-123.06891, 38.36246], [-123.06962, 38.36317], [-123.06968, 38.36328], [-123.0698, 38.36358], [-123.06997, 38.36427], [-123.07005, 38.36441], [-123.07075, 38.36541], [-123.0715, 38.36668], [-123.07159, 38.36688], [-123.0717, 38.36731], [-123.07179, 38.36752], [-123.07194, 38.3677], [-123.07229, 38.36799], [-123.07245, 38.36823], [-123.07281, 38.3691], [-123.07287, 38.36927], [-123.07288, 38.36939], [-123.07287, 38.36952], [-123.07283, 38.3697], [-123.07275, 38.36998], [-123.07275, 38.37014]]]} | Restricted Access 2 | 15036 | Carrington Coast Ranch | 31268 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 329.459 | Carrington Coast Ranch | 2003 | Local Other or Unknown 14 | 4 | |
9628 | 9628 | 9627 | {"type": "Polygon", "coordinates": [[[-122.69582, 38.54625], [-122.69567, 38.54622], [-122.6949, 38.54581], [-122.69432, 38.54576], [-122.69338, 38.54514], [-122.69307, 38.54474], [-122.69284, 38.54396], [-122.69244, 38.5437], [-122.69183, 38.54277], [-122.69113, 38.54204], [-122.69108, 38.54018], [-122.69581, 38.54015], [-122.69582, 38.54625]]]} | No Public Access 3 | 47850 | Wendle Property | 31796 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 50.237 | Wendle Property | 2018 | Local Other or Unknown 14 | 4 | |
7798 | 7798 | 7797 | {"type": "Polygon", "coordinates": [[[-122.26488, 38.57654], [-122.26001, 38.57628], [-122.25998, 38.57271], [-122.2502, 38.57224], [-122.24999, 38.5757], [-122.24669, 38.57566], [-122.24449, 38.57208], [-122.24579, 38.57211], [-122.24589, 38.56866], [-122.24142, 38.56847], [-122.24147, 38.56167], [-122.2507, 38.56202], [-122.25035, 38.56881], [-122.25518, 38.569], [-122.25526, 38.5656], [-122.25995, 38.56577], [-122.25998, 38.56918], [-122.26488, 38.56972], [-122.26488, 38.57654]]]} | No Public Access 3 | 47669 | Swittle Creek | 31410 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 422.914 | Swittle Creek | 0 | Local Other or Unknown 14 | 4 | |
2719 | 2719 | 2718 | {"type": "Polygon", "coordinates": [[[-122.15145, 37.62482], [-122.1508, 37.62499], [-122.14973, 37.62515], [-122.14837, 37.62508], [-122.14707, 37.62481], [-122.14004, 37.62225], [-122.13959, 37.62203], [-122.13915, 37.62174], [-122.14433, 37.62003], [-122.14478, 37.62002], [-122.14935, 37.61837], [-122.15103, 37.61782], [-122.15106, 37.61893], [-122.15087, 37.61931], [-122.15075, 37.62021], [-122.15092, 37.62129], [-122.15132, 37.6246], [-122.15145, 37.62482]]]} | Restricted Access 2 | 18348 | Oliver Property | 23136 | 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 | 118.291 | Oliver Property | 1977 | Local Other or Unknown 14 | 4 | |
6737 | 6737 | 6736 | {"type": "Polygon", "coordinates": [[[-122.03598, 37.62441], [-122.03477, 37.62527], [-122.02785, 37.61905], [-122.0275, 37.61927], [-122.02683, 37.61864], [-122.02714, 37.61843], [-122.02714, 37.61841], [-122.02541, 37.61685], [-122.02383, 37.61546], [-122.025, 37.61493], [-122.02533, 37.61507], [-122.02541, 37.61558], [-122.02606, 37.61578], [-122.02551, 37.6161], [-122.02551, 37.61612], [-122.02586, 37.61626], [-122.02596, 37.61635], [-122.0261, 37.61629], [-122.02619, 37.6165], [-122.027, 37.61691], [-122.02703, 37.61697], [-122.02748, 37.61694], [-122.02752, 37.61708], [-122.0276, 37.61722], [-122.02769, 37.61732], [-122.02793, 37.61754], [-122.02831, 37.61728], [-122.02844, 37.61738], [-122.029, 37.61799], [-122.02907, 37.61807], [-122.02902, 37.61828], [-122.02923, 37.61868], [-122.02909, 37.61922], [-122.02966, 37.6193], [-122.02981, 37.61926], [-122.03015, 37.61907], [-122.0305, 37.61923], [-122.03127, 37.62017], [-122.03116, 37.62025], [-122.03122, 37.62063], [-122.03175, 37.62081], [-122.03201, 37.62079], [-122.03174, 37.62155], [-122.03264, 37.62176], [-122.0328, 37.62189], [-122.03275, 37.62243], [-122.03287, 37.62265], [-122.03458, 37.62408], [-122.03509, 37.62432], [-122.03598, 37.62441]]]} | Open Access 1 | 5068 | Taper Park Property | 26183 | 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 | 39.626 | Taper Park Property | 1975 | Local Other or Unknown 14 | 4 | |
3741 | 3741 | 3740 | {"type": "Polygon", "coordinates": [[[-121.909, 36.51865], [-121.90875, 36.51885], [-121.90885, 36.51911], [-121.90865, 36.51936], [-121.90826, 36.5196], [-121.90811, 36.51967], [-121.90807, 36.51973], [-121.90716, 36.52011], [-121.90656, 36.52042], [-121.90615, 36.52045], [-121.90555, 36.52056], [-121.90501, 36.52079], [-121.9046, 36.52107], [-121.90365, 36.52139], [-121.9025, 36.52232], [-121.90225, 36.5224], [-121.90144, 36.52252], [-121.90107, 36.52238], [-121.90084, 36.52241], [-121.90066, 36.52256], [-121.90048, 36.52259], [-121.89827, 36.52246], [-121.89696, 36.52232], [-121.89571, 36.51565], [-121.8964, 36.51259], [-121.89768, 36.51305], [-121.89768, 36.5118], [-121.90218, 36.51185], [-121.90218, 36.50821], [-121.90668, 36.50827], [-121.90669, 36.51191], [-121.90662, 36.51654], [-121.909, 36.51865]]]} | Restricted Access 2 | 44849 | Whisler-Wilson Ranch | 28252 | 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 | 306.464 | Whisler-Wilson Ranch | 0 | Local Other or Unknown 14 | 4 | |
4618 | 4618 | 4617 | {"type": "Polygon", "coordinates": [[[-121.86433, 36.93568], [-121.86428, 36.93572], [-121.8632, 36.9346], [-121.86325, 36.93456], [-121.86433, 36.93568]]]} | Open Access 1 | 36130 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.256 | 0 | Local Other or Unknown 14 | 4 | ||
4673 | 4673 | 4672 | {"type": "Polygon", "coordinates": [[[-121.86411, 36.93794], [-121.86404, 36.93797], [-121.86384, 36.93798], [-121.86379, 36.93797], [-121.86377, 36.93793], [-121.86383, 36.93779], [-121.86393, 36.93787], [-121.86398, 36.93783], [-121.86411, 36.93794]]]} | Open Access 1 | 36646 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.092 | 0 | Local Other or Unknown 14 | 4 | ||
4559 | 4559 | 4558 | {"type": "Polygon", "coordinates": [[[-121.86369, 36.93775], [-121.86367, 36.9378], [-121.86349, 36.938], [-121.86335, 36.93821], [-121.86263, 36.93764], [-121.86282, 36.9375], [-121.86287, 36.9375], [-121.86293, 36.93754], [-121.86296, 36.93752], [-121.86302, 36.93756], [-121.86312, 36.93749], [-121.86321, 36.93756], [-121.86335, 36.93746], [-121.86366, 36.93771], [-121.86369, 36.93775]]]} | Open Access 1 | 35179 | Unknown park - La Selva Beach Parks and Recreation District | 28690 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 1.005 | 0 | Local Other or Unknown 14 | 4 | ||
15485 | 15485 | 15484 | {"type": "Polygon", "coordinates": [[[-121.8621, 36.93337], [-121.86183, 36.93378], [-121.86183, 36.93423], [-121.86175, 36.93427], [-121.86176, 36.93376], [-121.86206, 36.93332], [-121.8621, 36.93337]]]} | Open Access 1 | 43087 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.166 | 0 | Local Other or Unknown 14 | 4 | ||
4683 | 4683 | 4682 | {"type": "Polygon", "coordinates": [[[-121.8613, 36.93786], [-121.86128, 36.9379], [-121.86099, 36.93813], [-121.86095, 36.93813], [-121.86093, 36.9381], [-121.86095, 36.93798], [-121.86093, 36.93765], [-121.86096, 36.93761], [-121.86102, 36.93762], [-121.86128, 36.93782], [-121.8613, 36.93786]]]} | Open Access 1 | 43074 | Unknown park - La Selva Beach Recreation District | 28639 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.278 | 0 | Local Other or Unknown 14 | 4 | ||
4619 | 4619 | 4618 | {"type": "Polygon", "coordinates": [[[-121.86, 36.94078], [-121.85982, 36.94067], [-121.85962, 36.94058], [-121.85956, 36.94051], [-121.8596, 36.94044], [-121.85969, 36.9404], [-121.86, 36.94039], [-121.86, 36.94078]]]} | Open Access 1 | 36131 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.265 | 0 | Local Other or Unknown 14 | 4 | ||
15482 | 15482 | 15481 | {"type": "Polygon", "coordinates": [[[-121.85976, 36.9403], [-121.85956, 36.94034], [-121.85939, 36.94045], [-121.85932, 36.94046], [-121.85927, 36.94041], [-121.85927, 36.94028], [-121.85951, 36.94009], [-121.85976, 36.9403]]]} | Open Access 1 | 43081 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.222 | 0 | Local Other or Unknown 14 | 4 | ||
15483 | 15483 | 15482 | {"type": "Polygon", "coordinates": [[[-121.7569, 36.77289], [-121.75622, 36.77347], [-121.75458, 36.77228], [-121.75464, 36.77222], [-121.75547, 36.77222], [-121.75581, 36.77227], [-121.75598, 36.77233], [-121.75612, 36.77239], [-121.7569, 36.77289]]]} | Open Access 1 | 43083 | Unnamed site - North County Recreation and Park District | 28720 | 2094 | North County Recreation and Park District 733 | Special District 4 | Recreation/Parks District 4 | http://www.ncrpd.org | Special District 4 | 2094 | North County Recreation and Park District 717 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.303 | 0 | Local Other or Unknown 14 | 4 | ||
15479 | 15479 | 15478 | {"type": "Polygon", "coordinates": [[[-121.72963, 36.78547], [-121.72962, 36.78553], [-121.72872, 36.78627], [-121.72865, 36.78628], [-121.72807, 36.78601], [-121.72823, 36.78577], [-121.72779, 36.78557], [-121.728, 36.78528], [-121.72812, 36.78532], [-121.72824, 36.78532], [-121.72835, 36.78529], [-121.72844, 36.78523], [-121.7285, 36.78514], [-121.72863, 36.7848], [-121.72871, 36.78483], [-121.72869, 36.78491], [-121.72871, 36.78496], [-121.72875, 36.785], [-121.72886, 36.78503], [-121.72899, 36.78498], [-121.72903, 36.78499], [-121.72935, 36.78519], [-121.72948, 36.7853], [-121.72963, 36.78547]]]} | Open Access 1 | 43075 | Unknown park - North County Recreation and Park District | 28650 | 2094 | North County Recreation and Park District 733 | Special District 4 | Recreation/Parks District 4 | http://www.ncrpd.org | Special District 4 | 2094 | North County Recreation and Park District 717 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.408 | 0 | Local Other or Unknown 14 | 4 | ||
4687 | 4687 | 4686 | {"type": "Polygon", "coordinates": [[[-121.32025, 36.42989], [-121.32025, 36.43031], [-121.31912, 36.4303], [-121.31914, 36.42962], [-121.31995, 36.42962], [-121.31996, 36.42988], [-121.32025, 36.42989]]]} | Open Access 1 | 43092 | Unknown park - Soledad-Mission Recreation District | 28668 | 2154 | Soledad-Mission Recreation District 775 | Special District 4 | Recreation/Parks District 4 | http://www.soledad-mission-recreation-district.org/ | Special District 4 | 2154 | Soledad-Mission Recreation District 756 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 1.687 | 0 | Local Other or Unknown 14 | 4 | ||
4800 | 4800 | 4799 | {"type": "Polygon", "coordinates": [[[-120.91362, 38.89783], [-120.91305, 38.89803], [-120.91312, 38.89817], [-120.91226, 38.89828], [-120.91215, 38.89848], [-120.91174, 38.89845], [-120.91132, 38.89844], [-120.91116, 38.89838], [-120.91124, 38.89813], [-120.91198, 38.89771], [-120.91213, 38.89791], [-120.91217, 38.89791], [-120.91219, 38.89797], [-120.91239, 38.89791], [-120.91242, 38.89803], [-120.91284, 38.89788], [-120.91293, 38.898], [-120.91358, 38.89777], [-120.91362, 38.89783]]]} | Open Access 1 | 48517 | Unnamed site - Georgetown Divide Recreation District | 33230 | 2223 | Georgetown Divide Recreation District 784 | Special District 4 | Recreation/Parks District 4 | http://www.gdrd.org/ | Special District 4 | 2223 | Georgetown Divide Recreation District 764 | Special District 4 | Recreation/Parks District 4 | El Dorado 34 | 1.949 | 0 | Local Other or Unknown 14 | 4 | ||
4520 | 4520 | 4519 | {"type": "Polygon", "coordinates": [[[-119.13455, 35.37983], [-119.13454, 35.38338], [-119.13233, 35.38337], [-119.13234, 35.37982], [-119.13455, 35.37983]]]} | Open Access 1 | 13519 | Unnamed site - North of the River Recreation and Park District | 32826 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 19.594 | 0 | Local Other or Unknown 14 | 4 | ||
4493 | 4493 | 4492 | {"type": "Polygon", "coordinates": [[[-118.36086, 33.76832], [-118.3608, 33.76862], [-118.36056, 33.76861], [-118.36041, 33.76865], [-118.36031, 33.76842], [-118.36043, 33.76817], [-118.36086, 33.76832]]]} | Open Access 1 | 5915 | Unknown park - Westfield Recreation and Park District | 28677 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.462 | 0 | Local Other or Unknown 14 | 4 | |||
4492 | 4492 | 4491 | {"type": "Polygon", "coordinates": [[[-118.35128, 33.78024], [-118.35122, 33.78036], [-118.35108, 33.78051], [-118.35086, 33.78065], [-118.35069, 33.7807], [-118.35057, 33.78035], [-118.35093, 33.78032], [-118.35092, 33.78], [-118.35108, 33.78], [-118.35119, 33.78003], [-118.35127, 33.78011], [-118.35128, 33.78024]]]} | Open Access 1 | 5914 | Unnamed site - Westfield Recreation and Park District | 28676 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.653 | 0 | Local Other or Unknown 14 | 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]);