units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "34.233" and MNG_AG_TYP = 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15505 | 15505 | 15504 | {"type": "MultiPolygon", "coordinates": [[[[-118.35612, 34.43068], [-118.35613, 34.43095], [-118.3561, 34.431], [-118.35601, 34.43109], [-118.356, 34.43063], [-118.35612, 34.43068]]], [[[-118.36056, 34.43358], [-118.36055, 34.43456], [-118.35603, 34.434], [-118.35601, 34.43127], [-118.3562, 34.43136], [-118.35639, 34.43149], [-118.35801, 34.43288], [-118.35827, 34.43304], [-118.3586, 34.43317], [-118.35999, 34.43352], [-118.36029, 34.43357], [-118.36056, 34.43358]]], [[[-118.36058, 34.4324], [-118.36057, 34.43342], [-118.36037, 34.43341], [-118.36015, 34.43339], [-118.35951, 34.43323], [-118.35952, 34.43314], [-118.35948, 34.43306], [-118.35943, 34.43301], [-118.35926, 34.43291], [-118.35911, 34.43286], [-118.35863, 34.43278], [-118.35858, 34.43276], [-118.35852, 34.43269], [-118.35852, 34.4326], [-118.35856, 34.43256], [-118.35875, 34.43243], [-118.35865, 34.43233], [-118.35845, 34.43246], [-118.35837, 34.43255], [-118.35835, 34.43261], [-118.35835, 34.43268], [-118.35837, 34.43275], [-118.3584, 34.43281], [-118.35847, 34.43287], [-118.35856, 34.43291], [-118.35915, 34.43301], [-118.35933, 34.43312], [-118.35936, 34.43319], [-118.3585, 34.43296], [-118.35834, 34.43288], [-118.35817, 34.43277], [-118.35652, 34.43137], [-118.35633, 34.43124], [-118.35614, 34.43114], [-118.35622, 34.43105], [-118.35626, 34.43097], [-118.35627, 34.43091], [-118.35625, 34.43074], [-118.3594, 34.43212], [-118.35966, 34.43221], [-118.35999, 34.4323], [-118.36058, 34.4324]]], [[[-118.36059, 34.43104], [-118.36058, 34.43212], [-118.36008, 34.43204], [-118.35954, 34.43187], [-118.35636, 34.4305], [-118.35638, 34.43048], [-118.36059, 34.43104]]]]} | Unknown Access 4 | 46349 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 34.233 | 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]);