units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 8, MNG_AGENCY = 47 and YR_EST = 1947
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10802 | 10802 | 10801 | {"type": "Polygon", "coordinates": [[[-123.37785, 39.2331], [-123.37783, 39.22954], [-123.37609, 39.2295], [-123.37336, 39.22927], [-123.3732, 39.22205], [-123.36849, 39.22206], [-123.36853, 39.21849], [-123.36626, 39.21852], [-123.36618, 39.21491], [-123.36615, 39.21138], [-123.36838, 39.21129], [-123.36844, 39.21495], [-123.37313, 39.21486], [-123.37772, 39.21508], [-123.37773, 39.21866], [-123.37778, 39.22201], [-123.39156, 39.22222], [-123.40058, 39.22234], [-123.40066, 39.22956], [-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.39634, 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.38724, 39.2403], [-123.38723, 39.24031], [-123.38735, 39.24342], [-123.3874, 39.24726], [-123.38279, 39.24729], [-123.38281, 39.25114], [-123.38745, 39.25115], [-123.38749, 39.25494], [-123.39195, 39.25495], [-123.39664, 39.25473], [-123.39651, 39.25848], [-123.39193, 39.25849], [-123.38281, 39.25841], [-123.37364, 39.25837], [-123.37363, 39.25838], [-123.37371, 39.26176], [-123.3592, 39.26178], [-123.35938, 39.25821], [-123.35465, 39.25816], [-123.35481, 39.25458], [-123.35021, 39.2545], [-123.35045, 39.25103], [-123.35508, 39.25107], [-123.3595, 39.25108], [-123.35946, 39.24726], [-123.35749, 39.24725], [-123.35772, 39.24663], [-123.35926, 39.24558], [-123.35941, 39.24525], [-123.36021, 39.24393], [-123.36441, 39.24394], [-123.36442, 39.24344], [-123.3644, 39.24105], [-123.36707, 39.24104], [-123.37134, 39.24294], [-123.3735, 39.24345], [-123.37522, 39.24222], [-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.37602, 39.24032], [-123.37346, 39.24031], [-123.37341, 39.23659], [-123.37572, 39.23668], [-123.37798, 39.2367], [-123.37785, 39.2331]]]} | Open Access 1 | 20504 | Montgomery Woods State Natural Reserve | 1641 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=434 | Mendocino 24 | 2690.737 | Montgomery Woods SNR | 1947 | State Conservation Area 8 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, 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_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);