units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 47, MNG_AG_TYP = 5 and SUID_NMA = 1552
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 1 ✖
MNG_AGENCY 1
- California Department of Parks and Recreation · 1 ✖
DES_TP 1
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16584 | 16584 | 16583 | {"type": "MultiPolygon", "coordinates": [[[[-123.9138, 40.48108], [-123.91359, 40.48118], [-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.48683], [-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.48098], [-123.9138, 40.48108]]], [[[-123.95668, 40.47595], [-123.95668, 40.4767], [-123.95498, 40.47797], [-123.95403, 40.47838], [-123.95399, 40.47835], [-123.95363, 40.47857], [-123.95342, 40.47874], [-123.95257, 40.47953], [-123.95254, 40.47952], [-123.95236, 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.47864], [-123.95105, 40.47844], [-123.95098, 40.47824], [-123.95087, 40.47805], [-123.95082, 40.47798], [-123.95075, 40.478], [-123.95051, 40.47778], [-123.95024, 40.47759], [-123.94987, 40.47727], [-123.95083, 40.47725], [-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.4796], [-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.95669, 40.48479], [-123.95618, 40.48441], [-123.95575, 40.48372], [-123.95569, 40.4831], [-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.4808], [-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 | 20479 | Grizzly Creek Redwoods State Park | 1552 | 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=421 | Humboldt 45 | 446.393 | Grizzly Creek Redwoods SP | 1943 | 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]);