units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "303.484", MNG_AGENCY = 44 and MNG_AG_TYP = 1
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Federal Agency · 1 ✖
MNG_AGENCY 1
- United States Fish and Wildlife Service · 1 ✖
DES_TP 1
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15565 | 15565 | 15564 | {"type": "Polygon", "coordinates": [[[-122.23821, 37.49916], [-122.23884, 37.49964], [-122.24115, 37.5016], [-122.24307, 37.50329], [-122.24334, 37.50312], [-122.24409, 37.50378], [-122.24397, 37.50388], [-122.24419, 37.50407], [-122.24432, 37.50399], [-122.24458, 37.50422], [-122.24447, 37.5043], [-122.24446, 37.50432], [-122.24468, 37.50451], [-122.24481, 37.50443], [-122.24618, 37.50566], [-122.24606, 37.50575], [-122.24628, 37.50595], [-122.24562, 37.50643], [-122.24251, 37.50367], [-122.23994, 37.50551], [-122.24256, 37.50787], [-122.24216, 37.50788], [-122.24137, 37.50795], [-122.24041, 37.50791], [-122.23934, 37.50779], [-122.23901, 37.50769], [-122.23865, 37.50741], [-122.23809, 37.50775], [-122.23815, 37.5079], [-122.23796, 37.50807], [-122.23743, 37.50801], [-122.23714, 37.50802], [-122.23677, 37.50794], [-122.23623, 37.50776], [-122.23566, 37.50748], [-122.23556, 37.50727], [-122.23495, 37.50712], [-122.23456, 37.50689], [-122.23402, 37.50679], [-122.23243, 37.50611], [-122.23102, 37.50574], [-122.23027, 37.50549], [-122.22934, 37.50497], [-122.22894, 37.50458], [-122.22864, 37.50415], [-122.22815, 37.50366], [-122.22781, 37.50279], [-122.22773, 37.50232], [-122.22712, 37.50151], [-122.2261, 37.50079], [-122.22503, 37.50015], [-122.22494, 37.5003], [-122.22459, 37.5004], [-122.22486, 37.50102], [-122.22469, 37.50103], [-122.22456, 37.50109], [-122.22447, 37.5011], [-122.22336, 37.49821], [-122.21968, 37.49817], [-122.21976, 37.4979], [-122.22358, 37.49793], [-122.22364, 37.49767], [-122.22378, 37.49741], [-122.22393, 37.49721], [-122.22412, 37.49704], [-122.2243, 37.49691], [-122.22714, 37.49518], [-122.22728, 37.49534], [-122.22445, 37.49707], [-122.22422, 37.49724], [-122.22405, 37.49742], [-122.22391, 37.49764], [-122.22382, 37.49787], [-122.2238, 37.49813], [-122.23182, 37.49814], [-122.23176, 37.49823], [-122.23135, 37.49871], [-122.23132, 37.49883], [-122.23133, 37.49889], [-122.23137, 37.49895], [-122.23142, 37.499], [-122.23149, 37.49904], [-122.23155, 37.49918], [-122.23183, 37.49924], [-122.23201, 37.49918], [-122.23217, 37.49876], [-122.23249, 37.49825], [-122.23258, 37.49814], [-122.23676, 37.49811], [-122.23821, 37.49916]]]} | No Public Access 3 | 2389 | 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 | 303.484 | 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]);