superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Lopez Canyon" and MNG_AG_TYP = 6
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12461 | 12461 | 12460 | {"type": "MultiPolygon", "coordinates": [[[[-118.38716, 34.31516], [-118.38712, 34.31703], [-118.38601, 34.31704], [-118.38597, 34.31888], [-118.38707, 34.3189], [-118.38698, 34.32263], [-118.38262, 34.32257], [-118.38267, 34.31888], [-118.38047, 34.31884], [-118.3805, 34.31514], [-118.3827, 34.31515], [-118.38271, 34.31468], [-118.38278, 34.31477], [-118.38282, 34.31487], [-118.38283, 34.31516], [-118.3828, 34.31537], [-118.38267, 34.31581], [-118.38267, 34.31586], [-118.3827, 34.31593], [-118.38277, 34.31598], [-118.38285, 34.316], [-118.38294, 34.31598], [-118.38302, 34.31592], [-118.38318, 34.31561], [-118.38332, 34.31541], [-118.38344, 34.31528], [-118.38383, 34.31495], [-118.38385, 34.31515], [-118.38494, 34.31515], [-118.38492, 34.31421], [-118.38563, 34.3139], [-118.38592, 34.31372], [-118.3861, 34.31356], [-118.3871, 34.31251], [-118.38712, 34.31336], [-118.38657, 34.31338], [-118.38661, 34.31514], [-118.38716, 34.31516]]], [[[-118.3871, 34.31234], [-118.386, 34.31349], [-118.38585, 34.31362], [-118.38557, 34.3138], [-118.38492, 34.31409], [-118.3849, 34.31336], [-118.38381, 34.31335], [-118.38383, 34.3148], [-118.38335, 34.31521], [-118.38321, 34.31534], [-118.38306, 34.31556], [-118.3829, 34.31587], [-118.38285, 34.31589], [-118.38281, 34.31587], [-118.3828, 34.31583], [-118.38295, 34.31531], [-118.38296, 34.31516], [-118.38296, 34.31495], [-118.38294, 34.31483], [-118.38289, 34.31471], [-118.38282, 34.31461], [-118.38271, 34.31451], [-118.38267, 34.31154], [-118.38708, 34.31156], [-118.3871, 34.31234]]]]} | Unknown Access 4 | Lopez Canyon | 29509 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 129.23 | Lopez Canyon |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);