superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and YR_EST = 1943
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
81 | 81 | 80 | {"type": "Polygon", "coordinates": [[[-124.08242, 40.91964], [-124.08176, 40.91965], [-124.07689, 40.91964], [-124.07679, 40.91709], [-124.07901, 40.91719], [-124.079, 40.91686], [-124.07903, 40.91671], [-124.07915, 40.91655], [-124.07941, 40.9163], [-124.07967, 40.91593], [-124.07971, 40.91594], [-124.07948, 40.9163], [-124.07956, 40.91628], [-124.07984, 40.91636], [-124.08013, 40.9164], [-124.07995, 40.91671], [-124.07996, 40.91673], [-124.08053, 40.91687], [-124.08055, 40.91686], [-124.0817, 40.91715], [-124.08172, 40.91714], [-124.08171, 40.91657], [-124.08231, 40.91674], [-124.08242, 40.91964]]]} | Open Access 1 | Azalea State Natural Reserve | http://www.parks.ca.gov/?page_id=420 | 1424 | 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 | 35.286 | Azalea SNR | 1943 |
15236 | 15236 | 15235 | {"type": "MultiPolygon", "coordinates": [[[[-123.9138, 40.48108], [-123.91359, 40.48119], [-123.91354, 40.48627], [-123.90839, 40.48823], [-123.90411, 40.48912], [-123.90148, 40.48872], [-123.89984, 40.48755], [-123.89867, 40.48724], [-123.89864, 40.48684], [-123.89852, 40.48683], [-123.89845, 40.48526], [-123.89847, 40.48381], [-123.89851, 40.48202], [-123.90601, 40.4821], [-123.91123, 40.47871], [-123.91366, 40.47867], [-123.91359, 40.48097], [-123.9138, 40.48108]]], [[[-123.95668, 40.47595], [-123.95668, 40.4767], [-123.95498, 40.47797], [-123.95403, 40.47838], [-123.95399, 40.47836], [-123.95364, 40.47857], [-123.95342, 40.47874], [-123.95257, 40.47953], [-123.95254, 40.47952], [-123.95235, 40.47965], [-123.95212, 40.47973], [-123.95186, 40.47974], [-123.95162, 40.4797], [-123.9516, 40.47972], [-123.95136, 40.47961], [-123.95126, 40.47954], [-123.95118, 40.47945], [-123.95112, 40.47935], [-123.95108, 40.47925], [-123.95106, 40.47914], [-123.95107, 40.47865], [-123.95105, 40.47844], [-123.95098, 40.47824], [-123.95087, 40.47805], [-123.95082, 40.47798], [-123.95075, 40.478], [-123.95052, 40.47778], [-123.95024, 40.47758], [-123.94987, 40.47727], [-123.95083, 40.47724], [-123.95072, 40.47667], [-123.95066, 40.47608], [-123.95668, 40.47595]]], [[[-123.95118, 40.47979], [-123.95063, 40.4798], [-123.95063, 40.47891], [-123.95066, 40.4789], [-123.95083, 40.47946], [-123.95091, 40.47959], [-123.95095, 40.47959], [-123.95106, 40.4797], [-123.95118, 40.47979]]], [[[-123.96938, 40.48018], [-123.96882, 40.48007], [-123.96756, 40.48013], [-123.96716, 40.48028], [-123.96672, 40.48039], [-123.96558, 40.48115], [-123.9645, 40.48241], [-123.96367, 40.48351], [-123.96274, 40.48469], [-123.96189, 40.48513], [-123.96037, 40.48527], [-123.95783, 40.48539], [-123.9567, 40.48479], [-123.95618, 40.48441], [-123.95575, 40.48372], [-123.95569, 40.48311], [-123.95564, 40.48309], [-123.95565, 40.48276], [-123.95573, 40.48248], [-123.9557, 40.48234], [-123.95571, 40.48228], [-123.95581, 40.48199], [-123.9559, 40.48186], [-123.95604, 40.48152], [-123.95616, 40.48138], [-123.95619, 40.48122], [-123.95623, 40.48111], [-123.95637, 40.48091], [-123.95639, 40.48079], [-123.95644, 40.48069], [-123.95654, 40.48047], [-123.95666, 40.4803], [-123.95666, 40.47995], [-123.95764, 40.47896], [-123.96067, 40.47662], [-123.96157, 40.47625], [-123.96182, 40.47601], [-123.96712, 40.47896], [-123.96938, 40.48018]]]]} | Open Access 1 | Grizzly Creek Redwoods State Park | http://www.parks.ca.gov/?page_id=421 | 1552 | 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 | 446.406 | Grizzly Creek Redwoods SP | 1943 |
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]);