superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and LABEL_NAME = "San Dieguito Lagoon"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
MNG_AG_TYP 2
ACCESS_TYP 1
- Open Access · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7713 | 7713 | 7712 | {"type": "MultiPolygon", "coordinates": [[[[-117.24735, 32.96922], [-117.24593, 32.96921], [-117.24593, 32.96923], [-117.24638, 32.96992], [-117.2445, 32.96992], [-117.24371, 32.97056], [-117.24369, 32.97114], [-117.24394, 32.97137], [-117.24404, 32.97165], [-117.24404, 32.97187], [-117.24398, 32.97218], [-117.24382, 32.97234], [-117.24361, 32.97234], [-117.24328, 32.97225], [-117.24315, 32.97208], [-117.24316, 32.97158], [-117.24305, 32.97158], [-117.24169, 32.97116], [-117.24127, 32.97067], [-117.23964, 32.97065], [-117.23954, 32.97036], [-117.23941, 32.97006], [-117.23923, 32.96977], [-117.23904, 32.96953], [-117.23677, 32.96735], [-117.23875, 32.96737], [-117.23876, 32.96375], [-117.23968, 32.96375], [-117.24306, 32.96168], [-117.24306, 32.96378], [-117.24569, 32.96381], [-117.2457, 32.96397], [-117.24735, 32.96759], [-117.24735, 32.96922]]], [[[-117.25165, 32.96386], [-117.24822, 32.96383], [-117.24814, 32.96365], [-117.24879, 32.96367], [-117.24926, 32.96341], [-117.24928, 32.96339], [-117.24933, 32.96292], [-117.24872, 32.96292], [-117.24872, 32.96289], [-117.2487, 32.96287], [-117.24933, 32.96283], [-117.24898, 32.96229], [-117.24872, 32.9617], [-117.24906, 32.96147], [-117.24963, 32.96157], [-117.2502, 32.96181], [-117.25059, 32.96137], [-117.25064, 32.96139], [-117.25069, 32.96146], [-117.25073, 32.96153], [-117.25074, 32.9617], [-117.25081, 32.96191], [-117.2511, 32.96236], [-117.25122, 32.96245], [-117.25136, 32.96251], [-117.25146, 32.96252], [-117.25164, 32.96252], [-117.25165, 32.96386]]]]} | Open Access 1 | San Dieguito Lagoon | 24864 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 166.422 | San Dieguito Lagoon | ||
7714 | 7714 | 7713 | {"type": "Polygon", "coordinates": [[[-117.26035, 32.96792], [-117.26005, 32.96812], [-117.25973, 32.9678], [-117.2599, 32.96778], [-117.2601, 32.96779], [-117.26023, 32.96784], [-117.26035, 32.96792]]]} | Open Access 1 | San Dieguito Lagoon | http://sandieguitorivervalleyconservancy.org/sdrvc1_projects_acquisitions1.html | 24865 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 0.286 | San Dieguito Lagoon |
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]);