units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where ACCESS_TYP = 2, COUNTY = 3 and MNG_AGENCY = 611
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME, GAP_STS
DES_TP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Rancho Santa Margarita Landscape and Recreation Corporation · 18 ✖
ACCESS_TYP 1
- Restricted Access · 18 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3339 | 3339 | 3338 | {"type": "Polygon", "coordinates": [[[-117.60164, 33.62872], [-117.60116, 33.62884], [-117.60031, 33.6291], [-117.60029, 33.62905], [-117.60002, 33.62892], [-117.60004, 33.62855], [-117.60049, 33.62742], [-117.60127, 33.62756], [-117.60121, 33.62777], [-117.60132, 33.6278], [-117.60137, 33.62789], [-117.60123, 33.62795], [-117.60164, 33.62872]]]} | Restricted Access 2 | 30283 | Tijeras Creek Park | 31711 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 4.432 | Tijeras Creek Park | 0 | Private Recreation or Education 65 | 4 | |
3340 | 3340 | 3339 | {"type": "Polygon", "coordinates": [[[-117.61896, 33.65906], [-117.61894, 33.6595], [-117.61887, 33.65976], [-117.61872, 33.66002], [-117.61856, 33.66021], [-117.61813, 33.66053], [-117.61788, 33.66066], [-117.61763, 33.66075], [-117.61746, 33.66081], [-117.6173, 33.66083], [-117.61687, 33.66083], [-117.61685, 33.66021], [-117.61663, 33.65975], [-117.61673, 33.65943], [-117.6167, 33.65921], [-117.6166, 33.65904], [-117.6166, 33.65897], [-117.61643, 33.65896], [-117.6163, 33.65897], [-117.61627, 33.65881], [-117.61631, 33.65879], [-117.6165, 33.65864], [-117.61666, 33.65855], [-117.61678, 33.6585], [-117.61689, 33.65848], [-117.61715, 33.65846], [-117.61722, 33.65837], [-117.61758, 33.65853], [-117.61801, 33.65868], [-117.61827, 33.65875], [-117.6187, 33.6588], [-117.61873, 33.65889], [-117.61879, 33.65897], [-117.61896, 33.65906]]]} | Restricted Access 2 | 30288 | Altistima Park | 31699 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 10.958 | Altistima Park | 0 | Private Recreation or Education 65 | 4 | |
3709 | 3709 | 3708 | {"type": "Polygon", "coordinates": [[[-117.57401, 33.6383], [-117.57347, 33.63793], [-117.57352, 33.63773], [-117.57355, 33.63752], [-117.57353, 33.63731], [-117.57346, 33.637], [-117.57336, 33.63681], [-117.57324, 33.63663], [-117.57376, 33.63658], [-117.57401, 33.6383]]]} | Restricted Access 2 | 30292 | Sycamore Canyon Drive Park | 31710 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 1.561 | Sycamore Canyon Drive Park | 0 | Private Recreation or Education 65 | 4 | |
3907 | 3907 | 3906 | {"type": "Polygon", "coordinates": [[[-117.59448, 33.64807], [-117.59356, 33.64867], [-117.59295, 33.64803], [-117.59281, 33.64785], [-117.59262, 33.64744], [-117.59259, 33.64733], [-117.5926, 33.64721], [-117.59254, 33.64711], [-117.59244, 33.64701], [-117.59231, 33.64683], [-117.59263, 33.64662], [-117.59273, 33.64662], [-117.59289, 33.64651], [-117.59295, 33.6466], [-117.59307, 33.64695], [-117.59381, 33.64679], [-117.59389, 33.64704], [-117.59401, 33.64733], [-117.59423, 33.64767], [-117.59448, 33.64798], [-117.59448, 33.64807]]]} | Restricted Access 2 | 5723 | Monte Vista Park | 31707 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 6.018 | Monte Vista Park | 0 | Private Recreation or Education 65 | 4 | |
4237 | 4237 | 4236 | {"type": "Polygon", "coordinates": [[[-117.57184, 33.65254], [-117.57178, 33.65265], [-117.5717, 33.65293], [-117.57159, 33.65371], [-117.57151, 33.65374], [-117.57123, 33.6537], [-117.57087, 33.6536], [-117.56993, 33.65329], [-117.5699, 33.65165], [-117.57005, 33.65139], [-117.57051, 33.65143], [-117.57051, 33.65186], [-117.57112, 33.65187], [-117.57158, 33.65227], [-117.5717, 33.65245], [-117.57184, 33.65254]]]} | Restricted Access 2 | 2077 | Ike Arnold Park | 31704 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 7.915 | Ike Arnold Park | 0 | Private Recreation or Education 65 | 4 | |
12829 | 12829 | 12828 | {"type": "Polygon", "coordinates": [[[-117.58219, 33.65585], [-117.58216, 33.65592], [-117.58162, 33.65612], [-117.58116, 33.65619], [-117.58071, 33.65618], [-117.58049, 33.65614], [-117.58023, 33.65606], [-117.57994, 33.65593], [-117.57971, 33.65579], [-117.5795, 33.65562], [-117.57929, 33.65535], [-117.5792, 33.65521], [-117.57913, 33.65507], [-117.57908, 33.65486], [-117.57907, 33.65458], [-117.57909, 33.65425], [-117.58132, 33.65415], [-117.58219, 33.65585]]]} | Restricted Access 2 | 30278 | Trabuco Mesa Park | 31712 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 12.063 | Trabuco Mesa Park | 0 | Private Recreation or Education 65 | 4 | |
12830 | 12830 | 12829 | {"type": "Polygon", "coordinates": [[[-117.58699, 33.65131], [-117.58579, 33.65233], [-117.58528, 33.65279], [-117.58509, 33.65331], [-117.58538, 33.65387], [-117.58551, 33.65408], [-117.58575, 33.65428], [-117.58525, 33.65459], [-117.58486, 33.6548], [-117.58434, 33.65504], [-117.58375, 33.65426], [-117.58358, 33.65366], [-117.58381, 33.65304], [-117.58382, 33.65279], [-117.58375, 33.65253], [-117.58364, 33.65246], [-117.58365, 33.65238], [-117.58376, 33.65232], [-117.58388, 33.65199], [-117.58392, 33.65177], [-117.58388, 33.65147], [-117.58379, 33.65111], [-117.58369, 33.65095], [-117.58307, 33.65039], [-117.58331, 33.65015], [-117.5833, 33.65009], [-117.58318, 33.65001], [-117.58317, 33.64988], [-117.58311, 33.64983], [-117.5831, 33.64969], [-117.58317, 33.64961], [-117.58318, 33.64956], [-117.58329, 33.64944], [-117.58295, 33.64919], [-117.58296, 33.64906], [-117.58304, 33.64902], [-117.58374, 33.64904], [-117.58405, 33.64903], [-117.58456, 33.64899], [-117.58456, 33.64902], [-117.58434, 33.64924], [-117.5844, 33.65004], [-117.58525, 33.65084], [-117.58637, 33.65039], [-117.58677, 33.65103], [-117.58699, 33.65131]]]} | Restricted Access 2 | 30279 | Lago Santa Margarita Beach Club | 31705 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 27.579 | Lago Santa Margarita Beach Club | 0 | Private Recreation or Education 65 | 4 | |
12832 | 12832 | 12831 | {"type": "Polygon", "coordinates": [[[-117.58827, 33.64485], [-117.58825, 33.64492], [-117.58764, 33.6453], [-117.58743, 33.64541], [-117.5874, 33.64546], [-117.58739, 33.64554], [-117.58742, 33.64563], [-117.58736, 33.64567], [-117.58731, 33.64558], [-117.58728, 33.64541], [-117.58733, 33.64503], [-117.58718, 33.64498], [-117.58713, 33.64495], [-117.58695, 33.64442], [-117.58746, 33.64426], [-117.58748, 33.64432], [-117.58742, 33.6444], [-117.58749, 33.64465], [-117.58757, 33.64469], [-117.58764, 33.64468], [-117.58767, 33.64479], [-117.58817, 33.6447], [-117.58827, 33.64485]]]} | Restricted Access 2 | 30280 | Cielo Vista Park | 31702 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 1.805 | Cielo Vista Park | 0 | Private Recreation or Education 65 | 4 | |
12833 | 12833 | 12832 | {"type": "Polygon", "coordinates": [[[-117.59395, 33.64177], [-117.59353, 33.64183], [-117.5933, 33.64212], [-117.59332, 33.64226], [-117.5917, 33.6425], [-117.59138, 33.64242], [-117.59072, 33.64304], [-117.59072, 33.64277], [-117.59123, 33.6423], [-117.59111, 33.64158], [-117.59158, 33.64113], [-117.59308, 33.64092], [-117.59309, 33.64101], [-117.59313, 33.64108], [-117.59311, 33.64112], [-117.59339, 33.64129], [-117.59383, 33.64123], [-117.59395, 33.64177]]]} | Restricted Access 2 | 30281 | Central Park | 31698 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 8.304 | Central Park | 0 | Private Recreation or Education 65 | 4 | |
12834 | 12834 | 12833 | {"type": "Polygon", "coordinates": [[[-117.57006, 33.63818], [-117.56954, 33.63885], [-117.56851, 33.63819], [-117.56793, 33.63796], [-117.56772, 33.63797], [-117.56754, 33.638], [-117.56734, 33.63809], [-117.56714, 33.63821], [-117.56675, 33.6382], [-117.56672, 33.63751], [-117.56682, 33.63751], [-117.56741, 33.63745], [-117.56825, 33.63745], [-117.56912, 33.63771], [-117.57006, 33.63818]]]} | Restricted Access 2 | 30293 | Swim & Racquet Complex | 31709 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 5.564 | Swim & Racquet Complex | 0 | Private Conservation 16 | 2 | |
12835 | 12835 | 12834 | {"type": "Polygon", "coordinates": [[[-117.5971, 33.63467], [-117.59708, 33.63469], [-117.59704, 33.63464], [-117.59698, 33.63462], [-117.59688, 33.63463], [-117.59683, 33.6347], [-117.59679, 33.63483], [-117.59669, 33.63486], [-117.59628, 33.63476], [-117.59581, 33.63472], [-117.59577, 33.63471], [-117.59574, 33.63468], [-117.59571, 33.63444], [-117.59569, 33.63442], [-117.59561, 33.63437], [-117.59564, 33.63431], [-117.59571, 33.63431], [-117.59578, 33.63427], [-117.5958, 33.63425], [-117.59583, 33.63408], [-117.59591, 33.63399], [-117.59601, 33.63391], [-117.59614, 33.63384], [-117.59683, 33.63363], [-117.59663, 33.63306], [-117.59655, 33.6329], [-117.59639, 33.63268], [-117.59603, 33.63231], [-117.59616, 33.63221], [-117.59659, 33.63264], [-117.59675, 33.63288], [-117.59679, 33.63298], [-117.59718, 33.63409], [-117.59717, 33.63434], [-117.5971, 33.63467]]]} | Restricted Access 2 | 30282 | Vista Verde Park | 31713 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 4.143 | Vista Verde Park | 0 | Private Recreation or Education 65 | 4 | |
12836 | 12836 | 12835 | {"type": "Polygon", "coordinates": [[[-117.6149, 33.62502], [-117.61475, 33.62515], [-117.61437, 33.62539], [-117.61365, 33.62567], [-117.61349, 33.62596], [-117.61261, 33.62537], [-117.61271, 33.62521], [-117.61294, 33.62465], [-117.61307, 33.62394], [-117.61309, 33.62356], [-117.61317, 33.6235], [-117.61351, 33.6235], [-117.61393, 33.62344], [-117.6149, 33.62502]]]} | Restricted Access 2 | 30284 | Arroyo Vista Park | 31700 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 8.483 | Arroyo Vista Park | 0 | Private Recreation or Education 65 | 4 | |
12837 | 12837 | 12836 | {"type": "Polygon", "coordinates": [[[-117.6146, 33.61524], [-117.61435, 33.61562], [-117.6143, 33.61567], [-117.61429, 33.61572], [-117.61404, 33.61604], [-117.61313, 33.61556], [-117.61374, 33.61518], [-117.61402, 33.61493], [-117.6146, 33.61524]]]} | Restricted Access 2 | 30285 | Mesa Linda Park | 31706 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 2.036 | Mesa Linda Park | 0 | Private Recreation or Education 65 | 4 | |
12838 | 12838 | 12837 | {"type": "Polygon", "coordinates": [[[-117.61738, 33.6086], [-117.6171, 33.60943], [-117.61703, 33.60972], [-117.6166, 33.61002], [-117.61646, 33.61014], [-117.61636, 33.61027], [-117.61619, 33.61057], [-117.61601, 33.6108], [-117.61571, 33.61109], [-117.61551, 33.61123], [-117.61516, 33.61158], [-117.61508, 33.6117], [-117.61502, 33.61175], [-117.61494, 33.61174], [-117.61488, 33.61166], [-117.61486, 33.61157], [-117.61492, 33.61126], [-117.61479, 33.61102], [-117.61483, 33.6109], [-117.61483, 33.61084], [-117.61473, 33.61064], [-117.61462, 33.61052], [-117.61466, 33.61046], [-117.61474, 33.61], [-117.61492, 33.61003], [-117.61502, 33.61], [-117.61515, 33.60987], [-117.6153, 33.60971], [-117.61543, 33.60951], [-117.61546, 33.60936], [-117.61543, 33.60918], [-117.61543, 33.60909], [-117.61549, 33.60905], [-117.6157, 33.60916], [-117.61596, 33.60923], [-117.61608, 33.60923], [-117.6162, 33.60917], [-117.61636, 33.60902], [-117.61667, 33.60882], [-117.61685, 33.6088], [-117.61698, 33.60876], [-117.61713, 33.60866], [-117.61721, 33.60856], [-117.61738, 33.6086]]]} | Restricted Access 2 | 30286 | Canada Vista Park | 31701 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 9.226 | Canada Vista Park | 0 | Private Recreation or Education 65 | 4 | |
12839 | 12839 | 12838 | {"type": "Polygon", "coordinates": [[[-117.62105, 33.64782], [-117.62093, 33.64797], [-117.62089, 33.64829], [-117.621, 33.64844], [-117.62085, 33.64863], [-117.6208, 33.64888], [-117.62072, 33.64898], [-117.62073, 33.64903], [-117.62007, 33.64904], [-117.61982, 33.64919], [-117.61975, 33.64931], [-117.61973, 33.64947], [-117.6198, 33.64963], [-117.61979, 33.64967], [-117.61926, 33.64984], [-117.6186, 33.65011], [-117.61846, 33.6501], [-117.61847, 33.64988], [-117.61856, 33.64955], [-117.61859, 33.64919], [-117.6184, 33.64832], [-117.61834, 33.64789], [-117.61841, 33.64783], [-117.61868, 33.64784], [-117.61918, 33.6478], [-117.61974, 33.64774], [-117.6204, 33.64757], [-117.62096, 33.64735], [-117.62103, 33.64744], [-117.62105, 33.64782]]]} | Restricted Access 2 | 30287 | Solana Park | 31708 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 11.27 | Solana Park | 0 | Private Recreation or Education 65 | 4 | |
12840 | 12840 | 12839 | {"type": "Polygon", "coordinates": [[[-117.5736, 33.65402], [-117.57342, 33.65417], [-117.5736, 33.65432], [-117.57357, 33.65435], [-117.57336, 33.65429], [-117.57315, 33.65447], [-117.57355, 33.65506], [-117.57341, 33.65512], [-117.57322, 33.65516], [-117.57297, 33.65519], [-117.57268, 33.65517], [-117.57253, 33.65514], [-117.57245, 33.6551], [-117.57244, 33.65506], [-117.57271, 33.6545], [-117.57276, 33.65426], [-117.57276, 33.65406], [-117.5728, 33.65404], [-117.5733, 33.65397], [-117.5736, 33.6539], [-117.5736, 33.65402]]]} | Restricted Access 2 | 30289 | Country Hollow Lane Park | 31703 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 2.253 | Country Hollow Lane Park | 0 | Private Recreation or Education 65 | 4 | |
12841 | 12841 | 12840 | {"type": "Polygon", "coordinates": [[[-117.56834, 33.65338], [-117.56831, 33.65345], [-117.56817, 33.65353], [-117.56768, 33.65384], [-117.56738, 33.65406], [-117.56728, 33.65414], [-117.56682, 33.65472], [-117.56663, 33.6549], [-117.56639, 33.65508], [-117.56617, 33.65519], [-117.56594, 33.65527], [-117.56562, 33.6553], [-117.56637, 33.65377], [-117.56695, 33.65295], [-117.56755, 33.65213], [-117.56775, 33.65229], [-117.56794, 33.65253], [-117.56804, 33.65272], [-117.56834, 33.65338]]]} | Restricted Access 2 | 30290 | Central Park | 31698 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 8.176 | Central Park | 0 | Private Recreation or Education 65 | 4 | |
12842 | 12842 | 12841 | {"type": "Polygon", "coordinates": [[[-117.57444, 33.64923], [-117.5744, 33.64929], [-117.57435, 33.64932], [-117.57435, 33.64936], [-117.57417, 33.64937], [-117.57379, 33.64929], [-117.57349, 33.64935], [-117.57356, 33.64943], [-117.57367, 33.64963], [-117.57381, 33.64979], [-117.57379, 33.64981], [-117.57383, 33.65015], [-117.57356, 33.65015], [-117.57353, 33.6499], [-117.57342, 33.64976], [-117.57325, 33.6494], [-117.573, 33.6491], [-117.57296, 33.64904], [-117.57295, 33.64897], [-117.57295, 33.6489], [-117.57311, 33.64844], [-117.57314, 33.64821], [-117.57315, 33.64777], [-117.57312, 33.6473], [-117.57329, 33.64725], [-117.57335, 33.64753], [-117.57338, 33.64755], [-117.57342, 33.64772], [-117.57383, 33.64748], [-117.5741, 33.64778], [-117.574, 33.64784], [-117.574, 33.6479], [-117.57396, 33.64794], [-117.57384, 33.64799], [-117.5738, 33.64805], [-117.5738, 33.6481], [-117.57385, 33.64819], [-117.57398, 33.64812], [-117.57436, 33.64858], [-117.57438, 33.64859], [-117.57441, 33.64872], [-117.57443, 33.64874], [-117.57444, 33.64887], [-117.57444, 33.64923]]]} | Restricted Access 2 | 30291 | Walden Park | 31714 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 5.762 | Walden Park | 0 | Private Recreation or Education 65 | 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]);