units_with_maps

Table actions

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

1 row where COUNTY = 10 and MNG_AG_TYP = 16

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Irrigation District · 1 ✖

ACCESS_TYP 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
8010 8010 8009 {"type": "MultiPolygon", "coordinates": [[[[-116.02639, 33.51813], [-116.02637, 33.5256], [-116.00908, 33.52564], [-116.00908, 33.51812], [-116.02639, 33.51813]]], [[[-115.9917, 33.52561], [-115.97426, 33.52554], [-115.97415, 33.51817], [-115.99159, 33.51815], [-115.9917, 33.52561]]], [[[-116.08721, 33.51054], [-116.08721, 33.51421], [-116.08313, 33.51422], [-116.08312, 33.5179], [-116.07905, 33.51792], [-116.07904, 33.51054], [-116.06996, 33.51054], [-116.06116, 33.51058], [-116.06111, 33.50026], [-116.06106, 33.49907], [-116.04367, 33.4991], [-116.04385, 33.4845], [-116.02647, 33.48448], [-116.02633, 33.49919], [-116.00918, 33.49928], [-116.00907, 33.48449], [-115.99116, 33.48451], [-115.99116, 33.49919], [-115.9738, 33.49918], [-115.97404, 33.5108], [-115.95654, 33.51085], [-115.95674, 33.52541], [-115.94386, 33.52537], [-115.9438, 33.52174], [-115.9395, 33.52173], [-115.93932, 33.51085], [-115.95652, 33.51085], [-115.95651, 33.50987], [-115.9563, 33.5002], [-115.95643, 33.49917], [-115.93907, 33.49918], [-115.93919, 33.4846], [-115.94781, 33.48458], [-115.94784, 33.48133], [-115.95216, 33.48126], [-115.95214, 33.48458], [-115.95644, 33.48457], [-115.95644, 33.49916], [-115.97378, 33.49918], [-115.97379, 33.49917], [-115.97371, 33.48456], [-115.95645, 33.48456], [-115.95658, 33.47012], [-115.93925, 33.47013], [-115.93931, 33.45556], [-115.9393, 33.45555], [-115.92196, 33.45559], [-115.92197, 33.44092], [-115.90467, 33.44096], [-115.90465, 33.45563], [-115.88728, 33.45568], [-115.88727, 33.441], [-115.87582, 33.44116], [-115.86951, 33.44116], [-115.86945, 33.42685], [-115.87438, 33.42687], [-115.88723, 33.42686], [-115.88728, 33.44099], [-115.90466, 33.44096], [-115.9047, 33.42684], [-115.9221, 33.4268], [-115.92198, 33.44092], [-115.93937, 33.44093], [-115.9393, 33.45555], [-115.95671, 33.45554], [-115.95674, 33.45552], [-115.95683, 33.44096], [-115.93939, 33.44093], [-115.93946, 33.42674], [-115.95693, 33.42668], [-115.95683, 33.44096], [-115.97422, 33.44094], [-115.97424, 33.44093], [-115.97442, 33.42663], [-115.98341, 33.4266], [-115.99201, 33.42654], [-115.9918, 33.44093], [-116.00081, 33.44091], [-116.00913, 33.44086], [-116.00921, 33.42648], [-116.0265, 33.42635], [-116.02646, 33.44084], [-116.04392, 33.44081], [-116.04391, 33.45541], [-116.05245, 33.45538], [-116.05247, 33.46264], [-116.06106, 33.4626], [-116.06111, 33.46984], [-116.07886, 33.46979], [-116.07885, 33.48439], [-116.08713, 33.48429], [-116.08717, 33.49528], [-116.08304, 33.4953], [-116.08305, 33.49895], [-116.07892, 33.49896], [-116.079, 33.50032], [-116.07905, 33.51053], [-116.08721, 33.51054]], [[-115.99114, 33.48451], [-115.99135, 33.4701], [-115.97388, 33.47012], [-115.97372, 33.48455], [-115.99114, 33.48451]], [[-115.97388, 33.47012], [-115.9741, 33.45549], [-115.95674, 33.45553], [-115.95672, 33.45555], [-115.95658, 33.47012], [-115.97388, 33.47012]], [[-116.0091, 33.47005], [-116.00912, 33.45545], [-115.99162, 33.45548], [-115.99136, 33.4701], [-116.00084, 33.47011], [-116.0091, 33.47005]], [[-116.04381, 33.46994], [-116.04391, 33.45541], [-116.02647, 33.45544], [-116.02647, 33.47003], [-116.04381, 33.46994]], [[-116.06115, 33.48444], [-116.06111, 33.46984], [-116.04382, 33.46994], [-116.04386, 33.4845], [-116.06115, 33.48444]], [[-116.07885, 33.48441], [-116.06116, 33.48445], [-116.06107, 33.49906], [-116.07892, 33.49895], [-116.07885, 33.48441]], [[-116.02646, 33.48448], [-116.02646, 33.47004], [-116.00911, 33.47006], [-116.00908, 33.48449], [-116.02646, 33.48448]], [[-115.9918, 33.44093], [-115.97424, 33.44095], [-115.97411, 33.45548], [-115.99161, 33.45547], [-115.99181, 33.44094], [-115.9918, 33.44093]], [[-116.02646, 33.44086], [-116.02645, 33.44085], [-116.00914, 33.44087], [-116.00912, 33.45545], [-116.02646, 33.45544], [-116.02646, 33.44086]]], [[[-116.04379, 33.52553], [-116.04379, 33.52917], [-116.03943, 33.52918], [-116.03943, 33.52555], [-116.04379, 33.52553]]], [[[-116.07904, 33.5253], [-116.07902, 33.52898], [-116.07016, 33.52902], [-116.07016, 33.5327], [-116.06574, 33.53272], [-116.06571, 33.52536], [-116.07904, 33.5253]]]]} Open Access 1 12966 Salton Sea - Irrigation District 4595 2048 Imperial Irrigation District 379 Special District 4 Irrigation District 17 http://www.iid.com/ Special District 4 2048 Imperial Irrigation District 374 Special District 4 Irrigation District 16   Riverside 10 16954.91 Salton Sea - Irrigation District 0 Local Other or Unknown 14 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]);