superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "Vargas Plateau RP", MNG_AGENCY = 87 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15123 | 15123 | 15122 | {"type": "Polygon", "coordinates": [[[-121.96185, 37.57989], [-121.96136, 37.58008], [-121.96009, 37.58126], [-121.95896, 37.58058], [-121.95651, 37.5797], [-121.95482, 37.57916], [-121.95245, 37.5782], [-121.95134, 37.57963], [-121.95129, 37.57974], [-121.95028, 37.58068], [-121.95033, 37.58077], [-121.95032, 37.58091], [-121.95009, 37.581], [-121.94936, 37.58153], [-121.94913, 37.58161], [-121.94988, 37.58326], [-121.94994, 37.58359], [-121.95368, 37.58319], [-121.95714, 37.58286], [-121.95905, 37.58265], [-121.95888, 37.58306], [-121.95919, 37.5848], [-121.95871, 37.58618], [-121.95904, 37.58686], [-121.95896, 37.58689], [-121.95861, 37.58708], [-121.95844, 37.58734], [-121.9583, 37.58743], [-121.95817, 37.58763], [-121.95687, 37.58866], [-121.95651, 37.58876], [-121.95614, 37.58878], [-121.95596, 37.58883], [-121.95569, 37.58881], [-121.95545, 37.58884], [-121.95525, 37.58898], [-121.95474, 37.58917], [-121.95406, 37.58935], [-121.95351, 37.58957], [-121.95286, 37.58975], [-121.95253, 37.58991], [-121.95203, 37.59006], [-121.95155, 37.59016], [-121.95136, 37.59028], [-121.95105, 37.5903], [-121.95097, 37.59067], [-121.95072, 37.59077], [-121.94787, 37.59175], [-121.94787, 37.59177], [-121.94801, 37.59185], [-121.948, 37.59278], [-121.94835, 37.59315], [-121.94856, 37.59424], [-121.94881, 37.59456], [-121.94934, 37.59486], [-121.94961, 37.59494], [-121.94957, 37.59508], [-121.94869, 37.59596], [-121.94995, 37.59692], [-121.94911, 37.59716], [-121.94728, 37.59742], [-121.94711, 37.59741], [-121.94706, 37.59737], [-121.94699, 37.59717], [-121.94669, 37.59704], [-121.94594, 37.59687], [-121.94494, 37.59694], [-121.94423, 37.59694], [-121.94375, 37.59699], [-121.94289, 37.59728], [-121.94261, 37.59733], [-121.94155, 37.5977], [-121.94096, 37.59805], [-121.94051, 37.59822], [-121.94001, 37.59832], [-121.93944, 37.59839], [-121.93886, 37.59837], [-121.93856, 37.5982], [-121.93827, 37.59798], [-121.93812, 37.59779], [-121.93805, 37.59763], [-121.93803, 37.59733], [-121.93805, 37.59691], [-121.93814, 37.59689], [-121.94449, 37.5966], [-121.94453, 37.5959], [-121.93949, 37.59431], [-121.93954, 37.5932], [-121.93939, 37.59171], [-121.93776, 37.59095], [-121.93569, 37.5872], [-121.93383, 37.5841], [-121.93239, 37.58293], [-121.93293, 37.5824], [-121.93027, 37.58028], [-121.92941, 37.57875], [-121.93081, 37.57686], [-121.93131, 37.57628], [-121.93276, 37.57397], [-121.93383, 37.57506], [-121.93618, 37.57415], [-121.93661, 37.57385], [-121.93739, 37.57328], [-121.938, 37.57258], [-121.93855, 37.57206], [-121.93889, 37.57182], [-121.93938, 37.57122], [-121.93957, 37.57078], [-121.93968, 37.57071], [-121.94005, 37.57056], [-121.94039, 37.57051], [-121.94048, 37.57052], [-121.94067, 37.57049], [-121.94222, 37.57063], [-121.94283, 37.57077], [-121.94359, 37.57069], [-121.94377, 37.5705], [-121.94417, 37.57054], [-121.94422, 37.57052], [-121.94445, 37.57055], [-121.94496, 37.57023], [-121.94579, 37.57009], [-121.94644, 37.56994], [-121.94675, 37.56992], [-121.94722, 37.56996], [-121.9478, 37.56989], [-121.94801, 37.56988], [-121.94827, 37.56992], [-121.94853, 37.57001], [-121.94885, 37.57014], [-121.94932, 37.5704], [-121.9496, 37.57049], [-121.94978, 37.5705], [-121.95006, 37.57043], [-121.95033, 37.57046], [-121.95075, 37.57047], [-121.95149, 37.57059], [-121.95202, 37.57059], [-121.95235, 37.57069], [-121.95259, 37.57072], [-121.95318, 37.5706], [-121.9542, 37.5703], [-121.95482, 37.57017], [-121.95499, 37.5701], [-121.95582, 37.56967], [-121.95694, 37.57054], [-121.95788, 37.57133], [-121.95821, 37.57193], [-121.95852, 37.574], [-121.95896, 37.57507], [-121.95935, 37.57641], [-121.96086, 37.57834], [-121.96185, 37.57989]], [[-121.95725, 37.58544], [-121.95711, 37.58574], [-121.95776, 37.58591], [-121.95788, 37.58561], [-121.95725, 37.58544]]]} | Open Access 1 | Vargas Plateau Regional Park | 30630 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 1260.535 | Vargas Plateau RP | 2016 |
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]);