units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3 and UNIT_NAME = "San Pablo Reservoir Recreation Area"
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16824 | 16824 | 16823 | {"type": "Polygon", "coordinates": [[[-122.26684, 37.94304], [-122.26626, 37.94348], [-122.2666, 37.94626], [-122.26004, 37.94558], [-122.25994, 37.94566], [-122.25984, 37.94571], [-122.2597, 37.94571], [-122.25949, 37.94554], [-122.25938, 37.94547], [-122.25881, 37.94416], [-122.25834, 37.94446], [-122.25747, 37.944], [-122.25632, 37.94381], [-122.25606, 37.94317], [-122.25548, 37.94276], [-122.25519, 37.94191], [-122.25381, 37.9414], [-122.25245, 37.94012], [-122.25107, 37.93955], [-122.25037, 37.93912], [-122.24921, 37.94049], [-122.24887, 37.94132], [-122.2489, 37.94191], [-122.24933, 37.94292], [-122.2493, 37.94335], [-122.2489, 37.94336], [-122.24797, 37.94292], [-122.24604, 37.94295], [-122.24549, 37.94338], [-122.24462, 37.94347], [-122.24294, 37.94391], [-122.24245, 37.94412], [-122.24211, 37.94439], [-122.24159, 37.94506], [-122.24046, 37.94515], [-122.24, 37.94533], [-122.23893, 37.94637], [-122.23861, 37.94689], [-122.23824, 37.94659], [-122.23936, 37.94478], [-122.23942, 37.94435], [-122.23927, 37.94401], [-122.2402, 37.944], [-122.24046, 37.94362], [-122.24242, 37.94286], [-122.24436, 37.94203], [-122.24499, 37.9416], [-122.2456, 37.94157], [-122.24644, 37.94068], [-122.24744, 37.93899], [-122.24765, 37.93846], [-122.24767, 37.9375], [-122.24735, 37.9367], [-122.24701, 37.93635], [-122.24695, 37.93578], [-122.24628, 37.93521], [-122.24605, 37.93477], [-122.24527, 37.93414], [-122.24498, 37.93283], [-122.2446, 37.93237], [-122.24434, 37.93219], [-122.24402, 37.93215], [-122.24322, 37.93285], [-122.24264, 37.93306], [-122.24258, 37.93153], [-122.24301, 37.93102], [-122.24295, 37.93065], [-122.24206, 37.92983], [-122.24185, 37.9291], [-122.24165, 37.92885], [-122.24199, 37.92844], [-122.24199, 37.92816], [-122.2417, 37.92791], [-122.24049, 37.92787], [-122.23977, 37.92844], [-122.23922, 37.92867], [-122.2387, 37.92864], [-122.23821, 37.92789], [-122.23821, 37.92757], [-122.23896, 37.92725], [-122.23928, 37.92665], [-122.23962, 37.92626], [-122.23899, 37.92522], [-122.23838, 37.92553], [-122.2382, 37.92602], [-122.23777, 37.92624], [-122.23731, 37.92613], [-122.23731, 37.92569], [-122.23702, 37.92544], [-122.23633, 37.92533], [-122.23592, 37.92517], [-122.23566, 37.92496], [-122.23543, 37.92416], [-122.2356, 37.92382], [-122.23559, 37.92354], [-122.23494, 37.92352], [-122.23355, 37.92469], [-122.23294, 37.92467], [-122.23352, 37.92384], [-122.23381, 37.92324], [-122.23369, 37.92286], [-122.23236, 37.9227], [-122.23236, 37.92231], [-122.23308, 37.92211], [-122.23308, 37.9221], [-122.23294, 37.92164], [-122.2321, 37.92121], [-122.23201, 37.91987], [-122.23163, 37.91952], [-122.23135, 37.9194], [-122.23008, 37.91979], [-122.2297, 37.9195], [-122.22935, 37.91941], [-122.22791, 37.91954], [-122.22641, 37.91964], [-122.22603, 37.91945], [-122.22623, 37.91916], [-122.22713, 37.91922], [-122.22773, 37.91902], [-122.22814, 37.91826], [-122.22817, 37.91785], [-122.22747, 37.91662], [-122.22747, 37.91547], [-122.22779, 37.91506], [-122.22779, 37.91449], [-122.22701, 37.91419], [-122.22634, 37.91327], [-122.22562, 37.91298], [-122.2253, 37.91215], [-122.22484, 37.91193], [-122.2248, 37.91101], [-122.22457, 37.91073], [-122.22457, 37.90993], [-122.22434, 37.90968], [-122.22371, 37.90943], [-122.22342, 37.90904], [-122.22295, 37.90863], [-122.22226, 37.90845], [-122.22174, 37.90792], [-122.22073, 37.90792], [-122.22041, 37.90788], [-122.21998, 37.90765], [-122.2192, 37.90751], [-122.21876, 37.90721], [-122.21836, 37.90717], [-122.21795, 37.90731], [-122.21683, 37.9074], [-122.21582, 37.9071], [-122.21472, 37.90589], [-122.21419, 37.90506], [-122.21417, 37.90424], [-122.21442, 37.90387], [-122.21088, 37.90009], [-122.21028, 37.89961], [-122.212, 37.89985], [-122.21336, 37.90033], [-122.21398, 37.90088], [-122.21458, 37.90156], [-122.21508, 37.90194], [-122.21568, 37.9026], [-122.21629, 37.90304], [-122.21773, 37.9034], [-122.22188, 37.90488], [-122.22305, 37.90491], [-122.22406, 37.90502], [-122.22493, 37.90483], [-122.22541, 37.90482], [-122.22656, 37.90526], [-122.22738, 37.90561], [-122.22819, 37.90608], [-122.22871, 37.90643], [-122.22918, 37.90665], [-122.22977, 37.90675], [-122.23001, 37.90721], [-122.23079, 37.90809], [-122.23105, 37.90819], [-122.23116, 37.90842], [-122.23144, 37.90851], [-122.23179, 37.90884], [-122.23219, 37.90892], [-122.23276, 37.90924], [-122.23376, 37.91036], [-122.23376, 37.91105], [-122.23424, 37.91204], [-122.23403, 37.9129], [-122.23416, 37.9134], [-122.23464, 37.9145], [-122.23553, 37.91552], [-122.23644, 37.91591], [-122.23693, 37.91639], [-122.23843, 37.91679], [-122.23926, 37.91656], [-122.23976, 37.91676], [-122.24019, 37.91713], [-122.24121, 37.91728], [-122.2423, 37.91797], [-122.24287, 37.91808], [-122.24329, 37.91857], [-122.24349, 37.919], [-122.24386, 37.92032], [-122.2442, 37.92058], [-122.24471, 37.92066], [-122.24501, 37.92081], [-122.2456, 37.92084], [-122.24636, 37.92139], [-122.24778, 37.92237], [-122.24829, 37.92264], [-122.24919, 37.92343], [-122.24962, 37.92483], [-122.24993, 37.92514], [-122.25051, 37.92542], [-122.25094, 37.92603], [-122.25183, 37.92646], [-122.25259, 37.92663], [-122.25297, 37.92638], [-122.2541, 37.927], [-122.25473, 37.92771], [-122.25508, 37.92819], [-122.2552, 37.92859], [-122.25501, 37.93002], [-122.25556, 37.93043], [-122.25576, 37.93076], [-122.25579, 37.93118], [-122.25608, 37.93147], [-122.25715, 37.93201], [-122.25749, 37.93249], [-122.25792, 37.93295], [-122.25801, 37.9335], [-122.25878, 37.93389], [-122.2587, 37.93491], [-122.25887, 37.93523], [-122.25923, 37.93636], [-122.25935, 37.93702], [-122.26044, 37.93853], [-122.26086, 37.93884], [-122.26109, 37.93954], [-122.26212, 37.93996], [-122.26228, 37.94012], [-122.26239, 37.94048], [-122.26311, 37.941], [-122.26374, 37.94114], [-122.26456, 37.9418], [-122.26579, 37.9421], [-122.2667, 37.943], [-122.26684, 37.94304]]]} | Open Access 1 | 35114 | San Pablo Reservoir Recreation Area | 29294 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 2031 | East Bay Municipal Utility District 427 | Special District 4 | Water District 13 | https://www.ebmud.com/recreation/san-pablo-reservoir | Contra Costa 12 | 1258.808 | San Pablo Reservoir Rec. Area | 0 | Local Recreation Area 3 | 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]);