units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where ACCESS_TYP = 2, DES_TP = 3, MNG_AG_TYP = 3 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME
MNG_AGENCY 8
MNG_AG_TYP 1
- County Agency · 20 ✖
DES_TP 1
- Local Recreation Area · 20 ✖
ACCESS_TYP 1
- Restricted Access · 20 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1070 | 1070 | 1069 | {"type": "Polygon", "coordinates": [[[-118.12169, 34.18412], [-118.12169, 34.18484], [-118.12109, 34.18492], [-118.12098, 34.18506], [-118.12057, 34.18506], [-118.12058, 34.18579], [-118.11862, 34.1858], [-118.11862, 34.18574], [-118.11762, 34.1841], [-118.11755, 34.18393], [-118.1175, 34.18371], [-118.11747, 34.18334], [-118.11742, 34.18334], [-118.11734, 34.18092], [-118.11782, 34.18092], [-118.11781, 34.18075], [-118.11767, 34.18048], [-118.11767, 34.18009], [-118.11806, 34.18009], [-118.1181, 34.1796], [-118.12141, 34.17957], [-118.12144, 34.18233], [-118.12147, 34.18248], [-118.12158, 34.18276], [-118.12162, 34.18294], [-118.12162, 34.18319], [-118.12154, 34.18358], [-118.12153, 34.18373], [-118.12155, 34.18386], [-118.12159, 34.18403], [-118.12162, 34.18407], [-118.12169, 34.18412]]]} | Restricted Access 2 | 6971 | Altadena Golf Course | 33022 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 57.739 | Altadena GC | 0 | Local Recreation Area 3 | 4 | |
1632 | 1632 | 1631 | {"type": "Polygon", "coordinates": [[[-118.00413, 33.90582], [-118.00266, 33.9058], [-118.00229, 33.90591], [-118.0005, 33.9071], [-118.00033, 33.90729], [-118.00022, 33.90737], [-118.00018, 33.90743], [-117.99885, 33.90986], [-117.99444, 33.90988], [-117.99438, 33.90984], [-117.99434, 33.90424], [-117.99435, 33.90374], [-117.99441, 33.90318], [-117.99449, 33.90284], [-117.99455, 33.9028], [-118.00302, 33.90275], [-118.00303, 33.9028], [-118.00324, 33.90281], [-118.00329, 33.90286], [-118.0033, 33.90333], [-118.00333, 33.90358], [-118.00337, 33.90378], [-118.00343, 33.90396], [-118.00405, 33.90551], [-118.00413, 33.90582]]]} | Restricted Access 2 | 45404 | La Mirada Golf Course | 33111 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/La_Mirada_Golf_Course | Los Angeles 6 | 131.179 | La Mirada GC | 0 | Local Recreation Area 3 | 4 |
2202 | 2202 | 2201 | {"type": "Polygon", "coordinates": [[[-118.27588, 33.85284], [-118.2733, 33.85587], [-118.27289, 33.855], [-118.27131, 33.85628], [-118.27096, 33.85622], [-118.27087, 33.85665], [-118.26832, 33.85666], [-118.26831, 33.85663], [-118.26621, 33.85662], [-118.26616, 33.85657], [-118.26515, 33.84858], [-118.26738, 33.84759], [-118.26891, 33.84731], [-118.26947, 33.84787], [-118.26991, 33.84825], [-118.26994, 33.84841], [-118.27012, 33.84858], [-118.2705, 33.84889], [-118.27057, 33.84885], [-118.2725, 33.85028], [-118.2731, 33.85068], [-118.27588, 33.85284]]]} | Restricted Access 2 | 6243 | Victoria Golf Course | 33008 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 167.229 | Victoria GC | 0 | Local Recreation Area 3 | 4 | |
4892 | 4892 | 4891 | {"type": "MultiPolygon", "coordinates": [[[[-118.15498, 33.83254], [-118.15491, 33.83579], [-118.15381, 33.83579], [-118.15367, 33.83568], [-118.15367, 33.83541], [-118.15336, 33.8354], [-118.15335, 33.83567], [-118.15358, 33.83568], [-118.15378, 33.83584], [-118.15123, 33.83584], [-118.15123, 33.83648], [-118.15303, 33.83854], [-118.15303, 33.83964], [-118.14813, 33.83963], [-118.14827, 33.83948], [-118.14837, 33.83933], [-118.14842, 33.83919], [-118.1485, 33.83886], [-118.15013, 33.83865], [-118.15122, 33.83875], [-118.15122, 33.8381], [-118.1496, 33.83658], [-118.14871, 33.83658], [-118.14676, 33.83715], [-118.14799, 33.83893], [-118.14829, 33.83889], [-118.14823, 33.83915], [-118.14819, 33.83926], [-118.14811, 33.83939], [-118.14799, 33.83951], [-118.14782, 33.83963], [-118.14742, 33.83963], [-118.14397, 33.83644], [-118.14405, 33.83636], [-118.14424, 33.83639], [-118.14429, 33.83617], [-118.14441, 33.83597], [-118.1462, 33.83409], [-118.14639, 33.83392], [-118.14756, 33.833], [-118.14768, 33.83283], [-118.14773, 33.8327], [-118.14775, 33.83255], [-118.14781, 33.83251], [-118.15469, 33.83253], [-118.1547, 33.83254], [-118.15498, 33.83254]]], [[[-118.15984, 33.8286], [-118.15959, 33.8286], [-118.15661, 33.83004], [-118.15469, 33.83035], [-118.15293, 33.83225], [-118.15, 33.83223], [-118.15104, 33.82949], [-118.15192, 33.82897], [-118.1541, 33.82898], [-118.15411, 33.82768], [-118.15982, 33.82769], [-118.15984, 33.8286]]]]} | Restricted Access 2 | 45718 | Lakewood Golf Course | 33113 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/Lakewood_Golf_Course | Los Angeles 6 | 176.286 | Lakewood GC | 0 | Local Recreation Area 3 | 4 |
5855 | 5855 | 5854 | {"type": "Polygon", "coordinates": [[[-118.87212, 34.31513], [-118.86601, 34.31512], [-118.86602, 34.31149], [-118.86145, 34.31148], [-118.85913, 34.30851], [-118.85892, 34.3046], [-118.85829, 34.30065], [-118.86599, 34.30066], [-118.86602, 34.30788], [-118.86833, 34.30788], [-118.87066, 34.30982], [-118.87207, 34.31343], [-118.87212, 34.31513]]]} | Restricted Access 2 | 224 | Rustic Canyon Golf Course | 32984 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 277.113 | Rustic Canyon GC | 0 | Local Recreation Area 3 | 4 | |
6002 | 6002 | 6001 | {"type": "Polygon", "coordinates": [[[-119.16058, 34.28227], [-119.1606, 34.28232], [-119.16056, 34.28237], [-119.1576, 34.28415], [-119.15733, 34.28384], [-119.15656, 34.2843], [-119.15656, 34.28431], [-119.15682, 34.28462], [-119.15395, 34.28635], [-119.15198, 34.28407], [-119.15254, 34.28373], [-119.15218, 34.28332], [-119.15296, 34.28284], [-119.15581, 34.28113], [-119.15737, 34.28293], [-119.16005, 34.28166], [-119.16058, 34.28227]]]} | Restricted Access 2 | 646 | Saticoy Regional Golf Course | 32989 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 48.962 | Saticoy Reg. GC | 0 | Local Recreation Area 3 | 4 | |
7496 | 7496 | 7495 | {"type": "Polygon", "coordinates": [[[-118.04347, 34.13092], [-118.04339, 34.13133], [-118.0426, 34.13196], [-118.04287, 34.13232], [-118.04246, 34.13254], [-118.04197, 34.13285], [-118.0416, 34.13314], [-118.04112, 34.13356], [-118.04211, 34.13249], [-118.04222, 34.13228], [-118.04225, 34.13218], [-118.04224, 34.13217], [-118.04223, 34.13217], [-118.03927, 34.13536], [-118.03909, 34.13561], [-118.03898, 34.13586], [-118.0383, 34.1366], [-118.03775, 34.13635], [-118.03681, 34.13613], [-118.03624, 34.13619], [-118.03571, 34.13614], [-118.0349, 34.13614], [-118.03405, 34.13627], [-118.03343, 34.13635], [-118.03292, 34.13634], [-118.03259, 34.13625], [-118.03227, 34.13601], [-118.03198, 34.13576], [-118.03151, 34.13565], [-118.03143, 34.1309], [-118.03583, 34.13086], [-118.04244, 34.13075], [-118.04347, 34.13092]], [[-118.04259, 34.13197], [-118.04251, 34.13188], [-118.04241, 34.13199], [-118.04249, 34.13208], [-118.04259, 34.13197]]]} | Restricted Access 2 | 7018 | Santa Anita Golf Course | 33023 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 130.957 | Santa Anita GC | 0 | Local Recreation Area 3 | 4 | |
8644 | 8644 | 8643 | {"type": "Polygon", "coordinates": [[[-121.62329, 36.69175], [-121.62139, 36.69476], [-121.62267, 36.69557], [-121.62305, 36.69583], [-121.62239, 36.69593], [-121.62224, 36.69599], [-121.62208, 36.69612], [-121.62156, 36.69684], [-121.62114, 36.69815], [-121.61922, 36.69881], [-121.61535, 36.69667], [-121.61887, 36.69401], [-121.61838, 36.69346], [-121.61979, 36.69213], [-121.62135, 36.69028], [-121.623, 36.69156], [-121.62329, 36.69175]]]} | Restricted Access 2 | 1466 | Twin Creeks Golf Course | 32997 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 76.277 | Twin Creeks GC | 0 | Local Recreation Area 3 | 4 | |
11132 | 11132 | 11131 | {"type": "MultiPolygon", "coordinates": [[[[-121.09148, 38.49227], [-121.09125, 38.49243], [-121.09091, 38.49263], [-121.09073, 38.49271], [-121.09048, 38.49267], [-121.09013, 38.49268], [-121.0895, 38.49277], [-121.08916, 38.49278], [-121.08856, 38.49271], [-121.08839, 38.49288], [-121.08806, 38.49299], [-121.08776, 38.49324], [-121.08758, 38.49346], [-121.08736, 38.49369], [-121.08706, 38.49389], [-121.08684, 38.49411], [-121.08668, 38.49447], [-121.08635, 38.49468], [-121.08587, 38.4948], [-121.08548, 38.49497], [-121.08494, 38.49507], [-121.08444, 38.49513], [-121.08401, 38.49522], [-121.08368, 38.4954], [-121.08321, 38.49533], [-121.08263, 38.4952], [-121.08218, 38.49516], [-121.08186, 38.49517], [-121.08155, 38.49514], [-121.08119, 38.49514], [-121.08085, 38.49518], [-121.08048, 38.49518], [-121.07954, 38.49521], [-121.07918, 38.4953], [-121.07885, 38.49527], [-121.07803, 38.49512], [-121.07721, 38.49518], [-121.07672, 38.49507], [-121.07643, 38.49489], [-121.07601, 38.49485], [-121.07561, 38.49479], [-121.07506, 38.49468], [-121.0745, 38.49467], [-121.07387, 38.49457], [-121.07313, 38.4944], [-121.07188, 38.49433], [-121.07136, 38.49445], [-121.0709, 38.49468], [-121.07057, 38.49491], [-121.07008, 38.49571], [-121.06978, 38.49606], [-121.06879, 38.4965], [-121.0684, 38.49662], [-121.06787, 38.4969], [-121.06772, 38.49747], [-121.06745, 38.49789], [-121.06741, 38.4964], [-121.0678, 38.49625], [-121.06829, 38.49619], [-121.0692, 38.4956], [-121.06938, 38.49529], [-121.06934, 38.49511], [-121.06944, 38.49477], [-121.06956, 38.4945], [-121.07004, 38.4941], [-121.07124, 38.49356], [-121.07312, 38.49317], [-121.07514, 38.49348], [-121.07693, 38.49402], [-121.08244, 38.49408], [-121.08245, 38.49418], [-121.08279, 38.49418], [-121.08281, 38.49409], [-121.083, 38.49409], [-121.08466, 38.49399], [-121.08601, 38.4936], [-121.08706, 38.49299], [-121.08713, 38.49306], [-121.08756, 38.49279], [-121.08806, 38.49236], [-121.08926, 38.49218], [-121.0898, 38.49205], [-121.09063, 38.49184], [-121.09106, 38.49171], [-121.09128, 38.49189], [-121.09127, 38.49191], [-121.09133, 38.49195], [-121.09148, 38.49227]]], [[[-121.11462, 38.48233], [-121.11316, 38.48204], [-121.10939, 38.48209], [-121.10861, 38.48241], [-121.10763, 38.483], [-121.10532, 38.48394], [-121.10435, 38.48511], [-121.10083, 38.48719], [-121.10067, 38.48782], [-121.09651, 38.49026], [-121.09674, 38.49053], [-121.09379, 38.49339], [-121.09281, 38.49263], [-121.09319, 38.49205], [-121.09333, 38.49171], [-121.09343, 38.49155], [-121.09393, 38.48993], [-121.09485, 38.48922], [-121.09593, 38.48922], [-121.09595, 38.48641], [-121.09858, 38.48505], [-121.09983, 38.48505], [-121.09985, 38.48438], [-121.10456, 38.4818], [-121.11192, 38.48073], [-121.1122, 38.4807], [-121.1146, 38.48154], [-121.11462, 38.48233]]]]} | Restricted Access 2 | 21421 | Cosumnes River Parkway | 17677 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 188.683 | Cosumnes River Parkway | 0 | Local Recreation Area 3 | 4 | |
11398 | 11398 | 11397 | {"type": "MultiPolygon", "coordinates": [[[[-121.24893, 38.67172], [-121.2489, 38.67173], [-121.24889, 38.67164], [-121.24884, 38.67156], [-121.2486, 38.67133], [-121.24893, 38.67133], [-121.24893, 38.67172]]], [[[-121.25125, 38.67334], [-121.25049, 38.67337], [-121.25043, 38.67336], [-121.24934, 38.67255], [-121.24894, 38.67232], [-121.24893, 38.67184], [-121.24905, 38.67183], [-121.24903, 38.67201], [-121.24906, 38.67206], [-121.24937, 38.67222], [-121.24962, 38.67238], [-121.25057, 38.67308], [-121.25063, 38.67309], [-121.25112, 38.67306], [-121.25117, 38.67304], [-121.25125, 38.67298], [-121.25125, 38.67334]]]]} | Restricted Access 2 | 22206 | Sunrise Recreation/parks District | 26038 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.065 | Sunrise Rec./parks District | 0 | Local Recreation Area 3 | 4 | |
12987 | 12987 | 12986 | {"type": "Polygon", "coordinates": [[[-117.95443, 33.73019], [-117.95436, 33.73026], [-117.95426, 33.73026], [-117.94777, 33.73043], [-117.94169, 33.73062], [-117.9416, 33.72608], [-117.94053, 33.72571], [-117.94052, 33.72461], [-117.94155, 33.72372], [-117.94153, 33.72203], [-117.94128, 33.72199], [-117.94098, 33.72168], [-117.94094, 33.72129], [-117.9419, 33.71991], [-117.94347, 33.71884], [-117.94402, 33.71875], [-117.94344, 33.71734], [-117.94412, 33.71715], [-117.94413, 33.71651], [-117.95425, 33.71643], [-117.95433, 33.71648], [-117.95437, 33.72142], [-117.95382, 33.72148], [-117.95241, 33.72317], [-117.95049, 33.72413], [-117.94943, 33.72413], [-117.94859, 33.72456], [-117.94665, 33.72493], [-117.94676, 33.72783], [-117.94853, 33.72841], [-117.94947, 33.7276], [-117.95442, 33.72763], [-117.95443, 33.73019]]]} | Restricted Access 2 | 30459 | Mile Square Golf Course | 33098 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 362.625 | Mile Square GC | 0 | Local Recreation Area 3 | 4 | |
15663 | 15663 | 15662 | {"type": "Polygon", "coordinates": [[[-118.40577, 33.76235], [-118.40543, 33.76277], [-118.40476, 33.76288], [-118.40115, 33.76183], [-118.40043, 33.76139], [-118.39873, 33.75821], [-118.39882, 33.75812], [-118.3989, 33.758], [-118.39899, 33.7578], [-118.39901, 33.75768], [-118.39901, 33.75754], [-118.39898, 33.75742], [-118.39888, 33.75722], [-118.39883, 33.75706], [-118.39879, 33.75691], [-118.39878, 33.75667], [-118.39884, 33.75634], [-118.39895, 33.75609], [-118.39942, 33.7554], [-118.39929, 33.75534], [-118.3988, 33.75604], [-118.39865, 33.75639], [-118.39861, 33.75662], [-118.39862, 33.7568], [-118.39833, 33.75685], [-118.3983, 33.75674], [-118.39837, 33.75604], [-118.39856, 33.7544], [-118.40003, 33.75192], [-118.39994, 33.75125], [-118.39987, 33.75101], [-118.39978, 33.75086], [-118.39962, 33.75068], [-118.39956, 33.75063], [-118.3993, 33.75049], [-118.39909, 33.75043], [-118.3989, 33.75041], [-118.39871, 33.75041], [-118.39843, 33.75047], [-118.3983, 33.75051], [-118.39609, 33.75167], [-118.3959, 33.75181], [-118.3958, 33.75191], [-118.39569, 33.75208], [-118.3957, 33.75216], [-118.3956, 33.75209], [-118.39539, 33.752], [-118.39546, 33.75197], [-118.39555, 33.75184], [-118.39507, 33.75161], [-118.39476, 33.7508], [-118.39504, 33.75018], [-118.39573, 33.74968], [-118.39552, 33.74935], [-118.39672, 33.74876], [-118.39875, 33.74843], [-118.39979, 33.74782], [-118.40117, 33.74652], [-118.40172, 33.74643], [-118.40231, 33.74691], [-118.40191, 33.74915], [-118.403, 33.75085], [-118.40334, 33.75309], [-118.404, 33.75374], [-118.40391, 33.75506], [-118.40227, 33.75588], [-118.40141, 33.75658], [-118.40141, 33.75804], [-118.40296, 33.76003], [-118.40533, 33.76169], [-118.40577, 33.76235]]]} | Restricted Access 2 | 5866 | Los Verdes Golf Course | 33003 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 162.838 | Los Verdes GC | 0 | Local Recreation Area 3 | 4 | |
15666 | 15666 | 15665 | {"type": "Polygon", "coordinates": [[[-118.31767, 33.91768], [-118.31766, 33.92154], [-118.31756, 33.92157], [-118.31241, 33.9237], [-118.3092, 33.9237], [-118.30923, 33.91674], [-118.30926, 33.91673], [-118.30926, 33.91662], [-118.30931, 33.91658], [-118.31432, 33.91659], [-118.31444, 33.91781], [-118.3146, 33.91784], [-118.31459, 33.91818], [-118.31461, 33.91853], [-118.31533, 33.91853], [-118.31681, 33.91768], [-118.31767, 33.91768]]]} | Restricted Access 2 | 6207 | Chester L Washington Golf Course | 33007 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 125.616 | Chester L Washington GC | 0 | Local Recreation Area 3 | 4 | |
15700 | 15700 | 15699 | {"type": "MultiPolygon", "coordinates": [[[[-121.39794, 38.718], [-121.39794, 38.71803], [-121.39732, 38.718], [-121.39658, 38.71802], [-121.39577, 38.71793], [-121.39554, 38.71792], [-121.39551, 38.71787], [-121.39552, 38.71785], [-121.39555, 38.71784], [-121.39583, 38.71783], [-121.39606, 38.71779], [-121.39641, 38.71779], [-121.39656, 38.7178], [-121.39671, 38.71785], [-121.39676, 38.7179], [-121.39686, 38.71795], [-121.39728, 38.71796], [-121.39737, 38.71794], [-121.39749, 38.71784], [-121.39758, 38.71779], [-121.3976, 38.71781], [-121.39758, 38.71783], [-121.39748, 38.71789], [-121.39744, 38.71795], [-121.39783, 38.71794], [-121.39783, 38.71791], [-121.39779, 38.71786], [-121.39778, 38.71783], [-121.39781, 38.71782], [-121.39785, 38.71784], [-121.39789, 38.71788], [-121.39794, 38.718]]], [[[-121.39618, 38.71991], [-121.39616, 38.72016], [-121.39605, 38.72016], [-121.39597, 38.72018], [-121.39591, 38.72022], [-121.39584, 38.72035], [-121.3958, 38.72036], [-121.39565, 38.72036], [-121.39555, 38.7204], [-121.39556, 38.72018], [-121.39566, 38.72015], [-121.39571, 38.72], [-121.39583, 38.71988], [-121.39595, 38.71984], [-121.39608, 38.71986], [-121.39618, 38.71991]]], [[[-121.39818, 38.72268], [-121.39814, 38.72274], [-121.39806, 38.72275], [-121.39799, 38.72272], [-121.39741, 38.72221], [-121.39721, 38.72206], [-121.39692, 38.72206], [-121.39681, 38.72208], [-121.39667, 38.72208], [-121.39636, 38.72209], [-121.3963, 38.72213], [-121.39624, 38.72223], [-121.39618, 38.72225], [-121.39614, 38.72225], [-121.39614, 38.72214], [-121.39627, 38.72204], [-121.39642, 38.722], [-121.39678, 38.72199], [-121.397, 38.72193], [-121.39712, 38.72193], [-121.39716, 38.7219], [-121.39732, 38.72192], [-121.39736, 38.72188], [-121.39735, 38.7218], [-121.3974, 38.7218], [-121.39766, 38.72198], [-121.39765, 38.72205], [-121.39772, 38.72225], [-121.39781, 38.72236], [-121.39793, 38.72246], [-121.39806, 38.72253], [-121.39815, 38.72262], [-121.39818, 38.72268]]], [[[-121.39707, 38.71962], [-121.39706, 38.71979], [-121.39699, 38.71992], [-121.39686, 38.72003], [-121.3967, 38.7201], [-121.39652, 38.72011], [-121.39623, 38.7201], [-121.39627, 38.71989], [-121.39643, 38.71978], [-121.39654, 38.71961], [-121.39661, 38.71955], [-121.39665, 38.71954], [-121.39669, 38.71956], [-121.3967, 38.71969], [-121.39676, 38.71971], [-121.39683, 38.71966], [-121.39686, 38.71961], [-121.3969, 38.7196], [-121.39707, 38.71962]]], [[[-121.39714, 38.72282], [-121.39707, 38.72291], [-121.39709, 38.72297], [-121.39705, 38.72298], [-121.39697, 38.72297], [-121.39696, 38.72294], [-121.39698, 38.72291], [-121.39703, 38.72287], [-121.39705, 38.7228], [-121.39711, 38.72278], [-121.39714, 38.72282]]], [[[-121.39748, 38.71779], [-121.39746, 38.71783], [-121.39735, 38.71791], [-121.39728, 38.71789], [-121.39722, 38.7178], [-121.3973, 38.71778], [-121.39748, 38.71779]]], [[[-121.39777, 38.72167], [-121.39772, 38.72182], [-121.39774, 38.72194], [-121.39773, 38.72196], [-121.39751, 38.72182], [-121.39744, 38.72169], [-121.39747, 38.72165], [-121.39749, 38.72157], [-121.39747, 38.72152], [-121.39743, 38.72147], [-121.39759, 38.72147], [-121.39758, 38.72153], [-121.39763, 38.72157], [-121.39766, 38.72157], [-121.3977, 38.7215], [-121.39772, 38.72151], [-121.39777, 38.72167]]], [[[-121.39838, 38.7181], [-121.39828, 38.71814], [-121.39808, 38.71811], [-121.39802, 38.71806], [-121.39799, 38.71795], [-121.39803, 38.71791], [-121.3982, 38.71785], [-121.39827, 38.71781], [-121.39836, 38.71786], [-121.39833, 38.71791], [-121.39838, 38.7181]], [[-121.39827, 38.71793], [-121.39823, 38.71793], [-121.3981, 38.71799], [-121.39807, 38.71801], [-121.39808, 38.71804], [-121.39814, 38.71808], [-121.39829, 38.71808], [-121.3983, 38.71806], [-121.3983, 38.71802], [-121.39827, 38.71793]]], [[[-121.39856, 38.71876], [-121.39851, 38.71878], [-121.39844, 38.71876], [-121.39837, 38.71876], [-121.39836, 38.71877], [-121.39837, 38.71878], [-121.39847, 38.71879], [-121.39849, 38.7188], [-121.39849, 38.71882], [-121.39834, 38.71882], [-121.39826, 38.71884], [-121.39821, 38.71882], [-121.39814, 38.71876], [-121.39799, 38.71874], [-121.39799, 38.71871], [-121.39807, 38.71868], [-121.39808, 38.71864], [-121.39807, 38.71857], [-121.3981, 38.71854], [-121.39828, 38.71856], [-121.39835, 38.71854], [-121.39841, 38.71868], [-121.39856, 38.71873], [-121.39856, 38.71876]]], [[[-121.39831, 38.71842], [-121.3983, 38.71845], [-121.39827, 38.71847], [-121.39812, 38.71846], [-121.39806, 38.71841], [-121.39809, 38.71835], [-121.39812, 38.71833], [-121.39817, 38.71832], [-121.39825, 38.71834], [-121.39831, 38.71842]]], [[[-121.39929, 38.71634], [-121.3993, 38.7164], [-121.39929, 38.7165], [-121.39912, 38.71679], [-121.39902, 38.7169], [-121.39895, 38.71708], [-121.39891, 38.71713], [-121.39875, 38.71725], [-121.3987, 38.7173], [-121.39851, 38.71762], [-121.3985, 38.71769], [-121.39844, 38.71774], [-121.3984, 38.7178], [-121.39832, 38.71779], [-121.39832, 38.71776], [-121.3984, 38.7176], [-121.39865, 38.71724], [-121.39869, 38.71712], [-121.39881, 38.71706], [-121.39899, 38.71683], [-121.39904, 38.7168], [-121.39918, 38.71658], [-121.39922, 38.71649], [-121.39924, 38.71633], [-121.39929, 38.71634]]], [[[-121.39855, 38.71891], [-121.39854, 38.71895], [-121.39849, 38.71897], [-121.39844, 38.71895], [-121.39837, 38.71895], [-121.39834, 38.71892], [-121.39836, 38.71889], [-121.3985, 38.71887], [-121.39852, 38.71887], [-121.39855, 38.71891]]], [[[-121.399, 38.71916], [-121.39899, 38.7193], [-121.39893, 38.71943], [-121.39888, 38.71974], [-121.39877, 38.72018], [-121.39878, 38.72047], [-121.39876, 38.72053], [-121.39867, 38.72068], [-121.39863, 38.72089], [-121.39857, 38.72103], [-121.39855, 38.72112], [-121.3985, 38.72116], [-121.39845, 38.72114], [-121.39842, 38.72111], [-121.39842, 38.72097], [-121.39847, 38.72082], [-121.3985, 38.72065], [-121.39847, 38.7206], [-121.39853, 38.72028], [-121.39864, 38.71992], [-121.39871, 38.71981], [-121.3988, 38.71951], [-121.39879, 38.71916], [-121.39885, 38.71911], [-121.39894, 38.71911], [-121.399, 38.71916]]], [[[-121.40081, 38.71464], [-121.40058, 38.71479], [-121.40051, 38.71481], [-121.40037, 38.71487], [-121.40032, 38.71491], [-121.40027, 38.71504], [-121.4002, 38.71514], [-121.39991, 38.71531], [-121.3999, 38.71535], [-121.40001, 38.71548], [-121.39996, 38.71553], [-121.39964, 38.71561], [-121.39948, 38.71568], [-121.39943, 38.71572], [-121.39939, 38.71579], [-121.39938, 38.71583], [-121.39939, 38.71588], [-121.39952, 38.71594], [-121.39954, 38.71599], [-121.39951, 38.71607], [-121.39939, 38.71624], [-121.39933, 38.71628], [-121.39928, 38.71625], [-121.39927, 38.71623], [-121.39943, 38.71603], [-121.3994, 38.71598], [-121.39927, 38.71596], [-121.39924, 38.71594], [-121.39922, 38.7159], [-121.39923, 38.7158], [-121.39939, 38.71563], [-121.3995, 38.71556], [-121.39981, 38.7155], [-121.39985, 38.71546], [-121.39972, 38.71525], [-121.39962, 38.71525], [-121.39965, 38.71522], [-121.3997, 38.71521], [-121.39969, 38.71515], [-121.39971, 38.71513], [-121.39977, 38.71509], [-121.40009, 38.71507], [-121.40012, 38.71504], [-121.40018, 38.7149], [-121.40026, 38.71479], [-121.40037, 38.71472], [-121.40055, 38.71466], [-121.40071, 38.71457], [-121.4008, 38.71462], [-121.40081, 38.71464]]], [[[-121.40096, 38.71443], [-121.4009, 38.71456], [-121.40083, 38.71459], [-121.40079, 38.71456], [-121.40079, 38.71453], [-121.40085, 38.71449], [-121.40086, 38.71443], [-121.40096, 38.71443]]]]} | Restricted Access 2 | 21434 | Antelope Greens Golf Course | 28301 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 5.742 | Antelope Greens GC | 0 | Local Recreation Area 3 | 4 | |
15708 | 15708 | 15707 | {"type": "Polygon", "coordinates": [[[-119.91096, 36.84512], [-119.90786, 36.84617], [-119.90717, 36.84638], [-119.90647, 36.84658], [-119.90541, 36.84683], [-119.90469, 36.84697], [-119.90396, 36.8471], [-119.90287, 36.84725], [-119.90247, 36.84764], [-119.89722, 36.84425], [-119.90643, 36.84421], [-119.90626, 36.84057], [-119.90871, 36.84057], [-119.91065, 36.84027], [-119.91086, 36.84418], [-119.91096, 36.84418], [-119.91096, 36.84512]]]} | Restricted Access 2 | 25955 | Riverside Municipal Golf Course | 33087 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 107.589 | Riverside Municipal GC | 0 | Local Recreation Area 3 | 4 | |
15718 | 15718 | 15717 | {"type": "Polygon", "coordinates": [[[-118.86048, 35.43724], [-118.86016, 35.4381], [-118.86002, 35.43895], [-118.85983, 35.4394], [-118.8594, 35.44002], [-118.85729, 35.4433], [-118.85404, 35.44375], [-118.85191, 35.44323], [-118.85136, 35.44191], [-118.85208, 35.44189], [-118.85209, 35.44188], [-118.85187, 35.44165], [-118.85179, 35.44152], [-118.8517, 35.44143], [-118.85151, 35.44114], [-118.85136, 35.4408], [-118.85127, 35.44037], [-118.85124, 35.4397], [-118.85125, 35.43952], [-118.85142, 35.43847], [-118.85168, 35.4376], [-118.85179, 35.43699], [-118.85188, 35.43672], [-118.85194, 35.43629], [-118.85201, 35.43606], [-118.85205, 35.43585], [-118.85218, 35.43553], [-118.85249, 35.43501], [-118.85257, 35.43462], [-118.85274, 35.43427], [-118.85284, 35.43411], [-118.85288, 35.4338], [-118.85293, 35.43364], [-118.85293, 35.4334], [-118.853, 35.43324], [-118.85845, 35.4332], [-118.85874, 35.43316], [-118.85964, 35.43288], [-118.86022, 35.43526], [-118.86031, 35.43629], [-118.86048, 35.43724]]]} | Restricted Access 2 | 44512 | Kern River Golf Course | 33105 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 196.033 | Kern River GC | 0 | Local Recreation Area 3 | 4 | |
15719 | 15719 | 15718 | {"type": "Polygon", "coordinates": [[[-118.34366, 33.88545], [-118.34013, 33.88558], [-118.34029, 33.88725], [-118.33518, 33.88725], [-118.33518, 33.88623], [-118.33512, 33.88577], [-118.33502, 33.88542], [-118.33485, 33.88504], [-118.33464, 33.88473], [-118.33435, 33.88438], [-118.33447, 33.88429], [-118.33398, 33.88376], [-118.33384, 33.88384], [-118.33158, 33.88141], [-118.34006, 33.87868], [-118.34007, 33.87869], [-118.3403, 33.87861], [-118.3403, 33.8786], [-118.34353, 33.87755], [-118.34365, 33.87762], [-118.34366, 33.88545]]]} | Restricted Access 2 | 44523 | Alondra Golf Course | 33106 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 187.746 | Alondra GC | 0 | Local Recreation Area 3 | 4 | |
16433 | 16433 | 16432 | {"type": "Polygon", "coordinates": [[[-120.74154, 35.3331], [-120.73974, 35.33628], [-120.73643, 35.3387], [-120.73575, 35.33844], [-120.73517, 35.33868], [-120.73285, 35.3378], [-120.72967, 35.33978], [-120.72435, 35.34033], [-120.72421, 35.34083], [-120.72439, 35.34155], [-120.72495, 35.34214], [-120.72174, 35.3459], [-120.71513, 35.35322], [-120.71224, 35.35091], [-120.72459, 35.32556], [-120.72558, 35.3253], [-120.72633, 35.32599], [-120.72988, 35.32905], [-120.73035, 35.3294], [-120.73084, 35.32971], [-120.73136, 35.33], [-120.73191, 35.33026], [-120.73247, 35.33048], [-120.73305, 35.33067], [-120.73498, 35.33122], [-120.7373, 35.33191], [-120.73941, 35.33243], [-120.74154, 35.3331]]]} | Restricted Access 2 | 14529 | El Chorro Regional Park and Dairy Creek Golf Course | 33039 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 684.123 | El Chorro RP and Dairy Creek GC | 0 | Local Recreation Area 3 | 4 | |
16927 | 16927 | 16926 | {"type": "MultiPolygon", "coordinates": [[[[-120.6486, 35.47827], [-120.64691, 35.47993], [-120.64474, 35.48211], [-120.64314, 35.47842], [-120.64254, 35.47751], [-120.64174, 35.47671], [-120.64078, 35.47603], [-120.63969, 35.47551], [-120.63961, 35.47559], [-120.63571, 35.47391], [-120.63519, 35.47363], [-120.63473, 35.47327], [-120.63438, 35.47285], [-120.63412, 35.47237], [-120.64037, 35.46871], [-120.6405, 35.46878], [-120.64087, 35.4689], [-120.6417, 35.46914], [-120.64319, 35.46938], [-120.64348, 35.4694], [-120.64491, 35.46934], [-120.64506, 35.46931], [-120.64513, 35.47088], [-120.64566, 35.47188], [-120.64588, 35.47365], [-120.6459, 35.47365], [-120.647, 35.47288], [-120.64704, 35.47299], [-120.64715, 35.47313], [-120.64723, 35.47319], [-120.64742, 35.47326], [-120.64749, 35.47332], [-120.64761, 35.47347], [-120.64684, 35.47375], [-120.64621, 35.47385], [-120.64521, 35.47416], [-120.64491, 35.47415], [-120.6449, 35.47417], [-120.64525, 35.47453], [-120.6486, 35.47827]]], [[[-120.64709, 35.47263], [-120.64603, 35.47336], [-120.64582, 35.47184], [-120.64531, 35.47085], [-120.64525, 35.46978], [-120.64704, 35.46978], [-120.64709, 35.47263]]], [[[-120.64864, 35.47105], [-120.64865, 35.47288], [-120.64863, 35.47292], [-120.64856, 35.47299], [-120.64843, 35.47307], [-120.64824, 35.47314], [-120.64786, 35.47317], [-120.64769, 35.4732], [-120.6475, 35.47317], [-120.64741, 35.47312], [-120.64725, 35.473], [-120.6472, 35.47292], [-120.64718, 35.47285], [-120.64718, 35.47278], [-120.6472, 35.47274], [-120.64728, 35.47267], [-120.64717, 35.47257], [-120.64713, 35.47259], [-120.64711, 35.47107], [-120.64864, 35.47105]]]]} | Restricted Access 2 | 48426 | Chalk Mountain Golf Course | 33050 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 227.705 | Chalk Mtn. GC | 0 | Local Recreation Area 3 | 4 | |
16928 | 16928 | 16927 | {"type": "Polygon", "coordinates": [[[-117.78685, 34.08806], [-117.78682, 34.08835], [-117.78544, 34.08847], [-117.78504, 34.08832], [-117.78493, 34.08852], [-117.78422, 34.08859], [-117.78404, 34.08903], [-117.78041, 34.08809], [-117.78037, 34.08814], [-117.77867, 34.08717], [-117.77694, 34.08623], [-117.77698, 34.0862], [-117.77697, 34.08618], [-117.77522, 34.08526], [-117.77486, 34.08403], [-117.77477, 34.08386], [-117.77462, 34.08372], [-117.77291, 34.08262], [-117.77288, 34.08258], [-117.77288, 34.08254], [-117.77302, 34.08229], [-117.77324, 34.08205], [-117.77352, 34.08184], [-117.77384, 34.08168], [-117.77419, 34.08158], [-117.77412, 34.08161], [-117.77412, 34.08163], [-117.77559, 34.08135], [-117.77669, 34.08111], [-117.77718, 34.08098], [-117.77767, 34.08079], [-117.77822, 34.08051], [-117.77878, 34.08014], [-117.77903, 34.07993], [-117.77937, 34.07959], [-117.77961, 34.07928], [-117.77973, 34.07925], [-117.7799, 34.07934], [-117.78382, 34.08108], [-117.78097, 34.08373], [-117.78204, 34.08539], [-117.78408, 34.0849], [-117.78541, 34.08509], [-117.78685, 34.08806]]]} | Restricted Access 2 | 46285 | Mountain Meadows Golf Course | 33118 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/Mountain_Meadows_Golf_Course | Los Angeles 6 | 165.184 | Mtn. Meadows GC | 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]);