units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
62 rows where MNG_AG_TYP = 11 sorted by COUNTY
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, MNG_AG_ID, PARK_URL, COUNTY, LABEL_NAME, YR_EST
MNG_AGENCY 49
- Exeter Cemetery District 3
- Selma Cemetery District 3
- Rose Hills Memorial Park Association 3
- Pajaro Valley Public Cemetery District 3
- Santa Maria Cemetery District 2
- Lindsay-Strathmore Cemetery District 2
- Sanger/Del Rey Cemetery District 2
- Porterville Public Cemetery District 2
- Merced Cemetery District 2
- Jamestown Cemetery District 1
- Santa Barbara Cemetery Association 1
- Shaws Flat Cemetery District 1
- Oak Grove Cemetery District 1
- Woodlake Public Cemetery District 1
- Soledad Cemetery District 1
- Tulare Veterans Memorial District 1
- Woodville Public Cemetery District 1
- Tulare Cemetery District 1
- Wilmington Public Cemetery District 1
- Los Banos Cemetery District 1
- Fowler Cemetery District 1
- Goleta Cemetery District 1
- Gonzales Cemetery District 1
- King City Cemetery District 1
- Plainsburg Cemetery District 1
- Parlier Cemetery District 1
- Bardsdale Cemetery District 1
- Kingsburg Cemetery District 1
- Lompoc Cemetery District 1
- Lancaster Cemetery District 1
- Visalia Cemetery District 1
- Coalinga Cemetery District 1
- Simi Valley Public Cemetery District 1
- Three Rivers Public Cemetery District 1
- Cambria Public Cemetery District 1
- Reedley Cemetery District 1
- Carpinteria Cemetery District 1
- Castroville Cemetery District 1
- Piru Cemetery District 1
- Orange County Cemetery District 1
- Greenfield Cemetery District 1
- Guadalupe Cemetery District 1
- Dos Palos Cemetery District 1
- Washington Colony Cemetery District 1
- Hills Ferry Cemetery District 1
- Winton Cemetery District 1
- Los Alamos Cemetery District 1
- Oak Hill Cemetery District 1
- Artesia Cemetery District 1
AGNCY_WEB 11 ✖
- http://www.co.merced.ca.us/index.aspx?NID=1329 5
- http://www.rosehills.com/ 3
- http://www.countyofsb.org/pwd/pwsurveyor.aspx 2
- http://artesiacemeterydistrict.com/ 1
- http://bardsdalecemetery.com/ 1
- http://lancastercemetery.net/ 1
- http://www.cambriacemetery.com/ 1
- http://www.carpinteriacemetery.com/ 1
- http://www.co.monterey.ca.us/factfinder/specdistr.htm 1
- http://www.goletacemetery.com/ 1
- http://www.occemeterydistrict.com/ 1
DES_TP 5
MNG_AG_TYP 1
- Cemetery District · 62 ✖
ACCESS_TYP 1
- Open Access 62
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5260 | 5260 | 5259 | {"type": "Polygon", "coordinates": [[[-121.09494, 35.57501], [-121.09451, 35.57558], [-121.09347, 35.57506], [-121.09278, 35.57593], [-121.09109, 35.57504], [-121.09181, 35.57412], [-121.09133, 35.57387], [-121.09398, 35.57389], [-121.09494, 35.57501]]]} | Open Access 1 | 1946 | Cambria Public Cemetery | 16751 | 2011 | Cambria Public Cemetery District 800 | Special District 4 | Cemetery District 11 | http://www.cambriacemetery.com/ | Special District 4 | 2011 | Cambria Public Cemetery District 780 | Special District 4 | Cemetery District 11 | San Luis Obispo 1 | 12.234 | Cambria Public Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
8127 | 8127 | 8126 | {"type": "Polygon", "coordinates": [[[-117.68379, 33.64177], [-117.68361, 33.64242], [-117.68314, 33.64365], [-117.68303, 33.64446], [-117.68101, 33.64482], [-117.68049, 33.64436], [-117.67955, 33.6437], [-117.68281, 33.64044], [-117.68379, 33.64177]]]} | Open Access 1 | 12304 | El Toro Memorial Park Cemetery | 18544 | 2104 | Orange County Cemetery District 885 | Special District 4 | Cemetery District 11 | http://www.occemeterydistrict.com/ | Special District 4 | 2104 | Orange County Cemetery District 861 | Special District 4 | Cemetery District 11 | Orange 3 | 25.36 | El Toro Memorial Park Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2793 | 2793 | 2792 | {"type": "Polygon", "coordinates": [[[-121.76676, 36.92508], [-121.76492, 36.92663], [-121.7632, 36.92467], [-121.76454, 36.92389], [-121.76432, 36.92363], [-121.76487, 36.92332], [-121.76462, 36.92303], [-121.76486, 36.92289], [-121.76531, 36.92344], [-121.76676, 36.92508]]]} | Open Access 1 | 18569 | Pioneer Cemetery | 23711 | 2107 | Pajaro Valley Public Cemetery District 554 | Special District 4 | Cemetery District 11 | Special District 4 | 2107 | Pajaro Valley Public Cemetery District 547 | Special District 4 | Cemetery District 11 | Santa Cruz 5 | 15.079 | Pioneer Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
3920 | 3920 | 3919 | {"type": "Polygon", "coordinates": [[[-121.82126, 36.88954], [-121.81983, 36.89075], [-121.81617, 36.88796], [-121.81634, 36.88786], [-121.8166, 36.88778], [-121.81815, 36.88717], [-121.82126, 36.88954]]]} | Open Access 1 | 36129 | Pajaro Valley Water Management Agency | 28693 | 2107 | Pajaro Valley Public Cemetery District 554 | Special District 4 | Cemetery District 11 | Special District 4 | 2107 | Pajaro Valley Public Cemetery District 547 | Special District 4 | Cemetery District 11 | Santa Cruz 5 | 19.074 | Pajaro Valley Water Management Agency | None 337 | ||||
13750 | 13750 | 13749 | {"type": "Polygon", "coordinates": [[[-121.74769, 36.95384], [-121.74604, 36.95506], [-121.74302, 36.95493], [-121.74224, 36.95466], [-121.7421, 36.95465], [-121.74196, 36.95466], [-121.74172, 36.95458], [-121.74133, 36.95427], [-121.74156, 36.95362], [-121.74193, 36.95294], [-121.7433, 36.95149], [-121.74329, 36.95057], [-121.74263, 36.95073], [-121.74159, 36.94975], [-121.74651, 36.94608], [-121.74674, 36.94774], [-121.7473, 36.95058], [-121.74769, 36.95384]]]} | Open Access 1 | 36260 | Pajaro Valley Water Management Agency | 28693 | 2107 | Pajaro Valley Public Cemetery District 554 | Special District 4 | Cemetery District 11 | Special District 4 | 2107 | Pajaro Valley Public Cemetery District 547 | Special District 4 | Cemetery District 11 | Santa Cruz 5 | 88.944 | Pajaro Valley Water Management Agency | None 1183 | ||||
994 | 994 | 993 | {"type": "Polygon", "coordinates": [[[-118.25629, 33.79377], [-118.25421, 33.79388], [-118.2541, 33.79231], [-118.25461, 33.79228], [-118.25462, 33.79225], [-118.25616, 33.79216], [-118.25616, 33.79219], [-118.25618, 33.79219], [-118.25629, 33.79377]]]} | Open Access 1 | 6195 | Wilmington Cemetery | 27598 | 2182 | Wilmington Public Cemetery District 302 | Special District 4 | Cemetery District 11 | Special District 4 | 2182 | Wilmington Public Cemetery District 298 | Special District 4 | Cemetery District 11 | Los Angeles 6 | 8.461 | Wilmington Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
1705 | 1705 | 1704 | {"type": "Polygon", "coordinates": [[[-118.06777, 33.99672], [-118.06723, 33.99773], [-118.06591, 33.99683], [-118.06669, 33.996], [-118.06777, 33.99672]]]} | Open Access 1 | 6543 | Guirado Park | 19564 | 2125 | Rose Hills Memorial Park Association 412 | Special District 4 | Cemetery District 11 | http://www.rosehills.com/ | Special District 4 | 2125 | Rose Hills Memorial Park Association 406 | Special District 4 | Cemetery District 11 | Los Angeles 6 | 4.169 | Guirado Park | 0 | Local Park 2 | 4 | |
4354 | 4354 | 4353 | {"type": "Polygon", "coordinates": [[[-118.1303, 34.6981], [-118.13028, 34.69811], [-118.13028, 34.69818], [-118.12875, 34.69818], [-118.12873, 34.69777], [-118.12606, 34.69778], [-118.12606, 34.69691], [-118.12608, 34.69689], [-118.12611, 34.69688], [-118.12787, 34.69686], [-118.12864, 34.69679], [-118.13024, 34.69679], [-118.13029, 34.69681], [-118.1303, 34.6981]]]} | Open Access 1 | 45697 | Lancaster Cemetery | 28596 | 2357 | Lancaster Cemetery District 753 | Special District 4 | Cemetery District 11 | http://lancastercemetery.net/ | Special District 4 | 2357 | Lancaster Cemetery District 739 | Special District 4 | Cemetery District 11 | http://lancastercemetery.net/ | Los Angeles 6 | 11.633 | Lancaster Cemetery | 0 | Local Historic or Cultural Area 19 | 4 |
7168 | 7168 | 7167 | {"type": "Polygon", "coordinates": [[[-118.38057, 34.01511], [-118.3805, 34.0151], [-118.38043, 34.01512], [-118.38035, 34.01526], [-118.37778, 34.0153], [-118.37775, 34.01366], [-118.37761, 34.01347], [-118.37663, 34.01349], [-118.37647, 34.01384], [-118.37619, 34.01404], [-118.37593, 34.01451], [-118.37583, 34.01452], [-118.37551, 34.01452], [-118.37457, 34.01458], [-118.37457, 34.01464], [-118.37434, 34.01465], [-118.37432, 34.01431], [-118.37424, 34.01381], [-118.37498, 34.01377], [-118.37494, 34.01346], [-118.37489, 34.01333], [-118.37488, 34.01324], [-118.37489, 34.01317], [-118.37961, 34.01301], [-118.38057, 34.01511]]]} | Open Access 1 | 6304 | Kenneth Hahn State Recreation Area | 20609 | 2125 | Rose Hills Memorial Park Association 412 | Special District 4 | Cemetery District 11 | http://www.rosehills.com/ | Special District 4 | 2125 | Rose Hills Memorial Park Association 406 | Special District 4 | Cemetery District 11 | http://www.parks.ca.gov/?page_id=612 | Los Angeles 6 | 20.832 | Kenneth Hahn SRA | 1984 | Local Recreation Area 3 | 4 |
13497 | 13497 | 13496 | {"type": "MultiPolygon", "coordinates": [[[[-118.09532, 33.8702], [-118.09532, 33.87013], [-118.09532, 33.87013], [-118.09532, 33.87013], [-118.09532, 33.8702]]], [[[-118.09533, 33.87063], [-118.09533, 33.87057], [-118.09533, 33.87038], [-118.09533, 33.87057], [-118.09533, 33.87063]]], [[[-118.09689, 33.87286], [-118.09535, 33.87287], [-118.09533, 33.87087], [-118.09644, 33.87086], [-118.09644, 33.87106], [-118.09686, 33.87106], [-118.09689, 33.87286]]]]} | Open Access 1 | 45696 | Artesia Cemetery | 28595 | 2356 | Artesia Cemetery District 1061 | Special District 4 | Cemetery District 11 | http://artesiacemeterydistrict.com/ | Special District 4 | 2356 | Artesia Cemetery District 1019 | Special District 4 | Cemetery District 11 | Los Angeles 6 | 7.557 | Artesia Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
16631 | 16631 | 16630 | {"type": "MultiPolygon", "coordinates": [[[[-118.36556, 33.99719], [-118.36144, 33.99597], [-118.36141, 33.98957], [-118.36287, 33.98957], [-118.36334, 33.98947], [-118.3634, 33.9897], [-118.36252, 33.98969], [-118.36256, 33.99325], [-118.36257, 33.99325], [-118.3635, 33.99303], [-118.36353, 33.99316], [-118.36363, 33.99337], [-118.36396, 33.99381], [-118.36403, 33.99395], [-118.36411, 33.99421], [-118.36419, 33.99473], [-118.36434, 33.99508], [-118.36536, 33.99652], [-118.36551, 33.99681], [-118.36556, 33.99701], [-118.36556, 33.99719]]], [[[-118.36928, 33.98952], [-118.36892, 33.99032], [-118.36877, 33.99076], [-118.36859, 33.9914], [-118.36849, 33.99302], [-118.36856, 33.99412], [-118.36902, 33.99714], [-118.3692, 33.99788], [-118.36918, 33.99796], [-118.36914, 33.99801], [-118.36908, 33.99806], [-118.36902, 33.99809], [-118.36775, 33.99834], [-118.36778, 33.99796], [-118.36777, 33.99785], [-118.36575, 33.99725], [-118.36576, 33.99709], [-118.36574, 33.99691], [-118.36571, 33.99681], [-118.36564, 33.99661], [-118.36555, 33.99645], [-118.36456, 33.99506], [-118.36448, 33.99493], [-118.36442, 33.9948], [-118.36437, 33.99464], [-118.36431, 33.99418], [-118.36426, 33.994], [-118.36413, 33.99373], [-118.36382, 33.99331], [-118.36486, 33.9932], [-118.36505, 33.99297], [-118.36538, 33.99193], [-118.36611, 33.99122], [-118.36744, 33.9912], [-118.36747, 33.98969], [-118.36898, 33.98967], [-118.36928, 33.98952]]], [[[-118.36954, 33.99848], [-118.36954, 33.99848], [-118.36911, 33.99835], [-118.36924, 33.99832], [-118.36939, 33.99834], [-118.36951, 33.99842], [-118.36954, 33.99848]]]]} | Open Access 1 | 6308 | Kenneth Hahn State Recreation Area Sports Complex | 29781 | 2125 | Rose Hills Memorial Park Association 412 | Special District 4 | Cemetery District 11 | http://www.rosehills.com/ | Special District 4 | 2125 | Rose Hills Memorial Park Association 406 | Special District 4 | Cemetery District 11 | http://www.parks.ca.gov/?page_id=612 | Los Angeles 6 | 102.89 | Kenneth Hahn SRA Sports Complex | 0 | Local Recreation Area 3 | 4 |
175 | 175 | 174 | {"type": "Polygon", "coordinates": [[[-119.65914, 34.41998], [-119.65807, 34.4201], [-119.65671, 34.42044], [-119.65662, 34.42048], [-119.65651, 34.42056], [-119.65592, 34.42119], [-119.65575, 34.42131], [-119.65555, 34.42137], [-119.65541, 34.42139], [-119.65297, 34.42138], [-119.65294, 34.42134], [-119.65294, 34.41914], [-119.65261, 34.41913], [-119.65261, 34.41724], [-119.65352, 34.41719], [-119.65403, 34.41712], [-119.65457, 34.41717], [-119.65502, 34.41711], [-119.65526, 34.41712], [-119.65548, 34.41708], [-119.65595, 34.41711], [-119.65614, 34.41706], [-119.65649, 34.41705], [-119.65687, 34.41702], [-119.65729, 34.41703], [-119.65751, 34.41701], [-119.65793, 34.41701], [-119.65827, 34.41698], [-119.6587, 34.41702], [-119.65912, 34.41699], [-119.65914, 34.41998]]]} | Open Access 1 | 481 | Santa Barbara Cemetery | 25039 | 2140 | Santa Barbara Cemetery Association 67 | Special District 4 | Cemetery District 11 | Special District 4 | 2140 | Santa Barbara Cemetery Association 65 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 59.983 | Santa Barbara Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
180 | 180 | 179 | {"type": "Polygon", "coordinates": [[[-120.42711, 34.93148], [-120.42706, 34.93392], [-120.42702, 34.93833], [-120.42498, 34.93831], [-120.42501, 34.93448], [-120.42505, 34.93211], [-120.42507, 34.93195], [-120.42508, 34.93153], [-120.42511, 34.93149], [-120.42515, 34.93147], [-120.42711, 34.93148]]]} | Open Access 1 | 568 | Santa Maria Cemetery | 25103 | 2145 | Santa Maria Cemetery District 68 | Special District 4 | Cemetery District 11 | http://www.countyofsb.org/pwd/pwsurveyor.aspx | Special District 4 | 2145 | Santa Maria Cemetery District 66 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 35.019 | Santa Maria Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
1935 | 1935 | 1934 | {"type": "Polygon", "coordinates": [[[-119.78286, 34.44151], [-119.78261, 34.44152], [-119.7826, 34.44155], [-119.78177, 34.44157], [-119.78068, 34.44156], [-119.77962, 34.44159], [-119.7786, 34.44154], [-119.77859, 34.44048], [-119.77991, 34.44048], [-119.77991, 34.4404], [-119.77984, 34.4404], [-119.77985, 34.43923], [-119.78015, 34.43911], [-119.78025, 34.43909], [-119.78039, 34.43907], [-119.78082, 34.43905], [-119.78091, 34.43898], [-119.78101, 34.43894], [-119.7812, 34.43878], [-119.7813, 34.43873], [-119.78138, 34.43872], [-119.78168, 34.43872], [-119.78168, 34.43949], [-119.78069, 34.43949], [-119.78067, 34.44015], [-119.78035, 34.44016], [-119.78035, 34.44039], [-119.7817, 34.4404], [-119.78171, 34.44067], [-119.78186, 34.44067], [-119.78186, 34.44053], [-119.78254, 34.44054], [-119.78286, 34.44151]]]} | Open Access 1 | 16622 | Goleta Cemetery | 19381 | 2037 | Goleta Cemetery District 456 | Special District 4 | Cemetery District 11 | http://www.goletacemetery.com/ | Special District 4 | 2037 | Goleta Cemetery District 450 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 15.518 | Goleta Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2368 | 2368 | 2367 | {"type": "Polygon", "coordinates": [[[-120.41878, 34.85391], [-120.41878, 34.85526], [-120.41827, 34.85526], [-120.41827, 34.85391], [-120.41878, 34.85391]]]} | Open Access 1 | 18541 | Pine Grove Cemetery | 23677 | 2145 | Santa Maria Cemetery District 68 | Special District 4 | Cemetery District 11 | http://www.countyofsb.org/pwd/pwsurveyor.aspx | Special District 4 | 2145 | Santa Maria Cemetery District 66 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 1.717 | Pine Grove Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
2460 | 2460 | 2459 | {"type": "Polygon", "coordinates": [[[-120.45154, 34.63089], [-120.45154, 34.63099], [-120.44878, 34.63096], [-120.44841, 34.63085], [-120.44601, 34.63083], [-120.446, 34.63074], [-120.44531, 34.63074], [-120.4453, 34.63071], [-120.44519, 34.63071], [-120.44522, 34.63014], [-120.44594, 34.62906], [-120.44681, 34.62907], [-120.44682, 34.62893], [-120.44884, 34.62894], [-120.44887, 34.62739], [-120.44917, 34.6274], [-120.44916, 34.62827], [-120.44944, 34.62828], [-120.4503, 34.62929], [-120.45069, 34.63019], [-120.45128, 34.63077], [-120.45154, 34.63089]]]} | Open Access 1 | 17397 | Lompoc Cemetery - Lompoc Cemetery District | 21419 | 2063 | Lompoc Cemetery District 526 | Special District 4 | Cemetery District 11 | Special District 4 | 2063 | Lompoc Cemetery District 518 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 27.221 | Lompoc Cemetery - Lompoc Cemetery District | 0 | Local Historic or Cultural Area 19 | 4 | ||
6599 | 6599 | 6598 | {"type": "Polygon", "coordinates": [[[-119.54108, 34.41138], [-119.54104, 34.41331], [-119.5386, 34.41327], [-119.53861, 34.4125], [-119.53904, 34.41046], [-119.54094, 34.41042], [-119.54094, 34.41137], [-119.54108, 34.41138]]]} | Open Access 1 | 4088 | Carpinteria Cemetery | 16894 | 2014 | Carpinteria Cemetery District 838 | Special District 4 | Cemetery District 11 | http://www.carpinteriacemetery.com/ | Special District 4 | 2014 | Carpinteria Cemetery District 815 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 16.22 | Carpinteria Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
9794 | 9794 | 9793 | {"type": "Polygon", "coordinates": [[[-120.57648, 34.95764], [-120.57647, 34.95894], [-120.57408, 34.95892], [-120.57408, 34.95762], [-120.57648, 34.95764]]]} | Open Access 1 | 16696 | Guadalupe Cemetery | 19541 | 2043 | Guadalupe Cemetery District 927 | Special District 4 | Cemetery District 11 | Special District 4 | 2043 | Guadalupe Cemetery District 900 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 7.795 | Guadalupe Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
9973 | 9973 | 9972 | {"type": "Polygon", "coordinates": [[[-120.28195, 34.73211], [-120.28188, 34.73339], [-120.2803, 34.73332], [-120.2804, 34.73204], [-120.28195, 34.73211]]]} | Open Access 1 | 17408 | Los Alamos Cemetery | 21471 | 2064 | Los Alamos Cemetery District 940 | Special District 4 | Cemetery District 11 | Special District 4 | 2064 | Los Alamos Cemetery District 913 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 5.019 | Los Alamos Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
10329 | 10329 | 10328 | {"type": "Polygon", "coordinates": [[[-120.11248, 34.63311], [-120.11247, 34.63324], [-120.11225, 34.63369], [-120.11229, 34.6339], [-120.11233, 34.6339], [-120.11242, 34.63432], [-120.11242, 34.63476], [-120.11203, 34.63477], [-120.11178, 34.63565], [-120.11113, 34.63565], [-120.11115, 34.63281], [-120.11073, 34.6328], [-120.11074, 34.63167], [-120.11247, 34.63167], [-120.11248, 34.63311]]]} | Open Access 1 | 18192 | Oak Hill Cemetery | 22976 | 2099 | Oak Hill Cemetery District 946 | Special District 4 | Cemetery District 11 | Special District 4 | 2099 | Oak Hill Cemetery District 918 | Special District 4 | Cemetery District 11 | Santa Barbara 7 | 12.84 | Oak Hill Cemetery | 0 | Local Historic or Cultural Area 19 | 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]);