units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
22 rows where COUNTY = 36 and MNG_AGENCY = 640
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3511 | 3511 | 3510 | {"type": "Polygon", "coordinates": [[[-118.29463, 35.66527], [-118.29017, 35.6658], [-118.29016, 35.66338], [-118.29462, 35.66337], [-118.29463, 35.66527]]]} | Unknown Access 4 | 36102 | National Audubon Society 4 | 22654 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 23.993 | Nat. Audubon Society 4 | 0 | Private Conservation 16 | 2 | |
3921 | 3921 | 3920 | {"type": "MultiPolygon", "coordinates": [[[[-118.2043, 35.49494], [-118.20434, 35.49511], [-118.20436, 35.49526], [-118.20435, 35.49577], [-118.20437, 35.49604], [-118.20442, 35.49637], [-118.20441, 35.49673], [-118.20436, 35.49698], [-118.20421, 35.49746], [-118.20412, 35.49806], [-118.20399, 35.49875], [-118.2038, 35.49939], [-118.20377, 35.49962], [-118.20377, 35.50008], [-118.20385, 35.50087], [-118.20408, 35.50174], [-118.20407, 35.50194], [-118.20403, 35.50207], [-118.20398, 35.50216], [-118.20123, 35.50216], [-118.20127, 35.49494], [-118.2043, 35.49494]]], [[[-118.2101, 35.50219], [-118.2042, 35.50216], [-118.20427, 35.50197], [-118.20428, 35.50175], [-118.20425, 35.50159], [-118.20405, 35.50084], [-118.20397, 35.50008], [-118.20397, 35.49964], [-118.20401, 35.4994], [-118.20419, 35.49878], [-118.20432, 35.49808], [-118.20441, 35.49748], [-118.20456, 35.49699], [-118.20461, 35.49672], [-118.20462, 35.4964], [-118.20457, 35.49599], [-118.20455, 35.49569], [-118.20456, 35.49526], [-118.2045, 35.49494], [-118.2101, 35.49494], [-118.2101, 35.50219]]]]} | Unknown Access 4 | 36100 | National Audubon Society 5 | 22655 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 155.643 | Nat. Audubon Society 5 | 0 | Private Conservation 16 | 2 | |
12399 | 12399 | 12398 | {"type": "Polygon", "coordinates": [[[-118.2991, 35.66701], [-118.29904, 35.67422], [-118.29611, 35.67423], [-118.29467, 35.67377], [-118.29464, 35.66699], [-118.2991, 35.66701]]]} | Unknown Access 4 | 27000 | Vig, Heflin and Alexander | 27096 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 78.449 | Vig, Heflin and Alexander | 0 | Private Conservation 16 | 2 | |
12400 | 12400 | 12399 | {"type": "Polygon", "coordinates": [[[-118.29464, 35.6701], [-118.29249, 35.6701], [-118.29247, 35.66885], [-118.29016, 35.66927], [-118.29017, 35.66773], [-118.29266, 35.66777], [-118.29252, 35.6669], [-118.2944, 35.66666], [-118.29414, 35.6655], [-118.29463, 35.66544], [-118.29464, 35.6701]]]} | Unknown Access 4 | 27001 | Vig, Heflin and Alexander | 27096 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 26.231 | Vig, Heflin and Alexander | 0 | Private Conservation 16 | 2 | |
12406 | 12406 | 12405 | {"type": "Polygon", "coordinates": [[[-118.18291, 35.72885], [-118.18268, 35.73232], [-118.17866, 35.73247], [-118.17877, 35.72896], [-118.18291, 35.72885]]]} | Unknown Access 4 | 36168 | National Audubon Society 8 | 22658 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 35.32 | Nat. Audubon Society 8 | 0 | Private Conservation 16 | 2 | |
13711 | 13711 | 13710 | {"type": "Polygon", "coordinates": [[[-118.6737, 35.68413], [-118.66479, 35.68413], [-118.66477, 35.68045], [-118.6603, 35.68042], [-118.66019, 35.67669], [-118.66472, 35.67668], [-118.6736, 35.6767], [-118.6737, 35.68413]]]} | Unknown Access 4 | 36111 | National Audubon Society 6 | 22656 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 206.102 | Nat. Audubon Society 6 | 0 | Private Conservation 16 | 2 | |
13725 | 13725 | 13724 | {"type": "Polygon", "coordinates": [[[-118.1829, 35.73595], [-118.17869, 35.7361], [-118.17866, 35.73247], [-118.18268, 35.73233], [-118.1829, 35.73595]]]} | Unknown Access 4 | 36140 | National Audubon Society 23 | 22652 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 37.086 | Nat. Audubon Society 23 | 0 | Private Conservation 16 | 2 | |
13726 | 13726 | 13725 | {"type": "Polygon", "coordinates": [[[-118.29017, 35.66553], [-118.29, 35.66553], [-118.29, 35.66582], [-118.28548, 35.66634], [-118.28553, 35.66335], [-118.29016, 35.66338], [-118.29017, 35.66553]]]} | Unknown Access 4 | 36141 | National Audubon Society 13 | 22642 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 31.155 | Nat. Audubon Society 13 | 0 | Private Conservation 16 | 2 | |
13729 | 13729 | 13728 | {"type": "MultiPolygon", "coordinates": [[[[-118.32506, 35.67338], [-118.32384, 35.674], [-118.32283, 35.67419], [-118.32277, 35.67419], [-118.32279, 35.67326], [-118.32286, 35.67325], [-118.32367, 35.67324], [-118.32441, 35.67334], [-118.32506, 35.67338]]], [[[-118.32559, 35.67153], [-118.32554, 35.67299], [-118.3248, 35.67294], [-118.32373, 35.67272], [-118.3228, 35.67274], [-118.32288, 35.66874], [-118.32302, 35.66909], [-118.32324, 35.6695], [-118.32351, 35.66989], [-118.32383, 35.67025], [-118.32419, 35.67059], [-118.32452, 35.67085], [-118.32559, 35.67153]]], [[[-118.32574, 35.66363], [-118.32571, 35.66683], [-118.32559, 35.67132], [-118.3246, 35.67068], [-118.32428, 35.67043], [-118.324, 35.67016], [-118.32369, 35.66981], [-118.32343, 35.66944], [-118.32325, 35.66911], [-118.32307, 35.6687], [-118.32297, 35.66835], [-118.32289, 35.66792], [-118.32293, 35.66363], [-118.32574, 35.66363]]]]} | Unknown Access 4 | 36167 | National Audubon Society 7 | 22657 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 65.106 | Nat. Audubon Society 7 | 0 | Private Conservation 16 | 2 | |
13991 | 13991 | 13990 | {"type": "MultiPolygon", "coordinates": [[[[-118.3212, 35.67603], [-118.31012, 35.67604], [-118.31012, 35.67776], [-118.30892, 35.67966], [-118.30793, 35.67964], [-118.3079, 35.67385], [-118.30967, 35.67417], [-118.3104, 35.67449], [-118.3123, 35.67459], [-118.31453, 35.67488], [-118.31568, 35.67488], [-118.31715, 35.67483], [-118.31912, 35.675], [-118.32027, 35.67493], [-118.321, 35.67494], [-118.3212, 35.67603]]], [[[-118.31744, 35.67415], [-118.31682, 35.67447], [-118.31588, 35.67444], [-118.31439, 35.67428], [-118.31371, 35.67434], [-118.31237, 35.67416], [-118.3096, 35.67365], [-118.30791, 35.6734], [-118.30792, 35.67063], [-118.31243, 35.67061], [-118.31248, 35.67416], [-118.31744, 35.67415]]], [[[-118.32132, 35.67418], [-118.32092, 35.67452], [-118.3199, 35.67452], [-118.31892, 35.67445], [-118.31814, 35.67445], [-118.31912, 35.67416], [-118.32132, 35.67418]]]]} | Unknown Access 4 | 36654 | National Audubon Society 10 | 22639 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 101.523 | Nat. Audubon Society 10 | 0 | Private Conservation 16 | 2 | |
14132 | 14132 | 14131 | {"type": "Polygon", "coordinates": [[[-118.33903, 35.68861], [-118.33455, 35.6886], [-118.32572, 35.68873], [-118.32572, 35.69247], [-118.31685, 35.69236], [-118.31682, 35.68866], [-118.30796, 35.68871], [-118.29908, 35.68873], [-118.29912, 35.69602], [-118.29714, 35.69602], [-118.297, 35.69594], [-118.2969, 35.69584], [-118.295, 35.69434], [-118.29474, 35.69417], [-118.29474, 35.6925], [-118.29049, 35.69251], [-118.29033, 35.69245], [-118.29029, 35.69014], [-118.29028, 35.68874], [-118.29027, 35.68149], [-118.29457, 35.68151], [-118.29466, 35.68502], [-118.30355, 35.68506], [-118.30358, 35.68149], [-118.30794, 35.68146], [-118.30793, 35.67964], [-118.30892, 35.67966], [-118.31012, 35.67776], [-118.31011, 35.67604], [-118.3212, 35.67603], [-118.32222, 35.6763], [-118.32294, 35.67622], [-118.32402, 35.67619], [-118.32525, 35.67581], [-118.32555, 35.67599], [-118.32561, 35.67788], [-118.3345, 35.67777], [-118.33451, 35.67409], [-118.33871, 35.6742], [-118.33892, 35.68137], [-118.33903, 35.68861]]]} | Unknown Access 4 | 43027 | National Audubon Society 19 | 22648 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 1369.209 | Nat. Audubon Society 19 | 0 | Private Conservation 16 | 2 | |
16380 | 16380 | 16379 | {"type": "Polygon", "coordinates": [[[-118.2968, 35.69602], [-118.29474, 35.69602], [-118.29474, 35.69437], [-118.29674, 35.69595], [-118.2968, 35.69602]]]} | Unknown Access 4 | 43028 | National Audubon Society 17 | 22646 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 4.294 | Nat. Audubon Society 17 | 0 | Private Conservation 16 | 2 | |
16516 | 16516 | 16515 | {"type": "Polygon", "coordinates": [[[-118.29012, 35.69205], [-118.28803, 35.69205], [-118.28803, 35.69251], [-118.2814, 35.6925], [-118.28132, 35.69068], [-118.2747, 35.69061], [-118.27464, 35.68696], [-118.27242, 35.68693], [-118.27242, 35.68512], [-118.2769, 35.68515], [-118.27693, 35.68874], [-118.29007, 35.68874], [-118.29008, 35.69014], [-118.29012, 35.69205]]]} | Unknown Access 4 | 36142 | National Audubon Society 18 | 22647 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 141.001 | Nat. Audubon Society 18 | 0 | Private Conservation 16 | 2 | |
16616 | 16616 | 16615 | {"type": "MultiPolygon", "coordinates": [[[[-118.29226, 35.67424], [-118.29028, 35.67426], [-118.29026, 35.67365], [-118.29076, 35.67366], [-118.29168, 35.67375], [-118.29226, 35.67408], [-118.29226, 35.67424]]], [[[-118.29062, 35.67315], [-118.29038, 35.67314], [-118.29037, 35.67301], [-118.29037, 35.67301], [-118.29062, 35.67315]]]]} | Unknown Access 4 | 43064 | National Audubon Society 20 | 22650 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 2.496 | Nat. Audubon Society 20 | 0 | Private Conservation 16 | 2 | |
16995 | 16995 | 16994 | {"type": "MultiPolygon", "coordinates": [[[[-118.32729, 35.67268], [-118.32554, 35.67299], [-118.32559, 35.67163], [-118.32667, 35.6723], [-118.32694, 35.67249], [-118.32729, 35.67268]]], [[[-118.33913, 35.6662], [-118.33753, 35.66683], [-118.33575, 35.66799], [-118.33412, 35.66986], [-118.33236, 35.67133], [-118.32783, 35.67255], [-118.32755, 35.67242], [-118.32729, 35.67228], [-118.32693, 35.67204], [-118.3256, 35.67122], [-118.32571, 35.66683], [-118.32574, 35.66363], [-118.32902, 35.66361], [-118.33069, 35.66324], [-118.33669, 35.66321], [-118.33666, 35.66368], [-118.33695, 35.66497], [-118.3391, 35.66591], [-118.33913, 35.6662]]], [[[-118.33451, 35.67194], [-118.33451, 35.67409], [-118.3266, 35.6742], [-118.32676, 35.67347], [-118.32829, 35.67307], [-118.32861, 35.67315], [-118.32902, 35.67322], [-118.32936, 35.67331], [-118.32971, 35.67337], [-118.33, 35.6734], [-118.33029, 35.6734], [-118.33058, 35.67339], [-118.33087, 35.67335], [-118.33148, 35.67318], [-118.33287, 35.67269], [-118.33292, 35.67279], [-118.3335, 35.67261], [-118.33375, 35.6725], [-118.33406, 35.67232], [-118.33431, 35.67214], [-118.33451, 35.67194]]], [[[-118.33452, 35.67084], [-118.33452, 35.67101], [-118.33429, 35.67122], [-118.33405, 35.67153], [-118.33385, 35.67174], [-118.33364, 35.6719], [-118.33337, 35.67205], [-118.33315, 35.67214], [-118.33271, 35.67227], [-118.33274, 35.67238], [-118.33134, 35.67287], [-118.33073, 35.67304], [-118.33067, 35.67305], [-118.33058, 35.67289], [-118.3302, 35.67291], [-118.32986, 35.67289], [-118.32976, 35.67304], [-118.32946, 35.67299], [-118.32904, 35.67289], [-118.33057, 35.67251], [-118.33314, 35.67175], [-118.33432, 35.67112], [-118.33452, 35.67084]]], [[[-118.33903, 35.667], [-118.33898, 35.67037], [-118.33489, 35.67031], [-118.33543, 35.66955], [-118.33642, 35.66855], [-118.33784, 35.66754], [-118.33903, 35.667]]]]} | Unknown Access 4 | 36166 | National Audubon Society 9 | 22659 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 264.275 | Nat. Audubon Society 9 | 0 | Private Conservation 16 | 2 | |
16996 | 16996 | 16995 | {"type": "MultiPolygon", "coordinates": [[[[-118.18308, 35.74613], [-118.18307, 35.74668], [-118.17417, 35.7468], [-118.16604, 35.74711], [-118.16564, 35.74343], [-118.17202, 35.74325], [-118.17204, 35.74501], [-118.17417, 35.74496], [-118.1801, 35.74487], [-118.1815, 35.74541], [-118.18202, 35.74564], [-118.18308, 35.74613]]], [[[-118.18308, 35.74581], [-118.18218, 35.74539], [-118.18088, 35.74486], [-118.18091, 35.74485], [-118.18087, 35.74309], [-118.18304, 35.74308], [-118.18308, 35.74581]]]]} | Unknown Access 4 | 43024 | National Audubon Society 11 | 22640 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 114.543 | Nat. Audubon Society 11 | 0 | Private Conservation 16 | 2 | |
16997 | 16997 | 16996 | {"type": "MultiPolygon", "coordinates": [[[[-118.30795, 35.66696], [-118.3079, 35.6734], [-118.30686, 35.67324], [-118.30399, 35.67358], [-118.30196, 35.67421], [-118.29905, 35.67422], [-118.2991, 35.66701], [-118.2991, 35.66489], [-118.30103, 35.66465], [-118.30104, 35.66566], [-118.30398, 35.66567], [-118.30399, 35.66695], [-118.30795, 35.66696]]], [[[-118.3079, 35.67385], [-118.3079, 35.67418], [-118.30372, 35.6742], [-118.30562, 35.67372], [-118.30749, 35.67378], [-118.3079, 35.67385]]]]} | Unknown Access 4 | 43025 | National Audubon Society 15 | 22644 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 173.319 | Nat. Audubon Society 15 | 0 | Private Conservation 16 | 2 | |
16998 | 16998 | 16997 | {"type": "Polygon", "coordinates": [[[-118.31679, 35.67415], [-118.31247, 35.67416], [-118.31243, 35.67061], [-118.30792, 35.67063], [-118.30795, 35.66668], [-118.31204, 35.66666], [-118.31679, 35.66529], [-118.31679, 35.67415]]]} | Unknown Access 4 | 43026 | National Audubon Society 14 | 22643 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 133.04 | Nat. Audubon Society 14 | 0 | Private Conservation 16 | 2 | |
17001 | 17001 | 17000 | {"type": "MultiPolygon", "coordinates": [[[[-118.25928, 35.67024], [-118.25921, 35.67026], [-118.25904, 35.67033], [-118.25865, 35.67053], [-118.25835, 35.67072], [-118.258, 35.67097], [-118.25768, 35.67124], [-118.25744, 35.67148], [-118.25696, 35.67205], [-118.25584, 35.67205], [-118.25583, 35.67252], [-118.25465, 35.67252], [-118.25467, 35.67066], [-118.25461, 35.66342], [-118.2582, 35.66342], [-118.25822, 35.66403], [-118.25906, 35.66405], [-118.25928, 35.67024]]], [[[-118.26209, 35.67064], [-118.25938, 35.67289], [-118.25934, 35.67204], [-118.25722, 35.67205], [-118.25745, 35.67176], [-118.25766, 35.67153], [-118.25789, 35.6713], [-118.25814, 35.67109], [-118.25841, 35.6709], [-118.25869, 35.67072], [-118.25899, 35.67056], [-118.25929, 35.67042], [-118.25931, 35.67065], [-118.26209, 35.67064]]], [[[-118.264, 35.67436], [-118.25943, 35.67436], [-118.25939, 35.67328], [-118.26257, 35.67064], [-118.26379, 35.67063], [-118.264, 35.67436]]]]} | Unknown Access 4 | 36112 | National Audubon Society 16 | 22645 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 135.112 | Nat. Audubon Society 16 | 0 | Private Conservation 16 | 2 | |
17004 | 17004 | 17003 | {"type": "MultiPolygon", "coordinates": [[[[-118.29467, 35.67377], [-118.29419, 35.67362], [-118.29189, 35.67317], [-118.29062, 35.67315], [-118.29037, 35.67301], [-118.29034, 35.67178], [-118.2902, 35.67177], [-118.29016, 35.66927], [-118.29248, 35.66885], [-118.29249, 35.67009], [-118.29464, 35.6701], [-118.29467, 35.67377]]], [[[-118.29434, 35.67423], [-118.29226, 35.67424], [-118.29226, 35.67408], [-118.29168, 35.67375], [-118.29272, 35.67385], [-118.29434, 35.67423]]]]} | Unknown Access 4 | 36101 | National Audubon Society 3 | 22653 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 42.725 | Nat. Audubon Society 3 | 0 | Private Conservation 16 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);