CPAD_2020a_Units

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

1,162 rows where MNG_AG_TYP = 4

View and edit SQL

Suggested facets: ACCESS_TYP, AGNCY_LEV, AGNCY_TYP, LAYER, GAP_STS

id ▼ 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 geometry
17 Open Access 1 58 Borchard Park 16277 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 27.263 Borchard Park 0 Local Park 2 4 <Binary data: 212 bytes>
104 Open Access 1 294 Roy's Redwoods Open Space Preserve 29292 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 http://www.marincountyparks.org/depts/pk/divisions/open-space/roys-redwoods Marin 23 281.798 Roy's Redwoods OSP 1978 Local Conservation Area 4 2 <Binary data: 1124 bytes>
111 Open Access 1 327 San Carlos Beach Park 24846 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 1.92 San Carlos Beach Park 0 Local Park 2 4 <Binary data: 410 bytes>
194 Open Access 1 569 Foglesong Park/Eda Henderson Pool 18966 2203 Barstow Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Special District 4 2203 Barstow Recreation and Park District 76 Special District 4 Recreation/Parks District 4   San Bernardino 22 9.887 Foglesong Park/Eda Henderson Pool 0 Local Recreation Area 3 4 <Binary data: 132 bytes>
196 Open Access 1 615 Santa Susana Park 25139 2118 Rancho Simi Recreation and Park District 80 Special District 4 Recreation/Parks District 4 http://www.rsrpd.org/ Special District 4 2118 Rancho Simi Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Ventura 8 15.254 Santa Susana Park 0 Local Park 2 4 <Binary data: 228 bytes>
217 Open Access 1 586 Quarry Lakes Regional Recreation Area 30594 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 254.616 Quarry Lakes Reg. Rec. Area 2001 Local Recreation Area 3 4 <Binary data: 1207 bytes>
269 Open Access 1 916 Skyline Wilderness Park 835 222 California Bureau of Real Estate 111 State 5 State Agency 5 http://www.bre.ca.gov/ Other State 5 2268 Napa County Regional Park and Open Space District 108 Special District 4 Recreation/Parks District 4 http://www.skylinepark.org/ Napa 11 1021.072 Skyline Wilderness Park 1983 Local Conservation Area 4 2 <Binary data: 980 bytes>
302 Open Access 1 1040 Spring Meadow Park 25741 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 6.467 Spring Meadow Park 0 Local Park 2 4 <Binary data: 164 bytes>
357 Open Access 1 1009 Southshore Hills Park 25696 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.475 Southshore Hills Park 0 Local Park 2 4 <Binary data: 324 bytes>
364 Open Access 1 1045 Springville Park 25752 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 4.87 Springville Park 0 Local Park 2 4 <Binary data: 394 bytes>
367 Open Access 1 1056 Stagecoach Inn Park 25777 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 16.214 Stagecoach Inn Park 0 Local Park 2 4 <Binary data: 164 bytes>
384 Open Access 1 48338 Lago Vista Sports Park 32901 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/lago-vista-sports-park Riverside 10 28.451 Lago Vista Sports Park 0 Local Recreation Area 3 4 <Binary data: 996 bytes>
388 Open Access 1 1158 Strathearn Historical Park & Museum 25908 2118 Rancho Simi Recreation and Park District 80 Special District 4 Recreation/Parks District 4 http://www.rsrpd.org/ Special District 4 2118 Rancho Simi Recreation and Park District 78 Special District 4 Recreation/Parks District 4   Ventura 8 5.386 Strathearn Historical Park & Museum 0 Local Historic or Cultural Area 19 4 <Binary data: 260 bytes>
402 Open Access 1 1554 Tiburon Ridge Open Space Preserve 26341 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 14.684 Tiburon Ridge OSP 0 Local Conservation Area 4 2 <Binary data: 324 bytes>
446 Open Access 1 1418 Trigo Pasado Park 26535 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.344 Trigo Pasado Park 0 Local Park 2 4 <Binary data: 132 bytes>
449 Open Access 1 1427 Triunfo Park 7237 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 http://www.lamountains.com/parks.asp?parkid=62 Ventura 8 38.958 Triunfo Park 0 Local Park 2 4 <Binary data: 580 bytes>
483 Open Access 1 1943 Window to the Sea Park 27630 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.344 Window to the Sea Park 0 Local Park 2 4 <Binary data: 132 bytes>
486 Open Access 1 1684 Valle Lindo Park 26770 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 10.069 Valle Lindo Park 0 Local Park 2 4 <Binary data: 260 bytes>
490 Open Access 1 1963 Woodcreek Park 27704 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 4.956 Woodcreek Park 0 Local Park 2 4 <Binary data: 180 bytes>
502 Open Access 1 48367 Camarillo Grove Park 32933 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 http://www.pvrpd.org/parks/park_list/camarillo_grove_park.asp Ventura 8 25.264 Camarillo Grove Park 0 Local Park 2 4 <Binary data: 308 bytes>

Next page

Advanced export

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

CSV options:

CREATE TABLE [CPAD_2020a_Units] (
   [id] INTEGER PRIMARY KEY,
   [ACCESS_TYP] INTEGER,
   [UNIT_ID] INTEGER,
   [UNIT_NAME] TEXT,
   [SUID_NMA] INTEGER,
   [AGNCY_ID] INTEGER,
   [AGNCY_NAME] INTEGER,
   [AGNCY_LEV] INTEGER,
   [AGNCY_TYP] INTEGER,
   [AGNCY_WEB] TEXT,
   [LAYER] INTEGER,
   [MNG_AG_ID] INTEGER,
   [MNG_AGENCY] INTEGER,
   [MNG_AG_LEV] INTEGER,
   [MNG_AG_TYP] INTEGER,
   [PARK_URL] TEXT,
   [COUNTY] INTEGER,
   [ACRES] FLOAT,
   [LABEL_NAME] TEXT,
   [YR_EST] INTEGER,
   [DES_TP] INTEGER,
   [GAP_STS] TEXT
, "geometry" GEOMETRY,
   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_CPAD_2020a_Units_DES_TP]
                ON [CPAD_2020a_Units] ([DES_TP]);
CREATE INDEX [idx_CPAD_2020a_Units_COUNTY]
                ON [CPAD_2020a_Units] ([COUNTY]);
CREATE INDEX [idx_CPAD_2020a_Units_MNG_AG_TYP]
                ON [CPAD_2020a_Units] ([MNG_AG_TYP]);
CREATE INDEX [idx_CPAD_2020a_Units_MNG_AG_LEV]
                ON [CPAD_2020a_Units] ([MNG_AG_LEV]);
CREATE INDEX [idx_CPAD_2020a_Units_MNG_AGENCY]
                ON [CPAD_2020a_Units] ([MNG_AGENCY]);
CREATE INDEX [idx_CPAD_2020a_Units_LAYER]
                ON [CPAD_2020a_Units] ([LAYER]);
CREATE INDEX [idx_CPAD_2020a_Units_AGNCY_TYP]
                ON [CPAD_2020a_Units] ([AGNCY_TYP]);
CREATE INDEX [idx_CPAD_2020a_Units_AGNCY_LEV]
                ON [CPAD_2020a_Units] ([AGNCY_LEV]);
CREATE INDEX [idx_CPAD_2020a_Units_AGNCY_NAME]
                ON [CPAD_2020a_Units] ([AGNCY_NAME]);
CREATE INDEX [idx_CPAD_2020a_Units_ACCESS_TYP]
                ON [CPAD_2020a_Units] ([ACCESS_TYP]);
Powered by Datasette · Query took 411.763ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette