calands: units_with_maps: 3 rows where COUNTY = 6 and MNG

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

3 rows where COUNTY = 6 and MNG_AGENCY = 25

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
7566	7566	7565	{"type": "MultiPolygon", "coordinates": [[[[-118.79086, 34.75249], [-118.7905, 34.75269], [-118.78995, 34.75282], [-118.78833, 34.75304], [-118.7856, 34.75305], [-118.78493, 34.75343], [-118.7845, 34.75351], [-118.78357, 34.75316], [-118.78272, 34.7538], [-118.78126, 34.75417], [-118.78017, 34.75394], [-118.77903, 34.75547], [-118.77894, 34.75664], [-118.77779, 34.75756], [-118.77848, 34.758], [-118.77841, 34.75986], [-118.77886, 34.75987], [-118.77913, 34.76202], [-118.77761, 34.76518], [-118.77755, 34.76574], [-118.77634, 34.76582], [-118.77522, 34.7637], [-118.77346, 34.76262], [-118.77195, 34.76241], [-118.77418, 34.76093], [-118.7718, 34.76016], [-118.7718, 34.75988], [-118.77251, 34.75988], [-118.77253, 34.75986], [-118.77541, 34.75987], [-118.77538, 34.75716], [-118.76641, 34.75721], [-118.76641, 34.7563], [-118.76211, 34.75628], [-118.76217, 34.75101], [-118.76215, 34.74996], [-118.76216, 34.74903], [-118.74905, 34.74906], [-118.74903, 34.74547], [-118.74904, 34.73837], [-118.75789, 34.73825], [-118.75783, 34.7453], [-118.75784, 34.74543], [-118.76664, 34.74538], [-118.76648, 34.75269], [-118.78437, 34.75246], [-118.79086, 34.75249]]], [[[-118.81161, 34.69934], [-118.80281, 34.69927], [-118.80282, 34.70238], [-118.80001, 34.70204], [-118.79731, 34.7014], [-118.79715, 34.70135], [-118.79688, 34.70122], [-118.79659, 34.70101], [-118.79636, 34.70072], [-118.79535, 34.69892], [-118.79396, 34.69519], [-118.79373, 34.69386], [-118.79362, 34.6936], [-118.79348, 34.69334], [-118.7933, 34.69308], [-118.7926, 34.69251], [-118.79179, 34.69207], [-118.79171, 34.69193], [-118.79408, 34.69176], [-118.80275, 34.69201], [-118.80714, 34.69205], [-118.80718, 34.69567], [-118.81157, 34.69571], [-118.81161, 34.69934]]], [[[-118.7954, 34.74528], [-118.79529, 34.74598], [-118.79517, 34.74694], [-118.79477, 34.7469], [-118.79447, 34.74857], [-118.79437, 34.74895], [-118.79362, 34.75118], [-118.79356, 34.75131], [-118.79347, 34.75144], [-118.79333, 34.75159], [-118.79322, 34.75168], [-118.79317, 34.74518], [-118.7953, 34.74521], [-118.7954, 34.74528]]]]}	No Public Access 3	7259	DWR Mitigation -- L.A. Property	32152	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	Los Angeles 6	999.598	DWR Mitigation -- L.A. Property	State Other or Unknown 104	4
15573	15573	15572	{"type": "MultiPolygon", "coordinates": [[[[-118.44473, 33.96166], [-118.4447, 33.96171], [-118.44418, 33.96215], [-118.44385, 33.96246], [-118.44342, 33.96289], [-118.44309, 33.96328], [-118.44315, 33.96333], [-118.44053, 33.96656], [-118.44026, 33.96686], [-118.44011, 33.96701], [-118.43981, 33.96728], [-118.43941, 33.9676], [-118.43887, 33.96794], [-118.4384, 33.96819], [-118.43066, 33.97172], [-118.42699, 33.96619], [-118.42668, 33.96586], [-118.42641, 33.96564], [-118.42613, 33.96547], [-118.42645, 33.96527], [-118.42773, 33.96546], [-118.43068, 33.96732], [-118.43234, 33.96689], [-118.43239, 33.9668], [-118.43209, 33.9664], [-118.4321, 33.96632], [-118.43276, 33.9659], [-118.43364, 33.96545], [-118.43415, 33.96523], [-118.43422, 33.96524], [-118.43435, 33.9654], [-118.43446, 33.96535], [-118.43469, 33.96582], [-118.43509, 33.96568], [-118.43604, 33.9651], [-118.43667, 33.96607], [-118.43697, 33.96594], [-118.43706, 33.96604], [-118.43709, 33.96601], [-118.43699, 33.96585], [-118.43699, 33.96579], [-118.43704, 33.96573], [-118.43777, 33.96541], [-118.43791, 33.96542], [-118.43798, 33.96545], [-118.43802, 33.9655], [-118.43814, 33.96549], [-118.43874, 33.96467], [-118.43957, 33.96412], [-118.43945, 33.96398], [-118.44147, 33.96268], [-118.44115, 33.96234], [-118.44009, 33.96295], [-118.44008, 33.96292], [-118.44091, 33.96236], [-118.44307, 33.9621], [-118.44458, 33.96139], [-118.44472, 33.96151], [-118.44473, 33.96166]], [[-118.43824, 33.96817], [-118.43824, 33.96815], [-118.43806, 33.96788], [-118.43778, 33.96801], [-118.43796, 33.96829], [-118.43824, 33.96817]], [[-118.43869, 33.96659], [-118.43869, 33.96658], [-118.43851, 33.9663], [-118.43823, 33.96643], [-118.43841, 33.96672], [-118.43869, 33.96659]], [[-118.44125, 33.96475], [-118.44126, 33.96474], [-118.44108, 33.96446], [-118.44079, 33.96459], [-118.44097, 33.96487], [-118.44125, 33.96475]]], [[[-118.43925, 33.96812], [-118.43793, 33.96975], [-118.43775, 33.96993], [-118.43747, 33.97015], [-118.43728, 33.97027], [-118.43507, 33.97137], [-118.43351, 33.97209], [-118.43335, 33.97219], [-118.43319, 33.97233], [-118.43307, 33.97247], [-118.43296, 33.97271], [-118.43292, 33.97285], [-118.43291, 33.97312], [-118.43293, 33.97324], [-118.43299, 33.9734], [-118.43323, 33.97385], [-118.43335, 33.97414], [-118.43342, 33.9745], [-118.43342, 33.9747], [-118.4334, 33.97487], [-118.43336, 33.97486], [-118.43335, 33.97488], [-118.43263, 33.97528], [-118.4324, 33.97495], [-118.43169, 33.97387], [-118.43174, 33.97384], [-118.4317, 33.97378], [-118.43062, 33.97213], [-118.43065, 33.97204], [-118.4385, 33.96846], [-118.4388, 33.96831], [-118.4392, 33.96808], [-118.43924, 33.96808], [-118.43925, 33.96812]], [[-118.4383, 33.96882], [-118.43821, 33.96868], [-118.43793, 33.96881], [-118.43812, 33.96909], [-118.4384, 33.96897], [-118.4383, 33.96882]]], [[[-118.43334, 33.97494], [-118.43332, 33.97504], [-118.4332, 33.97536], [-118.43311, 33.97551], [-118.43296, 33.9757], [-118.43267, 33.97532], [-118.43334, 33.97494]]], [[[-118.45161, 33.96469], [-118.44452, 33.9687], [-118.44542, 33.96982], [-118.44543, 33.97342], [-118.44494, 33.9741], [-118.43612, 33.97801], [-118.4347, 33.97707], [-118.43468, 33.97708], [-118.4341, 33.9767], [-118.43372, 33.97642], [-118.43344, 33.97618], [-118.43331, 33.97606], [-118.43335, 33.97599], [-118.4332, 33.97591], [-118.43335, 33.97571], [-118.43354, 33.9754], [-118.43368, 33.97507], [-118.43375, 33.97478], [-118.44449, 33.96869], [-118.44446, 33.96865], [-118.44411, 33.96885], [-118.43376, 33.97471], [-118.43378, 33.97456], [-118.43376, 33.97433], [-118.43368, 33.97401], [-118.43361, 33.97384], [-118.43334, 33.97331], [-118.43327, 33.97306], [-118.43327, 33.97283], [-118.43331, 33.97269], [-118.43343, 33.97247], [-118.43353, 33.97236], [-118.43366, 33.97224], [-118.43385, 33.97214], [-118.43519, 33.97153], [-118.43726, 33.97048], [-118.43765, 33.97025], [-118.43787, 33.97008], [-118.43817, 33.96978], [-118.44333, 33.96342], [-118.44359, 33.96312], [-118.44394, 33.96276], [-118.44421, 33.96249], [-118.44451, 33.96222], [-118.44505, 33.96178], [-118.44528, 33.96197], [-118.44816, 33.95963], [-118.4483, 33.95975], [-118.44862, 33.95994], [-118.45035, 33.96271], [-118.45044, 33.96286], [-118.45041, 33.96289], [-118.45041, 33.96291], [-118.45161, 33.96469]], [[-118.44504, 33.97165], [-118.44497, 33.97162], [-118.44481, 33.97186], [-118.44516, 33.97201], [-118.44531, 33.97178], [-118.44504, 33.97165]], [[-118.44334, 33.97151], [-118.44335, 33.97149], [-118.44329, 33.97118], [-118.44297, 33.97123], [-118.44303, 33.97155], [-118.44334, 33.97151]], [[-118.44456, 33.97055], [-118.44454, 33.97053], [-118.44426, 33.97067], [-118.44441, 33.97091], [-118.44445, 33.97095], [-118.44473, 33.97082], [-118.44456, 33.97055]], [[-118.44264, 33.96993], [-118.44258, 33.9699], [-118.44242, 33.97013], [-118.44277, 33.97029], [-118.44292, 33.97006], [-118.44264, 33.96993]], [[-118.44405, 33.9696], [-118.44391, 33.96938], [-118.44362, 33.96951], [-118.44381, 33.9698], [-118.44409, 33.96967], [-118.44405, 33.9696]], [[-118.4425, 33.96731], [-118.44226, 33.96707], [-118.44201, 33.96724], [-118.44225, 33.96749], [-118.4425, 33.96733], [-118.4425, 33.96731]], [[-118.44362, 33.9664], [-118.4435, 33.96623], [-118.44322, 33.96636], [-118.44341, 33.96664], [-118.44369, 33.96652], [-118.44362, 33.9664]], [[-118.44164, 33.96645], [-118.44164, 33.96644], [-118.44145, 33.96616], [-118.44118, 33.96628], [-118.44136, 33.96657], [-118.44164, 33.96645]], [[-118.44294, 33.96604], [-118.44307, 33.9658], [-118.44272, 33.96566], [-118.44259, 33.96591], [-118.44294, 33.96604]], [[-118.44467, 33.96591], [-118.44478, 33.96606], [-118.44506, 33.96592], [-118.44486, 33.96565], [-118.44459, 33.96577], [-118.44467, 33.96591]], [[-118.44438, 33.9652], [-118.44438, 33.96519], [-118.4442, 33.96491], [-118.44392, 33.96504], [-118.4441, 33.96533], [-118.44438, 33.9652]], [[-118.44834, 33.96124], [-118.44834, 33.96123], [-118.44816, 33.96095], [-118.44788, 33.96108], [-118.44806, 33.96136], [-118.44834, 33.96124]], [[-118.44066, 33.96931], [-118.44044, 33.96908], [-118.44019, 33.96924], [-118.44038, 33.96946], [-118.44044, 33.9695], [-118.44068, 33.96934], [-118.44066, 33.96931]]], [[[-118.42859, 33.97776], [-118.42515, 33.98022], [-118.42379, 33.97996], [-118.42537, 33.97911], [-118.42826, 33.97724], [-118.42859, 33.97776]]], [[[-118.43174, 33.97724], [-118.4317, 33.97735], [-118.43144, 33.97766], [-118.42946, 33.98012], [-118.42927, 33.98031], [-118.42887, 33.98057], [-118.42866, 33.98065], [-118.42828, 33.9807], [-118.42783, 33.98073], [-118.42528, 33.98024], [-118.42626, 33.97951], [-118.42754, 33.9786], [-118.42908, 33.97756], [-118.43008, 33.97693], [-118.43083, 33.97698], [-118.43096, 33.97692], [-118.43095, 33.9769], [-118.43022, 33.97685], [-118.43141, 33.97613], [-118.43141, 33.97616], [-118.43134, 33.97622], [-118.43125, 33.97636], [-118.43123, 33.97645], [-118.43125, 33.97664], [-118.43128, 33.97671], [-118.43136, 33.97682], [-118.4315, 33.97693], [-118.43167, 33.97702], [-118.43172, 33.9771], [-118.43174, 33.97717], [-118.43174, 33.97724]]], [[[-118.43032, 33.9812], [-118.43032, 33.9812], [-118.42931, 33.98101], [-118.42992, 33.98025], [-118.42992, 33.9805], [-118.42994, 33.98063], [-118.42999, 33.98077], [-118.43012, 33.98099], [-118.43032, 33.9812]]], [[[-118.43568, 33.97821], [-118.43245, 33.97964], [-118.43209, 33.98154], [-118.43051, 33.98124], [-118.43043, 33.98119], [-118.43027, 33.98105], [-118.43018, 33.98095], [-118.43009, 33.98081], [-118.43002, 33.9806], [-118.43, 33.98053], [-118.43, 33.9803], [-118.43006, 33.98007], [-118.43284, 33.97663], [-118.43284, 33.97661], [-118.43269, 33.97653], [-118.43293, 33.97623], [-118.43309, 33.97632], [-118.43312, 33.9763], [-118.43336, 33.97651], [-118.4337, 33.97677], [-118.43551, 33.978], [-118.43546, 33.97807], [-118.43568, 33.97821]]]]}	Restricted Access 2	6315	Ballona Wetlands Ecological Reserve	15789	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	Los Angeles 6	576.608	Ballona Wetlands ER	State Conservation Area 8	2
15631	15631	15630	{"type": "MultiPolygon", "coordinates": [[[[-118.42515, 33.98022], [-118.42488, 33.98042], [-118.42427, 33.98031], [-118.42454, 33.98011], [-118.42515, 33.98022]]], [[[-118.42921, 33.98035], [-118.42898, 33.98059], [-118.42873, 33.9809], [-118.42783, 33.98073], [-118.42828, 33.9807], [-118.42866, 33.98064], [-118.42887, 33.98056], [-118.42921, 33.98035]]], [[[-118.42901, 33.97746], [-118.42859, 33.97776], [-118.42826, 33.97724], [-118.42875, 33.97693], [-118.42887, 33.97722], [-118.42901, 33.97746]]], [[[-118.43285, 33.97662], [-118.43006, 33.98007], [-118.43, 33.9803], [-118.43002, 33.9806], [-118.4301, 33.98081], [-118.43018, 33.98095], [-118.43027, 33.98105], [-118.43049, 33.98123], [-118.43191, 33.9815], [-118.43208, 33.98162], [-118.43187, 33.98175], [-118.42892, 33.98119], [-118.43269, 33.97653], [-118.43285, 33.97662]], [[-118.43028, 33.98119], [-118.43029, 33.98117], [-118.43018, 33.98107], [-118.43009, 33.98096], [-118.42999, 33.98077], [-118.42993, 33.98058], [-118.42991, 33.98041], [-118.42992, 33.98028], [-118.42991, 33.98027], [-118.42941, 33.98086], [-118.42931, 33.981], [-118.43028, 33.98119]]], [[[-118.4323, 33.97539], [-118.42949, 33.97712], [-118.42928, 33.97727], [-118.42915, 33.97702], [-118.42904, 33.97676], [-118.42915, 33.97666], [-118.43197, 33.97484], [-118.4323, 33.97539]]]]}	Restricted Access 2	44627	Ballona Wetlands Ecological Reserve	15789	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	Los Angeles 6	11.92	Ballona Wetlands ER	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]);