calands: units_with_maps: 5 rows where COUNTY = 3, DES_TP = 8, MNG_AGENCY = 25 and MNG_AG

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

5 rows where COUNTY = 3, DES_TP = 8, MNG_AGENCY = 25 and MNG_AG_TYP = 5

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
5757	5757	5756	{"type": "Polygon", "coordinates": [[[-118.06308, 33.71148], [-118.0591, 33.71135], [-118.05909, 33.71137], [-118.05916, 33.71145], [-118.0591, 33.71145], [-118.0529, 33.70379], [-118.05255, 33.70376], [-118.05209, 33.70383], [-118.05126, 33.7045], [-118.05053, 33.70499], [-118.04992, 33.70528], [-118.04939, 33.70559], [-118.04839, 33.70627], [-118.04758, 33.70679], [-118.04721, 33.70696], [-118.0473, 33.70706], [-118.04645, 33.70713], [-118.0451, 33.7068], [-118.04429, 33.70664], [-118.04277, 33.7066], [-118.04262, 33.70639], [-118.03926, 33.70783], [-118.03874, 33.70808], [-118.03248, 33.7108], [-118.03236, 33.71026], [-118.0385, 33.70771], [-118.03856, 33.70759], [-118.04008, 33.70696], [-118.04008, 33.70694], [-118.03929, 33.70619], [-118.0362, 33.70457], [-118.0348, 33.70349], [-118.0343, 33.70285], [-118.03222, 33.70268], [-118.03233, 33.70084], [-118.03007, 33.70098], [-118.02774, 33.69924], [-118.02442, 33.69685], [-118.02392, 33.69652], [-118.02288, 33.69605], [-118.02167, 33.69532], [-118.02083, 33.69486], [-118.02092, 33.69004], [-118.0209, 33.68917], [-118.02053, 33.68916], [-118.02115, 33.68814], [-118.02114, 33.68806], [-118.02204, 33.68651], [-118.02221, 33.68641], [-118.02252, 33.68592], [-118.02297, 33.68566], [-118.02347, 33.68548], [-118.02404, 33.68539], [-118.02475, 33.68495], [-118.02488, 33.68482], [-118.02499, 33.68461], [-118.02516, 33.68437], [-118.02565, 33.68424], [-118.02733, 33.68355], [-118.02777, 33.68348], [-118.02863, 33.68372], [-118.03085, 33.6841], [-118.03152, 33.68436], [-118.03221, 33.68471], [-118.03276, 33.68458], [-118.03308, 33.68442], [-118.03319, 33.6839], [-118.0338, 33.68341], [-118.03355, 33.68309], [-118.03361, 33.68286], [-118.03424, 33.68245], [-118.03919, 33.68737], [-118.04395, 33.69223], [-118.04773, 33.69635], [-118.05291, 33.70154], [-118.05401, 33.7027], [-118.05549, 33.70404], [-118.05874, 33.70712], [-118.06037, 33.70878], [-118.06086, 33.70921], [-118.06308, 33.71148]]]}	Restricted Access 2	6996	Bolsa Chica Ecological Reserve	16245	209	California State Lands Commission 75	State 5	State Agency 5	http://www.slc.ca.gov/	Other State 5	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bolsa-Chica-ER	Orange 3	1223.82	Bolsa Chica ER	1993	State Conservation Area 8	2
7956	7956	7955	{"type": "Polygon", "coordinates": [[[-117.77053, 33.59072], [-117.7686, 33.593], [-117.76454, 33.58976], [-117.7642, 33.5901], [-117.76309, 33.58823], [-117.76246, 33.58625], [-117.762, 33.58582], [-117.76259, 33.58473], [-117.76199, 33.58343], [-117.76189, 33.58343], [-117.76179, 33.583], [-117.76357, 33.58416], [-117.76405, 33.5845], [-117.76434, 33.58553], [-117.76703, 33.58678], [-117.76652, 33.58743], [-117.77053, 33.59072]]]}	Open Access 1	12836	Laguna Laurel Ecological Reserve	32199	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	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Laguna-Laurel-ER	Orange 3	78.251	Laguna Laurel ER	1994	State Conservation Area 8	2
15593	15593	15592	{"type": "MultiPolygon", "coordinates": [[[[-117.89222, 33.64467], [-117.89145, 33.6457], [-117.89113, 33.64628], [-117.89089, 33.64677], [-117.89083, 33.64719], [-117.89084, 33.64753], [-117.89089, 33.64759], [-117.89093, 33.64785], [-117.89083, 33.64873], [-117.89054, 33.64966], [-117.89017, 33.65045], [-117.8898, 33.65087], [-117.88872, 33.65156], [-117.88812, 33.65187], [-117.88788, 33.65189], [-117.88622, 33.65225], [-117.88611, 33.652], [-117.88486, 33.65232], [-117.8843, 33.65248], [-117.87916, 33.65141], [-117.87837, 33.65117], [-117.87713, 33.65074], [-117.87657, 33.6506], [-117.87613, 33.65052], [-117.87553, 33.65046], [-117.87501, 33.65045], [-117.87457, 33.65048], [-117.87406, 33.65056], [-117.87356, 33.65068], [-117.87325, 33.65078], [-117.87276, 33.65097], [-117.8725, 33.6511], [-117.8725, 33.65114], [-117.87218, 33.65124], [-117.87103, 33.65164], [-117.87, 33.65204], [-117.8698, 33.65216], [-117.86922, 33.65227], [-117.8687, 33.65232], [-117.86833, 33.65235], [-117.86765, 33.65235], [-117.86706, 33.65231], [-117.86708, 33.65218], [-117.86709, 33.65196], [-117.86707, 33.65156], [-117.86682, 33.64989], [-117.86679, 33.64957], [-117.86679, 33.64906], [-117.86683, 33.64857], [-117.86703, 33.64726], [-117.86707, 33.6472], [-117.86711, 33.64718], [-117.86734, 33.64712], [-117.8676, 33.64704], [-117.86792, 33.64689], [-117.86808, 33.6468], [-117.86834, 33.64662], [-117.86852, 33.64646], [-117.86899, 33.64595], [-117.8692, 33.64576], [-117.86944, 33.64558], [-117.86976, 33.64542], [-117.87016, 33.64527], [-117.87085, 33.64509], [-117.87095, 33.64511], [-117.87106, 33.64518], [-117.87142, 33.64535], [-117.87172, 33.64545], [-117.87183, 33.64547], [-117.87223, 33.64549], [-117.87236, 33.64548], [-117.87265, 33.64543], [-117.87291, 33.64542], [-117.87372, 33.64556], [-117.87421, 33.64568], [-117.87447, 33.6457], [-117.87515, 33.6457], [-117.8759, 33.64575], [-117.87634, 33.64582], [-117.87713, 33.64612], [-117.87762, 33.64626], [-117.87788, 33.64635], [-117.87808, 33.64647], [-117.87867, 33.6469], [-117.87881, 33.64695], [-117.87897, 33.64698], [-117.87915, 33.64697], [-117.87951, 33.64689], [-117.8799, 33.64678], [-117.88059, 33.64662], [-117.88113, 33.64644], [-117.88173, 33.64615], [-117.88198, 33.64597], [-117.88219, 33.64575], [-117.88233, 33.64554], [-117.88237, 33.64543], [-117.88239, 33.64532], [-117.8824, 33.64522], [-117.88237, 33.64482], [-117.88232, 33.64439], [-117.88232, 33.64391], [-117.88236, 33.64373], [-117.88249, 33.64346], [-117.88289, 33.64303], [-117.8835, 33.64256], [-117.88413, 33.64202], [-117.88488, 33.64141], [-117.88531, 33.64104], [-117.88556, 33.6409], [-117.88609, 33.64083], [-117.88629, 33.64071], [-117.88769, 33.63761], [-117.8869, 33.63605], [-117.88594, 33.63516], [-117.88561, 33.63453], [-117.88549, 33.6344], [-117.88509, 33.63403], [-117.88483, 33.63395], [-117.88467, 33.63377], [-117.8846, 33.63364], [-117.88329, 33.63301], [-117.88322, 33.63295], [-117.88312, 33.63284], [-117.88308, 33.63273], [-117.88302, 33.63212], [-117.883, 33.63202], [-117.88295, 33.63192], [-117.88289, 33.63186], [-117.88279, 33.63178], [-117.88204, 33.63138], [-117.88241, 33.63125], [-117.88249, 33.6312], [-117.88264, 33.63117], [-117.88405, 33.63114], [-117.88432, 33.63107], [-117.88449, 33.63099], [-117.88488, 33.63066], [-117.88499, 33.63025], [-117.88548, 33.6302], [-117.88591, 33.63007], [-117.88626, 33.6299], [-117.88612, 33.63039], [-117.88587, 33.63218], [-117.88586, 33.63288], [-117.88575, 33.63374], [-117.88578, 33.63407], [-117.88581, 33.63411], [-117.88628, 33.63495], [-117.88729, 33.63596], [-117.88751, 33.63628], [-117.88803, 33.63756], [-117.88726, 33.63909], [-117.88745, 33.63942], [-117.88748, 33.64008], [-117.88734, 33.64041], [-117.88712, 33.64036], [-117.88699, 33.63984], [-117.8868, 33.63992], [-117.88676, 33.64059], [-117.88657, 33.64098], [-117.88545, 33.64139], [-117.88378, 33.64272], [-117.88277, 33.64381], [-117.88279, 33.64569], [-117.88389, 33.64613], [-117.88438, 33.6465], [-117.8855, 33.64753], [-117.88816, 33.64607], [-117.88984, 33.63866], [-117.89034, 33.63939], [-117.89056, 33.64126], [-117.89124, 33.64184], [-117.89123, 33.64185], [-117.89199, 33.64287], [-117.892, 33.64455], [-117.89222, 33.64467]]], [[[-117.89314, 33.62071], [-117.89283, 33.62081], [-117.89246, 33.62119], [-117.89175, 33.62246], [-117.89121, 33.62441], [-117.89083, 33.62549], [-117.88925, 33.62635], [-117.88846, 33.62665], [-117.88746, 33.62641], [-117.88643, 33.62681], [-117.886, 33.62694], [-117.88567, 33.62718], [-117.88584, 33.62689], [-117.88589, 33.62528], [-117.88691, 33.62397], [-117.88723, 33.62373], [-117.88767, 33.62364], [-117.88885, 33.62448], [-117.88954, 33.6235], [-117.88998, 33.62271], [-117.89091, 33.62176], [-117.89113, 33.62077], [-117.89086, 33.62079], [-117.89175, 33.61959], [-117.89246, 33.61966], [-117.8925, 33.61989], [-117.89314, 33.62071]]], [[[-117.88963, 33.63535], [-117.88929, 33.6359], [-117.88875, 33.63601], [-117.88836, 33.63604], [-117.88836, 33.63606], [-117.88847, 33.63615], [-117.88844, 33.63635], [-117.88819, 33.6364], [-117.88797, 33.63633], [-117.88781, 33.63615], [-117.88787, 33.63609], [-117.88787, 33.63607], [-117.88765, 33.63609], [-117.88672, 33.63532], [-117.88638, 33.63492], [-117.88625, 33.63433], [-117.88639, 33.63337], [-117.88651, 33.63282], [-117.88916, 33.63443], [-117.88963, 33.63535]]], [[[-117.89083, 33.6312], [-117.89067, 33.63158], [-117.8901, 33.6319], [-117.88925, 33.63267], [-117.88746, 33.63221], [-117.88696, 33.63051], [-117.88668, 33.62896], [-117.88673, 33.62858], [-117.88728, 33.62827], [-117.8878, 33.62814], [-117.88859, 33.62791], [-117.88964, 33.6274], [-117.88979, 33.62763], [-117.88942, 33.6286], [-117.88976, 33.62886], [-117.89017, 33.62957], [-117.89074, 33.63065], [-117.89083, 33.6312]]]]}	Open Access 1	14907	Upper Newport Bay Ecological Reserve	32343	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	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Upper-Newport-Bay-ER	Orange 3	505.532	Upper Newport Bay ER	1975	State Conservation Area 8	2
15607	15607	15606	{"type": "Polygon", "coordinates": [[[-117.69319, 33.84432], [-117.69062, 33.8469], [-117.68788, 33.8496], [-117.68513, 33.85239], [-117.688, 33.85428], [-117.68589, 33.85486], [-117.68501, 33.85497], [-117.68439, 33.85571], [-117.68464, 33.85666], [-117.68536, 33.85817], [-117.68679, 33.8593], [-117.68747, 33.85956], [-117.68726, 33.85992], [-117.68759, 33.86043], [-117.68726, 33.86083], [-117.68806, 33.86152], [-117.68807, 33.86304], [-117.68743, 33.86329], [-117.68666, 33.86293], [-117.68671, 33.86241], [-117.68541, 33.86252], [-117.68546, 33.86174], [-117.68537, 33.86163], [-117.6858, 33.86096], [-117.68562, 33.86072], [-117.68491, 33.86069], [-117.68491, 33.85999], [-117.68378, 33.85932], [-117.68309, 33.85978], [-117.68326, 33.86037], [-117.68257, 33.86055], [-117.6827, 33.86157], [-117.68237, 33.86186], [-117.68256, 33.86267], [-117.68156, 33.86257], [-117.68111, 33.86218], [-117.6808, 33.86203], [-117.67982, 33.86182], [-117.6779, 33.86191], [-117.6782, 33.86274], [-117.67936, 33.86359], [-117.67909, 33.8642], [-117.67733, 33.8641], [-117.67665, 33.86349], [-117.6759, 33.86353], [-117.67551, 33.86327], [-117.67288, 33.86335], [-117.67271, 33.86201], [-117.67336, 33.8596], [-117.67207, 33.84275], [-117.67655, 33.83827], [-117.67987, 33.83499], [-117.69319, 33.84432]]]}	Open Access 1	17876	Coal Canyon Ecological Reserve	32121	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	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Coal-Canyon-ER	Orange 3	941.511	Coal Canyon ER	1994	State Conservation Area 8	2
15633	15633	15632	{"type": "Polygon", "coordinates": [[[-118.0591, 33.71145], [-118.05334, 33.71151], [-118.05324, 33.71141], [-118.05253, 33.7114], [-118.05237, 33.7115], [-118.05211, 33.71154], [-118.05202, 33.71038], [-118.04962, 33.70863], [-118.04937, 33.70848], [-118.04877, 33.70796], [-118.04785, 33.70755], [-118.0472, 33.70696], [-118.04758, 33.70679], [-118.04839, 33.70627], [-118.04939, 33.70559], [-118.04992, 33.70528], [-118.05053, 33.70499], [-118.05126, 33.7045], [-118.0521, 33.70383], [-118.05255, 33.70376], [-118.05289, 33.70379], [-118.0591, 33.71145]]]}	Open Access 1	29270	Bolsa Chica Ecological Reserve	32062	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	https://www.wildlife.ca.gov/Lands/Places-to-Visit/Bolsa-Chica-ER	Orange 3	116.387	Bolsa Chica ER	1993	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]);