superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
89 rows where MNG_AGENCY = 7 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6245 | 6245 | 6244 | {"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 | Nectarine Mini Park | 22682 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.13 | Nectarine MP | ||
1117 | 1117 | 1116 | {"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 | Alamo Pintado Creek | 15318 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.262 | Alamo Pintado Creek | ||
1575 | 1575 | 1574 | {"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 | Armstrong Mini Park | 15594 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.465 | Armstrong MP | ||
14307 | 14307 | 14306 | {"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 | 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 | 0.465 | |||
9256 | 9256 | 9255 | {"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 | San Roque Creek | 24990 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.477 | San Roque Creek | ||
4647 | 4647 | 4646 | {"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 | Goleta Cemetery | 19380 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.486 | Goleta Cemetery | ||
6334 | 6334 | 6333 | {"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 | Lompoc Cemetery | 21418 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.518 | Lompoc Cemetery | ||
3913 | 3913 | 3912 | {"type": "Polygon", "coordinates": [[[-120.14736, 34.60188], [-120.14677, 34.60214], [-120.14634, 34.60186], [-120.1463, 34.60186], [-120.1463, 34.60182], [-120.14633, 34.60183], [-120.14664, 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 | Hans Christian Andersen Park | 19646 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.567 | Hans Christian Andersen Park | ||
1354 | 1354 | 1353 | {"type": "Polygon", "coordinates": [[[-119.88382, 34.43947], [-119.88316, 34.43948], [-119.88316, 34.43906], [-119.88317, 34.43903], [-119.8832, 34.43902], [-119.88379, 34.43902], [-119.88381, 34.43905], [-119.88382, 34.43947]]]} | Open Access 1 | Bella Vista III | 15978 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.76 | Bella Vista III | ||
9990 | 9990 | 9989 | {"type": "MultiPolygon", "coordinates": [[[[-119.8405, 34.44897], [-119.84028, 34.44897], [-119.84023, 34.44897], [-119.84042, 34.44887], [-119.8405, 34.44897]]], [[[-119.84221, 34.45083], [-119.84133, 34.45085], [-119.84133, 34.45014], [-119.84133, 34.45014], [-119.84221, 34.45083]]]]} | Open Access 1 | Stonebridge Park | 25879 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.819 | Stonebridge Park | ||
14969 | 14969 | 14968 | {"type": "Polygon", "coordinates": [[[-119.80222, 34.43559], [-119.8022, 34.43567], [-119.80216, 34.43575], [-119.8021, 34.43582], [-119.80202, 34.43587], [-119.80193, 34.4359], [-119.80149, 34.43595], [-119.80136, 34.43599], [-119.80122, 34.43578], [-119.80125, 34.43551], [-119.80131, 34.4355], [-119.80138, 34.43544], [-119.80144, 34.43543], [-119.80151, 34.43544], [-119.80176, 34.43554], [-119.80189, 34.43557], [-119.80203, 34.43557], [-119.80218, 34.43556], [-119.80222, 34.43559]]]} | Open Access 1 | Thunderbird Open Space | 28546 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.941 | Thunderbird OS | ||
4581 | 4581 | 4580 | {"type": "Polygon", "coordinates": [[[-119.87288, 34.43682], [-119.8723, 34.43682], [-119.87211, 34.43668], [-119.872, 34.43654], [-119.87193, 34.43639], [-119.8719, 34.43628], [-119.87195, 34.43605], [-119.87205, 34.43605], [-119.87221, 34.43614], [-119.87248, 34.4365], [-119.87277, 34.43651], [-119.87288, 34.43682]]]} | Open Access 1 | Glen Annie at Del Norte | 19314 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 0.988 | Glen Annie at Del Norte | ||
8068 | 8068 | 8067 | {"type": "Polygon", "coordinates": [[[-119.85595, 34.4093], [-119.85537, 34.40921], [-119.85537, 34.40853], [-119.85595, 34.40862], [-119.85595, 34.4093]]]} | Open Access 1 | Pelican Park | 23568 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.002 | Pelican Park | ||
3681 | 3681 | 3680 | {"type": "Polygon", "coordinates": [[[-119.74281, 34.40401], [-119.74274, 34.40423], [-119.74231, 34.40436], [-119.7421, 34.40437], [-119.74078, 34.40476], [-119.7407, 34.40454], [-119.74281, 34.40401]]]} | Open Access 1 | Douglas Family Reserve | 18242 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.079 | Douglas Family Reserve | ||
11312 | 11312 | 11311 | {"type": "Polygon", "coordinates": [[[-119.89552, 34.4344], [-119.89508, 34.43471], [-119.89486, 34.4345], [-119.89513, 34.43431], [-119.89512, 34.43381], [-119.89489, 34.4336], [-119.8955, 34.43359], [-119.89552, 34.4344]]]} | Open Access 1 | Winchester I Park | 27619 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.141 | Winchester I Park | ||
10240 | 10240 | 10239 | {"type": "Polygon", "coordinates": [[[-120.4206, 34.85883], [-120.42009, 34.85944], [-120.41983, 34.85913], [-120.41982, 34.85851], [-120.42033, 34.85851], [-120.42034, 34.85866], [-120.4206, 34.85883]]]} | Open Access 1 | Domino Open Space | http://cosb.countyofsb.org/parks/parks03.aspx?id=13428 | 28582 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.162 | Domino OS | |
7917 | 7917 | 7916 | {"type": "Polygon", "coordinates": [[[-119.52661, 34.41577], [-119.52628, 34.41577], [-119.52622, 34.41481], [-119.52623, 34.41435], [-119.5263, 34.41401], [-119.52657, 34.41394], [-119.52646, 34.41475], [-119.52646, 34.41518], [-119.52661, 34.41577]]]} | Open Access 1 | Santa Monica Creek | 25116 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.173 | Santa Monica Creek | ||
11313 | 11313 | 11312 | {"type": "Polygon", "coordinates": [[[-119.89864, 34.43647], [-119.89778, 34.43649], [-119.89777, 34.43593], [-119.89862, 34.43591], [-119.89864, 34.43647]]]} | Open Access 1 | Winchester II Park | 27620 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.21 | Winchester II Park | ||
9432 | 9432 | 9431 | {"type": "Polygon", "coordinates": [[[-119.86649, 34.40896], [-119.86649, 34.40971], [-119.86582, 34.40971], [-119.86582, 34.40896], [-119.86649, 34.40896]]]} | Open Access 1 | Sea Lookout Park | 25234 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.287 | Sea Lookout Park | ||
9287 | 9287 | 9286 | {"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 | Santa Barbara holding 11 | 25043 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 1.308 | Santa Barbara holding 11 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);