superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
39 rows where MNG_AGENCY = 165 and MNG_AG_LEV = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
14390 | 14390 | 14389 | {"type": "Polygon", "coordinates": [[[-116.07451, 33.56924], [-116.07349, 33.56924], [-116.07349, 33.56872], [-116.07451, 33.56872], [-116.07451, 33.56924]]]} | Open Access 1 | Unknown Park - Riverside, County of | 33493 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 1.338 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
11031 | 11031 | 11030 | {"type": "Polygon", "coordinates": [[[-117.38678, 33.93378], [-117.38579, 33.93434], [-117.38492, 33.93328], [-117.38591, 33.93272], [-117.38678, 33.93378]]]} | Open Access 1 | Washington Park | 27271 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 3.903 | Washington 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 | ||
10321 | 10321 | 10320 | {"type": "Polygon", "coordinates": [[[-114.62963, 33.43504], [-114.62963, 33.43504], [-114.62692, 33.43503], [-114.6273, 33.43394], [-114.62962, 33.4339], [-114.62963, 33.43504]]]} | Open Access 1 | Thirty Eighth Street County Park | 26304 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 7.152 | Thirty Eighth Street County Park | ||
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 | ||
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 | |
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 | |
8141 | 8141 | 8140 | {"type": "Polygon", "coordinates": [[[-116.73697, 33.76722], [-116.73616, 33.76785], [-116.73441, 33.76766], [-116.73406, 33.7661], [-116.73443, 33.76596], [-116.73465, 33.76583], [-116.73672, 33.76566], [-116.73697, 33.76722]]]} | Open Access 1 | Pine Cove County Park | 23674 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 12.828 | Pine Cove County Park | ||
14177 | 14177 | 14176 | {"type": "Polygon", "coordinates": [[[-116.39879, 33.82366], [-116.39697, 33.82366], [-116.39696, 33.82193], [-116.39701, 33.82189], [-116.39701, 33.82178], [-116.39697, 33.82173], [-116.39696, 33.8216], [-116.39701, 33.82156], [-116.39701, 33.82145], [-116.39697, 33.82139], [-116.39697, 33.82105], [-116.39702, 33.821], [-116.39702, 33.8209], [-116.39697, 33.82084], [-116.39697, 33.8205], [-116.39702, 33.82045], [-116.39701, 33.82033], [-116.39697, 33.82028], [-116.39698, 33.82013], [-116.39701, 33.8201], [-116.39879, 33.8201], [-116.39879, 33.82366]]]} | Restricted Access 2 | Thousand Palms Community Park | 31650 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 16.4 | Thousand Palms Community 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 | |
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 | |
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 | ||
4416 | 4416 | 4415 | {"type": "Polygon", "coordinates": [[[-117.09349, 33.56898], [-117.0926, 33.57066], [-117.08388, 33.57076], [-117.08394, 33.56909], [-117.09349, 33.56898]]]} | Unknown Access 4 | French Valley Conservation Area, Expansion 1 | 19108 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 38.847 | French Valley Conservation Area, Expansion 1 | ||
15509 | 15509 | 15508 | {"type": "MultiPolygon", "coordinates": [[[[-116.22904, 33.56937], [-116.22417, 33.57225], [-116.22417, 33.57225], [-116.22448, 33.56938], [-116.22904, 33.56937]]], [[[-116.47104, 33.54345], [-116.47103, 33.54704], [-116.46673, 33.54703], [-116.46673, 33.54344], [-116.47104, 33.54345]]]]} | Open Access 1 | Santa Rosa and San Jacinto Mountains National Monument | 25129 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 55.977 | Santa Rosa and San Jacinto Mtns. NM | 2000 |
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]);