units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
119 rows where MNG_AGENCY = 7 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
DES_TP 19
- Local Park 40
- Local Other or Unknown 39
- Local Recreation Area 19
- Local Conservation Area 5
- Local Historic or Cultural Area 2
- National Forest 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
PARK_URL 6 ✖
- https://www.countyofsb.org/parks/parks02.aspx?id=13422 2
- http://cosb.countyofsb.org/parks/parks03.aspx?id=13252 1
- http://cosb.countyofsb.org/parks/parks03.aspx?id=13402 1
- http://cosb.countyofsb.org/parks/parks03.aspx?id=13428 1
- http://cosb.countyofsb.org/parks/parks03.aspx?id=13434 1
- https://www.countyofsb.org/parks/asset.c/581 1
ACCESS_TYP 3
- Open Access 105
- Unknown Access 13
- No Public Access 1
MNG_AG_TYP 1
- County Agency 119
MNG_AGENCY 1
- Santa Barbara, County of · 119 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
15465 | 15465 | 15464 | {"type": "Polygon", "coordinates": [[[-119.80649, 34.43933], [-119.80631, 34.43932], [-119.80632, 34.43914], [-119.80623, 34.43901], [-119.80633, 34.43899], [-119.80637, 34.43904], [-119.80649, 34.43933]]]} | Open Access 1 | 36557 | 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.103 | 0 | Local Other or Unknown 14 | 4 | ||
9804 | 9804 | 9803 | {"type": "Polygon", "coordinates": [[[-119.82652, 34.43735], [-119.82651, 34.43749], [-119.82615, 34.43748], [-119.82615, 34.43734], [-119.82652, 34.43735]]]} | Open Access 1 | 18096 | Nectarine Mini Park | 22682 | 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.13 | Nectarine MP | 0 | Local Park 2 | 4 | |
4648 | 4648 | 4647 | {"type": "Polygon", "coordinates": [[[-119.88526, 34.44186], [-119.88488, 34.44185], [-119.88421, 34.44177], [-119.88526, 34.44175], [-119.88526, 34.44186]]]} | Open Access 1 | 36547 | 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.183 | 0 | Local Other or Unknown 14 | 4 | ||
15470 | 15470 | 15469 | {"type": "Polygon", "coordinates": [[[-120.18038, 34.61185], [-120.17973, 34.61194], [-120.17955, 34.61197], [-120.17963, 34.61185], [-120.18036, 34.61174], [-120.18038, 34.61185]]]} | Open Access 1 | 36571 | 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.219 | 0 | Local Other or Unknown 14 | 4 | ||
10361 | 10361 | 10360 | {"type": "Polygon", "coordinates": [[[-120.11686, 34.66391], [-120.11686, 34.66443], [-120.11666, 34.66443], [-120.11667, 34.6639], [-120.11686, 34.66391]]]} | Open Access 1 | 18384 | Alamo Pintado Creek | 15318 | 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.262 | Alamo Pintado Creek | 0 | Local Other or Unknown 14 | 4 | |
15474 | 15474 | 15473 | {"type": "Polygon", "coordinates": [[[-120.18167, 34.61167], [-120.18058, 34.61182], [-120.18055, 34.61172], [-120.18165, 34.61156], [-120.18167, 34.61167]]]} | Open Access 1 | 36578 | 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.307 | 0 | Local Other or Unknown 14 | 4 | ||
4642 | 4642 | 4641 | {"type": "Polygon", "coordinates": [[[-119.78178, 34.43221], [-119.78161, 34.43233], [-119.78143, 34.43249], [-119.78137, 34.43253], [-119.78129, 34.43254], [-119.78124, 34.43252], [-119.78118, 34.43247], [-119.78115, 34.43241], [-119.78114, 34.43234], [-119.78116, 34.43228], [-119.7812, 34.43223], [-119.78127, 34.4322], [-119.78176, 34.43218], [-119.78178, 34.43221]]]} | Open Access 1 | 36491 | 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.349 | 0 | Local Other or Unknown 14 | 4 | ||
4652 | 4652 | 4651 | {"type": "Polygon", "coordinates": [[[-120.41955, 34.86001], [-120.41894, 34.86], [-120.41895, 34.85937], [-120.4194, 34.85991], [-120.41955, 34.86001]]]} | Open Access 1 | 36565 | 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.425 | 0 | Local Other or Unknown 14 | 4 | ||
4643 | 4643 | 4642 | {"type": "Polygon", "coordinates": [[[-119.80253, 34.43606], [-119.80222, 34.43595], [-119.80231, 34.43586], [-119.80236, 34.43578], [-119.8024, 34.43562], [-119.8024, 34.43546], [-119.80231, 34.43516], [-119.80231, 34.43506], [-119.80235, 34.43503], [-119.80253, 34.43503], [-119.80253, 34.43606]]]} | Open Access 1 | 36492 | 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.462 | 0 | Local Other or Unknown 14 | 4 | ||
8900 | 8900 | 8899 | {"type": "Polygon", "coordinates": [[[-119.87867, 34.42332], [-119.87847, 34.42368], [-119.87808, 34.42365], [-119.87803, 34.42368], [-119.87799, 34.42375], [-119.878, 34.42402], [-119.87795, 34.42403], [-119.87793, 34.42372], [-119.87812, 34.42327], [-119.87829, 34.42335], [-119.87847, 34.42349], [-119.87865, 34.42326], [-119.87867, 34.42332]]]} | Open Access 1 | 14564 | Armstrong Mini Park | 15594 | 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.463 | Armstrong MP | 0 | Local Park 2 | 4 | |
4574 | 4574 | 4573 | {"type": "Polygon", "coordinates": [[[-120.41847, 34.87892], [-120.41847, 34.87914], [-120.41845, 34.87917], [-120.41794, 34.87923], [-120.41794, 34.87885], [-120.418, 34.87884], [-120.41807, 34.8788], [-120.41847, 34.87892]]]} | No Public Access 3 | 35227 | Unnamed site - Santa Barbara, County of | 28691 | 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.465 | 0 | Local Other or Unknown 14 | 4 | ||
133 | 133 | 132 | {"type": "Polygon", "coordinates": [[[-119.74246, 34.44054], [-119.74244, 34.44072], [-119.74241, 34.44073], [-119.74215, 34.44091], [-119.74194, 34.44113], [-119.74168, 34.44129], [-119.74157, 34.44128], [-119.7414, 34.44128], [-119.74181, 34.44101], [-119.74204, 34.44079], [-119.74227, 34.44062], [-119.74234, 34.44054], [-119.74246, 34.44054]]]} | Unknown Access 4 | 414 | San Roque Creek | 24990 | 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.477 | San Roque Creek | 0 | Local Other or Unknown 14 | 4 | |
2224 | 2224 | 2223 | {"type": "MultiPolygon", "coordinates": [[[[-119.78067, 34.4404], [-119.78035, 34.4404], [-119.78034, 34.44016], [-119.78067, 34.44016], [-119.78067, 34.4404]]], [[[-119.78168, 34.43949], [-119.78168, 34.4396], [-119.78068, 34.4396], [-119.78068, 34.43949], [-119.78168, 34.43949]]]]} | Open Access 1 | 16611 | Goleta Cemetery | 19380 | 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.487 | Goleta Cemetery | 0 | Local Historic or Cultural Area 19 | 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 | ||
9587 | 9587 | 9586 | {"type": "Polygon", "coordinates": [[[-120.45155, 34.63055], [-120.45154, 34.63089], [-120.45128, 34.63077], [-120.45087, 34.63037], [-120.45125, 34.63029], [-120.45155, 34.63055]]]} | Open Access 1 | 17395 | Lompoc Cemetery | 21418 | 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.518 | Lompoc Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
4644 | 4644 | 4643 | {"type": "Polygon", "coordinates": [[[-120.42602, 34.86014], [-120.42568, 34.86014], [-120.42519, 34.85941], [-120.42519, 34.85919], [-120.4253, 34.85927], [-120.42583, 34.85995], [-120.42602, 34.86014]]]} | Open Access 1 | 36495 | 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.558 | 0 | Local Other or Unknown 14 | 4 | ||
9791 | 9791 | 9790 | {"type": "Polygon", "coordinates": [[[-120.14736, 34.60188], [-120.14677, 34.60214], [-120.14633, 34.60186], [-120.1463, 34.60186], [-120.1463, 34.60182], [-120.14633, 34.60183], [-120.14665, 34.6018], [-120.14665, 34.60173], [-120.14672, 34.60171], [-120.14701, 34.60175], [-120.14726, 34.60186], [-120.14736, 34.60188]]]} | Open Access 1 | 16735 | Hans Christian Andersen Park | 19646 | 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.566 | Hans Christian Andersen Park | 0 | Local Park 2 | 4 | |
4653 | 4653 | 4652 | {"type": "Polygon", "coordinates": [[[-120.42656, 34.86071], [-120.4262, 34.86092], [-120.42568, 34.86014], [-120.42602, 34.86015], [-120.42622, 34.86031], [-120.42656, 34.86071]]]} | Open Access 1 | 36566 | 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.748 | 0 | Local Other or Unknown 14 | 4 | ||
13938 | 13938 | 13937 | {"type": "Polygon", "coordinates": [[[-119.79733, 34.4284], [-119.79733, 34.42843], [-119.79698, 34.42842], [-119.79697, 34.42853], [-119.79653, 34.42852], [-119.79656, 34.42798], [-119.79693, 34.42778], [-119.79699, 34.42786], [-119.79698, 34.42839], [-119.79733, 34.4284]]]} | Open Access 1 | 36554 | Rhoads Open Space | 28548 | 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.759 | Rhoads OS | 0 | Local Recreation Area 3 | 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]);