units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
63 rows where ACCESS_TYP = 2 and AGNCY_TYP = 3 sorted by COUNTY
This data as json, copyable, CSV (advanced)
DES_TP 17
- Local Recreation Area 18
- Local Conservation Area 6
- Local Other or Unknown 5
- Local Park 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 13
- Sacramento, County of 23
- Los Angeles, County of 5
- Los Angeles - Department of Parks and Recreation, County of 4
- Ventura, County of 2
- Monterey, County of 1
- Tulare, County of 1
- Placer, County of 1
- Torrance, City of 1
- Fresno, County of 1
- Kern, County of 1
- Humboldt, County of 1
- National Audubon Society 1
- Shasta, County of 1
MNG_AG_TYP 4
ACCESS_TYP 1
- Restricted Access · 43 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7384 | 7384 | 7383 | {"type": "MultiPolygon", "coordinates": [[[[-117.75565, 34.14631], [-117.75553, 34.14714], [-117.75483, 34.1482], [-117.75272, 34.15092], [-117.75047, 34.15094], [-117.75081, 34.15065], [-117.75101, 34.15053], [-117.75273, 34.14962], [-117.75307, 34.1494], [-117.75341, 34.14911], [-117.7536, 34.14891], [-117.75565, 34.14631]]], [[[-117.75567, 34.14565], [-117.75562, 34.14593], [-117.75555, 34.14608], [-117.75543, 34.1463], [-117.75346, 34.14879], [-117.75329, 34.14898], [-117.75306, 34.14919], [-117.75271, 34.14943], [-117.75105, 34.1503], [-117.75068, 34.15053], [-117.75049, 34.15067], [-117.75008, 34.15106], [-117.74901, 34.1523], [-117.74894, 34.15235], [-117.74876, 34.15247], [-117.74856, 34.15255], [-117.74841, 34.1526], [-117.74818, 34.15264], [-117.74703, 34.15265], [-117.74681, 34.15262], [-117.74662, 34.15256], [-117.74658, 34.15137], [-117.74647, 34.14969], [-117.74586, 34.14597], [-117.75013, 34.14351], [-117.75014, 34.14318], [-117.75037, 34.14309], [-117.75042, 34.14294], [-117.75065, 34.14274], [-117.7508, 34.14274], [-117.75097, 34.14262], [-117.75147, 34.14253], [-117.75189, 34.14258], [-117.75194, 34.14258], [-117.75204, 34.14273], [-117.7528, 34.14244], [-117.75279, 34.14352], [-117.75422, 34.14353], [-117.75379, 34.14549], [-117.75567, 34.14565]]], [[[-117.75033, 34.15136], [-117.74915, 34.15243], [-117.74893, 34.15258], [-117.74874, 34.15267], [-117.74861, 34.15271], [-117.74889, 34.1526], [-117.74919, 34.15238], [-117.75024, 34.15115], [-117.75033, 34.15107], [-117.75033, 34.15136]]]]} | Restricted Access 2 | 6781 | Marshall Canyon Golf Course | 32492 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 157.54 | Marshall Canyon 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 | |
15382 | 15382 | 15381 | {"type": "Polygon", "coordinates": [[[-118.34245, 33.8418], [-118.34022, 33.84182], [-118.3402, 33.84072], [-118.34244, 33.8407], [-118.34245, 33.8418]]]} | Restricted Access 2 | 46597 | Toyota Sports Complex | 29898 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/27330.htm | Los Angeles 6 | 6.221 | Toyota Sports Complex | 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 | |
15668 | 15668 | 15667 | {"type": "MultiPolygon", "coordinates": [[[[-118.0811, 34.16216], [-118.08104, 34.16259], [-118.08093, 34.16271], [-118.08087, 34.16287], [-118.08084, 34.16316], [-118.08097, 34.16318], [-118.08058, 34.16641], [-118.08051, 34.16641], [-118.0805, 34.16649], [-118.0805, 34.16684], [-118.08044, 34.16691], [-118.0803, 34.16711], [-118.08014, 34.16749], [-118.08008, 34.16794], [-118.08006, 34.16839], [-118.07996, 34.16874], [-118.07985, 34.16905], [-118.07963, 34.16951], [-118.07945, 34.1698], [-118.07912, 34.17028], [-118.07902, 34.17045], [-118.07896, 34.17062], [-118.07904, 34.17066], [-118.07896, 34.17081], [-118.07893, 34.17095], [-118.07897, 34.17142], [-118.07725, 34.17059], [-118.07677, 34.17044], [-118.07725, 34.1699], [-118.07797, 34.16832], [-118.0781, 34.16829], [-118.07808, 34.16819], [-118.07808, 34.16794], [-118.07801, 34.16776], [-118.07794, 34.16767], [-118.07787, 34.16761], [-118.07781, 34.16756], [-118.07767, 34.1675], [-118.07801, 34.1668], [-118.07807, 34.16683], [-118.0782, 34.16656], [-118.07814, 34.16654], [-118.07852, 34.16519], [-118.07867, 34.16438], [-118.07856, 34.16431], [-118.07863, 34.16427], [-118.07863, 34.16426], [-118.07839, 34.16409], [-118.07851, 34.16358], [-118.07786, 34.16347], [-118.07837, 34.1619], [-118.07982, 34.16188], [-118.07968, 34.16205], [-118.07962, 34.16215], [-118.07954, 34.16241], [-118.07955, 34.16242], [-118.07972, 34.16239], [-118.07977, 34.16221], [-118.07985, 34.16208], [-118.0799, 34.16202], [-118.08007, 34.16188], [-118.08086, 34.16187], [-118.08089, 34.16189], [-118.08089, 34.16192], [-118.08086, 34.16215], [-118.08107, 34.16211], [-118.0811, 34.16216]]], [[[-118.08637, 34.16367], [-118.08296, 34.16371], [-118.08264, 34.16329], [-118.08239, 34.16307], [-118.0822, 34.16294], [-118.08178, 34.1625], [-118.08176, 34.1625], [-118.08174, 34.16273], [-118.08153, 34.16267], [-118.08143, 34.16259], [-118.08137, 34.16259], [-118.0813, 34.16263], [-118.08122, 34.1626], [-118.0812, 34.16255], [-118.08128, 34.16189], [-118.08133, 34.16186], [-118.08539, 34.16181], [-118.08539, 34.16263], [-118.08619, 34.16263], [-118.08637, 34.16367]]]]} | Restricted Access 2 | 6972 | Eaton Canyon Golf Course | 32483 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 72.049 | Eaton Canyon GC | 0 | Local Recreation Area 3 | 4 | |
15670 | 15670 | 15669 | {"type": "MultiPolygon", "coordinates": [[[[-117.82298, 34.00931], [-117.82283, 34.00935], [-117.82285, 34.00942], [-117.82262, 34.00997], [-117.82239, 34.0103], [-117.8221, 34.01066], [-117.82141, 34.01145], [-117.82045, 34.01247], [-117.81939, 34.01369], [-117.81895, 34.01423], [-117.81792, 34.01559], [-117.81716, 34.0165], [-117.81428, 34.01933], [-117.81308, 34.01781], [-117.81286, 34.0177], [-117.81479, 34.01516], [-117.81665, 34.01383], [-117.81651, 34.01257], [-117.81514, 34.01064], [-117.81561, 34.01027], [-117.81631, 34.00983], [-117.82166, 34.00683], [-117.82172, 34.00683], [-117.82176, 34.00685], [-117.82194, 34.0071], [-117.82233, 34.00774], [-117.82252, 34.00813], [-117.82274, 34.00866], [-117.82298, 34.00931]]], [[[-117.82998, 34.00371], [-117.82917, 34.00439], [-117.82774, 34.00547], [-117.82702, 34.00603], [-117.82699, 34.00606], [-117.82701, 34.00608], [-117.82489, 34.00787], [-117.82467, 34.00809], [-117.82428, 34.00843], [-117.82418, 34.00849], [-117.82414, 34.00859], [-117.82372, 34.00894], [-117.82358, 34.00893], [-117.82338, 34.00909], [-117.82333, 34.00903], [-117.82323, 34.0089], [-117.82265, 34.00767], [-117.82228, 34.00704], [-117.82203, 34.00671], [-117.82201, 34.00664], [-117.82205, 34.00659], [-117.82244, 34.00638], [-117.82264, 34.00625], [-117.82287, 34.00606], [-117.82311, 34.00581], [-117.82333, 34.00548], [-117.82391, 34.0044], [-117.82417, 34.00405], [-117.82451, 34.00371], [-117.82484, 34.00346], [-117.825, 34.00336], [-117.82538, 34.00316], [-117.82579, 34.00299], [-117.8264, 34.00283], [-117.82673, 34.00279], [-117.82725, 34.00277], [-117.82757, 34.00278], [-117.82785, 34.00282], [-117.82993, 34.00368], [-117.82998, 34.00371]]]]} | Restricted Access 2 | 7047 | Diamond Bar Golf Course | 32474 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 172.308 | Diamond Bar GC | 0 | Local Recreation Area 3 | 4 | |
15676 | 15676 | 15675 | {"type": "MultiPolygon", "coordinates": [[[[-118.4942, 34.29493], [-118.49415, 34.29507], [-118.49406, 34.29546], [-118.49398, 34.29564], [-118.49388, 34.29576], [-118.49377, 34.29585], [-118.49361, 34.29593], [-118.49356, 34.29593], [-118.49288, 34.29503], [-118.49267, 34.29486], [-118.49254, 34.2948], [-118.49238, 34.29474], [-118.49203, 34.29281], [-118.49207, 34.29277], [-118.49231, 34.29268], [-118.49226, 34.29252], [-118.49245, 34.29228], [-118.49248, 34.29102], [-118.49251, 34.29044], [-118.49302, 34.28836], [-118.4933, 34.2875], [-118.4937, 34.28756], [-118.494, 34.28756], [-118.49381, 34.28959], [-118.49379, 34.28994], [-118.494, 34.29018], [-118.49392, 34.29019], [-118.49391, 34.2902], [-118.4941, 34.29062], [-118.49412, 34.29083], [-118.49405, 34.29088], [-118.49394, 34.29102], [-118.49388, 34.29114], [-118.49387, 34.29127], [-118.49396, 34.29129], [-118.49405, 34.29126], [-118.49376, 34.29298], [-118.49376, 34.29349], [-118.49418, 34.29492], [-118.4942, 34.29493]]], [[[-118.49991, 34.28395], [-118.49999, 34.28414], [-118.50004, 34.28432], [-118.50006, 34.28453], [-118.50005, 34.28472], [-118.49999, 34.28496], [-118.49981, 34.28542], [-118.49976, 34.28561], [-118.49975, 34.28585], [-118.49979, 34.28607], [-118.49963, 34.28617], [-118.49955, 34.28571], [-118.49952, 34.28562], [-118.49945, 34.28549], [-118.49929, 34.28532], [-118.49873, 34.28494], [-118.4988, 34.28434], [-118.49846, 34.28411], [-118.49758, 34.28399], [-118.49621, 34.28343], [-118.49538, 34.28512], [-118.49468, 34.28629], [-118.49379, 34.28742], [-118.49335, 34.28736], [-118.49368, 34.28635], [-118.49478, 34.28437], [-118.49481, 34.28394], [-118.49493, 34.2835], [-118.49507, 34.28331], [-118.49523, 34.28248], [-118.49531, 34.28243], [-118.49546, 34.28253], [-118.49561, 34.28259], [-118.49767, 34.28311], [-118.498, 34.28316], [-118.49919, 34.28318], [-118.49936, 34.28321], [-118.4995, 34.28328], [-118.49963, 34.2834], [-118.49991, 34.28395]]], [[[-118.50165, 34.28881], [-118.5016, 34.28915], [-118.50156, 34.28947], [-118.50144, 34.28946], [-118.50101, 34.28961], [-118.50098, 34.28965], [-118.50098, 34.29018], [-118.50094, 34.29022], [-118.50093, 34.29027], [-118.50125, 34.29157], [-118.50127, 34.29178], [-118.50126, 34.2919], [-118.501, 34.29307], [-118.50096, 34.29311], [-118.50079, 34.29308], [-118.50059, 34.293], [-118.50001, 34.29269], [-118.50024, 34.29217], [-118.50036, 34.29168], [-118.49992, 34.29064], [-118.49946, 34.29044], [-118.4993, 34.2906], [-118.49927, 34.29055], [-118.49903, 34.29075], [-118.49893, 34.29094], [-118.49894, 34.29096], [-118.498, 34.2919], [-118.49834, 34.29256], [-118.49699, 34.29319], [-118.49685, 34.29299], [-118.49632, 34.29308], [-118.496, 34.29255], [-118.49674, 34.29172], [-118.49757, 34.2909], [-118.49736, 34.29063], [-118.49636, 34.29057], [-118.49468, 34.2908], [-118.49463, 34.29009], [-118.49619, 34.28974], [-118.49639, 34.28887], [-118.49662, 34.28872], [-118.49859, 34.28869], [-118.49852, 34.28743], [-118.49882, 34.28581], [-118.499, 34.2853], [-118.49918, 34.28543], [-118.49929, 34.28553], [-118.49936, 34.28564], [-118.4994, 34.28576], [-118.49947, 34.28626], [-118.49953, 34.28639], [-118.49948, 34.28643], [-118.49953, 34.28753], [-118.49965, 34.28818], [-118.49992, 34.28829], [-118.50061, 34.28866], [-118.50107, 34.28884], [-118.50127, 34.28863], [-118.50142, 34.28871], [-118.50161, 34.28876], [-118.50165, 34.28881]], [[-118.49983, 34.28885], [-118.49989, 34.28876], [-118.49989, 34.28871], [-118.49987, 34.28867], [-118.4998, 34.28864], [-118.49971, 34.28866], [-118.4996, 34.28878], [-118.49972, 34.28892], [-118.49978, 34.28895], [-118.49983, 34.28888], [-118.49983, 34.28885]]], [[[-118.5016, 34.30115], [-118.50107, 34.30139], [-118.50004, 34.30151], [-118.49895, 34.30146], [-118.49826, 34.3016], [-118.49776, 34.30181], [-118.49746, 34.30136], [-118.49735, 34.30115], [-118.49704, 34.30032], [-118.49717, 34.30019], [-118.49715, 34.29925], [-118.49684, 34.29855], [-118.49654, 34.29794], [-118.49626, 34.29628], [-118.49639, 34.29519], [-118.49677, 34.29415], [-118.4972, 34.29352], [-118.49706, 34.29331], [-118.49814, 34.2928], [-118.49832, 34.29308], [-118.49839, 34.2934], [-118.49733, 34.29595], [-118.49735, 34.29737], [-118.49816, 34.29904], [-118.49822, 34.2997], [-118.49845, 34.3006], [-118.50031, 34.3008], [-118.5007, 34.30057], [-118.50034, 34.29979], [-118.50069, 34.29969], [-118.50095, 34.29955], [-118.5015, 34.30017], [-118.50163, 34.30069], [-118.5016, 34.30115]]], [[[-118.50112, 34.2985], [-118.50113, 34.29861], [-118.50097, 34.29904], [-118.50112, 34.29926], [-118.50079, 34.29948], [-118.50066, 34.29955], [-118.50046, 34.29962], [-118.50007, 34.2997], [-118.49994, 34.29723], [-118.49966, 34.29668], [-118.49918, 34.29446], [-118.49995, 34.29282], [-118.50054, 34.29314], [-118.50024, 34.29448], [-118.50054, 34.29591], [-118.50097, 34.2972], [-118.5011, 34.29829], [-118.50097, 34.29844], [-118.50096, 34.2985], [-118.50112, 34.2985]]]]} | Restricted Access 2 | 12346 | Knollwood Golf Course | 32668 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/knollwood-golf-course/ | Los Angeles 6 | 151.317 | Knollwood 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 | |
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 |
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 | |
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 | |
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 | |
14677 | 14677 | 14676 | {"type": "MultiPolygon", "coordinates": [[[[-122.49119, 37.8781], [-122.48776, 37.88368], [-122.48737, 37.88444], [-122.48336, 37.88288], [-122.48238, 37.8846], [-122.48632, 37.88604], [-122.4838, 37.89047], [-122.48247, 37.88939], [-122.48215, 37.88917], [-122.48181, 37.88898], [-122.48152, 37.88884], [-122.47989, 37.88823], [-122.47913, 37.88787], [-122.48029, 37.8859], [-122.48068, 37.88606], [-122.4814, 37.88629], [-122.48237, 37.8846], [-122.48122, 37.88414], [-122.48609, 37.87599], [-122.48677, 37.87623], [-122.49119, 37.8781]]], [[[-122.48654, 37.88697], [-122.49182, 37.87837], [-122.49434, 37.87888], [-122.49609, 37.88349], [-122.4939, 37.88719], [-122.49252, 37.88934], [-122.48979, 37.89388], [-122.48955, 37.89379], [-122.4886, 37.89402], [-122.48778, 37.89409], [-122.48771, 37.89414], [-122.4843, 37.8909], [-122.48654, 37.88697]]]]} | Restricted Access 2 | 44955 | Richardson Bay Audubon Center & Sanctuary | 24330 | 353 | Marin, County of 1034 | County 3 | County Agency 3 | http://www.marincounty.org/recreation/parks-in-marin | County 3 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 382.054 | Richardson Bay Audubon Ctr. & Sanctuary | 0 | None 1253 | ||
4057 | 4057 | 4056 | {"type": "Polygon", "coordinates": [[[-122.40231, 40.58043], [-122.40172, 40.58057], [-122.40131, 40.57969], [-122.40194, 40.57953], [-122.40231, 40.58043]]]} | Restricted Access 2 | 44420 | Magnolia Park | 21676 | 343 | Shasta, County of 717 | County 3 | County Agency 3 | http://www.co.shasta.ca.us/index.aspx | County 3 | 343 | Shasta, County of 700 | County 3 | County Agency 3 | Shasta 27 | 1.399 | Magnolia Park | 0 | Local Park 2 | 4 | |
262 | 262 | 261 | {"type": "MultiPolygon", "coordinates": [[[[-119.51628, 36.5064], [-119.51628, 36.50687], [-119.51596, 36.50697], [-119.5159, 36.50697], [-119.51578, 36.50704], [-119.51571, 36.50706], [-119.51541, 36.50717], [-119.51519, 36.50722], [-119.51504, 36.50729], [-119.5146, 36.50739], [-119.51446, 36.5074], [-119.51416, 36.5074], [-119.51366, 36.50732], [-119.51344, 36.50726], [-119.51285, 36.50704], [-119.51229, 36.5069], [-119.51198, 36.50687], [-119.5116, 36.50688], [-119.51097, 36.50675], [-119.51085, 36.50679], [-119.51073, 36.50687], [-119.51069, 36.50704], [-119.51062, 36.50717], [-119.51053, 36.50724], [-119.51037, 36.50734], [-119.5101, 36.50745], [-119.50998, 36.50746], [-119.50976, 36.5076], [-119.50924, 36.50769], [-119.50894, 36.5078], [-119.50879, 36.50781], [-119.50838, 36.5078], [-119.50839, 36.5066], [-119.50732, 36.50658], [-119.50733, 36.50532], [-119.50718, 36.50531], [-119.50723, 36.50332], [-119.51176, 36.50332], [-119.51176, 36.50188], [-119.51343, 36.50219], [-119.51503, 36.50228], [-119.51505, 36.50638], [-119.51628, 36.5064]]], [[[-119.51651, 36.50754], [-119.5165, 36.50802], [-119.51522, 36.50835], [-119.51522, 36.5079], [-119.5154, 36.50788], [-119.51546, 36.50784], [-119.51651, 36.50754]]]]} | Restricted Access 2 | 733 | Kings River Nature Preserve | 20663 | 330 | Tulare, County of 96 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | Tulare 29 | 86.678 | Kings River Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
11385 | 11385 | 11384 | {"type": "Polygon", "coordinates": [[[-121.17077, 38.75418], [-121.16993, 38.75466], [-121.1697, 38.75468], [-121.16948, 38.75447], [-121.1688, 38.75478], [-121.16876, 38.75502], [-121.16861, 38.7552], [-121.16835, 38.75537], [-121.16788, 38.7554], [-121.16753, 38.75571], [-121.16726, 38.75588], [-121.16716, 38.75623], [-121.16677, 38.75661], [-121.16673, 38.75682], [-121.16613, 38.75708], [-121.16599, 38.75725], [-121.16577, 38.75739], [-121.16555, 38.75728], [-121.16531, 38.75748], [-121.16497, 38.75763], [-121.16483, 38.75781], [-121.16452, 38.75776], [-121.16401, 38.7578], [-121.164, 38.75736], [-121.16404, 38.75718], [-121.16409, 38.75705], [-121.16416, 38.7569], [-121.16436, 38.75666], [-121.16713, 38.75422], [-121.16735, 38.75406], [-121.16907, 38.75301], [-121.17077, 38.75418]]]} | Restricted Access 2 | 22191 | Miners Ravine Nature Reserve | 22264 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 24.569 | Miners Ravine Nature Reserve | 0 | Local Conservation Area 4 | 2 | |
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 | |
2734 | 2734 | 2733 | {"type": "Polygon", "coordinates": [[[-121.33438, 38.34361], [-121.33319, 38.34464], [-121.33304, 38.34475], [-121.33156, 38.34376], [-121.32059, 38.34373], [-121.31587, 38.3413], [-121.31593, 38.33691], [-121.31584, 38.33662], [-121.33219, 38.33672], [-121.33217, 38.33698], [-121.33427, 38.34166], [-121.33351, 38.34218], [-121.33376, 38.3427], [-121.33414, 38.34327], [-121.33438, 38.34361]]]} | Restricted Access 2 | 21422 | Cosumnes River Preserve | 17679 | 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 | 286.086 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 |
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]);