superunits_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 PARK_NAME = "Bothe-Napa Valley State Park"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 1 ✖
MNG_AGENCY 1
- California Department of Parks and Recreation · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
97 | 97 | 96 | {"type": "MultiPolygon", "coordinates": [[[[-122.58686, 38.52798], [-122.58674, 38.53155], [-122.57743, 38.53163], [-122.57737, 38.53524], [-122.57147, 38.53526], [-122.57128, 38.53514], [-122.57127, 38.53518], [-122.5645, 38.53511], [-122.56457, 38.53863], [-122.56428, 38.54219], [-122.55966, 38.54216], [-122.55969, 38.54171], [-122.55963, 38.54215], [-122.55047, 38.54187], [-122.55018, 38.54545], [-122.54591, 38.54532], [-122.54565, 38.54892], [-122.54568, 38.5501], [-122.54074, 38.54876], [-122.53631, 38.54875], [-122.53191, 38.54871], [-122.53179, 38.55234], [-122.53009, 38.55233], [-122.52904, 38.55231], [-122.52854, 38.55228], [-122.5271, 38.55228], [-122.52628, 38.55226], [-122.52575, 38.55331], [-122.52521, 38.5532], [-122.52466, 38.55313], [-122.52386, 38.55309], [-122.52372, 38.55296], [-122.52361, 38.55311], [-122.5231, 38.55313], [-122.52223, 38.55308], [-122.52216, 38.55288], [-122.52183, 38.55305], [-122.5214, 38.55297], [-122.52104, 38.55287], [-122.52101, 38.55289], [-122.51997, 38.5525], [-122.5169, 38.55158], [-122.51647, 38.55141], [-122.51628, 38.55131], [-122.51588, 38.55107], [-122.51536, 38.55068], [-122.51307, 38.54906], [-122.51213, 38.54833], [-122.51399, 38.54702], [-122.51307, 38.54638], [-122.51213, 38.54708], [-122.51194, 38.54698], [-122.51112, 38.54759], [-122.51081, 38.54726], [-122.51059, 38.54697], [-122.51368, 38.54555], [-122.51377, 38.54295], [-122.51375, 38.54148], [-122.51301, 38.54141], [-122.51222, 38.54146], [-122.5115, 38.54147], [-122.51085, 38.54168], [-122.50994, 38.54164], [-122.50973, 38.54191], [-122.50914, 38.5424], [-122.50904, 38.54242], [-122.50894, 38.54153], [-122.50959, 38.54147], [-122.50959, 38.54145], [-122.50951, 38.54126], [-122.50988, 38.54123], [-122.50989, 38.54122], [-122.50983, 38.54111], [-122.50948, 38.54101], [-122.50918, 38.54103], [-122.5088, 38.54108], [-122.50874, 38.54096], [-122.50913, 38.54096], [-122.50949, 38.54095], [-122.50975, 38.541], [-122.50999, 38.54101], [-122.51015, 38.54037], [-122.51016, 38.54023], [-122.51011, 38.54019], [-122.51057, 38.53988], [-122.5111, 38.53962], [-122.51093, 38.53933], [-122.51045, 38.53908], [-122.5101, 38.53883], [-122.50814, 38.53926], [-122.50798, 38.53888], [-122.5075, 38.53758], [-122.50738, 38.53731], [-122.50725, 38.53697], [-122.50751, 38.537], [-122.50766, 38.53709], [-122.50812, 38.53716], [-122.50862, 38.53717], [-122.50868, 38.53719], [-122.50938, 38.53766], [-122.50995, 38.53757], [-122.51021, 38.53745], [-122.51082, 38.53713], [-122.51048, 38.53664], [-122.51219, 38.53636], [-122.51262, 38.53678], [-122.51271, 38.53691], [-122.51326, 38.53646], [-122.51305, 38.53616], [-122.51416, 38.53539], [-122.5146, 38.53485], [-122.51557, 38.53426], [-122.51556, 38.53345], [-122.51664, 38.53342], [-122.51657, 38.53135], [-122.50938, 38.53138], [-122.50937, 38.53097], [-122.51733, 38.53094], [-122.51735, 38.53126], [-122.52055, 38.53126], [-122.52064, 38.5306], [-122.52313, 38.53053], [-122.52315, 38.5309], [-122.53401, 38.53088], [-122.53405, 38.529], [-122.54146, 38.52939], [-122.54148, 38.53441], [-122.53154, 38.5344], [-122.53152, 38.53415], [-122.52798, 38.53418], [-122.52796, 38.53439], [-122.52459, 38.5344], [-122.52452, 38.53455], [-122.52311, 38.53455], [-122.52309, 38.53466], [-122.5225, 38.5348], [-122.52197, 38.53555], [-122.52204, 38.53601], [-122.52232, 38.53633], [-122.52291, 38.53751], [-122.52265, 38.5377], [-122.52266, 38.53791], [-122.52305, 38.53792], [-122.52305, 38.54143], [-122.53214, 38.54152], [-122.53228, 38.53793], [-122.54151, 38.53795], [-122.54148, 38.53852], [-122.54149, 38.53854], [-122.55519, 38.53847], [-122.55517, 38.53502], [-122.55988, 38.53498], [-122.5598, 38.5315], [-122.55983, 38.53139], [-122.56441, 38.53156], [-122.56434, 38.52802], [-122.56654, 38.52804], [-122.56654, 38.52807], [-122.56657, 38.52815], [-122.57748, 38.52806], [-122.57748, 38.52812], [-122.57785, 38.52828], [-122.57793, 38.52827], [-122.57799, 38.52818], [-122.57816, 38.52829], [-122.57824, 38.52832], [-122.57843, 38.52831], [-122.57857, 38.52834], [-122.57865, 38.52833], [-122.57873, 38.5284], [-122.57872, 38.52857], [-122.57875, 38.52864], [-122.5788, 38.52868], [-122.57882, 38.52873], [-122.57891, 38.52878], [-122.57893, 38.52882], [-122.57909, 38.52893], [-122.57923, 38.529], [-122.57941, 38.529], [-122.57948, 38.52906], [-122.57953, 38.52906], [-122.57959, 38.52912], [-122.57989, 38.52924], [-122.57997, 38.52932], [-122.58004, 38.52932], [-122.58007, 38.52938], [-122.58017, 38.52936], [-122.58027, 38.52937], [-122.58031, 38.52941], [-122.58028, 38.52947], [-122.58028, 38.52952], [-122.58032, 38.52953], [-122.58037, 38.52973], [-122.58041, 38.52977], [-122.58049, 38.52977], [-122.58054, 38.52981], [-122.58065, 38.52974], [-122.58078, 38.52969], [-122.58084, 38.5297], [-122.58104, 38.52982], [-122.58122, 38.52988], [-122.58123, 38.52999], [-122.58121, 38.53005], [-122.58117, 38.53009], [-122.58118, 38.53013], [-122.58138, 38.53026], [-122.58145, 38.53024], [-122.58171, 38.53005], [-122.58187, 38.53002], [-122.58196, 38.53007], [-122.58212, 38.53003], [-122.58217, 38.52801], [-122.58686, 38.52798]]], [[[-122.50861, 38.54191], [-122.50773, 38.54206], [-122.50754, 38.54111], [-122.50843, 38.54101], [-122.50861, 38.54191]]]]} | Open Access 1 | Bothe-Napa Valley State Park | http://www.parks.ca.gov/?page_id=477 | 1446 | 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 | 1885.54 | Bothe-Napa Valley SP | 1960 |
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]);