units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
60 rows where AGNCY_LEV = 2 and MNG_AGENCY = 185 sorted by GAP_STS
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16511 | 16511 | 16510 | {"type": "MultiPolygon", "coordinates": [[[[-117.42036, 33.89827], [-117.41851, 33.89932], [-117.4162, 33.8965], [-117.41663, 33.89624], [-117.41665, 33.89616], [-117.41647, 33.89589], [-117.41644, 33.89575], [-117.41647, 33.89559], [-117.41663, 33.89533], [-117.41535, 33.89528], [-117.4153, 33.89523], [-117.41665, 33.89524], [-117.41632, 33.89488], [-117.41609, 33.89488], [-117.41566, 33.89478], [-117.41492, 33.89449], [-117.41484, 33.89459], [-117.41385, 33.89471], [-117.41322, 33.89429], [-117.41256, 33.89429], [-117.41204, 33.89435], [-117.412, 33.89406], [-117.41183, 33.89388], [-117.41166, 33.89379], [-117.41111, 33.89291], [-117.41054, 33.89225], [-117.4102, 33.89208], [-117.41, 33.89204], [-117.40959, 33.89169], [-117.4093, 33.89168], [-117.40904, 33.89161], [-117.40943, 33.89155], [-117.40951, 33.8914], [-117.40941, 33.89114], [-117.4096, 33.89087], [-117.40925, 33.89053], [-117.40871, 33.89016], [-117.40837, 33.88975], [-117.40834, 33.8893], [-117.40809, 33.88889], [-117.40735, 33.88827], [-117.40711, 33.88799], [-117.40725, 33.88721], [-117.40755, 33.88702], [-117.4097, 33.88701], [-117.40989, 33.88734], [-117.40977, 33.88754], [-117.4093, 33.88773], [-117.40926, 33.88786], [-117.40949, 33.88808], [-117.40985, 33.88821], [-117.40998, 33.88863], [-117.41021, 33.88855], [-117.41045, 33.88821], [-117.41049, 33.88849], [-117.4106, 33.88852], [-117.41085, 33.88845], [-117.41084, 33.88867], [-117.41128, 33.88888], [-117.41121, 33.88913], [-117.41144, 33.88925], [-117.41134, 33.88943], [-117.41159, 33.88938], [-117.4116, 33.88955], [-117.41174, 33.88952], [-117.41175, 33.88963], [-117.41186, 33.88968], [-117.41184, 33.88987], [-117.41195, 33.88993], [-117.41194, 33.89031], [-117.41236, 33.89029], [-117.41254, 33.89021], [-117.41272, 33.89], [-117.41285, 33.88995], [-117.41287, 33.89013], [-117.413, 33.89022], [-117.41309, 33.89036], [-117.41332, 33.89056], [-117.4133, 33.8907], [-117.41341, 33.89088], [-117.41333, 33.891], [-117.41336, 33.89147], [-117.4133, 33.89158], [-117.4134, 33.89163], [-117.41354, 33.89164], [-117.4135, 33.89185], [-117.41376, 33.89199], [-117.41404, 33.89198], [-117.4144, 33.89203], [-117.41451, 33.89196], [-117.41431, 33.89159], [-117.41442, 33.89158], [-117.41441, 33.89148], [-117.41446, 33.89129], [-117.41441, 33.89119], [-117.41443, 33.89103], [-117.41431, 33.89089], [-117.41431, 33.89082], [-117.41447, 33.89082], [-117.41453, 33.8907], [-117.41438, 33.89054], [-117.41427, 33.89011], [-117.41449, 33.89053], [-117.41464, 33.89057], [-117.41472, 33.89067], [-117.41473, 33.89083], [-117.41482, 33.89098], [-117.41493, 33.89086], [-117.415, 33.89084], [-117.4151, 33.89065], [-117.41511, 33.8908], [-117.41518, 33.89084], [-117.41508, 33.89094], [-117.41511, 33.89106], [-117.41541, 33.89094], [-117.41584, 33.89039], [-117.41797, 33.89199], [-117.418, 33.89201], [-117.41759, 33.89239], [-117.41755, 33.89263], [-117.41808, 33.8932], [-117.41845, 33.89311], [-117.41869, 33.89345], [-117.41907, 33.89345], [-117.4193, 33.89373], [-117.41976, 33.89373], [-117.42014, 33.8941], [-117.42015, 33.89415], [-117.42003, 33.89418], [-117.41986, 33.89428], [-117.41995, 33.89439], [-117.42012, 33.89439], [-117.42021, 33.89448], [-117.42029, 33.89534], [-117.42006, 33.89559], [-117.41899, 33.89581], [-117.4186, 33.89529], [-117.41837, 33.89535], [-117.41812, 33.89552], [-117.42036, 33.89827]]], [[[-117.42232, 33.90418], [-117.41881, 33.90616], [-117.41756, 33.90463], [-117.42107, 33.90265], [-117.42232, 33.90418]]], [[[-117.42967, 33.90001], [-117.42254, 33.90406], [-117.42128, 33.90253], [-117.42311, 33.90146], [-117.42331, 33.90095], [-117.42404, 33.89999], [-117.42415, 33.8999], [-117.42428, 33.89985], [-117.42441, 33.89984], [-117.42454, 33.89986], [-117.42466, 33.89992], [-117.42483, 33.89998], [-117.42567, 33.90001], [-117.4284, 33.89846], [-117.42967, 33.90001]]]]} | Open Access 1 | 30006 | California Citrus State Historic Park | 16687 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 193.189 | California Citrus SHP | 1984 | None 1410 | ||
14468 | 14468 | 14467 | {"type": "MultiPolygon", "coordinates": [[[[-117.29626, 33.92407], [-117.29615, 33.92376], [-117.296, 33.92348], [-117.29579, 33.92318], [-117.29557, 33.92294], [-117.29533, 33.92272], [-117.2951, 33.92255], [-117.29343, 33.92152], [-117.29311, 33.92127], [-117.29286, 33.92103], [-117.29264, 33.92076], [-117.29247, 33.92047], [-117.29234, 33.92017], [-117.29282, 33.92017], [-117.29336, 33.92028], [-117.29562, 33.92026], [-117.29625, 33.92143], [-117.29626, 33.92407]]], [[[-117.30959, 33.92395], [-117.30437, 33.92747], [-117.30115, 33.92705], [-117.30114, 33.92402], [-117.30959, 33.92395]]], [[[-117.33562, 33.9346], [-117.33559, 33.9351], [-117.33551, 33.93552], [-117.33539, 33.93593], [-117.33518, 33.93638], [-117.33498, 33.93673], [-117.33474, 33.93705], [-117.3337, 33.93822], [-117.33121, 33.93822], [-117.33119, 33.94092], [-117.33065, 33.94196], [-117.33015, 33.94236], [-117.33016, 33.94288], [-117.32975, 33.94328], [-117.32976, 33.94413], [-117.32953, 33.94449], [-117.32994, 33.94506], [-117.32971, 33.94594], [-117.33007, 33.94647], [-117.33007, 33.94662], [-117.32252, 33.9466], [-117.32248, 33.95022], [-117.32246, 33.95383], [-117.31984, 33.95381], [-117.31985, 33.95479], [-117.31914, 33.95501], [-117.31879, 33.95514], [-117.31848, 33.95528], [-117.31788, 33.95558], [-117.31607, 33.95659], [-117.31599, 33.95657], [-117.31589, 33.95643], [-117.31581, 33.95628], [-117.31577, 33.95613], [-117.31575, 33.95596], [-117.31639, 33.956], [-117.31665, 33.95545], [-117.31698, 33.95521], [-117.31697, 33.95499], [-117.31702, 33.95409], [-117.3164, 33.95331], [-117.3159, 33.95295], [-117.3155, 33.95276], [-117.31453, 33.95269], [-117.31439, 33.95313], [-117.31415, 33.9531], [-117.3138, 33.95309], [-117.31379, 33.95308], [-117.31335, 33.95305], [-117.31309, 33.95299], [-117.31281, 33.95289], [-117.31262, 33.95277], [-117.31246, 33.95266], [-117.31232, 33.95253], [-117.3122, 33.95238], [-117.31205, 33.95211], [-117.3119, 33.95163], [-117.31181, 33.95145], [-117.31167, 33.95123], [-117.31149, 33.95103], [-117.31122, 33.95082], [-117.31051, 33.95041], [-117.31021, 33.95026], [-117.30986, 33.95012], [-117.31142, 33.95011], [-117.31151, 33.94987], [-117.31166, 33.94926], [-117.31159, 33.94868], [-117.31147, 33.94823], [-117.31127, 33.94783], [-117.31085, 33.94738], [-117.31096, 33.94681], [-117.31095, 33.94594], [-117.31109, 33.94572], [-117.31116, 33.94534], [-117.31123, 33.94418], [-117.31165, 33.94369], [-117.3132, 33.94256], [-117.31351, 33.94194], [-117.31279, 33.93981], [-117.30957, 33.93997], [-117.30958, 33.93677], [-117.30965, 33.93675], [-117.30972, 33.93672], [-117.30976, 33.93666], [-117.30977, 33.9366], [-117.30976, 33.93654], [-117.30972, 33.93649], [-117.30965, 33.93645], [-117.30958, 33.93644], [-117.30958, 33.93079], [-117.30897, 33.93001], [-117.30686, 33.92858], [-117.30672, 33.92804], [-117.30627, 33.92775], [-117.30537, 33.92764], [-117.30512, 33.92764], [-117.30511, 33.92756], [-117.30473, 33.92752], [-117.31001, 33.92395], [-117.31387, 33.92391], [-117.31395, 33.92761], [-117.31828, 33.92758], [-117.31828, 33.9271], [-117.31921, 33.92679], [-117.31945, 33.92714], [-117.31876, 33.92788], [-117.3176, 33.92842], [-117.31763, 33.92921], [-117.31949, 33.93068], [-117.32109, 33.93119], [-117.32288, 33.93116], [-117.32337, 33.9319], [-117.32445, 33.93227], [-117.32515, 33.93244], [-117.32669, 33.93222], [-117.32664, 33.92973], [-117.33128, 33.92966], [-117.33128, 33.93101], [-117.33347, 33.93101], [-117.33346, 33.9328], [-117.33455, 33.9328], [-117.33454, 33.9346], [-117.33562, 33.9346]]]]} | Open Access 1 | 47099 | Sycamore Canyon Wilderness Park | 30758 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 1281.186 | Sycamore Canyon Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
499 | 499 | 498 | {"type": "Polygon", "coordinates": [[[-117.44281, 33.92927], [-117.44007, 33.93082], [-117.44, 33.9307], [-117.4399, 33.93042], [-117.43981, 33.93026], [-117.43907, 33.92934], [-117.4391, 33.9293], [-117.44164, 33.92787], [-117.4417, 33.9279], [-117.44281, 33.92927]]]} | Open Access 1 | 2014 | Hunt Park | 20152 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 13.779 | Hunt Park | 0 | Local Park 2 | 4 | |
593 | 593 | 592 | {"type": "Polygon", "coordinates": [[[-117.34381, 34.00102], [-117.34008, 34.00101], [-117.34004, 34.00099], [-117.34002, 34.00096], [-117.34002, 33.9977], [-117.34004, 33.99767], [-117.34008, 33.99765], [-117.34377, 33.99765], [-117.34381, 34.00102]]]} | Open Access 1 | 2017 | Hunter Park | 20153 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 32.155 | Hunter Park | 0 | Local Park 2 | 4 | |
746 | 746 | 745 | {"type": "MultiPolygon", "coordinates": [[[[-117.40095, 33.94777], [-117.40071, 33.94777], [-117.40025, 33.94777], [-117.40041, 33.94751], [-117.40046, 33.94749], [-117.40093, 33.94769], [-117.40095, 33.94772], [-117.40095, 33.94777]]], [[[-117.40082, 33.94629], [-117.40073, 33.94643], [-117.40029, 33.94713], [-117.40029, 33.94672], [-117.40046, 33.94671], [-117.40046, 33.9463], [-117.40082, 33.94629]]], [[[-117.40096, 33.94666], [-117.40096, 33.94755], [-117.40095, 33.94758], [-117.40091, 33.9476], [-117.40053, 33.94743], [-117.4005, 33.94737], [-117.40096, 33.94666]]]]} | Open Access 1 | 4842 | Low Park | 21552 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 1.258 | Low Park | 0 | Local Park 2 | 4 | |
776 | 776 | 775 | {"type": "Polygon", "coordinates": [[[-117.3806, 33.97735], [-117.38008, 33.97814], [-117.37913, 33.97771], [-117.37967, 33.97692], [-117.3806, 33.97735]]]} | Open Access 1 | 5730 | Newman Park | 22730 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 2.463 | Newman Park | 0 | Local Park 2 | 4 | |
865 | 865 | 864 | {"type": "Polygon", "coordinates": [[[-117.47581, 33.92126], [-117.47472, 33.92215], [-117.47441, 33.92183], [-117.47425, 33.92197], [-117.47407, 33.92174], [-117.47366, 33.9219], [-117.47364, 33.92189], [-117.47326, 33.92208], [-117.47304, 33.92173], [-117.47259, 33.92118], [-117.4737, 33.9206], [-117.47389, 33.92082], [-117.4746, 33.92045], [-117.47477, 33.92071], [-117.47461, 33.9208], [-117.47474, 33.92101], [-117.47538, 33.92068], [-117.47579, 33.92118], [-117.47581, 33.92126]]]} | Open Access 1 | 5587 | Myra Linn Park | 22619 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 7.868 | Myra Linn Park | 0 | Local Park 2 | 4 | |
875 | 875 | 874 | {"type": "Polygon", "coordinates": [[[-117.36909, 33.97328], [-117.36858, 33.97404], [-117.36855, 33.97406], [-117.36852, 33.97405], [-117.36731, 33.97349], [-117.36786, 33.9727], [-117.36909, 33.97328]]]} | Open Access 1 | 5696 | Lincoln Park | 21269 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 3.27 | Lincoln Park | 0 | Local Park 2 | 4 | |
1295 | 1295 | 1294 | {"type": "Polygon", "coordinates": [[[-117.42388, 33.91938], [-117.41909, 33.92211], [-117.41862, 33.92237], [-117.41949, 33.92047], [-117.41964, 33.92019], [-117.41975, 33.92002], [-117.42093, 33.91887], [-117.42114, 33.91856], [-117.42201, 33.91709], [-117.42388, 33.91938]]]} | Open Access 1 | 5722 | Don Derr Park | 18202 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 23.992 | Don Derr Park | 0 | Local Park 2 | 4 | |
1910 | 1910 | 1909 | {"type": "Polygon", "coordinates": [[[-117.34809, 33.93534], [-117.34809, 33.93619], [-117.3482, 33.93658], [-117.34818, 33.93665], [-117.34811, 33.93669], [-117.3475, 33.93651], [-117.34756, 33.93624], [-117.34586, 33.9359], [-117.34435, 33.93551], [-117.34434, 33.93552], [-117.34434, 33.9358], [-117.34253, 33.93534], [-117.34234, 33.9353], [-117.34208, 33.93528], [-117.34018, 33.93528], [-117.34011, 33.93522], [-117.34011, 33.93487], [-117.34017, 33.93481], [-117.34046, 33.93475], [-117.34074, 33.93466], [-117.34112, 33.93447], [-117.34134, 33.93431], [-117.34216, 33.9336], [-117.34244, 33.93341], [-117.34274, 33.93325], [-117.34317, 33.9331], [-117.34351, 33.93301], [-117.34386, 33.93297], [-117.34435, 33.93296], [-117.34435, 33.93385], [-117.34516, 33.93385], [-117.34628, 33.93481], [-117.34664, 33.93477], [-117.34705, 33.93527], [-117.34732, 33.93509], [-117.34747, 33.93521], [-117.34765, 33.93529], [-117.3478, 33.93532], [-117.34808, 33.93533], [-117.34809, 33.93534]]]} | Open Access 1 | 14787 | Castleview Park | 16959 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 31.36 | Castleview Park | 0 | Local Park 2 | 4 | |
1958 | 1958 | 1957 | {"type": "Polygon", "coordinates": [[[-117.39925, 33.93249], [-117.39747, 33.93351], [-117.39804, 33.93423], [-117.39629, 33.93522], [-117.39508, 33.93368], [-117.39869, 33.93164], [-117.39896, 33.93198], [-117.39888, 33.93204], [-117.39925, 33.93249]]]} | Open Access 1 | 15069 | Villegas Park | 27122 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 15.207 | Villegas Park | 0 | Local Park 2 | 4 | |
2667 | 2667 | 2666 | {"type": "Polygon", "coordinates": [[[-117.44922, 33.92097], [-117.44787, 33.92173], [-117.4472, 33.9209], [-117.44883, 33.91998], [-117.44921, 33.92046], [-117.44896, 33.92062], [-117.44922, 33.92097]]]} | Open Access 1 | 18187 | Arlington Park | 15590 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 4.645 | Arlington Park | 0 | Local Park 2 | 4 | |
2924 | 2924 | 2923 | {"type": "Polygon", "coordinates": [[[-117.48066, 33.91287], [-117.48064, 33.91295], [-117.47958, 33.9135], [-117.47841, 33.91207], [-117.47877, 33.91192], [-117.47881, 33.91196], [-117.47887, 33.91198], [-117.47899, 33.91197], [-117.47904, 33.91192], [-117.47912, 33.9118], [-117.4792, 33.91173], [-117.47953, 33.91154], [-117.47959, 33.91155], [-117.48066, 33.91287]]]} | Open Access 1 | 19855 | Collett Park | 17517 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 5.616 | Collett Park | 0 | Local Park 2 | 4 | |
2925 | 2925 | 2924 | {"type": "Polygon", "coordinates": [[[-117.48705, 33.90341], [-117.48654, 33.90444], [-117.48509, 33.90395], [-117.4845, 33.90321], [-117.48512, 33.90285], [-117.48535, 33.90279], [-117.48561, 33.90279], [-117.48585, 33.90284], [-117.48646, 33.90305], [-117.48659, 33.90312], [-117.4867, 33.90314], [-117.48678, 33.90312], [-117.48685, 33.90336], [-117.48705, 33.90341]]]} | Open Access 1 | 19856 | Rancho Loma Park | 24151 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 6.497 | Rancho Loma Park | 0 | Local Park 2 | 4 | |
2926 | 2926 | 2925 | {"type": "Polygon", "coordinates": [[[-117.44729, 33.93129], [-117.44564, 33.93223], [-117.44557, 33.93222], [-117.44446, 33.93087], [-117.44445, 33.93083], [-117.44448, 33.9308], [-117.44622, 33.92979], [-117.44646, 33.93007], [-117.44651, 33.93028], [-117.44658, 33.93041], [-117.44729, 33.93129]]]} | Open Access 1 | 19857 | Don Lorenzi Sports Park | 18207 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 9.204 | Don Lorenzi Sports Park | 0 | Local Recreation Area 3 | 4 | |
2927 | 2927 | 2926 | {"type": "Polygon", "coordinates": [[[-117.46881, 33.95793], [-117.46871, 33.958], [-117.4678, 33.95805], [-117.46654, 33.95818], [-117.46577, 33.95822], [-117.46697, 33.95722], [-117.46655, 33.95686], [-117.46679, 33.95666], [-117.46684, 33.95669], [-117.46692, 33.9567], [-117.46698, 33.95669], [-117.46703, 33.95665], [-117.46707, 33.9566], [-117.46707, 33.95655], [-117.46706, 33.9565], [-117.46702, 33.95646], [-117.4674, 33.95614], [-117.46833, 33.95678], [-117.46856, 33.95701], [-117.4687, 33.95723], [-117.46879, 33.95745], [-117.46882, 33.95768], [-117.46881, 33.95793]]]} | Open Access 1 | 19865 | Rutland Park | 24755 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 8.56 | Rutland Park | 0 | Local Park 2 | 4 | |
3187 | 3187 | 3186 | {"type": "Polygon", "coordinates": [[[-117.33391, 33.92759], [-117.33249, 33.92759], [-117.33197, 33.92887], [-117.33197, 33.92892], [-117.33128, 33.92893], [-117.33128, 33.92681], [-117.33178, 33.92669], [-117.33181, 33.92649], [-117.33189, 33.92648], [-117.33212, 33.92637], [-117.33304, 33.92615], [-117.3331, 33.92617], [-117.33322, 33.92642], [-117.33373, 33.92712], [-117.33391, 33.92759]]]} | Open Access 1 | 22127 | Taft Park | 26166 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 10.103 | Taft Park | 0 | Local Park 2 | 4 | |
3188 | 3188 | 3187 | {"type": "Polygon", "coordinates": [[[-117.33536, 33.9812], [-117.33535, 33.98219], [-117.33523, 33.98258], [-117.33522, 33.98284], [-117.33513, 33.9829], [-117.33282, 33.98289], [-117.33281, 33.98294], [-117.33261, 33.98294], [-117.33261, 33.98289], [-117.33248, 33.98289], [-117.33246, 33.98294], [-117.33221, 33.98294], [-117.3322, 33.98289], [-117.33128, 33.98289], [-117.33124, 33.98286], [-117.33125, 33.98119], [-117.33284, 33.9812], [-117.33536, 33.9812]]]} | Open Access 1 | 22126 | Riverside Sports Center | 24460 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 17.499 | Riverside Sports Ctr. | 0 | Local Recreation Area 3 | 4 | |
3777 | 3777 | 3776 | {"type": "Polygon", "coordinates": [[[-117.35709, 33.96642], [-117.35708, 33.96793], [-117.35707, 33.96798], [-117.35703, 33.96801], [-117.35503, 33.96801], [-117.35501, 33.96725], [-117.35294, 33.96728], [-117.35296, 33.9646], [-117.35502, 33.96459], [-117.35502, 33.96601], [-117.35509, 33.96605], [-117.35538, 33.96619], [-117.35571, 33.96627], [-117.3565, 33.96639], [-117.35681, 33.96642], [-117.35709, 33.96642]]]} | Open Access 1 | 8570 | Bordwell Park | 16282 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 22.989 | Bordwell Park | 0 | Local Park 2 | 4 | |
3799 | 3799 | 3798 | {"type": "Polygon", "coordinates": [[[-117.33029, 33.96071], [-117.33022, 33.96079], [-117.32984, 33.96073], [-117.32966, 33.96063], [-117.32972, 33.96057], [-117.32972, 33.96049], [-117.33009, 33.96027], [-117.33022, 33.96031], [-117.33029, 33.96071]]]} | Open Access 1 | 48819 | Kensington Pocket Park | 33538 | 1279 | Riverside, City of 189 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | https://www.riversideca.gov/park_rec/sites/riversideca.gov.park_rec/files/pdf/Riverside%20Parks_0.pdf | Riverside 10 | 0.541 | Kensington PP | 0 | Local Park 2 | 4 |
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]);