units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 690, MNG_AG_LEV = 4 and MNG_AG_TYP = 13
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8280 | 8280 | 8279 | {"type": "MultiPolygon", "coordinates": [[[[-118.48094, 34.09499], [-118.48094, 34.09553], [-118.48028, 34.09636], [-118.48008, 34.09718], [-118.47968, 34.09851], [-118.47953, 34.0987], [-118.47943, 34.09891], [-118.47908, 34.09938], [-118.47893, 34.09944], [-118.47909, 34.099], [-118.47913, 34.09881], [-118.47915, 34.09861], [-118.47912, 34.09828], [-118.47902, 34.09795], [-118.47901, 34.09781], [-118.47894, 34.09758], [-118.47878, 34.09729], [-118.47866, 34.09714], [-118.47836, 34.0969], [-118.47831, 34.09687], [-118.47793, 34.09658], [-118.47718, 34.09576], [-118.47751, 34.09528], [-118.47856, 34.09537], [-118.47954, 34.09499], [-118.48094, 34.09499]]], [[[-118.47877, 34.09907], [-118.47863, 34.0994], [-118.47864, 34.09913], [-118.4786, 34.09867], [-118.47853, 34.09816], [-118.47848, 34.09794], [-118.47841, 34.09775], [-118.47806, 34.09705], [-118.47818, 34.09701], [-118.47824, 34.09704], [-118.47844, 34.09721], [-118.4786, 34.09739], [-118.47873, 34.09762], [-118.47883, 34.09791], [-118.4789, 34.09827], [-118.47889, 34.09857], [-118.47886, 34.09875], [-118.47878, 34.09899], [-118.47876, 34.09906], [-118.47877, 34.09907]]]]} | No Public Access 3 | 12704 | Sepulveda Canyon MWD site | 25303 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 2078 | Metropolitan Water District of Southern California 407 | Special District 4 | Water District 13 | Los Angeles 6 | 19.6 | Sepulveda Canyon MWD site | None 690 |
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]);