calands: units_with_maps: 32 rows where AGNCY_NAME = 104, AGNCY_WEB = "http://www.sandiegocounty.gov/parks/" and DES

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

32 rows where AGNCY_NAME = 104, AGNCY_WEB = "http://www.sandiegocounty.gov/parks/" and DES_TP = 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	YR_EST	DES_TP	GAP_STS
256	256	255	{"type": "Polygon", "coordinates": [[[-116.59188, 32.61847], [-116.59183, 32.62191], [-116.5879, 32.62185], [-116.57534, 32.62173], [-116.57533, 32.6218], [-116.57501, 32.62179], [-116.57504, 32.61913], [-116.5737, 32.61912], [-116.57357, 32.61185], [-116.5833, 32.61188], [-116.5833, 32.61473], [-116.58772, 32.61475], [-116.58772, 32.61842], [-116.59188, 32.61847]]]}	No Public Access 3	845	Mason Wildlife Refuge	21944	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3		San Diego 4	353.869	Mason Wildlife Refuge	0	Local Conservation Area 4	2
273	273	272	{"type": "Polygon", "coordinates": [[[-117.22664, 33.05068], [-117.22596, 33.05276], [-117.2242, 33.05232], [-117.22397, 33.05269], [-117.22342, 33.05309], [-117.22333, 33.0532], [-117.22327, 33.05335], [-117.22319, 33.05333], [-117.22285, 33.05437], [-117.2217, 33.05409], [-117.22056, 33.05378], [-117.21929, 33.05347], [-117.21921, 33.05335], [-117.2161, 33.05151], [-117.2152, 33.05153], [-117.21517, 33.05106], [-117.21518, 33.05083], [-117.21545, 33.0506], [-117.21594, 33.05075], [-117.21635, 33.05105], [-117.21679, 33.05145], [-117.21732, 33.05162], [-117.21818, 33.05212], [-117.21855, 33.05236], [-117.2191, 33.05245], [-117.21953, 33.05245], [-117.22, 33.05237], [-117.22063, 33.05218], [-117.22118, 33.05198], [-117.22176, 33.05197], [-117.22196, 33.05142], [-117.22206, 33.05144], [-117.22209, 33.05145], [-117.2219, 33.052], [-117.2221, 33.05204], [-117.22236, 33.0522], [-117.22247, 33.05237], [-117.22239, 33.05293], [-117.22239, 33.05312], [-117.22257, 33.05319], [-117.22287, 33.05307], [-117.22318, 33.05292], [-117.22333, 33.05278], [-117.22331, 33.05265], [-117.22347, 33.05211], [-117.22328, 33.0517], [-117.2231, 33.0515], [-117.22291, 33.05106], [-117.22291, 33.05094], [-117.22294, 33.05091], [-117.22296, 33.0508], [-117.22288, 33.05078], [-117.22291, 33.05061], [-117.22294, 33.0506], [-117.22293, 33.05044], [-117.22297, 33.0501], [-117.22301, 33.0501], [-117.22307, 33.05], [-117.22299, 33.04997], [-117.22302, 33.04982], [-117.22309, 33.04984], [-117.22316, 33.04971], [-117.22322, 33.04966], [-117.2235, 33.04936], [-117.22355, 33.04924], [-117.22352, 33.04914], [-117.22363, 33.049], [-117.22362, 33.04898], [-117.22385, 33.04877], [-117.2239, 33.04867], [-117.22389, 33.04866], [-117.22404, 33.04837], [-117.22402, 33.04835], [-117.22407, 33.04826], [-117.22407, 33.04819], [-117.22411, 33.04819], [-117.22416, 33.04806], [-117.2241, 33.04804], [-117.22416, 33.0479], [-117.2241, 33.04783], [-117.22609, 33.04832], [-117.22544, 33.05038], [-117.22664, 33.05068]]]}	Open Access 1	745	Val Sereno Preserve	26755	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3		San Diego 4	54.542	Val Sereno Preserve	0	Local Conservation Area 4	2
1137	1137	1136	{"type": "MultiPolygon", "coordinates": [[[[-117.02885, 33.34502], [-117.02695, 33.34498], [-117.02614, 33.34414], [-117.02426, 33.34497], [-117.02419, 33.34265], [-117.02878, 33.34259], [-117.02885, 33.34502]]], [[[-117.05093, 33.3583], [-117.04668, 33.35835], [-117.04442, 33.35814], [-117.04443, 33.35429], [-117.04345, 33.35427], [-117.0434, 33.35804], [-117.04323, 33.35802], [-117.04326, 33.35059], [-117.04225, 33.35057], [-117.04224, 33.35058], [-117.04223, 33.35424], [-117.04258, 33.35426], [-117.04258, 33.35796], [-117.04222, 33.35793], [-117.04221, 33.35603], [-117.04114, 33.35604], [-117.0411, 33.35792], [-117.04095, 33.35765], [-117.04058, 33.35758], [-117.03982, 33.35725], [-117.03928, 33.35674], [-117.03849, 33.35579], [-117.03828, 33.35582], [-117.03668, 33.35448], [-117.03357, 33.35447], [-117.03356, 33.35433], [-117.02942, 33.35428], [-117.0292, 33.3542], [-117.02912, 33.35051], [-117.02563, 33.35045], [-117.02562, 33.34983], [-117.0257, 33.34859], [-117.02569, 33.3484], [-117.02565, 33.34824], [-117.02555, 33.34803], [-117.02542, 33.34786], [-117.02435, 33.34678], [-117.02433, 33.34655], [-117.03346, 33.34656], [-117.03331, 33.34315], [-117.04228, 33.34309], [-117.05066, 33.3431], [-117.05068, 33.34591], [-117.0508, 33.35071], [-117.05093, 33.3583]]]]}	Open Access 1	7251	Wilderness Gardens Preserve	29262	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3	http://www.sdparks.org/content/sdparks/en/park-pages/WildernessGardens.html	San Diego 4	732.625	Wilderness Gardens Preserve	0	Local Conservation Area 4	2
1560	1560	1559	{"type": "MultiPolygon", "coordinates": [[[[-116.67869, 33.12778], [-116.67507, 33.1291], [-116.67083, 33.12914], [-116.66826, 33.12896], [-116.66617, 33.12917], [-116.66555, 33.12932], [-116.66459, 33.12981], [-116.66349, 33.13111], [-116.66203, 33.13263], [-116.66257, 33.13857], [-116.65983, 33.1441], [-116.65087, 33.13807], [-116.64428, 33.13531], [-116.64222, 33.13439], [-116.64213, 33.13433], [-116.64207, 33.13431], [-116.64201, 33.13432], [-116.63822, 33.13266], [-116.63537, 33.13001], [-116.62768, 33.12661], [-116.61609, 33.1216], [-116.61608, 33.1216], [-116.6161, 33.12308], [-116.60157, 33.12331], [-116.60159, 33.12309], [-116.60164, 33.12292], [-116.60177, 33.12264], [-116.60204, 33.12221], [-116.60219, 33.12188], [-116.6028, 33.11983], [-116.60294, 33.11942], [-116.61572, 33.10683], [-116.61854, 33.10692], [-116.63257, 33.10687], [-116.63264, 33.10942], [-116.63262, 33.11709], [-116.63264, 33.11777], [-116.63951, 33.11478], [-116.63967, 33.11501], [-116.64538, 33.11233], [-116.64539, 33.11232], [-116.64534, 33.11224], [-116.64807, 33.11104], [-116.65016, 33.11031], [-116.65016, 33.10895], [-116.65283, 33.10895], [-116.65665, 33.10729], [-116.6568, 33.10743], [-116.65693, 33.10752], [-116.65708, 33.1076], [-116.65724, 33.10766], [-116.65756, 33.10773], [-116.65784, 33.10773], [-116.65788, 33.1078], [-116.65812, 33.10777], [-116.65812, 33.10769], [-116.65843, 33.10758], [-116.6587, 33.10742], [-116.65882, 33.10731], [-116.65895, 33.10714], [-116.65905, 33.10696], [-116.65909, 33.1068], [-116.65913, 33.10621], [-116.66452, 33.10387], [-116.66715, 33.10274], [-116.66726, 33.1029], [-116.66744, 33.10304], [-116.66752, 33.10314], [-116.66774, 33.10343], [-116.6679, 33.10373], [-116.66802, 33.10409], [-116.66808, 33.1044], [-116.66808, 33.10477], [-116.66803, 33.10504], [-116.66778, 33.10603], [-116.66776, 33.10634], [-116.66779, 33.10659], [-116.66782, 33.10675], [-116.6679, 33.10696], [-116.66874, 33.10895], [-116.66871, 33.10899], [-116.66882, 33.10921], [-116.66748, 33.10958], [-116.66806, 33.11096], [-116.6704, 33.11028], [-116.67082, 33.11127], [-116.67421, 33.1103], [-116.67598, 33.11473], [-116.67648, 33.11617], [-116.67686, 33.1175], [-116.67738, 33.12013], [-116.67869, 33.12778]]], [[[-116.65874, 33.10638], [-116.65872, 33.10671], [-116.65869, 33.10681], [-116.65863, 33.10695], [-116.65855, 33.10706], [-116.65843, 33.10719], [-116.65831, 33.10728], [-116.65819, 33.10736], [-116.65812, 33.10733], [-116.65786, 33.10737], [-116.65781, 33.10743], [-116.65751, 33.10742], [-116.65733, 33.10737], [-116.65713, 33.1073], [-116.65696, 33.10715], [-116.65874, 33.10638]]], [[[-116.72151, 33.13325], [-116.71595, 33.13859], [-116.70914, 33.13903], [-116.70195, 33.13862], [-116.69711, 33.13219], [-116.69318, 33.12693], [-116.69264, 33.12424], [-116.68438, 33.12422], [-116.6784, 33.12414], [-116.67819, 33.12293], [-116.68439, 33.12295], [-116.70166, 33.12273], [-116.70167, 33.12271], [-116.7084, 33.12261], [-116.70589, 33.11347], [-116.70159, 33.10945], [-116.69487, 33.10266], [-116.69544, 33.10219], [-116.69685, 33.10083], [-116.69907, 33.09843], [-116.69941, 33.09801], [-116.69975, 33.09756], [-116.70055, 33.0964], [-116.70072, 33.09608], [-116.70092, 33.09561], [-116.7011, 33.09529], [-116.7021, 33.09356], [-116.70233, 33.09324], [-116.70258, 33.09301], [-116.70399, 33.09204], [-116.70418, 33.09185], [-116.70443, 33.09149], [-116.70462, 33.09129], [-116.70478, 33.09116], [-116.70551, 33.09069], [-116.70566, 33.09057], [-116.7058, 33.09043], [-116.70592, 33.09025], [-116.70598, 33.09009], [-116.70626, 33.08876], [-116.70719, 33.08867], [-116.70708, 33.10671], [-116.70849, 33.10944], [-116.71004, 33.11173], [-116.71661, 33.12406], [-116.71794, 33.12675], [-116.71988, 33.13024], [-116.72151, 33.13325]]]]}	Open Access 1	11729	Santa Ysabel Preserve	29255	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3	http://www.sdparks.org/content/sdparks/en/park-pages/SantaYsabel.html	San Diego 4	5407.378	Santa Ysabel Preserve	0	Local Conservation Area 4	2
4184	4184	4183	{"type": "Polygon", "coordinates": [[[-117.13525, 33.02933], [-117.1352, 33.03273], [-117.1346, 33.03273], [-117.13459, 33.03241], [-117.13336, 33.03194], [-117.13294, 33.0302], [-117.13281, 33.0301], [-117.13258, 33.03004], [-117.1325, 33.02998], [-117.13233, 33.02954], [-117.1323, 33.02934], [-117.13525, 33.02933]]]}	Open Access 1	44865	Greenfield Preserve	19479	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3		San Diego 4	17.374	Greenfield Preserve	0	Local Conservation Area 4	2
4918	4918	4917	{"type": "Polygon", "coordinates": [[[-116.70363, 32.61525], [-116.70362, 32.61622], [-116.69898, 32.61612], [-116.69901, 32.6143], [-116.70262, 32.61442], [-116.70298, 32.61427], [-116.70332, 32.61396], [-116.70321, 32.61425], [-116.70363, 32.61525]]]}	No Public Access 3	5150	MSCP Open Space Preserve Land	22571	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3		San Diego 4	21.27	MSCP OSP Land	0	Local Conservation Area 4	2
4919	4919	4918	{"type": "Polygon", "coordinates": [[[-116.95348, 32.97049], [-116.94486, 32.97075], [-116.94038, 32.97069], [-116.94043, 32.98879], [-116.93164, 32.98892], [-116.93165, 32.99244], [-116.92769, 32.9925], [-116.92746, 32.99195], [-116.92717, 32.99145], [-116.92712, 32.99134], [-116.9271, 32.99123], [-116.92703, 32.98965], [-116.92701, 32.98949], [-116.92694, 32.98925], [-116.92663, 32.98861], [-116.9274, 32.98859], [-116.92743, 32.98054], [-116.92835, 32.98052], [-116.9317, 32.98057], [-116.93267, 32.9801], [-116.93358, 32.97947], [-116.9336, 32.97826], [-116.93376, 32.97758], [-116.93361, 32.97697], [-116.93362, 32.97623], [-116.93287, 32.97482], [-116.93164, 32.9748], [-116.93162, 32.97644], [-116.93154, 32.97731], [-116.93048, 32.9773], [-116.93047, 32.97779], [-116.92975, 32.97775], [-116.92906, 32.9778], [-116.92869, 32.9778], [-116.92802, 32.97777], [-116.92744, 32.97782], [-116.9275, 32.97291], [-116.92755, 32.96326], [-116.92218, 32.96267], [-116.92286, 32.95497], [-116.91692, 32.95427], [-116.91686, 32.95103], [-116.91843, 32.95115], [-116.91844, 32.95114], [-116.91845, 32.9482], [-116.9174, 32.93946], [-116.92765, 32.94122], [-116.93182, 32.94121], [-116.93186, 32.95198], [-116.92763, 32.95203], [-116.92761, 32.95595], [-116.93185, 32.95601], [-116.93186, 32.95964], [-116.94042, 32.95977], [-116.94045, 32.9561], [-116.94879, 32.95602], [-116.94888, 32.95974], [-116.95342, 32.95961], [-116.95348, 32.97049]]]}	No Public Access 3	47591	Boulder Oaks Open Space Preserve	31318	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3	http://www.sdparks.org/content/sdparks/en/park-pages/BoulderOaks.html	San Diego 4	2020.361	Boulder Oaks OSP	0	Local Conservation Area 4	2
6086	6086	6085	{"type": "MultiPolygon", "coordinates": [[[[-117.00116, 33.01884], [-116.99647, 33.01886], [-116.99635, 33.01507], [-117.00112, 33.01494], [-117.00116, 33.01884]]], [[[-117.01695, 33.01451], [-117.01452, 33.01459], [-117.00983, 33.01471], [-117.00983, 33.01458], [-117.01035, 33.01452], [-117.01054, 33.01217], [-117.01092, 33.01197], [-117.01481, 33.01197], [-117.01603, 33.01335], [-117.01695, 33.01451]]]]}	Restricted Access 2	891	Blue Sky Ecological Reserve	29220	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3		San Diego 4	83.938	Blue Sky ER	1991	Local Conservation Area 4	2
6171	6171	6170	{"type": "Polygon", "coordinates": [[[-116.29585, 33.26389], [-116.28718, 33.26345], [-116.28666, 33.25667], [-116.28614, 33.24923], [-116.29523, 33.25029], [-116.29514, 33.2503], [-116.29515, 33.25033], [-116.29516, 33.25762], [-116.29517, 33.25777], [-116.29534, 33.25778], [-116.29585, 33.26389]]]}	Open Access 1	1189	Old Springs Road Open Space Preserve	29251	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3		San Diego 4	307.721	Old Springs Road OSP	0	Local Conservation Area 4	2
6179	6179	6178	{"type": "Polygon", "coordinates": [[[-117.11321, 33.4123], [-117.11289, 33.41266], [-117.1124, 33.41359], [-117.11121, 33.41278], [-117.11054, 33.41298], [-117.10972, 33.4128], [-117.10938, 33.41231], [-117.10899, 33.41231], [-117.10623, 33.4129], [-117.10374, 33.41236], [-117.1033, 33.4123], [-117.10365, 33.41528], [-117.0977, 33.41534], [-117.09748, 33.41496], [-117.09743, 33.41491], [-117.09735, 33.41487], [-117.09697, 33.41478], [-117.09692, 33.41473], [-117.09693, 33.41467], [-117.09689, 33.41455], [-117.09675, 33.41441], [-117.09648, 33.41432], [-117.09612, 33.414], [-117.09606, 33.41398], [-117.09598, 33.414], [-117.09593, 33.41405], [-117.09582, 33.41435], [-117.09578, 33.41451], [-117.09559, 33.41471], [-117.09566, 33.41531], [-117.09569, 33.41535], [-117.0958, 33.41567], [-117.0958, 33.41579], [-117.09578, 33.41591], [-117.09565, 33.41619], [-117.09546, 33.41631], [-117.09512, 33.4166], [-117.09511, 33.41667], [-117.09518, 33.41676], [-117.09519, 33.41684], [-117.09516, 33.41689], [-117.09497, 33.41701], [-117.09486, 33.41713], [-117.09482, 33.41726], [-117.09484, 33.41742], [-117.09483, 33.4175], [-117.09475, 33.41763], [-117.09472, 33.41775], [-117.09473, 33.41799], [-117.09479, 33.41844], [-117.09481, 33.41855], [-117.09476, 33.41895], [-117.09476, 33.41905], [-117.09483, 33.41908], [-117.09506, 33.41908], [-117.0951, 33.4198], [-117.09514, 33.4209], [-117.09526, 33.42291], [-117.09097, 33.42296], [-117.09102, 33.42379], [-117.08878, 33.42387], [-117.08865, 33.42348], [-117.08854, 33.42301], [-117.09096, 33.42296], [-117.09042, 33.41541], [-117.09032, 33.41197], [-117.0873, 33.41198], [-117.08728, 33.40855], [-117.09023, 33.40853], [-117.09014, 33.40506], [-117.08586, 33.40504], [-117.08585, 33.40349], [-117.08401, 33.40348], [-117.08388, 33.40276], [-117.08385, 33.4021], [-117.08377, 33.40175], [-117.08584, 33.40179], [-117.10209, 33.40231], [-117.10282, 33.40838], [-117.10377, 33.40848], [-117.10378, 33.40847], [-117.10306, 33.40238], [-117.11128, 33.4029], [-117.11148, 33.40933], [-117.11249, 33.40945], [-117.11291, 33.41202], [-117.11321, 33.4123]]]}	No Public Access 3	1219	Mt. Olympus Preserve	29249	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3		San Diego 4	801.066	Mt. Olympus Preserve	0	Local Conservation Area 4	2
6269	6269	6268	{"type": "MultiPolygon", "coordinates": [[[[-116.98966, 32.91956], [-116.98937, 32.91956], [-116.9895, 32.9339], [-116.98364, 32.93398], [-116.98356, 32.9343], [-116.98403, 32.93561], [-116.98442, 32.93603], [-116.98441, 32.93658], [-116.98424, 32.93807], [-116.98354, 32.93871], [-116.98159, 32.94012], [-116.98109, 32.94034], [-116.98048, 32.93979], [-116.98033, 32.93986], [-116.98058, 32.9412], [-116.97817, 32.94117], [-116.97813, 32.943], [-116.97815, 32.94301], [-116.97847, 32.94277], [-116.97891, 32.9428], [-116.97894, 32.94363], [-116.97912, 32.94418], [-116.97809, 32.9459], [-116.97938, 32.9459], [-116.98105, 32.94585], [-116.98105, 32.94859], [-116.97935, 32.94853], [-116.97058, 32.94833], [-116.97082, 32.94447], [-116.97099, 32.94104], [-116.96183, 32.94088], [-116.96174, 32.93343], [-116.95747, 32.93346], [-116.95777, 32.92622], [-116.96202, 32.92624], [-116.96229, 32.91927], [-116.96218, 32.91552], [-116.95771, 32.9155], [-116.95773, 32.9085], [-116.96197, 32.90851], [-116.96182, 32.9035], [-116.97162, 32.90168], [-116.97155, 32.91577], [-116.9809, 32.91574], [-116.98072, 32.90852], [-116.98503, 32.90855], [-116.98502, 32.90763], [-116.98936, 32.90765], [-116.98938, 32.90859], [-116.98504, 32.90855], [-116.98507, 32.91031], [-116.98943, 32.91034], [-116.98966, 32.91956]]], [[[-116.96655, 32.94369], [-116.9663, 32.94401], [-116.96603, 32.94429], [-116.96578, 32.9445], [-116.96516, 32.94497], [-116.96477, 32.94521], [-116.96302, 32.94614], [-116.96296, 32.94615], [-116.96292, 32.94612], [-116.96269, 32.94584], [-116.96241, 32.94553], [-116.96213, 32.94526], [-116.96188, 32.94506], [-116.96187, 32.94452], [-116.96109, 32.94453], [-116.96052, 32.94424], [-116.959, 32.94362], [-116.95841, 32.94333], [-116.95808, 32.94313], [-116.95775, 32.94291], [-116.95774, 32.94223], [-116.961, 32.94226], [-116.96099, 32.94127], [-116.96649, 32.9413], [-116.96655, 32.94369]]], [[[-116.9654, 32.94517], [-116.96539, 32.94575], [-116.96341, 32.94681], [-116.96315, 32.94645], [-116.96315, 32.94639], [-116.96318, 32.94636], [-116.965, 32.94542], [-116.9654, 32.94517]]], [[[-116.98432, 32.90496], [-116.98062, 32.90494], [-116.98042, 32.90307], [-116.9843, 32.90304], [-116.98432, 32.90496]]], [[[-116.98934, 32.90675], [-116.98501, 32.90674], [-116.98498, 32.90496], [-116.98929, 32.90498], [-116.98934, 32.90675]]]]}	Open Access 1	1358	Goodan Ranch Sycamore Canyon Preserve	29238	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3	http://www.sdparks.org/content/sdparks/en/park-pages/GoodanSycamore.html	San Diego 4	2571.686	Goodan Ranch Sycamore Canyon Preserve	0	Local Conservation Area 4	2
6785	6785	6784	{"type": "Polygon", "coordinates": [[[-117.25752, 33.40873], [-117.25323, 33.40878], [-117.25324, 33.41265], [-117.24915, 33.41271], [-117.24922, 33.40887], [-117.24932, 33.40872], [-117.24939, 33.40856], [-117.24945, 33.40837], [-117.24947, 33.40824], [-117.24939, 33.40734], [-117.24924, 33.40619], [-117.24924, 33.4061], [-117.24935, 33.40529], [-117.24926, 33.40393], [-117.24924, 33.40289], [-117.24928, 33.40267], [-117.24932, 33.40252], [-117.24946, 33.40219], [-117.24965, 33.40189], [-117.25008, 33.4014], [-117.25014, 33.40129], [-117.2503, 33.40084], [-117.2503, 33.40072], [-117.25027, 33.40062], [-117.25028, 33.40061], [-117.25015, 33.40032], [-117.25013, 33.4002], [-117.25023, 33.3996], [-117.25023, 33.39948], [-117.25019, 33.39938], [-117.25013, 33.39929], [-117.24996, 33.39916], [-117.25256, 33.39932], [-117.25255, 33.39925], [-117.25239, 33.39903], [-117.25238, 33.39893], [-117.25242, 33.39881], [-117.25252, 33.3987], [-117.25256, 33.39862], [-117.25258, 33.39847], [-117.25682, 33.39851], [-117.25613, 33.40205], [-117.25582, 33.40206], [-117.25572, 33.40275], [-117.25524, 33.4065], [-117.2575, 33.40647], [-117.25752, 33.40873]]]}	Open Access 1	5282	Santa Margarita Preserve	25099	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3	http://www.sdparks.org/content/sdparks/en/park-pages/SantaMargarita.html	San Diego 4	211.224	Santa Margarita Preserve	0	Local Conservation Area 4	2
6802	6802	6801	{"type": "MultiPolygon", "coordinates": [[[[-116.91462, 33.22682], [-116.91453, 33.23359], [-116.91037, 33.23358], [-116.91038, 33.23708], [-116.90136, 33.23707], [-116.90139, 33.227], [-116.90169, 33.22659], [-116.91067, 33.22678], [-116.91462, 33.22682]]], [[[-116.92783, 33.19759], [-116.92778, 33.20078], [-116.92782, 33.2009], [-116.92779, 33.20311], [-116.9278, 33.20838], [-116.91504, 33.20852], [-116.91746, 33.20521], [-116.92314, 33.19761], [-116.92783, 33.19759]]], [[[-116.96695, 33.2241], [-116.96284, 33.22408], [-116.96285, 33.22763], [-116.96266, 33.23129], [-116.95379, 33.23114], [-116.95353, 33.23836], [-116.95793, 33.23848], [-116.95778, 33.2421], [-116.94485, 33.24154], [-116.92792, 33.2417], [-116.91891, 33.24172], [-116.91909, 33.2343], [-116.91916, 33.23058], [-116.92233, 33.23056], [-116.92215, 33.23127], [-116.92182, 33.2315], [-116.92221, 33.23241], [-116.92339, 33.23242], [-116.92344, 33.23055], [-116.92777, 33.23051], [-116.92787, 33.22694], [-116.93242, 33.22711], [-116.93206, 33.22005], [-116.93192, 33.2162], [-116.93202, 33.2162], [-116.93202, 33.21615], [-116.93604, 33.21632], [-116.93838, 33.21647], [-116.94032, 33.21654], [-116.94079, 33.22037], [-116.94526, 33.22053], [-116.9496, 33.22055], [-116.94957, 33.22402], [-116.95836, 33.22405], [-116.95837, 33.22057], [-116.96282, 33.22058], [-116.96695, 33.22052], [-116.96695, 33.2241]], [[-116.9453, 33.22652], [-116.94303, 33.22648], [-116.943, 33.22742], [-116.9453, 33.22745], [-116.9453, 33.22652]]]]}	Open Access 1	5317	Hellhole Canyon Preserve	29239	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3	http://www.sdparks.org/content/sdparks/en/park-pages/HellholeCanyon.html	San Diego 4	2451.423	Hellhole Canyon Preserve	0	Local Conservation Area 4	2
6825	6825	6824	{"type": "Polygon", "coordinates": [[[-117.17513, 33.01315], [-117.17085, 33.01592], [-117.16887, 33.01455], [-117.16549, 33.01457], [-117.16225, 33.01456], [-117.16124, 33.01454], [-117.16134, 33.01093], [-117.15898, 33.01092], [-117.15897, 33.0073], [-117.16989, 33.00728], [-117.1699, 33.01127], [-117.17283, 33.01129], [-117.1732, 33.01127], [-117.17395, 33.01128], [-117.174, 33.01125], [-117.17441, 33.01238], [-117.17513, 33.01315]]]}	Open Access 1	5419	Lusardi Creek Preserve	29247	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3	http://www.sdparks.org/content/sdparks/en/park-pages/LusardiCreek.html	San Diego 4	225.646	Lusardi Creek Preserve	0	Local Conservation Area 4	2
6830	6830	6829	{"type": "Polygon", "coordinates": [[[-117.18338, 33.25274], [-117.18272, 33.25297], [-117.18189, 33.25323], [-117.18125, 33.25339], [-117.18097, 33.25343], [-117.18104, 33.24925], [-117.18302, 33.24925], [-117.18305, 33.2493], [-117.18316, 33.24949], [-117.18322, 33.24967], [-117.1836, 33.25208], [-117.18366, 33.2523], [-117.18378, 33.25255], [-117.18377, 33.25259], [-117.18374, 33.25261], [-117.18338, 33.25274]]]}	Open Access 1	5437	Gopher Canyon Reserve	19407	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3		San Diego 4	23.859	Gopher Canyon Reserve	0	Local Conservation Area 4	2
6918	6918	6917	{"type": "MultiPolygon", "coordinates": [[[[-117.23536, 33.03391], [-117.23513, 33.03422], [-117.2342, 33.03397], [-117.23474, 33.03348], [-117.23477, 33.03348], [-117.23517, 33.03379], [-117.23536, 33.03391]]], [[[-117.23609, 33.03514], [-117.23555, 33.03678], [-117.23459, 33.03653], [-117.23477, 33.03601], [-117.23609, 33.03514]]], [[[-117.23732, 33.03115], [-117.23555, 33.03272], [-117.23531, 33.03354], [-117.23553, 33.03368], [-117.23569, 33.03369], [-117.23557, 33.03381], [-117.23525, 33.0336], [-117.23497, 33.03337], [-117.23493, 33.03326], [-117.23496, 33.03324], [-117.2351, 33.03295], [-117.23513, 33.03282], [-117.23514, 33.0326], [-117.23511, 33.03241], [-117.23505, 33.03223], [-117.23496, 33.03209], [-117.23577, 33.03136], [-117.23603, 33.03158], [-117.23624, 33.0314], [-117.23625, 33.03135], [-117.23668, 33.03095], [-117.23612, 33.03046], [-117.23629, 33.0303], [-117.23732, 33.03115]]], [[[-117.24184, 33.03031], [-117.24168, 33.03057], [-117.24148, 33.03079], [-117.24127, 33.03094], [-117.24071, 33.03129], [-117.24106, 33.03011], [-117.24184, 33.03031]]], [[[-117.27719, 33.00739], [-117.27719, 33.00739], [-117.27717, 33.00818], [-117.27696, 33.00739], [-117.27719, 33.00739]]], [[[-117.27882, 33.01168], [-117.27819, 33.01179], [-117.27803, 33.01121], [-117.27846, 33.01114], [-117.2784, 33.01123], [-117.2784, 33.01129], [-117.27872, 33.01159], [-117.2788, 33.01158], [-117.27882, 33.01168]]]]}	Open Access 1	724	San Elijo Lagoon Ecological Reserve	24878	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3	http://www.sdparks.org/content/sdparks/en/park-pages/SanElijo.html	San Diego 4	12.338	San Elijo Lagoon ER	1983	Local Conservation Area 4	2
7109	7109	7108	{"type": "MultiPolygon", "coordinates": [[[[-116.88462, 32.91635], [-116.88184, 32.91632], [-116.88177, 32.91164], [-116.88174, 32.91156], [-116.88176, 32.9108], [-116.88173, 32.90896], [-116.88411, 32.90898], [-116.88487, 32.91321], [-116.88487, 32.91346], [-116.88462, 32.91635]]], [[[-116.90743, 32.91287], [-116.90741, 32.91652], [-116.90314, 32.91651], [-116.90316, 32.92005], [-116.89739, 32.92002], [-116.89018, 32.92002], [-116.89019, 32.91943], [-116.88957, 32.91944], [-116.88966, 32.91642], [-116.88483, 32.91635], [-116.88507, 32.91354], [-116.88507, 32.91322], [-116.88501, 32.91285], [-116.88481, 32.91175], [-116.89029, 32.91174], [-116.89031, 32.90899], [-116.89462, 32.90904], [-116.8947, 32.91274], [-116.90743, 32.91287]]]]}	Open Access 1	6185	Oakoasis Preserve	29250	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3	http://www.sdparks.org/content/sdparks/en/park-pages/Oakoasis.html	San Diego 4	443.34	Oakoasis Preserve	0	Local Conservation Area 4	2
7361	7361	7360	{"type": "Polygon", "coordinates": [[[-116.80495, 32.6658], [-116.7972, 32.66593], [-116.79691, 32.66573], [-116.79678, 32.66565], [-116.79554, 32.66464], [-116.7957, 32.65742], [-116.78827, 32.65749], [-116.78821, 32.65701], [-116.77957, 32.65689], [-116.77935, 32.64654], [-116.78382, 32.64644], [-116.78381, 32.64588], [-116.78409, 32.64598], [-116.78439, 32.64605], [-116.78463, 32.64607], [-116.78512, 32.64609], [-116.7853, 32.64611], [-116.78551, 32.64618], [-116.78574, 32.64629], [-116.78584, 32.64636], [-116.78591, 32.64644], [-116.78597, 32.64653], [-116.786, 32.64664], [-116.78603, 32.64794], [-116.78609, 32.64813], [-116.78635, 32.64851], [-116.78641, 32.64863], [-116.78641, 32.64876], [-116.78636, 32.64911], [-116.78634, 32.64918], [-116.78636, 32.64927], [-116.78685, 32.65008], [-116.78694, 32.65019], [-116.78706, 32.65029], [-116.78722, 32.65038], [-116.7874, 32.65043], [-116.78819, 32.65052], [-116.78833, 32.65059], [-116.78845, 32.65071], [-116.7885, 32.65082], [-116.78869, 32.65163], [-116.7887, 32.65178], [-116.78869, 32.65209], [-116.78872, 32.65231], [-116.78884, 32.65264], [-116.78898, 32.65285], [-116.78902, 32.65304], [-116.78907, 32.65314], [-116.78921, 32.65323], [-116.78954, 32.65329], [-116.78969, 32.65328], [-116.78976, 32.65325], [-116.78984, 32.6532], [-116.79019, 32.65284], [-116.79056, 32.65268], [-116.7907, 32.65263], [-116.79084, 32.65261], [-116.791, 32.65262], [-116.79115, 32.65265], [-116.79157, 32.6528], [-116.79173, 32.6529], [-116.79181, 32.65303], [-116.79189, 32.65332], [-116.79204, 32.65374], [-116.79201, 32.65377], [-116.79204, 32.65382], [-116.79217, 32.65396], [-116.79232, 32.65409], [-116.79251, 32.6542], [-116.7927, 32.65427], [-116.79413, 32.65454], [-116.79453, 32.65443], [-116.79454, 32.65439], [-116.79458, 32.65438], [-116.79479, 32.65439], [-116.79609, 32.65457], [-116.79742, 32.65446], [-116.79772, 32.65438], [-116.798, 32.65424], [-116.79813, 32.65414], [-116.7988, 32.65358], [-116.79906, 32.65342], [-116.79963, 32.65313], [-116.79982, 32.65306], [-116.80012, 32.65298], [-116.80041, 32.65296], [-116.80065, 32.65297], [-116.8009, 32.65301], [-116.80291, 32.6536], [-116.80322, 32.65367], [-116.80397, 32.6538], [-116.80484, 32.65407], [-116.80495, 32.6658]]]}	No Public Access 3	47588	Lawrence and Barbara Daley Preserve	31315	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3		San Diego 4	580.873	Lawrence and Barbara Daley Preserve	0	Local Conservation Area 4	2
7407	7407	7406	{"type": "MultiPolygon", "coordinates": [[[[-116.92757, 33.0656], [-116.92344, 33.06562], [-116.92331, 33.06922], [-116.92324, 33.0692], [-116.91503, 33.0691], [-116.91516, 33.06562], [-116.91502, 33.06561], [-116.91536, 33.05416], [-116.91053, 33.05147], [-116.91053, 33.04782], [-116.90649, 33.04778], [-116.90482, 33.04779], [-116.90481, 33.04762], [-116.90634, 33.04761], [-116.9063, 33.04319], [-116.91054, 33.0432], [-116.91057, 33.04412], [-116.92332, 33.04382], [-116.9233, 33.04181], [-116.92753, 33.04244], [-116.92754, 33.04372], [-116.92749, 33.04509], [-116.92746, 33.04986], [-116.92755, 33.05108], [-116.92763, 33.05833], [-116.92756, 33.06196], [-116.92757, 33.0656]]], [[[-116.93601, 33.03652], [-116.93073, 33.03647], [-116.92754, 33.03643], [-116.92752, 33.03644], [-116.92731, 33.03645], [-116.92737, 33.03962], [-116.91043, 33.03711], [-116.9102, 33.0296], [-116.91019, 33.02797], [-116.91012, 33.02594], [-116.91323, 33.02589], [-116.91342, 33.02951], [-116.91449, 33.02948], [-116.9146, 33.03312], [-116.91887, 33.033], [-116.91878, 33.02936], [-116.92752, 33.02912], [-116.92753, 33.02855], [-116.93283, 33.0301], [-116.9334, 33.03109], [-116.93182, 33.03106], [-116.93182, 33.03196], [-116.93601, 33.03206], [-116.93601, 33.03652]]], [[[-116.9673, 33.07317], [-116.96318, 33.07321], [-116.96246, 33.0732], [-116.95431, 33.07292], [-116.94985, 33.0728], [-116.95008, 33.0765], [-116.94558, 33.07649], [-116.94537, 33.07261], [-116.94514, 33.06916], [-116.93635, 33.06921], [-116.93206, 33.06931], [-116.93207, 33.06563], [-116.9449, 33.0657], [-116.94481, 33.05845], [-116.93614, 33.05838], [-116.93609, 33.0511], [-116.94461, 33.05108], [-116.9569, 33.05119], [-116.95686, 33.04913], [-116.94648, 33.04762], [-116.94656, 33.04718], [-116.94955, 33.04471], [-116.94864, 33.04308], [-116.94486, 33.04306], [-116.94209, 33.04308], [-116.94205, 33.04096], [-116.94204, 33.03821], [-116.93764, 33.03588], [-116.9362, 33.03588], [-116.93619, 33.03301], [-116.94553, 33.03316], [-116.95749, 33.03329], [-116.95744, 33.0405], [-116.95735, 33.04765], [-116.96188, 33.04771], [-116.96191, 33.05133], [-116.96208, 33.05497], [-116.96668, 33.055], [-116.96674, 33.05881], [-116.96679, 33.06251], [-116.96243, 33.06256], [-116.96237, 33.06154], [-116.95791, 33.06161], [-116.95798, 33.06557], [-116.96257, 33.06566], [-116.96715, 33.0657], [-116.9673, 33.07317]]]]}	Open Access 1	47592	Ramona Grasslands Preserve	31319	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3		San Diego 4	3490.938	Ramona Grasslands Preserve	0	Local Conservation Area 4	2
7603	7603	7602	{"type": "MultiPolygon", "coordinates": [[[[-117.14805, 33.08584], [-117.14789, 33.0859], [-117.14775, 33.08597], [-117.14704, 33.08645], [-117.14671, 33.08662], [-117.14508, 33.08435], [-117.13959, 33.08443], [-117.13958, 33.08442], [-117.13958, 33.08754], [-117.13651, 33.08756], [-117.12968, 33.08756], [-117.12962, 33.09117], [-117.12315, 33.09115], [-117.12313, 33.08756], [-117.11888, 33.08755], [-117.11889, 33.08746], [-117.11885, 33.08602], [-117.1189, 33.08492], [-117.11888, 33.08399], [-117.11911, 33.08376], [-117.11915, 33.08376], [-117.11941, 33.08344], [-117.11939, 33.08342], [-117.1194, 33.08339], [-117.11947, 33.0833], [-117.11965, 33.083], [-117.11982, 33.08265], [-117.11992, 33.08237], [-117.12041, 33.08055], [-117.12047, 33.08025], [-117.12056, 33.07972], [-117.12075, 33.07971], [-117.12076, 33.07899], [-117.12108, 33.07898], [-117.12106, 33.07836], [-117.12084, 33.07835], [-117.1211, 33.07661], [-117.12112, 33.07652], [-117.12116, 33.07652], [-117.1212, 33.07624], [-117.12126, 33.07623], [-117.12136, 33.07562], [-117.12131, 33.0756], [-117.12133, 33.07547], [-117.1213, 33.07546], [-117.12141, 33.07449], [-117.12151, 33.07448], [-117.12178, 33.07265], [-117.1219, 33.07198], [-117.12179, 33.07194], [-117.12245, 33.06783], [-117.12255, 33.06782], [-117.12257, 33.06767], [-117.12265, 33.06739], [-117.12276, 33.06717], [-117.1229, 33.06695], [-117.12283, 33.06691], [-117.1229, 33.06681], [-117.12305, 33.06665], [-117.12318, 33.06653], [-117.12349, 33.06632], [-117.12368, 33.06617], [-117.12387, 33.06596], [-117.12401, 33.06571], [-117.12412, 33.0657], [-117.12411, 33.06544], [-117.12415, 33.06519], [-117.12415, 33.06479], [-117.12423, 33.06438], [-117.12603, 33.06455], [-117.12788, 33.06455], [-117.12814, 33.0646], [-117.12826, 33.0646], [-117.12862, 33.06454], [-117.12897, 33.06451], [-117.12907, 33.06454], [-117.12925, 33.06468], [-117.12939, 33.06474], [-117.12952, 33.06476], [-117.1298, 33.06475], [-117.13004, 33.06483], [-117.13017, 33.06485], [-117.1304, 33.06485], [-117.13053, 33.06486], [-117.13064, 33.0649], [-117.13091, 33.06506], [-117.12933, 33.06755], [-117.1271, 33.06756], [-117.12711, 33.07295], [-117.12718, 33.0802], [-117.13631, 33.08017], [-117.13631, 33.08116], [-117.13629, 33.08152], [-117.13633, 33.08392], [-117.13957, 33.08391], [-117.13955, 33.08019], [-117.14401, 33.08032], [-117.14803, 33.08027], [-117.14803, 33.08388], [-117.14805, 33.08584]]], [[[-117.13193, 33.06024], [-117.1319, 33.06349], [-117.13096, 33.06498], [-117.13069, 33.06483], [-117.13055, 33.06478], [-117.13042, 33.06477], [-117.1302, 33.06477], [-117.13006, 33.06475], [-117.1298, 33.06467], [-117.12954, 33.06467], [-117.12941, 33.06466], [-117.12927, 33.06459], [-117.12914, 33.06448], [-117.129, 33.06443], [-117.12886, 33.06443], [-117.12866, 33.06445], [-117.12833, 33.06451], [-117.12823, 33.06452], [-117.12769, 33.06443], [-117.12734, 33.0643], [-117.12689, 33.06409], [-117.12647, 33.06398], [-117.12639, 33.06391], [-117.12638, 33.06383], [-117.12642, 33.06376], [-117.12671, 33.06361], [-117.12679, 33.06353], [-117.12685, 33.06345], [-117.12688, 33.06336], [-117.12692, 33.0627], [-117.1271, 33.06259], [-117.12723, 33.06248], [-117.12759, 33.06209], [-117.12771, 33.06199], [-117.12786, 33.06191], [-117.12802, 33.06185], [-117.12849, 33.06178], [-117.12867, 33.06172], [-117.12883, 33.06164], [-117.12904, 33.06148], [-117.12933, 33.06112], [-117.12945, 33.06102], [-117.12965, 33.06092], [-117.13193, 33.06024]]]]}	Open Access 1	7314	Del Dios Highlands Preserve	10675	319	San Diego, County of 104	County 3	County Agency 3	http://www.sandiegocounty.gov/parks/	County 3	319	San Diego, County of 101	County 3	County Agency 3	http://www.sdparks.org/content/sdparks/en/park-pages/DelDiosHighlands.html	San Diego 4	781.705	Del Dios Highlands Preserve	0	Local Conservation Area 4	2

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
   FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
   FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
   FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
   FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);