units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, DES_TP = 15, MNG_AG_TYP = 5 and YR_EST = 1976
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16544 | 16544 | 16543 | {"type": "Polygon", "coordinates": [[[-122.50503, 38.00419], [-122.50193, 38.00711], [-122.5018, 38.00732], [-122.50174, 38.0076], [-122.50162, 38.00778], [-122.50138, 38.00802], [-122.50097, 38.00835], [-122.5006, 38.0085], [-122.50043, 38.00867], [-122.50031, 38.00891], [-122.50009, 38.00918], [-122.49957, 38.00951], [-122.49953, 38.00983], [-122.49891, 38.01051], [-122.49846, 38.01098], [-122.49819, 38.01149], [-122.49735, 38.01358], [-122.49261, 38.01094], [-122.48933, 38.01234], [-122.4895, 38.0131], [-122.48923, 38.01368], [-122.48847, 38.01316], [-122.48831, 38.01285], [-122.48796, 38.01262], [-122.48688, 38.0108], [-122.48589, 38.00918], [-122.48415, 38.00777], [-122.48287, 38.00766], [-122.48259, 38.00772], [-122.48234, 38.00767], [-122.48215, 38.00768], [-122.48203, 38.00772], [-122.48188, 38.00774], [-122.48172, 38.0077], [-122.48162, 38.00765], [-122.4815, 38.00754], [-122.48135, 38.00724], [-122.48081, 38.00667], [-122.48038, 38.00636], [-122.48005, 38.00605], [-122.47958, 38.00571], [-122.47893, 38.00549], [-122.47893, 38.01029], [-122.47026, 38.00743], [-122.46201, 38.00453], [-122.45356, 37.99846], [-122.45583, 37.9972], [-122.45647, 37.99687], [-122.45921, 37.99732], [-122.46526, 38.00042], [-122.46667, 38.00066], [-122.46668, 38.00065], [-122.46665, 37.99943], [-122.46668, 37.99858], [-122.46897, 37.99864], [-122.46896, 38.00001], [-122.47158, 38.00009], [-122.47203, 37.9992], [-122.47631, 37.99977], [-122.47657, 37.9952], [-122.47582, 37.99406], [-122.47601, 37.99396], [-122.47618, 37.99389], [-122.47631, 37.99386], [-122.47659, 37.99382], [-122.47676, 37.99378], [-122.47695, 37.99371], [-122.47716, 37.99358], [-122.4772, 37.99354], [-122.47695, 37.99329], [-122.47701, 37.99325], [-122.47731, 37.9935], [-122.4774, 37.9935], [-122.4776, 37.9937], [-122.47768, 37.99386], [-122.47767, 37.99403], [-122.47757, 37.9943], [-122.47756, 37.99448], [-122.4776, 37.99467], [-122.47771, 37.99489], [-122.47781, 37.99496], [-122.4779, 37.99494], [-122.47812, 37.99476], [-122.4782, 37.99483], [-122.47796, 37.99505], [-122.47796, 37.9951], [-122.47799, 37.99514], [-122.47809, 37.9952], [-122.47836, 37.99531], [-122.47846, 37.9954], [-122.47872, 37.99574], [-122.47876, 37.99578], [-122.47887, 37.9958], [-122.47919, 37.9957], [-122.47927, 37.99581], [-122.47903, 37.99595], [-122.47899, 37.99599], [-122.47898, 37.99604], [-122.47898, 37.99608], [-122.47911, 37.99631], [-122.47917, 37.99649], [-122.47919, 37.99665], [-122.47919, 37.99694], [-122.48022, 37.99696], [-122.48023, 37.99658], [-122.4802, 37.99635], [-122.4808, 37.99634], [-122.48124, 37.99616], [-122.48169, 37.99632], [-122.48201, 37.99599], [-122.48194, 37.99593], [-122.48246, 37.9954], [-122.48319, 37.99591], [-122.48339, 37.99591], [-122.48339, 37.99239], [-122.48487, 37.99126], [-122.48657, 37.99003], [-122.48883, 37.99143], [-122.4909, 37.98936], [-122.48847, 37.98609], [-122.48412, 37.98559], [-122.48036, 37.98519], [-122.48, 37.98505], [-122.47956, 37.98484], [-122.47957, 37.98473], [-122.48009, 37.98378], [-122.48201, 37.98442], [-122.48271, 37.98413], [-122.4831, 37.98399], [-122.48342, 37.98396], [-122.4839, 37.98406], [-122.4846, 37.98425], [-122.48532, 37.98405], [-122.48577, 37.98406], [-122.48599, 37.98428], [-122.48612, 37.98434], [-122.48627, 37.98434], [-122.48655, 37.98419], [-122.48791, 37.9821], [-122.49078, 37.98355], [-122.49221, 37.98499], [-122.49336, 37.98589], [-122.4938, 37.98622], [-122.49418, 37.98664], [-122.49487, 37.98707], [-122.49521, 37.98721], [-122.49548, 37.99683], [-122.49549, 37.99683], [-122.49595, 37.99646], [-122.49628, 37.99597], [-122.49716, 37.99601], [-122.4982, 37.99593], [-122.4994, 37.99562], [-122.4999, 37.99511], [-122.50008, 37.99533], [-122.50006, 37.99568], [-122.49997, 37.9959], [-122.50016, 37.99643], [-122.50005, 37.99685], [-122.50032, 37.9969], [-122.50063, 37.99685], [-122.50134, 37.99683], [-122.50179, 37.99746], [-122.50147, 37.99774], [-122.50213, 37.9986], [-122.50298, 37.99854], [-122.50313, 37.99833], [-122.5041, 37.99849], [-122.50503, 38.00419]], [[-122.46204, 38.00437], [-122.46209, 38.00429], [-122.46206, 38.00426], [-122.46201, 38.00424], [-122.46196, 38.00427], [-122.46192, 38.00434], [-122.46195, 38.00446], [-122.462, 38.00448], [-122.46203, 38.00452], [-122.46205, 38.00443], [-122.46204, 38.00437]]]} | Open Access 1 | 11238 | China Camp State Park | 1475 | 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=466 | Marin 23 | 1524.442 | China Camp SP | 1976 | State Park 15 | 4 |
16561 | 16561 | 16560 | {"type": "MultiPolygon", "coordinates": [[[[-120.16091, 39.20563], [-120.14219, 39.2056], [-120.13286, 39.20564], [-120.13288, 39.202], [-120.13287, 39.1983], [-120.1235, 39.19836], [-120.1234, 39.19101], [-120.1234, 39.18726], [-120.12343, 39.18638], [-120.12492, 39.18637], [-120.12489, 39.1862], [-120.12479, 39.18593], [-120.12468, 39.18566], [-120.1242, 39.18509], [-120.12388, 39.18427], [-120.12374, 39.18407], [-120.1241, 39.18388], [-120.12454, 39.18368], [-120.12938, 39.18367], [-120.13495, 39.18369], [-120.13495, 39.18291], [-120.13236, 39.17826], [-120.13482, 39.17692], [-120.13491, 39.177], [-120.13492, 39.17642], [-120.13508, 39.17632], [-120.13891, 39.17636], [-120.13946, 39.17719], [-120.14358, 39.18372], [-120.15309, 39.18378], [-120.16086, 39.18398], [-120.16084, 39.19824], [-120.16091, 39.20563]]], [[[-120.14412, 39.16673], [-120.14389, 39.16687], [-120.14386, 39.16691], [-120.14377, 39.16692], [-120.14361, 39.16699], [-120.14339, 39.16715], [-120.1432, 39.16721], [-120.14286, 39.16718], [-120.14279, 39.16712], [-120.14264, 39.1669], [-120.14242, 39.16672], [-120.14231, 39.16659], [-120.14271, 39.16657], [-120.14288, 39.16642], [-120.14305, 39.16648], [-120.14312, 39.16645], [-120.14311, 39.16618], [-120.14331, 39.16597], [-120.14344, 39.16604], [-120.14357, 39.16608], [-120.14369, 39.1661], [-120.14375, 39.16607], [-120.14388, 39.16638], [-120.14412, 39.16673]]]]} | Open Access 1 | 17050 | Burton Creek State Park | 1449 | 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=512 | Placer 35 | 1902.333 | Burton Creek SP | 1976 | State Park 15 | 4 |
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]);