superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AG_TYP = 5 and YR_EST = 1947
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
204 | 204 | 203 | {"type": "Polygon", "coordinates": [[[-124.20999, 41.99407], [-124.20847, 41.99408], [-124.20828, 41.99141], [-124.20979, 41.9914], [-124.20985, 41.99173], [-124.20999, 41.99407]]]} | Open Access 1 | Pelican State Beach | http://www.parks.ca.gov/?page_id=412 | 1672 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 9.291 | Pelican SB | 1947 |
207 | 207 | 206 | {"type": "Polygon", "coordinates": [[[-123.4007, 39.23677], [-123.39962, 39.23676], [-123.39959, 39.23635], [-123.39953, 39.23597], [-123.39935, 39.23563], [-123.39902, 39.2353], [-123.39873, 39.23505], [-123.3982, 39.23467], [-123.39742, 39.23454], [-123.39635, 39.23483], [-123.39644, 39.23675], [-123.39633, 39.24346], [-123.39638, 39.24722], [-123.39198, 39.24724], [-123.39194, 39.24339], [-123.39186, 39.24029], [-123.38725, 39.2403], [-123.38723, 39.24031], [-123.38735, 39.24342], [-123.3874, 39.24726], [-123.38279, 39.2473], [-123.38281, 39.25114], [-123.38745, 39.25115], [-123.38749, 39.25493], [-123.39195, 39.25495], [-123.39664, 39.25473], [-123.39651, 39.25848], [-123.39193, 39.25849], [-123.38281, 39.25841], [-123.37365, 39.25837], [-123.37363, 39.25839], [-123.37371, 39.26176], [-123.3592, 39.26178], [-123.35937, 39.25821], [-123.35465, 39.25816], [-123.35481, 39.25458], [-123.35021, 39.2545], [-123.35045, 39.25103], [-123.35508, 39.25107], [-123.35949, 39.25108], [-123.35946, 39.24727], [-123.35749, 39.24725], [-123.35772, 39.24663], [-123.35926, 39.24558], [-123.35941, 39.24525], [-123.36021, 39.24393], [-123.36441, 39.24393], [-123.36442, 39.24344], [-123.3644, 39.24105], [-123.36707, 39.24104], [-123.37133, 39.24294], [-123.3735, 39.24345], [-123.37522, 39.24223], [-123.37515, 39.24208], [-123.37507, 39.242], [-123.37497, 39.24168], [-123.37498, 39.24157], [-123.37513, 39.24137], [-123.37552, 39.24105], [-123.37572, 39.24093], [-123.37578, 39.2408], [-123.37585, 39.2407], [-123.37593, 39.24055], [-123.37601, 39.24039], [-123.37601, 39.24033], [-123.37346, 39.24031], [-123.37341, 39.23659], [-123.37572, 39.23668], [-123.37798, 39.2367], [-123.37785, 39.2331], [-123.37783, 39.22954], [-123.37609, 39.2295], [-123.37336, 39.22927], [-123.3732, 39.22206], [-123.36849, 39.22206], [-123.36853, 39.2185], [-123.36626, 39.21852], [-123.36618, 39.21491], [-123.36615, 39.21138], [-123.36838, 39.21129], [-123.36845, 39.21495], [-123.37313, 39.21486], [-123.37772, 39.21508], [-123.37773, 39.21866], [-123.37778, 39.222], [-123.39156, 39.22222], [-123.40058, 39.22234], [-123.40066, 39.22956], [-123.4007, 39.23677]]]} | Open Access 1 | Montgomery Woods State Natural Reserve | http://www.parks.ca.gov/?page_id=434 | 1641 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 2691.182 | Montgomery Woods SNR | 1947 |
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]);