units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
240 rows where MNG_AGENCY = 21 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP >30
ACCESS_TYP 2
- Open Access 198
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 200
MNG_AGENCY 1
- San Francisco, City and County of · 200 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15674 | 15674 | 15673 | {"type": "Polygon", "coordinates": [[[-122.4337, 37.74613], [-122.43304, 37.74617], [-122.43304, 37.7461], [-122.43312, 37.74608], [-122.4331, 37.74577], [-122.43345, 37.74575], [-122.43369, 37.74571], [-122.4337, 37.74613]]]} | Open Access 1 | 5551 | Duncan/Castro Street Open Space | 18299 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.579 | Duncan/Castro Street OS | 0 | Local Recreation Area 3 | 4 | |
857 | 857 | 856 | {"type": "Polygon", "coordinates": [[[-122.44005, 37.73418], [-122.43989, 37.73445], [-122.43886, 37.73409], [-122.43928, 37.73337], [-122.4397, 37.73337], [-122.43971, 37.73394], [-122.4397, 37.73396], [-122.43966, 37.73396], [-122.43966, 37.73403], [-122.44005, 37.73418]]]} | Open Access 1 | 5558 | Dorothy Erskine Park | 18223 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.6 | Dorothy Erskine Park | 0 | Local Park 2 | 4 | |
863 | 863 | 862 | {"type": "Polygon", "coordinates": [[[-122.46596, 37.74109], [-122.46493, 37.74236], [-122.4645, 37.74212], [-122.46556, 37.74086], [-122.46583, 37.74099], [-122.46595, 37.74107], [-122.46596, 37.74109]]]} | Open Access 1 | 5574 | West Portal Playground | 27374 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.893 | West Portal Playground | 0 | Local Recreation Area 3 | 4 | |
5312 | 5312 | 5311 | {"type": "Polygon", "coordinates": [[[-122.47017, 37.74701], [-122.46994, 37.74702], [-122.46993, 37.74705], [-122.46994, 37.74711], [-122.46989, 37.74716], [-122.46955, 37.74717], [-122.46952, 37.74707], [-122.46946, 37.74704], [-122.46939, 37.74704], [-122.46935, 37.74706], [-122.46933, 37.74713], [-122.46935, 37.74718], [-122.46892, 37.7472], [-122.46889, 37.74678], [-122.46846, 37.74672], [-122.46709, 37.74679], [-122.46707, 37.74656], [-122.46717, 37.74655], [-122.46717, 37.74647], [-122.46742, 37.74645], [-122.46742, 37.7464], [-122.46739, 37.74639], [-122.46739, 37.74612], [-122.46761, 37.74618], [-122.46795, 37.74616], [-122.46802, 37.74609], [-122.46892, 37.74615], [-122.46962, 37.74611], [-122.46966, 37.74667], [-122.47015, 37.74665], [-122.47017, 37.74701]]]} | Open Access 1 | 5584 | Hawk Hill Open Space | 19745 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 4.836 | Hawk Hill OS | 0 | Local Recreation Area 3 | 4 | |
4899 | 4899 | 4898 | {"type": "MultiPolygon", "coordinates": [[[[-122.47227, 37.75682], [-122.47215, 37.75701], [-122.47202, 37.75727], [-122.47195, 37.75729], [-122.47141, 37.75706], [-122.47129, 37.75698], [-122.4712, 37.7569], [-122.47111, 37.75678], [-122.47106, 37.75665], [-122.47105, 37.75655], [-122.47106, 37.75638], [-122.47147, 37.75639], [-122.47146, 37.75656], [-122.47151, 37.75669], [-122.47162, 37.75678], [-122.47179, 37.75685], [-122.47194, 37.75665], [-122.47227, 37.75682]]], [[[-122.47149, 37.75605], [-122.47147, 37.75632], [-122.47108, 37.75631], [-122.47109, 37.75604], [-122.47149, 37.75605]]], [[[-122.47257, 37.75623], [-122.47259, 37.75633], [-122.47257, 37.75647], [-122.47252, 37.75655], [-122.47232, 37.75676], [-122.47199, 37.75659], [-122.47219, 37.75636], [-122.4722, 37.75634], [-122.47197, 37.75608], [-122.47171, 37.7559], [-122.47192, 37.75563], [-122.47207, 37.75572], [-122.47224, 37.75585], [-122.47238, 37.756], [-122.47257, 37.75623]]]]} | Open Access 1 | 5586 | 14th & 15th Avenue Open Space | 15172 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.665 | 14th & 15th Avenue OS | 0 | Local Recreation Area 3 | 4 | |
15775 | 15775 | 15774 | {"type": "Polygon", "coordinates": [[[-122.47273, 37.75508], [-122.47255, 37.75526], [-122.47257, 37.75529], [-122.47226, 37.75545], [-122.47219, 37.75536], [-122.47216, 37.75526], [-122.47213, 37.75504], [-122.47212, 37.75467], [-122.47216, 37.75465], [-122.4722, 37.75466], [-122.47236, 37.75482], [-122.47273, 37.75508]]]} | Open Access 1 | 5588 | Grand View Pk. Open Space | 19427 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.642 | Grand View Pk. OS | 0 | Local Recreation Area 3 | 4 | |
5317 | 5317 | 5316 | {"type": "Polygon", "coordinates": [[[-122.47094, 37.7547], [-122.4709, 37.75473], [-122.47059, 37.75472], [-122.47062, 37.75435], [-122.47054, 37.75434], [-122.47078, 37.75371], [-122.47082, 37.75334], [-122.47061, 37.75298], [-122.47089, 37.75284], [-122.47106, 37.7533], [-122.4711, 37.75353], [-122.47108, 37.75374], [-122.47096, 37.75406], [-122.47093, 37.75418], [-122.47096, 37.75451], [-122.47094, 37.7547]]]} | Open Access 1 | 5590 | Rock Outcropping | 24511 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.4 | Rock Outcropping | None 429 | |||
5319 | 5319 | 5318 | {"type": "Polygon", "coordinates": [[[-122.46536, 37.75213], [-122.46453, 37.75217], [-122.46452, 37.75212], [-122.46486, 37.75138], [-122.46531, 37.75136], [-122.46536, 37.75213]]]} | Open Access 1 | 5593 | John P. Murphy Playground | 20461 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.226 | John P. Murphy Playground | 0 | Local Recreation Area 3 | 4 | |
6880 | 6880 | 6879 | {"type": "MultiPolygon", "coordinates": [[[[-122.44736, 37.75022], [-122.44723, 37.75056], [-122.44717, 37.75089], [-122.44689, 37.7512], [-122.44672, 37.75149], [-122.44662, 37.75147], [-122.44705, 37.75049], [-122.44687, 37.75043], [-122.44689, 37.75038], [-122.44675, 37.75021], [-122.44662, 37.75022], [-122.44534, 37.7493], [-122.44542, 37.74921], [-122.44552, 37.74932], [-122.44563, 37.74942], [-122.44674, 37.75004], [-122.44699, 37.75014], [-122.44736, 37.75022]]], [[[-122.44813, 37.74837], [-122.44807, 37.74864], [-122.44798, 37.74863], [-122.44804, 37.74853], [-122.44813, 37.74837]]], [[[-122.44996, 37.75106], [-122.44994, 37.75108], [-122.44977, 37.75112], [-122.44966, 37.75095], [-122.44996, 37.75095], [-122.44996, 37.75106]]], [[[-122.4502, 37.74979], [-122.45002, 37.75052], [-122.44997, 37.75081], [-122.44974, 37.75081], [-122.45001, 37.7503], [-122.44998, 37.74979], [-122.4502, 37.74979]]], [[[-122.45601, 37.75981], [-122.45564, 37.76031], [-122.45562, 37.7603], [-122.45519, 37.76058], [-122.45509, 37.76058], [-122.45508, 37.76067], [-122.4538, 37.76173], [-122.45355, 37.76154], [-122.45349, 37.76158], [-122.45248, 37.7614], [-122.45245, 37.76128], [-122.45205, 37.76133], [-122.45203, 37.76127], [-122.45244, 37.76121], [-122.45227, 37.76034], [-122.45201, 37.76037], [-122.45201, 37.7588], [-122.45288, 37.75881], [-122.45288, 37.75995], [-122.45309, 37.7601], [-122.45415, 37.76012], [-122.45483, 37.75976], [-122.4559, 37.75978], [-122.45601, 37.75981]]], [[[-122.45331, 37.75675], [-122.45338, 37.75678], [-122.45348, 37.7569], [-122.45353, 37.757], [-122.45357, 37.75711], [-122.45358, 37.75721], [-122.45356, 37.75733], [-122.45353, 37.75742], [-122.45347, 37.75752], [-122.45326, 37.75768], [-122.45278, 37.75797], [-122.45229, 37.75819], [-122.45206, 37.75825], [-122.45203, 37.75696], [-122.45206, 37.75696], [-122.45213, 37.75704], [-122.45223, 37.7571], [-122.45234, 37.75712], [-122.45244, 37.75712], [-122.45256, 37.75708], [-122.45317, 37.75676], [-122.45324, 37.75674], [-122.45331, 37.75675]]], [[[-122.45251, 37.75697], [-122.45245, 37.75699], [-122.45239, 37.757], [-122.45227, 37.75696], [-122.45251, 37.75697]]], [[[-122.45531, 37.75382], [-122.45511, 37.75413], [-122.45502, 37.75433], [-122.45497, 37.75454], [-122.45492, 37.75493], [-122.45486, 37.75509], [-122.45462, 37.75553], [-122.45417, 37.75615], [-122.45407, 37.75633], [-122.45399, 37.75658], [-122.45394, 37.75697], [-122.45389, 37.7571], [-122.45381, 37.75722], [-122.45377, 37.75705], [-122.45367, 37.75685], [-122.45356, 37.75673], [-122.45342, 37.75666], [-122.45326, 37.75663], [-122.45314, 37.75664], [-122.45272, 37.75685], [-122.45271, 37.75669], [-122.45302, 37.75653], [-122.45319, 37.7565], [-122.45336, 37.7565], [-122.45354, 37.75655], [-122.45369, 37.75663], [-122.45382, 37.75677], [-122.45383, 37.75677], [-122.45388, 37.75651], [-122.454, 37.75622], [-122.45445, 37.75552], [-122.45471, 37.75502], [-122.45478, 37.75478], [-122.45482, 37.75436], [-122.45491, 37.75413], [-122.45514, 37.75376], [-122.45529, 37.75379], [-122.45531, 37.75382]]], [[[-122.45565, 37.75336], [-122.45545, 37.75366], [-122.45542, 37.75366], [-122.45525, 37.75363], [-122.45547, 37.75332], [-122.45565, 37.75336]]], [[[-122.45981, 37.75986], [-122.45974, 37.76001], [-122.45953, 37.76007], [-122.45919, 37.76008], [-122.45907, 37.76011], [-122.45901, 37.7602], [-122.45901, 37.76032], [-122.45909, 37.76051], [-122.4591, 37.76063], [-122.45905, 37.76086], [-122.45899, 37.76093], [-122.45888, 37.76096], [-122.45877, 37.76095], [-122.45869, 37.7609], [-122.45865, 37.76081], [-122.45865, 37.76076], [-122.45869, 37.7607], [-122.45879, 37.76064], [-122.45892, 37.76063], [-122.45897, 37.76059], [-122.45897, 37.76055], [-122.45887, 37.76033], [-122.45887, 37.76018], [-122.45898, 37.76002], [-122.45916, 37.75997], [-122.4595, 37.75996], [-122.45963, 37.75992], [-122.45967, 37.75985], [-122.45962, 37.7597], [-122.45934, 37.75907], [-122.4595, 37.75911], [-122.45975, 37.75966], [-122.45981, 37.75986]]]]} | Open Access 1 | 5595 | Interior Green Belt | 20223 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 21.314 | Interior Green Belt | None 560 | |||
6683 | 6683 | 6682 | {"type": "Polygon", "coordinates": [[[-122.44221, 37.75785], [-122.44216, 37.75851], [-122.44212, 37.75885], [-122.44209, 37.75891], [-122.44181, 37.75894], [-122.4418, 37.7589], [-122.44174, 37.7589], [-122.44172, 37.75871], [-122.4412, 37.75874], [-122.44119, 37.75863], [-122.44101, 37.75864], [-122.44097, 37.75825], [-122.44092, 37.75821], [-122.44121, 37.75818], [-122.44112, 37.75803], [-122.44123, 37.75795], [-122.44128, 37.75795], [-122.44133, 37.75792], [-122.44136, 37.75788], [-122.44136, 37.75784], [-122.44145, 37.75784], [-122.44148, 37.75754], [-122.44151, 37.75747], [-122.44166, 37.75749], [-122.44167, 37.75747], [-122.44221, 37.75785]]]} | Open Access 1 | 5597 | Kite Hill Open Space | 20679 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.896 | Kite Hill OS | 0 | Local Recreation Area 3 | 4 | |
15821 | 15821 | 15820 | {"type": "Polygon", "coordinates": [[[-122.44835, 37.76017], [-122.44827, 37.76026], [-122.44799, 37.76046], [-122.44692, 37.76053], [-122.44701, 37.76033], [-122.44722, 37.75978], [-122.44733, 37.7596], [-122.44746, 37.75945], [-122.4476, 37.75936], [-122.44774, 37.75928], [-122.44796, 37.75921], [-122.44812, 37.75918], [-122.44817, 37.75999], [-122.44833, 37.75999], [-122.44835, 37.76017]]]} | Open Access 1 | 5600 | Tank Hill Open Space | 26181 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.866 | Tank Hill OS | 0 | Local Recreation Area 3 | 4 | |
760 | 760 | 759 | {"type": "Polygon", "coordinates": [[[-122.44042, 37.75748], [-122.4401, 37.75772], [-122.44006, 37.7577], [-122.43984, 37.75794], [-122.4397, 37.75788], [-122.43989, 37.75763], [-122.44017, 37.75731], [-122.44042, 37.75748]]]} | Open Access 1 | 5609 | Seward Mini Park | 25330 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.372 | Seward MP | 0 | Local Park 2 | 4 | |
6885 | 6885 | 6884 | {"type": "Polygon", "coordinates": [[[-122.43926, 37.7517], [-122.43865, 37.75173], [-122.43859, 37.75111], [-122.43919, 37.75107], [-122.43926, 37.7517]]]} | Open Access 1 | 5623 | Noe Valley Court | 22782 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.926 | Noe Valley Court | 0 | Local Park 2 | 4 | |
16791 | 16791 | 16790 | {"type": "Polygon", "coordinates": [[[-122.43699, 37.75986], [-122.43657, 37.75989], [-122.43662, 37.7605], [-122.43619, 37.76052], [-122.43607, 37.7593], [-122.43694, 37.75925], [-122.43699, 37.75986]]]} | Open Access 1 | 5633 | Eureka Valley Recreation Center | 30885 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/destination/eureka-valley-rec-center/ | San Francisco 13 | 1.933 | Eureka Valley Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
7867 | 7867 | 7866 | {"type": "Polygon", "coordinates": [[[-122.41995, 37.74444], [-122.41985, 37.74459], [-122.41939, 37.7444], [-122.41948, 37.74426], [-122.41995, 37.74444]]]} | Open Access 1 | 5642 | Coleridge Mini Park | 17494 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.207 | Coleridge MP | 0 | Local Park 2 | 4 | |
5326 | 5326 | 5325 | {"type": "Polygon", "coordinates": [[[-122.4141, 37.75425], [-122.41371, 37.75447], [-122.4133, 37.75474], [-122.41325, 37.75425], [-122.41409, 37.7542], [-122.4141, 37.75425]]]} | Open Access 1 | 5650 | Parque De Los Ninos Unidos | 23475 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.541 | Parque De Los Ninos Unidos | None 431 | |||
1065 | 1065 | 1064 | {"type": "Polygon", "coordinates": [[[-122.41556, 37.75767], [-122.41515, 37.75769], [-122.41515, 37.75778], [-122.41473, 37.7578], [-122.41469, 37.75738], [-122.41553, 37.75733], [-122.41556, 37.75767]]]} | Open Access 1 | 5658 | Coronado Playground | 17650 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.783 | Coronado Playground | 0 | Local Recreation Area 3 | 4 | |
768 | 768 | 767 | {"type": "Polygon", "coordinates": [[[-122.42281, 37.75993], [-122.42246, 37.75995], [-122.42232, 37.75965], [-122.42215, 37.75966], [-122.42211, 37.75927], [-122.42205, 37.75923], [-122.42183, 37.75925], [-122.4218, 37.75887], [-122.4227, 37.75882], [-122.42281, 37.75993]]]} | Open Access 1 | 5666 | Mission Playground | 22307 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.793 | Mission Playground | 0 | Local Recreation Area 3 | 4 | |
1261 | 1261 | 1260 | {"type": "Polygon", "coordinates": [[[-122.42247, 37.74924], [-122.42242, 37.74925], [-122.42198, 37.74959], [-122.42198, 37.74954], [-122.42196, 37.74954], [-122.42188, 37.7496], [-122.42189, 37.74966], [-122.42158, 37.7499], [-122.4215, 37.7499], [-122.42149, 37.74982], [-122.42246, 37.74908], [-122.42247, 37.74924]]]} | Open Access 1 | 5676 | Juri Commons | 20535 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.325 | Juri Commons | None 108 | |||
15832 | 15832 | 15831 | {"type": "Polygon", "coordinates": [[[-122.42184, 37.75933], [-122.4215, 37.75935], [-122.42147, 37.75906], [-122.42181, 37.75904], [-122.42184, 37.75933]]]} | Open Access 1 | 5687 | Valencia & Cunningham Open Space | 26758 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.241 | Valencia & Cunningham OS | 0 | Local Recreation Area 3 | 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]);