units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14,510 rows where ACCESS_TYP = 1
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 344
- Los Angeles, City of 304
- California Department of Parks and Recreation 297
- California Department of Fish and Wildlife 248
- Sacramento, City of 177
- San Jose, City of 163
- San Francisco, City and County of 150
- Mountains Recreation and Conservation Authority 142
- Ventura, City of 121
- Los Angeles, County of 108
- Long Beach, City of 103
- Roseville, City of 99
- Oakland, City of 90
- East Bay Regional Park District 87
- Consumnes Community Services District 86
- United States Forest Service 79
- Santa Barbara, County of 78
- San Diego, County of 77
- United States Bureau of Land Management 71
- Orange, County of 67
- Irvine, City of 65
- Napa, City of 64
- United States National Park Service 63
- California State Lands Commission 63
- Hayward Area Recreation and Park District 62
- Tracy, City of 59
- Valley-Wide Recreation and Park District 55
- Davis, City of 55
- Poway, City of 54
- Stockton, City of 52
- …
DES_TP >30
- Local Park 6,174
- Local Recreation Area 1,325
- Local Other or Unknown 763
- Local Conservation Area 279
- State Conservation Area 223
- State Park 172
- Private Conservation 164
- State Recreation Area 111
- National Forest 71
- State Resource Management Area 68
- Local Historic or Cultural Area 58
- State Historic or Cultural Area 54
- Recreation Management Area 41
- National Public Lands 35
- Private Recreation or Education 33
- National Recreation Area 31
- National Monument or Landmark 28
- State Other or Unknown 22
- National Wildlife Refuge 21
- National Park 19
- Resource Management Area 12
- Local Resource Management Area 8
- Federal Other or Unknown 8
- Private Other or Unknown 8
- Area of Critical Environmental Concern 6
- Conservation Area 5
- Wilderness Area 4
- Historic or Cultural Area 4
- Private Historic or Cultural 4
- Private Agricultural 3
- …
MNG_AG_TYP 29
- City Agency 6,960
- County Agency 798
- Recreation/Parks District 780
- State Agency 684
- Federal Agency 289
- Open Space District 195
- County Agency - Parks 168
- Community Services District 159
- Non Profit - Land Trust 154
- Water District 91
- Non Profit - Conservation 47
- Cemetery District 31
- Flood District 27
- Non Profit - Other 26
- Port/Harbor District 24
- County Agency - Other 15
- Irrigation District 14
- Special District - Other 14
- Non Profit - Cemetery District 5
- Sanitation District 4
- Commercial 2
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Metropolitan Planning Organization 1
- Utility 1
- Fire District 1
- Transportation Agency 1
ACCESS_TYP 1
- Open Access · 10,499 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4561 | 4561 | 4560 | {"type": "Polygon", "coordinates": [[[-121.68777, 36.44521], [-121.68564, 36.44803], [-121.68544, 36.44783], [-121.68401, 36.44774], [-121.68569, 36.44484], [-121.68595, 36.44475], [-121.68612, 36.44467], [-121.68628, 36.44455], [-121.68641, 36.44439], [-121.68648, 36.44425], [-121.68652, 36.44411], [-121.68653, 36.44396], [-121.68651, 36.44383], [-121.68652, 36.44381], [-121.68655, 36.4438], [-121.68658, 36.44382], [-121.68665, 36.44396], [-121.68679, 36.44411], [-121.68691, 36.4442], [-121.68711, 36.44428], [-121.68715, 36.44432], [-121.68717, 36.44437], [-121.68713, 36.44456], [-121.68714, 36.4447], [-121.68719, 36.44484], [-121.68728, 36.44497], [-121.6874, 36.44507], [-121.68751, 36.44513], [-121.68777, 36.44521]]]} | Open Access 1 | 35187 | Unnamed site - Other State | 28654 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Monterey 14 | 16.412 | 0 | State Other or Unknown 104 | 4 | |||
4564 | 4564 | 4563 | {"type": "MultiPolygon", "coordinates": [[[[-116.11039, 33.44247], [-116.10826, 33.44247], [-116.10825, 33.44073], [-116.11038, 33.44072], [-116.11039, 33.44247]]], [[[-116.10935, 33.44611], [-116.10828, 33.44612], [-116.10827, 33.44431], [-116.10934, 33.4443], [-116.10935, 33.44611]]], [[[-115.74733, 33.43453], [-115.73867, 33.43457], [-115.73865, 33.42729], [-115.74731, 33.42724], [-115.74733, 33.43453]]], [[[-115.78294, 33.4371], [-115.77836, 33.43734], [-115.77816, 33.43392], [-115.78267, 33.43375], [-115.78294, 33.4371]]], [[[-116.13863, 33.45518], [-116.1343, 33.45522], [-116.13423, 33.45164], [-116.13531, 33.45163], [-116.13524, 33.44803], [-116.13848, 33.44804], [-116.13863, 33.45518]]], [[[-116.13321, 33.45523], [-116.12992, 33.45525], [-116.12992, 33.45165], [-116.13316, 33.45165], [-116.13321, 33.45523]]], [[[-116.11248, 33.44793], [-116.11247, 33.45514], [-116.11155, 33.45514], [-116.11151, 33.44793], [-116.11248, 33.44793]]], [[[-115.75601, 33.45632], [-115.74304, 33.4564], [-115.74303, 33.45276], [-115.73437, 33.4528], [-115.73436, 33.44916], [-115.73003, 33.44918], [-115.73002, 33.4419], [-115.73868, 33.44186], [-115.7387, 33.44914], [-115.756, 33.44904], [-115.75601, 33.45632]]], [[[-115.78263, 33.48481], [-115.7826, 33.48581], [-115.77976, 33.48731], [-115.77978, 33.4849], [-115.78263, 33.48481]]], [[[-115.77365, 33.4851], [-115.77357, 33.49049], [-115.76899, 33.49285], [-115.7687, 33.49299], [-115.76839, 33.49312], [-115.76778, 33.49334], [-115.7661, 33.49382], [-115.76467, 33.48945], [-115.76466, 33.48539], [-115.76242, 33.4854], [-115.7588, 33.48059], [-115.75845, 33.48014], [-115.75772, 33.47925], [-115.75695, 33.47839], [-115.75614, 33.47755], [-115.75531, 33.47673], [-115.74902, 33.47093], [-115.76465, 33.47082], [-115.76467, 33.48538], [-115.77365, 33.4851]]], [[[-115.77791, 33.49623], [-115.77784, 33.49998], [-115.76744, 33.49995], [-115.76742, 33.49922], [-115.76738, 33.4987], [-115.76732, 33.49818], [-115.76719, 33.4974], [-115.76707, 33.49689], [-115.76687, 33.49616], [-115.76628, 33.49435], [-115.76801, 33.49385], [-115.76867, 33.49362], [-115.76932, 33.49333], [-115.77079, 33.49257], [-115.77355, 33.49253], [-115.7735, 33.49625], [-115.77791, 33.49623]]], [[[-115.79094, 33.49983], [-115.79085, 33.51014], [-115.78868, 33.51019], [-115.78868, 33.50984], [-115.78759, 33.50984], [-115.7876, 33.50805], [-115.78869, 33.50803], [-115.78876, 33.49988], [-115.79094, 33.49983]]], [[[-115.7844, 33.49996], [-115.78431, 33.51029], [-115.78211, 33.51035], [-115.78223, 33.5], [-115.7844, 33.49996]]], [[[-116.20263, 33.53223], [-116.1984, 33.53224], [-116.1984, 33.53133], [-116.20262, 33.53132], [-116.20263, 33.53223]]], [[[-116.20483, 33.53673], [-116.20483, 33.53763], [-116.20267, 33.53763], [-116.20266, 33.53852], [-116.1983, 33.53852], [-116.1983, 33.53764], [-116.20158, 33.53763], [-116.20158, 33.53674], [-116.20483, 33.53673]]], [[[-115.75192, 33.531], [-115.74761, 33.53102], [-115.7476, 33.52921], [-115.75191, 33.52919], [-115.75192, 33.531]]], [[[-115.87997, 33.55444], [-115.87898, 33.55447], [-115.87892, 33.55083], [-115.87992, 33.5508], [-115.87997, 33.55444]]], [[[-115.93063, 33.56179], [-115.92202, 33.56176], [-115.92175, 33.55441], [-115.93043, 33.55447], [-115.93052, 33.55812], [-115.93063, 33.56179]]], [[[-116.22972, 33.57756], [-116.2248, 33.57751], [-116.22482, 33.57648], [-116.22436, 33.57648], [-116.22435, 33.57461], [-116.22436, 33.5746], [-116.22435, 33.5737], [-116.22718, 33.57368], [-116.22816, 33.57512], [-116.22904, 33.57647], [-116.22945, 33.57706], [-116.2296, 33.57731], [-116.2297, 33.57749], [-116.22972, 33.57756]]], [[[-116.2709, 33.59277], [-116.26982, 33.59276], [-116.26981, 33.59095], [-116.2709, 33.59095], [-116.2709, 33.59277]]], [[[-116.06075, 33.67141], [-116.05857, 33.67141], [-116.05857, 33.66959], [-116.06075, 33.6696], [-116.06075, 33.67141]]], [[[-116.05639, 33.6714], [-116.05422, 33.6714], [-116.05421, 33.66868], [-116.05639, 33.66868], [-116.05639, 33.6714]]], [[[-116.05203, 33.66777], [-116.04768, 33.66776], [-116.04768, 33.67139], [-116.04332, 33.67138], [-116.04332, 33.66411], [-116.05203, 33.66413], [-116.05203, 33.66777]]], [[[-116.05642, 33.68943], [-116.05641, 33.69305], [-116.05343, 33.69305], [-116.05175, 33.69222], [-116.05112, 33.69193], [-116.05062, 33.69172], [-116.0501, 33.69153], [-116.04957, 33.69136], [-116.04904, 33.69121], [-116.04633, 33.69], [-116.04367, 33.68981], [-116.04332, 33.68974], [-116.04332, 33.68581], [-116.05202, 33.68582], [-116.05202, 33.68942], [-116.05642, 33.68943]]], [[[-116.03034, 33.70947], [-116.03034, 33.71127], [-116.02818, 33.71128], [-116.02819, 33.70946], [-116.03034, 33.70947]]], [[[-116.06078, 33.7248], [-116.06078, 33.72571], [-116.05205, 33.72574], [-116.05206, 33.72936], [-116.06078, 33.72934], [-116.06077, 33.74387], [-116.04407, 33.7439], [-116.04333, 33.74303], [-116.04333, 33.72212], [-116.04551, 33.72211], [-116.04552, 33.72393], [-116.04769, 33.72392], [-116.04769, 33.72211], [-116.05205, 33.7221], [-116.05206, 33.72482], [-116.06078, 33.7248]]], [[[-116.07824, 33.75837], [-116.07824, 33.76202], [-116.07387, 33.76202], [-116.07387, 33.75838], [-116.07824, 33.75837]]], [[[-116.10752, 33.76574], [-116.10752, 33.76938], [-116.10316, 33.76936], [-116.10317, 33.76571], [-116.10752, 33.76574]]], [[[-116.09195, 33.77659], [-116.09194, 33.78748], [-116.08792, 33.78748], [-116.07458, 33.77618], [-116.07458, 33.77336], [-116.07503, 33.77296], [-116.07894, 33.77296], [-116.07893, 33.77659], [-116.08543, 33.77659], [-116.08545, 33.77296], [-116.08761, 33.77296], [-116.08761, 33.77659], [-116.09195, 33.77659]]], [[[-116.24856, 33.79477], [-116.24856, 33.80022], [-116.23116, 33.80026], [-116.23115, 33.78759], [-116.23986, 33.78758], [-116.23987, 33.79477], [-116.24856, 33.79477]]], [[[-116.18621, 33.80619], [-116.1862, 33.8077], [-116.1823, 33.80769], [-116.1823, 33.80617], [-116.18621, 33.80619]]], [[[-116.14848, 33.80578], [-116.1463, 33.80577], [-116.14629, 33.80667], [-116.14411, 33.80666], [-116.1441, 33.80214], [-116.14848, 33.80216], [-116.14848, 33.80578]]], [[[-116.26601, 33.81656], [-116.24855, 33.8166], [-116.24856, 33.80209], [-116.26578, 33.80204], [-116.26601, 33.81656]]], [[[-116.16594, 33.81671], [-116.16594, 33.82032], [-116.1616, 33.82031], [-116.1616, 33.8167], [-116.16594, 33.81671]]], [[[-116.17027, 33.82216], [-116.17027, 33.82216], [-116.16661, 33.82215], [-116.16896, 33.82033], [-116.17026, 33.82033], [-116.17027, 33.82216]]], [[[-116.15365, 33.82717], [-116.15315, 33.82706], [-116.15301, 33.82705], [-116.15285, 33.82707], [-116.15272, 33.82711], [-116.1526, 33.82717], [-116.1525, 33.82724], [-116.15237, 33.82739], [-116.15216, 33.82754], [-116.14412, 33.82749], [-116.14412, 33.81663], [-116.15363, 33.81667], [-116.15365, 33.82717]]], [[[-116.19631, 33.83847], [-116.17904, 33.83844], [-116.17903, 33.8312], [-116.19631, 33.83122], [-116.19631, 33.83847]], [[-116.19039, 33.83719], [-116.19039, 33.83737], [-116.19093, 33.83737], [-116.19092, 33.83719], [-116.19039, 33.83719]]], [[[-116.20933, 33.8666], [-116.20505, 33.86442], [-116.20505, 33.86408], [-116.20438, 33.86408], [-116.19733, 33.86046], [-116.20511, 33.86045], [-116.20932, 33.86046], [-116.20933, 33.8666]]], [[[-116.3014, 33.88038], [-116.30139, 33.88401], [-116.29646, 33.884], [-116.29645, 33.88219], [-116.29537, 33.88218], [-116.29537, 33.884], [-116.29428, 33.884], [-116.29429, 33.88581], [-116.2932, 33.88581], [-116.29319, 33.88399], [-116.29211, 33.884], [-116.29211, 33.88762], [-116.28776, 33.88761], [-116.28776, 33.8858], [-116.28668, 33.88579], [-116.28668, 33.88761], [-116.28342, 33.8876], [-116.28341, 33.87854], [-116.2834, 33.87853], [-116.28339, 33.8749], [-116.29016, 33.87493], [-116.29101, 33.87491], [-116.29535, 33.87494], [-116.29537, 33.87856], [-116.29645, 33.87855], [-116.29644, 33.87494], [-116.29753, 33.87494], [-116.29753, 33.87675], [-116.29971, 33.87676], [-116.29971, 33.88037], [-116.3014, 33.88038]], [[-116.28666, 33.88579], [-116.28667, 33.88398], [-116.2845, 33.88398], [-116.2845, 33.88578], [-116.28666, 33.88579]], [[-116.28557, 33.88216], [-116.28558, 33.88035], [-116.28449, 33.88035], [-116.2845, 33.88216], [-116.28557, 33.88216]], [[-116.29427, 33.88218], [-116.29428, 33.88217], [-116.29427, 33.87856], [-116.29319, 33.87855], [-116.29319, 33.88036], [-116.2921, 33.88037], [-116.2921, 33.88217], [-116.29427, 33.88218]], [[-116.28667, 33.8775], [-116.28665, 33.87673], [-116.28557, 33.87673], [-116.28558, 33.87853], [-116.28666, 33.87853], [-116.28667, 33.8775]], [[-116.2921, 33.87675], [-116.29101, 33.87673], [-116.29102, 33.87855], [-116.2921, 33.87854], [-116.2921, 33.87675]], [[-116.29209, 33.88036], [-116.2921, 33.87901], [-116.29102, 33.879], [-116.29102, 33.88036], [-116.29209, 33.88036]]], [[[-116.41468, 33.89668], [-116.41462, 33.8994], [-116.41247, 33.89939], [-116.41248, 33.89668], [-116.41468, 33.89668]]], [[[-116.41457, 33.90121], [-116.41455, 33.90212], [-116.41036, 33.90211], [-116.41035, 33.90029], [-116.41247, 33.9003], [-116.41247, 33.9012], [-116.41457, 33.90121]]], [[[-116.6389, 33.91082], [-116.63675, 33.91082], [-116.63672, 33.90839], [-116.63888, 33.90828], [-116.6389, 33.91082]]], [[[-116.64988, 33.91441], [-116.64662, 33.91442], [-116.64663, 33.91533], [-116.64555, 33.91534], [-116.64546, 33.91082], [-116.64983, 33.91082], [-116.64988, 33.91441]]], [[[-116.64447, 33.91579], [-116.64338, 33.9158], [-116.64337, 33.91534], [-116.64446, 33.91534], [-116.64447, 33.91579]]], [[[-116.64777, 33.91807], [-116.64342, 33.91808], [-116.64341, 33.91744], [-116.64558, 33.91731], [-116.64666, 33.91731], [-116.64667, 33.91726], [-116.64776, 33.91726], [-116.64777, 33.91807]]], [[[-116.32979, 33.90377], [-116.32899, 33.90569], [-116.32678, 33.90997], [-116.32616, 33.91101], [-116.31879, 33.91097], [-116.31875, 33.91098], [-116.31875, 33.91269], [-116.31002, 33.90844], [-116.30136, 33.90426], [-116.30136, 33.90383], [-116.30047, 33.90383], [-116.28342, 33.89562], [-116.28342, 33.88941], [-116.30138, 33.88945], [-116.30137, 33.90357], [-116.31877, 33.90373], [-116.31879, 33.90013], [-116.32317, 33.90015], [-116.32316, 33.90375], [-116.32979, 33.90377]], [[-116.31877, 33.90612], [-116.31879, 33.90612], [-116.31881, 33.904], [-116.31879, 33.90391], [-116.31878, 33.90392], [-116.31877, 33.90612]]], [[[-116.37098, 33.9096], [-116.37097, 33.91099], [-116.3623, 33.91101], [-116.36227, 33.91826], [-116.35574, 33.91828], [-116.35577, 33.91104], [-116.35359, 33.91104], [-116.35362, 33.90379], [-116.36012, 33.90378], [-116.37098, 33.9096]]], [[[-116.71097, 33.9382], [-116.70987, 33.93821], [-116.70986, 33.9345], [-116.71095, 33.93449], [-116.71097, 33.9382]]], [[[-116.64172, 33.9475], [-116.64148, 33.9475], [-116.64137, 33.94735], [-116.64162, 33.94735], [-116.64172, 33.9475]]], [[[-116.44054, 33.96104], [-116.42877, 33.96124], [-116.42304, 33.95752], [-116.42302, 33.94686], [-116.44043, 33.94685], [-116.44054, 33.96104]]], [[[-116.58264, 34.00542], [-116.58046, 34.00555], [-116.58041, 34.00236], [-116.58256, 34.00224], [-116.58264, 34.00542]]]]} | Open Access 1 | 35203 | Unnamed site - Friends of the Desert Mountains | 33250 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 7591.856 | 0 | Private Other or Unknown 399 | 4 | ||
4567 | 4567 | 4566 | {"type": "Polygon", "coordinates": [[[-119.71084, 34.46312], [-119.71071, 34.46336], [-119.70994, 34.46337], [-119.70995, 34.46314], [-119.71084, 34.46312]]]} | Open Access 1 | 35211 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.489 | 0 | Local Other or Unknown 14 | 4 | ||
4568 | 4568 | 4567 | {"type": "Polygon", "coordinates": [[[-119.62321, 34.44984], [-119.62318, 34.45014], [-119.62286, 34.45046], [-119.62231, 34.45075], [-119.62214, 34.45112], [-119.62197, 34.45112], [-119.62196, 34.45078], [-119.6221, 34.45066], [-119.62217, 34.45053], [-119.62231, 34.44987], [-119.62232, 34.44975], [-119.6223, 34.44957], [-119.62216, 34.44918], [-119.62211, 34.44896], [-119.6221, 34.44883], [-119.62209, 34.44827], [-119.62239, 34.44829], [-119.62238, 34.44846], [-119.62223, 34.44862], [-119.62265, 34.44905], [-119.62283, 34.44907], [-119.62296, 34.44939], [-119.62321, 34.44984]]]} | Open Access 1 | 35212 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 4.011 | 0 | Local Other or Unknown 14 | 4 | ||
4569 | 4569 | 4568 | {"type": "Polygon", "coordinates": [[[-121.90092, 36.38111], [-121.90068, 36.38151], [-121.89991, 36.38153], [-121.90026, 36.38083], [-121.90092, 36.38111]]]} | Open Access 1 | 35213 | Unnamed site - Monterey, County of | 28641 | 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 | 1.072 | 0 | Local Other or Unknown 14 | 4 | ||
4570 | 4570 | 4569 | {"type": "Polygon", "coordinates": [[[-121.79587, 36.24479], [-121.79216, 36.24477], [-121.79223, 36.24187], [-121.79275, 36.24205], [-121.79412, 36.24162], [-121.79434, 36.24172], [-121.79457, 36.24166], [-121.79584, 36.24162], [-121.79587, 36.24479]]]} | Open Access 1 | 35214 | Unnamed site - Monterey, County of | 28641 | 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 | 27.202 | 0 | Local Other or Unknown 14 | 4 | ||
4571 | 4571 | 4570 | {"type": "Polygon", "coordinates": [[[-121.75824, 36.76732], [-121.75755, 36.76792], [-121.75679, 36.76735], [-121.75748, 36.76675], [-121.75824, 36.76732]]]} | Open Access 1 | 35215 | Unknown park - Monterey, County of | 28642 | 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 | 2.087 | 0 | Local Other or Unknown 14 | 4 | ||
4572 | 4572 | 4571 | {"type": "Polygon", "coordinates": [[[-121.68837, 36.61717], [-121.68833, 36.6172], [-121.68814, 36.61791], [-121.68767, 36.61774], [-121.68798, 36.6174], [-121.68817, 36.6171], [-121.68837, 36.61717]]]} | Open Access 1 | 35222 | Unnamed site - Monterey, County of | 28641 | 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 | 0.614 | 0 | Local Other or Unknown 14 | 4 | ||
4573 | 4573 | 4572 | {"type": "Polygon", "coordinates": [[[-121.68761, 36.61869], [-121.68717, 36.61899], [-121.68712, 36.61905], [-121.687, 36.61903], [-121.68706, 36.61882], [-121.68721, 36.61854], [-121.68761, 36.61869]]]} | Open Access 1 | 35223 | Unnamed site - Monterey, County of | 28641 | 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 | 0.347 | 0 | Local Other or Unknown 14 | 4 | ||
4575 | 4575 | 4574 | {"type": "Polygon", "coordinates": [[[-120.41196, 34.87233], [-120.40988, 34.87235], [-120.40988, 34.87167], [-120.41063, 34.87167], [-120.41063, 34.87165], [-120.41048, 34.87139], [-120.41055, 34.87137], [-120.41071, 34.87164], [-120.41102, 34.87133], [-120.4118, 34.87166], [-120.41179, 34.87207], [-120.41196, 34.87233]]]} | Open Access 1 | 35235 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.807 | 0 | Local Other or Unknown 14 | 4 | ||
4576 | 4576 | 4575 | {"type": "Polygon", "coordinates": [[[-121.90098, 36.38732], [-121.9, 36.38737], [-121.8999, 36.38682], [-121.89994, 36.38646], [-121.90076, 36.38641], [-121.90098, 36.38732]]]} | Open Access 1 | 35237 | Unnamed site - Monterey, County of | 28641 | 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 | 2.104 | 0 | Local Other or Unknown 14 | 4 | ||
4577 | 4577 | 4576 | {"type": "Polygon", "coordinates": [[[-121.85444, 36.9225], [-121.85412, 36.92319], [-121.85376, 36.92307], [-121.85374, 36.9231], [-121.85269, 36.92275], [-121.85271, 36.92271], [-121.85333, 36.92292], [-121.85334, 36.92288], [-121.85364, 36.92288], [-121.85392, 36.92281], [-121.85385, 36.92265], [-121.85379, 36.92263], [-121.85393, 36.92259], [-121.8539, 36.92263], [-121.85399, 36.92279], [-121.85421, 36.92268], [-121.85444, 36.9225]]]} | Open Access 1 | 35238 | Unknown park - Santa Cruz, County of | 28665 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 0.741 | 0 | Local Other or Unknown 14 | 4 | ||
4578 | 4578 | 4577 | {"type": "MultiPolygon", "coordinates": [[[[-120.44975, 34.81145], [-120.44876, 34.81144], [-120.44421, 34.8026], [-120.44368, 34.79916], [-120.44429, 34.80052], [-120.44421, 34.80147], [-120.44538, 34.80388], [-120.44649, 34.80641], [-120.44778, 34.80894], [-120.449, 34.81041], [-120.44975, 34.81145]]], [[[-120.44694, 34.81143], [-120.44555, 34.81141], [-120.44464, 34.80544], [-120.44694, 34.81143], [-120.44694, 34.81143]]]]} | Open Access 1 | 35242 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 23.418 | 0 | Local Other or Unknown 14 | 4 | ||
4579 | 4579 | 4578 | {"type": "Polygon", "coordinates": [[[-120.14651, 34.6035], [-120.14643, 34.60387], [-120.14512, 34.60449], [-120.14492, 34.60438], [-120.14466, 34.6043], [-120.14438, 34.6043], [-120.14381, 34.60437], [-120.14377, 34.60436], [-120.14373, 34.60432], [-120.14374, 34.6041], [-120.14379, 34.60395], [-120.14434, 34.60404], [-120.14512, 34.60379], [-120.14578, 34.60373], [-120.14651, 34.6035]]]} | Open Access 1 | 35310 | Unnamed site - Solvang, City of | 28670 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 3.005 | 0 | Local Other or Unknown 14 | 4 | ||
4580 | 4580 | 4579 | {"type": "Polygon", "coordinates": [[[-120.65368, 35.25981], [-120.65355, 35.25973], [-120.65336, 35.25938], [-120.65327, 35.25852], [-120.65304, 35.25837], [-120.65297, 35.25826], [-120.65294, 35.25809], [-120.653, 35.2577], [-120.65339, 35.25769], [-120.65368, 35.25981]]]} | Open Access 1 | 35313 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.637 | 0 | Local Other or Unknown 14 | 4 | ||
4581 | 4581 | 4580 | {"type": "Polygon", "coordinates": [[[-120.68305, 35.25007], [-120.68298, 35.25011], [-120.68277, 35.25009], [-120.68274, 35.25012], [-120.68269, 35.25007], [-120.68285, 35.24982], [-120.68305, 35.25007]]]} | Open Access 1 | 35336 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.137 | 0 | Local Other or Unknown 14 | 4 | ||
4582 | 4582 | 4581 | {"type": "MultiPolygon", "coordinates": [[[[-120.1849, 34.61028], [-120.18435, 34.61053], [-120.18425, 34.61045], [-120.18475, 34.61022], [-120.1849, 34.61028]]], [[[-120.43144, 34.69015], [-120.43034, 34.69026], [-120.42984, 34.68952], [-120.42983, 34.68933], [-120.42996, 34.68929], [-120.43006, 34.68941], [-120.43087, 34.68899], [-120.431, 34.6891], [-120.43087, 34.68918], [-120.43142, 34.68999], [-120.43144, 34.69015]]], [[[-120.43408, 34.69307], [-120.43387, 34.69201], [-120.43382, 34.69192], [-120.43375, 34.69184], [-120.43334, 34.69167], [-120.43349, 34.69141], [-120.43336, 34.69134], [-120.43351, 34.69111], [-120.43387, 34.69156], [-120.43425, 34.69197], [-120.43457, 34.69241], [-120.43471, 34.6924], [-120.43477, 34.69296], [-120.43518, 34.69386], [-120.43496, 34.69483], [-120.43531, 34.6949], [-120.43529, 34.69518], [-120.43495, 34.69675], [-120.43496, 34.69681], [-120.43501, 34.69687], [-120.43512, 34.69694], [-120.43507, 34.69714], [-120.4354, 34.69765], [-120.43556, 34.69768], [-120.43551, 34.69795], [-120.43488, 34.69786], [-120.43487, 34.69849], [-120.43399, 34.69839], [-120.43398, 34.6992], [-120.43343, 34.69918], [-120.43315, 34.69904], [-120.43413, 34.69775], [-120.43424, 34.69755], [-120.43434, 34.69733], [-120.43442, 34.69709], [-120.43452, 34.69664], [-120.43454, 34.6964], [-120.43451, 34.69514], [-120.43449, 34.69491], [-120.43408, 34.69307]]], [[[-120.43252, 34.69557], [-120.43253, 34.69645], [-120.43246, 34.69677], [-120.43236, 34.69696], [-120.43231, 34.69705], [-120.43203, 34.69738], [-120.43134, 34.69773], [-120.43098, 34.69821], [-120.43081, 34.69823], [-120.43103, 34.69795], [-120.43093, 34.69789], [-120.43065, 34.69796], [-120.42978, 34.69811], [-120.42957, 34.69812], [-120.42893, 34.69812], [-120.42865, 34.69814], [-120.42745, 34.69836], [-120.42721, 34.69845], [-120.42693, 34.69863], [-120.42593, 34.69941], [-120.42581, 34.69954], [-120.42571, 34.69968], [-120.42562, 34.69992], [-120.42542, 34.69992], [-120.42552, 34.69964], [-120.42563, 34.69948], [-120.42572, 34.69937], [-120.42686, 34.69845], [-120.42713, 34.6983], [-120.42726, 34.69825], [-120.42752, 34.69818], [-120.42859, 34.69798], [-120.42877, 34.69796], [-120.42958, 34.69796], [-120.42979, 34.69794], [-120.43069, 34.69778], [-120.43096, 34.69768], [-120.43174, 34.6973], [-120.43198, 34.69712], [-120.43217, 34.69687], [-120.43225, 34.69669], [-120.43232, 34.69639], [-120.43229, 34.69589], [-120.4322, 34.69557], [-120.4319, 34.69507], [-120.43179, 34.69478], [-120.43118, 34.69181], [-120.43106, 34.69134], [-120.43091, 34.69104], [-120.43064, 34.69067], [-120.43086, 34.69056], [-120.43119, 34.69103], [-120.43132, 34.69128], [-120.43207, 34.6948], [-120.43214, 34.69499], [-120.43219, 34.69508], [-120.43252, 34.69553], [-120.43252, 34.69557]]], [[[-120.43087, 34.69835], [-120.43, 34.69953], [-120.4299, 34.69972], [-120.42983, 34.69997], [-120.42966, 34.69994], [-120.42973, 34.69968], [-120.42985, 34.69945], [-120.43064, 34.69839], [-120.43087, 34.69835]]]]} | Open Access 1 | 35355 | Unnamed site - Santa Barbara, County of | 28662 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 26.157 | 0 | Local Other or Unknown 14 | 4 | ||
4583 | 4583 | 4582 | {"type": "Polygon", "coordinates": [[[-119.88779, 34.43612], [-119.8877, 34.43611], [-119.88767, 34.43609], [-119.88769, 34.43601], [-119.88773, 34.43598], [-119.8878, 34.43598], [-119.88784, 34.43602], [-119.88784, 34.4361], [-119.88782, 34.43612], [-119.88779, 34.43612]]]} | Open Access 1 | 35397 | Unknown park - Santa Barbara, County of | 28663 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.051 | 0 | Local Other or Unknown 14 | 4 | ||
4584 | 4584 | 4583 | {"type": "MultiPolygon", "coordinates": [[[[-119.29299, 34.28177], [-119.29297, 34.28184], [-119.29281, 34.28191], [-119.29269, 34.28203], [-119.29249, 34.28203], [-119.29249, 34.28177], [-119.29299, 34.28177]]], [[[-119.29359, 34.28203], [-119.29355, 34.28202], [-119.2935, 34.28196], [-119.29342, 34.2819], [-119.29328, 34.28185], [-119.29326, 34.28181], [-119.29325, 34.28176], [-119.29359, 34.28175], [-119.29359, 34.28203]]]]} | Open Access 1 | 35403 | Unknown park - Ventura, City of | 30393 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.37 | 0 | Local Other or Unknown 14 | 4 | ||
4585 | 4585 | 4584 | {"type": "Polygon", "coordinates": [[[-119.02666, 34.17663], [-119.02303, 34.17889], [-119.02303, 34.17889], [-119.0227, 34.17654], [-119.0266, 34.17657], [-119.02666, 34.17663]]]} | Open Access 1 | 35461 | Unnamed site - Ventura, County of | 28674 | 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 | 12.065 | 0 | Local Other or Unknown 14 | 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]);