calands: units_with_maps: 6 rows where ACCESS_TYP = 2, LAYER = 4 and MNG_AG

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

6 rows where ACCESS_TYP = 2, LAYER = 4 and MNG_AG_TYP = 23

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
2587	2587	2586	{"type": "Polygon", "coordinates": [[[-121.6993, 37.1374], [-121.69927, 37.13758], [-121.69925, 37.13763], [-121.69897, 37.1379], [-121.69889, 37.13803], [-121.69886, 37.13818], [-121.69891, 37.13845], [-121.69887, 37.13856], [-121.69879, 37.13863], [-121.69835, 37.13886], [-121.69819, 37.13898], [-121.69812, 37.13906], [-121.69804, 37.13918], [-121.698, 37.13927], [-121.69798, 37.1394], [-121.69502, 37.13925], [-121.69459, 37.14231], [-121.69775, 37.14279], [-121.69751, 37.1432], [-121.69747, 37.14338], [-121.69749, 37.14349], [-121.69753, 37.14359], [-121.69773, 37.14385], [-121.69774, 37.1439], [-121.6977, 37.14408], [-121.69774, 37.14423], [-121.69782, 37.14433], [-121.69793, 37.14441], [-121.69814, 37.14449], [-121.6985, 37.14457], [-121.69858, 37.14461], [-121.69862, 37.14465], [-121.69873, 37.14492], [-121.69878, 37.145], [-121.69885, 37.14507], [-121.69906, 37.14521], [-121.69907, 37.14526], [-121.69904, 37.1453], [-121.69893, 37.14534], [-121.69881, 37.14534], [-121.69868, 37.14529], [-121.6984, 37.14513], [-121.69831, 37.1451], [-121.69784, 37.14504], [-121.69732, 37.1449], [-121.69711, 37.14489], [-121.69657, 37.14502], [-121.69609, 37.1451], [-121.69592, 37.14514], [-121.69575, 37.14523], [-121.69534, 37.14556], [-121.69429, 37.14477], [-121.69077, 37.14709], [-121.68949, 37.14741], [-121.6883, 37.14735], [-121.68766, 37.14771], [-121.68593, 37.14831], [-121.68474, 37.14958], [-121.6848, 37.15033], [-121.68234, 37.15043], [-121.68145, 37.15097], [-121.68134, 37.15101], [-121.68069, 37.15066], [-121.67969, 37.1506], [-121.6794, 37.15055], [-121.67913, 37.15046], [-121.67887, 37.15036], [-121.67862, 37.15023], [-121.67818, 37.15011], [-121.67231, 37.14686], [-121.67232, 37.14683], [-121.67103, 37.14611], [-121.67103, 37.14609], [-121.67071, 37.14589], [-121.67035, 37.14558], [-121.67011, 37.1453], [-121.68383, 37.13848], [-121.69306, 37.1338], [-121.69859, 37.13656], [-121.69832, 37.13693], [-121.6993, 37.1374]]]}	Restricted Access 2	49052	Baird Open Space Regional Reserve	33794	503	Santa Clara Valley Habitat Agency 536	Joint 8	Joint Powers Authority 24	https://www.scv-habitatagency.org/	Special District 4	503	Santa Clara Valley Habitat Agency 529	Joint 8	Joint Powers Authority 23	https://www.scv-habitatagency.org/	Santa Clara 19	597.843	Baird OS RR		None 211
2588	2588	2587	{"type": "Polygon", "coordinates": [[[-121.68265, 37.13906], [-121.67601, 37.14237], [-121.67267, 37.13922], [-121.67394, 37.13832], [-121.67414, 37.13831], [-121.67414, 37.13825], [-121.67417, 37.13816], [-121.67413, 37.13806], [-121.67415, 37.138], [-121.67421, 37.13787], [-121.67433, 37.13771], [-121.6747, 37.13788], [-121.67611, 37.13687], [-121.67571, 37.13647], [-121.67744, 37.13531], [-121.67854, 37.13499], [-121.68054, 37.1365], [-121.68265, 37.13906]]]}	Restricted Access 2	49053	Davidson Open Space Regional Reserve	33795	503	Santa Clara Valley Habitat Agency 536	Joint 8	Joint Powers Authority 24	https://www.scv-habitatagency.org/	Special District 4	503	Santa Clara Valley Habitat Agency 529	Joint 8	Joint Powers Authority 23	https://www.scv-habitatagency.org/	Santa Clara 19	93.914	Davidson OS RR		None 212
9815	9815	9814	{"type": "MultiPolygon", "coordinates": [[[[-118.0981, 33.75518], [-118.09806, 33.75524], [-118.09723, 33.75729], [-118.09712, 33.75727], [-118.09712, 33.7574], [-118.09718, 33.75742], [-118.09712, 33.75756], [-118.09679, 33.75796], [-118.09678, 33.7574], [-118.09397, 33.75741], [-118.0981, 33.75518]]], [[[-118.10823, 33.7587], [-118.10791, 33.75879], [-118.10789, 33.75877], [-118.10682, 33.75905], [-118.10565, 33.75931], [-118.10521, 33.75938], [-118.10477, 33.75942], [-118.10433, 33.75944], [-118.10388, 33.75944], [-118.10387, 33.7595], [-118.09897, 33.75948], [-118.09898, 33.75944], [-118.09888, 33.75943], [-118.09766, 33.75943], [-118.09756, 33.75944], [-118.09753, 33.75948], [-118.09711, 33.75947], [-118.09713, 33.75927], [-118.09719, 33.75906], [-118.09855, 33.75569], [-118.0987, 33.75543], [-118.09888, 33.75522], [-118.0991, 33.75502], [-118.09928, 33.75491], [-118.10004, 33.75448], [-118.10066, 33.75425], [-118.10133, 33.7539], [-118.1015, 33.75378], [-118.10179, 33.75355], [-118.10197, 33.75343], [-118.10391, 33.75239], [-118.1039, 33.75304], [-118.10392, 33.75305], [-118.10544, 33.75188], [-118.10505, 33.75144], [-118.10335, 33.75235], [-118.10275, 33.75234], [-118.10578, 33.75071], [-118.10581, 33.75113], [-118.10588, 33.75155], [-118.10546, 33.75189], [-118.10624, 33.75276], [-118.10496, 33.75373], [-118.10575, 33.75452], [-118.10487, 33.7551], [-118.10823, 33.7587]]], [[[-118.1037, 33.76073], [-118.10224, 33.76073], [-118.10201, 33.76064], [-118.10203, 33.75976], [-118.10363, 33.75977], [-118.10369, 33.75982], [-118.1037, 33.76073]]], [[[-118.1044, 33.76679], [-118.10413, 33.76701], [-118.10379, 33.76693], [-118.10378, 33.76689], [-118.10341, 33.76687], [-118.10336, 33.76683], [-118.1034, 33.76645], [-118.10346, 33.76609], [-118.1044, 33.76679]]], [[[-118.11507, 33.76323], [-118.11475, 33.7634], [-118.11459, 33.76373], [-118.11427, 33.76414], [-118.11409, 33.76433], [-118.11382, 33.76457], [-118.11347, 33.76479], [-118.11321, 33.76491], [-118.1129, 33.76502], [-118.1124, 33.76514], [-118.1115, 33.76493], [-118.11152, 33.76491], [-118.11151, 33.7649], [-118.11107, 33.76499], [-118.11113, 33.76522], [-118.10929, 33.76562], [-118.10921, 33.76539], [-118.10584, 33.76612], [-118.10538, 33.76627], [-118.10496, 33.76644], [-118.10362, 33.76543], [-118.10389, 33.76452], [-118.10395, 33.76416], [-118.10399, 33.76388], [-118.104, 33.7635], [-118.10401, 33.76043], [-118.104, 33.7599], [-118.10408, 33.7599], [-118.10408, 33.75983], [-118.10459, 33.75981], [-118.10511, 33.75977], [-118.10561, 33.7597], [-118.10597, 33.75963], [-118.10599, 33.75965], [-118.10654, 33.75953], [-118.10656, 33.75946], [-118.10676, 33.75945], [-118.10678, 33.75947], [-118.10725, 33.75935], [-118.10805, 33.75914], [-118.10805, 33.75911], [-118.10954, 33.7587], [-118.10954, 33.75868], [-118.11055, 33.75842], [-118.11056, 33.75844], [-118.1106, 33.75844], [-118.11072, 33.75876], [-118.11112, 33.75891], [-118.11151, 33.75866], [-118.11346, 33.76076], [-118.11388, 33.76125], [-118.11425, 33.76177], [-118.11479, 33.76278], [-118.11483, 33.76277], [-118.11507, 33.76323]]], [[[-118.1102, 33.76604], [-118.10804, 33.76789], [-118.10525, 33.76728], [-118.10565, 33.76708], [-118.10606, 33.76694], [-118.1102, 33.76604]]], [[[-118.11134, 33.76537], [-118.11087, 33.76547], [-118.11087, 33.76547], [-118.11104, 33.76532], [-118.11134, 33.76537]]]]}	Restricted Access 2	47917	Los Cerritos Wetlands	32016	2418	Los Cerritos Wetland Authority 929	Special District 4	Joint Powers Authority 24	http://intoloscerritoswetlands.org	Special District 4	2418	Los Cerritos Wetland Authority 902	Special District 4	Joint Powers Authority 23	http://intoloscerritoswetlands.org/	Los Angeles 6	311.339	Los Cerritos Wetlands	2006	Local Conservation Area 4	2
9865	9865	9864	{"type": "Polygon", "coordinates": [[[-118.10578, 33.7507], [-118.10168, 33.75292], [-118.10147, 33.75304], [-118.1011, 33.75333], [-118.10089, 33.75347], [-118.10032, 33.75377], [-118.09988, 33.75392], [-118.09965, 33.75401], [-118.09891, 33.75441], [-118.09869, 33.75454], [-118.09849, 33.7547], [-118.09831, 33.75488], [-118.09809, 33.75518], [-118.09198, 33.75848], [-118.09204, 33.75945], [-118.09112, 33.75945], [-118.09164, 33.75896], [-118.09157, 33.75739], [-118.09158, 33.75387], [-118.08764, 33.75239], [-118.08918, 33.75013], [-118.08922, 33.7501], [-118.08929, 33.7501], [-118.08955, 33.75023], [-118.08964, 33.75031], [-118.08979, 33.75034], [-118.08981, 33.75036], [-118.08981, 33.75039], [-118.08968, 33.75066], [-118.08941, 33.75105], [-118.08933, 33.7512], [-118.08928, 33.75135], [-118.08892, 33.7513], [-118.08888, 33.7515], [-118.0888, 33.75161], [-118.08872, 33.75167], [-118.08845, 33.75179], [-118.08832, 33.75191], [-118.08825, 33.75207], [-118.08825, 33.75224], [-118.08832, 33.75239], [-118.0884, 33.75248], [-118.08851, 33.75255], [-118.08863, 33.7526], [-118.08876, 33.75262], [-118.08888, 33.75261], [-118.08905, 33.75257], [-118.08918, 33.75249], [-118.08938, 33.75251], [-118.08938, 33.7526], [-118.0894, 33.75269], [-118.08945, 33.7528], [-118.08953, 33.75288], [-118.08963, 33.75295], [-118.08975, 33.753], [-118.08987, 33.75303], [-118.09001, 33.75303], [-118.0903, 33.75291], [-118.09037, 33.75284], [-118.09043, 33.75276], [-118.09054, 33.7525], [-118.09066, 33.75228], [-118.09075, 33.7521], [-118.0908, 33.75192], [-118.09083, 33.75172], [-118.09086, 33.75163], [-118.09109, 33.75129], [-118.09134, 33.75085], [-118.09161, 33.75067], [-118.09171, 33.75057], [-118.09192, 33.75029], [-118.09201, 33.75014], [-118.09208, 33.75006], [-118.09226, 33.74999], [-118.09225, 33.74995], [-118.09219, 33.74988], [-118.09207, 33.74981], [-118.09207, 33.7498], [-118.09274, 33.75002], [-118.09392, 33.75049], [-118.09404, 33.75021], [-118.0943, 33.75006], [-118.09489, 33.75005], [-118.09567, 33.74976], [-118.09748, 33.74977], [-118.09918, 33.74999], [-118.09978, 33.74999], [-118.10013, 33.74989], [-118.10034, 33.74971], [-118.10036, 33.74943], [-118.10071, 33.74928], [-118.10082, 33.74891], [-118.1013, 33.74875], [-118.10131, 33.74888], [-118.10216, 33.74867], [-118.10286, 33.74859], [-118.10307, 33.74855], [-118.10332, 33.74869], [-118.1034, 33.74872], [-118.10342, 33.74871], [-118.10352, 33.74876], [-118.10373, 33.74893], [-118.10379, 33.74891], [-118.10399, 33.74944], [-118.10574, 33.74945], [-118.10578, 33.7507]]]}	Restricted Access 2	47918	Los Cerritos Wetlands	32016	2418	Los Cerritos Wetland Authority 929	Special District 4	Joint Powers Authority 24	http://intoloscerritoswetlands.org	Special District 4	2418	Los Cerritos Wetland Authority 902	Special District 4	Joint Powers Authority 23	http://intoloscerritoswetlands.org/	Orange 3	196.293	Los Cerritos Wetlands	2006	Local Conservation Area 4	2
10243	10243	10242	{"type": "Polygon", "coordinates": [[[-121.75635, 37.21971], [-121.75564, 37.22071], [-121.75151, 37.2261], [-121.75121, 37.2259], [-121.75107, 37.22578], [-121.75107, 37.22539], [-121.75109, 37.22526], [-121.75121, 37.225], [-121.74995, 37.22425], [-121.74922, 37.22423], [-121.74873, 37.22405], [-121.74844, 37.22381], [-121.74917, 37.22299], [-121.75427, 37.22089], [-121.75529, 37.22009], [-121.75635, 37.21971]]]}	Restricted Access 2	49054	Tulare Hill Wedge Open Space Regional Reserve	33796	503	Santa Clara Valley Habitat Agency 536	Joint 8	Joint Powers Authority 24	https://www.scv-habitatagency.org/	Special District 4	503	Santa Clara Valley Habitat Agency 529	Joint 8	Joint Powers Authority 23	https://www.scv-habitatagency.org/	Santa Clara 19	37.498	Tulare Hill Wedge OS RR		None 890
16268	16268	16267	{"type": "MultiPolygon", "coordinates": [[[[-121.33318, 37.01942], [-121.33188, 37.02043], [-121.33185, 37.02053], [-121.33057, 37.02153], [-121.33035, 37.02153], [-121.32883, 37.02266], [-121.32829, 37.02321], [-121.32786, 37.02394], [-121.32768, 37.02432], [-121.32755, 37.02471], [-121.32745, 37.0251], [-121.32742, 37.02652], [-121.32737, 37.0269], [-121.32722, 37.02747], [-121.32709, 37.02784], [-121.32692, 37.0282], [-121.32672, 37.02855], [-121.32649, 37.02888], [-121.32623, 37.02921], [-121.3252, 37.03042], [-121.32465, 37.03112], [-121.32441, 37.03131], [-121.32412, 37.03164], [-121.32389, 37.03184], [-121.32365, 37.03202], [-121.3234, 37.03219], [-121.32313, 37.03235], [-121.32284, 37.03249], [-121.32254, 37.03261], [-121.31959, 37.03369], [-121.31926, 37.03379], [-121.3186, 37.03397], [-121.31804, 37.03408], [-121.3177, 37.03412], [-121.31603, 37.03443], [-121.31486, 37.03474], [-121.31471, 37.03445], [-121.3168, 37.03364], [-121.31661, 37.03311], [-121.31967, 37.03186], [-121.31922, 37.03113], [-121.32124, 37.03039], [-121.32143, 37.0303], [-121.3216, 37.0302], [-121.32172, 37.0301], [-121.32223, 37.0296], [-121.32263, 37.02907], [-121.32378, 37.02772], [-121.32397, 37.02745], [-121.32412, 37.02716], [-121.32424, 37.02686], [-121.32431, 37.02656], [-121.32434, 37.02635], [-121.3244, 37.02473], [-121.32454, 37.02415], [-121.32474, 37.02358], [-121.32499, 37.02302], [-121.32573, 37.02181], [-121.32578, 37.02182], [-121.32633, 37.02319], [-121.32831, 37.02267], [-121.32847, 37.02224], [-121.32838, 37.02221], [-121.32871, 37.02123], [-121.33079, 37.01895], [-121.33135, 37.01868], [-121.33202, 37.0188], [-121.33318, 37.01942]]], [[[-121.3394, 37.01452], [-121.33674, 37.01658], [-121.3366, 37.01662], [-121.33598, 37.01721], [-121.33518, 37.01785], [-121.33503, 37.01782], [-121.33494, 37.01789], [-121.33498, 37.01801], [-121.33349, 37.01917], [-121.33146, 37.01808], [-121.33411, 37.01517], [-121.33462, 37.01488], [-121.33712, 37.01426], [-121.3394, 37.01452]]]]}	Restricted Access 2	49051	Pacheco Creek Open Space Regional Reserve	33793	503	Santa Clara Valley Habitat Agency 536	Joint 8	Joint Powers Authority 24	https://www.scv-habitatagency.org/	Special District 4	503	Santa Clara Valley Habitat Agency 529	Joint 8	Joint Powers Authority 23	https://www.scv-habitatagency.org/	Santa Clara 19	162.38	Pacheco Creek OS RR		None 1397

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