superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 25 and PARK_NAME = "Bear River Fishing Access"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14549 | 14549 | 14548 | {"type": "Polygon", "coordinates": [[[-121.00139, 39.06934], [-120.99874, 39.069], [-120.99789, 39.0695], [-120.99789, 39.06953], [-120.999, 39.07047], [-120.99886, 39.07205], [-120.99861, 39.07295], [-120.99796, 39.0731], [-120.99607, 39.0738], [-120.99433, 39.07435], [-120.99373, 39.0745], [-120.99325, 39.07469], [-120.99326, 39.07569], [-120.99322, 39.07675], [-120.99435, 39.07741], [-120.99498, 39.07788], [-120.9959, 39.07848], [-120.99739, 39.07957], [-120.99723, 39.0813], [-120.99661, 39.08206], [-120.9963, 39.08237], [-120.99442, 39.08236], [-120.99343, 39.08238], [-120.99246, 39.0823], [-120.99231, 39.08231], [-120.99208, 39.08257], [-120.99044, 39.0847], [-120.98935, 39.08652], [-120.98869, 39.08647], [-120.98869, 39.08655], [-120.98862, 39.08703], [-120.98855, 39.0873], [-120.98845, 39.08793], [-120.98843, 39.08826], [-120.9885, 39.08873], [-120.9885, 39.08893], [-120.98842, 39.08946], [-120.98829, 39.08984], [-120.98807, 39.09034], [-120.98777, 39.09082], [-120.98758, 39.09124], [-120.98746, 39.0917], [-120.98744, 39.09194], [-120.98753, 39.09229], [-120.98763, 39.09261], [-120.98767, 39.09305], [-120.98764, 39.09386], [-120.98765, 39.09424], [-120.9877, 39.09478], [-120.98769, 39.09523], [-120.9875, 39.09581], [-120.98734, 39.09612], [-120.98718, 39.09657], [-120.98701, 39.09686], [-120.98693, 39.09713], [-120.98595, 39.09711], [-120.98599, 39.09674], [-120.98612, 39.09664], [-120.98632, 39.09614], [-120.98629, 39.09545], [-120.98596, 39.09498], [-120.98503, 39.0942], [-120.98558, 39.09368], [-120.98546, 39.09235], [-120.98657, 39.09107], [-120.98674, 39.09083], [-120.9867, 39.09033], [-120.98695, 39.08997], [-120.98691, 39.08986], [-120.9866, 39.08927], [-120.98671, 39.08913], [-120.98676, 39.08867], [-120.98713, 39.08755], [-120.98727, 39.08678], [-120.98727, 39.08653], [-120.98507, 39.08644], [-120.9851, 39.08641], [-120.98519, 39.0857], [-120.98792, 39.08572], [-120.98804, 39.08461], [-120.98534, 39.08446], [-120.98552, 39.08418], [-120.98554, 39.08391], [-120.98553, 39.08389], [-120.98596, 39.08391], [-120.98618, 39.08365], [-120.98626, 39.08324], [-120.98589, 39.08303], [-120.98525, 39.08302], [-120.98405, 39.08281], [-120.98364, 39.08242], [-120.98361, 39.08227], [-120.98482, 39.0823], [-120.98631, 39.08198], [-120.98669, 39.08217], [-120.98741, 39.0821], [-120.98798, 39.08208], [-120.98812, 39.08203], [-120.98858, 39.08163], [-120.9892, 39.08157], [-120.99035, 39.08116], [-120.99165, 39.08076], [-120.99174, 39.08068], [-120.99173, 39.08048], [-120.99121, 39.08021], [-120.99107, 39.0799], [-120.99046, 39.07976], [-120.99046, 39.07954], [-120.99108, 39.07911], [-120.99089, 39.07826], [-120.99068, 39.07809], [-120.99046, 39.07809], [-120.99002, 39.07837], [-120.98978, 39.07857], [-120.98899, 39.07846], [-120.98851, 39.078], [-120.98798, 39.07804], [-120.98799, 39.07753], [-120.98813, 39.0775], [-120.98861, 39.07731], [-120.98907, 39.07721], [-120.9893, 39.07706], [-120.98955, 39.07696], [-120.98991, 39.0767], [-120.99015, 39.07635], [-120.99047, 39.07543], [-120.99047, 39.07503], [-120.99045, 39.0749], [-120.99083, 39.07446], [-120.99109, 39.07398], [-120.99131, 39.0739], [-120.9926, 39.07315], [-120.99373, 39.07267], [-120.99362, 39.07229], [-120.99347, 39.07218], [-120.99296, 39.0721], [-120.99253, 39.07211], [-120.9922, 39.07202], [-120.99207, 39.07186], [-120.99213, 39.07158], [-120.99196, 39.07135], [-120.99185, 39.0709], [-120.99161, 39.07074], [-120.99178, 39.07028], [-120.99209, 39.07027], [-120.99237, 39.07012], [-120.99289, 39.07067], [-120.99332, 39.07063], [-120.99403, 39.07028], [-120.99412, 39.07004], [-120.99342, 39.06931], [-120.99361, 39.06918], [-120.99384, 39.06887], [-120.99374, 39.0683], [-120.99662, 39.06833], [-120.99664, 39.06835], [-120.99671, 39.06834], [-120.99682, 39.06823], [-120.99699, 39.06815], [-121.00137, 39.0689], [-121.00139, 39.06934]]]} | Open Access 1 | Bear River Fishing Access | 32044 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 270.049 | Bear River FA |
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]);