units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
659 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AG_TYP = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 659 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11403 | 11403 | 11402 | {"type": "Polygon", "coordinates": [[[-122.26076, 37.8998], [-122.26076, 37.8998], [-122.2605, 37.89989], [-122.26062, 37.89973], [-122.26076, 37.8998]]]} | Open Access 1 | 23017 | Tilden Regional Park | 3324 | 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 | http://www.ebparks.org/parks/tilden | Alameda 17 | 0.038 | Tilden RP | 1936 | Local Park 2 | 4 |
6994 | 6994 | 6993 | {"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 | 47558 | Herschel Young Park | 31275 | 1015 | Auburn, City of 453 | City 2 | City Agency 2 | http://www.auburn.ca.gov/ | City 2 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | Placer 35 | 0.061 | Herschel Young Park | 0 | Local Park 2 | 4 | |
12628 | 12628 | 12627 | {"type": "Polygon", "coordinates": [[[-117.35578, 34.42283], [-117.35576, 34.4229], [-117.35578, 34.42299], [-117.35577, 34.42306], [-117.35568, 34.42309], [-117.35563, 34.42305], [-117.35562, 34.42299], [-117.35559, 34.42289], [-117.35562, 34.42278], [-117.35572, 34.42277], [-117.35578, 34.42283]]]} | Open Access 1 | 29427 | Sapphire Park | 25154 | 2227 | Hesperia Recreation and Park District 609 | Special District 4 | Recreation/Parks District 4 | http://www.hesperiaparks.com/ | Special District 4 | 2227 | Hesperia Recreation and Park District 598 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 0.12 | Sapphire Park | 0 | Local Park 2 | 4 | |
13189 | 13189 | 13188 | {"type": "Polygon", "coordinates": [[[-122.1211, 37.12664], [-122.12089, 37.12679], [-122.12081, 37.12657], [-122.12102, 37.12645], [-122.1211, 37.12664]]]} | Open Access 1 | 35180 | Junction Park | 28529 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/#!parks/ccjp | Santa Cruz 5 | 0.129 | Junction Park | 0 | Local Park 2 | 4 |
8543 | 8543 | 8542 | {"type": "MultiPolygon", "coordinates": [[[[-119.09761, 35.40048], [-119.09761, 35.40048], [-119.0976, 35.40055], [-119.09755, 35.40051], [-119.09761, 35.40048]]], [[[-119.09798, 35.40118], [-119.09789, 35.40109], [-119.09783, 35.40095], [-119.0979, 35.401], [-119.09794, 35.40106], [-119.09798, 35.40118]]], [[[-119.09823, 35.4015], [-119.0981, 35.40149], [-119.09804, 35.40138], [-119.09808, 35.40132], [-119.09823, 35.4015]]], [[[-119.09895, 35.39986], [-119.09895, 35.39986], [-119.09864, 35.39995], [-119.09889, 35.3998], [-119.09895, 35.39986]]], [[[-119.09949, 35.40115], [-119.09931, 35.40122], [-119.09921, 35.40121], [-119.09937, 35.40109], [-119.09947, 35.40107], [-119.09949, 35.40115]]]]} | Open Access 1 | 13462 | River Lakes Ranch Community Park | 24410 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 0.141 | River Lakes Ranch Community Park | 0 | Local Park 2 | 4 | |
14442 | 14442 | 14441 | {"type": "Polygon", "coordinates": [[[-117.09337, 33.59269], [-117.09337, 33.59287], [-117.09303, 33.59287], [-117.09303, 33.59269], [-117.09337, 33.59269]]]} | Open Access 1 | 48260 | Northfield Park | 32814 | 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 | https://www.gorecreation.org/northfield-park | Riverside 10 | 0.152 | Northfield Park | 0 | Local Park 2 | 4 |
15006 | 15006 | 15005 | {"type": "Polygon", "coordinates": [[[-122.05718, 37.94618], [-122.05718, 37.94618], [-122.057, 37.94673], [-122.05698, 37.94654], [-122.05696, 37.94645], [-122.05688, 37.94625], [-122.05716, 37.94615], [-122.05718, 37.94618]]]} | Open Access 1 | 45656 | Sherman Acres Neighborhood Park | 28472 | 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 | Contra Costa 12 | 0.171 | Sherman Acres Neighborhood Park | 0 | Local Park 2 | 4 | |
5258 | 5258 | 5257 | {"type": "Polygon", "coordinates": [[[-117.1093, 33.59153], [-117.1089, 33.59184], [-117.10882, 33.59184], [-117.10882, 33.59154], [-117.10915, 33.59157], [-117.10922, 33.59155], [-117.10929, 33.59152], [-117.1093, 33.59153]]]} | Open Access 1 | 48383 | Pompei Pocket Park | 32947 | 6123 | Brindisi Owners Association 763 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/pompei-pocket-park | Riverside 10 | 0.197 | Pompei PP | 0 | Local Park 2 | 4 | |
6465 | 6465 | 6464 | {"type": "Polygon", "coordinates": [[[-117.10035, 33.59259], [-117.10035, 33.59281], [-117.09998, 33.59281], [-117.09998, 33.59259], [-117.10035, 33.59259]]]} | Open Access 1 | 48392 | Watermill Park | 32956 | 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 | https://www.gorecreation.org/watermill-park | Riverside 10 | 0.202 | Watermill Park | 0 | Local Park 2 | 4 |
6391 | 6391 | 6390 | {"type": "Polygon", "coordinates": [[[-117.10569, 33.59244], [-117.10566, 33.59249], [-117.10549, 33.59255], [-117.10527, 33.59259], [-117.10527, 33.59237], [-117.10566, 33.59232], [-117.10569, 33.59244]]]} | Open Access 1 | 48388 | Sicily Pocket Park | 32952 | 6123 | Brindisi Owners Association 763 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/sicily-pocket-park | Riverside 10 | 0.212 | Sicily PP | 0 | Local Park 2 | 4 | |
3157 | 3157 | 3156 | {"type": "Polygon", "coordinates": [[[-121.28286, 38.5753], [-121.28275, 38.57551], [-121.28263, 38.57548], [-121.2824, 38.57529], [-121.28262, 38.57514], [-121.28271, 38.57522], [-121.28286, 38.5753]]]} | Open Access 1 | 25946 | Waterbrook Park | 27299 | 2193 | Cordova Recreation and Park District 307 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 0.214 | Waterbrook Park | 0 | Local Park 2 | 4 | |
4281 | 4281 | 4280 | {"type": "Polygon", "coordinates": [[[-120.23679, 37.96123], [-120.23635, 37.96123], [-120.23635, 37.96102], [-120.23679, 37.96102], [-120.23679, 37.96123]]]} | Open Access 1 | 48059 | Reid Park | 32551 | 2169 | Tuolumne Park and Recreation District 741 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | https://www.tuolumnerecreation.com/TPRD_facilities.html | Tuolumne 21 | 0.215 | Reid Park | 1997 | Local Park 2 | 4 |
7967 | 7967 | 7966 | {"type": "Polygon", "coordinates": [[[-122.10386, 37.66497], [-122.10343, 37.66497], [-122.10343, 37.66475], [-122.10385, 37.66475], [-122.10386, 37.66497]]]} | Open Access 1 | 15632 | La Placita Mini Park | 20788 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.229 | La Placita MP | 0 | Local Park 2 | 4 | |
3818 | 3818 | 3817 | {"type": "Polygon", "coordinates": [[[-122.13417, 37.15393], [-122.13375, 37.15388], [-122.13379, 37.15364], [-122.13411, 37.15359], [-122.13417, 37.15393]]]} | Open Access 1 | 35183 | Garrahan Park | 28532 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/#!parks/ccjp | Santa Cruz 5 | 0.257 | Garrahan Park | 0 | Local Park 2 | 4 |
13188 | 13188 | 13187 | {"type": "Polygon", "coordinates": [[[-122.11963, 37.1255], [-122.11902, 37.12573], [-122.11902, 37.12573], [-122.11903, 37.12536], [-122.11963, 37.1255]]]} | Open Access 1 | 35178 | Barbara Day Park | 28528 | 2009 | Boulder Creek Recreation and Park District 688 | Special District 4 | Recreation/Parks District 4 | http://www.bcrpd.org/ | Special District 4 | 2009 | Boulder Creek Recreation and Park District 679 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.272 | Barbara Day Park | 0 | Local Park 2 | 4 | |
14495 | 14495 | 14494 | {"type": "Polygon", "coordinates": [[[-120.20197, 39.32434], [-120.20196, 39.32475], [-120.20172, 39.32478], [-120.20165, 39.32437], [-120.20197, 39.32434]]]} | Open Access 1 | 45000 | Bill Rose Park | 16111 | 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.274 | Bill Rose Park | 0 | Local Park 2 | 4 | |
4162 | 4162 | 4161 | {"type": "Polygon", "coordinates": [[[-117.14454, 33.70443], [-117.14404, 33.70443], [-117.14404, 33.70421], [-117.14454, 33.70421], [-117.14454, 33.70443]]]} | Open Access 1 | 48377 | Mahogany Creek Pocket Park | 32944 | 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 | 0.282 | Mahogany Creek PP | 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 | |
2018 | 2018 | 2017 | {"type": "Polygon", "coordinates": [[[-119.85998, 34.40901], [-119.85998, 34.40971], [-119.85981, 34.40971], [-119.85981, 34.409], [-119.85998, 34.40901]]]} | Open Access 1 | 16986 | Isla Vista County Park | 20279 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.295 | Isla Vista County Park | 0 | Local Park 2 | 4 | |
4163 | 4163 | 4162 | {"type": "Polygon", "coordinates": [[[-117.13273, 33.61299], [-117.13267, 33.61334], [-117.13238, 33.61333], [-117.13235, 33.61297], [-117.13273, 33.61299]]]} | Open Access 1 | 48381 | Mahogany Meadows Pocket Park | 32945 | 6124 | Mahogany Hills Home Owner Association 727 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/mahogany-meadows-pocket-park | Riverside 10 | 0.3 | Mahogany Meadows PP | 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]);