units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, ACRES = "406.137" and DES_TP = 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15594 | 15594 | 15593 | {"type": "MultiPolygon", "coordinates": [[[[-122.2062, 37.53851], [-122.20455, 37.54011], [-122.19733, 37.53527], [-122.1973, 37.53847], [-122.19487, 37.53846], [-122.19422, 37.53582], [-122.19495, 37.53174], [-122.19634, 37.52938], [-122.20089, 37.52623], [-122.20168, 37.52658], [-122.20253, 37.52558], [-122.20578, 37.52397], [-122.20588, 37.52401], [-122.19807, 37.53143], [-122.20242, 37.53423], [-122.20129, 37.53534], [-122.20129, 37.53535], [-122.2062, 37.53851]]], [[[-122.22714, 37.52048], [-122.22689, 37.52077], [-122.22657, 37.52111], [-122.22641, 37.52125], [-122.22609, 37.52149], [-122.22538, 37.52198], [-122.22516, 37.52212], [-122.22445, 37.52244], [-122.22405, 37.52255], [-122.2239, 37.52255], [-122.22374, 37.52258], [-122.22363, 37.52262], [-122.22341, 37.52272], [-122.22324, 37.52266], [-122.22312, 37.52267], [-122.22276, 37.52251], [-122.22266, 37.52245], [-122.22245, 37.52219], [-122.22241, 37.5221], [-122.22245, 37.52195], [-122.22254, 37.52177], [-122.22262, 37.52149], [-122.22287, 37.52094], [-122.22315, 37.52048], [-122.22323, 37.52021], [-122.22332, 37.51999], [-122.22338, 37.51976], [-122.2234, 37.5196], [-122.22319, 37.51928], [-122.22333, 37.51939], [-122.22358, 37.51978], [-122.22325, 37.5205], [-122.22326, 37.52052], [-122.22714, 37.52048]]], [[[-122.23489, 37.519], [-122.23483, 37.51918], [-122.23478, 37.51928], [-122.23448, 37.51963], [-122.23425, 37.51988], [-122.23403, 37.52006], [-122.23368, 37.52027], [-122.23317, 37.52048], [-122.23279, 37.52065], [-122.23244, 37.52075], [-122.23198, 37.52076], [-122.23175, 37.52057], [-122.23162, 37.52041], [-122.2316, 37.52031], [-122.23155, 37.52019], [-122.23147, 37.51995], [-122.23143, 37.51971], [-122.23143, 37.51959], [-122.23123, 37.51926], [-122.23098, 37.51906], [-122.23489, 37.519]]], [[[-122.24449, 37.52305], [-122.24432, 37.52312], [-122.24259, 37.52249], [-122.24224, 37.52232], [-122.24156, 37.52225], [-122.24014, 37.52184], [-122.23966, 37.5216], [-122.23923, 37.52116], [-122.23916, 37.52098], [-122.23904, 37.52076], [-122.23902, 37.52064], [-122.23888, 37.52027], [-122.23881, 37.51987], [-122.23859, 37.51912], [-122.23923, 37.5191], [-122.23924, 37.51909], [-122.23879, 37.5087], [-122.24237, 37.50878], [-122.24322, 37.50895], [-122.24355, 37.50917], [-122.244, 37.5097], [-122.24412, 37.51004], [-122.24429, 37.51013], [-122.24441, 37.51041], [-122.24479, 37.5109], [-122.24612, 37.51319], [-122.24624, 37.51615], [-122.24618, 37.51781], [-122.24599, 37.51889], [-122.24597, 37.51955], [-122.24449, 37.52305]]]]} | No Public Access 3 | 17757 | Bair Island Ecological Reserve | 15764 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bair-Island-ER | San Mateo 15 | 406.137 | Bair Island ER | 1986 | Conservation Area 13 | 2 |
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]);