units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where AGNCY_TYP = 3 and MNG_AGENCY = 5 sorted by ACRES
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10310 | 10310 | 10309 | {"type": "Polygon", "coordinates": [[[-121.74548, 36.91252], [-121.74543, 36.91258], [-121.74506, 36.91341], [-121.74351, 36.91547], [-121.7433, 36.91528], [-121.74403, 36.91429], [-121.74416, 36.91385], [-121.74483, 36.91341], [-121.74512, 36.91263], [-121.74548, 36.91252]]]} | Open Access 1 | 18353 | Pajaro River | 28154 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.421 | Pajaro River | None 901 | |||
9854 | 9854 | 9853 | {"type": "MultiPolygon", "coordinates": [[[[-121.88803, 36.96112], [-121.8874, 36.96143], [-121.88725, 36.96128], [-121.88734, 36.96113], [-121.88674, 36.96072], [-121.88659, 36.96057], [-121.88667, 36.96038], [-121.88733, 36.96103], [-121.88803, 36.96112]]], [[[-121.88865, 36.95676], [-121.88823, 36.9575], [-121.88824, 36.95754], [-121.88779, 36.95806], [-121.88785, 36.95842], [-121.88803, 36.95889], [-121.88785, 36.95921], [-121.88746, 36.9591], [-121.88746, 36.95897], [-121.88765, 36.95859], [-121.88751, 36.95839], [-121.88767, 36.95762], [-121.88767, 36.95746], [-121.8878, 36.95735], [-121.8882, 36.95749], [-121.88863, 36.95674], [-121.88865, 36.95676]]]]} | Open Access 1 | 16866 | Hidden Beach Park | 19902 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.424 | Hidden Beach Park | 0 | Local Park 2 | 4 | |
10497 | 10497 | 10496 | {"type": "Polygon", "coordinates": [[[-121.85845, 36.92895], [-121.85841, 36.9293], [-121.85822, 36.92941], [-121.8581, 36.92954], [-121.85786, 36.92946], [-121.85754, 36.93007], [-121.85696, 36.92982], [-121.85766, 36.92846], [-121.8577, 36.92845], [-121.85774, 36.92846], [-121.85764, 36.92869], [-121.85845, 36.92895]]]} | Open Access 1 | 18621 | Place de Mer Park | 23760 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.659 | Place de Mer Park | 0 | Local Park 2 | 4 | |
1357 | 1357 | 1356 | {"type": "Polygon", "coordinates": [[[-121.9737, 36.9789], [-121.97373, 36.97903], [-121.97373, 36.97947], [-121.97365, 36.97963], [-121.97249, 36.97967], [-121.97247, 36.97939], [-121.97093, 36.97945], [-121.97096, 36.97932], [-121.97243, 36.97925], [-121.97242, 36.97895], [-121.9737, 36.9789]]]} | Open Access 1 | 7881 | Coffee Lane Park | 17475 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 2.75 | Coffee Lane Park | 0 | Local Park 2 | 4 | |
6135 | 6135 | 6134 | {"type": "Polygon", "coordinates": [[[-121.81009, 36.98721], [-121.80994, 36.98711], [-121.80897, 36.98712], [-121.80907, 36.98747], [-121.80915, 36.98801], [-121.80804, 36.98783], [-121.80804, 36.98741], [-121.80794, 36.98713], [-121.80693, 36.98714], [-121.80692, 36.98712], [-121.80828, 36.9871], [-121.8081, 36.98657], [-121.80874, 36.98643], [-121.80896, 36.98709], [-121.81004, 36.98708], [-121.81009, 36.98721]]]} | Open Access 1 | 1127 | Aldridge Lane Park | 15351 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 3.265 | Aldridge Lane Park | 0 | Local Park 2 | 4 | |
216 | 216 | 215 | {"type": "Polygon", "coordinates": [[[-121.81987, 36.97069], [-121.81931, 36.97091], [-121.81883, 36.97022], [-121.81864, 36.96998], [-121.81841, 36.96978], [-121.81822, 36.96964], [-121.81752, 36.96928], [-121.81814, 36.96853], [-121.81894, 36.96939], [-121.81987, 36.97069]]]} | Open Access 1 | 691 | Scott Park | 25203 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 4.268 | Scott Park | 0 | Local Park 2 | 4 | |
6210 | 6210 | 6209 | {"type": "Polygon", "coordinates": [[[-121.82055, 36.87191], [-121.82046, 36.872], [-121.82016, 36.87219], [-121.81982, 36.87232], [-121.81941, 36.87243], [-121.81935, 36.87243], [-121.81931, 36.8724], [-121.81904, 36.87191], [-121.81895, 36.87179], [-121.81886, 36.87168], [-121.81843, 36.87126], [-121.81874, 36.87076], [-121.81887, 36.87049], [-121.81924, 36.87028], [-121.8193, 36.87051], [-121.81938, 36.87127], [-121.81992, 36.87155], [-121.82031, 36.87159], [-121.82055, 36.87191]]]} | Open Access 1 | 1259 | Sunset State Beach | 26065 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.parks.ca.gov/?page_id=544 | Santa Cruz 5 | 4.627 | Sunset SB | 1931 | None 502 | |
17031 | 17031 | 17030 | {"type": "Polygon", "coordinates": [[[-121.94388, 36.98798], [-121.94332, 36.99061], [-121.94267, 36.99058], [-121.94267, 36.99056], [-121.94276, 36.99045], [-121.94269, 36.99022], [-121.94259, 36.99013], [-121.94264, 36.98993], [-121.94279, 36.98973], [-121.9428, 36.98959], [-121.94286, 36.98949], [-121.94287, 36.98945], [-121.94242, 36.98943], [-121.94249, 36.98922], [-121.94269, 36.98889], [-121.94279, 36.98867], [-121.94289, 36.98833], [-121.94293, 36.98807], [-121.94297, 36.98802], [-121.94302, 36.98799], [-121.9433, 36.98804], [-121.94345, 36.98801], [-121.94346, 36.98799], [-121.94388, 36.98798]]]} | Open Access 1 | 48177 | The Farm Park & Community Center | 32712 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/Home/Parks/TheFarmPark-CommunityMeetings.aspx | Santa Cruz 5 | 5.534 | The Farm Park & Community Ctr. | 0 | Local Recreation Area 3 | 4 |
1846 | 1846 | 1845 | {"type": "Polygon", "coordinates": [[[-122.07213, 37.05232], [-122.07202, 37.05234], [-122.07061, 37.05188], [-122.06936, 37.05156], [-122.06955, 37.05119], [-122.06989, 37.05114], [-122.07065, 37.05095], [-122.07126, 37.05071], [-122.07141, 37.05075], [-122.07159, 37.05093], [-122.07213, 37.05232]]]} | Open Access 1 | 15786 | Felton Covered Bridge Park | 18870 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 5.596 | Felton Covered Bridge Park | 0 | Local Park 2 | 4 | |
9927 | 9927 | 9926 | {"type": "Polygon", "coordinates": [[[-121.99187, 36.9749], [-121.99092, 36.97662], [-121.99045, 36.97644], [-121.99045, 36.97637], [-121.99042, 36.97632], [-121.99082, 36.97556], [-121.9899, 36.97523], [-121.98986, 36.97527], [-121.9895, 36.97539], [-121.98912, 36.97532], [-121.98942, 36.97511], [-121.98952, 36.97507], [-121.9896, 36.97494], [-121.99007, 36.97503], [-121.99003, 36.97493], [-121.99018, 36.97471], [-121.99049, 36.97461], [-121.99079, 36.9743], [-121.99187, 36.9749]]]} | Open Access 1 | 17068 | Jose Avenue Park | 20491 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 5.839 | Jose Avenue Park | 0 | Local Park 2 | 4 | |
6433 | 6433 | 6432 | {"type": "Polygon", "coordinates": [[[-121.97728, 36.98977], [-121.97688, 36.99123], [-121.97544, 36.99106], [-121.97541, 36.9911], [-121.97467, 36.99101], [-121.97477, 36.99045], [-121.97558, 36.99054], [-121.97583, 36.9896], [-121.97728, 36.98977]]]} | Open Access 1 | 1956 | Winkle Farm Park | 27647 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 6.402 | Winkle Farm Park | 0 | Local Park 2 | 4 | |
144 | 144 | 143 | {"type": "Polygon", "coordinates": [[[-121.97587, 36.97007], [-121.9757, 36.97077], [-121.97566, 36.97132], [-121.97552, 36.9716], [-121.97389, 36.9716], [-121.97365, 36.97101], [-121.9733, 36.97101], [-121.97331, 36.97038], [-121.97438, 36.97017], [-121.97457, 36.97011], [-121.97587, 36.97007]]]} | Open Access 1 | 363 | Brommer Park | 16416 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 7.663 | Brommer Park | 0 | Local Park 2 | 4 | |
2608 | 2608 | 2607 | {"type": "MultiPolygon", "coordinates": [[[[-121.97832, 36.95705], [-121.97828, 36.95709], [-121.9783, 36.95711], [-121.97787, 36.95759], [-121.97783, 36.95757], [-121.97775, 36.95765], [-121.97718, 36.95745], [-121.97667, 36.9574], [-121.97609, 36.95755], [-121.97595, 36.95809], [-121.97577, 36.9583], [-121.97571, 36.95895], [-121.97546, 36.95939], [-121.97509, 36.95967], [-121.97488, 36.95987], [-121.97474, 36.95987], [-121.97499, 36.95918], [-121.97528, 36.95862], [-121.97554, 36.95745], [-121.9757, 36.95715], [-121.97617, 36.9566], [-121.97634, 36.95646], [-121.97646, 36.95645], [-121.97691, 36.95656], [-121.97758, 36.95608], [-121.97784, 36.95626], [-121.97797, 36.95666], [-121.97791, 36.95672], [-121.97828, 36.95698], [-121.97832, 36.95705]]], [[[-121.97827, 36.95625], [-121.97813, 36.95638], [-121.97809, 36.95638], [-121.97801, 36.95612], [-121.97812, 36.95614], [-121.97827, 36.95625]]]]} | Open Access 1 | 17987 | Moran Lake Park | 22471 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 8.942 | Moran Lake Park | 0 | Local Park 2 | 4 | |
414 | 414 | 413 | {"type": "Polygon", "coordinates": [[[-121.99027, 36.96704], [-121.98919, 36.96912], [-121.98905, 36.9695], [-121.98804, 36.9695], [-121.98722, 36.96943], [-121.98774, 36.96794], [-121.98768, 36.96792], [-121.98777, 36.96788], [-121.98814, 36.96779], [-121.98895, 36.96735], [-121.98913, 36.96739], [-121.99027, 36.96704]]]} | Open Access 1 | 830 | Simpkins Swim Center | 25513 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 9.9 | Simpkins Swim Ctr. | 0 | Local Recreation Area 3 | 4 | |
6294 | 6294 | 6293 | {"type": "Polygon", "coordinates": [[[-121.88394, 36.95303], [-121.88313, 36.95362], [-121.88287, 36.95358], [-121.8827, 36.95365], [-121.88262, 36.95372], [-121.88258, 36.95366], [-121.88266, 36.9536], [-121.88261, 36.95352], [-121.88252, 36.95344], [-121.88226, 36.95327], [-121.8822, 36.95312], [-121.88213, 36.95301], [-121.88208, 36.95296], [-121.88204, 36.95296], [-121.88197, 36.953], [-121.88177, 36.95321], [-121.88167, 36.95333], [-121.8814, 36.95338], [-121.88133, 36.95337], [-121.8812, 36.95342], [-121.88084, 36.95385], [-121.88068, 36.95396], [-121.88056, 36.95393], [-121.8804, 36.95374], [-121.88026, 36.95366], [-121.87994, 36.95365], [-121.87969, 36.95371], [-121.87941, 36.95324], [-121.87926, 36.95315], [-121.87947, 36.95303], [-121.87986, 36.95273], [-121.88001, 36.95249], [-121.881, 36.95231], [-121.88219, 36.95156], [-121.88394, 36.95303]]]} | Open Access 1 | 1412 | Trestle at Hidden Beach | 26524 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 13.189 | Trestle at Hidden Beach | 0 | Local Park 2 | 4 | |
6033 | 6033 | 6032 | {"type": "Polygon", "coordinates": [[[-121.87593, 36.94744], [-121.87547, 36.94775], [-121.87485, 36.94762], [-121.87457, 36.94761], [-121.87438, 36.94764], [-121.87413, 36.94784], [-121.87421, 36.948], [-121.87412, 36.94846], [-121.87401, 36.94854], [-121.87273, 36.94732], [-121.87231, 36.94688], [-121.8722, 36.94674], [-121.87472, 36.94532], [-121.87575, 36.94641], [-121.87484, 36.94682], [-121.87485, 36.94684], [-121.87474, 36.94696], [-121.87481, 36.94702], [-121.87477, 36.94716], [-121.87484, 36.94727], [-121.87482, 36.94735], [-121.87497, 36.94735], [-121.87509, 36.94731], [-121.87541, 36.94707], [-121.87546, 36.94691], [-121.87558, 36.94706], [-121.87566, 36.94715], [-121.8758, 36.94736], [-121.87593, 36.94744]]]} | Open Access 1 | 727 | Seascape Park | 25248 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 13.659 | Seascape Park | 0 | Local Park 2 | 4 | |
8578 | 8578 | 8577 | {"type": "MultiPolygon", "coordinates": [[[[-121.9012, 36.97535], [-121.90104, 36.97554], [-121.9009, 36.97565], [-121.90022, 36.97565], [-121.9, 36.97562], [-121.89997, 36.97558], [-121.89973, 36.97546], [-121.89978, 36.97517], [-121.90053, 36.97515], [-121.90119, 36.97534], [-121.9012, 36.97535]]], [[[-121.90391, 36.97622], [-121.90364, 36.97625], [-121.90357, 36.9762], [-121.90345, 36.97617], [-121.90284, 36.97609], [-121.9025, 36.97598], [-121.90204, 36.97598], [-121.90206, 36.97594], [-121.90199, 36.97591], [-121.90206, 36.97533], [-121.90205, 36.97559], [-121.90211, 36.97585], [-121.90219, 36.97584], [-121.90231, 36.97592], [-121.90246, 36.97591], [-121.9026, 36.97592], [-121.90263, 36.97583], [-121.90276, 36.97582], [-121.9032, 36.97591], [-121.90382, 36.97612], [-121.90391, 36.97622]]], [[[-121.90494, 36.97742], [-121.90501, 36.97777], [-121.90491, 36.97835], [-121.90452, 36.97864], [-121.90473, 36.97891], [-121.90466, 36.97907], [-121.90448, 36.97926], [-121.90426, 36.97969], [-121.90428, 36.98012], [-121.90472, 36.9802], [-121.90476, 36.98033], [-121.90457, 36.98062], [-121.90442, 36.98093], [-121.90434, 36.98123], [-121.90412, 36.98134], [-121.90415, 36.98094], [-121.90432, 36.98034], [-121.9041, 36.98031], [-121.90404, 36.98008], [-121.90367, 36.97979], [-121.9036, 36.97965], [-121.90358, 36.97936], [-121.90366, 36.97924], [-121.90361, 36.979], [-121.90385, 36.97865], [-121.90359, 36.97852], [-121.90359, 36.97849], [-121.90346, 36.9784], [-121.90303, 36.97822], [-121.90278, 36.97807], [-121.90277, 36.97809], [-121.90296, 36.97834], [-121.90299, 36.97854], [-121.90288, 36.97856], [-121.90286, 36.97847], [-121.90276, 36.97827], [-121.90259, 36.97804], [-121.9025, 36.97783], [-121.9025, 36.97762], [-121.90257, 36.97739], [-121.90268, 36.97731], [-121.90277, 36.97721], [-121.90309, 36.97701], [-121.9038, 36.97673], [-121.90381, 36.97671], [-121.90375, 36.97664], [-121.90393, 36.97654], [-121.90398, 36.97662], [-121.90399, 36.97708], [-121.90452, 36.97704], [-121.90494, 36.97742]]]]} | Open Access 1 | 13614 | Aptos Village Park | 15547 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 14.362 | Aptos Village Park | 0 | Local Park 2 | 4 | |
9135 | 9135 | 9134 | {"type": "Polygon", "coordinates": [[[-121.8062, 36.9086], [-121.80603, 36.90929], [-121.80576, 36.90997], [-121.80555, 36.91066], [-121.80541, 36.91092], [-121.80506, 36.91124], [-121.8049, 36.9115], [-121.80481, 36.91148], [-121.80472, 36.91147], [-121.80272, 36.91153], [-121.80291, 36.90858], [-121.8062, 36.9086]]]} | Restricted Access 2 | 16765 | Harkins Slough | 28149 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 20.48 | Harkins Slough | 0 | Local Conservation Area 4 | 2 | |
2293 | 2293 | 2292 | {"type": "Polygon", "coordinates": [[[-122.08447, 37.08129], [-122.08267, 37.08185], [-122.08229, 37.08166], [-122.08161, 37.08221], [-122.0806, 37.08182], [-122.0801, 37.08182], [-122.07978, 37.08175], [-122.07979, 37.08108], [-122.07892, 37.08061], [-122.07893, 37.08031], [-122.07917, 37.08], [-122.07986, 37.07971], [-122.08017, 37.0795], [-122.08045, 37.07977], [-122.0815, 37.07968], [-122.0816, 37.07953], [-122.08169, 37.07949], [-122.08201, 37.07942], [-122.08222, 37.07931], [-122.0828, 37.07895], [-122.08312, 37.07895], [-122.0836, 37.07989], [-122.08377, 37.08028], [-122.08406, 37.08086], [-122.0842, 37.08104], [-122.08429, 37.08114], [-122.08447, 37.08129]]]} | Open Access 1 | 16891 | Highland Park | 19931 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 25.586 | Highland Park | 0 | Local Park 2 | 4 | |
10179 | 10179 | 10178 | {"type": "Polygon", "coordinates": [[[-122.0518, 37.04316], [-122.05171, 37.04325], [-122.05136, 37.04307], [-122.05098, 37.04293], [-122.04999, 37.04275], [-122.05026, 37.04347], [-122.04925, 37.04495], [-122.0486, 37.04622], [-122.04469, 37.04114], [-122.04518, 37.04088], [-122.04547, 37.04119], [-122.04567, 37.04136], [-122.04589, 37.04151], [-122.04612, 37.04165], [-122.04637, 37.04178], [-122.04664, 37.04188], [-122.04719, 37.04204], [-122.05101, 37.04281], [-122.05123, 37.04287], [-122.05152, 37.04299], [-122.0518, 37.04316]]]} | Open Access 1 | 17811 | Michael Gray Field Park | 22195 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 27.906 | Michael Gray Field Park | 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]);