units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where COUNTY = 26 and MNG_AGENCY = 51
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3803 | 3803 | 3802 | {"type": "MultiPolygon", "coordinates": [[[[-122.10658, 38.5004], [-122.09761, 38.50035], [-122.09774, 38.50434], [-122.09775, 38.50723], [-122.09305, 38.50723], [-122.093, 38.50397], [-122.09232, 38.49092], [-122.09697, 38.4909], [-122.09687, 38.4893], [-122.09688, 38.48804], [-122.0969, 38.48794], [-122.09688, 38.4865], [-122.09693, 38.48236], [-122.10164, 38.48238], [-122.10165, 38.48207], [-122.10631, 38.48211], [-122.10633, 38.48923], [-122.1065, 38.49317], [-122.10655, 38.49628], [-122.10658, 38.5004]]], [[[-122.1064, 38.50769], [-122.10633, 38.50813], [-122.10619, 38.50846], [-122.1061, 38.5086], [-122.10598, 38.5087], [-122.10582, 38.50877], [-122.10572, 38.50879], [-122.10561, 38.50879], [-122.10518, 38.50894], [-122.10504, 38.50897], [-122.10464, 38.50918], [-122.10452, 38.50932], [-122.10427, 38.5095], [-122.1042, 38.50947], [-122.10212, 38.50969], [-122.10231, 38.50753], [-122.10582, 38.50758], [-122.1064, 38.50769]]]]} | Restricted Access 2 | 35111 | Stebbins Cold Canyon Reserve | 25816 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Solano 26 | 606.446 | Stebbins Cold Canyon Reserve | 0 | State Conservation Area 8 | 2 | |
| 9930 | 9930 | 9929 | {"type": "Polygon", "coordinates": [[[-121.84235, 38.25685], [-121.83602, 38.26394], [-121.83312, 38.26707], [-121.83311, 38.2711], [-121.82945, 38.27111], [-121.82645, 38.27432], [-121.82358, 38.27798], [-121.82356, 38.28536], [-121.82097, 38.28535], [-121.81442, 38.28518], [-121.81447, 38.28517], [-121.81448, 38.28333], [-121.81451, 38.28254], [-121.81452, 38.27627], [-121.80554, 38.27616], [-121.80553, 38.27613], [-121.8053, 38.27616], [-121.80552, 38.25635], [-121.82403, 38.25652], [-121.82404, 38.25691], [-121.84235, 38.25685]]]} | Restricted Access 2 | 17078 | Jepson Prairie Reserve | 33186 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 217 | University of California 51 | State 5 | State Agency 5 | Solano 26 | 1546.442 | Jepson Prairie Reserve | 0 | State Conservation Area 8 | 2 | |
| 11287 | 11287 | 11286 | {"type": "MultiPolygon", "coordinates": [[[[-121.75699, 38.51703], [-121.75697, 38.51836], [-121.75692, 38.51824], [-121.75685, 38.51815], [-121.75673, 38.5181], [-121.75649, 38.51805], [-121.75317, 38.51763], [-121.75268, 38.51755], [-121.75246, 38.51753], [-121.75205, 38.51753], [-121.75187, 38.51754], [-121.75157, 38.51761], [-121.7512, 38.51763], [-121.74956, 38.51765], [-121.74832, 38.51762], [-121.74759, 38.51766], [-121.74722, 38.51765], [-121.74666, 38.51773], [-121.74532, 38.518], [-121.7443, 38.51814], [-121.74362, 38.5182], [-121.74052, 38.51828], [-121.73603, 38.51837], [-121.73603, 38.51729], [-121.74998, 38.51721], [-121.75019, 38.51722], [-121.75019, 38.51532], [-121.75511, 38.51533], [-121.75694, 38.5155], [-121.75693, 38.51703], [-121.75699, 38.51703]]], [[[-121.76097, 38.51739], [-121.76006, 38.51843], [-121.75913, 38.51832], [-121.75904, 38.5183], [-121.75863, 38.51828], [-121.75754, 38.51816], [-121.75727, 38.51816], [-121.75715, 38.51821], [-121.75707, 38.51832], [-121.75704, 38.51831], [-121.75704, 38.51828], [-121.75706, 38.51702], [-121.75755, 38.51691], [-121.75843, 38.51664], [-121.75878, 38.51658], [-121.75898, 38.51658], [-121.75928, 38.5167], [-121.75956, 38.51687], [-121.75981, 38.51698], [-121.76073, 38.51727], [-121.76097, 38.51739]]], [[[-121.77089, 38.51779], [-121.77044, 38.51813], [-121.77009, 38.51842], [-121.7697, 38.51852], [-121.76947, 38.51856], [-121.76771, 38.51878], [-121.76634, 38.51889], [-121.76399, 38.51899], [-121.76264, 38.51895], [-121.76206, 38.51888], [-121.76141, 38.51873], [-121.76093, 38.51859], [-121.7607, 38.51857], [-121.76034, 38.51847], [-121.76016, 38.51844], [-121.76105, 38.51743], [-121.76119, 38.5175], [-121.76145, 38.51753], [-121.76227, 38.51756], [-121.76251, 38.51759], [-121.76346, 38.51758], [-121.76378, 38.51753], [-121.76414, 38.51747], [-121.76455, 38.51742], [-121.76572, 38.51737], [-121.76747, 38.51724], [-121.76764, 38.51725], [-121.7703, 38.51761], [-121.77089, 38.51779]]], [[[-121.78397, 38.52325], [-121.78363, 38.52355], [-121.7837, 38.52387], [-121.78274, 38.52399], [-121.78249, 38.52399], [-121.78229, 38.52396], [-121.78093, 38.52354], [-121.78057, 38.5234], [-121.78026, 38.52324], [-121.77342, 38.51964], [-121.77204, 38.51897], [-121.77195, 38.51896], [-121.77189, 38.51899], [-121.77187, 38.51898], [-121.77254, 38.51835], [-121.77264, 38.5183], [-121.77285, 38.51839], [-121.7733, 38.51865], [-121.77383, 38.51887], [-121.77398, 38.519], [-121.77426, 38.51917], [-121.77518, 38.51962], [-121.77547, 38.51987], [-121.77588, 38.52002], [-121.77621, 38.52021], [-121.77625, 38.52028], [-121.77629, 38.5203], [-121.77654, 38.52029], [-121.77697, 38.52042], [-121.7771, 38.52048], [-121.77734, 38.52062], [-121.77736, 38.52066], [-121.77735, 38.52076], [-121.77768, 38.52098], [-121.77772, 38.52104], [-121.77788, 38.52111], [-121.77793, 38.52117], [-121.77812, 38.5213], [-121.77847, 38.52147], [-121.77865, 38.52165], [-121.7788, 38.52176], [-121.77891, 38.52189], [-121.77936, 38.5222], [-121.77961, 38.52243], [-121.77984, 38.52253], [-121.78114, 38.52306], [-121.78152, 38.52312], [-121.782, 38.52312], [-121.7824, 38.52317], [-121.78397, 38.52325]]], [[[-121.78388, 38.5251], [-121.78364, 38.52523], [-121.78353, 38.52607], [-121.78304, 38.52603], [-121.78293, 38.52649], [-121.78283, 38.52648], [-121.78288, 38.52627], [-121.78292, 38.52596], [-121.78295, 38.52562], [-121.78294, 38.52546], [-121.78288, 38.52518], [-121.78253, 38.52433], [-121.78251, 38.52423], [-121.78252, 38.52418], [-121.78255, 38.52412], [-121.78258, 38.52409], [-121.78264, 38.52407], [-121.78305, 38.52401], [-121.78319, 38.52471], [-121.78304, 38.52473], [-121.78308, 38.52495], [-121.78379, 38.52489], [-121.78388, 38.5251]]]]} | Restricted Access 2 | 21914 | Putah Creek Riparian Reserve | 24035 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Solano 26 | 136.113 | Putah Creek Riparian Reserve | 0 | 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]);