units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where DES_TP = 8, MNG_AG_TYP = 5 and YR_EST = 1990
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, PARK_URL, COUNTY, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5838 | 5838 | 5837 | {"type": "MultiPolygon", "coordinates": [[[[-120.19624, 36.73443], [-120.18674, 36.73448], [-120.17316, 36.73451], [-120.17319, 36.71998], [-120.19608, 36.71999], [-120.19624, 36.73443]]], [[[-120.20506, 36.73468], [-120.2048, 36.74922], [-120.18653, 36.74912], [-120.17739, 36.74918], [-120.17765, 36.73475], [-120.18677, 36.73478], [-120.20506, 36.73468]]]]} | Open Access 1 | 21960 | Kerman Ecological Reserve | 32193 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Kerman-ER | Fresno 9 | 1784.445 | Kerman ER | 1990 | State Conservation Area 8 | 2 |
11297 | 11297 | 11296 | {"type": "MultiPolygon", "coordinates": [[[[-120.64201, 40.56747], [-120.63854, 40.5702], [-120.6383, 40.57005], [-120.63565, 40.5709], [-120.63328, 40.57222], [-120.63034, 40.57582], [-120.62598, 40.57702], [-120.61664, 40.58054], [-120.61739, 40.58262], [-120.60854, 40.58242], [-120.60855, 40.58605], [-120.60387, 40.58598], [-120.60382, 40.58599], [-120.60384, 40.5896], [-120.59907, 40.58953], [-120.599, 40.57866], [-120.59426, 40.57858], [-120.59412, 40.56773], [-120.58939, 40.56764], [-120.58939, 40.56035], [-120.58464, 40.56027], [-120.58448, 40.55315], [-120.58683, 40.55322], [-120.58676, 40.55043], [-120.58894, 40.54947], [-120.58887, 40.54559], [-120.59366, 40.54569], [-120.59381, 40.54925], [-120.59838, 40.5493], [-120.59854, 40.55339], [-120.60337, 40.55344], [-120.60345, 40.557], [-120.62612, 40.55715], [-120.63537, 40.55731], [-120.63543, 40.5592], [-120.63402, 40.55969], [-120.63304, 40.56167], [-120.62611, 40.56304], [-120.62411, 40.5657], [-120.62613, 40.56521], [-120.63142, 40.56473], [-120.63159, 40.56463], [-120.63281, 40.56396], [-120.63552, 40.56302], [-120.63985, 40.56248], [-120.64187, 40.56619], [-120.64201, 40.56676], [-120.64201, 40.56747]]], [[[-120.62616, 40.58146], [-120.6261, 40.58187], [-120.62537, 40.58223], [-120.62489, 40.58168], [-120.62528, 40.58151], [-120.62557, 40.58173], [-120.62616, 40.58146]]], [[[-120.62676, 40.58089], [-120.6264, 40.58127], [-120.62604, 40.58075], [-120.62633, 40.58047], [-120.62676, 40.58089]]]]} | Open Access 1 | 21996 | Willow Creek Wildlife Area | 30522 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Willow-Creek-WA | Lassen 54 | 2753.484 | Willow Creek Wildlife Area | 1990 | State Conservation Area 8 | 2 |
15578 | 15578 | 15577 | {"type": "Polygon", "coordinates": [[[-120.79972, 36.68843], [-120.79051, 36.68826], [-120.79072, 36.68476], [-120.78171, 36.68455], [-120.78187, 36.67755], [-120.78639, 36.67756], [-120.78647, 36.66694], [-120.79072, 36.66697], [-120.79095, 36.67402], [-120.79963, 36.67422], [-120.79959, 36.68136], [-120.79972, 36.68843]]]} | Open Access 1 | 7984 | Panoche Hills Ecological Reserve | 32255 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Panoche-Hills-ER | Fresno 9 | 580.503 | Panoche Hills ER | 1990 | State Conservation Area 8 | 2 |
15580 | 15580 | 15579 | {"type": "MultiPolygon", "coordinates": [[[[-119.75149, 36.93449], [-119.75004, 36.93665], [-119.74807, 36.93775], [-119.7476, 36.93775], [-119.74664, 36.93813], [-119.74654, 36.93847], [-119.74512, 36.93902], [-119.74305, 36.94171], [-119.7421, 36.94133], [-119.74269, 36.94065], [-119.7424, 36.93959], [-119.74382, 36.93938], [-119.74593, 36.93776], [-119.74592, 36.93775], [-119.74577, 36.93775], [-119.74638, 36.93737], [-119.74673, 36.93674], [-119.74919, 36.93511], [-119.74916, 36.93178], [-119.74932, 36.93147], [-119.74951, 36.9313], [-119.74939, 36.93079], [-119.74911, 36.93064], [-119.74862, 36.93047], [-119.74793, 36.93041], [-119.7478, 36.93035], [-119.7472, 36.93076], [-119.74686, 36.93149], [-119.74685, 36.93201], [-119.74447, 36.93198], [-119.74333, 36.93159], [-119.74307, 36.93144], [-119.74177, 36.93195], [-119.73788, 36.93198], [-119.73781, 36.93219], [-119.73633, 36.93306], [-119.73427, 36.93358], [-119.73336, 36.93373], [-119.73044, 36.93311], [-119.73041, 36.93239], [-119.73061, 36.9316], [-119.73124, 36.9316], [-119.73126, 36.93255], [-119.73127, 36.93256], [-119.73161, 36.93254], [-119.73234, 36.93241], [-119.73304, 36.93225], [-119.73373, 36.93202], [-119.73406, 36.9319], [-119.73472, 36.9316], [-119.73979, 36.93156], [-119.74062, 36.93058], [-119.74138, 36.92971], [-119.74139, 36.9284], [-119.73931, 36.92732], [-119.73829, 36.92685], [-119.73672, 36.92627], [-119.73336, 36.92534], [-119.73339, 36.92527], [-119.73343, 36.9251], [-119.73343, 36.92504], [-119.73346, 36.92494], [-119.73358, 36.92405], [-119.7336, 36.92358], [-119.7341, 36.92354], [-119.73415, 36.92309], [-119.73918, 36.92306], [-119.73922, 36.92508], [-119.74372, 36.92507], [-119.74824, 36.92503], [-119.74827, 36.92686], [-119.75016, 36.92688], [-119.74997, 36.9272], [-119.74985, 36.92744], [-119.74977, 36.92779], [-119.74975, 36.92803], [-119.74978, 36.92809], [-119.74976, 36.92817], [-119.74967, 36.92829], [-119.74964, 36.9285], [-119.74964, 36.92858], [-119.74971, 36.92881], [-119.74987, 36.92909], [-119.74996, 36.92922], [-119.75003, 36.9294], [-119.75013, 36.92954], [-119.75019, 36.92969], [-119.75029, 36.92983], [-119.75034, 36.92994], [-119.75092, 36.93166], [-119.75089, 36.93182], [-119.75148, 36.93286], [-119.75149, 36.93449]]], [[[-119.77586, 36.91001], [-119.77555, 36.91048], [-119.77537, 36.91107], [-119.77446, 36.91292], [-119.7743, 36.91345], [-119.7743, 36.91431], [-119.77434, 36.91462], [-119.77429, 36.91505], [-119.77468, 36.91557], [-119.77477, 36.9159], [-119.77478, 36.91651], [-119.77441, 36.91741], [-119.77414, 36.91775], [-119.77314, 36.91823], [-119.77191, 36.91894], [-119.77042, 36.91939], [-119.76929, 36.91916], [-119.76793, 36.91875], [-119.76641, 36.91867], [-119.76577, 36.91878], [-119.76381, 36.91944], [-119.76246, 36.91996], [-119.76108, 36.91989], [-119.75946, 36.92006], [-119.75867, 36.92023], [-119.75865, 36.91991], [-119.75717, 36.91859], [-119.75586, 36.91748], [-119.75488, 36.91848], [-119.75433, 36.91911], [-119.75368, 36.91952], [-119.75344, 36.91935], [-119.75444, 36.91854], [-119.75504, 36.91767], [-119.75617, 36.91681], [-119.75693, 36.91639], [-119.75802, 36.91625], [-119.75862, 36.91606], [-119.75941, 36.91527], [-119.76011, 36.91496], [-119.7616, 36.91462], [-119.76287, 36.91421], [-119.76437, 36.91389], [-119.76516, 36.91395], [-119.76595, 36.91382], [-119.76732, 36.91341], [-119.76817, 36.91294], [-119.76874, 36.91139], [-119.76938, 36.91059], [-119.76964, 36.91015], [-119.77586, 36.91001]]], [[[-119.87928, 36.85578], [-119.87603, 36.85449], [-119.87533, 36.85429], [-119.87396, 36.85226], [-119.87062, 36.85148], [-119.86577, 36.85146], [-119.86576, 36.85122], [-119.86509, 36.85136], [-119.86496, 36.85146], [-119.86358, 36.85295], [-119.86216, 36.85392], [-119.86103, 36.85445], [-119.86019, 36.85415], [-119.85874, 36.85339], [-119.85886, 36.85305], [-119.86222, 36.85338], [-119.86251, 36.85301], [-119.86385, 36.85146], [-119.86576, 36.85078], [-119.86576, 36.84991], [-119.86568, 36.84623], [-119.86566, 36.84345], [-119.86698, 36.84314], [-119.86842, 36.84288], [-119.86992, 36.84279], [-119.87089, 36.84285], [-119.87165, 36.84313], [-119.87233, 36.84359], [-119.87239, 36.84365], [-119.87268, 36.84386], [-119.87294, 36.84402], [-119.87323, 36.84413], [-119.8736, 36.84431], [-119.87451, 36.84449], [-119.87477, 36.84458], [-119.8748, 36.84467], [-119.87606, 36.84495], [-119.87648, 36.845], [-119.87669, 36.8449], [-119.87925, 36.84684], [-119.87928, 36.85578]]], [[[-119.93262, 36.84369], [-119.93119, 36.84553], [-119.92798, 36.84853], [-119.92581, 36.84638], [-119.92803, 36.84555], [-119.93144, 36.84307], [-119.93262, 36.84369]]]]} | Open Access 1 | 8353 | San Joaquin River Ecological Reserve | 32295 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Joaquin-River-ER | Fresno 9 | 875.667 | San Joaquin River ER | 1990 | State Conservation Area 8 | 2 |
15628 | 15628 | 15627 | {"type": "Polygon", "coordinates": [[[-119.87533, 36.85429], [-119.87123, 36.85253], [-119.87062, 36.85148], [-119.87396, 36.85227], [-119.87533, 36.85429]]]} | Restricted Access 2 | 28125 | San Joaquin River Ecological Reserve | 24913 | 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/San-Joaquin-River-ER | Fresno 9 | 10.874 | San Joaquin River ER | 1990 | 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]);