calands: units_with_maps: 4 rows where DES_TP = 3, LAYER = 4 and MNG_AG

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

4 rows where DES_TP = 3, LAYER = 4 and MNG_AG_TYP = 24

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	DES_TP	GAP_STS
6684	6684	6683	{"type": "MultiPolygon", "coordinates": [[[[-116.74406, 32.79528], [-116.74353, 32.79522], [-116.74329, 32.79518], [-116.74299, 32.79506], [-116.74274, 32.79491], [-116.74253, 32.79473], [-116.74237, 32.79452], [-116.74203, 32.79381], [-116.74269, 32.79448], [-116.74301, 32.79475], [-116.74343, 32.795], [-116.74406, 32.79528]]], [[[-116.74494, 32.79562], [-116.73759, 32.79565], [-116.73759, 32.79051], [-116.73789, 32.79055], [-116.73815, 32.79063], [-116.73842, 32.79076], [-116.73864, 32.79093], [-116.73916, 32.79151], [-116.73931, 32.79174], [-116.73945, 32.79207], [-116.73953, 32.79219], [-116.73966, 32.79235], [-116.73981, 32.79247], [-116.74003, 32.79261], [-116.74114, 32.79309], [-116.74139, 32.79324], [-116.74162, 32.79342], [-116.7422, 32.7946], [-116.74237, 32.79482], [-116.74263, 32.79505], [-116.74295, 32.79523], [-116.74328, 32.79535], [-116.74354, 32.79539], [-116.74437, 32.79546], [-116.74467, 32.79553], [-116.74494, 32.79562]]], [[[-116.79678, 32.79555], [-116.78939, 32.79568], [-116.78942, 32.79919], [-116.78839, 32.79922], [-116.78843, 32.801], [-116.79007, 32.80102], [-116.7926, 32.80099], [-116.79263, 32.80279], [-116.78848, 32.80283], [-116.78424, 32.80279], [-116.78419, 32.79919], [-116.77998, 32.79918], [-116.77995, 32.7956], [-116.77575, 32.7956], [-116.77578, 32.80274], [-116.77261, 32.80276], [-116.7724, 32.80274], [-116.77211, 32.80269], [-116.77186, 32.80263], [-116.77035, 32.80211], [-116.76993, 32.80202], [-116.76944, 32.80196], [-116.76903, 32.80196], [-116.76866, 32.80199], [-116.76675, 32.80232], [-116.76636, 32.80235], [-116.76581, 32.80234], [-116.76495, 32.80223], [-116.76464, 32.80215], [-116.76436, 32.80203], [-116.76256, 32.80087], [-116.76202, 32.80057], [-116.76163, 32.80039], [-116.75955, 32.79963], [-116.75917, 32.79952], [-116.75871, 32.79944], [-116.75756, 32.7994], [-116.75701, 32.79933], [-116.75675, 32.79928], [-116.75557, 32.79895], [-116.75512, 32.79887], [-116.75485, 32.79885], [-116.75316, 32.79883], [-116.75283, 32.79885], [-116.75249, 32.79889], [-116.75205, 32.799], [-116.75162, 32.79915], [-116.75052, 32.79972], [-116.7503, 32.79981], [-116.7501, 32.79986], [-116.74989, 32.79989], [-116.74964, 32.7999], [-116.74943, 32.79988], [-116.74915, 32.7998], [-116.74876, 32.79962], [-116.74852, 32.79945], [-116.74831, 32.79924], [-116.74669, 32.7967], [-116.7464, 32.79635], [-116.74602, 32.79601], [-116.74601, 32.79564], [-116.74539, 32.79563], [-116.74374, 32.79496], [-116.74351, 32.79486], [-116.7433, 32.79473], [-116.74308, 32.79458], [-116.74288, 32.79441], [-116.74192, 32.79345], [-116.74156, 32.79315], [-116.74122, 32.79294], [-116.74012, 32.79246], [-116.73988, 32.79231], [-116.73976, 32.79219], [-116.73967, 32.79206], [-116.73948, 32.79166], [-116.73934, 32.79144], [-116.73886, 32.79089], [-116.73869, 32.79074], [-116.73845, 32.79058], [-116.73816, 32.79045], [-116.73791, 32.79038], [-116.73759, 32.79034], [-116.73759, 32.78851], [-116.73336, 32.78851], [-116.73331, 32.78476], [-116.73751, 32.78476], [-116.75429, 32.78443], [-116.7543, 32.77679], [-116.76715, 32.77703], [-116.76713, 32.77324], [-116.7714, 32.77332], [-116.77142, 32.77711], [-116.78805, 32.77718], [-116.78795, 32.77343], [-116.7965, 32.77338], [-116.79677, 32.78836], [-116.79252, 32.7884], [-116.79256, 32.79198], [-116.79677, 32.79194], [-116.79678, 32.79555]]], [[[-116.77178, 32.80276], [-116.76519, 32.80282], [-116.76299, 32.80279], [-116.75449, 32.80278], [-116.74607, 32.80287], [-116.74601, 32.79624], [-116.74632, 32.79654], [-116.74656, 32.79684], [-116.74806, 32.79921], [-116.74821, 32.7994], [-116.7484, 32.79959], [-116.74863, 32.79975], [-116.74954, 32.80016], [-116.74978, 32.80019], [-116.74989, 32.80018], [-116.75005, 32.80014], [-116.75067, 32.79984], [-116.75166, 32.79932], [-116.75207, 32.79917], [-116.75245, 32.79907], [-116.75283, 32.79901], [-116.75319, 32.79899], [-116.75482, 32.79902], [-116.75511, 32.79904], [-116.75554, 32.79911], [-116.75667, 32.79943], [-116.75698, 32.79949], [-116.75756, 32.79957], [-116.7587, 32.79961], [-116.7591, 32.79968], [-116.75948, 32.79979], [-116.76145, 32.80051], [-116.76196, 32.80073], [-116.76246, 32.80101], [-116.76427, 32.80217], [-116.7645, 32.80228], [-116.76478, 32.80237], [-116.7657, 32.8025], [-116.76602, 32.80252], [-116.76636, 32.80252], [-116.76682, 32.80247], [-116.7687, 32.80216], [-116.76907, 32.80213], [-116.76942, 32.80213], [-116.76989, 32.80218], [-116.77029, 32.80227], [-116.77178, 32.80276]]]]}	Open Access 1	4834	Loveland Reservoir	12983	2163	Sweetwater Authority 840	Special District 4	Special District - Other 26	http://www.sweetwater.org	Special District 4	2163	Sweetwater Authority 817	Special District 4	Special District - Other 24	http://www.sweetwater.org/index.aspx?page=111	San Diego 4	3292.465	Loveland Reservoir	Local Recreation Area 3	4
7018	7018	7017	{"type": "MultiPolygon", "coordinates": [[[[-117.92563, 33.95386], [-117.92551, 33.95393], [-117.92534, 33.95397], [-117.92519, 33.95397], [-117.92506, 33.95395], [-117.92502, 33.95392], [-117.925, 33.95387], [-117.92501, 33.95383], [-117.92529, 33.95348], [-117.92549, 33.95359], [-117.92554, 33.95377], [-117.92563, 33.95386]]], [[[-117.92633, 33.95169], [-117.92624, 33.9518], [-117.92622, 33.9518], [-117.92621, 33.95185], [-117.92598, 33.95214], [-117.92521, 33.95305], [-117.923, 33.95593], [-117.92265, 33.95634], [-117.9225, 33.95639], [-117.92154, 33.95636], [-117.92414, 33.95009], [-117.92426, 33.95043], [-117.92458, 33.95062], [-117.9247, 33.95081], [-117.925, 33.95102], [-117.92517, 33.95146], [-117.92545, 33.95147], [-117.9257, 33.9516], [-117.92585, 33.95156], [-117.92597, 33.95157], [-117.92633, 33.95169]]]]}	Open Access 1	6496	Powder Canyon Open Space	7479	2091	Native Habitat Preservation Authority 848	Special District 4	Special District - Other 26	http://www.habitatauthority.org/	Special District 4	2091	Native Habitat Preservation Authority 826	Special District 4	Special District - Other 24	http://www.lamountains.com/parks.asp?parkid=45	Los Angeles 6	27.946	Powder Canyon OS	Local Recreation Area 3	4
7638	7638	7637	{"type": "MultiPolygon", "coordinates": [[[[-117.01289, 32.68963], [-117.01273, 32.68983], [-117.01202, 32.69013], [-117.01125, 32.69018], [-117.01109, 32.69026], [-117.01139, 32.69105], [-117.01006, 32.69144], [-117.01049, 32.69249], [-117.01035, 32.69264], [-117.01027, 32.69282], [-117.01026, 32.69298], [-117.01031, 32.69315], [-117.01039, 32.69334], [-117.01048, 32.69348], [-117.01099, 32.69408], [-117.01119, 32.69426], [-117.01143, 32.69485], [-117.00956, 32.69534], [-117.00656, 32.69617], [-117.00618, 32.69512], [-117.00612, 32.69501], [-117.00435, 32.69499], [-117.0043, 32.69752], [-117.00427, 32.69832], [-117.00321, 32.69831], [-117.00225, 32.6976], [-117.0005, 32.69756], [-116.99905, 32.69953], [-116.99528, 32.70188], [-116.99528, 32.7009], [-116.99469, 32.70089], [-116.99469, 32.70118], [-116.99502, 32.70118], [-116.99502, 32.70219], [-116.99471, 32.70219], [-116.9947, 32.70197], [-116.99438, 32.70198], [-116.99437, 32.70129], [-116.9941, 32.7013], [-116.9941, 32.70218], [-116.99345, 32.70218], [-116.99345, 32.70131], [-116.99339, 32.7013], [-116.98986, 32.7032], [-116.98981, 32.70485], [-116.98865, 32.70483], [-116.98678, 32.70577], [-116.98678, 32.70679], [-116.98667, 32.70685], [-116.98666, 32.70691], [-116.98637, 32.70706], [-116.98598, 32.7073], [-116.98571, 32.70742], [-116.9846, 32.7074], [-116.98455, 32.70877], [-116.98409, 32.70894], [-116.98378, 32.70911], [-116.98276, 32.70928], [-116.98295, 32.7098], [-116.98281, 32.70996], [-116.981, 32.7124], [-116.98079, 32.71263], [-116.98037, 32.71304], [-116.98007, 32.71326], [-116.97835, 32.71428], [-116.97786, 32.71462], [-116.97751, 32.7149], [-116.97712, 32.71526], [-116.97656, 32.71585], [-116.9757, 32.71692], [-116.97558, 32.71703], [-116.97541, 32.71695], [-116.97547, 32.71378], [-116.97669, 32.71162], [-116.97486, 32.71069], [-116.97368, 32.71127], [-116.97187, 32.70999], [-116.96919, 32.71004], [-116.96717, 32.70956], [-116.96536, 32.7089], [-116.96242, 32.70748], [-116.96114, 32.7065], [-116.95846, 32.70964], [-116.95844, 32.711], [-116.9581, 32.71205], [-116.9566, 32.71183], [-116.95699, 32.71138], [-116.95618, 32.70806], [-116.95828, 32.70139], [-116.96282, 32.7014], [-116.96508, 32.70243], [-116.96727, 32.70129], [-116.96827, 32.70129], [-116.96827, 32.70216], [-116.97589, 32.70219], [-116.97777, 32.69987], [-116.97802, 32.69579], [-116.97824, 32.69276], [-116.97921, 32.69007], [-116.98595, 32.69006], [-116.98601, 32.69003], [-116.98608, 32.69003], [-116.98854, 32.68878], [-116.98853, 32.68673], [-116.98976, 32.68673], [-116.98976, 32.68514], [-116.99176, 32.68512], [-116.99176, 32.68303], [-116.99173, 32.68302], [-116.99173, 32.68284], [-116.99302, 32.68306], [-116.99443, 32.68312], [-116.99553, 32.68297], [-116.99641, 32.68324], [-116.99641, 32.68275], [-116.99729, 32.68246], [-116.99947, 32.68152], [-116.9996, 32.68176], [-117.00039, 32.68385], [-117.00165, 32.68355], [-117.00257, 32.68591], [-117.00289, 32.68583], [-117.00626, 32.68725], [-117.00585, 32.68795], [-117.00562, 32.68829], [-117.00584, 32.68882], [-117.00846, 32.68998], [-117.00851, 32.68999], [-117.00932, 32.68976], [-117.01078, 32.68938], [-117.01149, 32.6884], [-117.01152, 32.6883], [-117.01146, 32.68822], [-117.01148, 32.68813], [-117.01286, 32.68945], [-117.01289, 32.68963]], [[-116.9777, 32.71144], [-116.9769, 32.71243], [-116.97689, 32.71248], [-116.97658, 32.71286], [-116.97639, 32.71351], [-116.97646, 32.71453], [-116.97698, 32.71483], [-116.97704, 32.71474], [-116.97659, 32.71448], [-116.97651, 32.71352], [-116.9767, 32.71291], [-116.97787, 32.71141], [-116.97543, 32.71], [-116.97476, 32.70997], [-116.97399, 32.71061], [-116.97307, 32.70944], [-116.97225, 32.70918], [-116.97221, 32.70926], [-116.97223, 32.70928], [-116.97298, 32.70953], [-116.97395, 32.71076], [-116.97479, 32.71007], [-116.97537, 32.71009], [-116.9777, 32.71144]], [[-116.99677, 32.68615], [-116.99677, 32.68613], [-116.99635, 32.68554], [-116.99567, 32.68556], [-116.99569, 32.68666], [-116.99677, 32.68615]]], [[[-117.01103, 32.6939], [-117.01058, 32.6934], [-117.0105, 32.69326], [-117.01044, 32.69313], [-117.01041, 32.69298], [-117.01041, 32.69287], [-117.01046, 32.69273], [-117.01054, 32.69262], [-117.01103, 32.6939]]]]}	Open Access 1	7386	Sweetwater Reservoir	12984	2163	Sweetwater Authority 840	Special District 4	Special District - Other 26	http://www.sweetwater.org	Special District 4	2163	Sweetwater Authority 817	Special District 4	Special District - Other 24	http://www.sweetwater.org/index.aspx?page=112	San Diego 4	1773.187	Sweetwater Reservoir	Local Recreation Area 3	4
16046	16046	16045	{"type": "MultiPolygon", "coordinates": [[[[-117.96288, 33.96984], [-117.96249, 33.9704], [-117.96226, 33.97064], [-117.96228, 33.97088], [-117.96219, 33.97105], [-117.96204, 33.97114], [-117.96194, 33.97104], [-117.96175, 33.97093], [-117.96168, 33.97086], [-117.96159, 33.97082], [-117.96145, 33.97083], [-117.96125, 33.97077], [-117.96113, 33.97071], [-117.96104, 33.97064], [-117.96095, 33.97051], [-117.96093, 33.97033], [-117.96147, 33.96993], [-117.96156, 33.97004], [-117.96202, 33.97003], [-117.96229, 33.96993], [-117.9626, 33.96994], [-117.9628, 33.96978], [-117.96288, 33.96984]]], [[[-117.96145, 33.96988], [-117.96145, 33.9699], [-117.96096, 33.97026], [-117.96096, 33.97024], [-117.961, 33.97017], [-117.96112, 33.97006], [-117.96145, 33.96988]]], [[[-117.96165, 33.97087], [-117.96164, 33.97088], [-117.96156, 33.97086], [-117.96159, 33.97086], [-117.96165, 33.97087]]], [[[-117.97696, 33.96632], [-117.9769, 33.9664], [-117.97684, 33.96644], [-117.97661, 33.96649], [-117.97661, 33.96619], [-117.97696, 33.96632]]], [[[-117.97702, 33.96785], [-117.97665, 33.96784], [-117.97661, 33.96655], [-117.97689, 33.96666], [-117.97687, 33.96681], [-117.97678, 33.96705], [-117.97674, 33.96723], [-117.97673, 33.96739], [-117.97679, 33.96759], [-117.97684, 33.96769], [-117.97691, 33.96778], [-117.97702, 33.96785]]], [[[-117.98084, 33.96788], [-117.97717, 33.96785], [-117.97699, 33.96778], [-117.97694, 33.96773], [-117.97683, 33.96751], [-117.97679, 33.96737], [-117.9768, 33.96723], [-117.97685, 33.96706], [-117.97694, 33.96682], [-117.97697, 33.96664], [-117.97672, 33.96652], [-117.9768, 33.96651], [-117.97689, 33.96648], [-117.97698, 33.9664], [-117.97701, 33.96633], [-117.97851, 33.96688], [-117.97904, 33.96694], [-117.97955, 33.96708], [-117.9798, 33.96713], [-117.98007, 33.96716], [-117.98041, 33.96705], [-117.98052, 33.96678], [-117.98059, 33.96681], [-117.98023, 33.96761], [-117.98084, 33.96788]]]]}	Open Access 1	6504	Arroyo San Miguel Open Space	15625	2091	Native Habitat Preservation Authority 848	Special District 4	Special District - Other 26	http://www.habitatauthority.org/	Special District 4	2091	Native Habitat Preservation Authority 826	Special District 4	Special District - Other 24		Los Angeles 6	13.411	Arroyo San Miguel OS	Local Recreation Area 3	4

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