units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where ACCESS_TYP = 1, AGNCY_LEV = 2 and MNG_AGENCY = 403
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 5
- Local Park 14
- Local Recreation Area 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 18
MNG_AGENCY 1
- Pacifica, City of · 18 ✖
ACCESS_TYP 1
- Open Access · 18 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1693 | 1693 | 1692 | {"type": "Polygon", "coordinates": [[[-122.49248, 37.63035], [-122.49247, 37.63053], [-122.49221, 37.63053], [-122.49218, 37.63034], [-122.49248, 37.63035]]]} | Open Access 1 | 14655 | Palmetto Mini Park | 23354 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 0.124 | Palmetto MP | 0 | Local Park 2 | 4 | |
2771 | 2771 | 2770 | {"type": "Polygon", "coordinates": [[[-122.46746, 37.58568], [-122.46682, 37.58703], [-122.46548, 37.5881], [-122.46587, 37.58833], [-122.46498, 37.58832], [-122.46384, 37.58843], [-122.46356, 37.58842], [-122.46248, 37.58827], [-122.4622, 37.58821], [-122.46167, 37.58804], [-122.46003, 37.58769], [-122.45809, 37.58706], [-122.45803, 37.58698], [-122.4658, 37.58332], [-122.46672, 37.58456], [-122.46656, 37.58464], [-122.46645, 37.58476], [-122.46641, 37.58486], [-122.46629, 37.58528], [-122.46626, 37.58531], [-122.46621, 37.58532], [-122.46618, 37.58545], [-122.46746, 37.58568]]]} | Open Access 1 | 18507 | Frontierland Park | 19135 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 61.615 | Frontierland Park | 0 | Local Park 2 | 4 | |
3164 | 3164 | 3163 | {"type": "Polygon", "coordinates": [[[-122.49502, 37.62961], [-122.49505, 37.63001], [-122.49505, 37.63036], [-122.49496, 37.63119], [-122.49471, 37.63598], [-122.4946, 37.63603], [-122.49456, 37.63632], [-122.49446, 37.63656], [-122.49438, 37.63681], [-122.49433, 37.63719], [-122.49406, 37.637], [-122.49407, 37.63665], [-122.49406, 37.63599], [-122.49411, 37.63561], [-122.4941, 37.63519], [-122.49414, 37.63485], [-122.4942, 37.63386], [-122.49415, 37.63353], [-122.49413, 37.63313], [-122.49407, 37.63272], [-122.49383, 37.63194], [-122.4937, 37.63164], [-122.49368, 37.63123], [-122.49372, 37.63078], [-122.49369, 37.63035], [-122.49376, 37.63008], [-122.49401, 37.63002], [-122.49434, 37.63], [-122.49458, 37.62988], [-122.49502, 37.62961]]]} | Open Access 1 | 21950 | Sharp Park Beach | 25364 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 14.338 | Sharp Park Beach | 0 | Local Park 2 | 4 | |
3800 | 3800 | 3799 | {"type": "Polygon", "coordinates": [[[-122.49357, 37.64899], [-122.4935, 37.65064], [-122.49285, 37.65056], [-122.49308, 37.64929], [-122.4932, 37.6491], [-122.49325, 37.64896], [-122.49357, 37.64899]]]} | Open Access 1 | 35108 | Pacifica Esplanade | 23308 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 2.083 | Pacifica Esplanade | None 318 | |||
4292 | 4292 | 4291 | {"type": "Polygon", "coordinates": [[[-122.47915, 37.65481], [-122.47904, 37.65494], [-122.47891, 37.65513], [-122.4788, 37.65535], [-122.47874, 37.65553], [-122.4787, 37.65572], [-122.47868, 37.65593], [-122.47873, 37.65638], [-122.47847, 37.6564], [-122.47839, 37.65644], [-122.47835, 37.6565], [-122.47835, 37.65658], [-122.47844, 37.65679], [-122.4785, 37.65723], [-122.47845, 37.65724], [-122.47845, 37.65751], [-122.4784, 37.65751], [-122.47841, 37.65737], [-122.47837, 37.65722], [-122.47829, 37.657], [-122.47819, 37.6568], [-122.47642, 37.65406], [-122.47623, 37.65399], [-122.47603, 37.65407], [-122.47569, 37.65354], [-122.47566, 37.65343], [-122.47545, 37.65311], [-122.47401, 37.65226], [-122.4739, 37.65226], [-122.47331, 37.65141], [-122.47338, 37.65139], [-122.4742, 37.65218], [-122.4743, 37.65227], [-122.47444, 37.65235], [-122.47592, 37.65297], [-122.47625, 37.65306], [-122.47657, 37.65309], [-122.47655, 37.65355], [-122.47718, 37.65405], [-122.47732, 37.65412], [-122.47749, 37.65416], [-122.47765, 37.65418], [-122.47784, 37.65417], [-122.47785, 37.65422], [-122.47819, 37.65419], [-122.47822, 37.6543], [-122.47831, 37.65438], [-122.47834, 37.65456], [-122.47867, 37.65453], [-122.4787, 37.65467], [-122.47887, 37.65465], [-122.47915, 37.65481]]]} | Open Access 1 | 14647 | Imperial Park | 20181 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 12.743 | Imperial Park | 0 | Local Park 2 | 4 | |
4943 | 4943 | 4942 | {"type": "Polygon", "coordinates": [[[-122.48335, 37.63599], [-122.48332, 37.63609], [-122.48205, 37.63607], [-122.48206, 37.63561], [-122.48335, 37.63599]]]} | Open Access 1 | 14653 | Pomo Park | 23880 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 0.887 | Pomo Park | 0 | Local Park 2 | 4 | |
5451 | 5451 | 5450 | {"type": "Polygon", "coordinates": [[[-122.48486, 37.59659], [-122.48406, 37.59704], [-122.48453, 37.59732], [-122.48449, 37.59789], [-122.48301, 37.59801], [-122.48292, 37.59739], [-122.48256, 37.59742], [-122.48254, 37.59721], [-122.48289, 37.59717], [-122.48281, 37.59655], [-122.48276, 37.59639], [-122.4827, 37.59624], [-122.48261, 37.59609], [-122.48276, 37.59602], [-122.48227, 37.59522], [-122.4815, 37.59455], [-122.48154, 37.59436], [-122.48227, 37.59377], [-122.48316, 37.5953], [-122.48318, 37.5953], [-122.4832, 37.59514], [-122.48356, 37.59517], [-122.48363, 37.59536], [-122.48402, 37.59563], [-122.48415, 37.59604], [-122.48486, 37.59659]]]} | Open Access 1 | 24966 | Fassler Park | 18850 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 13.442 | Fassler Park | 0 | Local Park 2 | 4 | |
5621 | 5621 | 5620 | {"type": "Polygon", "coordinates": [[[-122.48191, 37.65869], [-122.48022, 37.65948], [-122.47994, 37.65915], [-122.48007, 37.65887], [-122.48018, 37.65857], [-122.47985, 37.6585], [-122.47988, 37.65839], [-122.48022, 37.65845], [-122.4803, 37.65811], [-122.48035, 37.65773], [-122.48033, 37.65762], [-122.4802, 37.65732], [-122.48097, 37.65705], [-122.48191, 37.65869]]]} | Open Access 1 | 14644 | Fairmont Park | 18806 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 6.458 | Fairmont Park | 0 | Local Park 2 | 4 | |
5622 | 5622 | 5621 | {"type": "Polygon", "coordinates": [[[-122.48783, 37.65343], [-122.48751, 37.65378], [-122.48743, 37.65376], [-122.48732, 37.65381], [-122.48696, 37.65377], [-122.48679, 37.65385], [-122.48662, 37.65364], [-122.4866, 37.65358], [-122.48666, 37.65328], [-122.48738, 37.65336], [-122.48762, 37.6533], [-122.48783, 37.65343]]]} | Open Access 1 | 14650 | Edgemar Park | 18436 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 1.18 | Edgemar Park | 0 | Local Park 2 | 4 | |
7824 | 7824 | 7823 | {"type": "Polygon", "coordinates": [[[-122.48429, 37.59997], [-122.48425, 37.601], [-122.48421, 37.60101], [-122.4842, 37.60205], [-122.48412, 37.602], [-122.48403, 37.60201], [-122.48397, 37.60205], [-122.48394, 37.60211], [-122.48396, 37.60216], [-122.48402, 37.60223], [-122.48411, 37.60228], [-122.4842, 37.6023], [-122.48415, 37.60367], [-122.48402, 37.60963], [-122.48335, 37.60962], [-122.48332, 37.61013], [-122.48313, 37.61014], [-122.4831, 37.6103], [-122.48256, 37.6103], [-122.48249, 37.6119], [-122.48246, 37.6119], [-122.48238, 37.61232], [-122.48272, 37.61233], [-122.48273, 37.61229], [-122.48315, 37.61229], [-122.48314, 37.61277], [-122.48303, 37.61278], [-122.48252, 37.61276], [-122.48199, 37.61266], [-122.48134, 37.61243], [-122.48126, 37.61234], [-122.48116, 37.61227], [-122.48103, 37.61221], [-122.48089, 37.61218], [-122.48074, 37.61218], [-122.48061, 37.61219], [-122.48047, 37.61224], [-122.48036, 37.61231], [-122.47961, 37.6123], [-122.47909, 37.6122], [-122.47875, 37.61208], [-122.47859, 37.6119], [-122.47827, 37.6117], [-122.47848, 37.6108], [-122.4789, 37.61085], [-122.4794, 37.60871], [-122.47855, 37.60858], [-122.47861, 37.60831], [-122.47826, 37.60826], [-122.47819, 37.60853], [-122.47751, 37.60844], [-122.47713, 37.61021], [-122.47686, 37.61018], [-122.47657, 37.61147], [-122.47641, 37.61149], [-122.47635, 37.61155], [-122.47618, 37.61162], [-122.47618, 37.61166], [-122.47533, 37.61154], [-122.47481, 37.61139], [-122.47418, 37.6113], [-122.47403, 37.61126], [-122.47349, 37.61072], [-122.47378, 37.61056], [-122.47373, 37.61048], [-122.47355, 37.60974], [-122.47356, 37.60954], [-122.47386, 37.60909], [-122.47364, 37.60881], [-122.47337, 37.60872], [-122.47302, 37.60882], [-122.47276, 37.60919], [-122.47259, 37.60927], [-122.47174, 37.60903], [-122.47143, 37.60916], [-122.47171, 37.60937], [-122.47166, 37.60941], [-122.4714, 37.60922], [-122.47045, 37.60878], [-122.47613, 37.59749], [-122.47623, 37.59759], [-122.47619, 37.59761], [-122.4766, 37.59832], [-122.4769, 37.59821], [-122.4777, 37.59904], [-122.47843, 37.59869], [-122.478, 37.59788], [-122.47832, 37.59775], [-122.47897, 37.59755], [-122.47939, 37.59738], [-122.48018, 37.59787], [-122.48024, 37.5982], [-122.48026, 37.59853], [-122.47991, 37.59846], [-122.47966, 37.59844], [-122.47941, 37.59848], [-122.47918, 37.59856], [-122.47898, 37.59869], [-122.47859, 37.5992], [-122.47859, 37.59922], [-122.47939, 37.59952], [-122.47966, 37.59916], [-122.48033, 37.59932], [-122.4805, 37.59928], [-122.48076, 37.59944], [-122.48085, 37.59934], [-122.48093, 37.59923], [-122.48122, 37.59929], [-122.48122, 37.59937], [-122.48191, 37.59934], [-122.4822, 37.59946], [-122.48364, 37.59971], [-122.48359, 37.59995], [-122.48429, 37.59997]]]} | Open Access 1 | 9277 | Sweeney Ridge | 8294 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/parksbeaches/beach_and_park_info_and_rules/sweeny/default.asp | San Mateo 15 | 327.796 | Sweeney Ridge | None 652 | ||
8926 | 8926 | 8925 | {"type": "Polygon", "coordinates": [[[-122.48978, 37.5917], [-122.48929, 37.59194], [-122.48923, 37.59194], [-122.48925, 37.5922], [-122.48876, 37.59225], [-122.48864, 37.59229], [-122.48851, 37.59236], [-122.48839, 37.59225], [-122.48576, 37.59164], [-122.48526, 37.59119], [-122.48495, 37.59195], [-122.48479, 37.59275], [-122.48475, 37.59276], [-122.4849, 37.59197], [-122.48398, 37.59171], [-122.48465, 37.59015], [-122.4847, 37.59006], [-122.48477, 37.58998], [-122.48486, 37.58994], [-122.48503, 37.5899], [-122.48546, 37.58985], [-122.48594, 37.58991], [-122.48718, 37.58976], [-122.48723, 37.58977], [-122.48805, 37.5902], [-122.48817, 37.59104], [-122.48939, 37.59187], [-122.48977, 37.59168], [-122.48978, 37.5917]]]} | Open Access 1 | 14662 | Oddstad Park | 23070 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 19.937 | Oddstad Park | 0 | Local Park 2 | 4 | |
8928 | 8928 | 8927 | {"type": "Polygon", "coordinates": [[[-122.48438, 37.66358], [-122.4839, 37.66357], [-122.48388, 37.66343], [-122.48379, 37.6633], [-122.48372, 37.66324], [-122.48361, 37.66318], [-122.48347, 37.66314], [-122.48336, 37.66314], [-122.48262, 37.66222], [-122.48276, 37.66179], [-122.48259, 37.66157], [-122.48264, 37.66105], [-122.48212, 37.6607], [-122.4824, 37.66037], [-122.48259, 37.65977], [-122.48304, 37.66045], [-122.48352, 37.66124], [-122.48359, 37.66156], [-122.4837, 37.66191], [-122.48438, 37.66358]]]} | Open Access 1 | 14669 | Edgewood Park | 18442 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 7.393 | Edgewood Park | 2000 | Local Park 2 | 4 | |
8929 | 8929 | 8928 | {"type": "Polygon", "coordinates": [[[-122.48269, 37.61961], [-122.48258, 37.61968], [-122.48252, 37.61978], [-122.48247, 37.62111], [-122.4811, 37.62108], [-122.48108, 37.62134], [-122.48104, 37.62134], [-122.48105, 37.62108], [-122.48039, 37.62106], [-122.48039, 37.62092], [-122.48052, 37.62051], [-122.48091, 37.61992], [-122.48252, 37.61922], [-122.48269, 37.61961]]]} | Open Access 1 | 14672 | Fairway Park Baseball Fields | 18826 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 6.945 | Fairway Park Baseball Fields | 0 | Local Recreation Area 3 | 4 | |
8934 | 8934 | 8933 | {"type": "Polygon", "coordinates": [[[-122.49868, 37.59281], [-122.49843, 37.59295], [-122.49823, 37.59278], [-122.49854, 37.59259], [-122.49868, 37.59281]]]} | Open Access 1 | 14667 | Portola Mini Park | 23908 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 0.206 | Portola MP | 0 | Local Park 2 | 4 | |
9655 | 9655 | 9654 | {"type": "Polygon", "coordinates": [[[-122.48686, 37.66026], [-122.48678, 37.66038], [-122.48669, 37.66045], [-122.4858, 37.66077], [-122.48564, 37.6605], [-122.48545, 37.66028], [-122.48524, 37.66012], [-122.48494, 37.65994], [-122.4847, 37.65967], [-122.48446, 37.65954], [-122.48451, 37.65941], [-122.48458, 37.65945], [-122.48478, 37.65901], [-122.48486, 37.65891], [-122.48507, 37.65871], [-122.48531, 37.65854], [-122.48529, 37.65909], [-122.48534, 37.65925], [-122.48546, 37.65938], [-122.48579, 37.65922], [-122.48647, 37.65925], [-122.4865, 37.65929], [-122.4865, 37.65963], [-122.48655, 37.65984], [-122.48667, 37.66006], [-122.48686, 37.66026]]]} | Open Access 1 | 16284 | Fairmont West Park | 18810 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 5.88 | Fairmont West Park | 0 | Local Park 2 | 4 | |
11586 | 11586 | 11585 | {"type": "Polygon", "coordinates": [[[-122.48853, 37.58277], [-122.48701, 37.58454], [-122.48674, 37.58438], [-122.48648, 37.58417], [-122.48626, 37.58395], [-122.48597, 37.5836], [-122.48578, 37.58345], [-122.48697, 37.58208], [-122.48761, 37.58223], [-122.48809, 37.58168], [-122.48813, 37.58169], [-122.48776, 37.58215], [-122.48853, 37.58277]]]} | Open Access 1 | 23681 | Sanchez Park | 25008 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 8.902 | Sanchez Park | 0 | Local Park 2 | 4 | |
13157 | 13157 | 13156 | {"type": "MultiPolygon", "coordinates": [[[[-122.50554, 37.59598], [-122.50508, 37.59614], [-122.50486, 37.59625], [-122.50464, 37.59638], [-122.50451, 37.59625], [-122.50495, 37.59601], [-122.50546, 37.59582], [-122.50554, 37.59598]]], [[[-122.50577, 37.59605], [-122.50554, 37.59627], [-122.50546, 37.59647], [-122.50531, 37.59657], [-122.50484, 37.59631], [-122.5054, 37.59615], [-122.50538, 37.59608], [-122.50549, 37.59605], [-122.50553, 37.59612], [-122.50577, 37.59605]]]]} | Open Access 1 | 35107 | City of Pacifica | 17326 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 0.889 | City of Pacifica | None 1140 | |||
14858 | 14858 | 14857 | {"type": "Polygon", "coordinates": [[[-122.48077, 37.61419], [-122.4807, 37.61426], [-122.48046, 37.61418], [-122.48031, 37.61418], [-122.48019, 37.61413], [-122.47989, 37.61388], [-122.47915, 37.61355], [-122.47867, 37.61305], [-122.47857, 37.61298], [-122.47823, 37.61288], [-122.47784, 37.6128], [-122.4771, 37.61251], [-122.47688, 37.61246], [-122.47665, 37.61243], [-122.47606, 37.61242], [-122.47567, 37.61248], [-122.47526, 37.61255], [-122.47472, 37.61239], [-122.47457, 37.61231], [-122.47441, 37.61222], [-122.47428, 37.6121], [-122.47417, 37.61197], [-122.4741, 37.61183], [-122.47409, 37.61161], [-122.47406, 37.61145], [-122.4741, 37.61143], [-122.47415, 37.61147], [-122.47415, 37.61164], [-122.47417, 37.61176], [-122.47422, 37.61188], [-122.4743, 37.61199], [-122.47448, 37.61212], [-122.47483, 37.61228], [-122.47524, 37.61235], [-122.47599, 37.6123], [-122.47673, 37.61228], [-122.47694, 37.61229], [-122.47725, 37.61237], [-122.47751, 37.61248], [-122.47795, 37.61269], [-122.47814, 37.61274], [-122.47851, 37.6128], [-122.47877, 37.6129], [-122.47893, 37.61301], [-122.47919, 37.61324], [-122.47953, 37.61362], [-122.47986, 37.61376], [-122.4802, 37.61396], [-122.48048, 37.614], [-122.48077, 37.61419]]]} | Open Access 1 | 45385 | Calera Creek Park | 27898 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 2.784 | Calera Creek 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]);