units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, AGNCY_WEB = "http://www.lakemcclure.com/" and MNG_AGENCY = 620

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Merced Irrigation District · 1 ✖

DES_TP 1

ACCESS_TYP 1

  • Restricted 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
7761 7761 7760 {"type": "Polygon", "coordinates": [[[-120.31895, 37.52502], [-120.31852, 37.52527], [-120.31803, 37.52517], [-120.31679, 37.525], [-120.31626, 37.5249], [-120.31569, 37.52483], [-120.31548, 37.52484], [-120.31468, 37.52498], [-120.31412, 37.52505], [-120.31379, 37.52505], [-120.31337, 37.52502], [-120.31309, 37.52495], [-120.31281, 37.52486], [-120.312, 37.52441], [-120.31077, 37.52366], [-120.30206, 37.5239], [-120.29728, 37.52385], [-120.29724, 37.52346], [-120.29606, 37.52324], [-120.2955, 37.52344], [-120.29558, 37.5236], [-120.29312, 37.52441], [-120.29203, 37.52461], [-120.29178, 37.52469], [-120.29147, 37.52483], [-120.29125, 37.52499], [-120.29044, 37.52582], [-120.2902, 37.52596], [-120.29006, 37.52585], [-120.2899, 37.52596], [-120.28979, 37.52594], [-120.28916, 37.52642], [-120.28887, 37.52661], [-120.28841, 37.52716], [-120.28844, 37.52726], [-120.28717, 37.5286], [-120.28707, 37.5286], [-120.28673, 37.52917], [-120.28658, 37.52955], [-120.28637, 37.53062], [-120.28636, 37.53126], [-120.28607, 37.53165], [-120.28549, 37.53229], [-120.28538, 37.53254], [-120.2853, 37.53301], [-120.28518, 37.53352], [-120.28513, 37.53367], [-120.28479, 37.53413], [-120.2846, 37.53431], [-120.28419, 37.53456], [-120.28375, 37.5348], [-120.28334, 37.5352], [-120.28311, 37.5355], [-120.28292, 37.53581], [-120.28275, 37.53658], [-120.28, 37.53667], [-120.28098, 37.53383], [-120.28102, 37.5312], [-120.28117, 37.52988], [-120.28182, 37.53], [-120.28321, 37.52909], [-120.28389, 37.52827], [-120.28464, 37.52741], [-120.28466, 37.5271], [-120.28501, 37.52659], [-120.28531, 37.52646], [-120.28587, 37.52577], [-120.28469, 37.52417], [-120.28479, 37.52371], [-120.28398, 37.52336], [-120.28302, 37.52404], [-120.28336, 37.52307], [-120.28422, 37.52264], [-120.28565, 37.52313], [-120.28597, 37.52384], [-120.28673, 37.52421], [-120.28765, 37.52339], [-120.28696, 37.52268], [-120.28806, 37.5226], [-120.28906, 37.52155], [-120.28839, 37.52087], [-120.2886, 37.52031], [-120.29, 37.52076], [-120.29197, 37.51909], [-120.29196, 37.51836], [-120.29121, 37.51803], [-120.29114, 37.51784], [-120.28969, 37.51818], [-120.28899, 37.51815], [-120.28959, 37.51765], [-120.29126, 37.51697], [-120.2917, 37.51558], [-120.29153, 37.51491], [-120.29221, 37.51322], [-120.29221, 37.51299], [-120.29285, 37.51207], [-120.29369, 37.51202], [-120.29339, 37.513], [-120.29377, 37.51341], [-120.29308, 37.51455], [-120.29252, 37.51477], [-120.29252, 37.51478], [-120.29303, 37.51534], [-120.29384, 37.51508], [-120.29389, 37.51435], [-120.29444, 37.51458], [-120.29468, 37.51399], [-120.29519, 37.51393], [-120.29506, 37.51514], [-120.29598, 37.51471], [-120.29534, 37.51566], [-120.2955, 37.51645], [-120.29641, 37.51672], [-120.29786, 37.51661], [-120.29865, 37.51672], [-120.29904, 37.51678], [-120.29933, 37.51653], [-120.30248, 37.51675], [-120.30326, 37.51675], [-120.30351, 37.51636], [-120.30361, 37.51564], [-120.30444, 37.51585], [-120.30482, 37.51623], [-120.30501, 37.51679], [-120.3066, 37.51626], [-120.30794, 37.51748], [-120.30832, 37.51674], [-120.309, 37.51656], [-120.31143, 37.51626], [-120.31199, 37.51621], [-120.31464, 37.51928], [-120.31649, 37.52163], [-120.31743, 37.52286], [-120.31532, 37.52453], [-120.31532, 37.52454], [-120.31543, 37.52453], [-120.31652, 37.52463], [-120.31895, 37.52502]]]} Restricted Access 2 48467 Lake McClure 33177 2240 Merced Irrigation District 631 Special District 4 Irrigation District 17 http://www.lakemcclure.com/ Special District 4 2240 Merced Irrigation District 620 Special District 4 Irrigation District 16 http://www.lakemcclure.com/ Mariposa 31 626.209 Lake McClure   None 643  

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