units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
646 rows where COUNTY = 4 and DES_TP = 2 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_ID, YR_EST
MNG_AGENCY 25
- San Diego, City of 281
- San Diego, County of 68
- Chula Vista, City of 60
- Oceanside, City of 28
- Carlsbad, City of 23
- San Marcos, City of 21
- Encinitas, City of 19
- Coronado, City of 17
- San Diego Unified Port District 17
- Escondido, City of 16
- La Mesa, City of 14
- Poway, City of 13
- Vista, City of 13
- El Cajon, City of 12
- Santee, City of 10
- National City, City of 6
- Lemon Grove, City of 6
- Del Mar, City of 5
- Imperial Beach, City of 5
- Solana Beach, City of 3
- Valley Center Parks and Recreation 3
- Helix Water District 2
- San Dieguito River Park Joint Powers Authority 2
- Ramona Municipal Water District 1
- Padre Dam Municipal Water District 1
MNG_AG_TYP 6
ACCESS_TYP 3
- Open Access 626
- Restricted Access 11
- No Public Access 9
DES_TP 1
- Local Park · 646 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13727 | 13727 | 13726 | {"type": "Polygon", "coordinates": [[[-117.10185, 32.75039], [-117.10185, 32.75069], [-117.10169, 32.75069], [-117.10169, 32.75039], [-117.10185, 32.75039]]]} | Open Access 1 | 48831 | City Heights Square Mini Park | 33550 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.123 | City Heights Square MP | 0 | Local Park 2 | 4 | |
13700 | 13700 | 13699 | {"type": "Polygon", "coordinates": [[[-117.10891, 32.76431], [-117.10845, 32.76431], [-117.10847, 32.76337], [-117.10865, 32.76342], [-117.10891, 32.76431]]]} | Open Access 1 | 48830 | Terrace Drive Mini Park | 33549 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/sites/default/files/adams.pdf | San Diego 4 | 0.759 | Terrace Drive MP | 0 | Local Park 2 | 4 |
11519 | 11519 | 11518 | {"type": "Polygon", "coordinates": [[[-117.15865, 32.90484], [-117.15766, 32.9055], [-117.15764, 32.9055], [-117.15694, 32.90501], [-117.15673, 32.90517], [-117.15582, 32.90455], [-117.15595, 32.90437], [-117.15623, 32.90451], [-117.15631, 32.9044], [-117.15716, 32.90483], [-117.15808, 32.90422], [-117.15865, 32.90484]]]} | Open Access 1 | 48230 | Salk Neighborhood Park | 30831 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.974 | Salk Neighborhood 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 |
2241 | 2241 | 2240 | {"type": "Polygon", "coordinates": [[[-117.00327, 32.84388], [-117.00321, 32.84396], [-117.00231, 32.84396], [-117.00229, 32.84395], [-117.00136, 32.84412], [-117.00137, 32.8442], [-117.00036, 32.84439], [-117.00032, 32.84432], [-116.99873, 32.84483], [-116.99875, 32.8449], [-116.99829, 32.845], [-116.99814, 32.84466], [-116.99705, 32.84193], [-116.9988, 32.84171], [-116.99935, 32.84157], [-116.99968, 32.84165], [-117.00072, 32.84155], [-117.0017, 32.84133], [-117.00257, 32.84084], [-117.00262, 32.84057], [-117.0026, 32.8399], [-117.00308, 32.83962], [-117.00312, 32.83966], [-117.00312, 32.84055], [-117.00316, 32.84248], [-117.00327, 32.84388]]]} | Open Access 1 | 47897 | Mast Park West | 31858 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | San Diego 4 | 43.439 | Mast Park West | 0 | Local Park 2 | 4 | |
9773 | 9773 | 9772 | {"type": "Polygon", "coordinates": [[[-117.08652, 32.67007], [-117.08573, 32.67028], [-117.08584, 32.67017], [-117.08587, 32.6701], [-117.08587, 32.66994], [-117.08585, 32.66973], [-117.08582, 32.66962], [-117.08566, 32.66932], [-117.08549, 32.66885], [-117.08548, 32.6687], [-117.08549, 32.6686], [-117.08555, 32.6685], [-117.0856, 32.66846], [-117.08577, 32.66839], [-117.08586, 32.66839], [-117.08652, 32.67007]]]} | Open Access 1 | 47892 | Butterfly Park | 31840 | 1219 | National City, City of 51 | City 2 | City Agency 2 | http://www.ci.national-city.ca.us/index.aspx?page=152 | City 2 | 1219 | National City, City of 49 | City 2 | City Agency 2 | San Diego 4 | 2.413 | Butterfly Park | 0 | Local Park 2 | 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 | |
8018 | 8018 | 8017 | {"type": "Polygon", "coordinates": [[[-117.07726, 32.82341], [-117.07515, 32.82374], [-117.07514, 32.82348], [-117.07463, 32.82217], [-117.07561, 32.82194], [-117.07704, 32.82323], [-117.07726, 32.82341]]]} | Open Access 1 | 47737 | Camp Elliott Neighborhood Park | 31540 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 6.611 | Camp Elliott Neighborhood Park | 0 | Local Park 2 | 4 | |
8009 | 8009 | 8008 | {"type": "Polygon", "coordinates": [[[-117.21811, 32.87657], [-117.21809, 32.87661], [-117.218, 32.87664], [-117.21696, 32.87666], [-117.21654, 32.87677], [-117.2164, 32.87634], [-117.21541, 32.87589], [-117.21425, 32.87618], [-117.21425, 32.87547], [-117.21431, 32.87534], [-117.21436, 32.87529], [-117.21448, 32.87522], [-117.21463, 32.87518], [-117.21746, 32.87517], [-117.21749, 32.87594], [-117.21811, 32.8764], [-117.21811, 32.87657]]]} | Open Access 1 | 47736 | Weiss Mandell Eastgate Neighborhood Park | 31539 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.754 | Weiss Mandell Eastgate Neighborhood Park | 0 | Local Park 2 | 4 | |
8008 | 8008 | 8007 | {"type": "Polygon", "coordinates": [[[-117.16727, 32.71112], [-117.16654, 32.71073], [-117.16629, 32.71062], [-117.16603, 32.71054], [-117.16572, 32.71049], [-117.16572, 32.7102], [-117.16725, 32.71103], [-117.16727, 32.71112]]]} | Open Access 1 | 47735 | King, Jr. Promenade Park | 31538 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.483 | King, Jr. Promenade Park | 0 | Local Park 2 | 4 | |
7807 | 7807 | 7806 | {"type": "Polygon", "coordinates": [[[-117.11293, 32.81673], [-117.11252, 32.81766], [-117.11164, 32.81742], [-117.11146, 32.81776], [-117.11149, 32.81779], [-117.11054, 32.81797], [-117.11042, 32.81793], [-117.11036, 32.81787], [-117.11033, 32.81791], [-117.11028, 32.81791], [-117.1101, 32.81788], [-117.11003, 32.81789], [-117.10987, 32.81794], [-117.10979, 32.818], [-117.10978, 32.81808], [-117.10942, 32.81814], [-117.10938, 32.8178], [-117.11012, 32.81739], [-117.11026, 32.81733], [-117.11059, 32.81724], [-117.11189, 32.81656], [-117.11264, 32.81638], [-117.11273, 32.81639], [-117.11284, 32.81645], [-117.11287, 32.81651], [-117.11285, 32.81659], [-117.11293, 32.81673]]]} | Open Access 1 | 47732 | Damato Park | 31533 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 6.967 | Damato Park | 0 | Local Park 2 | 4 | |
7643 | 7643 | 7642 | {"type": "Polygon", "coordinates": [[[-117.16198, 32.71308], [-117.16185, 32.71308], [-117.16185, 32.71266], [-117.16198, 32.71267], [-117.16198, 32.71308]]]} | Open Access 1 | 47731 | G Street Mini Park | 31532 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.138 | G Street MP | 0 | Local Park 2 | 4 | |
7864 | 7864 | 7863 | {"type": "MultiPolygon", "coordinates": [[[[-116.92777, 32.58949], [-116.92777, 32.59228], [-116.92719, 32.59236], [-116.92709, 32.59253], [-116.92678, 32.59284], [-116.92635, 32.59308], [-116.92611, 32.59314], [-116.92622, 32.59232], [-116.92562, 32.59183], [-116.92563, 32.5918], [-116.92293, 32.5893], [-116.92211, 32.58875], [-116.92204, 32.58879], [-116.92131, 32.58828], [-116.91987, 32.58695], [-116.91737, 32.58824], [-116.91724, 32.58868], [-116.91579, 32.58965], [-116.91571, 32.59019], [-116.91743, 32.59146], [-116.92026, 32.59141], [-116.92062, 32.59165], [-116.92179, 32.59313], [-116.92285, 32.59318], [-116.92318, 32.59348], [-116.92371, 32.5935], [-116.92369, 32.59353], [-116.92526, 32.595], [-116.92514, 32.59515], [-116.92556, 32.59554], [-116.92582, 32.59535], [-116.92587, 32.59561], [-116.92593, 32.59573], [-116.92601, 32.59583], [-116.92635, 32.59609], [-116.9266, 32.5963], [-116.92681, 32.59658], [-116.92695, 32.59689], [-116.91079, 32.59702], [-116.9107, 32.59326], [-116.9129, 32.59324], [-116.91243, 32.59374], [-116.91342, 32.59443], [-116.91457, 32.59326], [-116.91516, 32.59328], [-116.91548, 32.5923], [-116.91619, 32.5921], [-116.91584, 32.59121], [-116.91508, 32.59097], [-116.91467, 32.59137], [-116.9128, 32.59139], [-116.91275, 32.58957], [-116.91061, 32.58958], [-116.91052, 32.58587], [-116.91906, 32.5858], [-116.92128, 32.5858], [-116.92129, 32.58715], [-116.92666, 32.58812], [-116.92777, 32.58949]]], [[[-116.92994, 32.59688], [-116.92778, 32.59688], [-116.92778, 32.59585], [-116.92807, 32.5955], [-116.92806, 32.59492], [-116.92993, 32.59491], [-116.92994, 32.59688]]], [[[-116.98385, 32.58252], [-116.97937, 32.58383], [-116.97937, 32.58383], [-116.97936, 32.5825], [-116.98385, 32.58252]]]]} | No Public Access 3 | 47717 | Otay Valley Regional Park | 31497 | 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.ovrp.org/ | San Diego 4 | 324.329 | Otay Valley RP | 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 | |
4198 | 4198 | 4197 | {"type": "Polygon", "coordinates": [[[-117.03223, 33.15748], [-117.03217, 33.15759], [-117.0322, 33.15761], [-117.03147, 33.15902], [-117.03133, 33.15897], [-117.03144, 33.15869], [-117.0315, 33.15844], [-117.03159, 33.15746], [-117.03223, 33.15748]]]} | Open Access 1 | 47689 | Mayflower Dog Park | 31425 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/mayflower-dog-park.aspx | San Diego 4 | 1.445 | Mayflower Dog Park | 0 | 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 |
4194 | 4194 | 4193 | {"type": "Polygon", "coordinates": [[[-117.06893, 32.60036], [-117.06893, 32.60105], [-117.06677, 32.60104], [-117.06677, 32.60035], [-117.06893, 32.60036]]]} | Open Access 1 | 47683 | Orange Park | 31420 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/orange-park | San Diego 4 | 3.796 | Orange Park | 0 | Local Park 2 | 4 |
7764 | 7764 | 7763 | {"type": "Polygon", "coordinates": [[[-117.05995, 32.79051], [-117.05985, 32.79091], [-117.05962, 32.79212], [-117.05724, 32.792], [-117.05709, 32.79219], [-117.05701, 32.79214], [-117.05719, 32.79191], [-117.05734, 32.79033], [-117.05995, 32.79051]]]} | Open Access 1 | 47663 | Pasatiempo Neighborhood Park | 31403 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 10.697 | Pasatiempo Neighborhood Park | 0 | Local Park 2 | 4 | |
7632 | 7632 | 7631 | {"type": "Polygon", "coordinates": [[[-117.09477, 32.73317], [-117.09468, 32.73326], [-117.09471, 32.73329], [-117.09294, 32.73506], [-117.09199, 32.73506], [-117.09262, 32.73397], [-117.09333, 32.73319], [-117.09477, 32.73317]]]} | Open Access 1 | 47653 | Charles L. Lewis III Memorial Park | 31396 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 6.224 | Charles L. Lewis III Memorial 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 |
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]);