calands: units_with_maps: 1 row where ACCESS_TYP = 2, DES_TP = 8 and UNIT_NAME = "Santa Rosa Plateau Ecological Reserve"

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where ACCESS_TYP = 2, DES_TP = 8 and UNIT_NAME = "Santa Rosa Plateau Ecological Reserve"

Search:

descending

This data as json, copyable, CSV (advanced)

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
15620	15620	15619	{"type": "MultiPolygon", "coordinates": [[[[-117.29691, 33.50922], [-117.29443, 33.50925], [-117.29366, 33.50656], [-117.29686, 33.50664], [-117.29691, 33.50922]]], [[[-117.30422, 33.51102], [-117.30312, 33.51228], [-117.30368, 33.51239], [-117.303, 33.51312], [-117.30271, 33.51322], [-117.30252, 33.51335], [-117.30249, 33.5134], [-117.30241, 33.51367], [-117.30233, 33.51377], [-117.30222, 33.51386], [-117.30211, 33.51393], [-117.30192, 33.51401], [-117.30179, 33.5141], [-117.30168, 33.51422], [-117.30163, 33.51432], [-117.30151, 33.51438], [-117.3001, 33.51427], [-117.3002, 33.51413], [-117.30163, 33.51258], [-117.30174, 33.51242], [-117.30178, 33.51231], [-117.3018, 33.51212], [-117.30169, 33.51097], [-117.30171, 33.51072], [-117.30173, 33.51061], [-117.30179, 33.51047], [-117.30185, 33.51044], [-117.30196, 33.51045], [-117.30211, 33.51043], [-117.30222, 33.5104], [-117.30241, 33.51031], [-117.3026, 33.51027], [-117.30273, 33.51026], [-117.30292, 33.51029], [-117.30304, 33.51033], [-117.30396, 33.51075], [-117.30411, 33.51086], [-117.30422, 33.51102]]], [[[-117.30682, 33.48342], [-117.30671, 33.48384], [-117.30668, 33.4842], [-117.3067, 33.48445], [-117.30681, 33.48526], [-117.30682, 33.48547], [-117.30678, 33.48578], [-117.30672, 33.48598], [-117.30664, 33.48618], [-117.30653, 33.48637], [-117.3064, 33.48655], [-117.30459, 33.48881], [-117.30434, 33.48908], [-117.30405, 33.48934], [-117.30282, 33.48822], [-117.30539, 33.48498], [-117.30585, 33.48446], [-117.30682, 33.48342]]], [[[-117.31602, 33.50967], [-117.31583, 33.51591], [-117.31468, 33.51586], [-117.3134, 33.51573], [-117.31277, 33.51564], [-117.30935, 33.51506], [-117.3095, 33.51398], [-117.31151, 33.51178], [-117.31074, 33.51132], [-117.30996, 33.51076], [-117.30875, 33.51199], [-117.30459, 33.5112], [-117.30457, 33.51113], [-117.30441, 33.51095], [-117.30433, 33.51084], [-117.30415, 33.51066], [-117.30657, 33.51076], [-117.30871, 33.50862], [-117.3119, 33.50877], [-117.31204, 33.50873], [-117.31335, 33.50519], [-117.31602, 33.50967]]], [[[-117.32402, 33.49267], [-117.32243, 33.49476], [-117.31894, 33.49287], [-117.31878, 33.49351], [-117.31866, 33.49348], [-117.31854, 33.4935], [-117.31846, 33.49356], [-117.31848, 33.49368], [-117.31856, 33.49373], [-117.31596, 33.49402], [-117.3132, 33.49064], [-117.3083, 33.49327], [-117.3042, 33.48946], [-117.30492, 33.4887], [-117.30523, 33.48833], [-117.30608, 33.48721], [-117.30659, 33.48659], [-117.30682, 33.48629], [-117.30689, 33.4861], [-117.30698, 33.4859], [-117.30934, 33.48625], [-117.30964, 33.48626], [-117.30978, 33.48625], [-117.30998, 33.4863], [-117.3101, 33.48625], [-117.31019, 33.48617], [-117.31013, 33.48608], [-117.31001, 33.48605], [-117.3099, 33.48608], [-117.30963, 33.48613], [-117.30929, 33.48608], [-117.30709, 33.48574], [-117.30703, 33.48566], [-117.30705, 33.48544], [-117.30698, 33.48461], [-117.30697, 33.48376], [-117.30721, 33.48315], [-117.30742, 33.48289], [-117.30759, 33.48275], [-117.31294, 33.48675], [-117.31524, 33.48853], [-117.31715, 33.4866], [-117.31719, 33.48657], [-117.32346, 33.49117], [-117.32288, 33.4918], [-117.32402, 33.49267]]], [[[-117.33472, 33.4949], [-117.33416, 33.49536], [-117.33374, 33.49581], [-117.33365, 33.49597], [-117.33356, 33.49623], [-117.33351, 33.49662], [-117.32591, 33.49765], [-117.32575, 33.49765], [-117.32222, 33.49646], [-117.32227, 33.49633], [-117.32248, 33.49528], [-117.32262, 33.49499], [-117.32333, 33.49408], [-117.32339, 33.49407], [-117.32407, 33.4944], [-117.32433, 33.49449], [-117.32521, 33.49472], [-117.32551, 33.49484], [-117.32559, 33.49484], [-117.32566, 33.49478], [-117.32569, 33.4947], [-117.32567, 33.49465], [-117.3256, 33.49459], [-117.32553, 33.49457], [-117.32528, 33.49456], [-117.32427, 33.4943], [-117.32404, 33.49421], [-117.32356, 33.49396], [-117.32348, 33.49387], [-117.32452, 33.49255], [-117.32476, 33.49229], [-117.32496, 33.49214], [-117.32529, 33.49197], [-117.32566, 33.49186], [-117.32592, 33.49182], [-117.32632, 33.49183], [-117.33029, 33.49216], [-117.33068, 33.49221], [-117.33101, 33.49229], [-117.33155, 33.49246], [-117.3319, 33.49263], [-117.33222, 33.49282], [-117.33304, 33.49347], [-117.33472, 33.4949]]], [[[-117.33364, 33.50621], [-117.333, 33.507], [-117.33283, 33.50726], [-117.33255, 33.50758], [-117.32478, 33.50323], [-117.32545, 33.50184], [-117.3255, 33.50169], [-117.33364, 33.50621]]], [[[-117.33772, 33.50251], [-117.33705, 33.50292], [-117.33622, 33.50346], [-117.33563, 33.50294], [-117.33546, 33.50276], [-117.33527, 33.50254], [-117.33508, 33.50225], [-117.33488, 33.50192], [-117.33455, 33.50105], [-117.33423, 33.49964], [-117.33642, 33.49965], [-117.33636, 33.5007], [-117.33772, 33.50251]]], [[[-117.34065, 33.50668], [-117.33987, 33.50717], [-117.33667, 33.50408], [-117.33722, 33.50368], [-117.33762, 33.50343], [-117.33864, 33.50448], [-117.33868, 33.50464], [-117.33873, 33.50472], [-117.33897, 33.50474], [-117.33904, 33.50461], [-117.339, 33.50449], [-117.33886, 33.50441], [-117.33876, 33.50431], [-117.33784, 33.5033], [-117.33866, 33.50282], [-117.33894, 33.50274], [-117.3393, 33.50256], [-117.33949, 33.50245], [-117.33994, 33.50227], [-117.34, 33.50231], [-117.34064, 33.50368], [-117.34055, 33.50372], [-117.33997, 33.50393], [-117.33957, 33.50403], [-117.33949, 33.50414], [-117.33953, 33.50427], [-117.34065, 33.50668]]], [[[-117.34556, 33.50156], [-117.34541, 33.50193], [-117.34536, 33.50228], [-117.34543, 33.50264], [-117.34549, 33.50274], [-117.34158, 33.50425], [-117.34161, 33.50612], [-117.34156, 33.50612], [-117.34147, 33.50618], [-117.34137, 33.50627], [-117.34097, 33.50656], [-117.34081, 33.50656], [-117.34065, 33.50616], [-117.34054, 33.50594], [-117.33978, 33.50417], [-117.33992, 33.50413], [-117.34053, 33.50391], [-117.3408, 33.50389], [-117.34089, 33.50378], [-117.34091, 33.50366], [-117.34086, 33.50358], [-117.34078, 33.5035], [-117.34028, 33.50237], [-117.34027, 33.50217], [-117.34045, 33.50212], [-117.34072, 33.502], [-117.3412, 33.50186], [-117.34155, 33.50179], [-117.34317, 33.50141], [-117.3437, 33.50133], [-117.34452, 33.50133], [-117.34498, 33.5014], [-117.34541, 33.50151], [-117.34556, 33.50156]]], [[[-117.35154, 33.50447], [-117.35082, 33.5055], [-117.35061, 33.50561], [-117.35037, 33.50566], [-117.35013, 33.50565], [-117.34987, 33.50557], [-117.34969, 33.50541], [-117.34955, 33.50519], [-117.34907, 33.50416], [-117.34886, 33.50397], [-117.3487, 33.50387], [-117.34843, 33.50384], [-117.34765, 33.50384], [-117.34745, 33.5038], [-117.3473, 33.50371], [-117.34719, 33.50359], [-117.34705, 33.50346], [-117.34683, 33.50335], [-117.34629, 33.50317], [-117.34601, 33.50304], [-117.34582, 33.50292], [-117.34566, 33.50272], [-117.34556, 33.50248], [-117.34554, 33.50222], [-117.34562, 33.50191], [-117.34577, 33.50162], [-117.34619, 33.50181], [-117.34652, 33.50192], [-117.3472, 33.50231], [-117.34796, 33.50266], [-117.34952, 33.50347], [-117.35029, 33.50381], [-117.35154, 33.50447]]], [[[-117.35429, 33.50591], [-117.35306, 33.50668], [-117.35206, 33.5065], [-117.35204, 33.50638], [-117.35195, 33.5063], [-117.35178, 33.50624], [-117.35106, 33.50551], [-117.35172, 33.50458], [-117.35251, 33.50497], [-117.35429, 33.50591]]], [[[-117.36579, 33.50162], [-117.36439, 33.50466], [-117.3635, 33.50465], [-117.3628, 33.50619], [-117.36176, 33.5088], [-117.35747, 33.5067], [-117.35318, 33.50452], [-117.35375, 33.50444], [-117.35434, 33.50422], [-117.35495, 33.50386], [-117.35539, 33.50351], [-117.35578, 33.50295], [-117.35602, 33.50239], [-117.35604, 33.50175], [-117.35596, 33.50113], [-117.35591, 33.5005], [-117.35585, 33.49994], [-117.35989, 33.49968], [-117.36579, 33.50162]]]]}	Restricted Access 2	47975	Santa Rosa Plateau Ecological Reserve	25137	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		Riverside 10	905.397	Santa Rosa Plateau ER	1994	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]);