units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where AGNCY_NAME = 159
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
383 | 383 | 382 | {"type": "Polygon", "coordinates": [[[-117.22845, 33.16083], [-117.2284, 33.16177], [-117.22806, 33.16168], [-117.22781, 33.16165], [-117.2276, 33.16165], [-117.22727, 33.16168], [-117.2269, 33.1618], [-117.22586, 33.16235], [-117.22575, 33.16243], [-117.22556, 33.16262], [-117.22544, 33.1628], [-117.22539, 33.16293], [-117.22502, 33.16282], [-117.2247, 33.1628], [-117.2247, 33.16268], [-117.22433, 33.16247], [-117.22399, 33.16224], [-117.22389, 33.16212], [-117.22306, 33.16275], [-117.22263, 33.1626], [-117.22261, 33.1627], [-117.22263, 33.16286], [-117.22269, 33.16302], [-117.22279, 33.16322], [-117.22227, 33.16321], [-117.22228, 33.16316], [-117.2223, 33.16314], [-117.22233, 33.16299], [-117.22231, 33.16284], [-117.22222, 33.1627], [-117.22229, 33.16267], [-117.22298, 33.16109], [-117.2247, 33.16213], [-117.22482, 33.162], [-117.2251, 33.16202], [-117.22563, 33.16191], [-117.22612, 33.1615], [-117.22684, 33.16107], [-117.22733, 33.16138], [-117.22803, 33.16057], [-117.22845, 33.16083]]]} | Open Access 1 | 1148 | Shadowridge Park | 25344 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 12.621 | Shadowridge Park | 0 | Local Park 2 | 4 |
560 | 560 | 559 | {"type": "Polygon", "coordinates": [[[-117.24214, 33.21168], [-117.24226, 33.21186], [-117.24227, 33.21195], [-117.24215, 33.21325], [-117.24212, 33.2134], [-117.24112, 33.21337], [-117.24105, 33.21318], [-117.24104, 33.21265], [-117.24098, 33.21249], [-117.2408, 33.21254], [-117.2407, 33.21228], [-117.24085, 33.21216], [-117.24085, 33.21212], [-117.24155, 33.21197], [-117.24214, 33.21168]]]} | Open Access 1 | 1858 | Townsite Park | 26499 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 4.674 | Townsite Park | 0 | Local Park 2 | 4 |
590 | 590 | 589 | {"type": "MultiPolygon", "coordinates": [[[[-117.27736, 33.20005], [-117.27659, 33.20005], [-117.27657, 33.19878], [-117.27591, 33.19876], [-117.2759, 33.1975], [-117.27735, 33.19751], [-117.27736, 33.19793], [-117.27735, 33.19803], [-117.27736, 33.20005]]], [[[-117.27712, 33.20062], [-117.27712, 33.20091], [-117.27708, 33.20108], [-117.27703, 33.20116], [-117.27688, 33.20129], [-117.2768, 33.2013], [-117.27659, 33.20114], [-117.27659, 33.20062], [-117.27712, 33.20062]]]]} | Open Access 1 | 2007 | Bub Williamson Park | 16465 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 8.047 | Bub Williamson Park | 0 | Local Park 2 | 4 |
1735 | 1735 | 1734 | {"type": "Polygon", "coordinates": [[[-117.23838, 33.21173], [-117.23856, 33.21185], [-117.23857, 33.2119], [-117.23828, 33.21216], [-117.23821, 33.21217], [-117.23734, 33.21166], [-117.23732, 33.21167], [-117.23733, 33.21172], [-117.23731, 33.21171], [-117.2373, 33.21132], [-117.23824, 33.21188], [-117.23838, 33.21173]]]} | Open Access 1 | 12942 | Raintree Park | 24094 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 0.968 | Raintree Park | 0 | Local Park 2 | 4 |
2862 | 2862 | 2861 | {"type": "MultiPolygon", "coordinates": [[[[-117.22617, 33.20984], [-117.22447, 33.21056], [-117.22419, 33.21105], [-117.22304, 33.21187], [-117.22327, 33.21226], [-117.22299, 33.21329], [-117.22306, 33.21334], [-117.22292, 33.21354], [-117.22278, 33.2137], [-117.22273, 33.21374], [-117.22251, 33.21382], [-117.22239, 33.2139], [-117.22185, 33.21442], [-117.22178, 33.21452], [-117.22141, 33.21444], [-117.21999, 33.2146], [-117.21886, 33.21438], [-117.21913, 33.21433], [-117.2193, 33.21442], [-117.21977, 33.21441], [-117.22009, 33.2145], [-117.22026, 33.21443], [-117.2212, 33.21425], [-117.22155, 33.21408], [-117.2217, 33.21404], [-117.2218, 33.21408], [-117.22196, 33.21402], [-117.22216, 33.2139], [-117.22254, 33.21363], [-117.22259, 33.21355], [-117.22278, 33.21334], [-117.22289, 33.21309], [-117.22296, 33.21283], [-117.22296, 33.21266], [-117.22307, 33.21244], [-117.22288, 33.21211], [-117.22157, 33.21212], [-117.22081, 33.2121], [-117.21744, 33.21208], [-117.21744, 33.2114], [-117.21746, 33.21139], [-117.21746, 33.20968], [-117.21822, 33.20818], [-117.21705, 33.20793], [-117.21728, 33.20743], [-117.21733, 33.20744], [-117.21749, 33.20676], [-117.21822, 33.20691], [-117.21879, 33.20596], [-117.21894, 33.20604], [-117.2199, 33.20671], [-117.22312, 33.20886], [-117.22346, 33.2089], [-117.22389, 33.20897], [-117.22505, 33.20907], [-117.22616, 33.20902], [-117.22617, 33.20984]]], [[[-117.21836, 33.21428], [-117.21754, 33.21413], [-117.21746, 33.21397], [-117.21746, 33.21377], [-117.21811, 33.21403], [-117.21836, 33.2141], [-117.21837, 33.21413], [-117.21836, 33.21428]]]]} | Open Access 1 | 1844 | Brengle Terrace Park | 16350 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 85.637 | Brengle Terrace Park | 0 | Local Park 2 | 4 |
3176 | 3176 | 3175 | {"type": "Polygon", "coordinates": [[[-117.2368, 33.20483], [-117.23693, 33.20506], [-117.23694, 33.20515], [-117.23692, 33.20532], [-117.23689, 33.20539], [-117.2366, 33.20577], [-117.2364, 33.20609], [-117.23565, 33.20588], [-117.2361, 33.20519], [-117.2368, 33.20483]]]} | Open Access 1 | 22011 | Wildwood Park | 27523 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 2.222 | Wildwood Park | 0 | Local Park 2 | 4 |
4388 | 4388 | 4387 | {"type": "Polygon", "coordinates": [[[-117.24404, 33.20205], [-117.24397, 33.20207], [-117.2439, 33.20204], [-117.24364, 33.20165], [-117.24364, 33.20161], [-117.24366, 33.20157], [-117.24371, 33.20155], [-117.24404, 33.20205]]]} | Open Access 1 | 45980 | Soroptimist Park | 29147 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.ebidboard.com/docs/1504/280065/COVParkLandscapeMaintenance.pdf | San Diego 4 | 0.158 | Soroptimist Park | 0 | Local Park 2 | 4 |
5397 | 5397 | 5396 | {"type": "Polygon", "coordinates": [[[-117.23649, 33.19126], [-117.23638, 33.19153], [-117.23561, 33.19208], [-117.23554, 33.19207], [-117.23564, 33.19185], [-117.23563, 33.19181], [-117.2356, 33.19177], [-117.23569, 33.19179], [-117.23577, 33.19176], [-117.23598, 33.19124], [-117.23604, 33.19116], [-117.23617, 33.19111], [-117.2363, 33.19111], [-117.23641, 33.19117], [-117.23649, 33.19126]]]} | Open Access 1 | 47902 | Pala Vista Park | 31879 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | https://www.cityofvista.com/services/city-departments/engineering/construction-projects/pala-vista-park | San Diego 4 | 0.924 | Pala Vista Park | 0 | Local Park 2 | 4 |
6143 | 6143 | 6142 | {"type": "MultiPolygon", "coordinates": [[[[-117.2322, 33.14229], [-117.23213, 33.1423], [-117.23079, 33.14226], [-117.23016, 33.14279], [-117.23009, 33.14283], [-117.2299, 33.1429], [-117.22971, 33.14288], [-117.22965, 33.14293], [-117.22956, 33.1429], [-117.22942, 33.14281], [-117.22936, 33.14273], [-117.22838, 33.14284], [-117.22763, 33.14285], [-117.22742, 33.14382], [-117.22664, 33.14584], [-117.22578, 33.14584], [-117.22575, 33.14586], [-117.22578, 33.14672], [-117.22545, 33.14622], [-117.22543, 33.14499], [-117.22545, 33.14498], [-117.22571, 33.14438], [-117.22564, 33.14354], [-117.22553, 33.14314], [-117.22408, 33.14364], [-117.22366, 33.14366], [-117.22358, 33.14375], [-117.22341, 33.14374], [-117.22319, 33.14375], [-117.22294, 33.14384], [-117.22269, 33.14399], [-117.22261, 33.14408], [-117.22254, 33.14418], [-117.22244, 33.14426], [-117.22254, 33.1444], [-117.22213, 33.14452], [-117.22193, 33.14451], [-117.22167, 33.14427], [-117.22102, 33.14438], [-117.22071, 33.14439], [-117.22026, 33.14457], [-117.21977, 33.14473], [-117.21939, 33.14498], [-117.21909, 33.14516], [-117.21864, 33.14481], [-117.21879, 33.14463], [-117.21953, 33.14425], [-117.21971, 33.14417], [-117.21927, 33.1437], [-117.2198, 33.14346], [-117.22013, 33.14311], [-117.22065, 33.14288], [-117.2207, 33.1429], [-117.22156, 33.1426], [-117.22174, 33.14268], [-117.22244, 33.14249], [-117.2225, 33.14252], [-117.22325, 33.1423], [-117.22326, 33.14226], [-117.22301, 33.14137], [-117.22304, 33.14137], [-117.22341, 33.14217], [-117.22355, 33.14222], [-117.22536, 33.14182], [-117.22552, 33.14168], [-117.22571, 33.14182], [-117.22573, 33.14223], [-117.23002, 33.14216], [-117.22998, 33.14032], [-117.23034, 33.14013], [-117.23039, 33.14013], [-117.23078, 33.14048], [-117.23149, 33.14103], [-117.2317, 33.14126], [-117.23193, 33.14159], [-117.23208, 33.14189], [-117.2322, 33.14229]]], [[[-117.24385, 33.13544], [-117.24359, 33.13527], [-117.24107, 33.13527], [-117.24034, 33.13552], [-117.23979, 33.13609], [-117.23808, 33.138], [-117.23711, 33.13816], [-117.23713, 33.13888], [-117.23625, 33.1395], [-117.23444, 33.14101], [-117.23228, 33.14173], [-117.23214, 33.14146], [-117.23193, 33.14116], [-117.2317, 33.14091], [-117.23142, 33.14066], [-117.23315, 33.14025], [-117.2341, 33.13943], [-117.23428, 33.13863], [-117.23426, 33.13694], [-117.23613, 33.13594], [-117.23662, 33.13558], [-117.2372, 33.13568], [-117.23806, 33.13524], [-117.23805, 33.13501], [-117.23859, 33.135], [-117.24377, 33.13497], [-117.24385, 33.13544]]], [[[-117.2461, 33.13659], [-117.24526, 33.13547], [-117.24439, 33.13552], [-117.24438, 33.13503], [-117.24439, 33.13496], [-117.246, 33.13495], [-117.2461, 33.13659]]]]} | Open Access 1 | 1138 | Agua Hedionda Creek | 15293 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 113.24 | Agua Hedionda Creek | 0 | Local Other or Unknown 14 | 4 |
6448 | 6448 | 6447 | {"type": "Polygon", "coordinates": [[[-117.24462, 33.14974], [-117.24442, 33.14974], [-117.2444, 33.14942], [-117.24348, 33.14943], [-117.24348, 33.1496], [-117.24353, 33.14969], [-117.24323, 33.14972], [-117.24305, 33.1498], [-117.24288, 33.14957], [-117.24256, 33.14972], [-117.24225, 33.14977], [-117.24165, 33.14763], [-117.24167, 33.14758], [-117.24169, 33.14756], [-117.24204, 33.14745], [-117.24224, 33.14773], [-117.24274, 33.14773], [-117.2431, 33.14771], [-117.24344, 33.14767], [-117.24372, 33.1476], [-117.24396, 33.14751], [-117.24414, 33.14741], [-117.24441, 33.14714], [-117.24446, 33.14706], [-117.24456, 33.14663], [-117.24458, 33.14662], [-117.24462, 33.14974]]]} | Open Access 1 | 1978 | South Buena Vista Park | 29136 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.ci.vista.ca.us/home/showdocument?id=1170 | San Diego 4 | 14.053 | South Buena Vista Park | 0 | Local Park 2 | 4 |
6449 | 6449 | 6448 | {"type": "Polygon", "coordinates": [[[-117.23029, 33.17171], [-117.22999, 33.17217], [-117.22771, 33.17219], [-117.22771, 33.17147], [-117.22778, 33.17104], [-117.2279, 33.17079], [-117.22811, 33.17043], [-117.22875, 33.17044], [-117.22896, 33.1705], [-117.22918, 33.1706], [-117.22938, 33.17072], [-117.22956, 33.1709], [-117.22963, 33.17102], [-117.22971, 33.17119], [-117.22991, 33.17145], [-117.23008, 33.17159], [-117.23029, 33.17171]]]} | Open Access 1 | 1980 | Thibodo Park | 26301 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 8.775 | Thibodo Park | 0 | Local Park 2 | 4 |
6454 | 6454 | 6453 | {"type": "Polygon", "coordinates": [[[-117.25577, 33.18597], [-117.25573, 33.18666], [-117.25363, 33.18666], [-117.2535, 33.18567], [-117.25577, 33.18597]]]} | Open Access 1 | 1984 | Breeze Hill Park | 16346 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 4.698 | Breeze Hill Park | 0 | Local Park 2 | 4 |
6466 | 6466 | 6465 | {"type": "Polygon", "coordinates": [[[-117.27321, 33.19], [-117.27305, 33.19012], [-117.27292, 33.19077], [-117.27299, 33.19089], [-117.27235, 33.19118], [-117.2714, 33.19154], [-117.26883, 33.19256], [-117.26869, 33.1927], [-117.26711, 33.19335], [-117.26697, 33.19342], [-117.26694, 33.19342], [-117.26676, 33.1935], [-117.26638, 33.19358], [-117.26615, 33.1936], [-117.26629, 33.19355], [-117.26664, 33.19337], [-117.26697, 33.19316], [-117.26841, 33.19181], [-117.26877, 33.19148], [-117.26933, 33.19093], [-117.26955, 33.19073], [-117.26992, 33.19051], [-117.27046, 33.19024], [-117.2708, 33.19001], [-117.27135, 33.18936], [-117.27148, 33.18924], [-117.27166, 33.18908], [-117.27193, 33.18894], [-117.27225, 33.18882], [-117.27306, 33.18867], [-117.27321, 33.19]]]} | Open Access 1 | 2018 | Buena Vista Creek | 16484 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 24.565 | Buena Vista Creek | 0 | Local Other or Unknown 14 | 4 |
7772 | 7772 | 7771 | {"type": "MultiPolygon", "coordinates": [[[[-117.24181, 33.1531], [-117.24157, 33.15477], [-117.24103, 33.15465], [-117.24011, 33.15443], [-117.23977, 33.1544], [-117.23943, 33.15443], [-117.23913, 33.15449], [-117.23886, 33.15459], [-117.23805, 33.15504], [-117.23768, 33.15519], [-117.23643, 33.15551], [-117.23557, 33.15556], [-117.23476, 33.15575], [-117.2344, 33.15578], [-117.23438, 33.15308], [-117.23872, 33.15306], [-117.23868, 33.15112], [-117.23964, 33.15112], [-117.23971, 33.15153], [-117.24025, 33.15187], [-117.2404, 33.15165], [-117.24043, 33.15167], [-117.24028, 33.1519], [-117.24046, 33.15201], [-117.24049, 33.15202], [-117.2402, 33.15284], [-117.24043, 33.1531], [-117.24081, 33.15331], [-117.24103, 33.15331], [-117.24112, 33.1531], [-117.24181, 33.1531]], [[-117.23902, 33.15372], [-117.23903, 33.15371], [-117.23898, 33.15342], [-117.23861, 33.15346], [-117.23866, 33.15376], [-117.23902, 33.15372]]], [[[-117.24845, 33.15757], [-117.24813, 33.15766], [-117.24782, 33.15777], [-117.24752, 33.15792], [-117.24725, 33.15808], [-117.24699, 33.15827], [-117.24676, 33.15847], [-117.24655, 33.1587], [-117.24608, 33.15926], [-117.24576, 33.15956], [-117.24552, 33.15973], [-117.24524, 33.1599], [-117.24498, 33.16004], [-117.24471, 33.16016], [-117.24469, 33.15742], [-117.24413, 33.15763], [-117.24405, 33.1575], [-117.24393, 33.15739], [-117.24403, 33.15731], [-117.24402, 33.15677], [-117.24171, 33.15678], [-117.24241, 33.15172], [-117.24245, 33.15121], [-117.24243, 33.1507], [-117.24277, 33.15068], [-117.24341, 33.15037], [-117.24314, 33.14994], [-117.24335, 33.14987], [-117.24364, 33.14985], [-117.2441, 33.15058], [-117.24389, 33.15068], [-117.2428, 33.1508], [-117.24324, 33.15203], [-117.2473, 33.15188], [-117.24741, 33.15314], [-117.24722, 33.15314], [-117.24721, 33.15315], [-117.24745, 33.15677], [-117.2482, 33.15678], [-117.24845, 33.15757]], [[-117.24785, 33.15725], [-117.24772, 33.1573], [-117.24779, 33.15742], [-117.24769, 33.15748], [-117.24775, 33.15759], [-117.24799, 33.15749], [-117.24785, 33.15725]]], [[[-117.24736, 33.16176], [-117.24736, 33.16243], [-117.24402, 33.16245], [-117.24399, 33.1621], [-117.24405, 33.16206], [-117.24405, 33.1619], [-117.24411, 33.16187], [-117.24414, 33.16183], [-117.24471, 33.16182], [-117.24471, 33.16176], [-117.24736, 33.16176]]]]} | Open Access 1 | 47651 | Buena Vista Park | 16496 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.ci.vista.ca.us/home/showdocument?id=1170 | San Diego 4 | 137.724 | Buena Vista Park | 0 | Local Park 2 | 4 |
7800 | 7800 | 7799 | {"type": "Polygon", "coordinates": [[[-117.26035, 33.22616], [-117.26007, 33.22644], [-117.25999, 33.22659], [-117.25995, 33.22662], [-117.25982, 33.22667], [-117.25975, 33.22672], [-117.25957, 33.22701], [-117.25934, 33.2272], [-117.25916, 33.22739], [-117.25895, 33.22757], [-117.25893, 33.22763], [-117.25894, 33.22773], [-117.25893, 33.22786], [-117.25888, 33.22796], [-117.25882, 33.22802], [-117.25855, 33.22815], [-117.25846, 33.22823], [-117.25836, 33.2283], [-117.25833, 33.22825], [-117.25598, 33.22639], [-117.25712, 33.22493], [-117.25715, 33.22502], [-117.25723, 33.22508], [-117.25734, 33.22508], [-117.25742, 33.22502], [-117.25745, 33.22497], [-117.25739, 33.22483], [-117.25725, 33.22476], [-117.2574, 33.22457], [-117.26035, 33.22616]]]} | Open Access 1 | 47695 | Vista Sports Park | 31431 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | https://gis.cityofvista.com/vistaparks/ | San Diego 4 | 20.867 | Vista Sports Park | 0 | Local Recreation Area 3 | 4 |
7825 | 7825 | 7824 | {"type": "MultiPolygon", "coordinates": [[[[-117.24471, 33.16016], [-117.24441, 33.1603], [-117.24417, 33.16044], [-117.24361, 33.16085], [-117.24323, 33.16107], [-117.24282, 33.16124], [-117.24229, 33.1614], [-117.24222, 33.1614], [-117.24219, 33.16137], [-117.24208, 33.16097], [-117.24272, 33.1611], [-117.243, 33.16098], [-117.2447, 33.15982], [-117.24471, 33.16016]]], [[[-117.2461, 33.1596], [-117.24504, 33.16176], [-117.24472, 33.16176], [-117.24472, 33.16182], [-117.24414, 33.16183], [-117.24411, 33.16187], [-117.24405, 33.1619], [-117.24405, 33.16205], [-117.24399, 33.16211], [-117.24402, 33.16245], [-117.2441, 33.16245], [-117.24411, 33.16261], [-117.2434, 33.16292], [-117.24314, 33.16273], [-117.24291, 33.16251], [-117.2427, 33.16228], [-117.24252, 33.16204], [-117.2423, 33.16165], [-117.2423, 33.16161], [-117.24232, 33.16157], [-117.24304, 33.16134], [-117.24347, 33.16114], [-117.24373, 33.16098], [-117.24432, 33.16055], [-117.24471, 33.16035], [-117.2453, 33.16012], [-117.24547, 33.16004], [-117.24578, 33.15985], [-117.2461, 33.1596]]]]} | Open Access 1 | 47694 | Buena Vista Park Ballfields | 31430 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 12.951 | Buena Vista Park Ballfields | 0 | None 653 | |
8363 | 8363 | 8362 | {"type": "Polygon", "coordinates": [[[-117.24754, 33.19862], [-117.24753, 33.19874], [-117.24749, 33.19888], [-117.24742, 33.199], [-117.24733, 33.19912], [-117.24722, 33.19922], [-117.24617, 33.19997], [-117.24613, 33.2001], [-117.24596, 33.20007], [-117.24584, 33.2], [-117.24565, 33.19983], [-117.24565, 33.19975], [-117.2456, 33.19969], [-117.24553, 33.19964], [-117.24543, 33.19963], [-117.24523, 33.19937], [-117.24517, 33.1994], [-117.24506, 33.19923], [-117.24532, 33.19915], [-117.24527, 33.19897], [-117.24501, 33.19902], [-117.24493, 33.1988], [-117.24507, 33.19876], [-117.24536, 33.19858], [-117.24541, 33.19832], [-117.24545, 33.1983], [-117.24553, 33.19827], [-117.2457, 33.1984], [-117.24596, 33.19841], [-117.24597, 33.19839], [-117.24617, 33.1984], [-117.24631, 33.19835], [-117.24632, 33.19814], [-117.24658, 33.19812], [-117.24684, 33.19804], [-117.24697, 33.19797], [-117.24694, 33.19792], [-117.24715, 33.19777], [-117.24754, 33.19792], [-117.24746, 33.19815], [-117.24744, 33.19838], [-117.24744, 33.19846], [-117.2475, 33.19846], [-117.24754, 33.19862]], [[-117.24679, 33.19854], [-117.24679, 33.19852], [-117.24654, 33.19843], [-117.24629, 33.19853], [-117.24626, 33.19856], [-117.24629, 33.1986], [-117.24634, 33.1986], [-117.2464, 33.19869], [-117.24679, 33.19854]]]} | Open Access 1 | 12959 | Wave Waterpark | 29135 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.ci.vista.ca.us/services/facility-rentals | San Diego 4 | 8.392 | Wave Waterpark | None 699 | ||
17023 | 17023 | 17022 | {"type": "Polygon", "coordinates": [[[-117.23516, 33.20398], [-117.2347, 33.20423], [-117.23438, 33.20391], [-117.23431, 33.20367], [-117.23415, 33.20336], [-117.23382, 33.20317], [-117.23319, 33.20309], [-117.23308, 33.20329], [-117.23293, 33.20312], [-117.23259, 33.20288], [-117.2323, 33.20278], [-117.23192, 33.20276], [-117.2321, 33.20221], [-117.23237, 33.20244], [-117.23319, 33.20271], [-117.2334, 33.20269], [-117.23376, 33.20281], [-117.23402, 33.20279], [-117.23406, 33.20295], [-117.2342, 33.20294], [-117.23423, 33.20304], [-117.23436, 33.20302], [-117.23441, 33.20304], [-117.23458, 33.20312], [-117.2347, 33.20322], [-117.23465, 33.20338], [-117.23464, 33.20356], [-117.23466, 33.20364], [-117.23471, 33.20374], [-117.23483, 33.2037], [-117.23486, 33.20375], [-117.235, 33.20369], [-117.23516, 33.20398]]]} | Open Access 1 | 12927 | Civic Center Park | 17366 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 3.873 | Civic Ctr. Park | 0 | Local Park 2 | 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]);