units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
58 rows where COUNTY = 4 and DES_TP = 4 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15151 | 15151 | 15150 | {"type": "MultiPolygon", "coordinates": [[[[-116.88037, 32.99665], [-116.88033, 33.00055], [-116.87994, 33.00357], [-116.87945, 33.00359], [-116.87922, 33.00355], [-116.87884, 33.00359], [-116.87877, 33.00394], [-116.87546, 33.00405], [-116.87055, 33.0041], [-116.87056, 33.00098], [-116.87153, 33.00056], [-116.87167, 32.99946], [-116.87084, 32.99878], [-116.8659, 33.00008], [-116.86399, 33.00124], [-116.8635, 33.0014], [-116.86286, 32.99999], [-116.86269, 32.99974], [-116.86258, 32.99962], [-116.86244, 32.9995], [-116.8621, 32.99929], [-116.86006, 32.99861], [-116.85989, 32.99857], [-116.85935, 32.99846], [-116.85932, 32.99844], [-116.85743, 32.99818], [-116.85603, 32.99774], [-116.85585, 32.9977], [-116.85536, 32.99764], [-116.85323, 32.99762], [-116.85199, 32.99755], [-116.85178, 32.99756], [-116.85167, 32.99754], [-116.85119, 32.99758], [-116.85076, 32.99767], [-116.85055, 32.99772], [-116.84987, 32.99795], [-116.8499, 32.99391], [-116.85022, 32.9938], [-116.85051, 32.99367], [-116.85421, 32.99372], [-116.85422, 32.99384], [-116.85844, 32.99388], [-116.86869, 32.99391], [-116.8686, 32.98563], [-116.87533, 32.9856], [-116.87565, 32.99388], [-116.87771, 32.99389], [-116.87771, 32.99394], [-116.87778, 32.99394], [-116.87782, 32.99776], [-116.88037, 32.99665]]], [[[-116.86534, 33.00441], [-116.86282, 33.00443], [-116.86282, 33.00121], [-116.86091, 33.0005], [-116.86091, 33.0012], [-116.85836, 33.00125], [-116.85837, 32.99956], [-116.85825, 32.9995], [-116.84987, 33.00111], [-116.84989, 32.99819], [-116.85052, 32.9981], [-116.85507, 32.99781], [-116.85584, 32.99791], [-116.85649, 32.99809], [-116.85689, 32.99825], [-116.85706, 32.9983], [-116.85783, 32.99844], [-116.85827, 32.99849], [-116.85841, 32.99848], [-116.85929, 32.9986], [-116.8596, 32.99867], [-116.85999, 32.99877], [-116.86204, 32.99945], [-116.8623, 32.99961], [-116.86242, 32.99972], [-116.86256, 32.99987], [-116.86268, 33.00006], [-116.86378, 33.00245], [-116.86398, 33.00279], [-116.86425, 33.00308], [-116.86476, 33.0035], [-116.86507, 33.00383], [-116.86517, 33.00399], [-116.86525, 33.00417], [-116.86534, 33.00441]]], [[[-116.85006, 32.99368], [-116.85, 32.9937], [-116.84991, 32.99373], [-116.8499, 32.99368], [-116.85006, 32.99368]]], [[[-116.85253, 32.99779], [-116.85146, 32.99786], [-116.85061, 32.99791], [-116.85093, 32.99781], [-116.85141, 32.99774], [-116.85174, 32.99773], [-116.85253, 32.99779]]]]} | Open Access 1 | 45995 | Barnett Ranch Preserve | 29189 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/BarnettRanch.html | San Diego 4 | 717.785 | Barnett Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
15640 | 15640 | 15639 | {"type": "MultiPolygon", "coordinates": [[[[-117.31035, 33.08979], [-117.31028, 33.08985], [-117.31002, 33.08986], [-117.3097, 33.08907], [-117.30937, 33.08815], [-117.30811, 33.08419], [-117.30836, 33.08424], [-117.30846, 33.08445], [-117.30841, 33.08445], [-117.3084, 33.0845], [-117.30846, 33.08469], [-117.30861, 33.0851], [-117.30879, 33.0855], [-117.30911, 33.08636], [-117.30926, 33.08685], [-117.30936, 33.08707], [-117.30944, 33.08752], [-117.30948, 33.08757], [-117.30958, 33.0876], [-117.3098, 33.08825], [-117.3098, 33.08832], [-117.30977, 33.0884], [-117.30987, 33.08879], [-117.31004, 33.08917], [-117.31007, 33.08927], [-117.31015, 33.08935], [-117.31023, 33.08954], [-117.31034, 33.0897], [-117.31035, 33.08979]]], [[[-117.31092, 33.09038], [-117.31087, 33.09039], [-117.31078, 33.09031], [-117.31073, 33.09017], [-117.31058, 33.08993], [-117.31056, 33.0898], [-117.31043, 33.08945], [-117.31048, 33.08939], [-117.31045, 33.08926], [-117.31027, 33.08887], [-117.31021, 33.08862], [-117.31001, 33.08829], [-117.30994, 33.08824], [-117.30987, 33.08814], [-117.30966, 33.08762], [-117.30966, 33.08759], [-117.30968, 33.08746], [-117.30965, 33.0873], [-117.30953, 33.08701], [-117.30946, 33.08676], [-117.30932, 33.08638], [-117.30928, 33.0862], [-117.30915, 33.08591], [-117.30901, 33.08547], [-117.30893, 33.08529], [-117.30884, 33.08484], [-117.30877, 33.08464], [-117.30875, 33.08445], [-117.30868, 33.08417], [-117.30878, 33.08405], [-117.30986, 33.08748], [-117.31068, 33.08968], [-117.31077, 33.08988], [-117.31076, 33.08997], [-117.31079, 33.09011], [-117.3109, 33.09029], [-117.31092, 33.09038]]]]} | Unknown Access 4 | 45153 | Batiquitos Lagoon Ecological Reserve | 15865 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Batiquitos-Lagoon-ER | San Diego 4 | 7.116 | Batiquitos Lagoon ER | 1983 | Local Conservation Area 4 | 2 |
6086 | 6086 | 6085 | {"type": "MultiPolygon", "coordinates": [[[[-117.00116, 33.01884], [-116.99647, 33.01886], [-116.99635, 33.01507], [-117.00112, 33.01494], [-117.00116, 33.01884]]], [[[-117.01695, 33.01451], [-117.01452, 33.01459], [-117.00983, 33.01471], [-117.00983, 33.01458], [-117.01035, 33.01452], [-117.01054, 33.01217], [-117.01092, 33.01197], [-117.01481, 33.01197], [-117.01603, 33.01335], [-117.01695, 33.01451]]]]} | Restricted Access 2 | 891 | Blue Sky Ecological Reserve | 29220 | 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 | 83.938 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
15638 | 15638 | 15637 | {"type": "Polygon", "coordinates": [[[-117.02536, 33.01762], [-117.0241, 33.01851], [-117.02409, 33.01859], [-117.02226, 33.01869], [-117.02223, 33.01607], [-117.02353, 33.01605], [-117.02405, 33.01608], [-117.02415, 33.01631], [-117.02426, 33.01652], [-117.02438, 33.01672], [-117.02457, 33.01696], [-117.0249, 33.01729], [-117.02514, 33.01748], [-117.02536, 33.01762]]]} | Restricted Access 2 | 45140 | Blue Sky Ecological Reserve | 29221 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 15.494 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
15152 | 15152 | 15151 | {"type": "Polygon", "coordinates": [[[-117.02397, 33.1489], [-117.0239, 33.14891], [-117.0239, 33.1525], [-117.02365, 33.15577], [-117.02352, 33.15771], [-117.02307, 33.16317], [-117.01963, 33.16302], [-117.01956, 33.16279], [-117.01479, 33.16263], [-117.01268, 33.16299], [-117.00684, 33.16413], [-117.00685, 33.16376], [-117.00731, 33.16309], [-117.00787, 33.16232], [-117.00813, 33.16193], [-117.00823, 33.1618], [-117.00842, 33.16163], [-117.00899, 33.16133], [-117.0092, 33.16115], [-117.00963, 33.16057], [-117.01, 33.16016], [-117.0109, 33.15901], [-117.011, 33.15891], [-117.01118, 33.15879], [-117.01141, 33.15874], [-117.01164, 33.15874], [-117.01189, 33.15882], [-117.01208, 33.15849], [-117.01212, 33.15834], [-117.01213, 33.1582], [-117.01201, 33.15618], [-117.01198, 33.15605], [-117.01192, 33.15593], [-117.01179, 33.15576], [-117.01168, 33.15567], [-117.01173, 33.15501], [-117.01431, 33.15464], [-117.01429, 33.15444], [-117.01429, 33.15428], [-117.0145, 33.15332], [-117.01455, 33.15225], [-117.01465, 33.15223], [-117.01927, 33.15236], [-117.01936, 33.14882], [-117.02397, 33.1489]]]} | Open Access 1 | 45997 | Bottle Peak Preserve | 29192 | 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 | 373.609 | Bottle Peak Preserve | 0 | Local Conservation Area 4 | 2 | |
4919 | 4919 | 4918 | {"type": "Polygon", "coordinates": [[[-116.95348, 32.97049], [-116.94486, 32.97075], [-116.94038, 32.97069], [-116.94043, 32.98879], [-116.93164, 32.98892], [-116.93165, 32.99244], [-116.92769, 32.9925], [-116.92746, 32.99195], [-116.92717, 32.99145], [-116.92712, 32.99134], [-116.9271, 32.99123], [-116.92703, 32.98965], [-116.92701, 32.98949], [-116.92694, 32.98925], [-116.92663, 32.98861], [-116.9274, 32.98859], [-116.92743, 32.98054], [-116.92835, 32.98052], [-116.9317, 32.98057], [-116.93267, 32.9801], [-116.93358, 32.97947], [-116.9336, 32.97826], [-116.93376, 32.97758], [-116.93361, 32.97697], [-116.93362, 32.97623], [-116.93287, 32.97482], [-116.93164, 32.9748], [-116.93162, 32.97644], [-116.93154, 32.97731], [-116.93048, 32.9773], [-116.93047, 32.97779], [-116.92975, 32.97775], [-116.92906, 32.9778], [-116.92869, 32.9778], [-116.92802, 32.97777], [-116.92744, 32.97782], [-116.9275, 32.97291], [-116.92755, 32.96326], [-116.92218, 32.96267], [-116.92286, 32.95497], [-116.91692, 32.95427], [-116.91686, 32.95103], [-116.91843, 32.95115], [-116.91844, 32.95114], [-116.91845, 32.9482], [-116.9174, 32.93946], [-116.92765, 32.94122], [-116.93182, 32.94121], [-116.93186, 32.95198], [-116.92763, 32.95203], [-116.92761, 32.95595], [-116.93185, 32.95601], [-116.93186, 32.95964], [-116.94042, 32.95977], [-116.94045, 32.9561], [-116.94879, 32.95602], [-116.94888, 32.95974], [-116.95342, 32.95961], [-116.95348, 32.97049]]]} | No Public Access 3 | 47591 | Boulder Oaks Open Space Preserve | 31318 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/BoulderOaks.html | San Diego 4 | 2020.361 | Boulder Oaks OSP | 0 | Local Conservation Area 4 | 2 |
13166 | 13166 | 13165 | {"type": "Polygon", "coordinates": [[[-117.35743, 33.16745], [-117.35654, 33.16659], [-117.35654, 33.16659], [-117.35663, 33.16654], [-117.35665, 33.16649], [-117.35674, 33.16649], [-117.35696, 33.16668], [-117.35696, 33.1667], [-117.35728, 33.16704], [-117.35724, 33.16707], [-117.35727, 33.1671], [-117.35726, 33.16716], [-117.35728, 33.16723], [-117.3574, 33.16736], [-117.35743, 33.16745]]]} | Unknown Access 4 | 45147 | Buena Vista Lagoon Ecological Reserve | 16489 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | San Diego 4 | 0.497 | Buena Vista Lagoon ER | 1968 | Local Conservation Area 4 | 2 | |
7648 | 7648 | 7647 | {"type": "Polygon", "coordinates": [[[-117.11377, 32.61359], [-117.11375, 32.61403], [-117.11361, 32.61439], [-117.11328, 32.61458], [-117.11248, 32.61658], [-117.11221, 32.61694], [-117.11171, 32.61699], [-117.10505, 32.61491], [-117.10484, 32.61492], [-117.10439, 32.61365], [-117.10416, 32.61334], [-117.10343, 32.61347], [-117.10329, 32.61356], [-117.10315, 32.61354], [-117.10185, 32.61386], [-117.10134, 32.61391], [-117.09805, 32.61389], [-117.0981, 32.61364], [-117.10049, 32.61375], [-117.10148, 32.61376], [-117.10163, 32.61366], [-117.10181, 32.61369], [-117.10189, 32.61371], [-117.10254, 32.61349], [-117.10447, 32.61307], [-117.10485, 32.61297], [-117.10499, 32.61283], [-117.10524, 32.61279], [-117.106, 32.61235], [-117.10611, 32.61219], [-117.10625, 32.61219], [-117.10671, 32.61241], [-117.11126, 32.61384], [-117.1118, 32.61389], [-117.11182, 32.61398], [-117.11303, 32.61434], [-117.11347, 32.61429], [-117.1137, 32.61374], [-117.11377, 32.61359]]]} | Open Access 1 | 7392 | Chula Vista Wildlife Reserve | 17243 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | San Diego 4 | 64.761 | Chula Vista Wildlife Reserve | 0 | Local Conservation Area 4 | 2 | |
7603 | 7603 | 7602 | {"type": "MultiPolygon", "coordinates": [[[[-117.14805, 33.08584], [-117.14789, 33.0859], [-117.14775, 33.08597], [-117.14704, 33.08645], [-117.14671, 33.08662], [-117.14508, 33.08435], [-117.13959, 33.08443], [-117.13958, 33.08442], [-117.13958, 33.08754], [-117.13651, 33.08756], [-117.12968, 33.08756], [-117.12962, 33.09117], [-117.12315, 33.09115], [-117.12313, 33.08756], [-117.11888, 33.08755], [-117.11889, 33.08746], [-117.11885, 33.08602], [-117.1189, 33.08492], [-117.11888, 33.08399], [-117.11911, 33.08376], [-117.11915, 33.08376], [-117.11941, 33.08344], [-117.11939, 33.08342], [-117.1194, 33.08339], [-117.11947, 33.0833], [-117.11965, 33.083], [-117.11982, 33.08265], [-117.11992, 33.08237], [-117.12041, 33.08055], [-117.12047, 33.08025], [-117.12056, 33.07972], [-117.12075, 33.07971], [-117.12076, 33.07899], [-117.12108, 33.07898], [-117.12106, 33.07836], [-117.12084, 33.07835], [-117.1211, 33.07661], [-117.12112, 33.07652], [-117.12116, 33.07652], [-117.1212, 33.07624], [-117.12126, 33.07623], [-117.12136, 33.07562], [-117.12131, 33.0756], [-117.12133, 33.07547], [-117.1213, 33.07546], [-117.12141, 33.07449], [-117.12151, 33.07448], [-117.12178, 33.07265], [-117.1219, 33.07198], [-117.12179, 33.07194], [-117.12245, 33.06783], [-117.12255, 33.06782], [-117.12257, 33.06767], [-117.12265, 33.06739], [-117.12276, 33.06717], [-117.1229, 33.06695], [-117.12283, 33.06691], [-117.1229, 33.06681], [-117.12305, 33.06665], [-117.12318, 33.06653], [-117.12349, 33.06632], [-117.12368, 33.06617], [-117.12387, 33.06596], [-117.12401, 33.06571], [-117.12412, 33.0657], [-117.12411, 33.06544], [-117.12415, 33.06519], [-117.12415, 33.06479], [-117.12423, 33.06438], [-117.12603, 33.06455], [-117.12788, 33.06455], [-117.12814, 33.0646], [-117.12826, 33.0646], [-117.12862, 33.06454], [-117.12897, 33.06451], [-117.12907, 33.06454], [-117.12925, 33.06468], [-117.12939, 33.06474], [-117.12952, 33.06476], [-117.1298, 33.06475], [-117.13004, 33.06483], [-117.13017, 33.06485], [-117.1304, 33.06485], [-117.13053, 33.06486], [-117.13064, 33.0649], [-117.13091, 33.06506], [-117.12933, 33.06755], [-117.1271, 33.06756], [-117.12711, 33.07295], [-117.12718, 33.0802], [-117.13631, 33.08017], [-117.13631, 33.08116], [-117.13629, 33.08152], [-117.13633, 33.08392], [-117.13957, 33.08391], [-117.13955, 33.08019], [-117.14401, 33.08032], [-117.14803, 33.08027], [-117.14803, 33.08388], [-117.14805, 33.08584]]], [[[-117.13193, 33.06024], [-117.1319, 33.06349], [-117.13096, 33.06498], [-117.13069, 33.06483], [-117.13055, 33.06478], [-117.13042, 33.06477], [-117.1302, 33.06477], [-117.13006, 33.06475], [-117.1298, 33.06467], [-117.12954, 33.06467], [-117.12941, 33.06466], [-117.12927, 33.06459], [-117.12914, 33.06448], [-117.129, 33.06443], [-117.12886, 33.06443], [-117.12866, 33.06445], [-117.12833, 33.06451], [-117.12823, 33.06452], [-117.12769, 33.06443], [-117.12734, 33.0643], [-117.12689, 33.06409], [-117.12647, 33.06398], [-117.12639, 33.06391], [-117.12638, 33.06383], [-117.12642, 33.06376], [-117.12671, 33.06361], [-117.12679, 33.06353], [-117.12685, 33.06345], [-117.12688, 33.06336], [-117.12692, 33.0627], [-117.1271, 33.06259], [-117.12723, 33.06248], [-117.12759, 33.06209], [-117.12771, 33.06199], [-117.12786, 33.06191], [-117.12802, 33.06185], [-117.12849, 33.06178], [-117.12867, 33.06172], [-117.12883, 33.06164], [-117.12904, 33.06148], [-117.12933, 33.06112], [-117.12945, 33.06102], [-117.12965, 33.06092], [-117.13193, 33.06024]]]]} | Open Access 1 | 7314 | Del Dios Highlands Preserve | 10675 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/DelDiosHighlands.html | San Diego 4 | 781.705 | Del Dios Highlands Preserve | 0 | Local Conservation Area 4 | 2 |
10477 | 10477 | 10476 | {"type": "Polygon", "coordinates": [[[-117.00881, 32.57966], [-117.00877, 32.57945], [-117.00873, 32.5794], [-117.00866, 32.57937], [-117.00856, 32.57938], [-117.00848, 32.57945], [-117.00848, 32.57952], [-117.0085, 32.57956], [-117.00862, 32.57962], [-117.00863, 32.57965], [-117.00559, 32.57952], [-117.00558, 32.57773], [-117.0088, 32.57781], [-117.00881, 32.57966]]]} | Open Access 1 | 18561 | Dennery Canyon Vernal Pool Reserve | 18086 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 14.897 | Dennery Canyon Vernal Pool Reserve | 0 | Local Conservation Area 4 | 2 | |
1429 | 1429 | 1428 | {"type": "Polygon", "coordinates": [[[-117.00998, 32.57781], [-117.00559, 32.57765], [-117.00559, 32.57912], [-117.00537, 32.57895], [-117.00513, 32.57883], [-117.00486, 32.57878], [-117.0046, 32.57878], [-117.00434, 32.57884], [-117.00415, 32.57892], [-117.00402, 32.579], [-117.00369, 32.57861], [-117.00357, 32.57838], [-117.00352, 32.5782], [-117.0035, 32.57805], [-117.0035, 32.57572], [-117.00456, 32.57575], [-117.00457, 32.57563], [-117.00487, 32.57547], [-117.00504, 32.57543], [-117.00514, 32.57544], [-117.00571, 32.5757], [-117.00584, 32.5757], [-117.00599, 32.57551], [-117.00621, 32.57533], [-117.00643, 32.57533], [-117.00656, 32.57537], [-117.0068, 32.57512], [-117.00705, 32.57482], [-117.00727, 32.57423], [-117.00733, 32.57399], [-117.00696, 32.57363], [-117.00645, 32.57334], [-117.00621, 32.57316], [-117.00602, 32.57284], [-117.00594, 32.57263], [-117.00594, 32.57243], [-117.00626, 32.57237], [-117.00647, 32.57236], [-117.00649, 32.57158], [-117.00647, 32.57157], [-117.00652, 32.57069], [-117.0065, 32.57067], [-117.00652, 32.57059], [-117.00652, 32.57031], [-117.00654, 32.5703], [-117.00654, 32.56915], [-117.00618, 32.56914], [-117.00587, 32.56895], [-117.00586, 32.56882], [-117.00553, 32.56882], [-117.00553, 32.56854], [-117.00572, 32.56854], [-117.00575, 32.56846], [-117.00583, 32.56841], [-117.00749, 32.56842], [-117.00798, 32.56847], [-117.00925, 32.56848], [-117.00925, 32.56886], [-117.00841, 32.56886], [-117.0084, 32.56946], [-117.00888, 32.5703], [-117.00988, 32.5703], [-117.00998, 32.57781]]]} | Restricted Access 2 | 47693 | Dennery Preserve | 31429 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 98.129 | Dennery Preserve | 0 | Local Conservation Area 4 | 2 | |
4083 | 4083 | 4082 | {"type": "MultiPolygon", "coordinates": [[[[-117.03637, 32.85313], [-117.0344, 32.85405], [-117.03519, 32.85544], [-117.03489, 32.85561], [-117.0346, 32.85581], [-117.03416, 32.85622], [-117.03398, 32.85645], [-117.03193, 32.85573], [-117.03233, 32.8512], [-117.03319, 32.85205], [-117.03336, 32.85201], [-117.03364, 32.85193], [-117.03452, 32.85157], [-117.03607, 32.85164], [-117.03637, 32.85313]]], [[[-117.05222, 32.85447], [-117.05067, 32.85518], [-117.04735, 32.85631], [-117.04684, 32.85796], [-117.04954, 32.85847], [-117.05024, 32.86129], [-117.05034, 32.86134], [-117.04923, 32.86297], [-117.0489, 32.86331], [-117.04865, 32.86351], [-117.04863, 32.86351], [-117.04846, 32.86364], [-117.0482, 32.86378], [-117.04777, 32.86396], [-117.04735, 32.86408], [-117.04646, 32.86425], [-117.04627, 32.86349], [-117.04614, 32.86318], [-117.04596, 32.86285], [-117.0458, 32.86263], [-117.04552, 32.86232], [-117.04524, 32.86208], [-117.04492, 32.86185], [-117.04463, 32.86157], [-117.04447, 32.86137], [-117.04437, 32.86119], [-117.0442, 32.86082], [-117.0441, 32.8604], [-117.0441, 32.85768], [-117.04224, 32.85775], [-117.04229, 32.85475], [-117.04051, 32.85484], [-117.0427, 32.85265], [-117.04343, 32.85287], [-117.0452, 32.85314], [-117.04758, 32.85335], [-117.04886, 32.85358], [-117.05119, 32.85418], [-117.05167, 32.85398], [-117.05194, 32.85403], [-117.05222, 32.85447]]]]} | Open Access 1 | 1687 | East Elliott Preserve | 18366 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 196.534 | East Elliott Preserve | 0 | Local Conservation Area 4 | 2 | |
6865 | 6865 | 6864 | {"type": "Polygon", "coordinates": [[[-116.88206, 32.9016], [-116.87735, 32.90152], [-116.87743, 32.90675], [-116.87754, 32.91269], [-116.87364, 32.91266], [-116.87363, 32.91259], [-116.86927, 32.9126], [-116.86073, 32.91264], [-116.86073, 32.91536], [-116.85906, 32.91535], [-116.85857, 32.91537], [-116.84119, 32.9155], [-116.84121, 32.91914], [-116.84126, 32.92277], [-116.83271, 32.92285], [-116.83293, 32.93288], [-116.83278, 32.93287], [-116.83277, 32.93288], [-116.83424, 32.93483], [-116.82384, 32.93501], [-116.8236, 32.92202], [-116.82359, 32.91926], [-116.8236, 32.91642], [-116.83981, 32.91648], [-116.83994, 32.90146], [-116.83993, 32.90145], [-116.82362, 32.90223], [-116.82372, 32.8874], [-116.828, 32.8874], [-116.82799, 32.89121], [-116.83615, 32.89146], [-116.84492, 32.89538], [-116.84472, 32.89861], [-116.84891, 32.89856], [-116.84889, 32.90108], [-116.8525, 32.90092], [-116.85243, 32.90479], [-116.84825, 32.9049], [-116.84828, 32.9088], [-116.85647, 32.90867], [-116.85649, 32.90782], [-116.8565, 32.90482], [-116.86949, 32.9051], [-116.86958, 32.90132], [-116.86968, 32.8984], [-116.86146, 32.89843], [-116.86208, 32.89371], [-116.87781, 32.88967], [-116.87782, 32.89258], [-116.88195, 32.89201], [-116.88202, 32.89926], [-116.88206, 32.9016]]]} | Open Access 1 | 5516 | El Capitan Preserve | 30283 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/ElCapitan.html | San Diego 4 | 2603.63 | El Capitan Preserve | 0 | Local Conservation Area 4 | 2 |
14610 | 14610 | 14609 | {"type": "MultiPolygon", "coordinates": [[[[-117.18723, 33.06546], [-117.18548, 33.06687], [-117.18548, 33.06687], [-117.1855, 33.06545], [-117.18723, 33.06546]]], [[[-117.19071, 33.0655], [-117.18965, 33.06846], [-117.18937, 33.06842], [-117.18924, 33.06843], [-117.18905, 33.06849], [-117.18895, 33.06856], [-117.18842, 33.06661], [-117.18836, 33.06649], [-117.18808, 33.06547], [-117.19071, 33.0655]]], [[[-117.18728, 33.0727], [-117.1848, 33.07266], [-117.18489, 33.07234], [-117.18501, 33.07155], [-117.18506, 33.0713], [-117.18494, 33.07096], [-117.18482, 33.07042], [-117.18453, 33.06973], [-117.18441, 33.06953], [-117.18417, 33.06924], [-117.18403, 33.06917], [-117.18387, 33.06916], [-117.18385, 33.0691], [-117.18541, 33.06911], [-117.18638, 33.06908], [-117.18726, 33.06908], [-117.18728, 33.0727]]], [[[-117.17423, 33.07671], [-117.17417, 33.0784], [-117.17415, 33.07845], [-117.17348, 33.07833], [-117.17312, 33.0783], [-117.17248, 33.07829], [-117.17227, 33.07826], [-117.17207, 33.0782], [-117.17154, 33.07797], [-117.17111, 33.07773], [-117.17073, 33.07743], [-117.16999, 33.07663], [-117.17001, 33.07636], [-117.17294, 33.07642], [-117.17294, 33.0767], [-117.17423, 33.07671]]], [[[-117.19572, 33.07672], [-117.1957, 33.0794], [-117.19324, 33.07923], [-117.19334, 33.07904], [-117.19314, 33.07854], [-117.19205, 33.07829], [-117.19191, 33.07822], [-117.19179, 33.07814], [-117.19161, 33.07794], [-117.19153, 33.07779], [-117.19149, 33.07761], [-117.19143, 33.0776], [-117.19146, 33.07717], [-117.19145, 33.07663], [-117.18855, 33.07658], [-117.18857, 33.07545], [-117.19146, 33.07551], [-117.19146, 33.07663], [-117.19572, 33.07672]]], [[[-117.17416, 33.07869], [-117.17408, 33.08036], [-117.16976, 33.08034], [-117.16984, 33.07885], [-117.16998, 33.07701], [-117.17052, 33.07759], [-117.17088, 33.07786], [-117.17113, 33.07803], [-117.1714, 33.07817], [-117.17195, 33.07841], [-117.17216, 33.07848], [-117.17237, 33.07851], [-117.17326, 33.07855], [-117.1736, 33.07859], [-117.17416, 33.07869]]], [[[-117.15319, 33.08571], [-117.15294, 33.08582], [-117.15251, 33.08596], [-117.15219, 33.08602], [-117.15183, 33.08606], [-117.15133, 33.08605], [-117.14956, 33.08587], [-117.14844, 33.0858], [-117.14823, 33.0858], [-117.14805, 33.08584], [-117.14803, 33.08027], [-117.15231, 33.08034], [-117.15223, 33.08571], [-117.15319, 33.08571]]], [[[-117.14475, 33.08745], [-117.1439, 33.08753], [-117.1439, 33.08753], [-117.1439, 33.08751], [-117.14394, 33.08751], [-117.14414, 33.08745], [-117.14475, 33.08745]]], [[[-117.15649, 33.08564], [-117.15649, 33.08741], [-117.15009, 33.08746], [-117.15012, 33.08937], [-117.14806, 33.0894], [-117.14808, 33.09109], [-117.1522, 33.09107], [-117.15221, 33.09471], [-117.1507, 33.09472], [-117.15069, 33.09473], [-117.1529, 33.09685], [-117.1533, 33.09789], [-117.15372, 33.09849], [-117.15353, 33.09873], [-117.15287, 33.09997], [-117.15245, 33.10051], [-117.15247, 33.10086], [-117.15329, 33.10166], [-117.15378, 33.10215], [-117.15386, 33.10237], [-117.15388, 33.10252], [-117.15386, 33.10266], [-117.15379, 33.10284], [-117.15365, 33.10304], [-117.15361, 33.10318], [-117.15363, 33.10332], [-117.15381, 33.10356], [-117.15382, 33.10365], [-117.15376, 33.10382], [-117.15357, 33.10398], [-117.15352, 33.10411], [-117.15351, 33.10421], [-117.15356, 33.10433], [-117.1537, 33.10449], [-117.15383, 33.10459], [-117.15398, 33.10468], [-117.15435, 33.10482], [-117.15455, 33.10504], [-117.15475, 33.10519], [-117.15482, 33.1053], [-117.15484, 33.10539], [-117.15488, 33.10548], [-117.15495, 33.10555], [-117.15522, 33.10568], [-117.15528, 33.10574], [-117.15536, 33.10597], [-117.15542, 33.10607], [-117.15567, 33.10631], [-117.15573, 33.10641], [-117.1558, 33.10661], [-117.15591, 33.10672], [-117.156, 33.10677], [-117.15617, 33.10681], [-117.15621, 33.10686], [-117.15622, 33.10691], [-117.1562, 33.10696], [-117.15615, 33.10699], [-117.15615, 33.10711], [-117.15609, 33.10712], [-117.15602, 33.10951], [-117.15534, 33.10922], [-117.15424, 33.10859], [-117.15415, 33.1086], [-117.15418, 33.10894], [-117.15418, 33.11015], [-117.15412, 33.11003], [-117.15402, 33.10997], [-117.15375, 33.1091], [-117.15355, 33.10862], [-117.1534, 33.10836], [-117.15337, 33.10821], [-117.1534, 33.10809], [-117.15344, 33.10805], [-117.15356, 33.10797], [-117.15383, 33.10784], [-117.15404, 33.10777], [-117.15451, 33.10766], [-117.15487, 33.10749], [-117.15514, 33.10743], [-117.15544, 33.10728], [-117.15566, 33.10722], [-117.15596, 33.10708], [-117.15596, 33.10706], [-117.15425, 33.10641], [-117.15282, 33.10651], [-117.15056, 33.10608], [-117.14915, 33.10526], [-117.14816, 33.10531], [-117.14802, 33.09843], [-117.13961, 33.09842], [-117.13962, 33.09474], [-117.14391, 33.09473], [-117.14393, 33.09378], [-117.1439, 33.09109], [-117.1396, 33.09109], [-117.13961, 33.09282], [-117.13652, 33.09281], [-117.13649, 33.0927], [-117.13649, 33.09251], [-117.13651, 33.0923], [-117.13645, 33.09202], [-117.13643, 33.09161], [-117.13651, 33.09136], [-117.13665, 33.0911], [-117.13685, 33.09077], [-117.13738, 33.09003], [-117.13755, 33.08972], [-117.13766, 33.08945], [-117.13778, 33.08925], [-117.13793, 33.08906], [-117.13802, 33.08897], [-117.13817, 33.08887], [-117.13835, 33.08879], [-117.13851, 33.08877], [-117.1387, 33.08878], [-117.13924, 33.08898], [-117.13943, 33.08902], [-117.13959, 33.08903], [-117.1396, 33.08909], [-117.14002, 33.08903], [-117.1404, 33.08901], [-117.14066, 33.08897], [-117.14123, 33.08882], [-117.14372, 33.08787], [-117.14407, 33.08772], [-117.14433, 33.08764], [-117.14518, 33.08757], [-117.14537, 33.08753], [-117.14561, 33.08744], [-117.148, 33.08744], [-117.14801, 33.08748], [-117.14803, 33.08747], [-117.14806, 33.08608], [-117.14818, 33.08605], [-117.1483, 33.08603], [-117.14876, 33.08605], [-117.14953, 33.08611], [-117.1514, 33.0863], [-117.15187, 33.08631], [-117.15239, 33.08624], [-117.15292, 33.0861], [-117.15339, 33.08588], [-117.15366, 33.0857], [-117.15649, 33.08564]]]]} | No Public Access 3 | 44822 | Escondido Creek Preserve | 29232 | 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 | 625.018 | Escondido Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
7319 | 7319 | 7318 | {"type": "MultiPolygon", "coordinates": [[[[-117.22972, 32.75044], [-117.22933, 32.75092], [-117.22933, 32.75147], [-117.22929, 32.75241], [-117.22709, 32.75259], [-117.22689, 32.7514], [-117.2268, 32.75068], [-117.22908, 32.74803], [-117.2293, 32.74816], [-117.22931, 32.7482], [-117.22952, 32.74831], [-117.22953, 32.74875], [-117.22969, 32.74886], [-117.22965, 32.74889], [-117.22954, 32.74882], [-117.22953, 32.74883], [-117.22955, 32.74986], [-117.22966, 32.74994], [-117.22963, 32.74997], [-117.22955, 32.74993], [-117.22954, 32.74994], [-117.22955, 32.75033], [-117.22972, 32.75044]]], [[[-117.22998, 32.75264], [-117.22997, 32.75307], [-117.22992, 32.75379], [-117.22997, 32.75424], [-117.22993, 32.75452], [-117.2298, 32.75482], [-117.22947, 32.75521], [-117.22925, 32.75543], [-117.22921, 32.75552], [-117.22922, 32.75562], [-117.22935, 32.75583], [-117.22945, 32.75616], [-117.227, 32.7566], [-117.2278, 32.75561], [-117.22787, 32.75564], [-117.22917, 32.7541], [-117.22904, 32.75271], [-117.22998, 32.75264]]]]} | Open Access 1 | 47586 | Famosa Slough Wildlife Reserve | 31313 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/park-and-recreation/parks/regional/missionbay/mbtour1#Famosa | San Diego 4 | 33.351 | Famosa Slough Wildlife Reserve | 0 | Local Conservation Area 4 | 2 |
6269 | 6269 | 6268 | {"type": "MultiPolygon", "coordinates": [[[[-116.98966, 32.91956], [-116.98937, 32.91956], [-116.9895, 32.9339], [-116.98364, 32.93398], [-116.98356, 32.9343], [-116.98403, 32.93561], [-116.98442, 32.93603], [-116.98441, 32.93658], [-116.98424, 32.93807], [-116.98354, 32.93871], [-116.98159, 32.94012], [-116.98109, 32.94034], [-116.98048, 32.93979], [-116.98033, 32.93986], [-116.98058, 32.9412], [-116.97817, 32.94117], [-116.97813, 32.943], [-116.97815, 32.94301], [-116.97847, 32.94277], [-116.97891, 32.9428], [-116.97894, 32.94363], [-116.97912, 32.94418], [-116.97809, 32.9459], [-116.97938, 32.9459], [-116.98105, 32.94585], [-116.98105, 32.94859], [-116.97935, 32.94853], [-116.97058, 32.94833], [-116.97082, 32.94447], [-116.97099, 32.94104], [-116.96183, 32.94088], [-116.96174, 32.93343], [-116.95747, 32.93346], [-116.95777, 32.92622], [-116.96202, 32.92624], [-116.96229, 32.91927], [-116.96218, 32.91552], [-116.95771, 32.9155], [-116.95773, 32.9085], [-116.96197, 32.90851], [-116.96182, 32.9035], [-116.97162, 32.90168], [-116.97155, 32.91577], [-116.9809, 32.91574], [-116.98072, 32.90852], [-116.98503, 32.90855], [-116.98502, 32.90763], [-116.98936, 32.90765], [-116.98938, 32.90859], [-116.98504, 32.90855], [-116.98507, 32.91031], [-116.98943, 32.91034], [-116.98966, 32.91956]]], [[[-116.96655, 32.94369], [-116.9663, 32.94401], [-116.96603, 32.94429], [-116.96578, 32.9445], [-116.96516, 32.94497], [-116.96477, 32.94521], [-116.96302, 32.94614], [-116.96296, 32.94615], [-116.96292, 32.94612], [-116.96269, 32.94584], [-116.96241, 32.94553], [-116.96213, 32.94526], [-116.96188, 32.94506], [-116.96187, 32.94452], [-116.96109, 32.94453], [-116.96052, 32.94424], [-116.959, 32.94362], [-116.95841, 32.94333], [-116.95808, 32.94313], [-116.95775, 32.94291], [-116.95774, 32.94223], [-116.961, 32.94226], [-116.96099, 32.94127], [-116.96649, 32.9413], [-116.96655, 32.94369]]], [[[-116.9654, 32.94517], [-116.96539, 32.94575], [-116.96341, 32.94681], [-116.96315, 32.94645], [-116.96315, 32.94639], [-116.96318, 32.94636], [-116.965, 32.94542], [-116.9654, 32.94517]]], [[[-116.98432, 32.90496], [-116.98062, 32.90494], [-116.98042, 32.90307], [-116.9843, 32.90304], [-116.98432, 32.90496]]], [[[-116.98934, 32.90675], [-116.98501, 32.90674], [-116.98498, 32.90496], [-116.98929, 32.90498], [-116.98934, 32.90675]]]]} | Open Access 1 | 1358 | Goodan Ranch Sycamore Canyon Preserve | 29238 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/GoodanSycamore.html | San Diego 4 | 2571.686 | Goodan Ranch Sycamore Canyon Preserve | 0 | Local Conservation Area 4 | 2 |
6830 | 6830 | 6829 | {"type": "Polygon", "coordinates": [[[-117.18338, 33.25274], [-117.18272, 33.25297], [-117.18189, 33.25323], [-117.18125, 33.25339], [-117.18097, 33.25343], [-117.18104, 33.24925], [-117.18302, 33.24925], [-117.18305, 33.2493], [-117.18316, 33.24949], [-117.18322, 33.24967], [-117.1836, 33.25208], [-117.18366, 33.2523], [-117.18378, 33.25255], [-117.18377, 33.25259], [-117.18374, 33.25261], [-117.18338, 33.25274]]]} | Open Access 1 | 5437 | Gopher Canyon Reserve | 19407 | 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 | 23.859 | Gopher Canyon Reserve | 0 | Local Conservation Area 4 | 2 | |
4184 | 4184 | 4183 | {"type": "Polygon", "coordinates": [[[-117.13525, 33.02933], [-117.1352, 33.03273], [-117.1346, 33.03273], [-117.13459, 33.03241], [-117.13336, 33.03194], [-117.13294, 33.0302], [-117.13281, 33.0301], [-117.13258, 33.03004], [-117.1325, 33.02998], [-117.13233, 33.02954], [-117.1323, 33.02934], [-117.13525, 33.02933]]]} | Open Access 1 | 44865 | Greenfield Preserve | 19479 | 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 | 17.374 | Greenfield Preserve | 0 | Local Conservation Area 4 | 2 | |
6802 | 6802 | 6801 | {"type": "MultiPolygon", "coordinates": [[[[-116.91462, 33.22682], [-116.91453, 33.23359], [-116.91037, 33.23358], [-116.91038, 33.23708], [-116.90136, 33.23707], [-116.90139, 33.227], [-116.90169, 33.22659], [-116.91067, 33.22678], [-116.91462, 33.22682]]], [[[-116.92783, 33.19759], [-116.92778, 33.20078], [-116.92782, 33.2009], [-116.92779, 33.20311], [-116.9278, 33.20838], [-116.91504, 33.20852], [-116.91746, 33.20521], [-116.92314, 33.19761], [-116.92783, 33.19759]]], [[[-116.96695, 33.2241], [-116.96284, 33.22408], [-116.96285, 33.22763], [-116.96266, 33.23129], [-116.95379, 33.23114], [-116.95353, 33.23836], [-116.95793, 33.23848], [-116.95778, 33.2421], [-116.94485, 33.24154], [-116.92792, 33.2417], [-116.91891, 33.24172], [-116.91909, 33.2343], [-116.91916, 33.23058], [-116.92233, 33.23056], [-116.92215, 33.23127], [-116.92182, 33.2315], [-116.92221, 33.23241], [-116.92339, 33.23242], [-116.92344, 33.23055], [-116.92777, 33.23051], [-116.92787, 33.22694], [-116.93242, 33.22711], [-116.93206, 33.22005], [-116.93192, 33.2162], [-116.93202, 33.2162], [-116.93202, 33.21615], [-116.93604, 33.21632], [-116.93838, 33.21647], [-116.94032, 33.21654], [-116.94079, 33.22037], [-116.94526, 33.22053], [-116.9496, 33.22055], [-116.94957, 33.22402], [-116.95836, 33.22405], [-116.95837, 33.22057], [-116.96282, 33.22058], [-116.96695, 33.22052], [-116.96695, 33.2241]], [[-116.9453, 33.22652], [-116.94303, 33.22648], [-116.943, 33.22742], [-116.9453, 33.22745], [-116.9453, 33.22652]]]]} | Open Access 1 | 5317 | Hellhole Canyon Preserve | 29239 | 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 | http://www.sdparks.org/content/sdparks/en/park-pages/HellholeCanyon.html | San Diego 4 | 2451.423 | Hellhole Canyon Preserve | 0 | Local Conservation Area 4 | 2 |
10691 | 10691 | 10690 | {"type": "Polygon", "coordinates": [[[-117.27216, 32.97823], [-117.27163, 32.97837], [-117.27094, 32.97727], [-117.27056, 32.97727], [-117.27028, 32.97763], [-117.27008, 32.97763], [-117.27008, 32.97727], [-117.26992, 32.97726], [-117.27001, 32.9771], [-117.2701, 32.97681], [-117.27025, 32.97658], [-117.27069, 32.97614], [-117.2714, 32.97626], [-117.27163, 32.97667], [-117.27181, 32.97708], [-117.27206, 32.97782], [-117.27216, 32.97823]]]} | Open Access 1 | 19844 | James Scripps Bluff Preserve | 20352 | 1082 | Del Mar, City of 93 | City 2 | City Agency 2 | http://www.delmar.ca.us/203/Beaches-Parks | City 2 | 1082 | Del Mar, City of 91 | City 2 | City Agency 2 | San Diego 4 | 6.327 | James Scripps Bluff Preserve | 0 | Local Conservation Area 4 | 2 |
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]);