units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 sorted by rowid descending
This data as json, copyable, CSV (advanced)
DES_TP >30
ACCESS_TYP 2
- Open Access 231
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 233
MNG_AGENCY 1
- San Jose, City of · 233 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14029 | 14029 | 14028 | {"type": "Polygon", "coordinates": [[[-121.88207, 37.25467], [-121.88187, 37.25473], [-121.88159, 37.25404], [-121.88169, 37.254], [-121.88176, 37.25392], [-121.88207, 37.25467]]]} | Open Access 1 | 38025 | Russo Park | 24747 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.386 | Russo Park | 0 | Local Park 2 | 4 | |
14028 | 14028 | 14027 | {"type": "Polygon", "coordinates": [[[-121.89024, 37.36141], [-121.88965, 37.36147], [-121.88895, 37.36154], [-121.89005, 37.36072], [-121.89015, 37.36081], [-121.89024, 37.36141]]]} | Open Access 1 | 38024 | Luna Park | 21595 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.178 | Luna Park | 0 | Local Park 2 | 4 | |
14027 | 14027 | 14026 | {"type": "Polygon", "coordinates": [[[-121.93192, 37.40428], [-121.93187, 37.40434], [-121.93178, 37.40435], [-121.92938, 37.40376], [-121.92932, 37.40372], [-121.92931, 37.40366], [-121.92942, 37.4035], [-121.92955, 37.40337], [-121.92971, 37.40326], [-121.9299, 37.40318], [-121.93015, 37.40311], [-121.93042, 37.40307], [-121.93068, 37.40308], [-121.93095, 37.40313], [-121.93119, 37.40321], [-121.93131, 37.40327], [-121.93152, 37.4034], [-121.9317, 37.40356], [-121.93182, 37.40372], [-121.93189, 37.40387], [-121.93193, 37.40412], [-121.93192, 37.40428]]]} | Open Access 1 | 38023 | River Oaks Park | 24414 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 4.994 | River Oaks Park | 0 | Local Park 2 | 4 | |
14026 | 14026 | 14025 | {"type": "Polygon", "coordinates": [[[-121.89165, 37.39019], [-121.89118, 37.39055], [-121.8907, 37.39015], [-121.89062, 37.39011], [-121.89063, 37.39005], [-121.89058, 37.39004], [-121.89058, 37.39001], [-121.89066, 37.38996], [-121.8907, 37.38986], [-121.891, 37.38967], [-121.89106, 37.38966], [-121.8911, 37.38967], [-121.89163, 37.39012], [-121.89165, 37.39015], [-121.89165, 37.39019]]]} | Open Access 1 | 38022 | Gran Paradiso Park | 19416 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.245 | Gran Paradiso Park | 0 | Local Park 2 | 4 | |
14025 | 14025 | 14024 | {"type": "MultiPolygon", "coordinates": [[[[-121.82812, 37.30669], [-121.82394, 37.30932], [-121.82371, 37.30909], [-121.82499, 37.30827], [-121.82783, 37.3065], [-121.82788, 37.30649], [-121.82792, 37.3065], [-121.82812, 37.30669]]], [[[-121.83241, 37.30382], [-121.82836, 37.30653], [-121.82817, 37.30634], [-121.82816, 37.30629], [-121.82819, 37.30626], [-121.83201, 37.30371], [-121.83206, 37.3037], [-121.83227, 37.30378], [-121.83241, 37.30382]]]]} | Open Access 1 | 38016 | Umbarger Pathway | 26650 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 7.564 | Umbarger Pathway | None 1198 | |||
14024 | 14024 | 14023 | {"type": "MultiPolygon", "coordinates": [[[[-121.81736, 37.31364], [-121.8153, 37.31502], [-121.81397, 37.31591], [-121.81404, 37.31557], [-121.81408, 37.31554], [-121.81431, 37.31549], [-121.81447, 37.31539], [-121.81459, 37.31525], [-121.81465, 37.31511], [-121.81476, 37.31501], [-121.81491, 37.31494], [-121.8152, 37.31489], [-121.81535, 37.31481], [-121.81609, 37.31431], [-121.81679, 37.31386], [-121.81692, 37.31374], [-121.81701, 37.31356], [-121.81708, 37.31349], [-121.81717, 37.31348], [-121.81725, 37.31355], [-121.81727, 37.31354], [-121.81736, 37.31364]]], [[[-121.8212, 37.31105], [-121.8176, 37.31346], [-121.8174, 37.31329], [-121.81739, 37.31326], [-121.81741, 37.31321], [-121.81755, 37.31312], [-121.81769, 37.31306], [-121.81803, 37.31296], [-121.8182, 37.31289], [-121.81946, 37.31205], [-121.81964, 37.31189], [-121.81983, 37.3116], [-121.82001, 37.31145], [-121.8202, 37.31136], [-121.82077, 37.31116], [-121.82105, 37.311], [-121.82113, 37.311], [-121.8212, 37.31105]]]]} | Open Access 1 | 38015 | Barberry Pathway | 15808 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 3.881 | Barberry Pathway | None 1197 | |||
14021 | 14021 | 14020 | {"type": "Polygon", "coordinates": [[[-121.92579, 37.34618], [-121.92523, 37.34688], [-121.92464, 37.34658], [-121.92459, 37.34652], [-121.92451, 37.3465], [-121.92532, 37.34595], [-121.92579, 37.34618]]]} | Open Access 1 | 38012 | Newhall Park | 22725 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.428 | Newhall Park | 0 | Local Park 2 | 4 | |
14020 | 14020 | 14019 | {"type": "Polygon", "coordinates": [[[-121.91633, 37.30724], [-121.91633, 37.30735], [-121.91628, 37.30751], [-121.91606, 37.30781], [-121.91582, 37.30782], [-121.91582, 37.30733], [-121.91601, 37.30733], [-121.91602, 37.3072], [-121.91633, 37.30718], [-121.91633, 37.30724]]]} | Open Access 1 | 38011 | St. Elizabeth Park | 25765 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.581 | St. Elizabeth Park | 0 | Local Park 2 | 4 | |
14019 | 14019 | 14018 | {"type": "MultiPolygon", "coordinates": [[[[-121.89295, 37.31787], [-121.89295, 37.31797], [-121.89085, 37.31787], [-121.89085, 37.31778], [-121.89295, 37.31787]]], [[[-121.89597, 37.31798], [-121.89596, 37.31807], [-121.89363, 37.31799], [-121.89363, 37.31789], [-121.89597, 37.31798]]], [[[-121.89742, 37.31803], [-121.89731, 37.31856], [-121.8972, 37.31855], [-121.89721, 37.31839], [-121.89724, 37.31838], [-121.89727, 37.31802], [-121.89742, 37.31803]]]]} | Open Access 1 | 38010 | Fuller Park | 28012 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.195 | Fuller Park | 0 | Local Park 2 | 4 | |
14018 | 14018 | 14017 | {"type": "Polygon", "coordinates": [[[-121.86189, 37.28614], [-121.86177, 37.28619], [-121.8615, 37.28635], [-121.86099, 37.28584], [-121.86112, 37.28576], [-121.86125, 37.28585], [-121.8614, 37.28593], [-121.86153, 37.28599], [-121.86178, 37.28605], [-121.86189, 37.28614]]]} | Open Access 1 | 38009 | Tuscany Hills Overlook Park | 26600 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.482 | Tuscany Hills Overlook Park | 0 | Local Park 2 | 4 | |
13065 | 13065 | 13064 | {"type": "Polygon", "coordinates": [[[-121.77292, 37.304], [-121.7721, 37.30412], [-121.77199, 37.30358], [-121.77225, 37.30356], [-121.77279, 37.30349], [-121.77279, 37.30353], [-121.77283, 37.3036], [-121.77292, 37.304]]]} | Open Access 1 | 34937 | Falls Creek Park | 18838 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.053 | Falls Creek Park | 0 | Local Park 2 | 4 | |
12515 | 12515 | 12514 | {"type": "Polygon", "coordinates": [[[-121.87386, 37.3113], [-121.87152, 37.31279], [-121.87136, 37.31263], [-121.87365, 37.31109], [-121.87386, 37.3113]]]} | Open Access 1 | 28350 | Bellevue Park | 15987 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.763 | Bellevue Park | 0 | Local Park 2 | 4 | |
12510 | 12510 | 12509 | {"type": "Polygon", "coordinates": [[[-121.85504, 37.31493], [-121.85362, 37.31586], [-121.85394, 37.31607], [-121.8543, 37.31623], [-121.85453, 37.31642], [-121.85461, 37.31658], [-121.85444, 37.31664], [-121.85458, 37.31695], [-121.8546, 37.31739], [-121.85467, 37.31745], [-121.85459, 37.31752], [-121.85452, 37.31752], [-121.85442, 37.31764], [-121.8527, 37.31876], [-121.85175, 37.31941], [-121.85185, 37.31915], [-121.85188, 37.31865], [-121.85183, 37.31831], [-121.8516, 37.31773], [-121.85171, 37.31746], [-121.85158, 37.31703], [-121.8514, 37.31667], [-121.85079, 37.31652], [-121.84976, 37.31696], [-121.84901, 37.31766], [-121.84836, 37.31805], [-121.84693, 37.31777], [-121.84644, 37.3174], [-121.84633, 37.31727], [-121.84665, 37.31706], [-121.8465, 37.3166], [-121.84646, 37.3159], [-121.84642, 37.31575], [-121.8461, 37.31501], [-121.8459, 37.3143], [-121.84574, 37.31409], [-121.84536, 37.31386], [-121.84385, 37.31327], [-121.84309, 37.31261], [-121.84276, 37.31197], [-121.8424, 37.31155], [-121.84415, 37.31039], [-121.84419, 37.3105], [-121.84432, 37.31042], [-121.84442, 37.31062], [-121.8444, 37.31099], [-121.84452, 37.31122], [-121.8447, 37.31142], [-121.84459, 37.31149], [-121.84417, 37.31191], [-121.84409, 37.31207], [-121.84407, 37.3122], [-121.84411, 37.31234], [-121.84419, 37.31246], [-121.84436, 37.31257], [-121.84497, 37.31281], [-121.8452, 37.31294], [-121.8453, 37.31303], [-121.84533, 37.31299], [-121.84563, 37.31308], [-121.84574, 37.31317], [-121.8458, 37.31315], [-121.84602, 37.31327], [-121.8461, 37.31328], [-121.8462, 37.31332], [-121.84658, 37.31343], [-121.84692, 37.31356], [-121.84697, 37.31357], [-121.84766, 37.31475], [-121.84764, 37.31497], [-121.84771, 37.31508], [-121.84776, 37.31542], [-121.84775, 37.31559], [-121.84777, 37.31566], [-121.84775, 37.31568], [-121.84776, 37.31575], [-121.84775, 37.31581], [-121.84778, 37.31594], [-121.8479, 37.3161], [-121.84815, 37.31621], [-121.84838, 37.31626], [-121.84864, 37.31629], [-121.84892, 37.31627], [-121.84912, 37.31622], [-121.84939, 37.31605], [-121.84985, 37.31584], [-121.85022, 37.3156], [-121.85106, 37.31535], [-121.85176, 37.3151], [-121.85212, 37.31495], [-121.85244, 37.31494], [-121.85297, 37.31454], [-121.85402, 37.31395], [-121.85504, 37.31493]]]} | Open Access 1 | 28340 | Coyote Creek Park | 17738 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 65.935 | Coyote Creek Park | 0 | Local Park 2 | 4 | |
10641 | 10641 | 10640 | {"type": "Polygon", "coordinates": [[[-121.81329, 37.2961], [-121.81329, 37.29614], [-121.81326, 37.29617], [-121.813, 37.29628], [-121.8123, 37.29672], [-121.81215, 37.29673], [-121.81209, 37.29676], [-121.81183, 37.29657], [-121.8116, 37.29678], [-121.81166, 37.29689], [-121.81147, 37.29697], [-121.8112, 37.29654], [-121.81095, 37.296], [-121.81176, 37.29608], [-121.81177, 37.29603], [-121.81215, 37.29608], [-121.81219, 37.29596], [-121.81212, 37.29593], [-121.81214, 37.2958], [-121.81162, 37.29575], [-121.81164, 37.29567], [-121.81144, 37.29564], [-121.81136, 37.29534], [-121.8115, 37.29542], [-121.81162, 37.29542], [-121.81168, 37.29539], [-121.81192, 37.2952], [-121.81204, 37.29513], [-121.81297, 37.29488], [-121.81301, 37.29489], [-121.81304, 37.29493], [-121.81321, 37.29533], [-121.81324, 37.29546], [-121.81325, 37.29588], [-121.81329, 37.2961]]]} | Open Access 1 | 18969 | Ramblewood Park | 24107 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 6.423 | Ramblewood Park | 1985 | Local Park 2 | 4 | |
10636 | 10636 | 10635 | {"type": "Polygon", "coordinates": [[[-122.00954, 37.30075], [-122.00901, 37.30197], [-122.00665, 37.30109], [-122.0066, 37.30106], [-122.00659, 37.30103], [-122.00702, 37.29988], [-122.0071, 37.29985], [-122.00954, 37.30075]]]} | Open Access 1 | 18961 | Rainbow | 24083 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 8.476 | Rainbow | 1991 | None 935 | ||
10602 | 10602 | 10601 | {"type": "MultiPolygon", "coordinates": [[[[-121.84854, 37.33749], [-121.84887, 37.3379], [-121.8491, 37.33822], [-121.84929, 37.33856], [-121.84935, 37.33868], [-121.84938, 37.33879], [-121.84943, 37.33902], [-121.84944, 37.33937], [-121.84938, 37.33971], [-121.84926, 37.34004], [-121.84918, 37.3402], [-121.84898, 37.3405], [-121.84872, 37.34077], [-121.84858, 37.3409], [-121.84842, 37.34101], [-121.84743, 37.3415], [-121.84717, 37.34166], [-121.84693, 37.34183], [-121.84657, 37.34214], [-121.84646, 37.34227], [-121.84626, 37.34255], [-121.84616, 37.3426], [-121.84605, 37.34258], [-121.84574, 37.34232], [-121.84535, 37.34196], [-121.84525, 37.34201], [-121.84372, 37.34042], [-121.84377, 37.34038], [-121.84366, 37.34027], [-121.84406, 37.34001], [-121.84375, 37.33969], [-121.84555, 37.33847], [-121.84561, 37.33847], [-121.84567, 37.33849], [-121.84612, 37.33894], [-121.84625, 37.33898], [-121.84637, 37.33895], [-121.84854, 37.33749]]], [[[-121.84725, 37.33818], [-121.84633, 37.33882], [-121.84629, 37.33883], [-121.84623, 37.33882], [-121.84617, 37.33879], [-121.84582, 37.33842], [-121.84579, 37.33838], [-121.8458, 37.33834], [-121.84582, 37.3383], [-121.84638, 37.3379], [-121.84671, 37.33763], [-121.84725, 37.33818]]]]} | Open Access 1 | 18900 | Emma Prusch Farm Park | 18630 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 41.775 | Emma Prusch Farm Park | 1983 | Local Park 2 | 4 | |
10535 | 10535 | 10534 | {"type": "Polygon", "coordinates": [[[-121.88902, 37.33131], [-121.88912, 37.33132], [-121.88924, 37.33138], [-121.88939, 37.3315], [-121.88951, 37.33163], [-121.89039, 37.33279], [-121.89041, 37.33286], [-121.89041, 37.33293], [-121.89037, 37.333], [-121.89033, 37.33304], [-121.89023, 37.33308], [-121.89014, 37.33309], [-121.89003, 37.33307], [-121.88994, 37.33301], [-121.88886, 37.33158], [-121.88884, 37.33149], [-121.88886, 37.33142], [-121.88893, 37.33135], [-121.88902, 37.33131]]]} | Open Access 1 | 18747 | Plaza de Ceasr Chavez | 23778 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 2.432 | Plaza de Ceasr Chavez | 1988 | None 924 | ||
10533 | 10533 | 10532 | {"type": "Polygon", "coordinates": [[[-121.85019, 37.25398], [-121.85019, 37.25444], [-121.85016, 37.25448], [-121.84869, 37.25448], [-121.84852, 37.25447], [-121.84847, 37.25442], [-121.8485, 37.2543], [-121.84877, 37.25364], [-121.84912, 37.25368], [-121.84947, 37.25375], [-121.84951, 37.25381], [-121.84958, 37.25384], [-121.84965, 37.25384], [-121.84974, 37.25381], [-121.84978, 37.25381], [-121.85002, 37.25388], [-121.85017, 37.25395], [-121.85019, 37.25398]]]} | Open Access 1 | 18743 | Playa Del Rey Park | 23774 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 2.792 | Playa Del Rey Park | 1978 | Local Park 2 | 4 | |
10529 | 10529 | 10528 | {"type": "Polygon", "coordinates": [[[-121.86047, 37.35798], [-121.86039, 37.35799], [-121.85985, 37.35783], [-121.85954, 37.35777], [-121.85736, 37.35764], [-121.85711, 37.35765], [-121.85691, 37.35767], [-121.85672, 37.35771], [-121.85651, 37.35778], [-121.85668, 37.35763], [-121.8588, 37.3562], [-121.85878, 37.35623], [-121.85879, 37.35626], [-121.86046, 37.35796], [-121.86047, 37.35798]]]} | Open Access 1 | 18733 | Plata Arroyo | 23771 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 6.812 | Plata Arroyo | 1980 | None 922 | ||
10481 | 10481 | 10480 | {"type": "Polygon", "coordinates": [[[-121.86155, 37.37723], [-121.86155, 37.37723], [-121.86087, 37.37798], [-121.86118, 37.37735], [-121.8611, 37.37702], [-121.86118, 37.37684], [-121.86155, 37.37723]]]} | Open Access 1 | 18595 | Penitencia Creek Park Chain | 23584 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.518 | Penitencia Creek Park Chain | None 916 |
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]);