units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where DES_TP = 2, MNG_AGENCY = 155 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
MNG_AG_TYP 1
- City Agency · 13 ✖
MNG_AGENCY 1
- Vista, City of · 13 ✖
DES_TP 1
- Local Park · 13 ✖
ACCESS_TYP 1
- Open Access 13
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 |
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 |
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 |
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]);