units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
373 rows where ACCESS_TYP = 3 and GAP_STS = 4 sorted by COUNTY
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, PARK_URL, YR_EST
MNG_AGENCY >30
- Los Angeles, City of 29
- Las Virgenes Municipal Water District 28
- East Bay Regional Park District 27
- Rivers and Lands Conservancy 21
- Mountains Restoration Trust 20
- San Diego, City of 14
- Littlerock Creek Irrigation District 12
- Los Angeles County Flood Control District 11
- California Department of Parks and Recreation 10
- Escondido, City of 10
- Napa, City of 10
- California Department of General Services 8
- Rocklin, City of 8
- Los Angeles - Department of Water and Power, City of 7
- Mountains Recreation and Conservation Authority 6
- San Diego, County of 6
- Kinneloa Irrigation District 5
- East Bay Municipal Utility District 5
- Los Angeles, County of 4
- Napa County Regional Park and Open Space District 4
- Vacaville, City of 4
- San Marcos, City of 4
- Long Beach, City of 4
- Santa Clara County Parks and Recreation Dept., County of 4
- Natomas Basin Conservancy 4
- California Department of Fish and Wildlife 3
- Santa Barbara Flood Control and Water Conserv. District 3
- Other Federal 3
- Rolling Hills, City of 3
- La Verne, City of 3
- …
MNG_AG_TYP 13
DES_TP 12
- Local Recreation Area 113
- Local Other or Unknown 96
- Local Park 77
- Private Recreation or Education 25
- Private Other or Unknown 25
- State Other or Unknown 19
- State Park 5
- Private Agricultural 5
- Federal Other or Unknown 3
- State Historic or Cultural Area 3
- State Recreation Area 1
- Recreation Management Area 1
ACCESS_TYP 1
- No Public Access · 373 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15527 | 15527 | 15526 | {"type": "MultiPolygon", "coordinates": [[[[-119.61418, 35.01952], [-119.61408, 35.02358], [-119.61081, 35.0236], [-119.61082, 35.02714], [-119.60676, 35.02715], [-119.60679, 35.01594], [-119.61076, 35.01594], [-119.61078, 35.01952], [-119.61418, 35.01952]]], [[[-119.59622, 35.03402], [-119.58291, 35.03401], [-119.58292, 35.02938], [-119.58202, 35.02937], [-119.58202, 35.03031], [-119.57855, 35.03029], [-119.57855, 35.02661], [-119.57871, 35.01939], [-119.58747, 35.01945], [-119.58746, 35.03015], [-119.59621, 35.03015], [-119.59622, 35.03402]]], [[[-119.6161, 35.03944], [-119.6138, 35.03944], [-119.61381, 35.03767], [-119.61606, 35.0377], [-119.6161, 35.03944]]], [[[-119.65933, 35.0526], [-119.65498, 35.05258], [-119.65497, 35.04877], [-119.65933, 35.0488], [-119.65933, 35.0526]]], [[[-119.54298, 35.0484], [-119.54297, 35.05512], [-119.53455, 35.05508], [-119.53456, 35.04839], [-119.54298, 35.0484]]], [[[-119.67241, 35.04885], [-119.67241, 35.05626], [-119.668, 35.05625], [-119.668, 35.04883], [-119.67241, 35.04885]]], [[[-119.65499, 35.06265], [-119.65056, 35.06268], [-119.65056, 35.05721], [-119.65498, 35.0572], [-119.65499, 35.06265]]], [[[-119.61562, 35.07044], [-119.61371, 35.07042], [-119.61372, 35.06928], [-119.61537, 35.0703], [-119.61562, 35.07044]]], [[[-119.62277, 35.06694], [-119.62277, 35.07049], [-119.61597, 35.07045], [-119.61373, 35.06908], [-119.61375, 35.06688], [-119.62277, 35.06694]]], [[[-119.66386, 35.07437], [-119.65938, 35.07435], [-119.65937, 35.07068], [-119.66385, 35.07071], [-119.66386, 35.07437]]], [[[-119.65055, 35.07064], [-119.65054, 35.07801], [-119.63159, 35.07808], [-119.63162, 35.07054], [-119.65055, 35.07064]]], [[[-119.70254, 35.17498], [-119.70247, 35.18236], [-119.69363, 35.18233], [-119.6937, 35.17492], [-119.70254, 35.17498]]], [[[-119.71549, 35.15299], [-119.71517, 35.18598], [-119.71296, 35.18599], [-119.71328, 35.15301], [-119.71549, 35.15299]]], [[[-119.80914, 35.21218], [-119.79117, 35.21217], [-119.79123, 35.20472], [-119.79938, 35.20456], [-119.80907, 35.20453], [-119.80914, 35.21218]]], [[[-119.93407, 35.27851], [-119.93405, 35.2821], [-119.92948, 35.28209], [-119.92955, 35.27848], [-119.93407, 35.27851]]], [[[-119.88065, 35.2857], [-119.87618, 35.28571], [-119.87619, 35.27826], [-119.88063, 35.27825], [-119.88065, 35.2857]]], [[[-119.89832, 35.30027], [-119.8805, 35.30024], [-119.88048, 35.29994], [-119.88049, 35.29948], [-119.88046, 35.29481], [-119.88052, 35.29387], [-119.88052, 35.29277], [-119.89829, 35.29287], [-119.89832, 35.30027]]], [[[-119.90275, 35.30571], [-119.89831, 35.30574], [-119.89832, 35.30212], [-119.90273, 35.30208], [-119.90275, 35.30571]]], [[[-119.98726, 35.30787], [-119.98677, 35.31869], [-119.98248, 35.31867], [-119.98256, 35.30773], [-119.98569, 35.30776], [-119.98611, 35.30812], [-119.9869, 35.30748], [-119.98726, 35.30787]]], [[[-120.02291, 35.3223], [-120.00554, 35.32245], [-120.00532, 35.30776], [-120.02289, 35.3077], [-120.02291, 35.3223]]], [[[-119.96473, 35.32586], [-119.96472, 35.32949], [-119.96029, 35.32947], [-119.96032, 35.32582], [-119.96473, 35.32586]]], [[[-120.00405, 35.32975], [-120.00468, 35.33424], [-120.00493, 35.33592], [-120.00511, 35.33693], [-120.00513, 35.33749], [-120.00511, 35.34444], [-120.00516, 35.34697], [-120.00514, 35.35124], [-120.00504, 35.35138], [-120.00211, 35.35135], [-119.99779, 35.35134], [-119.99777, 35.35009], [-119.9962, 35.35008], [-119.99616, 35.34417], [-119.9874, 35.34411], [-119.98732, 35.33683], [-119.98673, 35.33683], [-119.98673, 35.33672], [-119.98679, 35.33669], [-119.98681, 35.33665], [-119.98686, 35.32225], [-119.98967, 35.32224], [-119.99417, 35.3223], [-120.00276, 35.32223], [-120.00312, 35.32431], [-120.00186, 35.32442], [-120.00185, 35.32444], [-120.00209, 35.32578], [-120.00334, 35.3256], [-120.00405, 35.32975]]], [[[-120.02293, 35.33708], [-120.02287, 35.34435], [-120.01414, 35.34429], [-120.01402, 35.35143], [-120.00541, 35.35138], [-120.00529, 35.35125], [-120.00525, 35.34697], [-120.00531, 35.34444], [-120.00532, 35.34331], [-120.00533, 35.33749], [-120.00531, 35.33693], [-120.01458, 35.33701], [-120.01725, 35.33701], [-120.02293, 35.33708]]], [[[-119.95138, 35.35507], [-119.94698, 35.35498], [-119.93368, 35.35493], [-119.93368, 35.3513], [-119.95136, 35.35136], [-119.95138, 35.35507]]], [[[-119.93368, 35.35854], [-119.93369, 35.36591], [-119.93359, 35.3697], [-119.92971, 35.36969], [-119.9298, 35.3585], [-119.93368, 35.35854]]]]} | No Public Access 3 | 48608 | Unnamed site - Sequoia Riverlands Trust | 33321 | 3076 | Sequoia Riverlands Trust 109 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | San Luis Obispo 1 | 5142.858 | 0 | Private Other or Unknown 399 | 4 | ||
8240 | 8240 | 8239 | {"type": "Polygon", "coordinates": [[[-117.74572, 33.72825], [-117.74394, 33.72809], [-117.74363, 33.72833], [-117.74275, 33.72951], [-117.74213, 33.72985], [-117.74125, 33.72999], [-117.73959, 33.72991], [-117.73823, 33.73051], [-117.73759, 33.73049], [-117.73683, 33.73074], [-117.73669, 33.73143], [-117.73626, 33.73167], [-117.73626, 33.73049], [-117.73616, 33.73036], [-117.736, 33.73031], [-117.7355, 33.73039], [-117.73526, 33.73029], [-117.735, 33.7304], [-117.73438, 33.73044], [-117.73392, 33.73009], [-117.73391, 33.72963], [-117.73427, 33.72935], [-117.73452, 33.72924], [-117.73466, 33.72899], [-117.73493, 33.72868], [-117.73564, 33.72826], [-117.73635, 33.7284], [-117.73709, 33.7284], [-117.73756, 33.72741], [-117.73763, 33.72705], [-117.73785, 33.72703], [-117.73826, 33.72767], [-117.73866, 33.72748], [-117.73948, 33.72717], [-117.74028, 33.7268], [-117.74042, 33.72637], [-117.74062, 33.72625], [-117.74099, 33.72663], [-117.74151, 33.7271], [-117.74225, 33.72701], [-117.74242, 33.72904], [-117.74371, 33.72788], [-117.74569, 33.72796], [-117.74572, 33.72825]]]} | No Public Access 3 | 12575 | Rattlesnake Reservoir | 24196 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 58.86 | Rattlesnake Reservoir | 0 | Local Recreation Area 3 | 4 | |
208 | 208 | 207 | {"type": "Polygon", "coordinates": [[[-117.09538, 33.13695], [-117.09362, 33.13752], [-117.09362, 33.1357], [-117.09365, 33.13567], [-117.09379, 33.1356], [-117.0939, 33.13563], [-117.09401, 33.1356], [-117.09406, 33.13557], [-117.09407, 33.13551], [-117.09406, 33.1355], [-117.09382, 33.13558], [-117.09362, 33.13548], [-117.09357, 33.13283], [-117.09348, 33.13177], [-117.09397, 33.13182], [-117.09425, 33.13159], [-117.09432, 33.13154], [-117.09436, 33.13154], [-117.09442, 33.13154], [-117.09451, 33.13179], [-117.09458, 33.13207], [-117.09474, 33.13462], [-117.09453, 33.13534], [-117.09455, 33.13535], [-117.0948, 33.13527], [-117.09484, 33.13577], [-117.09489, 33.13594], [-117.09494, 33.13615], [-117.09502, 33.13635], [-117.09522, 33.13672], [-117.0953, 33.13686], [-117.09538, 33.13695]]]} | No Public Access 3 | 654 | Reidy Canyon Creek | 24281 | 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 | San Diego 4 | 16.798 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
235 | 235 | 234 | {"type": "MultiPolygon", "coordinates": [[[[-117.09432, 33.11987], [-117.09377, 33.1199], [-117.09333, 33.11988], [-117.09298, 33.11971], [-117.09292, 33.11957], [-117.0934, 33.11955], [-117.09432, 33.11987]]], [[[-117.09563, 33.1199], [-117.09552, 33.12002], [-117.09533, 33.1203], [-117.09524, 33.12049], [-117.09521, 33.1206], [-117.09497, 33.12181], [-117.09491, 33.12286], [-117.09486, 33.12319], [-117.09477, 33.12344], [-117.0946, 33.1235], [-117.09447, 33.1232], [-117.09458, 33.12282], [-117.0946, 33.12228], [-117.09473, 33.12119], [-117.09482, 33.12061], [-117.09498, 33.12015], [-117.09521, 33.11975], [-117.09563, 33.1199]]]]} | No Public Access 3 | 684 | Reidy Canyon Creek | 24281 | 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 | San Diego 4 | 4.055 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
236 | 236 | 235 | {"type": "Polygon", "coordinates": [[[-117.09461, 33.12373], [-117.09348, 33.12592], [-117.09308, 33.12668], [-117.09291, 33.12629], [-117.09353, 33.12505], [-117.09345, 33.12492], [-117.09371, 33.12472], [-117.09415, 33.12388], [-117.09461, 33.12373]]]} | No Public Access 3 | 687 | Reidy Canyon Creek | 24281 | 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 | San Diego 4 | 2.732 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
251 | 251 | 250 | {"type": "Polygon", "coordinates": [[[-117.0929, 33.12785], [-117.09258, 33.12797], [-117.09245, 33.12767], [-117.09253, 33.12696], [-117.09276, 33.12662], [-117.09289, 33.12693], [-117.09286, 33.12698], [-117.09278, 33.12727], [-117.09278, 33.12756], [-117.0929, 33.12785]]]} | No Public Access 3 | 683 | Reidy Canyon Creek | 24281 | 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 | San Diego 4 | 0.966 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
1339 | 1339 | 1338 | {"type": "Polygon", "coordinates": [[[-116.73714, 32.58342], [-116.74114, 32.58362], [-116.74116, 32.57636], [-116.73709, 32.57624], [-116.73707, 32.57262], [-116.74115, 32.5727], [-116.74116, 32.5691], [-116.73703, 32.56906], [-116.73696, 32.56738], [-116.75384, 32.56596], [-116.75385, 32.56579], [-116.80114, 32.56182], [-116.80119, 32.56352], [-116.79687, 32.56361], [-116.79696, 32.56738], [-116.78817, 32.56748], [-116.78397, 32.56787], [-116.78402, 32.57978], [-116.77099, 32.58015], [-116.76217, 32.58046], [-116.76212, 32.58426], [-116.75374, 32.58427], [-116.75371, 32.58796], [-116.75367, 32.59538], [-116.74509, 32.59534], [-116.74513, 32.59151], [-116.72846, 32.59121], [-116.72857, 32.58727], [-116.73278, 32.58732], [-116.7329, 32.5834], [-116.73714, 32.58342]]]} | No Public Access 3 | 7398 | Marron Valley Mitigation Bank | 21885 | 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 | 2644.0 | Marron Valley Mitigation Bank | 0 | Local Other or Unknown 14 | 4 | |
3140 | 3140 | 3139 | {"type": "MultiPolygon", "coordinates": [[[[-116.60256, 33.11613], [-116.59824, 33.115], [-116.59824, 33.11394], [-116.60131, 33.11356], [-116.60184, 33.11283], [-116.60185, 33.1129], [-116.6019, 33.11298], [-116.60231, 33.11337], [-116.6024, 33.11349], [-116.60246, 33.1136], [-116.60259, 33.11401], [-116.60286, 33.1151], [-116.60287, 33.11531], [-116.60283, 33.11554], [-116.60272, 33.11583], [-116.60256, 33.11613]]], [[[-116.60241, 33.11223], [-116.60228, 33.11229], [-116.6022, 33.11232], [-116.60227, 33.11223], [-116.60241, 33.11223]]]]} | No Public Access 3 | 25800 | San Dieguito River Park | 24870 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 22.717 | San Dieguito River Park | 0 | Private Recreation or Education 65 | 4 | |
3421 | 3421 | 3420 | {"type": "Polygon", "coordinates": [[[-116.96658, 32.84974], [-116.96647, 32.85215], [-116.96564, 32.85215], [-116.965, 32.85221], [-116.96414, 32.85224], [-116.96351, 32.8521], [-116.96347, 32.85208], [-116.96345, 32.85204], [-116.96339, 32.85204], [-116.9634, 32.85153], [-116.96338, 32.85152], [-116.9634, 32.85046], [-116.96343, 32.85045], [-116.96343, 32.84995], [-116.96658, 32.84974]]]} | No Public Access 3 | 25131 | Radio Towers Park | 24070 | 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 | 18.699 | Radio Towers Park | 0 | Local Park 2 | 4 | |
3744 | 3744 | 3743 | {"type": "Polygon", "coordinates": [[[-117.00555, 32.56116], [-117.00554, 32.56472], [-117.00446, 32.56471], [-117.00445, 32.56601], [-117.00443, 32.56603], [-117.00418, 32.566], [-117.00401, 32.56588], [-117.00338, 32.56582], [-117.00337, 32.56469], [-117.00123, 32.56466], [-117.00126, 32.56109], [-117.00555, 32.56116]]]} | No Public Access 3 | 44877 | Anderprises TransNet Environmental Mitigation | 32283 | 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 | 42.881 | Anderprises TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
3798 | 3798 | 3797 | {"type": "MultiPolygon", "coordinates": [[[[-116.9578, 33.32443], [-116.94941, 33.3289], [-116.94271, 33.33233], [-116.93544, 33.32958], [-116.92862, 33.32705], [-116.91095, 33.32034], [-116.90797, 33.31919], [-116.91534, 33.31418], [-116.92002, 33.31102], [-116.92765, 33.31311], [-116.92793, 33.31298], [-116.92835, 33.31273], [-116.92842, 33.31228], [-116.929, 33.31186], [-116.92931, 33.31159], [-116.92979, 33.31131], [-116.93077, 33.311], [-116.93042, 33.31167], [-116.92952, 33.31213], [-116.92917, 33.31283], [-116.92805, 33.31344], [-116.92704, 33.31409], [-116.92582, 33.31491], [-116.92483, 33.31573], [-116.92386, 33.31674], [-116.92361, 33.31727], [-116.92383, 33.31777], [-116.92675, 33.31811], [-116.93088, 33.31862], [-116.93485, 33.318], [-116.93823, 33.31644], [-116.93821, 33.31671], [-116.93823, 33.31709], [-116.9382, 33.31734], [-116.93815, 33.31744], [-116.93808, 33.31751], [-116.93778, 33.31765], [-116.93785, 33.31774], [-116.93818, 33.31759], [-116.93827, 33.31749], [-116.93832, 33.31739], [-116.93836, 33.31715], [-116.93834, 33.31671], [-116.93837, 33.31633], [-116.94031, 33.31541], [-116.94087, 33.31561], [-116.94023, 33.31693], [-116.94024, 33.31695], [-116.94325, 33.31647], [-116.94478, 33.31671], [-116.94578, 33.31681], [-116.94575, 33.31803], [-116.94491, 33.31761], [-116.94483, 33.31757], [-116.94482, 33.31758], [-116.94292, 33.32426], [-116.95073, 33.32383], [-116.9542, 33.32362], [-116.9578, 33.32443]]], [[[-116.92717, 33.31458], [-116.92717, 33.31471], [-116.927, 33.31471], [-116.927, 33.31458], [-116.92717, 33.31458]]]]} | No Public Access 3 | 45133 | YMWD Open Space | 27772 | 2320 | Yuima Municipal Water District 684 | Special District 4 | Water District 13 | http://www.yuimamwd.com/ | Special District 4 | 2320 | Yuima Municipal Water District 675 | Special District 4 | Water District 13 | San Diego 4 | 1090.211 | YMWD OS | 0 | Local Recreation Area 3 | 4 | |
3822 | 3822 | 3821 | {"type": "MultiPolygon", "coordinates": [[[[-117.16091, 33.13937], [-117.15846, 33.14101], [-117.15822, 33.14036], [-117.15821, 33.14035], [-117.15831, 33.14084], [-117.1584, 33.14105], [-117.15769, 33.14153], [-117.1577, 33.14159], [-117.15715, 33.14168], [-117.15661, 33.14181], [-117.15656, 33.14167], [-117.15663, 33.14161], [-117.15665, 33.14152], [-117.15663, 33.14145], [-117.15659, 33.14141], [-117.15691, 33.14112], [-117.15709, 33.14098], [-117.15796, 33.14043], [-117.16037, 33.13882], [-117.16091, 33.13937]]], [[[-117.16212, 33.13866], [-117.16175, 33.13905], [-117.16107, 33.13923], [-117.1605, 33.13865], [-117.16073, 33.13857], [-117.1615, 33.13836], [-117.16206, 33.1385], [-117.16212, 33.13866]]]]} | No Public Access 3 | 45235 | San Marcos City Open Space | 24944 | 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 | 10.993 | San Marcos City OS | 0 | Local Recreation Area 3 | 4 | |
3826 | 3826 | 3825 | {"type": "Polygon", "coordinates": [[[-117.046, 33.25229], [-117.0459, 33.25362], [-117.04581, 33.25622], [-117.04584, 33.25988], [-117.04315, 33.25987], [-117.04304, 33.25622], [-117.04149, 33.2562], [-117.04135, 33.25228], [-117.046, 33.25229]]]} | No Public Access 3 | 45243 | Valley Center MWDD Open Space | 26786 | 2321 | Valley Center Water District 689 | Special District 4 | Water District 13 | http://www.vcmwd.org/ | Special District 4 | 2321 | Valley Center Water District 672 | Special District 4 | Water District 13 | San Diego 4 | 70.32 | Valley Ctr. MWDD OS | 0 | Local Recreation Area 3 | 4 | |
3846 | 3846 | 3845 | {"type": "Polygon", "coordinates": [[[-117.22388, 32.93759], [-117.22376, 32.93764], [-117.22348, 32.9376], [-117.22333, 32.93761], [-117.22215, 32.93794], [-117.22194, 32.93802], [-117.22151, 32.93822], [-117.22151, 32.93456], [-117.22388, 32.93457], [-117.22388, 32.93759]]]} | No Public Access 3 | 46811 | Neighborhood 8 Neighborhood Park | 30272 | 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 | 19.773 | Neighborhood 8 Neighborhood Park | 0 | Local Park 2 | 4 | |
3891 | 3891 | 3890 | {"type": "Polygon", "coordinates": [[[-117.09429, 33.13135], [-117.094, 33.13143], [-117.09383, 33.13102], [-117.09403, 33.13085], [-117.09407, 33.13095], [-117.09412, 33.13095], [-117.09429, 33.13135]]]} | No Public Access 3 | 642 | Reidy Canyon Creek | 24281 | 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 | San Diego 4 | 0.372 | Reidy Canyon Creek | 0 | Local Other or Unknown 14 | 4 | |
4532 | 4532 | 4531 | {"type": "MultiPolygon", "coordinates": [[[[-117.21241, 32.80723], [-117.21239, 32.80731], [-117.21232, 32.80734], [-117.2111, 32.80742], [-117.21111, 32.80697], [-117.21157, 32.80696], [-117.21172, 32.80698], [-117.21219, 32.80709], [-117.21237, 32.80716], [-117.21241, 32.80723]]], [[[-117.21219, 32.80689], [-117.21219, 32.80695], [-117.21195, 32.80689], [-117.21219, 32.80689], [-117.21219, 32.80689]]]]} | No Public Access 3 | 18410 | Unnamed site - San Diego, City of | 31719 | 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 | 1.217 | 0 | Local Other or Unknown 14 | 4 | ||
4535 | 4535 | 4534 | {"type": "Polygon", "coordinates": [[[-117.23982, 32.87111], [-117.23981, 32.87152], [-117.23927, 32.87152], [-117.23951, 32.87136], [-117.23982, 32.87111]]]} | No Public Access 3 | 19896 | Unnamed site - San Diego, City of | 31719 | 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.273 | 0 | Local Other or Unknown 14 | 4 | ||
4536 | 4536 | 4535 | {"type": "Polygon", "coordinates": [[[-117.1276, 32.76738], [-117.12717, 32.76784], [-117.12705, 32.76778], [-117.12742, 32.76738], [-117.1276, 32.76738]]]} | No Public Access 3 | 19905 | Unnamed site - San Diego, City of | 31719 | 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.196 | 0 | Local Other or Unknown 14 | 4 | ||
4537 | 4537 | 4536 | {"type": "Polygon", "coordinates": [[[-117.10461, 32.76969], [-117.10445, 32.76969], [-117.10461, 32.76951], [-117.10461, 32.76969], [-117.10461, 32.76969]]]} | No Public Access 3 | 19907 | Unnamed site - San Diego, City of | 31719 | 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.035 | 0 | Local Other or Unknown 14 | 4 | ||
4785 | 4785 | 4784 | {"type": "Polygon", "coordinates": [[[-117.23137, 32.88833], [-117.22878, 32.89057], [-117.22879, 32.89385], [-117.22675, 32.89645], [-117.22675, 32.89619], [-117.22726, 32.89551], [-117.22708, 32.8954], [-117.22721, 32.89514], [-117.22753, 32.89435], [-117.22772, 32.89381], [-117.22795, 32.89294], [-117.22797, 32.89271], [-117.22797, 32.89157], [-117.22795, 32.89107], [-117.22798, 32.89083], [-117.22816, 32.89009], [-117.22833, 32.89009], [-117.22872, 32.88902], [-117.22917, 32.88808], [-117.22989, 32.8883], [-117.23011, 32.88786], [-117.23073, 32.88808], [-117.23137, 32.88833]]]} | No Public Access 3 | 47655 | Unnamed site - San Diego, City of | 31719 | 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 | 20.801 | 0 | Local Other or Unknown 14 | 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]);