CPAD_2020a_Units

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

52 rows where AGNCY_NAME = 12

View and edit SQL

Suggested facets: ACCESS_TYP, MNG_AG_ID, MNG_AGENCY, MNG_AG_TYP, 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
17 Open Access 1 58 Borchard Park 16277 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 27.263 Borchard Park 0 Local Park 2 4 <Binary data: 212 bytes>
302 Open Access 1 1040 Spring Meadow Park 25741 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 6.467 Spring Meadow Park 0 Local Park 2 4 <Binary data: 164 bytes>
357 Open Access 1 1009 Southshore Hills Park 25696 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 4.475 Southshore Hills Park 0 Local Park 2 4 <Binary data: 324 bytes>
367 Open Access 1 1056 Stagecoach Inn Park 25777 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 16.214 Stagecoach Inn Park 0 Local Park 2 4 <Binary data: 164 bytes>
449 Open Access 1 1427 Triunfo Park 7237 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.lamountains.com/parks.asp?parkid=62 Ventura 8 38.958 Triunfo Park 0 Local Park 2 4 <Binary data: 580 bytes>
531 Open Access 1 1797 Walnut Grove Equestrian Center 27229 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 13.391 Walnut Grove Equestrian Ctr. 0 Local Recreation Area 3 4 <Binary data: 404 bytes>
539 Open Access 1 1801 Walnut Grove Park 27233 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 6.623 Walnut Grove Park 0 Local Park 2 4 <Binary data: 308 bytes>
546 Open Access 1 1822 Waverly Park 27320 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 7.419 Waverly Park 0 Local Park 2 4 <Binary data: 228 bytes>
1607 Open Access 1 13637 Dos Vientos Neighborhood Park 18232 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 5.87 Dos Vientos Neighborhood Park 0 Local Park 2 4 <Binary data: 324 bytes>
1826 Open Access 1 15708 Estella Park 18723 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 1.604 Estella Park 0 Local Park 2 4 <Binary data: 180 bytes>
2021 Open Access 1 17010 Banyan Park 15803 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 6.96 Banyan Park 0 Local Park 2 4 <Binary data: 356 bytes>
2045 Open Access 1 15585 Conejo Recreation and Park District 17586 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 0.656 Conejo Rec. and Park District 0 Local Recreation Area 3 4 <Binary data: 196 bytes>
2046 Open Access 1 15591 Conejo Recreation and Park District 17586 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 10.413 Conejo Rec. and Park District 0 Local Recreation Area 3 4 <Binary data: 548 bytes>
2353 Open Access 1 17105 Kimber Park 20647 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 8.259 Kimber Park 0 Local Park 2 4 <Binary data: 324 bytes>
2415 Open Access 1 17272 Lang Ranch Community Park 21012 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 126.522 Lang Ranch Community Park 0 Local Park 2 4 <Binary data: 1844 bytes>
2627 Open Access 1 18025 Morrow Circle 22506 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 4.053 Morrow Circle   None 215   <Binary data: 324 bytes>
2648 Open Access 1 18114 Newbury Gateway Park 22716 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 8.503 Newbury Gateway Park 0 Local Park 2 4 <Binary data: 548 bytes>
2662 Open Access 1 18174 North Ranch Neighborhood Park 22853 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 11.442 North Ranch Neighborhood Park 0 Local Park 2 4 <Binary data: 356 bytes>
2663 Open Access 1 18176 North Ranch Playfield 22854 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 11.94 North Ranch Playfield 0 Local Recreation Area 3 4 <Binary data: 420 bytes>
2698 Open Access 1 18273 Old Meadows FC 23089 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4 http://www.crpd.org/ Special District 4 2025 Conejo Recreation and Park District 12 Special District 4 Recreation/Parks District 4   Ventura 8 2.511 Old Meadows FC   None 221   <Binary data: 196 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]);
Powered by Datasette · Query took 54.442ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette