superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "Worsham Canyon OS", MNG_AGENCY = 287 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
Link | rowid ▼ | id | map | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1060 | 1060 | 1059 | {"type": "Polygon", "coordinates": [[[-118.02482, 33.98022], [-118.02407, 33.9806], [-118.02376, 33.98114], [-118.02378, 33.98121], [-118.02382, 33.98124], [-118.02386, 33.98126], [-118.02393, 33.98125], [-118.02374, 33.98136], [-118.02358, 33.98126], [-118.02323, 33.98115], [-118.0225, 33.98121], [-118.0216, 33.98166], [-118.01997, 33.98163], [-118.01995, 33.98253], [-118.01677, 33.98248], [-118.01673, 33.98326], [-118.01617, 33.98356], [-118.01558, 33.98377], [-118.01406, 33.98404], [-118.01334, 33.98402], [-118.0129, 33.9839], [-118.01238, 33.98365], [-118.01159, 33.98351], [-118.01098, 33.98353], [-118.01011, 33.98279], [-118.00999, 33.982], [-118.01028, 33.98102], [-118.01084, 33.98063], [-118.01287, 33.9814], [-118.01311, 33.98104], [-118.01375, 33.98062], [-118.01378, 33.98056], [-118.01378, 33.9805], [-118.01371, 33.98042], [-118.01361, 33.9804], [-118.01256, 33.98079], [-118.01267, 33.98046], [-118.01485, 33.97894], [-118.01564, 33.97894], [-118.01564, 33.97709], [-118.01907, 33.97712], [-118.01997, 33.97662], [-118.01998, 33.97533], [-118.0235, 33.97537], [-118.0214, 33.97828], [-118.02166, 33.9793], [-118.02168, 33.97931], [-118.02173, 33.97925], [-118.02178, 33.97918], [-118.02178, 33.97915], [-118.02303, 33.97958], [-118.02325, 33.97977], [-118.02331, 33.97974], [-118.02366, 33.98006], [-118.02415, 33.97987], [-118.02482, 33.98022]]]} | Open Access 1 | Worsham Canyon Open Space | 14873 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 154.404 | Worsham Canyon OS |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, 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_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);