units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where ACCESS_TYP = 4 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, COUNTY, YR_EST, GAP_STS
MNG_AGENCY 15
- Santa Barbara, City of 12
- Los Angeles, City of 3
- Carpinteria, City of 2
- San Diego, City of 1
- Fresno, City of 1
- Dana Point, City of 1
- Marina, City of 1
- Chico, City of 1
- Clovis, City of 1
- Guadalupe, City of 1
- Soledad, City of 1
- Woodland, City of 1
- Arcata, City of 1
- Rio Dell, City of 1
- Isleton, City of 1
DES_TP 9
MNG_AG_TYP 1
- City Agency · 29 ✖
ACCESS_TYP 1
- Unknown Access · 29 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15778 | 15778 | 15777 | {"type": "MultiPolygon", "coordinates": [[[[-121.75791, 36.68606], [-121.75595, 36.68696], [-121.75593, 36.68608], [-121.75451, 36.68365], [-121.75257, 36.68073], [-121.75146, 36.6801], [-121.74911, 36.6779], [-121.75195, 36.67676], [-121.75214, 36.67632], [-121.75247, 36.67453], [-121.75354, 36.67429], [-121.75391, 36.67753], [-121.75535, 36.67855], [-121.75536, 36.68165], [-121.75539, 36.682], [-121.75791, 36.68606]]], [[[-121.77964, 36.68834], [-121.7669, 36.69278], [-121.76637, 36.69229], [-121.76571, 36.69188], [-121.76504, 36.69157], [-121.76357, 36.68898], [-121.76719, 36.68783], [-121.76848, 36.68844], [-121.76912, 36.68756], [-121.77161, 36.68875], [-121.77356, 36.68598], [-121.77129, 36.68474], [-121.77174, 36.68425], [-121.77964, 36.68834]]]]} | Unknown Access 4 | 15902 | Fort Ord National Monument | 19010 | 1197 | Marina, City of 216 | City 2 | City Agency 2 | http://www.ci.marina.ca.us/index.aspx?NID=25 | City 2 | 1197 | Marina, City of 212 | City 2 | City Agency 2 | Monterey 14 | 205.529 | Fort Ord NM | 2012 | National Monument or Landmark 80 | 3 | |
14697 | 14697 | 14696 | {"type": "Polygon", "coordinates": [[[-121.80876, 39.76798], [-121.80871, 39.76806], [-121.80871, 39.76814], [-121.80873, 39.76815], [-121.80863, 39.76821], [-121.80864, 39.76851], [-121.80763, 39.76852], [-121.8071, 39.76788], [-121.80738, 39.76769], [-121.8079, 39.76741], [-121.8081, 39.76735], [-121.80827, 39.76733], [-121.80829, 39.76733], [-121.8083, 39.76746], [-121.80846, 39.76763], [-121.80856, 39.76768], [-121.80866, 39.76792], [-121.80876, 39.76798]]]} | Unknown Access 4 | 45027 | Wildwood Estate Preserve | 27518 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 3.11 | Wildwood Estate Preserve | 0 | Local Conservation Area 4 | 2 | |
14204 | 14204 | 14203 | {"type": "Polygon", "coordinates": [[[-117.69372, 33.47577], [-117.69372, 33.47621], [-117.69164, 33.47621], [-117.69155, 33.4761], [-117.69185, 33.47517], [-117.69271, 33.47517], [-117.69279, 33.47543], [-117.69307, 33.47559], [-117.69326, 33.47577], [-117.69372, 33.47577]]]} | Unknown Access 4 | 44041 | Stonehill Open Space | 25889 | 1079 | Dana Point, City of 134 | City 2 | City Agency 2 | http://www.danapoint.org/index.aspx?page=170 | City 2 | 1079 | Dana Point, City of 131 | City 2 | City Agency 2 | Orange 3 | 4.154 | Stonehill OS | 0 | Local Recreation Area 3 | 4 | |
13946 | 13946 | 13945 | {"type": "Polygon", "coordinates": [[[-119.72261, 34.40986], [-119.72251, 34.41013], [-119.72213, 34.41004], [-119.72223, 34.40976], [-119.72261, 34.40986]]]} | Unknown Access 4 | 36576 | Santa Barbara holding 6 | 25048 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.289 | Santa Barbara holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13945 | 13945 | 13944 | {"type": "Polygon", "coordinates": [[[-119.72232, 34.41009], [-119.72219, 34.41042], [-119.722, 34.41037], [-119.72213, 34.41004], [-119.72232, 34.41009]]]} | Unknown Access 4 | 36575 | Santa Barbara holding 7 | 25049 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.176 | Santa Barbara holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13944 | 13944 | 13943 | {"type": "Polygon", "coordinates": [[[-119.7227, 34.41018], [-119.72251, 34.41013], [-119.72261, 34.40986], [-119.72277, 34.4099], [-119.7228, 34.40994], [-119.7227, 34.41018]]]} | Unknown Access 4 | 36570 | Santa Barbara holding 5 | 25047 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.148 | Santa Barbara holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13943 | 13943 | 13942 | {"type": "Polygon", "coordinates": [[[-119.67454, 34.43385], [-119.6741, 34.43428], [-119.67275, 34.43326], [-119.67318, 34.43286], [-119.67454, 34.43385]]]} | Unknown Access 4 | 36569 | Santa Barbara holding 8 | 25050 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 2.52 | Santa Barbara holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13328 | 13328 | 13327 | {"type": "Polygon", "coordinates": [[[-119.7227, 34.41018], [-119.72259, 34.41048], [-119.72256, 34.4105], [-119.72219, 34.41042], [-119.72232, 34.41009], [-119.7227, 34.41018]]]} | Unknown Access 4 | 35396 | Santa Barbara holding 2 | 25044 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.342 | Santa Barbara holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13234 | 13234 | 13233 | {"type": "Polygon", "coordinates": [[[-120.57752, 34.96378], [-120.57752, 34.96399], [-120.57714, 34.96399], [-120.57714, 34.96377], [-120.57752, 34.96378]]]} | Unknown Access 4 | 35278 | Guadalupe holding 9 | 19554 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.206 | Guadalupe holding 9 | 0 | Local Other or Unknown 14 | 4 | ||
12995 | 12995 | 12994 | {"type": "Polygon", "coordinates": [[[-119.69167, 34.45419], [-119.69138, 34.45435], [-119.691, 34.45433], [-119.69056, 34.45403], [-119.69059, 34.45371], [-119.69063, 34.45361], [-119.69071, 34.45352], [-119.69083, 34.45346], [-119.6913, 34.45343], [-119.69167, 34.45419]]]} | Unknown Access 4 | 35356 | Santa Barbara holding 1 | 25042 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 1.835 | Santa Barbara holding 1 | 0 | Local Other or Unknown 14 | 4 | |
12711 | 12711 | 12710 | {"type": "Polygon", "coordinates": [[[-121.72875, 38.64797], [-121.72864, 38.65335], [-121.72639, 38.65334], [-121.72639, 38.65153], [-121.71965, 38.65152], [-121.71964, 38.65159], [-121.7104, 38.65156], [-121.7105, 38.64787], [-121.72282, 38.64792], [-121.72283, 38.649], [-121.7259, 38.649], [-121.72593, 38.64795], [-121.72875, 38.64797]]]} | Unknown Access 4 | 29718 | Spring Lake | 25739 | 1665 | Woodland, City of 547 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | Yolo 33 | 160.694 | Spring Lake | None 1108 | |||
11085 | 11085 | 11084 | {"type": "Polygon", "coordinates": [[[-121.5949, 38.15797], [-121.59472, 38.15807], [-121.592, 38.16102], [-121.59186, 38.16102], [-121.58624, 38.15878], [-121.58673, 38.15797], [-121.5871, 38.1577], [-121.58783, 38.15763], [-121.58864, 38.15775], [-121.59014, 38.15777], [-121.59087, 38.15761], [-121.59142, 38.15729], [-121.59198, 38.15656], [-121.5949, 38.15797]]]} | Unknown Access 4 | 21327 | Delta Protection | 18076 | 1150 | Isleton, City of 964 | City 2 | City Agency 2 | http://www.isletoncoc.org/ | City 2 | 1150 | Isleton, City of 932 | City 2 | City Agency 2 | Sacramento 41 | 46.487 | Delta Protection | None 962 | |||
9729 | 9729 | 9728 | {"type": "Polygon", "coordinates": [[[-119.6934, 34.52036], [-119.6934, 34.52221], [-119.69115, 34.52218], [-119.69114, 34.52754], [-119.68866, 34.52752], [-119.68705, 34.52781], [-119.68501, 34.52954], [-119.68622, 34.53066], [-119.68472, 34.53039], [-119.68386, 34.53133], [-119.67969, 34.53036], [-119.67781, 34.52923], [-119.67491, 34.5293], [-119.67149, 34.52698], [-119.66811, 34.52495], [-119.66732, 34.52538], [-119.66722, 34.52689], [-119.66577, 34.52755], [-119.6666, 34.52867], [-119.66618, 34.53081], [-119.66796, 34.53221], [-119.66763, 34.53302], [-119.6658, 34.53325], [-119.66514, 34.53309], [-119.6664, 34.53236], [-119.66561, 34.53143], [-119.66599, 34.5291], [-119.66389, 34.52704], [-119.65995, 34.52669], [-119.65741, 34.52878], [-119.65352, 34.52894], [-119.65144, 34.5286], [-119.64741, 34.52628], [-119.64605, 34.52516], [-119.64503, 34.52343], [-119.64467, 34.52235], [-119.64306, 34.52303], [-119.64129, 34.52278], [-119.63968, 34.52275], [-119.63712, 34.52172], [-119.63329, 34.52084], [-119.63247, 34.52217], [-119.63085, 34.52238], [-119.6296, 34.52313], [-119.6276, 34.52426], [-119.62715, 34.52608], [-119.63044, 34.52831], [-119.63085, 34.52999], [-119.6308, 34.53047], [-119.63135, 34.53015], [-119.63372, 34.5296], [-119.63515, 34.52996], [-119.63677, 34.53112], [-119.63734, 34.53289], [-119.6381, 34.53317], [-119.6361, 34.53433], [-119.63547, 34.53506], [-119.63983, 34.53544], [-119.63879, 34.53598], [-119.63742, 34.53615], [-119.63701, 34.53779], [-119.63555, 34.53873], [-119.63561, 34.53935], [-119.6374, 34.53989], [-119.63713, 34.54123], [-119.63743, 34.54178], [-119.63794, 34.54182], [-119.63831, 34.54016], [-119.63944, 34.53981], [-119.6405, 34.53968], [-119.64324, 34.54248], [-119.64332, 34.54352], [-119.6421, 34.5457], [-119.64226, 34.54683], [-119.64087, 34.54775], [-119.63885, 34.54829], [-119.63962, 34.54693], [-119.63881, 34.5462], [-119.64092, 34.54371], [-119.64035, 34.54314], [-119.63908, 34.54288], [-119.63751, 34.54389], [-119.63537, 34.54242], [-119.63522, 34.54073], [-119.63257, 34.53803], [-119.63146, 34.53994], [-119.63076, 34.54022], [-119.63073, 34.54045], [-119.63118, 34.54086], [-119.63118, 34.54213], [-119.62993, 34.54216], [-119.62822, 34.54155], [-119.62802, 34.54172], [-119.62753, 34.54121], [-119.62714, 34.54119], [-119.62678, 34.54204], [-119.62777, 34.54251], [-119.62947, 34.54367], [-119.6322, 34.54523], [-119.62971, 34.5449], [-119.6297, 34.54575], [-119.62938, 34.54761], [-119.62813, 34.54806], [-119.62443, 34.54676], [-119.62415, 34.54673], [-119.62367, 34.54769], [-119.6237, 34.54853], [-119.62276, 34.54962], [-119.62247, 34.54963], [-119.62297, 34.54569], [-119.62344, 34.54558], [-119.62792, 34.54657], [-119.62826, 34.54627], [-119.62775, 34.54505], [-119.62729, 34.54434], [-119.62493, 34.54437], [-119.62428, 34.5438], [-119.62417, 34.54201], [-119.62251, 34.54055], [-119.62356, 34.53906], [-119.6255, 34.5396], [-119.62721, 34.53891], [-119.62817, 34.53927], [-119.62953, 34.53924], [-119.62954, 34.53923], [-119.62905, 34.53753], [-119.62803, 34.53661], [-119.62703, 34.53618], [-119.62609, 34.53623], [-119.6254, 34.53551], [-119.62507, 34.53642], [-119.62395, 34.53586], [-119.6233, 34.53588], [-119.62223, 34.53672], [-119.62191, 34.53556], [-119.62609, 34.53399], [-119.6265, 34.53111], [-119.63041, 34.53065], [-119.63054, 34.53006], [-119.63017, 34.52838], [-119.62687, 34.52621], [-119.62739, 34.52412], [-119.62832, 34.52354], [-119.62979, 34.5228], [-119.63073, 34.52222], [-119.63239, 34.52191], [-119.63266, 34.52094], [-119.63222, 34.51907], [-119.63374, 34.51892], [-119.63539, 34.51883], [-119.63861, 34.51929], [-119.64019, 34.5204], [-119.64043, 34.51992], [-119.6408, 34.52076], [-119.64154, 34.52053], [-119.64505, 34.52033], [-119.64689, 34.52171], [-119.6484, 34.5232], [-119.65019, 34.5264], [-119.65259, 34.52569], [-119.65347, 34.5265], [-119.65703, 34.5285], [-119.65784, 34.52777], [-119.65784, 34.52672], [-119.65831, 34.52707], [-119.66009, 34.52521], [-119.66441, 34.52522], [-119.66858, 34.52383], [-119.67364, 34.526], [-119.67425, 34.52593], [-119.67374, 34.52267], [-119.66995, 34.51894], [-119.67134, 34.51923], [-119.67499, 34.52215], [-119.67562, 34.52267], [-119.67459, 34.52272], [-119.67473, 34.52671], [-119.68072, 34.52912], [-119.68307, 34.52908], [-119.68435, 34.52755], [-119.68434, 34.52753], [-119.68241, 34.52753], [-119.68242, 34.52388], [-119.68457, 34.52388], [-119.68458, 34.52035], [-119.6934, 34.52036]]]} | Unknown Access 4 | 16478 | Gibraltar Reservoir | 19290 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | https://www.santabarbaraca.gov/gov/depts/pw/resources/system/sources/gibraltar.asp | Santa Barbara 7 | 925.313 | Gibraltar Reservoir | 0 | Local Recreation Area 3 | 4 |
7814 | 7814 | 7813 | {"type": "Polygon", "coordinates": [[[-116.9793, 33.00015], [-116.97875, 33.00754], [-116.96993, 33.00757], [-116.96172, 33.00767], [-116.9618, 33.00385], [-116.96605, 33.00387], [-116.9661, 33.0001], [-116.97037, 33.00014], [-116.9793, 33.00015]], [[-116.96341, 33.00537], [-116.96341, 33.00535], [-116.96301, 33.00517], [-116.96282, 33.00519], [-116.96283, 33.00535], [-116.9626, 33.00539], [-116.96258, 33.00528], [-116.96208, 33.00531], [-116.96211, 33.00571], [-116.96243, 33.0057], [-116.96285, 33.00559], [-116.96301, 33.00552], [-116.96317, 33.00548], [-116.96341, 33.00537]]]} | Unknown Access 4 | 45215 | City of San Diego Open Space | 17331 | 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 | 287.249 | City of San Diego OS | 0 | Local Recreation Area 3 | 4 | |
6601 | 6601 | 6600 | {"type": "MultiPolygon", "coordinates": [[[[-119.50722, 34.39559], [-119.50661, 34.3957], [-119.50574, 34.39635], [-119.5055, 34.39636], [-119.50526, 34.39632], [-119.50526, 34.39623], [-119.50539, 34.39622], [-119.50563, 34.39619], [-119.50586, 34.39611], [-119.50597, 34.39606], [-119.50676, 34.39552], [-119.50722, 34.39559]]], [[[-119.51198, 34.39382], [-119.51152, 34.39386], [-119.51141, 34.39389], [-119.51064, 34.3943], [-119.51039, 34.39448], [-119.51014, 34.39416], [-119.51121, 34.39348], [-119.51144, 34.3934], [-119.51198, 34.39382]]]]} | Unknown Access 4 | 4238 | Carpinteria Creek | 16897 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 2.293 | Carpinteria Creek | 0 | Local Other or Unknown 14 | 4 | |
5005 | 5005 | 5004 | {"type": "Polygon", "coordinates": [[[-119.70199, 36.84945], [-119.70166, 36.8492], [-119.6998, 36.84806], [-119.69973, 36.84801], [-119.69944, 36.8476], [-119.69939, 36.84721], [-119.69943, 36.84702], [-119.69958, 36.84682], [-119.70058, 36.84598], [-119.70076, 36.8457], [-119.70083, 36.84536], [-119.7008, 36.84483], [-119.70149, 36.84483], [-119.70172, 36.84527], [-119.70192, 36.84589], [-119.70196, 36.8461], [-119.702, 36.84659], [-119.70199, 36.84693], [-119.70201, 36.848], [-119.70199, 36.84945]]]} | Unknown Access 4 | 17221 | Dry Creek | 18278 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 17.89 | Dry Creek | 0 | Local Other or Unknown 14 | 4 | |
4946 | 4946 | 4945 | {"type": "Polygon", "coordinates": [[[-119.7272, 34.4336], [-119.72698, 34.43445], [-119.72664, 34.43545], [-119.72639, 34.43526], [-119.72657, 34.43483], [-119.72679, 34.43462], [-119.72695, 34.43445], [-119.72702, 34.43416], [-119.72681, 34.43413], [-119.72683, 34.43397], [-119.72706, 34.43399], [-119.72716, 34.43359], [-119.7272, 34.4336]]]} | Unknown Access 4 | 14659 | El Mission Creek | 18514 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 0.719 | El Mission Creek | 0 | Local Other or Unknown 14 | 4 | |
4769 | 4769 | 4768 | {"type": "Polygon", "coordinates": [[[-124.10344, 40.4928], [-124.10326, 40.49301], [-124.10325, 40.49313], [-124.10297, 40.49314], [-124.10296, 40.49296], [-124.103, 40.49297], [-124.10313, 40.4928], [-124.10344, 40.4928]]]} | Unknown Access 4 | 46929 | Unnamed site - Rio Dell, City of | 30545 | 1435 | Rio Dell, City of 642 | City 2 | City Agency 2 | http://www.riodellcity.com/ | City 2 | 1435 | Rio Dell, City of 632 | City 2 | City Agency 2 | Humboldt 45 | 0.236 | 0 | Local Other or Unknown 14 | 4 | ||
4718 | 4718 | 4717 | {"type": "Polygon", "coordinates": [[[-118.28418, 34.23377], [-118.28386, 34.23376], [-118.28045, 34.23393], [-118.27981, 34.23393], [-118.27976, 34.22908], [-118.27539, 34.22911], [-118.27538, 34.22816], [-118.28411, 34.2281], [-118.28418, 34.23377]]]} | Unknown Access 4 | 46522 | Unnamed site - Los Angeles, City of | 29809 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 73.646 | 0 | Local Other or Unknown 14 | 4 | ||
4370 | 4370 | 4369 | {"type": "Polygon", "coordinates": [[[-118.47207, 33.99034], [-118.47192, 33.99044], [-118.47173, 33.99025], [-118.47189, 33.99014], [-118.47207, 33.99034]]]} | Unknown Access 4 | 45826 | San Juan Garage | 28845 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.124 | San Juan Garage | None 386 |
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]);