superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2,000 rows where MNG_AG_LEV = 4 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 181
- East Bay Regional Park District 132
- Consumnes Community Services District 92
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 67
- Rancho Simi Recreation and Park District 53
- Yuba County Water Agency 50
- Conejo Recreation and Park District 44
- Midpeninsula Regional Open Space District 43
- Southgate Recreation and Park District 40
- Marin County Open Space District 39
- Conejo Open Space Conservation Agency 39
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 36
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 31
- Fresno Metropolitan Flood Control District 29
- North of the River Recreation and Park District 27
- Monterey Peninsula Regional Park District 24
- El Dorado Hills Community Service District 24
- Santa Clara Valley Open Space Authority 23
- Olivehurst Public Utility District 23
- Sonoma County Agricultural Preservation and Open Space District 21
- Natomas Basin Conservancy 20
- San Diego Unified Port District 19
- Jurupa Area Recreation and Park District 18
- Santa Barbara Flood Control and Water Conserv. District 16
- Los Angeles County Flood Control District 16
- Los Angeles Unified School District 16
- Desert Recreation District 15
- …
MNG_AG_TYP 17
- Recreation/Parks District 1,091
- Open Space District 241
- Community Services District 193
- Water District 187
- Flood District 94
- Cemetery District 61
- School District 38
- Port/Harbor District 32
- Irrigation District 24
- Special District - Other 15
- Sanitation District 9
- Conservation District 5
- Transportation Agency 5
- Metropolitan Planning Organization 2
- Airport District 1
- Joint Powers Authority 1
- Fire District 1
ACCESS_TYP 4
- Open Access 1,567
- No Public Access 194
- Restricted Access 135
- Unknown Access 104
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14315 | 14315 | 14314 | {"type": "Polygon", "coordinates": [[[-121.79158, 37.67939], [-121.79158, 37.67946], [-121.79149, 37.67979], [-121.79049, 37.6798], [-121.78952, 37.6799], [-121.78852, 37.67912], [-121.78813, 37.67868], [-121.78776, 37.6781], [-121.78856, 37.67806], [-121.78921, 37.67793], [-121.78982, 37.67789], [-121.79032, 37.67778], [-121.79055, 37.67842], [-121.79149, 37.67827], [-121.79153, 37.67865], [-121.79159, 37.67899], [-121.79158, 37.67939]]]} | Open Access 1 | Unnamed site - Alameda County Flood Control and Water Conservation District | 28716 | 2000 | Alameda County Flood Control and Water Conservation District 752 | Special District 4 | Flood District 9 | http://acfloodcontrol.org/ | Special District 4 | 13.151 | |||
1473 | 1473 | 1472 | {"type": "Polygon", "coordinates": [[[-121.94024, 38.01658], [-121.93979, 38.01658], [-121.93977, 38.01672], [-121.93947, 38.01674], [-121.9395, 38.01831], [-121.93948, 38.01832], [-121.93914, 38.01842], [-121.93876, 38.01847], [-121.93842, 38.01836], [-121.93821, 38.01832], [-121.9382, 38.01825], [-121.93793, 38.01815], [-121.9373, 38.01768], [-121.93773, 38.01605], [-121.94023, 38.01603], [-121.94024, 38.01658]]]} | Open Access 1 | Ambrose Park | 15445 | 2001 | Ambrose Recreation and Park District 213 | Special District 4 | Recreation/Parks District 4 | http://www.ambroserec.org/ | Special District 4 | 11.751 | Ambrose Park | ||
1517 | 1517 | 1516 | {"type": "Polygon", "coordinates": [[[-121.93962, 38.02603], [-121.93962, 38.02658], [-121.93958, 38.02664], [-121.93745, 38.02664], [-121.93744, 38.02609], [-121.93911, 38.02609], [-121.93962, 38.02603]]]} | Open Access 1 | Anuta Park | 15526 | 2001 | Ambrose Recreation and Park District 213 | Special District 4 | Recreation/Parks District 4 | http://www.ambroserec.org/ | Special District 4 | 2.895 | Anuta Park | ||
14207 | 14207 | 14206 | {"type": "Polygon", "coordinates": [[[-121.95011, 38.02426], [-121.95, 38.02587], [-121.95007, 38.0259], [-121.95002, 38.02667], [-121.94884, 38.02667], [-121.94884, 38.02395], [-121.95011, 38.02426]]]} | Open Access 1 | Ambrose Center Park | https://www.ambroserec.org/ambrose-center-park | 32665 | 2001 | Ambrose Recreation and Park District 213 | Special District 4 | Recreation/Parks District 4 | http://www.ambroserec.org/ | Special District 4 | 7.507 | Ambrose Ctr. Park | 1973 |
5107 | 5107 | 5106 | {"type": "MultiPolygon", "coordinates": [[[[-121.88803, 36.96112], [-121.88733, 36.96103], [-121.88667, 36.96038], [-121.88723, 36.95904], [-121.88785, 36.95921], [-121.88767, 36.95954], [-121.88759, 36.96033], [-121.88751, 36.9606], [-121.88803, 36.96112]]], [[[-121.88834, 36.95777], [-121.88826, 36.95785], [-121.88803, 36.95793], [-121.88785, 36.95843], [-121.88779, 36.95806], [-121.88824, 36.95754], [-121.88834, 36.95777]]]]} | Open Access 1 | Hidden Beach Park - Aptos Sanitation District | 19903 | 2002 | Aptos Sanitation District 903 | Special District 4 | Sanitation District 19 | http://www.dpw.co.santa-cruz.ca.us/Sanitation.htm | Special District 4 | 3.727 | Hidden Beach Park - Aptos Sanitation District | ||
1631 | 1631 | 1630 | {"type": "Polygon", "coordinates": [[[-121.06468, 38.91873], [-121.06431, 38.91933], [-121.06366, 38.91966], [-121.06329, 38.91982], [-121.063, 38.91991], [-121.063, 38.91944], [-121.0622, 38.91748], [-121.06238, 38.91737], [-121.06257, 38.91741], [-121.06446, 38.91859], [-121.06447, 38.91872], [-121.06468, 38.91873]]]} | Open Access 1 | Ashford Park | http://www.auburnrec.com/parks_ashford.php | 15650 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 7.06 | Ashford Park | |
1663 | 1663 | 1662 | {"type": "Polygon", "coordinates": [[[-121.10884, 38.95035], [-121.10789, 38.95042], [-121.10787, 38.95046], [-121.10748, 38.95048], [-121.10748, 38.94927], [-121.1088, 38.94923], [-121.10884, 38.95035]]]} | Open Access 1 | Auburn Recreation District 1 | 15695 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 3.704 | Auburn Rec. District 1 | ||
2919 | 2919 | 2918 | {"type": "MultiPolygon", "coordinates": [[[[-121.03745, 38.95721], [-121.03709, 38.95795], [-121.03689, 38.95845], [-121.03671, 38.95873], [-121.03598, 38.95955], [-121.03574, 38.95986], [-121.03541, 38.96038], [-121.0353, 38.96067], [-121.03422, 38.96068], [-121.03418, 38.96038], [-121.03427, 38.9602], [-121.03401, 38.95986], [-121.03387, 38.95963], [-121.03366, 38.95954], [-121.03325, 38.95969], [-121.03316, 38.95968], [-121.03311, 38.95927], [-121.03311, 38.95906], [-121.03322, 38.95893], [-121.03337, 38.9589], [-121.03375, 38.9589], [-121.03389, 38.95883], [-121.034, 38.95871], [-121.03411, 38.95853], [-121.03445, 38.95869], [-121.03539, 38.95784], [-121.03643, 38.95726], [-121.03666, 38.95719], [-121.03689, 38.95714], [-121.03725, 38.95712], [-121.03745, 38.95721]]], [[[-121.08528, 38.98459], [-121.08516, 38.98556], [-121.08401, 38.98557], [-121.08403, 38.98528], [-121.08431, 38.98491], [-121.08458, 38.98476], [-121.08528, 38.98459]]], [[[-121.08869, 38.98555], [-121.08869, 38.98555], [-121.0866, 38.98555], [-121.08785, 38.9849], [-121.08814, 38.9848], [-121.08868, 38.98429], [-121.08869, 38.98555]]], [[[-121.09018, 38.98115], [-121.08998, 38.98112], [-121.08999, 38.98096], [-121.08996, 38.98079], [-121.08987, 38.98062], [-121.08974, 38.98049], [-121.0899, 38.98033], [-121.0899, 38.98038], [-121.09006, 38.98056], [-121.09016, 38.98075], [-121.0902, 38.98095], [-121.09018, 38.98115]]]]} | Open Access 1 | Christian Valley Park | http://www.auburnrec.com/parks_christian-valley.php | 17226 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 21.916 | Christian Valley Park | |
8220 | 8220 | 8219 | {"type": "MultiPolygon", "coordinates": [[[[-121.02494, 38.99785], [-121.02393, 38.99791], [-121.02363, 38.99776], [-121.02283, 38.99767], [-121.023, 38.99692], [-121.02465, 38.99688], [-121.02494, 38.99785]]], [[[-121.02542, 38.99876], [-121.02443, 38.99884], [-121.02388, 38.99806], [-121.02516, 38.99798], [-121.02542, 38.99876]]]]} | Open Access 1 | Placer Hills Park | http://www.auburnrec.com/parks_placer-hills.php | 23763 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 6.282 | Placer Hills Park | |
8605 | 8605 | 8604 | {"type": "Polygon", "coordinates": [[[-121.02737, 38.9946], [-121.02673, 38.99428], [-121.02649, 38.9942], [-121.02396, 38.99405], [-121.02378, 38.99389], [-121.02389, 38.99331], [-121.02415, 38.99239], [-121.02422, 38.99208], [-121.02426, 38.99176], [-121.02426, 38.99135], [-121.02484, 38.99142], [-121.0273, 38.99139], [-121.02737, 38.9946]]]} | Open Access 1 | Meadow Vista Park | http://www.auburnrec.com/parks_meadow-vista.php | 33688 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 21.873 | Meadow Vista Park | |
8613 | 8613 | 8612 | {"type": "Polygon", "coordinates": [[[-121.10732, 38.95626], [-121.10451, 38.95631], [-121.10406, 38.95183], [-121.10279, 38.95142], [-121.10144, 38.95043], [-121.10129, 38.94998], [-121.10036, 38.94996], [-121.09999, 38.94985], [-121.09987, 38.94957], [-121.10027, 38.9497], [-121.1012, 38.94971], [-121.10121, 38.9497], [-121.10115, 38.94947], [-121.10127, 38.94963], [-121.10135, 38.9497], [-121.10149, 38.94977], [-121.10199, 38.94994], [-121.10238, 38.95], [-121.10269, 38.94999], [-121.10324, 38.94992], [-121.10364, 38.94996], [-121.1071, 38.94987], [-121.10711, 38.94998], [-121.10731, 38.94996], [-121.10731, 38.95207], [-121.10735, 38.95531], [-121.10733, 38.9556], [-121.10732, 38.95626]]]} | Open Access 1 | Auburn Regional Park | http://www.auburnrec.com/parks_regional.php | 33689 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 56.337 | Auburn RP | |
8671 | 8671 | 8670 | {"type": "Polygon", "coordinates": [[[-121.03287, 38.97743], [-121.03214, 38.97744], [-121.03101, 38.97718], [-121.03108, 38.97711], [-121.03122, 38.97706], [-121.03127, 38.977], [-121.03128, 38.97694], [-121.03126, 38.97689], [-121.03121, 38.97685], [-121.03115, 38.97682], [-121.03105, 38.97682], [-121.03096, 38.97687], [-121.03093, 38.97693], [-121.03092, 38.97703], [-121.03083, 38.97715], [-121.03012, 38.97682], [-121.03039, 38.9766], [-121.03059, 38.97629], [-121.03071, 38.97617], [-121.03115, 38.97583], [-121.03148, 38.97573], [-121.03249, 38.97552], [-121.03272, 38.97551], [-121.03268, 38.97717], [-121.03287, 38.97718], [-121.03287, 38.97743]]]} | Open Access 1 | Sugarpine Ridge Park | http://www.auburnrec.com/parks_sugarpine.php | 33690 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 8.067 | Sugarpine Ridge Park | |
13763 | 13763 | 13762 | {"type": "Polygon", "coordinates": [[[-121.07745, 38.89517], [-121.07673, 38.89523], [-121.07619, 38.89551], [-121.07584, 38.8954], [-121.07647, 38.89454], [-121.07666, 38.89464], [-121.07666, 38.89501], [-121.07744, 38.89496], [-121.07745, 38.89517]]]} | Open Access 1 | Bicentennial Park | http://www.auburnrec.com/parks_bicentennial.php | 31270 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 1.457 | Bicentennial Park | |
13767 | 13767 | 13766 | {"type": "Polygon", "coordinates": [[[-121.07803, 38.89568], [-121.07803, 38.89571], [-121.07746, 38.8957], [-121.07748, 38.89564], [-121.07803, 38.89568]]]} | Open Access 1 | Herschel Young Park | 31275 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 0.061 | Herschel Young Park | ||
14416 | 14416 | 14415 | {"type": "Polygon", "coordinates": [[[-121.076, 38.88682], [-121.07557, 38.88683], [-121.07503, 38.88688], [-121.07451, 38.88696], [-121.07409, 38.88705], [-121.07249, 38.88759], [-121.07175, 38.88795], [-121.07161, 38.8875], [-121.07166, 38.88747], [-121.07166, 38.88711], [-121.07176, 38.88677], [-121.07185, 38.88667], [-121.07219, 38.88647], [-121.07232, 38.88631], [-121.07265, 38.88601], [-121.07292, 38.88593], [-121.07309, 38.88592], [-121.07325, 38.88593], [-121.0738, 38.88606], [-121.07413, 38.8861], [-121.07443, 38.88607], [-121.07496, 38.88595], [-121.07513, 38.88597], [-121.07535, 38.88594], [-121.07539, 38.88636], [-121.07595, 38.88636], [-121.076, 38.88682]]]} | Open Access 1 | Railhead Park | http://www.auburnrec.com/parks_railhead.php | 33471 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 10.962 | Railhead Park | |
15237 | 15237 | 15236 | {"type": "Polygon", "coordinates": [[[-121.08019, 38.88362], [-121.08017, 38.8873], [-121.08018, 38.88871], [-121.07996, 38.88872], [-121.07997, 38.89012], [-121.07901, 38.89031], [-121.07869, 38.89031], [-121.07837, 38.89027], [-121.07817, 38.88988], [-121.07792, 38.88832], [-121.07785, 38.88746], [-121.07815, 38.88727], [-121.07848, 38.88699], [-121.07918, 38.88629], [-121.07938, 38.88606], [-121.07956, 38.88581], [-121.07969, 38.88557], [-121.07981, 38.88531], [-121.0799, 38.88504], [-121.07996, 38.88476], [-121.07998, 38.88454], [-121.07998, 38.88432], [-121.07991, 38.88363], [-121.08019, 38.88362]]]} | Open Access 1 | Recreation Park | http://www.auburnrec.com/parks_recreation.php | 24219 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 20.476 | Rec. Park | |
1760 | 1760 | 1759 | {"type": "Polygon", "coordinates": [[[-118.9423, 34.36055], [-118.9423, 34.36195], [-118.94129, 34.36223], [-118.94128, 34.36118], [-118.93907, 34.36194], [-118.93823, 34.36211], [-118.93755, 34.3607], [-118.93811, 34.3605], [-118.9423, 34.36055]]]} | Open Access 1 | Bardsdale Cemetery | 15812 | 2005 | Bardsdale Cemetery District 508 | Special District 4 | Cemetery District 11 | http://bardsdalecemetery.com/ | Special District 4 | 14.328 | Bardsdale Cemetery | ||
1875 | 1875 | 1874 | {"type": "Polygon", "coordinates": [[[-118.92086, 35.26268], [-118.92085, 35.26278], [-118.92079, 35.26281], [-118.92076, 35.26287], [-118.92075, 35.26294], [-118.92079, 35.26302], [-118.9208, 35.26341], [-118.91879, 35.2634], [-118.91879, 35.26218], [-118.91898, 35.26218], [-118.919, 35.26249], [-118.92076, 35.2625], [-118.92077, 35.26257], [-118.92081, 35.26263], [-118.92086, 35.26268]]]} | Open Access 1 | Bear Mountain Park | 15928 | 2006 | Bear Mountain Recreation and Park District 1069 | Special District 4 | Recreation/Parks District 4 | http://www.bearmtnprk.com/ | Special District 4 | 4.73 | Bear Mtn. Park | ||
14190 | 14190 | 14189 | {"type": "Polygon", "coordinates": [[[-118.92241, 35.23652], [-118.92241, 35.23775], [-118.92086, 35.23775], [-118.92086, 35.23653], [-118.92241, 35.23652]]]} | Open Access 1 | Weedpatch Park | 32818 | 2006 | Bear Mountain Recreation and Park District 1069 | Special District 4 | Recreation/Parks District 4 | http://www.bearmtnprk.com/ | Special District 4 | 4.735 | Weedpatch Park | ||
1870 | 1870 | 1869 | {"type": "Polygon", "coordinates": [[[-118.65798, 35.17081], [-118.6578, 35.1709], [-118.65757, 35.17099], [-118.65739, 35.17104], [-118.65691, 35.17114], [-118.65657, 35.17115], [-118.65646, 35.17117], [-118.65636, 35.17116], [-118.65616, 35.17116], [-118.6558, 35.17111], [-118.65549, 35.17103], [-118.65508, 35.17088], [-118.65347, 35.17007], [-118.65369, 35.16978], [-118.65381, 35.16954], [-118.65384, 35.16946], [-118.65404, 35.16856], [-118.65412, 35.16843], [-118.65421, 35.16832], [-118.65439, 35.16818], [-118.65448, 35.16813], [-118.65466, 35.16806], [-118.65572, 35.16787], [-118.65615, 35.16773], [-118.65652, 35.16844], [-118.65688, 35.16867], [-118.65791, 35.16929], [-118.65733, 35.16993], [-118.65798, 35.17081]]]} | Open Access 1 | Bear Valley Park | 15932 | 2007 | Bear Valley Springs Community Services District 478 | Special District 4 | Community Services District 17 | http://www.bvcsd.com/ | Special District 4 | 25.296 | Bear Valley 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]);