calands: units_with_maps: 14 rows where DES_TP = 3, GAP_STS = 4 and MNG

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

14 rows where DES_TP = 3, GAP_STS = 4 and MNG_AGENCY = 197

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
559	559	558	{"type": "Polygon", "coordinates": [[[-117.14812, 33.12447], [-117.14555, 33.12477], [-117.14553, 33.12381], [-117.1481, 33.12381], [-117.14812, 33.12447]]]}	Open Access 1	1866	City of San Marcos Open Space	17333	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2		San Diego 4	5.376	City of San Marcos OS	Local Recreation Area 3	4
1524	1524	1523	{"type": "Polygon", "coordinates": [[[-117.12865, 33.15166], [-117.12863, 33.15202], [-117.12765, 33.15199], [-117.12767, 33.15133], [-117.12844, 33.15134], [-117.12843, 33.15165], [-117.12865, 33.15166]]]}	Open Access 1	47730	Woodland Park Tennis Courts	31531	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2		San Diego 4	1.518	Woodland Park Tennis Courts	Local Recreation Area 3	4
3822	3822	3821	{"type": "MultiPolygon", "coordinates": [[[[-117.16091, 33.13937], [-117.15846, 33.14101], [-117.15822, 33.14036], [-117.15821, 33.14035], [-117.15831, 33.14084], [-117.1584, 33.14105], [-117.15769, 33.14153], [-117.1577, 33.14159], [-117.15715, 33.14168], [-117.15661, 33.14181], [-117.15656, 33.14167], [-117.15663, 33.14161], [-117.15665, 33.14152], [-117.15663, 33.14145], [-117.15659, 33.14141], [-117.15691, 33.14112], [-117.15709, 33.14098], [-117.15796, 33.14043], [-117.16037, 33.13882], [-117.16091, 33.13937]]], [[[-117.16212, 33.13866], [-117.16175, 33.13905], [-117.16107, 33.13923], [-117.1605, 33.13865], [-117.16073, 33.13857], [-117.1615, 33.13836], [-117.16206, 33.1385], [-117.16212, 33.13866]]]]}	No Public Access 3	45235	San Marcos City Open Space	24944	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2		San Diego 4	10.993	San Marcos City OS	Local Recreation Area 3	4
4398	4398	4397	{"type": "Polygon", "coordinates": [[[-117.18329, 33.14634], [-117.1828, 33.14626], [-117.17872, 33.14576], [-117.1788, 33.14537], [-117.17884, 33.14494], [-117.1789, 33.1446], [-117.17915, 33.1445], [-117.17921, 33.1445], [-117.17956, 33.14463], [-117.17994, 33.14406], [-117.18015, 33.14392], [-117.18033, 33.1437], [-117.18045, 33.1436], [-117.18329, 33.14634]]]}	Open Access 1	1831	Mission Sports Park	22312	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2	http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/163/1081	San Diego 4	15.175	Mission Sports Park	Local Recreation Area 3	4
9938	9938	9937	{"type": "Polygon", "coordinates": [[[-117.18229, 33.16732], [-117.1818, 33.16767], [-117.18177, 33.16834], [-117.1747, 33.16811], [-117.17439, 33.1632], [-117.17425, 33.16054], [-117.17772, 33.16053], [-117.17791, 33.16137], [-117.17776, 33.16141], [-117.17785, 33.1618], [-117.17729, 33.16189], [-117.17689, 33.16205], [-117.17657, 33.16226], [-117.17624, 33.16257], [-117.17602, 33.1629], [-117.17589, 33.16318], [-117.17582, 33.16346], [-117.17585, 33.16381], [-117.17592, 33.16398], [-117.17601, 33.16414], [-117.17623, 33.16441], [-117.17651, 33.16424], [-117.17653, 33.16426], [-117.17626, 33.16444], [-117.17667, 33.16491], [-117.17696, 33.16515], [-117.17714, 33.16526], [-117.1774, 33.16535], [-117.17761, 33.1654], [-117.1778, 33.1654], [-117.17807, 33.16539], [-117.1786, 33.16531], [-117.17894, 33.1653], [-117.17912, 33.16533], [-117.17944, 33.16545], [-117.17959, 33.16553], [-117.18049, 33.16633], [-117.18066, 33.16645], [-117.18119, 33.16674], [-117.1816, 33.16709], [-117.18185, 33.16691], [-117.18229, 33.16732]], [[-117.1756, 33.16062], [-117.17556, 33.1606], [-117.17549, 33.16061], [-117.1751, 33.1608], [-117.17468, 33.16093], [-117.17464, 33.16099], [-117.1746, 33.16107], [-117.17459, 33.16119], [-117.17473, 33.16128], [-117.17497, 33.16138], [-117.17517, 33.16139], [-117.17528, 33.16137], [-117.1755, 33.16119], [-117.17567, 33.16088], [-117.1756, 33.16062]]]}	Open Access 1	1949	City of San Marcos Open Space	17333	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2		San Diego 4	74.648	City of San Marcos OS	Local Recreation Area 3	4
10023	10023	10022	{"type": "MultiPolygon", "coordinates": [[[[-117.17416, 33.12472], [-117.17243, 33.12474], [-117.17244, 33.12667], [-117.17248, 33.12668], [-117.1725, 33.12673], [-117.17253, 33.1269], [-117.17254, 33.12709], [-117.17258, 33.1271], [-117.17295, 33.12709], [-117.17376, 33.12712], [-117.1738, 33.1271], [-117.17396, 33.12664], [-117.17399, 33.12649], [-117.17404, 33.12654], [-117.17391, 33.1272], [-117.17386, 33.12725], [-117.17382, 33.12725], [-117.1735, 33.12721], [-117.1732, 33.12719], [-117.17242, 33.12719], [-117.17239, 33.12717], [-117.17237, 33.12661], [-117.17238, 33.12609], [-117.17236, 33.12464], [-117.17416, 33.12463], [-117.17416, 33.12472]]], [[[-117.17811, 33.12863], [-117.17302, 33.12999], [-117.17294, 33.12981], [-117.17384, 33.12959], [-117.17406, 33.12955], [-117.17449, 33.12943], [-117.17452, 33.12945], [-117.17584, 33.12912], [-117.17612, 33.12906], [-117.17614, 33.12906], [-117.17663, 33.12892], [-117.17714, 33.12879], [-117.1777, 33.12868], [-117.1779, 33.12859], [-117.17771, 33.12846], [-117.1773, 33.12825], [-117.17728, 33.12827], [-117.17722, 33.12822], [-117.17712, 33.1282], [-117.17703, 33.12821], [-117.17696, 33.12827], [-117.17691, 33.12812], [-117.17692, 33.12809], [-117.177, 33.12812], [-117.17714, 33.12813], [-117.17765, 33.12835], [-117.17811, 33.12863]]], [[[-117.17416, 33.12524], [-117.17415, 33.12595], [-117.17408, 33.12629], [-117.17402, 33.12632], [-117.17361, 33.12632], [-117.17352, 33.12633], [-117.17348, 33.12616], [-117.17384, 33.12612], [-117.17393, 33.12606], [-117.17399, 33.126], [-117.17406, 33.1257], [-117.1741, 33.12535], [-117.1741, 33.1252], [-117.17416, 33.12524]]], [[[-117.17842, 33.12527], [-117.17841, 33.12554], [-117.17837, 33.12573], [-117.17826, 33.12591], [-117.17814, 33.12604], [-117.17802, 33.12611], [-117.17753, 33.12634], [-117.17722, 33.12653], [-117.17687, 33.12688], [-117.1767, 33.12709], [-117.17661, 33.12725], [-117.1765, 33.12759], [-117.17646, 33.12764], [-117.17639, 33.12763], [-117.17626, 33.12758], [-117.17608, 33.12755], [-117.1759, 33.12756], [-117.17419, 33.12733], [-117.17414, 33.12729], [-117.17413, 33.12725], [-117.17418, 33.12699], [-117.1742, 33.127], [-117.1742, 33.12723], [-117.17425, 33.12728], [-117.17552, 33.1274], [-117.17608, 33.12742], [-117.17627, 33.12735], [-117.17696, 33.12672], [-117.17697, 33.12672], [-117.17703, 33.12667], [-117.17703, 33.12665], [-117.17711, 33.12657], [-117.17716, 33.12647], [-117.17706, 33.1264], [-117.17695, 33.12619], [-117.17708, 33.12611], [-117.17719, 33.126], [-117.17725, 33.12586], [-117.17722, 33.12567], [-117.17748, 33.12588], [-117.17763, 33.12594], [-117.17779, 33.12596], [-117.17796, 33.12593], [-117.1781, 33.12585], [-117.1782, 33.12575], [-117.17826, 33.12564], [-117.1783, 33.12547], [-117.17831, 33.12522], [-117.1784, 33.12524], [-117.17842, 33.12527]]], [[[-117.17522, 33.12471], [-117.17446, 33.12472], [-117.17438, 33.12468], [-117.17437, 33.12463], [-117.17522, 33.12463], [-117.17522, 33.12471]]], [[[-117.19148, 33.12706], [-117.19144, 33.12706], [-117.19118, 33.12607], [-117.19115, 33.12579], [-117.1912, 33.12563], [-117.19109, 33.12521], [-117.19089, 33.12507], [-117.19045, 33.12506], [-117.19028, 33.12509], [-117.19014, 33.12508], [-117.18934, 33.12488], [-117.18892, 33.12484], [-117.18891, 33.12453], [-117.18867, 33.12453], [-117.18866, 33.12483], [-117.18818, 33.12484], [-117.18773, 33.12491], [-117.18751, 33.12497], [-117.18716, 33.12511], [-117.18685, 33.12518], [-117.1867, 33.12519], [-117.18592, 33.12515], [-117.1857, 33.12518], [-117.18576, 33.12546], [-117.18573, 33.12546], [-117.18561, 33.12525], [-117.18535, 33.12497], [-117.18513, 33.12488], [-117.18478, 33.12493], [-117.18456, 33.12518], [-117.18458, 33.12553], [-117.18471, 33.12561], [-117.18491, 33.12566], [-117.18505, 33.12579], [-117.18495, 33.12587], [-117.18461, 33.12564], [-117.18411, 33.12544], [-117.18403, 33.12533], [-117.18395, 33.12505], [-117.18363, 33.12511], [-117.18344, 33.12443], [-117.18331, 33.1242], [-117.18308, 33.12388], [-117.18292, 33.12351], [-117.18329, 33.12353], [-117.18335, 33.12333], [-117.18309, 33.12312], [-117.18301, 33.12297], [-117.18302, 33.12282], [-117.183, 33.12267], [-117.18303, 33.12252], [-117.18297, 33.12235], [-117.18286, 33.12227], [-117.18266, 33.1222], [-117.18242, 33.12233], [-117.18215, 33.12244], [-117.18236, 33.1227], [-117.18231, 33.12274], [-117.18213, 33.12252], [-117.18203, 33.1225], [-117.18183, 33.1226], [-117.18178, 33.12298], [-117.18166, 33.12302], [-117.18142, 33.12295], [-117.18104, 33.12298], [-117.18098, 33.12311], [-117.18102, 33.12316], [-117.18098, 33.1232], [-117.18092, 33.12317], [-117.18064, 33.12321], [-117.18063, 33.12328], [-117.18064, 33.12336], [-117.1807, 33.1235], [-117.18079, 33.12359], [-117.18154, 33.12421], [-117.18136, 33.12422], [-117.18174, 33.12457], [-117.18327, 33.12457], [-117.18343, 33.12512], [-117.18259, 33.12529], [-117.18138, 33.12541], [-117.18116, 33.12541], [-117.18123, 33.12534], [-117.18132, 33.1252], [-117.18109, 33.12508], [-117.181, 33.12507], [-117.181, 33.12502], [-117.18097, 33.12498], [-117.18086, 33.12491], [-117.18079, 33.1249], [-117.18068, 33.12494], [-117.18062, 33.125], [-117.18059, 33.12508], [-117.18051, 33.12512], [-117.18029, 33.12516], [-117.1799, 33.12517], [-117.17989, 33.1249], [-117.17957, 33.12488], [-117.1794, 33.12485], [-117.1791, 33.12483], [-117.17891, 33.12489], [-117.17868, 33.12511], [-117.17868, 33.12515], [-117.17858, 33.12506], [-117.17851, 33.12502], [-117.17837, 33.12502], [-117.17829, 33.12505], [-117.1783, 33.12488], [-117.17797, 33.12488], [-117.17798, 33.12476], [-117.17796, 33.12461], [-117.1783, 33.1246], [-117.17824, 33.12439], [-117.17815, 33.12424], [-117.17805, 33.12411], [-117.1774, 33.12354], [-117.17727, 33.12344], [-117.17712, 33.12336], [-117.17682, 33.12325], [-117.17666, 33.12321], [-117.1765, 33.12318], [-117.1762, 33.12316], [-117.17594, 33.12311], [-117.1758, 33.1231], [-117.17556, 33.12313], [-117.17534, 33.12329], [-117.17561, 33.12346], [-117.17559, 33.12348], [-117.17531, 33.12332], [-117.17522, 33.12346], [-117.17521, 33.12243], [-117.17497, 33.12244], [-117.17496, 33.12229], [-117.17473, 33.12209], [-117.17446, 33.12204], [-117.1745, 33.12191], [-117.17477, 33.12186], [-117.17505, 33.1219], [-117.17624, 33.12193], [-117.17679, 33.12205], [-117.17715, 33.122], [-117.17736, 33.12207], [-117.17735, 33.12049], [-117.18754, 33.12045], [-117.18771, 33.12056], [-117.18764, 33.12056], [-117.18757, 33.1206], [-117.18755, 33.12063], [-117.1875, 33.12067], [-117.18749, 33.12071], [-117.18722, 33.12086], [-117.18727, 33.12095], [-117.18738, 33.12106], [-117.18753, 33.12117], [-117.18802, 33.12142], [-117.18815, 33.12152], [-117.18824, 33.12177], [-117.18819, 33.12226], [-117.18823, 33.12259], [-117.18779, 33.1226], [-117.18755, 33.12263], [-117.18741, 33.12265], [-117.18713, 33.12276], [-117.1868, 33.123], [-117.18664, 33.12319], [-117.18652, 33.12344], [-117.18648, 33.12368], [-117.18638, 33.12368], [-117.18615, 33.1238], [-117.18615, 33.12382], [-117.18635, 33.12401], [-117.18646, 33.12407], [-117.18662, 33.12411], [-117.18679, 33.1241], [-117.1869, 33.12407], [-117.1872, 33.12387], [-117.18867, 33.12387], [-117.18867, 33.12393], [-117.18879, 33.12393], [-117.18888, 33.12403], [-117.18886, 33.12409], [-117.18887, 33.12436], [-117.19031, 33.12435], [-117.19031, 33.12439], [-117.19034, 33.12443], [-117.19033, 33.12452], [-117.19027, 33.12452], [-117.19028, 33.12477], [-117.19145, 33.12477], [-117.19148, 33.12706]]], [[[-117.17682, 33.12806], [-117.17671, 33.12804], [-117.17658, 33.12807], [-117.17651, 33.12829], [-117.1765, 33.12838], [-117.17647, 33.12838], [-117.17648, 33.12831], [-117.17657, 33.12802], [-117.1766, 33.12799], [-117.17665, 33.12797], [-117.17671, 33.12799], [-117.17682, 33.12806]]], [[[-117.17854, 33.12599], [-117.17844, 33.12616], [-117.17818, 33.12637], [-117.17809, 33.12662], [-117.1781, 33.12672], [-117.17797, 33.1268], [-117.17755, 33.12654], [-117.17822, 33.12621], [-117.17848, 33.12599], [-117.17854, 33.12599]]], [[[-117.18067, 33.13017], [-117.17992, 33.13037], [-117.17963, 33.12975], [-117.17943, 33.12945], [-117.17917, 33.12911], [-117.17916, 33.12909], [-117.17918, 33.12905], [-117.17934, 33.12894], [-117.1797, 33.12934], [-117.17981, 33.12955], [-117.17997, 33.12986], [-117.18012, 33.13003], [-117.18034, 33.13014], [-117.18067, 33.13017]]], [[[-117.18623, 33.12773], [-117.18591, 33.12818], [-117.18588, 33.12846], [-117.18576, 33.12846], [-117.18564, 33.12847], [-117.18566, 33.12863], [-117.18572, 33.12882], [-117.18252, 33.12968], [-117.18208, 33.1285], [-117.18157, 33.12807], [-117.18145, 33.12802], [-117.18146, 33.12797], [-117.18172, 33.12809], [-117.18174, 33.12803], [-117.18196, 33.1281], [-117.18197, 33.12805], [-117.18218, 33.12811], [-117.1822, 33.12806], [-117.18234, 33.12812], [-117.18237, 33.12806], [-117.18278, 33.12818], [-117.18279, 33.12819], [-117.18299, 33.12826], [-117.18298, 33.1283], [-117.18319, 33.12834], [-117.18315, 33.1284], [-117.18316, 33.12841], [-117.18339, 33.12842], [-117.18356, 33.12817], [-117.18361, 33.12819], [-117.18344, 33.12846], [-117.18359, 33.1285], [-117.18406, 33.1287], [-117.18423, 33.12884], [-117.18442, 33.12893], [-117.18454, 33.12897], [-117.18478, 33.12898], [-117.18485, 33.12895], [-117.1849, 33.12897], [-117.18518, 33.12887], [-117.18532, 33.12875], [-117.18537, 33.12878], [-117.18547, 33.12865], [-117.18552, 33.12867], [-117.18562, 33.12833], [-117.18529, 33.12828], [-117.18531, 33.12825], [-117.18562, 33.12829], [-117.18565, 33.12823], [-117.18562, 33.12806], [-117.18549, 33.12786], [-117.18512, 33.12761], [-117.18408, 33.12662], [-117.18383, 33.12681], [-117.1838, 33.12677], [-117.18404, 33.12659], [-117.1837, 33.12627], [-117.18381, 33.12619], [-117.18395, 33.12618], [-117.1841, 33.12621], [-117.18425, 33.12629], [-117.18435, 33.12637], [-117.18491, 33.12691], [-117.18531, 33.12725], [-117.18561, 33.12744], [-117.18593, 33.12761], [-117.18623, 33.12773]]], [[[-117.18503, 33.1282], [-117.18501, 33.12824], [-117.1847, 33.12847], [-117.18466, 33.12847], [-117.18463, 33.12847], [-117.18491, 33.12821], [-117.18471, 33.12804], [-117.18436, 33.12794], [-117.18432, 33.12797], [-117.18427, 33.12799], [-117.18323, 33.12751], [-117.18306, 33.12776], [-117.18303, 33.12775], [-117.18318, 33.1275], [-117.18288, 33.12727], [-117.18287, 33.12725], [-117.18265, 33.12713], [-117.18265, 33.1271], [-117.1824, 33.12697], [-117.18224, 33.12694], [-117.18223, 33.12673], [-117.18202, 33.12646], [-117.18179, 33.12634], [-117.18176, 33.12634], [-117.18174, 33.1262], [-117.18267, 33.12613], [-117.18286, 33.12608], [-117.18282, 33.12575], [-117.18285, 33.12579], [-117.18293, 33.12606], [-117.18302, 33.12625], [-117.18317, 33.12643], [-117.18502, 33.12818], [-117.18503, 33.1282]]], [[[-117.18752, 33.12608], [-117.18745, 33.12614], [-117.1874, 33.12628], [-117.18709, 33.12657], [-117.18697, 33.1267], [-117.18683, 33.12692], [-117.18673, 33.12714], [-117.18627, 33.12695], [-117.18599, 33.12679], [-117.18573, 33.12659], [-117.18546, 33.12634], [-117.18544, 33.12614], [-117.18548, 33.12607], [-117.18563, 33.12597], [-117.18567, 33.12603], [-117.18596, 33.12598], [-117.18636, 33.12598], [-117.18683, 33.12604], [-117.18728, 33.12594], [-117.18752, 33.12608]]], [[[-117.18863, 33.12556], [-117.1885, 33.12594], [-117.18841, 33.12613], [-117.1882, 33.12639], [-117.18791, 33.12666], [-117.18768, 33.12683], [-117.18756, 33.12694], [-117.18742, 33.12713], [-117.18733, 33.12738], [-117.18718, 33.12734], [-117.18727, 33.1271], [-117.18756, 33.12675], [-117.18794, 33.12648], [-117.1881, 33.12623], [-117.188, 33.12594], [-117.18771, 33.1258], [-117.18769, 33.12568], [-117.18785, 33.12562], [-117.18818, 33.12556], [-117.18863, 33.12556]]], [[[-117.19027, 33.12682], [-117.18996, 33.12699], [-117.18984, 33.127], [-117.18955, 33.12735], [-117.18952, 33.12724], [-117.18948, 33.1272], [-117.18941, 33.12716], [-117.18935, 33.12714], [-117.18928, 33.12715], [-117.18921, 33.12718], [-117.18917, 33.12722], [-117.18905, 33.12715], [-117.1894, 33.12697], [-117.18869, 33.12631], [-117.18853, 33.12657], [-117.1882, 33.12684], [-117.18805, 33.12699], [-117.18795, 33.12714], [-117.1878, 33.12746], [-117.1876, 33.12741], [-117.18766, 33.12724], [-117.18777, 33.12707], [-117.18814, 33.1268], [-117.18832, 33.12664], [-117.1886, 33.12631], [-117.18875, 33.12605], [-117.1888, 33.12593], [-117.18887, 33.12574], [-117.18889, 33.12559], [-117.1891, 33.1256], [-117.18921, 33.1258], [-117.18904, 33.12596], [-117.18898, 33.12607], [-117.18896, 33.12621], [-117.189, 33.12634], [-117.18907, 33.12647], [-117.18918, 33.12656], [-117.18946, 33.12667], [-117.18976, 33.12669], [-117.19025, 33.12668], [-117.19027, 33.12682]]], [[[-117.19006, 33.12172], [-117.18982, 33.12153], [-117.18949, 33.12151], [-117.18934, 33.12155], [-117.1892, 33.12149], [-117.18897, 33.12116], [-117.18872, 33.12085], [-117.18857, 33.1207], [-117.18808, 33.12045], [-117.18973, 33.12044], [-117.18974, 33.12104], [-117.19006, 33.12104], [-117.19006, 33.12172]]]]}	Open Access 1	18707	Discovery Lake Park and Open Space	18163	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2	http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/164/1081	San Diego 4	156.563	Discovery Lake Park and OS	Local Recreation Area 3	4
15971	15971	15970	{"type": "Polygon", "coordinates": [[[-117.16978, 33.1527], [-117.16956, 33.15253], [-117.16955, 33.15249], [-117.1694, 33.15236], [-117.16939, 33.15232], [-117.16922, 33.15221], [-117.16922, 33.15216], [-117.16903, 33.15204], [-117.16902, 33.15199], [-117.16878, 33.15188], [-117.16857, 33.15213], [-117.16834, 33.15202], [-117.16849, 33.15174], [-117.16848, 33.1517], [-117.16818, 33.15162], [-117.16788, 33.15157], [-117.16761, 33.15156], [-117.16758, 33.15155], [-117.1673, 33.15158], [-117.16711, 33.15157], [-117.16698, 33.15159], [-117.16685, 33.15178], [-117.16653, 33.15211], [-117.16631, 33.15221], [-117.1671, 33.15139], [-117.16753, 33.15139], [-117.16812, 33.1515], [-117.1685, 33.15163], [-117.16879, 33.15179], [-117.16905, 33.15196], [-117.16917, 33.15206], [-117.16976, 33.15264], [-117.16978, 33.1527]]]}	Open Access 1	1817	City of San Marcos Open Space	17333	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2		San Diego 4	1.188	City of San Marcos OS	Local Recreation Area 3	4
15991	15991	15990	{"type": "Polygon", "coordinates": [[[-117.1688, 33.15147], [-117.16874, 33.15146], [-117.16824, 33.15127], [-117.16804, 33.15122], [-117.16773, 33.15117], [-117.16777, 33.15112], [-117.16796, 33.15118], [-117.168, 33.15117], [-117.16818, 33.15124], [-117.16821, 33.15121], [-117.16838, 33.1513], [-117.16843, 33.15128], [-117.16859, 33.15137], [-117.16863, 33.15136], [-117.1688, 33.15147]]]}	Open Access 1	1808	City of San Marcos Open Space	17333	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2		San Diego 4	0.109	City of San Marcos OS	Local Recreation Area 3	4
15996	15996	15995	{"type": "Polygon", "coordinates": [[[-117.18616, 33.15609], [-117.18576, 33.1561], [-117.18562, 33.15604], [-117.18475, 33.1554], [-117.18447, 33.15531], [-117.18401, 33.15525], [-117.18391, 33.15517], [-117.1837, 33.15513], [-117.18323, 33.15512], [-117.18287, 33.15522], [-117.1826, 33.15547], [-117.18259, 33.1555], [-117.18257, 33.15551], [-117.18253, 33.15575], [-117.1827, 33.15598], [-117.18286, 33.15616], [-117.18303, 33.1562], [-117.18373, 33.15615], [-117.18397, 33.15615], [-117.18417, 33.15612], [-117.18496, 33.15664], [-117.18507, 33.15691], [-117.18249, 33.15695], [-117.18232, 33.15339], [-117.18371, 33.15336], [-117.18316, 33.15377], [-117.18294, 33.15382], [-117.18291, 33.15398], [-117.18325, 33.15416], [-117.18335, 33.15417], [-117.18335, 33.15425], [-117.18344, 33.15432], [-117.18336, 33.15442], [-117.18349, 33.15463], [-117.18373, 33.15463], [-117.18397, 33.15449], [-117.18395, 33.15447], [-117.18425, 33.15432], [-117.1845, 33.1543], [-117.18472, 33.15435], [-117.18499, 33.15457], [-117.18522, 33.15457], [-117.18527, 33.15469], [-117.18535, 33.15472], [-117.18531, 33.1548], [-117.18541, 33.15504], [-117.18539, 33.15522], [-117.18557, 33.15543], [-117.18566, 33.15558], [-117.18569, 33.15575], [-117.18612, 33.15574], [-117.18616, 33.15609]]]}	Open Access 1	1799	City of San Marcos Open Space	17333	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2		San Diego 4	14.769	City of San Marcos OS	Local Recreation Area 3	4
16002	16002	16001	{"type": "Polygon", "coordinates": [[[-117.17026, 33.15271], [-117.17005, 33.15254], [-117.16937, 33.15188], [-117.16919, 33.15172], [-117.16898, 33.15158], [-117.16899, 33.15154], [-117.16912, 33.15166], [-117.16917, 33.15165], [-117.16928, 33.15177], [-117.16932, 33.15177], [-117.16943, 33.1519], [-117.16947, 33.1519], [-117.16959, 33.15205], [-117.16963, 33.15205], [-117.16975, 33.15221], [-117.16979, 33.15221], [-117.1699, 33.15236], [-117.16995, 33.15237], [-117.17007, 33.15252], [-117.17012, 33.15253], [-117.17026, 33.15271]]]}	Open Access 1	1818	City of San Marcos Open Space	17333	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2		San Diego 4	0.155	City of San Marcos OS	Local Recreation Area 3	4
16004	16004	16003	{"type": "Polygon", "coordinates": [[[-117.17371, 33.14974], [-117.17371, 33.15282], [-117.17358, 33.15257], [-117.17322, 33.15261], [-117.1731, 33.15265], [-117.17302, 33.1526], [-117.17293, 33.1526], [-117.17285, 33.15265], [-117.1727, 33.15242], [-117.17178, 33.15243], [-117.17139, 33.15238], [-117.17083, 33.15211], [-117.17017, 33.15147], [-117.17021, 33.15144], [-117.17031, 33.15143], [-117.17076, 33.15108], [-117.17086, 33.15092], [-117.1703, 33.15076], [-117.17031, 33.15072], [-117.17029, 33.15067], [-117.17026, 33.15062], [-117.17022, 33.1506], [-117.1704, 33.15027], [-117.17056, 33.15017], [-117.17045, 33.14997], [-117.17039, 33.14975], [-117.17371, 33.14974]]]}	Open Access 1	1819	City of San Marcos Open Space	17333	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2		San Diego 4	22.056	City of San Marcos OS	Local Recreation Area 3	4
16005	16005	16004	{"type": "Polygon", "coordinates": [[[-117.16735, 33.15265], [-117.16713, 33.1529], [-117.1672, 33.15355], [-117.16624, 33.15355], [-117.1663, 33.15317], [-117.16642, 33.15291], [-117.16654, 33.15276], [-117.16692, 33.15237], [-117.16703, 33.15229], [-117.16735, 33.15265]]]}	Open Access 1	1821	City of San Marcos Open Space	17333	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2		San Diego 4	2.223	City of San Marcos OS	Local Recreation Area 3	4
16011	16011	16010	{"type": "Polygon", "coordinates": [[[-117.17372, 33.15323], [-117.17372, 33.15323], [-117.1724, 33.15322], [-117.17351, 33.15316], [-117.17363, 33.15296], [-117.17372, 33.15286], [-117.17372, 33.15323]]]}	Open Access 1	1820	City of San Marcos Open Space	17333	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2		San Diego 4	0.221	City of San Marcos OS	Local Recreation Area 3	4
16014	16014	16013	{"type": "MultiPolygon", "coordinates": [[[[-117.17767, 33.134], [-117.17757, 33.13399], [-117.17694, 33.13412], [-117.17638, 33.13427], [-117.1762, 33.13433], [-117.17605, 33.13441], [-117.17581, 33.13457], [-117.17563, 33.13473], [-117.17526, 33.13514], [-117.17471, 33.13553], [-117.17329, 33.13626], [-117.17329, 33.1363], [-117.17296, 33.13644], [-117.17295, 33.13647], [-117.17207, 33.13636], [-117.17152, 33.13637], [-117.17082, 33.13645], [-117.17142, 33.13609], [-117.17225, 33.13567], [-117.17242, 33.13614], [-117.17331, 33.13591], [-117.1728, 33.13453], [-117.17741, 33.1333], [-117.17767, 33.134]]], [[[-117.18715, 33.13282], [-117.18214, 33.13416], [-117.18201, 33.13387], [-117.1812, 33.13407], [-117.18058, 33.13246], [-117.18054, 33.13245], [-117.18414, 33.13145], [-117.18639, 33.13086], [-117.18715, 33.13282]]]]}	Open Access 1	1862	San Marcos Creek Open Space	24945	1308	San Marcos, City of 201	City 2	City Agency 2	http://www.ci.san-marcos.ca.us/index.aspx?page=42	City 2	1308	San Marcos, City of 197	City 2	City Agency 2		San Diego 4	47.467	San Marcos Creek OS	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]);