units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where PARK_URL = "http://www.fws.gov/refuge/stone_lakes/"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
ACCESS_TYP 2
MNG_AG_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15825 | 15825 | 15824 | {"type": "MultiPolygon", "coordinates": [[[[-121.47105, 38.35012], [-121.46407, 38.35017], [-121.46402, 38.34546], [-121.46413, 38.34545], [-121.46394, 38.33939], [-121.46876, 38.33911], [-121.47105, 38.35012]]], [[[-121.50976, 38.36471], [-121.50932, 38.36497], [-121.50925, 38.36406], [-121.50915, 38.36315], [-121.50902, 38.36224], [-121.50827, 38.35776], [-121.50809, 38.35774], [-121.50777, 38.35581], [-121.50794, 38.35579], [-121.50791, 38.35561], [-121.50801, 38.35559], [-121.50705, 38.34985], [-121.50695, 38.34984], [-121.50694, 38.34981], [-121.50132, 38.34978], [-121.50101, 38.34974], [-121.50054, 38.34973], [-121.50024, 38.34969], [-121.49774, 38.34967], [-121.49781, 38.34858], [-121.49885, 38.34766], [-121.49929, 38.34611], [-121.49096, 38.34607], [-121.49092, 38.34239], [-121.4909, 38.34231], [-121.49076, 38.32093], [-121.49636, 38.32096], [-121.49638, 38.32055], [-121.5012, 38.32057], [-121.50242, 38.32787], [-121.50369, 38.32788], [-121.50491, 38.3352], [-121.50497, 38.33521], [-121.50872, 38.3577], [-121.50867, 38.35771], [-121.50944, 38.36211], [-121.50967, 38.36368], [-121.50976, 38.36471]]], [[[-121.50109, 38.35764], [-121.50084, 38.36476], [-121.49622, 38.36469], [-121.49609, 38.37119], [-121.49574, 38.37128], [-121.49544, 38.37129], [-121.48983, 38.37282], [-121.48916, 38.37298], [-121.48893, 38.36986], [-121.48853, 38.36862], [-121.48864, 38.36598], [-121.48843, 38.36472], [-121.4885, 38.36472], [-121.48871, 38.36596], [-121.48899, 38.36595], [-121.4888, 38.36472], [-121.48899, 38.36186], [-121.49096, 38.35817], [-121.49308, 38.35702], [-121.50107, 38.35702], [-121.50106, 38.35763], [-121.50109, 38.35764]]], [[[-121.50184, 38.41602], [-121.50166, 38.41632], [-121.50152, 38.41663], [-121.50144, 38.41695], [-121.5014, 38.41728], [-121.50142, 38.42955], [-121.50134, 38.42957], [-121.50133, 38.43045], [-121.50142, 38.43046], [-121.50142, 38.43053], [-121.48891, 38.43054], [-121.48947, 38.429], [-121.48964, 38.42828], [-121.48955, 38.42756], [-121.48888, 38.42657], [-121.48787, 38.4259], [-121.48769, 38.42587], [-121.48733, 38.42418], [-121.4871, 38.42222], [-121.48676, 38.42107], [-121.4859, 38.41689], [-121.4858, 38.41654], [-121.48563, 38.41606], [-121.48585, 38.41604], [-121.50086, 38.41604], [-121.50184, 38.41602]]]]} | Open Access 1 | 21636 | Stone Lakes National Wildlife Refuge | 1758 | 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 | http://www.fws.gov/refuge/stone_lakes/ | Sacramento 41 | 1878.711 | Stone Lakes NWR | 1994 | National Wildlife Refuge 105 | 2 |
15844 | 15844 | 15843 | {"type": "MultiPolygon", "coordinates": [[[[-121.50142, 38.43053], [-121.50116, 38.4307], [-121.50116, 38.43311], [-121.49772, 38.43419], [-121.49635, 38.43742], [-121.49086, 38.43957], [-121.48897, 38.43056], [-121.48891, 38.43054], [-121.50142, 38.43053]]], [[[-121.50288, 38.31759], [-121.50237, 38.31765], [-121.50282, 38.32038], [-121.50191, 38.32038], [-121.50147, 38.31774], [-121.50137, 38.31774], [-121.49836, 38.29949], [-121.49887, 38.29944], [-121.49888, 38.29943], [-121.49573, 38.28032], [-121.49674, 38.28031], [-121.50288, 38.31759]]]]} | No Public Access 3 | 44499 | Stone Lakes National Wildlife Refuge | 31515 | 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 | http://www.fws.gov/refuge/stone_lakes/ | Sacramento 41 | 288.103 | Stone Lakes NWR | 1994 | National Wildlife Refuge 105 | 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]);