units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
61 rows where MNG_AGENCY = 185 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13161 | 13161 | 13160 | {"type": "Polygon", "coordinates": [[[-117.46674, 33.9428], [-117.46599, 33.9428], [-117.46595, 33.94279], [-117.46591, 33.94273], [-117.46591, 33.94235], [-117.46674, 33.94235], [-117.46674, 33.9428]]]} | Open Access 1 | 48820 | Arlanza Community Garden | 33539 | 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/mayor/fitfreshfunriverside/community.asp | Riverside 10 | 0.937 | Arlanza Community Garden | 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 |
17040 | 17040 | 17039 | {"type": "MultiPolygon", "coordinates": [[[[-117.45663, 33.95565], [-117.45632, 33.95587], [-117.45598, 33.95604], [-117.45559, 33.95619], [-117.45518, 33.95628], [-117.4551, 33.95629], [-117.45398, 33.95629], [-117.45397, 33.95621], [-117.45293, 33.95622], [-117.4533, 33.95591], [-117.45356, 33.9556], [-117.45389, 33.95566], [-117.45399, 33.95566], [-117.45399, 33.95458], [-117.45538, 33.95457], [-117.45593, 33.95505], [-117.45662, 33.95554], [-117.45663, 33.95565]]], [[[-117.46118, 33.95825], [-117.45644, 33.9549], [-117.45602, 33.95457], [-117.45558, 33.95416], [-117.45532, 33.95387], [-117.45508, 33.95357], [-117.45486, 33.95325], [-117.45468, 33.95293], [-117.45472, 33.95285], [-117.45507, 33.95274], [-117.45536, 33.95269], [-117.45743, 33.95268], [-117.45803, 33.95369], [-117.45885, 33.95382], [-117.46023, 33.95608], [-117.46069, 33.95728], [-117.46071, 33.95727], [-117.46062, 33.95703], [-117.46072, 33.95701], [-117.46118, 33.95825]]]]} | Restricted Access 2 | 30001 | Van Buren Golf Center | 33095 | 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 | 41.11 | Van Buren Golf Ctr. | 0 | Local Recreation Area 3 | 4 | |
15714 | 15714 | 15713 | {"type": "Polygon", "coordinates": [[[-117.38221, 34.00104], [-117.38076, 34.00281], [-117.37982, 34.00246], [-117.37662, 34.00097], [-117.37602, 34.00067], [-117.37477, 33.99998], [-117.37651, 33.99723], [-117.37697, 33.99738], [-117.37768, 33.99739], [-117.37769, 33.99741], [-117.38159, 33.99982], [-117.38173, 34.0003], [-117.38151, 34.00061], [-117.38221, 34.00104]]]} | Restricted Access 2 | 30000 | Fairmount Park Golf Course | 33094 | 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 | 55.983 | Fairmount Park GC | 0 | Local Recreation Area 3 | 4 | |
14376 | 14376 | 14375 | {"type": "Polygon", "coordinates": [[[-117.31104, 33.94759], [-117.31041, 33.94799], [-117.31031, 33.94797], [-117.31021, 33.94798], [-117.30999, 33.94807], [-117.30936, 33.94828], [-117.30896, 33.94845], [-117.30892, 33.94848], [-117.30889, 33.94848], [-117.30844, 33.94815], [-117.30832, 33.94803], [-117.30823, 33.9479], [-117.30817, 33.94775], [-117.30803, 33.94724], [-117.30801, 33.94708], [-117.30803, 33.94691], [-117.3081, 33.94671], [-117.30823, 33.94653], [-117.30838, 33.9464], [-117.30869, 33.94619], [-117.30877, 33.94619], [-117.30894, 33.94638], [-117.30909, 33.94659], [-117.30916, 33.94663], [-117.30925, 33.94665], [-117.30934, 33.94664], [-117.30943, 33.9466], [-117.30959, 33.9464], [-117.30973, 33.94626], [-117.30999, 33.94643], [-117.31095, 33.94654], [-117.31096, 33.94681], [-117.31085, 33.94738], [-117.31104, 33.94759]]]} | Open Access 1 | 47104 | Sycamore Highlands Park | 30764 | 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 | 12.04 | Sycamore Highlands Park | 0 | Local Park 2 | 4 | |
14471 | 14471 | 14470 | {"type": "Polygon", "coordinates": [[[-117.32246, 33.95383], [-117.32245, 33.95457], [-117.32188, 33.95454], [-117.32112, 33.95458], [-117.32047, 33.95466], [-117.31985, 33.95479], [-117.31984, 33.95381], [-117.32246, 33.95383]]]} | Open Access 1 | 47101 | Ameal Moore Nature Center | 30760 | 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.254 | Ameal Moore Nature Ctr. | 0 | Local Park 2 | 4 | |
4076 | 4076 | 4075 | {"type": "Polygon", "coordinates": [[[-117.31001, 33.92395], [-117.30137, 33.92978], [-117.30137, 33.92978], [-117.30137, 33.9295], [-117.30959, 33.92395], [-117.31001, 33.92395]]]} | Open Access 1 | 47102 | Sycamore Canyon Wilderness Park | 30758 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | Riverside 10 | 6.045 | Sycamore Canyon Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
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 | |
9177 | 9177 | 9176 | {"type": "Polygon", "coordinates": [[[-117.37885, 33.9822], [-117.37866, 33.98249], [-117.3787, 33.98252], [-117.3787, 33.98262], [-117.37876, 33.9827], [-117.37854, 33.98304], [-117.37756, 33.98259], [-117.37757, 33.98255], [-117.37628, 33.98195], [-117.37676, 33.98123], [-117.37885, 33.9822]]]} | Open Access 1 | 15332 | White Park | 27461 | 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.332 | White 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 | |
10700 | 10700 | 10699 | {"type": "Polygon", "coordinates": [[[-117.46036, 33.8924], [-117.45897, 33.89319], [-117.45756, 33.89148], [-117.4579, 33.89149], [-117.45792, 33.89136], [-117.45928, 33.89142], [-117.45965, 33.89158], [-117.46036, 33.8924]]]} | Open Access 1 | 19861 | Victoria Cross Park | 27074 | 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.06 | Victoria Cross Park | 0 | Local Park 2 | 4 | |
11999 | 11999 | 11998 | {"type": "Polygon", "coordinates": [[[-117.30452, 33.8917], [-117.30421, 33.89182], [-117.30382, 33.892], [-117.30351, 33.89219], [-117.3032, 33.89242], [-117.30295, 33.89224], [-117.3027, 33.89211], [-117.30137, 33.89163], [-117.30149, 33.89145], [-117.30267, 33.89018], [-117.30283, 33.89006], [-117.30302, 33.88997], [-117.30322, 33.88993], [-117.30444, 33.88993], [-117.30444, 33.89143], [-117.30447, 33.89159], [-117.30452, 33.8917]]]} | Open Access 1 | 24657 | Thundersky Park | 26339 | 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 | 12.807 | Thundersky Park | 0 | Local Park 2 | 4 | |
4866 | 4866 | 4865 | {"type": "Polygon", "coordinates": [[[-117.39881, 33.97562], [-117.3967, 33.97612], [-117.39677, 33.976], [-117.39676, 33.97599], [-117.39632, 33.97609], [-117.39633, 33.97611], [-117.39646, 33.97618], [-117.39507, 33.9765], [-117.39506, 33.97649], [-117.39344, 33.97687], [-117.3909, 33.97747], [-117.39089, 33.9775], [-117.39057, 33.97757], [-117.3904, 33.9775], [-117.39115, 33.97631], [-117.39145, 33.97595], [-117.39173, 33.97568], [-117.39207, 33.97541], [-117.39381, 33.97423], [-117.39453, 33.9738], [-117.39476, 33.97361], [-117.39493, 33.9734], [-117.39587, 33.97382], [-117.39642, 33.97382], [-117.39704, 33.97375], [-117.39773, 33.97419], [-117.39809, 33.97398], [-117.39792, 33.97424], [-117.39811, 33.97432], [-117.39829, 33.97438], [-117.39865, 33.97443], [-117.39881, 33.97562]]]} | Open Access 1 | 14708 | Tequesquito Arroyo Park | 26248 | 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 | 42.809 | Tequesquito Arroyo 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 | |
11998 | 11998 | 11997 | {"type": "Polygon", "coordinates": [[[-117.35595, 33.94831], [-117.35569, 33.94856], [-117.35559, 33.94867], [-117.35535, 33.9482], [-117.35525, 33.94793], [-117.3552, 33.94765], [-117.35516, 33.94725], [-117.35516, 33.94704], [-117.3554, 33.94761], [-117.35551, 33.94783], [-117.35569, 33.94807], [-117.35595, 33.94831]]]} | Open Access 1 | 24656 | Swanson Park | 26096 | 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.029 | Swanson Park | 0 | Local Park 2 | 4 | |
8188 | 8188 | 8187 | {"type": "Polygon", "coordinates": [[[-117.39493, 33.94612], [-117.39314, 33.94614], [-117.39311, 33.94353], [-117.39324, 33.9435], [-117.39336, 33.94351], [-117.39402, 33.94372], [-117.39491, 33.9439], [-117.39493, 33.94612]]]} | Open Access 1 | 12431 | Shamel Park | 25355 | 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 | 11.051 | Shamel Park | 0 | Local Park 2 | 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 | |
12761 | 12761 | 12760 | {"type": "MultiPolygon", "coordinates": [[[[-117.49463, 33.90092], [-117.49453, 33.901], [-117.49383, 33.90091], [-117.49395, 33.9007], [-117.49401, 33.90052], [-117.49414, 33.90042], [-117.49421, 33.90034], [-117.49424, 33.90023], [-117.49421, 33.90011], [-117.49404, 33.89988], [-117.49393, 33.89967], [-117.49386, 33.89952], [-117.49387, 33.89939], [-117.49385, 33.89936], [-117.49373, 33.89929], [-117.49363, 33.89919], [-117.49355, 33.89914], [-117.49328, 33.89906], [-117.49316, 33.89906], [-117.49304, 33.89901], [-117.49297, 33.89895], [-117.49283, 33.89878], [-117.49358, 33.89836], [-117.49418, 33.89909], [-117.49433, 33.89935], [-117.49447, 33.89966], [-117.49456, 33.89993], [-117.49462, 33.90026], [-117.49465, 33.90054], [-117.49463, 33.90092]]], [[[-117.49574, 33.90107], [-117.49564, 33.90112], [-117.49505, 33.90105], [-117.49499, 33.90098], [-117.49501, 33.90053], [-117.49494, 33.89995], [-117.49488, 33.89974], [-117.49474, 33.89939], [-117.49484, 33.89936], [-117.49538, 33.90002], [-117.49532, 33.90011], [-117.49532, 33.90021], [-117.49567, 33.90064], [-117.49573, 33.90074], [-117.49576, 33.90088], [-117.49574, 33.90107]]]]} | Open Access 1 | 30005 | Riverwalk Dog Park | 24468 | 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.013 | Riverwalk Dog 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 | |
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 |
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]);