units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where ACCESS_TYP = 2, AGNCY_NAME = 244 and DES_TP = 65
This data as json, copyable, CSV (advanced)
Suggested facets: ACRES
MNG_AG_TYP 1
MNG_AGENCY 1
DES_TP 1
- Private Recreation or Education · 30 ✖
ACCESS_TYP 1
- Restricted Access · 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
705 | 705 | 704 | {"type": "Polygon", "coordinates": [[[-117.79528, 33.68552], [-117.79478, 33.68601], [-117.79345, 33.68511], [-117.79387, 33.68468], [-117.79439, 33.68492], [-117.79528, 33.68552]]]} | Restricted Access 2 | 3955 | Lemongrass Park | 21155 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.759 | Lemongrass Park | 0 | Private Recreation or Education 65 | 4 | |
779 | 779 | 778 | {"type": "Polygon", "coordinates": [[[-117.80378, 33.68325], [-117.80318, 33.68385], [-117.8024, 33.68332], [-117.80299, 33.68272], [-117.80378, 33.68325]]]} | Restricted Access 2 | 5060 | Birdsong Park | 16124 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.997 | Birdsong Park | 0 | Private Recreation or Education 65 | 4 | |
1592 | 1592 | 1591 | {"type": "Polygon", "coordinates": [[[-117.78781, 33.67973], [-117.78686, 33.68064], [-117.78636, 33.68028], [-117.7873, 33.67937], [-117.78781, 33.67973]]]} | Restricted Access 2 | 12155 | Ashwood Park | 15658 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.011 | Ashwood Park | 0 | Private Recreation or Education 65 | 4 | |
1604 | 1604 | 1603 | {"type": "Polygon", "coordinates": [[[-117.81184, 33.66673], [-117.81155, 33.66748], [-117.81149, 33.66751], [-117.81146, 33.66746], [-117.81132, 33.66739], [-117.81062, 33.66726], [-117.81077, 33.66651], [-117.81184, 33.66673]]]} | Restricted Access 2 | 12272 | Clearbrook Park | 17414 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.0 | Clearbrook Park | 0 | Private Recreation or Education 65 | 4 | |
1646 | 1646 | 1645 | {"type": "Polygon", "coordinates": [[[-117.81063, 33.67059], [-117.81046, 33.67171], [-117.80973, 33.67181], [-117.80991, 33.67052], [-117.81063, 33.67059]]]} | Restricted Access 2 | 12487 | Meadow Park | 22076 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.231 | Meadow Park | 0 | Private Recreation or Education 65 | 4 | |
1680 | 1680 | 1679 | {"type": "Polygon", "coordinates": [[[-117.81746, 33.6734], [-117.81707, 33.67379], [-117.81593, 33.67299], [-117.8157, 33.67287], [-117.81568, 33.67285], [-117.81568, 33.67278], [-117.81649, 33.67272], [-117.81746, 33.6734]]]} | Restricted Access 2 | 12685 | Timber Run Park | 26369 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.05 | Timber Run Park | 0 | Private Recreation or Education 65 | 4 | |
1692 | 1692 | 1691 | {"type": "Polygon", "coordinates": [[[-117.78759, 33.68347], [-117.78758, 33.6835], [-117.78705, 33.68403], [-117.78624, 33.68348], [-117.78675, 33.68297], [-117.78688, 33.68301], [-117.78707, 33.68309], [-117.78757, 33.68342], [-117.78759, 33.68347]]]} | Restricted Access 2 | 12755 | Wildwood Park | 27526 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.939 | Wildwood Park | 0 | Private Recreation or Education 65 | 4 | |
1796 | 1796 | 1795 | {"type": "Polygon", "coordinates": [[[-117.80523, 33.68667], [-117.8047, 33.68721], [-117.80468, 33.6872], [-117.8047, 33.68714], [-117.80468, 33.68707], [-117.80463, 33.68704], [-117.80447, 33.68703], [-117.80433, 33.68695], [-117.80385, 33.68661], [-117.80384, 33.68655], [-117.80393, 33.68641], [-117.80406, 33.68628], [-117.80409, 33.68622], [-117.80433, 33.68608], [-117.80523, 33.68667]]]} | Restricted Access 2 | 15483 | Woodpine Park | 27731 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.007 | Woodpine Park | 0 | Private Recreation or Education 65 | 4 | |
5153 | 5153 | 5152 | {"type": "Polygon", "coordinates": [[[-117.81503, 33.66922], [-117.8143, 33.66981], [-117.81368, 33.66911], [-117.81433, 33.66861], [-117.81503, 33.66922]]]} | Restricted Access 2 | 12301 | Echo Run Park | 18421 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.05 | Echo Run Park | 0 | Private Recreation or Education 65 | 4 | |
6878 | 6878 | 6877 | {"type": "Polygon", "coordinates": [[[-117.80159, 33.68926], [-117.80114, 33.68972], [-117.80084, 33.68974], [-117.80076, 33.68915], [-117.80078, 33.68909], [-117.80112, 33.68894], [-117.80159, 33.68926]]]} | Restricted Access 2 | 5540 | Blue Jay Park | 16177 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.077 | Blue Jay Park | 0 | Private Recreation or Education 65 | 4 | |
8088 | 8088 | 8087 | {"type": "Polygon", "coordinates": [[[-117.7966, 33.66983], [-117.79631, 33.67068], [-117.79544, 33.67047], [-117.79574, 33.66964], [-117.79578, 33.66962], [-117.7966, 33.66983]]]} | Restricted Access 2 | 12162 | Briarglen Park | 16371 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.017 | Briarglen Park | 0 | Private Recreation or Education 65 | 4 | |
8121 | 8121 | 8120 | {"type": "Polygon", "coordinates": [[[-117.78826, 33.67677], [-117.78752, 33.67755], [-117.78658, 33.67687], [-117.78681, 33.67669], [-117.78706, 33.67673], [-117.78726, 33.67673], [-117.78759, 33.67667], [-117.78789, 33.67665], [-117.78817, 33.67669], [-117.78825, 33.67673], [-117.78826, 33.67677]]]} | Restricted Access 2 | 12288 | Crestbrook Park | 17805 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.069 | Crestbrook Park | 0 | Private Recreation or Education 65 | 4 | |
8122 | 8122 | 8121 | {"type": "Polygon", "coordinates": [[[-117.81073, 33.67563], [-117.81009, 33.67625], [-117.80942, 33.67578], [-117.8094, 33.67575], [-117.80941, 33.67571], [-117.81, 33.67513], [-117.81073, 33.67563]]]} | Restricted Access 2 | 12293 | Daybreak Park | 17962 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.95 | Daybreak Park | 0 | Private Recreation or Education 65 | 4 | |
8128 | 8128 | 8127 | {"type": "Polygon", "coordinates": [[[-117.78342, 33.67945], [-117.78277, 33.68011], [-117.78207, 33.67962], [-117.78272, 33.67895], [-117.78282, 33.67903], [-117.78298, 33.67918], [-117.78308, 33.67921], [-117.78342, 33.67945]]]} | Restricted Access 2 | 12306 | Fallbrook Park | 18834 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.0 | Fallbrook Park | 0 | Private Recreation or Education 65 | 4 | |
8130 | 8130 | 8129 | {"type": "Polygon", "coordinates": [[[-117.79209, 33.67836], [-117.79147, 33.67898], [-117.79106, 33.6787], [-117.79096, 33.6786], [-117.79068, 33.6782], [-117.79081, 33.67818], [-117.79087, 33.67825], [-117.79093, 33.67826], [-117.79103, 33.67825], [-117.79107, 33.67821], [-117.79118, 33.67803], [-117.79136, 33.67785], [-117.79209, 33.67836]]]} | Restricted Access 2 | 12308 | Firwood Park | 18917 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.968 | Firwood Park | 0 | Private Recreation or Education 65 | 4 | |
8222 | 8222 | 8221 | {"type": "Polygon", "coordinates": [[[-117.7994, 33.67836], [-117.79936, 33.6784], [-117.79916, 33.67826], [-117.79911, 33.67831], [-117.79916, 33.67836], [-117.79902, 33.67851], [-117.79914, 33.6786], [-117.79896, 33.67878], [-117.79888, 33.67873], [-117.79881, 33.6788], [-117.79868, 33.67871], [-117.79852, 33.67887], [-117.79875, 33.67905], [-117.79867, 33.67914], [-117.79862, 33.67911], [-117.79856, 33.67919], [-117.7987, 33.6793], [-117.79868, 33.67944], [-117.79886, 33.67956], [-117.79873, 33.67966], [-117.79857, 33.67972], [-117.79816, 33.67979], [-117.79804, 33.67983], [-117.7979, 33.6799], [-117.7978, 33.67999], [-117.79776, 33.68006], [-117.7977, 33.68032], [-117.79748, 33.68048], [-117.79742, 33.68063], [-117.79741, 33.68072], [-117.79743, 33.681], [-117.79741, 33.68108], [-117.79733, 33.68121], [-117.79731, 33.6813], [-117.79736, 33.68148], [-117.79737, 33.68158], [-117.79746, 33.68164], [-117.79737, 33.68173], [-117.7972, 33.68202], [-117.79666, 33.68258], [-117.79659, 33.68258], [-117.79655, 33.68256], [-117.79658, 33.68251], [-117.79546, 33.68174], [-117.79539, 33.68181], [-117.79541, 33.68183], [-117.79533, 33.68196], [-117.79522, 33.68209], [-117.79502, 33.68225], [-117.79486, 33.68232], [-117.79471, 33.68232], [-117.7946, 33.68228], [-117.79453, 33.68223], [-117.79451, 33.68225], [-117.79429, 33.6821], [-117.7942, 33.68218], [-117.7941, 33.68219], [-117.79393, 33.68207], [-117.7938, 33.6822], [-117.79369, 33.68221], [-117.7936, 33.68216], [-117.79344, 33.68233], [-117.79341, 33.68232], [-117.79323, 33.6825], [-117.79323, 33.68252], [-117.79328, 33.68255], [-117.79309, 33.68275], [-117.79311, 33.68277], [-117.79295, 33.68294], [-117.79295, 33.68298], [-117.79277, 33.6831], [-117.79269, 33.68321], [-117.7929, 33.68337], [-117.79283, 33.68337], [-117.79276, 33.6834], [-117.79271, 33.68344], [-117.79269, 33.68351], [-117.79258, 33.68351], [-117.79237, 33.68372], [-117.79223, 33.68364], [-117.79203, 33.68383], [-117.79203, 33.68376], [-117.79199, 33.68372], [-117.79193, 33.6837], [-117.79185, 33.68371], [-117.79169, 33.68387], [-117.79165, 33.68386], [-117.79145, 33.68407], [-117.79138, 33.68403], [-117.79116, 33.68429], [-117.79044, 33.68381], [-117.79045, 33.68371], [-117.79046, 33.68369], [-117.79062, 33.68355], [-117.79082, 33.68328], [-117.79092, 33.68309], [-117.79088, 33.68306], [-117.79104, 33.68289], [-117.79102, 33.68287], [-117.79121, 33.68268], [-117.79111, 33.6826], [-117.79129, 33.68241], [-117.79127, 33.68239], [-117.79143, 33.68223], [-117.79141, 33.6822], [-117.79147, 33.68215], [-117.7915, 33.68211], [-117.79184, 33.68202], [-117.79197, 33.68202], [-117.79216, 33.68207], [-117.79234, 33.68207], [-117.7925, 33.68204], [-117.79264, 33.68197], [-117.7927, 33.68194], [-117.7928, 33.68182], [-117.79295, 33.68159], [-117.793, 33.68155], [-117.79311, 33.68147], [-117.79349, 33.68126], [-117.79374, 33.681], [-117.79373, 33.68077], [-117.79338, 33.68054], [-117.79341, 33.68049], [-117.79327, 33.6804], [-117.7934, 33.68042], [-117.7935, 33.68039], [-117.79378, 33.68012], [-117.79404, 33.68029], [-117.79445, 33.6799], [-117.79501, 33.68028], [-117.79533, 33.68024], [-117.79585, 33.6797], [-117.7956, 33.67952], [-117.79562, 33.67946], [-117.79561, 33.67939], [-117.79552, 33.67928], [-117.79621, 33.67975], [-117.79638, 33.67943], [-117.79645, 33.67935], [-117.79662, 33.67923], [-117.79675, 33.67916], [-117.79683, 33.67921], [-117.79697, 33.67908], [-117.79714, 33.67919], [-117.79723, 33.67911], [-117.79729, 33.67913], [-117.79738, 33.67904], [-117.79745, 33.67907], [-117.79754, 33.67897], [-117.79746, 33.67891], [-117.79759, 33.67878], [-117.79755, 33.67874], [-117.79762, 33.67867], [-117.7976, 33.67865], [-117.79773, 33.67852], [-117.79769, 33.67848], [-117.79777, 33.6784], [-117.7977, 33.67835], [-117.79769, 33.67828], [-117.79764, 33.67819], [-117.79746, 33.67802], [-117.79741, 33.67794], [-117.79737, 33.67782], [-117.79737, 33.67772], [-117.79745, 33.67763], [-117.79755, 33.67759], [-117.79787, 33.67728], [-117.79834, 33.67754], [-117.79874, 33.67781], [-117.79906, 33.67805], [-117.7994, 33.67836]]]} | Restricted Access 2 | 12526 | North Lake Park | 22829 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 42.339 | North Lake Park | 0 | Private Recreation or Education 65 | 4 | |
8272 | 8272 | 8271 | {"type": "Polygon", "coordinates": [[[-117.80743, 33.67464], [-117.80703, 33.67504], [-117.80686, 33.67516], [-117.80683, 33.6752], [-117.80683, 33.67526], [-117.80617, 33.67479], [-117.80694, 33.67401], [-117.80706, 33.67411], [-117.80724, 33.67441], [-117.80733, 33.67453], [-117.80742, 33.6746], [-117.80743, 33.67464]]]} | Restricted Access 2 | 12661 | Smokestone Park | 25574 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.973 | Smokestone Park | 0 | Private Recreation or Education 65 | 4 | |
8273 | 8273 | 8272 | {"type": "Polygon", "coordinates": [[[-117.80678, 33.67139], [-117.80676, 33.67142], [-117.80666, 33.67141], [-117.80656, 33.67144], [-117.80646, 33.67151], [-117.80539, 33.67258], [-117.80528, 33.67274], [-117.80528, 33.67281], [-117.80501, 33.67291], [-117.8049, 33.67309], [-117.80474, 33.67323], [-117.80456, 33.67333], [-117.8043, 33.6734], [-117.80402, 33.67352], [-117.80388, 33.6736], [-117.80364, 33.67384], [-117.80366, 33.67387], [-117.8036, 33.67393], [-117.80357, 33.67391], [-117.80345, 33.67404], [-117.80346, 33.67406], [-117.80339, 33.67414], [-117.80342, 33.67417], [-117.80335, 33.67426], [-117.80327, 33.67431], [-117.8031, 33.67449], [-117.80206, 33.67384], [-117.80145, 33.67352], [-117.80054, 33.67312], [-117.8005, 33.67302], [-117.80105, 33.67324], [-117.80186, 33.67363], [-117.80209, 33.67336], [-117.80218, 33.67339], [-117.80228, 33.67324], [-117.80228, 33.67306], [-117.8022, 33.67293], [-117.80268, 33.67314], [-117.80284, 33.67297], [-117.80289, 33.67289], [-117.80291, 33.6728], [-117.8029, 33.67248], [-117.803, 33.67226], [-117.80308, 33.67216], [-117.80315, 33.67219], [-117.80328, 33.67205], [-117.8034, 33.67211], [-117.80349, 33.67199], [-117.80344, 33.67194], [-117.8035, 33.67188], [-117.80346, 33.67182], [-117.80359, 33.67167], [-117.80355, 33.67163], [-117.8036, 33.67159], [-117.80364, 33.67147], [-117.80363, 33.67132], [-117.80361, 33.67123], [-117.80344, 33.671], [-117.80343, 33.67094], [-117.80345, 33.67081], [-117.8035, 33.67074], [-117.80286, 33.67062], [-117.80221, 33.67035], [-117.80216, 33.67031], [-117.80251, 33.66998], [-117.80268, 33.66977], [-117.80276, 33.66963], [-117.80281, 33.66949], [-117.80282, 33.66935], [-117.80308, 33.66934], [-117.80461, 33.6678], [-117.80616, 33.66797], [-117.80611, 33.66836], [-117.80628, 33.66839], [-117.80625, 33.66865], [-117.80628, 33.66868], [-117.80625, 33.66873], [-117.80624, 33.66876], [-117.80626, 33.6688], [-117.80622, 33.66884], [-117.80614, 33.66937], [-117.80609, 33.66942], [-117.80609, 33.66949], [-117.80559, 33.66944], [-117.80556, 33.66951], [-117.80544, 33.6695], [-117.80541, 33.66969], [-117.8053, 33.66968], [-117.80527, 33.66986], [-117.80521, 33.66987], [-117.8052, 33.66996], [-117.8053, 33.66998], [-117.80527, 33.67016], [-117.80535, 33.67017], [-117.80531, 33.6703], [-117.80518, 33.6705], [-117.80506, 33.67057], [-117.80488, 33.67059], [-117.80487, 33.6706], [-117.80491, 33.67067], [-117.80602, 33.67119], [-117.80631, 33.67127], [-117.80655, 33.67131], [-117.80678, 33.67139]]]} | Restricted Access 2 | 12662 | South Lake Park | 25662 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 39.165 | South Lake Park | 0 | Private Recreation or Education 65 | 4 | |
8274 | 8274 | 8273 | {"type": "Polygon", "coordinates": [[[-117.81298, 33.67241], [-117.81313, 33.67272], [-117.81315, 33.67281], [-117.81317, 33.67293], [-117.81317, 33.67305], [-117.81313, 33.67319], [-117.81302, 33.67338], [-117.81295, 33.67343], [-117.81267, 33.67371], [-117.81262, 33.67374], [-117.81258, 33.67374], [-117.81254, 33.67373], [-117.81203, 33.67338], [-117.81298, 33.67241]]]} | Restricted Access 2 | 12664 | Springacre Park | 25743 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.987 | Springacre Park | 0 | Private Recreation or Education 65 | 4 | |
8275 | 8275 | 8274 | {"type": "Polygon", "coordinates": [[[-117.79219, 33.66769], [-117.79215, 33.66773], [-117.79143, 33.66723], [-117.7918, 33.66686], [-117.792, 33.667], [-117.79215, 33.66702], [-117.7922, 33.66712], [-117.79238, 33.66725], [-117.79237, 33.66731], [-117.79218, 33.66751], [-117.79216, 33.6676], [-117.79219, 33.66769]]]} | Restricted Access 2 | 12665 | Springbrook Park | 25745 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 1.032 | Springbrook 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]);