units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where COUNTY = 7 and DES_TP = 4
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
345 | 345 | 344 | {"type": "Polygon", "coordinates": [[[-119.5898, 34.42352], [-119.58906, 34.42428], [-119.5885, 34.42388], [-119.58922, 34.42315], [-119.5898, 34.42352]]]} | Open Access 1 | 1191 | Summerland Greenwell Preserve | 25961 | 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.774 | Summerland Greenwell Preserve | 0 | Local Conservation Area 4 | 2 | |
770 | 770 | 769 | {"type": "MultiPolygon", "coordinates": [[[[-119.5289, 34.39581], [-119.52824, 34.3972], [-119.52811, 34.3971], [-119.52714, 34.39789], [-119.52649, 34.39736], [-119.52855, 34.39567], [-119.5289, 34.39581]]], [[[-119.52817, 34.39735], [-119.52805, 34.39762], [-119.52771, 34.39836], [-119.52732, 34.39804], [-119.52817, 34.39735]]]]} | Restricted Access 2 | 4493 | Carpinteria Salt Marsh Reserve | 16899 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 5.768 | Carpinteria Salt Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
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 | |
5015 | 5015 | 5014 | {"type": "MultiPolygon", "coordinates": [[[[-119.88652, 34.4241], [-119.8861, 34.42411], [-119.88609, 34.42296], [-119.88565, 34.42295], [-119.88567, 34.42283], [-119.88572, 34.42274], [-119.8858, 34.42267], [-119.88589, 34.42261], [-119.88605, 34.42258], [-119.88616, 34.42258], [-119.88626, 34.4226], [-119.88638, 34.42268], [-119.88649, 34.42281], [-119.88652, 34.42295], [-119.88652, 34.4241]]], [[[-119.88652, 34.42502], [-119.88649, 34.42503], [-119.88649, 34.42521], [-119.88645, 34.42525], [-119.8861, 34.42526], [-119.8861, 34.42433], [-119.88652, 34.42433], [-119.88652, 34.42502]]], [[[-119.88715, 34.42511], [-119.88666, 34.42512], [-119.88665, 34.42294], [-119.88662, 34.4228], [-119.88652, 34.42265], [-119.88663, 34.42258], [-119.88689, 34.42258], [-119.8869, 34.42254], [-119.88657, 34.42253], [-119.88654, 34.42242], [-119.88657, 34.42238], [-119.88661, 34.42236], [-119.8869, 34.42232], [-119.88714, 34.42233], [-119.88715, 34.42511]]], [[[-119.89286, 34.42346], [-119.892, 34.42346], [-119.89157, 34.42348], [-119.89122, 34.42359], [-119.89106, 34.42379], [-119.89004, 34.4238], [-119.89009, 34.42361], [-119.88956, 34.42349], [-119.88954, 34.42356], [-119.88807, 34.42356], [-119.88807, 34.4233], [-119.88953, 34.42329], [-119.89006, 34.42336], [-119.89286, 34.42313], [-119.89286, 34.42346]]]]} | Open Access 1 | 1029 | Sperling Preserve | 25723 | 1121 | Goleta, City of 179 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | Santa Barbara 7 | 10.186 | Sperling Preserve | 0 | Local Conservation Area 4 | 2 | |
5089 | 5089 | 5088 | {"type": "Polygon", "coordinates": [[[-119.73541, 34.4041], [-119.73541, 34.40426], [-119.73437, 34.40428], [-119.73407, 34.4042], [-119.73417, 34.40413], [-119.73405, 34.40365], [-119.73466, 34.40398], [-119.73541, 34.4041]]]} | Open Access 1 | 13858 | Douglas Family Reserve | 18244 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 1.023 | Douglas Family Reserve | 0 | Local Conservation Area 4 | 2 | |
6661 | 6661 | 6660 | {"type": "MultiPolygon", "coordinates": [[[[-119.52905, 34.3961], [-119.52846, 34.39735], [-119.52762, 34.39923], [-119.52766, 34.39927], [-119.52741, 34.39995], [-119.5269, 34.39971], [-119.52637, 34.39941], [-119.52672, 34.39929], [-119.52671, 34.39926], [-119.52674, 34.39925], [-119.52683, 34.39932], [-119.52708, 34.39925], [-119.52717, 34.39921], [-119.52737, 34.39902], [-119.52739, 34.39902], [-119.5288, 34.39601], [-119.52905, 34.3961]]], [[[-119.53027, 34.40061], [-119.5299, 34.40115], [-119.52919, 34.40081], [-119.52943, 34.40021], [-119.53027, 34.40061]]]]} | Restricted Access 2 | 4718 | Carpinteria Salt Marsh Reserve | 16900 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 5.152 | Carpinteria Salt Marsh Reserve | 0 | Local Conservation Area 4 | 2 | |
7782 | 7782 | 7781 | {"type": "Polygon", "coordinates": [[[-119.6649, 34.42122], [-119.66069, 34.42234], [-119.65994, 34.42248], [-119.65896, 34.42255], [-119.65662, 34.42136], [-119.65665, 34.42119], [-119.65672, 34.42104], [-119.65679, 34.42096], [-119.65693, 34.42083], [-119.65709, 34.42072], [-119.65739, 34.42055], [-119.65768, 34.42042], [-119.65788, 34.42036], [-119.65829, 34.42029], [-119.66117, 34.4201], [-119.66131, 34.42008], [-119.66144, 34.42003], [-119.66163, 34.41991], [-119.66191, 34.41967], [-119.6621, 34.41949], [-119.66228, 34.4192], [-119.6626, 34.41855], [-119.66269, 34.41843], [-119.6628, 34.41832], [-119.663, 34.41821], [-119.66314, 34.41816], [-119.66437, 34.4179], [-119.66417, 34.41798], [-119.66395, 34.41844], [-119.66327, 34.41888], [-119.66314, 34.41969], [-119.6633, 34.41997], [-119.66379, 34.42021], [-119.66422, 34.42048], [-119.66476, 34.42078], [-119.66479, 34.42119], [-119.6649, 34.42122]]]} | Open Access 1 | 8690 | Andre Clark Bird Refuge | 15482 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 40.91 | Andre Clark Bird Refuge | 0 | Local Conservation Area 4 | 2 | |
8636 | 8636 | 8635 | {"type": "Polygon", "coordinates": [[[-119.74327, 34.40268], [-119.74281, 34.40401], [-119.74071, 34.40454], [-119.74078, 34.40476], [-119.74033, 34.40489], [-119.74028, 34.4048], [-119.73989, 34.40491], [-119.73968, 34.40495], [-119.73946, 34.40497], [-119.73853, 34.40494], [-119.73635, 34.40462], [-119.73614, 34.40469], [-119.73598, 34.40469], [-119.73437, 34.40428], [-119.73532, 34.40426], [-119.73675, 34.40426], [-119.73677, 34.40319], [-119.73676, 34.40304], [-119.73681, 34.4012], [-119.73505, 34.40118], [-119.73505, 34.40069], [-119.73483, 34.40057], [-119.73463, 34.40056], [-119.73462, 34.39855], [-119.73629, 34.39906], [-119.7367, 34.39936], [-119.73706, 34.39956], [-119.73799, 34.40017], [-119.73809, 34.40013], [-119.7381, 34.40019], [-119.73836, 34.40032], [-119.73916, 34.40081], [-119.74042, 34.40149], [-119.7427, 34.40247], [-119.74327, 34.40268]]]} | Open Access 1 | 13812 | Douglas Family Reserve | 18243 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | Santa Barbara 7 | 68.84 | Douglas Family Reserve | 0 | Local Conservation Area 4 | 2 | |
9798 | 9798 | 9797 | {"type": "Polygon", "coordinates": [[[-120.65717, 34.9522], [-120.65432, 34.95978], [-120.6519, 34.96646], [-120.65078, 34.97051], [-120.64878, 34.96944], [-120.64914, 34.96875], [-120.64889, 34.96826], [-120.64937, 34.96772], [-120.64677, 34.96656], [-120.64661, 34.96442], [-120.64568, 34.96166], [-120.64502, 34.96078], [-120.64471, 34.96016], [-120.64403, 34.95965], [-120.64345, 34.95932], [-120.64321, 34.9592], [-120.64235, 34.95893], [-120.64056, 34.95849], [-120.64021, 34.95863], [-120.63876, 34.95838], [-120.63834, 34.95875], [-120.6378, 34.9583], [-120.63663, 34.9577], [-120.63662, 34.95771], [-120.63659, 34.95879], [-120.63347, 34.95834], [-120.63251, 34.95793], [-120.63144, 34.95778], [-120.63125, 34.95708], [-120.6326, 34.95643], [-120.63361, 34.95661], [-120.63361, 34.95605], [-120.63038, 34.95437], [-120.63021, 34.95408], [-120.63031, 34.95324], [-120.62935, 34.95269], [-120.62838, 34.95091], [-120.6414, 34.95112], [-120.64138, 34.95191], [-120.65717, 34.9522]]]} | Open Access 1 | 16704 | Guadalupe-Nipomo Dunes Preserve Forest | 28194 | 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/parks02.aspx?id=13422 | Santa Barbara 7 | 611.44 | Guadalupe-Nipomo Dunes Preserve Forest | 0 | Local Conservation Area 4 | 2 |
10002 | 10002 | 10001 | {"type": "Polygon", "coordinates": [[[-119.85366, 34.44306], [-119.85276, 34.44347], [-119.85337, 34.44455], [-119.8527, 34.44481], [-119.84965, 34.4455], [-119.84954, 34.44511], [-119.84907, 34.44512], [-119.8486, 34.44517], [-119.84766, 34.44503], [-119.8476, 34.4451], [-119.84732, 34.44499], [-119.84702, 34.44491], [-119.84672, 34.44486], [-119.84642, 34.44483], [-119.84611, 34.44482], [-119.84581, 34.44485], [-119.84551, 34.4449], [-119.84502, 34.44504], [-119.84435, 34.44329], [-119.84429, 34.443], [-119.84425, 34.44272], [-119.84423, 34.44243], [-119.84423, 34.44189], [-119.84417, 34.44156], [-119.84321, 34.44012], [-119.84296, 34.4393], [-119.84304, 34.4392], [-119.84742, 34.43854], [-119.84918, 34.43857], [-119.84949, 34.43861], [-119.84978, 34.43869], [-119.85005, 34.43883], [-119.85018, 34.43891], [-119.85041, 34.43912], [-119.85121, 34.4401], [-119.85133, 34.44022], [-119.85148, 34.44031], [-119.85164, 34.44038], [-119.85184, 34.44042], [-119.85204, 34.44044], [-119.85207, 34.44067], [-119.8523, 34.44083], [-119.85269, 34.4408], [-119.85279, 34.44126], [-119.85293, 34.44172], [-119.85303, 34.442], [-119.85315, 34.44223], [-119.85339, 34.44266], [-119.85366, 34.44306]]]} | Open Access 1 | 17215 | Lake Los Carneros Natural and Historical Preserve | 20949 | 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 | 133.546 | Lake Los Carneros Natural and Historical Preserve | 0 | Local Conservation Area 4 | 2 | |
10246 | 10246 | 10245 | {"type": "Polygon", "coordinates": [[[-120.67009, 34.90633], [-120.6671, 34.91364], [-120.66438, 34.92044], [-120.66391, 34.92673], [-120.655, 34.91725], [-120.64527, 34.90698], [-120.64528, 34.90274], [-120.65299, 34.90277], [-120.66179, 34.90273], [-120.66183, 34.90636], [-120.67009, 34.90633]]]} | Open Access 1 | 18725 | Point Sal Preserve | 23860 | 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 | 759.061 | Point Sal Preserve | 0 | Local Conservation Area 4 | 2 |
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]);