superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 2 and YR_EST = 2003
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, LAYER
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3212 | 3212 | 3211 | {"type": "Polygon", "coordinates": [[[-121.4409, 38.26568], [-121.4405, 38.26654], [-121.43893, 38.26623], [-121.43872, 38.26566], [-121.43905, 38.26515], [-121.43899, 38.26457], [-121.44061, 38.26555], [-121.4409, 38.26568]]]} | Restricted Access 2 | Cosumnes River Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cosumnes-River-ER | 17675 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 5.743 | Cosumnes River ER | 2003 |
13724 | 13724 | 13723 | {"type": "MultiPolygon", "coordinates": [[[[-122.32741, 37.14284], [-122.32714, 37.14347], [-122.32655, 37.14419], [-122.32659, 37.14425], [-122.32635, 37.14448], [-122.32503, 37.14518], [-122.32041, 37.14207], [-122.32012, 37.14206], [-122.31984, 37.14197], [-122.31969, 37.14186], [-122.31953, 37.14171], [-122.31951, 37.14157], [-122.3194, 37.14146], [-122.31921, 37.14132], [-122.31909, 37.14122], [-122.31847, 37.14093], [-122.31833, 37.14084], [-122.31821, 37.14074], [-122.31806, 37.14068], [-122.31789, 37.14063], [-122.3176, 37.14047], [-122.31728, 37.14035], [-122.31671, 37.14023], [-122.31598, 37.14017], [-122.31507, 37.14021], [-122.31469, 37.14019], [-122.31474, 37.13998], [-122.31591, 37.13998], [-122.31622, 37.14007], [-122.31681, 37.13974], [-122.31636, 37.13934], [-122.31598, 37.13892], [-122.31583, 37.13895], [-122.3158, 37.13892], [-122.31557, 37.139], [-122.31498, 37.13835], [-122.31505, 37.13831], [-122.31505, 37.13829], [-122.31314, 37.13613], [-122.31577, 37.13477], [-122.32065, 37.13982], [-122.32108, 37.14022], [-122.32156, 37.14058], [-122.32192, 37.14082], [-122.32236, 37.14106], [-122.32309, 37.1414], [-122.32348, 37.14156], [-122.32513, 37.1421], [-122.32517, 37.14208], [-122.32741, 37.14284]]], [[[-122.33433, 37.13521], [-122.33247, 37.13613], [-122.33252, 37.13834], [-122.33203, 37.13838], [-122.33175, 37.13835], [-122.33152, 37.1386], [-122.33151, 37.13868], [-122.33135, 37.13904], [-122.33118, 37.13917], [-122.33089, 37.13931], [-122.33051, 37.13942], [-122.33031, 37.13963], [-122.3302, 37.13989], [-122.33012, 37.14016], [-122.3299, 37.14031], [-122.32948, 37.14052], [-122.32877, 37.14075], [-122.32857, 37.14103], [-122.32809, 37.14106], [-122.32753, 37.1412], [-122.32688, 37.14128], [-122.32644, 37.14131], [-122.326, 37.14148], [-122.32563, 37.14174], [-122.32349, 37.14099], [-122.323, 37.1408], [-122.32236, 37.14048], [-122.32194, 37.14021], [-122.3217, 37.14004], [-122.32132, 37.13973], [-122.32111, 37.13953], [-122.31997, 37.13828], [-122.31976, 37.1381], [-122.31617, 37.13441], [-122.3303, 37.12878], [-122.33433, 37.13521]]]]} | Restricted Access 2 | Cascade Ranch | 31226 | 3377 | Cascade Ranch Historic Farm 709 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 420.592 | Cascade Ranch | 2003 | ||
13761 | 13761 | 13760 | {"type": "Polygon", "coordinates": [[[-123.07275, 38.37014], [-123.07057, 38.37134], [-123.06942, 38.37164], [-123.0685, 38.37149], [-123.06748, 38.37154], [-123.06637, 38.37194], [-123.06309, 38.36451], [-123.06149, 38.36456], [-123.05809, 38.35921], [-123.05832, 38.35919], [-123.05836, 38.35916], [-123.0584, 38.35911], [-123.05846, 38.35891], [-123.05851, 38.35864], [-123.05854, 38.35835], [-123.05851, 38.35812], [-123.05851, 38.35799], [-123.05848, 38.35785], [-123.0583, 38.35731], [-123.05826, 38.35715], [-123.05826, 38.35706], [-123.05823, 38.35697], [-123.05822, 38.35682], [-123.05822, 38.35627], [-123.0582, 38.35599], [-123.05824, 38.35569], [-123.05831, 38.35553], [-123.05839, 38.35542], [-123.05872, 38.35516], [-123.05927, 38.3549], [-123.05942, 38.35485], [-123.05994, 38.35473], [-123.06015, 38.35469], [-123.06041, 38.35468], [-123.06101, 38.35462], [-123.06128, 38.35457], [-123.06153, 38.35449], [-123.06171, 38.35436], [-123.06179, 38.35419], [-123.06177, 38.3541], [-123.06176, 38.35385], [-123.06179, 38.35378], [-123.06188, 38.35331], [-123.06184, 38.35315], [-123.06172, 38.35292], [-123.06172, 38.35287], [-123.06166, 38.35281], [-123.06163, 38.35274], [-123.06158, 38.35256], [-123.06249, 38.35334], [-123.06313, 38.35379], [-123.06445, 38.35463], [-123.06499, 38.35501], [-123.06561, 38.35547], [-123.0666, 38.35624], [-123.06683, 38.3565], [-123.06689, 38.35665], [-123.06694, 38.35688], [-123.06696, 38.35708], [-123.06696, 38.35747], [-123.06692, 38.35779], [-123.06695, 38.358], [-123.06706, 38.35821], [-123.0675, 38.35885], [-123.06775, 38.35926], [-123.06781, 38.35942], [-123.06797, 38.3601], [-123.06807, 38.36034], [-123.06817, 38.36051], [-123.06855, 38.361], [-123.06867, 38.36122], [-123.06873, 38.36144], [-123.06873, 38.36205], [-123.06878, 38.36226], [-123.06891, 38.36246], [-123.06962, 38.36317], [-123.06968, 38.36328], [-123.0698, 38.36358], [-123.06997, 38.36426], [-123.07005, 38.36441], [-123.07075, 38.36541], [-123.0715, 38.36668], [-123.07159, 38.36688], [-123.0717, 38.36731], [-123.07179, 38.36752], [-123.07194, 38.3677], [-123.07229, 38.36799], [-123.07245, 38.36823], [-123.07281, 38.3691], [-123.07287, 38.36927], [-123.07288, 38.36939], [-123.07287, 38.36952], [-123.07283, 38.3697], [-123.07275, 38.36998], [-123.07275, 38.37014]]]} | Restricted Access 2 | Carrington Coast Ranch | 31268 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 329.468 | Carrington Coast Ranch | 2003 | |
14762 | 14762 | 14761 | {"type": "Polygon", "coordinates": [[[-122.01096, 37.17045], [-122.01066, 37.17058], [-122.0105, 37.17074], [-122.0103, 37.17084], [-122.00975, 37.17124], [-122.00965, 37.17139], [-122.00932, 37.17152], [-122.00919, 37.17162], [-122.00907, 37.17163], [-122.00898, 37.17167], [-122.00854, 37.17155], [-122.00786, 37.17166], [-122.00758, 37.17183], [-122.00748, 37.17194], [-122.0073, 37.17197], [-122.00706, 37.17214], [-122.00678, 37.17245], [-122.00664, 37.1725], [-122.00652, 37.17265], [-122.00632, 37.17276], [-122.00628, 37.17289], [-122.00607, 37.17308], [-122.00594, 37.17325], [-122.00586, 37.17333], [-122.00565, 37.17343], [-122.00553, 37.17351], [-122.00539, 37.17356], [-122.00524, 37.1737], [-122.0052, 37.17384], [-122.00479, 37.17427], [-122.00493, 37.17449], [-122.00529, 37.1748], [-122.00566, 37.17501], [-122.00595, 37.17514], [-122.00624, 37.17533], [-122.00649, 37.17542], [-122.0068, 37.17558], [-122.00708, 37.17577], [-122.00747, 37.17586], [-122.00912, 37.17491], [-122.00915, 37.17502], [-122.00921, 37.17511], [-122.00935, 37.17526], [-122.00979, 37.17563], [-122.00993, 37.1757], [-122.01007, 37.17574], [-122.01035, 37.17576], [-122.01039, 37.17602], [-122.01024, 37.17631], [-122.01016, 37.17661], [-122.00971, 37.17712], [-122.00978, 37.17759], [-122.00995, 37.17776], [-122.01007, 37.17791], [-122.0101, 37.17808], [-122.01006, 37.1782], [-122.01002, 37.17823], [-122.00977, 37.17824], [-122.00928, 37.17868], [-122.00968, 37.17911], [-122.00968, 37.17931], [-122.00955, 37.17977], [-122.00931, 37.1799], [-122.00893, 37.17991], [-122.00843, 37.17999], [-122.00776, 37.17978], [-122.00713, 37.18034], [-122.00687, 37.18045], [-122.00652, 37.18046], [-122.00617, 37.18083], [-122.0057, 37.18106], [-122.0053, 37.18114], [-122.00509, 37.18109], [-122.0048, 37.18086], [-122.00442, 37.1804], [-122.00418, 37.18021], [-122.00373, 37.18015], [-122.00288, 37.18041], [-122.00259, 37.18084], [-122.00256, 37.18115], [-122.0031, 37.18184], [-122.00354, 37.18234], [-122.00452, 37.18287], [-122.00463, 37.18315], [-122.00485, 37.18341], [-122.00503, 37.18392], [-122.00501, 37.18399], [-122.00497, 37.18401], [-122.00443, 37.18397], [-122.00423, 37.18399], [-122.00388, 37.18413], [-122.00329, 37.1843], [-122.0032, 37.18431], [-122.00307, 37.18427], [-122.00275, 37.18414], [-122.00239, 37.18404], [-122.00238, 37.18429], [-122.0026, 37.1847], [-122.00273, 37.18509], [-122.0031, 37.18521], [-122.00276, 37.18561], [-122.00258, 37.18563], [-122.00218, 37.18559], [-122.00187, 37.18569], [-122.00186, 37.1857], [-122.00188, 37.18571], [-122.00155, 37.18585], [-122.00154, 37.18588], [-122.00128, 37.18594], [-122.00051, 37.18632], [-121.99863, 37.187], [-121.9984, 37.18703], [-121.99796, 37.18715], [-121.9978, 37.18717], [-121.99763, 37.18714], [-121.99731, 37.18705], [-121.99615, 37.18697], [-121.99586, 37.18703], [-121.99545, 37.18716], [-121.99524, 37.18728], [-121.9951, 37.18749], [-121.99508, 37.18772], [-121.99465, 37.18774], [-121.99471, 37.18951], [-121.99455, 37.18969], [-121.99421, 37.18993], [-121.99378, 37.19009], [-121.99339, 37.18947], [-121.99281, 37.1891], [-121.99224, 37.18819], [-121.99172, 37.18702], [-121.99235, 37.18587], [-121.99179, 37.18542], [-121.99214, 37.18481], [-121.9925, 37.18442], [-121.99327, 37.18282], [-121.99433, 37.18216], [-121.99402, 37.18107], [-121.99486, 37.17957], [-121.99613, 37.17899], [-121.99618, 37.17738], [-121.9968, 37.17713], [-121.99712, 37.17722], [-121.99772, 37.17722], [-121.99788, 37.17741], [-121.99816, 37.17741], [-121.99819, 37.1777], [-121.99826, 37.17776], [-121.99871, 37.17777], [-121.99875, 37.17773], [-121.99877, 37.17761], [-121.99923, 37.17747], [-121.99934, 37.17719], [-121.99965, 37.17714], [-121.9996, 37.17693], [-122.00017, 37.17674], [-122.00024, 37.17649], [-122.00024, 37.17631], [-122.00015, 37.176], [-122.00003, 37.17262], [-122.00092, 37.17055], [-122.00091, 37.17053], [-122.00017, 37.17054], [-122.00011, 37.16903], [-122.00007, 37.16709], [-122.0, 37.16707], [-121.9999, 37.1636], [-122.00339, 37.1636], [-122.00335, 37.15994], [-122.00784, 37.15996], [-122.008, 37.17046], [-122.01096, 37.17045]]]} | Restricted Access 2 | Bear Creek Redwoods Open Space Preserve | 31478 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 577.157 | Bear Creek Redwoods OSP | 2003 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);