CPAD_2020a_Units
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
266 rows where LAYER = 14
This data as json, geojson, copyable, CSV (advanced)
Suggested facets: ACCESS_TYP, AGNCY_TYP, MNG_AG_LEV, MNG_AG_TYP, COUNTY, YR_EST, DES_TP, GAP_STS
PARK_URL 30 ✖
- http://www.ehrhoa.com/info.php?pnum=458ee5f40122cd 3
- http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 2
- http://summerlyhomes.com/explore/ 2
- https://www.bellflower.org/home/index.asp?page=132 2
- https://www.greatshastarailtrail.org/ 2
- http://ohv.parks.ca.gov/?page_id=1179 1
- http://parks.lacounty.gov/wps/portal/dpr/!ut/p/b0/04_Sj9CPykssy0xPLMnMz0vMAfGjzOLdDAwM3P2dgo0MggwcDTxdQl3MnI3DDMwNDfQLsh0VASikIj4!/ 1
- http://www.carlsbadca.gov/services/depts/parks/facilities/north/cannon.asp 1
- http://www.paramountcity.com/parks.cfm?task=detail&ID=10 1
- http://www.petcoparkinsider.com/park-at-the-park 1
- http://www.santa-clarita.com/index.aspx?page=411 1
- http://www.wlv.org/index.aspx?NID=378 1
- https://ceqanet.opr.ca.gov/2003038103 1
- https://github.com/GreenInfo-Network/cpad/issues/37 1
- https://www.cityofmenifee.us/285/Parks 1
- https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3801835 1
- https://www.gorecreation.org/capri-pocket-park 1
- https://www.gorecreation.org/linear-park 1
- https://www.gorecreation.org/mahogany-meadows-pocket-park 1
- https://www.gorecreation.org/pompei-pocket-park 1
- https://www.gorecreation.org/sicily-pocket-park 1
- https://www.laketahoeparkassociation.com/sub_category_list.asp?category=9&title=Park+and+Beach+General+Policies 1
- https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/173/2783 1
- https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/175/2553?npage=2 1
- https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/177/2783 1
- https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/187/2783 1
- https://www.sfparksalliance.org/our-parks/parks/robert-pender-park 1
- https://www.villageoakscommonareasassociation.org/ 1
- https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/17/773 1
- https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/19/773 1
Advanced export
JSON shape: default, array, newline-delimited, object
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]);