superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows sorted by MNG_AGENCY descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 10,210
- County Agency 1,102
- Recreation/Parks District 1,086
- State Agency 872
- Non Profit - Land Trust 510
- Federal Agency 289
- Open Space District 241
- County Agency - Parks 218
- Home Owners Association 198
- Community Services District 193
- Water District 183
- Non Profit - Conservation 117
- Flood District 94
- Cemetery District 61
- Non Profit - Other 43
- School District 38
- County Agency - Other 32
- Port/Harbor District 32
- Irrigation District 22
- Special District - Other 15
- Commercial 12
- Sanitation District 9
- Joint Powers Authority 7
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Metropolitan Planning Organization 2
- Non Profit - Education 2
- …
MNG_AGENCY >30
- Los Angeles, City of 465
- San Diego, City of 433
- California Department of Fish and Wildlife 394
- California Department of Parks and Recreation 276
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 218
- Mountains Recreation and Conservation Authority 181
- Los Angeles, County of 171
- Ventura, City of 151
- Long Beach, City of 148
- East Bay Regional Park District 132
- Roseville, City of 124
- Oakland, City of 122
- San Diego, County of 120
- Irvine, City of 98
- Fresno, City of 94
- Consumnes Community Services District 92
- Santa Barbara, County of 89
- Hayward Area Recreation and Park District 84
- Modesto, City of 84
- Orange, County of 82
- Stockton, City of 81
- Santa Rosa, City of 79
- Huntington Beach, City of 76
- Tracy, City of 73
- Torrance, City of 72
- Santa Cruz, City of 69
- Chula Vista, City of 69
- Brentwood, City of 68
- …
ACCESS_TYP 4
- Open Access 13,499
- Restricted Access 1,112
- No Public Access 752
- Unknown Access 254
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY ▲ | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14617 | 14617 | 14616 | {"type": "MultiPolygon", "coordinates": [[[[-117.09268, 33.16118], [-117.09263, 33.16144], [-117.09239, 33.1623], [-117.09172, 33.16442], [-117.09132, 33.16557], [-117.09126, 33.16559], [-117.09122, 33.16558], [-117.09117, 33.16553], [-117.09112, 33.16552], [-117.09095, 33.1655], [-117.09109, 33.16537], [-117.09084, 33.16498], [-117.09075, 33.16478], [-117.09071, 33.16458], [-117.09071, 33.16438], [-117.09076, 33.16417], [-117.09092, 33.16373], [-117.09086, 33.16352], [-117.09004, 33.16299], [-117.08994, 33.16301], [-117.08984, 33.16316], [-117.0898, 33.16373], [-117.09023, 33.1638], [-117.09023, 33.16386], [-117.0898, 33.16381], [-117.08972, 33.1645], [-117.08977, 33.16477], [-117.08983, 33.16503], [-117.08993, 33.16525], [-117.09006, 33.1655], [-117.09025, 33.1657], [-117.09055, 33.16553], [-117.09067, 33.16561], [-117.09073, 33.16569], [-117.09088, 33.16575], [-117.09098, 33.16581], [-117.09117, 33.16582], [-117.0912, 33.16588], [-117.09069, 33.16732], [-117.09045, 33.16811], [-117.09031, 33.1682], [-117.09, 33.16812], [-117.08956, 33.1681], [-117.08947, 33.16806], [-117.08938, 33.16805], [-117.08929, 33.16808], [-117.08918, 33.16816], [-117.08894, 33.16826], [-117.08883, 33.16821], [-117.08896, 33.16797], [-117.08906, 33.1677], [-117.08909, 33.16741], [-117.08905, 33.16713], [-117.08871, 33.16584], [-117.08859, 33.16494], [-117.0884, 33.16417], [-117.08837, 33.1636], [-117.08815, 33.16355], [-117.08817, 33.16349], [-117.08816, 33.16345], [-117.08821, 33.16335], [-117.08822, 33.16322], [-117.08826, 33.16313], [-117.08827, 33.16305], [-117.08823, 33.16297], [-117.08814, 33.1629], [-117.08795, 33.16256], [-117.08797, 33.16246], [-117.08897, 33.16188], [-117.0893, 33.16172], [-117.0897, 33.16157], [-117.08991, 33.1615], [-117.09033, 33.1614], [-117.09069, 33.16135], [-117.09263, 33.16112], [-117.09268, 33.16118]]], [[[-117.09493, 33.16981], [-117.09491, 33.16997], [-117.0949, 33.17091], [-117.08993, 33.17091], [-117.09066, 33.1685], [-117.0928, 33.1691], [-117.09489, 33.16975], [-117.09493, 33.16981]]], [[[-117.09702, 33.17023], [-117.0954, 33.16973], [-117.09539, 33.16968], [-117.09404, 33.16924], [-117.09211, 33.16867], [-117.09084, 33.16831], [-117.09344, 33.16883], [-117.09504, 33.16905], [-117.09539, 33.16912], [-117.09576, 33.16927], [-117.09604, 33.16943], [-117.09629, 33.16963], [-117.09644, 33.16979], [-117.09662, 33.16997], [-117.09679, 33.1701], [-117.09702, 33.17023]]]]} | Restricted Access 2 | Reidy Creek Golf Course | https://www.jcgolf.com/san-diego-golf-courses/reidy-creek/ | 31473 | 7017 | JC Resorts 1102 | Private 7 | Commercial 18 | https://www.jcresorts.com | Private 14 | 70.311 | Reidy Creek GC | |
9189 | 9189 | 9188 | {"type": "MultiPolygon", "coordinates": [[[[-117.23374, 33.03631], [-117.23309, 33.03834], [-117.23296, 33.03831], [-117.23292, 33.03841], [-117.23201, 33.03818], [-117.23209, 33.03792], [-117.23191, 33.03787], [-117.23251, 33.03599], [-117.23374, 33.03631]]], [[[-117.23623, 33.03472], [-117.23609, 33.03514], [-117.23477, 33.03601], [-117.23459, 33.03653], [-117.23385, 33.03634], [-117.23455, 33.03424], [-117.23623, 33.03472]]]]} | Open Access 1 | San Elijo Lagoon Ecological Reserve | https://www.sanelijo.org/home | 24880 | 3058 | Rancho Santa Fe Community Foundation 1101 | Non Profit 6 | Non Profit - Other 20 | http://www.rsffoundation.org/ | Non Governmental Organization 10 | 14.076 | San Elijo Lagoon ER | 1983 |
13369 | 13369 | 13368 | {"type": "MultiPolygon", "coordinates": [[[[-122.28318, 38.30265], [-122.28294, 38.3029], [-122.2829, 38.30296], [-122.28289, 38.30304], [-122.28294, 38.30335], [-122.28277, 38.30344], [-122.28272, 38.30318], [-122.28268, 38.3028], [-122.28265, 38.3027], [-122.28255, 38.30246], [-122.28229, 38.30218], [-122.28217, 38.30212], [-122.28207, 38.3021], [-122.28203, 38.30204], [-122.2821, 38.30199], [-122.28205, 38.30193], [-122.28217, 38.30187], [-122.28221, 38.30189], [-122.28231, 38.30179], [-122.28244, 38.30173], [-122.28318, 38.30265]]], [[[-122.28323, 38.3012], [-122.28254, 38.30155], [-122.28245, 38.30144], [-122.28269, 38.30123], [-122.28274, 38.3012], [-122.28278, 38.30121], [-122.28284, 38.30112], [-122.28297, 38.30103], [-122.28289, 38.30092], [-122.2829, 38.30087], [-122.28274, 38.30068], [-122.28279, 38.30065], [-122.28323, 38.3012]]], [[[-122.28379, 38.30186], [-122.28306, 38.30224], [-122.28265, 38.3017], [-122.28337, 38.30134], [-122.28379, 38.30186]]], [[[-122.2837, 38.30098], [-122.28341, 38.30111], [-122.28296, 38.30057], [-122.28325, 38.30043], [-122.28332, 38.30043], [-122.2837, 38.30098]]]]} | Open Access 1 | Oxbow Commons | 30727 | 2405 | Napa County Flood Control and Water Conservation District 1100 | Special District 4 | Water District 13 | http://www.countyofnapa.org/flooddistrict/ | Special District 4 | 3.868 | Oxbow Commons | ||
14122 | 14122 | 14121 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19585], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 5.623 | |||
12635 | 12635 | 12634 | {"type": "Polygon", "coordinates": [[[-118.1787, 33.98749], [-118.1785, 33.98885], [-118.17811, 33.98882], [-118.17817, 33.98838], [-118.17812, 33.98837], [-118.17792, 33.98851], [-118.17774, 33.98834], [-118.17784, 33.98769], [-118.17797, 33.98768], [-118.178, 33.98742], [-118.1787, 33.98749]]]} | Open Access 1 | Maywood Activity Center | http://www.cityofmaywood.com/index.php?option=com_content&view=article&id=162&Itemid=69 | 29736 | 3366 | YMCA of Southeast - Rio Vista 1098 | Non Profit 6 | Non Profit - Other 20 | http://www.ymcala.org/southeast-rio-vista/ | Non Governmental Organization 10 | 2.401 | Maywood Activity Ctr. | |
12584 | 12584 | 12583 | {"type": "Polygon", "coordinates": [[[-117.97481, 34.14373], [-117.9748, 34.14592], [-117.97454, 34.14593], [-117.97453, 34.14687], [-117.9745, 34.14687], [-117.9745, 34.1459], [-117.97472, 34.14589], [-117.97476, 34.14586], [-117.97476, 34.14373], [-117.97481, 34.14373]]]} | Open Access 1 | Lemon Trail | 29710 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 0.344 | Lemon Trail | ||
12585 | 12585 | 12584 | {"type": "Polygon", "coordinates": [[[-117.97472, 34.14357], [-117.97464, 34.14362], [-117.96441, 34.1437], [-117.96441, 34.14354], [-117.97458, 34.14347], [-117.97472, 34.14357]]]} | Open Access 1 | Royal Oaks Trail North | 29711 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 4.027 | Royal Oaks Trail North | ||
15622 | 15622 | 15621 | {"type": "Polygon", "coordinates": [[[-117.96999, 34.14575], [-117.9696, 34.14575], [-117.96915, 34.14556], [-117.96899, 34.14555], [-117.96898, 34.14547], [-117.96986, 34.1455], [-117.96996, 34.14548], [-117.96999, 34.14575]]]} | Open Access 1 | Civic Center Park | 32522 | 1712 | Bradbury, City of 1097 | City 2 | City Agency 2 | http://cityofbradbury.org/ | City 2 | 0.468 | Civic Ctr. Park | ||
12606 | 12606 | 12605 | {"type": "Polygon", "coordinates": [[[-118.42222, 33.91688], [-118.4218, 33.91688], [-118.42178, 33.91679], [-118.42102, 33.91679], [-118.42102, 33.91638], [-118.42222, 33.91637], [-118.42222, 33.91688]]]} | No Public Access 3 | El Segundo Blue Butterfly Preserve | 29696 | 6107 | Chevron Corporation 1096 | Private 7 | Commercial 18 | http://www.chevron.com/ | Private 14 | 1.359 | El Segundo Blue Butterfly Preserve | ||
238 | 238 | 237 | {"type": "Polygon", "coordinates": [[[-118.11657, 33.91793], [-118.11657, 33.91795], [-118.11639, 33.9182], [-118.11639, 33.91832], [-118.1159, 33.91833], [-118.11589, 33.9183], [-118.11582, 33.9183], [-118.11581, 33.91828], [-118.11572, 33.91828], [-118.11571, 33.91809], [-118.11509, 33.9181], [-118.11507, 33.91806], [-118.11486, 33.91806], [-118.11484, 33.91809], [-118.11464, 33.91809], [-118.11463, 33.91875], [-118.11356, 33.91874], [-118.11419, 33.91728], [-118.11434, 33.91721], [-118.11651, 33.9172], [-118.11657, 33.91725], [-118.11657, 33.91793]]]} | Restricted Access 2 | Columbus High School Park | 31885 | 2368 | Downey Unified School District 1095 | Special District 4 | School District 21 | http://www.dusd.net/ | Special District 4 | 7.586 | Columbus High School Park | ||
12458 | 12458 | 12457 | {"type": "Polygon", "coordinates": [[[-118.51949, 34.4416], [-118.51896, 34.44198], [-118.51857, 34.44159], [-118.51911, 34.44123], [-118.51949, 34.4416]]]} | Restricted Access 2 | Saugus High School Joint Use Facility | 29502 | 2389 | William S. Hart Union High School District 1094 | Special District 4 | School District 21 | http://www.hartdistrict.org/ | Special District 4 | 0.881 | Saugus High School Joint Use Facility | ||
13564 | 13564 | 13563 | {"type": "Polygon", "coordinates": [[[-117.27449, 33.09511], [-117.27025, 33.09505], [-117.27019, 33.09492], [-117.27019, 33.09488], [-117.27023, 33.09483], [-117.27016, 33.09464], [-117.27011, 33.09464], [-117.27011, 33.09307], [-117.2703, 33.09301], [-117.27048, 33.09283], [-117.27071, 33.09282], [-117.27099, 33.09295], [-117.27164, 33.09308], [-117.2715, 33.0933], [-117.27151, 33.09332], [-117.27233, 33.09353], [-117.27312, 33.09348], [-117.27325, 33.09329], [-117.27351, 33.09329], [-117.27355, 33.09311], [-117.27415, 33.09307], [-117.27414, 33.09316], [-117.27439, 33.09324], [-117.27448, 33.09326], [-117.27449, 33.09511]]]} | Open Access 1 | Cholla Point | http://www.batiquitosfoundation.org/category/visit/ | 30996 | 3220 | Batiquitos Lagoon Foundation 1093 | Non Profit 6 | Non Profit - Conservation 12 | http://www.batiquitosfoundation.org/about/ | Non Governmental Organization 10 | 20.825 | Cholla Point | 2011 |
12096 | 12096 | 12095 | {"type": "Polygon", "coordinates": [[[-117.98619, 34.17245], [-117.98605, 34.1798], [-117.9775, 34.17979], [-117.97751, 34.17245], [-117.98619, 34.17245]]]} | Open Access 1 | Canyon Park, Boy Scouts of America | 29062 | 3360 | Boy Scouts of America 1092 | Non Profit 6 | Non Profit - Other 20 | http://www.scouting.org/ | Non Governmental Organization 10 | 159.845 | Canyon Park, Boy Scouts of America | ||
11851 | 11851 | 11850 | {"type": "Polygon", "coordinates": [[[-121.1982, 39.20573], [-121.19466, 39.20522], [-121.1857, 39.20366], [-121.18573, 39.20231], [-121.18731, 39.20265], [-121.18791, 39.20104], [-121.19336, 39.20145], [-121.19421, 39.2016], [-121.19591, 39.20205], [-121.19738, 39.2026], [-121.19816, 39.20518], [-121.1982, 39.20573]]]} | Open Access 1 | Western Gateway Park | http://www.westerngatewaypark.com/ | 28498 | 2269 | Western Gateway Recreation and Park District 1091 | Special District 4 | Recreation/Parks District 4 | http://www.westerngatewaypark.com/ | Special District 4 | 85.756 | Western Gateway Park | |
11850 | 11850 | 11849 | {"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 | Walker Field | 28497 | 1701 | Fort Jones, City of 1090 | City 2 | City Agency 2 | City 2 | 3.716 | Walker Field | |||
11857 | 11857 | 11856 | {"type": "Polygon", "coordinates": [[[-121.02525, 39.27137], [-121.02459, 39.27178], [-121.02463, 39.2722], [-121.02458, 39.27233], [-121.02428, 39.27257], [-121.02436, 39.27291], [-121.02413, 39.27301], [-121.02351, 39.2731], [-121.02323, 39.2731], [-121.02296, 39.27305], [-121.02255, 39.27293], [-121.02227, 39.27278], [-121.02207, 39.27253], [-121.02238, 39.27212], [-121.02238, 39.27195], [-121.02298, 39.2717], [-121.02307, 39.27154], [-121.02315, 39.27146], [-121.02322, 39.2713], [-121.02336, 39.27113], [-121.02397, 39.27013], [-121.02405, 39.27005], [-121.02429, 39.27012], [-121.02424, 39.27023], [-121.02421, 39.27049], [-121.02429, 39.27056], [-121.02446, 39.27055], [-121.02472, 39.27038], [-121.02453, 39.27084], [-121.02463, 39.2712], [-121.02525, 39.27137]]]} | Open Access 1 | Tobiassen Park | 28508 | 361 | Nevada, County of 1089 | County 3 | County Agency 3 | http://mynevadacounty.com/ | County 3 | 10.979 | Tobiassen Park | ||
11835 | 11835 | 11834 | {"type": "Polygon", "coordinates": [[[-118.81765, 36.13081], [-118.81735, 36.13107], [-118.81709, 36.13088], [-118.81696, 36.13099], [-118.81693, 36.13097], [-118.81688, 36.13102], [-118.81664, 36.13084], [-118.81712, 36.13041], [-118.81765, 36.13081]]]} | Open Access 1 | Springville Veterans Memorial Park | 28480 | 2353 | Springville Memorial District 1088 | Special District 4 | Special District - Other 24 | Special District 4 | 0.832 | Springville Veterans Memorial Park | |||
11858 | 11858 | 11857 | {"type": "Polygon", "coordinates": [[[-117.33599, 34.59944], [-117.33599, 34.5995], [-117.33454, 34.60022], [-117.3345, 34.60023], [-117.33446, 34.60022], [-117.33402, 34.59962], [-117.33403, 34.59956], [-117.3355, 34.59883], [-117.33556, 34.59885], [-117.33599, 34.59944]]]} | Open Access 1 | Oro Grande Park | 28514 | 2355 | County Service Area 42 1087 | Special District 4 | Special District - Other 24 | http://specialdistricts.org/index.aspx?page=404 | Special District 4 | 3.531 | Oro Grande Park | ||
11802 | 11802 | 11801 | {"type": "Polygon", "coordinates": [[[-120.70579, 38.3017], [-120.70573, 38.30198], [-120.70526, 38.30193], [-120.70527, 38.30181], [-120.70536, 38.30152], [-120.70544, 38.30153], [-120.70546, 38.30156], [-120.70552, 38.30157], [-120.70551, 38.30168], [-120.70579, 38.3017]]]} | Open Access 1 | Shutter Tree Park | 28439 | 350 | Calaveras, County of 1086 | County 3 | County Agency 3 | http://co.calaveras.ca.us/ | County 3 | 0.372 | Shutter Tree Park | ||
11853 | 11853 | 11852 | {"type": "Polygon", "coordinates": [[[-120.34443, 38.26473], [-120.34436, 38.26898], [-120.34298, 38.26918], [-120.34042, 38.2728], [-120.33898, 38.27538], [-120.33742, 38.27467], [-120.33708, 38.27336], [-120.33764, 38.271], [-120.33958, 38.26716], [-120.33976, 38.26714], [-120.33976, 38.26654], [-120.3405, 38.26662], [-120.34091, 38.26612], [-120.34127, 38.26616], [-120.34133, 38.26589], [-120.34147, 38.26588], [-120.34157, 38.26581], [-120.34172, 38.26567], [-120.34196, 38.26552], [-120.34244, 38.26534], [-120.34271, 38.26528], [-120.34298, 38.26524], [-120.34341, 38.26524], [-120.34361, 38.2652], [-120.3438, 38.26512], [-120.34433, 38.26482], [-120.34443, 38.26473]]]} | Open Access 1 | White Pines Park | 28500 | 350 | Calaveras, County of 1086 | County 3 | County Agency 3 | http://co.calaveras.ca.us/ | County 3 | 89.753 | White Pines Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);