units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 16, DES_TP = 16 and MNG_AGENCY = 224
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- The Wildlands Conservancy · 2 ✖
DES_TP 1
- Private Conservation · 2 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7069 | 7069 | 7068 | {"type": "Polygon", "coordinates": [[[-123.01386, 38.31434], [-123.01002, 38.3143], [-123.00814, 38.31429], [-123.00245, 38.31411], [-123.0023, 38.31424], [-123.0022, 38.3144], [-123.00205, 38.31453], [-123.00187, 38.31464], [-122.99666, 38.30504], [-122.99501, 38.30525], [-122.99554, 38.30466], [-122.99486, 38.30372], [-122.99439, 38.30005], [-122.99478, 38.29961], [-122.99675, 38.29965], [-122.99733, 38.29973], [-122.99963, 38.29915], [-122.99977, 38.2988], [-123.00043, 38.29842], [-123.00176, 38.29807], [-123.00219, 38.29769], [-123.00325, 38.29684], [-123.00604, 38.29753], [-123.00633, 38.29757], [-123.00696, 38.29822], [-123.00801, 38.29894], [-123.01009, 38.30083], [-123.01048, 38.30104], [-123.01147, 38.30205], [-123.01274, 38.30297], [-123.01309, 38.30341], [-123.01267, 38.30378], [-123.01248, 38.30387], [-123.0122, 38.30391], [-123.0122, 38.30408], [-123.01231, 38.30426], [-123.01018, 38.30693], [-123.00978, 38.30732], [-123.00968, 38.30746], [-123.00962, 38.30758], [-123.00923, 38.30803], [-123.01266, 38.31021], [-123.01302, 38.3108], [-123.01386, 38.31434]]]} | Restricted Access 2 | 47579 | Estero Americano Coast Preserve | 31306 | 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_estero.html | Sonoma 16 | 534.989 | Estero Americano Coast Preserve | 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 |
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]);