units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
704 rows where DES_TP = 2 and MNG_AG_TYP = 4 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- East Bay Regional Park District 76
- Hayward Area Recreation and Park District 74
- Valley-Wide Recreation and Park District 53
- Rancho Simi Recreation and Park District 42
- Cordova Recreation and Park District 37
- Southgate Recreation and Park District 34
- Greater Vallejo Recreation and Park District 29
- Conejo Recreation and Park District 25
- Pleasant Valley Recreation and Park District 25
- Sunrise Recreation and Park District 25
- North of the River Recreation and Park District 24
- Jurupa Area Recreation and Park District 16
- Mission Oaks Recreation and Park District 14
- Isla Vista Recreation and Park District 12
- Carmichael Recreation and Park District 10
- North Highland Recreation and Park District 10
- Auburn Area Recreation and Park District 9
- Pleasant Hill Recreation and Park District 9
- Hesperia Recreation and Park District 9
- Monterey Peninsula Regional Park District 8
- Desert Recreation District 8
- Fair Oaks Recreation and Park District 8
- Livermore Area Recreation and Park District 7
- Rio Linda Elverta Recreation and Park District 7
- Big Bear Valley Recreation and Park District 7
- Feather River Recreation and Park District 6
- Boulder Creek Recreation and Park District 5
- Miraleste Recreation and Park District 5
- Orangevale Recreation and Park District 5
- Coalinga-Huron Recreation and Park District 4
- …
ACCESS_TYP 3
- Open Access 639
- No Public Access 27
- Restricted Access 18
MNG_AG_TYP 1
- Recreation/Parks District · 684 ✖
DES_TP 1
- Local Park · 684 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16854 | 16854 | 16853 | {"type": "Polygon", "coordinates": [[[-122.27281, 37.7628], [-122.27158, 37.76221], [-122.25694, 37.75677], [-122.25495, 37.75605], [-122.25057, 37.75438], [-122.24678, 37.75296], [-122.24667, 37.75307], [-122.24506, 37.75247], [-122.23877, 37.75051], [-122.23679, 37.74987], [-122.23701, 37.74992], [-122.23762, 37.75012], [-122.23783, 37.75017], [-122.23803, 37.75025], [-122.23854, 37.75039], [-122.23935, 37.75064], [-122.23973, 37.7507], [-122.24, 37.75076], [-122.24037, 37.75089], [-122.24067, 37.75091], [-122.24082, 37.75098], [-122.24094, 37.75106], [-122.24105, 37.7511], [-122.24119, 37.75113], [-122.24164, 37.75117], [-122.24183, 37.75116], [-122.24206, 37.75119], [-122.24283, 37.75148], [-122.24307, 37.75153], [-122.24327, 37.75161], [-122.24361, 37.75182], [-122.2437, 37.75185], [-122.24381, 37.75184], [-122.24391, 37.75181], [-122.24418, 37.75168], [-122.24432, 37.75167], [-122.24451, 37.75168], [-122.24464, 37.7517], [-122.24488, 37.75178], [-122.24503, 37.75181], [-122.2454, 37.75182], [-122.2457, 37.75188], [-122.24598, 37.75199], [-122.24614, 37.75208], [-122.24629, 37.7521], [-122.24662, 37.75211], [-122.2469, 37.75216], [-122.24704, 37.75222], [-122.24723, 37.75234], [-122.24741, 37.75237], [-122.24766, 37.75238], [-122.24792, 37.75235], [-122.24807, 37.75235], [-122.24853, 37.75245], [-122.24874, 37.75252], [-122.24895, 37.75264], [-122.24904, 37.75272], [-122.24908, 37.75279], [-122.2491, 37.7529], [-122.24913, 37.75299], [-122.24923, 37.75305], [-122.24936, 37.75308], [-122.24943, 37.75314], [-122.24947, 37.75326], [-122.24946, 37.75338], [-122.24951, 37.75343], [-122.24968, 37.75354], [-122.24987, 37.75363], [-122.25, 37.75371], [-122.25018, 37.75377], [-122.25024, 37.75376], [-122.25038, 37.75371], [-122.25048, 37.7537], [-122.25076, 37.7538], [-122.25101, 37.75394], [-122.25115, 37.75405], [-122.25127, 37.7541], [-122.25173, 37.75415], [-122.25242, 37.75433], [-122.25361, 37.7547], [-122.25394, 37.75483], [-122.2543, 37.75502], [-122.25492, 37.75527], [-122.25505, 37.75532], [-122.25512, 37.75533], [-122.25525, 37.75541], [-122.25561, 37.75555], [-122.25599, 37.75577], [-122.2562, 37.75586], [-122.2567, 37.75613], [-122.2575, 37.75644], [-122.25802, 37.7566], [-122.25877, 37.75693], [-122.25908, 37.7571], [-122.25986, 37.75741], [-122.26011, 37.75749], [-122.26051, 37.7575], [-122.2609, 37.75757], [-122.26136, 37.7577], [-122.26176, 37.75789], [-122.26223, 37.75816], [-122.26272, 37.75841], [-122.26334, 37.75869], [-122.26407, 37.75895], [-122.26445, 37.75906], [-122.2647, 37.75907], [-122.2656, 37.75939], [-122.26631, 37.75957], [-122.26674, 37.7597], [-122.26892, 37.76054], [-122.27008, 37.76105], [-122.27047, 37.7612], [-122.27093, 37.76141], [-122.27142, 37.7617], [-122.27203, 37.76211], [-122.27224, 37.76233], [-122.27273, 37.76269], [-122.27281, 37.7628]]]} | Open Access 1 | 46017 | Crown Memorial Regional Shoreline | 1486 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/crown_beach | Alameda 17 | 47.607 | Crown Memorial Reg. Shoreline | 1967 | Local Park 2 | 4 |
9693 | 9693 | 9692 | {"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 | 16378 | Ball Four Park | 15784 | 2301 | Arbuckle Parks and Recreation District 918 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | Colusa 49 | 5.419 | Ball Four Park | 0 | Local Park 2 | 4 | |
9700 | 9700 | 9699 | {"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 | 16386 | Wee Park | 27329 | 2301 | Arbuckle Parks and Recreation District 918 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | Colusa 49 | 0.721 | Wee Park | 0 | Local Park 2 | 4 | |
9704 | 9704 | 9703 | {"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 | 16403 | Memorial Park | 22144 | 2301 | Arbuckle Parks and Recreation District 918 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | Colusa 49 | 0.288 | Memorial Park | 0 | Local Park 2 | 4 | |
9705 | 9705 | 9704 | {"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 | 16415 | LaVanche Hursh Park | 21111 | 2301 | Arbuckle Parks and Recreation District 918 | Special District 4 | Recreation/Parks District 4 | http://arbuckleparksandrecreation.org/ | Special District 4 | 2301 | Arbuckle Parks and Recreation District 891 | Special District 4 | Recreation/Parks District 4 | Colusa 49 | 0.742 | LaVanche Hursh Park | 0 | Local Park 2 | 4 | |
3924 | 3924 | 3923 | {"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 | 36156 | Meadow Vista Park | 33688 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_meadow-vista.php | Placer 35 | 21.873 | Meadow Vista Park | 0 | Local Park 2 | 4 |
9097 | 9097 | 9096 | {"type": "Polygon", "coordinates": [[[-121.03287, 38.97744], [-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.03189, 38.97565], [-121.03249, 38.97552], [-121.03272, 38.97551], [-121.03268, 38.97718], [-121.03287, 38.97718], [-121.03287, 38.97744]]]} | Open Access 1 | 48994 | Sugarpine Ridge Park | 33690 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_sugarpine.php | Placer 35 | 8.053 | Sugarpine Ridge Park | 0 | Local Park 2 | 4 |
11222 | 11222 | 11221 | {"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.03374, 38.9589], [-121.03389, 38.95883], [-121.034, 38.95871], [-121.03411, 38.95853], [-121.03444, 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.98097], [-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 | 21556 | Christian Valley Park | 17226 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_christian-valley.php | Placer 35 | 21.912 | Christian Valley Park | 0 | Local Park 2 | 4 |
11223 | 11223 | 11222 | {"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.06446, 38.91872], [-121.06468, 38.91873]]]} | Open Access 1 | 21559 | Ashford Park | 15650 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_ashford.php | Placer 35 | 7.059 | Ashford Park | 0 | Local Park 2 | 4 |
14269 | 14269 | 14268 | {"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 | 44192 | Placer Hills Park | 23763 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_placer-hills.php | Placer 35 | 6.283 | Placer Hills Park | 0 | Local Park 2 | 4 |
15950 | 15950 | 15949 | {"type": "Polygon", "coordinates": [[[-121.10732, 38.95626], [-121.10451, 38.95631], [-121.10406, 38.95183], [-121.10279, 38.95142], [-121.10144, 38.95043], [-121.1013, 38.94998], [-121.10036, 38.94996], [-121.09999, 38.94985], [-121.09987, 38.94957], [-121.10027, 38.9497], [-121.10121, 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 | 36157 | Auburn Regional Park | 33689 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_regional.php | Placer 35 | 56.324 | Auburn RP | 0 | Local Park 2 | 4 |
3361 | 3361 | 3360 | {"type": "Polygon", "coordinates": [[[-116.94595, 34.2707], [-116.94595, 34.27072], [-116.94563, 34.27071], [-116.94562, 34.27077], [-116.94497, 34.27093], [-116.94464, 34.27093], [-116.94464, 34.27032], [-116.94497, 34.27032], [-116.94562, 34.2706], [-116.94562, 34.27069], [-116.94595, 34.2707]]]} | Open Access 1 | 24294 | Miller Park | 22245 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.155 | Miller Park | 0 | Local Park 2 | 4 | |
6773 | 6773 | 6772 | {"type": "Polygon", "coordinates": [[[-116.90495, 34.24779], [-116.90474, 34.24781], [-116.90462, 34.24807], [-116.90448, 34.24827], [-116.90431, 34.24846], [-116.90403, 34.24873], [-116.90396, 34.24889], [-116.90389, 34.24891], [-116.90385, 34.24888], [-116.90384, 34.24884], [-116.90405, 34.24859], [-116.9042, 34.24846], [-116.9043, 34.24833], [-116.90447, 34.24807], [-116.90457, 34.24781], [-116.90364, 34.24786], [-116.90349, 34.24799], [-116.90332, 34.2481], [-116.90318, 34.24817], [-116.90296, 34.24825], [-116.90253, 34.24807], [-116.90234, 34.24797], [-116.90204, 34.24794], [-116.9013, 34.24797], [-116.90048, 34.24739], [-116.89837, 34.24635], [-116.89837, 34.24628], [-116.90046, 34.24631], [-116.9026, 34.24714], [-116.90378, 34.24716], [-116.90436, 34.24666], [-116.90495, 34.24714], [-116.90495, 34.24779]]]} | Open Access 1 | 5242 | Meadow Park/ Ski Beach Park | 22077 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 14.954 | Meadow Park/ Ski Beach Park | 0 | Local Park 2 | 4 | |
11854 | 11854 | 11853 | {"type": "Polygon", "coordinates": [[[-116.80514, 34.23956], [-116.80401, 34.23957], [-116.80401, 34.23911], [-116.80513, 34.23911], [-116.80514, 34.23956]]]} | Open Access 1 | 24291 | Erwin Lake Park | 18700 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.293 | Erwin Lake Park | 0 | Local Park 2 | 4 | |
11856 | 11856 | 11855 | {"type": "Polygon", "coordinates": [[[-116.9437, 34.26661], [-116.94353, 34.26684], [-116.94343, 34.26702], [-116.94368, 34.26716], [-116.94319, 34.26782], [-116.94314, 34.26784], [-116.9431, 34.26783], [-116.94307, 34.26779], [-116.94306, 34.26702], [-116.94262, 34.26717], [-116.9425, 34.26666], [-116.94236, 34.26665], [-116.94236, 34.26662], [-116.94243, 34.26661], [-116.94235, 34.26648], [-116.94232, 34.26619], [-116.94237, 34.26586], [-116.94244, 34.26557], [-116.94254, 34.26533], [-116.94266, 34.2654], [-116.94281, 34.26529], [-116.94316, 34.26527], [-116.94339, 34.26541], [-116.94356, 34.26563], [-116.94368, 34.26603], [-116.94368, 34.26629], [-116.94363, 34.2666], [-116.9437, 34.26661]]]} | Open Access 1 | 24299 | Dana Point Park | 17913 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 5.904 | Dana Point Park | 0 | Local Park 2 | 4 | |
11858 | 11858 | 11857 | {"type": "Polygon", "coordinates": [[[-116.82518, 34.25059], [-116.82517, 34.25111], [-116.82511, 34.2514], [-116.82264, 34.2514], [-116.82262, 34.25055], [-116.82512, 34.25055], [-116.82516, 34.25057], [-116.82518, 34.25059]]]} | Open Access 1 | 24303 | Sugarloaf Park | 25945 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 5.455 | Sugarloaf Park | 0 | Local Park 2 | 4 | |
12012 | 12012 | 12011 | {"type": "Polygon", "coordinates": [[[-116.80742, 34.25033], [-116.80527, 34.25034], [-116.80523, 34.25032], [-116.8052, 34.25028], [-116.80519, 34.24883], [-116.8052, 34.2488], [-116.80525, 34.24878], [-116.80741, 34.24877], [-116.80742, 34.25033]]]} | Open Access 1 | 24682 | The Ranch | 26292 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 8.733 | The Ranch | 0 | Local Park 2 | 4 | |
14219 | 14219 | 14218 | {"type": "Polygon", "coordinates": [[[-116.84618, 34.26482], [-116.84437, 34.26482], [-116.84437, 34.26376], [-116.84458, 34.26376], [-116.84475, 34.26357], [-116.84509, 34.26291], [-116.8452, 34.26282], [-116.84548, 34.26282], [-116.84618, 34.26482]]]} | Open Access 1 | 44098 | Big Bear City Park | 16073 | 2207 | Big Bear Valley Recreation and Park District 626 | Special District 4 | Recreation/Parks District 4 | http://bigbearparks.com/ | Special District 4 | 2207 | Big Bear Valley Recreation and Park District 615 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 6.163 | Big Bear City Park | 0 | Local Park 2 | 4 | |
11883 | 11883 | 11882 | {"type": "Polygon", "coordinates": [[[-122.27794, 41.22417], [-122.27803, 41.22452], [-122.2779, 41.22595], [-122.2778, 41.22668], [-122.2773, 41.22731], [-122.27591, 41.22751], [-122.27598, 41.22489], [-122.27604, 41.22388], [-122.27657, 41.22391], [-122.27681, 41.22417], [-122.27794, 41.22417]]]} | Open Access 1 | 24339 | Dunsmuir City Park | 18308 | 2219 | Dunsmuir Recreation and Park District 999 | Special District 4 | Recreation/Parks District 4 | http://dunsmuirparks.org/ | Special District 4 | 2219 | Dunsmuir Recreation and Park District 962 | Special District 4 | Recreation/Parks District 4 | Siskiyou 28 | 14.439 | Dunsmuir City Park | 0 | Local Park 2 | 4 | |
7804 | 7804 | 7803 | {"type": "Polygon", "coordinates": [[[-122.42274, 38.39449], [-122.41856, 38.39451], [-122.4184, 38.39435], [-122.41835, 38.39431], [-122.41799, 38.39415], [-122.4177, 38.39404], [-122.41652, 38.39341], [-122.41618, 38.39306], [-122.41604, 38.39295], [-122.41586, 38.39286], [-122.4159, 38.39281], [-122.41587, 38.39273], [-122.41593, 38.39256], [-122.41485, 38.39153], [-122.4144, 38.39119], [-122.41397, 38.39091], [-122.41853, 38.39089], [-122.41855, 38.39111], [-122.4213, 38.39198], [-122.42177, 38.39216], [-122.42274, 38.39449]]]} | No Public Access 3 | 47687 | Amy's Grove | 31415 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 46.448 | Amy's Grove | 0 | Local Park 2 | 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]);