units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 424 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, LABEL_NAME, YR_EST, GAP_STS
DES_TP 7
- Local Park 24
- Local Recreation Area 8
- Local Conservation Area 7
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 43
MNG_AGENCY 1
- Chico, City of · 43 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16690 | 16690 | 16689 | {"type": "Polygon", "coordinates": [[[-121.78746, 39.7124], [-121.78712, 39.71247], [-121.78382, 39.71293], [-121.78234, 39.71292], [-121.78172, 39.71297], [-121.78061, 39.7131], [-121.78031, 39.71316], [-121.77964, 39.7132], [-121.77914, 39.71317], [-121.77773, 39.7129], [-121.77777, 39.71176], [-121.77777, 39.70713], [-121.77781, 39.70459], [-121.77727, 39.70261], [-121.78695, 39.70468], [-121.78734, 39.71127], [-121.78746, 39.71128], [-121.78746, 39.7124]]]} | Open Access 1 | 15788 | USFS Genetic Resource and Conservation Center | 26745 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 204.578 | USFS Genetic Resource and Conservation Ctr. | None 1416 | |||
16682 | 16682 | 16681 | {"type": "Polygon", "coordinates": [[[-121.82126, 39.72543], [-121.82125, 39.72544], [-121.81953, 39.72565], [-121.81943, 39.72559], [-121.81928, 39.72488], [-121.8199, 39.72452], [-121.82017, 39.72479], [-121.82021, 39.72478], [-121.82043, 39.72484], [-121.82128, 39.72533], [-121.8213, 39.72535], [-121.82131, 39.72538], [-121.82126, 39.72543]]]} | Open Access 1 | 15783 | Johnson Neighborhood Center | 20477 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 3.063 | Johnson Neighborhood Ctr. | 0 | Local Recreation Area 3 | 4 | |
16113 | 16113 | 16112 | {"type": "Polygon", "coordinates": [[[-121.85619, 39.78758], [-121.854, 39.78871], [-121.85242, 39.78672], [-121.85239, 39.78672], [-121.85132, 39.78533], [-121.84775, 39.78707], [-121.84928, 39.78895], [-121.84435, 39.79158], [-121.84414, 39.78648], [-121.84413, 39.78647], [-121.84406, 39.78651], [-121.84403, 39.78524], [-121.84377, 39.78521], [-121.84219, 39.78329], [-121.8421, 39.78312], [-121.83982, 39.78034], [-121.84, 39.7803], [-121.84321, 39.7781], [-121.84366, 39.77782], [-121.84529, 39.77718], [-121.84576, 39.77707], [-121.84814, 39.77756], [-121.85272, 39.78314], [-121.85301, 39.78365], [-121.85619, 39.78758]]]} | Open Access 1 | 15750 | City Designated Open Space | 17291 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 251.243 | City Designated OS | 0 | Local Recreation Area 3 | 4 | |
14810 | 14810 | 14809 | {"type": "Polygon", "coordinates": [[[-121.79697, 39.74059], [-121.79119, 39.74076], [-121.7909, 39.74056], [-121.79051, 39.74037], [-121.7905, 39.73904], [-121.7966, 39.73971], [-121.79681, 39.73971], [-121.79697, 39.74059]]]} | Open Access 1 | 45363 | Meriam Park Preserve | 22169 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 19.101 | Meriam Park Preserve | 0 | Local Conservation Area 4 | 2 | |
14707 | 14707 | 14706 | {"type": "MultiPolygon", "coordinates": [[[[-121.81454, 39.7557], [-121.81394, 39.75598], [-121.81374, 39.75574], [-121.8116, 39.75617], [-121.81113, 39.75629], [-121.81111, 39.75628], [-121.81069, 39.75678], [-121.81039, 39.75684], [-121.80834, 39.75704], [-121.80653, 39.75711], [-121.80604, 39.75756], [-121.80577, 39.75801], [-121.80474, 39.75919], [-121.80446, 39.75977], [-121.80351, 39.76005], [-121.80249, 39.76057], [-121.80141, 39.76023], [-121.80176, 39.75978], [-121.80238, 39.75949], [-121.80248, 39.75948], [-121.80325, 39.75911], [-121.80381, 39.75827], [-121.80419, 39.75793], [-121.80479, 39.75768], [-121.80562, 39.75705], [-121.8061, 39.75682], [-121.80637, 39.75671], [-121.80756, 39.75641], [-121.80805, 39.75631], [-121.80906, 39.75643], [-121.80907, 39.75645], [-121.8092, 39.75647], [-121.81026, 39.75622], [-121.8105, 39.75574], [-121.81025, 39.75498], [-121.8103, 39.755], [-121.81049, 39.7547], [-121.81098, 39.75441], [-121.81161, 39.75419], [-121.81165, 39.7542], [-121.81238, 39.75414], [-121.81415, 39.75422], [-121.81452, 39.75427], [-121.81451, 39.7544], [-121.81454, 39.7557]]], [[[-121.82477, 39.75221], [-121.82469, 39.7524], [-121.82452, 39.75269], [-121.82436, 39.7529], [-121.82421, 39.75307], [-121.82415, 39.7531], [-121.82368, 39.75316], [-121.82333, 39.75326], [-121.82238, 39.75366], [-121.82216, 39.75378], [-121.82184, 39.754], [-121.82175, 39.75409], [-121.8215, 39.75438], [-121.82122, 39.75464], [-121.82062, 39.75512], [-121.82003, 39.75551], [-121.81981, 39.75561], [-121.8198, 39.75518], [-121.81749, 39.75535], [-121.81559, 39.75529], [-121.81479, 39.75509], [-121.81472, 39.75508], [-121.81469, 39.75443], [-121.8147, 39.75431], [-121.81551, 39.75442], [-121.81754, 39.75473], [-121.82073, 39.75384], [-121.82111, 39.75364], [-121.82121, 39.75371], [-121.82254, 39.75313], [-121.82292, 39.75293], [-121.82354, 39.75273], [-121.82402, 39.75258], [-121.82477, 39.75221]]], [[[-121.82915, 39.75313], [-121.82911, 39.75331], [-121.82905, 39.75349], [-121.82904, 39.75349], [-121.82789, 39.75338], [-121.82686, 39.75305], [-121.82493, 39.75312], [-121.82459, 39.75311], [-121.82456, 39.75309], [-121.82455, 39.75305], [-121.82459, 39.75289], [-121.82508, 39.75215], [-121.82632, 39.75228], [-121.82747, 39.75265], [-121.82763, 39.75286], [-121.82831, 39.753], [-121.82915, 39.75313]]], [[[-121.84019, 39.75186], [-121.83997, 39.75184], [-121.83976, 39.75184], [-121.83885, 39.75205], [-121.83791, 39.7523], [-121.83691, 39.7524], [-121.83513, 39.75277], [-121.83464, 39.75291], [-121.83358, 39.75329], [-121.83278, 39.7535], [-121.83048, 39.7536], [-121.82939, 39.7535], [-121.82931, 39.75349], [-121.82929, 39.75346], [-121.82938, 39.75314], [-121.83047, 39.75317], [-121.83111, 39.75287], [-121.83269, 39.75271], [-121.83405, 39.75194], [-121.83488, 39.75169], [-121.83522, 39.7516], [-121.83589, 39.75161], [-121.83757, 39.75118], [-121.83848, 39.75116], [-121.83871, 39.75106], [-121.84019, 39.75186]]], [[[-121.84462, 39.75105], [-121.8431, 39.75122], [-121.84301, 39.75105], [-121.84283, 39.75086], [-121.84272, 39.75077], [-121.84216, 39.75078], [-121.84216, 39.75125], [-121.84206, 39.75129], [-121.84189, 39.7513], [-121.84125, 39.75152], [-121.84005, 39.75089], [-121.83966, 39.75067], [-121.83958, 39.75072], [-121.83954, 39.75069], [-121.83992, 39.75039], [-121.84019, 39.75027], [-121.84076, 39.75018], [-121.84106, 39.75015], [-121.84129, 39.75007], [-121.84159, 39.75002], [-121.84196, 39.74993], [-121.84212, 39.74993], [-121.84238, 39.7499], [-121.84269, 39.74991], [-121.84285, 39.74997], [-121.84295, 39.75005], [-121.84293, 39.75017], [-121.84294, 39.7502], [-121.84296, 39.75047], [-121.84297, 39.7505], [-121.84303, 39.75056], [-121.84315, 39.7506], [-121.84339, 39.75063], [-121.84445, 39.7507], [-121.84462, 39.75105]]], [[[-121.85362, 39.74917], [-121.85365, 39.74925], [-121.85361, 39.74961], [-121.85318, 39.74951], [-121.85169, 39.74972], [-121.85082, 39.75065], [-121.85055, 39.75082], [-121.84975, 39.75105], [-121.8493, 39.75069], [-121.84848, 39.75108], [-121.84816, 39.75133], [-121.84773, 39.75176], [-121.84737, 39.75184], [-121.84721, 39.752], [-121.84702, 39.75208], [-121.847, 39.75204], [-121.84589, 39.75204], [-121.84547, 39.75188], [-121.84507, 39.75109], [-121.84502, 39.75106], [-121.8449, 39.75071], [-121.84521, 39.75088], [-121.8454, 39.75101], [-121.84575, 39.75151], [-121.84591, 39.75165], [-121.84601, 39.75171], [-121.84614, 39.75176], [-121.8464, 39.75181], [-121.84654, 39.7518], [-121.84667, 39.75176], [-121.84684, 39.75168], [-121.8475, 39.75121], [-121.84772, 39.75107], [-121.84806, 39.7507], [-121.8483, 39.75054], [-121.84859, 39.75046], [-121.84918, 39.75041], [-121.84928, 39.75041], [-121.84938, 39.75044], [-121.84953, 39.75044], [-121.84976, 39.75041], [-121.84992, 39.75038], [-121.85001, 39.75035], [-121.85021, 39.75026], [-121.85036, 39.75013], [-121.85042, 39.75001], [-121.85055, 39.75017], [-121.85091, 39.7497], [-121.85131, 39.74951], [-121.85156, 39.74943], [-121.85205, 39.74935], [-121.85281, 39.74929], [-121.85362, 39.74917]]], [[[-121.86592, 39.74976], [-121.86568, 39.74972], [-121.86507, 39.74998], [-121.86485, 39.75012], [-121.86461, 39.75034], [-121.86406, 39.75068], [-121.86402, 39.7509], [-121.86398, 39.75085], [-121.86391, 39.75082], [-121.86385, 39.75082], [-121.86378, 39.75083], [-121.86371, 39.75088], [-121.86368, 39.75094], [-121.8637, 39.75101], [-121.86375, 39.75107], [-121.86354, 39.75104], [-121.86332, 39.75112], [-121.8631, 39.75129], [-121.86299, 39.75141], [-121.86271, 39.75158], [-121.86238, 39.75163], [-121.8626, 39.75149], [-121.86252, 39.7515], [-121.86245, 39.75154], [-121.86202, 39.75149], [-121.8604, 39.75146], [-121.85999, 39.7513], [-121.85793, 39.75098], [-121.85764, 39.75087], [-121.8575, 39.7508], [-121.85716, 39.75057], [-121.8568, 39.75027], [-121.85666, 39.7501], [-121.8562, 39.74967], [-121.85594, 39.74957], [-121.85564, 39.74952], [-121.85547, 39.74951], [-121.85457, 39.74956], [-121.85442, 39.74943], [-121.85438, 39.74942], [-121.85415, 39.74915], [-121.85471, 39.74908], [-121.8553, 39.74895], [-121.85547, 39.74894], [-121.85571, 39.74898], [-121.85587, 39.74905], [-121.85597, 39.74912], [-121.85606, 39.74919], [-121.85626, 39.74941], [-121.85642, 39.74954], [-121.85651, 39.7496], [-121.85667, 39.74967], [-121.85715, 39.75017], [-121.85722, 39.75027], [-121.85767, 39.75068], [-121.85778, 39.75074], [-121.85796, 39.75078], [-121.85812, 39.75079], [-121.85857, 39.75072], [-121.85881, 39.75066], [-121.85894, 39.75067], [-121.8597, 39.75088], [-121.85979, 39.75093], [-121.86007, 39.75109], [-121.86035, 39.7512], [-121.8605, 39.75124], [-121.86067, 39.75126], [-121.86092, 39.75126], [-121.86128, 39.75122], [-121.86164, 39.75124], [-121.86191, 39.75121], [-121.86221, 39.75111], [-121.86272, 39.7509], [-121.86288, 39.75081], [-121.86307, 39.75063], [-121.8636, 39.75003], [-121.86406, 39.74973], [-121.86478, 39.74929], [-121.86509, 39.74918], [-121.86546, 39.7491], [-121.86571, 39.74954], [-121.86592, 39.74976]]], [[[-121.86883, 39.74919], [-121.86831, 39.74936], [-121.86769, 39.7495], [-121.86769, 39.74951], [-121.86797, 39.74979], [-121.86739, 39.74979], [-121.86677, 39.74965], [-121.86655, 39.74956], [-121.86623, 39.74956], [-121.86601, 39.74954], [-121.86593, 39.74943], [-121.86584, 39.74907], [-121.86641, 39.74907], [-121.86675, 39.74904], [-121.86695, 39.74905], [-121.86715, 39.7491], [-121.86745, 39.74911], [-121.86758, 39.74913], [-121.86802, 39.74916], [-121.86864, 39.74901], [-121.86883, 39.74919]]], [[[-121.87593, 39.74371], [-121.87576, 39.74395], [-121.87572, 39.7439], [-121.8756, 39.74387], [-121.87536, 39.74393], [-121.87509, 39.74407], [-121.87503, 39.74412], [-121.8752, 39.7441], [-121.87453, 39.74454], [-121.87437, 39.74456], [-121.87386, 39.74485], [-121.87364, 39.74515], [-121.87354, 39.74538], [-121.87353, 39.74592], [-121.87368, 39.74648], [-121.87318, 39.74685], [-121.87217, 39.74698], [-121.8704, 39.74766], [-121.87008, 39.7483], [-121.8697, 39.74878], [-121.86937, 39.74895], [-121.86896, 39.74911], [-121.86887, 39.74913], [-121.86871, 39.74898], [-121.86884, 39.74891], [-121.86895, 39.74887], [-121.86929, 39.74879], [-121.86929, 39.74875], [-121.86938, 39.74868], [-121.86948, 39.74854], [-121.86952, 39.74841], [-121.86953, 39.74829], [-121.86975, 39.74784], [-121.87081, 39.74716], [-121.87285, 39.74642], [-121.87302, 39.74624], [-121.8729, 39.74533], [-121.87365, 39.74437], [-121.8744, 39.74408], [-121.8755, 39.74356], [-121.8758, 39.74352], [-121.8759, 39.74359], [-121.87593, 39.74371]]], [[[-121.88154, 39.74155], [-121.88151, 39.74161], [-121.88152, 39.74177], [-121.8815, 39.74196], [-121.88148, 39.74232], [-121.88145, 39.74242], [-121.88136, 39.74254], [-121.88123, 39.74265], [-121.88099, 39.74278], [-121.88052, 39.74297], [-121.88021, 39.74284], [-121.88002, 39.74305], [-121.88014, 39.74312], [-121.8798, 39.74348], [-121.87936, 39.74364], [-121.87805, 39.74352], [-121.87778, 39.74364], [-121.87612, 39.74382], [-121.87608, 39.7438], [-121.87606, 39.74377], [-121.87597, 39.74349], [-121.87626, 39.74348], [-121.87634, 39.7435], [-121.87685, 39.74339], [-121.87711, 39.74335], [-121.87745, 39.74334], [-121.87769, 39.74336], [-121.87791, 39.74332], [-121.87816, 39.74321], [-121.87936, 39.74338], [-121.87959, 39.74334], [-121.88001, 39.74281], [-121.88023, 39.74272], [-121.88051, 39.74268], [-121.88074, 39.74257], [-121.88111, 39.74228], [-121.88121, 39.74218], [-121.88126, 39.74199], [-121.88123, 39.74179], [-121.88114, 39.74164], [-121.88111, 39.74151], [-121.88112, 39.74141], [-121.8812, 39.74134], [-121.88154, 39.74155]]], [[[-121.8838, 39.74025], [-121.88348, 39.7403], [-121.88324, 39.74056], [-121.88311, 39.74077], [-121.88316, 39.741], [-121.88312, 39.74108], [-121.8826, 39.74122], [-121.88244, 39.74125], [-121.88217, 39.74119], [-121.88196, 39.74131], [-121.88189, 39.74142], [-121.88138, 39.74119], [-121.88164, 39.74101], [-121.88172, 39.74093], [-121.88251, 39.74079], [-121.88322, 39.73993], [-121.8838, 39.74025]]]]} | Open Access 1 | 45024 | Lindo Channel | 21299 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 135.161 | Lindo Channel | None 1260 | |||
14699 | 14699 | 14698 | {"type": "MultiPolygon", "coordinates": [[[[-121.83044, 39.77695], [-121.83031, 39.77695], [-121.8251, 39.7756], [-121.82359, 39.7757], [-121.82261, 39.77517], [-121.82066, 39.77577], [-121.82065, 39.77574], [-121.81709, 39.77645], [-121.81481, 39.7754], [-121.81457, 39.77535], [-121.81444, 39.77536], [-121.81278, 39.7741], [-121.81342, 39.77381], [-121.81435, 39.77381], [-121.81691, 39.77345], [-121.82053, 39.77457], [-121.82061, 39.77431], [-121.82061, 39.77428], [-121.82055, 39.77402], [-121.82044, 39.77378], [-121.82024, 39.7735], [-121.8196, 39.77287], [-121.81948, 39.77273], [-121.81933, 39.7725], [-121.81923, 39.77226], [-121.81999, 39.77238], [-121.8217, 39.77235], [-121.82365, 39.77212], [-121.82531, 39.77171], [-121.82533, 39.77173], [-121.82594, 39.77152], [-121.82643, 39.7714], [-121.82683, 39.77127], [-121.82732, 39.77195], [-121.82744, 39.7721], [-121.82762, 39.77226], [-121.82782, 39.77238], [-121.82809, 39.7725], [-121.82831, 39.77256], [-121.82859, 39.7726], [-121.82884, 39.7726], [-121.82906, 39.77257], [-121.82933, 39.77251], [-121.8299, 39.77228], [-121.83057, 39.77323], [-121.83074, 39.77352], [-121.83085, 39.77383], [-121.83092, 39.77419], [-121.83093, 39.77447], [-121.8309, 39.77479], [-121.83044, 39.77695]]], [[[-121.84008, 39.78068], [-121.83856, 39.78182], [-121.8374, 39.78209], [-121.83598, 39.7817], [-121.83437, 39.78158], [-121.82839, 39.78231], [-121.8284, 39.78334], [-121.82502, 39.78339], [-121.81752, 39.7777], [-121.81821, 39.77698], [-121.81753, 39.77666], [-121.81793, 39.7766], [-121.81832, 39.77643], [-121.81936, 39.7761], [-121.81986, 39.77606], [-121.82012, 39.77612], [-121.82073, 39.77609], [-121.82134, 39.77595], [-121.82176, 39.77584], [-121.82206, 39.77572], [-121.82229, 39.77568], [-121.82301, 39.77594], [-121.82336, 39.7761], [-121.82365, 39.77612], [-121.82535, 39.77608], [-121.82542, 39.77609], [-121.82608, 39.77626], [-121.8268, 39.77655], [-121.82945, 39.77718], [-121.82977, 39.7773], [-121.83007, 39.77735], [-121.83078, 39.77732], [-121.83128, 39.77734], [-121.83238, 39.77743], [-121.83271, 39.7774], [-121.83459, 39.77744], [-121.83528, 39.77772], [-121.83552, 39.77789], [-121.83625, 39.7785], [-121.83686, 39.77883], [-121.8377, 39.77907], [-121.83785, 39.77916], [-121.83851, 39.77939], [-121.83911, 39.77965], [-121.8392, 39.77971], [-121.83926, 39.78019], [-121.83928, 39.78023], [-121.83939, 39.78029], [-121.83979, 39.78032], [-121.84008, 39.78068]]]]} | Open Access 1 | 45028 | Foothill Preserve | 18982 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 362.463 | Foothill Preserve | 0 | Local Conservation Area 4 | 2 | |
14697 | 14697 | 14696 | {"type": "Polygon", "coordinates": [[[-121.80876, 39.76798], [-121.80871, 39.76806], [-121.80871, 39.76814], [-121.80873, 39.76815], [-121.80863, 39.76821], [-121.80864, 39.76851], [-121.80763, 39.76852], [-121.8071, 39.76788], [-121.80738, 39.76769], [-121.8079, 39.76741], [-121.8081, 39.76735], [-121.80827, 39.76733], [-121.80829, 39.76733], [-121.8083, 39.76746], [-121.80846, 39.76763], [-121.80856, 39.76768], [-121.80866, 39.76792], [-121.80876, 39.76798]]]} | Unknown Access 4 | 45027 | Wildwood Estate Preserve | 27518 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 3.11 | Wildwood Estate Preserve | 0 | Local Conservation Area 4 | 2 | |
14696 | 14696 | 14695 | {"type": "Polygon", "coordinates": [[[-121.80841, 39.76956], [-121.80823, 39.76957], [-121.80746, 39.77005], [-121.80758, 39.77016], [-121.80642, 39.76929], [-121.80643, 39.76853], [-121.80708, 39.76853], [-121.80745, 39.7689], [-121.80751, 39.76892], [-121.80751, 39.76895], [-121.80767, 39.76908], [-121.80801, 39.76933], [-121.80841, 39.76956]]]} | Open Access 1 | 45026 | Eaton Road Preserve | 18413 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 3.753 | Eaton Road Preserve | 0 | Local Conservation Area 4 | 2 | |
14695 | 14695 | 14694 | {"type": "MultiPolygon", "coordinates": [[[[-121.84325, 39.73187], [-121.84302, 39.73192], [-121.84284, 39.7319], [-121.8422, 39.73193], [-121.84217, 39.73192], [-121.84212, 39.73178], [-121.84229, 39.73181], [-121.84258, 39.7318], [-121.84284, 39.73176], [-121.84292, 39.73172], [-121.8431, 39.73171], [-121.84317, 39.73169], [-121.84325, 39.73187]]], [[[-121.8483, 39.72901], [-121.84825, 39.72906], [-121.84809, 39.72914], [-121.84775, 39.72926], [-121.84745, 39.72934], [-121.84724, 39.72943], [-121.84701, 39.72956], [-121.84693, 39.72964], [-121.84664, 39.73034], [-121.84626, 39.73047], [-121.84533, 39.73053], [-121.8451, 39.73057], [-121.84483, 39.73066], [-121.84461, 39.73079], [-121.84442, 39.73095], [-121.84438, 39.73092], [-121.84423, 39.73115], [-121.84412, 39.73137], [-121.84389, 39.73163], [-121.84382, 39.73172], [-121.84344, 39.73192], [-121.84338, 39.73185], [-121.84331, 39.73187], [-121.84322, 39.73166], [-121.84325, 39.73162], [-121.84348, 39.73146], [-121.84363, 39.73136], [-121.84379, 39.73128], [-121.84391, 39.73119], [-121.84403, 39.73107], [-121.84412, 39.7309], [-121.84423, 39.73057], [-121.84431, 39.73045], [-121.84438, 39.73039], [-121.84469, 39.73023], [-121.84494, 39.73022], [-121.84504, 39.73015], [-121.84512, 39.73011], [-121.8453, 39.73009], [-121.84578, 39.73006], [-121.84608, 39.73008], [-121.84626, 39.73003], [-121.8464, 39.72995], [-121.84652, 39.72982], [-121.84662, 39.72962], [-121.84663, 39.72953], [-121.84673, 39.72936], [-121.8468, 39.72928], [-121.84694, 39.72919], [-121.8472, 39.72907], [-121.84743, 39.72901], [-121.84782, 39.72895], [-121.84786, 39.72891], [-121.84794, 39.72886], [-121.84801, 39.72875], [-121.8483, 39.72901]]], [[[-121.85008, 39.72685], [-121.84992, 39.72697], [-121.84966, 39.72711], [-121.84932, 39.7274], [-121.84909, 39.72756], [-121.84895, 39.72763], [-121.84884, 39.72766], [-121.84868, 39.72775], [-121.8486, 39.72781], [-121.84849, 39.72795], [-121.84844, 39.72805], [-121.84837, 39.72832], [-121.84848, 39.72843], [-121.84856, 39.72859], [-121.8486, 39.72873], [-121.84857, 39.72885], [-121.84847, 39.72892], [-121.848, 39.72838], [-121.84804, 39.72817], [-121.84803, 39.72807], [-121.84809, 39.72795], [-121.84797, 39.72791], [-121.84809, 39.72764], [-121.84834, 39.72746], [-121.84855, 39.72742], [-121.84872, 39.72736], [-121.84919, 39.72713], [-121.84954, 39.72687], [-121.84986, 39.72666], [-121.85008, 39.72685]]], [[[-121.8512, 39.72593], [-121.85116, 39.72596], [-121.85119, 39.72599], [-121.8503, 39.72669], [-121.85018, 39.72659], [-121.8504, 39.72642], [-121.85079, 39.72605], [-121.85108, 39.72583], [-121.8512, 39.72593]]], [[[-121.86328, 39.72721], [-121.86263, 39.72725], [-121.8612, 39.72719], [-121.86002, 39.72711], [-121.85943, 39.72703], [-121.85906, 39.72692], [-121.85858, 39.72666], [-121.85839, 39.7266], [-121.85768, 39.7262], [-121.85723, 39.72585], [-121.85702, 39.7254], [-121.85697, 39.72523], [-121.85686, 39.72523], [-121.8561, 39.72558], [-121.85451, 39.72559], [-121.85403, 39.72573], [-121.85311, 39.72573], [-121.85237, 39.72569], [-121.85169, 39.72575], [-121.85138, 39.72585], [-121.85126, 39.7257], [-121.85142, 39.72564], [-121.85167, 39.72557], [-121.85199, 39.72557], [-121.85202, 39.72548], [-121.85209, 39.72541], [-121.85218, 39.72536], [-121.8523, 39.72534], [-121.85254, 39.72537], [-121.85272, 39.72543], [-121.85293, 39.72553], [-121.85326, 39.72561], [-121.85353, 39.72565], [-121.85371, 39.72566], [-121.85381, 39.72565], [-121.85429, 39.7255], [-121.85471, 39.72544], [-121.85547, 39.7254], [-121.85597, 39.72543], [-121.85597, 39.72537], [-121.85619, 39.72535], [-121.85641, 39.72522], [-121.8565, 39.72518], [-121.85661, 39.72506], [-121.85683, 39.72489], [-121.8569, 39.72487], [-121.85698, 39.72487], [-121.85711, 39.72494], [-121.85721, 39.72502], [-121.85724, 39.72507], [-121.85724, 39.7251], [-121.85727, 39.72514], [-121.85723, 39.72537], [-121.85725, 39.72547], [-121.85729, 39.7256], [-121.85738, 39.72571], [-121.85741, 39.72581], [-121.85746, 39.72584], [-121.85761, 39.72598], [-121.85777, 39.72606], [-121.85814, 39.72618], [-121.8583, 39.72625], [-121.85865, 39.7266], [-121.85876, 39.72669], [-121.85887, 39.72676], [-121.85899, 39.72679], [-121.85929, 39.72684], [-121.85967, 39.72699], [-121.85978, 39.72701], [-121.8607, 39.72698], [-121.86125, 39.72705], [-121.86152, 39.72709], [-121.8623, 39.72711], [-121.86296, 39.72709], [-121.86325, 39.72706], [-121.86328, 39.72721]]], [[[-121.88182, 39.72846], [-121.88181, 39.72884], [-121.88173, 39.72876], [-121.881, 39.72855], [-121.88033, 39.7281], [-121.87939, 39.72783], [-121.87927, 39.72773], [-121.87885, 39.72768], [-121.87833, 39.72773], [-121.87807, 39.72762], [-121.87754, 39.72657], [-121.87719, 39.72646], [-121.87653, 39.72635], [-121.87582, 39.72599], [-121.87462, 39.72552], [-121.87396, 39.72505], [-121.87318, 39.72512], [-121.87248, 39.72505], [-121.87209, 39.72507], [-121.87158, 39.72511], [-121.87086, 39.72494], [-121.87042, 39.72497], [-121.86931, 39.72491], [-121.8688, 39.72496], [-121.86836, 39.72481], [-121.86786, 39.72441], [-121.86763, 39.72442], [-121.86694, 39.72482], [-121.86674, 39.72503], [-121.86566, 39.72545], [-121.86534, 39.7259], [-121.86486, 39.72674], [-121.8647, 39.72681], [-121.86355, 39.72717], [-121.86353, 39.72705], [-121.86366, 39.72704], [-121.86424, 39.72678], [-121.86473, 39.72666], [-121.86483, 39.72657], [-121.86512, 39.72589], [-121.8653, 39.72573], [-121.86558, 39.7253], [-121.86592, 39.72526], [-121.86679, 39.72487], [-121.86725, 39.72445], [-121.86755, 39.72432], [-121.86794, 39.7243], [-121.86842, 39.72471], [-121.86888, 39.72485], [-121.86933, 39.72479], [-121.87007, 39.72482], [-121.87043, 39.72486], [-121.87059, 39.72485], [-121.87108, 39.72475], [-121.8717, 39.72495], [-121.8727, 39.72489], [-121.87293, 39.72492], [-121.87324, 39.72501], [-121.87334, 39.725], [-121.87345, 39.72494], [-121.87383, 39.72484], [-121.87393, 39.72482], [-121.87402, 39.72483], [-121.87417, 39.72495], [-121.87425, 39.72497], [-121.87444, 39.72511], [-121.87462, 39.72521], [-121.87531, 39.72551], [-121.87658, 39.72618], [-121.87676, 39.72623], [-121.877, 39.72624], [-121.87734, 39.72622], [-121.87745, 39.72624], [-121.87752, 39.72628], [-121.87763, 39.7264], [-121.8777, 39.7265], [-121.87776, 39.72665], [-121.8778, 39.72684], [-121.87786, 39.72691], [-121.87798, 39.72694], [-121.87843, 39.72696], [-121.87864, 39.72699], [-121.87871, 39.72704], [-121.87876, 39.72718], [-121.87878, 39.72721], [-121.87892, 39.72736], [-121.87907, 39.72746], [-121.87933, 39.72753], [-121.87953, 39.72761], [-121.87962, 39.72768], [-121.87983, 39.72777], [-121.88016, 39.72782], [-121.8804, 39.72781], [-121.88053, 39.72783], [-121.88074, 39.72795], [-121.88104, 39.72818], [-121.88134, 39.72839], [-121.88165, 39.72846], [-121.88182, 39.72846]]]]} | No Public Access 3 | 45025 | Big Chico Creek Greenway | 28979 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 23.271 | Big Chico Creek Greenway | 0 | Local Recreation Area 3 | 4 | |
13707 | 13707 | 13706 | {"type": "MultiPolygon", "coordinates": [[[[-121.77899, 39.72934], [-121.77873, 39.7295], [-121.77861, 39.72949], [-121.77845, 39.72935], [-121.77833, 39.72941], [-121.77802, 39.72945], [-121.77802, 39.72992], [-121.77386, 39.73195], [-121.77333, 39.73185], [-121.77331, 39.73068], [-121.77334, 39.73068], [-121.77335, 39.73104], [-121.774, 39.73102], [-121.774, 39.73091], [-121.77429, 39.73083], [-121.77467, 39.7308], [-121.77522, 39.73068], [-121.77551, 39.73065], [-121.7756, 39.73059], [-121.77563, 39.7305], [-121.77637, 39.7305], [-121.7766, 39.73038], [-121.77672, 39.73037], [-121.77679, 39.73031], [-121.77722, 39.73031], [-121.77722, 39.72916], [-121.77802, 39.72915], [-121.77816, 39.72911], [-121.77822, 39.72906], [-121.77828, 39.72898], [-121.77839, 39.72893], [-121.779, 39.72921], [-121.77902, 39.72924], [-121.77899, 39.72934]]], [[[-121.77943, 39.72965], [-121.77914, 39.72969], [-121.77906, 39.72935], [-121.77909, 39.72928], [-121.77916, 39.72927], [-121.77929, 39.72931], [-121.77934, 39.72935], [-121.77936, 39.72938], [-121.77938, 39.72952], [-121.77943, 39.72965]]], [[[-121.78023, 39.72944], [-121.78012, 39.72956], [-121.77961, 39.72963], [-121.77955, 39.72949], [-121.77953, 39.72935], [-121.77949, 39.72928], [-121.7794, 39.7292], [-121.77925, 39.72915], [-121.77922, 39.72911], [-121.77943, 39.72877], [-121.77961, 39.7286], [-121.77975, 39.72853], [-121.77987, 39.72849], [-121.7802, 39.72843], [-121.78028, 39.7287], [-121.7802, 39.72884], [-121.78021, 39.72903], [-121.78013, 39.72912], [-121.7799, 39.72917], [-121.77988, 39.72918], [-121.78023, 39.72944]]]]} | Open Access 1 | 36082 | Hillview Preserve | 19996 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 9.976 | Hillview Preserve | 0 | Local Conservation Area 4 | 2 | |
13705 | 13705 | 13704 | {"type": "Polygon", "coordinates": [[[-121.8163, 39.73448], [-121.81582, 39.73456], [-121.81522, 39.73484], [-121.81516, 39.73491], [-121.81511, 39.73509], [-121.815, 39.73522], [-121.81453, 39.73546], [-121.81412, 39.73559], [-121.81413, 39.73562], [-121.81281, 39.73575], [-121.81238, 39.73587], [-121.81229, 39.73592], [-121.81196, 39.73603], [-121.81163, 39.7361], [-121.81138, 39.7363], [-121.81018, 39.73637], [-121.81008, 39.73565], [-121.81022, 39.73565], [-121.81075, 39.73576], [-121.81152, 39.73572], [-121.81172, 39.73569], [-121.81196, 39.7356], [-121.8121, 39.73554], [-121.81225, 39.73541], [-121.81236, 39.73537], [-121.81236, 39.7353], [-121.81235, 39.73521], [-121.81188, 39.73525], [-121.81181, 39.73527], [-121.81164, 39.73541], [-121.81157, 39.73542], [-121.81145, 39.73543], [-121.81136, 39.73542], [-121.8111, 39.73533], [-121.81091, 39.73535], [-121.81075, 39.73539], [-121.81066, 39.73538], [-121.81061, 39.73535], [-121.81062, 39.73524], [-121.81051, 39.73523], [-121.8104, 39.73515], [-121.81038, 39.73509], [-121.81041, 39.73502], [-121.81013, 39.73494], [-121.81011, 39.73353], [-121.81017, 39.73352], [-121.81015, 39.73328], [-121.81142, 39.73321], [-121.81156, 39.73317], [-121.81163, 39.73309], [-121.8117, 39.73311], [-121.81197, 39.73309], [-121.81183, 39.73157], [-121.81285, 39.73149], [-121.81296, 39.73163], [-121.8131, 39.73161], [-121.81378, 39.73236], [-121.8145, 39.73304], [-121.81508, 39.73353], [-121.8159, 39.73414], [-121.8163, 39.73448]]]} | Open Access 1 | 36080 | Teichert Pond | 26222 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 38.383 | Teichert Pond | None 1179 | |||
13088 | 13088 | 13087 | {"type": "Polygon", "coordinates": [[[-121.82501, 39.71158], [-121.82298, 39.71164], [-121.82226, 39.71162], [-121.82184, 39.71159], [-121.82151, 39.71169], [-121.82076, 39.71183], [-121.82027, 39.71179], [-121.81914, 39.71142], [-121.81785, 39.71191], [-121.81759, 39.7123], [-121.81671, 39.71257], [-121.8152, 39.71355], [-121.81442, 39.71402], [-121.81349, 39.71308], [-121.81331, 39.71295], [-121.81451, 39.7125], [-121.81821, 39.71095], [-121.81822, 39.71093], [-121.81069, 39.70943], [-121.80962, 39.70915], [-121.80952, 39.70889], [-121.81481, 39.71001], [-121.8191, 39.71083], [-121.8205, 39.71111], [-121.82101, 39.7112], [-121.82129, 39.71123], [-121.82187, 39.71057], [-121.82195, 39.71036], [-121.82252, 39.71002], [-121.82267, 39.70976], [-121.82339, 39.70937], [-121.82365, 39.7088], [-121.82408, 39.70921], [-121.824, 39.70943], [-121.82372, 39.70977], [-121.82342, 39.71001], [-121.82306, 39.71036], [-121.82299, 39.71051], [-121.8226, 39.71052], [-121.82242, 39.71075], [-121.82236, 39.7111], [-121.82209, 39.71132], [-121.825, 39.71138], [-121.82501, 39.71158]]]} | No Public Access 3 | 45023 | Comanche Creek Greenway | 28967 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 29.62 | Comanche Creek Greenway | 0 | Local Recreation Area 3 | 4 | |
11468 | 11468 | 11467 | {"type": "Polygon", "coordinates": [[[-121.85697, 39.8077], [-121.85694, 39.81018], [-121.85663, 39.81022], [-121.85626, 39.80996], [-121.85599, 39.80946], [-121.85582, 39.80948], [-121.85572, 39.80922], [-121.85437, 39.80942], [-121.85359, 39.80962], [-121.85359, 39.80913], [-121.85387, 39.80913], [-121.85422, 39.80927], [-121.85439, 39.8093], [-121.8557, 39.8091], [-121.85575, 39.80889], [-121.85596, 39.80883], [-121.85612, 39.80845], [-121.85624, 39.80843], [-121.85634, 39.80839], [-121.85643, 39.80834], [-121.8565, 39.80827], [-121.85674, 39.80774], [-121.85697, 39.8077]]]} | Open Access 1 | 48708 | Skycreek Park | 33437 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 5.528 | Skycreek Park | 0 | Local Park 2 | 4 | |
11326 | 11326 | 11325 | {"type": "Polygon", "coordinates": [[[-121.88044, 39.75226], [-121.87925, 39.75296], [-121.87783, 39.75153], [-121.879, 39.75083], [-121.88044, 39.75226]]]} | Open Access 1 | 22040 | Henshaw Park | 19830 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 6.342 | Henshaw Park | 0 | Local Park 2 | 4 | |
10936 | 10936 | 10935 | {"type": "Polygon", "coordinates": [[[-121.83508, 39.72537], [-121.83486, 39.7255], [-121.83448, 39.72532], [-121.83456, 39.72529], [-121.83465, 39.72529], [-121.83508, 39.72537]]]} | Open Access 1 | 48677 | Junction Park | 33418 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 0.146 | Junction Park | 0 | Local Park 2 | 4 | |
10923 | 10923 | 10922 | {"type": "Polygon", "coordinates": [[[-121.82111, 39.75364], [-121.82073, 39.75384], [-121.81754, 39.75473], [-121.81653, 39.75353], [-121.81834, 39.75217], [-121.81856, 39.75203], [-121.81882, 39.75191], [-121.81883, 39.75189], [-121.82111, 39.75364]]]} | Open Access 1 | 48669 | Verbena Fields | 33413 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 16.052 | Verbena Fields | 2009 | Local Recreation Area 3 | 4 | |
9471 | 9471 | 9470 | {"type": "Polygon", "coordinates": [[[-121.82954, 39.71984], [-121.82923, 39.72018], [-121.82893, 39.72001], [-121.82925, 39.71967], [-121.82954, 39.71984]]]} | Open Access 1 | 15837 | Rotary Park | 24687 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 0.36 | Rotary Park | 0 | Local Park 2 | 4 | |
9465 | 9465 | 9464 | {"type": "Polygon", "coordinates": [[[-121.80608, 39.76755], [-121.80419, 39.76528], [-121.80279, 39.76367], [-121.80359, 39.76323], [-121.80417, 39.76268], [-121.80426, 39.76274], [-121.80495, 39.76259], [-121.80525, 39.76249], [-121.80535, 39.76249], [-121.80539, 39.76252], [-121.80554, 39.76278], [-121.80578, 39.7633], [-121.80587, 39.76356], [-121.80597, 39.76392], [-121.80605, 39.76446], [-121.80608, 39.76755]]]} | Open Access 1 | 15842 | Wildwood Park | 27520 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 19.795 | Wildwood Park | 0 | Local Park 2 | 4 | |
9460 | 9460 | 9459 | {"type": "Polygon", "coordinates": [[[-121.87704, 39.76343], [-121.8758, 39.76415], [-121.87473, 39.76307], [-121.87603, 39.76234], [-121.87704, 39.76343]]]} | Open Access 1 | 15817 | Peterson Park | 23633 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 4.991 | Peterson Park | 0 | Local Park 2 | 4 | |
9455 | 9455 | 9454 | {"type": "MultiPolygon", "coordinates": [[[[-121.78112, 39.7262], [-121.77809, 39.72622], [-121.77808, 39.72462], [-121.77825, 39.72467], [-121.77875, 39.72424], [-121.77911, 39.72406], [-121.77947, 39.72361], [-121.77957, 39.72373], [-121.78071, 39.7244], [-121.78111, 39.72483], [-121.78125, 39.72528], [-121.78112, 39.7262]]], [[[-121.79536, 39.73944], [-121.79055, 39.73888], [-121.79053, 39.73776], [-121.79385, 39.73726], [-121.79534, 39.73763], [-121.79536, 39.73944]]]]} | Open Access 1 | 15827 | Preserve Areas | 2238 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 33.396 | Preserve Areas | 0 | Local Conservation Area 4 | 2 |
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]);