units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where AGNCY_LEV = 5 and DES_TP = 2 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, LAYER, MNG_AG_LEV, COUNTY
MNG_AGENCY 10
- Mountains Recreation and Conservation Authority 17
- East Bay Regional Park District 10
- San Diego, City of 2
- Los Angeles, County of 1
- Rosemead, City of 1
- San Fernando, City of 1
- Los Angeles - Department of Parks and Recreation, County of 1
- South Pasadena, City of 1
- Santa Clara County Parks and Recreation Dept., County of 1
- Anderson, City of 1
MNG_AG_TYP 5
ACCESS_TYP 3
DES_TP 1
- Local Park · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
115 | 115 | 114 | {"type": "Polygon", "coordinates": [[[-118.77562, 34.03262], [-118.77533, 34.03337], [-118.77526, 34.03417], [-118.77391, 34.03402], [-118.77397, 34.03297], [-118.77225, 34.0325], [-118.77235, 34.03205], [-118.77242, 34.03192], [-118.7725, 34.03184], [-118.7726, 34.03179], [-118.77271, 34.03175], [-118.77283, 34.03174], [-118.773, 34.03177], [-118.77369, 34.03203], [-118.77383, 34.03206], [-118.77404, 34.03206], [-118.77425, 34.03201], [-118.77476, 34.03219], [-118.77512, 34.0325], [-118.77562, 34.03262]]]} | Open Access 1 | 345 | Escondido Canyon Park | 29611 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 10.379 | Escondido Canyon Park | 0 | Local Park 2 | 4 | |
922 | 922 | 921 | {"type": "Polygon", "coordinates": [[[-118.58834, 34.15325], [-118.58689, 34.15235], [-118.5868, 34.15236], [-118.58641, 34.15142], [-118.58633, 34.14834], [-118.58557, 34.14681], [-118.5847, 34.14741], [-118.58252, 34.14676], [-118.58605, 34.14524], [-118.58832, 34.14524], [-118.58834, 34.15325]]]} | Open Access 1 | 6411 | Serrania Park | 29661 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 48.711 | Serrania Park | 0 | Local Park 2 | 4 | |
1086 | 1086 | 1085 | {"type": "MultiPolygon", "coordinates": [[[[-118.70777, 34.08133], [-118.70681, 34.0813], [-118.70623, 34.08114], [-118.70622, 34.08048], [-118.70776, 34.08048], [-118.70777, 34.08133]]], [[[-118.71107, 34.08337], [-118.71107, 34.08905], [-118.70501, 34.08902], [-118.70468, 34.08872], [-118.70458, 34.08871], [-118.70446, 34.08865], [-118.70384, 34.08818], [-118.70376, 34.08805], [-118.70405, 34.08651], [-118.70448, 34.08541], [-118.70225, 34.08541], [-118.70224, 34.08133], [-118.70325, 34.08192], [-118.70432, 34.0824], [-118.70448, 34.08253], [-118.7046, 34.08271], [-118.70472, 34.08318], [-118.70474, 34.08317], [-118.70472, 34.08304], [-118.70466, 34.08277], [-118.70458, 34.08252], [-118.70455, 34.08244], [-118.70452, 34.08241], [-118.70427, 34.08224], [-118.70329, 34.08181], [-118.70419, 34.08181], [-118.70421, 34.08184], [-118.70436, 34.0818], [-118.7069, 34.08182], [-118.70864, 34.08246], [-118.70839, 34.08293], [-118.7084, 34.08294], [-118.70854, 34.08298], [-118.70879, 34.08252], [-118.71107, 34.08337]]]]} | Open Access 1 | 6475 | Tapia Park | 26185 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 138.571 | Tapia Park | 0 | Local Park 2 | 4 | |
1186 | 1186 | 1185 | {"type": "Polygon", "coordinates": [[[-118.39663, 34.12324], [-118.39662, 34.12739], [-118.39432, 34.12728], [-118.39349, 34.12698], [-118.39288, 34.12624], [-118.39362, 34.12552], [-118.39315, 34.12515], [-118.39309, 34.12519], [-118.39276, 34.12493], [-118.39381, 34.12374], [-118.39484, 34.12323], [-118.39663, 34.12324]]]} | Open Access 1 | 6876 | Fryman Canyon Park | 29621 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 33.114 | Fryman Canyon Park | 0 | Local Park 2 | 4 | |
3621 | 3621 | 3620 | {"type": "Polygon", "coordinates": [[[-122.13468, 38.02843], [-122.13427, 38.02977], [-122.13074, 38.03157], [-122.13026, 38.02906], [-122.13025, 38.02905], [-122.12946, 38.02945], [-122.12902, 38.02716], [-122.12945, 38.02692], [-122.13129, 38.02602], [-122.13153, 38.02637], [-122.13293, 38.02824], [-122.13468, 38.02843]]]} | Open Access 1 | 29404 | Martinez Regional Shoreline | 21926 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 38.97 | Martinez Reg. Shoreline | 1979 | 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 | |
7419 | 7419 | 7418 | {"type": "MultiPolygon", "coordinates": [[[[-118.21146, 34.09879], [-118.21115, 34.09901], [-118.21029, 34.09818], [-118.21037, 34.0981], [-118.21019, 34.09794], [-118.21044, 34.09773], [-118.21054, 34.0978], [-118.21078, 34.0979], [-118.21109, 34.09815], [-118.21137, 34.09856], [-118.21146, 34.09879]]], [[[-118.21383, 34.10142], [-118.21382, 34.10174], [-118.21354, 34.10186], [-118.21353, 34.10171], [-118.2133, 34.10134], [-118.21263, 34.10094], [-118.21266, 34.10092], [-118.21253, 34.10075], [-118.21251, 34.10076], [-118.21242, 34.10048], [-118.21257, 34.10041], [-118.21253, 34.10028], [-118.21246, 34.10017], [-118.21231, 34.10022], [-118.21215, 34.09998], [-118.21181, 34.09966], [-118.21142, 34.09952], [-118.21125, 34.09928], [-118.21127, 34.09904], [-118.21147, 34.09898], [-118.2116, 34.09914], [-118.21263, 34.10009], [-118.21291, 34.10074], [-118.21365, 34.10135], [-118.21371, 34.10147], [-118.21383, 34.10142]]], [[[-118.2138, 34.10064], [-118.21391, 34.10081], [-118.21392, 34.10086], [-118.21386, 34.1012], [-118.21385, 34.10121], [-118.21383, 34.1012], [-118.2136, 34.10071], [-118.2138, 34.10064]]]]} | Open Access 1 | 6859 | Rainbow Canyon Park | 24084 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 4.762 | Rainbow Canyon Park | 0 | Local Park 2 | 4 | |
7447 | 7447 | 7446 | {"type": "MultiPolygon", "coordinates": [[[[-118.22877, 34.08683], [-118.22866, 34.08675], [-118.22875, 34.08668], [-118.22875, 34.08668], [-118.22877, 34.08683]]], [[[-118.22915, 34.08683], [-118.22891, 34.08704], [-118.22889, 34.08693], [-118.22882, 34.08688], [-118.22879, 34.08664], [-118.22885, 34.08659], [-118.22915, 34.08683]]]]} | No Public Access 3 | 6921 | Steelhead Park | 25823 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.219 | Steelhead Park | 0 | Local Park 2 | 4 | |
7833 | 7833 | 7832 | {"type": "Polygon", "coordinates": [[[-118.79535, 34.03826], [-118.79477, 34.03824], [-118.79477, 34.03957], [-118.79361, 34.03957], [-118.7936, 34.03837], [-118.79107, 34.0391], [-118.79255, 34.03838], [-118.79212, 34.0374], [-118.79008, 34.03869], [-118.79052, 34.03807], [-118.7899, 34.03768], [-118.79316, 34.03568], [-118.79317, 34.03571], [-118.7931, 34.03572], [-118.79308, 34.03578], [-118.79312, 34.03582], [-118.7932, 34.03581], [-118.79331, 34.03629], [-118.79429, 34.03684], [-118.79448, 34.03785], [-118.79535, 34.03826]]]} | Open Access 1 | 9327 | Ramirez Canyon Park | 24108 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 21.794 | Ramirez Canyon Park | 0 | Local Park 2 | 4 | |
11442 | 11442 | 11441 | {"type": "Polygon", "coordinates": [[[-118.36175, 33.93255], [-118.36175, 33.93272], [-118.36145, 33.93272], [-118.36146, 33.93255], [-118.36175, 33.93255]]]} | Open Access 1 | 48138 | Lennox Community Garden | 32666 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.127 | Lennox Community Garden | 0 | Local Park 2 | 4 | |
12258 | 12258 | 12257 | {"type": "Polygon", "coordinates": [[[-122.29218, 38.01568], [-122.29031, 38.01802], [-122.28912, 38.01718], [-122.28922, 38.01688], [-122.28938, 38.0167], [-122.28977, 38.01698], [-122.29009, 38.01702], [-122.29019, 38.01671], [-122.2906, 38.0165], [-122.2905, 38.01637], [-122.29193, 38.01586], [-122.29218, 38.01568]]]} | Open Access 1 | 25796 | San Pablo Bay Regional Shoreline | 24965 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 5.337 | San Pablo Bay Reg. Shoreline | 0 | Local Park 2 | 4 | |
13118 | 13118 | 13117 | {"type": "Polygon", "coordinates": [[[-118.32897, 34.10547], [-118.32877, 34.10597], [-118.32865, 34.10616], [-118.32806, 34.1056], [-118.32807, 34.10559], [-118.32819, 34.10555], [-118.32853, 34.1055], [-118.32891, 34.10541], [-118.32895, 34.10543], [-118.32897, 34.10547]]]} | Open Access 1 | 45044 | Franklin Ivar Park | 19059 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.862 | Franklin Ivar Park | 0 | Local Park 2 | 4 | |
14016 | 14016 | 14015 | {"type": "Polygon", "coordinates": [[[-122.24273, 38.04095], [-122.24052, 38.04205], [-122.23951, 38.04221], [-122.2386, 38.04314], [-122.23869, 38.0438], [-122.23841, 38.0441], [-122.23718, 38.04447], [-122.23672, 38.0448], [-122.23549, 38.04464], [-122.23425, 38.04336], [-122.23416, 38.04336], [-122.23416, 38.03632], [-122.23583, 38.03721], [-122.2362, 38.03709], [-122.23681, 38.03857], [-122.23851, 38.03866], [-122.23956, 38.03929], [-122.24273, 38.04095]]]} | No Public Access 3 | 46991 | Crockett Hills Regional Park | 17828 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 91.433 | Crockett Hills RP | 2006 | Local Park 2 | 4 | |
14840 | 14840 | 14839 | {"type": "Polygon", "coordinates": [[[-122.29906, 38.01601], [-122.2989, 38.01618], [-122.29856, 38.0164], [-122.29806, 38.01657], [-122.29759, 38.01661], [-122.29719, 38.01659], [-122.29698, 38.01653], [-122.29624, 38.01624], [-122.29604, 38.01624], [-122.29585, 38.01631], [-122.29558, 38.01677], [-122.29522, 38.01711], [-122.29479, 38.01739], [-122.29463, 38.0176], [-122.29443, 38.01801], [-122.29424, 38.01817], [-122.29281, 38.01923], [-122.29062, 38.01816], [-122.29249, 38.0158], [-122.29332, 38.01483], [-122.2936, 38.01454], [-122.2931, 38.01518], [-122.2931, 38.01523], [-122.29767, 38.01516], [-122.29906, 38.01601]]]} | No Public Access 3 | 45329 | San Pablo Bay Regional Shoreline | 24967 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 38.47 | San Pablo Bay Reg. Shoreline | 1976 | Local Park 2 | 4 | |
15258 | 15258 | 15257 | {"type": "Polygon", "coordinates": [[[-118.22167, 34.10123], [-118.22164, 34.10136], [-118.22162, 34.10133], [-118.2215, 34.10138], [-118.22152, 34.10147], [-118.22133, 34.10152], [-118.22133, 34.10135], [-118.22132, 34.10134], [-118.22045, 34.1016], [-118.22027, 34.1012], [-118.22067, 34.10102], [-118.2211, 34.10072], [-118.22167, 34.10123]]]} | Open Access 1 | 46322 | Elyria Canyon Park | 18607 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.644 | Elyria Canyon Park | 0 | Local Park 2 | 4 | |
15274 | 15274 | 15273 | {"type": "MultiPolygon", "coordinates": [[[[-118.19173, 34.58565], [-118.19103, 34.58551], [-118.1904, 34.58533], [-118.1895, 34.58502], [-118.18939, 34.58496], [-118.18908, 34.58485], [-118.18887, 34.58479], [-118.1877, 34.58437], [-118.18688, 34.58413], [-118.18612, 34.58397], [-118.1856, 34.58389], [-118.18396, 34.58375], [-118.18388, 34.58346], [-118.18505, 34.58383], [-118.18753, 34.58394], [-118.188, 34.58409], [-118.19007, 34.58515], [-118.19026, 34.5852], [-118.19173, 34.5855], [-118.19173, 34.58565]]], [[[-118.19173, 34.58536], [-118.19057, 34.58512], [-118.19014, 34.585], [-118.18974, 34.58482], [-118.18808, 34.58397], [-118.18757, 34.5838], [-118.18508, 34.58369], [-118.18437, 34.58346], [-118.19169, 34.58356], [-118.19173, 34.58536]]], [[[-118.20525, 34.59411], [-118.20445, 34.59379], [-118.20346, 34.59378], [-118.20269, 34.59351], [-118.20236, 34.59342], [-118.20202, 34.5934], [-118.20168, 34.59343], [-118.20135, 34.59352], [-118.2011, 34.59364], [-118.20131, 34.59396], [-118.20091, 34.59424], [-118.20081, 34.59423], [-118.2005, 34.59401], [-118.20007, 34.59378], [-118.20007, 34.59376], [-118.19935, 34.59339], [-118.19872, 34.59313], [-118.19807, 34.59292], [-118.19739, 34.59277], [-118.19694, 34.59271], [-118.19432, 34.59248], [-118.19358, 34.59238], [-118.19309, 34.59228], [-118.19262, 34.59217], [-118.19216, 34.59204], [-118.19168, 34.59188], [-118.19109, 34.59166], [-118.18915, 34.59033], [-118.18934, 34.5902], [-118.18925, 34.58861], [-118.1869, 34.5881], [-118.18565, 34.58738], [-118.18555, 34.5871], [-118.197, 34.58722], [-118.19759, 34.58756], [-118.19845, 34.58814], [-118.2, 34.58932], [-118.2006, 34.58969], [-118.20126, 34.59], [-118.20186, 34.59024], [-118.20219, 34.59032], [-118.20241, 34.59034], [-118.20409, 34.59039], [-118.20491, 34.59051], [-118.20514, 34.59058], [-118.20525, 34.59411]]]]} | Open Access 1 | 46362 | Joshua Ranch | 33248 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 204.37 | Joshua Ranch | 0 | Local Park 2 | 4 | |
15360 | 15360 | 15359 | {"type": "Polygon", "coordinates": [[[-118.08168, 34.07278], [-118.08143, 34.0728], [-118.08143, 34.07246], [-118.08165, 34.07245], [-118.08168, 34.07278]]]} | Open Access 1 | 46551 | Olney Park | 29847 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 0.199 | Olney Park | 0 | Local Park 2 | 4 | |
16836 | 16836 | 16835 | {"type": "Polygon", "coordinates": [[[-121.88013, 38.03876], [-121.8799, 38.03947], [-121.87888, 38.03985], [-121.87938, 38.04057], [-121.87831, 38.04152], [-121.87674, 38.04095], [-121.8754, 38.04202], [-121.87585, 38.04277], [-121.87563, 38.04308], [-121.87538, 38.04357], [-121.87321, 38.04374], [-121.87163, 38.04436], [-121.86986, 38.04524], [-121.86868, 38.04556], [-121.86677, 38.04663], [-121.86586, 38.04647], [-121.86463, 38.04548], [-121.86456, 38.04549], [-121.86457, 38.04022], [-121.869, 38.04023], [-121.86901, 38.03651], [-121.86606, 38.03563], [-121.85991, 38.03561], [-121.85989, 38.04021], [-121.8644, 38.04022], [-121.86438, 38.04552], [-121.8629, 38.0458], [-121.86169, 38.04609], [-121.86089, 38.04681], [-121.86099, 38.04761], [-121.86205, 38.04829], [-121.86179, 38.04832], [-121.86114, 38.04802], [-121.86065, 38.04767], [-121.86064, 38.04741], [-121.86029, 38.04715], [-121.85877, 38.04615], [-121.85643, 38.04435], [-121.85513, 38.04328], [-121.85323, 38.04205], [-121.85256, 38.04052], [-121.85138, 38.03899], [-121.85147, 38.03731], [-121.85092, 38.03582], [-121.85024, 38.03499], [-121.85207, 38.03389], [-121.85368, 38.03368], [-121.85526, 38.03272], [-121.85876, 38.03221], [-121.8607, 38.03229], [-121.86306, 38.03258], [-121.86702, 38.03277], [-121.86921, 38.03335], [-121.87099, 38.03432], [-121.87408, 38.03568], [-121.87734, 38.03749], [-121.87896, 38.03836], [-121.88013, 38.03876]]]} | Restricted Access 2 | 3883 | Browns Island Regional Shoreline | 16445 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 600.69 | Browns Island Reg. Shoreline | 0 | Local Park 2 | 4 | |
16851 | 16851 | 16850 | {"type": "Polygon", "coordinates": [[[-122.30221, 38.01043], [-122.30218, 38.01147], [-122.29662, 38.01164], [-122.29722, 38.01107], [-122.29759, 38.01082], [-122.29803, 38.0106], [-122.29837, 38.01048], [-122.29871, 38.01038], [-122.29928, 38.01029], [-122.29965, 38.01027], [-122.30075, 38.0103], [-122.30221, 38.01038], [-122.30221, 38.01043]]]} | Open Access 1 | 29547 | San Pablo Bay Regional Shoreline | 24965 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 13.84 | San Pablo Bay Reg. Shoreline | 0 | Local Park 2 | 4 | |
11506 | 11506 | 11505 | {"type": "MultiPolygon", "coordinates": [[[[-122.26439, 40.46354], [-122.26186, 40.46573], [-122.26173, 40.46555], [-122.26152, 40.46533], [-122.26093, 40.46456], [-122.26067, 40.46429], [-122.26042, 40.46408], [-122.25979, 40.46373], [-122.25937, 40.46342], [-122.25849, 40.46291], [-122.2574, 40.4625], [-122.25689, 40.46224], [-122.25581, 40.46194], [-122.25528, 40.46176], [-122.25826, 40.45926], [-122.25894, 40.45972], [-122.25774, 40.46074], [-122.25774, 40.46075], [-122.25834, 40.46116], [-122.25955, 40.46015], [-122.26439, 40.46354]]], [[[-122.27724, 40.46773], [-122.27711, 40.46784], [-122.27722, 40.46806], [-122.27378, 40.4691], [-122.27158, 40.47075], [-122.27044, 40.47169], [-122.26905, 40.47272], [-122.26848, 40.47302], [-122.26697, 40.47311], [-122.26542, 40.47269], [-122.2634, 40.47184], [-122.26244, 40.47132], [-122.26088, 40.47093], [-122.25945, 40.47025], [-122.25885, 40.46904], [-122.25868, 40.46843], [-122.26163, 40.46594], [-122.26734, 40.46985], [-122.27317, 40.46493], [-122.27724, 40.46773]]], [[[-122.28086, 40.46807], [-122.27979, 40.46787], [-122.27888, 40.46784], [-122.27965, 40.46719], [-122.27968, 40.4672], [-122.27964, 40.46726], [-122.28086, 40.46807]]]]} | Open Access 1 | 48204 | Anderson River Park | 32743 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1421 | Anderson, City of 602 | City 2 | City Agency 2 | http://cms3.revize.com/revize/andersoncanew/departments/parks.php | Shasta 27 | 212.125 | Anderson River 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]);