calands: units_with_maps: 7 rows where ACCESS_TYP = 3, AGNCY_TYP = 6 and MNG

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

7 rows where ACCESS_TYP = 3, AGNCY_TYP = 6 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
3009	3009	3008	{"type": "MultiPolygon", "coordinates": [[[[-117.29594, 33.79782], [-117.29594, 33.80085], [-117.29157, 33.80089], [-117.29164, 33.79364], [-117.28317, 33.79374], [-117.28315, 33.79302], [-117.28403, 33.79299], [-117.28399, 33.79073], [-117.28315, 33.79073], [-117.28311, 33.7865], [-117.28724, 33.78647], [-117.28726, 33.78834], [-117.29198, 33.7881], [-117.29215, 33.78821], [-117.29222, 33.78829], [-117.29226, 33.7884], [-117.29225, 33.7885], [-117.2922, 33.78861], [-117.29208, 33.78873], [-117.29166, 33.78892], [-117.29154, 33.78899], [-117.29142, 33.78913], [-117.29137, 33.7893], [-117.2914, 33.78947], [-117.29146, 33.78959], [-117.29214, 33.79026], [-117.29221, 33.79037], [-117.29223, 33.79047], [-117.29222, 33.79053], [-117.29219, 33.79062], [-117.29199, 33.79082], [-117.29188, 33.79101], [-117.29159, 33.79206], [-117.29162, 33.79352], [-117.29165, 33.79364], [-117.29171, 33.79374], [-117.29371, 33.79621], [-117.29499, 33.7976], [-117.29507, 33.79767], [-117.29523, 33.79775], [-117.29538, 33.7978], [-117.29553, 33.79782], [-117.2958, 33.79783], [-117.29594, 33.79782]]], [[[-117.29584, 33.7976], [-117.29576, 33.79766], [-117.29549, 33.79765], [-117.29532, 33.7976], [-117.29514, 33.79749], [-117.29387, 33.79611], [-117.29231, 33.79418], [-117.29584, 33.79413], [-117.29584, 33.7976]]]]}	No Public Access 3	48555	Steele Peak Reserve	33270	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	203.798	Steele Peak Reserve	0	Local Conservation Area 4	2
3821	3821	3820	{"type": "MultiPolygon", "coordinates": [[[[-116.37096, 33.91459], [-116.37095, 33.91825], [-116.36879, 33.91825], [-116.36881, 33.9146], [-116.37096, 33.91459]]], [[[-116.75455, 33.48392], [-116.75058, 33.48397], [-116.75043, 33.48095], [-116.75448, 33.4809], [-116.75455, 33.48392]]]]}	No Public Access 3	35202	Riverside County Habitat Conservation Agency 4	24448	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		Riverside 10	50.849	Riverside County Habitat Conservation Agency 4		None 321
4600	4600	4599	{"type": "Polygon", "coordinates": [[[-116.95429, 33.71487], [-116.94563, 33.71491], [-116.94558, 33.71136], [-116.95424, 33.71132], [-116.95429, 33.71487]]]}	No Public Access 3	35669	Unnamed Site - Riverside County Habitat Conservation Agency	18707	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		Riverside 10	78.203		0	Local Other or Unknown 14	4
13382	13382	13381	{"type": "Polygon", "coordinates": [[[-116.8256, 33.60948], [-116.82402, 33.60951], [-116.82394, 33.5982], [-116.82544, 33.5982], [-116.8256, 33.60948]]]}	No Public Access 3	35473	Riverside County Habitat Conservation Agency 3	24447	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		Riverside 10	44.142	Riverside County Habitat Conservation Agency 3		None 1153
13455	13455	13454	{"type": "Polygon", "coordinates": [[[-116.80135, 33.49175], [-116.79698, 33.49202], [-116.79687, 33.48835], [-116.80122, 33.4881], [-116.80135, 33.49175]]]}	No Public Access 3	35668	Riverside County Habitat Conservation Agency 1	24445	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		Riverside 10	40.695	Riverside County Habitat Conservation Agency 1		None 1162
13477	13477	13476	{"type": "Polygon", "coordinates": [[[-116.79687, 33.48835], [-116.79278, 33.48858], [-116.79265, 33.48463], [-116.79675, 33.48441], [-116.79687, 33.48835]]]}	No Public Access 3	35745	Riverside County Habitat Conservation Agency 2	24446	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		Riverside 10	41.246	Riverside County Habitat Conservation Agency 2		None 1163
16921	16921	16920	{"type": "MultiPolygon", "coordinates": [[[[-117.41584, 33.75669], [-117.39854, 33.75659], [-117.39853, 33.75106], [-117.38985, 33.75097], [-117.38968, 33.74215], [-117.39853, 33.74208], [-117.41583, 33.74208], [-117.41584, 33.75669]]], [[[-117.43326, 33.76202], [-117.43315, 33.76725], [-117.43301, 33.76727], [-117.42967, 33.76517], [-117.42998, 33.7651], [-117.43025, 33.76497], [-117.43122, 33.76418], [-117.43106, 33.76401], [-117.43088, 33.76386], [-117.43068, 33.76373], [-117.43046, 33.76361], [-117.43007, 33.76346], [-117.4298, 33.7634], [-117.42946, 33.76335], [-117.42931, 33.76329], [-117.42921, 33.76322], [-117.42914, 33.76314], [-117.42909, 33.76304], [-117.42906, 33.76291], [-117.42645, 33.76276], [-117.4275, 33.76535], [-117.42702, 33.76538], [-117.42672, 33.76537], [-117.42632, 33.76532], [-117.42588, 33.76522], [-117.42574, 33.76554], [-117.42557, 33.76578], [-117.42542, 33.76593], [-117.42492, 33.76635], [-117.42484, 33.76647], [-117.42478, 33.76664], [-117.42478, 33.7668], [-117.42482, 33.76696], [-117.4249, 33.76711], [-117.42503, 33.76724], [-117.42519, 33.76733], [-117.42537, 33.7674], [-117.42488, 33.7685], [-117.42168, 33.76555], [-117.42108, 33.76601], [-117.42144, 33.76153], [-117.42394, 33.76226], [-117.42413, 33.76186], [-117.42434, 33.76152], [-117.42563, 33.75971], [-117.42569, 33.75959], [-117.42572, 33.75946], [-117.42574, 33.75933], [-117.42572, 33.75921], [-117.426, 33.75921], [-117.42628, 33.75925], [-117.42652, 33.75933], [-117.42669, 33.75943], [-117.42686, 33.75957], [-117.42701, 33.75978], [-117.42707, 33.75993], [-117.42716, 33.76028], [-117.42722, 33.76038], [-117.42729, 33.76045], [-117.42737, 33.7605], [-117.42749, 33.76055], [-117.42759, 33.76057], [-117.42772, 33.76056], [-117.42803, 33.7605], [-117.42832, 33.76041], [-117.42856, 33.7603], [-117.42892, 33.76009], [-117.42933, 33.75972], [-117.42952, 33.75962], [-117.42969, 33.75957], [-117.42986, 33.75956], [-117.43004, 33.75957], [-117.43017, 33.75961], [-117.43036, 33.7597], [-117.43051, 33.75983], [-117.43061, 33.75999], [-117.43066, 33.76017], [-117.43065, 33.76031], [-117.43061, 33.76045], [-117.43029, 33.76097], [-117.43326, 33.76202]]], [[[-117.41246, 33.77321], [-117.41141, 33.77613], [-117.40868, 33.77481], [-117.40752, 33.77567], [-117.40733, 33.77553], [-117.40716, 33.77545], [-117.4067, 33.77534], [-117.40652, 33.77527], [-117.40636, 33.77517], [-117.40604, 33.77488], [-117.40588, 33.77479], [-117.40562, 33.77471], [-117.40536, 33.77468], [-117.40521, 33.77465], [-117.40497, 33.77455], [-117.40484, 33.77445], [-117.40474, 33.77433], [-117.40466, 33.7742], [-117.40453, 33.77388], [-117.40445, 33.77376], [-117.40427, 33.77354], [-117.40428, 33.77342], [-117.40451, 33.77324], [-117.40466, 33.77307], [-117.40476, 33.77292], [-117.40485, 33.77272], [-117.40928, 33.77406], [-117.41067, 33.77234], [-117.4119, 33.773], [-117.41217, 33.77312], [-117.41246, 33.77321]]], [[[-117.45059, 33.77844], [-117.45055, 33.78566], [-117.44043, 33.78573], [-117.44042, 33.7785], [-117.45059, 33.77844]]], [[[-117.43312, 33.76867], [-117.43306, 33.77133], [-117.43181, 33.77135], [-117.43181, 33.77855], [-117.43183, 33.78291], [-117.42876, 33.78264], [-117.42755, 33.78493], [-117.42756, 33.78494], [-117.43184, 33.78482], [-117.43184, 33.7858], [-117.42977, 33.78582], [-117.42966, 33.79286], [-117.41752, 33.79286], [-117.41735, 33.79001], [-117.41903, 33.78993], [-117.41839, 33.78746], [-117.41653, 33.78574], [-117.41461, 33.78525], [-117.41461, 33.78416], [-117.41555, 33.78461], [-117.4158, 33.78459], [-117.4162, 33.7846], [-117.4166, 33.78466], [-117.41696, 33.78475], [-117.41733, 33.78489], [-117.41766, 33.78506], [-117.41819, 33.78544], [-117.41846, 33.78558], [-117.41893, 33.78573], [-117.41935, 33.78577], [-117.41966, 33.78576], [-117.42005, 33.78567], [-117.42153, 33.78506], [-117.42154, 33.78504], [-117.41945, 33.78181], [-117.42273, 33.78061], [-117.42019, 33.77844], [-117.41815, 33.77983], [-117.41798, 33.77969], [-117.41461, 33.77756], [-117.41461, 33.77542], [-117.41776, 33.77541], [-117.41776, 33.77261], [-117.41818, 33.77254], [-117.41837, 33.77252], [-117.41866, 33.77255], [-117.41892, 33.77265], [-117.41915, 33.7728], [-117.42002, 33.77366], [-117.42003, 33.77136], [-117.4234, 33.77135], [-117.4238, 33.76976], [-117.42541, 33.77031], [-117.42567, 33.77036], [-117.42592, 33.77038], [-117.42612, 33.77038], [-117.4264, 33.77036], [-117.42841, 33.76999], [-117.42856, 33.7699], [-117.42866, 33.76979], [-117.4287, 33.76965], [-117.42869, 33.7695], [-117.43312, 33.76867]], [[-117.4252, 33.78511], [-117.4248, 33.78515], [-117.42446, 33.78513], [-117.42422, 33.78507], [-117.42156, 33.78784], [-117.42279, 33.78849], [-117.42594, 33.78708], [-117.42565, 33.78628], [-117.4252, 33.78511]]], [[[-117.45051, 33.79286], [-117.45048, 33.80012], [-117.43234, 33.80008], [-117.43228, 33.79287], [-117.43174, 33.79286], [-117.43179, 33.78945], [-117.43608, 33.78941], [-117.43605, 33.79286], [-117.45051, 33.79286]]], [[[-117.45891, 33.80378], [-117.4589, 33.80739], [-117.45353, 33.80736], [-117.45354, 33.80558], [-117.45245, 33.80557], [-117.45246, 33.80374], [-117.45891, 33.80378]]], [[[-117.43658, 33.80366], [-117.43657, 33.80732], [-117.43442, 33.80731], [-117.43446, 33.80365], [-117.43658, 33.80366]]], [[[-117.49364, 33.80747], [-117.49354, 33.81462], [-117.48485, 33.81461], [-117.48478, 33.81924], [-117.46764, 33.80498], [-117.46768, 33.80166], [-117.47251, 33.80168], [-117.47254, 33.80022], [-117.47639, 33.80024], [-117.48505, 33.80022], [-117.48495, 33.80741], [-117.49364, 33.80747]]], [[[-117.48467, 33.82746], [-117.48464, 33.82912], [-117.48083, 33.82912], [-117.48154, 33.82875], [-117.4821, 33.82837], [-117.48229, 33.82828], [-117.48244, 33.82823], [-117.48261, 33.82821], [-117.48287, 33.82822], [-117.48296, 33.8282], [-117.4831, 33.82823], [-117.48335, 33.82823], [-117.48347, 33.82821], [-117.48363, 33.82815], [-117.48467, 33.82746]]], [[[-117.39731, 33.82543], [-117.3973, 33.82722], [-117.39511, 33.82722], [-117.39511, 33.82559], [-117.3957, 33.82559], [-117.39571, 33.82542], [-117.39731, 33.82543]]], [[[-117.4755, 33.82912], [-117.47149, 33.82912], [-117.47149, 33.829], [-117.47153, 33.82878], [-117.47157, 33.82866], [-117.47169, 33.82846], [-117.47185, 33.82828], [-117.47202, 33.82816], [-117.47221, 33.82805], [-117.47243, 33.82798], [-117.47265, 33.82794], [-117.47287, 33.82793], [-117.4744, 33.82797], [-117.47461, 33.82804], [-117.47477, 33.82811], [-117.47492, 33.82821], [-117.47504, 33.82832], [-117.47515, 33.82845], [-117.47527, 33.8288], [-117.47534, 33.82893], [-117.4755, 33.82912]]], [[[-117.48476, 33.82077], [-117.48467, 33.82722], [-117.48352, 33.82794], [-117.48331, 33.82801], [-117.48264, 33.82799], [-117.48218, 33.82808], [-117.48136, 33.82859], [-117.48071, 33.82893], [-117.48039, 33.82902], [-117.47995, 33.82912], [-117.47586, 33.82912], [-117.47566, 33.82894], [-117.47557, 33.82883], [-117.47552, 33.82873], [-117.47539, 33.82837], [-117.47522, 33.82816], [-117.47507, 33.82803], [-117.4749, 33.82792], [-117.47471, 33.82783], [-117.47441, 33.82775], [-117.47272, 33.82771], [-117.47258, 33.82773], [-117.47232, 33.82778], [-117.47208, 33.82786], [-117.47186, 33.82798], [-117.47166, 33.82813], [-117.47146, 33.82835], [-117.47132, 33.82859], [-117.47124, 33.82885], [-117.47122, 33.82912], [-117.46727, 33.82912], [-117.46739, 33.82186], [-117.46306, 33.82186], [-117.46302, 33.82549], [-117.45869, 33.8255], [-117.45867, 33.82639], [-117.45438, 33.8264], [-117.4544, 33.82369], [-117.45013, 33.82368], [-117.45016, 33.82186], [-117.44743, 33.82185], [-117.44744, 33.81991], [-117.44064, 33.81984], [-117.4405, 33.81459], [-117.45026, 33.81459], [-117.45027, 33.81096], [-117.46318, 33.81099], [-117.46318, 33.8146], [-117.4675, 33.8146], [-117.46762, 33.80652], [-117.48476, 33.82077]], [[-117.47116, 33.81737], [-117.47087, 33.81784], [-117.4716, 33.81816], [-117.47189, 33.8177], [-117.47116, 33.81737]]]]}	No Public Access 3	48549	Lake Mathews - Estelle Mountain Reserve	33268	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	4385.749	Lake Mathews - Estelle Mtn. Reserve	1982	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]);