units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
268 rows where DES_TP = 65 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, MNG_AG_LEV, PARK_URL, COUNTY, YR_EST
MNG_AGENCY >30
- Woodbridge Village Association 30
- Mountains Restoration Trust 26
- Home Owners Association - Unknown Name 25
- Rancho Santa Margarita Landscape and Recreation Corporation 17
- Amerige Heights Community Association 7
- Los Angeles Neighborhood Land Trust 6
- San Dieguito River Valley Land Conservancy 5
- Arroyos and Foothills Conservancy 4
- Paseo Westpark Maintenance Association 4
- Deerfield Community Association 4
- Nellie Gail Ranch Owners Association 4
- Westpark Maintenance District 4
- Sierra Bonita Community Association 4
- Town Center Association 4
- Private Landowner 3
- Odd Fellows Sierra Recreation Association 3
- Northpark Square Maintenance Association 3
- Turtle Rock Broadmoor Community Association 3
- Oak Creek Village Maintenance Association 2
- Quail Hill Community Association 2
- Truckee Donner Land Trust 2
- Trinidad Coastal Land Trust 2
- Broadmoor Campus View Community Association 2
- Trust for Public Land 2
- Woodbridge Owners Association 2
- Northpark Maintenance Association 2
- Windwood Homeowners Association 2
- Johnson Ranch Community Association 2
- Woodbury Community Association 2
- John Muir Land Trust 1
- …
MNG_AG_TYP 10
ACCESS_TYP 4
- Restricted Access 194
- Open Access 48
- No Public Access 25
- Unknown Access 1
AGNCY_LEV 2 ✖
- Private 193
- Non Profit 75
DES_TP 1
- Private Recreation or Education · 268 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1665 | 1665 | 1664 | {"type": "Polygon", "coordinates": [[[-117.78817, 33.666], [-117.78729, 33.66687], [-117.78636, 33.66624], [-117.78725, 33.66535], [-117.78817, 33.666]]]} | Restricted Access 2 | 12583 | Royal Oak Park | 24713 | 6014 | Oak Creek Village Maintenance Association 405 | Private 7 | Home Owners Association 16 | Private 14 | 6014 | Oak Creek Village Maintenance Association 399 | Private 7 | Home Owners Association 15 | Orange 3 | 3.524 | Royal Oak Park | 0 | Private Recreation or Education 65 | 4 | ||
| 3420 | 3420 | 3419 | {"type": "Polygon", "coordinates": [[[-117.05959, 32.78133], [-117.05924, 32.78214], [-117.0579, 32.78173], [-117.05777, 32.78163], [-117.05832, 32.78034], [-117.05875, 32.78051], [-117.05875, 32.78059], [-117.0588, 32.78065], [-117.05889, 32.78067], [-117.05897, 32.78065], [-117.05922, 32.78083], [-117.05921, 32.78113], [-117.05925, 32.78141], [-117.05959, 32.78132], [-117.05959, 32.78133]]]} | Restricted Access 2 | 25123 | Del Cerro Park | 31745 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 4.764 | Del Cerro Park | 0 | Private Recreation or Education 65 | 4 | ||
| 3512 | 3512 | 3511 | {"type": "Polygon", "coordinates": [[[-117.8, 33.63663], [-117.79999, 33.63665], [-117.80001, 33.63696], [-117.79993, 33.63714], [-117.79993, 33.63721], [-117.79994, 33.63725], [-117.79977, 33.63733], [-117.79914, 33.63718], [-117.79908, 33.63712], [-117.799, 33.63711], [-117.799, 33.63679], [-117.79894, 33.63605], [-117.79896, 33.63585], [-117.79913, 33.63589], [-117.79912, 33.63598], [-117.79915, 33.63606], [-117.79936, 33.6362], [-117.79941, 33.63622], [-117.79964, 33.63623], [-117.79976, 33.63628], [-117.79994, 33.63648], [-117.79998, 33.63654], [-117.8, 33.63663]]]} | Restricted Access 2 | 36116 | HOA Community Park | 31986 | 6028 | Turtle Rock Ridge Association 652 | Private 7 | Home Owners Association 16 | Private 14 | 6028 | Turtle Rock Ridge Association 641 | Private 7 | Home Owners Association 15 | Orange 3 | 2.684 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | ||
| 3513 | 3513 | 3512 | {"type": "Polygon", "coordinates": [[[-117.81397, 33.68873], [-117.81343, 33.68929], [-117.81316, 33.68912], [-117.81251, 33.68866], [-117.81295, 33.68837], [-117.81303, 33.68829], [-117.81307, 33.68822], [-117.81318, 33.68818], [-117.81397, 33.68873]]]} | Restricted Access 2 | 36118 | Santa Clara Park | 32396 | 6018 | Paseo Westpark Maintenance Association 653 | Private 7 | Home Owners Association 16 | Private 14 | 6018 | Paseo Westpark Maintenance Association 642 | Private 7 | Home Owners Association 15 | Orange 3 | 2.033 | Santa Clara Park | 0 | Private Recreation or Education 65 | 4 | ||
| 3806 | 3806 | 3805 | {"type": "Polygon", "coordinates": [[[-116.97738, 32.65693], [-116.97721, 32.65698], [-116.9771, 32.65706], [-116.97694, 32.65721], [-116.97668, 32.65643], [-116.97706, 32.65643], [-116.97724, 32.65675], [-116.97738, 32.65693]]]} | Restricted Access 2 | 45163 | Cobblestone Park | 33360 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.726 | Cobblestone Park | 0 | Private Recreation or Education 65 | 4 | ||
| 3813 | 3813 | 3812 | {"type": "Polygon", "coordinates": [[[-116.99456, 32.62803], [-116.99407, 32.62875], [-116.99394, 32.62888], [-116.99368, 32.62907], [-116.99364, 32.62907], [-116.99332, 32.62882], [-116.9933, 32.62871], [-116.99399, 32.62774], [-116.99403, 32.62773], [-116.99455, 32.62799], [-116.99456, 32.62803]]]} | Restricted Access 2 | 45186 | Oak Crest Park | 33358 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 2.168 | Oak Crest Park | 0 | Private Recreation or Education 65 | 4 | ||
| 3814 | 3814 | 3813 | {"type": "Polygon", "coordinates": [[[-116.96275, 32.65963], [-116.96272, 32.6598], [-116.96273, 32.65988], [-116.96252, 32.65994], [-116.96249, 32.65993], [-116.96238, 32.65998], [-116.96235, 32.65997], [-116.96224, 32.66002], [-116.96221, 32.66001], [-116.96195, 32.6601], [-116.96175, 32.66013], [-116.96165, 32.65965], [-116.96164, 32.6595], [-116.96167, 32.65933], [-116.96188, 32.65935], [-116.962, 32.6594], [-116.96203, 32.65939], [-116.96215, 32.65944], [-116.96218, 32.65943], [-116.96245, 32.65955], [-116.96275, 32.65963]]]} | Restricted Access 2 | 45187 | Madison Lane Park | 33353 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 1.505 | Madison Lane Park | 0 | Private Recreation or Education 65 | 4 | ||
| 3843 | 3843 | 3842 | {"type": "Polygon", "coordinates": [[[-117.82217, 33.64995], [-117.82193, 33.64998], [-117.82124, 33.65], [-117.82125, 33.6497], [-117.8212, 33.64969], [-117.82123, 33.64946], [-117.8212, 33.64942], [-117.82123, 33.6492], [-117.82123, 33.64892], [-117.82118, 33.64891], [-117.82121, 33.64871], [-117.82121, 33.64864], [-117.82141, 33.64862], [-117.82155, 33.64859], [-117.82174, 33.64887], [-117.82151, 33.649], [-117.82152, 33.64906], [-117.82168, 33.64925], [-117.82175, 33.64926], [-117.82188, 33.64941], [-117.82183, 33.64946], [-117.82217, 33.64995]]]} | Restricted Access 2 | 35490 | Paseo Park | 32335 | 6001 | Broadmoor Campus View Community Association 691 | Private 7 | Home Owners Association 16 | Private 14 | 6001 | Broadmoor Campus View Community Association 681 | Private 7 | Home Owners Association 15 | Orange 3 | 2.01 | Paseo Park | 0 | Private Recreation or Education 65 | 4 | ||
| 3919 | 3919 | 3918 | {"type": "Polygon", "coordinates": [[[-117.62662, 33.59091], [-117.62663, 33.59093], [-117.62662, 33.591], [-117.62606, 33.5917], [-117.62547, 33.59254], [-117.62527, 33.59238], [-117.62515, 33.59227], [-117.62488, 33.59227], [-117.62481, 33.59233], [-117.62478, 33.59237], [-117.6247, 33.59236], [-117.62464, 33.59239], [-117.62436, 33.59244], [-117.62411, 33.5927], [-117.62405, 33.59275], [-117.62399, 33.59277], [-117.62389, 33.59271], [-117.62381, 33.59272], [-117.62369, 33.59249], [-117.62358, 33.59244], [-117.62362, 33.59238], [-117.6237, 33.59216], [-117.62369, 33.5921], [-117.62365, 33.59207], [-117.62346, 33.59204], [-117.62344, 33.59205], [-117.62341, 33.59202], [-117.62334, 33.59198], [-117.6233, 33.59179], [-117.62307, 33.5917], [-117.62309, 33.59165], [-117.62305, 33.59163], [-117.62323, 33.59136], [-117.62358, 33.59091], [-117.62376, 33.59095], [-117.62418, 33.59107], [-117.62426, 33.59106], [-117.62461, 33.59095], [-117.62472, 33.59087], [-117.62497, 33.59047], [-117.62533, 33.59009], [-117.62588, 33.59031], [-117.62586, 33.59037], [-117.62591, 33.59045], [-117.62609, 33.59052], [-117.62635, 33.59074], [-117.62662, 33.59091]]]} | Restricted Access 2 | 36105 | Oak Tree Park | 32384 | 6047 | L F Maintenance Corporation 697 | Private 7 | Home Owners Association 16 | Private 14 | 6047 | L F Maintenance Corporation 687 | Private 7 | Home Owners Association 15 | Orange 3 | 12.69 | Oak Tree Park | 0 | Private Recreation or Education 65 | 4 | ||
| 3925 | 3925 | 3924 | {"type": "Polygon", "coordinates": [[[-117.80367, 33.69677], [-117.80367, 33.69684], [-117.80303, 33.69712], [-117.80284, 33.6968], [-117.80285, 33.69674], [-117.80285, 33.69669], [-117.80271, 33.69652], [-117.80257, 33.69625], [-117.80257, 33.69623], [-117.80263, 33.69619], [-117.80272, 33.69616], [-117.80332, 33.69605], [-117.80341, 33.69613], [-117.8035, 33.69638], [-117.80367, 33.69677]]]} | Restricted Access 2 | 36161 | Santa Luisa Park | 32290 | 6018 | Paseo Westpark Maintenance Association 653 | Private 7 | Home Owners Association 16 | Private 14 | 6018 | Paseo Westpark Maintenance Association 642 | Private 7 | Home Owners Association 15 | Orange 3 | 1.832 | Santa Luisa Park | 0 | Private Recreation or Education 65 | 4 | ||
| 4258 | 4258 | 4257 | {"type": "Polygon", "coordinates": [[[-116.95997, 32.62142], [-116.9593, 32.62156], [-116.95916, 32.62104], [-116.95966, 32.62083], [-116.95972, 32.62084], [-116.95987, 32.6211], [-116.95997, 32.62142]]]} | Restricted Access 2 | 45184 | HOA Park | 31749 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 1.008 | HOA Park | 0 | Private Recreation or Education 65 | 4 | ||
| 4259 | 4259 | 4258 | {"type": "Polygon", "coordinates": [[[-116.98256, 32.62142], [-116.98251, 32.62145], [-116.98215, 32.62155], [-116.98208, 32.62155], [-116.98189, 32.62107], [-116.98195, 32.62104], [-116.98229, 32.62094], [-116.98237, 32.62094], [-116.98256, 32.62142]]]} | Restricted Access 2 | 45185 | Hillsborough Park | 33348 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.702 | Hillsborough Park | 0 | Private Recreation or Education 65 | 4 | ||
| 4265 | 4265 | 4264 | {"type": "Polygon", "coordinates": [[[-116.9567, 32.66503], [-116.95654, 32.66512], [-116.95638, 32.66517], [-116.95606, 32.66524], [-116.95601, 32.66487], [-116.95602, 32.66467], [-116.95616, 32.66437], [-116.95618, 32.66437], [-116.95629, 32.66455], [-116.95631, 32.66456], [-116.95642, 32.66473], [-116.95646, 32.66474], [-116.9567, 32.66503]]]} | Restricted Access 2 | 45205 | Magnolia Hill Park | 33356 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.848 | Magnolia Hill Park | 0 | Private Recreation or Education 65 | 4 | ||
| 4960 | 4960 | 4959 | {"type": "MultiPolygon", "coordinates": [[[[-116.95389, 32.62879], [-116.95386, 32.62885], [-116.95334, 32.62907], [-116.95288, 32.6293], [-116.94886, 32.63154], [-116.94878, 32.63152], [-116.94777, 32.63021], [-116.94712, 32.62933], [-116.94715, 32.62927], [-116.9473, 32.6292], [-116.94749, 32.62947], [-116.94866, 32.63102], [-116.94885, 32.63109], [-116.94899, 32.63111], [-116.94912, 32.6311], [-116.94923, 32.63107], [-116.95003, 32.63059], [-116.95025, 32.6302], [-116.95064, 32.63024], [-116.95164, 32.62962], [-116.95191, 32.62941], [-116.95206, 32.62932], [-116.95252, 32.62929], [-116.95344, 32.62876], [-116.95358, 32.62861], [-116.95357, 32.62844], [-116.95371, 32.62841], [-116.95389, 32.62879]]], [[[-116.95778, 32.62794], [-116.95704, 32.6281], [-116.95487, 32.62855], [-116.95422, 32.62873], [-116.95415, 32.6287], [-116.954, 32.6284], [-116.95407, 32.62837], [-116.95416, 32.62846], [-116.95443, 32.62854], [-116.95604, 32.62813], [-116.95694, 32.62793], [-116.95724, 32.62792], [-116.95741, 32.62789], [-116.95759, 32.62775], [-116.95778, 32.62794]]]]} | Restricted Access 2 | 45161 | HOA Open Space | 31748 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 7.416 | HOA OS | 0 | Private Recreation or Education 65 | 4 | ||
| 4962 | 4962 | 4961 | {"type": "MultiPolygon", "coordinates": [[[[-116.98594, 32.6469], [-116.98591, 32.64692], [-116.98584, 32.64693], [-116.98545, 32.64674], [-116.98558, 32.64668], [-116.98578, 32.64682], [-116.98594, 32.6469]]], [[[-116.98664, 32.64925], [-116.98652, 32.64925], [-116.98693, 32.64859], [-116.98705, 32.64845], [-116.98707, 32.64834], [-116.98707, 32.64814], [-116.98696, 32.64797], [-116.98662, 32.64767], [-116.98618, 32.64741], [-116.98595, 32.64725], [-116.98675, 32.64765], [-116.98695, 32.64777], [-116.98717, 32.64793], [-116.98748, 32.64821], [-116.98747, 32.64827], [-116.98717, 32.64855], [-116.98694, 32.64882], [-116.98664, 32.64925]]]]} | Restricted Access 2 | 45162 | HOA Open Space | 31748 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 1.099 | HOA OS | 0 | Private Recreation or Education 65 | 4 | ||
| 5619 | 5619 | 5618 | {"type": "Polygon", "coordinates": [[[-116.95083, 32.62528], [-116.95098, 32.62537], [-116.95112, 32.62549], [-116.95124, 32.62562], [-116.95133, 32.62575], [-116.95141, 32.6259], [-116.95146, 32.62607], [-116.95149, 32.62623], [-116.95148, 32.6264], [-116.95145, 32.62659], [-116.95139, 32.62673], [-116.95131, 32.62689], [-116.9512, 32.62703], [-116.95105, 32.62717], [-116.95092, 32.62727], [-116.95054, 32.62745], [-116.95053, 32.62744], [-116.95055, 32.62738], [-116.9505, 32.62727], [-116.95048, 32.62711], [-116.95051, 32.62704], [-116.95063, 32.62686], [-116.95069, 32.62661], [-116.95065, 32.62654], [-116.95065, 32.62647], [-116.95074, 32.62641], [-116.95075, 32.62617], [-116.95072, 32.62598], [-116.95077, 32.62571], [-116.95079, 32.62547], [-116.95085, 32.62535], [-116.95082, 32.6253], [-116.95083, 32.62528]]]} | Restricted Access 2 | 45188 | HOA Park | 31749 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 3.222 | HOA Park | 0 | Private Recreation or Education 65 | 4 | ||
| 6064 | 6064 | 6063 | {"type": "Polygon", "coordinates": [[[-117.79972, 33.84507], [-117.79958, 33.84561], [-117.79822, 33.84561], [-117.7985, 33.84485], [-117.79865, 33.84464], [-117.79925, 33.84493], [-117.79948, 33.84501], [-117.79972, 33.84507]]]} | Restricted Access 2 | 47367 | HOA Community Park | 32230 | 6112 | Westridge Homeowners Association 825 | Private 7 | Home Owners Association 16 | Private 14 | 6112 | Westridge Homeowners Association 804 | Private 7 | Home Owners Association 15 | Orange 3 | 2.472 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | ||
| 7259 | 7259 | 7258 | {"type": "Polygon", "coordinates": [[[-121.33415, 38.0047], [-121.33339, 38.0049], [-121.33335, 38.0049], [-121.33331, 38.00487], [-121.33306, 38.00439], [-121.33306, 38.00436], [-121.33311, 38.00433], [-121.33386, 38.00414], [-121.33415, 38.0047]]]} | Restricted Access 2 | 48928 | Village Oaks Community Park | 33647 | 6136 | Lincoln Village Home Association 854 | Private 7 | Home Owners Association 16 | Private 14 | 6136 | Lincoln Village Home Association 832 | Private 7 | Home Owners Association 15 | https://www.villageoakscommonareasassociation.org/ | San Joaquin 39 | 1.255 | Village Oaks Community Park | 0 | Private Recreation or Education 65 | 4 | |
| 8241 | 8241 | 8240 | {"type": "Polygon", "coordinates": [[[-117.78052, 33.66198], [-117.78052, 33.66204], [-117.78004, 33.66252], [-117.77971, 33.66281], [-117.77938, 33.66301], [-117.77934, 33.66295], [-117.77937, 33.66293], [-117.77939, 33.66289], [-117.77936, 33.66283], [-117.77923, 33.66266], [-117.77886, 33.66229], [-117.7792, 33.66209], [-117.77967, 33.66174], [-117.77987, 33.66157], [-117.77992, 33.66157], [-117.78052, 33.66198]]]} | Restricted Access 2 | 12576 | Ravencreek Park | 24198 | 6014 | Oak Creek Village Maintenance Association 405 | Private 7 | Home Owners Association 16 | Private 14 | 6014 | Oak Creek Village Maintenance Association 399 | Private 7 | Home Owners Association 15 | Orange 3 | 2.918 | Ravencreek Park | 0 | Private Recreation or Education 65 | 4 | ||
| 8253 | 8253 | 8252 | {"type": "MultiPolygon", "coordinates": [[[[-117.80373, 33.69585], [-117.80368, 33.69586], [-117.80361, 33.69579], [-117.80358, 33.69562], [-117.80356, 33.69525], [-117.80357, 33.69497], [-117.80364, 33.69489], [-117.80369, 33.69489], [-117.80367, 33.69514], [-117.80367, 33.69539], [-117.80369, 33.69561], [-117.80373, 33.69585]]], [[[-117.80489, 33.69297], [-117.80459, 33.69323], [-117.8044, 33.69345], [-117.80423, 33.69367], [-117.80458, 33.69394], [-117.80481, 33.6942], [-117.80478, 33.69444], [-117.80466, 33.69494], [-117.80369, 33.69485], [-117.80369, 33.69479], [-117.80366, 33.69478], [-117.80362, 33.69469], [-117.80377, 33.69422], [-117.80389, 33.694], [-117.80415, 33.69359], [-117.80449, 33.69321], [-117.80476, 33.69296], [-117.80487, 33.69295], [-117.80489, 33.69297]]]]} | Restricted Access 2 | 12621 | Santa Cruz Park | 25083 | 6018 | Paseo Westpark Maintenance Association 653 | Private 7 | Home Owners Association 16 | Private 14 | 6018 | Paseo Westpark Maintenance Association 642 | Private 7 | Home Owners Association 15 | Orange 3 | 3.171 | Santa Cruz 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]);