units_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 = "Pardee Reservoir" 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 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
13155 13155 13154 {"type": "MultiPolygon", "coordinates": [[[[-120.86291, 38.27615], [-120.86285, 38.27627], [-120.86285, 38.27637], [-120.8629, 38.27656], [-120.86289, 38.27663], [-120.86287, 38.27665], [-120.86237, 38.27673], [-120.86199, 38.27686], [-120.86191, 38.27685], [-120.86186, 38.27682], [-120.86172, 38.27668], [-120.86165, 38.27665], [-120.86121, 38.2767], [-120.86101, 38.2767], [-120.86089, 38.27665], [-120.86072, 38.27651], [-120.86067, 38.27642], [-120.8607, 38.27631], [-120.86078, 38.27621], [-120.86081, 38.27607], [-120.8608, 38.27595], [-120.86078, 38.27588], [-120.86073, 38.27582], [-120.86062, 38.27579], [-120.86008, 38.27577], [-120.86002, 38.27575], [-120.85993, 38.27567], [-120.85987, 38.27553], [-120.85987, 38.27546], [-120.8599, 38.27543], [-120.85999, 38.27542], [-120.86023, 38.27543], [-120.86032, 38.2754], [-120.86037, 38.2753], [-120.86035, 38.2752], [-120.8603, 38.27512], [-120.86009, 38.27494], [-120.85974, 38.27474], [-120.85972, 38.2747], [-120.85974, 38.27466], [-120.85995, 38.27457], [-120.86004, 38.27458], [-120.86034, 38.27457], [-120.86047, 38.27461], [-120.86083, 38.27489], [-120.86093, 38.27504], [-120.86099, 38.27511], [-120.86114, 38.27521], [-120.8612, 38.27531], [-120.86119, 38.27538], [-120.86114, 38.27545], [-120.86113, 38.2755], [-120.86115, 38.27555], [-120.86149, 38.27567], [-120.86158, 38.27581], [-120.86189, 38.27582], [-120.86214, 38.27591], [-120.86225, 38.27589], [-120.86247, 38.27578], [-120.8626, 38.27577], [-120.86277, 38.27588], [-120.86289, 38.27606], [-120.86291, 38.27615]]], [[[-120.87015, 38.27732], [-120.87019, 38.27742], [-120.87023, 38.27759], [-120.87025, 38.27792], [-120.87025, 38.2781], [-120.87016, 38.27864], [-120.86994, 38.2802], [-120.86992, 38.2807], [-120.86889, 38.28072], [-120.86882, 38.2813], [-120.86954, 38.28257], [-120.87016, 38.28429], [-120.87041, 38.28562], [-120.87012, 38.2871], [-120.86965, 38.28856], [-120.86912, 38.28875], [-120.86877, 38.28872], [-120.86787, 38.28917], [-120.86713, 38.28928], [-120.86707, 38.28923], [-120.86688, 38.28914], [-120.86684, 38.28909], [-120.86682, 38.28902], [-120.86676, 38.28893], [-120.86669, 38.28888], [-120.86654, 38.28884], [-120.86653, 38.28881], [-120.86653, 38.28842], [-120.86651, 38.28828], [-120.86652, 38.2882], [-120.86665, 38.28795], [-120.86672, 38.28789], [-120.86691, 38.28781], [-120.86705, 38.28777], [-120.86714, 38.28776], [-120.86722, 38.28779], [-120.86726, 38.28796], [-120.86725, 38.28808], [-120.86721, 38.28821], [-120.86716, 38.28831], [-120.86715, 38.28846], [-120.86718, 38.28857], [-120.86724, 38.28862], [-120.8676, 38.28863], [-120.86772, 38.28861], [-120.86779, 38.28853], [-120.86784, 38.28841], [-120.86794, 38.28826], [-120.8682, 38.28806], [-120.86828, 38.28806], [-120.86831, 38.28808], [-120.86835, 38.28821], [-120.86838, 38.28823], [-120.86852, 38.28824], [-120.86855, 38.28827], [-120.86861, 38.2884], [-120.86886, 38.28858], [-120.86893, 38.28859], [-120.86931, 38.28859], [-120.86943, 38.28856], [-120.86945, 38.28852], [-120.86944, 38.28837], [-120.86935, 38.28769], [-120.86917, 38.28755], [-120.86912, 38.28745], [-120.86913, 38.2874], [-120.86923, 38.28729], [-120.86923, 38.28727], [-120.8689, 38.28723], [-120.86837, 38.2871], [-120.86831, 38.28707], [-120.8682, 38.28707], [-120.86816, 38.28703], [-120.86814, 38.28696], [-120.86815, 38.28687], [-120.86819, 38.28679], [-120.86822, 38.28676], [-120.86828, 38.28675], [-120.86844, 38.28675], [-120.86852, 38.28678], [-120.86887, 38.28696], [-120.86893, 38.28698], [-120.86898, 38.28697], [-120.86911, 38.28686], [-120.86912, 38.28681], [-120.86899, 38.286], [-120.86896, 38.28598], [-120.86891, 38.28596], [-120.86782, 38.28601], [-120.86777, 38.28599], [-120.86774, 38.28594], [-120.8677, 38.2855], [-120.86774, 38.28544], [-120.86777, 38.28542], [-120.8687, 38.28537], [-120.86875, 38.28533], [-120.86887, 38.28435], [-120.86888, 38.28412], [-120.86883, 38.28411], [-120.86872, 38.28417], [-120.86866, 38.28417], [-120.86855, 38.28414], [-120.86823, 38.28397], [-120.86813, 38.28395], [-120.86807, 38.28395], [-120.86788, 38.28389], [-120.86768, 38.28376], [-120.86727, 38.28365], [-120.86717, 38.28364], [-120.8671, 38.28369], [-120.8671, 38.28377], [-120.86714, 38.28382], [-120.86732, 38.284], [-120.86735, 38.2841], [-120.86734, 38.28419], [-120.86728, 38.2844], [-120.86728, 38.28445], [-120.86732, 38.28456], [-120.86739, 38.28466], [-120.86739, 38.28485], [-120.86735, 38.28491], [-120.86732, 38.28493], [-120.86663, 38.28515], [-120.86659, 38.28518], [-120.86657, 38.28523], [-120.86656, 38.28545], [-120.86654, 38.28549], [-120.86643, 38.28558], [-120.86623, 38.28565], [-120.8659, 38.28567], [-120.86583, 38.28564], [-120.86578, 38.28553], [-120.86579, 38.28513], [-120.86581, 38.28508], [-120.86588, 38.28502], [-120.86612, 38.28485], [-120.86613, 38.28481], [-120.86611, 38.28473], [-120.86608, 38.28469], [-120.8658, 38.28467], [-120.86566, 38.28464], [-120.86563, 38.2846], [-120.86562, 38.28447], [-120.8658, 38.28423], [-120.8658, 38.28417], [-120.86575, 38.28412], [-120.86565, 38.28411], [-120.86552, 38.28414], [-120.86516, 38.28438], [-120.86502, 38.28453], [-120.86494, 38.2849], [-120.86487, 38.28492], [-120.86475, 38.2849], [-120.86471, 38.28487], [-120.86471, 38.28463], [-120.86467, 38.28424], [-120.86468, 38.28416], [-120.86472, 38.28402], [-120.86472, 38.28391], [-120.8647, 38.28389], [-120.86462, 38.28387], [-120.86457, 38.28389], [-120.86439, 38.2841], [-120.86429, 38.28426], [-120.86417, 38.28436], [-120.8641, 38.28437], [-120.86401, 38.28436], [-120.86388, 38.28424], [-120.86379, 38.28413], [-120.86376, 38.28405], [-120.86376, 38.28389], [-120.86375, 38.28383], [-120.86366, 38.28376], [-120.86361, 38.28374], [-120.8635, 38.28374], [-120.86346, 38.28376], [-120.86338, 38.28396], [-120.8633, 38.28402], [-120.86311, 38.28404], [-120.86302, 38.28403], [-120.86284, 38.28409], [-120.8627, 38.28411], [-120.86257, 38.2841], [-120.86248, 38.28407], [-120.8623, 38.28397], [-120.86225, 38.28391], [-120.86223, 38.28385], [-120.86221, 38.28375], [-120.86226, 38.28328], [-120.86224, 38.28323], [-120.86191, 38.28304], [-120.86179, 38.28292], [-120.86169, 38.28289], [-120.86138, 38.28286], [-120.86133, 38.28284], [-120.8613, 38.28282], [-120.86131, 38.28271], [-120.86138, 38.28251], [-120.86139, 38.2824], [-120.86131, 38.28232], [-120.86115, 38.28224], [-120.86113, 38.2822], [-120.86112, 38.28209], [-120.86118, 38.28197], [-120.86131, 38.28182], [-120.86133, 38.28178], [-120.86133, 38.28174], [-120.86131, 38.28168], [-120.86119, 38.28152], [-120.86118, 38.28149], [-120.86163, 38.28147], [-120.86176, 38.28141], [-120.86178, 38.28137], [-120.86178, 38.28129], [-120.86176, 38.28124], [-120.8612, 38.28068], [-120.86119, 38.28063], [-120.86119, 38.2806], [-120.86129, 38.2806], [-120.86153, 38.28067], [-120.86165, 38.28065], [-120.8621, 38.28033], [-120.86212, 38.28029], [-120.86211, 38.28022], [-120.86204, 38.28018], [-120.86177, 38.28008], [-120.86169, 38.28004], [-120.86165, 38.27997], [-120.86173, 38.27992], [-120.86199, 38.27989], [-120.86234, 38.27991], [-120.86237, 38.27989], [-120.86237, 38.27986], [-120.86236, 38.27979], [-120.86224, 38.27963], [-120.86211, 38.27955], [-120.86193, 38.27949], [-120.86182, 38.27943], [-120.86164, 38.27931], [-120.86155, 38.2793], [-120.86153, 38.27927], [-120.86156, 38.2792], [-120.86167, 38.2791], [-120.86178, 38.27903], [-120.86194, 38.27898], [-120.86197, 38.27896], [-120.86201, 38.27882], [-120.86213, 38.27872], [-120.86221, 38.27869], [-120.86217, 38.27849], [-120.86218, 38.27845], [-120.86227, 38.27827], [-120.86234, 38.27817], [-120.86243, 38.27813], [-120.86256, 38.27811], [-120.86264, 38.27812], [-120.86287, 38.2782], [-120.86295, 38.2782], [-120.86297, 38.27819], [-120.86297, 38.27812], [-120.86294, 38.27809], [-120.86263, 38.27777], [-120.86262, 38.27772], [-120.86267, 38.27769], [-120.86305, 38.27762], [-120.86312, 38.27759], [-120.86313, 38.27754], [-120.8631, 38.27746], [-120.86304, 38.27741], [-120.86287, 38.27737], [-120.86258, 38.27737], [-120.86245, 38.27735], [-120.86226, 38.27727], [-120.86226, 38.27721], [-120.86247, 38.27702], [-120.86266, 38.27694], [-120.86275, 38.27683], [-120.86284, 38.27677], [-120.86292, 38.27674], [-120.86302, 38.27673], [-120.86314, 38.27675], [-120.86353, 38.27699], [-120.86358, 38.27699], [-120.86363, 38.27695], [-120.86364, 38.2769], [-120.86363, 38.27683], [-120.86345, 38.27646], [-120.86341, 38.27635], [-120.86341, 38.2763], [-120.86348, 38.27618], [-120.86347, 38.27597], [-120.86349, 38.27593], [-120.86359, 38.27585], [-120.86359, 38.27578], [-120.86351, 38.2756], [-120.86349, 38.27546], [-120.86351, 38.27538], [-120.86359, 38.27527], [-120.86367, 38.27523], [-120.86388, 38.27517], [-120.86399, 38.27511], [-120.86441, 38.2747], [-120.86444, 38.27463], [-120.86439, 38.27457], [-120.86426, 38.27453], [-120.86369, 38.2746], [-120.86358, 38.2746], [-120.8635, 38.27457], [-120.86343, 38.27453], [-120.86326, 38.27432], [-120.86325, 38.27427], [-120.86329, 38.274], [-120.86328, 38.27396], [-120.86322, 38.27393], [-120.86293, 38.27391], [-120.86284, 38.27387], [-120.86277, 38.27381], [-120.86271, 38.27374], [-120.86269, 38.27347], [-120.86267, 38.2734], [-120.86262, 38.27335], [-120.86252, 38.27329], [-120.86241, 38.27331], [-120.86234, 38.27334], [-120.86227, 38.27334], [-120.86205, 38.27331], [-120.8619, 38.27327], [-120.86176, 38.27319], [-120.86153, 38.27294], [-120.86143, 38.27272], [-120.86141, 38.27259], [-120.86137, 38.2721], [-120.86135, 38.27205], [-120.8612, 38.27193], [-120.86102, 38.27181], [-120.86413, 38.26857], [-120.86442, 38.26876], [-120.86478, 38.26911], [-120.86501, 38.26939], [-120.86515, 38.26961], [-120.86528, 38.26988], [-120.86587, 38.27161], [-120.86612, 38.27194], [-120.86798, 38.274], [-120.86828, 38.27436], [-120.86884, 38.2754], [-120.86963, 38.27647], [-120.86989, 38.27679], [-120.87008, 38.2771], [-120.87015, 38.27732]]]]} Open Access 1 35080 Pardee Reservoir 3202 2031 East Bay Municipal Utility District 433 Special District 4 Water District 13 http://www.ebmud.com/ Special District 4 2031 East Bay Municipal Utility District 427 Special District 4 Water District 13 https://www.ebmud.com/recreation/pardee-reservoir Amador 52 250.788 Pardee Reservoir 0 Local Recreation Area 3 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]);