units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14,510 rows where ACCESS_TYP = 1 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 30
- City Agency 9,893
- County Agency 1,092
- Recreation/Parks District 990
- State Agency 827
- Federal Agency 396
- Open Space District 248
- County Agency - Parks 206
- Non Profit - Land Trust 205
- Community Services District 194
- Water District 113
- Cemetery District 62
- Non Profit - Conservation 55
- Flood District 40
- Non Profit - Other 35
- Port/Harbor District 33
- County Agency - Other 20
- Irrigation District 17
- Special District - Other 15
- Sanitation District 6
- Commercial 5
- Non Profit - Cemetery District 5
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Utility 1
- Fire District 1
- Transportation Agency 1
MNG_AGENCY >30
- San Diego, City of 493
- Los Angeles, City of 431
- California Department of Parks and Recreation 354
- California Department of Fish and Wildlife 293
- San Jose, City of 247
- San Francisco, City and County of 237
- Sacramento, City of 216
- Mountains Recreation and Conservation Authority 191
- Los Angeles, County of 152
- Ventura, City of 149
- Long Beach, City of 135
- Roseville, City of 123
- Oakland, City of 122
- United States Forest Service 109
- San Diego, County of 105
- United States Bureau of Land Management 104
- Santa Barbara, County of 103
- East Bay Regional Park District 101
- Irvine, City of 100
- Consumnes Community Services District 94
- Fresno, City of 91
- Orange, County of 88
- United States National Park Service 80
- Modesto, City of 78
- Hayward Area Recreation and Park District 77
- Stockton, City of 77
- Huntington Beach, City of 76
- California State Lands Commission 75
- Tracy, City of 73
- Santa Rosa, City of 72
- …
DES_TP >30
- Local Park 9,051
- Local Recreation Area 1,636
- Local Other or Unknown 859
- Local Conservation Area 350
- State Conservation Area 250
- Private Conservation 212
- State Park 199
- State Recreation Area 140
- Local Historic or Cultural Area 113
- National Forest 99
- State Resource Management Area 81
- National Public Lands 63
- State Historic or Cultural Area 59
- Recreation Management Area 50
- Private Recreation or Education 48
- National Recreation Area 38
- National Monument or Landmark 33
- State Other or Unknown 32
- National Wildlife Refuge 25
- National Park 22
- Resource Management Area 20
- Federal Other or Unknown 14
- Local Resource Management Area 11
- Private Other or Unknown 9
- Conservation Area 6
- Wilderness Area 6
- Area of Critical Environmental Concern 6
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- Private Agricultural 3
- …
ACCESS_TYP 1
- Open Access · 14,470 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46 | 46 | 45 | {"type": "Polygon", "coordinates": [[[-117.08226, 32.82508], [-117.08219, 32.82527], [-117.08213, 32.82555], [-117.08203, 32.82574], [-117.08095, 32.8251], [-117.08087, 32.82511], [-117.08059, 32.82491], [-117.08031, 32.82482], [-117.07942, 32.82465], [-117.0796, 32.8244], [-117.08002, 32.82402], [-117.08018, 32.82416], [-117.08058, 32.82439], [-117.08226, 32.82508]]]} | Open Access 1 | 131 | Tierrasanta Open Space | 10608 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.081 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
47 | 47 | 46 | {"type": "MultiPolygon", "coordinates": [[[[-119.70909, 34.44366], [-119.70909, 34.44415], [-119.70862, 34.44493], [-119.70858, 34.44547], [-119.70828, 34.44567], [-119.70821, 34.44594], [-119.70847, 34.44627], [-119.70848, 34.44649], [-119.70851, 34.44659], [-119.70826, 34.44655], [-119.70805, 34.44586], [-119.70711, 34.44467], [-119.70752, 34.44456], [-119.70909, 34.44366]]], [[[-119.71066, 34.44319], [-119.71065, 34.4436], [-119.71, 34.4436], [-119.70999, 34.44352], [-119.71046, 34.44304], [-119.71066, 34.44319]]]]} | Open Access 1 | 134 | Rocky Nook Park | 24543 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 6.0 | Rocky Nook Park | 0 | Local Park 2 | 4 | |
48 | 48 | 47 | {"type": "Polygon", "coordinates": [[[-121.13139, 37.46901], [-121.13089, 37.46894], [-121.13099, 37.46845], [-121.13139, 37.46901], [-121.13139, 37.46901]]]} | Open Access 1 | 106 | Del Puerto Park | 18048 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.306 | Del Puerto Park | 0 | Local Park 2 | 4 | |
49 | 49 | 48 | {"type": "Polygon", "coordinates": [[[-117.04877, 32.81115], [-117.04766, 32.81153], [-117.04656, 32.81065], [-117.04633, 32.81056], [-117.04656, 32.80996], [-117.04591, 32.8096], [-117.04518, 32.80917], [-117.0453, 32.80896], [-117.04544, 32.80897], [-117.04612, 32.8091], [-117.04679, 32.80933], [-117.04712, 32.80941], [-117.04749, 32.80943], [-117.04824, 32.80934], [-117.04829, 32.8096], [-117.0481, 32.80978], [-117.04786, 32.81015], [-117.04788, 32.81022], [-117.04852, 32.81057], [-117.04845, 32.81084], [-117.04877, 32.81115]]]} | Open Access 1 | 107 | Tuxedo Neighborhood Park | 30163 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 10.11 | Tuxedo Neighborhood Park | 0 | Local Park 2 | 4 | |
50 | 50 | 49 | {"type": "MultiPolygon", "coordinates": [[[[-117.21301, 33.87552], [-117.21265, 33.8756], [-117.21258, 33.87543], [-117.21246, 33.87526], [-117.2123, 33.87511], [-117.21214, 33.87501], [-117.21187, 33.87491], [-117.21099, 33.87478], [-117.2109, 33.87468], [-117.21098, 33.87391], [-117.21278, 33.87393], [-117.21279, 33.8744], [-117.21285, 33.87488], [-117.21287, 33.87501], [-117.21289, 33.87505], [-117.21301, 33.87552]]], [[[-117.21735, 33.87448], [-117.21724, 33.87454], [-117.21542, 33.87452], [-117.21528, 33.87448], [-117.21519, 33.87448], [-117.21508, 33.87454], [-117.21502, 33.87462], [-117.21502, 33.87471], [-117.21505, 33.87477], [-117.21504, 33.87503], [-117.21332, 33.87502], [-117.21325, 33.87454], [-117.21324, 33.87428], [-117.21325, 33.87393], [-117.21469, 33.87393], [-117.2147, 33.87379], [-117.21734, 33.8738], [-117.21735, 33.87448]]]]} | Open Access 1 | 116 | El Potrero Park | 18530 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 14.762 | El Potrero Park | 0 | Local Park 2 | 4 | |
52 | 52 | 51 | {"type": "Polygon", "coordinates": [[[-117.25242, 32.75012], [-117.25237, 32.75054], [-117.25232, 32.75081], [-117.25179, 32.75049], [-117.25206, 32.75019], [-117.2521, 32.7502], [-117.25219, 32.75008], [-117.25188, 32.74988], [-117.25193, 32.74983], [-117.25242, 32.75012]]]} | Open Access 1 | 46758 | Saratoga Park | 30209 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.754 | Saratoga Park | 0 | Local Park 2 | 4 | |
54 | 54 | 53 | {"type": "Polygon", "coordinates": [[[-119.73175, 36.7591], [-119.73175, 36.75936], [-119.73077, 36.75936], [-119.72949, 36.75856], [-119.72945, 36.75845], [-119.72945, 36.75759], [-119.73145, 36.7576], [-119.73104, 36.75782], [-119.73095, 36.75784], [-119.73086, 36.75791], [-119.73087, 36.75827], [-119.73094, 36.75851], [-119.73101, 36.75863], [-119.73118, 36.75885], [-119.73131, 36.75898], [-119.73139, 36.75904], [-119.73157, 36.75909], [-119.73175, 36.7591]]]} | Open Access 1 | 125 | Carozza Park | 16891 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.025 | Carozza Park | 0 | Local Park 2 | 4 | |
55 | 55 | 54 | {"type": "Polygon", "coordinates": [[[-121.12622, 37.47895], [-121.12464, 37.47968], [-121.12384, 37.47861], [-121.12544, 37.47788], [-121.12622, 37.47895]]]} | Open Access 1 | 128 | Felipe Garza Park | 18867 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 5.539 | Felipe Garza Park | 0 | Local Park 2 | 4 | |
56 | 56 | 55 | {"type": "Polygon", "coordinates": [[[-117.06137, 32.79131], [-117.06126, 32.79227], [-117.06098, 32.79279], [-117.06081, 32.79305], [-117.05968, 32.79265], [-117.05975, 32.79246], [-117.05991, 32.79163], [-117.06039, 32.7917], [-117.06047, 32.79131], [-117.06137, 32.79131]]]} | Open Access 1 | 157 | Pasatiempo Park West Open Space | 23492 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.178 | Pasatiempo Park West OS | 0 | Local Recreation Area 3 | 4 | |
57 | 57 | 56 | {"type": "Polygon", "coordinates": [[[-117.16831, 32.71264], [-117.16831, 32.71356], [-117.1674, 32.71356], [-117.1674, 32.71264], [-117.16831, 32.71264]]]} | Open Access 1 | 170 | Pantoja Neighborhood Park | 30100 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.149 | Pantoja Neighborhood Park | 0 | Local Park 2 | 4 | |
58 | 58 | 57 | {"type": "Polygon", "coordinates": [[[-117.02209, 32.79762], [-117.02195, 32.79979], [-117.02062, 32.79972], [-117.02075, 32.79755], [-117.02202, 32.79758], [-117.02207, 32.7976], [-117.02209, 32.79762]]]} | Open Access 1 | 129 | San Carlos Community Park | 24847 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 7.486 | San Carlos Community Park | 0 | Local Park 2 | 4 | |
59 | 59 | 58 | {"type": "Polygon", "coordinates": [[[-121.1527, 37.47726], [-121.15269, 37.47821], [-121.15093, 37.47821], [-121.15093, 37.47775], [-121.15095, 37.47748], [-121.15165, 37.47732], [-121.15206, 37.47726], [-121.1527, 37.47726]]]} | Open Access 1 | 143 | Goldbar Park | 19357 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 3.779 | Goldbar Park | 0 | Local Park 2 | 4 | |
60 | 60 | 59 | {"type": "Polygon", "coordinates": [[[-121.14269, 37.47264], [-121.14187, 37.47299], [-121.14169, 37.47269], [-121.14164, 37.47256], [-121.1416, 37.47241], [-121.14166, 37.47235], [-121.14203, 37.47228], [-121.14236, 37.47215], [-121.14269, 37.47264]]]} | Open Access 1 | 148 | Golden Amber Park | 19358 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.295 | Golden Amber Park | 0 | Local Park 2 | 4 | |
61 | 61 | 60 | {"type": "Polygon", "coordinates": [[[-117.12117, 32.92243], [-117.12114, 32.92415], [-117.11938, 32.9242], [-117.11931, 32.92417], [-117.11913, 32.9225], [-117.11913, 32.92238], [-117.12117, 32.92243]]]} | Open Access 1 | 146 | Westview Park | 27432 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.82 | Westview Park | 0 | Local Park 2 | 4 | |
62 | 62 | 61 | {"type": "Polygon", "coordinates": [[[-122.66503, 38.48047], [-122.66507, 38.48062], [-122.66507, 38.48074], [-122.66505, 38.48087], [-122.66498, 38.48107], [-122.66496, 38.48119], [-122.66497, 38.48269], [-122.66322, 38.483], [-122.66293, 38.48249], [-122.66263, 38.48191], [-122.66259, 38.48191], [-122.66235, 38.48147], [-122.66342, 38.48127], [-122.66343, 38.48126], [-122.66201, 38.47875], [-122.6625, 38.47876], [-122.66282, 38.47874], [-122.66322, 38.4787], [-122.66362, 38.47862], [-122.6647, 38.48058], [-122.66503, 38.48047]]]} | Open Access 1 | 151 | Rincon Valley Community Park | 24371 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 18.752 | Rincon Valley Community Park | 0 | Local Park 2 | 4 | |
65 | 65 | 64 | {"type": "Polygon", "coordinates": [[[-119.79845, 36.71057], [-119.79843, 36.71219], [-119.7971, 36.71219], [-119.79701, 36.71221], [-119.79693, 36.71228], [-119.79644, 36.71228], [-119.79644, 36.71058], [-119.79845, 36.71057]]]} | Open Access 1 | 189 | Carver Park | 16927 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.052 | Carver Park | 0 | Local Park 2 | 4 | |
66 | 66 | 65 | {"type": "Polygon", "coordinates": [[[-118.24767, 33.99122], [-118.24568, 33.99122], [-118.24567, 33.98955], [-118.24762, 33.98955], [-118.24767, 33.99122]]]} | Open Access 1 | 190 | Augustus Hawkins Natural Park | 15707 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.369 | Augustus Hawkins Natural Park | 0 | Local Park 2 | 4 | |
68 | 68 | 67 | {"type": "MultiPolygon", "coordinates": [[[[-117.08318, 32.79598], [-117.08318, 32.79625], [-117.07976, 32.79623], [-117.07979, 32.79489], [-117.08005, 32.79464], [-117.08026, 32.79453], [-117.08041, 32.79449], [-117.08053, 32.79447], [-117.08069, 32.79447], [-117.08088, 32.79451], [-117.08105, 32.79458], [-117.08115, 32.79463], [-117.08253, 32.7958], [-117.0828, 32.79593], [-117.083, 32.79597], [-117.08318, 32.79598]]], [[[-117.08168, 32.79321], [-117.08167, 32.7939], [-117.08165, 32.79398], [-117.08157, 32.79411], [-117.08123, 32.79443], [-117.08117, 32.79444], [-117.08096, 32.79435], [-117.08077, 32.79431], [-117.08057, 32.7943], [-117.08036, 32.79433], [-117.07996, 32.79402], [-117.08082, 32.79319], [-117.08168, 32.79321]]]]} | Open Access 1 | 155 | Allied Gardens Community Park | 15383 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 13.814 | Allied Gardens Community Park | 0 | Local Park 2 | 4 | |
69 | 69 | 68 | {"type": "Polygon", "coordinates": [[[-117.06833, 32.78979], [-117.0681, 32.78985], [-117.06791, 32.78987], [-117.06755, 32.78998], [-117.06712, 32.79007], [-117.0668, 32.78832], [-117.06803, 32.78813], [-117.06823, 32.7894], [-117.06833, 32.78979]]]} | Open Access 1 | 163 | Princess Del Cerro Neighborhood Park | 30167 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.472 | Princess Del Cerro Neighborhood Park | 0 | Local Park 2 | 4 | |
70 | 70 | 69 | {"type": "Polygon", "coordinates": [[[-117.09581, 32.78702], [-117.0958, 32.78757], [-117.09407, 32.78755], [-117.09403, 32.78751], [-117.09402, 32.78697], [-117.09483, 32.78698], [-117.09581, 32.78702]]]} | Open Access 1 | 164 | Grantville Neighborhood Park | 30217 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.604 | Grantville Neighborhood Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);