units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,421 rows where COUNTY = 4 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, MNG_AG_LEV
MNG_AGENCY >30
- San Diego, City of 533
- San Diego, County of 123
- Chula Vista, City of 70
- Poway, City of 67
- Encinitas, City of 57
- Oceanside, City of 45
- Carlsbad, City of 40
- San Marcos, City of 40
- Escondido, City of 34
- California Department of Fish and Wildlife 31
- Home Owners Association - Unknown Name 27
- California Department of Transportation 22
- California Department of Parks and Recreation 21
- The Environmental Trust 21
- Coronado, City of 19
- San Diego Unified Port District 19
- Vista, City of 18
- El Cajon, City of 17
- Fallbrook Land Conservancy 15
- La Mesa, City of 14
- Endangered Habitats Conservancy 14
- Center for Natural Lands Management 13
- Santee, City of 12
- United States Fish and Wildlife Service 10
- Del Mar, City of 8
- United States Bureau of Land Management 7
- National City, City of 7
- San Diego River Park Foundation 7
- San Dieguito River Valley Land Conservancy 6
- Lemon Grove, City of 6
- …
DES_TP >30
- Local Park 646
- Local Recreation Area 309
- Local Other or Unknown 99
- Private Conservation 87
- Local Conservation Area 58
- Private Recreation or Education 38
- State Conservation Area 36
- State Other or Unknown 20
- State Park 16
- National Wildlife Refuge 11
- State Resource Management Area 6
- National Public Lands 4
- Local Historic or Cultural Area 3
- Private Other or Unknown 3
- Conservation Area 2
- State Recreation Area 2
- Local Resource Management Area 2
- State Historic or Cultural Area 2
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Recreation Management Area 1
- None 1
- None 1
- National Monument or Landmark 1
- None 1
- …
MNG_AG_TYP 21
- City Agency 995
- County Agency 123
- State Agency 87
- Non Profit - Land Trust 69
- Home Owners Association 28
- Non Profit - Conservation 24
- Water District 23
- Federal Agency 21
- Port/Harbor District 19
- Non Profit - Other 7
- Commercial 5
- Recreation/Parks District 4
- Transportation Agency 4
- Open Space District 2
- Irrigation District 2
- Special District - Other 2
- Other 2
- School District 1
- Mitigation Bank 1
- Utility 1
- Fire District 1
AGNCY_TYP 21 ✖
- City Agency 987
- County Agency 120
- State Agency 86
- Non Profit - Land Trust 70
- Home Owners Association 28
- Water District 27
- Non Profit - Conservation 25
- Federal Agency 24
- Port/Harbor District 18
- School District 8
- Non Profit - Other 7
- Transportation Agency 4
- Recreation/Parks District 3
- Commercial 3
- Open Space District 2
- Irrigation District 2
- Utility 2
- Special District - Other 2
- Other 1
- Mitigation Bank 1
- Fire District 1
ACCESS_TYP 4
- Open Access 1,164
- No Public Access 128
- Restricted Access 102
- Unknown Access 27
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104 | 104 | 103 | {"type": "MultiPolygon", "coordinates": [[[[-117.28007, 33.05439], [-117.27998, 33.05619], [-117.27973, 33.05623], [-117.27961, 33.05627], [-117.27947, 33.05637], [-117.27933, 33.05643], [-117.27924, 33.05645], [-117.27918, 33.05644], [-117.27916, 33.05641], [-117.27907, 33.05602], [-117.279, 33.05546], [-117.279, 33.05499], [-117.27903, 33.05437], [-117.28007, 33.05439]]], [[[-117.28063, 33.05635], [-117.28056, 33.05752], [-117.28062, 33.05796], [-117.27972, 33.05795], [-117.27929, 33.05682], [-117.27923, 33.05664], [-117.27929, 33.0566], [-117.27948, 33.05654], [-117.27971, 33.0564], [-117.27986, 33.05635], [-117.28063, 33.05635]]]]} | Open Access 1 | 288 | Encinitas Ranch Community Use Site | 18665 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 9.497 | Encinitas Ranch Community Use Site | None 12 | |||
192 | 192 | 191 | {"type": "Polygon", "coordinates": [[[-117.25358, 33.2577], [-117.25022, 33.25616], [-117.25015, 33.25611], [-117.25356, 33.2561], [-117.25358, 33.2577]]]} | Open Access 1 | 527 | San Luis Rey River | 24941 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 7.039 | San Luis Rey River | None 21 | |||
219 | 219 | 218 | {"type": "Polygon", "coordinates": [[[-117.29114, 33.03378], [-117.29094, 33.03383], [-117.29088, 33.0337], [-117.29105, 33.03363], [-117.29114, 33.03378]]]} | Open Access 1 | 708 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.079 | Swami's Bluff Parcels | None 23 | ||
255 | 255 | 254 | {"type": "Polygon", "coordinates": [[[-117.29084, 33.0333], [-117.2907, 33.03336], [-117.29031, 33.03261], [-117.29033, 33.03255], [-117.29053, 33.03288], [-117.29071, 33.03315], [-117.29084, 33.0333]]]} | Open Access 1 | 709 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.184 | Swami's Bluff Parcels | None 27 | ||
284 | 284 | 283 | {"type": "Polygon", "coordinates": [[[-116.4753, 32.60867], [-116.47487, 32.60888], [-116.47435, 32.60914], [-116.47431, 32.60887], [-116.47465, 32.60861], [-116.47505, 32.60838], [-116.4753, 32.60867]]]} | Open Access 1 | 766 | Campo Stone Store | 29229 | 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://ohp.parks.ca.gov/ListedResources/Detail/411 | San Diego 4 | 0.82 | Campo Stone Store | None 31 | ||
460 | 460 | 459 | {"type": "Polygon", "coordinates": [[[-117.24981, 33.2545], [-117.24943, 33.25596], [-117.245, 33.25509], [-117.245, 33.25326], [-117.24532, 33.25324], [-117.24564, 33.25323], [-117.24597, 33.25326], [-117.2464, 33.25334], [-117.24907, 33.2543], [-117.24981, 33.2545]]]} | Open Access 1 | 1842 | San Luis Rey River | 24941 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 21.567 | San Luis Rey River | None 48 | |||
494 | 494 | 493 | {"type": "Polygon", "coordinates": [[[-117.27317, 32.85074], [-117.27304, 32.85083], [-117.27295, 32.85079], [-117.27295, 32.85077], [-117.27298, 32.85075], [-117.273, 32.85069], [-117.27288, 32.8505], [-117.27277, 32.85041], [-117.27279, 32.85034], [-117.27292, 32.85028], [-117.27299, 32.85025], [-117.27301, 32.85027], [-117.27317, 32.85046], [-117.27323, 32.85056], [-117.27322, 32.85066], [-117.27317, 32.85074]]]} | Open Access 1 | 47473 | La Jolla Cove | 31200 | 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 | http://www.lajollabythesea.com/la-jolla-cove | San Diego 4 | 0.357 | La Jolla Cove | None 52 | ||
909 | 909 | 908 | {"type": "MultiPolygon", "coordinates": [[[[-116.98194, 32.66387], [-116.98012, 32.66389], [-116.98006, 32.66252], [-116.98113, 32.66321], [-116.98194, 32.66387]]], [[[-116.99533, 32.66736], [-116.9952, 32.6671], [-116.99494, 32.66669], [-116.9947, 32.66636], [-116.99446, 32.6661], [-116.99404, 32.6657], [-116.99371, 32.66545], [-116.99336, 32.66523], [-116.99305, 32.66506], [-116.99253, 32.66482], [-116.99242, 32.66479], [-116.99241, 32.66479], [-116.9924, 32.66481], [-116.98955, 32.66381], [-116.98915, 32.66383], [-116.98534, 32.66471], [-116.98442, 32.66526], [-116.98444, 32.66385], [-116.98299, 32.66386], [-116.98277, 32.66357], [-116.98191, 32.66274], [-116.98083, 32.66182], [-116.98012, 32.66126], [-116.98162, 32.66028], [-116.99252, 32.66025], [-116.99312, 32.66169], [-116.99324, 32.66166], [-116.99346, 32.66211], [-116.99359, 32.6624], [-116.99369, 32.66237], [-116.99393, 32.6629], [-116.99407, 32.66325], [-116.9942, 32.66361], [-116.9944, 32.66434], [-116.99449, 32.66471], [-116.99456, 32.66515], [-116.99455, 32.66531], [-116.99458, 32.66546], [-116.99462, 32.66554], [-116.9947, 32.66567], [-116.99489, 32.66587], [-116.99513, 32.66618], [-116.99523, 32.66641], [-116.99531, 32.66663], [-116.99536, 32.66698], [-116.99535, 32.66725], [-116.99533, 32.66736]]], [[[-117.00156, 32.67463], [-116.99849, 32.67546], [-116.99657, 32.67064], [-116.99567, 32.66833], [-116.9957, 32.66831], [-116.99555, 32.66794], [-116.99562, 32.6678], [-116.99568, 32.66754], [-116.99571, 32.66723], [-116.99569, 32.66683], [-116.99561, 32.66648], [-116.99551, 32.66623], [-116.99533, 32.66591], [-116.99522, 32.66576], [-116.99497, 32.66549], [-116.99488, 32.66534], [-116.99485, 32.66493], [-116.99477, 32.66442], [-116.99459, 32.66368], [-116.9944, 32.66315], [-116.99369, 32.66154], [-116.99617, 32.66084], [-116.99614, 32.66208], [-116.99667, 32.66343], [-116.99675, 32.66451], [-116.99781, 32.66579], [-116.99839, 32.6665], [-116.99859, 32.66701], [-116.99879, 32.66746], [-116.99892, 32.66874], [-117.00005, 32.6695], [-117.00038, 32.67013], [-117.00035, 32.67151], [-117.00156, 32.67463]]]]} | Open Access 1 | 5809 | Blue-Bonita Meadows | 1797 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 240.067 | Blue-Bonita Meadows | None 81 | |||
3169 | 3169 | 3168 | {"type": "Polygon", "coordinates": [[[-117.25165, 32.96386], [-117.24822, 32.96383], [-117.24814, 32.96365], [-117.24879, 32.96367], [-117.24926, 32.96341], [-117.24928, 32.96339], [-117.24933, 32.96291], [-117.24872, 32.96292], [-117.24872, 32.96289], [-117.2487, 32.96287], [-117.24934, 32.96284], [-117.24898, 32.96229], [-117.24872, 32.9617], [-117.24906, 32.96147], [-117.24962, 32.96157], [-117.2502, 32.96181], [-117.25059, 32.96137], [-117.25064, 32.96139], [-117.25069, 32.96146], [-117.25073, 32.96153], [-117.25074, 32.9617], [-117.25081, 32.96191], [-117.2511, 32.96236], [-117.25122, 32.96245], [-117.25136, 32.96251], [-117.25146, 32.96252], [-117.25164, 32.96252], [-117.25165, 32.96386]]]} | Open Access 1 | 21993 | San Dieguito Lagoon | 24864 | 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 | 13.674 | San Dieguito Lagoon | None 260 | |||
3568 | 3568 | 3567 | {"type": "Polygon", "coordinates": [[[-117.12444, 32.57552], [-117.12422, 32.57552], [-117.12425, 32.57652], [-117.12305, 32.57652], [-117.12307, 32.5737], [-117.12357, 32.57366], [-117.12388, 32.57374], [-117.12399, 32.57387], [-117.12401, 32.57408], [-117.12442, 32.57408], [-117.12444, 32.57552]]]} | Open Access 1 | 439 | Imperial Beach Sports Park | 31474 | 1143 | Imperial Beach, City of 630 | City 2 | City Agency 2 | http://www.imperialbeachca.gov/index.asp?Type=B_BASIC&SEC={9F232DF8-5366-4BA2-A4B8-8795196F6D81} | City 2 | 7018 | Boys and Girls Clubs of South County 649 | Non Profit 6 | Non Profit - Other 20 | http://www.bgcscounty.org/portal/home | San Diego 4 | 8.985 | Imperial Beach Sports Park | None 298 | ||
3825 | 3825 | 3824 | {"type": "MultiPolygon", "coordinates": [[[[-117.26084, 32.96844], [-117.26055, 32.96864], [-117.26044, 32.96852], [-117.26074, 32.96833], [-117.26084, 32.96844]]], [[[-117.26155, 32.96919], [-117.26115, 32.96945], [-117.26112, 32.96943], [-117.26088, 32.96904], [-117.26065, 32.96877], [-117.26095, 32.96856], [-117.26155, 32.96919]]]]} | Open Access 1 | 45240 | San Diequito Lagoon | 24873 | 1082 | Del Mar, City of 93 | City 2 | City Agency 2 | http://www.delmar.ca.us/203/Beaches-Parks | City 2 | 1082 | Del Mar, City of 91 | City 2 | City Agency 2 | http://www.sdrp.org/wordpress/ | San Diego 4 | 1.046 | San Diequito Lagoon | None 322 | ||
4183 | 4183 | 4182 | {"type": "MultiPolygon", "coordinates": [[[[-117.06172, 32.93278], [-117.06122, 32.93336], [-117.06087, 32.93316], [-117.06071, 32.9331], [-117.06052, 32.93306], [-117.06016, 32.93303], [-117.05996, 32.93305], [-117.05974, 32.9331], [-117.05968, 32.93308], [-117.05965, 32.93305], [-117.05923, 32.93194], [-117.05911, 32.93166], [-117.05887, 32.93122], [-117.05859, 32.93084], [-117.05859, 32.93079], [-117.05882, 32.93064], [-117.05916, 32.93101], [-117.0608, 32.93016], [-117.06098, 32.93018], [-117.0599, 32.93081], [-117.05979, 32.93128], [-117.06026, 32.93172], [-117.0606, 32.93182], [-117.06093, 32.93184], [-117.06127, 32.93176], [-117.0615, 32.93172], [-117.06153, 32.93243], [-117.06172, 32.93278]]], [[[-117.06669, 32.93294], [-117.06648, 32.93266], [-117.06644, 32.93238], [-117.06648, 32.93208], [-117.06625, 32.932], [-117.06608, 32.9318], [-117.06621, 32.93138], [-117.06616, 32.93133], [-117.06597, 32.93138], [-117.06552, 32.93156], [-117.06489, 32.93141], [-117.06501, 32.93102], [-117.06506, 32.93069], [-117.06543, 32.93045], [-117.06548, 32.93009], [-117.0652, 32.92941], [-117.06497, 32.92918], [-117.06473, 32.929], [-117.06367, 32.92871], [-117.06354, 32.92923], [-117.0635, 32.92922], [-117.06361, 32.9287], [-117.06028, 32.92779], [-117.06534, 32.92774], [-117.06556, 32.928], [-117.06579, 32.92819], [-117.06596, 32.92829], [-117.06668, 32.92866], [-117.06669, 32.93294]]], [[[-117.06581, 32.93938], [-117.06576, 32.93969], [-117.06569, 32.93966], [-117.06569, 32.93963], [-117.06539, 32.93946], [-117.06532, 32.93947], [-117.06505, 32.93936], [-117.06446, 32.93929], [-117.06429, 32.9389], [-117.06405, 32.93887], [-117.0639, 32.93843], [-117.063, 32.93833], [-117.06287, 32.93795], [-117.06274, 32.93769], [-117.06286, 32.93761], [-117.06308, 32.93783], [-117.06349, 32.93754], [-117.06399, 32.93805], [-117.06412, 32.93807], [-117.06478, 32.93895], [-117.06507, 32.93898], [-117.06505, 32.93915], [-117.06581, 32.93938]]], [[[-117.06668, 32.92848], [-117.06592, 32.92807], [-117.06573, 32.92792], [-117.06557, 32.92774], [-117.06668, 32.92773], [-117.06668, 32.92848]]]]} | No Public Access 3 | 44864 | South Poway Cornerstone | 25675 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 37.928 | South Poway Cornerstone | None 364 | |||
4244 | 4244 | 4243 | {"type": "Polygon", "coordinates": [[[-117.0056, 32.63624], [-117.00513, 32.63582], [-117.00502, 32.63576], [-117.0046, 32.63569], [-117.00423, 32.63587], [-117.00342, 32.63602], [-117.00317, 32.63618], [-117.00295, 32.63637], [-117.0028, 32.63655], [-117.00278, 32.63652], [-117.00292, 32.63635], [-117.00312, 32.63616], [-117.0034, 32.63599], [-117.00399, 32.63587], [-117.00393, 32.63562], [-117.00387, 32.63559], [-117.00389, 32.63551], [-117.00387, 32.63546], [-117.00383, 32.63543], [-117.00384, 32.63532], [-117.00342, 32.63483], [-117.0034, 32.63476], [-117.00332, 32.6347], [-117.00288, 32.6342], [-117.00288, 32.63413], [-117.00285, 32.63409], [-117.00266, 32.63386], [-117.0024, 32.63364], [-117.00258, 32.63353], [-117.0029, 32.63337], [-117.00316, 32.63336], [-117.00324, 32.63329], [-117.00326, 32.63322], [-117.00374, 32.63319], [-117.00374, 32.6339], [-117.00368, 32.63422], [-117.00397, 32.63498], [-117.00413, 32.63517], [-117.00417, 32.63515], [-117.0042, 32.6352], [-117.00418, 32.63523], [-117.00447, 32.63557], [-117.00525, 32.63536], [-117.0056, 32.63624]]]} | Open Access 1 | 45158 | Rancho Del Rey South | 24141 | 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/rancho-del-rey-park | San Diego 4 | 5.729 | Rancho Del Rey South | None 370 | ||
4280 | 4280 | 4279 | {"type": "Polygon", "coordinates": [[[-117.24735, 32.96922], [-117.24593, 32.96921], [-117.24592, 32.96922], [-117.24638, 32.96992], [-117.2445, 32.96992], [-117.24371, 32.97056], [-117.24369, 32.97114], [-117.24394, 32.97137], [-117.24404, 32.97165], [-117.24404, 32.97187], [-117.24398, 32.97218], [-117.24382, 32.97234], [-117.24361, 32.97234], [-117.24328, 32.97225], [-117.24315, 32.97208], [-117.24317, 32.97158], [-117.24305, 32.97158], [-117.24169, 32.97116], [-117.24127, 32.97067], [-117.23964, 32.97065], [-117.23955, 32.97036], [-117.23941, 32.97006], [-117.23922, 32.96977], [-117.23904, 32.96953], [-117.23677, 32.96735], [-117.23875, 32.96737], [-117.23876, 32.96375], [-117.23968, 32.96375], [-117.24306, 32.96168], [-117.24306, 32.96378], [-117.24569, 32.96381], [-117.2457, 32.96397], [-117.24735, 32.96759], [-117.24735, 32.96922]]]} | Open Access 1 | 45239 | San Dieguito Lagoon | 24864 | 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 | 152.683 | San Dieguito Lagoon | None 374 | |||
4389 | 4389 | 4388 | {"type": "Polygon", "coordinates": [[[-117.06741, 32.94582], [-117.06611, 32.94579], [-117.06614, 32.94569], [-117.06613, 32.94558], [-117.06599, 32.94508], [-117.066, 32.94497], [-117.06604, 32.94487], [-117.0661, 32.94481], [-117.06617, 32.94477], [-117.06647, 32.94467], [-117.06665, 32.94462], [-117.06687, 32.94461], [-117.06698, 32.94458], [-117.06741, 32.94582]]]} | Open Access 1 | 45987 | The Pond | 29156 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 3.291 | The Pond | None 391 | |||
4391 | 4391 | 4390 | {"type": "Polygon", "coordinates": [[[-116.36536, 33.23412], [-116.36466, 33.23413], [-116.3643, 33.23433], [-116.36296, 33.23237], [-116.3634, 33.23211], [-116.36371, 33.23196], [-116.36404, 33.23184], [-116.36438, 33.23175], [-116.36473, 33.23167], [-116.36508, 33.23163], [-116.36526, 33.23161], [-116.3653, 33.23163], [-116.36533, 33.23167], [-116.36536, 33.23412]]]} | Open Access 1 | 45996 | Borrego Springs Park Site Dedication | 29191 | 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 | 11.154 | Borrego Springs Park Site Dedication | None 392 | |||
5056 | 5056 | 5055 | {"type": "Polygon", "coordinates": [[[-117.13499, 32.75509], [-117.13393, 32.75509], [-117.13391, 32.75416], [-117.13499, 32.75415], [-117.13499, 32.75509]]]} | Restricted Access 2 | 46 | San Diego Indoor Soccer Center | 30288 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 6103 | Private Landowner 774 | Private 7 | Other 26 | San Diego 4 | 2.583 | San Diego Indoor Soccer Ctr. | None 416 | |||
5282 | 5282 | 5281 | {"type": "Polygon", "coordinates": [[[-116.9986, 32.96095], [-116.99776, 32.96117], [-116.99758, 32.96085], [-116.99794, 32.96067], [-116.9981, 32.96063], [-116.99835, 32.96059], [-116.99841, 32.96063], [-116.9985, 32.96081], [-116.9986, 32.96095]]]} | Open Access 1 | 47639 | Sycamore Creek Neighborhood Park - East | 31380 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.91 | Sycamore Creek Neighborhood Park - East | None 426 | |||
6084 | 6084 | 6083 | {"type": "Polygon", "coordinates": [[[-117.03743, 32.96938], [-117.03742, 32.97105], [-117.03627, 32.97104], [-117.03628, 32.96938], [-117.03743, 32.96938]]]} | Open Access 1 | 890 | Old Poway Park and Railroad | 23098 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/452/Old-Poway-Park | San Diego 4 | 4.928 | Old Poway Park and Railroad | None 491 | ||
6136 | 6136 | 6135 | {"type": "Polygon", "coordinates": [[[-116.38064, 33.25292], [-116.3793, 33.25356], [-116.37899, 33.25374], [-116.37872, 33.25392], [-116.37866, 33.25393], [-116.3784, 33.25375], [-116.37788, 33.25326], [-116.37753, 33.25281], [-116.37726, 33.25241], [-116.37712, 33.25213], [-116.37694, 33.2517], [-116.37682, 33.25124], [-116.37676, 33.2508], [-116.37759, 33.25077], [-116.37785, 33.25082], [-116.37806, 33.25092], [-116.37822, 33.25101], [-116.3789, 33.25157], [-116.38064, 33.25292]]]} | Open Access 1 | 1161 | Borrego Springs Holding | 29228 | 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 | 15.939 | Borrego Springs Holding | None 494 |
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]);