units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where ACCESS_TYP = 1, COUNTY = 16 and DES_TP = 16
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 8 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 555 | 555 | 554 | {"type": "Polygon", "coordinates": [[[-122.9929, 38.40024], [-122.98778, 38.40028], [-122.9879, 38.40009], [-122.98801, 38.39995], [-122.98807, 38.39982], [-122.9881, 38.39969], [-122.9881, 38.39939], [-122.98798, 38.39883], [-122.98846, 38.39805], [-122.98894, 38.39796], [-122.98994, 38.39783], [-122.99049, 38.398], [-122.99099, 38.39799], [-122.99139, 38.39795], [-122.99214, 38.3978], [-122.99265, 38.39762], [-122.99288, 38.39745], [-122.99276, 38.39812], [-122.99289, 38.39876], [-122.99292, 38.39973], [-122.9929, 38.40024]]]} | Open Access 1 | 1847 | Grove of Old Trees | 31507 | 3117 | LandPaths 206 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landpaths.org/ | Non Governmental Organization 10 | 3117 | LandPaths 202 | Non Profit 6 | Non Profit - Land Trust 10 | http://landpaths.org/get-to-know-our-places/grove-of-old-trees.aspx | Sonoma 16 | 27.052 | Grove of Old Trees | 0 | Private Conservation 16 | 2 |
| 7218 | 7218 | 7217 | {"type": "Polygon", "coordinates": [[[-123.15353, 38.46907], [-123.15292, 38.46995], [-123.15347, 38.47095], [-123.15338, 38.47128], [-123.15337, 38.47178], [-123.15366, 38.47331], [-123.15365, 38.47354], [-123.1536, 38.47368], [-123.15348, 38.47389], [-123.15336, 38.47401], [-123.15307, 38.47421], [-123.15318, 38.47434], [-123.15269, 38.4747], [-123.15246, 38.47499], [-123.1523, 38.47527], [-123.15209, 38.47629], [-123.15202, 38.47688], [-123.15187, 38.47722], [-123.15173, 38.47784], [-123.15174, 38.47836], [-123.15146, 38.47909], [-123.15132, 38.47887], [-123.15114, 38.4788], [-123.15047, 38.4788], [-123.15027, 38.47864], [-123.15015, 38.4785], [-123.14963, 38.4786], [-123.1487, 38.47884], [-123.14817, 38.47885], [-123.14499, 38.47823], [-123.1434, 38.47843], [-123.14302, 38.47891], [-123.14271, 38.47904], [-123.14188, 38.47913], [-123.14161, 38.47966], [-123.14203, 38.47999], [-123.14195, 38.48016], [-123.14111, 38.48052], [-123.14082, 38.48074], [-123.14046, 38.48098], [-123.13955, 38.48075], [-123.13863, 38.4813], [-123.13807, 38.48126], [-123.1376, 38.48163], [-123.13734, 38.48178], [-123.13617, 38.48156], [-123.13566, 38.48137], [-123.13508, 38.48159], [-123.13386, 38.4816], [-123.13343, 38.48135], [-123.13142, 38.48113], [-123.13091, 38.48092], [-123.13052, 38.48097], [-123.13051, 38.48133], [-123.13223, 38.48365], [-123.13261, 38.48443], [-123.13251, 38.48523], [-123.13225, 38.48554], [-123.13237, 38.48591], [-123.13232, 38.48628], [-123.13277, 38.48742], [-123.1329, 38.4882], [-123.13248, 38.48905], [-123.1319, 38.49032], [-123.13134, 38.49063], [-123.13108, 38.49151], [-123.13088, 38.49171], [-123.13097, 38.49223], [-123.13126, 38.49354], [-123.13083, 38.49417], [-123.13033, 38.49495], [-123.13035, 38.49521], [-123.12968, 38.49644], [-123.12972, 38.49645], [-123.12979, 38.49685], [-123.13051, 38.4972], [-123.13103, 38.49792], [-123.13254, 38.49882], [-123.13357, 38.49875], [-123.13381, 38.4989], [-123.13387, 38.50102], [-123.13375, 38.5012], [-123.13173, 38.50121], [-123.13174, 38.50313], [-123.12481, 38.50317], [-123.1248, 38.50139], [-123.11602, 38.50147], [-123.11616, 38.49781], [-123.11311, 38.49782], [-123.11612, 38.49433], [-123.11831, 38.49182], [-123.11818, 38.48717], [-123.10602, 38.48746], [-123.09675, 38.48758], [-123.09674, 38.48759], [-123.09737, 38.49439], [-123.10648, 38.49444], [-123.10662, 38.49608], [-123.10679, 38.49761], [-123.10716, 38.50136], [-123.10467, 38.50182], [-123.09791, 38.50293], [-123.09097, 38.50412], [-123.0899, 38.49925], [-123.09333, 38.49889], [-123.09397, 38.49883], [-123.09381, 38.4978], [-123.09317, 38.49437], [-123.08882, 38.49434], [-123.08757, 38.4877], [-123.07376, 38.4877], [-123.07043, 38.48762], [-123.07037, 38.48386], [-123.06528, 38.48388], [-123.06516, 38.48036], [-123.06211, 38.48036], [-123.06024, 38.4735], [-123.06092, 38.46884], [-123.06322, 38.46881], [-123.06316, 38.46521], [-123.07462, 38.46511], [-123.07468, 38.46881], [-123.08371, 38.46872], [-123.0837, 38.46737], [-123.09944, 38.47639], [-123.1015, 38.47594], [-123.10142, 38.47458], [-123.10319, 38.47012], [-123.10513, 38.46994], [-123.10957, 38.46777], [-123.11102, 38.46808], [-123.11349, 38.46719], [-123.11519, 38.46609], [-123.1152, 38.46493], [-123.11619, 38.46268], [-123.114, 38.45964], [-123.11426, 38.45803], [-123.11233, 38.45719], [-123.11214, 38.45589], [-123.11206, 38.45551], [-123.11332, 38.45391], [-123.11365, 38.45401], [-123.11406, 38.45348], [-123.11375, 38.45338], [-123.11382, 38.45328], [-123.11396, 38.45313], [-123.11555, 38.45175], [-123.11615, 38.45151], [-123.11618, 38.45167], [-123.11679, 38.45221], [-123.11699, 38.4526], [-123.11727, 38.45454], [-123.11937, 38.45452], [-123.11954, 38.45319], [-123.11935, 38.45309], [-123.11922, 38.45306], [-123.11908, 38.45306], [-123.11872, 38.45311], [-123.11861, 38.4531], [-123.11852, 38.45306], [-123.11847, 38.453], [-123.11846, 38.45283], [-123.11828, 38.45225], [-123.11842, 38.45223], [-123.11856, 38.45269], [-123.11858, 38.45282], [-123.11858, 38.45295], [-123.11862, 38.453], [-123.11872, 38.45302], [-123.11909, 38.45295], [-123.11929, 38.45296], [-123.11944, 38.45301], [-123.12017, 38.45337], [-123.12051, 38.45335], [-123.12085, 38.45267], [-123.12107, 38.45211], [-123.12284, 38.45141], [-123.12297, 38.45041], [-123.12325, 38.45038], [-123.12339, 38.45038], [-123.1241, 38.45044], [-123.12428, 38.45048], [-123.12444, 38.45054], [-123.1246, 38.45065], [-123.12471, 38.45078], [-123.12476, 38.4509], [-123.12485, 38.45138], [-123.12491, 38.45148], [-123.12502, 38.45158], [-123.12514, 38.45163], [-123.12528, 38.45165], [-123.1258, 38.45159], [-123.12606, 38.45162], [-123.12619, 38.45166], [-123.12661, 38.45184], [-123.12751, 38.45215], [-123.12724, 38.45246], [-123.12911, 38.45328], [-123.12964, 38.45331], [-123.12967, 38.4532], [-123.13023, 38.45328], [-123.13092, 38.45333], [-123.13106, 38.45336], [-123.13123, 38.45343], [-123.13146, 38.45359], [-123.13182, 38.45393], [-123.13269, 38.45449], [-123.13278, 38.45456], [-123.13283, 38.45465], [-123.13285, 38.45478], [-123.13281, 38.45488], [-123.13273, 38.45502], [-123.13271, 38.45513], [-123.13275, 38.45525], [-123.13285, 38.45533], [-123.13294, 38.45536], [-123.13308, 38.45536], [-123.13325, 38.45533], [-123.13373, 38.4552], [-123.13393, 38.4552], [-123.13499, 38.4555], [-123.13537, 38.45563], [-123.13577, 38.4558], [-123.13596, 38.45591], [-123.13607, 38.456], [-123.13619, 38.45613], [-123.13649, 38.45664], [-123.13654, 38.45679], [-123.13655, 38.45694], [-123.1365, 38.45711], [-123.13644, 38.45724], [-123.13602, 38.45781], [-123.13587, 38.45806], [-123.13582, 38.45823], [-123.1358, 38.45845], [-123.13575, 38.45861], [-123.13568, 38.45871], [-123.13543, 38.45893], [-123.13538, 38.45901], [-123.13535, 38.45914], [-123.13538, 38.45924], [-123.13544, 38.45931], [-123.13555, 38.45938], [-123.13568, 38.45941], [-123.13582, 38.45942], [-123.13698, 38.45938], [-123.13733, 38.45934], [-123.13766, 38.45923], [-123.13788, 38.45911], [-123.13809, 38.45891], [-123.13822, 38.45876], [-123.13867, 38.45815], [-123.13884, 38.45797], [-123.13906, 38.4578], [-123.13924, 38.45772], [-123.13946, 38.45765], [-123.13965, 38.45761], [-123.13993, 38.45758], [-123.1403, 38.45761], [-123.14066, 38.4577], [-123.14087, 38.45779], [-123.14101, 38.45786], [-123.14113, 38.45794], [-123.14141, 38.45818], [-123.1441, 38.46069], [-123.14456, 38.46105], [-123.1463, 38.46222], [-123.14662, 38.46237], [-123.14743, 38.46265], [-123.14777, 38.46281], [-123.14766, 38.46294], [-123.14934, 38.46391], [-123.14975, 38.46424], [-123.15067, 38.46479], [-123.14913, 38.46785], [-123.15001, 38.46876], [-123.15246, 38.46716], [-123.15222, 38.46612], [-123.15162, 38.46561], [-123.1529, 38.46582], [-123.15331, 38.46658], [-123.15326, 38.46751], [-123.15305, 38.46757], [-123.15316, 38.46828], [-123.15339, 38.46828], [-123.15353, 38.46907]]]} | Open Access 1 | 47580 | Jenner Headlands Preserve | 33778 | 3092 | The Wildlands Conservancy 228 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/ | Non Governmental Organization 10 | 3092 | The Wildlands Conservancy 224 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/preserve_jenner.html | Sonoma 16 | 5645.951 | Jenner Headlands Preserve | 2009 | Private Conservation 16 | 2 |
| 9652 | 9652 | 9651 | {"type": "Polygon", "coordinates": [[[-122.48913, 38.1515], [-122.48712, 38.1504], [-122.48423, 38.14884], [-122.4679, 38.16216], [-122.46698, 38.16178], [-122.46518, 38.16124], [-122.46491, 38.16041], [-122.46619, 38.15946], [-122.46632, 38.1583], [-122.46645, 38.15776], [-122.46648, 38.15745], [-122.46468, 38.15337], [-122.46436, 38.1532], [-122.46415, 38.153], [-122.4639, 38.15267], [-122.45849, 38.14981], [-122.45767, 38.14948], [-122.45694, 38.1492], [-122.4559, 38.14713], [-122.4569, 38.14626], [-122.45911, 38.14478], [-122.46117, 38.14358], [-122.46314, 38.14239], [-122.46372, 38.14217], [-122.4675, 38.13994], [-122.47004, 38.13833], [-122.47107, 38.13772], [-122.47171, 38.13729], [-122.47242, 38.13691], [-122.47378, 38.13622], [-122.47453, 38.13576], [-122.47479, 38.13563], [-122.47497, 38.13562], [-122.47658, 38.13567], [-122.47696, 38.13572], [-122.4772, 38.13586], [-122.47768, 38.13634], [-122.47849, 38.1372], [-122.47884, 38.13754], [-122.47902, 38.13779], [-122.47652, 38.13926], [-122.4748, 38.14021], [-122.47732, 38.1425], [-122.47873, 38.1456], [-122.48124, 38.14463], [-122.48348, 38.14378], [-122.48774, 38.14948], [-122.48913, 38.1515]]]} | Open Access 1 | 16273 | Sears Point Ranch | 30372 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 900.38 | Sears Point Ranch | 0 | Private Conservation 16 | 2 | |
| 9658 | 9658 | 9657 | {"type": "Polygon", "coordinates": [[[-122.76949, 38.74085], [-122.76573, 38.73744], [-122.76241, 38.73972], [-122.7624, 38.73911], [-122.75779, 38.73936], [-122.7577, 38.73559], [-122.75417, 38.73553], [-122.75429, 38.73194], [-122.75071, 38.73192], [-122.75078, 38.72832], [-122.74803, 38.7283], [-122.74762, 38.72114], [-122.7511, 38.72112], [-122.7511, 38.71423], [-122.75872, 38.7141], [-122.75911, 38.70825], [-122.75919, 38.70742], [-122.7593, 38.69993], [-122.76654, 38.70011], [-122.76878, 38.70013], [-122.76879, 38.70105], [-122.76855, 38.70749], [-122.76741, 38.72074], [-122.76737, 38.72247], [-122.76682, 38.72313], [-122.76686, 38.72316], [-122.76696, 38.72317], [-122.76707, 38.72315], [-122.76729, 38.72306], [-122.76741, 38.72306], [-122.76753, 38.72308], [-122.76767, 38.72317], [-122.76773, 38.72325], [-122.76776, 38.72333], [-122.76782, 38.72339], [-122.7679, 38.72344], [-122.7681, 38.72349], [-122.76816, 38.72353], [-122.76823, 38.72361], [-122.76824, 38.72369], [-122.76821, 38.72384], [-122.76816, 38.72393], [-122.76783, 38.72437], [-122.76778, 38.72447], [-122.76776, 38.72456], [-122.76776, 38.72466], [-122.76784, 38.72482], [-122.76781, 38.72493], [-122.76774, 38.72498], [-122.76765, 38.725], [-122.76759, 38.72499], [-122.76735, 38.7249], [-122.76731, 38.72491], [-122.76703, 38.73525], [-122.76936, 38.73517], [-122.76949, 38.74085]]]} | Open Access 1 | 16287 | Modini Mayacamas Preserves | 383 | 3005 | Audubon Canyon Ranch 837 | Non Profit 6 | Non Profit - Conservation 12 | http://www.egret.org | Non Governmental Organization 10 | 3005 | Audubon Canyon Ranch 814 | Non Profit 6 | Non Profit - Conservation 12 | http://egret.org/visit_modini_mayacamas | Sonoma 16 | 1278.975 | Modini Mayacamas Preserves | 0 | Private Conservation 16 | 2 |
| 14228 | 14228 | 14227 | {"type": "Polygon", "coordinates": [[[-123.13174, 38.50312], [-123.13179, 38.50561], [-123.13184, 38.50667], [-123.13149, 38.50846], [-123.12478, 38.50859], [-123.11624, 38.50855], [-123.11607, 38.50388], [-123.11602, 38.50146], [-123.12481, 38.50138], [-123.12482, 38.50316], [-123.13174, 38.50312]]]} | Open Access 1 | 46886 | Pole Mountain | 30375 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 237.859 | Pole Mtn. | 0 | Private Conservation 16 | 2 | |
| 14649 | 14649 | 14648 | {"type": "Polygon", "coordinates": [[[-122.49414, 38.14246], [-122.49422, 38.14826], [-122.49409, 38.15389], [-122.48997, 38.15168], [-122.48963, 38.15145], [-122.48931, 38.15118], [-122.48914, 38.15098], [-122.48374, 38.14381], [-122.48113, 38.14024], [-122.48862, 38.14023], [-122.49094, 38.14008], [-122.49182, 38.14021], [-122.49201, 38.14029], [-122.49212, 38.14022], [-122.49271, 38.14038], [-122.4932, 38.14056], [-122.49309, 38.14105], [-122.49306, 38.14115], [-122.49304, 38.1414], [-122.49308, 38.14159], [-122.49317, 38.14184], [-122.49337, 38.14213], [-122.49353, 38.14221], [-122.49414, 38.14246]]]} | Open Access 1 | 44917 | Lakeville Property | 28163 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/explore/interactive_map/map.php | Sonoma 16 | 248.564 | Lakeville Property | 0 | Private Conservation 16 | 2 |
| 14650 | 14650 | 14649 | {"type": "Polygon", "coordinates": [[[-122.52153, 38.36819], [-122.52135, 38.36832], [-122.52125, 38.36844], [-122.52062, 38.36888], [-122.52047, 38.36894], [-122.52018, 38.36901], [-122.51901, 38.36925], [-122.51878, 38.36932], [-122.51813, 38.3696], [-122.51797, 38.36971], [-122.51815, 38.36947], [-122.51862, 38.36901], [-122.51892, 38.36884], [-122.51915, 38.36873], [-122.51948, 38.36861], [-122.5215, 38.36809], [-122.52153, 38.36819]]]} | Open Access 1 | 44918 | Stuart Creek Run | 28159 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 3.571 | Stuart Creek Run | 0 | Private Conservation 16 | 2 | |
| 14657 | 14657 | 14656 | {"type": "Polygon", "coordinates": [[[-122.51831, 38.36893], [-122.51815, 38.36907], [-122.51797, 38.36927], [-122.51779, 38.36926], [-122.51731, 38.36899], [-122.51679, 38.36894], [-122.51658, 38.36902], [-122.51566, 38.3693], [-122.51514, 38.36956], [-122.51401, 38.36831], [-122.51659, 38.36699], [-122.51831, 38.36893]]]} | Open Access 1 | 44919 | Stuart Creek Hill | 28160 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 13.645 | Stuart Creek Hill | 0 | Private Conservation 16 | 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]);