CPAD_2020a_SuperUnits

Table actions

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

433 rows where MNG_AGENCY = 4

This data as json, geojson, copyable, CSV (advanced)

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
15 Open Access 1 30th Street Mini Park   15192 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 0.23 30th Street MP   <Binary: 132 bytes>
30 Open Access 1 Encanto Expressway Open Space   18635 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 14.138 Encanto Expressway OS   <Binary: 1,935 bytes>
41 Open Access 1 Navajo Canyon Open Space Park   22675 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 155.928 Navajo Canyon OS Park   <Binary: 2,154 bytes>
43 Open Access 1 47th Street Canyon   15202 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 10.029 47th Street Canyon   <Binary: 756 bytes>
107 Open Access 1 Hampe Hills Open Space   19630 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 8.407 Hampe Hills OS   <Binary: 548 bytes>
318 Restricted Access 2 Clay Elementary School Park   31950 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 3.7 Clay Elementary School Park   <Binary: 148 bytes>
476 Open Access 1 Adobe Bluffs Neighborhood Park   15270 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 5.15 Adobe Bluffs Neighborhood Park   <Binary: 452 bytes>
479 Open Access 1 Adobe Falls Open Space Park   15271 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 4.006 Adobe Falls OS Park   <Binary: 228 bytes>
690 Open Access 1 Carmel Valley Open Space   10280 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 511.468 Carmel Valley OS   <Binary: 21,280 bytes>
692 Open Access 1 Black Mountain Open Space Park http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml 10257 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 2533.913 Black Mtn. OS Park   <Binary: 16,486 bytes>
694 Open Access 1 Balboa Park http://www.sandiego.gov/park-and-recreation/parks/regional/balboa/index.shtml 10235 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1052.9 Balboa Park   <Binary: 16,651 bytes>
704 Open Access 1 Mission Bay Park http://www.sandiego.gov/park-and-recreation/parks/regional/missionbay/ 10430 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 3897.63 Mission Bay Park   <Binary: 28,596 bytes>
719 Open Access 1 Davis House Mini Park   17950 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 0.118 Davis House MP   <Binary: 132 bytes>
728 Open Access 1 Sabre Springs South Open Space   10518 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 451.855 Sabre Springs South OS   <Binary: 10,361 bytes>
732 Open Access 1 Semillon Mini Park   25294 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 0.437 Semillon MP   <Binary: 148 bytes>
738 Open Access 1 Morley Green Mini Park   30227 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1.168 Morley Green MP   <Binary: 196 bytes>
782 Open Access 1 Terrace Drive Mini Park https://www.sandiego.gov/sites/default/files/adams.pdf 33549 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 0.758 Terrace Drive MP   <Binary: 132 bytes>
789 Open Access 1 City Heights Square Mini Park   33550 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 0.123 City Heights Square MP   <Binary: 132 bytes>
821 Open Access 1 Tijuana River Valley Regional Park http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html 26363 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 11.184 Tijuana River Valley RP   <Binary: 753 bytes>
899 Open Access 1 Manzanita Gathering Place http://rootedinplace.com/portfolio-items/manzanita-gathering-place/ 32782 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 0.446 Manzanita Gathering Place 2013 <Binary: 292 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]);