units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where DES_TP = 8, MNG_AG_TYP = 5 and YR_EST = 1974
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_ID, COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10507 | 10507 | 10506 | {"type": "Polygon", "coordinates": [[[-122.41293, 37.25988], [-122.41295, 37.25997], [-122.41206, 37.26401], [-122.41184, 37.2647], [-122.41161, 37.2652], [-122.41159, 37.26533], [-122.41128, 37.26576], [-122.4113, 37.26579], [-122.41094, 37.26638], [-122.4098, 37.2687], [-122.40947, 37.26959], [-122.40843, 37.27365], [-122.40815, 37.274], [-122.40808, 37.2744], [-122.40529, 37.27429], [-122.40521, 37.27413], [-122.40479, 37.27394], [-122.40452, 37.27375], [-122.40434, 37.2736], [-122.40436, 37.27315], [-122.40434, 37.27296], [-122.40415, 37.27255], [-122.40354, 37.27164], [-122.40392, 37.2708], [-122.4039, 37.27061], [-122.40373, 37.27008], [-122.40286, 37.26946], [-122.40273, 37.2694], [-122.40192, 37.2695], [-122.40167, 37.2696], [-122.40142, 37.26976], [-122.40087, 37.26961], [-122.40028, 37.26914], [-122.3996, 37.26883], [-122.3989, 37.26729], [-122.39829, 37.26639], [-122.39808, 37.26579], [-122.39826, 37.2658], [-122.39835, 37.26527], [-122.39769, 37.263], [-122.39969, 37.26224], [-122.40032, 37.26221], [-122.40033, 37.2622], [-122.39899, 37.26081], [-122.39849, 37.26053], [-122.39838, 37.26007], [-122.39715, 37.2589], [-122.39639, 37.25856], [-122.39593, 37.25842], [-122.39535, 37.25805], [-122.39395, 37.25808], [-122.39357, 37.25795], [-122.39351, 37.25769], [-122.39361, 37.25734], [-122.39402, 37.25686], [-122.39407, 37.25651], [-122.39443, 37.25615], [-122.39451, 37.256], [-122.39446, 37.25594], [-122.39453, 37.25583], [-122.39458, 37.25557], [-122.39745, 37.25524], [-122.39749, 37.25525], [-122.39812, 37.25516], [-122.39624, 37.25305], [-122.3962, 37.25299], [-122.39476, 37.2514], [-122.39605, 37.25124], [-122.39588, 37.2509], [-122.39583, 37.25085], [-122.39573, 37.25059], [-122.39556, 37.2503], [-122.39701, 37.25003], [-122.39842, 37.24988], [-122.39936, 37.24994], [-122.39991, 37.25003], [-122.40056, 37.25021], [-122.40116, 37.25057], [-122.40158, 37.25089], [-122.402, 37.25141], [-122.40238, 37.25191], [-122.4027, 37.25228], [-122.40313, 37.25257], [-122.40363, 37.25272], [-122.40409, 37.25289], [-122.40483, 37.25312], [-122.40541, 37.25337], [-122.40618, 37.25364], [-122.40676, 37.25399], [-122.40706, 37.25426], [-122.40726, 37.25469], [-122.40754, 37.25545], [-122.40803, 37.25646], [-122.40868, 37.25772], [-122.40892, 37.25813], [-122.40913, 37.25843], [-122.40947, 37.25879], [-122.40992, 37.25914], [-122.41039, 37.25939], [-122.41067, 37.2595], [-122.41157, 37.25973], [-122.41229, 37.25979], [-122.41283, 37.25981], [-122.41293, 37.25988]]]} | Restricted Access 2 | 18614 | Pescadero Marsh Natural Preserve | 23620 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | San Mateo 15 | 606.372 | Pescadero Marsh Natural Preserve | 1974 | State Conservation Area 8 | 2 | |
11472 | 11472 | 11471 | {"type": "Polygon", "coordinates": [[[-121.0343, 37.08628], [-121.03425, 37.08903], [-121.02759, 37.08656], [-121.02759, 37.08625], [-121.0343, 37.08628]]]} | Open Access 1 | 29207 | O'Neill Forebay Wildlife Area | 30483 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Merced 37 | 25.025 | O'Neill Forebay Wildlife Area | 1974 | State Conservation Area 8 | 2 | |
16737 | 16737 | 16736 | {"type": "Polygon", "coordinates": [[[-121.21406, 37.06776], [-121.21298, 37.06812], [-121.21212, 37.06859], [-121.21188, 37.06961], [-121.2101, 37.07152], [-121.20869, 37.07416], [-121.20739, 37.07552], [-121.20099, 37.07677], [-121.19885, 37.07706], [-121.19884, 37.07707], [-121.19633, 37.07741], [-121.19525, 37.07718], [-121.19463, 37.07753], [-121.19516, 37.07966], [-121.19407, 37.08005], [-121.19383, 37.08125], [-121.1924, 37.08246], [-121.19156, 37.08301], [-121.19054, 37.08296], [-121.19005, 37.08424], [-121.18797, 37.08395], [-121.1871, 37.08434], [-121.18607, 37.08428], [-121.18542, 37.08347], [-121.18368, 37.0841], [-121.18212, 37.08385], [-121.17922, 37.08431], [-121.17713, 37.08548], [-121.17606, 37.08487], [-121.17821, 37.08307], [-121.17796, 37.07874], [-121.18424, 37.07983], [-121.18605, 37.07761], [-121.18322, 37.07575], [-121.18084, 37.07492], [-121.1802, 37.06942], [-121.18417, 37.07149], [-121.19435, 37.07428], [-121.19578, 37.0731], [-121.18894, 37.06847], [-121.18034, 37.06541], [-121.18358, 37.06544], [-121.18861, 37.06533], [-121.19068, 37.06551], [-121.1916, 37.06583], [-121.19232, 37.06645], [-121.19305, 37.06654], [-121.19453, 37.06725], [-121.195, 37.0677], [-121.1973, 37.06844], [-121.19909, 37.06839], [-121.201, 37.06716], [-121.2009, 37.06662], [-121.20154, 37.0658], [-121.20221, 37.06557], [-121.20246, 37.06481], [-121.20495, 37.06328], [-121.20792, 37.06482], [-121.20995, 37.06498], [-121.21014, 37.06529], [-121.21023, 37.06551], [-121.21019, 37.06568], [-121.21011, 37.06588], [-121.20996, 37.06606], [-121.20975, 37.06625], [-121.20933, 37.06659], [-121.20921, 37.06685], [-121.20914, 37.0671], [-121.2092, 37.06737], [-121.20941, 37.06751], [-121.20965, 37.06762], [-121.20996, 37.0677], [-121.2103, 37.06774], [-121.21065, 37.06784], [-121.21158, 37.06825], [-121.21174, 37.06826], [-121.21318, 37.06774], [-121.21347, 37.06769], [-121.21381, 37.06769], [-121.21406, 37.06776]]]} | Open Access 1 | 17305 | San Luis Reservoir Wildlife Area | 30500 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Merced 37 | 861.266 | San Luis Reservoir Wildlife Area | 1974 | State Conservation Area 8 | 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]);