units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
491 rows where MNG_AGENCY = 24 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, ACRES, LABEL_NAME, YR_EST, GAP_STS
SUID_NMA 465 ✖
- 21477 16
- 21482 11
- 21478 2
- 5628 1
- 5632 1
- 5656 1
- 5694 1
- 5786 1
- 5838 1
- 5891 1
- 15168 1
- 15183 1
- 15299 1
- 15356 1
- 15370 1
- 15374 1
- 15387 1
- 15394 1
- 15480 1
- 15483 1
- 15492 1
- 15498 1
- 15626 1
- 15627 1
- 15631 1
- 15645 1
- 15707 1
- 15727 1
- 15776 1
- 15788 1
- 15794 1
- 15798 1
- 15825 1
- 15835 1
- 15950 1
- 16017 1
- 16316 1
- 16329 1
- 16331 1
- 16372 1
- 16442 1
- 16480 1
- 16634 1
- 16796 1
- 16849 1
- 16852 1
- 16953 1
- 17072 1
- 17156 1
- 17158 1
- 17159 1
- 17160 1
- 17180 1
- 17185 1
- 17187 1
- 17295 1
- 17320 1
- 17419 1
- 17478 1
- 17487 1
- 17635 1
- 17816 1
- 17853 1
- 17972 1
- 17973 1
- 17981 1
- 17985 1
- 18050 1
- 18062 1
- 18085 1
- 18127 1
- 18128 1
- 18255 1
- 18346 1
- 18347 1
- 18385 1
- 18386 1
- 18420 1
- 18426 1
- 18526 1
- 18541 1
- 18543 1
- 18548 1
- 18609 1
- 18668 1
- 18763 1
- 18767 1
- 18779 1
- 18880 1
- 18890 1
- 19226 1
- 19255 1
- 19309 1
- 19313 1
- 19331 1
- 19410 1
- 19417 1
- 19424 1
- 19447 1
- 19469 1
- 19597 1
- 19635 1
- 19661 1
- 19663 1
- 19666 1
- 19684 1
- 19710 1
- 19763 1
- 19822 1
- 19865 1
- 19932 1
- 19937 1
- 20034 1
- 20037 1
- 20054 1
- 20083 1
- 20084 1
- 20116 1
- 20130 1
- 20179 1
- 20272 1
- 20411 1
- 20463 1
- 20466 1
- 20473 1
- 20489 1
- 20534 1
- 20542 1
- 20620 1
- 20680 1
- 20692 1
- 20832 1
- 20985 1
- 20998 1
- 21077 1
- 21087 1
- 21122 1
- 21145 1
- 21146 1
- 21152 1
- 21179 1
- 21241 1
- 21250 1
- 21266 1
- 21337 1
- 21341 1
- 21463 1
- 21468 1
- 21483 1
- 21498 1
- 21499 1
- 21502 1
- 21550 1
- 21623 1
- 21665 1
- 21739 1
- 21742 1
- 21785 1
- 21787 1
- 21905 1
- 21907 1
- 21941 1
- 21943 1
- 22038 1
- 22409 1
- 22453 1
- 22465 1
- 22522 1
- 22593 1
- 22797 1
- 22800 1
- 22801 1
- 22805 1
- 22823 1
- 22824 1
- 22864 1
- 22889 1
- 22965 1
- 23039 1
- 23198 1
- 23209 1
- 23357 1
- 23384 1
- 23393 1
- 23485 1
- 23537 1
- 23555 1
- 23556 1
- 23586 1
- 23619 1
- 23657 1
- 23845 1
- 23850 1
- 23900 1
- 23901 1
- 24020 1
- 24060 1
- 24110 1
- 24114 1
- 24134 1
- 24291 1
- 24310 1
- 24336 1
- 24404 1
- 24489 1
- 24498 1
- 24559 1
- 24603 1
- 24610 1
- 24611 1
- 24617 1
- 24677 1
- 24730 1
- 24731 1
- 24750 1
- 24751 1
- 24786 1
- 24787 1
- 24789 1
- 24971 1
- 25288 1
- 25306 1
- 25307 1
- 25316 1
- 25341 1
- 25373 1
- 25488 1
- 25489 1
- 25524 1
- 25554 1
- 25672 1
- 25683 1
- 25812 1
- 25838 1
- 25855 1
- 25864 1
- 25891 1
- 25894 1
- 25899 1
- 25909 1
- 25910 1
- 25936 1
- 25949 1
- 25981 1
- 26001 1
- 26128 1
- 26148 1
- 26192 1
- 26200 1
- 26229 1
- 26282 1
- 26340 1
- 26375 1
- 26380 1
- 26381 1
- 26397 1
- 26531 1
- 26542 1
- 26562 1
- 26789 1
- 26799 1
- 26828 1
- 26830 1
- 26832 1
- 26834 1
- 26846 1
- 26998 1
- 26999 1
- 27088 1
- 27097 1
- 27098 1
- 27140 1
- 27170 1
- 27175 1
- 27263 1
- 27269 1
- 27312 1
- 27313 1
- 27314 1
- 27360 1
- 27377 1
- 27386 1
- 27406 1
- 27417 1
- 27423 1
- 27441 1
- 27463 1
- 27492 1
- 27505 1
- 27554 1
- 27599 1
- 27600 1
- 27649 1
- 27680 1
- 27686 1
- 27785 1
- 27861 1
- 27920 1
- 27965 1
- 28069 1
- 28101 1
- 28354 1
- 28359 1
- 28361 1
- 28362 1
- 28367 1
- 28375 1
- 28382 1
- 28419 1
- 28599 1
- 28612 1
- 28613 1
- 28614 1
- 28615 1
- 28617 1
- 28618 1
- 28619 1
- 28620 1
- 28621 1
- 28623 1
- 28624 1
- 28626 1
- 28628 1
- 28633 1
- 28698 1
- 28718 1
- 28721 1
- 28722 1
- 28724 1
- 28725 1
- 28726 1
- 28727 1
- 28728 1
- 28729 1
- 28733 1
- 28734 1
- 28735 1
- 28736 1
- 28737 1
- 28741 1
- 28742 1
- 28743 1
- 28744 1
- 28745 1
- 28746 1
- 28750 1
- 28751 1
- 28757 1
- 28758 1
- 28761 1
- 28767 1
- 28768 1
- 28772 1
- 28776 1
- 28778 1
- 28779 1
- 28781 1
- 28783 1
- 28785 1
- 28786 1
- 28788 1
- 28790 1
- 28791 1
- 28800 1
- 28801 1
- 28802 1
- 28803 1
- 28805 1
- 28807 1
- 28808 1
- 28810 1
- 28812 1
- 28820 1
- 28821 1
- 28822 1
- 28824 1
- 28825 1
- 28826 1
- 28830 1
- 28831 1
- 28833 1
- 28834 1
- 28837 1
- 28839 1
- 28840 1
- 28841 1
- 28842 1
- 28845 1
- 28846 1
- 28847 1
- 28848 1
- 28849 1
- 28850 1
- 28851 1
- 28852 1
- 28853 1
- 28854 1
- 28855 1
- 28857 1
- 28858 1
- 28859 1
- 28862 1
- 28863 1
- 28866 1
- 28872 1
- 28880 1
- 28918 1
- 28919 1
- 28920 1
- 28921 1
- 29029 1
- 29033 1
- 29037 1
- 29042 1
- 29085 1
- 29322 1
- 29809 1
- 29817 1
- 29961 1
- 29965 1
- 29966 1
- 29969 1
- 29970 1
- 29971 1
- 29973 1
- 29974 1
- 30330 1
- 30336 1
- 30349 1
- 30356 1
- 30450 1
- 30713 1
- 30744 1
- 30890 1
- 30898 1
- 30907 1
- 30949 1
- 30957 1
- 30958 1
- 30961 1
- 31121 1
- 31212 1
- 31254 1
- 31643 1
- 31684 1
- 31694 1
- 31843 1
- 31940 1
- 31941 1
- 32026 1
- 32559 1
- 32572 1
- 32599 1
- 32601 1
- 32609 1
- 32611 1
- 32744 1
- 32785 1
- 32999 1
- 33009 1
- 33047 1
- 33076 1
- 33107 1
- 33131 1
- 33648 1
DES_TP 35
- Local Park 314
- Local Recreation Area 116
- Local Other or Unknown 26
- Local Conservation Area 4
- National Forest 1
- Local Historic or Cultural Area 1
- None 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 4
- Open Access 432
- No Public Access 36
- Restricted Access 20
- Unknown Access 3
MNG_AG_TYP 1
- City Agency 491
MNG_AGENCY 1
- Los Angeles, City of · 491 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44 | 44 | 43 | {"type": "Polygon", "coordinates": [[[-118.35044, 34.13077], [-118.35003, 34.13136], [-118.34933, 34.1306], [-118.3496, 34.13019], [-118.35044, 34.13077]]]} | Open Access 1 | 99 | El Paseo Cahuenga Park | 18526 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.546 | El Paseo Cahuenga Park | 0 | Local Park 2 | 4 | |
66 | 66 | 65 | {"type": "Polygon", "coordinates": [[[-118.24767, 33.99122], [-118.24568, 33.99122], [-118.24567, 33.98955], [-118.24762, 33.98955], [-118.24767, 33.99122]]]} | Open Access 1 | 190 | Augustus Hawkins Natural Park | 15707 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.369 | Augustus Hawkins Natural Park | 0 | Local Park 2 | 4 | |
95 | 95 | 94 | {"type": "Polygon", "coordinates": [[[-118.50316, 34.16163], [-118.50227, 34.16163], [-118.50228, 34.15971], [-118.50316, 34.15991], [-118.50316, 34.16163]]]} | Open Access 1 | 302 | Encino Park | 18668 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 4.067 | Encino Park | 0 | Local Park 2 | 4 | |
127 | 127 | 126 | {"type": "MultiPolygon", "coordinates": [[[[-118.41914, 34.18293], [-118.4191, 34.18296], [-118.41829, 34.18296], [-118.41826, 34.18294], [-118.41825, 34.1818], [-118.41911, 34.18181], [-118.41914, 34.18184], [-118.41914, 34.18293]]], [[[-118.42023, 34.18293], [-118.42019, 34.18296], [-118.41938, 34.18296], [-118.41935, 34.18294], [-118.41934, 34.18184], [-118.42023, 34.18184], [-118.42023, 34.18293]]]]} | Open Access 1 | 335 | Valley Glen Community Park | 26789 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 5.115 | Valley Glen Community Park | 0 | Local Park 2 | 4 | |
156 | 156 | 155 | {"type": "Polygon", "coordinates": [[[-118.27409, 34.2411], [-118.27374, 34.24114], [-118.2736, 34.24083], [-118.27329, 34.24038], [-118.2733, 34.24033], [-118.27334, 34.24031], [-118.27398, 34.2402], [-118.27404, 34.24086], [-118.27409, 34.2411]]]} | Open Access 1 | 494 | Fehlhaber-Houk Park | 28620 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://www.laparks.org/dos/parks/facility/fehlhaberHoukPk.htm | Los Angeles 6 | 1.175 | Fehlhaber-Houk Park | 0 | Local Park 2 | 4 |
159 | 159 | 158 | {"type": "Polygon", "coordinates": [[[-118.24886, 34.06967], [-118.24887, 34.07033], [-118.24883, 34.07039], [-118.24876, 34.07043], [-118.24868, 34.07045], [-118.2486, 34.07043], [-118.24854, 34.0704], [-118.2485, 34.07035], [-118.24848, 34.07029], [-118.24848, 34.07024], [-118.24877, 34.06965], [-118.24882, 34.06963], [-118.24886, 34.06967]]]} | Open Access 1 | 405 | Everett Park | 18763 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.521 | Everett Park | 0 | Local Park 2 | 4 | |
294 | 294 | 293 | {"type": "Polygon", "coordinates": [[[-118.36564, 34.02332], [-118.36557, 34.02447], [-118.36551, 34.02475], [-118.36542, 34.02503], [-118.36317, 34.02482], [-118.36308, 34.02548], [-118.3629, 34.02546], [-118.36318, 34.02338], [-118.36465, 34.02338], [-118.36466, 34.02331], [-118.36564, 34.02332]]]} | Open Access 1 | 788 | Baldwin Hills Recreation Center | 15776 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 10.253 | Baldwin Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
319 | 319 | 318 | {"type": "Polygon", "coordinates": [[[-118.18189, 34.12005], [-118.18189, 34.12005], [-118.17889, 34.12008], [-118.1804, 34.11888], [-118.18088, 34.11808], [-118.18153, 34.11815], [-118.18189, 34.12005]]]} | Open Access 1 | 855 | Garvanza Park | 19226 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.274 | Garvanza Park | 0 | Local Park 2 | 4 | |
331 | 331 | 330 | {"type": "Polygon", "coordinates": [[[-118.36901, 34.03598], [-118.36855, 34.03714], [-118.36689, 34.03694], [-118.36745, 34.03546], [-118.36901, 34.03598]]]} | Open Access 1 | 908 | Genesee Avenue Park | 19255 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 5.852 | Genesee Avenue Park | 0 | Local Park 2 | 4 | |
449 | 449 | 448 | {"type": "Polygon", "coordinates": [[[-118.18446, 34.11514], [-118.1843, 34.11529], [-118.18412, 34.11522], [-118.1843, 34.11518], [-118.18446, 34.11514]]]} | Open Access 1 | 1807 | Highland Park | 19932 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.045 | Highland Park | 0 | Local Park 2 | 4 | |
493 | 493 | 492 | {"type": "Polygon", "coordinates": [[[-118.40813, 34.28144], [-118.40657, 34.28258], [-118.40505, 34.28116], [-118.40662, 34.28002], [-118.40813, 34.28144]]]} | Open Access 1 | 1998 | Hubert H. Humphrey Memorial Park | 20130 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 9.987 | Hubert H. Humphrey Memorial Park | 0 | Local Park 2 | 4 | |
511 | 511 | 510 | {"type": "Polygon", "coordinates": [[[-118.19601, 34.05796], [-118.19489, 34.05976], [-118.19436, 34.05954], [-118.19513, 34.0583], [-118.1952, 34.05834], [-118.19523, 34.05833], [-118.19532, 34.05836], [-118.19542, 34.05832], [-118.19563, 34.05796], [-118.19573, 34.058], [-118.19601, 34.05796]]]} | Open Access 1 | 1704 | Henry Alvarez Memorial Park | 19822 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.566 | Henry Alvarez Memorial Park | 0 | Local Park 2 | 4 | |
514 | 514 | 513 | {"type": "Polygon", "coordinates": [[[-118.29549, 34.09994], [-118.29552, 34.10008], [-118.29552, 34.10036], [-118.2955, 34.10049], [-118.29546, 34.10058], [-118.29538, 34.10069], [-118.29515, 34.10094], [-118.29543, 34.10117], [-118.29519, 34.10127], [-118.2953, 34.10134], [-118.2953, 34.10166], [-118.29326, 34.10167], [-118.29326, 34.10131], [-118.29305, 34.10119], [-118.29296, 34.10103], [-118.29294, 34.10094], [-118.29294, 34.10085], [-118.29299, 34.10075], [-118.29298, 34.09918], [-118.29357, 34.0992], [-118.29358, 34.09919], [-118.29391, 34.09915], [-118.29454, 34.09916], [-118.29462, 34.0992], [-118.29469, 34.09919], [-118.29473, 34.09923], [-118.29489, 34.09928], [-118.29489, 34.09935], [-118.29492, 34.09941], [-118.29518, 34.0996], [-118.29539, 34.09978], [-118.29549, 34.09994]]]} | Open Access 1 | 1713 | Barnsdall Park | 15825 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 14.293 | Barnsdall Park | 0 | Local Park 2 | 4 | |
546 | 546 | 545 | {"type": "Polygon", "coordinates": [[[-118.2789, 33.99551], [-118.27847, 33.99551], [-118.27847, 33.99538], [-118.27889, 33.99538], [-118.2789, 33.99551]]]} | Open Access 1 | 45788 | Broadway Park | 28807 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.146 | Broadway Park | 0 | Local Park 2 | 4 | |
640 | 640 | 639 | {"type": "Polygon", "coordinates": [[[-118.38183, 34.28065], [-118.38163, 34.2808], [-118.38181, 34.28097], [-118.38084, 34.28168], [-118.38011, 34.28099], [-118.38128, 34.28013], [-118.38183, 34.28065]]]} | Open Access 1 | 2675 | Kagel Canyon Park | 20542 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.465 | Kagel Canyon Park | 0 | Local Park 2 | 4 | |
659 | 659 | 658 | {"type": "MultiPolygon", "coordinates": [[[[-118.28551, 34.06276], [-118.28488, 34.06277], [-118.28427, 34.06357], [-118.28256, 34.0628], [-118.28336, 34.06157], [-118.28425, 34.06197], [-118.2855, 34.06197], [-118.28551, 34.06276]]], [[[-118.28408, 34.06152], [-118.28355, 34.06128], [-118.28407, 34.06049], [-118.28408, 34.06152], [-118.28408, 34.06152]]]]} | Open Access 1 | 3260 | Lafayette Park | 20832 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 9.08 | Lafayette Park | 0 | Local Park 2 | 4 | |
691 | 691 | 690 | {"type": "Polygon", "coordinates": [[[-118.18789, 34.13489], [-118.18738, 34.13556], [-118.18733, 34.13557], [-118.18727, 34.13555], [-118.18726, 34.13551], [-118.18778, 34.13483], [-118.18789, 34.13489]]]} | Open Access 1 | 3556 | Lanark/Shelby Park | 20998 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.274 | Lanark/Shelby Park | 0 | Local Park 2 | 4 | |
696 | 696 | 695 | {"type": "Polygon", "coordinates": [[[-118.6462, 34.21201], [-118.64612, 34.21245], [-118.64599, 34.21284], [-118.64584, 34.21312], [-118.6452, 34.21418], [-118.64505, 34.21455], [-118.64495, 34.21491], [-118.64489, 34.21494], [-118.6445, 34.21492], [-118.64449, 34.21195], [-118.64612, 34.21195], [-118.64617, 34.21197], [-118.6462, 34.21201]]]} | Open Access 1 | 3832 | Lazy J Ranch Park | 21122 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.44 | Lazy J Ranch Park | 0 | Local Park 2 | 4 | |
701 | 701 | 700 | {"type": "Polygon", "coordinates": [[[-118.33238, 34.00416], [-118.3308, 34.00412], [-118.3308, 34.00412], [-118.33091, 34.00377], [-118.33196, 34.00376], [-118.33238, 34.00416]]]} | Open Access 1 | 3898 | Leimert Park | 21145 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.262 | Leimert Park | 0 | Local Park 2 | 4 | |
712 | 712 | 711 | {"type": "Polygon", "coordinates": [[[-118.32015, 34.02603], [-118.31946, 34.02603], [-118.31946, 34.02567], [-118.32015, 34.02568], [-118.32015, 34.02603]]]} | Open Access 1 | 4016 | Leslie N. Shaw Park | 21179 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.627 | Leslie N. Shaw 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]);