units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
651 rows where DES_TP = 2 and MNG_AG_TYP = 3 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, YR_EST
MNG_AGENCY >30
- Los Angeles, County of 95
- San Diego, County of 68
- Orange, County of 43
- El Dorado, County of 42
- Santa Barbara, County of 40
- Kern, County of 37
- Santa Cruz, County of 33
- Stanislaus, County of 22
- San Luis Obispo, County of 20
- Riverside, County of 19
- Placer, County of 19
- Lake, County of 18
- San Joaquin, County of 18
- Monterey, County of 17
- Ventura, County of 15
- San Bernardino, County of 14
- Merced, County of 12
- Yolo, County of 12
- Tulare, County of 11
- Fresno, County of 11
- Humboldt, County of 10
- Sacramento, County of 7
- Tehama, County of 6
- Mendocino, County of 6
- Lassen, County of 6
- Mariposa, County of 5
- Mono, County of 5
- Imperial, County of 4
- Yuba, County of 4
- San Benito, County of 3
- …
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 651 ✖
DES_TP 1
- Local Park · 651 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15237 | 15237 | 15236 | {"type": "Polygon", "coordinates": [[[-118.37777, 34.01479], [-118.37753, 34.0148], [-118.37747, 34.01477], [-118.37741, 34.01476], [-118.37599, 34.0148], [-118.37598, 34.01451], [-118.37593, 34.01451], [-118.37619, 34.01404], [-118.37647, 34.01384], [-118.37662, 34.01349], [-118.37761, 34.01347], [-118.37774, 34.01366], [-118.37777, 34.01479]]]} | Open Access 1 | 46287 | Stoneview Park | 29580 | 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 | 5.017 | Stoneview Park | 2017 | Local Park 2 | 4 | |
5626 | 5626 | 5625 | {"type": "Polygon", "coordinates": [[[-118.41054, 34.22709], [-118.4103, 34.22778], [-118.40776, 34.22897], [-118.40741, 34.22916], [-118.40705, 34.2294], [-118.407, 34.22941], [-118.40696, 34.22939], [-118.404, 34.22662], [-118.40712, 34.22434], [-118.40755, 34.22467], [-118.40844, 34.22521], [-118.40886, 34.2255], [-118.41022, 34.22678], [-118.41054, 34.22709]]]} | Open Access 1 | 45413 | Sheldon-Arleta Park | 28186 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.laparks.org/dos/parks/facility/devonshireArletaPk.htm | Los Angeles 6 | 45.127 | Sheldon-Arleta Park | 2016 | Local Park 2 | 4 |
14928 | 14928 | 14927 | {"type": "Polygon", "coordinates": [[[-117.25461, 33.36874], [-117.2546, 33.3693], [-117.25423, 33.3693], [-117.25423, 33.36873], [-117.25461, 33.36874]]]} | Open Access 1 | 45505 | Clemmens Lane County Park | 28337 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Clemmens.html | San Diego 4 | 0.544 | Clemmens Lane County Park | 2009 | Local Park 2 | 4 |
14960 | 14960 | 14959 | {"type": "Polygon", "coordinates": [[[-116.01947, 32.74748], [-116.01802, 32.74819], [-116.01696, 32.74871], [-116.01696, 32.74748], [-116.01947, 32.74748]]]} | Open Access 1 | 45623 | Ocotillo Community Park | 28449 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | Imperial 20 | 3.974 | Ocotillo Community Park | 2007 | Local Park 2 | 4 | |
16420 | 16420 | 16419 | {"type": "MultiPolygon", "coordinates": [[[[-121.18213, 38.97105], [-121.1726, 38.97098], [-121.16305, 38.97055], [-121.16315, 38.9633], [-121.16337, 38.95628], [-121.16418, 38.95627], [-121.16436, 38.95648], [-121.16487, 38.95686], [-121.16513, 38.95721], [-121.16527, 38.95736], [-121.16559, 38.95748], [-121.16589, 38.95782], [-121.16614, 38.95819], [-121.16611, 38.96087], [-121.16915, 38.96346], [-121.17248, 38.96354], [-121.18199, 38.96348], [-121.19112, 38.96335], [-121.2006, 38.96332], [-121.20992, 38.96332], [-121.20989, 38.96696], [-121.20985, 38.96762], [-121.20985, 38.97062], [-121.20974, 38.97424], [-121.20966, 38.97782], [-121.20022, 38.97793], [-121.19116, 38.978], [-121.19131, 38.97085], [-121.18213, 38.97105]]], [[[-121.21912, 38.97648], [-121.21872, 38.97647], [-121.2185, 38.97649], [-121.21802, 38.97633], [-121.21801, 38.97634], [-121.21816, 38.97662], [-121.21813, 38.97665], [-121.2181, 38.97674], [-121.2181, 38.97683], [-121.21815, 38.97692], [-121.21826, 38.97706], [-121.21895, 38.97778], [-121.21443, 38.97778], [-121.21449, 38.97418], [-121.21911, 38.97416], [-121.21912, 38.97648]]]]} | Open Access 1 | 44942 | Hidden Falls Regional Park | 8647 | 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 | http://www.placer.ca.gov/departments/facility/parks/parks-content/parks/hidden-falls | Placer 35 | 1234.21 | Hidden Falls RP | 2006 | Local Park 2 | 4 |
9402 | 9402 | 9401 | {"type": "Polygon", "coordinates": [[[-123.4405, 39.05938], [-123.44049, 39.05965], [-123.44041, 39.05975], [-123.44021, 39.05983], [-123.43997, 39.0601], [-123.43987, 39.06018], [-123.43962, 39.06044], [-123.4395, 39.06053], [-123.43949, 39.06058], [-123.4393, 39.06079], [-123.43906, 39.06087], [-123.43892, 39.06095], [-123.43876, 39.06095], [-123.43795, 39.06072], [-123.43766, 39.0607], [-123.4375, 39.06076], [-123.43727, 39.06098], [-123.43715, 39.06109], [-123.43686, 39.06123], [-123.43655, 39.06093], [-123.43605, 39.06052], [-123.43589, 39.0604], [-123.43528, 39.06002], [-123.43639, 39.05958], [-123.43805, 39.05866], [-123.4405, 39.05938]]]} | Open Access 1 | 49017 | Indian Creek County Park | 33715 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/indian-creek | Mendocino 24 | 17.437 | Indian Creek County Park | 1973 | Local Park 2 | 4 |
15380 | 15380 | 15379 | {"type": "Polygon", "coordinates": [[[-123.4074, 39.00408], [-123.40742, 39.00624], [-123.40739, 39.00777], [-123.40276, 39.00769], [-123.40285, 39.004], [-123.4074, 39.00408]]]} | Open Access 1 | 49011 | Faulkner Park | 33709 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/faulkner-park | Mendocino 24 | 40.36 | Faulkner Park | 1930 | Local Park 2 | 4 |
7 | 7 | 6 | {"type": "Polygon", "coordinates": [[[-121.93881, 36.98905], [-121.93822, 36.98905], [-121.93821, 36.98875], [-121.93824, 36.98871], [-121.93853, 36.9887], [-121.93856, 36.98875], [-121.93875, 36.98872], [-121.93881, 36.98905]]]} | Open Access 1 | 28 | Richard Vessey Park | 24328 | 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.46 | Richard Vessey Park | 0 | Local Park 2 | 4 | |
9 | 9 | 8 | {"type": "Polygon", "coordinates": [[[-119.48323, 34.37952], [-119.48284, 34.37978], [-119.48215, 34.37935], [-119.48075, 34.37775], [-119.4785, 34.37584], [-119.47796, 34.37557], [-119.47746, 34.37548], [-119.47737, 34.37524], [-119.47812, 34.37527], [-119.47861, 34.37543], [-119.47887, 34.37564], [-119.47904, 34.37573], [-119.47969, 34.37544], [-119.48031, 34.37629], [-119.48123, 34.37728], [-119.48177, 34.37797], [-119.48233, 34.37854], [-119.48323, 34.37952]]]} | Open Access 1 | 36 | Rincon Beach Park | 24367 | 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 | 11.623 | Rincon Beach Park | 0 | Local Park 2 | 4 | |
24 | 24 | 23 | {"type": "Polygon", "coordinates": [[[-118.15573, 34.02499], [-118.1555, 34.02576], [-118.15546, 34.0258], [-118.15538, 34.02582], [-118.15475, 34.02568], [-118.15469, 34.02564], [-118.15468, 34.02558], [-118.1549, 34.02485], [-118.15494, 34.02481], [-118.15501, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} | Open Access 1 | 62 | Atlantic Avenue Park | 15674 | 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 | 1.951 | Atlantic Avenue Park | 0 | Local Park 2 | 4 | |
31 | 31 | 30 | {"type": "Polygon", "coordinates": [[[-120.44007, 34.65751], [-120.44003, 34.66064], [-120.4377, 34.66062], [-120.43735, 34.65839], [-120.43399, 34.65557], [-120.43409, 34.64948], [-120.43349, 34.64835], [-120.43323, 34.648], [-120.4329, 34.64769], [-120.43272, 34.64755], [-120.43252, 34.64742], [-120.43202, 34.64716], [-120.43205, 34.64698], [-120.43156, 34.64672], [-120.4313, 34.64654], [-120.43107, 34.64633], [-120.43086, 34.64611], [-120.43007, 34.64516], [-120.42988, 34.64496], [-120.42986, 34.6449], [-120.42988, 34.64483], [-120.43012, 34.64467], [-120.43121, 34.64405], [-120.43128, 34.64412], [-120.43217, 34.6436], [-120.43226, 34.6436], [-120.43589, 34.64992], [-120.4396, 34.65676], [-120.44007, 34.65751]]]} | Open Access 1 | 80 | River Park | 24416 | 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 | 123.418 | River Park | 0 | Local Park 2 | 4 | |
42 | 42 | 41 | {"type": "Polygon", "coordinates": [[[-121.8696, 36.54123], [-121.86858, 36.54357], [-121.8688, 36.54399], [-121.86843, 36.54483], [-121.86836, 36.54672], [-121.86702, 36.54676], [-121.86669, 36.54657], [-121.86686, 36.54615], [-121.86861, 36.54212], [-121.86807, 36.5408], [-121.86878, 36.54061], [-121.8696, 36.54123]]]} | Open Access 1 | 97 | Roach Canyon Park | 24474 | 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 | 15.0 | Roach Canyon Park | 0 | Local Park 2 | 4 | |
128 | 128 | 127 | {"type": "Polygon", "coordinates": [[[-120.6997, 35.75055], [-120.69948, 35.75185], [-120.69912, 35.7518], [-120.6989, 35.75166], [-120.69837, 35.75161], [-120.69849, 35.75083], [-120.69876, 35.75085], [-120.69881, 35.7505], [-120.6997, 35.75055]]]} | Open Access 1 | 394 | San Miguel Community Park | 24955 | 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 | 3.196 | San Miguel Community Park | 0 | Local Park 2 | 4 | |
142 | 142 | 141 | {"type": "MultiPolygon", "coordinates": [[[[-120.6245, 35.11002], [-120.62419, 35.11012], [-120.62312, 35.1078], [-120.62286, 35.1073], [-120.62239, 35.10649], [-120.62277, 35.10634], [-120.6229, 35.10654], [-120.62301, 35.10675], [-120.6245, 35.11002]]], [[[-120.62952, 35.12079], [-120.6292, 35.12089], [-120.62657, 35.11519], [-120.62426, 35.11027], [-120.62457, 35.11017], [-120.62699, 35.11532], [-120.62952, 35.12079]]]]} | Open Access 1 | 446 | Sand and Surf County Park | 25009 | 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 | 13.006 | Sand and Surf County Park | 0 | Local Park 2 | 4 | |
144 | 144 | 143 | {"type": "Polygon", "coordinates": [[[-121.97587, 36.97007], [-121.9757, 36.97077], [-121.97566, 36.97132], [-121.97552, 36.9716], [-121.97389, 36.9716], [-121.97365, 36.97101], [-121.9733, 36.97101], [-121.97331, 36.97038], [-121.97438, 36.97017], [-121.97457, 36.97011], [-121.97587, 36.97007]]]} | Open Access 1 | 363 | Brommer Park | 16416 | 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 | 7.663 | Brommer Park | 0 | Local Park 2 | 4 | |
160 | 160 | 159 | {"type": "Polygon", "coordinates": [[[-120.6906, 35.75373], [-120.68985, 35.75372], [-120.68986, 35.75288], [-120.69045, 35.75267], [-120.6906, 35.75373]]]} | Open Access 1 | 409 | San Miguel Staging Area Park | 24961 | 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 | 1.605 | San Miguel Staging Area Park | 0 | Local Park 2 | 4 | |
201 | 201 | 200 | {"type": "Polygon", "coordinates": [[[-121.97829, 37.0053], [-121.97809, 37.00576], [-121.97787, 37.00575], [-121.97787, 37.00548], [-121.97734, 37.00547], [-121.97737, 37.00514], [-121.97736, 37.00494], [-121.97733, 37.00482], [-121.97818, 37.00467], [-121.97826, 37.00495], [-121.97822, 37.00505], [-121.97829, 37.0053]]]} | Open Access 1 | 539 | Santa Cruz Gardens Park | 25063 | 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 | 1.786 | Santa Cruz Gardens Park | 0 | Local Park 2 | 4 | |
216 | 216 | 215 | {"type": "Polygon", "coordinates": [[[-121.81987, 36.97069], [-121.81931, 36.97091], [-121.81883, 36.97022], [-121.81864, 36.96998], [-121.81841, 36.96978], [-121.81822, 36.96964], [-121.81752, 36.96928], [-121.81814, 36.96853], [-121.81894, 36.96939], [-121.81987, 36.97069]]]} | Open Access 1 | 691 | Scott Park | 25203 | 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 | 4.268 | Scott Park | 0 | Local Park 2 | 4 | |
223 | 223 | 222 | {"type": "Polygon", "coordinates": [[[-120.30735, 34.60822], [-120.30677, 34.60853], [-120.30678, 34.60893], [-120.3056, 34.60813], [-120.30557, 34.6074], [-120.30189, 34.60527], [-120.30097, 34.60541], [-120.30098, 34.60492], [-120.30091, 34.60466], [-120.30062, 34.60438], [-120.30092, 34.60412], [-120.29991, 34.60337], [-120.29883, 34.60341], [-120.29874, 34.60326], [-120.29916, 34.60305], [-120.30017, 34.60306], [-120.301, 34.60348], [-120.30152, 34.60338], [-120.30129, 34.60386], [-120.30172, 34.60416], [-120.30208, 34.60463], [-120.30257, 34.60484], [-120.30301, 34.60488], [-120.30316, 34.60512], [-120.30339, 34.60529], [-120.30363, 34.60552], [-120.30404, 34.60552], [-120.30465, 34.60545], [-120.30514, 34.60554], [-120.30564, 34.6055], [-120.30565, 34.60574], [-120.306, 34.60603], [-120.30666, 34.60682], [-120.30735, 34.60822]]]} | Open Access 1 | 610 | Santa Rosa Park | 25134 | 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 | 24.322 | Santa Rosa Park | 0 | Local Park 2 | 4 | |
234 | 234 | 233 | {"type": "Polygon", "coordinates": [[[-119.29489, 35.98035], [-119.29292, 35.98036], [-119.2929, 35.97877], [-119.2929, 35.97629], [-119.29461, 35.97627], [-119.29478, 35.9767], [-119.29488, 35.977], [-119.29489, 35.98035]]]} | Open Access 1 | 752 | Pixley Park | 23756 | 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 | 19.73 | Pixley 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]);