units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where DES_TP = 2, MNG_AGENCY = 376 and MNG_AG_TYP = 2 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- City Agency · 44 ✖
MNG_AGENCY 1
- Fremont, City of · 44 ✖
DES_TP 1
- Local Park · 44 ✖
ACCESS_TYP 1
- Open Access 44
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8375 | 8375 | 8374 | {"type": "Polygon", "coordinates": [[[-121.93225, 37.50991], [-121.93204, 37.51012], [-121.93181, 37.51023], [-121.93159, 37.51028], [-121.93114, 37.51029], [-121.93086, 37.51035], [-121.93082, 37.51033], [-121.93058, 37.51007], [-121.9304, 37.50992], [-121.93017, 37.50976], [-121.92982, 37.50957], [-121.93049, 37.50885], [-121.93022, 37.50868], [-121.93039, 37.5085], [-121.9304, 37.50844], [-121.9304, 37.50839], [-121.93036, 37.50832], [-121.92988, 37.5079], [-121.92977, 37.50786], [-121.92968, 37.50787], [-121.92962, 37.50789], [-121.92919, 37.50748], [-121.92948, 37.50745], [-121.93084, 37.50722], [-121.93088, 37.50723], [-121.93101, 37.50771], [-121.93102, 37.50784], [-121.93101, 37.50803], [-121.93096, 37.50821], [-121.93089, 37.50837], [-121.9308, 37.5085], [-121.9306, 37.50873], [-121.93058, 37.50878], [-121.93055, 37.50884], [-121.93056, 37.50895], [-121.93061, 37.50899], [-121.93068, 37.50902], [-121.93075, 37.50901], [-121.93081, 37.50899], [-121.93084, 37.50895], [-121.93086, 37.50891], [-121.93083, 37.50881], [-121.93083, 37.50876], [-121.93114, 37.50894], [-121.93204, 37.50965], [-121.932, 37.50975], [-121.93225, 37.50991]]]} | Open Access 1 | 12969 | Arroyo Agua Caliente Park | 15608 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 8.639 | Arroyo Agua Caliente Park | 1973 | Local Park 2 | 4 | |
8378 | 8378 | 8377 | {"type": "Polygon", "coordinates": [[[-121.99645, 37.5323], [-121.99529, 37.53248], [-121.99431, 37.53369], [-121.99277, 37.53289], [-121.99248, 37.53294], [-121.9924, 37.53304], [-121.992, 37.53283], [-121.99219, 37.5326], [-121.99241, 37.53271], [-121.99421, 37.53243], [-121.99502, 37.53145], [-121.99614, 37.53202], [-121.99626, 37.5321], [-121.99629, 37.5321], [-121.99638, 37.53219], [-121.99645, 37.5323]]]} | Open Access 1 | 12972 | Azevada Park | 15739 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 7.832 | Azevada Park | 1973 | Local Park 2 | 4 | |
14287 | 14287 | 14286 | {"type": "Polygon", "coordinates": [[[-122.00741, 37.55856], [-122.00698, 37.55907], [-122.00686, 37.55908], [-122.00678, 37.55875], [-122.00712, 37.55842], [-122.00741, 37.55856]]]} | Open Access 1 | 47144 | Bill Ball Civic Park | 30825 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 0.513 | Bill Ball Civic Park | 0 | Local Park 2 | 4 | |
8383 | 8383 | 8382 | {"type": "Polygon", "coordinates": [[[-121.97573, 37.52674], [-121.97429, 37.52858], [-121.97358, 37.52821], [-121.97261, 37.52945], [-121.97162, 37.53022], [-121.97139, 37.53001], [-121.97252, 37.52912], [-121.97294, 37.52858], [-121.97255, 37.5277], [-121.97245, 37.52753], [-121.97257, 37.52748], [-121.97275, 37.52775], [-121.97308, 37.5276], [-121.97333, 37.52746], [-121.97371, 37.52723], [-121.974, 37.52699], [-121.9746, 37.52647], [-121.97479, 37.52622], [-121.97495, 37.52634], [-121.97573, 37.52674]]]} | Open Access 1 | 12979 | Blacow Park | 16146 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 9.967 | Blacow Park | 1961 | Local Park 2 | 4 | |
1545 | 1545 | 1544 | {"type": "Polygon", "coordinates": [[[-121.92081, 37.47824], [-121.92042, 37.47893], [-121.91967, 37.47868], [-121.91913, 37.47883], [-121.91902, 37.47896], [-121.91873, 37.47891], [-121.91828, 37.47906], [-121.91812, 37.47925], [-121.91824, 37.47946], [-121.91842, 37.47985], [-121.9173, 37.48026], [-121.91631, 37.47851], [-121.91682, 37.47833], [-121.9171, 37.47884], [-121.91744, 37.47892], [-121.91786, 37.47879], [-121.91967, 37.47812], [-121.92003, 37.47831], [-121.92062, 37.47809], [-121.92078, 37.47818], [-121.92081, 37.47821], [-121.92081, 37.47824]]]} | Open Access 1 | 12981 | Booster Park | 16273 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 8.178 | Booster Park | 1973 | Local Park 2 | 4 | |
1748 | 1748 | 1747 | {"type": "Polygon", "coordinates": [[[-122.02309, 37.56793], [-122.02258, 37.5686], [-122.02267, 37.56866], [-122.02253, 37.56884], [-122.02249, 37.56866], [-122.02161, 37.56762], [-122.02176, 37.56748], [-122.02192, 37.56727], [-122.02228, 37.56744], [-122.02242, 37.5676], [-122.02309, 37.56793]]]} | Open Access 1 | 12983 | Brookvale Park | 16436 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 2.344 | Brookvale Park | 0 | Local Park 2 | 4 | |
1546 | 1546 | 1545 | {"type": "Polygon", "coordinates": [[[-121.94629, 37.55413], [-121.94553, 37.55481], [-121.94613, 37.55522], [-121.94594, 37.55538], [-121.94582, 37.55544], [-121.94486, 37.55627], [-121.9447, 37.55637], [-121.94463, 37.55636], [-121.94461, 37.55634], [-121.94456, 37.55617], [-121.94449, 37.55605], [-121.94437, 37.55591], [-121.94414, 37.55573], [-121.94412, 37.55571], [-121.94413, 37.55567], [-121.94596, 37.55405], [-121.94603, 37.55402], [-121.9461, 37.55402], [-121.94629, 37.55413]]]} | Open Access 1 | 12987 | Buena Vista Park | 16491 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 4.54 | Buena Vista Park | 1984 | Local Park 2 | 4 | |
12097 | 12097 | 12096 | {"type": "Polygon", "coordinates": [[[-122.02467, 37.55165], [-122.02422, 37.55191], [-122.02376, 37.5527], [-122.02171, 37.55163], [-122.02252, 37.55065], [-122.02256, 37.55064], [-122.02311, 37.55076], [-122.02333, 37.55084], [-122.02448, 37.55144], [-122.0246, 37.55154], [-122.02467, 37.55165]]]} | Open Access 1 | 24927 | Cabrillo Park | 16639 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 7.699 | Cabrillo Park | 0 | Local Park 2 | 4 | |
1749 | 1749 | 1748 | {"type": "Polygon", "coordinates": [[[-121.99986, 37.58564], [-121.99972, 37.58581], [-121.99965, 37.58593], [-121.99961, 37.58596], [-121.99911, 37.58586], [-121.99892, 37.5858], [-121.99868, 37.58569], [-121.99852, 37.58557], [-121.99854, 37.58553], [-121.99871, 37.58539], [-121.99882, 37.58528], [-121.99909, 37.58507], [-121.99915, 37.58506], [-121.9992, 37.58507], [-121.99985, 37.58559], [-121.99986, 37.58564]]]} | Open Access 1 | 12992 | California Terrace Park | 16729 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 1.669 | California Terrace Park | 1972 | Local Park 2 | 4 | |
17024 | 17024 | 17023 | {"type": "Polygon", "coordinates": [[[-121.99179, 37.55472], [-121.9905, 37.55623], [-121.9886, 37.55525], [-121.98988, 37.55374], [-121.99179, 37.55472]]]} | Open Access 1 | 12994 | Centerville Community Park | 17042 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 10.034 | Centerville Community Park | 1973 | Local Park 2 | 4 | |
8396 | 8396 | 8395 | {"type": "Polygon", "coordinates": [[[-122.03871, 37.56994], [-122.0378, 37.57114], [-122.03777, 37.57116], [-122.03771, 37.57115], [-122.03747, 37.57104], [-122.03656, 37.57059], [-122.03654, 37.57056], [-122.03654, 37.57052], [-122.03739, 37.56944], [-122.03742, 37.56942], [-122.03748, 37.56942], [-122.03784, 37.5696], [-122.03791, 37.56969], [-122.03796, 37.56972], [-122.03807, 37.56973], [-122.03816, 37.56968], [-122.03871, 37.56994]]]} | Open Access 1 | 12995 | Crandall Creek Park | 17755 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 4.975 | Crandall Creek Park | 0 | Local Park 2 | 4 | |
1552 | 1552 | 1551 | {"type": "Polygon", "coordinates": [[[-122.05715, 37.57857], [-122.05566, 37.58029], [-122.05467, 37.57972], [-122.0569, 37.57843], [-122.05715, 37.57857]]]} | Open Access 1 | 13000 | David Jones Park | 17942 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 3.885 | David Jones Park | 0 | Local Park 2 | 4 | |
8398 | 8398 | 8397 | {"type": "Polygon", "coordinates": [[[-122.05496, 37.57223], [-122.05499, 37.57249], [-122.05499, 37.57273], [-122.05497, 37.57297], [-122.05493, 37.57321], [-122.05485, 37.5735], [-122.05477, 37.57373], [-122.05464, 37.57401], [-122.05455, 37.57415], [-122.05448, 37.57416], [-122.05421, 37.57405], [-122.05391, 37.57397], [-122.05365, 37.57394], [-122.05331, 37.57392], [-122.05311, 37.57388], [-122.05294, 37.57382], [-122.05276, 37.57373], [-122.05264, 37.57364], [-122.0525, 37.57351], [-122.05259, 37.57347], [-122.05274, 37.57346], [-122.05285, 37.57343], [-122.05319, 37.57346], [-122.05333, 37.57339], [-122.05342, 37.57329], [-122.05358, 37.57329], [-122.05367, 37.57325], [-122.05372, 37.57318], [-122.05375, 37.57302], [-122.0537, 37.57285], [-122.05381, 37.57279], [-122.05384, 37.57267], [-122.05399, 37.57252], [-122.05388, 37.57243], [-122.05387, 37.5724], [-122.05397, 37.57215], [-122.05444, 37.57221], [-122.0549, 37.57219], [-122.05494, 37.5722], [-122.05496, 37.57223]]]} | Open Access 1 | 13002 | Deep Creek Park | 17989 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 6.262 | Deep Creek Park | 0 | Local Park 2 | 4 | |
1750 | 1750 | 1749 | {"type": "Polygon", "coordinates": [[[-122.05236, 37.563], [-122.05088, 37.56366], [-122.05082, 37.56366], [-122.0508, 37.56363], [-122.05065, 37.56333], [-122.05049, 37.56307], [-122.04975, 37.56215], [-122.04974, 37.5621], [-122.04977, 37.56207], [-122.05135, 37.56137], [-122.05134, 37.56142], [-122.05139, 37.56149], [-122.05143, 37.56163], [-122.05144, 37.56184], [-122.0515, 37.56193], [-122.0515, 37.56194], [-122.05152, 37.56199], [-122.05152, 37.56203], [-122.0515, 37.56209], [-122.0515, 37.56214], [-122.05159, 37.56222], [-122.05178, 37.56243], [-122.05188, 37.56251], [-122.05199, 37.5625], [-122.05206, 37.56253], [-122.05209, 37.56256], [-122.05212, 37.56261], [-122.05214, 37.56275], [-122.05218, 37.56284], [-122.05229, 37.56299], [-122.05236, 37.563]]]} | Open Access 1 | 13004 | Frank Fischer Park | 19049 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 7.271 | Frank Fischer Park | 0 | Local Park 2 | 4 | |
8402 | 8402 | 8401 | {"type": "Polygon", "coordinates": [[[-121.972, 37.54942], [-121.97136, 37.54931], [-121.97107, 37.54946], [-121.971, 37.54955], [-121.97097, 37.54961], [-121.97093, 37.54977], [-121.97094, 37.54979], [-121.97094, 37.54984], [-121.97093, 37.5499], [-121.97077, 37.55006], [-121.97076, 37.55014], [-121.97083, 37.55028], [-121.97082, 37.55037], [-121.97077, 37.5504], [-121.97068, 37.55044], [-121.97046, 37.55049], [-121.9703, 37.55049], [-121.97025, 37.55042], [-121.97009, 37.55037], [-121.96983, 37.55023], [-121.96929, 37.54991], [-121.96868, 37.55068], [-121.96839, 37.55055], [-121.96807, 37.55094], [-121.96809, 37.55099], [-121.96832, 37.55113], [-121.96849, 37.55131], [-121.9683, 37.55134], [-121.96813, 37.5514], [-121.96804, 37.55148], [-121.96782, 37.5517], [-121.96766, 37.55183], [-121.96768, 37.55131], [-121.96766, 37.55126], [-121.9675, 37.55123], [-121.96659, 37.55124], [-121.96657, 37.55185], [-121.96719, 37.55215], [-121.96743, 37.55221], [-121.96833, 37.55299], [-121.96844, 37.55312], [-121.96875, 37.55359], [-121.96409, 37.55553], [-121.96375, 37.5557], [-121.96344, 37.5559], [-121.9589, 37.5593], [-121.95693, 37.54698], [-121.95619, 37.54193], [-121.9561, 37.54143], [-121.95718, 37.54123], [-121.95785, 37.54113], [-121.95832, 37.54112], [-121.9586, 37.54114], [-121.95943, 37.54126], [-121.95985, 37.54138], [-121.96025, 37.54155], [-121.9605, 37.54169], [-121.96079, 37.54191], [-121.96262, 37.54352], [-121.9631, 37.54383], [-121.96535, 37.54521], [-121.96653, 37.54597], [-121.96692, 37.54625], [-121.96715, 37.54644], [-121.96795, 37.54695], [-121.96898, 37.54754], [-121.96898, 37.54758], [-121.97169, 37.54896], [-121.9718, 37.54904], [-121.9719, 37.54917], [-121.97196, 37.54927], [-121.972, 37.54942]]]} | Open Access 1 | 13006 | Fremont Central Park | 3837 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | https://www.fremont.gov/317/Central-Park | Alameda 17 | 352.046 | Fremont Central Park | 1960 | Local Park 2 | 4 |
8403 | 8403 | 8402 | {"type": "Polygon", "coordinates": [[[-121.95484, 37.55058], [-121.95467, 37.55059], [-121.95169, 37.55095], [-121.95126, 37.55128], [-121.94894, 37.54939], [-121.95022, 37.54841], [-121.95122, 37.54927], [-121.95149, 37.54909], [-121.95151, 37.54916], [-121.95122, 37.54937], [-121.95178, 37.54986], [-121.952, 37.55015], [-121.95214, 37.55027], [-121.95256, 37.55029], [-121.9527, 37.55019], [-121.9527, 37.55017], [-121.95249, 37.54998], [-121.95253, 37.54993], [-121.95267, 37.55001], [-121.95322, 37.54998], [-121.95323, 37.55005], [-121.95321, 37.5501], [-121.95284, 37.55012], [-121.9529, 37.55039], [-121.95325, 37.55056], [-121.95364, 37.55051], [-121.95388, 37.55026], [-121.95384, 37.55001], [-121.95413, 37.54999], [-121.9542, 37.54991], [-121.95428, 37.54994], [-121.95436, 37.54993], [-121.95478, 37.54996], [-121.95484, 37.55058]]]} | Open Access 1 | 13008 | Gomes Park | 19388 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 14.299 | Gomes Park | 1973 | Local Park 2 | 4 | |
8404 | 8404 | 8403 | {"type": "Polygon", "coordinates": [[[-121.96531, 37.52284], [-121.96529, 37.52287], [-121.96284, 37.52318], [-121.96261, 37.52202], [-121.9627, 37.52208], [-121.96279, 37.52207], [-121.96264, 37.52125], [-121.96266, 37.52125], [-121.96269, 37.5213], [-121.96274, 37.52134], [-121.96285, 37.52135], [-121.96292, 37.52133], [-121.96302, 37.52128], [-121.96456, 37.52108], [-121.96467, 37.52109], [-121.96475, 37.52112], [-121.96481, 37.52118], [-121.96512, 37.5216], [-121.9652, 37.52172], [-121.96526, 37.52188], [-121.96531, 37.52216], [-121.96528, 37.52259], [-121.96531, 37.52284]]]} | Open Access 1 | 13009 | Irvington Park | 20273 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 11.073 | Irvington Park | 1961 | Local Park 2 | 4 | |
8405 | 8405 | 8404 | {"type": "Polygon", "coordinates": [[[-121.95991, 37.53298], [-121.95978, 37.53314], [-121.95949, 37.53297], [-121.95991, 37.53298], [-121.95991, 37.53298]]]} | Open Access 1 | 13011 | Irvington Plaza | 20274 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 0.081 | Irvington Plaza | 1961 | Local Park 2 | 4 | |
14422 | 14422 | 14421 | {"type": "Polygon", "coordinates": [[[-122.01603, 37.57645], [-122.01558, 37.57708], [-122.01482, 37.57828], [-122.01426, 37.57913], [-122.01383, 37.58023], [-122.0133, 37.58059], [-122.01315, 37.58062], [-122.01319, 37.5807], [-122.01219, 37.58083], [-122.01105, 37.58063], [-122.0093, 37.57964], [-122.00936, 37.57947], [-122.00837, 37.57903], [-122.00827, 37.5793], [-122.00815, 37.57902], [-122.00809, 37.57874], [-122.00807, 37.57854], [-122.00812, 37.57821], [-122.00819, 37.578], [-122.00833, 37.57772], [-122.00854, 37.57745], [-122.00876, 37.57728], [-122.00896, 37.57717], [-122.00997, 37.57828], [-122.01028, 37.57847], [-122.01069, 37.57891], [-122.01548, 37.57662], [-122.01556, 37.57638], [-122.0156, 37.5762], [-122.01603, 37.57645]]]} | Open Access 1 | 47141 | Isherwood Park | 30822 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 37.007 | Isherwood Park | 0 | Local Park 2 | 4 | |
8406 | 8406 | 8405 | {"type": "Polygon", "coordinates": [[[-121.91653, 37.47485], [-121.9162, 37.47533], [-121.91599, 37.47559], [-121.91525, 37.47665], [-121.91428, 37.47497], [-121.91463, 37.47484], [-121.91467, 37.47477], [-121.91475, 37.47478], [-121.91483, 37.47476], [-121.91488, 37.47472], [-121.91491, 37.47465], [-121.91526, 37.47444], [-121.91566, 37.47425], [-121.91605, 37.47455], [-121.91651, 37.4748], [-121.91653, 37.47485]]]} | Open Access 1 | 13013 | Lone Tree Creek Park | 21442 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 6.426 | Lone Tree Creek Park | 1973 | 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]);