calands: superunits_with_maps: 32 rows where ACCESS_TYP = 1, MNG_AGENCY = 165 and MNG_AG

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

32 rows where ACCESS_TYP = 1, MNG_AGENCY = 165 and MNG_AG_LEV = 3

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
671	671	670	{"type": "MultiPolygon", "coordinates": [[[[-117.35822, 33.80178], [-117.35821, 33.80646], [-117.35818, 33.8076], [-117.35807, 33.80825], [-117.35787, 33.80896], [-117.35779, 33.8093], [-117.35773, 33.80975], [-117.35771, 33.81021], [-117.35791, 33.81283], [-117.3581, 33.81404], [-117.35812, 33.81452], [-117.34499, 33.8145], [-117.34509, 33.80721], [-117.34514, 33.79991], [-117.35388, 33.79993], [-117.35387, 33.80177], [-117.35822, 33.80178]]], [[[-117.36258, 33.8088], [-117.36255, 33.81453], [-117.35849, 33.81452], [-117.35846, 33.81401], [-117.35827, 33.8128], [-117.35807, 33.81031], [-117.35807, 33.80999], [-117.35811, 33.80956], [-117.35817, 33.80924], [-117.35828, 33.80883], [-117.36258, 33.8088]]]]}	Open Access 1	Harford Springs Reserve	http://www.rivcoparks.org/?s=Harford+Springs+Reserve	9495	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	523.315	Harford Springs Reserve
823	823	822	{"type": "Polygon", "coordinates": [[[-117.43583, 33.96849], [-117.43536, 33.96974], [-117.43501, 33.97033], [-117.43446, 33.97086], [-117.43442, 33.97085], [-117.43427, 33.971], [-117.43171, 33.97096], [-117.43118, 33.97227], [-117.433, 33.97287], [-117.43293, 33.9733], [-117.43265, 33.97349], [-117.43197, 33.97466], [-117.43188, 33.97477], [-117.43138, 33.97492], [-117.43111, 33.97531], [-117.43102, 33.97528], [-117.43086, 33.97546], [-117.4307, 33.9756], [-117.43, 33.97602], [-117.4298, 33.9762], [-117.42956, 33.97649], [-117.42946, 33.97658], [-117.42929, 33.97668], [-117.42923, 33.97697], [-117.429, 33.97716], [-117.42792, 33.97905], [-117.42513, 33.97828], [-117.42577, 33.97715], [-117.42648, 33.97737], [-117.42771, 33.97462], [-117.42799, 33.97381], [-117.42718, 33.97361], [-117.42691, 33.97415], [-117.42673, 33.97411], [-117.42663, 33.97435], [-117.42677, 33.97442], [-117.42548, 33.97708], [-117.42489, 33.97821], [-117.42302, 33.97769], [-117.42279, 33.9779], [-117.4225, 33.9787], [-117.4225, 33.97903], [-117.4218, 33.98023], [-117.42087, 33.97983], [-117.4201, 33.97938], [-117.41876, 33.97847], [-117.42046, 33.97761], [-117.42057, 33.97678], [-117.41981, 33.97625], [-117.41726, 33.97756], [-117.41297, 33.97467], [-117.41574, 33.97359], [-117.41586, 33.97327], [-117.41563, 33.97311], [-117.41662, 33.96931], [-117.41524, 33.96978], [-117.41515, 33.97005], [-117.41285, 33.97113], [-117.41121, 33.96974], [-117.41245, 33.96917], [-117.41288, 33.96841], [-117.41392, 33.96765], [-117.41477, 33.96672], [-117.41487, 33.96652], [-117.4155, 33.96578], [-117.41588, 33.96605], [-117.41621, 33.96583], [-117.41621, 33.96581], [-117.4157, 33.96541], [-117.41653, 33.96498], [-117.41659, 33.96504], [-117.41774, 33.96484], [-117.42157, 33.96549], [-117.42287, 33.96409], [-117.42349, 33.96386], [-117.42531, 33.96378], [-117.42585, 33.96357], [-117.42679, 33.96353], [-117.42722, 33.96266], [-117.42797, 33.9627], [-117.42798, 33.96274], [-117.42896, 33.96279], [-117.43583, 33.96849]]]}	Open Access 1	Martha McLean Anza Narrows Park	http://santaanarivertrail.org/home.html	9503	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	615.589	Martha McLean Anza Narrows Park
959	959	958	{"type": "Polygon", "coordinates": [[[-117.34495, 33.64111], [-117.34461, 33.64156], [-117.34354, 33.6409], [-117.34412, 33.64026], [-117.34444, 33.64045], [-117.34428, 33.64065], [-117.34495, 33.64111]]]}	Open Access 1	Perret Park		33593	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	2.065	Perret Park
968	968	967	{"type": "Polygon", "coordinates": [[[-117.12413, 33.54745], [-117.1241, 33.54807], [-117.12362, 33.54832], [-117.12356, 33.54832], [-117.12379, 33.54812], [-117.12375, 33.54798], [-117.1237, 33.54794], [-117.12368, 33.54781], [-117.12365, 33.54779], [-117.12366, 33.54745], [-117.12413, 33.54745]]]}	Open Access 1	Discovery Park		33594	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	0.79	Discovery Park
969	969	968	{"type": "Polygon", "coordinates": [[[-117.12554, 33.55661], [-117.12553, 33.5568], [-117.12529, 33.55681], [-117.12524, 33.55678], [-117.12519, 33.55681], [-117.12507, 33.55681], [-117.12505, 33.55686], [-117.125, 33.55686], [-117.125, 33.5569], [-117.12496, 33.55692], [-117.12494, 33.55695], [-117.12496, 33.55699], [-117.125, 33.55701], [-117.125, 33.55709], [-117.12504, 33.55709], [-117.12505, 33.5572], [-117.12522, 33.5572], [-117.12523, 33.55718], [-117.12525, 33.55718], [-117.12527, 33.5572], [-117.12545, 33.5572], [-117.12546, 33.55724], [-117.12553, 33.55724], [-117.12552, 33.55745], [-117.12403, 33.55744], [-117.12404, 33.55702], [-117.12365, 33.55701], [-117.12365, 33.55667], [-117.12363, 33.55663], [-117.12358, 33.55661], [-117.1234, 33.55662], [-117.12335, 33.55664], [-117.12292, 33.55701], [-117.12262, 33.55696], [-117.12249, 33.55684], [-117.12272, 33.55671], [-117.12299, 33.55661], [-117.12313, 33.55657], [-117.12342, 33.55654], [-117.12549, 33.55657], [-117.12554, 33.55661]]]}	Open Access 1	Central Park Community Park Murrieta		33595	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	3.893	Central Park Community Park Murrieta
970	970	969	{"type": "Polygon", "coordinates": [[[-117.14043, 33.54707], [-117.14033, 33.54714], [-117.14015, 33.54747], [-117.14, 33.54759], [-117.1397, 33.54789], [-117.13919, 33.54827], [-117.13902, 33.54831], [-117.13885, 33.54827], [-117.13872, 33.54818], [-117.13868, 33.54811], [-117.13866, 33.54804], [-117.13864, 33.54803], [-117.13819, 33.54827], [-117.13775, 33.54855], [-117.1376, 33.5487], [-117.13734, 33.54913], [-117.13712, 33.54933], [-117.13684, 33.54927], [-117.13672, 33.54927], [-117.13643, 33.54949], [-117.13623, 33.54973], [-117.13611, 33.54969], [-117.1368, 33.54916], [-117.13676, 33.5491], [-117.13698, 33.54886], [-117.13707, 33.54872], [-117.13719, 33.54846], [-117.13729, 33.54833], [-117.13743, 33.54823], [-117.13791, 33.548], [-117.13812, 33.54786], [-117.13818, 33.54775], [-117.13821, 33.54764], [-117.1382, 33.54752], [-117.13815, 33.54746], [-117.13968, 33.54619], [-117.14015, 33.54657], [-117.13849, 33.5478], [-117.13849, 33.54782], [-117.13853, 33.54785], [-117.1402, 33.54661], [-117.14042, 33.54677], [-117.14043, 33.54707]]]}	Open Access 1	Guenther Willows Park		33596	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	8.904	Guenther Willows Park
980	980	979	{"type": "Polygon", "coordinates": [[[-117.12462, 33.54378], [-117.12448, 33.54508], [-117.12437, 33.54615], [-117.12388, 33.54512], [-117.12356, 33.54429], [-117.12362, 33.54435], [-117.12371, 33.54437], [-117.12389, 33.54459], [-117.12437, 33.54458], [-117.12447, 33.54378], [-117.12462, 33.54378]], [[-117.12426, 33.54565], [-117.12424, 33.54563], [-117.1242, 33.54564], [-117.12424, 33.54573], [-117.12426, 33.54572], [-117.12426, 33.54565]]]}	Open Access 1	Overlook Park		33597	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	2.196	Overlook Park
1000	1000	999	{"type": "Polygon", "coordinates": [[[-117.53184, 33.83651], [-117.52781, 33.83658], [-117.52781, 33.83602], [-117.52859, 33.836], [-117.52865, 33.83597], [-117.52865, 33.83594], [-117.52861, 33.83541], [-117.52852, 33.83513], [-117.52837, 33.83487], [-117.52794, 33.83501], [-117.52726, 33.83357], [-117.52752, 33.83343], [-117.52761, 33.83344], [-117.52777, 33.83335], [-117.5278, 33.83328], [-117.52925, 33.83254], [-117.53, 33.83352], [-117.53166, 33.83607], [-117.53184, 33.83651]]]}	Open Access 1	El Cerrito Sports Park	https://www.coronaca.gov/Home/Components/FacilityDirectory/FacilityDirectory/95/580	33598	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	26.336	El Cerrito Sports Park
1001	1001	1000	{"type": "Polygon", "coordinates": [[[-117.28428, 33.76242], [-117.28273, 33.76246], [-117.2827, 33.76182], [-117.28324, 33.7618], [-117.28324, 33.76162], [-117.28425, 33.76159], [-117.28428, 33.76242]]]}	Open Access 1	Goodhope Park		33599	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	3.023	Goodhope Park
1005	1005	1004	{"type": "Polygon", "coordinates": [[[-117.32215, 34.01575], [-117.32169, 34.01627], [-117.32155, 34.01645], [-117.32148, 34.01656], [-117.3214, 34.01675], [-117.32125, 34.01722], [-117.32099, 34.01872], [-117.32092, 34.01895], [-117.32079, 34.01927], [-117.32066, 34.01927], [-117.32063, 34.01926], [-117.3206, 34.01922], [-117.32022, 34.01922], [-117.32021, 34.01866], [-117.32021, 34.01575], [-117.32215, 34.01575]]]}	Open Access 1	Highgrove Community Park	https://rivcoccsd.org/new-page-2	33600	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	9.518	Highgrove Community Park
1006	1006	1005	{"type": "Polygon", "coordinates": [[[-117.51151, 33.77707], [-117.51138, 33.77733], [-117.51089, 33.77824], [-117.51044, 33.77898], [-117.50991, 33.77901], [-117.5099, 33.77885], [-117.50991, 33.77865], [-117.50988, 33.77857], [-117.50981, 33.7785], [-117.50971, 33.77848], [-117.50949, 33.77851], [-117.50935, 33.77852], [-117.50932, 33.77819], [-117.50853, 33.77823], [-117.51151, 33.77707]]]}	Open Access 1	Montecito Ranch Park		33601	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	5.317	Montecito Ranch Park
1007	1007	1006	{"type": "Polygon", "coordinates": [[[-117.47088, 33.75654], [-117.47089, 33.75734], [-117.47087, 33.75752], [-117.47083, 33.75766], [-117.47078, 33.75779], [-117.47069, 33.75793], [-117.47059, 33.75805], [-117.47046, 33.75817], [-117.47029, 33.75828], [-117.47011, 33.75837], [-117.46993, 33.75843], [-117.46972, 33.75847], [-117.46952, 33.75849], [-117.46907, 33.75844], [-117.46903, 33.7584], [-117.469, 33.75799], [-117.46894, 33.75779], [-117.46891, 33.75762], [-117.46891, 33.75742], [-117.46893, 33.75725], [-117.46899, 33.75702], [-117.46946, 33.75622], [-117.47088, 33.75654]]]}	Open Access 1	Coral Canyon Park	https://rivcoccsd.org/new-page-2	33603	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	9.03	Coral Canyon Park
1008	1008	1007	{"type": "Polygon", "coordinates": [[[-117.46707, 33.74589], [-117.46683, 33.74759], [-117.46525, 33.74744], [-117.46517, 33.7471], [-117.46503, 33.74677], [-117.46348, 33.7442], [-117.46334, 33.744], [-117.4632, 33.74382], [-117.4632, 33.74376], [-117.46365, 33.74339], [-117.46373, 33.74335], [-117.46383, 33.74332], [-117.46405, 33.74329], [-117.46541, 33.7433], [-117.46601, 33.74403], [-117.46707, 33.74589]]]}	Open Access 1	Deleo Regional Sports Park	https://rivcoccsd.org/new-page-2	33602	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	24.913	Deleo Reg. Sports Park
1093	1093	1092	{"type": "Polygon", "coordinates": [[[-116.25953, 33.85477], [-116.25847, 33.85477], [-116.25854, 33.85444], [-116.25847, 33.85432], [-116.25869, 33.85385], [-116.25883, 33.85385], [-116.25953, 33.85422], [-116.25953, 33.85477]]]}	Open Access 1	Indio Hills Community Center and Park		32855	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	1.978	Indio Hills Community Ctr. and Park
2113	2113	2112	{"type": "Polygon", "coordinates": [[[-116.95489, 33.98303], [-116.95487, 33.98323], [-116.9546, 33.98346], [-116.95406, 33.98442], [-116.95376, 33.98457], [-116.95354, 33.98473], [-116.95305, 33.98462], [-116.9529, 33.9843], [-116.95287, 33.98399], [-116.95261, 33.98389], [-116.95215, 33.98347], [-116.952, 33.98315], [-116.95168, 33.98291], [-116.95142, 33.9828], [-116.95117, 33.98291], [-116.95089, 33.98273], [-116.95074, 33.98224], [-116.9509, 33.98148], [-116.95086, 33.98132], [-116.95083, 33.98091], [-116.95085, 33.9806], [-116.95075, 33.98032], [-116.95062, 33.97962], [-116.95038, 33.97899], [-116.95009, 33.9787], [-116.95004, 33.97853], [-116.94976, 33.97837], [-116.94969, 33.97798], [-116.94962, 33.97766], [-116.94941, 33.97749], [-116.94973, 33.97706], [-116.95035, 33.97679], [-116.95068, 33.97669], [-116.9508, 33.97634], [-116.95129, 33.97611], [-116.9513, 33.97605], [-116.95342, 33.97612], [-116.95481, 33.97613], [-116.95449, 33.97627], [-116.95418, 33.97658], [-116.95416, 33.97729], [-116.95406, 33.97855], [-116.95382, 33.97883], [-116.95364, 33.97944], [-116.95373, 33.98027], [-116.95402, 33.9808], [-116.95406, 33.98136], [-116.95422, 33.98197], [-116.9546, 33.98262], [-116.95489, 33.98303]]]}	Open Access 1	Bogart County Park		16226	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	70.988	Bogart County Park
3679	3679	3678	{"type": "Polygon", "coordinates": [[[-117.11988, 33.71789], [-117.11539, 33.71794], [-117.11537, 33.72507], [-117.11986, 33.72504], [-117.11979, 33.72862], [-117.1023, 33.72895], [-117.10226, 33.72172], [-117.10216, 33.7145], [-117.10576, 33.71446], [-117.10651, 33.71438], [-117.11099, 33.71433], [-117.11139, 33.71453], [-117.11318, 33.71473], [-117.11586, 33.71436], [-117.11982, 33.71433], [-117.11988, 33.71789]]]}	Open Access 1	Double Butte Park Property		18237	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	560.404	Double Butte Park Property
4565	4565	4564	{"type": "Polygon", "coordinates": [[[-116.90313, 33.94334], [-116.89857, 33.94333], [-116.89827, 33.94266], [-116.89791, 33.94223], [-116.89766, 33.9413], [-116.89702, 33.9398], [-116.89651, 33.93845], [-116.8965, 33.93756], [-116.8943, 33.93447], [-116.8943, 33.93254], [-116.89922, 33.93253], [-116.89923, 33.93542], [-116.89855, 33.93543], [-116.89855, 33.93598], [-116.89923, 33.936], [-116.89924, 33.9367], [-116.90309, 33.93967], [-116.90313, 33.94334]]]}	Open Access 1	Gilman Historic Ranch Park		19295	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	131.565	Gilman Historic Ranch Park
5073	5073	5072	{"type": "Polygon", "coordinates": [[[-116.68439, 33.67798], [-116.68332, 33.67893], [-116.68325, 33.67922], [-116.68303, 33.67923], [-116.68266, 33.68164], [-116.68233, 33.68175], [-116.68215, 33.68145], [-116.68192, 33.68122], [-116.68198, 33.68043], [-116.68174, 33.68004], [-116.68091, 33.67917], [-116.68038, 33.67794], [-116.67964, 33.6772], [-116.6792, 33.6776], [-116.67885, 33.6784], [-116.67838, 33.67849], [-116.67788, 33.67828], [-116.67766, 33.6776], [-116.67571, 33.67759], [-116.6757, 33.67582], [-116.67894, 33.67586], [-116.6796, 33.67582], [-116.67984, 33.67574], [-116.68008, 33.67574], [-116.68006, 33.67523], [-116.68191, 33.67527], [-116.68211, 33.67525], [-116.68334, 33.67622], [-116.68347, 33.67629], [-116.68439, 33.67742], [-116.68439, 33.67798]]]}	Open Access 1	Herkey Creek Park		19866	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	62.303	Herkey Creek Park
5326	5326	5325	{"type": "Polygon", "coordinates": [[[-116.7286, 33.74804], [-116.72433, 33.74805], [-116.72439, 33.75331], [-116.72419, 33.75332], [-116.72401, 33.75332], [-116.7238, 33.75328], [-116.72363, 33.75324], [-116.72265, 33.75277], [-116.72224, 33.75263], [-116.72198, 33.75258], [-116.72159, 33.75253], [-116.72116, 33.75253], [-116.72079, 33.75257], [-116.72033, 33.75266], [-116.72006, 33.75267], [-116.72007, 33.75162], [-116.72, 33.74448], [-116.72147, 33.74447], [-116.72155, 33.74437], [-116.7217, 33.74441], [-116.72174, 33.74435], [-116.72185, 33.74399], [-116.72191, 33.74397], [-116.72254, 33.74304], [-116.72217, 33.74269], [-116.72285, 33.74216], [-116.72316, 33.742], [-116.72341, 33.74181], [-116.7237, 33.74169], [-116.72465, 33.74204], [-116.7254, 33.74138], [-116.72574, 33.74058], [-116.72635, 33.74011], [-116.72689, 33.74058], [-116.72747, 33.74026], [-116.72757, 33.74037], [-116.72842, 33.73989], [-116.72855, 33.73978], [-116.72856, 33.74444], [-116.7286, 33.74804]], [[-116.72096, 33.75235], [-116.72112, 33.75235], [-116.72111, 33.75222], [-116.72095, 33.75223], [-116.72096, 33.75235]]]}	Open Access 1	Idyllwild Park		20173	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	183.652	Idyllwild Park
5516	5516	5515	{"type": "Polygon", "coordinates": [[[-117.42105, 33.99374], [-117.42104, 33.99393], [-117.42094, 33.99387], [-117.42032, 33.99432], [-117.41971, 33.9945], [-117.41891, 33.99527], [-117.41837, 33.99521], [-117.41467, 33.99321], [-117.41633, 33.99213], [-117.4184, 33.99191], [-117.42105, 33.99374]]]}	Open Access 1	Jensen-Alvarado Ranch Historical Park		20393	315	Riverside, County of 165	County 3	County Agency 3	http://www.rivcoparks.org/	County 3	30.063	Jensen-Alvarado Ranch Historical Park

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