units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where ACCESS_TYP = 4, AGNCY_TYP = 3 and MNG_AGENCY = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9763 | 9763 | 9762 | {"type": "Polygon", "coordinates": [[[-119.63709, 34.41583], [-119.63704, 34.41641], [-119.63642, 34.41654], [-119.63646, 34.41695], [-119.63641, 34.41723], [-119.63631, 34.41757], [-119.63611, 34.41758], [-119.63581, 34.41763], [-119.63571, 34.41761], [-119.63562, 34.41754], [-119.6355, 34.41737], [-119.6354, 34.4173], [-119.63519, 34.41724], [-119.63496, 34.41724], [-119.63486, 34.41687], [-119.6343, 34.41698], [-119.6338, 34.41711], [-119.63385, 34.41696], [-119.63423, 34.41679], [-119.63501, 34.41663], [-119.63563, 34.41644], [-119.63623, 34.4162], [-119.6365, 34.41604], [-119.63678, 34.4159], [-119.63709, 34.41583]]]} | Unknown Access 4 | 16729 | Hammond's Meadow | 19627 | 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 | Hammond's Meadow | 0 | None 843 | ||
9811 | 9811 | 9810 | {"type": "MultiPolygon", "coordinates": [[[[-119.78388, 34.43252], [-119.78345, 34.43278], [-119.78231, 34.43354], [-119.78143, 34.43378], [-119.78052, 34.4337], [-119.78052, 34.43358], [-119.78135, 34.43364], [-119.78158, 34.43361], [-119.78213, 34.43346], [-119.78241, 34.43332], [-119.78376, 34.43242], [-119.78381, 34.43241], [-119.78385, 34.43243], [-119.78388, 34.43248], [-119.78388, 34.43252]]], [[[-119.79498, 34.42774], [-119.79162, 34.42959], [-119.7874, 34.43078], [-119.78626, 34.43109], [-119.78625, 34.43108], [-119.78589, 34.43127], [-119.78408, 34.43239], [-119.78411, 34.4321], [-119.78448, 34.43201], [-119.78536, 34.43149], [-119.78544, 34.43143], [-119.7857, 34.43115], [-119.7862, 34.43068], [-119.78689, 34.43049], [-119.78694, 34.43059], [-119.79145, 34.42935], [-119.79203, 34.42903], [-119.79202, 34.42901], [-119.79462, 34.42757], [-119.79483, 34.42761], [-119.79498, 34.42774]]]]} | Unknown Access 4 | 16760 | Atascadero Creek | 15661 | 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 | 9.641 | Atascadero Creek | 0 | Local Other or Unknown 14 | 4 | |
10124 | 10124 | 10123 | {"type": "MultiPolygon", "coordinates": [[[[-119.80818, 34.42783], [-119.80793, 34.42827], [-119.80768, 34.42863], [-119.80753, 34.42918], [-119.80753, 34.42957], [-119.80738, 34.43021], [-119.80738, 34.43068], [-119.80766, 34.43127], [-119.80766, 34.43204], [-119.80759, 34.43228], [-119.80758, 34.43254], [-119.80761, 34.43273], [-119.80782, 34.43341], [-119.80783, 34.43357], [-119.80781, 34.43369], [-119.80775, 34.43386], [-119.80769, 34.43396], [-119.80749, 34.43418], [-119.80694, 34.43476], [-119.80655, 34.43475], [-119.80662, 34.43457], [-119.80671, 34.43458], [-119.80679, 34.43454], [-119.80682, 34.43449], [-119.80683, 34.43443], [-119.8069, 34.43442], [-119.80717, 34.43408], [-119.80713, 34.4338], [-119.80705, 34.43375], [-119.80706, 34.43369], [-119.80705, 34.43363], [-119.80714, 34.43359], [-119.80722, 34.43323], [-119.80737, 34.43319], [-119.80729, 34.43293], [-119.80721, 34.43289], [-119.80724, 34.4328], [-119.80719, 34.43256], [-119.80717, 34.43226], [-119.80724, 34.43176], [-119.80724, 34.43145], [-119.80722, 34.43129], [-119.80709, 34.4308], [-119.80705, 34.43058], [-119.80703, 34.43036], [-119.80703, 34.43014], [-119.80712, 34.42909], [-119.8072, 34.42878], [-119.80735, 34.42839], [-119.80738, 34.42824], [-119.80739, 34.42809], [-119.80737, 34.42787], [-119.80818, 34.42783]]], [[[-119.80555, 34.44363], [-119.80546, 34.44368], [-119.80534, 34.44379], [-119.80523, 34.44397], [-119.80497, 34.44513], [-119.80464, 34.4451], [-119.80449, 34.44531], [-119.80419, 34.44525], [-119.80402, 34.4453], [-119.80393, 34.44547], [-119.80358, 34.44532], [-119.80365, 34.44499], [-119.8039, 34.44475], [-119.80438, 34.44456], [-119.80474, 34.44427], [-119.8046, 34.44386], [-119.80481, 34.44368], [-119.80527, 34.44343], [-119.80532, 34.44334], [-119.80551, 34.44332], [-119.80555, 34.44363]]], [[[-119.80378, 34.44592], [-119.80366, 34.4463], [-119.80325, 34.44624], [-119.80324, 34.44625], [-119.80335, 34.44727], [-119.80368, 34.44726], [-119.80373, 34.44775], [-119.80371, 34.44782], [-119.80365, 34.44786], [-119.80355, 34.44789], [-119.80349, 34.44795], [-119.80328, 34.4479], [-119.80257, 34.44813], [-119.80238, 34.44837], [-119.80211, 34.44842], [-119.80196, 34.44856], [-119.80178, 34.44857], [-119.80166, 34.44894], [-119.80137, 34.44905], [-119.8013, 34.44915], [-119.80126, 34.44928], [-119.80139, 34.44946], [-119.80159, 34.44962], [-119.80128, 34.44962], [-119.80088, 34.44918], [-119.80098, 34.44907], [-119.8012, 34.44877], [-119.80138, 34.44859], [-119.80223, 34.44801], [-119.8023, 34.44795], [-119.80235, 34.44786], [-119.80262, 34.44773], [-119.80269, 34.44762], [-119.80241, 34.44694], [-119.8021, 34.44669], [-119.80182, 34.4467], [-119.80174, 34.44684], [-119.80123, 34.44716], [-119.80119, 34.44729], [-119.80113, 34.44766], [-119.80087, 34.44796], [-119.80047, 34.44833], [-119.80041, 34.44828], [-119.80029, 34.44828], [-119.80051, 34.44786], [-119.80059, 34.44762], [-119.80067, 34.44731], [-119.80079, 34.44707], [-119.80091, 34.44694], [-119.8015, 34.44645], [-119.80169, 34.44626], [-119.80199, 34.44589], [-119.80212, 34.44575], [-119.80256, 34.44575], [-119.80304, 34.44557], [-119.80355, 34.44549], [-119.80368, 34.44556], [-119.80351, 34.44585], [-119.80378, 34.44592]]], [[[-119.7952, 34.45576], [-119.79519, 34.45606], [-119.79483, 34.45606], [-119.79478, 34.45662], [-119.79471, 34.45677], [-119.79433, 34.45736], [-119.79434, 34.45737], [-119.79472, 34.45738], [-119.79463, 34.45757], [-119.79373, 34.45755], [-119.7937, 34.45659], [-119.79444, 34.45608], [-119.79437, 34.45575], [-119.7952, 34.45576]]], [[[-119.79526, 34.4592], [-119.79501, 34.45939], [-119.79428, 34.45963], [-119.79402, 34.45956], [-119.79374, 34.45963], [-119.79341, 34.45957], [-119.79319, 34.45991], [-119.79298, 34.45997], [-119.79289, 34.45965], [-119.79349, 34.45947], [-119.79401, 34.45938], [-119.79428, 34.45928], [-119.79438, 34.45922], [-119.79483, 34.45924], [-119.79525, 34.45902], [-119.79526, 34.4592]]]]} | Unknown Access 4 | 17594 | Maria Ygnacia Creek | 21810 | 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 | 28.798 | Maria Ygnacia Creek | 0 | Local Other or Unknown 14 | 4 | |
13271 | 13271 | 13270 | {"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 | 35320 | Santa Barbara holding 11 | 25043 | 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.308 | Santa Barbara holding 11 | 0 | Local Other or Unknown 14 | 4 | |
15974 | 15974 | 15973 | {"type": "MultiPolygon", "coordinates": [[[[-119.81332, 34.45598], [-119.81288, 34.45617], [-119.81225, 34.45579], [-119.81214, 34.45568], [-119.81209, 34.45571], [-119.81199, 34.45548], [-119.81194, 34.45517], [-119.81158, 34.45496], [-119.81142, 34.45533], [-119.81138, 34.45536], [-119.81135, 34.45542], [-119.81137, 34.4555], [-119.81145, 34.45559], [-119.8115, 34.45578], [-119.81148, 34.45592], [-119.8114, 34.45609], [-119.81136, 34.45621], [-119.81136, 34.45643], [-119.81134, 34.45646], [-119.81119, 34.45654], [-119.81111, 34.45662], [-119.81093, 34.45692], [-119.81062, 34.45753], [-119.8103, 34.45739], [-119.81042, 34.4569], [-119.80997, 34.45714], [-119.80956, 34.45682], [-119.80933, 34.45651], [-119.80908, 34.4565], [-119.80894, 34.45612], [-119.80929, 34.45603], [-119.80957, 34.45575], [-119.80968, 34.4558], [-119.80969, 34.4561], [-119.81035, 34.4561], [-119.81047, 34.45579], [-119.81042, 34.45575], [-119.81048, 34.45568], [-119.8105, 34.45559], [-119.8105, 34.45431], [-119.81053, 34.45429], [-119.81115, 34.45429], [-119.81129, 34.45426], [-119.81139, 34.45421], [-119.81146, 34.45416], [-119.81153, 34.45407], [-119.81158, 34.45396], [-119.81159, 34.45408], [-119.81196, 34.45403], [-119.81204, 34.45397], [-119.81207, 34.45383], [-119.81229, 34.45385], [-119.81229, 34.45306], [-119.81384, 34.45306], [-119.81408, 34.45307], [-119.81411, 34.4531], [-119.81412, 34.45313], [-119.81401, 34.45326], [-119.81387, 34.45335], [-119.81367, 34.45343], [-119.81356, 34.45348], [-119.81346, 34.45357], [-119.81339, 34.45366], [-119.81331, 34.45385], [-119.81322, 34.45435], [-119.81289, 34.45432], [-119.81286, 34.45461], [-119.81251, 34.45474], [-119.81236, 34.45497], [-119.81251, 34.45525], [-119.81269, 34.45538], [-119.81294, 34.45543], [-119.81309, 34.45578], [-119.81332, 34.45598]]], [[[-119.81048, 34.45784], [-119.81042, 34.45797], [-119.81006, 34.45793], [-119.80996, 34.45812], [-119.80972, 34.45833], [-119.80961, 34.45878], [-119.80941, 34.45916], [-119.80963, 34.45934], [-119.80984, 34.45945], [-119.81, 34.4595], [-119.80999, 34.45955], [-119.80985, 34.45956], [-119.8098, 34.4595], [-119.80931, 34.45923], [-119.80912, 34.45888], [-119.80925, 34.4583], [-119.80955, 34.45781], [-119.81004, 34.45766], [-119.81042, 34.45785], [-119.81048, 34.45784]]], [[[-119.81501, 34.458], [-119.815, 34.45855], [-119.81493, 34.45851], [-119.81494, 34.45848], [-119.81485, 34.45842], [-119.81481, 34.45845], [-119.81458, 34.45833], [-119.81417, 34.45818], [-119.81412, 34.45791], [-119.81387, 34.45777], [-119.81367, 34.45716], [-119.81363, 34.45682], [-119.81339, 34.45641], [-119.8131, 34.45626], [-119.81363, 34.45603], [-119.81367, 34.45604], [-119.81376, 34.4562], [-119.81383, 34.45639], [-119.81407, 34.45734], [-119.81419, 34.45756], [-119.81434, 34.45772], [-119.81452, 34.45785], [-119.81478, 34.45796], [-119.81501, 34.458]]], [[[-119.8154, 34.45898], [-119.81531, 34.45912], [-119.81528, 34.45914], [-119.81495, 34.45882], [-119.81494, 34.45878], [-119.81462, 34.45852], [-119.8154, 34.45898]]]]} | Unknown Access 4 | 339 | San Jose Creek Open Space | 24915 | 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 | 23.422 | San Jose Creek OS | 0 | Local Recreation Area 3 | 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]);