calands: superunits_with_maps: 7 rows where MNG_AGENCY = 258 and MNG_AG

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

7 rows where MNG_AGENCY = 258 and MNG_AG_TYP = 4

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME	YR_EST
859	859	858	{"type": "Polygon", "coordinates": [[[-117.42159, 33.98048], [-117.42081, 33.98144], [-117.41987, 33.9818], [-117.41784, 33.98249], [-117.41784, 33.98251], [-117.41846, 33.98293], [-117.41668, 33.98402], [-117.41511, 33.98494], [-117.41511, 33.98495], [-117.41679, 33.98621], [-117.41677, 33.98622], [-117.41647, 33.98611], [-117.41616, 33.98602], [-117.41589, 33.98597], [-117.41561, 33.98594], [-117.41415, 33.98593], [-117.41401, 33.98606], [-117.4138, 33.98591], [-117.41345, 33.9859], [-117.41311, 33.98586], [-117.41278, 33.9858], [-117.41244, 33.98569], [-117.41217, 33.98558], [-117.41188, 33.98542], [-117.40831, 33.98324], [-117.40796, 33.98304], [-117.40754, 33.98284], [-117.40716, 33.98271], [-117.40677, 33.9826], [-117.40638, 33.98252], [-117.40581, 33.98246], [-117.40524, 33.98246], [-117.4046, 33.98253], [-117.40404, 33.98265], [-117.40351, 33.98283], [-117.40295, 33.9831], [-117.40268, 33.98325], [-117.40243, 33.98342], [-117.40202, 33.98376], [-117.40249, 33.98324], [-117.40324, 33.98249], [-117.40376, 33.98201], [-117.40431, 33.98155], [-117.40525, 33.98081], [-117.40543, 33.98095], [-117.40598, 33.98057], [-117.40598, 33.98055], [-117.40584, 33.98039], [-117.40712, 33.97954], [-117.40516, 33.97714], [-117.4044, 33.97762], [-117.40329, 33.97839], [-117.40257, 33.97893], [-117.40154, 33.97979], [-117.40088, 33.98038], [-117.39995, 33.9813], [-117.39801, 33.98342], [-117.40257, 33.97667], [-117.40275, 33.97634], [-117.40381, 33.97674], [-117.40711, 33.97636], [-117.40986, 33.97527], [-117.41046, 33.97568], [-117.41297, 33.97467], [-117.41986, 33.97931], [-117.41979, 33.97937], [-117.41979, 33.97939], [-117.42055, 33.97986], [-117.42099, 33.98007], [-117.42159, 33.98048]]]}	Open Access 1	Ranch Jurupa Regional Park	http://www.rivcoparks.org/parks/rancho-jurupa/rancho-jurupa-park-home/	9395	2123	Riverside County Regional Park and Open Space District 258	Special District 4	Recreation/Parks District 4	http://www.riversidecountyparks.org/	Special District 4	309.406	Ranch Jurupa RP
6787	6787	6786	{"type": "Polygon", "coordinates": [[[-117.06136, 33.78295], [-117.05948, 33.78299], [-117.05934, 33.78716], [-117.05089, 33.78742], [-117.05152, 33.78022], [-117.05245, 33.78019], [-117.05246, 33.78027], [-117.0525, 33.78037], [-117.05261, 33.78051], [-117.05279, 33.78061], [-117.05299, 33.78066], [-117.05311, 33.78066], [-117.05324, 33.78063], [-117.05381, 33.78044], [-117.05395, 33.78045], [-117.05402, 33.7805], [-117.05408, 33.78058], [-117.05408, 33.78064], [-117.05404, 33.78083], [-117.05403, 33.78095], [-117.05406, 33.78108], [-117.05414, 33.78122], [-117.05426, 33.78133], [-117.05439, 33.78142], [-117.05454, 33.78147], [-117.05474, 33.78148], [-117.05491, 33.78147], [-117.0551, 33.78143], [-117.05597, 33.78117], [-117.05598, 33.78101], [-117.055, 33.78129], [-117.05476, 33.78132], [-117.0546, 33.78131], [-117.05442, 33.78123], [-117.05434, 33.78117], [-117.05427, 33.78108], [-117.05423, 33.78092], [-117.05428, 33.78067], [-117.05427, 33.78055], [-117.0542, 33.78042], [-117.05409, 33.78033], [-117.05394, 33.78028], [-117.05377, 33.78028], [-117.05317, 33.78048], [-117.05298, 33.78049], [-117.05286, 33.78046], [-117.05276, 33.78039], [-117.05268, 33.7803], [-117.05265, 33.78019], [-117.05959, 33.77997], [-117.0596, 33.78013], [-117.06066, 33.7801], [-117.06071, 33.78014], [-117.06072, 33.78046], [-117.06057, 33.78122], [-117.06056, 33.78137], [-117.06058, 33.7815], [-117.06063, 33.78163], [-117.06072, 33.78183], [-117.06086, 33.78198], [-117.06095, 33.78204], [-117.06109, 33.78209], [-117.0612, 33.78211], [-117.06135, 33.78211], [-117.06136, 33.78295]]]}	Open Access 1	Maze Stone Park		21984	2123	Riverside County Regional Park and Open Space District 258	Special District 4	Recreation/Parks District 4	http://www.riversidecountyparks.org/	Special District 4	158.257	Maze Stone Park
6791	6791	6790	{"type": "Polygon", "coordinates": [[[-116.73692, 33.70731], [-116.73692, 33.70798], [-116.73675, 33.71539], [-116.73248, 33.71537], [-116.73258, 33.70742], [-116.73272, 33.70733], [-116.73692, 33.70731]]]}	Open Access 1	McCall Memorial Park		21990	2123	Riverside County Regional Park and Open Space District 258	Special District 4	Recreation/Parks District 4	http://www.riversidecountyparks.org/	Special District 4	88.361	McCall Memorial Park
10116	10116	10115	{"type": "Polygon", "coordinates": [[[-117.10388, 33.94678], [-117.10311, 33.9613], [-117.10328, 33.96486], [-117.09472, 33.96481], [-117.09502, 33.97011], [-117.09504, 33.97163], [-117.09403, 33.97124], [-117.09293, 33.97167], [-117.09235, 33.97323], [-117.09284, 33.97395], [-117.09131, 33.97423], [-117.09079, 33.97429], [-117.08999, 33.9743], [-117.08919, 33.97422], [-117.08868, 33.97412], [-117.08842, 33.97405], [-117.08817, 33.97398], [-117.08777, 33.97384], [-117.0875, 33.97368], [-117.08738, 33.97359], [-117.08683, 33.97309], [-117.08654, 33.97287], [-117.08636, 33.97278], [-117.08619, 33.97272], [-117.08598, 33.97267], [-117.08584, 33.9726], [-117.0857, 33.97255], [-117.08546, 33.97252], [-117.08522, 33.97254], [-117.08141, 33.97041], [-117.0813, 33.97052], [-117.07767, 33.96848], [-117.07698, 33.96806], [-117.07633, 33.9676], [-117.07622, 33.96769], [-117.07616, 33.96765], [-117.07555, 33.96719], [-117.0692, 33.96178], [-117.06634, 33.95929], [-117.06638, 33.95923], [-117.06505, 33.95806], [-117.06498, 33.9581], [-117.05297, 33.94762], [-117.05238, 33.94713], [-117.05212, 33.94737], [-117.05116, 33.94668], [-117.05045, 33.94621], [-117.04969, 33.94574], [-117.04886, 33.9453], [-117.048, 33.94489], [-117.04708, 33.94451], [-117.04621, 33.94419], [-117.04528, 33.9439], [-117.04543, 33.94348], [-117.04373, 33.94302], [-117.04357, 33.94344], [-117.04236, 33.94316], [-117.04139, 33.94298], [-117.04021, 33.94283], [-117.03937, 33.94277], [-117.03882, 33.94277], [-117.03819, 33.9428], [-117.03417, 33.94319], [-117.03415, 33.93543], [-117.03667, 33.93645], [-117.03667, 33.9365], [-117.03716, 33.93672], [-117.03739, 33.93686], [-117.03761, 33.93701], [-117.03802, 33.93735], [-117.03904, 33.93845], [-117.03922, 33.93862], [-117.0396, 33.93895], [-117.04001, 33.93925], [-117.04023, 33.93939], [-117.04091, 33.93977], [-117.04165, 33.94008], [-117.04528, 33.94134], [-117.05005, 33.94303], [-117.05085, 33.94334], [-117.05162, 33.94369], [-117.05238, 33.94406], [-117.05432, 33.94511], [-117.0581, 33.94722], [-117.05866, 33.94746], [-117.05916, 33.94764], [-117.05965, 33.94777], [-117.06022, 33.94788], [-117.06069, 33.94794], [-117.06124, 33.94797], [-117.06171, 33.94797], [-117.06222, 33.94794], [-117.06276, 33.94786], [-117.0688, 33.94677], [-117.06882, 33.9469], [-117.06968, 33.9469], [-117.08582, 33.94427], [-117.08584, 33.94339], [-117.08648, 33.94321], [-117.08707, 33.94299], [-117.09015, 33.94194], [-117.0904, 33.94184], [-117.09064, 33.94171], [-117.09217, 33.94072], [-117.09288, 33.94034], [-117.09363, 33.94003], [-117.09416, 33.93986], [-117.09476, 33.93969], [-117.09465, 33.9429], [-117.10384, 33.9428], [-117.10373, 33.94676], [-117.10388, 33.94678]]]}	Open Access 1	Norton Younglove Reserve		33274	2123	Riverside County Regional Park and Open Space District 258	Special District 4	Recreation/Parks District 4	http://www.riversidecountyparks.org/	Special District 4	2643.579	Norton Younglove Reserve
14285	14285	14284	{"type": "MultiPolygon", "coordinates": [[[[-116.23302, 33.58134], [-116.23293, 33.58128], [-116.23136, 33.57741], [-116.23092, 33.57648], [-116.22951, 33.57441], [-116.22812, 33.57509], [-116.22717, 33.57368], [-116.22437, 33.5737], [-116.22436, 33.57461], [-116.22274, 33.57463], [-116.22139, 33.57376], [-116.22098, 33.57302], [-116.22093, 33.57257], [-116.22053, 33.57243], [-116.22029, 33.57202], [-116.21854, 33.57148], [-116.21604, 33.57082], [-116.21605, 33.56939], [-116.22448, 33.56938], [-116.22417, 33.57222], [-116.22418, 33.57224], [-116.22904, 33.56937], [-116.233, 33.56936], [-116.23299, 33.57257], [-116.23302, 33.58134]]], [[[-116.61537, 33.98365], [-116.61085, 33.98366], [-116.61082, 33.98821], [-116.60649, 33.98822], [-116.60648, 33.98541], [-116.60215, 33.98543], [-116.60214, 33.98821], [-116.60433, 33.98822], [-116.60433, 33.99003], [-116.59774, 33.99004], [-116.59775, 33.98278], [-116.61537, 33.98276], [-116.61537, 33.98365]], [[-116.59887, 33.98636], [-116.59885, 33.98823], [-116.59994, 33.98822], [-116.59994, 33.98637], [-116.59887, 33.98636]]]]}	Open Access 1	Unnamed site - Riverside County Regional Park and Open Space District		28656	2123	Riverside County Regional Park and Open Space District 258	Special District 4	Recreation/Parks District 4	http://www.riversidecountyparks.org/	Special District 4	372.375
14481	14481	14480	{"type": "Polygon", "coordinates": [[[-117.30212, 33.52516], [-117.30028, 33.52911], [-117.29792, 33.53406], [-117.29703, 33.53775], [-117.29677, 33.53867], [-117.29553, 33.54139], [-117.29365, 33.54205], [-117.29295, 33.54294], [-117.28821, 33.54579], [-117.28777, 33.54435], [-117.28727, 33.54342], [-117.2852, 33.54184], [-117.28378, 33.54002], [-117.28222, 33.53975], [-117.27324, 33.54364], [-117.27138, 33.54321], [-117.2717, 33.54223], [-117.27183, 33.54172], [-117.27195, 33.54103], [-117.27201, 33.54033], [-117.27209, 33.53702], [-117.27206, 33.53615], [-117.27192, 33.53432], [-117.27192, 33.53403], [-117.27197, 33.53357], [-117.27205, 33.53314], [-117.27267, 33.53064], [-117.27278, 33.53023], [-117.27298, 33.52969], [-117.27346, 33.52855], [-117.27706, 33.52778], [-117.27748, 33.52772], [-117.27781, 33.5277], [-117.27813, 33.52771], [-117.27977, 33.52793], [-117.28008, 33.52795], [-117.28038, 33.52794], [-117.2804, 33.52793], [-117.2807, 33.5279], [-117.28101, 33.52785], [-117.28201, 33.5276], [-117.28234, 33.52753], [-117.28272, 33.52749], [-117.2831, 33.52748], [-117.28584, 33.5276], [-117.28614, 33.52763], [-117.28646, 33.52768], [-117.28692, 33.52781], [-117.28726, 33.52796], [-117.28882, 33.52881], [-117.28926, 33.529], [-117.28963, 33.5291], [-117.29, 33.52916], [-117.29044, 33.52918], [-117.29083, 33.52916], [-117.29109, 33.52913], [-117.29141, 33.52905], [-117.29181, 33.52892], [-117.29205, 33.52881], [-117.29233, 33.52865], [-117.29254, 33.5285], [-117.29273, 33.52834], [-117.29291, 33.52817], [-117.29315, 33.52786], [-117.2933, 33.52762], [-117.29422, 33.52577], [-117.29437, 33.5255], [-117.29462, 33.52513], [-117.29514, 33.52451], [-117.29576, 33.5249], [-117.29601, 33.525], [-117.2964, 33.52509], [-117.29671, 33.5251], [-117.29697, 33.52508], [-117.29806, 33.52484], [-117.29827, 33.52483], [-117.29844, 33.52484], [-117.29873, 33.52491], [-117.29901, 33.52503], [-117.29924, 33.52519], [-117.29937, 33.52531], [-117.29972, 33.52575], [-117.29988, 33.52589], [-117.30011, 33.52601], [-117.30029, 33.52607], [-117.30048, 33.52609], [-117.30067, 33.5261], [-117.30082, 33.52608], [-117.30097, 33.52604], [-117.30117, 33.52596], [-117.30141, 33.52579], [-117.30185, 33.52533], [-117.30212, 33.52516]]]}	Open Access 1	Santa Rosa Plateau Ecological Reserve	http://www.rivcoparks.org/education/santa-rosa-plateau/santa-rosa-plateau/	9398	2123	Riverside County Regional Park and Open Space District 258	Special District 4	Recreation/Parks District 4	http://www.riversidecountyparks.org/	Special District 4	986.338	Santa Rosa Plateau ER	1994
15273	15273	15272	{"type": "MultiPolygon", "coordinates": [[[[-117.44904, 33.97183], [-117.4458, 33.97245], [-117.44529, 33.97253], [-117.44488, 33.97256], [-117.44443, 33.97256], [-117.44384, 33.97253], [-117.44296, 33.97243], [-117.44238, 33.97232], [-117.44195, 33.97221], [-117.44112, 33.97194], [-117.44033, 33.9716], [-117.43995, 33.97141], [-117.43958, 33.97119], [-117.43978, 33.97116], [-117.43979, 33.97115], [-117.43939, 33.9709], [-117.43904, 33.97065], [-117.43597, 33.96811], [-117.43615, 33.9676], [-117.43614, 33.96686], [-117.44693, 33.96686], [-117.44696, 33.96596], [-117.44747, 33.96596], [-117.44772, 33.96682], [-117.4477, 33.96759], [-117.44795, 33.9676], [-117.4483, 33.96878], [-117.44756, 33.96893], [-117.44754, 33.96895], [-117.44766, 33.96929], [-117.44829, 33.96944], [-117.44846, 33.97004], [-117.44841, 33.97004], [-117.4484, 33.97005], [-117.44904, 33.97183]]], [[[-117.46554, 33.96612], [-117.46487, 33.96657], [-117.46133, 33.9671], [-117.4598, 33.96673], [-117.45629, 33.96732], [-117.45361, 33.96876], [-117.45364, 33.97094], [-117.44952, 33.97174], [-117.44948, 33.97161], [-117.45043, 33.97142], [-117.45044, 33.9714], [-117.44992, 33.96997], [-117.44927, 33.97012], [-117.44899, 33.97009], [-117.44863, 33.96883], [-117.44845, 33.96884], [-117.44823, 33.96808], [-117.44825, 33.96761], [-117.44879, 33.96759], [-117.44883, 33.96597], [-117.44914, 33.96596], [-117.44915, 33.96506], [-117.4536, 33.96509], [-117.45361, 33.96586], [-117.45469, 33.96588], [-117.45823, 33.9649], [-117.45938, 33.96494], [-117.46012, 33.96429], [-117.46308, 33.96265], [-117.46429, 33.96193], [-117.46485, 33.96213], [-117.465, 33.96251], [-117.46512, 33.96287], [-117.46526, 33.96344], [-117.46553, 33.96548], [-117.46541, 33.96551], [-117.46554, 33.96612]]]]}	Open Access 1	Santa Ana River Wildlife Area	https://riversideca.gov/publicworks/traffic/bicycleprogram/pdf/santa-ana-river-trail-map.pdf	29297	2123	Riverside County Regional Park and Open Space District 258	Special District 4	Recreation/Parks District 4	http://www.riversidecountyparks.org/	Special District 4	302.487	Santa Ana River Wildlife Area

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);