units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,219 rows where MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 58
- Butte, County of 43
- Orange, County of 31
- El Dorado, County of 31
- Lake, County of 30
- San Diego, County of 28
- Santa Barbara, County of 19
- Monterey, County of 17
- Placer, County of 6
- San Bernardino, County of 6
- Kern, County of 6
- Riverside, County of 5
- San Luis Obispo, County of 4
- Ventura, County of 3
- San Joaquin, County of 3
- Stanislaus, County of 3
- Sacramento, County of 3
- Humboldt, County of 3
- Mendocino, County of 3
- Lassen, County of 3
- Contra Costa, County of 3
- Santa Cruz, County of 2
- Tulare, County of 2
- Fresno, County of 2
- Yolo, County of 2
- Tehama, County of 2
- Sutter, County of 2
- Calaveras, County of 2
- Imperial, County of 1
- Merced, County of 1
- …
DES_TP 21
- Local Park 137
- Local Other or Unknown 117
- Local Recreation Area 48
- Local Conservation Area 15
- Local Historic or Cultural Area 1
- National Recreation Area 1
- National Monument or Landmark 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
- None 1
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 334 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13271 | 13271 | 13270 | {"type": "Polygon", "coordinates": [[[-120.45861, 34.63105], [-120.4586, 34.6313], [-120.45841, 34.63139], [-120.45828, 34.63142], [-120.45798, 34.63146], [-120.45797, 34.63153], [-120.45768, 34.63151], [-120.45734, 34.63146], [-120.45735, 34.63104], [-120.45861, 34.63105]]]} | Unknown Access 4 | 35320 | Santa Barbara holding 11 | 25043 | 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 | 1.308 | Santa Barbara holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13276 | 13276 | 13275 | {"type": "Polygon", "coordinates": [[[-120.63883, 34.95912], [-120.63659, 34.95879], [-120.63662, 34.9577], [-120.6378, 34.9583], [-120.63834, 34.95875], [-120.63883, 34.95912]]]} | Open Access 1 | 45324 | Rancho Guadalupe Dunes | 24146 | 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.499 | Rancho Guadalupe Dunes | None 1151 | |||
13370 | 13370 | 13369 | {"type": "Polygon", "coordinates": [[[-117.64456, 33.55733], [-117.64456, 33.55832], [-117.64446, 33.55917], [-117.64411, 33.55996], [-117.64407, 33.55994], [-117.64408, 33.55991], [-117.64401, 33.55988], [-117.64398, 33.55992], [-117.64392, 33.55989], [-117.64387, 33.55995], [-117.64407, 33.56004], [-117.64406, 33.56007], [-117.64384, 33.55998], [-117.64352, 33.55741], [-117.64456, 33.55733]]]} | Open Access 1 | 35454 | Orange holding 11 | 23158 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.148 | Orange holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13371 | 13371 | 13370 | {"type": "Polygon", "coordinates": [[[-118.67954, 36.22615], [-118.66991, 36.22607], [-118.66963, 36.22235], [-118.67932, 36.2224], [-118.67954, 36.22615]]]} | Open Access 1 | 35455 | Tulare holding 1 | 26567 | 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 | 88.945 | Tulare holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13372 | 13372 | 13371 | {"type": "Polygon", "coordinates": [[[-117.63857, 33.57457], [-117.63787, 33.57431], [-117.63727, 33.57449], [-117.63726, 33.57438], [-117.63751, 33.574], [-117.63751, 33.57405], [-117.63754, 33.57408], [-117.63777, 33.57416], [-117.63788, 33.57415], [-117.63799, 33.57409], [-117.63806, 33.57413], [-117.63814, 33.57414], [-117.63825, 33.57418], [-117.63855, 33.57422], [-117.63857, 33.57457]]]} | Open Access 1 | 35456 | Orange holding 5 | 23172 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.869 | Orange holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13373 | 13373 | 13372 | {"type": "Polygon", "coordinates": [[[-117.63726, 33.57438], [-117.63727, 33.57449], [-117.63717, 33.57496], [-117.63702, 33.57514], [-117.63615, 33.57531], [-117.63567, 33.5756], [-117.63515, 33.57558], [-117.63505, 33.57537], [-117.63485, 33.57548], [-117.63422, 33.57516], [-117.63384, 33.57494], [-117.63357, 33.57506], [-117.63345, 33.57529], [-117.63341, 33.57524], [-117.63358, 33.57484], [-117.63367, 33.57479], [-117.63511, 33.57517], [-117.63594, 33.57518], [-117.63671, 33.5749], [-117.63726, 33.57438]]]} | Open Access 1 | 35457 | Orange holding 6 | 23173 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.925 | Orange holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13374 | 13374 | 13373 | {"type": "Polygon", "coordinates": [[[-118.16425, 34.20803], [-118.16421, 34.20806], [-118.16415, 34.20814], [-118.16402, 34.20843], [-118.16389, 34.20862], [-118.1638, 34.2087], [-118.16379, 34.20873], [-118.16361, 34.20889], [-118.1632, 34.20918], [-118.16302, 34.20934], [-118.16295, 34.20945], [-118.16292, 34.20946], [-118.16283, 34.20965], [-118.16273, 34.20979], [-118.16243, 34.21008], [-118.16238, 34.21009], [-118.1623, 34.21009], [-118.1622, 34.21004], [-118.16216, 34.20998], [-118.16216, 34.20979], [-118.16218, 34.2096], [-118.16225, 34.20936], [-118.16241, 34.20908], [-118.16248, 34.20891], [-118.16251, 34.20874], [-118.1625, 34.20838], [-118.16293, 34.208], [-118.16425, 34.20803]]]} | Open Access 1 | 35458 | Los Angeles holding 6 | 21493 | 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.183 | Los Angeles holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13375 | 13375 | 13374 | {"type": "Polygon", "coordinates": [[[-117.63554, 33.54852], [-117.63528, 33.54875], [-117.63505, 33.549], [-117.63502, 33.54901], [-117.63462, 33.54878], [-117.6346, 33.54874], [-117.63495, 33.54837], [-117.63516, 33.54819], [-117.63522, 33.5482], [-117.63553, 33.5485], [-117.63554, 33.54852]]]} | Open Access 1 | 35459 | Orange holding 7 | 23174 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.006 | Orange holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13376 | 13376 | 13375 | {"type": "Polygon", "coordinates": [[[-117.62419, 33.69092], [-117.62398, 33.69096], [-117.62396, 33.69093], [-117.62376, 33.69096], [-117.62351, 33.69104], [-117.62298, 33.69101], [-117.62301, 33.69097], [-117.62305, 33.69074], [-117.6231, 33.69026], [-117.62314, 33.69005], [-117.62321, 33.6899], [-117.62345, 33.6895], [-117.62353, 33.68947], [-117.62395, 33.68963], [-117.62408, 33.69006], [-117.62399, 33.69007], [-117.62398, 33.69008], [-117.62419, 33.69092]]]} | Open Access 1 | 35460 | Orange holding 8 | 23175 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.388 | Orange holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13377 | 13377 | 13376 | {"type": "Polygon", "coordinates": [[[-117.63832, 33.55179], [-117.63825, 33.55193], [-117.63806, 33.55195], [-117.63749, 33.55165], [-117.63722, 33.55113], [-117.63732, 33.55058], [-117.63776, 33.55016], [-117.63796, 33.55008], [-117.63803, 33.55011], [-117.63826, 33.55094], [-117.63832, 33.55179]]]} | Open Access 1 | 35462 | Orange holding 12 | 23159 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.606 | Orange holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13388 | 13388 | 13387 | {"type": "Polygon", "coordinates": [[[-121.53269, 39.46596], [-121.53184, 39.46602], [-121.5318, 39.46567], [-121.53264, 39.4656], [-121.53269, 39.46596]]]} | Open Access 1 | 36275 | Butte holding 2 | 16563 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.717 | Butte holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13438 | 13438 | 13437 | {"type": "Polygon", "coordinates": [[[-117.62881, 33.68711], [-117.62823, 33.68765], [-117.62818, 33.6877], [-117.62837, 33.68738], [-117.62838, 33.68717], [-117.62881, 33.68711]]]} | Open Access 1 | 35571 | Orange holding 2 | 23167 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.227 | Orange holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13439 | 13439 | 13438 | {"type": "Polygon", "coordinates": [[[-117.62942, 33.68702], [-117.62839, 33.68717], [-117.62837, 33.68738], [-117.62818, 33.6877], [-117.62813, 33.68775], [-117.62743, 33.68762], [-117.62754, 33.6872], [-117.6276, 33.68684], [-117.62873, 33.68685], [-117.62887, 33.68684], [-117.62926, 33.68677], [-117.6293, 33.6868], [-117.62942, 33.68702]]]} | Open Access 1 | 35572 | Orange holding 3 | 23170 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.452 | Orange holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13452 | 13452 | 13451 | {"type": "Polygon", "coordinates": [[[-121.05734, 38.6586], [-121.05697, 38.65922], [-121.05661, 38.65869], [-121.05709, 38.65863], [-121.05734, 38.6586]]]} | Open Access 1 | 35646 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.505 | RP | 0 | Local Park 2 | 4 | |
13454 | 13454 | 13453 | {"type": "Polygon", "coordinates": [[[-116.39879, 33.82366], [-116.39697, 33.82366], [-116.39696, 33.82193], [-116.39701, 33.82189], [-116.39701, 33.82177], [-116.39697, 33.82173], [-116.39696, 33.8216], [-116.39701, 33.82156], [-116.39701, 33.82145], [-116.39697, 33.82139], [-116.39697, 33.82105], [-116.39702, 33.821], [-116.39702, 33.82089], [-116.39697, 33.82084], [-116.39697, 33.8205], [-116.39702, 33.82045], [-116.39701, 33.82032], [-116.39697, 33.82028], [-116.39698, 33.82013], [-116.39701, 33.8201], [-116.39879, 33.8201], [-116.39879, 33.82366]]]} | Restricted Access 2 | 35667 | Thousand Palms Community Park | 31650 | 2318 | Palm Springs Unified School District 1058 | Special District 4 | School District 14 | http://www.psusd.us/ | Special District 4 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 16.4 | Thousand Palms Community Park | 0 | Local Park 2 | 4 | |
13458 | 13458 | 13457 | {"type": "Polygon", "coordinates": [[[-118.16322, 34.20967], [-118.16308, 34.21031], [-118.16183, 34.21032], [-118.1618, 34.20908], [-118.16226, 34.2091], [-118.16218, 34.20921], [-118.16211, 34.20936], [-118.16205, 34.20959], [-118.16203, 34.20973], [-118.16203, 34.21], [-118.16209, 34.2101], [-118.1622, 34.21018], [-118.16229, 34.2102], [-118.1624, 34.2102], [-118.16254, 34.21015], [-118.16284, 34.20986], [-118.16294, 34.20972], [-118.16298, 34.20963], [-118.16322, 34.20967]]]} | Open Access 1 | 35757 | Los Angeles holding 7 | 21494 | 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.731 | Los Angeles holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13478 | 13478 | 13477 | {"type": "Polygon", "coordinates": [[[-117.63733, 33.55174], [-117.6369, 33.55204], [-117.63667, 33.55227], [-117.63653, 33.55225], [-117.63645, 33.55234], [-117.63651, 33.55243], [-117.63629, 33.55265], [-117.63566, 33.55222], [-117.63428, 33.55282], [-117.63399, 33.55224], [-117.6338, 33.55163], [-117.63384, 33.55152], [-117.63396, 33.55146], [-117.63704, 33.55126], [-117.63716, 33.55152], [-117.63733, 33.55174]]]} | Open Access 1 | 35756 | Orange holding 13 | 23160 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 8.81 | Orange holding 13 | 0 | Local Other or Unknown 14 | 4 | |
13480 | 13480 | 13479 | {"type": "Polygon", "coordinates": [[[-118.61573, 34.06931], [-118.61507, 34.06932], [-118.61506, 34.06843], [-118.61534, 34.06856], [-118.6155, 34.0687], [-118.61554, 34.06878], [-118.61559, 34.06896], [-118.61573, 34.06931]]]} | Open Access 1 | 35764 | Los Angeles holding 10 | 21485 | 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.032 | Los Angeles holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13481 | 13481 | 13480 | {"type": "Polygon", "coordinates": [[[-118.16406, 34.20859], [-118.16399, 34.20877], [-118.16379, 34.20908], [-118.16333, 34.20952], [-118.16322, 34.20967], [-118.16298, 34.20963], [-118.16307, 34.20948], [-118.16318, 34.20935], [-118.16368, 34.20899], [-118.16383, 34.20886], [-118.16406, 34.20859]]]} | Open Access 1 | 35765 | Los Angeles holding 11 | 21486 | 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 | 0.54 | Los Angeles holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13482 | 13482 | 13481 | {"type": "Polygon", "coordinates": [[[-117.64438, 33.54846], [-117.64365, 33.54864], [-117.64349, 33.5483], [-117.64349, 33.54828], [-117.64352, 33.54825], [-117.64417, 33.54807], [-117.64421, 33.54807], [-117.64424, 33.5481], [-117.64438, 33.54846]]]} | Open Access 1 | 35767 | Orange holding 17 | 23164 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.821 | Orange holding 17 | 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]);