units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where AGNCY_NAME = 391
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, MNG_AG_ID, MNG_AG_LEV, LABEL_NAME
DES_TP 5
MNG_AGENCY 3
MNG_AG_TYP 2
ACCESS_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1599 | 1599 | 1598 | {"type": "MultiPolygon", "coordinates": [[[[-122.02054, 37.98502], [-122.01997, 37.98528], [-122.01976, 37.9854], [-122.01948, 37.98561], [-122.01903, 37.98604], [-122.01742, 37.98529], [-122.01715, 37.98514], [-122.01703, 37.98505], [-122.01682, 37.98483], [-122.01587, 37.98356], [-122.01718, 37.98295], [-122.0186, 37.98485], [-122.01994, 37.98422], [-122.02054, 37.98502]]], [[[-122.02351, 37.99321], [-122.0232, 37.99333], [-122.02241, 37.99272], [-122.02244, 37.99269], [-122.02224, 37.99248], [-122.02216, 37.99237], [-122.0221, 37.99225], [-122.02204, 37.99207], [-122.02132, 37.98904], [-122.02126, 37.98885], [-122.02119, 37.9887], [-122.02109, 37.98856], [-122.01954, 37.98648], [-122.01938, 37.9863], [-122.01924, 37.98618], [-122.01969, 37.98576], [-122.01993, 37.98557], [-122.02068, 37.98522], [-122.02264, 37.98785], [-122.02207, 37.98863], [-122.02247, 37.98882], [-122.02351, 37.99321]]]]} | Open Access 1 | 13532 | Willow Pass Community Park | 27586 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 40.392 | Willow Pass Community Park | 0 | Local Park 2 | 4 | |
1600 | 1600 | 1599 | {"type": "MultiPolygon", "coordinates": [[[[-122.03172, 37.98378], [-122.02817, 37.98545], [-122.02703, 37.98392], [-122.02735, 37.98377], [-122.0275, 37.9839], [-122.0277, 37.98399], [-122.02785, 37.98403], [-122.028, 37.98403], [-122.02822, 37.984], [-122.03039, 37.98299], [-122.03056, 37.98287], [-122.03064, 37.98277], [-122.03069, 37.98265], [-122.03071, 37.98247], [-122.03068, 37.98234], [-122.03063, 37.98222], [-122.03098, 37.98206], [-122.03172, 37.98378]]], [[[-122.03053, 37.98227], [-122.0306, 37.98246], [-122.0306, 37.98257], [-122.03058, 37.98267], [-122.03052, 37.98276], [-122.03045, 37.98284], [-122.03028, 37.98295], [-122.02818, 37.98392], [-122.02805, 37.98395], [-122.02792, 37.98395], [-122.0278, 37.98393], [-122.02768, 37.98389], [-122.02757, 37.98384], [-122.02744, 37.98372], [-122.03053, 37.98227]]]]} | Open Access 1 | 13534 | Baldwin Park | 15779 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 17.805 | Baldwin Park | 0 | Local Park 2 | 4 | |
1795 | 1795 | 1794 | {"type": "Polygon", "coordinates": [[[-122.03452, 37.97743], [-122.03363, 37.97784], [-122.0331, 37.97714], [-122.03399, 37.97672], [-122.03452, 37.97743]]]} | Open Access 1 | 13536 | Todos Santos | 26388 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 2.043 | Todos Santos | None 141 | |||
1798 | 1798 | 1797 | {"type": "Polygon", "coordinates": [[[-122.04156, 37.96284], [-122.04157, 37.96319], [-122.04143, 37.9635], [-122.03856, 37.96546], [-122.03816, 37.965], [-122.03816, 37.96496], [-122.03837, 37.96482], [-122.03852, 37.96467], [-122.03862, 37.9645], [-122.0387, 37.96422], [-122.03877, 37.96408], [-122.03887, 37.96394], [-122.039, 37.96383], [-122.03921, 37.96401], [-122.04137, 37.96256], [-122.04156, 37.96284]]]} | Open Access 1 | 13547 | Meadow Homes Park | 22072 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 7.701 | Meadow Homes Park | 0 | Local Park 2 | 4 | |
1799 | 1799 | 1798 | {"type": "Polygon", "coordinates": [[[-122.01628, 37.96415], [-122.01473, 37.96759], [-122.0115, 37.96667], [-122.01305, 37.96324], [-122.01628, 37.96415]]]} | Open Access 1 | 13550 | Concord Community Park | 17575 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 30.162 | Concord Community Park | 0 | Local Park 2 | 4 | |
3333 | 3333 | 3332 | {"type": "Polygon", "coordinates": [[[-122.03097, 37.96818], [-122.0305, 37.96804], [-122.0304, 37.96765], [-122.03042, 37.96764], [-122.03041, 37.96759], [-122.03061, 37.96755], [-122.03072, 37.96749], [-122.03085, 37.96758], [-122.0309, 37.96779], [-122.03087, 37.96778], [-122.03087, 37.96779], [-122.03097, 37.96818]]]} | Open Access 1 | 23690 | Concord Skate Park | 17576 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 0.597 | Concord Skate Park | 0 | Local Recreation Area 3 | 4 | |
3628 | 3628 | 3627 | {"type": "Polygon", "coordinates": [[[-122.02596, 38.00835], [-122.02592, 38.00855], [-122.02562, 38.00858], [-122.0253, 38.0085], [-122.02441, 38.00795], [-122.02331, 38.00706], [-122.02336, 38.00691], [-122.02353, 38.00654], [-122.02402, 38.00703], [-122.02433, 38.00684], [-122.02477, 38.0073], [-122.02446, 38.00749], [-122.02483, 38.00787], [-122.02532, 38.00815], [-122.02596, 38.00835]]]} | Open Access 1 | 13525 | Bayview Circle Park | 15900 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 3.32 | Bayview Circle Park | 0 | Local Park 2 | 4 | |
3629 | 3629 | 3628 | {"type": "Polygon", "coordinates": [[[-122.03573, 38.00376], [-122.0353, 38.00455], [-122.03501, 38.00407], [-122.03474, 38.00393], [-122.03454, 38.00418], [-122.03377, 38.00383], [-122.03373, 38.00378], [-122.03394, 38.00348], [-122.03424, 38.00362], [-122.03447, 38.0033], [-122.03476, 38.00343], [-122.03573, 38.00376]]]} | Open Access 1 | 13528 | Sun Terrace Park | 25978 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 2.594 | Sun Terrace Park | 0 | Local Park 2 | 4 | |
3630 | 3630 | 3629 | {"type": "Polygon", "coordinates": [[[-122.04817, 37.99731], [-122.04801, 37.9984], [-122.04768, 37.99848], [-122.04746, 37.9985], [-122.04723, 37.99848], [-122.043, 37.99784], [-122.0428, 37.9978], [-122.04243, 37.99767], [-122.04226, 37.99757], [-122.04223, 37.99751], [-122.04249, 37.99665], [-122.04246, 37.99627], [-122.04423, 37.9966], [-122.04444, 37.99633], [-122.0447, 37.99554], [-122.0451, 37.99563], [-122.04584, 37.99596], [-122.04786, 37.99682], [-122.0452, 37.99613], [-122.04504, 37.99652], [-122.04783, 37.99725], [-122.04817, 37.99731]]]} | Open Access 1 | 13530 | Hillcrest Community Park | 19965 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 22.958 | Hillcrest Community Park | 0 | Local Park 2 | 4 | |
3631 | 3631 | 3630 | {"type": "Polygon", "coordinates": [[[-121.98729, 37.97617], [-121.98563, 37.97757], [-121.9843, 37.97657], [-121.98544, 37.97561], [-121.98729, 37.97617]]]} | Open Access 1 | 13539 | Concord Boulevard Park | 17574 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 7.136 | Concord Boulevard Park | 0 | Local Park 2 | 4 | |
3632 | 3632 | 3631 | {"type": "Polygon", "coordinates": [[[-122.03877, 37.97179], [-122.0379, 37.9722], [-122.03832, 37.97276], [-122.03765, 37.97301], [-122.03649, 37.97161], [-122.03544, 37.97045], [-122.03573, 37.97031], [-122.03609, 37.9707], [-122.03617, 37.97065], [-122.03661, 37.97047], [-122.03692, 37.97088], [-122.0378, 37.97047], [-122.03877, 37.97179]]]} | Open Access 1 | 13541 | Ellis Lake Park | 18592 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 9.392 | Ellis Lake Park | 0 | Local Park 2 | 4 | |
4766 | 4766 | 4765 | {"type": "Polygon", "coordinates": [[[-121.94894, 37.95659], [-121.94811, 37.95676], [-121.94769, 37.95718], [-121.94595, 37.95732], [-121.94556, 37.95747], [-121.94522, 37.95733], [-121.94478, 37.95735], [-121.94426, 37.95733], [-121.94353, 37.95711], [-121.94302, 37.957], [-121.94253, 37.95683], [-121.94236, 37.95692], [-121.94229, 37.95689], [-121.94223, 37.95691], [-121.94208, 37.95672], [-121.94172, 37.95664], [-121.94141, 37.95649], [-121.94116, 37.95642], [-121.94053, 37.95602], [-121.9399, 37.9559], [-121.94005, 37.95573], [-121.94022, 37.9556], [-121.94044, 37.95581], [-121.94064, 37.95573], [-121.9428, 37.95516], [-121.94301, 37.95513], [-121.94349, 37.95516], [-121.94377, 37.95516], [-121.94406, 37.95513], [-121.94503, 37.95483], [-121.94529, 37.95473], [-121.94551, 37.95461], [-121.94551, 37.95459], [-121.9453, 37.95439], [-121.94545, 37.95428], [-121.94565, 37.95443], [-121.94581, 37.95462], [-121.94617, 37.95491], [-121.94641, 37.95496], [-121.94663, 37.95505], [-121.94703, 37.95524], [-121.94707, 37.9552], [-121.94792, 37.95578], [-121.9482, 37.95594], [-121.94845, 37.95617], [-121.9486, 37.95614], [-121.94868, 37.95609], [-121.9488, 37.9563], [-121.94894, 37.95659]]]} | Open Access 1 | 46888 | Unnamed site - Concord, City of | 30380 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 35.16 | 0 | Local Other or Unknown 14 | 4 | ||
4887 | 4887 | 4886 | {"type": "Polygon", "coordinates": [[[-122.01786, 38.01685], [-122.01615, 38.01606], [-122.01379, 38.01187], [-122.01827, 38.01106], [-122.02232, 38.01073], [-122.02266, 38.01085], [-122.02298, 38.01167], [-122.0232, 38.01212], [-122.02344, 38.01272], [-122.02371, 38.01327], [-122.0239, 38.01321], [-122.02459, 38.01463], [-122.02429, 38.01472], [-122.02586, 38.01793], [-122.02616, 38.01785], [-122.02649, 38.01854], [-122.02529, 38.01892], [-122.02508, 38.01872], [-122.02404, 38.01933], [-122.01786, 38.01685]]]} | Restricted Access 2 | 13617 | Diablo Creek Golf Course | 33034 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 150.576 | Diablo Creek GC | 0 | Local Recreation Area 3 | 4 | |
8554 | 8554 | 8553 | {"type": "Polygon", "coordinates": [[[-122.00772, 37.96146], [-122.00602, 37.96186], [-122.00616, 37.96268], [-122.0044, 37.96289], [-122.00424, 37.9621], [-122.0041, 37.96209], [-122.00429, 37.96314], [-122.0027, 37.9627], [-122.00308, 37.96203], [-122.00233, 37.96198], [-122.0034, 37.96113], [-122.00375, 37.96132], [-122.00441, 37.96154], [-122.00459, 37.96152], [-122.0048, 37.96143], [-122.00488, 37.96147], [-122.0047, 37.96168], [-122.00471, 37.96169], [-122.00528, 37.96161], [-122.00536, 37.96166], [-122.00544, 37.96166], [-122.00552, 37.96162], [-122.00554, 37.96153], [-122.00557, 37.96149], [-122.00588, 37.96164], [-122.00602, 37.96148], [-122.00606, 37.96149], [-122.0069, 37.96049], [-122.00714, 37.9607], [-122.00725, 37.96082], [-122.00772, 37.96146]]]} | Open Access 1 | 13553 | Markham Nature Park | 21873 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 13.525 | Markham Nature Park | 0 | Local Park 2 | 4 | |
8556 | 8556 | 8555 | {"type": "MultiPolygon", "coordinates": [[[[-121.99479, 37.96098], [-121.99442, 37.96146], [-121.99399, 37.96144], [-121.99404, 37.96088], [-121.99396, 37.96089], [-121.99182, 37.96056], [-121.99172, 37.96132], [-121.99205, 37.96149], [-121.99196, 37.96148], [-121.98214, 37.95919], [-121.981, 37.95825], [-121.98095, 37.95832], [-121.98086, 37.95824], [-121.98071, 37.95815], [-121.97998, 37.95788], [-121.98003, 37.95778], [-121.9799, 37.95772], [-121.97958, 37.95739], [-121.97949, 37.95719], [-121.97934, 37.95713], [-121.97922, 37.95697], [-121.97906, 37.95686], [-121.97912, 37.95673], [-121.97732, 37.9551], [-121.97713, 37.95541], [-121.97633, 37.95481], [-121.97615, 37.9551], [-121.97479, 37.95388], [-121.97489, 37.9537], [-121.97495, 37.95323], [-121.97491, 37.95287], [-121.97476, 37.95274], [-121.9745, 37.95284], [-121.97436, 37.95267], [-121.97421, 37.95257], [-121.97392, 37.95245], [-121.97357, 37.9524], [-121.97354, 37.95235], [-121.97369, 37.95218], [-121.97391, 37.95198], [-121.97398, 37.95204], [-121.97428, 37.95189], [-121.9746, 37.9518], [-121.97494, 37.95177], [-121.97583, 37.95177], [-121.9762, 37.9517], [-121.97642, 37.95164], [-121.97649, 37.95166], [-121.97652, 37.95165], [-121.97747, 37.953], [-121.97842, 37.95399], [-121.97859, 37.95411], [-121.97896, 37.95432], [-121.97948, 37.95457], [-121.97963, 37.95468], [-121.97991, 37.95492], [-121.98074, 37.95585], [-121.98082, 37.95592], [-121.98101, 37.95603], [-121.98123, 37.9561], [-121.98146, 37.95614], [-121.98169, 37.95615], [-121.98192, 37.95611], [-121.98223, 37.95599], [-121.98294, 37.95557], [-121.98323, 37.95543], [-121.98337, 37.95575], [-121.98351, 37.9559], [-121.98373, 37.95599], [-121.98404, 37.95607], [-121.98443, 37.95627], [-121.98547, 37.95672], [-121.98586, 37.9568], [-121.98622, 37.95681], [-121.98672, 37.95699], [-121.98698, 37.95704], [-121.98722, 37.95706], [-121.98764, 37.95721], [-121.98795, 37.95742], [-121.98819, 37.95767], [-121.98833, 37.95779], [-121.98847, 37.95797], [-121.98886, 37.95827], [-121.9891, 37.95835], [-121.98911, 37.95883], [-121.98865, 37.95901], [-121.98865, 37.9593], [-121.98851, 37.95931], [-121.98847, 37.95932], [-121.98843, 37.95935], [-121.9884, 37.95941], [-121.98842, 37.95949], [-121.98851, 37.95954], [-121.98856, 37.95955], [-121.98864, 37.95953], [-121.98869, 37.95948], [-121.9887, 37.95968], [-121.99005, 37.95967], [-121.99025, 37.9597], [-121.9905, 37.95977], [-121.99072, 37.9598], [-121.99079, 37.95956], [-121.99101, 37.95957], [-121.99117, 37.95954], [-121.99138, 37.95947], [-121.99155, 37.95939], [-121.9918, 37.95952], [-121.99202, 37.9596], [-121.99236, 37.95965], [-121.99242, 37.95985], [-121.99256, 37.96009], [-121.99288, 37.96023], [-121.99367, 37.96017], [-121.99372, 37.96025], [-121.99382, 37.96033], [-121.99407, 37.96016], [-121.99418, 37.96025], [-121.99396, 37.96045], [-121.99409, 37.96056], [-121.99418, 37.96069], [-121.99436, 37.96084], [-121.99479, 37.96098]]], [[[-121.98862, 37.96075], [-121.9885, 37.96096], [-121.98795, 37.96077], [-121.988, 37.96068], [-121.98799, 37.96066], [-121.98784, 37.96061], [-121.9878, 37.96067], [-121.98744, 37.96049], [-121.98862, 37.96075]]]]} | Open Access 1 | 13559 | Newhall Community Park | 22724 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 116.896 | Newhall Community Park | 0 | Local Park 2 | 4 | |
8557 | 8557 | 8556 | {"type": "Polygon", "coordinates": [[[-121.97034, 37.96168], [-121.96971, 37.96159], [-121.96914, 37.96141], [-121.96863, 37.96092], [-121.96855, 37.96075], [-121.96845, 37.9607], [-121.96879, 37.96024], [-121.9691, 37.96038], [-121.96943, 37.96035], [-121.96959, 37.9604], [-121.96963, 37.96034], [-121.96978, 37.96044], [-121.97034, 37.96168]]]} | Open Access 1 | 13562 | Brazil Quarry Park | 16338 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 3.647 | Brazil Quarry Park | 0 | Local Park 2 | 4 | |
8558 | 8558 | 8557 | {"type": "Polygon", "coordinates": [[[-122.04915, 37.95255], [-122.04632, 37.95453], [-122.04611, 37.95441], [-122.04588, 37.95449], [-122.04526, 37.95388], [-122.04525, 37.95361], [-122.04629, 37.95288], [-122.04641, 37.95301], [-122.04675, 37.95283], [-122.04771, 37.95221], [-122.04841, 37.95172], [-122.04915, 37.95255]]]} | Open Access 1 | 13565 | Cambridge Park | 16752 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 10.872 | Cambridge Park | 0 | Local Park 2 | 4 | |
8559 | 8559 | 8558 | {"type": "Polygon", "coordinates": [[[-122.03014, 37.94438], [-122.02767, 37.94589], [-122.02678, 37.94493], [-122.02722, 37.94455], [-122.02771, 37.94422], [-122.02807, 37.94401], [-122.02924, 37.94341], [-122.03014, 37.94438]]]} | Open Access 1 | 13567 | Ygnacio Valley Park | 27771 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 9.462 | Ygnacio Valley Park | 0 | Local Park 2 | 4 | |
8560 | 8560 | 8559 | {"type": "Polygon", "coordinates": [[[-121.95868, 37.94342], [-121.95855, 37.94356], [-121.95849, 37.94365], [-121.95821, 37.94415], [-121.95553, 37.94318], [-121.95594, 37.94246], [-121.95868, 37.94342]]]} | Open Access 1 | 13570 | Highlands Neighborhood Park | 19941 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 5.734 | Highlands Neighborhood Park | 0 | Local Park 2 | 4 | |
8561 | 8561 | 8560 | {"type": "Polygon", "coordinates": [[[-122.05177, 37.94056], [-122.05138, 37.94277], [-122.05069, 37.94269], [-122.05106, 37.94041], [-122.05165, 37.94042], [-122.05164, 37.94055], [-122.05177, 37.94056]]]} | Open Access 1 | 13573 | Len Hester Community Park | 21161 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | Contra Costa 12 | 3.966 | Len Hester Community Park | 0 | Local Park 2 | 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]);