units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

3 rows where DES_TP = 3, LAYER = 4 and MNG_AGENCY = 250

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Marin Municipal Water District · 3 ✖

DES_TP 1

  • Local Recreation Area · 3 ✖

ACCESS_TYP 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
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
7391 7391 7390 {"type": "Polygon", "coordinates": [[[-122.58663, 38.10653], [-122.58616, 38.10726], [-122.58423, 38.10642], [-122.58469, 38.10574], [-122.58663, 38.10653]]]} Open Access 1 6798 L U Sutton Recreation Area 20738 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   Marin 23 4.202 L U Sutton Rec. Area 2000 Local Recreation Area 3 4
10335 10335 10334 {"type": "Polygon", "coordinates": [[[-122.75989, 38.09427], [-122.75979, 38.09527], [-122.75803, 38.09619], [-122.75721, 38.09696], [-122.75704, 38.09884], [-122.75737, 38.09968], [-122.75871, 38.10096], [-122.75847, 38.10114], [-122.75748, 38.10047], [-122.75716, 38.10107], [-122.75695, 38.10094], [-122.75735, 38.10015], [-122.75654, 38.09908], [-122.75427, 38.09953], [-122.75371, 38.09986], [-122.75313, 38.09985], [-122.75308, 38.10139], [-122.75325, 38.10159], [-122.75298, 38.10167], [-122.75256, 38.10049], [-122.75225, 38.10065], [-122.75214, 38.10048], [-122.7525, 38.09986], [-122.7525, 38.09985], [-122.75213, 38.09983], [-122.75227, 38.09906], [-122.75123, 38.09858], [-122.7507, 38.09853], [-122.75093, 38.09777], [-122.75112, 38.09769], [-122.75186, 38.09802], [-122.75238, 38.09793], [-122.75222, 38.09736], [-122.7508, 38.09696], [-122.75049, 38.09612], [-122.75076, 38.09557], [-122.75025, 38.09525], [-122.75006, 38.09573], [-122.74922, 38.09612], [-122.74756, 38.09634], [-122.74674, 38.09501], [-122.74622, 38.09411], [-122.74552, 38.09397], [-122.74509, 38.09406], [-122.74432, 38.09432], [-122.74392, 38.09483], [-122.74365, 38.09486], [-122.74363, 38.09444], [-122.7432, 38.09396], [-122.74274, 38.09311], [-122.74168, 38.0927], [-122.74114, 38.09267], [-122.74066, 38.09254], [-122.7388, 38.09238], [-122.7384, 38.09243], [-122.73795, 38.09252], [-122.73776, 38.09258], [-122.73729, 38.09276], [-122.73691, 38.09296], [-122.7366, 38.09317], [-122.73633, 38.09339], [-122.73612, 38.09359], [-122.73591, 38.09386], [-122.73579, 38.09404], [-122.73542, 38.0947], [-122.7357, 38.09482], [-122.73493, 38.09635], [-122.73515, 38.09705], [-122.73664, 38.09759], [-122.73676, 38.09787], [-122.73576, 38.09765], [-122.73505, 38.09796], [-122.73508, 38.09817], [-122.73571, 38.09841], [-122.73604, 38.09898], [-122.73724, 38.09912], [-122.73744, 38.09964], [-122.73699, 38.09974], [-122.73704, 38.09931], [-122.73648, 38.09937], [-122.73574, 38.09922], [-122.73548, 38.099], [-122.73529, 38.09876], [-122.73518, 38.09942], [-122.73553, 38.10016], [-122.73531, 38.10018], [-122.73471, 38.10003], [-122.73486, 38.09948], [-122.73489, 38.09904], [-122.73435, 38.09819], [-122.73336, 38.09753], [-122.73377, 38.09719], [-122.7341, 38.09685], [-122.73445, 38.09641], [-122.73455, 38.09625], [-122.73434, 38.09543], [-122.7341, 38.0958], [-122.73431, 38.09587], [-122.73425, 38.09596], [-122.73412, 38.09606], [-122.73387, 38.09617], [-122.7337, 38.0962], [-122.73353, 38.09621], [-122.73331, 38.09616], [-122.73316, 38.09611], [-122.733, 38.096], [-122.73286, 38.09583], [-122.73231, 38.09598], [-122.7328, 38.09716], [-122.7328, 38.09733], [-122.73279, 38.09739], [-122.73271, 38.09755], [-122.73197, 38.09795], [-122.73152, 38.09852], [-122.73134, 38.09893], [-122.73103, 38.09831], [-122.73209, 38.09744], [-122.73046, 38.09481], [-122.73125, 38.09421], [-122.73103, 38.09357], [-122.73185, 38.09331], [-122.73134, 38.09206], [-122.73113, 38.09163], [-122.73077, 38.09108], [-122.73056, 38.09081], [-122.73033, 38.09056], [-122.72993, 38.09016], [-122.72948, 38.08978], [-122.72898, 38.08944], [-122.72856, 38.08919], [-122.72813, 38.08897], [-122.72778, 38.08882], [-122.72516, 38.08776], [-122.72505, 38.08768], [-122.72481, 38.08756], [-122.72436, 38.0873], [-122.72383, 38.08694], [-122.72354, 38.08719], [-122.72341, 38.08709], [-122.72194, 38.08862], [-122.72049, 38.08814], [-122.72003, 38.08635], [-122.72224, 38.08527], [-122.72101, 38.08334], [-122.72137, 38.08294], [-122.72331, 38.08388], [-122.72331, 38.08452], [-122.7237, 38.08507], [-122.72428, 38.08541], [-122.72491, 38.08563], [-122.72578, 38.0853], [-122.7301, 38.08626], [-122.73176, 38.08483], [-122.73246, 38.08212], [-122.73, 38.07966], [-122.72888, 38.07799], [-122.72852, 38.07809], [-122.72783, 38.07758], [-122.727, 38.07745], [-122.72665, 38.07814], [-122.72629, 38.07813], [-122.72415, 38.07613], [-122.72438, 38.07437], [-122.72255, 38.07411], [-122.72221, 38.07447], [-122.7172, 38.07005], [-122.71325, 38.07367], [-122.71091, 38.07594], [-122.70832, 38.07712], [-122.70802, 38.07678], [-122.70785, 38.07655], [-122.70735, 38.07576], [-122.70702, 38.0752], [-122.70675, 38.07391], [-122.70728, 38.07284], [-122.70698, 38.0724], [-122.70657, 38.07233], [-122.70559, 38.07262], [-122.70477, 38.071], [-122.70475, 38.07088], [-122.70546, 38.07065], [-122.70448, 38.0688], [-122.70454, 38.06799], [-122.70425, 38.06742], [-122.70437, 38.06667], [-122.70436, 38.06647], [-122.70414, 38.06632], [-122.70326, 38.06609], [-122.703, 38.06601], [-122.70283, 38.06575], [-122.70249, 38.06539], [-122.70244, 38.06506], [-122.70203, 38.0649], [-122.70171, 38.06452], [-122.70143, 38.06432], [-122.70069, 38.06347], [-122.70122, 38.06346], [-122.70129, 38.06358], [-122.70228, 38.0636], [-122.70334, 38.06579], [-122.70473, 38.06633], [-122.7047, 38.06726], [-122.70518, 38.06822], [-122.70665, 38.06942], [-122.71019, 38.07072], [-122.7118, 38.07008], [-122.71558, 38.06819], [-122.71417, 38.06652], [-122.71459, 38.06486], [-122.71552, 38.0643], [-122.71734, 38.06738], [-122.72045, 38.06549], [-122.72337, 38.06771], [-122.7235, 38.06797], [-122.72395, 38.06835], [-122.72475, 38.06855], [-122.72503, 38.06879], [-122.72611, 38.06849], [-122.72626, 38.06842], [-122.72625, 38.06831], [-122.72829, 38.06753], [-122.72861, 38.06782], [-122.72702, 38.06997], [-122.72842, 38.07141], [-122.72777, 38.07225], [-122.72883, 38.074], [-122.72945, 38.07538], [-122.7315, 38.07633], [-122.73178, 38.07573], [-122.73472, 38.07613], [-122.73543, 38.07441], [-122.73712, 38.07479], [-122.73824, 38.07316], [-122.73876, 38.0739], [-122.73886, 38.07432], [-122.73884, 38.07519], [-122.73898, 38.07547], [-122.73937, 38.07574], [-122.74128, 38.0763], [-122.74357, 38.07706], [-122.7449, 38.0767], [-122.74659, 38.07705], [-122.74715, 38.07636], [-122.7485, 38.0765], [-122.74862, 38.07644], [-122.74873, 38.07661], [-122.74953, 38.07647], [-122.74949, 38.0758], [-122.75077, 38.07619], [-122.75294, 38.07393], [-122.75563, 38.07411], [-122.75585, 38.07436], [-122.75607, 38.07397], [-122.75647, 38.07397], [-122.7568, 38.07315], [-122.75728, 38.07286], [-122.75691, 38.07364], [-122.75671, 38.07416], [-122.75653, 38.07499], [-122.75639, 38.07527], [-122.75659, 38.07538], [-122.75632, 38.07597], [-122.75606, 38.07592], [-122.75581, 38.07625], [-122.75593, 38.07646], [-122.75548, 38.07683], [-122.75526, 38.07705], [-122.75505, 38.07729], [-122.75487, 38.07755], [-122.75463, 38.07749], [-122.75461, 38.07751], [-122.75428, 38.07744], [-122.75405, 38.07785], [-122.75394, 38.0781], [-122.75377, 38.0786], [-122.75352, 38.08007], [-122.7533, 38.08006], [-122.75323, 38.08044], [-122.7532, 38.08073], [-122.75309, 38.08125], [-122.75292, 38.08175], [-122.75255, 38.08267], [-122.75284, 38.08279], [-122.75256, 38.08404], [-122.75448, 38.085], [-122.7544, 38.08544], [-122.75469, 38.08591], [-122.75284, 38.08615], [-122.75283, 38.08616], [-122.75286, 38.08628], [-122.75549, 38.08768], [-122.75571, 38.08825], [-122.75571, 38.08835], [-122.75564, 38.08856], [-122.75383, 38.08895], [-122.75385, 38.08915], [-122.75385, 38.08937], [-122.75377, 38.08982], [-122.75363, 38.09019], [-122.75343, 38.09052], [-122.75521, 38.09265], [-122.75547, 38.09403], [-122.75989, 38.09427]]]} Open Access 1 18202 Nicasio Reservoir 6342 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   Marin 23 1604.995 Nicasio Reservoir 1960 Local Recreation Area 3 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);