units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,421 rows where COUNTY = 4 sorted by AGNCY_TYP descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, 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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12141 | 12141 | 12140 | {"type": "Polygon", "coordinates": [[[-117.24854, 33.38252], [-117.24854, 33.3826], [-117.2485, 33.38294], [-117.24846, 33.38358], [-117.24731, 33.38357], [-117.24732, 33.38286], [-117.24747, 33.38282], [-117.24749, 33.38251], [-117.24854, 33.38252]]]} | Open Access 1 | 25112 | Ballpark | 15790 | 2327 | North County Fire District 1008 | Special District 4 | Fire District 36 | http://www.ncfireprotectiondistrict.org/ | Special District 4 | 2327 | North County Fire District 970 | Special District 4 | Fire District 33 | San Diego 4 | 3.077 | Ballpark | None 1061 | |||
13166 | 13166 | 13165 | {"type": "Polygon", "coordinates": [[[-117.35743, 33.16745], [-117.35654, 33.16659], [-117.35654, 33.16659], [-117.35663, 33.16654], [-117.35665, 33.16649], [-117.35674, 33.16649], [-117.35696, 33.16668], [-117.35696, 33.1667], [-117.35728, 33.16704], [-117.35724, 33.16707], [-117.35727, 33.1671], [-117.35726, 33.16716], [-117.35728, 33.16723], [-117.3574, 33.16736], [-117.35743, 33.16745]]]} | Unknown Access 4 | 45147 | Buena Vista Lagoon Ecological Reserve | 16489 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | San Diego 4 | 0.497 | Buena Vista Lagoon ER | 1968 | Local Conservation Area 4 | 2 | |
14768 | 14768 | 14767 | {"type": "Polygon", "coordinates": [[[-117.31758, 33.10576], [-117.31739, 33.10582], [-117.31597, 33.10271], [-117.3161, 33.10265], [-117.31758, 33.10576]]]} | Unknown Access 4 | 45154 | Poinsettia Lane Vernal Pools | 23843 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | San Diego 4 | 1.476 | Poinsettia Lane Vernal Pools | 0 | Local Conservation Area 4 | 2 | |
14774 | 14774 | 14773 | {"type": "MultiPolygon", "coordinates": [[[[-117.3104, 33.20185], [-117.31053, 33.20215], [-117.31063, 33.20246], [-117.31076, 33.20299], [-117.31074, 33.20304], [-117.31069, 33.20307], [-117.31012, 33.2032], [-117.30901, 33.2034], [-117.308, 33.20353], [-117.30733, 33.20359], [-117.30597, 33.20366], [-117.30496, 33.20366], [-117.30145, 33.20359], [-117.30076, 33.20359], [-117.30007, 33.20361], [-117.29904, 33.20369], [-117.29686, 33.20395], [-117.29686, 33.20297], [-117.30621, 33.20241], [-117.30709, 33.20231], [-117.30775, 33.20222], [-117.31037, 33.2018], [-117.3104, 33.20185]]], [[[-117.31023, 33.20153], [-117.3077, 33.20193], [-117.30618, 33.20213], [-117.29686, 33.2027], [-117.29686, 33.20126], [-117.3063, 33.20135], [-117.31012, 33.20136], [-117.31023, 33.20153]]]]} | Unknown Access 4 | 45152 | North County Transit District Mitigation | 22817 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | San Diego 4 | 69.998 | North County Transit District Mitigation | 0 | Local Other or Unknown 14 | 4 | |
15640 | 15640 | 15639 | {"type": "MultiPolygon", "coordinates": [[[[-117.31035, 33.08979], [-117.31028, 33.08985], [-117.31002, 33.08986], [-117.3097, 33.08907], [-117.30937, 33.08815], [-117.30811, 33.08419], [-117.30836, 33.08424], [-117.30846, 33.08445], [-117.30841, 33.08445], [-117.3084, 33.0845], [-117.30846, 33.08469], [-117.30861, 33.0851], [-117.30879, 33.0855], [-117.30911, 33.08636], [-117.30926, 33.08685], [-117.30936, 33.08707], [-117.30944, 33.08752], [-117.30948, 33.08757], [-117.30958, 33.0876], [-117.3098, 33.08825], [-117.3098, 33.08832], [-117.30977, 33.0884], [-117.30987, 33.08879], [-117.31004, 33.08917], [-117.31007, 33.08927], [-117.31015, 33.08935], [-117.31023, 33.08954], [-117.31034, 33.0897], [-117.31035, 33.08979]]], [[[-117.31092, 33.09038], [-117.31087, 33.09039], [-117.31078, 33.09031], [-117.31073, 33.09017], [-117.31058, 33.08993], [-117.31056, 33.0898], [-117.31043, 33.08945], [-117.31048, 33.08939], [-117.31045, 33.08926], [-117.31027, 33.08887], [-117.31021, 33.08862], [-117.31001, 33.08829], [-117.30994, 33.08824], [-117.30987, 33.08814], [-117.30966, 33.08762], [-117.30966, 33.08759], [-117.30968, 33.08746], [-117.30965, 33.0873], [-117.30953, 33.08701], [-117.30946, 33.08676], [-117.30932, 33.08638], [-117.30928, 33.0862], [-117.30915, 33.08591], [-117.30901, 33.08547], [-117.30893, 33.08529], [-117.30884, 33.08484], [-117.30877, 33.08464], [-117.30875, 33.08445], [-117.30868, 33.08417], [-117.30878, 33.08405], [-117.30986, 33.08748], [-117.31068, 33.08968], [-117.31077, 33.08988], [-117.31076, 33.08997], [-117.31079, 33.09011], [-117.3109, 33.09029], [-117.31092, 33.09038]]]]} | Unknown Access 4 | 45153 | Batiquitos Lagoon Ecological Reserve | 15865 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Batiquitos-Lagoon-ER | San Diego 4 | 7.116 | Batiquitos Lagoon ER | 1983 | Local Conservation Area 4 | 2 |
7799 | 7799 | 7798 | {"type": "Polygon", "coordinates": [[[-117.31508, 33.26166], [-117.31432, 33.26259], [-117.31428, 33.26186], [-117.31404, 33.26172], [-117.31338, 33.26127], [-117.31266, 33.2613], [-117.31162, 33.26213], [-117.3132, 33.26337], [-117.31094, 33.26441], [-117.30968, 33.26347], [-117.30968, 33.26342], [-117.30855, 33.26259], [-117.30882, 33.2621], [-117.31085, 33.25891], [-117.31091, 33.25884], [-117.31117, 33.25856], [-117.31145, 33.25829], [-117.31228, 33.25764], [-117.31243, 33.25778], [-117.31258, 33.25767], [-117.31258, 33.25766], [-117.31243, 33.25752], [-117.3135, 33.25671], [-117.31355, 33.2567], [-117.31361, 33.25671], [-117.31372, 33.25681], [-117.31374, 33.25685], [-117.31373, 33.25691], [-117.31385, 33.25702], [-117.31403, 33.25689], [-117.3142, 33.25705], [-117.31396, 33.25708], [-117.31349, 33.26035], [-117.31401, 33.2604], [-117.31487, 33.26041], [-117.31508, 33.26166]]]} | No Public Access 3 | 47673 | Foss Lake Preserve | 31414 | 7016 | Foss Lake Conservation LP 877 | Private 7 | Mitigation Bank 29 | Private 14 | 7016 | Foss Lake Conservation LP 854 | Private 7 | Mitigation Bank 28 | San Diego 4 | 58.822 | Foss Lake Preserve | None 648 | ||||
6684 | 6684 | 6683 | {"type": "MultiPolygon", "coordinates": [[[[-116.74406, 32.79528], [-116.74353, 32.79522], [-116.74329, 32.79518], [-116.74299, 32.79506], [-116.74274, 32.79491], [-116.74253, 32.79473], [-116.74237, 32.79452], [-116.74203, 32.79381], [-116.74269, 32.79448], [-116.74301, 32.79475], [-116.74343, 32.795], [-116.74406, 32.79528]]], [[[-116.74494, 32.79562], [-116.73759, 32.79565], [-116.73759, 32.79051], [-116.73789, 32.79055], [-116.73815, 32.79063], [-116.73842, 32.79076], [-116.73864, 32.79093], [-116.73916, 32.79151], [-116.73931, 32.79174], [-116.73945, 32.79207], [-116.73953, 32.79219], [-116.73966, 32.79235], [-116.73981, 32.79247], [-116.74003, 32.79261], [-116.74114, 32.79309], [-116.74139, 32.79324], [-116.74162, 32.79342], [-116.7422, 32.7946], [-116.74237, 32.79482], [-116.74263, 32.79505], [-116.74295, 32.79523], [-116.74328, 32.79535], [-116.74354, 32.79539], [-116.74437, 32.79546], [-116.74467, 32.79553], [-116.74494, 32.79562]]], [[[-116.79678, 32.79555], [-116.78939, 32.79568], [-116.78942, 32.79919], [-116.78839, 32.79922], [-116.78843, 32.801], [-116.79007, 32.80102], [-116.7926, 32.80099], [-116.79263, 32.80279], [-116.78848, 32.80283], [-116.78424, 32.80279], [-116.78419, 32.79919], [-116.77998, 32.79918], [-116.77995, 32.7956], [-116.77575, 32.7956], [-116.77578, 32.80274], [-116.77261, 32.80276], [-116.7724, 32.80274], [-116.77211, 32.80269], [-116.77186, 32.80263], [-116.77035, 32.80211], [-116.76993, 32.80202], [-116.76944, 32.80196], [-116.76903, 32.80196], [-116.76866, 32.80199], [-116.76675, 32.80232], [-116.76636, 32.80235], [-116.76581, 32.80234], [-116.76495, 32.80223], [-116.76464, 32.80215], [-116.76436, 32.80203], [-116.76256, 32.80087], [-116.76202, 32.80057], [-116.76163, 32.80039], [-116.75955, 32.79963], [-116.75917, 32.79952], [-116.75871, 32.79944], [-116.75756, 32.7994], [-116.75701, 32.79933], [-116.75675, 32.79928], [-116.75557, 32.79895], [-116.75512, 32.79887], [-116.75485, 32.79885], [-116.75316, 32.79883], [-116.75283, 32.79885], [-116.75249, 32.79889], [-116.75205, 32.799], [-116.75162, 32.79915], [-116.75052, 32.79972], [-116.7503, 32.79981], [-116.7501, 32.79986], [-116.74989, 32.79989], [-116.74964, 32.7999], [-116.74943, 32.79988], [-116.74915, 32.7998], [-116.74876, 32.79962], [-116.74852, 32.79945], [-116.74831, 32.79924], [-116.74669, 32.7967], [-116.7464, 32.79635], [-116.74602, 32.79601], [-116.74601, 32.79564], [-116.74539, 32.79563], [-116.74374, 32.79496], [-116.74351, 32.79486], [-116.7433, 32.79473], [-116.74308, 32.79458], [-116.74288, 32.79441], [-116.74192, 32.79345], [-116.74156, 32.79315], [-116.74122, 32.79294], [-116.74012, 32.79246], [-116.73988, 32.79231], [-116.73976, 32.79219], [-116.73967, 32.79206], [-116.73948, 32.79166], [-116.73934, 32.79144], [-116.73886, 32.79089], [-116.73869, 32.79074], [-116.73845, 32.79058], [-116.73816, 32.79045], [-116.73791, 32.79038], [-116.73759, 32.79034], [-116.73759, 32.78851], [-116.73336, 32.78851], [-116.73331, 32.78476], [-116.73751, 32.78476], [-116.75429, 32.78443], [-116.7543, 32.77679], [-116.76715, 32.77703], [-116.76713, 32.77324], [-116.7714, 32.77332], [-116.77142, 32.77711], [-116.78805, 32.77718], [-116.78795, 32.77343], [-116.7965, 32.77338], [-116.79677, 32.78836], [-116.79252, 32.7884], [-116.79256, 32.79198], [-116.79677, 32.79194], [-116.79678, 32.79555]]], [[[-116.77178, 32.80276], [-116.76519, 32.80282], [-116.76299, 32.80279], [-116.75449, 32.80278], [-116.74607, 32.80287], [-116.74601, 32.79624], [-116.74632, 32.79654], [-116.74656, 32.79684], [-116.74806, 32.79921], [-116.74821, 32.7994], [-116.7484, 32.79959], [-116.74863, 32.79975], [-116.74954, 32.80016], [-116.74978, 32.80019], [-116.74989, 32.80018], [-116.75005, 32.80014], [-116.75067, 32.79984], [-116.75166, 32.79932], [-116.75207, 32.79917], [-116.75245, 32.79907], [-116.75283, 32.79901], [-116.75319, 32.79899], [-116.75482, 32.79902], [-116.75511, 32.79904], [-116.75554, 32.79911], [-116.75667, 32.79943], [-116.75698, 32.79949], [-116.75756, 32.79957], [-116.7587, 32.79961], [-116.7591, 32.79968], [-116.75948, 32.79979], [-116.76145, 32.80051], [-116.76196, 32.80073], [-116.76246, 32.80101], [-116.76427, 32.80217], [-116.7645, 32.80228], [-116.76478, 32.80237], [-116.7657, 32.8025], [-116.76602, 32.80252], [-116.76636, 32.80252], [-116.76682, 32.80247], [-116.7687, 32.80216], [-116.76907, 32.80213], [-116.76942, 32.80213], [-116.76989, 32.80218], [-116.77029, 32.80227], [-116.77178, 32.80276]]]]} | Open Access 1 | 4834 | Loveland Reservoir | 12983 | 2163 | Sweetwater Authority 840 | Special District 4 | Special District - Other 26 | http://www.sweetwater.org | Special District 4 | 2163 | Sweetwater Authority 817 | Special District 4 | Special District - Other 24 | http://www.sweetwater.org/index.aspx?page=111 | San Diego 4 | 3292.465 | Loveland Reservoir | 0 | Local Recreation Area 3 | 4 |
7638 | 7638 | 7637 | {"type": "MultiPolygon", "coordinates": [[[[-117.01289, 32.68963], [-117.01273, 32.68983], [-117.01202, 32.69013], [-117.01125, 32.69018], [-117.01109, 32.69026], [-117.01139, 32.69105], [-117.01006, 32.69144], [-117.01049, 32.69249], [-117.01035, 32.69264], [-117.01027, 32.69282], [-117.01026, 32.69298], [-117.01031, 32.69315], [-117.01039, 32.69334], [-117.01048, 32.69348], [-117.01099, 32.69408], [-117.01119, 32.69426], [-117.01143, 32.69485], [-117.00956, 32.69534], [-117.00656, 32.69617], [-117.00618, 32.69512], [-117.00612, 32.69501], [-117.00435, 32.69499], [-117.0043, 32.69752], [-117.00427, 32.69832], [-117.00321, 32.69831], [-117.00225, 32.6976], [-117.0005, 32.69756], [-116.99905, 32.69953], [-116.99528, 32.70188], [-116.99528, 32.7009], [-116.99469, 32.70089], [-116.99469, 32.70118], [-116.99502, 32.70118], [-116.99502, 32.70219], [-116.99471, 32.70219], [-116.9947, 32.70197], [-116.99438, 32.70198], [-116.99437, 32.70129], [-116.9941, 32.7013], [-116.9941, 32.70218], [-116.99345, 32.70218], [-116.99345, 32.70131], [-116.99339, 32.7013], [-116.98986, 32.7032], [-116.98981, 32.70485], [-116.98865, 32.70483], [-116.98678, 32.70577], [-116.98678, 32.70679], [-116.98667, 32.70685], [-116.98666, 32.70691], [-116.98637, 32.70706], [-116.98598, 32.7073], [-116.98571, 32.70742], [-116.9846, 32.7074], [-116.98455, 32.70877], [-116.98409, 32.70894], [-116.98378, 32.70911], [-116.98276, 32.70928], [-116.98295, 32.7098], [-116.98281, 32.70996], [-116.981, 32.7124], [-116.98079, 32.71263], [-116.98037, 32.71304], [-116.98007, 32.71326], [-116.97835, 32.71428], [-116.97786, 32.71462], [-116.97751, 32.7149], [-116.97712, 32.71526], [-116.97656, 32.71585], [-116.9757, 32.71692], [-116.97558, 32.71703], [-116.97541, 32.71695], [-116.97547, 32.71378], [-116.97669, 32.71162], [-116.97486, 32.71069], [-116.97368, 32.71127], [-116.97187, 32.70999], [-116.96919, 32.71004], [-116.96717, 32.70956], [-116.96536, 32.7089], [-116.96242, 32.70748], [-116.96114, 32.7065], [-116.95846, 32.70964], [-116.95844, 32.711], [-116.9581, 32.71205], [-116.9566, 32.71183], [-116.95699, 32.71138], [-116.95618, 32.70806], [-116.95828, 32.70139], [-116.96282, 32.7014], [-116.96508, 32.70243], [-116.96727, 32.70129], [-116.96827, 32.70129], [-116.96827, 32.70216], [-116.97589, 32.70219], [-116.97777, 32.69987], [-116.97802, 32.69579], [-116.97824, 32.69276], [-116.97921, 32.69007], [-116.98595, 32.69006], [-116.98601, 32.69003], [-116.98608, 32.69003], [-116.98854, 32.68878], [-116.98853, 32.68673], [-116.98976, 32.68673], [-116.98976, 32.68514], [-116.99176, 32.68512], [-116.99176, 32.68303], [-116.99173, 32.68302], [-116.99173, 32.68284], [-116.99302, 32.68306], [-116.99443, 32.68312], [-116.99553, 32.68297], [-116.99641, 32.68324], [-116.99641, 32.68275], [-116.99729, 32.68246], [-116.99947, 32.68152], [-116.9996, 32.68176], [-117.00039, 32.68385], [-117.00165, 32.68355], [-117.00257, 32.68591], [-117.00289, 32.68583], [-117.00626, 32.68725], [-117.00585, 32.68795], [-117.00562, 32.68829], [-117.00584, 32.68882], [-117.00846, 32.68998], [-117.00851, 32.68999], [-117.00932, 32.68976], [-117.01078, 32.68938], [-117.01149, 32.6884], [-117.01152, 32.6883], [-117.01146, 32.68822], [-117.01148, 32.68813], [-117.01286, 32.68945], [-117.01289, 32.68963]], [[-116.9777, 32.71144], [-116.9769, 32.71243], [-116.97689, 32.71248], [-116.97658, 32.71286], [-116.97639, 32.71351], [-116.97646, 32.71453], [-116.97698, 32.71483], [-116.97704, 32.71474], [-116.97659, 32.71448], [-116.97651, 32.71352], [-116.9767, 32.71291], [-116.97787, 32.71141], [-116.97543, 32.71], [-116.97476, 32.70997], [-116.97399, 32.71061], [-116.97307, 32.70944], [-116.97225, 32.70918], [-116.97221, 32.70926], [-116.97223, 32.70928], [-116.97298, 32.70953], [-116.97395, 32.71076], [-116.97479, 32.71007], [-116.97537, 32.71009], [-116.9777, 32.71144]], [[-116.99677, 32.68615], [-116.99677, 32.68613], [-116.99635, 32.68554], [-116.99567, 32.68556], [-116.99569, 32.68666], [-116.99677, 32.68615]]], [[[-117.01103, 32.6939], [-117.01058, 32.6934], [-117.0105, 32.69326], [-117.01044, 32.69313], [-117.01041, 32.69298], [-117.01041, 32.69287], [-117.01046, 32.69273], [-117.01054, 32.69262], [-117.01103, 32.6939]]]]} | Open Access 1 | 7386 | Sweetwater Reservoir | 12984 | 2163 | Sweetwater Authority 840 | Special District 4 | Special District - Other 26 | http://www.sweetwater.org | Special District 4 | 2163 | Sweetwater Authority 817 | Special District 4 | Special District - Other 24 | http://www.sweetwater.org/index.aspx?page=112 | San Diego 4 | 1773.187 | Sweetwater Reservoir | 0 | Local Recreation Area 3 | 4 |
15427 | 15427 | 15426 | {"type": "Polygon", "coordinates": [[[-116.96631, 32.65277], [-116.96564, 32.6533], [-116.96602, 32.65375], [-116.96606, 32.65404], [-116.96482, 32.65413], [-116.96359, 32.65388], [-116.96354, 32.65344], [-116.96469, 32.65281], [-116.96408, 32.6518], [-116.9643, 32.65168], [-116.96476, 32.65241], [-116.96542, 32.65319], [-116.96614, 32.65261], [-116.96631, 32.65277]]]} | Restricted Access 2 | 46691 | Scobee Park | 30036 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 6103 | Private Landowner 774 | Private 7 | Other 26 | San Diego 4 | 7.196 | Scobee Park | 0 | Private Recreation or Education 65 | 4 | ||
2398 | 2398 | 2397 | {"type": "MultiPolygon", "coordinates": [[[[-117.21972, 33.42999], [-117.21971, 33.43008], [-117.21941, 33.43087], [-117.21888, 33.43101], [-117.21852, 33.43096], [-117.21805, 33.43108], [-117.21795, 33.43113], [-117.21774, 33.43153], [-117.21722, 33.43152], [-117.21407, 33.43154], [-117.21414, 33.42781], [-117.21857, 33.4278], [-117.21851, 33.42935], [-117.21925, 33.42978], [-117.21965, 33.42988], [-117.2197, 33.42993], [-117.21972, 33.42999]]], [[[-117.20291, 33.42795], [-117.20281, 33.43006], [-117.19914, 33.43009], [-117.199, 33.43159], [-117.19592, 33.4316], [-117.19604, 33.42917], [-117.19685, 33.429], [-117.19721, 33.42851], [-117.19932, 33.42801], [-117.20077, 33.42797], [-117.20291, 33.42795]]]]} | Restricted Access 2 | 7255 | Santa Margarita Ecological Reserve | 33342 | 3065 | San Diego State University Foundation 524 | Non Profit 6 | Non Profit - Other 22 | http://www.foundation.sdsu.edu/index.html | Non Governmental Organization 10 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 88.83 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
4471 | 4471 | 4470 | {"type": "Polygon", "coordinates": [[[-116.62024, 32.8546], [-116.62023, 32.85532], [-116.61829, 32.85533], [-116.61829, 32.85491], [-116.618, 32.85491], [-116.61799, 32.85435], [-116.61875, 32.85434], [-116.61914, 32.85341], [-116.61924, 32.85343], [-116.6193, 32.85399], [-116.61991, 32.8542], [-116.6198, 32.85446], [-116.62024, 32.8546]]]} | Restricted Access 2 | 1199 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 6.306 | 0 | Private Other or Unknown 399 | 4 | |||
4472 | 4472 | 4471 | {"type": "Polygon", "coordinates": [[[-116.31558, 33.3251], [-116.31551, 33.33963], [-116.29816, 33.3395], [-116.29841, 33.32503], [-116.31558, 33.3251]]]} | Restricted Access 2 | 1208 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 638.799 | 0 | Private Other or Unknown 399 | 4 | |||
5266 | 5266 | 5265 | {"type": "Polygon", "coordinates": [[[-117.35459, 33.20901], [-117.35406, 33.21043], [-117.35407, 33.21045], [-117.35412, 33.21045], [-117.3539, 33.21053], [-117.35388, 33.21048], [-117.35389, 33.21042], [-117.35409, 33.20978], [-117.35417, 33.20964], [-117.35418, 33.20959], [-117.35417, 33.20953], [-117.35411, 33.20946], [-117.35404, 33.20943], [-117.35393, 33.20943], [-117.35337, 33.20918], [-117.35314, 33.20899], [-117.35395, 33.20875], [-117.35416, 33.20875], [-117.35447, 33.20877], [-117.35455, 33.20899], [-117.35459, 33.20901]]]} | Open Access 1 | 949 | North County Humane Society and SPCA Dog Park | 29112 | 3361 | San Diego Humane Society and SPCA 803 | Non Profit 6 | Non Profit - Other 22 | http://www.sdhumane.org/ | Non Governmental Organization 10 | 3361 | San Diego Humane Society and SPCA 783 | Non Profit 6 | Non Profit - Other 20 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/dogpark.asp | San Diego 4 | 2.32 | North County Humane Society and SPCA Dog Park | 0 | Private Recreation or Education 65 | 4 |
7613 | 7613 | 7612 | {"type": "MultiPolygon", "coordinates": [[[[-116.98432, 32.76701], [-116.98411, 32.76731], [-116.98404, 32.76739], [-116.98377, 32.76752], [-116.9836, 32.76758], [-116.98348, 32.76759], [-116.98317, 32.76758], [-116.98293, 32.76749], [-116.98281, 32.76741], [-116.98257, 32.76721], [-116.9825, 32.7671], [-116.9825, 32.76698], [-116.98252, 32.76694], [-116.98265, 32.76674], [-116.98268, 32.76671], [-116.9829, 32.76674], [-116.98319, 32.76662], [-116.98334, 32.7666], [-116.98362, 32.76663], [-116.98411, 32.76677], [-116.98423, 32.76685], [-116.98432, 32.76701]]], [[[-116.98313, 32.76651], [-116.98288, 32.76661], [-116.98266, 32.76658], [-116.98257, 32.76662], [-116.98253, 32.76666], [-116.98238, 32.76693], [-116.98236, 32.76703], [-116.98238, 32.76715], [-116.98245, 32.76726], [-116.98277, 32.76752], [-116.98302, 32.76765], [-116.98294, 32.76763], [-116.98228, 32.76735], [-116.98219, 32.76715], [-116.98236, 32.76689], [-116.98254, 32.76651], [-116.98266, 32.76646], [-116.98313, 32.76651]]], [[[-116.98413, 32.76749], [-116.98404, 32.76755], [-116.98385, 32.76773], [-116.98381, 32.76769], [-116.98369, 32.76768], [-116.98333, 32.76772], [-116.98326, 32.7677], [-116.9835, 32.7677], [-116.98373, 32.76766], [-116.98405, 32.76752], [-116.98412, 32.76747], [-116.98413, 32.76749]]], [[[-116.98087, 32.76954], [-116.98087, 32.76954], [-116.98049, 32.76998], [-116.9807, 32.7694], [-116.98087, 32.76954]]], [[[-116.98059, 32.7693], [-116.98028, 32.77017], [-116.98022, 32.77025], [-116.98028, 32.77002], [-116.98028, 32.76978], [-116.98025, 32.76951], [-116.98022, 32.76942], [-116.98014, 32.76934], [-116.98008, 32.76931], [-116.97977, 32.76924], [-116.97988, 32.76911], [-116.98017, 32.76898], [-116.98059, 32.7693]]], [[[-116.98014, 32.76944], [-116.98017, 32.76955], [-116.9802, 32.76977], [-116.9802, 32.76996], [-116.98018, 32.77009], [-116.98013, 32.77025], [-116.98007, 32.77023], [-116.97955, 32.76984], [-116.97941, 32.76978], [-116.97929, 32.76976], [-116.97953, 32.76954], [-116.97972, 32.7693], [-116.98004, 32.76937], [-116.98014, 32.76944]]], [[[-116.98007, 32.77041], [-116.97968, 32.77033], [-116.97914, 32.77013], [-116.97923, 32.76989], [-116.97934, 32.7699], [-116.97948, 32.76997], [-116.98007, 32.77041]]]]} | Open Access 1 | 7353 | Mt. Helix Park | 22579 | 3024 | Foundation for Preservation of Mt. Helix Nature Theatre 874 | Non Profit 6 | Non Profit - Other 22 | http://www.mthelixpark.org/ | Non Governmental Organization 10 | 3024 | Foundation for Preservation of Mt. Helix Nature Theatre 852 | Non Profit 6 | Non Profit - Other 20 | https://www.mthelixpark.org/ | San Diego 4 | 6.584 | Mt. Helix Park | 0 | Private Recreation or Education 65 | 4 |
11517 | 11517 | 11516 | {"type": "Polygon", "coordinates": [[[-117.24714, 33.20982], [-117.24712, 33.21018], [-117.2451, 33.21017], [-117.2451, 33.20897], [-117.24589, 33.20902], [-117.24596, 33.20884], [-117.24679, 33.20904], [-117.24684, 33.20979], [-117.24714, 33.20982]]]} | Restricted Access 2 | 48224 | Linda Rhoades Recreation Center | 32840 | 3385 | Educational Enrichment Systems Incorporated 983 | Non Profit 6 | Non Profit - Other 22 | http://www.educ-enrichment.org/ | Non Governmental Organization 10 | 2426 | Vista Unified School District 946 | Special District 4 | School District 21 | San Diego 4 | 5.644 | Linda Rhoades Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
15558 | 15558 | 15557 | {"type": "MultiPolygon", "coordinates": [[[[-117.23623, 33.03472], [-117.23609, 33.03514], [-117.23477, 33.03601], [-117.23459, 33.03653], [-117.23385, 33.03634], [-117.23455, 33.03424], [-117.23623, 33.03472]]], [[[-117.23374, 33.03631], [-117.23309, 33.03834], [-117.23296, 33.03831], [-117.23292, 33.03841], [-117.23201, 33.03818], [-117.23209, 33.03792], [-117.23191, 33.03787], [-117.23251, 33.03599], [-117.23374, 33.03631]]]]} | Open Access 1 | 1247 | San Elijo Lagoon Ecological Reserve | 24880 | 3058 | Rancho Santa Fe Community Foundation 1159 | Non Profit 6 | Non Profit - Other 22 | http://www.rsffoundation.org/ | Non Governmental Organization 10 | 3058 | Rancho Santa Fe Community Foundation 1101 | Non Profit 6 | Non Profit - Other 20 | https://www.sanelijo.org/home | San Diego 4 | 14.074 | San Elijo Lagoon ER | 1983 | Private Conservation 16 | 2 |
1595 | 1595 | 1594 | {"type": "Polygon", "coordinates": [[[-117.33591, 33.13338], [-117.33487, 33.13375], [-117.33448, 33.13298], [-117.33535, 33.13267], [-117.3354, 33.13267], [-117.33591, 33.13338]]]} | Open Access 1 | 12167 | Cannon Park | 16804 | 6076 | San Diego Gas and Electric 389 | Private 7 | Utility 21 | http://www.sdge.com/ | Private 14 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/cannon.asp | San Diego 4 | 2.282 | Cannon Park | 0 | Local Park 2 | 4 |
6070 | 6070 | 6069 | {"type": "Polygon", "coordinates": [[[-117.1791, 32.70172], [-117.17896, 32.70196], [-117.17873, 32.70185], [-117.17887, 32.70163], [-117.1791, 32.70172]]]} | Open Access 1 | 808 | Bayview Park | 33708 | 6076 | San Diego Gas and Electric 389 | Private 7 | Utility 21 | http://www.sdge.com/ | Private 14 | 6076 | San Diego Gas and Electric 805 | Private 7 | Utility 29 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3801835 | San Diego 4 | 0.176 | Bayview Park | 0 | Private Recreation or Education 65 | 4 |
1118 | 1118 | 1117 | {"type": "Polygon", "coordinates": [[[-117.15742, 32.70928], [-117.15639, 32.70929], [-117.15639, 32.70847], [-117.15742, 32.70847], [-117.15742, 32.70928]]]} | Restricted Access 2 | 47585 | The Park at Petco Park | 31312 | 6117 | Petco Park Owner 322 | Private 7 | Commercial 20 | http://www.petcoparkinsider.com/park-at-the-park | Private 14 | 6117 | Petco Park Owner 319 | Private 7 | Commercial 18 | http://www.petcoparkinsider.com/park-at-the-park | San Diego 4 | 2.17 | The Park at Petco Park | 0 | Private Recreation or Education 65 | 4 |
3931 | 3931 | 3930 | {"type": "Polygon", "coordinates": [[[-117.15178, 32.71015], [-117.15154, 32.71016], [-117.15154, 32.71036], [-117.15114, 32.71036], [-117.15113, 32.70953], [-117.15178, 32.70953], [-117.15178, 32.71015]]]} | Open Access 1 | 48832 | Fault Line Park | 33551 | 6133 | Pinnacle International Development, Inc 701 | Private 7 | Commercial 20 | http://www.pinnacleinternational.ca/resume | Private 14 | 6133 | Pinnacle International Development, Inc 689 | Private 7 | Commercial 18 | San Diego 4 | 1.249 | Fault Line Park | 0 | Private Recreation or Education 65 | 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]);