units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 10, MNG_AGENCY = 374 and MNG_AG_TYP = 16
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Irrigation District · 1 ✖
MNG_AGENCY 1
- Imperial Irrigation District · 1 ✖
DES_TP 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
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]);