units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where AGNCY_TYP = 3, MNG_AG_ID = 315 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, YR_EST, GAP_STS
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 431 | 431 | 430 | {"type": "Polygon", "coordinates": [[[-117.28428, 33.76243], [-117.28273, 33.76246], [-117.2827, 33.76182], [-117.28324, 33.76181], [-117.28324, 33.76162], [-117.28425, 33.76159], [-117.28428, 33.76243]]]} | Open Access 1 | 48878 | Goodhope Park | 33599 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 3.022 | Goodhope Park | 0 | Local Park 2 | 4 | |
| 567 | 567 | 566 | {"type": "Polygon", "coordinates": [[[-116.28545, 33.64926], [-116.27605, 33.6493], [-116.27598, 33.64886], [-116.27585, 33.64695], [-116.27557, 33.64484], [-116.27553, 33.64464], [-116.2754, 33.64431], [-116.27531, 33.64417], [-116.27517, 33.64399], [-116.2749, 33.64373], [-116.27445, 33.64342], [-116.27439, 33.64335], [-116.27436, 33.64326], [-116.27435, 33.64317], [-116.27438, 33.64308], [-116.27467, 33.64262], [-116.27478, 33.64236], [-116.27486, 33.64209], [-116.27489, 33.64208], [-116.27489, 33.64181], [-116.27485, 33.64155], [-116.27478, 33.64134], [-116.27444, 33.6407], [-116.27435, 33.64045], [-116.2741, 33.63907], [-116.27415, 33.63896], [-116.27423, 33.6389], [-116.27463, 33.63883], [-116.27495, 33.63873], [-116.27516, 33.63865], [-116.2755, 33.63848], [-116.2757, 33.63841], [-116.27604, 33.63834], [-116.27679, 33.6383], [-116.27679, 33.63793], [-116.27606, 33.63794], [-116.27575, 33.63799], [-116.27547, 33.63807], [-116.27523, 33.63815], [-116.27487, 33.63832], [-116.27471, 33.63838], [-116.27451, 33.63844], [-116.27408, 33.63852], [-116.27397, 33.63856], [-116.27385, 33.63862], [-116.27376, 33.6387], [-116.27369, 33.6388], [-116.27365, 33.63888], [-116.27322, 33.63867], [-116.273, 33.63852], [-116.27277, 33.63831], [-116.27259, 33.63807], [-116.27246, 33.63778], [-116.27241, 33.63747], [-116.27242, 33.63233], [-116.27236, 33.63209], [-116.27227, 33.63189], [-116.27213, 33.6317], [-116.27194, 33.63152], [-116.27176, 33.6314], [-116.27151, 33.63128], [-116.27134, 33.63123], [-116.27114, 33.6312], [-116.26991, 33.63119], [-116.26969, 33.63117], [-116.26945, 33.63112], [-116.2691, 33.63099], [-116.26892, 33.63089], [-116.26877, 33.63079], [-116.26854, 33.63057], [-116.26836, 33.63031], [-116.26811, 33.63031], [-116.26811, 33.62777], [-116.26796, 33.62763], [-116.26793, 33.62282], [-116.26835, 33.62284], [-116.26846, 33.62308], [-116.26867, 33.62343], [-116.26903, 33.62371], [-116.26946, 33.62391], [-116.27001, 33.62436], [-116.27227, 33.62528], [-116.27348, 33.62589], [-116.27578, 33.62758], [-116.28097, 33.62756], [-116.28101, 33.63121], [-116.28107, 33.64207], [-116.28542, 33.64205], [-116.28545, 33.64926]]]} | Open Access 1 | 3338 | Lake Cahuilla Recreation Area | 9500 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/parks/lake-cahuilla/lake-cahuilla-recreation-area-home/ | Riverside 10 | 566.48 | Lake Cahuilla Rec. Area | 0 | Local Recreation Area 3 | 4 |
| 1099 | 1099 | 1098 | {"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.98398], [-116.95261, 33.98389], [-116.95215, 33.98347], [-116.952, 33.98315], [-116.95168, 33.98291], [-116.95142, 33.98279], [-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.97963], [-116.95038, 33.97899], [-116.95009, 33.9787], [-116.95005, 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.95069, 33.97669], [-116.9508, 33.97634], [-116.9513, 33.9761], [-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 | 6503 | Bogart County Park | 16226 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 70.98 | Bogart County Park | 0 | Local Park 2 | 4 | |
| 1584 | 1584 | 1583 | {"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 | 12140 | French Valley Conservation Area, Expansion 1 | 19108 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 38.849 | French Valley Conservation Area, Expansion 1 | None 128 | |||
| 3697 | 3697 | 3696 | {"type": "Polygon", "coordinates": [[[-117.43583, 33.96849], [-117.43536, 33.96974], [-117.43501, 33.97033], [-117.43446, 33.97086], [-117.43443, 33.97085], [-117.43427, 33.971], [-117.43171, 33.97095], [-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.42647, 33.97737], [-117.42771, 33.97462], [-117.42799, 33.97381], [-117.42717, 33.97361], [-117.42691, 33.97415], [-117.42674, 33.9741], [-117.42662, 33.97435], [-117.42677, 33.97442], [-117.42548, 33.97708], [-117.42489, 33.97821], [-117.42302, 33.97768], [-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.41663, 33.9693], [-117.41524, 33.96978], [-117.41515, 33.97005], [-117.41285, 33.97113], [-117.41121, 33.96974], [-117.41244, 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.41622, 33.96583], [-117.41621, 33.96581], [-117.4157, 33.96541], [-117.41653, 33.96498], [-117.41658, 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 | 30004 | Martha McLean Anza Narrows Park | 9503 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://santaanarivertrail.org/home.html | Riverside 10 | 615.445 | Martha McLean Anza Narrows Park | 0 | Local Park 2 | 4 |
| 4081 | 4081 | 4080 | {"type": "Polygon", "coordinates": [[[-117.12462, 33.54378], [-117.12448, 33.54508], [-117.12437, 33.54616], [-117.12388, 33.54512], [-117.12356, 33.54429], [-117.12362, 33.54435], [-117.12371, 33.54437], [-117.12389, 33.54459], [-117.12438, 33.54458], [-117.12447, 33.54378], [-117.12462, 33.54378]], [[-117.12427, 33.54564], [-117.12424, 33.54563], [-117.1242, 33.54564], [-117.12424, 33.54573], [-117.12426, 33.54572], [-117.12427, 33.54564]]]} | Open Access 1 | 48876 | Overlook Park | 33597 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 2.188 | Overlook Park | 0 | Local Park 2 | 4 | |
| 4206 | 4206 | 4205 | {"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 | 48872 | Perret Park | 33593 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 2.063 | Perret Park | 0 | Local Park 2 | 4 | |
| 4815 | 4815 | 4814 | {"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 | 48766 | Unknown Park - Riverside, County of | 33493 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 1.339 | 0 | Local Other or Unknown 14 | 4 | ||
| 4875 | 4875 | 4874 | {"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 | 14733 | Thirty Eighth Street County Park | 26304 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 7.153 | Thirty Eighth Street County Park | 0 | Local Park 2 | 4 | |
| 5175 | 5175 | 5174 | {"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 | 4462 | Santa Rosa and San Jacinto Mountains National Monument | 25129 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 55.98 | Santa Rosa and San Jacinto Mtns. NM | 2000 | National Monument or Landmark 80 | 3 | |
| 5279 | 5279 | 5278 | {"type": "Polygon", "coordinates": [[[-117.25814, 33.7139], [-117.25811, 33.71948], [-117.25803, 33.72838], [-117.24077, 33.72856], [-117.24065, 33.72142], [-117.24062, 33.71414], [-117.25808, 33.71387], [-117.25809, 33.7139], [-117.25814, 33.7139]]]} | Open Access 1 | 2650 | Kabian Park Property | 20539 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 640.487 | Kabian Park Property | 0 | Local Other or Unknown 14 | 4 | |
| 5589 | 5589 | 5588 | {"type": "MultiPolygon", "coordinates": [[[[-117.31639, 33.6953], [-117.31635, 33.69561], [-117.31633, 33.69569], [-117.3163, 33.69571], [-117.31632, 33.6955], [-117.31631, 33.69534], [-117.31594, 33.69537], [-117.31592, 33.69538], [-117.31574, 33.69537], [-117.31571, 33.69539], [-117.31553, 33.69534], [-117.3153, 33.6952], [-117.31512, 33.69522], [-117.31503, 33.69526], [-117.31476, 33.69552], [-117.31443, 33.69569], [-117.31383, 33.6958], [-117.31368, 33.69593], [-117.31364, 33.69608], [-117.31361, 33.69625], [-117.31355, 33.6964], [-117.31344, 33.69654], [-117.31328, 33.69667], [-117.31326, 33.69671], [-117.31313, 33.69667], [-117.31303, 33.69689], [-117.31324, 33.69696], [-117.31297, 33.69761], [-117.31285, 33.69777], [-117.31286, 33.69781], [-117.31274, 33.69796], [-117.31275, 33.69801], [-117.31267, 33.6982], [-117.31269, 33.69825], [-117.31261, 33.69844], [-117.31263, 33.69849], [-117.31232, 33.6985], [-117.31228, 33.69878], [-117.31228, 33.69934], [-117.31217, 33.69939], [-117.3121, 33.69984], [-117.31209, 33.70031], [-117.31159, 33.70037], [-117.31143, 33.70065], [-117.31153, 33.70092], [-117.31154, 33.7013], [-117.31183, 33.70143], [-117.31253, 33.70148], [-117.31263, 33.70165], [-117.31269, 33.70186], [-117.31269, 33.70201], [-117.31283, 33.70211], [-117.31016, 33.70212], [-117.31015, 33.70437], [-117.30948, 33.70421], [-117.30905, 33.70422], [-117.30873, 33.70414], [-117.30802, 33.70393], [-117.30754, 33.70366], [-117.30723, 33.70357], [-117.30706, 33.70356], [-117.30739, 33.70329], [-117.3083, 33.70348], [-117.30818, 33.70272], [-117.30938, 33.70245], [-117.31079, 33.7014], [-117.31122, 33.70029], [-117.31185, 33.70011], [-117.31177, 33.69849], [-117.31161, 33.6985], [-117.31168, 33.70001], [-117.31109, 33.70018], [-117.31064, 33.70131], [-117.3093, 33.70232], [-117.30799, 33.70262], [-117.3081, 33.70329], [-117.30734, 33.70313], [-117.3056, 33.70454], [-117.30572, 33.70516], [-117.30514, 33.70516], [-117.30516, 33.70542], [-117.30442, 33.70566], [-117.30445, 33.70582], [-117.3015, 33.70585], [-117.30154, 33.70315], [-117.30153, 33.70223], [-117.30591, 33.70216], [-117.30588, 33.69857], [-117.31018, 33.69849], [-117.31016, 33.69487], [-117.31638, 33.69484], [-117.31639, 33.6953]]], [[[-117.31014, 33.69113], [-117.30429, 33.69122], [-117.30424, 33.68906], [-117.30415, 33.68905], [-117.30405, 33.6841], [-117.3101, 33.68401], [-117.31014, 33.69113]]], [[[-117.30638, 33.70411], [-117.30631, 33.70476], [-117.30632, 33.7049], [-117.30628, 33.70497], [-117.30595, 33.70515], [-117.30589, 33.70515], [-117.30578, 33.70459], [-117.30638, 33.70411]]], [[[-117.32739, 33.71393], [-117.32716, 33.72027], [-117.31861, 33.7203], [-117.31839, 33.72757], [-117.31126, 33.7276], [-117.31118, 33.72583], [-117.31162, 33.72582], [-117.31163, 33.72581], [-117.31115, 33.725], [-117.31105, 33.72502], [-117.31013, 33.72438], [-117.30997, 33.72377], [-117.31012, 33.71407], [-117.3188, 33.71403], [-117.32739, 33.71393]]], [[[-117.36159, 33.71668], [-117.35971, 33.71664], [-117.35975, 33.7135], [-117.36052, 33.71444], [-117.36112, 33.71589], [-117.36129, 33.71621], [-117.36152, 33.71654], [-117.36159, 33.71668]]], [[[-117.45455, 33.74791], [-117.45432, 33.74847], [-117.45404, 33.74872], [-117.45382, 33.74846], [-117.45382, 33.74819], [-117.45451, 33.74787], [-117.45455, 33.74791]]], [[[-117.46108, 33.7505], [-117.46077, 33.75067], [-117.46048, 33.7509], [-117.45889, 33.75254], [-117.45869, 33.75269], [-117.45844, 33.75282], [-117.45841, 33.75283], [-117.4583, 33.75281], [-117.45827, 33.75277], [-117.45859, 33.75261], [-117.45884, 33.75242], [-117.45898, 33.75241], [-117.45962, 33.75175], [-117.45961, 33.75163], [-117.46014, 33.75107], [-117.46029, 33.75106], [-117.46051, 33.75083], [-117.46072, 33.75067], [-117.46107, 33.75048], [-117.46108, 33.7505]]]]} | Unknown Access 4 | 14103 | Alberhill Conservation Area | 15333 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 685.557 | Alberhill Conservation Area | 0 | Local Conservation Area 4 | 2 | |
| 6006 | 6006 | 6005 | {"type": "Polygon", "coordinates": [[[-117.12554, 33.55661], [-117.12553, 33.5568], [-117.12529, 33.55681], [-117.12524, 33.55678], [-117.12519, 33.55681], [-117.12506, 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.12526, 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 | 48874 | Central Park Community Park Murrieta | 33595 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 3.887 | Central Park Community Park Murrieta | None 485 | |||
| 6259 | 6259 | 6258 | {"type": "Polygon", "coordinates": [[[-117.14043, 33.54708], [-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.54803], [-117.13865, 33.54803], [-117.13819, 33.54827], [-117.13775, 33.54854], [-117.1376, 33.54869], [-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.13681, 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.13848, 33.54781], [-117.13848, 33.54782], [-117.13852, 33.54785], [-117.1402, 33.54661], [-117.14042, 33.54677], [-117.14043, 33.54708]]]} | Open Access 1 | 48875 | Guenther Willows Park | 33596 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 8.902 | Guenther Willows Park | 0 | Local Park 2 | 4 | |
| 6265 | 6265 | 6264 | {"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.5276, 33.83344], [-117.52778, 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 | 48877 | El Cerrito Sports Park | 33598 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | https://www.coronaca.gov/Home/Components/FacilityDirectory/FacilityDirectory/95/580 | Riverside 10 | 26.334 | El Cerrito Sports Park | 0 | Local Recreation Area 3 | 4 |
| 6266 | 6266 | 6265 | {"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.32061, 34.01922], [-117.32022, 34.01922], [-117.32021, 34.01866], [-117.32021, 34.01575], [-117.32215, 34.01575]]]} | Open Access 1 | 48879 | Highgrove Community Park | 33600 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | https://rivcoccsd.org/new-page-2 | Riverside 10 | 9.518 | Highgrove Community Park | 0 | Local Park 2 | 4 |
| 6276 | 6276 | 6275 | {"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 | 48880 | Montecito Ranch Park | 33601 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 5.314 | Montecito Ranch Park | 0 | Local Park 2 | 4 | |
| 6278 | 6278 | 6277 | {"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 | 48881 | Deleo Regional Sports Park | 33602 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | https://rivcoccsd.org/new-page-2 | Riverside 10 | 24.913 | Deleo Reg. Sports Park | 0 | Local Recreation Area 3 | 4 |
| 6290 | 6290 | 6289 | {"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 | 48882 | Coral Canyon Park | 33603 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | https://rivcoccsd.org/new-page-2 | Riverside 10 | 9.031 | Coral Canyon Park | 0 | Local Park 2 | 4 |
| 6298 | 6298 | 6297 | {"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.35386, 33.80178], [-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 | 1420 | Harford Springs Reserve | 9495 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/?s=Harford+Springs+Reserve | Riverside 10 | 523.302 | Harford Springs Reserve | 0 | 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]);