calands: units_with_maps: 4 rows where ACCESS_TYP = 3, COUNTY = 4 and GAP

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

4 rows where ACCESS_TYP = 3, COUNTY = 4 and GAP_STS = 3

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
3678	3678	3677	{"type": "Polygon", "coordinates": [[[-117.17431, 33.05469], [-117.17231, 33.05468], [-117.17229, 33.05456], [-117.17224, 33.05445], [-117.17216, 33.05434], [-117.17206, 33.05426], [-117.17194, 33.05419], [-117.17181, 33.05416], [-117.17142, 33.05413], [-117.17121, 33.05407], [-117.17104, 33.05396], [-117.17068, 33.05363], [-117.17054, 33.05374], [-117.17047, 33.05382], [-117.1704, 33.05399], [-117.17038, 33.05408], [-117.1704, 33.05417], [-117.17059, 33.05467], [-117.17004, 33.05467], [-117.16999, 33.05106], [-117.172, 33.05106], [-117.17202, 33.0523], [-117.17429, 33.0523], [-117.17431, 33.05469]]]}	No Public Access 3	44356	Escondido Creek	32162	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	San Diego 4	29.504	Escondido Creek	State Resource Management Area 55	3
4196	4196	4195	{"type": "Polygon", "coordinates": [[[-116.88012, 33.16121], [-116.87559, 33.16121], [-116.87567, 33.15391], [-116.88007, 33.1539], [-116.88011, 33.15824], [-116.88012, 33.16121]]]}	No Public Access 3	47685	Pamo Watershed	31421	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2	San Diego 4	83.475	Pamo Watershed	Local Resource Management Area 83	3
6243	6243	6242	{"type": "Polygon", "coordinates": [[[-116.96211, 32.96295], [-116.95351, 32.96324], [-116.95342, 32.95961], [-116.94888, 32.95974], [-116.94878, 32.95602], [-116.94045, 32.9561], [-116.94043, 32.95977], [-116.93185, 32.95964], [-116.93185, 32.95601], [-116.92761, 32.95596], [-116.92763, 32.95203], [-116.93186, 32.95198], [-116.93182, 32.94121], [-116.92765, 32.94122], [-116.92248, 32.94033], [-116.9225, 32.94032], [-116.92218, 32.93627], [-116.92764, 32.93755], [-116.92764, 32.93401], [-116.93615, 32.93378], [-116.93618, 32.93562], [-116.94046, 32.93556], [-116.94047, 32.93366], [-116.9447, 32.93354], [-116.94886, 32.93352], [-116.94892, 32.94093], [-116.95334, 32.9409], [-116.9534, 32.94251], [-116.95366, 32.94251], [-116.95404, 32.94257], [-116.95419, 32.94253], [-116.95424, 32.9425], [-116.95433, 32.94237], [-116.95436, 32.94199], [-116.95436, 32.94189], [-116.95434, 32.94179], [-116.95417, 32.94158], [-116.95413, 32.94147], [-116.95414, 32.94141], [-116.95421, 32.94125], [-116.9543, 32.94118], [-116.95462, 32.94098], [-116.95478, 32.94093], [-116.9549, 32.9409], [-116.95518, 32.94089], [-116.95541, 32.94094], [-116.95553, 32.94095], [-116.95568, 32.94125], [-116.95518, 32.94132], [-116.95504, 32.94139], [-116.95494, 32.94146], [-116.95486, 32.94158], [-116.95481, 32.94169], [-116.95481, 32.94184], [-116.95484, 32.94192], [-116.95488, 32.94211], [-116.95483, 32.94232], [-116.95478, 32.94241], [-116.9547, 32.94251], [-116.95461, 32.94259], [-116.95445, 32.94268], [-116.95429, 32.94272], [-116.95411, 32.94274], [-116.95366, 32.94268], [-116.95324, 32.94271], [-116.95308, 32.94269], [-116.95286, 32.94263], [-116.9527, 32.94263], [-116.95253, 32.94268], [-116.9524, 32.94276], [-116.9513, 32.94378], [-116.95115, 32.94389], [-116.95109, 32.94392], [-116.95165, 32.94469], [-116.94886, 32.94473], [-116.94889, 32.95222], [-116.95298, 32.9522], [-116.95323, 32.95222], [-116.95318, 32.94851], [-116.95783, 32.94845], [-116.95798, 32.95947], [-116.96207, 32.95939], [-116.96211, 32.96295]]]}	No Public Access 3	1316	San Vicente Highlands	32296	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	San Diego 4	1545.08	San Vicente Highlands	State Resource Management Area 55	3
12161	12161	12160	{"type": "MultiPolygon", "coordinates": [[[[-116.89905, 32.95333], [-116.89, 32.95344], [-116.88151, 32.95355], [-116.8816, 32.96148], [-116.88116, 32.9615], [-116.88115, 32.96152], [-116.885, 32.9652], [-116.88908, 32.96899], [-116.88886, 32.96915], [-116.88806, 32.96953], [-116.88748, 32.96988], [-116.88714, 32.97015], [-116.88637, 32.97047], [-116.88496, 32.97038], [-116.88394, 32.97102], [-116.88384, 32.97134], [-116.88348, 32.97175], [-116.88356, 32.97201], [-116.88313, 32.97251], [-116.88289, 32.97259], [-116.88262, 32.97308], [-116.88259, 32.97326], [-116.88268, 32.9735], [-116.8831, 32.97377], [-116.88302, 32.97416], [-116.883, 32.9744], [-116.88309, 32.97464], [-116.88333, 32.97482], [-116.88365, 32.97502], [-116.88396, 32.9752], [-116.8848, 32.97528], [-116.88502, 32.97532], [-116.88523, 32.97541], [-116.8854, 32.97555], [-116.88529, 32.97581], [-116.88538, 32.97593], [-116.88558, 32.97612], [-116.88559, 32.97621], [-116.88546, 32.97641], [-116.88497, 32.9773], [-116.88513, 32.97767], [-116.88546, 32.97779], [-116.88569, 32.97807], [-116.88589, 32.97851], [-116.88585, 32.97869], [-116.88572, 32.97887], [-116.88574, 32.97923], [-116.88615, 32.98011], [-116.88646, 32.98026], [-116.88664, 32.98061], [-116.88691, 32.98074], [-116.88704, 32.98091], [-116.8871, 32.98113], [-116.88712, 32.98177], [-116.88739, 32.98276], [-116.88724, 32.98301], [-116.88737, 32.98363], [-116.88727, 32.98413], [-116.88743, 32.98493], [-116.88738, 32.98527], [-116.88734, 32.98618], [-116.88744, 32.98643], [-116.88739, 32.98664], [-116.88719, 32.98685], [-116.88719, 32.98709], [-116.88736, 32.98767], [-116.88731, 32.98807], [-116.8875, 32.98843], [-116.88729, 32.98881], [-116.88741, 32.98924], [-116.88717, 32.98984], [-116.88666, 32.99058], [-116.88661, 32.99098], [-116.88658, 32.99111], [-116.88666, 32.99133], [-116.88665, 32.9917], [-116.88654, 32.99221], [-116.88662, 32.99234], [-116.8864, 32.9939], [-116.87774, 32.99394], [-116.87771, 32.99394], [-116.8777, 32.99389], [-116.87565, 32.99388], [-116.87531, 32.98531], [-116.86673, 32.98548], [-116.86689, 32.99385], [-116.85049, 32.99367], [-116.85066, 32.99357], [-116.85055, 32.99344], [-116.85028, 32.99359], [-116.85006, 32.99368], [-116.8499, 32.99368], [-116.84983, 32.99285], [-116.84955, 32.98892], [-116.8484, 32.98898], [-116.84841, 32.98896], [-116.84841, 32.98895], [-116.84131, 32.98865], [-116.84128, 32.97835], [-116.84039, 32.96417], [-116.84829, 32.96324], [-116.84847, 32.94951], [-116.85033, 32.95109], [-116.85343, 32.95285], [-116.8537, 32.95281], [-116.85377, 32.95285], [-116.85671, 32.95243], [-116.85752, 32.95367], [-116.85831, 32.95552], [-116.85917, 32.95623], [-116.85986, 32.95615], [-116.86132, 32.95637], [-116.86287, 32.95522], [-116.86398, 32.95328], [-116.8659, 32.95241], [-116.86586, 32.95523], [-116.8735, 32.95511], [-116.87459, 32.95514], [-116.88011, 32.94845], [-116.87784, 32.94618], [-116.88568, 32.94618], [-116.88564, 32.94202], [-116.88949, 32.94174], [-116.89438, 32.94175], [-116.8944, 32.94591], [-116.89892, 32.94576], [-116.89905, 32.95333]], [[-116.85013, 32.98801], [-116.85065, 32.98657], [-116.84949, 32.98657], [-116.84954, 32.98837], [-116.84974, 32.98835], [-116.84991, 32.98827], [-116.85005, 32.98815], [-116.85013, 32.98801]]], [[[-116.90039, 32.98023], [-116.89618, 32.98029], [-116.89653, 32.98476], [-116.89236, 32.98489], [-116.89283, 32.98927], [-116.89317, 32.99393], [-116.88879, 32.99392], [-116.88686, 32.9939], [-116.88696, 32.99365], [-116.88691, 32.99352], [-116.88678, 32.9933], [-116.88692, 32.99229], [-116.88684, 32.99216], [-116.88694, 32.99173], [-116.88695, 32.9913], [-116.88688, 32.9911], [-116.88694, 32.99065], [-116.88743, 32.98995], [-116.88772, 32.98926], [-116.8876, 32.98884], [-116.88782, 32.98844], [-116.88761, 32.98803], [-116.88766, 32.98766], [-116.88748, 32.98706], [-116.88748, 32.98694], [-116.88767, 32.98674], [-116.88774, 32.98642], [-116.88764, 32.98615], [-116.88768, 32.98529], [-116.88772, 32.98492], [-116.88757, 32.98413], [-116.88767, 32.98363], [-116.88754, 32.98305], [-116.8877, 32.98279], [-116.88741, 32.98174], [-116.88739, 32.98111], [-116.88732, 32.98082], [-116.88711, 32.98055], [-116.88687, 32.98044], [-116.88669, 32.98009], [-116.88639, 32.97994], [-116.88603, 32.97917], [-116.88601, 32.97894], [-116.88614, 32.97878], [-116.88619, 32.97848], [-116.88595, 32.97795], [-116.88565, 32.97759], [-116.88537, 32.97748], [-116.88529, 32.97731], [-116.88572, 32.97653], [-116.88585, 32.97632], [-116.88591, 32.97618], [-116.88589, 32.97611], [-116.88568, 32.97589], [-116.88562, 32.97577], [-116.88574, 32.97564], [-116.88576, 32.97544], [-116.88552, 32.97514], [-116.88519, 32.97496], [-116.88454, 32.97497], [-116.88416, 32.97491], [-116.88367, 32.97459], [-116.88342, 32.97445], [-116.88331, 32.97435], [-116.88341, 32.97379], [-116.88335, 32.97365], [-116.88297, 32.97336], [-116.88293, 32.97329], [-116.88292, 32.97323], [-116.88293, 32.97317], [-116.88313, 32.97282], [-116.88333, 32.97276], [-116.8839, 32.97204], [-116.88384, 32.97183], [-116.88416, 32.9715], [-116.88425, 32.97121], [-116.88509, 32.97067], [-116.88647, 32.97077], [-116.88707, 32.97049], [-116.88737, 32.97033], [-116.88772, 32.97009], [-116.88829, 32.96974], [-116.88913, 32.96933], [-116.88931, 32.9692], [-116.89119, 32.97093], [-116.89186, 32.97159], [-116.89141, 32.97351], [-116.89084, 32.97584], [-116.9001, 32.97586], [-116.90039, 32.98023]]]]}	No Public Access 3	25240	Canada de San Vicente	32091	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	San Diego 4	4998.226	Canada de San Vicente	State Resource Management Area 55	3

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]);