calands: units_with_maps: 9 rows where ACCESS_TYP = 2, GAP_STS = 4 and MNG

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

9 rows where ACCESS_TYP = 2, GAP_STS = 4 and MNG_AGENCY = 4

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	DES_TP	GAP_STS
2754	2754	2753	{"type": "Polygon", "coordinates": [[[-117.24499, 32.80093], [-117.24419, 32.8011], [-117.24283, 32.80145], [-117.24267, 32.80102], [-117.24251, 32.80051], [-117.24472, 32.80004], [-117.24499, 32.80093]]]}	Restricted Access 2	18441	Pacific Beach Community Park	33345	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	5.466	Pacific Beach Community Park	Local Park 2	4
2799	2799	2798	{"type": "MultiPolygon", "coordinates": [[[[-117.05969, 32.76384], [-117.05963, 32.76392], [-117.05829, 32.76395], [-117.05834, 32.7639], [-117.05835, 32.76382], [-117.05963, 32.76378], [-117.05966, 32.76379], [-117.05969, 32.76384]]], [[[-117.06115, 32.76232], [-117.06114, 32.76248], [-117.06111, 32.76257], [-117.06106, 32.76264], [-117.06009, 32.76351], [-117.06004, 32.76235], [-117.06115, 32.76232]]]]}	Restricted Access 2	18582	Clay Neighborhood Park	31592	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	2.413	Clay Neighborhood Park	Local Park 2	4
5896	5896	5895	{"type": "Polygon", "coordinates": [[[-117.06009, 32.76351], [-117.05994, 32.76363], [-117.05895, 32.76366], [-117.05892, 32.76238], [-117.06004, 32.76235], [-117.06009, 32.76351]]]}	Restricted Access 2	46816	Clay Elementary School Park	31950	2310	San Diego Unified School District 820	Special District 4	School District 14	http://www.sandi.net/sandi	Special District 4	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	3.701	Clay Elementary School Park	Local Park 2	4
6254	6254	6253	{"type": "MultiPolygon", "coordinates": [[[[-116.72083, 32.70426], [-116.71907, 32.7045], [-116.71873, 32.70456], [-116.7182, 32.70471], [-116.71793, 32.70482], [-116.71767, 32.70496], [-116.71735, 32.70515], [-116.71708, 32.70537], [-116.71398, 32.70808], [-116.71371, 32.70826], [-116.71349, 32.70839], [-116.71319, 32.70853], [-116.71283, 32.70866], [-116.70883, 32.70798], [-116.70426, 32.70803], [-116.70439, 32.71165], [-116.70677, 32.71163], [-116.70672, 32.71196], [-116.70667, 32.7121], [-116.70658, 32.71228], [-116.70649, 32.71241], [-116.70538, 32.71375], [-116.70517, 32.71411], [-116.70506, 32.71444], [-116.70502, 32.71464], [-116.705, 32.71489], [-116.70499, 32.71695], [-116.70495, 32.71993], [-116.7049, 32.72027], [-116.70478, 32.72064], [-116.70461, 32.72097], [-116.70444, 32.72123], [-116.70424, 32.72147], [-116.70405, 32.72166], [-116.69956, 32.72557], [-116.69966, 32.7224], [-116.69545, 32.72241], [-116.6953, 32.72599], [-116.6909, 32.726], [-116.69148, 32.71532], [-116.69577, 32.71527], [-116.69593, 32.71173], [-116.7001, 32.71169], [-116.69997, 32.7081], [-116.70112, 32.70807], [-116.70099, 32.7045], [-116.69554, 32.70453], [-116.69514, 32.69711], [-116.6819, 32.69715], [-116.68214, 32.70068], [-116.67793, 32.70075], [-116.67876, 32.71169], [-116.6786, 32.71546], [-116.68281, 32.71546], [-116.68266, 32.71901], [-116.68694, 32.71903], [-116.68659, 32.7261], [-116.67808, 32.72613], [-116.67826, 32.7226], [-116.66961, 32.72265], [-116.66984, 32.71904], [-116.67418, 32.71895], [-116.67435, 32.71542], [-116.6661, 32.71554], [-116.66639, 32.71171], [-116.66252, 32.71174], [-116.66225, 32.70812], [-116.66611, 32.70808], [-116.66584, 32.7045], [-116.66983, 32.70446], [-116.66933, 32.69723], [-116.66139, 32.69733], [-116.66126, 32.69371], [-116.65721, 32.69375], [-116.65703, 32.69021], [-116.65041, 32.68985], [-116.64504, 32.6896], [-116.64512, 32.68579], [-116.64145, 32.68553], [-116.62402, 32.686], [-116.62403, 32.68245], [-116.61982, 32.68242], [-116.61983, 32.67894], [-116.62406, 32.67895], [-116.62828, 32.67883], [-116.62843, 32.68226], [-116.64162, 32.6817], [-116.65303, 32.68272], [-116.65312, 32.68635], [-116.65685, 32.68666], [-116.66102, 32.68661], [-116.66116, 32.69017], [-116.66941, 32.69001], [-116.66943, 32.68647], [-116.66522, 32.68654], [-116.66518, 32.67936], [-116.66938, 32.67923], [-116.66936, 32.66864], [-116.67387, 32.66853], [-116.67418, 32.66477], [-116.67836, 32.6647], [-116.67912, 32.65372], [-116.68316, 32.65371], [-116.68281, 32.65012], [-116.69142, 32.65005], [-116.69107, 32.6537], [-116.68713, 32.65371], [-116.68691, 32.66092], [-116.68275, 32.66096], [-116.68232, 32.66832], [-116.67809, 32.66843], [-116.67805, 32.67191], [-116.67386, 32.67198], [-116.67382, 32.68271], [-116.68213, 32.68268], [-116.68206, 32.68638], [-116.68642, 32.68631], [-116.68641, 32.68978], [-116.69093, 32.68974], [-116.69093, 32.69145], [-116.69097, 32.69352], [-116.7085, 32.69348], [-116.70862, 32.69707], [-116.71266, 32.69772], [-116.71271, 32.7015], [-116.7208, 32.70275], [-116.72083, 32.70426]]], [[[-116.70877, 32.71161], [-116.70809, 32.72584], [-116.69953, 32.72595], [-116.69953, 32.72583], [-116.70419, 32.72176], [-116.70447, 32.72148], [-116.7047, 32.72118], [-116.70487, 32.72089], [-116.70501, 32.72058], [-116.70509, 32.7203], [-116.70515, 32.71995], [-116.70519, 32.71695], [-116.7052, 32.71484], [-116.70523, 32.71452], [-116.70534, 32.71421], [-116.70544, 32.714], [-116.70558, 32.71379], [-116.70662, 32.71254], [-116.70673, 32.71239], [-116.70683, 32.71221], [-116.7069, 32.71203], [-116.70695, 32.71184], [-116.70697, 32.71163], [-116.70877, 32.71161]]], [[[-116.71691, 32.70935], [-116.71691, 32.70935], [-116.71317, 32.70872], [-116.71348, 32.70858], [-116.71373, 32.70845], [-116.71395, 32.70831], [-116.71419, 32.70814], [-116.71683, 32.70582], [-116.71691, 32.70935]]], [[[-116.72086, 32.70635], [-116.72086, 32.70635], [-116.71693, 32.70573], [-116.71727, 32.70544], [-116.71758, 32.70521], [-116.71797, 32.705], [-116.71838, 32.70483], [-116.7187, 32.70474], [-116.719, 32.70467], [-116.72083, 32.70443], [-116.72086, 32.70635]]]]}	Restricted Access 2	1327	Barrett Reservoir	15833	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2	https://www.sandiego.gov/water/recreation/reservoirs/barrett	San Diego 4	4177.221	Barrett Reservoir	Local Recreation Area 3	4
8338	8338	8337	{"type": "MultiPolygon", "coordinates": [[[[-116.79017, 33.10872], [-116.78888, 33.10869], [-116.78881, 33.1087], [-116.78893, 33.11811], [-116.78862, 33.11835], [-116.78851, 33.11848], [-116.78846, 33.11858], [-116.78836, 33.11893], [-116.78835, 33.11907], [-116.78838, 33.11928], [-116.7885, 33.11957], [-116.78852, 33.11974], [-116.78854, 33.11978], [-116.7886, 33.11983], [-116.78877, 33.11986], [-116.78895, 33.11994], [-116.78899, 33.12409], [-116.78494, 33.12412], [-116.78478, 33.13134], [-116.78472, 33.13504], [-116.78022, 33.13504], [-116.78021, 33.13137], [-116.77157, 33.13135], [-116.77151, 33.12419], [-116.7715, 33.12037], [-116.76717, 33.12036], [-116.76713, 33.11269], [-116.76278, 33.11275], [-116.7628, 33.1166], [-116.75415, 33.11659], [-116.75405, 33.10902], [-116.75416, 33.10548], [-116.74984, 33.10546], [-116.74993, 33.10187], [-116.75427, 33.10185], [-116.75438, 33.09824], [-116.75869, 33.09819], [-116.75874, 33.0947], [-116.76306, 33.09471], [-116.76301, 33.09817], [-116.77151, 33.09804], [-116.77152, 33.09805], [-116.77576, 33.0981], [-116.77578, 33.09841], [-116.77583, 33.09846], [-116.77619, 33.0991], [-116.77626, 33.09918], [-116.77636, 33.09925], [-116.77657, 33.09931], [-116.77686, 33.09935], [-116.77698, 33.09934], [-116.77709, 33.09936], [-116.77715, 33.0994], [-116.77722, 33.09947], [-116.77724, 33.09966], [-116.77732, 33.09971], [-116.77739, 33.09973], [-116.7775, 33.09973], [-116.77764, 33.0997], [-116.77782, 33.0997], [-116.77793, 33.09973], [-116.77802, 33.09977], [-116.77809, 33.09977], [-116.77821, 33.09973], [-116.77838, 33.09956], [-116.77846, 33.09973], [-116.77873, 33.09962], [-116.77928, 33.09982], [-116.77949, 33.09997], [-116.77957, 33.10009], [-116.77963, 33.10015], [-116.77976, 33.10022], [-116.77986, 33.10025], [-116.78003, 33.10025], [-116.7802, 33.10021], [-116.78034, 33.1001], [-116.78042, 33.09998], [-116.7805, 33.09996], [-116.7807, 33.10036], [-116.7807, 33.10042], [-116.78077, 33.10048], [-116.78083, 33.10049], [-116.78088, 33.10048], [-116.78097, 33.10042], [-116.78109, 33.10051], [-116.7812, 33.10058], [-116.7813, 33.10053], [-116.78145, 33.10042], [-116.7815, 33.10053], [-116.78157, 33.10064], [-116.78169, 33.10074], [-116.78178, 33.10079], [-116.78191, 33.10084], [-116.78206, 33.10087], [-116.7822, 33.10087], [-116.78233, 33.10085], [-116.78225, 33.10103], [-116.78224, 33.10112], [-116.78225, 33.10123], [-116.78228, 33.10134], [-116.78234, 33.10145], [-116.78248, 33.10158], [-116.78248, 33.10169], [-116.78254, 33.10178], [-116.78944, 33.10182], [-116.78946, 33.10197], [-116.78944, 33.10202], [-116.78918, 33.10221], [-116.78905, 33.10233], [-116.78896, 33.10245], [-116.78877, 33.10272], [-116.78873, 33.10285], [-116.78873, 33.10306], [-116.7887, 33.10325], [-116.78848, 33.10378], [-116.78839, 33.10385], [-116.78816, 33.1039], [-116.78798, 33.10399], [-116.78787, 33.10412], [-116.78784, 33.10423], [-116.78784, 33.10432], [-116.7879, 33.1045], [-116.7881, 33.10473], [-116.7882, 33.1049], [-116.7883, 33.10503], [-116.7885, 33.1052], [-116.78869, 33.10528], [-116.78882, 33.1053], [-116.789, 33.10528], [-116.79015, 33.10488], [-116.79022, 33.10488], [-116.79028, 33.10492], [-116.79029, 33.10498], [-116.79025, 33.10522], [-116.79023, 33.1053], [-116.79018, 33.10535], [-116.78986, 33.10565], [-116.78964, 33.10605], [-116.78961, 33.10622], [-116.78962, 33.10633], [-116.78966, 33.10642], [-116.78979, 33.10658], [-116.79034, 33.10699], [-116.79071, 33.10712], [-116.79136, 33.10731], [-116.79148, 33.10738], [-116.7915, 33.10742], [-116.79144, 33.10753], [-116.79112, 33.10775], [-116.79084, 33.10803], [-116.79054, 33.10839], [-116.79048, 33.10855], [-116.79044, 33.1086], [-116.79039, 33.10863], [-116.79017, 33.10872]], [[-116.77148, 33.11084], [-116.76714, 33.11085], [-116.76714, 33.11268], [-116.77147, 33.11263], [-116.77148, 33.11084]], [[-116.78493, 33.12411], [-116.78494, 33.1241], [-116.7849, 33.1203], [-116.7802, 33.12032], [-116.7802, 33.12414], [-116.78493, 33.12411]]], [[[-116.78883, 33.10517], [-116.78865, 33.10512], [-116.78845, 33.10497], [-116.78837, 33.10487], [-116.78823, 33.10464], [-116.78805, 33.10444], [-116.78802, 33.10437], [-116.788, 33.10429], [-116.78803, 33.10416], [-116.78812, 33.10406], [-116.78822, 33.10402], [-116.78844, 33.10399], [-116.78858, 33.1039], [-116.78864, 33.10382], [-116.7888, 33.10343], [-116.78883, 33.10517]]], [[[-116.78895, 33.11978], [-116.78874, 33.1197], [-116.78869, 33.11965], [-116.78856, 33.11932], [-116.78851, 33.11907], [-116.78853, 33.11895], [-116.78864, 33.11856], [-116.78873, 33.11845], [-116.78893, 33.11829], [-116.78895, 33.11978]]], [[[-116.79304, 33.13133], [-116.79306, 33.1327], [-116.79299, 33.13288], [-116.79295, 33.13294], [-116.7929, 33.13297], [-116.79269, 33.13304], [-116.79263, 33.13309], [-116.79258, 33.13324], [-116.79221, 33.13361], [-116.79207, 33.13378], [-116.79184, 33.13421], [-116.79176, 33.13429], [-116.79166, 33.13435], [-116.7916, 33.13444], [-116.79146, 33.13462], [-116.79143, 33.13471], [-116.79144, 33.13494], [-116.79143, 33.135], [-116.79129, 33.13526], [-116.79113, 33.13544], [-116.79109, 33.13552], [-116.79108, 33.13557], [-116.79112, 33.13572], [-116.79112, 33.13577], [-116.79108, 33.13583], [-116.79091, 33.13593], [-116.79086, 33.13601], [-116.79087, 33.13612], [-116.79096, 33.13627], [-116.79097, 33.13638], [-116.79093, 33.13649], [-116.79079, 33.13671], [-116.79074, 33.13682], [-116.7907, 33.13694], [-116.79065, 33.13727], [-116.79056, 33.13741], [-116.79038, 33.13751], [-116.79029, 33.13761], [-116.79025, 33.13773], [-116.79024, 33.13794], [-116.79019, 33.13808], [-116.79003, 33.13826], [-116.78984, 33.13836], [-116.78973, 33.13845], [-116.7895, 33.1387], [-116.78944, 33.13878], [-116.7891, 33.13878], [-116.78904, 33.13134], [-116.79304, 33.13133]]], [[[-116.79308, 33.13875], [-116.78959, 33.13878], [-116.78986, 33.13849], [-116.79011, 33.13834], [-116.79027, 33.13818], [-116.79032, 33.13809], [-116.79037, 33.13796], [-116.79038, 33.13787], [-116.79038, 33.13773], [-116.7904, 33.13767], [-116.79046, 33.1376], [-116.79063, 33.13751], [-116.79075, 33.13736], [-116.79079, 33.13724], [-116.79086, 33.13686], [-116.79091, 33.13675], [-116.79104, 33.13655], [-116.79109, 33.13639], [-116.79109, 33.13626], [-116.79106, 33.13618], [-116.791, 33.13608], [-116.791, 33.13603], [-116.79103, 33.13598], [-116.79117, 33.1359], [-116.79124, 33.13581], [-116.79125, 33.13573], [-116.79122, 33.13554], [-116.79139, 33.13532], [-116.79154, 33.13506], [-116.79157, 33.13496], [-116.79156, 33.13473], [-116.79158, 33.13465], [-116.79172, 33.13449], [-116.79176, 33.13442], [-116.79185, 33.13437], [-116.79194, 33.13429], [-116.79218, 33.13384], [-116.7924, 33.13359], [-116.79268, 33.13331], [-116.79271, 33.13325], [-116.79274, 33.13315], [-116.79295, 33.13307], [-116.79306, 33.133], [-116.79308, 33.13875]]]]}	Restricted Access 2	12842	Sutherland Reservoir	31464	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/water/recreation/reservoirs/sutherland.shtml	San Diego 4	2269.078	Sutherland Reservoir	Local Recreation Area 3	4
14205	14205	14204	{"type": "Polygon", "coordinates": [[[-117.0489, 32.67824], [-117.04772, 32.67864], [-117.04697, 32.67911], [-117.04638, 32.67955], [-117.04603, 32.67827], [-117.04596, 32.67806], [-117.04688, 32.67781], [-117.04697, 32.6778], [-117.04699, 32.67778], [-117.04668, 32.67615], [-117.04831, 32.67614], [-117.04833, 32.67636], [-117.04857, 32.67756], [-117.0487, 32.67789], [-117.0489, 32.67824]]]}	Restricted Access 2	44066	Penn Athletic Field	31636	2310	San Diego Unified School District 820	Special District 4	School District 14	http://www.sandi.net/sandi	Special District 4	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	13.867	Penn Athletic Field	Local Recreation Area 3	4
14490	14490	14489	{"type": "Polygon", "coordinates": [[[-117.15766, 32.9055], [-117.15651, 32.90626], [-117.1561, 32.90582], [-117.15673, 32.90517], [-117.15693, 32.90501], [-117.15764, 32.9055], [-117.15766, 32.9055]]]}	Restricted Access 2	47149	Salk Neighborhood Park	31627	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	2.342	Salk Neighborhood Park	Local Park 2	4
14599	14599	14598	{"type": "Polygon", "coordinates": [[[-116.82378, 32.88431], [-116.82378, 32.88489], [-116.82371, 32.88787], [-116.81079, 32.88793], [-116.81078, 32.88438], [-116.80658, 32.88434], [-116.80259, 32.88433], [-116.80253, 32.88611], [-116.79824, 32.88612], [-116.79819, 32.88806], [-116.79407, 32.88811], [-116.79412, 32.89172], [-116.78983, 32.89179], [-116.78987, 32.8947], [-116.78741, 32.89479], [-116.78531, 32.89483], [-116.78509, 32.90677], [-116.78592, 32.91744], [-116.7837, 32.9175], [-116.784, 32.92114], [-116.78386, 32.9282], [-116.78192, 32.92819], [-116.78182, 32.93195], [-116.77992, 32.93194], [-116.77986, 32.93542], [-116.77984, 32.93544], [-116.77857, 32.93544], [-116.77736, 32.93546], [-116.77722, 32.94281], [-116.77324, 32.94286], [-116.77329, 32.9502], [-116.77122, 32.95017], [-116.77091, 32.95166], [-116.77082, 32.95224], [-116.77055, 32.95358], [-116.76843, 32.95364], [-116.76779, 32.95696], [-116.76562, 32.95707], [-116.76438, 32.96334], [-116.75388, 32.96342], [-116.75393, 32.9671], [-116.7494, 32.96711], [-116.74941, 32.97075], [-116.7382, 32.97066], [-116.73814, 32.96705], [-116.74485, 32.96708], [-116.74482, 32.96342], [-116.74512, 32.96188], [-116.74551, 32.96004], [-116.75024, 32.96006], [-116.75098, 32.95663], [-116.7514, 32.95665], [-116.7553, 32.95664], [-116.75672, 32.94992], [-116.75715, 32.94991], [-116.75852, 32.94995], [-116.75877, 32.94994], [-116.75882, 32.94633], [-116.75674, 32.94644], [-116.75676, 32.94303], [-116.76506, 32.94257], [-116.76504, 32.93951], [-116.76914, 32.93931], [-116.7691, 32.93567], [-116.76692, 32.93577], [-116.76699, 32.92771], [-116.77323, 32.92776], [-116.77327, 32.92111], [-116.77321, 32.92069], [-116.77249, 32.91387], [-116.77683, 32.91396], [-116.77611, 32.90681], [-116.77624, 32.90238], [-116.77224, 32.90247], [-116.77244, 32.89524], [-116.76171, 32.89511], [-116.76163, 32.88822], [-116.76381, 32.88824], [-116.76382, 32.88977], [-116.76818, 32.88986], [-116.76821, 32.88985], [-116.7682, 32.88828], [-116.77238, 32.88832], [-116.78345, 32.88822], [-116.78362, 32.88455], [-116.78583, 32.88451], [-116.78613, 32.87714], [-116.78812, 32.87713], [-116.78823, 32.87351], [-116.78627, 32.87354], [-116.7859, 32.87031], [-116.79405, 32.87017], [-116.79361, 32.86645], [-116.79343, 32.85863], [-116.79834, 32.85869], [-116.79825, 32.85517], [-116.80246, 32.85521], [-116.80231, 32.8591], [-116.80234, 32.86122], [-116.80265, 32.87358], [-116.80265, 32.87364], [-116.79855, 32.87362], [-116.79845, 32.87727], [-116.8067, 32.87741], [-116.80665, 32.88079], [-116.81512, 32.88089], [-116.81507, 32.8841], [-116.81508, 32.88435], [-116.82378, 32.88431]], [[-116.75538, 32.9625], [-116.75464, 32.96306], [-116.75455, 32.96311], [-116.75449, 32.96311], [-116.75403, 32.96305], [-116.75379, 32.96304], [-116.75353, 32.96304], [-116.75318, 32.9631], [-116.75299, 32.96307], [-116.75289, 32.96301], [-116.75237, 32.9626], [-116.75224, 32.96255], [-116.75192, 32.96246], [-116.75171, 32.96246], [-116.7513, 32.96256], [-116.75108, 32.96256], [-116.75076, 32.9625], [-116.75062, 32.9625], [-116.75017, 32.96262], [-116.75007, 32.96262], [-116.74931, 32.96238], [-116.74926, 32.96247], [-116.74978, 32.96265], [-116.75004, 32.96272], [-116.75016, 32.96273], [-116.75028, 32.96271], [-116.75066, 32.96261], [-116.75076, 32.96261], [-116.75108, 32.96267], [-116.75124, 32.96268], [-116.75172, 32.96257], [-116.7519, 32.96257], [-116.75218, 32.96265], [-116.75235, 32.96272], [-116.75282, 32.9631], [-116.75298, 32.96318], [-116.75318, 32.96321], [-116.75376, 32.96314], [-116.75401, 32.96315], [-116.75449, 32.96322], [-116.7546, 32.96321], [-116.75473, 32.96315], [-116.75555, 32.96253], [-116.75647, 32.96203], [-116.7572, 32.96147], [-116.75728, 32.96144], [-116.75737, 32.96141], [-116.75796, 32.9614], [-116.75816, 32.96138], [-116.76004, 32.96066], [-116.76028, 32.96059], [-116.76049, 32.96055], [-116.76064, 32.96054], [-116.76077, 32.96055], [-116.76109, 32.96062], [-116.7611, 32.96061], [-116.76106, 32.9605], [-116.76077, 32.96043], [-116.76047, 32.96044], [-116.76017, 32.96051], [-116.75978, 32.96063], [-116.75825, 32.96123], [-116.75812, 32.96127], [-116.7579, 32.9613], [-116.75734, 32.9613], [-116.7572, 32.96134], [-116.75687, 32.96157], [-116.75638, 32.96196], [-116.75562, 32.96235], [-116.75538, 32.9625]]]}	Restricted Access 2	44814	El Capitan Reservoir	31465	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/water/recreation/reservoirs/elcapitan.shtml	San Diego 4	4164.597	El Capitan Reservoir	Local Recreation Area 3	4
15624	15624	15623	{"type": "Polygon", "coordinates": [[[-117.25401, 32.90718], [-117.25377, 32.90874], [-117.25262, 32.90918], [-117.24994, 32.90895], [-117.24794, 32.9092], [-117.24821, 32.91061], [-117.24923, 32.91094], [-117.25048, 32.91053], [-117.25122, 32.91156], [-117.24972, 32.91275], [-117.24806, 32.91462], [-117.24673, 32.91482], [-117.24619, 32.91416], [-117.24559, 32.91285], [-117.24534, 32.91288], [-117.24527, 32.91268], [-117.24423, 32.90787], [-117.24323, 32.90302], [-117.24456, 32.90286], [-117.24504, 32.90279], [-117.245, 32.90244], [-117.24482, 32.90135], [-117.24476, 32.90057], [-117.24393, 32.90056], [-117.24393, 32.89928], [-117.24361, 32.89931], [-117.24339, 32.89538], [-117.24311, 32.89479], [-117.243, 32.89303], [-117.2429, 32.89074], [-117.24399, 32.89061], [-117.24399, 32.89004], [-117.24568, 32.89008], [-117.2485, 32.8908], [-117.24981, 32.89148], [-117.24979, 32.89123], [-117.24893, 32.89001], [-117.24905, 32.88967], [-117.24895, 32.88953], [-117.24912, 32.88945], [-117.24949, 32.88918], [-117.24956, 32.88871], [-117.24948, 32.88821], [-117.24675, 32.88752], [-117.24675, 32.88716], [-117.24929, 32.88717], [-117.24931, 32.88608], [-117.25316, 32.88609], [-117.25325, 32.88745], [-117.25336, 32.8895], [-117.25341, 32.89232], [-117.25347, 32.89308], [-117.25341, 32.89309], [-117.25342, 32.89313], [-117.25326, 32.89416], [-117.25312, 32.89498], [-117.25313, 32.89595], [-117.2531, 32.89605], [-117.25307, 32.89665], [-117.25207, 32.8971], [-117.24992, 32.89617], [-117.24919, 32.89482], [-117.24868, 32.89411], [-117.2478, 32.89401], [-117.24696, 32.89485], [-117.24697, 32.89486], [-117.24824, 32.89499], [-117.2483, 32.89632], [-117.24733, 32.89745], [-117.24658, 32.89793], [-117.24674, 32.89866], [-117.248, 32.89905], [-117.24715, 32.90058], [-117.24714, 32.90063], [-117.24882, 32.90056], [-117.24967, 32.89857], [-117.25065, 32.89747], [-117.25183, 32.89836], [-117.25235, 32.90141], [-117.25196, 32.90284], [-117.25085, 32.90429], [-117.24791, 32.90569], [-117.24852, 32.90688], [-117.24931, 32.9069], [-117.2531, 32.90488], [-117.2532, 32.90552], [-117.25401, 32.90718]]]}	Restricted Access 2	12118	Torrey Pines Golf Course	33030	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	484.153	Torrey Pines GC	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]);