units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
50 rows where COUNTY = 7, DES_TP = 14 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY 7
ACCESS_TYP 2
- Open Access 38
- Unknown Access 12
MNG_AG_TYP 1
- City Agency · 50 ✖
DES_TP 1
- Local Other or Unknown · 50 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185 | 185 | 184 | {"type": "Polygon", "coordinates": [[[-119.52773, 34.40703], [-119.52713, 34.40837], [-119.52698, 34.40879], [-119.52686, 34.40923], [-119.52678, 34.40968], [-119.52672, 34.40966], [-119.52675, 34.4094], [-119.52682, 34.40907], [-119.52689, 34.40883], [-119.52701, 34.40848], [-119.52766, 34.40701], [-119.52773, 34.40703]]]} | Unknown Access 4 | 592 | Santa Monica Creek | 25117 | 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 | 0.489 | Santa Monica Creek | 0 | Local Other or Unknown 14 | 4 | |
364 | 364 | 363 | {"type": "Polygon", "coordinates": [[[-119.67342, 34.42333], [-119.67318, 34.42356], [-119.67274, 34.42324], [-119.67299, 34.42301], [-119.67342, 34.42333]]]} | Unknown Access 4 | 1276 | Sycamore Creek | 26121 | 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 | 0.446 | Sycamore Creek | 0 | Local Other or Unknown 14 | 4 | |
1412 | 1412 | 1411 | {"type": "Polygon", "coordinates": [[[-119.67034, 34.43903], [-119.67034, 34.4395], [-119.66917, 34.4395], [-119.66941, 34.43903], [-119.67034, 34.43903]]]} | Unknown Access 4 | 36486 | Santa Barbara holding 9 | 25051 | 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 | 1.234 | Santa Barbara holding 9 | 0 | Local Other or Unknown 14 | 4 | |
3416 | 3416 | 3415 | {"type": "Polygon", "coordinates": [[[-120.45474, 34.63166], [-120.45474, 34.63208], [-120.45449, 34.63208], [-120.45449, 34.6318], [-120.45474, 34.63166]]]} | Open Access 1 | 35325 | Lompoc holding 11 | 21422 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.216 | Lompoc holding 11 | 0 | Local Other or Unknown 14 | 4 | |
4579 | 4579 | 4578 | {"type": "Polygon", "coordinates": [[[-120.14651, 34.6035], [-120.14643, 34.60387], [-120.14512, 34.60449], [-120.14492, 34.60438], [-120.14466, 34.6043], [-120.14438, 34.6043], [-120.14381, 34.60437], [-120.14377, 34.60436], [-120.14373, 34.60432], [-120.14374, 34.6041], [-120.14379, 34.60395], [-120.14434, 34.60404], [-120.14512, 34.60379], [-120.14578, 34.60373], [-120.14651, 34.6035]]]} | Open Access 1 | 35310 | Unnamed site - Solvang, City of | 28670 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 3.005 | 0 | Local Other or Unknown 14 | 4 | ||
4927 | 4927 | 4926 | {"type": "Polygon", "coordinates": [[[-120.57718, 34.95846], [-120.57722, 34.95871], [-120.57726, 34.95884], [-120.57749, 34.95931], [-120.57749, 34.95936], [-120.57745, 34.95938], [-120.57717, 34.95939], [-120.57718, 34.95846]]]} | Open Access 1 | 35362 | Guadalupe holding 1 | 19545 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.328 | Guadalupe holding 1 | 0 | Local Other or Unknown 14 | 4 | ||
4928 | 4928 | 4927 | {"type": "Polygon", "coordinates": [[[-120.58052, 34.96254], [-120.58034, 34.96267], [-120.57983, 34.9626], [-120.57981, 34.9625], [-120.58012, 34.96231], [-120.58041, 34.96249], [-120.58052, 34.96254]]]} | Open Access 1 | 35363 | Guadalupe holding 2 | 19547 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.371 | Guadalupe holding 2 | 0 | Local Other or Unknown 14 | 4 | ||
4946 | 4946 | 4945 | {"type": "Polygon", "coordinates": [[[-119.7272, 34.4336], [-119.72698, 34.43445], [-119.72664, 34.43545], [-119.72639, 34.43526], [-119.72657, 34.43483], [-119.72679, 34.43462], [-119.72695, 34.43445], [-119.72702, 34.43416], [-119.72681, 34.43413], [-119.72683, 34.43397], [-119.72706, 34.43399], [-119.72716, 34.43359], [-119.7272, 34.4336]]]} | Unknown Access 4 | 14659 | El Mission Creek | 18514 | 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 | 0.719 | El Mission Creek | 0 | Local Other or Unknown 14 | 4 | |
5141 | 5141 | 5140 | {"type": "Polygon", "coordinates": [[[-120.57892, 34.964], [-120.57887, 34.96401], [-120.57829, 34.96412], [-120.57829, 34.964], [-120.57892, 34.964]]]} | Open Access 1 | 35415 | Guadalupe holding 6 | 19551 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.1 | Guadalupe holding 6 | 0 | Local Other or Unknown 14 | 4 | ||
5655 | 5655 | 5654 | {"type": "Polygon", "coordinates": [[[-120.14075, 34.59592], [-120.13946, 34.5959], [-120.13946, 34.5959], [-120.13963, 34.59555], [-120.14075, 34.59592]]]} | Open Access 1 | 35244 | Unknown park - Solvang, City of | 28669 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 0.581 | 0 | Local Other or Unknown 14 | 4 | ||
6601 | 6601 | 6600 | {"type": "MultiPolygon", "coordinates": [[[[-119.50722, 34.39559], [-119.50661, 34.3957], [-119.50574, 34.39635], [-119.5055, 34.39636], [-119.50526, 34.39632], [-119.50526, 34.39623], [-119.50539, 34.39622], [-119.50563, 34.39619], [-119.50586, 34.39611], [-119.50597, 34.39606], [-119.50676, 34.39552], [-119.50722, 34.39559]]], [[[-119.51198, 34.39382], [-119.51152, 34.39386], [-119.51141, 34.39389], [-119.51064, 34.3943], [-119.51039, 34.39448], [-119.51014, 34.39416], [-119.51121, 34.39348], [-119.51144, 34.3934], [-119.51198, 34.39382]]]]} | Unknown Access 4 | 4238 | Carpinteria Creek | 16897 | 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 | 2.293 | Carpinteria Creek | 0 | Local Other or Unknown 14 | 4 | |
12995 | 12995 | 12994 | {"type": "Polygon", "coordinates": [[[-119.69167, 34.45419], [-119.69138, 34.45435], [-119.691, 34.45433], [-119.69056, 34.45403], [-119.69059, 34.45371], [-119.69063, 34.45361], [-119.69071, 34.45352], [-119.69083, 34.45346], [-119.6913, 34.45343], [-119.69167, 34.45419]]]} | Unknown Access 4 | 35356 | Santa Barbara holding 1 | 25042 | 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 | 1.835 | Santa Barbara holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13147 | 13147 | 13146 | {"type": "Polygon", "coordinates": [[[-120.58049, 34.96217], [-120.58041, 34.96249], [-120.58017, 34.96234], [-120.58038, 34.96212], [-120.58049, 34.96217]]]} | Open Access 1 | 35256 | Guadalupe holding 7 | 19552 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.158 | Guadalupe holding 7 | 0 | Local Other or Unknown 14 | 4 | ||
13200 | 13200 | 13199 | {"type": "Polygon", "coordinates": [[[-120.14624, 34.60823], [-120.14615, 34.60863], [-120.14538, 34.60859], [-120.14546, 34.60827], [-120.14599, 34.60822], [-120.14624, 34.60823]]]} | Open Access 1 | 35228 | Solvang holding 1 | 25601 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 0.735 | Solvang holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13208 | 13208 | 13207 | {"type": "Polygon", "coordinates": [[[-120.45602, 34.63102], [-120.45601, 34.6313], [-120.45541, 34.63129], [-120.45542, 34.63102], [-120.45602, 34.63102]]]} | Open Access 1 | 35243 | Lompoc holding 3 | 21429 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.414 | Lompoc holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13210 | 13210 | 13209 | {"type": "Polygon", "coordinates": [[[-120.45534, 34.63198], [-120.45534, 34.63209], [-120.45504, 34.63209], [-120.45504, 34.63198], [-120.45534, 34.63198]]]} | Open Access 1 | 35246 | Lompoc holding 4 | 21430 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.083 | Lompoc holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13213 | 13213 | 13212 | {"type": "Polygon", "coordinates": [[[-120.45331, 34.65345], [-120.45328, 34.65553], [-120.4529, 34.65553], [-120.45289, 34.65395], [-120.45288, 34.65374], [-120.45277, 34.65345], [-120.45331, 34.65345]]]} | Open Access 1 | 35251 | Lompoc holding 5 | 21431 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 2.15 | Lompoc holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13216 | 13216 | 13215 | {"type": "Polygon", "coordinates": [[[-120.41587, 34.97214], [-120.4158, 34.97224], [-120.41559, 34.97213], [-120.41511, 34.97201], [-120.41521, 34.97161], [-120.41526, 34.97159], [-120.41582, 34.9716], [-120.41587, 34.97214]]]} | Open Access 1 | 35255 | Santa Maria holding 7 | 25111 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 0.886 | Santa Maria holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13227 | 13227 | 13226 | {"type": "Polygon", "coordinates": [[[-120.45638, 34.6553], [-120.45638, 34.65537], [-120.45512, 34.65556], [-120.45512, 34.65548], [-120.45638, 34.6553]]]} | Open Access 1 | 35268 | Lompoc holding 6 | 21432 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.235 | Lompoc holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13229 | 13229 | 13228 | {"type": "Polygon", "coordinates": [[[-119.87679, 34.42375], [-119.87675, 34.42404], [-119.87631, 34.42397], [-119.87651, 34.42342], [-119.87657, 34.42341], [-119.8767, 34.42375], [-119.87679, 34.42375]]]} | Open Access 1 | 35271 | Goleta holding 1 | 19382 | 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 | 0.437 | Goleta holding 1 | 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]);