units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where DES_TP = 2 and LAYER = 5 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, COUNTY, LABEL_NAME, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3271 | 3271 | 3270 | {"type": "Polygon", "coordinates": [[[-121.96963, 38.04434], [-121.96963, 38.04843], [-121.96528, 38.04832], [-121.96268, 38.04843], [-121.96269, 38.04202], [-121.9663, 38.04288], [-121.96623, 38.04318], [-121.96849, 38.0443], [-121.96963, 38.04434]]]} | Open Access 1 | 29409 | Bay Point Regional Shoreline | 32664 | 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 | https://www.ebparks.org/parks/bay_point/default.htm | Contra Costa 12 | 86.981 | Bay Point Reg. Shoreline | 1996 | 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 | |
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 | |
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 | |
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 | |
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 | |
15359 | 15359 | 15358 | {"type": "MultiPolygon", "coordinates": [[[[-118.40992, 34.11585], [-118.40898, 34.11655], [-118.40899, 34.11679], [-118.40906, 34.1169], [-118.40926, 34.11703], [-118.40975, 34.1171], [-118.40976, 34.11731], [-118.40891, 34.11751], [-118.40833, 34.11817], [-118.40725, 34.11836], [-118.40661, 34.11809], [-118.4057, 34.11848], [-118.40533, 34.1192], [-118.40486, 34.11959], [-118.40486, 34.12029], [-118.40407, 34.12058], [-118.40351, 34.12008], [-118.40357, 34.12005], [-118.40367, 34.12013], [-118.40403, 34.1197], [-118.40457, 34.11926], [-118.40478, 34.11901], [-118.40555, 34.11864], [-118.40565, 34.11843], [-118.40665, 34.118], [-118.40692, 34.11794], [-118.40682, 34.11729], [-118.40717, 34.11675], [-118.40834, 34.11668], [-118.4086, 34.11648], [-118.40853, 34.1161], [-118.40799, 34.11577], [-118.40788, 34.11467], [-118.40983, 34.11435], [-118.40992, 34.11585]]], [[[-118.40964, 34.12285], [-118.40958, 34.1229], [-118.40933, 34.12299], [-118.4091, 34.12312], [-118.40898, 34.12323], [-118.40885, 34.12342], [-118.40846, 34.12311], [-118.4081, 34.12265], [-118.40795, 34.12264], [-118.40907, 34.12141], [-118.40917, 34.12144], [-118.40908, 34.12174], [-118.40905, 34.12193], [-118.40905, 34.12213], [-118.40911, 34.12256], [-118.40918, 34.12266], [-118.40925, 34.12271], [-118.40933, 34.12274], [-118.40951, 34.12276], [-118.40958, 34.12279], [-118.40964, 34.12285]]]]} | Open Access 1 | 46550 | Franklin Canyon Park | 14217 | 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 | http://www.nps.gov/samo/planyourvisit/franklincanyon.htm | Los Angeles 6 | 23.912 | Franklin Canyon Park | 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 | |
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 | |
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 | |
7417 | 7417 | 7416 | {"type": "MultiPolygon", "coordinates": [[[[-118.29284, 34.22715], [-118.29066, 34.22716], [-118.29063, 34.22534], [-118.28845, 34.22535], [-118.28842, 34.22261], [-118.28624, 34.22262], [-118.28622, 34.2217], [-118.29278, 34.22166], [-118.29284, 34.22715]]], [[[-118.29291, 34.23355], [-118.292, 34.23377], [-118.29159, 34.23383], [-118.29113, 34.23385], [-118.29066, 34.23381], [-118.29035, 34.23376], [-118.28933, 34.23349], [-118.2889, 34.23343], [-118.28854, 34.23341], [-118.28852, 34.23267], [-118.28635, 34.23269], [-118.28633, 34.23086], [-118.28851, 34.23084], [-118.28849, 34.22901], [-118.29286, 34.22898], [-118.29291, 34.23355]]], [[[-118.29291, 34.23402], [-118.29284, 34.23415], [-118.29275, 34.23424], [-118.29258, 34.23434], [-118.29245, 34.23437], [-118.29238, 34.23438], [-118.29187, 34.23418], [-118.29241, 34.23393], [-118.29255, 34.23387], [-118.29291, 34.23379], [-118.29291, 34.23402]]]]} | Open Access 1 | 6854 | La Tuna Canyon Park | 7143 | 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 | http://www.lamountains.com/parks.asp?parkid=26 | Los Angeles 6 | 118.186 | La Tuna 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 | |
16849 | 16849 | 16848 | {"type": "Polygon", "coordinates": [[[-122.22677, 37.74529], [-122.22677, 37.74709], [-122.22609, 37.74994], [-122.22601, 37.75017], [-122.22572, 37.75132], [-122.22566, 37.75177], [-122.22545, 37.75267], [-122.22531, 37.75314], [-122.22505, 37.75449], [-122.22486, 37.75528], [-122.2248, 37.75564], [-122.2247, 37.75639], [-122.22455, 37.75706], [-122.22248, 37.75871], [-122.22223, 37.75832], [-122.22166, 37.75833], [-122.22103, 37.75878], [-122.22074, 37.7592], [-122.22071, 37.75919], [-122.22033, 37.75962], [-122.21971, 37.75996], [-122.21902, 37.7605], [-122.21838, 37.76026], [-122.21785, 37.76069], [-122.21784, 37.7607], [-122.21792, 37.76078], [-122.21759, 37.76102], [-122.21696, 37.76048], [-122.21551, 37.7613], [-122.21541, 37.76183], [-122.21436, 37.76065], [-122.21461, 37.7605], [-122.21503, 37.76094], [-122.21591, 37.76038], [-122.21612, 37.75946], [-122.21613, 37.75933], [-122.21602, 37.75906], [-122.21555, 37.75849], [-122.21631, 37.75808], [-122.21615, 37.75803], [-122.21598, 37.75794], [-122.21586, 37.75784], [-122.21578, 37.75771], [-122.21573, 37.75759], [-122.21573, 37.75745], [-122.2158, 37.7573], [-122.21593, 37.75709], [-122.2156, 37.75689], [-122.21556, 37.75671], [-122.21574, 37.75666], [-122.21575, 37.75665], [-122.21566, 37.75652], [-122.21548, 37.75637], [-122.21538, 37.75608], [-122.2152, 37.75601], [-122.21512, 37.75585], [-122.21512, 37.75571], [-122.21507, 37.75558], [-122.21482, 37.75549], [-122.21469, 37.75547], [-122.21439, 37.75561], [-122.21415, 37.75521], [-122.21399, 37.75508], [-122.21384, 37.75499], [-122.21366, 37.75497], [-122.21267, 37.75507], [-122.21142, 37.75331], [-122.21458, 37.75151], [-122.21457, 37.75149], [-122.21281, 37.75156], [-122.21218, 37.75089], [-122.21582, 37.74969], [-122.21245, 37.74314], [-122.20845, 37.74313], [-122.20851, 37.74359], [-122.20795, 37.74294], [-122.20567, 37.74422], [-122.2058, 37.74436], [-122.20712, 37.74363], [-122.20867, 37.74539], [-122.20847, 37.74549], [-122.20697, 37.74377], [-122.20563, 37.74446], [-122.20519, 37.74396], [-122.20737, 37.74276], [-122.20738, 37.74274], [-122.20115, 37.73543], [-122.19921, 37.73326], [-122.1991, 37.73315], [-122.19893, 37.73302], [-122.19882, 37.73296], [-122.19848, 37.73284], [-122.19872, 37.73229], [-122.19878, 37.73218], [-122.19951, 37.73252], [-122.19985, 37.73273], [-122.20736, 37.74128], [-122.20738, 37.74128], [-122.20863, 37.74277], [-122.20917, 37.74243], [-122.20877, 37.74227], [-122.20879, 37.7421], [-122.20873, 37.74177], [-122.20858, 37.74152], [-122.20858, 37.74137], [-122.20865, 37.74108], [-122.20861, 37.74103], [-122.20889, 37.74085], [-122.20916, 37.74064], [-122.20926, 37.74065], [-122.20945, 37.74037], [-122.20973, 37.73942], [-122.20971, 37.73868], [-122.20943, 37.738], [-122.20916, 37.7374], [-122.21013, 37.73678], [-122.20976, 37.73583], [-122.20941, 37.73503], [-122.20881, 37.73357], [-122.20865, 37.7332], [-122.20832, 37.7325], [-122.20812, 37.73219], [-122.20787, 37.73192], [-122.20757, 37.73165], [-122.20732, 37.73101], [-122.20668, 37.73075], [-122.20755, 37.72954], [-122.2101, 37.73094], [-122.21055, 37.73137], [-122.21105, 37.73215], [-122.21278, 37.73589], [-122.21298, 37.73637], [-122.21308, 37.73651], [-122.21952, 37.74448], [-122.21972, 37.74462], [-122.22007, 37.74481], [-122.22046, 37.74502], [-122.22075, 37.74515], [-122.22148, 37.74539], [-122.22197, 37.7454], [-122.22656, 37.74528], [-122.22677, 37.74529]]]} | Open Access 1 | 29417 | MLK Regional Shoreline | 3285 | 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 | http://www.ebparks.org/parks/martinlking | Alameda 17 | 604.945 | MLK Reg. Shoreline | 1976 | 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 | |
13167 | 13167 | 13166 | {"type": "MultiPolygon", "coordinates": [[[[-117.06575, 32.85148], [-117.06108, 32.85142], [-117.05338, 32.85136], [-117.05338, 32.85293], [-117.05221, 32.8528], [-117.05147, 32.85255], [-117.05108, 32.852], [-117.05061, 32.85144], [-117.0501, 32.85094], [-117.0495, 32.85046], [-117.04913, 32.8502], [-117.04868, 32.84993], [-117.04767, 32.84943], [-117.04769, 32.84785], [-117.06406, 32.84798], [-117.06575, 32.85148]]], [[[-117.05339, 32.85425], [-117.0534, 32.85544], [-117.05338, 32.85558], [-117.05244, 32.8541], [-117.05339, 32.85425]]]]} | Open Access 1 | 45149 | Mission Trails Regional Park | 29248 | 221 | San Diego State University 1047 | State 5 | State Agency 5 | http://www.sdsu.edu/ | Other State 5 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.mtrp.org/ | San Diego 4 | 155.468 | Mission Trails RP | 0 | Local Park 2 | 4 |
7241 | 7241 | 7240 | {"type": "MultiPolygon", "coordinates": [[[[-118.53739, 34.13313], [-118.53157, 34.13325], [-118.53157, 34.13088], [-118.53199, 34.13087], [-118.53211, 34.13106], [-118.53222, 34.13116], [-118.53235, 34.13123], [-118.53257, 34.13131], [-118.53273, 34.13133], [-118.53286, 34.13133], [-118.53312, 34.13149], [-118.53349, 34.13164], [-118.53375, 34.13172], [-118.53402, 34.13177], [-118.53442, 34.13179], [-118.53454, 34.13185], [-118.53467, 34.13189], [-118.53488, 34.13191], [-118.53512, 34.13187], [-118.53526, 34.13182], [-118.53538, 34.13174], [-118.53601, 34.13113], [-118.5361, 34.13098], [-118.53633, 34.1309], [-118.53662, 34.13086], [-118.53691, 34.13088], [-118.5371, 34.13094], [-118.53738, 34.13106], [-118.53739, 34.13313]]], [[[-118.56486, 34.13297], [-118.56316, 34.13469], [-118.56295, 34.13455], [-118.56085, 34.13667], [-118.5606, 34.13685], [-118.5603, 34.137], [-118.56009, 34.13706], [-118.55987, 34.13711], [-118.5585, 34.13724], [-118.55818, 34.13731], [-118.55806, 34.13707], [-118.55768, 34.13697], [-118.5576, 34.13691], [-118.55753, 34.13684], [-118.55749, 34.13675], [-118.55725, 34.13596], [-118.55671, 34.13596], [-118.55637, 34.13454], [-118.55633, 34.13422], [-118.55635, 34.13401], [-118.5564, 34.13379], [-118.55653, 34.13349], [-118.55666, 34.13331], [-118.55682, 34.13314], [-118.557, 34.13298], [-118.55731, 34.13279], [-118.55766, 34.13266], [-118.55804, 34.13258], [-118.55843, 34.13257], [-118.56101, 34.13269], [-118.56115, 34.13075], [-118.56138, 34.13078], [-118.56162, 34.13079], [-118.56206, 34.13074], [-118.56224, 34.13074], [-118.56251, 34.13079], [-118.56275, 34.1309], [-118.56288, 34.131], [-118.56454, 34.13248], [-118.5647, 34.13267], [-118.56486, 34.13297]]], [[[-118.57461, 34.13938], [-118.57442, 34.13933], [-118.57435, 34.13928], [-118.5743, 34.13921], [-118.57461, 34.13938]]], [[[-118.5767, 34.13939], [-118.57671, 34.13952], [-118.57676, 34.13972], [-118.57675, 34.1398], [-118.57635, 34.1406], [-118.5763, 34.1408], [-118.57596, 34.14006], [-118.57581, 34.13986], [-118.57562, 34.13969], [-118.57595, 34.13967], [-118.57616, 34.13962], [-118.5767, 34.13939]]], [[[-118.58569, 34.14247], [-118.58537, 34.14244], [-118.58491, 34.14234], [-118.58471, 34.14219], [-118.58456, 34.14211], [-118.58439, 34.14205], [-118.58406, 34.14197], [-118.58392, 34.14188], [-118.58341, 34.14141], [-118.58323, 34.14126], [-118.58291, 34.14107], [-118.58256, 34.14094], [-118.5816, 34.14028], [-118.58121, 34.14005], [-118.58093, 34.13992], [-118.57856, 34.13893], [-118.57785, 34.13868], [-118.57759, 34.13865], [-118.57741, 34.13867], [-118.57725, 34.13871], [-118.57709, 34.13878], [-118.5769, 34.13893], [-118.57617, 34.13925], [-118.57592, 34.13934], [-118.57573, 34.13936], [-118.57546, 34.13935], [-118.57528, 34.13932], [-118.57511, 34.13926], [-118.57413, 34.13873], [-118.57402, 34.13863], [-118.5739, 34.13856], [-118.57375, 34.1385], [-118.57359, 34.13847], [-118.57335, 34.13849], [-118.57208, 34.13873], [-118.57179, 34.13883], [-118.57154, 34.13899], [-118.57092, 34.13917], [-118.57067, 34.13919], [-118.57049, 34.13918], [-118.57031, 34.13915], [-118.57014, 34.13909], [-118.57006, 34.13905], [-118.56968, 34.13848], [-118.56952, 34.13833], [-118.56932, 34.13823], [-118.56916, 34.13819], [-118.569, 34.13818], [-118.56884, 34.13819], [-118.56841, 34.13796], [-118.56831, 34.13775], [-118.56821, 34.13762], [-118.56808, 34.13751], [-118.56793, 34.13743], [-118.56776, 34.13737], [-118.56758, 34.13733], [-118.56741, 34.13732], [-118.56724, 34.13734], [-118.5669, 34.13709], [-118.5667, 34.1369], [-118.56652, 34.1367], [-118.56643, 34.13651], [-118.56626, 34.13635], [-118.56612, 34.136], [-118.56605, 34.13574], [-118.56583, 34.13433], [-118.5659, 34.1342], [-118.56594, 34.13406], [-118.56595, 34.13385], [-118.56589, 34.13365], [-118.56573, 34.13332], [-118.56874, 34.13168], [-118.58139, 34.1365], [-118.5814, 34.13648], [-118.58368, 34.13647], [-118.58368, 34.13715], [-118.58382, 34.13716], [-118.58383, 34.13742], [-118.58568, 34.13813], [-118.58569, 34.14247]]], [[[-118.58569, 34.14299], [-118.58557, 34.14299], [-118.58538, 34.14295], [-118.58527, 34.14289], [-118.58516, 34.14276], [-118.58524, 34.14275], [-118.58569, 34.1428], [-118.58569, 34.14299]]], [[[-118.57569, 34.141], [-118.57511, 34.14315], [-118.57159, 34.14326], [-118.57087, 34.14295], [-118.57069, 34.14157], [-118.569, 34.14107], [-118.56925, 34.13989], [-118.56661, 34.139], [-118.56666, 34.13809], [-118.56682, 34.13808], [-118.56696, 34.13806], [-118.5671, 34.13801], [-118.56731, 34.1379], [-118.5674, 34.13787], [-118.56749, 34.13788], [-118.56772, 34.13799], [-118.56775, 34.13805], [-118.56781, 34.13822], [-118.56789, 34.13836], [-118.56806, 34.13853], [-118.56819, 34.13862], [-118.56835, 34.13869], [-118.5686, 34.13874], [-118.56878, 34.13875], [-118.56898, 34.13873], [-118.56905, 34.13873], [-118.56916, 34.13882], [-118.56968, 34.13961], [-118.56977, 34.13973], [-118.56989, 34.13983], [-118.57003, 34.13992], [-118.57019, 34.13998], [-118.5704, 34.14003], [-118.57062, 34.14003], [-118.57085, 34.14], [-118.57152, 34.13975], [-118.57175, 34.13962], [-118.57208, 34.13933], [-118.57226, 34.13925], [-118.57354, 34.13902], [-118.5736, 34.13907], [-118.57362, 34.13924], [-118.5737, 34.13945], [-118.57385, 34.13964], [-118.57398, 34.13975], [-118.57414, 34.13983], [-118.57431, 34.13989], [-118.57489, 34.13999], [-118.57503, 34.14003], [-118.57516, 34.14009], [-118.57526, 34.14017], [-118.57538, 34.14033], [-118.57569, 34.141]]], [[[-118.5751, 34.14321], [-118.57499, 34.14364], [-118.56847, 34.14354], [-118.56899, 34.14112], [-118.57063, 34.14161], [-118.57081, 34.14296], [-118.57086, 34.14297], [-118.57087, 34.14301], [-118.57158, 34.14331], [-118.5751, 34.14321]]]]} | Open Access 1 | 6410 | Mulholland Gateway Park | 7189 | 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 | http://www.lamountains.com/parks.asp?parkid=34 | Los Angeles 6 | 417.91 | Mulholland Gateway Park | 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 | |
1657 | 1657 | 1656 | {"type": "MultiPolygon", "coordinates": [[[[-118.42001, 34.2954], [-118.41857, 34.29646], [-118.41842, 34.29631], [-118.41952, 34.29551], [-118.41985, 34.29525], [-118.42001, 34.2954]]], [[[-118.42165, 34.2942], [-118.42009, 34.29535], [-118.41992, 34.29519], [-118.42018, 34.29495], [-118.42042, 34.29471], [-118.42115, 34.29381], [-118.42145, 34.29409], [-118.42151, 34.29406], [-118.42165, 34.2942]]]]} | Open Access 1 | 12545 | Pacoima Wash Natural Park | 32523 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 1299 | San Fernando, City of 238 | City 2 | City Agency 2 | https://mrca.ca.gov/parks/park-listing/pacoima-wash-natural-park/ | Los Angeles 6 | 2.83 | Pacoima Wash Natural Park | 2005 | Local Park 2 | 4 |
16846 | 16846 | 16845 | {"type": "Polygon", "coordinates": [[[-122.3802, 37.98427], [-122.38018, 37.9843], [-122.38, 37.98779], [-122.37899, 38.01124], [-122.36814, 38.01604], [-122.36813, 38.01606], [-122.36705, 38.01651], [-122.36244, 38.01648], [-122.34305, 38.00892], [-122.34309, 38.00652], [-122.3432, 38.00305], [-122.34379, 38.00351], [-122.34405, 38.00392], [-122.34436, 38.00449], [-122.34457, 38.00481], [-122.34479, 38.00489], [-122.3448, 38.00488], [-122.34467, 38.00455], [-122.34454, 38.00404], [-122.34462, 38.00376], [-122.34495, 38.00343], [-122.34516, 38.00349], [-122.34534, 38.00367], [-122.34534, 38.00389], [-122.34545, 38.00404], [-122.34568, 38.00396], [-122.34583, 38.00369], [-122.34609, 38.00359], [-122.34652, 38.00353], [-122.34676, 38.00338], [-122.34696, 38.00316], [-122.34827, 38.00323], [-122.3483, 38.00342], [-122.34807, 38.00358], [-122.34784, 38.00369], [-122.34774, 38.00381], [-122.34797, 38.00399], [-122.34825, 38.00407], [-122.34813, 38.00425], [-122.34792, 38.00434], [-122.34756, 38.00438], [-122.34715, 38.00448], [-122.34682, 38.00473], [-122.34674, 38.00501], [-122.34674, 38.00529], [-122.34826, 38.00533], [-122.3497, 38.00568], [-122.35019, 38.0059], [-122.35061, 38.00629], [-122.35087, 38.00669], [-122.35118, 38.00692], [-122.35133, 38.00691], [-122.35138, 38.00653], [-122.35159, 38.0063], [-122.35177, 38.00618], [-122.35226, 38.00618], [-122.35239, 38.0066], [-122.35251, 38.00683], [-122.35277, 38.00677], [-122.35287, 38.00658], [-122.35275, 38.00624], [-122.35274, 38.00595], [-122.35277, 38.00559], [-122.35269, 38.0052], [-122.35282, 38.00512], [-122.35308, 38.00526], [-122.35362, 38.00581], [-122.35383, 38.00599], [-122.35409, 38.0063], [-122.3546, 38.00631], [-122.35488, 38.00617], [-122.35514, 38.00613], [-122.35529, 38.00574], [-122.35529, 38.00531], [-122.35547, 38.00521], [-122.35588, 38.00537], [-122.35614, 38.00558], [-122.35627, 38.00594], [-122.35627, 38.00627], [-122.35597, 38.00651], [-122.35574, 38.0068], [-122.35561, 38.007], [-122.35559, 38.00733], [-122.35576, 38.00737], [-122.35584, 38.00723], [-122.35582, 38.00694], [-122.3561, 38.00684], [-122.35641, 38.00684], [-122.35692, 38.00679], [-122.35728, 38.00659], [-122.35749, 38.00629], [-122.35761, 38.00602], [-122.35803, 38.0059], [-122.35828, 38.00571], [-122.35849, 38.00541], [-122.35874, 38.00536], [-122.35903, 38.00544], [-122.35916, 38.00569], [-122.35916, 38.00593], [-122.35924, 38.00616], [-122.3595, 38.00667], [-122.35948, 38.00681], [-122.35983, 38.00697], [-122.36019, 38.00695], [-122.36056, 38.00711], [-122.36081, 38.00717], [-122.36092, 38.00727], [-122.36089, 38.00744], [-122.36053, 38.00768], [-122.36025, 38.00785], [-122.36013, 38.00799], [-122.36015, 38.00821], [-122.36041, 38.00827], [-122.36082, 38.00829], [-122.36149, 38.00821], [-122.3618, 38.00827], [-122.36265, 38.00835], [-122.36291, 38.00847], [-122.36298, 38.00865], [-122.36286, 38.00882], [-122.3625, 38.0089], [-122.36222, 38.0089], [-122.36217, 38.00898], [-122.3624, 38.00908], [-122.36281, 38.00939], [-122.36322, 38.00977], [-122.36348, 38.01014], [-122.36374, 38.01061], [-122.36372, 38.01085], [-122.36374, 38.01103], [-122.36393, 38.0113], [-122.36403, 38.01154], [-122.36411, 38.01189], [-122.36414, 38.01214], [-122.36421, 38.01242], [-122.3644, 38.01256], [-122.36618, 38.01363], [-122.36723, 38.0128], [-122.36788, 38.00868], [-122.36802, 38.00833], [-122.36808, 38.008], [-122.3681, 38.0077], [-122.37081, 37.99594], [-122.37547, 37.98803], [-122.35736, 37.98888], [-122.35741, 37.98844], [-122.35748, 37.98816], [-122.36111, 37.98801], [-122.36254, 37.9879], [-122.36294, 37.9865], [-122.36416, 37.98461], [-122.36415, 37.98434], [-122.3802, 37.98427]]]} | Open Access 1 | 29400 | Point Pinole Regional Shoreline | 3305 | 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 | http://www.ebparks.org/parks/pt_pinole | Contra Costa 12 | 1125.298 | Point Pinole Reg. Shoreline | 1973 | 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 |
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]);