units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,640 rows where ACCESS_TYP = 1 and DES_TP = 3 sorted by PARK_URL descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 1,640 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11316 | 11316 | 11315 | {"type": "Polygon", "coordinates": [[[-120.23983, 37.96099], [-120.23982, 37.96122], [-120.23954, 37.96122], [-120.23954, 37.96099], [-120.23983, 37.96099]]]} | Open Access 1 | 48052 | Bay Street Tot Lot | 32546 | 2169 | Tuolumne Park and Recreation District 741 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | https://www.tuolumnerecreation.com/TPRD_facilities.html | Tuolumne 21 | 0.163 | Bay Street Tot Lot | 2011 | Local Recreation Area 3 | 4 |
11367 | 11367 | 11366 | {"type": "Polygon", "coordinates": [[[-120.18086, 37.99455], [-120.18082, 37.99822], [-120.18026, 37.99868], [-120.1788, 37.99869], [-120.17953, 37.99809], [-120.17867, 37.99728], [-120.17833, 37.99763], [-120.17708, 37.99617], [-120.1795, 37.99458], [-120.18086, 37.99455]]]} | Open Access 1 | 48060 | River Ranch Campground | 32552 | 2169 | Tuolumne Park and Recreation District 741 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | https://www.tuolumnerecreation.com/TPRD_facilities.html | Tuolumne 21 | 24.283 | River Ranch Campground | 1960 | Local Recreation Area 3 | 4 |
14131 | 14131 | 14130 | {"type": "Polygon", "coordinates": [[[-119.32522, 36.15647], [-119.32197, 36.1564], [-119.32208, 36.15273], [-119.32208, 36.15273], [-119.32522, 36.15647]]]} | Open Access 1 | 48851 | Elk Bayou Soccer Complex | 33571 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | https://www.tulare.ca.gov/Home/Components/FacilityDirectory/FacilityDirectory/22/155 | Tulare 29 | 14.659 | Elk Bayou Soccer Complex | 0 | Local Recreation Area 3 | 4 |
16623 | 16623 | 16622 | {"type": "Polygon", "coordinates": [[[-121.12692, 38.32886], [-121.11901, 38.33613], [-121.11309, 38.33752], [-121.10553, 38.33757], [-121.104, 38.33961], [-121.1038, 38.35073], [-121.07621, 38.35076], [-121.0762, 38.33633], [-121.08539, 38.3363], [-121.08539, 38.32906], [-121.10379, 38.329], [-121.10381, 38.33624], [-121.10382, 38.33625], [-121.11309, 38.33615], [-121.11309, 38.32894], [-121.12692, 38.32886]], [[-121.08712, 38.33171], [-121.08831, 38.33059], [-121.0886, 38.33024], [-121.08872, 38.32997], [-121.08887, 38.32906], [-121.08694, 38.32906], [-121.08671, 38.33014], [-121.08658, 38.3303], [-121.08635, 38.33047], [-121.08614, 38.33054], [-121.08604, 38.33063], [-121.08608, 38.33088], [-121.08621, 38.33112], [-121.0868, 38.33162], [-121.08712, 38.33171]], [[-121.08621, 38.34122], [-121.08622, 38.34124], [-121.08666, 38.34098], [-121.08664, 38.34098], [-121.08621, 38.34122]]]} | Open Access 1 | 21808 | Rancho Seco Recreational Area | 29290 | 2129 | Sacramento Municipal Utility District 591 | Special District 4 | Water District 13 | http://www.smud.org/ | Special District 4 | 2129 | Sacramento Municipal Utility District 581 | Special District 4 | Water District 13 | https://www.smud.org/en/about-smud/community/recreational-areas/rancho-seco-lake.htm | Sacramento 41 | 1484.024 | Rancho Seco Recreational Area | 0 | Local Recreation Area 3 | 4 |
11163 | 11163 | 11162 | {"type": "Polygon", "coordinates": [[[-122.43003, 37.77971], [-122.42876, 37.77987], [-122.42861, 37.77913], [-122.42988, 37.77897], [-122.43003, 37.77971]]]} | Open Access 1 | 48006 | Ella Hill Hutch Center | 32433 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | https://www.sfparksalliance.org/our-parks/parks/ella-hill-hutch-center | San Francisco 13 | 2.344 | Ella Hill Hutch Ctr. | 0 | Local Recreation Area 3 | 4 |
11580 | 11580 | 11579 | {"type": "Polygon", "coordinates": [[[-122.33843, 37.96763], [-122.33822, 37.96764], [-122.33751, 37.9677], [-122.33749, 37.96762], [-122.33702, 37.96765], [-122.33701, 37.96676], [-122.33832, 37.96678], [-122.33843, 37.96763]]]} | Open Access 1 | 23688 | El Portal Soccer Field | 32541 | 1311 | San Pablo, City of 192 | City 2 | City Agency 2 | http://www.ci.san-pablo.ca.us/ | City 2 | 1311 | San Pablo, City of 188 | City 2 | City Agency 2 | https://www.sanpabloca.gov/1489/El-Portal-Soccer-Fieldv | Contra Costa 12 | 2.907 | El Portal Soccer Field | 0 | Local Recreation Area 3 | 4 |
3977 | 3977 | 3976 | {"type": "Polygon", "coordinates": [[[-121.85453, 37.34889], [-121.85442, 37.34894], [-121.85423, 37.34868], [-121.85434, 37.34863], [-121.85453, 37.34889]]]} | Open Access 1 | 48844 | San Antonio Tot Lot | 33564 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | https://www.sanjoseca.gov/Home/Components/FacilityDirectory/FacilityDirectory/2945/37 | Santa Clara 19 | 0.09 | San Antonio Tot Lot | 0 | Local Recreation Area 3 | 4 |
14861 | 14861 | 14860 | {"type": "Polygon", "coordinates": [[[-118.10949, 34.09919], [-118.10938, 34.09922], [-118.10907, 34.09927], [-118.10903, 34.09911], [-118.10936, 34.09897], [-118.10949, 34.09919]]]} | Open Access 1 | 48194 | Community Recreation Center | 32731 | 1301 | San Gabriel, City of 740 | City 2 | City Agency 2 | http://www.sangabrielcity.com/ | City 2 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | https://www.sangabrielcity.com/549/Community-Recreation-Center | Los Angeles 6 | 0.205 | Community Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
16186 | 16186 | 16185 | {"type": "MultiPolygon", "coordinates": [[[[-117.00447, 33.07327], [-117.00428, 33.07335], [-117.00391, 33.0734], [-117.0033, 33.0736], [-117.00314, 33.07361], [-117.00277, 33.07356], [-117.00262, 33.07357], [-117.00247, 33.0736], [-117.00222, 33.07371], [-117.00187, 33.07398], [-117.00168, 33.07406], [-116.99795, 33.07481], [-116.99298, 33.07587], [-116.99275, 33.07315], [-117.0015, 33.0732], [-117.00268, 33.07324], [-117.00447, 33.07327]]], [[[-116.99723, 33.07514], [-116.99801, 33.07497], [-117.00174, 33.07422], [-117.00196, 33.07413], [-117.0023, 33.07386], [-117.00251, 33.07376], [-117.00275, 33.07373], [-117.00314, 33.07377], [-117.00337, 33.07376], [-117.00399, 33.07355], [-117.00438, 33.07349], [-117.00451, 33.07344], [-117.00472, 33.07332], [-117.00514, 33.07321], [-117.01479, 33.07329], [-117.01479, 33.07322], [-117.01873, 33.07318], [-117.01875, 33.06972], [-117.02308, 33.06956], [-117.02299, 33.07945], [-117.02171, 33.07996], [-117.02157, 33.08027], [-117.02148, 33.08038], [-117.02131, 33.08048], [-117.0211, 33.08052], [-117.021, 33.08078], [-117.02098, 33.08104], [-117.02087, 33.08151], [-117.02058, 33.08183], [-117.02023, 33.08195], [-117.02, 33.082], [-117.0199, 33.082], [-117.01977, 33.08196], [-117.0197, 33.08199], [-117.01965, 33.08209], [-117.01968, 33.08219], [-117.01995, 33.08269], [-117.02011, 33.08289], [-117.02012, 33.08294], [-117.02009, 33.08299], [-117.01998, 33.08309], [-117.01997, 33.08344], [-117.01993, 33.08354], [-117.01937, 33.0841], [-117.01927, 33.08415], [-117.01916, 33.08416], [-117.01906, 33.08415], [-117.01871, 33.08401], [-117.0183, 33.08373], [-117.01789, 33.08335], [-117.01771, 33.08323], [-117.01724, 33.08311], [-117.01714, 33.08303], [-117.01707, 33.08292], [-117.01696, 33.08292], [-117.01595, 33.08279], [-117.01568, 33.08269], [-117.01554, 33.08265], [-117.01535, 33.08251], [-117.0153, 33.08243], [-117.01516, 33.08229], [-117.01512, 33.08218], [-117.01513, 33.0816], [-117.01516, 33.08156], [-117.01516, 33.08152], [-117.01513, 33.08149], [-117.01494, 33.08147], [-117.01476, 33.08143], [-117.01466, 33.08137], [-117.01443, 33.0813], [-117.01426, 33.0812], [-117.01388, 33.08075], [-117.01384, 33.08066], [-117.01381, 33.08047], [-117.01375, 33.08043], [-117.01361, 33.08027], [-117.01352, 33.08009], [-117.01327, 33.07982], [-117.01322, 33.0797], [-117.01315, 33.07961], [-117.01304, 33.0794], [-117.01294, 33.0793], [-117.01282, 33.07923], [-117.01272, 33.07911], [-117.01263, 33.07893], [-117.0126, 33.07868], [-117.01257, 33.07864], [-117.01229, 33.0786], [-117.01205, 33.0785], [-117.01195, 33.0785], [-117.01184, 33.07846], [-117.01168, 33.07836], [-117.01156, 33.0782], [-117.01151, 33.07816], [-117.01123, 33.07814], [-117.01107, 33.07807], [-117.01059, 33.07792], [-117.01029, 33.07778], [-117.01021, 33.07771], [-117.00983, 33.07751], [-117.00956, 33.07739], [-117.00928, 33.07731], [-117.00907, 33.07721], [-117.00899, 33.07725], [-117.00878, 33.07724], [-117.00873, 33.0772], [-117.00872, 33.07716], [-117.00864, 33.07713], [-117.00856, 33.07704], [-117.00848, 33.07702], [-117.00829, 33.07701], [-117.00826, 33.07694], [-117.00827, 33.0768], [-117.00824, 33.07677], [-117.00818, 33.07678], [-117.0081, 33.07691], [-117.00802, 33.07692], [-117.00768, 33.07666], [-117.00747, 33.07656], [-117.00739, 33.07649], [-117.00734, 33.07649], [-117.00728, 33.07651], [-117.00721, 33.07651], [-117.00699, 33.07641], [-117.00681, 33.07642], [-117.00665, 33.07637], [-117.0066, 33.07637], [-117.00647, 33.07646], [-117.00641, 33.07648], [-117.00621, 33.07647], [-117.00612, 33.07649], [-117.00602, 33.07649], [-117.0059, 33.07653], [-117.00579, 33.07652], [-117.00553, 33.07642], [-117.00525, 33.07639], [-117.00515, 33.07636], [-117.00504, 33.07626], [-117.00456, 33.07599], [-117.00453, 33.07592], [-117.0045, 33.07589], [-117.00436, 33.07587], [-117.00368, 33.0759], [-117.00365, 33.07593], [-117.00365, 33.07599], [-117.00361, 33.07604], [-117.00325, 33.07624], [-117.00312, 33.07626], [-117.00295, 33.07633], [-117.00285, 33.07652], [-117.00274, 33.0765], [-117.0027, 33.07647], [-117.00267, 33.07639], [-117.0026, 33.07638], [-117.00231, 33.07646], [-117.00221, 33.07648], [-117.00207, 33.07658], [-117.00199, 33.07661], [-117.00191, 33.07661], [-117.00166, 33.07657], [-117.00161, 33.07654], [-117.00159, 33.0765], [-117.00159, 33.07635], [-117.00154, 33.07622], [-117.00156, 33.07617], [-117.00155, 33.07613], [-117.00136, 33.07599], [-117.00128, 33.07597], [-117.00116, 33.07603], [-117.00109, 33.07605], [-117.00087, 33.07601], [-117.0007, 33.07609], [-117.00059, 33.0761], [-117.00056, 33.07611], [-117.00057, 33.07613], [-117.00048, 33.07615], [-117.00052, 33.07623], [-117.00052, 33.07631], [-117.00049, 33.07636], [-117.00039, 33.07648], [-117.00036, 33.07661], [-117.00002, 33.07679], [-116.99993, 33.07682], [-116.99977, 33.07683], [-116.99961, 33.07679], [-116.99952, 33.07675], [-116.99938, 33.07678], [-116.99926, 33.07673], [-116.99887, 33.07679], [-116.99882, 33.07676], [-116.99876, 33.07663], [-116.99872, 33.07659], [-116.99867, 33.07657], [-116.99856, 33.07657], [-116.99846, 33.07652], [-116.99841, 33.07652], [-116.99837, 33.07657], [-116.99836, 33.07694], [-116.99833, 33.077], [-116.9983, 33.07702], [-116.99827, 33.07701], [-116.99825, 33.07696], [-116.99822, 33.07695], [-116.99819, 33.07696], [-116.99819, 33.077], [-116.99815, 33.07703], [-116.99805, 33.07701], [-116.998, 33.07702], [-116.99797, 33.07705], [-116.99795, 33.07709], [-116.99797, 33.07713], [-116.99802, 33.07719], [-116.998, 33.07724], [-116.99794, 33.07726], [-116.99788, 33.07724], [-116.99782, 33.07723], [-116.99767, 33.07728], [-116.9976, 33.07724], [-116.9976, 33.07716], [-116.99758, 33.07712], [-116.99754, 33.07711], [-116.99746, 33.07711], [-116.99742, 33.07708], [-116.9974, 33.07698], [-116.99718, 33.07663], [-116.99702, 33.07647], [-116.9968, 33.07652], [-116.99652, 33.07647], [-116.9963, 33.07624], [-116.99606, 33.07635], [-116.99597, 33.07545], [-116.99723, 33.07514]]], [[[-116.92759, 33.07655], [-116.92744, 33.07995], [-116.92748, 33.0867], [-116.92709, 33.0866], [-116.92684, 33.08649], [-116.92578, 33.08581], [-116.92555, 33.0857], [-116.92531, 33.08563], [-116.92514, 33.08561], [-116.92454, 33.08558], [-116.92436, 33.08559], [-116.9242, 33.08561], [-116.92403, 33.08565], [-116.92389, 33.0857], [-116.92361, 33.08583], [-116.92342, 33.08582], [-116.92327, 33.08589], [-116.92313, 33.0859], [-116.92298, 33.08589], [-116.92285, 33.08584], [-116.92272, 33.08574], [-116.92257, 33.08558], [-116.9224, 33.08551], [-116.92144, 33.08427], [-116.92136, 33.08403], [-116.92135, 33.08388], [-116.92138, 33.08338], [-116.92137, 33.08327], [-116.9213, 33.08309], [-116.92112, 33.08288], [-116.92092, 33.08278], [-116.9206, 33.08272], [-116.92044, 33.08274], [-116.91994, 33.08284], [-116.91976, 33.08285], [-116.91957, 33.08284], [-116.91934, 33.08277], [-116.91873, 33.08253], [-116.91846, 33.08247], [-116.91745, 33.08251], [-116.91726, 33.08255], [-116.91705, 33.08263], [-116.91698, 33.08268], [-116.91683, 33.08284], [-116.91676, 33.08304], [-116.91675, 33.08318], [-116.91683, 33.08362], [-116.91682, 33.08374], [-116.91678, 33.0839], [-116.91666, 33.08407], [-116.91654, 33.08417], [-116.91437, 33.08565], [-116.91421, 33.08569], [-116.91393, 33.08569], [-116.91341, 33.08547], [-116.91308, 33.08539], [-116.91204, 33.08534], [-116.91147, 33.08526], [-116.91131, 33.08526], [-116.91117, 33.08529], [-116.91099, 33.08535], [-116.91082, 33.08544], [-116.91063, 33.08554], [-116.91037, 33.08571], [-116.91002, 33.08603], [-116.90967, 33.08649], [-116.90939, 33.08678], [-116.90916, 33.08694], [-116.909, 33.08699], [-116.90884, 33.08702], [-116.90872, 33.08703], [-116.90857, 33.08701], [-116.90828, 33.08692], [-116.90805, 33.08681], [-116.90773, 33.08657], [-116.90745, 33.08645], [-116.90733, 33.08643], [-116.90718, 33.08641], [-116.90621, 33.08639], [-116.90593, 33.08641], [-116.90576, 33.08644], [-116.90575, 33.0799], [-116.90995, 33.07989], [-116.91005, 33.07638], [-116.91005, 33.07606], [-116.91406, 33.07609], [-116.91386, 33.07229], [-116.91884, 33.07241], [-116.91858, 33.07623], [-116.92759, 33.07655]]], [[[-116.95037, 33.10964], [-116.95001, 33.11701], [-116.94576, 33.11706], [-116.94101, 33.11703], [-116.93637, 33.11709], [-116.93668, 33.10981], [-116.93672, 33.10607], [-116.9277, 33.10613], [-116.92319, 33.10609], [-116.92315, 33.1024], [-116.9185, 33.10234], [-116.91452, 33.10225], [-116.91451, 33.10226], [-116.91449, 33.10601], [-116.91016, 33.10601], [-116.91016, 33.10808], [-116.91014, 33.1102], [-116.90585, 33.11018], [-116.90581, 33.10592], [-116.90151, 33.10587], [-116.90149, 33.09135], [-116.90576, 33.0914], [-116.90576, 33.08682], [-116.90603, 33.0867], [-116.90623, 33.08665], [-116.90645, 33.08663], [-116.90652, 33.08661], [-116.90657, 33.08656], [-116.90718, 33.08657], [-116.90739, 33.08661], [-116.90763, 33.08671], [-116.90792, 33.08693], [-116.90818, 33.08708], [-116.90851, 33.08718], [-116.90867, 33.08719], [-116.90886, 33.08718], [-116.90902, 33.08717], [-116.90917, 33.08712], [-116.90939, 33.087], [-116.90958, 33.08685], [-116.90973, 33.08671], [-116.91012, 33.08619], [-116.9104, 33.08591], [-116.91054, 33.08581], [-116.91088, 33.08559], [-116.91124, 33.08544], [-116.91147, 33.08543], [-116.91202, 33.0855], [-116.91306, 33.08555], [-116.91336, 33.08564], [-116.91372, 33.0858], [-116.91387, 33.08584], [-116.91412, 33.08587], [-116.91435, 33.08583], [-116.9145, 33.08577], [-116.91461, 33.08571], [-116.91666, 33.0843], [-116.91683, 33.08415], [-116.91695, 33.08397], [-116.91699, 33.08387], [-116.91702, 33.08372], [-116.91702, 33.08361], [-116.91695, 33.08323], [-116.91694, 33.08309], [-116.91698, 33.08297], [-116.91702, 33.0829], [-116.91718, 33.08276], [-116.91728, 33.08272], [-116.91745, 33.08268], [-116.91833, 33.08264], [-116.91851, 33.08264], [-116.91873, 33.0827], [-116.91932, 33.08294], [-116.9196, 33.08301], [-116.91978, 33.08302], [-116.92, 33.083], [-116.92054, 33.08289], [-116.92064, 33.08289], [-116.92084, 33.08293], [-116.92102, 33.08304], [-116.92112, 33.08315], [-116.92118, 33.08331], [-116.92119, 33.08341], [-116.92116, 33.08388], [-116.92118, 33.08397], [-116.92118, 33.08409], [-116.92128, 33.08437], [-116.92136, 33.0845], [-116.92247, 33.08589], [-116.9226, 33.08599], [-116.92282, 33.08608], [-116.92296, 33.08612], [-116.9231, 33.08614], [-116.92325, 33.08613], [-116.92338, 33.08611], [-116.92351, 33.08607], [-116.92411, 33.0858], [-116.92431, 33.08576], [-116.92453, 33.08574], [-116.92525, 33.08578], [-116.92535, 33.0858], [-116.92565, 33.08593], [-116.92656, 33.08653], [-116.92676, 33.08665], [-116.92707, 33.08677], [-116.9276, 33.08691], [-116.92762, 33.09523], [-116.9417, 33.09509], [-116.94152, 33.09872], [-116.94634, 33.09872], [-116.94598, 33.10967], [-116.95037, 33.10964]]]]} | Open Access 1 | 46817 | San Pasqual Trails Open Space | 30281 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/park-and-recreation/parks/osp/sanpasqual | San Diego 4 | 3036.959 | San Pasqual Trails OS | 0 | Local Recreation Area 3 | 4 |
8901 | 8901 | 8900 | {"type": "Polygon", "coordinates": [[[-117.24522, 32.80169], [-117.24443, 32.80186], [-117.24419, 32.8011], [-117.24499, 32.80093], [-117.24522, 32.80169]]]} | Open Access 1 | 48513 | Pacific Beach Recreation Center | 33225 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/park-and-recreation/centers/recctr/pacificb | San Diego 4 | 1.663 | Pacific Beach Rec. Ctr. | 1975 | Local Recreation Area 3 | 4 |
1129 | 1129 | 1128 | {"type": "Polygon", "coordinates": [[[-117.04676, 32.56542], [-117.04503, 32.56542], [-117.04504, 32.56485], [-117.04551, 32.56485], [-117.04578, 32.5649], [-117.0459, 32.56494], [-117.04676, 32.56542]]]} | Open Access 1 | 47587 | Colonel Irving Salomon San Ysidro Community Activity Center | 31314 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/park-and-recreation/centers/recctr/colonel | San Diego 4 | 1.766 | Colonel Irving Salomon San Ysidro Community Activity Ctr. | 0 | Local Recreation Area 3 | 4 |
13496 | 13496 | 13495 | {"type": "Polygon", "coordinates": [[[-117.61267, 33.45818], [-117.61235, 33.45862], [-117.61242, 33.45866], [-117.6122, 33.45896], [-117.61217, 33.45895], [-117.61187, 33.45933], [-117.61189, 33.45935], [-117.61164, 33.45962], [-117.61136, 33.45988], [-117.61091, 33.46023], [-117.61058, 33.46044], [-117.61005, 33.46072], [-117.6077, 33.46174], [-117.60716, 33.462], [-117.60666, 33.4623], [-117.60562, 33.46305], [-117.60511, 33.4634], [-117.60478, 33.4636], [-117.60468, 33.46358], [-117.60409, 33.46281], [-117.60379, 33.46232], [-117.60362, 33.46197], [-117.60347, 33.4616], [-117.60329, 33.46104], [-117.60325, 33.46083], [-117.6033, 33.46081], [-117.60311, 33.45993], [-117.60308, 33.45981], [-117.60303, 33.45981], [-117.60295, 33.45954], [-117.60303, 33.45951], [-117.60297, 33.45933], [-117.60275, 33.45878], [-117.60266, 33.4588], [-117.60234, 33.4582], [-117.61267, 33.45818]]]} | Open Access 1 | 48826 | Vista Hermosa Sports Park | 33545 | 1296 | San Clemente, City of 353 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/61/2783 | Orange 3 | 80.721 | Vista Hermosa Sports Park | 0 | Local Recreation Area 3 | 4 |
13544 | 13544 | 13543 | {"type": "Polygon", "coordinates": [[[-117.63464, 33.44433], [-117.63368, 33.44513], [-117.63359, 33.44529], [-117.63357, 33.44527], [-117.63343, 33.44529], [-117.63333, 33.44533], [-117.63317, 33.44552], [-117.63307, 33.44557], [-117.63301, 33.44552], [-117.63294, 33.44537], [-117.63296, 33.44526], [-117.63278, 33.44448], [-117.63247, 33.44421], [-117.63228, 33.44418], [-117.63214, 33.44405], [-117.63214, 33.444], [-117.63222, 33.44385], [-117.63236, 33.44332], [-117.6324, 33.44296], [-117.63253, 33.44286], [-117.63261, 33.44289], [-117.63314, 33.4433], [-117.63313, 33.44335], [-117.63427, 33.4443], [-117.63438, 33.44434], [-117.63448, 33.44433], [-117.63456, 33.44428], [-117.63464, 33.44433]]]} | Open Access 1 | 48827 | Jim Johnson Memorial Sports Park | 33546 | 6132 | Marblehead Development Partners LLC 1045 | Private 7 | Home Owners Association 16 | Private 14 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/187/2783 | Orange 3 | 7.375 | Jim Johnson Memorial Sports Park | 0 | Local Recreation Area 3 | 4 | |
16813 | 16813 | 16812 | {"type": "MultiPolygon", "coordinates": [[[[-121.24935, 38.79757], [-121.24887, 38.7976], [-121.24888, 38.79736], [-121.24862, 38.79729], [-121.2486, 38.79701], [-121.24788, 38.79639], [-121.24756, 38.79629], [-121.24638, 38.79603], [-121.24591, 38.79611], [-121.24558, 38.79621], [-121.24526, 38.79664], [-121.24512, 38.79694], [-121.24485, 38.79709], [-121.24378, 38.7975], [-121.24094, 38.79876], [-121.24094, 38.79877], [-121.24112, 38.79902], [-121.24073, 38.79922], [-121.24054, 38.79896], [-121.23974, 38.79931], [-121.23958, 38.79911], [-121.23981, 38.7985], [-121.23945, 38.79817], [-121.2406, 38.79786], [-121.24375, 38.79649], [-121.2443, 38.79581], [-121.24429, 38.7958], [-121.2442, 38.7958], [-121.24484, 38.79531], [-121.24604, 38.79445], [-121.24636, 38.79473], [-121.24652, 38.79518], [-121.24729, 38.79541], [-121.2479, 38.79543], [-121.24805, 38.79534], [-121.24878, 38.79605], [-121.24909, 38.79654], [-121.24928, 38.79708], [-121.24934, 38.79735], [-121.24935, 38.79757]]], [[[-121.25255, 38.7998], [-121.25223, 38.80002], [-121.25251, 38.80029], [-121.25098, 38.80127], [-121.24815, 38.80405], [-121.24782, 38.80431], [-121.24743, 38.80455], [-121.24494, 38.8056], [-121.24452, 38.80574], [-121.24407, 38.80574], [-121.24396, 38.80605], [-121.24361, 38.80596], [-121.2433, 38.80581], [-121.24304, 38.80562], [-121.24284, 38.80538], [-121.24271, 38.80511], [-121.24237, 38.80408], [-121.24228, 38.80386], [-121.24216, 38.80366], [-121.242, 38.80347], [-121.24184, 38.80331], [-121.24168, 38.80319], [-121.24194, 38.80296], [-121.24086, 38.80233], [-121.24045, 38.80189], [-121.24021, 38.80132], [-121.24015, 38.8003], [-121.24006, 38.80006], [-121.24075, 38.79973], [-121.24057, 38.79946], [-121.24109, 38.79923], [-121.24126, 38.79947], [-121.24142, 38.79983], [-121.24149, 38.80031], [-121.24174, 38.80044], [-121.24236, 38.80036], [-121.24253, 38.80015], [-121.2423, 38.79946], [-121.2421, 38.79913], [-121.24418, 38.79821], [-121.24535, 38.79776], [-121.24594, 38.79761], [-121.24654, 38.79765], [-121.2474, 38.79783], [-121.24743, 38.79896], [-121.24579, 38.79935], [-121.24484, 38.79916], [-121.24397, 38.7995], [-121.244, 38.80063], [-121.24357, 38.80114], [-121.24342, 38.80191], [-121.24445, 38.80209], [-121.24565, 38.80187], [-121.24573, 38.80237], [-121.24541, 38.80249], [-121.24543, 38.80279], [-121.24583, 38.80285], [-121.2465, 38.80259], [-121.24734, 38.80186], [-121.24764, 38.80162], [-121.24906, 38.80072], [-121.24952, 38.80026], [-121.25005, 38.79988], [-121.2504, 38.79967], [-121.25064, 38.79948], [-121.25112, 38.799], [-121.25148, 38.79878], [-121.25255, 38.7998]]], [[[-121.26336, 38.7949], [-121.26216, 38.79573], [-121.26081, 38.79691], [-121.25822, 38.79824], [-121.25393, 38.79935], [-121.25344, 38.79967], [-121.25314, 38.79939], [-121.25282, 38.7996], [-121.25177, 38.7986], [-121.2521, 38.7984], [-121.25393, 38.79763], [-121.25471, 38.79763], [-121.25541, 38.7972], [-121.25571, 38.79678], [-121.25665, 38.79627], [-121.25694, 38.7964], [-121.25724, 38.79647], [-121.25756, 38.79649], [-121.25786, 38.79645], [-121.25816, 38.79633], [-121.25931, 38.79573], [-121.25953, 38.79557], [-121.26037, 38.79477], [-121.26072, 38.7945], [-121.26198, 38.79366], [-121.26336, 38.7949]]]]} | Open Access 1 | 49034 | Sunset Whitney Recreation Area | 33741 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | https://www.rocklin.ca.us/news/west-trails-sunset-whitney-rec-area-now-open | Placer 35 | 178.722 | Sunset Whitney Rec. Area | 2018 | Local Recreation Area 3 | 4 |
16251 | 16251 | 16250 | {"type": "Polygon", "coordinates": [[[-120.93077, 37.73589], [-120.92905, 37.73587], [-120.92904, 37.73514], [-120.93077, 37.73514], [-120.93077, 37.73589]]]} | Open Access 1 | 36543 | Community Center Park | 31854 | 1278 | Riverbank, City of 41 | City 2 | City Agency 2 | http://www.riverbank.org/Depts/Recreation/default.aspx | City 2 | 1278 | Riverbank, City of 40 | City 2 | City Agency 2 | https://www.riverbank.org/Facilities/Facility/Details/Community-Center-Veterans-Park-9 | Stanislaus 2 | 3.097 | Community Ctr. Park | 0 | Local Recreation Area 3 | 4 |
500 | 500 | 499 | {"type": "Polygon", "coordinates": [[[-117.1728, 32.71668], [-117.17278, 32.71676], [-117.17262, 32.71679], [-117.17261, 32.71695], [-117.1722, 32.71685], [-117.17129, 32.71683], [-117.17128, 32.71657], [-117.17223, 32.71657], [-117.17231, 32.71653], [-117.17235, 32.71589], [-117.17279, 32.71589], [-117.1728, 32.71668]]]} | Open Access 1 | 47486 | Lane Field Park | 31204 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/parks/lane-field-park.html | San Diego 4 | 1.887 | Lane Field Park | 0 | Local Recreation Area 3 | 4 |
7019 | 7019 | 7018 | {"type": "Polygon", "coordinates": [[[-118.28592, 33.71434], [-118.28588, 33.71469], [-118.28592, 33.71498], [-118.28564, 33.71556], [-118.28542, 33.71631], [-118.28546, 33.71662], [-118.28435, 33.7181], [-118.28417, 33.7184], [-118.28345, 33.71926], [-118.28338, 33.71977], [-118.28316, 33.72016], [-118.28318, 33.72028], [-118.28308, 33.72031], [-118.28345, 33.7209], [-118.28395, 33.72204], [-118.28411, 33.72244], [-118.28426, 33.72301], [-118.28445, 33.7239], [-118.28434, 33.72394], [-118.28389, 33.72397], [-118.28306, 33.72182], [-118.28152, 33.72222], [-118.28118, 33.72129], [-118.28269, 33.72088], [-118.28241, 33.72004], [-118.28248, 33.72002], [-118.28236, 33.71965], [-118.28222, 33.71969], [-118.28216, 33.71947], [-118.28226, 33.71943], [-118.28193, 33.71853], [-118.28185, 33.71854], [-118.28176, 33.71823], [-118.28044, 33.71852], [-118.28044, 33.7186], [-118.28016, 33.71866], [-118.27982, 33.71774], [-118.28155, 33.71727], [-118.28161, 33.71721], [-118.28173, 33.71692], [-118.28178, 33.71669], [-118.2815, 33.71617], [-118.28043, 33.71566], [-118.28029, 33.71561], [-118.2791, 33.71561], [-118.279, 33.71563], [-118.27841, 33.71586], [-118.27837, 33.71586], [-118.27833, 33.71583], [-118.27831, 33.71578], [-118.27832, 33.71575], [-118.2784, 33.7157], [-118.27901, 33.71552], [-118.27912, 33.7155], [-118.28029, 33.71548], [-118.28042, 33.71549], [-118.28159, 33.71607], [-118.2819, 33.71666], [-118.28264, 33.71686], [-118.28323, 33.71682], [-118.28341, 33.71662], [-118.28376, 33.71619], [-118.28391, 33.71596], [-118.28418, 33.71546], [-118.28439, 33.71495], [-118.28448, 33.71454], [-118.2845, 33.71434], [-118.28592, 33.71434]]]} | Open Access 1 | 5954 | Cabrillo Beach Marina and Recreation Complex | 29073 | 2384 | Port of Los Angeles 289 | Special District 4 | Port/Harbor District 15 | http://www.portoflosangeles.org/ | Special District 4 | 2384 | Port of Los Angeles 286 | Special District 4 | Port/Harbor District 14 | https://www.portoflosangeles.org | Los Angeles 6 | 45.403 | Cabrillo Beach Marina and Rec. Complex | 0 | Local Recreation Area 3 | 4 |
7593 | 7593 | 7592 | {"type": "Polygon", "coordinates": [[[-117.13563, 33.08017], [-117.12718, 33.0802], [-117.12711, 33.07295], [-117.1271, 33.06937], [-117.13529, 33.06938], [-117.13563, 33.08017]]]} | Open Access 1 | 7302 | Elfin Forest Recreational Reserve | 29214 | 2102 | Olivenhain Municipal Water District 871 | Special District 4 | Water District 13 | http://www.olivenhain.com/ | Special District 4 | 2102 | Olivenhain Municipal Water District 849 | Special District 4 | Water District 13 | https://www.olivenhain.com/elfin-forest-recreational-reserve | San Diego 4 | 230.522 | Elfin Forest Recreational Reserve | 0 | Local Recreation Area 3 | 4 |
7598 | 7598 | 7597 | {"type": "MultiPolygon", "coordinates": [[[[-117.15281, 33.07293], [-117.15266, 33.08035], [-117.14803, 33.08027], [-117.14401, 33.08032], [-117.13955, 33.08019], [-117.13956, 33.08391], [-117.13632, 33.08392], [-117.13629, 33.08152], [-117.13631, 33.08116], [-117.13631, 33.08018], [-117.13563, 33.08017], [-117.1354, 33.07289], [-117.15281, 33.07293]]], [[[-117.14671, 33.08662], [-117.14533, 33.0873], [-117.14509, 33.08735], [-117.14443, 33.08739], [-117.14422, 33.08742], [-117.1439, 33.08751], [-117.1439, 33.08753], [-117.14377, 33.08759], [-117.14364, 33.08761], [-117.14342, 33.08769], [-117.14244, 33.0881], [-117.14107, 33.08861], [-117.14063, 33.08872], [-117.13959, 33.08884], [-117.13957, 33.08443], [-117.14508, 33.08436], [-117.14671, 33.08662]]]]} | Open Access 1 | 7311 | Elfin Forest Recreational Reserve | 29214 | 2102 | Olivenhain Municipal Water District 871 | Special District 4 | Water District 13 | http://www.olivenhain.com/ | Special District 4 | 2102 | Olivenhain Municipal Water District 849 | Special District 4 | Water District 13 | https://www.olivenhain.com/elfin-forest-recreational-reserve | San Diego 4 | 413.656 | Elfin Forest Recreational Reserve | 0 | Local Recreation Area 3 | 4 |
14329 | 14329 | 14328 | {"type": "Polygon", "coordinates": [[[-122.38715, 41.43835], [-122.38702, 41.43886], [-122.38616, 41.43867], [-122.38561, 41.43852], [-122.38556, 41.43846], [-122.38554, 41.43836], [-122.38559, 41.43811], [-122.38715, 41.43835]]]} | Open Access 1 | 48856 | Weed Skate Park | 33576 | 2352 | Weed Recreation and Parks District 1109 | Special District 4 | Recreation/Parks District 4 | http://weedrec.org/?page_id=45 | Special District 4 | 2352 | Weed Recreation and Parks District 1063 | Special District 4 | Recreation/Parks District 4 | https://www.northwestskater.com/weed.html | Siskiyou 28 | 1.645 | Weed Skate Park | 0 | Local Recreation Area 3 | 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]);