CPAD_2020a_Units

Table actions

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

9 rows where MNG_AGENCY = 645

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

Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME

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
3539 Open Access 1 20600 Hollydale Community Park 20048 1339 South Gate, City of 657 City 2 City Agency 2 http://www.cityofsouthgate.org/ City 2 1339 South Gate, City of 645 City 2 City Agency 2   Los Angeles 6 1.539 Hollydale Community Park 0 Local Park 2 4 <Binary: 132 bytes>
4171 Open Access 1 46508 Circle Park 29791 6073 Southern California Edison 655 Private 7 Utility 21 https://www.sce.com Private 14 1339 South Gate, City of 645 City 2 City Agency 2   Los Angeles 6 4.401 Circle Park 0 Local Park 2 4 <Binary: 180 bytes>
5497 Open Access 1 12838 South Gate Park 25654 1339 South Gate, City of 657 City 2 City Agency 2 http://www.cityofsouthgate.org/ City 2 1339 South Gate, City of 645 City 2 City Agency 2   Los Angeles 6 83.175 South Gate Park 0 Local Park 2 4 <Binary: 538 bytes>
5563 Open Access 1 20599 Hollydale Park 20049 1339 South Gate, City of 657 City 2 City Agency 2 http://www.cityofsouthgate.org/ City 2 1339 South Gate, City of 645 City 2 City Agency 2   Los Angeles 6 48.034 Hollydale Park 0 Local Park 2 4 <Binary: 266 bytes>
10825 Open Access 1 20620 Triangle Park 26533 1339 South Gate, City of 657 City 2 City Agency 2 http://www.cityofsouthgate.org/ City 2 1339 South Gate, City of 645 City 2 City Agency 2   Los Angeles 6 0.568 Triangle Park 0 Local Park 2 4 <Binary: 132 bytes>
10826 Open Access 1 20621 Stanford Avenue Park 25785 1339 South Gate, City of 657 City 2 City Agency 2 http://www.cityofsouthgate.org/ City 2 1339 South Gate, City of 645 City 2 City Agency 2   Los Angeles 6 0.743 Stanford Avenue Park 0 Local Park 2 4 <Binary: 132 bytes>
10841 Open Access 1 20622 Cesar Chavez Park 30832 1339 South Gate, City of 657 City 2 City Agency 2 http://www.cityofsouthgate.org/ City 2 1339 South Gate, City of 645 City 2 City Agency 2   Los Angeles 6 9.852 Cesar Chavez Park 0 Local Park 2 4 <Binary: 731 bytes>
14771 Open Access 1 47227 State Street Park 30934 1339 South Gate, City of 657 City 2 City Agency 2 http://www.cityofsouthgate.org/ City 2 1339 South Gate, City of 645 City 2 City Agency 2 http://cityofsouthgate.org/Facilities/Facility/Details/State-Street-Park-11 Los Angeles 6 3.495 State Street Park 0 Local Park 2 4 <Binary: 561 bytes>
15330 Open Access 1 46507 Circle Park 29791 1339 South Gate, City of 657 City 2 City Agency 2 http://www.cityofsouthgate.org/ City 2 1339 South Gate, City of 645 City 2 City Agency 2   Los Angeles 6 0.2 Circle Park 0 Local Park 2 4 <Binary: 132 bytes>

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]);