CPAD_2020a_SuperUnits

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1,091 rows where MNG_AG_TYP = 4

View and edit SQL

Suggested facets: ACCESS_TYP

id ▼ 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 geometry
16 Open Access 1 Skyline Wilderness Park http://www.skylinepark.org/ 835 2268 Napa County Regional Park and Open Space District 108 Special District 4 Recreation/Parks District 4 http://napaoutdoors.org/ Special District 4 1021.301 Skyline Wilderness Park 1983 <Binary data: 980 bytes>
36 Open Access 1 Frascati Trail   31776 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 5.929 Frascati Trail   <Binary data: 794 bytes>
53 Open Access 1 Frog Pond Park   31771 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 0.44 Frog Pond Park   <Binary data: 228 bytes>
55 Open Access 1 Harter Park   31774 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 2.954 Harter Park   <Binary data: 484 bytes>
56 Open Access 1 Colinita Trail   31775 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 3.142 Colinita Trail   <Binary data: 372 bytes>
60 Open Access 1 Sienna Loop Trail   31777 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 9.939 Sienna Loop Trail   <Binary data: 922 bytes>
72 Open Access 1 Miraleste Median   31778 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 3.263 Miraleste Median   <Binary data: 1089 bytes>
73 Open Access 1 Miltenberger Park   31779 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 1.103 Miltenberger Park   <Binary data: 212 bytes>
74 Open Access 1 Miraleste Park   31780 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 0.395 Miraleste Park   <Binary data: 196 bytes>
75 Open Access 1 Canada Park   31781 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 13.194 Canada Park   <Binary data: 868 bytes>
76 Open Access 1 Lorraine Trail   31782 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 2.558 Lorraine Trail   <Binary data: 244 bytes>
79 No Public Access 3 Croy Redwoods   31791 2142 Santa Clara Valley Open Space Authority 468 Special District 4 Recreation/Parks District 4 http://www.openspaceauthority.org/ Special District 4 115.547 Croy Redwoods 2018 <Binary data: 516 bytes>
83 No Public Access 3 Wendle Property   31796 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 50.237 Wendle Property 2018 <Binary data: 260 bytes>
108 Open Access 1 Hatton Canyon Open Space   19738 2085 Monterey Peninsula Regional Park District 46 Special District 4 Recreation/Parks District 4 http://www.mprpd.org/ Special District 4 34.94 Hatton Canyon OS   <Binary data: 484 bytes>
116 No Public Access 3 Garaventa Wetlands Preserve https://www.larpd.org/garaventa-wetlands 31818 2062 Livermore Area Recreation and Park District 388 Special District 4 Recreation/Parks District 4 http://www.larpd.dst.ca.us/ Special District 4 21.408 Garaventa Wetlands Preserve   <Binary data: 340 bytes>
117 Open Access 1 Altamont Creek Park   31819 2062 Livermore Area Recreation and Park District 388 Special District 4 Recreation/Parks District 4 http://www.larpd.dst.ca.us/ Special District 4 4.385 Altamont Creek Park   <Binary data: 372 bytes>
153 Open Access 1 Brushy Peak Regional Preserve http://www.larpd.org/open_space/brushy_peak.html 5287 2062 Livermore Area Recreation and Park District 388 Special District 4 Recreation/Parks District 4 http://www.larpd.dst.ca.us/ Special District 4 1584.798 Brushy Peak RPr 2005 <Binary data: 970 bytes>
163 Open Access 1 Lake Del Valle SRA http://www.parks.ca.gov/?page_id=537 1594 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 0.204 Lake Del Valle SRA 2000 <Binary data: 164 bytes>
317 Restricted Access 2 Brenkwitz School Park   31949 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 8.676 Brenkwitz School Park   <Binary data: 196 bytes>
319 Restricted Access 2 Colonial Acres School Park   31951 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 11.664 Colonial Acres School Park   <Binary data: 196 bytes>

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [CPAD_2020a_SuperUnits] (
   [id] INTEGER PRIMARY KEY,
   [ACCESS_TYP] INTEGER,
   [PARK_NAME] TEXT,
   [PARK_URL] TEXT,
   [SUID_NMA] INTEGER,
   [MNG_AG_ID] INTEGER,
   [MNG_AGENCY] INTEGER,
   [MNG_AG_LEV] INTEGER,
   [MNG_AG_TYP] INTEGER,
   [AGNCY_WEB] TEXT,
   [LAYER] INTEGER,
   [ACRES] FLOAT,
   [LABEL_NAME] TEXT,
   [YR_EST] INTEGER
, "geometry" GEOMETRY,
   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_CPAD_2020a_SuperUnits_LAYER]
                ON [CPAD_2020a_SuperUnits] ([LAYER]);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_MNG_AG_TYP]
                ON [CPAD_2020a_SuperUnits] ([MNG_AG_TYP]);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_MNG_AG_LEV]
                ON [CPAD_2020a_SuperUnits] ([MNG_AG_LEV]);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_MNG_AGENCY]
                ON [CPAD_2020a_SuperUnits] ([MNG_AGENCY]);
CREATE INDEX [idx_CPAD_2020a_SuperUnits_ACCESS_TYP]
                ON [CPAD_2020a_SuperUnits] ([ACCESS_TYP]);
Powered by Datasette · Query took 229.44ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette