units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 120
- Los Angeles, City of 69
- Mountains Recreation and Conservation Authority 39
- San Francisco, City and County of 30
- Conejo Open Space Conservation Agency 28
- Los Angeles, County of 24
- East Bay Regional Park District 22
- Las Virgenes Municipal Water District 22
- Davis, City of 20
- San Luis Obispo, City of 18
- Long Beach, City of 17
- Santa Clarita, City of 17
- Glendale, City of 15
- Thousand Oaks, City of 14
- Sacramento, City of 14
- Santa Cruz, City of 13
- Santa Barbara, County of 12
- San Jose, City of 12
- Vacaville, City of 12
- Tiburon, Town of 12
- Sunrise Recreation and Park District 12
- Los Angeles - Department of Parks and Recreation, County of 11
- Oakland, City of 10
- San Marcos, City of 10
- Littlerock Creek Irrigation District 10
- Poway, City of 9
- Sacramento, County of 9
- Mission Viejo, City of 8
- East Bay Municipal Utility District 8
- Roseville, City of 8
- …
MNG_AG_TYP 17
- City Agency 901
- Recreation/Parks District 123
- County Agency 81
- Open Space District 68
- Water District 53
- County Agency - Parks 25
- Irrigation District 20
- Community Services District 11
- Flood District 5
- County Agency - Other 4
- School District 3
- Special District - Other 2
- Cemetery District 1
- Port/Harbor District 1
- Sanitation District 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 1,043
- Restricted Access 168
- No Public Access 80
- Unknown Access 10
DES_TP 1
- Local Recreation Area · 1,301 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7242 | 7242 | 7241 | {"type": "Polygon", "coordinates": [[[-118.57098, 34.15161], [-118.5709, 34.1527], [-118.57041, 34.15261], [-118.57021, 34.15331], [-118.56909, 34.15368], [-118.56414, 34.15241], [-118.56436, 34.1514], [-118.56346, 34.15075], [-118.56364, 34.14998], [-118.566, 34.15044], [-118.57098, 34.15161]]]} | Open Access 1 | 6415 | Corbin Canyon Open Space | 17634 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 40.214 | Corbin Canyon OS | 0 | Local Recreation Area 3 | 4 | |
7251 | 7251 | 7250 | {"type": "Polygon", "coordinates": [[[-121.92994, 37.74522], [-121.92625, 37.74667], [-121.92569, 37.74579], [-121.92458, 37.74623], [-121.92512, 37.74711], [-121.92071, 37.74637], [-121.92092, 37.7457], [-121.92094, 37.7455], [-121.92092, 37.74535], [-121.921, 37.74482], [-121.9211, 37.7447], [-121.9213, 37.74459], [-121.92141, 37.74449], [-121.92146, 37.7444], [-121.92148, 37.74426], [-121.92136, 37.74378], [-121.92055, 37.74282], [-121.9205, 37.74268], [-121.92049, 37.74258], [-121.92053, 37.7422], [-121.92061, 37.74194], [-121.92088, 37.74171], [-121.9209, 37.74166], [-121.92086, 37.74144], [-121.921, 37.74106], [-121.92102, 37.74085], [-121.92096, 37.74024], [-121.92146, 37.73929], [-121.92181, 37.73883], [-121.92232, 37.73901], [-121.92245, 37.73928], [-121.92249, 37.73962], [-121.92256, 37.73977], [-121.92257, 37.73977], [-121.92276, 37.73954], [-121.92277, 37.73957], [-121.92258, 37.73982], [-121.9226, 37.73986], [-121.92258, 37.74002], [-121.9226, 37.74014], [-121.9227, 37.7404], [-121.92283, 37.74054], [-121.92298, 37.74068], [-121.92344, 37.74066], [-121.92396, 37.74073], [-121.92441, 37.74073], [-121.9246, 37.74075], [-121.9248, 37.74079], [-121.92491, 37.74089], [-121.92502, 37.74095], [-121.92519, 37.74109], [-121.92534, 37.74126], [-121.92543, 37.74145], [-121.92548, 37.74167], [-121.92547, 37.74189], [-121.92553, 37.74205], [-121.92563, 37.74213], [-121.92575, 37.74238], [-121.9259, 37.74263], [-121.92617, 37.74292], [-121.92625, 37.74304], [-121.92638, 37.74333], [-121.92669, 37.74351], [-121.92698, 37.74389], [-121.92725, 37.74414], [-121.92715, 37.74428], [-121.92706, 37.74444], [-121.92692, 37.74464], [-121.92691, 37.74469], [-121.92692, 37.74481], [-121.92801, 37.74475], [-121.92843, 37.74481], [-121.92869, 37.74482], [-121.92892, 37.74479], [-121.9294, 37.74467], [-121.92994, 37.74522]]]} | Open Access 1 | 48920 | Dougherty Valley Ridge Trail | 33643 | 2300 | Geologic Hazard Abatement District (San Ramon) 853 | Special District 4 | Special District - Other 26 | http://www.sanramon.ca.gov/engr/ghad.html | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 89.586 | Dougherty Valley Ridge Trail | 0 | Local Recreation Area 3 | 4 |
7252 | 7252 | 7251 | {"type": "Polygon", "coordinates": [[[-118.10792, 33.88199], [-118.10716, 33.882], [-118.10715, 33.88191], [-118.10454, 33.88194], [-118.10453, 33.88189], [-118.10437, 33.88189], [-118.10433, 33.88166], [-118.10432, 33.88045], [-118.10422, 33.88025], [-118.10504, 33.88024], [-118.1051, 33.87876], [-118.10616, 33.87877], [-118.10629, 33.88012], [-118.10716, 33.88009], [-118.10714, 33.87968], [-118.10709, 33.87933], [-118.10649, 33.87707], [-118.10742, 33.87714], [-118.10767, 33.87811], [-118.10775, 33.87855], [-118.10785, 33.87922], [-118.10789, 33.87966], [-118.10791, 33.88021], [-118.10771, 33.88022], [-118.10771, 33.88026], [-118.10791, 33.88027], [-118.10792, 33.88199]]]} | Restricted Access 2 | 20050 | Cerritos Iron Wood Nine Golf Course | 33069 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | http://www.cerritos.us/RESIDENTS/recreation/facilities/iron_wood_nine_golf_course.php | Los Angeles 6 | 26.76 | Cerritos Iron Wood Nine GC | 0 | Local Recreation Area 3 | 4 |
7254 | 7254 | 7253 | {"type": "MultiPolygon", "coordinates": [[[[-121.92276, 37.73954], [-121.92256, 37.73979], [-121.92249, 37.73962], [-121.92245, 37.73928], [-121.92232, 37.73901], [-121.92181, 37.73883], [-121.92146, 37.73929], [-121.92096, 37.74024], [-121.92102, 37.74085], [-121.921, 37.74106], [-121.92086, 37.74144], [-121.9209, 37.74166], [-121.92088, 37.74171], [-121.92061, 37.74195], [-121.92053, 37.7422], [-121.92049, 37.74258], [-121.9205, 37.74268], [-121.92053, 37.74278], [-121.92058, 37.74286], [-121.92136, 37.74378], [-121.92147, 37.74422], [-121.92148, 37.74431], [-121.92146, 37.7444], [-121.92138, 37.74453], [-121.9213, 37.74459], [-121.9211, 37.7447], [-121.921, 37.74482], [-121.92092, 37.74535], [-121.92094, 37.7455], [-121.92092, 37.7457], [-121.92071, 37.74637], [-121.91927, 37.74613], [-121.91968, 37.74602], [-121.91984, 37.74603], [-121.92007, 37.7457], [-121.92025, 37.74584], [-121.92066, 37.74583], [-121.92071, 37.74569], [-121.92042, 37.74544], [-121.92047, 37.74537], [-121.92045, 37.74529], [-121.92075, 37.74515], [-121.92082, 37.74491], [-121.92083, 37.7446], [-121.92073, 37.7445], [-121.92078, 37.74446], [-121.9208, 37.7444], [-121.92088, 37.7444], [-121.92123, 37.74428], [-121.9212, 37.74406], [-121.92109, 37.74379], [-121.9207, 37.74358], [-121.92073, 37.74349], [-121.92068, 37.74342], [-121.92078, 37.74333], [-121.92065, 37.74309], [-121.91977, 37.74301], [-121.91985, 37.74232], [-121.9201, 37.74232], [-121.92032, 37.74197], [-121.92017, 37.74139], [-121.92017, 37.74113], [-121.92062, 37.74071], [-121.92054, 37.74037], [-121.92035, 37.74031], [-121.92036, 37.74026], [-121.92035, 37.74022], [-121.92058, 37.74012], [-121.92075, 37.73983], [-121.92098, 37.73938], [-121.92089, 37.73929], [-121.92106, 37.73914], [-121.9213, 37.73889], [-121.9215, 37.73864], [-121.92162, 37.73848], [-121.92173, 37.73867], [-121.92185, 37.7385], [-121.92201, 37.73855], [-121.92228, 37.73867], [-121.92246, 37.73881], [-121.92256, 37.73893], [-121.92262, 37.73906], [-121.92276, 37.73954]]], [[[-121.92287, 37.73974], [-121.9226, 37.73986], [-121.92258, 37.73982], [-121.92277, 37.73957], [-121.92287, 37.73974]]]]} | Open Access 1 | 48921 | Dougherty Valley Ridge Trail | 33643 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 10.256 | Dougherty Valley Ridge Trail | 0 | Local Recreation Area 3 | 4 |
7255 | 7255 | 7254 | {"type": "Polygon", "coordinates": [[[-121.92427, 37.74849], [-121.92332, 37.74921], [-121.92193, 37.74844], [-121.91908, 37.7461], [-121.92388, 37.7469], [-121.92427, 37.74849]]]} | Open Access 1 | 48922 | Dougherty Valley Ridge Trail | 33643 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 17.382 | Dougherty Valley Ridge Trail | 0 | Local Recreation Area 3 | 4 |
7256 | 7256 | 7255 | {"type": "Polygon", "coordinates": [[[-118.65889, 34.09126], [-118.65889, 34.09173], [-118.6584, 34.09174], [-118.65839, 34.09126], [-118.65889, 34.09126]]]} | No Public Access 3 | 6445 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.59 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
7261 | 7261 | 7260 | {"type": "Polygon", "coordinates": [[[-118.83515, 34.23259], [-118.83311, 34.24265], [-118.82882, 34.24621], [-118.81532, 34.23954], [-118.81766, 34.23382], [-118.81607, 34.2271], [-118.81847, 34.22638], [-118.8202, 34.22678], [-118.82229, 34.22626], [-118.82297, 34.22618], [-118.82348, 34.22618], [-118.82412, 34.22632], [-118.82474, 34.22653], [-118.82541, 34.22649], [-118.82606, 34.22664], [-118.83021, 34.22816], [-118.8305, 34.22913], [-118.83515, 34.23259]]]} | Restricted Access 2 | 49003 | Calleguas Municipal Water District Open Space | 33702 | 2441 | Calleguas Municipal Water District 855 | Special District 4 | Water District 13 | http://www.calleguas.com/ | Special District 4 | 2441 | Calleguas Municipal Water District 833 | Special District 4 | Water District 13 | Ventura 8 | 702.738 | Calleguas Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
7270 | 7270 | 7269 | {"type": "Polygon", "coordinates": [[[-121.93454, 37.26366], [-121.93454, 37.26383], [-121.93449, 37.26388], [-121.93447, 37.26395], [-121.93446, 37.2643], [-121.93449, 37.26439], [-121.93448, 37.26468], [-121.9316, 37.2647], [-121.9316, 37.26461], [-121.93187, 37.26459], [-121.93183, 37.26378], [-121.93196, 37.2638], [-121.93212, 37.26384], [-121.93211, 37.26389], [-121.93241, 37.26393], [-121.93261, 37.26393], [-121.93285, 37.26391], [-121.93302, 37.26387], [-121.93309, 37.26392], [-121.9331, 37.26427], [-121.93378, 37.26427], [-121.93379, 37.26407], [-121.93376, 37.26406], [-121.93375, 37.26376], [-121.93367, 37.26376], [-121.93365, 37.26359], [-121.93396, 37.26359], [-121.93396, 37.26373], [-121.93439, 37.26372], [-121.9344, 37.26367], [-121.93454, 37.26366]]]} | Open Access 1 | 6499 | Camden Park Center | 16755 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.013 | Camden Park Ctr. | 1961 | Local Recreation Area 3 | 4 | |
7271 | 7271 | 7270 | {"type": "MultiPolygon", "coordinates": [[[[-118.01971, 33.9463], [-118.01948, 33.94639], [-118.0187, 33.94601], [-118.0188, 33.94587], [-118.01971, 33.9463]]], [[[-118.02441, 33.94909], [-118.02429, 33.94915], [-118.02312, 33.94833], [-118.02309, 33.94835], [-118.02273, 33.94811], [-118.02217, 33.94776], [-118.02113, 33.94717], [-118.01977, 33.94652], [-118.01997, 33.94642], [-118.0218, 33.94729], [-118.02441, 33.94909]]], [[[-118.02875, 33.95205], [-118.02866, 33.9521], [-118.02863, 33.95209], [-118.02683, 33.95086], [-118.02585, 33.9502], [-118.02583, 33.95021], [-118.02442, 33.94925], [-118.02455, 33.94918], [-118.02875, 33.95205]]], [[[-118.0343, 33.95582], [-118.03418, 33.95593], [-118.02874, 33.95219], [-118.02897, 33.95206], [-118.03424, 33.95571], [-118.03423, 33.95572], [-118.0343, 33.95577], [-118.0343, 33.95582]]], [[[-118.03717, 33.95872], [-118.03703, 33.95885], [-118.03668, 33.95829], [-118.03638, 33.95788], [-118.03613, 33.95758], [-118.0359, 33.95733], [-118.03546, 33.9569], [-118.03488, 33.95643], [-118.03434, 33.95604], [-118.03443, 33.95594], [-118.03449, 33.95593], [-118.03464, 33.95603], [-118.03588, 33.95693], [-118.03583, 33.957], [-118.03629, 33.95748], [-118.03652, 33.95776], [-118.03685, 33.9582], [-118.03717, 33.95872]]], [[[-118.03931, 33.96332], [-118.03916, 33.96347], [-118.03773, 33.96032], [-118.03718, 33.95913], [-118.03732, 33.95899], [-118.03752, 33.95938], [-118.03931, 33.96332]]], [[[-118.04156, 33.96787], [-118.04144, 33.96798], [-118.04115, 33.9678], [-118.04095, 33.96749], [-118.04066, 33.96694], [-118.03923, 33.96375], [-118.03947, 33.96351], [-118.04096, 33.96681], [-118.04132, 33.96748], [-118.04156, 33.96787]]], [[[-118.04196, 33.96851], [-118.04195, 33.96896], [-118.04149, 33.96827], [-118.04163, 33.96827], [-118.04186, 33.96837], [-118.04196, 33.96851]]], [[[-118.04487, 33.9734], [-118.0447, 33.97344], [-118.04446, 33.97273], [-118.04436, 33.97272], [-118.04389, 33.97181], [-118.04218, 33.9693], [-118.0422, 33.96892], [-118.04223, 33.96892], [-118.04482, 33.97273], [-118.04459, 33.97273], [-118.04487, 33.9734]]], [[[-118.04525, 33.97459], [-118.04524, 33.97537], [-118.04508, 33.97537], [-118.04508, 33.97499], [-118.04498, 33.97459], [-118.04478, 33.97363], [-118.04476, 33.97359], [-118.04494, 33.97354], [-118.04499, 33.97363], [-118.04511, 33.97393], [-118.04506, 33.97395], [-118.04518, 33.97451], [-118.04509, 33.97452], [-118.04509, 33.97453], [-118.04525, 33.97454], [-118.04525, 33.97459]]], [[[-118.04667, 33.97726], [-118.04666, 33.97899], [-118.04648, 33.97899], [-118.04643, 33.97793], [-118.04625, 33.97792], [-118.04626, 33.97744], [-118.0462, 33.97719], [-118.04612, 33.97704], [-118.04609, 33.97704], [-118.04605, 33.97698], [-118.04598, 33.97698], [-118.04591, 33.97681], [-118.04549, 33.97617], [-118.04519, 33.97553], [-118.04531, 33.97554], [-118.04612, 33.97674], [-118.04615, 33.97674], [-118.04648, 33.97726], [-118.04667, 33.97726]]], [[[-118.0466, 33.97922], [-118.0466, 33.97959], [-118.04643, 33.9796], [-118.04643, 33.97921], [-118.0466, 33.97922]]], [[[-118.0466, 33.98071], [-118.04651, 33.98046], [-118.04647, 33.98028], [-118.04646, 33.98001], [-118.04647, 33.97965], [-118.0466, 33.97965], [-118.0466, 33.98071]]], [[[-118.04847, 33.98263], [-118.04817, 33.98262], [-118.0478, 33.98224], [-118.04779, 33.98214], [-118.04774, 33.98209], [-118.04768, 33.98209], [-118.04727, 33.98167], [-118.04725, 33.98168], [-118.0469, 33.98132], [-118.04673, 33.98109], [-118.04674, 33.98097], [-118.04693, 33.98097], [-118.04698, 33.98107], [-118.04714, 33.98127], [-118.04847, 33.98263]]], [[[-118.05016, 33.98446], [-118.04996, 33.98445], [-118.04937, 33.98386], [-118.04936, 33.98382], [-118.04841, 33.98285], [-118.04867, 33.98285], [-118.04936, 33.98354], [-118.04936, 33.98359], [-118.05014, 33.98437], [-118.05016, 33.9844], [-118.05016, 33.98446]]], [[[-118.05017, 33.98468], [-118.0501, 33.98461], [-118.05003, 33.98454], [-118.05016, 33.98453], [-118.05017, 33.98468]]], [[[-118.05456, 33.98908], [-118.05248, 33.98697], [-118.05247, 33.987], [-118.05037, 33.98487], [-118.05037, 33.98457], [-118.05301, 33.98724], [-118.05298, 33.98726], [-118.05304, 33.98731], [-118.05456, 33.98886], [-118.05456, 33.98908]]], [[[-118.05979, 33.99413], [-118.05964, 33.99427], [-118.05961, 33.99425], [-118.05543, 33.99001], [-118.05476, 33.98932], [-118.05476, 33.98901], [-118.05979, 33.99413]]], [[[-118.06622, 33.99876], [-118.06611, 33.99887], [-118.06562, 33.99842], [-118.06564, 33.99839], [-118.06513, 33.998], [-118.06432, 33.99751], [-118.06305, 33.99675], [-118.06303, 33.99677], [-118.06164, 33.99595], [-118.06104, 33.99554], [-118.06045, 33.99509], [-118.06004, 33.99473], [-118.05975, 33.99437], [-118.05987, 33.99425], [-118.06005, 33.99448], [-118.06015, 33.99457], [-118.06134, 33.99559], [-118.06214, 33.99609], [-118.06226, 33.99612], [-118.06225, 33.99614], [-118.0651, 33.99784], [-118.0655, 33.99813], [-118.06582, 33.99838], [-118.06622, 33.99876]]]]} | Open Access 1 | 6509 | Whittier Greenway Trail | 27475 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 34.834 | Whittier Greenway Trail | 0 | Local Recreation Area 3 | 4 | |
7275 | 7275 | 7274 | {"type": "Polygon", "coordinates": [[[-118.03492, 33.97189], [-118.03492, 33.97353], [-118.03427, 33.97353], [-118.03331, 33.9734], [-118.03332, 33.97241], [-118.03385, 33.9724], [-118.03385, 33.97215], [-118.03394, 33.97215], [-118.03395, 33.97189], [-118.0344, 33.9719], [-118.03441, 33.97215], [-118.03447, 33.97214], [-118.03448, 33.9719], [-118.03492, 33.97189]]]} | Open Access 1 | 6518 | Friends Park Complex | 19117 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 5.686 | Friends Park Complex | 0 | Local Recreation Area 3 | 4 | |
7276 | 7276 | 7275 | {"type": "Polygon", "coordinates": [[[-118.00215, 33.94886], [-118.00214, 33.9489], [-118.00206, 33.949], [-118.002, 33.94912], [-118.00178, 33.94977], [-118.00198, 33.94984], [-118.00196, 33.94995], [-118.00167, 33.9504], [-118.0013, 33.95135], [-118.00092, 33.95167], [-118.00051, 33.95194], [-118.00043, 33.9518], [-118.0004, 33.95175], [-118.0004, 33.95168], [-118.00045, 33.95164], [-118.00065, 33.95159], [-118.00085, 33.95147], [-118.00099, 33.95134], [-118.00109, 33.95121], [-118.00154, 33.95019], [-118.00168, 33.94978], [-118.00193, 33.94917], [-118.00205, 33.94898], [-118.00215, 33.94886]]]} | Open Access 1 | 6519 | La Serna Drive Open Space | 20807 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 1.661 | La Serna Drive OS | 0 | Local Recreation Area 3 | 4 | |
7283 | 7283 | 7282 | {"type": "MultiPolygon", "coordinates": [[[[-118.14175, 33.82338], [-118.13512, 33.82334], [-118.13509, 33.82283], [-118.13466, 33.82244], [-118.13408, 33.82244], [-118.13409, 33.81902], [-118.13416, 33.81896], [-118.13886, 33.81895], [-118.139, 33.81906], [-118.1391, 33.81948], [-118.13924, 33.81986], [-118.13935, 33.82009], [-118.13975, 33.82078], [-118.13995, 33.82107], [-118.14019, 33.82136], [-118.14125, 33.82253], [-118.14146, 33.82291], [-118.14163, 33.82315], [-118.14164, 33.82326], [-118.14169, 33.82326], [-118.14175, 33.82338]]], [[[-118.13891, 33.81857], [-118.13879, 33.81867], [-118.13416, 33.81868], [-118.1341, 33.81863], [-118.13413, 33.81186], [-118.13414, 33.81143], [-118.13419, 33.81124], [-118.1342, 33.81077], [-118.13422, 33.81074], [-118.13428, 33.81072], [-118.13441, 33.81072], [-118.13496, 33.81078], [-118.13539, 33.81088], [-118.13582, 33.81105], [-118.13625, 33.81129], [-118.13757, 33.81228], [-118.13794, 33.81248], [-118.13814, 33.81256], [-118.13848, 33.81267], [-118.1388, 33.81275], [-118.1389, 33.81284], [-118.1389, 33.81374], [-118.13894, 33.81402], [-118.13894, 33.81428], [-118.13895, 33.81713], [-118.13889, 33.81799], [-118.13889, 33.81832], [-118.13891, 33.81857]]]]} | Restricted Access 2 | 6575 | Skylinks Golf Course | 33018 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 152.018 | Skylinks GC | 0 | Local Recreation Area 3 | 4 | |
7290 | 7290 | 7289 | {"type": "Polygon", "coordinates": [[[-117.97673, 33.90641], [-117.9767, 33.90644], [-117.97664, 33.90637], [-117.9765, 33.90631], [-117.97642, 33.90626], [-117.97638, 33.90594], [-117.97628, 33.90577], [-117.97605, 33.90575], [-117.97595, 33.90571], [-117.97586, 33.90562], [-117.97578, 33.90546], [-117.97571, 33.90524], [-117.97566, 33.90504], [-117.97543, 33.90475], [-117.97542, 33.90466], [-117.97549, 33.90455], [-117.97559, 33.90451], [-117.97572, 33.9045], [-117.97604, 33.90473], [-117.97616, 33.9049], [-117.97628, 33.90511], [-117.97632, 33.90524], [-117.97632, 33.90533], [-117.97635, 33.9054], [-117.97645, 33.90557], [-117.97649, 33.90575], [-117.97673, 33.90641]]]} | Open Access 1 | 7134 | City of Fullerton Open Space | 17314 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 2.106 | City of Fullerton OS | 0 | Local Recreation Area 3 | 4 | |
7296 | 7296 | 7295 | {"type": "MultiPolygon", "coordinates": [[[[-118.09001, 33.80323], [-118.08973, 33.80323], [-118.08972, 33.80318], [-118.08943, 33.79703], [-118.0896, 33.79703], [-118.08976, 33.79762], [-118.09001, 33.80323]]], [[[-118.09035, 33.80941], [-118.09002, 33.8094], [-118.08982, 33.80517], [-118.09014, 33.80517], [-118.09035, 33.80941]]], [[[-118.09387, 33.78866], [-118.09152, 33.79346], [-118.09152, 33.79349], [-118.09142, 33.79369], [-118.09128, 33.7941], [-118.09112, 33.79469], [-118.09104, 33.7952], [-118.09101, 33.79591], [-118.0914, 33.80399], [-118.09119, 33.80398], [-118.09108, 33.80402], [-118.09108, 33.80406], [-118.09077, 33.80406], [-118.09035, 33.79591], [-118.09068, 33.7959], [-118.09069, 33.79548], [-118.09072, 33.79515], [-118.09082, 33.79456], [-118.0909, 33.79422], [-118.091, 33.79389], [-118.09124, 33.79331], [-118.09351, 33.78865], [-118.09387, 33.78866]]], [[[-118.09172, 33.81023], [-118.09119, 33.81024], [-118.09091, 33.80678], [-118.09078, 33.80436], [-118.09109, 33.80437], [-118.0911, 33.8044], [-118.09119, 33.80445], [-118.09143, 33.80444], [-118.09172, 33.81023]]]]} | Open Access 1 | 6580 | San Gabriel River Trail | 29917 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 36.911 | San Gabriel River Trail | 0 | Local Recreation Area 3 | 4 | |
7301 | 7301 | 7300 | {"type": "Polygon", "coordinates": [[[-122.39795, 40.68894], [-122.39783, 40.69056], [-122.3966, 40.69054], [-122.39628, 40.69051], [-122.39582, 40.69042], [-122.39538, 40.69028], [-122.39545, 40.68923], [-122.39693, 40.68922], [-122.39713, 40.68908], [-122.39766, 40.68891], [-122.39795, 40.68894]]]} | Open Access 1 | 48427 | Bizz Johnson Ball Park | 33124 | 1438 | Shasta Lake, City of 324 | City 2 | City Agency 2 | http://www.ci.shasta-lake.ca.us/index.aspx?nid=253 | City 2 | 1438 | Shasta Lake, City of 321 | City 2 | City Agency 2 | https://cityofshastalake.org/553/Parks | Shasta 27 | 7.801 | Bizz Johnson Ball Park | 0 | Local Recreation Area 3 | 4 |
7326 | 7326 | 7325 | {"type": "Polygon", "coordinates": [[[-122.44504, 37.7974], [-122.44466, 37.79745], [-122.44464, 37.79736], [-122.44471, 37.79735], [-122.44469, 37.79727], [-122.44502, 37.79723], [-122.44504, 37.7974]]]} | Open Access 1 | 6639 | Cow Hollow Playground | 17727 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.151 | Cow Hollow Playground | 0 | Local Recreation Area 3 | 4 | |
7327 | 7327 | 7326 | {"type": "MultiPolygon", "coordinates": [[[[-118.19093, 33.78373], [-118.19093, 33.78389], [-118.19012, 33.78389], [-118.19012, 33.78373], [-118.19093, 33.78373]]], [[[-118.19225, 33.78389], [-118.1912, 33.78389], [-118.1912, 33.78373], [-118.19225, 33.78373], [-118.19225, 33.78389]]], [[[-118.19492, 33.78372], [-118.19492, 33.78389], [-118.19388, 33.78389], [-118.19388, 33.78372], [-118.19492, 33.78372]]], [[[-118.19623, 33.78372], [-118.19623, 33.78389], [-118.19519, 33.78389], [-118.19519, 33.78372], [-118.19623, 33.78372]]]]} | Open Access 1 | 6641 | 14th Street Park and Playground | 15173 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.661 | 14th Street Park and Playground | 0 | Local Recreation Area 3 | 4 | |
7335 | 7335 | 7334 | {"type": "MultiPolygon", "coordinates": [[[[-118.13513, 33.76319], [-118.13494, 33.76348], [-118.13464, 33.76355], [-118.13433, 33.76341], [-118.13513, 33.76319]]], [[[-118.13617, 33.76292], [-118.13599, 33.7632], [-118.13525, 33.7634], [-118.13521, 33.7634], [-118.13518, 33.76337], [-118.13519, 33.76334], [-118.13531, 33.76315], [-118.13617, 33.76292]]], [[[-118.1372, 33.76265], [-118.13714, 33.7629], [-118.13629, 33.76312], [-118.13625, 33.76312], [-118.13623, 33.76309], [-118.13623, 33.76306], [-118.13636, 33.76287], [-118.1372, 33.76265]]], [[[-118.13839, 33.76234], [-118.13834, 33.76258], [-118.13735, 33.76284], [-118.13743, 33.76259], [-118.13839, 33.76234]]]]} | Open Access 1 | 6648 | Livingston Drive Greenbelt and Playground | 21383 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.923 | Livingston Drive Greenbelt and Playground | 2008 | Local Recreation Area 3 | 4 | |
7336 | 7336 | 7335 | {"type": "MultiPolygon", "coordinates": [[[[-118.14362, 33.77567], [-118.14362, 33.77608], [-118.14273, 33.77551], [-118.14273, 33.77544], [-118.14327, 33.77544], [-118.14362, 33.77567]]], [[[-118.14578, 33.77707], [-118.14515, 33.77707], [-118.14381, 33.77621], [-118.14381, 33.77579], [-118.14578, 33.77707]]]]} | Open Access 1 | 6649 | Pacific Electric Greenbelt | 23297 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 2.422 | Pacific Electric Greenbelt | 0 | Local Recreation Area 3 | 4 | |
7344 | 7344 | 7343 | {"type": "Polygon", "coordinates": [[[-122.45598, 37.79153], [-122.45339, 37.79222], [-122.45287, 37.79205], [-122.4521, 37.79218], [-122.45194, 37.79104], [-122.45569, 37.7903], [-122.45598, 37.79153]]]} | Open Access 1 | 6663 | Julius Kahn Playground | 20521 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 12.262 | Julius Kahn Playground | 0 | Local Recreation Area 3 | 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]);