calands: units_with_maps: 6 rows where ACCESS_TYP = 1, AGNCY_TYP = 31 and MNG_AG

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

6 rows where ACCESS_TYP = 1, AGNCY_TYP = 31 and MNG_AG_TYP = 6

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	PARK_URL	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
9995	9995	9994	{"type": "Polygon", "coordinates": [[[-118.06629, 34.01001], [-118.06603, 34.01028], [-118.06535, 34.00982], [-118.06545, 34.00971], [-118.06551, 34.00974], [-118.0657, 34.00954], [-118.06572, 34.00956], [-118.06569, 34.00961], [-118.06629, 34.01001]]]}	Open Access 1	47987	Citrus Grove Heights Bike Stop	32407	2177	Watershed Conservation Authority 860	Special District 4	Conservation District 31	https://www.wca.ca.gov/	Special District 4	2088	Mountains Recreation and Conservation Authority 27	Special District 4	Open Space District 6		Los Angeles 6	0.744	Citrus Grove Heights Bike Stop		None 862
15282	15282	15281	{"type": "MultiPolygon", "coordinates": [[[[-118.01566, 33.97164], [-118.01565, 33.97527], [-118.01129, 33.97522], [-118.01115, 33.98076], [-118.01084, 33.98063], [-118.01028, 33.98102], [-118.00999, 33.982], [-118.01005, 33.9824], [-117.9948, 33.9824], [-117.99477, 33.9823], [-117.99471, 33.9822], [-117.99452, 33.98203], [-117.99442, 33.98198], [-117.99428, 33.98195], [-117.99397, 33.98193], [-117.99359, 33.98169], [-117.99375, 33.97568], [-117.99376, 33.97516], [-117.9848, 33.97512], [-117.98554, 33.97458], [-117.98606, 33.97426], [-117.98662, 33.97397], [-117.98857, 33.97305], [-117.98896, 33.97284], [-117.98942, 33.97254], [-117.98976, 33.97228], [-117.99001, 33.97207], [-117.99024, 33.97185], [-117.99173, 33.97028], [-117.9921, 33.96997], [-117.99243, 33.96974], [-117.99382, 33.9689], [-117.99382, 33.96927], [-117.99384, 33.96928], [-117.9948, 33.96871], [-117.99517, 33.96823], [-117.99565, 33.96816], [-117.99626, 33.96747], [-117.99656, 33.96738], [-117.99668, 33.96732], [-117.99694, 33.96746], [-117.99761, 33.96689], [-117.99784, 33.9669], [-117.9991, 33.9668], [-118.00017, 33.9661], [-118.00034, 33.9661], [-118.00104, 33.96561], [-118.00152, 33.96516], [-118.00193, 33.96458], [-118.00592, 33.96477], [-118.00774, 33.96578], [-118.00796, 33.96556], [-118.00827, 33.96532], [-118.00839, 33.96528], [-118.00875, 33.96504], [-118.00875, 33.96502], [-118.00951, 33.96456], [-118.00958, 33.96441], [-118.0098, 33.96413], [-118.0099, 33.96386], [-118.00989, 33.96384], [-118.01017, 33.96353], [-118.01029, 33.9636], [-118.01004, 33.96394], [-118.01053, 33.9642], [-118.00966, 33.9653], [-118.0101, 33.96556], [-118.00944, 33.96637], [-118.00857, 33.96682], [-118.00824, 33.96752], [-118.00951, 33.96824], [-118.00918, 33.96867], [-118.00952, 33.96888], [-118.00921, 33.96926], [-118.00846, 33.96884], [-118.00843, 33.96896], [-118.00792, 33.9694], [-118.00795, 33.9695], [-118.00887, 33.97002], [-118.00827, 33.97078], [-118.0088, 33.97086], [-118.00905, 33.97078], [-118.01025, 33.96928], [-118.01347, 33.97108], [-118.01348, 33.97164], [-118.01566, 33.97164]]], [[[-117.99476, 33.9824], [-117.99357, 33.98241], [-117.99359, 33.98173], [-117.99379, 33.98188], [-117.99396, 33.98196], [-117.99427, 33.98198], [-117.9945, 33.98206], [-117.99468, 33.98222], [-117.99473, 33.98231], [-117.99476, 33.9824]]]]}	Open Access 1	46392	Arroyo Pescadero	29674	2332	Puente Hills Habitat Preservation Authority 849	Special District 4	Conservation District 31	http://www.habitatauthority.org	Special District 4	2088	Mountains Recreation and Conservation Authority 27	Special District 4	Open Space District 6		Los Angeles 6	812.555	Arroyo Pescadero	0	None 1345
16053	16053	16052	{"type": "MultiPolygon", "coordinates": [[[[-118.02124, 33.98973], [-118.01938, 33.99107], [-118.0193, 33.99111], [-118.01914, 33.99113], [-118.01881, 33.99105], [-118.01825, 33.99098], [-118.01817, 33.99099], [-118.01806, 33.99103], [-118.01801, 33.99109], [-118.01799, 33.99115], [-118.01798, 33.99122], [-118.01801, 33.99128], [-118.01806, 33.99134], [-118.01813, 33.99138], [-118.01834, 33.99141], [-118.01844, 33.99146], [-118.01848, 33.99151], [-118.0185, 33.99157], [-118.01849, 33.99163], [-118.01846, 33.99168], [-118.01838, 33.99174], [-118.01777, 33.99197], [-118.01761, 33.99207], [-118.01749, 33.99221], [-118.01745, 33.99232], [-118.01743, 33.99245], [-118.01739, 33.99251], [-118.01733, 33.99255], [-118.01699, 33.99269], [-118.01688, 33.99277], [-118.01675, 33.99292], [-118.01663, 33.99311], [-118.01655, 33.99321], [-118.01627, 33.99341], [-118.01594, 33.99366], [-118.01583, 33.99372], [-118.01548, 33.99379], [-118.01535, 33.9938], [-118.01522, 33.99379], [-118.01504, 33.99373], [-118.01494, 33.99366], [-118.01486, 33.99358], [-118.01433, 33.99283], [-118.01421, 33.99276], [-118.01412, 33.99274], [-118.01402, 33.99275], [-118.01394, 33.99278], [-118.01384, 33.99287], [-118.01381, 33.99295], [-118.01382, 33.99322], [-118.01388, 33.9935], [-118.01385, 33.99356], [-118.01377, 33.99359], [-118.01332, 33.99357], [-118.0132, 33.99358], [-118.01303, 33.99365], [-118.01291, 33.99377], [-118.01286, 33.99387], [-118.01284, 33.99397], [-118.01286, 33.99407], [-118.01289, 33.99415], [-118.013, 33.99428], [-118.01325, 33.99441], [-118.01328, 33.99446], [-118.01329, 33.99451], [-118.01326, 33.99456], [-118.0128, 33.99492], [-118.01271, 33.99497], [-118.01261, 33.99501], [-118.01246, 33.99501], [-118.01143, 33.9949], [-118.01127, 33.99491], [-118.01118, 33.99494], [-118.01103, 33.99502], [-118.01092, 33.99504], [-118.01081, 33.99502], [-118.01056, 33.99493], [-118.0104, 33.99491], [-118.00955, 33.99493], [-118.00949, 33.99491], [-118.00945, 33.99485], [-118.00944, 33.99481], [-118.00946, 33.99463], [-118.00941, 33.9945], [-118.00934, 33.99442], [-118.00925, 33.99437], [-118.00909, 33.99432], [-118.00892, 33.99434], [-118.00859, 33.99448], [-118.00843, 33.99456], [-118.00828, 33.99468], [-118.00823, 33.9947], [-118.00794, 33.99471], [-118.00777, 33.99478], [-118.00771, 33.99478], [-118.00767, 33.99476], [-118.00765, 33.99472], [-118.00767, 33.99442], [-118.00764, 33.99422], [-118.0075, 33.99388], [-118.00748, 33.99373], [-118.00745, 33.99362], [-118.00723, 33.99329], [-118.00715, 33.99324], [-118.007, 33.9932], [-118.00684, 33.99323], [-118.00676, 33.99328], [-118.0067, 33.99335], [-118.00667, 33.99343], [-118.00665, 33.99367], [-118.00662, 33.99373], [-118.00644, 33.99391], [-118.00641, 33.99399], [-118.00637, 33.99426], [-118.00631, 33.9943], [-118.00625, 33.99429], [-118.00604, 33.99416], [-118.00598, 33.99408], [-118.00576, 33.99336], [-118.00572, 33.99328], [-118.00565, 33.99322], [-118.00556, 33.99317], [-118.00541, 33.99315], [-118.00531, 33.99318], [-118.00522, 33.99322], [-118.00515, 33.9933], [-118.00505, 33.99344], [-118.00498, 33.99349], [-118.00489, 33.9935], [-118.00469, 33.99343], [-118.00459, 33.99343], [-118.00447, 33.99347], [-118.00437, 33.99355], [-118.00432, 33.99367], [-118.00434, 33.99398], [-118.00433, 33.99405], [-118.00429, 33.99412], [-118.00419, 33.99421], [-118.00413, 33.99434], [-118.00414, 33.99447], [-118.00424, 33.99463], [-118.00422, 33.99469], [-118.00417, 33.99473], [-118.004, 33.99475], [-118.00385, 33.99471], [-118.00362, 33.99458], [-118.00356, 33.99451], [-118.00286, 33.99423], [-118.00262, 33.99423], [-118.00249, 33.99428], [-118.00237, 33.99438], [-118.00218, 33.99415], [-118.00226, 33.98961], [-117.99339, 33.98965], [-117.99357, 33.98241], [-118.00675, 33.9824], [-118.00666, 33.98603], [-118.01101, 33.98603], [-118.01979, 33.98612], [-118.01973, 33.98968], [-118.02124, 33.98973]]], [[[-118.02863, 33.98995], [-118.02862, 33.99703], [-118.01632, 33.99904], [-118.01394, 34.0002], [-118.01117, 34.00059], [-118.0107, 34.0018], [-118.0098, 34.00224], [-118.00612, 33.99767], [-118.00524, 33.99916], [-118.00413, 33.99864], [-118.00401, 33.99855], [-118.00371, 33.99829], [-118.00297, 33.99793], [-118.00352, 33.99749], [-118.00324, 33.99706], [-118.0028, 33.99704], [-118.00252, 33.99745], [-118.00104, 33.99676], [-118.00161, 33.99657], [-118.00173, 33.9965], [-118.00181, 33.99641], [-118.00186, 33.99632], [-118.00189, 33.99618], [-118.00188, 33.99599], [-118.00182, 33.9958], [-118.00166, 33.99552], [-118.00165, 33.99537], [-118.00168, 33.99532], [-118.00176, 33.9953], [-118.00183, 33.99532], [-118.00208, 33.9951], [-118.00245, 33.99459], [-118.00254, 33.99449], [-118.00268, 33.99443], [-118.00285, 33.99443], [-118.00347, 33.99467], [-118.00385, 33.99486], [-118.00407, 33.99489], [-118.00424, 33.99486], [-118.00435, 33.99478], [-118.0044, 33.99467], [-118.0044, 33.99459], [-118.00431, 33.99444], [-118.0043, 33.99436], [-118.00433, 33.99428], [-118.00446, 33.99415], [-118.00449, 33.99407], [-118.0045, 33.99397], [-118.00448, 33.99369], [-118.00451, 33.99362], [-118.00456, 33.99358], [-118.00463, 33.99356], [-118.00489, 33.99363], [-118.00498, 33.99363], [-118.00507, 33.99361], [-118.00518, 33.99353], [-118.00531, 33.99333], [-118.00541, 33.99329], [-118.00552, 33.99331], [-118.00559, 33.99337], [-118.0058, 33.99408], [-118.00586, 33.9942], [-118.00592, 33.99425], [-118.00615, 33.9944], [-118.00622, 33.99443], [-118.0063, 33.99444], [-118.00642, 33.99442], [-118.00648, 33.99438], [-118.00652, 33.99432], [-118.00658, 33.99398], [-118.00675, 33.99381], [-118.00682, 33.99369], [-118.00683, 33.9936], [-118.00682, 33.99346], [-118.00684, 33.9934], [-118.00689, 33.99336], [-118.00696, 33.99333], [-118.00703, 33.99334], [-118.0071, 33.99337], [-118.00714, 33.99341], [-118.00729, 33.99369], [-118.00734, 33.99393], [-118.00747, 33.99424], [-118.00749, 33.99436], [-118.00748, 33.99471], [-118.0075, 33.99478], [-118.00757, 33.99486], [-118.00768, 33.99491], [-118.0078, 33.99491], [-118.00799, 33.99485], [-118.00818, 33.99485], [-118.00829, 33.99483], [-118.00838, 33.99479], [-118.00862, 33.99462], [-118.00896, 33.99448], [-118.00907, 33.99446], [-118.00918, 33.99449], [-118.00926, 33.99456], [-118.0093, 33.99465], [-118.00927, 33.99481], [-118.0093, 33.99492], [-118.00939, 33.99502], [-118.00952, 33.99507], [-118.01046, 33.99505], [-118.01058, 33.99507], [-118.01079, 33.99516], [-118.01092, 33.99518], [-118.01109, 33.99515], [-118.01127, 33.99506], [-118.0114, 33.99504], [-118.0125, 33.99516], [-118.01263, 33.99515], [-118.01275, 33.99512], [-118.01291, 33.99503], [-118.01335, 33.99467], [-118.01341, 33.99461], [-118.01345, 33.99453], [-118.01344, 33.99443], [-118.01339, 33.99434], [-118.01332, 33.99429], [-118.01313, 33.9942], [-118.01303, 33.99409], [-118.013, 33.99396], [-118.01303, 33.99388], [-118.01312, 33.99377], [-118.01326, 33.99371], [-118.01378, 33.99372], [-118.01387, 33.9937], [-118.01398, 33.99364], [-118.01402, 33.99357], [-118.01404, 33.99349], [-118.01399, 33.99324], [-118.01396, 33.99298], [-118.01398, 33.99294], [-118.01402, 33.9929], [-118.01411, 33.99288], [-118.01417, 33.99289], [-118.01421, 33.99292], [-118.01476, 33.9937], [-118.01487, 33.99379], [-118.01499, 33.99387], [-118.01521, 33.99393], [-118.01544, 33.99394], [-118.01582, 33.99387], [-118.01599, 33.9938], [-118.01665, 33.99332], [-118.01675, 33.99322], [-118.0169, 33.99297], [-118.01698, 33.99288], [-118.01708, 33.99281], [-118.01741, 33.99267], [-118.0175, 33.99261], [-118.01758, 33.9925], [-118.01761, 33.99234], [-118.01764, 33.99225], [-118.01775, 33.99215], [-118.01784, 33.9921], [-118.01848, 33.99185], [-118.0186, 33.99176], [-118.01864, 33.99167], [-118.01866, 33.99158], [-118.01864, 33.99149], [-118.0186, 33.99141], [-118.01852, 33.99134], [-118.01843, 33.99129], [-118.01818, 33.99124], [-118.01815, 33.99119], [-118.01817, 33.99114], [-118.01823, 33.99112], [-118.0187, 33.99117], [-118.01913, 33.99127], [-118.01932, 33.99125], [-118.01949, 33.99118], [-118.02156, 33.98967], [-118.02178, 33.98944], [-118.02201, 33.98909], [-118.02239, 33.98861], [-118.02252, 33.98851], [-118.02262, 33.98847], [-118.02279, 33.98847], [-118.0229, 33.98849], [-118.02326, 33.98872], [-118.02349, 33.98882], [-118.02365, 33.98885], [-118.02391, 33.98887], [-118.02432, 33.98883], [-118.025, 33.98864], [-118.02659, 33.9884], [-118.02664, 33.98989], [-118.02863, 33.98995]]]]}	Open Access 1	6494	Turnbull Canyon Open Space	29669	2332	Puente Hills Habitat Preservation Authority 849	Special District 4	Conservation District 31	http://www.habitatauthority.org	Special District 4	2088	Mountains Recreation and Conservation Authority 27	Special District 4	Open Space District 6	http://www.hillsforeveryone.org/visitors-guide/ph-access.html	Los Angeles 6	982.018	Turnbull Canyon OS	0	Local Recreation Area 3	4
16054	16054	16053	{"type": "Polygon", "coordinates": [[[-118.05598, 34.00404], [-118.05588, 34.00488], [-118.05517, 34.00482], [-118.05493, 34.00456], [-118.05489, 34.00458], [-118.05126, 34.00442], [-118.05104, 34.0045], [-118.05088, 34.0045], [-118.05078, 34.00439], [-118.05031, 34.00437], [-118.05032, 34.004], [-118.05083, 34.00384], [-118.05083, 34.00382], [-118.04981, 34.0035], [-118.04948, 34.00345], [-118.04626, 34.00323], [-118.04625, 34.00324], [-118.04641, 34.00445], [-118.04344, 34.00374], [-118.04201, 34.00324], [-118.04011, 34.0028], [-118.03994, 34.00383], [-118.03882, 34.00374], [-118.03737, 34.00312], [-118.03733, 34.00079], [-118.04593, 34.00089], [-118.04604, 34.0017], [-118.04899, 34.00174], [-118.04936, 34.00199], [-118.04959, 34.00206], [-118.05047, 34.00241], [-118.05049, 34.00175], [-118.05062, 34.00175], [-118.05396, 34.00349], [-118.05557, 34.00362], [-118.05553, 34.004], [-118.05598, 34.00404]]]}	Open Access 1	6495	Sycamore Canyon Open Space	26116	2332	Puente Hills Habitat Preservation Authority 849	Special District 4	Conservation District 31	http://www.habitatauthority.org	Special District 4	2088	Mountains Recreation and Conservation Authority 27	Special District 4	Open Space District 6		Los Angeles 6	100.023	Sycamore Canyon OS	0	Local Recreation Area 3	4
16252	16252	16251	{"type": "MultiPolygon", "coordinates": [[[[-117.96366, 33.97258], [-117.96126, 33.97259], [-117.96126, 33.97247], [-117.9615, 33.97245], [-117.96176, 33.97236], [-117.96197, 33.97222], [-117.96214, 33.97202], [-117.96218, 33.97203], [-117.96226, 33.97185], [-117.96228, 33.97166], [-117.96225, 33.97165], [-117.96223, 33.97147], [-117.96217, 33.97133], [-117.96204, 33.97114], [-117.9622, 33.97105], [-117.96227, 33.97088], [-117.96243, 33.97101], [-117.96266, 33.97101], [-117.9629, 33.97107], [-117.96328, 33.97149], [-117.96366, 33.97258]]], [[[-117.96794, 33.97257], [-117.96656, 33.97258], [-117.96551, 33.97127], [-117.96533, 33.97112], [-117.9648, 33.97082], [-117.96593, 33.97054], [-117.96624, 33.97079], [-117.96645, 33.97069], [-117.96751, 33.97084], [-117.96766, 33.97089], [-117.96776, 33.97088], [-117.96791, 33.97121], [-117.96773, 33.97135], [-117.96722, 33.97149], [-117.96695, 33.97152], [-117.96694, 33.97153], [-117.96794, 33.97257]]], [[[-117.97666, 33.97483], [-117.97401, 33.97407], [-117.96878, 33.97258], [-117.97664, 33.97254], [-117.97666, 33.97483]]]]}	Open Access 1	46389	Arroyo San Miguel Open Space	29672	2332	Puente Hills Habitat Preservation Authority 849	Special District 4	Conservation District 31	http://www.habitatauthority.org	Special District 4	2088	Mountains Recreation and Conservation Authority 27	Special District 4	Open Space District 6		Los Angeles 6	36.363	Arroyo San Miguel OS	0	Local Recreation Area 3	4
16253	16253	16252	{"type": "MultiPolygon", "coordinates": [[[[-117.93078, 33.97203], [-117.93077, 33.97211], [-117.93065, 33.97208], [-117.91639, 33.96877], [-117.91761, 33.96581], [-117.9179, 33.96553], [-117.9181, 33.96538], [-117.91832, 33.96526], [-117.91894, 33.96501], [-117.91907, 33.96493], [-117.91917, 33.96484], [-117.92028, 33.9637], [-117.92039, 33.96359], [-117.92056, 33.9635], [-117.92084, 33.96343], [-117.92272, 33.96345], [-117.92291, 33.96344], [-117.92309, 33.96339], [-117.92319, 33.96335], [-117.92335, 33.96325], [-117.92361, 33.96305], [-117.92371, 33.96299], [-117.92384, 33.96295], [-117.92399, 33.96292], [-117.92446, 33.96288], [-117.92497, 33.96278], [-117.92591, 33.96251], [-117.9265, 33.96237], [-117.92651, 33.96242], [-117.9266, 33.96244], [-117.92665, 33.96247], [-117.92667, 33.96252], [-117.92667, 33.9626], [-117.92663, 33.96273], [-117.92663, 33.96283], [-117.92666, 33.96295], [-117.92672, 33.96305], [-117.9268, 33.96314], [-117.9269, 33.96321], [-117.92716, 33.96334], [-117.92726, 33.96343], [-117.92732, 33.96352], [-117.92733, 33.9636], [-117.92738, 33.96371], [-117.92775, 33.96428], [-117.92781, 33.96442], [-117.92794, 33.9651], [-117.92802, 33.96526], [-117.92833, 33.96569], [-117.92905, 33.96753], [-117.9292, 33.96775], [-117.92956, 33.96811], [-117.92967, 33.96827], [-117.92973, 33.96849], [-117.92991, 33.97], [-117.92997, 33.97023], [-117.93011, 33.97053], [-117.93066, 33.97139], [-117.93072, 33.97153], [-117.93076, 33.97171], [-117.93078, 33.97203]]], [[[-117.92709, 33.96025], [-117.92697, 33.96039], [-117.92683, 33.96052], [-117.92627, 33.96084], [-117.92598, 33.96106], [-117.92589, 33.96116], [-117.92577, 33.9613], [-117.92564, 33.96136], [-117.92514, 33.96145], [-117.92483, 33.96145], [-117.92446, 33.96139], [-117.92407, 33.96125], [-117.92394, 33.96124], [-117.92385, 33.96128], [-117.92363, 33.96144], [-117.92354, 33.96147], [-117.92343, 33.96147], [-117.92295, 33.96129], [-117.92284, 33.9613], [-117.92352, 33.96284], [-117.92356, 33.96288], [-117.92351, 33.96291], [-117.92319, 33.96316], [-117.923, 33.96325], [-117.92289, 33.96328], [-117.92272, 33.96329], [-117.92111, 33.96326], [-117.92082, 33.96327], [-117.92074, 33.96328], [-117.92027, 33.96305], [-117.9202, 33.96305], [-117.92015, 33.96308], [-117.92013, 33.96312], [-117.92012, 33.9632], [-117.91917, 33.96207], [-117.92073, 33.95833], [-117.92102, 33.95814], [-117.92147, 33.95782], [-117.92172, 33.95764], [-117.92198, 33.95741], [-117.92198, 33.95745], [-117.92202, 33.95743], [-117.9225, 33.95699], [-117.92295, 33.95651], [-117.92335, 33.95602], [-117.9249, 33.95402], [-117.92495, 33.95402], [-117.92508, 33.95406], [-117.92518, 33.95408], [-117.92543, 33.95407], [-117.92554, 33.95404], [-117.92571, 33.95396], [-117.92587, 33.95382], [-117.92596, 33.95378], [-117.92615, 33.95372], [-117.9266, 33.95373], [-117.92662, 33.95374], [-117.92659, 33.95381], [-117.92634, 33.95393], [-117.92604, 33.95377], [-117.92584, 33.95413], [-117.92577, 33.95414], [-117.92576, 33.95463], [-117.9256, 33.95488], [-117.92543, 33.95505], [-117.9253, 33.95537], [-117.92513, 33.95595], [-117.92444, 33.95676], [-117.92442, 33.95721], [-117.924, 33.95738], [-117.92365, 33.95739], [-117.92323, 33.95802], [-117.92368, 33.9582], [-117.92407, 33.95873], [-117.92449, 33.95883], [-117.92487, 33.95901], [-117.92398, 33.95981], [-117.92393, 33.9599], [-117.92394, 33.95991], [-117.92406, 33.95993], [-117.92473, 33.95991], [-117.92519, 33.95994], [-117.92543, 33.95998], [-117.92583, 33.96006], [-117.92635, 33.96022], [-117.92651, 33.96026], [-117.92669, 33.96027], [-117.92709, 33.96025]], [[-117.92345, 33.95938], [-117.92348, 33.9594], [-117.92359, 33.95934], [-117.92342, 33.95888], [-117.92282, 33.9586], [-117.92249, 33.95908], [-117.92219, 33.95827], [-117.92206, 33.958], [-117.92205, 33.958], [-117.92162, 33.95923], [-117.9219, 33.95972], [-117.92204, 33.95967], [-117.92258, 33.9593], [-117.92272, 33.95924], [-117.92283, 33.95921], [-117.92303, 33.9592], [-117.92314, 33.95922], [-117.92331, 33.95928], [-117.92345, 33.95938]]], [[[-117.92264, 33.95635], [-117.92221, 33.9568], [-117.92185, 33.95713], [-117.92146, 33.95746], [-117.92093, 33.95785], [-117.92154, 33.95636], [-117.92223, 33.95637], [-117.9225, 33.95639], [-117.92264, 33.95635]]], [[[-117.95545, 33.97052], [-117.95545, 33.97066], [-117.95508, 33.97098], [-117.95459, 33.97243], [-117.95445, 33.97245], [-117.95431, 33.97249], [-117.95383, 33.97271], [-117.95371, 33.97274], [-117.95358, 33.97274], [-117.95305, 33.9726], [-117.9528, 33.97257], [-117.95253, 33.97256], [-117.95227, 33.97258], [-117.95129, 33.97269], [-117.95125, 33.97281], [-117.95128, 33.97304], [-117.95108, 33.97295], [-117.95083, 33.9726], [-117.95077, 33.97255], [-117.95068, 33.9725], [-117.95016, 33.97243], [-117.94984, 33.97234], [-117.94971, 33.97234], [-117.94956, 33.97236], [-117.94944, 33.97239], [-117.94926, 33.97248], [-117.94889, 33.97285], [-117.94835, 33.97321], [-117.94832, 33.97325], [-117.9483, 33.97331], [-117.94835, 33.97345], [-117.94841, 33.97386], [-117.94838, 33.9739], [-117.94833, 33.9739], [-117.94806, 33.97378], [-117.94773, 33.97379], [-117.94763, 33.97378], [-117.94747, 33.97371], [-117.94732, 33.97362], [-117.94688, 33.9732], [-117.94678, 33.97314], [-117.94668, 33.97311], [-117.94632, 33.9731], [-117.9461, 33.97313], [-117.94528, 33.97307], [-117.94456, 33.97308], [-117.94442, 33.97313], [-117.94433, 33.97319], [-117.94426, 33.97327], [-117.94422, 33.97336], [-117.9441, 33.97385], [-117.94404, 33.97398], [-117.94397, 33.97406], [-117.94388, 33.97411], [-117.94332, 33.97426], [-117.94326, 33.97431], [-117.94321, 33.97441], [-117.94288, 33.97444], [-117.94276, 33.97451], [-117.9427, 33.97457], [-117.94268, 33.97486], [-117.93096, 33.97215], [-117.93098, 33.97198], [-117.93098, 33.97181], [-117.93095, 33.97163], [-117.93089, 33.97143], [-117.9308, 33.97124], [-117.93024, 33.97037], [-117.93014, 33.97013], [-117.92993, 33.96847], [-117.92987, 33.96827], [-117.92978, 33.9681], [-117.92938, 33.96768], [-117.92929, 33.96757], [-117.92922, 33.96744], [-117.92852, 33.96566], [-117.92816, 33.96511], [-117.92812, 33.96499], [-117.928, 33.96441], [-117.92794, 33.96424], [-117.92754, 33.96361], [-117.9275, 33.96347], [-117.92746, 33.96338], [-117.92733, 33.96325], [-117.927, 33.96308], [-117.92691, 33.963], [-117.92684, 33.96288], [-117.92682, 33.96273], [-117.92695, 33.96238], [-117.92698, 33.96234], [-117.92705, 33.96229], [-117.92755, 33.9622], [-117.92772, 33.96215], [-117.92782, 33.96215], [-117.92787, 33.96217], [-117.92793, 33.96225], [-117.92793, 33.96246], [-117.92794, 33.96256], [-117.92798, 33.9627], [-117.92805, 33.9628], [-117.92864, 33.96351], [-117.9289, 33.9637], [-117.92926, 33.96387], [-117.92942, 33.96402], [-117.92952, 33.9642], [-117.92962, 33.96455], [-117.92974, 33.96479], [-117.92994, 33.96504], [-117.93016, 33.96522], [-117.93047, 33.96539], [-117.93072, 33.96547], [-117.9316, 33.96563], [-117.93182, 33.96564], [-117.93222, 33.96559], [-117.93246, 33.96552], [-117.93276, 33.96539], [-117.93319, 33.96545], [-117.93332, 33.96572], [-117.9334, 33.96606], [-117.93338, 33.96648], [-117.93346, 33.96663], [-117.93359, 33.96666], [-117.93375, 33.96666], [-117.93384, 33.96664], [-117.93398, 33.96658], [-117.93409, 33.9665], [-117.93417, 33.96641], [-117.93422, 33.96629], [-117.93431, 33.96583], [-117.93434, 33.96585], [-117.93439, 33.96585], [-117.93432, 33.96629], [-117.93424, 33.96648], [-117.93407, 33.96664], [-117.93392, 33.96671], [-117.93377, 33.96674], [-117.93349, 33.96714], [-117.93366, 33.96745], [-117.9332, 33.96805], [-117.93344, 33.96811], [-117.93353, 33.96815], [-117.9336, 33.9682], [-117.93367, 33.96817], [-117.93382, 33.96816], [-117.93403, 33.96799], [-117.93426, 33.96777], [-117.93439, 33.96794], [-117.9346, 33.96807], [-117.93456, 33.96848], [-117.93525, 33.96874], [-117.93522, 33.96899], [-117.93533, 33.96911], [-117.93553, 33.96927], [-117.93593, 33.96902], [-117.9361, 33.96904], [-117.93634, 33.96931], [-117.93625, 33.96947], [-117.9362, 33.96954], [-117.93594, 33.96977], [-117.93583, 33.96991], [-117.93576, 33.97011], [-117.93575, 33.97025], [-117.93576, 33.97029], [-117.93601, 33.97027], [-117.93603, 33.97012], [-117.93607, 33.97002], [-117.93613, 33.96993], [-117.93633, 33.96974], [-117.93654, 33.96989], [-117.93684, 33.96991], [-117.93701, 33.96977], [-117.93701, 33.96946], [-117.93696, 33.96924], [-117.93704, 33.96917], [-117.937, 33.96914], [-117.93691, 33.96916], [-117.93671, 33.9689], [-117.93671, 33.96873], [-117.93667, 33.96857], [-117.93648, 33.96794], [-117.93646, 33.96778], [-117.9364, 33.96611], [-117.93636, 33.96596], [-117.93629, 33.9658], [-117.93616, 33.9656], [-117.93608, 33.96551], [-117.93622, 33.96541], [-117.93732, 33.96575], [-117.93736, 33.9659], [-117.93743, 33.96601], [-117.93753, 33.96611], [-117.93764, 33.96615], [-117.93779, 33.96615], [-117.93789, 33.96611], [-117.93796, 33.96606], [-117.93802, 33.96598], [-117.93805, 33.96579], [-117.93809, 33.96575], [-117.93824, 33.9658], [-117.93845, 33.96583], [-117.93859, 33.96589], [-117.93889, 33.96611], [-117.93915, 33.96632], [-117.93971, 33.96686], [-117.93977, 33.96694], [-117.93983, 33.96704], [-117.93986, 33.96715], [-117.93986, 33.96732], [-117.93981, 33.96751], [-117.93981, 33.9676], [-117.93985, 33.96771], [-117.93992, 33.96783], [-117.93992, 33.96792], [-117.93994, 33.96796], [-117.93998, 33.96798], [-117.94005, 33.96799], [-117.94009, 33.96797], [-117.94012, 33.96793], [-117.94011, 33.96787], [-117.94001, 33.96774], [-117.94014, 33.96781], [-117.94021, 33.96793], [-117.94047, 33.9682], [-117.94093, 33.96817], [-117.94094, 33.96825], [-117.94175, 33.96821], [-117.94175, 33.96812], [-117.942, 33.96811], [-117.94232, 33.96834], [-117.94246, 33.9684], [-117.94255, 33.96834], [-117.94264, 33.96831], [-117.94272, 33.96847], [-117.94264, 33.96851], [-117.94273, 33.96863], [-117.94279, 33.96879], [-117.94283, 33.96884], [-117.94293, 33.96893], [-117.94312, 33.96901], [-117.94316, 33.96905], [-117.9432, 33.96911], [-117.94326, 33.96916], [-117.94337, 33.9692], [-117.94344, 33.9692], [-117.94353, 33.96917], [-117.9436, 33.96911], [-117.94365, 33.96903], [-117.94364, 33.96893], [-117.94353, 33.96876], [-117.94348, 33.96858], [-117.94348, 33.96852], [-117.9435, 33.96847], [-117.94359, 33.96842], [-117.94385, 33.96836], [-117.94392, 33.96831], [-117.94395, 33.96826], [-117.94474, 33.96921], [-117.94484, 33.96921], [-117.94483, 33.96938], [-117.9449, 33.96957], [-117.94495, 33.96963], [-117.94502, 33.9697], [-117.94514, 33.96976], [-117.94518, 33.96967], [-117.94525, 33.96943], [-117.94523, 33.96926], [-117.94518, 33.96919], [-117.94494, 33.96922], [-117.94497, 33.96883], [-117.945, 33.96874], [-117.94523, 33.96838], [-117.9453, 33.96831], [-117.94537, 33.96826], [-117.94576, 33.96805], [-117.94589, 33.96794], [-117.94673, 33.96779], [-117.9471, 33.96782], [-117.94738, 33.96776], [-117.94777, 33.96755], [-117.94787, 33.9674], [-117.94877, 33.96714], [-117.94887, 33.96701], [-117.94905, 33.96697], [-117.94923, 33.96677], [-117.94938, 33.96676], [-117.94971, 33.9666], [-117.95017, 33.96672], [-117.94997, 33.96748], [-117.95078, 33.96818], [-117.95029, 33.96925], [-117.95102, 33.96949], [-117.95125, 33.9691], [-117.95194, 33.96936], [-117.95221, 33.96887], [-117.95198, 33.96811], [-117.95328, 33.9682], [-117.9533, 33.96885], [-117.95304, 33.96924], [-117.95297, 33.97024], [-117.95346, 33.97027], [-117.95375, 33.96966], [-117.9543, 33.96954], [-117.9542, 33.96782], [-117.95476, 33.96837], [-117.95468, 33.96855], [-117.95503, 33.97003], [-117.95504, 33.97004], [-117.95528, 33.96997], [-117.95531, 33.97011], [-117.95526, 33.97025], [-117.95531, 33.97028], [-117.95545, 33.97052]], [[-117.94332, 33.97353], [-117.94333, 33.97352], [-117.9432, 33.973], [-117.9425, 33.97312], [-117.94263, 33.97365], [-117.94332, 33.97353]], [[-117.95035, 33.97225], [-117.95067, 33.97237], [-117.95096, 33.97195], [-117.95039, 33.97182], [-117.95005, 33.97156], [-117.94961, 33.97164], [-117.94961, 33.97216], [-117.94994, 33.97209], [-117.95003, 33.97225], [-117.95014, 33.97239], [-117.95035, 33.97225]]], [[[-117.95197, 33.97404], [-117.94961, 33.97464], [-117.94961, 33.97646], [-117.94272, 33.97487], [-117.94275, 33.97456], [-117.94278, 33.97454], [-117.9429, 33.97446], [-117.94321, 33.97444], [-117.94326, 33.9744], [-117.9433, 33.97432], [-117.94334, 33.97429], [-117.94387, 33.97415], [-117.94396, 33.97411], [-117.94403, 33.97405], [-117.94414, 33.97386], [-117.94426, 33.97334], [-117.94431, 33.97325], [-117.94441, 33.97317], [-117.94451, 33.97313], [-117.9446, 33.97311], [-117.94481, 33.97312], [-117.94529, 33.9731], [-117.94611, 33.97317], [-117.94632, 33.97313], [-117.94665, 33.97314], [-117.94683, 33.97321], [-117.94727, 33.97362], [-117.94734, 33.97368], [-117.9475, 33.97377], [-117.94764, 33.97381], [-117.94776, 33.97383], [-117.94806, 33.97381], [-117.94832, 33.97392], [-117.94838, 33.97393], [-117.94844, 33.97389], [-117.94844, 33.97385], [-117.94839, 33.97344], [-117.94834, 33.97333], [-117.94835, 33.97327], [-117.94892, 33.97287], [-117.94929, 33.97251], [-117.94949, 33.97241], [-117.94966, 33.97237], [-117.94986, 33.97238], [-117.95015, 33.97247], [-117.95061, 33.97252], [-117.95072, 33.97255], [-117.9508, 33.97262], [-117.95105, 33.97296], [-117.95113, 33.97302], [-117.95128, 33.97308], [-117.95131, 33.9733], [-117.95143, 33.97327], [-117.95148, 33.97338], [-117.95178, 33.97366], [-117.95184, 33.9737], [-117.95193, 33.97372], [-117.95197, 33.97404]]], [[[-117.95209, 33.9735], [-117.95191, 33.97354], [-117.95192, 33.97368], [-117.95185, 33.97367], [-117.95152, 33.97337], [-117.95147, 33.97325], [-117.9519, 33.97311], [-117.95209, 33.9735]]]]}	Open Access 1	46390	Powder Canyon Open Space	29673	2332	Puente Hills Habitat Preservation Authority 849	Special District 4	Conservation District 31	http://www.habitatauthority.org	Special District 4	2088	Mountains Recreation and Conservation Authority 27	Special District 4	Open Space District 6		Los Angeles 6	690.972	Powder Canyon OS	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]);