units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where DES_TP = 8, MNG_AGENCY = 25 and YR_EST = 1998
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Fish and Wildlife · 7 ✖
DES_TP 1
- State Conservation Area · 7 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
213 | 213 | 212 | {"type": "Polygon", "coordinates": [[[-121.44057, 41.00434], [-121.44008, 41.00444], [-121.44004, 41.00437], [-121.43945, 41.00437], [-121.43934, 41.00404], [-121.43939, 41.00396], [-121.44023, 41.00367], [-121.44032, 41.00373], [-121.44038, 41.00381], [-121.44057, 41.00434]]]} | Open Access 1 | 663 | Fall River Mills Ecological Reserve | 32163 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fall-River-Mills-ER | Shasta 27 | 1.448 | Fall River Mills ER | 1998 | State Conservation Area 8 | 2 |
9764 | 9764 | 9763 | {"type": "MultiPolygon", "coordinates": [[[[-122.77929, 38.89026], [-122.77004, 38.89005], [-122.76995, 38.88925], [-122.76949, 38.88924], [-122.76949, 38.88295], [-122.77003, 38.88295], [-122.77003, 38.88386], [-122.77094, 38.8841], [-122.77094, 38.88206], [-122.77262, 38.88206], [-122.77318, 38.88256], [-122.7732, 38.8842], [-122.77256, 38.8848], [-122.77195, 38.8836], [-122.77156, 38.88428], [-122.7713, 38.88488], [-122.77001, 38.88564], [-122.77, 38.88636], [-122.77079, 38.88756], [-122.77094, 38.88785], [-122.77186, 38.88911], [-122.77411, 38.8901], [-122.77754, 38.88952], [-122.77825, 38.8897], [-122.77831, 38.88934], [-122.77928, 38.88935], [-122.77929, 38.89026]]], [[[-122.77318, 38.88244], [-122.77318, 38.88244], [-122.77277, 38.88206], [-122.77317, 38.88206], [-122.77318, 38.88244]]]]} | Open Access 1 | 17928 | Boggs Lake Ecological Reserve | 32060 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Boggs-Lake-ER | Lake 40 | 42.42 | Boggs Lake ER | 1998 | State Conservation Area 8 | 2 |
12264 | 12264 | 12263 | {"type": "Polygon", "coordinates": [[[-122.34065, 38.43479], [-122.33607, 38.43482], [-122.3342, 38.43477], [-122.33024, 38.43188], [-122.31255, 38.42754], [-122.31252, 38.42674], [-122.30773, 38.42655], [-122.30763, 38.4229], [-122.30341, 38.42274], [-122.30339, 38.41911], [-122.30753, 38.41926], [-122.31223, 38.4194], [-122.31238, 38.42307], [-122.31712, 38.42325], [-122.31731, 38.42695], [-122.32649, 38.42714], [-122.3313, 38.42785], [-122.3314, 38.43135], [-122.33603, 38.4315], [-122.33604, 38.43157], [-122.33849, 38.43177], [-122.34057, 38.43186], [-122.34065, 38.43479]]]} | Open Access 1 | 25818 | Rector Reservoir Wildlife Area | 30490 | 206 | California Department of Veterans Affairs 170 | State 5 | State Agency 5 | http://www.cdva.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Napa 11 | 349.564 | Rector Reservoir Wildlife Area | 1998 | State Conservation Area 8 | 2 | |
15530 | 15530 | 15529 | {"type": "MultiPolygon", "coordinates": [[[[-121.78185, 36.907], [-121.78058, 36.90929], [-121.78003, 36.90997], [-121.78001, 36.90996], [-121.77957, 36.90881], [-121.77992, 36.9084], [-121.78017, 36.90825], [-121.7805, 36.90816], [-121.78062, 36.90806], [-121.78084, 36.90757], [-121.78086, 36.90724], [-121.78104, 36.90676], [-121.78109, 36.90643], [-121.7809, 36.90633], [-121.78068, 36.90633], [-121.78084, 36.90607], [-121.78116, 36.90591], [-121.78124, 36.90598], [-121.78185, 36.907]]], [[[-121.79118, 36.91207], [-121.78804, 36.91346], [-121.78801, 36.91344], [-121.78752, 36.91366], [-121.78741, 36.91367], [-121.78732, 36.91362], [-121.78572, 36.91221], [-121.78347, 36.90873], [-121.78327, 36.90803], [-121.78299, 36.90757], [-121.78302, 36.90722], [-121.78247, 36.90717], [-121.78132, 36.90536], [-121.78121, 36.90501], [-121.78346, 36.90541], [-121.78347, 36.9054], [-121.78339, 36.90527], [-121.78353, 36.90396], [-121.78416, 36.90417], [-121.78453, 36.90434], [-121.78489, 36.90453], [-121.7852, 36.90473], [-121.78674, 36.90593], [-121.78786, 36.90689], [-121.78976, 36.90898], [-121.79013, 36.90949], [-121.7905, 36.9101], [-121.7908, 36.91073], [-121.79102, 36.91139], [-121.79118, 36.91207]]], [[[-121.81321, 36.91185], [-121.81215, 36.91259], [-121.80981, 36.90863], [-121.80903, 36.90862], [-121.8086, 36.90776], [-121.80773, 36.90721], [-121.80786, 36.90653], [-121.80678, 36.90649], [-121.80663, 36.90699], [-121.80672, 36.9076], [-121.8062, 36.90843], [-121.80617, 36.9086], [-121.80291, 36.90858], [-121.803, 36.9068], [-121.80244, 36.89698], [-121.80239, 36.89645], [-121.80563, 36.89841], [-121.80602, 36.89867], [-121.80637, 36.89896], [-121.80659, 36.8992], [-121.80678, 36.89947], [-121.80723, 36.90033], [-121.80761, 36.90121], [-121.80777, 36.90179], [-121.80784, 36.90284], [-121.80796, 36.90327], [-121.80818, 36.90368], [-121.80847, 36.90406], [-121.80877, 36.90434], [-121.80899, 36.90451], [-121.80972, 36.90495], [-121.80985, 36.90512], [-121.80991, 36.90511], [-121.81003, 36.9052], [-121.81033, 36.90553], [-121.8105, 36.90577], [-121.81064, 36.90601], [-121.81075, 36.90627], [-121.81056, 36.9063], [-121.81064, 36.90656], [-121.81082, 36.90702], [-121.81104, 36.90778], [-121.81116, 36.9081], [-121.81131, 36.90841], [-121.81158, 36.90885], [-121.81178, 36.90912], [-121.81221, 36.90964], [-121.8125, 36.9101], [-121.81273, 36.91059], [-121.81296, 36.91131], [-121.81321, 36.91185]]], [[[-121.84027, 36.93839], [-121.83995, 36.93852], [-121.83673, 36.93888], [-121.83567, 36.93828], [-121.83287, 36.93742], [-121.82875, 36.93642], [-121.82699, 36.93585], [-121.82577, 36.9355], [-121.82498, 36.93534], [-121.82463, 36.93488], [-121.82462, 36.93484], [-121.82464, 36.93457], [-121.82455, 36.93425], [-121.82397, 36.9338], [-121.82401, 36.93376], [-121.82401, 36.93375], [-121.82332, 36.9332], [-121.82299, 36.93295], [-121.82251, 36.93231], [-121.82264, 36.93183], [-121.82293, 36.93153], [-121.82296, 36.93155], [-121.82339, 36.93139], [-121.82358, 36.93069], [-121.82336, 36.92926], [-121.82346, 36.92882], [-121.82361, 36.92852], [-121.82374, 36.92842], [-121.82396, 36.92815], [-121.82915, 36.92783], [-121.82916, 36.92782], [-121.82877, 36.92714], [-121.82884, 36.92623], [-121.82942, 36.92507], [-121.83029, 36.92516], [-121.83193, 36.92747], [-121.83266, 36.92732], [-121.83667, 36.93538], [-121.83789, 36.93482], [-121.84027, 36.93839]]], [[[-121.82473, 36.9352], [-121.8247, 36.93526], [-121.82359, 36.9349], [-121.82381, 36.93391], [-121.82387, 36.93387], [-121.82444, 36.9343], [-121.82451, 36.93452], [-121.82449, 36.93488], [-121.82473, 36.9352]]]]} | Open Access 1 | 1163 | Watsonville Slough Ecological Reserve | 32347 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Watsonville-Slough-ER | Santa Cruz 5 | 568.569 | Watsonville Slough ER | 1998 | State Conservation Area 8 | 2 |
15534 | 15534 | 15533 | {"type": "Polygon", "coordinates": [[[-122.12958, 40.15278], [-122.12882, 40.15322], [-122.12754, 40.15169], [-122.1274, 40.15145], [-122.12654, 40.15098], [-122.12535, 40.1509], [-122.12415, 40.15059], [-122.12324, 40.15114], [-122.12248, 40.15109], [-122.12157, 40.15063], [-122.12095, 40.15023], [-122.12059, 40.14919], [-122.12063, 40.14923], [-122.12064, 40.14921], [-122.12017, 40.1479], [-122.11938, 40.14683], [-122.12133, 40.14572], [-122.12142, 40.14619], [-122.1217, 40.14694], [-122.1218, 40.14704], [-122.12196, 40.1471], [-122.12298, 40.14715], [-122.1234, 40.1472], [-122.12388, 40.14728], [-122.12417, 40.14734], [-122.12434, 40.14744], [-122.12451, 40.1476], [-122.12464, 40.14776], [-122.12488, 40.14831], [-122.12505, 40.14861], [-122.12526, 40.14881], [-122.12549, 40.14908], [-122.12561, 40.14917], [-122.12695, 40.14969], [-122.12664, 40.15041], [-122.12752, 40.1509], [-122.1279, 40.15016], [-122.12872, 40.15076], [-122.12883, 40.15096], [-122.12913, 40.15137], [-122.12923, 40.15229], [-122.12942, 40.15264], [-122.12958, 40.15278]]]} | Open Access 1 | 18147 | Butler Slough Ecological Reserve | 32071 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Butler-Slough-ER | Tehama 18 | 57.88 | Butler Slough ER | 1998 | State Conservation Area 8 | 2 |
15559 | 15559 | 15558 | {"type": "Polygon", "coordinates": [[[-122.89111, 38.45184], [-122.88969, 38.45207], [-122.88942, 38.45154], [-122.88873, 38.45123], [-122.88857, 38.45091], [-122.88842, 38.45081], [-122.88785, 38.45026], [-122.88738, 38.45022], [-122.88712, 38.44951], [-122.88676, 38.44908], [-122.88597, 38.44848], [-122.88479, 38.44833], [-122.88386, 38.44855], [-122.88374, 38.44861], [-122.88334, 38.44818], [-122.88169, 38.44884], [-122.88158, 38.44869], [-122.88028, 38.4488], [-122.87915, 38.44716], [-122.87778, 38.44774], [-122.8769, 38.44434], [-122.87757, 38.44425], [-122.87824, 38.44495], [-122.87907, 38.44517], [-122.87952, 38.44546], [-122.88075, 38.44702], [-122.88233, 38.44744], [-122.883, 38.44747], [-122.88311, 38.44786], [-122.88594, 38.44781], [-122.88619, 38.44799], [-122.88671, 38.44842], [-122.8869, 38.44855], [-122.88703, 38.44873], [-122.88734, 38.44894], [-122.88752, 38.44916], [-122.88813, 38.44964], [-122.8884, 38.45002], [-122.8885, 38.45011], [-122.88873, 38.45047], [-122.88915, 38.45077], [-122.88953, 38.45094], [-122.88956, 38.45097], [-122.88992, 38.45114], [-122.8905, 38.45151], [-122.89094, 38.45169], [-122.89111, 38.45184]]]} | Open Access 1 | 17413 | Atascadero Creek Marsh Ecological Reserve | 32029 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Atascadero-Creek-Marsh-ER | Sonoma 16 | 40.259 | Atascadero Creek Marsh ER | 1998 | State Conservation Area 8 | 2 |
15583 | 15583 | 15582 | {"type": "MultiPolygon", "coordinates": [[[[-122.10851, 37.57261], [-122.10771, 37.57585], [-122.10625, 37.5766], [-122.10464, 37.57543], [-122.10395, 37.5745], [-122.10196, 37.57425], [-122.09941, 37.57655], [-122.09863, 37.57851], [-122.09762, 37.57924], [-122.09462, 37.57929], [-122.09254, 37.57957], [-122.09229, 37.57988], [-122.09018, 37.57887], [-122.0876, 37.57882], [-122.08733, 37.57871], [-122.08715, 37.57861], [-122.08711, 37.57848], [-122.08659, 37.57379], [-122.08811, 37.57303], [-122.0895, 37.57225], [-122.0909, 37.57194], [-122.09475, 37.57101], [-122.10007, 37.56978], [-122.09984, 37.56954], [-122.0984, 37.5684], [-122.09829, 37.56783], [-122.09828, 37.56764], [-122.09816, 37.56745], [-122.09814, 37.56679], [-122.09837, 37.56629], [-122.10804, 37.56921], [-122.10793, 37.5703], [-122.10798, 37.5709], [-122.10851, 37.57261]], [[-122.10599, 37.57282], [-122.10652, 37.57186], [-122.1062, 37.57085], [-122.10581, 37.57036], [-122.10544, 37.57021], [-122.10489, 37.57059], [-122.10339, 37.57152], [-122.10319, 37.57172], [-122.10294, 37.57184], [-122.10231, 37.57143], [-122.10072, 37.57013], [-122.10028, 37.56971], [-122.1001, 37.56977], [-122.1021, 37.5715], [-122.10263, 37.5719], [-122.10268, 37.57208], [-122.10269, 37.57232], [-122.1029, 37.57271], [-122.10371, 37.57344], [-122.10419, 37.57427], [-122.10453, 37.57477], [-122.10491, 37.57491], [-122.1051, 37.57517], [-122.10528, 37.57566], [-122.10553, 37.57585], [-122.10581, 37.57596], [-122.10609, 37.57582], [-122.10621, 37.5754], [-122.10603, 37.57492], [-122.10595, 37.57451], [-122.1061, 37.57367], [-122.1061, 37.57308], [-122.10599, 37.57282]]], [[[-122.15148, 37.6176], [-122.14477, 37.62002], [-122.13858, 37.62004], [-122.13441, 37.62181], [-122.133, 37.6225], [-122.12668, 37.62247], [-122.1261, 37.62264], [-122.12543, 37.62272], [-122.12285, 37.62263], [-122.12301, 37.62135], [-122.123, 37.62134], [-122.12283, 37.62133], [-122.12264, 37.62254], [-122.12243, 37.62226], [-122.11291, 37.62106], [-122.10399, 37.6184], [-122.10324, 37.61614], [-122.10325, 37.61575], [-122.10327, 37.61559], [-122.10344, 37.61525], [-122.10349, 37.61494], [-122.1038, 37.61455], [-122.10431, 37.6143], [-122.10439, 37.61408], [-122.10429, 37.61387], [-122.10417, 37.61351], [-122.10244, 37.6113], [-122.102, 37.61121], [-122.10137, 37.6116], [-122.10098, 37.61195], [-122.1005, 37.61249], [-122.10035, 37.61253], [-122.09988, 37.61253], [-122.09932, 37.61257], [-122.09774, 37.61317], [-122.09764, 37.60551], [-122.09077, 37.60542], [-122.0915, 37.60423], [-122.0922, 37.60283], [-122.0926, 37.60156], [-122.09285, 37.60006], [-122.09309, 37.59836], [-122.09308, 37.59631], [-122.09297, 37.5953], [-122.09307, 37.59489], [-122.09342, 37.59457], [-122.09399, 37.59423], [-122.09518, 37.59394], [-122.09659, 37.59393], [-122.10333, 37.59408], [-122.10452, 37.59382], [-122.10518, 37.59355], [-122.10947, 37.59105], [-122.11062, 37.59089], [-122.11214, 37.59089], [-122.11347, 37.59111], [-122.11918, 37.59279], [-122.12001, 37.59294], [-122.12238, 37.59348], [-122.12353, 37.59354], [-122.13668, 37.59328], [-122.14106, 37.59435], [-122.14735, 37.59511], [-122.14674, 37.59535], [-122.14671, 37.59606], [-122.147, 37.59668], [-122.14646, 37.59709], [-122.14641, 37.59757], [-122.14682, 37.59819], [-122.14727, 37.59827], [-122.14723, 37.59863], [-122.14719, 37.59934], [-122.14721, 37.59992], [-122.14699, 37.60028], [-122.146, 37.60088], [-122.14592, 37.60172], [-122.14593, 37.60181], [-122.14546, 37.60231], [-122.14411, 37.60384], [-122.14348, 37.60427], [-122.14224, 37.60574], [-122.142, 37.60645], [-122.14178, 37.60676], [-122.1415, 37.60684], [-122.13963, 37.60665], [-122.13758, 37.60623], [-122.13563, 37.60597], [-122.1352, 37.60601], [-122.13481, 37.60621], [-122.13457, 37.60649], [-122.13412, 37.60809], [-122.13397, 37.60873], [-122.13358, 37.60949], [-122.13323, 37.61012], [-122.13306, 37.6107], [-122.13316, 37.61116], [-122.13337, 37.61158], [-122.13359, 37.61178], [-122.13462, 37.61234], [-122.13516, 37.61256], [-122.13541, 37.6128], [-122.13546, 37.61318], [-122.13523, 37.61354], [-122.13443, 37.61395], [-122.13349, 37.61422], [-122.13195, 37.61446], [-122.1306, 37.61441], [-122.12937, 37.61444], [-122.12873, 37.61474], [-122.1281, 37.61528], [-122.12816, 37.61597], [-122.12811, 37.61666], [-122.12802, 37.61723], [-122.12767, 37.61762], [-122.12656, 37.61809], [-122.12551, 37.61839], [-122.1248, 37.61843], [-122.12444, 37.6189], [-122.12555, 37.61886], [-122.12618, 37.61853], [-122.12679, 37.6183], [-122.1275, 37.61813], [-122.12852, 37.61773], [-122.129, 37.61681], [-122.12903, 37.61612], [-122.12895, 37.61593], [-122.129, 37.61554], [-122.12923, 37.61532], [-122.13013, 37.6151], [-122.1312, 37.61504], [-122.13253, 37.61498], [-122.13434, 37.61472], [-122.13489, 37.61471], [-122.13518, 37.61458], [-122.13581, 37.61417], [-122.13626, 37.61353], [-122.13629, 37.61305], [-122.13613, 37.61255], [-122.13584, 37.61223], [-122.1348, 37.61178], [-122.13415, 37.61147], [-122.13397, 37.61126], [-122.13406, 37.61052], [-122.1348, 37.60933], [-122.13492, 37.609], [-122.13498, 37.60802], [-122.1351, 37.60727], [-122.13554, 37.60707], [-122.13611, 37.60712], [-122.13655, 37.60722], [-122.13779, 37.60777], [-122.1384, 37.60796], [-122.1406, 37.60875], [-122.14128, 37.60878], [-122.1418, 37.60858], [-122.14221, 37.60838], [-122.14247, 37.60807], [-122.14264, 37.60748], [-122.14258, 37.60746], [-122.14277, 37.60705], [-122.14261, 37.60682], [-122.14284, 37.60616], [-122.14361, 37.60509], [-122.14398, 37.6047], [-122.14497, 37.60399], [-122.14548, 37.60334], [-122.14607, 37.60278], [-122.14625, 37.60345], [-122.14638, 37.60429], [-122.14707, 37.60495], [-122.14714, 37.60553], [-122.14711, 37.60619], [-122.1474, 37.6065], [-122.14663, 37.60674], [-122.14747, 37.60737], [-122.14836, 37.61021], [-122.14903, 37.61482], [-122.15005, 37.61634], [-122.15109, 37.61696], [-122.15148, 37.6176]]], [[[-122.09165, 37.59228], [-122.09115, 37.5923], [-122.09117, 37.59121], [-122.09161, 37.59183], [-122.09165, 37.59193], [-122.09167, 37.59204], [-122.09165, 37.59228]]], [[[-122.14755, 37.59403], [-122.14079, 37.59318], [-122.13633, 37.5922], [-122.12605, 37.59215], [-122.12243, 37.59219], [-122.12073, 37.59197], [-122.11607, 37.59085], [-122.11342, 37.5901], [-122.11224, 37.58978], [-122.11106, 37.5897], [-122.10978, 37.58983], [-122.10872, 37.59007], [-122.10394, 37.59271], [-122.10362, 37.59287], [-122.10318, 37.59301], [-122.10283, 37.59309], [-122.09481, 37.59278], [-122.09394, 37.59292], [-122.09237, 37.59362], [-122.09202, 37.59328], [-122.09204, 37.59255], [-122.09202, 37.59163], [-122.09154, 37.59163], [-122.09165, 37.58494], [-122.09638, 37.58317], [-122.09587, 37.58037], [-122.09789, 37.58016], [-122.09885, 37.5799], [-122.09952, 37.57936], [-122.10127, 37.57589], [-122.10184, 37.57552], [-122.10219, 37.57534], [-122.10256, 37.57533], [-122.10302, 37.57549], [-122.10322, 37.5757], [-122.10291, 37.57998], [-122.10433, 37.58178], [-122.10715, 37.58098], [-122.11424, 37.5734], [-122.11863, 37.57426], [-122.11909, 37.57431], [-122.11965, 37.57432], [-122.12546, 37.57341], [-122.12904, 37.57119], [-122.13395, 37.56663], [-122.1434, 37.58219], [-122.14539, 37.58277], [-122.14739, 37.58484], [-122.14755, 37.59403]]], [[[-122.13425, 37.62343], [-122.13425, 37.62343], [-122.13143, 37.62438], [-122.13185, 37.62338], [-122.13273, 37.62282], [-122.13425, 37.62343]]]]} | Open Access 1 | 9456 | Eden Landing Ecological Reserve | 32155 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Eden-Landing-ER | Alameda 17 | 5803.055 | Eden Landing ER | 1998 | State Conservation Area 8 | 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]);