units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where DES_TP = 54 and MNG_AGENCY = 59 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, PARK_URL, COUNTY, LABEL_NAME, YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- United States National Park Service · 34 ✖
DES_TP 1
- National Recreation Area · 34 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15803 | 15803 | 15802 | {"type": "Polygon", "coordinates": [[[-122.71133, 40.61643], [-122.71149, 40.61739], [-122.71147, 40.61801], [-122.71143, 40.61845], [-122.71132, 40.61911], [-122.71122, 40.61946], [-122.71099, 40.62011], [-122.71097, 40.6202], [-122.71089, 40.62057], [-122.71076, 40.62142], [-122.71074, 40.62165], [-122.71078, 40.6222], [-122.71085, 40.62249], [-122.71114, 40.62322], [-122.71121, 40.6234], [-122.71122, 40.62354], [-122.71107, 40.62433], [-122.711, 40.62455], [-122.71087, 40.62486], [-122.71088, 40.62487], [-122.71093, 40.62487], [-122.71028, 40.62598], [-122.71013, 40.62628], [-122.70975, 40.62674], [-122.70966, 40.62699], [-122.70971, 40.62737], [-122.71009, 40.62842], [-122.71027, 40.6288], [-122.71034, 40.62911], [-122.71018, 40.6296], [-122.71003, 40.63022], [-122.70998, 40.63036], [-122.70986, 40.63054], [-122.70977, 40.63114], [-122.70169, 40.63286], [-122.70156, 40.63443], [-122.69885, 40.63653], [-122.69878, 40.63781], [-122.69894, 40.63844], [-122.69651, 40.63891], [-122.69486, 40.63832], [-122.693, 40.63826], [-122.69116, 40.63886], [-122.69076, 40.63972], [-122.69051, 40.63953], [-122.68984, 40.63897], [-122.68844, 40.63955], [-122.68647, 40.63983], [-122.68452, 40.64085], [-122.68277, 40.64498], [-122.68288, 40.64624], [-122.68321, 40.64793], [-122.68546, 40.64801], [-122.68549, 40.65064], [-122.68552, 40.65098], [-122.68565, 40.65162], [-122.68268, 40.65161], [-122.68223, 40.65318], [-122.68122, 40.65379], [-122.68099, 40.6554], [-122.68035, 40.65639], [-122.67916, 40.65719], [-122.67799, 40.65991], [-122.67815, 40.66061], [-122.67752, 40.66092], [-122.67507, 40.66305], [-122.6717, 40.66368], [-122.66965, 40.66631], [-122.65169, 40.66612], [-122.65148, 40.67122], [-122.65145, 40.67217], [-122.65102, 40.68034], [-122.65106, 40.68072], [-122.63293, 40.68092], [-122.63291, 40.68044], [-122.63295, 40.67327], [-122.63263, 40.66945], [-122.62787, 40.66965], [-122.6231, 40.66983], [-122.62301, 40.66594], [-122.61369, 40.66604], [-122.61374, 40.66435], [-122.61373, 40.66434], [-122.60475, 40.66419], [-122.59555, 40.66395], [-122.59579, 40.66191], [-122.59112, 40.66189], [-122.58462, 40.66195], [-122.58181, 40.66194], [-122.57723, 40.66196], [-122.56334, 40.66227], [-122.56258, 40.6663], [-122.55775, 40.6663], [-122.53942, 40.66616], [-122.54161, 40.65081], [-122.5258, 40.65116], [-122.52499, 40.65115], [-122.52263, 40.65122], [-122.52256, 40.65016], [-122.5224, 40.64503], [-122.5221, 40.63649], [-122.52233, 40.632], [-122.52163, 40.63165], [-122.52006, 40.63074], [-122.51962, 40.63045], [-122.51902, 40.62997], [-122.51849, 40.62945], [-122.51805, 40.62888], [-122.51769, 40.62828], [-122.51751, 40.62786], [-122.51743, 40.62765], [-122.5173, 40.62722], [-122.51723, 40.62678], [-122.5172, 40.62656], [-122.51719, 40.62634], [-122.5172, 40.6259], [-122.51725, 40.62546], [-122.51729, 40.62524], [-122.51792, 40.62382], [-122.51839, 40.62304], [-122.51856, 40.62244], [-122.51856, 40.62174], [-122.5185, 40.62151], [-122.50899, 40.62134], [-122.50902, 40.61951], [-122.51368, 40.61964], [-122.51374, 40.61653], [-122.51392, 40.61029], [-122.51456, 40.6103], [-122.51457, 40.61029], [-122.51044, 40.60684], [-122.51025, 40.60665], [-122.51211, 40.60666], [-122.51398, 40.60815], [-122.51403, 40.60666], [-122.51472, 40.60665], [-122.51474, 40.60306], [-122.51201, 40.60303], [-122.50974, 40.60303], [-122.50974, 40.59954], [-122.50469, 40.59952], [-122.50497, 40.59214], [-122.50502, 40.58486], [-122.50521, 40.57767], [-122.50645, 40.56059], [-122.51498, 40.56028], [-122.51504, 40.5461], [-122.52413, 40.54614], [-122.52408, 40.54792], [-122.52401, 40.55315], [-122.52901, 40.55361], [-122.53641, 40.55418], [-122.54351, 40.55477], [-122.54334, 40.5618], [-122.55359, 40.56199], [-122.56157, 40.56207], [-122.56164, 40.55171], [-122.56621, 40.55151], [-122.56781, 40.55146], [-122.57092, 40.5514], [-122.57089, 40.55494], [-122.5802, 40.55501], [-122.58016, 40.55734], [-122.58079, 40.55785], [-122.58354, 40.55793], [-122.58418, 40.55827], [-122.58784, 40.55907], [-122.58834, 40.56162], [-122.58842, 40.5618], [-122.58989, 40.56172], [-122.58989, 40.56218], [-122.59036, 40.56316], [-122.59077, 40.56498], [-122.59342, 40.5667], [-122.59394, 40.56702], [-122.59679, 40.56584], [-122.5995, 40.56339], [-122.60011, 40.563], [-122.6066, 40.56524], [-122.60982, 40.56687], [-122.61399, 40.56677], [-122.61775, 40.56796], [-122.61776, 40.56795], [-122.61775, 40.56712], [-122.62853, 40.56731], [-122.63613, 40.5675], [-122.63606, 40.57013], [-122.63765, 40.57111], [-122.63824, 40.57138], [-122.63966, 40.57026], [-122.64015, 40.56991], [-122.64112, 40.57007], [-122.64165, 40.5697], [-122.64435, 40.57356], [-122.64651, 40.57476], [-122.64785, 40.57802], [-122.65548, 40.57798], [-122.65538, 40.58507], [-122.65643, 40.58579], [-122.6606, 40.58568], [-122.66179, 40.58667], [-122.66168, 40.58813], [-122.66285, 40.58967], [-122.66435, 40.59017], [-122.66682, 40.5889], [-122.67108, 40.58826], [-122.67316, 40.58787], [-122.67419, 40.57786], [-122.69326, 40.57776], [-122.69315, 40.57803], [-122.69305, 40.57823], [-122.6929, 40.57879], [-122.69286, 40.57929], [-122.69299, 40.57964], [-122.69302, 40.57991], [-122.69291, 40.58052], [-122.69298, 40.58067], [-122.69338, 40.58094], [-122.69392, 40.5812], [-122.69423, 40.58139], [-122.69448, 40.58151], [-122.6952, 40.58174], [-122.69551, 40.58188], [-122.69585, 40.58209], [-122.69623, 40.58252], [-122.69637, 40.58273], [-122.6973, 40.58347], [-122.69754, 40.58369], [-122.69863, 40.58442], [-122.6989, 40.58466], [-122.69957, 40.58512], [-122.69986, 40.58544], [-122.70015, 40.58569], [-122.70029, 40.58591], [-122.70037, 40.58619], [-122.70036, 40.58656], [-122.7004, 40.58685], [-122.70061, 40.5872], [-122.7009, 40.58754], [-122.70097, 40.58767], [-122.7009, 40.5879], [-122.70081, 40.58798], [-122.70055, 40.58818], [-122.70043, 40.58831], [-122.7003, 40.58846], [-122.70007, 40.58885], [-122.69991, 40.5892], [-122.69981, 40.58962], [-122.69978, 40.59011], [-122.70004, 40.59096], [-122.7002, 40.59134], [-122.70065, 40.59189], [-122.70081, 40.59212], [-122.70103, 40.59236], [-122.70125, 40.59251], [-122.70158, 40.5927], [-122.70193, 40.59299], [-122.70201, 40.59336], [-122.702, 40.59366], [-122.70194, 40.594], [-122.70187, 40.59422], [-122.70174, 40.59452], [-122.70147, 40.59498], [-122.70121, 40.59567], [-122.70122, 40.59579], [-122.70131, 40.59595], [-122.7022, 40.59673], [-122.70265, 40.59701], [-122.70294, 40.59714], [-122.70329, 40.59726], [-122.70351, 40.5974], [-122.70351, 40.59751], [-122.70346, 40.59773], [-122.70337, 40.59796], [-122.70332, 40.59818], [-122.70344, 40.59856], [-122.70358, 40.59889], [-122.70371, 40.59906], [-122.70388, 40.59918], [-122.7041, 40.5993], [-122.70438, 40.59943], [-122.70467, 40.59954], [-122.70493, 40.59968], [-122.70509, 40.59981], [-122.70538, 40.60019], [-122.70546, 40.60037], [-122.70551, 40.60056], [-122.70545, 40.60142], [-122.70541, 40.60171], [-122.70516, 40.6026], [-122.70495, 40.60328], [-122.70493, 40.6036], [-122.70499, 40.60392], [-122.70536, 40.60471], [-122.70551, 40.60495], [-122.70566, 40.60514], [-122.70583, 40.60521], [-122.70604, 40.60511], [-122.70622, 40.60506], [-122.70645, 40.60507], [-122.70661, 40.60514], [-122.70676, 40.60527], [-122.70696, 40.60575], [-122.70696, 40.60614], [-122.70689, 40.60677], [-122.70664, 40.60788], [-122.70648, 40.60866], [-122.70638, 40.60897], [-122.70617, 40.6093], [-122.70608, 40.60963], [-122.7061, 40.60975], [-122.70663, 40.61052], [-122.70685, 40.61081], [-122.70751, 40.61152], [-122.70762, 40.61159], [-122.70839, 40.61183], [-122.7087, 40.61191], [-122.70909, 40.61197], [-122.7101, 40.61215], [-122.71032, 40.61228], [-122.7104, 40.61234], [-122.71053, 40.61245], [-122.71066, 40.61261], [-122.71072, 40.61275], [-122.71076, 40.61301], [-122.71085, 40.6137], [-122.71087, 40.61399], [-122.71085, 40.61443], [-122.71095, 40.61508], [-122.71108, 40.61558], [-122.71133, 40.61643]]]} | Open Access 1 | 10486 | Whiskeytown-Shasta-Trinity National Recreation Area | 14303 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/whis/index.htm | Shasta 27 | 42235.009 | Whiskeytown-Shasta-Trinity NRA | 1965 | National Recreation Area 54 | 3 |
14833 | 14833 | 14832 | {"type": "Polygon", "coordinates": [[[-122.49941, 37.62023], [-122.49936, 37.62028], [-122.49928, 37.62031], [-122.49919, 37.62031], [-122.4991, 37.62029], [-122.49903, 37.62025], [-122.49895, 37.62024], [-122.49887, 37.62027], [-122.49878, 37.62027], [-122.49857, 37.62038], [-122.49844, 37.62047], [-122.49827, 37.62051], [-122.49816, 37.62062], [-122.49808, 37.62065], [-122.49791, 37.62067], [-122.49782, 37.62077], [-122.49765, 37.62082], [-122.49707, 37.62106], [-122.49311, 37.62054], [-122.49345, 37.62181], [-122.49158, 37.62173], [-122.49152, 37.62169], [-122.49152, 37.62164], [-122.49153, 37.62163], [-122.49158, 37.62], [-122.49005, 37.61977], [-122.48829, 37.61943], [-122.48748, 37.61945], [-122.48652, 37.61931], [-122.48655, 37.61919], [-122.48639, 37.61901], [-122.48626, 37.61909], [-122.48565, 37.61852], [-122.48565, 37.61832], [-122.48596, 37.61766], [-122.48677, 37.61715], [-122.48652, 37.61621], [-122.49708, 37.61654], [-122.49736, 37.619], [-122.49742, 37.61908], [-122.49745, 37.61915], [-122.49756, 37.61922], [-122.49779, 37.61943], [-122.4979, 37.61951], [-122.49808, 37.6196], [-122.49821, 37.61963], [-122.49834, 37.61969], [-122.49844, 37.61967], [-122.49846, 37.6196], [-122.49851, 37.61958], [-122.4986, 37.61956], [-122.49871, 37.61956], [-122.49873, 37.61952], [-122.49876, 37.61951], [-122.49886, 37.61952], [-122.49889, 37.61954], [-122.49889, 37.61958], [-122.49893, 37.61961], [-122.49895, 37.61966], [-122.49904, 37.61973], [-122.49907, 37.61982], [-122.49913, 37.61986], [-122.49929, 37.61992], [-122.49935, 37.61996], [-122.49938, 37.62003], [-122.49941, 37.62023]]]} | Open Access 1 | 45300 | Mori Point | 14258 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/goga/planyourvisit/mori-point-accessibility.htm | San Mateo 15 | 112.076 | Mori Point | 1972 | National Recreation Area 54 | 3 |
13143 | 13143 | 13142 | {"type": "Polygon", "coordinates": [[[-122.4927, 37.78799], [-122.49205, 37.78796], [-122.49139, 37.78826], [-122.49086, 37.78861], [-122.48984, 37.78946], [-122.48986, 37.78902], [-122.48996, 37.7886], [-122.49008, 37.78858], [-122.49004, 37.78851], [-122.49001, 37.78837], [-122.49005, 37.78836], [-122.49001, 37.78804], [-122.48986, 37.78796], [-122.49, 37.78777], [-122.49017, 37.78759], [-122.49038, 37.78742], [-122.49062, 37.78728], [-122.49091, 37.78716], [-122.49101, 37.78714], [-122.49113, 37.78714], [-122.4912, 37.78709], [-122.49154, 37.78723], [-122.49157, 37.78742], [-122.49166, 37.78741], [-122.49165, 37.78728], [-122.49175, 37.78732], [-122.49177, 37.7878], [-122.49222, 37.78752], [-122.49224, 37.78776], [-122.4927, 37.78799]]]} | Open Access 1 | 35094 | China Beach | 14203 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/goga/planyourvisit/chinabeach.htm | San Francisco 13 | 6.413 | China Beach | 1972 | National Recreation Area 54 | 3 |
13148 | 13148 | 13147 | {"type": "Polygon", "coordinates": [[[-122.48598, 37.7908], [-122.48574, 37.79102], [-122.48541, 37.79147], [-122.48528, 37.79171], [-122.485, 37.79195], [-122.48475, 37.79221], [-122.48454, 37.79252], [-122.48436, 37.79274], [-122.48407, 37.7933], [-122.48386, 37.79365], [-122.48359, 37.79404], [-122.4833, 37.79466], [-122.48352, 37.79473], [-122.48309, 37.79561], [-122.483, 37.7959], [-122.48285, 37.79618], [-122.48267, 37.79681], [-122.48218, 37.79783], [-122.48217, 37.798], [-122.48214, 37.79813], [-122.48209, 37.79823], [-122.48213, 37.79833], [-122.48208, 37.79847], [-122.48204, 37.79851], [-122.48196, 37.79853], [-122.48187, 37.79854], [-122.48183, 37.79857], [-122.48193, 37.79877], [-122.4819, 37.79878], [-122.48179, 37.79869], [-122.48176, 37.79879], [-122.48174, 37.79881], [-122.48173, 37.79885], [-122.4817, 37.79886], [-122.48155, 37.79876], [-122.48155, 37.79879], [-122.48167, 37.79889], [-122.48168, 37.79893], [-122.48162, 37.79895], [-122.48156, 37.79903], [-122.48151, 37.79921], [-122.48138, 37.79937], [-122.48139, 37.79945], [-122.48131, 37.79952], [-122.4812, 37.79956], [-122.4811, 37.79962], [-122.48107, 37.7997], [-122.48106, 37.79982], [-122.48099, 37.79994], [-122.48097, 37.80033], [-122.48076, 37.80044], [-122.48065, 37.80065], [-122.48059, 37.80073], [-122.48038, 37.80109], [-122.4803, 37.80129], [-122.4802, 37.80142], [-122.48018, 37.80156], [-122.48007, 37.80184], [-122.48003, 37.80206], [-122.48004, 37.80223], [-122.4799, 37.8029], [-122.47961, 37.80343], [-122.4795, 37.80357], [-122.47936, 37.80386], [-122.47917, 37.80433], [-122.47915, 37.80448], [-122.47906, 37.80469], [-122.47895, 37.80488], [-122.47881, 37.80529], [-122.47873, 37.80549], [-122.47872, 37.80568], [-122.47869, 37.80596], [-122.47863, 37.80601], [-122.47822, 37.80549], [-122.47987, 37.80125], [-122.48076, 37.79958], [-122.48119, 37.79836], [-122.48155, 37.79679], [-122.48179, 37.79459], [-122.4822, 37.79248], [-122.48288, 37.79043], [-122.48382, 37.78928], [-122.48408, 37.7894], [-122.48426, 37.78941], [-122.48457, 37.78953], [-122.48472, 37.78956], [-122.48481, 37.78967], [-122.48486, 37.78979], [-122.48488, 37.78979], [-122.48489, 37.78973], [-122.485, 37.78985], [-122.48497, 37.78995], [-122.485, 37.79001], [-122.48496, 37.7901], [-122.48495, 37.7902], [-122.48505, 37.79037], [-122.4854, 37.79045], [-122.48598, 37.7908]]]} | Open Access 1 | 35095 | Baker Beach | 14193 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/prsf/planyourvisit/baker-beach.htm | San Francisco 13 | 48.266 | Baker Beach | 1910 | National Recreation Area 54 | 3 |
10598 | 10598 | 10597 | {"type": "Polygon", "coordinates": [[[-122.48467, 37.78753], [-122.48415, 37.78756], [-122.48414, 37.78777], [-122.48395, 37.78803], [-122.48393, 37.78831], [-122.48371, 37.78878], [-122.48382, 37.78928], [-122.48288, 37.79043], [-122.4822, 37.79248], [-122.48179, 37.79459], [-122.48155, 37.79679], [-122.48119, 37.79836], [-122.48076, 37.79958], [-122.47987, 37.80125], [-122.47822, 37.80549], [-122.47863, 37.80601], [-122.47865, 37.80609], [-122.47863, 37.80612], [-122.47866, 37.80617], [-122.47863, 37.80635], [-122.47862, 37.80647], [-122.47858, 37.80664], [-122.47853, 37.80707], [-122.47852, 37.80725], [-122.47849, 37.80731], [-122.4785, 37.80755], [-122.47848, 37.80783], [-122.47841, 37.80809], [-122.47806, 37.80828], [-122.4779, 37.80845], [-122.47789, 37.80853], [-122.47792, 37.80867], [-122.47796, 37.80925], [-122.47792, 37.80978], [-122.47796, 37.81011], [-122.47793, 37.81032], [-122.47798, 37.81054], [-122.47769, 37.81063], [-122.47774, 37.81094], [-122.47728, 37.81102], [-122.47728, 37.81089], [-122.47717, 37.81077], [-122.47736, 37.81066], [-122.47747, 37.81071], [-122.47751, 37.8107], [-122.47755, 37.81062], [-122.47754, 37.81059], [-122.47743, 37.81055], [-122.4774, 37.8102], [-122.47734, 37.81018], [-122.4772, 37.81025], [-122.47717, 37.81021], [-122.47709, 37.80952], [-122.47704, 37.80951], [-122.47699, 37.8091], [-122.47691, 37.80894], [-122.47677, 37.80871], [-122.47665, 37.80856], [-122.47647, 37.80835], [-122.4763, 37.8082], [-122.47562, 37.80865], [-122.47509, 37.80815], [-122.47492, 37.80818], [-122.47476, 37.80817], [-122.47375, 37.80785], [-122.47342, 37.80768], [-122.47307, 37.80738], [-122.47264, 37.80709], [-122.47262, 37.80701], [-122.47236, 37.80701], [-122.47214, 37.80695], [-122.47201, 37.80689], [-122.47145, 37.80655], [-122.47107, 37.80638], [-122.46998, 37.80603], [-122.46986, 37.80603], [-122.46882, 37.80621], [-122.46842, 37.80498], [-122.46824, 37.8047], [-122.46774, 37.80397], [-122.46744, 37.8037], [-122.46719, 37.80359], [-122.46122, 37.80286], [-122.46079, 37.80291], [-122.46046, 37.80307], [-122.46003, 37.80338], [-122.45977, 37.80352], [-122.44846, 37.80496], [-122.4484, 37.80459], [-122.44859, 37.80454], [-122.44882, 37.80444], [-122.44913, 37.80427], [-122.44942, 37.80403], [-122.44964, 37.80375], [-122.44977, 37.80349], [-122.44983, 37.80328], [-122.44986, 37.80305], [-122.44984, 37.80279], [-122.44977, 37.80253], [-122.44964, 37.80227], [-122.44944, 37.80202], [-122.4492, 37.80181], [-122.44889, 37.80161], [-122.44858, 37.80149], [-122.44827, 37.8014], [-122.44789, 37.80136], [-122.44691, 37.79501], [-122.44714, 37.795], [-122.44712, 37.79425], [-122.4468, 37.79424], [-122.44647, 37.79214], [-122.45194, 37.79104], [-122.4521, 37.79218], [-122.45287, 37.79205], [-122.4534, 37.79222], [-122.45597, 37.79153], [-122.45569, 37.7903], [-122.471, 37.78723], [-122.47101, 37.78765], [-122.47455, 37.78695], [-122.47454, 37.78679], [-122.47651, 37.78686], [-122.47675, 37.78685], [-122.47679, 37.7869], [-122.47713, 37.78701], [-122.47728, 37.78703], [-122.47746, 37.78701], [-122.47773, 37.78689], [-122.47796, 37.78685], [-122.47817, 37.78686], [-122.47854, 37.78697], [-122.47871, 37.787], [-122.479, 37.78699], [-122.47935, 37.78701], [-122.47967, 37.78697], [-122.47986, 37.78696], [-122.48004, 37.787], [-122.48023, 37.78706], [-122.4804, 37.78709], [-122.48057, 37.78708], [-122.48076, 37.78702], [-122.48089, 37.78702], [-122.48108, 37.78705], [-122.48118, 37.7871], [-122.48133, 37.78719], [-122.48148, 37.78723], [-122.4816, 37.78721], [-122.48217, 37.78724], [-122.48221, 37.78724], [-122.48237, 37.78709], [-122.48406, 37.78728], [-122.48431, 37.78735], [-122.48464, 37.78738], [-122.48467, 37.78753]]]} | Open Access 1 | 18880 | Presidio | 14267 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/prsf/index.htm | San Francisco 13 | 1314.067 | Presidio | 1910 | National Recreation Area 54 | 3 |
2009 | 2009 | 2008 | {"type": "Polygon", "coordinates": [[[-122.47305, 37.64408], [-122.47256, 37.64407], [-122.47178, 37.64379], [-122.47151, 37.64332], [-122.47133, 37.64306], [-122.47056, 37.64305], [-122.46994, 37.64271], [-122.46923, 37.64265], [-122.46911, 37.6426], [-122.46794, 37.64159], [-122.47021, 37.64033], [-122.47305, 37.64408]]]} | Open Access 1 | 15356 | Sky Ridge | 14293 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | San Mateo 15 | 16.859 | Sky Ridge | 0 | National Recreation Area 54 | 3 | |
13152 | 13152 | 13151 | {"type": "Polygon", "coordinates": [[[-122.47154, 37.80864], [-122.47141, 37.80883], [-122.47093, 37.80872], [-122.4706, 37.8086], [-122.47003, 37.80943], [-122.46999, 37.80945], [-122.46992, 37.80943], [-122.4694, 37.8092], [-122.46939, 37.80917], [-122.46945, 37.80907], [-122.46951, 37.80905], [-122.47005, 37.80928], [-122.47053, 37.80858], [-122.47042, 37.80845], [-122.47023, 37.80835], [-122.47001, 37.8082], [-122.46982, 37.8081], [-122.46959, 37.80795], [-122.4693, 37.80773], [-122.46923, 37.80757], [-122.46911, 37.80737], [-122.46887, 37.80707], [-122.46879, 37.807], [-122.46864, 37.80692], [-122.46831, 37.80682], [-122.46815, 37.80698], [-122.46804, 37.80691], [-122.4682, 37.80675], [-122.46816, 37.8067], [-122.46777, 37.80645], [-122.4672, 37.80601], [-122.467, 37.80591], [-122.46668, 37.8058], [-122.46647, 37.80599], [-122.46606, 37.80642], [-122.46589, 37.80631], [-122.46595, 37.80624], [-122.46605, 37.8063], [-122.46607, 37.80629], [-122.46613, 37.80632], [-122.46664, 37.8058], [-122.46664, 37.80579], [-122.46608, 37.80558], [-122.4659, 37.80557], [-122.46565, 37.80549], [-122.46546, 37.80539], [-122.46423, 37.805], [-122.46399, 37.80494], [-122.46358, 37.80488], [-122.46327, 37.80489], [-122.46295, 37.80492], [-122.46243, 37.80501], [-122.46221, 37.80502], [-122.46203, 37.80496], [-122.4619, 37.80493], [-122.4616, 37.80496], [-122.46101, 37.80509], [-122.45977, 37.80525], [-122.45912, 37.8054], [-122.45834, 37.80549], [-122.45804, 37.80556], [-122.45764, 37.80569], [-122.45736, 37.80576], [-122.45671, 37.80585], [-122.45629, 37.80592], [-122.45567, 37.80608], [-122.45448, 37.80647], [-122.45435, 37.80648], [-122.45431, 37.80646], [-122.45429, 37.80638], [-122.45409, 37.80636], [-122.45382, 37.80629], [-122.4533, 37.80626], [-122.45244, 37.80627], [-122.45165, 37.80635], [-122.45046, 37.80665], [-122.44991, 37.80672], [-122.44972, 37.80672], [-122.44963, 37.80673], [-122.44948, 37.8068], [-122.4493, 37.80684], [-122.44905, 37.80682], [-122.44901, 37.80678], [-122.44889, 37.80673], [-122.44873, 37.8067], [-122.44846, 37.80496], [-122.45977, 37.80352], [-122.46003, 37.80338], [-122.46046, 37.80307], [-122.46079, 37.80291], [-122.46122, 37.80286], [-122.46719, 37.80359], [-122.46744, 37.8037], [-122.46774, 37.80396], [-122.46824, 37.8047], [-122.46842, 37.80498], [-122.46882, 37.8062], [-122.46986, 37.80603], [-122.46987, 37.80615], [-122.4699, 37.80627], [-122.46997, 37.80641], [-122.47004, 37.80651], [-122.47019, 37.80666], [-122.47056, 37.80692], [-122.47076, 37.80711], [-122.47086, 37.80724], [-122.47093, 37.80743], [-122.47099, 37.80764], [-122.47107, 37.80803], [-122.47118, 37.80827], [-122.47106, 37.80841], [-122.47154, 37.80864]]]} | Open Access 1 | 35097 | Crissy Field | 14207 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/goga/planyourvisit/crissy-field-access.htm | San Francisco 13 | 105.424 | Crissy Field | 1910 | National Recreation Area 54 | 3 |
3795 | 3795 | 3794 | {"type": "Polygon", "coordinates": [[[-122.43256, 37.8083], [-122.43205, 37.80836], [-122.43177, 37.80703], [-122.43144, 37.80708], [-122.43171, 37.80841], [-122.43119, 37.80847], [-122.43092, 37.80713], [-122.43059, 37.80718], [-122.43085, 37.80851], [-122.42933, 37.8087], [-122.42924, 37.80829], [-122.42743, 37.80852], [-122.42742, 37.80854], [-122.42754, 37.80864], [-122.42801, 37.80857], [-122.42804, 37.80873], [-122.42751, 37.80881], [-122.42749, 37.80873], [-122.42734, 37.80875], [-122.42733, 37.80872], [-122.42747, 37.80869], [-122.42731, 37.80854], [-122.42683, 37.80859], [-122.4267, 37.80795], [-122.4257, 37.80598], [-122.42534, 37.80421], [-122.43159, 37.80342], [-122.43256, 37.8083]]]} | Open Access 1 | 35092 | Fort Mason | 14215 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/goga/planyourvisit/fort-mason.htm | San Francisco 13 | 67.901 | Fort Mason | 1972 | National Recreation Area 54 | 3 |
12701 | 12701 | 12700 | {"type": "Polygon", "coordinates": [[[-122.42467, 37.82831], [-122.42422, 37.82828], [-122.42384, 37.82818], [-122.42355, 37.82805], [-122.42275, 37.82756], [-122.42256, 37.82751], [-122.42224, 37.82746], [-122.42212, 37.82741], [-122.42194, 37.82732], [-122.42183, 37.82729], [-122.42169, 37.82729], [-122.42156, 37.82731], [-122.42141, 37.82736], [-122.42135, 37.82737], [-122.42126, 37.82735], [-122.4212, 37.82732], [-122.42088, 37.82706], [-122.42084, 37.82701], [-122.42081, 37.82694], [-122.42086, 37.82678], [-122.42084, 37.82668], [-122.42075, 37.8266], [-122.42058, 37.82653], [-122.42045, 37.82642], [-122.42033, 37.82625], [-122.42029, 37.82608], [-122.42029, 37.82597], [-122.42033, 37.82583], [-122.42044, 37.82568], [-122.42073, 37.82512], [-122.42081, 37.82505], [-122.42094, 37.82498], [-122.42106, 37.82494], [-122.4212, 37.82492], [-122.42138, 37.82493], [-122.42155, 37.82498], [-122.42185, 37.82503], [-122.42215, 37.8251], [-122.42236, 37.82518], [-122.42262, 37.82531], [-122.42295, 37.82551], [-122.42315, 37.82559], [-122.42338, 37.82565], [-122.42351, 37.82566], [-122.42364, 37.82564], [-122.42381, 37.82566], [-122.42397, 37.82572], [-122.42409, 37.82579], [-122.42417, 37.82588], [-122.42425, 37.826], [-122.42427, 37.82611], [-122.42428, 37.82634], [-122.42432, 37.82645], [-122.42439, 37.82654], [-122.42446, 37.82661], [-122.42468, 37.82674], [-122.42496, 37.82702], [-122.42513, 37.82723], [-122.42525, 37.82734], [-122.42543, 37.82747], [-122.4257, 37.82763], [-122.42578, 37.82772], [-122.42582, 37.82782], [-122.42583, 37.82794], [-122.4258, 37.82802], [-122.42574, 37.82812], [-122.42565, 37.8282], [-122.42542, 37.82828], [-122.42517, 37.82832], [-122.42492, 37.82833], [-122.42467, 37.82831]]]} | Open Access 1 | 29702 | Alcatraz Island | 14190 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/alca/index.htm | San Francisco 13 | 24.914 | Alcatraz Island | 0 | National Recreation Area 54 | 3 |
6322 | 6322 | 6321 | {"type": "Polygon", "coordinates": [[[-119.0027, 34.08163], [-118.99835, 34.08165], [-118.99821, 34.07797], [-119.00256, 34.07796], [-119.0027, 34.08163]]]} | Open Access 1 | 1851 | Whelan | 14301 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Ventura 8 | 40.428 | Whelan | 0 | National Recreation Area 54 | 3 | |
6060 | 6060 | 6059 | {"type": "Polygon", "coordinates": [[[-118.97657, 34.10355], [-118.97656, 34.10714], [-118.96776, 34.10715], [-118.96774, 34.10717], [-118.96769, 34.11073], [-118.95683, 34.11074], [-118.95688, 34.10716], [-118.9634, 34.10715], [-118.96346, 34.10358], [-118.97657, 34.10355]]]} | Open Access 1 | 768 | Serrano Valley | 14291 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Ventura 8 | 217.477 | Serrano Valley | 0 | National Recreation Area 54 | 3 | |
10625 | 10625 | 10624 | {"type": "Polygon", "coordinates": [[[-118.96951, 34.14747], [-118.96763, 34.15622], [-118.96743, 34.15724], [-118.96528, 34.157], [-118.96311, 34.15657], [-118.96289, 34.15656], [-118.9626, 34.15659], [-118.96231, 34.15668], [-118.9614, 34.15707], [-118.96119, 34.15718], [-118.961, 34.15731], [-118.96088, 34.15742], [-118.96076, 34.15754], [-118.96061, 34.15774], [-118.96049, 34.15787], [-118.96035, 34.15797], [-118.96019, 34.15806], [-118.95828, 34.15873], [-118.95766, 34.159], [-118.95754, 34.15902], [-118.95742, 34.15903], [-118.95731, 34.15901], [-118.95715, 34.15895], [-118.95677, 34.15869], [-118.95512, 34.15645], [-118.95124, 34.15444], [-118.94685, 34.15418], [-118.94266, 34.15488], [-118.93998, 34.15573], [-118.9387, 34.15593], [-118.93875, 34.14302], [-118.95834, 34.14465], [-118.96429, 34.14616], [-118.96331, 34.14751], [-118.96332, 34.14753], [-118.96951, 34.14747]]]} | Open Access 1 | 18934 | Rancho Sierra Vista/ Satwiwa | 29291 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/rsvsatwiwa.htm | Ventura 8 | 856.328 | Rancho Sierra Vista/ Satwiwa | 0 | National Recreation Area 54 | 3 |
589 | 589 | 588 | {"type": "Polygon", "coordinates": [[[-118.95475, 34.05983], [-118.95458, 34.07447], [-118.94543, 34.07444], [-118.94389, 34.07442], [-118.94103, 34.07443], [-118.94193, 34.06723], [-118.9462, 34.06719], [-118.94636, 34.06005], [-118.95475, 34.05983]]]} | Open Access 1 | 2002 | Yellowhill | 14304 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Ventura 8 | 395.74 | Yellowhill | 0 | National Recreation Area 54 | 3 | |
537 | 537 | 536 | {"type": "Polygon", "coordinates": [[[-118.93025, 34.14501], [-118.92997, 34.14499], [-118.92993, 34.14464], [-118.92975, 34.14379], [-118.92957, 34.14348], [-118.92948, 34.14328], [-118.92886, 34.14266], [-118.92864, 34.14235], [-118.92848, 34.14201], [-118.9283, 34.14173], [-118.92811, 34.14159], [-118.92784, 34.14148], [-118.9272, 34.14139], [-118.92693, 34.14128], [-118.92682, 34.1412], [-118.92674, 34.14104], [-118.9261, 34.14091], [-118.92611, 34.14077], [-118.92675, 34.14087], [-118.92687, 34.14075], [-118.92704, 34.14075], [-118.92725, 34.14084], [-118.92746, 34.14096], [-118.92768, 34.14103], [-118.92786, 34.14092], [-118.92801, 34.14071], [-118.92812, 34.14063], [-118.92829, 34.14063], [-118.92846, 34.14068], [-118.92868, 34.14092], [-118.92874, 34.14116], [-118.92841, 34.14085], [-118.92825, 34.14077], [-118.92811, 34.1408], [-118.92804, 34.14095], [-118.92794, 34.14107], [-118.92778, 34.14115], [-118.92765, 34.14115], [-118.92743, 34.14108], [-118.92726, 34.141], [-118.92709, 34.1409], [-118.92693, 34.14089], [-118.92688, 34.14102], [-118.92701, 34.14117], [-118.92717, 34.14123], [-118.92802, 34.14142], [-118.92829, 34.14151], [-118.92846, 34.14169], [-118.92862, 34.14194], [-118.92882, 34.14232], [-118.92903, 34.14264], [-118.92965, 34.14322], [-118.92974, 34.14342], [-118.92986, 34.14361], [-118.9301, 34.14436], [-118.93025, 34.14501]]]} | Open Access 1 | 2651 | Canilla Corp. | 14196 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Ventura 8 | 3.474 | Canilla Corp. | 0 | National Recreation Area 54 | 3 | |
2756 | 2756 | 2755 | {"type": "Polygon", "coordinates": [[[-118.87643, 34.08195], [-118.87642, 34.08913], [-118.87501, 34.08912], [-118.87206, 34.08915], [-118.86766, 34.08914], [-118.86758, 34.08551], [-118.86766, 34.08185], [-118.87643, 34.08195]]]} | Open Access 1 | 18445 | Decker Canyon | 14211 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 161.245 | Decker Canyon | 0 | National Recreation Area 54 | 3 | |
8244 | 8244 | 8243 | {"type": "Polygon", "coordinates": [[[-118.8237, 34.10011], [-118.82369, 34.10371], [-118.81543, 34.10383], [-118.81292, 34.10384], [-118.81292, 34.10366], [-118.81287, 34.10342], [-118.81279, 34.10321], [-118.81267, 34.10301], [-118.8121, 34.10238], [-118.81208, 34.10237], [-118.81116, 34.10136], [-118.81106, 34.10122], [-118.81094, 34.101], [-118.8109, 34.10078], [-118.81089, 34.10067], [-118.8109, 34.09811], [-118.81098, 34.09788], [-118.81105, 34.09773], [-118.81115, 34.09759], [-118.81133, 34.0974], [-118.81147, 34.0973], [-118.81263, 34.09663], [-118.81273, 34.0966], [-118.81393, 34.09669], [-118.81419, 34.09669], [-118.81462, 34.09662], [-118.81503, 34.0965], [-118.81597, 34.09611], [-118.81936, 34.09507], [-118.81938, 34.10016], [-118.8237, 34.10011]]]} | Open Access 1 | 12587 | Rocky Oaks | 29304 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/rockyoaks.htm | Los Angeles 6 | 192.465 | Rocky Oaks | 0 | National Recreation Area 54 | 3 |
8294 | 8294 | 8293 | {"type": "Polygon", "coordinates": [[[-118.79335, 34.09855], [-118.79333, 34.10035], [-118.78907, 34.10036], [-118.78889, 34.10038], [-118.78887, 34.10212], [-118.79161, 34.10212], [-118.79159, 34.1022], [-118.79159, 34.10229], [-118.79163, 34.10239], [-118.79171, 34.10251], [-118.79173, 34.10254], [-118.79172, 34.1026], [-118.79169, 34.10262], [-118.7915, 34.10274], [-118.79141, 34.10281], [-118.79134, 34.10292], [-118.79133, 34.103], [-118.79135, 34.10313], [-118.79156, 34.10362], [-118.79163, 34.10372], [-118.79176, 34.1038], [-118.79187, 34.10384], [-118.79199, 34.10385], [-118.79215, 34.1038], [-118.79228, 34.1037], [-118.79234, 34.10356], [-118.79234, 34.10347], [-118.79227, 34.10327], [-118.79228, 34.10323], [-118.79233, 34.1032], [-118.79236, 34.1032], [-118.79274, 34.1033], [-118.79287, 34.1033], [-118.79294, 34.10328], [-118.79303, 34.10323], [-118.7931, 34.10315], [-118.79312, 34.10311], [-118.79317, 34.10286], [-118.79324, 34.10281], [-118.79327, 34.10281], [-118.79325, 34.10389], [-118.78034, 34.10396], [-118.78032, 34.09328], [-118.78903, 34.09327], [-118.78896, 34.09681], [-118.79119, 34.09681], [-118.79117, 34.09856], [-118.79335, 34.09855]]]} | Open Access 1 | 12708 | Hennesy Property | 14225 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 275.914 | Hennesy Property | 0 | National Recreation Area 54 | 3 | |
14176 | 14176 | 14175 | {"type": "Polygon", "coordinates": [[[-118.77607, 34.1074], [-118.77188, 34.10743], [-118.77186, 34.10401], [-118.77604, 34.10399], [-118.77607, 34.1074]]]} | Open Access 1 | 43097 | Malibu Creek Properties | 14251 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 36.124 | Malibu Creek Properties | 0 | National Recreation Area 54 | 3 | |
8305 | 8305 | 8304 | {"type": "Polygon", "coordinates": [[[-118.77471, 34.06273], [-118.7747, 34.06488], [-118.77445, 34.06486], [-118.77447, 34.06468], [-118.77443, 34.0646], [-118.77436, 34.06455], [-118.77319, 34.06472], [-118.77312, 34.06476], [-118.77306, 34.06483], [-118.77302, 34.0649], [-118.77301, 34.06505], [-118.77293, 34.06506], [-118.77242, 34.06439], [-118.77233, 34.06435], [-118.77224, 34.06435], [-118.77199, 34.06442], [-118.77192, 34.06441], [-118.77186, 34.06437], [-118.77183, 34.06424], [-118.77177, 34.06418], [-118.77149, 34.06407], [-118.77142, 34.06401], [-118.77141, 34.06391], [-118.77168, 34.06353], [-118.7717, 34.06346], [-118.77171, 34.06334], [-118.77166, 34.0632], [-118.77133, 34.0626], [-118.77132, 34.06224], [-118.7713, 34.06224], [-118.7712, 34.06249], [-118.77144, 34.06331], [-118.77142, 34.06333], [-118.77135, 34.06332], [-118.77109, 34.06287], [-118.77101, 34.06282], [-118.77093, 34.06281], [-118.77087, 34.06283], [-118.77053, 34.06302], [-118.77043, 34.06312], [-118.77033, 34.06328], [-118.77027, 34.06335], [-118.77025, 34.06184], [-118.77242, 34.06182], [-118.77243, 34.06271], [-118.77471, 34.06273]]]} | Open Access 1 | 12728 | Upper Solstice Canyon | 14300 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/solsticecanyon.htm | Los Angeles 6 | 20.51 | Upper Solstice Canyon | 0 | National Recreation Area 54 | 3 |
10389 | 10389 | 10388 | {"type": "Polygon", "coordinates": [[[-118.76119, 34.19892], [-118.76116, 34.21247], [-118.75992, 34.2125], [-118.75502, 34.20902], [-118.74374, 34.20107], [-118.73683, 34.19615], [-118.73664, 34.19545], [-118.7359, 34.19539], [-118.73556, 34.19519], [-118.73533, 34.19472], [-118.73571, 34.19364], [-118.7348, 34.19327], [-118.73415, 34.19222], [-118.73403, 34.18887], [-118.73481, 34.18829], [-118.73513, 34.18809], [-118.73524, 34.18738], [-118.73559, 34.18635], [-118.73519, 34.18473], [-118.73512, 34.18418], [-118.73552, 34.18375], [-118.73556, 34.18263], [-118.73559, 34.18232], [-118.73535, 34.18219], [-118.73399, 34.18169], [-118.73281, 34.1814], [-118.73083, 34.17923], [-118.72838, 34.17739], [-118.7283, 34.17549], [-118.72811, 34.17317], [-118.72822, 34.17173], [-118.72834, 34.16793], [-118.74541, 34.16802], [-118.74533, 34.1689], [-118.74566, 34.1703], [-118.74591, 34.17109], [-118.74694, 34.17346], [-118.74669, 34.17648], [-118.74831, 34.17813], [-118.74851, 34.18082], [-118.74845, 34.18264], [-118.74928, 34.18459], [-118.75077, 34.18893], [-118.75117, 34.1903], [-118.75472, 34.19703], [-118.76119, 34.19892]]]} | Open Access 1 | 18360 | Palo Comado Canyon | 14260 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/samo/planyourvisit/cheeseboropalocomado.htm | Ventura 8 | 1698.51 | Palo Comado Canyon | 0 | National Recreation Area 54 | 3 |
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]);