superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Forrestal Nature Preserve" and MNG_AG_TYP = 6
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12524 | 12524 | 12523 | {"type": "Polygon", "coordinates": [[[-118.35743, 33.73927], [-118.35609, 33.74137], [-118.35451, 33.74259], [-118.35482, 33.74403], [-118.35362, 33.74458], [-118.35252, 33.74529], [-118.35063, 33.7436], [-118.3464, 33.74233], [-118.34503, 33.74505], [-118.34344, 33.74433], [-118.33999, 33.7428], [-118.34048, 33.74141], [-118.34104, 33.74039], [-118.34184, 33.73965], [-118.34197, 33.73931], [-118.34325, 33.7401], [-118.34389, 33.74064], [-118.34434, 33.74033], [-118.34435, 33.73955], [-118.34415, 33.73943], [-118.34424, 33.73925], [-118.34391, 33.73909], [-118.3449, 33.73758], [-118.34551, 33.73785], [-118.34744, 33.73774], [-118.34871, 33.73993], [-118.34901, 33.74034], [-118.34923, 33.74059], [-118.34954, 33.74088], [-118.34981, 33.7411], [-118.35018, 33.74134], [-118.3505, 33.74153], [-118.35157, 33.74209], [-118.35167, 33.74196], [-118.35143, 33.74182], [-118.35146, 33.74177], [-118.35156, 33.74181], [-118.35157, 33.74178], [-118.35267, 33.74042], [-118.3527, 33.74039], [-118.35277, 33.74039], [-118.35285, 33.74041], [-118.35292, 33.74027], [-118.35275, 33.7402], [-118.35262, 33.7402], [-118.35329, 33.73935], [-118.35651, 33.74024], [-118.35681, 33.73955], [-118.35743, 33.73927]]]} | Open Access 1 | Forrestal Nature Preserve | 29614 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 158.1 | Forrestal Nature Preserve |
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]);