units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3 sorted by AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 211
- Los Angeles, City of 116
- San Francisco, City and County of 80
- Mountains Recreation and Conservation Authority 58
- Los Angeles, County of 31
- Conejo Open Space Conservation Agency 29
- East Bay Regional Park District 28
- Las Virgenes Municipal Water District 28
- San Luis Obispo, City of 26
- Long Beach, City of 25
- Glendale, City of 24
- Davis, City of 23
- Santa Barbara, County of 19
- Santa Clarita, City of 18
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Fullerton, City of 15
- Los Angeles - Department of Parks and Recreation, County of 15
- Santa Cruz, City of 14
- Conejo Recreation and Park District 14
- San Bernardino, City of 14
- San Marcos, City of 14
- East Bay Municipal Utility District 13
- Tiburon, Town of 13
- Carlsbad, City of 12
- Poway, City of 12
- Sunrise Recreation and Park District 12
- …
MNG_AG_TYP 17
- City Agency 1,440
- Recreation/Parks District 164
- County Agency 117
- Open Space District 88
- Water District 69
- County Agency - Parks 37
- Irrigation District 23
- Community Services District 14
- Flood District 12
- Port/Harbor District 5
- School District 5
- County Agency - Other 4
- Special District - Other 4
- Sanitation District 3
- Cemetery District 2
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 1,640
- Restricted Access 220
- No Public Access 113
- Unknown Access 16
MNG_AG_LEV 3 ✖
- City 1,440
- Special District 391
- County 158
DES_TP 1
- Local Recreation Area · 1,989 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16909 | 16909 | 16908 | {"type": "Polygon", "coordinates": [[[-118.77815, 34.14346], [-118.77784, 34.14376], [-118.77784, 34.14381], [-118.77752, 34.14415], [-118.77741, 34.14423], [-118.77726, 34.14428], [-118.77716, 34.14429], [-118.77696, 34.14427], [-118.77668, 34.14417], [-118.77653, 34.1441], [-118.7765, 34.14407], [-118.77656, 34.14399], [-118.77656, 34.14391], [-118.7765, 34.14383], [-118.7764, 34.1438], [-118.77667, 34.14384], [-118.7767, 34.14377], [-118.77664, 34.14368], [-118.77673, 34.14333], [-118.77709, 34.14327], [-118.77735, 34.14256], [-118.77759, 34.14262], [-118.77779, 34.14302], [-118.77815, 34.14346]]]} | Open Access 1 | 46240 | Agoura Hills Recreation and Event Center | 29519 | 3364 | Joni and Friends 1181 | Non Profit 6 | Non Profit - Other 22 | http://www.joniandfriends.org/ | Non Governmental Organization 10 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities/agoura-hills-recreation-center | Los Angeles 6 | 3.899 | Agoura Hills Rec. and Event Ctr. | 0 | Local Recreation Area 3 | 4 |
16901 | 16901 | 16900 | {"type": "Polygon", "coordinates": [[[-121.99742, 37.3099], [-121.99742, 37.31032], [-121.99733, 37.31095], [-121.99727, 37.311], [-121.99717, 37.311], [-121.99687, 37.31043], [-121.99662, 37.31014], [-121.99673, 37.31007], [-121.99654, 37.30984], [-121.99704, 37.30983], [-121.99736, 37.30986], [-121.9974, 37.3099], [-121.99742, 37.3099]]]} | Open Access 1 | 24310 | Rancho Rinconada Recreation Center | 24167 | 2251 | Rancho Rinconada Recreation and Park District 1180 | Special District 4 | Recreation/Parks District 4 | http://www.ranchoreccenter.com/ | Special District 4 | 2251 | Rancho Rinconada Recreation and Park District 1119 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 1.514 | Rancho Rinconada Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16900 | 16900 | 16899 | {"type": "Polygon", "coordinates": [[[-122.19908, 37.40441], [-122.19859, 37.40468], [-122.19843, 37.40469], [-122.19797, 37.40388], [-122.19864, 37.40363], [-122.19908, 37.40441]]]} | Open Access 1 | 24309 | Ladera Recreation Center | 20823 | 2233 | Ladera Recreation District 1179 | Special District 4 | Recreation/Parks District 4 | http://www.lrdrec.com/ | Special District 4 | 2233 | Ladera Recreation District 1118 | Special District 4 | Recreation/Parks District 4 | San Mateo 15 | 1.613 | Ladera Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16899 | 16899 | 16898 | {"type": "Polygon", "coordinates": [[[-122.34743, 37.51955], [-122.34676, 37.52049], [-122.34572, 37.52008], [-122.34668, 37.51877], [-122.34722, 37.51902], [-122.34701, 37.51936], [-122.34743, 37.51955]]]} | Open Access 1 | 24308 | Highlands Recreation Center | 19949 | 2228 | Highlands Recreation District 1178 | Special District 4 | Recreation/Parks District 4 | http://www.highlandsrec.com/ | Special District 4 | 2228 | Highlands Recreation District 1117 | Special District 4 | Recreation/Parks District 4 | San Mateo 15 | 3.66 | Highlands Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16777 | 16777 | 16776 | {"type": "MultiPolygon", "coordinates": [[[[-121.32835, 39.32083], [-121.32741, 39.32099], [-121.32743, 39.32082], [-121.32742, 39.32081], [-121.32611, 39.32104], [-121.32606, 39.32077], [-121.32632, 39.32044], [-121.32753, 39.32028], [-121.32834, 39.32058], [-121.32835, 39.32083]]], [[[-121.33188, 39.34191], [-121.33189, 39.34216], [-121.33188, 39.34277], [-121.33121, 39.34476], [-121.32791, 39.34345], [-121.32665, 39.344], [-121.32726, 39.34514], [-121.32708, 39.34564], [-121.32807, 39.34709], [-121.32842, 39.34764], [-121.32772, 39.34845], [-121.3264, 39.34849], [-121.32679, 39.35054], [-121.32645, 39.35135], [-121.32611, 39.35143], [-121.32406, 39.35094], [-121.32355, 39.35201], [-121.32411, 39.3543], [-121.32393, 39.35623], [-121.32202, 39.35605], [-121.32233, 39.35703], [-121.32218, 39.35806], [-121.3208, 39.35861], [-121.32109, 39.3604], [-121.32114, 39.36108], [-121.32034, 39.36122], [-121.32035, 39.362], [-121.31996, 39.36193], [-121.31991, 39.36118], [-121.31898, 39.36126], [-121.31866, 39.36182], [-121.31683, 39.36169], [-121.31191, 39.36163], [-121.31381, 39.36072], [-121.31438, 39.35769], [-121.3151, 39.35558], [-121.3156, 39.35493], [-121.31674, 39.35424], [-121.31864, 39.35203], [-121.31711, 39.35045], [-121.31381, 39.35083], [-121.3124, 39.35023], [-121.31157, 39.34868], [-121.30954, 39.34808], [-121.30783, 39.347], [-121.3062, 39.34438], [-121.30459, 39.34319], [-121.3042, 39.34249], [-121.30412, 39.34039], [-121.30516, 39.33994], [-121.30606, 39.33992], [-121.30807, 39.33935], [-121.30808, 39.33857], [-121.3048, 39.33534], [-121.30563, 39.33302], [-121.30741, 39.33138], [-121.30729, 39.33068], [-121.3033, 39.32901], [-121.30466, 39.32782], [-121.30453, 39.32059], [-121.3106, 39.32065], [-121.31527, 39.32072], [-121.31837, 39.32456], [-121.31915, 39.32509], [-121.3195, 39.32553], [-121.32, 39.32597], [-121.32241, 39.32959], [-121.32248, 39.32994], [-121.32225, 39.3305], [-121.32237, 39.33074], [-121.32276, 39.3312], [-121.32426, 39.33264], [-121.32426, 39.33439], [-121.32584, 39.33452], [-121.32707, 39.33532], [-121.32707, 39.33704], [-121.32858, 39.33861], [-121.32912, 39.34105], [-121.33188, 39.34191]]], [[[-121.31524, 39.36175], [-121.31682, 39.36179], [-121.3186, 39.36191], [-121.31775, 39.36316], [-121.32079, 39.36518], [-121.32123, 39.36596], [-121.32097, 39.36688], [-121.31987, 39.36715], [-121.31905, 39.36651], [-121.31795, 39.36582], [-121.31713, 39.36478], [-121.31529, 39.36402], [-121.31306, 39.36412], [-121.31005, 39.36485], [-121.3087, 39.36396], [-121.30512, 39.36372], [-121.30466, 39.36234], [-121.30758, 39.36172], [-121.31033, 39.36236], [-121.31075, 39.36219], [-121.31169, 39.36174], [-121.31524, 39.36175]]]]} | Open Access 1 | 662 | Collins Lake Recreation Area | 720 | 2010 | Browns Valley Irrigation District 1174 | Special District 4 | Irrigation District 17 | http://www.bvid.org/ | Special District 4 | 2010 | Browns Valley Irrigation District 1114 | Special District 4 | Irrigation District 16 | http://www.collinslake.com/map | Yuba 25 | 1598.822 | Collins Lake Rec. Area | 0 | Local Recreation Area 3 | 4 |
16693 | 16693 | 16692 | {"type": "Polygon", "coordinates": [[[-120.00196, 37.03239], [-120.00171, 37.03243], [-120.00016, 37.03244], [-119.99943, 37.03242], [-119.99724, 37.03242], [-119.99579, 37.03241], [-119.99252, 37.03241], [-119.98734, 37.03239], [-119.98585, 37.0324], [-119.98511, 37.03239], [-119.98264, 37.03238], [-119.97899, 37.03232], [-119.979, 37.03958], [-119.97675, 37.03953], [-119.97457, 37.03941], [-119.97449, 37.03591], [-119.96991, 37.03582], [-119.9699, 37.03231], [-119.97086, 37.03233], [-119.97446, 37.03227], [-119.97437, 37.02492], [-119.9744, 37.02311], [-119.97465, 37.023], [-119.97595, 37.02177], [-119.97705, 37.02028], [-119.9795, 37.01914], [-119.98213, 37.0183], [-119.98262, 37.01829], [-119.98364, 37.01781], [-119.98429, 37.01744], [-119.9852, 37.01715], [-119.98573, 37.01685], [-119.98675, 37.01624], [-119.98722, 37.01571], [-119.98802, 37.0152], [-119.98904, 37.01478], [-119.98933, 37.01476], [-119.98986, 37.01509], [-119.99053, 37.0152], [-119.99118, 37.01519], [-119.99207, 37.01523], [-119.99284, 37.01517], [-119.99361, 37.01483], [-119.99386, 37.01459], [-119.99395, 37.0136], [-119.99422, 37.01325], [-119.99436, 37.01282], [-119.99459, 37.01265], [-119.99507, 37.01245], [-119.99623, 37.0122], [-119.99704, 37.01195], [-119.99831, 37.01198], [-119.99894, 37.01182], [-119.99942, 37.01152], [-120.00002, 37.01106], [-120.00027, 37.01077], [-120.00172, 37.01077], [-120.00185, 37.02526], [-120.00196, 37.03239]]]} | No Public Access 3 | 16739 | Madera Lake Park And Recreation Area | 21652 | 2275 | Madera Irrigation District 1173 | Special District 4 | Irrigation District 17 | http://www.madera-id.org/ | Special District 4 | 2275 | Madera Irrigation District 1113 | Special District 4 | Irrigation District 16 | Madera 48 | 1216.241 | Madera Lake Park And Rec. Area | 0 | Local Recreation Area 3 | 4 | |
16262 | 16262 | 16261 | {"type": "Polygon", "coordinates": [[[-117.93705, 33.96918], [-117.93697, 33.96925], [-117.93701, 33.96946], [-117.93701, 33.96978], [-117.93684, 33.96991], [-117.93654, 33.96989], [-117.93623, 33.96967], [-117.93635, 33.96954], [-117.93648, 33.96933], [-117.9366, 33.96936], [-117.93669, 33.96909], [-117.93671, 33.9689], [-117.9369, 33.96915], [-117.937, 33.96914], [-117.93705, 33.96918]]]} | Open Access 1 | 46395 | Powder Canyon Open Space | 29673 | 2392 | La Habra Heights County Water District 1168 | Special District 4 | Water District 13 | http://www.lhhcwd.com/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.12 | Powder Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16223 | 16223 | 16222 | {"type": "Polygon", "coordinates": [[[-117.02305, 32.58558], [-117.01876, 32.58555], [-117.01875, 32.58376], [-117.0148, 32.58373], [-117.01465, 32.58363], [-117.01447, 32.58354], [-117.01433, 32.57606], [-117.02242, 32.57628], [-117.0226, 32.57717], [-117.02239, 32.57718], [-117.02228, 32.57717], [-117.02221, 32.57699], [-117.02213, 32.57694], [-117.02176, 32.5769], [-117.02167, 32.57671], [-117.02153, 32.5766], [-117.02143, 32.57654], [-117.02118, 32.57659], [-117.02096, 32.57669], [-117.02085, 32.57684], [-117.02075, 32.57687], [-117.02063, 32.57685], [-117.02049, 32.57678], [-117.02041, 32.57685], [-117.02001, 32.57685], [-117.01955, 32.57696], [-117.01934, 32.57699], [-117.01923, 32.57693], [-117.01911, 32.57693], [-117.01877, 32.57699], [-117.01863, 32.57698], [-117.01838, 32.57678], [-117.01823, 32.57676], [-117.01815, 32.57677], [-117.01807, 32.57664], [-117.01786, 32.57655], [-117.01771, 32.57645], [-117.01764, 32.57652], [-117.01738, 32.57666], [-117.01729, 32.57688], [-117.01729, 32.57695], [-117.01734, 32.57704], [-117.01734, 32.57712], [-117.01724, 32.57724], [-117.01741, 32.57755], [-117.01742, 32.57766], [-117.01757, 32.57781], [-117.01759, 32.5779], [-117.01753, 32.57802], [-117.01754, 32.57808], [-117.01758, 32.57815], [-117.01753, 32.5783], [-117.01751, 32.57859], [-117.01752, 32.57881], [-117.01758, 32.579], [-117.01765, 32.57912], [-117.01759, 32.57929], [-117.0176, 32.57938], [-117.01768, 32.57961], [-117.01774, 32.57987], [-117.01776, 32.58027], [-117.01773, 32.58054], [-117.01774, 32.5806], [-117.01785, 32.58072], [-117.01788, 32.58097], [-117.01792, 32.58102], [-117.01836, 32.58133], [-117.01845, 32.58134], [-117.01871, 32.58129], [-117.01878, 32.58128], [-117.01886, 32.58129], [-117.01895, 32.58138], [-117.019, 32.58147], [-117.01903, 32.58159], [-117.01898, 32.58167], [-117.01891, 32.58169], [-117.01868, 32.58167], [-117.01861, 32.5817], [-117.01852, 32.58188], [-117.01845, 32.58196], [-117.0184, 32.58238], [-117.01849, 32.58265], [-117.01846, 32.58281], [-117.0184, 32.58286], [-117.01873, 32.58324], [-117.0189, 32.58348], [-117.01924, 32.58413], [-117.01932, 32.58433], [-117.01953, 32.58434], [-117.01997, 32.58424], [-117.02013, 32.58427], [-117.02021, 32.58425], [-117.02029, 32.58418], [-117.02055, 32.58382], [-117.02049, 32.58355], [-117.02039, 32.58323], [-117.02075, 32.58311], [-117.02081, 32.58306], [-117.02092, 32.58288], [-117.02094, 32.58281], [-117.02117, 32.58292], [-117.02149, 32.58274], [-117.0214, 32.58198], [-117.0211, 32.58161], [-117.02126, 32.58163], [-117.02136, 32.58158], [-117.02176, 32.58159], [-117.02191, 32.58155], [-117.0221, 32.58145], [-117.02217, 32.58145], [-117.02223, 32.58147], [-117.02224, 32.58151], [-117.0222, 32.58163], [-117.02222, 32.58164], [-117.02267, 32.5816], [-117.023, 32.58154], [-117.02305, 32.58379], [-117.02305, 32.58558]]]} | Open Access 1 | 44861 | Hidden Trails Open Space | 31665 | 6075 | Western Pacific Housing 1167 | Private 7 | Commercial 20 | Private 14 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 106.609 | Hidden Trails OS | 0 | Local Recreation Area 3 | 4 | ||
16196 | 16196 | 16195 | {"type": "Polygon", "coordinates": [[[-117.0865, 34.04475], [-117.08624, 34.04842], [-117.0692, 34.04833], [-117.06049, 34.04845], [-117.06053, 34.04117], [-117.06028, 34.04116], [-117.06136, 34.04016], [-117.06174, 34.03987], [-117.06213, 34.03963], [-117.06229, 34.03983], [-117.06217, 34.03991], [-117.06204, 34.04003], [-117.06193, 34.04016], [-117.06185, 34.04031], [-117.0618, 34.04047], [-117.06173, 34.04129], [-117.06164, 34.04169], [-117.06154, 34.04194], [-117.06143, 34.04217], [-117.06097, 34.04289], [-117.06091, 34.04319], [-117.06129, 34.04371], [-117.06201, 34.04408], [-117.06344, 34.04421], [-117.06355, 34.04469], [-117.06401, 34.0452], [-117.06526, 34.04508], [-117.06733, 34.04373], [-117.06926, 34.04307], [-117.06929, 34.04107], [-117.06949, 34.04146], [-117.0696, 34.0416], [-117.0697, 34.04169], [-117.06984, 34.04178], [-117.07002, 34.04185], [-117.07023, 34.0419], [-117.07042, 34.04191], [-117.07059, 34.04189], [-117.07124, 34.04177], [-117.07142, 34.04172], [-117.07162, 34.04162], [-117.0722, 34.04122], [-117.07364, 34.041], [-117.07357, 34.04112], [-117.07356, 34.04255], [-117.074, 34.0428], [-117.07417, 34.04316], [-117.07504, 34.04377], [-117.07525, 34.04398], [-117.07626, 34.04404], [-117.07656, 34.04384], [-117.07839, 34.04318], [-117.07967, 34.04238], [-117.08011, 34.04194], [-117.07995, 34.0413], [-117.08064, 34.04121], [-117.08074, 34.04181], [-117.08067, 34.04184], [-117.08088, 34.04306], [-117.08058, 34.04376], [-117.08109, 34.0441], [-117.08156, 34.0439], [-117.08182, 34.04338], [-117.08177, 34.04301], [-117.08168, 34.04272], [-117.08098, 34.0427], [-117.08072, 34.0412], [-117.08344, 34.04075], [-117.08406, 34.04061], [-117.08457, 34.04045], [-117.08458, 34.04109], [-117.08231, 34.0411], [-117.08215, 34.04474], [-117.0865, 34.04475]]]} | Open Access 1 | 29521 | Chapman Heights Open Space | 10132 | 3237 | Crafton Hills Open Space Conservancy 1166 | Non Profit 6 | Non Profit - Conservation 12 | http://craftonhillsconservancy.org/ | Non Governmental Organization 10 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://craftonhillsconservancy.org/maps/trail-maps-all-trails | San Bernardino 22 | 336.232 | Chapman Heights OS | 0 | Local Recreation Area 3 | 4 |
16183 | 16183 | 16182 | {"type": "Polygon", "coordinates": [[[-116.96262, 32.66755], [-116.96258, 32.67203], [-116.9624, 32.67632], [-116.96061, 32.6763], [-116.96057, 32.67812], [-116.95842, 32.67809], [-116.95815, 32.68544], [-116.95389, 32.68549], [-116.9496, 32.68532], [-116.94952, 32.67935], [-116.94962, 32.66718], [-116.95173, 32.66721], [-116.95171, 32.67086], [-116.95136, 32.67085], [-116.95135, 32.67086], [-116.95145, 32.67118], [-116.9517, 32.67172], [-116.95188, 32.67188], [-116.95185, 32.67227], [-116.95191, 32.67262], [-116.9519, 32.67282], [-116.95177, 32.67289], [-116.95196, 32.6732], [-116.95169, 32.67409], [-116.95183, 32.67443], [-116.95208, 32.67451], [-116.95247, 32.67456], [-116.9524, 32.67497], [-116.95235, 32.67565], [-116.95234, 32.67634], [-116.95242, 32.67715], [-116.95232, 32.67769], [-116.95227, 32.67865], [-116.95263, 32.67895], [-116.9528, 32.67927], [-116.95272, 32.67965], [-116.95259, 32.68069], [-116.95268, 32.68104], [-116.95291, 32.68152], [-116.95313, 32.68161], [-116.95414, 32.68165], [-116.95455, 32.68221], [-116.95477, 32.68236], [-116.95507, 32.68269], [-116.95534, 32.68301], [-116.95553, 32.68311], [-116.95598, 32.68351], [-116.95623, 32.68353], [-116.95641, 32.6833], [-116.95648, 32.68294], [-116.95691, 32.6828], [-116.95718, 32.68259], [-116.95736, 32.68229], [-116.95749, 32.68199], [-116.95741, 32.68142], [-116.9572, 32.68091], [-116.95737, 32.68062], [-116.95743, 32.68033], [-116.95743, 32.68007], [-116.9575, 32.67979], [-116.95762, 32.67949], [-116.95764, 32.67923], [-116.95759, 32.67898], [-116.95759, 32.67872], [-116.95752, 32.67844], [-116.95757, 32.67783], [-116.95772, 32.67749], [-116.95798, 32.67702], [-116.95829, 32.67654], [-116.95842, 32.67622], [-116.95892, 32.67575], [-116.96005, 32.67517], [-116.96004, 32.67482], [-116.96017, 32.67458], [-116.96029, 32.67422], [-116.96058, 32.67373], [-116.96067, 32.6735], [-116.96068, 32.67316], [-116.96065, 32.67274], [-116.96045, 32.67188], [-116.96041, 32.67153], [-116.96048, 32.67116], [-116.96048, 32.67092], [-116.96103, 32.67029], [-116.9616, 32.66946], [-116.96178, 32.66878], [-116.96214, 32.66815], [-116.96242, 32.66771], [-116.96262, 32.66755]]]} | No Public Access 3 | 46836 | Mount Miguel Open Space | 30305 | 2401 | Otay Water District 1164 | Special District 4 | Water District 13 | http://www.otaywater.gov/ | Special District 4 | 2401 | Otay Water District 1106 | Special District 4 | Water District 13 | San Diego 4 | 231.148 | Mount Miguel OS | 0 | Local Recreation Area 3 | 4 | |
15845 | 15845 | 15844 | {"type": "MultiPolygon", "coordinates": [[[[-118.37159, 33.76721], [-118.37139, 33.76744], [-118.37081, 33.76795], [-118.37054, 33.76809], [-118.37028, 33.76819], [-118.36988, 33.76826], [-118.36957, 33.76825], [-118.36931, 33.76821], [-118.36905, 33.76812], [-118.36801, 33.7677], [-118.3677, 33.76761], [-118.36738, 33.76756], [-118.36695, 33.76756], [-118.36722, 33.76751], [-118.36745, 33.76751], [-118.36778, 33.76756], [-118.36792, 33.7676], [-118.3693, 33.76817], [-118.36961, 33.76824], [-118.36984, 33.76825], [-118.37, 33.76823], [-118.37022, 33.76817], [-118.37042, 33.76808], [-118.37055, 33.76799], [-118.37068, 33.76788], [-118.37139, 33.76708], [-118.37138, 33.76701], [-118.37159, 33.76714], [-118.37159, 33.76721]]], [[[-118.3718, 33.76638], [-118.3718, 33.76662], [-118.37176, 33.76685], [-118.3717, 33.7669], [-118.37163, 33.76689], [-118.37158, 33.76686], [-118.37168, 33.7667], [-118.37175, 33.76655], [-118.37178, 33.76638], [-118.37178, 33.76628], [-118.3718, 33.76638]]]]} | Open Access 1 | 5926 | Ridgecrest Ranchos Open Space | 24353 | 2120 | Ridgecrest Ranchos Recreation and Park District 1162 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2120 | Ridgecrest Ranchos Recreation and Park District 1105 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 1.195 | Ridgecrest Ranchos OS | 0 | Local Recreation Area 3 | 4 | ||
15695 | 15695 | 15694 | {"type": "Polygon", "coordinates": [[[-114.6039, 34.84393], [-114.60287, 34.84392], [-114.60287, 34.84339], [-114.6039, 34.84339], [-114.6039, 34.84393]]]} | Restricted Access 2 | 49074 | River's Edge Golf Course | 33774 | 2442 | Needles Unified School District 1161 | Special District 4 | School District 14 | https://www.needlesusd.org/ | Special District 4 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/services/rivers-edge-golf-course/ | San Bernardino 22 | 1.368 | River's Edge GC | 0 | Local Recreation Area 3 | 4 |
15667 | 15667 | 15666 | {"type": "MultiPolygon", "coordinates": [[[[-117.78087, 34.13432], [-117.77956, 34.13623], [-117.77952, 34.13623], [-117.77668, 34.13961], [-117.77672, 34.13656], [-117.77842, 34.13656], [-117.77907, 34.13625], [-117.77907, 34.13623], [-117.77757, 34.13623], [-117.77816, 34.13544], [-117.78087, 34.13432]]], [[[-117.78553, 34.13746], [-117.7855, 34.13899], [-117.78448, 34.1382], [-117.78414, 34.13855], [-117.78324, 34.13797], [-117.78188, 34.13857], [-117.77931, 34.14076], [-117.77831, 34.14213], [-117.7783, 34.14331], [-117.77675, 34.14332], [-117.77677, 34.13975], [-117.77972, 34.13625], [-117.77971, 34.13623], [-117.78, 34.1358], [-117.78077, 34.1347], [-117.78082, 34.13473], [-117.78093, 34.13461], [-117.7812, 34.13438], [-117.78164, 34.13411], [-117.78274, 34.13355], [-117.78304, 34.13334], [-117.78316, 34.13323], [-117.78323, 34.1332], [-117.78327, 34.1332], [-117.78333, 34.13323], [-117.7842, 34.13378], [-117.78317, 34.13427], [-117.78294, 34.13488], [-117.78326, 34.13531], [-117.78441, 34.13592], [-117.78436, 34.13609], [-117.78435, 34.13626], [-117.78438, 34.13643], [-117.78449, 34.13664], [-117.78468, 34.13683], [-117.78553, 34.13746]], [[-117.78214, 34.13578], [-117.78214, 34.13579], [-117.78231, 34.13592], [-117.78253, 34.13571], [-117.78235, 34.13558], [-117.78214, 34.13578]]]]} | Restricted Access 2 | 6754 | San Dimas Canyon Golf Course | 33021 | 2135 | San Dimas-La Verne Recreational Facilities Authority 1160 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2135 | San Dimas-La Verne Recreational Facilities Authority 1104 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 103.27 | San Dimas Canyon GC | 0 | Local Recreation Area 3 | 4 | ||
15418 | 15418 | 15417 | {"type": "Polygon", "coordinates": [[[-117.33206, 33.16323], [-117.33174, 33.16369], [-117.33078, 33.16284], [-117.33123, 33.16249], [-117.33206, 33.16323]]]} | Restricted Access 2 | 46651 | Carlsbad High School Tennis Courts | 32247 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.727 | Carlsbad High School Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
15358 | 15358 | 15357 | {"type": "Polygon", "coordinates": [[[-118.08395, 34.01292], [-118.0835, 34.01349], [-118.08385, 34.01371], [-118.08368, 34.0139], [-118.08365, 34.01392], [-118.08362, 34.01391], [-118.08245, 34.01323], [-118.08312, 34.01244], [-118.08395, 34.01292]]]} | Restricted Access 2 | 46547 | Pio Pico Playground | 31638 | 2369 | El Rancho Unified School District 1156 | Special District 4 | School District 14 | http://www.erusd.org/ | Special District 4 | 1250 | Pico Rivera, City of 367 | City 2 | City Agency 2 | Los Angeles 6 | 2.817 | Pio Pico Playground | 0 | Local Recreation Area 3 | 4 | |
15330 | 15330 | 15329 | {"type": "Polygon", "coordinates": [[[-118.2036, 34.20436], [-118.2036, 34.20462], [-118.20323, 34.20462], [-118.20323, 34.20436], [-118.2036, 34.20436]]]} | Restricted Access 2 | 46505 | Skate Park | 31585 | 2395 | La Canada Unified School District 1154 | Special District 4 | School District 14 | http://lcusd.net/site/default.aspx?PageID=1 | Special District 4 | 1154 | La Canada Flintridge, City of 330 | City 2 | City Agency 2 | http://www.lcf.ca.gov/parks/skate | Los Angeles 6 | 0.246 | Skate Park | 0 | Local Recreation Area 3 | 4 |
15299 | 15299 | 15298 | {"type": "Polygon", "coordinates": [[[-117.97481, 34.14373], [-117.9748, 34.14592], [-117.97453, 34.14593], [-117.97453, 34.14687], [-117.9745, 34.14687], [-117.9745, 34.1459], [-117.97473, 34.14589], [-117.97476, 34.14586], [-117.97476, 34.14373], [-117.97481, 34.14373]]]} | Open Access 1 | 46437 | Lemon Trail | 29710 | 1712 | Bradbury, City of 1150 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | Los Angeles 6 | 0.341 | Lemon Trail | 0 | Local Recreation Area 3 | 4 | |
15277 | 15277 | 15276 | {"type": "Polygon", "coordinates": [[[-118.01134, 34.00416], [-118.00978, 34.00681], [-118.00888, 34.00585], [-118.0079, 34.00193], [-118.00768, 34.00148], [-118.00739, 34.00133], [-118.00716, 34.00114], [-118.00703, 34.00099], [-118.00639, 34.00009], [-118.00618, 33.99987], [-118.00592, 33.9997], [-118.00515, 33.99931], [-118.00612, 33.99766], [-118.01134, 34.00416]]]} | Unknown Access 4 | 46393 | Hacienda Hills Open Space | 29675 | 6105 | Rose Hills Memorial Park and Mortuaries 1148 | Private 7 | Commercial 20 | http://www.rosehills.com/en-us/index.page | Private 14 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 40.216 | Hacienda Hills OS | 0 | Local Recreation Area 3 | 4 | |
15245 | 15245 | 15244 | {"type": "MultiPolygon", "coordinates": [[[[-118.11714, 33.88168], [-118.11705, 33.88172], [-118.11518, 33.88074], [-118.11387, 33.87997], [-118.10923, 33.87712], [-118.10987, 33.87717], [-118.11517, 33.88042], [-118.11714, 33.88145], [-118.11714, 33.88168]]], [[[-118.12513, 33.88586], [-118.11962, 33.88303], [-118.11818, 33.88229], [-118.11864, 33.88221], [-118.12292, 33.8844], [-118.12415, 33.88503], [-118.1244, 33.88538], [-118.12513, 33.88572], [-118.12513, 33.88586]]], [[[-118.13228, 33.8892], [-118.13165, 33.8892], [-118.12539, 33.88599], [-118.12539, 33.88567], [-118.13228, 33.8892]]], [[[-118.13385, 33.89032], [-118.13216, 33.88946], [-118.13216, 33.88942], [-118.1327, 33.88942], [-118.13384, 33.89], [-118.13385, 33.89032]]], [[[-118.14254, 33.89477], [-118.13411, 33.89046], [-118.13411, 33.89013], [-118.14254, 33.89445], [-118.14254, 33.89477]]]]} | Open Access 1 | 46283 | Bellflower Bike Trail | 29575 | 2077 | Los Angeles County Metropolitan Transportation Authority 1142 | Special District 4 | Transportation Agency 32 | http://www.metro.net | Special District 4 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | Los Angeles 6 | 24.976 | Bellflower Bike Trail | 0 | Local Recreation Area 3 | 4 | |
15031 | 15031 | 15030 | {"type": "Polygon", "coordinates": [[[-122.83393, 41.61987], [-122.83324, 41.62052], [-122.83325, 41.62054], [-122.83331, 41.62054], [-122.83314, 41.62075], [-122.83212, 41.62027], [-122.83205, 41.62032], [-122.83181, 41.62017], [-122.83282, 41.61921], [-122.83393, 41.61987]]]} | Open Access 1 | 45683 | Walker Field | 28497 | 1701 | Fort Jones, City of 1135 | City 2 | City Agency 2 | City 2 | 1701 | Fort Jones, City of 1090 | City 2 | City Agency 2 | Siskiyou 28 | 3.716 | Walker Field | 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]);