units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and UNIT_NAME = "San Vicente Reservoir"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8019 | 8019 | 8018 | {"type": "Polygon", "coordinates": [[[-116.94506, 32.91553], [-116.94466, 32.91916], [-116.94182, 32.91919], [-116.94182, 32.92273], [-116.94468, 32.92624], [-116.9447, 32.93354], [-116.94048, 32.93366], [-116.94047, 32.93556], [-116.93617, 32.93562], [-116.93614, 32.93378], [-116.92764, 32.93401], [-116.92764, 32.93755], [-116.92218, 32.93627], [-116.9225, 32.94033], [-116.91741, 32.93947], [-116.91845, 32.9482], [-116.9159, 32.94755], [-116.91576, 32.94657], [-116.91448, 32.94623], [-116.91438, 32.94521], [-116.91304, 32.94488], [-116.91307, 32.94542], [-116.91306, 32.94558], [-116.91308, 32.94561], [-116.9131, 32.94587], [-116.9119, 32.94557], [-116.91196, 32.94651], [-116.90807, 32.94551], [-116.90812, 32.95317], [-116.90817, 32.9541], [-116.90471, 32.95723], [-116.90358, 32.95723], [-116.90357, 32.95727], [-116.90359, 32.9583], [-116.90151, 32.96021], [-116.90121, 32.96015], [-116.90097, 32.96009], [-116.90083, 32.96009], [-116.90068, 32.96012], [-116.90057, 32.96006], [-116.90045, 32.95995], [-116.90024, 32.9597], [-116.90007, 32.95928], [-116.89998, 32.95919], [-116.89982, 32.95916], [-116.89957, 32.9592], [-116.89949, 32.95923], [-116.89942, 32.95929], [-116.89937, 32.9594], [-116.89943, 32.95941], [-116.89952, 32.95935], [-116.89953, 32.95932], [-116.8996, 32.9593], [-116.89985, 32.95927], [-116.89991, 32.95929], [-116.89997, 32.95934], [-116.90013, 32.95975], [-116.90019, 32.95984], [-116.90048, 32.96014], [-116.90061, 32.9602], [-116.9007, 32.96022], [-116.90092, 32.9602], [-116.90108, 32.96023], [-116.90108, 32.96025], [-116.90072, 32.96051], [-116.89939, 32.9605], [-116.89937, 32.95978], [-116.89932, 32.95942], [-116.89923, 32.95728], [-116.90056, 32.9572], [-116.9048, 32.95324], [-116.90358, 32.95326], [-116.90351, 32.94937], [-116.89898, 32.94943], [-116.89892, 32.94619], [-116.89888, 32.94179], [-116.89438, 32.94175], [-116.89435, 32.93428], [-116.8899, 32.93422], [-116.88989, 32.93367], [-116.88991, 32.93085], [-116.89874, 32.93078], [-116.89882, 32.92721], [-116.9032, 32.92717], [-116.90314, 32.91651], [-116.90947, 32.91653], [-116.90951, 32.91547], [-116.91165, 32.91576], [-116.91178, 32.91358], [-116.91194, 32.91346], [-116.91203, 32.91343], [-116.91213, 32.91343], [-116.91235, 32.91346], [-116.91244, 32.91346], [-116.91252, 32.91343], [-116.91257, 32.91337], [-116.91258, 32.91334], [-116.91256, 32.91328], [-116.91251, 32.91324], [-116.91435, 32.91334], [-116.91483, 32.91338], [-116.91607, 32.91346], [-116.91633, 32.91175], [-116.91651, 32.91039], [-116.92236, 32.91106], [-116.92267, 32.90393], [-116.92826, 32.90465], [-116.9284, 32.90439], [-116.9286, 32.90408], [-116.929, 32.90357], [-116.92918, 32.90342], [-116.93015, 32.90247], [-116.93042, 32.90226], [-116.92918, 32.90344], [-116.92917, 32.90347], [-116.92895, 32.90368], [-116.92876, 32.90394], [-116.92863, 32.90416], [-116.92853, 32.90439], [-116.92845, 32.90467], [-116.93335, 32.90532], [-116.93337, 32.90531], [-116.93641, 32.90571], [-116.93641, 32.91193], [-116.94091, 32.91195], [-116.94068, 32.91554], [-116.94506, 32.91553]]]} | Open Access 1 | 11309 | San Vicente Reservoir | 10541 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/water/recreation/reservoirs/sanvicente.shtml | San Diego 4 | 3583.905 | San Vicente Reservoir | 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]);