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

59 rows where MNG_AGENCY = 57

View and edit SQL

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
1 Open Access 1 Deer Canyon Park http://www.anaheim.net/comm_svc/parks/parkDetail.asp?dir=park_deer_canyon_preserve 129 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 287.621 Deer Canyon Park   <Binary: 3828 bytes>
1307 Open Access 1 Anaheim Coves   15465 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 29.091 Anaheim Coves   <Binary: 564 bytes>
1317 Open Access 1 Anaheim holding 1   15466 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 5.206 Anaheim holding 1   <Binary: 324 bytes>
1318 Open Access 1 Anaheim holding 2   15467 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 3.08 Anaheim holding 2   <Binary: 276 bytes>
1321 Open Access 1 Anaheim holding 3   15468 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 3.955 Anaheim holding 3   <Binary: 132 bytes>
1331 Open Access 1 Anaheim holding 4   15469 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 4.264 Anaheim holding 4   <Binary: 260 bytes>
1785 Open Access 1 Barton Park   15844 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 4.502 Barton Park   <Binary: 164 bytes>
2192 Open Access 1 Boysen Park   16318 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 24.4 Boysen Park   <Binary: 276 bytes>
2279 Open Access 1 Brookhurst Park   16423 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 26.893 Brookhurst Park   <Binary: 372 bytes>
2435 Open Access 1 Colony Square   17539 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 0.163 Colony Square   <Binary: 132 bytes>
2601 Open Access 1 Canyon Rim Park   16825 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 8.985 Canyon Rim Park   <Binary: 452 bytes>
2833 Open Access 1 Chaparral Park   17125 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 9.618 Chaparral Park   <Binary: 132 bytes>
2958 Open Access 1 Citrus Park   17283 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 2.787 Citrus Park   <Binary: 324 bytes>
3108 Open Access 1 Colony Park   17534 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 0.953 Colony Park   <Binary: 308 bytes>
3223 Open Access 1 Cottonwood Park   17687 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 0.387 Cottonwood Park   <Binary: 196 bytes>
3858 Open Access 1 Edison Park   18445 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 7.387 Edison Park   <Binary: 132 bytes>
4029 Open Access 1 Energy Field Park   18673 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 2.55 Energy Field Park   <Binary: 276 bytes>
4082 Open Access 1 Eucalyptus Park   18740 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 9.906 Eucalyptus Park   <Binary: 388 bytes>
4547 Open Access 1 George Washington Park   19275 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 1.678 George Washington Park   <Binary: 164 bytes>
4879 Open Access 1 Hansen Park   19648 1006 Anaheim, City of 57 City 2 City Agency 2 http://www.anaheim.net/comm_svc/parks/ City 2 6.621 Hansen Park   <Binary: 308 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]);