CPAD_2020a_Units

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

17,068 rows

View and edit SQL

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
20 Open Access 1 77 Aurora Park 15710 1248 Patterson, City of 10 City 2 City Agency 2 http://www.ci.patterson.ca.us/ City 2 1248 Patterson, City of 10 City 2 City Agency 2   Stanislaus 2 0.447 Aurora Park 0 Local Park 2 4 <Binary data: 148 bytes>
21 Open Access 1 60 Bigby VIlla Park 16097 1114 Fresno, City of 14 City 2 City Agency 2 http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm City 2 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 3.426 Bigby VIlla Park 0 Local Park 2 4 <Binary data: 212 bytes>
22 Open Access 1 17469 City of Moreno Valley Open Space 6975 1216 Moreno Valley, City of 15 City 2 City Agency 2 http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml City 2 1216 Moreno Valley, City of 15 City 2 City Agency 2   Riverside 10 471.264 City of Moreno Valley OS 0 Local Recreation Area 3 4 <Binary data: 10415 bytes>
23 Open Access 1 62 Atlantic Avenue Park 15674 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 1.951 Atlantic Avenue Park 0 Local Park 2 4 <Binary data: 260 bytes>
24 No Public Access 3 64 Real Estate Services Division 24211 203 California Department of General Services 17 State 5 State Agency 5 http://www.dgs.ca.gov/default.htm Other State 5 203 California Department of General Services 17 State 5 State Agency 5   Napa 11 0.203 Real Estate Services Division   None 6   <Binary data: 132 bytes>
25 Open Access 1 89 Colina Del Sol Community Park 17497 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 29.899 Colina Del Sol Community Park 0 Local Park 2 4 <Binary data: 452 bytes>
26 Open Access 1 78 El Marino Park 18512 1075 Culver City, City of 18 City 2 City Agency 2 http://www.culvercity.org/Home/Government/PRCS City 2 1075 Culver City, City of 18 City 2 City Agency 2   Los Angeles 6 1.645 El Marino Park 0 Local Park 2 4 <Binary data: 164 bytes>
27 Open Access 1 154 El Salvador Park 18538 1316 Santa Ana, City of 19 City 2 City Agency 2 http://www.santa-ana.org/parks/ City 2 1316 Santa Ana, City of 19 City 2 City Agency 2   Orange 3 7.57 El Salvador Park 0 Local Park 2 4 <Binary data: 196 bytes>
28 Open Access 1 46752 Corte Playa San Juan Mini-Park 30203 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 0.206 Corte Playa San Juan Mini-Park 0 Local Park 2 4 <Binary data: 244 bytes>
29 Open Access 1 46753 Cuvier Park 30204 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2 https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/cuvier San Diego 4 0.83 Cuvier Park 0 Local Park 2 4 <Binary data: 356 bytes>
30 Open Access 1 80 River Park 24416 325 Santa Barbara, County of 7 County 3 County Agency 3 http://cosb.countyofsb.org/parks/ County 3 325 Santa Barbara, County of 7 County 3 County Agency 3   Santa Barbara 7 123.418 River Park 0 Local Park 2 4 <Binary data: 516 bytes>
31 Open Access 1 81 Autumn Royal Park 15718 1248 Patterson, City of 10 City 2 City Agency 2 http://www.ci.patterson.ca.us/ City 2 1248 Patterson, City of 10 City 2 City Agency 2   Stanislaus 2 2.417 Autumn Royal Park 0 Local Park 2 4 <Binary data: 132 bytes>
32 Open Access 1 87 Blenheim Park 16159 1248 Patterson, City of 10 City 2 City Agency 2 http://www.ci.patterson.ca.us/ City 2 1248 Patterson, City of 10 City 2 City Agency 2   Stanislaus 2 1.244 Blenheim Park 0 Local Park 2 4 <Binary data: 228 bytes>
33 Open Access 1 83 Mission Hills Park and Open Space 22301 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 7.109 Mission Hills Park and OS 0 Local Recreation Area 3 4 <Binary data: 583 bytes>
34 Open Access 1 21941 Scripps-Miramar Ranch Open Space 10552 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 366.385 Scripps-Miramar Ranch OS 0 Local Recreation Area 3 4 <Binary data: 25736 bytes>
35 Open Access 1 118 Dailard Neighborhood Park 17891 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 4.634 Dailard Neighborhood Park 0 Local Park 2 4 <Binary data: 164 bytes>
36 Open Access 1 119 Booker T. Anderson Jr. Park 16269 1274 Richmond, City of 20 City 2 City Agency 2 http://www.ci.richmond.ca.us/index.aspx?NID=2075 City 2 1274 Richmond, City of 20 City 2 City Agency 2   Contra Costa 12 21.023 Booker T. Anderson Jr. Park 0 Local Park 2 4 <Binary data: 180 bytes>
37 Open Access 1 121 El Pescadero Park 18527 1248 Patterson, City of 10 City 2 City Agency 2 http://www.ci.patterson.ca.us/ City 2 1248 Patterson, City of 10 City 2 City Agency 2   Stanislaus 2 0.352 El Pescadero Park 0 Local Park 2 4 <Binary data: 132 bytes>
38 Open Access 1 122 Bernal Heights Park 16026 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 1300 San Francisco, City and County of 21 City 2 City Agency 2   San Francisco 13 19.35 Bernal Heights Park 0 Local Park 2 4 <Binary data: 1000 bytes>
39 Open Access 1 127 Rockview Right-of-Way 24536 1307 San Luis Obispo, City of 22 City 2 City Agency 2 http://www.slocity.org/parksandrecreation/index.asp City 2 1307 San Luis Obispo, City of 22 City 2 City Agency 2   San Luis Obispo 1 0.123 Rockview Right-of-Way   None 7   <Binary data: 132 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 18.414ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette