superunits_with_maps

Table actions

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

1 row where MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=466"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 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
101 101 100 {"type": "Polygon", "coordinates": [[[-122.50503, 38.00419], [-122.50193, 38.00711], [-122.5018, 38.00732], [-122.50174, 38.0076], [-122.50162, 38.00778], [-122.50138, 38.00802], [-122.50097, 38.00835], [-122.5006, 38.00851], [-122.50043, 38.00867], [-122.50031, 38.00891], [-122.50009, 38.00918], [-122.49957, 38.00951], [-122.49953, 38.00983], [-122.49891, 38.01051], [-122.49846, 38.01098], [-122.49819, 38.01149], [-122.49735, 38.01358], [-122.49261, 38.01094], [-122.48933, 38.01234], [-122.4895, 38.0131], [-122.48923, 38.01368], [-122.48847, 38.01316], [-122.48831, 38.01285], [-122.48796, 38.01262], [-122.48688, 38.0108], [-122.48589, 38.00918], [-122.48415, 38.00777], [-122.48287, 38.00766], [-122.48259, 38.00772], [-122.48234, 38.00767], [-122.48215, 38.00768], [-122.48203, 38.00772], [-122.48188, 38.00774], [-122.48172, 38.0077], [-122.48162, 38.00765], [-122.4815, 38.00754], [-122.48135, 38.00724], [-122.48081, 38.00667], [-122.48038, 38.00636], [-122.48005, 38.00605], [-122.47958, 38.00571], [-122.47893, 38.0055], [-122.47893, 38.01029], [-122.47026, 38.00743], [-122.46201, 38.00453], [-122.45356, 37.99846], [-122.45583, 37.9972], [-122.45647, 37.99687], [-122.45921, 37.99732], [-122.46526, 38.00042], [-122.46667, 38.00066], [-122.46668, 38.00065], [-122.46665, 37.99943], [-122.46668, 37.99858], [-122.46897, 37.99864], [-122.46897, 38.00001], [-122.47158, 38.00009], [-122.47203, 37.9992], [-122.4763, 37.99977], [-122.47657, 37.9952], [-122.47582, 37.99406], [-122.47601, 37.99396], [-122.47618, 37.99389], [-122.47659, 37.99382], [-122.47676, 37.99378], [-122.47695, 37.99371], [-122.47716, 37.99358], [-122.47719, 37.99353], [-122.47695, 37.99329], [-122.47701, 37.99325], [-122.47731, 37.9935], [-122.4774, 37.9935], [-122.4776, 37.9937], [-122.47768, 37.99386], [-122.47767, 37.99403], [-122.47757, 37.9943], [-122.47756, 37.99448], [-122.4776, 37.99467], [-122.47771, 37.99489], [-122.47781, 37.99496], [-122.4779, 37.99494], [-122.47812, 37.99476], [-122.4782, 37.99483], [-122.47796, 37.99505], [-122.47796, 37.9951], [-122.47799, 37.99514], [-122.47809, 37.9952], [-122.47836, 37.99531], [-122.47846, 37.9954], [-122.47871, 37.99574], [-122.47876, 37.99578], [-122.47887, 37.9958], [-122.47919, 37.9957], [-122.47927, 37.99581], [-122.47903, 37.99595], [-122.47899, 37.99599], [-122.47898, 37.99604], [-122.47898, 37.99608], [-122.4791, 37.99631], [-122.47917, 37.99649], [-122.47919, 37.99665], [-122.47919, 37.99693], [-122.48022, 37.99696], [-122.48023, 37.99658], [-122.4802, 37.99635], [-122.4808, 37.99634], [-122.48124, 37.99616], [-122.48169, 37.99632], [-122.48201, 37.99599], [-122.48194, 37.99593], [-122.48246, 37.9954], [-122.48319, 37.99591], [-122.48339, 37.99591], [-122.48339, 37.99239], [-122.48487, 37.99126], [-122.48657, 37.99003], [-122.48883, 37.99143], [-122.4909, 37.98937], [-122.48847, 37.98609], [-122.48412, 37.98559], [-122.48036, 37.98519], [-122.48, 37.98505], [-122.47956, 37.98484], [-122.47957, 37.98473], [-122.48009, 37.98378], [-122.48201, 37.98442], [-122.48271, 37.98413], [-122.4831, 37.98399], [-122.48341, 37.98396], [-122.4839, 37.98406], [-122.4846, 37.98425], [-122.48531, 37.98405], [-122.48577, 37.98406], [-122.48599, 37.98428], [-122.48612, 37.98434], [-122.48627, 37.98434], [-122.48655, 37.98418], [-122.48791, 37.9821], [-122.49078, 37.98355], [-122.49221, 37.98499], [-122.49336, 37.98589], [-122.4938, 37.98622], [-122.49418, 37.98664], [-122.49487, 37.98707], [-122.49521, 37.98721], [-122.49548, 37.99682], [-122.4955, 37.99683], [-122.49595, 37.99646], [-122.49628, 37.99597], [-122.49717, 37.99601], [-122.4982, 37.99593], [-122.4994, 37.99562], [-122.4999, 37.99511], [-122.50008, 37.99533], [-122.50006, 37.99568], [-122.49997, 37.9959], [-122.50016, 37.99643], [-122.50005, 37.99685], [-122.50032, 37.9969], [-122.50063, 37.99685], [-122.50134, 37.99683], [-122.50179, 37.99746], [-122.50148, 37.99774], [-122.50213, 37.9986], [-122.50297, 37.99854], [-122.50313, 37.99833], [-122.5041, 37.99849], [-122.50503, 38.00419]], [[-122.46204, 38.00437], [-122.46208, 38.00429], [-122.46206, 38.00426], [-122.462, 38.00424], [-122.46196, 38.00427], [-122.46192, 38.00434], [-122.46195, 38.00446], [-122.46202, 38.00451], [-122.46205, 38.00443], [-122.46204, 38.00437]]]} Open Access 1 China Camp State Park http://www.parks.ca.gov/?page_id=466 1475 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 1524.649 China Camp SP 1976

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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