units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,196 rows where COUNTY = 3 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, GAP_STS
MNG_AGENCY >30
- Irvine, City of 101
- Orange, County of 95
- Huntington Beach, City of 76
- Newport Beach, City of 65
- Anaheim, City of 59
- Fullerton, City of 58
- Mission Viejo, City of 47
- Santa Ana, City of 46
- Costa Mesa, City of 32
- Lake Forest, City of 31
- Woodbridge Village Association 31
- Yorba Linda, City of 30
- Laguna Niguel, City of 29
- San Juan Capistrano, City of 24
- Westminster, City of 24
- San Clemente, City of 24
- Dana Point, City of 22
- La Habra, City of 22
- Fountain Valley, City of 21
- Orange, City of 20
- Garden Grove, City of 19
- Cypress, City of 19
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- Laguna Beach, City of 17
- Aliso Viejo, City of 17
- Placentia, City of 16
- Tustin, City of 16
- Brea, City of 15
- Seal Beach, City of 13
- Laguna Hills, City of 13
- …
DES_TP >30
- Local Park 793
- Private Recreation or Education 143
- Local Recreation Area 92
- Local Other or Unknown 70
- Local Conservation Area 25
- Private Conservation 11
- State Park 8
- State Conservation Area 7
- Local Historic or Cultural Area 4
- National Forest 1
- None 1
- None 1
- State Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 1,011
- Restricted Access 178
- Unknown Access 4
- No Public Access 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5 | 5 | 4 | {"type": "MultiPolygon", "coordinates": [[[[-118.10598, 33.73945], [-118.10581, 33.73968], [-118.1051, 33.73933], [-118.10527, 33.73909], [-118.10598, 33.73945]]], [[[-118.10701, 33.73996], [-118.10683, 33.7402], [-118.10615, 33.73985], [-118.10632, 33.73962], [-118.10701, 33.73996]]], [[[-118.10746, 33.7402], [-118.10729, 33.74044], [-118.10691, 33.74024], [-118.10708, 33.74], [-118.10746, 33.7402]]]]} | Open Access 1 | 25 | Eisenhower Park | 18475 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.46 | Eisenhower Park | 0 | Local Park 2 | 4 | |
5792 | 5792 | 5791 | {"type": "Polygon", "coordinates": [[[-117.94385, 33.93367], [-117.94187, 33.93367], [-117.94187, 33.9329], [-117.94297, 33.93289], [-117.94343, 33.93281], [-117.94383, 33.93282], [-117.94385, 33.93284], [-117.94385, 33.93367]]]} | Open Access 1 | 44 | El Centro Park | 18489 | 1155 | La Habra, City of 203 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | Orange 3 | 4.032 | El Centro Park | 0 | Local Park 2 | 4 | |
5794 | 5794 | 5793 | {"type": "Polygon", "coordinates": [[[-117.69121, 33.59025], [-117.6909, 33.59048], [-117.69087, 33.59047], [-117.6908, 33.59046], [-117.6907, 33.59049], [-117.69068, 33.59055], [-117.69041, 33.59076], [-117.69052, 33.59083], [-117.69026, 33.59105], [-117.68995, 33.59081], [-117.68985, 33.59067], [-117.6898, 33.59062], [-117.68968, 33.5906], [-117.68957, 33.59064], [-117.68951, 33.59069], [-117.68879, 33.58992], [-117.69092, 33.58993], [-117.69121, 33.59025]]]} | Open Access 1 | 50 | El Conejo Park | 18493 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 3.773 | El Conejo Park | 0 | Local Park 2 | 4 | |
5816 | 5816 | 5815 | {"type": "MultiPolygon", "coordinates": [[[[-117.80522, 33.77805], [-117.80516, 33.77848], [-117.80507, 33.77873], [-117.80498, 33.77889], [-117.80469, 33.77923], [-117.80459, 33.77939], [-117.80449, 33.77961], [-117.80446, 33.77974], [-117.80347, 33.77974], [-117.80347, 33.77977], [-117.8031, 33.77977], [-117.80311, 33.77801], [-117.80518, 33.77802], [-117.80522, 33.77805]]], [[[-117.80651, 33.77897], [-117.80594, 33.77961], [-117.80594, 33.78083], [-117.80596, 33.78174], [-117.80591, 33.78197], [-117.80584, 33.78216], [-117.80574, 33.78233], [-117.80555, 33.78257], [-117.80556, 33.78274], [-117.80548, 33.78265], [-117.80546, 33.78266], [-117.8053, 33.7825], [-117.80516, 33.78234], [-117.80501, 33.78207], [-117.80469, 33.7801], [-117.80468, 33.77984], [-117.80472, 33.77967], [-117.80479, 33.7795], [-117.80488, 33.77935], [-117.80514, 33.77907], [-117.80526, 33.77892], [-117.80604, 33.77893], [-117.80605, 33.77896], [-117.80651, 33.77897]]]]} | Open Access 1 | 88 | El Modena Park | 18516 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2520 | Orange 3 | 17.868 | El Modena Park | 0 | Local Park 2 | 4 |
28 | 28 | 27 | {"type": "Polygon", "coordinates": [[[-117.89558, 33.75242], [-117.89529, 33.75244], [-117.89531, 33.75329], [-117.8936, 33.75333], [-117.89359, 33.75197], [-117.89397, 33.75194], [-117.89398, 33.75162], [-117.89558, 33.75161], [-117.89558, 33.75242]]]} | Open Access 1 | 154 | El Salvador Park | 18538 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 7.57 | El Salvador Park | 0 | Local Park 2 | 4 | |
5850 | 5850 | 5849 | {"type": "Polygon", "coordinates": [[[-117.96021, 33.73828], [-117.95756, 33.7383], [-117.95755, 33.7378], [-117.9591, 33.73779], [-117.95911, 33.73774], [-117.96021, 33.73773], [-117.96021, 33.73828]]]} | Open Access 1 | 184 | Elden F Gillespie Park | 18549 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 3.525 | Elden F Gillespie Park | 0 | Local Park 2 | 4 | |
5851 | 5851 | 5850 | {"type": "Polygon", "coordinates": [[[-117.94983, 33.69457], [-117.94976, 33.69461], [-117.94972, 33.69467], [-117.94971, 33.69472], [-117.9497, 33.69521], [-117.94966, 33.69525], [-117.9496, 33.69527], [-117.94864, 33.69529], [-117.94863, 33.69496], [-117.94872, 33.69496], [-117.94872, 33.69469], [-117.94863, 33.69461], [-117.94868, 33.69454], [-117.94869, 33.69435], [-117.94877, 33.69428], [-117.94982, 33.69428], [-117.94983, 33.69457]]]} | Open Access 1 | 210 | Ellis Park | 18593 | 1111 | Fountain Valley, City of 273 | City 2 | City Agency 2 | http://www.fountainvalley.org/visitors/parks/ | City 2 | 1111 | Fountain Valley, City of 268 | City 2 | City Agency 2 | Orange 3 | 2.693 | Ellis Park | 0 | Local Park 2 | 4 | |
5879 | 5879 | 5878 | {"type": "Polygon", "coordinates": [[[-117.97279, 33.88354], [-117.97261, 33.88413], [-117.972, 33.88412], [-117.9719, 33.88422], [-117.97193, 33.88435], [-117.97208, 33.88454], [-117.97217, 33.88471], [-117.97227, 33.88494], [-117.97225, 33.88493], [-117.97208, 33.88457], [-117.97193, 33.88438], [-117.97164, 33.88404], [-117.97158, 33.88394], [-117.97147, 33.88371], [-117.9714, 33.88344], [-117.97137, 33.88329], [-117.97136, 33.88245], [-117.97132, 33.88232], [-117.97128, 33.88225], [-117.97113, 33.88209], [-117.97093, 33.88198], [-117.9708, 33.88194], [-117.97064, 33.88192], [-117.97006, 33.88198], [-117.96907, 33.88205], [-117.96901, 33.88204], [-117.96899, 33.88201], [-117.96903, 33.882], [-117.96904, 33.88195], [-117.97007, 33.88193], [-117.97008, 33.88182], [-117.97133, 33.8818], [-117.97188, 33.88135], [-117.97186, 33.88058], [-117.97233, 33.88058], [-117.97235, 33.8831], [-117.97279, 33.88354]]]} | Open Access 1 | 270 | Emery Park | 18625 | 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 | 9.034 | Emery Park | 0 | Local Park 2 | 4 | |
126 | 126 | 125 | {"type": "Polygon", "coordinates": [[[-117.92158, 33.62047], [-117.92075, 33.62131], [-117.92059, 33.62077], [-117.92003, 33.62037], [-117.92034, 33.62006], [-117.92071, 33.62032], [-117.92089, 33.62015], [-117.92158, 33.62047]]]} | Open Access 1 | 318 | Ensign View Park | 18682 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.134 | Ensign View Park | 0 | Local Park 2 | 4 | |
5906 | 5906 | 5905 | {"type": "Polygon", "coordinates": [[[-117.9385, 33.67267], [-117.93847, 33.67503], [-117.93841, 33.67502], [-117.93789, 33.67429], [-117.93753, 33.67395], [-117.93727, 33.67379], [-117.93692, 33.6736], [-117.93658, 33.67352], [-117.9363, 33.67352], [-117.93586, 33.6736], [-117.93572, 33.67329], [-117.93563, 33.67307], [-117.93559, 33.67289], [-117.93558, 33.67274], [-117.93563, 33.67273], [-117.93565, 33.67268], [-117.9385, 33.67267]]]} | Open Access 1 | 361 | Estancia Park | 18720 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 8.831 | Estancia Park | 0 | Local Park 2 | 4 | |
5912 | 5912 | 5911 | {"type": "Polygon", "coordinates": [[[-117.92111, 33.94507], [-117.91973, 33.94508], [-117.91937, 33.94443], [-117.91927, 33.94399], [-117.91937, 33.94376], [-117.91922, 33.94348], [-117.91899, 33.94316], [-117.91905, 33.94291], [-117.91937, 33.94291], [-117.91943, 33.94277], [-117.91996, 33.94277], [-117.91997, 33.94291], [-117.9211, 33.9429], [-117.92111, 33.94507]]]} | Open Access 1 | 369 | Esteli Park | 18722 | 1155 | La Habra, City of 203 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | Orange 3 | 9.989 | Esteli Park | 0 | Local Park 2 | 4 | |
149 | 149 | 148 | {"type": "Polygon", "coordinates": [[[-117.77568, 33.85853], [-117.77547, 33.85861], [-117.77421, 33.85892], [-117.77404, 33.85905], [-117.77384, 33.85876], [-117.77385, 33.85867], [-117.77384, 33.85862], [-117.77368, 33.85847], [-117.77332, 33.85794], [-117.77303, 33.85744], [-117.77303, 33.85684], [-117.77418, 33.8563], [-117.77437, 33.85656], [-117.77436, 33.85678], [-117.77438, 33.8569], [-117.77443, 33.85701], [-117.77465, 33.85731], [-117.77471, 33.85734], [-117.77478, 33.85736], [-117.7749, 33.85735], [-117.77568, 33.85853]]]} | Open Access 1 | 381 | Eucalyptus Park | 18740 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 9.905 | Eucalyptus Park | 0 | Local Park 2 | 4 | |
166 | 166 | 165 | {"type": "Polygon", "coordinates": [[[-117.79359, 33.89318], [-117.7925, 33.89354], [-117.79204, 33.89354], [-117.79144, 33.89368], [-117.79082, 33.89369], [-117.79105, 33.89335], [-117.79115, 33.89317], [-117.79126, 33.89285], [-117.79131, 33.8926], [-117.79133, 33.89305], [-117.79295, 33.89303], [-117.79295, 33.89283], [-117.79312, 33.89283], [-117.79312, 33.89263], [-117.79317, 33.89262], [-117.79317, 33.89234], [-117.79344, 33.89233], [-117.79343, 33.89188], [-117.79357, 33.89188], [-117.79359, 33.89318]]]} | Open Access 1 | 437 | Fairmont Knolls Park | 18803 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 4.085 | Fairmont Knolls Park | 0 | Local Park 2 | 4 | |
153 | 153 | 152 | {"type": "Polygon", "coordinates": [[[-117.95453, 33.79354], [-117.95368, 33.79353], [-117.95366, 33.79224], [-117.9545, 33.79224], [-117.95453, 33.79354]]]} | Open Access 1 | 483 | Faylane Park | 18859 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 2.786 | Faylane Park | 0 | Local Park 2 | 4 | |
5936 | 5936 | 5935 | {"type": "Polygon", "coordinates": [[[-117.9531, 33.87725], [-117.953, 33.87735], [-117.95292, 33.87747], [-117.95288, 33.87762], [-117.95287, 33.87779], [-117.95084, 33.87777], [-117.95078, 33.87775], [-117.95077, 33.87723], [-117.9531, 33.87725]]]} | Open Access 1 | 509 | Fern Drive Park | 18874 | 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 | 2.953 | Fern Drive Park | 0 | Local Park 2 | 4 | |
168 | 168 | 167 | {"type": "Polygon", "coordinates": [[[-117.89514, 33.614], [-117.89456, 33.61397], [-117.89358, 33.61385], [-117.8935, 33.61387], [-117.89229, 33.61421], [-117.89219, 33.61426], [-117.89104, 33.61503], [-117.89096, 33.61513], [-117.89091, 33.61526], [-117.89088, 33.61554], [-117.89077, 33.61565], [-117.89026, 33.61591], [-117.88975, 33.61562], [-117.88988, 33.61545], [-117.89005, 33.61555], [-117.89018, 33.61539], [-117.89068, 33.61565], [-117.89078, 33.61558], [-117.89081, 33.61554], [-117.89085, 33.61536], [-117.8908, 33.61528], [-117.89079, 33.61519], [-117.8908, 33.61509], [-117.89113, 33.61463], [-117.891, 33.61454], [-117.89084, 33.6145], [-117.89066, 33.61444], [-117.89044, 33.61441], [-117.89041, 33.61439], [-117.89036, 33.61433], [-117.89018, 33.6143], [-117.89004, 33.61433], [-117.8898, 33.61442], [-117.88968, 33.61453], [-117.88966, 33.61452], [-117.89069, 33.61325], [-117.89076, 33.61318], [-117.89086, 33.61314], [-117.89096, 33.61312], [-117.89107, 33.61312], [-117.89435, 33.61364], [-117.89433, 33.61373], [-117.89514, 33.614]]]} | Open Access 1 | 536 | Back Bay View Park | 15751 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 10.648 | Back Bay View Park | 0 | Local Park 2 | 4 | |
203 | 203 | 202 | {"type": "Polygon", "coordinates": [[[-117.8759, 33.77057], [-117.8759, 33.77164], [-117.87387, 33.77142], [-117.871, 33.77154], [-117.87088, 33.77167], [-117.87063, 33.77133], [-117.87169, 33.77125], [-117.8717, 33.77141], [-117.87384, 33.77134], [-117.87386, 33.77119], [-117.87472, 33.7711], [-117.8756, 33.77074], [-117.8759, 33.77057]]]} | Open Access 1 | 544 | Fisher Park | 18919 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 3.993 | Fisher Park | 0 | Local Park 2 | 4 | |
5976 | 5976 | 5975 | {"type": "MultiPolygon", "coordinates": [[[[-117.63645, 33.63371], [-117.63639, 33.63372], [-117.63632, 33.63375], [-117.63627, 33.63382], [-117.63626, 33.63389], [-117.63508, 33.63393], [-117.63479, 33.634], [-117.63419, 33.63405], [-117.63373, 33.63419], [-117.63367, 33.63418], [-117.63361, 33.63421], [-117.63361, 33.63418], [-117.63387, 33.63406], [-117.63389, 33.63403], [-117.63386, 33.63376], [-117.63386, 33.63366], [-117.6339, 33.63346], [-117.63399, 33.63331], [-117.63408, 33.6332], [-117.63418, 33.63312], [-117.63462, 33.63289], [-117.63466, 33.63284], [-117.63394, 33.63122], [-117.63379, 33.63087], [-117.63366, 33.63048], [-117.63352, 33.63028], [-117.63329, 33.62986], [-117.63421, 33.62949], [-117.63429, 33.62948], [-117.63447, 33.6297], [-117.63548, 33.63072], [-117.63565, 33.63094], [-117.636, 33.63155], [-117.63624, 33.63207], [-117.63632, 33.63233], [-117.63638, 33.63259], [-117.63646, 33.63343], [-117.63645, 33.63371]]], [[[-117.6373, 33.63707], [-117.63697, 33.63744], [-117.6366, 33.6375], [-117.63653, 33.63727], [-117.63652, 33.63716], [-117.63633, 33.63657], [-117.63617, 33.63619], [-117.63595, 33.63574], [-117.63569, 33.63528], [-117.63564, 33.63492], [-117.63557, 33.63473], [-117.63539, 33.63433], [-117.63505, 33.63426], [-117.63506, 33.63419], [-117.63509, 33.63418], [-117.63632, 33.63414], [-117.63635, 33.63421], [-117.63641, 33.63427], [-117.6365, 33.6343], [-117.63657, 33.63431], [-117.63664, 33.63473], [-117.63682, 33.63536], [-117.63696, 33.63576], [-117.63707, 33.63598], [-117.63701, 33.63601], [-117.63696, 33.63616], [-117.63696, 33.63635], [-117.63712, 33.63668], [-117.63713, 33.63676], [-117.6372, 33.63694], [-117.63724, 33.63701], [-117.6373, 33.63707]]]]} | Open Access 1 | 562 | Florence Joyner Olympiad Park | 18960 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 28.648 | Florence Joyner Olympiad Park | 0 | Local Park 2 | 4 | |
5941 | 5941 | 5940 | {"type": "Polygon", "coordinates": [[[-117.87624, 33.74536], [-117.87445, 33.74536], [-117.87444, 33.74444], [-117.8755, 33.74444], [-117.87551, 33.74454], [-117.87624, 33.74455], [-117.87624, 33.74536]]]} | Open Access 1 | 565 | Tennis Center | 26244 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 3.988 | Tennis Ctr. | 0 | Local Recreation Area 3 | 4 | |
225 | 225 | 224 | {"type": "Polygon", "coordinates": [[[-117.64157, 33.50229], [-117.64232, 33.50243], [-117.64251, 33.5025], [-117.64268, 33.5026], [-117.64283, 33.50272], [-117.64301, 33.50296], [-117.64302, 33.503], [-117.64253, 33.50326], [-117.64249, 33.50326], [-117.64136, 33.5029], [-117.6415, 33.50259], [-117.64157, 33.50229]]]} | Open Access 1 | 612 | Four Oaks Park | 19025 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 2.499 | Four Oaks Park | 0 | Local Park 2 | 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]);