units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
39 rows where MNG_AGENCY = 639 and MNG_AG_TYP = 4 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 3
MNG_AG_TYP 1
- Recreation/Parks District · 39 ✖
MNG_AGENCY 1
- Sunrise Recreation and Park District · 39 ✖
ACCESS_TYP 1
- Open Access 39
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11607 | 11607 | 11606 | {"type": "Polygon", "coordinates": [[[-121.35916, 38.71684], [-121.35881, 38.71689], [-121.35884, 38.71703], [-121.35856, 38.71714], [-121.3585, 38.71709], [-121.35841, 38.71706], [-121.35826, 38.71709], [-121.35584, 38.7171], [-121.35572, 38.71707], [-121.35563, 38.71709], [-121.35546, 38.71696], [-121.35521, 38.71696], [-121.3552, 38.71547], [-121.35454, 38.71511], [-121.35468, 38.71489], [-121.3548, 38.71466], [-121.35488, 38.71443], [-121.35494, 38.71421], [-121.35615, 38.71421], [-121.35617, 38.71206], [-121.35798, 38.7129], [-121.35772, 38.71326], [-121.35862, 38.71369], [-121.35858, 38.71389], [-121.35855, 38.71411], [-121.35856, 38.71459], [-121.35859, 38.71483], [-121.35885, 38.71599], [-121.35916, 38.71684]]]} | Open Access 1 | 23882 | Antelope Community Park | 15508 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 34.017 | Antelope Community Park | 0 | Local Park 2 | 4 | |
13650 | 13650 | 13649 | {"type": "MultiPolygon", "coordinates": [[[[-121.33733, 38.65608], [-121.33726, 38.65614], [-121.33675, 38.65624], [-121.33626, 38.65622], [-121.33625, 38.65614], [-121.33611, 38.65614], [-121.33612, 38.65605], [-121.33626, 38.65605], [-121.33626, 38.65586], [-121.33595, 38.65586], [-121.33594, 38.65596], [-121.33567, 38.65597], [-121.33544, 38.656], [-121.33528, 38.65609], [-121.33507, 38.65607], [-121.3349, 38.65612], [-121.33473, 38.65611], [-121.33473, 38.65602], [-121.33503, 38.65542], [-121.33588, 38.65516], [-121.33664, 38.65615], [-121.33685, 38.65592], [-121.33686, 38.65596], [-121.3369, 38.65595], [-121.337, 38.65602], [-121.33708, 38.65596], [-121.33714, 38.65588], [-121.33712, 38.65577], [-121.33701, 38.65573], [-121.33713, 38.6556], [-121.33733, 38.65608]]], [[[-121.34277, 38.65129], [-121.3424, 38.65235], [-121.34226, 38.65268], [-121.3423, 38.65301], [-121.34224, 38.65322], [-121.34218, 38.65329], [-121.34119, 38.65388], [-121.34097, 38.65419], [-121.34028, 38.65443], [-121.34023, 38.65451], [-121.34015, 38.65456], [-121.33895, 38.65492], [-121.33851, 38.65508], [-121.33812, 38.65534], [-121.33759, 38.65583], [-121.33737, 38.65531], [-121.33768, 38.65521], [-121.33764, 38.65509], [-121.33794, 38.65502], [-121.33797, 38.65507], [-121.33997, 38.65418], [-121.33999, 38.65419], [-121.34003, 38.65419], [-121.34057, 38.65396], [-121.34096, 38.65375], [-121.34127, 38.65348], [-121.34133, 38.65336], [-121.34178, 38.65282], [-121.34199, 38.65245], [-121.34206, 38.6523], [-121.34193, 38.65232], [-121.34204, 38.65212], [-121.34207, 38.65191], [-121.34226, 38.65143], [-121.34184, 38.65078], [-121.34162, 38.6506], [-121.34115, 38.64998], [-121.34119, 38.64993], [-121.34115, 38.64975], [-121.34121, 38.6493], [-121.34129, 38.64906], [-121.3418, 38.64906], [-121.34176, 38.64925], [-121.34156, 38.64955], [-121.34175, 38.64992], [-121.34179, 38.65006], [-121.34183, 38.65041], [-121.34215, 38.65048], [-121.34264, 38.65089], [-121.34277, 38.65129]]]]} | Open Access 1 | 36015 | Arcade Creek Nature Area | 15562 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 12.32 | Arcade Creek Nature Area | 0 | Local Conservation Area 4 | 2 | |
3774 | 3774 | 3773 | {"type": "Polygon", "coordinates": [[[-121.27757, 38.6844], [-121.27735, 38.6846], [-121.27714, 38.68446], [-121.27711, 38.68447], [-121.2769, 38.68433], [-121.27643, 38.68417], [-121.27632, 38.68409], [-121.27631, 38.68391], [-121.27174, 38.68393], [-121.27173, 38.68226], [-121.27214, 38.68226], [-121.27215, 38.68233], [-121.2722, 38.68239], [-121.27221, 38.68272], [-121.27308, 38.68271], [-121.27344, 38.68278], [-121.27471, 38.68354], [-121.27632, 38.68353], [-121.27632, 38.68368], [-121.27663, 38.68395], [-121.27711, 38.68411], [-121.27733, 38.68427], [-121.27736, 38.68425], [-121.27757, 38.6844]]]} | Open Access 1 | 45019 | Arcade Creek Park Preserve Development | 15564 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 10.069 | Arcade Creek Park Preserve Development | 0 | Local Conservation Area 4 | 2 | |
13732 | 13732 | 13731 | {"type": "Polygon", "coordinates": [[[-121.30691, 38.67268], [-121.3051, 38.67271], [-121.30415, 38.67288], [-121.30393, 38.67288], [-121.30394, 38.67079], [-121.3069, 38.67079], [-121.30691, 38.67268]]]} | Open Access 1 | 36218 | Brooktree Park | 16435 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 13.839 | Brooktree Park | 0 | Local Park 2 | 4 | |
14124 | 14124 | 14123 | {"type": "Polygon", "coordinates": [[[-121.25641, 38.7041], [-121.25359, 38.70412], [-121.25365, 38.70058], [-121.25519, 38.70056], [-121.25522, 38.70103], [-121.25635, 38.70102], [-121.25641, 38.7041]]]} | Open Access 1 | 43016 | C-Bar-C Park | 16623 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 22.055 | C-Bar-C Park | 0 | Local Park 2 | 4 | |
3500 | 3500 | 3499 | {"type": "Polygon", "coordinates": [[[-121.30119, 38.67445], [-121.30091, 38.67484], [-121.30047, 38.67468], [-121.30035, 38.67441], [-121.29992, 38.67421], [-121.2994, 38.67448], [-121.2988, 38.67434], [-121.29862, 38.67432], [-121.29865, 38.67415], [-121.29816, 38.6737], [-121.29776, 38.67344], [-121.29772, 38.67344], [-121.29767, 38.67337], [-121.29756, 38.67331], [-121.29688, 38.67257], [-121.29668, 38.67246], [-121.29633, 38.67237], [-121.29631, 38.67233], [-121.2963, 38.67214], [-121.29687, 38.67227], [-121.29722, 38.67242], [-121.29767, 38.67288], [-121.29844, 38.67353], [-121.29879, 38.67377], [-121.2998, 38.67379], [-121.30011, 38.67385], [-121.30119, 38.67445]]]} | Open Access 1 | 36016 | Cherry Creek Park | 17168 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 5.473 | Cherry Creek Park | 0 | Local Park 2 | 4 | |
13649 | 13649 | 13648 | {"type": "MultiPolygon", "coordinates": [[[[-121.30085, 38.68737], [-121.30066, 38.68739], [-121.29997, 38.68774], [-121.29947, 38.68774], [-121.29946, 38.68709], [-121.29977, 38.68709], [-121.29988, 38.68719], [-121.30039, 38.68715], [-121.30044, 38.68715], [-121.30082, 38.68698], [-121.30085, 38.68737]]], [[[-121.30537, 38.68726], [-121.30541, 38.68736], [-121.30543, 38.68748], [-121.30543, 38.68761], [-121.3054, 38.68772], [-121.30529, 38.68792], [-121.30518, 38.68804], [-121.30508, 38.68811], [-121.30454, 38.68839], [-121.30434, 38.68847], [-121.30414, 38.6885], [-121.30344, 38.6885], [-121.30319, 38.68804], [-121.30306, 38.68786], [-121.30289, 38.68742], [-121.30269, 38.68724], [-121.30237, 38.68711], [-121.30205, 38.68707], [-121.30106, 38.68731], [-121.301, 38.68664], [-121.30186, 38.68661], [-121.3024, 38.68638], [-121.3024, 38.68641], [-121.30327, 38.68679], [-121.30338, 38.68778], [-121.30377, 38.68796], [-121.30413, 38.68793], [-121.30537, 38.68726]]], [[[-121.30762, 38.68752], [-121.30717, 38.68784], [-121.30705, 38.68749], [-121.30663, 38.68722], [-121.30615, 38.68718], [-121.30564, 38.68742], [-121.3056, 38.68727], [-121.3055, 38.68709], [-121.30481, 38.68624], [-121.30473, 38.68611], [-121.30553, 38.68598], [-121.30641, 38.68555], [-121.30762, 38.68752]]]]} | Open Access 1 | 36011 | Crosswoods Park | 17833 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 15.692 | Crosswoods Park | 0 | Local Park 2 | 4 | |
16206 | 16206 | 16205 | {"type": "MultiPolygon", "coordinates": [[[[-121.25745, 38.71827], [-121.25706, 38.71836], [-121.25661, 38.71824], [-121.25604, 38.71835], [-121.25531, 38.7183], [-121.25481, 38.7183], [-121.25458, 38.71785], [-121.25377, 38.71788], [-121.25328, 38.7182], [-121.25312, 38.71819], [-121.25286, 38.71813], [-121.25264, 38.71812], [-121.25257, 38.71784], [-121.25237, 38.71788], [-121.25149, 38.71703], [-121.25155, 38.717], [-121.25163, 38.71644], [-121.25132, 38.71635], [-121.25131, 38.71616], [-121.2509, 38.71615], [-121.25093, 38.71604], [-121.25088, 38.71596], [-121.25078, 38.71592], [-121.25061, 38.71591], [-121.25062, 38.71554], [-121.25014, 38.71543], [-121.25015, 38.71537], [-121.24976, 38.71477], [-121.24969, 38.71478], [-121.24951, 38.71459], [-121.24941, 38.71442], [-121.24946, 38.71417], [-121.24989, 38.714], [-121.24981, 38.71437], [-121.25022, 38.71465], [-121.25022, 38.71501], [-121.25049, 38.71539], [-121.25132, 38.71542], [-121.25177, 38.71557], [-121.25215, 38.71577], [-121.2526, 38.71618], [-121.25276, 38.71637], [-121.25277, 38.71658], [-121.25261, 38.71688], [-121.25297, 38.71734], [-121.25333, 38.71738], [-121.25374, 38.71722], [-121.25376, 38.71752], [-121.25438, 38.71751], [-121.25463, 38.71726], [-121.2548, 38.71733], [-121.25492, 38.71737], [-121.25509, 38.7178], [-121.25531, 38.7178], [-121.2561, 38.71779], [-121.25611, 38.71739], [-121.25646, 38.71738], [-121.25695, 38.7173], [-121.25696, 38.71737], [-121.25722, 38.71769], [-121.2574, 38.71774], [-121.25738, 38.71787], [-121.25739, 38.71803], [-121.25745, 38.71827]]], [[[-121.26254, 38.71962], [-121.26116, 38.71952], [-121.26128, 38.71921], [-121.26101, 38.71881], [-121.26072, 38.71861], [-121.26024, 38.71858], [-121.26019, 38.71897], [-121.25863, 38.71886], [-121.25863, 38.71854], [-121.25823, 38.71839], [-121.25818, 38.71824], [-121.2577, 38.7182], [-121.25763, 38.71822], [-121.25758, 38.71806], [-121.25757, 38.71792], [-121.25758, 38.71779], [-121.25762, 38.71768], [-121.25763, 38.71764], [-121.25811, 38.71778], [-121.25821, 38.71765], [-121.25843, 38.7178], [-121.25868, 38.71794], [-121.25896, 38.71806], [-121.25924, 38.71814], [-121.25971, 38.71822], [-121.26008, 38.71788], [-121.2606, 38.71806], [-121.26089, 38.71821], [-121.26131, 38.71847], [-121.26162, 38.71861], [-121.26184, 38.71867], [-121.26209, 38.71872], [-121.26253, 38.71873], [-121.26254, 38.71962]]]]} | Open Access 1 | 44064 | Edgecliff/Cripple Creek Open Space | 18434 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 24.487 | Edgecliff/Cripple Creek OS | 0 | Local Recreation Area 3 | 4 | |
11646 | 11646 | 11645 | {"type": "Polygon", "coordinates": [[[-121.32967, 38.66609], [-121.32964, 38.66739], [-121.3274, 38.66735], [-121.32743, 38.66607], [-121.32967, 38.66609]]]} | Open Access 1 | 23937 | Eugene H. Ahner Park | 18747 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 6.925 | Eugene H. Ahner Park | 0 | Local Park 2 | 4 | |
11622 | 11622 | 11621 | {"type": "MultiPolygon", "coordinates": [[[[-121.33851, 38.68543], [-121.33712, 38.68611], [-121.33687, 38.6863], [-121.33676, 38.68643], [-121.33666, 38.68656], [-121.33656, 38.68679], [-121.33651, 38.68703], [-121.33651, 38.68894], [-121.33632, 38.68894], [-121.33624, 38.68897], [-121.33531, 38.68816], [-121.3349, 38.6877], [-121.33466, 38.68763], [-121.33452, 38.6875], [-121.33441, 38.68734], [-121.33419, 38.68646], [-121.33445, 38.68602], [-121.33458, 38.68571], [-121.33476, 38.68545], [-121.33491, 38.68528], [-121.33509, 38.68513], [-121.33531, 38.68498], [-121.33552, 38.68486], [-121.33574, 38.68477], [-121.33598, 38.68469], [-121.33618, 38.68463], [-121.33647, 38.68459], [-121.33647, 38.6849], [-121.33638, 38.68495], [-121.33636, 38.68503], [-121.33638, 38.68509], [-121.33645, 38.68513], [-121.33654, 38.68514], [-121.33662, 38.68511], [-121.33663, 38.68534], [-121.33714, 38.68534], [-121.33728, 38.68555], [-121.33744, 38.68542], [-121.33782, 38.68526], [-121.33814, 38.6852], [-121.33836, 38.68526], [-121.33851, 38.68543]], [[-121.33601, 38.68515], [-121.33602, 38.6851], [-121.33595, 38.6851], [-121.33595, 38.68515], [-121.33601, 38.68515]]], [[[-121.3379, 38.68961], [-121.33744, 38.68963], [-121.33761, 38.68997], [-121.33781, 38.69027], [-121.33749, 38.69064], [-121.33743, 38.69146], [-121.33733, 38.69156], [-121.33682, 38.69156], [-121.33682, 38.69142], [-121.33672, 38.69142], [-121.33672, 38.68862], [-121.33733, 38.68863], [-121.33733, 38.68904], [-121.33744, 38.68959], [-121.33789, 38.68959], [-121.3379, 38.68961]]]]} | Open Access 1 | 23904 | Foothill Community Park | 18976 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 24.928 | Foothill Community Park | 0 | Local Park 2 | 4 | |
16216 | 16216 | 16215 | {"type": "MultiPolygon", "coordinates": [[[[-121.32436, 38.68423], [-121.32407, 38.68432], [-121.32368, 38.6844], [-121.32312, 38.68449], [-121.32291, 38.68451], [-121.32292, 38.68418], [-121.32377, 38.68406], [-121.32405, 38.68399], [-121.32436, 38.68423]]], [[[-121.32508, 38.68324], [-121.32478, 38.68325], [-121.32473, 38.68326], [-121.32467, 38.6833], [-121.32465, 38.68337], [-121.32468, 38.68362], [-121.32468, 38.68382], [-121.32466, 38.68391], [-121.32462, 38.68401], [-121.32454, 38.6841], [-121.32446, 38.68416], [-121.32442, 38.68413], [-121.32416, 38.68394], [-121.32422, 38.68386], [-121.32423, 38.68378], [-121.32417, 38.68325], [-121.32412, 38.68308], [-121.324, 38.68282], [-121.32378, 38.68248], [-121.32363, 38.68218], [-121.32358, 38.68216], [-121.32354, 38.68218], [-121.32339, 38.6824], [-121.32327, 38.68266], [-121.32317, 38.68301], [-121.32303, 38.68321], [-121.32294, 38.68327], [-121.32298, 38.68193], [-121.32316, 38.6819], [-121.32321, 38.6818], [-121.32365, 38.68166], [-121.32378, 38.68166], [-121.32397, 38.68175], [-121.32409, 38.68185], [-121.32434, 38.6819], [-121.32437, 38.68215], [-121.32447, 38.68239], [-121.32458, 38.68254], [-121.3249, 38.68291], [-121.32499, 38.68305], [-121.32508, 38.68324]]], [[[-121.32685, 38.68121], [-121.32683, 38.68171], [-121.32655, 38.68189], [-121.32646, 38.68223], [-121.32636, 38.68246], [-121.32629, 38.68257], [-121.32613, 38.68273], [-121.32551, 38.68316], [-121.3254, 38.68322], [-121.32526, 38.68326], [-121.32516, 38.68302], [-121.32503, 38.6828], [-121.32517, 38.68278], [-121.32535, 38.68268], [-121.3254, 38.68256], [-121.3256, 38.68232], [-121.32558, 38.68229], [-121.32565, 38.68223], [-121.32567, 38.68218], [-121.32565, 38.68212], [-121.32572, 38.6819], [-121.32573, 38.6817], [-121.32577, 38.68162], [-121.32575, 38.68155], [-121.32585, 38.68149], [-121.32576, 38.6812], [-121.32685, 38.68121]]]]} | Open Access 1 | 44675 | Indian River Drive Open Space | 20205 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 10.226 | Indian River Drive OS | 0 | Local Recreation Area 3 | 4 | |
3928 | 3928 | 3927 | {"type": "Polygon", "coordinates": [[[-121.38462, 38.71894], [-121.38462, 38.72153], [-121.3846, 38.72154], [-121.38459, 38.72181], [-121.38418, 38.72178], [-121.38313, 38.72178], [-121.38312, 38.71965], [-121.38313, 38.71906], [-121.38287, 38.71845], [-121.38347, 38.71836], [-121.38409, 38.71824], [-121.38413, 38.71826], [-121.38417, 38.71837], [-121.38417, 38.71844], [-121.38413, 38.71854], [-121.38415, 38.71861], [-121.38418, 38.71864], [-121.38425, 38.71867], [-121.38438, 38.71867], [-121.38448, 38.71894], [-121.38462, 38.71894]]]} | Open Access 1 | 36210 | Lone Oak Park | 21440 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 12.014 | Lone Oak Park | 0 | Local Park 2 | 4 | |
13692 | 13692 | 13691 | {"type": "Polygon", "coordinates": [[[-121.2693, 38.71205], [-121.26927, 38.71499], [-121.2671, 38.71497], [-121.2671, 38.71204], [-121.2693, 38.71205]]]} | Open Access 1 | 36076 | Madera Park | 21654 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 15.326 | Madera Park | 0 | Local Park 2 | 4 | |
14243 | 14243 | 14242 | {"type": "Polygon", "coordinates": [[[-121.2692, 38.70536], [-121.2692, 38.70651], [-121.2682, 38.70653], [-121.2682, 38.70579], [-121.26831, 38.70574], [-121.2692, 38.70536]]]} | Open Access 1 | 44136 | McDonald Field Park | 22021 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.271 | McDonald Field Park | 0 | Local Recreation Area 3 | 4 | |
13713 | 13713 | 13712 | {"type": "Polygon", "coordinates": [[[-121.25298, 38.69746], [-121.25298, 38.69861], [-121.25254, 38.69848], [-121.25252, 38.69849], [-121.25248, 38.69848], [-121.25142, 38.69879], [-121.2513, 38.6986], [-121.25118, 38.69846], [-121.25171, 38.69808], [-121.25203, 38.69778], [-121.25199, 38.69751], [-121.25245, 38.69746], [-121.25298, 38.69746]]]} | Open Access 1 | 36220 | Northwoods Park | 22902 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.516 | Northwoods Park | 0 | Local Park 2 | 4 | |
13730 | 13730 | 13729 | {"type": "Polygon", "coordinates": [[[-121.31655, 38.67259], [-121.31615, 38.67248], [-121.31541, 38.67249], [-121.31541, 38.67194], [-121.31568, 38.67194], [-121.31611, 38.67179], [-121.31649, 38.67247], [-121.31655, 38.67259]]]} | Open Access 1 | 36216 | Park Oaks Park | 23430 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.367 | Park Oaks Park | 0 | Local Park 2 | 4 | |
13652 | 13652 | 13651 | {"type": "Polygon", "coordinates": [[[-121.34512, 38.67339], [-121.34482, 38.67322], [-121.34451, 38.67307], [-121.3441, 38.6729], [-121.34373, 38.67278], [-121.34371, 38.67273], [-121.34374, 38.67257], [-121.34374, 38.67235], [-121.34378, 38.67232], [-121.34442, 38.67215], [-121.34483, 38.67207], [-121.34538, 38.67202], [-121.3456, 38.67202], [-121.34566, 38.67204], [-121.34568, 38.67208], [-121.34568, 38.6728], [-121.34566, 38.67292], [-121.34555, 38.67308], [-121.34524, 38.67338], [-121.34517, 38.6734], [-121.34512, 38.67339]]]} | Open Access 1 | 36021 | Pioneer Park | 23737 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 4.497 | Pioneer Park | 0 | Local Park 2 | 4 | |
11628 | 11628 | 11627 | {"type": "Polygon", "coordinates": [[[-121.35512, 38.68034], [-121.3551, 38.68038], [-121.35384, 38.68155], [-121.35192, 38.68026], [-121.35212, 38.67996], [-121.35227, 38.67966], [-121.35251, 38.67907], [-121.35315, 38.67919], [-121.35339, 38.67927], [-121.35364, 38.67937], [-121.35387, 38.6795], [-121.35508, 38.68028], [-121.35511, 38.6803], [-121.35512, 38.68034]]]} | Open Access 1 | 23911 | Robert Frost Park | 24487 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 10.212 | Robert Frost Park | 0 | Local Park 2 | 4 | |
14125 | 14125 | 14124 | {"type": "Polygon", "coordinates": [[[-121.29954, 38.71017], [-121.29705, 38.71019], [-121.29704, 38.70937], [-121.29055, 38.70941], [-121.29054, 38.7073], [-121.29165, 38.70731], [-121.29228, 38.70735], [-121.29265, 38.70743], [-121.29439, 38.70744], [-121.29441, 38.70742], [-121.29476, 38.70752], [-121.29497, 38.70754], [-121.29951, 38.7075], [-121.29954, 38.71017]]]} | Open Access 1 | 43018 | Rusch Park | 24733 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 46.067 | Rusch Park | 0 | Local Park 2 | 4 | |
14188 | 14188 | 14187 | {"type": "Polygon", "coordinates": [[[-121.34316, 38.67726], [-121.34314, 38.67731], [-121.34317, 38.67742], [-121.34317, 38.67773], [-121.34315, 38.67776], [-121.34285, 38.67782], [-121.34266, 38.67788], [-121.34246, 38.67798], [-121.34233, 38.67808], [-121.34293, 38.67748], [-121.34304, 38.67739], [-121.34316, 38.67726]]]} | Open Access 1 | 44008 | Rushmore Jeanine Park | 24735 | 2199 | Sunrise Recreation and Park District 650 | Special District 4 | Recreation/Parks District 4 | http://sunriseparks.com/ | Special District 4 | 2199 | Sunrise Recreation and Park District 639 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 0.434 | Rushmore Jeanine 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]);