units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
49 rows where DES_TP = 2 and MNG_AGENCY = 185 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 49
MNG_AGENCY 1
- Riverside, City of · 49 ✖
DES_TP 1
- Local Park · 49 ✖
ACCESS_TYP 1
- Open Access 49
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10708 | 10708 | 10707 | {"type": "MultiPolygon", "coordinates": [[[[-117.37087, 33.994], [-117.37078, 33.99435], [-117.37031, 33.99412], [-117.36972, 33.99353], [-117.36958, 33.99334], [-117.36949, 33.99316], [-117.36942, 33.99296], [-117.36938, 33.99277], [-117.36938, 33.99257], [-117.3694, 33.99237], [-117.36946, 33.99218], [-117.36955, 33.99197], [-117.36982, 33.99158], [-117.37012, 33.99184], [-117.36983, 33.99208], [-117.36977, 33.99312], [-117.36986, 33.9934], [-117.37009, 33.99365], [-117.37087, 33.994]]], [[[-117.37086, 33.99581], [-117.37063, 33.99558], [-117.37069, 33.99542], [-117.37072, 33.99526], [-117.37073, 33.99505], [-117.37071, 33.99487], [-117.37066, 33.99469], [-117.3706, 33.99454], [-117.37052, 33.99438], [-117.37041, 33.99424], [-117.37078, 33.99442], [-117.37117, 33.99516], [-117.37118, 33.99526], [-117.37115, 33.99537], [-117.37086, 33.99581]]], [[[-117.39089, 33.99042], [-117.39043, 33.99084], [-117.38686, 33.99507], [-117.3868, 33.99555], [-117.38653, 33.99587], [-117.38657, 33.9959], [-117.38427, 33.99864], [-117.38249, 33.99753], [-117.38234, 33.99761], [-117.38223, 33.99748], [-117.38215, 33.99752], [-117.38192, 33.99732], [-117.3817, 33.99744], [-117.38134, 33.99699], [-117.38069, 33.99734], [-117.38051, 33.99749], [-117.38034, 33.99766], [-117.37982, 33.99846], [-117.37976, 33.99852], [-117.37777, 33.99728], [-117.37773, 33.99731], [-117.37699, 33.9973], [-117.37656, 33.99716], [-117.37477, 33.99998], [-117.37442, 33.99975], [-117.37329, 33.99888], [-117.37358, 33.99866], [-117.37363, 33.99866], [-117.37368, 33.99873], [-117.37379, 33.99867], [-117.37356, 33.99832], [-117.37344, 33.99837], [-117.37299, 33.99865], [-117.37265, 33.99841], [-117.37237, 33.99824], [-117.37197, 33.99803], [-117.37138, 33.99775], [-117.37116, 33.9976], [-117.37098, 33.99745], [-117.37082, 33.99726], [-117.37074, 33.99714], [-117.37064, 33.99692], [-117.37056, 33.99658], [-117.37179, 33.99475], [-117.37179, 33.99474], [-117.37172, 33.9947], [-117.37218, 33.99403], [-117.37276, 33.99431], [-117.37305, 33.99439], [-117.37325, 33.99441], [-117.37344, 33.99439], [-117.37359, 33.99437], [-117.37379, 33.99429], [-117.37395, 33.99422], [-117.37409, 33.9941], [-117.37421, 33.99398], [-117.37506, 33.99271], [-117.37512, 33.99268], [-117.37519, 33.99268], [-117.37549, 33.99282], [-117.37529, 33.99313], [-117.37651, 33.99369], [-117.37669, 33.99393], [-117.3769, 33.99408], [-117.37684, 33.9942], [-117.37732, 33.99442], [-117.37717, 33.99452], [-117.37707, 33.99455], [-117.37701, 33.99458], [-117.37698, 33.99466], [-117.37699, 33.9947], [-117.37703, 33.99474], [-117.37712, 33.99477], [-117.37721, 33.99475], [-117.37724, 33.99472], [-117.37731, 33.99461], [-117.3775, 33.99448], [-117.37753, 33.99443], [-117.37783, 33.99466], [-117.37789, 33.9946], [-117.37801, 33.99467], [-117.37783, 33.99488], [-117.37766, 33.99533], [-117.37764, 33.99544], [-117.3778, 33.99547], [-117.3779, 33.99516], [-117.37801, 33.99493], [-117.37812, 33.99479], [-117.37869, 33.99428], [-117.37876, 33.99418], [-117.3789, 33.99383], [-117.37904, 33.99362], [-117.37944, 33.9938], [-117.37962, 33.99385], [-117.38049, 33.99381], [-117.3807, 33.99384], [-117.38084, 33.99389], [-117.38092, 33.99378], [-117.3809, 33.99376], [-117.38078, 33.99371], [-117.38057, 33.99367], [-117.38026, 33.99367], [-117.3797, 33.99372], [-117.3796, 33.99371], [-117.37951, 33.99368], [-117.37912, 33.9935], [-117.37937, 33.99312], [-117.38044, 33.99363], [-117.38108, 33.9936], [-117.38137, 33.99371], [-117.38161, 33.99374], [-117.38197, 33.9937], [-117.38215, 33.99358], [-117.38205, 33.9935], [-117.38324, 33.99227], [-117.38375, 33.99209], [-117.38449, 33.99162], [-117.3851, 33.9919], [-117.38617, 33.9913], [-117.38799, 33.98968], [-117.38909, 33.99004], [-117.38943, 33.9901], [-117.39011, 33.99028], [-117.39089, 33.99042]], [[-117.37157, 33.99781], [-117.37158, 33.99783], [-117.37171, 33.99777], [-117.37168, 33.99774], [-117.37157, 33.99781]]]]} | Open Access 1 | 19864 | Fairmount Park | 9451 | 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 | http://www.riversideca.gov/park_rec/facilities.asp | Riverside 10 | 213.051 | Fairmount 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 | |
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 | |
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 | |
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 | |
6488 | 6488 | 6487 | {"type": "Polygon", "coordinates": [[[-117.31356, 33.97583], [-117.31348, 33.97661], [-117.31272, 33.97644], [-117.3127, 33.97634], [-117.31246, 33.97633], [-117.31216, 33.97636], [-117.31184, 33.97644], [-117.31152, 33.97658], [-117.31126, 33.97676], [-117.31103, 33.977], [-117.31091, 33.97717], [-117.31082, 33.97736], [-117.31077, 33.97756], [-117.31074, 33.97776], [-117.31076, 33.97802], [-117.31097, 33.97915], [-117.3094, 33.97913], [-117.30939, 33.9792], [-117.3091, 33.9792], [-117.30899, 33.97901], [-117.30891, 33.97877], [-117.30888, 33.9786], [-117.30888, 33.97827], [-117.30939, 33.97827], [-117.30941, 33.97575], [-117.31351, 33.97578], [-117.31355, 33.9758], [-117.31356, 33.97583]]]} | Open Access 1 | 2341 | Islander Park | 20282 | 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 | 18.783 | Islander Park | 0 | Local Park 2 | 4 | |
11997 | 11997 | 11996 | {"type": "Polygon", "coordinates": [[[-117.31539, 33.89509], [-117.31542, 33.89745], [-117.31538, 33.89765], [-117.31531, 33.89784], [-117.3152, 33.89802], [-117.31503, 33.89823], [-117.31326, 33.89717], [-117.31293, 33.897], [-117.31258, 33.89686], [-117.31221, 33.89675], [-117.31182, 33.89668], [-117.31156, 33.89666], [-117.31167, 33.89567], [-117.31189, 33.89491], [-117.3126, 33.89505], [-117.3131, 33.8951], [-117.31539, 33.89509]]]} | Open Access 1 | 24655 | Orange Terrace Community Park | 23178 | 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 | 21.801 | Orange Terrace Community Park | 0 | Local Park 2 | 4 | |
6875 | 6875 | 6874 | {"type": "Polygon", "coordinates": [[[-117.31797, 33.98415], [-117.31795, 33.98417], [-117.31792, 33.98419], [-117.31714, 33.98418], [-117.31701, 33.98413], [-117.31694, 33.98412], [-117.31684, 33.98416], [-117.3168, 33.9842], [-117.31679, 33.98425], [-117.31671, 33.98425], [-117.31672, 33.98509], [-117.31652, 33.98524], [-117.31637, 33.98543], [-117.31479, 33.98544], [-117.31479, 33.9857], [-117.31407, 33.9857], [-117.31407, 33.98558], [-117.314, 33.98553], [-117.31371, 33.98548], [-117.31371, 33.98543], [-117.31378, 33.98523], [-117.31378, 33.98484], [-117.31434, 33.98483], [-117.31434, 33.98456], [-117.31552, 33.98458], [-117.31557, 33.98408], [-117.31661, 33.98349], [-117.31665, 33.98307], [-117.31671, 33.98307], [-117.31672, 33.98312], [-117.31796, 33.98312], [-117.31797, 33.98415]]]} | Open Access 1 | 5533 | Mount Vernon Park | 22535 | 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.317 | Mount Vernon 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 | |
11996 | 11996 | 11995 | {"type": "Polygon", "coordinates": [[[-117.3249, 33.88653], [-117.32405, 33.88669], [-117.32397, 33.8864], [-117.32373, 33.88644], [-117.3233, 33.88487], [-117.32336, 33.88494], [-117.32345, 33.88497], [-117.32371, 33.88491], [-117.32477, 33.8849], [-117.3248, 33.88491], [-117.32467, 33.88518], [-117.32464, 33.88533], [-117.32463, 33.88553], [-117.32465, 33.88565], [-117.3249, 33.88653]]]} | Open Access 1 | 24654 | Bergmont Park | 16021 | 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.031 | Bergmont Park | 0 | Local Park 2 | 4 | |
11343 | 11343 | 11342 | {"type": "Polygon", "coordinates": [[[-117.33014, 33.98755], [-117.32986, 33.98789], [-117.32965, 33.98784], [-117.32856, 33.98784], [-117.32834, 33.98781], [-117.32807, 33.9877], [-117.3277, 33.98746], [-117.32743, 33.98734], [-117.32717, 33.98729], [-117.32643, 33.98724], [-117.3264, 33.98721], [-117.32641, 33.9867], [-117.32646, 33.98666], [-117.32677, 33.98666], [-117.32678, 33.98701], [-117.3289, 33.98699], [-117.32899, 33.98724], [-117.32964, 33.98699], [-117.33014, 33.98755]]]} | Open Access 1 | 22123 | Highland Park | 19934 | 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.558 | Highland 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 |
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 | |
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 | |
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 | |
12123 | 12123 | 12122 | {"type": "Polygon", "coordinates": [[[-117.35103, 33.96113], [-117.35035, 33.96114], [-117.34983, 33.96116], [-117.34983, 33.96112], [-117.34864, 33.96037], [-117.34863, 33.96099], [-117.34849, 33.961], [-117.34849, 33.96038], [-117.34803, 33.95977], [-117.34669, 33.95629], [-117.34676, 33.95612], [-117.34851, 33.95588], [-117.34851, 33.9561], [-117.34852, 33.95611], [-117.34884, 33.95582], [-117.35026, 33.9561], [-117.3503, 33.95661], [-117.35047, 33.95689], [-117.3503, 33.957], [-117.35022, 33.95758], [-117.35018, 33.95805], [-117.35018, 33.95823], [-117.35026, 33.95849], [-117.35055, 33.9584], [-117.3507, 33.95873], [-117.35049, 33.95894], [-117.35028, 33.95967], [-117.35028, 33.95989], [-117.3503, 33.95993], [-117.35034, 33.95995], [-117.35057, 33.95994], [-117.35086, 33.95982], [-117.35102, 33.96057], [-117.35096, 33.96062], [-117.35103, 33.96113]]]} | Open Access 1 | 25074 | Andulka Park | 15488 | 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 | 36.517 | Andulka Park | 0 | Local Park 2 | 4 | |
5119 | 5119 | 5118 | {"type": "Polygon", "coordinates": [[[-117.35274, 33.97925], [-117.35065, 33.97926], [-117.35064, 33.97845], [-117.35274, 33.97843], [-117.35274, 33.97925]]]} | Open Access 1 | 8097 | Patterson Park | 23521 | 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.352 | Patterson 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 | |
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 | |
10701 | 10701 | 10700 | {"type": "Polygon", "coordinates": [[[-117.36263, 33.97145], [-117.36167, 33.97146], [-117.36167, 33.97143], [-117.36207, 33.97142], [-117.36206, 33.97072], [-117.36167, 33.97071], [-117.36167, 33.97062], [-117.36175, 33.97047], [-117.36181, 33.97046], [-117.36219, 33.97059], [-117.36224, 33.97066], [-117.36251, 33.97097], [-117.36262, 33.97106], [-117.36263, 33.97145]]]} | Open Access 1 | 19862 | Dario Vasquez Park | 17926 | 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.193 | Dario Vasquez 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]);