units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
991 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 4 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 991 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
576 | 576 | 575 | {"type": "Polygon", "coordinates": [[[-122.14526, 37.74311], [-122.14524, 37.74315], [-122.14492, 37.74341], [-122.14434, 37.74398], [-122.14423, 37.74406], [-122.1437, 37.7433], [-122.14342, 37.74306], [-122.14482, 37.7425], [-122.14526, 37.74311]]]} | Open Access 1 | 3448 | Poaks Headquarters | 23819 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.419 | Poaks Headquarters | None 57 | |||
587 | 587 | 586 | {"type": "Polygon", "coordinates": [[[-119.01482, 34.20968], [-119.01465, 34.21039], [-119.01452, 34.21114], [-119.01418, 34.21111], [-119.014, 34.21118], [-119.01319, 34.21098], [-119.01318, 34.21095], [-119.01357, 34.20947], [-119.01362, 34.20945], [-119.01422, 34.20959], [-119.01433, 34.20959], [-119.01441, 34.20956], [-119.01445, 34.20961], [-119.01482, 34.20968]]]} | Open Access 1 | 1987 | Woodside Park - PVRPD | 27744 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 5.147 | Woodside Park - PVRPD | None 58 | |||
1549 | 1549 | 1548 | {"type": "Polygon", "coordinates": [[[-122.2434, 38.10352], [-122.24337, 38.10447], [-122.24248, 38.10446], [-122.24233, 38.1044], [-122.24153, 38.10439], [-122.24156, 38.10395], [-122.24157, 38.10349], [-122.24254, 38.10351], [-122.2434, 38.10352]]]} | Open Access 1 | 11545 | Children's Wonderland | 17196 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Childrens_Wonderland | Solano 26 | 4.081 | Children's Wonderland | None 122 | ||
2001 | 2001 | 2000 | {"type": "Polygon", "coordinates": [[[-119.476, 35.13679], [-119.47598, 35.13817], [-119.4743, 35.13818], [-119.4743, 35.1368], [-119.476, 35.13679]]]} | Open Access 1 | 15314 | Taft Heights Park (A Street Park) | 26164 | 2178 | West Side Recreation and Park District 467 | Special District 4 | Recreation/Parks District 4 | http://www.wsrpd.com/ | Special District 4 | 2178 | West Side Recreation and Park District 460 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 5.82 | Taft Heights Park (A Street Park) | None 159 | |||
2356 | 2356 | 2355 | {"type": "Polygon", "coordinates": [[[-121.7508, 38.02106], [-121.7506, 38.02106], [-121.75061, 38.02096], [-121.75065, 38.02095], [-121.75065, 38.01964], [-121.75066, 38.01963], [-121.75067, 38.01953], [-121.75076, 38.01953], [-121.75075, 38.02095], [-121.7508, 38.02096], [-121.7508, 38.02106]]]} | Open Access 1 | 17112 | Antioch Bridge Fishing Pier | 15522 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 0.397 | Antioch Bridge Fishing Pier | None 198 | |||
2628 | 2628 | 2627 | {"type": "Polygon", "coordinates": [[[-118.84231, 34.19564], [-118.84227, 34.19647], [-118.84184, 34.19646], [-118.84183, 34.19631], [-118.84174, 34.19621], [-118.84159, 34.1962], [-118.8415, 34.1963], [-118.84159, 34.19645], [-118.84038, 34.19642], [-118.84035, 34.1963], [-118.84001, 34.19634], [-118.83995, 34.196], [-118.84002, 34.19568], [-118.84038, 34.1958], [-118.84116, 34.19567], [-118.84155, 34.19567], [-118.84231, 34.19564]]]} | Open Access 1 | 18025 | Morrow Circle | 22506 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.053 | Morrow Circle | None 215 | |||
2699 | 2699 | 2698 | {"type": "Polygon", "coordinates": [[[-118.84721, 34.20202], [-118.8472, 34.20254], [-118.84648, 34.20252], [-118.846, 34.20241], [-118.84562, 34.20243], [-118.84515, 34.20253], [-118.84479, 34.20234], [-118.84429, 34.20217], [-118.84721, 34.20202]]]} | Open Access 1 | 18273 | Old Meadows FC | 23089 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 2.511 | Old Meadows FC | None 221 | |||
3351 | 3351 | 3350 | {"type": "Polygon", "coordinates": [[[-121.63593, 39.77761], [-121.63218, 39.77763], [-121.63219, 39.77495], [-121.63309, 39.77382], [-121.63173, 39.7738], [-121.63278, 39.77294], [-121.63294, 39.77294], [-121.63295, 39.7728], [-121.63365, 39.77224], [-121.63365, 39.77252], [-121.63359, 39.77253], [-121.63359, 39.77266], [-121.63317, 39.77267], [-121.63316, 39.77272], [-121.63305, 39.77273], [-121.63306, 39.77308], [-121.63589, 39.77309], [-121.63593, 39.77761]]]} | Open Access 1 | 24231 | Bill Park Expansion | 16108 | 2250 | Paradise Recreation and Park District 580 | Special District 4 | Recreation/Parks District 4 | http://www.paradiseprpd.com/ | Special District 4 | 2250 | Paradise Recreation and Park District 572 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 38.925 | Bill Park Expansion | None 273 | |||
3363 | 3363 | 3362 | {"type": "Polygon", "coordinates": [[[-120.1891, 39.3279], [-120.18813, 39.32838], [-120.18792, 39.32815], [-120.1889, 39.32764], [-120.1891, 39.3279]]]} | Open Access 1 | 24338 | Veterans Hall | 27021 | 2263 | Truckee-Donner Recreation and Park District 576 | Special District 4 | Recreation/Parks District 4 | http://www.tdrpd.com/ | Special District 4 | 2263 | Truckee-Donner Recreation and Park District 568 | Special District 4 | Recreation/Parks District 4 | Nevada 30 | 0.806 | Veterans Hall | None 274 | |||
3366 | 3366 | 3365 | {"type": "Polygon", "coordinates": [[[-123.02007, 38.4736], [-123.01905, 38.47432], [-123.01973, 38.47494], [-123.019, 38.4755], [-123.01754, 38.47486], [-123.01736, 38.47459], [-123.01653, 38.47281], [-123.0177, 38.47143], [-123.01778, 38.47153], [-123.02007, 38.4736]]]} | Open Access 1 | 24315 | Monte Rio Riverfront Meadow | 22391 | 2241 | Monte Rio Recreation and Park District 573 | Special District 4 | Recreation/Parks District 4 | http://www.mrrpd.org/ | Special District 4 | 2241 | Monte Rio Recreation and Park District 565 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 18.497 | Monte Rio Riverfront Meadow | None 275 | |||
3380 | 3380 | 3379 | {"type": "Polygon", "coordinates": [[[-122.95918, 38.42482], [-122.95872, 38.42509], [-122.95812, 38.42505], [-122.95782, 38.42498], [-122.95732, 38.42481], [-122.95714, 38.42469], [-122.95699, 38.42452], [-122.95772, 38.4242], [-122.95796, 38.42427], [-122.9584, 38.42451], [-122.95894, 38.42475], [-122.95918, 38.42482]]]} | Open Access 1 | 34933 | Camp Meeker | 16776 | 2294 | Camp Meeker Recreation and Parks District 632 | Special District 4 | Recreation/Parks District 4 | http://www.campmeeker.org/ | Special District 4 | 2294 | Camp Meeker Recreation and Parks District 621 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 2.494 | Camp Meeker | None 278 | |||
3817 | 3817 | 3816 | {"type": "Polygon", "coordinates": [[[-121.80256, 36.69071], [-121.80064, 36.68954], [-121.8013, 36.68878], [-121.8017, 36.68905], [-121.80185, 36.68917], [-121.80204, 36.68937], [-121.80221, 36.68959], [-121.80238, 36.6899], [-121.80249, 36.69019], [-121.80254, 36.69043], [-121.80256, 36.69071]]]} | Open Access 1 | 35194 | Monterey Peninsula Regional Park District 4 | 22427 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.919 | Monterey Peninsula RP District 4 | None 320 | |||
3987 | 3987 | 3986 | {"type": "Polygon", "coordinates": [[[-122.5132, 37.88901], [-122.51299, 37.88939], [-122.51302, 37.88987], [-122.51291, 37.88971], [-122.51269, 37.88951], [-122.51256, 37.88942], [-122.512, 37.88912], [-122.51221, 37.88897], [-122.51227, 37.88891], [-122.51227, 37.88889], [-122.51201, 37.88879], [-122.51114, 37.88826], [-122.51091, 37.88816], [-122.51077, 37.88816], [-122.51062, 37.88833], [-122.51058, 37.88831], [-122.51101, 37.88781], [-122.51272, 37.88864], [-122.51295, 37.88848], [-122.5132, 37.88901]]]} | Open Access 1 | 38041 | Strawberry Cove Park/Belloc Lagoon | 25913 | 2162 | Strawberry Recreation District 662 | Special District 4 | Recreation/Parks District 4 | http://strawberry.marin.org/ | Special District 4 | 2162 | Strawberry Recreation District 650 | Special District 4 | Recreation/Parks District 4 | Marin 23 | 3.478 | Strawberry Cove Park/Belloc Lagoon | None 346 | |||
4146 | 4146 | 4145 | {"type": "Polygon", "coordinates": [[[-116.89403, 33.75911], [-116.89402, 33.7592], [-116.89372, 33.75945], [-116.89348, 33.75971], [-116.89336, 33.7599], [-116.89326, 33.7601], [-116.89319, 33.76013], [-116.89307, 33.7601], [-116.89305, 33.75874], [-116.8932, 33.75873], [-116.89319, 33.75788], [-116.89322, 33.75789], [-116.89332, 33.75814], [-116.89345, 33.75837], [-116.89366, 33.75869], [-116.89321, 33.75894], [-116.89321, 33.75895], [-116.89355, 33.75931], [-116.89398, 33.75906], [-116.89403, 33.75911]]]} | Open Access 1 | 48275 | Valle Vista | 32830 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 2.045 | Valle Vista | 0 | None 357 | ||
4182 | 4182 | 4181 | {"type": "Polygon", "coordinates": [[[-122.33713, 37.91103], [-122.3302, 37.90951], [-122.33019, 37.90937], [-122.32739, 37.90874], [-122.32609, 37.90838], [-122.32557, 37.9082], [-122.32557, 37.90811], [-122.32475, 37.9078], [-122.32454, 37.90774], [-122.32432, 37.90764], [-122.32317, 37.90701], [-122.32242, 37.90652], [-122.32205, 37.90627], [-122.32145, 37.90584], [-122.32094, 37.9054], [-122.32039, 37.90483], [-122.32022, 37.90468], [-122.31956, 37.90396], [-122.3163, 37.8999], [-122.31655, 37.89982], [-122.31658, 37.89984], [-122.31926, 37.90317], [-122.32457, 37.90051], [-122.32268, 37.89818], [-122.32347, 37.89776], [-122.32425, 37.89827], [-122.32452, 37.89851], [-122.32468, 37.89872], [-122.32478, 37.89891], [-122.32485, 37.89914], [-122.32487, 37.89938], [-122.32522, 37.89938], [-122.32522, 37.9011], [-122.32128, 37.90308], [-122.31988, 37.9038], [-122.3203, 37.90434], [-122.32088, 37.90498], [-122.32125, 37.90533], [-122.32159, 37.90561], [-122.32212, 37.90606], [-122.32235, 37.90632], [-122.3228, 37.9066], [-122.32313, 37.90684], [-122.3235, 37.90705], [-122.32458, 37.9076], [-122.32579, 37.90809], [-122.32594, 37.90814], [-122.3261, 37.90816], [-122.32745, 37.90855], [-122.3325, 37.90968], [-122.33251, 37.90967], [-122.33251, 37.90946], [-122.33711, 37.91047], [-122.33713, 37.91103]]]} | Open Access 1 | 3447 | Point Isabel | 23851 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 37.437 | Point Isabel | None 363 | |||
4304 | 4304 | 4303 | {"type": "Polygon", "coordinates": [[[-118.43677, 35.11513], [-118.43674, 35.11696], [-118.4324, 35.11697], [-118.43243, 35.11515], [-118.43677, 35.11513]]]} | Open Access 1 | 45342 | Morris Park (Proposed) | 22495 | 2164 | Tehachapi Valley Recreation and Parks District 743 | Special District 4 | Recreation/Parks District 4 | http://www.tvrpd.org/ | Special District 4 | 2164 | Tehachapi Valley Recreation and Parks District 723 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 19.824 | Morris Park (Proposed) | None 379 | |||
4374 | 4374 | 4373 | {"type": "Polygon", "coordinates": [[[-121.44728, 38.68325], [-121.44665, 38.68325], [-121.44664, 38.68384], [-121.44643, 38.68383], [-121.44643, 38.68325], [-121.444, 38.68323], [-121.44594, 38.6815], [-121.44594, 38.68149], [-121.44573, 38.68135], [-121.44599, 38.68134], [-121.44618, 38.68069], [-121.44629, 38.68061], [-121.44728, 38.68062], [-121.44728, 38.68325]]]} | Open Access 1 | 48538 | Central Park & Horse Arena | 33257 | 2187 | Solano Tri-City and County Cooperative Planning Group 74 | Special District 4 | Open Space District 6 | Special District 4 | 2190 | Rio Linda Elverta Recreation and Park District 539 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 12.526 | Central Park & Horse Arena | None 388 | ||||
5344 | 5344 | 5343 | {"type": "Polygon", "coordinates": [[[-119.0427, 34.22709], [-119.04183, 34.2271], [-119.04183, 34.22684], [-119.04176, 34.22677], [-119.04181, 34.22671], [-119.04183, 34.22664], [-119.04181, 34.22643], [-119.04185, 34.22641], [-119.04264, 34.2264], [-119.04267, 34.22641], [-119.04269, 34.22646], [-119.0427, 34.22709]]]} | Open Access 1 | 17313 | Laurelwood Park - PVRPD | 21108 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 1.519 | Laurelwood Park - PVRPD | None 435 | |||
5595 | 5595 | 5594 | {"type": "Polygon", "coordinates": [[[-122.67989, 38.01119], [-122.67917, 38.01172], [-122.67866, 38.01125], [-122.67834, 38.0111], [-122.67789, 38.01155], [-122.67781, 38.01151], [-122.67759, 38.0116], [-122.6775, 38.01158], [-122.67804, 38.01093], [-122.67802, 38.01091], [-122.67746, 38.01158], [-122.67721, 38.01154], [-122.67715, 38.01146], [-122.67712, 38.01129], [-122.67698, 38.01116], [-122.67682, 38.01108], [-122.67658, 38.01112], [-122.67633, 38.01098], [-122.67708, 38.01016], [-122.67707, 38.01013], [-122.67689, 38.01032], [-122.67671, 38.01022], [-122.6766, 38.01031], [-122.67646, 38.01025], [-122.67635, 38.01038], [-122.67667, 38.01056], [-122.6763, 38.01097], [-122.67603, 38.01083], [-122.67581, 38.01075], [-122.6755, 38.01072], [-122.67509, 38.01072], [-122.67479, 38.01068], [-122.67475, 38.01057], [-122.67477, 38.0104], [-122.67475, 38.01007], [-122.67474, 38.00882], [-122.67655, 38.00789], [-122.67989, 38.01119]]]} | Open Access 1 | 35115 | San Geronimo Ridge Acq | 24901 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | Marin 23 | 25.019 | San Geronimo Ridge Acq | None 450 | |||
5629 | 5629 | 5628 | {"type": "Polygon", "coordinates": [[[-122.55288, 38.33176], [-122.55063, 38.33254], [-122.55084, 38.33184], [-122.55027, 38.33187], [-122.55008, 38.33138], [-122.54925, 38.33155], [-122.5489, 38.33136], [-122.54879, 38.33111], [-122.54884, 38.33094], [-122.54859, 38.33071], [-122.54827, 38.33014], [-122.54814, 38.33002], [-122.54764, 38.32992], [-122.54754, 38.32984], [-122.54752, 38.32961], [-122.5471, 38.32881], [-122.54726, 38.32864], [-122.54727, 38.32849], [-122.54726, 38.32823], [-122.54715, 38.32801], [-122.547, 38.32781], [-122.54682, 38.32763], [-122.54633, 38.32729], [-122.54728, 38.32696], [-122.54744, 38.32716], [-122.54838, 38.32888], [-122.55288, 38.33176]]]} | Open Access 1 | 29798 | McCrea Trail Parcel | 33322 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 22.037 | McCrea Trail Parcel | 2010 | None 454 |
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]);