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 = 1937
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
333 | 333 | 332 | {"type": "MultiPolygon", "coordinates": [[[[-122.49035, 40.5981], [-122.48979, 40.59856], [-122.48973, 40.59856], [-122.48914, 40.59809], [-122.48856, 40.59758], [-122.48903, 40.59717], [-122.49035, 40.5981]]], [[[-122.49088, 40.59846], [-122.49038, 40.59887], [-122.49055, 40.59893], [-122.49077, 40.59908], [-122.48996, 40.59971], [-122.48937, 40.59889], [-122.48974, 40.5986], [-122.48982, 40.59859], [-122.49038, 40.59812], [-122.49088, 40.59846]]], [[[-122.49222, 40.59936], [-122.49114, 40.60027], [-122.49076, 40.60002], [-122.49029, 40.60041], [-122.49001, 40.59973], [-122.49084, 40.59908], [-122.49091, 40.59906], [-122.49132, 40.59877], [-122.4921, 40.59931], [-122.49214, 40.5993], [-122.49222, 40.59936]]], [[[-122.4927, 40.59839], [-122.49267, 40.59877], [-122.49232, 40.59906], [-122.49005, 40.59748], [-122.49049, 40.59712], [-122.49187, 40.59797], [-122.49219, 40.59803], [-122.4927, 40.59839]]], [[[-122.4948, 40.60133], [-122.49358, 40.60236], [-122.49289, 40.60188], [-122.49227, 40.60239], [-122.49185, 40.60201], [-122.49163, 40.60214], [-122.49153, 40.60202], [-122.49183, 40.60183], [-122.49161, 40.60162], [-122.49219, 40.6013], [-122.49299, 40.60073], [-122.49238, 40.60031], [-122.49258, 40.60012], [-122.49238, 40.59997], [-122.49242, 40.59995], [-122.49241, 40.59993], [-122.49201, 40.59965], [-122.49234, 40.59937], [-122.49322, 40.59998], [-122.49317, 40.60004], [-122.49317, 40.60005], [-122.49396, 40.6006], [-122.49387, 40.60067], [-122.49388, 40.60069], [-122.4948, 40.60133]]], [[[-122.49322, 40.59868], [-122.49255, 40.59925], [-122.4924, 40.59915], [-122.49307, 40.59858], [-122.49322, 40.59868]]]]} | Open Access 1 | Shasta State Historic Park | http://www.parks.ca.gov/?page_id=456 | 1742 | 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 | 23.925 | Shasta SHP | 1937 |
15170 | 15170 | 15169 | {"type": "Polygon", "coordinates": [[[-124.15946, 41.06946], [-124.15941, 41.06953], [-124.15927, 41.06951], [-124.15922, 41.06961], [-124.15899, 41.06982], [-124.15821, 41.07014], [-124.158, 41.0702], [-124.1578, 41.07031], [-124.1578, 41.07043], [-124.15804, 41.07103], [-124.15825, 41.07131], [-124.15844, 41.07149], [-124.15858, 41.07166], [-124.15872, 41.07172], [-124.15911, 41.07196], [-124.15925, 41.07217], [-124.15939, 41.07231], [-124.1594, 41.07234], [-124.15022, 41.07222], [-124.14963, 41.07124], [-124.14907, 41.07039], [-124.14885, 41.06999], [-124.14812, 41.06878], [-124.14552, 41.06491], [-124.14465, 41.06357], [-124.1446, 41.06354], [-124.14453, 41.06352], [-124.14446, 41.06352], [-124.1444, 41.06355], [-124.14381, 41.06404], [-124.1432, 41.06448], [-124.1431, 41.0645], [-124.14301, 41.06448], [-124.14281, 41.06436], [-124.14276, 41.06431], [-124.14272, 41.0642], [-124.14273, 41.06411], [-124.14287, 41.06386], [-124.14288, 41.06369], [-124.1429, 41.06356], [-124.14303, 41.06326], [-124.14327, 41.06242], [-124.14323, 41.061], [-124.14491, 41.06088], [-124.1468, 41.06098], [-124.14745, 41.06001], [-124.14743, 41.05899], [-124.14767, 41.05898], [-124.14766, 41.05871], [-124.15004, 41.05863], [-124.14989, 41.05881], [-124.14976, 41.05908], [-124.14957, 41.05953], [-124.14922, 41.06007], [-124.14913, 41.06033], [-124.1491, 41.06051], [-124.14908, 41.06079], [-124.14892, 41.06151], [-124.14891, 41.06177], [-124.14906, 41.06233], [-124.14922, 41.06267], [-124.14984, 41.06321], [-124.14995, 41.06333], [-124.1501, 41.06337], [-124.15033, 41.06347], [-124.15066, 41.06365], [-124.15094, 41.06398], [-124.15111, 41.06405], [-124.15115, 41.06409], [-124.1512, 41.06422], [-124.1512, 41.06431], [-124.15106, 41.06442], [-124.15102, 41.06447], [-124.15103, 41.06455], [-124.15106, 41.0646], [-124.15123, 41.06464], [-124.15135, 41.06476], [-124.15141, 41.06486], [-124.1512, 41.0651], [-124.15092, 41.06526], [-124.15078, 41.06548], [-124.15075, 41.06564], [-124.1508, 41.06615], [-124.15104, 41.06664], [-124.1512, 41.06687], [-124.15136, 41.06705], [-124.15167, 41.06732], [-124.15194, 41.0675], [-124.15214, 41.06757], [-124.15246, 41.06774], [-124.15267, 41.06778], [-124.15281, 41.06776], [-124.15391, 41.0681], [-124.15404, 41.06809], [-124.15413, 41.06802], [-124.15418, 41.06788], [-124.15427, 41.06774], [-124.15447, 41.06751], [-124.15444, 41.06739], [-124.15444, 41.06732], [-124.15458, 41.06705], [-124.15474, 41.06702], [-124.1549, 41.06702], [-124.15502, 41.06695], [-124.15568, 41.06673], [-124.15587, 41.06663], [-124.15609, 41.06663], [-124.15625, 41.06671], [-124.15658, 41.06699], [-124.15667, 41.06701], [-124.15674, 41.06707], [-124.15672, 41.06715], [-124.15663, 41.06726], [-124.15653, 41.06734], [-124.15627, 41.06741], [-124.15639, 41.06757], [-124.15653, 41.06759], [-124.1567, 41.06765], [-124.15694, 41.06778], [-124.15702, 41.06796], [-124.15717, 41.06796], [-124.15735, 41.0678], [-124.1575, 41.0678], [-124.15769, 41.06785], [-124.15783, 41.06784], [-124.15802, 41.06787], [-124.15821, 41.06795], [-124.15835, 41.06804], [-124.15844, 41.06819], [-124.15844, 41.06832], [-124.15847, 41.06854], [-124.15854, 41.06884], [-124.15887, 41.06903], [-124.1591, 41.06904], [-124.1593, 41.06927], [-124.15943, 41.06937], [-124.15946, 41.06946]]]} | Open Access 1 | Trinidad State Beach | http://www.parks.ca.gov/default.asp?page_id=418 | 1775 | 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 | 203.902 | Trinidad SB | 1937 |
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]);