units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where ACCESS_TYP = 1 and YR_EST = 2009
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
DES_TP 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
9516 | 9516 | 9515 | {"type": "Polygon", "coordinates": [[[-122.28661, 38.29915], [-122.28655, 38.29918], [-122.28646, 38.29908], [-122.28628, 38.29916], [-122.28622, 38.29909], [-122.28624, 38.29907], [-122.28614, 38.29895], [-122.28636, 38.29883], [-122.28661, 38.29915]]]} | Open Access 1 | 15968 | Dwight Murray Plaza | 30020 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.186 | Dwight Murray Plaza | 2009 | Local Park 2 | 4 | |
10923 | 10923 | 10922 | {"type": "Polygon", "coordinates": [[[-121.82111, 39.75364], [-121.82073, 39.75384], [-121.81754, 39.75473], [-121.81653, 39.75353], [-121.81834, 39.75217], [-121.81856, 39.75203], [-121.81882, 39.75191], [-121.81883, 39.75189], [-121.82111, 39.75364]]]} | Open Access 1 | 48669 | Verbena Fields | 33413 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 16.052 | Verbena Fields | 2009 | Local Recreation Area 3 | 4 | |
14701 | 14701 | 14700 | {"type": "Polygon", "coordinates": [[[-119.31061, 34.3893], [-119.30984, 34.39525], [-119.3074, 34.39503], [-119.30777, 34.39226], [-119.30787, 34.39109], [-119.30782, 34.39089], [-119.30758, 34.39039], [-119.30751, 34.39018], [-119.30745, 34.38994], [-119.30742, 34.38972], [-119.30743, 34.38939], [-119.30748, 34.38909], [-119.30759, 34.38877], [-119.30815, 34.38775], [-119.30831, 34.38732], [-119.3084, 34.38688], [-119.30843, 34.3865], [-119.31055, 34.3867], [-119.30993, 34.38752], [-119.31, 34.38844], [-119.31061, 34.3893]]]} | Open Access 1 | 48312 | Rio Vista Preserve | 32880 | 3296 | Ojai Valley Land Conservancy 1112 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | https://ovlc.org/preserves/rio-vista-preserve/ | Ventura 8 | 53.272 | Rio Vista Preserve | 2009 | Private Conservation 16 | 2 |
14876 | 14876 | 14875 | {"type": "Polygon", "coordinates": [[[-118.38886, 33.7537], [-118.38884, 33.75428], [-118.38568, 33.75472], [-118.38468, 33.75461], [-118.38403, 33.75377], [-118.38081, 33.75391], [-118.38052, 33.75579], [-118.3799, 33.75633], [-118.37866, 33.75701], [-118.37781, 33.75817], [-118.3771, 33.75868], [-118.37707, 33.75825], [-118.37711, 33.7576], [-118.37672, 33.75717], [-118.37591, 33.75727], [-118.37537, 33.75747], [-118.37496, 33.75736], [-118.37444, 33.7576], [-118.37405, 33.7573], [-118.37305, 33.75748], [-118.37273, 33.75801], [-118.37208, 33.75856], [-118.37204, 33.75801], [-118.3719, 33.75777], [-118.37171, 33.75778], [-118.37132, 33.75803], [-118.36941, 33.75792], [-118.36906, 33.7576], [-118.36876, 33.75761], [-118.36893, 33.75736], [-118.36946, 33.75731], [-118.3696, 33.75725], [-118.36996, 33.75672], [-118.36943, 33.75647], [-118.36924, 33.75632], [-118.36863, 33.75616], [-118.36873, 33.7559], [-118.36863, 33.75581], [-118.36675, 33.75661], [-118.36646, 33.75686], [-118.36637, 33.75679], [-118.36647, 33.75669], [-118.36628, 33.75629], [-118.36646, 33.75528], [-118.368, 33.754], [-118.36936, 33.75121], [-118.371, 33.7519], [-118.37101, 33.75208], [-118.37207, 33.75267], [-118.37212, 33.75284], [-118.37233, 33.75281], [-118.37205, 33.75415], [-118.37348, 33.75414], [-118.37418, 33.75324], [-118.37402, 33.75299], [-118.37386, 33.75259], [-118.37375, 33.7522], [-118.37377, 33.75166], [-118.37358, 33.75128], [-118.37308, 33.7509], [-118.37297, 33.75099], [-118.37276, 33.75087], [-118.37279, 33.75062], [-118.37327, 33.75061], [-118.37421, 33.75153], [-118.37399, 33.75225], [-118.37442, 33.75285], [-118.37497, 33.75239], [-118.37553, 33.75118], [-118.37586, 33.75109], [-118.37637, 33.7511], [-118.37727, 33.75155], [-118.37867, 33.75187], [-118.38047, 33.751], [-118.38057, 33.75145], [-118.38325, 33.75147], [-118.38324, 33.75182], [-118.38564, 33.7539], [-118.38797, 33.75337], [-118.38886, 33.7537]]]} | Open Access 1 | 45418 | Upper Filiorum Reserve | 32428 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 3052 | Palos Verdes Peninsula Land Conservancy 727 | Non Profit 6 | Non Profit - Land Trust 10 | http://pvplc.org/_lands/filiorum.asp | Los Angeles 6 | 207.362 | Upper Filiorum Reserve | 2009 | None 1282 | |
14925 | 14925 | 14924 | {"type": "Polygon", "coordinates": [[[-118.35363, 33.88347], [-118.35335, 33.88347], [-118.35335, 33.88312], [-118.35321, 33.88312], [-118.35321, 33.88276], [-118.35363, 33.88276], [-118.35363, 33.88347]]]} | Open Access 1 | 45499 | Charles B. Hopper Park | 28332 | 1172 | Lawndale, City of 484 | City 2 | City Agency 2 | http://www.lawndalecity.org/ | City 2 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/ASSETS/PDF/CSD/Parks%20%20Recreation%20City%20Parks%20Hopper.pdf | Los Angeles 6 | 0.627 | Charles B. Hopper Park | 2009 | Local Park 2 | 4 |
14928 | 14928 | 14927 | {"type": "Polygon", "coordinates": [[[-117.25461, 33.36874], [-117.2546, 33.3693], [-117.25423, 33.3693], [-117.25423, 33.36873], [-117.25461, 33.36874]]]} | Open Access 1 | 45505 | Clemmens Lane County Park | 28337 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Clemmens.html | San Diego 4 | 0.544 | Clemmens Lane County Park | 2009 | Local Park 2 | 4 |
16559 | 16559 | 16558 | {"type": "Polygon", "coordinates": [[[-121.84277, 36.6295], [-121.84251, 36.62983], [-121.83855, 36.63538], [-121.83232, 36.64513], [-121.82796, 36.65291], [-121.82051, 36.668], [-121.81674, 36.677], [-121.81473, 36.68272], [-121.8095, 36.68023], [-121.80948, 36.68025], [-121.80945, 36.68024], [-121.80754, 36.67933], [-121.81051, 36.67491], [-121.81114, 36.67399], [-121.81242, 36.67195], [-121.81273, 36.6715], [-121.81297, 36.67123], [-121.81327, 36.67084], [-121.81359, 36.67045], [-121.81399, 36.67], [-121.81416, 36.66968], [-121.81433, 36.66931], [-121.81469, 36.66864], [-121.81495, 36.66801], [-121.81542, 36.66667], [-121.81564, 36.66616], [-121.81575, 36.66597], [-121.81628, 36.66458], [-121.81648, 36.66398], [-121.81665, 36.66338], [-121.81686, 36.66247], [-121.81698, 36.66174], [-121.81751, 36.65727], [-121.81753, 36.65683], [-121.81752, 36.65626], [-121.81748, 36.65583], [-121.81739, 36.65531], [-121.81727, 36.65483], [-121.81709, 36.65427], [-121.81692, 36.65386], [-121.81652, 36.65303], [-121.8144, 36.65301], [-121.81463, 36.65297], [-121.81489, 36.65289], [-121.81587, 36.65241], [-121.81552, 36.65166], [-121.81536, 36.65126], [-121.81524, 36.65076], [-121.81518, 36.65034], [-121.81517, 36.64992], [-121.81519, 36.64958], [-121.81521, 36.64949], [-121.81527, 36.6493], [-121.81536, 36.64907], [-121.81547, 36.64885], [-121.81561, 36.64864], [-121.81578, 36.64843], [-121.81599, 36.64821], [-121.81624, 36.64801], [-121.81647, 36.64785], [-121.81681, 36.64766], [-121.81794, 36.64714], [-121.81852, 36.64681], [-121.82454, 36.64319], [-121.82513, 36.64279], [-121.82565, 36.64236], [-121.82609, 36.64194], [-121.83083, 36.63758], [-121.83114, 36.63726], [-121.83152, 36.63682], [-121.83185, 36.63636], [-121.83189, 36.63636], [-121.83219, 36.63587], [-121.83257, 36.63514], [-121.83278, 36.63477], [-121.83309, 36.63429], [-121.83345, 36.63383], [-121.8338, 36.63345], [-121.83902, 36.62797], [-121.83926, 36.62769], [-121.83942, 36.62746], [-121.83969, 36.62763], [-121.83951, 36.62787], [-121.83933, 36.62809], [-121.83933, 36.62811], [-121.84026, 36.62798], [-121.84277, 36.6295]]]} | Open Access 1 | 15891 | Fort Ord Dunes State Park | 1539 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=580 | Monterey 14 | 1039.014 | Fort Ord Dunes SP | 2009 | State Park 15 | 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]);