superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
931 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 4 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Hayward Area Recreation and Park District 77
- East Bay Regional Park District 73
- Valley-Wide Recreation and Park District 66
- Rancho Simi Recreation and Park District 51
- Conejo Recreation and Park District 41
- Sunrise Recreation and Park District 39
- Marin County Open Space District 38
- Southgate Recreation and Park District 38
- Cordova Recreation and Park District 36
- Greater Vallejo Recreation and Park District 32
- Pleasant Valley Recreation and Park District 31
- North of the River Recreation and Park District 27
- Midpeninsula Regional Open Space District 24
- Jurupa Area Recreation and Park District 18
- Monterey Peninsula Regional Park District 17
- Isla Vista Recreation and Park District 14
- Desert Recreation District 14
- Mission Oaks Recreation and Park District 14
- Pleasant Hill Recreation and Park District 12
- Carmichael Recreation and Park District 12
- Auburn Area Recreation and Park District 11
- North Highland Recreation and Park District 11
- Hesperia Recreation and Park District 10
- Miraleste Recreation and Park District 10
- Livermore Area Recreation and Park District 9
- Rio Linda Elverta Recreation and Park District 9
- Orangevale Recreation and Park District 9
- Fair Oaks Recreation and Park District 9
- Tuolumne Park and Recreation District 8
- Riverside County Regional Park and Open Space District 7
- …
MNG_AG_TYP 1
- Recreation/Parks District · 911 ✖
ACCESS_TYP 1
- Open Access · 911 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11495 | 11495 | 11494 | {"type": "Polygon", "coordinates": [[[-117.19678, 34.49915], [-117.19678, 34.5004], [-117.19625, 34.5004], [-117.19623, 34.50005], [-117.19617, 34.49975], [-117.19609, 34.49945], [-117.19597, 34.49916], [-117.19678, 34.49915]]]} | Open Access 1 | Yucca Loma Park | 27847 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 1.976 | Yucca Loma Park | |||
11888 | 11888 | 11887 | {"type": "Polygon", "coordinates": [[[-121.96105, 36.96553], [-121.96093, 36.96566], [-121.9605, 36.9653], [-121.96048, 36.96524], [-121.96044, 36.96518], [-121.96044, 36.96515], [-121.96055, 36.96512], [-121.96105, 36.96553]]]} | Open Access 1 | Privates Beach Accessway | 28594 | 2103 | Opal Cliffs Recreation District 1054 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 0.289 | Privates Beach Accessway | |||
13398 | 13398 | 13397 | {"type": "Polygon", "coordinates": [[[-121.21401, 36.33581], [-121.21125, 36.33739], [-121.2107, 36.33678], [-121.2099, 36.33723], [-121.2097, 36.3372], [-121.20858, 36.33591], [-121.21228, 36.33384], [-121.21401, 36.33581]]]} | Open Access 1 | Oak Park | 30778 | 2042 | Greenfield Public Recreation District 535 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 24.879 | Oak Park | |||
14283 | 14283 | 14282 | {"type": "Polygon", "coordinates": [[[-118.35128, 33.78024], [-118.35122, 33.78036], [-118.35108, 33.78051], [-118.35086, 33.78065], [-118.35069, 33.7807], [-118.35057, 33.78035], [-118.35092, 33.78032], [-118.35092, 33.78], [-118.35108, 33.78], [-118.35119, 33.78003], [-118.35127, 33.78011], [-118.35128, 33.78024]]]} | Open Access 1 | Unnamed site - Westfield Recreation and Park District | 28676 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 0.655 | ||||
14292 | 14292 | 14291 | {"type": "Polygon", "coordinates": [[[-118.36086, 33.76832], [-118.3608, 33.76862], [-118.36057, 33.76861], [-118.36041, 33.76865], [-118.36031, 33.76842], [-118.36043, 33.76817], [-118.36086, 33.76832]]]} | Open Access 1 | Unknown park - Westfield Recreation and Park District | 28677 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 0.462 | ||||
15547 | 15547 | 15546 | {"type": "Polygon", "coordinates": [[[-117.21516, 34.52544], [-117.2149, 34.52567], [-117.21459, 34.52587], [-117.21431, 34.52599], [-117.21392, 34.52613], [-117.21357, 34.5263], [-117.21326, 34.52651], [-117.21302, 34.52673], [-117.21227, 34.52624], [-117.2121, 34.52604], [-117.21002, 34.52408], [-117.21079, 34.52352], [-117.21273, 34.5235], [-117.21274, 34.52388], [-117.21516, 34.52544]]]} | Open Access 1 | Civic Center Park | 17368 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 21.172 | Civic Ctr. Park | |||
15566 | 15566 | 15565 | {"type": "Polygon", "coordinates": [[[-117.19004, 34.49668], [-117.19002, 34.49674], [-117.18994, 34.49677], [-117.18695, 34.4968], [-117.18694, 34.49682], [-117.18584, 34.49683], [-117.18583, 34.4934], [-117.18692, 34.4934], [-117.18694, 34.49509], [-117.18912, 34.49508], [-117.18913, 34.49583], [-117.19004, 34.49583], [-117.19004, 34.49668]]]} | Open Access 1 | James A Woody Community Center | 20340 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 21.047 | James A Woody Community Ctr. | |||
1283 | 1283 | 1282 | {"type": "Polygon", "coordinates": [[[-122.06313, 39.01813], [-122.06254, 39.01813], [-122.06198, 39.01814], [-122.06199, 39.01614], [-122.06312, 39.01613], [-122.06313, 39.01813]]]} | Open Access 1 | Ball Four Park | 15784 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 5.418 | Ball Four Park | ||
6058 | 6058 | 6057 | {"type": "Polygon", "coordinates": [[[-122.05765, 39.01799], [-122.05714, 39.01819], [-122.05681, 39.01768], [-122.05734, 39.01751], [-122.05765, 39.01799]]]} | Open Access 1 | LaVanche Hursh Park | 21111 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 0.742 | LaVanche Hursh Park | ||
6934 | 6934 | 6933 | {"type": "Polygon", "coordinates": [[[-122.05725, 39.01739], [-122.05695, 39.0175], [-122.05674, 39.01718], [-122.05702, 39.01706], [-122.05725, 39.01739]]]} | Open Access 1 | Memorial Park | 22144 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 0.288 | Memorial Park | ||
11079 | 11079 | 11078 | {"type": "Polygon", "coordinates": [[[-122.05603, 39.01389], [-122.05597, 39.01392], [-122.05585, 39.01392], [-122.05572, 39.01383], [-122.05561, 39.01382], [-122.05544, 39.01383], [-122.05532, 39.01386], [-122.05523, 39.01386], [-122.05508, 39.01374], [-122.05489, 39.01354], [-122.05489, 39.01349], [-122.05495, 39.01341], [-122.05503, 39.01336], [-122.05516, 39.01332], [-122.05603, 39.01389]]]} | Open Access 1 | Wee Park | 27329 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 0.721 | Wee Park | ||
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 |
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]);