superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_NAME = "Yolo Bypass Wildlife Area"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15388 | 15388 | 15387 | {"type": "MultiPolygon", "coordinates": [[[[-121.68733, 38.43041], [-121.67516, 38.44394], [-121.67508, 38.45192], [-121.67494, 38.45194], [-121.67482, 38.45924], [-121.66369, 38.45925], [-121.65679, 38.45924], [-121.65684, 38.4665], [-121.63838, 38.46658], [-121.6384, 38.46945], [-121.63846, 38.46946], [-121.63852, 38.4737], [-121.6395, 38.48091], [-121.63987, 38.48399], [-121.63988, 38.484], [-121.63995, 38.48397], [-121.63998, 38.4841], [-121.63989, 38.48415], [-121.64015, 38.48699], [-121.6304, 38.48691], [-121.63018, 38.49449], [-121.6207, 38.49448], [-121.62063, 38.5013], [-121.62061, 38.50145], [-121.62051, 38.51378], [-121.6207, 38.51379], [-121.62098, 38.51386], [-121.62139, 38.51403], [-121.62169, 38.51413], [-121.62195, 38.51407], [-121.6225, 38.51385], [-121.62282, 38.51377], [-121.62305, 38.51377], [-121.62473, 38.51398], [-121.62526, 38.51407], [-121.62629, 38.51455], [-121.62687, 38.51499], [-121.6271, 38.51515], [-121.6273, 38.51515], [-121.62806, 38.51475], [-121.62884, 38.51465], [-121.62939, 38.51465], [-121.62984, 38.51481], [-121.62985, 38.5152], [-121.63047, 38.51521], [-121.63068, 38.51527], [-121.63088, 38.51518], [-121.63114, 38.51536], [-121.63156, 38.51556], [-121.63195, 38.51577], [-121.63224, 38.51597], [-121.63224, 38.51642], [-121.6313, 38.51642], [-121.63131, 38.51699], [-121.63627, 38.51702], [-121.63884, 38.51712], [-121.63874, 38.52375], [-121.63148, 38.52374], [-121.63131, 38.53803], [-121.63878, 38.53814], [-121.63872, 38.54529], [-121.63102, 38.54516], [-121.631, 38.54517], [-121.63096, 38.5518], [-121.63107, 38.55228], [-121.63116, 38.5524], [-121.63126, 38.55246], [-121.6315, 38.55267], [-121.63753, 38.55919], [-121.63774, 38.55947], [-121.63795, 38.55996], [-121.63803, 38.56022], [-121.63808, 38.56051], [-121.63812, 38.56085], [-121.63814, 38.5613], [-121.63818, 38.56166], [-121.63896, 38.5621], [-121.63847, 38.56303], [-121.63821, 38.56306], [-121.63756, 38.56337], [-121.63743, 38.56337], [-121.62946, 38.56475], [-121.62849, 38.56475], [-121.61981, 38.56629], [-121.61032, 38.56795], [-121.60961, 38.56823], [-121.58284, 38.5729], [-121.58307, 38.55951], [-121.58312, 38.55125], [-121.58357, 38.55024], [-121.58394, 38.54958], [-121.58445, 38.5488], [-121.58471, 38.54844], [-121.58505, 38.54791], [-121.5854, 38.5474], [-121.58548, 38.5473], [-121.58603, 38.54646], [-121.58618, 38.54614], [-121.58629, 38.54598], [-121.58656, 38.54552], [-121.58681, 38.54514], [-121.58686, 38.54502], [-121.58722, 38.54443], [-121.5876, 38.54368], [-121.58806, 38.54245], [-121.58826, 38.54197], [-121.58846, 38.5412], [-121.58871, 38.54004], [-121.58886, 38.53925], [-121.58904, 38.53799], [-121.58903, 38.53757], [-121.58905, 38.53543], [-121.58904, 38.5328], [-121.5891, 38.53177], [-121.58911, 38.53017], [-121.58908, 38.52969], [-121.58908, 38.52712], [-121.58915, 38.51613], [-121.58936, 38.51608], [-121.58933, 38.51567], [-121.59316, 38.51545], [-121.59322, 38.50945], [-121.5932, 38.50152], [-121.59319, 38.50151], [-121.59319, 38.50135], [-121.5932, 38.50133], [-121.5932, 38.49779], [-121.5896, 38.49778], [-121.58902, 38.49779], [-121.58894, 38.48687], [-121.58825, 38.47445], [-121.58873, 38.47371], [-121.5886, 38.47145], [-121.58862, 38.47112], [-121.58865, 38.47091], [-121.58982, 38.46852], [-121.59817, 38.45067], [-121.60276, 38.44092], [-121.60335, 38.44092], [-121.60278, 38.4421], [-121.60156, 38.44474], [-121.60157, 38.44476], [-121.61354, 38.4448], [-121.61641, 38.44509], [-121.6384, 38.44603], [-121.63842, 38.44602], [-121.63841, 38.44495], [-121.63838, 38.44494], [-121.63838, 38.4449], [-121.65675, 38.44482], [-121.65678, 38.41581], [-121.67529, 38.41572], [-121.67528, 38.42596], [-121.6753, 38.43029], [-121.68733, 38.43041]]], [[[-121.63913, 38.56515], [-121.63854, 38.56527], [-121.63855, 38.56611], [-121.62925, 38.56778], [-121.60746, 38.5728], [-121.60745, 38.57282], [-121.60751, 38.57304], [-121.6017, 38.57436], [-121.58334, 38.57859], [-121.58294, 38.57378], [-121.60986, 38.56897], [-121.61059, 38.56896], [-121.62854, 38.5658], [-121.62918, 38.56555], [-121.62956, 38.56538], [-121.63752, 38.564], [-121.63834, 38.56392], [-121.6384, 38.56424], [-121.63845, 38.56438], [-121.63855, 38.56458], [-121.63866, 38.56473], [-121.63882, 38.5649], [-121.63913, 38.56515]]], [[[-121.62924, 38.56885], [-121.62921, 38.57495], [-121.62027, 38.57479], [-121.60499, 38.57438], [-121.62001, 38.57089], [-121.62924, 38.56885]]], [[[-121.673, 38.55286], [-121.67291, 38.55632], [-121.6721, 38.55632], [-121.67207, 38.55753], [-121.67149, 38.55766], [-121.67155, 38.55283], [-121.673, 38.55286]]]]} | Open Access 1 | Yolo Bypass Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Yolo-Bypass-WA | 30523 | 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 | 16579.674 | Yolo Bypass Wildlife Area | 1994 |
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]);