units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, MNG_AG_TYP = 13 and YR_EST = 1979
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6102 | 6102 | 6101 | {"type": "Polygon", "coordinates": [[[-122.79576, 38.1413], [-122.79467, 38.14223], [-122.79458, 38.14495], [-122.79495, 38.1457], [-122.79546, 38.14663], [-122.79542, 38.14665], [-122.79543, 38.14669], [-122.7936, 38.1474], [-122.79335, 38.14774], [-122.7941, 38.14916], [-122.79361, 38.14914], [-122.79334, 38.14873], [-122.79301, 38.14888], [-122.79269, 38.14912], [-122.79201, 38.14945], [-122.79165, 38.1499], [-122.79081, 38.15007], [-122.7911, 38.15082], [-122.78952, 38.15196], [-122.79039, 38.15269], [-122.79057, 38.15325], [-122.79046, 38.15396], [-122.78981, 38.15442], [-122.78991, 38.15474], [-122.78595, 38.15441], [-122.78681, 38.15597], [-122.7863, 38.15575], [-122.78471, 38.15456], [-122.78189, 38.15463], [-122.78138, 38.15411], [-122.78108, 38.15398], [-122.78067, 38.15395], [-122.78063, 38.15371], [-122.78038, 38.1537], [-122.78006, 38.15234], [-122.78034, 38.15129], [-122.77998, 38.15059], [-122.77951, 38.14987], [-122.77751, 38.15037], [-122.77622, 38.14988], [-122.77325, 38.15204], [-122.77331, 38.15305], [-122.76909, 38.15508], [-122.76865, 38.15547], [-122.76858, 38.15577], [-122.76455, 38.1558], [-122.7615, 38.15536], [-122.76127, 38.15458], [-122.75946, 38.15235], [-122.76, 38.15155], [-122.75844, 38.15059], [-122.75768, 38.15078], [-122.75728, 38.15027], [-122.75631, 38.15007], [-122.75565, 38.15049], [-122.7556, 38.14959], [-122.75411, 38.14889], [-122.75474, 38.14841], [-122.75507, 38.14685], [-122.75424, 38.14606], [-122.75313, 38.14653], [-122.75161, 38.14691], [-122.7512, 38.14748], [-122.75051, 38.14696], [-122.74972, 38.14681], [-122.74819, 38.14723], [-122.74762, 38.14762], [-122.74711, 38.1476], [-122.74684, 38.14796], [-122.74682, 38.14866], [-122.74625, 38.1487], [-122.74592, 38.14824], [-122.74419, 38.1488], [-122.74351, 38.14865], [-122.74323, 38.14849], [-122.74281, 38.14791], [-122.74202, 38.14803], [-122.74102, 38.14912], [-122.7384, 38.14931], [-122.73811, 38.15104], [-122.73794, 38.15111], [-122.73796, 38.14979], [-122.73555, 38.15022], [-122.73509, 38.15025], [-122.73433, 38.15109], [-122.73411, 38.1512], [-122.73429, 38.15146], [-122.73399, 38.1516], [-122.73376, 38.15136], [-122.73341, 38.15156], [-122.73313, 38.15129], [-122.73381, 38.15085], [-122.73425, 38.15027], [-122.7335, 38.15014], [-122.73318, 38.14916], [-122.73259, 38.14916], [-122.73203, 38.14886], [-122.73197, 38.14819], [-122.73147, 38.14739], [-122.73073, 38.14681], [-122.73027, 38.14513], [-122.73037, 38.1446], [-122.72991, 38.1442], [-122.73011, 38.14373], [-122.73057, 38.14366], [-122.73083, 38.14307], [-122.73073, 38.14273], [-122.73056, 38.14258], [-122.72999, 38.14211], [-122.7301, 38.14181], [-122.73076, 38.14177], [-122.73091, 38.14199], [-122.73142, 38.14249], [-122.73175, 38.14273], [-122.73174, 38.14297], [-122.73128, 38.14455], [-122.73137, 38.14539], [-122.7313, 38.1455], [-122.73181, 38.1461], [-122.73165, 38.14648], [-122.73291, 38.14851], [-122.73335, 38.14847], [-122.73351, 38.14862], [-122.73379, 38.14848], [-122.73412, 38.14855], [-122.73435, 38.14911], [-122.73798, 38.14788], [-122.73846, 38.14765], [-122.73848, 38.14726], [-122.73924, 38.14728], [-122.74059, 38.14676], [-122.74046, 38.14537], [-122.74123, 38.14502], [-122.74118, 38.14485], [-122.74143, 38.14483], [-122.74169, 38.14512], [-122.74457, 38.14689], [-122.74746, 38.14486], [-122.74987, 38.14448], [-122.75039, 38.14502], [-122.75168, 38.1446], [-122.75326, 38.14163], [-122.75352, 38.14128], [-122.75355, 38.14183], [-122.75403, 38.14157], [-122.75449, 38.14023], [-122.75534, 38.14016], [-122.75575, 38.14008], [-122.75609, 38.13982], [-122.75567, 38.1397], [-122.75579, 38.13945], [-122.75632, 38.13952], [-122.75654, 38.13934], [-122.75727, 38.13813], [-122.75784, 38.13802], [-122.75741, 38.13881], [-122.75787, 38.13889], [-122.75813, 38.13888], [-122.75831, 38.13898], [-122.7582, 38.13914], [-122.75795, 38.13916], [-122.75762, 38.13911], [-122.75728, 38.1392], [-122.75715, 38.13914], [-122.75681, 38.1396], [-122.75736, 38.14026], [-122.75706, 38.14071], [-122.75684, 38.14077], [-122.75608, 38.14185], [-122.75609, 38.14186], [-122.75662, 38.14163], [-122.75615, 38.14271], [-122.75491, 38.14365], [-122.75472, 38.14428], [-122.75575, 38.14501], [-122.75628, 38.14561], [-122.75626, 38.14563], [-122.75696, 38.14639], [-122.75657, 38.14765], [-122.75677, 38.14816], [-122.75719, 38.14855], [-122.75771, 38.14863], [-122.75843, 38.14887], [-122.75907, 38.14905], [-122.75968, 38.14901], [-122.76026, 38.14934], [-122.7612, 38.14983], [-122.76301, 38.14741], [-122.7634, 38.14809], [-122.7701, 38.14778], [-122.77216, 38.1446], [-122.77215, 38.14459], [-122.77017, 38.14509], [-122.7693, 38.14395], [-122.77029, 38.14302], [-122.77004, 38.14252], [-122.77065, 38.14226], [-122.77126, 38.14002], [-122.7731, 38.14049], [-122.77409, 38.14088], [-122.77528, 38.14103], [-122.77666, 38.14093], [-122.77775, 38.1416], [-122.77926, 38.14167], [-122.77991, 38.14179], [-122.78094, 38.14254], [-122.78284, 38.14233], [-122.78284, 38.14232], [-122.7823, 38.14167], [-122.78366, 38.1408], [-122.78398, 38.14006], [-122.78509, 38.13913], [-122.78592, 38.13892], [-122.78659, 38.13881], [-122.78774, 38.13756], [-122.78913, 38.13593], [-122.79004, 38.13585], [-122.79046, 38.13645], [-122.79031, 38.13664], [-122.79031, 38.13708], [-122.79011, 38.13753], [-122.78939, 38.13848], [-122.78891, 38.13924], [-122.78873, 38.13982], [-122.78956, 38.13972], [-122.7935, 38.14018], [-122.79483, 38.13954], [-122.79557, 38.14012], [-122.79539, 38.14068], [-122.79576, 38.1413]]]} | Open Access 1 | 1015 | Soulajule Reservoir | 6344 | 2071 | Marin Municipal Water District 254 | Special District 4 | Water District 13 | http://www.marinwater.org/ | Special District 4 | 2071 | Marin Municipal Water District 250 | Special District 4 | Water District 13 | http://www.marinwater.org/190/Fishing | Marin 23 | 1095.86 | Soulajule Reservoir | 1979 | 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]);