calands: units_with_maps: 2 rows where DES_TP = 4 and MNG_AG

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

2 rows where DES_TP = 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
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

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