units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
118 rows where AGNCY_NAME = 7 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, MNG_AG_LEV, PARK_URL, YR_EST, GAP_STS
DES_TP 19
- Local Park 40
- Local Other or Unknown 39
- Local Recreation Area 18
- 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
ACCESS_TYP 3
- Open Access 104
- Unknown Access 13
- No Public Access 1
MNG_AG_TYP 2
- County Agency 117
- City Agency 1
MNG_AGENCY 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4017 | 4017 | 4016 | {"type": "Polygon", "coordinates": [[[-120.42732, 34.97528], [-120.42699, 34.97526], [-120.42685, 34.97536], [-120.42682, 34.97661], [-120.42664, 34.97662], [-120.42664, 34.97691], [-120.42404, 34.97697], [-120.42397, 34.97488], [-120.42711, 34.97493], [-120.42732, 34.97528]]]} | Open Access 1 | 48887 | Jim May Park | 33608 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | https://www.cityofsantamaria.org/city-government/departments/recreation-and-parks/visit-your-parks/view-park-photos-descriptions#Jim%20May%20Park | Santa Barbara 7 | 14.607 | Jim May Park | 0 | Local Park 2 | 4 |
3487 | 3487 | 3486 | {"type": "Polygon", "coordinates": [[[-120.42216, 34.84972], [-120.42192, 34.85046], [-120.42153, 34.85094], [-120.42161, 34.85109], [-120.42151, 34.85123], [-120.42113, 34.85129], [-120.42097, 34.852], [-120.4202, 34.85238], [-120.42045, 34.85272], [-120.42027, 34.85283], [-120.41993, 34.85247], [-120.41927, 34.85288], [-120.41925, 34.85304], [-120.41877, 34.85301], [-120.4185, 34.85298], [-120.41851, 34.85295], [-120.41878, 34.85272], [-120.41876, 34.85243], [-120.41873, 34.85237], [-120.41785, 34.85177], [-120.41792, 34.85149], [-120.41769, 34.85134], [-120.41774, 34.85092], [-120.4174, 34.85061], [-120.41773, 34.85045], [-120.41787, 34.85016], [-120.41891, 34.85012], [-120.41919, 34.84959], [-120.4196, 34.84947], [-120.42048, 34.84963], [-120.42153, 34.84925], [-120.422, 34.8495], [-120.42216, 34.84972]]]} | Open Access 1 | 48769 | Orcutt Community Park | 33496 | 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 | https://www.countyofsb.org/parks/asset.c/581 | Santa Barbara 7 | 26.01 | Orcutt Community Park | 0 | Local Park 2 | 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 | |||
4670 | 4670 | 4669 | {"type": "Polygon", "coordinates": [[[-119.71071, 34.46336], [-119.71044, 34.46387], [-119.70993, 34.46387], [-119.70994, 34.46337], [-119.71071, 34.46336]]]} | Open Access 1 | 36623 | 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.807 | 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 | ||
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 | ||
4655 | 4655 | 4654 | {"type": "Polygon", "coordinates": [[[-120.18416, 34.61062], [-120.18194, 34.61163], [-120.18168, 34.61167], [-120.18165, 34.61156], [-120.18189, 34.61153], [-120.18407, 34.61053], [-120.18416, 34.61062]]]} | Open Access 1 | 36568 | 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.766 | 0 | Local Other or Unknown 14 | 4 | ||
4654 | 4654 | 4653 | {"type": "Polygon", "coordinates": [[[-120.42629, 34.86984], [-120.42629, 34.87058], [-120.42539, 34.87059], [-120.42539, 34.86983], [-120.42629, 34.86984]]]} | Open Access 1 | 36567 | 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 | 1.686 | 0 | Local Other or Unknown 14 | 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 | ||
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 | ||
4651 | 4651 | 4650 | {"type": "Polygon", "coordinates": [[[-120.42212, 34.86173], [-120.42211, 34.86232], [-120.41957, 34.86066], [-120.41894, 34.86066], [-120.41894, 34.86], [-120.41957, 34.86001], [-120.41994, 34.86023], [-120.42093, 34.86118], [-120.42212, 34.86173]]]} | Open Access 1 | 36564 | 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.39 | 0 | Local Other or Unknown 14 | 4 | ||
4649 | 4649 | 4648 | {"type": "Polygon", "coordinates": [[[-120.41141, 34.87986], [-120.41097, 34.87998], [-120.41078, 34.88006], [-120.41065, 34.88015], [-120.41051, 34.88028], [-120.41044, 34.88037], [-120.41039, 34.88048], [-120.41036, 34.88065], [-120.41036, 34.88075], [-120.4104, 34.88096], [-120.41046, 34.88113], [-120.41054, 34.8813], [-120.41141, 34.88251], [-120.40984, 34.88064], [-120.40981, 34.87972], [-120.41134, 34.87967], [-120.41141, 34.87986]]]} | Open Access 1 | 36561 | 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 | 2.987 | 0 | Local Other or Unknown 14 | 4 | ||
15467 | 15467 | 15466 | {"type": "Polygon", "coordinates": [[[-119.71114, 34.46263], [-119.7109, 34.46311], [-119.70995, 34.46314], [-119.70997, 34.46221], [-119.71104, 34.46218], [-119.71114, 34.46263]]]} | Open Access 1 | 36559 | 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 | 2.578 | 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 | ||
15463 | 15463 | 15462 | {"type": "Polygon", "coordinates": [[[-119.79849, 34.44828], [-119.79718, 34.44828], [-119.79717, 34.44776], [-119.79691, 34.44741], [-119.79692, 34.44733], [-119.79713, 34.44713], [-119.79773, 34.44715], [-119.79804, 34.44701], [-119.79807, 34.44705], [-119.79777, 34.4472], [-119.79849, 34.44828]]]} | Open Access 1 | 36555 | 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 | 2.992 | 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 | |
15462 | 15462 | 15461 | {"type": "Polygon", "coordinates": [[[-119.7985, 34.44828], [-119.79829, 34.44848], [-119.79825, 34.44887], [-119.79785, 34.44906], [-119.79743, 34.4492], [-119.79721, 34.44922], [-119.79721, 34.44845], [-119.7972, 34.44828], [-119.7985, 34.44828]]]} | Open Access 1 | 36552 | 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 | 2.181 | 0 | Local Other or Unknown 14 | 4 | ||
15436 | 15436 | 15435 | {"type": "Polygon", "coordinates": [[[-119.71104, 34.46218], [-119.70997, 34.4622], [-119.71005, 34.46101], [-119.71021, 34.46101], [-119.71049, 34.46161], [-119.71092, 34.46166], [-119.71104, 34.46218]]]} | Open Access 1 | 36550 | 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 | 1.9 | 0 | Local Other or Unknown 14 | 4 | ||
15459 | 15459 | 15458 | {"type": "Polygon", "coordinates": [[[-120.42776, 34.86205], [-120.42752, 34.86223], [-120.4262, 34.86092], [-120.42656, 34.86071], [-120.42734, 34.86163], [-120.42742, 34.8617], [-120.42755, 34.86174], [-120.42752, 34.86183], [-120.42776, 34.86205]]]} | Open Access 1 | 36549 | 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 | 1.547 | 0 | Local Other or Unknown 14 | 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 |
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]);