units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where MNG_AGENCY = 28 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- San Mateo County Parks and Recreation Dept., County of · 5 ✖
ACCESS_TYP 1
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12495 | 12495 | 12494 | {"type": "Polygon", "coordinates": [[[-122.52068, 37.57395], [-122.5207, 37.57409], [-122.52068, 37.57423], [-122.52049, 37.57446], [-122.52045, 37.5746], [-122.52045, 37.57474], [-122.52041, 37.57488], [-122.52041, 37.57516], [-122.52039, 37.57534], [-122.52036, 37.57543], [-122.52028, 37.57555], [-122.52011, 37.5756], [-122.51993, 37.57562], [-122.51977, 37.57568], [-122.51955, 37.57583], [-122.51938, 37.57596], [-122.51928, 37.57608], [-122.51913, 37.57616], [-122.51896, 37.57617], [-122.51879, 37.57615], [-122.51857, 37.57594], [-122.5184, 37.57591], [-122.51827, 37.576], [-122.51823, 37.57613], [-122.51813, 37.57625], [-122.51807, 37.57638], [-122.51807, 37.57665], [-122.51792, 37.57706], [-122.51791, 37.57719], [-122.51796, 37.57749], [-122.5179, 37.57762], [-122.51782, 37.57797], [-122.51776, 37.57816], [-122.5177, 37.57843], [-122.51745, 37.579], [-122.51746, 37.57938], [-122.51754, 37.57964], [-122.51755, 37.57985], [-122.51739, 37.58021], [-122.51736, 37.58083], [-122.51732, 37.58094], [-122.51717, 37.58118], [-122.51792, 37.58123], [-122.5179, 37.58134], [-122.51788, 37.58139], [-122.51781, 37.58143], [-122.51776, 37.58149], [-122.51763, 37.58155], [-122.51756, 37.58159], [-122.51742, 37.58163], [-122.51707, 37.58186], [-122.51697, 37.58198], [-122.5169, 37.58202], [-122.51679, 37.58224], [-122.51678, 37.5823], [-122.51679, 37.58252], [-122.51686, 37.58256], [-122.51689, 37.58262], [-122.51688, 37.58273], [-122.51683, 37.58286], [-122.51683, 37.58292], [-122.51681, 37.58309], [-122.51685, 37.58315], [-122.51683, 37.58321], [-122.51688, 37.58343], [-122.51699, 37.58362], [-122.51714, 37.58378], [-122.51722, 37.58394], [-122.51722, 37.58401], [-122.51732, 37.58413], [-122.51736, 37.58426], [-122.51738, 37.5845], [-122.51734, 37.58463], [-122.51735, 37.58474], [-122.51733, 37.58489], [-122.51728, 37.58502], [-122.51721, 37.58515], [-122.51649, 37.58524], [-122.51604, 37.58525], [-122.51123, 37.58564], [-122.51071, 37.58567], [-122.51024, 37.58562], [-122.50897, 37.58527], [-122.50853, 37.58519], [-122.50822, 37.58515], [-122.5083, 37.58473], [-122.50945, 37.58484], [-122.50993, 37.58514], [-122.5102, 37.58521], [-122.51044, 37.58524], [-122.51072, 37.58526], [-122.51099, 37.58498], [-122.51182, 37.5849], [-122.5124, 37.58521], [-122.51398, 37.58507], [-122.5145, 37.58471], [-122.51438, 37.58321], [-122.51384, 37.58307], [-122.51344, 37.58178], [-122.5137, 37.58153], [-122.51392, 37.58135], [-122.51579, 37.57957], [-122.51601, 37.57904], [-122.51579, 37.57652], [-122.51668, 37.57545], [-122.51754, 37.57485], [-122.51768, 37.57465], [-122.51773, 37.57453], [-122.51776, 37.57432], [-122.51774, 37.57417], [-122.5177, 37.57405], [-122.51761, 37.5739], [-122.51747, 37.57374], [-122.51676, 37.57321], [-122.51655, 37.57299], [-122.51597, 37.57218], [-122.51591, 37.57184], [-122.51591, 37.5715], [-122.51594, 37.5714], [-122.516, 37.57076], [-122.51611, 37.57074], [-122.51612, 37.57058], [-122.5161, 37.57038], [-122.51606, 37.57026], [-122.51596, 37.57005], [-122.5159, 37.56996], [-122.51539, 37.56936], [-122.51636, 37.56913], [-122.51627, 37.56923], [-122.5163, 37.56937], [-122.5164, 37.56949], [-122.51656, 37.56953], [-122.51691, 37.56956], [-122.51709, 37.56956], [-122.51724, 37.56962], [-122.51736, 37.56972], [-122.51737, 37.56986], [-122.51732, 37.57], [-122.51706, 37.57037], [-122.51696, 37.57048], [-122.51694, 37.57062], [-122.51689, 37.57075], [-122.51699, 37.57086], [-122.51713, 37.57095], [-122.51728, 37.57101], [-122.51762, 37.57096], [-122.51778, 37.57101], [-122.51793, 37.57094], [-122.51808, 37.57102], [-122.51824, 37.57107], [-122.51837, 37.57117], [-122.51845, 37.57129], [-122.51831, 37.57154], [-122.51804, 37.57171], [-122.51818, 37.57178], [-122.51825, 37.57191], [-122.5184, 37.57198], [-122.51851, 37.57209], [-122.51865, 37.57216], [-122.51874, 37.57228], [-122.51852, 37.5725], [-122.51835, 37.57253], [-122.51817, 37.57255], [-122.51771, 37.57273], [-122.51764, 37.57286], [-122.5178, 37.5731], [-122.51798, 37.57314], [-122.51813, 37.57321], [-122.5183, 37.57323], [-122.51845, 37.57316], [-122.51854, 37.57328], [-122.51856, 37.57342], [-122.51851, 37.57354], [-122.51852, 37.57356], [-122.51868, 37.57356], [-122.51876, 37.57344], [-122.51886, 37.57333], [-122.51902, 37.5734], [-122.51905, 37.57354], [-122.51898, 37.57365], [-122.51898, 37.57366], [-122.51913, 37.57371], [-122.51929, 37.57366], [-122.51938, 37.57354], [-122.51955, 37.57354], [-122.51971, 37.57361], [-122.51987, 37.57356], [-122.52004, 37.57357], [-122.5202, 37.57364], [-122.52025, 37.57377], [-122.52024, 37.57391], [-122.52057, 37.57384], [-122.52068, 37.57395]]]} | Open Access 1 | 46890 | Devil's Slide Trail | 30387 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://parks.smcgov.org/devils-slide-trail | San Mateo 15 | 99.15 | Devil's Slide Trail | 0 | Local Recreation Area 3 | 4 |
12581 | 12581 | 12580 | {"type": "Polygon", "coordinates": [[[-122.39077, 37.18393], [-122.39073, 37.18394], [-122.39048, 37.18419], [-122.3904, 37.18422], [-122.39031, 37.18422], [-122.3899, 37.18409], [-122.38951, 37.18398], [-122.38911, 37.18389], [-122.38871, 37.18383], [-122.38428, 37.18345], [-122.38344, 37.18335], [-122.38282, 37.18325], [-122.38249, 37.18217], [-122.38261, 37.18223], [-122.38278, 37.18226], [-122.38295, 37.18226], [-122.38312, 37.18222], [-122.3833, 37.18223], [-122.38342, 37.18233], [-122.38375, 37.18242], [-122.38392, 37.18241], [-122.38409, 37.18242], [-122.38424, 37.18249], [-122.38441, 37.18253], [-122.38451, 37.18263], [-122.38468, 37.18263], [-122.385, 37.18275], [-122.38512, 37.18285], [-122.38527, 37.18291], [-122.38539, 37.18301], [-122.38555, 37.18308], [-122.38568, 37.18317], [-122.38602, 37.18326], [-122.38619, 37.18325], [-122.38633, 37.18333], [-122.38667, 37.18331], [-122.38698, 37.18318], [-122.38714, 37.18315], [-122.38748, 37.18322], [-122.38783, 37.18321], [-122.388, 37.18317], [-122.38814, 37.1831], [-122.3883, 37.18304], [-122.38845, 37.18296], [-122.38897, 37.18297], [-122.38925, 37.18279], [-122.38941, 37.18278], [-122.38955, 37.18287], [-122.3897, 37.18293], [-122.38982, 37.18304], [-122.38999, 37.18305], [-122.39012, 37.18314], [-122.3903, 37.18314], [-122.39056, 37.18312], [-122.39077, 37.18393]]]} | Open Access 1 | 46893 | Pigeon Point County Park | 30390 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 15.218 | Pigeon Point County Park | 2000 | Local Park 2 | 4 | |
12669 | 12669 | 12668 | {"type": "MultiPolygon", "coordinates": [[[[-122.46492, 37.5095], [-122.46477, 37.50991], [-122.46465, 37.51006], [-122.4644, 37.5103], [-122.46427, 37.51052], [-122.46356, 37.5129], [-122.46303, 37.51306], [-122.46278, 37.51328], [-122.4626, 37.51366], [-122.4618, 37.51368], [-122.46108, 37.51435], [-122.46078, 37.51448], [-122.46082, 37.51456], [-122.4609, 37.51466], [-122.46094, 37.5147], [-122.46108, 37.51477], [-122.46113, 37.51484], [-122.4607, 37.51502], [-122.46019, 37.51538], [-122.45989, 37.51561], [-122.45977, 37.51576], [-122.45949, 37.51621], [-122.45938, 37.51633], [-122.45936, 37.51644], [-122.45932, 37.51651], [-122.4592, 37.51659], [-122.45913, 37.51662], [-122.45893, 37.51665], [-122.45865, 37.51662], [-122.45851, 37.51658], [-122.45819, 37.51644], [-122.45754, 37.51632], [-122.45741, 37.51627], [-122.45732, 37.51617], [-122.45724, 37.51593], [-122.45715, 37.51581], [-122.45652, 37.51533], [-122.45645, 37.51524], [-122.45631, 37.51496], [-122.45616, 37.51476], [-122.45599, 37.51461], [-122.45566, 37.5144], [-122.45553, 37.51428], [-122.45545, 37.51417], [-122.45524, 37.51376], [-122.45517, 37.51367], [-122.45499, 37.51354], [-122.45449, 37.51336], [-122.45656, 37.51305], [-122.4557, 37.51077], [-122.45212, 37.5113], [-122.4521, 37.51155], [-122.45311, 37.5122], [-122.45338, 37.51227], [-122.45353, 37.51233], [-122.45368, 37.51246], [-122.4537, 37.51254], [-122.45366, 37.51277], [-122.45368, 37.51292], [-122.45376, 37.51307], [-122.45389, 37.5132], [-122.45407, 37.5133], [-122.45491, 37.5136], [-122.45507, 37.5137], [-122.45515, 37.51379], [-122.45537, 37.51421], [-122.45545, 37.51433], [-122.4556, 37.51446], [-122.4559, 37.51466], [-122.45607, 37.51481], [-122.45622, 37.51499], [-122.45635, 37.51527], [-122.45645, 37.51539], [-122.45707, 37.51585], [-122.45714, 37.51596], [-122.45722, 37.5162], [-122.45732, 37.51631], [-122.45739, 37.51636], [-122.4575, 37.5164], [-122.45816, 37.51652], [-122.45851, 37.51667], [-122.44941, 37.51586], [-122.44972, 37.51408], [-122.44817, 37.50926], [-122.44817, 37.50916], [-122.44842, 37.50822], [-122.44898, 37.50781], [-122.44921, 37.50708], [-122.44974, 37.50607], [-122.44982, 37.5057], [-122.45031, 37.50411], [-122.45095, 37.50276], [-122.45228, 37.50148], [-122.45505, 37.4988], [-122.45574, 37.4992], [-122.4557, 37.49924], [-122.4557, 37.49925], [-122.45732, 37.50056], [-122.45789, 37.50012], [-122.45814, 37.50032], [-122.45817, 37.50039], [-122.45823, 37.50049], [-122.45831, 37.50057], [-122.4584, 37.50063], [-122.45903, 37.50088], [-122.45932, 37.50103], [-122.45988, 37.50137], [-122.46063, 37.50166], [-122.46103, 37.50188], [-122.46263, 37.50178], [-122.46268, 37.50232], [-122.46272, 37.50252], [-122.4628, 37.50278], [-122.46292, 37.50305], [-122.46308, 37.5033], [-122.4633, 37.50356], [-122.46351, 37.50375], [-122.46378, 37.50394], [-122.4636, 37.50414], [-122.46355, 37.50428], [-122.46333, 37.50453], [-122.4634, 37.5049], [-122.46365, 37.50504], [-122.46365, 37.50525], [-122.46264, 37.5064], [-122.46316, 37.5067], [-122.46321, 37.50707], [-122.46324, 37.50715], [-122.46317, 37.50729], [-122.46322, 37.50734], [-122.46314, 37.50738], [-122.46316, 37.50743], [-122.46332, 37.50737], [-122.46354, 37.50798], [-122.46395, 37.50818], [-122.46389, 37.50889], [-122.46434, 37.50938], [-122.46492, 37.5095]]], [[[-122.4645, 37.51484], [-122.46327, 37.51708], [-122.45906, 37.51671], [-122.45914, 37.5167], [-122.45924, 37.51667], [-122.45939, 37.51657], [-122.45945, 37.51648], [-122.45948, 37.51635], [-122.45957, 37.51626], [-122.45986, 37.5158], [-122.45998, 37.51566], [-122.46043, 37.51532], [-122.46076, 37.51509], [-122.46104, 37.51497], [-122.46115, 37.51508], [-122.46137, 37.51517], [-122.46141, 37.51521], [-122.4622, 37.51576], [-122.46222, 37.51563], [-122.46227, 37.51557], [-122.46254, 37.51549], [-122.46262, 37.51544], [-122.4627, 37.51536], [-122.46285, 37.51539], [-122.46298, 37.51535], [-122.46306, 37.51527], [-122.46308, 37.51512], [-122.46313, 37.51505], [-122.46358, 37.51482], [-122.46377, 37.51468], [-122.46388, 37.51466], [-122.46409, 37.51465], [-122.4645, 37.51484]]]]} | Open Access 1 | 46894 | Quarry Park | 30391 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://parks.smcgov.org/quarry-park | San Mateo 15 | 504.154 | Quarry Park | 0 | Local Park 2 | 4 |
14209 | 14209 | 14208 | {"type": "Polygon", "coordinates": [[[-122.49515, 37.58657], [-122.49386, 37.58803], [-122.49373, 37.58789], [-122.49356, 37.58775], [-122.49138, 37.58627], [-122.4911, 37.58614], [-122.49084, 37.58606], [-122.49175, 37.58498], [-122.49198, 37.58497], [-122.49232, 37.5852], [-122.49249, 37.58522], [-122.49283, 37.58504], [-122.49319, 37.5854], [-122.49394, 37.58538], [-122.49413, 37.58585], [-122.49424, 37.58594], [-122.4943, 37.58589], [-122.49442, 37.58597], [-122.49458, 37.58628], [-122.49515, 37.58657]]]} | Open Access 1 | 44075 | Sanchez Adobe County Park | 25006 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 15.786 | Sanchez Adobe County Park | 0 | Local Park 2 | 4 | |
16804 | 16804 | 16803 | {"type": "Polygon", "coordinates": [[[-122.33445, 37.58791], [-122.33305, 37.58779], [-122.32861, 37.58893], [-122.32724, 37.58938], [-122.32601, 37.58986], [-122.32518, 37.59024], [-122.32415, 37.59081], [-122.32273, 37.59144], [-122.32189, 37.59167], [-122.32131, 37.59187], [-122.32117, 37.5919], [-122.32114, 37.59198], [-122.3211, 37.59201], [-122.32105, 37.59201], [-122.32098, 37.59197], [-122.32093, 37.59191], [-122.32087, 37.59181], [-122.32079, 37.59176], [-122.3207, 37.59174], [-122.32055, 37.59179], [-122.32048, 37.59177], [-122.32044, 37.59171], [-122.32042, 37.59158], [-122.32035, 37.5915], [-122.32003, 37.5914], [-122.31982, 37.59138], [-122.31941, 37.59142], [-122.31911, 37.59139], [-122.31883, 37.59142], [-122.31855, 37.59136], [-122.31836, 37.59134], [-122.31626, 37.59144], [-122.31586, 37.5915], [-122.31548, 37.59162], [-122.31517, 37.59178], [-122.315, 37.59189], [-122.31472, 37.59223], [-122.31465, 37.59225], [-122.31459, 37.59221], [-122.31459, 37.59217], [-122.31485, 37.59184], [-122.31491, 37.59172], [-122.31504, 37.59162], [-122.31515, 37.59148], [-122.31523, 37.59133], [-122.31527, 37.59115], [-122.31532, 37.59111], [-122.31549, 37.59111], [-122.31567, 37.59108], [-122.31575, 37.5911], [-122.31632, 37.59118], [-122.31651, 37.59118], [-122.31696, 37.59115], [-122.31737, 37.59118], [-122.31815, 37.59116], [-122.31823, 37.59112], [-122.31829, 37.59105], [-122.31813, 37.58693], [-122.31812, 37.58688], [-122.31804, 37.58683], [-122.31744, 37.58675], [-122.31729, 37.5868], [-122.31723, 37.58685], [-122.31719, 37.58692], [-122.31737, 37.59031], [-122.31736, 37.59037], [-122.3173, 37.59043], [-122.31722, 37.59047], [-122.31713, 37.59048], [-122.31706, 37.59046], [-122.31699, 37.59042], [-122.31696, 37.59037], [-122.31694, 37.59032], [-122.31678, 37.5869], [-122.31672, 37.58682], [-122.31662, 37.58679], [-122.31575, 37.58681], [-122.31561, 37.58684], [-122.31548, 37.58692], [-122.3154, 37.58702], [-122.31537, 37.58712], [-122.31536, 37.58785], [-122.31541, 37.58808], [-122.31535, 37.58825], [-122.31535, 37.58834], [-122.31543, 37.58854], [-122.31541, 37.58894], [-122.31548, 37.58935], [-122.31549, 37.58982], [-122.31545, 37.59003], [-122.31533, 37.59027], [-122.31535, 37.59035], [-122.31541, 37.59042], [-122.31543, 37.59046], [-122.31538, 37.59063], [-122.31535, 37.59066], [-122.31531, 37.59068], [-122.31525, 37.59067], [-122.3152, 37.59064], [-122.31516, 37.59057], [-122.31517, 37.59045], [-122.31514, 37.59041], [-122.31481, 37.59036], [-122.31418, 37.59036], [-122.31411, 37.59033], [-122.31404, 37.59028], [-122.314, 37.59022], [-122.31399, 37.59016], [-122.31392, 37.5884], [-122.31399, 37.58785], [-122.31404, 37.58773], [-122.31413, 37.58764], [-122.31423, 37.58757], [-122.3144, 37.58749], [-122.31452, 37.58738], [-122.31455, 37.58732], [-122.31477, 37.58666], [-122.31488, 37.58655], [-122.31504, 37.58646], [-122.31508, 37.58638], [-122.31506, 37.58632], [-122.31502, 37.58629], [-122.31491, 37.58626], [-122.31468, 37.58631], [-122.3145, 37.58642], [-122.31442, 37.58652], [-122.31438, 37.58662], [-122.31418, 37.58727], [-122.31409, 37.58735], [-122.31397, 37.5874], [-122.31394, 37.58738], [-122.31393, 37.58735], [-122.31395, 37.58677], [-122.31395, 37.58632], [-122.31397, 37.58617], [-122.31407, 37.58596], [-122.31414, 37.58587], [-122.31426, 37.58577], [-122.31444, 37.58566], [-122.31483, 37.58551], [-122.31508, 37.58538], [-122.31531, 37.58521], [-122.31548, 37.58504], [-122.31563, 37.58484], [-122.31576, 37.58456], [-122.31594, 37.58425], [-122.31597, 37.58409], [-122.31596, 37.584], [-122.31594, 37.58391], [-122.31598, 37.58396], [-122.3173, 37.58505], [-122.31733, 37.58504], [-122.31748, 37.58517], [-122.31758, 37.5851], [-122.31775, 37.58567], [-122.31788, 37.58596], [-122.31797, 37.58626], [-122.31795, 37.58638], [-122.31856, 37.58615], [-122.31931, 37.58631], [-122.3202, 37.58694], [-122.32072, 37.58807], [-122.32097, 37.58825], [-122.32144, 37.58826], [-122.32144, 37.58824], [-122.32141, 37.58816], [-122.32238, 37.58802], [-122.32249, 37.58799], [-122.32265, 37.58791], [-122.32295, 37.58766], [-122.32309, 37.58759], [-122.32324, 37.58755], [-122.32343, 37.58752], [-122.32421, 37.5875], [-122.32434, 37.58747], [-122.32445, 37.58743], [-122.32776, 37.58515], [-122.32782, 37.58508], [-122.32785, 37.58503], [-122.32787, 37.5849], [-122.32808, 37.58501], [-122.3281, 37.58513], [-122.32815, 37.58529], [-122.32824, 37.58544], [-122.32834, 37.58556], [-122.32851, 37.5857], [-122.32877, 37.58584], [-122.32874, 37.5859], [-122.32895, 37.58599], [-122.33027, 37.58639], [-122.33176, 37.58668], [-122.33237, 37.58684], [-122.33424, 37.58706], [-122.33445, 37.58791]]]} | Open Access 1 | 14075 | Coyote Point Recreation Area | 30386 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 155.347 | Coyote Point Rec. Area | 2000 | 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]);