calands: units_with_maps: 4 rows where ACCESS_TYP = 1, AGNCY_TYP = 2 and DES

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

4 rows where ACCESS_TYP = 1, AGNCY_TYP = 2 and DES_TP = 80

Search:

descending

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	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
16973	16973	16972	{"type": "MultiPolygon", "coordinates": [[[[-116.40815, 33.67042], [-116.40786, 33.67036], [-116.40782, 33.67052], [-116.40799, 33.67062], [-116.39102, 33.67062], [-116.391, 33.66342], [-116.39893, 33.66343], [-116.39911, 33.66404], [-116.40094, 33.66486], [-116.40196, 33.66555], [-116.40233, 33.66566], [-116.40387, 33.6657], [-116.4042, 33.66582], [-116.40453, 33.66609], [-116.40497, 33.66685], [-116.4053, 33.66712], [-116.40552, 33.66717], [-116.40528, 33.66757], [-116.40635, 33.66818], [-116.40697, 33.6684], [-116.40765, 33.66936], [-116.40814, 33.66949], [-116.40815, 33.67042]]], [[[-116.40827, 33.72153], [-116.40815, 33.72862], [-116.40669, 33.72863], [-116.40669, 33.72848], [-116.40684, 33.7284], [-116.40655, 33.72811], [-116.40623, 33.7282], [-116.40596, 33.72815], [-116.40582, 33.72814], [-116.40548, 33.72787], [-116.40502, 33.72771], [-116.40502, 33.72751], [-116.40505, 33.72734], [-116.40537, 33.72647], [-116.40619, 33.72641], [-116.4064, 33.7255], [-116.40497, 33.72403], [-116.40463, 33.72346], [-116.40453, 33.72287], [-116.40411, 33.72255], [-116.40389, 33.72245], [-116.40392, 33.72232], [-116.40349, 33.72228], [-116.4033, 33.72239], [-116.40281, 33.72177], [-116.4027, 33.7215], [-116.4029, 33.7215], [-116.40291, 33.72149], [-116.40175, 33.7185], [-116.40156, 33.71853], [-116.40039, 33.71553], [-116.40161, 33.71553], [-116.402, 33.71581], [-116.40276, 33.71609], [-116.40281, 33.71616], [-116.40284, 33.71642], [-116.40297, 33.71668], [-116.40302, 33.71674], [-116.40306, 33.71693], [-116.40319, 33.71696], [-116.40319, 33.717], [-116.40326, 33.71705], [-116.40359, 33.7171], [-116.40379, 33.71717], [-116.4039, 33.71725], [-116.40409, 33.71744], [-116.4044, 33.71793], [-116.40416, 33.71802], [-116.40406, 33.71789], [-116.40398, 33.71792], [-116.40391, 33.71801], [-116.40387, 33.71809], [-116.40386, 33.71821], [-116.40388, 33.71829], [-116.40363, 33.71859], [-116.40435, 33.71968], [-116.40505, 33.72005], [-116.40443, 33.72029], [-116.40465, 33.72151], [-116.40827, 33.72153]]], [[[-116.42543, 33.68504], [-116.4238, 33.68504], [-116.42375, 33.68413], [-116.42366, 33.68321], [-116.42348, 33.68225], [-116.42102, 33.67791], [-116.42092, 33.67739], [-116.41891, 33.67625], [-116.41686, 33.6757], [-116.4163, 33.67524], [-116.41641, 33.67467], [-116.41631, 33.67457], [-116.41632, 33.67446], [-116.41628, 33.67436], [-116.41599, 33.67408], [-116.41578, 33.67406], [-116.41563, 33.67392], [-116.41474, 33.67379], [-116.41409, 33.67414], [-116.41322, 33.67388], [-116.41171, 33.67319], [-116.41164, 33.67302], [-116.41166, 33.6721], [-116.4118, 33.6721], [-116.4119, 33.67207], [-116.41196, 33.672], [-116.41201, 33.67187], [-116.412, 33.67179], [-116.41196, 33.67172], [-116.41186, 33.67163], [-116.41177, 33.67159], [-116.41442, 33.67067], [-116.41673, 33.67067], [-116.41674, 33.67069], [-116.4254, 33.67068], [-116.42543, 33.68504]], [[-116.41672, 33.67293], [-116.41648, 33.6729], [-116.41612, 33.67323], [-116.41612, 33.6734], [-116.41694, 33.67337], [-116.41696, 33.67309], [-116.41677, 33.67294], [-116.41672, 33.67293]]]]}	Open Access 1	5785	Santa Rosa and San Jacinto Mountains National Monument	8325	1240	Palm Desert, City of 215	City 2	City Agency 2	http://www.cityofpalmdesert.org/Index.aspx?page=174	City 2	1240	Palm Desert, City of 211	City 2	City Agency 2	Riverside 10	562.433	Santa Rosa and San Jacinto Mtns. NM	2000	National Monument or Landmark 80	3
16984	16984	16983	{"type": "MultiPolygon", "coordinates": [[[[-116.29417, 33.63475], [-116.28536, 33.6349], [-116.28539, 33.63048], [-116.28628, 33.63084], [-116.28641, 33.63086], [-116.28663, 33.63084], [-116.28664, 33.63125], [-116.287, 33.6318], [-116.28734, 33.63194], [-116.28757, 33.63265], [-116.28748, 33.63325], [-116.28763, 33.63324], [-116.28777, 33.63302], [-116.2879, 33.63307], [-116.28798, 33.63302], [-116.28825, 33.6329], [-116.28847, 33.63297], [-116.28858, 33.63282], [-116.28992, 33.63292], [-116.2908, 33.63331], [-116.29086, 33.63325], [-116.29062, 33.6329], [-116.2906, 33.6326], [-116.29091, 33.63264], [-116.29154, 33.63335], [-116.29173, 33.6334], [-116.29174, 33.63339], [-116.2917, 33.63327], [-116.29156, 33.6332], [-116.29145, 33.63265], [-116.29161, 33.63256], [-116.29177, 33.63273], [-116.29182, 33.63295], [-116.29198, 33.6328], [-116.29229, 33.63274], [-116.29303, 33.63303], [-116.29374, 33.63312], [-116.29414, 33.63314], [-116.29417, 33.63475]]], [[[-116.29398, 33.63067], [-116.29318, 33.62999], [-116.2932, 33.62982], [-116.29306, 33.62973], [-116.29256, 33.62926], [-116.29256, 33.62916], [-116.29315, 33.62898], [-116.29324, 33.6286], [-116.29375, 33.62868], [-116.29369, 33.62858], [-116.29344, 33.62838], [-116.29306, 33.62825], [-116.29306, 33.62806], [-116.29324, 33.62779], [-116.29385, 33.62784], [-116.29385, 33.62779], [-116.29358, 33.62755], [-116.29396, 33.62754], [-116.29398, 33.63067]]]]}	Open Access 1	5792	Santa Rosa and San Jacinto Mountains National Monument	25130	1161	La Quinta, City of 612	City 2	City Agency 2	http://www.la-quinta.org/your-government/community-services/city-parks	City 2	1161	La Quinta, City of 601	City 2	City Agency 2	Riverside 10	57.461	Santa Rosa and San Jacinto Mtns. NM	2000	National Monument or Landmark 80	3
16987	16987	16986	{"type": "MultiPolygon", "coordinates": [[[[-116.45598, 33.64882], [-116.44832, 33.64885], [-116.44301, 33.64885], [-116.44283, 33.64527], [-116.44727, 33.64526], [-116.44728, 33.6416], [-116.45169, 33.6416], [-116.45169, 33.64524], [-116.45597, 33.64524], [-116.45598, 33.64882]]], [[[-116.58839, 33.78979], [-116.58817, 33.7898], [-116.58804, 33.78983], [-116.58789, 33.7899], [-116.58779, 33.79002], [-116.58763, 33.79028], [-116.58752, 33.79034], [-116.58742, 33.7903], [-116.58707, 33.78996], [-116.58697, 33.78967], [-116.58692, 33.78958], [-116.58674, 33.78955], [-116.58663, 33.7896], [-116.58654, 33.78969], [-116.58651, 33.78978], [-116.58644, 33.78988], [-116.58625, 33.78999], [-116.58619, 33.79], [-116.58573, 33.78994], [-116.58553, 33.78985], [-116.58535, 33.78981], [-116.5853, 33.78978], [-116.58524, 33.78972], [-116.58516, 33.78956], [-116.58501, 33.78941], [-116.58483, 33.78928], [-116.58457, 33.78907], [-116.5845, 33.78884], [-116.58445, 33.78879], [-116.58416, 33.7887], [-116.58414, 33.78669], [-116.58837, 33.78667], [-116.58839, 33.78979]]], [[[-116.59685, 33.79389], [-116.59266, 33.79392], [-116.59262, 33.79028], [-116.59684, 33.79025], [-116.59685, 33.79389]]], [[[-116.56323, 33.80153], [-116.55962, 33.80147], [-116.55074, 33.80137], [-116.55057, 33.80085], [-116.55113, 33.80049], [-116.55137, 33.80031], [-116.55159, 33.79937], [-116.55164, 33.79875], [-116.55161, 33.79843], [-116.55161, 33.79837], [-116.55155, 33.79832], [-116.55155, 33.79819], [-116.5516, 33.79775], [-116.55157, 33.79771], [-116.55148, 33.79765], [-116.55125, 33.79764], [-116.55184, 33.79764], [-116.55198, 33.79718], [-116.55157, 33.79687], [-116.55132, 33.79629], [-116.55046, 33.79594], [-116.55005, 33.79555], [-116.54939, 33.79511], [-116.54909, 33.79478], [-116.55181, 33.79478], [-116.55184, 33.79264], [-116.54945, 33.79262], [-116.54897, 33.79248], [-116.5486, 33.79157], [-116.5486, 33.79105], [-116.54789, 33.79103], [-116.54778, 33.79158], [-116.54768, 33.79158], [-116.54769, 33.79061], [-116.54751, 33.7906], [-116.5475, 33.78922], [-116.54744, 33.78921], [-116.54775, 33.78855], [-116.54807, 33.78802], [-116.54815, 33.78745], [-116.54809, 33.78704], [-116.54819, 33.78685], [-116.56316, 33.78691], [-116.56323, 33.80153]]], [[[-116.5631, 33.81604], [-116.56304, 33.82941], [-116.56085, 33.83032], [-116.55565, 33.83032], [-116.55429, 33.83027], [-116.55428, 33.8304], [-116.55352, 33.8304], [-116.55373, 33.83006], [-116.55404, 33.82972], [-116.55405, 33.82962], [-116.55405, 33.82957], [-116.554, 33.8295], [-116.55367, 33.82924], [-116.55362, 33.82908], [-116.5536, 33.82891], [-116.55357, 33.82887], [-116.55353, 33.82882], [-116.55321, 33.82864], [-116.55298, 33.82848], [-116.55284, 33.82824], [-116.55275, 33.82802], [-116.55268, 33.82795], [-116.55261, 33.82792], [-116.55248, 33.82789], [-116.55167, 33.8279], [-116.55101, 33.82809], [-116.5506, 33.82814], [-116.55042, 33.82822], [-116.55079, 33.82852], [-116.55129, 33.82881], [-116.55146, 33.82935], [-116.55175, 33.82934], [-116.55216, 33.82942], [-116.55266, 33.82935], [-116.55285, 33.82943], [-116.55302, 33.8296], [-116.55363, 33.82957], [-116.55366, 33.82993], [-116.55346, 33.8304], [-116.5481, 33.83015], [-116.54807, 33.82561], [-116.54829, 33.82541], [-116.55427, 33.82541], [-116.55424, 33.81778], [-116.55466, 33.81777], [-116.55465, 33.81673], [-116.55501, 33.81672], [-116.55501, 33.81627], [-116.55491, 33.81626], [-116.55491, 33.81593], [-116.5631, 33.81604]]], [[[-116.5806, 33.84508], [-116.56296, 33.84488], [-116.56305, 33.84079], [-116.56314, 33.84063], [-116.56318, 33.84051], [-116.56327, 33.84038], [-116.56332, 33.84017], [-116.56342, 33.83998], [-116.56347, 33.8399], [-116.56353, 33.83987], [-116.56355, 33.83979], [-116.56353, 33.83969], [-116.56354, 33.83957], [-116.56361, 33.83945], [-116.56354, 33.83933], [-116.56351, 33.83923], [-116.56349, 33.83906], [-116.56355, 33.83881], [-116.56362, 33.83863], [-116.56357, 33.83849], [-116.56349, 33.83818], [-116.56351, 33.83804], [-116.56335, 33.83774], [-116.56331, 33.83758], [-116.5633, 33.83714], [-116.56335, 33.83681], [-116.56325, 33.83669], [-116.56461, 33.83668], [-116.56462, 33.83609], [-116.56444, 33.83583], [-116.56442, 33.83572], [-116.56451, 33.83549], [-116.56461, 33.8354], [-116.56478, 33.83534], [-116.56524, 33.8351], [-116.56549, 33.83501], [-116.56584, 33.83492], [-116.56626, 33.83484], [-116.56641, 33.83478], [-116.56658, 33.83466], [-116.56671, 33.83453], [-116.56696, 33.83461], [-116.56705, 33.8346], [-116.56708, 33.83455], [-116.5671, 33.83444], [-116.56715, 33.83437], [-116.56726, 33.83434], [-116.56729, 33.83428], [-116.56731, 33.83419], [-116.56735, 33.83417], [-116.56741, 33.83408], [-116.56738, 33.83393], [-116.56738, 33.83374], [-116.56732, 33.83366], [-116.56661, 33.83309], [-116.56634, 33.83294], [-116.56619, 33.83279], [-116.56616, 33.83268], [-116.56626, 33.83246], [-116.5663, 33.83208], [-116.56648, 33.83162], [-116.56666, 33.83103], [-116.5668, 33.83076], [-116.56675, 33.83045], [-116.57471, 33.83041], [-116.58024, 33.83042], [-116.58025, 33.83067], [-116.58059, 33.83067], [-116.5806, 33.84508]]], [[[-116.59707, 33.85934], [-116.58047, 33.85949], [-116.58043, 33.85485], [-116.58245, 33.85483], [-116.5868, 33.85048], [-116.58694, 33.85047], [-116.58874, 33.85195], [-116.59006, 33.85195], [-116.59174, 33.85027], [-116.59259, 33.84761], [-116.59258, 33.84609], [-116.59307, 33.8461], [-116.59621, 33.84759], [-116.59703, 33.84877], [-116.59707, 33.85934]]], [[[-116.60571, 33.87064], [-116.60136, 33.87069], [-116.60135, 33.86804], [-116.6019, 33.86804], [-116.6019, 33.86712], [-116.60569, 33.86709], [-116.60571, 33.87064]]]]}	Open Access 1	5788	Santa Rosa and San Jacinto Mountains National Monument	8337	1241	Palm Springs, City of 553	City 2	City Agency 2	http://www.ci.palm-springs.ca.us/index.aspx?page=80	City 2	1241	Palm Springs, City of 546	City 2	City Agency 2	Riverside 10	2097.744	Santa Rosa and San Jacinto Mtns. NM	2000	National Monument or Landmark 80	3
16991	16991	16990	{"type": "MultiPolygon", "coordinates": [[[[-116.47773, 33.74318], [-116.47769, 33.75611], [-116.47746, 33.75617], [-116.47731, 33.75678], [-116.47668, 33.75743], [-116.47654, 33.75765], [-116.47769, 33.75766], [-116.47768, 33.75939], [-116.47499, 33.76165], [-116.47293, 33.76164], [-116.47262, 33.76235], [-116.47263, 33.76253], [-116.47266, 33.76263], [-116.47272, 33.76274], [-116.47272, 33.76285], [-116.47266, 33.76298], [-116.47254, 33.76307], [-116.47245, 33.7631], [-116.47232, 33.7631], [-116.47218, 33.76307], [-116.47209, 33.763], [-116.472, 33.76286], [-116.47192, 33.76235], [-116.47188, 33.76229], [-116.4718, 33.76222], [-116.47171, 33.76219], [-116.47163, 33.76219], [-116.47152, 33.76223], [-116.47143, 33.76232], [-116.47142, 33.76245], [-116.47148, 33.76254], [-116.47173, 33.76276], [-116.47175, 33.76281], [-116.47175, 33.7629], [-116.47172, 33.76297], [-116.47137, 33.76323], [-116.47064, 33.76344], [-116.47038, 33.76402], [-116.47033, 33.76408], [-116.47025, 33.7641], [-116.47016, 33.76405], [-116.47005, 33.76374], [-116.47, 33.7637], [-116.46995, 33.76369], [-116.46987, 33.76372], [-116.46932, 33.7644], [-116.46774, 33.76437], [-116.46748, 33.76383], [-116.46741, 33.76379], [-116.46732, 33.76376], [-116.46718, 33.76377], [-116.46707, 33.76382], [-116.46703, 33.76388], [-116.46677, 33.76472], [-116.46677, 33.76481], [-116.46682, 33.7649], [-116.46692, 33.76498], [-116.46701, 33.76501], [-116.46797, 33.76511], [-116.46806, 33.76509], [-116.4682, 33.76502], [-116.46837, 33.76486], [-116.46847, 33.76481], [-116.46853, 33.76479], [-116.46869, 33.76479], [-116.46883, 33.76485], [-116.46888, 33.76488], [-116.46895, 33.76498], [-116.46893, 33.76543], [-116.46872, 33.76557], [-116.46837, 33.76548], [-116.46823, 33.76548], [-116.4681, 33.76555], [-116.46804, 33.76564], [-116.46804, 33.76572], [-116.46806, 33.76577], [-116.46815, 33.76585], [-116.46823, 33.76588], [-116.46858, 33.76587], [-116.46868, 33.76588], [-116.46877, 33.76595], [-116.46879, 33.76606], [-116.46873, 33.76615], [-116.46864, 33.76619], [-116.46818, 33.76616], [-116.4679, 33.76644], [-116.46781, 33.76647], [-116.46771, 33.76647], [-116.46758, 33.76642], [-116.46751, 33.76633], [-116.4675, 33.76604], [-116.46748, 33.766], [-116.46743, 33.76594], [-116.46733, 33.7659], [-116.46722, 33.7659], [-116.46714, 33.76592], [-116.46707, 33.76598], [-116.46705, 33.76602], [-116.46692, 33.76643], [-116.46745, 33.7669], [-116.46725, 33.76737], [-116.46729, 33.7679], [-116.46688, 33.76798], [-116.46673, 33.76805], [-116.46668, 33.76811], [-116.46663, 33.7682], [-116.46663, 33.76833], [-116.46668, 33.76842], [-116.46678, 33.76852], [-116.46585, 33.7691], [-116.46571, 33.76915], [-116.46562, 33.76915], [-116.46546, 33.76909], [-116.46538, 33.76901], [-116.46512, 33.76855], [-116.46482, 33.76838], [-116.46406, 33.76692], [-116.46401, 33.76687], [-116.46389, 33.76682], [-116.46381, 33.76682], [-116.46372, 33.76685], [-116.46365, 33.7669], [-116.46361, 33.76696], [-116.46324, 33.76793], [-116.46324, 33.76811], [-116.46333, 33.76831], [-116.4634, 33.76838], [-116.46349, 33.76846], [-116.4637, 33.76856], [-116.46028, 33.76854], [-116.46029, 33.76782], [-116.46185, 33.76782], [-116.46227, 33.76738], [-116.4624, 33.76697], [-116.46243, 33.76691], [-116.46253, 33.76683], [-116.46266, 33.76679], [-116.46337, 33.76674], [-116.46352, 33.76668], [-116.46365, 33.76659], [-116.4637, 33.76652], [-116.46375, 33.76642], [-116.46385, 33.76592], [-116.46426, 33.76558], [-116.46447, 33.76492], [-116.46455, 33.76473], [-116.46469, 33.76464], [-116.46482, 33.7645], [-116.46487, 33.76438], [-116.4649, 33.76428], [-116.46487, 33.76369], [-116.46455, 33.7631], [-116.46376, 33.76273], [-116.46365, 33.76266], [-116.46356, 33.76252], [-116.46354, 33.76246], [-116.46354, 33.7623], [-116.46359, 33.76218], [-116.4638, 33.76188], [-116.46381, 33.76175], [-116.46379, 33.76169], [-116.46373, 33.76162], [-116.46363, 33.76156], [-116.46337, 33.76151], [-116.46325, 33.76146], [-116.46319, 33.76141], [-116.4631, 33.76131], [-116.46305, 33.76118], [-116.46305, 33.76104], [-116.46332, 33.75978], [-116.46336, 33.75967], [-116.46343, 33.75956], [-116.46356, 33.75941], [-116.46407, 33.75905], [-116.46414, 33.75892], [-116.46414, 33.75883], [-116.4641, 33.75873], [-116.46371, 33.75833], [-116.46366, 33.75826], [-116.46361, 33.75811], [-116.46362, 33.75789], [-116.46338, 33.75766], [-116.46034, 33.75767], [-116.46032, 33.74316], [-116.46034, 33.74322], [-116.47772, 33.74322], [-116.47773, 33.74318]], [[-116.46548, 33.7667], [-116.46549, 33.76669], [-116.46545, 33.76493], [-116.46459, 33.76492], [-116.4646, 33.7667], [-116.46548, 33.7667]], [[-116.47653, 33.75767], [-116.47652, 33.75766], [-116.47486, 33.75766], [-116.47484, 33.7578], [-116.47532, 33.75803], [-116.47556, 33.75828], [-116.47556, 33.75855], [-116.47521, 33.75965], [-116.47555, 33.76053], [-116.47559, 33.76059], [-116.47565, 33.76062], [-116.47571, 33.76063], [-116.47578, 33.76061], [-116.47583, 33.76058], [-116.47586, 33.76053], [-116.47611, 33.75981], [-116.47607, 33.75932], [-116.4761, 33.75914], [-116.47618, 33.75897], [-116.47635, 33.75877], [-116.47638, 33.75864], [-116.47637, 33.75857], [-116.47634, 33.75851], [-116.47622, 33.75841], [-116.47609, 33.75837], [-116.47588, 33.75837], [-116.47576, 33.75831], [-116.4757, 33.75822], [-116.47571, 33.75813], [-116.47576, 33.75805], [-116.47587, 33.75799], [-116.47597, 33.75798], [-116.47615, 33.75802], [-116.47624, 33.75801], [-116.47631, 33.75799], [-116.4764, 33.75791], [-116.47653, 33.75767]]], [[[-116.46033, 33.75769], [-116.46031, 33.76137], [-116.45967, 33.76136], [-116.4594, 33.76151], [-116.45945, 33.76134], [-116.45948, 33.76129], [-116.45955, 33.76122], [-116.45982, 33.761], [-116.45986, 33.76095], [-116.45992, 33.76086], [-116.45993, 33.76074], [-116.45992, 33.76069], [-116.45979, 33.76047], [-116.45977, 33.76041], [-116.45978, 33.76023], [-116.45974, 33.76016], [-116.45972, 33.76014], [-116.45972, 33.75968], [-116.45907, 33.75968], [-116.45906, 33.7602], [-116.45964, 33.76022], [-116.45969, 33.76028], [-116.45969, 33.76042], [-116.45983, 33.76071], [-116.45983, 33.76084], [-116.45978, 33.76094], [-116.45973, 33.76099], [-116.45947, 33.76119], [-116.45941, 33.76126], [-116.45937, 33.76132], [-116.45929, 33.76157], [-116.45881, 33.76183], [-116.45805, 33.76228], [-116.45689, 33.76305], [-116.45646, 33.76411], [-116.45621, 33.76429], [-116.45592, 33.76487], [-116.45604, 33.76523], [-116.45589, 33.76574], [-116.45529, 33.76574], [-116.45361, 33.76668], [-116.45361, 33.76744], [-116.45385, 33.76757], [-116.45466, 33.7681], [-116.45591, 33.76952], [-116.45478, 33.7695], [-116.45458, 33.76948], [-116.4531, 33.76921], [-116.45292, 33.76921], [-116.45271, 33.76925], [-116.45157, 33.76905], [-116.45132, 33.76962], [-116.45093, 33.7698], [-116.4505, 33.77022], [-116.44985, 33.77058], [-116.44902, 33.77053], [-116.44885, 33.77129], [-116.44869, 33.77131], [-116.44856, 33.77134], [-116.44841, 33.7714], [-116.44826, 33.77149], [-116.44818, 33.77156], [-116.44807, 33.77168], [-116.44797, 33.77185], [-116.44787, 33.77198], [-116.44771, 33.77211], [-116.44777, 33.77202], [-116.4478, 33.77194], [-116.44781, 33.77158], [-116.44788, 33.77142], [-116.448, 33.77129], [-116.44804, 33.77126], [-116.4482, 33.77118], [-116.44832, 33.77115], [-116.44835, 33.77105], [-116.44692, 33.77066], [-116.44646, 33.76922], [-116.44629, 33.76878], [-116.44707, 33.76846], [-116.44718, 33.76852], [-116.44756, 33.76911], [-116.44915, 33.76842], [-116.44875, 33.76773], [-116.44911, 33.76757], [-116.45082, 33.76739], [-116.45078, 33.76707], [-116.45081, 33.76703], [-116.45074, 33.76686], [-116.45069, 33.76649], [-116.45022, 33.7662], [-116.4484, 33.76641], [-116.44751, 33.76619], [-116.44673, 33.76652], [-116.44637, 33.76594], [-116.44632, 33.76583], [-116.44628, 33.76568], [-116.44625, 33.76547], [-116.44625, 33.76525], [-116.44628, 33.76505], [-116.44624, 33.76501], [-116.44852, 33.76405], [-116.4499, 33.7623], [-116.44989, 33.76216], [-116.44977, 33.76144], [-116.44927, 33.76055], [-116.44859, 33.75994], [-116.44718, 33.76017], [-116.44713, 33.76006], [-116.44631, 33.7602], [-116.4458, 33.75985], [-116.44525, 33.75965], [-116.44501, 33.75957], [-116.44467, 33.75969], [-116.44419, 33.75944], [-116.44414, 33.7594], [-116.44404, 33.75928], [-116.44372, 33.75859], [-116.44293, 33.75858], [-116.44293, 33.75769], [-116.46033, 33.75769]], [[-116.45332, 33.769], [-116.4543, 33.76917], [-116.45443, 33.76864], [-116.4532, 33.76842], [-116.45332, 33.769]]], [[[-116.46027, 33.77149], [-116.46026, 33.77245], [-116.45811, 33.77254], [-116.4581, 33.77241], [-116.44763, 33.77245], [-116.44755, 33.77239], [-116.44757, 33.77232], [-116.44784, 33.77218], [-116.448, 33.77204], [-116.44806, 33.77198], [-116.44819, 33.77176], [-116.44835, 33.77159], [-116.44843, 33.77153], [-116.44861, 33.77145], [-116.44883, 33.77141], [-116.44913, 33.77143], [-116.44955, 33.77156], [-116.44975, 33.7716], [-116.44996, 33.77159], [-116.45011, 33.77157], [-116.45037, 33.77146], [-116.4505, 33.77137], [-116.45065, 33.77122], [-116.451, 33.77072], [-116.45114, 33.77055], [-116.45147, 33.77021], [-116.45172, 33.77], [-116.45261, 33.76941], [-116.45275, 33.76936], [-116.453, 33.76932], [-116.45318, 33.76934], [-116.45456, 33.76959], [-116.45485, 33.76962], [-116.45602, 33.76963], [-116.45635, 33.76959], [-116.45661, 33.7695], [-116.45698, 33.76978], [-116.45704, 33.77035], [-116.45764, 33.77136], [-116.45769, 33.7719], [-116.45777, 33.77201], [-116.45841, 33.77207], [-116.45873, 33.7718], [-116.4597, 33.77182], [-116.46027, 33.77149]]]]}	Open Access 1	11569	Santa Rosa and San Jacinto Mountains National Monument	8932	1264	Rancho Mirage, City of 594	City 2	City Agency 2	http://www.ranchomirageca.gov/residents/parks-trails/	City 2	1264	Rancho Mirage, City of 584	City 2	City Agency 2	Riverside 10	1207.988	Santa Rosa and San Jacinto Mtns. NM	2000	National Monument or Landmark 80	3

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]);