units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where YR_EST = 1948
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5800 | 5800 | 5799 | {"type": "Polygon", "coordinates": [[[-122.2403, 37.47151], [-122.24004, 37.47181], [-122.24028, 37.47209], [-122.23817, 37.47371], [-122.23757, 37.47321], [-122.23697, 37.47352], [-122.23666, 37.47333], [-122.23611, 37.47364], [-122.23547, 37.47309], [-122.23574, 37.47276], [-122.23467, 37.47184], [-122.23503, 37.47158], [-122.23546, 37.47184], [-122.23776, 37.47011], [-122.23849, 37.47067], [-122.23953, 37.46994], [-122.23989, 37.47018], [-122.24025, 37.47086], [-122.24002, 37.47123], [-122.2403, 37.47151]]]} | Open Access 1 | 69 | Red Morton Community Park | 24226 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 30.176 | Red Morton Community Park | 1948 | Local Park 2 | 4 | |
7096 | 7096 | 7095 | {"type": "MultiPolygon", "coordinates": [[[[-118.45649, 33.96106], [-118.4539, 33.96225], [-118.45386, 33.96218], [-118.45387, 33.96216], [-118.45341, 33.96151], [-118.45334, 33.96153], [-118.45045, 33.95737], [-118.45047, 33.95734], [-118.44895, 33.95484], [-118.449, 33.9548], [-118.44838, 33.95368], [-118.44808, 33.9538], [-118.44804, 33.95374], [-118.448, 33.95375], [-118.44754, 33.95303], [-118.44749, 33.95304], [-118.44736, 33.95271], [-118.44722, 33.95244], [-118.44704, 33.95251], [-118.44289, 33.9455], [-118.44281, 33.94549], [-118.44162, 33.94339], [-118.43925, 33.93909], [-118.43838, 33.93743], [-118.43516, 33.931], [-118.4348, 33.93032], [-118.43426, 33.92916], [-118.43381, 33.92809], [-118.42773, 33.91632], [-118.42962, 33.91633], [-118.42973, 33.91659], [-118.42999, 33.91685], [-118.43044, 33.91711], [-118.4313, 33.91921], [-118.43228, 33.92105], [-118.43304, 33.9221], [-118.43452, 33.92501], [-118.43532, 33.92696], [-118.43556, 33.92749], [-118.43596, 33.92826], [-118.43648, 33.92933], [-118.43669, 33.92984], [-118.43695, 33.93038], [-118.4377, 33.93169], [-118.43814, 33.93271], [-118.43825, 33.93303], [-118.43856, 33.9337], [-118.43878, 33.93406], [-118.43935, 33.93521], [-118.43954, 33.93568], [-118.43975, 33.9361], [-118.4402, 33.93693], [-118.44039, 33.93724], [-118.44084, 33.93823], [-118.44155, 33.9395], [-118.44195, 33.94017], [-118.44217, 33.94043], [-118.44232, 33.94051], [-118.44263, 33.94044], [-118.44296, 33.94034], [-118.44308, 33.94069], [-118.4432, 33.9409], [-118.44334, 33.94121], [-118.44367, 33.9417], [-118.44376, 33.94192], [-118.44381, 33.94211], [-118.44396, 33.94242], [-118.44416, 33.94266], [-118.44456, 33.94334], [-118.44541, 33.94489], [-118.44554, 33.94511], [-118.4458, 33.94546], [-118.44669, 33.947], [-118.44707, 33.94754], [-118.44738, 33.94819], [-118.44801, 33.94931], [-118.44839, 33.94989], [-118.44869, 33.95022], [-118.44873, 33.95065], [-118.44883, 33.95089], [-118.44923, 33.9516], [-118.44935, 33.95184], [-118.45076, 33.95404], [-118.451, 33.95433], [-118.45164, 33.95539], [-118.45195, 33.95585], [-118.4524, 33.95642], [-118.4523, 33.95654], [-118.45272, 33.9573], [-118.4533, 33.95802], [-118.45372, 33.95875], [-118.4544, 33.95934], [-118.4548, 33.95974], [-118.45514, 33.95998], [-118.45547, 33.9603], [-118.45582, 33.96055], [-118.45613, 33.96073], [-118.45649, 33.96106]]], [[[-118.45189, 33.95952], [-118.45155, 33.95965], [-118.45148, 33.95971], [-118.45127, 33.95915], [-118.45156, 33.95904], [-118.45189, 33.95952]]]]} | Open Access 1 | 6136 | Dockweiler State Beach | 30635 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | http://www.parks.ca.gov/?page_id=617 | Los Angeles 6 | 279.238 | Dockweiler SB | 1948 | None 580 | |
10530 | 10530 | 10529 | {"type": "Polygon", "coordinates": [[[-120.67131, 34.90254], [-120.65299, 34.90277], [-120.64528, 34.90274], [-120.64528, 34.90009], [-120.64412, 34.90026], [-120.64411, 34.89945], [-120.64356, 34.89941], [-120.6419, 34.89213], [-120.64256, 34.8931], [-120.64449, 34.8983], [-120.64849, 34.90111], [-120.653, 34.90106], [-120.66639, 34.901], [-120.67103, 34.90205], [-120.67131, 34.90254]]]} | Open Access 1 | 18734 | Point Sal State Beach | 1693 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=605 | Santa Barbara 7 | 126.988 | Point Sal SB | 1948 | State Park 15 | 4 |
16436 | 16436 | 16435 | {"type": "MultiPolygon", "coordinates": [[[[-118.51739, 34.02521], [-118.51653, 34.02589], [-118.51439, 34.02481], [-118.51406, 34.02525], [-118.5134, 34.02491], [-118.51238, 34.02435], [-118.51199, 34.02412], [-118.51237, 34.0237], [-118.51161, 34.0232], [-118.5112, 34.0236], [-118.51097, 34.02344], [-118.51137, 34.02304], [-118.50904, 34.02123], [-118.50859, 34.02159], [-118.50852, 34.02154], [-118.50853, 34.0215], [-118.50769, 34.02085], [-118.50809, 34.02048], [-118.50677, 34.01947], [-118.50634, 34.01983], [-118.50632, 34.01982], [-118.50673, 34.01945], [-118.50659, 34.01933], [-118.50617, 34.0197], [-118.50581, 34.01942], [-118.50622, 34.01905], [-118.50587, 34.01877], [-118.50545, 34.01913], [-118.50524, 34.01897], [-118.50565, 34.0186], [-118.50523, 34.01825], [-118.5048, 34.01862], [-118.50458, 34.01846], [-118.50501, 34.01807], [-118.50473, 34.01785], [-118.5043, 34.01822], [-118.50403, 34.01802], [-118.50448, 34.01765], [-118.50435, 34.01754], [-118.50388, 34.01791], [-118.50193, 34.01637], [-118.50222, 34.01612], [-118.50373, 34.01741], [-118.50378, 34.01738], [-118.50123, 34.01521], [-118.50097, 34.01506], [-118.49608, 34.0106], [-118.49497, 34.00952], [-118.49503, 34.00947], [-118.49498, 34.00936], [-118.4947, 34.0091], [-118.49465, 34.00908], [-118.49457, 34.00914], [-118.49188, 34.00657], [-118.49169, 34.00641], [-118.49144, 34.00614], [-118.49146, 34.00611], [-118.49135, 34.006], [-118.49133, 34.006], [-118.48736, 34.00198], [-118.48698, 34.00157], [-118.48726, 34.0014], [-118.48792, 34.00211], [-118.48814, 34.00196], [-118.48693, 34.00069], [-118.48689, 34.0007], [-118.48681, 34.00062], [-118.48676, 34.00061], [-118.48666, 34.00053], [-118.48649, 34.00059], [-118.48639, 34.00049], [-118.48652, 34.00037], [-118.48642, 34.00027], [-118.48646, 34.00024], [-118.48635, 34.00013], [-118.48638, 34.0001], [-118.48629, 33.99999], [-118.48636, 33.99995], [-118.48622, 33.99979], [-118.48628, 33.99974], [-118.4861, 33.99955], [-118.48549, 33.99996], [-118.48409, 33.99847], [-118.48355, 33.99794], [-118.48411, 33.99757], [-118.48411, 33.99755], [-118.48402, 33.99748], [-118.48387, 33.99748], [-118.48347, 33.99773], [-118.48336, 33.99775], [-118.48265, 33.99704], [-118.48266, 33.99682], [-118.48261, 33.99671], [-118.48254, 33.99663], [-118.48245, 33.99655], [-118.48212, 33.99647], [-118.48193, 33.99627], [-118.482, 33.99621], [-118.48163, 33.99581], [-118.48214, 33.99547], [-118.48257, 33.99589], [-118.48352, 33.99534], [-118.48429, 33.99629], [-118.48542, 33.99756], [-118.48626, 33.9987], [-118.48672, 33.99921], [-118.48679, 33.99935], [-118.48711, 33.99973], [-118.48732, 33.99988], [-118.48764, 34.00019], [-118.48802, 34.00047], [-118.48827, 34.00069], [-118.48869, 34.00121], [-118.48893, 34.00156], [-118.48981, 34.00261], [-118.49033, 34.00315], [-118.49117, 34.00405], [-118.49219, 34.00526], [-118.49346, 34.00642], [-118.49466, 34.00733], [-118.49572, 34.00794], [-118.49658, 34.00837], [-118.49746, 34.00864], [-118.49796, 34.00895], [-118.49851, 34.00949], [-118.49904, 34.0098], [-118.49966, 34.00998], [-118.50024, 34.0104], [-118.501, 34.01129], [-118.50147, 34.01199], [-118.50289, 34.01419], [-118.50413, 34.01521], [-118.50517, 34.0161], [-118.50641, 34.0172], [-118.50874, 34.01906], [-118.50938, 34.01951], [-118.51008, 34.02018], [-118.51093, 34.02084], [-118.51237, 34.02183], [-118.51313, 34.02238], [-118.51402, 34.02295], [-118.51468, 34.0234], [-118.51565, 34.02398], [-118.51729, 34.02516], [-118.51739, 34.02521]]], [[[-118.49294, 34.00767], [-118.49265, 34.00791], [-118.49195, 34.00725], [-118.49225, 34.00701], [-118.49294, 34.00767]]], [[[-118.49444, 34.0091], [-118.49414, 34.00934], [-118.49379, 34.00901], [-118.49409, 34.00877], [-118.49444, 34.0091]]], [[[-118.49478, 34.00943], [-118.49449, 34.00967], [-118.49432, 34.0095], [-118.49461, 34.00926], [-118.49478, 34.00943]]], [[[-118.49544, 34.01006], [-118.49512, 34.01031], [-118.49465, 34.00986], [-118.49496, 34.0096], [-118.49544, 34.01006]]], [[[-118.49751, 34.01198], [-118.49725, 34.01217], [-118.497, 34.01196], [-118.49725, 34.01176], [-118.49751, 34.01198]]], [[[-118.49825, 34.01266], [-118.49801, 34.01286], [-118.4974, 34.01231], [-118.49766, 34.01212], [-118.49825, 34.01266]]], [[[-118.50218, 34.01609], [-118.50188, 34.01633], [-118.50134, 34.0159], [-118.50043, 34.01511], [-118.5007, 34.01489], [-118.50095, 34.01512], [-118.50119, 34.01525], [-118.50218, 34.01609]]]]} | Open Access 1 | 6337 | Santa Monica State Beach | 1737 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://www.smgov.net/portals/beach/ | Los Angeles 6 | 204.076 | Santa Monica SB | 1948 | None 1402 | |
16440 | 16440 | 16439 | {"type": "MultiPolygon", "coordinates": [[[[-119.27128, 34.2566], [-119.27103, 34.25667], [-119.27081, 34.25615], [-119.27105, 34.25608], [-119.27128, 34.2566]]], [[[-119.2715, 34.25714], [-119.27126, 34.25721], [-119.27104, 34.2567], [-119.27129, 34.25663], [-119.2715, 34.25714]]], [[[-119.29055, 34.27536], [-119.2901, 34.27622], [-119.28912, 34.2759], [-119.28859, 34.27564], [-119.28858, 34.27558], [-119.28627, 34.27419], [-119.28558, 34.27375], [-119.28554, 34.27375], [-119.28489, 34.27329], [-119.28498, 34.27321], [-119.28498, 34.27319], [-119.28397, 34.27247], [-119.28346, 34.27218], [-119.28293, 34.27195], [-119.28253, 34.27182], [-119.28219, 34.27173], [-119.28176, 34.27165], [-119.28141, 34.27161], [-119.28079, 34.27159], [-119.27945, 34.27165], [-119.27878, 34.27165], [-119.27796, 34.27159], [-119.27715, 34.27146], [-119.27662, 34.27134], [-119.27623, 34.27123], [-119.27585, 34.2711], [-119.27536, 34.2709], [-119.27488, 34.27067], [-119.27454, 34.27048], [-119.27427, 34.2703], [-119.274, 34.27007], [-119.27383, 34.26988], [-119.27367, 34.26969], [-119.27855, 34.26723], [-119.2762, 34.26469], [-119.27594, 34.26437], [-119.27469, 34.26266], [-119.2734, 34.26073], [-119.27197, 34.25814], [-119.27107, 34.25605], [-119.27121, 34.25601], [-119.27208, 34.25792], [-119.27289, 34.25768], [-119.27295, 34.25772], [-119.27289, 34.25777], [-119.27214, 34.25801], [-119.27211, 34.25816], [-119.27248, 34.25886], [-119.27306, 34.25981], [-119.27332, 34.26006], [-119.2739, 34.2611], [-119.274, 34.26119], [-119.2741, 34.26119], [-119.27428, 34.26115], [-119.27469, 34.26097], [-119.27472, 34.26102], [-119.27471, 34.26105], [-119.27415, 34.26129], [-119.27408, 34.26139], [-119.27414, 34.2615], [-119.2748, 34.26242], [-119.27538, 34.26332], [-119.2756, 34.2637], [-119.27581, 34.26394], [-119.27599, 34.26396], [-119.27657, 34.26371], [-119.27663, 34.26376], [-119.27663, 34.2638], [-119.27623, 34.26406], [-119.27672, 34.26476], [-119.27721, 34.26536], [-119.27781, 34.26589], [-119.27851, 34.26665], [-119.27907, 34.26731], [-119.27995, 34.26821], [-119.2817, 34.26994], [-119.28237, 34.27051], [-119.28275, 34.27073], [-119.28324, 34.27036], [-119.28331, 34.27034], [-119.2833, 34.27039], [-119.2831, 34.27057], [-119.28336, 34.27091], [-119.28522, 34.27248], [-119.28571, 34.27285], [-119.28669, 34.27348], [-119.28782, 34.27417], [-119.28871, 34.27462], [-119.28928, 34.27486], [-119.28978, 34.2751], [-119.29055, 34.27536]]], [[[-119.27173, 34.25767], [-119.27148, 34.25774], [-119.27127, 34.25724], [-119.27152, 34.25716], [-119.27173, 34.25767]]], [[[-119.27196, 34.25819], [-119.27172, 34.25828], [-119.27149, 34.25777], [-119.27174, 34.2577], [-119.27196, 34.25819]]], [[[-119.27219, 34.25861], [-119.27195, 34.2587], [-119.27173, 34.2583], [-119.27197, 34.25821], [-119.27219, 34.25861]]], [[[-119.27248, 34.25913], [-119.27224, 34.25923], [-119.27197, 34.25873], [-119.2722, 34.25863], [-119.27248, 34.25913]]], [[[-119.27277, 34.25965], [-119.27253, 34.25974], [-119.27226, 34.25925], [-119.27249, 34.25916], [-119.27277, 34.25965]]], [[[-119.27305, 34.26016], [-119.27281, 34.26025], [-119.27254, 34.25977], [-119.27278, 34.25967], [-119.27305, 34.26016]]], [[[-119.27334, 34.26068], [-119.2731, 34.26077], [-119.27283, 34.26028], [-119.27306, 34.26019], [-119.27334, 34.26068]]], [[[-119.27363, 34.26113], [-119.2734, 34.26123], [-119.27311, 34.2608], [-119.27335, 34.26071], [-119.27363, 34.26113]]], [[[-119.27394, 34.26159], [-119.27371, 34.2617], [-119.27341, 34.26126], [-119.27364, 34.26115], [-119.27394, 34.26159]]], [[[-119.27424, 34.26205], [-119.27401, 34.26216], [-119.27372, 34.26172], [-119.27395, 34.26162], [-119.27424, 34.26205]]], [[[-119.27509, 34.26326], [-119.27487, 34.26338], [-119.27444, 34.2628], [-119.27403, 34.26218], [-119.27426, 34.26207], [-119.27466, 34.26267], [-119.27509, 34.26326]]], [[[-119.27541, 34.2637], [-119.27519, 34.26381], [-119.27488, 34.2634], [-119.27511, 34.26329], [-119.27541, 34.2637]]], [[[-119.27574, 34.26414], [-119.27551, 34.26426], [-119.2752, 34.26384], [-119.27543, 34.26372], [-119.27574, 34.26414]]], [[[-119.27608, 34.2646], [-119.27586, 34.26472], [-119.27553, 34.26428], [-119.27576, 34.26417], [-119.27608, 34.2646]]], [[[-119.27645, 34.26502], [-119.27624, 34.26514], [-119.27588, 34.26474], [-119.2761, 34.26462], [-119.27645, 34.26502]]], [[[-119.27684, 34.26543], [-119.27662, 34.26556], [-119.27626, 34.26517], [-119.27647, 34.26504], [-119.27684, 34.26543]]], [[[-119.27696, 34.26556], [-119.27675, 34.2657], [-119.27664, 34.26558], [-119.27686, 34.26546], [-119.27696, 34.26556]]], [[[-119.27724, 34.26586], [-119.27703, 34.26599], [-119.27684, 34.26579], [-119.27704, 34.26565], [-119.27724, 34.26586]]], [[[-119.27762, 34.26627], [-119.27741, 34.2664], [-119.27705, 34.26601], [-119.27726, 34.26588], [-119.27762, 34.26627]]], [[[-119.27803, 34.2667], [-119.27782, 34.26684], [-119.27743, 34.26643], [-119.27764, 34.26629], [-119.27803, 34.2667]]], [[[-119.27845, 34.26716], [-119.27826, 34.26726], [-119.27822, 34.26726], [-119.27784, 34.26686], [-119.27805, 34.26672], [-119.27845, 34.26716]]]]} | Open Access 1 | 316 | San Buenaventura State Beach | 1723 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=600 | Ventura 8 | 97.587 | San Buenaventura SB | 1948 | State Park 15 | 4 |
16469 | 16469 | 16468 | {"type": "Polygon", "coordinates": [[[-121.87069, 36.94019], [-121.86966, 36.94078], [-121.86919, 36.9404], [-121.86859, 36.9397], [-121.86848, 36.93935], [-121.86811, 36.93884], [-121.86699, 36.93758], [-121.86642, 36.93721], [-121.86637, 36.93722], [-121.86599, 36.93691], [-121.86636, 36.93651], [-121.86509, 36.93478], [-121.86474, 36.93483], [-121.86336, 36.93308], [-121.86319, 36.93316], [-121.86278, 36.93284], [-121.86235, 36.93321], [-121.86045, 36.93232], [-121.8607, 36.93192], [-121.8607, 36.9319], [-121.86213, 36.93166], [-121.86214, 36.93165], [-121.86121, 36.93044], [-121.86033, 36.92938], [-121.85931, 36.9279], [-121.85795, 36.92554], [-121.85686, 36.92399], [-121.85605, 36.9225], [-121.85513, 36.92109], [-121.85436, 36.91983], [-121.85428, 36.91967], [-121.85427, 36.91967], [-121.85358, 36.92094], [-121.85326, 36.92086], [-121.8529, 36.9207], [-121.85283, 36.92059], [-121.85262, 36.92063], [-121.85248, 36.92074], [-121.85246, 36.92088], [-121.85235, 36.92099], [-121.85222, 36.92127], [-121.85206, 36.92127], [-121.85196, 36.92116], [-121.8518, 36.92138], [-121.8517, 36.92138], [-121.85163, 36.92112], [-121.85139, 36.92103], [-121.85117, 36.92097], [-121.85063, 36.92121], [-121.84998, 36.92236], [-121.85058, 36.92257], [-121.85051, 36.92269], [-121.85052, 36.9227], [-121.85147, 36.92304], [-121.85156, 36.92292], [-121.85215, 36.92313], [-121.85179, 36.92346], [-121.84892, 36.9225], [-121.84919, 36.922], [-121.84857, 36.92178], [-121.84929, 36.92043], [-121.84638, 36.91715], [-121.84521, 36.91586], [-121.84861, 36.91493], [-121.84885, 36.9153], [-121.8505, 36.91507], [-121.85068, 36.91536], [-121.85151, 36.91524], [-121.85135, 36.91494], [-121.85152, 36.91491], [-121.85153, 36.9149], [-121.84965, 36.91216], [-121.84938, 36.91158], [-121.84874, 36.91075], [-121.84826, 36.91006], [-121.84848, 36.90998], [-121.84877, 36.91031], [-121.84897, 36.91058], [-121.84918, 36.91084], [-121.84958, 36.91143], [-121.85033, 36.91232], [-121.8517, 36.91456], [-121.85185, 36.91474], [-121.85197, 36.91492], [-121.852, 36.915], [-121.85206, 36.91522], [-121.8522, 36.91555], [-121.85242, 36.91586], [-121.85285, 36.91672], [-121.85333, 36.91762], [-121.85341, 36.91782], [-121.85359, 36.91818], [-121.85365, 36.91827], [-121.85398, 36.91889], [-121.8544, 36.91958], [-121.85451, 36.91972], [-121.8551, 36.92067], [-121.85532, 36.92098], [-121.85571, 36.92158], [-121.85584, 36.9218], [-121.85591, 36.92188], [-121.85661, 36.92297], [-121.85679, 36.9232], [-121.85699, 36.92353], [-121.85721, 36.92383], [-121.85764, 36.92456], [-121.8579, 36.92493], [-121.85813, 36.92532], [-121.85859, 36.92593], [-121.85876, 36.92621], [-121.85917, 36.92676], [-121.85981, 36.92768], [-121.8612, 36.92941], [-121.86165, 36.93001], [-121.86212, 36.93057], [-121.86241, 36.93103], [-121.86286, 36.93161], [-121.86688, 36.93638], [-121.87069, 36.94019]]]} | Open Access 1 | 17537 | Manresa State Beach | 1619 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=545 | Santa Cruz 5 | 140.157 | Manresa SB | 1948 | State Park 15 | 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]);