superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AG_TYP = 4 and YR_EST = 1982
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9232 | 9232 | 9231 | {"type": "MultiPolygon", "coordinates": [[[[-121.96304, 37.93978], [-121.96305, 37.93982], [-121.96283, 37.94044], [-121.96271, 37.94113], [-121.96265, 37.94118], [-121.96266, 37.94099], [-121.96275, 37.9405], [-121.96283, 37.9402], [-121.963, 37.93975], [-121.96304, 37.93978]]], [[[-121.967, 37.94522], [-121.96692, 37.94523], [-121.96688, 37.94515], [-121.96662, 37.94479], [-121.9661, 37.94436], [-121.96423, 37.94346], [-121.96462, 37.94293], [-121.96447, 37.94288], [-121.96422, 37.94261], [-121.9641, 37.94241], [-121.96396, 37.94225], [-121.96369, 37.94199], [-121.96305, 37.94148], [-121.96287, 37.94147], [-121.9629, 37.94142], [-121.96307, 37.94142], [-121.96377, 37.94198], [-121.96401, 37.94221], [-121.96416, 37.94238], [-121.96429, 37.94259], [-121.96452, 37.94283], [-121.96475, 37.9429], [-121.96435, 37.94345], [-121.96617, 37.94432], [-121.9667, 37.94476], [-121.96695, 37.94513], [-121.967, 37.94522]]], [[[-121.96407, 37.93824], [-121.96335, 37.93918], [-121.96327, 37.9393], [-121.96312, 37.9396], [-121.96305, 37.93961], [-121.96316, 37.93934], [-121.96329, 37.93915], [-121.96399, 37.93823], [-121.96407, 37.93824]]], [[[-121.96826, 37.93546], [-121.96797, 37.93555], [-121.96726, 37.9357], [-121.96694, 37.93579], [-121.96664, 37.93591], [-121.96636, 37.93605], [-121.9661, 37.93622], [-121.96586, 37.93641], [-121.96569, 37.93657], [-121.96412, 37.93819], [-121.96404, 37.93818], [-121.96563, 37.93653], [-121.96585, 37.93633], [-121.9661, 37.93614], [-121.96637, 37.93598], [-121.96666, 37.93584], [-121.96696, 37.93572], [-121.96728, 37.93563], [-121.96782, 37.93553], [-121.96807, 37.93546], [-121.96826, 37.93546]]], [[[-121.96761, 37.94557], [-121.96754, 37.94563], [-121.96714, 37.94565], [-121.96699, 37.94536], [-121.96707, 37.94535], [-121.9672, 37.94559], [-121.96761, 37.94557]]], [[[-121.97369, 37.93539], [-121.97365, 37.93544], [-121.96855, 37.93551], [-121.96867, 37.93545], [-121.97369, 37.93539]]], [[[-122.08253, 37.97602], [-122.08247, 37.97608], [-122.08181, 37.97609], [-122.08181, 37.97604], [-122.08253, 37.97602]]], [[[-122.08523, 37.97718], [-122.08516, 37.97722], [-122.08511, 37.97722], [-122.08497, 37.97715], [-122.08485, 37.9771], [-122.08446, 37.97706], [-122.08405, 37.97641], [-122.08396, 37.97618], [-122.08386, 37.97606], [-122.08269, 37.97608], [-122.08276, 37.97602], [-122.08396, 37.976], [-122.08396, 37.97605], [-122.08403, 37.97614], [-122.08409, 37.97627], [-122.08413, 37.97639], [-122.08447, 37.97693], [-122.08458, 37.977], [-122.08484, 37.97704], [-122.08507, 37.97712], [-122.08514, 37.97711], [-122.08523, 37.97718]]]]} | Open Access 1 | California Riding and Hiking Trail | https://www.ebparks.org/parks/trails/california/default.htm | 33750 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 3.641 | California Riding and Hiking Trail | 1982 |
14695 | 14695 | 14694 | {"type": "Polygon", "coordinates": [[[-122.37309, 37.4127], [-122.37278, 37.41312], [-122.3725, 37.41327], [-122.37233, 37.41347], [-122.37222, 37.41377], [-122.37224, 37.41403], [-122.37217, 37.4142], [-122.372, 37.41444], [-122.37199, 37.41457], [-122.37186, 37.4151], [-122.37075, 37.41538], [-122.3705, 37.41597], [-122.36321, 37.4179], [-122.3644, 37.41943], [-122.36489, 37.4192], [-122.36989, 37.41948], [-122.36984, 37.41957], [-122.37003, 37.41988], [-122.36993, 37.42019], [-122.37001, 37.42044], [-122.37001, 37.42092], [-122.3698, 37.42131], [-122.36968, 37.42182], [-122.3696, 37.42207], [-122.36957, 37.42235], [-122.36889, 37.42374], [-122.36885, 37.42409], [-122.36853, 37.42428], [-122.36786, 37.42438], [-122.36763, 37.42469], [-122.36715, 37.42474], [-122.36689, 37.4248], [-122.36678, 37.42499], [-122.36614, 37.42537], [-122.36582, 37.42554], [-122.3656, 37.42561], [-122.36493, 37.42594], [-122.3647, 37.42612], [-122.36432, 37.42614], [-122.36369, 37.42602], [-122.36287, 37.42584], [-122.36166, 37.42542], [-122.36121, 37.42521], [-122.36023, 37.4249], [-122.35985, 37.42486], [-122.35896, 37.42485], [-122.35828, 37.42473], [-122.35773, 37.42449], [-122.35746, 37.42449], [-122.35663, 37.42518], [-122.35599, 37.42557], [-122.35456, 37.42361], [-122.35147, 37.42352], [-122.35641, 37.42926], [-122.36081, 37.42928], [-122.36975, 37.43652], [-122.37049, 37.43666], [-122.37051, 37.43691], [-122.37068, 37.43719], [-122.3707, 37.4373], [-122.37071, 37.43744], [-122.37074, 37.43755], [-122.37081, 37.43765], [-122.37099, 37.43771], [-122.37165, 37.44065], [-122.36917, 37.44065], [-122.36915, 37.44069], [-122.36907, 37.4407], [-122.36905, 37.44399], [-122.36914, 37.44412], [-122.36917, 37.44413], [-122.36911, 37.44781], [-122.35153, 37.44775], [-122.35157, 37.45131], [-122.34204, 37.4512], [-122.3415, 37.44987], [-122.34113, 37.44979], [-122.33954, 37.45059], [-122.33902, 37.45072], [-122.33869, 37.45023], [-122.33867, 37.45022], [-122.33832, 37.44979], [-122.33966, 37.44908], [-122.33908, 37.44844], [-122.33903, 37.44845], [-122.33914, 37.44653], [-122.33888, 37.44627], [-122.33894, 37.44577], [-122.33863, 37.44591], [-122.33825, 37.44597], [-122.33785, 37.44594], [-122.33768, 37.44584], [-122.33717, 37.44569], [-122.33685, 37.44569], [-122.33634, 37.44525], [-122.33586, 37.44523], [-122.33556, 37.44526], [-122.33535, 37.44539], [-122.33436, 37.4458], [-122.33431, 37.4458], [-122.33426, 37.44568], [-122.33408, 37.44537], [-122.33398, 37.44526], [-122.334, 37.44291], [-122.33473, 37.4429], [-122.33473, 37.4395], [-122.33481, 37.43223], [-122.31678, 37.43226], [-122.31677, 37.43227], [-122.31742, 37.43365], [-122.31683, 37.4336], [-122.31622, 37.43338], [-122.31608, 37.43325], [-122.31555, 37.43265], [-122.31468, 37.43145], [-122.31448, 37.43119], [-122.31404, 37.43069], [-122.31375, 37.43041], [-122.31342, 37.43016], [-122.31285, 37.42964], [-122.31188, 37.42882], [-122.31579, 37.42651], [-122.31821, 37.42505], [-122.3185, 37.42517], [-122.31924, 37.4246], [-122.3204, 37.42428], [-122.32071, 37.42391], [-122.32065, 37.423], [-122.32033, 37.42254], [-122.32027, 37.42186], [-122.32006, 37.42123], [-122.3204, 37.42087], [-122.32045, 37.42046], [-122.32026, 37.42028], [-122.3203, 37.42007], [-122.32096, 37.41998], [-122.32139, 37.42024], [-122.32158, 37.42118], [-122.32205, 37.42153], [-122.32308, 37.42152], [-122.32322, 37.4218], [-122.32333, 37.42233], [-122.32408, 37.4228], [-122.32443, 37.42329], [-122.32496, 37.42373], [-122.32526, 37.42369], [-122.32535, 37.42307], [-122.32561, 37.42267], [-122.32566, 37.42206], [-122.32589, 37.42157], [-122.32618, 37.42155], [-122.32691, 37.42189], [-122.32788, 37.42271], [-122.32862, 37.42304], [-122.32912, 37.42288], [-122.32882, 37.42227], [-122.32835, 37.42168], [-122.32842, 37.42147], [-122.32901, 37.42127], [-122.32982, 37.42127], [-122.33015, 37.42108], [-122.33013, 37.42026], [-122.33028, 37.42016], [-122.33097, 37.42054], [-122.3315, 37.42056], [-122.33186, 37.42126], [-122.33251, 37.42087], [-122.33338, 37.42119], [-122.33497, 37.42113], [-122.33567, 37.42158], [-122.33714, 37.42206], [-122.33729, 37.42206], [-122.33818, 37.42299], [-122.3384, 37.42304], [-122.33872, 37.42332], [-122.33906, 37.42341], [-122.33938, 37.42366], [-122.33982, 37.42365], [-122.34031, 37.42342], [-122.34064, 37.42311], [-122.34109, 37.42307], [-122.34158, 37.42307], [-122.34236, 37.42347], [-122.3427, 37.42353], [-122.34315, 37.42345], [-122.34353, 37.42323], [-122.34383, 37.423], [-122.34396, 37.42299], [-122.34421, 37.42311], [-122.3445, 37.42339], [-122.3453, 37.42388], [-122.34565, 37.42402], [-122.34593, 37.42401], [-122.34647, 37.42424], [-122.34688, 37.42425], [-122.34735, 37.42412], [-122.34758, 37.42418], [-122.3479, 37.42417], [-122.34867, 37.42379], [-122.349, 37.42339], [-122.34939, 37.42285], [-122.34968, 37.42252], [-122.34994, 37.42228], [-122.35027, 37.42164], [-122.35124, 37.42124], [-122.35147, 37.42133], [-122.35178, 37.42131], [-122.35193, 37.42117], [-122.35257, 37.42114], [-122.35288, 37.42096], [-122.35304, 37.42075], [-122.35359, 37.42038], [-122.35418, 37.42024], [-122.35481, 37.41979], [-122.35612, 37.41996], [-122.35653, 37.41974], [-122.35667, 37.41937], [-122.35663, 37.41913], [-122.35663, 37.41888], [-122.35671, 37.41854], [-122.35651, 37.418], [-122.35659, 37.41728], [-122.35642, 37.41698], [-122.35694, 37.41616], [-122.35716, 37.41595], [-122.35659, 37.41465], [-122.35603, 37.4147], [-122.35536, 37.41486], [-122.35551, 37.41457], [-122.35606, 37.4143], [-122.35646, 37.41369], [-122.35676, 37.41303], [-122.35662, 37.41262], [-122.35562, 37.41169], [-122.35551, 37.41144], [-122.35656, 37.41102], [-122.35669, 37.41056], [-122.35662, 37.41008], [-122.35673, 37.40966], [-122.35713, 37.40946], [-122.35823, 37.41034], [-122.35984, 37.40924], [-122.36012, 37.40833], [-122.36072, 37.40817], [-122.36165, 37.40905], [-122.36212, 37.40931], [-122.36321, 37.4104], [-122.36412, 37.41042], [-122.36561, 37.41066], [-122.36511, 37.41158], [-122.36714, 37.41232], [-122.36763, 37.41153], [-122.36839, 37.41211], [-122.36922, 37.41294], [-122.36962, 37.41289], [-122.37014, 37.413], [-122.37053, 37.41291], [-122.37063, 37.41285], [-122.3712, 37.41272], [-122.37164, 37.41284], [-122.37222, 37.4128], [-122.37309, 37.4127]], [[-122.34105, 37.44573], [-122.34188, 37.4443], [-122.34187, 37.44428], [-122.34131, 37.44432], [-122.34102, 37.4443], [-122.34045, 37.44434], [-122.3402, 37.44444], [-122.33995, 37.4448], [-122.33961, 37.44506], [-122.33952, 37.44521], [-122.33953, 37.44536], [-122.34071, 37.44608], [-122.34105, 37.44573]]]} | Open Access 1 | Purisima Creek Redwoods Open Space Preserve | http://www.openspace.org/preserves/pr_purisima.asp | 6528 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2835.599 | Purisima Creek Redwoods OSP | 1982 |
14710 | 14710 | 14709 | {"type": "Polygon", "coordinates": [[[-122.67299, 38.01771], [-122.67194, 38.01889], [-122.66833, 38.01851], [-122.66464, 38.01685], [-122.66456, 38.01582], [-122.66387, 38.01579], [-122.66385, 38.01511], [-122.66418, 38.01504], [-122.66421, 38.01496], [-122.66456, 38.01488], [-122.66457, 38.01468], [-122.66471, 38.01468], [-122.66501, 38.0158], [-122.66727, 38.01649], [-122.67073, 38.01735], [-122.67135, 38.01679], [-122.67271, 38.01751], [-122.67299, 38.01771]]]} | Open Access 1 | Maurice Thorner Memorial Open Space Preserve | 21960 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 31.818 | Maurice Thorner Memorial OSP | 1982 |
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]);