superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, LABEL_NAME = "Mokelumne Trail" and MNG_AG_TYP = 13

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Water District · 1 ✖

ACCESS_TYP 1

  • Open Access · 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
7099 7099 7098 {"type": "MultiPolygon", "coordinates": [[[[-121.72319, 37.95393], [-121.72319, 37.95429], [-121.71709, 37.95429], [-121.71684, 37.95402], [-121.72238, 37.95401], [-121.72319, 37.95393]]], [[[-121.74157, 37.95436], [-121.72891, 37.9543], [-121.72334, 37.95429], [-121.72334, 37.95393], [-121.73271, 37.95396], [-121.73358, 37.95405], [-121.74157, 37.95409], [-121.74157, 37.95436]]], [[[-121.75526, 37.95876], [-121.75511, 37.959], [-121.75087, 37.95721], [-121.75086, 37.9569], [-121.75526, 37.95876]]], [[[-121.75973, 37.96095], [-121.75912, 37.96069], [-121.75529, 37.95908], [-121.75546, 37.95884], [-121.75967, 37.96062], [-121.75973, 37.96095]]], [[[-121.78005, 37.96603], [-121.77993, 37.96623], [-121.77859, 37.96572], [-121.76918, 37.96356], [-121.76557, 37.96268], [-121.762, 37.96191], [-121.76189, 37.96186], [-121.76264, 37.96186], [-121.76317, 37.96189], [-121.76341, 37.96191], [-121.76411, 37.96204], [-121.76918, 37.96327], [-121.7779, 37.96525], [-121.77849, 37.96541], [-121.77931, 37.96568], [-121.77999, 37.96595], [-121.78004, 37.96599], [-121.78005, 37.96603]]], [[[-121.78567, 37.96827], [-121.78552, 37.96854], [-121.7852, 37.96829], [-121.78027, 37.96636], [-121.7804, 37.96617], [-121.78044, 37.96615], [-121.78051, 37.96616], [-121.78507, 37.96793], [-121.78541, 37.96805], [-121.78567, 37.96827]]], [[[-121.78823, 37.97022], [-121.78813, 37.97034], [-121.78807, 37.97047], [-121.7857, 37.96867], [-121.78585, 37.96841], [-121.78823, 37.97022]]], [[[-121.79282, 37.9737], [-121.79258, 37.9739], [-121.78823, 37.97059], [-121.78825, 37.97052], [-121.78833, 37.97038], [-121.78838, 37.97032], [-121.79282, 37.9737]]], [[[-121.80043, 37.97808], [-121.80022, 37.97834], [-121.79905, 37.97671], [-121.79894, 37.97665], [-121.79732, 37.9758], [-121.7968, 37.9758], [-121.79679, 37.97553], [-121.79568, 37.97495], [-121.79374, 37.97477], [-121.79273, 37.97401], [-121.79297, 37.97381], [-121.7939, 37.97451], [-121.7958, 37.97468], [-121.79931, 37.97651], [-121.80043, 37.97808]]], [[[-121.80353, 37.98089], [-121.8035, 37.98091], [-121.80316, 37.98092], [-121.80119, 37.97969], [-121.80034, 37.9785], [-121.80055, 37.97824], [-121.80146, 37.9795], [-121.80353, 37.98079], [-121.80353, 37.98089]]], [[[-121.80543, 37.98233], [-121.80391, 37.98138], [-121.80352, 37.98114], [-121.80408, 37.98113], [-121.80541, 37.98196], [-121.80543, 37.98233]]], [[[-121.80773, 37.98341], [-121.80759, 37.98349], [-121.80747, 37.9836], [-121.80586, 37.9826], [-121.80584, 37.9826], [-121.80581, 37.98223], [-121.80773, 37.98341]]], [[[-121.81051, 37.98513], [-121.81029, 37.98535], [-121.80763, 37.9837], [-121.80776, 37.9836], [-121.80791, 37.98352], [-121.81051, 37.98513]]], [[[-121.81741, 37.98943], [-121.8173, 37.98953], [-121.81715, 37.98962], [-121.81043, 37.98544], [-121.81064, 37.98522], [-121.81741, 37.98943]]], [[[-121.82223, 37.99262], [-121.82219, 37.99266], [-121.82205, 37.99268], [-121.81732, 37.98973], [-121.81745, 37.98965], [-121.81757, 37.98953], [-121.82222, 37.99242], [-121.82223, 37.99262]]], [[[-121.82676, 37.99526], [-121.82655, 37.99547], [-121.82263, 37.99303], [-121.82258, 37.99281], [-121.82264, 37.99277], [-121.82275, 37.99276], [-121.82676, 37.99526]]], [[[-121.83178, 37.99794], [-121.83051, 37.99794], [-121.82671, 37.99557], [-121.82692, 37.99536], [-121.83063, 37.99767], [-121.83167, 37.99767], [-121.83173, 37.99779], [-121.83178, 37.99794]]], [[[-121.83458, 37.99767], [-121.83457, 37.99795], [-121.83199, 37.99794], [-121.83195, 37.99779], [-121.8319, 37.99767], [-121.83458, 37.99767]]], [[[-121.83789, 37.99768], [-121.83789, 37.99795], [-121.83479, 37.99795], [-121.83479, 37.99767], [-121.83789, 37.99768]]], [[[-121.84196, 37.99803], [-121.84136, 37.99817], [-121.84044, 37.99795], [-121.83811, 37.99795], [-121.8381, 37.99768], [-121.84051, 37.99768], [-121.84196, 37.99803]]], [[[-121.84351, 37.9984], [-121.84325, 37.99862], [-121.84188, 37.99829], [-121.84266, 37.99819], [-121.84351, 37.9984]]]]} Open Access 1 Mokelumne Trail   22359 2031 East Bay Municipal Utility District 427 Special District 4 Water District 13 http://www.ebmud.com/ Special District 4 86.253 Mokelumne Trail  

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