units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

2 rows where UNIT_NAME = "Bothe-Napa Valley State Park"

This data as json, copyable, CSV (advanced)

These facets timed out: ACCESS_TYP, MNG_AGENCY

MNG_AG_TYP 1

DES_TP 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
3233 3233 3232 {"type": "Polygon", "coordinates": [[[-122.58686, 38.52798], [-122.58674, 38.53155], [-122.57743, 38.53163], [-122.57737, 38.53525], [-122.57147, 38.53526], [-122.57108, 38.53501], [-122.57084, 38.53477], [-122.57076, 38.53365], [-122.5706, 38.53352], [-122.57019, 38.53338], [-122.57004, 38.53329], [-122.56976, 38.53299], [-122.56974, 38.53273], [-122.56992, 38.53244], [-122.57014, 38.53214], [-122.57012, 38.53163], [-122.56996, 38.53111], [-122.56996, 38.53002], [-122.5696, 38.52958], [-122.56927, 38.52935], [-122.56905, 38.52902], [-122.56872, 38.52877], [-122.56826, 38.52863], [-122.56756, 38.52852], [-122.56695, 38.52851], [-122.56674, 38.52842], [-122.5666, 38.52827], [-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.57881, 38.52874], [-122.57891, 38.52878], [-122.57893, 38.52882], [-122.57898, 38.52884], [-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.58027, 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.52982], [-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.5301], [-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]]]} Open Access 1 23019 Bothe-Napa Valley State Park 1446 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=477 Sonoma 16 196.527 Bothe-Napa Valley SP 1960 State Park 15 4
16530 16530 16529 {"type": "MultiPolygon", "coordinates": [[[[-122.50861, 38.54191], [-122.50773, 38.54206], [-122.50754, 38.54111], [-122.50843, 38.54101], [-122.50861, 38.54191]]], [[[-122.57127, 38.53514], [-122.57127, 38.53518], [-122.56449, 38.53511], [-122.56457, 38.53863], [-122.56428, 38.54219], [-122.55966, 38.54216], [-122.55976, 38.54093], [-122.55963, 38.54215], [-122.55047, 38.54186], [-122.55018, 38.54545], [-122.54591, 38.54531], [-122.54565, 38.54892], [-122.54568, 38.5501], [-122.54074, 38.54876], [-122.53631, 38.54875], [-122.5319, 38.54871], [-122.53179, 38.55234], [-122.53009, 38.55233], [-122.52904, 38.55231], [-122.52854, 38.55228], [-122.5271, 38.55228], [-122.52627, 38.55226], [-122.52575, 38.55331], [-122.52521, 38.5532], [-122.52466, 38.55313], [-122.52386, 38.55309], [-122.52372, 38.55295], [-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.514, 38.54701], [-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.54147], [-122.51301, 38.54141], [-122.51222, 38.54146], [-122.51149, 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.5096, 38.54146], [-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.54022], [-122.51011, 38.54019], [-122.51057, 38.53988], [-122.5111, 38.53963], [-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.53692], [-122.51327, 38.53646], [-122.51305, 38.53616], [-122.51417, 38.53539], [-122.5146, 38.53485], [-122.51557, 38.53426], [-122.51556, 38.53345], [-122.51664, 38.53343], [-122.51657, 38.53135], [-122.50938, 38.53138], [-122.50937, 38.53097], [-122.51733, 38.53094], [-122.51734, 38.53126], [-122.52056, 38.53126], [-122.52064, 38.5306], [-122.52313, 38.53053], [-122.52314, 38.5309], [-122.53402, 38.53088], [-122.53405, 38.529], [-122.54146, 38.52939], [-122.54148, 38.53441], [-122.53154, 38.5344], [-122.53153, 38.53415], [-122.52797, 38.53418], [-122.52796, 38.53439], [-122.52458, 38.5344], [-122.52452, 38.53455], [-122.5231, 38.53455], [-122.52309, 38.53466], [-122.5225, 38.5348], [-122.52197, 38.53556], [-122.52204, 38.53601], [-122.52232, 38.53633], [-122.52291, 38.53751], [-122.52265, 38.5377], [-122.52266, 38.53792], [-122.52305, 38.53792], [-122.52304, 38.54144], [-122.53214, 38.54152], [-122.53228, 38.53793], [-122.54152, 38.53795], [-122.54148, 38.53853], [-122.54149, 38.53854], [-122.55519, 38.53847], [-122.55517, 38.53502], [-122.55988, 38.53499], [-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.5666, 38.52827], [-122.56675, 38.52842], [-122.56695, 38.52851], [-122.56756, 38.52852], [-122.56826, 38.52863], [-122.56872, 38.52877], [-122.56905, 38.52902], [-122.56927, 38.52935], [-122.5696, 38.52958], [-122.56996, 38.53003], [-122.56996, 38.53111], [-122.57012, 38.53163], [-122.57014, 38.53214], [-122.56992, 38.53244], [-122.56974, 38.53273], [-122.56976, 38.53299], [-122.57004, 38.53329], [-122.57019, 38.53338], [-122.5706, 38.53352], [-122.57076, 38.53365], [-122.57084, 38.53477], [-122.57108, 38.53501], [-122.57127, 38.53514]]]]} Open Access 1 1853 Bothe-Napa Valley State Park 1446 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=477 Napa 11 1688.482 Bothe-Napa Valley SP 1960 State Park 15 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);