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

59 rows where MNG_AGENCY = 57

View and edit SQL

Suggested facets: YR_EST, DES_TP

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
148 Open Access 1 381 Eucalyptus Park 18740 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 9.905 Eucalyptus Park 0 Local Park 2 4 <Binary: 388 bytes>
633 Open Access 1 2521 John Marshall Park 20457 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 13.948 John Marshall Park 0 Local Park 2 4 <Binary: 404 bytes>
645 Open Access 1 3194 La Palma Park 20780 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 16.03 La Palma Park 0 Local Park 2 4 <Binary: 308 bytes>
793 Open Access 1 5169 Maxwell Park 21970 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 19.293 Maxwell Park 0 Local Park 2 4 <Binary: 324 bytes>
867 Open Access 1 5616 Citrus Park 17283 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 2.785 Citrus Park 0 Local Park 2 4 <Binary: 324 bytes>
882 Open Access 1 5707 Manzanita Park 21768 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 6.245 Manzanita Park 0 Local Park 2 4 <Binary: 148 bytes>
1201 Open Access 1 8374 Peter Marshall Park 23627 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 4.555 Peter Marshall Park 0 Local Park 2 4 <Binary: 228 bytes>
1261 Open Access 1 5693 Lincoln Park 21261 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 5.389 Lincoln Park 0 Local Park 2 4 <Binary: 330 bytes>
1362 Open Access 1 8146 Pearson Park 23549 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 18.827 Pearson Park 0 Local Park 2 4 <Binary: 212 bytes>
1398 Open Access 1 8773 Ponderosa Park 23887 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 8.563 Ponderosa Park 0 Local Park 2 4 <Binary: 164 bytes>
2479 Open Access 1 18993 Riverdale Park 24440 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 8.669 Riverdale Park 0 Local Park 2 4 <Binary: 148 bytes>
2900 Open Access 1 18953 Edison Park 18445 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 7.389 Edison Park 0 Local Park 2 4 <Binary: 132 bytes>
2911 Open Access 1 18988 Julianna Park 20520 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 0.607 Julianna Park 0 Local Park 2 4 <Binary: 308 bytes>
2912 Open Access 1 18989 Juarez Park 20515 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 8.975 Juarez Park 0 Local Park 2 4 <Binary: 340 bytes>
3191 Open Access 1 22115 Imperial Park 20180 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 8.207 Imperial Park 0 Local Park 2 4 <Binary: 644 bytes>
3429 Open Access 1 48740 Friendship Plaza 33466 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2 https://www.anaheim.net/facilities/facility/details/Friendship-Plaza-86 Orange 3 0.663 Friendship Plaza 0 Local Park 2 4 <Binary: 196 bytes>
3446 Open Access 1 25269 Stoddard Park 25863 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 10.242 Stoddard Park 0 Local Park 2 4 <Binary: 324 bytes>
3559 Open Access 1 36526 Anaheim holding 3 15468 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 3.956 Anaheim holding 3 0 Local Other or Unknown 14 4 <Binary: 132 bytes>
3654 Open Access 1 29596 Hansen Park 19648 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 6.605 Hansen Park 0 Local Park 2 4 <Binary: 308 bytes>
3780 Open Access 1 8684 Energy Field Park 18673 1006 Anaheim, City of 59 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1006 Anaheim, City of 57 City 2 City Agency 2   Orange 3 2.549 Energy Field Park 0 Local Recreation Area 3 4 <Binary: 276 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]);