units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where MNG_AGENCY = 356 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 18
- Local Recreation Area 3
- None 1
MNG_AG_TYP 1
- City Agency 22
MNG_AGENCY 1
- Temecula, City of · 22 ✖
ACCESS_TYP 1
- Open Access 22
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12005 | 12005 | 12004 | {"type": "Polygon", "coordinates": [[[-117.09832, 33.45288], [-117.09729, 33.45379], [-117.09709, 33.45401], [-117.09692, 33.45424], [-117.09675, 33.45454], [-117.09662, 33.45489], [-117.09655, 33.45521], [-117.09653, 33.45553], [-117.09333, 33.45554], [-117.09182, 33.4544], [-117.09582, 33.45067], [-117.09649, 33.45127], [-117.09803, 33.4527], [-117.09814, 33.45279], [-117.09832, 33.45288]]]} | Open Access 1 | 24674 | Patricia H. Birdsall Sports Park | 23508 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 44.044 | Patricia H. Birdsall Sports Park | 0 | Local Recreation Area 3 | 4 | |
12006 | 12006 | 12005 | {"type": "Polygon", "coordinates": [[[-117.08147, 33.51191], [-117.08005, 33.5122], [-117.07996, 33.51216], [-117.07978, 33.51167], [-117.07967, 33.51144], [-117.07953, 33.51121], [-117.08118, 33.5104], [-117.08111, 33.51081], [-117.08147, 33.51191]]]} | Open Access 1 | 24675 | Pauba Ridge Park | 23528 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 5.176 | Pauba Ridge Park | 0 | Local Park 2 | 4 | |
14476 | 14476 | 14475 | {"type": "Polygon", "coordinates": [[[-117.10241, 33.47537], [-117.09849, 33.47666], [-117.09832, 33.47667], [-117.09781, 33.47684], [-117.09755, 33.47687], [-117.0971, 33.47662], [-117.09753, 33.47644], [-117.09874, 33.4758], [-117.09882, 33.47553], [-117.10044, 33.47453], [-117.10147, 33.47393], [-117.10199, 33.47381], [-117.10201, 33.47453], [-117.10241, 33.47537]]]} | Open Access 1 | 47174 | Redhawk Community Park | 30865 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/RedhawkCommunityPark.htm | Riverside 10 | 14.627 | Redhawk Community Park | 0 | Local Park 2 | 4 |
2939 | 2939 | 2938 | {"type": "Polygon", "coordinates": [[[-117.11174, 33.54046], [-117.11064, 33.54088], [-117.11044, 33.54051], [-117.11037, 33.5403], [-117.11029, 33.54023], [-117.11017, 33.5402], [-117.10995, 33.54022], [-117.10945, 33.54022], [-117.1094, 33.54018], [-117.10941, 33.54007], [-117.10945, 33.53995], [-117.1102, 33.53848], [-117.1105, 33.53856], [-117.11048, 33.53876], [-117.1105, 33.53919], [-117.11049, 33.53969], [-117.11064, 33.53993], [-117.11174, 33.54046]]]} | Open Access 1 | 19942 | Riverton Park | 24461 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 4.979 | Riverton Park | 0 | Local Park 2 | 4 | |
12007 | 12007 | 12006 | {"type": "Polygon", "coordinates": [[[-117.12532, 33.49784], [-117.1252, 33.49987], [-117.1246, 33.49986], [-117.12394, 33.49991], [-117.12358, 33.49997], [-117.12323, 33.50005], [-117.12271, 33.50021], [-117.12219, 33.50042], [-117.12175, 33.50065], [-117.12135, 33.5009], [-117.12068, 33.50139], [-117.1206, 33.50131], [-117.12044, 33.50134], [-117.12044, 33.5014], [-117.12054, 33.50149], [-117.12035, 33.50163], [-117.11966, 33.50101], [-117.11988, 33.50085], [-117.11987, 33.50076], [-117.11974, 33.50063], [-117.11947, 33.50083], [-117.11675, 33.49838], [-117.11641, 33.49809], [-117.1162, 33.49795], [-117.11677, 33.49763], [-117.11708, 33.4975], [-117.1174, 33.49739], [-117.11773, 33.4973], [-117.11807, 33.49724], [-117.11841, 33.49721], [-117.12046, 33.4971], [-117.12032, 33.49805], [-117.12014, 33.49817], [-117.12002, 33.4985], [-117.11986, 33.49908], [-117.12005, 33.4992], [-117.12075, 33.49932], [-117.12135, 33.49929], [-117.12141, 33.4986], [-117.12104, 33.49844], [-117.12172, 33.49814], [-117.1221, 33.49799], [-117.12241, 33.4979], [-117.12281, 33.49781], [-117.12314, 33.49776], [-117.12364, 33.49772], [-117.12426, 33.49773], [-117.12532, 33.49784]]]} | Open Access 1 | 24676 | Ronald Reagan Sports Park | 24591 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 52.442 | Ronald Reagan Sports Park | 0 | Local Recreation Area 3 | 4 | |
2514 | 2514 | 2513 | {"type": "Polygon", "coordinates": [[[-117.14777, 33.48896], [-117.14754, 33.48901], [-117.1464, 33.48571], [-117.14663, 33.48566], [-117.14777, 33.48896]]]} | Open Access 1 | 19949 | Rotary Park | 24698 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.063 | Rotary Park | 0 | Local Park 2 | 4 | |
11355 | 11355 | 11354 | {"type": "Polygon", "coordinates": [[[-117.15188, 33.49686], [-117.15163, 33.49762], [-117.15159, 33.4976], [-117.15143, 33.49804], [-117.15136, 33.49802], [-117.15092, 33.49756], [-117.15013, 33.49809], [-117.15002, 33.49794], [-117.15099, 33.4971], [-117.15102, 33.49711], [-117.15113, 33.49701], [-117.15094, 33.49684], [-117.15137, 33.49681], [-117.15137, 33.49683], [-117.15167, 33.49683], [-117.15188, 33.49686]]]} | Open Access 1 | 22136 | Sam Hicks Monument Park | 24817 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.612 | Sam Hicks Monument Park | 0 | Local Park 2 | 4 | |
4133 | 4133 | 4132 | {"type": "Polygon", "coordinates": [[[-117.10489, 33.52993], [-117.10489, 33.52993], [-117.10464, 33.5314], [-117.10454, 33.53111], [-117.10447, 33.53097], [-117.10391, 33.53015], [-117.10394, 33.53007], [-117.10426, 33.52989], [-117.10456, 33.52969], [-117.10484, 33.52947], [-117.1049, 33.52951], [-117.10493, 33.52956], [-117.10492, 33.5296], [-117.10487, 33.52967], [-117.10489, 33.5297], [-117.10483, 33.52975], [-117.10481, 33.52981], [-117.10483, 33.52988], [-117.10489, 33.52993]]]} | Open Access 1 | 47168 | Serena Hills Park | 30855 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/SerenaHillsPark.htm | Riverside 10 | 2.237 | Serena Hills Park | 0 | Local Park 2 | 4 |
14512 | 14512 | 14511 | {"type": "MultiPolygon", "coordinates": [[[[-117.10094, 33.54351], [-117.10092, 33.54417], [-117.10087, 33.54452], [-117.10078, 33.54487], [-117.10066, 33.54521], [-117.1005, 33.54554], [-117.10031, 33.54585], [-117.1001, 33.54616], [-117.1, 33.54617], [-117.09914, 33.54571], [-117.0987, 33.54552], [-117.09824, 33.54537], [-117.09776, 33.54525], [-117.09728, 33.54517], [-117.0976, 33.543], [-117.09919, 33.54308], [-117.0995, 33.54315], [-117.10023, 33.54346], [-117.10051, 33.54351], [-117.10094, 33.54351]]], [[[-117.10296, 33.5503], [-117.10246, 33.55222], [-117.10125, 33.55193], [-117.1012, 33.55185], [-117.10134, 33.55129], [-117.10135, 33.55116], [-117.10134, 33.55089], [-117.10126, 33.55063], [-117.10113, 33.55039], [-117.10105, 33.55027], [-117.10296, 33.5503]]]]} | Open Access 1 | 47176 | Skyview Park | 32843 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 27.722 | Skyview Park | 0 | Local Park 2 | 4 | |
4132 | 4132 | 4131 | {"type": "Polygon", "coordinates": [[[-117.07627, 33.4742], [-117.07537, 33.47446], [-117.07523, 33.47432], [-117.07478, 33.47396], [-117.07499, 33.47382], [-117.07522, 33.47371], [-117.07546, 33.47361], [-117.07588, 33.47347], [-117.07599, 33.47351], [-117.07627, 33.4742]]]} | Open Access 1 | 47167 | Stephen Linen Jr. Memorial Park | 30852 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/StephenLinenJrMemorialPark.htm | Riverside 10 | 2.187 | Stephen Linen Jr. Memorial Park | 0 | Local Park 2 | 4 |
14509 | 14509 | 14508 | {"type": "Polygon", "coordinates": [[[-117.09846, 33.46835], [-117.09812, 33.46893], [-117.09775, 33.4688], [-117.09757, 33.46869], [-117.09743, 33.46855], [-117.09731, 33.46834], [-117.09734, 33.46829], [-117.09782, 33.46814], [-117.09819, 33.46799], [-117.09846, 33.46835]]]} | Open Access 1 | 47175 | Sunset Park | 30866 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/SunsetPark.htm | Riverside 10 | 1.613 | Sunset Park | 0 | Local Park 2 | 4 |
12008 | 12008 | 12007 | {"type": "Polygon", "coordinates": [[[-117.07633, 33.48251], [-117.07622, 33.48256], [-117.07614, 33.48257], [-117.0761, 33.48266], [-117.07614, 33.48271], [-117.07615, 33.48275], [-117.07614, 33.48278], [-117.07611, 33.48279], [-117.07597, 33.48279], [-117.07579, 33.48273], [-117.07547, 33.4828], [-117.07518, 33.48289], [-117.07445, 33.48317], [-117.07403, 33.48341], [-117.07357, 33.4835], [-117.07323, 33.48353], [-117.07275, 33.48352], [-117.0723, 33.48347], [-117.07213, 33.48348], [-117.07194, 33.48346], [-117.07155, 33.48349], [-117.07143, 33.48347], [-117.07142, 33.48348], [-117.07124, 33.48344], [-117.07103, 33.48343], [-117.0709, 33.4834], [-117.07081, 33.48336], [-117.07069, 33.48328], [-117.07045, 33.48316], [-117.07034, 33.48305], [-117.07025, 33.48301], [-117.07009, 33.48299], [-117.06983, 33.48303], [-117.06961, 33.48299], [-117.06975, 33.48277], [-117.0705, 33.48258], [-117.07043, 33.48242], [-117.07028, 33.48217], [-117.07037, 33.48214], [-117.07062, 33.48252], [-117.07068, 33.48277], [-117.07073, 33.48286], [-117.07082, 33.48297], [-117.07098, 33.48307], [-117.07144, 33.48326], [-117.07158, 33.48329], [-117.07198, 33.48326], [-117.07236, 33.4833], [-117.07313, 33.48334], [-117.07367, 33.48331], [-117.07392, 33.48324], [-117.07413, 33.4831], [-117.07441, 33.48296], [-117.07461, 33.4829], [-117.0753, 33.48262], [-117.07548, 33.48258], [-117.07598, 33.48256], [-117.0761, 33.48252], [-117.07614, 33.48249], [-117.07615, 33.48242], [-117.07605, 33.4822], [-117.07605, 33.48217], [-117.07608, 33.48214], [-117.07633, 33.48251]]]} | Open Access 1 | 24677 | Temecula Creek Trail Park | 26226 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 4.345 | Temecula Creek Trail Park | 0 | Local Park 2 | 4 | |
11357 | 11357 | 11356 | {"type": "Polygon", "coordinates": [[[-117.14821, 33.50276], [-117.1482, 33.50286], [-117.14645, 33.50406], [-117.14639, 33.5039], [-117.14645, 33.50371], [-117.14658, 33.50354], [-117.14665, 33.50358], [-117.14669, 33.50356], [-117.14672, 33.50353], [-117.1467, 33.50348], [-117.14663, 33.50345], [-117.1466, 33.50337], [-117.14668, 33.50331], [-117.14669, 33.50323], [-117.14663, 33.50308], [-117.14666, 33.50306], [-117.14666, 33.50301], [-117.14661, 33.50298], [-117.14655, 33.503], [-117.1465, 33.50298], [-117.14649, 33.50286], [-117.14649, 33.50276], [-117.14637, 33.50277], [-117.14634, 33.50282], [-117.14614, 33.50278], [-117.14612, 33.50266], [-117.14601, 33.50244], [-117.14596, 33.50238], [-117.14587, 33.50234], [-117.14551, 33.50191], [-117.14595, 33.50177], [-117.14605, 33.50172], [-117.14614, 33.50166], [-117.1464, 33.50141], [-117.14799, 33.50258], [-117.14821, 33.50276]]]} | Open Access 1 | 22137 | Temecula Duck Pond | 26227 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 7.504 | Temecula Duck Pond | None 997 | |||
14445 | 14445 | 14444 | {"type": "Polygon", "coordinates": [[[-117.12141, 33.49859], [-117.12135, 33.49929], [-117.12075, 33.49932], [-117.12005, 33.4992], [-117.11986, 33.49909], [-117.12002, 33.4985], [-117.12015, 33.49817], [-117.12032, 33.49805], [-117.12098, 33.49847], [-117.12104, 33.49844], [-117.12141, 33.49859]]]} | Open Access 1 | 47173 | Temecula Skate Park | 30864 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/SkatePark.htm | Riverside 10 | 3.466 | Temecula Skate Park | 0 | Local Recreation Area 3 | 4 |
12009 | 12009 | 12008 | {"type": "Polygon", "coordinates": [[[-117.11426, 33.52396], [-117.11345, 33.52488], [-117.11317, 33.52517], [-117.11287, 33.52545], [-117.11255, 33.5257], [-117.11242, 33.52579], [-117.1123, 33.52579], [-117.11191, 33.5253], [-117.11159, 33.52479], [-117.11148, 33.52458], [-117.11115, 33.52369], [-117.11119, 33.5236], [-117.11147, 33.5235], [-117.11158, 33.52343], [-117.11167, 33.52332], [-117.11174, 33.5233], [-117.11215, 33.52338], [-117.11289, 33.52342], [-117.11307, 33.52345], [-117.1132, 33.5235], [-117.11346, 33.52363], [-117.11374, 33.52384], [-117.11387, 33.52385], [-117.11394, 33.52383], [-117.11399, 33.52379], [-117.11426, 33.52396]]]} | Open Access 1 | 24678 | Temeku Hills Park | 26228 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 11.412 | Temeku Hills Park | 0 | Local Park 2 | 4 | |
14516 | 14516 | 14515 | {"type": "Polygon", "coordinates": [[[-117.14791, 33.49437], [-117.14766, 33.49416], [-117.14786, 33.49399], [-117.14794, 33.49397], [-117.14803, 33.49397], [-117.14808, 33.494], [-117.14813, 33.49406], [-117.14814, 33.49415], [-117.14811, 33.4942], [-117.14791, 33.49437]]]} | Open Access 1 | 47180 | Town Square | 30871 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 0.288 | Town Square | 0 | Local Park 2 | 4 | |
12010 | 12010 | 12009 | {"type": "Polygon", "coordinates": [[[-117.08685, 33.47747], [-117.08646, 33.47801], [-117.08626, 33.47824], [-117.08603, 33.47844], [-117.08578, 33.47863], [-117.08566, 33.47861], [-117.08547, 33.47843], [-117.08518, 33.47809], [-117.08549, 33.47789], [-117.08521, 33.47757], [-117.08478, 33.47736], [-117.08287, 33.47678], [-117.08253, 33.4767], [-117.08206, 33.47608], [-117.08225, 33.47582], [-117.08225, 33.47551], [-117.08201, 33.47528], [-117.08165, 33.47527], [-117.0815, 33.47535], [-117.08114, 33.47488], [-117.08132, 33.47468], [-117.08128, 33.4744], [-117.08115, 33.47415], [-117.08077, 33.47397], [-117.08061, 33.47388], [-117.0805, 33.47377], [-117.08033, 33.47351], [-117.08028, 33.47317], [-117.08076, 33.47312], [-117.08093, 33.47371], [-117.08117, 33.47393], [-117.08159, 33.47407], [-117.08172, 33.47444], [-117.08204, 33.47463], [-117.08262, 33.47452], [-117.08277, 33.47467], [-117.0829, 33.4754], [-117.08318, 33.47576], [-117.08356, 33.47605], [-117.08405, 33.47619], [-117.08457, 33.47615], [-117.08463, 33.47641], [-117.08458, 33.47648], [-117.08458, 33.47656], [-117.08428, 33.47658], [-117.08433, 33.4768], [-117.08466, 33.47695], [-117.08507, 33.47689], [-117.08525, 33.4769], [-117.08654, 33.47739], [-117.08685, 33.47747]]]} | Open Access 1 | 24679 | Vail Ranch Park | 26754 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 16.323 | Vail Ranch Park | 0 | Local Park 2 | 4 | |
10727 | 10727 | 10726 | {"type": "Polygon", "coordinates": [[[-117.12176, 33.51628], [-117.12161, 33.51668], [-117.12156, 33.51689], [-117.12153, 33.5171], [-117.12152, 33.51731], [-117.12153, 33.51752], [-117.12166, 33.51861], [-117.12166, 33.51883], [-117.1216, 33.51921], [-117.12154, 33.51939], [-117.12138, 33.51971], [-117.12105, 33.52013], [-117.12081, 33.52035], [-117.12045, 33.52058], [-117.12027, 33.51798], [-117.12028, 33.51762], [-117.12038, 33.51558], [-117.12172, 33.51621], [-117.12176, 33.51628]]]} | Open Access 1 | 19943 | Veterans Park | 27053 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 13.721 | Veterans Park | 0 | Local Park 2 | 4 | |
2851 | 2851 | 2850 | {"type": "Polygon", "coordinates": [[[-117.13417, 33.5384], [-117.13414, 33.53866], [-117.13392, 33.5387], [-117.13353, 33.53869], [-117.13336, 33.53866], [-117.1325, 33.5387], [-117.13407, 33.53834], [-117.13417, 33.5384]]]} | Open Access 1 | 22140 | Voorburg Park | 27197 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 0.728 | Voorburg Park | 0 | Local Park 2 | 4 | |
3059 | 3059 | 3058 | {"type": "Polygon", "coordinates": [[[-117.15257, 33.54356], [-117.15135, 33.5445], [-117.15049, 33.54371], [-117.1517, 33.54277], [-117.15257, 33.54356]]]} | Open Access 1 | 24680 | Winchester Creek Park | 27617 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 4.498 | Winchester Creek 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]);