units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
119 rows where MNG_AGENCY = 7 and MNG_AG_LEV = 3 sorted by YR_EST
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
581 | 581 | 580 | {"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 | 1936 | Winchester II Park | 27620 | 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.211 | Winchester II Park | 0 | Local Park 2 | 4 | |
1618 | 1618 | 1617 | {"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 | 13836 | Douglas Family Reserve | 18242 | 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.079 | Douglas Family Reserve | 0 | Local Conservation Area 4 | 2 | |
2133 | 2133 | 2132 | {"type": "Polygon", "coordinates": [[[-120.28032, 34.72943], [-120.27999, 34.73522], [-120.27985, 34.73547], [-120.27962, 34.73577], [-120.27927, 34.73609], [-120.27919, 34.7362], [-120.27913, 34.73638], [-120.27913, 34.73661], [-120.27911, 34.73676], [-120.27899, 34.737], [-120.27896, 34.73714], [-120.27897, 34.73734], [-120.27902, 34.73748], [-120.27907, 34.73756], [-120.27918, 34.73766], [-120.27946, 34.73785], [-120.27655, 34.73782], [-120.27684, 34.73708], [-120.27732, 34.7367], [-120.27772, 34.73627], [-120.27788, 34.7359], [-120.2781, 34.73554], [-120.27827, 34.7354], [-120.27869, 34.73489], [-120.27877, 34.7347], [-120.2786, 34.73459], [-120.27812, 34.7342], [-120.27848, 34.7338], [-120.27922, 34.73374], [-120.27939, 34.73358], [-120.27945, 34.73338], [-120.27947, 34.73311], [-120.27926, 34.73286], [-120.27885, 34.73253], [-120.27534, 34.73122], [-120.27619, 34.73006], [-120.27721, 34.72949], [-120.27919, 34.72923], [-120.28032, 34.72943]]]} | Open Access 1 | 17411 | Los Alamos Park | 21472 | 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 | 49.94 | Los Alamos Park | 0 | Local Park 2 | 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 | |
2429 | 2429 | 2428 | {"type": "Polygon", "coordinates": [[[-119.73275, 34.45416], [-119.73256, 34.45495], [-119.73033, 34.45569], [-119.73131, 34.45385], [-119.73248, 34.45385], [-119.73275, 34.45416]]]} | Open Access 1 | 17293 | Lauro Canyon Reservoir | 33319 | 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 | 6.232 | Lauro Canyon Reservoir | 0 | Local Recreation Area 3 | 4 | |
2465 | 2465 | 2464 | {"type": "Polygon", "coordinates": [[[-119.60451, 34.42018], [-119.60401, 34.42022], [-119.60381, 34.42025], [-119.6035, 34.42034], [-119.60326, 34.42037], [-119.60294, 34.42044], [-119.60259, 34.42056], [-119.60257, 34.42054], [-119.60186, 34.42055], [-119.60192, 34.42063], [-119.60149, 34.42059], [-119.6015, 34.42054], [-119.60119, 34.42046], [-119.60115, 34.42057], [-119.60107, 34.42054], [-119.6011, 34.42044], [-119.60054, 34.42031], [-119.60027, 34.41974], [-119.59999, 34.41968], [-119.6, 34.4196], [-119.59979, 34.41952], [-119.5994, 34.41953], [-119.59921, 34.41946], [-119.5993, 34.41913], [-119.60007, 34.41924], [-119.60003, 34.4195], [-119.60215, 34.41991], [-119.60216, 34.42013], [-119.60228, 34.42012], [-119.60228, 34.41991], [-119.60362, 34.41996], [-119.60381, 34.41998], [-119.60451, 34.41995], [-119.60451, 34.42018]]]} | Open Access 1 | 17402 | Lookout Park and Beach | 21461 | 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 | 6.582 | Lookout Park and Beach | 0 | Local Park 2 | 4 | |
2498 | 2498 | 2497 | {"type": "MultiPolygon", "coordinates": [[[[-119.63205, 34.43527], [-119.631, 34.43526], [-119.63141, 34.43312], [-119.63141, 34.43311], [-119.63134, 34.4331], [-119.63134, 34.43283], [-119.63179, 34.43283], [-119.6318, 34.43303], [-119.63183, 34.43323], [-119.63201, 34.43386], [-119.63205, 34.43527]]], [[[-119.63427, 34.43281], [-119.63426, 34.43526], [-119.63224, 34.43526], [-119.63225, 34.43427], [-119.63336, 34.43427], [-119.63339, 34.43368], [-119.63328, 34.43339], [-119.63369, 34.43334], [-119.63417, 34.43334], [-119.63418, 34.43281], [-119.63427, 34.43281]]]]} | Open Access 1 | 17533 | Manning Park | 21754 | 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.812 | Manning Park | 0 | Local Park 2 | 4 | |
2555 | 2555 | 2554 | {"type": "Polygon", "coordinates": [[[-120.47151, 34.59209], [-120.4715, 34.59302], [-120.4694, 34.59376], [-120.46933, 34.59299], [-120.47003, 34.59241], [-120.47066, 34.59232], [-120.47151, 34.59209]]]} | Open Access 1 | 17819 | Miguelito County Park | 22211 | 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 | 5.367 | Miguelito County Park | 0 | Local Park 2 | 4 | |
2615 | 2615 | 2614 | {"type": "Polygon", "coordinates": [[[-119.80483, 34.42522], [-119.80482, 34.42554], [-119.80247, 34.42582], [-119.8009, 34.42611], [-119.80039, 34.42613], [-119.79935, 34.42613], [-119.79881, 34.42614], [-119.79835, 34.42616], [-119.7981, 34.4262], [-119.79785, 34.42626], [-119.79761, 34.42634], [-119.79738, 34.42644], [-119.79607, 34.42714], [-119.7965, 34.42603], [-119.7965, 34.42592], [-119.79466, 34.42424], [-119.801, 34.42408], [-119.80117, 34.42409], [-119.80132, 34.42412], [-119.80156, 34.4242], [-119.80248, 34.42446], [-119.80249, 34.4255], [-119.80483, 34.42522]]]} | Open Access 1 | 17990 | More Mesa Open Space | 22473 | 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 | 36.882 | More Mesa OS | 0 | Local Recreation Area 3 | 4 | |
2653 | 2653 | 2652 | {"type": "Polygon", "coordinates": [[[-120.1819, 34.5326], [-120.18188, 34.5355], [-120.18164, 34.53547], [-120.17751, 34.53436], [-120.17561, 34.53522], [-120.1757, 34.53333], [-120.1755, 34.53184], [-120.17499, 34.53056], [-120.17342, 34.52986], [-120.17345, 34.52719], [-120.17782, 34.5272], [-120.17762, 34.53254], [-120.1819, 34.5326]]]} | Open Access 1 | 18125 | Nojoqui Falls County Park | 22783 | 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 | 83.478 | Nojoqui Falls County Park | 0 | Local Park 2 | 4 | |
2687 | 2687 | 2686 | {"type": "MultiPolygon", "coordinates": [[[[-120.60154, 34.69034], [-120.60044, 34.69224], [-120.59668, 34.69152], [-120.59741, 34.68786], [-120.60038, 34.68829], [-120.60154, 34.69034]]], [[[-120.60536, 34.68376], [-120.60493, 34.6845], [-120.60463, 34.68438], [-120.60507, 34.68364], [-120.60536, 34.68376]]]]} | Open Access 1 | 18238 | Ocean Beach Park | 23051 | 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 | 38.919 | Ocean Beach Park | 0 | Local Park 2 | 4 | |
2864 | 2864 | 2863 | {"type": "Polygon", "coordinates": [[[-119.8955, 34.43359], [-119.89489, 34.4336], [-119.89507, 34.4334], [-119.89518, 34.43315], [-119.89502, 34.43276], [-119.89396, 34.43277], [-119.89349, 34.43308], [-119.89327, 34.43291], [-119.89312, 34.43283], [-119.89296, 34.43279], [-119.89279, 34.43277], [-119.89158, 34.43278], [-119.89147, 34.43278], [-119.89124, 34.43274], [-119.89246, 34.43273], [-119.89311, 34.43267], [-119.89548, 34.43263], [-119.8955, 34.43359]]]} | Open Access 1 | 1923 | Winchester I Open Space | 27618 | 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.191 | Winchester I OS | 0 | Local Recreation Area 3 | 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 |
3823 | 3823 | 3822 | {"type": "Polygon", "coordinates": [[[-119.79655, 34.42798], [-119.79651, 34.42886], [-119.79611, 34.42884], [-119.79604, 34.4287], [-119.7958, 34.4284], [-119.79655, 34.42798]]]} | Open Access 1 | 35233 | 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 | 1.01 | Rhoads OS | 0 | Local Recreation Area 3 | 4 | |
3849 | 3849 | 3848 | {"type": "MultiPolygon", "coordinates": [[[[-120.08509, 34.61217], [-120.08485, 34.61225], [-120.08464, 34.61234], [-120.08421, 34.61266], [-120.08416, 34.61268], [-120.08416, 34.61217], [-120.08509, 34.61217]]], [[[-120.08517, 34.61149], [-120.08516, 34.61204], [-120.0845, 34.61203], [-120.08451, 34.61148], [-120.08517, 34.61149]]], [[[-120.08606, 34.6115], [-120.08594, 34.61162], [-120.08572, 34.61198], [-120.08555, 34.61204], [-120.08543, 34.61204], [-120.08543, 34.61149], [-120.08606, 34.6115]]], [[[-120.08723, 34.61005], [-120.08718, 34.61013], [-120.08634, 34.61118], [-120.08635, 34.6112], [-120.08626, 34.61128], [-120.08554, 34.61129], [-120.08554, 34.61123], [-120.08561, 34.61111], [-120.0859, 34.61112], [-120.08608, 34.61102], [-120.08625, 34.6111], [-120.08632, 34.61104], [-120.08622, 34.61074], [-120.08647, 34.61044], [-120.0867, 34.61044], [-120.08691, 34.61018], [-120.08706, 34.61005], [-120.08723, 34.61005]]]]} | Open Access 1 | 626 | Santa Ynez Park | 25143 | 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.195 | Santa Ynez Park | 0 | Local Park 2 | 4 | |
4181 | 4181 | 4180 | {"type": "Polygon", "coordinates": [[[-120.44516, 34.8993], [-120.44515, 34.90526], [-120.43668, 34.90529], [-120.43648, 34.90517], [-120.43631, 34.9047], [-120.43632, 34.90177], [-120.43902, 34.90176], [-120.43902, 34.89957], [-120.43913, 34.89956], [-120.43913, 34.89863], [-120.4392, 34.89828], [-120.43921, 34.89813], [-120.43919, 34.89613], [-120.4391, 34.89559], [-120.43902, 34.89558], [-120.43906, 34.89471], [-120.43963, 34.89485], [-120.44023, 34.89505], [-120.44093, 34.89552], [-120.44516, 34.8993]]]} | Open Access 1 | 1794 | Waller Park | 27221 | 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 | 154.426 | Waller Park | 0 | Local Park 2 | 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 | ||
4568 | 4568 | 4567 | {"type": "Polygon", "coordinates": [[[-119.62321, 34.44984], [-119.62318, 34.45014], [-119.62286, 34.45046], [-119.62231, 34.45075], [-119.62214, 34.45112], [-119.62197, 34.45112], [-119.62196, 34.45078], [-119.6221, 34.45066], [-119.62217, 34.45053], [-119.62231, 34.44987], [-119.62232, 34.44975], [-119.6223, 34.44957], [-119.62216, 34.44918], [-119.62211, 34.44896], [-119.6221, 34.44883], [-119.62209, 34.44827], [-119.62239, 34.44829], [-119.62238, 34.44846], [-119.62223, 34.44862], [-119.62265, 34.44905], [-119.62283, 34.44907], [-119.62296, 34.44939], [-119.62321, 34.44984]]]} | Open Access 1 | 35212 | 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.011 | 0 | Local Other or Unknown 14 | 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 | ||
4575 | 4575 | 4574 | {"type": "Polygon", "coordinates": [[[-120.41196, 34.87233], [-120.40988, 34.87235], [-120.40988, 34.87167], [-120.41063, 34.87167], [-120.41063, 34.87165], [-120.41048, 34.87139], [-120.41055, 34.87137], [-120.41071, 34.87164], [-120.41102, 34.87133], [-120.4118, 34.87166], [-120.41179, 34.87207], [-120.41196, 34.87233]]]} | Open Access 1 | 35235 | 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 | 3.807 | 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]);