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 LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5531 | 5531 | 5530 | {"type": "Polygon", "coordinates": [[[-117.38523, 33.97454], [-117.38443, 33.97573], [-117.38338, 33.97525], [-117.38268, 33.97514], [-117.38229, 33.97515], [-117.38184, 33.97479], [-117.38356, 33.97319], [-117.38429, 33.97345], [-117.38463, 33.97353], [-117.38449, 33.97375], [-117.38478, 33.9739], [-117.38488, 33.97413], [-117.38505, 33.97434], [-117.38519, 33.97442], [-117.38523, 33.97454]]]} | Open Access 1 | 400 | Evans Park | 18753 | 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.086 | Evans Park | 0 | Local Park 2 | 4 | |
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 |
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 | |
10696 | 10696 | 10695 | {"type": "Polygon", "coordinates": [[[-117.50348, 33.92772], [-117.50251, 33.92989], [-117.50242, 33.92988], [-117.50156, 33.93086], [-117.50142, 33.93067], [-117.50125, 33.93054], [-117.50115, 33.93049], [-117.50104, 33.93046], [-117.50092, 33.93045], [-117.50058, 33.93051], [-117.50057, 33.93047], [-117.50053, 33.93047], [-117.49988, 33.92856], [-117.50072, 33.92825], [-117.50109, 33.92828], [-117.50152, 33.92826], [-117.50215, 33.92813], [-117.50294, 33.9279], [-117.50347, 33.92771], [-117.50348, 33.92772]]]} | Open Access 1 | 19854 | Golden Park | 19369 | 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.176 | Golden Park | 0 | Local Park 2 | 4 | |
10699 | 10699 | 10698 | {"type": "Polygon", "coordinates": [[[-117.44341, 33.90341], [-117.44327, 33.90362], [-117.44303, 33.90377], [-117.44231, 33.90407], [-117.44202, 33.9043], [-117.4418, 33.9046], [-117.44161, 33.90455], [-117.44127, 33.90455], [-117.44128, 33.90379], [-117.44133, 33.90359], [-117.44144, 33.9034], [-117.44156, 33.90326], [-117.44168, 33.90316], [-117.44266, 33.90261], [-117.44271, 33.9026], [-117.44277, 33.90262], [-117.44341, 33.90341]]]} | Open Access 1 | 19860 | Harrison Park | 19702 | 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.028 | Harrison 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 | |
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 | |
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 | |
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 |
5750 | 5750 | 5749 | {"type": "Polygon", "coordinates": [[[-117.49315, 33.92732], [-117.49312, 33.92736], [-117.49232, 33.92767], [-117.49234, 33.92772], [-117.49048, 33.92843], [-117.49032, 33.92843], [-117.49019, 33.92838], [-117.48967, 33.92668], [-117.48843, 33.92474], [-117.48846, 33.92466], [-117.48897, 33.92435], [-117.48929, 33.92422], [-117.49079, 33.92578], [-117.49082, 33.9258], [-117.49095, 33.92584], [-117.49108, 33.92584], [-117.49186, 33.92554], [-117.49203, 33.92586], [-117.49239, 33.92573], [-117.49293, 33.92679], [-117.49289, 33.92681], [-117.49315, 33.92732]]]} | Open Access 1 | 3215 | La Sierra Park | 20808 | 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.045 | La Sierra 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 | |
11339 | 11339 | 11338 | {"type": "Polygon", "coordinates": [[[-117.38677, 33.98911], [-117.3867, 33.98967], [-117.38581, 33.98929], [-117.38579, 33.98931], [-117.38569, 33.98922], [-117.38557, 33.98916], [-117.38574, 33.98909], [-117.38574, 33.98907], [-117.38557, 33.98899], [-117.3852, 33.98842], [-117.38543, 33.98852], [-117.38548, 33.98853], [-117.38555, 33.98849], [-117.3856, 33.98851], [-117.38566, 33.98844], [-117.38571, 33.98842], [-117.3858, 33.98848], [-117.38614, 33.9886], [-117.38634, 33.98871], [-117.38649, 33.98882], [-117.38677, 33.98911]]]} | Open Access 1 | 22122 | Loring Park | 21469 | 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.464 | Loring 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 | |
6873 | 6873 | 6872 | {"type": "Polygon", "coordinates": [[[-117.39744, 33.98247], [-117.39709, 33.98354], [-117.39609, 33.98502], [-117.3952, 33.98599], [-117.39408, 33.98696], [-117.3933, 33.98826], [-117.39244, 33.98893], [-117.39223, 33.9892], [-117.39218, 33.98924], [-117.39205, 33.98929], [-117.39182, 33.98929], [-117.39155, 33.98933], [-117.39091, 33.98952], [-117.38988, 33.98974], [-117.38962, 33.98976], [-117.3893, 33.98973], [-117.38766, 33.98919], [-117.38735, 33.989], [-117.38667, 33.98836], [-117.38626, 33.98815], [-117.38659, 33.98816], [-117.38668, 33.98819], [-117.38677, 33.98826], [-117.38713, 33.98798], [-117.38713, 33.98797], [-117.38673, 33.98764], [-117.38677, 33.98763], [-117.38669, 33.98696], [-117.38722, 33.98694], [-117.3872, 33.98667], [-117.38756, 33.98666], [-117.38782, 33.98635], [-117.38835, 33.98591], [-117.38873, 33.98478], [-117.38871, 33.98462], [-117.38943, 33.98417], [-117.39008, 33.98389], [-117.39036, 33.98386], [-117.39043, 33.98362], [-117.39076, 33.98331], [-117.39088, 33.98317], [-117.39101, 33.98296], [-117.3911, 33.9828], [-117.39116, 33.98262], [-117.39123, 33.98228], [-117.39142, 33.98213], [-117.3917, 33.9818], [-117.39214, 33.98142], [-117.39224, 33.98129], [-117.39221, 33.98118], [-117.39211, 33.98102], [-117.39204, 33.98074], [-117.39178, 33.9806], [-117.39172, 33.98048], [-117.39173, 33.98035], [-117.39164, 33.9803], [-117.39178, 33.98], [-117.39202, 33.97965], [-117.39226, 33.97939], [-117.39259, 33.97912], [-117.39309, 33.97935], [-117.39344, 33.97913], [-117.39343, 33.97912], [-117.39297, 33.97889], [-117.39302, 33.97886], [-117.39293, 33.97872], [-117.3952, 33.97823], [-117.39514, 33.97836], [-117.39551, 33.97836], [-117.39563, 33.97842], [-117.39601, 33.97902], [-117.39609, 33.98016], [-117.39688, 33.98022], [-117.39735, 33.98022], [-117.39737, 33.97982], [-117.39734, 33.97973], [-117.39726, 33.97967], [-117.39734, 33.97958], [-117.39739, 33.97962], [-117.39747, 33.97971], [-117.39751, 33.97987], [-117.39737, 33.98224], [-117.39744, 33.98247]]]} | Open Access 1 | 5527 | Mount Rubidoux Park | 22530 | 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 | 166.427 | Mount Rubidoux 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 | |
16913 | 16913 | 16912 | {"type": "Polygon", "coordinates": [[[-117.40859, 33.95923], [-117.40748, 33.95924], [-117.40747, 33.95732], [-117.40856, 33.95731], [-117.40858, 33.95876], [-117.4085, 33.95874], [-117.40842, 33.95875], [-117.40835, 33.9588], [-117.40833, 33.95886], [-117.40836, 33.95893], [-117.40842, 33.95898], [-117.4085, 33.95898], [-117.40858, 33.95896], [-117.40859, 33.95923]]]} | Open Access 1 | 19866 | Mountain View Park | 22558 | 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.233 | Mtn. View 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 | |
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 | |
12122 | 12122 | 12121 | {"type": "Polygon", "coordinates": [[[-117.37978, 33.97615], [-117.37952, 33.97656], [-117.37949, 33.97657], [-117.37945, 33.97657], [-117.37897, 33.97634], [-117.37903, 33.97625], [-117.3794, 33.97624], [-117.37964, 33.9762], [-117.37978, 33.97615]]]} | Open Access 1 | 25073 | 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 | 0.423 | Newman 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]);