units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
60 rows where DES_TP = 2 and MNG_AGENCY = 117 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 60
MNG_AGENCY 1
- Chula Vista, City of · 60 ✖
DES_TP 1
- Local Park · 60 ✖
ACCESS_TYP 1
- Open Access 60
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14762 | 14762 | 14761 | {"type": "Polygon", "coordinates": [[[-116.97651, 32.6128], [-116.97638, 32.61287], [-116.97623, 32.61292], [-116.97566, 32.61299], [-116.97547, 32.61304], [-116.9753, 32.61311], [-116.97513, 32.6132], [-116.97499, 32.6133], [-116.97474, 32.61356], [-116.97466, 32.61359], [-116.97418, 32.61369], [-116.97406, 32.61373], [-116.97391, 32.61384], [-116.97376, 32.61399], [-116.97363, 32.61405], [-116.97357, 32.61383], [-116.97353, 32.61361], [-116.97346, 32.6126], [-116.97478, 32.61231], [-116.975, 32.61238], [-116.97625, 32.61212], [-116.97627, 32.6123], [-116.97632, 32.61248], [-116.9764, 32.61264], [-116.97651, 32.6128]]]} | Open Access 1 | 45144 | All Seasons Park | 15377 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/all-seasons-park | San Diego 4 | 7.603 | All Seasons Park | 0 | Local Park 2 | 4 |
533 | 533 | 532 | {"type": "Polygon", "coordinates": [[[-117.10061, 32.63666], [-117.10052, 32.6367], [-117.1004, 32.63657], [-117.10016, 32.63639], [-117.0999, 32.63627], [-117.09961, 32.63619], [-117.0994, 32.63601], [-117.09949, 32.63592], [-117.10024, 32.63571], [-117.10061, 32.63666]]]} | Open Access 1 | 2423 | Bay Boulevard Park | 30005 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/bay-boulevard | San Diego 4 | 1.27 | Bay Boulevard Park | 0 | Local Park 2 | 4 |
7711 | 7711 | 7710 | {"type": "Polygon", "coordinates": [[[-116.99759, 32.65572], [-116.99525, 32.65807], [-116.99418, 32.65763], [-116.99362, 32.65738], [-116.99358, 32.65732], [-116.99387, 32.65684], [-116.99422, 32.65698], [-116.99435, 32.65678], [-116.9947, 32.65639], [-116.99492, 32.65576], [-116.99759, 32.65572]]]} | Open Access 1 | 7787 | Bonita Long Canyon Park | 16260 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/bonita-long-canyon-park | San Diego 4 | 12.067 | Bonita Long Canyon Park | 0 | Local Park 2 | 4 |
14598 | 14598 | 14597 | {"type": "Polygon", "coordinates": [[[-116.98456, 32.63845], [-116.98455, 32.63849], [-116.98452, 32.63851], [-116.98444, 32.63854], [-116.98433, 32.63855], [-116.98428, 32.63857], [-116.98425, 32.63864], [-116.98427, 32.63871], [-116.9842, 32.63876], [-116.9841, 32.63879], [-116.984, 32.63879], [-116.98397, 32.63872], [-116.98392, 32.63869], [-116.98387, 32.63868], [-116.98381, 32.6387], [-116.98374, 32.63876], [-116.98358, 32.63881], [-116.98353, 32.63879], [-116.98341, 32.63835], [-116.9834, 32.63819], [-116.98335, 32.6381], [-116.98379, 32.63786], [-116.98375, 32.63775], [-116.9838, 32.63774], [-116.9841, 32.63775], [-116.98413, 32.63785], [-116.98426, 32.638], [-116.98456, 32.63845]]]} | Open Access 1 | 44823 | Breezewood Park | 16347 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/breezewood-park | San Diego 4 | 2.13 | Breezewood Park | 0 | Local Park 2 | 4 |
7666 | 7666 | 7665 | {"type": "Polygon", "coordinates": [[[-116.96955, 32.64393], [-116.96934, 32.64428], [-116.96888, 32.64511], [-116.96881, 32.64532], [-116.96877, 32.64554], [-116.96841, 32.64548], [-116.96795, 32.64527], [-116.96729, 32.64523], [-116.96689, 32.64515], [-116.96615, 32.64484], [-116.96612, 32.64481], [-116.96612, 32.64477], [-116.96629, 32.64451], [-116.96642, 32.64427], [-116.96659, 32.64384], [-116.96666, 32.64352], [-116.9667, 32.64326], [-116.96671, 32.64276], [-116.96805, 32.64268], [-116.96812, 32.64341], [-116.9682, 32.64359], [-116.96836, 32.64376], [-116.96857, 32.64389], [-116.96881, 32.64396], [-116.96898, 32.64397], [-116.96955, 32.64393]]]} | Open Access 1 | 7568 | Chula Vista Community Park | 17240 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/chula-vista-community-park | San Diego 4 | 14.298 | Chula Vista Community Park | 0 | Local Park 2 | 4 |
3552 | 3552 | 3551 | {"type": "Polygon", "coordinates": [[[-117.05544, 32.59946], [-117.05505, 32.59946], [-117.05504, 32.59979], [-117.05461, 32.59966], [-117.05462, 32.59923], [-117.05469, 32.59919], [-117.05504, 32.59919], [-117.05505, 32.59938], [-117.05544, 32.59939], [-117.05544, 32.59946]]]} | Open Access 1 | 7710 | Connoley Park | 17592 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/connoley-park | San Diego 4 | 0.668 | Connoley Park | 0 | Local Park 2 | 4 |
7665 | 7665 | 7664 | {"type": "Polygon", "coordinates": [[[-116.98312, 32.63302], [-116.98199, 32.63347], [-116.98175, 32.63286], [-116.98096, 32.63275], [-116.98126, 32.63152], [-116.98161, 32.63162], [-116.98244, 32.63175], [-116.98249, 32.63181], [-116.98267, 32.63184], [-116.98275, 32.63179], [-116.98298, 32.63183], [-116.98284, 32.63252], [-116.98312, 32.63302]]]} | Open Access 1 | 7566 | Cottonwood Park | 17688 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/cottonwood-park | San Diego 4 | 6.723 | Cottonwood Park | 0 | Local Park 2 | 4 |
7671 | 7671 | 7670 | {"type": "Polygon", "coordinates": [[[-117.01065, 32.64444], [-117.00899, 32.64428], [-117.00849, 32.6448], [-117.00796, 32.64427], [-117.00791, 32.6445], [-117.00773, 32.6447], [-117.00742, 32.64471], [-117.00714, 32.64442], [-117.00691, 32.64445], [-117.00663, 32.64485], [-117.0069, 32.64532], [-117.00664, 32.64565], [-117.00643, 32.64533], [-117.00618, 32.64516], [-117.00598, 32.64509], [-117.00571, 32.64508], [-117.00451, 32.64528], [-117.00403, 32.6438], [-117.00436, 32.64382], [-117.00459, 32.64382], [-117.00483, 32.64379], [-117.00506, 32.64373], [-117.00537, 32.64361], [-117.00652, 32.64301], [-117.00663, 32.64313], [-117.00682, 32.64326], [-117.00703, 32.64336], [-117.00722, 32.6434], [-117.0105, 32.64368], [-117.01055, 32.6437], [-117.01056, 32.64374], [-117.01065, 32.64444]]]} | Open Access 1 | 7619 | Discovery Park | 18165 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/discovery-park | San Diego 4 | 20.562 | Discovery Park | 0 | Local Park 2 | 4 |
3226 | 3226 | 3225 | {"type": "Polygon", "coordinates": [[[-116.9381, 32.62076], [-116.93597, 32.62079], [-116.93593, 32.62048], [-116.93582, 32.62021], [-116.93569, 32.61999], [-116.93473, 32.61881], [-116.93465, 32.61869], [-116.93448, 32.61839], [-116.93433, 32.61801], [-116.93424, 32.61761], [-116.93424, 32.61751], [-116.93365, 32.61192], [-116.93445, 32.61192], [-116.9381, 32.62076]]]} | Open Access 1 | 22283 | EastLake III Park | 18395 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 43.841 | EastLake III Park | 0 | Local Park 2 | 4 | |
7686 | 7686 | 7685 | {"type": "Polygon", "coordinates": [[[-117.09191, 32.64933], [-117.09061, 32.64971], [-117.09036, 32.64976], [-117.08898, 32.65016], [-117.08813, 32.65038], [-117.0881, 32.65037], [-117.08805, 32.65033], [-117.08745, 32.64879], [-117.0903, 32.64799], [-117.09007, 32.64737], [-117.08995, 32.64732], [-117.08993, 32.64727], [-117.09051, 32.64712], [-117.09055, 32.64719], [-117.09103, 32.64705], [-117.09191, 32.64933]]]} | Open Access 1 | 7648 | Eucalyptus Park | 18741 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/eucalyptus-park | San Diego 4 | 19.675 | Eucalyptus Park | 0 | Local Park 2 | 4 |
1174 | 1174 | 1173 | {"type": "Polygon", "coordinates": [[[-117.02598, 32.64134], [-117.02555, 32.64146], [-117.02542, 32.64136], [-117.02506, 32.64128], [-117.02482, 32.6413], [-117.02465, 32.64135], [-117.02435, 32.64151], [-117.024, 32.64158], [-117.0237, 32.64159], [-117.02338, 32.64155], [-117.02304, 32.64148], [-117.02367, 32.64097], [-117.02389, 32.64083], [-117.02416, 32.64067], [-117.02445, 32.64054], [-117.02476, 32.64043], [-117.02582, 32.64013], [-117.02586, 32.64032], [-117.02571, 32.64037], [-117.02558, 32.64047], [-117.02553, 32.64053], [-117.02549, 32.64062], [-117.02549, 32.64077], [-117.02552, 32.64086], [-117.0256, 32.641], [-117.02565, 32.64126], [-117.02597, 32.64127], [-117.02598, 32.64134]]]} | Open Access 1 | 7579 | Explorer Park | 18775 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/explorer-park | San Diego 4 | 5.227 | Explorer Park | 0 | Local Park 2 | 4 |
7679 | 7679 | 7678 | {"type": "Polygon", "coordinates": [[[-117.0842, 32.64107], [-117.08447, 32.64177], [-117.08447, 32.64181], [-117.08445, 32.64184], [-117.08276, 32.64232], [-117.08271, 32.64232], [-117.08267, 32.6423], [-117.08239, 32.64157], [-117.0842, 32.64107]]]} | Open Access 1 | 7610 | Friendship Park | 19121 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/friendship-park | San Diego 4 | 3.934 | Friendship Park | 0 | Local Park 2 | 4 |
6761 | 6761 | 6760 | {"type": "Polygon", "coordinates": [[[-117.04643, 32.63539], [-117.04591, 32.63554], [-117.04554, 32.63452], [-117.04553, 32.63446], [-117.04616, 32.63447], [-117.04643, 32.63539]]]} | Open Access 1 | 5199 | Gayle L. McCandliss Park | 30008 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/gayle-l-mccandliss-park | San Diego 4 | 1.542 | Gayle L. McCandliss Park | 0 | Local Park 2 | 4 |
7670 | 7670 | 7669 | {"type": "Polygon", "coordinates": [[[-117.03555, 32.62065], [-117.03358, 32.62121], [-117.03124, 32.61519], [-117.03171, 32.61515], [-117.03228, 32.61506], [-117.03312, 32.61489], [-117.03353, 32.61486], [-117.0336, 32.6149], [-117.03378, 32.61597], [-117.03386, 32.61638], [-117.03555, 32.62065]]]} | Open Access 1 | 7573 | Greg Rogers Park | 19498 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/greg-rogers-park | San Diego 4 | 33.478 | Greg Rogers Park | 0 | Local Park 2 | 4 |
7659 | 7659 | 7658 | {"type": "Polygon", "coordinates": [[[-117.08528, 32.60725], [-117.08416, 32.60756], [-117.08352, 32.60593], [-117.08464, 32.60562], [-117.08528, 32.60725]]]} | Open Access 1 | 7542 | Harborside Park | 19668 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/harborside-park | San Diego 4 | 5.203 | Harborside Park | 0 | Local Park 2 | 4 |
7713 | 7713 | 7712 | {"type": "Polygon", "coordinates": [[[-116.99159, 32.62877], [-116.99156, 32.63051], [-116.99151, 32.63053], [-116.99042, 32.63052], [-116.99007, 32.63055], [-116.99003, 32.63055], [-116.99, 32.63052], [-116.98997, 32.63018], [-116.98997, 32.6297], [-116.98999, 32.6293], [-116.99003, 32.62916], [-116.99003, 32.62908], [-116.99, 32.62902], [-116.98989, 32.62895], [-116.98992, 32.62892], [-116.98993, 32.62876], [-116.99053, 32.62875], [-116.99159, 32.62877]]]} | Open Access 1 | 7798 | Harvest Park | 19721 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/harvest-park | San Diego 4 | 7.303 | Harvest Park | 0 | Local Park 2 | 4 |
7664 | 7664 | 7663 | {"type": "Polygon", "coordinates": [[[-116.99884, 32.62363], [-116.99893, 32.62395], [-116.99896, 32.6242], [-116.99893, 32.62444], [-116.99889, 32.62456], [-116.99876, 32.62483], [-116.99857, 32.62508], [-116.9983, 32.62529], [-116.99806, 32.62543], [-116.99773, 32.62553], [-116.99742, 32.62558], [-116.99708, 32.62557], [-116.99674, 32.6255], [-116.9964, 32.62536], [-116.99622, 32.62524], [-116.99603, 32.62508], [-116.99588, 32.62491], [-116.99578, 32.62474], [-116.9963, 32.62462], [-116.9964, 32.62463], [-116.99639, 32.62456], [-116.9965, 32.62453], [-116.99644, 32.62432], [-116.9964, 32.62432], [-116.99635, 32.62419], [-116.99578, 32.62431], [-116.99574, 32.62435], [-116.99572, 32.62443], [-116.99567, 32.62443], [-116.99563, 32.62432], [-116.99567, 32.62426], [-116.99612, 32.62416], [-116.99878, 32.6236], [-116.99884, 32.62363]]]} | Open Access 1 | 7565 | Heritage Park | 19845 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/heritage-park | San Diego 4 | 10.742 | Heritage Park | 0 | Local Park 2 | 4 |
7676 | 7676 | 7675 | {"type": "Polygon", "coordinates": [[[-117.06542, 32.62775], [-117.06488, 32.62791], [-117.06482, 32.62795], [-117.06501, 32.62845], [-117.06435, 32.62864], [-117.06443, 32.62886], [-117.06356, 32.62911], [-117.06366, 32.62937], [-117.06326, 32.62949], [-117.06297, 32.62877], [-117.06171, 32.62913], [-117.06156, 32.62888], [-117.06072, 32.62796], [-117.06059, 32.62772], [-117.06095, 32.6276], [-117.06109, 32.62792], [-117.06196, 32.62767], [-117.06208, 32.62794], [-117.06237, 32.62787], [-117.06261, 32.62845], [-117.06539, 32.62767], [-117.06542, 32.62775]]]} | Open Access 1 | 7587 | Hilltop Park | 19986 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/hilltop-park | San Diego 4 | 9.411 | Hilltop Park | 0 | Local Park 2 | 4 |
7717 | 7717 | 7716 | {"type": "Polygon", "coordinates": [[[-117.05366, 32.59768], [-117.05361, 32.59768], [-117.05329, 32.59759], [-117.05329, 32.59744], [-117.0533, 32.59742], [-117.05335, 32.59739], [-117.05366, 32.59738], [-117.05366, 32.59768]]]} | Open Access 1 | 7832 | Holiday Estates I Park | 30009 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/holiday-estates-i-park | San Diego 4 | 0.243 | Holiday Estates I Park | 0 | Local Park 2 | 4 |
7699 | 7699 | 7698 | {"type": "Polygon", "coordinates": [[[-117.05534, 32.59767], [-117.05536, 32.59782], [-117.05532, 32.59786], [-117.05497, 32.59788], [-117.05497, 32.59767], [-117.05534, 32.59767]]]} | Open Access 1 | 7773 | Holiday Estates II Park | 20028 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/holiday-estates-ii-park | San Diego 4 | 0.194 | Holiday Estates II 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]);