units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
126 rows where AGNCY_TYP = 3 and DES_TP = 3 sorted by AGNCY_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, COUNTY, YR_EST
MNG_AGENCY 28
- Los Angeles, County of 25
- Santa Barbara, County of 18
- Los Angeles - Department of Parks and Recreation, County of 13
- Sacramento, County of 9
- San Diego, County of 7
- Santa Cruz, County of 5
- San Luis Obispo, County of 5
- Monterey, County of 5
- Orange, County of 5
- Riverside, County of 5
- Ventura, County of 4
- Fresno, County of 3
- Kern, County of 3
- Placer, County of 2
- San Joaquin, County of 2
- Stanislaus, County of 2
- Yolo, County of 2
- Valley-Wide Recreation and Park District 1
- Cerritos, City of 1
- Lake, County of 1
- Desert Recreation District 1
- Torrance, City of 1
- Long Beach, City of 1
- San Bernardino, County of 1
- Humboldt, County of 1
- Siskiyou, County of 1
- Amador, County of 1
- Sutter, County of 1
MNG_AG_TYP 4
ACCESS_TYP 4
DES_TP 1
- Local Recreation Area · 126 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
414 | 414 | 413 | {"type": "Polygon", "coordinates": [[[-121.99027, 36.96704], [-121.98919, 36.96912], [-121.98905, 36.9695], [-121.98804, 36.9695], [-121.98722, 36.96943], [-121.98774, 36.96794], [-121.98768, 36.96792], [-121.98777, 36.96788], [-121.98814, 36.96779], [-121.98895, 36.96735], [-121.98913, 36.96739], [-121.99027, 36.96704]]]} | Open Access 1 | 830 | Simpkins Swim Center | 25513 | 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 | 9.9 | Simpkins Swim Ctr. | 0 | Local Recreation Area 3 | 4 | |
6125 | 6125 | 6124 | {"type": "MultiPolygon", "coordinates": [[[[-121.9654, 36.95968], [-121.96527, 36.95978], [-121.96488, 36.96008], [-121.96489, 36.9599], [-121.96496, 36.95985], [-121.96516, 36.95981], [-121.96528, 36.95971], [-121.96532, 36.95963], [-121.96534, 36.95945], [-121.9654, 36.95935], [-121.9654, 36.95968]]], [[[-121.96554, 36.96051], [-121.96499, 36.96051], [-121.96499, 36.96023], [-121.96554, 36.9598], [-121.96554, 36.96051]]]]} | Open Access 1 | 1336 | The Hook Beach Access | 26285 | 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 | 0.827 | The Hook Beach Access | 0 | Local Recreation Area 3 | 4 | |
10113 | 10113 | 10112 | {"type": "Polygon", "coordinates": [[[-121.85358, 36.92094], [-121.85322, 36.92159], [-121.85317, 36.92157], [-121.85338, 36.92118], [-121.85334, 36.92115], [-121.85347, 36.92092], [-121.85358, 36.92094]]]} | Open Access 1 | 17544 | Manresa State Beach Access | 21760 | 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 | http://www.parks.ca.gov/?page_id=545 | Santa Cruz 5 | 0.136 | Manresa SB Access | 0 | Local Recreation Area 3 | 4 |
10179 | 10179 | 10178 | {"type": "Polygon", "coordinates": [[[-122.0518, 37.04316], [-122.05171, 37.04325], [-122.05136, 37.04307], [-122.05098, 37.04293], [-122.04999, 37.04275], [-122.05026, 37.04347], [-122.04925, 37.04495], [-122.0486, 37.04622], [-122.04469, 37.04114], [-122.04518, 37.04088], [-122.04547, 37.04119], [-122.04567, 37.04136], [-122.04589, 37.04151], [-122.04612, 37.04165], [-122.04637, 37.04178], [-122.04664, 37.04188], [-122.04719, 37.04204], [-122.05101, 37.04281], [-122.05123, 37.04287], [-122.05152, 37.04299], [-122.0518, 37.04316]]]} | Open Access 1 | 17811 | Michael Gray Field Park | 22195 | 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 | 27.906 | Michael Gray Field Park | 0 | Local Recreation Area 3 | 4 | |
17031 | 17031 | 17030 | {"type": "Polygon", "coordinates": [[[-121.94388, 36.98798], [-121.94332, 36.99061], [-121.94267, 36.99058], [-121.94267, 36.99056], [-121.94276, 36.99045], [-121.94269, 36.99022], [-121.94259, 36.99013], [-121.94264, 36.98993], [-121.94279, 36.98973], [-121.9428, 36.98959], [-121.94286, 36.98949], [-121.94287, 36.98945], [-121.94242, 36.98943], [-121.94249, 36.98922], [-121.94269, 36.98889], [-121.94279, 36.98867], [-121.94289, 36.98833], [-121.94293, 36.98807], [-121.94297, 36.98802], [-121.94302, 36.98799], [-121.9433, 36.98804], [-121.94345, 36.98801], [-121.94346, 36.98799], [-121.94388, 36.98798]]]} | Open Access 1 | 48177 | The Farm Park & Community Center | 32712 | 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 | http://www.scparks.com/Home/Parks/TheFarmPark-CommunityMeetings.aspx | Santa Cruz 5 | 5.534 | The Farm Park & Community Ctr. | 0 | Local Recreation Area 3 | 4 |
2429 | 2429 | 2428 | {"type": "Polygon", "coordinates": [[[-119.73275, 34.45416], [-119.73256, 34.45495], [-119.73033, 34.45569], [-119.73131, 34.45385], [-119.73248, 34.45385], [-119.73275, 34.45416]]]} | Open Access 1 | 17293 | Lauro Canyon Reservoir | 33319 | 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.232 | Lauro Canyon Reservoir | 0 | Local Recreation Area 3 | 4 | |
2615 | 2615 | 2614 | {"type": "Polygon", "coordinates": [[[-119.80483, 34.42522], [-119.80482, 34.42554], [-119.80247, 34.42582], [-119.8009, 34.42611], [-119.80039, 34.42613], [-119.79935, 34.42613], [-119.79881, 34.42614], [-119.79835, 34.42616], [-119.7981, 34.4262], [-119.79785, 34.42626], [-119.79761, 34.42634], [-119.79738, 34.42644], [-119.79607, 34.42714], [-119.7965, 34.42603], [-119.7965, 34.42592], [-119.79466, 34.42424], [-119.801, 34.42408], [-119.80117, 34.42409], [-119.80132, 34.42412], [-119.80156, 34.4242], [-119.80248, 34.42446], [-119.80249, 34.4255], [-119.80483, 34.42522]]]} | Open Access 1 | 17990 | More Mesa Open Space | 22473 | 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 | 36.882 | More Mesa OS | 0 | Local Recreation Area 3 | 4 | |
2864 | 2864 | 2863 | {"type": "Polygon", "coordinates": [[[-119.8955, 34.43359], [-119.89489, 34.4336], [-119.89507, 34.4334], [-119.89518, 34.43315], [-119.89502, 34.43276], [-119.89396, 34.43277], [-119.89349, 34.43308], [-119.89327, 34.43291], [-119.89312, 34.43283], [-119.89296, 34.43279], [-119.89279, 34.43277], [-119.89158, 34.43278], [-119.89147, 34.43278], [-119.89124, 34.43274], [-119.89246, 34.43273], [-119.89311, 34.43267], [-119.89548, 34.43263], [-119.8955, 34.43359]]]} | Open Access 1 | 1923 | Winchester I Open Space | 27618 | 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.191 | Winchester I OS | 0 | Local Recreation Area 3 | 4 | |
3823 | 3823 | 3822 | {"type": "Polygon", "coordinates": [[[-119.79655, 34.42798], [-119.79651, 34.42886], [-119.79611, 34.42884], [-119.79604, 34.4287], [-119.7958, 34.4284], [-119.79655, 34.42798]]]} | Open Access 1 | 35233 | Rhoads Open Space | 28548 | 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.01 | Rhoads OS | 0 | Local Recreation Area 3 | 4 | |
5504 | 5504 | 5503 | {"type": "Polygon", "coordinates": [[[-120.44562, 34.87516], [-120.4456, 34.87591], [-120.44401, 34.87591], [-120.44401, 34.87511], [-120.44418, 34.87512], [-120.44458, 34.87515], [-120.44562, 34.87516]]]} | Open Access 1 | 1135 | Stonebrook Open Space | 25882 | 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 | 3.08 | Stonebrook OS | 0 | Local Recreation Area 3 | 4 | |
6333 | 6333 | 6332 | {"type": "MultiPolygon", "coordinates": [[[[-119.81783, 34.44343], [-119.81777, 34.44362], [-119.81759, 34.44372], [-119.81675, 34.44373], [-119.81574, 34.44462], [-119.81576, 34.44491], [-119.81593, 34.4456], [-119.81594, 34.44587], [-119.81525, 34.44586], [-119.81511, 34.44584], [-119.81508, 34.44583], [-119.81506, 34.44578], [-119.81514, 34.44535], [-119.81518, 34.44473], [-119.8152, 34.44462], [-119.81527, 34.44446], [-119.81546, 34.44422], [-119.81556, 34.44403], [-119.81563, 34.4438], [-119.81568, 34.44357], [-119.81735, 34.44366], [-119.81742, 34.44341], [-119.81783, 34.44343]]], [[[-119.81606, 34.4464], [-119.81623, 34.44693], [-119.81622, 34.44703], [-119.81614, 34.44723], [-119.81604, 34.44766], [-119.81591, 34.4481], [-119.8159, 34.44838], [-119.816, 34.44868], [-119.81541, 34.44868], [-119.81543, 34.44863], [-119.81542, 34.44862], [-119.81444, 34.44862], [-119.81443, 34.44848], [-119.81445, 34.44835], [-119.81449, 34.44821], [-119.81456, 34.44809], [-119.81464, 34.44798], [-119.81475, 34.44789], [-119.815, 34.44774], [-119.8151, 34.44766], [-119.81521, 34.44752], [-119.81527, 34.44736], [-119.81529, 34.44719], [-119.81525, 34.44681], [-119.81518, 34.44658], [-119.81504, 34.44629], [-119.81501, 34.44616], [-119.81502, 34.44603], [-119.81506, 34.44601], [-119.81526, 34.44603], [-119.81573, 34.44602], [-119.81573, 34.4463], [-119.816, 34.44635], [-119.81606, 34.4464]]]]} | Open Access 1 | 1578 | University Circle Open Space | 26673 | 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 | 11.722 | University Circle OS | 0 | Local Recreation Area 3 | 4 | |
6729 | 6729 | 6728 | {"type": "MultiPolygon", "coordinates": [[[[-119.77531, 34.45209], [-119.77531, 34.45312], [-119.7686, 34.454], [-119.76861, 34.45071], [-119.76859, 34.44934], [-119.77006, 34.44971], [-119.77438, 34.45153], [-119.77495, 34.45195], [-119.77531, 34.45209]], [[-119.76965, 34.45139], [-119.76974, 34.4514], [-119.76981, 34.45116], [-119.76932, 34.4508], [-119.76873, 34.45061], [-119.76873, 34.45135], [-119.76877, 34.45142], [-119.7692, 34.45152], [-119.76925, 34.45137], [-119.76929, 34.45138], [-119.7693, 34.45136], [-119.76933, 34.45136], [-119.76934, 34.45134], [-119.76959, 34.45138], [-119.76963, 34.4514], [-119.76965, 34.45139]]], [[[-119.77683, 34.45222], [-119.77667, 34.45302], [-119.77675, 34.45338], [-119.77595, 34.45341], [-119.7759, 34.45326], [-119.77589, 34.45311], [-119.77602, 34.45211], [-119.77683, 34.45222]]]]} | Unknown Access 4 | 5091 | Cathedral Oaks Fire Center | 16974 | 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 | 51.634 | Cathedral Oaks Fire Ctr. | 0 | Local Recreation Area 3 | 4 | |
9316 | 9316 | 9315 | {"type": "Polygon", "coordinates": [[[-119.82494, 34.44682], [-119.82494, 34.44687], [-119.82461, 34.44687], [-119.82461, 34.4471], [-119.82386, 34.4471], [-119.82385, 34.44677], [-119.82334, 34.44673], [-119.82347, 34.44642], [-119.82408, 34.44613], [-119.82404, 34.44586], [-119.82411, 34.44586], [-119.82415, 34.44614], [-119.82474, 34.44618], [-119.82457, 34.4468], [-119.82494, 34.44682]]]} | Open Access 1 | 15524 | Emerald Terrace Open Space | 18619 | 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.426 | Emerald Terrace OS | 0 | Local Recreation Area 3 | 4 | |
9939 | 9939 | 9938 | {"type": "Polygon", "coordinates": [[[-119.81698, 34.44965], [-119.81663, 34.44988], [-119.81647, 34.45003], [-119.8159, 34.45065], [-119.81571, 34.45089], [-119.81557, 34.45112], [-119.81532, 34.45163], [-119.81511, 34.45195], [-119.81492, 34.45216], [-119.81442, 34.45265], [-119.81427, 34.45284], [-119.81423, 34.45285], [-119.81387, 34.45282], [-119.81409, 34.45242], [-119.81395, 34.45236], [-119.81373, 34.45275], [-119.81353, 34.45275], [-119.81478, 34.4516], [-119.81478, 34.45139], [-119.81522, 34.45138], [-119.81533, 34.45127], [-119.81473, 34.45053], [-119.81488, 34.44981], [-119.81506, 34.44943], [-119.81678, 34.44942], [-119.81698, 34.44965]]]} | Open Access 1 | 17098 | Kellogg Open Space | 20580 | 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 | 8.384 | Kellogg OS | 0 | Local Recreation Area 3 | 4 | |
10201 | 10201 | 10200 | {"type": "Polygon", "coordinates": [[[-119.80649, 34.43933], [-119.80639, 34.43966], [-119.80611, 34.44014], [-119.80558, 34.44021], [-119.80538, 34.44045], [-119.80531, 34.44096], [-119.80503, 34.44096], [-119.80508, 34.4404], [-119.80517, 34.44035], [-119.80527, 34.44028], [-119.80564, 34.43982], [-119.80575, 34.43961], [-119.8058, 34.43946], [-119.80581, 34.4393], [-119.80649, 34.43933]]]} | Open Access 1 | 35229 | Lassen Open Space | 28547 | 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 | http://cosb.countyofsb.org/parks/parks03.aspx?id=13252 | Santa Barbara 7 | 2.024 | Lassen OS | 0 | Local Recreation Area 3 | 4 |
13201 | 13201 | 13200 | {"type": "Polygon", "coordinates": [[[-119.80136, 34.43599], [-119.80122, 34.43578], [-119.80125, 34.43551], [-119.80131, 34.4355], [-119.80138, 34.43544], [-119.80144, 34.43543], [-119.80151, 34.43544], [-119.80177, 34.43554], [-119.8019, 34.43557], [-119.80203, 34.43557], [-119.80218, 34.43556], [-119.80222, 34.43559], [-119.8022, 34.43567], [-119.80216, 34.43575], [-119.8021, 34.43582], [-119.80202, 34.43587], [-119.80193, 34.4359], [-119.80149, 34.43595], [-119.80136, 34.43599]]]} | Open Access 1 | 35221 | Thunderbird Open Space | 28546 | 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 | 0.941 | Thunderbird OS | 0 | Local Recreation Area 3 | 4 | |
13896 | 13896 | 13895 | {"type": "Polygon", "coordinates": [[[-120.4206, 34.85883], [-120.42009, 34.85944], [-120.41983, 34.85913], [-120.41982, 34.85851], [-120.42033, 34.85851], [-120.42033, 34.85866], [-120.4206, 34.85883]]]} | Open Access 1 | 36498 | Domino Open Space | 28582 | 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 | http://cosb.countyofsb.org/parks/parks03.aspx?id=13428 | Santa Barbara 7 | 1.162 | Domino OS | 0 | Local Recreation Area 3 | 4 |
13938 | 13938 | 13937 | {"type": "Polygon", "coordinates": [[[-119.79733, 34.4284], [-119.79733, 34.42843], [-119.79698, 34.42842], [-119.79697, 34.42853], [-119.79653, 34.42852], [-119.79656, 34.42798], [-119.79693, 34.42778], [-119.79699, 34.42786], [-119.79698, 34.42839], [-119.79733, 34.4284]]]} | Open Access 1 | 36554 | Rhoads Open Space | 28548 | 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 | 0.759 | Rhoads OS | 0 | Local Recreation Area 3 | 4 | |
15835 | 15835 | 15834 | {"type": "Polygon", "coordinates": [[[-119.84074, 34.4486], [-119.84062, 34.44862], [-119.84007, 34.44831], [-119.83956, 34.44809], [-119.83937, 34.44757], [-119.83959, 34.4473], [-119.83992, 34.44739], [-119.84009, 34.44716], [-119.84018, 34.44719], [-119.8403, 34.4472], [-119.84054, 34.44726], [-119.84032, 34.44792], [-119.84042, 34.44822], [-119.84063, 34.44831], [-119.84069, 34.44831], [-119.84074, 34.4486]]]} | Open Access 1 | 1150 | Stow Canyon Open Space | 25904 | 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.596 | Stow Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15963 | 15963 | 15962 | {"type": "MultiPolygon", "coordinates": [[[[-119.90372, 34.44055], [-119.90337, 34.44064], [-119.90304, 34.44075], [-119.90228, 34.44082], [-119.90212, 34.44081], [-119.9019, 34.44074], [-119.9018, 34.44071], [-119.90159, 34.44072], [-119.90141, 34.4408], [-119.90103, 34.44128], [-119.90044, 34.44129], [-119.90044, 34.44119], [-119.90054, 34.44119], [-119.90067, 34.44116], [-119.90084, 34.44107], [-119.90091, 34.441], [-119.90125, 34.44054], [-119.9014, 34.44043], [-119.90154, 34.44038], [-119.90164, 34.44037], [-119.90178, 34.44039], [-119.90217, 34.44055], [-119.90229, 34.44058], [-119.90243, 34.44059], [-119.90262, 34.44056], [-119.90312, 34.44039], [-119.90321, 34.44038], [-119.90344, 34.44039], [-119.90363, 34.44036], [-119.90367, 34.44038], [-119.90372, 34.44055]]], [[[-119.90635, 34.43896], [-119.90632, 34.43909], [-119.90622, 34.43924], [-119.90594, 34.43954], [-119.90539, 34.43967], [-119.90513, 34.43993], [-119.90497, 34.4404], [-119.90465, 34.44068], [-119.90455, 34.44101], [-119.90449, 34.44101], [-119.90448, 34.44078], [-119.90438, 34.44049], [-119.90389, 34.44046], [-119.90385, 34.44035], [-119.90389, 34.44031], [-119.90399, 34.44031], [-119.90417, 34.44034], [-119.90427, 34.44034], [-119.90442, 34.4403], [-119.90455, 34.44022], [-119.90469, 34.44007], [-119.90481, 34.43981], [-119.90508, 34.4395], [-119.90518, 34.43942], [-119.90535, 34.43934], [-119.90543, 34.43927], [-119.90548, 34.43918], [-119.90549, 34.43905], [-119.90547, 34.43895], [-119.90539, 34.43885], [-119.90549, 34.43857], [-119.90613, 34.43873], [-119.9063, 34.43887], [-119.90635, 34.43896]]]]} | Open Access 1 | 403 | San Miguel Open Space | 24956 | 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 | 5.809 | San Miguel OS | 0 | Local Recreation Area 3 | 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]);