superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2,007 rows where LAYER = 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
- Joint Powers Authority 8
- Conservation District 5
- Transportation Agency 5
- Metropolitan Planning Organization 2
- Airport District 1
- Fire District 1
ACCESS_TYP 4
- Open Access 1,569
- No Public Access 195
- Restricted Access 139
- Unknown Access 104
MNG_AG_LEV 2 ✖
- Special District 2,000
- Joint 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15446 | 15446 | 15445 | {"type": "Polygon", "coordinates": [[[-118.86603, 34.26242], [-118.86562, 34.26252], [-118.86522, 34.26265], [-118.86394, 34.26316], [-118.86356, 34.26328], [-118.86317, 34.26338], [-118.86264, 34.26347], [-118.86097, 34.26346], [-118.86089, 34.2628], [-118.8609, 34.26237], [-118.86095, 34.26211], [-118.861, 34.2619], [-118.86109, 34.26165], [-118.86118, 34.26145], [-118.86138, 34.26111], [-118.86163, 34.2608], [-118.86183, 34.2606], [-118.86237, 34.26013], [-118.8626, 34.25991], [-118.86281, 34.25968], [-118.86305, 34.25937], [-118.86326, 34.25903], [-118.86447, 34.25686], [-118.86461, 34.25655], [-118.8647, 34.25629], [-118.86476, 34.25603], [-118.86479, 34.2557], [-118.86478, 34.25538], [-118.86473, 34.25506], [-118.86461, 34.25463], [-118.86413, 34.25349], [-118.86406, 34.25324], [-118.86401, 34.25298], [-118.86399, 34.25267], [-118.86401, 34.25241], [-118.86406, 34.2521], [-118.86415, 34.2518], [-118.86428, 34.25151], [-118.86444, 34.25123], [-118.86461, 34.25101], [-118.86483, 34.25076], [-118.86509, 34.25053], [-118.86537, 34.25033], [-118.86568, 34.25015], [-118.86601, 34.25], [-118.86601, 34.25267], [-118.86509, 34.25268], [-118.86509, 34.25348], [-118.86601, 34.2535], [-118.86603, 34.26242]]]} | Open Access 1 | Moorpark Watershed, Parks, Recreation and Conservation Authority Open Space | 33712 | 502 | Moorpark Watershed, Parks, Recreation and Conservation Authority 1115 | Joint 8 | Joint Powers Authority 23 | http://smmc.ca.gov/Moorpark%20Watershed%20Parks%20Recreation%20and%20Conservation%20Authority.html | Special District 4 | 80.693 | Moorpark Watershed, Parks, Rec. and Conservation Authority OS | ||
346 | 346 | 345 | {"type": "Polygon", "coordinates": [[[-121.70881, 37.05148], [-121.70881, 37.05521], [-121.70362, 37.05528], [-121.7038, 37.06238], [-121.69622, 37.06245], [-121.69514, 37.06244], [-121.69439, 37.06355], [-121.69444, 37.0639], [-121.69444, 37.06407], [-121.69411, 37.0645], [-121.6941, 37.06458], [-121.69364, 37.06462], [-121.69249, 37.0636], [-121.69248, 37.05907], [-121.69522, 37.05905], [-121.69519, 37.05511], [-121.69504, 37.05144], [-121.69974, 37.05144], [-121.69975, 37.04779], [-121.70426, 37.0478], [-121.70428, 37.05146], [-121.70881, 37.05148]]]} | No Public Access 3 | Uvas South Open Space Regional Reserve | https://www.scv-habitatagency.org/ | 33792 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Special District 4 | 347.767 | Uvas South OS RR | |
524 | 524 | 523 | {"type": "Polygon", "coordinates": [[[-121.68265, 37.13906], [-121.67601, 37.14237], [-121.67267, 37.13922], [-121.67394, 37.13832], [-121.67414, 37.13831], [-121.67417, 37.13816], [-121.67414, 37.13806], [-121.67415, 37.138], [-121.67421, 37.13787], [-121.67433, 37.13771], [-121.6747, 37.13787], [-121.6761, 37.13687], [-121.67571, 37.13647], [-121.67744, 37.13531], [-121.67854, 37.13499], [-121.68054, 37.1365], [-121.68265, 37.13906]]]} | Restricted Access 2 | Davidson Open Space Regional Reserve | https://www.scv-habitatagency.org/ | 33795 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Special District 4 | 93.919 | Davidson OS RR | |
3214 | 3214 | 3213 | {"type": "Polygon", "coordinates": [[[-121.75635, 37.21971], [-121.75564, 37.22071], [-121.75151, 37.22609], [-121.75121, 37.2259], [-121.75107, 37.22578], [-121.75107, 37.22539], [-121.75109, 37.22526], [-121.7512, 37.225], [-121.74995, 37.22425], [-121.74922, 37.22423], [-121.74873, 37.22405], [-121.74844, 37.22381], [-121.74917, 37.22299], [-121.75427, 37.22089], [-121.75529, 37.22009], [-121.75635, 37.21971]]]} | Restricted Access 2 | Tulare Hill Wedge Open Space Regional Reserve | https://www.scv-habitatagency.org/ | 33796 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Special District 4 | 37.501 | Tulare Hill Wedge OS RR | |
15029 | 15029 | 15028 | {"type": "Polygon", "coordinates": [[[-121.6993, 37.1374], [-121.69927, 37.13758], [-121.69925, 37.13763], [-121.69897, 37.1379], [-121.69889, 37.13803], [-121.69886, 37.13818], [-121.69891, 37.13845], [-121.69887, 37.13856], [-121.69879, 37.13863], [-121.69835, 37.13886], [-121.69819, 37.13898], [-121.69811, 37.13906], [-121.69804, 37.13918], [-121.698, 37.13927], [-121.69798, 37.1394], [-121.69502, 37.13926], [-121.69459, 37.1423], [-121.69774, 37.14279], [-121.69751, 37.1432], [-121.69747, 37.14338], [-121.69749, 37.14348], [-121.69753, 37.14359], [-121.69773, 37.14385], [-121.69774, 37.1439], [-121.6977, 37.14408], [-121.69774, 37.14423], [-121.69782, 37.14433], [-121.69793, 37.14441], [-121.69814, 37.14449], [-121.6985, 37.14457], [-121.69858, 37.14461], [-121.69862, 37.14465], [-121.69873, 37.14492], [-121.69878, 37.145], [-121.69885, 37.14507], [-121.69906, 37.14521], [-121.69907, 37.14526], [-121.69904, 37.1453], [-121.69893, 37.14534], [-121.69881, 37.14534], [-121.69868, 37.14529], [-121.69841, 37.14513], [-121.69831, 37.1451], [-121.69784, 37.14504], [-121.69732, 37.1449], [-121.69711, 37.14489], [-121.69657, 37.14502], [-121.69609, 37.1451], [-121.69592, 37.14514], [-121.69575, 37.14523], [-121.69534, 37.14556], [-121.69428, 37.14477], [-121.69077, 37.14709], [-121.68949, 37.14741], [-121.6883, 37.14735], [-121.68766, 37.14771], [-121.68593, 37.14831], [-121.68474, 37.14958], [-121.6848, 37.15033], [-121.68234, 37.15043], [-121.68145, 37.15097], [-121.68134, 37.15101], [-121.68069, 37.15066], [-121.67969, 37.1506], [-121.6794, 37.15055], [-121.67913, 37.15046], [-121.67887, 37.15036], [-121.67862, 37.15023], [-121.67818, 37.15011], [-121.67231, 37.14686], [-121.67231, 37.14683], [-121.67103, 37.14611], [-121.67103, 37.14609], [-121.67071, 37.14589], [-121.67035, 37.14558], [-121.67011, 37.1453], [-121.68383, 37.13848], [-121.69306, 37.1338], [-121.69859, 37.13656], [-121.69833, 37.13693], [-121.6993, 37.1374]]]} | Restricted Access 2 | Baird Open Space Regional Reserve | https://www.scv-habitatagency.org/ | 33794 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Special District 4 | 597.913 | Baird OS RR | |
15030 | 15030 | 15029 | {"type": "MultiPolygon", "coordinates": [[[[-121.33318, 37.01942], [-121.33188, 37.02043], [-121.33185, 37.02053], [-121.33057, 37.02153], [-121.33034, 37.02154], [-121.32884, 37.02266], [-121.32829, 37.02321], [-121.32786, 37.02395], [-121.32768, 37.02432], [-121.32755, 37.02471], [-121.32745, 37.0251], [-121.32742, 37.02652], [-121.32737, 37.0269], [-121.32722, 37.02747], [-121.32709, 37.02784], [-121.32692, 37.0282], [-121.32672, 37.02855], [-121.32649, 37.02888], [-121.32623, 37.02921], [-121.3252, 37.03042], [-121.32465, 37.03112], [-121.32441, 37.03131], [-121.32412, 37.03164], [-121.32389, 37.03184], [-121.32365, 37.03202], [-121.3234, 37.03219], [-121.32313, 37.03235], [-121.32284, 37.03249], [-121.32254, 37.03261], [-121.31959, 37.03369], [-121.31926, 37.03379], [-121.3186, 37.03397], [-121.31804, 37.03408], [-121.3177, 37.03412], [-121.31603, 37.03443], [-121.31486, 37.03474], [-121.31471, 37.03445], [-121.31679, 37.03365], [-121.31661, 37.03311], [-121.31967, 37.03186], [-121.31922, 37.03113], [-121.32124, 37.03039], [-121.32143, 37.0303], [-121.3216, 37.0302], [-121.32172, 37.0301], [-121.32223, 37.02959], [-121.32263, 37.02907], [-121.32378, 37.02772], [-121.32397, 37.02745], [-121.32412, 37.02716], [-121.32424, 37.02686], [-121.32431, 37.02656], [-121.32434, 37.02635], [-121.3244, 37.02473], [-121.32454, 37.02415], [-121.32474, 37.02358], [-121.32499, 37.02302], [-121.32573, 37.02181], [-121.32578, 37.02182], [-121.32633, 37.02319], [-121.32831, 37.02267], [-121.32846, 37.02224], [-121.32838, 37.02221], [-121.32871, 37.02123], [-121.33079, 37.01895], [-121.33135, 37.01868], [-121.33202, 37.0188], [-121.33318, 37.01942]]], [[[-121.3394, 37.01452], [-121.33674, 37.01658], [-121.33659, 37.01662], [-121.33598, 37.01721], [-121.33518, 37.01785], [-121.33503, 37.01782], [-121.33494, 37.01789], [-121.33498, 37.01801], [-121.33349, 37.01917], [-121.33146, 37.01808], [-121.33411, 37.01517], [-121.33462, 37.01488], [-121.33712, 37.01426], [-121.3394, 37.01452]]]]} | Restricted Access 2 | Pacheco Creek Open Space Regional Reserve | https://www.scv-habitatagency.org/ | 33793 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Special District 4 | 162.411 | Pacheco Creek OS RR | |
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 |
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]);