units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where COUNTY = 14 and MNG_AG_TYP = 10 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, YR_EST, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
442 | 442 | 441 | {"type": "Polygon", "coordinates": [[[-121.93363, 36.54329], [-121.93317, 36.54325], [-121.93307, 36.54313], [-121.93323, 36.54306], [-121.93329, 36.54312], [-121.93337, 36.54317], [-121.93363, 36.54329]]]} | Restricted Access 2 | 1381 | Tor House | 26411 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.129 | Tor House | 0 | Private Conservation 16 | 2 | |
10215 | 10215 | 10214 | {"type": "Polygon", "coordinates": [[[-121.91841, 36.54792], [-121.91818, 36.54805], [-121.91774, 36.54778], [-121.91774, 36.54777], [-121.9183, 36.54778], [-121.91841, 36.54792]]]} | Restricted Access 2 | 17874 | Mission Trails/Probasco | 22315 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.256 | Mission Trails/Probasco | 0 | Private Conservation 16 | 2 | |
2296 | 2296 | 2295 | {"type": "Polygon", "coordinates": [[[-121.93865, 36.50129], [-121.93862, 36.50189], [-121.93831, 36.5019], [-121.93831, 36.50186], [-121.93839, 36.50179], [-121.93842, 36.50173], [-121.9384, 36.50165], [-121.93832, 36.5016], [-121.93831, 36.50147], [-121.93849, 36.50138], [-121.93848, 36.50133], [-121.93865, 36.50129]]]} | Restricted Access 2 | 16894 | Highlands Inn turnout | 19940 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.373 | Highlands Inn turnout | 0 | Private Conservation 16 | 2 | |
6413 | 6413 | 6412 | {"type": "Polygon", "coordinates": [[[-121.93361, 36.54372], [-121.93342, 36.54391], [-121.9333, 36.54419], [-121.93338, 36.54444], [-121.93337, 36.54452], [-121.93334, 36.54453], [-121.93305, 36.54443], [-121.93288, 36.54441], [-121.93264, 36.54448], [-121.9325, 36.54447], [-121.93239, 36.54448], [-121.93237, 36.54438], [-121.93252, 36.54434], [-121.93284, 36.54436], [-121.93292, 36.54428], [-121.9331, 36.54428], [-121.93338, 36.54376], [-121.93361, 36.54372]]]} | No Public Access 3 | 3340 | Carmel Point | 16873 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.545 | Carmel Point | 0 | Private Conservation 16 | 2 | |
9846 | 9846 | 9845 | {"type": "Polygon", "coordinates": [[[-121.75445, 36.22079], [-121.75378, 36.22097], [-121.75356, 36.22094], [-121.7535, 36.2208], [-121.75377, 36.22063], [-121.75412, 36.22022], [-121.7541, 36.22039], [-121.75416, 36.22056], [-121.75428, 36.2207], [-121.75445, 36.22079]]]} | Restricted Access 2 | 16833 | Henry Miller Library | 19825 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.706 | Henry Miller Library | 0 | Private Conservation 16 | 2 | |
4562 | 4562 | 4561 | {"type": "Polygon", "coordinates": [[[-121.79416, 36.26266], [-121.79365, 36.26267], [-121.79215, 36.26261], [-121.79215, 36.2623], [-121.79397, 36.26233], [-121.79416, 36.26266]]]} | Unknown Access 4 | 35188 | Unnamed site - Save the Redwoods League | 28667 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/ | Monterey 14 | 1.537 | 0 | Private Other or Unknown 399 | 4 | |
9956 | 9956 | 9955 | {"type": "Polygon", "coordinates": [[[-121.43202, 35.86496], [-121.43153, 35.86465], [-121.42979, 35.86366], [-121.42952, 35.86346], [-121.42931, 35.86325], [-121.4306, 35.86327], [-121.43074, 35.86332], [-121.43083, 35.86332], [-121.43092, 35.86336], [-121.43109, 35.8634], [-121.43128, 35.8635], [-121.43137, 35.86353], [-121.43147, 35.86354], [-121.43164, 35.86366], [-121.43173, 35.86367], [-121.43193, 35.86378], [-121.43198, 35.86385], [-121.43202, 35.86496]]]} | Restricted Access 2 | 17132 | Kopp | 20717 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 5.005 | Kopp | 0 | Private Conservation 16 | 2 | |
14619 | 14619 | 14618 | {"type": "Polygon", "coordinates": [[[-121.90552, 36.39559], [-121.90264, 36.39564], [-121.90257, 36.39556], [-121.90235, 36.39508], [-121.90232, 36.39481], [-121.90213, 36.39455], [-121.90202, 36.39409], [-121.90218, 36.39379], [-121.90166, 36.39367], [-121.90166, 36.39363], [-121.90291, 36.39363], [-121.90303, 36.39396], [-121.90334, 36.39423], [-121.90351, 36.39432], [-121.90369, 36.39437], [-121.90387, 36.39449], [-121.90399, 36.39464], [-121.90391, 36.39477], [-121.90374, 36.39488], [-121.90374, 36.39495], [-121.90378, 36.39509], [-121.90385, 36.39523], [-121.90402, 36.39535], [-121.90437, 36.39548], [-121.90455, 36.39552], [-121.90492, 36.39553], [-121.9051, 36.39551], [-121.90532, 36.39551], [-121.90541, 36.39553], [-121.90552, 36.39559]]]} | Open Access 1 | 44850 | Notley's Landing | 22909 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 7.251 | Notley's Landing | 0 | Private Conservation 16 | 2 | |
9183 | 9183 | 9182 | {"type": "Polygon", "coordinates": [[[-121.7894, 36.81978], [-121.78896, 36.82003], [-121.78623, 36.82002], [-121.7864, 36.81918], [-121.78663, 36.81883], [-121.78692, 36.81852], [-121.78709, 36.8182], [-121.78772, 36.81857], [-121.78831, 36.81895], [-121.78887, 36.81935], [-121.7894, 36.81978]]]} | Open Access 1 | 15247 | Elkhorn Slough / Sandholdt - ESF | 18580 | 3019 | Elkhorn Slough Foundation 464 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.elkhornslough.org | Non Governmental Organization 10 | 3019 | Elkhorn Slough Foundation 457 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 8.401 | Elkhorn Slough / Sandholdt - ESF | 0 | Private Conservation 16 | 2 | |
9721 | 9721 | 9720 | {"type": "Polygon", "coordinates": [[[-121.7533, 36.23116], [-121.75183, 36.23133], [-121.75128, 36.23163], [-121.75085, 36.23034], [-121.75086, 36.22979], [-121.7533, 36.22983], [-121.7533, 36.23116]]]} | Restricted Access 2 | 16469 | Gelbart | 19249 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 8.735 | Gelbart | 0 | Private Conservation 16 | 2 | |
14614 | 14614 | 14613 | {"type": "Polygon", "coordinates": [[[-121.83146, 36.52516], [-121.83129, 36.52544], [-121.83095, 36.52559], [-121.83081, 36.52568], [-121.82997, 36.52431], [-121.82878, 36.5243], [-121.82877, 36.52349], [-121.8286, 36.52348], [-121.8286, 36.52327], [-121.82707, 36.52296], [-121.82806, 36.52234], [-121.8297, 36.52268], [-121.83146, 36.52516]]]} | Open Access 1 | 44848 | Carmel River Songbird Preserve | 16875 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 11.39 | Carmel River Songbird Preserve | 0 | Private Conservation 16 | 2 | |
1553 | 1553 | 1552 | {"type": "Polygon", "coordinates": [[[-121.90672, 36.50825], [-121.90222, 36.5082], [-121.90221, 36.50639], [-121.90672, 36.50645], [-121.90672, 36.50825]]]} | Restricted Access 2 | 11595 | Curtis | 17864 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 19.995 | Curtis | 0 | Private Conservation 16 | 2 | |
14597 | 14597 | 14596 | {"type": "Polygon", "coordinates": [[[-121.72845, 36.82317], [-121.72733, 36.82518], [-121.72606, 36.82474], [-121.72639, 36.82412], [-121.72439, 36.82382], [-121.72538, 36.82202], [-121.72406, 36.82155], [-121.72768, 36.82091], [-121.72769, 36.82102], [-121.72808, 36.8211], [-121.72722, 36.82266], [-121.72843, 36.82309], [-121.72845, 36.82317]]]} | No Public Access 3 | 44811 | Elkhorn Slough | 18572 | 3019 | Elkhorn Slough Foundation 464 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.elkhornslough.org | Non Governmental Organization 10 | 3019 | Elkhorn Slough Foundation 457 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 24.799 | Elkhorn Slough | 0 | Private Conservation 16 | 2 | |
10283 | 10283 | 10282 | {"type": "Polygon", "coordinates": [[[-121.6547, 36.1411], [-121.65326, 36.1411], [-121.65289, 36.14044], [-121.65268, 36.13992], [-121.65204, 36.14043], [-121.65076, 36.1392], [-121.64971, 36.13814], [-121.64917, 36.13763], [-121.64917, 36.13645], [-121.64931, 36.13644], [-121.64941, 36.13604], [-121.64917, 36.13595], [-121.64918, 36.13411], [-121.64925, 36.13426], [-121.64931, 36.13451], [-121.64931, 36.13486], [-121.64923, 36.13501], [-121.64922, 36.13511], [-121.64928, 36.13518], [-121.64936, 36.13526], [-121.64964, 36.1352], [-121.64974, 36.13526], [-121.64977, 36.13534], [-121.64978, 36.13559], [-121.64988, 36.13576], [-121.64995, 36.13592], [-121.64997, 36.13607], [-121.64987, 36.1361], [-121.64981, 36.13619], [-121.64978, 36.13651], [-121.64979, 36.13666], [-121.64981, 36.13673], [-121.65003, 36.13683], [-121.65027, 36.1369], [-121.65037, 36.13695], [-121.65043, 36.13703], [-121.65071, 36.13716], [-121.65092, 36.13732], [-121.65107, 36.13738], [-121.65136, 36.1376], [-121.65148, 36.13765], [-121.65191, 36.13777], [-121.65211, 36.13779], [-121.65233, 36.13785], [-121.65242, 36.13786], [-121.65281, 36.1381], [-121.65291, 36.13825], [-121.65306, 36.13841], [-121.65317, 36.13856], [-121.65324, 36.13873], [-121.65328, 36.13897], [-121.65333, 36.13904], [-121.65333, 36.13912], [-121.6534, 36.13927], [-121.65361, 36.13949], [-121.65371, 36.13955], [-121.65373, 36.13963], [-121.65374, 36.13971], [-121.65362, 36.13987], [-121.65359, 36.14004], [-121.6536, 36.1403], [-121.6537, 36.14053], [-121.65381, 36.14069], [-121.65403, 36.14081], [-121.65423, 36.14084], [-121.65433, 36.14088], [-121.6547, 36.1411]]]} | Restricted Access 2 | 18049 | Murphy | 22606 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 24.906 | Murphy | 0 | Private Conservation 16 | 2 | |
535 | 535 | 534 | {"type": "Polygon", "coordinates": [[[-121.91117, 36.50829], [-121.9087, 36.50828], [-121.9087, 36.50744], [-121.9081, 36.50743], [-121.90839, 36.50686], [-121.90839, 36.50628], [-121.90807, 36.50595], [-121.90715, 36.50527], [-121.90671, 36.50464], [-121.91113, 36.50468], [-121.91117, 36.50829]]]} | No Public Access 3 | 2572 | Canavarro | 16797 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 27.752 | Canavarro | 0 | Private Conservation 16 | 2 | |
2308 | 2308 | 2307 | {"type": "Polygon", "coordinates": [[[-121.74109, 36.20753], [-121.74023, 36.20903], [-121.74017, 36.20907], [-121.74019, 36.20934], [-121.73998, 36.20962], [-121.73983, 36.21012], [-121.73958, 36.21002], [-121.73936, 36.20986], [-121.73793, 36.2084], [-121.73781, 36.20831], [-121.73766, 36.20826], [-121.73743, 36.20823], [-121.73726, 36.20826], [-121.73713, 36.20831], [-121.73666, 36.20856], [-121.73645, 36.20861], [-121.73627, 36.20861], [-121.73579, 36.20852], [-121.73553, 36.2085], [-121.73517, 36.20855], [-121.73479, 36.20869], [-121.73466, 36.20872], [-121.73446, 36.20871], [-121.73432, 36.20868], [-121.73423, 36.20864], [-121.73483, 36.20817], [-121.73538, 36.20764], [-121.7358, 36.20726], [-121.73632, 36.20683], [-121.73645, 36.20679], [-121.73834, 36.20563], [-121.73853, 36.20558], [-121.7393, 36.20504], [-121.73939, 36.20508], [-121.73948, 36.20516], [-121.7395, 36.20532], [-121.7395, 36.20556], [-121.73955, 36.20571], [-121.73956, 36.20579], [-121.73957, 36.20601], [-121.73965, 36.20607], [-121.73976, 36.20613], [-121.73985, 36.20613], [-121.73987, 36.20629], [-121.7399, 36.20635], [-121.73997, 36.20642], [-121.7399, 36.20649], [-121.73992, 36.20657], [-121.74003, 36.20664], [-121.74011, 36.2068], [-121.74036, 36.20701], [-121.74045, 36.20715], [-121.74063, 36.20718], [-121.74068, 36.20725], [-121.74077, 36.20732], [-121.74106, 36.20745], [-121.74109, 36.20753]]]} | Restricted Access 2 | 18323 | Owings | 23277 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 35.43 | Owings | 0 | Private Conservation 16 | 2 | |
2400 | 2400 | 2399 | {"type": "Polygon", "coordinates": [[[-121.59811, 36.07501], [-121.59802, 36.07863], [-121.59354, 36.07864], [-121.59363, 36.07502], [-121.59811, 36.07501]]]} | Restricted Access 2 | 17234 | Landels-Hill Big Creek Reserve | 21004 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 40.063 | Landels-Hill Big Creek Reserve | 0 | Private Conservation 16 | 2 | |
9064 | 9064 | 9063 | {"type": "MultiPolygon", "coordinates": [[[[-121.75263, 36.85516], [-121.75065, 36.85699], [-121.75018, 36.85703], [-121.74877, 36.85849], [-121.74805, 36.85863], [-121.74789, 36.85532], [-121.75263, 36.85516]]], [[[-121.74646, 36.88109], [-121.73938, 36.88076], [-121.73873, 36.88092], [-121.73862, 36.88056], [-121.7411, 36.88026], [-121.74146, 36.88018], [-121.7417, 36.88009], [-121.74189, 36.87998], [-121.74208, 36.87984], [-121.74248, 36.87945], [-121.74262, 36.87937], [-121.74279, 36.87931], [-121.74322, 36.87929], [-121.74362, 36.87929], [-121.74433, 36.87935], [-121.74434, 36.87933], [-121.74445, 36.87935], [-121.74446, 36.87937], [-121.74459, 36.87938], [-121.74488, 36.87939], [-121.7452, 36.87936], [-121.74544, 36.87932], [-121.74569, 36.87925], [-121.74583, 36.87917], [-121.74593, 36.87908], [-121.74602, 36.87895], [-121.74605, 36.87882], [-121.74603, 36.87868], [-121.74553, 36.87736], [-121.74477, 36.87596], [-121.74529, 36.8759], [-121.7452, 36.87554], [-121.74532, 36.87554], [-121.74565, 36.87667], [-121.74582, 36.87665], [-121.74645, 36.87865], [-121.7465, 36.87886], [-121.74657, 36.87933], [-121.74658, 36.87979], [-121.74657, 36.88007], [-121.74646, 36.88109]]]]} | No Public Access 3 | 15004 | Elkhorn Slough | 18572 | 3019 | Elkhorn Slough Foundation 464 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.elkhornslough.org | Non Governmental Organization 10 | 3019 | Elkhorn Slough Foundation 457 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 47.964 | Elkhorn Slough | 0 | Private Conservation 16 | 2 | |
1183 | 1183 | 1182 | {"type": "Polygon", "coordinates": [[[-121.91238, 36.53285], [-121.91178, 36.53344], [-121.91174, 36.5336], [-121.90785, 36.53358], [-121.90718, 36.53361], [-121.90652, 36.53368], [-121.90586, 36.53377], [-121.90514, 36.53391], [-121.90169, 36.53471], [-121.90144, 36.53402], [-121.90197, 36.53366], [-121.90319, 36.53217], [-121.9039, 36.53149], [-121.90504, 36.53109], [-121.90542, 36.53107], [-121.90577, 36.5311], [-121.90609, 36.53133], [-121.90641, 36.53152], [-121.90692, 36.53164], [-121.9072, 36.53167], [-121.90743, 36.53162], [-121.90823, 36.53118], [-121.90861, 36.53115], [-121.91058, 36.5322], [-121.91194, 36.53282], [-121.91238, 36.53285]]]} | Restricted Access 2 | 7782 | Coast Ranch | 17463 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 51.109 | Coast Ranch | 0 | Private Conservation 16 | 2 | |
9165 | 9165 | 9164 | {"type": "Polygon", "coordinates": [[[-121.74681, 36.86075], [-121.74688, 36.86101], [-121.74687, 36.86114], [-121.74683, 36.86128], [-121.74681, 36.86152], [-121.74671, 36.86185], [-121.74632, 36.86269], [-121.74615, 36.86292], [-121.74583, 36.86318], [-121.74557, 36.86347], [-121.74523, 36.86409], [-121.74511, 36.86439], [-121.74509, 36.8647], [-121.74528, 36.86541], [-121.74553, 36.86674], [-121.74564, 36.86767], [-121.74483, 36.86791], [-121.74469, 36.86701], [-121.74398, 36.86742], [-121.74393, 36.86792], [-121.74367, 36.86789], [-121.74295, 36.86748], [-121.74223, 36.86702], [-121.7416, 36.86666], [-121.74035, 36.86618], [-121.74039, 36.86596], [-121.74045, 36.86502], [-121.74032, 36.86324], [-121.74143, 36.86316], [-121.74136, 36.86206], [-121.74681, 36.86075]]]} | No Public Access 3 | 15213 | Elkhorn Slough / Porter Preserve | 18578 | 3019 | Elkhorn Slough Foundation 464 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.elkhornslough.org | Non Governmental Organization 10 | 3019 | Elkhorn Slough Foundation 457 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 70.791 | Elkhorn Slough / Porter Preserve | 0 | Private Conservation 16 | 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]);