superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
78 rows where ACCESS_TYP = 2 and MNG_AG_LEV = 3 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, AGNCY_WEB, YR_EST
MNG_AGENCY 22
- Sacramento, County of 21
- Los Angeles, County of 14
- San Francisco - Public Utilities Commission, City and County of 8
- Los Angeles - Department of Parks and Recreation, County of 7
- Orange, County of 5
- San Diego, County of 3
- Santa Cruz, County of 2
- San Luis Obispo, County of 2
- Ventura, County of 2
- Santa Clara County Parks and Recreation Dept., County of 2
- Monterey, County of 1
- Tulare, County of 1
- Marin County Parks Department, County of 1
- Riverside, County of 1
- Sonoma County Regional Parks Dept., County of 1
- Placer, County of 1
- Fresno, County of 1
- Kern, County of 1
- Contra Costa County Public Works Dept., County of 1
- Humboldt, County of 1
- Shasta, County of 1
- Orange County Department of Education, County of 1
MNG_AG_TYP 3
ACCESS_TYP 1
- Restricted Access · 78 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14334 | 14334 | 14333 | {"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]} | Restricted Access 2 | Unnamed site - Humboldt, County of | 29996 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 19.487 | |||
14179 | 14179 | 14178 | {"type": "Polygon", "coordinates": [[[-122.93948, 38.35579], [-122.93861, 38.35592], [-122.93857, 38.35592], [-122.93856, 38.35587], [-122.93847, 38.35577], [-122.93853, 38.35573], [-122.93849, 38.35551], [-122.93858, 38.35544], [-122.93913, 38.35514], [-122.93922, 38.35551], [-122.93948, 38.35579]]]} | Restricted Access 2 | Watson School/ Wayside Park | 31655 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 1.063 | Watson School/ Wayside Park | ||
5150 | 5150 | 5149 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | http://sfwater.org/ | County 3 | 0.079 | Hillcrest And Ocean View Lots | ||
10062 | 10062 | 10061 | {"type": "Polygon", "coordinates": [[[-122.45243, 37.75546], [-122.45204, 37.75657], [-122.45019, 37.75667], [-122.44973, 37.75638], [-122.44965, 37.75628], [-122.4496, 37.75614], [-122.4496, 37.75594], [-122.4499, 37.75586], [-122.45005, 37.75579], [-122.45019, 37.75571], [-122.45027, 37.75565], [-122.45079, 37.75511], [-122.45094, 37.755], [-122.45106, 37.75493], [-122.45121, 37.75487], [-122.45136, 37.75483], [-122.45148, 37.75484], [-122.45154, 37.75481], [-122.45158, 37.75476], [-122.45164, 37.75442], [-122.45206, 37.75443], [-122.45208, 37.75517], [-122.45243, 37.75546]]]} | Restricted Access 2 | Summit Reservoir Water Facilities | 25969 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | http://sfwater.org/ | County 3 | 9.064 | Summit Reservoir Water Facilities | ||
6528 | 6528 | 6527 | {"type": "Polygon", "coordinates": [[[-122.40231, 40.58043], [-122.40172, 40.58057], [-122.40131, 40.57969], [-122.40194, 40.57953], [-122.40231, 40.58043]]]} | Restricted Access 2 | Magnolia Park | 21676 | 343 | Shasta, County of 700 | County 3 | County Agency 3 | http://www.co.shasta.ca.us/index.aspx | County 3 | 1.398 | Magnolia Park | ||
9227 | 9227 | 9226 | {"type": "Polygon", "coordinates": [[[-122.1385, 37.48163], [-122.13828, 37.48212], [-122.13754, 37.48296], [-122.13725, 37.48334], [-122.13641, 37.48427], [-122.13358, 37.48639], [-122.13244, 37.48637], [-122.12668, 37.4898], [-122.12636, 37.48978], [-122.12589, 37.4898], [-122.1259, 37.48918], [-122.12601, 37.48639], [-122.12719, 37.48574], [-122.12827, 37.48519], [-122.13007, 37.48435], [-122.13119, 37.48389], [-122.13088, 37.48337], [-122.13108, 37.4829], [-122.13274, 37.48232], [-122.13331, 37.48261], [-122.1338, 37.48271], [-122.13422, 37.48259], [-122.13498, 37.48243], [-122.13544, 37.48231], [-122.13606, 37.48227], [-122.13669, 37.48211], [-122.13741, 37.48183], [-122.1385, 37.48163]]]} | Restricted Access 2 | San Mateo Properties | 24954 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | http://sfwater.org/ | County 3 | 94.819 | San Mateo Properties | 1930 | |
8271 | 8271 | 8270 | {"type": "Polygon", "coordinates": [[[-122.09793, 38.0339], [-122.09769, 38.03914], [-122.09158, 38.04066], [-122.09096, 38.03986], [-122.08905, 38.03774], [-122.08812, 38.03657], [-122.08732, 38.03561], [-122.08642, 38.03459], [-122.08564, 38.03378], [-122.08448, 38.0328], [-122.08348, 38.03204], [-122.08255, 38.03143], [-122.09011, 38.02928], [-122.09118, 38.03176], [-122.09429, 38.0309], [-122.09428, 38.03188], [-122.09338, 38.03401], [-122.09417, 38.03471], [-122.09447, 38.03495], [-122.09577, 38.03467], [-122.09706, 38.03377], [-122.09793, 38.0339]]]} | Restricted Access 2 | Point Edith Wetlands | 23847 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 211.393 | Point Edith Wetlands | 2001 | |
6994 | 6994 | 6993 | {"type": "Polygon", "coordinates": [[[-121.86466, 37.49523], [-121.86362, 37.49944], [-121.86365, 37.50092], [-121.8629, 37.50172], [-121.86226, 37.50343], [-121.86265, 37.50433], [-121.86196, 37.50649], [-121.85999, 37.50648], [-121.8428, 37.5063], [-121.84273, 37.49844], [-121.84258, 37.49107], [-121.84714, 37.49118], [-121.84729, 37.48771], [-121.85157, 37.48778], [-121.85164, 37.48476], [-121.85601, 37.48478], [-121.85594, 37.48769], [-121.85582, 37.49136], [-121.85565, 37.49892], [-121.86004, 37.49904], [-121.8601, 37.49519], [-121.86466, 37.49523]]]} | Restricted Access 2 | SFPUC Alameda Watershed | 33672 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | http://sfwater.org/ | County 3 | 750.846 | SFPUC Alameda Watershed | ||
11603 | 11603 | 11602 | {"type": "Polygon", "coordinates": [[[-121.8062, 36.9086], [-121.80603, 36.90929], [-121.80576, 36.90997], [-121.80555, 36.91066], [-121.80541, 36.91092], [-121.80506, 36.91124], [-121.8049, 36.9115], [-121.80481, 36.91148], [-121.80472, 36.91147], [-121.80272, 36.91153], [-121.80291, 36.90858], [-121.8062, 36.9086]]]} | Restricted Access 2 | Harkins Slough | 28149 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 20.479 | Harkins Slough | ||
2885 | 2885 | 2884 | {"type": "Polygon", "coordinates": [[[-121.72098, 37.12625], [-121.72074, 37.12705], [-121.71994, 37.12674], [-121.71867, 37.12586], [-121.71666, 37.12538], [-121.71328, 37.12336], [-121.71202, 37.12322], [-121.71031, 37.1239], [-121.70847, 37.12388], [-121.70782, 37.12443], [-121.70714, 37.12548], [-121.70569, 37.12583], [-121.70477, 37.12519], [-121.70452, 37.12419], [-121.70372, 37.12296], [-121.70352, 37.123], [-121.70303, 37.12251], [-121.70261, 37.12126], [-121.70278, 37.12087], [-121.70219, 37.12033], [-121.70201, 37.11947], [-121.70031, 37.11878], [-121.69953, 37.11889], [-121.6985, 37.11855], [-121.69645, 37.11872], [-121.69476, 37.11834], [-121.69386, 37.11816], [-121.69338, 37.11708], [-121.69242, 37.11639], [-121.69228, 37.11591], [-121.69232, 37.1159], [-121.69247, 37.1153], [-121.6915, 37.11446], [-121.69207, 37.11431], [-121.69281, 37.11473], [-121.69669, 37.1143], [-121.69704, 37.11364], [-121.69832, 37.11545], [-121.6989, 37.1157], [-121.69952, 37.1153], [-121.70012, 37.11588], [-121.70096, 37.11611], [-121.7014, 37.11606], [-121.70166, 37.11624], [-121.70314, 37.11652], [-121.70373, 37.11585], [-121.70377, 37.11676], [-121.70459, 37.11703], [-121.70403, 37.11737], [-121.70452, 37.11779], [-121.70579, 37.11958], [-121.70672, 37.11956], [-121.70837, 37.11872], [-121.70693, 37.12048], [-121.70635, 37.12078], [-121.70651, 37.12125], [-121.70735, 37.12169], [-121.70879, 37.12155], [-121.7095, 37.12176], [-121.70981, 37.12151], [-121.7103, 37.12152], [-121.71087, 37.12123], [-121.71192, 37.12133], [-121.71272, 37.12116], [-121.71281, 37.12098], [-121.71324, 37.12081], [-121.71398, 37.12043], [-121.71385, 37.12116], [-121.71444, 37.12122], [-121.7151, 37.1208], [-121.71502, 37.12103], [-121.71537, 37.12149], [-121.71565, 37.12161], [-121.71648, 37.12215], [-121.71703, 37.12212], [-121.71689, 37.12234], [-121.7173, 37.12305], [-121.71769, 37.12316], [-121.71681, 37.12434], [-121.71844, 37.12451], [-121.71898, 37.12449], [-121.71952, 37.12559], [-121.71994, 37.126], [-121.72057, 37.12625], [-121.72098, 37.12625]]]} | Restricted Access 2 | Chesbro | 17176 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 232.334 | Chesbro | ||
10592 | 10592 | 10591 | {"type": "Polygon", "coordinates": [[[-121.70684, 37.07901], [-121.70529, 37.07998], [-121.70532, 37.08003], [-121.7054, 37.08006], [-121.69439, 37.08908], [-121.69296, 37.08754], [-121.69287, 37.08753], [-121.69284, 37.08746], [-121.69272, 37.08753], [-121.6919, 37.0865], [-121.69109, 37.08617], [-121.69136, 37.08545], [-121.69189, 37.08417], [-121.69202, 37.08391], [-121.69145, 37.08331], [-121.69157, 37.08238], [-121.6916, 37.08225], [-121.6915, 37.08191], [-121.69166, 37.08042], [-121.69062, 37.07976], [-121.6885, 37.07927], [-121.68643, 37.07936], [-121.68564, 37.07935], [-121.6941, 37.07268], [-121.6941, 37.07264], [-121.6942, 37.07255], [-121.69329, 37.0711], [-121.693, 37.07097], [-121.69298, 37.07094], [-121.69291, 37.07092], [-121.68894, 37.06868], [-121.68749, 37.06792], [-121.68852, 37.0659], [-121.68819, 37.06578], [-121.68803, 37.06488], [-121.68984, 37.0656], [-121.69106, 37.06443], [-121.68984, 37.06384], [-121.69002, 37.06361], [-121.69153, 37.06397], [-121.69758, 37.06659], [-121.69778, 37.06657], [-121.69791, 37.06653], [-121.69803, 37.06656], [-121.69863, 37.06653], [-121.69934, 37.06671], [-121.70001, 37.06711], [-121.70149, 37.06837], [-121.70144, 37.06848], [-121.70136, 37.06889], [-121.70085, 37.06928], [-121.70086, 37.06935], [-121.70133, 37.06971], [-121.70148, 37.07008], [-121.70284, 37.06995], [-121.70251, 37.07023], [-121.70227, 37.0718], [-121.70207, 37.07323], [-121.70256, 37.07405], [-121.70379, 37.07478], [-121.70383, 37.07478], [-121.70579, 37.07602], [-121.70684, 37.07901]]]} | Restricted Access 2 | Uvas Reservoir | 26750 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 637.913 | Uvas Reservoir | ||
4282 | 4282 | 4281 | {"type": "Polygon", "coordinates": [[[-121.62329, 36.69175], [-121.62139, 36.69475], [-121.62267, 36.69557], [-121.62305, 36.69583], [-121.62239, 36.69593], [-121.62224, 36.69599], [-121.62208, 36.69612], [-121.62156, 36.69684], [-121.62114, 36.69815], [-121.61922, 36.69881], [-121.61535, 36.69667], [-121.61886, 36.69402], [-121.61838, 36.69346], [-121.61979, 36.69213], [-121.62135, 36.69028], [-121.623, 36.69156], [-121.62329, 36.69175]]]} | Restricted Access 2 | Twin Creeks Golf Course | 32997 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 76.301 | Twin Creeks GC | ||
9987 | 9987 | 9986 | {"type": "Polygon", "coordinates": [[[-121.48774, 38.4088], [-121.48772, 38.40888], [-121.48765, 38.40901], [-121.48756, 38.4091], [-121.48745, 38.40917], [-121.48727, 38.40925], [-121.48678, 38.40939], [-121.48637, 38.40956], [-121.48599, 38.40978], [-121.48562, 38.41006], [-121.48534, 38.41036], [-121.48511, 38.41068], [-121.48492, 38.41107], [-121.48483, 38.4114], [-121.48435, 38.4089], [-121.48598, 38.40887], [-121.48656, 38.40882], [-121.48774, 38.4088]]]} | Restricted Access 2 | Stone Lakes | 25873 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 7.901 | Stone Lakes | ||
5709 | 5709 | 5708 | {"type": "Polygon", "coordinates": [[[-121.45132, 38.38301], [-121.45064, 38.38333], [-121.45063, 38.38332], [-121.45032, 38.38293], [-121.44997, 38.38258], [-121.44967, 38.38233], [-121.44924, 38.38204], [-121.44983, 38.3814], [-121.45112, 38.3813], [-121.45132, 38.38301]]]} | Restricted Access 2 | Kenneth Way Drainage | 20610 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 6.272 | Kenneth Way Drainage | ||
5232 | 5232 | 5231 | {"type": "Polygon", "coordinates": [[[-121.45044, 38.37471], [-121.44978, 38.3747], [-121.44966, 38.37342], [-121.45028, 38.37338], [-121.45044, 38.37471]]]} | Restricted Access 2 | Hood-Franklin Drainage | 20071 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2.024 | Hood-Franklin Drainage | ||
5882 | 5882 | 5881 | {"type": "Polygon", "coordinates": [[[-121.45011, 38.40646], [-121.45004, 38.40688], [-121.4499, 38.40688], [-121.44976, 38.40685], [-121.44963, 38.40679], [-121.44953, 38.40671], [-121.44945, 38.40661], [-121.44942, 38.40654], [-121.44941, 38.40643], [-121.44943, 38.40612], [-121.44612, 38.40611], [-121.44611, 38.40534], [-121.44083, 38.40532], [-121.44083, 38.405], [-121.44983, 38.40499], [-121.44995, 38.40507], [-121.45002, 38.40514], [-121.4501, 38.40525], [-121.45014, 38.40538], [-121.45014, 38.40551], [-121.45, 38.40639], [-121.45004, 38.40645], [-121.45011, 38.40646]]]} | Restricted Access 2 | Laguna Lake Drainage | 20858 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 15.925 | Laguna Lake Drainage | ||
6427 | 6427 | 6426 | {"type": "Polygon", "coordinates": [[[-121.44882, 38.38398], [-121.44574, 38.38469], [-121.44561, 38.38473], [-121.44549, 38.38479], [-121.44535, 38.38492], [-121.44535, 38.38427], [-121.44879, 38.38348], [-121.44879, 38.38397], [-121.44882, 38.38398]]]} | Restricted Access 2 | Lotus Pond Drainage | 21545 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 4.29 | Lotus Pond Drainage | ||
1651 | 1651 | 1650 | {"type": "Polygon", "coordinates": [[[-121.39798, 38.71663], [-121.39679, 38.71662], [-121.39676, 38.71656], [-121.39668, 38.71625], [-121.39666, 38.71594], [-121.39669, 38.71563], [-121.39678, 38.71532], [-121.39678, 38.71519], [-121.39741, 38.71519], [-121.39736, 38.71531], [-121.39736, 38.71542], [-121.39743, 38.71553], [-121.39768, 38.71574], [-121.39785, 38.71583], [-121.39795, 38.71602], [-121.39798, 38.71663]]]} | Restricted Access 2 | Atreule Et Al Community Plan | 15676 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 3.539 | Atreule Et Al Community Plan | ||
14273 | 14273 | 14272 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45596], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 1.452 | |||
3401 | 3401 | 3400 | {"type": "Polygon", "coordinates": [[[-121.35327, 38.45636], [-121.35322, 38.45992], [-121.35131, 38.45992], [-121.3513, 38.45977], [-121.35097, 38.45977], [-121.35102, 38.45972], [-121.35104, 38.45966], [-121.35101, 38.45955], [-121.35101, 38.45909], [-121.35105, 38.45881], [-121.35101, 38.45853], [-121.35101, 38.45828], [-121.35103, 38.45815], [-121.35115, 38.45772], [-121.35118, 38.45754], [-121.35122, 38.45751], [-121.35151, 38.45747], [-121.35171, 38.4574], [-121.3519, 38.45729], [-121.35207, 38.45714], [-121.35219, 38.45698], [-121.35227, 38.45677], [-121.35228, 38.45663], [-121.35226, 38.45636], [-121.35327, 38.45636]]]} | Restricted Access 2 | D R Horton Inc Sacramento | 17889 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 15.775 | D R Horton Inc Sacramento |
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]);