calands: units_with_maps: 1 row where ACCESS_TYP = 1, AGNCY_NAME = 570 and MNG

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

1 row where ACCESS_TYP = 1, AGNCY_NAME = 570 and MNG_AGENCY = 562

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
14413	14413	14412	{"type": "MultiPolygon", "coordinates": [[[[-117.01468, 33.61301], [-117.01468, 33.6203], [-117.01466, 33.62751], [-116.99656, 33.62778], [-116.99439, 33.62795], [-116.99448, 33.62781], [-116.9946, 33.62756], [-116.99465, 33.62737], [-116.99464, 33.62708], [-116.99459, 33.62689], [-116.99386, 33.62491], [-116.99383, 33.62481], [-116.9938, 33.62461], [-116.99381, 33.6244], [-116.99817, 33.62324], [-116.99656, 33.61769], [-116.9968, 33.61559], [-116.99153, 33.61569], [-116.99129, 33.61552], [-116.99092, 33.61534], [-116.99091, 33.61529], [-116.99196, 33.61464], [-116.99227, 33.61438], [-116.99699, 33.6139], [-116.99782, 33.61299], [-117.00298, 33.61305], [-117.00926, 33.61306], [-117.01468, 33.61301]]], [[[-117.01437, 33.64771], [-117.01434, 33.64944], [-117.00996, 33.64944], [-117.01001, 33.64582], [-117.01182, 33.64583], [-117.01153, 33.6471], [-117.01288, 33.64823], [-117.01355, 33.6477], [-117.01437, 33.64771]]], [[[-117.01432, 33.64401], [-117.0143, 33.64559], [-117.01421, 33.64567], [-117.01002, 33.64566], [-117.01099, 33.64443], [-117.01117, 33.64424], [-117.01134, 33.64401], [-117.01432, 33.64401]]], [[[-117.01051, 33.64473], [-117.01025, 33.64506], [-117.01002, 33.64535], [-117.01002, 33.64487], [-117.01026, 33.64482], [-117.01051, 33.64473]]], [[[-117.01092, 33.64401], [-117.0108, 33.64416], [-117.01057, 33.64434], [-117.01029, 33.64448], [-117.01003, 33.64456], [-117.01004, 33.644], [-117.01092, 33.64401]]], [[[-117.03173, 33.64194], [-117.01881, 33.64214], [-117.01888, 33.63846], [-117.03166, 33.63826], [-117.03173, 33.64194]]], [[[-117.06677, 33.64892], [-117.0496, 33.64918], [-117.04941, 33.64558], [-117.04073, 33.64562], [-117.04072, 33.64563], [-117.04076, 33.64922], [-117.03915, 33.64923], [-117.03912, 33.64744], [-117.03717, 33.64745], [-117.03718, 33.64924], [-117.03629, 33.64925], [-117.03625, 33.64564], [-117.04072, 33.64562], [-117.04068, 33.64201], [-117.03392, 33.64196], [-117.03385, 33.64013], [-117.03606, 33.64011], [-117.03606, 33.63935], [-117.03595, 33.63467], [-117.03158, 33.63458], [-117.03153, 33.63087], [-117.03586, 33.63098], [-117.03578, 33.62718], [-117.04011, 33.62717], [-117.04019, 33.61636], [-117.03158, 33.61638], [-117.03151, 33.62354], [-117.02771, 33.62366], [-117.02767, 33.61645], [-117.02333, 33.61652], [-117.02331, 33.61294], [-117.03161, 33.61285], [-117.04883, 33.61249], [-117.04876, 33.62767], [-117.04443, 33.62742], [-117.04448, 33.63119], [-117.03587, 33.63098], [-117.03595, 33.63465], [-117.04031, 33.63474], [-117.04041, 33.63839], [-117.04468, 33.63844], [-117.04469, 33.63843], [-117.04452, 33.63482], [-117.04731, 33.63487], [-117.0473, 33.63466], [-117.04735, 33.63451], [-117.04743, 33.63437], [-117.04756, 33.63426], [-117.04777, 33.63417], [-117.04795, 33.63414], [-117.04819, 33.63416], [-117.04836, 33.63423], [-117.04866, 33.63445], [-117.04875, 33.6345], [-117.04875, 33.6349], [-117.04925, 33.64206], [-117.05748, 33.642], [-117.05748, 33.64019], [-117.05618, 33.64021], [-117.05618, 33.63935], [-117.05645, 33.63934], [-117.05663, 33.63929], [-117.05676, 33.63922], [-117.05686, 33.63914], [-117.05695, 33.63905], [-117.05703, 33.6389], [-117.05706, 33.63877], [-117.05706, 33.63861], [-117.05701, 33.63844], [-117.0569, 33.6383], [-117.0568, 33.6382], [-117.05647, 33.63798], [-117.05631, 33.63783], [-117.05622, 33.63773], [-117.05611, 33.63754], [-117.05606, 33.63742], [-117.05601, 33.63722], [-117.05596, 33.63666], [-117.0559, 33.63645], [-117.0558, 33.63627], [-117.05557, 33.63592], [-117.05548, 33.63572], [-117.05541, 33.63553], [-117.05536, 33.63532], [-117.05533, 33.63512], [-117.05534, 33.63482], [-117.05911, 33.63477], [-117.05939, 33.63642], [-117.0594, 33.63672], [-117.05944, 33.63685], [-117.0595, 33.63693], [-117.0596, 33.63704], [-117.06185, 33.63871], [-117.06188, 33.64197], [-117.06628, 33.64193], [-117.06677, 33.64892]]], [[[-117.06473, 33.62745], [-117.06443, 33.62762], [-117.06414, 33.62786], [-117.06402, 33.628], [-117.06357, 33.62861], [-117.06349, 33.62862], [-117.06311, 33.62844], [-117.06285, 33.62835], [-117.06258, 33.62827], [-117.06231, 33.62821], [-117.06203, 33.62818], [-117.06175, 33.62816], [-117.06146, 33.62816], [-117.06118, 33.62819], [-117.0609, 33.62823], [-117.06063, 33.6283], [-117.06037, 33.62838], [-117.06011, 33.62848], [-117.05987, 33.6286], [-117.05964, 33.62874], [-117.05942, 33.62889], [-117.05922, 33.62906], [-117.05904, 33.62924], [-117.05888, 33.62944], [-117.05874, 33.62964], [-117.05854, 33.62999], [-117.05846, 33.63012], [-117.05824, 33.63035], [-117.05798, 33.63055], [-117.05783, 33.63063], [-117.05768, 33.6307], [-117.05745, 33.63077], [-117.05744, 33.62755], [-117.06473, 33.62745]]], [[[-117.06516, 33.62953], [-117.06509, 33.63151], [-117.06342, 33.63472], [-117.06182, 33.63474], [-117.06178, 33.63156], [-117.06189, 33.63153], [-117.06193, 33.63148], [-117.06194, 33.63143], [-117.06187, 33.63119], [-117.06187, 33.62848], [-117.06192, 33.62845], [-117.06224, 33.62848], [-117.06273, 33.6286], [-117.06297, 33.62869], [-117.06363, 33.62902], [-117.06405, 33.62919], [-117.06516, 33.62953]]], [[[-117.06626, 33.63983], [-117.06339, 33.6397], [-117.06394, 33.63964], [-117.06474, 33.63926], [-117.06483, 33.63921], [-117.06494, 33.63911], [-117.06499, 33.63903], [-117.06503, 33.6389], [-117.06497, 33.63636], [-117.0644, 33.6347], [-117.0662, 33.63468], [-117.06626, 33.63983]]], [[[-117.06615, 33.62953], [-117.06538, 33.62931], [-117.06418, 33.62893], [-117.06386, 33.6288], [-117.06383, 33.62872], [-117.06426, 33.62814], [-117.06437, 33.62802], [-117.06449, 33.62791], [-117.06476, 33.62772], [-117.06541, 33.62744], [-117.06613, 33.62743], [-117.06615, 33.62953]]]]}	Open Access 1	48556	Southwestern Riverside County Multi-Species Reserve	33272	2122	Riverside County Habitat Conservation Agency 570	Special District 4	Open Space District 6	http://www.skrplan.org/	Special District 4	2122	Riverside County Habitat Conservation Agency 562	Special District 4	Open Space District 6	http://rchca.us/159/Reserves	Riverside 10	2338.328	Southwestern Riverside County Multi-Species Reserve	1992	Local Conservation Area 4	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]);