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 AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, MNG_AG_LEV, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13224 | 13224 | 13223 | {"type": "MultiPolygon", "coordinates": [[[[-117.09269, 32.55829], [-117.09263, 32.56415], [-117.09055, 32.56414], [-117.09051, 32.56369], [-117.08947, 32.56369], [-117.08949, 32.56007], [-117.09055, 32.56006], [-117.09056, 32.55828], [-117.09269, 32.55829]]], [[[-117.10137, 32.56011], [-117.10133, 32.56544], [-117.09793, 32.56548], [-117.0971, 32.56548], [-117.09709, 32.56469], [-117.09388, 32.56469], [-117.09387, 32.56424], [-117.09282, 32.56424], [-117.09285, 32.55829], [-117.09377, 32.55829], [-117.09567, 32.559], [-117.09568, 32.55829], [-117.09604, 32.55829], [-117.09604, 32.55914], [-117.09819, 32.55915], [-117.09819, 32.55956], [-117.09926, 32.55957], [-117.09926, 32.56009], [-117.10137, 32.56011]]]]} | Open Access 1 | 45246 | Tijuana River Valley Regional Park | 13879 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 169.576 | Tijuana River Valley RP | 0 | Local Park 2 | 4 |
4007 | 4007 | 4006 | {"type": "MultiPolygon", "coordinates": [[[[-117.14406, 32.70147], [-117.1438, 32.70178], [-117.14126, 32.70002], [-117.14133, 32.6999], [-117.14168, 32.70003], [-117.14184, 32.70014], [-117.14214, 32.70029], [-117.14239, 32.70037], [-117.14245, 32.70033], [-117.14406, 32.70147]]], [[[-117.14441, 32.70113], [-117.14421, 32.70131], [-117.14265, 32.70025], [-117.14169, 32.69956], [-117.14176, 32.69951], [-117.14179, 32.69934], [-117.14203, 32.69909], [-117.14229, 32.69886], [-117.1439, 32.7], [-117.14382, 32.70008], [-117.14379, 32.70022], [-117.14379, 32.70042], [-117.14375, 32.70045], [-117.14383, 32.70053], [-117.14392, 32.70058], [-117.14392, 32.70062], [-117.14396, 32.70074], [-117.14401, 32.70083], [-117.14441, 32.70113]]]]} | Open Access 1 | 46820 | Chicano Park | 17188 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.609 | Chicano Park | 0 | Local Park 2 | 4 | |
13167 | 13167 | 13166 | {"type": "MultiPolygon", "coordinates": [[[[-117.06575, 32.85148], [-117.06108, 32.85142], [-117.05338, 32.85136], [-117.05338, 32.85293], [-117.05221, 32.8528], [-117.05147, 32.85255], [-117.05108, 32.852], [-117.05061, 32.85144], [-117.0501, 32.85094], [-117.0495, 32.85046], [-117.04913, 32.8502], [-117.04868, 32.84993], [-117.04767, 32.84943], [-117.04769, 32.84785], [-117.06406, 32.84798], [-117.06575, 32.85148]]], [[[-117.05339, 32.85425], [-117.0534, 32.85544], [-117.05338, 32.85558], [-117.05244, 32.8541], [-117.05339, 32.85425]]]]} | Open Access 1 | 45149 | Mission Trails Regional Park | 29248 | 221 | San Diego State University 1047 | State 5 | State Agency 5 | http://www.sdsu.edu/ | Other State 5 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.mtrp.org/ | San Diego 4 | 155.468 | Mission Trails RP | 0 | Local Park 2 | 4 |
254 | 254 | 253 | {"type": "Polygon", "coordinates": [[[-117.30173, 33.05629], [-117.30148, 33.05638], [-117.3014, 33.05627], [-117.30138, 33.05619], [-117.30167, 33.05611], [-117.30173, 33.05629]]]} | Open Access 1 | 704 | Seaside Gardens County Park | 25250 | 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 | San Diego 4 | 0.15 | Seaside Gardens County Park | 0 | Local Park 2 | 4 | |
433 | 433 | 432 | {"type": "Polygon", "coordinates": [[[-116.59781, 32.61496], [-116.59778, 32.61691], [-116.592, 32.61684], [-116.59195, 32.61847], [-116.58772, 32.61842], [-116.58772, 32.61307], [-116.59204, 32.61313], [-116.59203, 32.6113], [-116.59613, 32.61131], [-116.59619, 32.61494], [-116.59781, 32.61496]]]} | Open Access 1 | 836 | Potrero Park | 23926 | 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.sdparks.org/content/sdparks/en/park-pages/Potrero.html | San Diego 4 | 126.277 | Potrero Park | 0 | Local Park 2 | 4 |
575 | 575 | 574 | {"type": "Polygon", "coordinates": [[[-116.55091, 32.68226], [-116.5509, 32.68904], [-116.54671, 32.68903], [-116.54666, 32.69624], [-116.54247, 32.69617], [-116.54246, 32.69264], [-116.53813, 32.69259], [-116.53815, 32.68901], [-116.53404, 32.68893], [-116.53398, 32.69617], [-116.53815, 32.6962], [-116.53809, 32.71037], [-116.53398, 32.71042], [-116.53382, 32.71605], [-116.53385, 32.72189], [-116.52947, 32.72189], [-116.52952, 32.72556], [-116.52511, 32.72556], [-116.5252, 32.71823], [-116.52073, 32.71818], [-116.52069, 32.71598], [-116.52077, 32.71459], [-116.51671, 32.71461], [-116.5166, 32.70729], [-116.50784, 32.70735], [-116.50786, 32.71104], [-116.50351, 32.71109], [-116.5035, 32.71481], [-116.49896, 32.71499], [-116.4951, 32.71505], [-116.4951, 32.71112], [-116.49937, 32.71107], [-116.49957, 32.6966], [-116.50366, 32.69661], [-116.50364, 32.70018], [-116.50784, 32.70019], [-116.508, 32.69288], [-116.51156, 32.6929], [-116.51245, 32.69289], [-116.51259, 32.68983], [-116.51262, 32.68937], [-116.51405, 32.68937], [-116.51423, 32.68936], [-116.51428, 32.6885], [-116.51487, 32.68809], [-116.51478, 32.68764], [-116.51501, 32.68738], [-116.515, 32.68715], [-116.51517, 32.68685], [-116.51506, 32.68635], [-116.51528, 32.68609], [-116.51576, 32.68605], [-116.51581, 32.68607], [-116.51608, 32.68574], [-116.51671, 32.68596], [-116.51671, 32.68474], [-116.51678, 32.68255], [-116.51675, 32.68254], [-116.51675, 32.68218], [-116.52375, 32.68219], [-116.52543, 32.68216], [-116.52542, 32.67813], [-116.53399, 32.67817], [-116.534, 32.67113], [-116.53823, 32.67113], [-116.5382, 32.67463], [-116.54239, 32.67461], [-116.54239, 32.67817], [-116.54667, 32.67819], [-116.5467, 32.68224], [-116.55091, 32.68226]], [[-116.534, 32.67817], [-116.53399, 32.67818], [-116.53399, 32.68219], [-116.53814, 32.68223], [-116.53816, 32.6782], [-116.534, 32.67817]]]} | Open Access 1 | 3446 | Lake Morena County Park | 10398 | 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.sdparks.org/content/sdparks/en/park-pages/LakeMorena.html | San Diego 4 | 3278.988 | Lake Morena County Park | 0 | Local Park 2 | 4 |
601 | 601 | 600 | {"type": "Polygon", "coordinates": [[[-116.86232, 33.04283], [-116.86091, 33.04362], [-116.85968, 33.04204], [-116.8611, 33.04126], [-116.86164, 33.04196], [-116.86161, 33.04199], [-116.86171, 33.04211], [-116.86175, 33.04209], [-116.86232, 33.04283]]]} | Open Access 1 | 4174 | Collier Park | 17519 | 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.sdparks.org/content/sdparks/en/park-pages/Collier.html | San Diego 4 | 8.145 | Collier Park | 0 | Local Park 2 | 4 |
677 | 677 | 676 | {"type": "Polygon", "coordinates": [[[-117.0076, 32.7182], [-117.00574, 32.7182], [-117.00573, 32.71601], [-117.00759, 32.71601], [-117.0076, 32.7182]]]} | Open Access 1 | 5123 | Sweetwater Lane County Park | 29258 | 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.sdparks.org/content/sdparks/en/park-pages/SweetwaterLane.html | San Diego 4 | 10.435 | Sweetwater Lane County Park | 0 | Local Park 2 | 4 |
761 | 761 | 760 | {"type": "Polygon", "coordinates": [[[-117.2805, 33.06873], [-117.28049, 33.07082], [-117.2805, 33.07144], [-117.27943, 33.07144], [-117.27942, 33.07234], [-117.27801, 33.07234], [-117.27792, 33.07143], [-117.27683, 33.07143], [-117.27656, 33.06872], [-117.2805, 33.06873]]]} | Open Access 1 | 4959 | Magdalena Ecke Park | 21667 | 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 | San Diego 4 | 29.785 | Magdalena Ecke Park | 0 | Local Park 2 | 4 | |
763 | 763 | 762 | {"type": "Polygon", "coordinates": [[[-117.00133, 32.74581], [-117.00084, 32.74581], [-117.00081, 32.74585], [-117.00087, 32.74595], [-117.00053, 32.74629], [-117.00034, 32.74616], [-117.00008, 32.74645], [-116.99996, 32.74633], [-116.99954, 32.74618], [-116.99953, 32.74531], [-117.00019, 32.74531], [-117.0002, 32.74539], [-117.00067, 32.74538], [-117.00066, 32.74515], [-117.00083, 32.74497], [-117.00083, 32.74462], [-117.00132, 32.74461], [-117.00133, 32.74581]]]} | Open Access 1 | 4973 | Bancroft Park | 15792 | 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.sdparks.org/content/sdparks/en/park-pages/Bancroft.html | San Diego 4 | 4.676 | Bancroft Park | 0 | Local Park 2 | 4 |
802 | 802 | 801 | {"type": "Polygon", "coordinates": [[[-117.15085, 33.41386], [-117.14988, 33.41386], [-117.14987, 33.41211], [-117.15083, 33.4121], [-117.15085, 33.41386]]]} | Open Access 1 | 5212 | Rainbow Park | 24087 | 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.sdparks.org/content/sdparks/en/park-pages/Rainbow.html | San Diego 4 | 4.328 | Rainbow Park | 0 | Local Park 2 | 4 |
811 | 811 | 810 | {"type": "MultiPolygon", "coordinates": [[[[-117.2369, 32.9958], [-117.23453, 32.99563], [-117.2341, 32.99565], [-117.23297, 32.99578], [-117.23256, 32.99581], [-117.23056, 32.99574], [-117.23036, 32.99575], [-117.23007, 32.99581], [-117.22987, 32.99588], [-117.22968, 32.99599], [-117.22933, 32.99552], [-117.22974, 32.99535], [-117.23001, 32.99528], [-117.23031, 32.99523], [-117.23045, 32.99524], [-117.23061, 32.99523], [-117.23062, 32.99521], [-117.23239, 32.99532], [-117.23242, 32.9953], [-117.23269, 32.99532], [-117.23396, 32.99517], [-117.23465, 32.99513], [-117.23542, 32.99532], [-117.23645, 32.99554], [-117.23678, 32.99567], [-117.2369, 32.9958]]], [[[-117.23859, 32.99818], [-117.23857, 33.00045], [-117.23843, 33.00087], [-117.23822, 33.00122], [-117.23805, 33.00137], [-117.2379, 33.00146], [-117.23668, 33.00197], [-117.23657, 33.00202], [-117.23624, 33.00226], [-117.23614, 33.00236], [-117.23599, 33.00256], [-117.23589, 33.00275], [-117.23581, 33.00295], [-117.23568, 33.0035], [-117.23558, 33.00372], [-117.23543, 33.00395], [-117.23535, 33.00396], [-117.23417, 33.00243], [-117.23417, 33.00241], [-117.23399, 33.00224], [-117.22959, 32.99637], [-117.22976, 32.99622], [-117.22997, 32.99609], [-117.2302, 32.99601], [-117.23041, 32.99596], [-117.23053, 32.99595], [-117.23227, 32.99602], [-117.2326, 32.99602], [-117.23311, 32.99599], [-117.23416, 32.99587], [-117.23453, 32.99585], [-117.23651, 32.99599], [-117.23674, 32.99602], [-117.23695, 32.99611], [-117.23709, 32.99619], [-117.23725, 32.99635], [-117.2373, 32.9964], [-117.23772, 32.99729], [-117.23782, 32.99744], [-117.23808, 32.99773], [-117.23859, 32.99818]]], [[[-117.2386, 32.99605], [-117.2386, 32.99605], [-117.23859, 32.99794], [-117.2382, 32.9976], [-117.23798, 32.99734], [-117.23783, 32.99709], [-117.23749, 32.99637], [-117.23737, 32.99619], [-117.23723, 32.99603], [-117.2386, 32.99605]]]]} | Open Access 1 | 5234 | San Dieguito Park | 24867 | 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.sdparks.org/content/sdparks/en/park-pages/SanDieguito.html | San Diego 4 | 119.501 | San Dieguito Park | 0 | Local Park 2 | 4 |
819 | 819 | 818 | {"type": "Polygon", "coordinates": [[[-117.25791, 33.37491], [-117.25791, 33.37556], [-117.25754, 33.37556], [-117.25754, 33.3752], [-117.25724, 33.37489], [-117.25791, 33.37491]]]} | Open Access 1 | 5304 | Don Dussault Park | 18203 | 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.sdparks.org/content/sdparks/en/park-pages/DonDussault.html | San Diego 4 | 0.746 | Don Dussault Park | 0 | Local Park 2 | 4 |
828 | 828 | 827 | {"type": "Polygon", "coordinates": [[[-116.60586, 33.035], [-116.60569, 33.04233], [-116.60489, 33.0424], [-116.60129, 33.04245], [-116.60127, 33.04251], [-116.60002, 33.04253], [-116.5987, 33.0425], [-116.59842, 33.04233], [-116.59829, 33.04218], [-116.59813, 33.04195], [-116.59794, 33.04155], [-116.59784, 33.04137], [-116.59773, 33.04123], [-116.59756, 33.04106], [-116.59713, 33.04074], [-116.59716, 33.03891], [-116.5931, 33.03889], [-116.59285, 33.03891], [-116.59281, 33.0403], [-116.59279, 33.04249], [-116.58846, 33.04249], [-116.58844, 33.04973], [-116.58419, 33.04971], [-116.58417, 33.05062], [-116.57558, 33.05059], [-116.57561, 33.04971], [-116.57569, 33.0497], [-116.57555, 33.04248], [-116.58428, 33.04247], [-116.58426, 33.03632], [-116.58423, 33.03631], [-116.58416, 33.02825], [-116.58831, 33.02827], [-116.5925, 33.02826], [-116.59259, 33.02534], [-116.59252, 33.02528], [-116.59264, 33.02518], [-116.59278, 33.02511], [-116.59294, 33.02507], [-116.59311, 33.02506], [-116.59328, 33.02508], [-116.59344, 33.02513], [-116.59395, 33.02547], [-116.59409, 33.02551], [-116.59424, 33.02553], [-116.59439, 33.02552], [-116.59468, 33.02542], [-116.59704, 33.02542], [-116.59708, 33.02825], [-116.6015, 33.0282], [-116.60473, 33.02811], [-116.60482, 33.03499], [-116.60586, 33.035]], [[-116.58847, 33.0389], [-116.58852, 33.03726], [-116.58788, 33.03725], [-116.58785, 33.03796], [-116.58784, 33.03889], [-116.58847, 33.0389]], [[-116.5927, 33.03902], [-116.59271, 33.03901], [-116.59269, 33.03895], [-116.59071, 33.03894], [-116.58907, 33.03895], [-116.58908, 33.03902], [-116.5927, 33.03902]]]} | Open Access 1 | 5368 | William Heise County Park | 10697 | 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.sdparks.org/content/sdparks/en/park-pages/WilliamHeise.html | San Diego 4 | 1012.3 | William Heise County Park | 0 | Local Park 2 | 4 |
843 | 843 | 842 | {"type": "Polygon", "coordinates": [[[-116.9683, 32.73338], [-116.9683, 32.73465], [-116.96616, 32.73505], [-116.9659, 32.73378], [-116.96606, 32.73382], [-116.96615, 32.73378], [-116.96618, 32.73375], [-116.96619, 32.73366], [-116.96615, 32.73359], [-116.96606, 32.73356], [-116.96598, 32.73356], [-116.96587, 32.73363], [-116.96582, 32.73336], [-116.9683, 32.73338]]]} | Open Access 1 | 4978 | Del Parque Park | 18044 | 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 | San Diego 4 | 8.751 | Del Parque Park | 0 | Local Park 2 | 4 | |
848 | 848 | 847 | {"type": "Polygon", "coordinates": [[[-117.00957, 32.73712], [-117.00956, 32.73771], [-117.00891, 32.7377], [-117.00892, 32.73676], [-117.00933, 32.73677], [-117.00933, 32.73712], [-117.00957, 32.73712]]]} | Open Access 1 | 4981 | Goodland Acres Park | 19403 | 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.sdparks.org/content/sdparks/en/park-pages/GoodlandAcres.html | San Diego 4 | 1.35 | Goodland Acres Park | 0 | Local Park 2 | 4 |
854 | 854 | 853 | {"type": "Polygon", "coordinates": [[[-116.11437, 32.67551], [-116.11002, 32.6755], [-116.10767, 32.67548], [-116.10778, 32.67525], [-116.10795, 32.67478], [-116.10802, 32.67445], [-116.10806, 32.67418], [-116.10805, 32.6737], [-116.10792, 32.67306], [-116.10777, 32.67268], [-116.10697, 32.67118], [-116.10689, 32.67095], [-116.10682, 32.67052], [-116.10683, 32.6702], [-116.10686, 32.66997], [-116.10714, 32.66874], [-116.10721, 32.6682], [-116.11014, 32.66819], [-116.11432, 32.66822], [-116.11437, 32.67551]]]} | Open Access 1 | 5543 | Mountain Springs County Park | 22548 | 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 | San Diego 4 | 129.801 | Mtn. Springs County Park | 0 | Local Park 2 | 4 | |
1159 | 1159 | 1158 | {"type": "Polygon", "coordinates": [[[-116.86115, 32.85694], [-116.85942, 32.85842], [-116.85825, 32.85715], [-116.85827, 32.85712], [-116.86003, 32.85568], [-116.86115, 32.85694]]]} | Open Access 1 | 7359 | Rios Canyon Park | 24393 | 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 | San Diego 4 | 10.061 | Rios Canyon Park | 0 | Local Park 2 | 4 | |
1324 | 1324 | 1323 | {"type": "Polygon", "coordinates": [[[-117.28327, 33.05261], [-117.28325, 33.0544], [-117.28105, 33.05439], [-117.27903, 33.05436], [-117.27912, 33.0521], [-117.27921, 33.0508], [-117.28122, 33.05083], [-117.28114, 33.05261], [-117.28327, 33.05261]]]} | Open Access 1 | 47628 | San Diego Botanic Garden | 31367 | 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.sdbgarden.org/ | San Diego 4 | 28.386 | San Diego Botanic Garden | 0 | Local Park 2 | 4 |
3171 | 3171 | 3170 | {"type": "Polygon", "coordinates": [[[-117.07154, 32.66675], [-117.07129, 32.66682], [-117.07133, 32.66693], [-117.07096, 32.66703], [-117.07084, 32.66671], [-117.07146, 32.66654], [-117.07154, 32.66675]]]} | Open Access 1 | 26057 | Lincoln Acres Park | 21245 | 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.sdparks.org/content/sdparks/en/park-pages/LincolnAcres.html | San Diego 4 | 0.484 | Lincoln Acres 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]);