superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "San Bruno Mtn. ER" and MNG_AG_TYP = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15203 | 15203 | 15202 | {"type": "Polygon", "coordinates": [[[-122.42073, 37.67888], [-122.42038, 37.68009], [-122.42024, 37.68034], [-122.41625, 37.68323], [-122.4188, 37.68671], [-122.4174, 37.68729], [-122.41662, 37.68663], [-122.41649, 37.68654], [-122.41633, 37.68645], [-122.41615, 37.68638], [-122.41596, 37.68633], [-122.41441, 37.68613], [-122.41413, 37.68607], [-122.41385, 37.68597], [-122.41403, 37.68559], [-122.41357, 37.68543], [-122.41325, 37.68536], [-122.41307, 37.68534], [-122.41288, 37.68533], [-122.41265, 37.68535], [-122.41243, 37.68539], [-122.41225, 37.68544], [-122.41205, 37.68552], [-122.41151, 37.68581], [-122.41125, 37.68592], [-122.41019, 37.6863], [-122.41016, 37.68625], [-122.4092, 37.68652], [-122.40894, 37.68656], [-122.4087, 37.68658], [-122.40824, 37.68656], [-122.40798, 37.68651], [-122.40776, 37.68645], [-122.4057, 37.68566], [-122.40588, 37.68546], [-122.40687, 37.68481], [-122.40806, 37.68479], [-122.40806, 37.68264], [-122.40809, 37.68264], [-122.40811, 37.68257], [-122.40806, 37.68254], [-122.40806, 37.68232], [-122.40811, 37.68231], [-122.40811, 37.68226], [-122.40834, 37.68234], [-122.41065, 37.68155], [-122.41122, 37.68322], [-122.41168, 37.68323], [-122.41335, 37.68529], [-122.41549, 37.68554], [-122.41507, 37.68212], [-122.41619, 37.68107], [-122.41635, 37.68109], [-122.41837, 37.67888], [-122.42073, 37.67888]]]} | Open Access 1 | San Bruno Mountain Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Bruno-Mountain-ER | 32289 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 95.818 | San Bruno Mtn. ER | 1993 |
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]);