units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,219 rows where MNG_AG_TYP = 3 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 172
- San Diego, County of 122
- Santa Barbara, County of 116
- Orange, County of 94
- Lake, County of 56
- Butte, County of 53
- Santa Cruz, County of 50
- Sacramento, County of 49
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 44
- Riverside, County of 38
- San Luis Obispo, County of 30
- Placer, County of 27
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- San Bernardino, County of 20
- Yolo, County of 18
- Fresno, County of 17
- Tulare, County of 15
- Merced, County of 15
- Humboldt, County of 12
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- Napa, County of 5
- …
DES_TP >30
- Local Park 651
- Local Other or Unknown 214
- Local Recreation Area 117
- Local Conservation Area 103
- Local Historic or Cultural Area 21
- National Recreation Area 3
- National Forest 2
- National Monument or Landmark 2
- 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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 1,082
- Restricted Access 58
- Unknown Access 33
- No Public Access 26
MNG_AG_TYP 1
- County Agency · 1,199 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3118 | 3118 | 3117 | {"type": "Polygon", "coordinates": [[[-121.45011, 38.40646], [-121.45004, 38.40688], [-121.4499, 38.40688], [-121.44976, 38.40685], [-121.44963, 38.40679], [-121.44953, 38.40671], [-121.44945, 38.40661], [-121.44942, 38.40654], [-121.44941, 38.40643], [-121.44944, 38.40612], [-121.44612, 38.40611], [-121.44612, 38.40534], [-121.44083, 38.40532], [-121.44083, 38.405], [-121.44983, 38.40499], [-121.44995, 38.40507], [-121.45002, 38.40514], [-121.4501, 38.40525], [-121.45014, 38.40538], [-121.45014, 38.40551], [-121.45, 38.40639], [-121.45004, 38.40645], [-121.45011, 38.40646]]]} | Restricted Access 2 | 21488 | Laguna Lake Drainage | 20858 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 15.913 | Laguna Lake Drainage | None 255 | |||
3224 | 3224 | 3223 | {"type": "Polygon", "coordinates": [[[-121.45044, 38.37471], [-121.44978, 38.3747], [-121.44966, 38.37342], [-121.45028, 38.37338], [-121.45044, 38.37471]]]} | Restricted Access 2 | 22246 | Hood-Franklin Drainage | 20071 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.025 | Hood-Franklin Drainage | None 266 | |||
3367 | 3367 | 3366 | {"type": "Polygon", "coordinates": [[[-120.03019, 41.82727], [-120.03008, 41.83089], [-120.02524, 41.8308], [-120.02535, 41.82718], [-120.03019, 41.82727]]]} | Open Access 1 | 24348 | County Government Land | 17712 | 341 | Modoc, County of 629 | County 3 | County Agency 3 | http://www.co.modoc.ca.us/departments/parks-recreation | County 3 | 341 | Modoc, County of 618 | County 3 | County Agency 3 | Modoc 56 | 39.993 | County Government Land | None 276 | |||
3493 | 3493 | 3492 | {"type": "Polygon", "coordinates": [[[-119.84774, 36.85682], [-119.84773, 36.85954], [-119.84741, 36.8595], [-119.84434, 36.86227], [-119.84328, 36.8623], [-119.84113, 36.86119], [-119.8391, 36.85984], [-119.83905, 36.85717], [-119.84175, 36.85772], [-119.84229, 36.85626], [-119.8449, 36.85685], [-119.84774, 36.85682]]]} | Open Access 1 | 25924 | Scout Island | 25217 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 88.577 | Scout Island | None 291 | |||
3753 | 3753 | 3752 | {"type": "Polygon", "coordinates": [[[-119.69543, 34.43397], [-119.69509, 34.43541], [-119.69424, 34.43536], [-119.69419, 34.43629], [-119.69257, 34.4363], [-119.69256, 34.43377], [-119.69278, 34.4335], [-119.6928, 34.43343], [-119.69302, 34.43324], [-119.69368, 34.43246], [-119.69391, 34.43263], [-119.69364, 34.43294], [-119.69351, 34.43319], [-119.69331, 34.43328], [-119.69335, 34.43335], [-119.69344, 34.43332], [-119.69346, 34.43333], [-119.69364, 34.43368], [-119.69373, 34.43372], [-119.69382, 34.43371], [-119.69382, 34.43374], [-119.69527, 34.43376], [-119.69515, 34.43396], [-119.69543, 34.43397]]]} | Unknown Access 4 | 467 | Santa Barbara Bowl | 25038 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 16.55 | Santa Barbara Bowl | None 315 | |||
3863 | 3863 | 3862 | {"type": "Polygon", "coordinates": [[[-121.02867, 38.67828], [-121.02866, 38.67981], [-121.02866, 38.68191], [-121.0275, 38.68192], [-121.02633, 38.68375], [-121.02633, 38.6846], [-121.02169, 38.68456], [-121.01836, 38.67788], [-121.01832, 38.67709], [-121.01842, 38.67699], [-121.01883, 38.67516], [-121.0189, 38.67498], [-121.01899, 38.67485], [-121.01914, 38.67478], [-121.0193, 38.67476], [-121.0195, 38.67479], [-121.01975, 38.67492], [-121.02138, 38.67628], [-121.02188, 38.67638], [-121.02234, 38.67651], [-121.02373, 38.67707], [-121.02408, 38.67719], [-121.02444, 38.67728], [-121.02488, 38.67735], [-121.02524, 38.67738], [-121.02568, 38.67737], [-121.02617, 38.67701], [-121.02624, 38.67689], [-121.02625, 38.67681], [-121.02636, 38.67682], [-121.02635, 38.67829], [-121.02867, 38.67828]]]} | Open Access 1 | 35604 | Bass Lake | 15855 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 152.098 | Bass Lake | None 330 | |||
3874 | 3874 | 3873 | {"type": "Polygon", "coordinates": [[[-121.01029, 38.67025], [-121.00859, 38.67106], [-121.00596, 38.67107], [-121.00591, 38.67096], [-121.00832, 38.67042], [-121.0086, 38.67009], [-121.00799, 38.66978], [-121.00808, 38.66966], [-121.00871, 38.66997], [-121.00918, 38.6694], [-121.01029, 38.67025]]]} | Open Access 1 | 35657 | Cameron Park-Shingle Springs 1 | 16762 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 6.395 | Cameron Park-Shingle Springs 1 | None 331 | |||
3899 | 3899 | 3898 | {"type": "Polygon", "coordinates": [[[-117.8205, 34.09105], [-117.82051, 34.09113], [-117.82049, 34.09123], [-117.82036, 34.09135], [-117.82033, 34.09142], [-117.82026, 34.09145], [-117.82024, 34.09087], [-117.82037, 34.09095], [-117.8205, 34.09105]]]} | Open Access 1 | 45847 | San Dimas Staging Area | 28895 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/San_Dimas_Staging_Area | Los Angeles 6 | 0.247 | San Dimas Staging Area | None 334 | ||
4205 | 4205 | 4204 | {"type": "Polygon", "coordinates": [[[-120.91483, 39.93803], [-120.91232, 39.93808], [-120.91216, 39.93828], [-120.91089, 39.93831], [-120.91086, 39.93744], [-120.91281, 39.93744], [-120.91293, 39.93722], [-120.91326, 39.93721], [-120.91325, 39.93651], [-120.91482, 39.93651], [-120.91483, 39.93803]]]} | Open Access 1 | 48871 | Quincy Skatepark | 33592 | 362 | Plumas, County of 664 | County 3 | County Agency 3 | http://www.countyofplumas.com/ | County 3 | 362 | Plumas, County of 652 | County 3 | County Agency 3 | Plumas 57 | 10.115 | Quincy Skatepark | None 367 | |||
4291 | 4291 | 4290 | {"type": "Polygon", "coordinates": [[[-117.96399, 33.63508], [-117.96237, 33.63687], [-117.96074, 33.63584], [-117.95743, 33.63372], [-117.958, 33.63182], [-117.96399, 33.63508]]]} | Unknown Access 4 | 14646 | Talbert Marsh | 26170 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 34.691 | Talbert Marsh | None 375 | |||
4371 | 4371 | 4370 | {"type": "MultiPolygon", "coordinates": [[[[-118.24124, 33.92765], [-118.24116, 33.9276], [-118.24085, 33.92733], [-118.24124, 33.92733], [-118.24124, 33.92765]]], [[[-118.24433, 33.92779], [-118.24433, 33.92814], [-118.24389, 33.92811], [-118.2427, 33.92796], [-118.24172, 33.92781], [-118.24433, 33.92779]]], [[[-118.24465, 33.92779], [-118.24465, 33.92817], [-118.24449, 33.92815], [-118.24449, 33.92779], [-118.24465, 33.92779]]], [[[-118.24611, 33.9282], [-118.24572, 33.9282], [-118.24571, 33.92817], [-118.24482, 33.92817], [-118.24482, 33.92779], [-118.24607, 33.92779], [-118.24611, 33.92784], [-118.24611, 33.9282]]]]} | Unknown Access 4 | 45850 | 117th and Compton | 28898 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 2.884 | 117th and Compton | None 387 | |||
4391 | 4391 | 4390 | {"type": "Polygon", "coordinates": [[[-116.36536, 33.23412], [-116.36466, 33.23413], [-116.3643, 33.23433], [-116.36296, 33.23237], [-116.3634, 33.23211], [-116.36371, 33.23196], [-116.36404, 33.23184], [-116.36438, 33.23175], [-116.36473, 33.23167], [-116.36508, 33.23163], [-116.36526, 33.23161], [-116.3653, 33.23163], [-116.36533, 33.23167], [-116.36536, 33.23412]]]} | Open Access 1 | 45996 | Borrego Springs Park Site Dedication | 29191 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 11.154 | Borrego Springs Park Site Dedication | None 392 | |||
4845 | 4845 | 4844 | {"type": "Polygon", "coordinates": [[[-119.84133, 34.45093], [-119.84062, 34.45098], [-119.84059, 34.45044], [-119.84067, 34.45043], [-119.84073, 34.45041], [-119.84077, 34.45036], [-119.84079, 34.4503], [-119.84075, 34.4497], [-119.84072, 34.44964], [-119.84067, 34.4496], [-119.84055, 34.44958], [-119.84054, 34.44941], [-119.84028, 34.44897], [-119.84057, 34.44897], [-119.84115, 34.44969], [-119.84132, 34.44997], [-119.84133, 34.45093]]]} | Open Access 1 | 1110 | Stonebridge | 25878 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.613 | Stonebridge | None 406 | |||
5030 | 5030 | 5029 | {"type": "Polygon", "coordinates": [[[-120.4125, 41.2052], [-120.40765, 41.20523], [-120.40742, 41.19433], [-120.41231, 41.19432], [-120.41247, 41.20322], [-120.41243, 41.20313], [-120.4122, 41.20285], [-120.41184, 41.20254], [-120.41143, 41.2023], [-120.41105, 41.20211], [-120.40983, 41.20157], [-120.40956, 41.20148], [-120.40941, 41.20141], [-120.40907, 41.20115], [-120.40882, 41.20084], [-120.40849, 41.20038], [-120.40818, 41.2], [-120.40796, 41.19977], [-120.40792, 41.19975], [-120.40785, 41.19975], [-120.40781, 41.19977], [-120.4078, 41.19982], [-120.40833, 41.20045], [-120.40849, 41.20065], [-120.40866, 41.20091], [-120.40893, 41.20123], [-120.40929, 41.20152], [-120.40948, 41.20161], [-120.40974, 41.20169], [-120.41095, 41.20222], [-120.41132, 41.20241], [-120.41171, 41.20264], [-120.41206, 41.20294], [-120.41227, 41.20319], [-120.41248, 41.20372], [-120.4125, 41.2052]]]} | Open Access 1 | 24347 | West Valley Reservation Area | 27378 | 341 | Modoc, County of 629 | County 3 | County Agency 3 | http://www.co.modoc.ca.us/departments/parks-recreation | County 3 | 341 | Modoc, County of 618 | County 3 | County Agency 3 | Modoc 56 | 119.952 | West Valley Reservation Area | None 415 | |||
5212 | 5212 | 5211 | {"type": "Polygon", "coordinates": [[[-123.7721, 39.56968], [-123.77167, 39.5697], [-123.77145, 39.56927], [-123.771, 39.56816], [-123.77128, 39.56814], [-123.77136, 39.56839], [-123.77169, 39.56866], [-123.77174, 39.56906], [-123.77185, 39.56918], [-123.7721, 39.56968]]]} | Open Access 1 | 46783 | Coastal View Point | 30237 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | Mendocino 24 | 1.451 | Coastal View Point | None 422 | |||
5339 | 5339 | 5338 | {"type": "Polygon", "coordinates": [[[-121.76487, 36.22671], [-121.76455, 36.22693], [-121.76407, 36.227], [-121.76385, 36.22719], [-121.76369, 36.22707], [-121.76348, 36.22697], [-121.76368, 36.22607], [-121.76441, 36.22592], [-121.76478, 36.22637], [-121.76487, 36.22671]]]} | Unknown Access 4 | 15853 | First Growth | 18915 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 2.843 | First Growth | None 434 | |||
5597 | 5597 | 5596 | {"type": "Polygon", "coordinates": [[[-120.49458, 34.67098], [-120.49431, 34.67124], [-120.49306, 34.67174], [-120.493, 34.6711], [-120.49457, 34.67081], [-120.49458, 34.67098]]]} | Unknown Access 4 | 631 | Santa Ynez River | 25145 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.884 | Santa Ynez River | None 451 | |||
5638 | 5638 | 5637 | {"type": "Polygon", "coordinates": [[[-122.06767, 37.07161], [-122.06612, 37.07145], [-122.06525, 37.07244], [-122.06498, 37.0733], [-122.06239, 37.07328], [-122.06241, 37.06957], [-122.06378, 37.06958], [-122.06746, 37.07014], [-122.06767, 37.07161]]]} | Open Access 1 | 29800 | Quail Hollow Quarry Conservation Areas | 24044 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 34.79 | Quail Hollow Quarry Conservation Areas | None 456 | |||
5981 | 5981 | 5980 | {"type": "MultiPolygon", "coordinates": [[[[-120.57149, 34.97539], [-120.57144, 34.97556], [-120.57136, 34.97569], [-120.57125, 34.97578], [-120.57111, 34.97585], [-120.57117, 34.97538], [-120.57149, 34.97539]]], [[[-120.57027, 34.97531], [-120.57026, 34.97583], [-120.56846, 34.97601], [-120.56811, 34.97606], [-120.56776, 34.97608], [-120.56742, 34.97607], [-120.56707, 34.97602], [-120.56673, 34.97595], [-120.56573, 34.97567], [-120.5635, 34.97513], [-120.56095, 34.97464], [-120.55788, 34.97431], [-120.55621, 34.97422], [-120.55444, 34.97367], [-120.55789, 34.97375], [-120.5579, 34.97386], [-120.56036, 34.9741], [-120.56361, 34.97468], [-120.56368, 34.97454], [-120.56401, 34.97461], [-120.56396, 34.97476], [-120.56397, 34.97477], [-120.56707, 34.97552], [-120.56736, 34.97556], [-120.56766, 34.97558], [-120.56797, 34.97557], [-120.57027, 34.97531]]], [[[-120.55274, 34.97282], [-120.55227, 34.97363], [-120.54431, 34.97442], [-120.54358, 34.97544], [-120.54006, 34.97599], [-120.51284, 34.98081], [-120.51265, 34.97972], [-120.51277, 34.97971], [-120.51284, 34.98009], [-120.513, 34.98022], [-120.53916, 34.97546], [-120.53998, 34.97431], [-120.54702, 34.97309], [-120.55274, 34.97282]]], [[[-120.53866, 34.98161], [-120.53788, 34.98229], [-120.51433, 34.98672], [-120.51413, 34.98716], [-120.51421, 34.98764], [-120.51408, 34.98765], [-120.51384, 34.9863], [-120.53866, 34.98161]]], [[[-120.47587, 34.98734], [-120.47586, 34.98785], [-120.4659, 34.98969], [-120.46394, 34.98997], [-120.46217, 34.99011], [-120.45826, 34.98975], [-120.45272, 34.98952], [-120.45272, 34.98923], [-120.453, 34.98925], [-120.45301, 34.98943], [-120.45678, 34.98961], [-120.45761, 34.98969], [-120.45762, 34.98963], [-120.45999, 34.98971], [-120.46285, 34.98957], [-120.46286, 34.98949], [-120.46302, 34.98948], [-120.46302, 34.98954], [-120.46364, 34.98949], [-120.46588, 34.98917], [-120.47587, 34.98734]]], [[[-120.47967, 34.98664], [-120.47965, 34.99181], [-120.47784, 34.99165], [-120.47789, 34.98694], [-120.47967, 34.98664]]], [[[-120.51386, 34.98767], [-120.51376, 34.98768], [-120.51368, 34.98716], [-120.51331, 34.98688], [-120.51188, 34.98728], [-120.50779, 34.9882], [-120.50391, 34.98892], [-120.4877, 34.99201], [-120.48536, 34.99237], [-120.48337, 34.99218], [-120.48345, 34.98595], [-120.4854, 34.98558], [-120.48776, 34.98517], [-120.48777, 34.98558], [-120.4877, 34.99145], [-120.48771, 34.99146], [-120.51138, 34.98689], [-120.51362, 34.98635], [-120.51386, 34.98767]]]]} | Open Access 1 | 574 | Santa Maria River | 11840 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 285.306 | Santa Maria River | 0 | None 480 | ||
5986 | 5986 | 5985 | {"type": "Polygon", "coordinates": [[[-120.1236, 34.60253], [-120.12359, 34.60288], [-120.12353, 34.60288], [-120.12353, 34.60258], [-120.12298, 34.60278], [-120.12308, 34.60299], [-120.12289, 34.60309], [-120.12231, 34.60349], [-120.12213, 34.60366], [-120.12199, 34.60387], [-120.12138, 34.60522], [-120.12135, 34.60537], [-120.12135, 34.60551], [-120.12041, 34.60677], [-120.12006, 34.60677], [-120.1204, 34.60648], [-120.12062, 34.60616], [-120.12062, 34.60585], [-120.12072, 34.60567], [-120.12064, 34.60526], [-120.12075, 34.60503], [-120.12119, 34.60489], [-120.12117, 34.60452], [-120.12148, 34.60432], [-120.12159, 34.60385], [-120.1212, 34.60323], [-120.12158, 34.60313], [-120.12283, 34.60232], [-120.12284, 34.60236], [-120.12279, 34.60252], [-120.1228, 34.60253], [-120.1236, 34.60253]]]} | Open Access 1 | 587 | Alamo Pintado Creek (Solvang area) | 15320 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 6.784 | Alamo Pintado Creek (Solvang area) | None 481 |
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]);