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

32 rows where MNG_AGENCY = 192

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
13 Open Access 1 Cucamonga/Demens Creek Trail Rest https://www.cityofrc.us/cityhall/cs/parks/trails/cucamonga.asp 31742 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 0.299 Cucamonga/Demens Creek Trail Rest   <Binary: 132 bytes>
1865 Open Access 1 Bear Gulch Park   15926 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 4.563 Bear Gulch Park   <Binary: 148 bytes>
2171 Open Access 1 Church Street Park   17249 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 7.512 Church Street Park   <Binary: 164 bytes>
2568 Open Access 1 East Beryl Park   18363 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 10.11 East Beryl Park   <Binary: 132 bytes>
2584 Open Access 1 Coyote Canyon Park   17734 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 4.517 Coyote Canyon Park   <Binary: 148 bytes>
2771 Open Access 1 Central Park   17056 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 98.797 Central Park   <Binary: 970 bytes>
3466 Open Access 1 Day Creek Park   17960 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 9.992 Day Creek Park   <Binary: 164 bytes>
3951 Open Access 1 Ellena Park   18584 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 6.059 Ellena Park   <Binary: 516 bytes>
4076 Open Access 1 Etiwanda Creek Community Park   18734 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 14.114 Etiwanda Creek Community Park   <Binary: 132 bytes>
4479 Open Access 1 Garcia Park   19192 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 5.56 Garcia Park   <Binary: 196 bytes>
4635 Open Access 1 Golden Oak Park   19366 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 4.998 Golden Oak Park   <Binary: 148 bytes>
5044 Open Access 1 Heritage Community Park   19834 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 36.41 Heritage Community Park   <Binary: 250 bytes>
5075 Open Access 1 Hermosa Park   19870 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 9.576 Hermosa Park   <Binary: 164 bytes>
5718 Open Access 1 Kenyon Park   20625 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 7.861 Kenyon Park   <Binary: 388 bytes>
5903 Open Access 1 Milliken Park   22250 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 7.131 Milliken Park   <Binary: 580 bytes>
6081 Open Access 1 Legacy Park   21139 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 3.752 Legacy Park   <Binary: 420 bytes>
6119 Open Access 1 Mountain View Park   22557 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 5.02 Mtn. View Park   <Binary: 148 bytes>
6255 Open Access 1 Lions Park   21322 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 2.733 Lions Park   <Binary: 228 bytes>
7662 Open Access 1 Old Town Park   23107 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 5.029 Old Town Park   <Binary: 164 bytes>
7672 Open Access 1 Olive Grove Park   23123 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 7.679 Olive Grove Park   <Binary: 484 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]);