units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 2, COUNTY = 15 and DES_TP = 8
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID
MNG_AGENCY 2
MNG_AG_TYP 1
DES_TP 1
- State Conservation Area · 3 ✖
ACCESS_TYP 1
- Restricted Access · 3 ✖
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 | |
15625 | 15625 | 15624 | {"type": "MultiPolygon", "coordinates": [[[[-122.24865, 37.51867], [-122.24743, 37.51868], [-122.24741, 37.51813], [-122.24748, 37.51813], [-122.24749, 37.51816], [-122.24862, 37.51816], [-122.24865, 37.51867]]], [[[-122.25031, 37.52028], [-122.25023, 37.52041], [-122.24962, 37.5202], [-122.24918, 37.52094], [-122.24828, 37.52218], [-122.2483, 37.52221], [-122.24792, 37.52383], [-122.24781, 37.52382], [-122.2478, 37.52386], [-122.24781, 37.5241], [-122.24786, 37.52424], [-122.24796, 37.52444], [-122.24799, 37.52472], [-122.24791, 37.52535], [-122.24786, 37.52542], [-122.24778, 37.52547], [-122.24723, 37.52548], [-122.24707, 37.52552], [-122.24692, 37.52562], [-122.24685, 37.52574], [-122.2467, 37.52589], [-122.24634, 37.52667], [-122.245, 37.52927], [-122.24342, 37.53062], [-122.24231, 37.53147], [-122.24153, 37.53184], [-122.24148, 37.53156], [-122.24182, 37.53144], [-122.24329, 37.5305], [-122.24468, 37.52927], [-122.245, 37.52866], [-122.24525, 37.52848], [-122.24547, 37.52798], [-122.24599, 37.52722], [-122.24624, 37.52667], [-122.24633, 37.52654], [-122.24643, 37.52628], [-122.24654, 37.52603], [-122.24661, 37.52577], [-122.24721, 37.52417], [-122.24776, 37.52234], [-122.24798, 37.52223], [-122.24811, 37.52205], [-122.24773, 37.52171], [-122.24828, 37.51948], [-122.24999, 37.51947], [-122.25, 37.52016], [-122.25031, 37.52028]]], [[[-122.26048, 37.53983], [-122.25986, 37.54047], [-122.25946, 37.54084], [-122.25913, 37.54101], [-122.25855, 37.5412], [-122.25804, 37.54119], [-122.25772, 37.54131], [-122.25724, 37.54136], [-122.25559, 37.54134], [-122.25503, 37.54121], [-122.25145, 37.54121], [-122.25134, 37.54061], [-122.25128, 37.54022], [-122.25111, 37.53887], [-122.25235, 37.53852], [-122.25331, 37.5382], [-122.25366, 37.53831], [-122.25397, 37.53888], [-122.25428, 37.53932], [-122.25501, 37.53978], [-122.25625, 37.54008], [-122.2566, 37.54011], [-122.25696, 37.54005], [-122.25758, 37.53973], [-122.25905, 37.53885], [-122.25959, 37.53581], [-122.25953, 37.53523], [-122.25952, 37.53411], [-122.26037, 37.53411], [-122.26039, 37.53561], [-122.26051, 37.53857], [-122.26048, 37.53983]]], [[[-122.25028, 37.5486], [-122.24616, 37.55153], [-122.24454, 37.55092], [-122.2445, 37.55056], [-122.23268, 37.5485], [-122.22913, 37.54832], [-122.22573, 37.54575], [-122.22551, 37.54456], [-122.22647, 37.54375], [-122.22746, 37.54312], [-122.228, 37.54251], [-122.22814, 37.54218], [-122.2287, 37.54152], [-122.22976, 37.53961], [-122.23149, 37.53647], [-122.23186, 37.53603], [-122.23309, 37.53486], [-122.2344, 37.53393], [-122.23498, 37.53394], [-122.23331, 37.53504], [-122.23279, 37.53595], [-122.23386, 37.53877], [-122.23243, 37.5399], [-122.23463, 37.54114], [-122.23471, 37.54139], [-122.23202, 37.54174], [-122.23135, 37.54208], [-122.22994, 37.54172], [-122.22602, 37.54478], [-122.22612, 37.54565], [-122.22864, 37.54754], [-122.22881, 37.54742], [-122.2294, 37.54785], [-122.22964, 37.54796], [-122.2339, 37.54828], [-122.23459, 37.54768], [-122.23539, 37.54826], [-122.23601, 37.54817], [-122.24311, 37.54898], [-122.2432, 37.54887], [-122.24423, 37.54895], [-122.24467, 37.54932], [-122.24458, 37.54992], [-122.24415, 37.54987], [-122.24432, 37.55035], [-122.24487, 37.55048], [-122.24483, 37.54996], [-122.24511, 37.54992], [-122.24523, 37.55013], [-122.24553, 37.54982], [-122.24629, 37.54998], [-122.24731, 37.54929], [-122.2456, 37.54832], [-122.24616, 37.54769], [-122.24856, 37.54904], [-122.2492, 37.54861], [-122.24947, 37.5484], [-122.24989, 37.54788], [-122.25022, 37.54713], [-122.25046, 37.54651], [-122.2505, 37.54636], [-122.25049, 37.54618], [-122.2501, 37.54469], [-122.24881, 37.54254], [-122.24985, 37.54224], [-122.25108, 37.54487], [-122.25117, 37.54517], [-122.25127, 37.5459], [-122.25116, 37.54638], [-122.25055, 37.54751], [-122.25015, 37.5481], [-122.24992, 37.54835], [-122.2496, 37.5486], [-122.25028, 37.5486]]], [[[-122.25278, 37.54858], [-122.25136, 37.55035], [-122.25103, 37.55059], [-122.24968, 37.55201], [-122.24686, 37.55341], [-122.24684, 37.55426], [-122.24657, 37.55451], [-122.24683, 37.55476], [-122.24681, 37.55559], [-122.24618, 37.55477], [-122.24514, 37.55598], [-122.24549, 37.55472], [-122.24616, 37.55371], [-122.24753, 37.55203], [-122.25081, 37.54981], [-122.25228, 37.54852], [-122.25251, 37.54853], [-122.25248, 37.54857], [-122.25249, 37.54858], [-122.25278, 37.54858]]]]} | Restricted Access 2 | 24423 | Redwood Shores Ecological Reserve | 24252 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Redwood-Shores-ER | San Mateo 15 | 218.064 | Redwood Shores ER | 1976 | State Conservation Area 8 | 2 |
15629 | 15629 | 15628 | {"type": "Polygon", "coordinates": [[[-122.22785, 37.5376], [-122.22781, 37.53769], [-122.22737, 37.53832], [-122.22719, 37.53867], [-122.22695, 37.53952], [-122.22669, 37.53983], [-122.22637, 37.54034], [-122.22594, 37.54065], [-122.22587, 37.54083], [-122.22572, 37.54099], [-122.22529, 37.54163], [-122.22499, 37.54186], [-122.22456, 37.54246], [-122.22451, 37.54248], [-122.22432, 37.54214], [-122.22343, 37.54263], [-122.21888, 37.5422], [-122.21566, 37.54246], [-122.21353, 37.542], [-122.20784, 37.54198], [-122.20636, 37.54134], [-122.20455, 37.54011], [-122.20733, 37.5374], [-122.20733, 37.53739], [-122.19806, 37.53143], [-122.20588, 37.52401], [-122.20775, 37.52464], [-122.20924, 37.52534], [-122.21153, 37.52598], [-122.2154, 37.52634], [-122.21659, 37.52578], [-122.21686, 37.52402], [-122.21759, 37.52322], [-122.2194, 37.52263], [-122.21975, 37.52171], [-122.21809, 37.51903], [-122.21877, 37.51801], [-122.22009, 37.51773], [-122.22005, 37.51792], [-122.22062, 37.51804], [-122.22148, 37.52435], [-122.21606, 37.52774], [-122.21381, 37.52792], [-122.21288, 37.52874], [-122.22785, 37.5376]]]} | Restricted Access 2 | 29105 | Bair Island Ecological Reserve | 15765 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bair-Island-ER | San Mateo 15 | 787.45 | Bair Island ER | 1986 | 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]);