units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where MNG_AGENCY = 197 sorted by SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 0 | 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 | 0 | Local Recreation Area 3 | 4 | |
6362 | 6362 | 6361 | {"type": "MultiPolygon", "coordinates": [[[[-117.15494, 33.18453], [-117.15476, 33.18493], [-117.1547, 33.18503], [-117.15452, 33.18522], [-117.15437, 33.18532], [-117.15412, 33.18544], [-117.15215, 33.18622], [-117.15055, 33.18412], [-117.15249, 33.17979], [-117.15452, 33.18044], [-117.15298, 33.1839], [-117.15494, 33.18453]]], [[[-117.15956, 33.17354], [-117.15956, 33.17356], [-117.15938, 33.17397], [-117.15928, 33.17428], [-117.15912, 33.17535], [-117.15892, 33.17581], [-117.15689, 33.17517], [-117.15611, 33.17685], [-117.15513, 33.17655], [-117.15471, 33.17739], [-117.15439, 33.1787], [-117.15385, 33.18001], [-117.15258, 33.17961], [-117.15573, 33.17252], [-117.15582, 33.17242], [-117.15587, 33.17233], [-117.15593, 33.17231], [-117.15951, 33.17349], [-117.15956, 33.17354]]]]} | Open Access 1 | 1734 | Walnut Grove Park | 27232 | 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/166/1081?npage=2 | San Diego 4 | 85.152 | Walnut Grove Park | 0 | Local Park 2 | 4 |
2861 | 2861 | 2860 | {"type": "Polygon", "coordinates": [[[-117.13342, 33.14761], [-117.13288, 33.14884], [-117.13241, 33.14999], [-117.13211, 33.15068], [-117.12988, 33.15061], [-117.1299, 33.15021], [-117.13084, 33.15023], [-117.13094, 33.14816], [-117.13177, 33.14817], [-117.13179, 33.14755], [-117.13342, 33.14761]]]} | Open Access 1 | 1834 | Woodland Park | 27724 | 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/167/1081?npage=2 | San Diego 4 | 14.507 | Woodland Park | 0 | Local Park 2 | 4 |
4597 | 4597 | 4596 | {"type": "Polygon", "coordinates": [[[-117.18544, 33.1626], [-117.18544, 33.16267], [-117.18537, 33.16299], [-117.18467, 33.1629], [-117.18466, 33.16288], [-117.18471, 33.16253], [-117.18544, 33.1626]]]} | Open Access 1 | 35551 | Unknown park - San Marcos, City of | 28686 | 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.736 | 0 | Local Other or Unknown 14 | 4 | ||
4614 | 4614 | 4613 | {"type": "Polygon", "coordinates": [[[-117.14137, 33.15374], [-117.14114, 33.15399], [-117.1411, 33.154], [-117.14106, 33.154], [-117.14103, 33.15398], [-117.14101, 33.15395], [-117.14087, 33.15347], [-117.14094, 33.15346], [-117.14137, 33.15374]]]} | Open Access 1 | 35852 | Unknown park - San Marcos, City of | 28686 | 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.339 | 0 | Local Other or Unknown 14 | 4 | ||
4387 | 4387 | 4386 | {"type": "Polygon", "coordinates": [[[-117.17078, 33.14419], [-117.17069, 33.14454], [-117.16617, 33.14341], [-117.16616, 33.14322], [-117.16611, 33.14305], [-117.17078, 33.14419]]]} | Open Access 1 | 45969 | Buelow Park | 29118 | 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/153/1081 | San Diego 4 | 4.241 | Buelow Park | 0 | Local Park 2 | 4 |
17045 | 17045 | 17044 | {"type": "Polygon", "coordinates": [[[-117.15886, 33.14153], [-117.15831, 33.14154], [-117.1577, 33.14159], [-117.15768, 33.14153], [-117.1584, 33.14106], [-117.15849, 33.1412], [-117.15861, 33.14133], [-117.15886, 33.14153]]]} | Open Access 1 | 45970 | Civic Center Park | 29119 | 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/150/1081 | San Diego 4 | 0.729 | Civic Ctr. Park | 0 | Local Park 2 | 4 |
15144 | 15144 | 15143 | {"type": "Polygon", "coordinates": [[[-117.14676, 33.14701], [-117.14641, 33.14733], [-117.14605, 33.14732], [-117.14585, 33.14745], [-117.14584, 33.14782], [-117.14563, 33.1482], [-117.14521, 33.14846], [-117.14455, 33.14859], [-117.14409, 33.1489], [-117.14399, 33.14905], [-117.14433, 33.15065], [-117.14424, 33.1507], [-117.14388, 33.1491], [-117.14352, 33.14915], [-117.14345, 33.14921], [-117.14334, 33.14918], [-117.14327, 33.1492], [-117.14321, 33.14924], [-117.14315, 33.14921], [-117.14293, 33.14924], [-117.14296, 33.14942], [-117.1427, 33.14946], [-117.14259, 33.14944], [-117.14251, 33.14946], [-117.14238, 33.14931], [-117.14232, 33.14904], [-117.14345, 33.14887], [-117.14418, 33.14836], [-117.14393, 33.14776], [-117.14347, 33.14781], [-117.14299, 33.14772], [-117.14227, 33.148], [-117.14194, 33.14804], [-117.14197, 33.14855], [-117.14148, 33.14863], [-117.14095, 33.14625], [-117.14507, 33.1456], [-117.14561, 33.14472], [-117.14572, 33.14478], [-117.14506, 33.14588], [-117.14566, 33.14685], [-117.14647, 33.14668], [-117.14676, 33.14701]]]} | Open Access 1 | 45971 | Hollandia Park | 29121 | 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/156/1081 | San Diego 4 | 29.818 | Hollandia Park | 0 | Local Park 2 | 4 |
15145 | 15145 | 15144 | {"type": "Polygon", "coordinates": [[[-117.22521, 33.12266], [-117.22464, 33.12337], [-117.2252, 33.12429], [-117.22484, 33.12462], [-117.2246, 33.12477], [-117.22338, 33.12367], [-117.2235, 33.12358], [-117.22433, 33.12266], [-117.2249, 33.12218], [-117.22521, 33.12266]]]} | Open Access 1 | 45972 | Simmons Family Park | 29122 | 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/158/1081?npage=2 | San Diego 4 | 5.896 | Simmons Family Park | 0 | Local Park 2 | 4 |
3905 | 3905 | 3904 | {"type": "Polygon", "coordinates": [[[-117.21535, 33.1462], [-117.21466, 33.14765], [-117.21064, 33.14621], [-117.21065, 33.14618], [-117.20942, 33.14575], [-117.21011, 33.1444], [-117.2111, 33.14476], [-117.21098, 33.145], [-117.21105, 33.14506], [-117.21106, 33.14505], [-117.21116, 33.14507], [-117.21124, 33.14505], [-117.21137, 33.14479], [-117.21238, 33.14513], [-117.21535, 33.1462]]]} | Open Access 1 | 45973 | Sunset Park | 29123 | 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/155/1081?npage=2 | San Diego 4 | 22.101 | Sunset Park | 0 | Local Park 2 | 4 |
7628 | 7628 | 7627 | {"type": "Polygon", "coordinates": [[[-117.15123, 33.13075], [-117.14933, 33.13075], [-117.14897, 33.13165], [-117.14916, 33.13197], [-117.15033, 33.13376], [-117.14836, 33.13491], [-117.14827, 33.13106], [-117.14832, 33.12938], [-117.14827, 33.12783], [-117.14921, 33.12832], [-117.14932, 33.12837], [-117.14963, 33.12845], [-117.15012, 33.12851], [-117.15039, 33.12859], [-117.15064, 33.12873], [-117.15083, 33.12889], [-117.15099, 33.12911], [-117.15109, 33.12937], [-117.15123, 33.13075]]]} | No Public Access 3 | 47623 | La Moree Park | 31359 | 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 | 28.883 | La Moree Park | 0 | Local Park 2 | 4 | |
4784 | 4784 | 4783 | {"type": "Polygon", "coordinates": [[[-117.17371, 33.15352], [-117.16952, 33.15353], [-117.16952, 33.15346], [-117.16955, 33.15327], [-117.16964, 33.15308], [-117.16977, 33.15295], [-117.1699, 33.15285], [-117.16995, 33.15283], [-117.16999, 33.15285], [-117.1703, 33.15306], [-117.17058, 33.1532], [-117.17095, 33.15333], [-117.17128, 33.15342], [-117.1718, 33.15347], [-117.17371, 33.15348], [-117.17371, 33.15352]]]} | Open Access 1 | 47624 | Unnamed San Marcos City Park 1 | 31361 | 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.05 | 0 | Local Other or Unknown 14 | 4 | ||
7630 | 7630 | 7629 | {"type": "Polygon", "coordinates": [[[-117.17031, 33.14175], [-117.1696, 33.14194], [-117.16948, 33.14143], [-117.1694, 33.14144], [-117.16913, 33.14075], [-117.16876, 33.14084], [-117.16851, 33.14017], [-117.16966, 33.13987], [-117.17001, 33.14078], [-117.16995, 33.14081], [-117.17031, 33.14175]]]} | Open Access 1 | 47648 | Connors Park | 31392 | 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/151/1081 | San Diego 4 | 4.59 | Connors Park | 2014 | Local Park 2 | 4 |
4197 | 4197 | 4196 | {"type": "Polygon", "coordinates": [[[-117.16467, 33.14461], [-117.16462, 33.14506], [-117.16459, 33.14509], [-117.16454, 33.14511], [-117.16434, 33.14509], [-117.16425, 33.14503], [-117.16417, 33.14501], [-117.16417, 33.1448], [-117.1627, 33.14464], [-117.16275, 33.14424], [-117.16278, 33.14421], [-117.16282, 33.14419], [-117.16332, 33.14424], [-117.16381, 33.14422], [-117.16464, 33.14431], [-117.16468, 33.14433], [-117.1647, 33.14436], [-117.16467, 33.14461]]]} | Open Access 1 | 47686 | Richmar Park | 31423 | 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/406/1126 | San Diego 4 | 2.819 | Richmar Park | 0 | Local Park 2 | 4 |
1430 | 1430 | 1429 | {"type": "Polygon", "coordinates": [[[-117.12984, 33.15135], [-117.1298, 33.15206], [-117.12954, 33.15205], [-117.12957, 33.15153], [-117.12968, 33.1515], [-117.12974, 33.15147], [-117.12984, 33.15135]]]} | Open Access 1 | 47696 | Fulton Community Garden | 31432 | 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.389 | Fulton Community Garden | 0 | Local Park 2 | 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 | 0 | Local Recreation Area 3 | 4 | |
8217 | 8217 | 8216 | {"type": "Polygon", "coordinates": [[[-117.17097, 33.11374], [-117.17037, 33.11403], [-117.16936, 33.1144], [-117.16869, 33.11525], [-117.16869, 33.11589], [-117.1677, 33.11649], [-117.16752, 33.11688], [-117.16683, 33.11688], [-117.16714, 33.11618], [-117.16679, 33.11598], [-117.16555, 33.11598], [-117.16559, 33.11623], [-117.16539, 33.11626], [-117.16533, 33.11598], [-117.16473, 33.11597], [-117.16472, 33.11457], [-117.16443, 33.11428], [-117.16415, 33.11412], [-117.16436, 33.11387], [-117.16443, 33.1135], [-117.16443, 33.11338], [-117.16416, 33.11309], [-117.16432, 33.11292], [-117.16492, 33.11313], [-117.16499, 33.11327], [-117.16616, 33.11328], [-117.16617, 33.11297], [-117.1667, 33.11245], [-117.16671, 33.11222], [-117.16609, 33.1121], [-117.16543, 33.11143], [-117.16572, 33.11127], [-117.16596, 33.11142], [-117.16637, 33.11155], [-117.16697, 33.1115], [-117.16709, 33.11132], [-117.16748, 33.11138], [-117.16788, 33.11159], [-117.16805, 33.11267], [-117.16799, 33.11329], [-117.16876, 33.11329], [-117.16878, 33.11319], [-117.16924, 33.11279], [-117.17009, 33.11237], [-117.16996, 33.11267], [-117.16958, 33.1131], [-117.16954, 33.11329], [-117.16947, 33.1133], [-117.16942, 33.11355], [-117.16966, 33.11366], [-117.17097, 33.11374]], [[-117.16912, 33.11452], [-117.16939, 33.11424], [-117.16972, 33.11406], [-117.16972, 33.11395], [-117.16945, 33.11372], [-117.16928, 33.11338], [-117.16907, 33.11344], [-117.16868, 33.11397], [-117.1683, 33.11424], [-117.16779, 33.11418], [-117.16765, 33.11374], [-117.16769, 33.11329], [-117.16666, 33.11328], [-117.16658, 33.11343], [-117.16583, 33.11369], [-117.1652, 33.11353], [-117.1649, 33.11361], [-117.16487, 33.11397], [-117.16536, 33.11482], [-117.16555, 33.11498], [-117.16593, 33.11491], [-117.16683, 33.11496], [-117.16743, 33.1153], [-117.16849, 33.11523], [-117.16906, 33.11473], [-117.16912, 33.11452]]]} | No Public Access 3 | 47786 | South Lake Park | 31662 | 2170 | Vallecitos Water District 879 | Special District 4 | Water District 13 | http://www.vwd.org/ | Special District 4 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 29.916 | South Lake Park | 0 | Local Park 2 | 4 | |
8218 | 8218 | 8217 | {"type": "MultiPolygon", "coordinates": [[[[-117.15598, 33.10707], [-117.15561, 33.10724], [-117.15541, 33.10729], [-117.15513, 33.10743], [-117.15484, 33.1075], [-117.15451, 33.10766], [-117.15398, 33.10779], [-117.15382, 33.10784], [-117.15357, 33.10796], [-117.15344, 33.10805], [-117.1534, 33.10809], [-117.15337, 33.10818], [-117.1534, 33.10835], [-117.15356, 33.10863], [-117.15377, 33.10915], [-117.15402, 33.10997], [-117.15394, 33.10991], [-117.15386, 33.10987], [-117.15326, 33.10975], [-117.15296, 33.10964], [-117.15283, 33.11018], [-117.15297, 33.11064], [-117.15345, 33.11053], [-117.15394, 33.11036], [-117.15385, 33.11066], [-117.1538, 33.11078], [-117.15369, 33.11096], [-117.15363, 33.111], [-117.15356, 33.11101], [-117.15302, 33.11098], [-117.15136, 33.11131], [-117.15112, 33.11093], [-117.15102, 33.11072], [-117.151, 33.11064], [-117.151, 33.11048], [-117.15098, 33.11037], [-117.15081, 33.10999], [-117.1507, 33.10967], [-117.1507, 33.10956], [-117.15072, 33.10945], [-117.15071, 33.10937], [-117.15038, 33.10894], [-117.15017, 33.10859], [-117.15012, 33.10852], [-117.15003, 33.10847], [-117.14962, 33.10829], [-117.14952, 33.10827], [-117.14942, 33.10828], [-117.14875, 33.10845], [-117.14855, 33.10847], [-117.14838, 33.10846], [-117.14822, 33.10849], [-117.14822, 33.1055], [-117.14954, 33.10548], [-117.1506, 33.10609], [-117.15282, 33.10654], [-117.15402, 33.10642], [-117.15598, 33.10707]]], [[[-117.16972, 33.11406], [-117.16939, 33.11424], [-117.16912, 33.11452], [-117.16906, 33.11473], [-117.16849, 33.11523], [-117.16743, 33.1153], [-117.16683, 33.11496], [-117.16594, 33.11491], [-117.16555, 33.11498], [-117.16536, 33.11482], [-117.16487, 33.11397], [-117.1649, 33.1136], [-117.1652, 33.11353], [-117.16583, 33.11369], [-117.16658, 33.11343], [-117.16665, 33.11328], [-117.1677, 33.11329], [-117.16765, 33.11374], [-117.16779, 33.11418], [-117.1683, 33.11424], [-117.16868, 33.11397], [-117.16907, 33.11344], [-117.16928, 33.11337], [-117.16945, 33.11372], [-117.16972, 33.11395], [-117.16972, 33.11406]]]]} | No Public Access 3 | 47787 | South Lake Mitigation | 31663 | 2170 | Vallecitos Water District 879 | Special District 4 | Water District 13 | http://www.vwd.org/ | Special District 4 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 72.132 | South Lake Mitigation | 0 | Local Other or Unknown 14 | 4 | |
11518 | 11518 | 11517 | {"type": "Polygon", "coordinates": [[[-117.1632, 33.14385], [-117.16316, 33.14408], [-117.16282, 33.14405], [-117.16279, 33.144], [-117.16284, 33.1438], [-117.16288, 33.14375], [-117.16304, 33.14365], [-117.1632, 33.14385]]]} | Open Access 1 | 48229 | Mark J. Noy Jr. Adult Fitness Zone | 32784 | 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 | https://www.san-marcos.net/Home/Components/Calendar/Event/9174/5349 | San Diego 4 | 0.309 | Mark J. Noy Jr. Adult Fitness Zone | 2019 | None 1025 |
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]);