superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3 and ACRES = "449.17"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3052 | 3052 | 3051 | {"type": "MultiPolygon", "coordinates": [[[[-121.93312, 37.96917], [-121.93309, 37.9762], [-121.92398, 37.97636], [-121.92389, 37.98339], [-121.91481, 37.9835], [-121.91485, 37.97467], [-121.91541, 37.97455], [-121.91618, 37.97432], [-121.91638, 37.97432], [-121.91683, 37.97403], [-121.917, 37.97372], [-121.91739, 37.97344], [-121.91795, 37.97331], [-121.91823, 37.97315], [-121.91876, 37.97249], [-121.91908, 37.97226], [-121.91945, 37.97219], [-121.91991, 37.97201], [-121.92004, 37.97193], [-121.92076, 37.97121], [-121.92124, 37.97103], [-121.92209, 37.97065], [-121.92264, 37.97037], [-121.92271, 37.9702], [-121.9229, 37.97006], [-121.92356, 37.96996], [-121.92384, 37.9698], [-121.9245, 37.96925], [-121.93312, 37.96917]]], [[[-121.92264, 37.96928], [-121.922, 37.96996], [-121.92175, 37.97005], [-121.92152, 37.97027], [-121.92122, 37.97042], [-121.9205, 37.9709], [-121.91988, 37.97127], [-121.91761, 37.97247], [-121.91709, 37.97284], [-121.91631, 37.97367], [-121.91588, 37.97391], [-121.91493, 37.9742], [-121.91489, 37.96938], [-121.92264, 37.96928]]]]} | No Public Access 3 | CNWS to Black Diamond | 17451 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 449.17 | CNWS to Black Diamond |
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]);